Data source: Big Local News · About: Big Local

10,704 rows where state = "SD" and year = 2017 sorted by black descending

View and edit SQL

year

  • 2017 · 10,704
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
3014761 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2017   k_12_total 233.0 99.0 66.0 39.0   16.0       4.0 48.0   263.0 242.0       15.3               505.0 233 99 66 39   16       4 48   263 242                 505
3014328 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2017   grade_10 285.0 91.0 50.0 23.0   37.0       0.0 24.0   272.0 238.0                       510.0 285 91 50 23   37       0 24   272 238                 510
3014748 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2017   grade_9 287.0 90.0 66.0 27.0   35.0       1.0 12.0   284.0 234.0                       518.0 287 90 66 27   35       1 12   284 234                 518
3014781 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2017   k_12_total 294.0 90.0 77.0 13.0   38.0         34.0   277.0 269.0       19.1               546.0 294 90 77 13   38         34   277 269                 546
3014789 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2017   k_12_total 139.0 90.0 106.0 48.0   16.0         38.0   244.0 193.0       22.9               437.0 139 90 106 48   16         38   244 193                 437
3014865 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2017   pk_12_total 294.0 90.0 77.0 13.0   38.0         34.0   277.0 269.0                       546.0 294 90 77 13   38         34   277 269                 546
3006251 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_11 286.0 9.0 9.0 16.0   10.0       2.0 4.0   173.0 163.0                       336.0 286 9 9 16   10       2 4   173 163                 336
3006357 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2017   k_12_total 284.0 9.0 22.0 29.0   20.0         26.0   201.0 189.0       5.4               390.0 284 9 22 29   20         26   201 189                 390
3006358 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2017   k_12_total 334.0 9.0 16.0 28.0   8.0       3.0 19.0   225.0 192.0       3.8               417.0 334 9 16 28   8       3 19   225 192                 417
3006377 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2017   pk_12_total 284.0 9.0 22.0 29.0   20.0         26.0   201.0 189.0                       390.0 284 9 22 29   20         26   201 189                 390
3006378 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2017   pk_12_total 334.0 9.0 16.0 28.0   8.0       3.0 19.0   225.0 192.0                       417.0 334 9 16 28   8       3 19   225 192                 417
3007228 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_12 248.0 9.0 5.0 0.0   3.0       0.0 3.0   133.0 135.0                       268.0 248 9 5 0   3       0 3   133 135                 268
3007245 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2017   grade_3 68.0 9.0 2.0 1.0   4.0         4.0   49.0 39.0                       88.0 68 9 2 1   4         4   49 39                 88
3007545 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2017   kindergarten 81.0 9.0 7.0 3.0   4.0         3.0   64.0 43.0                       107.0 81 9 7 3   4         3   64 43                 107
3008344 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2017   k_12_total 246.0 9.0 18.0 4.0   5.0         8.0   154.0 136.0       0.3               290.0 246 9 18 4   5         8   154 136                 290
3008352 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2017   pk_12_total 246.0 9.0 18.0 4.0   5.0         8.0   154.0 136.0                       290.0 246 9 18 4   5         8   154 136                 290
3008744 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2017   grade_6 162.0 9.0 22.0 25.0   2.0       0.0 17.0   126.0 111.0                       237.0 162 9 22 25   2       0 17   126 111                 237
3010394 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No Elementary PK 05 2017   k_12_total 450.0 9.0 6.0 2.0   2.0         12.0   252.0 229.0       0.8               481.0 450 9 6 2   2         12   252 229                 481
3011158 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2017   k_12_total 90.0 9.0 6.0 3.0             1.0   55.0 54.0       4.6               109.0 90 9 6 3             1   55 54                 109
3013798 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2017   k_12_total 476.0 9.0 34.0 77.0   7.0         41.0   330.0 314.0       1.1               644.0 476 9 34 77   7         41   330 314                 644
3013848 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2017   pk_12_total 476.0 9.0 34.0 77.0   7.0         41.0   330.0 314.0                       644.0 476 9 34 77   7         41   330 314                 644
3013943 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No Elementary PK 06 2017   k_12_total 311.0 9.0 13.0 5.0   1.0             178.0 161.0       0.0               339.0 311 9 13 5   1             178 161                 339
3014312 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No High 09 12 2017   grade_10 73.0 9.0 4.0 6.0   3.0         1.0   45.0 51.0                       96.0 73 9 4 6   3         1   45 51                 96
3014433 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2017   grade_2 70.0 9.0 13.0 2.0   1.0         6.0   54.0 47.0                       101.0 70 9 13 2   1         6   54 47                 101
3014464 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No Elementary KG 05 2017   grade_3 0.0 9.0 4.0     2.0             6.0 9.0                       15.0 0 9 4     2             6 9                 15
3014471 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   grade_3 57.0 9.0 28.0 13.0   2.0         8.0   59.0 58.0                       117.0 57 9 28 13   2         8   59 58                 117
3014504 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2017   grade_4 112.0 9.0 10.0 1.0   4.0         6.0   71.0 71.0                       142.0 112 9 10 1   4         6   71 71                 142
3014549 SD     school 4666270 49005   Sioux Falls 49-5 466627000585 16 Eugene Field A+ Elementary   Regular School No Elementary KG 05 2017   grade_5 57.0 9.0 3.0 0.0   0.0         8.0   38.0 39.0                       77.0 57 9 3 0   0         8   38 39                 77
3014561 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2017   grade_5 25.0 9.0 14.0 10.0   0.0         5.0   27.0 36.0                       63.0 25 9 14 10   0         5   27 36                 63
3014806 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2017   kindergarten 19.0 9.0 9.0 11.0   0.0         9.0   27.0 30.0                       57.0 19 9 9 11   0         9   27 30                 57
3014807 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   kindergarten 53.0 9.0 29.0 8.0   4.0         9.0   57.0 55.0                       112.0 53 9 29 8   4         9   57 55                 112
3014810 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2017   kindergarten 24.0 9.0 13.0 3.0   1.0         3.0   39.0 14.0                       53.0 24 9 13 3   1         3   39 14                 53
3015366 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2017   k_12_total 62.0 9.0 8.0 1.0   2.0         10.0   53.0 39.0       9.8               92.0 62 9 8 1   2         10   53 39                 92
3015374 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2017   pk_12_total 62.0 9.0 8.0 1.0   2.0         10.0   53.0 39.0                       92.0 62 9 8 1   2         10   53 39                 92
3016139 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   k_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0       0.7               1232.0 1114 9 45 37   9         18   644 588                 1232
3016155 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   pk_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0                       1232.0 1114 9 45 37   9         18   644 588                 1232
3016915 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2017   k_12_total 503.0 9.0 40.0 35.0   5.0         7.0   315.0 284.0       2.3               599.0 503 9 40 35   5         7   315 284                 599
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
3014771 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2017   k_12_total 162.0 84.0 68.0 61.0   6.0         55.0   218.0 218.0       13.1               436.0 162 84 68 61   6         55   218 218                 436
3014788 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2017   k_12_total 305.0 80.0 74.0 27.0   14.0       2.0 28.0   292.0 238.0       15.5               530.0 305 80 74 27   14       2 28   292 238                 530
3014872 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2017   pk_12_total 305.0 80.0 74.0 27.0   14.0       2.0 28.0   292.0 238.0                       530.0 305 80 74 27   14       2 28   292 238                 530
3006241 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_10 270.0 8.0 8.0 25.0   7.0       4.0 1.0   162.0 161.0                       323.0 270 8 8 25   7       4 1   162 161                 323
3007210 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2017   grade_1 63.0 8.0 3.0 0.0   3.0         2.0   36.0 43.0                       79.0 63 8 3 0   3         2   36 43                 79
3007214 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_10 235.0 8.0 7.0 0.0   3.0       0.0 3.0   129.0 127.0                       256.0 235 8 7 0   3       0 3   129 127                 256
3007284 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_9 252.0 8.0 5.0 1.0   3.0       0.0 9.0   148.0 130.0                       278.0 252 8 5 1   3       0 9   148 130                 278
3007290 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2017   k_12_total 474.0 8.0 5.0 7.0   4.0       3.0 19.0   273.0 247.0       0.2               520.0 474 8 5 7   4       3 19   273 247                 520
3007301 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2017   kindergarten 109.0 8.0 3.0 1.0   3.0         8.0   55.0 77.0                       132.0 109 8 3 1   3         8   55 77                 132
3007304 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2017   pk_12_total 497.0 8.0 6.0 7.0   6.0       3.0 21.0   292.0 256.0                       548.0 497 8 6 7   6       3 21   292 256                 548
3007499 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2017   grade_4 192.0 8.0 12.0 8.0   11.0         18.0   120.0 129.0                       249.0 192 8 12 8   11         18   120 129                 249
3008701 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2017   grade_10 128.0 8.0 4.0 17.0   1.0       1.0 10.0   91.0 78.0                       169.0 128 8 4 17   1       1 10   91 78                 169
3008741 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2017   grade_5 169.0 8.0 14.0 13.0   6.0       1.0 18.0   116.0 113.0                       229.0 169 8 14 13   6       1 18   116 113                 229
3010944 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2017   k_12_total 168.0 8.0 76.0 9.0   83.0         8.0   178.0 174.0       17.3               352.0 168 8 76 9   83         8   178 174                 352
3010958 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2017   pk_12_total 168.0 8.0 76.0 9.0   83.0         8.0   178.0 174.0                       352.0 168 8 76 9   83         8   178 174                 352
3011882 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2017   k_12_total 433.0 8.0 44.0 4.0   3.0         20.0   250.0 262.0       0.6               512.0 433 8 44 4   3         20   250 262                 512
3011888 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 433.0 8.0 44.0 4.0   3.0         20.0   250.0 262.0                       512.0 433 8 44 4   3         20   250 262                 512
3012539 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2017   k_12_total 451.0 8.0 39.0 31.0   5.0         18.0   295.0 257.0       2.4               552.0 451 8 39 31   5         18   295 257                 552
3012541 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   k_12_total 665.0 8.0 33.0 35.0   8.0         23.0   406.0 366.0       0.3               772.0 665 8 33 35   8         23   406 366                 772
3012553 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2017   pk_12_total 451.0 8.0 39.0 31.0   5.0         18.0   295.0 257.0                       552.0 451 8 39 31   5         18   295 257                 552
3012555 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   pk_12_total 665.0 8.0 33.0 35.0   8.0         23.0   406.0 366.0                       772.0 665 8 33 35   8         23   406 366                 772
3013571 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   grade_12 287.0 8.0 16.0 45.0   3.0         18.0   182.0 195.0                       377.0 287 8 16 45   3         18   182 195                 377
3013731 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2017   grade_7 53.0 8.0 13.0 106.0             14.0   102.0 92.0                       194.0 53 8 13 106             14   102 92                 194
3014261 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   grade_1 48.0 8.0 29.0 8.0   1.0         12.0   52.0 54.0                       106.0 48 8 29 8   1         12   52 54                 106
3014265 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2017   grade_1 47.0 8.0 6.0 4.0   0.0         12.0   37.0 40.0                       77.0 47 8 6 4   0         12   37 40                 77
3014441 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2017   grade_2 122.0 8.0 6.0 0.0   1.0       0.0 10.0   76.0 71.0                       147.0 122 8 6 0   1       0 10   76 71                 147
3014494 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2017   grade_3 50.0 8.0 11.0 5.0   2.0       0.0 1.0   47.0 30.0                       77.0 50 8 11 5   2       0 1   47 30                 77
3014516 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2017   grade_4 11.0 8.0 20.0 4.0   1.0         9.0   25.0 28.0                       53.0 11 8 20 4   1         9   25 28                 53
3014557 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2017   grade_5 87.0 8.0 3.0 1.0   1.0       0.0 1.0   56.0 45.0                       101.0 87 8 3 1   1       0 1   56 45                 101
3014805 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   kindergarten 63.0 8.0 2.0 3.0   3.0         9.0   43.0 45.0                       88.0 63 8 2 3   3         9   43 45                 88
3014811 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2017   kindergarten 53.0 8.0 11.0 7.0   0.0         12.0   51.0 40.0                       91.0 53 8 11 7   0         12   51 40                 91
3015645 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2017   kindergarten 56.0 8.0 2.0               1.0   37.0 30.0                       67.0 56 8 2               1   37 30                 67
3014764 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2017   k_12_total 109.0 77.0 73.0 51.0   7.0         37.0   186.0 168.0       18.4               354.0 109 77 73 51   7         37   186 168                 354
3014776 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2017   k_12_total 871.0 77.0 63.0 25.0   25.0         38.0   538.0 561.0       1.5               1099.0 871 77 63 25   25         38   538 561                 1099
3014860 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2017   pk_12_total 871.0 77.0 63.0 25.0   25.0         38.0   538.0 561.0                       1099.0 871 77 63 25   25         38   538 561                 1099
3014852 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2017   pk_12_total 137.0 73.0 111.0 25.0   10.0         26.0   189.0 193.0                       382.0 137 73 111 25   10         26   189 193                 382
3014847 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   pk_12_total 555.0 70.0 39.0 16.0   21.0         50.0   384.0 367.0                       751.0 555 70 39 16   21         50   384 367                 751
3006354 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2017   k_12_total 309.0 7.0 26.0 22.0   10.0       3.0 29.0   208.0 198.0       2.5               406.0 309 7 26 22   10       3 29   208 198                 406
3006374 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2017   pk_12_total 309.0 7.0 26.0 22.0   10.0       3.0 29.0   208.0 198.0                       406.0 309 7 26 22   10       3 29   208 198                 406
3007491 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2017   grade_2 56.0 7.0 5.0 2.0   6.0         1.0   34.0 43.0                       77.0 56 7 5 2   6         1   34 43                 77
3007505 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2017   grade_5 229.0 7.0 14.0 3.0   13.0         14.0   143.0 137.0                       280.0 229 7 14 3   13         14   143 137                 280
3008735 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2017   grade_4 181.0 7.0 23.0 12.0   4.0       1.0 12.0   113.0 127.0                       240.0 181 7 23 12   4       1 12   113 127                 240
3009979 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No High 09 12 2017   k_12_total 161.0 7.0 1.0 1.0   4.0             81.0 93.0       1.2               174.0 161 7 1 1   4             81 93                 174
3009985 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No High 09 12 2017   pk_12_total 161.0 7.0 1.0 1.0   4.0             81.0 93.0                       174.0 161 7 1 1   4             81 93                 174
3010391 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2017   k_12_total 330.0 7.0 5.0     1.0         12.0   176.0 179.0       0.6               355.0 330 7 5     1         12   176 179                 355
3010409 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2017   pk_12_total 330.0 7.0 5.0     1.0         12.0   176.0 179.0                       355.0 330 7 5     1         12   176 179                 355
3013801 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No Elementary KG 05 2017   k_12_total 99.0 7.0 27.0 137.0   5.0         31.0   152.0 154.0       1.0               306.0 99 7 27 137   5         31   152 154                 306
3013805 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2017   k_12_total 433.0 7.0 30.0 57.0   5.0       1.0 15.0   259.0 289.0       0.7               548.0 433 7 30 57   5       1 15   259 289                 548
3013808 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2017   k_12_total 176.0 7.0 26.0 143.0   3.0         20.0   209.0 166.0       1.3               375.0 176 7 26 143   3         20   209 166                 375
3013851 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No Elementary KG 05 2017   pk_12_total 99.0 7.0 27.0 137.0   5.0         31.0   152.0 154.0                       306.0 99 7 27 137   5         31   152 154                 306
3013855 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2017   pk_12_total 433.0 7.0 30.0 57.0   5.0       1.0 15.0   259.0 289.0                       548.0 433 7 30 57   5       1 15   259 289                 548
3013858 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2017   pk_12_total 176.0 7.0 26.0 143.0   3.0         20.0   209.0 166.0                       375.0 176 7 26 143   3         20   209 166                 375
3014259 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   grade_1 90.0 7.0 3.0 3.0   3.0         5.0   55.0 56.0                       111.0 90 7 3 3   3         5   55 56                 111
3014420 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2017   grade_2 126.0 7.0 13.0 0.0   3.0         10.0   74.0 85.0                       159.0 126 7 13 0   3         10   74 85                 159
3014423 SD     school 4666270 49005   Sioux Falls 49-5 466627000585 16 Eugene Field A+ Elementary   Regular School No Elementary KG 05 2017   grade_2 47.0 7.0 6.0 2.0   1.0         7.0   32.0 38.0                       70.0 47 7 6 2   1         7   32 38                 70
3014432 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2017   grade_2 19.0 7.0 17.0 1.0   1.0         5.0   21.0 29.0                       50.0 19 7 17 1   1         5   21 29                 50
3014439 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2017   grade_2 74.0 7.0 8.0 2.0   2.0       0.0 9.0   57.0 45.0                       102.0 74 7 8 2   2       0 9   57 45                 102
3014546 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2017   grade_5 122.0 7.0 8.0 0.0   1.0         8.0   68.0 78.0                       146.0 122 7 8 0   1         8   68 78                 146
3014555 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   grade_5 56.0 7.0 22.0 10.0   4.0         9.0   55.0 53.0                       108.0 56 7 22 10   4         9   55 53                 108
3015624 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2017   grade_4 67.0 7.0 5.0               2.0   37.0 44.0                       81.0 67 7 5               2   37 44                 81
3015784 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2017   k_12_total 305.0 7.0 18.0 44.0   8.0       1.0 6.0   189.0 200.0       0.5               389.0 305 7 18 44   8       1 6   189 200                 389
3015792 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2017   pk_12_total 305.0 7.0 18.0 44.0   8.0       1.0 6.0   189.0 200.0                       389.0 305 7 18 44   8       1 6   189 200                 389

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