enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,361 ✖

grade ✖

  • kindergarten · 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
2759631 2759631 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759632 2759632 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759633 2759633 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2020   kindergarten                                                   0                                             0
2759634 2759634 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2020   kindergarten                                                   90                                             90
2759635 2759635 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2020   kindergarten                                                   0                                             0
2759686 2759686 CT     school 903810 1180011   Ridgefield School District 90381001467 1180811 Barlow Mountain Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   46                                             46
2759687 2759687 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   53                                             53
2759688 2759688 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   47                                             47
2759689 2759689 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   53                                             53
2759690 2759690 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2020   kindergarten                                                   *                                              
2759691 2759691 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2020   kindergarten                                                   *                                              
2759692 2759692 CT     school 903810 1180011   Ridgefield School District 90381000777 1180411 Farmingville Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   42                                             42
2759693 2759693 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   36                                             36
2759694 2759694 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2020   kindergarten                                                   0                                             0
2759695 2759695 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2020   kindergarten                                                   0                                             0
2759696 2759696 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2020   kindergarten                                                   0                                             0
2759697 2759697 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759698 2759698 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759699 2759699 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2020   kindergarten                                                   0                                             0
2759700 2759700 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759701 2759701 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2020   kindergarten                                                   0                                             0
2759702 2759702 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2020   kindergarten                                                   0                                             0
2759703 2759703 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 03 2020   kindergarten                                                   88                                             88
2759704 2759704 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 03 2020   kindergarten                                                   118                                             118
2759705 2759705 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2020   kindergarten                                                   0                                             0
2759706 2759706 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759707 2759707 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759708 2759708 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2020   kindergarten                                                   0                                             0
2759709 2759709 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2020   kindergarten                                                   0                                             0
2758784 2758784 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   39                                             39
2758785 2758785 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2758786 2758786 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2020   kindergarten                                                   0                                             0
2759710 2759710 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   52                                             52
2759711 2759711 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   40                                             40
2759712 2759712 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   8                                             8
2759713 2759713 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   92                                             92
2759714 2759714 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   73                                             73
2759715 2759715 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759716 2759716 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759717 2759717 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   15                                             15
2759718 2759718 CT     school 904050 1260011   Shelton School District 90405000804 1260911 Mohegan School Public Schools Regular School No Elementary PK 04 2020   kindergarten                                                   64                                             64
2759719 2759719 CT     school 904050 1260011   Shelton School District 90405000796 1261011 Booth Hill School Public Schools Regular School No Elementary PK 04 2020   kindergarten                                                   *                                              
2759720 2759720 CT     school 904050 1260011   Shelton School District 90405000798 1260511 Elizabeth Shelton School Public Schools Regular School No Elementary PK 04 2020   kindergarten                                                   83                                             83
2759721 2759721 CT     school 904050 1260011   Shelton School District 90405000803 1260811 Long Hill School Public Schools Regular School No Elementary PK 04 2020   kindergarten                                                   68                                             68
2759722 2759722 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2020   kindergarten                                                   0                                             0
2759723 2759723 CT     school 904050 1260011   Shelton School District 90405000003 1260611 Sunnyside School Public Schools Regular School No Elementary PK 04 2020   kindergarten                                                   61                                             61
2759724 2759724 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2020   kindergarten                                                   *                                              
2759725 2759725 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2020   kindergarten                                                   *                                              
2759726 2759726 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2020   kindergarten                                                   0                                             0
2759727 2759727 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2020   kindergarten                                                   0                                             0
2759728 2759728 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2020   kindergarten                                                   0                                             0
2759729 2759729 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
2759730 2759730 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759731 2759731 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2020   kindergarten                                                   0                                             0
2759732 2759732 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   11                                             11
2759734 2759734 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   91                                             91
2759735 2759735 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2020   kindergarten                                                   51                                             51
2759736 2759736 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2020   kindergarten                                                   68                                             68
2759737 2759737 CT     school 904110 1280011   Simsbury School District 90411000815 1280311 Tariffville School Public Schools Regular School No Elementary KG 06 2020   kindergarten                                                   29                                             29
2759738 2759738 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2020   kindergarten                                                   44                                             44
2759739 2759739 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
2759740 2759740 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759741 2759741 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2020   kindergarten                                                   0                                             0
2759742 2759742 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   91                                             91
2759743 2759743 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759744 2759744 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2758787 2758787 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   14                                             14
2759754 2759754 CT     school   1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools           2020   kindergarten                                                   0                                             0
2759755 2759755 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   kindergarten                                                   0                                             0
2759756 2759756 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   49                                             49
2759757 2759757 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   93                                             93
2759758 2759758 CT     school 904230 1310011   Southington School District 90423000830 1311311 Flanders Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   53                                             53
2759759 2759759 CT     school 904230 1310011   Southington School District 90423000831 1310211 Hatton Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   54                                             54
2759760 2759760 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2020   kindergarten                                                   *                                              
2759761 2759761 CT     school   1310011   Southington School District 90423001759 1311811 Language Based Classroom, Multihandicapped Program           2020   kindergarten                                                   *                                              
2759762 2759762 CT     school 904230 1310011   Southington School District 90423000836 1310611 Oshana Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   35                                             35
2759763 2759763 CT     school 904230 1310011   Southington School District 90423000837 1310711 South End Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   40                                             40
2759764 2759764 CT     school 904230 1310011   Southington School District 90423000839 1310811 Strong Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   46                                             46
2759765 2759765 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   72                                             72
2759766 2759766 CT     school   1310011   Southington School District 90423001786 1310411 Language Based Classroom at Hatton School Program           2020   kindergarten                                                   0                                             0
2759767 2759767 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759768 2759768 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2020   kindergarten                                                   0                                             0
2759769 2759769 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759770 2759770 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2020   kindergarten                                                   0                                             0
2759771 2759771 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2020   kindergarten                                                   0                                             0
2759772 2759772 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2020   kindergarten                                                   0                                             0
2759773 2759773 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759774 2759774 CT     school   1310011   Southington School District 90423001665 1310111 The Karen Smith Academy Program           2020   kindergarten                                                   0                                             0
2759775 2759775 CT     school   1310011   Southington School District   1312211 STELLAR Program           2020   kindergarten                                                   0                                             0
2759745 2759745 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   83                                             83
2759746 2759746 CT     school 904170 1320011   South Windsor School District 90417000821 1320111 Philip R. Smith School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   *                                              
2759747 2759747 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2020   kindergarten                                                   0                                             0
2759748 2759748 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   87                                             87
2759749 2759749 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   99                                             99
2759750 2759750 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759751 2759751 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759752 2759752 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759753 2759753 CT     school   1320011   South Windsor School District 90417001605 1329011 Project Worth Young Adult Academy Program           2020   kindergarten                                                   0                                             0
2759776 2759776 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Elementary PK 08 2020   kindergarten                                                   28                                             28
2759777 2759777 CT     school 904290 1340011   Stafford School District 90429000847 1340311 Staffordville School Public Schools Regular School No Elementary PK 01 2020   kindergarten                                                   43                                             43

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