Data source: Big Local News · About: Big Local

10,736 rows where state = "SD" and year = 2018 sorted by black descending

View and edit SQL

year

  • 2018 · 10,736
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
258361 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2018   k_12_total 121.0 99.0 107.0 42.0   13.0         40.0   229.0 193.0       26.1               422.0 121 99 107 42   13         40   229 193                 422
258430 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   pk_12_total 176.0 98.0 74.0 70.0   8.0         58.0   235.0 249.0                       484.0 176 98 74 70   8         58   235 249                 484
258349 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   k_12_total 847.0 97.0 78.0 28.0   27.0         41.0   555.0 563.0       3.1               1118.0 847 97 78 28   27         41   555 563                 1118
258435 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   pk_12_total 847.0 97.0 78.0 28.0   27.0         41.0   555.0 563.0                       1118.0 847 97 78 28   27         41   555 563                 1118
257889 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   grade_10 296.0 91.0 63.0 24.0   38.0       0.0 14.0   289.0 237.0                       526.0 296 91 63 24   38       0 14   289 237                 526
249826 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   grade_11 278.0 9.0 13.0 22.0   7.0       3.0 3.0   167.0 168.0                       335.0 278 9 13 22   7       3 3   167 168                 335
249932 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   k_12_total 255.0 9.0 14.0 21.0   15.0       1.0 23.0   179.0 159.0       4.1               338.0 255 9 14 21   15       1 23   179 159                 338
249952 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   pk_12_total 255.0 9.0 14.0 21.0   15.0       1.0 23.0   179.0 159.0                       338.0 255 9 14 21   15       1 23   179 159                 338
250805 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   grade_10 254.0 9.0 7.0 1.0   3.0       0.0 8.0   147.0 135.0                       282.0 254 9 7 1   3       0 8   147 135                 282
250875 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   grade_9 266.0 9.0 10.0 1.0   5.0       0.0 7.0   156.0 142.0                       298.0 266 9 10 1   5       0 7   156 142                 298
251110 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   grade_7 218.0 9.0 11.0 5.0   13.0       1.0 15.0   135.0 137.0                       272.0 218 9 11 5   13       1 15   135 137                 272
251136 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2018   kindergarten 82.0 9.0 10.0 2.0   4.0         8.0   58.0 57.0                       115.0 82 9 10 2   4         8   58 57                 115
252324 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   grade_5 176.0 9.0 23.0 14.0   3.0       1.0 19.0   108.0 137.0                       245.0 176 9 23 14   3       1 19   108 137                 245
252353 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   kindergarten 180.0 9.0 25.0 13.0   2.0       0.0 36.0   142.0 123.0                       265.0 180 9 25 13   2       0 36   142 123                 265
253933 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   k_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0       1.1               648.0 580 9 19 4   15         21   335 313                 648
253934 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2018   k_12_total 365.0 9.0 10.0     1.0         12.0   193.0 204.0       0.8               397.0 365 9 10     1         12   193 204                 397
253951 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   pk_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0                       648.0 580 9 19 4   15         21   335 313                 648
253952 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2018   pk_12_total 365.0 9.0 10.0     1.0         12.0   193.0 204.0                       397.0 365 9 10     1         12   193 204                 397
257917 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No High 09 12 2018   grade_11 71.0 9.0 6.0 5.0   3.0         3.0   45.0 52.0                       97.0 71 9 6 5   3         3   45 52                 97
258041 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2018   grade_3 63.0 9.0 11.0 1.0   1.0         9.0   47.0 47.0                       94.0 63 9 11 1   1         9   47 47                 94
258043 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   grade_3 32.0 9.0 12.0 12.0   0.0         13.0   38.0 40.0                       78.0 32 9 12 12   0         13   38 40                 78
258084 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2018   grade_4 65.0 9.0 13.0 10.0   2.0         6.0   51.0 54.0                       105.0 65 9 13 10   2         6   51 54                 105
258123 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   grade_5 43.0 9.0 34.0 9.0   4.0         8.0   61.0 46.0                       107.0 43 9 34 9   4         8   61 46                 107
258127 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2018   grade_5 40.0 9.0 11.0 6.0   0.0         3.0   33.0 36.0                       69.0 40 9 11 6   0         3   33 36                 69
258372 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   kindergarten 108.0 9.0 12.0 2.0   0.0       0.0 10.0   70.0 71.0                       141.0 108 9 12 2   0       0 10   70 71                 141
258958 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   k_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0       0.2               431.0 387 9 9 7             19   226 205                 431
258966 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   pk_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0                       431.0 387 9 9 7             19   226 205                 431
259234 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2018   grade_5 65.0 9.0 5.0               2.0   38.0 43.0                       81.0 65 9 5               2   38 43                 81
259251 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   k_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0       1.4               145.0 125 9 9 1             1   71 74                 145
259257 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   pk_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0                       145.0 125 9 9 1             1   71 74                 145
260522 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   k_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0       1.6               635.0 529 9 42 36   4         15   335 300                 635
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
258191 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   grade_6 117.0 82.0 59.0 17.0   25.0       0.0 15.0   159.0 156.0                       315.0 117 82 59 17   25       0 15   159 156                 315
258344 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   k_12_total 148.0 81.0 70.0 66.0   6.0         58.0   210.0 219.0       13.8               429.0 148 81 70 66   6         58   210 219                 429
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 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
249836 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   grade_12 293.0 8.0 9.0 25.0   13.0       2.0 4.0   186.0 168.0                       354.0 293 8 9 25   13       2 4   186 168                 354
249916 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   grade_9 297.0 8.0 19.0 29.0   12.0       0.0 2.0   181.0 186.0                       367.0 297 8 19 29   12       0 2   181 186                 367
250812 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   grade_11 235.0 8.0 4.0 1.0   3.0       0.0 4.0   134.0 121.0                       255.0 235 8 4 1   3       0 4   134 121                 255
250892 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   kindergarten 92.0 8.0 4.0 1.0   2.0         4.0   57.0 54.0                       111.0 92 8 4 1   2         4   57 54                 111
251090 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2018   grade_4 267.0 8.0 12.0 7.0   12.0       1.0 15.0   162.0 160.0                       322.0 267 8 12 7   12       1 15   162 160                 322
251104 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   grade_6 220.0 8.0 17.0 3.0   13.0       0.0 16.0   141.0 136.0                       277.0 220 8 17 3   13       0 16   141 136                 277
251119 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   grade_9 237.0 8.0 13.0 3.0   16.0       0.0 9.0   147.0 139.0                       286.0 237 8 13 3   16       0 9   147 139                 286
251934 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   k_12_total 333.0 8.0 23.0 4.0   6.0       2.0 12.0   214.0 174.0       0.3               388.0 333 8 23 4   6       2 12   214 174                 388
251942 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   pk_12_total 333.0 8.0 23.0 4.0   6.0       2.0 12.0   214.0 174.0                       388.0 333 8 23 4   6       2 12   214 174                 388
252326 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   grade_6 166.0 8.0 12.0 16.0   3.0       2.0 18.0   116.0 109.0                       225.0 166 8 12 16   3       2 18   116 109                 225
252340 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   grade_9 150.0 8.0 10.0 20.0   1.0       1.0 22.0   111.0 101.0                       212.0 150 8 10 20   1       1 22   111 101                 212
253935 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   k_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0       7.3               205.0 177 8 8     5         7   102 103                 205
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
254484 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2018   k_12_total 279.0 8.0 105.0 5.0   110.0       2.0 6.0   259.0 256.0       14.0               515.0 279 8 105 5   110       2 6   259 256                 515
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
254498 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2018   pk_12_total 279.0 8.0 105.0 5.0   110.0       2.0 6.0   259.0 256.0                       515.0 279 8 105 5   110       2 6   259 256                 515
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
255057 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2018   grade_10 11.0 8.0 3.0 6.0   1.0         4.0   25.0 8.0                       33.0 11 8 3 6   1         4   25 8                 33
256114 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   k_12_total 418.0 8.0 36.0 36.0   1.0         14.0   257.0 256.0       1.8               513.0 418 8 36 36   1         14   257 256                 513
256116 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   k_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0       0.9               777.0 662 8 35 38   8         26   389 388                 777
256128 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   pk_12_total 418.0 8.0 36.0 36.0   1.0         14.0   257.0 256.0                       513.0 418 8 36 36   1         14   257 256                 513
256130 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   pk_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0                       777.0 662 8 35 38   8         26   389 388                 777
257315 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2018   grade_8 46.0 8.0 13.0 93.0   1.0       0.0 14.0   93.0 82.0                       175.0 46 8 13 93   1       0 14   93 82                 175
257510 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 328.0 8.0 9.0 8.0   1.0             183.0 171.0                       354.0 328 8 9 8   1             183 171                 354
257815 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No Elementary KG 05 2018   grade_1   8.0 2.0     0.0             4.0 6.0                       10.0   8 2     0             4 6                 10
257825 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2018   grade_1 23.0 8.0 9.0 1.0   2.0         4.0   31.0 16.0                       47.0 23 8 9 1   2         4   31 16                 47
258040 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2018   grade_3 13.0 8.0 14.0 1.0   1.0         5.0   18.0 24.0                       42.0 13 8 14 1   1         5   18 24                 42
258071 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   grade_4 118.0 8.0 9.0 1.0   4.0       0.0 4.0   78.0 66.0                       144.0 118 8 9 1   4       0 4   78 66                 144
258080 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   grade_4 48.0 8.0 34.0 13.0   2.0         8.0   58.0 55.0                       113.0 48 8 34 13   2         8   58 55                 113
258090 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   grade_4 70.0 8.0 11.0 3.0   0.0       0.0 6.0   48.0 50.0                       98.0 70 8 11 3   0       0 6   48 50                 98
258121 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   grade_5 76.0 8.0 3.0 0.0   1.0         5.0   53.0 40.0                       93.0 76 8 3 0   1         5   53 40                 93
258173 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2018   grade_6   8.0 10.0     6.0             10.0 14.0                       24.0   8 10     6             10 14                 24
258304 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No High 09 12 2018   grade_9 63.0 8.0 11.0 1.0   0.0         8.0   45.0 46.0                       91.0 63 8 11 1   0         8   45 46                 91
258381 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   kindergarten 51.0 8.0 32.0 12.0   3.0         13.0   66.0 53.0                       119.0 51 8 32 12   3         13   66 53                 119
259391 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   k_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0       0.3               378.0 303 8 19 39   5       2 2   174 204                 378
259399 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   pk_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0                       378.0 303 8 19 39   5       2 2   174 204                 378
259746 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   k_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0       0.5               1211.0 1086 8 38 45   10       1 23   619 592                 1211
259762 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   pk_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0                       1211.0 1086 8 38 45   10       1 23   619 592                 1211
260517 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   k_12_total 334.0 8.0 23.0 13.0   2.0         12.0   207.0 185.0       2.3               392.0 334 8 23 13   2         12   207 185                 392
260529 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   pk_12_total 334.0 8.0 23.0 13.0   2.0         12.0   207.0 185.0                       392.0 334 8 23 13   2         12   207 185                 392
260532 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   pk_12_total 268.0 8.0 31.0 21.0   5.0         14.0   181.0 166.0                       347.0 268 8 31 21   5         14   181 166                 347
258337 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2018   k_12_total 99.0 74.0 61.0 56.0   10.0         54.0   177.0 177.0       21.2               354.0 99 74 61 56   10         54   177 177                 354
258331 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No Elementary KG 05 2018   k_12_total   73.0 26.0     11.0             51.0 59.0       100.0               110.0   73 26     11             51 59                 110
258417 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No Elementary KG 05 2018   pk_12_total   73.0 26.0     11.0             51.0 59.0                       110.0   73 26     11             51 59                 110
258346 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   k_12_total 1112.0 71.0 67.0 22.0   32.0         60.0   678.0 686.0       1.0               1364.0 1112 71 67 22   32         60   678 686                 1364
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
258432 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   pk_12_total 1112.0 71.0 67.0 22.0   32.0         60.0   678.0 686.0                       1364.0 1112 71 67 22   32         60   678 686                 1364
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
258234 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   grade_7 124.0 70.0 57.0 28.0   31.0       0.0 19.0   173.0 156.0                       329.0 124 70 57 28   31       0 19   173 156                 329
249929 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2018   k_12_total 280.0 7.0 35.0 20.0   13.0       1.0 33.0   199.0 190.0       4.9               389.0 280 7 35 20   13       1 33   199 190                 389
249934 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   k_12_total 415.0 7.0 30.0 26.0   16.0       3.0 14.0   256.0 255.0       2.5               511.0 415 7 30 26   16       3 14   256 255                 511
249949 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2018   pk_12_total 280.0 7.0 35.0 20.0   13.0       1.0 33.0   199.0 190.0                       389.0 280 7 35 20   13       1 33   199 190                 389
249954 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   pk_12_total 415.0 7.0 30.0 26.0   16.0       3.0 14.0   256.0 255.0                       511.0 415 7 30 26   16       3 14   256 255                 511
250801 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   grade_1 90.0 7.0 3.0 0.0   2.0         8.0   43.0 67.0                       110.0 90 7 3 0   2         8   43 67                 110
250855 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   grade_6 302.0 7.0 9.0 2.0   3.0       0.0 6.0   177.0 152.0                       329.0 302 7 9 2   3       0 6   177 152                 329
250870 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   grade_8 275.0 7.0 6.0 3.0   8.0       1.0 4.0   175.0 129.0                       304.0 275 7 6 3   8       1 4   175 129                 304
251096 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2018   grade_5 197.0 7.0 17.0 5.0   11.0       0.0 17.0   124.0 130.0                       254.0 197 7 17 5   11       0 17   124 130                 254
251129 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   k_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0       7.9               277.0 214 7 14 13   11         18   146 131                 277
251141 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   pk_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0                       277.0 214 7 14 13   11         18   146 131                 277
252295 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   grade_11 109.0 7.0 11.0 11.0   1.0       1.0 11.0   77.0 74.0                       151.0 109 7 11 11   1       1 11   77 74                 151
252308 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   grade_2 165.0 7.0 26.0 11.0   0.0       1.0 34.0   124.0 120.0                       244.0 165 7 26 11   0       1 34   124 120                 244
252313 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   grade_3 185.0 7.0 29.0 16.0   2.0       0.0 15.0   126.0 128.0                       254.0 185 7 29 16   2       0 15   126 128                 254
252319 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   grade_4 170.0 7.0 16.0 17.0   1.0       0.0 24.0   123.0 112.0                       235.0 170 7 16 17   1       0 24   123 112                 235
252331 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   grade_7 172.0 7.0 30.0 30.0   3.0       0.0 16.0   134.0 124.0                       258.0 172 7 30 30   3       0 16   134 124                 258

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