Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by rowid descending

View and edit SQL

grade

year

  • 2021 · 20,116
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
2758631 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 165 320 165   * 26     *   57   382 353     20             127   735 165 320 165     26         57   382 353     20       127   735
2758630 CT     school 905220 1640011   Windsor School District 90522001089 1640811 John F. Kennedy School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 80 134 92   * *     0   42   190 174     14             68   364 80 134 92           0   42   190 174     14       68   364
2758629 CT     school 905220 1640011   Windsor School District 90522001087 1640111 Clover Street School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 59 123 62   0 10     0   18   140 132     9             59   272 59 123 62   0 10     0   18   140 132     9       59   272
2758628 CT     school 905220 1640011   Windsor School District 90522001093 1640511 Poquonock Elementary School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 79 114 94   0 20     0   33   174 166     19             64   340 79 114 94   0 20     0   33   174 166     19       64   340
2758627 CT     school 905220 1640011   Windsor School District 90522001092 1640911 Oliver Ellsworth School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 122 138 106   * *     0   39   219 225     26             86   444 122 138 106           0   39   219 225     26       86   444
2758626 CT     school   1650011   Windsor Locks School District 90525001777 1650211 RISE Transition Academy Program           2021   pk_12_total 11 * *   0 0     0   *   12 9     0             21   21 11       0 0     0       12 9     0       21   21
2758625 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2021   pk_12_total 229 50 63   0 38     *   *   211 188     8             56   399 229 50 63   0 38             211 188     8       56   399
2758624 CT     school   1650011   Windsor Locks School District 90525001709 1650611 Pine Meadow Academy Program           2021   pk_12_total 25 * 9   0 0     0   *   25 19     0             22   44 25   9   0 0     0       25 19     0       22   44
2758623 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 173 40 65   0 27     0   17   153 169     11             52   322 173 40 65   0 27     0   17   153 169     11       52   322
2758622 CT     school 905250 1650011   Windsor Locks School District 90525001098 1650411 South Elementary School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 177 44 49   0 29     0   31   154 176     31             41   330 177 44 49   0 29     0   31   154 176     31       41   330
2758621 CT     school 905250 1650011   Windsor Locks School District 90525001097 1650111 North Street School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 251 44 65   0 *     *   23   198 206     50             55   404 251 44 65   0           23   198 206     50       55   404
2758620 CT     school   1630011   Windham School District   1631411 Assisted Work Program at WHS Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2758619 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             13   13   0     0 0     0   0                   13   13
2758618 CT     school 905190 1630011   Windham School District 90519001086 1636111 Windham High School Public Schools Regular School No High 09 12 2021   pk_12_total 95 32 461   * *     0   11   344 260     181             135   604 95 32 461           0   11   344 260     181       135   604
2758617 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 106 21 532   * *     0   15   348 330     188             146   678 106 21 532           0   15   348 330     188       146   678
2758616 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2021   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2758615 CT     school   1630011   Windham School District   1630711 Natchaug Emotional Disturbance Program Program           2021   pk_12_total * * 6   0 0     0   0   8 0     *             8   8     6   0 0     0   0   8 0             8   8
2758614 CT     school 905190 1630011   Windham School District 90519001085 1630511 Windham Center School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 63 0 160   0 0     0   6   116 113     98             44   229 63 0 160   0 0     0   6   116 113     98       44   229
2758613 CT     school 905190 1630011   Windham School District 90519001084 1630611 W. B. Sweeney School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 26 9 183   * *     0   9   104 125     110             41   229 26 9 183           0   9   104 125     110       41   229
2758612 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2021   pk_12_total * 0 15   0 0     0   *   * *     *             17   17   0 15   0 0     0                       17   17
2758611 CT     school 905190 1630011   Windham School District 90519001214 1630311 North Windham School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 80 21 322   * *     0   *   212 219     171             68   431 80 21 322           0       212 219     171       68   431
2758610 CT     school 905190 1630011   Windham School District 90519001083 1630111 Natchaug School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 39 20 221   * *     0   *   153 135     123             44   288 39 20 221           0       153 135     123       44   288
2758609 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2021   pk_12_total 254 * 248   * 10     *   23   278 265     72             51   543 254   248     10         23   278 265     72       51   543
2758608 CT     school   1630011   Windham School District 90519001474 1638311 Windham Early Childhood Center Program           2021   pk_12_total 21 * 125   0 *     0   *   80 74     0             44   154 21   125   0       0       80 74     0       44   154
2758607 CT     school   1630011   Windham School District 90519000307 1638011 Early Headstart Program           2021   pk_12_total * * 20   0 0     0   0   11 11     0             0   22     20   0 0     0   0   11 11     0       0   22
2758606 CT     school 905160 1620011   Winchester School District 90516001080 1625111 Pearson School Public Schools Regular School No Elementary 03 06 2021   pk_12_total 228 * 37   0 *     0   13   149 138     14             57   287 228   37   0       0   13   149 138     14       57   287
2758605 CT     school 905160 1620011   Winchester School District 90516001077 1620411 Batcheller Early Education Center Public Schools Regular School No Elementary PK 02 2021   pk_12_total 213 * 21   0 *     *   9   * 132     6             53   249 213   21   0           9     132     6       53   249
2758604 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2758603 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2021   pk_12_total 975 * 76   * 130     0   68   621 651     *             200   1272 975   76     130     0   68   621 651             200   1272
2758602 CT     school   1610011   Wilton School District   1610211 Genesis Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   14   0     0 0     0   0           0           14
2758601 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 560 * 64   0 93     0   *   382 392     0             124   774 560   64   0 93     0       382 392     0       124   774
2758600 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2021   pk_12_total 697 * 65   0 100     0   *   453 467     *             143   920 697   65   0 100     0       453 467             143   920
2758599 CT     school 905130 1610011   Wilton School District 90513001075 1610511 Miller-Driscoll School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 522 7 57   0 77     0   50   338 375     25             97   713 522 7 57   0 77     0   50   338 375     25       97   713
2758598 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2021   pk_12_total 170 * 16   0 *     0   0   98 97     *             37   195 170   16   0       0   0   98 97             37   195
2758597 CT     school 905100 1600011   Willington School District 90510001069 1600111 Center School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 177 * 20   0 *     0   0   110 92     6             37   202 177   20   0       0   0   110 92     6       37   202
2758596 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2021   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2758595 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2021   pk_12_total 778 54 207   * 52     *   28   557 566     41             144   1123 778 54 207     52         28   557 566     41       144   1123
2758594 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 403 * 110   * 19     0   29   290 288     27             88   578 403   110     19     0   29   290 288     27       88   578
2758593 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2758592 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 213 21 40   0 18     0   11   145 158     36             32   303 213 21 40   0 18     0   11   145 158     36       32   303
2758591 CT     school 905070 1590011   Wethersfield School District 90507001065 1591211 Samuel B. Webb Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 212 9 69   0 22     *   *   151 171     40             47   322 212 9 69   0 22             151 171     40       47   322
2758590 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 338 8 68   0 29     0   20   237 226     52             49   463 338 8 68   0 29     0   20   237 226     52       49   463
2758589 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 286 * 103   0 14     *   20   231 207     63             42   438 286   103   0 14         20   231 207     63       42   438
2758588 CT     school 905070 1590011   Wethersfield School District 90507001060 1591011 Charles Wright School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 156 13 82   0 15     0   16   139 143     61             42   282 156 13 82   0 15     0   16   139 143     61       42   282
2758587 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2021   pk_12_total * * 10   0 *     0   *   9 9     6             18   18     10   0       0       9 9     6       18   18
2758586 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2021   pk_12_total 1483 37 97   0 119     0   68   912 *     10             252   1804 1483 37 97   0 119     0   68   912       10       252   1804
2758585 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 924 24 95   0 76     0   88   593 614     8             151   1207 924 24 95   0 76     0   88   593 614     8       151   1207
2758584 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             8   8   0     0       0   0           0       8   8
2758583 CT     school 905040 1580011   Westport School District 90504001363 1580811 Saugatuck Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 322 * 22   * 22     0   32   208 201     11             50   409 322   22     22     0   32   208 201     11       50   409
2758582 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 400 11 42   0 50     0   42   267 278     12             47   545 400 11 42   0 50     0   42   267 278     12       47   545
2758581 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2758580 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 329 19 36   0 28     0   38   222 228     6             49   450 329 19 36   0 28     0   38   222 228     6       49   450
2758579 CT     school 905040 1580011   Westport School District 90504000960 1580411 Green's Farms School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 315 * 33   * 22     0   26   208 202     *             45   410 315   33     22     0   26   208 202             45   410
2758578 CT     school 905040 1580011   Westport School District 90504001051 1580311 Coleytown Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 327 * 26   * 37     0   24   226 197     10             41   423 327   26     37     0   24   226 197     10       41   423
2758577 CT     school   1580011   Westport School District 90504001501 1588011 Stepping Stones Preschool Program           2021   pk_12_total 54 0 9   0 *     0   *   44 25     0             47   69 54 0 9   0       0       44 25     0       47   69
2758576 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2021   pk_12_total 0 0 0   0 0     0   *   0 *     0             *   * 0 0 0   0 0     0       0       0            
2758575 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2021   pk_12_total 678 11 42   0 29     0   38   412 386     0             80   798 678 11 42   0 29     0   38   412 386     0       80   798
2758574 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 436 11 38   0 35     0   38   300 258     *             65   558 436 11 38   0 35     0   38   300 258             65   558
2758573 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 374 8 48   0 30     0   32   249 243     *             65   492 374 8 48   0 30     0   32   249 243             65   492
2758572 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 304 8 43   0 24     0   39   221 197     10             50   418 304 8 43   0 24     0   39   221 197     10       50   418
2758571 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2021   pk_12_total 162 0 32   * 7     0   *   111 97     12             36   208 162 0 32     7     0       111 97     12       36   208
2758570 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 125 * 38   0 0     0   *   74 94     16             28   168 125   38   0 0     0       74 94     16       28   168
2758569 CT     school 904980 1540011   Westbrook School District 90498001042 1540211 Daisy Ingraham School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 194 * 63   0 *     *   7   137 132     45             35   269 194   63   0           7   137 132     45       35   269
2758568 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2021   pk_12_total 452 406 578   * 61     0   *   797 757     122             211   1554 452 406 578     61     0       797 757     122       211   1554
2758567 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2021   pk_12_total 13 * 20   0 0     0   *   32 16     *             23   48 13   20   0 0     0       32 16             23   48
2758566 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2021   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2758565 CT     school   1560011   West Haven School District   1560711 Blended Program           2021   pk_12_total 27 * 13   0 0     0   *   34 16     *             11   50 27   13   0 0     0       34 16             11   50
2758564 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 271 223 364   0 *     *   37   509 418     83             154   927 271 223 364   0           37   509 418     83       154   927
2758563 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2021   pk_12_total 233 185 334   * *     0   36   428 395     101             139   823 233 185 334           0   36   428 395     101       139   823
2758562 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2021   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
2758561 CT     school 904950 1560011   West Haven School District 90495001039 1560411 Seth G. Haley School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 182 70 94   0 23     0   13   204 178     69             71   382 182 70 94   0 23     0   13   204 178     69       71   382
2758560 CT     school 904950 1560011   West Haven School District 90495001038 1561411 Savin Rock Community School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 103 115 185   0 12     0   29   242 202     111             63   444 103 115 185   0 12     0   29   242 202     111       63   444
2758559 CT     school 904950 1560011   West Haven School District 90495001035 1560311 Forest School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 58 108 188   0 17     0   27   219 179     124             67   398 58 108 188   0 17     0   27   219 179     124       67   398
2758558 CT     school 904950 1560011   West Haven School District 90495001033 1560611 Edith E. Mackrille School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 102 61 103   0 18     0   9   138 155     57             39   293 102 61 103   0 18     0   9   138 155     57       39   293
2758557 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 114 88 105   0 34     0   21   200 162     80             112   362 114 88 105   0 34     0   21   200 162     80       112   362
2758556 CT     school 904950 1560011   West Haven School District 90495001040 1561211 Washington School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 93 54 212   * *     0   29   214 189     106             52   403 93 54 212           0   29   214 189     106       52   403
2758555 CT     school   1550011   West Hartford School District 90492001526 1559011 Post Secondary Program Program           2021   pk_12_total 17 7 11   0 *     0   *   24 16     *             40   40 17 7 11   0       0       24 16             40   40
2758554 CT     school   1550011   West Hartford School District 90492001600 1559211 Strive-West Hartford Program           2021   pk_12_total 8 7 18   0 *     0   *   25 13     0             38   38 8 7 18   0       0       25 13     0       38   38
2758553 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2021   pk_12_total 889 141 228   * 156     *   74   756 *     46             162   1492 889 141 228     156         74   756       46       162   1492
2758552 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2021   pk_12_total 810 118 276   * 190     *   56   726 *     53             192   1453 810 118 276     190         56   726       53       192   1453
2758551 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2021   pk_12_total 9 * 15   0 *     0   0   25 9     0             0   34 9   15   0       0   0   25 9     0       0   34
2758550 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 462 78 208   * 88     *   27   * 446     36             105   867 462 78 208     88         27     446     36       105   867
2758549 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 510 80 147   * 86     *   46   459 412     35             123   871 510 80 147     86         46   459 412     35       123   871
2758548 CT     school 904920 1550011   West Hartford School District 90492001419 1555311 Bristow Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 202 28 58   0 40     0   21   180 169     9             55   349 202 28 58   0 40     0   21   180 169     9       55   349
2758547 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2758546 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2021   pk_12_total 0 0 *   0 0     0   0   * *     *             *   * 0 0     0 0     0   0                        
2758545 CT     school 904920 1550011   West Hartford School District 90492001026 1551511 Wolcott School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 170 35 73   0 43     *   *   164 178     40             47   342 170 35 73   0 43             164 178     40       47   342
2758544 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2021   pk_12_total 6 * *   0 *     0   0   8 6     *             14   14 6       0       0   0   8 6             14   14
2758543 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2021   pk_12_total 10 * 8   0 *     0   *   14 8     *             22   22 10   8   0       0       14 8             22   22
2758542 CT     school 904920 1550011   West Hartford School District 90492001019 1551011 Norfeldt School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 180 39 30   0 33     *   *   148 153     8             27   301 180 39 30   0 33             148 153     8       27   301
2758541 CT     school   1550011   West Hartford School District 90492001681 1559411 Norfeldt Learning Center Program           2021   pk_12_total * * 0   0 *     0   0   * *     *             10   10     0   0       0   0                   10   10
2758540 CT     school 904920 1550011   West Hartford School District 90492001018 1550911 Morley School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 201 17 30   0 14     0   17   129 150     11             37   279 201 17 30   0 14     0   17   129 150     11       37   279
2758539 CT     school 904920 1550011   West Hartford School District 90492001014 1550611 Duffy School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 348 22 48   0 30     0   12   234 226     34             50   460 348 22 48   0 30     0   12   234 226     34       50   460
2758538 CT     school 904920 1550011   West Hartford School District 90492001011 1550411 Bugbee School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 262 24 31   * 24     0   *   183 171     15             34   354 262 24 31     24     0       183 171     15       34   354
2758537 CT     school 904920 1550011   West Hartford School District 90492001009 1550211 Braeburn School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 243 23 26   0 24     0   18   173 161     15             41   334 243 23 26   0 24     0   18   173 161     15       41   334
2758536 CT     school 904920 1550011   West Hartford School District 90492001025 1551311 Whiting Lane School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 169 37 75   0 40     *   *   179 149     54             100   328 169 37 75   0 40             179 149     54       100   328
2758535 CT     school 904920 1550011   West Hartford School District 90492001024 1551211 Webster Hill School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 169 20 66   * 24     0   *   138 145     35             32   283 169 20 66     24     0       138 145     35       32   283
2758534 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 114 43 102   0 59     0   6   180 *     65             44   324 114 43 102   0 59     0   6   180       65       44   324
2758533 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2021   pk_12_total 158 70 180   * 74     *   28   246 270     49             51   516 158 70 180     74         28   246 270     49       51   516
2758532 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 241 36 47   * 60     *   16   183 220     46             45   403 241 36 47     60         16   183 220     46       45   403

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