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

Data source: Big Local News · About: Big Local

1,219 rows where grade = "grade_3", state = "SC" and year = 2020 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
236679	236679	SC	school	4501500	1101	Cherokee 01	450150000283	1101001	Blacksburg High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236680	236680	SC	school	4501500	1101	Cherokee 01	450150000284	1101002	John E Ewing Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236681	236681	SC	school	4501500	1101	Cherokee 01	450150000285	1101003	Gaffney High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236682	236682	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2020	grade_3	31.0	31
236683	236683	SC	school	4501500	1101	Cherokee 01	450150000271	1101007	Blacksburg Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236684	236684	SC	school	4501500	1101	Cherokee 01	450150000273	1101009	Corinth Elem	Regular School	No	Elementary	PK	05	2020	grade_3	65.0	65
236685	236685	SC	school	4501500	1101	Cherokee 01	450150000274	1101010	Draytonville Elem	Regular School	No	Elementary	PK	05	2020	grade_3	37.0	37
236686	236686	SC	school	4501500	1101	Cherokee 01	450150000275	1101011	Mary Bramlett Elem	Regular School	No	Elementary	PK	05	2020	grade_3	36.0	36
236687	236687	SC	school	4501500	1101	Cherokee 01	450150000276	1101012	Goucher Elem	Regular School	No	Elementary	PK	05	2020	grade_3	28.0	28
236688	236688	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2020	grade_3	48.0	48
236689	236689	SC	school	4501500	1101	Cherokee 01	450150000282	1101019	Luther L Vaughan Elem	Regular School	No	Elementary	PK	05	2020	grade_3	63.0	63
236690	236690	SC	school	4501500	1101	Cherokee 01	450150001391	1101020	Blacksburg Elem	Regular School	No	Elementary	03	05	2020	grade_3	125.0	125
236691	236691	SC	school	4501500	1101	Cherokee 01	450150000287	1101021	Limestone/Central Elem	Regular School	No	Elementary	PK	05	2020	grade_3	66.0	66
236692	236692	SC	school	4501500	1101	Cherokee 01	450150000296	1101022	Grassy Pond Elem	Regular School	No	Elementary	PK	05	2020	grade_3	78.0	78
236693	236693	SC	school	4501500	1101	Cherokee 01	450150000297	1101023	Northwest Elem	Regular School	No	Elementary	PK	05	2020	grade_3	99.0	99
236694	236694	SC	school	4501500	1101	Cherokee 01	450150000549	1101024	Gaffney Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236695	236695	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236696	236696	SC	school	4501530	1201	Chester 01	450153000298	1201002	Chester Sr High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236697	236697	SC	school	4501530	1201	Chester 01	450153000299	1201004	Chester Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236698	236698	SC	school	4501530	1201	Chester 01	450153000300	1201005	Great Falls High	Regular School	No	High	06	12	2020	grade_3	0.0	0
236699	236699	SC	school	4501530	1201	Chester 01	450153000301	1201006	Lewisville High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236700	236700	SC	school	4501530	1201	Chester 01	450153001225	1201008	Lewisville Middle	Regular School	No	Middle	05	08	2020	grade_3	0.0	0
236701	236701	SC	school	4501530	1201	Chester 01	450153000291	1201011	Great Falls Elem	Regular School	No	Elementary	PK	05	2020	grade_3	63.0	63
236702	236702	SC	school	4501530	1201	Chester 01	450153000292	1201014	Lewisville Elem	Regular School	No	Elementary	PK	04	2020	grade_3	98.0	98
236703	236703	SC	school	4501530	1201	Chester 01	450153000036	1201018	Chester Park Elem Of Inquiry	Regular School	No	Elementary	PK	05	2020	grade_3	49.0	49
236704	236704	SC	school	4501530	1201	Chester 01	450153001171	1201020	Chester Park Elem Sch for the Arts	Regular School	No	Elementary	PK	05	2020	grade_3	47.0	47
236705	236705	SC	school	4501530	1201	Chester 01	450153001172	1201021	Chester Park Elem Literacy/Tec	Regular School	No	Elementary	PK	05	2020	grade_3	73.0	73
236706	236706	SC	school	4501530	1201	Chester 01	450153001020	1201601	Academy for Teaching Charter	Regular School	Yes	Elementary	KG	08	2020	grade_3	40.0	40
236707	236707	SC	school	4501560	1301	Chesterfield 01	450156000314	1301001	Cheraw High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236708	236708	SC	school	4501560	1301	Chesterfield 01	450156000315	1301002	Chesterfield High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236709	236709	SC	school	4501560	1301	Chesterfield 01	450156000316	1301005	Long Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236710	236710	SC	school	4501560	1301	Chesterfield 01	450156000317	1301006	McBee High	Regular School	No	High	07	12	2020	grade_3	0.0	0
236711	236711	SC	school	4501560	1301	Chesterfield 01	450156000318	1301007	Central High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236712	236712	SC	school	4501560	1301	Chesterfield 01	450156000319	1301008	New Heights Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236713	236713	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236714	236714	SC	school	4501560	1301	Chesterfield 01	450156000305	1301014	Edwards Elem	Regular School	No	Elementary	PK	05	2020	grade_3	73.0	73
236715	236715	SC	school	4501560	1301	Chesterfield 01	450156000306	1301015	Jefferson Elem	Regular School	No	Elementary	PK	05	2020	grade_3	57.0	57
236716	236716	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236717	236717	SC	school	4501560	1301	Chesterfield 01	450156000308	1301020	McBee Elem	Regular School	No	Elementary	PK	06	2020	grade_3	67.0	67
236718	236718	SC	school	4501560	1301	Chesterfield 01	450156000309	1301021	Plainview Elem	Regular School	No	Elementary	PK	06	2020	grade_3	22.0	22
236719	236719	SC	school	4501560	1301	Chesterfield 01	450156000310	1301023	Ruby Elem	Regular School	No	Elementary	PK	05	2020	grade_3	37.0	37
236720	236720	SC	school	4501560	1301	Chesterfield 01	450156000170	1301026	Cheraw Intermed	Regular School	No	Elementary	03	05	2020	grade_3	138.0	138
236721	236721	SC	school	4501560	1301	Chesterfield 01	450156000870	1301027	Pageland Elem	Regular School	No	Elementary	03	05	2020	grade_3	125.0	125
236722	236722	SC	school	4501560	1301	Chesterfield 01	450156001173	1301028	Chesterfield Ruby Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236723	236723	SC	school	4501740	1401	Clarendon 01	450174000323	1401001	Scotts Branch High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236724	236724	SC	school	4501740	1401	Clarendon 01	450174000321	1401005	St. Paul Elem	Regular School	No	Elementary	03	05	2020	grade_3	54.0	54
236725	236725	SC	school	4501740	1401	Clarendon 01	450174000188	1401020	Scott's Branch Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236726	236726	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early Childhood Ctr	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236727	236727	SC	school	4501770	1402	Clarendon 02	450177000327	1402007	Manning High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236728	236728	SC	school	4501770	1402	Clarendon 02	450177000326	1402011	Manning Junior High	Regular School	No	Middle	07	08	2020	grade_3	0.0	0
236729	236729	SC	school	4501770	1402	Clarendon 02	450177000325	1402012	Manning Primary	Regular School	No	Elementary	01	03	2020	grade_3	210.0	210
236730	236730	SC	school	4501770	1402	Clarendon 02	450177001439	1402013	Manning Elem	Regular School	No	Middle	04	06	2020	grade_3	0.0	0
236731	236731	SC	school	4501770	1402	Clarendon 02	450177000551	1402014	Manning Early Childhood Ctr	Regular School	No	Elementary	PK	01	2020	grade_3	0.0	0
236732	236732	SC	school	4501770	1402	Clarendon 02	450177000431	1402610	Phoenix Charter High	Regular School	Yes	High	09	12	2020	grade_3	0.0	0
236733	236733	SC	school	4501800	1403	Clarendon 03	450180000331	1403016	East Clarendon Middle-High	Regular School	No	High	06	12	2020	grade_3	0.0	0
236734	236734	SC	school	4501800	1403	Clarendon 03	450180000329	1403019	Walker-Gamble Elem	Regular School	No	Elementary	PK	05	2020	grade_3	86.0	86
236735	236735	SC	school	4501830	1501	Colleton 01	450183000347	1501005	Colleton County High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236736	236736	SC	school	4501830	1501	Colleton 01	450183000332	1501006	Bells Elem	Regular School	No	Elementary	PK	05	2020	grade_3	44.0	44
236737	236737	SC	school	4501830	1501	Colleton 01	450183000333	1501008	Black St Early Childhood Ctr	Regular School	No	Elementary	PK	KG	2020	grade_3	0.0	0
236738	236738	SC	school	4501830	1501	Colleton 01	450183000336	1501011	Cottageville Elem	Regular School	No	Elementary	PK	05	2020	grade_3	86.0	86
236739	236739	SC	school	4501830	1501	Colleton 01	450183000337	1501012	Forest Hills Elem	Regular School	No	Elementary	01	05	2020	grade_3	117.0	117
236740	236740	SC	school	4501830	1501	Colleton 01	450183000189	1501020	Northside Elem	Regular School	No	Elementary	01	05	2020	grade_3	106.0	106
236741	236741	SC	school	4501830	1501	Colleton 01	450183000713	1501021	Hendersonville Elem	Regular School	No	Elementary	PK	05	2020	grade_3	48.0	48
236742	236742	SC	school	4501830	1501	Colleton 01	450183001586	1501022	Colleton County Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236396	236396	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236397	236397	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2020	grade_3	0.0	0
236398	236398	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2020	grade_3	19.0	19
236399	236399	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236400	236400	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2020	grade_3	108.0	108
236401	236401	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2020	grade_3	47.0	47
236402	236402	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2020	grade_3	36.0	36
236403	236403	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236743	236743	SC	school	4501860	1601	Darlington 01	450186000369	1601004	Hartsville Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236744	236744	SC	school	4501860	1601	Darlington 01	450186000370	1601005	Hartsville High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236745	236745	SC	school	4501860	1601	Darlington 01	450186000371	1601006	Lamar High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236746	236746	SC	school	4501860	1601	Darlington 01	450186000374	1601010	Spaulding Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236747	236747	SC	school	4501860	1601	Darlington 01	450186000350	1601013	Brockington Elem	Regular School	No	Elementary	03	05	2020	grade_3	110.0	110
236748	236748	SC	school	4501860	1601	Darlington 01	450186000351	1601014	Cain Elem	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236749	236749	SC	school	4501860	1601	Darlington 01	450186000352	1601015	Carolina Elem	Regular School	No	Elementary	01	05	2020	grade_3	60.0	60
236750	236750	SC	school	4501860	1601	Darlington 01	450186000353	1601016	Lamar Elem	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236751	236751	SC	school	4501860	1601	Darlington 01	450186000354	1601017	N Hartsville Elem	Regular School	No	Elementary	01	05	2020	grade_3	127.0	127
236752	236752	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2020	grade_3	0.0	0
236753	236753	SC	school	4501860	1601	Darlington 01	450186000356	1601020	Rosenwald Elem/Middle	Regular School	No	Elementary	PK	08	2020	grade_3	19.0	19
236754	236754	SC	school	4501860	1601	Darlington 01	450186000359	1601023	Spaulding Elem	Regular School	No	Elementary	03	05	2020	grade_3	80.0	80
236755	236755	SC	school	4501860	1601	Darlington 01	450186000360	1601024	Brunson-Dargan Elem	Regular School	No	Elementary	03	05	2020	grade_3	78.0	78
236756	236756	SC	school	4501860	1601	Darlington 01	450186000362	1601026	St Johns Elem	Regular School	No	Elementary	PK	05	2020	grade_3	95.0	95
236757	236757	SC	school	4501860	1601	Darlington 01	450186000363	1601027	Thornwell School/Arts	Regular School	No	Elementary	01	05	2020	grade_3	51.0	51
236758	236758	SC	school	4501860	1601	Darlington 01	450186000364	1601028	W Hartsville Elem	Regular School	No	Elementary	03	05	2020	grade_3	105.0	105
236759	236759	SC	school	4501860	1601	Darlington 01	450186000365	1601029	Washington St Elem	Regular School	No	Elementary	01	02	2020	grade_3	0.0	0
236760	236760	SC	school	4501860	1601	Darlington 01	450186000095	1601030	Darlington High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236761	236761	SC	school	4501860	1601	Darlington 01	450186000098	1601031	Darlington Middle	Regular School	No	Middle	06	08	2020	grade_3	0.0	0
236762	236762	SC	school	4501860	1601	Darlington 01	450186000100	1601032	Southside Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	grade_3	0.0	0
236763	236763	SC	school	4501860	1601	Darlington 01	450186000190	1601033	Mayo High Math Science Tech	Regular School	No	High	09	12	2020	grade_3	0.0	0
236764	236764	SC	school	4501950	1703	Dillon 03	450195000391	1703019	Latta High	Regular School	No	High	09	12	2020	grade_3	0.0	0
236765	236765	SC	school	4501950	1703	Dillon 03	450195000390	1703021	Latta Middle	Regular School	No	Middle	05	08	2020	grade_3	0.0	0
236766	236766	SC	school	4501950	1703	Dillon 03	450195000389	1703024	Latta Elementary	Regular School	No	Elementary	PK	04	2020	grade_3	110.0	110
236767	236767	SC	school	4501920	1704	Dillon 04	450192000380	1704002	Lake View High	Regular School	No	High	06	12	2020	grade_3	0.0	0
236768	236768	SC	school	4501920	1704	Dillon 04	450192000378	1704003	Lake View Elementary	Regular School	No	Elementary	PK	05	2020	grade_3	42.0	42
236769	236769	SC	school	4501920	1704	Dillon 04	450192000385	1704005	Dillon High School	Regular School	No	High	09	12	2020	grade_3	0.0	0
236770	236770	SC	school	4501920	1704	Dillon 04	450192000381	1704007	East Elementary	Regular School	No	Elementary	PK	03	2020	grade_3	102.0	102

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