Data source: Big Local News · About: Big Local

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

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
475824 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 8TH AND 9TH GRADE CTR Junior High Regular School No Other 07 09 2017   grade_7 99 6 30 9   1     0   7   85 67                       152 99 6 30 9   1     0   7   85 67                 152
475825 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 8TH AND 9TH GRADE CTR Junior High Regular School No Other 07 09 2017   grade_8 86 3 30 5   1     0   4   69 60                       129 86 3 30 5   1     0   4   69 60                 129
475826 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 8TH AND 9TH GRADE CTR Junior High Regular School No Other 07 09 2017   grade_9 95 6 36 5   0     0   5   76 71                       147 95 6 36 5   0     0   5   76 71                 147
485613 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 8TH AND 9TH GRADE CTR Junior High Regular School No Other 07 09 2017   k_12_total 280 15 96 19   2     0   16   230 198                       428 280 15 96 19   2     0   16   230 198                 428
482217 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002811 971 ABLE CHARTER SCHOOL 6TH-8TH Charter (Virtual) Regular School Yes Middle 06 08 2017   grade_7 1 1 0 1   0     0   0   2 1                       3 1 1 0 1   0     0   0   2 1                 3
482218 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002811 971 ABLE CHARTER SCHOOL 6TH-8TH Charter (Virtual) Regular School Yes Middle 06 08 2017   grade_8 6 2 1 2   0     0   1   9 3                       12 6 2 1 2   0     0   1   9 3                 12
486731 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002811 971 ABLE CHARTER SCHOOL 6TH-8TH Charter (Virtual) Regular School Yes Middle 06 08 2017   k_12_total 7 3 1 3   0     0   1   11 4                       15 7 3 1 3   0     0   1   11 4                 15
482219 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002814 972 ABLE CHARTER SCHOOL 9TH-12TH Charter (Virtual) Regular School Yes High 09 12 2017   grade_10 6 1 4 5   0     0   0   8 8                       16 6 1 4 5   0     0   0   8 8                 16
482220 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002814 972 ABLE CHARTER SCHOOL 9TH-12TH Charter (Virtual) Regular School Yes High 09 12 2017   grade_11 1 0 1 0   0     0   0   1 1                       2 1 0 1 0   0     0   0   1 1                 2
482221 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002814 972 ABLE CHARTER SCHOOL 9TH-12TH Charter (Virtual) Regular School Yes High 09 12 2017   grade_12 14 0 2 2   0     0   1   10 9                       19 14 0 2 2   0     0   1   10 9                 19
482222 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002814 972 ABLE CHARTER SCHOOL 9TH-12TH Charter (Virtual) Regular School Yes High 09 12 2017   grade_9 4 0 2 1   0     0   0   2 5                       7 4 0 2 1   0     0   0   2 5                 7
486732 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002814 972 ABLE CHARTER SCHOOL 9TH-12TH Charter (Virtual) Regular School Yes High 09 12 2017   k_12_total 25 1 9 8   0     0   1   21 23                       44 25 1 9 8   0     0   1   21 23                 44
484263 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   grade_1 6 29 2 1   0     1   4   24 19                       43 6 29 2 1   0     1   4   24 19                 43
484264 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   grade_2 2 26 3 0   0     1   4   20 16                       36 2 26 3 0   0     1   4   20 16                 36
484265 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   grade_3 3 28 1 0   0     1   7   21 19                       40 3 28 1 0   0     1   7   21 19                 40
484266 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   grade_4 3 32 2 0   0     0   7   24 20                       44 3 32 2 0   0     0   7   24 20                 44
484267 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   grade_5 2 30 1 0   0     0   5   22 16                       38 2 30 1 0   0     0   5   22 16                 38
484268 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   grade_6 3 18 1 0   0     0   0   12 10                       22 3 18 1 0   0     0   0   12 10                 22
484269 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 6 24 3 1   0     1   11   26 20                       46 6 24 3 1   0     1   11   26 20                 46
484270 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 4 11 0 0   0     1   4   13 7                       20 4 11 0 0   0     1   4   13 7                 20
487091 OK TULSA   school 4030240 72-I001   TULSA 403024029854 103 ACADEMY CENTRAL ES Elementary Regular School No Elementary PK 06 2017   k_12_total 25 187 13 2   0     4   38   149 120                       269 25 187 13 2   0     4   38   149 120                 269
484069 OK TEXAS   school 4013590 70-I008   GUYMON 401359000635 105 ACADEMY ES Elementary Regular School No Elementary 03 04 2017   grade_3 36 14 179 1   6     0   2   105 133                       238 36 14 179 1   6     0   2   105 133                 238
484070 OK TEXAS   school 4013590 70-I008   GUYMON 401359000635 105 ACADEMY ES Elementary Regular School No Elementary 03 04 2017   grade_4 43 11 147 1   14     0   3   98 121                       219 43 11 147 1   14     0   3   98 121                 219
487058 OK TEXAS   school 4013590 70-I008   GUYMON 401359000635 105 ACADEMY ES Elementary Regular School No Elementary 03 04 2017   k_12_total 79 25 326 2   20     0   5   203 254                       457 79 25 326 2   20     0   5   203 254                 457
475945 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_1 16 0 1 8   0     0   0   14 11                       25 16 0 1 8   0     0   0   14 11                 25
475946 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_2 13 0 1 6   0     0   3   14 9                       23 13 0 1 6   0     0   3   14 9                 23
475947 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_3 13 0 0 5   0     0   0   11 7                       18 13 0 0 5   0     0   0   11 7                 18
475948 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_4 13 0 2 5   0     0   0   10 10                       20 13 0 2 5   0     0   0   10 10                 20
475949 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_5 17 0 1 5   0     0   3   14 12                       26 17 0 1 5   0     0   3   14 12                 26
475950 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_6 14 0 0 7   0     0   0   11 10                       21 14 0 0 7   0     0   0   11 10                 21
475951 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 20 1 2 6   0     0   1   19 11                       30 20 1 2 6   0     0   1   19 11                 30
475952 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_8 19 2 0 4   0     0   1   19 7                       26 19 2 0 4   0     0   1   19 7                 26
475953 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 12 0 2 8   0     0   3   15 10                       25 12 0 2 8   0     0   3   15 10                 25
475954 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 11 0 1 7   0     0   7   13 13                       26 11 0 1 7   0     0   7   13 13                 26
485636 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   k_12_total 137 3 9 54   0     0   11   127 87                       214 137 3 9 54   0     0   11   127 87                 214
475955 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2017   grade_10 17 0 0 9   0     0   1   13 14                       27 17 0 0 9   0     0   1   13 14                 27
475956 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2017   grade_11 14 0 0 4   0     0   1   12 7                       19 14 0 0 4   0     0   1   12 7                 19
475957 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2017   grade_12 15 1 2 13   0     0   0   17 14                       31 15 1 2 13   0     0   0   17 14                 31
475958 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2017   grade_9 21 0 2 5   0     0   1   14 15                       29 21 0 2 5   0     0   1   14 15                 29
485637 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2017   k_12_total 67 1 4 31   0     0   3   56 50                       106 67 1 4 31   0     0   3   56 50                 106
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
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
483042 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2017   grade_10 66 5 16 57   3     0   13   85 75                       160 66 5 16 57   3     0   13   85 75                 160
483043 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2017   grade_11 93 10 20 63   2     1   17   99 107                       206 93 10 20 63   2     1   17   99 107                 206
483044 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2017   grade_12 78 7 13 47   2     0   15   85 77                       162 78 7 13 47   2     0   15   85 77                 162
486881 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2017   k_12_total 237 22 49 167   7     1   45   269 259                       528 237 22 49 167   7     1   45   269 259                 528
483039 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Other 07 09 2017   grade_7 80 10 27 60   4     0   13   94 100                       194 80 10 27 60   4     0   13   94 100                 194
483040 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Other 07 09 2017   grade_8 92 11 18 59   3     0   9   111 81                       192 92 11 18 59   3     0   9   111 81                 192
483041 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Other 07 09 2017   grade_9 72 9 25 73   1     0   15   100 95                       195 72 9 25 73   1     0   15   100 95                 195
486880 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Other 07 09 2017   k_12_total 244 30 70 192   8     0   37   305 276                       581 244 30 70 192   8     0   37   305 276                 581
480065 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2017   grade_10 39 0 3 40   0     0   0   47 35                       82 39 0 3 40   0     0   0   47 35                 82
480066 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2017   grade_11 43 0 0 30   0     0   1   29 45                       74 43 0 0 30   0     0   1   29 45                 74
480067 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2017   grade_12 39 0 0 35   1     0   1   35 41                       76 39 0 0 35   1     0   1   35 41                 76
480068 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2017   grade_9 36 1 2 33   0     0   2   38 36                       74 36 1 2 33   0     0   2   38 36                 74
486351 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2017   k_12_total 157 1 5 138   1     0   4   149 157                       306 157 1 5 138   1     0   4   149 157                 306
480062 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   grade_6 30 3 1 41   0     0   2   46 31                       77 30 3 1 41   0     0   2   46 31                 77
480063 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   grade_7 31 0 1 38   0     0   1   38 33                       71 31 0 1 38   0     0   1   38 33                 71
480064 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   grade_8 26 1 2 34   0     0   1   30 34                       64 26 1 2 34   0     0   1   30 34                 64
486350 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   k_12_total 87 4 4 113   0     0   4   114 98                       212 87 4 4 113   0     0   4   114 98                 212
477083 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_1 44 3 27 1   1     0   20   55 41                       96 44 3 27 1   1     0   20   55 41                 96
477084 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_2 45 4 31 1   0     0   6   39 48                       87 45 4 31 1   0     0   6   39 48                 87
477085 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_3 45 6 35 2   2     0   12   59 43                       102 45 6 35 2   2     0   12   59 43                 102
477086 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_4 42 4 26 3   1     0   8   44 40                       84 42 4 26 3   1     0   8   44 40                 84
477087 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_5 45 2 30 1   0     0   13   47 44                       91 45 2 30 1   0     0   13   47 44                 91
477088 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 49 2 33 4   1     0   12   53 48                       101 49 2 33 4   1     0   12   53 48                 101
477089 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 14 1 13 3   0     0   4   19 16                       35 14 1 13 3   0     0   4   19 16                 35
477400 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_1 15 9 11 3   0     0   7   19 26                       45 15 9 11 3   0     0   7   19 26                 45
477401 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_2 15 6 6 1   1     0   8   20 17                       37 15 6 6 1   1     0   8   20 17                 37
477402 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_3 21 6 11 1   1     0   4   27 17                       44 21 6 11 1   1     0   4   27 17                 44
477403 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_4 14 9 9 2   1     0   5   17 23                       40 14 9 9 2   1     0   5   17 23                 40
477404 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   grade_5 8 12 8 3   0     0   2   12 21                       33 8 12 8 3   0     0   2   12 21                 33
477405 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 15 8 14 4   0     0   8   20 29                       49 15 8 14 4   0     0   8   20 29                 49
477406 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
478246 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   grade_1 17 1 13 1   1     16   9   34 24                       58 17 1 13 1   1     16   9   34 24                 58
478247 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   grade_2 19 0 24 1   0     13   2   33 26                       59 19 0 24 1   0     13   2   33 26                 59
478248 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   grade_3 23 1 24 2   1     6   5   37 25                       62 23 1 24 2   1     6   5   37 25                 62
478249 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   grade_4 14 1 24 2   1     5   6   28 25                       53 14 1 24 2   1     5   6   28 25                 53
478250 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   grade_5 16 7 18 0   0     8   1   22 28                       50 16 7 18 0   0     8   1   22 28                 50
478251 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   kindergarten_full_day 25 5 19 0   0     10   7   40 26                       66 25 5 19 0   0     10   7   40 26                 66
481557 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   grade_1 13 5 75 4   0     0   5   46 56                       102 13 5 75 4   0     0   5   46 56                 102
481558 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   grade_2 9 4 74 1   1     0   7   49 47                       96 9 4 74 1   1     0   7   49 47                 96
481559 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   grade_3 4 2 60 2   0     0   4   35 37                       72 4 2 60 2   0     0   4   35 37                 72
481560 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   grade_4 5 4 66 2   0     0   3   43 37                       80 5 4 66 2   0     0   3   43 37                 80
481561 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   grade_5 5 0 55 2   0     0   2   33 31                       64 5 0 55 2   0     0   2   33 31                 64
481562 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   grade_6 1 4 43 1   0     0   2   26 25                       51 1 4 43 1   0     0   2   26 25                 51
481563 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 8 6 80 3   0     0   3   52 48                       100 8 6 80 3   0     0   3   52 48                 100
481564 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 3 3 43 1   0     0   4   23 31                       54 3 3 43 1   0     0   4   23 31                 54
485831 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   k_12_total 270 21 182 12   5     0   71   297 264                       561 270 21 182 12   5     0   71   297 264                 561
485886 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2017   k_12_total 88 50 59 14   3     0   34   115 133                       248 88 50 59 14   3     0   34   115 133                 248
486035 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2017   k_12_total 114 15 122 6   3     58   30   194 154                       348 114 15 122 6   3     58   30   194 154                 348
486625 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 06 2017   k_12_total 45 25 453 15   1     0   26   284 281                       565 45 25 453 15   1     0   26   284 281                 565
482572 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_1 27 0 3 13   0     1   0   23 21                       44 27 0 3 13   0     1   0   23 21                 44
482573 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_2 21 0 0 15   0     1   0   20 17                       37 21 0 0 15   0     1   0   20 17                 37
482574 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_3 17 0 0 13   0     0   0   12 18                       30 17 0 0 13   0     0   0   12 18                 30
482575 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_4 25 0 5 17   0     0   0   21 26                       47 25 0 5 17   0     0   0   21 26                 47
482576 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_5 27 0 0 10   0     0   0   16 21                       37 27 0 0 10   0     0   0   16 21                 37
482577 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_6 20 0 0 14   0     0   0   16 18                       34 20 0 0 14   0     0   0   16 18                 34
482578 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 1 13   0     0   0   14 15                       29 15 0 1 13   0     0   0   14 15                 29
482579 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_8 21 0 1 22   1     0   0   27 18                       45 21 0 1 22   1     0   0   27 18                 45

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