Data source: Big Local News · About: Big Local

58,650 rows where state = "OK" sorted by multiracial_int

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
480710 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000140 105 BILLINGS ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 2 0 0 1   0     0   0   2 1                       3 2 0 0 1   0     0   0   2 1                 3
480711 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000141 705 BILLINGS HS High School Regular School No High 09 12 2017   grade_10 9 0 0 0   0     0   0   4 5                       9 9 0 0 0   0     0   0   4 5                 9
480712 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000141 705 BILLINGS HS High School Regular School No High 09 12 2017   grade_11 4 0 0 1   0     0   0   4 1                       5 4 0 0 1   0     0   0   4 1                 5
480713 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000141 705 BILLINGS HS High School Regular School No High 09 12 2017   grade_12 4 0 1 0   0     0   0   3 2                       5 4 0 1 0   0     0   0   3 2                 5
480714 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000141 705 BILLINGS HS High School Regular School No High 09 12 2017   grade_9 3 0 0 1   0     0   0   3 1                       4 3 0 0 1   0     0   0   3 1                 4
480718 OK NOBLE   school 4000020 52-I004   FRONTIER 400002025620 105 FRONTIER ES Elementary Regular School No Elementary PK 08 2017   grade_4 9 1 3 15   0     0   0   18 10                       28 9 1 3 15   0     0   0   18 10                 28
480721 OK NOBLE   school 4000020 52-I004   FRONTIER 400002025620 105 FRONTIER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 2 16   1     0   0   17 14                       31 12 0 2 16   1     0   0   17 14                 31
480724 OK NOBLE   school 4000020 52-I004   FRONTIER 400002025620 105 FRONTIER ES Elementary Regular School No Elementary PK 08 2017   kindergarten_half_day 0 0 0 2   0     0   0   2 0                       2 0 0 0 2   0     0   0   2 0                 2
480726 OK NOBLE   school 4000020 52-I004   FRONTIER 400002029709 705 FRONTIER HS High School Regular School No High 09 12 2017   grade_10 9 0 7 16   0     0   0   14 18                       32 9 0 7 16   0     0   0   14 18                 32
480727 OK NOBLE   school 4000020 52-I004   FRONTIER 400002029709 705 FRONTIER HS High School Regular School No High 09 12 2017   grade_11 7 0 4 11   0     0   0   12 10                       22 7 0 4 11   0     0   0   12 10                 22
480728 OK NOBLE   school 4000020 52-I004   FRONTIER 400002029709 705 FRONTIER HS High School Regular School No High 09 12 2017   grade_12 8 0 1 16   0     0   0   12 13                       25 8 0 1 16   0     0   0   12 13                 25
480729 OK NOBLE   school 4000020 52-I004   FRONTIER 400002029709 705 FRONTIER HS High School Regular School No High 09 12 2017   grade_9 12 0 1 14   0     0   0   16 11                       27 12 0 1 14   0     0   0   16 11                 27
480737 OK NOBLE   school 4020340 52-I006   MORRISON 402034001010 105 MORRISON ES Elementary Regular School No Elementary PK 06 2017   out_of_home_placement 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
480741 OK NOBLE   school 4020340 52-I006   MORRISON 402034002657 510 MORRISON MS Middle Regular School No Middle 07 08 2017   out_of_home_placement 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
480746 OK NOBLE   school 4020340 52-I006   MORRISON 402034001011 705 MORRISON HS High School Regular School No High 09 12 2017   out_of_home_placement 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
480761 OK NOWATA   school 4021930 53-I040   NOWATA 402193001093 110 NOWATA ES Elementary Regular School No Elementary PK 05 2017   grade_1 26 4 2 27   0     0   0   29 30                       59 26 4 2 27   0     0   0   29 30                 59
480762 OK NOWATA   school 4021930 53-I040   NOWATA 402193001093 110 NOWATA ES Elementary Regular School No Elementary PK 05 2017   grade_2 29 3 3 41   0     0   0   42 34                       76 29 3 3 41   0     0   0   42 34                 76
480763 OK NOWATA   school 4021930 53-I040   NOWATA 402193001093 110 NOWATA ES Elementary Regular School No Elementary PK 05 2017   grade_3 25 1 3 31   0     0   0   26 34                       60 25 1 3 31   0     0   0   26 34                 60
480764 OK NOWATA   school 4021930 53-I040   NOWATA 402193001093 110 NOWATA ES Elementary Regular School No Elementary PK 05 2017   grade_4 28 6 0 33   1     0   0   38 30                       68 28 6 0 33   1     0   0   38 30                 68
480766 OK NOWATA   school 4021930 53-I040   NOWATA 402193001093 110 NOWATA ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 35 1 0 28   0     0   0   36 28                       64 35 1 0 28   0     0   0   36 28                 64
480767 OK NOWATA   school 4021930 53-I040   NOWATA 402193001093 110 NOWATA ES Elementary Regular School No Elementary PK 05 2017   out_of_home_placement 3 0 0 2   0     0   0   1 4                       5 3 0 0 2   0     0   0   1 4                 5
480770 OK NOWATA   school 4021930 53-I040   NOWATA 402193001095 505 NOWATA MS Middle Regular School No Middle 06 08 2017   grade_7 26 5 1 39   0     0   0   36 35                       71 26 5 1 39   0     0   0   36 35                 71
480771 OK NOWATA   school 4021930 53-I040   NOWATA 402193001095 505 NOWATA MS Middle Regular School No Middle 06 08 2017   grade_8 26 2 4 37   0     0   0   33 36                       69 26 2 4 37   0     0   0   33 36                 69
480772 OK NOWATA   school 4021930 53-I040   NOWATA 402193001094 705 NOWATA HS High School Regular School No High 09 12 2017   grade_10 28 3 5 30   0     0   0   34 32                       66 28 3 5 30   0     0   0   34 32                 66
480774 OK NOWATA   school 4021930 53-I040   NOWATA 402193001094 705 NOWATA HS High School Regular School No High 09 12 2017   grade_12 22 4 5 34   0     0   0   31 34                       65 22 4 5 34   0     0   0   31 34                 65
480775 OK NOWATA   school 4021930 53-I040   NOWATA 402193001094 705 NOWATA HS High School Regular School No High 09 12 2017   grade_9 28 3 3 27   0     0   0   33 28                       61 28 3 3 27   0     0   0   33 28                 61
480776 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_1 8 1 1 5   0     0   0   4 11                       15 8 1 1 5   0     0   0   4 11                 15
480779 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_4 16 0 0 4   0     0   0   11 9                       20 16 0 0 4   0     0   0   11 9                 20
480780 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_5 12 0 0 4   0     1   0   10 7                       17 12 0 0 4   0     1   0   10 7                 17
480781 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_6 15 0 0 4   0     0   0   14 5                       19 15 0 0 4   0     0   0   14 5                 19
480782 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 0 3   0     1   0   10 7                       17 13 0 0 3   0     1   0   10 7                 17
480783 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_8 11 0 0 4   0     1   0   8 8                       16 11 0 0 4   0     1   0   8 8                 16
480786 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001860 705 SOUTH COFFEYVILLE HS High School Regular School No High 09 12 2017   grade_10 13 1 0 9   0     0   0   12 11                       23 13 1 0 9   0     0   0   12 11                 23
480787 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001860 705 SOUTH COFFEYVILLE HS High School Regular School No High 09 12 2017   grade_11 14 0 0 8   0     0   0   11 11                       22 14 0 0 8   0     0   0   11 11                 22
480789 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001860 705 SOUTH COFFEYVILLE HS High School Regular School No High 09 12 2017   grade_9 13 0 1 4   0     0   0   8 10                       18 13 0 1 4   0     0   0   8 10                 18
480820 OK OKFUSKEE   school 4023340 54-I014   PADEN 402334001237 105 PADEN ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 1 1 5   0     0   0   11 6                       17 10 1 1 5   0     0   0   11 6                 17
480824 OK OKFUSKEE   school 4023340 54-I014   PADEN 402334001238 705 PADEN HS High School Regular School No High 09 12 2017   grade_10 12 0 1 5   0     0   0   10 8                       18 12 0 1 5   0     0   0   10 8                 18
480825 OK OKFUSKEE   school 4023340 54-I014   PADEN 402334001238 705 PADEN HS High School Regular School No High 09 12 2017   grade_11 12 2 0 2   0     0   0   11 5                       16 12 2 0 2   0     0   0   11 5                 16
480826 OK OKFUSKEE   school 4023340 54-I014   PADEN 402334001238 705 PADEN HS High School Regular School No High 09 12 2017   grade_12 8 1 1 6   0     0   0   8 8                       16 8 1 1 6   0     0   0   8 8                 16
480834 OK OKFUSKEE   school 4006850 54-I026   OKEMAH 400685002711 110 OKEMAH NOBLE CTR Elementary Regular School No Elementary 04 05 2017   grade_5 32 2 1 26   0     0   0   21 40                       61 32 2 1 26   0     0   0   21 40                 61
480836 OK OKFUSKEE   school 4006850 54-I026   OKEMAH 400685001901 505 OKEMAH MS Middle Regular School No Middle 06 08 2017   grade_7 24 3 1 21   0     0   0   25 24                       49 24 3 1 21   0     0   0   25 24                 49
480867 OK OKFUSKEE   school 4000782 54-I054   GRAHAM-DUSTIN 400078200609 705 GRAHAM HS High School Regular School No High 09 12 2017   grade_11 4 0 2 10   0     0   0   6 10                       16 4 0 2 10   0     0   0   6 10                 16
480869 OK OKFUSKEE   school 4000782 54-I054   GRAHAM-DUSTIN 400078200609 705 GRAHAM HS High School Regular School No High 09 12 2017   grade_9 4 0 2 13   0     1   0   13 7                       20 4 0 2 13   0     1   0   13 7                 20
480871 OK OKLAHOMA   school 4022350 55-C029   OAKDALE 402235001098 105 OAKDALE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 62 2 5 1   1     0   0   40 31                       71 62 2 5 1   1     0   0   40 31                 71
480875 OK OKLAHOMA   school 4022350 55-C029   OAKDALE 402235001098 105 OAKDALE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 53 4 5 3   3     0   0   33 35                       68 53 4 5 3   3     0   0   33 35                 68
480879 OK OKLAHOMA   school 4022350 55-C029   OAKDALE 402235001098 105 OAKDALE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_half_day 38 0 6 0   2     0   0   24 22                       46 38 0 6 0   2     0   0   24 22                 46
480884 OK OKLAHOMA   school 4009150 55-C074   CRUTCHO 400915000386 105 CRUTCHO PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 4 24 5 0   0     1   0   19 15                       34 4 24 5 0   0     1   0   19 15                 34
480886 OK OKLAHOMA   school 4009150 55-C074   CRUTCHO 400915000386 105 CRUTCHO PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 20 1 1   0     0   0   7 15                       22 0 20 1 1   0     0   0   7 15                 22
480891 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302308 971 ASTEC CHARTER MS Charter Regular School Yes Middle 06 08 2017   grade_6 10 6 136 3   5     0   0   86 74                       160 10 6 136 3   5     0   0   86 74                 160
480892 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302308 971 ASTEC CHARTER MS Charter Regular School Yes Middle 06 08 2017   grade_7 7 6 148 2   4     0   0   86 81                       167 7 6 148 2   4     0   0   86 81                 167
480893 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302308 971 ASTEC CHARTER MS Charter Regular School Yes Middle 06 08 2017   grade_8 6 7 134 2   1     0   0   70 80                       150 6 7 134 2   1     0   0   70 80                 150
480894 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302399 972 ASTEC CHARTER HS Charter Regular School Yes High 09 12 2017   grade_10 4 4 116 2   2     0   0   58 70                       128 4 4 116 2   2     0   0   58 70                 128
480896 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302399 972 ASTEC CHARTER HS Charter Regular School Yes High 09 12 2017   grade_12 12 4 76 0   3     0   0   51 44                       95 12 4 76 0   3     0   0   51 44                 95
481058 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863000882 105 LUTHER ES Elementary Regular School No Elementary PK 04 2017   grade_4 42 5 3 3   0     0   0   30 23                       53 42 5 3 3   0     0   0   30 23                 53
481084 OK OKLAHOMA   school 4007620 55-I004   CHOCTAW-NICOMA PARK 400762000314 115 NICOMA PARK ES Elementary Regular School No Elementary PK 02 2017   pre_kindergarten_full_day 2 0 0 0   0     0   0   2 0                       2 2 0 0 0   0     0   0   2 0                 2
481110 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000412 105 DEER CREEK ES Elementary Regular School No Elementary PK 04 2017   grade_2 48 6 3 6   10     0   0   40 33                       73 48 6 3 6   10     0   0   40 33                 73
481111 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000412 105 DEER CREEK ES Elementary Regular School No Elementary PK 04 2017   grade_3 53 1 7 8   12     0   0   38 43                       81 53 1 7 8   12     0   0   38 43                 81
481114 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000412 105 DEER CREEK ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 2 0 1 0   0     0   0   2 1                       3 2 0 1 0   0     0   0   2 1                 3
481115 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002243 110 PRAIRIE VALE ES Elementary Regular School No Elementary PK 04 2017   grade_1 83 3 10 10   8     0   0   56 58                       114 83 3 10 10   8     0   0   56 58                 114
481116 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002243 110 PRAIRIE VALE ES Elementary Regular School No Elementary PK 04 2017   grade_2 81 5 13 7   2     0   0   51 57                       108 81 5 13 7   2     0   0   51 57                 108
481117 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002243 110 PRAIRIE VALE ES Elementary Regular School No Elementary PK 04 2017   grade_3 75 3 7 8   6     1   0   49 51                       100 75 3 7 8   6     1   0   49 51                 100
481120 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002243 110 PRAIRIE VALE ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 4 0 1 0   0     0   0   2 3                       5 4 0 1 0   0     0   0   2 3                 5
481121 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002384 115 ROSE UNION ES Elementary Regular School No Elementary PK 04 2017   grade_1 50 5 5 11   0     0   0   45 26                       71 50 5 5 11   0     0   0   45 26                 71
481122 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002384 115 ROSE UNION ES Elementary Regular School No Elementary PK 04 2017   grade_2 58 1 3 5   2     0   0   38 31                       69 58 1 3 5   2     0   0   38 31                 69
481124 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002384 115 ROSE UNION ES Elementary Regular School No Elementary PK 04 2017   grade_4 49 1 4 5   0     0   0   25 34                       59 49 1 4 5   0     0   0   25 34                 59
481127 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002384 115 ROSE UNION ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 8 1 2 0   0     0   0   9 2                       11 8 1 2 0   0     0   0   9 2                 11
481129 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002696 120 GROVE VALLEY ES Elementary Regular School No Elementary PK 04 2017   grade_2 69 20 5 5   10     0   0   56 53                       109 69 20 5 5   10     0   0   56 53                 109
481132 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002696 120 GROVE VALLEY ES Elementary Regular School No Elementary PK 04 2017   kindergarten_full_day 66 9 5 10   8     4   0   50 52                       102 66 9 5 10   8     4   0   50 52                 102
481133 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002696 120 GROVE VALLEY ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 2 0 0 1   0     0   0   3 0                       3 2 0 0 1   0     0   0   3 0                 3
481136 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957002749 125 DEER CREEK INTERMEDIATE SCHOOL Elementary Regular School No Middle 05 06 2017   out_of_home_placement 2 1 0 0   0     0   0   3 0                       3 2 1 0 0   0     0   0   3 0                 3
481145 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000414 505 DEER CREEK MS Middle Regular School No Middle 07 08 2017   out_of_home_placement 3 0 1 0   0     0   0   4 0                       4 3 0 1 0   0     0   0   4 0                 4
481146 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000413 705 DEER CREEK HS High School Regular School No High 09 12 2017   grade_10 281 20 27 35   20     2   0   186 199                       385 281 20 27 35   20     2   0   186 199                 385
481147 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000413 705 DEER CREEK HS High School Regular School No High 09 12 2017   grade_11 276 20 23 24   15     1   0   182 177                       359 276 20 23 24   15     1   0   182 177                 359
481148 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000413 705 DEER CREEK HS High School Regular School No High 09 12 2017   grade_12 246 16 23 25   19     1   0   166 164                       330 246 16 23 25   19     1   0   166 164                 330
481150 OK OKLAHOMA   school 4009570 55-I006   DEER CREEK 400957000413 705 DEER CREEK HS High School Regular School No High 09 12 2017   out_of_home_placement 2 0 0 0   0     0   0   1 1                       2 2 0 0 0   0     0   0   1 1                 2
481166 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000746 105 JONES ES Elementary Regular School No Elementary PK 05 2017   grade_2 61 7 7 9   0     1   0   50 35                       85 61 7 7 9   0     1   0   50 35                 85
481167 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000746 105 JONES ES Elementary Regular School No Elementary PK 05 2017   grade_3 67 3 7 10   0     0   0   39 48                       87 67 3 7 10   0     0   0   39 48                 87
481169 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000746 105 JONES ES Elementary Regular School No Elementary PK 05 2017   grade_5 59 5 4 7   0     0   0   50 25                       75 59 5 4 7   0     0   0   50 25                 75
481170 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000746 105 JONES ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 50 6 4 6   0     1   0   37 30                       67 50 6 4 6   0     1   0   37 30                 67
481171 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000746 105 JONES ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 29 3 2 6   0     0   0   21 19                       40 29 3 2 6   0     0   0   21 19                 40
481172 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000745 505 JONES MS Middle Regular School No Middle 06 08 2017   grade_6 72 4 5 7   0     0   0   40 48                       88 72 4 5 7   0     0   0   40 48                 88
481174 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000745 505 JONES MS Middle Regular School No Middle 06 08 2017   grade_8 72 6 9 5   0     0   0   50 42                       92 72 6 9 5   0     0   0   50 42                 92
481185 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000472 105 CLEGERN ES Elementary Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
481224 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000482 130 SUNSET ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
481232 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000483 135 WILL ROGERS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 0 0 0 0   1     0   0   1 0                       1 0 0 0 0   1     0   0   1 0                 1
481239 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000471 140 CHISHOLM ES Elementary Regular School No Elementary PK 05 2017   out_of_home_placement 5 2 0 1   0     0   0   8 0                       8 5 2 0 1   0     0   0   8 0                 8
481254 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001965 150 CHARLES HASKELL ES Elementary Regular School No Elementary PK 05 2017   out_of_home_placement 2 5 1 1   0     0   0   8 1                       9 2 5 1 1   0     0   0   8 1                 9
481308 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000475 505 CIMARRON MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
481337 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001360 720 SANTA FE HS High School Regular School No High 09 12 2017   out_of_home_placement 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
481425 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995000966 135 PLEASANT HILL EC CTR Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 3 13 4 2   0     0   0   10 12                       22 3 13 4 2   0     0   0   10 12                 22
481540 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_1 4 2 1 0   1     0   0   4 4                       8 4 2 1 0   1     0   0   4 4                 8
481541 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_2 2 6 1 0   1     0   0   8 2                       10 2 6 1 0   1     0   0   8 2                 10
481542 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_3 1 3 0 0   0     0   0   1 3                       4 1 3 0 0   0     0   0   1 3                 4
481543 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_4 1 2 0 2   0     0   0   2 3                       5 1 2 0 2   0     0   0   2 3                 5
481544 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_5 4 0 0 0   0     0   0   3 1                       4 4 0 0 0   0     0   0   3 1                 4
481545 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_6 2 0 0 1   0     0   0   1 2                       3 2 0 0 1   0     0   0   1 2                 3
481547 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   grade_8 5 4 0 0   0     0   0   6 3                       9 5 4 0 0   0     0   0   6 3                 9
481548 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 4 0 2 0   0     0   0   3 3                       6 4 0 2 0   0     0   0   3 3                 6
481549 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_half_day 3 3 3 1   0     0   0   8 2                       10 3 3 3 1   0     0   0   8 2                 10
481577 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001115 123 BODINE ES Elementary Regular School No Elementary PK 06 2017   grade_6 16 26 15 2   0     0   0   29 30                       59 16 26 15 2   0     0   0   29 30                 59

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