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 (district > :p3 or (district = :p3 and rowid > :p2)) order by district, 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	male	female	total	male_int	female_int	total_int
1930638	IN	school	1800071	9685	Aspire Charter Academy	180007102443	4043	Aspire Charter Academy	Regular School	Yes	Elementary	KG	08	2021	grade_1	35.0	47.0	82.0	35	47	82
1161987	IN	school	1800210	2435	Attica Consolidated Sch Corp	180021000049	2057	Attica Elementary School	Regular School	No	1.0	PK	06	2015	grade_1	35.0	23.0	58.0	35	23	58
1283398	IN	school	1800210	2435	Attica Consolidated School Corp	180021000049	2057	Attica Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	29.0	19.0	48.0	29	19	48
1295442	IN	school	1800210	2435	Attica Consolidated School Corp	180021000049	2057	Attica Elementary School	Regular School	No	Elementary	PK	06	2017	grade_1	23.0	16.0	39.0	23	16	39
1754051	IN	school	1800210	2435	Attica Consolidated School Corp	180021000049	2057	Attica Elementary School	Regular School	No	Elementary	PK	05	2019	grade_1	23.0	21.0	44.0	23	21	44
1789784	IN	school	1800210	2435	Attica Consolidated School Corp	180021000049	2057	Attica Elementary School	Regular School	No	Elementary	PK	06	2018	grade_1	31.0	24.0	55.0	31	24	55
1909477	IN	school	1800210	2435	Attica Consolidated School Corp	180021000049	2057	Attica Elementary School	Regular School	No	Elementary	PK	05	2020	grade_1	22.0	20.0	42.0	22	20	42
1921439	IN	school	1800210	2435	Attica Consolidated School Corp	180021000049	2057	Attica Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1	18.0	15.0	33.0	18	15	33
1163042	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary	Regular School	No	1.0	KG	04	2015	grade_1	87.0	70.0	157.0	87	70	157
1163057	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary Sch	Regular School	No	1.0	KG	04	2015	grade_1	26.0	14.0	40.0	26	14	40
1163063	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	1.0	PK	04	2015	grade_1	30.0	30.0	60.0	30	30	60
1163070	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	1.0	KG	04	2015	grade_1	50.0	33.0	83.0	50	33	83
1163085	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	1.0	KG	04	2015	grade_1	79.0	58.0	137.0	79	58	137
1163091	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	1.0	KG	04	2015	grade_1	30.0	40.0	70.0	30	40	70
1163097	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	1.0	KG	04	2015	grade_1	64.0	37.0	101.0	64	37	101
1284447	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	77.0	71.0	148.0	77	71	148
1284463	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	25.0	29.0	54.0	25	29	54
1284469	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	1.0	PK	04	2016	grade_1	35.0	24.0	59.0	35	24	59
1284476	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	50.0	41.0	91.0	50	41	91
1284491	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	90.0	74.0	164.0	90	74	164
1284497	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	39.0	40.0	79.0	39	40	79
1284503	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	1.0	KG	04	2016	grade_1	53.0	45.0	98.0	53	45	98
1296485	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	64.0	79.0	143.0	64	79	143
1296501	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	31.0	28.0	59.0	31	28	59
1296507	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	Elementary	PK	04	2017	grade_1	26.0	31.0	57.0	26	31	57
1296514	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	48.0	44.0	92.0	48	44	92
1296529	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	72.0	56.0	128.0	72	56	128
1296535	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	33.0	33.0	66.0	33	33	66
1296541	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1	50.0	49.0	99.0	50	49	99
1755100	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	85.0	70.0	155.0	85	70	155
1755116	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	26.0	49.0	75.0	26	49	75
1755123	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	47.0	38.0	85.0	47	38	85
1755130	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	48.0	41.0	89.0	48	41	89
1755145	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	65.0	53.0	118.0	65	53	118
1755151	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	40.0	34.0	74.0	40	34	74
1755157	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1	55.0	44.0	99.0	55	44	99
1790838	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	85.0	73.0	158.0	85	73	158
1790854	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	27.0	23.0	50.0	27	23	50
1790861	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	27.0	18.0	45.0	27	18	45
1790868	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	68.0	40.0	108.0	68	40	108
1790883	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	60.0	77.0	137.0	60	77	137
1790889	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	30.0	36.0	66.0	30	36	66
1790895	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	Elementary	KG	04	2018	grade_1	45.0	49.0	94.0	45	49	94
1910546	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1	70.0	77.0	147.0	70	77	147
1910561	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	29.0	27.0	56.0	29	27	56
1910568	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	23.0	40.0	63.0	23	40	63
1910575	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1	47.0	41.0	88.0	47	41	88
1910590	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1	68.0	58.0	126.0	68	58	126
1910596	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	35.0	26.0	61.0	35	26	61
1910603	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1	55.0	37.0	92.0	55	37	92
1922496	IN	school	1800270	3315	Avon Community School Corp	180027002480	2726	River Birch Elementary School	Regular School	No	Elementary	KG	04	2021	grade_1	93.0	73.0	166.0	93	73	166
1922513	IN	school	1800270	3315	Avon Community School Corp	180027000059	2733	Maple Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	49.0	30.0	79.0	49	30	79
1922520	IN	school	1800270	3315	Avon Community School Corp	180027000058	2734	White Oak Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	30.0	43.0	73.0	30	43	73
1922527	IN	school	1800270	3315	Avon Community School Corp	180027000390	2735	Sycamore Elementary School	Regular School	No	Elementary	KG	04	2021	grade_1	55.0	51.0	106.0	55	51	106
1922542	IN	school	1800270	3315	Avon Community School Corp	180027002194	2738	Cedar Elementary School	Regular School	No	Elementary	KG	04	2021	grade_1	84.0	66.0	150.0	84	66	150
1922548	IN	school	1800270	3315	Avon Community School Corp	180027002330	2739	Pine Tree Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	27.0	32.0	59.0	27	32	59
1922555	IN	school	1800270	3315	Avon Community School Corp	180027001675	2740	Hickory Elementary School	Regular School	No	Elementary	KG	04	2021	grade_1	50.0	43.0	93.0	50	43	93
1304536	IN	school	1800057	9645	Avondale Meadows Academy	180005702314	5716	Avondale Meadows Academy	Regular School	Yes	Elementary	KG	05	2017	grade_1	39.0	40.0	79.0	39	40	79
1763139	IN	school	1800057	9645	Avondale Meadows Academy	180005702314	5716	Avondale Meadows Academy	Regular School	Yes	Elementary	KG	05	2019	grade_1	40.0	32.0	72.0	40	32	72
1798870	IN	school	1800057	9645	Avondale Meadows Academy	180005702314	5716	Avondale Meadows Academy	Regular School	Yes	Elementary	KG	05	2018	grade_1	47.0	30.0	77.0	47	30	77
1918609	IN	school	1800057	9645	Avondale Meadows Academy	180005702314	5716	Avondale Meadows Academy	Regular School	Yes	Elementary	KG	05	2020	grade_1	38.0	43.0	81.0	38	43	81
1930596	IN	school	1800057	9645	Avondale Meadows Academy	180005702314	5716	Avondale Meadows Academy	Regular School	Yes	Elementary	KG	05	2021	grade_1	32.0	29.0	61.0	32	29	61
1160897	IN	school	1800330	1315	Barr-Reeve Com Schools Inc	180033000062	1073	Barr Reeve Primary Grade Sch	Regular School	No	1.0	KG	01	2015	grade_1	32.0	48.0	80.0	32	48	80
1282299	IN	school	1800330	1315	Barr-Reeve Com Schools Inc	180033000062	1073	Barr Reeve Primary Grade School	Regular School	No	1.0	KG	01	2016	grade_1	39.0	35.0	74.0	39	35	74
1294337	IN	school	1800330	1315	Barr-Reeve Community Schools Inc	180033000062	1073	Barr Reeve Primary Grade School	Regular School	No	Elementary	KG	01	2017	grade_1	39.0	31.0	70.0	39	31	70
1752954	IN	school	1800330	1315	Barr-Reeve Community Schools Inc	180033000062	1073	Barr Reeve Primary Grade School	Regular School	No	Elementary	KG	01	2019	grade_1	31.0	32.0	63.0	31	32	63
1788695	IN	school	1800330	1315	Barr-Reeve Community Schools Inc	180033000062	1073	Barr Reeve Primary Grade School	Regular School	No	Elementary	KG	01	2018	grade_1	39.0	39.0	78.0	39	39	78
1908385	IN	school	1800330	1315	Barr-Reeve Community Schools Inc	180033000062	1073	Barr Reeve Primary Grade School	Regular School	No	Elementary	KG	01	2020	grade_1	44.0	46.0	90.0	44	46	90
1920360	IN	school	1800330	1315	Barr-Reeve Community Schools Inc	180033000060	1075	Barr Reeve Elementary School	Regular School	No	Elementary	KG	05	2021	grade_1	34.0	57.0	91.0	34	57	91
1160049	IN	school	1800360	365	Bartholomew Con School Corp	180036002188	328	Clifty Creek Elementary Sch	Regular School	No	1.0	PK	06	2015	grade_1	32.0	35.0	67.0	32	35	67
1160058	IN	school	1800360	365	Bartholomew Con School Corp	180036002421	346	CSA Lincoln Campus	Regular School	No	1.0	KG	06	2015	grade_1	25.0	26.0	51.0	25	26	51
1160066	IN	school	1800360	365	Bartholomew Con School Corp	180036000075	353	Mount Healthy Elementary Sch	Regular School	No	1.0	PK	06	2015	grade_1	34.0	34.0	68.0	34	34	68
1160077	IN	school	1800360	365	Bartholomew Con School Corp	180036000077	357	Parkside Elementary School	Regular School	No	1.0	PK	06	2015	grade_1	56.0	38.0	94.0	56	38	94
1160086	IN	school	1800360	365	Bartholomew Con School Corp	180036000082	363	W D Richards Elementary Sch	Regular School	No	1.0	PK	06	2015	grade_1	29.0	39.0	68.0	29	39	68
1160095	IN	school	1800360	365	Bartholomew Con School Corp	180036000079	366	Rockcreek Elementary School	Regular School	No	1.0	PK	06	2015	grade_1	28.0	24.0	52.0	28	24	52
1160104	IN	school	1800360	365	Bartholomew Con School Corp	180036000071	369	Lillian Schmitt Elem School	Regular School	No	1.0	KG	06	2015	grade_1	65.0	63.0	128.0	65	63	128
1160112	IN	school	1800360	365	Bartholomew Con School Corp	180036000070	371	L F Smith Elementary	Regular School	No	1.0	PK	06	2015	grade_1	28.0	37.0	65.0	28	37	65
1160121	IN	school	1800360	365	Bartholomew Con School Corp	180036002492	375	CSA Fodrea Campus	Regular School	No	1.0	PK	06	2015	grade_1	32.0	18.0	50.0	32	18	50
1160130	IN	school	1800360	365	Bartholomew Con School Corp	180036000081	377	Taylorsville Elem School	Regular School	No	1.0	PK	06	2015	grade_1	58.0	41.0	99.0	58	41	99
1160142	IN	school	1800360	365	Bartholomew Con School Corp	180036000080	392	Southside Elementary School	Regular School	No	1.0	PK	06	2015	grade_1	57.0	63.0	120.0	57	63	120
1281444	IN	school	1800360	365	Bartholomew Con School Corp	180036002188	328	Clifty Creek Elementary School	Regular School	No	1.0	KG	06	2016	grade_1	37.0	40.0	77.0	37	40	77
1281452	IN	school	1800360	365	Bartholomew Con School Corp	180036002421	346	CSA Lincoln Campus	Regular School	No	1.0	KG	06	2016	grade_1	22.0	25.0	47.0	22	25	47
1281460	IN	school	1800360	365	Bartholomew Con School Corp	180036000075	353	Mount Healthy Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	50.0	29.0	79.0	50	29	79
1281471	IN	school	1800360	365	Bartholomew Con School Corp	180036000077	357	Parkside Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	65.0	54.0	119.0	65	54	119
1281480	IN	school	1800360	365	Bartholomew Con School Corp	180036000082	363	W D Richards Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	49.0	43.0	92.0	49	43	92
1281489	IN	school	1800360	365	Bartholomew Con School Corp	180036000079	366	Rockcreek Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	25.0	23.0	48.0	25	23	48
1281498	IN	school	1800360	365	Bartholomew Con School Corp	180036000071	369	Lillian Schmitt Elementary School	Regular School	No	1.0	KG	06	2016	grade_1	64.0	49.0	113.0	64	49	113
1281506	IN	school	1800360	365	Bartholomew Con School Corp	180036000070	371	L F Smith Elementary	Regular School	No	1.0	PK	06	2016	grade_1	31.0	33.0	64.0	31	33	64
1281515	IN	school	1800360	365	Bartholomew Con School Corp	180036002492	375	CSA Fodrea Campus	Regular School	No	1.0	PK	06	2016	grade_1	23.0	26.0	49.0	23	26	49
1281524	IN	school	1800360	365	Bartholomew Con School Corp	180036000081	377	Taylorsville Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	40.0	38.0	78.0	40	38	78
1281536	IN	school	1800360	365	Bartholomew Con School Corp	180036000080	392	Southside Elementary School	Regular School	No	1.0	PK	06	2016	grade_1	58.0	78.0	136.0	58	78	136
1293499	IN	school	1800360	365	Bartholomew Con School Corp	180036002188	328	Clifty Creek Elementary School	Regular School	No	Elementary	KG	06	2017	grade_1	36.0	40.0	76.0	36	40	76
1293507	IN	school	1800360	365	Bartholomew Con School Corp	180036002421	346	CSA Lincoln Campus	Regular School	No	Elementary	KG	06	2017	grade_1	29.0	21.0	50.0	29	21	50
1293515	IN	school	1800360	365	Bartholomew Con School Corp	180036000075	353	Mount Healthy Elementary School	Regular School	No	Elementary	PK	06	2017	grade_1	42.0	25.0	67.0	42	25	67
1293526	IN	school	1800360	365	Bartholomew Con School Corp	180036000077	357	Parkside Elementary School	Regular School	No	Elementary	PK	06	2017	grade_1	61.0	37.0	98.0	61	37	98
1293535	IN	school	1800360	365	Bartholomew Con School Corp	180036000082	363	W D Richards Elementary School	Regular School	No	Elementary	PK	06	2017	grade_1	41.0	36.0	77.0	41	36	77
1293544	IN	school	1800360	365	Bartholomew Con School Corp	180036000079	366	Rockcreek Elementary School	Regular School	No	Elementary	PK	06	2017	grade_1	28.0	16.0	44.0	28	16	44
1293553	IN	school	1800360	365	Bartholomew Con School Corp	180036000071	369	Lillian Schmitt Elementary School	Regular School	No	Elementary	KG	06	2017	grade_1	56.0	46.0	102.0	56	46	102
1293561	IN	school	1800360	365	Bartholomew Con School Corp	180036000070	371	L F Smith Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	39.0	42.0	81.0	39	42	81
1293570	IN	school	1800360	365	Bartholomew Con School Corp	180036002492	375	CSA Fodrea Campus	Regular School	No	Elementary	PK	06	2017	grade_1	27.0	26.0	53.0	27	26	53
1293579	IN	school	1800360	365	Bartholomew Con School Corp	180036000081	377	Taylorsville Elementary School	Regular School	No	Elementary	PK	06	2017	grade_1	40.0	47.0	87.0	40	47	87