Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 4,354
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
2453106 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2019   pk_12_total 7 * 10   0 0     0   *   24 0     *             *   24 7   10   0 0     0       24 0                 24
2453107 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2019   pk_12_total 15 11 17   0 *     0   *   17 32     *             *   49 15 11 17   0       0       17 32                 49
2453109 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2019   pk_12_total * 61 55   0 0     0   *   130 0     *             111   130   61 55   0 0     0       130 0             111   130
2453110 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   0 12     0             *   12         0 0     0   0   0 12     0           12
2453111 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2453112 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2453113 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2453114 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2453115 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2453116 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2019   pk_12_total 0 0 0   0 0     0   *   * 0     0             *   * 0 0 0   0 0     0         0     0            
2453146 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2758673 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2021   pk_12_total 10 13 9   0 0     0   0   9 23     *             23   32 10 13 9   0 0     0   0   9 23             23   32
2758674 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2021   pk_12_total 9 * *   * 0     0   *   19 0     0             *   19 9         0     0       19 0     0           19
2758694 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2021   pk_12_total * 60 33   0 0     0   *   108 0     *             88   108   60 33   0 0     0       108 0             88   108
2758695 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2021   pk_12_total * 6 *   0 0     0   0   12 0     *             12   12   6     0 0     0   0   12 0             12   12
2758696 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2021   pk_12_total * * *   0 0     0   0   0 *     0             *   *         0 0     0   0   0       0            
2758697 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2758698 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2758699 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2021   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2758700 CT     school   3360015   Unified School District #1 90000300374 3360915 New Haven Correctional Center State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758701 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   *   * 0     0             *   * 0   0   0 0     0         0     0            
2758702 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2758703 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758722 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758723 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   0 *     0             *   * 0   0   0 0     0   0   0       0            
2779122 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2020   pk_12_total * * 11   0 0     0   0   22 0     *             *   22     11   0 0     0   0   22 0                 22
2779123 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2020   pk_12_total 23 12 *   0 0     0   *   12 34     *             39   46 23 12     0 0     0       12 34             39   46
2779143 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2020   pk_12_total 13 54 40   0 0     0   6   113 0     *             93   113 13 54 40   0 0     0   6   113 0             93   113
2779144 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2779145 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2020   pk_12_total * 6 *   0 0     0   0   0 9     0             9   9   6     0 0     0   0   0 9     0       9   9
2779146 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779147 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   6 0     0             6   6 0       0 0     0   0   6 0     0       6   6
2779148 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   9 0     0             9   9 0       0 0     0   0   9 0     0       9   9
2779149 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779150 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779151 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779152 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2779153 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779154 CT     school   3360015   Unified School District #1 90000300419 3361315 Robinson Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779183 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2779184 CT     school   3370015   Department of Mental Health and Addiction Services 90002701537 3370515 Greater Bridgeport Community Mental Health Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779185 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   0 *     0             *   * 0 0     0 0     0   0   0       0            
2452607 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 300 * 48   0 *     0   19   194 *     7             53   379 300   48   0       0   19   194       7       53   379
2452608 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2019   pk_12_total 170 * *   0 0     0   11   94 99     *             28   193 170       0 0     0   11   94 99             28   193
2452609 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2019   pk_12_total 116 * 9   * 0     0   *   72 *     *             30   132 116   9     0     0       72               30   132
2452610 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2019   pk_12_total 68 * *   0 *     0   *   44 32     0             12   76 68       0       0       44 32     0       12   76
2452611 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2019   pk_12_total 471 8 15   * *     *   *   224 285     *             93   509 471 8 15                   224 285             93   509
2452612 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2019   pk_12_total 329 6 8   * 0     0   *   173 175     *             54   348 329 6 8     0     0       173 175             54   348
2452613 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2019   pk_12_total 384 * 16   * 9     0   6   231 190     23             48   421 384   16     9     0   6   231 190     23       48   421
2452614 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2019   pk_12_total 693 * 15   * 17     *   *   387 347     *             88   734 693   15     17             387 347             88   734
2452615 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2019   pk_12_total 700 7 31   * 10     *   *   372 385     0             82   757 700 7 31     10             372 385     0       82   757
2452616 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 123 * 13   0 *     0   *   63 77     *             12   140 123   13   0       0       63 77             12   140
2452617 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 67 0 *   0 0     0   *   31 40     0             9   71 67 0     0 0     0       31 40     0       9   71
2452618 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 48 0 *   0 *     0   *   29 24     *             *   53 48 0     0       0       29 24                 53
2452619 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2019   pk_12_total 373 * 31   0 *     0   *   207 210     *             70   417 373   31   0       0       207 210             70   417
2452621 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 03 2019   pk_12_total 240 0 13   * *     0   *   135 126     *             46   261 240 0 13           0       135 126             46   261
2452622 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2019   pk_12_total 205 * 14   0 *     0   10   106 128     6             35   234 205   14   0       0   10   106 128     6       35   234
2452623 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2019   pk_12_total 265 * 30   0 *     0   11   153 159     *             51   312 265   30   0       0   11   153 159             51   312
2452624 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 234 0 15   0 *     0   *   126 139     0             50   265 234 0 15   0       0       126 139     0       50   265
2452625 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 468 * 25   * 12     0   7   269 *     *             77   515 468   25     12     0   7   269               77   515
2452627 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 249 * 8   * *     0   6   139 129     *             39   268 249   8           0   6   139 129             39   268
2452628 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 287 * 32   0 *     0   14   183 169     11             47   352 287   32   0       0   14   183 169     11       47   352
2452629 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 304 * 20   * 8     0   *   160 177     *             63   337 304   20     8     0       160 177             63   337
2452630 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2019   pk_12_total 635 * 25   * 14     0   6   * 385     *             112   688 635   25     14     0   6     385             112   688
2452632 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 434 10 26   0 27     0   18   282 233     *             105   515 434 10 26   0 27     0   18   282 233             105   515
2452633 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 265 * 16   0 13     *   *   160 142     15             41   302 265   16   0 13             160 142     15       41   302
2452634 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 284 10 21   * 16     0   *   167 173     9             40   340 284 10 21     16     0       167 173     9       40   340
2452635 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 297 6 36   0 11     0   8   199 159     *             59   358 297 6 36   0 11     0   8   199 159             59   358
2452636 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 382 * 16   0 20     *   9   212 226     0             76   438 382   16   0 20         9   212 226     0       76   438
2452637 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 368 * 21   * 19     0   10   222 207     *             76   429 368   21     19     0   10   222 207             76   429
2452638 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 1018 17 75   * 69     *   19   632 575     6             196   1207 1018 17 75     69         19   632 575     6       196   1207
2452640 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 542 18 22   0 6     0   17   320 285     14             75   605 542 18 22   0 6     0   17   320 285     14       75   605
2452641 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 245 * 30   0 *     0   8   155 141     9             36   296 245   30   0       0   8   155 141     9       36   296
2452642 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 474 18 37   * 6     0   *   250 288     7             79   538 474 18 37     6     0       250 288     7       79   538
2452644 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 591 27 43   0 *     0   *   355 320     *             73   675 591 27 43   0       0       355 320             73   675
2452645 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary PK 04 2019   pk_12_total 236 * 11   0 6     0   *   137 120     *             59   257 236   11   0 6     0       137 120             59   257
2452647 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary KG 04 2019   pk_12_total 244 0 11   0 *     0   *   130 135     *             41   265 244 0 11   0       0       130 135             41   265
2452648 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 05 08 2019   pk_12_total 615 * 18   0 *     0   22   358 313     *             127   671 615   18   0       0   22   358 313             127   671
2452649 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2019   pk_12_total 601 8 12   0 14     0   9   333 311     *             83   644 601 8 12   0 14     0   9   333 311             83   644
2452651 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2019   pk_12_total 40 * *   0 0     0   *   26 23     0             13   49 40       0 0     0       26 23     0       13   49
2452652 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 180 0 *   0 *     0   11   120 85     *             24   205 180 0     0       0   11   120 85             24   205
2452653 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 207 * 16   0 *     0   14   125 126     10             39   251 207   16   0       0   14   125 126     10       39   251
2452654 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 244 * 15   0 10     0   *   131 147     *             39   278 244   15   0 10     0       131 147             39   278
2452655 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2019   pk_12_total 427 * 24   * 9     0   7   236 235     *             36   471 427   24     9     0   7   236 235             36   471
2453087 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 247 * 17   0 *     0   12   134 149     *             54   283 247   17   0       0   12   134 149             54   283
2453088 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 549 * 18   * 14     0   13   297 302     *             82   599 549   18     14     0   13   297 302             82   599
2453090 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2019   pk_12_total 234 * *   0 54     0   15   162 153     *             42   315 234       0 54     0   15   162 153             42   315
2453091 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2019   pk_12_total 286 * *   0 49     0   11   178 178     0             42   356 286       0 49     0   11   178 178     0       42   356
2453092 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 1135 48 25   * 207     *   67   739 752     10             175   1491 1135 48 25     207         67   739 752     10       175   1491
2453096 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 264 0 7   0 *     *   8   134 149     0             47   283 264 0 7   0           8   134 149     0       47   283
2453098 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 657 7 13   0 *     *   10   326 368     *             60   694 657 7 13   0           10   326 368             60   694
2453101 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2019   pk_12_total 444 * 23   0 9     *   0   261 222     *             70   483 444   23   0 9         0   261 222             70   483
2453102 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2019   pk_12_total 887 8 26   * 24     0   *   477 475     *             120   952 887 8 26     24     0       477 475             120   952
2453103 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2019   pk_12_total 190 * 18   0 0     *   9   129 96     *             39   225 190   18   0 0         9   129 96             39   225
2453139 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2019   pk_12_total 734 * 54   0 33     *   45   454 421     *             96   875 734   54   0 33         45   454 421             96   875
2453140 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2019   pk_12_total 783 * 96   0 45     *   144   533 558     9             135   1091 783   96   0 45         144   533 558     9       135   1091
2758184 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 172 * 8   0 *     0   10   97 97     7             25   194 172   8   0       0   10   97 97     7       25   194
2758185 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 116 * 9   0 0     0   *   65 64     *             26   129 116   9   0 0     0       65 64             26   129
2758186 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 60 0 *   0 *     0   *   40 25     0             8   65 60 0     0       0       40 25     0       8   65
2758187 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   pk_12_total 432 8 28   * *     *   9   * 267     *             87   484 432 8 28               9     267             87   484

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