Data source: Big Local News · About: Big Local

889 rows where grade = "grade_5", state = "MA" and year = 2021 sorted by total

View and edit SQL

year

  • 2021 · 889

grade

  • grade_5 · 889
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
1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
1680595 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680878 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1673829 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_5 8 6 83 0   0     0   3   51 49 *                     100.0 8 6 83 0   0     0   3   51 49                 100
1679843 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_5 70 6 12 0   5     0   7   44 56 *                     100.0 70 6 12 0   5     0   7   44 56                 100
1675100 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_5 1 4 94 0   1     0   1   52 49 *                     101.0 1 4 94 0   1     0   1   52 49                 101
1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
1675782 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_5 7 10 70 0   7     0   7   49 52 *                     101.0 7 10 70 0   7     0   7   49 52                 101
1676444 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham - Newman Elementary   Regular School No Elementary PK 05 2021   grade_5 74 6 5 0   9     0   7   49 52 *                     101.0 74 6 5 0   9     0   7   49 52                 101
1674039 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_5 82 2 5 0   3     0   10   58 44 *                     102.0 82 2 5 0   3     0   10   58 44                 102
1680104 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District) - Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2021   grade_5 1 61 36 0   0     0   4   49 53 *                     102.0 1 61 36 0   0     0   4   49 53                 102
1675428 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington - Joseph Estabrook   Regular School No Elementary KG 05 2021   grade_5 34 3 4 0   58     0   4   59 44 *                     103.0 34 3 4 0   58     0   4   59 44                 103
1677310 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth - South Elementary   Regular School No Elementary KG 05 2021   grade_5 88 0 9 1   1     1   3   48 55 *                     103.0 88 0 9 1   1     1   3   48 55                 103
1680893 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_5 92 2 7 0   0     0   2   54 49 *                     103.0 92 2 7 0   0     0   2   54 49                 103
1674588 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_5 19 3 77 0   0     0   5   53 50 *                     104.0 19 3 77 0   0     0   5   53 50                 104
1680318 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_5 97 2 4 0   0     0   1   55 49 *                     104.0 97 2 4 0   0     0   1   55 49                 104
1681311 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_5 95 2 3 0   1     0   3   54 50 *                     104.0 95 2 3 0   1     0   3   54 50                 104
1672138 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   grade_5 74 2 7 0   22     0   1   52 54 *                     106.0 74 2 7 0   22     0   1   52 54                 106
1673413 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_5 11 73 15 0   0     0   7   45 61 *                     106.0 11 73 15 0   0     0   7   45 61                 106
1675003 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook - John F Kennedy   Regular School No Elementary PK 05 2021   grade_5 56 20 11 0   8     0   11   62 44 *                     106.0 56 20 11 0   8     0   11   62 44                 106
1676522 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford - Abraham Lincoln   Regular School No Elementary KG 05 2021   grade_5 63 9 29 0   1     0   4   52 54 *                     106.0 63 9 29 0   1     0   4   52 54                 106
1678100 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield - Rebecca M Johnson   Regular School No Elementary PK 05 2021   grade_5 5 27 68 0   1     0   5   59 47 *                     106.0 5 27 68 0   1     0   5   59 47                 106
1673603 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington - Francis Wyman Elementary   Regular School No Elementary KG 05 2021   grade_5 57 8 8 1   27     0   6   54 53 *                     107.0 57 8 8 1   27     0   6   54 53                 107
1676235 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_5 95 1 3 0   0     0   8   58 49 *                     107.0 95 1 3 0   0     0   8   58 49                 107
1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
1673407 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_5 22 57 14 0   5     0   10   55 53 *                     108.0 22 57 14 0   5     0   10   55 53                 108
1674364 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_5 39 13 44 0   4     0   8   61 47 *                     108.0 39 13 44 0   4     0   8   61 47                 108
1675757 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn - Wm P Connery   Regular School No Elementary PK 05 2021   grade_5 4 4 86 0   10     0   4   61 47 *                     108.0 4 4 86 0   10     0   4   61 47                 108
1676240 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_5 96 2 2 0   0     0   8   56 52 *                     108.0 96 2 2 0   0     0   8   56 52                 108
1678457 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton - Sutton Elementary   Regular School No Elementary 03 05 2021   grade_5 101 0 3 0   1     0   4   56 53 *                     109.0 101 0 3 0   1     0   4   56 53                 109
1678033 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_5 1 2 8 0   0     0   0   10 1 *                     11.0 1 2 8 0   0     0   0   10 1                 11
1679227 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately - Whately Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1673387 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton - Mary E. Baker School   Regular School No Elementary KG 05 2021   grade_5 28 54 20 0   3     0   5   62 48 *                     110.0 28 54 20 0   3     0   5   62 48                 110
1678610 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough - Tyngsborough Elementary   Regular School No Elementary PK 05 2021   grade_5 81 6 10 0   8     0   5   52 58 *                     110.0 81 6 10 0   8     0   5   52 58                 110
1680182 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_5 87 6 11 0   2     0   4   47 63 *                     110.0 87 6 11 0   2     0   4   47 63                 110
1680540 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_5 102 0 5 0   2     0   1   60 50 *                     110.0 102 0 5 0   2     0   1   60 50                 110
1673314 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_5 98 2 3 0   4     0   4   57 54 *                     111.0 98 2 3 0   4     0   4   57 54                 111
1680233 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District) - Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2021   grade_5 7 27 67 1   2     1   6   54 57 *                     111.0 7 27 67 1   2     1   6   54 57                 111
1673759 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_5 104 4 3 0   0     0   1   70 42 *                     112.0 104 4 3 0   0     0   1   70 42                 112
1674773 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_5 88 0 4 0   12     1   7   58 54 *                     112.0 88 0 4 0   12     1   7   58 54                 112
1675769 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn - Robert L Ford   Regular School No Elementary 01 05 2021   grade_5 6 6 88 1   9     0   2   59 53 *                     112.0 6 6 88 1   9     0   2   59 53                 112
1676193 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_5 65 1 38 0   4     0   4   57 55 *                     112.0 65 1 38 0   4     0   4   57 55                 112
1676853 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough - Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2021   grade_5 87 4 7 0   6     0   8   63 49 *                     112.0 87 4 7 0   6     0   8   63 49                 112
1681119 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District - Powder Mill School   Regular School No Elementary 03 06 2021   grade_5 107 2 3 0   0     0   0   55 57 *                     112.0 107 2 3 0   0     0   0   55 57                 112
1673449 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_5 19 61 23 1   1     0   8   61 52 *                     113.0 19 61 23 1   1     0   8   61 52                 113
1674945 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_5 68 3 38 2   0     0   2   52 61 *                     113.0 68 3 38 2   0     0   2   52 61                 113
1680425 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville - A F Maloney   Regular School No Elementary 03 05 2021   grade_5 96 0 10 0   1     0   6   67 46 *                     113.0 96 0 10 0   1     0   6   67 46                 113
1680963 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_5 102 2 2 0   3     0   5   57 57 *                     114.0 102 2 2 0   3     0   5   57 57                 114
1680972 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_5 95 5 10 1   0     0   3   61 53 *                     114.0 95 5 10 1   0     0   3   61 53                 114
1675993 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_5 48 2 58 0   4     0   3   58 57 *                     115.0 48 2 58 0   4     0   3   58 57                 115
1678413 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge - Burgess Elementary   Regular School No Elementary PK 06 2021   grade_5 97 2 10 0   0     0   6   68 47 *                     115.0 97 2 10 0   0     0   6   68 47                 115
1679249 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 Wilmington - West Intermediate   Regular School No Elementary 04 05 2021   grade_5 101 1 5 0   6     0   2   62 53 *                     115.0 101 1 5 0   6     0   2   62 53                 115
1679928 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_5 28 61 18 0   2     0   6   59 56 *                     115.0 28 61 18 0   2     0   6   59 56                 115
1673821 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_5 9 6 99 0   0     0   2   57 59 *                     116.0 9 6 99 0   0     0   2   57 59                 116
1673381 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_5 14 74 15 2   2     0   10   68 49 *                     117.0 14 74 15 2   2     0   10   68 49                 117
1676223 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_5 47 5 54 0   3     0   8   68 49 *                     117.0 47 5 54 0   3     0   8   68 49                 117
1676283 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury - Raymond E. Shaw Elementary   Regular School No Middle 04 06 2021   grade_5 104 2 8 0   1     0   2   70 47 *                     117.0 104 2 8 0   1     0   2   70 47                 117
1676371 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket - Nantucket Intermediate School   Regular School No Elementary 03 05 2021   grade_5 68 9 34 0   2     0   4   70 47 *                     117.0 68 9 34 0   2     0   4   70 47                 117
1672866 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_5 21 24 13 0   58     1   1   62 56 *                     118.0 21 24 13 0   58     1   1   62 56                 118
1674935 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Haverhill - Silver Hill Elementary School   Regular School No Elementary KG 05 2021   grade_5 63 5 49 0   0     0   1   60 58 *                     118.0 63 5 49 0   0     0   1   60 58                 118
1679694 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham - Charles E Roderick   Regular School No Middle 04 06 2021   grade_5 95 2 7 2   3     1   8   56 62 *                     118.0 95 2 7 2   3     1   8   56 62                 118
1675365 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_5 58 5 47 0   2     0   7   62 57 *                     119.0 58 5 47 0   2     0   7   62 57                 119
1676049 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_5 82 7 10 8   1     0   11   57 62 *                     119.0 82 7 10 8   1     0   11   57 62                 119
1676590 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_5 4 1 7 0   0     0   0   10 2 *                     12.0 4 1 7 0   0     0   0   10 2                 12
1677866 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury - Shutesbury Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 1 0   0     0   1   6 6 *                     12.0 10 0 1 0   0     0   1   6 6                 12
1674306 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_5 25 27 63 0   2     0   3   64 56 *                     120.0 25 27 63 0   2     0   3   64 56                 120
1675245 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_5 2 3 112 0   2     0   1   63 57 *                     120.0 2 3 112 0   2     0   1   63 57                 120
1679031 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 Westford - John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2021   grade_5 70 2 7 0   37     0   4   64 56 *                     120.0 70 2 7 0   37     0   4   64 56                 120
1681449 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_5 16 26 39 0   35     0   4   50 70 *                     120.0 16 26 39 0   35     0   4   50 70                 120
1681536 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_5 67 9 29 1   7     0   7   59 61 *                     120.0 67 9 29 1   7     0   7   59 61                 120
1672944 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_5 10 11 12 0   83     0   5   61 60 *                     121.0 10 11 12 0   83     0   5   61 60                 121
1674816 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_5 80 2 30 0   1     0   9   65 57 *                     122.0 80 2 30 0   1     0   9   65 57                 122
1674921 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_5 60 2 56 0   1     0   3   58 64 *                     122.0 60 2 56 0   1     0   3   58 64                 122
1674398 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_5 66 6 28 0   7     0   16   62 61 *                     123.0 66 6 28 0   7     0   16   62 61                 123
1675689 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg - Turkey Hill Elementary School   Regular School No Elementary 03 05 2021   grade_5 99 4 13 0   6     0   1   67 56 *                     123.0 99 4 13 0   6     0   1   67 56                 123
1676203 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_5 62 1 46 0   7     0   7   65 58 *                     123.0 62 1 46 0   7     0   7   65 58                 123
1677520 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 Revere - A. C. Whelan Elementary School   Regular School No Elementary KG 05 2021   grade_5 54 2 61 0   4     0   2   64 59 *                     123.0 54 2 61 0   4     0   2   64 59                 123
1679080 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_5 113 1 6 0   0     0   3   76 47 *                     123.0 113 1 6 0   0     0   3   76 47                 123
1680069 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_5 53 28 15 1   24     0   2   60 63 *                     123.0 53 28 15 1   24     0   2   60 63                 123
1673393 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   grade_5 14 40 65 0   0     0   5   56 68 *                     124.0 14 40 65 0   0     0   5   56 68                 124
1675981 MA Middlesex   school 2507320 170   Marlborough 250732002913 1700020 Marlborough - Goodnow Brothers Elementary School   Regular School No Elementary KG 05 2021   grade_5 54 3 60 1   2     0   4   67 57 *                     124.0 54 3 60 1   2     0   4   67 57                 124
1678018 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley - Michael E. Smith Middle School   Regular School No Middle 05 08 2021   grade_5 105 0 16 0   1     0   2   68 56 *                     124.0 105 0 16 0   1     0   2   68 56                 124
1678624 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Uxbridge - Whitin Intermediate   Regular School No Middle 04 07 2021   grade_5 107 3 7 0   2     0   5   67 57 *                     124.0 107 3 7 0   2     0   5   67 57                 124
1679020 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Westford - Day Elementary   Regular School No Elementary 03 05 2021   grade_5 62 4 5 0   44     0   10   53 72 *                     125.0 62 4 5 0   44     0   10   53 72                 125
1674190 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_5 87 1 24 1   5     0   8   72 53 *                     126.0 87 1 24 1   5     0   8   72 53                 126
1675228 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_5 4 2 120 0   0     0   0   74 51 *                     126.0 4 2 120 0   0     0   0   74 51                 126
1677062 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford - Oxford Middle   Regular School No Middle 05 07 2021   grade_5 98 3 18 0   0     0   7   66 60 *                     126.0 98 3 18 0   0     0   7   66 60                 126
1680569 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_5 102 5 14 0   1     0   4   67 59 *                     126.0 102 5 14 0   1     0   4   67 59                 126
1675483 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Littleton - Russell St Elementary   Regular School No Elementary 03 05 2021   grade_5 103 1 4 0   16     0   3   62 65 *                     127.0 103 1 4 0   16     0   3   62 65                 127
1677543 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Revere - Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2021   grade_5 32 5 86 1   3     0   0   57 70 *                     127.0 32 5 86 1   3     0   0   57 70                 127
1679815 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_5 6 23 90 0   6     0   3   71 57 *                     128.0 6 23 90 0   6     0   3   71 57                 128
1677981 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Southborough - Margaret A Neary   Regular School No Elementary 04 05 2021   grade_5 91 3 5 0   23     0   7   68 61 *                     129.0 91 3 5 0   23     0   7   68 61                 129
1679901 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_5 19 39 59 0   5     0   7   68 61 *                     129.0 19 39 59 0   5     0   7   68 61                 129
1680466 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen - New Hingham Regional Elementary   Regular School No Elementary PK 06 2021   grade_5 12 0 1 0   0     0   0   6 7 *                     13.0 12 0 1 0   0     0   0   6 7                 13
1675626 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell - B.F. Butler Middle School   Regular School No Middle 05 08 2021   grade_5 30 10 45 0   42     0   3   62 68 *                     130.0 30 10 45 0   42     0   3   62 68                 130
1676483 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 New Bedford - Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2021   grade_5 47 20 43 0   1     0   19   72 58 *                     130.0 47 20 43 0   1     0   19   72 58                 130
1679320 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Winthrop - Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2021   grade_5 102 2 23 0   0     0   3   65 65 *                     130.0 102 2 23 0   0     0   3   65 65                 130
1674351 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_5 80 7 31 0   3     0   10   68 63 *                     131.0 80 7 31 0   3     0   10   68 63                 131
1675296 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_5 8 5 116 0   1     0   1   65 66 *                     131.0 8 5 116 0   1     0   1   65 66                 131

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