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 "grade" = :p0 and "state" = :p1 and (ccd_charter_school > :p3 or (ccd_charter_school = :p3 and rowid > :p2)) order by ccd_charter_school, 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
3131059	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2019	grade_1	51	51
3131060	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2020	grade_1	37	37
3131061	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2015	grade_1	96	96
3131062	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2016	grade_1	77	77
3131063	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	112	112
3131064	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2018	grade_1	88	88
3131065	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_1	85	85
3131066	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2020	grade_1	108	108
3131067	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	grade_1	0	0
3131068	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2016	grade_1	0	0
3131069	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Elementary	PK	PK	2017	grade_1	0	0
3131070	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2018	grade_1	0	0
3131071	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2019	grade_1	0	0
3131072	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
3131073	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	3	07	12	2015	grade_1	0	0
3131074	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	3	07	12	2016	grade_1	0	0
3131075	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2017	grade_1	0	0
3131076	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2018	grade_1	0	0
3131077	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2019	grade_1	0	0
3131078	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	06	12	2020	grade_1	0	0
3131079	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2015	grade_1	27	27
3131080	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2016	grade_1	24	24
3131081	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2017	grade_1	25	25
3131082	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2018	grade_1	23	23
3131083	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2019	grade_1	21	21
3131084	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	32	32
3131085	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	3	07	12	2015	grade_1	0	0
3131086	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	3	07	12	2016	grade_1	0	0
3131087	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2017	grade_1	0	0
3131088	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2018	grade_1	0	0
3131089	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2019	grade_1	0	0
3131090	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2020	grade_1	0	0
3131091	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2015	grade_1	21	21
3131092	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2016	grade_1	23	23
3131093	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2017	grade_1	30	30
3131094	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2018	grade_1	27	27
3131095	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2019	grade_1	19	19
3131096	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2020	grade_1	29	29
3131097	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	3	07	12	2015	grade_1	0	0
3131098	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	3	07	12	2016	grade_1	0	0
3131099	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2017	grade_1	0	0
3131100	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2018	grade_1	0	0
3131101	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2019	grade_1	0	0
3131102	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2020	grade_1	0	0
3131103	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2015	grade_1	0	0
3131104	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2016	grade_1	8	8
3131105	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2017	grade_1	13	13
3131106	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2018	grade_1	9	9
3131107	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2019	grade_1	13	13
3131108	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2020	grade_1	11	11
3131109	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	4	06	12	2015	grade_1	0	0
3131110	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	4	06	12	2016	grade_1	0	0
3131111	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	Other	06	12	2017	grade_1	0	0
3131112	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2018	grade_1	0	0
3131113	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2019	grade_1	0	0
3131114	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2020	grade_1	0	0
3131115	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2015	grade_1	21	21
3131116	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2016	grade_1	18	18
3131117	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	14	14
3131118	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	19	19
3131119	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	15	15
3131120	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	27	27
3131121	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	3	07	12	2015	grade_1	0	0
3131122	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	3	07	12	2016	grade_1	0	0
3131123	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2017	grade_1	0	0
3131124	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2018	grade_1	0	0
3131125	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2019	grade_1	0	0
3131126	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2020	grade_1	0	0
3131127	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2015	grade_1	55	55
3131128	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2016	grade_1	45	45
3131129	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2017	grade_1	35	35
3131130	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2018	grade_1	35	35
3131131	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2019	grade_1	47	47
3131132	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2020	grade_1	45	45
3131133	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2015	grade_1	0	0
3131134	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2016	grade_1	0	0
3131135	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2017	grade_1	0	0
3131136	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2018	grade_1	0	0
3131137	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2019	grade_1	0	0
3131138	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2020	grade_1	0	0
3131139	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	2	06	08	2015	grade_1	0	0
3131140	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	2	06	08	2016	grade_1	0	0
3131141	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2017	grade_1	0	0
3131142	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2018	grade_1	0	0
3131143	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2019	grade_1	0	0
3131144	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2020	grade_1	0	0
3131145	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2015	grade_1	73	73
3131146	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2016	grade_1	76	76
3131147	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2017	grade_1	64	64
3131148	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2018	grade_1	58	58
3131149	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2019	grade_1	67	67
3131150	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	05	2020	grade_1	86	86
3131151	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2015	grade_1	74	74
3131152	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2016	grade_1	82	82
3131153	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2017	grade_1	77	77
3131154	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2018	grade_1	69	69
3131155	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_1	66	66
3131156	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	01	05	2020	grade_1	86	86
3131157	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2015	grade_1	41	41
3131158	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2016	grade_1	32	32
3131159	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	40	40