| filing_id | 1618983 | 1600559 | 1628606 | 1628606 | 1709294 | 1676765 | 1676765 | 1652752 | 1732962 | 1796271 | 1777651 | 1760324 | 1869793 | 1841977 | 1818148 | 1930909 | 1910039 | 1993078 | 1977973 | 1961339 | 2062209 | 2037448 | 2008224 | 2101848 | 2173259 | 2122599 | 2155221 | 2191599 | 2240130 | 2208840 | 2271825 | 2397440 | 2316524 | 2344653 | 2378405 | 2439319 | 2416794 | 2469596 | 2482270 | 2524668 | 2524668 | 2548931 | 2598255 | 2621852 | 2577160 | 2704418 | 2677088 | 2640632 | 2746820 | |||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 1 | 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 | 0 | 0 | 0 | 1 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| sender_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| filer_naml | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2011-10-24 00:00:00 | 2011-07-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 2012-10-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-04-18 00:00:00 | 2013-01-31 00:00:00 | 2013-10-31 00:00:00 | 2013-07-31 00:00:00 | 2013-04-30 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2014-01-31 00:00:00 | 2015-01-31 00:00:00 | 2014-10-31 00:00:00 | 2015-10-31 00:00:00 | 2015-07-31 00:00:00 | 2015-04-30 00:00:00 | 2016-07-01 00:00:00 | 2016-04-30 00:00:00 | 2016-01-31 00:00:00 | 2016-10-31 00:00:00 | 2017-07-31 00:00:00 | 2017-01-31 00:00:00 | 2017-04-30 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-01-31 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2020-07-31 00:00:00 | 2020-11-10 00:00:00 | 2020-10-31 00:00:00 | 2021-01-31 00:00:00 | 2021-07-31 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-07-31 00:00:00 | 2022-05-02 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
| from_date | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-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 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-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 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-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 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
| thru_date | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-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 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2015-09-30 00:00:00 | 2015-06-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 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 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 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
| cum_beg_dt | 2011-01-01 00:00:00 | 2011-01-11 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2011-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 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 | None | None | None | None | 20120517 | 20120517 | 20120517 | None | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | 20120517 | |||||||||||||||||||||||||||||||||||||||||||||||||
| firm_name | None | None | None | None | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | None | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | INDEPENDENT PHARMACY COORPERATIVE | |||||||||||||||||||||||||||||||||||||||||||||||||
| firm_city | LOUISVILLE | LOUISVILLE | LOUISVILLE | LOUISVILLE | LOUISVILLE | LOUISVILLE | LOUISVILLE | LOUISVILLE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | |||||||||||||||||||||||||||||||||||||||||||||||||
| firm_st | CO | CO | CO | CO | CO | CO | CO | CO | CO | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | WI | |||||||||||||||||||||||||||||||||||||||||||||||||
| firm_zip4 | 80027 | 80027 | 80027 | 80027 | 80027 | 80027 | 80027 | 80027 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | |||||||||||||||||||||||||||||||||||||||||||||||||
| firm_phon | 6084699913 | 6084699913 | 6084699913 | 6084699913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | 6084699913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | (608) 469-9913 | |||||||||||||||||||||||||||||||||||||||||||||||||
| mail_city | None | None | None | None | LOUISVILLE | LOUISVILLE | LOUISVILLE | None | LOUISVILLE | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | CO | CO | CO | None | CO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 80027 | 80027 | 80027 | None | 80027 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| sig_date | 2011-10-24 00:00:00 | 2011-07-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 2012-10-30 00:00:00 | 2012-10-30 00:00:00 | 2012-07-30 00:00:00 | 2012-04-18 00:00:00 | 2013-01-30 00:00:00 | 2013-10-18 00:00:00 | 2013-07-22 00:00:00 | 2013-04-30 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2014-01-31 00:00:00 | 2015-01-31 00:00:00 | 2014-10-31 00:00:00 | 2015-10-31 00:00:00 | 2015-07-31 00:00:00 | 2015-04-30 00:00:00 | 2016-07-31 00:00:00 | 2016-04-30 00:00:00 | 2016-01-31 00:00:00 | 2016-10-31 00:00:00 | 2017-07-31 00:00:00 | 2017-01-31 00:00:00 | 2017-04-30 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-01-31 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2020-07-31 00:00:00 | 2020-11-10 00:00:00 | 2020-10-31 00:00:00 | 2021-01-31 00:00:00 | 2021-07-31 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-07-31 00:00:00 | 2022-05-02 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
| sig_loc | Louisville CO | Louisville, CO | louisville, CO | Louisville, CO | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | louisville co | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | |||||||||||||||||||||||||||||||||||||||||||||||||
| sig_naml | Driscoll | Driscoll | Driscoll | Driscoll | LUCAS | LUCAS | LUCAS | driscoll | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | |||||||||||||||||||||||||||||||||||||||||||||||||
| sig_namf | Jim | Jim | Independment Pharmacy Cooperative | Jim | STEVEN S. | STEVEN S. | STEVEN S. | jim | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| prn_naml | Driscoll | Driscoll | Driscoll | Driscoll | LUCAS | LUCAS | LUCAS | driscoll | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | |||||||||||||||||||||||||||||||||||||||||||||||||
| prn_namf | Jim | Jim | Independment Pharmacy Cooperative | Jim | STEVEN S. | STEVEN S. | STEVEN S. | jim | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| sig_title | Director of GA | Director of Government Affairs | Director of Goverment Affaris | Director of Government Affairs | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | Director of Government Affairs | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| ctrib_n_cb | X | X | X | X | X | X | X | X | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | X | None | None | None | None | None | None | None | None | None | None | 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 | Ab399 and AB102 | none | Ab399 and AB102 | Ab399 and AB102 | AB 399; SB 616, SB 1195 | AB 399, SB 1195 | AB 399, SB 1195 | Ab399 and AB102 | AB 97, 399 | AB 467; SB 62, 306, 491, 493 | AB 97, 299, 670, 900, 1136; SB 204, 205 | AB 204, 205, 299, 399, 403, 670, 1136; SB 146, 493 | AB 1535, 2418; SB 204, 1315 | AB 1535, 2418; SB 506, 1014 | SB 493,727 | AB 45 | AB 1535, 2418; SB 1014 | AB 1069, 1073 | AB 627; SB 672 | AB 45, 627; SB 671 | AB 45, 2039, 2050, 2084, 2712; SB 482, 999, 1229; CALIFORNIA DEPARTMENT OF PUBLIC HEALTH - PHARMACY SURVEY | AB 2084, 2144; SB 482 | NO LEGISLATION ACTIVELY LOBBIED THIS QUARTER | AB 1114; SB 1194, 1195 | AB 315 | NO LEGISLATION ACTIVELY LOBBIED THIS QUARTER | AB 315, 602, 1512; SB 641 | AB 40, 315, 1048; SB 716, 790, 799 | AB 315 | AB 315 | AB 315, 2486, 2589; SB 212 | AB 1131; SB 159 | AB 315; SB 212 | AB 315 | AB 1131; SB 159 | EXECUTIVE ORDER N-01-19 (FEE-FOR-SERVICE MODEL) - GOVERNOR'S OFFICE | AB 1131; SB 159; EXECUTIVE ORDER N-01-19 (FEE-FOR-SERVICE MODEL) - GOVERNOR'S OFFICE | AB 2100; EXECUTIVE ORDER REGARDING COVID-19: GOVERNOR'S OFFICE | AB 2100 | AB 1710, 2100 | AB 1710, 2100 | NO LEGISLATIVE MATTERS LOBBIED THIS QUARTER | AB 671, 1064; SB 524 | AB 671, 1064; SB 254, 362 | AB 671, 1064; SB 524 | AB 671, 1064; SB 524 | AB 671, 1064; SB 524 | AB 671, 1064; SB 524 | AB 671, 1064; SB 524 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| major_namf | None | None | None | None | X | X | X | None | X | X | X | X | X | X | X | X | X | X | X | X | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 |
| filing_id | 1598276 | 1667869 | 1718575 | 1918882 | 2117254 | 2334796 | 2541654 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||
| form_type | F602 | F602 | F602 | F602 | F602 | F602 | F602 | |||||||
| sender_id | F24890 | F00933 | F00933 | F00933 | F00933 | F00933 | F00933 | |||||||
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||
| filer_naml | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | |||||||
| filer_namf | None | None | None | None | None | None | None | |||||||
| filer_namt | None | None | None | None | None | None | None | |||||||
| filer_nams | None | None | None | None | None | None | None | |||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||
| rpt_date | 2011-06-27 00:00:00 | 2012-05-17 00:00:00 | 2012-12-15 00:00:00 | 2014-12-15 00:00:00 | 2016-12-31 00:00:00 | 2018-12-31 00:00:00 | 2020-12-31 00:00:00 | |||||||
| ls_beg_yr | 2011 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | |||||||
| ls_end_yr | 2012 | 2012 | 2014 | 2016 | 2018 | 2020 | 2022 | |||||||
| qual_date | None | None | None | None | None | None | None | |||||||
| eff_date | 2011-06-17 00:00:00 | 2012-05-17 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||
| bus_city | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | |||||||
| bus_st | WI | WI | WI | WI | WI | WI | WI | |||||||
| bus_zip4 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | |||||||
| bus_phon | 6088254165 | 608 469-9913 | 608 469-9913 | 608 469-9913 | 608 469-9913 | 720 620-4475 | 720 620-4475 | |||||||
| bus_fax | None | None | None | None | None | None | None | |||||||
| bus_email | [email protected] | None | None | None | None | None | None | |||||||
| mail_city | None | None | None | None | None | None | None | |||||||
| mail_st | None | None | None | None | None | None | None | |||||||
| mail_zip4 | None | None | None | None | None | None | None | |||||||
| mail_phon | None | None | None | None | None | None | None | |||||||
| sig_date | 2011-06-15 00:00:00 | 2012-05-25 00:00:00 | 2012-11-19 00:00:00 | 2014-11-10 00:00:00 | 2016-12-31 00:00:00 | 2018-12-31 00:00:00 | 2020-12-31 00:00:00 | |||||||
| sig_loc | None | SUN PRAIRIE, WI | SUN PRAIRIE, WI | SUN PRAIRIE, WI | SUN PRAIRIE, WI | SUN PRAIRIE, WI | SUN PRAIRIE, WI | |||||||
| sig_naml | DRISCOLL | DRISCOLL | DRISCOLL | YOUNG | DRISCOLL | DRISCOLL | DRISCOLL | |||||||
| sig_namf | JIM | JIM | JIM | BRAD | JIM | JIM | JIM | |||||||
| sig_namt | None | None | None | None | None | None | None | |||||||
| sig_nams | None | None | None | None | None | None | None | |||||||
| prn_naml | DRISCOLL | DRISCOLL | DRISCOLL | YOUNG | DRISCOLL | DRISCOLL | DRISCOLL | |||||||
| prn_namf | JIM | JIM | JIM | BRAD | JIM | JIM | JIM | |||||||
| prn_namt | None | None | None | None | None | None | None | |||||||
| prn_nams | None | None | None | None | None | None | None | |||||||
| sig_title | DIRECTOR STATE GOVERNMENT AFFAIRS | DIRECTOR OF GOVERNMENT AFFAIRS | DIRECTOR OF GOVERNMENT AFFAIRS | DIRECTOR OF GOVERNMENT AFFAIRS | DIRECTOR OF GOVERNMENT AFFAIRS | DIRECTOR OF GOVERNMENT AFFAIRS | DIRECTOR OF GOVERNMENT AFFAIRS | |||||||
| stmt_firm | None | None | None | None | None | None | None | |||||||
| ind_cb | None | None | None | None | None | None | None | |||||||
| bus_cb | X | None | None | None | None | None | None | |||||||
| trade_cb | None | None | None | None | None | None | None | |||||||
| oth_cb | None | X | X | X | X | X | X | |||||||
| a_b_name | None | None | None | None | None | None | None | |||||||
| a_b_city | None | None | None | None | None | None | None | |||||||
| a_b_st | None | None | None | None | None | None | None | |||||||
| a_b_zip4 | None | None | None | None | None | None | None | |||||||
| descrip_1 | PHARMACY COOPERATIVE | CO-OP | CO-OP | CO-OP | CO-OP | CO-OP | CO-OP | |||||||
| descrip_2 | None | PHARMACIES | PHARMACIES | PHARMACIES | PHARMACIES | PHARMACIES | PHARMACIES | |||||||
| c_less50 | None | None | None | None | None | None | None | |||||||
| c_more50 | None | None | None | None | None | None | None | |||||||
| ind_class | HEA | HEA | HEA | HEA | HEA | HEA | HEA | |||||||
| ind_descr | None | None | None | None | None | None | None | |||||||
| bus_class | None | None | None | None | None | None | None | |||||||
| bus_descr | None | None | None | None | None | None | None | |||||||
| auth_name | BROWNSTEIN HYATT FARBER SCHRECK, LLP | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI, LLP | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI, LLP | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI, LLP | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI, LLP | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI, LLP | |||||||
| auth_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||
| auth_st | CA | CA | CA | CA | CA | CA | CA | |||||||
| auth_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||
| lobby_int | None | None | None | None | None | None | None | |||||||
| influen_yn | None | None | None | None | None | None | None | |||||||
| firm_name | None | None | None | None | None | None | None | |||||||
| newcert_cb | None | None | None | None | None | None | None | |||||||
| rencert_cb | None | None | None | None | None | None | None | |||||||
| complet_dt | None | None | None | None | None | None | None | |||||||
| lby_reg_cb | None | None | None | None | None | None | None | |||||||
| lby_604_cb | None | None | None | None | None | None | None | |||||||
| st_leg_yn | None | None | None | None | None | None | None | |||||||
| st_agency | None | None | None | None | None | None | None | |||||||
| lobby_cb | None | None | None | None | None | None | None | |||||||
| l_firm_cb | None | None | None | None | None | None | None |
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2417063 | 2508526 | 2273216 | 2216578 | 2338154 | 2467907 | 2549799 | |||||||
| effect_dt | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-05-21 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||
| session_id | 2017 | 2021 | 2013 | 2011 | 2015 | 2019 | 2023 |
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1760324 | 1777651 | 1796271 | 1961339 | 1951888 | 1910039 | 1596936 | 1600559 | 1598276 | 1598463 | 1628606 | 1628606 | 1618983 | 1652752 | 1676765 | 1669295 | 1818148 | 1667869 | 1680919 | 1930909 | 1918882 | 1718575 | 1676765 | 1709294 | 1869793 | 1742493 | 1732962 | 1841977 | 1977973 | 2524668 | 2208840 | 2341431 | 2316524 | 2378405 | 2008224 | 1993078 | 2037448 | 2062209 | 2101848 | 2117254 | 2137357 | 2122599 | 2173259 | 2155221 | 2344653 | 2271825 | 2439319 | 2524668 | 2416794 | 2577160 | 2583512 | 2482270 | 2598255 | 2334796 | 2397440 | 2191599 | 2240130 | 2469596 | 2548931 | 2677088 | 2621852 | 2640632 | 2704418 | 2541654 | 2746820 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 213 | 214 | 215 | 221 | None | 219 | None | 206 | 206 | None | 208 | 208 | 207 | 209 | 210 | None | 216 | 210 | None | 220 | 220 | 212 | 210 | 211 | 218 | None | 212 | 217 | 222 | 243 | 232 | None | 235 | 237 | 224 | 223 | 225 | 226 | 227 | 228 | None | 228 | 230 | 229 | 236 | 234 | 240 | 243 | 239 | 245 | None | 242 | 246 | 236 | 238 | 231 | 233 | 241 | 244 | 249 | 247 | 248 | 250 | 244 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F635 | F635 | F635 | F635 | F602 | F635 | F603 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F605 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2013-04-22 00:00:00 | 2013-07-23 00:00:00 | 2013-10-22 00:00:00 | 2015-04-23 00:00:00 | 2014-12-17 00:00:00 | 2014-10-30 00:00:00 | 2011-06-07 00:00:00 | 2011-07-15 00:00:00 | 2011-06-27 00:00:00 | 2011-06-21 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 2011-10-24 00:00:00 | 2012-04-18 00:00:00 | 2012-07-30 00:00:00 | 2012-05-17 00:00:00 | 2014-01-31 00:00:00 | 2012-06-04 00:00:00 | 2012-07-31 00:00:00 | 2015-01-27 00:00:00 | 2014-12-18 00:00:00 | 2012-12-19 00:00:00 | 2012-10-31 00:00:00 | 2012-10-31 00:00:00 | 2014-07-30 00:00:00 | 2012-12-18 00:00:00 | 2013-01-26 00:00:00 | 2014-04-26 00:00:00 | 2015-07-27 00:00:00 | 2020-11-10 00:00:00 | 2018-01-30 00:00:00 | 2019-01-11 00:00:00 | 2018-10-30 00:00:00 | 2019-04-29 00:00:00 | 2016-01-27 00:00:00 | 2015-10-21 00:00:00 | 2016-05-02 00:00:00 | 2016-07-29 00:00:00 | 2016-10-31 00:00:00 | 2017-01-04 00:00:00 | 2016-12-30 00:00:00 | 2017-01-24 00:00:00 | 2017-07-28 00:00:00 | 2017-04-28 00:00:00 | 2019-01-30 00:00:00 | 2018-07-30 00:00:00 | 2020-01-30 00:00:00 | 2020-10-28 00:00:00 | 2019-10-29 00:00:00 | 2021-04-26 00:00:00 | 2021-01-04 00:00:00 | 2020-07-28 00:00:00 | 2021-07-28 00:00:00 | 2019-01-16 00:00:00 | 2019-07-31 00:00:00 | 2017-10-30 00:00:00 | 2018-04-28 00:00:00 | 2020-04-29 00:00:00 | 2021-01-28 00:00:00 | 2022-05-02 00:00:00 | 2021-10-29 00:00:00 | 2022-01-28 00:00:00 | 2022-07-29 00:00:00 | 2020-12-31 00:00:00 | 2022-10-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2011 | 2013 | 2015 | 2013 | 2011 | 2011 | 2013 | 2013 | 2011 | 2013 | 2015 | 2019 | 2017 | 2019 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | ASAETERN | ASAETERN | AGLADNEY | MPACHECO | SARRIAGA | ASAETERN | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | AGLADNEY | SARRIAGA | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | ASAETERN | MPACHECO | GTAYLOR | AGLADNEY | PBANFORD | AGLADNEY | SUSHAKOV | MPACHECO | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | SUSHAKOV | GTAYLOR | MMERCHANT | MKIRKHAM | GTAYLOR | PBANFORD | SUSHAKOV | AGLADNEY | AGLADNEY | GTAYLOR | CHARTRIDGE | CAFILER | CHATRIDGE | CHATRIDGE | CAFILER | MMERCHANT | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-06-27 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-10-01 00:00:00 | 2012-05-17 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-15 00:00:00 | 2012-12-15 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2015-04-01 00:00:00 | 2020-07-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-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 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-04-01 00:00:00 | 2019-10-01 00:00:00 | 2020-07-01 00:00:00 | 2019-07-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2018-12-31 00:00:00 | 2019-04-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2020-12-31 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-06-27 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-12-31 00:00:00 | 2012-05-17 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-15 00:00:00 | 2012-12-15 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2015-06-30 00:00:00 | 2020-09-30 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 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 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2020-09-30 00:00:00 | 2019-09-30 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2017 | 2011 | 2013 | 2019 | 2015 | 2021 | 2023 | |||||||
| interest_cd | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | |||||||
| effect_date | 2017-01-01 00:00:00 | 2011-05-21 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 1 | 2 | 1 | 1 | 1 | 1 | 1 | |||||||
| active | Y | Y | Y | Y | Y | Y | N | |||||||
| race | None | 0 | None | None | None | None | None | |||||||
| session_id | 2013 | 2011 | 2017 | 2019 | 2021 | 2015 | 2023 | |||||||
| category | None | 0 | None | None | None | None | None | |||||||
| category_type | None | 0 | None | None | None | None | None | |||||||
| sub_category | None | 0 | None | None | None | None | None | |||||||
| effect_dt | 2013-01-01 00:00:00 | 2011-05-21 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||
| sub_category_type | None | 0 | None | None | None | None | None | |||||||
| election_type | None | 0 | None | None | None | None | None | |||||||
| sub_category_a | None | None | None | None | None | None | None | |||||||
| nyq_dt | None | None | None | None | None | None | None | |||||||
| party_cd | None | 0 | None | None | None | None | None | |||||||
| county_cd | None | 0 | None | None | None | None | None | |||||||
| district_cd | None | 0 | None | None | None | None | None |
| filer_id | 1339274 | |
|---|---|---|
| xref_id | 1339274 | |
| effect_dt | 2011-06-15 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||||||||||||||||||||||||||||||||||||||||||||||
| filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | |||||||||||||||||||||||||||||||||||||||||||||||||
| status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||||||||||||||||||||||||||||||||||||||||||
| effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
| naml | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | |||||||||||||||||||||||||||||||||||||||||||||||||
| namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| city | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | LOUISVILLE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | SUN PRAIRIE | |||||||||||||||||||||||||||||||||||||||||||||||||
| st | CO | WI | WI | WI | WI | WI | WI | CO | WI | WI | WI | WI | WI | WI | CO | WI | WI | WI | WI | WI | WI | CO | WI | WI | WI | WI | WI | WI | CO | WI | WI | WI | WI | WI | WI | CO | WI | WI | WI | WI | WI | WI | CO | WI | WI | WI | WI | WI | WI | |||||||||||||||||||||||||||||||||||||||||||||||||
| zip4 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | 80027 | 53590 | 53590 | 53590 | 53590 | 53590 | 53590 | |||||||||||||||||||||||||||||||||||||||||||||||||
| phon | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | 6084699913 | 6084699913 | 6084699913 | 6084699913 | 7206264475 | 7206204475 | 7206204475 | |||||||||||||||||||||||||||||||||||||||||||||||||
| fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None |
| filer_id | 1339274 |
|---|
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | ||||
|---|---|---|---|---|---|---|---|---|
| change_no | 0 | 2 | 3 | 4 | ||||
| session_id | 2011 | 2011 | 2011 | 2011 | ||||
| log_dt | 2011-06-21 00:00:00 | 2011-06-07 00:00:00 | 2012-01-05 00:00:00 | 2012-07-31 00:00:00 | ||||
| filer_type | 2 | 2 | 2 | 2 | ||||
| correction_flg | Y | Y | Y | Y | ||||
| action | ADDED | ADDED | DELETED | DELETED | ||||
| attribute_changed | FIRM | LOBBYIST | FIRM | LOBBYIST | ||||
| ethics_dt | None | None | None | None | ||||
| interests | None | None | None | None | ||||
| filer_full_name | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | INDEPENDENT PHARMACY COOPERATIVE | ||||
| filer_city | None | None | None | None | ||||
| filer_st | None | None | None | None | ||||
| filer_zip | None | None | None | None | ||||
| filer_phone | None | None | None | None | ||||
| entity_type | 3 | 4 | 3 | 4 | ||||
| entity_name | BROWNSTEIN HYATT FARBER SCHRECK, LLP | DRISCOLL, JAMES R. | BROWNSTEIN HYATT FARBER SCHRECK, LLP | DRISCOLL, JAMES R. | ||||
| entity_city | None | None | None | None | ||||
| entity_st | None | None | None | None | ||||
| entity_zip | None | None | None | None | ||||
| entity_phone | None | None | None | None | ||||
| entity_id | 1147758 | 1339276 | 1147758 | 1339276 | ||||
| responsible_officer | None | None | None | None | ||||
| effect_dt | 2011-06-17 00:00:00 | 2011-05-21 00:00:00 | 2011-12-20 00:00:00 | 2012-06-30 00:00:00 |
| filer_id | 1339274 | 1339274 | 1339274 | 1339274 | 1339274 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 229772.cal | 347575.cal | 347360.cal | 471534.cal | 15721.cal | |||||
| received_date | 2014-01-31 00:00:00 | 2012-10-31 00:00:00 | 2012-10-31 00:00:00 | 2020-04-29 00:00:00 | 2019-10-29 00:00:00 | |||||
| filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||||
| filing_id | None | None | None | None | None | |||||
| form_id | None | None | None | None | None | |||||
| receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |