Data source: Big Local News · About: Big Local

11,652 rows where state = "OK" and year = 2020 sorted by school_state_type descending

View and edit SQL

year

  • 2020 · 11,652
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
3025322 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2020   grade_5 11 0 25 43   0     0   1   40 40                       80 11 0 25 43   0     0   1   40 40                 80
3025323 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2020   grade_6 4 0 11 54   0     0   0   36 33                       69 4 0 11 54   0     0   0   36 33                 69
3025324 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2020   grade_7 8 0 21 35   0     0   1   32 33                       65 8 0 21 35   0     0   1   32 33                 65
3025325 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2020   grade_8 6 0 14 35   0     0   0   23 32                       55 6 0 14 35   0     0   0   23 32                 55
3025336 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_5 1 0 0 10   0     0   0   6 5                       11 1 0 0 10   0     0   0   6 5                 11
3025337 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_6 0 0 0 6   0     0   0   5 1                       6 0 0 0 6   0     0   0   5 1                 6
3025338 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_7 2 0 0 9   0     0   0   4 7                       11 2 0 0 9   0     0   0   4 7                 11
3025339 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_8 0 0 0 3   0     0   0   2 1                       3 0 0 0 3   0     0   0   2 1                 3
3025367 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2020   grade_6 20 0 9 0   0     0   0   13 16                       29 20 0 9 0   0     0   0   13 16                 29
3025368 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2020   grade_7 23 0 5 0   0     0   2   13 17                       30 23 0 5 0   0     0   2   13 17                 30
3025369 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2020   grade_8 18 1 3 0   0     0   2   10 14                       24 18 1 3 0   0     0   2   10 14                 24
3025557 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2020   grade_6 43 0 6 0   0     0   10   35 24                       59 43 0 6 0   0     0   10   35 24                 59
3025558 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2020   grade_7 32 0 5 1   1     0   3   16 26                       42 32 0 5 1   1     0   3   16 26                 42
3025559 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2020   grade_8 31 0 6 1   0     0   2   18 22                       40 31 0 6 1   0     0   2   18 22                 40
3025599 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2020   grade_6 23 2 10 8   0     0   8   27 24                       51 23 2 10 8   0     0   8   27 24                 51
3025600 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2020   grade_7 27 3 14 7   0     0   7   27 31                       58 27 3 14 7   0     0   7   27 31                 58
3025601 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2020   grade_8 26 4 11 5   0     0   8   19 35                       54 26 4 11 5   0     0   8   19 35                 54
3025613 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2020   grade_6 10 1 3 15   0     0   0   17 12                       29 10 1 3 15   0     0   0   17 12                 29
3025614 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2020   grade_7 12 1 3 13   0     0   1   16 14                       30 12 1 3 13   0     0   1   16 14                 30
3025615 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2020   grade_8 9 0 6 7   0     0   1   10 13                       23 9 0 6 7   0     0   1   10 13                 23
3025642 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2020   grade_6 41 0 4 19   1     0   11   50 26                       76 41 0 4 19   1     0   11   50 26                 76
3025643 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2020   grade_7 47 0 6 19   0     0   7   39 40                       79 47 0 6 19   0     0   7   39 40                 79
3025644 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2020   grade_8 48 0 6 13   0     0   5   33 39                       72 48 0 6 13   0     0   5   33 39                 72
3025685 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2020   grade_7 27 2 8 15   0     0   4   25 31                       56 27 2 8 15   0     0   4   25 31                 56
3025686 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2020   grade_8 27 0 5 14   0     0   1   21 26                       47 27 0 5 14   0     0   1   21 26                 47
3025746 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2020   grade_7 119 10 39 55   2     0   23   116 132                       248 119 10 39 55   2     0   23   116 132                 248
3025747 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2020   grade_8 125 9 39 56   0     0   19   115 133                       248 125 9 39 56   0     0   19   115 133                 248
3025759 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2020   grade_6 27 0 4 0   0     0   3   12 22                       34 27 0 4 0   0     0   3   12 22                 34
3025760 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2020   grade_7 24 0 10 1   0     0   1   13 23                       36 24 0 10 1   0     0   1   13 23                 36
3025761 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2020   grade_8 19 1 8 1   0     0   0   16 13                       29 19 1 8 1   0     0   0   16 13                 29
3025788 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2020   grade_6 21 4 22 73   0     0   0   58 62                       120 21 4 22 73   0     0   0   58 62                 120
3025789 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2020   grade_7 16 6 12 75   3     0   0   52 60                       112 16 6 12 75   3     0   0   52 60                 112
3025790 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2020   grade_8 17 3 22 71   0     0   0   55 58                       113 17 3 22 71   0     0   0   55 58                 113
3025802 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2020   grade_6 16 0 9 10   0     0   8   24 19                       43 16 0 9 10   0     0   8   24 19                 43
3025803 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2020   grade_7 11 0 5 13   0     0   8   18 19                       37 11 0 5 13   0     0   8   18 19                 37
3025804 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2020   grade_8 14 0 3 13   0     0   4   17 17                       34 14 0 3 13   0     0   4   17 17                 34
3025817 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2020   grade_6 16 0 6 17   0     0   5   20 24                       44 16 0 6 17   0     0   5   20 24                 44
3025818 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2020   grade_7 9 0 5 7   0     0   7   19 9                       28 9 0 5 7   0     0   7   19 9                 28
3025819 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2020   grade_8 17 0 4 13   0     0   1   16 19                       35 17 0 4 13   0     0   1   16 19                 35
3025887 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2020   grade_6 10 2 0 10   0     0   3   14 11                       25 10 2 0 10   0     0   3   14 11                 25
3025888 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2020   grade_7 16 1 2 6   0     0   4   12 17                       29 16 1 2 6   0     0   4   12 17                 29
3025889 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2020   grade_8 20 0 2 3   0     0   2   16 11                       27 20 0 2 3   0     0   2   16 11                 27
3025969 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2020   grade_7 222 11 34 22   18     0   20   151 176                       327 222 11 34 22   18     0   20   151 176                 327
3025970 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2020   grade_8 231 10 38 28   9     1   18   166 169                       335 231 10 38 28   9     1   18   166 169                 335
3025971 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2020   out_of_home_placement 0 1 1 1   0     0   0   1 2                       3 0 1 1 1   0     0   0   1 2                 3
3026020 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2020   grade_6 440 25 113 21   14     1   61   346 329                       675 440 25 113 21   14     1   61   346 329                 675
3026021 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2020   grade_7 457 20 135 28   16     0   74   355 375                       730 457 20 135 28   16     0   74   355 375                 730
3026022 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2020   grade_8 426 26 106 28   20     1   56   341 322                       663 426 26 106 28   20     1   56   341 322                 663
3026033 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2020   grade_5 107 8 49 24   0     0   17   115 90                       205 107 8 49 24   0     0   17   115 90                 205
3026034 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2020   grade_6 106 6 64 22   1     0   20   115 104                       219 106 6 64 22   1     0   20   115 104                 219
3026117 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2020   grade_7 243 11 45 25   4     1   38   170 197                       367 243 11 45 25   4     1   38   170 197                 367
3026118 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2020   grade_8 255 9 67 23   4     0   25   195 188                       383 255 9 67 23   4     0   25   195 188                 383
3026119 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2020   out_of_home_placement 1 0 0 1   0     0   0   0 2                       2 1 0 0 1   0     0   0   0 2                 2
3026120 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2020   grade_7 176 23 52 15   36     2   32   161 175                       336 176 23 52 15   36     2   32   161 175                 336
3026121 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2020   grade_8 193 23 46 12   24     1   29   157 171                       328 193 23 46 12   24     1   29   157 171                 328
3026122 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002881 525 MUSTANG CENTRAL MS Middle Regular School No Middle 07 08 2020   grade_7 173 14 34 14   16     3   34   156 132                       288 173 14 34 14   16     3   34   156 132                 288
3026123 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002881 525 MUSTANG CENTRAL MS Middle Regular School No Middle 07 08 2020   grade_8 137 15 32 9   7     0   27   114 113                       227 137 15 32 9   7     0   27   114 113                 227
3026170 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2020   grade_6 74 40 47 20   4     0   45   113 117                       230 74 40 47 20   4     0   45   113 117                 230
3026171 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2020   grade_7 98 29 34 19   0     0   38   113 105                       218 98 29 34 19   0     0   38   113 105                 218
3026172 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2020   grade_8 74 28 42 19   1     0   22   87 99                       186 74 28 42 19   1     0   22   87 99                 186
3026198 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2020   grade_6 65 2 19 10   7     0   13   55 61                       116 65 2 19 10   7     0   13   55 61                 116
3026199 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2020   grade_7 74 2 7 13   4     0   12   57 55                       112 74 2 7 13   4     0   12   57 55                 112
3026200 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2020   grade_8 67 1 12 15   7     0   11   58 55                       113 67 1 12 15   7     0   11   58 55                 113
3026213 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2020   grade_6 70 2 13 17   0     0   10   62 50                       112 70 2 13 17   0     0   10   62 50                 112
3026214 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2020   grade_7 70 2 9 24   1     1   9   60 56                       116 70 2 9 24   1     1   9   60 56                 116
3026215 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2020   grade_8 72 3 10 17   0     0   11   55 58                       113 72 3 10 17   0     0   11   55 58                 113
3026241 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2020   grade_6 17 0 3 4   0     0   5   16 13                       29 17 0 3 4   0     0   5   16 13                 29
3026242 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2020   grade_7 28 0 5 1   1     0   3   19 19                       38 28 0 5 1   1     0   3   19 19                 38
3026243 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2020   grade_8 24 0 3 2   0     0   9   25 13                       38 24 0 3 2   0     0   9   25 13                 38
3026269 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2020   grade_6 55 0 6 18   0     0   14   48 45                       93 55 0 6 18   0     0   14   48 45                 93
3026270 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2020   grade_7 48 2 16 18   1     0   22   61 46                       107 48 2 16 18   1     0   22   61 46                 107
3026271 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2020   grade_8 56 0 5 18   1     0   18   51 47                       98 56 0 5 18   1     0   18   51 47                 98
3026379 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2020   grade_6 12 0 2 23   0     0   2   17 22                       39 12 0 2 23   0     0   2   17 22                 39
3026380 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2020   grade_7 10 0 5 25   0     0   4   22 22                       44 10 0 5 25   0     0   4   22 22                 44
3026381 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2020   grade_8 11 0 5 28   0     0   1   24 21                       45 11 0 5 28   0     0   1   24 21                 45
3026406 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2020   grade_6 36 6 46 99   1     0   50   108 130                       238 36 6 46 99   1     0   50   108 130                 238
3026407 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2020   grade_7 62 2 56 74   2     0   41   118 119                       237 62 2 56 74   2     0   41   118 119                 237
3026408 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2020   grade_8 58 1 44 99   0     0   29   117 114                       231 58 1 44 99   0     0   29   117 114                 231
3026409 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2020   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3026433 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2020   grade_7 7 0 3 9   0     0   2   12 9                       21 7 0 3 9   0     0   2   12 9                 21
3026434 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2020   grade_8 10 2 1 10   0     0   2   17 8                       25 10 2 1 10   0     0   2   17 8                 25
3026474 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2020   grade_6 23 26 3 19   1     0   13   45 40                       85 23 26 3 19   1     0   13   45 40                 85
3026475 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2020   grade_7 23 20 9 22   1     0   13   33 55                       88 23 20 9 22   1     0   13   33 55                 88
3026476 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2020   grade_8 39 23 4 15   0     0   8   51 38                       89 39 23 4 15   0     0   8   51 38                 89
3026489 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2020   grade_7 12 0 13 0   0     0   1   10 16                       26 12 0 13 0   0     0   1   10 16                 26
3026490 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2020   grade_8 8 0 7 0   0     0   0   10 5                       15 8 0 7 0   0     0   0   10 5                 15
3026917 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2020   grade_6 159 26 43 13   7     0   45   156 137                       293 159 26 43 13   7     0   45   156 137                 293
3026918 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2020   grade_7 153 39 34 15   14     2   50   157 150                       307 153 39 34 15   14     2   50   157 150                 307
3026919 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2020   grade_8 118 30 34 10   7     1   42   136 106                       242 118 30 34 10   7     1   42   136 106                 242
3026920 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2020   grade_6 140 11 50 12   2     0   41   131 125                       256 140 11 50 12   2     0   41   131 125                 256
3026921 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2020   grade_7 121 20 53 9   2     0   39   127 117                       244 121 20 53 9   2     0   39   127 117                 244
3026922 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2020   grade_8 136 7 59 11   3     0   32   126 122                       248 136 7 59 11   3     0   32   126 122                 248
3026923 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2020   grade_6 141 14 29 14   4     0   38   125 115                       240 141 14 29 14   4     0   38   125 115                 240
3026924 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2020   grade_7 164 18 29 16   3     1   35   151 115                       266 164 18 29 16   3     1   35   151 115                 266
3026925 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2020   grade_8 168 16 31 9   6     0   35   152 113                       265 168 16 31 9   6     0   35   152 113                 265
3026926 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2020   grade_6 210 13 61 12   32     0   49   193 184                       377 210 13 61 12   32     0   49   193 184                 377
3026927 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2020   grade_7 263 21 54 7   17     0   38   198 202                       400 263 21 54 7   17     0   38   198 202                 400
3026928 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2020   grade_8 241 15 62 10   18     0   64   217 193                       410 241 15 62 10   18     0   64   217 193                 410
3026950 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2020   grade_6 166 3 27 25   0     0   15   124 112                       236 166 3 27 25   0     0   15   124 112                 236
3026951 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2020   grade_7 134 9 17 32   2     0   11   106 99                       205 134 9 17 32   2     0   11   106 99                 205

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