enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "grade_5" 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2746292 | 2746292 | CT | school | 770011 | Manchester School District | 771511 | Manchester Middle Academy | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746313 | 2746313 | CT | school | 800011 | Meriden School District | 802211 | SOAR- ES | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746344 | 2746344 | CT | school | 830011 | Middletown School District | 90249001652 | 830711 | ICM - Moody 3-5 | Program | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746345 | 2746345 | CT | school | 830011 | Middletown School District | 832011 | ICM - Spencer | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746405 | 2746405 | CT | school | 890011 | New Britain School District | 890211 | Chamberlain Bridges | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746408 | 2746408 | CT | school | 890011 | New Britain School District | 892011 | Lincoln KEY Elementary | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746413 | 2746413 | CT | school | 890011 | New Britain School District | 891911 | Smith Pathways | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746417 | 2746417 | CT | school | 890011 | New Britain School District | 891011 | Lincoln SCS | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746470 | 2746470 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746472 | 2746472 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746474 | 2746474 | CT | school | 930011 | New Haven School District | 937511 | East Rock Self Contained MD | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746475 | 2746475 | CT | school | 930011 | New Haven School District | 938711 | Fair Haven Self Contained ID | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746476 | 2746476 | CT | school | 930011 | New Haven School District | 937711 | Nathan Hale Self Contained ID | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746482 | 2746482 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746483 | 2746483 | CT | school | 930011 | New Haven School District | 938611 | Wexler Grant Self Contained | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746578 | 2746578 | CT | school | 1040011 | Norwich School District | 1040411 | Strive Autism Program @ Huntington | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746583 | 2746583 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746634 | 2746634 | CT | school | 903515 | 2060012 | Regional School District 06 | 90351500726 | 2060312 | Warren Elementary School | Regional Schools | Regular School | No | Elementary | PK | 06 | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2746688 | 2746688 | CT | school | 1180011 | Ridgefield School District | 1180711 | District Program RES | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746689 | 2746689 | CT | school | 1180011 | Ridgefield School District | 1180911 | District Program SES | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746755 | 2746755 | CT | school | 1310011 | Southington School District | 90423001759 | 1311811 | Language Based Classroom, Multihandicapped | Program | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746761 | 2746761 | CT | school | 1310011 | Southington School District | 90423001786 | 1310411 | Language Based Classroom at Hatton School | Program | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746820 | 2746820 | CT | school | 1380011 | Stratford School District | 1382311 | DLC Whitney | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746852 | 2746852 | CT | school | 904590 | 1430011 | Torrington School District | 90459000917 | 1430211 | Forbes School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2746874 | 2746874 | CT | school | 904650 | 1450011 | Union School District | 90465000938 | 1450111 | Union School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2746879 | 2746879 | CT | school | 1460011 | Vernon School District | 1461111 | Elementary Activities Based Learning Program | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746881 | 2746881 | CT | school | 1460011 | Vernon School District | 1460811 | Renaissance Program | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746897 | 2746897 | CT | school | 1480011 | Wallingford School District | 1481111 | STARS Intermediate Program | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746898 | 2746898 | CT | school | 1480011 | Wallingford School District | 90474001595 | 1489211 | WISE Intermediate Program | Program | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746925 | 2746925 | CT | school | 1510011 | Waterbury School District | 1514611 | Bucks Hill Autism | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746932 | 2746932 | CT | school | 1510011 | Waterbury School District | 1513511 | Generali Autism | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746938 | 2746938 | CT | school | 1510011 | Waterbury School District | 1512411 | Reed ESC | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746941 | 2746941 | CT | school | 1510011 | Waterbury School District | 1511211 | Woodrow Wilson BDLC | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746968 | 2746968 | CT | school | 1520011 | Waterford School District | 1521111 | Autism Class | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746989 | 2746989 | CT | school | 1550011 | West Hartford School District | 90492001681 | 1559411 | Norfeldt Learning Center | Program | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2746991 | 2746991 | CT | school | 1550011 | West Hartford School District | 90492001780 | 1559511 | Whiting Lane Learning Center | Program | 2021 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747029 | 2747029 | CT | school | 1580011 | Westport School District | 1580111 | LLS Intensive Resource | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747032 | 2747032 | CT | school | 1580011 | Westport School District | 1580211 | GFS Intensive Resource | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747035 | 2747035 | CT | school | 1590011 | Wethersfield School District | 1590411 | ABA | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2747060 | 2747060 | CT | school | 1630011 | Windham School District | 1631111 | Sweeney ASD Program | Program | 2021 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766049 | 2766049 | CT | school | 2440014 | Area Cooperative Educational Services | 2440414 | ACES at Mead Elementary School | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766082 | 2766082 | CT | school | 110011 | Bloomfield School District | 110111 | Steps to Success | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766151 | 2766151 | CT | school | 170011 | Bristol School District | 90051001755 | 173011 | South Side Extended Resource | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766158 | 2766158 | CT | school | 170011 | Bristol School District | 90051001429 | 179011 | Alternative Special Education Program (ASEP) | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766159 | 2766159 | CT | school | 170011 | Bristol School District | 173711 | Hubbell Autism Program | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766160 | 2766160 | CT | school | 170011 | Bristol School District | 90051001711 | 173111 | South Side GOAL | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766201 | 2766201 | CT | school | 2410014 | Capitol Region Education Council | 90070001495 | 2419314 | River Street School | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766218 | 2766218 | CT | school | 250011 | Cheshire School District | 250711 | Highland School Autism Program | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766340 | 2766340 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766366 | 2766366 | CT | school | 490011 | Enfield School District | 491411 | Eli Whitney - Intermediate Adaptive Learning (IAL) | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766368 | 2766368 | CT | school | 490011 | Enfield School District | 90147001702 | 490711 | Prudence Crandall - Educational Counseling Program (ECP) | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766401 | 2766401 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2766412 | 2766412 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766465 | 2766465 | CT | school | 620011 | Hamden School District | 620711 | Alice Peck IIC | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766475 | 2766475 | CT | school | 620011 | Hamden School District | 621311 | Church Street IIC | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766517 | 2766517 | CT | school | 640011 | Hartford School District | 644711 | iGOAL 1 - Burns School | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766520 | 2766520 | CT | school | 640011 | Hartford School District | 90192001673 | 644411 | iGOAL 1 - Rawson School | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766526 | 2766526 | CT | school | 640011 | Hartford School District | 640210 | iGOAL 2 - Kennelly School | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766562 | 2766562 | CT | school | 2450014 | Learn | 90345001680 | 2451114 | Learn Intensive Program | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766564 | 2766564 | CT | school | 2450014 | Learn | 2451614 | LEARN SAILS Program | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766624 | 2766624 | CT | school | 800011 | Meriden School District | 802211 | SOAR- ES | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766625 | 2766625 | CT | school | 800011 | Meriden School District | 800611 | STARS - ES | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766655 | 2766655 | CT | school | 830011 | Middletown School District | 90249001652 | 830711 | ICM - Moody 3-5 | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766656 | 2766656 | CT | school | 830011 | Middletown School District | 832011 | ICM - Spencer | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766724 | 2766724 | CT | school | 890011 | New Britain School District | 890211 | Chamberlain Bridges | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766725 | 2766725 | CT | school | 890011 | New Britain School District | 890411 | Holmes Bridges | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766726 | 2766726 | CT | school | 890011 | New Britain School District | 891011 | Lincoln SCS | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766727 | 2766727 | CT | school | 890011 | New Britain School District | 90267001566 | 899011 | New Britain Transition Center | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766756 | 2766756 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766780 | 2766780 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766781 | 2766781 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766783 | 2766783 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766784 | 2766784 | CT | school | 930011 | New Haven School District | 937511 | East Rock Self Contained MD | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766785 | 2766785 | CT | school | 930011 | New Haven School District | 938711 | Fair Haven Self Contained ID | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766793 | 2766793 | CT | school | 930011 | New Haven School District | 938611 | Wexler Grant Self Contained | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766849 | 2766849 | CT | school | 903030 | 1010011 | North Haven School District | 90303000630 | 1010211 | Montowese Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2766889 | 2766889 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766890 | 2766890 | CT | school | 1040011 | Norwich School District | 1040911 | Stanton Special Learning Center | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2766958 | 2766958 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500739 | 2135112 | Frank Ward Strong School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2767125 | 2767125 | CT | school | 1380011 | Stratford School District | 90444001734 | 1380611 | ABA - K-6 | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767127 | 2767127 | CT | school | 1380011 | Stratford School District | 1382311 | DLC Whitney | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767131 | 2767131 | CT | school | 1380011 | Stratford School District | 1382811 | STEPS K-6 | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767134 | 2767134 | CT | school | 1380011 | Stratford School District | 1382711 | ALL Class Room - Second Hill Lane | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767185 | 2767185 | CT | school | 904650 | 1450011 | Union School District | 90465000938 | 1450111 | Union School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2767192 | 2767192 | CT | school | 1460011 | Vernon School District | 1460811 | Renaissance Program | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767204 | 2767204 | CT | school | 1480011 | Wallingford School District | 1480611 | Benhaven ABC Intermediate Program | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767209 | 2767209 | CT | school | 1480011 | Wallingford School District | 1481111 | STARS Intermediate Program | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767210 | 2767210 | CT | school | 1480011 | Wallingford School District | 90474001595 | 1489211 | WISE Intermediate Program | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767240 | 2767240 | CT | school | 1510011 | Waterbury School District | 1514611 | Bucks Hill Autism | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767242 | 2767242 | CT | school | 1510011 | Waterbury School District | 1511911 | Carrington ESC | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767245 | 2767245 | CT | school | 1510011 | Waterbury School District | 1513511 | Generali Autism | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767246 | 2767246 | CT | school | 1510011 | Waterbury School District | 1516911 | Gilmartin Scope | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767250 | 2767250 | CT | school | 1510011 | Waterbury School District | 1512411 | Reed ESC | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767256 | 2767256 | CT | school | 1510011 | Waterbury School District | 1510111 | Bunker Hill BDLC | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767282 | 2767282 | CT | school | 1520011 | Waterford School District | 1521111 | Autism Class | Program | 2020 | grade_5 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767300 | 2767300 | CT | school | 1550011 | West Hartford School District | 90492001705 | 1559311 | Braeburn Learning Center | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767306 | 2767306 | CT | school | 1550011 | West Hartford School District | 90492001681 | 1559411 | Norfeldt Learning Center | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767308 | 2767308 | CT | school | 1550011 | West Hartford School District | 90492001780 | 1559511 | Whiting Lane Learning Center | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767326 | 2767326 | CT | school | 1560011 | West Haven School District | 90495001799 | 1560111 | Life Skills | Program | 2020 | grade_5 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2767327 | 2767327 | CT | school | 1560011 | West Haven School District | 1561111 | ASD Lab | 2020 | grade_5 | * |
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]);