enrollments
Data source: Big Local News · About: Big Local
1,444 rows where grade = "grade_7", state = "CT" and year = 2021 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2748659 | 2748659 | CT | school | 110011 | Bloomfield School District | 110111 | Steps to Success | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748707 | 2748707 | CT | school | 150011 | Bridgeport School District | 90045001472 | 159011 | Bridgeport Learning Center | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748735 | 2748735 | CT | school | 170011 | Bristol School District | 90051001429 | 179011 | Alternative Special Education Program (ASEP) | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748739 | 2748739 | CT | school | 170011 | Bristol School District | 90051001748 | 171011 | Chippens Hill Middle School Functional Program | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748740 | 2748740 | CT | school | 170011 | Bristol School District | 171611 | Chippens Hill Middle School Medically Fragile | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748742 | 2748742 | CT | school | 170011 | Bristol School District | 90051001753 | 173411 | Chms Goal | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748743 | 2748743 | CT | school | 170011 | Bristol School District | 90051001651 | 172711 | Northeast MS/Extended Resource | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748744 | 2748744 | CT | school | 170011 | Bristol School District | 90051001796 | 172811 | Northeast MS/GOAL | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748746 | 2748746 | CT | school | 170011 | Bristol School District | 90051001661 | 170911 | Greene-Hills GOAL | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748772 | 2748772 | CT | school | 2410014 | Capitol Region Education Council | 90070001510 | 2419514 | River Street School Birken Campus | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748776 | 2748776 | CT | school | 2410014 | Capitol Region Education Council | 90070001154 | 2419014 | John J. Allison Polaris Center | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748816 | 2748816 | CT | school | 2430014 | Cooperative Educational Services | 90091001554 | 2439214 | Developmental Learning Center (DLC) | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748861 | 2748861 | CT | school | 370011 | Derby School District | 370511 | RAISE Academy | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748922 | 2748922 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748923 | 2748923 | CT | school | 2420014 | EdAdvance | 2420114 | Steps | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748945 | 2748945 | CT | school | 490011 | Enfield School District | 492411 | Eagle Academy | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748994 | 2748994 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748996 | 2748996 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2749060 | 2749060 | CT | school | 620011 | Hamden School District | 622011 | Intensive Support Classroom 7-8 | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749105 | 2749105 | CT | school | 640011 | Hartford School District | 640210 | iGOAL 2 - Kennelly School | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749112 | 2749112 | CT | school | 640011 | Hartford School District | 641310 | RISE - M.L. King Middle School | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749114 | 2749114 | CT | school | 640011 | Hartford School District | 640110 | iGOAL 1 - Milner School | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749115 | 2749115 | CT | school | 640011 | Hartford School District | 640910 | New Visions | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749144 | 2749144 | CT | school | 2450014 | Learn | 2451614 | LEARN SAILS Program | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749156 | 2749156 | CT | school | 902160 | 720011 | Ledyard School District | 90216000402 | 725111 | Ledyard Middle School | Public Schools | Regular School | No | Middle | 06 | 10 | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2749182 | 2749182 | CT | school | 770011 | Manchester School District | 90231000427 | 779011 | Manchester Regional Academy | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749205 | 2749205 | CT | school | 800011 | Meriden School District | 802311 | SOAR - LMS | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749207 | 2749207 | CT | school | 800011 | Meriden School District | 801511 | STARS-MS | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749210 | 2749210 | CT | school | 800011 | Meriden School District | 801311 | Venture Academy | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749234 | 2749234 | CT | school | 830011 | Middletown School District | 90249001793 | 830411 | ICM- Woodrow Wilson Middle School | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749303 | 2749303 | CT | school | 890011 | New Britain School District | 90267001566 | 899011 | New Britain Transition Center | Program | 2021 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749308 | 2749308 | CT | school | 890011 | New Britain School District | 891711 | Slade KEY Middle | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749359 | 2749359 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749360 | 2749360 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749363 | 2749363 | CT | school | 930011 | New Haven School District | 938711 | Fair Haven Self Contained ID | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749364 | 2749364 | CT | school | 930011 | New Haven School District | 937711 | Nathan Hale Self Contained ID | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749370 | 2749370 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2749473 | 2749473 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748624 | 2748624 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748625 | 2748625 | CT | school | 20011 | Ansonia School District | 20911 | Ansonia Public Schools Pre-K Program | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748626 | 2748626 | CT | school | 900060 | 20011 | Ansonia School District | 90006000005 | 20311 | Mead School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748627 | 2748627 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748629 | 2748629 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748630 | 2748630 | CT | school | 20011 | Ansonia School District | 90006001678 | 20111 | P.A.C.E. (Positive And Creative Education) | Program | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748631 | 2748631 | CT | school | 20011 | Ansonia School District | 20411 | P.A.C.E. - PM (Positive And Creative Education - PM) | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748632 | 2748632 | CT | school | 20011 | Ansonia School District | 21011 | Ansonia 18-21 Transition Program | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748634 | 2748634 | CT | school | 40011 | Avon School District | 90012001737 | 40111 | Avon Early Learning Center at Roaring Brook School | Program | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748635 | 2748635 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748636 | 2748636 | CT | school | 900120 | 40011 | Avon School District | 90012000013 | 40311 | Roaring Brook School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748637 | 2748637 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748639 | 2748639 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748640 | 2748640 | CT | school | 50011 | Barkhamsted School District | 90015001373 | 58011 | Shared Services Integrated Preschool | Program | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748641 | 2748641 | CT | school | 900150 | 50011 | Barkhamsted School District | 90015000015 | 50111 | Barkhamsted Elementary School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748642 | 2748642 | CT | school | 50011 | Barkhamsted School District | 50211 | Bridges at Barkhamsted Elementary School | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748643 | 2748643 | CT | school | 900210 | 70011 | Berlin School District | 90021000018 | 70411 | Emma Hart Willard School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748644 | 2748644 | CT | school | 900210 | 70011 | Berlin School District | 90021000020 | 70511 | Mary E. Griswold School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748645 | 2748645 | CT | school | 900210 | 70011 | Berlin School District | 90021000021 | 70111 | Richard D. Hubbard School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748647 | 2748647 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748648 | 2748648 | CT | school | 70011 | Berlin School District | 70311 | Transition Academy | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748649 | 2748649 | CT | school | 900240 | 80011 | Bethany School District | 90024000022 | 80111 | Bethany Community School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748650 | 2748650 | CT | school | 900270 | 90011 | Bethel School District | 90027000027 | 90111 | Frank A. Berry School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748651 | 2748651 | CT | school | 900270 | 90011 | Bethel School District | 90027000023 | 90411 | Anna H. Rockwell School | Public Schools | Regular School | No | Elementary | KG | 02 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748652 | 2748652 | CT | school | 900270 | 90011 | Bethel School District | 90027001118 | 90511 | Ralph M. T. Johnson School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748654 | 2748654 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748655 | 2748655 | CT | school | 90011 | Bethel School District | 90311 | TASK | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748656 | 2748656 | CT | school | 90011 | Bethel School District | 90211 | Community Partnership Program | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748657 | 2748657 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748658 | 2748658 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000032 | 110611 | Laurel School | Public Schools | Regular School | No | Elementary | KG | 02 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748660 | 2748660 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000033 | 110511 | Metacomet School | Public Schools | Regular School | No | Elementary | 03 | 04 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748661 | 2748661 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748664 | 2748664 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748666 | 2748666 | CT | school | 900360 | 120011 | Bolton School District | 90036000037 | 126111 | Bolton High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2748667 | 2748667 | CT | school | 120011 | Bolton School District | 120211 | Bolton Transition Program | Program | 2021 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748669 | 2748669 | CT | school | 140011 | Branford School District | 90042000177 | 148011 | Indian Neck School | Program | 2021 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2748670 | 2748670 | CT | school | 900420 | 140011 | Branford School District | 90042001119 | 141611 | John B. Sliney School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | 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]);