Data source: Big Local News · About: Big Local

2,295 rows where grade = "k_12_total", state = "MO" and year = 2017 sorted by ccd_school_lvl

View and edit SQL

year

  • 2017 · 2,295

grade

  • k_12_total · 2,295
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
3303721 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3303931 MO     school   60077   MCDONALD CO. R-I   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3296687 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2017   k_12_total 113 * * *   *       * *           *         72   11   114 113                                     72 11   114
3296705 MO     school 2916740 1091   KIRKSVILLE R-III 291674002219 4030 KIRKSVILLE PRIMARY   Regular School No Elementary PK 02 2017   k_12_total 453 38 8 *   10       * 24           33         300   84   533 453 38 8     10         24           33     300 84   533
3296711 MO     school 2916740 1091   KIRKSVILLE R-III 291674000917 4050 RAY MILLER ELEM.   Regular School No Elementary 03 05 2017   k_12_total 511 27 11 *   10       * 34           16         326   79   594 511 27 11     10         34           16     326 79   594
3296723 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2017   k_12_total 89 * * *   *       * *           *         45   15   95 89                                     45 15   95
3296741 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001250 4020 NORTH ANDREW ELEM.   Regular School No Elementary KG 05 2017   k_12_total 153 * * *   *       * *           *         57   14   153 153                                     57 14   153
3296747 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2017   k_12_total 141 * * *   *       * 6           *         24   7   151 141                   6                 24 7   151
3296765 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary PK 05 2017   k_12_total 90 * * *   *       * *           *         52   13   93 90                                     52 13   93
3296771 MO     school 2927570 2097   SAVANNAH R-III 292757001689 4015 HELENA ELEM.   Regular School No Elementary PK 05 2017   k_12_total 90 * * *   *       * *           *         31   11   97 90                                     31 11   97
3296777 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 250 15 14 *   *       * *           *         86   31   282 250 15 14                                 86 31   282
3296783 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 522 6 9 *   *       * 8           *         232.3   84   549 522 6 9               8                   84   549
3296789 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296801 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 06 2017   k_12_total 157 * 7 *   *       * *           *         86   20   168 157   7                                 86 20   168
3296813 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2017   k_12_total 178 * * *   *       * *           *         78   16   182 178                                     78 16   182
3296825 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2017   k_12_total 65 * * *   *       * *           *         29.2   8   67 65                                       8   67
3296837 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 115 * * *   *       * 6           *         75   25   122 115                   6                 75 25   122
3296849 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2017   k_12_total 254 9 6 *   *       * 23           *         164   34   292 254 9 6               23                 164 34   292
3296867 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary KG 05 2017   k_12_total 325 43 23 *   *       * 43           *         *   37   435 325 43 23               43                   37   435
3296873 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 309 26 66 *   *       * 39           54         *   19   444 309 26 66               39           54       19   444
3296879 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 181 10 * *   *       * 19           *         *   23   214 181 10                 19                   23   214
3296891 MO     school 2931950 5120   WHEATON R-III 293195002236 4020 WHEATON ELEM.   Regular School No Elementary PK 06 2017   k_12_total 157 * 21 *   25       8 *           46         152   28   214 157   21     25       8             46     152 28   214
3296909 MO     school 2928710 5121   SOUTHWEST R-V 292871001773 4020 SOUTHWEST ELEM.   Regular School No Elementary PK 04 2017   k_12_total 283 * 12 5   *       * 6           *         206   40   306 283   12 5             6                 206 40   306
3296921 MO     school 2911670 5122   EXETER R-VI 291167000426 4020 EXETER ELEM.   Regular School No Elementary KG 08 2017   k_12_total 195 * 9 *   12       * *           14         174   27   219 195   9     12                     14     174 27   219
3296939 MO     school 2908170 5123   CASSVILLE R-IV 290817000217 4020 EUNICE THOMAS ELEM.   Regular School No Elementary PK 02 2017   k_12_total 380 * 17 *   *       * 7           16         252   24   408 380   17               7           16     252 24   408
3296945 MO     school 2908170 5123   CASSVILLE R-IV 290817002718 4030 CASSVILLE INTERMEDIATE   Regular School No Elementary 03 05 2017   k_12_total 369 * 27 *   *       * 16           22         262   29   417 369   27               16           22     262 29   417
3296961 MO     school 2925620 5124   PURDY R-II 292562001501 4020 PURDY ELEM.   Regular School No Elementary KG 04 2017   k_12_total 144 * 14 *   11       74 *           78         179   47   246 144   14     11       74             78     179 47   246
3296968 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2017   k_12_total 112 * * *   *       * 8           *         *   22   123 112                   8                   22   123
3296986 MO     school 2921120 5128   MONETT R-I 292112003089 4000 CENTRAL PARK ELEM.   Regular School No Elementary 03 04 2017   k_12_total 202 * 138 8   5       * 5           103         235   64   359 202   138 8   5         5           103     235 64   359
3296992 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2017   k_12_total 271 * 182 *   *       * 13           166         343.1   83   478 271   182               13           166       83   478
3297016 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2017   k_12_total 166 7 * *   *       * *           *         104   22   181 166 7                                   104 22   181
3297028 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 90 * * *   *       * 12           *         70   14   102 90                   12                 70 14   102
3297052 MO     school 2917850 6104   LAMAR R-I 291785000953 4020 LAMAR ELEM.   Regular School No Elementary 03 05 2017   k_12_total 247 * 15 *   *       * 19           6         166   58   285 247   15               19           6     166 58   285
3297058 MO     school 2917850 6104   LAMAR R-I 291785002720 4040 EAST ELEM.   Regular School No Elementary PK 02 2017   k_12_total 204 * 11 *   *       * 16           6         147   30   235 204   11               16           6     147 30   235
3297070 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2017   k_12_total 73 * 6 *   *       * *           *         39   8   85 73   6                                 39 8   85
3297082 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary PK 06 2017   k_12_total 66 * * *   *       * *           *         43   14   72 66                                     43 14   72
3297094 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 325 * * *   *       * *           *         145   36   328 325                                     145 36   328
3297106 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2017   k_12_total 150 * * *   *       * 7           *         *   23   161 150                   7                   23   161
3297118 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2017   k_12_total 82 * * *   *       * *           *         62   13   85 82                                     62 13   85
3297124 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No Elementary PK 08 2017   k_12_total 40 * * *   *       * *           *         6   5   40 40                                     6 5   40
3297136 MO     school 2906360 7129   BUTLER R-V 290636000157 4020 BUTLER ELEM.   Regular School No Elementary PK 06 2017   k_12_total 491 7 12 *   *       * 24           *         330   82   536 491 7 12               24                 330 82   536
3297151 MO     school 2918670 8106   LINCOLN R-II 291867001015 4020 LINCOLN ELEM.   Regular School No Elementary KG 06 2017   k_12_total 251 * 6 *   *       * *           *         177   47   264 251   6                                 177 47   264
3297169 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 03 05 2017   k_12_total 142 * * *   *       * 10           *         *   33   154 142                   10                   33   154
3297175 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No Elementary PK 05 2017   k_12_total 196 * * *   *       * 5           *         *   36   203 196                   5                   36   203
3297181 MO     school 2931070 8107   WARSAW R-IX 293107000834 4060 RUTH MERCER ELEM.   Regular School No Elementary KG 02 2017   k_12_total 144 * * *   *       * 10           *         *   39   159 144                   10                   39   159
3297198 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No Elementary KG 04 2017   k_12_total 230 * 10 *   *       * *           12         151   28   240 230   10                           12     151 28   240
3297203 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297217 MO     school 2923640 9077   MEADOW HEIGHTS R-II 292364001407 4020 MEADOW HEIGHTS ELEM.   Regular School No Elementary PK 06 2017   k_12_total 305 * * *   *       * *           *         172.1   44   312 305                                       44   312
3297229 MO     school 2918420 9078   LEOPOLD R-III 291842000988 4020 LEOPOLD ELEM.   Regular School No Elementary KG 06 2017   k_12_total 113 * * *   *       * *           *         36   15   113 113                                     36 15   113
3297241 MO     school 2932490 9079   ZALMA R-V 293249002269 4020 ZALMA ELEM.   Regular School No Elementary KG 06 2017   k_12_total 128 * * *   *       * *           *         98   25   130 128                                     98 25   130
3297259 MO     school 2919350 9080   WOODLAND R-IV 291935001045 4040 WOODLAND ELEM.   Regular School No Elementary PK 04 2017   k_12_total 350 * * *   *       * *           *         252   42   353 350                                     252 42   353
3297277 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856002802 4010 SOUTHERN BOONE PRIMARY   Regular School No Elementary PK 02 2017   k_12_total 367 5 7 *   *       * 18           *         97   33   399 367 5 7               18                 97 33   399
3297283 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001765 4020 SOUTHERN BOONE ELEM.   Regular School No Elementary 03 05 2017   k_12_total 338 * 8 *   *       * 13           *         75   26   365 338   8               13                 75 26   365
3297301 MO     school 2913560 10089   HALLSVILLE R-IV 291356000577 4020 HALLSVILLE INTERMEDIATE   Regular School No Elementary 02 05 2017   k_12_total 398 11 14 6   *       * 23           *         181.4   35   456 398 11 14 6             23                   35   456
3297307 MO     school 2913560 10089   HALLSVILLE R-IV 291356002975 4040 HALLSVILLE PRIMARY   Regular School No Elementary PK 01 2017   k_12_total 192 6 * *   *       * 15           *         90.4   23   220 192 6                 15                   23   220
3297325 MO     school 2929700 10090   STURGEON R-V 292970002052 4020 STURGEON ELEM.   Regular School No Elementary KG 04 2017   k_12_total 162 * * *   *       * 9           *         83   28   175 162                   9                 83 28   175
3297343 MO     school 2908400 10091   CENTRALIA R-VI 290840000242 4020 CHANCE ELEM.   Regular School No Elementary PK 02 2017   k_12_total 269 * 5 *   *       * 13           *         103   24   291 269   5               13                 103 24   291
3297349 MO     school 2908400 10091   CENTRALIA R-VI 290840003092 4050 CENTRALIA INTERMEDIATE   Regular School No Elementary 03 05 2017   k_12_total 305 * 6 *   *       * 6           *         115.3   38   320 305   6               6                   38   320
3297367 MO     school 2913710 10092   HARRISBURG R-VIII 291371000598 4020 HARRISBURG ELEM.   Regular School No Elementary PK 05 2017   k_12_total 237 7 5 *   *       * *           *         119   48   252 237 7 5                                 119 48   252
3297439 MO     school 2901000 10093   COLUMBIA 93 290100000313 4020 THOMAS BENTON ELEM.   Regular School No Elementary PK 05 2017   k_12_total 120 143 13 *   *       * 38           5         *   37   318 120 143 13               38           5       37   318
3297445 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2017   k_12_total 204 153 21 *   *       * 55           *         *   61   441 204 153 21               55                   61   441
3297451 MO     school 2901000 10093   COLUMBIA 93 290100000298 4040 BLUE RIDGE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 130 150 85 *   14       * 34           87         347   49   415 130 150 85     14         34           87     347 49   415
3297457 MO     school 2901000 10093   COLUMBIA 93 290100002279 4050 CEDAR RIDGE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 139 47 12 *   *       * 16           6         105.2   16   220 139 47 12               16           6       16   220
3297463 MO     school 2901000 10093   COLUMBIA 93 290100002665 4055 DERBY RIDGE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 167 169 49 *   38       * 21           82         *   61   449 167 169 49     38         21           82       61   449
3297469 MO     school 2901000 10093   COLUMBIA 93 290100000303 4060 FAIRVIEW ELEM.   Regular School No Elementary PK 05 2017   k_12_total 343 70 24 *   39       * 22           63         150   29   499 343 70 24     39         22           63     150 29   499
3297474 MO     school 2901000 10093   COLUMBIA 93 290100003271 4070 ELIOT BATTLE ELEMENTARY   Regular School No Elementary KG 05 2017   k_12_total 195 139 29 *   *       * 42           19         *   45   411 195 139 29               42           19       45   411
3297480 MO     school 2901000 10093   COLUMBIA 93 290100000315 5000 ULYSSES S. GRANT ELEM.   Regular School No Elementary PK 05 2017   k_12_total 195 53 10 *   45       * 15           52         126   15   318 195 53 10     45         15           52     126 15   318
3297486 MO     school 2901000 10093   COLUMBIA 93 290100002770 5010 MARY PAXTON KEELEY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 422 80 39 *   86       * 64           119         198   61   691 422 80 39     86         64           119     198 61   691
3297492 MO     school 2901000 10093   COLUMBIA 93 290100000308 5020 ROBERT E. LEE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 204 52 18 *   34       * 24           55         131   16   333 204 52 18     34         24           55     131 16   333
3297498 MO     school 2901000 10093   COLUMBIA 93 290100001142 5025 MIDWAY HEIGHTS ELEM.   Regular School No Elementary PK 05 2017   k_12_total 196 5 10 *   *       * 13           *         61   15   225 196 5 10               13                 61 15   225
3297504 MO     school 2901000 10093   COLUMBIA 93 290100002546 5030 MILL CREEK ELEM.   Regular School No Elementary PK 05 2017   k_12_total 512 42 14 *   53       * 23           30         99   22   645 512 42 14     53         23           30     99 22   645
3297510 MO     school 2901000 10093   COLUMBIA 93 290100002280 5035 NEW HAVEN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 136 25 47 *   8       * 21           46         135   35   240 136 25 47     8         21           46     135 35   240
3297516 MO     school 2901000 10093   COLUMBIA 93 290100000307 5040 PARKADE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 238 93 26 *   9       * 51           9         243   51   420 238 93 26     9         51           9     243 51   420
3297520 MO     school 2901000 10093   COLUMBIA 93 290100003292 5050 BEULAH RALPH ELEMENTARY   Regular School No Elementary KG 05 2017   k_12_total 362 57 17 *   28       * 40           29         133   48   508 362 57 17     28         40           29     133 48   508
3297526 MO     school 2901000 10093   COLUMBIA 93 290100000305 5060 JOHN RIDGEWAY ELEM.   Regular School No Elementary KG 05 2017   k_12_total 179 18 6 *   14       * 23           5         37   13   240 179 18 6     14         23           5     37 13   240
3297532 MO     school 2901000 10093   COLUMBIA 93 290100000309 5080 ROCK BRIDGE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 332 50 22 *   21       * 37           29         135   40   464 332 50 22     21         37           29     135 40   464
3297538 MO     school 2901000 10093   COLUMBIA 93 290100000310 6000 RUSSELL BLVD. ELEM.   Regular School No Elementary PK 05 2017   k_12_total 296 25 21 *   11       * 24           16         106   35   379 296 25 21     11         24           16     106 35   379
3297544 MO     school 2901000 10093   COLUMBIA 93 290100000312 6010 SHEPARD BLVD. ELEM.   Regular School No Elementary PK 05 2017   k_12_total 318 101 22 *   23       * 60           47         286   58   528 318 101 22     23         60           47     286 58   528
3297550 MO     school 2901000 10093   COLUMBIA 93 290100000316 6020 WEST BLVD. ELEM.   Regular School No Elementary PK 05 2017   k_12_total 117 119 27 *   11       * 30           39         *   34   304 117 119 27     11         30           39       34   304
3297556 MO     school 2901000 10093   COLUMBIA 93 290100000314 6040 TWO MILE PRAIRIE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 148 8 9 *   *       * 8           *         71   15   177 148 8 9               8                 71 15   177
3297562 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2017   k_12_total 51 * * *   *       * *           *         *   *   53 51                                           53
3297566 MO     school 2901000 10093   COLUMBIA 93 290100003287 7500 CENTER FOR EARLY LRNING-NORTH   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297584 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125000390 4040 EAST BUCHANAN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 305 * * *   *       * 12           *         83   66   319 305                   12                 83 66   319
3297596 MO     school 2911940 11078   MID-BUCHANAN CO. R-V 291194000443 4020 MID-BUCHANAN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 366 5 * *   *       * 8           *         95   49   384 366 5                 8                 95 49   384
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
3297656 MO     school 2927060 11082   ST. JOSEPH 292706001649 4040 EDISON ELEM.   Regular School No Elementary PK 06 2017   k_12_total 195 55 74 *   *       12 46           67         *   73   386 195 55 74             12 46           67       73   386
3297662 MO     school 2927060 11082   ST. JOSEPH 292706001650 4060 ELLISON ELEM.   Regular School No Elementary KG 06 2017   k_12_total 276 28 17 *   5       * 22           12         139   30   353 276 28 17     5         22           12     139 30   353
3297668 MO     school 2927060 11082   ST. JOSEPH 292706003250 4070 CARDEN PARK ELEM   Regular School No Elementary PK 06 2017   k_12_total 390 77 53 *   *       5 57           43         *   146   584 390 77 53             5 57           43       146   584
3297674 MO     school 2927060 11082   ST. JOSEPH 292706003255 4080 OAK GROVE ELEM   Regular School No Elementary PK 06 2017   k_12_total 371 27 58 *   29       * 42           56         150   68   529 371 27 58     29         42           56     150 68   529
3297680 MO     school 2927060 11082   ST. JOSEPH 292706001652 4100 FIELD ELEM.   Regular School No Elementary KG 06 2017   k_12_total 264 13 20 *   15       * 14           19         116   31   329 264 13 20     15         14           19     116 31   329
3297686 MO     school 2927060 11082   ST. JOSEPH 292706001654 4140 COLEMAN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 184 77 45 *   31       20 29           103         *   45   388 184 77 45     31       20 29           103       45   388
3297692 MO     school 2927060 11082   ST. JOSEPH 292706001657 4180 HOSEA ELEM.   Regular School No Elementary PK 06 2017   k_12_total 361 16 51 *   *       * 18           32         *   58   451 361 16 51               18           32       58   451
3297698 MO     school 2927060 11082   ST. JOSEPH 292706001658 4200 HUMBOLDT ELEM.   Regular School No Elementary PK 06 2017   k_12_total 195 31 44 *   *       * 31           38         *   51   303 195 31 44               31           38       51   303
3297702 MO     school 2927060 11082   ST. JOSEPH 292706001659 4220 HYDE ELEM.   Regular School No Elementary KG 06 2017   k_12_total 366 11 16 *   *       * 24           7         246   55   421 366 11 16               24           7     246 55   421
3297708 MO     school 2927060 11082   ST. JOSEPH 292706001661 4240 LAKE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 224 7 44 *   *       * 24           36         *   54   303 224 7 44               24           36       54   303
3297712 MO     school 2927060 11082   ST. JOSEPH 292706001662 4260 LINDBERGH ELEM.   Regular School No Elementary PK 06 2017   k_12_total 314 22 26 *   *       * 31           20         *   85   399 314 22 26               31           20       85   399
3297718 MO     school 2927060 11082   ST. JOSEPH 292706001663 4280 MARK TWAIN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 258 32 31 *   *       * 24           20         *   46   348 258 32 31               24           20       46   348
3297724 MO     school 2927060 11082   ST. JOSEPH 292706001667 4390 PARKWAY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 346 28 26 *   *       8 32           19         *   55   443 346 28 26             8 32           19       55   443
3297730 MO     school 2927060 11082   ST. JOSEPH 292706001668 4400 PERSHING ELEM.   Regular School No Elementary KG 06 2017   k_12_total 288 5 7 *   *       * 32           8         185   40   339 288 5 7               32           8     185 40   339
3297736 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No Elementary PK 06 2017   k_12_total 280 11 16 *   7       * 27           6         *   62   342 280 11 16     7         27           6       62   342

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