Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by ccd_school_high_grade descending

View and edit SQL

grade

year

  • 2020 · 20,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
2773385 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2773407 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2773446 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2773560 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2773587 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2773797 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2774166 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2774185 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2774290 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2774365 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2774846 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2774868 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2774907 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775021 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775048 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775258 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775627 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775646 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775751 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2775826 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2776307 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776329 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776368 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776482 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776509 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2776719 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2777088 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2777107 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2777212 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2777287 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2777768 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 107 110 38   * 33     0   *   159 155     0             49   314 107 110 38     33     0       159 155     0       49   314
2777790 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 36 46 121   0 *     0   *   141 69     0             137   210 36 46 121   0       0       141 69     0       137   210
2777829 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total 68 0 31   0 *     0   *   75 38     0             70   113 68 0 31   0       0       75 38     0       70   113
2777943 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 46 * 81   0 13     0   *   101 54     0             80   155 46   81   0 13     0       101 54     0       80   155
2777970 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 21 6 15   0 0     0   7   24 25     0             19   49 21 6 15   0 0     0   7   24 25     0       19   49
2778180 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 18 56 26   * 56     0   *   76 85     0             9   161 18 56 26     56     0       76 85     0       9   161
2778549 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 53 15 67   * 12     0   *   84 71     0             92   155 53 15 67     12     0       84 71     0       92   155
2778568 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 54 34 66   * 10     *   12   97 81     0             61   178 54 34 66     10         12   97 81     0       61   178
2778673 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total * 0 *   0 0     0   0   37 34     0             12   71   0     0 0     0   0   37 34     0       12   71
2778748 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 63 0 7   0 *     0   *   50 27     0             52   77 63 0 7   0       0       50 27     0       52   77
2758910 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   kindergarten                                                   82                                             82
2759012 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   kindergarten                                                   *                                              
2759256 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   kindergarten                                                   108                                             108
2759596 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   kindergarten                                                   189                                             189
2760371 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_1                                                   0                                             0
2760473 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_1                                                   0                                             0
2760717 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_1                                                   0                                             0
2761057 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_1                                                   0                                             0
2761832 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_2                                                   0                                             0
2761934 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_2                                                   0                                             0
2762178 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_2                                                   0                                             0
2762518 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_2                                                   0                                             0
2763293 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_3                                                   0                                             0
2763395 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_3                                                   0                                             0
2763639 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_3                                                   0                                             0
2763979 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_3                                                   0                                             0
2764754 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_4                                                   0                                             0
2764856 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_4                                                   0                                             0
2765100 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_4                                                   0                                             0
2765440 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_4                                                   0                                             0
2766215 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_5                                                   0                                             0
2766317 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_5                                                   0                                             0
2766561 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_5                                                   0                                             0
2766901 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_5                                                   0                                             0
2767676 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_6                                                   0                                             0
2767778 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_6                                                   0                                             0
2768022 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_6                                                   0                                             0
2768362 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_6                                                   0                                             0
2769137 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_7                                                   0                                             0
2769239 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_7                                                   0                                             0
2769483 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_7                                                   0                                             0
2769823 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_7                                                   0                                             0
2770598 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_8                                                   0                                             0
2770700 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_8                                                   0                                             0
2770944 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_8                                                   0                                             0
2771284 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_8                                                   0                                             0
2772059 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_9                                                   0                                             0
2772161 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_9                                                   0                                             0
2772405 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_9                                                   0                                             0
2772745 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_9                                                   0                                             0
2773520 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_10                                                   0                                             0
2773622 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_10                                                   0                                             0
2773866 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_10                                                   0                                             0
2774206 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_10                                                   0                                             0
2774981 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_11                                                   0                                             0
2775083 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_11                                                   0                                             0
2775327 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_11                                                   0                                             0
2775667 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_11                                                   0                                             0
2776442 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   grade_12                                                   0                                             0
2776544 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   grade_12                                                   0                                             0
2776788 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   grade_12                                                   0                                             0
2777128 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   grade_12                                                   0                                             0
2777903 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   pk_12_total 138 * *   0 14     0   16   114 71     *             50   185 138       0 14     0   16   114 71             50   185
2778005 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   pk_12_total 99 * 56   0 9     0   *   80 95     0             *   175 99   56   0 9     0       80 95     0           175
2778249 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   pk_12_total 184 54 192   0 *     *   55   263 240     23             51   503 184 54 192   0           55   263 240     23       51   503
2778589 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   pk_12_total 175 * 17   0 28     0   *   130 106     11             32   236 175   17   0 28     0       130 106     11       32   236
2758737 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2758757 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2758765 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2758772 CT     school 900270 90011   Bethel School District 90027000024 96111 Bethel High School Public Schools Regular School No High 09 12 2020   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]);