filing_id | 811135 | 838895 | 854470 | 874858 | 906373 | 928926 | 945076 | 968061 | 982994 | 1011587 | 1027388 | 1050413 | 1074522 | 1128004 | 1105253 | 1163636 | 1114398 | 1147000 | 1187356 | 1232679 | 1257248 | 1280364 | 1210860 | 1349754 | 1294381 | 1327224 | 1308675 | 1420392 | 1376281 | 1449495 | 1435915 | 1396276 | 1505232 | 1537512 | 1463524 | 1481854 | 1568405 | 1590429 | 1620225 | 1604011 | 1632178 | 1703386 | 1676074 | 1655371 | 1733217 | 1796744 | 1778003 | 1762410 | 1816981 | 1907433 | 1870202 | 1842204 | 1932662 | 1979339 | 1993085 | 1963372 | 2059977 | 2037620 | 2010260 | 2097394 | 2175897 | 2154146 | 2127318 | 2188064 | 2242115 | 2275383 | 2207573 | 2376852 | 2343069 | 2396254 | 2320644 | 2414581 | 2443832 | 2470128 | 2554315 | 2484808 | 2527064 | 2602229 | 2623418 | 2580860 | 2701538 | 2642205 | 2672152 | 2748883 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | 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 | 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 | 0 | 0 | 0 | 0 | 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 | 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 | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | Robson | Robson | Robson | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | Michael R. | Michael R. | Michael R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2002-01-25 00:00:00 | 2002-04-29 00:00:00 | 2002-07-29 00:00:00 | 2002-10-16 00:00:00 | 2003-01-27 00:00:00 | 2003-04-21 00:00:00 | 2003-07-28 00:00:00 | 2003-10-21 00:00:00 | 2004-01-26 00:00:00 | 2004-04-20 00:00:00 | 2004-07-23 00:00:00 | 2004-10-15 00:00:00 | 2005-01-21 00:00:00 | 2005-10-17 00:00:00 | 2005-04-22 00:00:00 | 2006-04-14 00:00:00 | 2005-07-22 00:00:00 | 2006-01-25 00:00:00 | 2006-07-18 00:00:00 | 2007-01-29 00:00:00 | 2007-04-20 00:00:00 | 2007-07-23 00:00:00 | 2006-10-16 00:00:00 | 2008-07-25 00:00:00 | 2007-10-12 00:00:00 | 2008-04-21 00:00:00 | 2008-01-25 00:00:00 | 2009-04-20 00:00:00 | 2008-10-20 00:00:00 | 2009-10-20 00:00:00 | 2009-07-24 00:00:00 | 2009-01-26 00:00:00 | 2010-07-28 00:00:00 | 2010-10-20 00:00:00 | 2010-01-27 00:00:00 | 2010-04-16 00:00:00 | 2011-01-21 00:00:00 | 2011-04-18 00:00:00 | 2011-10-18 00:00:00 | 2011-07-25 00:00:00 | 2012-01-23 00:00:00 | 2012-10-22 00:00:00 | 2012-07-25 00:00:00 | 2012-04-19 00:00:00 | 2013-01-28 00:00:00 | 2013-10-21 00:00:00 | 2013-07-26 00:00:00 | 2013-04-22 00:00:00 | 2014-01-29 00:00:00 | 2014-10-24 00:00:00 | 2014-07-28 00:00:00 | 2014-04-17 00:00:00 | 2015-01-27 00:00:00 | 2015-07-27 00:00:00 | 2015-10-26 00:00:00 | 2015-04-21 00:00:00 | 2016-07-25 00:00:00 | 2016-04-20 00:00:00 | 2016-01-26 00:00:00 | 2016-10-21 00:00:00 | 2017-07-26 00:00:00 | 2017-04-19 00:00:00 | 2017-01-26 00:00:00 | 2017-10-16 00:00:00 | 2018-04-23 00:00:00 | 2018-07-30 00:00:00 | 2018-01-22 00:00:00 | 2019-04-15 00:00:00 | 2019-01-17 00:00:00 | 2019-07-11 00:00:00 | 2018-10-29 00:00:00 | 2019-10-11 00:00:00 | 2020-01-20 00:00:00 | 2020-04-14 00:00:00 | 2021-01-18 00:00:00 | 2020-07-16 00:00:00 | 2020-10-12 00:00:00 | 2021-07-14 00:00:00 | 2021-10-19 00:00:00 | 2021-04-14 00:00:00 | 2022-07-14 00:00:00 | 2022-01-15 00:00:00 | 2022-04-18 00:00:00 | 2022-10-12 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2006-07-01 00:00:00 | 2008-04-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2009-01-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2008-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-09-30 00:00:00 | 2005-03-31 00:00:00 | 2006-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-12-30 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2006-09-30 00:00:00 | 2008-06-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2009-03-31 00:00:00 | 2008-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2008-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN AND GILBERT | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | (916)443-6400 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 2002-10-22 00:00:00 | 2002-04-26 00:00:00 | 2002-07-29 00:00:00 | 2002-10-16 00:00:00 | 2003-01-24 00:00:00 | 2003-04-21 00:00:00 | 2003-07-28 00:00:00 | 2003-10-21 00:00:00 | 2004-01-20 00:00:00 | 2004-04-20 00:00:00 | 2004-07-21 00:00:00 | 2004-10-15 00:00:00 | 2005-01-20 00:00:00 | 2005-10-17 00:00:00 | 2005-04-20 00:00:00 | 2006-04-13 00:00:00 | 2005-07-22 00:00:00 | 2006-01-25 00:00:00 | 2006-07-18 00:00:00 | 2007-01-26 00:00:00 | 2007-04-20 00:00:00 | 2007-07-20 00:00:00 | 2006-10-16 00:00:00 | 2008-07-25 00:00:00 | 2007-10-12 00:00:00 | 2008-04-21 00:00:00 | 2008-01-25 00:00:00 | 2009-04-20 00:00:00 | 2008-10-20 00:00:00 | 2009-10-20 00:00:00 | 2009-07-24 00:00:00 | 2009-01-26 00:00:00 | 2010-07-28 00:00:00 | 2010-10-20 00:00:00 | 2010-01-27 00:00:00 | 2010-04-16 00:00:00 | 2011-01-21 00:00:00 | 2011-04-18 00:00:00 | 2011-10-18 00:00:00 | 2011-07-25 00:00:00 | 2012-01-23 00:00:00 | 2012-10-22 00:00:00 | 2012-07-25 00:00:00 | 2012-04-19 00:00:00 | 2013-01-28 00:00:00 | 2013-10-21 00:00:00 | 2013-07-26 00:00:00 | 2013-04-22 00:00:00 | 2014-01-29 00:00:00 | 2014-10-24 00:00:00 | 2014-07-28 00:00:00 | 2014-04-17 00:00:00 | 2015-01-27 00:00:00 | 2015-07-27 00:00:00 | 2015-10-26 00:00:00 | 2015-04-21 00:00:00 | 2016-07-25 00:00:00 | 2016-04-20 00:00:00 | 2016-01-26 00:00:00 | 2016-10-21 00:00:00 | 2017-07-26 00:00:00 | 2017-04-19 00:00:00 | 2017-01-26 00:00:00 | 2017-10-16 00:00:00 | 2018-04-23 00:00:00 | 2018-07-30 00:00:00 | 2018-01-22 00:00:00 | 2019-04-15 00:00:00 | 2019-01-17 00:00:00 | 2019-07-11 00:00:00 | 2018-10-29 00:00:00 | 2019-10-11 00:00:00 | 2020-01-20 00:00:00 | 2020-04-14 00:00:00 | 2021-01-18 00:00:00 | 2020-07-16 00:00:00 | 2020-10-12 00:00:00 | 2021-07-14 00:00:00 | 2021-10-19 00:00:00 | 2021-04-14 00:00:00 | 2022-07-14 00:00:00 | 2022-01-15 00:00:00 | 2022-04-18 00:00:00 | 2022-10-12 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | ROBSON 4034jh | ROBSON 4034jh | ROBSON 403400jh | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400SSB | ROBSON 403400SSB | ROBSON 403400SSB | ROBSON 403400jh | ROBSON 403400SSB | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | ROBSON 4034jh | ROBSON 4034jh | ROBSON 403400jh | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400jh | ROBSON 403400SSB | ROBSON 403400SSB | ROBSON 403400SSB | ROBSON 403400jh | ROBSON 403400SSB | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | X | X | X | X | X | X | None | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_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 | 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 | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1068409 | 1068409 | 1224555 | 1387139 | 1553681 | 1723417 | 1921962 | 1921962 | 2117124 | 2331711 | 2331711 | 2539288 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | ||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | ||||||||||||
sender_id | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | F00980 | ||||||||||||
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||
filer_naml | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||
filer_namf | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | ||||||||||||
filer_namt | 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 | ||||||||||||
report_num | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 001 | 000 | ||||||||||||
rpt_date | 2004-11-22 00:00:00 | 2005-03-22 00:00:00 | 2006-12-22 00:00:00 | 2008-12-22 00:00:00 | 2010-12-01 00:00:00 | 2013-01-08 00:00:00 | 2014-12-30 00:00:00 | 2015-01-27 00:00:00 | 2014-12-30 00:00:00 | 2018-11-13 00:00:00 | 2019-02-07 00:00:00 | 2020-12-03 00:00:00 | ||||||||||||
ls_beg_yr | 2005 | 2005 | 2007 | 2009 | 2011 | 2013 | 2015 | 2015 | 2017 | 2019 | 2019 | 2021 | ||||||||||||
ls_end_yr | 2006 | 2006 | 2008 | 2010 | 2012 | 2014 | 2016 | 2016 | 2018 | 2020 | 2020 | 2022 | ||||||||||||
qual_date | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | ||||||||||||
eff_date | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||
bus_phon | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | (916) 443-6400 | ||||||||||||
bus_fax | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_email | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
mail_city | 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 | ||||||||||||
mail_zip4 | 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 | ||||||||||||
sig_date | 2004-11-22 00:00:00 | 2005-03-22 00:00:00 | 2006-12-11 00:00:00 | 2008-11-12 00:00:00 | 2010-12-01 00:00:00 | 2012-12-18 00:00:00 | 2014-12-01 00:00:00 | 2015-01-27 00:00:00 | 2016-12-10 00:00:00 | 2018-11-13 00:00:00 | 2019-02-07 00:00:00 | 2020-12-03 00:00:00 | ||||||||||||
sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | ||||||||||||
sig_naml | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||
sig_namf | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | ||||||||||||
sig_namt | 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 | ||||||||||||
prn_naml | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||
prn_namf | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | ||||||||||||
prn_namt | 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 | ||||||||||||
sig_title | LOBBYIST 403400jh | LOBBYIST 403400jh | LOBBYIST 403400jh | LOBBYIST 403400jh | PARTNER 403400jh | PARTNER 403400jh | MANAGER 403400jh | MANAGER 403400jh | MANAGER 403400jh | MANAGER 403400jh | MANAGER | MANAGER | ||||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
oth_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
descrip_1 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
ind_class | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
ind_descr | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_class | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_name | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_city | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_st | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
firm_name | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN AND GILBERT | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | ||||||||||||
newcert_cb | None | None | None | X | None | None | None | None | None | None | None | None | ||||||||||||
rencert_cb | None | None | None | None | None | None | X | None | None | X | None | None | ||||||||||||
complet_dt | None | 2005-02-09 00:00:00 | None | None | 2010-11-17 00:00:00 | 2012-11-08 00:00:00 | None | 2015-01-22 00:00:00 | 2016-11-17 00:00:00 | None | 2019-02-07 00:00:00 | 2020-12-03 00:00:00 | ||||||||||||
lby_reg_cb | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
st_leg_yn | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | ||||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2026755 | 2044812 | 2081613 | 2116074 | 2160861 | 2204295 | 2411655 | 2545332 | 2469739 | 2516269 | 2277169 | 2345349 | ||||||||||||
effect_dt | 2001-12-10 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 2001 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2023 | 2019 | 2021 | 2013 | 2015 |
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2005 | 2007 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | ||||||||||
ethics_date | 2002-11-13 00:00:00 | 2005-02-09 00:00:00 | 2006-11-16 00:00:00 | 2009-01-16 00:00:00 | 2010-11-17 00:00:00 | 2012-11-08 00:00:00 | 2015-01-22 00:00:00 | 2016-11-17 00:00:00 | 2019-02-07 00:00:00 | 2020-12-03 00:00:00 |
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 811135 | 807139 | 807142 | 816302 | 838895 | 856469 | 854470 | 842284 | 877452 | 874858 | 918517 | 909985 | 906373 | 928926 | 929550 | 945076 | 951234 | 968061 | 970830 | 988114 | 982994 | 1011587 | 1027388 | 1013215 | 1029160 | 1050413 | 1061418 | 1068409 | 1074522 | 1098574 | 1084266 | 1068409 | 1085557 | 1105253 | 1114398 | 1128004 | 1147000 | 1163636 | 1187356 | 1210860 | 1257248 | 1232679 | 1232939 | 1224555 | 1280364 | 1308675 | 1294381 | 1778003 | 1963372 | 1947278 | 1870202 | 1952612 | 1907433 | 1327224 | 1349754 | 1387139 | 1376281 | 1414982 | 1414982 | 1396276 | 1435915 | 1420392 | 1449495 | 1463524 | 1505232 | 1481854 | 1537512 | 1553681 | 1563288 | 1568405 | 1604011 | 1620225 | 1590429 | 1632178 | 1676074 | 1655371 | 1816981 | 1796744 | 1932662 | 1930453 | 1921962 | 1921962 | 1703386 | 1723417 | 1733217 | 1842204 | 1762410 | 1752723 | 1979339 | 2376852 | 2571492 | 2242115 | 2331711 | 2343069 | 2320644 | 2010260 | 1993085 | 2037620 | 2059977 | 2097394 | 2124441 | 2127318 | 2117124 | 2154146 | 2175897 | 2275383 | 2207573 | 2470128 | 2484808 | 2188064 | 2396254 | 2331711 | 2428570 | 2414581 | 2358223 | 2527064 | 2443832 | 2602229 | 2642205 | 2623418 | 2539288 | 2701538 | 2580860 | 2672152 | 2554315 | 2748883 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 168 | None | None | None | 169 | None | 170 | None | None | 171 | None | None | 172 | 173 | None | 174 | None | 175 | None | None | 176 | 177 | 178 | None | None | 179 | None | 180 | 180 | None | None | 181 | None | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 189 | 188 | None | 188 | 190 | 192 | 191 | 214 | 221 | None | 218 | None | 219 | 193 | 194 | 196 | 195 | None | None | 196 | 198 | 197 | 199 | 200 | 202 | 201 | 203 | 204 | None | 204 | 206 | 207 | 205 | 208 | 210 | 209 | 216 | 215 | 220 | None | 221 | 220 | 211 | 213 | 212 | 217 | 213 | None | 222 | 237 | None | 233 | 236 | 236 | 235 | 224 | 223 | 225 | 226 | 227 | None | 228 | 220 | 229 | 230 | 234 | 232 | 241 | 242 | 231 | 238 | 237 | None | 239 | None | 243 | 240 | 246 | 248 | 247 | 244 | 250 | 245 | 249 | 244 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F604 | F999 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 0 | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2002-01-28 00:00:00 | 2002-01-08 00:00:00 | 2002-01-15 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-04-30 00:00:00 | 2002-10-18 00:00:00 | 2002-10-17 00:00:00 | 2002-12-20 00:00:00 | 2003-01-29 00:00:00 | 2003-01-27 00:00:00 | 2003-04-25 00:00:00 | 2003-04-25 00:00:00 | 2003-07-28 00:00:00 | 2003-07-29 00:00:00 | 2003-10-28 00:00:00 | 2003-10-29 00:00:00 | 2004-01-21 00:00:00 | 2004-01-16 00:00:00 | 2004-04-27 00:00:00 | 2004-07-28 00:00:00 | 2004-04-28 00:00:00 | 2004-07-29 00:00:00 | 2004-10-21 00:00:00 | 2004-10-21 00:00:00 | 2004-12-29 00:00:00 | 2005-01-24 00:00:00 | 2005-03-25 00:00:00 | 2005-01-26 00:00:00 | 2005-03-22 00:00:00 | 2004-12-29 00:00:00 | 2005-05-02 00:00:00 | 2005-07-26 00:00:00 | 2005-10-13 00:00:00 | 2006-01-30 00:00:00 | 2006-04-21 00:00:00 | 2006-07-25 00:00:00 | 2006-10-24 00:00:00 | 2007-04-17 00:00:00 | 2007-01-26 00:00:00 | 2006-12-26 00:00:00 | 2006-12-26 00:00:00 | 2007-07-25 00:00:00 | 2008-01-29 00:00:00 | 2007-10-23 00:00:00 | 2013-07-24 00:00:00 | 2015-04-28 00:00:00 | 2015-01-05 00:00:00 | 2014-07-30 00:00:00 | 2015-01-29 00:00:00 | 2014-10-28 00:00:00 | 2008-04-25 00:00:00 | 2008-07-30 00:00:00 | 2008-12-31 00:00:00 | 2008-10-30 00:00:00 | 2009-01-06 00:00:00 | 2009-01-16 00:00:00 | 2009-01-30 00:00:00 | 2009-07-29 00:00:00 | 2009-04-29 00:00:00 | 2009-10-25 00:00:00 | 2010-01-29 00:00:00 | 2010-07-29 00:00:00 | 2010-04-23 00:00:00 | 2010-10-28 00:00:00 | 2010-12-23 00:00:00 | 2010-12-22 00:00:00 | 2011-01-28 00:00:00 | 2011-07-26 00:00:00 | 2011-10-27 00:00:00 | 2011-04-29 00:00:00 | 2012-01-26 00:00:00 | 2012-07-27 00:00:00 | 2012-04-26 00:00:00 | 2014-01-30 00:00:00 | 2013-10-23 00:00:00 | 2015-01-29 00:00:00 | 2015-01-22 00:00:00 | 2015-01-29 00:00:00 | 2014-12-30 00:00:00 | 2012-10-25 00:00:00 | 2013-01-08 00:00:00 | 2013-01-28 00:00:00 | 2014-04-28 00:00:00 | 2013-04-26 00:00:00 | 2013-01-10 00:00:00 | 2015-07-29 00:00:00 | 2019-04-24 00:00:00 | 2020-12-30 00:00:00 | 2018-04-30 00:00:00 | 2019-01-02 00:00:00 | 2019-01-29 00:00:00 | 2018-10-31 00:00:00 | 2016-01-29 00:00:00 | 2015-10-21 00:00:00 | 2016-05-02 00:00:00 | 2016-07-28 00:00:00 | 2016-10-27 00:00:00 | 2017-01-05 00:00:00 | 2017-01-30 00:00:00 | 2017-01-04 00:00:00 | 2017-04-26 00:00:00 | 2017-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-01-29 00:00:00 | 2020-04-30 00:00:00 | 2020-07-30 00:00:00 | 2017-10-17 00:00:00 | 2019-07-30 00:00:00 | 2020-01-06 00:00:00 | 2020-01-06 00:00:00 | 2019-10-23 00:00:00 | 2019-01-02 00:00:00 | 2020-10-29 00:00:00 | 2020-01-31 00:00:00 | 2021-08-01 00:00:00 | 2022-01-29 00:00:00 | 2021-10-31 00:00:00 | 2020-12-29 00:00:00 | 2022-07-26 00:00:00 | 2021-04-30 00:00:00 | 2022-04-27 00:00:00 | 2021-02-01 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10006 | 10005 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 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 | 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 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2015 | 2013 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2019 | 2021 | 2017 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | GPEREZ | GPEREZ | YBONILLA | * | YBONILLA | * | YBONILLA | YBONILLA | * | GPEREZ | YBONILLA | COMPLETED | COMPLETED | YBONILLA | COMPLETED | YBONILLA | COMPLETED | YBONILLA | YBONILLA | COMPLETED | COMPLETED | COMPLETED | EMCENTEE | KLARRY | COMPLETED | EMCENTEE | COMPLETED | COMPLETED | SARRIAGA | YRODRIGU | COMPLETED | SARRIAGA | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | SARRIAGA | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | ASAETERN | JINGRAM | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | LTHIBAUL | LTHIBAUL | * | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | ASAETERN | JINGRAM | ASAETERN | YRODRIGU | SARRIAGA | ASAETERN | ASAETERN | ASAETERN | JINGRAM | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | JINGRAM | SUSHAKOV | MKIRKHAM | AGLADNEY | GPEREZ | AGLADNEY | JFRONEFIELD | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | GPEREZ | AGLADNEY | SMCCONNAN | AGLADNEY | AGLADNEY | SUSHAKOV | MMERCHANT | SMCCONNAN | VUKSTINA | GPEREZ | GPEREZ | VUKSTINA | GPEREZ | MKIRKHAM | VUKSTINA | GTAYLOR | GTAYLOR | CHATRIDGE | MKIRKHAM | CAFILER | CHARTRIDGE | CAFILER | CHARTRIDGE | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11003 | 11002 | 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 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2001-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-11-22 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-03-22 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-22 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-12-22 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-01 00:00:00 | None | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-27 00:00:00 | 2014-12-30 00:00:00 | 2012-07-01 00:00:00 | 2013-01-08 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-11-13 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-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 | 2014-12-30 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-02-07 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2019-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 2020-12-03 00:00:00 | 2022-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2001-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-11-22 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-03-22 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2006-12-22 00:00:00 | 2007-06-30 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-22 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-12-01 00:00:00 | None | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2015-01-27 00:00:00 | 2014-12-30 00:00:00 | 2012-09-30 00:00:00 | 2013-01-08 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2018-11-13 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2015-12-31 00:00:00 | 2015-09-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-12-31 00:00:00 | 2014-12-30 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-02-07 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2019-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 2020-12-03 00:00:00 | 2022-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||
race | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2021 | 2015 | 2019 | 2017 | 2023 | ||||||||||||
category | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 2001-12-10 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 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 | 2023-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nyq_dt | None | None | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | None | None | None | None | None | None | None | None | ||||||||||||
party_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
county_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
district_cd | 0 | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1241733 | |
---|---|---|
xref_id | 1241733 | |
effect_dt | 2002-01-09 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ROBSON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL R. | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | MICHAEL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | 9164436400 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | 9164436445 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] |
filer_id | 1241733 |
---|
filer_id | 1241733 | |
---|---|---|
change_no | 0 | |
session_id | 2001 | |
log_dt | 2002-01-08 00:00:00 | |
filer_type | 4 | |
correction_flg | Y | |
action | NEW | |
attribute_changed | LOBBYIST | |
ethics_dt | None | |
interests | None | |
filer_full_name | ROBSON, MICHAEL | |
filer_city | None | |
filer_st | None | |
filer_zip | None | |
filer_phone | None | |
entity_type | 4 | |
entity_name | EDELSTEIN AND GILBERT | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | 1147328 | |
responsible_officer | None | |
effect_dt | 2001-12-10 00:00:00 |
filer_id | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | 1241733 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 811135_0.cal | 838895_0.cal | 854470_0.cal | 874858_0.cal | 906373_0.cal | 928926_0.cal | 945076_0.cal | 968061_0.cal | 982994_0.cal | 195911.cal | 1011587_0.cal | 1027388_0.cal | 1050413_0.cal | 1074522_0.cal | 523175.cal | 1105253_0.cal | 1068409_1.cal | 1128004_0.cal | 1114398_0.cal | 1147000_0.cal | 1163636_0.cal | 1187356_0.cal | 1210860_0.cal | 1327224_0.cal | 1505232_0.cal | 1396276_0.cal | 1435915_0.cal | 1349754_0.cal | 1449495_0.cal | 1463524_0.cal | 1232679_0.cal | 1481854_0.cal | 1257248_0.cal | 406286.cal | 1280364_0.cal | 1420392_0.cal | 1294381_0.cal | 1376281_0.cal | 1387139_0.cal | 1308675_0.cal | 1842204_0.cal | 1733217_0.cal | 1723417_0.cal | 1676074_0.cal | 1796744_0.cal | 1553681_0.cal | 1537512_0.cal | 1703386_0.cal | 1568405_0.cal | 1816981_0.cal | 1604011_0.cal | 1590429_0.cal | 1762410_0.cal | 1778003_0.cal | 1632178_0.cal | 1620225_0.cal | 282976.cal | 1655371_0.cal | 1870202_0.cal | 2127318_0.cal | 2154146_0.cal | 2059977_0.cal | 2010260_0.cal | 1993085_0.cal | 2117124_0.cal | 2097394_0.cal | 1907433_0.cal | 1921962_0.cal | 2037620_0.cal | 1963372_0.cal | 1921962_1.cal | 1979339_0.cal | 1932662_0.cal | 2175897_0.cal | 2331711_1.cal | 2242115_0.cal | 2376852_0.cal | 2396254_0.cal | 2331711_0.cal | 2343069_0.cal | 2320644_0.cal | 2275383_0.cal | 2470128_0.cal | 2207573_0.cal | 2188064_0.cal | 2484808_0.cal | 2443832_0.cal | 2414581_0.cal | 2748883_0.cal | 2623418_0.cal | 2642205_0.cal | 2554315_0.cal | 2527064_0.cal | 2701538_0.cal | 2602229_0.cal | 2539288_0.cal | 2580860_0.cal | 2672152_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2002-01-28 00:00:00 | 2002-04-29 00:00:00 | 2002-07-30 00:00:00 | 2002-10-17 00:00:00 | 2003-01-27 00:00:00 | 2003-04-25 00:00:00 | 2003-07-28 00:00:00 | 2003-10-28 00:00:00 | 2004-01-16 00:00:00 | 2004-01-16 00:00:00 | 2004-04-27 00:00:00 | 2004-07-28 00:00:00 | 2004-10-21 00:00:00 | 2005-01-24 00:00:00 | 2005-03-22 00:00:00 | 2005-05-02 00:00:00 | 2005-03-22 00:00:00 | 2005-10-13 00:00:00 | 2005-07-26 00:00:00 | 2006-01-30 00:00:00 | 2006-04-21 00:00:00 | 2006-07-25 00:00:00 | 2006-10-24 00:00:00 | 2008-04-25 00:00:00 | 2010-07-29 00:00:00 | 2009-01-30 00:00:00 | 2009-07-29 00:00:00 | 2008-07-30 00:00:00 | 2009-10-25 00:00:00 | 2010-01-29 00:00:00 | 2007-01-26 00:00:00 | 2010-04-23 00:00:00 | 2007-04-17 00:00:00 | 2007-04-17 00:00:00 | 2007-07-25 00:00:00 | 2009-04-29 00:00:00 | 2007-10-23 00:00:00 | 2008-10-30 00:00:00 | 2008-12-31 00:00:00 | 2008-01-29 00:00:00 | 2014-04-28 00:00:00 | 2013-01-28 00:00:00 | 2013-01-08 00:00:00 | 2012-07-27 00:00:00 | 2013-10-23 00:00:00 | 2010-12-23 00:00:00 | 2010-10-28 00:00:00 | 2012-10-25 00:00:00 | 2011-01-28 00:00:00 | 2014-01-30 00:00:00 | 2011-07-26 00:00:00 | 2011-04-29 00:00:00 | 2013-04-26 00:00:00 | 2013-07-24 00:00:00 | 2012-01-26 00:00:00 | 2011-10-27 00:00:00 | 2012-04-26 00:00:00 | 2012-04-26 00:00:00 | 2014-07-30 00:00:00 | 2017-01-30 00:00:00 | 2017-04-26 00:00:00 | 2016-07-28 00:00:00 | 2016-01-29 00:00:00 | 2015-10-21 00:00:00 | 2017-01-04 00:00:00 | 2016-10-27 00:00:00 | 2014-10-28 00:00:00 | 2014-12-30 00:00:00 | 2016-05-02 00:00:00 | 2015-04-28 00:00:00 | 2015-01-29 00:00:00 | 2015-07-29 00:00:00 | 2015-01-29 00:00:00 | 2017-07-31 00:00:00 | 2020-01-06 00:00:00 | 2018-04-30 00:00:00 | 2019-04-24 00:00:00 | 2019-07-30 00:00:00 | 2019-01-02 00:00:00 | 2019-01-29 00:00:00 | 2018-10-31 00:00:00 | 2018-07-31 00:00:00 | 2020-04-30 00:00:00 | 2018-01-29 00:00:00 | 2017-10-17 00:00:00 | 2020-07-30 00:00:00 | 2020-01-31 00:00:00 | 2019-10-23 00:00:00 | 2022-10-31 00:00:00 | 2021-10-31 00:00:00 | 2022-01-29 00:00:00 | 2021-02-01 00:00:00 | 2020-10-29 00:00:00 | 2022-07-26 00:00:00 | 2021-08-01 00:00:00 | 2020-12-29 00:00:00 | 2021-04-30 00:00:00 | 2022-04-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 811135 | 838895 | 854470 | 874858 | 906373 | 928926 | 945076 | 968061 | 982994 | None | 1011587 | 1027388 | 1050413 | 1074522 | None | 1105253 | 1068409 | 1128004 | 1114398 | 1147000 | 1163636 | 1187356 | 1210860 | 1327224 | 1505232 | 1396276 | 1435915 | 1349754 | 1449495 | 1463524 | 1232679 | 1481854 | 1257248 | None | 1280364 | 1420392 | 1294381 | 1376281 | 1387139 | 1308675 | 1842204 | 1733217 | 1723417 | 1676074 | 1796744 | 1553681 | 1537512 | 1703386 | 1568405 | 1816981 | 1604011 | 1590429 | 1762410 | 1778003 | 1632178 | 1620225 | None | 1655371 | 1870202 | 2127318 | 2154146 | 2059977 | 2010260 | 1993085 | 2117124 | 2097394 | 1907433 | 1921962 | 2037620 | 1963372 | 1921962 | 1979339 | 1932662 | 2175897 | 2331711 | 2242115 | 2376852 | 2396254 | 2331711 | 2343069 | 2320644 | 2275383 | 2470128 | 2207573 | 2188064 | 2484808 | 2443832 | 2414581 | 2748883 | 2623418 | 2642205 | 2554315 | 2527064 | 2701538 | 2602229 | 2539288 | 2580860 | 2672152 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | None | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |