Data source: Big Local News · About: Big Local

4,696 rows where grade = "pk_12_total" and state = "SD" sorted by school 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
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
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
260534 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pk_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0                       635.0 529 9 42 36   4         15   335 300                 635
367793 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2019   pk_12_total 524.0 8.0 54.0 28.0   3.0         22.0   338.0 301.0                       639.0 524 8 54 28   3         22   338 301                 639
459703 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 521.0 8.0 57.0 29.0   3.0       1.0 21.0   321.0 319.0                       640.0 521 8 57 29   3       1 21   321 319                 640
498094 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 530.0 4.0 51.0 27.0   2.0         23.0   330.0 307.0                       637.0 530 4 51 27   2         23   330 307                 637
2972319 SD     school 4680430 63003   Yankton 63-3 468043000799 2 Yankton Middle School   Regular School No 2 06 08 2015   pk_12_total 489.0 8.0 31.0 37.0   3.0         5.0   313.0 260.0                       573.0 489 8 31 37   3         5   313 260                 573
3016927 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2017   pk_12_total 503.0 9.0 40.0 35.0   5.0         7.0   315.0 284.0                       599.0 503 9 40 35   5         7   315 284                 599
3354823 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No 2 06 08 2016   pk_12_total 492.0 11.0 32.0 32.0   4.0         10.0   309.0 272.0                       581.0 492 11 32 32   4         10   309 272                 581
459702 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2021   pk_12_total 777.0 15.0 74.0 45.0   6.0         22.0   497.0 442.0                       939.0 777 15 74 45   6         22   497 442                 939
498093 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2020   pk_12_total 782.0 13.0 57.0 40.0   7.0         14.0   483.0 430.0                       913.0 782 13 57 40   7         14   483 430                 913
260533 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pk_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0                       867.0 745 10 60 38   9         5   453 414                 867
367792 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2019   pk_12_total 774.0 13.0 56.0 41.0   8.0         9.0   467.0 434.0                       901.0 774 13 56 41   8         9   467 434                 901
2972318 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   pk_12_total 772.0 17.0 45.0 25.0   9.0         7.0   457.0 418.0                       875.0 772 17 45 25   9         7   457 418                 875
3016926 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   pk_12_total 788.0 18.0 47.0 31.0   7.0         10.0   464.0 437.0                       901.0 788 18 47 31   7         10   464 437                 901
3354822 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2016   pk_12_total 783.0 18.0 48.0 23.0   9.0         8.0   475.0 414.0                       889.0 783 18 48 23   9         8   475 414                 889
255239 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pk_12_total 91.0   3.0 2.0                 55.0 41.0                       96.0 91   3 2                 55 41                 96
362466 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2019   pk_12_total 111.0   3.0 1.0             1.0   68.0 48.0                       116.0 111   3 1             1   68 48                 116
454312 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School Not applicable Elementary PK 04 2021   pk_12_total 105.0   4.0 3.0   1.0             66.0 47.0                       113.0 105   4 3   1             66 47                 113
492735 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School Not applicable Elementary PK 04 2020   pk_12_total 96.0   3.0 3.0   1.0         1.0   63.0 41.0                       104.0 96   3 3   1         1   63 41                 104
2966945 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No 1 KG 05 2015   pk_12_total 125.0 3.0 3.0 2.0             2.0   69.0 66.0                       135.0 125 3 3 2             2   69 66                 135
3011680 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2017   pk_12_total 91.0 1.0 4.0 4.0             1.0   57.0 44.0                       101.0 91 1 4 4             1   57 44                 101
3349544 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No 1 PK 04 2016   pk_12_total 106.0   3.0 1.0             1.0   58.0 53.0                       111.0 106   3 1             1   58 53                 111
260442 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   pk_12_total 66.0   3.0                   35.0 34.0                       69.0 66   3                   35 34                 69
367701 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2019   pk_12_total 65.0   3.0     1.0         1.0   33.0 37.0                       70.0 65   3     1         1   33 37                 70
459611 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School Not applicable High 09 12 2021   pk_12_total 63.0   3.0     2.0         3.0   31.0 40.0                       71.0 63   3     2         3   31 40                 71
498002 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School Not applicable High 09 12 2020   pk_12_total 63.0   2.0               1.0   29.0 37.0                       66.0 63   2               1   29 37                 66
2972227 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No 3 09 12 2015   pk_12_total 54.0   3.0 1.0             1.0   40.0 19.0                       59.0 54   3 1             1   40 19                 59
3016835 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2017   pk_12_total 62.0   2.0               1.0   34.0 31.0                       65.0 62   2               1   34 31                 65
3354731 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No 3 09 12 2016   pk_12_total 52.0     1.0             1.0   34.0 20.0                       54.0 52     1             1   34 20                 54
260441 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   pk_12_total 164.0 1.0 12.0     3.0         6.0   94.0 92.0                       186.0 164 1 12     3         6   94 92                 186
367700 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2019   pk_12_total 196.0 1.0 11.0 2.0   2.0         7.0   112.0 107.0                       219.0 196 1 11 2   2         7   112 107                 219
459610 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School Not applicable Elementary PK 08 2021   pk_12_total 183.0   9.0 4.0             4.0   108.0 92.0                       200.0 183   9 4             4   108 92                 200
498001 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School Not applicable Elementary PK 08 2020   pk_12_total 183.0 1.0 8.0 2.0   2.0         6.0   108.0 94.0                       202.0 183 1 8 2   2         6   108 94                 202
2972226 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No 1 PK 08 2015   pk_12_total 147.0   6.0     2.0         6.0   83.0 78.0                       161.0 147   6     2         6   83 78                 161
3016834 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2017   pk_12_total 145.0   9.0     2.0         7.0   82.0 81.0                       163.0 145   9     2         7   82 81                 163
3354730 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No 1 PK 08 2016   pk_12_total 152.0   5.0     3.0         6.0   84.0 82.0                       166.0 152   5     3         6   84 82                 166
257427 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   pk_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0                       353.0 212 2 27 70   7       1 34   170 183                 353
364702 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2019   pk_12_total 219.0 6.0 29.0 51.0   3.0         50.0   180.0 178.0                       358.0 219 6 29 51   3         50   180 178                 358
456580 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School Not applicable Elementary KG 05 2021   pk_12_total 177.0 12.0 41.0 52.0   6.0         46.0   169.0 165.0                       334.0 177 12 41 52   6         46   169 165                 334
494987 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School Not applicable Elementary KG 05 2020   pk_12_total 231.0 6.0 33.0 47.0   5.0         48.0   182.0 188.0                       370.0 231 6 33 47   5         48   182 188                 370
2969036 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No 1 PK 05 2015   pk_12_total 252.0 1.0 30.0 76.0   3.0         20.0   190.0 192.0                       382.0 252 1 30 76   3         20   190 192                 382
3013868 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2017   pk_12_total 213.0 2.0 27.0 72.0   4.0         27.0   168.0 177.0                       345.0 213 2 27 72   4         27   168 177                 345
3351732 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No 1 KG 05 2016   pk_12_total 241.0 4.0 25.0 70.0   4.0         26.0   178.0 192.0                       370.0 241 4 25 70   4         26   178 192                 370
251768 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   pk_12_total 5.0     8.0                 6.0 7.0                       13.0 5     8                 6 7                 13
359027 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2019   pk_12_total 4.0     9.0                 4.0 9.0                       13.0 4     9                 4 9                 13
450873 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 6.0     10.0                 4.0 12.0                       16.0 6     10                 4 12                 16
489296 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School Not applicable Elementary KG 08 2020   pk_12_total 3.0     8.0                 4.0 7.0                       11.0 3     8                 4 7                 11
2963489 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No 1 KG 08 2015   pk_12_total 7.0     8.0                 6.0 9.0                       15.0 7     8                 6 9                 15
3008177 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2017   pk_12_total 2.0     9.0                 4.0 7.0                       11.0 2     9                 4 7                 11
3346089 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No 1 KG 08 2016   pk_12_total 6.0     8.0                 4.0 10.0                       14.0 6     8                 4 10                 14
260409 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2018   pk_12_total 96.0 4.0 13.0               7.0   51.0 69.0                       120.0 96 4 13               7   51 69                 120
367668 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2019   pk_12_total 94.0   13.0               6.0   57.0 56.0                       113.0 94   13               6   57 56                 113
459578 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 70.0   11.0               4.0   44.0 41.0                       85.0 70   11               4   44 41                 85
497969 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School Not applicable Middle 05 08 2020   pk_12_total 91.0   15.0               6.0   53.0 59.0                       112.0 91   15               6   53 59                 112
2972194 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No 2 06 08 2015   pk_12_total 73.0 4.0 1.0 1.0             3.0   47.0 35.0                       82.0 73 4 1 1             3   47 35                 82
3016802 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2017   pk_12_total 97.0 5.0 10.0 3.0             6.0   53.0 68.0                       121.0 97 5 10 3             6   53 68                 121
3354698 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No 2 06 08 2016   pk_12_total 46.0 3.0 2.0 1.0             1.0   29.0 24.0                       53.0 46 3 2 1             1   29 24                 53
260408 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2018   pk_12_total 93.0 5.0 7.0 2.0             2.0   65.0 44.0                       109.0 93 5 7 2             2   65 44                 109
367667 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2019   pk_12_total 92.0 3.0 7.0               4.0   51.0 55.0                       106.0 92 3 7               4   51 55                 106
459577 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School Not applicable High 09 12 2021   pk_12_total 88.0 3.0 10.0               7.0   50.0 58.0                       108.0 88 3 10               7   50 58                 108
497968 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School Not applicable High 09 12 2020   pk_12_total 89.0 4.0 9.0               6.0   52.0 56.0                       108.0 89 4 9               6   52 56                 108
2972193 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No 3 09 12 2015   pk_12_total 84.0 4.0 4.0 2.0                 55.0 39.0                       94.0 84 4 4 2                 55 39                 94
3016801 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2017   pk_12_total 90.0 5.0 5.0 2.0             1.0   69.0 34.0                       103.0 90 5 5 2             1   69 34                 103
3354697 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No 3 09 12 2016   pk_12_total 95.0 4.0 3.0 2.0             1.0   67.0 38.0                       105.0 95 4 3 2             1   67 38                 105
260407 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2018   pk_12_total 134.0 2.0 16.0               3.0   76.0 79.0                       155.0 134 2 16               3   76 79                 155
367666 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2019   pk_12_total 138.0 1.0 15.0 1.0             3.0   71.0 87.0                       158.0 138 1 15 1             3   71 87                 158
459576 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 167.0 1.0 13.0               1.0   86.0 96.0                       182.0 167 1 13               1   86 96                 182
497967 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School Not applicable Elementary PK 04 2020   pk_12_total 148.0 1.0 13.0               1.0   70.0 93.0                       163.0 148 1 13               1   70 93                 163
2972192 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No 1 PK 05 2015   pk_12_total 171.0 4.0 5.0 2.0             10.0   92.0 100.0                       192.0 171 4 5 2             10   92 100                 192
3016800 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2017   pk_12_total 136.0 1.0 13.0               6.0   78.0 78.0                       156.0 136 1 13               6   78 78                 156
3354696 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No 1 PK 06 2016   pk_12_total 187.0 6.0 15.0               10.0   102.0 116.0                       218.0 187 6 15               10   102 116                 218
256583 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   pk_12_total 4.0   9.0 669.0             2.0   366.0 318.0                       684.0 4   9 669             2   366 318                 684
363842 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2019   pk_12_total 1.0   9.0 648.0             2.0   333.0 327.0                       660.0 1   9 648             2   333 327                 660
455719 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School Not applicable Elementary PK 08 2021   pk_12_total     12.0 688.0             4.0   347.0 357.0                       704.0     12 688             4   347 357                 704
494127 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School Not applicable Elementary PK 08 2020   pk_12_total     10.0 633.0             1.0   311.0 333.0                       644.0     10 633             1   311 333                 644
2969503 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   pk_12_total     13.0 627.0             5.0   344.0 301.0                       645.0     13 627             5   344 301                 645
3013023 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2017   pk_12_total 3.0   11.0 690.0             3.0   362.0 345.0                       707.0 3   11 690             3   362 345                 707
3350887 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2016   pk_12_total 3.0   15.0 675.0             5.0   357.0 341.0                       698.0 3   15 675             5   357 341                 698
253287 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 27.0                       13.0 14.0                       27.0 27                       13 14                 27
360514 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2019   pk_12_total 29.0                       15.0 14.0                       29.0 29                       15 14                 29
452360 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 30.0                       14.0 16.0                       30.0 30                       14 16                 30
490783 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School Not applicable Elementary KG 08 2020   pk_12_total 29.0                       14.0 15.0                       29.0 29                       14 15                 29
2965008 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No 1 KG 08 2015   pk_12_total 29.0                       17.0 12.0                       29.0 29                       17 12                 29
3009696 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 26.0                       13.0 13.0                       26.0 26                       13 13                 26
3347592 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No 1 KG 08 2016   pk_12_total 29.0                       16.0 13.0                       29.0 29                       16 13                 29
260361 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2018   pk_12_total 116.0   1.0 44.0   2.0             86.0 77.0                       163.0 116   1 44   2             86 77                 163
367620 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2019   pk_12_total 106.0   1.0 51.0             1.0   88.0 71.0                       159.0 106   1 51             1   88 71                 159
459530 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 92.0 2.0   56.0   1.0             85.0 66.0                       151.0 92 2   56   1             85 66                 151
497921 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 95.0 2.0   50.0                 79.0 68.0                       147.0 95 2   50                 79 68                 147
2972146 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No 2 06 08 2015   pk_12_total 96.0 1.0   51.0   1.0             67.0 82.0                       149.0 96 1   51   1             67 82                 149
3016754 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2017   pk_12_total 106.0 1.0 2.0 42.0   3.0             71.0 83.0                       154.0 106 1 2 42   3             71 83                 154
3354650 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No 2 06 08 2016   pk_12_total 103.0 2.0   54.0   2.0             78.0 83.0                       161.0 103 2   54   2             78 83                 161
260360 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   pk_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0                       199.0 147 3 1 45   2       1     99 100                 199
367619 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2019   pk_12_total 146.0 3.0 3.0 40.0   2.0         1.0   93.0 102.0                       195.0 146 3 3 40   2         1   93 102                 195
459529 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School Not applicable High 09 12 2021   pk_12_total 152.0 1.0 2.0 47.0   1.0             101.0 102.0                       203.0 152 1 2 47   1             101 102                 203
497920 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School Not applicable High 09 12 2020   pk_12_total 147.0 2.0 3.0 50.0   2.0         1.0   105.0 100.0                       205.0 147 2 3 50   2         1   105 100                 205
2972145 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No 3 09 12 2015   pk_12_total 139.0   1.0 42.0                 98.0 84.0                       182.0 139   1 42                 98 84                 182
3016753 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2017   pk_12_total 142.0 1.0 1.0 49.0           1.0 1.0   103.0 92.0                       195.0 142 1 1 49           1 1   103 92                 195
3354649 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No 3 09 12 2016   pk_12_total 143.0     52.0           1.0     105.0 91.0                       196.0 143     52           1     105 91                 196

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