Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 11,624
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
3025663 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_1 22 0 0 4   0     0   5   23 8                       31 22 0 0 4   0     0   5   23 8                 31
3025664 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_2 12 0 1 4   0     0   2   11 8                       19 12 0 1 4   0     0   2   11 8                 19
3025665 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_3 15 0 0 8   0     0   3   11 15                       26 15 0 0 8   0     0   3   11 15                 26
3025666 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_4 10 0 0 6   0     0   0   8 8                       16 10 0 0 6   0     0   0   8 8                 16
3025667 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_5 8 2 2 6   0     0   2   13 7                       20 8 2 2 6   0     0   2   13 7                 20
3025668 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_6 10 0 2 7   0     0   5   12 12                       24 10 0 2 7   0     0   5   12 12                 24
3025669 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_7 16 0 1 4   0     0   3   13 11                       24 16 0 1 4   0     0   3   13 11                 24
3025670 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_8 16 0 1 4   0     0   3   13 11                       24 16 0 1 4   0     0   3   13 11                 24
3025671 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 27 0 0 3   0     0   7   17 20                       37 27 0 0 3   0     0   7   17 20                 37
3025672 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 19 0 1 10   0     0   5   19 16                       35 19 0 1 10   0     0   5   19 16                 35
3035173 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   k_12_total 136 2 7 46   0     0   30   121 100                       221 136 2 7 46   0     0   30   121 100                 221
3025673 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   grade_10 16 0 1 4   0     0   0   12 9                       21 16 0 1 4   0     0   0   12 9                 21
3025674 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   grade_11 16 0 0 2   0     0   1   11 8                       19 16 0 0 2   0     0   1   11 8                 19
3025675 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   grade_12 18 0 1 3   0     0   1   14 9                       23 18 0 1 3   0     0   1   14 9                 23
3025676 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   grade_9 16 0 0 4   0     0   0   11 9                       20 16 0 0 4   0     0   0   11 9                 20
3035174 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   k_12_total 66 0 2 13   0     0   2   48 35                       83 66 0 2 13   0     0   2   48 35                 83
3032566 OK PONTOTOC   school 4002430 62-I019   ADA 400243000005 105 ADA EC CTR Elementary Regular School No Elementary PK KG 2020   kindergarten_full_day 76 2 22 74   1     0   23   99 99                       198 76 2 22 74   1     0   23   99 99                 198
3032567 OK PONTOTOC   school 4002430 62-I019   ADA 400243000005 105 ADA EC CTR Elementary Regular School No Elementary PK KG 2020   pre_kindergarten_full_day 76 5 9 40   0     2   27   81 78                       159 76 5 9 40   0     2   27   81 78                 159
3036414 OK PONTOTOC   school 4002430 62-I019   ADA 400243000005 105 ADA EC CTR Elementary Regular School No Elementary PK KG 2020   k_12_total 76 2 22 74   1     0   23   99 99                       198 76 2 22 74   1     0   23   99 99                 198
3032577 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2020   grade_10 71 5 25 42   4     0   36   85 98                       183 71 5 25 42   4     0   36   85 98                 183
3032578 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2020   grade_11 90 9 14 38   4     0   32   103 84                       187 90 9 14 38   4     0   32   103 84                 187
3032579 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2020   grade_12 66 11 21 52   2     0   22   89 85                       174 66 11 21 52   2     0   22   89 85                 174
3036419 OK PONTOTOC   school 4002430 62-I019   ADA 400243000003 705 ADA HS High School Regular School No High 10 12 2020   k_12_total 227 25 60 132   10     0   90   277 267                       544 227 25 60 132   10     0   90   277 267                 544
3032574 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Middle 07 09 2020   grade_7 65 3 30 43   2     0   39   96 86                       182 65 3 30 43   2     0   39   96 86                 182
3032575 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Middle 07 09 2020   grade_8 77 5 26 52   2     0   38   106 94                       200 77 5 26 52   2     0   38   106 94                 200
3032576 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Middle 07 09 2020   grade_9 68 1 17 40   0     0   30   90 66                       156 68 1 17 40   0     0   30   90 66                 156
3036418 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Middle 07 09 2020   k_12_total 210 9 73 135   4     0   107   292 246                       538 210 9 73 135   4     0   107   292 246                 538
3029755 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2020   grade_10 30 0 0 36   1     0   1   38 30                       68 30 0 0 36   1     0   1   38 30                 68
3029756 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2020   grade_11 23 1 2 27   1     0   1   26 29                       55 23 1 2 27   1     0   1   26 29                 55
3029757 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2020   grade_12 27 0 3 30   1     0   2   35 28                       63 27 0 3 30   1     0   2   35 28                 63
3029758 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2020   grade_9 31 4 1 42   0     0   3   45 36                       81 31 4 1 42   0     0   3   45 36                 81
3035892 OK MAYES   school 4002460 46-I002   ADAIR 400246000009 705 ADAIR HS High School Regular School No High 09 12 2020   k_12_total 111 5 6 135   3     0   7   144 123                       267 111 5 6 135   3     0   7   144 123                 267
3029752 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2020   grade_6 52 0 6 39   0     0   2   45 54                       99 52 0 6 39   0     0   2   45 54                 99
3029753 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2020   grade_7 41 1 1 45   0     0   2   46 44                       90 41 1 1 45   0     0   2   46 44                 90
3029754 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2020   grade_8 33 0 7 44   0     0   0   38 46                       84 33 0 7 44   0     0   0   38 46                 84
3035891 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2020   k_12_total 126 1 14 128   0     0   4   129 144                       273 126 1 14 128   0     0   4   129 144                 273
3026780 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_1 41 3 25 2   0     0   17   42 46                       88 41 3 25 2   0     0   17   42 46                 88
3026781 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_2 45 1 35 5   2     0   13   44 57                       101 45 1 35 5   2     0   13   44 57                 101
3026782 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_3 44 2 32 5   0     0   11   51 43                       94 44 2 32 5   0     0   11   51 43                 94
3026783 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_4 52 5 31 1   0     0   16   56 49                       105 52 5 31 1   0     0   16   56 49                 105
3026784 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_5 45 6 32 2   1     0   5   40 51                       91 45 6 32 2   1     0   5   40 51                 91
3026785 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   kindergarten_full_day 40 6 25 2   0     0   16   45 44                       89 40 6 25 2   0     0   16   45 44                 89
3026786 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 9 1 2 1   0     0   2   7 8                       15 9 1 2 1   0     0   2   7 8                 15
3026787 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_half_day 15 1 9 1   0     0   4   16 14                       30 15 1 9 1   0     0   4   16 14                 30
3027099 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_1 13 3 10 1   0     1   4   18 14                       32 13 3 10 1   0     1   4   18 14                 32
3027100 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_2 4 7 10 1   0     1   4   7 20                       27 4 7 10 1   0     1   4   7 20                 27
3027101 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_3 12 6 10 2   0     0   7   13 24                       37 12 6 10 2   0     0   7   13 24                 37
3027102 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_4 6 8 9 2   0     0   3   14 14                       28 6 8 9 2   0     0   3   14 14                 28
3027103 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   grade_5 8 6 6 1   1     0   8   15 15                       30 8 6 6 1   1     0   8   15 15                 30
3027104 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   kindergarten_full_day 11 5 7 5   0     1   4   17 16                       33 11 5 7 5   0     1   4   17 16                 33
3027105 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 7 2 6 1   0     0   0   7 9                       16 7 2 6 1   0     0   0   7 9                 16
3027937 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   grade_1 12 1 18 1   0     16   4   20 32                       52 12 1 18 1   0     16   4   20 32                 52
3027938 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   grade_2 10 2 15 0   0     11   4   32 10                       42 10 2 15 0   0     11   4   32 10                 42
3027939 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   grade_3 17 1 17 2   0     11   2   26 24                       50 17 1 17 2   0     11   2   26 24                 50
3027940 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   grade_4 15 2 12 1   1     10   8   23 26                       49 15 2 12 1   1     10   8   23 26                 49
3027941 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   grade_5 14 0 13 3   0     10   2   20 22                       42 14 0 13 3   0     10   2   20 22                 42
3027942 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   kindergarten_full_day 13 1 15 1   0     10   5   23 22                       45 13 1 15 1   0     10   5   23 22                 45
3027943 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   pre_kindergarten_full_day 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
3031292 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   grade_1 6 4 81 1   0     0   5   46 51                       97 6 4 81 1   0     0   5   46 51                 97
3031293 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   grade_2 5 6 59 0   0     0   1   34 37                       71 5 6 59 0   0     0   1   34 37                 71
3031294 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   grade_3 9 4 89 2   0     0   3   58 49                       107 9 4 89 2   0     0   3   58 49                 107
3031295 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   grade_4 11 5 70 2   0     0   4   44 48                       92 11 5 70 2   0     0   4   44 48                 92
3031296 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   kindergarten_full_day 4 1 72 1   0     0   6   45 39                       84 4 1 72 1   0     0   6   45 39                 84
3031297 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   pre_kindergarten_full_day 1 5 57 1   0     0   7   36 35                       71 1 5 57 1   0     0   7   36 35                 71
3035370 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2020   k_12_total 267 23 180 17   3     0   78   278 290                       568 267 23 180 17   3     0   78   278 290                 568
3035425 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000798 105 ADAMS ES Elementary Regular School No Elementary PK 05 2020   k_12_total 54 35 52 12   1     3   30   84 103                       187 54 35 52 12   1     3   30   84 103                 187
3035575 OK GARFIELD   school 4010920 24-I057   ENID 401092000506 105 ADAMS ES Elementary Regular School No Elementary KG 05 2020   k_12_total 81 7 90 8   1     68   25   144 136                       280 81 7 90 8   1     68   25   144 136                 280
3036175 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001112 105 ADAMS ES Elementary Regular School No Elementary PK 04 2020   k_12_total 35 20 371 6   0     0   19   227 224                       451 35 20 371 6   0     0   19   227 224                 451
3031400 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   grade_1 4 2 65 3   0     0   5   47 32                       79 4 2 65 3   0     0   5   47 32                 79
3031401 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   grade_2 10 6 92 2   0     0   3   57 56                       113 10 6 92 2   0     0   3   57 56                 113
3031402 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   grade_3 8 2 93 0   0     0   3   49 57                       106 8 2 93 0   0     0   3   49 57                 106
3031403 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   grade_4 3 4 82 3   1     0   2   54 41                       95 3 4 82 3   1     0   2   54 41                 95
3031404 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   kindergarten_full_day 6 4 78 0   0     0   0   44 44                       88 6 4 78 0   0     0   0   44 44                 88
3031405 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   pre_kindergarten_full_day 4 3 53 1   0     0   1   29 33                       62 4 3 53 1   0     0   1   29 33                 62
3036192 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001154 295 ADELAIDE LEE ES Elementary Regular School No Elementary PK 04 2020   k_12_total 31 18 410 8   1     0   13   251 230                       481 31 18 410 8   1     0   13   251 230                 481
3032112 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_1 12 1 3 10   0     0   1   13 14                       27 12 1 3 10   0     0   1   13 14                 27
3032113 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_2 14 0 1 15   0     0   1   20 11                       31 14 0 1 15   0     0   1   20 11                 31
3032114 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_3 16 0 2 11   0     0   0   14 15                       29 16 0 2 11   0     0   0   14 15                 29
3032115 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_4 20 0 2 13   0     0   2   19 18                       37 20 0 2 13   0     0   2   19 18                 37
3032116 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_5 18 0 1 16   0     0   0   18 17                       35 18 0 1 16   0     0   0   18 17                 35
3032117 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_6 22 0 0 9   0     0   4   14 21                       35 22 0 0 9   0     0   4   14 21                 35
3032118 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_7 22 0 6 14   0     0   3   20 25                       45 22 0 6 14   0     0   3   20 25                 45
3032119 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   grade_8 28 0 0 6   0     0   3   15 22                       37 28 0 0 6   0     0   3   15 22                 37
3032120 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 13 0 1 10   0     0   1   13 12                       25 13 0 1 10   0     0   1   13 12                 25
3032121 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 11 1 0 9   0     0   1   7 15                       22 11 1 0 9   0     0   1   7 15                 22
3036336 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2020   k_12_total 165 1 16 104   0     0   15   146 155                       301 165 1 16 104   0     0   15   146 155                 301
3032122 OK OTTAWA   school 4002520 58-I026   AFTON 400252000014 705 AFTON HS High School Regular School No High 09 12 2020   grade_10 21 0 1 15   0     0   0   16 21                       37 21 0 1 15   0     0   0   16 21                 37
3032123 OK OTTAWA   school 4002520 58-I026   AFTON 400252000014 705 AFTON HS High School Regular School No High 09 12 2020   grade_11 24 0 1 22   1     0   1   31 18                       49 24 0 1 22   1     0   1   31 18                 49
3032124 OK OTTAWA   school 4002520 58-I026   AFTON 400252000014 705 AFTON HS High School Regular School No High 09 12 2020   grade_12 14 0 3 14   1     0   1   17 16                       33 14 0 3 14   1     0   1   17 16                 33
3032125 OK OTTAWA   school 4002520 58-I026   AFTON 400252000014 705 AFTON HS High School Regular School No High 09 12 2020   grade_9 23 0 1 11   0     0   1   13 23                       36 23 0 1 11   0     0   1   13 23                 36
3036337 OK OTTAWA   school 4002520 58-I026   AFTON 400252000014 705 AFTON HS High School Regular School No High 09 12 2020   k_12_total 82 0 6 62   2     0   3   77 78                       155 82 0 6 62   2     0   3   77 78                 155
3029462 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   grade_1 14 1 0 1   0     0   4   13 7                       20 14 1 0 1   0     0   4   13 7                 20
3029463 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   grade_2 21 1 0 1   0     0   3   13 13                       26 21 1 0 1   0     0   3   13 13                 26
3029464 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   grade_3 16 0 0 1   0     0   1   8 10                       18 16 0 0 1   0     0   1   8 10                 18
3029465 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   grade_4 18 1 0 1   0     0   2   13 9                       22 18 1 0 1   0     0   2   13 9                 22
3029466 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   grade_5 19 0 2 1   0     0   2   13 11                       24 19 0 2 1   0     0   2   13 11                 24
3029467 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   grade_6 18 1 0 3   0     0   1   12 11                       23 18 1 0 3   0     0   1   12 11                 23
3029468 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   kindergarten_full_day 16 1 0 1   0     0   1   16 3                       19 16 1 0 1   0     0   1   16 3                 19
3029469 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 17 0 0 3   0     0   3   12 11                       23 17 0 0 3   0     0   3   12 11                 23
3035842 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 06 2020   k_12_total 122 5 2 9   0     0   14   88 64                       152 122 5 2 9   0     0   14   88 64                 152

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