enrollments

Data source: Big Local News · About: Big Local

36,585 rows where state = "SC" sorted by ccd_school_type descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ▲ ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
232087 232087 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   pre_kindergarten                                                   5.0                                             5
232456 232456 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   pre_kindergarten                                                   5.0                                             5
232694 232694 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   pre_kindergarten                                                   32.0                                             32
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
233306 233306 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   kindergarten                                                   5.0                                             5
233675 233675 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   kindergarten                                                   0.0                                             0
233913 233913 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   kindergarten                                                   17.0                                             17
233939 233939 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   kindergarten                                                   0.0                                             0
233940 233940 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   kindergarten                                                   0.0                                             0
233941 233941 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   kindergarten                                                   0.0                                             0
233942 233942 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   kindergarten                                                   3.0                                             3
233943 233943 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   kindergarten                                                   4.0                                             4
234525 234525 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_1                                                   7.0                                             7
234894 234894 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_1                                                   0.0                                             0
235132 235132 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_1                                                   17.0                                             17
235158 235158 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   grade_1                                                   0.0                                             0
235159 235159 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   grade_1                                                   0.0                                             0
235160 235160 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   grade_1                                                   2.0                                             2
235161 235161 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   grade_1                                                   4.0                                             4
235162 235162 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   grade_1                                                   4.0                                             4
235744 235744 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_2                                                   3.0                                             3
236113 236113 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_2                                                   0.0                                             0
236351 236351 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_2                                                   5.0                                             5
236377 236377 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   grade_2                                                   0.0                                             0
236378 236378 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   grade_2                                                   0.0                                             0
236379 236379 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   grade_2                                                   2.0                                             2
236380 236380 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   grade_2                                                   1.0                                             1
236381 236381 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   grade_2                                                   2.0                                             2
236963 236963 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_3                                                   5.0                                             5
237332 237332 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_3                                                   0.0                                             0
237570 237570 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_3                                                   0.0                                             0
237596 237596 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   grade_3                                                   0.0                                             0
237597 237597 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   grade_3                                                   0.0                                             0
237598 237598 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   grade_3                                                   6.0                                             6
237599 237599 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   grade_3                                                   1.0                                             1
237600 237600 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   grade_3                                                   1.0                                             1
238182 238182 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_4                                                   9.0                                             9
238551 238551 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_4                                                   0.0                                             0
238789 238789 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_4                                                   0.0                                             0
238815 238815 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   grade_4                                                   0.0                                             0
238816 238816 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   grade_4                                                   0.0                                             0
238817 238817 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   grade_4                                                   6.0                                             6
238818 238818 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   grade_4                                                   1.0                                             1
238819 238819 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   grade_4                                                   5.0                                             5
239401 239401 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_5                                                   3.0                                             3
239770 239770 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_5                                                   1.0                                             1
240008 240008 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_5                                                   0.0                                             0
240034 240034 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   grade_5                                                   0.0                                             0
240035 240035 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   grade_5                                                   0.0                                             0
240036 240036 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   grade_5                                                   4.0                                             4
240037 240037 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   grade_5                                                   4.0                                             4
240038 240038 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   grade_5                                                   5.0                                             5
240620 240620 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_6                                                   3.0                                             3
240989 240989 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_6                                                   1.0                                             1
241227 241227 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_6                                                   0.0                                             0
241253 241253 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   grade_6                                                   0.0                                             0
241254 241254 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   grade_6                                                   0.0                                             0
241255 241255 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   grade_6                                                   7.0                                             7
241256 241256 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   grade_6                                                   4.0                                             4
241257 241257 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   grade_6                                                   1.0                                             1
241839 241839 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_7                                                   11.0                                             11
242208 242208 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_7                                                   3.0                                             3
242446 242446 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_7                                                   0.0                                             0
242472 242472 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   grade_7                                                   0.0                                             0
242473 242473 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   grade_7                                                   0.0                                             0
242474 242474 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   grade_7                                                   6.0                                             6
242475 242475 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   grade_7                                                   4.0                                             4
242476 242476 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   grade_7                                                   2.0                                             2
243058 243058 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_8                                                   8.0                                             8
243427 243427 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_8                                                   2.0                                             2
243665 243665 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_8                                                   0.0                                             0
243691 243691 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   grade_8                                                   0.0                                             0
243692 243692 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   grade_8                                                   0.0                                             0
243693 243693 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   grade_8                                                   10.0                                             10
243694 243694 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   grade_8                                                   8.0                                             8
243695 243695 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   grade_8                                                   6.0                                             6
244277 244277 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_9                                                   9.0                                             9
244646 244646 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_9                                                   3.0                                             3
244884 244884 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_9                                                   0.0                                             0
244910 244910 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   grade_9                                                   5.0                                             5
244911 244911 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   grade_9                                                   7.0                                             7
244912 244912 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   grade_9                                                   0.0                                             0
244913 244913 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   grade_9                                                   0.0                                             0
244914 244914 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   grade_9                                                   5.0                                             5
245496 245496 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_10                                                   9.0                                             9
245865 245865 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_10                                                   4.0                                             4
246103 246103 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_10                                                   0.0                                             0
246129 246129 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   grade_10                                                   7.0                                             7
246130 246130 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   grade_10                                                   6.0                                             6
246131 246131 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   grade_10                                                   0.0                                             0
246132 246132 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   grade_10                                                   0.0                                             0
246133 246133 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   grade_10                                                   1.0                                             1
246715 246715 SC     school 4502310 2301   Greenville 01 450231000576 2301902 Washington Center   Special Education School No Other PK 12 2020   grade_11                                                   46.0                                             46
247084 247084 SC     school 4503360 4001   Richland 01 450336000957 4001905 Pendergrass Fairwold School   Special Education School No Other PK 12 2020   grade_11                                                   6.0                                             6
247322 247322 SC     school 4503901 4701   SC Public Charter School District 450390101689 4701049 Meyers Center for Special Children   Special Education School Yes Elementary PK 02 2020   grade_11                                                   0.0                                             0
247348 247348 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   grade_11                                                   9.0                                             9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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