Data source: Big Local News · About: Big Local

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

View and edit SQL

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
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 SC     school 4500720 201   Aiken 01 450072000684 201602 Horse Creek Academy   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   31.0                                             31
231623 SC     school 4500900 405   Anderson 05 450090001602 405601 Anderson Five Charter   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
231672 SC     school 4501110 701   Beaufort 01 450111001530 701601 Riverview Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
231794 SC     school 4501440 1001   Charleston 01 450144000838 1001612 Charleston Develop. Charter   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   16.0                                             16
231795 SC     school 4501440 1001   Charleston 01 450144000856 1001614 East Cooper Montessori Charter   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   30.0                                             30
231796 SC     school 4501440 1001   Charleston 01 450144000857 1001615 Greg Mathis Charter High   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
231797 SC     school 4501440 1001   Charleston 01 450144001168 1001616 James Island Charter High   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
231798 SC     school 4501440 1001   Charleston 01 450144001457 1001618 Orange Grove Charter   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   19.0                                             19
231799 SC     school 4501440 1001   Charleston 01 450144001505 1001620 Charleston Charter Math/Scienc   Regular School Yes High 06 12 2020   pre_kindergarten                                                   0.0                                             0
231800 SC     school 4501440 1001   Charleston 01 450144001553 1001628 Pattison's Acad For Compr Edu   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
231801 SC     school 4501440 1001   Charleston 01 450144001628 1001629 Carolina Voyager Charter   Regular School Yes Elementary KG 07 2020   pre_kindergarten                                                   0.0                                             0
231802 SC     school 4501440 1001   Charleston 01 450144001655 1001630 Allegro Charter Sch of Music   Regular School Yes High 06 12 2020   pre_kindergarten                                                   0.0                                             0
231830 SC     school 4501530 1201   Chester 01 450153001020 1201601 Academy for Teaching Charter   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
231856 SC     school 4501770 1402   Clarendon 02 450177000431 1402610 Phoenix Charter High   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
231963 SC     school 4502130 2101   Florence 01 450213000958 2101600 Palmetto Youth Academy Charter   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
232000 SC     school 4502280 2201   Georgetown 01 450228001607 2201601 Coastal Montessori Charter   Regular School Yes Elementary 01 08 2020   pre_kindergarten                                                   0.0                                             0
232085 SC     school 4502310 2301   Greenville 01 450231000961 2301612 Langston Charter Middle   Regular School Yes Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
232169 SC     school 4502490 2601   Horry 01 450249000906 2601601 Bridgewater Academy Charter   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232170 SC     school 4502490 2601   Horry 01 450249001561 2601602 Palmetto Academy of Learn/Sci   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232171 SC     school 4502490 2601   Horry 01 450249001585 2601603 Academy of Hope Charter   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   16.0                                             16
232172 SC     school 4502490 2601   Horry 01 450249001595 2601604 Palmetto Academy - Motorsports   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232215 SC     school 4502580 2901   Lancaster 01 450258000556 2901611 Discovery Charter Of Lancaster   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
232386 SC     school 4503910 3809   Orangeburg 450391001604 3809601 OCSD5 High School for Health Professions   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232454 SC     school 4503360 4001   Richland 01 450336001195 4001601 Richland One Charter Middle Co   Regular School Yes High 11 12 2020   pre_kindergarten                                                   0.0                                             0
232455 SC     school 4503360 4001   Richland 01 450336001463 4001603 Carolina Charter for Inquiry   Regular School Yes Elementary PK 06 2020   pre_kindergarten                                                   21.0                                             21
232489 SC     school 4503390 4002   Richland 02 450339001554 4002600 Richland Two Charter High   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232649 SC     school 4503870 4603   York 03 450387001006 4603602 Palmetto School-Children's Attention Home   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232668 SC     school 4503901 4701   SC Public Charter School District 450390101520 4701003 SC Connections Academy   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232669 SC     school 4503901 4701   SC Public Charter School District 450390101541 4701006 Spartanburg Preparatory School   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232670 SC     school 4503901 4701   SC Public Charter School District 450390101542 4701010 Palmetto Scholars Academy   Regular School Yes High 06 12 2020   pre_kindergarten                                                   0.0                                             0
232671 SC     school 4503901 4701   SC Public Charter School District 450390101544 4701011 York Preparatory Academy   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232672 SC     school 4503901 4701   SC Public Charter School District 450390101582 4701013 East Pointe Academy   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   58.0                                             58
232673 SC     school 4503901 4701   SC Public Charter School District 450390101581 4701014 SC Whitmore School   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232674 SC     school 4503901 4701   SC Public Charter School District 450390101589 4701017 Youth Leadership Academy Charter   Regular School Yes Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
232675 SC     school 4503901 4701   SC Public Charter School District 450390101588 4701019 Cape Romain Environ. Ed.   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   22.0                                             22
232676 SC     school 4503901 4701   SC Public Charter School District 450390101176 4701020 Fox Creek High   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232677 SC     school 4503901 4701   SC Public Charter School District 450390101614 4701021 Midlands Middle College   Regular School Yes High 11 12 2020   pre_kindergarten                                                   0.0                                             0
232678 SC     school 4503901 4701   SC Public Charter School District 450390101613 4701023 Lowcountry Leadership Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232679 SC     school 4503901 4701   SC Public Charter School District 450390101620 4701026 GREEN Charter School   Regular School Yes Other PK 12 2020   pre_kindergarten                                                   33.0                                             33
232680 SC     school 4503901 4701   SC Public Charter School District 450390101617 4701027 Bridges Preparatory School   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232681 SC     school 4503901 4701   SC Public Charter School District 450390101619 4701029 Pee Dee Math Science & Tech Academy   Regular School Yes Other KG 10 2020   pre_kindergarten                                                   0.0                                             0
232682 SC     school 4503901 4701   SC Public Charter School District 450390101645 4701033 Riverwalk Academy   Regular School Yes Other KG 10 2020   pre_kindergarten                                                   0.0                                             0
232683 SC     school 4503901 4701   SC Public Charter School District 450390101639 4701034 High Point Academy   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232684 SC     school 4503901 4701   SC Public Charter School District 450390101545 4701036 Lead Academy   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232685 SC     school 4503901 4701   SC Public Charter School District 450390101646 4701037 Low Country Montessori School   Regular School Yes Other PK 12 2020   pre_kindergarten                                                   28.0                                             28
232686 SC     school 4503901 4701   SC Public Charter School District 450390101656 4701039 NEXT High   Regular School Yes High 06 12 2020   pre_kindergarten                                                   0.0                                             0
232687 SC     school 4503901 4701   SC Public Charter School District 450390101665 4701040 Tall Pines STEM Academy   Regular School Yes Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
232688 SC     school 4503901 4701   SC Public Charter School District 450390101401 4701042 Felton Lab Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232689 SC     school 4503901 4701   SC Public Charter School District 450390100460 4701043 Greenville Tech Charter Hi   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232690 SC     school 4503901 4701   SC Public Charter School District 450390101684 4701044 GREEN Charter School of the Midlands   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232691 SC     school 4503901 4701   SC Public Charter School District 450390101687 4701046 Brashier Middle College   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232692 SC     school 4503901 4701   SC Public Charter School District 450390101688 4701047 Greer Middle College Charter High   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232693 SC     school 4503901 4701   SC Public Charter School District 450390101685 4701048 Legacy Early College   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
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
232695 SC     school 4503901 4701   SC Public Charter School District 450390101696 4701050 East Link Academy   Regular School Yes Elementary PK 05 2020   pre_kindergarten                                                   0.0                                             0
232696 SC     school 4503901 4701   SC Public Charter School District 450390101695 4701051 Bettis Preparatory Leadership Academy   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
232697 SC     school 4503901 4701   SC Public Charter School District 450390101698 4701053 Polaris Tech   Regular School Yes Secondary 06 11 2020   pre_kindergarten                                                   0.0                                             0
232698 SC     school 4503901 4701   SC Public Charter School District 450390101692 4701054 Lakes and Bridges Charter School   Regular School Yes Elementary 01 06 2020   pre_kindergarten                                                   0.0                                             0
232699 SC     school 4503901 4701   SC Public Charter School District 450390101706 4701055 Charleston Acceleration Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232700 SC     school 4503901 4701   SC Public Charter School District 450390101703 4701056 Midlands Arts Conservatory   Regular School Yes Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
232701 SC     school 4503901 4701   SC Public Charter School District 450390101722 4701057 GREEN Charter School of Spartanburg   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
232702 SC     school 4503901 4701   SC Public Charter School District 450390101733 4701058 Renaissance Collegiate Academy   Regular School Yes Elementary KG 02 2020   pre_kindergarten                                                   0.0                                             0
232703 SC     school 4503909 4801   Charter Institute at Erskine 450390901699 4801001 Virtus Academy of South Carolina   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
232704 SC     school 4503909 4801   Charter Institute at Erskine 450390901700 4801002 Belton Preparatory Academy   Regular School Yes Elementary KG 03 2020   pre_kindergarten                                                   0.0                                             0
232705 SC     school 4503909 4801   Charter Institute at Erskine 450390901701 4801003 The Montessori School of Camden   Regular School Yes Elementary KG 07 2020   pre_kindergarten                                                   24.0                                             24
232706 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   pre_kindergarten                                                   0.0                                             0
232707 SC     school 4503909 4801   Charter Institute at Erskine 450390901663 4801005 Oceanside Collegiate Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232708 SC     school 4503909 4801   Charter Institute at Erskine 450390901686 4801006 Mevers School of Excellence   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
232709 SC     school 4503909 4801   Charter Institute at Erskine 450390901650 4801007 Gray Collegiate Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232710 SC     school 4503909 4801   Charter Institute at Erskine 450390901615 4801008 Coastal Leadership Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232711 SC     school 4503909 4801   Charter Institute at Erskine 450390901642 4801009 Midlands STEM Institute   Regular School Yes Other KG 10 2020   pre_kindergarten                                                   0.0                                             0
232712 SC     school 4503909 4801   Charter Institute at Erskine 450390901527 4801010 Odyssey Online Learning   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232713 SC     school 4503909 4801   Charter Institute at Erskine 450390901513 4801011 South Carolina Virtual Charter   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232714 SC     school 4503909 4801   Charter Institute at Erskine 450390901616 4801012 Cyber Academy of South Carolina   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
232715 SC     school 4503909 4801   Charter Institute at Erskine 450390901510 4801013 Calhoun Falls Charter School   Regular School Yes High 06 12 2020   pre_kindergarten                                                   0.0                                             0
232716 SC     school 4503909 4801   Charter Institute at Erskine 450390901717 4801014 Clear Dot Charter   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
232717 SC     school 4503909 4801   Charter Institute at Erskine 450390901716 4801015 Thornwell Charter School   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
232718 SC     school 4503909 4801   Charter Institute at Erskine 450390901715 4801016 Legion Collegiate Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
232719 SC     school 4503909 4801   Charter Institute at Erskine 450390901719 4801017 Summit Classical School   Regular School Yes Elementary KG 03 2020   pre_kindergarten                                                   0.0                                             0
232787 SC     school 4500720 201   Aiken 01 450072000682 201601 Lloyd/Kennedy Charter   Regular School Yes Middle 03 08 2020   kindergarten                                                   0.0                                             0
232788 SC     school 4500720 201   Aiken 01 450072000684 201602 Horse Creek Academy   Regular School Yes Elementary PK 08 2020   kindergarten                                                   62.0                                             62
232842 SC     school 4500900 405   Anderson 05 450090001602 405601 Anderson Five Charter   Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
232891 SC     school 4501110 701   Beaufort 01 450111001530 701601 Riverview Charter School   Regular School Yes Elementary KG 08 2020   kindergarten                                                   80.0                                             80
233013 SC     school 4501440 1001   Charleston 01 450144000838 1001612 Charleston Develop. Charter   Regular School Yes Elementary PK 08 2020   kindergarten                                                   19.0                                             19
233014 SC     school 4501440 1001   Charleston 01 450144000856 1001614 East Cooper Montessori Charter   Regular School Yes Elementary PK 08 2020   kindergarten                                                   18.0                                             18
233015 SC     school 4501440 1001   Charleston 01 450144000857 1001615 Greg Mathis Charter High   Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
233016 SC     school 4501440 1001   Charleston 01 450144001168 1001616 James Island Charter High   Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
233017 SC     school 4501440 1001   Charleston 01 450144001457 1001618 Orange Grove Charter   Regular School Yes Elementary PK 08 2020   kindergarten                                                   135.0                                             135
233018 SC     school 4501440 1001   Charleston 01 450144001505 1001620 Charleston Charter Math/Scienc   Regular School Yes High 06 12 2020   kindergarten                                                   0.0                                             0
233019 SC     school 4501440 1001   Charleston 01 450144001553 1001628 Pattison's Acad For Compr Edu   Regular School Yes Other KG 12 2020   kindergarten                                                   1.0                                             1
233020 SC     school 4501440 1001   Charleston 01 450144001628 1001629 Carolina Voyager Charter   Regular School Yes Elementary KG 07 2020   kindergarten                                                   46.0                                             46
233021 SC     school 4501440 1001   Charleston 01 450144001655 1001630 Allegro Charter Sch of Music   Regular School Yes High 06 12 2020   kindergarten                                                   0.0                                             0
233049 SC     school 4501530 1201   Chester 01 450153001020 1201601 Academy for Teaching Charter   Regular School Yes Elementary KG 08 2020   kindergarten                                                   41.0                                             41
233075 SC     school 4501770 1402   Clarendon 02 450177000431 1402610 Phoenix Charter High   Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
233182 SC     school 4502130 2101   Florence 01 450213000958 2101600 Palmetto Youth Academy Charter   Regular School Yes Elementary KG 06 2020   kindergarten                                                   15.0                                             15
233219 SC     school 4502280 2201   Georgetown 01 450228001607 2201601 Coastal Montessori Charter   Regular School Yes Elementary 01 08 2020   kindergarten                                                   0.0                                             0
233304 SC     school 4502310 2301   Greenville 01 450231000961 2301612 Langston Charter Middle   Regular School Yes Middle 06 08 2020   kindergarten                                                   0.0                                             0
233388 SC     school 4502490 2601   Horry 01 450249000906 2601601 Bridgewater Academy Charter   Regular School Yes Elementary KG 08 2020   kindergarten                                                   18.0                                             18
233389 SC     school 4502490 2601   Horry 01 450249001561 2601602 Palmetto Academy of Learn/Sci   Regular School Yes Elementary KG 08 2020   kindergarten                                                   36.0                                             36

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