Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by district_state_id descending

View and edit SQL

year

grade

  • pk_12_total · 4,354
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▲ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
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            
2758085 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 314 * 33   0 *     0   14   * 195     6             37   368 314   33   0       0   14     195     6       37   368
2758086 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 303 0 27   0 *     0   *   169 174     7             50   343 303 0 27   0       0       169 174     7       50   343
2758087 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   pk_12_total 336 * 38   * 7     0   9   228 170     *             59   398 336   38     7     0   9   228 170             59   398
2758088 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   pk_12_total 424 14 38   0 9     0   7   232 260     *             79   492 424 14 38   0 9     0   7   232 260             79   492
2758089 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2778529 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 326 * 31   0 7     0   *   187 188     7             38   375 326   31   0 7     0       187 188     7       38   375
2778530 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 344 * 33   * 9     0   6   205 192     *             69   397 344   33     9     0   6   205 192             69   397
2778531 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   pk_12_total 335 12 29   * *     0   7   225 165     *             56   390 335 12 29           0   7   225 165             56   390
2778532 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   pk_12_total 458 12 39   0 9     0   6   239 285     *             84   524 458 12 39   0 9     0   6   239 285             84   524
2778533 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
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
2758084 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 68 0 *   0 0     0   *   42 38     *             18   80 68 0     0 0     0       42 38             18   80
2778528 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 61 0 *   0 0     0   *   38 35     *             21   73 61 0     0 0     0       38 35             21   73
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
2758073 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2021   pk_12_total * 0 *   0 0     0   0   39 21     0             32   60   0     0 0     0   0   39 21     0       32   60
2758074 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 239 * 27   0 6     0   *   137 142     *             35   279 239   27   0 6     0       137 142             35   279
2758075 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 241 * 33   0 *     *   *   150 137     *             26   287 241   33   0               150 137             26   287
2758076 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 302 * 55   * 6     0   *   195 176     *             47   371 302   55     6     0       195 176             47   371
2758077 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2758078 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 299 * 39   0 9     *   *   163 193     *             56   356 299   39   0 9             163 193             56   356
2758079 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   pk_12_total 484 * 50   * 16     0   19   308 274     *             87   582 484   50     16     0   19   308 274             87   582
2758080 CT     school   970011   Newtown School District   970711 Reaching Independence through Structured Education Program           2021   pk_12_total 10 * *   0 *     0   0   7 7     0             14   14 10       0       0   0   7 7     0       14   14
2758081 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 526 * 54   0 19     *   14   * 322     *             85   623 526   54   0 19         14     322             85   623
2758082 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   pk_12_total 1230 23 110   0 54     0   24   * 720     *             168   1441 1230 23 110   0 54     0   24     720             168   1441
2758083 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2021   pk_12_total 8 * *   0 0     0   0   * *     0             11   11 8       0 0     0   0           0       11   11
2778519 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2020   pk_12_total 70 * *   0 *     0   0   53 22     0             46   75 70       0       0   0   53 22     0       46   75
2778520 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 255 * 30   0 7     0   *   150 149     *             40   299 255   30   0 7     0       150 149             40   299
2778521 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 256 * 28   0 *     0   *   156 140     *             35   296 256   28   0       0       156 140             35   296
2778522 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 296 6 44   * *     0   *   188 168     *             46   356 296 6 44           0       188 168             46   356
2778523 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 311 * 36   0 10     0   *   182 187     *             66   369 311   36   0 10     0       182 187             66   369
2778524 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 474 * 38   * 20     0   16   283 277     *             78   560 474   38     20     0   16   283 277             78   560
2778525 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 578 12 52   0 20     0   18   * 347     *             97   680 578 12 52   0 20     0   18     347             97   680
2778526 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   pk_12_total 1306 24 103   0 65     0   18   770 *     *             151   1516 1306 24 103   0 65     0   18   770               151   1516
2778527 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2020   pk_12_total 13 * *   0 *     0   0   * *     0             16   16 13       0       0   0           0       16   16
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
2758060 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 255 * 80   * 11     0   19   185 186     43             66   371 255   80     11     0   19   185 186     43       66   371
2758061 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 325 14 76   0 11     0   14   224 216     21             63   440 325 14 76   0 11     0   14   224 216     21       63   440
2758062 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 521 24 135   0 21     0   33   377 357     47             124   734 521 24 135   0 21     0   33   377 357     47       124   734
2758063 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 584 35 161   0 31     0   57   436 432     32             132   868 584 35 161   0 31     0   57   436 432     32       132   868
2758064 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2021   pk_12_total 967 40 203   * 45     0   *   675 *     33             178   1294 967 40 203     45     0       675       33       178   1294
2758065 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             14   14   0     0 0     0   0           0       14   14
2778506 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 263 7 76   0 13     0   16   197 178     37             65   375 263 7 76   0 13     0   16   197 178     37       65   375
2778507 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 373 19 56   0 12     0   16   256 220     25             74   476 373 19 56   0 12     0   16   256 220     25       74   476
2778508 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 573 30 135   0 23     0   42   415 388     49             125   803 573 30 135   0 23     0   42   415 388     49       125   803
2778509 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 668 * 164   * 30     0   52   490 449     35             154   939 668   164     30     0   52   490 449     35       154   939
2778510 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   pk_12_total 1024 32 186   0 52     0   36   706 *     44             161   1330 1024 32 186   0 52     0   36   706       44       161   1330
2778511 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
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
2758051 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2021   pk_12_total 34 56 322   * *     0   29   223 221     223             50   444 34 56 322           0   29   223 221     223       50   444
2758052 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 36 40 144   * 7     *   29   140 120     52             59   260 36 40 144     7         29   140 120     52       59   260
2758053 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2021   pk_12_total 0 * *   0 0     0   0   * *     0             6   6 0       0 0     0   0           0       6   6
2758054 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 93 74 238   * *     0   82   221 273     75             78   494 93 74 238           0   82   221 273     75       78   494
2758055 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 112 79 189   * 10     *   75   252 219     71             68   471 112 79 189     10         75   252 219     71       68   471
2758056 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 26 55 230   * *     0   21   176 161     145             62   337 26 55 230           0   21   176 161     145       62   337
2758057 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Secondary 06 11 2021   pk_12_total 42 55 95   * *     *   37   99 136     27             55   235 42 55 95               37   99 136     27       55   235
2758058 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 2021   pk_12_total 98 100 182   * 9     *   77   269 201     39             76   470 98 100 182     9         77   269 201     39       76   470
2758059 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2021   pk_12_total 35 103 356   * *     *   36   311 226     169             131   537 35 103 356               36   311 226     169       131   537
2778497 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2020   pk_12_total 35 53 358   * *     0   28   242 235     217             51   477 35 53 358           0   28   242 235     217       51   477
2778498 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 39 46 164   * *     0   21   149 131     57             50   280 39 46 164           0   21   149 131     57       50   280
2778499 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             7   7   0     0 0     0               0       7   7
2778500 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 122 79 235   * 6     *   92   226 310     61             82   536 122 79 235     6         92   226 310     61       82   536
2778501 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 136 87 192   * 8     *   77   275 230     59             72   505 136 87 192     8         77   275 230     59       72   505
2778502 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 19 43 189   * *     0   11   138 128     103             43   266 19 43 189           0   11   138 128     103       43   266
2778503 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 10 2020   pk_12_total 48 40 82   * *     0   29   91 113     26             47   204 48 40 82           0   29   91 113     26       47   204
2778504 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 2020   pk_12_total 132 117 194   * 12     *   87   307 241     44             73   548 132 117 194     12         87   307 241     44       73   548
2778505 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2020   pk_12_total 36 128 352   * *     *   43   317 251     169             141   568 36 128 352               43   317 251     169       141   568
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
2758066 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 217 25 88   * 42     0   *   197 198     45             59   395 217 25 88     42     0       197 198     45       59   395

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