enrollments

Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
3351454 3351454 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2016   grade_12 275.0 5.0 9.0 21.0   1.0       0.0 4.0   147.0 168.0                       315.0 275 5 9 21   1       0 4   147 168                 315
3351502 3351502 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2016   grade_3 29.0 1.0 9.0 24.0   0.0         4.0   33.0 34.0                       67.0 29 1 9 24   0         4   33 34                 67
3351507 3351507 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No 1 KG 05 2016   grade_3 42.0 0.0 9.0 17.0   0.0         7.0   30.0 45.0                       75.0 42 0 9 17   0         7   30 45                 75
3351539 3351539 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No 1 KG 05 2016   grade_5 55.0 1.0 9.0 12.0   0.0       1.0 3.0   47.0 34.0                       81.0 55 1 9 12   0       1 3   47 34                 81
3351550 3351550 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No 1 KG 05 2016   grade_5 28.0 1.0 9.0 5.0   1.0         3.0   29.0 18.0                       47.0 28 1 9 5   1         3   29 18                 47
3351631 3351631 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No 2 06 08 2016   grade_8 187.0 3.0 9.0 25.0   3.0         6.0   119.0 114.0                       233.0 187 3 9 25   3         6   119 114                 233
3351699 3351699 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No 1 KG 05 2016   kindergarten 39.0 0.0 9.0 24.0   0.0       0.0 8.0   43.0 37.0                       80.0 39 0 9 24   0       0 8   43 37                 80
3351702 3351702 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2016   kindergarten 18.0 1.0 9.0 10.0   2.0         8.0   25.0 23.0                       48.0 18 1 9 10   2         8   25 23                 48
3352223 3352223 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No 3 09 12 2016   grade_11 57.0 1.0 9.0 6.0   1.0         0.0   47.0 27.0                       74.0 57 1 9 6   1         0   47 27                 74
3352295 3352295 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   grade_2 35.0 10.0 9.0 3.0   0.0       0.0 12.0   37.0 32.0                       69.0 35 10 9 3   0       0 12   37 32                 69
3352317 3352317 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2016   grade_2 61.0 2.0 9.0 0.0   0.0       0.0 3.0   36.0 39.0                       75.0 61 2 9 0   0       0 3   36 39                 75
3352326 3352326 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2016   grade_3 33.0 28.0 9.0 1.0   11.0       0.0 8.0   49.0 41.0                       90.0 33 28 9 1   11       0 8   49 41                 90
3352335 3352335 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No 1 KG 05 2016   grade_3 0.0 9.0 9.0     5.0             11.0 12.0                       23.0 0 9 9     5             11 12                 23
3352359 3352359 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No 1 KG 05 2016   grade_3 37.0 5.0 9.0 2.0   1.0         2.0   34.0 22.0                       56.0 37 5 9 2   1         2   34 22                 56
3352374 3352374 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   grade_4 39.0 15.0 9.0 2.0   7.0       0.0 4.0   37.0 39.0                       76.0 39 15 9 2   7       0 4   37 39                 76
3352403 3352403 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2016   grade_4 49.0 2.0 9.0 0.0   0.0       0.0 2.0   33.0 29.0                       62.0 49 2 9 0   0       0 2   33 29                 62
3352427 3352427 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   grade_5 13.0 14.0 9.0 16.0   6.0       0.0 4.0   37.0 25.0                       62.0 13 14 9 16   6       0 4   37 25                 62
3352685 3352685 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   kindergarten 19.0 10.0 9.0 8.0   7.0       0.0 8.0   33.0 28.0                       61.0 19 10 9 8   7       0 8   33 28                 61
3352901 3352901 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School No 1 PK 05 2016   kindergarten 15.0   9.0 45.0             12.0   41.0 40.0                       81.0 15   9 45             12   41 40                 81
3353076 3353076 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No 2 06 08 2016   grade_6 162.0 1.0 9.0 11.0   1.0       1.0 4.0   93.0 96.0                       189.0 162 1 9 11   1       1 4   93 96                 189
3353099 3353099 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2016   grade_9 156.0 0.0 9.0 5.0   4.0         2.0   94.0 82.0                       176.0 156 0 9 5   4         2   94 82                 176
3353292 3353292 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No 3 09 12 2016   k_12_total 379.0 5.0 9.0 7.0   1.0         9.0   203.0 207.0       0.0               410.0 379 5 9 7   1         9   203 207                 410
3353302 3353302 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No 3 09 12 2016   pk_12_total 379.0 5.0 9.0 7.0   1.0         9.0   203.0 207.0                       410.0 379 5 9 7   1         9   203 207                 410
3354013 3354013 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No 2 07 08 2016   grade_7 270.0 5.0 9.0 15.0   2.0         3.0   156.0 148.0                       304.0 270 5 9 15   2         3   156 148                 304
3354759 3354759 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No 1 KG 05 2016   grade_2 51.0 0.0 9.0 5.0   0.0         1.0   32.0 34.0                       66.0 51 0 9 5   0         1   32 34                 66
3354787 3354787 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No 2 06 08 2016   grade_6 169.0 5.0 9.0 12.0   3.0         2.0   105.0 95.0                       200.0 169 5 9 12   3         2   105 95                 200
3354793 3354793 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No 2 06 08 2016   grade_7 149.0 2.0 9.0 12.0   0.0         0.0   90.0 82.0                       172.0 149 2 9 12   0         0   90 82                 172
365586 365586 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2019   k_12_total 125.0 171.0 89.0 27.0   90.0       1.0 37.0   275.0 265.0       45.2               540.0 125 171 89 27   90       1 37   275 265                 540
457375 457375 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2021   grade_8 101.0 62.0 89.0 19.0   5.0       0.0 24.0   151.0 149.0                       300.0 101 62 89 19   5       0 24   151 149                 300
457469 457469 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 1088.0 89.0 89.0 25.0   15.0       3.0 80.0   669.0 720.0       2.7               1389.0 1088 89 89 25   15       3 80   669 720                 1389
457553 457553 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 1088.0 89.0 89.0 25.0   15.0       3.0 80.0   669.0 720.0                       1389.0 1088 89 89 25   15       3 80   669 720                 1389
2970092 2970092 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No 1 PK 05 2015   k_12_total 147.0 102.0 89.0 65.0   27.0       1.0 32.0   264.0 199.0       29.2               463.0 147 102 89 65   27       1 32   264 199                 463
3352728 3352728 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   pk_12_total 144.0 120.0 89.0 62.0   33.0       2.0 50.0   267.0 233.0                       500.0 144 120 89 62   33       2 50   267 233                 500
365430 365430 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2019   grade_6 116.0 64.0 88.0 24.0   7.0       0.0 30.0   168.0 161.0                       329.0 116 64 88 24   7       0 30   168 161                 329
365604 365604 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2019   k_12_total 116.0 59.0 88.0 19.0   15.0         25.0   165.0 157.0       30.1               322.0 116 59 88 19   15         25   165 157                 322
495986 495986 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 564.0 16.0 88.0 3.0   1.0         28.0   341.0 359.0                       700.0 564 16 88 3   1         28   341 359                 700
2968964 2968964 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   k_12_total 1286.0 31.0 88.0 396.0   29.0         63.0   968.0 925.0       0.9               1893.0 1286 31 88 396   29         63   968 925                 1893
2969014 2969014 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   pk_12_total 1286.0 31.0 88.0 396.0   29.0         63.0   968.0 925.0                       1893.0 1286 31 88 396   29         63   968 925                 1893
2970156 2970156 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2015   pk_12_total 166.0 138.0 88.0 76.0   35.0       3.0 45.0   315.0 236.0                       551.0 166 138 88 76   35       3 45   315 236                 551
3014848 3014848 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2017   pk_12_total 158.0 103.0 88.0 61.0   11.0         53.0   254.0 220.0                       474.0 158 103 88 61   11         53   254 220                 474
3348813 3348813 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No 2 06 08 2016   k_12_total 293.0 11.0 88.0 10.0   119.0         1.0   265.0 257.0                       522.0 293 11 88 10   119         1   265 257                 522
3348823 3348823 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No 2 06 08 2016   pk_12_total 293.0 11.0 88.0 10.0   119.0         1.0   265.0 257.0                       522.0 293 11 88 10   119         1   265 257                 522
258323 258323 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   k_12_total 152.0 163.0 87.0 14.0   92.0         37.0   279.0 266.0       41.8               545.0 152 163 87 14   92         37   279 266                 545
258354 258354 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2018   k_12_total 291.0 101.0 87.0 17.0   31.0         42.0   289.0 280.0       24.3               569.0 291 101 87 17   31         42   289 280                 569
258440 258440 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2018   pk_12_total 291.0 101.0 87.0 17.0   31.0         42.0   289.0 280.0                       569.0 291 101 87 17   31         42   289 280                 569
457458 457458 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 180.0 103.0 87.0 47.0   13.0         55.0   259.0 226.0       25.6               485.0 180 103 87 47   13         55   259 226                 485
457532 457532 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 99.0 217.0 87.0 19.0   126.0       1.0 44.0   309.0 284.0                       593.0 99 217 87 19   126       1 44   309 284                 593
495447 495447 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 109.0 86.0 15.0   30.0       1.0 17.0   260.0 261.0                       521.0 263 109 86 15   30       1 17   260 261                 521
495975 495975 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 162.0 57.0 86.0 59.0   4.0       1.0 62.0   212.0 219.0                       431.0 162 57 86 59   4       1 62   212 219                 431
254488 254488 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   kindergarten 82.0 1.0 85.0 2.0   60.0       0.0 8.0   131.0 107.0                       238.0 82 1 85 2   60       0 8   131 107                 238
487454 487454 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   k_12_total 1081.0 30.0 85.0 79.0   46.0       2.0 26.0   671.0 678.0       2.8               1349.0 1081 30 85 79   46       2 26   671 678                 1349
487474 487474 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   pk_12_total 1081.0 30.0 85.0 79.0   46.0       2.0 26.0   671.0 678.0                       1349.0 1081 30 85 79   46       2 26   671 678                 1349
495881 495881 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 177.0 121.0 85.0 46.0   15.0         53.0   254.0 243.0       26.0               497.0 177 121 85 46   15         53   254 243                 497
3352718 3352718 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   pk_12_total 242.0 145.0 85.0 21.0   59.0       2.0 34.0   307.0 281.0                       588.0 242 145 85 21   59       2 34   307 281                 588
457455 457455 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2021   k_12_total 5.0 25.0 84.0     2.0       1.0     65.0 52.0       99.2               117.0 5 25 84     2       1     65 52                 117
457539 457539 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2021   pk_12_total 5.0 25.0 84.0     2.0       1.0     65.0 52.0                       117.0 5 25 84     2       1     65 52                 117
495902 495902 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 539.0 15.0 84.0 3.0   1.0         25.0   328.0 339.0       0.0               667.0 539 15 84 3   1         25   328 339                 667
495958 495958 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 169.0 224.0 84.0 28.0   42.0       1.0 43.0   304.0 287.0                       591.0 169 224 84 28   42       1 43   304 287                 591
2970141 2970141 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2015   pk_12_total 281.0 191.0 84.0 26.0   64.0         52.0   364.0 334.0                       698.0 281 191 84 26   64         52   364 334                 698
365701 365701 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   pk_12_total 557.0 15.0 83.0 3.0   1.0         30.0   337.0 352.0                       689.0 557 15 83 3   1         30   337 352                 689
495871 495871 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 100.0 181.0 83.0 26.0   92.0         37.0   265.0 254.0       47.2               519.0 100 181 83 26   92         37   265 254                 519
2970146 2970146 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2015   pk_12_total 277.0 150.0 83.0 22.0   52.0       2.0 24.0   312.0 298.0                       610.0 277 150 83 22   52       2 24   312 298                 610
3013796 3013796 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   k_12_total 1274.0 37.0 83.0 371.0   20.0         86.0   969.0 902.0       0.9               1871.0 1274 37 83 371   20         86   969 902                 1871
3013846 3013846 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   pk_12_total 1274.0 37.0 83.0 371.0   20.0         86.0   969.0 902.0                       1871.0 1274 37 83 371   20         86   969 902                 1871
258420 258420 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   pk_12_total 249.0 136.0 82.0 43.0   19.0       1.0 50.0   306.0 274.0                       580.0 249 136 82 43   19       1 50   306 274                 580
491984 491984 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   kindergarten 83.0 3.0 82.0 2.0   52.0       3.0 11.0   107.0 129.0                       236.0 83 3 82 2   52       3 11   107 129                 236
3013815 3013815 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   k_12_total 1356.0 10.0 82.0 89.0   20.0         43.0   815.0 785.0       1.0               1600.0 1356 10 82 89   20         43   815 785                 1600
3013865 3013865 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   pk_12_total 1356.0 10.0 82.0 89.0   20.0         43.0   815.0 785.0                       1600.0 1356 10 82 89   20         43   815 785                 1600
3014751 3014751 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2017   k_12_total 185.0 158.0 82.0 22.0   85.0         42.0   296.0 278.0       33.8               574.0 185 158 82 22   85         42   296 278                 574
365622 365622 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2019   k_12_total 264.0 69.0 81.0 12.0   17.0       3.0 33.0   261.0 218.0       20.9               479.0 264 69 81 12   17       3 33   261 218                 479
365706 365706 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2019   pk_12_total 264.0 69.0 81.0 12.0   17.0       3.0 33.0   261.0 218.0                       479.0 264 69 81 12   17       3 33   261 218                 479
457448 457448 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 90.0 185.0 81.0 18.0   102.0       0.0 35.0   258.0 253.0       50.5               511.0 90 185 81 18   102       0 35   258 253                 511
494968 494968 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School Not applicable Elementary PK 05 2020   pk_12_total 83.0 7.0 81.0 264.0   5.0         79.0   265.0 254.0                       519.0 83 7 81 264   5         79   265 254                 519
495907 495907 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0       19.7               509.0 280 79 81 14   19       4 32   283 226                 509
495991 495991 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0                       509.0 280 79 81 14   19       4 32   283 226                 509
365611 365611 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2019   k_12_total 849.0 93.0 80.0 30.0   22.0         54.0   565.0 563.0       2.5               1128.0 849 93 80 30   22         54   565 563                 1128
365617 365617 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   k_12_total 526.0 15.0 80.0 3.0   1.0         29.0   324.0 330.0       0.0               654.0 526 15 80 3   1         29   324 330                 654
365695 365695 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2019   pk_12_total 849.0 93.0 80.0 30.0   22.0         54.0   565.0 563.0                       1128.0 849 93 80 30   22         54   565 563                 1128
453470 453470 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2021   grade_1 79.0 4.0 80.0 2.0   54.0       2.0 11.0   105.0 127.0                       232.0 79 4 80 2   54       2 11   105 127                 232
456518 456518 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School Not applicable Middle 06 08 2021   k_12_total 117.0 4.0 80.0 245.0   7.0         78.0   267.0 264.0       1.9               531.0 117 4 80 245   7         78   267 264                 531
456568 456568 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School Not applicable Middle 06 08 2021   pk_12_total 117.0 4.0 80.0 245.0   7.0         78.0   267.0 264.0                       531.0 117 4 80 245   7         78   267 264                 531
495438 495438 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2020   grade_10 454.0 57.0 80.0 24.0   16.0       0.0 27.0   363.0 295.0                       658.0 454 57 80 24   16       0 27   363 295                 658
250137 250137 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   k_12_total 34.0   8.0 93.0             21.0   72.0 84.0       0.0               156.0 34   8 93             21   72 84                 156
250147 250147 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   pk_12_total 46.0   8.0 110.0             26.0   93.0 97.0                       190.0 46   8 110             26   93 97                 190
250423 250423 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No Middle 05 08 2018   grade_6 99.0   8.0 2.0             6.0   62.0 53.0                       115.0 99   8 2             6   62 53                 115
250545 250545 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2018   k_12_total 269.0 2.0 8.0 1.0   1.0         2.0   138.0 145.0       0.0               283.0 269 2 8 1   1         2   138 145                 283
250546 250546 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   k_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0       0.0               218.0 199 2 8     4         5   106 112                 218
250551 250551 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2018   pk_12_total 269.0 2.0 8.0 1.0   1.0         2.0   138.0 145.0                       283.0 269 2 8 1   1         2   138 145                 283
250552 250552 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   pk_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0                       218.0 199 2 8     4         5   106 112                 218
250863 250863 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   grade_7 297.0 13.0 8.0 1.0   1.0       1.0 7.0   159.0 169.0                       328.0 297 13 8 1   1       1 7   159 169                 328
250895 250895 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   pk_12_total 523.0 11.0 8.0 6.0   2.0       3.0 21.0   317.0 257.0                       574.0 523 11 8 6   2       3 21   317 257                 574
251029 251029 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   k_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0       0.0               214.0 191 4 8 2   1         8   103 111                 214
251041 251041 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0                       214.0 191 4 8 2   1         8   103 111                 214
251082 251082 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2018   grade_2 61.0 3.0 8.0 4.0   1.0         3.0   43.0 37.0                       80.0 61 3 8 4   1         3   43 37                 80
251872 251872 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   k_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0       0.0               204.0 166   8 13           1 16   98 106                 204
251880 251880 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   pk_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0                       204.0 166   8 13           1 16   98 106                 204
251916 251916 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   grade_5 92.0 0.0 8.0 1.0   1.0         7.0   50.0 59.0                       109.0 92 0 8 1   1         7   50 59                 109
251930 251930 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   grade_9 71.0 5.0 8.0 2.0   3.0       0.0 2.0   52.0 39.0                       91.0 71 5 8 2   3       0 2   52 39                 91
251937 251937 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   kindergarten 94.0 1.0 8.0 0.0   5.0         4.0   67.0 45.0                       112.0 94 1 8 0   5         4   67 45                 112
252115 252115 SD     school 4678300 5006   Deubrook Area 05-6 467830000559 3 Deubrook Elementary   Regular School No Elementary PK 06 2018   pk_12_total 163.0 1.0 8.0 2.0                 86.0 88.0                       174.0 163 1 8 2                 86 88                 174

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