schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, district, school_nces_id, school_state_id, school, school_state_type, ccd_school_type, ccd_charter_school, ccd_school_lvl, ccd_school_low_grade, ccd_school_high_grade, year, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "state" = :p0 and "year" = :p1 and (ccd_school_lvl > :p3 or (ccd_school_lvl = :p3 and rowid > :p2)) order by ccd_school_lvl, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
3104491	MO	school	2930520	12110	TWIN RIVERS R-X	293052002093	4040	FISK ELEMENTARY	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	16	16
3104497	MO	school	2930520	12110	TWIN RIVERS R-X	293052002094	4060	QULIN ELEMENTARY	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	18	18
3104509	MO	school	2905850	13054	BRECKENRIDGE R-I	290585000128	4020	BRECKENRIDGE ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	0	0
3104527	MO	school	2913590	13055	HAMILTON R-II	291359000579	4020	HAMILTON ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	43	43
3104533	MO	school	2922110	13057	NEW YORK R-IV	292211001227	4020	NEW YORK ELEM.	Regular School	No	Elementary	KG	08	2020	pre_kindergarten	0	0
3104539	MO	school	2910230	13058	COWGILL R-VI	291023000329	4020	COWGILL ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	11	11
3104557	MO	school	2925410	13059	POLO R-VII	292541001464	4020	POLO ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	22	22
3104563	MO	school	2921030	13060	MIRABILE C-1	292103001150	4020	MIRABILE ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	0	0
3104575	MO	school	2905820	13061	BRAYMER C-4	290582000126	4020	BRAYMER ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	5	5
3104581	MO	school	2916620	13062	KINGSTON 42	291662000908	4020	KINGSTON ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	7	7
3104593	MO	school	2922740	14126	NORTH CALLAWAY CO. R-I	292274001252	4020	AUXVASSE ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	18	18
3104599	MO	school	2922740	14126	NORTH CALLAWAY CO. R-I	292274001253	4040	HATTON-MCCREDIE ELEM.	Regular School	No	Elementary	KG	08	2020	pre_kindergarten	0	0
3104605	MO	school	2922740	14126	NORTH CALLAWAY CO. R-I	292274001255	4060	WILLIAMSBURG ELEM.	Regular School	No	Elementary	KG	08	2020	pre_kindergarten	0	0
3104617	MO	school	2921875	14127	NEW BLOOMFIELD R-III	292187501218	4020	NEW BLOOMFIELD ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	27	27
3104635	MO	school	2912550	14129	FULTON 58	291255000517	4010	BARTLEY ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3104641	MO	school	2912550	14129	FULTON 58	291255000518	4020	BUSH ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3104647	MO	school	2912550	14129	FULTON 58	291255000522	4080	MCINTIRE ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	85	85
3104665	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843003120	4010	SOUTH CALLAWAY EARLY CHD PK-02	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	5	5
3104671	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843001756	4020	SOUTH CALLAWAY ELEM.	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0	0
3104689	MO	school	2900020	14400	MO SCHOOL FOR THE DEAF	290002003023	4020	STARK ELEM.	Special Education School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3104701	MO	school	2929580	15001	STOUTLAND R-II	292958002045	4020	STOUTLAND ELEMENTARY	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	38	38
3104725	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEMENTARY	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	93	93
3104737	MO	school	2906990	15002	CAMDENTON R-III	290699000172	4040	HURRICANE DECK ELEMENTARY	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	18	18
3104743	MO	school	2906990	15002	CAMDENTON R-III	290699002983	4050	HAWTHORN ELEMENTARY	Regular School	No	Elementary	03	04	2020	pre_kindergarten	0	0
3104749	MO	school	2906990	15002	CAMDENTON R-III	290699000174	4080	OSAGE BEACH ELEMENTARY	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	14	14
3104761	MO	school	2909810	15003	CLIMAX SPRINGS R-IV	290981000283	4020	CLIMAX SPRINGS ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	13	13
3104773	MO	school	2919380	15004	MACKS CREEK R-V	291938001048	4020	MACKS CREEK ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	20	20
3104797	MO	school	2915600	16090	JACKSON R-II	291560000732	4015	ORCHARD DRIVE ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3104803	MO	school	2915600	16090	JACKSON R-II	291560000733	4060	GORDONVILLE ATTENDANCE CTR	Regular School	No	Elementary	KG	02	2020	pre_kindergarten	0	0
3104809	MO	school	2915600	16090	JACKSON R-II	291560000735	4100	MILLERSVILLE ATTENDANCE CTR.	Regular School	No	Elementary	KG	03	2020	pre_kindergarten	0	0
3104815	MO	school	2915600	16090	JACKSON R-II	291560000736	4110	NORTH ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3104821	MO	school	2915600	16090	JACKSON R-II	291560002248	4130	SOUTH ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3104826	MO	school	2915600	16090	JACKSON R-II	291560003265	4140	EAST ELEMENTARY	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	269	269
3104832	MO	school	2915600	16090	JACKSON R-II	291560000739	4160	WEST LANE ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3104844	MO	school	2910620	16092	DELTA R-V	291062000357	4020	DELTA ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	10	10
3104856	MO	school	2923070	16094	OAK RIDGE R-VI	292307001320	4020	OAK RIDGE ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	18	18
3104874	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000184	4020	ALMA SCHRADER ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3104880	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000187	4040	FRANKLIN ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	30	30
3104886	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712002722	4050	BLANCHARD ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	28	28
3104892	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000188	4060	CLIPPARD ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	114	114
3104898	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000189	4080	JEFFERSON ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	30	30
3104910	MO	school	2907320	16097	NELL HOLCOMB R-IV	290732000194	4020	NELL HOLCOMB ELEM.	Regular School	No	Elementary	KG	08	2020	pre_kindergarten	0	0
3104922	MO	school	2913500	17121	HALE R-I	291350000573	4020	HALE ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	0	0
3104934	MO	school	2930300	17122	TINA-AVALON R-II	293030002070	4020	TINA-AVALON ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	11	11
3104946	MO	school	2905610	17124	BOSWORTH R-V	290561000106	4020	BOSWORTH ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	8	8
3104964	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	Elementary	PK	01	2020	pre_kindergarten	21	21
3104970	MO	school	2907380	17125	CARROLLTON R-VII	290738003129	4010	CARROLLTON ELEMENTARY SCHOOL	Regular School	No	Elementary	02	04	2020	pre_kindergarten	0	0
3104982	MO	school	2922620	17126	NORBORNE R-VIII	292262001237	4020	NORBORNE ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105000	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	15	15
3105012	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	39	39
3105024	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	7	7
3105030	MO	school	2929670	19140	STRASBURG C-3	292967002051	4020	STRASBURG ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	0	0
3105051	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001426	4020	PECULIAR ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105057	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001427	4040	RAYMORE ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105066	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373002723	4060	STONEGATE ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105072	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001959	4070	TIMBER CREEK ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105078	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003024	4080	EAGLE GLEN ELEMENTARY	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105084	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373002913	4090	CREEKMOOR ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105090	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373002889	5000	BRIDLE RIDGE ELEMENTARY	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105111	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	41	41
3105117	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	0	0
3105135	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	44	44
3105141	MO	school	2925330	19148	PLEASANT HILL R-III	292533002803	4040	PLEASANT HILL ELEM.	Regular School	No	Elementary	03	04	2020	pre_kindergarten	0	0
3105170	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2020	pre_kindergarten	0	0
3105176	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000604	4040	MCEOWEN ELEM.	Regular School	No	Elementary	04	05	2020	pre_kindergarten	0	0
3105182	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	89	89
3105194	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	6	6
3105206	MO	school	2931800	19151	MIDWAY R-I	293180002223	4020	MIDWAY ELEM.	Regular School	No	Elementary	KG	06	2020	pre_kindergarten	0	0
3105224	MO	school	2904620	19152	BELTON 124	290462000051	4020	CAMBRIDGE ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105230	MO	school	2904620	19152	BELTON 124	290462000053	4040	HILLCREST STEAM ACADEMY	Regular School	No	Elementary	KG	06	2020	pre_kindergarten	0	0
3105241	MO	school	2904620	19152	BELTON 124	290462000052	4060	GLADDEN ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105253	MO	school	2904620	19152	BELTON 124	290462002988	4090	KENTUCKY TRAIL ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105278	MO	school	2929520	20001	STOCKTON R-I	292952002043	4020	STOCKTON ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105298	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	45	45
3105310	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	25	25
3105322	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	32	32
3105334	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	14	14
3105346	MO	school	2927520	21151	SALISBURY R-IV	292752001683	4040	SALISBURY ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	0	0
3105358	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	34	34
3105382	MO	school	2922530	22089	Nixa Public Schools	292253002504	4040	ESPY ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105388	MO	school	2922530	22089	Nixa Public Schools	292253002771	4050	CENTURY ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105400	MO	school	2922530	22089	Nixa Public Schools	292253001651	4070	MATHEWS ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105412	MO	school	2922530	22089	Nixa Public Schools	292253002998	4090	HIGH POINTE ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105418	MO	school	2922530	22089	Nixa Public Schools	292253003202	4100	JOHN THOMAS SCHOOL OF DISCOVER	Regular School	No	Elementary	KG	06	2020	pre_kindergarten	0	0
3105442	MO	school	2928740	22090	SPARTA R-III	292874001775	4020	SPARTA ELEM.	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0	0
3105460	MO	school	2905070	22091	BILLINGS R-IV	290507000065	4020	BILLINGS ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	30	30
3105472	MO	school	2909780	22092	CLEVER R-V	290978000281	4020	CLEVER ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	87	87
3105490	MO	school	2923430	22093	OZARK R-VI	292343002439	4040	SOUTH ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105502	MO	school	2923430	22093	OZARK R-VI	292343003001	4070	WEST ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105508	MO	school	2923430	22093	OZARK R-VI	292343001433	4080	EAST ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105514	MO	school	2923430	22093	OZARK R-VI	292343002727	4085	NORTH ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105516	MO	school	2923430	22093	OZARK R-VI	292343003333	7500	OZARK TIGERPAW EARLY CHILD CTR	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	160	160
3105534	MO	school	2928800	22094	SPOKANE R-VII	292880001778	4020	HIGHLANDVILLE ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	62	62
3105553	MO	school	2916380	23101	CLARK CO. R-I	291638000794	4040	BLACK HAWK ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105559	MO	school	2916380	23101	CLARK CO. R-I	291638000796	4060	RUNNING FOX ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105589	MO	school	2916450	24086	KEARNEY R-I	291645000891	4040	KEARNEY ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105595	MO	school	2916450	24086	KEARNEY R-I	291645002532	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105601	MO	school	2916450	24086	KEARNEY R-I	291645001434	4080	SOUTHVIEW ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105607	MO	school	2916450	24086	KEARNEY R-I	291645002862	5020	DOGWOOD ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3105608	MO	school	2916450	24086	KEARNEY R-I	291645003353	5040	LENS	Regular School	No	Elementary	03	04	2020	pre_kindergarten	0	0
3105628	MO	school	2928410	24087	SMITHVILLE R-II	292841001753	4020	Smithville Maple Elementary	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	11	11