Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,412

grade

  • pk_12_total · 1,412
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
2452416 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 212 70 228   * *     0   11   264 266     41             82   530 212 70 228           0   11   264 266     41       82   530
2452417 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 32 243 178   0 *     0   *   253 206     51             65   459 32 243 178   0       0       253 206     51       65   459
2452418 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 97 255 169   0 20     *   *   270 276     71             57   546 97 255 169   0 20             270 276     71       57   546
2452419 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 74 256 136   * *     0   9   253 228     20             54   481 74 256 136           0   9   253 228     20       54   481
2452420 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2019   pk_12_total 0 * 9   0 0     0   *   10 6     0             8   16 0   9   0 0     0       10 6     0       8   16
2452421 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 108 119 261   0 *     *   17   253 258     43             60   511 108 119 261   0           17   253 258     43       60   511
2452422 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 27 293 144   * *     0   8   233 245     33             77   478 27 293 144           0   8   233 245     33       77   478
2452423 CT     school 902790 930011   New Haven School District 90279001484 934811 Celentano BioTech, Health and Medical Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 31 210 127   0 11     0   9   174 214     40             69   388 31 210 127   0 11     0   9   174 214     40       69   388
2452424 CT     school 902790 930011   New Haven School District 90279000549 934111 Columbus Family Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total 10 14 468   0 *     0   *   253 243     230             60   496 10 14 468   0       0       253 243     230       60   496
2452425 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 53 267 325   * 7     *   *   327 335     76             70   662 53 267 325     7             327 335     76       70   662
2452426 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2019   pk_12_total 99 309 91   * *     0   10   251 266     8             59   517 99 309 91           0   10   251 266     8       59   517
2452427 CT     school   930011   New Haven School District   932711 Dr. Reginald Mayo Early Learning Center Program           2019   pk_12_total 18 218 140   * *     0   10   201 196     0             82   397 18 218 140           0   10   201 196     0       82   397
2452428 CT     school 902790 930011   New Haven School District 90279000552 934611 East Rock Community Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 69 176 205   * 25     0   *   222 260     84             71   482 69 176 205     25     0       222 260     84       71   482
2452429 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2019   pk_12_total * 15 23   0 *     0   0   31 13     6             44   44   15 23   0       0   0   31 13     6       44   44
2452430 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 38 70 678   * 21     *   *   413 399     444             83   812 38 70 678     21             413 399     444       83   812
2452431 CT     school 902790 930011   New Haven School District 90279000559 930711 Hill Central Music Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total * 92 372   0 *     0   0   249 236     195             69   485   92 372   0       0   0   249 236     195       69   485
2452432 CT     school 902790 930011   New Haven School District 90279001443 931311 John C. Daniels Public Schools Regular School No Elementary PK 08 2019   pk_12_total 58 70 395   0 10     0   7   281 259     138             52   540 58 70 395   0 10     0   7   281 259     138       52   540
2452433 CT     school 902790 930011   New Haven School District 90279001386 930811 John S. Martinez Sea and Sky STEM School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 17 45 484   * *     *   *   279 273     232             60   552 17 45 484                   279 273     232       60   552
2452434 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 41 381 69   0 *     0   *   250 259     24             62   509 41 381 69   0       0       250 259     24       62   509
2452435 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   13 0       0 0     0   0           0           13
2452436 CT     school 902790 930011   New Haven School District 90279000566 932011 Lincoln-Bassett School Public Schools Regular School No Elementary PK 06 2019   pk_12_total * 268 83   0 9     0   *   210 161     10             70   371   268 83   0 9     0       210 161     10       70   371
2452437 CT     school   930011   New Haven School District   938011 Lulac             2019   pk_12_total * 28 85   0 0     *   0   61 56     0             8   117   28 85   0 0         0   61 56     0       8   117
2452438 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 98 274 157   * 9     0   *   289 259     53             74   548 98 274 157     9     0       289 259     53       74   548
2452439 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 121 207 300   0 23     0   7   348 310     71             55   658 121 207 300   0 23     0   7   348 310     71       55   658
2452440 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 14 57 476   0 12     *   *   292 273     278             73   565 14 57 476   0 12             292 273     278       73   565
2452441 CT     school 902790 930011   New Haven School District 90279000647 934911 West Rock Authors Academy Public Schools Regular School No Elementary PK 04 2019   pk_12_total 32 89 42   * 6     0   *   87 87     7             13   174 32 89 42     6     0       87 87     7       13   174
2452442 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452443 CT     school 902790 930011   New Haven School District 90279000586 933211 Wexler/Grant Community School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 10 266 91   0 0     0   6   196 177     18             56   373 10 266 91   0 0     0   6   196 177     18       56   373
2452444 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 134 204 73   * *     0   17   213 225     31             46   438 134 204 73           0   17   213 225     31       46   438
2452445 CT     school 902790 930011   New Haven School District 90279001509 932811 Barack H. Obama Magnet University School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 11 81 152   0 11     0   12   146 121     105             32   267 11 81 152   0 11     0   12   146 121     105       32   267
2452446 CT     school   930011   New Haven School District   937611 Barack H. Obama Self Contained Autism Program           2019   pk_12_total * * 10   0 0     0   0   * *     0             20   20     10   0 0     0   0           0       20   20
2452447 CT     school 902790 930011   New Haven School District 90279000546 934311 Bishop Woods Architecture and Design Magnet School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 41 146 246   * 10     0   *   209 239     53             44   448 41 146 246     10     0       209 239     53       44   448
2452448 CT     school   930011   New Haven School District   937911 Bishop Woods Self Contained Autism Program           2019   pk_12_total * * 11   0 0     0   0   * *     0             15   15     11   0 0     0   0           0       15   15
2452449 CT     school   930011   New Haven School District   937211 Brennan Rogers Self Contained Autism Program           2019   pk_12_total * 12 8   0 0     0   *   * *     0             23   23   12 8   0 0     0               0       23   23
2452450 CT     school 902790 930011   New Haven School District 90279000550 930611 Clinton Avenue School Public Schools Regular School No Elementary KG 08 2019   pk_12_total * 75 379   0 0     0   *   260 233     180             64   493   75 379   0 0     0       260 233     180       64   493
2452451 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2452452 CT     school 902790 930011   New Haven School District 90279001612 933511 Quinnipiac Real World Math STEM School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 21 91 158   0 *     0   *   142 137     47             29   279 21 91 158   0       0       142 137     47       29   279
2452453 CT     school 902790 930011   New Haven School District 90279001483 934211 Roberto Clemente Leadership Academy for Global Awareness Public Schools Regular School No Elementary KG 08 2019   pk_12_total 41 144 278   0 9     *   *   246 229     123             74   475 41 144 278   0 9             246 229     123       74   475
2452454 CT     school 902790 930011   New Haven School District 90279000588 933811 Worthington Hooker School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 181 73 59   * 129     0   *   239 214     71             26   453 181 73 59     129     0       239 214     71       26   453
2452455 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2019   pk_12_total 0 * *   0 0     0   0   6 8     7             14   14 0       0 0     0   0   6 8     7       14   14
2452456 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2019   pk_12_total * 7 *   0 0     0   *   * *     0             13   13   7     0 0     0               0       13   13
2452457 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             10   10     7   0 0     0   0                   10   10
2452458 CT     school   930011   New Haven School District   938411 West Rock Self Contained Autism Program           2019   pk_12_total * 7 *   0 0     0   0   * *     0             11   11   7     0 0     0   0           0       11   11
2452459 CT     school   930011   New Haven School District   938611 Wexler Grant Self Contained Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             8   8     0   0 0     0   0           0       8   8
2452460 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2019   pk_12_total * * *   0 0     0   *   * *     *             12   12         0 0     0                       12   12
2452461 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2019   pk_12_total 90 187 157   * 7     0   *   147 301     30             45   448 90 187 157     7     0       147 301     30       45   448
2452462 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2019   pk_12_total 197 237 119   0 38     0   10   396 205     13             36   601 197 237 119   0 38     0   10   396 205     13       36   601
2452463 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2019   pk_12_total 100 278 234   * *     0   9   200 430     33             83   630 100 278 234           0   9   200 430     33       83   630
2452464 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2019   pk_12_total * 29 *   0 0     0   0   26 21     *             14   47   29     0 0     0   0   26 21             14   47
2452465 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2019   pk_12_total 31 77 120   * 6     0   *   127 112     40             49   239 31 77 120     6     0       127 112     40       49   239
2452466 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2019   pk_12_total 59 295 305   * 30     0   *   295 405     61             70   700 59 295 305     30     0       295 405     61       70   700
2452467 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2019   pk_12_total 46 597 289   * 8     *   *   507 439     156             192   946 46 597 289     8             507 439     156       192   946
2452468 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             *   9 0       0 0     0   0                       9
2452469 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2019   pk_12_total 37 149 215   * *     0   *   220 190     35             41   410 37 149 215           0       220 190     35       41   410
2452470 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2019   pk_12_total 25 206 66   0 *     0   *   149 155     *             58   304 25 206 66   0       0       149 155             58   304
2452471 CT     school   930011   New Haven School District 90279001550 939111 Riverside Education Academy Program           2019   pk_12_total 6 72 47   0 0     0   0   77 48     9             69   125 6 72 47   0 0     0   0   77 48     9       69   125
2452472 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2019   pk_12_total 173 31 111   0 *     0   *   172 146     14             67   318 173 31 111   0       0       172 146     14       67   318
2452473 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2019   pk_12_total 179 429 944   * 34     0   *   805 789     314             254   1594 179 429 944     34     0       805 789     314       254   1594
2452474 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2019   pk_12_total * * 12   0 0     0   0   12 8     *             20   20     12   0 0     0   0   12 8             20   20
2452475 CT     school   930011   New Haven School District   937311 Off-Campus Classroom Program (OCC) Program           2019   pk_12_total * 26 *   0 0     0   0   31 19     13             50   50   26     0 0     0   0   31 19     13       50   50
2452413 CT     school 902760 920011   New Hartford School District 90276000540 920211 New Hartford Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 85 * *   0 *     0   *   53 43     *             10   96 85       0       0       53 43             10   96
2452414 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 87 0 *   0 0     0   *   50 40     0             6   90 87 0     0 0     0       50 40     0       6   90
2452415 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2019   pk_12_total 243 * *   0 *     0   9   127 133     0             33   260 243       0       0   9   127 133     0       33   260
2452408 CT     school 902730 910011   New Fairfield School District 90273000535 910111 Consolidated School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 392 8 61   * *     *   18   246 238     36             79   484 392 8 61               18   246 238     36       79   484
2452409 CT     school 902730 910011   New Fairfield School District 90273001195 910211 Meeting House Hill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 377 * 58   * 6     0   8   221 236     17             60   457 377   58     6     0   8   221 236     17       60   457
2452410 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 423 11 57   * *     0   11   270 242     6             60   512 423 11 57           0   11   270 242     6       60   512
2452411 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 661 11 71   * 19     *   12   401 376     *             94   777 661 11 71     19         12   401 376             94   777
2452412 CT     school   910011   New Fairfield School District 90273001687 910311 Alternative Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   7   0     0 0     0   0           0           7
2453145 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 925 * 26   * 124     0   11   545 553     0             74   1098 925   26     124     0   11   545 553     0       74   1098
2453105 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   pk_12_total 348 8 82   0 50     0   23   275 *     16             74   511 348 8 82   0 50     0   23   275       16       74   511
2453136 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 1123 330 366   22 174     22   197   1084 1150     187             247   2234 1123 330 366   22 174     22   197   1084 1150     187       247   2234
2453137 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   pk_12_total 7 * *   0 0     0   0   * *     *             *   15 7       0 0     0   0                       15
2453138 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   pk_12_total * * *   0 0     0   0   * *     0             *   7         0 0     0   0           0           7
2451733 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 339 * 101   * 37     0   26   290 233     45             90   523 339   101     37     0   26   290 233     45       90   523
2451734 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 279 * 91   * 22     0   17   225 204     50             34   429 279   91     22     0   17   225 204     50       34   429
2451735 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2019   pk_12_total 323 15 86   6 32     0   22   261 223     31             62   484 323 15 86   6 32     0   22   261 223     31       62   484
2451736 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 501 21 162   * 46     *   11   372 373     28             84   745 501 21 162     46         11   372 373     28       84   745
2451737 CT     school 900270 90011   Bethel School District 90027000024 96111 Bethel High School Public Schools Regular School No High 09 12 2019   pk_12_total 621 31 162   * 70     *   16   485 419     30             114   904 621 31 162     70         16   485 419     30       114   904
2451738 CT     school   90011   Bethel School District   90311 TASK Program           2019   pk_12_total * 0 *   0 *     0   *   * *     *             *   12   0     0       0                           12
2451739 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452402 CT     school 902700 900011   New Canaan School District 90270000534 900311 West School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 432 * 14   0 24     0   *   264 220     6             68   484 432   14   0 24     0       264 220     6       68   484
2452403 CT     school 902700 900011   New Canaan School District 90270000530 900411 East School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 415 * 30   0 37     *   27   261 274     12             49   535 415   30   0 37         27   261 274     12       49   535
2452404 CT     school 902700 900011   New Canaan School District 90270000533 900211 South School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 417 * 26   * 45     0   28   265 254     14             37   519 417   26     45     0   28   265 254     14       37   519
2452405 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 1102 8 72   * 105     *   42   686 648     9             162   1334 1102 8 72     105         42   686 648     9       162   1334
2452406 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2019   pk_12_total 1096 23 53   * 77     *   32   647 637     *             167   1284 1096 23 53     77         32   647 637             167   1284
2452407 CT     school   900011   New Canaan School District   900111 Launch Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2453118 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   pk_12_total 32 177 444   * 13     *   *   339 338     71             64   677 32 177 444     13             339 338     71       64   677
2453119 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   pk_12_total 30 213 488   * *     0   20   362 398     53             35   760 30 213 488           0   20   362 398     53       35   760
2453120 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   pk_12_total 179 44 390   * *     0   21   369 *     33             48   647 179 44 390           0   21   369       33       48   647
2453121 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   pk_12_total 66 215 288   * 7     *   14   304 289     46             93   593 66 215 288     7         14   304 289     46       93   593
2453122 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   pk_12_total 246 35 162   * 7     *   34   299 192     17             82   491 246 35 162     7         34   299 192     17       82   491
2453123 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   pk_12_total 350 50 179   0 *     *   21   349 258     13             75   607 350 50 179   0           21   349 258     13       75   607
2453124 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   pk_12_total 341 45 335   * *     0   27   441 322     20             62   763 341 45 335           0   27   441 322     20       62   763
2453125 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   pk_12_total 590 * 39   * 6     0   16   469 188     *             58   657 590   39     6     0   16   469 188             58   657
2453126 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   pk_12_total 300 25 320   0 8     0   19   385 287     29             71   672 300 25 320   0 8     0   19   385 287     29       71   672
2453127 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   pk_12_total 342 70 169   0 18     0   32   486 145     14             62   631 342 70 169   0 18     0   32   486 145     14       62   631
2453128 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   pk_12_total 83 77 250   0 *     0   *   235 186     22             53   421 83 77 250   0       0       235 186     22       53   421
2453129 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   pk_12_total 426 43 111   * *     0   49   369 272     11             52   641 426 43 111           0   49   369 272     11       52   641
2453130 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   pk_12_total 524 12 73   0 *     *   23   399 238     *             78   637 524 12 73   0           23   399 238             78   637
2453131 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   pk_12_total 322 111 325   * *     0   35   514 294     19             95   808 322 111 325           0   35   514 294     19       95   808

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]);