Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by rowid descending

View and edit SQL

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
2779085 CT     school   1640011   Windsor School District   1640411 Expulsion Program           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             0   * 0   0   0 0     0   0     0     0       0    
2779084 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 176 304 155   * 21     *   50   354 355     20             111   709 176 304 155     21         50   354 355     20       111   709
2779083 CT     school 905220 1640011   Windsor School District 90522001089 1640811 John F. Kennedy School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 93 149 87   * *     0   25   200 173     15             57   373 93 149 87           0   25   200 173     15       57   373
2779082 CT     school 905220 1640011   Windsor School District 90522001087 1640111 Clover Street School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 52 141 54   0 6     0   21   152 122     7             53   274 52 141 54   0 6     0   21   152 122     7       53   274
2779081 CT     school 905220 1640011   Windsor School District 90522001093 1640511 Poquonock Elementary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 89 122 93   0 19     0   24   176 171     23             67   347 89 122 93   0 19     0   24   176 171     23       67   347
2779080 CT     school 905220 1640011   Windsor School District 90522001092 1640911 Oliver Ellsworth School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 117 134 113   * 45     0   *   225 228     28             89   453 117 134 113     45     0       225 228     28       89   453
2779079 CT     school   1650011   Windsor Locks School District 90525001777 1650211 RISE Transition Academy Program           2020   pk_12_total 10 * *   0 0     0   *   7 8     0             15   15 10       0 0     0       7 8     0       15   15
2779078 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2020   pk_12_total 253 48 55   0 38     *   *   223 180     13             54   403 253 48 55   0 38             223 180     13       54   403
2779077 CT     school   1650011   Windsor Locks School District 90525001709 1650611 Pine Meadow Academy Program           2020   pk_12_total 31 * 6   0 0     0   *   30 14     0             26   44 31   6   0 0     0       30 14     0       26   44
2779076 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 181 34 71   0 28     0   25   156 183     16             62   339 181 34 71   0 28     0   25   156 183     16       62   339
2779075 CT     school 905250 1650011   Windsor Locks School District 90525001098 1650411 South Elementary School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 174 50 60   * *     0   27   151 183     22             45   334 174 50 60           0   27   151 183     22       45   334
2779074 CT     school 905250 1650011   Windsor Locks School District 90525001097 1650111 North Street School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 277 50 65   * 28     *   30   228 224     48             60   452 277 50 65     28         30   228 224     48       60   452
2779073 CT     school   1630011   Windham School District   1631411 Assisted Work Program at WHS Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2779072 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     6             12   12   0     0 0     0   0           6       12   12
2779071 CT     school 905190 1630011   Windham School District 90519001086 1636111 Windham High School Public Schools Regular School No High 09 12 2020   pk_12_total 106 24 470   * *     0   11   359 257     196             150   616 106 24 470           0   11   359 257     196       150   616
2779070 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 99 20 529   0 0     0   10   336 322     174             141   658 99 20 529   0 0     0   10   336 322     174       141   658
2779069 CT     school   1630011   Windham School District   1630711 Natchaug Emotional Disturbance Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     *             *   *         0 0     0   0     0                  
2779068 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2779067 CT     school 905190 1630011   Windham School District 90519001085 1630511 Windham Center School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 51 * 159   0 0     0   *   114 107     88             37   221 51   159   0 0     0       114 107     88       37   221
2779066 CT     school 905190 1630011   Windham School District 90519001084 1630611 W. B. Sweeney School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 25 10 194   * 0     0   *   104 133     110             45   237 25 10 194     0     0       104 133     110       45   237
2779065 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2020   pk_12_total * 0 13   0 0     0   *   * *     *             16   16   0 13   0 0     0                       16   16
2779064 CT     school 905190 1630011   Windham School District 90519001214 1630311 North Windham School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 72 19 348   * 9     0   *   230 224     174             76   454 72 19 348     9     0       230 224     174       76   454
2779063 CT     school 905190 1630011   Windham School District 90519001083 1630111 Natchaug School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 45 18 231   * *     0   *   163 142     124             37   305 45 18 231           0       163 142     124       37   305
2779062 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2020   pk_12_total 267 * 248   * 8     *   23   283 271     71             65   554 267   248     8         23   283 271     71       65   554
2779061 CT     school   1630011   Windham School District 90519001474 1638311 Windham Early Childhood Center Program           2020   pk_12_total 49 * 148   0 *     0   *   112 93     0             47   205 49   148   0       0       112 93     0       47   205
2779060 CT     school   1630011   Windham School District 90519000307 1638011 Early Headstart Program           2020   pk_12_total * 0 26   0 *     0   0   16 15     0             0   31   0 26   0       0   0   16 15     0       0   31
2779059 CT     school 905160 1620011   Winchester School District 90516001080 1625111 Pearson School Public Schools Regular School No Elementary 03 06 2020   pk_12_total 236 8 39   0 7     0   14   163 141     10             64   304 236 8 39   0 7     0   14   163 141     10       64   304
2779058 CT     school 905160 1620011   Winchester School District 90516001077 1620411 Batcheller Early Education Center Public Schools Regular School No Elementary PK 02 2020   pk_12_total 221 * 17   0 *     *   6   * 128     13             41   254 221   17   0           6     128     13       41   254
2779057 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             7   7   0     0 0     0   0           0       7   7
2779056 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2020   pk_12_total 985 * 83   * 123     0   63   639 633     *             207   1272 985   83     123     0   63   639 633             207   1272
2779055 CT     school   1610011   Wilton School District   1610211 Genesis Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   10   0     0 0     0   0           0           10
2779054 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 620 * 67   0 107     0   *   431 422     *             128   853 620   67   0 107     0       431 422             128   853
2779053 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2020   pk_12_total 713 * 66   * 97     0   55   447 498     *             132   945 713   66     97     0   55   447 498             132   945
2779052 CT     school 905130 1610011   Wilton School District 90513001075 1610511 Miller-Driscoll School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 572 * 52   0 80     0   *   384 372     25             94   756 572   52   0 80     0       384 372     25       94   756
2779051 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2020   pk_12_total 174 6 18   0 *     0   *   107 94     0             36   201 174 6 18   0       0       107 94     0       36   201
2779050 CT     school 905100 1600011   Willington School District 90510001069 1600111 Center School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 210 * 18   0 *     0   *   129 108     7             47   237 210   18   0       0       129 108     7       47   237
2779049 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2779048 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 804 46 204   * 62     *   24   574 *     38             140   1144 804 46 204     62         24   574       38       140   1144
2779047 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 396 21 100   * *     0   28   294 272     36             90   566 396 21 100           0   28   294 272     36       90   566
2779046 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2779045 CT     school 905070 1590011   Wethersfield School District 90507001060 1591011 Charles Wright School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 170 8 79   0 13     0   17   143 144     69             38   287 170 8 79   0 13     0   17   143 144     69       38   287
2779044 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 243 20 46   0 21     0   14   161 183     41             47   344 243 20 46   0 21     0   14   161 183     41       47   344
2779043 CT     school 905070 1590011   Wethersfield School District 90507001065 1591211 Samuel B. Webb Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 215 * 73   0 14     *   8   146 173     42             46   319 215   73   0 14         8   146 173     42       46   319
2779042 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 350 11 67   0 26     0   14   230 238     51             51   468 350 11 67   0 26     0   14   230 238     51       51   468
2779041 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 280 14 99   0 12     0   18   216 207     65             48   423 280 14 99   0 12     0   18   216 207     65       48   423
2779040 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2020   pk_12_total * * 10   0 *     0   *   8 8     *             16   16     10   0       0       8 8             16   16
2779039 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2020   pk_12_total 1513 36 106   0 118     0   55   945 883     9             222   1828 1513 36 106   0 118     0   55   945 883     9       222   1828
2779038 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 985 23 94   0 76     0   81   637 622     12             185   1259 985 23 94   0 76     0   81   637 622     12       185   1259
2779037 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2779036 CT     school 905040 1580011   Westport School District 90504001363 1580811 Saugatuck Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 340 6 23   0 24     0   29   220 202     14             48   422 340 6 23   0 24     0   29   220 202     14       48   422
2779035 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 379 12 49   0 44     0   27   243 268     18             37   511 379 12 49   0 44     0   27   243 268     18       37   511
2779034 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 327 20 31   0 33     0   34   220 225     *             52   445 327 20 31   0 33     0   34   220 225             52   445
2779033 CT     school 905040 1580011   Westport School District 90504000960 1580411 Green's Farms School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 280 * 29   * 20     0   27   186 184     *             33   370 280   29     20     0   27   186 184             33   370
2779032 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2020   pk_12_total 7 0 *   0 *     0   0   * *     0             11   11 7 0     0       0   0           0       11   11
2779031 CT     school 905040 1580011   Westport School District 90504001051 1580311 Coleytown Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 309 * 20   * 31     0   23   206 185     10             31   391 309   20     31     0   23   206 185     10       31   391
2779030 CT     school   1580011   Westport School District 90504001501 1588011 Stepping Stones Preschool Program           2020   pk_12_total 57 * 6   0 *     0   *   44 26     0             48   70 57   6   0       0       44 26     0       48   70
2779029 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2020   pk_12_total 0 0 0   0 0     0   *   0 *     0             *   * 0 0 0   0 0     0       0       0            
2779028 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2020   pk_12_total 685 14 29   0 35     0   29   421 371     *             78   792 685 14 29   0 35     0   29   421 371             78   792
2779027 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 466 10 39   0 28     0   36   301 278     *             65   579 466 10 39   0 28     0   36   301 278             65   579
2779026 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 381 11 45   0 32     0   28   255 242     *             58   497 381 11 45   0 32     0   28   255 242             58   497
2779025 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 303 7 46   0 21     0   36   224 189     11             56   413 303 7 46   0 21     0   36   224 189     11       56   413
2779024 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2020   pk_12_total 175 0 34   * *     0   7   113 111     14             38   224 175 0 34           0   7   113 111     14       38   224
2779023 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 136 0 45   0 *     0   *   92 93     25             31   185 136 0 45   0       0       92 93     25       31   185
2779022 CT     school 904980 1540011   Westbrook School District 90498001042 1540211 Daisy Ingraham School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 180 * 56   0 *     0   10   112 143     50             30   255 180   56   0       0   10   112 143     50       30   255
2779021 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 452 367 592   * 69     0   *   775 760     142             198   1535 452 367 592     69     0       775 760     142       198   1535
2779020 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2020   pk_12_total 13 * 13   0 0     0   *   24 17     *             14   41 13   13   0 0     0       24 17             14   41
2779019 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2020   pk_12_total * 0 *   0 0     0   0   0 6     0             *   6   0     0 0     0   0   0 6     0           6
2779018 CT     school   1560011   West Haven School District   1560711 Blended Program           2020   pk_12_total 6 * *   0 0     0   0   * *     0             *   11 6       0 0     0   0           0           11
2779017 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 295 222 353   * 32     *   29   491 443     64             147   934 295 222 353     32         29   491 443     64       147   934
2779016 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 243 186 331   * *     0   36   460 370     96             135   830 243 186 331           0   36   460 370     96       135   830
2779015 CT     school   1560011   West Haven School District   1561111 ASD Lab             2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2779014 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2020   pk_12_total * * *   0 0     0   0   * *     *             10   10         0 0     0   0                   10   10
2779013 CT     school 904950 1560011   West Haven School District 90495001039 1560411 Seth G. Haley School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 194 67 108   0 22     0   17   209 199     79             73   408 194 67 108   0 22     0   17   209 199     79       73   408
2779012 CT     school 904950 1560011   West Haven School District 90495001038 1561411 Savin Rock Community School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 110 125 206   * *     0   25   246 230     111             55   476 110 125 206           0   25   246 230     111       55   476
2779011 CT     school 904950 1560011   West Haven School District 90495001035 1560311 Forest School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 64 102 196   0 18     0   26   217 189     128             72   406 64 102 196   0 18     0   26   217 189     128       72   406
2779010 CT     school 904950 1560011   West Haven School District 90495001033 1560611 Edith E. Mackrille School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 113 64 96   * 26     0   *   151 157     56             51   308 113 64 96     26     0       151 157     56       51   308
2779009 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 128 89 103   * 29     0   *   210 157     68             110   367 128 89 103     29     0       210 157     68       110   367
2779008 CT     school 904950 1560011   West Haven School District 90495001040 1561211 Washington School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 105 62 225   * *     0   22   227 193     117             58   420 105 62 225           0   22   227 193     117       58   420
2779007 CT     school   1550011   West Hartford School District 90492001526 1559011 Post Secondary Program Program           2020   pk_12_total 19 * 10   0 *     0   0   21 19     *             40   40 19   10   0       0   0   21 19             40   40
2779006 CT     school   1550011   West Hartford School District   1550111 Alternative Educational Program Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2779005 CT     school   1550011   West Hartford School District 90492001600 1559211 Strive-West Hartford Program           2020   pk_12_total 8 * 15   0 *     0   *   25 9     *             34   34 8   15   0       0       25 9             34   34
2779004 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2020   pk_12_total 916 126 226   * 168     *   75   773 741     47             163   1514 916 126 226     168         75   773 741     47       163   1514
2779003 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2020   pk_12_total 762 131 287   * 195     0   *   733 704     48             163   1437 762 131 287     195     0       733 704     48       163   1437
2779002 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2020   pk_12_total 7 * 22   0 *     0   0   23 11     *             0   34 7   22   0       0   0   23 11             0   34
2779001 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 496 85 207   * 95     *   33   445 475     49             114   920 496 85 207     95         33   445 475     49       114   920
2779000 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 517 81 152   0 93     *   *   459 436     41             121   895 517 81 152   0 93             459 436     41       121   895
2778999 CT     school 904920 1550011   West Hartford School District 90492001419 1555311 Bristow Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 243 27 58   0 42     0   16   217 169     10             60   386 243 27 58   0 42     0   16   217 169     10       60   386
2778998 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     *             7   7         0 0     0   0                   7   7
2778997 CT     school 904920 1550011   West Hartford School District 90492001026 1551511 Wolcott School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 174 31 83   * 54     0   *   181 183     54             55   364 174 31 83     54     0       181 183     54       55   364
2778996 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2020   pk_12_total 9 * *   0 *     0   0   * *     *             17   17 9       0       0   0                   17   17
2778995 CT     school 904920 1550011   West Hartford School District 90492001019 1551011 Norfeldt School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 199 31 32   0 39     *   *   164 162     12             41   326 199 31 32   0 39             164 162     12       41   326
2778994 CT     school   1550011   West Hartford School District 90492001681 1559411 Norfeldt Learning Center Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             7   7     0   0       0   0           0       7   7
2778993 CT     school 904920 1550011   West Hartford School District 90492001018 1550911 Morley School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 200 20 36   0 7     0   16   140 139     7             33   279 200 20 36   0 7     0   16   140 139     7       33   279
2778992 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2778991 CT     school 904920 1550011   West Hartford School District 90492001014 1550611 Duffy School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 344 19 59   0 22     0   17   226 235     35             40   461 344 19 59   0 22     0   17   226 235     35       40   461
2778990 CT     school 904920 1550011   West Hartford School District 90492001011 1550411 Bugbee School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 267 25 40   * 26     0   *   193 184     20             36   377 267 25 40     26     0       193 184     20       36   377
2778989 CT     school 904920 1550011   West Hartford School District 90492001009 1550211 Braeburn School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 248 25 41   0 18     0   18   187 163     19             36   350 248 25 41   0 18     0   18   187 163     19       36   350
2778988 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2020   pk_12_total * * *   0 0     0   *   * *     *             11   11         0 0     0                       11   11
2778987 CT     school 904920 1550011   West Hartford School District 90492001025 1551311 Whiting Lane School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 180 29 69   0 40     *   *   195 140     58             100   335 180 29 69   0 40             195 140     58       100   335
2778986 CT     school 904920 1550011   West Hartford School District 90492001024 1551211 Webster Hill School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 187 22 74   * 31     0   *   152 174     51             40   326 187 22 74     31     0       152 174     51       40   326

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