enrollments

Data source: Big Local News · About: Big Local

1,444 rows where grade = "kindergarten", state = "CT" and year = 2021 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,344 ✖

grade ✖

  • kindergarten · 1,344 ✖
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
2739409 2739409 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2021   kindergarten                                                   0                                             0
2739410 2739410 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2021   kindergarten                                                   91                                             91
2739411 2739411 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2021   kindergarten                                                   0                                             0
2739460 2739460 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   43                                             43
2739461 2739461 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   *                                              
2739462 2739462 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   *                                              
2739463 2739463 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   44                                             44
2739464 2739464 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   51                                             51
2739465 2739465 CT     school   1180011   Ridgefield School District   1180111 District Program BMES Program           2021   kindergarten                                                   *                                              
2739466 2739466 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   47                                             47
2739467 2739467 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2021   kindergarten                                                   0                                             0
2739468 2739468 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2021   kindergarten                                                   0                                             0
2739469 2739469 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2021   kindergarten                                                   0                                             0
2739470 2739470 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739471 2739471 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739472 2739472 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2021   kindergarten                                                   0                                             0
2739473 2739473 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2021   kindergarten                                                   0                                             0
2739474 2739474 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2021   kindergarten                                                   0                                             0
2739475 2739475 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739476 2739476 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2021   kindergarten                                                   0                                             0
2739477 2739477 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2021   kindergarten                                                   0                                             0
2739478 2739478 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2021   kindergarten                                                   96                                             96
2739479 2739479 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2021   kindergarten                                                   90                                             90
2739480 2739480 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2021   kindergarten                                                   0                                             0
2739481 2739481 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739482 2739482 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739483 2739483 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2021   kindergarten                                                   0                                             0
2738557 2738557 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   46                                             46
2738558 2738558 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2738559 2738559 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2021   kindergarten                                                   0                                             0
2739484 2739484 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   34                                             34
2739485 2739485 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   43                                             43
2739486 2739486 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   12                                             12
2739487 2739487 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   62                                             62
2739488 2739488 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   64                                             64
2739489 2739489 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739490 2739490 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739491 2739491 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   17                                             17
2739492 2739492 CT     school 904050 1260011   Shelton School District 90405000804 1260911 Mohegan School Public Schools Regular School No Elementary PK 04 2021   kindergarten                                                   58                                             58
2739493 2739493 CT     school 904050 1260011   Shelton School District 90405000796 1261011 Booth Hill School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   54                                             54
2739494 2739494 CT     school 904050 1260011   Shelton School District 90405000803 1260811 Long Hill School Public Schools Regular School No Elementary PK 04 2021   kindergarten                                                   *                                              
2739495 2739495 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2021   kindergarten                                                   0                                             0
2739496 2739496 CT     school 904050 1260011   Shelton School District 90405000003 1260611 Sunnyside School Public Schools Regular School No Elementary PK 04 2021   kindergarten                                                   46                                             46
2739497 2739497 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2021   kindergarten                                                   *                                              
2739498 2739498 CT     school 904050 1260011   Shelton School District 90405000798 1260511 Elizabeth Shelton School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   65                                             65
2739499 2739499 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2021   kindergarten                                                   0                                             0
2739500 2739500 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2021   kindergarten                                                   0                                             0
2739501 2739501 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2021   kindergarten                                                   0                                             0
2739502 2739502 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2021   kindergarten                                                   0                                             0
2739503 2739503 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739504 2739504 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739505 2739505 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2021   kindergarten                                                   0                                             0
2739506 2739506 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   23                                             23
2739508 2739508 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   74                                             74
2739509 2739509 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   40                                             40
2739510 2739510 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   56                                             56
2739511 2739511 CT     school 904110 1280011   Simsbury School District 90411000815 1280311 Tariffville School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   31                                             31
2739512 2739512 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2021   kindergarten                                                   51                                             51
2739513 2739513 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2021   kindergarten                                                   0                                             0
2739514 2739514 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739515 2739515 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2021   kindergarten                                                   0                                             0
2739516 2739516 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   78                                             78
2739517 2739517 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739518 2739518 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2738560 2738560 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   17                                             17
2739528 2739528 CT     school   1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools           2021   kindergarten                                                   0                                             0
2739529 2739529 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 2021   kindergarten                                                   0                                             0
2739530 2739530 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   47                                             47
2739531 2739531 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   94                                             94
2739532 2739532 CT     school 904230 1310011   Southington School District 90423000830 1311311 Flanders Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   49                                             49
2739533 2739533 CT     school 904230 1310011   Southington School District 90423000831 1310211 Hatton Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   44                                             44
2739534 2739534 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2021   kindergarten                                                   *                                              
2739535 2739535 CT     school   1310011   Southington School District 90423001759 1311811 Language Based Classroom, Multihandicapped Program           2021   kindergarten                                                   *                                              
2739536 2739536 CT     school 904230 1310011   Southington School District 90423000836 1310611 Oshana Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   49                                             49
2739537 2739537 CT     school   1310011   Southington School District   1311111 SPACE Program           2021   kindergarten                                                   *                                              
2739538 2739538 CT     school 904230 1310011   Southington School District 90423000837 1310711 South End Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   32                                             32
2739539 2739539 CT     school 904230 1310011   Southington School District 90423000839 1310811 Strong Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   37                                             37
2739540 2739540 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   64                                             64
2739541 2739541 CT     school   1310011   Southington School District 90423001786 1310411 Language Based Classroom at Hatton School Program           2021   kindergarten                                                   0                                             0
2739542 2739542 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739543 2739543 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2021   kindergarten                                                   0                                             0
2739544 2739544 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739545 2739545 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2021   kindergarten                                                   0                                             0
2739546 2739546 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2021   kindergarten                                                   0                                             0
2739547 2739547 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739548 2739548 CT     school   1310011   Southington School District 90423001665 1310111 The Karen Smith Academy Program           2021   kindergarten                                                   0                                             0
2739549 2739549 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2021   kindergarten                                                   0                                             0
2739550 2739550 CT     school   1310011   Southington School District   1312211 STELLAR Program           2021   kindergarten                                                   0                                             0
2739519 2739519 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   *                                              
2739520 2739520 CT     school 904170 1320011   South Windsor School District 90417000821 1320111 Philip R. Smith School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   77                                             77
2739521 2739521 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   *                                              
2739522 2739522 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2021   kindergarten                                                   0                                             0
2739523 2739523 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   77                                             77
2739524 2739524 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739525 2739525 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739526 2739526 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739527 2739527 CT     school   1320011   South Windsor School District 90417001605 1329011 Project Worth Young Adult Academy Program           2021   kindergarten                                                   0                                             0
2739551 2739551 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Elementary PK 08 2021   kindergarten                                                   24                                             24
2739552 2739552 CT     school 904290 1340011   Stafford School District 90429000847 1340311 Staffordville School Public Schools Regular School No Elementary PK 01 2021   kindergarten                                                   43                                             43
2739553 2739553 CT     school 904290 1340011   Stafford School District 90429000848 1340411 West Stafford School Public Schools Regular School No Elementary PK 01 2021   kindergarten                                                   45                                             45

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