lobbyist_registry

Data license: Open Government Licence – Toronto · Data source: Toronto Open Data · About: Built by Ram Vasuthevan with ❤️ on the shoulders of giants

Custom SQL query

Queries

Tables

beneficiaries

id, sm_number, type, name, trade_name, fiscal_start, fiscal_end

9,551 rows

beneficiary_business_addresses

id, beneficiary_id, address_line1, address_line2, city, province, country, postal_code

9,551 rows

communications

id, sm_number, registrant_id, poh_office, poh_type, poh_position, poh_name, communication_method, communication_date, communication_group_id, lobbyist_number, lobbyist_type, lobbyist_prefix, lobbyist_first_name, lobbyist_middle_initials, lobbyist_last_name, lobbyist_suffix, lobbyist_business, lobbyist_position_title, lobbyist_previous_public_office_holder, lobbyist_previous_public_office_hold_position, lobbyist_previous_public_office_position_program_name, lobbyist_previous_public_office_hold_last_date

127,370 rows

firm_business_addresses

id, firm_id, address_line1, address_line2, city, province, country, postal_code

17,445 rows

firms

id, sm_number, type, name, trade_name, fiscal_start, fiscal_end, description, business_type

17,445 rows

gmtfundings

id, sm_number, gmt_name, program

583 rows

grassroots

id, sm_number, community, start_date, end_date, target

585 rows

lobbyist_business_addresses

id, communication_id, address_line1, address_line2, city, province, country, postal_code, phone

127,370 rows

meeting_lobbyists

id, meeting_id, number, prefix, first_name, middle_initials, last_name, suffix, business, type

524 rows

meetings

id, sm_number, committee, desc, date

109 rows

pohs

id, meeting_id, name, office, title, type

115 rows

privatefundings

id, sm_number, funding, contact, agent, agent_contact

461 rows

registrant_business_addresses

id, registrant_id, address_line1, address_line2, city, province, country, postal_code, phone

13,327 rows

registrants

id, registration_number, status, effective_date, type, prefix, first_name, middle_initials, last_name, suffix, position_title, previous_public_office_holder, previous_public_office_hold_position, previous_public_office_position_program_name, previous_public_office_hold_last_date

13,327 rows

subject_matters

sm_number, status, type, subject_matter, particulars, subject_matter_definition, initial_approval_date, effective_date, proposed_start_date, proposed_end_date, registrant_id

13,327 rows

beneficiaries_fts (hidden)

id, sm_number, type, name, trade_name, fiscal_start, fiscal_end, beneficiaries_fts, rank

9,551 rows

beneficiaries_fts_config (hidden)

k, v

1 row

beneficiaries_fts_data (hidden)

id, block

132 rows

beneficiaries_fts_docsize (hidden)

id, sz

9,551 rows

beneficiaries_fts_idx (hidden)

segid, term, pgno

117 rows

beneficiary_business_addresses_fts (hidden)

id, beneficiary_id, address_line1, address_line2, city, province, country, postal_code, beneficiary_business_addresses_fts, rank

9,551 rows

beneficiary_business_addresses_fts_config (hidden)

k, v

1 row

beneficiary_business_addresses_fts_data (hidden)

id, block

160 rows

beneficiary_business_addresses_fts_docsize (hidden)

id, sz

9,551 rows

beneficiary_business_addresses_fts_idx (hidden)

segid, term, pgno

130 rows

communications_fts (hidden)

id, sm_number, registrant_id, poh_office, poh_type, poh_position, poh_name, communication_method, communication_date, communication_group_id, lobbyist_number, lobbyist_type, lobbyist_prefix, lobbyist_first_name, lobbyist_middle_initials, lobbyist_last_name, lobbyist_suffix, lobbyist_business, lobbyist_position_title, lobbyist_previous_public_office_holder, lobbyist_previous_public_office_hold_position, lobbyist_previous_public_office_position_program_name, lobbyist_previous_public_office_hold_last_date, communications_fts, rank

127,370 rows

communications_fts_config (hidden)

k, v

1 row

communications_fts_data (hidden)

id, block

5,355 rows

communications_fts_docsize (hidden)

id, sz

127,370 rows

communications_fts_idx (hidden)

segid, term, pgno

2,542 rows

firm_business_addresses_fts (hidden)

id, firm_id, address_line1, address_line2, city, province, country, postal_code, firm_business_addresses_fts, rank

17,445 rows

firm_business_addresses_fts_config (hidden)

k, v

1 row

firm_business_addresses_fts_data (hidden)

id, block

295 rows

firm_business_addresses_fts_docsize (hidden)

id, sz

17,445 rows

firm_business_addresses_fts_idx (hidden)

segid, term, pgno

234 rows

firms_fts (hidden)

id, sm_number, type, name, trade_name, fiscal_start, fiscal_end, description, business_type, firms_fts, rank

17,445 rows

firms_fts_config (hidden)

k, v

1 row

firms_fts_data (hidden)

id, block

426 rows

firms_fts_docsize (hidden)

id, sz

17,445 rows

firms_fts_idx (hidden)

segid, term, pgno

492 rows

gmtfundings_fts (hidden)

id, sm_number, gmt_name, program, gmtfundings_fts, rank

583 rows

gmtfundings_fts_config (hidden)

k, v

1 row

gmtfundings_fts_data (hidden)

id, block

10 rows

gmtfundings_fts_docsize (hidden)

id, sz

583 rows

gmtfundings_fts_idx (hidden)

segid, term, pgno

8 rows

grassroots_fts (hidden)

id, sm_number, community, start_date, end_date, target, grassroots_fts, rank

585 rows

grassroots_fts_config (hidden)

k, v

1 row

grassroots_fts_data (hidden)

id, block

19 rows

grassroots_fts_docsize (hidden)

id, sz

585 rows

grassroots_fts_idx (hidden)

segid, term, pgno

17 rows

lobbyist_business_addresses_fts (hidden)

id, communication_id, address_line1, address_line2, city, province, country, postal_code, phone, lobbyist_business_addresses_fts, rank

127,370 rows

lobbyist_business_addresses_fts_config (hidden)

k, v

1 row

lobbyist_business_addresses_fts_data (hidden)

id, block

1,657 rows

lobbyist_business_addresses_fts_docsize (hidden)

id, sz

127,370 rows

lobbyist_business_addresses_fts_idx (hidden)

segid, term, pgno

1,155 rows

meeting_lobbyists_fts (hidden)

id, meeting_id, number, prefix, first_name, middle_initials, last_name, suffix, business, type, meeting_lobbyists_fts, rank

524 rows

meeting_lobbyists_fts_config (hidden)

k, v

1 row

meeting_lobbyists_fts_data (hidden)

id, block

8 rows

meeting_lobbyists_fts_docsize (hidden)

id, sz

524 rows

meeting_lobbyists_fts_idx (hidden)

segid, term, pgno

6 rows

meetings_fts (hidden)

id, sm_number, committee, desc, date, meetings_fts, rank

109 rows

meetings_fts_config (hidden)

k, v

1 row

meetings_fts_data (hidden)

id, block

4 rows

meetings_fts_docsize (hidden)

id, sz

109 rows

meetings_fts_idx (hidden)

segid, term, pgno

2 rows

pohs_fts (hidden)

id, meeting_id, name, office, title, type, pohs_fts, rank

115 rows

pohs_fts_config (hidden)

k, v

1 row

pohs_fts_data (hidden)

id, block

5 rows

pohs_fts_docsize (hidden)

id, sz

115 rows

pohs_fts_idx (hidden)

segid, term, pgno

3 rows

privatefundings_fts (hidden)

id, sm_number, funding, contact, agent, agent_contact, privatefundings_fts, rank

461 rows

privatefundings_fts_config (hidden)

k, v

1 row

privatefundings_fts_data (hidden)

id, block

9 rows

privatefundings_fts_docsize (hidden)

id, sz

461 rows

privatefundings_fts_idx (hidden)

segid, term, pgno

7 rows

registrant_business_addresses_fts (hidden)

id, registrant_id, address_line1, address_line2, city, province, country, postal_code, phone, registrant_business_addresses_fts, rank

13,327 rows

registrant_business_addresses_fts_config (hidden)

k, v

1 row

registrant_business_addresses_fts_data (hidden)

id, block

340 rows

registrant_business_addresses_fts_docsize (hidden)

id, sz

13,327 rows

registrant_business_addresses_fts_idx (hidden)

segid, term, pgno

270 rows

registrants_fts (hidden)

id, registration_number, status, effective_date, type, prefix, first_name, middle_initials, last_name, suffix, position_title, previous_public_office_holder, previous_public_office_hold_position, previous_public_office_position_program_name, previous_public_office_hold_last_date, registrants_fts, rank

13,327 rows

registrants_fts_config (hidden)

k, v

1 row

registrants_fts_data (hidden)

id, block

256 rows

registrants_fts_docsize (hidden)

id, sz

13,327 rows

registrants_fts_idx (hidden)

segid, term, pgno

176 rows

subject_matters_fts (hidden)

sm_number, status, type, subject_matter, particulars, subject_matter_definition, initial_approval_date, effective_date, proposed_start_date, proposed_end_date, registrant_id, subject_matters_fts, rank

13,327 rows

subject_matters_fts_config (hidden)

k, v

1 row

subject_matters_fts_data (hidden)

id, block

975 rows

subject_matters_fts_docsize (hidden)

id, sz

13,327 rows

subject_matters_fts_idx (hidden)

segid, term, pgno

597 rows

Download SQLite DB: lobbyist_registry.db 87.3 MB