enrollments

Data source: Big Local News · About: Big Local

671 rows where grade = "grade_7", state = "SD" and year = 2018 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 571 ✖

grade ✖

  • grade_7 · 571 ✖
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
258227 258227 SD     school 4666270 49005   Sioux Falls 49-5 466627001138 12 Structured Teaching Program   Special Education School No High 06 12 2018   grade_7 1.0 1.0   1.0             0.0   2.0 1.0                       3.0 1 1   1             0   2 1                 3
258228 258228 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No High 06 12 2018   grade_7 4.0 1.0 0.0                   5.0 0.0                       5.0 4 1 0                   5 0                 5
258234 258234 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   grade_7 124.0 70.0 57.0 28.0   31.0       0.0 19.0   173.0 156.0                       329.0 124 70 57 28   31       0 19   173 156                 329
258522 258522 SD     school 4666300 5005   Sioux Valley 05-5 466630000613 4 Sioux Valley Middle School   Regular School No Middle 06 08 2018   grade_7 50.0   1.0               3.0   25.0 29.0                       54.0 50   1               3   25 29                 54
258569 258569 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No Middle 06 08 2018   grade_7 22.0 0.0 1.0 40.0   0.0         0.0   31.0 32.0                       63.0 22 0 1 40   0         0   31 32                 63
258618 258618 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No Middle 06 08 2018   grade_7       19.0                 11.0 8.0                       19.0       19                 11 8                 19
258666 258666 SD     school 4607670 26005   South Central 26-5 460767000881 2 South Central MS   Regular School No Middle 06 08 2018   grade_7 4.0     4.0             1.0   7.0 2.0                       9.0 4     4             1   7 2                 9
258763 258763 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No Middle 06 08 2018   grade_7 173.0 0.0 9.0 6.0   1.0       0.0 10.0   106.0 93.0                       199.0 173 0 9 6   1       0 10   106 93                 199
258852 258852 SD     school 4624850 57001   Stanley County 57-1 462485000841 2 Stanley County Middle School   Regular School No Middle 06 08 2018   grade_7 26.0   0.0 4.0             1.0   15.0 16.0                       31.0 26   0 4             1   15 16                 31
259002 259002 SD     school 4671880 20003   Timber Lake 20-3 467188000940 3 Timber Lake Middle 6-8   Regular School No Middle 06 08 2018   grade_7 12.0   0.0 16.0                 10.0 18.0                       28.0 12   0 16                 10 18                 28
259137 259137 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School No Middle 06 08 2018   grade_7       14.0                 9.0 5.0                       14.0       14                 9 5                 14
259140 259140 SD     school 4672090 66001   Todd County 66-1 467209000814 10 Todd County MS   Regular School No Middle 06 08 2018   grade_7 0.0   0.0 119.0                 59.0 60.0                       119.0 0   0 119                 59 60                 119
259380 259380 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   grade_7 68.0 1.0 7.0 12.0   0.0         7.0   42.0 53.0                       95.0 68 1 7 12   0         7   42 53                 95
259572 259572 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2018   grade_7 14.0   0.0 2.0                 10.0 6.0                       16.0 14   0 2                 10 6                 16
259626 259626 SD     school 4676020 6005   Warner 06-5 467602000710 3 Warner Middle Sch   Regular School No Middle 06 08 2018   grade_7 18.0 0.0 0.0 0.0             2.0   13.0 7.0                       20.0 18 0 0 0             2   13 7                 20
259802 259802 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2018   grade_7 1.0     7.0                 4.0 4.0                       8.0 1     7                 4 4                 8
259850 259850 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2018   grade_7 25.0     0.0           1.0     15.0 11.0                       26.0 25     0           1     15 11                 26
259898 259898 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2018   grade_7 33.0   1.0 1.0             0.0   17.0 18.0                       35.0 33   1 1             0   17 18                 35
260036 260036 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   grade_7 100.0 1.0 0.0 5.0   0.0         2.0   66.0 42.0                       108.0 100 1 0 5   0         2   66 42                 108
260148 260148 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   grade_7 2.0 0.0 2.0 28.0             0.0   16.0 16.0                       32.0 2 0 2 28             0   16 16                 32
260232 260232 SD     school 4679350 12003   Willow Lake 12-3 467935000952 3 Willow Lake Middle School   Regular School No Middle 06 08 2018   grade_7 13.0 1.0 0.0 0.0                 9.0 5.0                       14.0 13 1 0 0                 9 5                 14
260346 260346 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2018   grade_7 36.0   0.0 12.0   0.0             24.0 24.0                       48.0 36   0 12   0             24 24                 48
260504 260504 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   grade_7 187.0 3.0 18.0 10.0   1.0         3.0   112.0 110.0                       222.0 187 3 18 10   1         3   112 110                 222
250004 250004 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200939 6 Sully Buttes Junior High   Regular School No Middle 07 08 2018   grade_7 17.0     1.0             0.0   8.0 10.0                       18.0 17     1             0   8 10                 18
250058 250058 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2018   grade_7 19.0   1.0               1.0   9.0 12.0                       21.0 19   1               1   9 12                 21
250124 250124 SD     school 4639540 11001   Andes Central 11-1 463954000850 4 Andes Central Jr High   Regular School No Middle 07 08 2018   grade_7 1.0   2.0 13.0             0.0   9.0 7.0                       16.0 1   2 13             0   9 7                 16
250195 250195 SD     school 4603720 38001   Arlington 38-1 460372000877 3 Arlington Junior High School   Regular School No Middle 07 08 2018   grade_7 14.0   1.0                   4.0 11.0                       15.0 14   1                   4 11                 15
250307 250307 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2018   grade_7 21.0   1.0 0.0             0.0   11.0 11.0                       22.0 21   1 0             0   11 11                 22
250489 250489 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Jr High   Regular School No Middle 07 08 2018   grade_7 3.0   2.0 16.0   0.0         10.0   16.0 15.0                       31.0 3   2 16   0         10   16 15                 31
250618 250618 SD     school 4607050 52001   Bison 52-1 460705000879 4 Bison JH   Regular School No Middle 07 08 2018   grade_7 8.0   1.0 1.0                 5.0 5.0                       10.0 8   1 1                 5 5                 10
250778 250778 SD     school 4607800 22001   Bowdle 22-1 460780000883 3 Bowdle Jr High   Regular School No Middle 07 08 2018   grade_7 14.0                       8.0 6.0                       14.0 14                       8 6                 14
250863 250863 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   grade_7 297.0 13.0 8.0 1.0   1.0       1.0 7.0   159.0 169.0                       328.0 297 13 8 1   1       1 7   159 169                 328
251013 251013 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Junior High   Regular School No Middle 07 08 2018   grade_7 33.0     0.0   1.0             21.0 13.0                       34.0 33     0   1             21 13                 34
251178 251178 SD     school 4609512 26002   Burke 26-2 460951201043 4 Burke JH   Regular School No Middle 07 08 2018   grade_7 17.0 1.0 1.0 0.0                 9.0 10.0                       19.0 17 1 1 0                 9 10                 19
251331 251331 SD     school 4611280 28001   Castlewood 28-1 461128000954 3 Castlewood Jr High School   Regular School No Middle 07 08 2018   grade_7 15.0   1.0                   9.0 7.0                       16.0 15   1                   9 7                 16
251434 251434 SD     school 4612000 7001   Chamberlain 07-1 461200000889 2 Chamberlain Jr. High   Regular School No Middle 07 08 2018   grade_7 40.0   1.0 22.0   1.0         2.0   31.0 35.0                       66.0 40   1 22   1         2   31 35                 66
251690 251690 SD     school 4614100 50005   Colman-Egan 50-5 461410000092 2 Colman-Egan Jr Hi   Regular School No Middle 07 08 2018   grade_7 20.0     1.0                 11.0 10.0                       21.0 20     1                 11 10                 21
251802 251802 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School No Middle 07 08 2018   grade_7 14.0                       5.0 9.0                       14.0 14                       5 9                 14
251859 251859 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2018   grade_7 44.0 1.0 7.0 2.0             1.0   26.0 29.0                       55.0 44 1 7 2             1   26 29                 55
252092 252092 SD     school 4678300 5006   Deubrook Area 05-6 467830000016 2 Deubrook Jr High   Regular School No Middle 07 08 2018   grade_7 35.0 0.0 0.0 1.0   1.0             15.0 22.0                       37.0 35 0 0 1   1             15 22                 37
252240 252240 SD     school 4619170 56002   Doland 56-2 461917000895 2 Doland Junior High   Regular School No Middle 07 08 2018   grade_7 7.0 0.0                     5.0 2.0                       7.0 7 0                     5 2                 7
252394 252394 SD     school 4619450 64002   Dupree 64-2 461945000896 4 Dupree Jr Hi   Regular School No Middle 07 08 2018   grade_7 3.0   2.0 34.0                 17.0 22.0                       39.0 3   2 34                 17 22                 39
252450 252450 SD     school 4620100 20001   Eagle Butte 20-1 462010000898 6 C-EB Junior High   Regular School No Middle 07 08 2018   grade_7 2.0   0.0 0.0                 0.0 2.0                       2.0 2   0 0                 0 2                 2
252548 252548 SD     school 4634440 22005   Edmunds Central 22-5 463444000032 2 Edmunds Central Middle School   Regular School No Middle 07 08 2018   grade_7 7.0   2.0 1.0                 5.0 5.0                       10.0 7   2 1                 5 5                 10
252700 252700 SD     school 4621390 5003   Elkton 05-3 462139000901 3 Elkton Junior High   Regular School No Middle 07 08 2018   grade_7 32.0   3.0               2.0   19.0 18.0                       37.0 32   3               2   19 18                 37
252762 252762 SD     school 4622410 28002   Estelline 28-2 462241001045 3 Estelline Junior High   Regular School No Middle 07 08 2018   grade_7 15.0   2.0                   8.0 9.0                       17.0 15   2                   8 9                 17
252810 252810 SD     school 4622500 17001   Ethan 17-1 462250000903 3 Ethan Jr. High   Regular School No Middle 07 08 2018   grade_7 23.0   2.0               1.0   13.0 13.0                       26.0 23   2               1   13 13                 26
252924 252924 SD     school 4622940 46002   Faith 46-2 462294000995 6 Faith Jr. High   Regular School No Middle 07 08 2018   grade_7 9.0   0.0 2.0   1.0             8.0 4.0                       12.0 9   0 2   1             8 4                 12
253015 253015 SD     school 4624030 24004   Faulkton Area 462403000204 8 Faulkton Jr Hi   Regular School No Middle 07 08 2018   grade_7 11.0 0.0   0.0                 3.0 8.0                       11.0 11 0   0                 3 8                 11
253194 253194 SD     school 4621400 6002   Frederick Area 06-2 462140000957 3 Frederick Jr High   Regular School No Middle 07 08 2018   grade_7 9.0                       7.0 2.0                       9.0 9                       7 2                 9
253260 253260 SD     school 4625500 33001   Freeman 33-1 462550000842 5 Freeman Jr High   Regular School No Middle 07 08 2018   grade_7 14.0   2.0               0.0   9.0 7.0                       16.0 14   2               0   9 7                 16
253370 253370 SD     school 4626490 63001   Gayville-Volin 63-1 462649000844 3 Gayville-Volin JH   Regular School No Middle 07 08 2018   grade_7 11.0   2.0               1.0   7.0 7.0                       14.0 11   2               1   7 7                 14
253418 253418 SD     school 4626970 53001   Gettysburg 53-1 462697000959 3 Gettysburg Junior High   Regular School No Middle 07 08 2018   grade_7 16.0 1.0 1.0 3.0                 8.0 13.0                       21.0 16 1 1 3                 8 13                 21
253572 253572 SD     school 4630490 27001   Haakon 27-1 463049000247 3 Philip Junior High   Regular School No Middle 07 08 2018   grade_7 18.0 0.0   1.0             1.0   11.0 9.0                       20.0 18 0   1             1   11 9                 20
254090 254090 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2018   grade_7 15.0     0.0             2.0   13.0 4.0                       17.0 15     0             2   13 4                 17
254205 254205 SD     school 4600046 56006   Hitchcock-Tulare 460004601164 2 Hitchcock-Tulare JH   Regular School No Middle 07 08 2018   grade_7 14.0     0.0                 8.0 6.0                       14.0 14     0                 8 6                 14
254314 254314 SD     school 4634600 53002   Hoven 53-2 463460000912 3 Hoven Jr High School   Regular School No Middle 07 08 2018   grade_7 10.0                       6.0 4.0                       10.0 10                       6 4                 10
254371 254371 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2018   grade_7 36.0 3.0 1.0               0.0   23.0 17.0                       40.0 36 3 1               0   23 17                 40
254634 254634 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No Middle 07 08 2018   grade_7 25.0     0.0                 11.0 14.0                       25.0 25     0                 11 14                 25
254970 254970 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Jr High   Regular School No Middle 07 08 2018   grade_7 10.0 0.0                 1.0   7.0 4.0                       11.0 10 0                 1   7 4                 11
255146 255146 SD     school 4641520 52004   Lemmon 52-4 464152000852 6 Lemmon Jr Hi   Regular School No Middle 07 08 2018   grade_7 11.0     0.0                 6.0 5.0                       11.0 11     0                 6 5                 11
255213 255213 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School No Middle 07 08 2018   grade_7 93.0 1.0 4.0 1.0             0.0   48.0 51.0                       99.0 93 1 4 1             0   48 51                 99
255302 255302 SD     school 4641640 44002   Leola 44-2 464164000919 3 Leola MS   Regular School No Middle 07 08 2018   grade_7 10.0                       5.0 5.0                       10.0 10                       5 5                 10
255594 255594 SD     school 4646260 15001   McIntosh 15-1 464626000921 3 McIntosh Jr High   Regular School No Middle 07 08 2018   grade_7 6.0     8.0             1.0   9.0 6.0                       15.0 6     8             1   9 6                 15
256003 256003 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School No Middle 07 08 2018   grade_7 28.0 0.0       1.0         0.0   16.0 13.0                       29.0 28 0       1         0   16 13                 29
256346 256346 SD     school 4650670 51003   New Underwood 51-3 465067000456 4 New Underwood Jr Hi   Regular School No Middle 07 08 2018   grade_7 11.0   0.0 1.0           1.0     5.0 8.0                       13.0 11   0 1           1     5 8                 13
256636 256636 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2018   grade_7 13.0                   1.0   5.0 9.0                       14.0 13                   1   5 9                 14
256698 256698 SD     school 4654270 60004   Parker 60-4 465427000925 3 Parker JH   Regular School No Middle 07 08 2018   grade_7 33.0 0.0 1.0 1.0           1.0 0.0   18.0 18.0                       36.0 33 0 1 1           1 0   18 18                 36
256776 256776 SD     school 4654300 33003   Parkston 33-3 465430000926 5 Parkston Junior High   Regular School No Middle 07 08 2018   grade_7 39.0   1.0               0.0   18.0 22.0                       40.0 39   1               0   18 22                 40
256942 256942 SD     school 4655710 1001   Plankinton 01-1 465571000927 3 Plankinton Junior High   Regular School No Middle 07 08 2018   grade_7 10.0   4.0                   8.0 6.0                       14.0 10   4                   8 6                 14
257022 257022 SD     school 4680438 11005   Platte-Geddes 11-5 468043801250 3 Platte-Geddes Jr. Hi   Regular School No Middle 07 08 2018   grade_7 36.0 0.0   0.0             1.0   14.0 23.0                       37.0 36 0   0             1   14 23                 37
257492 257492 SD     school 4660450 56004   Redfield 56-4 466045000858 2 Redfield Junior High School   Regular School No Middle 07 08 2018   grade_7 52.0 1.0 1.0 0.0                 29.0 25.0                       54.0 52 1 1 0                 29 25                 54
257555 257555 SD     school 4663360 54004   Rosholt 54-4 466336001053 4 Rosholt Jr High   Regular School No Middle 07 08 2018   grade_7 16.0   1.0 3.0                 9.0 11.0                       20.0 16   1 3                 9 11                 20
257786 257786 SD     school 4601028 62005   Selby Area 62-5 460102801036 3 Selby Jr Hi   Regular School No Middle 07 08 2018   grade_7 14.0     2.0                 10.0 6.0                       16.0 14     2                 10 6                 16
259242 259242 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   grade_7 66.0 5.0 5.0 1.0             0.0   37.0 40.0                       77.0 66 5 5 1             0   37 40                 77
259310 259310 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2018   grade_7 12.0     0.0   1.0             6.0 7.0                       13.0 12     0   1             6 7                 13
259724 259724 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   grade_7 274.0 4.0 13.0 11.0   3.0         8.0   166.0 147.0                       313.0 274 4 13 11   3         8   166 147                 313
259966 259966 SD     school 4677460 36002   Wessington Springs 36-2 467746000076 4 Wessington Springs Jr. High   Regular School No Middle 07 08 2018   grade_7 15.0   3.0                   7.0 11.0                       18.0 15   3                   7 11                 18
260090 260090 SD     school 4678510 1003   White Lake 01-3 467851000950 3 White Lake JH   Regular School No Middle 07 08 2018   grade_7 7.0 1.0 1.0                   6.0 3.0                       9.0 7 1 1                   6 3                 9
260298 260298 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   grade_7 11.0     6.0                 8.0 9.0                       17.0 11     6                 8 9                 17
249896 249896 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   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
250003 250003 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200656 7 Sully Buttes High School   Regular School No High 09 12 2018   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
250057 250057 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2018   grade_7 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
250123 250123 SD     school 4639540 11001   Andes Central 11-1 463954000360 1 Andes Central High School   Regular School No High 09 12 2018   grade_7 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
250194 250194 SD     school 4603720 38001   Arlington 38-1 460372000022 1 Arlington High School   Regular School No High 09 12 2018   grade_7 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
250249 250249 SD     school 4603780 21001   Armour 21-1 460378000024 1 Armour High School   Regular School No High 09 12 2018   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
250306 250306 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2018   grade_7 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
250361 250361 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2018   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
250426 250426 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2018   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
250427 250427 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2018   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
250488 250488 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2018   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
250537 250537 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   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
250617 250617 SD     school 4607050 52001   Bison 52-1 460705000055 1 Bison High School   Regular School No High 09 12 2018   grade_7 0.0   0.0     0.0             0.0 0.0                       0.0 0   0     0             0 0                 0
250700 250700 SD     school 4607400 4002   Bon Homme 04-2 460740000065 1 Bon Homme High School   Regular School No High 09 12 2018   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
250777 250777 SD     school 4607800 22001   Bowdle 22-1 460780000069 1 Bowdle High School   Regular School No High 09 12 2018   grade_7 0.0   0.0     0.0             0.0 0.0                       0.0 0   0     0             0 0                 0
250861 250861 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   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
250937 250937 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142000074 1 Bridgewater-Emery High School   Regular School No High 09 12 2018   grade_7 0.0 0.0 0.0                   0.0 0.0                       0.0 0 0 0                   0 0                 0
251012 251012 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2018   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
251015 251015 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School No High 09 12 2018   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
251107 251107 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   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

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