Datasets / Queensland Department of Education · CC BY 4.0

Queensland school directory (May 2020)

Historical school addresses, sectors and coordinates. NAPLAN results are unavailable; achievement scores and ranks are missing, not zero. Explore the map at /schools.

Ask a question of it Download CSV Jupyter notebook Explore school map

1,774 rows16 columns Queensland Department of Education · CC BY 4.0

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.

School directory entries by sector (2020)

Counts describe the historical directory. Achievement data is not included.

How many schools are in each sector? — 2 rows charted from 1,774, drawn as a bar

Ask this yourself See the working

How it decided

Finding the data628 ms

Queensland school directory (May 2020): 1,774 rows, 16 columns. Queensland Department of Education school directory, May 2020, CC BY 4.0.

Shaping the data4 ms

1,774 rows in, 2 out across 2 columns. Counts describe the historical directory. Achievement data is not included.

Choosing the chart11 ms

bar. Bars compare counts across sectors; missing NAPLAN scores are not treated as zero.

Applying defaults1 ms

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

Schema

16 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	Type	Example
school_id	text	5817
school_name	text	A B Paterson College (Arundel)
address	text	10 A B Paterson Drive
suburb	text	Arundel
postcode	number	4214
state	text	QLD
sector	text	Non-State
school_type	text	Non-State School
latitude	number	-27.9277
longitude	number	153.3604
location_year	number	2020
achievement_score	text
rank	text
coverage	text
assessment_year	text
year_levels	text

First 8 rows

school_id	school_name	address	suburb	postcode	state	sector	school_type	latitude	longitude	location_year	achievement_score	rank	coverage	assessment_year
5817	A B Paterson College (Arundel)	10 A B Paterson Drive	Arundel	4214	QLD	Non-State	Non-State School	-27.9277	153.3604	2020	None	None	None	None
591	Abercorn State School	957 Wuruma Dam Road	Abercorn	4627	QLD	State	State School	-25.136	151.127	2020	None	None	None	None
1275	Abergowrie State School	5 Venables Road	Abergowrie	4850	QLD	State	State School	-18.4747	145.8835	2020	None	None	None	None
5588	Aboriginal & Islander Independent Community School (Acacia Ridge)	1277 Beaudesert Road	Acacia Ridge	4110	QLD	Non-State	Non-State School	-27.5816	153.0258	2020	None	None	None	None
25	Acacia Ridge State School	Nyngam Street	Acacia Ridge	4110	QLD	State	State School	-27.5796	153.0161	2020	None	None	None	None
1983	Agnes Water State School	1 Donohue Drive	Agnes Water	4677	QLD	State	State School	-24.214	151.9106	2020	None	None	None	None
598	Airville State School	Old Clare Road	Airville	4807	QLD	State	State School	-19.6552	147.3476	2020	None	None	None	None
801	Aitkenvale State School	67-85 Wotton Street	Aitkenvale	4814	QLD	State	State School	-19.2968	146.7631	2020	None	None	None	None

Ask it something else

How many schools are in each sector?Show school locations on a map Which schools are in Brisbane?

Start free