enrollments

Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic ▲ native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
495908 495908 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 141.0 92.0 99.0 55.0   20.0         39.0   238.0 208.0       28.3               446.0 141 92 99 55   20         39   238 208                 446
457563 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
359607 359607 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   k_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0       0.6               978.0 662 23 98 63   6       1 125   504 474                 978
359617 359617 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   pk_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0                       978.0 662 23 98 63   6       1 125   504 474                 978
457468 457468 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 126.0 63.0 98.0 51.0   3.0         41.0   196.0 186.0       20.4               382.0 126 63 98 51   3         41   196 186                 382
3014768 3014768 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2017   k_12_total 113.0 63.0 97.0 22.0   8.0         24.0   161.0 166.0       22.3               327.0 113 63 97 22   8         24   161 166                 327
258360 258360 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   k_12_total 288.0 71.0 96.0 22.0   18.0       3.0 38.0   280.0 256.0       19.0               536.0 288 71 96 22   18       3 38   280 256                 536
258446 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
365573 365573 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2019   grade_9 454.0 58.0 96.0 51.0   19.0       0.0 31.0   370.0 339.0                       709.0 454 58 96 51   19       0 31   370 339                 709
495888 495888 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 99.0 54.0 96.0 20.0   20.0         18.0   157.0 150.0       31.9               307.0 99 54 96 20   20         18   157 150                 307
457024 457024 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_10 258.0 101.0 96.0 30.0   26.0       0.0 22.0   280.0 253.0                       533.0 258 101 96 30   26       0 22   280 253                 533
3010941 3010941 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2017   k_12_total 279.0 10.0 95.0 7.0   111.0       1.0 4.0   259.0 248.0       17.8               507.0 279 10 95 7   111       1 4   259 248                 507
3010955 3010955 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2017   pk_12_total 279.0 10.0 95.0 7.0   111.0       1.0 4.0   259.0 248.0                       507.0 279 10 95 7   111       1 4   259 248                 507
254487 254487 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   k_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0       29.2               383.0 190 8 95 5   73         12   213 170                 383
254501 254501 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   pk_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0                       383.0 190 8 95 5   73         12   213 170                 383
457542 457542 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 205.0 122.0 95.0 51.0   14.0         60.0   293.0 254.0                       547.0 205 122 95 51   14         60   293 254                 547
495965 495965 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 195.0 144.0 94.0 52.0   17.0         58.0   289.0 271.0                       560.0 195 144 94 52   17         58   289 271                 560
449031 449031 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   k_12_total 1132.0 18.0 94.0 74.0   42.0       2.0 48.0   697.0 713.0       3.1               1410.0 1132 18 94 74   42       2 48   697 713                 1410
449051 449051 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   pk_12_total 1132.0 18.0 94.0 74.0   42.0       2.0 48.0   697.0 713.0                       1410.0 1132 18 94 74   42       2 48   697 713                 1410
457479 457479 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 538.0 17.0 94.0 2.0   1.0         25.0   328.0 349.0       0.0               677.0 538 17 94 2   1         25   328 349                 677
3351660 3351660 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   k_12_total 1258.0 33.0 93.0 351.0   27.0         74.0   937.0 899.0       0.9               1836.0 1258 33 93 351   27         74   937 899                 1836
3351710 3351710 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   pk_12_total 1258.0 33.0 93.0 351.0   27.0         74.0   937.0 899.0                       1836.0 1258 33 93 351   27         74   937 899                 1836
252348 252348 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   k_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0       0.7               1000.0 696 33 93 55   7       1 115   521 479                 1000
252358 252358 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   pk_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0                       1000.0 696 33 93 55   7       1 115   521 479                 1000
258330 258330 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   k_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0       2.5               1047.0 749 80 93 51   25       5 44   540 507                 1047
258416 258416 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   pk_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0                       1047.0 749 80 93 51   25       5 44   540 507                 1047
457444 457444 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_9 248.0 139.0 93.0 42.0   41.0       2.0 29.0   300.0 294.0                       594.0 248 139 93 42   41       2 29   300 294                 594
457485 457485 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 138.0 105.0 93.0 46.0   17.0         33.0   226.0 206.0       27.6               432.0 138 105 93 46   17         33   226 206                 432
258341 258341 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2018   k_12_total 110.0 56.0 92.0 14.0   12.0         30.0   157.0 157.0       28.3               314.0 110 56 92 14   12         30   157 157                 314
364649 364649 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2019   k_12_total 1411.0 13.0 92.0 74.0   20.0         72.0   834.0 848.0       1.0               1682.0 1411 13 92 74   20         72   834 848                 1682
364699 364699 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2019   pk_12_total 1411.0 13.0 92.0 74.0   20.0         72.0   834.0 848.0                       1682.0 1411 13 92 74   20         72   834 848                 1682
495955 495955 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 109.0 207.0 92.0 28.0   117.0         43.0   306.0 290.0                       596.0 109 207 92 28   117         43   306 290                 596
3352666 3352666 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No 1 PK 05 2016   k_12_total 142.0 92.0 91.0 56.0   19.0         39.0   255.0 184.0       22.9               439.0 142 92 91 56   19         39   255 184                 439
495756 495756 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 112.0 65.0 91.0 27.0   6.0       0.0 27.0   164.0 164.0                       328.0 112 65 91 27   6       0 27   164 164                 328
3014738 3014738 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2017   grade_9 480.0 42.0 90.0 44.0   23.0       0.0 13.0   368.0 324.0                       692.0 480 42 90 44   23       0 13   368 324                 692
2962829 2962829 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2015   grade_2 94.0 10.0 9.0 3.0   3.0       0.0 6.0   61.0 64.0                       125.0 94 10 9 3   3       0 6   61 64                 125
2962837 2962837 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_4 216.0 10.0 9.0 7.0   9.0       1.0 12.0   129.0 135.0                       264.0 216 10 9 7   9       1 12   129 135                 264
2962842 2962842 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_5 207.0 0.0 9.0 11.0   9.0       0.0 9.0   129.0 116.0                       245.0 207 0 9 11   9       0 9   129 116                 245
2962853 2962853 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No 2 06 08 2015   grade_7 212.0 5.0 9.0 10.0   8.0       0.0 6.0   120.0 130.0                       250.0 212 5 9 10   8       0 6   120 130                 250
2962861 2962861 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2015   grade_9 226.0 2.0 9.0 3.0   7.0       0.0 3.0   119.0 131.0                       250.0 226 2 9 3   7       0 3   119 131                 250
2963386 2963386 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No 1 PK 04 2015   pk_12_total 128.0 4.0 9.0             1.0     74.0 68.0                       142.0 128 4 9             1     74 68                 142
2963626 2963626 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No 1 KG 04 2015   grade_3 83.0 0.0 9.0 2.0   2.0       0.0 6.0   53.0 49.0                       102.0 83 0 9 2   2       0 6   53 49                 102
2963644 2963644 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No 2 07 08 2015   grade_7 89.0 1.0 9.0 1.0   1.0         4.0   56.0 49.0                       105.0 89 1 9 1   1         4   56 49                 105
2964009 2964009 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2015   grade_12 124.0 4.0 9.0 11.0   1.0       1.0 12.0   87.0 75.0                       162.0 124 4 9 11   1       1 12   87 75                 162
2964348 2964348 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No 2 06 08 2015   k_12_total 145.0 3.0 9.0               2.0   80.0 79.0                       159.0 145 3 9               2   80 79                 159
2964354 2964354 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No 2 06 08 2015   pk_12_total 145.0 3.0 9.0               2.0   80.0 79.0                       159.0 145 3 9               2   80 79                 159
2964994 2964994 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No 1 KG 06 2015   k_12_total 122.0 2.0 9.0 1.0             3.0   64.0 73.0                       137.0 122 2 9 1             3   64 73                 137
2965004 2965004 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No 1 KG 06 2015   pk_12_total 122.0 2.0 9.0 1.0             3.0   64.0 73.0                       137.0 122 2 9 1             3   64 73                 137
2965050 2965050 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No 1 PK 05 2015   k_12_total 189.0   9.0 0.0   2.0         13.0   103.0 110.0                       213.0 189   9 0   2         13   103 110                 213
2965419 2965419 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No 3 09 12 2015   k_12_total 156.0 1.0 9.0     1.0             73.0 94.0                       167.0 156 1 9     1             73 94                 167
2965425 2965425 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No 3 09 12 2015   pk_12_total 156.0 1.0 9.0     1.0             73.0 94.0                       167.0 156 1 9     1             73 94                 167
2965882 2965882 SD     school 4633360 51002   Hill City 51-2 463336000280 1 Hill City High School   Regular School No 3 09 12 2015   grade_10 31.0 0.0 9.0 1.0   1.0             20.0 22.0                       42.0 31 0 9 1   1             20 22                 42
2965917 2965917 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No 1 PK 05 2015   kindergarten 17.0 2.0 9.0 1.0             1.0   15.0 15.0                       30.0 17 2 9 1             1   15 15                 30
2967147 2967147 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No 3 09 12 2015   k_12_total 339.0 3.0 9.0 5.0   2.0             172.0 186.0                       358.0 339 3 9 5   2             172 186                 358
2967149 2967149 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No 1 KG 05 2015   kindergarten 92.0 0.0 9.0 1.0   0.0         2.0   44.0 60.0                       104.0 92 0 9 1   0         2   44 60                 104
2967153 2967153 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No 3 09 12 2015   pk_12_total 339.0 3.0 9.0 5.0   2.0             172.0 186.0                       358.0 339 3 9 5   2             172 186                 358
2967194 2967194 SD     school 4645450 60003   Marion 60-3 464545000407 2 Marion Elementary School   Regular School No 1 PK 05 2015   k_12_total 75.0   9.0 1.0             3.0   47.0 41.0                       88.0 75   9 1             3   47 41                 88
2967413 2967413 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No 1 PK 05 2015   grade_2 106.0 0.0 9.0 4.0   1.0         8.0   77.0 51.0                       128.0 106 0 9 4   1         8   77 51                 128
2967719 2967719 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No 1 KG 05 2015   grade_1 78.0 2.0 9.0 3.0   0.0       0.0 3.0   50.0 45.0                       95.0 78 2 9 3   0       0 3   50 45                 95
2968476 2968476 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No 3 09 12 2015   grade_9 177.0 0.0 9.0 35.0   2.0         7.0   114.0 116.0                       230.0 177 0 9 35   2         7   114 116                 230
2968769 2968769 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No 1 KG 05 2015   grade_2 23.0 1.0 9.0 23.0   1.0         4.0   36.0 25.0                       61.0 23 1 9 23   1         4   36 25                 61
2968773 2968773 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No 1 KG 05 2015   grade_2 84.0 1.0 9.0 7.0   2.0         2.0   49.0 56.0                       105.0 84 1 9 7   2         2   49 56                 105
2968786 2968786 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No 1 PK 05 2015   grade_2 44.0 0.0 9.0 14.0   0.0         7.0   29.0 45.0                       74.0 44 0 9 14   0         7   29 45                 74
2968800 2968800 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School No 1 KG 05 2015   grade_3 53.0 1.0 9.0 2.0   0.0         4.0   36.0 33.0                       69.0 53 1 9 2   0         4   36 33                 69
2968818 2968818 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No 1 KG 05 2015   grade_4 52.0 5.0 9.0 12.0   2.0         3.0   46.0 37.0                       83.0 52 5 9 12   2         3   46 37                 83
2968843 2968843 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No 1 KG 05 2015   grade_5 62.0 1.0 9.0 12.0   1.0         4.0   44.0 45.0                       89.0 62 1 9 12   1         4   44 45                 89
2969533 2969533 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2015   grade_1 67.0 7.0 9.0 7.0   6.0       1.0 9.0   55.0 51.0                       106.0 67 7 9 7   6       1 9   55 51                 106
2969547 2969547 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No 1 KG 05 2015   grade_1 34.0 7.0 9.0 0.0   3.0       0.0 4.0   33.0 24.0                       57.0 34 7 9 0   3       0 4   33 24                 57
2969548 2969548 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2015   grade_1 65.0 2.0 9.0 1.0   1.0       0.0 2.0   40.0 40.0                       80.0 65 2 9 1   1       0 2   40 40                 80
2969585 2969585 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No 3 09 12 2015   grade_10 67.0 2.0 9.0 7.0   1.0         0.0   58.0 28.0                       86.0 67 2 9 7   1         0   58 28                 86
2969721 2969721 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2015   grade_2 88.0 8.0 9.0 6.0   1.0       2.0 7.0   56.0 65.0                       121.0 88 8 9 6   1       2 7   56 65                 121
2969773 2969773 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2015   grade_3 54.0 2.0 9.0 0.0   1.0       0.0 1.0   35.0 32.0                       67.0 54 2 9 0   1       0 1   35 32                 67
2969786 2969786 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2015   grade_4 53.0 18.0 9.0 4.0   4.0       0.0 3.0   43.0 48.0                       91.0 53 18 9 4   4       0 3   43 48                 91
2969947 2969947 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2015   grade_7 307.0 22.0 9.0 13.0   8.0         7.0   194.0 172.0                       366.0 307 22 9 13   8         7   194 172                 366
2970191 2970191 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 26.0 25.0 9.0 1.0   18.0       0.0 5.0   42.0 42.0                       84.0 26 25 9 1   18       0 5   42 42                 84
2970218 2970218 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 27.0 7.0 9.0 2.0   0.0         3.0   24.0 24.0                       48.0 27 7 9 2   0         3   24 24                 48
2970281 2970281 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School No 1 KG 05 2015   grade_1 18.0   9.0 50.0             13.0   56.0 34.0                       90.0 18   9 50             13   56 34                 90
2970481 2970481 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_3 152.0 0.0 9.0 6.0   2.0       0.0 3.0   79.0 93.0                       172.0 152 0 9 6   2       0 3   79 93                 172
2970722 2970722 SD     school 4670140 54006   Summit 54-6 467014000662 2 Summit Elementary   Regular School No 1 PK 08 2015   pk_12_total 84.0 1.0 9.0 17.0             4.0   62.0 53.0                       115.0 84 1 9 17             4   62 53                 115
2971177 2971177 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No 2 06 08 2015   k_12_total 233.0 11.0 9.0 31.0   4.0         2.0   131.0 159.0                       290.0 233 11 9 31   4         2   131 159                 290
2971185 2971185 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No 2 06 08 2015   pk_12_total 233.0 11.0 9.0 31.0   4.0         2.0   131.0 159.0                       290.0 233 11 9 31   4         2   131 159                 290
2971304 2971304 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No 2 05 08 2015   k_12_total 61.0 2.0 9.0 135.0   1.0         14.0   104.0 118.0                       222.0 61 2 9 135   1         14   104 118                 222
2971312 2971312 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No 2 05 08 2015   pk_12_total 61.0 2.0 9.0 135.0   1.0         14.0   104.0 118.0                       222.0 61 2 9 135   1         14   104 118                 222
2971759 2971759 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No 1 PK 06 2015   pk_12_total 164.0   9.0                   91.0 82.0                       173.0 164   9                   91 82                 173
2972240 2972240 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   grade_10 201.0 6.0 9.0 6.0   0.0         2.0   115.0 109.0                       224.0 201 6 9 6   0         2   115 109                 224
3345185 3345185 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   grade_5 289.0 13.0 9.0     1.0       1.0 7.0   161.0 159.0                       320.0 289 13 9     1       1 7   161 159                 320
3345424 3345424 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   grade_12 187.0 5.0 9.0 5.0   6.0       1.0 3.0   109.0 107.0                       216.0 187 5 9 5   6       1 3   109 107                 216
3345449 3345449 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 2 04 05 2016   grade_5 217.0 9.0 9.0 4.0   12.0       1.0 16.0   130.0 138.0                       268.0 217 9 9 4   12       1 16   130 138                 268
3345974 3345974 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No 1 PK 04 2016   k_12_total 101.0 2.0 9.0             1.0     63.0 50.0       4.4               113.0 101 2 9             1     63 50                 113
3346226 3346226 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No 1 KG 04 2016   grade_3 97.0 0.0 9.0 0.0   1.0         6.0   56.0 57.0                       113.0 97 0 9 0   1         6   56 57                 113
3346248 3346248 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No 2 07 08 2016   grade_8 91.0 0.0 9.0 2.0   2.0         3.0   55.0 52.0                       107.0 91 0 9 2   2         3   55 52                 107
3346258 3346258 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No 1 KG 04 2016   kindergarten 86.0 0.0 9.0 0.0   6.0         2.0   50.0 53.0                       103.0 86 0 9 0   6         2   50 53                 103
3347408 3347408 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No 2 06 08 2016   k_12_total 73.0   9.0 57.0   4.0       1.0     75.0 69.0       1.9               144.0 73   9 57   4       1     75 69                 144
3347416 3347416 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No 2 06 08 2016   pk_12_total 73.0   9.0 57.0   4.0       1.0     75.0 69.0                       144.0 73   9 57   4       1     75 69                 144
3348462 3348462 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No 1 PK 05 2016   grade_1 14.0 1.0 9.0 5.0             2.0   17.0 14.0                       31.0 14 1 9 5             2   17 14                 31
3348469 3348469 SD     school 4633360 51002   Hill City 51-2 463336000280 1 Hill City High School   Regular School No 3 09 12 2016   grade_11 30.0   9.0 1.0   1.0             19.0 22.0                       41.0 30   9 1   1             19 22                 41
3351127 3351127 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No 3 09 12 2016   grade_10 165.0 0.0 9.0 28.0   2.0         4.0   107.0 101.0                       208.0 165 0 9 28   2         4   107 101                 208
3351367 3351367 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No 1 KG 05 2016   grade_1 31.0 0.0 9.0 36.0   1.0         6.0   38.0 45.0                       83.0 31 0 9 36   1         6   38 45                 83
3351374 3351374 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No 1 KG 05 2016   grade_1 37.0 0.0 9.0 27.0   2.0       1.0 5.0   46.0 35.0                       81.0 37 0 9 27   2       1 5   46 35                 81
3351375 3351375 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No 1 KG 05 2016   grade_1 29.0 1.0 9.0 4.0   1.0         3.0   19.0 28.0                       47.0 29 1 9 4   1         3   19 28                 47

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