enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "kindergarten" and state = "CT" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

  • kindergarten · 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
2434233 2434233 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2019   kindergarten                                                   96                                             96
2739874 2739874 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   96                                             96
2760106 2760106 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   kindergarten                                                   95                                             95
2434234 2434234 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   kindergarten                                                   91                                             91
2739875 2739875 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   60                                             60
2760107 2760107 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   kindergarten                                                   96                                             96
2434235 2434235 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   kindergarten                                                   93                                             93
2739876 2739876 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   92                                             92
2760108 2760108 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   kindergarten                                                   93                                             93
2432861 2432861 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   kindergarten                                                   22                                             22
2738516 2738516 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   23                                             23
2758732 2758732 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   20                                             20
2432862 2432862 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2019   kindergarten                                                   0                                             0
2432863 2432863 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   kindergarten                                                   88                                             88
2432864 2432864 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   kindergarten                                                   87                                             87
2432865 2432865 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   kindergarten                                                   0                                             0
2432866 2432866 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2432867 2432867 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2019   kindergarten                                                   0                                             0
2432868 2432868 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2019   kindergarten                                                   0                                             0
2738517 2738517 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2021   kindergarten                                                   0                                             0
2738518 2738518 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   92                                             92
2738519 2738519 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   88                                             88
2738520 2738520 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2021   kindergarten                                                   0                                             0
2738521 2738521 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2738522 2738522 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2021   kindergarten                                                   0                                             0
2738523 2738523 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2021   kindergarten                                                   0                                             0
2738524 2738524 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2021   kindergarten                                                   0                                             0
2758733 2758733 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2020   kindergarten                                                   0                                             0
2758734 2758734 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   91                                             91
2758735 2758735 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2020   kindergarten                                                   90                                             90
2758736 2758736 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
2758737 2758737 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2758738 2758738 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2020   kindergarten                                                   0                                             0
2758739 2758739 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2020   kindergarten                                                   0                                             0
2758740 2758740 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   kindergarten                                                   0                                             0
2432869 2432869 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2019   kindergarten                                                   *                                              
2432870 2432870 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2019   kindergarten                                                   *                                              
2432871 2432871 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2019   kindergarten                                                   55                                             55
2432872 2432872 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2019   kindergarten                                                   0                                             0
2432873 2432873 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2432874 2432874 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2019   kindergarten                                                   0                                             0
2432875 2432875 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2019   kindergarten                                                   0                                             0
2432876 2432876 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2019   kindergarten                                                   0                                             0
2432877 2432877 CT     school   2440014   Area Cooperative Educational Services   2449314 Whitney High School West             2019   kindergarten                                                   0                                             0
2432878 2432878 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2019   kindergarten                                                   0                                             0
2739877 2739877 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2021   kindergarten                                                   *                                              
2739878 2739878 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2021   kindergarten                                                   *                                              
2739879 2739879 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2021   kindergarten                                                   37                                             37
2739880 2739880 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2021   kindergarten                                                   0                                             0
2739881 2739881 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2021   kindergarten                                                   0                                             0
2739882 2739882 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2021   kindergarten                                                   0                                             0
2739883 2739883 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739884 2739884 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2021   kindergarten                                                   0                                             0
2739885 2739885 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2021   kindergarten                                                   0                                             0
2739886 2739886 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2021   kindergarten                                                   0                                             0
2758741 2758741 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2020   kindergarten                                                   *                                              
2758742 2758742 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2020   kindergarten                                                   *                                              
2758743 2758743 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2020   kindergarten                                                   44                                             44
2758744 2758744 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   kindergarten                                                   0                                             0
2758745 2758745 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2020   kindergarten                                                   0                                             0
2758746 2758746 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2758747 2758747 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2020   kindergarten                                                   0                                             0
2758748 2758748 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2020   kindergarten                                                   0                                             0
2758749 2758749 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2020   kindergarten                                                   0                                             0
2758750 2758750 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2020   kindergarten                                                   0                                             0
2432879 2432879 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   36                                             36
2738525 2738525 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   35                                             35
2758751 2758751 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   45                                             45
2432880 2432880 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   kindergarten                                                   0                                             0
2432881 2432881 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   kindergarten                                                   105                                             105
2432882 2432882 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   kindergarten                                                   101                                             101
2432883 2432883 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   kindergarten                                                   0                                             0
2432884 2432884 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   kindergarten                                                   0                                             0
2432885 2432885 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2738526 2738526 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2021   kindergarten                                                   0                                             0
2738527 2738527 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   108                                             108
2738528 2738528 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   90                                             90
2738529 2738529 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2021   kindergarten                                                   0                                             0
2738530 2738530 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2021   kindergarten                                                   0                                             0
2738531 2738531 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2758752 2758752 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2020   kindergarten                                                   0                                             0
2758753 2758753 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   139                                             139
2758754 2758754 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   84                                             84
2758755 2758755 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2020   kindergarten                                                   0                                             0
2758756 2758756 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
2758757 2758757 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2432886 2432886 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary PK 06 2019   kindergarten                                                   20                                             20
2432887 2432887 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   kindergarten                                                   0                                             0
2432888 2432888 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   kindergarten                                                   *                                              
2738532 2738532 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2021   kindergarten                                                   0                                             0
2738533 2738533 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   28                                             28
2738534 2738534 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2021   kindergarten                                                   *                                              
2758758 2758758 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   29                                             29
2758759 2758759 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2020   kindergarten                                                   0                                             0
2758760 2758760 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2020   kindergarten                                                   *                                              
2432889 2432889 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   73                                             73
2432890 2432890 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   80                                             80
2432891 2432891 CT     school 900210 70011   Berlin School District 90021000021 70111 Richard D. Hubbard School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   36                                             36
2432892 2432892 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2432893 2432893 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   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]);