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

Data source: Big Local News · About: Big Local

1,220 rows where grade = "grade_6", 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
376541	376541	SC	school	4501440	1001	Charleston 01	450144000250	1001001	Baptist Hill High	Regular School	No	High	06	12	2021	grade_6	80.0	80
376542	376542	SC	school	4501440	1001	Charleston 01	450144000251	1001002	N Charleston High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376543	376543	SC	school	4501440	1001	Charleston 01	450144001328	1001010	Burke High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376544	376544	SC	school	4501440	1001	Charleston 01	450144000261	1001014	Wando High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376545	376545	SC	school	4501440	1001	Charleston 01	450144001330	1001018	Military Magnet Academy	Regular School	No	High	06	12	2021	grade_6	79.0	79
376546	376546	SC	school	4501440	1001	Charleston 01	450144000264	1001020	St Johns High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376547	376547	SC	school	4501440	1001	Charleston 01	450144000265	1001022	R B Stall High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376548	376548	SC	school	4501440	1001	Charleston 01	450144001211	1001030	Northwoods Middle	Regular School	No	Middle	06	08	2021	grade_6	283.0	283
376549	376549	SC	school	4501440	1001	Charleston 01	450144000197	1001033	Chicora Elem	Regular School	No	Elementary	01	05	2021	grade_6	0.0	0
376550	376550	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376551	376551	SC	school	4501440	1001	Charleston 01	450144000201	1001039	Jane Edwards Elem	Regular School	No	Elementary	PK	06	2021	grade_6	8.0	8
376552	376552	SC	school	4501440	1001	Charleston 01	450144000202	1001040	Mary Ford Elem	Regular School	No	Elementary	PK	KG	2021	grade_6	0.0	0
376553	376553	SC	school	4501440	1001	Charleston 01	450144000204	1001042	W B Goodwin Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376554	376554	SC	school	4501440	1001	Charleston 01	450144001214	1001043	Harbor View Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376555	376555	SC	school	4501440	1001	Charleston 01	450144001215	1001044	Haut Gap Middle	Regular School	No	Middle	06	08	2021	grade_6	177.0	177
376556	376556	SC	school	4501440	1001	Charleston 01	450144000205	1001045	Minnie Hughes Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376557	376557	SC	school	4501440	1001	Charleston 01	450144000206	1001046	Hunley Park Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376558	376558	SC	school	4501440	1001	Charleston 01	450144000207	1001050	Ladson Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376559	376559	SC	school	4501440	1001	Charleston 01	450144001217	1001051	Laing Middle	Regular School	No	Middle	06	08	2021	grade_6	319.0	319
376560	376560	SC	school	4501440	1001	Charleston 01	450144000208	1001052	Lambs Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376561	376561	SC	school	4501440	1001	Charleston 01	450144001352	1001056	St James-Santee Elem	Regular School	No	Elementary	PK	08	2021	grade_6	25.0	25
376562	376562	SC	school	4501440	1001	Charleston 01	450144000210	1001057	Memminger Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376563	376563	SC	school	4501440	1001	Charleston 01	450144000211	1001058	Midland Park Primary	Regular School	No	Elementary	PK	KG	2021	grade_6	0.0	0
376564	376564	SC	school	4501440	1001	Charleston 01	450144000212	1001059	Ellington Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376565	376565	SC	school	4501440	1001	Charleston 01	450144000213	1001060	Mitchell Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376566	376566	SC	school	4501440	1001	Charleston 01	450144000214	1001061	Jennie Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376567	376567	SC	school	4501440	1001	Charleston 01	450144000215	1001062	Morningside Middle	Regular School	No	Middle	06	08	2021	grade_6	232.0	232
376568	376568	SC	school	4501440	1001	Charleston 01	450144000216	1001063	Mt Pleasant Academy	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376569	376569	SC	school	4501440	1001	Charleston 01	450144001218	1001065	Moultrie Middle	Regular School	No	Middle	06	08	2021	grade_6	357.0	357
376570	376570	SC	school	4501440	1001	Charleston 01	450144000218	1001066	Murray LaSaine MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_6	33.0	33
376571	376571	SC	school	4501440	1001	Charleston 01	450144000219	1001067	North Charleston Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376572	376572	SC	school	4501440	1001	Charleston 01	450144000220	1001068	Oakland Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376573	376573	SC	school	4501440	1001	Charleston 01	450144000222	1001070	Malcolm C. Hursey MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_6	25.0	25
376574	376574	SC	school	4501440	1001	Charleston 01	450144000224	1001072	Matilda Dunston Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376575	376575	SC	school	4501440	1001	Charleston 01	450144000225	1001075	Edith L Frierson Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376576	376576	SC	school	4501440	1001	Charleston 01	450144000226	1001076	Sanders-Clyde Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376577	376577	SC	school	4501440	1001	Charleston 01	450144000227	1001077	Pepperhill Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376578	376578	SC	school	4501440	1001	Charleston 01	450144000228	1001079	James Simon MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_6	24.0	24
376579	376579	SC	school	4501440	1001	Charleston 01	450144000229	1001081	Springfield Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376580	376580	SC	school	4501440	1001	Charleston 01	450144000230	1001082	St Andrew's Math and Science	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376581	376581	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376582	376582	SC	school	4501440	1001	Charleston 01	450144000232	1001084	Stiles Point Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376583	376583	SC	school	4501440	1001	Charleston 01	450144000233	1001085	Stono Park Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376584	376584	SC	school	4501440	1001	Charleston 01	450144000234	1001086	Sullivan's Island Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376585	376585	SC	school	4501440	1001	Charleston 01	450144000236	1001090	Mamie Whitesides Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376586	376586	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2021	grade_6	0.0	0
376587	376587	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_6	419.0	419
376588	376588	SC	school	4501440	1001	Charleston 01	450144001329	1001093	James B Edwards Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376589	376589	SC	school	4501440	1001	Charleston 01	450144001382	1001094	Buist Academy	Regular School	No	Elementary	01	08	2021	grade_6	76.0	76
376590	376590	SC	school	4501440	1001	Charleston 01	450144001404	1001095	Mt Zion Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376591	376591	SC	school	4501440	1001	Charleston 01	450144001438	1001096	Belle Hall Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376592	376592	SC	school	4501440	1001	Charleston 01	450144000083	1001098	Charleston School Of The Arts	Regular School	No	High	06	12	2021	grade_6	161.0	161
376593	376593	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376594	376594	SC	school	4501440	1001	Charleston 01	450144000240	1001101	Charleston Progressive	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376595	376595	SC	school	4501440	1001	Charleston 01	450144000429	1001102	Charles Pinckney Elem	Regular School	No	Elementary	03	05	2021	grade_6	0.0	0
376596	376596	SC	school	4501440	1001	Charleston 01	450144000430	1001103	Thomas C. Cario Middle	Regular School	No	Middle	06	08	2021	grade_6	372.0	372
376597	376597	SC	school	4501440	1001	Charleston 01	450144000548	1001104	West Ashley High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376598	376598	SC	school	4501440	1001	Charleston 01	450144000830	1001107	James Island Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376599	376599	SC	school	4501440	1001	Charleston 01	450144001167	1001109	Drayton Hall Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376600	376600	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	grade_6	0.0	0
376601	376601	SC	school	4501440	1001	Charleston 01	450144001533	1001111	Jerry Zucker Middle School Sci	Regular School	No	Middle	06	08	2021	grade_6	176.0	176
376602	376602	SC	school	4501440	1001	Charleston 01	450144001562	1001112	Pinehurst Elementary	Regular School	No	Elementary	01	05	2021	grade_6	0.0	0
376603	376603	SC	school	4501440	1001	Charleston 01	450144001610	1001113	Montessori Community School	Regular School	No	Elementary	PK	08	2021	grade_6	26.0	26
376604	376604	SC	school	4501440	1001	Charleston 01	450144001611	1001114	N. Charleston Creative ArtsElem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376605	376605	SC	school	4501440	1001	Charleston 01	450144001660	1001115	Simmons Pinckney MiddleSchool	Regular School	No	Middle	06	08	2021	grade_6	83.0	83
376606	376606	SC	school	4501440	1001	Charleston 01	450144001667	1001116	Deer Park Middle	Regular School	No	Middle	06	08	2021	grade_6	117.0	117
376607	376607	SC	school	4501440	1001	Charleston 01	450144001690	1001117	Carolina Park Elementary	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376608	376608	SC	school	4501440	1001	Charleston 01	450144001691	1001118	Camp Road Middle School	Regular School	No	Middle	06	08	2021	grade_6	267.0	267
376609	376609	SC	school	4501440	1001	Charleston 01	450144001746	1001121	Lucy Garrett Beckham High	Regular School	No	Secondary	09	10	2021	grade_6	0.0	0
376610	376610	SC	school	4501440	1001	Charleston 01	450144001648	1001200	Meeting Street ElementarySchool	Regular School	No	Elementary	PK	07	2021	grade_6	72.0	72
376611	376611	SC	school	4501440	1001	Charleston 01	450144000838	1001612	Charleston Develop. Charter	Regular School	Yes	Elementary	PK	08	2021	grade_6	22.0	22
376612	376612	SC	school	4501440	1001	Charleston 01	450144000856	1001614	East Cooper MontessoriCharter	Regular School	Yes	Elementary	PK	08	2021	grade_6	42.0	42
376613	376613	SC	school	4501440	1001	Charleston 01	450144000857	1001615	Greg Mathis Charter High	Regular School	Yes	High	09	12	2021	grade_6	0.0	0
376614	376614	SC	school	4501440	1001	Charleston 01	450144001168	1001616	James Island Charter High	Regular School	Yes	High	09	12	2021	grade_6	0.0	0
376615	376615	SC	school	4501440	1001	Charleston 01	450144001457	1001618	Orange Grove Charter	Regular School	Yes	Elementary	PK	08	2021	grade_6	125.0	125
376616	376616	SC	school	4501440	1001	Charleston 01	450144001505	1001620	Charleston CharterMath/Scienc	Regular School	Yes	High	06	12	2021	grade_6	78.0	78
376617	376617	SC	school	4501440	1001	Charleston 01	450144001553	1001628	Pattison's Acad For Compr Edu	Regular School	Yes	Other	KG	12	2021	grade_6	4.0	4
376618	376618	SC	school	4501440	1001	Charleston 01	450144001628	1001629	Carolina Voyager Charter	Regular School	Yes	Elementary	KG	08	2021	grade_6	44.0	44
376619	376619	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2021	grade_6	29.0	29
376620	376620	SC	school	4501500	1101	Cherokee 01	450150000283	1101001	Blacksburg High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376621	376621	SC	school	4501500	1101	Cherokee 01	450150000284	1101002	John E Ewing Middle	Regular School	No	Middle	06	08	2021	grade_6	195.0	195
376622	376622	SC	school	4501500	1101	Cherokee 01	450150000285	1101003	Gaffney High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376623	376623	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376624	376624	SC	school	4501500	1101	Cherokee 01	450150000271	1101007	Blacksburg Middle	Regular School	No	Middle	06	08	2021	grade_6	120.0	120
376625	376625	SC	school	4501500	1101	Cherokee 01	450150000273	1101009	Corinth Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376626	376626	SC	school	4501500	1101	Cherokee 01	450150000274	1101010	Draytonville Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376627	376627	SC	school	4501500	1101	Cherokee 01	450150000275	1101011	Mary Bramlett Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376628	376628	SC	school	4501500	1101	Cherokee 01	450150000276	1101012	Goucher Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376629	376629	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376630	376630	SC	school	4501500	1101	Cherokee 01	450150000282	1101019	Luther L Vaughan Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376631	376631	SC	school	4501500	1101	Cherokee 01	450150001391	1101020	Blacksburg Elem	Regular School	No	Elementary	03	05	2021	grade_6	0.0	0
376632	376632	SC	school	4501500	1101	Cherokee 01	450150000287	1101021	Limestone/Central Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376633	376633	SC	school	4501500	1101	Cherokee 01	450150000296	1101022	Grassy Pond Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376634	376634	SC	school	4501500	1101	Cherokee 01	450150000297	1101023	Northwest Elem	Regular School	No	Elementary	PK	05	2021	grade_6	0.0	0
376635	376635	SC	school	4501500	1101	Cherokee 01	450150000549	1101024	Gaffney Middle	Regular School	No	Middle	06	08	2021	grade_6	348.0	348
376636	376636	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	grade_6	0.0	0
376637	376637	SC	school	4501530	1201	Chester 01	450153000298	1201002	Chester Sr High	Regular School	No	High	09	12	2021	grade_6	0.0	0
376638	376638	SC	school	4501530	1201	Chester 01	450153000299	1201004	Chester Middle	Regular School	No	Middle	06	08	2021	grade_6	186.0	186
376639	376639	SC	school	4501530	1201	Chester 01	450153000300	1201005	Great Falls High	Regular School	No	High	06	12	2021	grade_6	62.0	62
376640	376640	SC	school	4501530	1201	Chester 01	450153000301	1201006	Lewisville High	Regular School	No	High	09	12	2021	grade_6	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]);