schools: enrollments: 1,219 rows where where grade = "pre_kindergarten", state = "SC" and year = 2020 sorted by school_nces

Data source: Big Local News · About: Big Local

1,219 rows where grade = "pre_kindergarten", state = "SC" and year = 2020 sorted by school_nces_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
232733	232733	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232734	232734	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232736	232736	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232728	232728	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232735	232735	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232730	232730	SC	school	4500001	5209	Department of Corrections	450000100939	5209007	Manning HS	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232729	232729	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232732	232732	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
232731	232731	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2020	pre_kindergarten	0.0	0
231923	231923	SC	school	4500002	1804	Dorchester 04	450000200435	1804016	Harleyville Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	22.0	22
231924	231924	SC	school	4500002	1804	Dorchester 04	450000200439	1804017	St. George Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231925	231925	SC	school	4500002	1804	Dorchester 04	450000200444	1804018	Williams Memorial Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	66.0	66
231926	231926	SC	school	4500002	1804	Dorchester 04	450000200445	1804019	Woodland High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231928	231928	SC	school	4500002	1804	Dorchester 04	450000201597	1804022	Harleyville-Ridgeville Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231927	231927	SC	school	4500002	1804	Dorchester 04	450000201600	1804021	Clay Hill Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	20.0	20
232720	232720	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401226	5207005	SC School For Blind High	Special Education School	No	High	09	12	2020	pre_kindergarten	0.0	0
232721	232721	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401227	5207007	SC School For Deaf High	Special Education School	No	High	09	12	2020	pre_kindergarten	0.0	0
232722	232722	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401228	5207009	SC School For Deaf Elem/Middle	Special Education School	No	Elementary	PK	08	2020	pre_kindergarten	4.0	4
232723	232723	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401246	5207010	SC School For Blind Elem/Middle	Special Education School	No	Elementary	PK	08	2020	pre_kindergarten	1.0	1
232724	232724	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401402	5207011	Cedar Springs Academy	Special Education School	No	Other	PK	12	2020	pre_kindergarten	7.0	7
231522	231522	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	13.0	13
231523	231523	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231520	231520	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231521	231521	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2020	pre_kindergarten	0.0	0
231525	231525	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2020	pre_kindergarten	20.0	20
231526	231526	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2020	pre_kindergarten	18.0	18
231527	231527	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	50.0	50
231524	231524	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0.0	0
231542	231542	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	39.0	39
231543	231543	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	46.0	46
231544	231544	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	40.0	40
231545	231545	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	39.0	39
231546	231546	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	20.0	20
231548	231548	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	27.0	27
231549	231549	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	40.0	40
231550	231550	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	30.0	30
231552	231552	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	28.0	28
231553	231553	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/Pinecrest Annex	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	42.0	42
231554	231554	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	20.0	20
231561	231561	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-Monetta Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	22.0	22
231556	231556	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	20.0	20
231559	231559	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	8.0	8
231529	231529	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231533	231533	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231537	231537	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231538	231538	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231562	231562	SC	school	4500720	201	Aiken 01	450072000056	201060	Ridge Spring Monetta High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231539	231539	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231568	231568	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2020	pre_kindergarten	0.0	0
231569	231569	SC	school	4500720	201	Aiken 01	450072000684	201602	Horse Creek Academy	Regular School	Yes	Elementary	PK	08	2020	pre_kindergarten	31.0	31
231560	231560	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	32.0	32
231540	231540	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	43.0	43
231555	231555	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	42.0	42
231531	231531	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	49.0	49
231534	231534	SC	school	4500720	201	Aiken 01	450072001194	201008	Lang Bath Clrwtr Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231535	231535	SC	school	4500720	201	Aiken 01	450072001196	201009	Leavelle Mccampbell Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231541	231541	SC	school	4500720	201	Aiken 01	450072001197	201017	M B Kennedy Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231532	231532	SC	school	4500720	201	Aiken 01	450072001198	201006	Midland Valley High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231536	231536	SC	school	4500720	201	Aiken 01	450072001199	201010	New Ellenton Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231557	231557	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	40.0	40
231547	231547	SC	school	4500720	201	Aiken 01	450072001201	201028	Schofield Middle	Regular School	No	Middle	07	08	2020	pre_kindergarten	0.0	0
231530	231530	SC	school	4500720	201	Aiken 01	450072001202	201003	South Aiken High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231551	231551	SC	school	4500720	201	Aiken 01	450072001321	201033	Jackson STEM Magnet Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231528	231528	SC	school	4500720	201	Aiken 01	450072001323	201001	Silver Bluff High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231558	231558	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	60.0	60
231565	231565	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231563	231563	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231564	231564	SC	school	4500720	201	Aiken 01	450072001713	201062	Ridge Spring Monetta Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231567	231567	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2020	pre_kindergarten	0.0	0
231566	231566	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	19.0	19
231570	231570	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231571	231571	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0.0	0
231573	231573	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231578	231578	SC	school	4500780	401	Anderson 01	450078000067	401005	Cedar Grove Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	40.0	40
231579	231579	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	80.0	80
231581	231581	SC	school	4500780	401	Anderson 01	450078000070	401009	West Pelzer Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	32.0	32
231582	231582	SC	school	4500780	401	Anderson 01	450078000072	401011	Spearman Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	39.0	39
231583	231583	SC	school	4500780	401	Anderson 01	450078000074	401012	Palmetto Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231574	231574	SC	school	4500780	401	Anderson 01	450078000076	401001	Palmetto High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231576	231576	SC	school	4500780	401	Anderson 01	450078000077	401003	Wren High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231585	231585	SC	school	4500780	401	Anderson 01	450078000545	401014	Hunt Meadows Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	57.0	57
231587	231587	SC	school	4500780	401	Anderson 01	450078000686	401062	Powdersville Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0.0	0
231580	231580	SC	school	4500780	401	Anderson 01	450078001203	401008	Wren Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231577	231577	SC	school	4500780	401	Anderson 01	450078001324	401004	Palmetto Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	73.0	73
231584	231584	SC	school	4500780	401	Anderson 01	450078001325	401013	Wren Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	37.0	37
231586	231586	SC	school	4500780	401	Anderson 01	450078001444	401061	Powdersville Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231575	231575	SC	school	4500780	401	Anderson 01	450078001567	401002	Powdersville High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231589	231589	SC	school	4500810	402	Anderson 02	450081000078	402013	Belton Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0.0	0
231591	231591	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	95.0	95
231592	231592	SC	school	4500810	402	Anderson 02	450081000080	402018	Honea Path Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	49.0	49
231594	231594	SC	school	4500810	402	Anderson 02	450081000081	402021	Wright Elem	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0.0	0
231588	231588	SC	school	4500810	402	Anderson 02	450081000084	402012	Belton Honea Path High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231590	231590	SC	school	4500810	402	Anderson 02	450081001204	402014	Belton Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231593	231593	SC	school	4500810	402	Anderson 02	450081001205	402019	Honea Path Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231596	231596	SC	school	4500840	403	Anderson 03	450084000086	403024	Iva Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	32.0	32
231598	231598	SC	school	4500840	403	Anderson 03	450084000087	403026	Starr Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	44.0	44
231597	231597	SC	school	4500840	403	Anderson 03	450084000088	403025	Starr Iva Middle	Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
231595	231595	SC	school	4500840	403	Anderson 03	450084000089	403022	Crescent High	Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
231599	231599	SC	school	4500840	403	Anderson 03	450084001506	403027	Flat Rock Elem.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	42.0	42
231602	231602	SC	school	4500870	404	Anderson 04	450087000090	404031	La France Elem	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	20.0	20

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