enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "grade_7" and state = "CT" sorted by total_int
This data as json, CSV (advanced)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2749475 | 2749475 | CT | school | 1040011 | Norwich School District | 90312001622 | 1049211 | Virtual Learning Academy | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749580 | 2749580 | CT | school | 1180011 | Ridgefield School District | 1181011 | District Program ERMS | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749581 | 2749581 | CT | school | 1180011 | Ridgefield School District | 1181111 | District Program SRMS | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749611 | 2749611 | CT | school | 904050 | 1260011 | Shelton School District | 90405000801 | 1265111 | Intermediate School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2749651 | 2749651 | CT | school | 1310011 | Southington School District | 90423001668 | 1310511 | EASE | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749653 | 2749653 | CT | school | 1310011 | Southington School District | 90423001720 | 1311611 | Therapeutic Educational Alternative Model (TEAM) | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749686 | 2749686 | CT | school | 1350011 | Stamford School District | 90432001744 | 1350411 | Anchor | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749714 | 2749714 | CT | school | 1380011 | Stratford School District | 90444001756 | 1381811 | Middle School Sails | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749715 | 2749715 | CT | school | 1380011 | Stratford School District | 90444001706 | 1381911 | STEPS 7-8 | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749787 | 2749787 | CT | school | 1480011 | Wallingford School District | 1481511 | Ben Haven ABC Middle School Program | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749789 | 2749789 | CT | school | 1480011 | Wallingford School District | 1481311 | Inspire Middle School | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749826 | 2749826 | CT | school | 1510011 | Waterbury School District | 1512411 | Reed ESC | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749831 | 2749831 | CT | school | 1510011 | Waterbury School District | 1512911 | North End Autism | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749835 | 2749835 | CT | school | 1510011 | Waterbury School District | 1514811 | North End SCOPE | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749836 | 2749836 | CT | school | 1510011 | Waterbury School District | 1514411 | Wallace BDLC | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749838 | 2749838 | CT | school | 1510011 | Waterbury School District | 1514911 | Wallace SCOPE | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749840 | 2749840 | CT | school | 1510011 | Waterbury School District | 1514711 | West Side BDLC | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749843 | 2749843 | CT | school | 1510011 | Waterbury School District | 1515511 | West Side SCOPE | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749844 | 2749844 | CT | school | 1510011 | Waterbury School District | 90483001418 | 1519111 | Enlightenment School | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749845 | 2749845 | CT | school | 1510011 | Waterbury School District | 1511811 | North End ESC | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749898 | 2749898 | CT | school | 1560011 | West Haven School District | 90495001799 | 1560111 | Life Skills | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749938 | 2749938 | CT | school | 1610011 | Wilton School District | 1610211 | Genesis | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749989 | 2749989 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2750010 | 2750010 | CT | school | 3470015 | Unified School District #2 | 90000400475 | 3470115 | Children's Place School | State Agency Facilities | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2750018 | 2750018 | CT | school | 2070012 | Regional School District 07 | 90372001399 | 2079012 | FLEX | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768974 | 2768974 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769080 | 2769080 | CT | school | 170011 | Bristol School District | 90051001429 | 179011 | Alternative Special Education Program (ASEP) | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769085 | 2769085 | CT | school | 170011 | Bristol School District | 90051001748 | 171011 | Chippens Hill Middle School Functional Program | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769086 | 2769086 | CT | school | 170011 | Bristol School District | 171611 | Chippens Hill Middle School Medically Fragile | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769087 | 2769087 | CT | school | 170011 | Bristol School District | 170811 | Chippens Hilll Middle School Extended Resource | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769088 | 2769088 | CT | school | 170011 | Bristol School District | 90051001753 | 173411 | Chms Goal | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769090 | 2769090 | CT | school | 170011 | Bristol School District | 90051001651 | 172711 | Northeast MS/Extended Resource | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769091 | 2769091 | CT | school | 170011 | Bristol School District | 90051001796 | 172811 | Northeast MS/GOAL | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769122 | 2769122 | CT | school | 2410014 | Capitol Region Education Council | 90070001154 | 2419014 | John J. Allison Polaris Center | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769208 | 2769208 | CT | school | 370011 | Derby School District | 370511 | RAISE Academy | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769291 | 2769291 | CT | school | 490011 | Enfield School District | 490911 | John F. Kennedy - Adaptive Learning Program (ALP) | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769293 | 2769293 | CT | school | 490011 | Enfield School District | 492311 | Enfield Alternative Education Program | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769334 | 2769334 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769445 | 2769445 | CT | school | 640011 | Hartford School District | 645911 | RISE - M.D. Fox School | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769448 | 2769448 | CT | school | 640011 | Hartford School District | 640210 | iGOAL 2 - Kennelly School | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769457 | 2769457 | CT | school | 640011 | Hartford School District | 640910 | New Visions | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769484 | 2769484 | CT | school | 2450014 | Learn | 90345001680 | 2451114 | Learn Intensive Program | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769489 | 2769489 | CT | school | 2450014 | Learn | 2450814 | Learn SAILS Middle School Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769527 | 2769527 | CT | school | 770011 | Manchester School District | 90231000427 | 779011 | Manchester Regional Academy | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769550 | 2769550 | CT | school | 800011 | Meriden School District | 802311 | SOAR - LMS | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769551 | 2769551 | CT | school | 800011 | Meriden School District | 802411 | SOAR - WMS | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769579 | 2769579 | CT | school | 830011 | Middletown School District | 90249001793 | 830411 | ICM- Woodrow Wilson Middle School | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769649 | 2769649 | CT | school | 890011 | New Britain School District | 90267001566 | 899011 | New Britain Transition Center | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769652 | 2769652 | CT | school | 890011 | New Britain School District | 891711 | Slade KEY Middle | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769678 | 2769678 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769702 | 2769702 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769703 | 2769703 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769706 | 2769706 | CT | school | 930011 | New Haven School District | 937511 | East Rock Self Contained MD | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769816 | 2769816 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769923 | 2769923 | CT | school | 1180011 | Ridgefield School District | 1181111 | District Program SRMS | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770059 | 2770059 | CT | school | 1380011 | Stratford School District | 90444001756 | 1381811 | Middle School Sails | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770060 | 2770060 | CT | school | 1380011 | Stratford School District | 90444001706 | 1381911 | STEPS 7-8 | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770074 | 2770074 | CT | school | 1400011 | Thomaston School District | 1400311 | PATHS | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770133 | 2770133 | CT | school | 1480011 | Wallingford School District | 1489011 | A.R.T.S. Academy | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770134 | 2770134 | CT | school | 1480011 | Wallingford School District | 1481511 | Ben Haven ABC Middle School Program | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770137 | 2770137 | CT | school | 1480011 | Wallingford School District | 1481311 | Inspire Middle School | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770172 | 2770172 | CT | school | 1510011 | Waterbury School District | 1512411 | Reed ESC | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770183 | 2770183 | CT | school | 1510011 | Waterbury School District | 1513711 | North End BDLC | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770185 | 2770185 | CT | school | 1510011 | Waterbury School District | 1511811 | North End ESC | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770187 | 2770187 | CT | school | 1510011 | Waterbury School District | 1514811 | North End SCOPE | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770188 | 2770188 | CT | school | 1510011 | Waterbury School District | 1514411 | Wallace BDLC | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770190 | 2770190 | CT | school | 1510011 | Waterbury School District | 1514911 | Wallace SCOPE | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770192 | 2770192 | CT | school | 1510011 | Waterbury School District | 1514711 | West Side BDLC | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770194 | 2770194 | CT | school | 1510011 | Waterbury School District | 1515511 | West Side SCOPE | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770248 | 2770248 | CT | school | 1560011 | West Haven School District | 90495001799 | 1560111 | Life Skills | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770249 | 2770249 | CT | school | 1560011 | West Haven School District | 1561111 | ASD Lab | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770343 | 2770343 | CT | school | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001156 | 2539014 | EastConn Special Education | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770351 | 2770351 | CT | school | 2010012 | Regional School District 01 | 2010312 | SELC | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770365 | 2770365 | CT | school | 2070012 | Regional School District 07 | 90372001401 | 2079212 | Links | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443004 | 2443004 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443005 | 2443005 | CT | school | 20011 | Ansonia School District | 20911 | Ansonia Public Schools Pre-K Program | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443006 | 2443006 | CT | school | 900060 | 20011 | Ansonia School District | 90006000005 | 20311 | Mead School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443007 | 2443007 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443009 | 2443009 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443010 | 2443010 | CT | school | 20011 | Ansonia School District | 90006001678 | 20111 | P.A.C.E. (Positive And Creative Education) | Program | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443011 | 2443011 | CT | school | 20011 | Ansonia School District | 20411 | P.A.C.E. - PM (Positive And Creative Education - PM) | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443013 | 2443013 | CT | school | 2440014 | Area Cooperative Educational Services | 2440214 | ACES Mill Elementary School | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443018 | 2443018 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001502 | 2449214 | Whitney Academy | Program | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443019 | 2443019 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001490 | 2449114 | Whitney High School North | Program | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443020 | 2443020 | CT | school | 2440014 | Area Cooperative Educational Services | 2449314 | Whitney High School West | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443021 | 2443021 | CT | school | 2440014 | Area Cooperative Educational Services | 2440114 | CREATE at Whitney Academy | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443023 | 2443023 | CT | school | 40011 | Avon School District | 90012001737 | 40111 | Avon Early Learning Center at Roaring Brook School | Program | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443024 | 2443024 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443025 | 2443025 | CT | school | 900120 | 40011 | Avon School District | 90012000013 | 40311 | Roaring Brook School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443026 | 2443026 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443028 | 2443028 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443029 | 2443029 | CT | school | 900150 | 50011 | Barkhamsted School District | 90015000015 | 50111 | Barkhamsted Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443030 | 2443030 | CT | school | 50011 | Barkhamsted School District | 90015001373 | 58011 | Shared Services Integrated Preschool | Program | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443031 | 2443031 | CT | school | 50011 | Barkhamsted School District | 50211 | Bridges at Barkhamsted Elementary School | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443032 | 2443032 | CT | school | 900210 | 70011 | Berlin School District | 90021000018 | 70411 | Emma Hart Willard School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443033 | 2443033 | CT | school | 900210 | 70011 | Berlin School District | 90021000020 | 70511 | Mary E. Griswold School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443034 | 2443034 | CT | school | 900210 | 70011 | Berlin School District | 90021000021 | 70111 | Richard D. Hubbard School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443036 | 2443036 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443037 | 2443037 | CT | school | 70011 | Berlin School District | 70311 | Transition Academy | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443038 | 2443038 | CT | school | 900240 | 80011 | Bethany School District | 90024000022 | 80111 | Bethany Community School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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]);