| filing_id | 2465965 | 2522787 | 2482167 | 2546950 | 2578573 | 2617892 | 2578573 | 2635509 | 2595107 | 2676228 | 2704360 | 2676228 | 2578573 | 2676228 | 2595107 | 2747028 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 1 | 2 | 0 | 1 | 0 | ||||||||||||||||
| rec_type | 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 | ||||||||||||||||
| sender_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | ||||||||||||||||
| filer_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | ||||||||||||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||
| filer_naml | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | ||||||||||||||||
| filer_namf | 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 | ||||||||||||||||
| filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 002 | 000 | 001 | 002 | 000 | 001 | 000 | ||||||||||||||||
| rpt_date | 2020-04-16 00:00:00 | 2020-10-26 00:00:00 | 2020-07-28 00:00:00 | 2021-01-25 00:00:00 | 2021-04-29 00:00:00 | 2021-10-22 00:00:00 | 2021-04-29 00:00:00 | 2022-01-20 00:00:00 | 2021-07-21 00:00:00 | 2022-05-27 00:00:00 | 2022-07-29 00:00:00 | 2022-05-27 00:00:00 | 2022-05-27 00:00:00 | 2022-05-02 00:00:00 | 2022-05-27 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||
| from_date | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||
| thru_date | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-30 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||
| cum_beg_dt | 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-02-18 00:00:00 | 2021-02-18 00:00:00 | 2021-02-18 00:00:00 | 2021-02-18 00:00:00 | None | 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-02-18 00:00:00 | 2021-01-01 00:00:00 | 2021-02-18 00:00:00 | ||||||||||||||||
| firm_id | 1425699 | 1425699 | 1425699 | 1425699 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
| firm_name | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
| firm_city | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | ||||||||||||||||
| firm_st | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | ||||||||||||||||
| firm_zip4 | 44505-2405 | 44505-2405 | 44505-2405 | 44505-2405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | ||||||||||||||||
| firm_phon | (330) 746-1064 | (330) 746-1064 | (330) 746-1064 | (330) 746-1064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | ||||||||||||||||
| mail_city | 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 | ||||||||||||||||
| mail_zip4 | 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 | ||||||||||||||||
| sig_date | 2020-04-16 00:00:00 | 2020-10-26 00:00:00 | 2020-07-28 00:00:00 | 2021-01-25 00:00:00 | 2021-04-29 00:00:00 | 2021-10-22 00:00:00 | 2021-04-29 00:00:00 | 2022-01-20 00:00:00 | 2021-07-21 00:00:00 | 2022-05-27 00:00:00 | 2022-07-29 00:00:00 | 2022-05-27 00:00:00 | 2022-05-27 00:00:00 | 2022-05-02 00:00:00 | 2022-05-27 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||
| sig_loc | Youngstown OH | Youngstown OH | Youngstown OH | Youngstown OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown, OH | Youngstown | Youngstown, OH | Youngstown, OH | ||||||||||||||||
| sig_naml | Weimer | Weimer | Weimer | Weimer | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | ||||||||||||||||
| sig_namf | William A | William A | William A | William A | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | ||||||||||||||||
| sig_namt | Mr. | Mr. | Mr. | Mr. | 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 | ||||||||||||||||
| prn_naml | Weimer | Weimer | Weimer | Weimer | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | Peart | ||||||||||||||||
| prn_namf | William A | William A | William A | William A | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | Danial | ||||||||||||||||
| prn_namt | Mr. | Mr. | Mr. | Mr. | 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 | ||||||||||||||||
| sig_title | VP and General Counsel | VP and General Counsel | VP and General Counsel | VP and General Counsel | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | Director Government Affairs | ||||||||||||||||
| nopart1_cb | 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 | ||||||||||||||||
| part1_1_cb | 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 | ||||||||||||||||
| ctrib_n_cb | X | X | X | X | X | X | X | X | None | X | X | X | X | X | None | X | ||||||||||||||||
| ctrib_y_cb | None | None | None | None | None | None | None | None | X | None | None | None | None | None | X | None | ||||||||||||||||
| lby_actvty | See attached TEXT | See attached TEXT | See attached TEXT | See attached TEXT | Lobbied the legislature re: SB 277 | Lobbied the legislature and governor's office re: SB 277 and AB 1588 | Lobbied the legislature re: SB 277 | Lobbied the legislature and governor's office and state agencies re: SB 277 and AB 1588 | Lobbied the legislature re: SB 277 | Lobbied the legislature and governor's office and state agencies re: SB 277 and AB 1588 | Lobbied the legislature and governor's office and state agencies re: SB 277 and AB 1588 | Lobbied the legislature and governor's office and state agencies re: SB 277 and AB 1588 | Lobbied the legislature re: SB 277 | Lobbied the legislature and governor's office and state agencies re: SB 277 and AB 1588 | Lobbied the legislature re: SB 277 | Lobbied the legislature and governor's office and state agencies re: SB 277 and AB 1588 | ||||||||||||||||
| lobby_n_cb | 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 | ||||||||||||||||
| major_naml | 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 | ||||||||||||||||
| major_namt | 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 | ||||||||||||||||
| rcpcmte_nm | 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 |
| filing_id | 2536645 | 2461872 | ||
|---|---|---|---|---|
| amend_id | 0 | 0 | ||
| rec_type | CVR | CVR | ||
| form_type | F602 | F602 | ||
| sender_id | F00944 | F00944 | ||
| filer_id | 1425699 | 1425699 | ||
| entity_cd | LEM | LEM | ||
| filer_naml | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | ||
| filer_namf | None | None | ||
| filer_namt | None | None | ||
| filer_nams | None | None | ||
| report_num | 000 | 000 | ||
| rpt_date | 2020-12-11 00:00:00 | 2020-03-09 00:00:00 | ||
| ls_beg_yr | 2021 | 2019 | ||
| ls_end_yr | 2022 | 2020 | ||
| qual_date | None | None | ||
| eff_date | 2020-03-09 00:00:00 | 2020-03-09 00:00:00 | ||
| bus_city | YOUNGSTOWN | YOUNGSTOWN | ||
| bus_st | OH | OH | ||
| bus_zip4 | 44505-2405 | 44505-2405 | ||
| bus_phon | (330) 746-1064 | (330) 746-1064 | ||
| bus_fax | 330-746-4410 | None | ||
| bus_email | [email protected] | None | ||
| mail_city | None | None | ||
| mail_st | None | None | ||
| mail_zip4 | None | None | ||
| mail_phon | None | None | ||
| sig_date | 2020-11-23 00:00:00 | 2020-03-06 00:00:00 | ||
| sig_loc | Youngstown OH | Youngstown OH | ||
| sig_naml | Weimer | Weimer | ||
| sig_namf | William A | William A | ||
| sig_namt | Mr. | Mr. | ||
| sig_nams | None | None | ||
| prn_naml | Weimer | Weimer | ||
| prn_namf | William A | William A | ||
| prn_namt | Mr. | Mr. | ||
| prn_nams | None | None | ||
| sig_title | VP and General Counsel | VP and General Counsel | ||
| stmt_firm | None | None | ||
| ind_cb | None | X | ||
| bus_cb | X | None | ||
| trade_cb | None | None | ||
| oth_cb | None | None | ||
| a_b_name | None | None | ||
| a_b_city | None | None | ||
| a_b_st | None | None | ||
| a_b_zip4 | None | None | ||
| descrip_1 | Fireworks Import/Export, Storage, Wholesale Distribution | None | ||
| descrip_2 | None | None | ||
| c_less50 | None | None | ||
| c_more50 | None | None | ||
| ind_class | None | None | ||
| ind_descr | None | None | ||
| bus_class | None | None | ||
| bus_descr | None | None | ||
| auth_name | REVELL COMMUNICATIONS | REVELL COMMUNICATIONS | ||
| auth_city | Roseville | Roseville | ||
| auth_st | CA | CA | ||
| auth_zip4 | 95661-4244 | 95661-4244 | ||
| lobby_int | None | None | ||
| influen_yn | None | None | ||
| firm_name | None | None | ||
| newcert_cb | None | None | ||
| rencert_cb | None | None | ||
| complet_dt | None | None | ||
| lby_reg_cb | None | None | ||
| lby_604_cb | None | None | ||
| st_leg_yn | None | None | ||
| st_agency | None | None | ||
| lobby_cb | None | None | ||
| l_firm_cb | None | None |
| filer_id | 1425699 | 1425699 | 1425699 | |||
|---|---|---|---|---|---|---|
| adrid | 2491684 | 2509379 | 2550550 | |||
| effect_dt | 2020-03-09 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||
| add_type | 7051 | 7051 | 7051 | |||
| session_id | 2019 | 2021 | 2023 |
| filer_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2578573 | 2548268 | 2461872 | 2522787 | 2462036 | 2462050 | 2482167 | 2617892 | 2578573 | 2602866 | 2676228 | 2704360 | 2465965 | 2595107 | 2676228 | 2578573 | 2536645 | 2546950 | 2676228 | 2635509 | 2595107 | 2747028 | ||||||||||||||||||||||
| period_id | 245 | None | 241 | 243 | None | None | 242 | 247 | 245 | None | 249 | 250 | 241 | 246 | 249 | 245 | 244 | 244 | 249 | 248 | 246 | 251 | ||||||||||||||||||||||
| form_id | F635 | F602 | F602 | F635 | F602 | F999 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
| filing_date | 2021-04-29 00:00:00 | 2020-12-15 00:00:00 | 2020-03-09 00:00:00 | 2020-10-26 00:00:00 | 2020-03-09 00:00:00 | 2020-03-09 00:00:00 | 2020-07-28 00:00:00 | 2021-10-22 00:00:00 | 2021-04-29 00:00:00 | 2021-02-22 00:00:00 | 2022-05-27 00:00:00 | 2022-07-29 00:00:00 | 2020-04-16 00:00:00 | 2022-05-27 00:00:00 | 2022-05-27 00:00:00 | 2022-05-27 00:00:00 | 2020-12-11 00:00:00 | 2021-01-25 00:00:00 | 2022-05-02 00:00:00 | 2022-01-20 00:00:00 | 2021-07-21 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||
| stmnt_type | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10002 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||
| session_id | 2021 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||
| user_id | GTAYLOR | MMERCHANT | GPEREZ | GTAYLOR | GPEREZ | GPEREZ | GTAYLOR | GTAYLOR | GTAYLOR | SARRIAGA | CAFILER | CAFILER | VUKSTINA | CAFILER | CAFILER | CAFILER | MMERCHANT | GTAYLOR | LPHEAV | MKIRKHAM | GTAYLOR | 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 | ||||||||||||||||||||||
| fine_audit | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||
| rpt_start | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-03-09 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-12-11 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||
| rpt_end | 2021-03-30 00:00:00 | 1900-01-01 00:00:00 | 2020-03-09 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-30 00:00:00 | 1900-01-01 00:00:00 | 2022-03-30 00:00:00 | 2022-06-30 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2020-12-11 00:00:00 | 2020-12-31 00:00:00 | 2022-03-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-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 | ||||||||||||||||||||||
| filing_type | 22006 | None | 22001 | 22001 | None | None | 22001 | 22006 | 22006 | None | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 |
| filer_id | 1425699 | 1425699 | 1425699 | 1425699 | ||||
|---|---|---|---|---|---|---|---|---|
| session_id | 2019 | 2023 | 2021 | 2021 | ||||
| interest_cd | 40312 | 40310 | 40312 | 40310 | ||||
| effect_date | 2020-03-09 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-19 00:00:00 |
| filer_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 1 | 1 | 1 | 1 | 1 | |||||
| active | Y | Y | T | Y | N | |||||
| race | None | 0 | None | None | None | |||||
| session_id | 2021 | 2019 | 2021 | 2021 | 2023 | |||||
| category | None | 0 | None | None | None | |||||
| category_type | None | 0 | None | None | None | |||||
| sub_category | None | 0 | None | None | None | |||||
| effect_dt | 2021-02-19 00:00:00 | 2020-03-09 00:00:00 | 2021-01-12 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||
| sub_category_type | None | 0 | None | None | None | |||||
| election_type | None | 0 | None | None | None | |||||
| sub_category_a | None | None | None | None | None | |||||
| nyq_dt | None | None | None | None | None | |||||
| party_cd | None | 0 | None | None | None | |||||
| county_cd | None | 0 | None | None | None | |||||
| district_cd | None | 0 | None | None | None |
| filer_id | 1425699 | |
|---|---|---|
| xref_id | 1425699 | |
| effect_dt | 2020-03-05 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | |||||||||
| filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | |||||||||
| status | 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 | |||||||||
| naml | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | |||||||||
| namf | None | None | None | None | None | None | None | None | None | |||||||||
| namt | None | None | None | None | None | None | None | None | None | |||||||||
| nams | None | None | None | None | None | None | None | None | None | |||||||||
| adr1 | None | None | None | None | None | None | None | None | None | |||||||||
| adr2 | None | None | None | None | None | None | None | None | None | |||||||||
| city | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | YOUNGSTOWN | |||||||||
| st | OH | OH | OH | OH | OH | OH | OH | OH | OH | |||||||||
| zip4 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | 445052405 | |||||||||
| phon | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | 3307461064 | |||||||||
| fax | 3307464410 | 3307464410 | 3307464410 | |||||||||||||||
| [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
| filer_id | 1425699 |
|---|
| filer_id | 1425699 | 1425699 | ||
|---|---|---|---|---|
| change_no | 1 | 0 | ||
| session_id | 2019 | 2019 | ||
| log_dt | 2020-03-09 00:00:00 | 2020-03-09 00:00:00 | ||
| filer_type | 1 | 1 | ||
| correction_flg | None | None | ||
| action | SET ACTIVE | ADDED | ||
| attribute_changed | FIRM | |||
| ethics_dt | None | None | ||
| interests | None | None | ||
| filer_full_name | PHANTOM FIREWORKS WESTERN REGION, LLC | PHANTOM FIREWORKS WESTERN REGION, LLC | ||
| filer_city | None | None | ||
| filer_st | None | None | ||
| filer_zip | None | None | ||
| filer_phone | None | None | ||
| entity_type | 1 | 3 | ||
| entity_name | None | REVELL COMMUNICATIONS | ||
| entity_city | None | None | ||
| entity_st | None | None | ||
| entity_zip | None | None | ||
| entity_phone | None | None | ||
| entity_id | 0 | 1147314 | ||
| responsible_officer | None | None | ||
| effect_dt | 2020-03-09 00:00:00 | 2020-03-09 00:00:00 |
| filer_id | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | 1425699 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 2465965_0.cal | 2482167_0.cal | 2522787_0.cal | 2546950_0.cal | 119954.cal | 149923.cal | ||||||
| received_date | 2020-04-16 00:00:00 | 2020-07-28 00:00:00 | 2020-10-26 00:00:00 | 2021-01-25 00:00:00 | 2020-12-11 00:00:00 | 2021-01-27 00:00:00 | ||||||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | ||||||
| filing_id | 2465965 | 2482167 | 2522787 | 2546950 | None | None | ||||||
| form_id | F635 | F635 | F635 | F635 | None | None | ||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |