| filing_id | 1859924 | 1867107 | 1905918 | 1905918 | 1867107 | 1859924 | 1859924 | 1928021 | 1960236 | 1972883 | 1990925 | 1972883 | 1960236 | 2003807 | 2088316 | 2035252 | 2057301 | 2161088 | 2167316 | 2131794 | 2186397 | 2233844 | 2302315 | 2268859 | 2205160 | 2388106 | 2334045 | 2386256 | 2428187 | 2465730 | 2411906 | 2477064 | 2542703 | 2574615 | 2477064 | 2465730 | 2509500 | 2574615 | 2619068 | 2619065 | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 2 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||
| form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||
| sender_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | ||||||||||||||||||||||||||||||||||||||||
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | ||||||||||||||||||||||||||||||||||||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||||||||||||||||||||||||||
| filer_naml | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | ||||||||||||||||||||||||||||||||||||||||
| filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| report_num | 002 | 001 | 000 | 001 | 000 | 000 | 001 | 000 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 001 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-10-27 00:00:00 | 2014-10-27 00:00:00 | 2014-07-28 00:00:00 | 2014-06-20 00:00:00 | 2014-07-01 00:00:00 | 2015-01-22 00:00:00 | 2015-09-11 00:00:00 | 2015-09-11 00:00:00 | 2015-10-07 00:00:00 | 2015-07-03 00:00:00 | 2015-04-22 00:00:00 | 2016-01-14 00:00:00 | 2016-10-13 00:00:00 | 2016-04-29 00:00:00 | 2016-07-22 00:00:00 | 2017-05-18 00:00:00 | 2017-07-14 00:00:00 | 2017-02-01 00:00:00 | 2017-10-04 00:00:00 | 2018-04-23 00:00:00 | 2018-10-05 00:00:00 | 2018-07-25 00:00:00 | 2018-01-25 00:00:00 | 2019-07-01 00:00:00 | 2019-01-14 00:00:00 | 2019-06-11 00:00:00 | 2020-01-06 00:00:00 | 2020-04-15 00:00:00 | 2019-10-08 00:00:00 | 2020-07-07 00:00:00 | 2021-01-07 00:00:00 | 2021-04-16 00:00:00 | 2020-07-22 00:00:00 | 2020-07-22 00:00:00 | 2020-10-05 00:00:00 | 2021-06-22 00:00:00 | 2021-10-26 00:00:00 | 2021-10-26 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
| from_date | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
| thru_date | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2014-09-30 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 3015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
| cum_beg_dt | 2014-02-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-02-01 00:00:00 | 2014-01-02 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-02 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
| firm_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| firm_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| firm_city | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | ||||||||||||||||||||||||||||||||||||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||
| firm_zip4 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | ||||||||||||||||||||||||||||||||||||||||
| firm_phon | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | ||||||||||||||||||||||||||||||||||||||||
| mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| sig_date | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-10-27 00:00:00 | 2014-07-29 00:00:00 | 2014-06-20 00:00:00 | 2014-07-01 00:00:00 | 2015-01-22 00:00:00 | 2015-09-11 00:00:00 | 2015-09-11 00:00:00 | 2015-10-06 00:00:00 | 2015-07-03 00:00:00 | 2015-04-22 00:00:00 | 2015-01-14 00:00:00 | 2016-10-13 00:00:00 | 2016-04-29 00:00:00 | 2016-07-22 00:00:00 | 2017-05-18 00:00:00 | 2017-07-14 00:00:00 | 2017-02-01 00:00:00 | 2017-10-04 00:00:00 | 2018-04-23 00:00:00 | 2018-10-05 00:00:00 | 2018-07-25 00:00:00 | 2018-01-25 00:00:00 | 2019-07-01 00:00:00 | 2019-01-14 00:00:00 | 2019-06-11 00:00:00 | 2019-01-06 00:00:00 | 2020-04-15 00:00:00 | 2019-10-08 00:00:00 | 2020-07-07 00:00:00 | 2020-07-01 00:00:00 | 2021-04-16 00:00:00 | 2020-07-22 00:00:00 | 2020-07-22 00:00:00 | 2020-10-05 00:00:00 | 2021-06-22 00:00:00 | 2021-10-26 00:00:00 | 2021-10-26 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
| sig_loc | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh | EDINBURGH | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh | Edinburgh | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh, UK | Edinburgh | Edinburgh, UK | Edinburgh | Edinburgh, UK | Edinburgh, UK | Edinburgh | Edinburgh, UK | Edinburgh, UK | Edinburgh | Edinburgh | Edinburgh, UK | Edinburgh, UK | Edinburgh | Edinburgh, UK | Edinburgh | Edinburgh, UK | Edinburgh | Edinburgh | Edinburgh | Edinburgh, UK | Edinburgh | Edinburgh | Edinburgh | ||||||||||||||||||||||||||||||||||||||||
| sig_naml | Greig | Greig | Alexander | Nairn | GREIG | Greig | Greig | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | ||||||||||||||||||||||||||||||||||||||||
| sig_namf | Kenneth | Kenneth | Nairn | Alasdair | KENNETH | Kenneth | Kenneth | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | ||||||||||||||||||||||||||||||||||||||||
| sig_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| prn_naml | Greig | Greig | Alexander | Nairn | GREIG | Greig | Greig | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | Nairn | ||||||||||||||||||||||||||||||||||||||||
| prn_namf | Kenneth | Kenneth | Nairn | Alasdair | KENNETH | Kenneth | Kenneth | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | Alasdair | ||||||||||||||||||||||||||||||||||||||||
| prn_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| sig_title | President | President | President | President | PRESIDENT/DIRECTOR | Director/President | Director/President | President | President | President | President | President | President | President | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | Director | President | Director | Director | Director | ||||||||||||||||||||||||||||||||||||||||
| nopart1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| ctrib_n_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||
| ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| lby_actvty | None. | CALSTRS | CALSTRS | None | CALSTRS | None | None. | CALSTRS | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| major_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| major_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||
| rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
| filing_id | 1849642 | 1915111 | 2107819 | 2535469 | 2611339 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | |||||
| rec_type | CVR | CVR | CVR | CVR | CVR | |||||
| form_type | F603 | F603 | F603 | F603 | F606 | |||||
| sender_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | |||||
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | |||||
| entity_cd | LEM | LEM | LEM | LEM | LBY | |||||
| filer_naml | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | |||||
| filer_namf | None | None | None | None | None | |||||
| filer_namt | None | None | None | None | None | |||||
| filer_nams | None | None | None | None | None | |||||
| report_num | 000 | 000 | 000 | 000 | 000 | |||||
| rpt_date | 2014-05-14 00:00:00 | 2014-11-17 00:00:00 | 2016-11-21 00:00:00 | 2020-11-20 00:00:00 | 2021-09-14 00:00:00 | |||||
| ls_beg_yr | 2013 | 2015 | 2017 | 2021 | 2021 | |||||
| ls_end_yr | 2014 | 2016 | 2018 | 2022 | 2022 | |||||
| qual_date | 2014-01-02 00:00:00 | None | None | None | None | |||||
| eff_date | None | None | None | None | 2021-09-29 00:00:00 | |||||
| bus_city | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | |||||
| bus_st | CA | CA | CA | CA | CA | |||||
| bus_zip4 | 94597 | 94597 | 94597 | 94597 | 94597 | |||||
| bus_phon | 9254726744 | 9254726744 | 9254726744 | 9254726744 | None | |||||
| bus_fax | None | None | None | 9254726746 | None | |||||
| bus_email | kgreig@edpam.com | TDICKSON@EDPAM.COM | SNAIRN@EDPAM.COM | TDICKSON@EDPAM.COM | None | |||||
| mail_city | None | None | None | None | None | |||||
| mail_st | None | None | None | None | None | |||||
| mail_zip4 | None | None | None | None | None | |||||
| mail_phon | None | None | None | None | None | |||||
| sig_date | 2014-05-14 00:00:00 | 2014-11-17 00:00:00 | 2016-11-21 00:00:00 | 2020-11-18 00:00:00 | 2021-09-14 00:00:00 | |||||
| sig_loc | None | None | None | None | None | |||||
| sig_naml | BLEAKNEY | Nairn | Nairn | Dickson | Dickson | |||||
| sig_namf | SAM | Alasdair | Alasdair | Thomas | Thomas | |||||
| sig_namt | None | None | None | None | None | |||||
| sig_nams | None | None | None | None | None | |||||
| prn_naml | BLEAKNEY | Nairn | Nairn | Dickson | Dickson | |||||
| prn_namf | SAM | Alasdair | Alasdair | Thomas | Thomas | |||||
| prn_namt | None | None | None | None | None | |||||
| prn_nams | None | None | None | None | None | |||||
| sig_title | TREASUER | President | Director | Director | Director | |||||
| stmt_firm | None | None | None | None | None | |||||
| ind_cb | None | None | None | None | None | |||||
| bus_cb | X | X | X | X | None | |||||
| trade_cb | None | None | None | None | None | |||||
| oth_cb | None | None | None | None | None | |||||
| a_b_name | None | None | None | None | None | |||||
| a_b_city | None | None | None | None | None | |||||
| a_b_st | None | None | None | None | None | |||||
| a_b_zip4 | None | None | None | None | None | |||||
| descrip_1 | None | None | None | None | None | |||||
| descrip_2 | INVESTMENT MANAGEMENT | Investment Management | Investment Management | Investment Management | None | |||||
| c_less50 | None | None | None | None | None | |||||
| c_more50 | None | None | None | None | None | |||||
| ind_class | OTH | None | None | None | None | |||||
| ind_descr | FINANCIAL | None | None | None | None | |||||
| bus_class | None | FIN | FIN | FIN | None | |||||
| bus_descr | None | None | None | None | None | |||||
| auth_name | None | None | None | None | None | |||||
| auth_city | None | None | None | None | None | |||||
| auth_st | None | None | None | None | None | |||||
| auth_zip4 | None | None | None | None | None | |||||
| lobby_int | None | None | None | None | None | |||||
| influen_yn | None | None | None | None | None | |||||
| firm_name | None | None | None | None | None | |||||
| newcert_cb | None | None | None | None | None | |||||
| rencert_cb | None | None | None | None | None | |||||
| complet_dt | None | None | None | None | None | |||||
| lby_reg_cb | None | None | None | None | None | |||||
| lby_604_cb | None | None | None | None | None | |||||
| st_leg_yn | None | None | None | None | None | |||||
| st_agency | None | None | None | None | None | |||||
| lobby_cb | None | None | None | None | None | |||||
| l_firm_cb | None | None | None | None | None |
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2466319 | 2413147 | 2508044 | 2315530 | 2341054 | |||||
| effect_dt | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2014-01-02 00:00:00 | 2015-01-01 00:00:00 | |||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
| session_id | 2019 | 2017 | 2021 | 2013 | 2015 |
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1859924 | 1859924 | 1867107 | 1928021 | 1960236 | 1922297 | 1905918 | 1905918 | 1859924 | 1867107 | 1915111 | 1849538 | 1849642 | 1990925 | 1960236 | 2003807 | 1972883 | 1972883 | 2411906 | 2233844 | 2186397 | 2302315 | 2388106 | 2268859 | 2035252 | 2057301 | 2088316 | 2110525 | 2107819 | 2131794 | 2161088 | 2167316 | 2334045 | 2205160 | 2428187 | 2477064 | 2386256 | 2509500 | 2329039 | 2465730 | 2619065 | 2542703 | 2477064 | 2631727 | 2574615 | 2574615 | 2611339 | 2465730 | 2619068 | 2535469 | 2538064 | 2629989 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 217 | 217 | 218 | 220 | 221 | None | 219 | 219 | 217 | 218 | 220 | None | 218 | 223 | 221 | 224 | 222 | 222 | 239 | 233 | 231 | 235 | 238 | 234 | 225 | 226 | 227 | None | 228 | 228 | 229 | 230 | 236 | 232 | 240 | 242 | 237 | 243 | None | 241 | 247 | 244 | 242 | None | 245 | 245 | 247 | 241 | 246 | 244 | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F603 | F603 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F606 | F635 | F635 | F603 | F603 | F605 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2014-07-01 00:00:00 | 2014-06-20 00:00:00 | 2014-07-28 00:00:00 | 2015-01-22 00:00:00 | 2015-04-22 00:00:00 | 2014-11-20 00:00:00 | 2014-10-27 00:00:00 | 2014-10-27 00:00:00 | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-11-17 00:00:00 | 2014-05-12 00:00:00 | 2014-05-14 00:00:00 | 2015-10-07 00:00:00 | 2015-09-11 00:00:00 | 2016-01-14 00:00:00 | 2015-07-03 00:00:00 | 2015-09-11 00:00:00 | 2019-10-08 00:00:00 | 2018-04-23 00:00:00 | 2017-10-04 00:00:00 | 2018-10-05 00:00:00 | 2019-07-01 00:00:00 | 2018-07-25 00:00:00 | 2016-04-29 00:00:00 | 2016-07-22 00:00:00 | 2016-10-13 00:00:00 | 2016-11-28 00:00:00 | 2016-11-21 00:00:00 | 2017-02-01 00:00:00 | 2017-05-18 00:00:00 | 2017-07-14 00:00:00 | 2019-01-14 00:00:00 | 2018-01-25 00:00:00 | 2020-01-06 00:00:00 | 2020-07-22 00:00:00 | 2019-06-11 00:00:00 | 2020-10-05 00:00:00 | 2018-12-12 00:00:00 | 2020-04-15 00:00:00 | 2021-10-26 00:00:00 | 2021-01-07 00:00:00 | 2020-07-07 00:00:00 | 2021-12-17 00:00:00 | 2021-04-16 00:00:00 | 2021-06-22 00:00:00 | 2021-09-14 00:00:00 | 2020-07-22 00:00:00 | 2021-10-26 00:00:00 | 2020-11-20 00:00:00 | 2020-11-23 00:00:00 | 2021-11-05 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10005 | 10002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | RGEREMIA | RGEREMIA | AGLADNEY | MPACHECO | MPACHECO | GKURIMOT | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | CAFILER | YRODRIGU | YRODRIGU | JINGRAM | AGLADNEY | AGLADNEY | MPACHECO | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | KBANH | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | GTAYLOR | KBANH | GTAYLOR | SARRIAGA | GTAYLOR | LPHEAV | GTAYLOR | GTAYLOR | JMENDOZA | GTAYLOR | CAFILER | CAFILER | GTAYLOR | LPHEAV | AROJAS | AROJAS | JMENDOZA | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-11-17 00:00:00 | 1900-01-01 00:00:00 | 2014-05-14 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2019-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-11-21 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-10-01 00:00:00 | 2017-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-09-14 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-11-20 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2014-03-31 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2014-09-30 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2014-11-17 00:00:00 | 1900-01-01 00:00:00 | 2014-05-14 00:00:00 | 3015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-06-30 00:00:00 | 2019-09-30 00:00:00 | 2018-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-11-21 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-12-31 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2021-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-09-14 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2020-11-20 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None |
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2015 | 2017 | 2019 | 2013 | 2021 | |||||
| interest_cd | 40304 | 40304 | 40304 | 40304 | 40304 | |||||
| effect_date | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2014-01-02 00:00:00 | 2021-01-01 00:00:00 |
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 2 | 2 | 2 | 2 | 2 | 2 | ||||||
| active | Y | Y | Y | Y | Y | T | ||||||
| race | 0 | None | None | None | None | None | ||||||
| session_id | 2013 | 2021 | 2015 | 2019 | 2017 | 2021 | ||||||
| category | 0 | None | None | None | None | None | ||||||
| category_type | 0 | None | None | None | None | None | ||||||
| sub_category | 0 | None | None | None | None | None | ||||||
| effect_dt | 2014-01-02 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-09-29 00:00:00 | ||||||
| sub_category_type | 0 | None | None | None | None | None | ||||||
| election_type | 0 | None | None | None | None | None | ||||||
| sub_category_a | None | None | None | None | None | None | ||||||
| nyq_dt | None | None | None | None | None | None | ||||||
| party_cd | 0 | None | None | None | None | None | ||||||
| county_cd | 0 | None | None | None | None | None | ||||||
| district_cd | 0 | None | None | None | None | None |
| filer_id | 1366645 | |
|---|---|---|
| xref_id | 1366645 | |
| effect_dt | 2014-05-09 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | 1366645 | |||||||||||||||||||||||||
| filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | |||||||||||||||||||||||||
| status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | |||||||||||||||||||||||||
| effect_dt | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | |||||||||||||||||||||||||
| naml | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA, INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | EDINBURGH PARTNERS NORTH AMERICA INC | |||||||||||||||||||||||||
| namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| city | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | WALNUT CREEK | |||||||||||||||||||||||||
| st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||
| zip4 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | 94597 | |||||||||||||||||||||||||
| phon | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | 9254726744 | |||||||||||||||||||||||||
| fax | None | None | None | 9254726746 | 9254726746 | None | None | None | 9254726746 | 9254726746 | None | None | None | 9254726746 | 9254726746 | None | None | None | 9254726746 | 9254726746 | None | None | None | 9254726746 | 9254726746 | |||||||||||||||||||||||||
| tdickson@edpam.com | snairn@edpam.com | snairn@edpam.com | snairn@edpam.com | tdickson@edpam.com | tdickson@edpam.com | snairn@edpam.com | snairn@edpam.com | snairn@edpam.com | tdickson@edpam.com | tdickson@edpam.com | snairn@edpam.com | snairn@edpam.com | snairn@edpam.com | tdickson@edpam.com | tdickson@edpam.com | snairn@edpam.com | snairn@edpam.com | snairn@edpam.com | tdickson@edpam.com | tdickson@edpam.com | snairn@edpam.com | snairn@edpam.com | snairn@edpam.com | tdickson@edpam.com |
| filer_id | 1366645 |
|---|
| filer_id | 1366645 | 1366645 | ||
|---|---|---|---|---|
| change_no | 0 | 1 | ||
| session_id | 2013 | 2013 | ||
| log_dt | 2014-05-12 00:00:00 | 2014-05-12 00:00:00 | ||
| filer_type | 2 | 2 | ||
| correction_flg | None | None | ||
| action | ADDED | CHANGED | ||
| attribute_changed | LOBBYIST | RESPONSIBLE OFFICER | ||
| ethics_dt | None | None | ||
| interests | None | None | ||
| filer_full_name | EDINBURGH PARTNERS NORTH AMERICA, INC. | EDINBURGH PARTNERS NORTH AMERICA, INC. | ||
| filer_city | None | None | ||
| filer_st | None | None | ||
| filer_zip | None | None | ||
| filer_phone | None | None | ||
| entity_type | 4 | 20 | ||
| entity_name | THOMAS J. DICKSON | TREASURER R. S. BLEAKNEY | ||
| entity_city | None | None | ||
| entity_st | None | None | ||
| entity_zip | None | None | ||
| entity_phone | None | None | ||
| entity_id | 1339292 | 1366752 | ||
| responsible_officer | None | None | ||
| effect_dt | 2014-01-02 00:00:00 | 2014-01-02 00:00:00 |