enrollments

Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white ▼ black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2968152 2968152 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968155 2968155 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968158 2968158 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968161 2968161 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968164 2968164 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968167 2968167 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968170 2968170 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_4       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968173 2968173 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_5       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968176 2968176 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_6       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968179 2968179 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_7       7.0                 4.0 3.0                       7.0       7                 4 3                 7
2968182 2968182 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_8       7.0                 6.0 1.0                       7.0       7                 6 1                 7
2968185 2968185 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968188 2968188 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   k_12_total       14.0                 10.0 4.0                       14.0       14                 10 4                 14
2968191 2968191 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2968194 2968194 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   pk_12_total       14.0                 10.0 4.0                       14.0       14                 10 4                 14
2968197 2968197 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969414 2969414 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_1       22.0                 12.0 10.0                       22.0       22                 12 10                 22
2969415 2969415 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_1     0.0 9.0                 3.0 6.0                       9.0     0 9                 3 6                 9
2969417 2969417 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969418 2969418 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_1     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969419 2969419 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_1     2.0 91.0             2.0   54.0 41.0                       95.0     2 91             2   54 41                 95
2969420 2969420 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969421 2969421 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_10     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969423 2969423 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969424 2969424 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_10     1.0 16.0                 7.0 10.0                       17.0     1 16                 7 10                 17
2969425 2969425 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_10     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
2969426 2969426 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969427 2969427 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_11     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969429 2969429 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969430 2969430 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_11     0.0 9.0                 4.0 5.0                       9.0     0 9                 4 5                 9
2969431 2969431 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_11     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
2969432 2969432 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969433 2969433 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_12     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969435 2969435 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969436 2969436 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_12     0.0 4.0                 0.0 4.0                       4.0     0 4                 0 4                 4
2969437 2969437 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_12     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
2969438 2969438 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_2       24.0                 11.0 13.0                       24.0       24                 11 13                 24
2969439 2969439 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_2     1.0 5.0                 4.0 2.0                       6.0     1 5                 4 2                 6
2969441 2969441 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969442 2969442 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_2     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
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
2969444 2969444 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_3       23.0                 11.0 12.0                       23.0       23                 11 12                 23
2969445 2969445 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_3     0.0 3.0                 3.0 0.0                       3.0     0 3                 3 0                 3
2969447 2969447 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_3       4.0                 4.0 0.0                       4.0       4                 4 0                 4
2969448 2969448 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_3     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969449 2969449 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_3     0.0 77.0             0.0   41.0 36.0                       77.0     0 77             0   41 36                 77
2969450 2969450 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_4       23.0                 9.0 14.0                       23.0       23                 9 14                 23
2969451 2969451 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_4     0.0 7.0                 4.0 3.0                       7.0     0 7                 4 3                 7
2969453 2969453 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_4       4.0                 4.0 0.0                       4.0       4                 4 0                 4
2969454 2969454 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_4     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969455 2969455 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_4     4.0 58.0             1.0   36.0 27.0                       63.0     4 58             1   36 27                 63
2969456 2969456 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_5       22.0                 13.0 9.0                       22.0       22                 13 9                 22
2969457 2969457 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_5     0.0 7.0                 4.0 3.0                       7.0     0 7                 4 3                 7
2969459 2969459 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_5       1.0                 1.0 0.0                       1.0       1                 1 0                 1
2969460 2969460 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_5     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969461 2969461 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_5     0.0 52.0             0.0   33.0 19.0                       52.0     0 52             0   33 19                 52
2969462 2969462 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_6       22.0                 11.0 11.0                       22.0       22                 11 11                 22
2969463 2969463 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_6     2.0 6.0                 4.0 4.0                       8.0     2 6                 4 4                 8
2969465 2969465 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_6       5.0                 4.0 1.0                       5.0       5                 4 1                 5
2969466 2969466 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_6     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969467 2969467 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_6     0.0 56.0             0.0   27.0 29.0                       56.0     0 56             0   27 29                 56
2969468 2969468 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_7       20.0                 7.0 13.0                       20.0       20                 7 13                 20
2969469 2969469 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_7     0.0 9.0                 5.0 4.0                       9.0     0 9                 5 4                 9
2969471 2969471 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_7       5.0                 3.0 2.0                       5.0       5                 3 2                 5
2969472 2969472 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_7     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969473 2969473 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_7     2.0 40.0             1.0   17.0 26.0                       43.0     2 40             1   17 26                 43
2969474 2969474 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_8       19.0                 12.0 7.0                       19.0       19                 12 7                 19
2969475 2969475 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_8     0.0 7.0                 4.0 3.0                       7.0     0 7                 4 3                 7
2969477 2969477 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_8       3.0                 2.0 1.0                       3.0       3                 2 1                 3
2969478 2969478 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_8     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969479 2969479 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_8     1.0 42.0             1.0   24.0 20.0                       44.0     1 42             1   24 20                 44
2969480 2969480 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969481 2969481 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   grade_9     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969483 2969483 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969484 2969484 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   grade_9     2.0 65.0                 32.0 35.0                       67.0     2 65                 32 35                 67
2969485 2969485 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   grade_9     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
2969486 2969486 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   k_12_total       204.0                 102.0 102.0                       204.0       204                 102 102                 204
2969487 2969487 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   k_12_total     3.0 66.0                 39.0 30.0                       69.0     3 66                 39 30                 69
2969489 2969489 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   k_12_total       22.0                 18.0 4.0                       22.0       22                 18 4                 22
2969490 2969490 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   k_12_total     3.0 94.0                 43.0 54.0                       97.0     3 94                 43 54                 97
2969491 2969491 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   k_12_total     12.0 586.0             5.0   316.0 287.0                       603.0     12 586             5   316 287                 603
2969492 2969492 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   kindergarten       29.0                 16.0 13.0                       29.0       29                 16 13                 29
2969493 2969493 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   kindergarten     0.0 13.0                 8.0 5.0                       13.0     0 13                 8 5                 13
2969495 2969495 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969496 2969496 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   kindergarten     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969497 2969497 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   kindergarten     1.0 81.0             0.0   40.0 42.0                       82.0     1 81             0   40 42                 82
2969498 2969498 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   pk_12_total       211.0                 103.0 108.0                       211.0       211                 103 108                 211
2969499 2969499 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   pk_12_total     3.0 73.0                 42.0 34.0                       76.0     3 73                 42 34                 76
2969501 2969501 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   pk_12_total       22.0                 18.0 4.0                       22.0       22                 18 4                 22
2969502 2969502 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   pk_12_total     3.0 94.0                 43.0 54.0                       97.0     3 94                 43 54                 97
2969503 2969503 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   pk_12_total     13.0 627.0             5.0   344.0 301.0                       645.0     13 627             5   344 301                 645
2969504 2969504 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   pre_kindergarten       7.0                 1.0 6.0                       7.0       7                 1 6                 7
2969505 2969505 SD     school 4665460 65001   Shannon County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2015   pre_kindergarten     0.0 7.0                 3.0 4.0                       7.0     0 7                 3 4                 7
2969507 2969507 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2969508 2969508 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   pre_kindergarten     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2969509 2969509 SD     school 4665460 65001   Shannon County 65-1 466546000574 2 Wolf Creek School   Regular School No 1 PK 08 2015   pre_kindergarten     1.0 41.0             0.0   28.0 14.0                       42.0     1 41             0   28 14                 42
2970342 2970342 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_1   0.0   10.0             1.0   5.0 6.0                       11.0   0   10             1   5 6                 11
2970343 2970343 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970344 2970344 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970345 2970345 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_10   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]);