Data source: Big Local News · About: Big Local

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

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
2451714 CT     school   2440014   Area Cooperative Educational Services   2449314 Whitney High School West             2019   pk_12_total 9 9 *   0 *     0   0   * *     *             26   26 9 9     0       0   0                   26   26
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
2451858 CT     school   2410014   Capitol Region Education Council   2411714 Soundbridge@Mountain View Elementary School             2019   pk_12_total * 0 *   0 *     0   0   * *     0             10   10   0     0       0   0           0       10   10
2451867 CT     school   2410014   Capitol Region Education Council   2411514 Soundbridge @ Chippens Hill MS Bristol             2019   pk_12_total 0 * *   0 *     0   0   * *     0             *   * 0       0       0   0           0            
2451870 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2451871 CT     school   2410014   Capitol Region Education Council   2419614 Lincoln Academy Regional Interdistrict Collaborative             2019   pk_12_total * * *   0 0     0   0   * *     0             *   7         0 0     0   0           0           7
2451885 CT     school 900810 270011   Clinton School District 90081000131 270111 Abraham Pierson School   Regular School No Elementary 04 05 2019   pk_12_total 187 * 48   * 7     0   6   130 121     24             36   251 187   48     7     0   6   130 121     24       36   251
2451892 CT     school   280011   Colchester School District   280611 School Resilience Program             2019   pk_12_total 7 0 0   0 0     0   0   * *     0             *   7 7 0 0   0 0     0   0           0           7
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
2452106 CT     school 901770 590011   Groton School District 90177000312 595311 Carl C. Cutler Middle School   Regular School No Middle 06 08 2019   pk_12_total 310 22 85   * 26     *   44   * 266     6             80   494 310 22 85     26         44     266     6       80   494
2452107 CT     school 901770 590011   Groton School District 90177000326 595211 West Side Middle School   Regular School No Middle 06 08 2019   pk_12_total 211 48 139   * 22     *   52   264 212     19             94   476 211 48 139     22         52   264 212     19       94   476
2452158 CT     school   640011   Hartford School District   640310 Pre-K Integrated - Burr School             2019   pk_12_total * 6 20   0 0     0   *   20 9     0             9   29   6 20   0 0     0       20 9     0       9   29
2452179 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   pk_12_total 0 * *   0 0     0   *   * *     *             *   * 0       0 0     0                            
2452181 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2019   pk_12_total 0 7 11   0 0     0   0   * *     *             18   18 0 7 11   0 0     0   0                   18   18
2452189 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2019   pk_12_total 0 * *   0 0     0   0   9 8     10             17   17 0       0 0     0   0   9 8     10       17   17
2452194 CT     school 901920 640011   Hartford School District 90192001574 647211 HPHS Engineering and Green Technology Academy   Regular School No High 09 12 2019   pk_12_total 13 144 198   0 11     *   *   292 78     119             81   370 13 144 198   0 11             292 78     119       81   370
2452195 CT     school 901920 640011   Hartford School District 90192001576 647411 HPHS Law and Government Academy   Regular School No High 09 12 2019   pk_12_total 6 119 192   0 *     *   *   161 163     79             67   324 6 119 192   0               161 163     79       67   324
2452196 CT     school 901920 640011   Hartford School District 90192001559 647511 HPHS Nursing and Health Sciences Academy   Regular School No High 09 12 2019   pk_12_total 11 114 202   * 15     0   *   102 242     124             58   344 11 114 202     15     0       102 242     124       58   344
2452197 CT     school 901920 640011   Hartford School District 90192001552 647611 High School, Inc.   Regular School No High 09 12 2019   pk_12_total * 81 102   * 0     0   *   95 95     35             45   190   81 102     0     0       95 95     35       45   190
2452198 CT     school 901920 640011   Hartford School District 90192001562 647711 Journalism and Media Academy   Regular School No High 09 12 2019   pk_12_total * 94 70   0 *     0   *   73 97     17             37   170   94 70   0       0       73 97     17       37   170
2452204 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2019   pk_12_total 0 6 9   0 0     0   0   8 7     *             15   15 0 6 9   0 0     0   0   8 7             15   15
2452205 CT     school 901920 640011   Hartford School District 90192001522 646011 Culinary Arts Academy at Weaver High School   Regular School No High 11 12 2019   pk_12_total 0 11 13   0 0     0   0   14 10     6             7   24 0 11 13   0 0     0   0   14 10     6       7   24
2452206 CT     school 901920 640011   Hartford School District 90192001650 643911 Capital Community College Magnet Academy   Regular School No High 12 12 2019   pk_12_total * 7 *   0 0     0   *   * *     0             *   11   7     0 0     0               0           11
2452227 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2019   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2452228 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2019   pk_12_total 42 16 65   0 *     *   21   65 81     17             28   146 42 16 65   0           21   65 81     17       28   146
2452229 CT     school   2450014   Learn   2451214 Learn ABA Program at Center School             2019   pk_12_total * * 6   0 *     0   *   * *     *             15   15     6   0       0                       15   15
2452230 CT     school   2450014   Learn   2450514 Learn Pathways Program             2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452241 CT     school 902160 720011   Ledyard School District 90216000400 720111 Ledyard Center School   Regular School No Elementary KG 06 2019   pk_12_total 277 * 36   12 13     *   23   193 181     *             58   374 277   36   12 13         23   193 181             58   374
2452252 CT     school 902280 760011   Madison School District 90228000414 760211 Island Avenue Elementary School   Regular School No Elementary KG 04 2019   pk_12_total 224 * 21   0 *     0   8   140 121     11             35   261 224   21   0       0   8   140 121     11       35   261
2452262 CT     school 902310 770011   Manchester School District 90231000431 771411 Washington School   Regular School No Elementary KG 04 2019   pk_12_total 58 74 104   * *     0   10   138 113     19             34   251 58 74 104           0   10   138 113     19       34   251
2452268 CT     school   770011   Manchester School District   771111 Elementary Site 2             2019   pk_12_total * 0 0   0 *     0   0   * *     *             0   *   0 0   0       0   0                   0    
2452295 CT     school   800011   Meriden School District   802311 SOAR - LMS             2019   pk_12_total * * 10   0 0     0   0   * *     6             16   16     10   0 0     0   0           6       16   16
2452437 CT     school   930011   New Haven School District   938011 Lulac             2019   pk_12_total * 28 85   0 0     *   0   61 56     0             8   117   28 85   0 0         0   61 56     0       8   117
2452646 CT     school 903539 2170012   Regional School District 17 90353900758 2170112 Haddam Elementary School   Regular School No Elementary KG 04 2019   pk_12_total 156 * 9   0 *     0   8   95 81     *             25   176 156   9   0       0   8   95 81             25   176
2452750 CT     school   1340011   Stafford School District   1340211 Stafford Tutoring Program             2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   7   0 0   0 0     0               0           7
2452778 CT     school 904380 1370011   Stonington School District 90438001637 1370111 Stonington BOE Pre-School   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 *     0   0   15 11     0             16   26 22 0     0       0   0   15 11     0       16   26
2452779 CT     school 904380 1370011   Stonington School District 90438001635 1370211 Stonington HS PreK   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 0     0   *   17 9     0             17   26 22 0     0 0     0       17 9     0       17   26
2452782 CT     school 904380 1370011   Stonington School District 90438000882 1370411 West Broad Street School   Regular School No Elementary 03 04 2019   pk_12_total 90 * 6   * *     0   10   50 61     *             20   111 90   6           0   10   50 61             20   111
2452783 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   pk_12_total 244 * 24   * *     0   8   158 124     0             55   282 244   24           0   8   158 124     0       55   282
2452826 CT     school   1430011   Torrington School District   1432211 East TPS - PreK - Reg Ed             2019   pk_12_total 12 * 30   0 *     0   0   26 18     0             *   44 12   30   0       0   0   26 18     0           44
2452856 CT     school   1460011   Vernon School District   1460911 First Step             2019   pk_12_total * * *   0 *     0   0   * *     0             8   8         0       0   0           0       8   8
2452874 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   pk_12_total 16 0 *   0 0     0   *   * *     0             21   21 16 0     0 0     0               0       21   21
2452878 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   pk_12_total 14 0 6   0 0     0   0   13 7     *             *   20 14 0 6   0 0     0   0   13 7                 20
2452913 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452919 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452956 CT     school   1530011   Watertown School District   1530711 Watertown Transition Program at Post University             2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2452988 CT     school   1560011   West Haven School District   1561111 ASD Lab             2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2453044 CT     school 905190 1630011   Windham School District 90519001920 1631311 Windham STEPS Academy   Alternative School No High 09 12 2019   pk_12_total * * 26   0 0     0   *   20 14     14             9   34     26   0 0     0       20 14     14       9   34
2453086 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   pk_12_total * 63 58   0 *     0   *   70 57     14             33   127   63 58   0       0       70 57     14       33   127
2453142 CT     school   2190012   Regional School District 19   2190212 PM Panthers             2019   pk_12_total 14 0 *   0 0     0   *   * *     *             6   17 14 0     0 0     0                       6   17
2453144 CT     school 900031 2820013   Stamford Academy District 90003101405 2826013 Stamford Academy   Regular School Yes High 09 12 2019   pk_12_total 9 70 66   0 *     0   *   84 68     9             54   152 9 70 66   0       0       84 68     9       54   152
2453118 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 32 177 444   * 13     *   *   339 338     71             64   677 32 177 444     13             339 338     71       64   677
2453119 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 30 213 488   * *     0   20   362 398     53             35   760 30 213 488           0   20   362 398     53       35   760
2453120 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 179 44 390   * *     0   21   369 *     33             48   647 179 44 390           0   21   369       33       48   647
2453121 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 66 215 288   * 7     *   14   304 289     46             93   593 66 215 288     7         14   304 289     46       93   593
2453122 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 246 35 162   * 7     *   34   299 192     17             82   491 246 35 162     7         34   299 192     17       82   491
2453123 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 350 50 179   0 *     *   21   349 258     13             75   607 350 50 179   0           21   349 258     13       75   607
2453124 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 341 45 335   * *     0   27   441 322     20             62   763 341 45 335           0   27   441 322     20       62   763
2453125 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 590 * 39   * 6     0   16   469 188     *             58   657 590   39     6     0   16   469 188             58   657
2453126 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 300 25 320   0 8     0   19   385 287     29             71   672 300 25 320   0 8     0   19   385 287     29       71   672
2453127 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 342 70 169   0 18     0   32   486 145     14             62   631 342 70 169   0 18     0   32   486 145     14       62   631
2453128 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 83 77 250   0 *     0   *   235 186     22             53   421 83 77 250   0       0       235 186     22       53   421
2453129 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 426 43 111   * *     0   49   369 272     11             52   641 426 43 111           0   49   369 272     11       52   641
2453130 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 524 12 73   0 *     *   23   399 238     *             78   637 524 12 73   0           23   399 238             78   637
2453131 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 322 111 325   * *     0   35   514 294     19             95   808 322 111 325           0   35   514 294     19       95   808
2453132 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 280 33 64   * *     *   27   285 122     6             55   407 280 33 64               27   285 122     6       55   407
2453133 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 288 97 334   * 25     *   37   444 343     26             61   787 288 97 334     25         37   444 343     26       61   787
2453134 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 253 6 181   * *     0   6   287 161     21             53   448 253 6 181           0   6   287 161     21       53   448
2453105 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   pk_12_total 348 8 82   0 50     0   23   275 *     16             74   511 348 8 82   0 50     0   23   275       16       74   511
2453136 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 1123 330 366   22 174     22   197   1084 1150     187             247   2234 1123 330 366   22 174     22   197   1084 1150     187       247   2234
2453145 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 925 * 26   * 124     0   11   545 553     0             74   1098 925   26     124     0   11   545 553     0       74   1098
2451699 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2019   pk_12_total 27 16 43   0 *     0   *   58 36     0             18   94 27 16 43   0       0       58 36     0       18   94
2451704 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2019   pk_12_total * 8 15   0 0     0   *   18 9     0             *   27   8 15   0 0     0       18 9     0           27
2451705 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2019   pk_12_total * * *   0 0     0   0   0 6     0             *   6         0 0     0   0   0 6     0           6
2451706 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2019   pk_12_total 54 46 28   * 6     *   *   102 37     0             139   139 54 46 28     6             102 37     0       139   139
2451707 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2019   pk_12_total * 16 14   0 0     0   *   33 8     *             41   41   16 14   0 0     0       33 8             41   41
2451709 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2019   pk_12_total 20 68 40   0 0     0   6   107 27     *             *   134 20 68 40   0 0     0   6   107 27                 134
2451711 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2019   pk_12_total 26 8 *   0 *     0   *   30 10     0             40   40 26 8     0       0       30 10     0       40   40
2451712 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2019   pk_12_total 27 19 22   0 *     0   *   54 17     0             71   71 27 19 22   0       0       54 17     0       71   71
2451713 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2019   pk_12_total 13 50 28   0 0     *   *   70 28     *             98   98 13 50 28   0 0             70 28             98   98
2451715 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2019   pk_12_total 20 * 18   0 0     0   *   39 13     *             52   52 20   18   0 0     0       39 13             52   52
2451717 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   pk_12_total 31 10 *   0 10     0   *   34 24     0             24   58 31 10     0 10     0       34 24     0       24   58
2451724 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   pk_12_total 17 0 0   0 0     0   0   9 8     0             8   17 17 0 0   0 0     0   0   9 8     0       8   17
2451725 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2451731 CT     school   70011   Berlin School District   70311 Transition Academy Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2451738 CT     school   90011   Bethel School District   90311 TASK Program           2019   pk_12_total * 0 *   0 *     0   *   * *     *             *   12   0     0       0                           12
2451739 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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
2451751 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2451753 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2019   pk_12_total 27 * 12   0 *     0   *   25 20     0             22   45 27   12   0       0       25 20     0       22   45
2451759 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2019   pk_12_total 35 * *   0 0     0   0   22 18     0             11   40 35       0 0     0   0   22 18     0       11   40
2451785 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2019   pk_12_total * 37 32   0 *     0   0   64 9     *             *   73   37 32   0       0   0   64 9                 73
2451798 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2019   pk_12_total * 16 *   0 0     0   0   19 8     *             27   27   16     0 0     0   0   19 8             27   27
2451799 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2019   pk_12_total * * *   0 *     0   *   * *     0             7   7         0       0               0       7   7
2451807 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2019   pk_12_total 0 0 *   0 0     0   *   * *     0             *   * 0 0     0 0     0               0            
2451808 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2019   pk_12_total * 0 8   0 0     0   *   * *     *             12   12   0 8   0 0     0                       12   12
2451809 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2019   pk_12_total * * *   0 *     0   0   * *     0             10   10         0       0   0           0       10   10
2451812 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2451813 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2451814 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6

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