Data source: Big Local News · About: Big Local

10,720 rows where state = "SD" and year = 2015 sorted by multiracial descending

View and edit SQL

year

  • 2015 · 10,720
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
2962261 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Jr High   Regular School No 2 07 08 2015   grade_8 5.0   1.0 16.0             9.0   13.0 18.0                       31.0 5   1 16             9   13 18                 31
2962842 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_5 207.0 0.0 9.0 11.0   9.0       0.0 9.0   129.0 116.0                       245.0 207 0 9 11   9       0 9   129 116                 245
2965099 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No 3 09 12 2015   k_12_total 83.0   1.0               9.0   43.0 50.0                       93.0 83   1               9   43 50                 93
2965105 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No 3 09 12 2015   pk_12_total 83.0   1.0               9.0   43.0 50.0                       93.0 83   1               9   43 50                 93
2965706 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   k_12_total 397.0 6.0 10.0 3.0   9.0         9.0   217.0 217.0                       434.0 397 6 10 3   9         9   217 217                 434
2965722 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   pk_12_total 397.0 6.0 10.0 3.0   9.0         9.0   217.0 217.0                       434.0 397 6 10 3   9         9   217 217                 434
2967806 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2015   k_12_total 493.0 8.0 22.0 30.0   6.0         9.0   309.0 259.0                       568.0 493 8 22 30   6         9   309 259                 568
2967820 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2015   pk_12_total 493.0 8.0 22.0 30.0   6.0         9.0   309.0 259.0                       568.0 493 8 22 30   6         9   309 259                 568
2968677 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No 1 KG 05 2015   grade_1 64.0 0.0 8.0 12.0   0.0       0.0 9.0   44.0 49.0                       93.0 64 0 8 12   0       0 9   44 49                 93
2968781 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2015   grade_2 28.0 0.0 11.0 19.0             9.0   31.0 36.0                       67.0 28 0 11 19             9   31 36                 67
2968806 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2015   grade_3 32.0 2.0 5.0 24.0             9.0   39.0 33.0                       72.0 32 2 5 24             9   39 33                 72
2968905 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No 2 06 08 2015   grade_7 143.0 4.0 10.0 33.0   0.0         9.0   100.0 99.0                       199.0 143 4 10 33   0         9   100 99                 199
2968916 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No 2 06 08 2015   grade_8 169.0 8.0 6.0 21.0   3.0         9.0   114.0 102.0                       216.0 169 8 6 21   3         9   114 102                 216
2968994 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No 1 KG 05 2015   kindergarten 21.0 1.0 6.0 23.0   2.0         9.0   27.0 35.0                       62.0 21 1 6 23   2         9   27 35                 62
2969533 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2015   grade_1 67.0 7.0 9.0 7.0   6.0       1.0 9.0   55.0 51.0                       106.0 67 7 9 7   6       1 9   55 51                 106
2969703 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   grade_2 36.0 8.0 8.0 5.0   1.0       2.0 9.0   30.0 39.0                       69.0 36 8 8 5   1       2 9   30 39                 69
2969723 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2015   grade_2 120.0 1.0 4.0 1.0   2.0         9.0   71.0 66.0                       137.0 120 1 4 1   2         9   71 66                 137
2969902 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2015   grade_6 303.0 24.0 14.0 10.0   8.0         9.0   174.0 194.0                       368.0 303 24 14 10   8         9   174 194                 368
2969969 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No 2 06 08 2015   grade_8 209.0 23.0 15.0 12.0   5.0         9.0   164.0 109.0                       273.0 209 23 15 12   5         9   164 109                 273
2970115 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2015   kindergarten 99.0 5.0 3.0 1.0   0.0         9.0   49.0 68.0                       117.0 99 5 3 1   0         9   49 68                 117
2970120 SD     school 4666270 49005   Sioux Falls 49-5 466627000601 27 Longfellow Elementary   Regular School No 1 KG 05 2015   kindergarten 11.0 20.0 21.0 3.0   9.0         9.0   40.0 33.0                       73.0 11 20 21 3   9         9   40 33                 73
2970198 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 27.0 16.0 4.0 4.0   2.0       0.0 9.0   38.0 24.0                       62.0 27 16 4 4   2       0 9   38 24                 62
2970202 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 70.0 5.0 31.0 9.0   1.0         9.0   74.0 51.0                       125.0 70 5 31 9   1         9   74 51                 125
2970539 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   k_12_total 502.0 7.0 30.0 14.0   9.0         9.0   298.0 273.0                       571.0 502 7 30 14   9         9   298 273                 571
2970541 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   k_12_total 351.0 2.0 17.0 11.0   1.0         9.0   195.0 196.0                       391.0 351 2 17 11   1         9   195 196                 391
2970555 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   pk_12_total 502.0 7.0 30.0 14.0   9.0         9.0   298.0 273.0                       571.0 502 7 30 14   9         9   298 273                 571
2970557 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   pk_12_total 351.0 2.0 17.0 11.0   1.0         9.0   195.0 196.0                       391.0 351 2 17 11   1         9   195 196                 391
2972186 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No 1 PK 05 2015   k_12_total 154.0 4.0 5.0 2.0             9.0   84.0 90.0                       174.0 154 4 5 2             9   84 90                 174
2961611 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2015   grade_1 60.0 2.0 3.0 2.0   2.0       0.0 8.0   38.0 39.0                       77.0 60 2 3 2   2       0 8   38 39                 77
2961872 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2015   pk_12_total 186.0 1.0 8.0 2.0           2.0 8.0   104.0 103.0                       207.0 186 1 8 2           2 8   104 103                 207
2962211 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No 3 09 12 2015   k_12_total 323.0   21.0 8.0   2.0         8.0   180.0 182.0                       362.0 323   21 8   2         8   180 182                 362
2962221 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No 3 09 12 2015   pk_12_total 323.0   21.0 8.0   2.0         8.0   180.0 182.0                       362.0 323   21 8   2         8   180 182                 362
2962250 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No 1 PK 06 2015   grade_4 4.0 0.0 3.0 16.0   0.0         8.0   15.0 16.0                       31.0 4 0 3 16   0         8   15 16                 31
2962256 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No 1 PK 06 2015   grade_6 9.0 0.0 1.0 14.0   0.0         8.0   20.0 12.0                       32.0 9 0 1 14   0         8   20 12                 32
2962642 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No 1 KG 05 2015   k_12_total 529.0 4.0 11.0 1.0   2.0       1.0 8.0   300.0 256.0                       556.0 529 4 11 1   2       1 8   300 256                 556
2962654 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No 1 KG 05 2015   pk_12_total 529.0 4.0 11.0 1.0   2.0       1.0 8.0   300.0 256.0                       556.0 529 4 11 1   2       1 8   300 256                 556
2963656 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No 2 07 08 2015   k_12_total 167.0 3.0 13.0 1.0   2.0         8.0   101.0 93.0                       194.0 167 3 13 1   2         8   101 93                 194
2963664 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No 2 07 08 2015   pk_12_total 167.0 3.0 13.0 1.0   2.0         8.0   101.0 93.0                       194.0 167 3 13 1   2         8   101 93                 194
2964346 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School No 1 PK 05 2015   k_12_total 297.0 1.0 21.0 2.0             8.0   168.0 161.0                       329.0 297 1 21 2             8   168 161                 329
2964352 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School No 1 PK 05 2015   pk_12_total 298.0 1.0 22.0 2.0             8.0   169.0 162.0                       331.0 298 1 22 2             8   169 162                 331
2965914 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No 1 PK 05 2015   k_12_total 177.0 5.0 38.0 15.0             8.0   119.0 124.0                       243.0 177 5 38 15             8   119 124                 243
2965920 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No 1 PK 05 2015   pk_12_total 180.0 5.0 42.0 15.0             8.0   125.0 125.0                       250.0 180 5 42 15             8   125 125                 250
2966490 SD     school 4619580 37003   Jones County 37-3 461958000358 2 Jones County Elem   Regular School No 1 KG 04 2015   k_12_total 63.0 1.0 1.0 4.0             8.0   41.0 36.0                       77.0 63 1 1 4             8   41 36                 77
2966492 SD     school 4619580 37003   Jones County 37-3 461958000955 4 Jones County MS   Regular School No 2 05 08 2015   k_12_total 37.0   1.0 6.0             8.0   36.0 16.0                       52.0 37   1 6             8   36 16                 52
2966496 SD     school 4619580 37003   Jones County 37-3 461958000358 2 Jones County Elem   Regular School No 1 KG 04 2015   pk_12_total 63.0 1.0 1.0 4.0             8.0   41.0 36.0                       77.0 63 1 1 4             8   41 36                 77
2966498 SD     school 4619580 37003   Jones County 37-3 461958000955 4 Jones County MS   Regular School No 2 05 08 2015   pk_12_total 37.0   1.0 6.0             8.0   36.0 16.0                       52.0 37   1 6             8   36 16                 52
2966795 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No 1 KG 05 2015   grade_3 54.0 0.0 3.0 2.0   0.0       0.0 8.0   38.0 29.0                       67.0 54 0 3 2   0       0 8   38 29                 67
2967413 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No 1 PK 05 2015   grade_2 106.0 0.0 9.0 4.0   1.0         8.0   77.0 51.0                       128.0 106 0 9 4   1         8   77 51                 128
2967642 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   k_12_total 339.0 4.0 25.0               8.0   213.0 163.0                       376.0 339 4 25               8   213 163                 376
2967648 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   pk_12_total 339.0 4.0 25.0               8.0   213.0 163.0                       376.0 339 4 25               8   213 163                 376
2967804 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School No 1 KG 05 2015   k_12_total 310.0 4.0 13.0 27.0   2.0         8.0   197.0 167.0                       364.0 310 4 13 27   2         8   197 167                 364
2967818 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School No 1 KG 05 2015   pk_12_total 310.0 4.0 13.0 27.0   2.0         8.0   197.0 167.0                       364.0 310 4 13 27   2         8   197 167                 364
2967879 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No 3 09 12 2015   k_12_total 146.0 1.0 8.0 59.0             8.0   117.0 105.0                       222.0 146 1 8 59             8   117 105                 222
2967887 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No 3 09 12 2015   pk_12_total 146.0 1.0 8.0 59.0             8.0   117.0 105.0                       222.0 146 1 8 59             8   117 105                 222
2968644 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No 1 PK 06 2015   k_12_total 217.0 2.0 2.0 11.0             8.0   122.0 118.0                       240.0 217 2 2 11             8   122 118                 240
2968654 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No 1 PK 06 2015   pk_12_total 218.0 2.0 2.0 11.0             8.0   123.0 118.0                       241.0 218 2 2 11             8   123 118                 241
2968684 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No 1 KG 05 2015   grade_1 72.0 1.0 5.0 20.0   2.0       0.0 8.0   59.0 49.0                       108.0 72 1 5 20   2       0 8   59 49                 108
2968714 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   grade_11 294.0 6.0 17.0 54.0   6.0         8.0   182.0 203.0                       385.0 294 6 17 54   6         8   182 203                 385
2968726 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative Education School No 3 07 12 2015   grade_11 58.0 1.0 4.0 39.0             8.0   55.0 55.0                       110.0 58 1 4 39             8   55 55                 110
2968733 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2015   grade_11 293.0 5.0 10.0 30.0   1.0         8.0   163.0 184.0                       347.0 293 5 10 30   1         8   163 184                 347
2968910 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No 2 06 08 2015   grade_7 181.0 2.0 12.0 19.0   1.0         8.0   116.0 107.0                       223.0 181 2 12 19   1         8   116 107                 223
2968996 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No 1 KG 05 2015   kindergarten 28.0 0.0 11.0 41.0   1.0         8.0   40.0 49.0                       89.0 28 0 11 41   1         8   40 49                 89
2969002 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No 1 KG 05 2015   kindergarten 67.0 1.0 2.0 10.0   0.0       1.0 8.0   40.0 49.0                       89.0 67 1 2 10   0       1 8   40 49                 89
2969006 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2015   kindergarten 31.0 0.0 2.0 8.0             8.0   31.0 18.0                       49.0 31 0 2 8             8   31 18                 49
2969009 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No 1 KG 05 2015   kindergarten 68.0 0.0 10.0 9.0   4.0       1.0 8.0   53.0 47.0                       100.0 68 0 10 9   4       1 8   53 47                 100
2969523 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   grade_1 32.0 7.0 11.0 3.0   0.0       0.0 8.0   39.0 22.0                       61.0 32 7 11 3   0       0 8   39 22                 61
2969624 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2015   grade_11 301.0 42.0 26.0 20.0   17.0       1.0 8.0   219.0 196.0                       415.0 301 42 26 20   17       1 8   219 196                 415
2969691 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2015   grade_2 43.0 27.0 6.0 1.0   11.0         8.0   54.0 42.0                       96.0 43 27 6 1   11         8   54 42                 96
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
2969795 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2015   grade_4 63.0 3.0 6.0 1.0   0.0         8.0   45.0 36.0                       81.0 63 3 6 1   0         8   45 36                 81
2969879 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No 2 06 08 2015   grade_6 233.0 16.0 16.0 21.0   8.0         8.0   158.0 144.0                       302.0 233 16 16 21   8         8   158 144                 302
2969914 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No 2 06 08 2015   grade_6 150.0 54.0 48.0 18.0   23.0         8.0   139.0 162.0                       301.0 150 54 48 18   23         8   139 162                 301
2969959 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No 2 06 08 2015   grade_7 158.0 52.0 46.0 22.0   19.0         8.0   159.0 146.0                       305.0 158 52 46 22   19         8   159 146                 305
2969974 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No 2 06 08 2015   grade_8 93.0 42.0 36.0 19.0   15.0       0.0 8.0   113.0 100.0                       213.0 93 42 36 19   15       0 8   113 100                 213
2970068 SD     school 4666270 49005   Sioux Falls 49-5 466627000592 21 Horace Mann Elementary   Regular School No 1 KG 05 2015   k_12_total 77.0 19.0 8.0 4.0   2.0         8.0   57.0 61.0       0.9               118.0 77 19 8 4   2         8   57 61                 118
2970106 SD     school 4666270 49005   Sioux Falls 49-5 466627000585 16 Eugene Field A+ Elementary   Regular School No 1 KG 05 2015   kindergarten 48.0 6.0 4.0 1.0   1.0         8.0   35.0 33.0                       68.0 48 6 4 1   1         8   35 33                 68
2970110 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2015   kindergarten 96.0 4.0 2.0 4.0   2.0         8.0   61.0 55.0                       116.0 96 4 2 4   2         8   61 55                 116
2970111 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2015   kindergarten 23.0 25.0 13.0 13.0   6.0       1.0 8.0   48.0 41.0                       89.0 23 25 13 13   6       1 8   48 41                 89
2970158 SD     school 4666270 49005   Sioux Falls 49-5 466627000592 21 Horace Mann Elementary   Regular School No 1 KG 05 2015   pk_12_total 77.0 19.0 8.0 4.0   2.0         8.0   57.0 61.0                       118.0 77 19 8 4   2         8   57 61                 118
2970615 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No 1 KG 05 2015   k_12_total 145.0 2.0 3.0 33.0             8.0   101.0 90.0                       191.0 145 2 3 33             8   101 90                 191
2970623 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No 1 KG 05 2015   pk_12_total 145.0 2.0 3.0 33.0             8.0   101.0 90.0                       191.0 145 2 3 33             8   101 90                 191
2971034 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No 1 PK 06 2015   k_12_total 424.0 24.0 16.0 1.0             8.0   249.0 224.0                       473.0 424 24 16 1             8   249 224                 473
2971040 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No 1 PK 06 2015   pk_12_total 424.0 24.0 16.0 1.0             8.0   249.0 224.0                       473.0 424 24 16 1             8   249 224                 473
2971254 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No 1 01 04 2015   grade_1 16.0   5.0 45.0             8.0   37.0 37.0                       74.0 16   5 45             8   37 37                 74
2971270 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No 1 01 04 2015   grade_2 17.0   3.0 39.0             8.0   32.0 35.0                       67.0 17   3 39             8   32 35                 67
2971509 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No 2 07 08 2015   grade_7 256.0 0.0 10.0 11.0   0.0         8.0   133.0 152.0                       285.0 256 0 10 11   0         8   133 152                 285
2971527 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No 1 KG 06 2015   k_12_total 520.0 1.0 11.0 3.0   6.0         8.0   284.0 265.0                       549.0 520 1 11 3   6         8   284 265                 549
2971528 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No 1 KG 06 2015   k_12_total 481.0 4.0 13.0 3.0   11.0         8.0   247.0 273.0                       520.0 481 4 13 3   11         8   247 273                 520
2971533 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No 2 07 08 2015   k_12_total 524.0 4.0 17.0 23.0   1.0         8.0   293.0 284.0                       577.0 524 4 17 23   1         8   293 284                 577
2971543 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No 1 KG 06 2015   pk_12_total 520.0 1.0 11.0 3.0   6.0         8.0   284.0 265.0                       549.0 520 1 11 3   6         8   284 265                 549
2971544 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No 1 KG 06 2015   pk_12_total 481.0 4.0 13.0 3.0   11.0         8.0   247.0 273.0                       520.0 481 4 13 3   11         8   247 273                 520
2971549 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No 2 07 08 2015   pk_12_total 524.0 4.0 17.0 23.0   1.0         8.0   293.0 284.0                       577.0 524 4 17 23   1         8   293 284                 577
2971816 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humbolt Elem   Regular School No 1 KG 05 2015   k_12_total 361.0 5.0 3.0 8.0   1.0         8.0   202.0 184.0                       386.0 361 5 3 8   1         8   202 184                 386
2971824 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humbolt Elem   Regular School No 1 KG 05 2015   pk_12_total 361.0 5.0 3.0 8.0   1.0         8.0   202.0 184.0                       386.0 361 5 3 8   1         8   202 184                 386
2961730 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2015   k_12_total 340.0 6.0 20.0 28.0   1.0         7.0   224.0 178.0                       402.0 340 6 20 28   1         7   224 178                 402
2961750 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2015   pk_12_total 376.0 6.0 20.0 28.0   1.0         7.0   244.0 194.0                       438.0 376 6 20 28   1         7   244 194                 438
2962239 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No 3 09 12 2015   grade_12 15.0   1.0 15.0   0.0         7.0   19.0 19.0                       38.0 15   1 15   0         7   19 19                 38
2962244 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No 1 PK 06 2015   grade_2 5.0 0.0 3.0 14.0   0.0         7.0   12.0 17.0                       29.0 5 0 3 14   0         7   12 17                 29
2962271 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No 1 PK 06 2015   kindergarten 8.0 1.0 1.0 25.0   0.0         7.0   17.0 25.0                       42.0 8 1 1 25   0         7   17 25                 42
2962786 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No 1 PK 06 2015   k_12_total 177.0 4.0 11.0 7.0   3.0         7.0   114.0 95.0                       209.0 177 4 11 7   3         7   114 95                 209

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