enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_7" and state = "CT" sorted by school_state_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 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
2443020 2443020 CT     school   2440014   Area Cooperative Educational Services   2449314 Whitney High School West             2019   grade_7                                                   0                                             0
2443054 2443054 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 09 12 2019   grade_7                                                   0                                             0
2443164 2443164 CT     school   2410014   Capitol Region Education Council   2411714 Soundbridge@Mountain View Elementary School             2019   grade_7                                                   0                                             0
2443173 2443173 CT     school   2410014   Capitol Region Education Council   2411514 Soundbridge @ Chippens Hill MS Bristol             2019   grade_7                                                   *                                              
2443176 2443176 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2019   grade_7                                                   0                                             0
2443177 2443177 CT     school   2410014   Capitol Region Education Council   2419614 Lincoln Academy Regional Interdistrict Collaborative             2019   grade_7                                                   0                                             0
2443191 2443191 CT     school 900810 270011   Clinton School District 90081000131 270111 Abraham Pierson School   Regular School No Elementary 04 05 2019   grade_7                                                   0                                             0
2443198 2443198 CT     school   280011   Colchester School District   280611 School Resilience Program             2019   grade_7                                                   0                                             0
2443308 2443308 CT     school   2420014   EdAdvance   2420214 Torrington Alternative Program             2019   grade_7                                                   *                                              
2443412 2443412 CT     school 901770 590011   Groton School District 90177000312 595311 Carl C. Cutler Middle School   Regular School No Middle 06 08 2019   grade_7                                                   161                                             161
2443413 2443413 CT     school 901770 590011   Groton School District 90177000326 595211 West Side Middle School   Regular School No Middle 06 08 2019   grade_7                                                   175                                             175
2443464 2443464 CT     school   640011   Hartford School District   640310 Pre-K Integrated - Burr School             2019   grade_7                                                   0                                             0
2443485 2443485 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   grade_7                                                   0                                             0
2443487 2443487 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2019   grade_7                                                   7                                             7
2443495 2443495 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2019   grade_7                                                   7                                             7
2443500 2443500 CT     school 901920 640011   Hartford School District 90192001574 647211 HPHS Engineering and Green Technology Academy   Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443501 2443501 CT     school 901920 640011   Hartford School District 90192001576 647411 HPHS Law and Government Academy   Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443502 2443502 CT     school 901920 640011   Hartford School District 90192001559 647511 HPHS Nursing and Health Sciences Academy   Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443503 2443503 CT     school 901920 640011   Hartford School District 90192001552 647611 High School, Inc.   Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443504 2443504 CT     school 901920 640011   Hartford School District 90192001562 647711 Journalism and Media Academy   Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443510 2443510 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2019   grade_7                                                   0                                             0
2443511 2443511 CT     school 901920 640011   Hartford School District 90192001522 646011 Culinary Arts Academy at Weaver High School   Regular School No High 11 12 2019   grade_7                                                   0                                             0
2443512 2443512 CT     school 901920 640011   Hartford School District 90192001650 643911 Capital Community College Magnet Academy   Regular School No High 12 12 2019   grade_7                                                   0                                             0
2443533 2443533 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2019   grade_7                                                   *                                              
2443534 2443534 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2019   grade_7                                                   43                                             43
2443535 2443535 CT     school   2450014   Learn   2451214 Learn ABA Program at Center School             2019   grade_7                                                   *                                              
2443536 2443536 CT     school   2450014   Learn   2450514 Learn Pathways Program             2019   grade_7                                                   0                                             0
2443547 2443547 CT     school 902160 720011   Ledyard School District 90216000400 720111 Ledyard Center School   Regular School No Elementary KG 06 2019   grade_7                                                   0                                             0
2443558 2443558 CT     school 902280 760011   Madison School District 90228000414 760211 Island Avenue Elementary School   Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2443568 2443568 CT     school 902310 770011   Manchester School District 90231000431 771411 Washington School   Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2443574 2443574 CT     school   770011   Manchester School District   771111 Elementary Site 2             2019   grade_7                                                   0                                             0
2443601 2443601 CT     school   800011   Meriden School District   802311 SOAR - LMS             2019   grade_7                                                   *                                              
2443743 2443743 CT     school   930011   New Haven School District   938011 Lulac             2019   grade_7                                                   0                                             0
2443952 2443952 CT     school 903539 2170012   Regional School District 17 90353900758 2170112 Haddam Elementary School   Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2444056 2444056 CT     school   1340011   Stafford School District   1340211 Stafford Tutoring Program             2019   grade_7                                                   0                                             0
2444084 2444084 CT     school 904380 1370011   Stonington School District 90438001637 1370111 Stonington BOE Pre-School   Special Education School No Prekindergarten PK PK 2019   grade_7                                                   0                                             0
2444085 2444085 CT     school 904380 1370011   Stonington School District 90438001635 1370211 Stonington HS PreK   Special Education School No Prekindergarten PK PK 2019   grade_7                                                   0                                             0
2444088 2444088 CT     school 904380 1370011   Stonington School District 90438000882 1370411 West Broad Street School   Regular School No Elementary 03 04 2019   grade_7                                                   0                                             0
2444089 2444089 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   grade_7                                                   73                                             73
2444132 2444132 CT     school   1430011   Torrington School District   1432211 East TPS - PreK - Reg Ed             2019   grade_7                                                   0                                             0
2444162 2444162 CT     school   1460011   Vernon School District   1460911 First Step             2019   grade_7                                                   0                                             0
2444180 2444180 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_7                                                   *                                              
2444184 2444184 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   grade_7                                                   0                                             0
2444219 2444219 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   grade_7                                                   0                                             0
2444225 2444225 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   grade_7                                                   *                                              
2444262 2444262 CT     school   1530011   Watertown School District   1530711 Watertown Transition Program at Post University             2019   grade_7                                                   0                                             0
2444294 2444294 CT     school   1560011   West Haven School District   1561111 ASD Lab             2019   grade_7                                                   *                                              
2444350 2444350 CT     school 905190 1630011   Windham School District 90519001920 1631311 Windham STEPS Academy   Alternative School No High 09 12 2019   grade_7                                                   0                                             0
2444392 2444392 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   grade_7                                                   44                                             44
2444448 2444448 CT     school   2190012   Regional School District 19   2190212 PM Panthers             2019   grade_7                                                   0                                             0
2444450 2444450 CT     school 900031 2820013   Stamford Academy District 90003101405 2826013 Stamford Academy   Regular School Yes High 09 12 2019   grade_7                                                   0                                             0
2749205 2749205 CT     school   800011   Meriden School District   802311 SOAR - LMS             2021   grade_7                                                   *                                              
2769010 2769010 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   grade_7                                                   0                                             0
2769134 2769134 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2020   grade_7                                                   0                                             0
2769370 2769370 CT     school 901770 590011   Groton School District 90177000312 595311 Carl C. Cutler Middle School   Regular School No Middle 06 08 2020   grade_7                                                   179                                             179
2769371 2769371 CT     school 901770 590011   Groton School District 90177000326 595211 West Side Middle School   Regular School No Middle 06 08 2020   grade_7                                                   158                                             158
2769421 2769421 CT     school   640011   Hartford School District   640310 Pre-K Integrated - Burr School             2020   grade_7                                                   0                                             0
2769444 2769444 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2020   grade_7                                                   0                                             0
2769445 2769445 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2020   grade_7                                                   *                                              
2769455 2769455 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2020   grade_7                                                   0                                             0
2769467 2769467 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2020   grade_7                                                   0                                             0
2769487 2769487 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2020   grade_7                                                   50                                             50
2769489 2769489 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2020   grade_7                                                   *                                              
2769550 2769550 CT     school   800011   Meriden School District   802311 SOAR - LMS             2020   grade_7                                                   *                                              
2770125 2770125 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   grade_7                                                   0                                             0
2770133 2770133 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   grade_7                                                   *                                              
2770138 2770138 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2020   grade_7                                                   0                                             0
2770175 2770175 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   grade_7                                                   0                                             0
2770249 2770249 CT     school   1560011   West Haven School District   1561111 ASD Lab             2020   grade_7                                                   *                                              
2770415 2770415 CT     school 900031 2820013   Stamford Academy District 90003101405 2826013 Stamford Academy   Regular School Yes High 09 12 2020   grade_7                                                   0                                             0
2444424 2444424 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444425 2444425 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444426 2444426 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444427 2444427 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444428 2444428 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444429 2444429 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444430 2444430 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444431 2444431 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444432 2444432 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444433 2444433 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444434 2444434 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444435 2444435 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444436 2444436 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444437 2444437 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444438 2444438 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444439 2444439 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2444440 2444440 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2750041 2750041 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750042 2750042 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750043 2750043 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750044 2750044 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750045 2750045 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750046 2750046 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750047 2750047 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750048 2750048 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750049 2750049 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750050 2750050 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750051 2750051 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750052 2750052 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   0                                             0
2750053 2750053 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_7                                                   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]);