Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

Link rowid ▲ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2778985 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 118 48 107   0 61     0   7   178 163     62             37   341 118 48 107   0 61     0   7   178 163     62       37   341
2778984 CT     school 904920 1550011   West Hartford School District 90492001012 1550511 Charter Oak International Academy Public Schools Regular School No Elementary PK 05 2020   pk_12_total 164 59 209   * 72     *   29   259 280     50             41   539 164 59 209     72         29   259 280     50       41   539
2778983 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 252 38 56   * 66     0   *   202 230     49             53   432 252 38 56     66     0       202 230     49       53   432
2778982 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2020   pk_12_total * 0 0   0 *     0   0   * 0     0             *   *   0 0   0       0   0     0     0            
2778981 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2020   pk_12_total 643 35 72   * *     0   23   415 374     9             113   789 643 35 72           0   23   415 374     9       113   789
2778980 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 564 18 63   * 11     *   19   356 321     17             109   677 564 18 63     11         19   356 321     17       109   677
2778979 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 239 8 44   * *     0   10   184 119     24             49   303 239 8 44           0   10   184 119     24       49   303
2778978 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 268 * 12   0 *     0   *   160 133     11             32   293 268   12   0       0       160 133     11       32   293
2778977 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 549 19 32   * 11     *   24   337 302     62             76   639 549 19 32     11         24   337 302     62       76   639
2778976 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778975 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2020   pk_12_total 619 18 96   * 46     *   25   407 *     8             132   811 619 18 96     46         25   407       8       132   811
2778974 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 433 15 70   * 30     *   33   287 299     14             107   586 433 15 70     30         33   287 299     14       107   586
2778973 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 256 18 42   0 18     0   26   177 183     16             50   360 256 18 42   0 18     0   26   177 183     16       50   360
2778972 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 251 * 33   * 7     0   15   161 152     13             42   313 251   33     7     0   15   161 152     13       42   313
2778971 CT     school 904860 1520011   Waterford School District 90486001593 1520211 Great Neck Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 243 9 34   0 16     0   14   154 162     24             38   316 243 9 34   0 16     0   14   154 162     24       38   316
2778970 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2020   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2778969 CT     school   1520011   Waterford School District   1521011 The Early Learning Center II Program           2020   pk_12_total 21 * *   0 0     *   *   14 12     0             12   26 21       0 0             14 12     0       12   26
2778968 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2020   pk_12_total 20 * *   0 0     0   0   15 10     0             13   25 20       0 0     0   0   15 10     0       13   25
2778967 CT     school   1510011   Waterbury School District   1517111 School to Work Transition Academy Program           2020   pk_12_total * 7 6   0 *     0   0   * *     *             15   15   7 6   0       0   0                   15   15
2778966 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2020   pk_12_total 84 286 661   * *     0   19   570 492     199             283   1062 84 286 661           0   19   570 492     199       283   1062
2778965 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2020   pk_12_total * * 7   0 0     0   0   * *     0             14   14     7   0 0     0   0           0       14   14
2778964 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   pk_12_total * * 7   0 0     0   0   * *     *             15   15     7   0 0     0   0                   15   15
2778963 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2020   pk_12_total 175 92 158   * *     0   21   167 288     12             92   455 175 92 158           0   21   167 288     12       92   455
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
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
2778960 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2020   pk_12_total * * *   0 0     0   0   * *     *             11   11         0 0     0   0                   11   11
2778959 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   pk_12_total * 0 *   0 0     0   0   40 34     *             10   74   0     0 0     0   0   40 34             10   74
2778958 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2020   pk_12_total * 6 10   0 0     0   *   * *     *             19   19   6 10   0 0     0                       19   19
2778957 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2020   pk_12_total 136 61 144   * *     0   20   158 209     8             49   367 136 61 144           0   20   158 209     8       49   367
2778956 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2778955 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2020   pk_12_total 0 0 58   0 0     0   0   31 27     *             15   58 0 0 58   0 0     0   0   31 27             15   58
2778954 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2020   pk_12_total * * 8   0 0     0   0   * *     *             11   11     8   0 0     0   0                   11   11
2778953 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2020   pk_12_total * * 6   0 0     0   *   6 6     *             12   12     6   0 0     0       6 6             12   12
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
2778951 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2778950 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2020   pk_12_total 0 0 60   0 0     0   0   31 29     60             16   60 0 0 60   0 0     0   0   31 29     60       16   60
2778949 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2020   pk_12_total * * 16   0 0     0   0   * *     *             30   30     16   0 0     0   0                   30   30
2778948 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2020   pk_12_total * * 8   0 *     0   *   * *     0             18   18     8   0       0               0       18   18
2778947 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2020   pk_12_total 14 48 80   0 *     0   *   84 64     15             30   148 14 48 80   0       0       84 64     15       30   148
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
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
2778944 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2020   pk_12_total * * 13   0 0     0   0   * *     *             23   23     13   0 0     0   0                   23   23
2778943 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2020   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
2778942 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   pk_12_total * * 15   0 0     0   *   * *     *             *   21     15   0 0     0                           21
2778941 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   pk_12_total 0 * 6   0 0     0   *   * *     0             11   11 0   6   0 0     0               0       11   11
2778940 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   pk_12_total 9 30 68   0 *     0   *   82 31     21             113   113 9 30 68   0       0       82 31     21       113   113
2778939 CT     school 904830 1510011   Waterbury School District 90483000984 1512811 Regan School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 32 44 141   * *     0   8   129 102     31             27   231 32 44 141           0   8   129 102     31       27   231
2778938 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2020   pk_12_total * 6 17   0 0     0   *   18 8     *             26   26   6 17   0 0     0       18 8             26   26
2778937 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 76 115 310   * *     0   28   282 265     78             59   547 76 115 310           0   28   282 265     78       59   547
2778936 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 46 62 191   * 0     0   *   161 156     57             39   317 46 62 191     0     0       161 156     57       39   317
2778935 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2020   pk_12_total 0 0 151   0 0     0   0   74 77     151             18   151 0 0 151   0 0     0   0   74 77     151       18   151
2778934 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   pk_12_total * * 13   0 0     0   0   10 8     7             *   18     13   0 0     0   0   10 8     7           18
2778933 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2020   pk_12_total * 12 17   0 *     0   *   27 6     *             33   33   12 17   0       0       27 6             33   33
2778932 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 39 149 278   * *     0   14   245 245     69             61   490 39 149 278           0   14   245 245     69       61   490
2778931 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2020   pk_12_total 13 0 119   0 0     0   0   82 50     *             13   132 13 0 119   0 0     0   0   82 50             13   132
2778930 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2020   pk_12_total 6 * 9   0 *     0   0   8 11     *             19   19 6   9   0       0   0   8 11             19   19
2778929 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2020   pk_12_total 0 0 226   0 0     0   0   122 104     226             28   226 0 0 226   0 0     0   0   122 104     226       28   226
2778928 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2020   pk_12_total 6 8 14   0 *     0   *   21 10     *             31   31 6 8 14   0       0       21 10             31   31
2778927 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 16 117 294   0 *     0   *   242 201     69             68   443 16 117 294   0       0       242 201     69       68   443
2778926 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 81 55 152   * 18     0   *   175 149     41             51   324 81 55 152     18     0       175 149     41       51   324
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
2778924 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 27 48 220   * *     0   11   167 146     59             60   313 27 48 220           0   11   167 146     59       60   313
2778923 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 23 110 226   * *     0   20   198 185     57             55   383 23 110 226           0   20   198 185     57       55   383
2778922 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 45 99 322   0 *     0   *   246 243     63             44   489 45 99 322   0       0       246 243     63       44   489
2778921 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2020   pk_12_total 26 37 140   0 11     0   6   140 80     *             130   220 26 37 140   0 11     0   6   140 80             130   220
2778920 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 210 85 261   * *     0   43   306 308     34             46   614 210 85 261           0   43   306 308     34       46   614
2778919 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 32 122 305   * *     0   11   244 230     58             92   474 32 122 305           0   11   244 230     58       92   474
2778918 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2020   pk_12_total * * *   0 0     0   0   * *     0             8   8         0 0     0   0           0       8   8
2778917 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 200 86 263   * *     0   27   267 323     36             52   590 200 86 263           0   27   267 323     36       52   590
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
2778915 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 62 104 276   * 12     *   13   253 220     53             77   473 62 104 276     12         13   253 220     53       77   473
2778914 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 52 105 296   * *     0   22   240 238     42             86   478 52 105 296           0   22   240 238     42       86   478
2778913 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 63 126 292   * *     0   19   268 239     57             93   507 63 126 292           0   19   268 239     57       93   507
2778912 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 110 107 242   0 10     0   25   242 252     55             57   494 110 107 242   0 10     0   25   242 252     55       57   494
2778911 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 66 95 280   * *     0   19   267 207     71             76   474 66 95 280           0   19   267 207     71       76   474
2778910 CT     school 904830 1510011   Waterbury School District 90483000968 1510511 Bucks Hill School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 24 68 244   0 *     0   *   180 170     58             68   350 24 68 244   0       0       180 170     58       68   350
2778909 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 130 98 276   0 6     0   28   266 272     79             62   538 130 98 276   0 6     0   28   266 272     79       62   538
2778908 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             6   6   0 0   0       0   0                   6   6
2778907 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2020   pk_12_total 575 * 122   0 54     0   *   374 402     15             83   776 575   122   0 54     0       374 402     15       83   776
2778906 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2020   pk_12_total 761 31 191   * 42     0   *   476 561     25             155   1037 761 31 191     42     0       476 561     25       155   1037
2778905 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2020   pk_12_total 14 0 *   0 *     0   0   14 8     *             22   22 14 0     0       0   0   14 8             22   22
2778904 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2020   pk_12_total 17 * *   0 0     0   0   14 10     0             9   24 17       0 0     0   0   14 10     0       9   24
2778903 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2020   pk_12_total 6 0 *   0 *     0   0   * *     *             8   8 6 0     0       0   0                   8   8
2778902 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 413 13 106   * 30     *   11   287 292     16             91   579 413 13 106     30         11   287 292     16       91   579
2778901 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 479 20 110   0 24     0   11   336 308     31             90   644 479 20 110   0 24     0   11   336 308     31       90   644
2778900 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2778899 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   pk_12_total 12 * *   0 0     0   0   * *     0             16   16 12       0 0     0   0           0       16   16
2778898 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778897 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             6   6   0 0   0       0   0                   6   6
2778896 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 206 * 73   * 10     0   7   137 163     31             35   300 206   73     10     0   7   137 163     31       35   300
2778895 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 208 * 51   0 17     0   *   148 139     29             45   287 208   51   0 17     0       148 139     29       45   287
2778894 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 184 10 74   0 14     *   *   147 138     39             49   285 184 10 74   0 14             147 138     39       49   285
2778893 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2020   pk_12_total 242 * 28   0 22     *   8   147 157     15             46   304 242   28   0 22         8   147 157     15       46   304
2778892 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2778891 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   pk_12_total * 0 0   0 *     0   0   * *     *             *   *   0 0   0       0   0                        
2778890 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             9   9   0     0 0     0                       9   9
2778889 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2020   pk_12_total 9 0 *   0 *     0   0   * *     *             13   13 9 0     0       0   0                   13   13
2778888 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 232 * 69   0 13     0   *   170 153     37             31   323 232   69   0 13     0       170 153     37       31   323
2778887 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 252 7 39   0 18     0   9   170 155     13             30   325 252 7 39   0 18     0   9   170 155     13       30   325
2778886 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 230 * 64   0 10     *   9   173 144     30             28   317 230   64   0 10         9   173 144     30       28   317

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