Data source: Big Local News · About: Big Local

2,320 rows where grade = "k_12_total", state = "MO" and year = 2020 sorted by ccd_school_lvl

View and edit SQL

year

  • 2020 · 2,320

grade

  • k_12_total · 2,320
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
3296690 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2020   k_12_total 121 * * *   *       * *           *         79   24   121 121                                     79 24   121
3296708 MO     school 2916740 1091   KIRKSVILLE R-III 291674002219 4030 KIRKSVILLE PRIMARY   Regular School No Elementary PK 02 2020   k_12_total 411 42 22 *   11       * 19           41         315   88   505 411 42 22     11         19           41     315 88   505
3296714 MO     school 2916740 1091   KIRKSVILLE R-III 291674000917 4050 RAY MILLER ELEM.   Regular School No Elementary 03 05 2020   k_12_total 447 34 10 *   12       * 23           31         283   72   526 447 34 10     12         23           31     283 72   526
3296726 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2020   k_12_total 69 * * *   *       * *           *         28   14   70 69                                     28 14   70
3296744 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001250 4020 NORTH ANDREW ELEM.   Regular School No Elementary PK 05 2020   k_12_total 144 * * *   *       * *           *         57   14   145 144                                     57 14   145
3296750 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2020   k_12_total 154 * * *   *       * 5           *         21   15   163 154                   5                 21 15   163
3296768 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 88 * * *   *       * *           *         39   18   93 88                                     39 18   93
3296774 MO     school 2927570 2097   SAVANNAH R-III 292757001689 4015 HELENA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 94 * 5 *   *       * *           *         24   13   102 94   5                                 24 13   102
3296780 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 251 5 9 *   *       * 5           *         96   37   270 251 5 9               5                 96 37   270
3296786 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 584 7 6 *   *       * 13           *         231   84   614 584 7 6               13                 231 84   614
3296804 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 05 2020   k_12_total 140 * 6 *   *       * *           *         82   24   151 140   6                                 82 24   151
3296816 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2020   k_12_total 169 6 * *   *       * *           *         68   21   181 169 6                                   68 21   181
3296828 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2020   k_12_total 68 * * *   *       * *           *         28.2   8   69 68                                       8   69
3296840 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 127 * * *   *       * *           *         83   32   131 127                                     83 32   131
3296852 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2020   k_12_total 248 11 15 *   *       * 25           5         162   36   299 248 11 15               25           5     162 36   299
3296870 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 05 2020   k_12_total 284 51 27 *   *       * 50           15         *   50   416 284 51 27               50           15       50   416
3296876 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary 01 05 2020   k_12_total 322 30 47 *   *       * 44           28         *   53   444 322 30 47               44           28       53   444
3296882 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN EARLY LEARNING CENTER   Regular School No Elementary PK KG 2020   k_12_total 151 13 16 *   *       * 18           12         *   39   199 151 13 16               18           12       39   199
3296894 MO     school 2931950 5120   WHEATON R-III 293195002236 4020 WHEATON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 156 * 8 *   46       5 16           36         158   36   232 156   8     46       5 16           36     158 36   232
3296912 MO     school 2928710 5121   SOUTHWEST R-V 292871001773 4020 SOUTHWEST ELEM.   Regular School No Elementary PK 04 2020   k_12_total 225 * 11 5   *       * 6           *         175   49   251 225   11 5             6                 175 49   251
3296924 MO     school 2911670 5122   EXETER R-VI 291167000426 4020 EXETER ELEM.   Regular School No Elementary PK 08 2020   k_12_total 170 * 7 *   18       * *           11         139   29   195 170   7     18                     11     139 29   195
3296942 MO     school 2908170 5123   CASSVILLE R-IV 290817000217 4020 EUNICE THOMAS ELEM.   Regular School No Elementary PK 02 2020   k_12_total 372 * 20 *   *       * 13           13         251   48   411 372   20               13           13     251 48   411
3296948 MO     school 2908170 5123   CASSVILLE R-IV 290817002718 4030 CASSVILLE INTERMEDIATE   Regular School No Elementary 03 05 2020   k_12_total 382 * 23 *   6       * 16           16         253   58   430 382   23     6         16           16     253 58   430
3296964 MO     school 2925620 5124   PURDY R-II 292562001501 4020 PURDY ELEM.   Regular School No Elementary PK 06 2020   k_12_total 219 * 122 *   8       * *           103         229   75   356 219   122     8                     103     229 75   356
3296971 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2020   k_12_total 72 * * *   *       * 60           *         *   21   133 72                   60                   21   133
3296989 MO     school 2921120 5128   MONETT R-I 292112003089 4000 CENTRAL PARK ELEM.   Regular School No Elementary 03 04 2020   k_12_total 161 * 127 *   16       * 7           114         240   55   317 161   127     16         7           114     240 55   317
3296995 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2020   k_12_total 249 * 191 *   20       5 11           195         345   48   480 249   191     20       5 11           195     345 48   480
3297019 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2020   k_12_total 137 * * *   *       * 8           *         72   21   150 137                   8                 72 21   150
3297031 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 81 * * *   *       * 11           *         73   9   95 81                   11                 73 9   95
3297055 MO     school 2917850 6104   LAMAR R-I 291785000953 4020 LAMAR ELEM.   Regular School No Elementary 03 05 2020   k_12_total 198 * 16 *   *       * 14           *         156   58   236 198   16               14                 156 58   236
3297061 MO     school 2917850 6104   LAMAR R-I 291785002720 4040 EAST ELEM.   Regular School No Elementary PK 02 2020   k_12_total 230 * 15 *   *       * 16           *         178   49   264 230   15               16                 178 49   264
3297073 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2020   k_12_total 77 * * *   *       * 10           *         36   7   90 77                   10                 36 7   90
3297085 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2020   k_12_total 60 * * *   *       * *           *         29   13   67 60                                     29 13   67
3297097 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2020   k_12_total 296 * 6 *   *       * *           *         105   41   303 296   6                                 105 41   303
3297109 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2020   k_12_total 159 7 * *   *       * *           *         111.1   25   176 159 7                                     25   176
3297121 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2020   k_12_total 61 * * *   *       * *           *         39   8   67 61                                     39 8   67
3297127 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No Elementary PK 08 2020   k_12_total 36 * * *   *       * *           *         *   *   36 36                                           36
3297139 MO     school 2906360 7129   BUTLER R-V 290636000157 4020 BUTLER ELEM.   Regular School No Elementary KG 06 2020   k_12_total 410 * 14 *   *       * 21           *         278   78   449 410   14               21                 278 78   449
3297154 MO     school 2918670 8106   LINCOLN R-II 291867001015 4020 LINCOLN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 244 * * *   *       * 7           *         153   44   256 244                   7                 153 44   256
3297172 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary KG 05 2020   k_12_total 318 * 8 *   *       * 14           *         *   81   348 318   8               14                   81   348
3297178 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No Elementary PK 05 2020   k_12_total 140 * * *   *       * 5           *         *   23   150 140                   5                   23   150
3297201 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No Elementary KG 04 2020   k_12_total 229 * 10 *   *       * 16           7         159   40   255 229   10               16           7     159 40   255
3297220 MO     school 2923640 9077   MEADOW HEIGHTS R-II 292364001407 4020 MEADOW HEIGHTS ELEM.   Regular School No Elementary PK 05 2020   k_12_total 202 * * *   *       * 5           *         123   26   207 202                   5                 123 26   207
3297232 MO     school 2918420 9078   LEOPOLD R-III 291842000988 4020 LEOPOLD ELEM.   Regular School No Elementary KG 06 2020   k_12_total 102 * * *   *       * *           *         32   13   102 102                                     32 13   102
3297244 MO     school 2932490 9079   ZALMA R-V 293249002269 4020 ZALMA ELEM.   Regular School No Elementary KG 06 2020   k_12_total 112 * * *   *       * *           *         *   18   112 112                                       18   112
3297262 MO     school 2919350 9080   WOODLAND R-IV 291935001045 4040 WOODLAND ELEM.   Regular School No Elementary PK 04 2020   k_12_total 322 * * *   *       * *           *         219   44   327 322                                     219 44   327
3297280 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856002802 4010 SOUTHERN BOONE PRIMARY   Regular School No Elementary PK 02 2020   k_12_total 427 * 12 *   *       * 20           *         81   46   464 427   12               20                 81 46   464
3297286 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001765 4020 SOUTHERN BOONE ELEM.   Regular School No Elementary 03 05 2020   k_12_total 399 * 12 *   *       * 21           *         84   41   438 399   12               21                 84 41   438
3297304 MO     school 2913560 10089   HALLSVILLE R-IV 291356000577 4020 HALLSVILLE INTERMEDIATE   Regular School No Elementary 02 05 2020   k_12_total 387 11 12 *   8       * 31           *         155   44   451 387 11 12     8         31                 155 44   451
3297310 MO     school 2913560 10089   HALLSVILLE R-IV 291356002975 4040 HALLSVILLE PRIMARY   Regular School No Elementary PK 01 2020   k_12_total 201 * 7 *   6       * 13           5         78   23   231 201   7     6         13           5     78 23   231
3297328 MO     school 2929700 10090   STURGEON R-V 292970002052 4020 STURGEON ELEM.   Regular School No Elementary PK 04 2020   k_12_total 130 * * *   *       * 7           *         57   21   139 130                   7                 57 21   139
3297346 MO     school 2908400 10091   CENTRALIA R-VI 290840000242 4020 CHANCE ELEM.   Regular School No Elementary PK 02 2020   k_12_total 272 * 8 *   *       * 14           *         94   28   299 272   8               14                 94 28   299
3297352 MO     school 2908400 10091   CENTRALIA R-VI 290840003092 4050 CENTRALIA INTERMEDIATE   Regular School No Elementary 03 05 2020   k_12_total 281 * 6 *   *       * 8           *         88.4   38   297 281   6               8                   38   297
3297370 MO     school 2913710 10092   HARRISBURG R-VIII 291371000598 4020 HARRISBURG ELEM.   Regular School No Elementary PK 05 2020   k_12_total 230 6 5 *   *       * *           *         98   26   244 230 6 5                                 98 26   244
3297442 MO     school 2901000 10093   COLUMBIA 93 290100000313 4020 THOMAS BENTON ELEM.   Regular School No Elementary PK 05 2020   k_12_total 88 94 * *   *       * 33           *         *   33   219 88 94                 33                   33   219
3297448 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2020   k_12_total 147 135 13 *   6       * 76           13         *   49   380 147 135 13     6         76           13       49   380
3297454 MO     school 2901000 10093   COLUMBIA 93 290100000298 4040 BLUE RIDGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 135 144 111 *   14       * 43           103         *   52   448 135 144 111     14         43           103       52   448
3297460 MO     school 2901000 10093   COLUMBIA 93 290100002279 4050 CEDAR RIDGE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 259 75 23 *   10       * 39           11         176   43   410 259 75 23     10         39           11     176 43   410
3297466 MO     school 2901000 10093   COLUMBIA 93 290100002665 4055 DERBY RIDGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 151 176 47 *   30       * 60           69         *   81   466 151 176 47     30         60           69       81   466
3297472 MO     school 2901000 10093   COLUMBIA 93 290100000303 4060 FAIRVIEW ELEM.   Regular School No Elementary PK 05 2020   k_12_total 329 61 18 *   46       * 27           64         142   33   481 329 61 18     46         27           64     142 33   481
3297477 MO     school 2901000 10093   COLUMBIA 93 290100003271 4070 ELIOT BATTLE ELEMENTARY   Regular School No Elementary KG 05 2020   k_12_total 186 158 23 *   5       * 52           33         *   55   427 186 158 23     5         52           33       55   427
3297483 MO     school 2901000 10093   COLUMBIA 93 290100000315 5000 ULYSSES S. GRANT ELEM.   Regular School No Elementary PK 05 2020   k_12_total 170 54 18 *   34       * 21           43         103.1   18   297 170 54 18     34         21           43       18   297
3297489 MO     school 2901000 10093   COLUMBIA 93 290100002770 5010 MARY PAXTON KEELEY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 407 70 34 *   88       * 72           103         218   39   674 407 70 34     88         72           103     218 39   674
3297495 MO     school 2901000 10093   COLUMBIA 93 290100000308 5020 Locust St Expressive Arts Elem   Regular School No Elementary PK 05 2020   k_12_total 97 46 6 *   28       * 23           39         93   13   201 97 46 6     28         23           39     93 13   201
3297501 MO     school 2901000 10093   COLUMBIA 93 290100001142 5025 MIDWAY HEIGHTS ELEM.   Regular School No Elementary PK 05 2020   k_12_total 193 * 8 *   5       * 14           *         57   13   222 193   8     5         14                 57 13   222
3297507 MO     school 2901000 10093   COLUMBIA 93 290100002546 5030 MILL CREEK ELEM.   Regular School No Elementary PK 05 2020   k_12_total 493 48 23 *   70       * 32           35         114   29   666 493 48 23     70         32           35     114 29   666
3297513 MO     school 2901000 10093   COLUMBIA 93 290100002280 5035 NEW HAVEN ELEM.   Regular School No Elementary PK 05 2020   k_12_total 123 61 59 *   16       * 26           73         159   35   285 123 61 59     16         26           73     159 35   285
3297519 MO     school 2901000 10093   COLUMBIA 93 290100000307 5040 PARKADE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 249 110 34 *   23       6 70           55         285   43   494 249 110 34     23       6 70           55     285 43   494
3297523 MO     school 2901000 10093   COLUMBIA 93 290100003292 5050 BEULAH RALPH ELEMENTARY   Regular School No Elementary KG 05 2020   k_12_total 498 58 26 *   38       * 56           32         153   64   681 498 58 26     38         56           32     153 64   681
3297529 MO     school 2901000 10093   COLUMBIA 93 290100000305 5060 JOHN RIDGEWAY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 175 18 9 *   11       * 24           *         27   22   238 175 18 9     11         24                 27 22   238
3297535 MO     school 2901000 10093   COLUMBIA 93 290100000309 5080 ROCK BRIDGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 335 49 27 *   31       * 39           38         138   29   485 335 49 27     31         39           38     138 29   485
3297541 MO     school 2901000 10093   COLUMBIA 93 290100000310 6000 RUSSELL BLVD. ELEM.   Regular School No Elementary PK 05 2020   k_12_total 335 27 22 *   11       * 36           25         126   48   432 335 27 22     11         36           25     126 48   432
3297547 MO     school 2901000 10093   COLUMBIA 93 290100000312 6010 SHEPARD BLVD. ELEM.   Regular School No Elementary PK 05 2020   k_12_total 261 119 25 *   10       * 64           42         263   48   485 261 119 25     10         64           42     263 48   485
3297553 MO     school 2901000 10093   COLUMBIA 93 290100000316 6020 WEST BLVD. ELEM.   Regular School No Elementary PK 05 2020   k_12_total 112 128 19 *   7       * 45           28         *   50   312 112 128 19     7         45           28       50   312
3297559 MO     school 2901000 10093   COLUMBIA 93 290100000314 6040 TWO MILE PRAIRIE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 141 * 9 *   *       * 13           6         58   20   170 141   9               13           6     58 20   170
3297565 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2020   k_12_total 31 * * *   *       * *           *         *   *   40 31                                           40
3297587 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125000390 4040 EAST BUCHANAN ELEM.   Regular School No Elementary PK 05 2020   k_12_total 303 * * *   *       * 11           *         84   60   319 303                   11                 84 60   319
3297599 MO     school 2911940 11078   MID-BUCHANAN CO. R-V 291194000443 4020 MID-BUCHANAN ELEM.   Regular School No Elementary PK 06 2020   k_12_total 387 5 * *   *       * *           *         79   64   401 387 5                                   79 64   401
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
3297659 MO     school 2927060 11082   ST. JOSEPH 292706001649 4040 EDISON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 159 57 78 *   *       17 60           79         *   47   375 159 57 78             17 60           79       47   375
3297665 MO     school 2927060 11082   ST. JOSEPH 292706001650 4060 ELLISON ELEM.   Regular School No Elementary KG 06 2020   k_12_total 266 24 21 *   7       * 36           17         137   44   354 266 24 21     7         36           17     137 44   354
3297671 MO     school 2927060 11082   ST. JOSEPH 292706003250 4070 CARDEN PARK ELEM   Regular School No Elementary KG 06 2020   k_12_total 429 47 64 *   *       10 55           62         *   101   606 429 47 64             10 55           62       101   606
3297677 MO     school 2927060 11082   ST. JOSEPH 292706003255 4080 OAK GROVE ELEM   Regular School No Elementary PK 06 2020   k_12_total 353 32 40 *   38       * 45           43         148   56   512 353 32 40     38         45           43     148 56   512
3297683 MO     school 2927060 11082   ST. JOSEPH 292706001652 4100 FIELD ELEM.   Regular School No Elementary KG 06 2020   k_12_total 235 10 11 *   29       * 19           37         112   18   308 235 10 11     29         19           37     112 18   308
3297689 MO     school 2927060 11082   ST. JOSEPH 292706001654 4140 COLEMAN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 165 63 41 *   25       38 37           107         *   37   369 165 63 41     25       38 37           107       37   369
3297695 MO     school 2927060 11082   ST. JOSEPH 292706001657 4180 HOSEA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 358 14 63 *   *       15 37           70         *   46   489 358 14 63             15 37           70       46   489
3297705 MO     school 2927060 11082   ST. JOSEPH 292706001659 4220 HYDE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 280 6 26 *   *       * 26           27         206   30   342 280 6 26               26           27     206 30   342
3297715 MO     school 2927060 11082   ST. JOSEPH 292706001662 4260 LINDBERGH ELEM.   Regular School No Elementary KG 05 2020   k_12_total 353 31 49 *   *       18 62           47         *   50   515 353 31 49             18 62           47       50   515
3297721 MO     school 2927060 11082   ST. JOSEPH 292706001663 4280 MARK TWAIN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 244 30 24 *   6       * 48           24         *   33   355 244 30 24     6         48           24       33   355
3297727 MO     school 2927060 11082   ST. JOSEPH 292706001667 4390 PARKWAY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 311 15 21 *   *       7 37           16         *   33   396 311 15 21             7 37           16       33   396
3297733 MO     school 2927060 11082   ST. JOSEPH 292706001668 4400 PERSHING ELEM.   Regular School No Elementary KG 06 2020   k_12_total 226 9 18 *   *       * 27           18         149   42   284 226 9 18               27           18     149 42   284
3297739 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No Elementary PK 06 2020   k_12_total 232 10 15 *   *       * 31           5         *   33   291 232 10 15               31           5       33   291
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
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
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
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
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
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
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
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

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