enrollments

Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_7" and state = "SD" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,696 ✖
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
459103 459103 SD     school 4677460 36002   Wessington Springs 36-2 467746001380 94 Wessington Springs Elementary Cyber School   Regular School Not applicable Elementary KG 06 2021   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
367203 367203 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber S   Regular School No Middle 07 08 2019   grade_7 1.0                       1.0 0.0                       1.0 1                       1 0                 1
459107 459107 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber School   Regular School Not applicable Middle 06 08 2021   grade_7 7.0                       3.0 4.0                       7.0 7                       3 4                 7
497504 497504 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber S   Regular School Not applicable Middle 07 08 2020   grade_7 2.0                       1.0 1.0                       2.0 2                       1 1                 2
251516 251516 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School No High 09 12 2018   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
256555 256555 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2018   grade_7 0.0   0.0 0.0           0.0     0.0 0.0                       0.0 0   0 0           0     0 0                 0
259965 259965 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2018   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
358775 358775 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School No High 09 12 2019   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
363692 363692 SD     school 4651750 56007   Northwestern Area 56-7 465175001391 92 Northwestern Cyber High School   Regular School No High 09 12 2019   grade_7 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
363814 363814 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2019   grade_7 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
364045 364045 SD     school 4654300 33003   Parkston 33-3 465430001395 92 Parkston Virtual School   Regular School No High 09 12 2019   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
367201 367201 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2019   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
450621 450621 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School Not applicable High 09 12 2021   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
452079 452079 SD     school 4624030 24004   Faulkton Area 462403001405 92 Brentwood Colony Virtual High School   Regular School Not applicable High 09 12 2021   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
455557 455557 SD     school 4651750 56007   Northwestern Area 56-7 465175001391 92 iSucceed   Regular School Not applicable High 09 12 2021   grade_7 0.0     0.0           0.0 0.0   0.0 0.0                       0.0 0     0           0 0   0 0                 0
455686 455686 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School Not applicable High 09 12 2021   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
455923 455923 SD     school 4654300 33003   Parkston 33-3 465430001395 92 Parkston Virtual School   Regular School Not applicable High 09 12 2021   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
459105 459105 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber School   Regular School Not applicable High 09 12 2021   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
489044 489044 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School Not applicable High 09 12 2020   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
493980 493980 SD     school 4651750 56007   Northwestern Area 56-7 465175001391 92 iSucceed   Regular School Not applicable High 09 12 2020   grade_7 0.0   0.0 0.0           0.0 0.0   0.0 0.0                       0.0 0   0 0           0 0   0 0                 0
494099 494099 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School Not applicable High 09 12 2020   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
494330 494330 SD     school 4654300 33003   Parkston 33-3 465430001395 92 Parkston Virtual School   Regular School Not applicable High 09 12 2020   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
497502 497502 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School Not applicable High 09 12 2020   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007926 3007926 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3009001 3009001 SD     school 4621300 16002   Elk Mountain 16-2 462130001186 92 Elk Mountain Virtual HS   Regular School No High 09 12 2017   grade_7 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
3012990 3012990 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2017   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3016358 3016358 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Alternative School No High 09 12 2017   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
249901 249901 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2018   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
357144 357144 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2019   grade_7 0.0 0.0   0.0                 0.0 0.0                       0.0 0 0   0                 0 0                 0
449006 449006 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2021   grade_7 1.0     0.0                 0.0 1.0                       1.0 1     0                 0 1                 1
487429 487429 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2020   grade_7 0.0 0.0 0.0 1.0                 0.0 1.0                       1.0 0 0 0 1                 0 1                 1
2961702 2961702 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2015   grade_7 0.0   0.0 2.0           0.0     1.0 1.0                       2.0 0   0 2           0     1 1                 2
3006326 3006326 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_7 0.0 0.0 0.0 1.0                 0.0 1.0                       1.0 0 0 0 1                 0 1                 1
3344260 3344260 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2016   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
256773 256773 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2018   grade_7 0.0 0.0 0.0 1.0                 0.0 1.0                       1.0 0 0 0 1                 0 1                 1
364041 364041 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2019   grade_7 0.0 0.0 0.0 1.0                 0.0 1.0                       1.0 0 0 0 1                 0 1                 1
455919 455919 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2021   grade_7 0.0   1.0 1.0                 0.0 2.0                       2.0 0   1 1                 0 2                 2
494326 494326 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2020   grade_7 1.0   0.0 1.0                 0.0 2.0                       2.0 1   0 1                 0 2                 2
2968366 2968366 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2015   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3013214 3013214 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   grade_7 0.0   1.0 1.0             1.0   1.0 2.0                       3.0 0   1 1             1   1 2                 3
3351078 3351078 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2016   grade_7 1.0 1.0 0.0 0.0           0.0     1.0 1.0                       2.0 1 1 0 0           0     1 1                 2
258192 258192 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School No Other KG 12 2018   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
365458 365458 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School No Other KG 12 2019   grade_7 0.0   0.0 1.0             0.0   0.0 1.0                       1.0 0   0 1             0   0 1                 1
457320 457320 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School Not applicable Other KG 12 2021   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
495743 495743 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School Not applicable Other KG 12 2020   grade_7 2.0                   0.0   2.0 0.0                       2.0 2                   0   2 0                 2
3014661 3014661 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 Summit Oaks Shelter Care   Alternative School No Other 05 12 2017   grade_7 0.0 1.0   1.0                 2.0 0.0                       2.0 0 1   1                 2 0                 2
258231 258231 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
365496 365496 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
457358 457358 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2021   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
495781 495781 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3014662 3014662 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3352536 3352536 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No 1 KG 05 2016   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
258226 258226 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
365491 365491 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
457353 457353 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
495776 495776 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2969953 2969953 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3014656 3014656 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3352532 3352532 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2016   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
257286 257286 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2018   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
364561 364561 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2019   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
456439 456439 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School Not applicable Other PK 12 2021   grade_7 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
494846 494846 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School Not applicable Other PK 12 2020   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
2968895 2968895 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No 4 PK 12 2015   grade_7 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
3013727 3013727 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2017   grade_7 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3351591 3351591 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No 4 PK 12 2016   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
258219 258219 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
365484 365484 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
457346 457346 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
495769 495769 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2969946 2969946 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3014649 3014649 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3352525 3352525 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
258210 258210 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2018   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
365476 365476 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
457337 457337 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
495760 495760 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2969935 2969935 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3014640 3014640 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3352516 3352516 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2016   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
258208 258208 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2018   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
365474 365474 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
457335 457335 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2021   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
495758 495758 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2969931 2969931 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3014638 3014638 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3352513 3352513 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2969917 2969917 SD     school 4666270 49005   Sioux Falls 49-5 466627000771 55 Bridges At Jefferson   Regular School No 1 KG 05 2015   grade_7 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3352499 3352499 SD     school 4666270 49005   Sioux Falls 49-5 466627000771 55 Bridges at Garfield   Regular School No 1 KG 05 2016   grade_7 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
258207 258207 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
365473 365473 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
457334 457334 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
495757 495757 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2969930 2969930 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3014637 3014637 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3352512 3352512 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
258216 258216 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2018   grade_7   14.0 13.0     3.0             18.0 12.0                       30.0   14 13     3             18 12                 30
2969942 2969942 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2015   grade_7 1.0 9.0 1.0     9.0             7.0 13.0                       20.0 1 9 1     9             7 13                 20
3014646 3014646 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2017   grade_7   11.0 5.0     2.0             6.0 12.0                       18.0   11 5     2             6 12                 18
3352522 3352522 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2016   grade_7 1.0 15.0 4.0     3.0             18.0 5.0                       23.0 1 15 4     3             18 5                 23

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