Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by district_state_id

View and edit SQL

year

  • 2020 · 1,428

grade

  • pk_12_total · 1,428
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
2778566 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2020   pk_12_total * 7 *   0 0     0   0   8 6     *             14   14   7     0 0     0   0   8 6             14   14
2778567 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778568 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 54 34 66   * 10     *   12   97 81     0             61   178 54 34 66     10         12   97 81     0       61   178
2778569 CT     school   1040011   Norwich School District 90312001745 1040211 Case Street Early Learning Center at DTZ Program           2020   pk_12_total * 23 21   0 *     0   9   29 34     0             *   63   23 21   0       0   9   29 34     0           63
2778570 CT     school 903120 1040011   Norwich School District 90312000675 1041711 Thomas W. Mahan School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 77 36 41   0 71     0   17   128 114     53             32   242 77 36 41   0 71     0   17   128 114     53       32   242
2778571 CT     school 903120 1040011   Norwich School District 90312000667 1041411 John B. Stanton School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 63 54 137   * 20     *   33   158 153     90             54   311 63 54 137     20         33   158 153     90       54   311
2778572 CT     school 903120 1040011   Norwich School District 90312000668 1042011 Moriarty Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 162 56 133   0 19     0   27   196 201     73             53   397 162 56 133   0 19     0   27   196 201     73       53   397
2778573 CT     school 903120 1040011   Norwich School District 90312000672 1040811 Samuel Huntington School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 144 70 95   0 *     *   47   190 *     53             41   376 144 70 95   0           47   190       53       41   376
2778574 CT     school 903120 1040011   Norwich School District 90312000676 1041911 Uncas Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 52 63 108   0 *     *   23   133 125     74             40   258 52 63 108   0           23   133 125     74       40   258
2778575 CT     school 903120 1040011   Norwich School District 90312000677 1041811 Veterans' Memorial School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 83 57 107   * 15     *   32   151 147     71             34   298 83 57 107     15         32   151 147     71       34   298
2778576 CT     school 903120 1040011   Norwich School District 90312000678 1041511 Wequonnoc Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 67 50 103   * *     *   38   132 132     53             40   264 67 50 103               38   132 132     53       40   264
2778577 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             8   8   0     0       0   0                   8   8
2778578 CT     school   1040011   Norwich School District   1040911 Stanton Special Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778579 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2020   pk_12_total * * *   0 *     0   0   * *     *             11   11         0       0   0                   11   11
2778580 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             *   * 0       0 0     0   0                        
2778581 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 180 115 239   * 31     *   70   324 314     86             72   638 180 115 239     31         70   324 314     86       72   638
2778582 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2778583 CT     school 903120 1040011   Norwich School District 90312000674 1045211 Teachers' Memorial Global Studies Magnet Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 104 71 143   * 25     *   44   202 194     66             100   396 104 71 143     25         44   202 194     66       100   396
2778584 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   7   0     0 0     0   0                       7
2778585 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2020   pk_12_total 11 * *   0 *     0   *   14 9     *             23   23 11       0       0       14 9             23   23
2778586 CT     school 903180 1060011   Old Saybrook School District 90318000681 1060211 Kathleen E. Goodwin School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 294 * 69   0 12     *   16   215 181     41             51   396 294   69   0 12         16   215 181     41       51   396
2778587 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 308 0 40   0 13     *   *   183 187     14             58   370 308 0 40   0 13             183 187     14       58   370
2778588 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2020   pk_12_total 349 9 40   0 18     0   9   214 211     13             61   425 349 9 40   0 18     0   9   214 211     13       61   425
2778589 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2020   pk_12_total 175 * 17   0 28     0   *   130 106     11             32   236 175   17   0 28     0       130 106     11       32   236
2778590 CT     school 903210 1070011   Orange School District 90321000687 1070511 Peck Place School Public Schools Regular School No Elementary 01 06 2020   pk_12_total 241 * 20   0 48     *   17   175 157     19             27   332 241   20   0 48         17   175 157     19       27   332
2778591 CT     school 903210 1070011   Orange School District 90321000688 1070311 Race Brook School Public Schools Regular School No Elementary 01 06 2020   pk_12_total 247 * 31   * 61     0   15   189 178     28             26   367 247   31     61     0   15   189 178     28       26   367
2778592 CT     school 903210 1070011   Orange School District 90321000689 1070411 Turkey Hill School Public Schools Regular School No Elementary 01 06 2020   pk_12_total 234 * 17   0 33     0   *   152 147     13             31   299 234   17   0 33     0       152 147     13       31   299
2778593 CT     school 903240 1080011   Oxford School District 90324000002 1080311 Quaker Farms School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 289 6 36   * 13     *   *   196 153     18             41   349 289 6 36     13             196 153     18       41   349
2778594 CT     school 903240 1080011   Oxford School District 90324000691 1080111 Oxford Center School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 326 * 36   0 *     0   8   192 188     18             47   380 326   36   0       0   8   192 188     18       47   380
2778595 CT     school 903240 1080011   Oxford School District 90324000690 1085111 Oxford Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 381 7 42   * 10     0   *   218 228     7             55   446 381 7 42     10     0       218 228     7       55   446
2778596 CT     school 903240 1080011   Oxford School District 90324001504 1086011 Oxford High School Public Schools Regular School No High 09 12 2020   pk_12_total 460 * 35   * 11     0   9   244 280     6             41   524 460   35     11     0   9   244 280     6       41   524
2778597 CT     school   1080011   Oxford School District   1080411 Connections Alternative Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   11   0     0 0     0   0           0           11
2778598 CT     school   1080011   Oxford School District   1080511 Community Explorations Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778599 CT     school   1090011   Plainfield School District 90327001586 1098011 Early Childhood Center Program           2020   pk_12_total 12 * *   0 *     0   *   7 11     0             *   18 12       0       0       7 11     0           18
2778600 CT     school 903270 1090011   Plainfield School District 90327000047 1090411 Shepard Hill Elementary School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 358 14 36   * 8     *   10   232 200     9             89   432 358 14 36     8         10   232 200     9       89   432
2778601 CT     school 903270 1090011   Plainfield School District 90327000692 1090111 Moosup Elementary School Public Schools Regular School No Elementary KG 03 2020   pk_12_total 259 13 22   * *     *   *   147 158     6             34   305 259 13 22                   147 158     6       34   305
2778602 CT     school 903270 1090011   Plainfield School District 90327000696 1090311 Plainfield Memorial School Public Schools Regular School No Elementary 04 05 2020   pk_12_total 247 13 29   * 6     *   0   144 156     8             42   300 247 13 29     6         0   144 156     8       42   300
2778603 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2020   pk_12_total 441 27 24   9 6     *   *   265 252     7             75   517 441 27 24   9 6             265 252     7       75   517
2778604 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 526 21 24   * 6     *   6   285 305     *             109   590 526 21 24     6         6   285 305             109   590
2778605 CT     school 903300 1100011   Plainville School District 90330000699 1100411 Frank T. Wheeler School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 205 16 66   * *     0   15   178 131     42             44   309 205 16 66           0   15   178 131     42       44   309
2778606 CT     school 903300 1100011   Plainville School District 90330000701 1100211 Linden Street School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 266 17 105   0 8     0   17   208 205     53             55   413 266 17 105   0 8     0   17   208 205     53       55   413
2778607 CT     school 903300 1100011   Plainville School District 90330000702 1100511 Louis Toffolon School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 291 22 56   0 *     *   16   203 194     21             49   397 291 22 56   0           16   203 194     21       49   397
2778608 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2020   pk_12_total 352 21 121   * *     0   26   270 272     26             77   542 352 21 121           0   26   270 272     26       77   542
2778609 CT     school 903300 1100011   Plainville School District 90330000703 1106111 Plainville High School Public Schools Regular School No High 09 12 2020   pk_12_total 480 29 118   * *     0   34   369 310     23             84   679 480 29 118           0   34   369 310     23       84   679
2778610 CT     school   1100011   Plainville School District   1100111 Plainville Transition Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2777768 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 107 110 38   * 33     0   *   159 155     0             49   314 107 110 38     33     0       159 155     0       49   314
2777769 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2020   pk_12_total 9 276 44   * *     0   14   160 191     14             48   351 9 276 44           0   14   160 191     14       48   351
2777770 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2020   pk_12_total * 9 *   0 0     0   0   11 0     0             11   11   9     0 0     0   0   11 0     0       11   11
2777771 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2020   pk_12_total 7 197 35   * *     0   14   138 119     19             46   257 7 197 35           0   14   138 119     19       46   257
2777772 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 9 191 30   * *     0   8   118 123     *             56   241 9 191 30           0   8   118 123             56   241
2777773 CT     school 900330 110011   Bloomfield School District 90033001615 116311 Global Experience Magnet School Public Schools Regular School No High 06 12 2020   pk_12_total 36 85 53   * *     0   8   78 107     16             33   185 36 85 53           0   8   78 107     16       33   185
2777774 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 7 220 28   * *     0   10   134 134     *             58   268 7 220 28           0   10   134 134             58   268
2777775 CT     school 900330 110011   Bloomfield School District 90033000029 116111 Bloomfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 11 460 64   0 6     0   15   287 269     13             98   556 11 460 64   0 6     0   15   287 269     13       98   556
2777776 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   pk_12_total 0 9 0   0 0     0   0   * *     0             *   9 0 9 0   0 0     0   0           0           9
2778611 CT     school 903330 1110011   Plymouth School District 90333000706 1110211 Plymouth Center School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 258 * 32   0 *     0   14   158 149     *             50   307 258   32   0       0   14   158 149             50   307
2778612 CT     school 903330 1110011   Plymouth School District 90333001521 1110411 Harry S. Fisher Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 234 * 57   0 *     0   20   175 143     8             61   318 234   57   0       0   20   175 143     8       61   318
2778613 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 300 * 41   * *     0   9   191 168     *             70   359 300   41           0   9   191 168             70   359
2778614 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2020   pk_12_total 313 7 33   0 11     0   10   185 189     *             59   374 313 7 33   0 11     0   10   185 189             59   374
2778615 CT     school 903360 1120011   Pomfret School District 90336000709 1120111 Pomfret Community School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 358 * 6   0 9     *   *   209 173     0             36   382 358   6   0 9             209 173     0       36   382
2778616 CT     school 903390 1130011   Portland School District 90339000714 1130211 Valley View School Public Schools Regular School No Elementary PK 01 2020   pk_12_total 173 * 38   0 *     0   14   125 *     14             33   232 173   38   0       0   14   125       14       33   232
2778617 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2020   pk_12_total 219 * 57   0 8     *   11   153 149     20             39   302 219   57   0 8         11   153 149     20       39   302
2778618 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 138 10 29   0 *     *   13   107 *     *             30   193 138 10 29   0           13   107               30   193
2778619 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 150 * 30   0 *     0   10   101 101     *             23   202 150   30   0       0   10   101 101             23   202
2778620 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2020   pk_12_total 301 13 32   * *     0   19   185 *     *             47   371 301 13 32           0   19   185               47   371
2778621 CT     school 903420 1140011   Preston School District 90342001466 1140411 Preston Veterans' Memorial School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 242 * 26   0 6     *   7   155 131     10             43   286 242   26   0 6         7   155 131     10       43   286
2778622 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2020   pk_12_total 122 * 7   * *     0   9   72 75     *             29   147 122   7           0   9   72 75             29   147
2778623 CT     school 903480 1160011   Putnam School District 90348000718 1160311 Putnam Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 478 12 95   0 *     *   43   328 307     30             106   635 478 12 95   0           43   328 307     30       106   635
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
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
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
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            
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            
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

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