enrollments

Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_7" and state = "SD" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,596 ✖
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
3353217 3353217 SD     school 4670140 54006   Summit 54-6 467014000663 1 Summit High School   Regular School No 3 09 12 2016   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3353216 3353216 SD     school 4670140 54006   Summit 54-6 467014000662 2 Summit Elementary   Regular School No 1 PK 08 2016   grade_7 8.0 0.0 0.0 2.0             0.0   5.0 5.0                       10.0 8 0 0 2             0   5 5                 10
3353173 3353173 SD     school 4624850 57001   Stanley County 57-1 462485000841 2 Stanley County Middle School   Regular School No 2 06 08 2016   grade_7 17.0   1.0 9.0             3.0   17.0 13.0                       30.0 17   1 9             3   17 13                 30
3353172 3353172 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No 3 09 12 2016   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3353171 3353171 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County 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
3353170 3353170 SD     school 4624850 57001   Stanley County 57-1 462485000849 6 Cheyenne Elementary   Regular School No 1 KG 08 2016   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3353085 3353085 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 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
3353084 3353084 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No 2 06 08 2016   grade_7 129.0 1.0 7.0 0.0   3.0       0.0 3.0   66.0 77.0                       143.0 129 1 7 0   3       0 3   66 77                 143
3353083 3353083 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 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
3353082 3353082 SD     school 4666930 40002   Spearfish 40-2 466693001342 8 Mountain View Elem   Regular School No 1 PK KG 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
3353081 3353081 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 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
3353080 3353080 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative Education School No 3 10 12 2016   grade_7 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
3353079 3353079 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Black Hills Academy at Canyon Hills H.S.   Alternative Education School No 3 09 12 2016   grade_7 0.0 0.0   0.0                 0.0 0.0                       0.0 0 0   0                 0 0                 0
3353078 3353078 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Black Hills Academy at Canyon Hills Elem   Alternative Education School No 1 KG 08 2016   grade_7 1.0     1.0             1.0   1.0 2.0                       3.0 1     1             1   1 2                 3
3352987 3352987 SD     school 4607670 26005   South Central 26-5 460767000881 2 South Central MS   Regular School No 2 06 08 2016   grade_7 5.0 0.0 0.0 3.0                 4.0 4.0                       8.0 5 0 0 3                 4 4                 8
3352986 3352986 SD     school 4607670 26005   South Central 26-5 460767000880 1 South Central High School   Regular School No 3 09 12 2016   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
3352985 3352985 SD     school 4607670 26005   South Central 26-5 460767000882 3 South Central 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
3352939 3352939 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2016   grade_7   0.0   15.0             1.0   7.0 9.0                       16.0   0   15             1   7 9                 16
3352938 3352938 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2016   grade_7       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3352937 3352937 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala 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
3352885 3352885 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   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
3352884 3352884 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No 2 06 08 2016   grade_7 19.0   3.0 30.0             2.0   31.0 23.0                       54.0 19   3 30             2   31 23                 54
3352883 3352883 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No 3 09 12 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
3352882 3352882 SD     school 4600053 54002   Sisseton 54-2 460005301242 5 New Effington Elementary   Regular School No 1 PK 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
3352827 3352827 SD     school 4666300 5005   Sioux Valley 05-5 466630000613 4 Sioux Valley Middle School   Regular School No 2 06 08 2016   grade_7 43.0   1.0     2.0         1.0   21.0 26.0                       47.0 43   1     2         1   21 26                 47
3352826 3352826 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No 3 09 12 2016   grade_7 0.0   0.0 0.0   0.0             0.0 0.0                       0.0 0   0 0   0             0 0                 0
3352825 3352825 SD     school 4666300 5005   Sioux Valley 05-5 466630000614 2 Sioux Valley Elementary School   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
3352539 3352539 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No 2 06 08 2016   grade_7 135.0 50.0 46.0 15.0   25.0       0.0 14.0   133.0 152.0                       285.0 135 50 46 15   25       0 14   133 152                 285
3352538 3352538 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 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
3352537 3352537 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin 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
3352536 3352536 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony 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
3352535 3352535 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative Education School No 4 KG 12 2016   grade_7 2.0 2.0 0.0 1.0             0.0   2.0 3.0                       5.0 2 2 0 1             0   2 3                 5
3352534 3352534 SD     school 4666270 49005   Sioux Falls 49-5 466627000609 40 Summit Oaks Day Program   Special Education School No 4 KG 12 2016   grade_7 0.0 0.0 0.0 0.0             3.0   1.0 2.0                       3.0 0 0 0 0             3   1 2                 3
3352533 3352533 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No 4 05 12 2016   grade_7 1.0     1.0                 2.0 0.0                       2.0 1     1                 2 0                 2
3352532 3352532 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education 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
3352531 3352531 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks 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
3352530 3352530 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No 3 09 12 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
3352529 3352529 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost 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
3352528 3352528 SD     school 4666270 49005   Sioux Falls 49-5 466627000606 42 Renberg 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
3352527 3352527 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew 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
3352526 3352526 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2016   grade_7 306.0 24.0 15.0 9.0   8.0         9.0   176.0 195.0                       371.0 306 24 15 9   8         9   176 195                 371
3352525 3352525 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe 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
3352524 3352524 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No 3 09 12 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
3352523 3352523 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No 2 06 08 2016   grade_7 356.0 20.0 14.0 2.0   8.0         9.0   213.0 196.0                       409.0 356 20 14 2   8         9   213 196                 409
3352522 3352522 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2016   grade_7 1.0 15.0 4.0     3.0             18.0 5.0                       23.0 1 15 4     3             18 5                 23
3352521 3352521 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell 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   0 0                 0
3352520 3352520 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 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
3352519 3352519 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder 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
3352518 3352518 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson 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
3352517 3352517 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris 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   0 0                 0
3352516 3352516 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy 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
3352515 3352515 SD     school 4666270 49005   Sioux Falls 49-5 466627000592 21 Horace Mann 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
3352514 3352514 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward 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   0 0                 0
3352513 3352513 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne 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   0 0                 0
3352512 3352512 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn 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
3352511 3352511 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No 2 06 08 2016   grade_7 119.0 42.0 49.0 20.0   12.0       1.0 10.0   130.0 123.0                       253.0 119 42 49 20   12       1 10   130 123                 253
3352510 3352510 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield 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   0 0                 0
3352509 3352509 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No 4 06 12 2016   grade_7 2.0 1.0 0.0 0.0                 3.0 0.0                       3.0 2 1 0 0                 3 0                 3
3352508 3352508 SD     school 4666270 49005   Sioux Falls 49-5 466627000585 16 Eugene Field A+ 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
3352507 3352507 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   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
3352506 3352506 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No 2 06 08 2016   grade_7 231.0 17.0 16.0 16.0   6.0         12.0   156.0 142.0                       298.0 231 17 16 16   6         12   156 142                 298
3352505 3352505 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery 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
3352504 3352504 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No 4 KG 12 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
3352503 3352503 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland 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   0 0                 0
3352502 3352502 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   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
3352501 3352501 SD     school 4666270 49005   Sioux Falls 49-5 466627001305 37 Career and Technical Education Academy   Vocational Education School No 3 09 12 2016   grade_7 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
3352500 3352500 SD     school 4666270 49005   Sioux Falls 49-5 466627001139 52 Bridges at Horace Mann   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
3352499 3352499 SD     school 4666270 49005   Sioux Falls 49-5 466627000771 55 Bridges at Garfield   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
3352498 3352498 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan 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   0 0                 0
3352497 3352497 SD     school 4666270 49005   Sioux Falls 49-5 466627001128 50 All City 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
3352091 3352091 SD     school 4601028 62005   Selby Area 62-5 460102801036 3 Selby Jr Hi   Regular School No 2 07 08 2016   grade_7 17.0 0.0 1.0 1.0             1.0   11.0 9.0                       20.0 17 0 1 1             1   11 9                 20
3352090 3352090 SD     school 4601028 62005   Selby Area 62-5 460102801028 1 Selby Hi Sch   Regular School No 3 09 12 2016   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3352089 3352089 SD     school 4601028 62005   Selby Area 62-5 460102801032 2 Selby Elem K-6   Regular School No 1 PK 06 2016   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3352043 3352043 SD     school 4665180 4003   Scotland 04-3 466518000933 5 Scotland Middle School   Regular School No 2 06 08 2016   grade_7 21.0                   1.0   8.0 14.0                       22.0 21                   1   8 14                 22
3352042 3352042 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School No 3 09 12 2016   grade_7 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
3352041 3352041 SD     school 4665180 4003   Scotland 04-3 466518000568 2 Scotland Elementary School   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
3351989 3351989 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School No 1 KG 08 2016   grade_7 4.0                       2.0 2.0                       4.0 4                       2 2                 4
3351988 3351988 SD     school 4603932 55005   Sanborn Central 55-5 460393200102 2 Sanborn Central Middle School   Regular School No 2 06 08 2016   grade_7 6.0     0.0             0.0   1.0 5.0                       6.0 6     0             0   1 5                 6
3351987 3351987 SD     school 4603932 55005   Sanborn Central 55-5 460393200099 1 Sanborn Central High School   Regular School No 3 09 12 2016   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3351986 3351986 SD     school 4603932 55005   Sanborn Central 55-5 460393201162 6 Sanborn Central 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
3351925 3351925 SD     school 4664140 39004   Rutland 39-4 466414000932 3 Rutland Jr Hi   Regular School No 2 07 08 2016   grade_7 6.0     1.0                 4.0 3.0                       7.0 6     1                 4 3                 7
3351924 3351924 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No 3 09 12 2016   grade_7 0.0 0.0                 0.0   0.0 0.0                       0.0 0 0                 0   0 0                 0
3351923 3351923 SD     school 4664140 39004   Rutland 39-4 466414000562 2 Rutland Elem   Regular School No 1 KG 06 2016   grade_7 0.0                 0.0     0.0 0.0                       0.0 0                 0     0 0                 0
3351922 3351922 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School No 1 KG 08 2016   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
3351861 3351861 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School No 1 KG 08 2016   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3351860 3351860 SD     school 4663360 54004   Rosholt 54-4 466336001053 4 Rosholt Jr High   Regular School No 2 07 08 2016   grade_7 8.0   0.0 2.0             0.0   7.0 3.0                       10.0 8   0 2             0   7 3                 10
3351859 3351859 SD     school 4663360 54004   Rosholt 54-4 466336000557 1 Rosholt High School   Regular School No 3 09 12 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
3351858 3351858 SD     school 4663360 54004   Rosholt 54-4 466336000556 2 Rosholt 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
3351797 3351797 SD     school 4660450 56004   Redfield 56-4 466045000858 2 Redfield Junior High School   Regular School No 2 07 08 2016   grade_7 43.0                       22.0 21.0                       43.0 43                       22 21                 43
3351796 3351796 SD     school 4660450 56004   Redfield 56-4 466045000552 1 Redfield High School   Regular School No 3 09 12 2016   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3351795 3351795 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No 1 PK 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
3351794 3351794 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S. Mickelson Alternative HS   Alternative Education School No 3 09 12 2016   grade_7 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
3351607 3351607 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   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
3351606 3351606 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No 2 06 08 2016   grade_7 160.0 3.0 7.0 24.0   1.0         13.0   89.0 119.0                       208.0 160 3 7 24   1         13   89 119                 208
3351605 3351605 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   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
3351604 3351604 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 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
3351603 3351603 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No 2 06 08 2016   grade_7 193.0 1.0 12.0 5.0   3.0         9.0   118.0 105.0                       223.0 193 1 12 5   3         9   118 105                 223
3351602 3351602 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   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
3351601 3351601 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No 2 06 08 2016   grade_7 166.0 2.0 20.0 30.0   0.0         14.0   107.0 125.0                       232.0 166 2 20 30   0         14   107 125                 232
3351600 3351600 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   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

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