schools: enrollments: 1,220 rows where where grade = "grade_1", state = "SC" and year = 2021 sorted by district_state

Data source: Big Local News · About: Big Local

1,220 rows where grade = "grade_1", state = "SC" and year = 2021 sorted by district_state_id

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	total	total_int
370441	370441	SC	school	4501440	1001	Charleston 01	450144000250	1001001	Baptist Hill High	Regular School	No	High	06	12	2021	grade_1	0.0	0
370442	370442	SC	school	4501440	1001	Charleston 01	450144000251	1001002	N Charleston High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370443	370443	SC	school	4501440	1001	Charleston 01	450144001328	1001010	Burke High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370444	370444	SC	school	4501440	1001	Charleston 01	450144000261	1001014	Wando High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370445	370445	SC	school	4501440	1001	Charleston 01	450144001330	1001018	Military Magnet Academy	Regular School	No	High	06	12	2021	grade_1	0.0	0
370446	370446	SC	school	4501440	1001	Charleston 01	450144000264	1001020	St Johns High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370447	370447	SC	school	4501440	1001	Charleston 01	450144000265	1001022	R B Stall High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370448	370448	SC	school	4501440	1001	Charleston 01	450144001211	1001030	Northwoods Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370449	370449	SC	school	4501440	1001	Charleston 01	450144000197	1001033	Chicora Elem	Regular School	No	Elementary	01	05	2021	grade_1	46.0	46
370450	370450	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_1	109.0	109
370451	370451	SC	school	4501440	1001	Charleston 01	450144000201	1001039	Jane Edwards Elem	Regular School	No	Elementary	PK	06	2021	grade_1	6.0	6
370452	370452	SC	school	4501440	1001	Charleston 01	450144000202	1001040	Mary Ford Elem	Regular School	No	Elementary	PK	KG	2021	grade_1	0.0	0
370453	370453	SC	school	4501440	1001	Charleston 01	450144000204	1001042	W B Goodwin Elem	Regular School	No	Elementary	PK	05	2021	grade_1	49.0	49
370454	370454	SC	school	4501440	1001	Charleston 01	450144001214	1001043	Harbor View Elem	Regular School	No	Elementary	PK	05	2021	grade_1	101.0	101
370455	370455	SC	school	4501440	1001	Charleston 01	450144001215	1001044	Haut Gap Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370456	370456	SC	school	4501440	1001	Charleston 01	450144000205	1001045	Minnie Hughes Elem	Regular School	No	Elementary	PK	05	2021	grade_1	26.0	26
370457	370457	SC	school	4501440	1001	Charleston 01	450144000206	1001046	Hunley Park Elem	Regular School	No	Elementary	PK	05	2021	grade_1	63.0	63
370458	370458	SC	school	4501440	1001	Charleston 01	450144000207	1001050	Ladson Elem	Regular School	No	Elementary	PK	05	2021	grade_1	143.0	143
370459	370459	SC	school	4501440	1001	Charleston 01	450144001217	1001051	Laing Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370460	370460	SC	school	4501440	1001	Charleston 01	450144000208	1001052	Lambs Elem	Regular School	No	Elementary	PK	05	2021	grade_1	55.0	55
370461	370461	SC	school	4501440	1001	Charleston 01	450144001352	1001056	St James-Santee Elem	Regular School	No	Elementary	PK	08	2021	grade_1	22.0	22
370462	370462	SC	school	4501440	1001	Charleston 01	450144000210	1001057	Memminger Elem	Regular School	No	Elementary	PK	05	2021	grade_1	47.0	47
370463	370463	SC	school	4501440	1001	Charleston 01	450144000211	1001058	Midland Park Primary	Regular School	No	Elementary	PK	KG	2021	grade_1	0.0	0
370464	370464	SC	school	4501440	1001	Charleston 01	450144000212	1001059	Ellington Elem	Regular School	No	Elementary	PK	05	2021	grade_1	46.0	46
370465	370465	SC	school	4501440	1001	Charleston 01	450144000213	1001060	Mitchell Elem	Regular School	No	Elementary	PK	05	2021	grade_1	38.0	38
370466	370466	SC	school	4501440	1001	Charleston 01	450144000214	1001061	Jennie Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_1	145.0	145
370467	370467	SC	school	4501440	1001	Charleston 01	450144000215	1001062	Morningside Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370468	370468	SC	school	4501440	1001	Charleston 01	450144000216	1001063	Mt Pleasant Academy	Regular School	No	Elementary	PK	05	2021	grade_1	87.0	87
370469	370469	SC	school	4501440	1001	Charleston 01	450144001218	1001065	Moultrie Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370470	370470	SC	school	4501440	1001	Charleston 01	450144000218	1001066	Murray LaSaine MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_1	35.0	35
370471	370471	SC	school	4501440	1001	Charleston 01	450144000219	1001067	North Charleston Elem	Regular School	No	Elementary	PK	05	2021	grade_1	53.0	53
370472	370472	SC	school	4501440	1001	Charleston 01	450144000220	1001068	Oakland Elem	Regular School	No	Elementary	PK	05	2021	grade_1	88.0	88
370473	370473	SC	school	4501440	1001	Charleston 01	450144000222	1001070	Malcolm C. Hursey MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_1	43.0	43
370474	370474	SC	school	4501440	1001	Charleston 01	450144000224	1001072	Matilda Dunston Elem	Regular School	No	Elementary	PK	05	2021	grade_1	61.0	61
370475	370475	SC	school	4501440	1001	Charleston 01	450144000225	1001075	Edith L Frierson Elem	Regular School	No	Elementary	PK	05	2021	grade_1	18.0	18
370476	370476	SC	school	4501440	1001	Charleston 01	450144000226	1001076	Sanders-Clyde Elem	Regular School	No	Elementary	PK	05	2021	grade_1	64.0	64
370477	370477	SC	school	4501440	1001	Charleston 01	450144000227	1001077	Pepperhill Elem	Regular School	No	Elementary	PK	05	2021	grade_1	84.0	84
370478	370478	SC	school	4501440	1001	Charleston 01	450144000228	1001079	James Simon MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_1	50.0	50
370479	370479	SC	school	4501440	1001	Charleston 01	450144000229	1001081	Springfield Elem	Regular School	No	Elementary	PK	05	2021	grade_1	92.0	92
370480	370480	SC	school	4501440	1001	Charleston 01	450144000230	1001082	St Andrew's Math and Science	Regular School	No	Elementary	PK	05	2021	grade_1	123.0	123
370481	370481	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2021	grade_1	124.0	124
370482	370482	SC	school	4501440	1001	Charleston 01	450144000232	1001084	Stiles Point Elem	Regular School	No	Elementary	PK	05	2021	grade_1	130.0	130
370483	370483	SC	school	4501440	1001	Charleston 01	450144000233	1001085	Stono Park Elem	Regular School	No	Elementary	PK	05	2021	grade_1	56.0	56
370484	370484	SC	school	4501440	1001	Charleston 01	450144000234	1001086	Sullivan's Island Elem	Regular School	No	Elementary	PK	05	2021	grade_1	80.0	80
370485	370485	SC	school	4501440	1001	Charleston 01	450144000236	1001090	Mamie Whitesides Elem	Regular School	No	Elementary	PK	05	2021	grade_1	111.0	111
370486	370486	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2021	grade_1	92.0	92
370487	370487	SC	school	4501440	1001	Charleston 01	450144000249	1001092	C.E. Williams Middle School forCreative and Scientific Arts	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370488	370488	SC	school	4501440	1001	Charleston 01	450144001329	1001093	James B Edwards Elem	Regular School	No	Elementary	PK	05	2021	grade_1	121.0	121
370489	370489	SC	school	4501440	1001	Charleston 01	450144001382	1001094	Buist Academy	Regular School	No	Elementary	01	08	2021	grade_1	73.0	73
370490	370490	SC	school	4501440	1001	Charleston 01	450144001404	1001095	Mt Zion Elem	Regular School	No	Elementary	PK	05	2021	grade_1	36.0	36
370491	370491	SC	school	4501440	1001	Charleston 01	450144001438	1001096	Belle Hall Elem	Regular School	No	Elementary	PK	05	2021	grade_1	97.0	97
370492	370492	SC	school	4501440	1001	Charleston 01	450144000083	1001098	Charleston School Of The Arts	Regular School	No	High	06	12	2021	grade_1	0.0	0
370493	370493	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370494	370494	SC	school	4501440	1001	Charleston 01	450144000240	1001101	Charleston Progressive	Regular School	No	Elementary	PK	05	2021	grade_1	46.0	46
370495	370495	SC	school	4501440	1001	Charleston 01	450144000429	1001102	Charles Pinckney Elem	Regular School	No	Elementary	03	05	2021	grade_1	0.0	0
370496	370496	SC	school	4501440	1001	Charleston 01	450144000430	1001103	Thomas C. Cario Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370497	370497	SC	school	4501440	1001	Charleston 01	450144000548	1001104	West Ashley High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370498	370498	SC	school	4501440	1001	Charleston 01	450144000830	1001107	James Island Elem	Regular School	No	Elementary	PK	05	2021	grade_1	59.0	59
370499	370499	SC	school	4501440	1001	Charleston 01	450144001167	1001109	Drayton Hall Elem	Regular School	No	Elementary	PK	05	2021	grade_1	86.0	86
370500	370500	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	grade_1	166.0	166
370501	370501	SC	school	4501440	1001	Charleston 01	450144001533	1001111	Jerry Zucker Middle School Sci	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370502	370502	SC	school	4501440	1001	Charleston 01	450144001562	1001112	Pinehurst Elementary	Regular School	No	Elementary	01	05	2021	grade_1	134.0	134
370503	370503	SC	school	4501440	1001	Charleston 01	450144001610	1001113	Montessori Community School	Regular School	No	Elementary	PK	08	2021	grade_1	25.0	25
370504	370504	SC	school	4501440	1001	Charleston 01	450144001611	1001114	N. Charleston Creative ArtsElem	Regular School	No	Elementary	PK	05	2021	grade_1	88.0	88
370505	370505	SC	school	4501440	1001	Charleston 01	450144001660	1001115	Simmons Pinckney MiddleSchool	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370506	370506	SC	school	4501440	1001	Charleston 01	450144001667	1001116	Deer Park Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370507	370507	SC	school	4501440	1001	Charleston 01	450144001690	1001117	Carolina Park Elementary	Regular School	No	Elementary	PK	05	2021	grade_1	145.0	145
370508	370508	SC	school	4501440	1001	Charleston 01	450144001691	1001118	Camp Road Middle School	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370509	370509	SC	school	4501440	1001	Charleston 01	450144001746	1001121	Lucy Garrett Beckham High	Regular School	No	Secondary	09	10	2021	grade_1	0.0	0
370510	370510	SC	school	4501440	1001	Charleston 01	450144001648	1001200	Meeting Street ElementarySchool	Regular School	No	Elementary	PK	07	2021	grade_1	123.0	123
370511	370511	SC	school	4501440	1001	Charleston 01	450144000838	1001612	Charleston Develop. Charter	Regular School	Yes	Elementary	PK	08	2021	grade_1	21.0	21
370512	370512	SC	school	4501440	1001	Charleston 01	450144000856	1001614	East Cooper MontessoriCharter	Regular School	Yes	Elementary	PK	08	2021	grade_1	54.0	54
370513	370513	SC	school	4501440	1001	Charleston 01	450144000857	1001615	Greg Mathis Charter High	Regular School	Yes	High	09	12	2021	grade_1	0.0	0
370514	370514	SC	school	4501440	1001	Charleston 01	450144001168	1001616	James Island Charter High	Regular School	Yes	High	09	12	2021	grade_1	0.0	0
370515	370515	SC	school	4501440	1001	Charleston 01	450144001457	1001618	Orange Grove Charter	Regular School	Yes	Elementary	PK	08	2021	grade_1	127.0	127
370516	370516	SC	school	4501440	1001	Charleston 01	450144001505	1001620	Charleston CharterMath/Scienc	Regular School	Yes	High	06	12	2021	grade_1	0.0	0
370517	370517	SC	school	4501440	1001	Charleston 01	450144001553	1001628	Pattison's Acad For Compr Edu	Regular School	Yes	Other	KG	12	2021	grade_1	2.0	2
370518	370518	SC	school	4501440	1001	Charleston 01	450144001628	1001629	Carolina Voyager Charter	Regular School	Yes	Elementary	KG	08	2021	grade_1	46.0	46
370519	370519	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2021	grade_1	0.0	0
370520	370520	SC	school	4501500	1101	Cherokee 01	450150000283	1101001	Blacksburg High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370521	370521	SC	school	4501500	1101	Cherokee 01	450150000284	1101002	John E Ewing Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370522	370522	SC	school	4501500	1101	Cherokee 01	450150000285	1101003	Gaffney High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370523	370523	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2021	grade_1	23.0	23
370524	370524	SC	school	4501500	1101	Cherokee 01	450150000271	1101007	Blacksburg Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370525	370525	SC	school	4501500	1101	Cherokee 01	450150000273	1101009	Corinth Elem	Regular School	No	Elementary	PK	05	2021	grade_1	47.0	47
370526	370526	SC	school	4501500	1101	Cherokee 01	450150000274	1101010	Draytonville Elem	Regular School	No	Elementary	PK	05	2021	grade_1	27.0	27
370527	370527	SC	school	4501500	1101	Cherokee 01	450150000275	1101011	Mary Bramlett Elem	Regular School	No	Elementary	PK	05	2021	grade_1	29.0	29
370528	370528	SC	school	4501500	1101	Cherokee 01	450150000276	1101012	Goucher Elem	Regular School	No	Elementary	PK	05	2021	grade_1	34.0	34
370529	370529	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2021	grade_1	43.0	43
370530	370530	SC	school	4501500	1101	Cherokee 01	450150000282	1101019	Luther L Vaughan Elem	Regular School	No	Elementary	PK	05	2021	grade_1	49.0	49
370531	370531	SC	school	4501500	1101	Cherokee 01	450150001391	1101020	Blacksburg Elem	Regular School	No	Elementary	03	05	2021	grade_1	0.0	0
370532	370532	SC	school	4501500	1101	Cherokee 01	450150000287	1101021	Limestone/Central Elem	Regular School	No	Elementary	PK	05	2021	grade_1	43.0	43
370533	370533	SC	school	4501500	1101	Cherokee 01	450150000296	1101022	Grassy Pond Elem	Regular School	No	Elementary	PK	05	2021	grade_1	55.0	55
370534	370534	SC	school	4501500	1101	Cherokee 01	450150000297	1101023	Northwest Elem	Regular School	No	Elementary	PK	05	2021	grade_1	63.0	63
370535	370535	SC	school	4501500	1101	Cherokee 01	450150000549	1101024	Gaffney Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370536	370536	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	grade_1	113.0	113
370537	370537	SC	school	4501530	1201	Chester 01	450153000298	1201002	Chester Sr High	Regular School	No	High	09	12	2021	grade_1	0.0	0
370538	370538	SC	school	4501530	1201	Chester 01	450153000299	1201004	Chester Middle	Regular School	No	Middle	06	08	2021	grade_1	0.0	0
370539	370539	SC	school	4501530	1201	Chester 01	450153000300	1201005	Great Falls High	Regular School	No	High	06	12	2021	grade_1	0.0	0
370540	370540	SC	school	4501530	1201	Chester 01	450153000301	1201006	Lewisville High	Regular School	No	High	09	12	2021	grade_1	0.0	0

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]);