Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by native_hawaiian_pacific_islander descending

View and edit SQL

grade

year

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
2451950 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2019   pk_12_total 327 * 16   * 6     0   *   188 172     0             51   360 327   16     6     0       188 172     0       51   360
2451952 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 524 10 43   0 14     0   26   319 298     *             96   617 524 10 43   0 14     0   26   319 298             96   617
2451953 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2019   pk_12_total 242 * 16   * *     0   11   125 151     *             27   276 242   16           0   11   125 151             27   276
2451956 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             6   6   0 0   0 0     0               0       6   6
2451957 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2019   pk_12_total 36 74 179   0 15     0   14   176 142     0             85   318 36 74 179   0 15     0   14   176 142     0       85   318
2451958 CT     school 901260 430011   East Hartford School District 90126000191 430911 Anna E. Norris School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 11 69 206   0 10     0   12   173 135     77             60   308 11 69 206   0 10     0   12   173 135     77       60   308
2451959 CT     school 901260 430011   East Hartford School District 90126000194 430611 Dr. Franklin H. Mayberry School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 21 117 195   * *     0   14   177 184     88             57   361 21 117 195           0   14   177 184     88       57   361
2451960 CT     school 901260 430011   East Hartford School District 90126000195 432211 Dr. John A. Langford School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 31 109 199   0 8     0   6   209 144     87             65   353 31 109 199   0 8     0   6   209 144     87       65   353
2451961 CT     school 901260 430011   East Hartford School District 90126000196 431011 Dr. Thomas S. O'Connell School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 125 122 227   0 17     0   38   274 255     41             75   529 125 122 227   0 17     0   38   274 255     41       75   529
2451962 CT     school 901260 430011   East Hartford School District 90126000201 432011 Governor William Pitkin School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 52 90 131   * 34     0   *   163 161     41             49   324 52 90 131     34     0       163 161     41       49   324
2451963 CT     school 901260 430011   East Hartford School District 90126000204 430411 Joseph O. Goodwin School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 54 88 164   * *     0   29   174 179     29             52   353 54 88 164           0   29   174 179     29       52   353
2451965 CT     school 901260 430011   East Hartford School District 90126000208 431211 Silver Lane School Public Schools Regular School No Elementary KG 05 2019   pk_12_total * 89 144   * 0     0   17   126 140     36             39   266   89 144     0     0   17   126 140     36       39   266
2451966 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2019   pk_12_total 20 63 82   * *     0   9   146 32     11             *   178 20 63 82           0   9   146 32     11           178
2451968 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 46 92 152   * *     0   18   152 171     9             50   323 46 92 152           0   18   152 171     9       50   323
2451969 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2019   pk_12_total 43 59 48   * 35     0   *   83 108     6             *   191 43 59 48     35     0       83 108     6           191
2451971 CT     school 901260 430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program Alternative School No High 10 12 2019   pk_12_total * 28 50   0 0     0   *   63 31     6             21   94   28 50   0 0     0       63 31     6       21   94
2451973 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 9 55   0 9     0   12   69 90     0             7   159 74 9 55   0 9     0   12   69 90     0       7   159
2451974 CT     school 901290 440011   East Haven School District 90129000218 441011 Grove J. Tuttle School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 148 15 96   * 11     0   *   153 127     45             26   280 148 15 96     11     0       153 127     45       26   280
2451975 CT     school 901290 440011   East Haven School District 90129000219 440711 Momauguin School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 159 14 102   0 6     0   10   144 147     36             35   291 159 14 102   0 6     0   10   144 147     36       35   291
2451976 CT     school 901290 440011   East Haven School District 90129000605 441711 Carbone School/East Haven Academy Public Schools Regular School No Elementary 01 08 2019   pk_12_total 233 9 56   0 7     0   9   161 153     11             38   314 233 9 56   0 7     0   9   161 153     11       38   314
2451977 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 111 8 48   * 10     0   *   86 99     16             34   185 111 8 48     10     0       86 99     16       34   185
2451978 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 285 36 166   * 18     0   *   241 270     41             81   511 285 36 166     18     0       241 270     41       81   511
2451980 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2019   pk_12_total 49 * *   0 *     0   *   31 26     0             28   57 49       0       0       31 26     0       28   57
2451981 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 251 * 30   0 31     0   *   159 175     7             43   334 251   30   0 31     0       159 175     7       43   334
2451982 CT     school 901320 450011   East Lyme School District 90132000226 450411 Lillie B. Haynes School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 217 9 22   0 33     0   17   160 138     11             42   298 217 9 22   0 33     0   17   160 138     11       42   298
2451983 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 146 * 11   0 *     0   13   88 88     6             23   176 146   11   0       0   13   88 88     6       23   176
2451984 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 617 * 62   * 75     0   38   412 391     6             110   803 617   62     75     0   38   412 391     6       110   803
2451985 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2019   pk_12_total * 0 0   0 0     0   *   9 6     0             8   15   0 0   0 0     0       9 6     0       8   15
2451987 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2019   pk_12_total 6 * *   0 0     0   0   * *     0             8   8 6       0 0     0   0           0       8   8
2451988 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 236 58 113   * 38     0   *   240 232     33             75   472 236 58 113     38     0       240 232     33       75   472
2451989 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 180 42 77   * 11     0   *   162 157     9             63   319 180 42 77     11     0       162 157     9       63   319
2451990 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 174 47 55   0 *     0   *   168 127     7             64   295 174 47 55   0       0       168 127     7       64   295
2451991 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2451992 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2019   pk_12_total 82 6 26   * 0     0   *   94 26     *             120   120 82 6 26     0     0       94 26             120   120
2451993 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 70 * 32   * 0     0   9   30 90     *             23   120 70   32     0     0   9   30 90             23   120
2451994 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 128 6 37   * *     0   *   61 117     0             26   178 128 6 37           0       61 117     0       26   178
2451995 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2451996 CT     school 901380 390011   Eastford School District 90138000232 390111 Eastford Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 141 0 13   0 0     0   11   85 80     0             36   165 141 0 13   0 0     0   11   85 80     0       36   165
2451998 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 281 * 21   * 18     0   9   156 176     0             40   332 281   21     18     0   9   156 176     0       40   332
2452000 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2019   pk_12_total 17 0 7   0 0     0   0   * *     0             *   24 17 0 7   0 0     0   0           0           24
2452001 CT     school   2420014   EdAdvance   2420114 Steps Program           2019   pk_12_total 14 * *   0 0     0   *   16 6     0             22   22 14       0 0     0       16 6     0       22   22
2452002 CT     school   2420014   EdAdvance   2420214 Torrington Alternative Program             2019   pk_12_total 10 * *   * 0     0   *   11 6     0             *   17 10         0     0       11 6     0           17
2452003 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452004 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2019   pk_12_total * * *   0 0     0   0   * 0     0             0   *         0 0     0   0     0     0       0    
2452005 CT     school 901440 480011   Ellington School District 90144000236 480211 Crystal Lake School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 262 17 18   0 15     0   12   162 162     7             46   324 262 17 18   0 15     0   12   162 162     7       46   324
2452008 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 352 20 *   * 43     0   13   225 213     *             56   438 352 20       43     0   13   225 213             56   438
2452009 CT     school 901440 480011   Ellington School District 90144000237 486111 Ellington High School Public Schools Regular School No High 09 12 2019   pk_12_total 666 27 35   0 50     0   20   403 395     *             102   798 666 27 35   0 50     0   20   403 395             102   798
2452010 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2452011 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452012 CT     school 900216 2910013   Elm City Montessori School District 90021601683 2910113 Elm City Montessori School Public Charter Schools Regular School Yes Elementary PK 04 2019   pk_12_total 51 83 52   0 *     0   *   95 104     *             8   199 51 83 52   0       0       95 104             8   199
2452013 CT     school 901470 490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program Special Education School No Prekindergarten PK PK 2019   pk_12_total 62 * *   0 *     0   *   48 26     0             46   74 62       0       0       48 26     0       46   74
2452014 CT     school 901470 490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program Regular School No Prekindergarten PK PK 2019   pk_12_total 31 17 14   0 *     0   *   39 29     0             10   68 31 17 14   0       0       39 29     0       10   68
2452015 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2019   pk_12_total 59 6 34   0 *     0   *   56 48     0             14   104 59 6 34   0       0       56 48     0       14   104
2452016 CT     school 901470 490011   Enfield School District 90147000244 490211 Enfield Street School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 229 14 41   0 11     0   17   181 131     11             42   312 229 14 41   0 11     0   17   181 131     11       42   312
2452017 CT     school 901470 490011   Enfield School District 90147000247 490411 Hazardville Memorial School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 244 28 63   * 12     0   *   187 169     23             48   356 244 28 63     12     0       187 169     23       48   356
2452018 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452020 CT     school 901470 490011   Enfield School District 90147000242 491611 Eli Whitney School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 249 25 57   0 8     0   12   178 173     15             57   351 249 25 57   0 8     0   12   178 173     15       57   351
2452021 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2019   pk_12_total * * 0   0 0     0   0   * 0     0             *   *     0   0 0     0   0     0     0            
2452022 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 0   0 0     0   *   0 *     0             *   *   0 0   0 0     0       0       0            
2452023 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452024 CT     school 901470 490011   Enfield School District 90147000241 491311 Edgar H. Parkman School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 238 15 53   0 9     0   15   161 169     11             55   330 238 15 53   0 9     0   15   161 169     11       55   330
2452025 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452026 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452027 CT     school 901470 490011   Enfield School District 90147000254 491511 Prudence Crandall School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 265 28 77   * 16     0   *   213 186     9             62   399 265 28 77     16     0       213 186     9       62   399
2452028 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2019   pk_12_total * * *   0 *     0   0   * *     0             6   6         0       0   0           0       6   6
2452031 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2019   pk_12_total * * 0   0 *     0   0   * *     0             6   6     0   0       0   0           0       6   6
2452032 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2019   pk_12_total * * 0   0 0     0   0   6 6     0             12   12     0   0 0     0   0   6 6     0       12   12
2452033 CT     school 901500 500011   Essex School District 90150000255 500111 Essex Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 281 * 24   0 *     0   19   176 156     9             59   332 281   24   0       0   19   176 156     9       59   332
2452034 CT     school 901530 510011   Fairfield School District 90153001378 510211 Burr Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 311 * 34   * 30     0   33   216 206     15             48   422 311   34     30     0   33   216 206     15       48   422
2452035 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2019   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
2452036 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2019   pk_12_total 80 * 15   0 *     0   *   66 42     0             83   108 80   15   0       0       66 42     0       83   108
2452037 CT     school 901530 510011   Fairfield School District 90153000270 511411 Stratfield School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 336 7 51   0 17     0   21   232 200     9             39   432 336 7 51   0 17     0   21   232 200     9       39   432
2452038 CT     school 901530 510011   Fairfield School District 90153000269 511311 Sherman School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 378 * 29   * 9     0   25   214 233     8             48   447 378   29     9     0   25   214 233     8       48   447
2452039 CT     school 901530 510011   Fairfield School District 90153000257 510111 Dwight Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 245 * 16   * 15     0   12   150 148     *             32   298 245   16     15     0   12   150 148             32   298
2452040 CT     school 901530 510011   Fairfield School District 90153000260 510411 Holland Hill School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 220 13 78   0 25     0   23   180 179     28             46   359 220 13 78   0 25     0   23   180 179     28       46   359
2452041 CT     school 901530 510011   Fairfield School District 90153000261 511711 Jennings School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 222 9 29   0 14     0   21   173 122     *             45   295 222 9 29   0 14     0   21   173 122             45   295
2452042 CT     school 901530 510011   Fairfield School District 90153000262 510611 McKinley School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 195 28 144   0 44     0   27   224 214     82             49   438 195 28 144   0 44     0   27   224 214     82       49   438
2452043 CT     school 901530 510011   Fairfield School District 90153000263 510711 Mill Hill School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 280 * 18   * 23     0   19   184 162     *             51   346 280   18     23     0   19   184 162             51   346
2452044 CT     school 901530 510011   Fairfield School District 90153000264 511611 North Stratfield School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 282 9 38   0 28     0   20   186 191     7             47   377 282 9 38   0 28     0   20   186 191     7       47   377
2452045 CT     school 901530 510011   Fairfield School District 90153000609 511811 Osborn Hill School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 329 7 25   0 32     0   25   222 196     *             55   418 329 7 25   0 32     0   25   222 196             55   418
2452046 CT     school 901530 510011   Fairfield School District 90153000267 511211 Riverfield School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 339 * 27   0 20     0   *   228 178     6             43   406 339   27   0 20     0       228 178     6       43   406
2452047 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 697 24 96   0 62     0   31   457 453     10             115   910 697 24 96   0 62     0   31   457 453     10       115   910
2452048 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 711 7 55   0 32     0   25   442 388     *             99   830 711 7 55   0 32     0   25   442 388             99   830
2452049 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 449 * 113   * 53     0   33   339 323     27             88   662 449   113     53     0   33   339 323     27       88   662
2452050 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2019   pk_12_total 1243 * 130   * 94     0   45   751 782     10             171   1533 1243   130     94     0   45   751 782     10       171   1533
2452051 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2019   pk_12_total 1056 * 225   * 90     0   60   748 731     43             191   1479 1056   225     90     0   60   748 731     43       191   1479
2452052 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2019   pk_12_total * 0 *   0 0     0   0   15 8     0             *   23   0     0 0     0   0   15 8     0           23
2452053 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2019   pk_12_total 10 * *   0 *     0   0   8 7     *             15   15 10       0       0   0   8 7             15   15
2452054 CT     school   520011   Farmington School District 90156001441 528011 Farmington Collaborative PK Program           2019   pk_12_total 69 6 13   0 14     0   7   61 48     0             30   109 69 6 13   0 14     0   7   61 48     0       30   109
2452055 CT     school 901560 520011   Farmington School District 90156000276 520111 Union School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 184 14 38   0 52     0   27   156 159     10             37   315 184 14 38   0 52     0   27   156 159     10       37   315
2452056 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 206 26 37   0 132     0   26   221 206     50             35   427 206 26 37   0 132     0   26   221 206     50       35   427
2452057 CT     school 901560 520011   Farmington School District 90156000275 520211 Noah Wallace School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 205 19 31   0 82     0   17   176 178     27             28   354 205 19 31   0 82     0   17   176 178     27       28   354
2452058 CT     school 901560 520011   Farmington School District 90156000277 520311 West District School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 188 12 32   0 58     0   16   155 151     25             20   306 188 12 32   0 58     0   16   155 151     25       20   306
2452059 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2019   pk_12_total 373 41 58   * 166     0   *   346 315     19             81   661 373 41 58     166     0       346 315     19       81   661
2452060 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 405 27 54   0 156     0   13   333 322     8             78   655 405 27 54   0 156     0   13   333 322     8       78   655
2452061 CT     school 901560 520011   Farmington School District 90156000273 526111 Farmington High School Public Schools Regular School No High 09 12 2019   pk_12_total 849 62 73   * 243     0   *   629 617     14             156   1246 849 62 73     243     0       629 617     14       156   1246
2452062 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2019   pk_12_total 6 0 *   0 *     0   *   * *     *             *   9 6 0     0       0                           9
2452063 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 125 8 9   0 *     0   *   83 71     0             9   154 125 8 9   0       0       83 71     0       9   154
2452064 CT     school   540011   Glastonbury School District 90162001724 540511 PreK-Eastbury Program           2019   pk_12_total 35 * 10   0 6     0   *   43 13     0             44   56 35   10   0 6     0       43 13     0       44   56
2452065 CT     school 901620 540011   Glastonbury School District 90162000280 540211 Buttonball Lane School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 301 * 50   * 87     0   31   248 235     34             44   483 301   50     87     0   31   248 235     34       44   483

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