enrollments

Data source: Big Local News · About: Big Local

58,650 rows where state = "OK" sorted by school_state_type descending

✎ 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
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
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
477347 477347 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 07 08 2017   grade_7 80 14 22 28   3     3   7   88 69                       157 80 14 22 28   3     3   7   88 69                 157
477348 477348 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 07 08 2017   grade_8 81 16 22 31   2     1   6   74 85                       159 81 16 22 31   2     1   6   74 85                 159
477349 477349 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 07 08 2017   out_of_home_placement 3 1 1 3   0     0   1   4 5                       9 3 1 1 3   0     0   1   4 5                 9
477350 477350 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2017   grade_5 62 14 15 32   3     0   13   55 84                       139 62 14 15 32   3     0   13   55 84                 139
477351 477351 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2017   grade_6 76 13 17 29   3     1   11   69 81                       150 76 13 17 29   3     1   11   69 81                 150
477352 477352 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2017   out_of_home_placement 3 1 1 1   0     0   0   5 1                       6 3 1 1 1   0     0   0   5 1                 6
477394 477394 OK COMANCHE   school 4012630 16-I004   GERONIMO 401263002732 505 GERONIMO MS Middle Regular School No Middle 07 08 2017   grade_7 9 2 6 3   1     0   2   13 10                       23 9 2 6 3   1     0   2   13 10                 23
477395 477395 OK COMANCHE   school 4012630 16-I004   GERONIMO 401263002732 505 GERONIMO MS Middle Regular School No Middle 07 08 2017   grade_8 11 1 1 3   0     0   8   13 11                       24 11 1 1 3   0     0   8   13 11                 24
477520 477520 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2017   grade_6 119 48 39 18   5     2   17   136 112                       248 119 48 39 18   5     2   17   136 112                 248
477521 477521 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2017   grade_7 115 43 48 17   8     2   28   135 126                       261 115 43 48 17   8     2   28   135 126                 261
477522 477522 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2017   grade_8 128 61 41 15   4     3   21   140 133                       273 128 61 41 15   4     3   21   140 133                 273
477523 477523 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_6 105 61 60 20   3     0   22   133 138                       271 105 61 60 20   3     0   22   133 138                 271
477524 477524 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_7 89 58 59 17   3     2   23   131 120                       251 89 58 59 17   3     2   23   131 120                 251
477525 477525 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_8 80 56 47 19   3     3   13   116 105                       221 80 56 47 19   3     3   13   116 105                 221
477526 477526 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 1 0 0 1   0     0   0   2 0                       2 1 0 0 1   0     0   0   2 0                 2
477527 477527 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2017   grade_6 85 60 56 16   2     2   29   129 121                       250 85 60 56 16   2     2   29   129 121                 250
477528 477528 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2017   grade_7 65 82 50 9   4     0   21   123 108                       231 65 82 50 9   4     0   21   123 108                 231
477529 477529 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2017   grade_8 80 64 53 12   6     1   15   122 109                       231 80 64 53 12   6     1   15   122 109                 231
477530 477530 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_6 91 75 33 18   8     1   24   123 127                       250 91 75 33 18   8     1   24   123 127                 250
477531 477531 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_7 93 100 52 24   9     1   23   157 145                       302 93 100 52 24   9     1   23   157 145                 302
477532 477532 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_8 101 101 38 19   13     2   27   142 159                       301 101 101 38 19   13     2   27   142 159                 301
477567 477567 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_5 97 4 25 18   1     2   17   88 76                       164 97 4 25 18   1     2   17   88 76                 164
477568 477568 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_6 112 7 19 16   0     0   14   78 90                       168 112 7 19 16   0     0   14   78 90                 168
477569 477569 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_7 115 5 29 15   1     1   17   89 94                       183 115 5 29 15   1     1   17   89 94                 183
477570 477570 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_8 103 9 22 17   0     1   19   89 82                       171 103 9 22 17   0     1   19   89 82                 171
477599 477599 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2017   grade_6 32 0 2 10   0     0   6   27 23                       50 32 0 2 10   0     0   6   27 23                 50
477600 477600 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2017   grade_7 25 0 3 5   0     0   11   23 21                       44 25 0 3 5   0     0   11   23 21                 44
477601 477601 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2017   grade_8 22 1 0 9   1     0   7   22 18                       40 22 1 0 9   1     0   7   22 18                 40
477653 477653 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_6 13 1 0 18   1     0   0   14 19                       33 13 1 0 18   1     0   0   14 19                 33
477654 477654 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_7 17 0 0 19   0     0   0   19 17                       36 17 0 0 19   0     0   0   19 17                 36
477655 477655 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_8 27 0 4 21   0     0   1   28 25                       53 27 0 4 21   0     0   1   28 25                 53
477667 477667 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2017   grade_6 14 0 2 9   0     0   0   15 10                       25 14 0 2 9   0     0   0   15 10                 25
477668 477668 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2017   grade_7 12 0 1 5   0     0   0   7 11                       18 12 0 1 5   0     0   0   7 11                 18
477669 477669 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2017   grade_8 5 0 0 16   0     0   0   10 11                       21 5 0 0 16   0     0   0   10 11                 21
477682 477682 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_6 4 0 0 3   1     0   0   4 4                       8 4 0 0 3   1     0   0   4 4                 8
477683 477683 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_7 5 0 0 10   0     0   3   9 9                       18 5 0 0 10   0     0   3   9 9                 18
477684 477684 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_8 4 0 2 9   0     0   2   8 9                       17 4 0 2 9   0     0   2   8 9                 17
477696 477696 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_6 34 1 8 48   0     0   11   65 37                       102 34 1 8 48   0     0   11   65 37                 102
477697 477697 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_7 48 4 2 43   1     0   16   61 53                       114 48 4 2 43   1     0   16   61 53                 114
477698 477698 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_8 55 3 5 33   1     0   15   55 57                       112 55 3 5 33   1     0   15   55 57                 112
477751 477751 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   grade_6 64 7 2 39   1     0   0   51 62                       113 64 7 2 39   1     0   0   51 62                 113
477752 477752 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   grade_7 70 9 3 36   0     0   0   62 56                       118 70 9 3 36   0     0   0   62 56                 118
477753 477753 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   grade_8 77 13 6 43   1     0   0   74 66                       140 77 13 6 43   1     0   0   74 66                 140
477754 477754 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 1 0 0 1   0     0   0   2 0                       2 1 0 0 1   0     0   0   2 0                 2
477767 477767 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2017   grade_6 84 1 3 17   2     0   4   57 54                       111 84 1 3 17   2     0   4   57 54                 111
477768 477768 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2017   grade_7 82 1 2 18   0     0   8   52 59                       111 82 1 2 18   0     0   8   52 59                 111
477769 477769 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2017   grade_8 78 2 4 17   1     1   6   62 47                       109 78 2 4 17   1     1   6   62 47                 109
477810 477810 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2017   grade_7 31 1 9 18   0     0   5   35 29                       64 31 1 9 18   0     0   5   35 29                 64
477811 477811 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2017   grade_8 31 2 3 9   0     0   1   21 25                       46 31 2 3 9   0     0   1   21 25                 46
477812 477812 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 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
477854 477854 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_7 46 0 1 17   0     0   16   44 36                       80 46 0 1 17   0     0   16   44 36                 80
477855 477855 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_8 48 0 7 13   0     0   12   42 38                       80 48 0 7 13   0     0   12   42 38                 80
477888 477888 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_6 132 15 26 41   1     0   30   122 123                       245 132 15 26 41   1     0   30   122 123                 245
477889 477889 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_7 152 6 21 42   0     0   48   128 141                       269 152 6 21 42   0     0   48   128 141                 269
477904 477904 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 07 08 2017   grade_7 21 1 2 2   0     0   1   16 11                       27 21 1 2 2   0     0   1   16 11                 27
477905 477905 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 07 08 2017   grade_8 32 1 1 6   1     0   5   21 25                       46 32 1 1 6   1     0   5   21 25                 46
477946 477946 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_6 99 1 30 1   0     0   13   63 81                       144 99 1 30 1   0     0   13   63 81                 144
477947 477947 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_7 88 1 27 13   2     0   22   77 76                       153 88 1 27 13   2     0   22   77 76                 153
477948 477948 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_8 107 2 25 6   0     0   15   71 84                       155 107 2 25 6   0     0   15   71 84                 155
477962 477962 OK CUSTER   school 4008070 20-I099   CLINTON 400807000339 505 CLINTON MS Middle Regular School No Middle 07 08 2017   grade_7 53 5 85 15   2     0   9   82 87                       169 53 5 85 15   2     0   9   82 87                 169
477963 477963 OK CUSTER   school 4008070 20-I099   CLINTON 400807000339 505 CLINTON MS Middle Regular School No Middle 07 08 2017   grade_8 56 2 83 11   2     0   14   83 85                       168 56 2 83 11   2     0   14   83 85                 168
478014 478014 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_6 39 1 15 61   7     0   15   65 73                       138 39 1 15 61   7     0   15   65 73                 138
478015 478015 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_7 41 0 4 49   4     0   16   65 49                       114 41 0 4 49   4     0   16   65 49                 114
478016 478016 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_8 31 0 14 40   5     0   20   57 53                       110 31 0 14 40   5     0   20   57 53                 110
478017 478017 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
478031 478031 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2017   grade_7 101 3 9 62   0     2   1   96 82                       178 101 3 9 62   0     2   1   96 82                 178
478032 478032 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2017   grade_8 106 2 14 65   2     0   1   93 97                       190 106 2 14 65   2     0   1   93 97                 190
478045 478045 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_6 19 1 0 45   1     0   1   29 38                       67 19 1 0 45   1     0   1   29 38                 67
478046 478046 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_7 24 1 0 28   0     0   2   25 30                       55 24 1 0 28   0     0   2   25 30                 55
478047 478047 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_8 24 0 1 29   3     0   2   31 28                       59 24 0 1 29   3     0   2   31 28                 59
478048 478048 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 2 1 0 2   0     0   0   5 0                       5 2 1 0 2   0     0   0   5 0                 5
478209 478209 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2017   grade_6 78 0 5 2   1     0   0   38 48                       86 78 0 5 2   1     0   0   38 48                 86
478210 478210 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2017   grade_7 68 3 6 0   2     0   0   38 41                       79 68 3 6 0   2     0   0   38 41                 79
478211 478211 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2017   grade_8 69 1 10 6   2     0   0   37 51                       88 69 1 10 6   2     0   0   37 51                 88
478324 478324 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_6 75 4 41 0   1     7   6   72 62                       134 75 4 41 0   1     7   6   72 62                 134
478325 478325 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_7 76 3 50 1   2     9   13   83 71                       154 76 3 50 1   2     9   13   83 71                 154
478326 478326 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_8 72 9 22 2   0     14   4   61 62                       123 72 9 22 2   0     14   4   61 62                 123
478327 478327 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 5 1 1 1   0     0   0   4 4                       8 5 1 1 1   0     0   0   4 4                 8
478328 478328 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_6 61 3 69 3   0     38   17   86 105                       191 61 3 69 3   0     38   17   86 105                 191
478329 478329 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 46 11 77 2   1     37   13   94 93                       187 46 11 77 2   1     37   13   94 93                 187
478330 478330 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_8 57 6 52 6   2     27   7   77 80                       157 57 6 52 6   2     27   7   77 80                 157
478331 478331 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_6 171 10 35 7   2     5   27   136 121                       257 171 10 35 7   2     5   27   136 121                 257
478332 478332 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_7 147 9 29 8   8     11   20   124 108                       232 147 9 29 8   8     11   20   124 108                 232
478333 478333 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_8 156 9 36 6   8     12   19   123 123                       246 156 9 36 6   8     12   19   123 123                 246
478384 478384 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2017   grade_6 35 0 1 16   0     0   0   26 26                       52 35 0 1 16   0     0   0   26 26                 52
478385 478385 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2017   grade_7 32 0 1 13   0     0   1   17 30                       47 32 0 1 13   0     0   1   17 30                 47
478386 478386 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2017   grade_8 35 0 0 17   0     0   1   29 24                       53 35 0 0 17   0     0   1   29 24                 53
478428 478428 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_6 59 0 9 7   0     0   0   38 37                       75 59 0 9 7   0     0   0   38 37                 75
478429 478429 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_7 61 0 9 17   1     0   2   48 42                       90 61 0 9 17   1     0   2   48 42                 90
478430 478430 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_8 60 0 6 14   0     0   0   44 36                       80 60 0 6 14   0     0   0   44 36                 80
478431 478431 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 1 0 0 1   0     0   0   0 2                       2 1 0 0 1   0     0   0   0 2                 2
478456 478456 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_5 39 7 3 8   0     1   0   22 36                       58 39 7 3 8   0     1   0   22 36                 58
478457 478457 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_6 32 5 4 5   0     0   3   34 15                       49 32 5 4 5   0     0   3   34 15                 49
478458 478458 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_7 30 1 1 11   1     0   4   24 24                       48 30 1 1 11   1     0   4   24 24                 48
478459 478459 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_8 31 1 4 9   0     0   2   26 21                       47 31 1 4 9   0     0   2   26 21                 47
478519 478519 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2017   grade_7 85 20 22 18   1     0   9   77 78                       155 85 20 22 18   1     0   9   77 78                 155
478520 478520 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2017   grade_8 90 10 19 17   1     0   7   74 70                       144 90 10 19 17   1     0   7   74 70                 144

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