enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 4,154 ✖
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
2759992 2759992 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   52                                             52
2759991 2759991 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   77                                             77
2759990 2759990 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   62                                             62
2759989 2759989 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2020   kindergarten                                                   0                                             0
2759988 2759988 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759987 2759987 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759986 2759986 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759985 2759985 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759984 2759984 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 02 2020   kindergarten                                                   188                                             188
2759983 2759983 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2020   kindergarten                                                   0                                             0
2759982 2759982 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759981 2759981 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759980 2759980 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   50                                             50
2759979 2759979 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   43                                             43
2759978 2759978 CT     school 904860 1520011   Waterford School District 90486001593 1520211 Great Neck Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   44                                             44
2759977 2759977 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2020   kindergarten                                                   *                                              
2759976 2759976 CT     school   1520011   Waterford School District   1521011 The Early Learning Center II Program           2020   kindergarten                                                   0                                             0
2759975 2759975 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2020   kindergarten                                                   0                                             0
2759974 2759974 CT     school   1510011   Waterbury School District   1517111 School to Work Transition Academy Program           2020   kindergarten                                                   0                                             0
2759973 2759973 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759972 2759972 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2020   kindergarten                                                   0                                             0
2759971 2759971 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   kindergarten                                                   0                                             0
2759970 2759970 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759969 2759969 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759968 2759968 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759967 2759967 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2020   kindergarten                                                   0                                             0
2759966 2759966 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   kindergarten                                                   0                                             0
2759965 2759965 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2020   kindergarten                                                   0                                             0
2759964 2759964 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759963 2759963 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2020   kindergarten                                                   0                                             0
2759962 2759962 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2020   kindergarten                                                   0                                             0
2759961 2759961 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2020   kindergarten                                                   0                                             0
2759960 2759960 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2020   kindergarten                                                   0                                             0
2759959 2759959 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759958 2759958 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   kindergarten                                                   0                                             0
2759957 2759957 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2020   kindergarten                                                   0                                             0
2759956 2759956 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2020   kindergarten                                                   0                                             0
2759955 2759955 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2020   kindergarten                                                   0                                             0
2759954 2759954 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2020   kindergarten                                                   0                                             0
2759953 2759953 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759952 2759952 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   kindergarten                                                   0                                             0
2759951 2759951 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2020   kindergarten                                                   0                                             0
2759950 2759950 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2020   kindergarten                                                   0                                             0
2759949 2759949 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   kindergarten                                                   0                                             0
2759948 2759948 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   kindergarten                                                   0                                             0
2759947 2759947 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   kindergarten                                                   *                                              
2759946 2759946 CT     school 904830 1510011   Waterbury School District 90483000984 1512811 Regan School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   39                                             39
2759945 2759945 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2020   kindergarten                                                   *                                              
2759944 2759944 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   96                                             96
2759943 2759943 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   66                                             66
2759942 2759942 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2020   kindergarten                                                   26                                             26
2759941 2759941 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   kindergarten                                                   *                                              
2759940 2759940 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2020   kindergarten                                                   7                                             7
2759939 2759939 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   81                                             81
2759938 2759938 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2020   kindergarten                                                   32                                             32
2759937 2759937 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2020   kindergarten                                                   *                                              
2759936 2759936 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2020   kindergarten                                                   48                                             48
2759935 2759935 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2020   kindergarten                                                   9                                             9
2759934 2759934 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   73                                             73
2759933 2759933 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   57                                             57
2759932 2759932 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759931 2759931 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   50                                             50
2759930 2759930 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   56                                             56
2759929 2759929 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   63                                             63
2759928 2759928 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2020   kindergarten                                                   0                                             0
2759927 2759927 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   90                                             90
2759926 2759926 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   41                                             41
2759925 2759925 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2020   kindergarten                                                   0                                             0
2759924 2759924 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
2759923 2759923 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   97                                             97
2759922 2759922 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   44                                             44
2759921 2759921 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   59                                             59
2759920 2759920 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   85                                             85
2759919 2759919 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   41                                             41
2759918 2759918 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   89                                             89
2759917 2759917 CT     school 904830 1510011   Waterbury School District 90483000968 1510511 Bucks Hill School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   64                                             64
2759916 2759916 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   92                                             92
2759915 2759915 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2020   kindergarten                                                   0                                             0
2759914 2759914 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759913 2759913 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759912 2759912 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2020   kindergarten                                                   0                                             0
2759911 2759911 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2020   kindergarten                                                   0                                             0
2759910 2759910 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2020   kindergarten                                                   0                                             0
2759909 2759909 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759908 2759908 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759907 2759907 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2020   kindergarten                                                   0                                             0
2759906 2759906 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   kindergarten                                                   0                                             0
2759905 2759905 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2020   kindergarten                                                   0                                             0
2759904 2759904 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2020   kindergarten                                                   0                                             0
2759903 2759903 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759902 2759902 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759901 2759901 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759900 2759900 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759899 2759899 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2020   kindergarten                                                   0                                             0
2759898 2759898 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   kindergarten                                                   0                                             0
2759897 2759897 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2020   kindergarten                                                   *                                              
2759896 2759896 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2020   kindergarten                                                   *                                              
2759895 2759895 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2020   kindergarten                                                   83                                             83
2759894 2759894 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2020   kindergarten                                                   112                                             112
2759893 2759893 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2020   kindergarten                                                   83                                             83

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