enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,679 ✖
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
1368461 1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1374311 1374311 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1675702 1675702 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1123135 1123135 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_4 5 6 4 0   0     0   1   14 2                       16 5 6 4 0   0     0   1   14 2                 16
1123248 1123248 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_4 26 7 16 0   1     0   0   30 20                       50 26 7 16 0   1     0   0   30 20                 50
1123446 1123446 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_4 2 4 3 0   0     0   0   7 2                       9 2 4 3 0   0     0   0   7 2                 9
1124656 1124656 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_4 3 2 2 0   0     0   1   7 1                       8 3 2 2 0   0     0   1   7 1                 8
1125423 1125423 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_4 * * * *   *     *   *   4 1                       *                         4 1                  
1125881 1125881 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_4 1 0 11 0   0     0   1   12 1                       13 1 0 11 0   0     0   1   12 1                 13
1131204 1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
1131269 1131269 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_4 0 20 0 0   0     0   0   10 10                       20 0 20 0 0   0     0   0   10 10                 20
1131305 1131305 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_4 26 32 58 0   5     0   7   65 63                       128 26 32 58 0   5     0   7   65 63                 128
1131330 1131330 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_4 20 63 34 0   2     0   0   57 62                       119 20 63 34 0   2     0   0   57 62                 119
1131344 1131344 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_4 47 39 2 0   15     0   9   49 63                       112 47 39 2 0   15     0   9   49 63                 112
1131453 1131453 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_4 12 1 1 0   0     0   1   7 8                       15 12 1 1 0   0     0   1   7 8                 15
1131471 1131471 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_4 4 33 31 0   3     0   2   33 40                       73 4 33 31 0   3     0   2   33 40                 73
1131485 1131485 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_4 71 23 13 0   23     0   5   74 61                       135 71 23 13 0   23     0   5   74 61                 135
1131584 1131584 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_4 13 49 18 2   10     1   2   50 45                       95 13 49 18 2   10     1   2   50 45                 95
1131598 1131598 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_4 24 18 3 0   2     0   3   22 28                       50 24 18 3 0   2     0   3   22 28                 50
1131617 1131617 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_4 80 3 11 0   0     0   6   48 52                       100 80 3 11 0   0     0   6   48 52                 100
1131661 1131661 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_4 26 1 6 0   5     0   5   23 20                       43 26 1 6 0   5     0   5   23 20                 43
1133186 1133186 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 22 8 9 0   3     0   4   21 25                       46 22 8 9 0   3     0   4   21 25                 46
1133200 1133200 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 16 8 5 0   1     0   3   23 10                       33 16 8 5 0   1     0   3   23 10                 33
1365778 1365778 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_4 0 6 8 1   0     0   0   13 2 *                     15.0 0 6 8 1   0     0   0   13 2                 15
1365880 1365880 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_4 20 16 7 0   4     0   2   25 24 *                     49.0 20 16 7 0   4     0   2   25 24                 49
1366046 1366046 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_4 0 2 4 0   0     0   0   3 3 *                     6.0 0 2 4 0   0     0   0   3 3                 6
1366217 1366217 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_4 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1367684 1367684 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_4 * * * *   *     *   *   2 * *                     2.0                         2                   2
1369341 1369341 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_4 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1372538 1372538 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_4 10 99 66 0   2     0   4   85 96 *                     181.0 10 99 66 0   2     0   4   85 96                 181
1372551 1372551 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_4 6 24 85 0   6     0   3   69 55 *                     124.0 6 24 85 0   6     0   3   69 55                 124
1372604 1372604 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_4 0 15 6 0   0     0   0   10 11 *                     21.0 0 15 6 0   0     0   0   10 11                 21
1372637 1372637 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_4 17 38 57 0   6     0   10   69 59 *                     128.0 17 38 57 0   6     0   10   69 59                 128
1372651 1372651 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_4 5 29 4 0   2     0   1   20 21 *                     41.0 5 29 4 0   2     0   1   20 21                 41
1372663 1372663 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_4 28 62 20 0   2     0   4   59 57 *                     116.0 28 62 20 0   2     0   4   59 57                 116
1372676 1372676 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_4 35 86 5 2   12     0   12   71 81 *                     152.0 35 86 5 2   12     0   12   71 81                 152
1372775 1372775 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_4 13 0 2 1   0     0   1   5 12 *                     17.0 13 0 2 1   0     0   1   5 12                 17
1372790 1372790 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_4 2 50 48 0   0     0   0   48 52 *                     100.0 2 50 48 0   0     0   0   48 52                 100
1372803 1372803 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_4 53 28 16 1   26     0   3   63 64 *                     127.0 53 28 16 1   26     0   3   63 64                 127
1372886 1372886 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_4 11 51 18 0   10     0   1   40 51 *                     91.0 11 51 18 0   10     0   1   40 51                 91
1372899 1372899 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_4 34 17 2 0   1     0   7   37 24 *                     61.0 34 17 2 0   1     0   7   37 24                 61
1372916 1372916 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_4 88 6 9 0   2     0   5   48 62 *                     110.0 88 6 9 0   2     0   5   48 62                 110
1372939 1372939 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_4 18 20 23 1   4     0   0   37 29 *                     66.0 18 20 23 1   4     0   0   37 29                 66
1372960 1372960 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_4 19 4 7 0   9     0   5   22 22 *                     44.0 19 4 7 0   9     0   5   22 22                 44
1374200 1374200 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_4 16 25 36 0   32     0   5   52 62 *                     114.0 16 25 36 0   32     0   5   52 62                 114
1374284 1374284 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_4 17 5 3 0   1     0   0   15 11 *                     26.0 17 5 3 0   1     0   0   15 11                 26
1374297 1374297 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_4 36 9 16 1   4     0   4   30 40 *                     70.0 36 9 16 1   4     0   4   30 40                 70
1673016 1673016 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_4 3 4 5 0   1     0   0   12 1 *                     13.0 3 4 5 0   1     0   0   12 1                 13
1673117 1673117 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_4 12 27 15 1   9     0   4   38 30 *                     68.0 12 27 15 1   9     0   4   38 30                 68
1673281 1673281 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_4 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673450 1673450 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_4 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674292 1674292 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_4 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1674428 1674428 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_4 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1675665 1675665 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_4 5 0 2 0   3     0   1   10 1 *                     11.0 5 0 2 0   3     0   1   10 1                 11
1675850 1675850 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_4 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1679801 1679801 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_4 9 102 75 0   4     0   2   82 110 *                     192.0 9 102 75 0   4     0   2   82 110                 192
1679814 1679814 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_4 7 24 85 2   3     0   4   56 69 *                     125.0 7 24 85 2   3     0   4   56 69                 125
1679867 1679867 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_4 0 16 6 0   0     0   0   8 14 *                     22.0 0 16 6 0   0     0   0   8 14                 22
1679900 1679900 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_4 23 38 57 0   5     0   5   64 64 *                     128.0 23 38 57 0   5     0   5   64 64                 128
1679914 1679914 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District) - Neighborhood House Charter School   Regular School Yes Other PK 12 2021   grade_4 9 20 7 0   3     0   4   15 27 *                     43.0 9 20 7 0   3     0   4   15 27                 43
1679927 1679927 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_4 21 57 34 0   3     0   2   48 69 *                     117.0 21 57 34 0   3     0   2   48 69                 117
1679940 1679940 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_4 44 75 11 0   15     0   7   78 74 *                     152.0 44 75 11 0   15     0   7   78 74                 152
1680039 1680039 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_4 7 0 1 0   0     0   3   7 4 *                     11.0 7 0 1 0   0     0   3   7 4                 11
1680055 1680055 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_4 1 43 47 1   0     0   4   49 47 *                     96.0 1 43 47 1   0     0   4   49 47                 96
1680068 1680068 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_4 52 22 16 0   20     0   13   68 55 *                     123.0 52 22 16 0   20     0   13   68 55                 123
1680151 1680151 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_4 9 50 29 0   5     0   1   47 47 *                     94.0 9 50 29 0   5     0   1   47 47                 94
1680164 1680164 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_4 41 19 8 0   4     0   7   32 47 *                     79.0 41 19 8 0   4     0   7   32 47                 79
1680181 1680181 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_4 81 10 12 0   0     0   7   57 53 *                     110.0 81 10 12 0   0     0   7   57 53                 110
1680203 1680203 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_4 25 17 20 1   2     0   1   27 39 *                     66.0 25 17 20 1   2     0   1   27 39                 66
1680224 1680224 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_4 30 1 5 0   7     0   1   22 22 *                     44.0 30 1 5 0   7     0   1   22 22                 44
1681448 1681448 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_4 14 29 42 0   24     0   7   61 55 *                     116.0 14 29 42 0   24     0   7   61 55                 116
1681522 1681522 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_4 30 6 5 0   3     0   2   18 28 0                     46.0 30 6 5 0   3     0   2   18 28 0               46
1681535 1681535 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_4 58 10 20 0   2     2   4   34 62 *                     96.0 58 10 20 0   2     2   4   34 62                 96
2040821 2040821 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_4 0 10 5 0   0     0   2   14 3                       17.0 0 10 5 0   0     0   2   14 3                 17
2040924 2040924 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_4 17 13 11 0   6     0   0   23 24                       47.0 17 13 11 0   6     0   0   23 24                 47
2041099 2041099 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_4 0 4 4 0   0     0   0   6 2                       8.0 0 4 4 0   0     0   0   6 2                 8
2041285 2041285 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_4 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2042768 2042768 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_4 1 0 4 1   0     0   0   5 *                       6.0 1 0 4 1   0     0   0   5                   6
2043144 2043144 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_4 1 0 13 0   0     0   0   10 4                       14.0 1 0 13 0   0     0   0   10 4                 14
2044414 2044414 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_4 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2047613 2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
2047676 2047676 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_4 0 18 1 0   0     0   0   9 10                       19.0 0 18 1 0   0     0   0   9 10                 19
2047709 2047709 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_4 26 48 73 0   8     0   6   88 73                       161.0 26 48 73 0   8     0   6   88 73                 161
2047723 2047723 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_4 10 20 11 0   1     0   1   21 22                       43.0 10 20 11 0   1     0   1   21 22                 43
2047734 2047734 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_4 23 65 19 0   3     0   6   64 52                       116.0 23 65 19 0   3     0   6   64 52                 116
2047747 2047747 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_4 57 66 9 0   12     0   8   75 77                       152.0 57 66 9 0   12     0   8   75 77                 152
2047846 2047846 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_4 9 0 0 1   0     0   4   7 7                       14.0 9 0 0 1   0     0   4   7 7                 14
2047862 2047862 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_4 2 43 47 1   2     0   2   39 58                       97.0 2 43 47 1   2     0   2   39 58                 97
2047875 2047875 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_4 64 29 6 1   17     0   11   58 70                       128.0 64 29 6 1   17     0   11   58 70                 128
2047958 2047958 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_4 15 40 21 0   12     0   7   60 35                       95.0 15 40 21 0   12     0   7   60 35                 95
2047971 2047971 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2019   grade_4 43 14 2 0   3     0   3   32 33                       65.0 43 14 2 0   3     0   3   32 33                 65
2047988 2047988 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_4 91 5 7 0   2     0   5   46 64                       110.0 91 5 7 0   2     0   5   46 64                 110
2048011 2048011 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2019   grade_4 26 9 23 0   8     0   0   29 37                       66.0 26 9 23 0   8     0   0   29 37                 66
2048032 2048032 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2019   grade_4 22 1 4 0   11     0   8   20 26                       46.0 22 1 4 0   11     0   8   20 26                 46
2049353 2049353 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 18 6 8 0   1     0   0   20 13                       33.0 18 6 8 0   1     0   0   20 13                 33
2049366 2049366 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 35 8 14 0   2     0   11   35 35                       70.0 35 8 14 0   2     0   11   35 35                 70
2229939 2229939 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_4 0 10 3 0   0     0   0   10 3                       13.0 0 10 3 0   0     0   0   10 3                 13
2230053 2230053 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_4 14 15 14 0   2     0   2   27 20                       47.0 14 15 14 0   2     0   2   27 20                 47
2230481 2230481 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_4 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2231474 2231474 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_4 * * * *   *     *   *   4 1                       5.0                         4 1                 5

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