enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 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
2768758 2768758 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768757 2768757 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768756 2768756 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768755 2768755 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2020   grade_6                                                   0                                             0
2768754 2768754 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768753 2768753 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   208                                             208
2768752 2768752 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2020   grade_6                                                   0                                             0
2768751 2768751 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2020   grade_6                                                   0                                             0
2768750 2768750 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 02 2020   grade_6                                                   0                                             0
2768749 2768749 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2020   grade_6                                                   0                                             0
2768748 2768748 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768747 2768747 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   195                                             195
2768746 2768746 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768745 2768745 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768744 2768744 CT     school 904860 1520011   Waterford School District 90486001593 1520211 Great Neck Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768743 2768743 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2020   grade_6                                                   0                                             0
2768742 2768742 CT     school   1520011   Waterford School District   1521011 The Early Learning Center II Program           2020   grade_6                                                   0                                             0
2768741 2768741 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2020   grade_6                                                   0                                             0
2768740 2768740 CT     school   1510011   Waterbury School District   1517111 School to Work Transition Academy Program           2020   grade_6                                                   0                                             0
2768739 2768739 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768738 2768738 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2020   grade_6                                                   0                                             0
2768737 2768737 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   grade_6                                                   0                                             0
2768736 2768736 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768735 2768735 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768734 2768734 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768733 2768733 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2020   grade_6                                                   *                                              
2768732 2768732 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   grade_6                                                   23                                             23
2768731 2768731 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2020   grade_6                                                   *                                              
2768730 2768730 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2020   grade_6                                                   121                                             121
2768729 2768729 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2020   grade_6                                                   *                                              
2768728 2768728 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2020   grade_6                                                   21                                             21
2768727 2768727 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2020   grade_6                                                   *                                              
2768726 2768726 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2020   grade_6                                                   *                                              
2768725 2768725 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   317                                             317
2768724 2768724 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   grade_6                                                   *                                              
2768723 2768723 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2020   grade_6                                                   20                                             20
2768722 2768722 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2020   grade_6                                                   *                                              
2768721 2768721 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2020   grade_6                                                   *                                              
2768720 2768720 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2020   grade_6                                                   *                                              
2768719 2768719 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   291                                             291
2768718 2768718 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   grade_6                                                   365                                             365
2768717 2768717 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2020   grade_6                                                   0                                             0
2768716 2768716 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2020   grade_6                                                   0                                             0
2768715 2768715 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   grade_6                                                   0                                             0
2768714 2768714 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   grade_6                                                   0                                             0
2768713 2768713 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   grade_6                                                   7                                             7
2768712 2768712 CT     school 904830 1510011   Waterbury School District 90483000984 1512811 Regan School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768711 2768711 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2020   grade_6                                                   *                                              
2768710 2768710 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768709 2768709 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768708 2768708 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2020   grade_6                                                   0                                             0
2768707 2768707 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   grade_6                                                   0                                             0
2768706 2768706 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2020   grade_6                                                   0                                             0
2768705 2768705 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
2768704 2768704 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2020   grade_6                                                   0                                             0
2768703 2768703 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2020   grade_6                                                   *                                              
2768702 2768702 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2020   grade_6                                                   0                                             0
2768701 2768701 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2020   grade_6                                                   0                                             0
2768700 2768700 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768699 2768699 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768698 2768698 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768697 2768697 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768696 2768696 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768695 2768695 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768694 2768694 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2020   grade_6                                                   0                                             0
2768693 2768693 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768692 2768692 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   54                                             54
2768691 2768691 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2020   grade_6                                                   0                                             0
2768690 2768690 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768689 2768689 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768688 2768688 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   45                                             45
2768687 2768687 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   48                                             48
2768686 2768686 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768685 2768685 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   56                                             56
2768684 2768684 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768683 2768683 CT     school 904830 1510011   Waterbury School District 90483000968 1510511 Bucks Hill School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768682 2768682 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2768681 2768681 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2020   grade_6                                                   0                                             0
2768680 2768680 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768679 2768679 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768678 2768678 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2020   grade_6                                                   0                                             0
2768677 2768677 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2020   grade_6                                                   0                                             0
2768676 2768676 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2020   grade_6                                                   0                                             0
2768675 2768675 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   201                                             201
2768674 2768674 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   209                                             209
2768673 2768673 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2020   grade_6                                                   *                                              
2768672 2768672 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   grade_6                                                   *                                              
2768671 2768671 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2020   grade_6                                                   0                                             0
2768670 2768670 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2020   grade_6                                                   0                                             0
2768669 2768669 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2020   grade_6                                                   0                                             0
2768668 2768668 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2020   grade_6                                                   0                                             0
2768667 2768667 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2020   grade_6                                                   0                                             0
2768666 2768666 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   grade_6                                                   0                                             0
2768665 2768665 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2020   grade_6                                                   0                                             0
2768664 2768664 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   grade_6                                                   0                                             0
2768663 2768663 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2020   grade_6                                                   0                                             0
2768662 2768662 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2020   grade_6                                                   0                                             0
2768661 2768661 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2020   grade_6                                                   0                                             0
2768660 2768660 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2020   grade_6                                                   0                                             0
2768659 2768659 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_6                                                   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]);