Data source: Big Local News · About: Big Local

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

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
3302490 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703331 1910 ACADEMIE LAFAYETTE - ARMOUR   Regular School Yes Middle 06 09 2020   k_12_total 182 41 13 *   5       * 27           *         45   23   269 182 41 13     5         27                 45 23   269
3302496 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Elementary KG 05 2020   k_12_total 338 123 19 *   6       * 60           6         116   41   552 338 123 19     6         60           6     116 41   552
3302502 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 05 2020   k_12_total 159 67 18 *   8       * 43           5         69   30   299 159 67 18     8         43           5     69 30   299
3302603 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2020   k_12_total 23 205 9 *   6       * *           *         *   20   248 23 205 9     6                             20   248
3296684 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2020   k_12_total 103 * * *   *       * *           *         54   *   104 103                                     54     104
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
3296720 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2020   k_12_total 73 * * *   *       * 6           *         18   15   79 73                   6                 18 15   79
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
3297091 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2020   k_12_total 369 * 8 *   5       * *           *         103   23   387 369   8     5                           103 23   387
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
3308564 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2020   k_12_total 195 * * *   *       * *           *         95   26   198 195                                     95 26   198
3308570 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No Elementary KG 06 2020   k_12_total 242 * * *   *       * *           *         137   22   244 242                                     137 22   244
3308572 MO     school 2902880 103129   ADVANCE R-IV 290288003340 7500 ADVANCE PRESCHOOL   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307637 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2020   k_12_total 582 90 41 *   14       * 47           36         248.4   108   774 582 90 41     14         47           36       108   774
3307643 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2020   k_12_total 412 62 41 *   17       * 47           31         225   95   579 412 62 41     17         47           31     225 95   579
3307649 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary KG 02 2020   k_12_total 476 32 36 *   21       * 56           100         178   96   621 476 32 36     21         56           100     178 96   621
3307655 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2020   k_12_total 434 56 44 *   24       * 54           83         210   103   613 434 56 44     24         54           83     210 103   613
3300337 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2020   k_12_total 116 * * *   *       * 7           *         62.1   15   124 116                   7                   15   124
3300343 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2020   k_12_total 89 * * *   *       * *           *         56   15   91 89                                     56 15   91
3300349 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 186 * * *   *       * 5           *         95   22   195 186                   5                 95 22   195
3302454 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2020   k_12_total * 63 104 *   6       * 5           24         162   21   182   63 104     6         5           24     162 21   182
3302456 MO     school 2900025 48909   ALLEN VILLAGE 290002503325 3930 ALLEN VILLAGE JUNIOR   Regular School Yes Middle 06 08 2020   k_12_total 7 41 94 *   5       * *           24         137   8   149 7 41 94     5                     24     137 8   149
3302458 MO     school 2900025 48909   ALLEN VILLAGE 290002503327 6905 ALLEN VILLAGE PRIMARY   Regular School Yes Elementary KG 02 2020   k_12_total * 28 56 *   *       * *           49         85   7   94   28 56                           49     85 7   94
3302464 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE ELEMENTARY   Regular School Yes Elementary 03 05 2020   k_12_total * 39 75 *   *       * *           47         111   7   123   39 75                           47     111 7   123
3305093 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2020   k_12_total 97 * * *   *       * *           *         28   19   98 97                                     28 19   98
3304871 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2020   k_12_total 300 * * 7   *       * *           *         181.1   48   313 300     7                                 48   313
3304877 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary KG 06 2020   k_12_total 354 * * *   *       * *           *         234.3   63   368 354                                       63   368
3306484 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2020   k_12_total 163 * 5 6   *       * *           *         78   19   177 163   5 6                               78 19   177
3306490 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 145 * * *   *       * *           *         69   20   149 145                                     69 20   149
3301318 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000022 1050 ARCADIA VALLEY HIGH   Regular School No High 09 12 2020   k_12_total 275 * * *   *       * 6           *         125   38   291 275                   6                 125 38   291
3301324 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000023 3000 ARCADIA VALLEY MIDDLE   Regular School No Middle 05 08 2020   k_12_total 272 * 7 *   *       * 5           *         183   38   290 272   7               5                 183 38   290
3301330 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000021 4020 ARCADIA VALLEY ELEM.   Regular School No Elementary PK 04 2020   k_12_total 302 7 * *   *       * *           *         218.4   64   317 302 7                                     64   317
3298358 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No High 06 12 2020   k_12_total 260 7 6 *   *       * *           *         64   22   278 260 7 6                                 64 22   278
3298364 MO     school 2903200 19139   ARCHIE R-V 290320000024 4020 CASS CO. ELEM.   Regular School No Elementary PK 05 2020   k_12_total 211 * * *   *       * *           *         72   30   221 211                                     72 30   221
3300452 MO     school 2903270 39135   ASH GROVE R-IV 290327000028 1050 ASH GROVE HIGH   Regular School No High 07 12 2020   k_12_total 314 * * *   *       * *           *         129   41   327 314                                     129 41   327
3300458 MO     school 2903270 39135   ASH GROVE R-IV 290327000027 4020 ASH GROVE ELEM.   Regular School No Elementary PK 03 2020   k_12_total 187 * * *   *       * *           8         121   34   199 187                               8     121 34   199
3300464 MO     school 2903270 39135   ASH GROVE R-IV 290327000026 4040 BOIS D'ARC ELEM.   Regular School No Middle 04 06 2020   k_12_total 152 * * *   *       * *           *         82   23   157 152                                     82 23   157
3303997 MO     school 2903480 61150   ATLANTA C-3 290348000030 1050 ATLANTA HIGH   Regular School No High 07 12 2020   k_12_total 103 * * *   *       * *           *         45   13   103 103                                     45 13   103
3304003 MO     school 2903480 61150   ATLANTA C-3 290348000029 4020 ATLANTA ELEM.   Regular School No Elementary KG 06 2020   k_12_total 102 * * *   *       * *           *         54   8   107 102                                     54 8   107
3303628 MO     school 2904020 55110   AURORA R-VIII 290402000031 1050 AURORA HIGH   Regular School No High 09 12 2020   k_12_total 425 5 69 8   *       * 11           16         270   73   522 425 5 69 8             11           16     270 73   522
3303634 MO     school 2904020 55110   AURORA R-VIII 290402001517 2050 AURORA JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 207 * 39 *   *       * 13           10         147   47   264 207   39               13           10     147 47   264
3303640 MO     school 2904020 55110   AURORA R-VIII 290402000032 4020 PATE EARLY CHILDHOOD CTR.   Regular School No Elementary PK 02 2020   k_12_total 283 * 73 *   *       * 13           48         280   80   373 283   73               13           48     280 80   373
3303646 MO     school 2904020 55110   AURORA R-VIII 290402000033 4040 ROBINSON ELEM.   Regular School No Elementary 03 04 2020   k_12_total 200 5 42 *   *       * 9           29         164   56   259 200 5 42               9           29     164 56   259
3303652 MO     school 2904020 55110   AURORA R-VIII 290402002981 4060 ROBINSON INTERMEDIATE   Regular School No Middle 05 06 2020   k_12_total 231 * 42 *   *       * 14           14         195.4   58   294 231   42               14           14       58   294
3299899 MO     school 2904050 34124   AVA R-I 290405000036 1050 AVA HIGH   Regular School No High 09 12 2020   k_12_total 409 * 10 5   *       * *           *         218   49   429 409   10 5                               218 49   429
3299905 MO     school 2904050 34124   AVA R-I 290405002548 3000 AVA MIDDLE   Regular School No Middle 05 08 2020   k_12_total 393 * 9 *   *       * 11           *         273.3   64   414 393   9               11                   64   414
3299911 MO     school 2904050 34124   AVA R-I 290405000034 4020 AVA ELEM.   Regular School No Elementary PK 04 2020   k_12_total 427 * 15 *   *       * 16           *         328.1   87   462 427   15               16                   87   462
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
3302651 MO     school 2904110 49135   AVILLA R-XIII 290411000038 4020 AVILLA ELEM.   Regular School No Elementary KG 08 2020   k_12_total 114 * 13 *   6       * 5           12         81   14   138 114   13     6         5           12     81 14   138
3304926 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000040 1050 BAKERSFIELD HIGH   Regular School No High 06 12 2020   k_12_total 212 * * *   *       * 6           *         119   46   221 212                   6                 119 46   221
3304932 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000039 4020 BAKERSFIELD ELEM.   Regular School No Elementary PK 05 2020   k_12_total 135 * * *   *       * *           *         86   22   135 135                                     86 22   135
3297079 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2020   k_12_total 42 * * *   *       * *           *         22   7   46 42                                     22 7   46
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
3307661 MO     school 2904500 96099   BAYLESS 290450000044 1050 BAYLESS SENIOR HIGH   Regular School No High 09 12 2020   k_12_total 322 72 23 *   67       * 23           55         307.4   85   508 322 72 23     67         23           55       85   508
3307667 MO     school 2904500 96099   BAYLESS 290450000715 2000 BAYLESS JUNIOR HIGH   Regular School No Middle 06 08 2020   k_12_total 282 48 21 *   48       * 15           50         255   76   414 282 48 21     48         15           50     255 76   414
3307673 MO     school 2904500 96099   BAYLESS 290450000043 4020 BAYLESS ELEMENTARY   Regular School No Elementary PK 05 2020   k_12_total 522 89 46 *   99       * 37           203         480   119   793 522 89 46     99         37           203     480 119   793
3308552 MO     school 2904530 103128   BELL CITY R-II 290453000047 1050 BELL CITY HIGH   Regular School No High 07 12 2020   k_12_total 103 * * *   *       * *           *         64   13   110 103                                     64 13   110
3308558 MO     school 2904530 103128   BELL CITY R-II 290453000046 4020 BELL CITY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 103 8 * *   *       * *           *         87   12   114 103 8                                   87 12   114
3301336 MO     school 2904590 47064   BELLEVIEW R-III 290459000050 4020 BELLEVIEW ELEM.   Regular School No Elementary PK 08 2020   k_12_total 104 * * *   *       * *           *         74   17   111 104                                     74 17   111
3298552 MO     school 2904620 19152   BELTON 124 290462000055 1050 BELTON HIGH   Regular School No High 09 12 2020   k_12_total 925 138 228 5   11       6 93           51         643.2   223   1406 925 138 228 5   11       6 93           51       223   1406
3298558 MO     school 2904620 19152   BELTON 124 290462003025 1055 BELTON MIDDLE SCHOOL   Regular School No Middle 07 08 2020   k_12_total 473 67 123 *   *       7 42           43         394   123   716 473 67 123             7 42           43     394 123   716
3298564 MO     school 2904620 19152   BELTON 124 290462000051 4020 CAMBRIDGE ELEM.   Regular School No Elementary KG 04 2020   k_12_total 222 26 67 *   *       * 32           37         222   44   348 222 26 67               32           37     222 44   348
3298570 MO     school 2904620 19152   BELTON 124 290462000053 4040 HILLCREST STEAM ACADEMY   Regular School No Elementary KG 06 2020   k_12_total 345 32 85 *   *       * 48           40         249   77   517 345 32 85               48           40     249 77   517
3298581 MO     school 2904620 19152   BELTON 124 290462000052 4060 GLADDEN ELEM.   Regular School No Elementary KG 04 2020   k_12_total 271 32 73 *   *       * 37           38         296   69   419 271 32 73               37           38     296 69   419
3298587 MO     school 2904620 19152   BELTON 124 290462002724 4080 MILL CREEK UPPER ELEM.   Regular School No Middle 05 06 2020   k_12_total 362 52 81 *   *       * 40           24         316.4   100   546 362 52 81               40           24       100   546
3298593 MO     school 2904620 19152   BELTON 124 290462002988 4090 KENTUCKY TRAIL ELEM.   Regular School No Elementary KG 04 2020   k_12_total 274 57 57 *   7       * 37           23         246   75   434 274 57 57     7         37           23     246 75   434
3298599 MO     school 2904620 19152   BELTON 124 290462002725 7500 GRACE EARLY CHILD. & ED. CTR.   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308650 MO     school 2904950 103135   BERNIE R-XIII 290495000061 1050 BERNIE HIGH   Regular School No High 07 12 2020   k_12_total 215 5 * *   *       * *           *         136   32   227 215 5                                   136 32   227
3308656 MO     school 2904950 103135   BERNIE R-XIII 290495000060 4020 BERNIE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 253 14 13 *   *       * 16           *         206   35   297 253 14 13               16                 206 35   297
3304009 MO     school 2904980 61151   BEVIER C-4 290498000063 1050 BEVIER HIGH   Regular School No High 09 12 2020   k_12_total 68 * * *   *       * *           *         27   18   70 68                                     27 18   70
3304015 MO     school 2904980 61151   BEVIER C-4 290498000062 4020 BEVIER ELEM.   Regular School No Elementary PK 08 2020   k_12_total 107 * * *   *       * *           *         64   29   113 107                                     64 29   113
3298794 MO     school 2905070 22091   BILLINGS R-IV 290507000066 1050 BILLINGS SR. HIGH   Regular School No High 07 12 2020   k_12_total 178 * * *   *       * *           *         80   20   189 178                                     80 20   189
3298800 MO     school 2905070 22091   BILLINGS R-IV 290507000065 4020 BILLINGS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 182 * * *   *       * *           *         100   36   189 182                                     100 36   189
3306526 MO     school 2905130 94076   BISMARCK R-V 290513000068 1050 BISMARCK R-V HIGH   Regular School No High 06 12 2020   k_12_total 256 * 10 *   *       * *           *         *   36   272 256   10                                   36   272
3306532 MO     school 2905130 94076   BISMARCK R-V 290513000067 4020 BISMARCK R-V ELEM.   Regular School No Elementary PK 05 2020   k_12_total 188 * 7 *   *       * *           *         *   48   201 188   7                                   48   201
3299521 MO     school 2905190 27055   BLACKWATER R-II 290519000069 4020 BLACKWATER ELEM.   Regular School No Elementary PK 08 2020   k_12_total 90 * * *   *       * *           *         46   17   94 90                                     46 17   94
3299400 MO     school 2909930 26002   BLAIR OAKS R-II 290993000295 1050 BLAIR OAKS HIGH   Regular School No High 09 12 2020   k_12_total 440 * * *   *       * 12           *         42   50   460 440                   12                 42 50   460
3299406 MO     school 2909930 26002   BLAIR OAKS R-II 290993003117 3000 BLAIR OAKS MIDDLE SCHOOL   Regular School No Middle 05 08 2020   k_12_total 353 * 5 *   *       * 21           *         48   43   385 353   5               21                 48 43   385
3299412 MO     school 2909930 26002   BLAIR OAKS R-II 290993000294 4020 BLAIR OAKS ELEM.   Regular School No Elementary PK 04 2020   k_12_total 384 * 5 *   *       * 8           *         52   58   399 384   5               8                 52 58   399
3308602 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308608 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525000073 1050 BLOOMFIELD HIGH   Regular School No High 09 12 2020   k_12_total 191 * * *   *       * *           *         85   17   196 191                                     85 17   196
3308614 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525003104 3000 BLOOMFIELD MIDDLE   Regular School No Middle 05 08 2020   k_12_total 193 * * *   *       * *           *         104   19   196 193                                     104 19   196
3308620 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525000072 4020 BLOOMFIELD ELEM.   Regular School No Elementary PK 04 2020   k_12_total 215 * * *   *       * *           *         125   25   217 215                                     125 25   217
3308733 MO     school 2905280 104045   BLUE EYE R-V 290528000076 1050 BLUE EYE HIGH   Regular School No High 09 12 2020   k_12_total 160 * * *   *       * 6           *         76   39   173 160                   6                 76 39   173
3308739 MO     school 2905280 104045   BLUE EYE R-V 290528001900 3000 BLUE EYE MIDDLE   Regular School No Middle 05 08 2020   k_12_total 142 * * *   *       * 6           *         89   36   153 142                   6                 89 36   153
3308745 MO     school 2905280 104045   BLUE EYE R-V 290528000075 4020 BLUE EYE ELEM.   Regular School No Elementary PK 04 2020   k_12_total 162 * * *   *       * *           *         124   40   169 162                                     124 40   169
3301407 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000085 1050 BLUE SPRINGS HIGH   Regular School No High 09 12 2020   k_12_total 1679 310 205 14   58       15 128           5         605   301   2409 1679 310 205 14   58       15 128           5     605 301   2409
3301413 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000170 1075 BLUE SPRINGS SOUTH HIGH   Regular School No High 09 12 2020   k_12_total 1516 232 130 5   59       * 108           *         382   196   2054 1516 232 130 5   59         108                 382 196   2054
3301419 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000943 3000 BRITTANY HILL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 597 84 78 *   10       * 63           *         235   97   839 597 84 78     10         63                 235 97   839
3301425 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531001706 3060 MORELAND RIDGE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 731 127 82 6   15       * 84           5         352   120   1046 731 127 82 6   15         84           5     352 120   1046
3301431 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002736 3080 DELTA WOODS MIDDLE   Regular School No Middle 06 08 2020   k_12_total 569 106 62 *   32       * 40           7         141   73   813 569 106 62     32         40           7     141 73   813
3301437 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002835 3090 PAUL KINDER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 546 108 72 7   15       * 73           *         289   129   824 546 108 72 7   15         73                 289 129   824
3301439 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000270 4015 LIGGETT TRAIL EDUCATION CENTER   Regular School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301445 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000086 4020 THOMAS J. ULTICAN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 345 43 27 5   7       * 46           *         214   63   473 345 43 27 5   7         46                 214 63   473
3301451 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000080 4040 FRANKLIN SMITH ELEM.   Regular School No Elementary KG 05 2020   k_12_total 300 44 39 *   5       * 43           *         211   61   433 300 44 39     5         43                 211 61   433
3301457 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000082 4050 JAMES LEWIS ELEM.   Regular School No Elementary PK 05 2020   k_12_total 359 31 30 *   *       * 36           *         125   52   459 359 31 30               36                 125 52   459
3301463 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000087 4060 WILLIAM YATES ELEM.   Regular School No Elementary KG 05 2020   k_12_total 241 54 74 *   14       7 29           30         167   38   420 241 54 74     14       7 29           30     167 38   420
3301469 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002549 4070 LUCY FRANKLIN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 504 39 48 *   5       * 45           *         140   79   644 504 39 48     5         45                 140 79   644
3301475 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000078 4080 CORDILL-MASON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 610 94 42 *   10       * 36           7         197   79   796 610 94 42     10         36           7     197 79   796
3301481 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000083 4090 JAMES WALKER ELEM.   Regular School No Elementary KG 05 2020   k_12_total 278 71 61 *   7       * 56           8         237   78   478 278 71 61     7         56           8     237 78   478

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