enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 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
2777524 2777524 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777523 2777523 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777522 2777522 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777521 2777521 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2020   grade_12                                                   *                                              
2777520 2777520 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2020   grade_12                                                   216                                             216
2777519 2777519 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777518 2777518 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2777517 2777517 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2777516 2777516 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2777515 2777515 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2020   grade_12                                                   *                                              
2777514 2777514 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2020   grade_12                                                   212                                             212
2777513 2777513 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777512 2777512 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777511 2777511 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777510 2777510 CT     school 904860 1520011   Waterford School District 90486001593 1520211 Great Neck Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777509 2777509 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2020   grade_12                                                   0                                             0
2777508 2777508 CT     school   1520011   Waterford School District   1521011 The Early Learning Center II Program           2020   grade_12                                                   0                                             0
2777507 2777507 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2020   grade_12                                                   0                                             0
2777506 2777506 CT     school   1510011   Waterbury School District   1517111 School to Work Transition Academy Program           2020   grade_12                                                   15                                             15
2777505 2777505 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2020   grade_12                                                   265                                             265
2777504 2777504 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2020   grade_12                                                   *                                              
2777503 2777503 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   grade_12                                                   6                                             6
2777502 2777502 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2020   grade_12                                                   107                                             107
2777501 2777501 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2020   grade_12                                                   306                                             306
2777500 2777500 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2020   grade_12                                                   277                                             277
2777499 2777499 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2020   grade_12                                                   0                                             0
2777498 2777498 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   grade_12                                                   0                                             0
2777497 2777497 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2020   grade_12                                                   0                                             0
2777496 2777496 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777495 2777495 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2020   grade_12                                                   0                                             0
2777494 2777494 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2020   grade_12                                                   0                                             0
2777493 2777493 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2020   grade_12                                                   0                                             0
2777492 2777492 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2020   grade_12                                                   0                                             0
2777491 2777491 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777490 2777490 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   grade_12                                                   0                                             0
2777489 2777489 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2020   grade_12                                                   0                                             0
2777488 2777488 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2020   grade_12                                                   0                                             0
2777487 2777487 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2020   grade_12                                                   0                                             0
2777486 2777486 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2020   grade_12                                                   21                                             21
2777485 2777485 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777484 2777484 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   grade_12                                                   0                                             0
2777483 2777483 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2020   grade_12                                                   0                                             0
2777482 2777482 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2020   grade_12                                                   0                                             0
2777481 2777481 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   grade_12                                                   0                                             0
2777480 2777480 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   grade_12                                                   0                                             0
2777479 2777479 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   grade_12                                                   17                                             17
2777478 2777478 CT     school 904830 1510011   Waterbury School District 90483000984 1512811 Regan School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777477 2777477 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2020   grade_12                                                   0                                             0
2777476 2777476 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777475 2777475 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777474 2777474 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2020   grade_12                                                   0                                             0
2777473 2777473 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   grade_12                                                   0                                             0
2777472 2777472 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2020   grade_12                                                   0                                             0
2777471 2777471 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777470 2777470 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2020   grade_12                                                   0                                             0
2777469 2777469 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2020   grade_12                                                   0                                             0
2777468 2777468 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2020   grade_12                                                   0                                             0
2777467 2777467 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2020   grade_12                                                   0                                             0
2777466 2777466 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777465 2777465 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777464 2777464 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2020   grade_12                                                   189                                             189
2777463 2777463 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777462 2777462 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777461 2777461 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777460 2777460 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2020   grade_12                                                   0                                             0
2777459 2777459 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777458 2777458 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2020   grade_12                                                   0                                             0
2777457 2777457 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2020   grade_12                                                   0                                             0
2777456 2777456 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777455 2777455 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777454 2777454 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2020   grade_12                                                   0                                             0
2777453 2777453 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2020   grade_12                                                   0                                             0
2777452 2777452 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777451 2777451 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2020   grade_12                                                   0                                             0
2777450 2777450 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777449 2777449 CT     school 904830 1510011   Waterbury School District 90483000968 1510511 Bucks Hill School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777448 2777448 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777447 2777447 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2020   grade_12                                                   6                                             6
2777446 2777446 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2020   grade_12                                                   201                                             201
2777445 2777445 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2020   grade_12                                                   256                                             256
2777444 2777444 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2020   grade_12                                                   *                                              
2777443 2777443 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2020   grade_12                                                   10                                             10
2777442 2777442 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2020   grade_12                                                   0                                             0
2777441 2777441 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777440 2777440 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777439 2777439 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2020   grade_12                                                   0                                             0
2777438 2777438 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   grade_12                                                   *                                              
2777437 2777437 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2020   grade_12                                                   0                                             0
2777436 2777436 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2020   grade_12                                                   0                                             0
2777435 2777435 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2777434 2777434 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2777433 2777433 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2777432 2777432 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_12                                                   0                                             0
2777431 2777431 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2020   grade_12                                                   0                                             0
2777430 2777430 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   grade_12                                                   0                                             0
2777429 2777429 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2020   grade_12                                                   0                                             0
2777428 2777428 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2020   grade_12                                                   0                                             0
2777427 2777427 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2777426 2777426 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2777425 2777425 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   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]);