Data source: Big Local News · About: Big Local

11,826 rows where state = "OK" and year = 2017 sorted by ccd_school_high_grade descending

View and edit SQL

year

  • 2017 · 11,826
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
476246 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002114 110 PIEDMONT PRIMARY ES Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 199 5 25 12   4     1   12   126 132                       258 199 5 25 12   4     1   12   126 132                 258
476375 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002358 130 MUSTANG EDUCATION CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 187 5 26 17   17     0   37   162 127                       289 187 5 26 17   17     0   37   162 127                 289
476660 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001543 115 SEQUOYAH ES Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 59 3 40 68   2     0   60   115 117                       232 59 3 40 68   2     0   60   115 117                 232
477470 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000820 160 BEGINNINGS ACADEMY Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 60 80 49 11   0     0   43   120 123                       243 60 80 49 11   0     0   43   120 123                 243
477471 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000820 160 BEGINNINGS ACADEMY Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 6 4 6 2   1     0   2   8 13                       21 6 4 6 2   1     0   2   8 13                 21
477506 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000835 200 LEARNING TREE ACADEMY Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 68 34 44 10   3     0   44   117 86                       203 68 34 44 10   3     0   44   117 86                 203
478252 OK GARFIELD   school 4010920 24-I057   ENID 401092002805 115 CARVER EARLY CHILDHOOD CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 56 9 48 3   1     34   21   84 88                       172 56 9 48 3   1     34   21   84 88                 172
479163 OK KAY   school 4024690 36-I071   PONCA CITY 402469002834 117 WASHINGTON PRE KG CENTER Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 160 8 22 22   1     4   31   133 115                       248 160 8 22 22   1     4   31   133 115                 248
479164 OK KAY   school 4024690 36-I071   PONCA CITY 402469002834 117 WASHINGTON PRE KG CENTER Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 8 1 2 3   0     0   2   14 2                       16 8 1 2 3   0     0   2   14 2                 16
480621 OK MUSKOGEE   school 4020970 51-I020   MUSKOGEE 402097002302 185 MUSKOGEE EC CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 93 76 59 36   0     1   96   176 185                       361 93 76 59 36   0     1   96   176 185                 361
482731 OK PAYNE   school 4009240 60-I067   CUSHING 400924002291 120 CUSHING PRE-KINDERGARTEN SCHL Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 78 3 9 16   0     0   1   53 54                       107 78 3 9 16   0     0   1   53 54                 107
482732 OK PAYNE   school 4009240 60-I067   CUSHING 400924002291 120 CUSHING PRE-KINDERGARTEN SCHL Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
482964 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944002381 125 JEFFERSON EC CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 79 7 29 25   0     0   29   98 71                       169 79 7 29 25   0     0   29   98 71                 169
483928 OK STEPHENS   school 4010290 69-I001   DUNCAN 401029000454 130 WILL ROGERS PRE-K CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 142 7 40 10   4     0   16   109 110                       219 142 7 40 10   4     0   16   109 110                 219
483929 OK STEPHENS   school 4010290 69-I001   DUNCAN 401029000454 130 WILL ROGERS PRE-K CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 10 0 2 0   1     0   3   10 6                       16 10 0 2 0   1     0   3   10 6                 16
484080 OK TEXAS   school 4013590 70-I008   GUYMON 401359000636 130 CARRIER ES Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 4 1 5 0   0     0   1   6 5                       11 4 1 5 0   0     0   1   6 5                 11
484081 OK TEXAS   school 4013590 70-I008   GUYMON 401359000636 130 CARRIER ES Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 41 1 114 0   5     0   4   85 80                       165 41 1 114 0   5     0   4   85 80                 165
484764 OK TULSA   school 4026880 72-I002   SAND SPRINGS 402688001904 103 SAND SPRINGS EC CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_full_day 129 26 12 49   5     0   1   105 117                       222 129 26 12 49   5     0   1   105 117                 222
475815 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 93 5 30 12   2     0   9   77 74                       151 93 5 30 12   2     0   9   77 74                 151
475816 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   kindergarten_half_day 9 1 2 0   0     0   0   9 3                       12 9 1 2 0   0     0   0   9 3                 12
475817 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   out_of_home_placement 2 0 0 0   0     0   0   2 0                       2 2 0 0 0   0     0   0   2 0                 2
475818 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 63 2 14 13   2     0   4   61 37                       98 63 2 14 13   2     0   4   61 37                 98
475819 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_half_day 22 0 12 3   1     0   3   18 23                       41 22 0 12 3   1     0   3   18 23                 41
476319 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000486 110 HILLCREST ES Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 93 1 47 20   1     0   31   102 91                       193 93 1 47 20   1     0   31   102 91                 193
476320 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000486 110 HILLCREST ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 66 3 30 8   0     0   20   58 69                       127 66 3 30 8   0     0   20   58 69                 127
476443 OK CARTER   school 4003180 10-I019   ARDMORE 400318029635 135 WILL ROGERS ES Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 81 31 40 22   5     0   19   93 105                       198 81 31 40 22   5     0   19   93 105                 198
476444 OK CARTER   school 4003180 10-I019   ARDMORE 400318029635 135 WILL ROGERS ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 68 25 23 23   0     0   32   81 90                       171 68 25 23 23   0     0   32   81 90                 171
477765 OK CREEK   school 4018840 19-I003   MANNFORD 401884002716 115 MANNFORD EC CTR Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 84 0 2 16   1     0   10   58 55                       113 84 0 2 16   1     0   10   58 55                 113
477766 OK CREEK   school 4018840 19-I003   MANNFORD 401884002716 115 MANNFORD EC CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 61 1 3 9   1     0   11   40 46                       86 61 1 3 9   1     0   11   40 46                 86
478436 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355002123 105 JEFFERSON EARLY LRNING CTR Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 38 6 13 16   0     0   0   42 31                       73 38 6 13 16   0     0   0   42 31                 73
478437 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355002123 105 JEFFERSON EARLY LRNING CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 49 6 11 15   0     0   3   42 42                       84 49 6 11 15   0     0   3   42 42                 84
478933 OK JACKSON   school 4002850 33-I018   ALTUS 400285000039 150 ALTUS EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 134 14 78 2   1     1   14   139 105                       244 134 14 78 2   1     1   14   139 105                 244
478934 OK JACKSON   school 4002850 33-I018   ALTUS 400285000039 150 ALTUS EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 72 28 86 1   3     0   11   109 92                       201 72 28 86 1   3     0   11   109 92                 201
478935 OK JACKSON   school 4002850 33-I018   ALTUS 400285000039 150 ALTUS EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_half_day 2 1 3 0   0     0   1   5 2                       7 2 1 3 0   0     0   1   5 2                 7
479806 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356000630 120 COTTERAL ES Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 155 13 27 5   0     1   39   127 113                       240 155 13 27 5   0     1   39   127 113                 240
479807 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356000630 120 COTTERAL ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 23 3 0 2   0     0   3   18 13                       31 23 3 0 2   0     0   3   18 13                 31
479808 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356000630 120 COTTERAL ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_half_day 70 7 12 2   1     0   20   54 58                       112 70 7 12 2   1     0   20   54 58                 112
482454 OK OSAGE   school 4014970 57-I038   HOMINY 401497002783 110 HOMINY EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 15 0 1 22   0     0   0   20 18                       38 15 0 1 22   0     0   0   20 18                 38
482455 OK OSAGE   school 4014970 57-I038   HOMINY 401497002783 110 HOMINY EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 16 1 0 13   0     0   1   17 14                       31 16 1 0 13   0     0   1   17 14                 31
482963 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000925 120 WILLIAM GAY EC CTR Elementary Regular School No Elementary KG KG 2017   kindergarten_full_day 98 7 33 38   1     3   46   117 109                       226 98 7 33 38   1     3   46   117 109                 226
483031 OK PONTOTOC   school 4002430 62-I019   ADA 400243000005 105 ADA EC CTR Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 71 4 36 52   4     0   32   109 90                       199 71 4 36 52   4     0   32   109 90                 199
483032 OK PONTOTOC   school 4002430 62-I019   ADA 400243000005 105 ADA EC CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 67 1 28 44   2     0   27   85 84                       169 67 1 28 44   2     0   27   85 84                 169
483205 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001554 115 KROUCH ES Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 90 4 10 27   0     0   19   73 77                       150 90 4 10 27   0     0   19   73 77                 150
483206 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001554 115 KROUCH ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 64 2 7 22   0     1   19   55 60                       115 64 2 7 22   0     1   19   55 60                 115
483207 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001554 115 KROUCH ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_half_day 2 0 0 0   0     0   0   2 0                       2 2 0 0 0   0     0   0   2 0                 2
483220 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001457 110 SHAWNEE EC CTR Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 85 10 24 20   0     1   45   106 79                       185 85 10 24 20   0     1   45   106 79                 185
483221 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001457 110 SHAWNEE EC CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 114 6 25 16   0     0   57   122 96                       218 114 6 25 16   0     0   57   122 96                 218
483222 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001457 110 SHAWNEE EC CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_half_day 4 0 0 0   0     0   3   5 2                       7 4 0 0 0   0     0   3   5 2                 7
484348 OK TULSA   school 4030240 72-I001   TULSA 403024029773 167 ECDC BUNCHE Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 11 44 4 4   1     0   7   36 35                       71 11 44 4 4   1     0   7   36 35                 71
484349 OK TULSA   school 4030240 72-I001   TULSA 403024029773 167 ECDC BUNCHE Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 81 189 252 16   23     0   56   335 282                       617 81 189 252 16   23     0   56   335 282                 617
484350 OK TULSA   school 4030240 72-I001   TULSA 403024002754 168 ECDC PORTER Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 12 9 4 7   1     0   4   20 17                       37 12 9 4 7   1     0   4   20 17                 37
484351 OK TULSA   school 4030240 72-I001   TULSA 403024002754 168 ECDC PORTER Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 43 11 12 4   2     0   8   32 48                       80 43 11 12 4   2     0   8   32 48                 80
484808 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549002781 100 CREEKWOOD EARLY CHILDHOOD CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 192 20 36 26   15     0   21   159 151                       310 192 20 36 26   15     0   21   159 151                 310
484809 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549002803 103 ARROW SPRINGS EARLY CHILDHOOD Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 139 16 22 21   5     0   27   133 97                       230 139 16 22 21   5     0   27   133 97                 230
484810 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549002763 105 ASPEN CREEK EC CENTER Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 216 11 18 30   5     0   21   165 136                       301 216 11 18 30   5     0   21   165 136                 301
484811 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549002773 107 PARKLANE EARLY CHILDHOOD CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 179 15 34 41   10     0   24   165 138                       303 179 15 34 41   10     0   24   165 138                 303
484977 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837002685 105 COLLINSVILLE EC CTR Elementary Regular School No Elementary PK KG 2017   kindergarten_full_day 123 2 22 37   6     0   31   113 108                       221 123 2 22 37   6     0   31   113 108                 221
484978 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837002685 105 COLLINSVILLE EC CTR Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_full_day 87 2 17 31   10     0   16   92 71                       163 87 2 17 31   10     0   16   92 71                 163
485610 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   k_12_total 104 6 32 12   2     0   9   88 77                       165 104 6 32 12   2     0   9   88 77                 165
485706 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000486 110 HILLCREST ES Elementary Regular School No Elementary PK KG 2017   k_12_total 93 1 47 20   1     0   31   102 91                       193 93 1 47 20   1     0   31   102 91                 193
485732 OK CARTER   school 4003180 10-I019   ARDMORE 400318029635 135 WILL ROGERS ES Elementary Regular School No Elementary PK KG 2017   k_12_total 81 31 40 22   5     0   19   93 105                       198 81 31 40 22   5     0   19   93 105                 198
485948 OK CREEK   school 4018840 19-I003   MANNFORD 401884002716 115 MANNFORD EC CTR Elementary Regular School No Elementary PK KG 2017   k_12_total 84 0 2 16   1     0   10   58 55                       113 84 0 2 16   1     0   10   58 55                 113
486065 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355002123 105 JEFFERSON EARLY LRNING CTR Elementary Regular School No Elementary PK KG 2017   k_12_total 38 6 13 16   0     0   0   42 31                       73 38 6 13 16   0     0   0   42 31                 73
486154 OK JACKSON   school 4002850 33-I018   ALTUS 400285000039 150 ALTUS EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   k_12_total 134 14 78 2   1     1   14   139 105                       244 134 14 78 2   1     1   14   139 105                 244
486306 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356000630 120 COTTERAL ES Elementary Regular School No Elementary PK KG 2017   k_12_total 155 13 27 5   0     1   39   127 113                       240 155 13 27 5   0     1   39   127 113                 240
486773 OK OSAGE   school 4014970 57-I038   HOMINY 401497002783 110 HOMINY EARLY CHILDHOOD CENTER Elementary Regular School No Elementary PK KG 2017   k_12_total 15 0 1 22   0     0   0   20 18                       38 15 0 1 22   0     0   0   20 18                 38
486862 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000925 120 WILLIAM GAY EC CTR Elementary Regular School No Elementary KG KG 2017   k_12_total 98 7 33 38   1     3   46   117 109                       226 98 7 33 38   1     3   46   117 109                 226
486876 OK PONTOTOC   school 4002430 62-I019   ADA 400243000005 105 ADA EC CTR Elementary Regular School No Elementary PK KG 2017   k_12_total 71 4 36 52   4     0   32   109 90                       199 71 4 36 52   4     0   32   109 90                 199
486908 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001554 115 KROUCH ES Elementary Regular School No Elementary PK KG 2017   k_12_total 90 4 10 27   0     0   19   73 77                       150 90 4 10 27   0     0   19   73 77                 150
486912 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001457 110 SHAWNEE EC CTR Elementary Regular School No Elementary PK KG 2017   k_12_total 85 10 24 20   0     1   45   106 79                       185 85 10 24 20   0     1   45   106 79                 185
487102 OK TULSA   school 4030240 72-I001   TULSA 403024029773 167 ECDC BUNCHE Elementary Regular School No Elementary PK KG 2017   k_12_total 11 44 4 4   1     0   7   36 35                       71 11 44 4 4   1     0   7   36 35                 71
487103 OK TULSA   school 4030240 72-I001   TULSA 403024002754 168 ECDC PORTER Elementary Regular School No Elementary PK KG 2017   k_12_total 12 9 4 7   1     0   4   20 17                       37 12 9 4 7   1     0   4   20 17                 37
487218 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837002685 105 COLLINSVILLE EC CTR Elementary Regular School No Elementary PK KG 2017   k_12_total 123 2 22 37   6     0   31   113 108                       221 123 2 22 37   6     0   31   113 108                 221
475577 OK ADAIR   school 4031860 01-I004   WATTS 403186001762 705 WATTS HS High School Regular School No High 09 12 2017   grade_10 10 0 1 12   1     0   6   14 16                       30 10 0 1 12   1     0   6   14 16                 30
475578 OK ADAIR   school 4031860 01-I004   WATTS 403186001762 705 WATTS HS High School Regular School No High 09 12 2017   grade_11 7 0 5 9   0     0   9   16 14                       30 7 0 5 9   0     0   9   16 14                 30
475579 OK ADAIR   school 4031860 01-I004   WATTS 403186001762 705 WATTS HS High School Regular School No High 09 12 2017   grade_12 5 0 4 8   1     0   8   12 14                       26 5 0 4 8   1     0   8   12 14                 26
475580 OK ADAIR   school 4031860 01-I004   WATTS 403186001762 705 WATTS HS High School Regular School No High 09 12 2017   grade_9 7 0 3 4   0     0   7   8 13                       21 7 0 3 4   0     0   7   8 13                 21
475591 OK ADAIR   school 4032400 01-I011   WESTVILLE 403240029611 705 WESTVILLE HS High School Regular School No High 09 12 2017   grade_10 26 0 6 43   4     0   11   34 56                       90 26 0 6 43   4     0   11   34 56                 90
475592 OK ADAIR   school 4032400 01-I011   WESTVILLE 403240029611 705 WESTVILLE HS High School Regular School No High 09 12 2017   grade_11 29 0 0 44   1     0   7   51 30                       81 29 0 0 44   1     0   7   51 30                 81
475593 OK ADAIR   school 4032400 01-I011   WESTVILLE 403240029611 705 WESTVILLE HS High School Regular School No High 09 12 2017   grade_12 37 1 6 31   1     0   5   42 39                       81 37 1 6 31   1     0   5   42 39                 81
475594 OK ADAIR   school 4032400 01-I011   WESTVILLE 403240029611 705 WESTVILLE HS High School Regular School No High 09 12 2017   grade_9 39 1 5 63   1     0   9   57 61                       118 39 1 5 63   1     0   9   57 61                 118
475605 OK ADAIR   school 4028710 01-I025   STILWELL 402871001512 705 STILWELL HS High School Regular School No High 09 12 2017   grade_10 33 0 21 111   0     0   1   91 75                       166 33 0 21 111   0     0   1   91 75                 166
475606 OK ADAIR   school 4028710 01-I025   STILWELL 402871001512 705 STILWELL HS High School Regular School No High 09 12 2017   grade_11 23 0 18 117   0     0   0   90 68                       158 23 0 18 117   0     0   0   90 68                 158
475607 OK ADAIR   school 4028710 01-I025   STILWELL 402871001512 705 STILWELL HS High School Regular School No High 09 12 2017   grade_12 29 0 17 89   0     0   0   66 69                       135 29 0 17 89   0     0   0   66 69                 135
475608 OK ADAIR   school 4028710 01-I025   STILWELL 402871001512 705 STILWELL HS High School Regular School No High 09 12 2017   grade_9 26 0 16 113   1     0   0   72 84                       156 26 0 16 113   1     0   0   72 84                 156
475619 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000275 705 CAVE SPRINGS HS High School Regular School No High 09 12 2017   grade_10 1 0 0 32   0     0   0   16 17                       33 1 0 0 32   0     0   0   16 17                 33
475620 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000275 705 CAVE SPRINGS HS High School Regular School No High 09 12 2017   grade_11 3 0 0 21   0     0   0   17 7                       24 3 0 0 21   0     0   0   17 7                 24
475621 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000275 705 CAVE SPRINGS HS High School Regular School No High 09 12 2017   grade_12 1 0 0 27   0     0   0   18 10                       28 1 0 0 27   0     0   0   18 10                 28
475622 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000275 705 CAVE SPRINGS HS High School Regular School No High 09 12 2017   grade_9 2 0 0 31   0     0   0   16 17                       33 2 0 0 31   0     0   0   16 17                 33
475633 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_10 6 0 3 0   0     0   0   5 4                       9 6 0 3 0   0     0   0   5 4                 9
475634 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_11 8 0 0 0   0     0   4   4 8                       12 8 0 0 0   0     0   4   4 8                 12
475635 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_12 10 0 1 0   0     0   0   8 3                       11 10 0 1 0   0     0   0   8 3                 11
475636 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_9 7 0 2 0   0     0   1   5 5                       10 7 0 2 0   0     0   1   5 5                 10
475648 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000297 705 CHEROKEE HS High School Regular School No High 09 12 2017   grade_10 20 0 2 0   0     0   2   16 8                       24 20 0 2 0   0     0   2   16 8                 24
475649 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000297 705 CHEROKEE HS High School Regular School No High 09 12 2017   grade_11 16 0 0 3   0     0   1   10 10                       20 16 0 0 3   0     0   1   10 10                 20
475650 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000297 705 CHEROKEE HS High School Regular School No High 09 12 2017   grade_12 24 1 2 0   0     0   0   19 8                       27 24 1 2 0   0     0   0   19 8                 27
475651 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000297 705 CHEROKEE HS High School Regular School No High 09 12 2017   grade_9 23 0 3 1   0     0   0   14 13                       27 23 0 3 1   0     0   0   14 13                 27
475662 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301101 705 TIMBERLAKE HS High School Regular School No High 09 12 2017   grade_10 10 2 1 1   2     0   1   6 11                       17 10 2 1 1   2     0   1   6 11                 17
475663 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301101 705 TIMBERLAKE HS High School Regular School No High 09 12 2017   grade_11 12 0 0 0   0     0   1   9 4                       13 12 0 0 0   0     0   1   9 4                 13
475664 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301101 705 TIMBERLAKE HS High School Regular School No High 09 12 2017   grade_12 11 0 0 0   1     0   1   4 9                       13 11 0 0 0   1     0   1   4 9                 13

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