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,449

grade

  • pk_12_total · 1,449
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
2452508 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 333 * 23   0 *     0   0   188 180     7             40   368 333   23   0       0   0   188 180     7       40   368
2452509 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 352 * 29   * 11     0   0   222 178     *             48   400 352   29     11     0   0   222 178             48   400
2452510 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2019   pk_12_total 355 15 31   0 14     0   0   226 189     *             58   415 355 15 31   0 14     0   0   226 189             58   415
2452511 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2019   pk_12_total 476 * 38   * 15     0   0   242 302     *             88   544 476   38     15     0   0   242 302             88   544
2452512 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452507 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 82 0 *   0 0     0   *   54 41     *             18   95 82 0     0 0     0       54 41             18   95
2452498 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2019   pk_12_total 68 * *   0 0     0   0   42 28     0             45   70 68       0 0     0   0   42 28     0       45   70
2452499 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 270 * 26   0 8     0   *   154 156     *             50   310 270   26   0 8     0       154 156             50   310
2452500 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 242 * 27   0 6     0   *   153 130     *             35   283 242   27   0 6     0       153 130             35   283
2452501 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 296 * 41   * 8     0   10   187 174     *             43   361 296   41     8     0   10   187 174             43   361
2452502 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 302 * 38   * 12     0   8   189 175     8             47   364 302   38     12     0   8   189 175     8       47   364
2452503 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 527 11 44   0 26     0   16   299 325     *             95   624 527 11 44   0 26     0   16   299 325             95   624
2452504 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 579 16 49   0 22     0   15   337 344     0             88   681 579 16 49   0 22     0   15   337 344     0       88   681
2452505 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2019   pk_12_total 1383 18 83   0 69     0   22   811 *     *             143   1575 1383 18 83   0 69     0   22   811               143   1575
2452506 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2019   pk_12_total 13 * 0   0 *     0   0   * *     0             15   15 13   0   0       0   0           0       15   15
2452485 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 269 * 61   * 15     0   20   192 183     24             47   375 269   61     15     0   20   192 183     24       47   375
2452486 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 365 17 53   0 12     0   12   233 226     17             70   459 365 17 53   0 12     0   12   233 226     17       70   459
2452487 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 578 25 144   0 28     0   41   408 408     50             130   816 578 25 144   0 28     0   41   408 408     50       130   816
2452488 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 729 * 153   * 40     0   44   537 *     29             150   991 729   153     40     0   44   537       29       150   991
2452489 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   pk_12_total 1061 * 155   * 48     0   33   699 *     34             169   1328 1061   155     48     0   33   699       34       169   1328
2452490 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2452476 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2019   pk_12_total 35 54 361   * *     0   24   255 225     214             53   480 35 54 361           0   24   255 225     214       53   480
2452477 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 34 43 152   * *     *   21   145 116     55             50   261 34 43 152               21   145 116     55       50   261
2452478 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   pk_12_total 0 0 *   0 0     0   0   * *     0             *   * 0 0     0 0     0   0           0            
2452479 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 124 83 242   * 7     *   87   223 323     75             76   546 124 83 242     7         87   223 323     75       76   546
2452480 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 150 84 191   * 10     *   78   279 237     62             70   516 150 84 191     10         78   279 237     62       70   516
2452481 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 19 45 192   * *     0   17   155 122     104             57   277 19 45 192           0   17   155 122     104       57   277
2452482 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 09 2019   pk_12_total 55 38 87   * *     0   21   92 112     25             46   204 55 38 87           0   21   92 112     25       46   204
2452483 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2019   pk_12_total 156 127 179   * 12     *   85   321 243     37             66   564 156 127 179     12         85   321 243     37       66   564
2452484 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2019   pk_12_total 51 160 388   * *     *   49   353 306     196             165   659 51 160 388               49   353 306     196       165   659
2452491 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 235 29 90   0 42     0   23   197 222     46             56   419 235 29 90   0 42     0   23   197 222     46       56   419
2452492 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 142 12 88   0 25     0   18   151 134     35             54   285 142 12 88   0 25     0   18   151 134     35       54   285
2452493 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 227 27 71   0 32     *   *   191 187     45             65   378 227 27 71   0 32             191 187     45       65   378
2452494 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 187 21 61   * 32     0   *   163 159     33             49   322 187 21 61     32     0       163 159     33       49   322
2452495 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 415 41 128   0 52     0   35   334 337     21             82   671 415 41 128   0 52     0   35   334 337     21       82   671
2452496 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 360 39 152   * 63     0   *   319 327     26             88   646 360 39 152     63     0       319 327     26       88   646
2452497 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 76 221   * 114     *   68   693 617     16             147   1310 827 76 221     114         68   693 617     16       147   1310
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

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