enrollments

Data source: Big Local News · About: Big Local

10,656 rows where state = "SD" and year = 2016 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 10,656 ✖
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
3344174 3344174 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   grade_1 71.0 3.0 3.0 1.0   0.0         0.0   42.0 36.0                       78.0 71 3 3 1   0         0   42 36                 78
3344177 3344177 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   grade_1 58.0 1.0 2.0 8.0   0.0         1.0   32.0 38.0                       70.0 58 1 2 8   0         1   32 38                 70
3344178 3344178 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_1 44.0 1.0 4.0 4.0   1.0       1.0 4.0   32.0 27.0                       59.0 44 1 4 4   1       1 4   32 27                 59
3344180 3344180 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   grade_1 56.0 0.0 2.0 6.0   4.0         6.0   44.0 30.0                       74.0 56 0 2 6   4         6   44 30                 74
3344181 3344181 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   grade_1 53.0 2.0 1.0 3.0   0.0       0.0 2.0   32.0 29.0                       61.0 53 2 1 3   0       0 2   32 29                 61
3344183 3344183 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344186 3344186 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344187 3344187 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344189 3344189 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344190 3344190 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344192 3344192 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344195 3344195 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344196 3344196 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344198 3344198 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344199 3344199 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344201 3344201 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344204 3344204 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344205 3344205 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344207 3344207 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344208 3344208 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344210 3344210 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   grade_2 61.0 6.0 3.0 2.0   2.0         2.0   38.0 38.0                       76.0 61 6 3 2   2         2   38 38                 76
3344213 3344213 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   grade_2 62.0 1.0 6.0 4.0   0.0         1.0   42.0 32.0                       74.0 62 1 6 4   0         1   42 32                 74
3344214 3344214 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_2 57.0 1.0 3.0 5.0   2.0       0.0 7.0   36.0 39.0                       75.0 57 1 3 5   2       0 7   36 39                 75
3344216 3344216 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   grade_2 58.0 1.0 2.0 7.0   4.0         4.0   38.0 38.0                       76.0 58 1 2 7   4         4   38 38                 76
3344217 3344217 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   grade_2 62.0 2.0 6.0 5.0   0.0       0.0 3.0   41.0 37.0                       78.0 62 2 6 5   0       0 3   41 37                 78
3344219 3344219 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   grade_3 71.0 3.0 2.0 2.0   1.0         3.0   42.0 40.0                       82.0 71 3 2 2   1         3   42 40                 82
3344222 3344222 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   grade_3 63.0 1.0 4.0 5.0   3.0         2.0   43.0 35.0                       78.0 63 1 4 5   3         2   43 35                 78
3344223 3344223 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_3 46.0 3.0 4.0 3.0   0.0       1.0 6.0   32.0 31.0                       63.0 46 3 4 3   0       1 6   32 31                 63
3344225 3344225 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   grade_3 68.0 2.0 5.0 4.0   1.0         5.0   41.0 44.0                       85.0 68 2 5 4   1         5   41 44                 85
3344226 3344226 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   grade_3 69.0 0.0 1.0 5.0   1.0       1.0 5.0   40.0 42.0                       82.0 69 0 1 5   1       1 5   40 42                 82
3344228 3344228 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   grade_4 67.0 2.0 2.0 0.0   2.0         5.0   44.0 34.0                       78.0 67 2 2 0   2         5   44 34                 78
3344231 3344231 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   grade_4 60.0 0.0 2.0 4.0   1.0         3.0   39.0 31.0                       70.0 60 0 2 4   1         3   39 31                 70
3344232 3344232 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_4 64.0 1.0 1.0 4.0   2.0       0.0 6.0   38.0 40.0                       78.0 64 1 1 4   2       0 6   38 40                 78
3344234 3344234 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   grade_4 56.0 1.0 6.0 7.0   2.0         4.0   37.0 39.0                       76.0 56 1 6 7   2         4   37 39                 76
3344235 3344235 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   grade_4 48.0 0.0 3.0 4.0   0.0       0.0 3.0   39.0 19.0                       58.0 48 0 3 4   0       0 3   39 19                 58
3344237 3344237 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   grade_5 68.0 2.0 0.0 1.0   2.0         2.0   38.0 37.0                       75.0 68 2 0 1   2         2   38 37                 75
3344240 3344240 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   grade_5 49.0 1.0 2.0 7.0   1.0         0.0   35.0 25.0                       60.0 49 1 2 7   1         0   35 25                 60
3344241 3344241 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   grade_5 53.0 1.0 3.0 1.0   4.0       1.0 3.0   29.0 37.0                       66.0 53 1 3 1   4       1 3   29 37                 66
3344243 3344243 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   grade_5 63.0 0.0 2.0 0.0   4.0         1.0   33.0 37.0                       70.0 63 0 2 0   4         1   33 37                 70
3344244 3344244 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   grade_5 65.0 0.0 2.0 4.0   3.0       0.0 1.0   32.0 43.0                       75.0 65 0 2 4   3       0 1   32 43                 75
3344246 3344246 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344249 3344249 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344250 3344250 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344252 3344252 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344253 3344253 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344255 3344255 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344258 3344258 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344259 3344259 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344261 3344261 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344262 3344262 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344264 3344264 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344267 3344267 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344268 3344268 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344270 3344270 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344271 3344271 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344273 3344273 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344276 3344276 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   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
3344277 3344277 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344279 3344279 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344280 3344280 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344282 3344282 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   k_12_total 389.0 19.0 11.0 6.0   11.0         18.0   242.0 212.0                       454.0 389 19 11 6   11         18   242 212                 454
3344285 3344285 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   k_12_total 341.0 4.0 21.0 36.0   9.0         10.0   225.0 196.0                       421.0 341 4 21 36   9         10   225 196                 421
3344286 3344286 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   k_12_total 313.0 7.0 19.0 23.0   11.0       4.0 37.0   204.0 210.0                       414.0 313 7 19 23   11       4 37   204 210                 414
3344288 3344288 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   k_12_total 355.0 4.0 22.0 28.0   18.0         24.0   228.0 223.0                       451.0 355 4 22 28   18         24   228 223                 451
3344289 3344289 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   k_12_total 347.0 4.0 16.0 23.0   7.0       2.0 17.0   216.0 200.0                       416.0 347 4 16 23   7       2 17   216 200                 416
3344291 3344291 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   kindergarten 51.0 3.0 1.0 0.0   4.0         6.0   38.0 27.0                       65.0 51 3 1 0   4         6   38 27                 65
3344294 3344294 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   kindergarten 49.0 0.0 5.0 8.0   4.0         3.0   34.0 35.0                       69.0 49 0 5 8   4         3   34 35                 69
3344295 3344295 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   kindergarten 49.0 0.0 4.0 6.0   2.0       1.0 11.0   37.0 36.0                       73.0 49 0 4 6   2       1 11   37 36                 73
3344297 3344297 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   kindergarten 54.0 0.0 5.0 4.0   3.0         4.0   35.0 35.0                       70.0 54 0 5 4   3         4   35 35                 70
3344298 3344298 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   kindergarten 50.0 0.0 3.0 2.0   3.0       1.0 3.0   32.0 30.0                       62.0 50 0 3 2   3       1 3   32 30                 62
3344300 3344300 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   pk_12_total 389.0 19.0 11.0 6.0   11.0         18.0   242.0 212.0                       454.0 389 19 11 6   11         18   242 212                 454
3344303 3344303 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   pk_12_total 371.0 4.0 21.0 36.0   9.0         10.0   234.0 217.0                       451.0 371 4 21 36   9         10   234 217                 451
3344304 3344304 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   pk_12_total 313.0 7.0 19.0 23.0   11.0       4.0 37.0   204.0 210.0                       414.0 313 7 19 23   11       4 37   204 210                 414
3344306 3344306 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   pk_12_total 355.0 4.0 22.0 28.0   18.0         24.0   228.0 223.0                       451.0 355 4 22 28   18         24   228 223                 451
3344307 3344307 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   pk_12_total 347.0 4.0 16.0 23.0   7.0       2.0 17.0   216.0 200.0                       416.0 347 4 16 23   7       2 17   216 200                 416
3344309 3344309 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No 1 KG 05 2016   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
3344312 3344312 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 30.0 0.0 0.0 0.0   0.0         0.0   9.0 21.0                       30.0 30 0 0 0   0         0   9 21                 30
3344313 3344313 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No 1 KG 05 2016   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
3344315 3344315 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2016   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
3344316 3344316 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No 1 KG 05 2016   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
3344318 3344318 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_1 5.0   0.0 1.0             0.0   4.0 2.0                       6.0 5   0 1             0   4 2                 6
3344319 3344319 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_1 8.0   0.0 0.0           0.0 1.0   6.0 3.0                       9.0 8   0 0           0 1   6 3                 9
3344322 3344322 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_10 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3344323 3344323 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   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
3344326 3344326 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_11 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3344327 3344327 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   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
3344330 3344330 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_12 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3344331 3344331 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   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
3344334 3344334 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_2 4.0   0.0 2.0             0.0   3.0 3.0                       6.0 4   0 2             0   3 3                 6
3344335 3344335 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_2 14.0   1.0 0.0           0.0 0.0   5.0 10.0                       15.0 14   1 0           0 0   5 10                 15
3344338 3344338 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_3 2.0   0.0 1.0             1.0   4.0 0.0                       4.0 2   0 1             1   4 0                 4
3344339 3344339 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_3 16.0   0.0 0.0           0.0 0.0   10.0 6.0                       16.0 16   0 0           0 0   10 6                 16
3344342 3344342 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_4 4.0   2.0 1.0             0.0   6.0 1.0                       7.0 4   2 1             0   6 1                 7
3344343 3344343 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_4 13.0   0.0 0.0           0.0 0.0   3.0 10.0                       13.0 13   0 0           0 0   3 10                 13
3344346 3344346 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_5 0.0   0.0 1.0             0.0   1.0 0.0                       1.0 0   0 1             0   1 0                 1
3344347 3344347 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_5 19.0   0.0 0.0           1.0 0.0   10.0 10.0                       20.0 19   0 0           1 0   10 10                 20
3344350 3344350 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_6 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3344351 3344351 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   grade_6 16.0   0.0 2.0           0.0 3.0   13.0 8.0                       21.0 16   0 2           0 3   13 8                 21
3344354 3344354 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3344355 3344355 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   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

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