Filer ID: 1143836
Table: filer_address
| filer_id |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| adrid |
| 1109631 |
| 2504961 |
| 2417503 |
| 2322074 |
| 2341864 |
| 2548388 |
| 2468160 |
| effect_dt |
| 1995-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2014-05-29 00:00:00 |
| 2015-07-13 00:00:00 |
| 2023-01-01 00:00:00 |
| 2019-02-01 00:00:00 |
| add_type |
| 7051 |
| 7051 |
| 7051 |
| 7051 |
| 7051 |
| 7051 |
| 7051 |
| session_id |
| 1995 |
| 2021 |
| 2017 |
| 2013 |
| 2015 |
| 2023 |
| 2019 |
|
Table: filer_filings
| filer_id |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| filing_id |
| 470254 |
| 463033 |
| 475763 |
| 465059 |
| 465059 |
| 1974267 |
| 1974857 |
| 1862541 |
| 1908353 |
| 1927110 |
| 1886170 |
| 1881798 |
| 1996937 |
| 2392278 |
| 2264044 |
| 2415466 |
| 2378798 |
| 2525365 |
| 2006648 |
| 2030283 |
| 2055233 |
| 2102007 |
| 2124589 |
| 2120209 |
| 2115374 |
| 2151164 |
| 2171641 |
| 2204698 |
| 2358219 |
| 2483671 |
| 2392278 |
| 2232289 |
| 2467972 |
| 2437276 |
| 2562393 |
| 2371707 |
| 2190091 |
| 2336595 |
| 2336590 |
| 2371707 |
| 2605161 |
| 2636260 |
| 2525365 |
| 2698118 |
| 2546672 |
| 2671164 |
| 2618452 |
| 2595809 |
| 2576123 |
| 2576123 |
| 2546672 |
| 2595809 |
| 2618452 |
| 2725831 |
| period_id |
| 142 |
| 141 |
| 143 |
| 141 |
| 141 |
| 223 |
| None |
| None |
| 219 |
| 220 |
| None |
| 218 |
| 223 |
| 238 |
| 234 |
| 239 |
| None |
| 243 |
| 224 |
| 225 |
| 226 |
| 227 |
| None |
| 228 |
| 228 |
| 229 |
| 230 |
| 232 |
| 236 |
| 242 |
| 238 |
| 233 |
| 241 |
| 240 |
| 244 |
| 237 |
| 231 |
| 236 |
| 235 |
| 237 |
| None |
| 248 |
| 243 |
| 250 |
| 244 |
| 249 |
| 247 |
| 246 |
| 245 |
| 245 |
| 244 |
| 246 |
| 247 |
| 251 |
| form_id |
| F635 |
| F606 |
| F635 |
| F690 |
| F635 |
| F602 |
| F602 |
| F602 |
| F635 |
| F635 |
| F602 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F602 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F602 |
| F635 |
| F602 |
| F635 |
| F635 |
| F635 |
| F602 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F602 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F602 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| F635 |
| filing_sequence |
| 0 |
| 0 |
| 0 |
| 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 |
| 0 |
| 0 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 0 |
| 0 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 0 |
| 1 |
| 1 |
| 0 |
| 1 |
| 0 |
| filing_date |
| 1995-08-08 00:00:00 |
| 1995-09-30 00:00:00 |
| 1995-10-31 00:00:00 |
| 1995-05-15 00:00:00 |
| 1995-05-15 00:00:00 |
| 2015-07-14 00:00:00 |
| 2015-07-14 00:00:00 |
| 2014-06-19 00:00:00 |
| 2014-10-29 00:00:00 |
| 2015-01-20 00:00:00 |
| 2014-09-17 00:00:00 |
| 2014-09-02 00:00:00 |
| 2015-10-30 00:00:00 |
| 2019-07-23 00:00:00 |
| 2018-07-12 00:00:00 |
| 2019-10-25 00:00:00 |
| 2019-02-12 00:00:00 |
| 2020-10-28 00:00:00 |
| 2016-01-26 00:00:00 |
| 2016-04-20 00:00:00 |
| 2016-07-14 00:00:00 |
| 2016-10-31 00:00:00 |
| 2016-12-29 00:00:00 |
| 2017-01-17 00:00:00 |
| 2016-12-29 00:00:00 |
| 2017-04-13 00:00:00 |
| 2017-07-26 00:00:00 |
| 2018-01-24 00:00:00 |
| 2019-02-12 00:00:00 |
| 2020-07-30 00:00:00 |
| 2019-07-30 00:00:00 |
| 2018-04-18 00:00:00 |
| 2020-04-27 00:00:00 |
| 2020-01-28 00:00:00 |
| 2021-03-03 00:00:00 |
| 2019-04-10 00:00:00 |
| 2017-10-24 00:00:00 |
| 2019-01-21 00:00:00 |
| 2019-01-21 00:00:00 |
| 2019-07-30 00:00:00 |
| 2021-03-04 00:00:00 |
| 2022-01-21 00:00:00 |
| 2022-01-21 00:00:00 |
| 2022-07-14 00:00:00 |
| 2021-01-25 00:00:00 |
| 2022-04-27 00:00:00 |
| 2021-10-23 00:00:00 |
| 2022-03-22 00:00:00 |
| 2021-04-22 00:00:00 |
| 2022-03-10 00:00:00 |
| 2022-01-21 00:00:00 |
| 2021-07-22 00:00:00 |
| 2022-05-31 00:00:00 |
| 2022-09-29 00:00:00 |
| stmnt_type |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10005 |
| 10005 |
| 10001 |
| 10001 |
| 10005 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10005 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10005 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10002 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10002 |
| 10005 |
| 10001 |
| 10002 |
| 10001 |
| 10001 |
| 10001 |
| 10001 |
| 10002 |
| 10001 |
| 10002 |
| 10002 |
| 10001 |
| 10002 |
| 10001 |
| stmnt_status |
| 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 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11003 |
| 11003 |
| 11001 |
| 11003 |
| 11001 |
| 11003 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11003 |
| 11003 |
| session_id |
| 1995 |
| 1995 |
| 1995 |
| 1995 |
| 1995 |
| 2015 |
| 2015 |
| 2013 |
| 2013 |
| 2013 |
| 2013 |
| 2013 |
| 2015 |
| 2019 |
| 2017 |
| 2019 |
| 2019 |
| 2019 |
| 2015 |
| 2015 |
| 2015 |
| 2015 |
| 2017 |
| 2015 |
| 2017 |
| 2017 |
| 2017 |
| 2017 |
| 2019 |
| 2019 |
| 2019 |
| 2017 |
| 2019 |
| 2019 |
| 2021 |
| 2019 |
| 2017 |
| 2017 |
| 2017 |
| 2019 |
| 2021 |
| 2021 |
| 2019 |
| 2021 |
| 2019 |
| 2021 |
| 2021 |
| 2021 |
| 2021 |
| 2021 |
| 2019 |
| 2021 |
| 2021 |
| 2021 |
| user_id |
| * |
| * |
| * |
| * |
| * |
| YRODRIGU |
| YRODRIGU |
| SARRIAGA |
| AGLADNEY |
| AGLADNEY |
| YRODRIGU |
| RGEREMIA |
| AGLADNEY |
| VUKSTINA |
| AGLADNEY |
| VUKSTINA |
| SARRIAGA |
| GTAYLOR |
| AGLADNEY |
| AGLADNEY |
| AGLADNEY |
| AGLADNEY |
| GPEREZ |
| AGLADNEY |
| CAFILER |
| AGLADNEY |
| AGLADNEY |
| AGLADNEY |
| SARRIAGA |
| GTAYLOR |
| SUSHAKOV |
| AGLADNEY |
| VUKSTINA |
| GTAYLOR |
| MKIRKHAM |
| AGLADNEY |
| AGLADNEY |
| AGLADNEY |
| AGLADNEY |
| GTAYLOR |
| MKIRKHAM |
| CHATRIDGE |
| CAFILER |
| CAFILER |
| GTAYLOR |
| CAFILER |
| CHATRIDGE |
| CAFILER |
| CHATRIDGE |
| GTAYLOR |
| CAFILER |
| GTAYLOR |
| CAFILER |
| CAFILER |
| special_audit |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 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 |
| 11003 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11003 |
| 11001 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11003 |
| 11003 |
| 11001 |
| 11003 |
| 11001 |
| 11003 |
| 11001 |
| 11001 |
| 11003 |
| 11001 |
| 11003 |
| 11003 |
| rpt_start |
| 1995-04-01 00:00:00 |
| 1995-01-01 00:00:00 |
| 1995-07-01 00:00:00 |
| 1995-01-01 00:00:00 |
| 1995-01-01 00:00:00 |
| 2015-07-13 00:00:00 |
| 1900-01-01 00:00:00 |
| 1900-01-01 00:00:00 |
| 2014-07-01 00:00:00 |
| 2014-10-01 00:00:00 |
| 1900-01-01 00:00:00 |
| 2014-05-29 00:00:00 |
| 2015-07-01 00:00:00 |
| 2019-04-01 00:00:00 |
| 2018-04-01 00:00:00 |
| 2019-07-01 00:00:00 |
| 1900-01-01 00:00:00 |
| 2020-07-01 00:00:00 |
| 2015-10-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-10-01 00:00:00 |
| 2016-11-30 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-04-01 00:00:00 |
| 2017-10-01 00:00:00 |
| 2018-11-15 00:00:00 |
| 2020-04-01 00:00:00 |
| 2019-04-01 00:00:00 |
| 2018-01-01 00:00:00 |
| 2020-01-01 00:00:00 |
| 2019-10-01 00:00:00 |
| 2020-12-07 00:00:00 |
| 2019-01-01 00:00:00 |
| 2017-07-01 00:00:00 |
| 2018-10-01 00:00:00 |
| 2018-07-01 00:00:00 |
| 2019-01-01 00:00:00 |
| 1900-01-01 00:00:00 |
| 2021-10-01 00:00:00 |
| 2020-07-01 00:00:00 |
| 2022-04-01 00:00:00 |
| 2020-10-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2021-07-01 00:00:00 |
| 2021-04-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2020-10-01 00:00:00 |
| 2021-04-01 00:00:00 |
| 2021-07-01 00:00:00 |
| 2022-07-01 00:00:00 |
| rpt_end |
| 1995-06-30 00:00:00 |
| 1995-03-31 00:00:00 |
| 1995-09-30 00:00:00 |
| 1995-03-31 00:00:00 |
| 1995-03-31 00:00:00 |
| 2015-07-13 00:00:00 |
| 1900-01-01 00:00:00 |
| 1900-01-01 00:00:00 |
| 2014-09-30 00:00:00 |
| 2014-12-31 00:00:00 |
| 1900-01-01 00:00:00 |
| 2014-06-30 00:00:00 |
| 2015-09-30 00:00:00 |
| 2019-06-30 00:00:00 |
| 2018-06-30 00:00:00 |
| 2019-09-30 00:00:00 |
| 1900-01-01 00:00:00 |
| 2020-09-30 00:00:00 |
| 2015-12-31 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-12-31 00:00:00 |
| 2016-11-30 00:00:00 |
| 2017-03-31 00:00:00 |
| 2017-06-30 00:00:00 |
| 2017-12-31 00:00:00 |
| 2018-11-15 00:00:00 |
| 2020-06-30 00:00:00 |
| 2019-06-30 00:00:00 |
| 2018-03-31 00:00:00 |
| 2020-03-31 00:00:00 |
| 2019-12-31 00:00:00 |
| 2020-12-07 00:00:00 |
| 2019-03-31 00:00:00 |
| 2017-09-30 00:00:00 |
| 2018-12-31 00:00:00 |
| 2018-09-30 00:00:00 |
| 2019-03-31 00:00:00 |
| 1900-01-01 00:00:00 |
| 2021-12-31 00:00:00 |
| 2020-09-30 00:00:00 |
| 2022-06-30 00:00:00 |
| 2020-12-31 00:00:00 |
| 2022-03-31 00:00:00 |
| 2021-09-30 00:00:00 |
| 2021-06-30 00:00:00 |
| 2021-03-31 00:00:00 |
| 2021-03-31 00:00:00 |
| 2020-12-31 00:00:00 |
| 2021-06-30 00:00:00 |
| 2021-09-30 00:00:00 |
| 2022-09-30 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 |
| None |
| None |
| filing_type |
| None |
| None |
| None |
| None |
| None |
| 22001 |
| None |
| None |
| 22006 |
| 22006 |
| None |
| 22006 |
| 22001 |
| 22006 |
| 22006 |
| 22006 |
| None |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| None |
| 22006 |
| 22001 |
| 22006 |
| 22006 |
| 22006 |
| 22001 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22001 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| None |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
| 22006 |
|
Table: filer_interests
| filer_id |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| session_id |
| 1995 |
| 2017 |
| 2019 |
| 2021 |
| 2013 |
| 2015 |
| 2023 |
| interest_cd |
| 40301 |
| 40303 |
| 40303 |
| 40303 |
| 40303 |
| 40303 |
| 40303 |
| effect_date |
| 1995-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2019-02-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2014-05-29 00:00:00 |
| 2015-07-13 00:00:00 |
| 2023-01-01 00:00:00 |
|
Table: filer_to_filer_type
| filer_id |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| filer_type |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| active |
| T |
| T |
| Y |
| Y |
| Y |
| Y |
| Y |
| N |
| race |
| 0 |
| 0 |
| 0 |
| None |
| None |
| None |
| None |
| None |
| session_id |
| 1995 |
| 1995 |
| 2013 |
| 2017 |
| 2021 |
| 2019 |
| 2015 |
| 2023 |
| category |
| 0 |
| 0 |
| 0 |
| None |
| None |
| None |
| None |
| None |
| category_type |
| 0 |
| 0 |
| 0 |
| None |
| None |
| None |
| None |
| None |
| sub_category |
| 0 |
| 0 |
| 0 |
| None |
| None |
| None |
| None |
| None |
| effect_dt |
| 1995-01-01 00:00:00 |
| 1995-09-30 00:00:00 |
| 2014-05-29 00:00:00 |
| 2017-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2019-02-01 00:00:00 |
| 2015-07-13 00:00:00 |
| 2023-01-01 00:00:00 |
| sub_category_type |
| 0 |
| 0 |
| 0 |
| None |
| None |
| None |
| None |
| None |
| election_type |
| 0 |
| 0 |
| 0 |
| None |
| None |
| None |
| None |
| None |
| sub_category_a |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| nyq_dt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| party_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| county_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| district_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_xref
| filer_id |
| 1143836 |
| xref_id |
| C24694 |
| effect_dt |
| 1999-12-08 00:00:00 |
| migration_source |
| MASTER |
|
Table: filername
| xref_filer_id |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| C24694 |
| filer_id |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| filer_type |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| CLIENT |
| status |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| INACTIVE |
| effect_dt |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| 2023-01-01 00:00:00 |
| naml |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| LOS ALAMITOS |
| 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 |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| zip4 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| 90720 |
| phon |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7142361100 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| 7148202648 |
| fax |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| None |
| 7148202641 |
| |
| |
| |
| |
| |
| email |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
| None |
| [email protected] |
| None |
| None |
| None |
| None |
| None |
|
Table: filers
| filer_id |
| 1143836 |
|
Table: lobbying_chg_log
| filer_id |
| 1143836 |
| 1143836 |
| change_no |
| 0 |
| 1 |
| session_id |
| 2013 |
| 2015 |
| log_dt |
| 2014-09-17 00:00:00 |
| 2015-07-14 00:00:00 |
| filer_type |
| 1 |
| 1 |
| correction_flg |
| None |
| Y |
| action |
| ADDED |
| ADDED |
| attribute_changed |
| FIRM |
| FIRM |
| ethics_dt |
| None |
| None |
| interests |
| None |
| None |
| filer_full_name |
| LOS ALAMITOS RACE COURSE |
| LOS ALAMITOS RACE COURSE |
| filer_city |
| None |
| LOS ALAMITOS |
| filer_st |
| None |
| CA |
| filer_zip |
| None |
| 90720 |
| filer_phone |
| None |
| 7148202648 |
| entity_type |
| 3 |
| 3 |
| entity_name |
| CARTER, WETCH & ASSOCIATES |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| entity_city |
| None |
| None |
| entity_st |
| None |
| None |
| entity_zip |
| None |
| None |
| entity_phone |
| None |
| None |
| entity_id |
| 1252406 |
| None |
| responsible_officer |
| None |
| None |
| effect_dt |
| 2014-08-25 00:00:00 |
| 2015-07-13 00:00:00 |
|
Table: received_filings
| filer_id |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| 1143836 |
| filing_file_name |
| 303632.cal |
| 303668.cal |
| 1996937_0.cal |
| 63668.cal |
| 63675.cal |
| received_date |
| 2016-01-27 00:00:00 |
| 2016-01-27 00:00:00 |
| 2015-10-30 00:00:00 |
| 2016-04-21 00:00:00 |
| 2016-04-21 00:00:00 |
| filing_directory |
| /cafiler/disclose/ca99/temp |
| /cafiler/disclose/ca99/temp |
| /cafiler/disclose/ca99/cal |
| /cafiler/disclose/ca99/temp |
| /cafiler/disclose/ca99/temp |
| filing_id |
| None |
| None |
| 1996937 |
| None |
| None |
| form_id |
| None |
| None |
| F635 |
| None |
| None |
| receive_comment |
| Filing passed validation, but failed DB constraints |
| Filing passed validation, but failed DB constraints |
| Filing accepted |
| Filing passed validation, but failed DB constraints |
| Filing passed validation, but failed DB constraints |
|