Data source: Big Local News · About: Big Local

257,968 rows where state = "MO" sorted by ell_int

View and edit SQL

grade

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
3297601 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000355 1050 DEKALB JR.-SR. HIGH   Regular School No 3 07 12 2016   k_12_total 130 * * *   *       * *           *         61   15   137 130                                     61 15   137
3297602 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000355 1050 DEKALB JR.-SR. HIGH   Regular School No High 07 12 2017   k_12_total 129 * * *   *       * *           *         54   15   134 129                                     54 15   134
3297603 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000355 1050 DEKALB JR.-SR. HIGH   Regular School No High 07 12 2018   k_12_total 115 * * *   *       * *           *         49   15   118 115                                     49 15   118
3297604 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000355 1050 DEKALB JR.-SR. HIGH   Regular School No High 07 12 2019   k_12_total 119 * * *   *       * *           *         44   15   125 119                                     44 15   125
3297605 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000355 1050 DEKALB JR.-SR. HIGH   Regular School No High 07 12 2020   k_12_total 115 * * *   *       * *           *         50   16   120 115                                     50 16   120
3297606 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No 1 PK 06 2015   k_12_total 165 * * *   *       * *           *         94   18   171 165                                     94 18   171
3297607 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No 1 PK 06 2016   k_12_total 177 * * *   *       * *           *         93   18   182 177                                     93 18   182
3297608 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 180 * * *   *       * *           *         94   27   184 180                                     94 27   184
3297609 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No Elementary PK 06 2018   k_12_total 160 * * *   *       * *           *         81   22   164 160                                     81 22   164
3297610 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No Elementary PK 06 2019   k_12_total 170 * * *   *       * *           *         73   23   170 170                                     73 23   170
3297611 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 170 * * *   *       * *           *         68   23   171 170                                     68 23   171
3297660 MO     school 2927060 11082   ST. JOSEPH 292706001650 4060 ELLISON ELEM.   Regular School No 1 PK 06 2015   k_12_total 304 28 17 *   5       * 21           *         126   42   379 304 28 17     5         21                 126 42   379
3297735 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No 1 PK 06 2016   k_12_total 254 10 18 *   *       * 20           *         194   55   305 254 10 18               20                 194 55   305
3297737 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No Elementary PK 06 2018   k_12_total 244 10 19 *   *       * 36           *         *   47   313 244 10 19               36                   47   313
3297738 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No Elementary PK 06 2019   k_12_total 235 11 17 *   *       * 38           *         *   35   301 235 11 17               38                   35   301
3297745 MO     school 2927060 11082   ST. JOSEPH 292706001672 4460 SKAITH ELEM.   Regular School No Elementary PK 06 2020   k_12_total 306 12 16 *   5       * 48           *         226   35   391 306 12 16     5         48                 226 35   391
3297746 MO     school 2921750 12108   NEELYVILLE R-IV 292175001200 1050 NEELYVILLE HIGH   Regular School No 3 07 12 2015   k_12_total 257 17 * *   *       * *           *         167   42   276 257 17                                   167 42   276
3297747 MO     school 2921750 12108   NEELYVILLE R-IV 292175001200 1050 NEELYVILLE HIGH   Regular School No 3 07 12 2016   k_12_total 252 20 * *   *       * *           *         169   38   275 252 20                                   169 38   275
3297748 MO     school 2921750 12108   NEELYVILLE R-IV 292175001200 1050 NEELYVILLE HIGH   Regular School No High 07 12 2017   k_12_total 238 15 * *   *       * *           *         157   34   261 238 15                                   157 34   261
3297749 MO     school 2921750 12108   NEELYVILLE R-IV 292175001200 1050 NEELYVILLE HIGH   Regular School No High 07 12 2018   k_12_total 241 15 5 *   *       * *           *         159   38   267 241 15 5                                 159 38   267
3297750 MO     school 2921750 12108   NEELYVILLE R-IV 292175001200 1050 NEELYVILLE HIGH   Regular School No High 07 12 2019   k_12_total 232 17 * *   *       * 5           *         138   38   261 232 17                 5                 138 38   261
3297751 MO     school 2921750 12108   NEELYVILLE R-IV 292175001200 1050 NEELYVILLE HIGH   Regular School No High 07 12 2020   k_12_total 244 16 * *   7       * *           *         137   38   274 244 16       7                           137 38   274
3297752 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No 1 PK 02 2015   k_12_total 131 7 * *   *       * *           *         96   22   141 131 7                                   96 22   141
3297753 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No 1 PK 02 2016   k_12_total 117 5 * *   *       * *           *         92   20   129 117 5                                   92 20   129
3297754 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No Elementary PK 02 2017   k_12_total 115 * * *   *       * *           *         94   19   124 115                                     94 19   124
3297755 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No Elementary PK 02 2018   k_12_total 127 * * *   *       * 6           *         83   29   134 127                   6                 83 29   134
3297756 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No Elementary PK 02 2019   k_12_total 135 * * *   *       * 5           *         93   26   142 135                   5                 93 26   142
3297757 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No Elementary PK 02 2020   k_12_total 151 * * *   *       * 6           *         112   29   159 151                   6                 112 29   159
3297758 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No 1 03 06 2015   k_12_total 154 13 * *   *       * *           *         116   34   173 154 13                                   116 34   173
3297759 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No 1 03 06 2016   k_12_total 162 13 * *   *       * *           *         128   34   180 162 13                                   128 34   180
3297760 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No Elementary 03 06 2017   k_12_total 166 12 * *   *       * *           *         119   33   182 166 12                                   119 33   182
3297761 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No Elementary 03 06 2018   k_12_total 172 11 * *   *       * 6           *         147   34   194 172 11                 6                 147 34   194
3297762 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No Elementary 03 06 2019   k_12_total 185 6 * *   *       * 7           *         137   44   202 185 6                 7                 137 44   202
3297763 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No Elementary 03 06 2020   k_12_total 162 5 * *   *       * 6           *         119   27   176 162 5                 6                 119 27   176
3297764 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001475 1050 POPLAR BLUFF HIGH   Regular School No 3 09 12 2015   k_12_total 1234 136 37 *   19       * 7           *         724   175   1437 1234 136 37     19         7                 724 175   1437
3297767 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001475 1050 POPLAR BLUFF HIGH   Regular School No High 09 12 2018   k_12_total 1213 179 32 9   6       * 21           *         715   151   1460 1213 179 32 9   6         21                 715 151   1460
3297768 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001475 1050 POPLAR BLUFF HIGH   Regular School No High 09 12 2019   k_12_total 1221 163 26 7   6       * 30           *         706   156   1453 1221 163 26 7   6         30                 706 156   1453
3297769 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001475 1050 POPLAR BLUFF HIGH   Regular School No High 09 12 2020   k_12_total 1217 184 34 10   7       * 28           *         742   169   1480 1217 184 34 10   7         28                 742 169   1480
3297772 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2017   k_12_total 654 92 22 *   *       * 17           *         503   109   792 654 92 22               17                 503 109   792
3297773 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2018   k_12_total 660 101 18 *   *       * 22           *         482.1   116   806 660 101 18               22                   116   806
3297774 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2019   k_12_total 626 93 18 5   *       * 23           *         471.1   131   768 626 93 18 5             23                   131   768
3297775 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 654 75 18 *   *       * 39           *         490.2   147   792 654 75 18               39                   147   792
3297776 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No 1 01 04 2015   k_12_total 329 55 13 *   *       * 16           *         366   75   414 329 55 13               16                 366 75   414
3297777 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No 1 01 04 2016   k_12_total 299 53 14 *   *       * 21           *         356   78   390 299 53 14               21                 356 78   390
3297778 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2017   k_12_total 245 56 8 *   *       * 18           *         297   62   329 245 56 8               18                 297 62   329
3297779 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2018   k_12_total 251 41 8 *   *       * 24           *         *   54   326 251 41 8               24                   54   326
3297780 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2019   k_12_total 243 30 8 *   *       * 19           *         *   48   300 243 30 8               19                   48   300
3297781 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2020   k_12_total 234 45 6 *   *       * 20           *         *   52   307 234 45 6               20                   52   307
3297784 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001947 4040 POPLAR BLUFF MIDDLE SCHOOL   Regular School No Elementary 04 06 2017   k_12_total 975 142 25 5   *       * 46           *         824.1   239   1196 975 142 25 5             46                   239   1196
3297785 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001947 4040 POPLAR BLUFF MIDDLE SCHOOL   Regular School No Middle 04 06 2018   k_12_total 955 135 30 5   *       * 67           *         789   283   1197 955 135 30 5             67                 789 283   1197
3297786 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001947 4040 POPLAR BLUFF MIDDLE SCHOOL   Regular School No Middle 04 06 2019   k_12_total 915 132 30 7   5       * 83           *         756.1   240   1173 915 132 30 7   5         83                   240   1173
3297787 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001947 4040 POPLAR BLUFF MIDDLE SCHOOL   Regular School No Middle 04 06 2020   k_12_total 845 115 27 *   6       * 85           *         744   230   1081 845 115 27     6         85                 744 230   1081
3297788 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No 1 01 04 2015   k_12_total 177 62 8 *   *       * 21           *         244   53   269 177 62 8               21                 244 53   269
3297789 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No 1 01 04 2016   k_12_total 186 53 * *   *       * 35           *         242   57   278 186 53                 35                 242 57   278
3297790 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 03 2017   k_12_total 124 41 6 *   *       * 25           *         168.2   51   197 124 41 6               25                   51   197
3297791 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 03 2018   k_12_total 118 43 * *   *       * 25           *         *   44   191 118 43                 25                   44   191
3297792 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 04 2019   k_12_total 168 44 6 *   *       * 32           *         *   56   251 168 44 6               32                   56   251
3297793 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 05 2020   k_12_total 224 49 * *   *       * 34           *         *   61   310 224 49                 34                   61   310
3297794 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No 1 KG KG 2015   k_12_total 309 50 5 *   *       * 31           *         296   48   400 309 50 5               31                 296 48   400
3297795 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No 1 KG KG 2016   k_12_total 304 39 8 *   *       * 31           *         302   47   385 304 39 8               31                 302 47   385
3297796 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No Elementary KG KG 2017   k_12_total 289 44 9 *   *       * 25           *         288   40   370 289 44 9               25                 288 40   370
3297797 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No Elementary KG KG 2018   k_12_total 295 37 13 *   *       * 24           *         *   44   371 295 37 13               24                   44   371
3297798 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No Elementary KG KG 2019   k_12_total 301 40 8 *   *       * 22           *         *   50   374 301 40 8               22                   50   374
3297799 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No Elementary KG KG 2020   k_12_total 273 45 8 *   *       * 30           *         *   43   359 273 45 8               30                   43   359
3297800 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No 1 01 04 2015   k_12_total 418 20 11 *   *       * 15           *         262   63   468 418 20 11               15                 262 63   468
3297801 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No 1 01 04 2016   k_12_total 426 27 9 *   *       * 26           *         289   68   494 426 27 9               26                 289 68   494
3297802 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2017   k_12_total 282 20 9 *   *       * 21           *         196   49   334 282 20 9               21                 196 49   334
3297803 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2018   k_12_total 257 23 10 *   *       * 17           *         *   41   311 257 23 10               17                   41   311
3297804 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2019   k_12_total 243 15 8 *   *       * 18           *         *   40   289 243 15 8               18                   40   289
3297805 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2020   k_12_total 256 17 9 *   5       * 12           *         *   42   300 256 17 9     5         12                   42   300
3297806 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No 1 01 04 2015   k_12_total 425 40 10 *   *       * 12           *         268   94   490 425 40 10               12                 268 94   490
3297807 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No 1 01 04 2016   k_12_total 439 49 6 *   *       * 17           *         283   98   514 439 49 6               17                 283 98   514
3297808 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2017   k_12_total 286 35 7 *   *       * 22           *         246   72   350 286 35 7               22                 246 72   350
3297809 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2018   k_12_total 273 35 6 *   *       * 27           *         *   84   343 273 35 6               27                   84   343
3297810 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2019   k_12_total 260 39 9 *   *       * 29           *         *   83   339 260 39 9               29                   83   339
3297811 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2020   k_12_total 265 40 7 *   *       * 15           *         *   81   330 265 40 7               15                   81   330
3297812 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297813 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297814 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297815 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297816 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297817 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297818 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No 3 09 12 2015   k_12_total 305 * * *   *       * *           *         181   63   307 305                                     181 63   307
3297819 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No 3 09 12 2016   k_12_total 318 * * *   *       * *           *         207   62   320 318                                     207 62   320
3297820 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No High 09 12 2017   k_12_total 302 * * *   *       * *           *         182   51   306 302                                     182 51   306
3297821 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No High 09 12 2018   k_12_total 264 * * *   *       * *           *         156   53   269 264                                     156 53   269
3297822 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No High 09 12 2019   k_12_total 246 * * *   *       * *           *         *   40   252 246                                       40   252
3297823 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No High 09 12 2020   k_12_total 247 * 6 *   *       * 5           *         *   42   263 247   6               5                   42   263
3297824 MO     school 2930520 12110   TWIN RIVERS R-X 293052003337 3000 QULIN MIDDLE   Regular School No Middle 05 08 2019   k_12_total 131 * * *   *       * *           *         *   29   137 131                                       29   137
3297825 MO     school 2930520 12110   TWIN RIVERS R-X 293052003337 3000 QULIN MIDDLE   Regular School No Middle 04 08 2020   k_12_total 139 * * *   *       * *           *         *   22   146 139                                       22   146
3297826 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEM.   Regular School No 1 PK 08 2015   k_12_total 380 * * *   *       * *           *         270   65   384 380                                     270 65   384
3297827 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEM.   Regular School No 1 KG 08 2016   k_12_total 371 * * *   *       * *           *         256   72   375 371                                     256 72   375
3297828 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEM.   Regular School No Elementary PK 08 2017   k_12_total 352 * * *   *       * *           *         240   67   358 352                                     240 67   358
3297829 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEM.   Regular School No Elementary KG 08 2018   k_12_total 338 * * *   *       * *           *         230   75   343 338                                     230 75   343
3297830 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEMENTARY   Regular School No Elementary PK 08 2019   k_12_total 345 * * *   *       * *           *         *   70   353 345                                       70   353
3297831 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEMENTARY   Regular School No Elementary PK 08 2020   k_12_total 330 * 10 *   *       * 12           *         *   72   357 330   10               12                   72   357
3297832 MO     school 2930520 12110   TWIN RIVERS R-X 293052002094 4060 QULIN ELEM.   Regular School No 1 PK 08 2015   k_12_total 279 * * *   *       * *           *         203   54   281 279                                     203 54   281
3297833 MO     school 2930520 12110   TWIN RIVERS R-X 293052002094 4060 QULIN ELEM.   Regular School No 1 KG 08 2016   k_12_total 277 * * *   *       * *           *         196   59   285 277                                     196 59   285
3297834 MO     school 2930520 12110   TWIN RIVERS R-X 293052002094 4060 QULIN ELEM.   Regular School No Elementary PK 08 2017   k_12_total 274 * * *   *       * *           *         187   51   279 274                                     187 51   279
3297835 MO     school 2930520 12110   TWIN RIVERS R-X 293052002094 4060 QULIN ELEM.   Regular School No Elementary KG 08 2018   k_12_total 283 * * *   *       * *           *         177   44   290 283                                     177 44   290

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