enrollments

Data source: Big Local News · About: Big Local

10,736 rows where state = "SD" and year = 2018 sorted by total_int 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 ▲
258353 258353 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   k_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0       5.9               2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
258439 258439 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   pk_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0                       2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
258343 258343 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   k_12_total 1419.0 224.0 145.0 91.0   54.0       1.0 72.0   1049.0 957.0       5.5               2006.0 1419 224 145 91   54       1 72   1049 957                 2006
258429 258429 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   pk_12_total 1419.0 224.0 145.0 91.0   54.0       1.0 72.0   1049.0 957.0                       2006.0 1419 224 145 91   54       1 72   1049 957                 2006
258362 258362 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   k_12_total 1111.0 333.0 224.0 66.0   143.0       1.0 61.0   997.0 942.0       14.7               1939.0 1111 333 224 66   143       1 61   997 942                 1939
258448 258448 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   pk_12_total 1111.0 333.0 224.0 66.0   143.0       1.0 61.0   997.0 942.0                       1939.0 1111 333 224 66   143       1 61   997 942                 1939
257355 257355 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2018   k_12_total 1222.0 33.0 104.0 386.0   19.0         89.0   933.0 920.0       1.0               1853.0 1222 33 104 386   19         89   933 920                 1853
257405 257405 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2018   pk_12_total 1222.0 33.0 104.0 386.0   19.0         89.0   933.0 920.0                       1853.0 1222 33 104 386   19         89   933 920                 1853
257374 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
257424 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
258346 258346 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   k_12_total 1112.0 71.0 67.0 22.0   32.0         60.0   678.0 686.0       1.0               1364.0 1112 71 67 22   32         60   678 686                 1364
258432 258432 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   pk_12_total 1112.0 71.0 67.0 22.0   32.0         60.0   678.0 686.0                       1364.0 1112 71 67 22   32         60   678 686                 1364
249926 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 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
259746 259746 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   k_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0       0.5               1211.0 1086 8 38 45   10       1 23   619 592                 1211
259762 259762 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   pk_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0                       1211.0 1086 8 38 45   10       1 23   619 592                 1211
258349 258349 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   k_12_total 847.0 97.0 78.0 28.0   27.0         41.0   555.0 563.0       3.1               1118.0 847 97 78 28   27         41   555 563                 1118
258435 258435 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   pk_12_total 847.0 97.0 78.0 28.0   27.0         41.0   555.0 563.0                       1118.0 847 97 78 28   27         41   555 563                 1118
250882 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
250896 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
258330 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 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
252348 252348 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   k_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0       0.7               1000.0 696 33 93 55   7       1 115   521 479                 1000
252358 252358 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   pk_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0                       1000.0 696 33 93 55   7       1 115   521 479                 1000
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
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
251125 251125 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   k_12_total 793.0 19.0 35.0 12.0   39.0       1.0 24.0   460.0 463.0       1.4               923.0 793 19 35 12   39       1 24   460 463                 923
251137 251137 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   pk_12_total 793.0 19.0 35.0 12.0   39.0       1.0 24.0   460.0 463.0                       923.0 793 19 35 12   39       1 24   460 463                 923
258363 258363 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   k_12_total 349.0 218.0 163.0 66.0   75.0       1.0 41.0   471.0 442.0       14.6               913.0 349 218 163 66   75       1 41   471 442                 913
258449 258449 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   pk_12_total 349.0 218.0 163.0 66.0   75.0       1.0 41.0   471.0 442.0                       913.0 349 218 163 66   75       1 41   471 442                 913
258415 258415 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   pk_12_total 694.0 68.0 68.0 8.0   17.0       1.0 49.0   447.0 458.0                       905.0 694 68 68 8   17       1 49   447 458                 905
258329 258329 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   k_12_total 685.0 67.0 65.0 8.0   16.0       1.0 48.0   438.0 452.0       9.1               890.0 685 67 65 8   16       1 48   438 452                 890
260521 260521 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   k_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0       1.6               867.0 745 10 60 38   9         5   453 414                 867
260533 260533 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pk_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0                       867.0 745 10 60 38   9         5   453 414                 867
258350 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
258335 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
258421 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
251128 251128 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   k_12_total 644.0 18.0 38.0 17.0   34.0       1.0 44.0   408.0 388.0       2.0               796.0 644 18 38 17   34       1 44   408 388                 796
251140 251140 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   pk_12_total 644.0 18.0 38.0 17.0   34.0       1.0 44.0   408.0 388.0                       796.0 644 18 38 17   34       1 44   408 388                 796
256116 256116 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   k_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0       0.9               777.0 662 8 35 38   8         26   389 388                 777
256130 256130 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   pk_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0                       777.0 662 8 35 38   8         26   389 388                 777
258422 258422 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   pk_12_total 551.0 58.0 40.0 15.0   25.0         56.0   389.0 356.0                       745.0 551 58 40 15   25         56   389 356                 745
252345 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 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
256877 256877 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   k_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0       0.8               727.0 560 2 35 90   6       1 33   365 362                 727
256887 256887 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   pk_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0                       727.0 560 2 35 90   6       1 33   365 362                 727
258424 258424 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   pk_12_total 314.0 61.0 201.0 66.0   20.0         61.0   385.0 338.0                       723.0 314 61 201 66   20         61   385 338                 723
254483 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 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
258959 258959 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   k_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0       1.4               710.0 652 7 19 8   1         23   378 332                 710
258967 258967 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   pk_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0                       710.0 652 7 19 8   1         23   378 332                 710
252346 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 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
258310 258310 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   grade_9 479.0 59.0 76.0 39.0   18.0       1.0 27.0   358.0 341.0                       699.0 479 59 76 39   18       1 27   358 341                 699
258426 258426 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2018   pk_12_total 584.0 28.0 28.0 11.0   15.0       1.0 22.0   347.0 342.0                       689.0 584 28 28 11   15       1 22   347 342                 689
256583 256583 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   pk_12_total 4.0   9.0 669.0             2.0   366.0 318.0                       684.0 4   9 669             2   366 318                 684
257357 257357 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2018   k_12_total 488.0 11.0 31.0 78.0   10.0       1.0 55.0   343.0 331.0       0.7               674.0 488 11 31 78   10       1 55   343 331                 674
257407 257407 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2018   pk_12_total 488.0 11.0 31.0 78.0   10.0       1.0 55.0   343.0 331.0                       674.0 488 11 31 78   10       1 55   343 331                 674
258340 258340 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2018   k_12_total 572.0 27.0 27.0 11.0   14.0       1.0 22.0   337.0 337.0       1.3               674.0 572 27 27 11   14       1 22   337 337                 674
257371 257371 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2018   k_12_total 397.0 5.0 58.0 165.0   3.0         44.0   343.0 329.0       0.3               672.0 397 5 58 165   3         44   343 329                 672
257421 257421 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 397.0 5.0 58.0 165.0   3.0         44.0   343.0 329.0                       672.0 397 5 58 165   3         44   343 329                 672
255799 255799 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2018   k_12_total 578.0 7.0 32.0 35.0             14.0   327.0 339.0       0.0               666.0 578 7 32 35             14   327 339                 666
255821 255821 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2018   pk_12_total 578.0 7.0 32.0 35.0             14.0   327.0 339.0                       666.0 578 7 32 35             14   327 339                 666
258338 258338 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   k_12_total 283.0 58.0 187.0 62.0   18.0         57.0   350.0 315.0       18.8               665.0 283 58 187 62   18         57   350 315                 665
250883 250883 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   k_12_total 594.0 22.0 19.0 8.0   10.0       1.0 10.0   351.0 313.0       0.9               664.0 594 22 19 8   10       1 10   351 313                 664
250897 250897 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   pk_12_total 594.0 22.0 19.0 8.0   10.0       1.0 10.0   351.0 313.0                       664.0 594 22 19 8   10       1 10   351 313                 664
257373 257373 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2018   k_12_total 554.0 5.0 35.0 31.0   15.0         20.0   329.0 331.0       0.9               660.0 554 5 35 31   15         20   329 331                 660
257423 257423 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 554.0 5.0 35.0 31.0   15.0         20.0   329.0 331.0                       660.0 554 5 35 31   15         20   329 331                 660
257330 257330 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2018   grade_9 365.0 12.0 48.0 195.0   2.0         37.0   346.0 313.0                       659.0 365 12 48 195   2         37   346 313                 659
257376 257376 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   k_12_total 515.0 5.0 56.0 35.0   6.0         39.0   353.0 303.0       0.6               656.0 515 5 56 35   6         39   353 303                 656
257426 257426 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 515.0 5.0 56.0 35.0   6.0         39.0   353.0 303.0                       656.0 515 5 56 35   6         39   353 303                 656
257880 257880 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   grade_10 480.0 36.0 75.0 28.0   22.0       0.0 15.0   354.0 302.0                       656.0 480 36 75 28   22       0 15   354 302                 656
256573 256573 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   k_12_total 4.0   8.0 639.0             2.0   349.0 304.0       0.2               653.0 4   8 639             2   349 304                 653
253933 253933 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   k_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0       1.1               648.0 580 9 19 4   15         21   335 313                 648
253951 253951 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   pk_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0                       648.0 580 9 19 4   15         21   335 313                 648
255798 255798 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   k_12_total 573.0 2.0 26.0 18.0   2.0         26.0   332.0 315.0       0.0               647.0 573 2 26 18   2         26   332 315                 647
255820 255820 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   pk_12_total 573.0 2.0 26.0 18.0   2.0         26.0   332.0 315.0                       647.0 573 2 26 18   2         26   332 315                 647
258441 258441 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   pk_12_total 523.0 12.0 73.0 4.0   2.0       1.0 30.0   311.0 334.0                       645.0 523 12 73 4   2       1 30   311 334                 645
256117 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 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
260522 260522 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   k_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0       1.6               635.0 529 9 42 36   4         15   335 300                 635
260534 260534 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pk_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0                       635.0 529 9 42 36   4         15   335 300                 635
250884 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
250898 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
256874 256874 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2018   k_12_total 458.0 5.0 31.0 79.0   2.0         56.0   318.0 313.0       0.3               631.0 458 5 31 79   2         56   318 313                 631
256884 256884 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2018   pk_12_total 458.0 5.0 31.0 79.0   2.0         56.0   318.0 313.0                       631.0 458 5 31 79   2         56   318 313                 631
259747 259747 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   k_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0       0.8               629.0 543 3 27 21   8         27   316 313                 629
259763 259763 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   pk_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0                       629.0 543 3 27 21   8         27   316 313                 629
258409 258409 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   pk_12_total 167.0 189.0 100.0 20.0   112.0         40.0   322.0 306.0                       628.0 167 189 100 20   112         40   322 306                 628
259748 259748 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   k_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0       0.3               627.0 550 5 20 32   6         14   313 314                 627
259764 259764 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   pk_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0                       627.0 550 5 20 32   6         14   313 314                 627
258786 258786 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   k_12_total 561.0 4.0 27.0 13.0   10.0         11.0   312.0 314.0       0.2               626.0 561 4 27 13   10         11   312 314                 626
258802 258802 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   pk_12_total 561.0 4.0 27.0 13.0   10.0         11.0   312.0 314.0                       626.0 561 4 27 13   10         11   312 314                 626
258339 258339 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2018   k_12_total 492.0 33.0 28.0 15.0   5.0         47.0   288.0 332.0       0.7               620.0 492 33 28 15   5         47   288 332                 620
258425 258425 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2018   pk_12_total 492.0 33.0 28.0 15.0   5.0         47.0   288.0 332.0                       620.0 492 33 28 15   5         47   288 332                 620
257375 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
257425 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
258355 258355 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   k_12_total 500.0 11.0 66.0 4.0   2.0       1.0 28.0   294.0 318.0       0.2               612.0 500 11 66 4   2       1 28   294 318                 612
258782 258782 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2018   k_12_total 537.0 6.0 32.0 18.0   6.0       1.0 12.0   310.0 302.0       1.1               612.0 537 6 32 18   6       1 12   310 302                 612

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