Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by black

View and edit SQL

year

grade

  • pk_12_total · 4,054
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
2452655 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2019   pk_12_total 427 * 24   * 9     0   7   236 235     *             36   471 427   24     9     0   7   236 235             36   471
2452657 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 277 * 26   0 47     0   *   191 182     15             68   373 277   26   0 47     0       191 182     15       68   373
2452658 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 303 * 23   * 20     0   12   201 159     8             59   360 303   23     20     0   12   201 159     8       59   360
2452659 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 266 * 35   0 19     0   *   177 155     8             42   332 266   35   0 19     0       177 155     8       42   332
2452660 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 288 * 23   * 24     0   15   175 178     15             33   353 288   23     24     0   15   175 178     15       33   353
2452661 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 214 * 25   0 16     *   20   138 139     12             37   277 214   25   0 16         20   138 139     12       37   277
2452663 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 235 * 23   * 13     0   18   149 142     *             26   291 235   23     13     0   18   149 142             26   291
2452673 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 378 * 68   * 113     0   26   301 307     67             61   608 378   68     113     0   26   301 307     67       61   608
2452689 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2019   pk_12_total 13 * *   0 *     0   *   * *     0             23   23 13       0       0               0       23   23
2452691 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2019   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2452693 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2452694 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2452698 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2019   pk_12_total 14 * *   0 0     0   0   8 9     0             17   17 14       0 0     0   0   8 9     0       17   17
2452699 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 254 * 10   * *     0   *   141 138     *             36   279 254   10           0       141 138             36   279
2452701 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 463 * 64   0 42     *   28   318 305     12             107   623 463   64   0 42         28   318 305     12       107   623
2452702 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 272 * 32   * 36     0   25   213 164     7             35   377 272   32     36     0   25   213 164     7       35   377
2452708 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2019   pk_12_total 28 * *   0 *     0   *   22 15     0             37   37 28       0       0       22 15     0       37   37
2452710 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 13   0 6     0   *   164 172     *             44   336 308   13   0 6     0       164 172             44   336
2452712 CT     school   1290011   Somers School District   1290511 Aspire Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452716 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2019   pk_12_total 47 * 11   0 15     0   *   48 38     0             50   86 47   11   0 15     0       48 38     0       50   86
2452719 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2019   pk_12_total * * 0   0 0     0   0   * *     0             *   12     0   0 0     0   0           0           12
2452721 CT     school   1320011   South Windsor School District 90417001605 1329011 Project Worth Young Adult Academy Program           2019   pk_12_total * * *   0 *     0   *   * *     0             9   9         0       0               0       9   9
2452722 CT     school 904230 1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total * * 0   0 0     0   0   9 10     0             11   19     0   0 0     0   0   9 10     0       11   19
2452723 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 56 * 7   0 *     0   *   52 18     0             46   70 56   7   0       0       52 18     0       46   70
2452724 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 246 * 18   0 *     0   16   158 133     8             29   291 246   18   0       0   16   158 133     8       29   291
2452726 CT     school 904230 1310011   Southington School District 90423000830 1311311 Flanders Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 207 * 45   0 12     *   12   142 144     26             31   286 207   45   0 12         12   142 144     26       31   286
2452727 CT     school 904230 1310011   Southington School District 90423000831 1310211 Hatton Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 263 * 27   * 7     0   16   163 158     9             43   321 263   27     7     0   16   163 158     9       43   321
2452728 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2019   pk_12_total 8 * *   0 0     0   0   * *     0             10   10 8       0 0     0   0           0       10   10
2452730 CT     school 904230 1310011   Southington School District 90423000836 1310611 Oshana Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 202 * 36   0 6     *   13   139 126     7             29   265 202   36   0 6         13   139 126     7       29   265
2452731 CT     school 904230 1310011   Southington School District 90423000837 1310711 South End Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 180 * 35   0 *     0   8   118 115     *             23   233 180   35   0       0   8   118 115             23   233
2452735 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 637 * 58   * 22     0   23   363 401     6             97   764 637   58     22     0   23   363 401     6       97   764
2452736 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2452739 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2019   pk_12_total 13 * *   0 0     0   0   * *     0             15   15 13       0 0     0   0           0       15   15
2452740 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2019   pk_12_total 8 * *   0 0     0   0   9 6     0             15   15 8       0 0     0   0   9 6     0       15   15
2452741 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2019   pk_12_total 1620 * 153   0 82     *   71   962 1008     12             233   1970 1620   153   0 82         71   962 1008     12       233   1970
2452742 CT     school   1310011   Southington School District 90423001665 1310111 The Karen Smith Academy Program           2019   pk_12_total 26 * *   0 0     0   0   15 17     0             11   32 26       0 0     0   0   15 17     0       11   32
2452743 CT     school   1310011   Southington School District   1312211 STELLAR Program           2019   pk_12_total 7 * 0   0 *     0   0   * *     0             9   9 7   0   0       0   0           0       9   9
2452745 CT     school 904290 1340011   Stafford School District 90429000847 1340311 Staffordville School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 127 * 13   0 0     0   *   86 61     0             20   147 127   13   0 0     0       86 61     0       20   147
2452746 CT     school 904290 1340011   Stafford School District 90429000848 1340411 West Stafford School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 124 * 10   0 *     0   *   78 66     *             17   144 124   10   0       0       78 66             17   144
2452749 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2019   pk_12_total 326 * 38   * 10     0   6   194 *     0             57   384 326   38     10     0   6   194       0       57   384
2452772 CT     school   1350011   Stamford School District 90432001744 1350411 Anchor Program           2019   pk_12_total 24 * 29   0 0     0   *   38 35     6             40   73 24   29   0 0     0       38 35     6       40   73
2452776 CT     school   1350011   Stamford School District 90432001749 1350211 Individuals Achieving Independence Program           2019   pk_12_total * * 10   0 0     0   0   12 9     *             21   21     10   0 0     0   0   12 9             21   21
2452780 CT     school 904380 1370011   Stonington School District 90438000876 1370511 Deans Mill School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 324 * 22   * 11     *   16   190 188     *             34   378 324   22     11         16   190 188             34   378
2452782 CT     school 904380 1370011   Stonington School District 90438000882 1370411 West Broad Street School   Regular School No Elementary 03 04 2019   pk_12_total 90 * 6   * *     0   10   50 61     *             20   111 90   6           0   10   50 61             20   111
2452783 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   pk_12_total 244 * 24   * *     0   8   158 124     0             55   282 244   24           0   8   158 124     0       55   282
2452784 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 312 * 21   0 *     0   9   169 182     *             51   351 312   21   0       0   9   169 182             51   351
2452785 CT     school 904380 1370011   Stonington School District 90438000881 1376111 Stonington High School Public Schools Regular School No High 09 12 2019   pk_12_total 581 * 34   7 25     *   13   353 311     *             79   664 581   34   7 25         13   353 311             79   664
2452790 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2019   pk_12_total 12 * *   0 *     0   *   15 6     0             21   21 12       0       0       15 6     0       21   21
2452797 CT     school   1380011   Stratford School District   1382311 DLC Whitney Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452799 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2019   pk_12_total * * *   0 0     0   0   6 0     0             6   6         0 0     0   0   6 0     0       6   6
2452802 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2019   pk_12_total * * *   * 0     0   0   8 0     *             8   8           0     0   0   8 0             8   8
2452803 CT     school   1380011   Stratford School District 90444001706 1381911 STEPS 7-8 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452806 CT     school   1380011   Stratford School District 90444001671 1380711 High School Sails Program           2019   pk_12_total * * 6   0 0     0   *   10 7     *             17   17     6   0 0     0       10 7             17   17
2452807 CT     school   1380011   Stratford School District 90444001710 1382011 STEPS 9-12 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             8   8         0 0     0   0           0       8   8
2452809 CT     school   1380011   Stratford School District 90444001437 1389011 Strive-Stratford Program           2019   pk_12_total 8 * *   0 0     0   *   * *     *             15   15 8       0 0     0                       15   15
2452816 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2019   pk_12_total 325 * 15   0 *     0   11   155 206     *             41   361 325   15   0       0   11   155 206             41   361
2452818 CT     school 904530 1410011   Thompson School District 90453000909 1410111 Mary R. Fisher Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 372 * 27   0 *     0   9   232 184     *             75   416 372   27   0       0   9   232 184             75   416
2452819 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 281 * 27   0 *     0   11   183 140     *             33   323 281   27   0       0   11   183 140             33   323
2452820 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2019   pk_12_total 216 * 14   * *     0   10   117 128     0             18   245 216   14           0   10   117 128     0       18   245
2452825 CT     school   1420011   Tolland School District 90456001738 1420311 TALC Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             0   9     0   0 0     0   0           0       0   9
2452826 CT     school   1430011   Torrington School District   1432211 East TPS - PreK - Reg Ed             2019   pk_12_total 12 * 30   0 *     0   0   26 18     0             *   44 12   30   0       0   0   26 18     0           44
2452831 CT     school 904590 1430011   Torrington School District 90459000917 1430211 Forbes School Public Schools Regular School No Elementary 04 05 2019   pk_12_total 218 * 110   0 18     *   8   193 169     49             66   362 218   110   0 18         8   193 169     49       66   362
2452837 CT     school   1440011   Trumbull School District 90462000683 1448011 Trumbull Early Childhood Education Center Program           2019   pk_12_total 138 * 46   0 23     0   *   132 93     0             77   225 138   46   0 23     0       132 93     0       77   225
2452840 CT     school 904620 1440011   Trumbull School District 90462000931 1440411 Jane Ryan School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 291 * 52   0 33     0   *   196 201     17             33   397 291   52   0 33     0       196 201     17       33   397
2452851 CT     school 904680 1460011   Vernon School District 90468000940 1460111 Lake Street School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 169 * 26   0 *     0   13   114 103     *             25   217 169   26   0       0   13   114 103             25   217
2452856 CT     school   1460011   Vernon School District   1460911 First Step             2019   pk_12_total * * *   0 *     0   0   * *     0             8   8         0       0   0           0       8   8
2452857 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2019   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2452860 CT     school   1460011   Vernon School District 90468001525 1469011 Next Step Program Program           2019   pk_12_total 6 * *   0 0     0   0   * *     0             9   9 6       0 0     0   0           0       9   9
2452862 CT     school 904740 1480011   Wallingford School District 90474000950 1481011 Cook Hill School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 239 * 90   0 17     0   *   213 149     37             91   362 239   90   0 17     0       213 149     37       91   362
2452863 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 215 * 67   0 13     *   8   163 144     38             24   307 215   67   0 13         8   163 144     38       24   307
2452864 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 257 * 39   0 14     0   *   173 152     17             38   325 257   39   0 14     0       173 152     17       38   325
2452867 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   pk_12_total 7 * *   * 0     0   0   * *     0             12   12 7         0     0   0           0       12   12
2452868 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2019   pk_12_total 235 * 32   0 20     *   9   156 146     12             38   302 235   32   0 20         9   156 146     12       38   302
2452870 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 211 * 64   0 19     0   *   154 151     34             39   305 211   64   0 19     0       154 151     34       39   305
2452871 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 215 * 61   * 7     0   8   145 152     31             36   297 215   61     7     0   8   145 152     31       36   297
2452881 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   pk_12_total 7 * *   0 *     0   0   * *     *             13   13 7       0       0   0                   13   13
2452890 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2019   pk_12_total * * 7   0 0     0   0   * *     0             15   15     7   0 0     0   0           0       15   15
2452903 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   pk_12_total * * 10   0 *     0   *   7 11     *             18   18     10   0       0       7 11             18   18
2452907 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   pk_12_total * * *   0 0     0   0   * *     *             9   9         0 0     0   0                   9   9
2452913 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452915 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   pk_12_total * * 16   0 0     0   *   16 8     *             24   24     16   0 0     0       16 8             24   24
2452916 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2019   pk_12_total 0 * 15   0 0     0   *   * *     0             24   24 0   15   0 0     0               0       24   24
2452917 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   pk_12_total * * 17   0 0     0   0   * *     *             25   25     17   0 0     0   0                   25   25
2452919 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452922 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   pk_12_total * * 7   0 *     0   0   * *     0             16   16     7   0       0   0           0       16   16
2452926 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2452927 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2019   pk_12_total * * 8   0 0     0   0   * *     0             14   14     8   0 0     0   0           0       14   14
2452929 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   8 6     *             14   14     7   0 0     0   0   8 6             14   14
2452931 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2019   pk_12_total * * 13   0 0     0   *   * *     *             23   23     13   0 0     0                       23   23
2452933 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             9   9     7   0 0     0   0                   9   9
2452934 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2019   pk_12_total * * 6   0 0     0   0   * *     0             9   9     6   0 0     0   0           0       9   9
2452938 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             13   13     6   0 0     0   0                   13   13
2452939 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2019   pk_12_total * * *   0 0     0   0   * *     0             13   13         0 0     0   0           0       13   13
2452941 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 273 * 30   * 10     0   11   163 167     12             47   330 273   30     10     0   11   163 167     12       47   330
2452945 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 272 * 41   0 19     *   29   181 196     17             48   377 272   41   0 19         29   181 196     17       48   377
2452951 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 237 * 16   * 6     0   7   147 123     13             21   270 237   16     6     0   7   147 123     13       21   270
2452963 CT     school 904920 1550011   West Hartford School District 90492001011 1550411 Bugbee School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 284 * 43   * 26     0   16   192 193     16             41   385 284   43     26     0   16   192 193     16       41   385
2452968 CT     school 904920 1550011   West Hartford School District 90492001019 1551011 Norfeldt School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 186 * 27   0 38     *   27   157 148     9             24   305 186   27   0 38         27   157 148     9       24   305
2452969 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2019   pk_12_total 7 * 8   0 *     0   *   13 6     *             19   19 7   8   0       0       13 6             19   19
2452971 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2019   pk_12_total * * 0   0 0     0   *   * 0     0             *   *     0   0 0     0         0     0            

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