Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by district_state_id

View and edit SQL

year

  • 2020 · 1,361

grade

  • pk_12_total · 1,361
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
2778624 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 230 * 31   0 *     0   11   158 123     12             53   281 230   31   0       0   11   158 123     12       53   281
2778625 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   pk_12_total 193 * 27   0 *     *   10   109 129     *             43   238 193   27   0           10   109 129             43   238
2778626 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands 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
2778627 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 384 * 55   0 11     *   15   233 241     12             91   474 384   55   0 11         15   233 241     12       91   474
2778628 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 298 * 27   * 9     0   16   190 168     0             60   358 298   27     9     0   16   190 168     0       60   358
2778679 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 246 * 32   0 40     0   *   179 162     9             70   341 246   32   0 40     0       179 162     9       70   341
2778680 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 279 * 35   0 23     0   *   199 152     9             62   351 279   35   0 23     0       199 152     9       62   351
2778681 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 284 * 20   * 16     0   16   158 181     10             29   339 284   20     16     0   16   158 181     10       29   339
2778682 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 301 0 22   * 17     0   *   186 167     6             56   353 301 0 22     17     0       186 167     6       56   353
2778683 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2020   pk_12_total 0 0 0   0 *     0   0   * 0     0             *   * 0 0 0   0       0   0     0     0            
2778684 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778685 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 223 0 20   * *     0   15   146 125     *             23   271 223 0 20           0   15   146 125             23   271
2778686 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 197 * 28   0 19     0   *   134 130     12             27   264 197   28   0 19     0       134 130     12       27   264
2778687 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2778688 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2778689 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778690 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 460 0 39   0 35     *   *   287 271     *             72   558 460 0 39   0 35             287 271             72   558
2778691 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 450 6 44   0 39     0   19   282 276     *             81   558 450 6 44   0 39     0   19   282 276             81   558
2778692 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             9   9   0 0   0       0   0           0       9   9
2778693 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2020   pk_12_total 1306 14 115   * 114     *   43   * 801     *             162   1596 1306 14 115     114         43     801             162   1596
2778694 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   8   0     0 0     0   0           0           8
2778695 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2020   pk_12_total 12 0 *   0 0     0   *   * *     0             16   16 12 0     0 0     0               0       16   16
2778696 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 231 * 47   * 89     0   19   202 194     44             44   396 231   47     89     0   19   202 194     44       44   396
2778697 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 141 7 23   * 312     *   10   256 241     102             52   497 141 7 23     312         10   256 241     102       52   497
2778698 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2020   pk_12_total 222 11 41   0 182     0   18   219 255     43             58   474 222 11 41   0 182     0   18   219 255     43       58   474
2778699 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 337 * 60   * 150     0   20   292 291     15             83   583 337   60     150     0   20   292 291     15       83   583
2778700 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2020   pk_12_total 479 36 92   * 116     0   *   372 371     11             89   743 479 36 92     116     0       372 371     11       89   743
2778701 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778702 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
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            
2778703 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 352 7 31   * *     0   15   * 209     *             59   416 352 7 31           0   15     209             59   416
2778704 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 228 10 20   * *     0   22   141 143     11             29   284 228 10 20           0   22   141 143     11       29   284
2778705 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total * 0 *   0 0     0   0   48 58     0             21   106   0     0 0     0   0   48 58     0       21   106
2778706 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 364 28 111   * *     0   21   292 246     38             98   538 364 28 111           0   21   292 246     38       98   538
2778707 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 327 18 59   0 22     0   8   216 218     29             56   434 327 18 59   0 22     0   8   216 218     29       56   434
2778708 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 387 24 104   * 17     0   *   272 272     6             84   544 387 24 104     17     0       272 272     6       84   544
2778709 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2020   pk_12_total 472 43 94   * 27     *   6   305 339     10             80   644 472 43 94     27         6   305 339     10       80   644
2778710 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 88 0 10   0 *     0   *   56 47     *             28   103 88 0 10   0       0       56 47             28   103
2778711 CT     school 904050 1260011   Shelton School District 90405000804 1260911 Mohegan School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 254 22 64   0 11     0   7   189 169     30             58   358 254 22 64   0 11     0   7   189 169     30       58   358
2778712 CT     school 904050 1260011   Shelton School District 90405000796 1261011 Booth Hill School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 236 22 47   0 *     0   *   163 160     35             32   323 236 22 47   0       0       163 160     35       32   323
2778713 CT     school 904050 1260011   Shelton School District 90405000798 1260511 Elizabeth Shelton School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 311 18 66   0 22     0   6   211 212     21             43   423 311 18 66   0 22     0   6   211 212     21       43   423
2778714 CT     school 904050 1260011   Shelton School District 90405000803 1260811 Long Hill School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 189 26 105   0 23     *   *   182 178     51             45   360 189 26 105   0 23             182 178     51       45   360
2778715 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2020   pk_12_total 22 * 7   0 *     0   0   26 *     0             *   31 22   7   0       0   0   26       0           31
2778716 CT     school 904050 1260011   Shelton School District 90405000003 1260611 Sunnyside School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 130 35 70   * 12     0   *   125 129     30             37   254 130 35 70     12     0       125 129     30       37   254
2778717 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2020   pk_12_total 6 * *   0 0     0   *   9 0     *             9   9 6       0 0     0       9 0             9   9
2778718 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             10   10   0 0   0       0   0                   10   10
2778719 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778720 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2778721 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2020   pk_12_total 489 51 113   * 42     0   *   382 345     34             105   727 489 51 113     42     0       382 345     34       105   727
2778722 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2020   pk_12_total 513 59 127   * 47     *   27   396 381     31             121   777 513 59 127     47         27   396 381     31       121   777
2778723 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2020   pk_12_total 946 86 188   * 84     0   *   696 *     22             167   1357 946 86 188     84     0       696       22       167   1357
2778724 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2020   pk_12_total * * 0   0 0     0   0   10 9     0             19   19     0   0 0     0   0   10 9     0       19   19
2778725 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 239 * 17   * 7     0   *   136 138     *             39   274 239   17     7     0       136 138             39   274
2778727 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 471 25 72   0 42     0   35   348 297     7             120   645 471 25 72   0 42     0   35   348 297     7       120   645
2778728 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 267 * 41   * 36     0   17   200 175     11             38   375 267   41     36     0   17   200 175     11       38   375
2778729 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 310 23 46   0 41     0   24   218 226     24             50   444 310 23 46   0 41     0   24   218 226     24       50   444
2778730 CT     school 904110 1280011   Simsbury School District 90411000815 1280311 Tariffville School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 154 45 16   0 12     0   19   116 130     7             33   246 154 45 16   0 12     0   19   116 130     7       33   246
2778731 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 267 19 39   0 17     0   23   169 196     *             49   365 267 19 39   0 17     0   23   169 196             49   365
2778732 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2020   pk_12_total 455 39 52   0 52     *   *   311 315     *             87   626 455 39 52   0 52             311 315             87   626
2778733 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2020   pk_12_total 1027 69 115   0 89     *   *   689 641     9             169   1330 1027 69 115   0 89             689 641     9       169   1330
2778734 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2020   pk_12_total 25 * *   0 *     0   0   23 10     0             33   33 25       0       0   0   23 10     0       33   33
2778735 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 552 15 30   * *     0   *   315 292     6             91   607 552 15 30           0       315 292     6       91   607
2778736 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 271 8 13   * 7     0   *   143 161     *             45   304 271 8 13     7     0       143 161             45   304
2778737 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2020   pk_12_total 380 15 24   0 *     *   10   230 208     0             59   438 380 15 24   0           10   230 208     0       59   438
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
2778747 CT     school   1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools           2020   pk_12_total * * 0   0 0     0   0   12 12     0             15   24     0   0 0     0   0   12 12     0       15   24
2778748 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 63 0 7   0 *     0   *   50 27     0             52   77 63 0 7   0       0       50 27     0       52   77
2778749 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 243 * 23   0 *     0   18   158 133     6             32   291 243   23   0       0   18   158 133     6       32   291
2778750 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 437 11 40   0 17     0   25   276 254     9             84   530 437 11 40   0 17     0   25   276 254     9       84   530
2778751 CT     school 904230 1310011   Southington School District 90423000830 1311311 Flanders Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 198 11 40   0 16     *   *   135 138     24             33   273 198 11 40   0 16             135 138     24       33   273
2778752 CT     school 904230 1310011   Southington School District 90423000831 1310211 Hatton Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 241 * 31   0 *     0   20   159 150     8             36   309 241   31   0       0   20   159 150     8       36   309
2778753 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778754 CT     school   1310011   Southington School District 90423001759 1311811 Language Based Classroom, Multihandicapped Program           2020   pk_12_total 12 0 *   0 *     0   *   * *     0             16   16 12 0     0       0               0       16   16
2778755 CT     school 904230 1310011   Southington School District 90423000836 1310611 Oshana Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 197 * 36   0 6     *   11   137 121     *             29   258 197   36   0 6         11   137 121             29   258
2778756 CT     school 904230 1310011   Southington School District 90423000837 1310711 South End Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 187 * 28   0 *     0   13   117 122     *             23   239 187   28   0       0   13   117 122             23   239
2778757 CT     school 904230 1310011   Southington School District 90423000839 1310811 Strong Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 204 8 24   0 9     0   21   130 136     15             29   266 204 8 24   0 9     0   21   130 136     15       29   266
2778758 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 325 10 45   0 25     0   22   224 203     21             26   427 325 10 45   0 25     0   22   224 203     21       26   427
2778759 CT     school   1310011   Southington School District 90423001786 1310411 Language Based Classroom at Hatton School Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778760 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 586 * 84   * 25     0   23   374 366     8             102   740 586   84     25     0   23   374 366     8       102   740
2778761 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2020   pk_12_total 8 * *   0 0     0   0   6 6     0             12   12 8       0 0     0   0   6 6     0       12   12
2778762 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 562 17 67   * 26     *   31   357 348     9             95   705 562 17 67     26         31   357 348     9       95   705
2778763 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             8   8   0     0 0     0               0       8   8
2778764 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2020   pk_12_total 13 * *   0 0     0   0   * *     0             17   17 13       0 0     0   0           0       17   17
2778765 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2020   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2778766 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2020   pk_12_total 1660 45 167   * 82     *   72   978 1052     15             260   2030 1660 45 167     82         72   978 1052     15       260   2030
2778767 CT     school   1310011   Southington School District 90423001665 1310111 The Karen Smith Academy Program           2020   pk_12_total 35 0 *   0 0     0   *   22 18     0             12   40 35 0     0 0     0       22 18     0       12   40
2778768 CT     school   1310011   Southington School District   1312211 STELLAR Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             11   11   0 0   0 0     0               0       11   11
2778738 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 269 32 57   * 81     0   *   227 231     24             76   458 269 32 57     81     0       227 231     24       76   458
2778739 CT     school 904170 1320011   South Windsor School District 90417000821 1320111 Philip R. Smith School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 232 12 39   0 97     0   17   199 198     50             32   397 232 12 39   0 97     0   17   199 198     50       32   397
2778740 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2020   pk_12_total 57 * 10   0 15     0   *   57 36     0             58   93 57   10   0 15     0       57 36     0       58   93
2778741 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 299 * 53   * 213     0   39   308 329     86             56   637 299   53     213     0   39   308 329     86       56   637
2778742 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 239 27 50   0 236     0   35   306 281     101             39   587 239 27 50   0 236     0   35   306 281     101       39   587
2778743 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2020   pk_12_total 578 72 84   * 258     *   55   530 *     25             125   1049 578 72 84     258         55   530       25       125   1049
2778744 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2020   pk_12_total 6 * *   0 0     0   0   9 0     0             *   9 6       0 0     0   0   9 0     0           9
2778745 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2020   pk_12_total 785 95 110   0 241     *   *   663 630     14             192   1293 785 95 110   0 241             663 630     14       192   1293
2778746 CT     school   1320011   South Windsor School District 90417001605 1329011 Project Worth Young Adult Academy Program           2020   pk_12_total 11 * 0   0 *     0   0   * *     0             14   14 11   0   0       0   0           0       14   14
2778769 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 187 14 38   * *     *   25   151 121     8             43   272 187 14 38               25   151 121     8       43   272
2778770 CT     school 904290 1340011   Stafford School District 90429000847 1340311 Staffordville School Public Schools Regular School No Elementary PK 01 2020   pk_12_total 127 * 15   0 *     0   *   81 67     0             20   148 127   15   0       0       81 67     0       20   148

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