Data source: Big Local News · About: Big Local

37,120 rows where state = "MO" and year = 2020 sorted by hispanic_int

View and edit SQL

grade

year

  • 2020 · 37,020
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
3298184 MO     school 2910620 16092   DELTA R-V 291062000357 4020 DELTA ELEM.   Regular School No Elementary PK 06 2020   k_12_total 84 * * *   *       * *           *         53   14   92 84                                     53 14   92
3298190 MO     school 2923070 16094   OAK RIDGE R-VI 292307001321 1050 OAK RIDGE HIGH   Regular School No High 07 12 2020   k_12_total 169 * * *   *       * *           *         51   17   170 169                                     51 17   170
3298196 MO     school 2923070 16094   OAK RIDGE R-VI 292307001320 4020 OAK RIDGE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 193 * * *   *       * *           *         93   12   196 193                                     93 12   196
3298256 MO     school 2913500 17121   HALE R-I 291350000574 1050 HALE HIGH   Regular School No High 07 12 2020   k_12_total 68 * * *   *       * *           *         29.4   9   71 68                                       9   71
3298262 MO     school 2913500 17121   HALE R-I 291350000573 4020 HALE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 53 * * *   *       6 *           *         34   12   60 53                 6                   34 12   60
3298268 MO     school 2930300 17122   TINA-AVALON R-II 293030002071 1050 TINA-AVALON HIGH   Regular School No High 07 12 2020   k_12_total 59 * * *   *       * *           *         29   *   61 59                                     29     61
3298274 MO     school 2930300 17122   TINA-AVALON R-II 293030002070 4020 TINA-AVALON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 79 * * *   *       * *           *         26   15   79 79                                     26 15   79
3298280 MO     school 2905610 17124   BOSWORTH R-V 290561000107 1050 BOSWORTH HIGH   Regular School No High 07 12 2020   k_12_total 23 * * *   *       * *           *         *   *   25 23                                           25
3298286 MO     school 2905610 17124   BOSWORTH R-V 290561000106 4020 BOSWORTH ELEM.   Regular School No Elementary PK 06 2020   k_12_total 19 * * *   *       * *           *         *   *   21 19                                           21
3298304 MO     school 2907380 17125   CARROLLTON R-VII 290738003131 4000 ADAMS PRIMARY SCHOOL   Regular School No Elementary PK 01 2020   k_12_total 143 * * *   *       * 9           *         82   21   156 143                   9                 82 21   156
3298316 MO     school 2922620 17126   NORBORNE R-VIII 292262001238 1050 NORBORNE HIGH   Regular School No High 06 12 2020   k_12_total 103 * * *   *       * *           *         43   21   107 103                                     43 21   107
3298322 MO     school 2922620 17126   NORBORNE R-VIII 292262001237 4020 NORBORNE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 68 * * *   *       * *           *         36   10   70 68                                     36 10   70
3298334 MO     school 2911100 18047   EAST CARTER CO. R-II 291110002916 3000 EAST CARTER CO. R-II MIDDLE   Regular School No Middle 06 08 2020   k_12_total 131 * * *   *       * 9           *         95   16   141 131                   9                 95 16   141
3298340 MO     school 2911100 18047   EAST CARTER CO. R-II 291110000380 4020 EAST CARTER CO. R-II ELEM.   Regular School No Elementary PK 05 2020   k_12_total 282 * * *   *       * 8           *         203   62   290 282                   8                 203 62   290
3298346 MO     school 2930750 18050   VAN BUREN R-I 293075002121 1050 VAN BUREN HIGH   Regular School No High 07 12 2020   k_12_total 213 * * *   *       * *           *         123   39   219 213                                     123 39   219
3298352 MO     school 2930750 18050   VAN BUREN R-I 293075002122 4020 VAN BUREN ELEM.   Regular School No Elementary PK 06 2020   k_12_total 244 * * *   *       * *           *         172   42   249 244                                     172 42   249
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
3298370 MO     school 2929670 19140   STRASBURG C-3 292967002051 4020 STRASBURG ELEM.   Regular School No Elementary PK 08 2020   k_12_total 113 * * *   *       * *           *         37   15   120 113                                     37 15   120
3298433 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373003316 7500 SHULL EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298457 MO     school 2911160 19147   EAST LYNNE 40 291116000384 4020 EAST LYNNE ELEM.   Regular School No Elementary PK 08 2020   k_12_total 101 * * *   *       * *           *         44   18   103 101                                     44 18   103
3298534 MO     school 2911070 19150   DREXEL R-IV 291107000378 4020 DREXEL ELEM.   Regular School No Elementary PK 06 2020   k_12_total 143 * * *   *       * *           *         65   23   149 143                                     65 23   149
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
3298600 MO     school 2929520 20001   STOCKTON R-I 292952003351 1010 EXCEPTIONAL PUPIL COOP. - ECSE   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298618 MO     school 2929520 20001   STOCKTON R-I 292952002043 4020 STOCKTON ELEM.   Regular School No Elementary KG 04 2020   k_12_total 340 * * *   *       * 5           *         201   69   348 340                   5                 201 69   348
3298620 MO     school 2929520 20001   STOCKTON R-I 292952003323 7500 LITTLE TIGER PRESCHOOL   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298644 MO     school 2922920 21148   NORTHWESTERN R-I 292292001311 1050 NORTHWESTERN HIGH   Regular School No High 07 12 2020   k_12_total 73 * * *   *       * *           *         30   10   74 73                                     30 10   74
3298650 MO     school 2922920 21148   NORTHWESTERN R-I 292292001310 4020 NORTHWESTERN ELEM.   Regular School No Elementary PK 06 2020   k_12_total 67 * * *   *       * *           *         25   10   67 67                                     25 10   67
3298656 MO     school 2906030 21149   BRUNSWICK R-II 290603000145 1050 BRUNSWICK HIGH   Regular School No High 07 12 2020   k_12_total 85 8 * *   *       * 7           *         53   19   100 85 8                 7                 53 19   100
3298662 MO     school 2906030 21149   BRUNSWICK R-II 290603000144 4020 BRUNSWICK ELEM.   Regular School No Elementary PK 06 2020   k_12_total 125 6 * *   *       * 13           *         76   30   147 125 6                 13                 76 30   147
3298668 MO     school 2916530 21150   KEYTESVILLE R-III 291653000905 1050 KEYTESVILLE HIGH   Regular School No High 07 12 2020   k_12_total 64 * * *   *       * *           *         37   8   68 64                                     37 8   68
3298674 MO     school 2916530 21150   KEYTESVILLE R-III 291653000904 4020 KEYTESVILLE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 54 * * *   *       * *           *         27   10   54 54                                     27 10   54
3298686 MO     school 2927520 21151   SALISBURY R-IV 292752001683 4040 SALISBURY ELEM.   Regular School No Elementary PK 06 2020   k_12_total 228 6 * *   *       * *           *         123   30   239 228 6                                   123 30   239
3298692 MO     school 2908430 22088   CHADWICK R-I 290843000246 1050 CHADWICK HIGH   Regular School No High 07 12 2020   k_12_total 110 * * *   *       * *           *         60   23   112 110                                     60 23   112
3298698 MO     school 2908430 22088   CHADWICK R-I 290843000245 4020 CHADWICK ELEMENTARY   Regular School No Elementary PK 06 2020   k_12_total 131 * * *   *       * *           *         84   30   132 131                                     84 30   132
3298716 MO     school 2922530 22089   Nixa Public Schools 292253003132 4030 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298764 MO     school 2922530 22089   Nixa Public Schools 292253003242 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298770 MO     school 2928740 22090   SPARTA R-III 292874001776 1050 SPARTA HIGH   Regular School No High 09 12 2020   k_12_total 198 * * *   *       * *           *         100   31   206 198                                     100 31   206
3298776 MO     school 2928740 22090   SPARTA R-III 292874001430 3000 SPARTA MIDDLE   Regular School No Middle 05 08 2020   k_12_total 218 * * *   *       * 6           *         137   21   229 218                   6                 137 21   229
3298782 MO     school 2928740 22090   SPARTA R-III 292874001775 4020 SPARTA ELEM.   Regular School No Elementary KG 04 2020   k_12_total 224 * * *   *       * 10           *         121   26   238 224                   10                 121 26   238
3298788 MO     school 2928740 22090   SPARTA R-III 292874003260 7500 SPARTA PK CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
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
3298806 MO     school 2909780 22092   CLEVER R-V 290978000282 1050 CLEVER HIGH   Regular School No High 09 12 2020   k_12_total 320 6 * *   *       * *           *         114   27   338 320 6                                   114 27   338
3298856 MO     school 2923430 22093   OZARK R-VI 292343003333 7500 OZARK TIGERPAW EARLY CHILD CTR   Regular School No Elementary PK KG 2020   k_12_total * * * *   *       * *           *         *   *   9                                             9
3298881 MO     school 2916380 23101   CLARK CO. R-I 291638000797 1050 CLARK CO. HIGH   Regular School No High 09 12 2020   k_12_total 274 * * *   *       * *           *         106   57   280 274                                     106 57   280
3298887 MO     school 2916380 23101   CLARK CO. R-I 291638001656 3000 CLARK CO. MIDDLE   Regular School No Middle 06 08 2020   k_12_total 245 * * *   *       * *           *         133   32   251 245                                     133 32   251
3298893 MO     school 2916380 23101   CLARK CO. R-I 291638000794 4040 BLACK HAWK ELEM.   Regular School No Elementary KG 05 2020   k_12_total 374 * * *   *       * *           *         211   83   383 374                                     211 83   383
3298899 MO     school 2916380 23101   CLARK CO. R-I 291638000796 4060 RUNNING FOX ELEM.   Regular School No Elementary KG 05 2020   k_12_total 88 * * *   *       * *           *         42   17   90 88                                     42 17   90
3298905 MO     school 2916380 23101   CLARK CO. R-I 291638003254 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298935 MO     school 2916450 24086   KEARNEY R-I 291645002532 4060 HAWTHORNE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 261 7 * *   *       * 12           *         36   42   284 261 7                 12                 36 42   284
3298948 MO     school 2916450 24086   KEARNEY R-I 291645003353 5040 LENS   Regular School No Elementary 03 04 2020   k_12_total 41 * * *   *       * *           *         5   7   44 41                                     5 7   44
3298950 MO     school 2916450 24086   KEARNEY R-I 291645003329 7500 KEARNEY EARLY EDUCATION CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299013 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165003352 7500 EXCELSIOR SPRINGS EAR CHLD CTR   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299121 MO     school 2918540 24090   LIBERTY 53 291854002615 7500 EARLY CHILD. EDUCATION CTR.   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299127 MO     school 2921060 24091   MISSOURI CITY 56 292106001151 4020 MISSOURI CITY ELEM.   Regular School No Elementary KG 08 2020   k_12_total 23 * * *   *       * *           *         15   5   23 23                                     15 5   23
3299317 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002662 7500 PLEASANT VALLEY EARLY CHILDHOO   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299335 MO     school 2907020 25001   CAMERON R-I 290702000178 4020 PARKVIEW ELEM.   Regular School No Elementary PK 02 2020   k_12_total 330 * * *   *       * 16           *         190   45   351 330                   16                 190 45   351
3299340 MO     school 2907020 25001   CAMERON R-I 290702003267 4040 CAMERON INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2020   k_12_total 333 * * *   *       * 16           *         191   62   357 333                   16                 191 62   357
3299364 MO     school 2925290 25003   CLINTON CO. R-III 292529001458 1050 PLATTSBURG HIGH   Regular School No High 09 12 2020   k_12_total 156 8 * *   *       * 15           *         68   23   183 156 8                 15                 68 23   183
3299370 MO     school 2925290 25003   CLINTON CO. R-III 292529000846 3000 CLINTON CO. R-III MIDDLE   Regular School No Middle 06 08 2020   k_12_total 123 * * *   *       * 15           *         53   22   146 123                   15                 53 22   146
3299382 MO     school 2926970 26001   COLE CO. R-I 292697001639 1050 RUSSELLVILLE HIGH   Regular School No High 09 12 2020   k_12_total 187 * * *   *       * *           *         62   19   196 187                                     62 19   196
3299388 MO     school 2926970 26001   COLE CO. R-I 292697000847 3000 COLE CO. R-I MIDDLE   Regular School No Middle 06 08 2020   k_12_total 144 * * *   *       * *           *         62   22   155 144                                     62 22   155
3299394 MO     school 2926970 26001   COLE CO. R-I 292697001638 4020 COLE CO. R-I ELEM.   Regular School No Elementary PK 05 2020   k_12_total 237 * * *   *       * 6           *         91   34   249 237                   6                 91 34   249
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
3299418 MO     school 2911550 26005   COLE CO. R-V 291155000411 1050 EUGENE HIGH   Regular School No High 07 12 2020   k_12_total 284 * * *   *       * *           *         66   14   292 284                                     66 14   292
3299515 MO     school 2916190 26006   JEFFERSON CITY 291619003121 7500 SOUTHWEST EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
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
3299527 MO     school 2906150 27056   COOPER CO. R-IV 290615000154 1050 BUNCETON HIGH   Regular School No High 07 12 2020   k_12_total 47 * * *   *       * *           *         22   *   48 47                                     22     48
3299533 MO     school 2906150 27056   COOPER CO. R-IV 290615000153 4020 BUNCETON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 49 * * *   *       * *           *         28   9   51 49                                     28 9   51
3299539 MO     school 2925530 27057   PRAIRIE HOME R-V 292553001500 1050 PRAIRIE HOME HIGH   Regular School No High 07 12 2020   k_12_total 71 * * *   *       * *           *         29   6   74 71                                     29 6   74
3299545 MO     school 2925530 27057   PRAIRIE HOME R-V 292553001499 4020 PRAIRIE HOME ELEM.   Regular School No Elementary KG 06 2020   k_12_total 70 * * *   *       * *           *         41   8   73 70                                     41 8   73
3299551 MO     school 2923310 27058   OTTERVILLE R-VI 292331001342 1050 OTTERVILLE HIGH   Regular School No High 06 12 2020   k_12_total 128 * * *   *       * *           *         55   20   132 128                                     55 20   132
3299557 MO     school 2923310 27058   OTTERVILLE R-VI 292331001341 4020 OTTERVILLE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 87 * * *   *       * *           *         43   8   88 87                                     43 8   88
3299563 MO     school 2925170 27059   PILOT GROVE C-4 292517001448 1050 PILOT GROVE HIGH   Regular School No High 07 12 2020   k_12_total 112 * * *   *       * 6           *         41   17   119 112                   6                 41 17   119
3299569 MO     school 2925170 27059   PILOT GROVE C-4 292517001447 4020 PILOT GROVE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 102 * * *   *       * *           *         51   18   105 102                                     51 18   105
3299641 MO     school 2929430 28103   STEELVILLE R-III 292943002482 3000 STEELVILLE MIDDLE   Regular School No Middle 05 08 2020   k_12_total 322 * * *   *       * 7           *         230   60   336 322                   7                 230 60   336
3299647 MO     school 2929430 28103   STEELVILLE R-III 292943002036 4020 STEELVILLE ELEM.   Regular School No Elementary PK 04 2020   k_12_total 335 * * *   *       * *           *         211   69   344 335                                     211 69   344
3299653 MO     school 2919140 29001   LOCKWOOD R-I 291914001033 1050 LOCKWOOD HIGH   Regular School No High 09 12 2020   k_12_total 91 * * *   *       * *           *         37   6   94 91                                     37 6   94
3299658 MO     school 2919140 29001   LOCKWOOD R-I 291914003283 3000 LOCKWOOD MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 64 * * *   *       * *           *         36   5   68 64                                     36 5   68
3299664 MO     school 2919140 29001   LOCKWOOD R-I 291914001032 4020 LOCKWOOD ELEM.   Regular School No Elementary PK 05 2020   k_12_total 122 * * *   *       * *           *         82   14   124 122                                     82 14   124
3299670 MO     school 2910440 29002   DADEVILLE R-II 291044000345 1050 DADEVILLE SR. HIGH   Regular School No High 06 12 2020   k_12_total 71 * * *   *       * *           *         27   *   71 71                                     27     71
3299676 MO     school 2910440 29002   DADEVILLE R-II 291044000344 4020 Dadeville R-II School   Regular School No Elementary KG 05 2020   k_12_total 98 * * *   *       * *           *         46   11   100 98                                     46 11   100
3299682 MO     school 2911580 29003   EVERTON R-III 291158000413 1050 EVERTON HIGH   Regular School No High 07 12 2020   k_12_total 68 * * *   *       * *           *         *   10   75 68                                       10   75
3299690 MO     school 2911580 29003   EVERTON R-III 291158000412 4020 EVERTON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 83 * * *   *       * *           *         *   13   87 83                                       13   87
3299702 MO     school 2913320 29004   GREENFIELD R-IV 291332000565 4020 GREENFIELD ELEM.   Regular School No Elementary PK 06 2020   k_12_total 173 * * *   *       * 5           *         120   29   179 173                   5                 120 29   179
3299727 MO     school 2923670 31116   PATTONSBURG R-II 292367001410 1050 PATTONSBURG HIGH   Regular School No High 06 12 2020   k_12_total 102 * * *   *       * *           *         55   14   109 102                                     55 14   109
3299733 MO     school 2923670 31116   PATTONSBURG R-II 292367001409 4020 PATTONSBURG ELEM.   Regular School No Elementary PK 05 2020   k_12_total 96 * * *   *       * *           *         68   7   99 96                                     68 7   99
3299739 MO     school 2932250 31117   WINSTON R-VI 293225002262 1050 WINSTON HIGH   Regular School No High 07 12 2020   k_12_total 75 * * *   *       * *           *         28   11   77 75                                     28 11   77
3299745 MO     school 2932250 31117   WINSTON R-VI 293225002261 4020 WINSTON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 66 * * *   *       * *           *         39   11   70 66                                     39 11   70
3299751 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000741 1050 NORTH DAVIESS HIGH   Regular School No High 07 12 2020   k_12_total 27 * * *   *       * *           *         *   8   27 27                                       8   27
3299757 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000740 4020 NORTH DAVIESS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 33 * * *   *       * *           *         *   9   33 33                                       9   33
3299763 MO     school 2912660 31121   GALLATIN R-V 291266000530 1050 GALLATIN HIGH   Regular School No High 09 12 2020   k_12_total 171 * * *   *       * *           *         70   32   177 171                                     70 32   177
3299767 MO     school 2912660 31121   GALLATIN R-V 291266003296 3000 GALLATIN MIDDLE SCHOOL   Regular School No Middle 05 08 2020   k_12_total 161 * * *   *       * *           *         69   25   168 161                                     69 25   168
3299773 MO     school 2912660 31121   GALLATIN R-V 291266000529 4020 COVEL D. SEARCY ELEM.   Regular School No Elementary PK 04 2020   k_12_total 202 * * *   *       * *           *         103.4   38   208 202                                       38   208
3299785 MO     school 2930390 31122   TRI-COUNTY R-VII 293039002081 4020 TRI-COUNTY ELEM.   Regular School No Elementary PK 06 2020   k_12_total 71 * * *   *       * *           *         47   24   74 71                                     47 24   74
3299791 MO     school 2923250 32054   OSBORN R-O 292325001338 1050 OSBORN HIGH   Regular School No High 07 12 2020   k_12_total 46 * * *   *       * *           *         21   *   50 46                                     21     50
3299797 MO     school 2923250 32054   OSBORN R-O 292325001337 4020 OSBORN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 69 * * *   *       * 5           *         32   9   74 69                   5                 32 9   74
3299803 MO     school 2920550 32055   MAYSVILLE R-I 292055001099 1050 MAYSVILLE JR.-SR. HIGH   Regular School No High 07 12 2020   k_12_total 249 * * *   *       * *           *         87   30   258 249                                     87 30   258
3299809 MO     school 2920550 32055   MAYSVILLE R-I 292055001098 4060 MAYSVILLE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 280 * * *   *       * *           *         127.4   34   283 280                                       34   283
3299815 MO     school 2930600 32056   UNION STAR R-II 293060002103 1050 UNION STAR HIGH   Regular School No High 06 12 2020   k_12_total 75 * * *   *       * *           *         31   7   77 75                                     31 7   77

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