enrollments

Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

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
2452067 2452067 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 328 * 44   * 68     0   27   255 222     *             22   477 328   44     68     0   27   255 222             22   477
2452072 2452072 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 681 * 86   * 108     0   45   * 495     *             112   952 681   86     108     0   45     495             112   952
2452074 2452074 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2019   pk_12_total 13 * *   0 *     0   0   * *     *             17   17 13       0       0   0                   17   17
2452080 2452080 CT     school 901710 570011   Greenwich School District 90171000305 570811 North Street School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 315 * 34   * 21     0   40   219 198     13             37   417 315   34     21     0   40   219 198     13       37   417
2452083 2452083 CT     school 901710 570011   Greenwich School District 90171000296 570211 Cos Cob School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 258 * 82   0 *     0   35   211 200     43             36   411 258   82   0       0   35   211 200     43       36   411
2452084 2452084 CT     school 901710 570011   Greenwich School District 90171000299 570411 Glenville School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 272 * 63   * 42     0   26   219 192     18             36   411 272   63     42     0   26   219 192     18       36   411
2452085 2452085 CT     school 901710 570011   Greenwich School District 90171001288 571311 International School At Dundee Public Schools Regular School No Elementary KG 05 2019   pk_12_total 184 * 52   * 90     0   37   189 180     24             29   369 184   52     90     0   37   189 180     24       29   369
2452086 2452086 CT     school 901710 570011   Greenwich School District 90171000302 570311 Julian Curtiss School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 150 * 106   * 25     0   22   168 152     48             34   320 150   106     25     0   22   168 152     48       34   320
2452088 2452088 CT     school 901710 570011   Greenwich School District 90171000304 570711 North Mianus School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 293 * 75   0 95     0   *   263 229     25             40   492 293   75   0 95     0       263 229     25       40   492
2452094 2452094 CT     school   570011   Greenwich School District   571511 Windrose Program           2019   pk_12_total * * 8   0 0     0   0   * *     *             8   20     8   0 0     0   0                   8   20
2452095 2452095 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2019   pk_12_total 11 * *   0 *     0   0   12 7     0             19   19 11       0       0   0   12 7     0       19   19
2452098 2452098 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 09 12 2019   pk_12_total 10 * *   0 0     0   *   * *     0             *   14 10       0 0     0               0           14
2452105 2452105 CT     school 901770 590011   Groton School District 90177001488 591911 Northeast Academy Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 307 * 44   0 19     *   33   206 205     7             47   411 307   44   0 19         33   206 205     7       47   411
2452109 2452109 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2019   pk_12_total 6 * *   0 0     *   *   9 6     0             15   15 6       0 0             9 6     0       15   15
2452111 2452111 CT     school   590011   Groton School District   591011 Transition Academy Program           2019   pk_12_total 11 * *   0 0     0   *   * *     0             15   15 11       0 0     0               0       15   15
2452112 2452112 CT     school 901800 600011   Guilford School District 90180000333 600211 Guilford Lakes School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 248 * 26   0 17     0   *   168 142     16             39   310 248   26   0 17     0       168 142     16       39   310
2452113 2452113 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 225 * 18   0 *     0   12   138 128     11             18   266 225   18   0       0   12   138 128     11       18   266
2452114 2452114 CT     school 901800 600011   Guilford School District 90180000330 600411 Calvin Leete School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 215 * 10   0 *     0   15   128 120     14             19   248 215   10   0       0   15   128 120     14       19   248
2452115 2452115 CT     school 901800 600011   Guilford School District 90180000334 600311 Melissa Jones School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 248 * 16   0 7     *   15   143 148     6             27   291 248   16   0 7         15   143 148     6       27   291
2452117 2452117 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 09 2019   pk_12_total 473 * 47   * 27     *   24   303 276     *             62   579 473   47     27         24   303 276             62   579
2452126 2452126 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2019   pk_12_total * * 6   0 *     0   0   12 0     *             12   12     6   0       0   0   12 0             12   12
2452134 2452134 CT     school   620011   Hamden School District   621811 West Woods IIC Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452160 2452160 CT     school   640011   Hartford School District   640410 Pre-K Integrated - Parkville School Program           2019   pk_12_total * * 13   * *     0   0   11 8     0             11   19     13           0   0   11 8     0       11   19
2452168 2452168 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2452169 2452169 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452174 2452174 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2452175 2452175 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2019   pk_12_total 0 * 21   0 *     0   0   20 8     8             28   28 0   21   0       0   0   20 8     8       28   28
2452176 2452176 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2019   pk_12_total 0 * 16   0 *     0   0   * *     9             20   20 0   16   0       0   0           9       20   20
2452177 2452177 CT     school   640011   Hartford School District   648711 iGOAL 1 - Parkville School Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             9   9     6   0 0     0   0                   9   9
2452179 2452179 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   pk_12_total 0 * *   0 0     0   *   * *     *             *   * 0       0 0     0                            
2452180 2452180 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452189 2452189 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2019   pk_12_total 0 * *   0 0     0   0   9 8     10             17   17 0       0 0     0   0   9 8     10       17   17
2452190 2452190 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2019   pk_12_total * * 11   0 0     0   0   * *     *             15   15     11   0 0     0   0                   15   15
2452191 2452191 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452200 2452200 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2019   pk_12_total * * 12   0 0     0   0   * *     *             19   19     12   0 0     0   0                   19   19
2452208 2452208 CT     school 901950 650011   Hartland School District 90195000386 650111 Hartland School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 143 * 6   0 0     *   6   91 69     *             29   160 143   6   0 0         6   91 69             29   160
2452209 2452209 CT     school 902010 670011   Hebron School District 90201000387 670211 Gilead Hill School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 286 * 13   0 *     0   *   149 159     *             25   308 286   13   0       0       149 159             25   308
2452210 2452210 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2019   pk_12_total 319 * 19   0 *     0   11   187 168     0             53   355 319   19   0       0   11   187 168     0       53   355
2452212 2452212 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   pk_12_total 165 * 52   * 47     0   39   171 166     31             29   337 165   52     47     0   39   171 166     31       29   337
2452215 2452215 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2019   pk_12_total 94 * 7   0 *     0   12   66 52     0             34   118 94   7   0       0   12   66 52     0       34   118
2452216 2452216 CT     school 902070 690011   Killingly School District 90207000391 690111 Killingly Central School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 300 * 43   * *     0   41   193 199     9             60   392 300   43           0   41   193 199     9       60   392
2452217 2452217 CT     school 902070 690011   Killingly School District 90207000394 690311 Killingly Memorial School Public Schools Regular School No Elementary 02 04 2019   pk_12_total 403 * 43   * 7     0   29   249 244     20             64   493 403   43     7     0   29   249 244     20       64   493
2452224 2452224 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2019   pk_12_total * * *   0 0     0   *   * *     *             15   15         0 0     0                       15   15
2452225 2452225 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2019   pk_12_total 6 * *   0 0     0   *   * *     0             11   11 6       0 0     0               0       11   11
2452227 2452227 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2019   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2452229 2452229 CT     school   2450014   Learn   2451214 Learn ABA Program at Center School             2019   pk_12_total * * 6   0 *     0   *   * *     *             15   15     6   0       0                       15   15
2452232 2452232 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 203 * 31   * 9     0   20   123 148     *             32   271 203   31     9     0   20   123 148             32   271
2452234 2452234 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2019   pk_12_total 42 * 14   * *     0   7   25 42     *             7   67 42   14           0   7   25 42             7   67
2452237 2452237 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 257 * 20   * 7     *   *   148 151     *             50   299 257   20     7             148 151             50   299
2452238 2452238 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2019   pk_12_total 303 * 10   * *     *   0   158 167     0             51   325 303   10               0   158 167     0       51   325
2452240 2452240 CT     school 902160 720011   Ledyard School District 90216000398 720411 Gallup Hill School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 199 * 41   20 10     *   30   167 145     *             58   312 199   41   20 10         30   167 145             58   312
2452241 2452241 CT     school 902160 720011   Ledyard School District 90216000400 720111 Ledyard Center School   Regular School No Elementary KG 06 2019   pk_12_total 277 * 36   12 13     *   23   193 181     *             58   374 277   36   12 13         23   193 181             58   374
2452245 2452245 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2019   pk_12_total 7 * 0   * 0     0   0   * *     0             9   9 7   0     0     0   0           0       9   9
2452246 2452246 CT     school 902190 730011   Lisbon School District 90219000403 730111 Lisbon Central School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 320 * 41   0 *     *   30   198 203     6             60   401 320   41   0           30   198 203     6       60   401
2452247 2452247 CT     school 902220 740011   Litchfield School District 90222000405 740211 Center School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 258 * 13   0 7     *   *   144 141     0             40   285 258   13   0 7             144 141     0       40   285
2452250 2452250 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 252 * 12   0 *     *   *   137 140     0             38   277 252   12   0               137 140     0       38   277
2452252 2452252 CT     school 902280 760011   Madison School District 90228000414 760211 Island Avenue Elementary School   Regular School No Elementary KG 04 2019   pk_12_total 224 * 21   0 *     0   8   140 121     11             35   261 224   21   0       0   8   140 121     11       35   261
2452255 2452255 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 321 * 17   * 15     *   22   193 187     *             54   380 321   17     15         22   193 187             54   380
2452256 2452256 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 364 * 24   0 *     0   21   236 *     *             64   423 364   24   0       0   21   236               64   423
2452257 2452257 CT     school 902280 760011   Madison School District 90228000411 766111 Daniel Hand High School Public Schools Regular School No High 09 12 2019   pk_12_total 937 * 49   * 45     0   33   557 *     0             114   1072 937   49     45     0   33   557       0       114   1072
2452260 2452260 CT     school   770011   Manchester School District   770811 Manchester Preschool - Site 2 Program           2019   pk_12_total 19 * *   0 7     0   0   24 10     0             19   34 19       0 7     0   0   24 10     0       19   34
2452270 2452270 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2019   pk_12_total 9 * 11   0 0     0   *   21 6     0             *   27 9   11   0 0     0       21 6     0           27
2452278 2452278 CT     school 902340 780011   Mansfield School District 90234000434 780211 Dorothy C. Goodwin School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 120 * 16   0 34     0   *   102 84     8             12   186 120   16   0 34     0       102 84     8       12   186
2452280 2452280 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 383 * 70   * 63     0   24   267 286     11             63   553 383   70     63     0   24   267 286     11       63   553
2452282 2452282 CT     school 902400 800011   Meriden School District 90240000442 800311 Hanover School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 178 * 246   0 *     0   21   249 214     126             77   463 178   246   0       0   21   249 214     126       77   463
2452288 2452288 CT     school   800011   Meriden School District   800611 STARS - ES Program           2019   pk_12_total 13 * 27   0 0     0   *   37 9     *             46   46 13   27   0 0     0       37 9             46   46
2452292 2452292 CT     school   800011   Meriden School District   800911 STEP - ES Program           2019   pk_12_total 8 * 15   0 0     0   *   * *     *             28   28 8   15   0 0     0                       28   28
2452293 2452293 CT     school   800011   Meriden School District   802211 SOAR- ES Program           2019   pk_12_total * * *   0 0     0   0   * *     0             9   9         0 0     0   0           0       9   9
2452295 2452295 CT     school   800011   Meriden School District   802311 SOAR - LMS             2019   pk_12_total * * 10   0 0     0   0   * *     6             16   16     10   0 0     0   0           6       16   16
2452296 2452296 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2019   pk_12_total * * *   0 0     0   0   * *     *             14   14         0 0     0   0                   14   14
2452297 2452297 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2019   pk_12_total 6 * 11   0 0     0   *   18 6     *             24   24 6   11   0 0     0       18 6             24   24
2452300 2452300 CT     school   800011   Meriden School District   801311 Venture Academy Program           2019   pk_12_total 13 * 31   0 0     0   *   40 11     *             51   51 13   31   0 0     0       40 11             51   51
2452303 2452303 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2019   pk_12_total * * 6   0 *     0   0   * *     *             12   12     6   0       0   0                   12   12
2452304 2452304 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2019   pk_12_total * * 7   0 *     0   *   7 6     *             13   13     7   0       0       7 6             13   13
2452305 2452305 CT     school   800011   Meriden School District   801611 TSC - MHS Program           2019   pk_12_total * * 10   0 0     0   0   * *     *             19   19     10   0 0     0   0                   19   19
2452306 2452306 CT     school   800011   Meriden School District   801711 TSC - PHS Program           2019   pk_12_total * * 18   0 0     0   0   18 6     6             24   24     18   0 0     0   0   18 6     6       24   24
2452307 2452307 CT     school   800011   Meriden School District   801811 STARS - HS Program           2019   pk_12_total * * 9   0 *     0   0   * *     6             16   16     9   0       0   0           6       16   16
2452308 2452308 CT     school   800011   Meriden School District   801411 Success Academy Program           2019   pk_12_total 6 * 26   0 0     0   *   15 23     *             12   38 6   26   0 0     0       15 23             12   38
2452309 2452309 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2019   pk_12_total * * 6   0 *     0   0   * *     *             14   14     6   0       0   0                   14   14
2452310 2452310 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2019   pk_12_total * * *   * 0     0   0   * *     *             11   11           0     0   0                   11   11
2452311 2452311 CT     school   800011   Meriden School District   802111 Community Collaborative Classroom - ACADEMY Program           2019   pk_12_total * * *   0 0     0   0   * *     *             8   8         0 0     0   0                   8   8
2452315 2452315 CT     school   830011   Middletown School District 90249001719 830811 ICM - Moody K-2 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452321 2452321 CT     school   830011   Middletown School District 90249001758 830611 ICM - Farm Hill Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452322 2452322 CT     school   830011   Middletown School District 90249001652 830711 ICM - Moody 3-5 Program           2019   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2452323 2452323 CT     school   830011   Middletown School District   832011 ICM - Spencer Program           2019   pk_12_total * * *   0 0     0   *   8 0     0             8   8         0 0     0       8 0     0       8   8
2452327 2452327 CT     school   830011   Middletown School District 90249001722 831811 MHS - Alternative Education Program 1 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             *   8         0 0     0   0           0           8
2452328 2452328 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             *   11 7       0 0     0   0           0           11
2452330 2452330 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2019   pk_12_total * * 0   0 0     0   *   * *     0             0   6     0   0 0     0               0       0   6
2452331 2452331 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2019   pk_12_total 6 * *   0 0     0   *   7 6     0             0   13 6       0 0     0       7 6     0       0   13
2452332 2452332 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2019   pk_12_total 0 * *   * 0     0   *   * *     0             *   * 0         0     0               0            
2452333 2452333 CT     school   830011   Middletown School District 90249001598 839111 Middletown Transition Center Program           2019   pk_12_total 10 * *   * 0     0   *   14 6     *             20   20 10         0     0       14 6             20   20
2452335 2452335 CT     school 902520 840011   Milford School District 90252000476 841611 Live Oaks School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 228 * 27   * 30     0   12   169 134     9             50   303 228   27     30     0   12   169 134     9       50   303
2452341 2452341 CT     school 902520 840011   Milford School District 90252000478 840711 Meadowside School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 133 * 32   0 90     0   *   117 149     45             29   266 133   32   0 90     0       117 149     45       29   266
2452342 2452342 CT     school 902520 840011   Milford School District 90252000484 845111 East Shore Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 310 * 30   0 27     0   *   179 216     *             57   395 310   30   0 27     0       179 216             57   395
2452347 2452347 CT     school   840011   Milford School District 90252001679 840311 The Academy Program           2019   pk_12_total 39 * *   0 0     0   *   31 18     0             15   49 39       0 0     0       31 18     0       15   49
2452348 2452348 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2019   pk_12_total * * 0   0 0     0   0   * *     *             6   6     0   0 0     0   0                   6   6
2452351 2452351 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 418 * 52   * 42     0   20   272 276     7             64   548 418   52     42     0   20   272 276     7       64   548
2452353 2452353 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2019   pk_12_total 627 * 58   * 39     0   18   361 395     *             101   756 627   58     39     0   18   361 395             101   756
2452357 2452357 CT     school   860011   Montville School District 90258001663 860311 Pre School Program Program           2019   pk_12_total 26 * 8   0 *     0   9   24 22     0             20   46 26   8   0       0   9   24 22     0       20   46
2452358 2452358 CT     school 902580 860011   Montville School District 90258000492 860711 Dr. Charles E. Murphy School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 190 * 37   * 8     0   47   155 135     11             42   290 190   37     8     0   47   155 135     11       42   290

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