enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by male_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,271 ✖
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
1127568 1127568 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_7 24 0 0 0   0     0   1   11 14                       25 24 0 0 0   0     0   1   11 14                 25
1372769 1372769 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_7 14 1 2 0   0     0   2   11 8 *                     19.0 14 1 2 0   0     0   2   11 8                 19
1372778 1372778 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_7 12 1 4 0   0     0   2   11 8 *                     19.0 12 1 4 0   0     0   2   11 8                 19
1674531 1674531 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_7 18 0 0 0   0     0   0   11 7 *                     18.0 18 0 0 0   0     0   0   11 7                 18
1677346 1677346 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_7 10 3 2 0   0     0   3   11 7 *                     18.0 10 3 2 0   0     0   3   11 7                 18
1678276 1678276 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield - Springfield Public Day Middle School   Regular School No Middle 06 08 2021   grade_7 1 4 7 0   0     0   0   11 1 *                     12.0 1 4 7 0   0     0   0   11 1                 12
1678587 1678587 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury - Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_7 17 1 19 0   0     0   1   11 27 *                     38.0 17 1 19 0   0     0   1   11 27                 38
2040910 2040910 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_7 0 6 10 0   0     0   2   11 7                       18.0 0 6 10 0   0     0   2   11 7                 18
2041465 2041465 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_7 13 0 21 0   1     0   2   11 26                       37.0 13 0 21 0   1     0   2   11 26                 37
2047920 2047920 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_7 25 1 3 0   2     0   2   11 22                       33.0 25 1 3 0   2     0   2   11 22                 33
2238129 2238129 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_7 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2238376 2238376 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_7 27 1 1 0   0     0   2   11 20                       31.0 27 1 1 0   0     0   2   11 20                 31
736725 736725 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_7 1 14 7 0   0     0   1   12 11                       23 1 14 7 0   0     0   1   12 11                 23
933415 933415 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_7 8 2 5 0   0     1   2   12 6                       18 8 2 5 0   0     1   2   12 6                 18
933630 933630 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_7 1 6 10 0   0     0   0   12 5                       17 1 6 10 0   0     0   0   12 5                 17
933809 933809 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_7 0 1 24 0   0     0   0   12 13                       25 0 1 24 0   0     0   0   12 13                 25
938191 938191 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2016   grade_7 22 0 9 0   0     0   3   12 22                       34 22 0 9 0   0     0   3   12 22                 34
940550 940550 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_7 12 0 1 0   2     0   1   12 4                       16 12 0 1 0   2     0   1   12 4                 16
1122731 1122731 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_7 7 7 9 1   1     0   1   12 14                       26 7 7 9 1   1     0   1   12 14                 26
1122903 1122903 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_7 7 8 7 0   0     0   0   12 10                       22 7 8 7 0   0     0   0   12 10                 22
1129358 1129358 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2017   grade_7 1 4 11 0   0     0   0   12 4                       16 1 4 11 0   0     0   0   12 4                 16
1131298 1131298 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_7 2 0 19 0   1     0   0   12 10                       22 2 0 19 0   1     0   0   12 10                 22
1365281 1365281 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_7 2 3 8 0   1     0   1   12 3 *                     15.0 2 3 8 0   1     0   1   12 3                 15
1365580 1365580 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_7 10 1 11 0   2     0   1   12 13 *                     25.0 10 1 11 0   2     0   1   12 13                 25
1366040 1366040 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_7 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
1366689 1366689 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_7 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1367207 1367207 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_7 3 2 8 0   0     0   3   12 4 *                     16.0 3 2 8 0   0     0   3   12 4                 16
1372504 1372504 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_7 0 13 6 0   0     0   4   12 11 *                     23.0 0 13 6 0   0     0   4   12 11                 23
1372709 1372709 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_7 28 0 2 0   0     0   2   12 19 *                     32.0 28 0 2 0   0     0   2   12 19                 32
1672527 1672527 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_7 4 11 13 0   3     0   0   12 19 *                     31.0 4 11 13 0   3     0   0   12 19                 31
1673040 1673040 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_7 0 14 12 0   0     0   0   12 14 *                     26.0 0 14 12 0   0     0   0   12 14                 26
1679767 1679767 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_7 0 17 10 0   0     0   0   12 15 *                     27.0 0 17 10 0   0     0   0   12 15                 27
1679838 1679838 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District) - Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2021   grade_7 3 2 29 0   1     0   0   12 23 *                     35.0 3 2 29 0   1     0   0   12 23                 35
1679870 1679870 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_7 0 18 4 0   0     0   0   12 10 *                     22.0 0 18 4 0   0     0   0   12 10                 22
1680720 1680720 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_7 9 1 3 0   0     0   2   12 3 *                     15.0 9 1 3 0   0     0   2   12 3                 15
2040470 2040470 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_7 6 3 12 0   2     0   1   12 12                       24.0 6 3 12 0   2     0   1   12 12                 24
2047577 2047577 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_7 0 16 7 0   0     0   1   12 12                       24.0 0 16 7 0   0     0   1   12 12                 24
2229965 2229965 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_7 1 13 6 0   0     0   0   12 8                       20.0 1 13 6 0   0     0   0   12 8                 20
2231651 2231651 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_7 12 3 3 0   0     0   5   12 11                       23.0 12 3 3 0   0     0   5   12 11                 23
2238248 2238248 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_7 21 1 6 0   0     0   2   12 18                       30.0 21 1 6 0   0     0   2   12 18                 30
736321 736321 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_7 3 5 14 0   0     0   0   13 9                       22 3 5 14 0   0     0   0   13 9                 22
742286 742286 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_7 25 3 5 0   0     0   1   13 21                       34 25 3 5 0   0     0   1   13 21                 34
743568 743568 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_7 5 1 38 0   0     0   0   13 31                       44 5 1 38 0   0     0   0   13 31                 44
938656 938656 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_7 8 8 8 0   1     0   1   13 13                       26 8 8 8 0   1     0   1   13 13                 26
940507 940507 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2016   grade_7 25 2 7 0   0     0   0   13 21                       34 25 2 7 0   0     0   0   13 21                 34
1122991 1122991 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_7 5 4 4 0   1     0   0   13 1                       14 5 4 4 0   1     0   0   13 1                 14
1123871 1123871 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_7 8 1 11 0   1     0   4   13 12                       25 8 1 11 0   1     0   4   13 12                 25
1365553 1365553 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_7 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1365767 1365767 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_7 12 5 10 0   0     0   5   13 19 *                     32.0 12 5 10 0   0     0   5   13 19                 32
1672624 1672624 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_7 2 12 7 0   0     0   3   13 11 *                     24.0 2 12 7 0   0     0   3   13 11                 24
1673276 1673276 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_7 1 0 27 0   0     0   1   13 16 *                     29.0 1 0 27 0   0     0   1   13 16                 29
1673917 1673917 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_7 30 0 0 0   0     0   0   13 17 *                     30.0 30 0 0 0   0     0   0   13 17                 30
1678294 1678294 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_7 10 5 36 0   0     0   2   13 40 *                     53.0 10 5 36 0   0     0   2   13 40                 53
2040443 2040443 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_7 2 13 10 0   0     0   3   13 15                       28.0 2 13 10 0   0     0   3   13 15                 28
2040810 2040810 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_7 9 5 18 0   2     0   1   13 22                       35.0 9 5 18 0   2     0   1   13 22                 35
2040846 2040846 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_7 0 12 11 0   0     0   4   13 14                       27.0 0 12 11 0   0     0   4   13 14                 27
2045405 2045405 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_7 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2047812 2047812 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2019   grade_7 22 3 8 0   0     0   2   13 22                       35.0 22 3 8 0   0     0   2   13 22                 35
2229406 2229406 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_7 1 11 16 0   2     0   0   13 17                       30.0 1 11 16 0   2     0   0   13 17                 30
2230003 2230003 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_7 0 12 11 0   0     0   2   13 12                       25.0 0 12 11 0   0     0   2   13 12                 25
736290 736290 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   grade_7 3 10 10 0   0     0   1   14 10                       24 3 10 10 0   0     0   1   14 10                 24
736572 736572 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_7 8 5 17 0   0     0   1   14 17                       31 8 5 17 0   0     0   1   14 17                 31
737317 737317 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_7 11 3 12 0   1     0   3   14 16                       30 11 3 12 0   1     0   3   14 16                 30
740442 740442 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_7 21 0 0 0   0     0   1   14 8                       22 21 0 0 0   0     0   1   14 8                 22
743806 743806 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_7 30 0 1 0   1     0   0   14 18                       32 30 0 1 0   1     0   0   14 18                 32
937452 937452 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_7 24 0 2 0   0     0   3   14 15                       29 24 0 2 0   0     0   3   14 15                 29
938798 938798 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No 4 06 10 2016   grade_7 11 17 29 0   0     0   1   14 44                       58 11 17 29 0   0     0   1   14 44                 58
1125563 1125563 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_7 1 1 34 0   1     0   0   14 23                       37 1 1 34 0   1     0   0   14 23                 37
1131380 1131380 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_7 23 0 6 0   1     0   2   14 18                       32 23 0 6 0   1     0   2   14 18                 32
1365305 1365305 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_7 4 11 14 1   0     0   0   14 16 *                     30.0 4 11 14 1   0     0   0   14 16                 30
1365678 1365678 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_7 4 6 18 0   0     0   2   14 16 *                     30.0 4 6 18 0   0     0   2   14 16                 30
1368062 1368062 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_7 2 0 13 0   0     0   1   14 2 *                     16.0 2 0 13 0   0     0   1   14 2                 16
1371032 1371032 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_7 5 7 38 0   0     0   2   14 38 *                     52.0 5 7 38 0   0     0   2   14 38                 52
1674246 1674246 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_7 22 3 7 1   0     0   2   14 21 *                     35.0 22 3 7 1   0     0   2   14 21                 35
1680005 1680005 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District) - Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2021   grade_7 27 0 4 0   0     0   1   14 18 *                     32.0 27 0 4 0   0     0   1   14 18                 32
2040824 2040824 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_7 2 6 12 0   0     0   0   14 6                       20.0 2 6 12 0   0     0   0   14 6                 20
2047604 2047604 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_7 0 0 32 0   1     0   0   14 19                       33.0 0 0 32 0   1     0   0   14 19                 33
2236035 2236035 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield: Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2018   grade_7 8 8 13 0   0     0   2   14 17                       31.0 8 8 13 0   0     0   2   14 17                 31
2236204 2236204 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield: Conservatory of the Arts   Regular School No High 06 12 2018   grade_7 5 14 37 0   0     0   1   14 43                       57.0 5 14 37 0   0     0   1   14 43                 57
740737 740737 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_7 28 1 3 0   1     0   6   15 24                       39 28 1 3 0   1     0   6   15 24                 39
741972 741972 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2015   grade_7 2 3 11 0   0     0   1   15 2                       17 2 3 11 0   0     0   1   15 2                 17
938777 938777 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2016   grade_7 3 2 14 0   0     0   0   15 4                       19 3 2 14 0   0     0   0   15 4                 19
940413 940413 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_7 0 19 9 0   0     0   2   15 15                       30 0 19 9 0   0     0   2   15 15                 30
940635 940635 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_7 25 0 2 0   4     0   0   15 16                       31 25 0 2 0   4     0   0   15 16                 31
1122946 1122946 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_7 0 8 19 0   0     0   1   15 13                       28 0 8 19 0   0     0   1   15 13                 28
1123232 1123232 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_7 6 5 9 0   0     0   1   15 6                       21 6 5 9 0   0     0   1   15 6                 21
1129216 1129216 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_7 6 9 14 0   0     0   2   15 16                       31 6 9 14 0   0     0   2   15 16                 31
1672911 1672911 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_7 10 7 24 0   0     0   2   15 28 *                     43.0 10 7 24 0   0     0   2   15 28                 43
1679973 1679973 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_7 24 0 0 0   2     0   5   15 16 *                     31.0 24 0 0 0   2     0   5   15 16                 31
2040695 2040695 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_7 10 7 4 0   0     0   1   15 7                       22.0 10 7 4 0   0     0   1   15 7                 22
2042717 2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
2042931 2042931 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_7 2 1 37 0   0     0   0   15 25                       40.0 2 1 37 0   0     0   0   15 25                 40
2045960 2045960 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_7 6 12 16 0   0     0   1   15 20                       35.0 6 12 16 0   0     0   1   15 20                 35
2046087 2046087 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_7 2 4 13 0   0     0   0   15 4                       19.0 2 4 13 0   0     0   0   15 4                 19
2229995 2229995 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_7 1 17 10 0   0     0   0   15 13                       28.0 1 17 10 0   0     0   0   15 13                 28
2231421 2231421 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_7 20 0 7 0   0     0   3   15 15                       30.0 20 0 7 0   0     0   3   15 15                 30
2232368 2232368 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_7 13 1 19 0   0     0   0   15 18                       33.0 13 1 19 0   0     0   0   15 18                 33
2238118 2238118 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_7 2 19 11 0   0     0   1   15 18                       33.0 2 19 11 0   0     0   1   15 18                 33
738121 738121 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2015   grade_7 11 4 4 0   1     0   1   16 5                       21 11 4 4 0   1     0   1   16 5                 21
740434 740434 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_7 23 3 2 0   0     0   1   16 13                       29 23 3 2 0   0     0   1   16 13                 29

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);