Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,449

grade

  • pk_12_total · 1,449
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2452513 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 213 * 28   0 *     0   9   127 128     7             42   255 213   28   0       0   9   127 128     7       42   255
2451698 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 164 * 17   0 0     0   *   101 90     *             12   191 164   17   0 0     0       101 90             12   191
2452514 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 275 13 28   * 11     0   *   174 160     8             18   334 275 13 28     11     0       174 160     8       18   334
2452515 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 272 19 31   0 43     0   15   184 196     31             53   380 272 19 31   0 43     0   15   184 196     31       53   380
2452516 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 208 * 28   * 19     0   6   142 124     11             28   266 208   28     19     0   6   142 124     11       28   266
2452517 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 297 18 36   0 26     *   *   193 195     12             41   388 297 18 36   0 26             193 195     12       41   388
2452518 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 570 25 61   * 55     0   *   380 351     10             94   731 570 25 61     55     0       380 351     10       94   731
2452519 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 38 73   * 64     *   29   528 506     11             117   1034 827 38 73     64         29   528 506     11       117   1034
2452520 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             8   8   0     0       0   0           0       8   8
2452521 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 325 6 20   * 10     *   *   188 181     0             42   369 325 6 20     10             188 181     0       42   369
2452522 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   pk_12_total 311 * 9   * 7     *   18   199 156     0             29   355 311   9     7         18   199 156     0       29   355
2452523 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 39 47 309   0 18     *   *   234 190     117             59   424 39 47 309   0 18             234 190     117       59   424
2452524 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 134 80 157   * 23     0   *   216 202     46             66   418 134 80 157     23     0       216 202     46       66   418
2452525 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 122 47 164   0 15     *   *   181 182     47             42   363 122 47 164   0 15             181 182     47       42   363
2452526 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 14 54   0 15     0   6   100 63     0             104   163 74 14 54   0 15     0   6   100 63     0       104   163
2452527 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 62 70 232   0 34     0   17   228 187     105             68   415 62 70 232   0 34     0   17   228 187     105       68   415
2452528 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 46 77 319   * 55     *   16   302 213     134             55   515 46 77 319     55         16   302 213     134       55   515
2452529 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 07 2019   pk_12_total 136 77 106   * 14     *   14   182 169     37             46   351 136 77 106     14         14   182 169     37       46   351
2452530 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 215 45 131   0 26     *   *   212 218     52             65   430 215 45 131   0 26             212 218     52       65   430
2452531 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 56 69 323   0 25     0   11   235 249     168             43   484 56 69 323   0 25     0   11   235 249     168       43   484
2452532 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 129 56 203   0 17     0   13   217 201     79             47   418 129 56 203   0 17     0   13   217 201     79       47   418
2452533 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 256 47 155   * 9     *   20   234 255     67             62   489 256 47 155     9         20   234 255     67       62   489
2452534 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 57 50 364   0 *     *   12   262 231     154             56   493 57 50 364   0           12   262 231     154       56   493
2452535 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 118 45 124   0 21     0   15   173 150     53             44   323 118 45 124   0 21     0   15   173 150     53       44   323
2452536 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 216 103 286   0 28     0   15   331 317     58             107   648 216 103 286   0 28     0   15   331 317     58       107   648
2452537 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 103 107 421   * 34     0   *   330 352     121             94   682 103 107 421     34     0       330 352     121       94   682
2452538 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 186 74 261   0 17     0   11   296 253     66             76   549 186 74 261   0 17     0   11   296 253     66       76   549
2452539 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 166 135 338   * 26     0   *   349 326     93             110   675 166 135 338     26     0       349 326     93       110   675
2452540 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2019   pk_12_total 363 300 823   0 51     0   25   807 *     213             208   1562 363 300 823   0 51     0   25   807       213       208   1562
2452541 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2019   pk_12_total 112 49 84   0 *     0   *   84 197     *             10   281 112 49 84   0       0       84 197             10   281
2452542 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2019   pk_12_total 554 330 740   * 74     *   22   912 810     184             213   1722 554 330 740     74         22   912 810     184       213   1722
2452543 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   pk_12_total 7 * *   0 0     0   0   10 7     *             17   17 7       0 0     0   0   10 7             17   17
2452544 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 61 33 54   * 15     0   *   90 85     0             74   175 61 33 54     15     0       90 85     0       74   175
2452545 CT     school   1040011   Norwich School District 90312001745 1040211 Case Street Early Learning Center at DTZ Program           2019   pk_12_total 10 18 18   * *     *   9   25 35     0             *   60 10 18 18               9   25 35     0           60
2452546 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2019   pk_12_total * * 6   0 *     0   *   6 6     *             12   12     6   0       0       6 6             12   12
2452547 CT     school 903120 1040011   Norwich School District 90312000675 1041711 Thomas W. Mahan School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 67 40 45   0 67     0   17   117 119     47             28   236 67 40 45   0 67     0   17   117 119     47       28   236
2452548 CT     school 903120 1040011   Norwich School District 90312000667 1041411 John B. Stanton School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 68 57 136   * 23     *   32   172 147     83             46   319 68 57 136     23         32   172 147     83       46   319
2452549 CT     school 903120 1040011   Norwich School District 90312000668 1042011 Moriarty Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 166 66 127   * *     0   34   210 203     75             62   413 166 66 127           0   34   210 203     75       62   413
2452550 CT     school 903120 1040011   Norwich School District 90312000672 1040811 Samuel Huntington School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 155 66 84   0 *     *   50   187 *     60             51   372 155 66 84   0           50   187       60       51   372
2452551 CT     school   1040011   Norwich School District   1040911 Stanton Special Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   6 0     0             6   6   0     0 0     0   0   6 0     0       6   6
2452552 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2019   pk_12_total 7 * 6   0 *     0   *   * *     8             21   21 7   6   0       0               8       21   21
2452553 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2019   pk_12_total * * *   0 0     0   0   * *     *             6   6         0 0     0   0                   6   6
2452554 CT     school 903120 1040011   Norwich School District 90312000676 1041911 Uncas Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 51 70 111   0 *     *   19   131 135     82             34   266 51 70 111   0           19   131 135     82       34   266
2452555 CT     school 903120 1040011   Norwich School District 90312000677 1041811 Veterans' Memorial School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 72 57 113   * 22     *   29   149 149     75             43   298 72 57 113     22         29   149 149     75       43   298
2452556 CT     school 903120 1040011   Norwich School District 90312000678 1041511 Wequonnoc Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 71 43 103   * *     *   37   139 120     52             37   259 71 43 103               37   139 120     52       37   259
2452557 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 182 109 226   0 *     *   70   316 315     84             78   631 182 109 226   0           70   316 315     84       78   631
2452558 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2452559 CT     school 903120 1040011   Norwich School District 90312000674 1045211 Teachers' Memorial Global Studies Magnet Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 102 77 137   * 26     *   40   191 194     54             99   385 102 77 137     26         40   191 194     54       99   385
2452560 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2019   pk_12_total * 8 6   0 0     0   *   13 6     0             10   19   8 6   0 0     0       13 6     0       10   19
2452561 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2019   pk_12_total 16 * *   0 *     0   *   14 9     *             23   23 16       0       0       14 9             23   23
2452562 CT     school 903180 1060011   Old Saybrook School District 90318000681 1060211 Kathleen E. Goodwin School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 238 * 49   0 10     *   16   164 153     31             33   317 238   49   0 10         16   164 153     31       33   317
2452563 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 04 08 2019   pk_12_total 383 0 48   0 15     *   *   226 232     22             65   458 383 0 48   0 15             226 232     22       65   458
2452564 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2019   pk_12_total 362 11 32   0 20     0   12   210 227     6             57   437 362 11 32   0 20     0   12   210 227     6       57   437
2452565 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2019   pk_12_total 143 * 14   0 22     0   *   86 105     9             25   191 143   14   0 22     0       86 105     9       25   191
2452566 CT     school 903210 1070011   Orange School District 90321000687 1070511 Peck Place School Public Schools Regular School No Elementary 01 06 2019   pk_12_total 255 * 14   0 48     *   16   183 157     15             22   340 255   14   0 48         16   183 157     15       22   340
2452567 CT     school 903210 1070011   Orange School District 90321000688 1070311 Race Brook School Public Schools Regular School No Elementary 01 06 2019   pk_12_total 243 * 31   * 53     0   18   196 160     27             29   356 243   31     53     0   18   196 160     27       29   356
2452568 CT     school 903210 1070011   Orange School District 90321000689 1070411 Turkey Hill School Public Schools Regular School No Elementary 01 06 2019   pk_12_total 231 0 16   * 36     0   *   152 141     13             26   293 231 0 16     36     0       152 141     13       26   293
2452569 CT     school 903240 1080011   Oxford School District 90324000002 1080311 Quaker Farms School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 313 * 34   * 10     *   *   201 164     10             40   365 313   34     10             201 164     10       40   365
2452570 CT     school 903240 1080011   Oxford School District 90324000691 1080111 Oxford Center School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 327 * 40   0 *     0   10   196 190     14             42   386 327   40   0       0   10   196 190     14       42   386
2452571 CT     school 903240 1080011   Oxford School District 90324000690 1085111 Oxford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 428 * 33   * 11     0   *   233 250     *             58   483 428   33     11     0       233 250             58   483
2452572 CT     school 903240 1080011   Oxford School District 90324001504 1086011 Oxford High School Public Schools Regular School No High 09 12 2019   pk_12_total 485 10 32   0 9     0   13   259 290     6             51   549 485 10 32   0 9     0   13   259 290     6       51   549
2452573 CT     school   1080011   Oxford School District   1080411 Connections Alternative Learning Center Program           2019   pk_12_total 6 0 0   0 0     0   0   * *     0             *   6 6 0 0   0 0     0   0           0           6
2452574 CT     school   1090011   Plainfield School District 90327001586 1098011 Early Childhood Center Program           2019   pk_12_total 11 * *   0 *     0   *   11 7     0             0   18 11       0       0       11 7     0       0   18
2452575 CT     school 903270 1090011   Plainfield School District 90327000047 1090411 Shepard Hill Elementary School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 334 14 44   * 13     *   6   224 196     14             81   420 334 14 44     13         6   224 196     14       81   420
2452576 CT     school 903270 1090011   Plainfield School District 90327000692 1090111 Moosup Elementary School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 259 10 23   0 *     *   *   139 162     *             29   301 259 10 23   0               139 162             29   301
2452577 CT     school 903270 1090011   Plainfield School District 90327000696 1090311 Plainfield Memorial School Public Schools Regular School No Elementary 04 05 2019   pk_12_total 273 12 16   * 6     *   *   155 159     9             45   314 273 12 16     6             155 159     9       45   314
2452578 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2019   pk_12_total 442 32 21   7 *     *   *   249 262     6             79   511 442 32 21   7               249 262     6       79   511
2452579 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 565 16 20   * 12     *   *   319 306     7             103   625 565 16 20     12             319 306     7       103   625
2452580 CT     school 903300 1100011   Plainville School District 90330000699 1100411 Frank T. Wheeler School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 210 15 64   * *     0   13   168 143     47             37   311 210 15 64           0   13   168 143     47       37   311
2452581 CT     school 903300 1100011   Plainville School District 90330000701 1100211 Linden Street School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 261 21 93   0 12     0   16   195 208     57             49   403 261 21 93   0 12     0   16   195 208     57       49   403
2452582 CT     school 903300 1100011   Plainville School District 90330000702 1100511 Louis Toffolon School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 296 19 54   * 8     *   14   203 190     27             55   393 296 19 54     8         14   203 190     27       55   393
2452583 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2019   pk_12_total 358 * 103   * 19     0   23   269 254     21             71   523 358   103     19     0   23   269 254     21       71   523
2452584 CT     school 903300 1100011   Plainville School District 90330000703 1106111 Plainville High School Public Schools Regular School No High 09 12 2019   pk_12_total 504 36 121   * *     0   24   371 330     18             77   701 504 36 121           0   24   371 330     18       77   701
2452585 CT     school   1100011   Plainville School District   1100111 Plainville Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2451740 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 115 120 37   * 25     0   *   170 149     0             44   319 115 120 37     25     0       170 149     0       44   319
2451741 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 19 273 28   * *     0   22   167 187     21             46   354 19 273 28           0   22   167 187     21       46   354
2451742 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2019   pk_12_total * * 0   0 0     0   *   7 0     0             7   7     0   0 0     0       7 0     0       7   7
2451743 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2019   pk_12_total 8 213 28   * *     0   10   129 134     8             45   263 8 213 28           0   10   129 134     8       45   263
2451744 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 8 207 23   0 *     *   6   123 123     *             45   246 8 207 23   0           6   123 123             45   246
2451745 CT     school 900330 110011   Bloomfield School District 90033001615 116311 Global Experience Magnet School Public Schools Regular School No High 06 12 2019   pk_12_total 44 107 39   * *     0   11   77 127     12             33   204 44 107 39           0   11   77 127     12       33   204
2451746 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 8 173 25   * *     0   13   127 96     *             45   223 8 173 25           0   13   127 96             45   223
2451747 CT     school 900330 110011   Bloomfield School District 90033000029 116111 Bloomfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 13 456 56   * *     0   17   287 260     14             97   547 13 456 56           0   17   287 260     14       97   547
2451748 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 09 12 2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2452586 CT     school 903330 1110011   Plymouth School District 90333000706 1110211 Plymouth Center School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 270 * 34   0 0     0   *   158 156     *             56   314 270   34   0 0     0       158 156             56   314
2452587 CT     school 903330 1110011   Plymouth School District 90333001521 1110411 Harry S. Fisher Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 261 * 51   0 *     0   18   180 157     8             58   337 261   51   0       0   18   180 157     8       58   337
2452588 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 24   * 10     0   6   199 155     7             64   354 308   24     10     0   6   199 155     7       64   354
2452589 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2019   pk_12_total 356 * 34   0 *     0   12   211 203     *             61   414 356   34   0       0   12   211 203             61   414
2452590 CT     school 903360 1120011   Pomfret School District 90336000709 1120111 Pomfret Community School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 338 * 19   0 15     *   *   208 171     *             38   379 338   19   0 15             208 171             38   379
2452591 CT     school 903390 1130011   Portland School District 90339000714 1130211 Valley View School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 159 * 34   0 *     0   14   115 96     12             27   211 159   34   0       0   14   115 96     12       27   211
2452592 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2019   pk_12_total 215 * 47   0 *     0   20   153 *     13             35   293 215   47   0       0   20   153       13       35   293
2452593 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 162 * 27   0 *     0   14   107 107     *             24   214 162   27   0       0   14   107 107             24   214
2452594 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 157 * 27   0 *     0   12   105 100     *             23   205 157   27   0       0   12   105 100             23   205
2452595 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2019   pk_12_total 315 16 35   * *     0   19   199 192     0             41   391 315 16 35           0   19   199 192     0       41   391
2452596 CT     school 903420 1140011   Preston School District 90342001466 1140411 Preston Veterans' Memorial School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 246 8 22   0 *     *   7   161 134     6             46   295 246 8 22   0           7   161 134     6       46   295
2452597 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2019   pk_12_total 113 * 11   * *     0   8   66 79     *             24   145 113   11           0   8   66 79             24   145
2452598 CT     school 903480 1160011   Putnam School District 90348000718 1160311 Putnam Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 506 16 83   0 7     0   31   331 312     29             104   643 506 16 83   0 7     0   31   331 312     29       104   643
2452599 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 232 * 28   0 *     *   9   150 128     7             53   278 232   28   0           9   150 128     7       53   278
2452600 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2019   pk_12_total 221 7 31   0 *     *   12   122 152     8             45   274 221 7 31   0           12   122 152     8       45   274
2452601 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   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

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