twoHelixestwoHelixes Start free

Datasets / Open Government Licence – Canada · Statistics Canada

Canada · K–12 facilities · school locations

Publicly sourced regional school directory. Location-only: no achievement scores or catchment polygons. Source dates and coverage vary; see /schools/region/ca.

Ask a question of it Download CSV Jupyter notebook Explore regional map
16,115 rows17 columns Open Government Licence – Canada · Statistics Canada

Worked examples

Each of these is a real run: the pipeline picked the columns, shaped the rows and chose the form. Open the trace to see what it decided and why.

Canada · K–12 facilities directory coverage

Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.

Canada · K–12 facilities directory records02k4k6kONQCABBCSKMBNSNBNLPENTNUYTGroup
How many school location records are in each region? — 13 rows charted from 16,115, drawn as a bar
Ask this yourself See the working
How it decided
Finding the data892 ms

Canada · K–12 facilities · school locations: 16,115 rows, 17 columns. The directory identifier and region classify source records; missing coordinates are still counted.

Shaping the data5 ms

16,115 rows in, 13 out across 2 columns. Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.

Choosing the chart4 ms

bar. A count comparison describes coverage without inventing achievement scores or attendance boundaries.

Applying defaults1 ms

Palette, spacing, axis titles and legend placement applied. 0 issues found.

Schema

17 columns, typed as the pipeline sees them — which is how it knows what can go on a time axis and what can be summed.

Column TypeExample
school_idtextb6326b14a88a60d3c896
school_nametextTricentia Academy
latitudenumber47.765
longitudenumber-53.9841
achievement_scoretext
ranktext
countrytextCA
regiontextNL
statetextNL
sectortextNot specified
school_typetextK12
addresstextBox 129, Arnold's Cove A0B 1A0
suburbtextArnold's Cove
postcodetextA0B 1A0
data_yeartext2023-09-30
source_school_codetext400924
districttextNewfoundland and Labrador English School

First 8 rows

school_idschool_namelatitudelongitudeachievement_scorerankcountryregionstatesectorschool_typeaddresssuburbpostcodedata_yearsource_school_codedistrict
b6326b14a88a60d3c896Tricentia Academy47.765-53.9841NoneNoneCANLNLNot specifiedK12Box 129, Arnold's Cove A0B 1A0Arnold's CoveA0B 1A02023-09-30400924Newfoundland and Labrador English School District
4b0989cde122afea0a95Roncalli Central High47.4192-53.1946NoneNoneCANLNLNot specifiedHP. O. Box 260, Avondale A0A 1B0AvondaleA0A 1B02023-09-30400247Newfoundland and Labrador English School District
79dcae69af352dcf6fc2Avoca Collegiate48.9764-56.042NoneNoneCANLNLNot specifiedEBox 190, Badger A0H 1A0BadgerA0H 1A02023-09-30300398Newfoundland and Labrador English School District
a4d11e968271c57fe5a1Copper Ridge Academy49.9244-56.227NoneNoneCANLNLNot specifiedK12Box 430, 9 Columbus Drive, Baie Verte A0K 1B0Baie VerteA0K 1B02023-09-30300125Newfoundland and Labrador English School District
5fd30011cac993fe37e4Amalgamated Academy47.5909-53.2769NoneNoneCANLNLNot specifiedIP.O. Box 460, Bay Roberts A0A 1G0Bay RobertsA0A 1G02023-09-30400248Newfoundland and Labrador English School District
0e51ac167b7ad5ec390bAscension Collegiate47.592-53.2834NoneNoneCANLNLNot specifiedSHBox 370, Bay Roberts A0A 1G0Bay RobertsA0A 1G02023-09-30400249Newfoundland and Labrador English School District
2401d73387fa5a110b7bTricon Elementary48.1098-52.9157NoneNoneCANLNLNot specifiedEP.O. Box 100, Bay de Verde A0A 1E0Bay de VerdeA0A 1E02023-09-30400433Newfoundland and Labrador English School District
96a0e8bfbbc2abd43d07St. Augustine's ElementarynannanNoneNoneCANLNLNot specifiedEP.O. Box 820, Bell Island A0A 4H0Bell IslandA0A 4H02023-09-30400294Newfoundland and Labrador English School District

Ask it something else

Map school locations by regionHow many school locations are in each region?Which schools have missing coordinates?
Start free