enrollments

Data source: Big Local News · About: Big Local

10,720 rows where state = "SD" and year = 2015 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 10,620 ✖
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
2962827 2962827 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_2 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2962832 2962832 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_3 105.0 3.0 4.0 2.0   5.0       0.0 7.0   67.0 59.0                       126.0 105 3 4 2   5       0 7   67 59                 126
2962837 2962837 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_4 216.0 10.0 9.0 7.0   9.0       1.0 12.0   129.0 135.0                       264.0 216 10 9 7   9       1 12   129 135                 264
2962842 2962842 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_5 207.0 0.0 9.0 11.0   9.0       0.0 9.0   129.0 116.0                       245.0 207 0 9 11   9       0 9   129 116                 245
2962847 2962847 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2962852 2962852 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2962857 2962857 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2962862 2962862 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2962867 2962867 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   k_12_total 528.0 13.0 22.0 20.0   23.0       1.0 28.0   325.0 310.0                       635.0 528 13 22 20   23       1 28   325 310                 635
2962872 2962872 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2962877 2962877 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   pk_12_total 528.0 13.0 22.0 20.0   23.0       1.0 28.0   325.0 310.0                       635.0 528 13 22 20   23       1 28   325 310                 635
2962882 2962882 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964138 2964138 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_1 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964143 2964143 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_10 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964148 2964148 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_11 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964153 2964153 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_12 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964158 2964158 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_2 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964163 2964163 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_3 1.0   0.0 46.0                 26.0 21.0                       47.0 1   0 46                 26 21                 47
2964168 2964168 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_4 1.0   1.0 59.0                 35.0 26.0                       61.0 1   1 59                 35 26                 61
2964173 2964173 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_5 1.0   0.0 63.0                 32.0 32.0                       64.0 1   0 63                 32 32                 64
2964178 2964178 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_6 2.0   0.0 56.0                 32.0 26.0                       58.0 2   0 56                 32 26                 58
2964183 2964183 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964188 2964188 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_8 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964193 2964193 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_9 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964198 2964198 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   k_12_total 5.0   1.0 224.0                 125.0 105.0                       230.0 5   1 224                 125 105                 230
2964203 2964203 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   kindergarten 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2964208 2964208 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   pk_12_total 5.0   1.0 224.0                 125.0 105.0                       230.0 5   1 224                 125 105                 230
2964213 2964213 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   pre_kindergarten 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2967833 2967833 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_1 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967837 2967837 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_10 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967841 2967841 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_11 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967845 2967845 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_12 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967849 2967849 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_2 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967853 2967853 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_3 26.0   0.0 23.0   1.0         2.0   27.0 25.0                       52.0 26   0 23   1         2   27 25                 52
2967857 2967857 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_4 25.0   1.0 16.0   0.0         0.0   20.0 22.0                       42.0 25   1 16   0         0   20 22                 42
2967861 2967861 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_5 30.0   1.0 21.0   0.0         2.0   25.0 29.0                       54.0 30   1 21   0         2   25 29                 54
2967865 2967865 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_6 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967869 2967869 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_7 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967873 2967873 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_8 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967877 2967877 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967881 2967881 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   k_12_total 81.0   2.0 60.0   1.0         4.0   72.0 76.0                       148.0 81   2 60   1         4   72 76                 148
2967885 2967885 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   kindergarten 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2967889 2967889 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   pk_12_total 81.0   2.0 60.0   1.0         4.0   72.0 76.0                       148.0 81   2 60   1         4   72 76                 148
2967893 2967893 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   pre_kindergarten 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2970441 2970441 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_1 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970449 2970449 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970457 2970457 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970465 2970465 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970473 2970473 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_2 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970481 2970481 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_3 152.0 0.0 9.0 6.0   2.0       0.0 3.0   79.0 93.0                       172.0 152 0 9 6   2       0 3   79 93                 172
2970489 2970489 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_4 159.0 0.0 7.0 5.0   1.0       0.0 10.0   99.0 83.0                       182.0 159 0 7 5   1       0 10   99 83                 182
2970497 2970497 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_5 158.0 1.0 8.0 10.0   1.0       1.0 3.0   88.0 94.0                       182.0 158 1 8 10   1       1 3   88 94                 182
2970505 2970505 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970513 2970513 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970521 2970521 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970529 2970529 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970537 2970537 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   k_12_total 469.0 1.0 24.0 21.0   4.0       1.0 16.0   266.0 270.0                       536.0 469 1 24 21   4       1 16   266 270                 536
2970545 2970545 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970553 2970553 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   pk_12_total 469.0 1.0 24.0 21.0   4.0       1.0 16.0   266.0 270.0                       536.0 469 1 24 21   4       1 16   266 270                 536
2970561 2970561 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970728 2970728 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_1 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970732 2970732 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_10 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970736 2970736 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_11 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970740 2970740 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_12 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970744 2970744 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_2 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970748 2970748 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_3 114.0 4.0 1.0 3.0             6.0   67.0 61.0                       128.0 114 4 1 3             6   67 61                 128
2970752 2970752 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_4 115.0 1.0 4.0 0.0             0.0   75.0 45.0                       120.0 115 1 4 0             0   75 45                 120
2970756 2970756 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_5 90.0 0.0 3.0 0.0             5.0   57.0 41.0                       98.0 90 0 3 0             5   57 41                 98
2970760 2970760 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_6 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970764 2970764 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_7 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970768 2970768 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_8 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970772 2970772 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_9 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970776 2970776 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   k_12_total 319.0 5.0 8.0 3.0             11.0   199.0 147.0                       346.0 319 5 8 3             11   199 147                 346
2970780 2970780 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   kindergarten 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2970784 2970784 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   pk_12_total 319.0 5.0 8.0 3.0             11.0   199.0 147.0                       346.0 319 5 8 3             11   199 147                 346
2970788 2970788 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   pre_kindergarten 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2963995 2963995 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_1 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964001 2964001 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964007 2964007 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964013 2964013 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964019 2964019 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_2 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964025 2964025 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_3 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964031 2964031 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_4 158.0 5.0 17.0 19.0   1.0       0.0 16.0   114.0 102.0                       216.0 158 5 17 19   1       0 16   114 102                 216
2964037 2964037 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_5 165.0 4.0 14.0 17.0   2.0       2.0 19.0   123.0 100.0                       223.0 165 4 14 17   2       2 19   123 100                 223
2964043 2964043 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964049 2964049 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964055 2964055 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964061 2964061 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964067 2964067 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   k_12_total 323.0 9.0 31.0 36.0   3.0       2.0 35.0   237.0 202.0                       439.0 323 9 31 36   3       2 35   237 202                 439
2964073 2964073 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964079 2964079 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   pk_12_total 323.0 9.0 31.0 36.0   3.0       2.0 35.0   237.0 202.0                       439.0 323 9 31 36   3       2 35   237 202                 439
2964085 2964085 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2966393 2966393 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_1 0.0                       0.0 0.0                       0.0 0                       0 0                 0
2966397 2966397 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_10 0.0                       0.0 0.0                       0.0 0                       0 0                 0
2966401 2966401 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_11 0.0                       0.0 0.0                       0.0 0                       0 0                 0
2966405 2966405 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_12 0.0                       0.0 0.0                       0.0 0                       0 0                 0
2966409 2966409 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_2 0.0                       0.0 0.0                       0.0 0                       0 0                 0
2966413 2966413 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_3 0.0                       0.0 0.0                       0.0 0                       0 0                 0
2966417 2966417 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
2966421 2966421 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_5 2.0                       1.0 1.0                       2.0 2                       1 1                 2

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