Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by native_american_alaskan_native descending

View and edit SQL

grade

year

  • 2020 · 20,454
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
2777795 CT     school 900450 150011   Bridgeport School District 90045000054 150411 Bryant School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 45 130 131   9 14     *   *   172 160     85             66   332 45 130 131   9 14             172 160     85       66   332
2778603 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2020   pk_12_total 441 27 24   9 6     *   *   265 252     7             75   517 441 27 24   9 6             265 252     7       75   517
2778961 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2020   pk_12_total 150 293 654   8 19     0   14   607 531     188             309   1138 150 293 654   8 19     0   14   607 531     188       309   1138
2779160 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 2020   pk_12_total 250 27 193   8 *     *   50   341 195     21             98   536 250 27 193   8           50   341 195     21       98   536
2777763 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2020   pk_12_total 299 12 95   7 30     0   23   254 212     33             63   466 299 12 95   7 30     0   23   254 212     33       63   466
2777764 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 518 23 184   7 52     0   22   402 404     27             82   806 518 23 184   7 52     0   22   402 404     27       82   806
2778916 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 102 164 350   7 19     0   26   369 299     102             77   668 102 164 350   7 19     0   26   369 299     102       77   668
2778925 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2020   pk_12_total 174 193 382   7 27     0   22   339 466     33             58   805 174 193 382   7 27     0   22   339 466     33       58   805
2778952 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 81 208 560   7 6     0   38   449 451     89             167   900 81 208 560   7 6     0   38   449 451     89       167   900
2778542 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 377 8 21   6 11     *   *   217 210     0             42   427 377 8 21   6 11             217 210     0       42   427
2779100 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 842 299   6 *     *   15   553 616     70             117   1169   842 299   6           15   553 616     70       117   1169
2778264 CT     school 902160 720011   Ledyard School District 90216000398 720411 Gallup Hill School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 430 14 66   31 *     *   29   319 267     9             111   586 430 14 66   31           29   319 267     9       111   586
2779174 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2020   pk_12_total 1173 330 390   26 180     10   132   1078 1163     212             248   2241 1173 330 390   26 180     10   132   1078 1163     212       248   2241
2777817 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 107 44 281   24 6     *   *   205 262     127             43   467 107 44 281   24 6             205 262     127       43   467
2778267 CT     school 902160 720011   Ledyard School District 90216000402 725111 Ledyard Middle School Public Schools Regular School No Middle 06 10 2020   pk_12_total 390 22 54   16 *     *   46   285 259     *             108   544 390 22 54   16           46   285 259             108   544
2777824 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2020   pk_12_total 223 594 683   15 47     *   *   742 835     246             242   1577 223 594 683   15 47             742 835     246       242   1577
2778945 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   pk_12_total 139 266 645   12 25     0   38   561 564     133             194   1125 139 266 645   12 25     0   38   561 564     133       194   1125
2778946 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 151 217 497   12 19     0   43   456 483     97             161   939 151 217 497   12 19     0   43   456 483     97       161   939
2777794 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 182 276 551   10 38     *   *   589 481     282             141   1070 182 276 551   10 38             589 481     282       141   1070
2777800 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 68 197 468   10 21     0   14   413 365     243             156   778 68 197 468   10 21     0   14   413 365     243       156   778
2778246 CT     school 902070 690011   Killingly School District 90207000392 696111 Killingly High School Public Schools Regular School No High 09 12 2020   pk_12_total 633 20 62   10 19     0   37   * 414     *             125   781 633 20 62   10 19     0   37     414             125   781
2778962 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2020   pk_12_total 206 247 670   10 18     0   18   628 541     204             245   1169 206 247 670   10 18     0   18   628 541     204       245   1169
2777725 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 158 * 24   0 0     0   *   99 96     *             21   195 158   24   0 0     0       99 96             21   195
2777726 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2020   pk_12_total 32 16 41   0 *     0   *   58 35     0             30   93 32 16 41   0       0       58 35     0       30   93
2777727 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 138 116 317   0 *     *   41   312 308     41             115   620 138 116 317   0           41   312 308     41       115   620
2777728 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 212 99 261   0 16     0   51   338 301     38             113   639 212 99 261   0 16     0   51   338 301     38       113   639
2777729 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 108 74 148   0 6     0   20   189 167     10             73   356 108 74 148   0 6     0   20   189 167     10       73   356
2777731 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2020   pk_12_total * 10 13   0 0     0   *   17 12     0             6   29   10 13   0 0     0       17 12     0       6   29
2777732 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2777733 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2777735 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2020   pk_12_total * 44 22   0 0     0   *   71 15     *             *   86   44 22   0 0     0       71 15                 86
2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2777738 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2020   pk_12_total 15 46 34   0 0     0   7   85 17     0             95   102 15 46 34   0 0     0   7   85 17     0       95   102
2777740 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2020   pk_12_total 25 7 *   0 *     0   *   30 10     0             40   40 25 7     0       0       30 10     0       40   40
2777741 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2020   pk_12_total 43 22 30   0 *     0   *   75 25     *             100   100 43 22 30   0       0       75 25             100   100
2777742 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2020   pk_12_total 13 54 25   0 0     *   *   77 24     *             101   101 13 54 25   0 0             77 24             101   101
2777743 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2020   pk_12_total 20 16 21   0 *     0   *   41 19     *             60   60 20 16 21   0       0       41 19             60   60
2777744 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 330 7 31   0 *     *   17   204 186     6             52   390 330 7 31   0           17   204 186     6       52   390
2777749 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 325 26 36   0 123     0   16   248 278     7             54   526 325 26 36   0 123     0   16   248 278     7       54   526
2777751 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 183 * *   0 *     0   9   94 103     0             48   197 183       0       0   9   94 103     0       48   197
2777752 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2020   pk_12_total 17 0 0   0 0     0   0   10 7     0             6   17 17 0 0   0 0     0   0   10 7     0       6   17
2777753 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2777754 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 361 9 55   0 16     0   19   236 224     13             85   460 361 9 55   0 16     0   19   236 224     13       85   460
2777756 CT     school 900210 70011   Berlin School District 90021000021 70111 Richard D. Hubbard School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 156 * 28   0 16     0   *   97 116     29             30   213 156   28   0 16     0       97 116     29       30   213
2777757 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 503 18 82   0 21     0   20   321 323     12             109   644 503 18 82   0 21     0   20   321 323     12       109   644
2777759 CT     school   70011   Berlin School District   70311 Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777766 CT     school   90011   Bethel School District   90311 TASK Program           2020   pk_12_total 6 0 *   0 *     0   *   * *     *             *   12 6 0     0       0                           12
2777767 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2777770 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2020   pk_12_total * 9 *   0 0     0   0   11 0     0             11   11   9     0 0     0   0   11 0     0       11   11
2777775 CT     school 900330 110011   Bloomfield School District 90033000029 116111 Bloomfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 11 460 64   0 6     0   15   287 269     13             98   556 11 460 64   0 6     0   15   287 269     13       98   556
2777776 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   pk_12_total 0 9 0   0 0     0   0   * *     0             *   9 0 9 0   0 0     0   0           0           9
2777777 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 377 28 56   0 10     0   26   243 254     *             52   497 377 28 56   0 10     0   26   243 254             52   497
2777778 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   pk_12_total 220 12 31   0 7     0   6   146 130     0             34   276 220 12 31   0 7     0   6   146 130     0       34   276
2777779 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2777780 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 146 * 20   0 0     0   *   101 84     *             28   185 146   20   0 0     0       101 84             28   185
2777781 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2020   pk_12_total 33 * 10   0 *     0   *   29 21     0             27   50 33   10   0       0       29 21     0       27   50
2777782 CT     school 900420 140011   Branford School District 90042001119 141611 John B. Sliney School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 197 13 49   0 8     0   24   138 153     27             36   291 197 13 49   0 8     0   24   138 153     27       36   291
2777783 CT     school 900420 140011   Branford School District 90042000043 141511 Mary R. Tisko School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 299 10 32   0 14     0   10   188 177     16             34   365 299 10 32   0 14     0   10   188 177     16       34   365
2777786 CT     school 900420 140011   Branford School District 90042000039 146111 Branford High School Public Schools Regular School No High 09 12 2020   pk_12_total 607 22 94   0 60     0   21   * 404     15             104   804 607 22 94   0 60     0   21     404     15       104   804
2777787 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2020   pk_12_total 20 * *   0 0     0   0   18 9     0             *   27 20       0 0     0   0   18 9     0           27
2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
2777789 CT     school 900215 2900013   Brass City Charter School District 90021501644 2900113 Brass City Charter School Public Charter Schools Regular School Yes Elementary PK 07 2020   pk_12_total 30 114 152   0 8     0   22   152 174     18             27   326 30 114 152   0 8     0   22   152 174     18       27   326
2777790 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 36 46 121   0 *     0   *   141 69     0             137   210 36 46 121   0       0       141 69     0       137   210
2777808 CT     school 900450 150011   Bridgeport School District 90045001161 154111 Paul Laurence Dunbar School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 15 128 156   0 *     0   *   148 161     35             52   309 15 128 156   0       0       148 161     35       52   309
2777814 CT     school 900450 150011   Bridgeport School District 90045000065 151111 Hall School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 18 93 62   0 *     0   *   80 100     9             31   180 18 93 62   0       0       80 100     9       31   180
2777816 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 96 135 196   0 *     *   9   254 191     118             87   445 96 135 196   0           9   254 191     118       87   445
2777818 CT     school 900450 150011   Bridgeport School District 90045000059 153911 Wilbur Cross School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 33 125 127   0 *     0   *   160 129     25             56   289 33 125 127   0       0       160 129     25       56   289
2777819 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2020   pk_12_total 0 44 *   0 *     0   0   67 9     7             *   76 0 44     0       0   0   67 9     7           76
2777827 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2020   pk_12_total 0 16 *   0 *     0   0   22 6     *             28   28 0 16     0       0   0   22 6             28   28
2777828 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             6   6   0     0 0     0               0       6   6
2777829 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total 68 0 31   0 *     0   *   75 38     0             70   113 68 0 31   0       0       75 38     0       70   113
2777832 CT     school 900510 170011   Bristol School District 90051000099 171911 Ivy Drive School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 231 29 78   0 7     0   19   171 193     13             65   364 231 29 78   0 7     0   19   171 193     13       65   364
2777833 CT     school 900510 170011   Bristol School District 90051000103 171711 Mountain View School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 202 17 86   0 17     0   16   172 166     23             42   338 202 17 86   0 17     0   16   172 166     23       42   338
2777836 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             6   6   0     0       0   0                   6   6
2777837 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777841 CT     school 900510 170011   Bristol School District 90051000106 171211 Stafford School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 178 35 123   0 *     *   15   161 200     16             65   361 178 35 123   0           15   161 200     16       65   361
2777843 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2020   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2777845 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2020   pk_12_total * * *   0 0     0   *   7 0     *             7   7         0 0     0       7 0             7   7
2777846 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2020   pk_12_total 12 * *   0 0     0   0   18 6     *             24   24 12       0 0     0   0   18 6             24   24
2777847 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2020   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2777848 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777849 CT     school   170011   Bristol School District   173611 West bristol Extended Resource Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2777850 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 350 60 249   0 34     0   27   347 373     46             119   720 350 60 249   0 34     0   27   347 373     46       119   720
2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777852 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777853 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2020   pk_12_total * 0 8   0 *     0   0   7 7     *             14   14   0 8   0       0   0   7 7             14   14
2777854 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2777855 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2020   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2777856 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2777857 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2777858 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 281 37 106   0 24     0   21   237 232     15             81   469 281 37 106   0 24     0   21   237 232     15       81   469
2777861 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   pk_12_total 26 * 11   0 0     0   *   32 8     0             0   40 26   11   0 0     0       32 8     0       0   40
2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2777863 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2020   pk_12_total 17 * *   0 0     0   *   13 11     *             24   24 17       0 0     0       13 11             24   24
2777869 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 268 * 34   0 11     *   20   184 156     *             56   340 268   34   0 11         20   184 156             56   340
2777870 CT     school 900660 220011   Canterbury School District 90066001188 220211 Canterbury Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 263 * 18   0 *     0   *   153 139     0             35   292 263   18   0       0       153 139     0       35   292
2777872 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 392 17 32   0 *     *   20   258 211     6             52   469 392 17 32   0           20   258 211     6       52   469

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