Data source: Big Local News · About: Big Local

4,696 rows where grade = "pre_kindergarten" and state = "SD" sorted by black descending

View and edit SQL

year

grade

  • pre_kindergarten · 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
365740 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 10.0 9.0 4.0 2.0   0.0         0.0   8.0 17.0                       25.0 10 9 4 2   0         0   8 17                 25
457602 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 12.0 9.0 2.0 0.0   2.0       1.0 0.0   10.0 16.0                       26.0 12 9 2 0   2       1 0   10 16                 26
496014 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 20.0 9.0 21.0 5.0   2.0         3.0   30.0 30.0                       60.0 20 9 21 5   2         3   30 30                 60
457591 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 19.0 8.0 16.0 3.0   4.0         1.0   24.0 27.0                       51.0 19 8 16 3   4         1   24 27                 51
258481 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 10.0 7.0 7.0 3.0   2.0       0.0 2.0   16.0 15.0                       31.0 10 7 7 3   2       0 2   16 15                 31
2970218 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 27.0 7.0 9.0 2.0   0.0         3.0   24.0 24.0                       48.0 27 7 9 2   0         3   24 24                 48
496017 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 24.0 6.0 9.0 10.0   0.0       0.0 5.0   30.0 24.0                       54.0 24 6 9 10   0       0 5   30 24                 54
496025 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 13.0 6.0 9.0 1.0   3.0         1.0   15.0 18.0                       33.0 13 6 9 1   3         1   15 18                 33
260538 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   pre_kindergarten 129.0 5.0 10.0 3.0   3.0         9.0   82.0 77.0                       159.0 129 5 10 3   3         9   82 77                 159
2970202 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 70.0 5.0 31.0 9.0   1.0         9.0   74.0 51.0                       125.0 70 5 31 9   1         9   74 51                 125
3352756 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 22.0 45.0 27.0 7.0   10.0       1.0 8.0   67.0 53.0                       120.0 22 45 27 7   10       1 8   67 53                 120
2970186 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 35.0 43.0 14.0 4.0   11.0         18.0   70.0 55.0                       125.0 35 43 14 4   11         18   70 55                 125
365716 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 20.0 41.0 12.0 7.0   10.0         5.0   52.0 43.0                       95.0 20 41 12 7   10         5   52 43                 95
496000 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 25.0 40.0 9.0 4.0   4.0       0.0 5.0   51.0 36.0                       87.0 25 40 9 4   4       0 5   51 36                 87
457588 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 36.0 4.0 20.0 3.0   1.0         3.0   28.0 39.0                       67.0 36 4 20 3   1         3   28 39                 67
496011 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 26.0 4.0 18.0 1.0   3.0         3.0   28.0 27.0                       55.0 26 4 18 1   3         3   28 27                 55
3014891 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 25.0 4.0 15.0 6.0   1.0         2.0   31.0 22.0                       53.0 25 4 15 6   1         2   31 22                 53
365726 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 48.0 38.0 16.0 21.0   2.0       1.0 21.0   83.0 64.0                       147.0 48 38 16 21   2       1 21   83 64                 147
496009 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 61.0 37.0 11.0 6.0   2.0         16.0   71.0 62.0                       133.0 61 37 11 6   2         16   71 62                 133
457577 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 16.0 35.0 10.0 3.0   7.0       0.0 5.0   43.0 33.0                       76.0 16 35 10 3   7       0 5   43 33                 76
457586 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 51.0 35.0 16.0 7.0   4.0         14.0   75.0 52.0                       127.0 51 35 16 7   4         14   75 52                 127
258456 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 21.0 33.0 5.0 5.0   16.0       0.0 6.0   49.0 37.0                       86.0 21 33 5 5   16       0 6   49 37                 86
457574 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 9.0 32.0 6.0 1.0   24.0       1.0 9.0   51.0 31.0                       82.0 9 32 6 1   24       1 9   51 31                 82
3014889 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 81.0 32.0 18.0 7.0   7.0         17.0   101.0 61.0                       162.0 81 32 18 7   7         17   101 61                 162
258466 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 59.0 31.0 12.0 15.0   7.0         11.0   77.0 58.0                       135.0 59 31 12 15   7         11   77 58                 135
258467 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 31.0 3.0 14.0 4.0   2.0         4.0   35.0 23.0                       58.0 31 3 14 4   2         4   35 23                 58
365727 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 26.0 3.0 17.0 1.0   2.0         5.0   32.0 22.0                       54.0 26 3 17 1   2         5   32 22                 54
367797 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2019   pre_kindergarten 150.0 3.0 16.0 9.0   5.0         2.0   83.0 102.0                       185.0 150 3 16 9   5         2   83 102                 185
457600 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 56.0 28.0 23.0 12.0   3.0       1.0 15.0   79.0 59.0                       138.0 56 28 23 12   3       1 15   79 59                 138
2970200 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 70.0 28.0 18.0 12.0   5.0         21.0   89.0 65.0                       154.0 70 28 18 12   5         21   89 65                 154
3352770 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 80.0 28.0 14.0 7.0   5.0         18.0   82.0 70.0                       152.0 80 28 14 7   5         18   82 70                 152
365712 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 12.0 27.0 16.0 2.0   24.0       0.0 4.0   43.0 42.0                       85.0 12 27 16 2   24       0 4   43 42                 85
457587 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 36.0 27.0 18.0 8.0   2.0       1.0 9.0   62.0 39.0                       101.0 36 27 18 8   2       1 9   62 39                 101
3352761 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 21.0 27.0 13.0 6.0   17.0       0.0 4.0   39.0 49.0                       88.0 21 27 13 6   17       0 4   39 49                 88
258452 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 15.0 26.0 13.0 6.0   20.0         3.0   43.0 40.0                       83.0 15 26 13 6   20         3   43 40                 83
365723 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 25.0 26.0 5.0 3.0   3.0       1.0 3.0   36.0 30.0                       66.0 25 26 5 3   3       1 3   36 30                 66
365725 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 90.0 26.0 18.0 9.0   5.0         17.0   91.0 74.0                       165.0 90 26 18 9   5         17   91 74                 165
495997 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 9.0 26.0 9.0 2.0   25.0         6.0   41.0 36.0                       77.0 9 26 9 2   25         6   41 36                 77
3014877 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 14.0 26.0 24.0 9.0   15.0         5.0   45.0 48.0                       93.0 14 26 24 9   15         5   45 48                 93
3014880 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 21.0 26.0 11.0 5.0   11.0       1.0 6.0   41.0 40.0                       81.0 21 26 11 5   11       1 6   41 40                 81
3014890 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 49.0 26.0 15.0 10.0   4.0         16.0   68.0 52.0                       120.0 49 26 15 10   4         16   68 52                 120
258463 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 23.0 25.0 3.0 2.0   3.0       0.0 7.0   38.0 25.0                       63.0 23 25 3 2   3       0 7   38 25                 63
258465 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 73.0 25.0 21.0 7.0   8.0         19.0   94.0 59.0                       153.0 73 25 21 7   8         19   94 59                 153
496023 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 53.0 25.0 24.0 9.0   2.0       0.0 17.0   81.0 49.0                       130.0 53 25 24 9   2       0 17   81 49                 130
2970191 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 26.0 25.0 9.0 1.0   18.0       0.0 5.0   42.0 42.0                       84.0 26 25 9 1   18       0 5   42 42                 84
496007 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 18.0 23.0 9.0 6.0   2.0         5.0   35.0 28.0                       63.0 18 23 9 6   2         5   35 28                 63
2970227 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 29.0 22.0 23.0 8.0   2.0       0.0 11.0   53.0 42.0                       95.0 29 22 23 8   2       0 11   53 42                 95
496010 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 43.0 21.0 19.0 12.0   3.0       0.0 12.0   63.0 47.0                       110.0 43 21 19 12   3       0 12   63 47                 110
2970201 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 45.0 21.0 11.0 12.0   9.0       1.0 12.0   65.0 46.0                       111.0 45 21 11 12   9       1 12   65 46                 111
258479 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 68.0 20.0 14.0 10.0   1.0       0.0 11.0   74.0 50.0                       124.0 68 20 14 10   1       0 11   74 50                 124
258490 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 31.0 20.0 25.0 6.0   6.0         7.0   47.0 48.0                       95.0 31 20 25 6   6         7   47 48                 95
365738 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 55.0 20.0 21.0 10.0   1.0       0.0 14.0   67.0 54.0                       121.0 55 20 21 10   1       0 14   67 54                 121
3014887 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 18.0 20.0 7.0 9.0   0.0       0.0 4.0   31.0 27.0                       58.0 18 20 7 9   0       0 4   31 27                 58
257433 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2018   pre_kindergarten 25.0 2.0 9.0 15.0   3.0       0.0 5.0   35.0 24.0                       59.0 25 2 9 15   3       0 5   35 24                 59
260314 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2018   pre_kindergarten 13.0 2.0 0.0 1.0             0.0   9.0 7.0                       16.0 13 2 0 1             0   9 7                 16
361184 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 12.0 2.0 0.0 0.0   0.0         1.0   8.0 7.0                       15.0 12 2 0 0   0         1   8 7                 15
364708 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2019   pre_kindergarten 22.0 2.0 15.0 12.0   0.0         6.0   32.0 25.0                       57.0 22 2 15 12   0         6   32 25                 57
450007 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2021   pre_kindergarten 25.0 2.0 2.0 3.0   0.0       0.0 7.0   26.0 13.0                       39.0 25 2 2 3   0       0 7   26 13                 39
450664 SD     school 4612300 39001   Chester Area 39-1 461230000131 2 Chester Area Elementary School   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 35.0 2.0 0.0               0.0   19.0 18.0                       37.0 35 2 0               0   19 18                 37
453029 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 9.0 2.0 0.0 1.0   3.0       0.0 0.0   10.0 5.0                       15.0 9 2 0 1   3       0 0   10 5                 15
456651 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 0.0 2.0 3.0 0.0             30.0   18.0 20.0                       38.0 0 2 3 0             30   18 20                 38
488430 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   pre_kindergarten 25.0 2.0 3.0 2.0   0.0       0.0 5.0   23.0 14.0                       37.0 25 2 3 2   0       0 5   23 14                 37
491453 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 12.0 2.0 1.0 0.0   1.0         0.0   10.0 6.0                       16.0 12 2 1 0   1         0   10 6                 16
2969053 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No 1 KG 05 2015   pre_kindergarten 7.0 2.0 1.0 2.0   0.0       0.0 2.0   7.0 7.0                       14.0 7 2 1 2   0       0 2   7 7                 14
2970786 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 KG 02 2015   pre_kindergarten 22.0 2.0 1.0 0.0   0.0       0.0 1.0   22.0 4.0                       26.0 22 2 1 0   0       0 1   22 4                 26
3016931 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2017   pre_kindergarten 82.0 2.0 6.0 2.0   2.0         4.0   49.0 49.0                       98.0 82 2 6 2   2         4   49 49                 98
3352772 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 34.0 2.0 13.0 4.0   2.0       0.0 5.0   34.0 26.0                       60.0 34 2 13 4   2       0 5   34 26                 60
457584 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 25.0 19.0 8.0 4.0   1.0         5.0   34.0 28.0                       62.0 25 19 8 4   1         5   34 28                 62
3014915 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 37.0 19.0 17.0 9.0   4.0         3.0   46.0 43.0                       89.0 37 19 17 9   4         3   46 43                 89
3352768 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 27.0 19.0 2.0 2.0   4.0       1.0 4.0   33.0 26.0                       59.0 27 19 2 2   4       1 4   33 26                 59
457611 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 23.0 18.0 8.0 5.0   4.0         9.0   34.0 33.0                       67.0 23 18 8 5   4         9   34 33                 67
258473 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 28.0 17.0 4.0 4.0   2.0         0.0   25.0 30.0                       55.0 28 17 4 4   2         0   25 30                 55
3014897 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 23.0 17.0 7.0 4.0   2.0         2.0   26.0 29.0                       55.0 23 17 7 4   2         2   26 29                 55
3352771 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 44.0 17.0 17.0 11.0   5.0       1.0 17.0   60.0 52.0                       112.0 44 17 17 11   5       1 17   60 52                 112
3352795 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 29.0 17.0 24.0 12.0   4.0         6.0   55.0 37.0                       92.0 29 17 24 12   4         6   55 37                 92
2970198 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 27.0 16.0 4.0 4.0   2.0       0.0 9.0   38.0 24.0                       62.0 27 16 4 4   2       0 9   38 24                 62
3352785 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 67.0 16.0 14.0 10.0   2.0         12.0   58.0 63.0                       121.0 67 16 14 10   2         12   58 63                 121
365749 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 34.0 15.0 17.0 8.0   9.0         8.0   42.0 49.0                       91.0 34 15 17 8   9         8   42 49                 91
3014903 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 67.0 14.0 20.0 11.0   1.0       0.0 10.0   72.0 51.0                       123.0 67 14 20 11   1       0 10   72 51                 123
258470 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 22.0 13.0 12.0 1.0   6.0         7.0   34.0 27.0                       61.0 22 13 12 1   6         7   34 27                 61
3352779 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 28.0 13.0 8.0 4.0   1.0       0.0 2.0   27.0 29.0                       56.0 28 13 8 4   1       0 2   27 29                 56
496034 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 19.0 12.0 9.0 10.0   4.0         8.0   27.0 35.0                       62.0 19 12 9 10   4         8   27 35                 62
2970211 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 23.0 12.0 8.0 4.0   2.0       0.0 7.0   21.0 35.0                       56.0 23 12 8 4   2       0 7   21 35                 56
2970207 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 24.0 11.0 20.0 1.0   2.0       0.0 2.0   35.0 25.0                       60.0 24 11 20 1   2       0 2   35 25                 60
3352776 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 26.0 11.0 16.0 2.0   2.0         2.0   32.0 27.0                       59.0 26 11 16 2   2         2   32 27                 59
365730 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 19.0 10.0 14.0 2.0   4.0         5.0   26.0 28.0                       54.0 19 10 14 2   4         5   26 28                 54
365733 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 22.0 10.0 9.0 10.0   1.0       0.0 5.0   30.0 27.0                       57.0 22 10 9 10   1       0 5   30 27                 57
457594 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 22.0 10.0 12.0 5.0   0.0         4.0   25.0 28.0                       53.0 22 10 12 5   0         4   25 28                 53
3014894 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 24.0 10.0 14.0 3.0   2.0         2.0   28.0 27.0                       55.0 24 10 14 3   2         2   28 27                 55
3014905 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 5.0 10.0 2.0 2.0   0.0       0.0 0.0   9.0 10.0                       19.0 5 10 2 2   0       0 0   9 10                 19
250587 SD     school 4606960 25001   Big Stone City 25-1 460696000053 1 Big Stone City Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 20.0 1.0   0.0   0.0             13.0 8.0                       21.0 20 1   0   0             13 8                 21
250902 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   pre_kindergarten 31.0 1.0 1.0 1.0   0.0       1.0 2.0   25.0 12.0                       37.0 31 1 1 1   0       1 2   25 12                 37
251655 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten 27.0 1.0 0.0               0.0   16.0 12.0                       28.0 27 1 0               0   16 12                 28
253957 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 12.0 1.0 0.0 0.0   0.0         0.0   7.0 6.0                       13.0 12 1 0 0   0         0   7 6                 13
253964 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 13.0 1.0 1.0 3.0   0.0         0.0   13.0 5.0                       18.0 13 1 1 3   0         0   13 5                 18
254010 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 11.0 1.0       0.0             5.0 7.0                       12.0 11 1       0             5 7                 12
254106 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 9.0 1.0 0.0 1.0             0.0   7.0 4.0                       11.0 9 1 0 1             0   7 4                 11
254600 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School No Elementary PK 05 2018   pre_kindergarten 25.0 1.0 1.0 1.0   0.0         0.0   14.0 14.0                       28.0 25 1 1 1   0         0   14 14                 28
257514 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten 45.0 1.0 1.0 1.0   0.0             23.0 25.0                       48.0 45 1 1 1   0             23 25                 48
258458 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 9.0 1.0 3.0 0.0   1.0       0.0 1.0   9.0 6.0                       15.0 9 1 3 0   1       0 1   9 6                 15

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