Data source: Big Local News · About: Big Local

10,736 rows where state = "SD" and year = 2018 sorted by pacific_islander 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
249926 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   k_12_total 1087.0 39.0 58.0 98.0   44.0       5.0 13.0   674.0 670.0       3.4               1344.0 1087 39 58 98   44       5 13   674 670                 1344
249946 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   pk_12_total 1087.0 39.0 58.0 98.0   44.0       5.0 13.0   674.0 670.0                       1344.0 1087 39 58 98   44       5 13   674 670                 1344
252346 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   k_12_total 495.0 20.0 62.0 67.0   10.0       5.0 50.0   371.0 338.0       0.1               709.0 495 20 62 67   10       5 50   371 338                 709
252356 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   pk_12_total 495.0 20.0 62.0 67.0   10.0       5.0 50.0   371.0 338.0                       709.0 495 20 62 67   10       5 50   371 338                 709
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
253101 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   k_12_total 136.0 1.0 44.0 100.0   6.0       4.0 24.0   164.0 151.0       10.2               315.0 136 1 44 100   6       4 24   164 151                 315
253109 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   pk_12_total 136.0 1.0 44.0 100.0   6.0       4.0 24.0   164.0 151.0                       315.0 136 1 44 100   6       4 24   164 151                 315
256013 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2018   k_12_total 269.0 1.0 5.0 2.0           4.0 1.0   147.0 135.0       0.4               282.0 269 1 5 2           4 1   147 135                 282
256021 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 269.0 1.0 5.0 2.0           4.0 1.0   147.0 135.0                       282.0 269 1 5 2           4 1   147 135                 282
256103 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   grade_8 190.0 1.0 4.0 11.0   5.0       4.0 1.0   113.0 103.0                       216.0 190 1 4 11   5       4 1   113 103                 216
256117 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   k_12_total 549.0 5.0 22.0 34.0   9.0       4.0 15.0   343.0 295.0       1.1               638.0 549 5 22 34   9       4 15   343 295                 638
256131 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   pk_12_total 549.0 5.0 22.0 34.0   9.0       4.0 15.0   343.0 295.0                       638.0 549 5 22 34   9       4 15   343 295                 638
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
249928 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2018   k_12_total 239.0 4.0 33.0 31.0   27.0       3.0 11.0   185.0 163.0       8.1               348.0 239 4 33 31   27       3 11   185 163                 348
249933 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   k_12_total 312.0 12.0 23.0 24.0   11.0       3.0 18.0   197.0 206.0       6.5               403.0 312 12 23 24   11       3 18   197 206                 403
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
249938 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2018   kindergarten 27.0 1.0 6.0 5.0   11.0       3.0 3.0   32.0 24.0                       56.0 27 1 6 5   11       3 3   32 24                 56
249948 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2018   pk_12_total 254.0 4.0 33.0 31.0   27.0       3.0 11.0   193.0 170.0                       363.0 254 4 33 31   27       3 11   193 170                 363
249953 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   pk_12_total 312.0 12.0 23.0 24.0   11.0       3.0 18.0   197.0 206.0                       403.0 312 12 23 24   11       3 18   197 206                 403
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
250895 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   pk_12_total 523.0 11.0 8.0 6.0   2.0       3.0 21.0   317.0 257.0                       574.0 523 11 8 6   2       3 21   317 257                 574
252336 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   grade_8 157.0 5.0 20.0 21.0   4.0       3.0 16.0   121.0 105.0                       226.0 157 5 20 21   4       3 16   121 105                 226
252345 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   k_12_total 533.0 21.0 50.0 62.0   8.0       3.0 57.0   397.0 337.0       0.3               734.0 533 21 50 62   8       3 57   397 337                 734
252355 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   pk_12_total 533.0 21.0 50.0 62.0   8.0       3.0 57.0   397.0 337.0                       734.0 533 21 50 62   8       3 57   397 337                 734
253103 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   k_12_total 77.0 2.0 8.0 49.0   2.0       3.0 3.0   76.0 68.0       0.0               144.0 77 2 8 49   2       3 3   76 68                 144
253111 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 77.0 2.0 8.0 49.0   2.0       3.0 3.0   76.0 68.0                       144.0 77 2 8 49   2       3 3   76 68                 144
254483 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2018   k_12_total 375.0 14.0 145.0 6.0   176.0       3.0 2.0   395.0 326.0       26.9               721.0 375 14 145 6   176       3 2   395 326                 721
254497 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2018   pk_12_total 375.0 14.0 145.0 6.0   176.0       3.0 2.0   395.0 326.0                       721.0 375 14 145 6   176       3 2   395 326                 721
258158 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   grade_6 247.0 34.0 38.0 16.0   3.0       3.0 14.0   187.0 168.0                       355.0 247 34 38 16   3       3 14   187 168                 355
258350 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2018   k_12_total 707.0 22.0 43.0 7.0   16.0       3.0 48.0   418.0 428.0       0.8               846.0 707 22 43 7   16       3 48   418 428                 846
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
258436 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2018   pk_12_total 775.0 42.0 57.0 17.0   17.0       3.0 59.0   492.0 478.0                       970.0 775 42 57 17   17       3 59   492 478                 970
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
259390 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   k_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0       1.2               348.0 257 5 12 39   7       3 25   182 166                 348
259398 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   pk_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0                       348.0 257 5 12 39   7       3 25   182 166                 348
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
249914 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   grade_8 137.0 4.0 11.0 9.0   2.0       2.0 2.0   83.0 84.0                       167.0 137 4 11 9   2       2 2   83 84                 167
250819 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   grade_12 227.0 5.0 4.0 0.0   4.0       2.0 1.0   111.0 132.0                       243.0 227 5 4 0   4       2 1   111 132                 243
250881 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   k_12_total 492.0 10.0 7.0 5.0   2.0       2.0 19.0   292.0 245.0       0.0               537.0 492 10 7 5   2       2 19   292 245                 537
250882 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   k_12_total 982.0 31.0 25.0 3.0   15.0       2.0 20.0   548.0 530.0       1.4               1078.0 982 31 25 3   15       2 20   548 530                 1078
250884 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   k_12_total 572.0 20.0 14.0 4.0   9.0       2.0 11.0   334.0 298.0       0.3               632.0 572 20 14 4   9       2 11   334 298                 632
250896 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   pk_12_total 982.0 31.0 25.0 3.0   15.0       2.0 20.0   548.0 530.0                       1078.0 982 31 25 3   15       2 20   548 530                 1078
250898 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   pk_12_total 572.0 20.0 14.0 4.0   9.0       2.0 11.0   334.0 298.0                       632.0 572 20 14 4   9       2 11   334 298                 632
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
252642 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2018   k_12_total 190.0 3.0 7.0     1.0       2.0 2.0   104.0 101.0       0.0               205.0 190 3 7     1       2 2   104 101                 205
252648 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2018   pk_12_total 190.0 3.0 7.0     1.0       2.0 2.0   104.0 101.0                       205.0 190 3 7     1       2 2   104 101                 205
253091 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   grade_7 30.0 1.0 3.0 19.0   0.0       2.0 0.0   30.0 25.0                       55.0 30 1 3 19   0       2 0   30 25                 55
254279 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2018   pk_12_total 264.0 1.0 14.0 33.0   5.0       2.0 56.0   198.0 177.0                       375.0 264 1 14 33   5       2 56   198 177                 375
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
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
256353 SD     school 4650670 51003   New Underwood 51-3 465067000463 2 New Underwood Elem   Regular School No Elementary KG 06 2018   k_12_total 84.0   5.0 2.0           2.0 16.0   56.0 53.0       1.8               109.0 84   5 2           2 16   56 53                 109
256359 SD     school 4650670 51003   New Underwood 51-3 465067000463 2 New Underwood Elem   Regular School No Elementary KG 06 2018   pk_12_total 84.0   5.0 2.0           2.0 16.0   56.0 53.0                       109.0 84   5 2           2 16   56 53                 109
257358 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2018   k_12_total 88.0 1.0 45.0 285.0   3.0       2.0 37.0   254.0 207.0       0.9               461.0 88 1 45 285   3       2 37   254 207                 461
257368 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   k_12_total 415.0 3.0 25.0 53.0   1.0       2.0 48.0   259.0 288.0       0.0               547.0 415 3 25 53   1       2 48   259 288                 547
257374 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   k_12_total 1382.0 7.0 75.0 84.0   23.0       2.0 53.0   793.0 833.0       0.8               1626.0 1382 7 75 84   23       2 53   793 833                 1626
257375 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2018   k_12_total 414.0 11.0 42.0 100.0   10.0       2.0 40.0   326.0 293.0       1.1               619.0 414 11 42 100   10       2 40   326 293                 619
257393 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   kindergarten 71.0 0.0 5.0 10.0   0.0       2.0 7.0   47.0 48.0                       95.0 71 0 5 10   0       2 7   47 48                 95
257408 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2018   pk_12_total 113.0 3.0 54.0 300.0   6.0       2.0 42.0   289.0 231.0                       520.0 113 3 54 300   6       2 42   289 231                 520
257418 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   pk_12_total 427.0 3.0 25.0 55.0   1.0       2.0 49.0   265.0 297.0                       562.0 427 3 25 55   1       2 49   265 297                 562
257424 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   pk_12_total 1382.0 7.0 75.0 84.0   23.0       2.0 53.0   793.0 833.0                       1626.0 1382 7 75 84   23       2 53   793 833                 1626
257425 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2018   pk_12_total 414.0 11.0 42.0 100.0   10.0       2.0 40.0   326.0 293.0                       619.0 414 11 42 100   10       2 40   326 293                 619
258112 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   grade_5 23.0 19.0 9.0 1.0   8.0       2.0 3.0   33.0 32.0                       65.0 23 19 9 1   8       2 3   33 32                 65
258163 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2018   grade_6 139.0 45.0 46.0 28.0   4.0       2.0 21.0   150.0 135.0                       285.0 139 45 46 28   4       2 21   150 135                 285
258201 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   grade_7 244.0 25.0 38.0 16.0   9.0       2.0 15.0   178.0 171.0                       349.0 244 25 38 16   9       2 15   178 171                 349
258327 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   k_12_total 141.0 161.0 65.0 13.0   44.0       2.0 34.0   218.0 242.0       37.8               460.0 141 161 65 13   44       2 34   218 242                 460
258335 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2018   k_12_total 339.0 137.0 158.0 100.0   18.0       2.0 56.0   435.0 375.0       7.4               810.0 339 137 158 100   18       2 56   435 375                 810
258413 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   pk_12_total 162.0 194.0 70.0 18.0   60.0       2.0 40.0   267.0 279.0                       546.0 162 194 70 18   60       2 40   267 279                 546
258421 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2018   pk_12_total 339.0 137.0 158.0 100.0   18.0       2.0 56.0   435.0 375.0                       810.0 339 137 158 100   18       2 56   435 375                 810
259370 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   grade_5 62.0 1.0 2.0 12.0   0.0       2.0 4.0   49.0 34.0                       83.0 62 1 2 12   0       2 4   49 34                 83
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
249813 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   grade_1 45.0 3.0 2.0 4.0   3.0       1.0 3.0   27.0 34.0                       61.0 45 3 2 4   3       1 3   27 34                 61
249853 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   grade_2 51.0 2.0 6.0 1.0   3.0       1.0 2.0   31.0 35.0                       66.0 51 2 6 1   3       1 2   31 35                 66
249859 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2018   grade_3 45.0 1.0 5.0 4.0   0.0       1.0 4.0   35.0 25.0                       60.0 45 1 5 4   0       1 4   35 25                 60
249875 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   grade_5 66.0 2.0 2.0 3.0   1.0       1.0 3.0   35.0 43.0                       78.0 66 2 2 3   1       1 3   35 43                 78
249883 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   grade_5 64.0 1.0 4.0 3.0   2.0       1.0 3.0   37.0 41.0                       78.0 64 1 4 3   2       1 3   37 41                 78
249904 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   grade_7 137.0 3.0 9.0 6.0   8.0       1.0 3.0   77.0 90.0                       167.0 137 3 9 6   8       1 3   77 90                 167
249925 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   k_12_total 343.0 11.0 9.0 12.0   7.0       1.0 20.0   212.0 191.0       2.5               403.0 343 11 9 12   7       1 20   212 191                 403
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
249930 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   k_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0       6.8               235.0 173 5 11 23   12       1 10   120 115                 235
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
249940 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   kindergarten 22.0 1.0 4.0 4.0   4.0       1.0 3.0   19.0 20.0                       39.0 22 1 4 4   4       1 3   19 20                 39
249942 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   kindergarten 38.0 1.0 2.0 5.0   2.0       1.0 4.0   26.0 27.0                       53.0 38 1 2 5   2       1 4   26 27                 53
249945 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   pk_12_total 343.0 11.0 9.0 12.0   7.0       1.0 20.0   212.0 191.0                       403.0 343 11 9 12   7       1 20   212 191                 403
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
249950 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   pk_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0                       235.0 173 5 11 23   12       1 10   120 115                 235
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
249994 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2018   grade_5 17.0   0.0 0.0           1.0 1.0   10.0 9.0                       19.0 17   0 0           1 1   10 9                 19
250014 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2018   k_12_total 88.0   4.0 3.0           1.0 4.0   52.0 48.0       4.0               100.0 88   4 3           1 4   52 48                 100
250022 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2018   pk_12_total 88.0   4.0 3.0           1.0 4.0   52.0 48.0                       100.0 88   4 3           1 4   52 48                 100
250065 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   k_12_total 158.0   10.0     1.0       1.0 5.0   89.0 86.0       1.1               175.0 158   10     1       1 5   89 86                 175
250068 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   kindergarten 19.0   2.0     0.0       1.0 0.0   9.0 13.0                       22.0 19   2     0       1 0   9 13                 22
250071 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   pk_12_total 209.0   13.0     1.0       1.0 6.0   124.0 106.0                       230.0 209   13     1       1 6   124 106                 230
250797 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   grade_1 82.0 2.0 1.0 0.0   0.0       1.0 5.0   49.0 42.0                       91.0 82 2 1 0   0       1 5   49 42                 91
250839 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   grade_4 86.0 3.0 0.0 0.0   1.0       1.0 2.0   46.0 47.0                       93.0 86 3 0 0   1       1 2   46 47                 93
250848 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   grade_5 292.0 15.0 10.0 6.0   7.0       1.0 4.0   174.0 161.0                       335.0 292 15 10 6   7       1 4   174 161                 335
250863 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   grade_7 297.0 13.0 8.0 1.0   1.0       1.0 7.0   159.0 169.0                       328.0 297 13 8 1   1       1 7   159 169                 328

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