Data source: Big Local News · About: Big Local

10,656 rows where state = "SD" and year = 2016 sorted by pacific_islander descending

View and edit SQL

year

  • 2016 · 10,656
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
3344283 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   k_12_total 1091.0 31.0 27.0 98.0   36.0       6.0 16.0   685.0 620.0                       1305.0 1091 31 27 98   36       6 16   685 620                 1305
3344301 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   pk_12_total 1091.0 31.0 27.0 98.0   36.0       6.0 16.0   685.0 620.0                       1305.0 1091 31 27 98   36       6 16   685 620                 1305
3345219 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   k_12_total 948.0 28.0 17.0 2.0   17.0       6.0 6.0   505.0 519.0       0.7               1024.0 948 28 17 2   17       6 6   505 519                 1024
3345233 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   pk_12_total 948.0 28.0 17.0 2.0   17.0       6.0 6.0   505.0 519.0                       1024.0 948 28 17 2   17       6 6   505 519                 1024
3344274 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_9 291.0 7.0 4.0 27.0   6.0       4.0 2.0   176.0 165.0                       341.0 291 7 4 27   6       4 2   176 165                 341
3344286 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   k_12_total 313.0 7.0 19.0 23.0   11.0       4.0 37.0   204.0 210.0                       414.0 313 7 19 23   11       4 37   204 210                 414
3344304 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   pk_12_total 313.0 7.0 19.0 23.0   11.0       4.0 37.0   204.0 210.0                       414.0 313 7 19 23   11       4 37   204 210                 414
3346680 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   k_12_total 445.0 10.0 48.0 48.0   8.0       4.0 58.0   313.0 308.0       0.0               621.0 445 10 48 48   8       4 58   313 308                 621
3346692 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   pk_12_total 445.0 10.0 48.0 48.0   8.0       4.0 58.0   313.0 308.0                       621.0 445 10 48 48   8       4 58   313 308                 621
3350302 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No 1 PK 06 2016   k_12_total 259.0 1.0 1.0 2.0   1.0       4.0     143.0 125.0       0.4               268.0 259 1 1 2   1       4     143 125                 268
3350310 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No 1 PK 06 2016   pk_12_total 259.0 1.0 1.0 2.0   1.0       4.0     143.0 125.0                       268.0 259 1 1 2   1       4     143 125                 268
3344290 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2016   k_12_total 384.0 15.0 18.0 41.0   12.0       3.0 6.0   228.0 251.0                       479.0 384 15 18 41   12       3 6   228 251                 479
3344308 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2016   pk_12_total 384.0 15.0 18.0 41.0   12.0       3.0 6.0   228.0 251.0                       479.0 384 15 18 41   12       3 6   228 251                 479
3345142 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   grade_10 246.0 6.0 5.0 0.0   6.0       3.0 2.0   133.0 135.0                       268.0 246 6 5 0   6       3 2   133 135                 268
3345478 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   k_12_total 780.0 18.0 39.0 16.0   32.0       3.0 12.0   448.0 452.0                       900.0 780 18 39 16   32       3 12   448 452                 900
3345490 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   pk_12_total 780.0 18.0 39.0 16.0   32.0       3.0 12.0   448.0 452.0                       900.0 780 18 39 16   32       3 12   448 452                 900
3347406 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No 1 KG 05 2016   k_12_total 167.0   24.0 113.0   4.0       3.0 10.0   172.0 149.0       6.5               321.0 167   24 113   4       3 10   172 149                 321
3347414 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No 1 KG 05 2016   pk_12_total 167.0   24.0 113.0   4.0       3.0 10.0   172.0 149.0                       321.0 167   24 113   4       3 10   172 149                 321
3348626 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No 1 PK 05 2016   k_12_total 252.0 3.0 18.0 33.0   5.0       3.0 26.0   184.0 156.0       0.0               340.0 252 3 18 33   5       3 26   184 156                 340
3348632 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No 1 PK 05 2016   pk_12_total 280.0 3.0 21.0 36.0   5.0       3.0 29.0   205.0 172.0                       377.0 280 3 21 36   5       3 29   205 172                 377
3350406 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2016   k_12_total 491.0 7.0 22.0 24.0   12.0       3.0 11.0   296.0 274.0       1.2               570.0 491 7 22 24   12       3 11   296 274                 570
3350420 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2016   pk_12_total 491.0 7.0 22.0 24.0   12.0       3.0 11.0   296.0 274.0                       570.0 491 7 22 24   12       3 11   296 274                 570
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
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
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
3344254 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2016   grade_6 140.0 3.0 4.0 12.0   2.0       2.0 4.0   79.0 88.0                       167.0 140 3 4 12   2       2 4   79 88                 167
3344289 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   k_12_total 347.0 4.0 16.0 23.0   7.0       2.0 17.0   216.0 200.0                       416.0 347 4 16 23   7       2 17   216 200                 416
3344307 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   pk_12_total 347.0 4.0 16.0 23.0   7.0       2.0 17.0   216.0 200.0                       416.0 347 4 16 23   7       2 17   216 200                 416
3345220 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   k_12_total 564.0 23.0 16.0     9.0       2.0 10.0   329.0 295.0       0.9               624.0 564 23 16     9       2 10   329 295                 624
3345234 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   pk_12_total 564.0 23.0 16.0     9.0       2.0 10.0   329.0 295.0                       624.0 564 23 16     9       2 10   329 295                 624
3345472 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   grade_9 206.0 4.0 17.0 5.0   10.0       2.0 6.0   134.0 116.0                       250.0 206 4 17 5   10       2 6   134 116                 250
3345986 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No 1 PK 04 2016   pk_12_total 124.0 2.0 10.0             2.0     73.0 65.0                       138.0 124 2 10             2     73 65                 138
3346613 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2016   grade_10 149.0 3.0 11.0 16.0   1.0       2.0 17.0   124.0 75.0                       199.0 149 3 11 16   1       2 17   124 75                 199
3346656 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   grade_6 148.0 3.0 15.0 17.0   2.0       2.0 21.0   105.0 103.0                       208.0 148 3 15 17   2       2 21   105 103                 208
3346662 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   grade_7 138.0 5.0 20.0 17.0   2.0       2.0 23.0   109.0 98.0                       207.0 138 5 20 17   2       2 23   109 98                 207
3346678 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2016   k_12_total 358.0 16.0 51.0 30.0   2.0       2.0 51.0   265.0 245.0       0.2               510.0 358 16 51 30   2       2 51   265 245                 510
3346679 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2016   k_12_total 509.0 23.0 40.0 56.0   9.0       2.0 68.0   391.0 316.0       0.1               707.0 509 23 40 56   9       2 68   391 316                 707
3346690 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2016   pk_12_total 358.0 16.0 51.0 30.0   2.0       2.0 51.0   265.0 245.0                       510.0 358 16 51 30   2       2 51   265 245                 510
3346691 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2016   pk_12_total 509.0 23.0 40.0 56.0   9.0       2.0 68.0   391.0 316.0                       707.0 509 23 40 56   9       2 68   391 316                 707
3347386 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No 1 KG 05 2016   grade_5 29.0   1.0 20.0   0.0       2.0 0.0   27.0 25.0                       52.0 29   1 20   0       2 0   27 25                 52
3348590 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No 1 PK 05 2016   grade_1 34.0 0.0 6.0 5.0   0.0       2.0 2.0   30.0 19.0                       49.0 34 0 6 5   0       2 2   30 19                 49
3350392 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2016   grade_8 151.0 3.0 11.0 11.0   3.0       2.0 4.0   103.0 82.0                       185.0 151 3 11 11   3       2 4   103 82                 185
3351663 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No 1 PK 05 2016   k_12_total 95.0 5.0 51.0 306.0   0.0       2.0 29.0   246.0 242.0       1.1               488.0 95 5 51 306   0       2 29   246 242                 488
3351688 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No 1 PK 05 2016   kindergarten 21.0 1.0 7.0 51.0   0.0       2.0 4.0   47.0 39.0                       86.0 21 1 7 51   0       2 4   47 39                 86
3351713 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No 1 PK 05 2016   pk_12_total 114.0 5.0 52.0 317.0   1.0       2.0 30.0   266.0 255.0                       521.0 114 5 52 317   1       2 30   266 255                 521
3352331 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   grade_3 31.0 21.0 11.0 3.0   8.0       2.0 4.0   47.0 33.0                       80.0 31 21 11 3   8       2 4   47 33                 80
3352353 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   grade_3 85.0 7.0 10.0 4.0   0.0       2.0 9.0   55.0 62.0                       117.0 85 7 10 4   0       2 9   55 62                 117
3352381 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   grade_4 42.0 14.0 3.0 7.0   1.0       2.0 6.0   39.0 36.0                       75.0 42 14 3 7   1       2 6   39 36                 75
3352632 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   k_12_total 221.0 118.0 72.0 15.0   42.0       2.0 30.0   268.0 232.0       29.2               500.0 221 118 72 15   42       2 30   268 232                 500
3352639 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   k_12_total 223.0 73.0 45.0 54.0   1.0       2.0 50.0   242.0 206.0       15.3               448.0 223 73 45 54   1       2 50   242 206                 448
3352649 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2016   k_12_total 1423.0 182.0 118.0 124.0   62.0       2.0 58.0   1025.0 944.0       4.6               1969.0 1423 182 118 124   62       2 58   1025 944                 1969
3352654 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   k_12_total 455.0 42.0 45.0 17.0   6.0       2.0 45.0   318.0 294.0       1.0               612.0 455 42 45 17   6       2 45   318 294                 612
3352718 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   pk_12_total 242.0 145.0 85.0 21.0   59.0       2.0 34.0   307.0 281.0                       588.0 242 145 85 21   59       2 34   307 281                 588
3352728 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   pk_12_total 144.0 120.0 89.0 62.0   33.0       2.0 50.0   267.0 233.0                       500.0 144 120 89 62   33       2 50   267 233                 500
3352735 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2016   pk_12_total 1423.0 182.0 118.0 124.0   62.0       2.0 58.0   1025.0 944.0                       1969.0 1423 182 118 124   62       2 58   1025 944                 1969
3352740 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   pk_12_total 455.0 42.0 45.0 17.0   6.0       2.0 45.0   318.0 294.0                       612.0 455 42 45 17   6       2 45   318 294                 612
3344178 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_1 44.0 1.0 4.0 4.0   1.0       1.0 4.0   32.0 27.0                       59.0 44 1 4 4   1       1 4   32 27                 59
3344184 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_10 294.0 8.0 6.0 20.0   9.0       1.0 4.0   177.0 165.0                       342.0 294 8 6 20   9       1 4   177 165                 342
3344202 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_12 246.0 7.0 12.0 20.0   10.0       1.0 5.0   153.0 148.0                       301.0 246 7 12 20   10       1 5   153 148                 301
3344223 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_3 46.0 3.0 4.0 3.0   0.0       1.0 6.0   32.0 31.0                       63.0 46 3 4 3   0       1 6   32 31                 63
3344226 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   grade_3 69.0 0.0 1.0 5.0   1.0       1.0 5.0   40.0 42.0                       82.0 69 0 1 5   1       1 5   40 42                 82
3344241 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_5 53.0 1.0 3.0 1.0   4.0       1.0 3.0   29.0 37.0                       66.0 53 1 3 1   4       1 3   29 37                 66
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
3344295 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   kindergarten 49.0 0.0 4.0 6.0   2.0       1.0 11.0   37.0 36.0                       73.0 49 0 4 6   2       1 11   37 36                 73
3344298 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   kindergarten 50.0 0.0 3.0 2.0   3.0       1.0 3.0   32.0 30.0                       62.0 50 0 3 2   3       1 3   32 30                 62
3344347 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_5 19.0   0.0 0.0           1.0 0.0   10.0 10.0                       20.0 19   0 0           1 0   10 10                 20
3344367 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   k_12_total 101.0   1.0 2.0           1.0 4.0   57.0 52.0       1.0               109.0 101   1 2           1 4   57 52                 109
3344375 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   pk_12_total 101.0   1.0 2.0           1.0 4.0   57.0 52.0                       109.0 101   1 2           1 4   57 52                 109
3345149 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   grade_11 258.0 6.0 4.0 0.0   4.0       1.0 2.0   137.0 138.0                       275.0 258 6 4 0   4       1 2   137 138                 275
3345156 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   grade_12 209.0 11.0 2.0 1.0   3.0       1.0 0.0   106.0 121.0                       227.0 209 11 2 1   3       1 0   106 121                 227
3345162 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No 1 KG 04 2016   grade_2 82.0 3.0 0.0 1.0   1.0       1.0 2.0   48.0 42.0                       90.0 82 3 0 1   1       1 2   48 42                 90
3345185 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   grade_5 289.0 13.0 9.0     1.0       1.0 7.0   161.0 159.0                       320.0 289 13 9     1       1 7   161 159                 320
3345192 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No 2 05 06 2016   grade_6 275.0 10.0 7.0     8.0       1.0 3.0   168.0 136.0                       304.0 275 10 7     8       1 3   168 136                 304
3345212 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   grade_9 235.0 5.0 6.0 1.0   4.0       1.0 2.0   129.0 125.0                       254.0 235 5 6 1   4       1 2   129 125                 254
3345218 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No 1 KG 04 2016   k_12_total 516.0 11.0 6.0 8.0   5.0       1.0 4.0   305.0 246.0       0.2               551.0 516 11 6 8   5       1 4   305 246                 551
3345232 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No 1 KG 04 2016   pk_12_total 516.0 11.0 6.0 8.0   5.0       1.0 4.0   305.0 246.0                       551.0 516 11 6 8   5       1 4   305 246                 551
3345317 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No 3 09 12 2016   grade_10 24.0 1.0 2.0 2.0           1.0     18.0 12.0                       30.0 24 1 2 2           1     18 12                 30
3345383 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No 3 09 12 2016   k_12_total 105.0 1.0 6.0 6.0           1.0     58.0 61.0       0.0               119.0 105 1 6 6           1     58 61                 119
3345395 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No 3 09 12 2016   pk_12_total 105.0 1.0 6.0 6.0           1.0     58.0 61.0                       119.0 105 1 6 6           1     58 61                 119
3345424 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   grade_12 187.0 5.0 9.0 5.0   6.0       1.0 3.0   109.0 107.0                       216.0 187 5 9 5   6       1 3   109 107                 216
3345434 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2016   grade_2 67.0 5.0 3.0 0.0   3.0       1.0 9.0   42.0 46.0                       88.0 67 5 3 0   3       1 9   42 46                 88
3345441 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   grade_3 59.0 7.0 5.0 2.0   3.0       1.0 9.0   36.0 50.0                       86.0 59 7 5 2   3       1 9   36 50                 86
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
3345479 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 2 04 05 2016   k_12_total 446.0 17.0 20.0 7.0   26.0       1.0 29.0   266.0 280.0                       546.0 446 17 20 7   26       1 29   266 280                 546
3345482 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2016   k_12_total 242.0 11.0 15.0 7.0   11.0       1.0 23.0   141.0 169.0                       310.0 242 11 15 7   11       1 23   141 169                 310
3345483 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   k_12_total 286.0 25.0 23.0 8.0   22.0       1.0 18.0   176.0 207.0                       383.0 286 25 23 8   22       1 18   176 207                 383
3345491 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 2 04 05 2016   pk_12_total 446.0 17.0 20.0 7.0   26.0       1.0 29.0   266.0 280.0                       546.0 446 17 20 7   26       1 29   266 280                 546
3345494 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2016   pk_12_total 242.0 11.0 15.0 7.0   11.0       1.0 23.0   141.0 169.0                       310.0 242 11 15 7   11       1 23   141 169                 310
3345495 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   pk_12_total 286.0 25.0 23.0 8.0   22.0       1.0 18.0   176.0 207.0                       383.0 286 25 23 8   22       1 18   176 207                 383
3345768 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No 3 09 12 2016   grade_12 38.0 0.0 1.0 23.0           1.0 5.0   35.0 33.0                       68.0 38 0 1 23           1 5   35 33                 68
3345795 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No 3 09 12 2016   k_12_total 142.0 1.0 10.0 101.0           1.0 14.0   127.0 142.0                       269.0 142 1 10 101           1 14   127 142                 269
3345801 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No 3 09 12 2016   pk_12_total 142.0 1.0 10.0 101.0           1.0 14.0   127.0 142.0                       269.0 142 1 10 101           1 14   127 142                 269
3345932 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No 1 PK 04 2016   grade_3 15.0 0.0 1.0             1.0     8.0 9.0                       17.0 15 0 1             1     8 9                 17
3345974 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No 1 PK 04 2016   k_12_total 101.0 2.0 9.0             1.0     63.0 50.0       4.4               113.0 101 2 9             1     63 50                 113
3345992 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No 1 PK 04 2016   pre_kindergarten 23.0 0.0 1.0             1.0     10.0 15.0                       25.0 23 0 1             1     10 15                 25
3346303 SD     school 4617850 38002   De Smet 38-2 461785000163 1 De Smet High School   Regular School No 3 09 12 2016   grade_9 24.0   0.0             1.0     12.0 13.0                       25.0 24   0             1     12 13                 25
3346306 SD     school 4617850 38002   De Smet 38-2 461785000163 1 De Smet High School   Regular School No 3 09 12 2016   k_12_total 91.0   2.0             1.0     43.0 51.0       0.0               94.0 91   2             1     43 51                 94
3346312 SD     school 4617850 38002   De Smet 38-2 461785000163 1 De Smet High School   Regular School No 3 09 12 2016   pk_12_total 91.0   2.0             1.0     43.0 51.0                       94.0 91   2             1     43 51                 94
3346446 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No 1 PK 05 2016   grade_1 48.0 1.0 3.0 0.0           1.0     28.0 25.0                       53.0 48 1 3 0           1     28 25                 53
3346451 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No 3 09 12 2016   grade_10 38.0 0.0 1.0 0.0           1.0     22.0 18.0                       40.0 38 0 1 0           1     22 18                 40

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