enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "grade_6" and state = "CT" sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2441674 | 2441674 | CT | school | 170011 | Bristol School District | 90051001429 | 179011 | Alternative Special Education Program (ASEP) | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441677 | 2441677 | CT | school | 170011 | Bristol School District | 90051001748 | 171011 | Chippens Hill Middle School Functional Program | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441678 | 2441678 | CT | school | 170011 | Bristol School District | 171611 | Chippens Hill Middle School Medically Fragile | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441679 | 2441679 | CT | school | 170011 | Bristol School District | 170811 | Chippens Hilll Middle School Extended Resource | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441680 | 2441680 | CT | school | 170011 | Bristol School District | 90051001753 | 173411 | Chms Goal | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441681 | 2441681 | CT | school | 170011 | Bristol School District | 90051001651 | 172711 | Northeast MS/Extended Resource | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441717 | 2441717 | CT | school | 2410014 | Capitol Region Education Council | 90070001495 | 2419314 | River Street School | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441743 | 2441743 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2441849 | 2441849 | CT | school | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001156 | 2539014 | EastConn Special Education | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441857 | 2441857 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441885 | 2441885 | CT | school | 490011 | Enfield School District | 490911 | John F. Kennedy - Adaptive Learning Program (ALP) | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441917 | 2441917 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2441929 | 2441929 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2441980 | 2441980 | CT | school | 620011 | Hamden School District | 620711 | Alice Peck IIC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2441982 | 2441982 | CT | school | 620011 | Hamden School District | 621511 | Dunbar Hill IIC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442038 | 2442038 | CT | school | 640011 | Hartford School District | 645911 | RISE - M.D. Fox School | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442046 | 2442046 | CT | school | 640011 | Hartford School District | 648911 | iGOAL 1 - McDonough Middle School | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442047 | 2442047 | CT | school | 640011 | Hartford School District | 640110 | iGOAL 1 - Milner School | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442048 | 2442048 | CT | school | 640011 | Hartford School District | 640210 | iGOAL 2 - Kennelly School | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442084 | 2442084 | CT | school | 2450014 | Learn | 2450814 | Learn SAILS Middle School Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442086 | 2442086 | CT | school | 2450014 | Learn | 2451214 | Learn ABA Program at Center School | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442152 | 2442152 | CT | school | 800011 | Meriden School District | 802311 | SOAR - LMS | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442153 | 2442153 | CT | school | 800011 | Meriden School District | 802411 | SOAR - WMS | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442181 | 2442181 | CT | school | 830011 | Middletown School District | 90249001793 | 830411 | ICM- Woodrow Wilson Middle School | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442249 | 2442249 | CT | school | 890011 | New Britain School District | 90267001566 | 899011 | New Britain Transition Center | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442253 | 2442253 | CT | school | 890011 | New Britain School District | 891711 | Slade KEY Middle | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442305 | 2442305 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442306 | 2442306 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442313 | 2442313 | CT | school | 930011 | New Haven School District | 938711 | Fair Haven Self Contained ID | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442314 | 2442314 | CT | school | 930011 | New Haven School District | 937711 | Nathan Hale Self Contained ID | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442317 | 2442317 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442415 | 2442415 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442462 | 2442462 | CT | school | 2010012 | Regional School District 01 | 2010312 | SELC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442523 | 2442523 | CT | school | 1180011 | Ridgefield School District | 1181111 | District Program SRMS | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442595 | 2442595 | CT | school | 1310011 | Southington School District | 90423001720 | 1311611 | Therapeutic Educational Alternative Model (TEAM) | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442652 | 2442652 | CT | school | 1380011 | Stratford School District | 1382811 | STEPS K-6 | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442654 | 2442654 | CT | school | 1380011 | Stratford School District | 1382311 | DLC Whitney | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442656 | 2442656 | CT | school | 1380011 | Stratford School District | 1382711 | ALL Class Room - Second Hill Lane | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442731 | 2442731 | CT | school | 1480011 | Wallingford School District | 1489011 | A.R.T.S. Academy | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442733 | 2442733 | CT | school | 1480011 | Wallingford School District | 1481311 | Inspire Middle School | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442760 | 2442760 | CT | school | 1510011 | Waterbury School District | 1511911 | Carrington ESC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442769 | 2442769 | CT | school | 1510011 | Waterbury School District | 90483000958 | 1519011 | State Street School | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442772 | 2442772 | CT | school | 1510011 | Waterbury School District | 1512411 | Reed ESC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442776 | 2442776 | CT | school | 1510011 | Waterbury School District | 1516811 | Duggan Scope | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442780 | 2442780 | CT | school | 1510011 | Waterbury School District | 1513711 | North End BDLC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442783 | 2442783 | CT | school | 1510011 | Waterbury School District | 1514811 | North End SCOPE | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442784 | 2442784 | CT | school | 1510011 | Waterbury School District | 1514411 | Wallace BDLC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442786 | 2442786 | CT | school | 1510011 | Waterbury School District | 1514911 | Wallace SCOPE | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442788 | 2442788 | CT | school | 1510011 | Waterbury School District | 1514711 | West Side BDLC | Program | 2019 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442844 | 2442844 | CT | school | 1560011 | West Haven School District | 90495001799 | 1560111 | Life Skills | Program | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442845 | 2442845 | CT | school | 1560011 | West Haven School District | 1561111 | ASD Lab | 2019 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747215 | 2747215 | CT | school | 110011 | Bloomfield School District | 110111 | Steps to Success | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747263 | 2747263 | CT | school | 150011 | Bridgeport School District | 90045001472 | 159011 | Bridgeport Learning Center | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747295 | 2747295 | CT | school | 170011 | Bristol School District | 90051001748 | 171011 | Chippens Hill Middle School Functional Program | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747296 | 2747296 | CT | school | 170011 | Bristol School District | 171611 | Chippens Hill Middle School Medically Fragile | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747297 | 2747297 | CT | school | 170011 | Bristol School District | 170811 | Chippens Hilll Middle School Extended Resource | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747298 | 2747298 | CT | school | 170011 | Bristol School District | 90051001753 | 173411 | Chms Goal | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747299 | 2747299 | CT | school | 170011 | Bristol School District | 90051001651 | 172711 | Northeast MS/Extended Resource | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747300 | 2747300 | CT | school | 170011 | Bristol School District | 90051001796 | 172811 | Northeast MS/GOAL | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747325 | 2747325 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000210 | 2413114 | Montessori Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2747332 | 2747332 | CT | school | 2410014 | Capitol Region Education Council | 90070001154 | 2419014 | John J. Allison Polaris Center | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747333 | 2747333 | CT | school | 2410014 | Capitol Region Education Council | 90070001495 | 2419314 | River Street School | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747348 | 2747348 | CT | school | 250011 | Cheshire School District | 250711 | Highland School Autism Program | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747478 | 2747478 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747501 | 2747501 | CT | school | 490011 | Enfield School District | 492411 | Eagle Academy | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747507 | 2747507 | CT | school | 490011 | Enfield School District | 490911 | John F. Kennedy - Adaptive Learning Program (ALP) | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747550 | 2747550 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747552 | 2747552 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2747605 | 2747605 | CT | school | 620011 | Hamden School District | 621911 | Intensive Support Classroom | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747611 | 2747611 | CT | school | 620011 | Hamden School District | 621611 | Helen Street IIC | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747612 | 2747612 | CT | school | 620011 | Hamden School District | 621811 | West Woods IIC | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747613 | 2747613 | CT | school | 620011 | Hamden School District | 621511 | Dunbar Hill IIC | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747614 | 2747614 | CT | school | 620011 | Hamden School District | 621311 | Church Street IIC | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747661 | 2747661 | CT | school | 640011 | Hartford School District | 640210 | iGOAL 2 - Kennelly School | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747668 | 2747668 | CT | school | 640011 | Hartford School District | 641310 | RISE - M.L. King Middle School | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747670 | 2747670 | CT | school | 640011 | Hartford School District | 640110 | iGOAL 1 - Milner School | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747699 | 2747699 | CT | school | 2450014 | Learn | 90345001680 | 2451114 | Learn Intensive Program | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747700 | 2747700 | CT | school | 2450014 | Learn | 2451614 | LEARN SAILS Program | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747736 | 2747736 | CT | school | 770011 | Manchester School District | 771511 | Manchester Middle Academy | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747761 | 2747761 | CT | school | 800011 | Meriden School District | 802311 | SOAR - LMS | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747762 | 2747762 | CT | school | 800011 | Meriden School District | 802411 | SOAR - WMS | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747763 | 2747763 | CT | school | 800011 | Meriden School District | 801511 | STARS-MS | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747790 | 2747790 | CT | school | 830011 | Middletown School District | 90249001793 | 830411 | ICM- Woodrow Wilson Middle School | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747859 | 2747859 | CT | school | 890011 | New Britain School District | 90267001566 | 899011 | New Britain Transition Center | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747914 | 2747914 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747915 | 2747915 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747916 | 2747916 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747918 | 2747918 | CT | school | 930011 | New Haven School District | 937511 | East Rock Self Contained MD | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747919 | 2747919 | CT | school | 930011 | New Haven School District | 938711 | Fair Haven Self Contained ID | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747926 | 2747926 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747972 | 2747972 | CT | school | 970011 | Newtown School District | 970711 | Reaching Independence through Structured Education | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748029 | 2748029 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748033 | 2748033 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000681 | 1060211 | Kathleen E. Goodwin School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2748167 | 2748167 | CT | school | 904050 | 1260011 | Shelton School District | 90405000801 | 1265111 | Intermediate School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2748207 | 2748207 | CT | school | 1310011 | Southington School District | 90423001668 | 1310511 | EASE | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748209 | 2748209 | CT | school | 1310011 | Southington School District | 90423001720 | 1311611 | Therapeutic Educational Alternative Model (TEAM) | Program | 2021 | grade_6 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748264 | 2748264 | CT | school | 1380011 | Stratford School District | 1382311 | DLC Whitney | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748265 | 2748265 | CT | school | 1380011 | Stratford School District | 1382811 | STEPS K-6 | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748267 | 2748267 | CT | school | 1380011 | Stratford School District | 1382711 | ALL Class Room - Second Hill Lane | Program | 2021 | grade_6 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748343 | 2748343 | CT | school | 1480011 | Wallingford School District | 1481511 | Ben Haven ABC Middle School Program | Program | 2021 | grade_6 | * |
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]);