enrollments

Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_2" and state = "SD" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 4,696 ✖
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
457126 457126 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2021   grade_2 36.0 13.0 36.0 6.0   2.0         6.0   52.0 47.0                       99.0 36 13 36 6   2         6   52 47                 99
495547 495547 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 74.0 3.0 6.0 4.0   3.0         9.0   60.0 39.0                       99.0 74 3 6 4   3         9   60 39                 99
3014425 3014425 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2017   grade_2 45.0 18.0 13.0 10.0   5.0       0.0 8.0   53.0 46.0                       99.0 45 18 13 10   5       0 8   53 46                 99
365274 365274 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2019   grade_2 72.0 6.0 6.0 6.0   0.0         8.0   42.0 56.0                       98.0 72 6 6 6   0         8   42 56                 98
457136 457136 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2021   grade_2 64.0 18.0 7.0 5.0   0.0         4.0   55.0 43.0                       98.0 64 18 7 5   0         4   55 43                 98
493210 493210 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School Not applicable Elementary KG 04 2020   grade_2 88.0 0.0 5.0 1.0   0.0         4.0   51.0 47.0                       98.0 88 0 5 1   0         4   51 47                 98
495549 495549 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 34.0 12.0 34.0 9.0   1.0         8.0   52.0 46.0                       98.0 34 12 34 9   1         8   52 46                 98
2962594 2962594 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No 1 KG 05 2015   grade_2 94.0 0.0 1.0 1.0   1.0       0.0 1.0   48.0 50.0                       98.0 94 0 1 1   1       0 1   48 50                 98
2968777 2968777 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No 1 KG 05 2015   grade_2 76.0 1.0 5.0 6.0   0.0       0.0 10.0   50.0 48.0                       98.0 76 1 5 6   0       0 10   50 48                 98
2969705 2969705 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2015   grade_2 81.0 5.0 4.0 1.0   1.0         6.0   58.0 40.0                       98.0 81 5 4 1   1         6   58 40                 98
3012147 3012147 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2017   grade_2 88.0 0.0 3.0 2.0   0.0         5.0   56.0 42.0                       98.0 88 0 3 2   0         5   56 42                 98
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
2962174 2962174 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No 1 01 04 2015   grade_2 90.0   4.0 1.0             2.0   48.0 49.0                       97.0 90   4 1             2   48 49                 97
2968778 2968778 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No 1 KG 05 2015   grade_2 54.0 1.0 11.0 20.0   0.0       0.0 11.0   48.0 49.0                       97.0 54 1 11 20   0       0 11   48 49                 97
3013616 3013616 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2017   grade_2 69.0 0.0 7.0 11.0   4.0       1.0 5.0   57.0 40.0                       97.0 69 0 7 11   4       1 5   57 40                 97
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
495559 495559 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 60.0 6.0 5.0 10.0   4.0         11.0   46.0 50.0                       96.0 60 6 5 10   4         11   46 50                 96
2969691 2969691 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2015   grade_2 43.0 27.0 6.0 1.0   11.0         8.0   54.0 42.0                       96.0 43 27 6 1   11         8   54 42                 96
3007488 3007488 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2017   grade_2 84.0 2.0 3.0 1.0   1.0         5.0   45.0 51.0                       96.0 84 2 3 1   1         5   45 51                 96
3008310 3008310 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2017   grade_2 82.0 0.0 7.0 1.0   3.0         3.0   48.0 48.0                       96.0 82 0 7 1   3         3   48 48                 96
3350347 3350347 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No 1 KG 05 2016   grade_2 78.0 1.0 8.0 4.0   0.0       0.0 5.0   48.0 48.0                       96.0 78 1 8 4   0       0 5   48 48                 96
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
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
488357 488357 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2020   grade_2 81.0 5.0 2.0     3.0       0.0 4.0   48.0 47.0                       95.0 81 5 2     3       0 4   48 47                 95
496886 496886 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_2 71.0 2.0 2.0 15.0   2.0         3.0   51.0 44.0                       95.0 71 2 2 15   2         3   51 44                 95
3013605 3013605 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2017   grade_2 79.0 1.0 2.0 11.0   0.0       0.0 2.0   52.0 43.0                       95.0 79 1 2 11   0       0 2   52 43                 95
3014446 3014446 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2017   grade_2 82.0 1.0 4.0 1.0   1.0       0.0 6.0   54.0 41.0                       95.0 82 1 4 1   1       0 6   54 41                 95
3352283 3352283 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2016   grade_2 38.0 25.0 12.0 3.0   8.0       0.0 9.0   48.0 47.0                       95.0 38 25 12 3   8       0 9   48 47                 95
3352297 3352297 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   grade_2 79.0 5.0 4.0 2.0   2.0         3.0   40.0 55.0                       95.0 79 5 4 2   2         3   40 55                 95
366585 366585 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2019   grade_2 72.0 3.0 4.0 7.0   3.0         5.0   53.0 41.0                       94.0 72 3 4 7   3         5   53 41                 94
493213 493213 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School Not applicable Elementary KG 04 2020   grade_2 77.0 2.0 6.0 4.0   0.0         5.0   55.0 39.0                       94.0 77 2 6 4   0         5   55 39                 94
494724 494724 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School Not applicable Elementary KG 05 2020   grade_2 75.0 3.0 3.0 7.0   2.0         4.0   51.0 43.0                       94.0 75 3 3 7   2         4   51 43                 94
3007234 3007234 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2017   grade_2 88.0 1.0 2.0 2.0   1.0       0.0 0.0   54.0 40.0                       94.0 88 1 2 2   1       0 0   54 40                 94
3349722 3349722 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No 1 KG 05 2016   grade_2 81.0 2.0 8.0 0.0   1.0         2.0   53.0 41.0                       94.0 81 2 8 0   1         2   53 41                 94
3350011 3350011 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No 1 KG 06 2016   grade_2 83.0 0.0 3.0 2.0   1.0         5.0   40.0 54.0                       94.0 83 0 3 2   1         5   40 54                 94
364444 364444 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No Elementary PK 05 2019   grade_2 46.0 0.0 14.0 19.0   1.0         13.0   57.0 36.0                       93.0 46 0 14 19   1         13   57 36                 93
452930 452930 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School Not applicable Elementary PK 05 2021   grade_2 83.0 2.0 0.0 0.0   4.0       1.0 3.0   53.0 40.0                       93.0 83 2 0 0   4       1 3   53 40                 93
491353 491353 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School Not applicable Elementary KG 05 2020   grade_2 86.0 1.0 1.0 1.0   2.0       0.0 2.0   52.0 41.0                       93.0 86 1 1 1   2       0 2   52 41                 93
3352321 3352321 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No 1 KG 05 2016   grade_2 50.0 14.0 15.0 5.0   4.0       1.0 4.0   59.0 34.0                       93.0 50 14 15 5   4       1 4   59 34                 93
454787 454787 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School Not applicable Elementary KG 04 2021   grade_2 75.0 0.0 6.0 2.0   3.0         6.0   52.0 40.0                       92.0 75 0 6 2   3         6   52 40                 92
457112 457112 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   grade_2 14.0 37.0 11.0 5.0   20.0       0.0 5.0   53.0 39.0                       92.0 14 37 11 5   20       0 5   53 39                 92
458463 458463 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2021   grade_2 66.0 3.0 5.0 10.0   1.0         7.0   40.0 52.0                       92.0 66 3 5 10   1         7   40 52                 92
458787 458787 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School Not applicable Elementary KG 04 2021   grade_2 82.0 0.0 2.0 1.0   0.0         7.0   48.0 44.0                       92.0 82 0 2 1   0         7   48 44                 92
494735 494735 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School Not applicable Elementary KG 05 2020   grade_2 58.0 2.0 8.0 11.0   1.0         12.0   50.0 42.0                       92.0 58 2 8 11   1         12   50 42                 92
251901 251901 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   grade_2 77.0 1.0 5.0 0.0   6.0         2.0   43.0 48.0                       91.0 77 1 5 0   6         2   43 48                 91
358089 358089 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2019   grade_2 89.0 0.0 1.0 0.0   0.0         1.0   43.0 48.0                       91.0 89 0 1 0   0         1   43 48                 91
491354 491354 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 77.0 2.0 5.0 2.0   3.0         2.0   40.0 51.0                       91.0 77 2 5 2   3         2   40 51                 91
494728 494728 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School Not applicable Elementary PK 05 2020   grade_2 66.0 0.0 7.0 8.0   0.0       0.0 10.0   44.0 47.0                       91.0 66 0 7 8   0       0 10   44 47                 91
497206 497206 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School Not applicable Elementary KG 04 2020   grade_2 85.0   5.0 0.0   0.0         1.0   48.0 43.0                       91.0 85   5 0   0         1   48 43                 91
2968767 2968767 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No 1 KG 05 2015   grade_2 18.0 0.0 14.0 54.0   0.0         5.0   48.0 43.0                       91.0 18 0 14 54   0         5   48 43                 91
2969443 2969443 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_2     2.0 89.0             0.0   44.0 47.0                       91.0     2 89             0   44 47                 91
3007239 3007239 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2017   grade_2 86.0 1.0 3.0     0.0         1.0   48.0 43.0                       91.0 86 1 3     0         1   48 43                 91
3011858 3011858 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2017   grade_2 77.0 0.0 11.0 0.0   0.0         3.0   40.0 51.0                       91.0 77 0 11 0   0         3   40 51                 91
3016070 3016070 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2017   grade_2 82.0 1.0 4.0 1.0   0.0         3.0   48.0 43.0                       91.0 82 1 4 1   0         3   48 43                 91
3348228 3348228 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School No 1 PK 05 2016   grade_2 84.0 2.0 1.0 1.0   1.0       1.0 1.0   39.0 52.0                       91.0 84 2 1 1   1       1 1   39 52                 91
3351474 3351474 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No 1 KG 05 2016   grade_2 40.0 1.0 10.0 24.0   0.0       0.0 16.0   49.0 42.0                       91.0 40 1 10 24   0       0 16   49 42                 91
361092 361092 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No Elementary PK 05 2019   grade_2 79.0 1.0 6.0 2.0   1.0         1.0   48.0 42.0                       90.0 79 1 6 2   1         1   48 42                 90
365254 365254 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2019   grade_2 28.0 27.0 18.0 4.0   8.0         5.0   32.0 58.0                       90.0 28 27 18 4   8         5   32 58                 90
2969696 2969696 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2015   grade_2 40.0 23.0 15.0 4.0   3.0       2.0 3.0   51.0 39.0                       90.0 40 23 15 4   3       2 3   51 39                 90
3012483 3012483 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2017   grade_2 71.0 4.0 5.0 7.0   0.0         3.0   49.0 41.0                       90.0 71 4 5 7   0         3   49 41                 90
3013609 3013609 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2017   grade_2 69.0 1.0 2.0 8.0           1.0 9.0   42.0 48.0                       90.0 69 1 2 8           1 9   42 48                 90
3345162 3345162 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No 1 KG 04 2016   grade_2 82.0 3.0 0.0 1.0   1.0       1.0 2.0   48.0 42.0                       90.0 82 3 0 1   1       1 2   48 42                 90
3348222 3348222 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No 1 KG 05 2016   grade_2 79.0 2.0 2.0 1.0   3.0         3.0   51.0 39.0                       90.0 79 2 2 1   3         3   51 39                 90
3352288 3352288 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   grade_2 32.0 23.0 19.0 3.0   7.0       0.0 6.0   45.0 45.0                       90.0 32 23 19 3   7       0 6   45 45                 90
3352865 3352865 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School No 1 PK 05 2016   grade_2 18.0   13.0 47.0             12.0   49.0 41.0                       90.0 18   13 47             12   49 41                 90
254178 254178 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No Elementary KG 06 2018   grade_2 9.0   0.0 0.0                 5.0 4.0                       9.0 9   0 0                 5 4                 9
254297 254297 SD     school 4634600 53002   Hoven 53-2 463460000297 2 Hoven Elementary   Regular School No Elementary PK 06 2018   grade_2 9.0     0.0                 5.0 4.0                       9.0 9     0                 5 4                 9
255577 255577 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No Elementary PK 06 2018   grade_2 7.0 0.0 0.0 2.0             0.0   3.0 6.0                       9.0 7 0 0 2             0   3 6                 9
258649 258649 SD     school 4607670 26005   South Central 26-5 460767000882 3 South Central Elementary   Regular School No Elementary PK 05 2018   grade_2 5.0   1.0 3.0                 6.0 3.0                       9.0 5   1 3                 6 3                 9
358020 358020 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School No Elementary PK 06 2019   grade_2 8.0   1.0               0.0   5.0 4.0                       9.0 8   1               0   5 4                 9
359728 359728 SD     school 4620850 23001   Edgemont 23-1 462085000181 3 Edgemont Elementary   Regular School No Elementary KG 08 2019   grade_2 9.0   0.0 0.0             0.0   6.0 3.0                       9.0 9   0 0             0   6 3                 9
362016 362016 SD     school 4680437 35002   Kadoka Area 35-2 468043701245 9 Interior Elementary   Regular School No Elementary KG 08 2019   grade_2 4.0   0.0 5.0                 5.0 4.0                       9.0 4   0 5                 5 4                 9
362938 362938 SD     school 4669930 46001   Meade 46-1 466993000736 9 Enning/Union Center Elem   Regular School No Elementary KG 08 2019   grade_2 8.0                   1.0   6.0 3.0                       9.0 8                   1   6 3                 9
363673 363673 SD     school 4651750 56007   Northwestern Area 56-7 465175000820 4 Northwestern Elementary   Regular School No Elementary PK 05 2019   grade_2 9.0 0.0 0.0 0.0             0.0   6.0 3.0                       9.0 9 0 0 0             0   6 3                 9
363868 363868 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701030 2 Oldham-Ramona Elementary   Regular School No Elementary PK 06 2019   grade_2 9.0   0.0               0.0   5.0 4.0                       9.0 9   0               0   5 4                 9
365900 365900 SD     school 4607670 26005   South Central 26-5 460767000882 3 South Central Elementary   Regular School No Elementary PK 05 2019   grade_2 6.0     3.0                 5.0 4.0                       9.0 6     3                 5 4                 9
367332 367332 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2019   grade_2 8.0 0.0 0.0             1.0     6.0 3.0                       9.0 8 0 0             1     6 3                 9
449086 449086 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary PK 04 2021   grade_2 5.0   1.0 1.0             2.0   3.0 6.0                       9.0 5   1 1             2   3 6                 9
449763 449763 SD     school 4607400 4002   Bon Homme 04-2 460740000061 3 Springfield Elementary   Regular School Not applicable Elementary KG 05 2021   grade_2 9.0   0.0 0.0             0.0   1.0 8.0                       9.0 9   0 0             0   1 8                 9
451308 451308 SD     school 4619170 56002   Doland 56-2 461917000170 3 Doland Elementary   Regular School Not applicable Elementary PK 06 2021   grade_2 7.0   2.0                   5.0 4.0                       9.0 7   2                   5 4                 9
453098 453098 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School Not applicable Elementary KG 05 2021   grade_2 7.0   1.0 1.0             0.0   5.0 4.0                       9.0 7   1 1             0   5 4                 9
453251 453251 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School Not applicable Elementary KG 06 2021   grade_2 9.0                       4.0 5.0                       9.0 9                       4 5                 9
458388 458388 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School Not applicable Elementary PK 06 2021   grade_2 9.0   0.0 0.0             0.0   7.0 2.0                       9.0 9   0 0             0   7 2                 9
459294 459294 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School Not applicable Elementary KG 05 2021   grade_2       9.0                 5.0 4.0                       9.0       9                 5 4                 9
488113 488113 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School Not applicable Elementary KG 06 2020   grade_2 8.0   0.0 0.0   0.0         1.0   4.0 5.0                       9.0 8   0 0   0         1   4 5                 9
488186 488186 SD     school 4607400 4002   Bon Homme 04-2 460740000061 3 Springfield Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 7.0   0.0 1.0             1.0   3.0 6.0                       9.0 7   0 1             1   3 6                 9
491521 491521 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School Not applicable Elementary KG 05 2020   grade_2 8.0   1.0 0.0             0.0   6.0 3.0                       9.0 8   1 0             0   6 3                 9
491793 491793 SD     school 4634600 53002   Hoven 53-2 463460000297 2 Hoven Elementary   Regular School Not applicable Elementary PK 06 2020   grade_2 9.0                       6.0 3.0                       9.0 9                       6 3                 9
497313 497313 SD     school 4676680 18003   Waubay 18-3 467668000719 2 Waubay Elem   Regular School Not applicable Elementary PK 05 2020   grade_2 7.0     1.0             1.0   7.0 2.0                       9.0 7     1             1   7 2                 9
2965947 2965947 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No 1 KG 06 2015   grade_2 8.0     1.0                 7.0 2.0                       9.0 8     1                 7 2                 9
2966726 2966726 SD     school 4640860 45005   Langford Area 464086000369 2 Langford Area Elem   Regular School No 1 PK 05 2015   grade_2 7.0   1.0 0.0             1.0   5.0 4.0                       9.0 7   1 0             1   5 4                 9
2969270 2969270 SD     school 4603932 55005   Sanborn Central 55-5 460393201162 6 Sanborn Central Elementary   Regular School No 1 PK 05 2015   grade_2 9.0   0.0 0.0             0.0   6.0 3.0                       9.0 9   0 0             0   6 3                 9
2971842 2971842 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No 1 PK 06 2015   grade_2 8.0   1.0                   6.0 3.0                       9.0 8   1                   6 3                 9
3006407 3006407 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2017   grade_2 8.0   0.0 0.0   0.0         1.0   6.0 3.0                       9.0 8   0 0   0         1   6 3                 9
3008134 3008134 SD     school 4614130 59003   Colome Consolidated 461413000140 2 Colome Elementary School   Regular School No Elementary PK 05 2017   grade_2 6.0     3.0   0.0         0.0   1.0 8.0                       9.0 6     3   0         0   1 8                 9
3009306 3009306 SD     school 4622940 46002   Faith 46-2 462294000805 2 Faith Elementary School   Regular School No Elementary KG 06 2017   grade_2 8.0   0.0 1.0   0.0             6.0 3.0                       9.0 8   0 1   0             6 3                 9
3016593 3016593 SD     school 4679350 12003   Willow Lake 12-3 467935000755 2 Willow Lake Elem   Regular School No Elementary PK 05 2017   grade_2 8.0   1.0 0.0                 3.0 6.0                       9.0 8   1 0                 3 6                 9
3344886 3344886 SD     school 4606960 25001   Big Stone City 25-1 460696000053 1 Big Stone City Elementary   Regular School No 1 PK 05 2016   grade_2 6.0 0.0 1.0 1.0   1.0             4.0 5.0                       9.0 6 0 1 1   1             4 5                 9
3345835 3345835 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No 1 KG 08 2016   grade_2 9.0                       8.0 1.0                       9.0 9                       8 1                 9

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