Data source: Big Local News · About: Big Local

4,696 rows where grade = "k_12_total" and state = "SD" sorted by district_nces_id descending

View and edit SQL

year

grade

  • k_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
251809 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School No Elementary PK 06 2018   k_12_total 133.0   2.0     1.0             71.0 65.0       0.0               136.0 133   2     1             71 65                 136
251810 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School No High 09 12 2018   k_12_total 78.0                   1.0   47.0 32.0       0.0               79.0 78                   1   47 32                 79
251811 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School No Middle 07 08 2018   k_12_total 36.0                       15.0 21.0       0.0               36.0 36                       15 21                 36
359068 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School No Elementary PK 06 2019   k_12_total 140.0     0.0   1.0             70.0 71.0       0.0               141.0 140     0   1             70 71                 141
359069 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School No High 09 12 2019   k_12_total 81.0                       43.0 38.0       0.0               81.0 81                       43 38                 81
359070 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School No Middle 07 08 2019   k_12_total 30.0                       14.0 16.0       0.0               30.0 30                       14 16                 30
450914 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 133.0   2.0 3.0   1.0         6.0   74.0 71.0       1.4               145.0 133   2 3   1         6   74 71                 145
450915 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School Not applicable High 09 12 2021   k_12_total 75.0     1.0                 38.0 38.0       0.0               76.0 75     1                 38 38                 76
450916 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School Not applicable Middle 07 08 2021   k_12_total 35.0                   1.0   20.0 16.0       0.0               36.0 35                   1   20 16                 36
489337 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 144.0   2.0 1.0   1.0             72.0 76.0       1.4               148.0 144   2 1   1             72 76                 148
489338 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School Not applicable High 09 12 2020   k_12_total 78.0                       37.0 41.0       0.0               78.0 78                       37 41                 78
489339 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School Not applicable Middle 07 08 2020   k_12_total 28.0                       17.0 11.0       0.0               28.0 28                       17 11                 28
3008218 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School No Elementary PK 06 2017   k_12_total 126.0     1.0   1.0             65.0 63.0       0.0               128.0 126     1   1             65 63                 128
3008219 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School No High 09 12 2017   k_12_total 67.0 1.0   3.0                 47.0 24.0       0.0               71.0 67 1   3                 47 24                 71
3008220 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School No Middle 07 08 2017   k_12_total 47.0                       22.0 25.0       0.0               47.0 47                       22 25                 47
3346130 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School No 1 PK 06 2016   k_12_total 127.0                       61.0 66.0       0.0               127.0 127                       61 66                 127
3346131 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School No 3 09 12 2016   k_12_total 64.0                       39.0 25.0       0.0               64.0 64                       39 25                 64
3346132 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School No 2 07 08 2016   k_12_total 39.0                       19.0 20.0       0.0               39.0 39                       19 20                 39
256189 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2018   k_12_total 67.0 2.0 4.0 59.0   2.0             66.0 68.0       0.0               134.0 67 2 4 59   2             66 68                 134
256190 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No High 09 12 2018   k_12_total 128.0   7.0 62.0             5.0   114.0 88.0       0.5               202.0 128   7 62             5   114 88                 202
256191 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No Middle 06 08 2018   k_12_total 81.0 1.0 2.0 56.0             6.0   76.0 70.0       0.0               146.0 81 1 2 56             6   76 70                 146
256192 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2018   k_12_total 89.0 3.0 6.0 45.0   1.0             66.0 78.0       0.0               144.0 89 3 6 45   1             66 78                 144
363432 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2019   k_12_total 71.0 1.0 1.0 54.0   1.0             57.0 71.0       0.0               128.0 71 1 1 54   1             57 71                 128
363433 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No High 09 12 2019   k_12_total 111.0 1.0 6.0 71.0             8.0   105.0 92.0       0.5               197.0 111 1 6 71             8   105 92                 197
363434 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No Middle 06 08 2019   k_12_total 86.0 1.0 5.0 52.0   1.0         4.0   75.0 74.0       0.0               149.0 86 1 5 52   1         4   75 74                 149
363435 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2019   k_12_total 75.0 3.0 7.0 57.0             1.0   68.0 75.0       0.0               143.0 75 3 7 57             1   68 75                 143
455294 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2021   k_12_total 93.0 1.0 2.0 47.0             1.0   68.0 76.0       0.0               144.0 93 1 2 47             1   68 76                 144
455295 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School Not applicable High 09 12 2021   k_12_total 109.0   5.0 71.0             11.0   101.0 95.0       0.0               196.0 109   5 71             11   101 95                 196
455296 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 89.0 3.0 5.0 48.0   1.0         3.0   66.0 83.0       0.0               149.0 89 3 5 48   1         3   66 83                 149
455297 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2021   k_12_total 62.0 3.0 4.0 58.0   1.0         4.0   64.0 68.0       0.0               132.0 62 3 4 58   1         4   64 68                 132
493717 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2020   k_12_total 77.0   1.0 57.0   1.0             62.0 74.0       0.0               136.0 77   1 57   1             62 74                 136
493718 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School Not applicable High 09 12 2020   k_12_total 107.0 1.0 6.0 65.0             9.0   97.0 91.0       0.0               188.0 107 1 6 65             9   97 91                 188
493719 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 86.0 1.0 4.0 45.0   1.0         5.0   70.0 72.0       0.0               142.0 86 1 4 45   1         5   70 72                 142
493720 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2020   k_12_total 64.0 5.0 7.0 61.0                 70.0 67.0       0.0               137.0 64 5 7 61                 70 67                 137
2967878 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2015   k_12_total 91.0   7.0 64.0   1.0       3.0     65.0 101.0                       166.0 91   7 64   1       3     65 101                 166
2967879 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No 3 09 12 2015   k_12_total 146.0 1.0 8.0 59.0             8.0   117.0 105.0                       222.0 146 1 8 59             8   117 105                 222
2967880 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No 2 06 08 2015   k_12_total 83.0   4.0 47.0             2.0   79.0 57.0                       136.0 83   4 47             2   79 57                 136
2967881 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   k_12_total 81.0   2.0 60.0   1.0         4.0   72.0 76.0                       148.0 81   2 60   1         4   72 76                 148
3012614 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2017   k_12_total 66.0 4.0 3.0 69.0                 67.0 75.0       0.0               142.0 66 4 3 69                 67 75                 142
3012615 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No High 09 12 2017   k_12_total 127.0   8.0 68.0             7.0   117.0 93.0       0.5               210.0 127   8 68             7   117 93                 210
3012616 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No Middle 06 08 2017   k_12_total 80.0   5.0 57.0             5.0   77.0 70.0       0.0               147.0 80   5 57             5   77 70                 147
3012617 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2017   k_12_total 90.0 1.0 4.0 58.0   1.0         5.0   73.0 86.0       0.0               159.0 90 1 4 58   1         5   73 86                 159
3350478 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2016   k_12_total 87.0 2.0 6.0 61.0                 69.0 87.0       0.0               156.0 87 2 6 61                 69 87                 156
3350479 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No 3 09 12 2016   k_12_total 134.0   6.0 68.0             6.0   112.0 102.0       0.5               214.0 134   6 68             6   112 102                 214
3350480 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No 2 06 08 2016   k_12_total 84.0   5.0 53.0             6.0   83.0 65.0       0.0               148.0 84   5 53             6   83 65                 148
3350481 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2016   k_12_total 88.0   4.0 64.0   2.0         5.0   79.0 84.0       0.0               163.0 88   4 64   2         5   79 84                 163
254097 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2018   k_12_total 98.0 0.0 2.0 13.0             3.0   53.0 63.0       0.0               116.0 98 0 2 13             3   53 63                 116
254098 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No High 09 12 2018   k_12_total 63.0   2.0 10.0             3.0   39.0 39.0       0.0               78.0 63   2 10             3   39 39                 78
254099 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2018   k_12_total 35.0     1.0             5.0   27.0 14.0       0.0               41.0 35     1             5   27 14                 41
361324 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2019   k_12_total 88.0   2.0 17.0             3.0   52.0 58.0       0.0               110.0 88   2 17             3   52 58                 110
361325 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No High 09 12 2019   k_12_total 67.0   2.0 11.0             4.0   46.0 38.0       0.0               84.0 67   2 11             4   46 38                 84
361326 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2019   k_12_total 34.0     1.0             2.0   20.0 17.0       0.0               37.0 34     1             2   20 17                 37
453170 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 85.0   4.0 17.0             3.0   52.0 57.0       0.0               109.0 85   4 17             3   52 57                 109
453171 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School Not applicable High 09 12 2021   k_12_total 67.0     3.0             6.0   49.0 27.0       0.0               76.0 67     3             6   49 27                 76
453172 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School Not applicable Middle 07 08 2021   k_12_total 26.0     4.0                 16.0 14.0       0.0               30.0 26     4                 16 14                 30
491593 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 87.0   3.0 18.0             3.0   57.0 54.0       0.0               111.0 87   3 18             3   57 54                 111
491594 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School Not applicable High 09 12 2020   k_12_total 68.0   1.0 4.0             6.0   50.0 29.0       0.0               79.0 68   1 4             6   50 29                 79
491595 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School Not applicable Middle 07 08 2020   k_12_total 31.0     2.0                 14.0 19.0       0.0               33.0 31     2                 14 19                 33
2965866 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No 1 PK 06 2015   k_12_total 115.0 1.0   11.0             5.0   74.0 58.0                       132.0 115 1   11             5   74 58                 132
2965867 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No 3 09 12 2015   k_12_total 73.0   5.0 6.0             5.0   45.0 44.0                       89.0 73   5 6             5   45 44                 89
2965868 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No 2 07 08 2015   k_12_total 30.0   2.0 8.0                 18.0 22.0                       40.0 30   2 8                 18 22                 40
3010554 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2017   k_12_total 108.0   1.0 11.0             3.0   61.0 62.0       0.0               123.0 108   1 11             3   61 62                 123
3010555 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No High 09 12 2017   k_12_total 62.0   2.0 11.0   1.0         5.0   34.0 47.0       0.0               81.0 62   2 11   1         5   34 47                 81
3010556 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2017   k_12_total 38.0     5.0             3.0   29.0 17.0       0.0               46.0 38     5             3   29 17                 46
3348450 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No 1 PK 06 2016   k_12_total 112.0   2.0 8.0             6.0   70.0 58.0       0.0               128.0 112   2 8             6   70 58                 128
3348451 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No 3 09 12 2016   k_12_total 70.0   2.0 8.0             4.0   40.0 44.0       0.0               84.0 70   2 8             4   40 44                 84
3348452 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No 2 07 08 2016   k_12_total 31.0     7.0                 22.0 16.0       0.0               38.0 31     7                 22 16                 38
254641 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No Elementary PK 06 2018   k_12_total 146.0   2.0 4.0             4.0   80.0 76.0       0.0               156.0 146   2 4             4   80 76                 156
254642 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School No High 09 12 2018   k_12_total 84.0 1.0 3.0 2.0                 48.0 42.0       0.0               90.0 84 1 3 2                 48 42                 90
254643 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No Middle 07 08 2018   k_12_total 47.0     1.0                 19.0 29.0       0.0               48.0 47     1                 19 29                 48
361868 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No Elementary PK 06 2019   k_12_total 142.0   1.0 3.0             10.0   75.0 81.0       0.0               156.0 142   1 3             10   75 81                 156
361869 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School No High 09 12 2019   k_12_total 76.0   2.0 2.0                 37.0 43.0       0.0               80.0 76   2 2                 37 43                 80
361870 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No Middle 07 08 2019   k_12_total 46.0     1.0                 23.0 24.0       0.0               47.0 46     1                 23 24                 47
453714 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School Not applicable Elementary PK 06 2021   k_12_total 143.0   2.0 2.0             8.0   85.0 70.0       0.0               155.0 143   2 2             8   85 70                 155
453715 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School Not applicable High 09 12 2021   k_12_total 86.0   1.0 4.0                 39.0 52.0       0.0               91.0 86   1 4                 39 52                 91
453716 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School Not applicable Middle 07 08 2021   k_12_total 41.0     1.0             2.0   16.0 28.0       0.0               44.0 41     1             2   16 28                 44
492137 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School Not applicable Elementary PK 06 2020   k_12_total 138.0   1.0 3.0             9.0   78.0 73.0       0.0               151.0 138   1 3             9   78 73                 151
492138 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School Not applicable High 09 12 2020   k_12_total 92.0   1.0 3.0                 43.0 53.0       0.0               96.0 92   1 3                 43 53                 96
492139 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School Not applicable Middle 07 08 2020   k_12_total 39.0   1.0 2.0                 21.0 21.0       0.0               42.0 39   1 2                 21 21                 42
2966378 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No 1 PK 06 2015   k_12_total 140.0 1.0 2.0 2.0             0.0   62.0 83.0                       145.0 140 1 2 2             0   62 83                 145
2966379 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School No 3 09 12 2015   k_12_total 86.0 3.0 1.0 1.0                 42.0 49.0                       91.0 86 3 1 1                 42 49                 91
2966380 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No 2 07 08 2015   k_12_total 41.0   1.0                   24.0 18.0                       42.0 41   1                   24 18                 42
3011098 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No Elementary PK 06 2017   k_12_total 144.0   1.0 3.0             3.0   71.0 80.0       0.0               151.0 144   1 3             3   71 80                 151
3011099 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School No High 09 12 2017   k_12_total 96.0 1.0 4.0                   58.0 43.0       0.0               101.0 96 1 4                   58 43                 101
3011100 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No Middle 07 08 2017   k_12_total 37.0   1.0 3.0                 14.0 27.0       0.0               41.0 37   1 3                 14 27                 41
3348962 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No 1 PK 06 2016   k_12_total 147.0   1.0 3.0             1.0   68.0 84.0       0.0               152.0 147   1 3             1   68 84                 152
3348963 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School No 3 09 12 2016   k_12_total 92.0 1.0 4.0                   47.0 50.0       0.0               97.0 92 1 4                   47 50                 97
3348964 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No 2 07 08 2016   k_12_total 38.0   1.0 1.0                 19.0 21.0       0.0               40.0 38   1 1                 19 21                 40
257033 SD     school 4680438 11005   Platte-Geddes 11-5 468043801252 14 Cedar Grove Colony School   Regular School No Elementary KG 08 2018   k_12_total 42.0                       15.0 27.0       42.9               42.0 42                       15 27                 42
257034 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School No Elementary KG 08 2018   k_12_total 28.0                       15.0 13.0       39.3               28.0 28                       15 13                 28
257035 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No Elementary KG 06 2018   k_12_total 211.0 1.0 3.0 13.0             19.0   119.0 128.0       0.0               247.0 211 1 3 13             19   119 128                 247
257036 SD     school 4680438 11005   Platte-Geddes 11-5 468043801248 1 Platte-Geddes H.S   Regular School No High 09 12 2018   k_12_total 112.0   3.0 1.0             4.0   59.0 61.0       0.0               120.0 112   3 1             4   59 61                 120
257037 SD     school 4680438 11005   Platte-Geddes 11-5 468043801250 3 Platte-Geddes Jr. Hi   Regular School No Middle 07 08 2018   k_12_total 58.0 1.0   3.0             3.0   33.0 32.0       1.5               65.0 58 1   3             3   33 32                 65
364308 SD     school 4680438 11005   Platte-Geddes 11-5 468043801252 14 Cedar Grove Colony School   Regular School No Elementary KG 08 2019   k_12_total 42.0                       16.0 26.0       45.2               42.0 42                       16 26                 42
364309 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School No Elementary KG 08 2019   k_12_total 26.0                       12.0 14.0       38.5               26.0 26                       12 14                 26
364310 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No Elementary KG 06 2019   k_12_total 214.0 1.0 6.0 7.0             19.0   120.0 127.0       0.4               247.0 214 1 6 7             19   120 127                 247
364311 SD     school 4680438 11005   Platte-Geddes 11-5 468043801248 1 Platte-Geddes H.S   Regular School No High 09 12 2019   k_12_total 108.0 1.0 2.0 3.0             6.0   61.0 59.0       0.8               120.0 108 1 2 3             6   61 59                 120
364312 SD     school 4680438 11005   Platte-Geddes 11-5 468043801250 3 Platte-Geddes Jr. Hi   Regular School No Middle 07 08 2019   k_12_total 65.0     1.0             2.0   31.0 37.0       0.0               68.0 65     1             2   31 37                 68
456186 SD     school 4680438 11005   Platte-Geddes 11-5 468043801252 14 Cedar Grove Colony School   Regular School Not applicable Elementary KG 08 2021   k_12_total 44.0                       19.0 25.0       59.1               44.0 44                       19 25                 44
456187 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School Not applicable Elementary KG 08 2021   k_12_total 20.0                       8.0 12.0       30.0               20.0 20                       8 12                 20

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