Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by rowid descending

View and edit SQL

grade

year

  • 2019 · 20,186
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
2453046 CT     school 905250 1650011   Windsor Locks School District 90525001097 1650111 North Street School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 254 49 59   * 33     0   *   206 222     35             48   428 254 49 59     33     0       206 222     35       48   428
2453045 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2019   pk_12_total * 0 9   * 0     0   0   * *     *             12   12   0 9     0     0   0                   12   12
2453044 CT     school 905190 1630011   Windham School District 90519001920 1631311 Windham STEPS Academy   Alternative School No High 09 12 2019   pk_12_total * * 26   0 0     0   *   20 14     14             9   34     26   0 0     0       20 14     14       9   34
2453043 CT     school 905190 1630011   Windham School District 90519001086 1636111 Windham High School Public Schools Regular School No High 09 12 2019   pk_12_total 103 27 414   * *     0   *   315 239     165             148   554 103 27 414           0       315 239     165       148   554
2453042 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 98 26 512   * *     0   13   343 311     186             138   654 98 26 512           0   13   343 311     186       138   654
2453041 CT     school 905190 1630011   Windham School District 90519001085 1630511 Windham Center School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 65 * 160   0 0     0   *   117 112     86             34   229 65   160   0 0     0       117 112     86       34   229
2453040 CT     school 905190 1630011   Windham School District 90519001084 1630611 W. B. Sweeney School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 24 13 214   0 0     0   6   125 132     107             56   257 24 13 214   0 0     0   6   125 132     107       56   257
2453039 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2453038 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2019   pk_12_total * 0 12   0 0     0   *   * *     *             15   15   0 12   0 0     0                       15   15
2453037 CT     school 905190 1630011   Windham School District 90519001214 1630311 North Windham School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 72 15 347   * *     0   *   229 215     160             71   444 72 15 347           0       229 215     160       71   444
2453036 CT     school 905190 1630011   Windham School District 90519001083 1630111 Natchaug School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 50 12 241   * *     0   8   152 164     114             49   316 50 12 241           0   8   152 164     114       49   316
2453035 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2019   pk_12_total 278 8 247   * 6     *   25   289 278     72             70   567 278 8 247     6         25   289 278     72       70   567
2453034 CT     school   1630011   Windham School District 90519001474 1638311 Windham Early Childhood Center Program           2019   pk_12_total 68 6 151   * *     0   *   119 109     0             46   228 68 6 151           0       119 109     0       46   228
2453033 CT     school   1630011   Windham School District 90519000307 1638011 Early Headstart Program           2019   pk_12_total * 0 *   0 0     0   0   15 15     0             0   30   0     0 0     0   0   15 15     0       0   30
2453032 CT     school 905160 1620011   Winchester School District 90516001080 1625111 Pearson School Public Schools Regular School No Elementary 03 06 2019   pk_12_total 224 6 42   0 14     0   8   166 128     16             56   294 224 6 42   0 14     0   8   166 128     16       56   294
2453031 CT     school 905160 1620011   Winchester School District 90516001077 1620411 Batcheller Early Education Center Public Schools Regular School No Elementary PK 02 2019   pk_12_total 210 * 20   0 *     0   *   122 *     22             48   243 210   20   0       0       122       22       48   243
2453030 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2453029 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2019   pk_12_total 1004 * 73   * 106     0   58   630 633     *             174   1263 1004   73     106     0   58   630 633             174   1263
2453028 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 648 * *   0 99     0   56   449 409     *             120   858 648       0 99     0   56   449 409             120   858
2453027 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   pk_12_total 770 * 66   * 104     0   54   471 532     *             138   1003 770   66     104     0   54   471 532             138   1003
2453026 CT     school 905130 1610011   Wilton School District 90513001075 1610511 Miller-Driscoll School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 590 6 56   0 84     0   55   395 396     15             94   791 590 6 56   0 84     0   55   395 396     15       94   791
2453025 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2019   pk_12_total 166 * 14   0 *     0   7   100 90     0             34   190 166   14   0       0   7   100 90     0       34   190
2453024 CT     school 905100 1600011   Willington School District 90510001069 1600111 Center School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 207 * 13   0 *     0   8   125 112     *             33   237 207   13   0       0   8   125 112             33   237
2453023 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2453022 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 805 52 191   6 66     0   20   * 582     26             130   1140 805 52 191   6 66     0   20     582     26       130   1140
2453021 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 379 23 89   * 21     *   20   267 268     24             81   535 379 23 89     21         20   267 268     24       81   535
2453020 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2453019 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   pk_12_total 0 * *   0 0     0   *   * *     *             7   7 0       0 0     0                       7   7
2453018 CT     school 905070 1590011   Wethersfield School District 90507001060 1591011 Charles Wright School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 213 7 79   0 11     0   18   168 160     87             41   328 213 7 79   0 11     0   18   168 160     87       41   328
2453017 CT     school 905070 1590011   Wethersfield School District 90507001065 1591211 Samuel B. Webb Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 229 * 60   0 11     *   10   160 161     38             61   321 229   60   0 11         10   160 161     38       61   321
2453016 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 344 12 70   0 17     0   10   228 225     47             47   453 344 12 70   0 17     0   10   228 225     47       47   453
2453015 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 285 15 93   0 16     0   23   218 214     60             57   432 285 15 93   0 16     0   23   218 214     60       57   432
2453014 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 261 * 48   * 20     0   15   179 181     52             43   360 261   48     20     0   15   179 181     52       43   360
2453013 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2019   pk_12_total 1560 44 107   0 110     0   37   959 899     9             218   1858 1560 44 107   0 110     0   37   959 899     9       218   1858
2453012 CT     school 905040 1580011   Westport School District 90504001052 1585311 Coleytown Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 370 7 28   0 27     0   24   227 229     *             58   456 370 7 28   0 27     0   24   227 229             58   456
2453011 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 682 13 48   0 58     0   57   446 412     *             110   858 682 13 48   0 58     0   57   446 412             110   858
2453010 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2019   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2453009 CT     school 905040 1580011   Westport School District 90504001363 1580811 Saugatuck Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 382 7 24   0 25     0   28   246 220     16             54   466 382 7 24   0 25     0   28   246 220     16       54   466
2453008 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 392 19 54   0 45     0   28   259 279     15             42   538 392 19 54   0 45     0   28   259 279     15       42   538
2453007 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 363 18 24   0 35     0   30   239 231     *             44   470 363 18 24   0 35     0   30   239 231             44   470
2453006 CT     school 905040 1580011   Westport School District 90504000960 1580411 Green's Farms School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 313 * 30   * 16     0   26   206 192     *             37   398 313   30     16     0   26   206 192             37   398
2453005 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2453004 CT     school 905040 1580011   Westport School District 90504001051 1580311 Coleytown Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 297 * 19   * 34     0   24   193 188     10             32   381 297   19     34     0   24   193 188     10       32   381
2453003 CT     school   1580011   Westport School District 90504001501 1588011 Stepping Stones Preschool Program           2019   pk_12_total 59 * 7   0 *     0   *   45 28     0             50   73 59   7   0       0       45 28     0       50   73
2453002 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2019   pk_12_total 0 0 *   0 0     0   *   * *     0             *   * 0 0     0 0     0               0            
2453001 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2019   pk_12_total 691 15 33   0 38     0   24   430 371     *             66   801 691 15 33   0 38     0   24   430 371             66   801
2453000 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 486 13 27   0 26     0   29   290 291     *             63   581 486 13 27   0 26     0   29   290 291             63   581
2452999 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 410 6 30   0 30     0   31   253 254     *             53   507 410 6 30   0 30     0   31   253 254             53   507
2452998 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 300 11 49   0 22     0   36   228 190     9             52   418 300 11 49   0 22     0   36   228 190     9       52   418
2452997 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2019   pk_12_total 180 0 30   * *     0   6   109 114     10             37   223 180 0 30           0   6   109 114     10       37   223
2452996 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 163 0 39   0 *     0   *   114 95     21             39   209 163 0 39   0       0       114 95     21       39   209
2452995 CT     school 904980 1540011   Westbrook School District 90498001042 1540211 Daisy Ingraham School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 169 * 55   0 *     0   7   103 136     50             31   239 169   55   0       0   7   103 136     50       31   239
2452994 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 462 362 520   * 70     *   57   749 727     122             202   1476 462 362 520     70         57   749 727     122       202   1476
2452993 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2019   pk_12_total * 0 *   0 0     0   0   0 *     0             0   *   0     0 0     0   0   0       0       0    
2452992 CT     school   1560011   West Haven School District   1560711 Blended Program           2019   pk_12_total 11 * 6   0 0     0   *   10 9     *             *   19 11   6   0 0     0       10 9                 19
2452991 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2019   pk_12_total * 11 19   0 0     0   *   22 18     *             14   40   11 19   0 0     0       22 18             14   40
2452990 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 315 234 352   * 26     *   29   466 494     87             144   960 315 234 352     26         29   466 494     87       144   960
2452989 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 281 211 357   * 30     *   36   510 408     91             145   918 281 211 357     30         36   510 408     91       145   918
2452988 CT     school   1560011   West Haven School District   1561111 ASD Lab             2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2452987 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2452986 CT     school 904950 1560011   West Haven School District 90495001039 1560411 Seth G. Haley School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 197 61 95   * 13     0   *   206 175     65             62   381 197 61 95     13     0       206 175     65       62   381
2452985 CT     school 904950 1560011   West Haven School District 90495001038 1561411 Savin Rock Community School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 116 113 230   * *     0   13   253 234     111             62   487 116 113 230           0   13   253 234     111       62   487
2452984 CT     school 904950 1560011   West Haven School District 90495001035 1560311 Forest School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 66 88 197   * *     0   28   199 198     128             68   397 66 88 197           0   28   199 198     128       68   397
2452983 CT     school 904950 1560011   West Haven School District 90495001033 1560611 Edith E. Mackrille School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 122 70 94   0 27     0   9   157 165     46             58   322 122 70 94   0 27     0   9   157 165     46       58   322
2452982 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 143 82 98   * 24     0   *   210 150     68             101   360 143 82 98     24     0       210 150     68       101   360
2452981 CT     school 904950 1560011   West Haven School District 90495001040 1561211 Washington School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 115 67 221   * *     0   20   232 200     126             49   432 115 67 221           0   20   232 200     126       49   432
2452980 CT     school   1550011   West Hartford School District 90492001526 1559011 Post Secondary Program Program           2019   pk_12_total 16 6 6   0 7     0   0   20 15     *             35   35 16 6 6   0 7     0   0   20 15             35   35
2452979 CT     school   1550011   West Hartford School District 90492001600 1559211 Strive-West Hartford Program           2019   pk_12_total 10 * 21   0 0     0   *   27 12     *             *   39 10   21   0 0     0       27 12                 39
2452978 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2019   pk_12_total 944 101 237   * 155     *   83   778 744     44             163   1522 944 101 237     155         83   778 744     44       163   1522
2452977 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2019   pk_12_total 771 143 297   * 195     0   *   763 707     53             171   1470 771 143 297     195     0       763 707     53       171   1470
2452976 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2019   pk_12_total 10 * 24   0 *     *   *   24 17     *             0   41 10   24   0               24 17             0   41
2452975 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 489 75 201   * 92     *   27   421 466     34             108   887 489 75 201     92         27   421 466     34       108   887
2452974 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 533 75 153   0 87     *   *   467 436     38             121   903 533 75 153   0 87             467 436     38       121   903
2452973 CT     school 904920 1550011   West Hartford School District 90492001419 1555311 Bristow Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 260 37 59   0 47     0   14   227 190     10             59   417 260 37 59   0 47     0   14   227 190     10       59   417
2452972 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2019   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
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            
2452970 CT     school 904920 1550011   West Hartford School District 90492001026 1551511 Wolcott School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 176 28 85   * 65     0   *   176 203     52             45   379 176 28 85     65     0       176 203     52       45   379
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
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
2452967 CT     school   1550011   West Hartford School District 90492001681 1559411 Norfeldt Learning Center Program           2019   pk_12_total 14 7 *   0 *     0   *   16 8     0             24   24 14 7     0       0       16 8     0       24   24
2452966 CT     school 904920 1550011   West Hartford School District 90492001018 1550911 Morley School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 215 15 41   0 9     0   17   146 151     12             27   297 215 15 41   0 9     0   17   146 151     12       27   297
2452965 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452964 CT     school 904920 1550011   West Hartford School District 90492001014 1550611 Duffy School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 371 18 65   0 32     0   21   256 251     40             30   507 371 18 65   0 32     0   21   256 251     40       30   507
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
2452962 CT     school 904920 1550011   West Hartford School District 90492001009 1550211 Braeburn School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 246 16 45   0 19     0   23   193 156     23             32   349 246 16 45   0 19     0   23   193 156     23       32   349
2452961 CT     school 904920 1550011   West Hartford School District 90492001025 1551311 Whiting Lane School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 196 29 67   0 35     *   *   196 155     48             108   351 196 29 67   0 35             196 155     48       108   351
2452960 CT     school 904920 1550011   West Hartford School District 90492001024 1551211 Webster Hill School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 187 25 81   0 38     0   14   160 185     53             42   345 187 25 81   0 38     0   14   160 185     53       42   345
2452959 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 110 49 116   0 67     0   9   182 169     68             26   351 110 49 116   0 67     0   9   182 169     68       26   351
2452958 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2019   pk_12_total 152 61 216   * 68     *   32   263 272     41             38   535 152 61 216     68         32   263 272     41       38   535
2452957 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 234 37 67   * 62     0   *   196 224     41             58   420 234 37 67     62     0       196 224     41       58   420
2452956 CT     school   1530011   Watertown School District   1530711 Watertown Transition Program at Post University             2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2452955 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452954 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2019   pk_12_total 679 31 65   * *     0   22   412 403     6             124   815 679 31 65           0   22   412 403     6       124   815
2452953 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 567 19 62   * *     0   20   364 321     16             100   685 567 19 62           0   20   364 321     16       100   685
2452952 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 251 13 33   0 *     0   *   174 131     20             40   305 251 13 33   0       0       174 131     20       40   305
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
2452950 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 572 19 34   * *     0   17   359 297     66             81   656 572 19 34           0   17   359 297     66       81   656
2452949 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             7   7   0     0 0     0   0           0       7   7
2452948 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2019   pk_12_total 643 19 98   * 52     *   20   432 *     7             138   838 643 19 98     52         20   432       7       138   838
2452947 CT     school   1520011   Waterford School District   1520911 Waterford Academy Program           2019   pk_12_total * 0 0   0 0     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]);