Data license: http://open.canada.ca/en/open-government-licence-canada · Data source: https://open.canada.ca/data/en/dataset/90fed587-1364-4f33-a9ee-208181dc0b97

Custom SQL query

all

province_territory, employer, address, occupations, positions_approved, phase, zipcode, city, stream

199,957 rows

all_fts (hidden)

employer, occupations, address, phase, province_territory, stream, all_fts, docid, __langid

199,957 rows

all_fts_docsize (hidden)

docid, size

199,957 rows

all_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

16 rows

all_fts_segments (hidden)

blockid, block

3,157 rows

all_fts_stat (hidden)

id, value

1 row

Queries

Download SQLite DB: all.db 48.7 MB