Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2970166 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No 1 PK 05 2015   pk_12_total 193.0 99.0 79.0 68.0   8.0       1.0 49.0   261.0 236.0                       497.0 193 99 79 68   8       1 49   261 236                 497
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
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
3352665 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No 1 KG 05 2016   k_12_total 293.0 98.0 74.0 34.0   25.0       3.0 29.0   315.0 241.0       15.5               556.0 293 98 74 34   25       3 29   315 241                 556
3352751 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No 1 KG 05 2016   pk_12_total 293.0 98.0 74.0 34.0   25.0       3.0 29.0   315.0 241.0                       556.0 293 98 74 34   25       3 29   315 241                 556
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
495489 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_11 241.0 96.0 49.0 11.0   35.0       0.0 14.0   207.0 239.0                       446.0 241 96 49 11   35       0 14   207 239                 446
495896 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 846.0 95.0 61.0 29.0   24.0       1.0 51.0   559.0 548.0       3.8               1107.0 846 95 61 29   24       1 51   559 548                 1107
495980 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 846.0 95.0 61.0 29.0   24.0       1.0 51.0   559.0 548.0                       1107.0 846 95 61 29   24       1 51   559 548                 1107
365611 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2019   k_12_total 849.0 93.0 80.0 30.0   22.0         54.0   565.0 563.0       2.5               1128.0 849 93 80 30   22         54   565 563                 1128
365695 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2019   pk_12_total 849.0 93.0 80.0 30.0   22.0         54.0   565.0 563.0                       1128.0 849 93 80 30   22         54   565 563                 1128
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
3352725 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   pk_12_total 250.0 92.0 47.0 56.0   5.0       3.0 54.0   275.0 232.0                       507.0 250 92 47 56   5       3 54   275 232                 507
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
457066 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_11 244.0 92.0 65.0 10.0   26.0       1.0 17.0   215.0 240.0                       455.0 244 92 65 10   26       1 17   215 240                 455
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
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
365691 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2019   pk_12_total 165.0 91.0 77.0 67.0   4.0       1.0 65.0   240.0 230.0                       470.0 165 91 77 67   4       1 65   240 230                 470
495877 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 766.0 91.0 135.0 45.0   19.0       4.0 65.0   583.0 542.0       3.1               1125.0 766 91 135 45   19       4 65   583 542                 1125
495961 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 766.0 91.0 135.0 45.0   19.0       4.0 65.0   583.0 542.0                       1125.0 766 91 135 45   19       4 65   583 542                 1125
2970048 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2015   grade_9 371.0 90.0 56.0 22.0   38.0         10.0   310.0 277.0                       587.0 371 90 56 22   38         10   310 277                 587
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
365499 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2019   grade_7 115.0 90.0 61.0 20.0   28.0       0.0 12.0   165.0 161.0                       326.0 115 90 61 20   28       0 12   165 161                 326
365593 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2019   k_12_total 752.0 90.0 121.0 42.0   17.0       5.0 51.0   558.0 520.0       2.5               1078.0 752 90 121 42   17       5 51   558 520                 1078
365677 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2019   pk_12_total 752.0 90.0 121.0 42.0   17.0       5.0 51.0   558.0 520.0                       1078.0 752 90 121 42   17       5 51   558 520                 1078
2961705 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2015   grade_7 105.0 9.0 5.0 16.0   4.0       1.0 0.0   70.0 70.0                       140.0 105 9 5 16   4       1 0   70 70                 140
2963990 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2015   grade_1 171.0 9.0 17.0 14.0   3.0         21.0   123.0 112.0                       235.0 171 9 17 14   3         21   123 112                 235
2964067 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   k_12_total 323.0 9.0 31.0 36.0   3.0       2.0 35.0   237.0 202.0                       439.0 323 9 31 36   3       2 35   237 202                 439
2964079 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   pk_12_total 323.0 9.0 31.0 36.0   3.0       2.0 35.0   237.0 202.0                       439.0 323 9 31 36   3       2 35   237 202                 439
2968939 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   grade_9 364.0 9.0 32.0 187.0   11.0         26.0   340.0 289.0                       629.0 364 9 32 187   11         26   340 289                 629
2968968 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No 1 KG 05 2015   k_12_total 356.0 9.0 35.0 82.0   4.0         24.0   273.0 237.0                       510.0 356 9 35 82   4         24   273 237                 510
2969018 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No 1 KG 05 2015   pk_12_total 356.0 9.0 35.0 82.0   4.0         24.0   273.0 237.0                       510.0 356 9 35 82   4         24   273 237                 510
2969698 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No 1 KG 05 2015   grade_2 98.0 9.0 2.0 2.0   2.0         4.0   57.0 60.0                       117.0 98 9 2 2   2         4   57 60                 117
2969712 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No 1 PK 05 2015   grade_2 15.0 9.0 22.0 2.0   1.0       0.0 8.0   25.0 32.0                       57.0 15 9 22 2   1       0 8   25 32                 57
2969727 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No 1 KG 05 2015   grade_2 42.0 9.0 8.0 1.0   2.0       0.0 1.0   33.0 30.0                       63.0 42 9 8 1   2       0 1   33 30                 63
2969847 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No 1 PK 05 2015   grade_5 14.0 9.0 10.0 3.0   4.0       0.0 2.0   22.0 20.0                       42.0 14 9 10 3   4       0 2   22 20                 42
2969862 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No 1 KG 05 2015   grade_5 40.0 9.0 7.0 3.0   4.0       0.0 1.0   25.0 39.0                       64.0 40 9 7 3   4       0 1   25 39                 64
2969942 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2015   grade_7 1.0 9.0 1.0     9.0             7.0 13.0                       20.0 1 9 1     9             7 13                 20
2969944 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No 2 06 08 2015   grade_7 375.0 9.0 15.0 6.0   7.0         7.0   207.0 212.0                       419.0 375 9 15 6   7         7   207 212                 419
2970108 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   kindergarten 46.0 9.0 6.0 3.0   0.0       0.0 7.0   39.0 32.0                       71.0 46 9 6 3   0       0 7   39 32                 71
2970112 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2015   kindergarten 64.0 9.0 28.0 8.0   3.0         11.0   64.0 59.0                       123.0 64 9 28 8   3         11   64 59                 123
3344193 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_11 260.0 9.0 5.0 31.0   11.0       0.0 5.0   179.0 142.0                       321.0 260 9 5 31   11       0 5   179 142                 321
3344272 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2016   grade_8 96.0 9.0 7.0 15.0   5.0       1.0 1.0   66.0 68.0                       134.0 96 9 7 15   5       1 1   66 68                 134
3345200 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No 2 07 08 2016   grade_7 265.0 9.0 11.0 2.0   4.0         6.0   156.0 141.0                       297.0 265 9 11 2   4         6   156 141                 297
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
3352120 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No 1 KG 05 2016   grade_1 1.0 9.0 5.0     0.0             7.0 8.0                       15.0 1 9 5     0             7 8                 15
3352127 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2016   grade_1 56.0 9.0 28.0 10.0   4.0       0.0 14.0   66.0 55.0                       121.0 56 9 28 10   4       0 14   66 55                 121
3352132 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2016   grade_1 65.0 9.0 10.0 3.0   2.0       0.0 4.0   48.0 45.0                       93.0 65 9 10 3   2       0 4   48 45                 93
3352304 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2016   grade_2 64.0 9.0 11.0 11.0   3.0       0.0 9.0   49.0 58.0                       107.0 64 9 11 11   3       0 9   49 58                 107
3352310 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   grade_2 81.0 9.0 5.0 4.0   0.0       0.0 4.0   45.0 58.0                       103.0 81 9 5 4   0       0 4   45 58                 103
3352335 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No 1 KG 05 2016   grade_3 0.0 9.0 9.0     5.0             11.0 12.0                       23.0 0 9 9     5             11 12                 23
3352338 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   grade_3 41.0 9.0 10.0 7.0   0.0       0.0 6.0   37.0 36.0                       73.0 41 9 10 7   0       0 6   37 36                 73
3352340 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   grade_3 77.0 9.0 3.0 0.0   1.0         6.0   55.0 41.0                       96.0 77 9 3 0   1         6   55 41                 96
3352388 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No 1 PK 05 2016   grade_4 86.0 9.0 2.0 1.0   1.0       0.0 2.0   55.0 46.0                       101.0 86 9 2 1   1       0 2   55 46                 101
3352610 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No 3 09 12 2016   grade_9 75.0 9.0 4.0 6.0   3.0         1.0   48.0 50.0                       98.0 75 9 4 6   3         1   48 50                 98
3352679 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No 1 KG 05 2016   kindergarten 2.0 9.0 8.0     4.0             15.0 8.0                       23.0 2 9 8     4             15 8                 23
3352686 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2016   kindergarten 54.0 9.0 30.0 8.0   2.0       0.0 12.0   63.0 52.0                       115.0 54 9 30 8   2       0 12   63 52                 115
3352703 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No 1 KG 05 2016   kindergarten 44.0 9.0 15.0 1.0   2.0         7.0   38.0 40.0                       78.0 44 9 15 1   2         7   38 40                 78
3353695 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2016   k_12_total 271.0 9.0 14.0 35.0   3.0         28.0   182.0 178.0       0.9               360.0 271 9 14 35   3         28   182 178                 360
3353703 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2016   pk_12_total 271.0 9.0 14.0 35.0   3.0         28.0   182.0 178.0                       360.0 271 9 14 35   3         28   182 178                 360
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
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

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