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 order by school_nces_id desc 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	male	female	total	male_int	female_int	total_int
1166230	IN	school		5375	M S D Wayne Township		5271	Sanders School						2015	grade_1	2.0	1.0	3.0	2	1	3
1287632	IN	school		5375	M S D Wayne Township		5271	Sanders School						2016	grade_1	3.0	0.0	3.0	3	0	3
1299669	IN	school		5375	M S D Wayne Township		5271	Sanders School						2017	grade_1	3.0	0.0	3.0	3	0	3
1758207	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_1	6.0	0.0	6.0	6	0	6
1793997	IN	school		5375	M S D Wayne Township		5271	Sanders School						2018	grade_1	2.0	2.0	4.0	2	2	4
1908015	IN	school		940	West Clark Community Schools		767	Henryville Elementary School						2020	grade_1	50.0	43.0	93.0	50	43	93
1908047	IN	school		940	West Clark Community Schools		815	William W Borden Elementary School						2020	grade_1	25.0	17.0	42.0	25	17	42
1908055	IN	school		940	West Clark Community Schools		818	Silver Creek Primary School						2020	grade_1	90.0	92.0	182.0	90	92	182
1913635	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_1	4.0	0.0	4.0	4	0	4
1927188	IN	school		6520	Porter Township School Corp		6811	Porter County Education Services						2021	grade_1	0.0	1.0	1.0	0	1	1
1927239	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_1	0.0	1.0	1.0	0	1	1
1927323	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_1	2.0	2.0	4.0	2	2	4
1164261	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary Sch	Regular School	No	1.0	PK	05	2015	grade_1	28.0	30.0	58.0	28	30	58
1285668	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	1.0	KG	05	2016	grade_1	17.0	21.0	38.0	17	21	38
1297714	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	Elementary	PK	05	2017	grade_1	20.0	18.0	38.0	20	18	38
1756308	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	Elementary	KG	06	2019	grade_1	19.0	28.0	47.0	19	28	47
1792072	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	Elementary	PK	05	2018	grade_1	18.0	24.0	42.0	18	24	42
1911765	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	Elementary	KG	06	2020	grade_1	18.0	18.0	36.0	18	18	36
1923733	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	Elementary	KG	06	2021	grade_1	20.0	25.0	45.0	20	25	45
1164249	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	1.0	PK	05	2015	grade_1	26.0	15.0	41.0	26	15	41
1285656	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	1.0	PK	05	2016	grade_1	19.0	33.0	52.0	19	33	52
1297702	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	Elementary	PK	05	2017	grade_1	33.0	21.0	54.0	33	21	54
1756299	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	Elementary	PK	06	2019	grade_1	22.0	38.0	60.0	22	38	60
1792060	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	Elementary	PK	05	2018	grade_1	28.0	24.0	52.0	28	24	52
1911756	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	Elementary	PK	06	2020	grade_1	27.0	22.0	49.0	27	22	49
1923724	IN	school	1813230	4455	Whitko Community School Corp	181323002084	3642	Pierceton Elementary School	Regular School	No	Elementary	PK	06	2021	grade_1	27.0	23.0	50.0	27	23	50
1165111	IN	school	1813200	4760	Whiting School City	181320002081	4361	Nathan Hale Elementary School	Regular School	No	1.0	PK	05	2015	grade_1	25.0	39.0	64.0	25	39	64
1286506	IN	school	1813200	4760	School City of Whiting	181320002081	4361	Nathan Hale Elementary School	Regular School	No	1.0	PK	05	2016	grade_1	22.0	37.0	59.0	22	37	59
1298545	IN	school	1813200	4760	School City of Whiting	181320002081	4361	Nathan Hale Elementary School	Regular School	No	Elementary	PK	05	2017	grade_1	42.0	34.0	76.0	42	34	76
1757073	IN	school	1813200	4760	School City of Whiting	181320002081	4361	Nathan Hale Elementary School	Regular School	No	Elementary	PK	05	2019	grade_1	28.0	26.0	54.0	28	26	54
1792864	IN	school	1813200	4760	School City of Whiting	181320002081	4361	Nathan Hale Elementary School	Regular School	No	Elementary	PK	05	2018	grade_1	39.0	27.0	66.0	39	27	66
1912509	IN	school	1813200	4760	School City of Whiting	181320002081	4361	Nathan Hale Elementary School	Regular School	No	Elementary	PK	05	2020	grade_1	37.0	45.0	82.0	37	45	82
1924459	IN	school	1813200	4760	School City of Whiting	181320002081	4361	Nathan Hale Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1	24.0	31.0	55.0	24	31	55
1164299	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	1.0	KG	04	2015	grade_1	35.0	34.0	69.0	35	34	69
1285705	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	27.0	32.0	59.0	27	32	59
1297752	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	33.0	29.0	62.0	33	29	62
1756349	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	29.0	27.0	56.0	29	27	56
1792111	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	39.0	34.0	73.0	39	34	73
1911806	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1	35.0	28.0	63.0	35	28	63
1923774	IN	school	1813110	4525	Westview School Corporation	181311002078	3698	Topeka Elementary School	Regular School	No	Elementary	KG	04	2021	grade_1	30.0	33.0	63.0	30	33	63
1164315	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elem School	Regular School	No	1.0	KG	04	2015	grade_1	37.0	29.0	66.0	37	29	66
1285722	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elementary Sch	Regular School	No	1.0	KG	04	2016	grade_1	27.0	37.0	64.0	27	37	64
1297769	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elementary Sch	Regular School	No	Elementary	KG	04	2017	grade_1	32.0	34.0	66.0	32	34	66
1756367	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elementary Sch	Regular School	No	Elementary	KG	04	2019	grade_1	29.0	35.0	64.0	29	35	64
1792129	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elementary Sch	Regular School	No	Elementary	KG	04	2018	grade_1	27.0	32.0	59.0	27	32	59
1911824	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elementary Sch	Regular School	No	Elementary	KG	04	2020	grade_1	40.0	43.0	83.0	40	43	83
1923792	IN	school	1813110	4525	Westview School Corporation	181311002077	3714	Shipshewana-Scott Elementary Sch	Regular School	No	Elementary	KG	04	2021	grade_1	42.0	40.0	82.0	42	40	82
1164308	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary Sch	Regular School	No	1.0	KG	05	2015	grade_1	34.0	36.0	70.0	34	36	70
1285714	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	1.0	KG	06	2016	grade_1	54.0	49.0	103.0	54	49	103
1297761	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	05	2017	grade_1	42.0	22.0	64.0	42	22	64
1756358	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2019	grade_1	38.0	29.0	67.0	38	29	67
1792120	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2018	grade_1	51.0	35.0	86.0	51	35	86
1911815	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2020	grade_1	39.0	42.0	81.0	39	42	81
1923783	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2021	grade_1	45.0	34.0	79.0	45	34	79
1162539	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	1.0	PK	04	2015	grade_1	34.0	28.0	62.0	34	28	62
1283954	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	1.0	PK	04	2016	grade_1	45.0	42.0	87.0	45	42	87
1295990	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	69.0	35.0	104.0	69	35	104
1754601	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	55.0	47.0	102.0	55	47	102
1790341	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	48.0	41.0	89.0	48	41	89
1910042	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1	45.0	48.0	93.0	45	48	93
1921997	IN	school	1813080	3030	Westfield-Washington Schools	181308002449	2498	Monon Trail Elementary School	Regular School	No	Elementary	KG	04	2021	grade_1	58.0	55.0	113.0	58	55	113
1162549	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	1.0	PK	04	2015	grade_1	49.0	32.0	81.0	49	32	81
1283964	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	1.0	PK	04	2016	grade_1	58.0	58.0	116.0	58	58	116
1295999	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	Elementary	PK	04	2017	grade_1	71.0	41.0	112.0	71	41	112
1754610	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	Elementary	PK	04	2019	grade_1	51.0	75.0	126.0	51	75	126
1790350	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	Elementary	PK	04	2018	grade_1	61.0	50.0	111.0	61	50	111
1910051	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	Elementary	PK	04	2020	grade_1	57.0	54.0	111.0	57	54	111
1922006	IN	school	1813080	3030	Westfield-Washington Schools	181308002184	2504	Maple Glen Elementary	Regular School	No	Elementary	PK	04	2021	grade_1	65.0	61.0	126.0	65	61	126
1162526	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	1.0	KG	04	2015	grade_1	38.0	47.0	85.0	38	47	85
1283941	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	35.0	35.0	70.0	35	35	70
1295977	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	47.0	35.0	82.0	47	35	82
1754587	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	63.0	52.0	115.0	63	52	115
1790327	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	58.0	47.0	105.0	58	47	105
1910028	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	53.0	46.0	99.0	53	46	99
1921983	IN	school	1813080	3030	Westfield-Washington Schools	181308002073	2495	Washington Woods Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	74.0	40.0	114.0	74	40	114
1162532	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary Sch	Regular School	No	1.0	PK	04	2015	grade_1	52.0	62.0	114.0	52	62	114
1283947	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary School	Regular School	No	1.0	PK	04	2016	grade_1	60.0	56.0	116.0	60	56	116
1295983	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary School	Regular School	No	Elementary	PK	04	2017	grade_1	69.0	45.0	114.0	69	45	114
1754594	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	61.0	40.0	101.0	61	40	101
1790334	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	65.0	66.0	131.0	65	66	131
1910035	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	54.0	44.0	98.0	54	44	98
1921990	IN	school	1813080	3030	Westfield-Washington Schools	181308001392	2496	Oak Trace Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	52.0	56.0	108.0	52	56	108
1162519	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary Sch	Regular School	No	1.0	PK	04	2015	grade_1	64.0	66.0	130.0	64	66	130
1283934	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary School	Regular School	No	1.0	PK	04	2016	grade_1	54.0	51.0	105.0	54	51	105
1295970	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary School	Regular School	No	Elementary	PK	04	2017	grade_1	49.0	60.0	109.0	49	60	109
1754580	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	71.0	56.0	127.0	71	56	127
1790320	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	57.0	52.0	109.0	57	52	109
1910021	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	58.0	63.0	121.0	58	63	121
1921976	IN	school	1813080	3030	Westfield-Washington Schools	181308000977	2494	Carey Ridge Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	66.0	55.0	121.0	66	55	121
1162507	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary Sch	Regular School	No	1.0	KG	04	2015	grade_1	43.0	53.0	96.0	43	53	96
1283922	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	49.0	43.0	92.0	49	43	92
1295957	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary School	Regular School	No	Elementary	PK	04	2017	grade_1	39.0	35.0	74.0	39	35	74
1754567	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	55.0	50.0	105.0	55	50	105
1790307	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	49.0	37.0	86.0	49	37	86
1910008	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	55.0	38.0	93.0	55	38	93
1921963	IN	school	1813080	3030	Westfield-Washington Schools	181308000134	2492	Shamrock Springs Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	59.0	52.0	111.0	59	52	111
1170406	IN	school	1813050	8355	Western Wayne Schools	181305000807	8971	Western Wayne Elem Sch	Regular School	No	1.0	PK	05	2015	grade_1	36.0	39.0	75.0	36	39	75
1291793	IN	school	1813050	8355	Western Wayne Schools	181305000807	8971	Western Wayne Elementary School	Regular School	No	1.0	PK	05	2016	grade_1	31.0	34.0	65.0	31	34	65
1303818	IN	school	1813050	8355	Western Wayne Schools	181305000807	8971	Western Wayne Elementary School	Regular School	No	Elementary	PK	05	2017	grade_1	32.0	36.0	68.0	32	36	68
1762357	IN	school	1813050	8355	Western Wayne Schools	181305000807	8971	Western Wayne Elementary School	Regular School	No	Elementary	PK	05	2019	grade_1	30.0	25.0	55.0	30	25	55
1798140	IN	school	1813050	8355	Western Wayne Schools	181305000807	8971	Western Wayne Elementary School	Regular School	No	Elementary	PK	05	2018	grade_1	33.0	42.0	75.0	33	42	75