Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 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
459138 SD     school 4677460 36002   Wessington Springs 36-2 467746001380 94 Wessington Springs Elementary Cyber School   Regular School Not applicable Elementary KG 06 2021   pk_12_total 15.0                       5.0 10.0                       15.0 15                       5 10                 15
367233 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber S   Regular School No Middle 07 08 2019   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
459142 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber School   Regular School Not applicable Middle 06 08 2021   pk_12_total 17.0                       8.0 9.0                       17.0 17                       8 9                 17
497534 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber S   Regular School Not applicable Middle 07 08 2020   pk_12_total 3.0                       2.0 1.0                       3.0 3                       2 1                 3
251551 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School No High 09 12 2018   pk_12_total 130.0                       75.0 55.0                       130.0 130                       75 55                 130
256580 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2018   pk_12_total 1.0   1.0 103.0           1.0     45.0 61.0                       106.0 1   1 103           1     45 61                 106
259990 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2018   pk_12_total 22.0   1.0 2.0                 11.0 14.0                       25.0 22   1 2                 11 14                 25
358810 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School No High 09 12 2019   pk_12_total 112.0                       76.0 36.0                       112.0 112                       76 36                 112
363712 SD     school 4651750 56007   Northwestern Area 56-7 465175001391 92 Northwestern Cyber High School   Regular School No High 09 12 2019   pk_12_total 5.0                   1.0   4.0 2.0                       6.0 5                   1   4 2                 6
363839 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2019   pk_12_total 1.0     93.0             2.0   31.0 65.0                       96.0 1     93             2   31 65                 96
364080 SD     school 4654300 33003   Parkston 33-3 465430001395 92 Parkston Virtual School   Regular School No High 09 12 2019   pk_12_total 10.0                       6.0 4.0                       10.0 10                       6 4                 10
367231 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2019   pk_12_total 23.0                       13.0 10.0                       23.0 23                       13 10                 23
450656 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School Not applicable High 09 12 2021   pk_12_total 118.0                       74.0 44.0                       118.0 118                       74 44                 118
452114 SD     school 4624030 24004   Faulkton Area 462403001405 92 Brentwood Colony Virtual High School   Regular School Not applicable High 09 12 2021   pk_12_total 7.0                       5.0 2.0                       7.0 7                       5 2                 7
455577 SD     school 4651750 56007   Northwestern Area 56-7 465175001391 92 iSucceed   Regular School Not applicable High 09 12 2021   pk_12_total 26.0     3.0           1.0 3.0   13.0 20.0                       33.0 26     3           1 3   13 20                 33
455716 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School Not applicable High 09 12 2021   pk_12_total 2.0   1.0 79.0             1.0   39.0 44.0                       83.0 2   1 79             1   39 44                 83
455958 SD     school 4654300 33003   Parkston 33-3 465430001395 92 Parkston Virtual School   Regular School Not applicable High 09 12 2021   pk_12_total 5.0                       3.0 2.0                       5.0 5                       3 2                 5
459140 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber School   Regular School Not applicable High 09 12 2021   pk_12_total 67.0     1.0                 26.0 42.0                       68.0 67     1                 26 42                 68
489079 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School Not applicable High 09 12 2020   pk_12_total 114.0                       65.0 49.0                       114.0 114                       65 49                 114
494000 SD     school 4651750 56007   Northwestern Area 56-7 465175001391 92 iSucceed   Regular School Not applicable High 09 12 2020   pk_12_total 21.0   1.0 1.0           1.0 1.0   14.0 11.0                       25.0 21   1 1           1 1   14 11                 25
494124 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School Not applicable High 09 12 2020   pk_12_total 1.0   2.0 93.0                 40.0 56.0                       96.0 1   2 93                 40 56                 96
494365 SD     school 4654300 33003   Parkston 33-3 465430001395 92 Parkston Virtual School   Regular School Not applicable High 09 12 2020   pk_12_total 8.0                       4.0 4.0                       8.0 8                       4 4                 8
497532 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School Not applicable High 09 12 2020   pk_12_total 44.0                       24.0 20.0                       44.0 44                       24 20                 44
3007961 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   pk_12_total 161.0                       97.0 64.0                       161.0 161                       97 64                 161
3009011 SD     school 4621300 16002   Elk Mountain 16-2 462130001186 92 Elk Mountain Virtual HS   Regular School No High 09 12 2017   pk_12_total 1.0                   1.0   1.0 1.0                       2.0 1                   1   1 1                 2
3013020 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2017   pk_12_total 1.0   1.0 106.0                 52.0 56.0                       108.0 1   1 106                 52 56                 108
3016383 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Alternative School No High 09 12 2017   pk_12_total 19.0   3.0 5.0                 18.0 9.0                       27.0 19   3 5                 18 9                 27
249951 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2018   pk_12_total 4.0     3.0                 4.0 3.0                       7.0 4     3                 4 3                 7
357194 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2019   pk_12_total 1.0 2.0   11.0                 5.0 9.0                       14.0 1 2   11                 5 9                 14
449056 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2021   pk_12_total 4.0     4.0                 2.0 6.0                       8.0 4     4                 2 6                 8
487479 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2020   pk_12_total 2.0 1.0 1.0 5.0                 5.0 4.0                       9.0 2 1 1 5                 5 4                 9
2961752 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2015   pk_12_total 3.0   1.0 4.0           1.0     4.0 5.0                       9.0 3   1 4           1     4 5                 9
3006376 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   pk_12_total 2.0 1.0 1.0 10.0                 3.0 11.0                       14.0 2 1 1 10                 3 11                 14
3344305 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2016   pk_12_total 5.0     7.0                 6.0 6.0                       12.0 5     7                 6 6                 12
256803 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2018   pk_12_total 15.0 2.0 1.0 13.0                 7.0 24.0                       31.0 15 2 1 13                 7 24                 31
364076 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2019   pk_12_total 9.0 1.0 1.0 15.0                 8.0 18.0                       26.0 9 1 1 15                 8 18                 26
455954 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2021   pk_12_total 10.0   2.0 14.0                 6.0 20.0                       26.0 10   2 14                 6 20                 26
494361 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2020   pk_12_total 13.0   2.0 15.0                 8.0 22.0                       30.0 13   2 15                 8 22                 30
2968396 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2015   pk_12_total 19.0   1.0 7.0                 11.0 16.0                       27.0 19   1 7                 11 16                 27
3013244 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   pk_12_total 7.0   1.0 19.0             2.0   9.0 20.0                       29.0 7   1 19             2   9 20                 29
3351108 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2016   pk_12_total 16.0 1.0 2.0 6.0           1.0     6.0 20.0                       26.0 16 1 2 6           1     6 20                 26
258407 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School No Other KG 12 2018   pk_12_total 2.0   2.0 2.0                 2.0 4.0                       6.0 2   2 2                 2 4                 6
365668 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School No Other KG 12 2019   pk_12_total 4.0   1.0 1.0             1.0   5.0 2.0                       7.0 4   1 1             1   5 2                 7
457530 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School Not applicable Other KG 12 2021   pk_12_total 3.0     4.0                 4.0 3.0                       7.0 3     4                 4 3                 7
495953 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School Not applicable Other KG 12 2020   pk_12_total 4.0                   1.0   4.0 1.0                       5.0 4                   1   4 1                 5
3014871 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 Summit Oaks Shelter Care   Alternative School No Other 05 12 2017   pk_12_total 2.0 3.0   9.0                 8.0 6.0                       14.0 2 3   9                 8 6                 14
258446 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   pk_12_total 288.0 71.0 96.0 22.0   18.0       3.0 38.0   280.0 256.0                       536.0 288 71 96 22   18       3 38   280 256                 536
365706 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2019   pk_12_total 264.0 69.0 81.0 12.0   17.0       3.0 33.0   261.0 218.0                       479.0 264 69 81 12   17       3 33   261 218                 479
457568 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 279.0 80.0 51.0 15.0   10.0       3.0 33.0   273.0 198.0                       471.0 279 80 51 15   10       3 33   273 198                 471
495991 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0                       509.0 280 79 81 14   19       4 32   283 226                 509
3014872 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2017   pk_12_total 305.0 80.0 74.0 27.0   14.0       2.0 28.0   292.0 238.0                       530.0 305 80 74 27   14       2 28   292 238                 530
3352751 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No 1 KG 05 2016   pk_12_total 293.0 98.0 74.0 34.0   25.0       3.0 29.0   315.0 241.0                       556.0 293 98 74 34   25       3 29   315 241                 556
258441 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   pk_12_total 523.0 12.0 73.0 4.0   2.0       1.0 30.0   311.0 334.0                       645.0 523 12 73 4   2       1 30   311 334                 645
365701 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   pk_12_total 557.0 15.0 83.0 3.0   1.0         30.0   337.0 352.0                       689.0 557 15 83 3   1         30   337 352                 689
457563 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 559.0 17.0 99.0 2.0   1.0         28.0   344.0 362.0                       706.0 559 17 99 2   1         28   344 362                 706
495986 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 564.0 16.0 88.0 3.0   1.0         28.0   341.0 359.0                       700.0 564 16 88 3   1         28   341 359                 700
2970178 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2015   pk_12_total 351.0 8.0 34.0 4.0   5.0       1.0 16.0   211.0 208.0                       419.0 351 8 34 4   5       1 16   211 208                 419
3014866 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2017   pk_12_total 478.0 12.0 66.0 4.0   2.0       1.0 25.0   284.0 304.0                       588.0 478 12 66 4   2       1 25   284 304                 588
3352747 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2016   pk_12_total 388.0 7.0 47.0 4.0   4.0       1.0 19.0   231.0 239.0                       470.0 388 7 47 4   4       1 19   231 239                 470
257411 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2018   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
364686 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2019   pk_12_total 14.0   1.0 9.0             1.0   19.0 6.0                       25.0 14   1 9             1   19 6                 25
456564 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School Not applicable Other PK 12 2021   pk_12_total 15.0   1.0 7.0   1.0         5.0   21.0 8.0                       29.0 15   1 7   1         5   21 8                 29
494971 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School Not applicable Other PK 12 2020   pk_12_total 22.0   1.0 17.0             2.0   26.0 16.0                       42.0 22   1 17             2   26 16                 42
2969020 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No 4 PK 12 2015   pk_12_total 17.0     5.0             2.0   16.0 8.0                       24.0 17     5             2   16 8                 24
3013852 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2017   pk_12_total 23.0 1.0 2.0 9.0             1.0   24.0 12.0                       36.0 23 1 2 9             1   24 12                 36
3351716 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No 4 PK 12 2016   pk_12_total 10.0     11.0                 15.0 6.0                       21.0 10     11                 15 6                 21
258434 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   pk_12_total 417.0 38.0 48.0 21.0   6.0       1.0 48.0   286.0 293.0                       579.0 417 38 48 21   6       1 48   286 293                 579
365694 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2019   pk_12_total 390.0 43.0 43.0 33.0   6.0         41.0   281.0 275.0                       556.0 390 43 43 33   6         41   281 275                 556
457556 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 359.0 64.0 64.0 31.0   7.0         36.0   289.0 272.0                       561.0 359 64 64 31   7         36   289 272                 561
495979 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 383.0 40.0 42.0 33.0   9.0         45.0   277.0 275.0                       552.0 383 40 42 33   9         45   277 275                 552
2970171 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2015   pk_12_total 493.0 35.0 37.0 30.0   6.0       2.0 34.0   335.0 302.0                       637.0 493 35 37 30   6       2 34   335 302                 637
3014859 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2017   pk_12_total 454.0 41.0 42.0 16.0   5.0       1.0 50.0   302.0 307.0                       609.0 454 41 42 16   5       1 50   302 307                 609
3352740 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   pk_12_total 455.0 42.0 45.0 17.0   6.0       2.0 45.0   318.0 294.0                       612.0 455 42 45 17   6       2 45   318 294                 612
258425 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2018   pk_12_total 492.0 33.0 28.0 15.0   5.0         47.0   288.0 332.0                       620.0 492 33 28 15   5         47   288 332                 620
365686 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2019   pk_12_total 466.0 37.0 31.0 18.0   5.0         49.0   290.0 316.0                       606.0 466 37 31 18   5         49   290 316                 606
457547 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 461.0 40.0 48.0 19.0   9.0         53.0   320.0 310.0                       630.0 461 40 48 19   9         53   320 310                 630
495970 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 462.0 31.0 34.0 14.0   8.0         52.0   290.0 311.0                       601.0 462 31 34 14   8         52   290 311                 601
2970160 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2015   pk_12_total 568.0 30.0 19.0 8.0   7.0         39.0   332.0 339.0                       671.0 568 30 19 8   7         39   332 339                 671
3014850 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2017   pk_12_total 518.0 23.0 28.0 12.0   6.0         44.0   288.0 343.0                       631.0 518 23 28 12   6         44   288 343                 631
3352731 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2016   pk_12_total 542.0 27.0 21.0 9.0   9.0         53.0   310.0 351.0                       661.0 542 27 21 9   9         53   310 351                 661
258423 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2018   pk_12_total 158.0 105.0 73.0 71.0   17.0         65.0   254.0 235.0                       489.0 158 105 73 71   17         65   254 235                 489
365684 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2019   pk_12_total 138.0 101.0 78.0 81.0   13.0       1.0 59.0   248.0 223.0                       471.0 138 101 78 81   13       1 59   248 223                 471
457545 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 114.0 68.0 74.0 57.0   8.0       2.0 42.0   184.0 181.0                       365.0 114 68 74 57   8       2 42   184 181                 365
495968 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 115.0 75.0 73.0 68.0   9.0       1.0 56.0   201.0 196.0                       397.0 115 75 73 68   9       1 56   201 196                 397
2970156 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2015   pk_12_total 166.0 138.0 88.0 76.0   35.0       3.0 45.0   315.0 236.0                       551.0 166 138 88 76   35       3 45   315 236                 551
3014848 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2017   pk_12_total 158.0 103.0 88.0 61.0   11.0         53.0   254.0 220.0                       474.0 158 103 88 61   11         53   254 220                 474
3352728 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   pk_12_total 144.0 120.0 89.0 62.0   33.0       2.0 50.0   267.0 233.0                       500.0 144 120 89 62   33       2 50   267 233                 500
2970142 SD     school 4666270 49005   Sioux Falls 49-5 466627000771 55 Bridges At Jefferson   Regular School No 1 KG 05 2015   pk_12_total 14.0 6.0 1.0               1.0   17.0 5.0                       22.0 14 6 1               1   17 5                 22
3352714 SD     school 4666270 49005   Sioux Falls 49-5 466627000771 55 Bridges at Garfield   Regular School No 1 KG 05 2016   pk_12_total 9.0 2.0 3.0 2.0             3.0   15.0 4.0                       19.0 9 2 3 2             3   15 4                 19
258422 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   pk_12_total 551.0 58.0 40.0 15.0   25.0         56.0   389.0 356.0                       745.0 551 58 40 15   25         56   389 356                 745
365683 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2019   pk_12_total 550.0 53.0 38.0 28.0   18.0         71.0   377.0 381.0                       758.0 550 53 38 28   18         71   377 381                 758
457544 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 488.0 67.0 41.0 18.0   12.0         59.0   370.0 315.0                       685.0 488 67 41 18   12         59   370 315                 685
495967 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 547.0 70.0 35.0 26.0   13.0         69.0   399.0 361.0                       760.0 547 70 35 26   13         69   399 361                 760
2970155 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2015   pk_12_total 562.0 52.0 40.0 23.0   15.0         50.0   386.0 356.0                       742.0 562 52 40 23   15         50   386 356                 742
3014847 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   pk_12_total 555.0 70.0 39.0 16.0   21.0         50.0   384.0 367.0                       751.0 555 70 39 16   21         50   384 367                 751
3352727 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   pk_12_total 568.0 57.0 34.0 15.0   14.0         52.0   373.0 367.0                       740.0 568 57 34 15   14         52   373 367                 740
258431 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2018   pk_12_total   40.0 27.0     9.0             36.0 40.0                       76.0   40 27     9             36 40                 76
2970167 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2015   pk_12_total 3.0 32.0 4.0     19.0             31.0 27.0                       58.0 3 32 4     19             31 27                 58
3014856 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2017   pk_12_total   34.0 21.0     9.0             38.0 26.0                       64.0   34 21     9             38 26                 64
3352737 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2016   pk_12_total 2.0 40.0 13.0     7.0             29.0 33.0                       62.0 2 40 13     7             29 33                 62

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