Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by rowid descending

View and edit SQL

grade

year

  • 2019 · 20,086
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
2452946 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 449 12 57   * 33     *   25   274 307     6             100   581 449 12 57     33         25   274 307     6       100   581
2452945 CT     school 904860 1520011   Waterford School District 90486001512 1520711 Quaker Hill Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 272 * 41   0 19     *   29   181 196     17             48   377 272   41   0 19         29   181 196     17       48   377
2452944 CT     school 904860 1520011   Waterford School District 90486001593 1520211 Great Neck Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 247 9 36   0 13     0   11   163 153     20             27   316 247 9 36   0 13     0   11   163 153     20       27   316
2452943 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2019   pk_12_total * 0 0   0 0     *   0   * *     0             *   *   0 0   0 0         0           0            
2452942 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2019   pk_12_total 41 0 *   0 *     0   0   25 19     0             20   44 41 0     0       0   0   25 19     0       20   44
2452941 CT     school 904860 1520011   Waterford School District 90486000998 1520611 Oswegatchie Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 273 * 30   * 10     0   11   163 167     12             47   330 273   30     10     0   11   163 167     12       47   330
2452940 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2019   pk_12_total 100 284 590   * *     0   19   545 457     177             239   1002 100 284 590           0   19   545 457     177       239   1002
2452939 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2019   pk_12_total * * *   0 0     0   0   * *     0             13   13         0 0     0   0           0       13   13
2452938 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             13   13     6   0 0     0   0                   13   13
2452937 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2019   pk_12_total 188 109 141   * *     0   20   171 300     *             73   471 188 109 141           0   20   171 300             73   471
2452936 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2019   pk_12_total 246 250 692   11 21     0   24   635 609     223             259   1244 246 250 692   11 21     0   24   635 609     223       259   1244
2452935 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2019   pk_12_total 172 306 645   * 13     *   18   637 525     188             311   1162 172 306 645     13         18   637 525     188       311   1162
2452934 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2019   pk_12_total * * 6   0 0     0   0   * *     0             9   9     6   0 0     0   0           0       9   9
2452933 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             9   9     7   0 0     0   0                   9   9
2452932 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2019   pk_12_total * 0 *   0 0     0   0   35 29     *             9   64   0     0 0     0   0   35 29             9   64
2452931 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2019   pk_12_total * * 13   0 0     0   *   * *     *             23   23     13   0 0     0                       23   23
2452930 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2019   pk_12_total 138 51 121   * *     0   17   137 197     9             47   334 138 51 121           0   17   137 197     9       47   334
2452929 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   8 6     *             14   14     7   0 0     0   0   8 6             14   14
2452928 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2019   pk_12_total 0 0 54   0 0     0   0   26 28     *             13   54 0 0 54   0 0     0   0   26 28             13   54
2452927 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2019   pk_12_total * * 8   0 0     0   0   * *     0             14   14     8   0 0     0   0           0       14   14
2452926 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2452925 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 83 234 576   * *     0   24   463 465     86             182   928 83 234 576           0   24   463 465     86       182   928
2452924 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2019   pk_12_total * 0 *   0 0     0   0   26 33     59             15   59   0     0 0     0   0   26 33     59       15   59
2452923 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2019   pk_12_total 0 8 12   0 0     0   0   * *     *             20   20 0 8 12   0 0     0   0                   20   20
2452922 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   pk_12_total * * 7   0 *     0   0   * *     0             16   16     7   0       0   0           0       16   16
2452921 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 143 248 599   10 22     0   30   543 509     122             199   1052 143 248 599   10 22     0   30   543 509     122       199   1052
2452920 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2019   pk_12_total 13 46 90   0 0     0   6   97 58     19             41   155 13 46 90   0 0     0   6   97 58     19       41   155
2452919 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452918 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 165 220 535   10 17     0   31   497 481     109             186   978 165 220 535   10 17     0   31   497 481     109       186   978
2452917 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   pk_12_total * * 17   0 0     0   0   * *     *             25   25     17   0 0     0   0                   25   25
2452916 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2019   pk_12_total 0 * 15   0 0     0   *   * *     0             24   24 0   15   0 0     0               0       24   24
2452915 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   pk_12_total * * 16   0 0     0   *   16 8     *             24   24     16   0 0     0       16 8             24   24
2452914 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2019   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
2452913 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452912 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2019   pk_12_total 8 24 65   0 *     0   *   77 25     24             *   102 8 24 65   0       0       77 25     24           102
2452911 CT     school 904830 1510011   Waterbury School District 90483000984 1512811 Regan School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 41 43 150   * *     0   8   137 112     33             29   249 41 43 150           0   8   137 112     33       29   249
2452910 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 92 132 288   * *     0   33   294 268     75             68   562 92 132 288           0   33   294 268     75       68   562
2452909 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 58 58 214   * 0     0   *   181 172     74             50   353 58 58 214     0     0       181 172     74       50   353
2452908 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2019   pk_12_total 0 0 127   0 0     0   0   67 60     127             17   127 0 0 127   0 0     0   0   67 60     127       17   127
2452907 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   pk_12_total * * *   0 0     0   0   * *     *             9   9         0 0     0   0                   9   9
2452906 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2019   pk_12_total * 11 16   0 *     0   *   * *     *             31   31   11 16   0       0                       31   31
2452905 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 43 166 263   * *     0   29   253 256     56             65   509 43 166 263           0   29   253 256     56       65   509
2452904 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2019   pk_12_total 8 0 122   0 0     0   0   78 52     130             22   130 8 0 122   0 0     0   0   78 52     130       22   130
2452903 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   pk_12_total * * 10   0 *     0   *   7 11     *             18   18     10   0       0       7 11             18   18
2452902 CT     school 904830 1510011   Waterbury School District 90483000968 1510511 Bucks Hill School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 22 72 259   0 *     0   *   190 182     54             52   372 22 72 259   0       0       190 182     54       52   372
2452901 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2019   pk_12_total 0 0 210   0 0     0   0   108 102     *             44   210 0 0 210   0 0     0   0   108 102             44   210
2452900 CT     school   1510011   Waterbury School District   1514611 Bucks Hill Autism Program           2019   pk_12_total * 6 13   0 0     0   *   19 7     *             26   26   6 13   0 0     0       19 7             26   26
2452899 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 18 109 271   * *     *   10   231 184     62             53   415 18 109 271               10   231 184     62       53   415
2452898 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 84 58 167   * 21     0   *   182 167     45             63   349 84 58 167     21     0       182 167     45       63   349
2452897 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2019   pk_12_total 171 208 372   7 25     0   25   334 474     27             67   808 171 208 372   7 25     0   25   334 474     27       67   808
2452896 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 22 55 213   8 0     0   13   156 155     47             55   311 22 55 213   8 0     0   13   156 155     47       55   311
2452895 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 29 101 252   * *     0   18   208 196     74             48   404 29 101 252           0   18   208 196     74       48   404
2452894 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 54 89 330   0 *     0   *   249 255     69             49   504 54 89 330   0       0       249 255     69       49   504
2452893 CT     school   1510011   Waterbury School District 90483000548 1518011 Special Education Preschool Program           2019   pk_12_total 39 36 108   0 *     *   7   112 84     *             93   196 39 36 108   0           7   112 84             93   196
2452892 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 232 85 242   * *     0   37   318 296     27             51   614 232 85 242           0   37   318 296     27       51   614
2452891 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 33 107 318   * *     0   17   252 226     61             80   478 33 107 318           0   17   252 226     61       80   478
2452890 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2019   pk_12_total * * 7   0 0     0   0   * *     0             15   15     7   0 0     0   0           0       15   15
2452889 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 214 90 238   * *     0   30   271 319     34             56   590 214 90 238           0   30   271 319     34       56   590
2452888 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 117 135 349   8 25     0   24   369 289     96             76   658 117 135 349   8 25     0   24   369 289     96       76   658
2452887 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 78 88 275   * 11     *   17   246 230     45             71   476 78 88 275     11         17   246 230     45       71   476
2452886 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 61 103 284   * *     0   28   248 231     44             91   479 61 103 284           0   28   248 231     44       91   479
2452885 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 61 148 268   * *     0   14   275 224     56             84   499 61 148 268           0   14   275 224     56       84   499
2452884 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 131 107 234   * *     0   22   263 247     54             58   510 131 107 234           0   22   263 247     54       58   510
2452883 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 75 103 258   * *     0   19   257 216     68             87   473 75 103 258           0   19   257 216     68       87   473
2452882 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 138 85 273   0 6     0   39   272 269     76             60   541 138 85 273   0 6     0   39   272 269     76       60   541
2452881 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   pk_12_total 7 * *   0 *     0   0   * *     *             13   13 7       0       0   0                   13   13
2452880 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2019   pk_12_total 608 20 102   0 59     0   6   380 415     9             87   795 608 20 102   0 59     0   6   380 415     9       87   795
2452879 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2019   pk_12_total 795 33 198   0 39     *   *   502 572     24             164   1074 795 33 198   0 39             502 572     24       164   1074
2452878 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   pk_12_total 14 0 6   0 0     0   0   13 7     *             *   20 14 0 6   0 0     0   0   13 7                 20
2452877 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 404 14 124   * 24     *   6   295 283     15             69   578 404 14 124     24         6   295 283     15       69   578
2452876 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2019   pk_12_total 9 0 *   0 *     0   0   6 7     *             13   13 9 0     0       0   0   6 7             13   13
2452875 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 500 18 110   0 29     0   7   344 320     23             89   664 500 18 110   0 29     0   7   344 320     23       89   664
2452874 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   pk_12_total 16 0 *   0 0     0   *   * *     0             21   21 16 0     0 0     0               0       21   21
2452873 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452872 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2019   pk_12_total * 0 *   0 *     0   0   * *     *             9   9   0     0       0   0                   9   9
2452871 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 215 * 61   * 7     0   8   145 152     31             36   297 215   61     7     0   8   145 152     31       36   297
2452870 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 211 * 64   0 19     0   *   154 151     34             39   305 211   64   0 19     0       154 151     34       39   305
2452869 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 179 8 59   0 12     *   *   124 142     34             37   266 179 8 59   0 12             124 142     34       37   266
2452868 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2019   pk_12_total 235 * 32   0 20     *   9   156 146     12             38   302 235   32   0 20         9   156 146     12       38   302
2452867 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   pk_12_total 7 * *   * 0     0   0   * *     0             12   12 7         0     0   0           0       12   12
2452866 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2019   pk_12_total 11 0 *   0 *     0   0   * *     *             15   15 11 0     0       0   0                   15   15
2452865 CT     school 904740 1480011   Wallingford School District 90474000957 1480111 Moses Y. Beach School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 263 6 60   0 12     0   7   187 161     35             30   348 263 6 60   0 12     0   7   187 161     35       30   348
2452864 CT     school 904740 1480011   Wallingford School District 90474000953 1480211 Highland School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 257 * 39   0 14     0   *   173 152     17             38   325 257   39   0 14     0       173 152     17       38   325
2452863 CT     school 904740 1480011   Wallingford School District 90474000952 1480911 Evarts C. Stevens School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 215 * 67   0 13     *   8   163 144     38             24   307 215   67   0 13         8   163 144     38       24   307
2452862 CT     school 904740 1480011   Wallingford School District 90474000950 1481011 Cook Hill School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 239 * 90   0 17     0   *   213 149     37             91   362 239   90   0 17     0       213 149     37       91   362
2452861 CT     school 904710 1470011   Voluntown School District 90471000949 1470111 Voluntown Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 228 6 12   * *     *   12   140 124     0             45   264 228 6 12               12   140 124     0       45   264
2452860 CT     school   1460011   Vernon School District 90468001525 1469011 Next Step Program Program           2019   pk_12_total 6 * *   0 0     0   0   * *     0             9   9 6       0 0     0   0           0       9   9
2452859 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2019   pk_12_total 560 96 114   * 51     0   *   433 421     21             149   854 560 96 114     51     0       433 421     21       149   854
2452858 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 418 79 134   * *     0   38   360 345     11             132   705 418 79 134           0   38   360 345     11       132   705
2452857 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2019   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2452856 CT     school   1460011   Vernon School District   1460911 First Step             2019   pk_12_total * * *   0 *     0   0   * *     0             8   8         0       0   0           0       8   8
2452855 CT     school 904680 1460011   Vernon School District 90468000941 1460211 Maple Street School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 92 45 90   0 *     *   27   135 138     *             32   273 92 45 90   0           27   135 138             32   273
2452854 CT     school   1460011   Vernon School District   1461111 Elementary Activities Based Learning Program Program           2019   pk_12_total * 0 *   0 *     0   *   * *     0             8   8   0     0       0               0       8   8
2452853 CT     school 904680 1460011   Vernon School District 90468000944 1461011 Skinner Road School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 149 35 73   0 38     0   28   169 154     29             41   323 149 35 73   0 38     0   28   169 154     29       41   323
2452852 CT     school 904680 1460011   Vernon School District 90468000942 1460311 Northeast School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 120 18 44   * *     0   25   115 109     *             43   224 120 18 44           0   25   115 109             43   224
2452851 CT     school 904680 1460011   Vernon School District 90468000940 1460111 Lake Street School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 169 * 26   0 *     0   13   114 103     *             25   217 169   26   0       0   13   114 103             25   217
2452850 CT     school 904680 1460011   Vernon School District 90468000939 1461411 Center Road School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 239 54 110   0 37     0   44   246 238     34             56   484 239 54 110   0 37     0   44   246 238     34       56   484
2452849 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2019   pk_12_total * 0 *   0 0     0   0   22 30     0             12   52   0     0 0     0   0   22 30     0       12   52
2452848 CT     school   1440011   Trumbull School District   1440611 Educating Learners in Transitional Environments (ELITE) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2452847 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2019   pk_12_total 1562 111 238   6 161     0   26   1012 1092     12             220   2104 1562 111 238   6 161     0   26   1012 1092     12       220   2104

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