enrollments

Data source: Big Local News · About: Big Local

1,219 rows where grade = "grade_7", state = "SC" and year = 2020 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,219 ✖

grade ✖

  • grade_7 · 1,219 ✖
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
242490 242490 SC     school 4503907 5395   Governor's School for Science and Mathematics 450390701579 5395001 Governor's School for Science and Mathematics   Regular School No High 11 12 2020   grade_7                                                   0.0                                             0
242489 242489 SC     school 4503904 5364   Governor's School for the Arts and Humanities 450390401580 5364001 Governor's School for the Arts and Humanities   Regular School No High 10 12 2020   grade_7                                                   0.0                                             0
242488 242488 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242487 242487 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242486 242486 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242485 242485 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242484 242484 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242483 242483 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242482 242482 SC     school 4500001 5209   Department of Corrections 450000100939 5209007 Manning HS   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242481 242481 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242480 242480 SC     school 4500001 5209   Department of Corrections 450000100255 5209003 Tyger River High   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
242479 242479 SC     school 4503420 5208   Department of Juvenile Justice 450342001186 5208003 Evaluation & Detention Ctr   Alternative School No High 05 12 2020   grade_7                                                   4.0                                             4
242478 242478 SC     school 4503420 5208   Department of Juvenile Justice 450342001185 5208002 Birchwood School   Alternative School No High 05 12 2020   grade_7                                                   3.0                                             3
242477 242477 SC     school 4503420 5208   Department of Juvenile Justice 450342001187 5208001 Willow Lane   Alternative School No High 05 12 2020   grade_7                                                   13.0                                             13
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
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
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
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
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
242471 242471 SC     school 4503909 4801   Charter Institute at Erskine 450390901719 4801017 Summit Classical School   Regular School Yes Elementary KG 03 2020   grade_7                                                   0.0                                             0
242470 242470 SC     school 4503909 4801   Charter Institute at Erskine 450390901715 4801016 Legion Collegiate Academy   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242469 242469 SC     school 4503909 4801   Charter Institute at Erskine 450390901716 4801015 Thornwell Charter School   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
242468 242468 SC     school 4503909 4801   Charter Institute at Erskine 450390901717 4801014 Clear Dot Charter   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
242467 242467 SC     school 4503909 4801   Charter Institute at Erskine 450390901510 4801013 Calhoun Falls Charter School   Regular School Yes High 06 12 2020   grade_7                                                   23.0                                             23
242466 242466 SC     school 4503909 4801   Charter Institute at Erskine 450390901616 4801012 Cyber Academy of South Carolina   Regular School Yes Other KG 12 2020   grade_7                                                   230.0                                             230
242465 242465 SC     school 4503909 4801   Charter Institute at Erskine 450390901513 4801011 South Carolina Virtual Charter   Regular School Yes Other KG 12 2020   grade_7                                                   309.0                                             309
242464 242464 SC     school 4503909 4801   Charter Institute at Erskine 450390901527 4801010 Odyssey Online Learning   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242463 242463 SC     school 4503909 4801   Charter Institute at Erskine 450390901642 4801009 Midlands STEM Institute   Regular School Yes Other KG 10 2020   grade_7                                                   16.0                                             16
242462 242462 SC     school 4503909 4801   Charter Institute at Erskine 450390901615 4801008 Coastal Leadership Academy   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242461 242461 SC     school 4503909 4801   Charter Institute at Erskine 450390901650 4801007 Gray Collegiate Academy   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242460 242460 SC     school 4503909 4801   Charter Institute at Erskine 450390901686 4801006 Mevers School of Excellence   Regular School Yes Elementary KG 08 2020   grade_7                                                   93.0                                             93
242459 242459 SC     school 4503909 4801   Charter Institute at Erskine 450390901663 4801005 Oceanside Collegiate Academy   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242458 242458 SC     school 4503909 4801   Charter Institute at Erskine 450390901590 4801004 Royal Oaks Academy of the Arts and Sciences   Regular School Yes Other KG 12 2020   grade_7                                                   50.0                                             50
242457 242457 SC     school 4503909 4801   Charter Institute at Erskine 450390901701 4801003 The Montessori School of Camden   Regular School Yes Elementary KG 07 2020   grade_7                                                   12.0                                             12
242456 242456 SC     school 4503909 4801   Charter Institute at Erskine 450390901700 4801002 Belton Preparatory Academy   Regular School Yes Elementary KG 03 2020   grade_7                                                   0.0                                             0
242455 242455 SC     school 4503909 4801   Charter Institute at Erskine 450390901699 4801001 Virtus Academy of South Carolina   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
242454 242454 SC     school 4503901 4701   SC Public Charter School District 450390101733 4701058 Renaissance Collegiate Academy   Regular School Yes Elementary KG 02 2020   grade_7                                                   0.0                                             0
242453 242453 SC     school 4503901 4701   SC Public Charter School District 450390101722 4701057 GREEN Charter School of Spartanburg   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
242452 242452 SC     school 4503901 4701   SC Public Charter School District 450390101703 4701056 Midlands Arts Conservatory   Regular School Yes Middle 06 08 2020   grade_7                                                   48.0                                             48
242451 242451 SC     school 4503901 4701   SC Public Charter School District 450390101706 4701055 Charleston Acceleration Academy   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242450 242450 SC     school 4503901 4701   SC Public Charter School District 450390101692 4701054 Lakes and Bridges Charter School   Regular School Yes Elementary 01 06 2020   grade_7                                                   0.0                                             0
242449 242449 SC     school 4503901 4701   SC Public Charter School District 450390101698 4701053 Polaris Tech   Regular School Yes Secondary 06 11 2020   grade_7                                                   57.0                                             57
242448 242448 SC     school 4503901 4701   SC Public Charter School District 450390101695 4701051 Bettis Preparatory Leadership Academy   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
242447 242447 SC     school 4503901 4701   SC Public Charter School District 450390101696 4701050 East Link Academy   Regular School Yes Elementary PK 05 2020   grade_7                                                   0.0                                             0
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
242445 242445 SC     school 4503901 4701   SC Public Charter School District 450390101685 4701048 Legacy Early College   Regular School Yes Other KG 12 2020   grade_7                                                   127.0                                             127
242444 242444 SC     school 4503901 4701   SC Public Charter School District 450390101688 4701047 Greer Middle College Charter High   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242443 242443 SC     school 4503901 4701   SC Public Charter School District 450390101687 4701046 Brashier Middle College   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242442 242442 SC     school 4503901 4701   SC Public Charter School District 450390101684 4701044 GREEN Charter School of the Midlands   Regular School Yes Elementary KG 08 2020   grade_7                                                   24.0                                             24
242441 242441 SC     school 4503901 4701   SC Public Charter School District 450390100460 4701043 Greenville Tech Charter Hi   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242440 242440 SC     school 4503901 4701   SC Public Charter School District 450390101401 4701042 Felton Lab Charter School   Regular School Yes Elementary KG 08 2020   grade_7                                                   45.0                                             45
242439 242439 SC     school 4503901 4701   SC Public Charter School District 450390101665 4701040 Tall Pines STEM Academy   Regular School Yes Middle 05 08 2020   grade_7                                                   46.0                                             46
242438 242438 SC     school 4503901 4701   SC Public Charter School District 450390101656 4701039 NEXT High   Regular School Yes High 06 12 2020   grade_7                                                   13.0                                             13
242437 242437 SC     school 4503901 4701   SC Public Charter School District 450390101646 4701037 Low Country Montessori School   Regular School Yes Other PK 12 2020   grade_7                                                   30.0                                             30
242436 242436 SC     school 4503901 4701   SC Public Charter School District 450390101545 4701036 Lead Academy   Regular School Yes Elementary KG 08 2020   grade_7                                                   44.0                                             44
242435 242435 SC     school 4503901 4701   SC Public Charter School District 450390101639 4701034 High Point Academy   Regular School Yes Other KG 12 2020   grade_7                                                   111.0                                             111
242434 242434 SC     school 4503901 4701   SC Public Charter School District 450390101645 4701033 Riverwalk Academy   Regular School Yes Other KG 10 2020   grade_7                                                   45.0                                             45
242433 242433 SC     school 4503901 4701   SC Public Charter School District 450390101619 4701029 Pee Dee Math Science & Tech Academy   Regular School Yes Other KG 10 2020   grade_7                                                   20.0                                             20
242432 242432 SC     school 4503901 4701   SC Public Charter School District 450390101617 4701027 Bridges Preparatory School   Regular School Yes Other KG 12 2020   grade_7                                                   67.0                                             67
242431 242431 SC     school 4503901 4701   SC Public Charter School District 450390101620 4701026 GREEN Charter School   Regular School Yes Other PK 12 2020   grade_7                                                   99.0                                             99
242430 242430 SC     school 4503901 4701   SC Public Charter School District 450390101613 4701023 Lowcountry Leadership Charter School   Regular School Yes Other KG 12 2020   grade_7                                                   44.0                                             44
242429 242429 SC     school 4503901 4701   SC Public Charter School District 450390101614 4701021 Midlands Middle College   Regular School Yes High 11 12 2020   grade_7                                                   0.0                                             0
242428 242428 SC     school 4503901 4701   SC Public Charter School District 450390101176 4701020 Fox Creek High   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242427 242427 SC     school 4503901 4701   SC Public Charter School District 450390101588 4701019 Cape Romain Environ. Ed.   Regular School Yes Elementary PK 08 2020   grade_7                                                   22.0                                             22
242426 242426 SC     school 4503901 4701   SC Public Charter School District 450390101589 4701017 Youth Leadership Academy Charter   Regular School Yes Middle 06 08 2020   grade_7                                                   49.0                                             49
242425 242425 SC     school 4503901 4701   SC Public Charter School District 450390101581 4701014 SC Whitmore School   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
242424 242424 SC     school 4503901 4701   SC Public Charter School District 450390101582 4701013 East Pointe Academy   Regular School Yes Elementary PK 08 2020   grade_7                                                   57.0                                             57
242423 242423 SC     school 4503901 4701   SC Public Charter School District 450390101544 4701011 York Preparatory Academy   Regular School Yes Other KG 12 2020   grade_7                                                   130.0                                             130
242422 242422 SC     school 4503901 4701   SC Public Charter School District 450390101542 4701010 Palmetto Scholars Academy   Regular School Yes High 06 12 2020   grade_7                                                   73.0                                             73
242421 242421 SC     school 4503901 4701   SC Public Charter School District 450390101541 4701006 Spartanburg Preparatory School   Regular School Yes Elementary KG 08 2020   grade_7                                                   46.0                                             46
242420 242420 SC     school 4503901 4701   SC Public Charter School District 450390101520 4701003 SC Connections Academy   Regular School Yes Other KG 12 2020   grade_7                                                   505.0                                             505
242419 242419 SC     school 4503900 4604   York 04 450390001718 4604061 Catawba Ridge High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
242418 242418 SC     school 4503900 4604   York 04 450390001683 4604060 Pleasant Knoll Middle   Regular School No Middle 06 08 2020   grade_7                                                   312.0                                             312
242417 242417 SC     school 4503900 4604   York 04 450390001649 4604059 Doby's Bridge Elementary   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242416 242416 SC     school 4503900 4604   York 04 450390001652 4604058 Tega Cay Elementary   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242415 242415 SC     school 4503900 4604   York 04 450390001564 4604057 Banks Trail Middle   Regular School No Middle 06 08 2020   grade_7                                                   316.0                                             316
242414 242414 SC     school 4503900 4604   York 04 450390001529 4604056 Sugar Creek Elementary   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
242413 242413 SC     school 4503900 4604   York 04 450390001535 4604055 Pleasant Knoll Elementary   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242412 242412 SC     school 4503900 4604   York 04 450390001103 4604054 Nation Ford High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
242411 242411 SC     school 4503900 4604   York 04 450390001102 4604053 Springfield Middle   Regular School No Middle 06 08 2020   grade_7                                                   206.0                                             206
242410 242410 SC     school 4503900 4604   York 04 450390000666 4604052 Springfield Elem   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242409 242409 SC     school 4503900 4604   York 04 450390000663 4604051 Orchard Park Elem   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242408 242408 SC     school 4503900 4604   York 04 450390000368 4604049 Gold Hill Middle   Regular School No Middle 06 08 2020   grade_7                                                   274.0                                             274
242407 242407 SC     school 4503900 4604   York 04 450390000062 4604048 Gold Hill Elem   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242406 242406 SC     school 4503900 4604   York 04 450390001153 4604043 Ft Mill Elem   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
242405 242405 SC     school 4503900 4604   York 04 450390001154 4604042 Riverview Elem   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
242404 242404 SC     school 4503900 4604   York 04 450390001155 4604037 Ft Mill Middle   Regular School No Middle 06 08 2020   grade_7                                                   263.0                                             263
242403 242403 SC     school 4503900 4604   York 04 450390001156 4604036 Ft Mill High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
242402 242402 SC     school 4503870 4603   York 03 450387000817 4603800 Central Child Development Ctr   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
242401 242401 SC     school 4503870 4603   York 03 450387001006 4603602 Palmetto School-Children's Attention Home   Regular School Yes Elementary KG 08 2020   grade_7                                                   3.0                                             3
242400 242400 SC     school 4503870 4603   York 03 450387001714 4603044 Cherry Park School of Language Immersion   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242399 242399 SC     school 4503870 4603   York 03 450387001516 4603043 Mount Holly Elementary   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242398 242398 SC     school 4503870 4603   York 03 450387001526 4603042 Dutchman Creek Middle   Regular School No Middle 06 08 2020   grade_7                                                   294.0                                             294
242397 242397 SC     school 4503870 4603   York 03 450387001004 4603041 South Pointe High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
242396 242396 SC     school 4503870 4603   York 03 450387000816 4603040 Old Pointe Elem   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
242395 242395 SC     school 4503870 4603   York 03 450387001491 4603039 India Hook Elem   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242394 242394 SC     school 4503870 4603   York 03 450387000537 4603038 Saluda Trail Middle   Regular School No Middle 06 08 2020   grade_7                                                   309.0                                             309
242393 242393 SC     school 4503870 4603   York 03 450387001145 4603037 Mt Gallant Elem   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
242392 242392 SC     school 4503870 4603   York 03 450387001144 4603036 Independence Elem   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
242391 242391 SC     school 4503870 4603   York 03 450387001143 4603035 York Road Elem   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0

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