schools: enrollments: 12,002 rows where where state = "IN" and year = 2021 sorted by ccd_school

Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by ccd_school_lvl

Search:

descending

Link	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	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	free_and_reduced	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	free_and_reduced_int	disability_int	total_int
1919512	1919512	IN	school		255	East Allen County Schools		318	EACS Early Childhood Preschool						2021	pk_12_total	28.0	8.0	4.0		4.0		4.0	36.0	12.0	0.0	24.0	40.0	48.0	28	8	4		4		4	36	12	0	24	40	48
1919513	1919513	IN	school		255	East Allen County Schools		318	EACS Early Childhood Preschool						2021	pre_kindergarten								36.0	12.0				48.0								36	12				48
1925542	1925542	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_10								0.0	3.0				3.0								0	3				3
1925543	1925543	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_11								4.0	3.0				7.0								4	3				7
1925544	1925544	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_12								4.0	0.0				4.0								4	0				4
1925545	1925545	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_2								6.0	0.0				6.0								6	0				6
1925546	1925546	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_3								8.0	1.0				9.0								8	1				9
1925547	1925547	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_4								5.0	1.0				6.0								5	1				6
1925548	1925548	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_5								4.0	1.0				5.0								4	1				5
1925549	1925549	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_6								4.0	0.0				4.0								4	0				4
1925550	1925550	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_7								7.0	1.0				8.0								7	1				8
1925551	1925551	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_8								6.0	1.0				7.0								6	1				7
1925552	1925552	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	grade_9								3.0	2.0				5.0								3	2				5
1925553	1925553	IN	school		5375	MSD Wayne Township		5271	Sanders School						2021	pk_12_total	30.0	23.0	4.0				7.0	51.0	13.0	5.0	38.0	63.0	64.0	30	23	4				7	51	13	5	38	63	64
1927083	1927083	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	adult								1.0	0.0				1.0								1	0				1
1927084	1927084	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_2								2.0	0.0				2.0								2	0				2
1927085	1927085	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_3								2.0	2.0				4.0								2	2				4
1927086	1927086	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_4								3.0	1.0				4.0								3	1				4
1927087	1927087	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_5								1.0	0.0				1.0								1	0				1
1927088	1927088	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_7								1.0	1.0				2.0								1	1				2
1927089	1927089	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_9								1.0	0.0				1.0								1	0				1
1927090	1927090	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	kindergarten								1.0	0.0				1.0								1	0				1
1927091	1927091	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	pk_12_total	11.0	1.0	3.0		1.0			12.0	4.0	1.0	7.0	16.0	16.0	11	1	3		1			12	4	1	7	16	16
1927137	1927137	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_2								0.0	1.0				1.0								0	1				1
1927138	1927138	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_4								0.0	1.0				1.0								0	1				1
1927139	1927139	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_5								1.0	0.0				1.0								1	0				1
1927140	1927140	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_6								2.0	0.0				2.0								2	0				2
1927141	1927141	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_8								1.0	0.0				1.0								1	0				1
1927142	1927142	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	pk_12_total	5.0		1.0					4.0	2.0	0.0	3.0	6.0	6.0	5		1					4	2	0	3	6	6
1927188	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
1927189	1927189	IN	school		6520	Porter Township School Corp		6811	Porter County Education Services						2021	grade_12								1.0	0.0				1.0								1	0				1
1927190	1927190	IN	school		6520	Porter Township School Corp		6811	Porter County Education Services						2021	kindergarten								0.0	1.0				1.0								0	1				1
1927191	1927191	IN	school		6520	Porter Township School Corp		6811	Porter County Education Services						2021	pk_12_total	3.0							1.0	2.0	0.0		3.0	3.0	3							1	2	0		3	3
1927211	1927211	IN	school		6530	Union Township School Corp		6811	Porter County Education Services						2021	grade_2								0.0	1.0				1.0								0	1				1
1927212	1927212	IN	school		6530	Union Township School Corp		6811	Porter County Education Services						2021	grade_6								0.0	1.0				1.0								0	1				1
1927213	1927213	IN	school		6530	Union Township School Corp		6811	Porter County Education Services						2021	grade_9								0.0	1.0				1.0								0	1				1
1927214	1927214	IN	school		6530	Union Township School Corp		6811	Porter County Education Services						2021	pk_12_total	3.0							0.0	3.0	0.0	3.0	3.0	3.0	3							0	3	0	3	3	3
1927238	1927238	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	adult								2.0	1.0				3.0								2	1				3
1927239	1927239	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_1								0.0	1.0				1.0								0	1				1
1927240	1927240	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_10								3.0	0.0				3.0								3	0				3
1927241	1927241	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_11								0.0	1.0				1.0								0	1				1
1927242	1927242	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_12								0.0	1.0				1.0								0	1				1
1927243	1927243	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_2								6.0	1.0				7.0								6	1				7
1927244	1927244	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_3								3.0	0.0				3.0								3	0				3
1927245	1927245	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_4								4.0	0.0				4.0								4	0				4
1927246	1927246	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_5								1.0	0.0				1.0								1	0				1
1927247	1927247	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_6								3.0	0.0				3.0								3	0				3
1927248	1927248	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_7								2.0	0.0				2.0								2	0				2
1927249	1927249	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_8								4.0	2.0				6.0								4	2				6
1927250	1927250	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	kindergarten								1.0	1.0				2.0								1	1				2
1927251	1927251	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	pk_12_total	24.0	5.0	3.0		1.0		4.0	29.0	8.0	0.0	19.0	37.0	37.0	24	5	3		1		4	29	8	0	19	37	37
1927322	1927322	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	adult								0.0	1.0				1.0								0	1				1
1927323	1927323	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_1								2.0	2.0				4.0								2	2				4
1927324	1927324	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_10								1.0	0.0				1.0								1	0				1
1927325	1927325	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_12								2.0	0.0				2.0								2	0				2
1927326	1927326	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_2								4.0	0.0				4.0								4	0				4
1927327	1927327	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_3								2.0	1.0				3.0								2	1				3
1927328	1927328	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_4								2.0	1.0				3.0								2	1				3
1927329	1927329	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_5								2.0	3.0				5.0								2	3				5
1927330	1927330	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_6								6.0	0.0				6.0								6	0				6
1927331	1927331	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_9								1.0	0.0				1.0								1	0				1
1927332	1927332	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	pk_12_total	20.0	3.0	6.0				1.0	22.0	8.0	2.0	15.0	30.0	30.0	20	3	6				1	22	8	2	15	30	30
1928191	1928191	IN	school		7205	South Bend Community School Corp		7605	South Bend SNAP						2021	pk_12_total	80.0	50.0	35.0				36.0	130.0	71.0	0.0	2.0	105.0	201.0	80	50	35				36	130	71	0	2	105	201
1928192	1928192	IN	school		7205	South Bend Community School Corp		7605	South Bend SNAP						2021	pre_kindergarten								130.0	71.0				201.0								130	71				201
1918957	1918957	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1								48.0	47.0				95.0								48	47				95
1918958	1918958	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	grade_2								56.0	43.0				99.0								56	43				99
1918959	1918959	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	grade_3								53.0	65.0				118.0								53	65				118
1918960	1918960	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								58.0	41.0				99.0								58	41				99
1918961	1918961	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5								58.0	48.0				106.0								58	48				106
1918962	1918962	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten								46.0	37.0				83.0								46	37				83
1918963	1918963	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	603.0	4.0	34.0	1.0	1.0		18.0	352.0	309.0	19.0	154.0	110.0	661.0	603	4	34	1	1		18	352	309	19	154	110	661
1918964	1918964	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten								33.0	28.0				61.0								33	28				61
1918980	1918980	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	grade_1								60.0	53.0				113.0								60	53				113
1918981	1918981	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	grade_2								35.0	55.0				90.0								35	55				90
1918982	1918982	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	grade_3								45.0	41.0				86.0								45	41				86
1918983	1918983	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	grade_4								51.0	51.0				102.0								51	51				102
1918984	1918984	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	grade_5								60.0	36.0				96.0								60	36				96
1918985	1918985	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	kindergarten								52.0	49.0				101.0								52	49				101
1918986	1918986	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	506.0	18.0	81.0		5.0	1.0	27.0	333.0	305.0	13.0	375.0	144.0	638.0	506	18	81		5	1	27	333	305	13	375	144	638
1918987	1918987	IN	school	1807680	25	North Adams Community Schools	180768001316	37	Bellmont Elementary	Regular School	No	Elementary	PK	05	2021	pre_kindergarten								30.0	20.0				50.0								30	20				50
1918998	1918998	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1								48.0	55.0				103.0								48	55				103
1918999	1918999	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	grade_2								43.0	60.0				103.0								43	60				103
1919000	1919000	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	grade_3								50.0	43.0				93.0								50	43				93
1919001	1919001	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								59.0	37.0				96.0								59	37				96
1919002	1919002	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5								50.0	47.0				97.0								50	47				97
1919003	1919003	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten								47.0	37.0				84.0								47	37				84
1919004	1919004	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	537.0		68.0		5.0	1.0	17.0	324.0	304.0	89.0	295.0	156.0	628.0	537		68		5	1	17	324	304	89	295	156	628
1919005	1919005	IN	school	1810260	35	South Adams Schools	181026001640	25	South Adams Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten								27.0	25.0				52.0								27	25				52
1919006	1919006	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	grade_1								24.0	31.0				55.0								24	31				55
1919007	1919007	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	grade_2								36.0	29.0				65.0								36	29				65
1919008	1919008	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	grade_3								52.0	32.0				84.0								52	32				84
1919009	1919009	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4								52.0	39.0				91.0								52	39				91
1919010	1919010	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5								57.0	43.0				100.0								57	43				100
1919011	1919011	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten								22.0	20.0				42.0								22	20				42
1919012	1919012	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000001	45	Aboite Elementary School	Regular School	No	Elementary	KG	05	2021	pk_12_total	359.0	10.0	20.0	4.0	20.0		24.0	243.0	194.0	3.0	81.0	26.0	437.0	359	10	20	4	20		24	243	194	3	81	26	437
1919013	1919013	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000083	46	Whispering Meadow Elementary Sch	Regular School	No	Elementary	PK	05	2021	grade_1								55.0	38.0				93.0								55	38				93
1919014	1919014	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000083	46	Whispering Meadow Elementary Sch	Regular School	No	Elementary	PK	05	2021	grade_2								35.0	41.0				76.0								35	41				76
1919015	1919015	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000083	46	Whispering Meadow Elementary Sch	Regular School	No	Elementary	PK	05	2021	grade_3								47.0	42.0				89.0								47	42				89
1919016	1919016	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000083	46	Whispering Meadow Elementary Sch	Regular School	No	Elementary	PK	05	2021	grade_4								40.0	44.0				84.0								40	44				84
1919017	1919017	IN	school	1800030	125	MSD Southwest Allen County Schls	180003000083	46	Whispering Meadow Elementary Sch	Regular School	No	Elementary	PK	05	2021	grade_5								50.0	42.0				92.0								50	42				92

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);