Data source: Big Local News · About: Big Local

58,650 rows where state = "OK"

View and edit SQL

year

Link rowid ▼ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
477831 OK CREEK   school 4022560 19-I020   OILTON 402256001103 715 OILTON HS High School Regular School No High 09 12 2017   grade_9 18 0 0 7   0     0   1   13 13                       26 18 0 0 7   0     0   1   13 13                 26
477832 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_1 10 0 0 10   0     0   0   12 8                       20 10 0 0 10   0     0   0   12 8                 20
477833 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_2 17 0 0 8   0     0   0   17 8                       25 17 0 0 8   0     0   0   17 8                 25
477834 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_3 19 1 1 4   0     0   0   13 12                       25 19 1 1 4   0     0   0   13 12                 25
477835 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_4 22 0 0 4   0     0   2   16 12                       28 22 0 0 4   0     0   2   16 12                 28
477836 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_5 18 1 2 5   0     0   1   9 18                       27 18 1 2 5   0     0   1   9 18                 27
477837 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_6 18 0 3 9   0     0   2   12 20                       32 18 0 3 9   0     0   2   12 20                 32
477838 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 0 5   0     0   1   12 12                       24 18 0 0 5   0     0   1   12 12                 24
477839 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_8 23 0 3 3   0     0   1   21 9                       30 23 0 3 3   0     0   1   21 9                 30
477840 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 16 0 0 5   0     0   0   13 8                       21 16 0 0 5   0     0   0   13 8                 21
477841 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 13 0 0 1   0     0   4   8 10                       18 13 0 0 1   0     0   4   8 10                 18
477842 OK CREEK   school 4009750 19-I021   DEPEW 400975000419 705 DEPEW HS High School Regular School No High 09 12 2017   grade_10 24 0 0 7   0     0   3   20 14                       34 24 0 0 7   0     0   3   20 14                 34
477843 OK CREEK   school 4009750 19-I021   DEPEW 400975000419 705 DEPEW HS High School Regular School No High 09 12 2017   grade_11 19 2 1 8   0     0   3   19 14                       33 19 2 1 8   0     0   3   19 14                 33
477844 OK CREEK   school 4009750 19-I021   DEPEW 400975000419 705 DEPEW HS High School Regular School No High 09 12 2017   grade_12 23 0 0 1   0     0   7   8 23                       31 23 0 0 1   0     0   7   8 23                 31
477845 OK CREEK   school 4009750 19-I021   DEPEW 400975000419 705 DEPEW HS High School Regular School No High 09 12 2017   grade_9 35 2 1 7   0     0   3   27 21                       48 35 2 1 7   0     0   3   27 21                 48
477846 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000753 105 KELLYVILLE ES Elementary Regular School No Elementary PK 03 2017   grade_1 43 1 3 23   0     0   2   47 25                       72 43 1 3 23   0     0   2   47 25                 72
477847 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000753 105 KELLYVILLE ES Elementary Regular School No Elementary PK 03 2017   grade_2 39 0 3 8   0     0   9   28 31                       59 39 0 3 8   0     0   9   28 31                 59
477848 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000753 105 KELLYVILLE ES Elementary Regular School No Elementary PK 03 2017   grade_3 48 3 4 14   0     0   9   42 36                       78 48 3 4 14   0     0   9   42 36                 78
477849 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000753 105 KELLYVILLE ES Elementary Regular School No Elementary PK 03 2017   kindergarten_full_day 35 2 4 8   0     0   14   34 29                       63 35 2 4 8   0     0   14   34 29                 63
477850 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000753 105 KELLYVILLE ES Elementary Regular School No Elementary PK 03 2017   pre_kindergarten_full_day 26 0 4 7   0     0   5   20 22                       42 26 0 4 7   0     0   5   20 22                 42
477851 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617002340 110 KELLYVILLE UPPER ES Elementary Regular School No Elementary 04 06 2017   grade_4 44 0 2 19   0     0   8   33 40                       73 44 0 2 19   0     0   8   33 40                 73
477852 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617002340 110 KELLYVILLE UPPER ES Elementary Regular School No Elementary 04 06 2017   grade_5 41 1 5 18   0     0   13   38 40                       78 41 1 5 18   0     0   13   38 40                 78
477853 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617002340 110 KELLYVILLE UPPER ES Elementary Regular School No Elementary 04 06 2017   grade_6 46 0 2 15   0     0   20   33 50                       83 46 0 2 15   0     0   20   33 50                 83
477854 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_7 46 0 1 17   0     0   16   44 36                       80 46 0 1 17   0     0   16   44 36                 80
477855 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_8 48 0 7 13   0     0   12   42 38                       80 48 0 7 13   0     0   12   42 38                 80
477856 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000754 705 KELLYVILLE HS High School Regular School No High 09 12 2017   grade_10 62 2 5 17   1     0   10   60 37                       97 62 2 5 17   1     0   10   60 37                 97
477857 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000754 705 KELLYVILLE HS High School Regular School No High 09 12 2017   grade_11 56 0 1 11   0     1   11   42 38                       80 56 0 1 11   0     1   11   42 38                 80
477858 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000754 705 KELLYVILLE HS High School Regular School No High 09 12 2017   grade_12 42 1 1 10   0     1   11   33 33                       66 42 1 1 10   0     1   11   33 33                 66
477859 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000754 705 KELLYVILLE HS High School Regular School No High 09 12 2017   grade_9 46 0 3 12   0     0   16   39 38                       77 46 0 3 12   0     0   16   39 38                 77
477860 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   grade_1 24 1 4 5   0     0   3   16 21                       37 24 1 4 5   0     0   3   16 21                 37
477861 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   grade_2 17 3 2 15   0     0   5   21 21                       42 17 3 2 15   0     0   5   21 21                 42
477862 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   grade_3 24 4 2 8   0     0   1   16 23                       39 24 4 2 8   0     0   1   16 23                 39
477863 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   grade_4 15 2 0 8   0     0   10   16 19                       35 15 2 0 8   0     0   10   16 19                 35
477864 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   grade_5 10 0 2 8   0     0   7   13 14                       27 10 0 2 8   0     0   7   13 14                 27
477865 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 28 1 2 3   0     0   7   17 24                       41 28 1 2 3   0     0   7   17 24                 41
477866 OK CREEK   school 4026910 19-I033   SAPULPA 402691001419 125 LIBERTY ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 9 1 4 4   0     0   6   9 15                       24 9 1 4 4   0     0   6   9 15                 24
477867 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   grade_1 40 0 4 11   3     0   9   29 38                       67 40 0 4 11   3     0   9   29 38                 67
477868 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   grade_2 46 3 5 8   1     0   6   38 31                       69 46 3 5 8   1     0   6   38 31                 69
477869 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   grade_3 53 1 6 8   0     0   13   41 40                       81 53 1 6 8   0     0   13   41 40                 81
477870 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   grade_4 46 0 5 8   1     0   7   32 35                       67 46 0 5 8   1     0   7   32 35                 67
477871 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   grade_5 40 2 7 12   0     0   8   36 33                       69 40 2 7 12   0     0   8   36 33                 69
477872 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 33 3 2 9   0     0   8   32 23                       55 33 3 2 9   0     0   8   32 23                 55
477873 OK CREEK   school 4026910 19-I033   SAPULPA 402691002341 150 FREEDOM ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 29 0 3 4   0     1   11   22 26                       48 29 0 3 4   0     1   11   22 26                 48
477874 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   grade_1 33 3 2 4   1     0   14   30 27                       57 33 3 2 4   1     0   14   30 27                 57
477875 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   grade_2 23 5 6 11   0     0   7   23 29                       52 23 5 6 11   0     0   7   23 29                 52
477876 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   grade_3 35 3 2 6   0     0   15   27 34                       61 35 3 2 6   0     0   15   27 34                 61
477877 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   grade_4 28 5 4 15   0     0   14   40 26                       66 28 5 4 15   0     0   14   40 26                 66
477878 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   grade_5 29 5 2 4   3     0   9   29 23                       52 29 5 2 4   3     0   9   29 23                 52
477879 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 33 2 5 6   0     0   8   30 24                       54 33 2 5 6   0     0   8   30 24                 54
477880 OK CREEK   school 4026910 19-I033   SAPULPA 402691002406 160 JEFFERSON HEIGHTS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 26 0 7 2   0     1   10   23 23                       46 26 0 7 2   0     1   10   23 23                 46
477881 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   grade_1 62 2 9 20   0     1   19   58 55                       113 62 2 9 20   0     1   19   58 55                 113
477882 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   grade_2 58 4 18 23   0     0   20   66 57                       123 58 4 18 23   0     0   20   66 57                 123
477883 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   grade_3 52 2 12 19   0     0   12   43 54                       97 52 2 12 19   0     0   12   43 54                 97
477884 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   grade_4 48 3 8 11   0     0   22   47 45                       92 48 3 8 11   0     0   22   47 45                 92
477885 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   grade_5 60 5 10 14   1     0   16   58 48                       106 60 5 10 14   1     0   16   58 48                 106
477886 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 60 1 11 15   0     0   24   57 54                       111 60 1 11 15   0     0   24   57 54                 111
477887 OK CREEK   school 4026910 19-I033   SAPULPA 402691002726 165 HOLMES PARK ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 39 3 9 9   0     0   17   43 34                       77 39 3 9 9   0     0   17   43 34                 77
477888 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_6 132 15 26 41   1     0   30   122 123                       245 132 15 26 41   1     0   30   122 123                 245
477889 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_7 152 6 21 42   0     0   48   128 141                       269 152 6 21 42   0     0   48   128 141                 269
477890 OK CREEK   school 4026910 19-I033   SAPULPA 402691002223 610 SAPULPA JHS Junior High Regular School No Other 08 09 2017   grade_8 154 14 25 35   1     0   48   138 139                       277 154 14 25 35   1     0   48   138 139                 277
477891 OK CREEK   school 4026910 19-I033   SAPULPA 402691002223 610 SAPULPA JHS Junior High Regular School No Other 08 09 2017   grade_9 203 10 26 51   0     1   66   197 160                       357 203 10 26 51   0     1   66   197 160                 357
477892 OK CREEK   school 4026910 19-I033   SAPULPA 402691002223 610 SAPULPA JHS Junior High Regular School No Other 08 09 2017   out_of_home_placement 1 1 0 0   0     0   0   0 2                       2 1 1 0 0   0     0   0   0 2                 2
477893 OK CREEK   school 4026910 19-I033   SAPULPA 402691001422 705 SAPULPA HS High School Regular School No High 10 12 2017   grade_10 197 21 30 62   0     1   39   178 172                       350 197 21 30 62   0     1   39   178 172                 350
477894 OK CREEK   school 4026910 19-I033   SAPULPA 402691001422 705 SAPULPA HS High School Regular School No High 10 12 2017   grade_11 203 16 22 73   3     2   51   188 182                       370 203 16 22 73   3     2   51   188 182                 370
477895 OK CREEK   school 4026910 19-I033   SAPULPA 402691001422 705 SAPULPA HS High School Regular School No High 10 12 2017   grade_12 171 13 21 50   2     0   34   156 135                       291 171 13 21 50   2     0   34   156 135                 291
477896 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   grade_1 23 0 4 2   0     0   10   16 23                       39 23 0 4 2   0     0   10   16 23                 39
477897 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   grade_2 18 0 1 3   0     0   18   21 19                       40 18 0 1 3   0     0   18   21 19                 40
477898 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   grade_3 27 2 2 3   0     0   13   22 25                       47 27 2 2 3   0     0   13   22 25                 47
477899 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   grade_4 17 1 2 2   0     0   21   21 22                       43 17 1 2 2   0     0   21   21 22                 43
477900 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   grade_5 18 1 1 8   1     0   12   22 19                       41 18 1 1 8   1     0   12   22 19                 41
477901 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   grade_6 7 2 2 10   0     0   10   15 16                       31 7 2 2 10   0     0   10   15 16                 31
477902 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 29 0 1 3   0     0   4   20 17                       37 29 0 1 3   0     0   4   20 17                 37
477903 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000440 115 BRADLEY ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 16 0 1 0   0     0   5   15 7                       22 16 0 1 0   0     0   5   15 7                 22
477904 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 07 08 2017   grade_7 21 1 2 2   0     0   1   16 11                       27 21 1 2 2   0     0   1   16 11                 27
477905 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 07 08 2017   grade_8 32 1 1 6   1     0   5   21 25                       46 32 1 1 6   1     0   5   21 25                 46
477906 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000441 705 DRUMRIGHT HS High School Regular School No High 09 12 2017   grade_10 34 1 3 8   2     0   9   29 28                       57 34 1 3 8   2     0   9   29 28                 57
477907 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000441 705 DRUMRIGHT HS High School Regular School No High 09 12 2017   grade_11 25 0 2 8   0     0   8   22 21                       43 25 0 2 8   0     0   8   22 21                 43
477908 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000441 705 DRUMRIGHT HS High School Regular School No High 09 12 2017   grade_12 28 1 1 9   0     0   10   30 19                       49 28 1 1 9   0     0   10   30 19                 49
477909 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020000441 705 DRUMRIGHT HS High School Regular School No High 09 12 2017   grade_9 35 0 4 2   1     0   1   19 24                       43 35 0 4 2   1     0   1   19 24                 43
477910 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_1 28 1 8 5   1     0   2   24 21                       45 28 1 8 5   1     0   2   24 21                 45
477911 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_2 25 0 3 0   0     0   3   17 14                       31 25 0 3 0   0     0   3   17 14                 31
477912 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_3 24 2 3 2   0     0   1   13 19                       32 24 2 3 2   0     0   1   13 19                 32
477913 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_4 31 0 6 3   0     0   0   22 18                       40 31 0 6 3   0     0   0   22 18                 40
477914 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_5 27 0 6 2   1     0   0   15 21                       36 27 0 6 2   1     0   0   15 21                 36
477915 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_6 20 1 2 1   1     0   0   13 12                       25 20 1 2 1   1     0   0   13 12                 25
477916 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_7 28 0 5 2   0     0   0   19 16                       35 28 0 5 2   0     0   0   19 16                 35
477917 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_8 24 1 1 1   1     0   0   15 13                       28 24 1 1 1   1     0   0   15 13                 28
477918 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 31 0 5 3   0     0   3   17 25                       42 31 0 5 3   0     0   3   17 25                 42
477919 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 30 0 3 2   0     0   4   21 18                       39 30 0 3 2   0     0   4   21 18                 39
477920 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312029657 715 ARAPAHO-BUTLER HS High School Regular School No High 09 12 2017   grade_10 21 0 3 0   0     0   3   12 15                       27 21 0 3 0   0     0   3   12 15                 27
477921 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312029657 715 ARAPAHO-BUTLER HS High School Regular School No High 09 12 2017   grade_11 21 0 2 2   0     0   0   12 13                       25 21 0 2 2   0     0   0   12 13                 25
477922 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312029657 715 ARAPAHO-BUTLER HS High School Regular School No High 09 12 2017   grade_12 26 0 2 0   0     0   0   13 15                       28 26 0 2 0   0     0   0   13 15                 28
477923 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312029657 715 ARAPAHO-BUTLER HS High School Regular School No High 09 12 2017   grade_9 19 0 0 0   0     0   4   11 12                       23 19 0 0 0   0     0   4   11 12                 23
477924 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   grade_1 25 0 6 3   0     0   1   18 17                       35 25 0 6 3   0     0   1   18 17                 35
477925 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   grade_2 31 1 6 6   0     0   2   29 17                       46 31 1 6 6   0     0   2   29 17                 46
477926 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   grade_3 26 1 3 8   0     0   2   23 17                       40 26 1 3 8   0     0   2   23 17                 40
477927 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   grade_4 22 1 5 4   0     0   0   13 19                       32 22 1 5 4   0     0   0   13 19                 32
477928 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   grade_5 20 0 5 4   0     0   2   16 15                       31 20 0 5 4   0     0   2   16 15                 31
477929 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   grade_6 29 2 4 3   0     0   0   23 15                       38 29 2 4 3   0     0   0   23 15                 38
477930 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501630 105 THOMAS ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 26 0 3 6   0     0   1   18 18                       36 26 0 3 6   0     0   1   18 18                 36

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