filing_id | 1024730 | 1054215 | 1075569 | 1163089 | 1104218 | 1114062 | 1145884 | 1131223 | 1283060 | 1189384 | 1236431 | 1260001 | 1215870 | 1260001 | 1283060 | 1309880 | 1309880 | 1348434 | 1294355 | 1329302 | 1436672 | 1436672 | 1451342 | 1377341 | 1421094 | 1392943 | 1421094 | 1484504 | 1436672 | 1451342 | 1464192 | 1484504 | 1508223 | 1421094 | 1464192 | 1569363 | 1539133 | 1590676 | 2444235 | 2398762 | 2471562 | 2419132 | 2531971 | 2554609 | 2487770 | 2601824 | 2623700 | 2579802 | 2675911 | 2708149 | 2644367 | 2749067 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 1 | 1 | 0 | 2 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | ||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 001 | 000 | 002 | 001 | 001 | 001 | 000 | 002 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2004-06-30 00:00:00 | 2004-10-31 00:00:00 | 2005-01-31 00:00:00 | 2006-04-30 00:00:00 | 2005-04-30 00:00:00 | 2005-07-31 00:00:00 | 2006-01-31 00:00:00 | 2005-10-31 00:00:00 | 2007-07-31 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2007-04-30 00:00:00 | 2006-10-31 00:00:00 | 2007-04-30 00:00:00 | 2007-07-31 00:00:00 | 2008-01-31 00:00:00 | 2008-01-31 00:00:00 | 2008-07-31 00:00:00 | 2007-10-31 00:00:00 | 2008-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2009-10-31 00:00:00 | 2008-10-31 00:00:00 | 2009-04-30 00:00:00 | 2009-01-31 00:00:00 | 2009-04-30 00:00:00 | 2010-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-10-31 00:00:00 | 2010-01-31 00:00:00 | 2010-04-30 00:00:00 | 2010-07-31 00:00:00 | 2009-04-30 00:00:00 | 2010-01-31 00:00:00 | 2011-01-31 00:00:00 | 2010-10-31 00:00:00 | 2011-04-30 00:00:00 | 2020-01-27 00:00:00 | 2019-07-24 00:00:00 | 2020-04-28 00:00:00 | 2019-10-15 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2020-07-22 00:00:00 | 2021-07-19 00:00:00 | 2021-10-17 00:00:00 | 2021-04-18 00:00:00 | 2022-04-21 00:00:00 | 2022-07-21 00:00:00 | 2022-01-22 00:00:00 | 2022-10-29 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2007-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2007-06-30 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2010-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2004-05-15 00:00:00 | 2004-05-15 00:00:00 | 2004-05-15 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | Pacific Dental Services | ||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | COSTA MESA | COSTA MESA | COSTA MESA | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | Irvine | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 92627 | 92627 | 92627 | 92606 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | 92614 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (714) 508-3600 | (714) 508-3600 | (949) 646-1151 | (714) 508-3600 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (949) 646-1151 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | (949) 646-1151 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | (714) 508-3600 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | 714 845-8545 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2004-07-14 00:00:00 | 2004-10-13 00:00:00 | 2005-01-22 00:00:00 | 2006-04-17 00:00:00 | 2005-04-23 00:00:00 | 2005-07-21 00:00:00 | 2006-01-22 00:00:00 | 2005-10-20 00:00:00 | 2007-07-24 00:00:00 | 2006-07-21 00:00:00 | 2007-01-22 00:00:00 | 2007-04-20 00:00:00 | 2006-10-19 00:00:00 | 2007-09-24 00:00:00 | 2007-07-24 00:00:00 | 2008-01-23 00:00:00 | 2008-02-12 00:00:00 | 2008-07-21 00:00:00 | 2007-10-15 00:00:00 | 2008-04-22 00:00:00 | 2009-07-20 00:00:00 | 2009-10-29 00:00:00 | 2009-10-19 00:00:00 | 2008-10-20 00:00:00 | 2009-04-20 00:00:00 | 2009-01-21 00:00:00 | 2009-10-26 00:00:00 | 2010-04-22 00:00:00 | 2010-07-19 00:00:00 | 2010-07-19 00:00:00 | 2010-07-19 00:00:00 | 2010-07-19 00:00:00 | 2010-07-19 00:00:00 | 2010-06-09 00:00:00 | 2010-01-24 00:00:00 | 2011-01-23 00:00:00 | 2010-10-24 00:00:00 | 2011-04-19 00:00:00 | 2020-01-27 00:00:00 | 2019-07-24 00:00:00 | 2020-04-28 00:00:00 | 2019-10-15 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2020-07-22 00:00:00 | 2021-07-19 00:00:00 | 2021-10-17 00:00:00 | 2021-04-18 00:00:00 | 2022-04-21 00:00:00 | 2022-07-21 00:00:00 | 2022-01-22 00:00:00 | 2022-10-29 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 | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | Irvine CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | ||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | EICHMAN | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | Burke | ||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | Dan | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | CERTIFIED PUBLIC ACCOUNTANT (433000-SSD) | SVP, Platform Strategy & GC | SVP, Platform Strategy & GC | SVP, Platform Strategy & GC | SVP, Platform Strategy & GC | Chief Enterprise Strategy & General Counsel | Chief Enterprise Strategy Off/General Counsel | SVP, Platform Strategy & GC | Chief Ent Strategy Officer & General Counsel | Chief Ent Strategy Officer & General Counsel | Sr. VP, Platform Strategy/General Counsel | Chief Ent Strategy Officer & General Counsel | Chief Ent Strategy Officer & General Counsel | Chief Ent Strategy Officer & General Counsel | Chief Ent Strategy Officer & General Counsel | ||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | None | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | X | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | LEGISLATURE RE: BUDGET ISSUES; GOVERNOR'S OFFICE RE: MANAGED-DENTAL CARE ISSUES | LEGISLATURE RE: BUDGET ISSUES; GOVERNOR'S OFFICE RE: MANAGED-DENTAL CARE ISSUES | LEGISLATURE RE: BUDGET ISSUES; GOVERNOR'S OFFICE, STATE AND CONSUMER SERVICES AGENCY RE: MANAGED-DENTAL CARE ISSUES | NONE | NONE | NONE | NONE | NONE | DEPARTMENT OF HEALTH SERVICES RE: MEDI-CAL FUNDING ISSUES | SB 1541 | SB 1541 | DEPARTMENT OF HEALTH SERVICES RE: MEDI-CAL FUNDING ISSUES | SB 1541 | DEPARTMENT OF HEALTH SERVICES RE: MEDI-CAL FUNDING ISSUES | DEPARTMENT OF HEALTH SERVICES RE: MEDI-CAL FUNDING ISSUES | NONE | NONE | SB 1633 | DEPARTMENT OF HEALTH SERVICES RE: MEDI-CAL FUNDING ISSUES | NONE | AB 171 | AB 171 | AB 171 | SB 1633 | AB 171 | SB 1633 | AB 171 | NONE | AB 171 | AB 171 | AB 171 | NONE | NONE | AB 171 | AB 171 | NONE | NONE | NONE - TERMINATED 1/31/11 | Legislature: homelessness | SB 639 | AB 1998, 2146; SB 1097; Legislature, Department of Managed Healthcare Re: multiple employer welfare arrangement | SB 639 | AB 1998; SB 275, 977, 1097; Department of Managed Health Care Re: Multiple employer welfare arrangement | None | AB 1998; SB 977, 1097; Legislature, Department of Managed Healthcare Re: multiple employer welfare arrangement | AB 526; SB 255, 652, 718; Legislature Re: Multiple employer welfare arrangement (MEWA) | AB 526; SB 255, 718; Legislature Re: Multiple employer welfare arrangement (MEWA) | AB 526; SB 255, 652, 718; Dental Board Re: Residency Programs | AB 1982, 2276 | AB 2276 | None | Legislature Re: Budget Items: Special Needs Dental Clinics & Dental Assistant Training; Treasurer's Office Re: Special Needs Clinical Infrastructure Grants; Department of Public Health Re: Office of Oral Health | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
filing_id | 1069753 | 1225384 | 1386417 | 1554290 | 2385358 | |||||
---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | |||||
rec_type | CVR | CVR | CVR | CVR | CVR | |||||
form_type | F602 | F602 | F602 | F602 | F602 | |||||
sender_id | F00409 | F00409 | F00409 | F00409 | 1373846 | |||||
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | |||||
entity_cd | LEM | LEM | LEM | LEM | LEM | |||||
filer_naml | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | Pacific Dental Services (PDS) | |||||
filer_namf | None | None | None | None | None | |||||
filer_namt | None | None | None | None | None | |||||
filer_nams | None | None | None | None | None | |||||
report_num | 000 | 000 | 000 | 000 | 000 | |||||
rpt_date | 2005-01-02 00:00:00 | 2006-11-27 00:00:00 | 2008-12-29 00:00:00 | 2010-12-22 00:00:00 | 2019-05-15 00:00:00 | |||||
ls_beg_yr | 2005 | 2007 | 2009 | 2011 | 2019 | |||||
ls_end_yr | 2006 | 2008 | 2010 | 2012 | 2020 | |||||
qual_date | None | None | None | None | None | |||||
eff_date | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2019-05-13 00:00:00 | |||||
bus_city | COSTA MESA | IRVINE | IRVINE | IRVINE | Irvine | |||||
bus_st | CA | CA | CA | CA | CA | |||||
bus_zip4 | 92627 | 92606 | 92606 | 92606 | 92614 | |||||
bus_phon | 949 646-1151 | 714 508-3600 | 714 508-3600 | 714 508-3600 | 714 845-8545 | |||||
bus_fax | None | None | None | None | None | |||||
bus_email | None | None | None | None | [email protected] | |||||
mail_city | None | None | None | None | None | |||||
mail_st | None | None | None | None | None | |||||
mail_zip4 | None | None | None | None | None | |||||
mail_phon | None | None | None | None | None | |||||
sig_date | 2004-12-22 00:00:00 | 2006-11-27 00:00:00 | 2008-12-05 00:00:00 | 2010-12-22 00:00:00 | 2019-05-15 00:00:00 | |||||
sig_loc | COSTA MESA, CA | IRVINE, CA | IRVINE, CA | IRVINE, CA | None | |||||
sig_naml | THOMAS | THORNE | THORNE | BRYANT | Burke | |||||
sig_namf | STEPHEN | STEPHEN | STEPHEN E. | JENNIFER | Dan | |||||
sig_namt | None | None | None | None | None | |||||
sig_nams | None | None | None | None | None | |||||
prn_naml | THOMAS | THORNE | THORNE | BRYANT | Burke | |||||
prn_namf | STEPHEN | STEPHEN | STEPHEN E. | JENNIFER | Dan | |||||
prn_namt | None | None | None | None | None | |||||
prn_nams | None | None | None | None | None | |||||
sig_title | PRESIDENT | PRESIDENT | PRESIDENT | CORPORATE COUNSEL | SVP, Platform Strategy & GC | |||||
stmt_firm | None | None | None | None | None | |||||
ind_cb | None | None | None | None | None | |||||
bus_cb | X | X | X | X | X | |||||
trade_cb | None | None | None | None | None | |||||
oth_cb | None | None | None | None | None | |||||
a_b_name | None | None | None | None | None | |||||
a_b_city | None | None | None | None | None | |||||
a_b_st | None | None | None | None | None | |||||
a_b_zip4 | None | None | None | None | None | |||||
descrip_1 | DENTAL PRACTICE MANAGEMENT ORGANIZATION | DENTAL PRACTICE MANAGEMENT ORGANIZATION | DENTAL PRACTICE MANAGEMENT ORGANIZATION | DENTAL PRACTICE MANAGEMENT ORGANIZATION | Dental practice management organization | |||||
descrip_2 | None | None | None | None | None | |||||
c_less50 | None | None | None | None | None | |||||
c_more50 | None | None | None | None | None | |||||
ind_class | None | None | None | None | None | |||||
ind_descr | None | None | None | None | None | |||||
bus_class | PRO | PRO | PRO | PRO | PRO | |||||
bus_descr | None | None | None | None | None | |||||
auth_name | KAHL/POWNALL ADVOCATES | KP PUBLIC AFFAIRS | KP PUBLIC AFFAIRS | KP PUBLIC AFFAIRS | Niemela, Pappas and Associates | |||||
auth_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | |||||
auth_st | CA | CA | CA | CA | CA | |||||
auth_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||
lobby_int | None | None | None | None | None | |||||
influen_yn | None | None | None | None | None | |||||
firm_name | None | None | None | None | None | |||||
newcert_cb | None | None | None | None | None | |||||
rencert_cb | None | None | None | None | None | |||||
complet_dt | None | None | None | None | None | |||||
lby_reg_cb | None | None | None | None | None | |||||
lby_604_cb | None | None | None | None | None | |||||
st_leg_yn | None | None | None | None | None | |||||
st_agency | None | None | None | None | None | |||||
lobby_cb | None | None | None | None | None | |||||
l_firm_cb | None | None | None | None | None |
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2092718 | 2067779 | 2080669 | 2113941 | 2165167 | 2206343 | 2482924 | 2508621 | 2547385 | |||||||||
effect_dt | 2005-07-01 00:00:00 | 2004-05-15 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 | 2019-05-13 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||
session_id | 2005 | 2003 | 2005 | 2007 | 2009 | 2011 | 2019 | 2021 | 2023 |
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1024730 | 1026304 | 1019482 | 1019484 | 1054215 | 1075569 | 1061565 | 1069753 | 1083129 | 1079861 | 1114062 | 1104218 | 1145884 | 1131223 | 1163089 | 1189384 | 1225384 | 1236431 | 1260001 | 1215870 | 1242043 | 1283060 | 1283060 | 1294355 | 1260001 | 1329302 | 1309880 | 1309880 | 1348434 | 1386417 | 1392943 | 1377341 | 1414862 | 1436672 | 1421094 | 1451342 | 1421094 | 1436672 | 1484504 | 1464192 | 1484504 | 1436672 | 1451342 | 1508223 | 1421094 | 1464192 | 1539133 | 1561115 | 1554290 | 1569363 | 1590676 | 2385358 | 2398762 | 2405372 | 2444235 | 2579802 | 2531971 | 2487770 | 2419132 | 2471562 | 2601824 | 2644367 | 2675911 | 2708149 | 2554609 | 2596443 | 2623700 | 2749067 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 178 | None | None | None | 179 | 180 | None | 181 | None | None | 182 | 181 | 184 | 183 | 185 | 186 | 188 | 188 | 189 | 187 | None | 190 | 190 | 191 | 189 | 193 | 192 | 192 | 194 | 196 | 196 | 195 | None | 198 | 197 | 199 | 197 | 198 | 201 | 200 | 201 | 198 | 199 | 202 | 197 | 200 | 203 | None | 204 | 204 | 205 | 238 | 238 | None | 240 | 245 | 243 | 242 | 239 | 241 | 246 | 248 | 249 | 250 | 244 | None | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F602 | F999 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 2 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2004-07-21 00:00:00 | 2004-07-26 00:00:00 | 2004-05-26 00:00:00 | 2004-05-27 00:00:00 | 2004-10-26 00:00:00 | 2005-01-26 00:00:00 | 2004-10-27 00:00:00 | 2005-01-04 00:00:00 | 2005-01-04 00:00:00 | 2005-01-26 00:00:00 | 2005-07-25 00:00:00 | 2005-04-29 00:00:00 | 2006-01-28 00:00:00 | 2005-10-26 00:00:00 | 2006-04-19 00:00:00 | 2006-07-28 00:00:00 | 2006-12-29 00:00:00 | 2007-01-30 00:00:00 | 2007-04-26 00:00:00 | 2006-10-30 00:00:00 | 2006-12-29 00:00:00 | 2007-07-30 00:00:00 | 2007-09-25 00:00:00 | 2007-10-23 00:00:00 | 2007-09-25 00:00:00 | 2008-04-30 00:00:00 | 2008-02-12 00:00:00 | 2008-01-30 00:00:00 | 2008-07-29 00:00:00 | 2008-12-30 00:00:00 | 2009-01-27 00:00:00 | 2008-10-30 00:00:00 | 2008-12-30 00:00:00 | 2009-07-30 00:00:00 | 2009-04-30 00:00:00 | 2009-10-29 00:00:00 | 2009-10-29 00:00:00 | 2009-10-29 00:00:00 | 2010-04-29 00:00:00 | 2010-01-31 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-07-08 00:00:00 | 2010-08-02 00:00:00 | 2010-10-29 00:00:00 | 2010-12-28 00:00:00 | 2010-12-28 00:00:00 | 2011-01-28 00:00:00 | 2011-04-29 00:00:00 | 2019-06-03 00:00:00 | 2019-07-31 00:00:00 | 2019-05-24 00:00:00 | 2020-01-31 00:00:00 | 2021-04-29 00:00:00 | 2020-11-02 00:00:00 | 2020-07-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2021-07-31 00:00:00 | 2022-01-31 00:00:00 | 2022-05-01 00:00:00 | 2022-08-01 00:00:00 | 2021-02-01 00:00:00 | 2021-02-11 00:00:00 | 2021-10-31 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | COMPLETED | LTHIBAUL | SARRIAGA | SARRIAGA | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | CFLAGG | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | MGUERRA | MGUERRA | YRODRIGU | MGUERRA | MGUERRA | MGUERRA | MGUERRA | MGUERRA | ASAETERN | MGUERRA | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | AGLADNEY | * | JBEAUDOIN | VUKSTINA | JBEAUDOIN | AGLADNEY | CHATRIDGE | GTAYLOR | MMERCHANT | SUSHAKOV | SUSHAKOV | MKIRKHAM | RATTIYEH | CAFILER | CAFILER | CREYNOLDS2 | MMERCHANT | MKIRKHAM | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-02 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-11-27 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-12-29 00:00:00 | 2008-10-01 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2010-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-22 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2019-05-15 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2005-01-02 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-11-27 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-29 00:00:00 | 2008-12-31 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2010-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-22 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2019-05-15 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | None | None | None | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2011 | 2005 | 2009 | 2007 | 2019 | 2021 | 2023 | ||||||||
interest_cd | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | ||||||||
effect_date | 2004-05-15 00:00:00 | 2011-01-01 00:00:00 | 2005-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2019-05-13 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||
active | Y | Y | Y | Y | Y | T | Y | Y | N | |||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
session_id | 2003 | 2005 | 2007 | 2011 | 2009 | 2011 | 2019 | 2021 | 2023 | |||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
effect_dt | 2004-05-15 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-31 00:00:00 | 2019-05-13 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | |||||||||
nyq_dt | None | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | None | None | None | None | None | None | |||||||||
party_cd | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
county_cd | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||
district_cd | 0 | 0 | 0 | None | None | None | None | None | None |
filer_id | 1265801 | |
---|---|---|
xref_id | 1265801 | |
effect_dt | 2004-05-27 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | COSTA MESA | COSTA MESA | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | IRVINE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | 92627 | 92627 | 92606 | 92606 | 92606 | 92606 | 92614 | 92614 | 92614 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | 9496461151 | 9496461151 | 7145083600 | 7145083600 | 7145083600 | 7145083600 | 7148458545 | 7148458545 | 7148458545 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 7145036400 | None | None | 7145036400 | None | None | 7145036400 | None | None | 7145036400 | None | None | 7145036400 | None | None | 7145036400 | None | None | 7145036400 | None | None | 7145036400 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] |
filer_id | 1265801 |
---|
filer_id | 1265801 | 1265801 | ||
---|---|---|---|---|
change_no | 0 | 1 | ||
session_id | 2003 | 2011 | ||
log_dt | 2004-05-26 00:00:00 | 2011-03-08 00:00:00 | ||
filer_type | 1 | 1 | ||
correction_flg | None | Y | ||
action | ADDED | DELETED | ||
attribute_changed | FIRM | FIRM | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | PACIFIC DENTAL SERVICES | PACIFIC DENTAL SERVICES | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 3 | 3 | ||
entity_name | KAHL/POWNALL ADVOCATES | KP PUBLIC AFFAIRS | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1147235 | 1147235 | ||
responsible_officer | None | None | ||
effect_dt | 2004-05-15 00:00:00 | 2011-01-31 00:00:00 |
filer_id | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | 1265801 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1024730_0.cal | 1054215_0.cal | 1075569_0.cal | 1104218_0.cal | 1114062_0.cal | 1131223_0.cal | 1145884_0.cal | 1163089_0.cal | 1189384_0.cal | 1329302_0.cal | 1436672_2.cal | 1451342_1.cal | 1464192_1.cal | 1484504_1.cal | 1508223_0.cal | 1421094_2.cal | 1392943_0.cal | 1348434_0.cal | 1484504_0.cal | 1451342_0.cal | 1421094_1.cal | 1436672_1.cal | 1215870_0.cal | 1236431_0.cal | 1464192_0.cal | 1283060_0.cal | 1260001_0.cal | 1421094_0.cal | 1436672_0.cal | 1260001_1.cal | 1283060_1.cal | 1294355_0.cal | 1377341_0.cal | 1309880_0.cal | 1309880_1.cal | 1539133_0.cal | 1569363_0.cal | 1590676_0.cal | 394068.cal | |||||||||||||||||||||||||||||||||||||||
received_date | 2004-07-21 00:00:00 | 2004-10-26 00:00:00 | 2005-01-26 00:00:00 | 2005-04-29 00:00:00 | 2005-07-25 00:00:00 | 2005-10-26 00:00:00 | 2006-01-28 00:00:00 | 2006-04-19 00:00:00 | 2006-07-28 00:00:00 | 2008-04-30 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-07-08 00:00:00 | 2009-01-27 00:00:00 | 2008-07-29 00:00:00 | 2010-04-29 00:00:00 | 2009-10-29 00:00:00 | 2009-10-29 00:00:00 | 2009-10-29 00:00:00 | 2006-10-30 00:00:00 | 2007-01-30 00:00:00 | 2010-01-31 00:00:00 | 2007-07-30 00:00:00 | 2007-04-26 00:00:00 | 2009-04-30 00:00:00 | 2009-07-30 00:00:00 | 2007-09-25 00:00:00 | 2007-09-25 00:00:00 | 2007-10-23 00:00:00 | 2008-10-30 00:00:00 | 2008-01-30 00:00:00 | 2008-02-12 00:00:00 | 2010-10-29 00:00:00 | 2011-01-28 00:00:00 | 2011-04-29 00:00:00 | 2020-11-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||
filing_directory | /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/temp | |||||||||||||||||||||||||||||||||||||||
filing_id | 1024730 | 1054215 | 1075569 | 1104218 | 1114062 | 1131223 | 1145884 | 1163089 | 1189384 | 1329302 | 1436672 | 1451342 | 1464192 | 1484504 | 1508223 | 1421094 | 1392943 | 1348434 | 1484504 | 1451342 | 1421094 | 1436672 | 1215870 | 1236431 | 1464192 | 1283060 | 1260001 | 1421094 | 1436672 | 1260001 | 1283060 | 1294355 | 1377341 | 1309880 | 1309880 | 1539133 | 1569363 | 1590676 | None | |||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | |||||||||||||||||||||||||||||||||||||||
receive_comment | 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 passed validation, but failed DB constraints |