enrollments

Data source: Big Local News · About: Big Local

58,650 rows where state = "OK"

✎ View and edit SQL

This data as json, CSV (advanced)

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
477220 477220 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_6 157 15 23 12   8     1   31   145 102                       247 157 15 23 12   8     1   31   145 102                 247
477221 477221 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 165 17 22 11   4     0   24   119 124                       243 165 17 22 11   4     0   24   119 124                 243
477222 477222 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_8 146 24 23 10   4     0   39   133 113                       246 146 24 23 10   4     0   39   133 113                 246
477223 477223 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_6 231 11 55 16   10     0   47   199 171                       370 231 11 55 16   10     0   47   199 171                 370
477224 477224 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_7 235 18 47 18   23     0   44   185 200                       385 235 18 47 18   23     0   44   185 200                 385
477225 477225 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_8 245 15 41 16   9     0   31   178 179                       357 245 15 41 16   9     0   31   178 179                 357
477226 477226 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001082 705 NORMAN HS High School Regular School No High 09 12 2017   grade_10 297 44 67 38   12     0   68   275 251                       526 297 44 67 38   12     0   68   275 251                 526
477227 477227 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001082 705 NORMAN HS High School Regular School No High 09 12 2017   grade_11 296 39 75 33   8     1   63   253 262                       515 296 39 75 33   8     1   63   253 262                 515
477228 477228 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001082 705 NORMAN HS High School Regular School No High 09 12 2017   grade_12 278 36 48 22   13     0   66   228 235                       463 278 36 48 22   13     0   66   228 235                 463
477229 477229 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001082 705 NORMAN HS High School Regular School No High 09 12 2017   grade_9 289 43 88 44   8     1   70   288 255                       543 289 43 88 44   8     1   70   288 255                 543
477230 477230 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_10 404 24 60 28   27     0   85   320 308                       628 404 24 60 28   27     0   85   320 308                 628
477231 477231 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_11 355 24 61 21   23     1   66   300 251                       551 355 24 61 21   23     1   66   300 251                 551
477232 477232 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_12 349 16 51 34   22     0   58   240 290                       530 349 16 51 34   22     0   58   240 290                 530
477233 477233 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_7 1 0 0 1   0     0   0   2 0                       2 1 0 0 1   0     0   0   2 0                 2
477234 477234 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_9 399 31 91 24   26     1   67   334 305                       639 399 31 91 24   26     1   67   334 305                 639
477235 477235 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002710 740 DIMENSIONS ACADEMY High School Regular School No High 09 12 2017   grade_10 14 2 2 4   0     0   3   12 13                       25 14 2 2 4   0     0   3   12 13                 25
477236 477236 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002710 740 DIMENSIONS ACADEMY High School Regular School No High 09 12 2017   grade_11 12 3 3 3   0     0   5   11 15                       26 12 3 3 3   0     0   5   11 15                 26
477237 477237 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002710 740 DIMENSIONS ACADEMY High School Regular School No High 09 12 2017   grade_12 15 3 5 2   1     0   2   12 16                       28 15 3 5 2   1     0   2   12 16                 28
477238 477238 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002710 740 DIMENSIONS ACADEMY High School Regular School No High 09 12 2017   grade_9 16 6 1 1   0     0   8   18 14                       32 16 6 1 1   0     0   8   18 14                 32
477239 477239 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002710 740 DIMENSIONS ACADEMY High School Regular School No High 09 12 2017   out_of_home_placement 69 30 15 17   0     0   12   103 40                       143 69 30 15 17   0     0   12   103 40                 143
477240 477240 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001063 105 KATHERINE I. DAILY ES Elementary Regular School No Elementary PK 01 2017   grade_1 173 1 18 23   1     1   12   120 109                       229 173 1 18 23   1     1   12   120 109                 229
477241 477241 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001063 105 KATHERINE I. DAILY ES Elementary Regular School No Elementary PK 01 2017   kindergarten_full_day 138 1 10 14   0     0   14   101 76                       177 138 1 10 14   0     0   14   101 76                 177
477242 477242 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001063 105 KATHERINE I. DAILY ES Elementary Regular School No Elementary PK 01 2017   kindergarten_half_day 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
477243 477243 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001063 105 KATHERINE I. DAILY ES Elementary Regular School No Elementary PK 01 2017   pre_kindergarten_full_day 90 1 11 8   0     0   21   66 65                       131 90 1 11 8   0     0   21   66 65                 131
477244 477244 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001063 105 KATHERINE I. DAILY ES Elementary Regular School No Elementary PK 01 2017   pre_kindergarten_half_day 3 0 0 0   0     0   0   1 2                       3 3 0 0 0   0     0   0   1 2                 3
477245 477245 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001066 110 PIONEER INTERMEDIATE ES Elementary Regular School No Elementary 04 05 2017   grade_4 127 11 15 37   2     0   3   95 100                       195 127 11 15 37   2     0   3   95 100                 195
477246 477246 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001066 110 PIONEER INTERMEDIATE ES Elementary Regular School No Elementary 04 05 2017   grade_5 157 5 18 34   0     0   4   114 104                       218 157 5 18 34   0     0   4   114 104                 218
477247 477247 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001923 115 JOHN K. HUBBARD ES Elementary Regular School No Elementary 02 03 2017   grade_2 160 3 23 23   3     2   5   109 110                       219 160 3 23 23   3     2   5   109 110                 219
477248 477248 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001923 115 JOHN K. HUBBARD ES Elementary Regular School No Elementary 02 03 2017   grade_3 170 5 23 32   1     0   4   121 114                       235 170 5 23 32   1     0   4   121 114                 235
477249 477249 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2017   grade_6 153 2 8 30   0     0   4   106 91                       197 153 2 8 30   0     0   4   106 91                 197
477250 477250 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2017   grade_7 153 3 10 38   4     1   6   113 102                       215 153 3 10 38   4     1   6   113 102                 215
477251 477251 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2017   grade_8 169 7 11 21   1     0   3   113 99                       212 169 7 11 21   1     0   3   113 99                 212
477252 477252 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001064 705 NOBLE HS High School Regular School No High 09 12 2017   grade_10 155 8 11 27   3     0   1   112 93                       205 155 8 11 27   3     0   1   112 93                 205
477253 477253 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001064 705 NOBLE HS High School Regular School No High 09 12 2017   grade_11 166 1 10 34   5     0   1   109 108                       217 166 1 10 34   5     0   1   109 108                 217
477254 477254 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001064 705 NOBLE HS High School Regular School No High 09 12 2017   grade_12 153 6 11 30   3     0   2   121 84                       205 153 6 11 30   3     0   2   121 84                 205
477255 477255 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001064 705 NOBLE HS High School Regular School No High 09 12 2017   grade_9 145 5 17 32   1     0   1   94 107                       201 145 5 17 32   1     0   1   94 107                 201
477256 477256 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   grade_1 51 0 15 5   0     0   15   42 44                       86 51 0 15 5   0     0   15   42 44                 86
477257 477257 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   grade_2 45 0 11 6   0     0   10   32 40                       72 45 0 11 6   0     0   10   32 40                 72
477258 477258 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   grade_3 49 0 15 5   0     0   17   35 51                       86 49 0 15 5   0     0   17   35 51                 86
477259 477259 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   grade_4 65 0 9 7   0     0   19   55 45                       100 65 0 9 7   0     0   19   55 45                 100
477260 477260 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   grade_5 66 0 5 11   0     0   10   42 50                       92 66 0 5 11   0     0   10   42 50                 92
477261 477261 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 41 0 8 3   0     0   12   33 31                       64 41 0 8 3   0     0   12   33 31                 64
477262 477262 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000853 105 LEXINGTON ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 39 0 5 6   0     0   5   30 25                       55 39 0 5 6   0     0   5   30 25                 55
477263 477263 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2017   grade_6 43 1 6 10   0     0   5   33 32                       65 43 1 6 10   0     0   5   33 32                 65
477264 477264 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2017   grade_7 57 0 10 11   1     0   3   44 38                       82 57 0 10 11   1     0   3   44 38                 82
477265 477265 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2017   grade_8 61 1 9 10   0     0   5   45 41                       86 61 1 9 10   0     0   5   45 41                 86
477266 477266 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000854 705 LEXINGTON HS High School Regular School No High 09 12 2017   grade_10 60 0 7 6   1     0   2   39 37                       76 60 0 7 6   1     0   2   39 37                 76
477267 477267 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000854 705 LEXINGTON HS High School Regular School No High 09 12 2017   grade_11 61 2 6 12   0     0   3   40 44                       84 61 2 6 12   0     0   3   40 44                 84
477268 477268 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000854 705 LEXINGTON HS High School Regular School No High 09 12 2017   grade_12 50 0 9 7   0     0   2   40 28                       68 50 0 9 7   0     0   2   40 28                 68
477269 477269 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758000854 705 LEXINGTON HS High School Regular School No High 09 12 2017   grade_9 65 2 11 11   0     0   8   56 41                       97 65 2 11 11   0     0   8   56 41                 97
477270 477270 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   grade_1 65 0 7 16   0     0   14   44 58                       102 65 0 7 16   0     0   14   44 58                 102
477271 477271 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   grade_2 63 0 9 7   0     0   12   45 46                       91 63 0 9 7   0     0   12   45 46                 91
477272 477272 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   grade_3 71 0 10 13   0     1   17   61 51                       112 71 0 10 13   0     1   17   61 51                 112
477273 477273 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   grade_4 55 0 9 11   0     0   11   48 38                       86 55 0 9 11   0     0   11   48 38                 86
477274 477274 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   grade_5 52 1 3 9   0     0   7   47 25                       72 52 1 3 9   0     0   7   47 25                 72
477275 477275 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 48 0 5 17   0     0   15   43 42                       85 48 0 5 17   0     0   15   43 42                 85
477276 477276 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000864 105 LITTLE AXE ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 51 1 0 12   0     0   12   37 39                       76 51 1 0 12   0     0   12   37 39                 76
477277 477277 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2017   grade_6 74 0 5 12   0     0   10   50 51                       101 74 0 5 12   0     0   10   50 51                 101
477278 477278 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2017   grade_7 58 0 7 15   0     0   12   55 37                       92 58 0 7 15   0     0   12   55 37                 92
477279 477279 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2017   grade_8 59 0 11 17   1     1   17   65 41                       106 59 0 11 17   1     1   17   65 41                 106
477280 477280 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788002206 715 LITTLE AXE HS High School Regular School No High 09 12 2017   grade_10 70 0 5 31   0     1   8   60 55                       115 70 0 5 31   0     1   8   60 55                 115
477281 477281 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788002206 715 LITTLE AXE HS High School Regular School No High 09 12 2017   grade_11 48 0 9 18   0     0   9   44 40                       84 48 0 9 18   0     0   9   44 40                 84
477282 477282 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788002206 715 LITTLE AXE HS High School Regular School No High 09 12 2017   grade_12 39 2 6 10   0     0   14   33 38                       71 39 2 6 10   0     0   14   33 38                 71
477283 477283 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788002206 715 LITTLE AXE HS High School Regular School No High 09 12 2017   grade_9 61 0 10 18   0     0   14   51 52                       103 61 0 10 18   0     0   14   51 52                 103
477284 477284 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 13 0 2 11   0     0   3   14 15                       29 13 0 2 11   0     0   3   14 15                 29
477285 477285 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 10 0 2 6   0     0   5   13 10                       23 10 0 2 6   0     0   5   13 10                 23
477286 477286 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 8 0 0 3   0     0   6   5 12                       17 8 0 0 3   0     0   6   5 12                 17
477287 477287 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 7 0 0 6   0     0   5   8 10                       18 7 0 0 6   0     0   5   8 10                 18
477288 477288 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 5 0 0 4   0     0   7   10 6                       16 5 0 0 4   0     0   7   10 6                 16
477289 477289 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 8 0 0 1   0     0   2   5 6                       11 8 0 0 1   0     0   2   5 6                 11
477290 477290 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 1 1 7   0     0   7   12 8                       20 4 1 1 7   0     0   7   12 8                 20
477291 477291 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 7 1 0 2   0     0   2   8 4                       12 7 1 0 2   0     0   2   8 4                 12
477292 477292 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 11 0 1 12   0     0   5   18 11                       29 11 0 1 12   0     0   5   18 11                 29
477293 477293 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 9 0 2 15   0     0   4   16 14                       30 9 0 2 15   0     0   4   16 14                 30
477294 477294 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   grade_1 18 0 5 18   0     0   5   24 22                       46 18 0 5 18   0     0   5   24 22                 46
477295 477295 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   grade_2 21 0 7 18   0     0   7   24 29                       53 21 0 7 18   0     0   7   24 29                 53
477296 477296 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   grade_3 20 0 4 17   0     0   6   23 24                       47 20 0 4 17   0     0   6   23 24                 47
477297 477297 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   grade_4 26 1 4 19   0     0   1   32 19                       51 26 1 4 19   0     0   1   32 19                 51
477298 477298 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   grade_5 24 0 2 18   0     0   3   22 25                       47 24 0 2 18   0     0   3   22 25                 47
477299 477299 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   grade_6 14 0 6 17   1     0   2   27 13                       40 14 0 6 17   1     0   2   27 13                 40
477300 477300 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 17 0 2 15   0     0   5   23 16                       39 17 0 2 15   0     0   5   23 16                 39
477301 477301 OK COAL   school 4008130 15-I001   COALGATE 400813000341 105 EMERSON ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 21 0 2 20   0     0   2   26 19                       45 21 0 2 20   0     0   2   26 19                 45
477302 477302 OK COAL   school 4008130 15-I001   COALGATE 400813001958 505 WALLACE BYRD MS Middle Regular School No Middle 07 08 2017   grade_7 25 0 6 16   0     0   1   26 22                       48 25 0 6 16   0     0   1   26 22                 48
477303 477303 OK COAL   school 4008130 15-I001   COALGATE 400813001958 505 WALLACE BYRD MS Middle Regular School No Middle 07 08 2017   grade_8 18 1 5 28   1     0   1   37 17                       54 18 1 5 28   1     0   1   37 17                 54
477304 477304 OK COAL   school 4008130 15-I001   COALGATE 400813002063 705 COALGATE HS High School Regular School No High 09 12 2017   grade_10 32 0 3 17   0     0   1   28 25                       53 32 0 3 17   0     0   1   28 25                 53
477305 477305 OK COAL   school 4008130 15-I001   COALGATE 400813002063 705 COALGATE HS High School Regular School No High 09 12 2017   grade_11 24 0 3 17   0     0   2   23 23                       46 24 0 3 17   0     0   2   23 23                 46
477306 477306 OK COAL   school 4008130 15-I001   COALGATE 400813002063 705 COALGATE HS High School Regular School No High 09 12 2017   grade_12 28 0 3 19   2     0   7   28 31                       59 28 0 3 19   2     0   7   28 31                 59
477307 477307 OK COAL   school 4008130 15-I001   COALGATE 400813002063 705 COALGATE HS High School Regular School No High 09 12 2017   grade_9 35 2 0 26   0     0   2   32 33                       65 35 2 0 26   0     0   2   32 33                 65
477308 477308 OK COAL   school 4008130 15-I001   COALGATE 400813002063 705 COALGATE HS High School Regular School No High 09 12 2017   out_of_home_placement 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
477309 477309 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_1 5 0 0 7   0     0   2   5 9                       14 5 0 0 7   0     0   2   5 9                 14
477310 477310 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_2 5 0 0 7   0     0   6   10 8                       18 5 0 0 7   0     0   6   10 8                 18
477311 477311 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_3 4 0 3 5   0     0   2   5 9                       14 4 0 3 5   0     0   2   5 9                 14
477312 477312 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_4 10 0 0 4   0     0   4   12 6                       18 10 0 0 4   0     0   4   12 6                 18
477313 477313 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_5 3 0 0 8   1     0   7   10 9                       19 3 0 0 8   1     0   7   10 9                 19
477314 477314 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_6 9 0 1 5   0     0   2   11 6                       17 9 0 1 5   0     0   2   11 6                 17
477315 477315 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 1 8   0     0   3   14 15                       29 17 0 1 8   0     0   3   14 15                 29
477316 477316 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_8 8 0 3 9   0     0   3   10 13                       23 8 0 3 9   0     0   3   10 13                 23
477317 477317 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 8 0 1 6   0     0   4   9 10                       19 8 0 1 6   0     0   4   9 10                 19
477318 477318 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 11 0 1 8   0     0   0   12 8                       20 11 0 1 8   0     0   0   12 8                 20
477319 477319 OK COAL   school 4030270 15-I002   TUPELO 403027001684 705 TUPELO HS High School Regular School No High 09 12 2017   grade_10 8 0 0 5   1     0   6   9 11                       20 8 0 0 5   1     0   6   9 11                 20

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