enrollments

Data source: Big Local News · About: Big Local

1,449 rows where grade = "kindergarten", state = "CT" and year = 2019 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,249 ✖

grade ✖

  • kindergarten · 1,249 ✖
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
2434109 2434109 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434108 2434108 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   61                                             61
2434107 2434107 CT     school 904860 1520011   Waterford School District 90486001593 1520211 Great Neck Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   50                                             50
2434106 2434106 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2019   kindergarten                                                   *                                              
2434105 2434105 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2019   kindergarten                                                   0                                             0
2434104 2434104 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   *                                              
2434103 2434103 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434102 2434102 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2019   kindergarten                                                   0                                             0
2434101 2434101 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   kindergarten                                                   0                                             0
2434100 2434100 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434099 2434099 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434098 2434098 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434097 2434097 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2019   kindergarten                                                   0                                             0
2434096 2434096 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   kindergarten                                                   0                                             0
2434095 2434095 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2019   kindergarten                                                   0                                             0
2434094 2434094 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2019   kindergarten                                                   0                                             0
2434093 2434093 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434092 2434092 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   kindergarten                                                   0                                             0
2434091 2434091 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2019   kindergarten                                                   0                                             0
2434090 2434090 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2019   kindergarten                                                   0                                             0
2434089 2434089 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   kindergarten                                                   0                                             0
2434088 2434088 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434087 2434087 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2019   kindergarten                                                   0                                             0
2434086 2434086 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2019   kindergarten                                                   0                                             0
2434085 2434085 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   kindergarten                                                   0                                             0
2434084 2434084 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434083 2434083 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2019   kindergarten                                                   0                                             0
2434082 2434082 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   kindergarten                                                   0                                             0
2434081 2434081 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434080 2434080 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   kindergarten                                                   0                                             0
2434079 2434079 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2019   kindergarten                                                   0                                             0
2434078 2434078 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   kindergarten                                                   0                                             0
2434077 2434077 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2019   kindergarten                                                   0                                             0
2434076 2434076 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   kindergarten                                                   0                                             0
2434075 2434075 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2019   kindergarten                                                   6                                             6
2434074 2434074 CT     school 904830 1510011   Waterbury School District 90483000984 1512811 Regan School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   39                                             39
2434073 2434073 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   96                                             96
2434072 2434072 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   77                                             77
2434071 2434071 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2019   kindergarten                                                   20                                             20
2434070 2434070 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   kindergarten                                                   *                                              
2434069 2434069 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2019   kindergarten                                                   6                                             6
2434068 2434068 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   80                                             80
2434067 2434067 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2019   kindergarten                                                   18                                             18
2434066 2434066 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   kindergarten                                                   *                                              
2434065 2434065 CT     school 904830 1510011   Waterbury School District 90483000968 1510511 Bucks Hill School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   67                                             67
2434064 2434064 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2019   kindergarten                                                   27                                             27
2434063 2434063 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2019   kindergarten                                                   *                                              
2434062 2434062 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   83                                             83
2434061 2434061 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   60                                             60
2434060 2434060 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434059 2434059 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   55                                             55
2434058 2434058 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   62                                             62
2434057 2434057 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   70                                             70
2434056 2434056 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2019   kindergarten                                                   0                                             0
2434055 2434055 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   89                                             89
2434054 2434054 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   41                                             41
2434053 2434053 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2019   kindergarten                                                   0                                             0
2434052 2434052 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   80                                             80
2434051 2434051 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   98                                             98
2434050 2434050 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   44                                             44
2434049 2434049 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   56                                             56
2434048 2434048 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   86                                             86
2434047 2434047 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   48                                             48
2434046 2434046 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   93                                             93
2434045 2434045 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   98                                             98
2434044 2434044 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   kindergarten                                                   0                                             0
2434043 2434043 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434042 2434042 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434041 2434041 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   kindergarten                                                   0                                             0
2434040 2434040 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434039 2434039 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2019   kindergarten                                                   0                                             0
2434038 2434038 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434037 2434037 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   kindergarten                                                   0                                             0
2434036 2434036 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2019   kindergarten                                                   0                                             0
2434035 2434035 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2019   kindergarten                                                   0                                             0
2434034 2434034 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2019   kindergarten                                                   0                                             0
2434033 2434033 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2019   kindergarten                                                   0                                             0
2434032 2434032 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2019   kindergarten                                                   0                                             0
2434031 2434031 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2019   kindergarten                                                   0                                             0
2434030 2434030 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   kindergarten                                                   0                                             0
2434029 2434029 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2019   kindergarten                                                   *                                              
2434028 2434028 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2019   kindergarten                                                   103                                             103
2434027 2434027 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2019   kindergarten                                                   77                                             77
2434026 2434026 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2019   kindergarten                                                   99                                             99
2434025 2434025 CT     school 904740 1480011   Wallingford School District 90474000950 1481011 Cook Hill School Public Schools Regular School No Elementary PK 02 2019   kindergarten                                                   82                                             82
2434024 2434024 CT     school 904710 1470011   Voluntown School District 90471000949 1470111 Voluntown Elementary School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   11                                             11
2434023 2434023 CT     school   1460011   Vernon School District 90468001525 1469011 Next Step Program Program           2019   kindergarten                                                   0                                             0
2434022 2434022 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434021 2434021 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2434020 2434020 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2019   kindergarten                                                   0                                             0
2434019 2434019 CT     school   1460011   Vernon School District   1460911 First Step             2019   kindergarten                                                   0                                             0
2434018 2434018 CT     school 904680 1460011   Vernon School District 90468000941 1460211 Maple Street School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   47                                             47
2434017 2434017 CT     school   1460011   Vernon School District   1461111 Elementary Activities Based Learning Program Program           2019   kindergarten                                                   *                                              
2434016 2434016 CT     school 904680 1460011   Vernon School District 90468000944 1461011 Skinner Road School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   49                                             49
2434015 2434015 CT     school 904680 1460011   Vernon School District 90468000942 1460311 Northeast School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   37                                             37
2434014 2434014 CT     school 904680 1460011   Vernon School District 90468000940 1460111 Lake Street School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   38                                             38
2434013 2434013 CT     school 904680 1460011   Vernon School District 90468000939 1461411 Center Road School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   78                                             78
2434012 2434012 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   *                                              
2434011 2434011 CT     school   1440011   Trumbull School District   1440611 Educating Learners in Transitional Environments (ELITE) Program           2019   kindergarten                                                   0                                             0
2434010 2434010 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull 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]);