filing_id | 2601600 | 2622823 | 2584014 | 2702036 | 2644788 | 2674066 | 2746054 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||
form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||
sender_id | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | |||||||
filer_id | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | |||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||
filer_naml | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | |||||||
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 | 2021-07-31 00:00:00 | 2021-10-31 00:00:00 | 2021-05-13 00:00:00 | 2022-07-31 00:00:00 | 2022-01-31 00:00:00 | 2022-04-30 00:00:00 | 2022-10-31 00:00:00 | |||||||
from_date | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||
thru_date | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | |||||||
cum_beg_dt | 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 | None | None | None | |||||||
firm_name | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | |||||||
firm_city | OTTAWA | OTTAWA | OTTAWA | OTTAWA | OTTAWA | OTTAWA | OTTAWA | |||||||
firm_st | ON | ON | ON | ON | ON | ON | ON | |||||||
firm_zip4 | K2P2L8 | K2P2L8 | K2P2L8 | K2P2L8 | K2P2L8 | K2P2L8 | K2P2L8 | |||||||
firm_phon | (416) 885-3477 | (416) 885-3477 | (416) 885-3477 | (416) 885-3477 | (416) 885-3477 | (416) 885-3477 | (416) 885-3477 | |||||||
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 | 2021-07-26 00:00:00 | 2021-10-22 00:00:00 | 2021-05-13 00:00:00 | 2022-07-25 00:00:00 | 2022-01-24 00:00:00 | 2022-04-20 00:00:00 | 2022-10-19 00:00:00 | |||||||
sig_loc | OTTAWA,ON | OTTAWA,ON | OTTAWA,ON | OTTAWA,ON | OTTAWA,ON | OTTAWA,ON | OTTAWA,ON | |||||||
sig_naml | FRASCA | FRASCA | FRASCA | FRASCA | FRASCA | FRASCA | FRASCA | |||||||
sig_namf | JOE | JOE | JOE | JOE | JOE | JOE | JOE | |||||||
sig_namt | None | None | None | None | None | None | None | |||||||
sig_nams | None | None | None | None | None | None | None | |||||||
prn_naml | FRASCA | FRASCA | FRASCA | FRASCA | FRASCA | FRASCA | FRASCA | |||||||
prn_namf | JOE | JOE | JOE | JOE | JOE | JOE | JOE | |||||||
prn_namt | None | None | None | None | None | None | None | |||||||
prn_nams | None | None | None | None | None | None | None | |||||||
sig_title | CHIEF LEGAL OFFICER | CHIEF LEGAL OFFICER | CHIEF LEGAL OFFICER | CHIEF LEGAL OFFICER | CHIEF LEGAL OFFICER | CHIEF LEGAL OFFICER | CHIEF LEGAL OFFICER | |||||||
nopart1_cb | None | None | None | None | None | None | None | |||||||
nopart2_cb | None | None | None | None | None | None | None | |||||||
part1_1_cb | None | None | None | None | None | None | None | |||||||
part1_2_cb | None | None | None | None | None | None | None | |||||||
ctrib_n_cb | X | X | X | X | X | X | X | |||||||
ctrib_y_cb | None | None | None | None | None | None | None | |||||||
lby_actvty | AB 13, 488, 1182 | LEGISLATURE AND ADMINISTRATION RE: AB 488 | AB 13, 1182, 1402, SB 301 | CA STATE LEGISLATURE AND ADMINISTRATION RE: SB 301 | NONE | CA STATE LEGISLATURE AND ADMINISTRATION RE: SB 301 | CA STATE LEGISLATURE AND ADMINISTRATION RE: SB 301 | |||||||
lobby_n_cb | None | None | None | None | None | None | None | |||||||
lobby_y_cb | None | None | None | None | None | None | None | |||||||
major_naml | None | None | None | None | None | None | None | |||||||
major_namf | None | None | None | None | None | None | None | |||||||
major_namt | None | None | None | None | None | None | None | |||||||
major_nams | None | None | None | None | None | None | None | |||||||
rcpcmte_nm | None | None | None | None | None | None | None | |||||||
rcpcmte_id | None | None | None | None | None | None | None |
filing_id | 2584013 | |
---|---|---|
amend_id | 0 | |
rec_type | CVR | |
form_type | F602 | |
sender_id | 1282555 | |
filer_id | 1438327 | |
entity_cd | LEM | |
filer_naml | SHOPIFY, INC. | |
filer_namf | None | |
filer_namt | None | |
filer_nams | None | |
report_num | 000 | |
rpt_date | 2021-02-18 00:00:00 | |
ls_beg_yr | 2021 | |
ls_end_yr | 2022 | |
qual_date | None | |
eff_date | 2021-01-31 00:00:00 | |
bus_city | OTTAWA | |
bus_st | ON | |
bus_zip4 | K2P2L8 | |
bus_phon | (416) 885-3477 | |
bus_fax | None | |
bus_email | None | |
mail_city | None | |
mail_st | None | |
mail_zip4 | None | |
mail_phon | None | |
sig_date | 2021-02-18 00:00:00 | |
sig_loc | OTTAWA, ON | |
sig_naml | FRASCA | |
sig_namf | JOE | |
sig_namt | None | |
sig_nams | None | |
prn_naml | FRASCA | |
prn_namf | JOE | |
prn_namt | None | |
prn_nams | None | |
sig_title | CHIEF LEGAL OFFICER (444600MM) | |
stmt_firm | None | |
ind_cb | None | |
bus_cb | X | |
trade_cb | None | |
oth_cb | None | |
a_b_name | None | |
a_b_city | None | |
a_b_st | None | |
a_b_zip4 | None | |
descrip_1 | E-COMMERCE | |
descrip_2 | None | |
c_less50 | None | |
c_more50 | None | |
ind_class | None | |
ind_descr | None | |
bus_class | MER | |
bus_descr | None | |
auth_name | FERNANDEZ CERVANTES GOVERNMENT AFFAIRS | |
auth_city | SACRAMENTO | |
auth_st | CA | |
auth_zip4 | 95814 | |
lobby_int | None | |
influen_yn | None | |
firm_name | None | |
newcert_cb | None | |
rencert_cb | None | |
complet_dt | None | |
lby_reg_cb | None | |
lby_604_cb | None | |
st_leg_yn | None | |
st_agency | None | |
lobby_cb | None | |
l_firm_cb | None |
filer_id | 1438327 | 1438327 | ||
---|---|---|---|---|
adrid | 2545937 | 2518171 | ||
effect_dt | 2023-01-01 00:00:00 | 2021-01-31 00:00:00 | ||
add_type | 7051 | 7051 | ||
session_id | 2023 | 2021 |
filer_id | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | 1438327 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2601600 | 2605073 | 2622823 | 2702036 | 2674066 | 2584013 | 2644788 | 2584014 | 2746054 | |||||||||
period_id | 246 | None | 247 | 250 | 249 | 245 | 248 | 245 | 251 | |||||||||
form_id | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | |||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||
filing_date | 2021-07-30 00:00:00 | 2021-03-05 00:00:00 | 2021-10-29 00:00:00 | 2022-07-27 00:00:00 | 2022-04-28 00:00:00 | 2021-05-13 00:00:00 | 2022-01-31 00:00:00 | 2021-05-13 00:00:00 | 2022-10-29 00:00:00 | |||||||||
stmnt_type | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | |||||||||
session_id | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||
user_id | GTAYLOR | CVANLIEW | MKIRKHAM | CAFILER | CAFILER | CVANLIEW | GTAYLOR | AROJAS | CAFILER | |||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||
fine_audit | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||
rpt_start | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-02-18 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||
rpt_end | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-02-18 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||
rpt_date | None | None | None | None | None | None | None | None | None | |||||||||
filing_type | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1438327 | 1438327 | ||
---|---|---|---|---|
session_id | 2021 | 2023 | ||
interest_cd | 40311 | 40311 | ||
effect_date | 2021-01-31 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1438327 | 1438327 | ||
---|---|---|---|---|
filer_type | 1 | 1 | ||
active | N | Y | ||
race | None | 0 | ||
session_id | 2023 | 2021 | ||
category | None | 0 | ||
category_type | None | 0 | ||
sub_category | None | 0 | ||
effect_dt | 2023-01-01 00:00:00 | 2021-01-31 00:00:00 | ||
sub_category_type | None | 0 | ||
election_type | None | 0 | ||
sub_category_a | None | None | ||
nyq_dt | None | None | ||
party_cd | None | 0 | ||
county_cd | None | 0 | ||
district_cd | None | 0 |
filer_id | 1438327 | |
---|---|---|
xref_id | 1438327 | |
effect_dt | 2021-05-13 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1438327 | 1438327 | 1438327 | 1438327 | ||||
---|---|---|---|---|---|---|---|---|
filer_id | 1438327 | 1438327 | 1438327 | 1438327 | ||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | ||||
status | 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 | ||||
naml | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | SHOPIFY, INC. | ||||
namf | None | None | None | None | ||||
namt | None | None | None | None | ||||
nams | None | None | None | None | ||||
adr1 | None | None | None | None | ||||
adr2 | None | None | None | None | ||||
city | None | None | None | None | ||||
st | None | None | None | None | ||||
zip4 | ||||||||
phon | None | None | None | None | ||||
fax | None | None | None | None | ||||
None | None | None | None |
filer_id | 1438327 |
---|