Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 4,254
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
2452328 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             *   11 7       0 0     0   0           0           11
2452348 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2019   pk_12_total * * 0   0 0     0   0   * *     *             6   6     0   0 0     0   0                   6   6
2452349 CT     school   840011   Milford School District   840611 Post Grad Transitional Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452363 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2019   pk_12_total 6 * 0   0 *     0   0   8 0     *             8   8 6   0   0       0   0   8 0             8   8
2452375 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2019   pk_12_total 8 * *   0 0     0   0   * *     *             0   15 8       0 0     0   0                   0   15
2452379 CT     school   890011   New Britain School District   891611 Gaffney KEY Elementary Program           2019   pk_12_total 14 13 63   0 *     0   *   74 28     0             102   102 14 13 63   0       0       74 28     0       102   102
2452381 CT     school   890011   New Britain School District   890111 Roosevelt Early Learning Center Program           2019   pk_12_total 23 17 107   0 *     0   *   95 68     0             88   163 23 17 107   0       0       95 68     0       88   163
2452384 CT     school   890011   New Britain School District   890211 Chamberlain Bridges Program           2019   pk_12_total * * 19   0 0     0   0   * *     *             *   24     19   0 0     0   0                       24
2452385 CT     school   890011   New Britain School District   890411 Holmes Bridges Program           2019   pk_12_total * * 15   0 0     0   0   * *     *             18   18     15   0 0     0   0                   18   18
2452387 CT     school   890011   New Britain School District   891011 Lincoln SCS Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452393 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2452396 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2019   pk_12_total * * 9   0 *     0   *   * *     *             17   17     9   0       0                       17   17
2452400 CT     school   890011   New Britain School District   899511 New Britain High School Satellite Careers Academy Program           2019   pk_12_total * 26 132   0 0     0   *   103 73     27             12   176   26 132   0 0     0       103 73     27       12   176
2452407 CT     school   900011   New Canaan School District   900111 Launch Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452420 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2019   pk_12_total 0 * 9   0 0     0   *   10 6     0             8   16 0   9   0 0     0       10 6     0       8   16
2452427 CT     school   930011   New Haven School District   932711 Dr. Reginald Mayo Early Learning Center Program           2019   pk_12_total 18 218 140   * *     0   10   201 196     0             82   397 18 218 140           0   10   201 196     0       82   397
2452429 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2019   pk_12_total * 15 23   0 *     0   0   31 13     6             44   44   15 23   0       0   0   31 13     6       44   44
2452435 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   13 0       0 0     0   0           0           13
2452437 CT     school   930011   New Haven School District   938011 Lulac             2019   pk_12_total * 28 85   0 0     *   0   61 56     0             8   117   28 85   0 0         0   61 56     0       8   117
2452442 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452446 CT     school   930011   New Haven School District   937611 Barack H. Obama Self Contained Autism Program           2019   pk_12_total * * 10   0 0     0   0   * *     0             20   20     10   0 0     0   0           0       20   20
2452448 CT     school   930011   New Haven School District   937911 Bishop Woods Self Contained Autism Program           2019   pk_12_total * * 11   0 0     0   0   * *     0             15   15     11   0 0     0   0           0       15   15
2452449 CT     school   930011   New Haven School District   937211 Brennan Rogers Self Contained Autism Program           2019   pk_12_total * 12 8   0 0     0   *   * *     0             23   23   12 8   0 0     0               0       23   23
2452451 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2452455 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2019   pk_12_total 0 * *   0 0     0   0   6 8     7             14   14 0       0 0     0   0   6 8     7       14   14
2452456 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2019   pk_12_total * 7 *   0 0     0   *   * *     0             13   13   7     0 0     0               0       13   13
2452457 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             10   10     7   0 0     0   0                   10   10
2452458 CT     school   930011   New Haven School District   938411 West Rock Self Contained Autism Program           2019   pk_12_total * 7 *   0 0     0   0   * *     0             11   11   7     0 0     0   0           0       11   11
2452459 CT     school   930011   New Haven School District   938611 Wexler Grant Self Contained Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             8   8     0   0 0     0   0           0       8   8
2452460 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2019   pk_12_total * * *   0 0     0   *   * *     *             12   12         0 0     0                       12   12
2452464 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2019   pk_12_total * 29 *   0 0     0   0   26 21     *             14   47   29     0 0     0   0   26 21             14   47
2452468 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             *   9 0       0 0     0   0                       9
2452474 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2019   pk_12_total * * 12   0 0     0   0   12 8     *             20   20     12   0 0     0   0   12 8             20   20
2452475 CT     school   930011   New Haven School District   937311 Off-Campus Classroom Program (OCC) Program           2019   pk_12_total * 26 *   0 0     0   0   31 19     13             50   50   26     0 0     0   0   31 19     13       50   50
2452478 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   pk_12_total 0 0 *   0 0     0   0   * *     0             *   * 0 0     0 0     0   0           0            
2452506 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2019   pk_12_total 13 * 0   0 *     0   0   * *     0             15   15 13   0   0       0   0           0       15   15
2452543 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   pk_12_total 7 * *   0 0     0   0   10 7     *             17   17 7       0 0     0   0   10 7             17   17
2452546 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2019   pk_12_total * * 6   0 *     0   *   6 6     *             12   12     6   0       0       6 6             12   12
2452551 CT     school   1040011   Norwich School District   1040911 Stanton Special Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   6 0     0             6   6   0     0 0     0   0   6 0     0       6   6
2452552 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2019   pk_12_total 7 * 6   0 *     0   *   * *     8             21   21 7   6   0       0               8       21   21
2452553 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2019   pk_12_total * * *   0 0     0   0   * *     *             6   6         0 0     0   0                   6   6
2452558 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2452561 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2019   pk_12_total 16 * *   0 *     0   *   14 9     *             23   23 16       0       0       14 9             23   23
2452573 CT     school   1080011   Oxford School District   1080411 Connections Alternative Learning Center Program           2019   pk_12_total 6 0 0   0 0     0   0   * *     0             *   6 6 0 0   0 0     0   0           0           6
2452585 CT     school   1100011   Plainville School District   1100111 Plainville Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2452604 CT     school   2010012   Regional School District 01   2010412 LEAPSS Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452605 CT     school   2010012   Regional School District 01   2010312 SELC Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452606 CT     school   2010012   Regional School District 01   2010612 Mountaineer Academy Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452620 CT     school   2120012   Regional School District 12   2120512 Shepaug Valley Partnership Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452631 CT     school   2140012   Regional School District 14   2140412 Region 14 Transition Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452639 CT     school   2150012   Regional School District 15   2150112 MIJ Program Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             6   13     0   0 0     0   0           0       6   13
2452650 CT     school   2170012   Regional School District 17   2170412 RSD17 Transition Program Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452656 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452662 CT     school   1180011   Ridgefield School District   1180111 District Program BMES Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452664 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             7   7   0 0   0 0     0               0       7   7
2452665 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452666 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2019   pk_12_total 6 0 0   0 0     0   0   6 0     0             6   6 6 0 0   0 0     0   0   6 0     0       6   6
2452669 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452676 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   7   0     0 0     0   0           0           7
2452689 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2019   pk_12_total 13 * *   0 *     0   *   * *     0             23   23 13       0       0               0       23   23
2452691 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2019   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2452692 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2452693 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2452694 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2452698 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2019   pk_12_total 14 * *   0 0     0   0   8 9     0             17   17 14       0 0     0   0   8 9     0       17   17
2452708 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2019   pk_12_total 28 * *   0 *     0   *   22 15     0             37   37 28       0       0       22 15     0       37   37
2452712 CT     school   1290011   Somers School District   1290511 Aspire Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452716 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2019   pk_12_total 47 * 11   0 15     0   *   48 38     0             50   86 47   11   0 15     0       48 38     0       50   86
2452728 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2019   pk_12_total 8 * *   0 0     0   0   * *     0             10   10 8       0 0     0   0           0       10   10
2452743 CT     school   1310011   Southington School District   1312211 STELLAR Program           2019   pk_12_total 7 * 0   0 *     0   0   * *     0             9   9 7   0   0       0   0           0       9   9
2452750 CT     school   1340011   Stafford School District   1340211 Stafford Tutoring Program             2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   7   0 0   0 0     0               0           7
2452786 CT     school   1370011   Stonington School District   1370711 SAILS Program           2019   pk_12_total * 0 *   0 0     0   0   7 0     0             *   7   0     0 0     0   0   7 0     0           7
2452795 CT     school   1380011   Stratford School District   1382811 STEPS K-6 Program           2019   pk_12_total 6 6 6   0 0     0   0   * *     0             18   18 6 6 6   0 0     0   0           0       18   18
2452797 CT     school   1380011   Stratford School District   1382311 DLC Whitney Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452799 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2019   pk_12_total * * *   0 0     0   0   6 0     0             6   6         0 0     0   0   6 0     0       6   6
2452817 CT     school   1400011   Thomaston School District   1400311 PATHS Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             8   15   0     0 0     0   0           0       8   15
2452826 CT     school   1430011   Torrington School District   1432211 East TPS - PreK - Reg Ed             2019   pk_12_total 12 * 30   0 *     0   0   26 18     0             *   44 12   30   0       0   0   26 18     0           44
2452828 CT     school   1430011   Torrington School District   1430611 TPS Preschool Lab Program           2019   pk_12_total 16 0 *   0 0     0   *   11 9     0             9   20 16 0     0 0     0       11 9     0       9   20
2452835 CT     school   1430011   Torrington School District   1430311 Post Secondary Transition Services Program           2019   pk_12_total 0 0 *   0 0     0   *   * 0     0             *   * 0 0     0 0     0         0     0            
2452848 CT     school   1440011   Trumbull School District   1440611 Educating Learners in Transitional Environments (ELITE) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2452854 CT     school   1460011   Vernon School District   1461111 Elementary Activities Based Learning Program Program           2019   pk_12_total * 0 *   0 *     0   *   * *     0             8   8   0     0       0               0       8   8
2452856 CT     school   1460011   Vernon School District   1460911 First Step             2019   pk_12_total * * *   0 *     0   0   * *     0             8   8         0       0   0           0       8   8
2452857 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2019   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2452866 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2019   pk_12_total 11 0 *   0 *     0   0   * *     *             15   15 11 0     0       0   0                   15   15
2452872 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2019   pk_12_total * 0 *   0 *     0   0   * *     *             9   9   0     0       0   0                   9   9
2452873 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452874 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   pk_12_total 16 0 *   0 0     0   *   * *     0             21   21 16 0     0 0     0               0       21   21
2452876 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2019   pk_12_total 9 0 *   0 *     0   0   6 7     *             13   13 9 0     0       0   0   6 7             13   13
2452878 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   pk_12_total 14 0 6   0 0     0   0   13 7     *             *   20 14 0 6   0 0     0   0   13 7                 20
2452890 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2019   pk_12_total * * 7   0 0     0   0   * *     0             15   15     7   0 0     0   0           0       15   15
2452900 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2019   pk_12_total * 6 13   0 0     0   *   19 7     *             26   26   6 13   0 0     0       19 7             26   26
2452901 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2019   pk_12_total 0 0 210   0 0     0   0   108 102     *             44   210 0 0 210   0 0     0   0   108 102             44   210
2452903 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   pk_12_total * * 10   0 *     0   *   7 11     *             18   18     10   0       0       7 11             18   18
2452904 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2019   pk_12_total 8 0 122   0 0     0   0   78 52     130             22   130 8 0 122   0 0     0   0   78 52     130       22   130
2452906 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2019   pk_12_total * 11 16   0 *     0   *   * *     *             31   31   11 16   0       0                       31   31
2452907 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   pk_12_total * * *   0 0     0   0   * *     *             9   9         0 0     0   0                   9   9
2452908 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2019   pk_12_total 0 0 127   0 0     0   0   67 60     127             17   127 0 0 127   0 0     0   0   67 60     127       17   127
2452913 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452914 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2019   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
2452915 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   pk_12_total * * 16   0 0     0   *   16 8     *             24   24     16   0 0     0       16 8             24   24

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