enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int ▼ black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3309680 3309680 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No Elementary PK 05 2017   k_12_total * 237 * *   *       * *           *         *   16   238   237                                     16   238
3309681 3309681 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No Elementary PK 05 2018   k_12_total * 216 * *   *       * *           *         *   15   216   216                                     15   216
3309682 3309682 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 GEORGE WASHINGTON CARVER ELEM   Regular School No Elementary PK 05 2019   k_12_total * 164 * *   *       * *           *         *   8   167   164                                     8   167
3309683 3309683 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 GEORGE WASHINGTON CARVER ELEM   Regular School No Elementary PK 05 2020   k_12_total * 143 * *   *       * *           *         *   9   145   143                                     9   145
3309684 3309684 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No 1 PK 05 2015   k_12_total * 201 * *   *       * *           *         *   24   203   201                                     24   203
3309685 3309685 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No 1 PK 05 2016   k_12_total * 184 * *   *       * *           *         *   25   187   184                                     25   187
3309686 3309686 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 182 * *   *       * *           *         *   21   186   182                                     21   186
3309687 3309687 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No Elementary PK 05 2018   k_12_total * 173 * *   *       * *           6         *   16   176   173                             6       16   176
3309688 3309688 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 139 * *   *       * *           *         *   8   139   139                                     8   139
3309689 3309689 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 102 * *   *       * *           *         *   9   102   102                                     9   102
3309696 3309696 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No 1 PK 05 2015   k_12_total * 277 * *   *       * *           *         *   24   280   277                                     24   280
3309697 3309697 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No 1 PK 05 2016   k_12_total * 205 * *   *       * *           *         *   14   206   205                                     14   206
3309698 3309698 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 174 * *   *       * *           *         *   16   175   174                                     16   175
3309699 3309699 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No Elementary PK 06 2018   k_12_total * 172 * *   *       * *           *         *   15   172   172                                     15   172
3309700 3309700 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No Elementary PK 07 2019   k_12_total * 185 * *   *       * *           *         *   19   188   185                                     19   188
3309701 3309701 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No Elementary PK 08 2020   k_12_total * 165 * *   *       * *           *         *   20   165   165                                     20   165
3309702 3309702 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No 1 PK 05 2015   k_12_total * 337 * *   *       * *           *         *   39   339   337                                     39   339
3309703 3309703 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No 1 PK 05 2016   k_12_total * 328 * *   *       * *           *         *   48   328   328                                     48   328
3309704 3309704 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 336 * *   *       * *           *         *   39   337   336                                     39   337
3309705 3309705 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No Elementary PK 05 2018   k_12_total * 318 * *   *       * *           *         *   34   318   318                                     34   318
3309706 3309706 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 311 * *   *       * *           *         *   36   312   311                                     36   312
3309707 3309707 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 251 * *   *       * *           *         *   40   251   251                                     40   251
3309740 3309740 MO     school 2929280 115115   ST. LOUIS CITY 292928001917 5520 ELIAS MICHAEL ELEM.   Regular School No Elementary PK 08 2017   k_12_total * 40 * *   *       * *           *         *   *   47   40                                         47
3309742 3309742 MO     school 2929280 115115   ST. LOUIS CITY 292928001917 5520 ELIAS MICHAEL ELEM.   Regular School No Elementary PK 08 2019   k_12_total * 40 * *   *       * *           11         *   43   48   40                             11       43   48
3309762 3309762 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No 1 PK 06 2015   k_12_total * 334 * *   *       * *           *         *   37   335   334                                     37   335
3309763 3309763 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No 1 PK 06 2016   k_12_total * 290 * *   *       * *           *         *   32   293   290                                     32   293
3309764 3309764 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No Elementary PK 06 2017   k_12_total * 272 * *   *       * *           *         *   26   274   272                                     26   274
3309765 3309765 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No Elementary PK 06 2018   k_12_total * 309 * *   *       * *           *         *   31   312   309                                     31   312
3309766 3309766 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 320 * *   *       * *           *         *   37   323   320                                     37   323
3309767 3309767 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No Elementary PK 06 2020   k_12_total * 279 * *   *       * *           *         *   30   279   279                                     30   279
3309768 3309768 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No 1 PK 05 2015   k_12_total * 225 * *   *       * *           *         *   16   226   225                                     16   226
3309769 3309769 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No 1 PK 05 2016   k_12_total * 190 * *   *       * *           *         *   12   191   190                                     12   191
3309770 3309770 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 166 * *   *       * *           *         *   11   166   166                                     11   166
3309771 3309771 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No Elementary PK 05 2018   k_12_total * 128 * *   *       * *           *         *   10   129   128                                     10   129
3309772 3309772 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 134 * *   *       * *           *         *   22   135   134                                     22   135
3309773 3309773 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 107 * *   *       * *           *         *   32   108   107                                     32   108
3309789 3309789 MO     school 2929280 115115   ST. LOUIS CITY 292928002000 5860 SIGEL ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2018   k_12_total * 195 * *   *       * *           48         *   19   199   195                             48       19   199
3309798 3309798 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No 1 PK 06 2015   k_12_total * 157 * *   *       * *           *         *   17   158   157                                     17   158
3309799 3309799 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No 1 PK 06 2016   k_12_total * 192 * *   *       * *           *         *   22   194   192                                     22   194
3309800 3309800 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No Elementary PK 06 2017   k_12_total * 192 * *   *       * *           *         *   32   192   192                                     32   192
3309801 3309801 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No Elementary PK 06 2018   k_12_total * 198 * *   *       * *           *         *   30   199   198                                     30   199
3309802 3309802 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No Elementary PK 06 2019   k_12_total * 178 * *   *       * *           *         *   21   178   178                                     21   178
3309803 3309803 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No Elementary PK 06 2020   k_12_total * 168 * *   *       * *           *         *   21   169   168                                     21   169
3309810 3309810 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No 1 PK 05 2015   k_12_total * 293 * 6   *       * *           *         *   19   307   293   6                                 19   307
3309811 3309811 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No 1 PK 05 2016   k_12_total * 297 * 7   *       * *           *         *   22   308   297   7                                 22   308
3309813 3309813 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No Elementary PK 05 2018   k_12_total * 247 * *   *       * *           *         *   15   256   247                                     15   256
3309814 3309814 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No Elementary PK 05 2019   k_12_total * 259 * *   *       * *           *         *   24   262   259                                     24   262
3309815 3309815 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No Elementary PK 05 2020   k_12_total * 235 * *   *       * *           *         *   20   239   235                                     20   239
3309828 3309828 MO     school 2929280 115115   ST. LOUIS CITY 292928002005 6340 ST. LOUIS CHILDREN'S HOSPITAL   Alternative Education School No 4 KG 12 2015   k_12_total * 22 * *   *       * *           *         *   12   23   22                                     12   23
3309829 3309829 MO     school 2929280 115115   ST. LOUIS CITY 292928002005 6340 ST. LOUIS CHILDREN'S HOSPITAL   Alternative Education School No 4 KG 12 2016   k_12_total * 14 * *   *       * *           *         *   *   18   14                                         18
3309833 3309833 MO     school 2929280 115115   ST. LOUIS CITY 292928002005 6340 ST. LOUIS CHILDREN'S HOSPITAL   Alternative School No Other KG 12 2020   k_12_total * * * *   *       * *           *         *   *   8                                             8
3309845 3309845 MO     school 2900021 115414   MO SCHOOL FOR THE BLIND 290002103039 4020 MO School for the Blind - ELEM   Special Education School No Elementary KG 08 2020   k_12_total * * * *   *       * *           *         *   *   9                                             9
3309856 3309856 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057402828 3910 LIFT FOR LIFE ACADEMY   Regular School Yes Middle 06 08 2018   k_12_total * 240 * *   *       * 11           *         *   35   258   240                 11                   35   258
3309857 3309857 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057402828 3910 LIFT FOR LIFE ACADEMY   Regular School Yes Middle 06 08 2019   k_12_total * 242 5 *   *       * 8           *         *   35   260   242 5               8                   35   260
3309859 3309859 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057403356 6905 LIFT FOR LIFE ACADEMY ELEM.   Regular School Yes Elementary KG 02 2020   k_12_total * 111 * *   *       * *           *         *   *   114   111                                         114
3309866 3309866 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes 3 07 12 2015   k_12_total * 456 10 *   *       * *           7         *   47   473   456 10                           7       47   473
3309867 3309867 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes 3 07 12 2016   k_12_total * 609 9 *   *       * 6           *         *   72   626   609 9               6                   72   626
3309868 3309868 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes High 07 12 2017   k_12_total * 752 8 *   *       * *           7         *   102   764   752 8                           7       102   764
3309869 3309869 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes High 07 12 2018   k_12_total * 696 * *   *       * *           *         *   95   703   696                                     95   703
3309871 3309871 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes High 09 12 2020   k_12_total * 405 7 *   *       * *           *         *   61   413   405 7                                   61   413
3309876 3309876 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes 1 KG 08 2015   k_12_total * 798 * *   *       * 7           *         *   70   809   798                 7                   70   809
3309877 3309877 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes 1 KG 08 2016   k_12_total * 796 * *   *       * 5           *         *   76   805   796                 5                   76   805
3309878 3309878 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes Elementary PK 06 2017   k_12_total * 608 * *   *       * 5           *         *   52   615   608                 5                   52   615
3309880 3309880 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes Elementary PK 06 2019   k_12_total * 410 * *   *       * *           *         *   33   417   410                                     33   417
3309881 3309881 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH ACADEMY   Regular School Yes Elementary PK 08 2020   k_12_total * 470 * *   *       * 7           *         *   54   478   470                 7                   54   478
3309882 3309882 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 WALNUT PARK   Regular School Yes 1 PK 08 2015   k_12_total * 712 * *   *       * *           *         *   62   718   712                                     62   718
3309883 3309883 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes 1 PK 06 2016   k_12_total * 644 * *   *       * *           *         *   53   648   644                                     53   648
3309884 3309884 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2017   k_12_total * 552 * *   *       * *           *         *   40   558   552                                     40   558
3309885 3309885 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2018   k_12_total * 377 * *   *       * *           *         *   31   381   377                                     31   381
3309886 3309886 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2019   k_12_total * 363 * *   *       * *           *         *   40   366   363                                     40   366
3309887 3309887 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 08 2020   k_12_total * 434 * *   *       * *           *         *   50   439   434                                     50   439
3309916 3309916 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes 1 PK 05 2015   k_12_total * 308 * *   *       * *           *         *   21   315   308                                     21   315
3309917 3309917 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes 1 PK 05 2016   k_12_total * 343 * *   *       * *           *         *   31   348   343                                     31   348
3309918 3309918 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes Elementary PK 05 2017   k_12_total * 351 * *   *       * *           *         *   26   354   351                                     26   354
3309919 3309919 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes Elementary PK 05 2018   k_12_total * 351 * *   *       * *           *         *   29   353   351                                     29   353
3309920 3309920 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes Elementary PK 04 2019   k_12_total * 344 * *   *       * *           *         *   30   349   344                                     30   349
3309921 3309921 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes Elementary PK 04 2020   k_12_total * 342 * *   *       * 8           *         *   34   357   342                 8                   34   357
3309922 3309922 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903344 6970 NORTH SIDE COMMUNITY-GRAND CTR   Regular School Yes Middle 05 06 2019   k_12_total * 75 * *   *       * *           *         *   11   75   75                                     11   75
3309923 3309923 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903344 6970 NORTH SIDE COMMUNITY-GRAND CTR   Regular School Yes Middle 05 07 2020   k_12_total * 108 * *   *       * *           *         *   11   109   108                                     11   109
3309924 3309924 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 09 2018   k_12_total * 106 * *   *       * *           *         *   20   111   106                                     20   111
3309925 3309925 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   k_12_total * 202 9 *   *       * *           9         *   33   214   202 9                           9       33   214
3309926 3309926 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 11 2020   k_12_total * 312 9 *   *       * *           7         *   53   326   312 9                           7       53   326
3309927 3309927 MO     school 2900591 115914   KIPP ST LOUIS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes 2 05 08 2015   k_12_total * 325 8 *   *       * *           *         297   37   336   325 8                                 297 37   336
3309928 3309928 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes 2 05 08 2016   k_12_total * 339 * *   *       * *           *         *   44   344   339                                     44   344
3309929 3309929 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes Middle 05 08 2017   k_12_total * 312 * *   *       * *           *         *   39   314   312                                     39   314
3309930 3309930 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes Middle 05 08 2018   k_12_total * 367 * *   *       * *           *         *   44   370   367                                     44   370
3309933 3309933 MO     school 2900591 115914   KIPP ST LOUIS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes 1 KG 01 2015   k_12_total * 197 10 *   *       * *           *         199   14   211   197 10                                 199 14   211
3309934 3309934 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes 1 KG 02 2016   k_12_total * 316 8 *   *       * *           *         *   30   324   316 8                                   30   324
3309935 3309935 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes Elementary KG 03 2017   k_12_total * 428 8 *   *       * *           *         *   32   437   428 8                                   32   437
3309936 3309936 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes Elementary KG 04 2018   k_12_total * 547 * *   *       * *           *         *   50   550   547                                     50   550
3309937 3309937 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes Elementary KG 04 2019   k_12_total * 539 5 *   *       * 5           *         *   45   550   539 5               5                   45   550
3309938 3309938 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes Elementary KG 04 2020   k_12_total * 565 * *   *       * *           *         *   44   574   565                                     44   574
3309939 3309939 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes 1 KG 01 2016   k_12_total * 204 * *   *       * *           *         *   17   207   204                                     17   207
3309940 3309940 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes Elementary KG 02 2017   k_12_total * 305 6 *   *       * *           *         *   22   315   305 6                                   22   315
3309941 3309941 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes Elementary KG 03 2018   k_12_total * 407 9 *   *       * *           *         *   42   419   407 9                                   42   419
3309942 3309942 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes Elementary KG 04 2019   k_12_total * 491 17 *   *       * *           18         *   32   511   491 17                           18       32   511
3309944 3309944 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes 2 05 05 2016   k_12_total * 81 * *   *       * *           *         *   10   81   81                                     10   81
3309945 3309945 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes Middle 05 06 2017   k_12_total * 187 * *   *       * *           *         *   25   187   187                                     25   187
3309946 3309946 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes Middle 05 07 2018   k_12_total * 269 * *   *       * *           *         *   28   269   269                                     28   269
3309947 3309947 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes Middle 05 08 2019   k_12_total * 413 * *   *       * *           *         *   60   417   413                                     60   417

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