Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 20,451
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
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
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
2777739 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2020   pk_12_total 144 100 381   * 36     0   *   342 356     67             79   698 144 100 381     36     0       342 356     67       79   698
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
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
2777745 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2020   pk_12_total 29 11 *   * 10     0   *   29 27     0             23   56 29 11       10     0       29 27     0       23   56
2777746 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 390 33 44   * 138     0   *   301 333     65             51   634 390 33 44     138     0       301 333     65       51   634
2777747 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 314 24 30   * 96     0   *   251 236     10             38   487 314 24 30     96     0       251 236     10       38   487
2777748 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2020   pk_12_total 306 31 39   * 105     0   *   237 265     8             57   502 306 31 39     105     0       237 265     8       57   502
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
2777750 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2020   pk_12_total 658 48 60   * 153     0   *   510 447     6             101   957 658 48 60     153     0       510 447     6       101   957
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
2777755 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 411 14 49   * *     0   16   261 242     32             60   503 411 14 49           0   16   261 242     32       60   503
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
2777758 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2020   pk_12_total 741 * 87   * 39     0   30   486 425     6             113   911 741   87     39     0   30   486 425     6       113   911
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            
2777760 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 306 * 28   * 23     0   7   174 195     13             51   369 306   28     23     0   7   174 195     13       51   369
2777761 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 307 22 113   * 52     0   *   273 247     51             79   520 307 22 113     52     0       273 247     51       79   520
2777762 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2020   pk_12_total 255 * 103   * 28     0   20   221 203     61             34   424 255   103     28     0   20   221 203     61       34   424
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
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
2777768 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 107 110 38   * 33     0   *   159 155     0             49   314 107 110 38     33     0       159 155     0       49   314
2777769 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2020   pk_12_total 9 276 44   * *     0   14   160 191     14             48   351 9 276 44           0   14   160 191     14       48   351
2777770 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2020   pk_12_total * 9 *   0 0     0   0   11 0     0             11   11   9     0 0     0   0   11 0     0       11   11
2777771 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2020   pk_12_total 7 197 35   * *     0   14   138 119     19             46   257 7 197 35           0   14   138 119     19       46   257
2777772 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 9 191 30   * *     0   8   118 123     *             56   241 9 191 30           0   8   118 123             56   241
2777773 CT     school 900330 110011   Bloomfield School District 90033001615 116311 Global Experience Magnet School Public Schools Regular School No High 06 12 2020   pk_12_total 36 85 53   * *     0   8   78 107     16             33   185 36 85 53           0   8   78 107     16       33   185
2777774 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 7 220 28   * *     0   10   134 134     *             58   268 7 220 28           0   10   134 134             58   268
2777775 CT     school 900330 110011   Bloomfield School District 90033000029 116111 Bloomfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 11 460 64   0 6     0   15   287 269     13             98   556 11 460 64   0 6     0   15   287 269     13       98   556
2777776 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   pk_12_total 0 9 0   0 0     0   0   * *     0             *   9 0 9 0   0 0     0   0           0           9
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
2777784 CT     school 900420 140011   Branford School District 90042000042 141411 Mary T. Murphy School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 232 * 64   * 48     0   21   185 200     62             44   385 232   64     48     0   21   185 200     62       44   385
2777785 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2020   pk_12_total 627 39 91   * 68     0   *   451 404     31             105   855 627 39 91     68     0       451 404     31       105   855
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
2777791 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 51 155 421   * *     0   *   356 283     182             203   639 51 155 421           0       356 283     182       203   639
2777792 CT     school 900450 150011   Bridgeport School District 90045000051 150211 Beardsley School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 16 117 168   * *     0   7   156 156     30             49   312 16 117 168           0   7   156 156     30       49   312
2777793 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 135 74 282   * 10     0   *   258 247     106             80   505 135 74 282     10     0       258 247     106       80   505
2777798 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 87 134 338   * 0     0   *   311 259     229             73   570 87 134 338     0     0       311 259     229       73   570
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
2777801 CT     school 900450 150011   Bridgeport School District 90045000066 151211 Hallen School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 25 144 115   * *     0   8   169 130     14             67   299 25 144 115           0   8   169 130     14       67   299
2777802 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 69 182 190   * 8     0   *   218 236     15             45   454 69 182 190     8     0       218 236     15       45   454
2777803 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 131 140 177   * 27     0   *   230 256     9             40   486 131 140 177     27     0       230 256     9       40   486
2777804 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 46 250 292   * 13     0   *   323 290     50             162   613 46 250 292     13     0       323 290     50       162   613
2777807 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 54 203 210   * 47     0   *   256 265     40             73   521 54 203 210     47     0       256 265     40       73   521
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
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
2777821 CT     school 900450 150011   Bridgeport School District 90045000050 156111 Bassick High School Public Schools Regular School No High 09 12 2020   pk_12_total 54 312 427   * 10     0   *   485 323     198             225   808 54 312 427     10     0       485 323     198       225   808
2777825 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2020   pk_12_total 63 117 181   * 24     0   *   275 123     16             38   398 63 117 181     24     0       275 123     16       38   398
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
2777830 CT     school 900510 170011   Bristol School District 90051000097 171411 Ellen P. Hubbell School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 174 28 154   * *     0   25   204 194     29             59   398 174 28 154           0   25   204 194     29       59   398
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
2777834 CT     school 900510 170011   Bristol School District 90051000105 171111 South Side School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 279 31 152   * *     0   16   253 239     17             61   492 279 31 152           0   16   253 239     17       61   492
2777835 CT     school 900510 170011   Bristol School District 90051000096 170311 Edgewood School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 145 * 99   * 15     0   13   150 136     20             35   286 145   99     15     0   13   150 136     20       35   286
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
2777840 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2020   pk_12_total * * *   * *     0   0   * *     0             14   14                 0   0           0       14   14
2777842 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 412 55 374   * *     0   58   456 463     83             168   919 412 55 374           0   58   456 463     83       168   919
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

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