Data source: Big Local News · About: Big Local

10,752 rows where state = "SD" and year = 2019 sorted by native_american descending

View and edit SQL

year

  • 2019 · 10,752
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
367419 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2019   k_12_total 9.0     97.0             6.0   67.0 45.0       0.9               112.0 9     97             6   67 45                 112
367427 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2019   pk_12_total 9.0     97.0             6.0   67.0 45.0                       112.0 9     97             6   67 45                 112
365615 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2019   k_12_total 1721.0 184.0 261.0 95.0   72.0       1.0 70.0   1232.0 1172.0       6.6               2404.0 1721 184 261 95   72       1 70   1232 1172                 2404
365699 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2019   pk_12_total 1721.0 184.0 261.0 95.0   72.0       1.0 70.0   1232.0 1172.0                       2404.0 1721 184 261 95   72       1 70   1232 1172                 2404
357169 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   k_12_total 1057.0 32.0 65.0 94.0   34.0       2.0 22.0   639.0 667.0       3.3               1306.0 1057 32 65 94   34       2 22   639 667                 1306
357189 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   pk_12_total 1057.0 32.0 65.0 94.0   34.0       2.0 22.0   639.0 667.0                       1306.0 1057 32 65 94   34       2 22   639 667                 1306
366305 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2019   grade_2 2.0 0.0 3.0 94.0   1.0         1.0   54.0 47.0                       101.0 2 0 3 94   1         1   54 47                 101
363829 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2019   k_12_total 1.0     93.0             2.0   31.0 65.0       4.2               96.0 1     93             2   31 65                 96
363839 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2019   pk_12_total 1.0     93.0             2.0   31.0 65.0                       96.0 1     93             2   31 65                 96
364590 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2019   grade_8 43.0 3.0 30.0 93.0   0.0         18.0   83.0 104.0                       187.0 43 3 30 93   0         18   83 104                 187
366413 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2019   kindergarten 0.0 0.0 4.0 93.0   0.0         2.0   48.0 51.0                       99.0 0 0 4 93   0         2   48 51                 99
364151 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No Elementary KG 05 2019   k_12_total 262.0 1.0 15.0 92.0             43.0   203.0 210.0       0.5               413.0 262 1 15 92             43   203 210                 413
364161 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 262.0 1.0 15.0 92.0             43.0   203.0 210.0                       413.0 262 1 15 92             43   203 210                 413
366341 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2019   grade_5 0.0 0.0 2.0 92.0   0.0         0.0   43.0 51.0                       94.0 0 0 2 92   0         0   43 51                 94
364540 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2019   grade_6 49.0 2.0 32.0 91.0   4.0         27.0   112.0 93.0                       205.0 49 2 32 91   4         27   112 93                 205
366329 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2019   grade_4 0.0 0.0 2.0 91.0   0.0         2.0   45.0 50.0                       95.0 0 0 2 91   0         2   45 50                 95
366236 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No Elementary PK 05 2019   k_12_total 71.0   2.0 90.0             0.0   85.0 78.0       0.6               163.0 71   2 90             0   85 78                 163
357336 SD     school 4639540 11001   Andes Central 11-1 463954000360 1 Andes Central High School   Regular School No High 09 12 2019   grade_12 5.0   0.0 9.0             1.0   10.0 5.0                       15.0 5   0 9             1   10 5                 15
357560 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2019   k_12_total 97.0   5.0 9.0             8.0   57.0 62.0       0.0               119.0 97   5 9             8   57 62                 119
357568 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2019   pk_12_total 97.0   5.0 9.0             8.0   57.0 62.0                       119.0 97   5 9             8   57 62                 119
357710 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2019   grade_11 12.0   0.0 9.0   0.0         2.0   13.0 10.0                       23.0 12   0 9   0         2   13 10                 23
359017 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School No High 09 12 2019   k_12_total 61.0     9.0   3.0         2.0   37.0 38.0       0.0               75.0 61     9   3         2   37 38                 75
359019 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2019   k_12_total 4.0     9.0                 4.0 9.0       0.0               13.0 4     9                 4 9                 13
359025 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School No High 09 12 2019   pk_12_total 61.0     9.0   3.0         2.0   37.0 38.0                       75.0 61     9   3         2   37 38                 75
359027 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2019   pk_12_total 4.0     9.0                 4.0 9.0                       13.0 4     9                 4 9                 13
359125 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2019   grade_9 65.0 2.0 2.0 9.0           1.0 4.0   41.0 42.0                       83.0 65 2 2 9           1 4   41 42                 83
359293 SD     school 4618120 49003   Dell Rapids 49-3 461812000165 1 Dell Rapids High School   Regular School No High 09 12 2019   k_12_total 280.0 1.0 4.0 9.0             4.0   155.0 143.0       0.3               298.0 280 1 4 9             4   155 143                 298
359299 SD     school 4618120 49003   Dell Rapids 49-3 461812000165 1 Dell Rapids High School   Regular School No High 09 12 2019   pk_12_total 280.0 1.0 4.0 9.0             4.0   155.0 143.0                       298.0 280 1 4 9             4   155 143                 298
361159 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   k_12_total 953.0 20.0 27.0 9.0   10.0         34.0   528.0 525.0       1.0               1053.0 953 20 27 9   10         34   528 525                 1053
361177 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   pk_12_total 953.0 20.0 27.0 9.0   10.0         34.0   528.0 525.0                       1053.0 953 20 27 9   10         34   528 525                 1053
361468 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2019   grade_10 40.0 2.0 2.0 9.0   1.0         2.0   29.0 27.0                       56.0 40 2 2 9   1         2   29 27                 56
361711 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   k_12_total 280.0 13.0 125.0 9.0   109.0       5.0 10.0   292.0 259.0       17.2               551.0 280 13 125 9   109       5 10   292 259                 551
361725 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   pk_12_total 280.0 13.0 125.0 9.0   109.0       5.0 10.0   292.0 259.0                       551.0 280 13 125 9   109       5 10   292 259                 551
362018 SD     school 4680437 35002   Kadoka Area 35-2 468043701249 2 Kadoka Elementary School   Regular School No Elementary PK 05 2019   grade_2 6.0     9.0                 8.0 7.0                       15.0 6     9                 8 7                 15
362030 SD     school 4680437 35002   Kadoka Area 35-2 468043701249 2 Kadoka Elementary School   Regular School No Elementary PK 05 2019   grade_4 8.0     9.0                 8.0 9.0                       17.0 8     9                 8 9                 17
362040 SD     school 4680437 35002   Kadoka Area 35-2 468043701245 9 Interior Elementary   Regular School No Elementary KG 08 2019   grade_6 0.0   0.0 9.0                 6.0 3.0                       9.0 0   0 9                 6 3                 9
362329 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2019   k_12_total 256.0 2.0 16.0 9.0   3.0       1.0 15.0   157.0 145.0       0.7               302.0 256 2 16 9   3       1 15   157 145                 302
362337 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2019   pk_12_total 256.0 2.0 16.0 9.0   3.0       1.0 15.0   157.0 145.0                       302.0 256 2 16 9   3       1 15   157 145                 302
362613 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2019   grade_9 19.0     9.0             1.0   18.0 11.0                       29.0 19     9             1   18 11                 29
362813 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No Elementary PK 06 2019   grade_5 8.0   1.0 9.0             2.0   7.0 13.0                       20.0 8   1 9             2   7 13                 20
363332 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2019   grade_6 196.0 4.0 19.0 9.0   0.0         4.0   112.0 120.0                       232.0 196 4 19 9   0         4   112 120                 232
363644 SD     school 4650850 9002   Newell 09-2 465085000468 2 Newell Elem   Regular School No Elementary PK 05 2019   k_12_total 94.0 2.0 6.0 9.0             2.0   48.0 65.0       0.0               113.0 94 2 6 9             2   48 65                 113
363646 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2019   k_12_total 60.0 1.0 3.0 9.0   1.0         3.0   41.0 36.0       0.0               77.0 60 1 3 9   1         3   41 36                 77
363650 SD     school 4650850 9002   Newell 09-2 465085000468 2 Newell Elem   Regular School No Elementary PK 05 2019   pk_12_total 109.0 2.0 8.0 9.0             4.0   56.0 76.0                       132.0 109 2 8 9             4   56 76                 132
363652 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2019   pk_12_total 60.0 1.0 3.0 9.0   1.0         3.0   41.0 36.0                       77.0 60 1 3 9   1         3   41 36                 77
363746 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No Middle 06 08 2019   grade_6 0.0   0.0 9.0             1.0   6.0 4.0                       10.0 0   0 9             1   6 4                 10
363779 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2019   grade_11 1.0     9.0             0.0   5.0 5.0                       10.0 1     9             0   5 5                 10
363795 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2019   grade_3       9.0                 5.0 4.0                       9.0       9                 5 4                 9
364091 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No Elementary KG 05 2019   grade_1 47.0 0.0 0.0 9.0             7.0   31.0 32.0                       63.0 47 0 0 9             7   31 32                 63
364468 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2019   grade_3 73.0 0.0 6.0 9.0   1.0         12.0   46.0 55.0                       101.0 73 0 6 9   1         12   46 55                 101
364478 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School No Elementary KG 05 2019   grade_4 43.0 0.0 2.0 9.0   0.0         9.0   29.0 34.0                       63.0 43 0 2 9   0         9   29 34                 63
364489 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2019   grade_4 72.0 0.0 5.0 9.0   0.0         4.0   44.0 46.0                       90.0 72 0 5 9   0         4   44 46                 90
364518 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2019   grade_5 60.0 0.0 8.0 9.0   1.0         11.0   41.0 48.0                       89.0 60 0 8 9   1         11   41 48                 89
364668 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2019   kindergarten 70.0 0.0 6.0 9.0   0.0         7.0   51.0 41.0                       92.0 70 0 6 9   0         7   51 41                 92
364686 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2019   pk_12_total 14.0   1.0 9.0             1.0   19.0 6.0                       25.0 14   1 9             1   19 6                 25
364711 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2019   pre_kindergarten 13.0   1.0 9.0             1.0   19.0 5.0                       24.0 13   1 9             1   19 5                 24
365096 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2019   grade_1 22.0 9.0 13.0 9.0   2.0       0.0 9.0   33.0 31.0                       64.0 22 9 13 9   2       0 9   33 31                 64
365287 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2019   grade_2 24.0 15.0 20.0 9.0   3.0         6.0   35.0 42.0                       77.0 24 15 20 9   3         6   35 42                 77
365345 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2019   grade_4 31.0 17.0 9.0 9.0   5.0       0.0 7.0   38.0 40.0                       78.0 31 17 9 9   5       0 7   38 40                 78
365355 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2019   grade_4 27.0 10.0 11.0 9.0   0.0       0.0 14.0   34.0 37.0                       71.0 27 10 11 9   0       0 14   34 37                 71
365596 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No High 06 12 2019   k_12_total 15.0 10.0 3.0 9.0             4.0   30.0 11.0       4.9               41.0 15 10 3 9             4   30 11                 41
365647 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2019   kindergarten 53.0 11.0 9.0 9.0   0.0       1.0 7.0   45.0 45.0                       90.0 53 11 9 9   0       1 7   45 45                 90
365649 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2019   kindergarten 32.0 15.0 14.0 9.0   1.0       0.0 10.0   43.0 38.0                       81.0 32 15 14 9   1       0 10   43 38                 81
365680 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No High 06 12 2019   pk_12_total 15.0 10.0 3.0 9.0             4.0   30.0 11.0                       41.0 15 10 3 9             4   30 11                 41
365725 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 90.0 26.0 18.0 9.0   5.0         17.0   91.0 74.0                       165.0 90 26 18 9   5         17   91 74                 165
365809 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2019   grade_12 15.0 0.0 2.0 9.0   0.0         3.0   18.0 11.0                       29.0 15 0 2 9   0         3   18 11                 29
365855 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No High 09 12 2019   grade_11       9.0             0.0   4.0 5.0                       9.0       9             0   4 5                 9
366012 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High S   Alternative School No High 09 12 2019   k_12_total 5.0 1.0 1.0 9.0                 8.0 8.0       0.0               16.0 5 1 1 9                 8 8                 16
366028 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High S   Alternative School No High 09 12 2019   pk_12_total 5.0 1.0 1.0 9.0                 8.0 8.0                       16.0 5 1 1 9                 8 8                 16
366387 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School No High 09 12 2019   grade_9       9.0                 3.0 6.0                       9.0       9                 3 6                 9
366582 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2019   grade_12 81.0 1.0 5.0 9.0   2.0         1.0   51.0 48.0                       99.0 81 1 5 9   2         1   51 48                 99
366593 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2019   grade_4 65.0 3.0 2.0 9.0   3.0         4.0   46.0 40.0                       86.0 65 3 2 9   3         4   46 40                 86
366811 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2019   k_12_total 55.0     9.0   1.0             37.0 28.0       0.0               65.0 55     9   1             37 28                 65
366819 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2019   pk_12_total 55.0     9.0   1.0             37.0 28.0                       65.0 55     9   1             37 28                 65
366959 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2019   grade_8 266.0 4.0 13.0 9.0   2.0         6.0   161.0 139.0                       300.0 266 4 13 9   2         6   161 139                 300
367026 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2019   grade_6 8.0     9.0                 12.0 5.0                       17.0 8     9                 12 5                 17
367034 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2019   grade_9 3.0   0.0 9.0                 6.0 6.0                       12.0 3   0 9                 6 6                 12
367303 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2019   k_12_total 339.0 2.0 8.0 9.0             14.0   186.0 186.0       0.8               372.0 339 2 8 9             14   186 186                 372
367313 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2019   pk_12_total 339.0 2.0 8.0 9.0             14.0   186.0 186.0                       372.0 339 2 8 9             14   186 186                 372
367388 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No Elementary KG 05 2019   grade_3       9.0                 7.0 2.0                       9.0       9                 7 2                 9
367797 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2019   pre_kindergarten 150.0 3.0 16.0 9.0   5.0         2.0   83.0 102.0                       185.0 150 3 16 9   5         2   83 102                 185
364650 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2019   k_12_total 373.0 2.0 62.0 88.0   14.0         83.0   323.0 299.0       1.9               622.0 373 2 62 88   14         83   323 299                 622
364700 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2019   pk_12_total 373.0 2.0 62.0 88.0   14.0         83.0   323.0 299.0                       622.0 373 2 62 88   14         83   323 299                 622
357380 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 05 2019   k_12_total 26.0   8.0 86.0             28.0   81.0 67.0       0.0               148.0 26   8 86             28   81 67                 148
366257 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2019   grade_1 0.0 1.0 5.0 86.0   0.0         3.0   58.0 37.0                       95.0 0 1 5 86   0         3   58 37                 95
367418 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2019   k_12_total 19.0 2.0   86.0           1.0 2.0   55.0 55.0       0.9               110.0 19 2   86           1 2   55 55                 110
367426 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2019   pk_12_total 19.0 2.0   86.0           1.0 2.0   55.0 55.0                       110.0 19 2   86           1 2   55 55                 110
363797 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2019   grade_3 0.0   1.0 85.0             0.0   46.0 40.0                       86.0 0   1 85             0   46 40                 86
364150 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School No Elementary KG 05 2019   k_12_total 279.0 1.0 30.0 85.0   1.0         44.0   227.0 213.0       0.7               440.0 279 1 30 85   1         44   227 213                 440
364160 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School No Elementary KG 05 2019   pk_12_total 279.0 1.0 30.0 85.0   1.0         44.0   227.0 213.0                       440.0 279 1 30 85   1         44   227 213                 440
364679 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School No Elementary PK 05 2019   pk_12_total 225.0 4.0 41.0 85.0   4.0         54.0   217.0 196.0                       413.0 225 4 41 85   4         54   217 196                 413
359692 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2019   grade_4 1.0   0.0 84.0   1.0       0.0 0.0   44.0 42.0                       86.0 1   0 84   1       0 0   44 42                 86
364152 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2019   k_12_total 552.0 4.0 25.0 83.0   6.0         57.0   382.0 345.0       0.8               727.0 552 4 25 83   6         57   382 345                 727
364162 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2019   pk_12_total 552.0 4.0 25.0 83.0   6.0         57.0   382.0 345.0                       727.0 552 4 25 83   6         57   382 345                 727
364629 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School No Elementary PK 05 2019   k_12_total 218.0 4.0 41.0 83.0   4.0         52.0   212.0 190.0       1.2               402.0 218 4 41 83   4         52   212 190                 402
365598 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2019   k_12_total 352.0 154.0 209.0 83.0   27.0       1.0 64.0   471.0 419.0       16.0               890.0 352 154 209 83   27       1 64   471 419                 890
365682 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2019   pk_12_total 352.0 154.0 209.0 83.0   27.0       1.0 64.0   471.0 419.0                       890.0 352 154 209 83   27       1 64   471 419                 890
363840 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2019   pk_12_total       82.0                 43.0 39.0                       82.0       82                 43 39                 82
359709 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2019   k_12_total 2.0     81.0   1.0             44.0 40.0       0.0               84.0 2     81   1             44 40                 84
359715 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2019   pk_12_total 2.0     81.0   1.0             44.0 40.0                       84.0 2     81   1             44 40                 84

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