enrollments

Data source: Big Local News · About: Big Local

10,736 rows where state = "SD" and year = 2018 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
250397 250397 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2018   grade_12 87.0   4.0 2.0   1.0         5.0   46.0 53.0                       99.0 87   4 2   1         5   46 53                 99
254218 254218 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No Elementary KG 06 2018   k_12_total 97.0   1.0 1.0                 57.0 42.0       0.0               99.0 97   1 1                 57 42                 99
254228 254228 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No Elementary KG 06 2018   pk_12_total 97.0   1.0 1.0                 57.0 42.0                       99.0 97   1 1                 57 42                 99
255213 255213 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School No Middle 07 08 2018   grade_7 93.0 1.0 4.0 1.0             0.0   48.0 51.0                       99.0 93 1 4 1             0   48 51                 99
255400 255400 SD     school 4644770 42001   Lyman 42-1 464477000397 3 Presho Elementary   Regular School No Elementary PK 05 2018   pk_12_total 80.0   1.0 14.0             4.0   59.0 40.0                       99.0 80   1 14             4   59 40                 99
255601 255601 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No Elementary PK 06 2018   k_12_total 52.0 3.0 3.0 31.0             10.0   49.0 50.0       0.0               99.0 52 3 3 31             10   49 50                 99
258957 258957 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2018   k_12_total 70.0 12.0 7.0 2.0   2.0         6.0   53.0 46.0       16.2               99.0 70 12 7 2   2         6   53 46                 99
258965 258965 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2018   pk_12_total 70.0 12.0 7.0 2.0   2.0         6.0   53.0 46.0                       99.0 70 12 7 2   2         6   53 46                 99
259114 259114 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   grade_5 1.0   0.0 98.0             0.0   34.0 65.0                       99.0 1   0 98             0   34 65                 99
253932 253932 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   k_12_total 900.0 16.0 21.0 9.0   11.0         29.0   524.0 462.0       0.6               986.0 900 16 21 9   11         29   524 462                 986
253950 253950 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   pk_12_total 900.0 16.0 21.0 9.0   11.0         29.0   524.0 462.0                       986.0 900 16 21 9   11         29   524 462                 986
250418 250418 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No Middle 05 08 2018   grade_5 88.0   5.0 2.0             3.0   53.0 45.0                       98.0 88   5 2             3   53 45                 98
250722 250722 SD     school 4607400 4002   Bon Homme 04-2 460740000987 2 Bon Homme Middle School   Regular School No Middle 06 08 2018   k_12_total 92.0   1.0 1.0             4.0   58.0 40.0       0.0               98.0 92   1 1             4   58 40                 98
250736 250736 SD     school 4607400 4002   Bon Homme 04-2 460740000987 2 Bon Homme Middle School   Regular School No Middle 06 08 2018   pk_12_total 92.0   1.0 1.0             4.0   58.0 40.0                       98.0 92   1 1             4   58 40                 98
251885 251885 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   grade_1 79.0 1.0 9.0 0.0   2.0         7.0   51.0 47.0                       98.0 79 1 9 0   2         7   51 47                 98
251923 251923 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2018   grade_7 84.0 1.0 6.0 1.0   3.0         3.0   51.0 47.0                       98.0 84 1 6 1   3         3   51 47                 98
251927 251927 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2018   grade_8 82.0 4.0 5.0 2.0   1.0         4.0   49.0 49.0                       98.0 82 4 5 2   1         4   49 49                 98
253939 253939 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   kindergarten 82.0 3.0 2.0 3.0   5.0         3.0   50.0 48.0                       98.0 82 3 2 3   5         3   50 48                 98
255743 255743 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   grade_5 84.0 0.0 6.0 5.0   1.0         2.0   45.0 53.0                       98.0 84 0 6 5   1         2   45 53                 98
258090 258090 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   grade_4 70.0 8.0 11.0 3.0   0.0       0.0 6.0   48.0 50.0                       98.0 70 8 11 3   0       0 6   48 50                 98
258901 258901 SD     school 4670140 54006   Summit 54-6 467014000662 2 Summit Elementary   Regular School No Elementary PK 08 2018   k_12_total 70.0 0.0 5.0 16.0             7.0   48.0 50.0       4.1               98.0 70 0 5 16             7   48 50                 98
259384 259384 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   grade_8 82.0 1.0 2.0 8.0   4.0         1.0   59.0 39.0                       98.0 82 1 2 8   4         1   59 39                 98
259520 259520 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2018   k_12_total 26.0   5.0 58.0             9.0   54.0 44.0       0.0               98.0 26   5 58             9   54 44                 98
259524 259524 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2018   kindergarten 26.0   5.0 58.0             9.0   54.0 44.0                       98.0 26   5 58             9   54 44                 98
258436 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
251765 251765 SD     school 4614130 59003   Colome Consolidated 461413000140 2 Colome Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 72.0   1.0 19.0   2.0         3.0   44.0 53.0                       97.0 72   1 19   2         3   44 53                 97
253866 253866 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2018   grade_3 89.0 2.0 2.0 1.0   1.0         2.0   50.0 47.0                       97.0 89 2 2 1   1         2   50 47                 97
253884 253884 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2018   grade_5 82.0 3.0 2.0 0.0   4.0         6.0   50.0 47.0                       97.0 82 3 2 0   4         6   50 47                 97
255495 255495 SD     school 4645450 60003   Marion 60-3 464545000407 2 Marion Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 81.0   10.0               6.0   51.0 46.0                       97.0 81   10               6   51 46                 97
255651 255651 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2018   k_12_total 3.0   2.0 92.0                 51.0 46.0       2.1               97.0 3   2 92                 51 46                 97
255657 255657 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2018   pk_12_total 3.0   2.0 92.0                 51.0 46.0                       97.0 3   2 92                 51 46                 97
255721 255721 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   grade_3 89.0 0.0 2.0 3.0   0.0         3.0   57.0 40.0                       97.0 89 0 2 3   0         3   57 40                 97
255803 255803 SD     school 4669930 46001   Meade 46-1 466993000652 4 Whitewood Elementary   Regular School No Elementary KG 06 2018   k_12_total 85.0   3.0 4.0           1.0 4.0   45.0 52.0       0.0               97.0 85   3 4           1 4   45 52                 97
255825 255825 SD     school 4669930 46001   Meade 46-1 466993000652 4 Whitewood Elementary   Regular School No Elementary KG 06 2018   pk_12_total 85.0   3.0 4.0           1.0 4.0   45.0 52.0                       97.0 85   3 4           1 4   45 52                 97
257917 257917 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No High 09 12 2018   grade_11 71.0 9.0 6.0 5.0   3.0         3.0   45.0 52.0                       97.0 71 9 6 5   3         3   45 52                 97
257994 257994 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   grade_2 41.0 10.0 31.0 4.0   1.0         10.0   50.0 47.0                       97.0 41 10 31 4   1         10   50 47                 97
257995 257995 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2018   grade_2 75.0 5.0 4.0 2.0   1.0         10.0   51.0 46.0                       97.0 75 5 4 2   1         10   51 46                 97
258078 258078 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   grade_4 79.0 6.0 3.0 1.0   2.0         6.0   37.0 60.0                       97.0 79 6 3 1   2         6   37 60                 97
259010 259010 SD     school 4671880 20003   Timber Lake 20-3 467188000665 1 Timber Lake High School 9-12   Regular School No High 09 12 2018   k_12_total 34.0   3.0 60.0                 44.0 53.0       0.0               97.0 34   3 60                 44 53                 97
259016 259016 SD     school 4671880 20003   Timber Lake 20-3 467188000665 1 Timber Lake High School 9-12   Regular School No High 09 12 2018   pk_12_total 34.0   3.0 60.0                 44.0 53.0                       97.0 34   3 60                 44 53                 97
259030 259030 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   grade_1 1.0   1.0 94.0             1.0   53.0 44.0                       97.0 1   1 94             1   53 44                 97
250066 250066 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2018   k_12_total 89.0   7.0                   45.0 51.0       2.1               96.0 89   7                   45 51                 96
250072 250072 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2018   pk_12_total 89.0   7.0                   45.0 51.0                       96.0 89   7                   45 51                 96
253875 253875 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2018   grade_4 89.0 2.0 0.0 0.0   2.0         3.0   55.0 41.0                       96.0 89 2 0 0   2         3   55 41                 96
255239 255239 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pk_12_total 91.0   3.0 2.0                 55.0 41.0                       96.0 91   3 2                 55 41                 96
255431 255431 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No Middle 06 08 2018   grade_6 81.0 1.0 6.0 2.0   1.0         5.0   41.0 55.0                       96.0 81 1 6 2   1         5   41 55                 96
255666 255666 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   grade_1 85.0 1.0 3.0 0.0   0.0         7.0   49.0 47.0                       96.0 85 1 3 0   0         7   49 47                 96
255809 255809 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   kindergarten 84.0 0.0 6.0 1.0   0.0         5.0   51.0 45.0                       96.0 84 0 6 1   0         5   51 45                 96
256533 256533 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   grade_2 1.0   1.0 94.0             0.0   55.0 41.0                       96.0 1   1 94             0   55 41                 96
258033 258033 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   grade_3 40.0 24.0 10.0 9.0   6.0       0.0 7.0   52.0 44.0                       96.0 40 24 10 9   6       0 7   52 44                 96
251905 251905 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   grade_3 82.0 0.0 5.0 1.0   2.0         5.0   43.0 52.0                       95.0 82 0 5 1   2         5   43 52                 95
255389 255389 SD     school 4644770 42001   Lyman 42-1 464477000728 4 Kennebec Elementary   Regular School No Elementary KG 05 2018   k_12_total 32.0     59.0             4.0   49.0 46.0       0.0               95.0 32     59             4   49 46                 95
255390 255390 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2018   k_12_total 64.0   1.0 29.0             1.0   51.0 44.0       0.0               95.0 64   1 29             1   51 44                 95
255397 255397 SD     school 4644770 42001   Lyman 42-1 464477000728 4 Kennebec Elementary   Regular School No Elementary KG 05 2018   pk_12_total 32.0     59.0             4.0   49.0 46.0                       95.0 32     59             4   49 46                 95
255398 255398 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2018   pk_12_total 64.0   1.0 29.0             1.0   51.0 44.0                       95.0 64   1 29             1   51 44                 95
255415 255415 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No High 09 12 2018   grade_12 89.0 1.0 4.0 0.0   1.0         0.0   42.0 53.0                       95.0 89 1 4 0   1         0   42 53                 95
257164 257164 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2018   grade_2 76.0 1.0 3.0 11.0   1.0         3.0   51.0 44.0                       95.0 76 1 3 11   1         3   51 44                 95
257393 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
258016 258016 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   grade_2 47.0 16.0 17.0 4.0   4.0       1.0 6.0   45.0 50.0                       95.0 47 16 17 4   4       1 6   45 50                 95
258490 258490 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 31.0 20.0 25.0 6.0   6.0         7.0   47.0 48.0                       95.0 31 20 25 6   6         7   47 48                 95
259376 259376 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   grade_6 70.0 2.0 4.0 11.0   4.0         4.0   45.0 50.0                       95.0 70 2 4 11   4         4   45 50                 95
259380 259380 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   grade_7 68.0 1.0 7.0 12.0   0.0         7.0   42.0 53.0                       95.0 68 1 7 12   0         7   42 53                 95
250837 250837 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2018   grade_3 89.0 1.0 2.0 1.0   0.0         1.0   51.0 43.0                       94.0 89 1 2 1   0         1   51 43                 94
251030 251030 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2018   k_12_total 84.0 2.0 3.0 3.0   1.0       1.0     58.0 36.0       0.0               94.0 84 2 3 3   1       1     58 36                 94
251042 251042 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2018   pk_12_total 84.0 2.0 3.0 3.0   1.0       1.0     58.0 36.0                       94.0 84 2 3 3   1       1     58 36                 94
251135 251135 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   kindergarten 71.0 1.0 7.0 4.0   6.0         5.0   49.0 45.0                       94.0 71 1 7 4   6         5   49 45                 94
254701 254701 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2018   k_12_total 82.0 6.0 4.0 2.0                 41.0 53.0       3.2               94.0 82 6 4 2                 41 53                 94
255202 255202 SD     school 4641550 41004   Lennox 41-4 464155001363 9 Lennox Intermediate   Regular School No Middle 05 06 2018   grade_5 85.0 1.0 3.0 1.0             4.0   47.0 47.0                       94.0 85 1 3 1             4   47 47                 94
255927 255927 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2018   grade_12 88.0 0.0 3.0 1.0           1.0 1.0   48.0 46.0                       94.0 88 0 3 1           1 1   48 46                 94
256305 256305 SD     school 4649650 17003   Mount Vernon 17-3 464965000454 2 Mount Vernon Elementary   Regular School No Elementary PK 05 2018   k_12_total 89.0 2.0 1.0 2.0                 50.0 44.0       0.0               94.0 89 2 1 2                 50 44                 94
256354 256354 SD     school 4650670 51003   New Underwood 51-3 465067000464 1 New Underwood Hi Sch   Regular School No High 09 12 2018   k_12_total 82.0   2.0 6.0             4.0   48.0 46.0       2.1               94.0 82   2 6             4   48 46                 94
256360 256360 SD     school 4650670 51003   New Underwood 51-3 465067000464 1 New Underwood Hi Sch   Regular School No High 09 12 2018   pk_12_total 82.0   2.0 6.0             4.0   48.0 46.0                       94.0 82   2 6             4   48 46                 94
256402 256402 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2018   k_12_total 87.0 3.0 1.0 1.0           1.0 1.0   52.0 42.0       0.0               94.0 87 3 1 1           1 1   52 42                 94
256408 256408 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2018   pk_12_total 87.0 3.0 1.0 1.0           1.0 1.0   52.0 42.0                       94.0 87 3 1 1           1 1   52 42                 94
257117 257117 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2018   grade_11 55.0 3.0 5.0 27.0   0.0         4.0   50.0 44.0                       94.0 55 3 5 27   0         4   50 44                 94
257389 257389 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2018   kindergarten 74.0 3.0 3.0 11.0   1.0         2.0   50.0 44.0                       94.0 74 3 3 11   1         2   50 44                 94
257630 257630 SD     school 4664140 39004   Rutland 39-4 466414000562 2 Rutland Elem   Regular School No Elementary KG 05 2018   k_12_total 92.0     1.0             1.0   43.0 51.0       0.0               94.0 92     1             1   43 51                 94
257638 257638 SD     school 4664140 39004   Rutland 39-4 466414000562 2 Rutland Elem   Regular School No Elementary KG 05 2018   pk_12_total 92.0     1.0             1.0   43.0 51.0                       94.0 92     1             1   43 51                 94
257836 257836 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School No Elementary PK 05 2018   grade_1 84.0 2.0 2.0 0.0   0.0       0.0 6.0   48.0 46.0                       94.0 84 2 2 0   0       0 6   48 46                 94
258041 258041 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2018   grade_3 63.0 9.0 11.0 1.0   1.0         9.0   47.0 47.0                       94.0 63 9 11 1   1         9   47 47                 94
258054 258054 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   grade_3 81.0 1.0 4.0 1.0   1.0       0.0 6.0   55.0 39.0                       94.0 81 1 4 1   1       0 6   55 39                 94
259634 259634 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2018   k_12_total 86.0 2.0 1.0 4.0   1.0             49.0 45.0       1.1               94.0 86 2 1 4   1             49 45                 94
259640 259640 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2018   pk_12_total 86.0 2.0 1.0 4.0   1.0             49.0 45.0                       94.0 86 2 1 4   1             49 45                 94
259685 259685 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2018   grade_3 85.0 0.0 4.0 2.0   0.0         3.0   51.0 43.0                       94.0 85 0 4 2   0         3   51 43                 94
260027 260027 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2018   grade_5 81.0 2.0 5.0 1.0   1.0         4.0   54.0 40.0                       94.0 81 2 5 1   1         4   54 40                 94
260248 260248 SD     school 4679350 12003   Willow Lake 12-3 467935000755 2 Willow Lake Elem   Regular School No Elementary PK 05 2018   k_12_total 86.0 0.0 5.0 3.0                 37.0 57.0       2.1               94.0 86 0 5 3                 37 57                 94
260356 260356 SD     school 4679710 59002   Winner 59-2 467971000479 4 Winner Elementary   Regular School No Elementary KG 05 2018   kindergarten 45.0 1.0 0.0 47.0   1.0         0.0   50.0 44.0                       94.0 45 1 0 47   1         0   50 44                 94
250839 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
251444 251444 SD     school 4612000 7001   Chamberlain 07-1 461200000118 3 Chamberlain Elementary School   Regular School No Elementary KG 06 2018   kindergarten 41.0   2.0 42.0           1.0 7.0   54.0 39.0                       93.0 41   2 42           1 7   54 39                 93
252402 252402 SD     school 4619450 64002   Dupree 64-2 461945000800 1 Dupree Hi Sch   Regular School No High 09 12 2018   k_12_total 17.0   1.0 75.0                 40.0 53.0       2.2               93.0 17   1 75                 40 53                 93
252408 252408 SD     school 4619450 64002   Dupree 64-2 461945000800 1 Dupree Hi Sch   Regular School No High 09 12 2018   pk_12_total 17.0   1.0 75.0                 40.0 53.0                       93.0 17   1 75                 40 53                 93
253378 253378 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2018   k_12_total 84.0   3.0 1.0             5.0   47.0 46.0       0.0               93.0 84   3 1             5   47 46                 93
253384 253384 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2018   pk_12_total 84.0   3.0 1.0             5.0   47.0 46.0                       93.0 84   3 1             5   47 46                 93
255909 255909 SD     school 4647100 33002   Menno 33-2 464710000419 2 Menno Elementary   Regular School No Elementary PK 05 2018   pk_12_total 92.0   1.0                   41.0 52.0                       93.0 92   1                   41 52                 93
256072 256072 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   grade_4 75.0 1.0 5.0 7.0   0.0         5.0   47.0 46.0                       93.0 75 1 5 7   0         5   47 46                 93
256121 256121 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   kindergarten 74.0 2.0 5.0 9.0   0.0         3.0   44.0 49.0                       93.0 74 2 5 9   0         3   44 49                 93
257069 257069 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No Elementary PK 05 2018   grade_1 49.0 0.0 10.0 24.0   1.0       0.0 9.0   53.0 40.0                       93.0 49 0 10 24   1       0 9   53 40                 93
257243 257243 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   grade_5 71.0 1.0 4.0 4.0   0.0       0.0 13.0   43.0 50.0                       93.0 71 1 4 4   0       0 13   43 50                 93
257832 257832 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   grade_1 71.0 4.0 5.0 2.0   0.0       0.0 11.0   36.0 57.0                       93.0 71 4 5 2   0       0 11   36 57                 93
258108 258108 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   grade_5 33.0 28.0 7.0 0.0   17.0         8.0   53.0 40.0                       93.0 33 28 7 0   17         8   53 40                 93

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