enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "grade_7", state = "CT" and year = 2020 sorted by school_nces_id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2769561 | 2769561 | CT | school | 800011 | Meriden School District | 801611 | TSC - MHS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769562 | 2769562 | CT | school | 800011 | Meriden School District | 801711 | TSC - PHS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769563 | 2769563 | CT | school | 800011 | Meriden School District | 802511 | SOAR - PHS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769564 | 2769564 | CT | school | 800011 | Meriden School District | 801411 | Success Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769566 | 2769566 | CT | school | 800011 | Meriden School District | 802111 | Community Collaborative Classroom - ACADEMY | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769578 | 2769578 | CT | school | 830011 | Middletown School District | 832011 | ICM - Spencer | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769587 | 2769587 | CT | school | 830011 | Middletown School District | 832211 | MHS- Alternative Education Program 3 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769603 | 2769603 | CT | school | 840011 | Milford School District | 840411 | Fifth Year Vocational Experience | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769604 | 2769604 | CT | school | 840011 | Milford School District | 840611 | Post Grad Transitional Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769618 | 2769618 | CT | school | 860011 | Montville School District | 860611 | Montville Transition and Vocational Training Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769630 | 2769630 | CT | school | 880011 | Naugatuck School District | 880911 | Genesis Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769631 | 2769631 | CT | school | 880011 | Naugatuck School District | 881011 | Naugatuck Community Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769635 | 2769635 | CT | school | 890011 | New Britain School District | 891611 | Gaffney KEY Elementary | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769636 | 2769636 | CT | school | 890011 | New Britain School District | 890111 | Roosevelt Early Learning Center | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769644 | 2769644 | CT | school | 890011 | New Britain School District | 891911 | Smith Pathways | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769646 | 2769646 | CT | school | 890011 | New Britain School District | 890211 | Chamberlain Bridges | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769647 | 2769647 | CT | school | 890011 | New Britain School District | 890411 | Holmes Bridges | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769648 | 2769648 | CT | school | 890011 | New Britain School District | 891011 | Lincoln SCS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769652 | 2769652 | CT | school | 890011 | New Britain School District | 891711 | Slade KEY Middle | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769656 | 2769656 | CT | school | 890011 | New Britain School District | 899511 | New Britain High School Satellite Careers Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769663 | 2769663 | CT | school | 900011 | New Canaan School District | 900111 | Launch | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769675 | 2769675 | CT | school | 930011 | New Haven School District | 933411 | Benjamin Jepson Head Start | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769678 | 2769678 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769683 | 2769683 | CT | school | 930011 | New Haven School District | 932711 | Dr. Reginald Mayo Early Learning Center | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769690 | 2769690 | CT | school | 930011 | New Haven School District | 930510 | Lincoln Bassett Integrated PK | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769697 | 2769697 | CT | school | 930011 | New Haven School District | 930410 | West Rock Integrated PK | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769700 | 2769700 | CT | school | 930011 | New Haven School District | 937611 | Barack H. Obama Self Contained Autism | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769705 | 2769705 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769706 | 2769706 | CT | school | 930011 | New Haven School District | 937511 | East Rock Self Contained MD | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769707 | 2769707 | CT | school | 930011 | New Haven School District | 938711 | Fair Haven Self Contained ID | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769708 | 2769708 | CT | school | 930011 | New Haven School District | 930310 | Lincoln Bassett Self Contained | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769709 | 2769709 | CT | school | 930011 | New Haven School District | 937711 | Nathan Hale Self Contained ID | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769712 | 2769712 | CT | school | 930011 | New Haven School District | 938411 | West Rock Self Contained Autism | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769715 | 2769715 | CT | school | 930011 | New Haven School District | 938611 | Wexler Grant Self Contained | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769727 | 2769727 | CT | school | 930011 | New Haven School District | 930110 | Gateway to College Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769728 | 2769728 | CT | school | 930011 | New Haven School District | 930210 | James Hillhouse Self Contained MD | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769729 | 2769729 | CT | school | 930011 | New Haven School District | 937311 | Off-Campus Classroom Program (OCC) | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769730 | 2769730 | CT | school | 930011 | New Haven School District | 938511 | Wilbur Cross Self Contained MD | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769733 | 2769733 | CT | school | 950011 | New London School District | 950711 | Pre-Kindergarten at Winthrop | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769761 | 2769761 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769797 | 2769797 | CT | school | 1030011 | Norwalk School District | 1031011 | Norwalk Alternative Opportunity Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769800 | 2769800 | CT | school | 1030011 | Norwalk School District | 1031111 | Norwalk 18-21 Next Steps (NNS) | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769801 | 2769801 | CT | school | 1030011 | Norwalk School District | 1030611 | Norwalk 18-21 Project SEARCH | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769811 | 2769811 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769812 | 2769812 | CT | school | 1040011 | Norwich School District | 1040911 | Stanton Special Learning Center | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769813 | 2769813 | CT | school | 1040011 | Norwich School District | 1040411 | Strive Autism Program @ Huntington | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769814 | 2769814 | CT | school | 1040011 | Norwich School District | 1041211 | Strive Program @ Stanton | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769816 | 2769816 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769819 | 2769819 | CT | school | 1040011 | Norwich School District | 1041011 | Transition Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769831 | 2769831 | CT | school | 1080011 | Oxford School District | 1080411 | Connections Alternative Learning Center | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769832 | 2769832 | CT | school | 1080011 | Oxford School District | 1080511 | Community Explorations | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769844 | 2769844 | CT | school | 1100011 | Plainville School District | 1100111 | Plainville Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769867 | 2769867 | CT | school | 2060012 | Regional School District 06 | 2060412 | Wamogo Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769876 | 2769876 | CT | school | 2120012 | Regional School District 12 | 2120512 | Shepaug Valley Partnership | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769887 | 2769887 | CT | school | 2140012 | Regional School District 14 | 2140412 | Region 14 Transition Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769895 | 2769895 | CT | school | 2150012 | Regional School District 15 | 2150112 | MIJ Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769906 | 2769906 | CT | school | 2170012 | Regional School District 17 | 2170412 | RSD17 Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769912 | 2769912 | CT | school | 2180012 | Regional School District 18 | 2180412 | Alternative Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769917 | 2769917 | CT | school | 1180011 | Ridgefield School District | 1181211 | District Program FES | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769918 | 2769918 | CT | school | 1180011 | Ridgefield School District | 1180711 | District Program RES | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769921 | 2769921 | CT | school | 1180011 | Ridgefield School District | 1180911 | District Program SES | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769922 | 2769922 | CT | school | 1180011 | Ridgefield School District | 1181011 | District Program ERMS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769923 | 2769923 | CT | school | 1180011 | Ridgefield School District | 1181111 | District Program SRMS | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769926 | 2769926 | CT | school | 1180011 | Ridgefield School District | 1181311 | District Program RHS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769935 | 2769935 | CT | school | 1190011 | Rocky Hill School District | 1190311 | Pathways | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769936 | 2769936 | CT | school | 1190011 | Rocky Hill School District | 1190711 | Rocky Hill DREAM Transition Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769949 | 2769949 | CT | school | 1260011 | Shelton School District | 1260111 | Pre-Kindergarten | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769951 | 2769951 | CT | school | 1260011 | Shelton School District | 1260211 | Alternative Learning Center 1 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769952 | 2769952 | CT | school | 1260011 | Shelton School District | 1261311 | Alternative Learning Center 2 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769953 | 2769953 | CT | school | 1260011 | Shelton School District | 1261211 | Therapeutic Learning Center | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769954 | 2769954 | CT | school | 1260011 | Shelton School District | 1260311 | Life Skills | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769958 | 2769958 | CT | school | 1260011 | Shelton School District | 1260711 | Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769968 | 2769968 | CT | school | 1280011 | Simsbury School District | 1280211 | Farmington Valley Transition Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769974 | 2769974 | CT | school | 1320011 | South Windsor School District | 1320511 | Preschool Outreach Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769987 | 2769987 | CT | school | 1310011 | Southington School District | 1312311 | Language Based Classroom II | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770002 | 2770002 | CT | school | 1310011 | Southington School District | 1312211 | STELLAR | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770022 | 2770022 | CT | school | 1350011 | Stamford School District | 1351011 | Strawberry Hill Special | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770036 | 2770036 | CT | school | 1350011 | Stamford School District | 1351311 | PAVE (Post-Secondary Adaptive Vocational Experience) | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770041 | 2770041 | CT | school | 1370011 | Stonington School District | 1370911 | The Learning Annex | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770043 | 2770043 | CT | school | 1370011 | Stonington School District | 1370711 | SAILS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770049 | 2770049 | CT | school | 1380011 | Stratford School District | 1382311 | DLC Whitney | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770053 | 2770053 | CT | school | 1380011 | Stratford School District | 1382811 | STEPS K-6 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770056 | 2770056 | CT | school | 1380011 | Stratford School District | 1382711 | ALL Class Room - Second Hill Lane | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770062 | 2770062 | CT | school | 1380011 | Stratford School District | 1380111 | BRIDGES 9-12 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770074 | 2770074 | CT | school | 1400011 | Thomaston School District | 1400311 | PATHS | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770084 | 2770084 | CT | school | 1420011 | Tolland School District | 1420611 | Tolland Transition Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770086 | 2770086 | CT | school | 1430011 | Torrington School District | 1430611 | TPS Preschool Lab | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770093 | 2770093 | CT | school | 1430011 | Torrington School District | 1430311 | Post Secondary Transition Services | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770106 | 2770106 | CT | school | 1440011 | Trumbull School District | 1440611 | Educating Learners in Transitional Environments (ELITE) | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770112 | 2770112 | CT | school | 1460011 | Vernon School District | 1461111 | Elementary Activities Based Learning Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770114 | 2770114 | CT | school | 1460011 | Vernon School District | 1460811 | Renaissance Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770123 | 2770123 | CT | school | 1480011 | Wallingford School District | 1480711 | STARS Primary Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770124 | 2770124 | CT | school | 1480011 | Wallingford School District | 1481611 | WISE Primary Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770125 | 2770125 | CT | school | 1480011 | Wallingford School District | 1481411 | Ben Haven ABC Primary Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770126 | 2770126 | CT | school | 1480011 | Wallingford School District | 1480611 | Benhaven ABC Intermediate Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770131 | 2770131 | CT | school | 1480011 | Wallingford School District | 1481111 | STARS Intermediate Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | * |
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]);