Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 4,054
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
2778624 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 230 * 31   0 *     0   11   158 123     12             53   281 230   31   0       0   11   158 123     12       53   281
2778625 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   pk_12_total 193 * 27   0 *     *   10   109 129     *             43   238 193   27   0           10   109 129             43   238
2778626 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2020   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2452602 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 384 9 47   * 10     *   13   236 229     8             90   465 384 9 47     10         13   236 229     8       90   465
2452603 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 328 * 24   0 *     0   19   201 188     *             60   389 328   24   0       0   19   201 188             60   389
2758182 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 374 13 62   * 14     *   11   230 246     10             74   476 374 13 62     14         11   230 246     10       74   476
2758183 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 271 * 27   * 10     0   14   179 149     0             48   328 271   27     10     0   14   179 149     0       48   328
2778627 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 384 * 55   0 11     *   15   233 241     12             91   474 384   55   0 11         15   233 241     12       91   474
2778628 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 298 * 27   * 9     0   16   190 168     0             60   358 298   27     9     0   16   190 168     0       60   358
2452657 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 277 * 26   0 47     0   *   191 182     15             68   373 277   26   0 47     0       191 182     15       68   373
2452658 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 303 * 23   * 20     0   12   201 159     8             59   360 303   23     20     0   12   201 159     8       59   360
2452659 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 266 * 35   0 19     0   *   177 155     8             42   332 266   35   0 19     0       177 155     8       42   332
2452660 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 288 * 23   * 24     0   15   175 178     15             33   353 288   23     24     0   15   175 178     15       33   353
2452661 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 214 * 25   0 16     *   20   138 139     12             37   277 214   25   0 16         20   138 139     12       37   277
2452662 CT     school   1180011   Ridgefield School District   1180111 District Program BMES Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452663 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 235 * 23   * 13     0   18   149 142     *             26   291 235   23     13     0   18   149 142             26   291
2452664 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             7   7   0 0   0 0     0               0       7   7
2452665 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452666 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2019   pk_12_total 6 0 0   0 0     0   0   6 0     0             6   6 6 0 0   0 0     0   0   6 0     0       6   6
2452667 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 535 0 41   0 38     0   27   329 312     *             71   641 535 0 41   0 38     0   27   329 312             71   641
2452668 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 441 7 38   0 46     0   20   285 267     0             87   552 441 7 38   0 46     0   20   285 267     0       87   552
2452669 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452670 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   11   0     0 0     0   0           0           11
2452671 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2019   pk_12_total 1353 15 103   * 107     *   37   791 827     *             160   1618 1353 15 103     107         37   791 827             160   1618
2452672 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2019   pk_12_total 11 0 *   0 *     0   0   * *     0             13   13 11 0     0       0   0           0       13   13
2758232 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 233 * 31   0 34     0   *   168 158     9             68   326 233   31   0 34     0       168 158     9       68   326
2758233 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 256 * 41   0 25     0   *   188 144     9             54   332 256   41   0 25     0       188 144     9       54   332
2758234 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 171 * 21   0 22     0   *   113 120     6             23   233 171   21   0 22     0       113 120     6       23   233
2758235 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 274 * 22   * 14     0   15   160 168     6             36   328 274   22     14     0   15   160 168     6       36   328
2758236 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 289 * 22   * 16     0   10   163 176     6             51   339 289   22     16     0   10   163 176     6       51   339
2758237 CT     school   1180011   Ridgefield School District   1180111 District Program BMES Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758238 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 239 0 21   0 12     0   16   149 139     *             28   288 239 0 21   0 12     0   16   149 139             28   288
2758239 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2021   pk_12_total 0 0 0   0 *     0   0   * *     0             *   * 0 0 0   0       0   0           0            
2758240 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758241 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2758242 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 424 * 45   0 38     *   29   285 253     *             77   538 424   45   0 38         29   285 253             77   538
2758243 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 429 * 46   * 43     0   15   280 259     *             74   539 429   46     43     0   15   280 259             74   539
2758244 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2758245 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758246 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   15   0     0 0     0   0           0           15
2758247 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2021   pk_12_total 1272 13 121   * 106     *   43   779 *     *             184   1559 1272 13 121     106         43   779               184   1559
2758248 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758249 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2778679 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 246 * 32   0 40     0   *   179 162     9             70   341 246   32   0 40     0       179 162     9       70   341
2778680 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 279 * 35   0 23     0   *   199 152     9             62   351 279   35   0 23     0       199 152     9       62   351
2778681 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 284 * 20   * 16     0   16   158 181     10             29   339 284   20     16     0   16   158 181     10       29   339
2778682 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 301 0 22   * 17     0   *   186 167     6             56   353 301 0 22     17     0       186 167     6       56   353
2778683 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2020   pk_12_total 0 0 0   0 *     0   0   * 0     0             *   * 0 0 0   0       0   0     0     0            
2778684 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778685 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 223 0 20   * *     0   15   146 125     *             23   271 223 0 20           0   15   146 125             23   271
2778686 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 197 * 28   0 19     0   *   134 130     12             27   264 197   28   0 19     0       134 130     12       27   264
2778687 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2778688 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2778689 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778690 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 460 0 39   0 35     *   *   287 271     *             72   558 460 0 39   0 35             287 271             72   558
2778691 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 450 6 44   0 39     0   19   282 276     *             81   558 450 6 44   0 39     0   19   282 276             81   558
2778692 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             9   9   0 0   0       0   0           0       9   9
2778693 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2020   pk_12_total 1306 14 115   * 114     *   43   * 801     *             162   1596 1306 14 115     114         43     801             162   1596
2778694 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   8   0     0 0     0   0           0           8
2778695 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2020   pk_12_total 12 0 *   0 0     0   *   * *     0             16   16 12 0     0 0     0               0       16   16
2452673 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 378 * 68   * 113     0   26   301 307     67             61   608 378   68     113     0   26   301 307     67       61   608
2452674 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 198 9 48   0 487     0   20   371 391     138             76   762 198 9 48   0 487     0   20   371 391     138       76   762
2452675 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 359 21 76   * 147     0   *   312 310     21             72   622 359 21 76     147     0       312 310     21       72   622
2452676 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   7   0     0 0     0   0           0           7
2452677 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2019   pk_12_total 495 36 87   * 105     0   *   373 368     10             103   741 495 36 87     105     0       373 368     10       103   741
2758250 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 224 * 47   * 76     0   19   196 181     49             49   377 224   47     76     0   19   196 181     49       49   377
2758251 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 148 9 23   * 262     *   9   215 238     78             55   453 148 9 23     262         9   215 238     78       55   453
2758252 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2021   pk_12_total 214 12 42   0 164     0   19   215 236     45             55   451 214 12 42   0 164     0   19   215 236     45       55   451
2758253 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 326 19 66   0 179     0   20   302 308     20             94   610 326 19 66   0 179     0   20   302 308     20       94   610
2758254 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2021   pk_12_total 468 30 92   * 126     0   *   353 385     9             79   738 468 30 92     126     0       353 385     9       79   738
2758255 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2021   pk_12_total * * *   0 *     0   *   8 0     0             8   8         0       0       8 0     0       8   8
2778696 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 231 * 47   * 89     0   19   202 194     44             44   396 231   47     89     0   19   202 194     44       44   396
2778697 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 141 7 23   * 312     *   10   256 241     102             52   497 141 7 23     312         10   256 241     102       52   497
2778698 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2020   pk_12_total 222 11 41   0 182     0   18   219 255     43             58   474 222 11 41   0 182     0   18   219 255     43       58   474
2778699 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 337 * 60   * 150     0   20   292 291     15             83   583 337   60     150     0   20   292 291     15       83   583
2778700 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2020   pk_12_total 479 36 92   * 116     0   *   372 371     11             89   743 479 36 92     116     0       372 371     11       89   743
2778701 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778702 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2451749 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 403 31 55   0 10     0   21   245 275     7             50   520 403 31 55   0 10     0   21   245 275     7       50   520
2451750 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2019   pk_12_total 210 16 21   0 7     0   7   141 *     0             39   261 210 16 21   0 7     0   7   141       0       39   261
2451751 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2757329 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 370 25 54   0 9     0   28   * 243     7             56   486 370 25 54   0 9     0   28     243     7       56   486
2757330 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2021   pk_12_total 207 13 29   0 7     0   6   134 128     0             26   262 207 13 29   0 7     0   6   134 128     0       26   262
2757331 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2021   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2777777 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 377 28 56   0 10     0   26   243 254     *             52   497 377 28 56   0 10     0   26   243 254             52   497
2777778 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   pk_12_total 220 12 31   0 7     0   6   146 130     0             34   276 220 12 31   0 7     0   6   146 130     0       34   276
2777779 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452678 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 350 10 24   7 7     0   15   * 216     *             59   413 350 10 24   7 7     0   15     216             59   413
2758256 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 314 * 34   6 *     0   21   190 194     *             53   384 314   34   6       0   21   190 194             53   384
2778703 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 352 7 31   * *     0   15   * 209     *             59   416 352 7 31           0   15     209             59   416
2452679 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 231 9 17   * *     0   22   137 150     9             29   287 231 9 17           0   22   137 150     9       29   287
2758257 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 245 12 28   * *     0   22   158 152     8             36   310 245 12 28           0   22   158 152     8       36   310
2778704 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 228 10 20   * *     0   22   141 143     11             29   284 228 10 20           0   22   141 143     11       29   284
2452680 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 99 0 *   0 0     0   *   46 59     0             18   105 99 0     0 0     0       46 59     0       18   105
2758258 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total * 0 *   0 0     0   0   42 46     0             20   88   0     0 0     0   0   42 46     0       20   88
2778705 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total * 0 *   0 0     0   0   48 58     0             21   106   0     0 0     0   0   48 58     0       21   106
2452681 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 372 26 104   * *     0   23   290 249     29             98   539 372 26 104           0   23   290 249     29       98   539
2452682 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 345 15 53   0 21     0   7   220 221     22             56   441 345 15 53   0 21     0   7   220 221     22       56   441
2452683 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 373 25 99   * 19     0   *   264 260     7             77   524 373 25 99     19     0       264 260     7       77   524
2452684 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2019   pk_12_total 511 35 81   * 26     0   *   318 342     9             81   660 511 35 81     26     0       318 342     9       81   660

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