Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 11,652
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
3025948 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001271 105 PIEDMONT ES Elementary Regular School No Elementary 01 04 2020   grade_1 86 0 13 8   6     0   3   60 56                       116 86 0 13 8   6     0   3   60 56                 116
3025949 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001271 105 PIEDMONT ES Elementary Regular School No Elementary 01 04 2020   grade_2 90 0 10 8   1     0   2   60 51                       111 90 0 10 8   1     0   2   60 51                 111
3025950 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001271 105 PIEDMONT ES Elementary Regular School No Elementary 01 04 2020   grade_3 51 2 7 5   0     0   7   38 34                       72 51 2 7 5   0     0   7   38 34                 72
3025951 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001271 105 PIEDMONT ES Elementary Regular School No Elementary 01 04 2020   grade_4 87 4 12 7   0     0   8   48 70                       118 87 4 12 7   0     0   8   48 70                 118
3025952 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   grade_1 90 3 8 15   8     0   12   71 65                       136 90 3 8 15   8     0   12   71 65                 136
3025953 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   grade_2 91 5 11 6   4     0   9   61 65                       126 91 5 11 6   4     0   9   61 65                 126
3025954 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   grade_3 76 5 9 14   9     0   7   64 56                       120 76 5 9 14   9     0   7   64 56                 120
3025955 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   grade_4 82 11 11 9   6     0   8   68 59                       127 82 11 11 9   6     0   8   68 59                 127
3025956 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   out_of_home_placement 2 0 0 0   0     0   0   0 2                       2 2 0 0 0   0     0   0   0 2                 2
3025957 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2020   grade_1 91 4 15 10   0     0   3   59 64                       123 91 4 15 10   0     0   3   59 64                 123
3025958 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2020   grade_2 82 2 12 6   4     1   1   50 58                       108 82 2 12 6   4     1   1   50 58                 108
3025959 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2020   grade_3 83 7 9 14   3     1   5   61 61                       122 83 7 9 14   3     1   5   61 61                 122
3025960 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2020   grade_4 66 3 17 5   2     0   8   46 55                       101 66 3 17 5   2     0   8   46 55                 101
3025961 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2020   out_of_home_placement 1 0 1 0   0     0   0   0 2                       2 1 0 1 0   0     0   0   0 2                 2
3026031 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000489 135 ROSE WITCHER ES Elementary Regular School No Elementary 01 02 2020   grade_1 85 4 46 19   0     0   21   86 89                       175 85 4 46 19   0     0   21   86 89                 175
3026032 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000489 135 ROSE WITCHER ES Elementary Regular School No Elementary 01 02 2020   grade_2 80 4 45 30   0     0   20   85 94                       179 80 4 45 30   0     0   20   85 94                 179
3026153 OK CARTER   school 4003180 10-I019   ARDMORE 400318000069 110 CHARLES EVANS ES Elementary Regular School No Elementary 01 05 2020   grade_1 33 9 15 8   6     0   19   50 40                       90 33 9 15 8   6     0   19   50 40                 90
3026154 OK CARTER   school 4003180 10-I019   ARDMORE 400318000069 110 CHARLES EVANS ES Elementary Regular School No Elementary 01 05 2020   grade_2 29 7 15 8   1     0   14   35 39                       74 29 7 15 8   1     0   14   35 39                 74
3026155 OK CARTER   school 4003180 10-I019   ARDMORE 400318000069 110 CHARLES EVANS ES Elementary Regular School No Elementary 01 05 2020   grade_3 31 10 14 7   2     0   14   38 40                       78 31 10 14 7   2     0   14   38 40                 78
3026156 OK CARTER   school 4003180 10-I019   ARDMORE 400318000069 110 CHARLES EVANS ES Elementary Regular School No Elementary 01 05 2020   grade_4 41 14 12 3   2     0   7   37 42                       79 41 14 12 3   2     0   7   37 42                 79
3026157 OK CARTER   school 4003180 10-I019   ARDMORE 400318000069 110 CHARLES EVANS ES Elementary Regular School No Elementary 01 05 2020   grade_5 41 12 12 8   2     0   6   42 39                       81 41 12 12 8   2     0   6   42 39                 81
3026158 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_1 9 15 18 3   0     0   12   33 24                       57 9 15 18 3   0     0   12   33 24                 57
3026159 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_2 8 11 10 9   0     0   17   32 23                       55 8 11 10 9   0     0   17   32 23                 55
3026160 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_3 16 10 17 6   0     0   6   22 33                       55 16 10 17 6   0     0   6   22 33                 55
3026161 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_4 13 11 12 4   0     0   11   23 28                       51 13 11 12 4   0     0   11   23 28                 51
3026162 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_5 7 8 9 7   0     1   13   23 22                       45 7 8 9 7   0     1   13   23 22                 45
3026163 OK CARTER   school 4003180 10-I019   ARDMORE 400318029632 125 LINCOLN ES Elementary Regular School No Elementary 01 05 2020   grade_1 25 11 17 13   0     0   16   45 37                       82 25 11 17 13   0     0   16   45 37                 82
3026164 OK CARTER   school 4003180 10-I019   ARDMORE 400318029632 125 LINCOLN ES Elementary Regular School No Elementary 01 05 2020   grade_2 30 9 10 9   0     0   11   32 37                       69 30 9 10 9   0     0   11   32 37                 69
3026165 OK CARTER   school 4003180 10-I019   ARDMORE 400318029632 125 LINCOLN ES Elementary Regular School No Elementary 01 05 2020   grade_3 25 8 14 7   1     0   12   39 28                       67 25 8 14 7   1     0   12   39 28                 67
3026166 OK CARTER   school 4003180 10-I019   ARDMORE 400318029632 125 LINCOLN ES Elementary Regular School No Elementary 01 05 2020   grade_4 23 11 18 4   0     0   21   42 35                       77 23 11 18 4   0     0   21   42 35                 77
3026167 OK CARTER   school 4003180 10-I019   ARDMORE 400318029632 125 LINCOLN ES Elementary Regular School No Elementary 01 05 2020   grade_5 21 3 11 6   1     0   21   35 28                       63 21 3 11 6   1     0   21   35 28                 63
3026947 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001923 115 JOHN K HUBBARD ES Elementary Regular School No Elementary 01 03 2020   grade_1 138 1 21 14   1     0   22   119 78                       197 138 1 21 14   1     0   22   119 78                 197
3026948 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001923 115 JOHN K HUBBARD ES Elementary Regular School No Elementary 01 03 2020   grade_2 134 1 11 14   0     0   26   97 89                       186 134 1 11 14   0     0   26   97 89                 186
3026949 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163001923 115 JOHN K HUBBARD ES Elementary Regular School No Elementary 01 03 2020   grade_3 153 0 15 15   0     1   21   121 84                       205 153 0 15 15   0     1   21   121 84                 205
3027462 OK CREEK   school 4018840 19-I003   MANNFORD 401884000893 105 MANNFORD LOWER ES Elementary Regular School No Elementary 01 03 2020   grade_1 64 0 0 6   1     0   15   47 39                       86 64 0 0 6   1     0   15   47 39                 86
3027463 OK CREEK   school 4018840 19-I003   MANNFORD 401884000893 105 MANNFORD LOWER ES Elementary Regular School No Elementary 01 03 2020   grade_2 55 1 5 9   1     0   12   40 43                       83 55 1 5 9   1     0   12   40 43                 83
3027464 OK CREEK   school 4018840 19-I003   MANNFORD 401884000893 105 MANNFORD LOWER ES Elementary Regular School No Elementary 01 03 2020   grade_3 72 0 5 11   1     0   13   47 55                       102 72 0 5 11   1     0   13   47 55                 102
3028132 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355001247 110 JACKSON ES Elementary Regular School No Elementary 01 03 2020   grade_1 50 10 19 16   1     0   0   46 50                       96 50 10 19 16   1     0   0   46 50                 96
3028133 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355001247 110 JACKSON ES Elementary Regular School No Elementary 01 03 2020   grade_2 58 4 11 18   0     0   0   45 46                       91 58 4 11 18   0     0   0   45 46                 91
3028134 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355001247 110 JACKSON ES Elementary Regular School No Elementary 01 03 2020   grade_3 35 4 22 19   0     0   0   41 39                       80 35 4 22 19   0     0   0   41 39                 80
3028287 OK GRADY   school 4030420 26-I097   TUTTLE 403042001693 105 TUTTLE ES Elementary Regular School No Elementary 01 03 2020   grade_1 88 3 10 13   1     0   4   65 54                       119 88 3 10 13   1     0   4   65 54                 119
3028288 OK GRADY   school 4030420 26-I097   TUTTLE 403042001693 105 TUTTLE ES Elementary Regular School No Elementary 01 03 2020   grade_2 109 2 3 14   1     0   1   68 62                       130 109 2 3 14   1     0   1   68 62                 130
3028289 OK GRADY   school 4030420 26-I097   TUTTLE 403042001693 105 TUTTLE ES Elementary Regular School No Elementary 01 03 2020   grade_3 102 0 10 13   1     1   5   70 62                       132 102 0 10 13   1     1   5   70 62                 132
3028628 OK JACKSON   school 4002850 33-I018   ALTUS 400285000035 155 ALTUS PRIMARY SCHOOL Elementary Regular School No Elementary 01 02 2020   grade_1 69 17 108 3   1     1   18   127 90                       217 69 17 108 3   1     1   18   127 90                 217
3028629 OK JACKSON   school 4002850 33-I018   ALTUS 400285000035 155 ALTUS PRIMARY SCHOOL Elementary Regular School No Elementary 01 02 2020   grade_2 76 19 90 2   2     0   17   110 96                       206 76 19 90 2   2     0   17   110 96                 206
3031992 OK OSAGE   school 4014970 57-I038   HOMINY 401497000705 105 HORACE MANN ES Elementary Regular School No Elementary 01 05 2020   grade_1 24 4 1 19   0     0   0   20 28                       48 24 4 1 19   0     0   0   20 28                 48
3031993 OK OSAGE   school 4014970 57-I038   HOMINY 401497000705 105 HORACE MANN ES Elementary Regular School No Elementary 01 05 2020   grade_2 19 0 1 27   0     0   0   20 27                       47 19 0 1 27   0     0   0   20 27                 47
3031994 OK OSAGE   school 4014970 57-I038   HOMINY 401497000705 105 HORACE MANN ES Elementary Regular School No Elementary 01 05 2020   grade_3 14 0 0 23   0     0   1   23 15                       38 14 0 0 23   0     0   1   23 15                 38
3031995 OK OSAGE   school 4014970 57-I038   HOMINY 401497000705 105 HORACE MANN ES Elementary Regular School No Elementary 01 05 2020   grade_4 18 2 0 25   0     0   3   25 23                       48 18 2 0 25   0     0   3   25 23                 48
3031996 OK OSAGE   school 4014970 57-I038   HOMINY 401497000705 105 HORACE MANN ES Elementary Regular School No Elementary 01 05 2020   grade_5 18 0 3 22   0     0   1   21 23                       44 18 0 3 22   0     0   1   21 23                 44
3032492 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000917 105 EDMOND DOYLE ES Elementary Regular School No Elementary 01 04 2020   grade_1 23 4 6 6   0     0   12   29 22                       51 23 4 6 6   0     0   12   29 22                 51
3032493 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000917 105 EDMOND DOYLE ES Elementary Regular School No Elementary 01 04 2020   grade_2 16 1 6 6   1     0   16   24 22                       46 16 1 6 6   1     0   16   24 22                 46
3032494 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000917 105 EDMOND DOYLE ES Elementary Regular School No Elementary 01 04 2020   grade_3 19 5 8 4   0     0   7   17 26                       43 19 5 8 4   0     0   7   17 26                 43
3032495 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000917 105 EDMOND DOYLE ES Elementary Regular School No Elementary 01 04 2020   grade_4 12 0 6 5   0     0   13   16 20                       36 12 0 6 5   0     0   13   16 20                 36
3032496 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000918 110 EMERSON ES Elementary Regular School No Elementary 01 04 2020   grade_1 19 1 9 10   0     0   20   31 28                       59 19 1 9 10   0     0   20   31 28                 59
3032497 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000918 110 EMERSON ES Elementary Regular School No Elementary 01 04 2020   grade_2 26 4 17 15   0     0   6   30 38                       68 26 4 17 15   0     0   6   30 38                 68
3032498 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000918 110 EMERSON ES Elementary Regular School No Elementary 01 04 2020   grade_3 20 1 21 4   0     0   15   27 34                       61 20 1 21 4   0     0   15   27 34                 61
3032499 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000918 110 EMERSON ES Elementary Regular School No Elementary 01 04 2020   grade_4 28 2 14 6   0     0   18   34 34                       68 28 2 14 6   0     0   18   34 34                 68
3032502 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000927 130 WILL ROGERS ES Elementary Regular School No Elementary 01 04 2020   grade_1 50 4 16 18   1     0   26   66 49                       115 50 4 16 18   1     0   26   66 49                 115
3032503 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000927 130 WILL ROGERS ES Elementary Regular School No Elementary 01 04 2020   grade_2 49 2 9 15   0     0   28   59 44                       103 49 2 9 15   0     0   28   59 44                 103
3032504 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000927 130 WILL ROGERS ES Elementary Regular School No Elementary 01 04 2020   grade_3 51 1 9 17   2     1   17   55 43                       98 51 1 9 17   2     1   17   55 43                 98
3032505 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000927 130 WILL ROGERS ES Elementary Regular School No Elementary 01 04 2020   grade_4 54 0 15 9   1     0   17   57 39                       96 54 0 15 9   1     0   17   57 39                 96
3032568 OK PONTOTOC   school 4002430 62-I019   ADA 400243000006 110 HAYES ES Elementary Regular School No Elementary 01 02 2020   grade_1 77 2 24 71   1     0   19   112 82                       194 77 2 24 71   1     0   19   112 82                 194
3032569 OK PONTOTOC   school 4002430 62-I019   ADA 400243000006 110 HAYES ES Elementary Regular School No Elementary 01 02 2020   grade_2 69 2 22 57   1     0   37   99 89                       188 69 2 22 57   1     0   37   99 89                 188
3032734 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001552 105 BARNARD ES Elementary Regular School No Elementary 01 02 2020   grade_1 84 2 11 31   0     0   19   76 71                       147 84 2 11 31   0     0   19   76 71                 147
3032735 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001552 105 BARNARD ES Elementary Regular School No Elementary 01 02 2020   grade_2 84 5 9 29   0     1   29   84 73                       157 84 5 9 29   0     1   29   84 73                 157
3032759 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001459 130 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_1 23 4 7 13   0     0   16   42 21                       63 23 4 7 13   0     0   16   42 21                 63
3032760 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001459 130 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_2 21 2 6 6   0     0   8   23 20                       43 21 2 6 6   0     0   8   23 20                 43
3032761 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001459 130 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_3 23 7 12 9   0     0   13   38 26                       64 23 7 12 9   0     0   13   38 26                 64
3032762 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001459 130 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_4 34 3 8 11   0     0   12   41 27                       68 34 3 8 11   0     0   12   41 27                 68
3032763 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001459 130 JEFFERSON ES Elementary Regular School No Elementary 01 05 2020   grade_5 21 5 7 8   0     0   15   33 23                       56 21 5 7 8   0     0   15   33 23                 56
3032769 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001466 145 WILL ROGERS ES Elementary Regular School No Elementary 01 05 2020   grade_1 40 2 11 13   0     0   16   36 46                       82 40 2 11 13   0     0   16   36 46                 82
3032770 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001466 145 WILL ROGERS ES Elementary Regular School No Elementary 01 05 2020   grade_2 39 3 7 18   0     0   9   40 36                       76 39 3 7 18   0     0   9   40 36                 76
3032771 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001466 145 WILL ROGERS ES Elementary Regular School No Elementary 01 05 2020   grade_3 30 4 6 10   0     0   18   38 30                       68 30 4 6 10   0     0   18   38 30                 68
3032772 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001466 145 WILL ROGERS ES Elementary Regular School No Elementary 01 05 2020   grade_4 35 4 5 12   1     0   14   38 33                       71 35 4 5 12   1     0   14   38 33                 71
3032773 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757001466 145 WILL ROGERS ES Elementary Regular School No Elementary 01 05 2020   grade_5 32 2 9 16   0     0   11   35 35                       70 32 2 9 16   0     0   11   35 35                 70
3034498 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837002824 125 HERALD ES Elementary Regular School No Elementary 01 02 2020   grade_1 111 1 17 44   8     0   40   124 97                       221 111 1 17 44   8     0   40   124 97                 221
3034499 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837002824 125 HERALD ES Elementary Regular School No Elementary 01 02 2020   grade_2 111 0 18 39   9     0   35   122 90                       212 111 0 18 39   9     0   35   122 90                 212
3034736 OK TULSA   school 4012720 72-I013   GLENPOOL 401272000593 105 GLENPOOL ES Elementary Regular School No Elementary 01 04 2020   grade_1 91 5 21 34   19     1   38   108 101                       209 91 5 21 34   19     1   38   108 101                 209
3034737 OK TULSA   school 4012720 72-I013   GLENPOOL 401272000593 105 GLENPOOL ES Elementary Regular School No Elementary 01 04 2020   grade_2 114 5 23 30   19     0   35   114 112                       226 114 5 23 30   19     0   35   114 112                 226
3034738 OK TULSA   school 4012720 72-I013   GLENPOOL 401272000593 105 GLENPOOL ES Elementary Regular School No Elementary 01 04 2020   grade_3 87 3 17 38   17     2   41   109 96                       205 87 3 17 38   17     2   41   109 96                 205
3034739 OK TULSA   school 4012720 72-I013   GLENPOOL 401272000593 105 GLENPOOL ES Elementary Regular School No Elementary 01 04 2020   grade_4 100 5 22 35   12     0   36   119 91                       210 100 5 22 35   12     0   36   119 91                 210
3034995 OK WOODS   school 4002880 76-I001   ALVA 400288000044 110 LONGFELLOW ES Elementary Regular School No Elementary 01 03 2020   grade_2 60 1 8 0   1     0   2   37 35                       72 60 1 8 0   1     0   2   37 35                 72
3034996 OK WOODS   school 4002880 76-I001   ALVA 400288000044 110 LONGFELLOW ES Elementary Regular School No Elementary 01 03 2020   grade_3 66 4 5 5   2     0   4   41 45                       86 66 4 5 5   2     0   4   41 45                 86
3035035 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318001820 105 CEDAR HEIGHTS ES Elementary Regular School No Elementary 01 04 2020   grade_1 50 2 18 5   1     0   0   42 34                       76 50 2 18 5   1     0   0   42 34                 76
3035036 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318001820 105 CEDAR HEIGHTS ES Elementary Regular School No Elementary 01 04 2020   grade_2 56 4 8 4   3     0   0   38 37                       75 56 4 8 4   3     0   0   38 37                 75
3035037 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318001820 105 CEDAR HEIGHTS ES Elementary Regular School No Elementary 01 04 2020   grade_3 44 1 15 0   0     0   0   33 27                       60 44 1 15 0   0     0   0   33 27                 60
3035038 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318001820 105 CEDAR HEIGHTS ES Elementary Regular School No Elementary 01 04 2020   grade_4 55 0 12 2   1     0   0   36 34                       70 55 0 12 2   1     0   0   36 34                 70
3035039 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029832 115 HORACE MANN ES Elementary Regular School No Elementary 01 04 2020   grade_1 47 1 26 3   0     0   0   41 36                       77 47 1 26 3   0     0   0   41 36                 77
3035040 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029832 115 HORACE MANN ES Elementary Regular School No Elementary 01 04 2020   grade_2 44 1 21 5   0     0   0   35 36                       71 44 1 21 5   0     0   0   35 36                 71
3035041 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029832 115 HORACE MANN ES Elementary Regular School No Elementary 01 04 2020   grade_3 38 0 20 5   0     0   0   27 36                       63 38 0 20 5   0     0   0   27 36                 63
3035042 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029832 115 HORACE MANN ES Elementary Regular School No Elementary 01 04 2020   grade_4 35 1 22 2   0     0   0   33 27                       60 35 1 22 2   0     0   0   33 27                 60
3035046 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029835 130 HIGHLAND PARK ES Elementary Regular School No Elementary 01 04 2020   grade_1 36 2 18 3   0     0   0   27 32                       59 36 2 18 3   0     0   0   27 32                 59
3035047 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029835 130 HIGHLAND PARK ES Elementary Regular School No Elementary 01 04 2020   grade_2 40 1 21 1   0     0   0   39 24                       63 40 1 21 1   0     0   0   39 24                 63
3035048 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029835 130 HIGHLAND PARK ES Elementary Regular School No Elementary 01 04 2020   grade_3 38 1 13 4   0     0   0   32 24                       56 38 1 13 4   0     0   0   32 24                 56
3035049 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029835 130 HIGHLAND PARK ES Elementary Regular School No Elementary 01 04 2020   grade_4 40 0 25 3   2     0   1   35 36                       71 40 0 25 3   2     0   1   35 36                 71
3035225 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001271 105 PIEDMONT ES Elementary Regular School No Elementary 01 04 2020   k_12_total 314 6 42 28   7     0   20   206 211                       417 314 6 42 28   7     0   20   206 211                 417
3035226 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   k_12_total 341 24 39 44   27     0   36   264 247                       511 341 24 39 44   27     0   36   264 247                 511
3035227 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2020   k_12_total 323 16 54 35   9     2   17   216 240                       456 323 16 54 35   9     2   17   216 240                 456
3035245 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000489 135 ROSE WITCHER ES Elementary Regular School No Elementary 01 02 2020   k_12_total 165 8 91 49   0     0   41   171 183                       354 165 8 91 49   0     0   41   171 183                 354

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