Data source: Big Local News · About: Big Local

884 rows where grade = "grade_5", state = "MA" and year = 2020 sorted by total

View and edit SQL

year

  • 2020 · 884

grade

  • grade_5 · 884
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
1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1368367 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_5 * * * *   *     *   *   1 * *                     1.0                         1                   1
1372422 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1373330 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1364941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_5 71 2 8 0   9     1   9   55 45 *                     100.0 71 2 8 0   9     1   9   55 45                 100
1369049 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 05 2020   grade_5 88 0 6 0   1     0   5   48 52 *                     100.0 88 0 6 0   1     0   5   48 52                 100
1371516 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2020   grade_5 75 0 13 1   1     0   10   50 50 *                     100.0 75 0 13 1   1     0   10   50 50                 100
1371987 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 North Intermediate   Regular School No Elementary 04 05 2020   grade_5 86 0 5 0   5     0   4   55 45 *                     100.0 86 0 5 0   5     0   4   55 45                 100
1372580 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_5 69 6 9 0   8     0   8   59 41 *                     100.0 69 6 9 0   8     0   8   59 41                 100
1365660 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_5 1 62 35 0   1     0   2   42 59 *                     101.0 1 62 35 0   1     0   2   42 59                 101
1366271 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_5 51 6 8 0   30     0   6   51 50 *                     101.0 51 6 8 0   30     0   6   51 50                 101
1367700 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_5 59 2 36 1   1     0   2   58 43 *                     101.0 59 2 36 1   1     0   2   58 43                 101
1368090 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_5 79 4 10 0   3     0   5   52 49 *                     101.0 79 4 10 0   3     0   5   52 49                 101
1368177 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2020   grade_5 43 5 6 0   33     0   14   53 48 *                     101.0 43 5 6 0   33     0   14   53 48                 101
1368183 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2020   grade_5 38 5 3 0   45     0   10   56 45 *                     101.0 38 5 3 0   45     0   10   56 45                 101
1368667 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_5 38 20 22 0   18     0   3   52 49 *                     101.0 38 20 22 0   18     0   3   52 49                 101
1373637 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Elementary School   Regular School No Elementary PK 05 2020   grade_5 87 1 6 0   0     0   7   52 49 *                     101.0 87 1 6 0   0     0   7   52 49                 101
1367075 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_5 32 12 47 0   8     0   3   55 47 *                     102.0 32 12 47 0   8     0   3   55 47                 102
1367378 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_5 75 6 20 0   0     0   1   59 43 *                     102.0 75 6 20 0   0     0   1   59 43                 102
1370308 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2020   grade_5 13 3 75 1   8     0   2   49 53 *                     102.0 13 3 75 1   8     0   2   49 53                 102
1364890 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_5 76 3 7 0   12     0   5   53 50 *                     103.0 76 3 7 0   12     0   5   53 50                 103
1367704 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_5 33 5 58 1   4     0   2   56 47 *                     103.0 33 5 58 1   4     0   2   56 47                 103
1367856 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 06 2020   grade_5 4 5 92 0   1     0   1   67 36 *                     103.0 4 5 92 0   1     0   1   67 36                 103
1368640 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_5 31 21 16 0   30     0   5   51 52 *                     103.0 31 21 16 0   30     0   5   51 52                 103
1368649 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_5 25 21 39 0   14     0   4   46 57 *                     103.0 25 21 39 0   14     0   4   46 57                 103
1366173 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_5 16 73 5 0   2     0   8   54 50 *                     104.0 16 73 5 0   2     0   8   54 50                 104
1366971 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2020   grade_5 73 7 14 0   6     0   4   61 42 *                     104.0 73 7 14 0   6     0   4   61 42                 104
1369576 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_5 85 3 5 1   7     0   3   57 47 *                     104.0 85 3 5 1   7     0   3   57 47                 104
1370056 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2020   grade_5 89 0 4 0   1     0   10   53 51 *                     104.0 89 0 4 0   1     0   10   53 51                 104
1365480 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_5 26 24 35 0   15     0   6   53 53 *                     106.0 26 24 35 0   15     0   6   53 53                 106
1366327 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_5 48 1 14 0   30     0   13   54 51 *                     106.0 48 1 14 0   30     0   13   54 51                 106
1368189 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2020   grade_5 52 6 7 0   33     0   8   56 50 *                     106.0 52 6 7 0   33     0   8   56 50                 106
1368540 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2020   grade_5 6 12 79 0   6     1   2   52 54 *                     106.0 6 12 79 0   6     1   2   52 54                 106
1370552 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No Elementary KG 05 2020   grade_5 48 7 4 1   33     1   12   56 50 *                     106.0 48 7 4 1   33     1   12   56 50                 106
1371198 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2020   grade_5 96 2 2 0   3     0   3   56 50 *                     106.0 96 2 2 0   3     0   3   56 50                 106
1373036 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_5 90 6 6 0   2     0   2   55 51 *                     106.0 90 6 6 0   2     0   2   55 51                 106
1368954 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_5 48 6 46 0   1     0   6   51 56 *                     107.0 48 6 46 0   1     0   6   51 56                 107
1374004 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2020   grade_5 95 2 4 2   2     0   3   56 52 *                     108.0 95 2 4 2   2     0   3   56 52                 108
1373275 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_5 94 4 4 0   3     0   4   48 61 *                     109.0 94 4 4 0   3     0   4   48 61                 109
1373659 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2020   grade_5 90 4 4 0   7     0   4   53 56 *                     109.0 90 4 4 0   7     0   4   53 56                 109
1365377 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2020   grade_5 4 0 7 0   0     0   0   7 4 *                     11.0 4 0 7 0   0     0   0   7 4                 11
1368060 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_5 0 0 11 0   0     0   0   6 5 *                     11.0 0 0 11 0   0     0   0   6 5                 11
1373781 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_5 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1364805 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_5 97 0 8 0   1     0   4   49 61 *                     110.0 97 0 8 0   1     0   4   49 61                 110
1366215 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_5 13 74 18 0   1     1   3   56 54 *                     110.0 13 74 18 0   1     1   3   56 54                 110
1369236 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2020   grade_5 37 22 44 0   1     0   6   60 50 *                     110.0 37 22 44 0   1     0   6   60 50                 110
1369275 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_5 50 11 40 1   0     0   8   56 54 *                     110.0 50 11 40 1   0     0   8   56 54                 110
1370062 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2020   grade_5 101 3 3 0   0     0   3   62 48 *                     110.0 101 3 3 0   0     0   3   62 48                 110
1371989 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 West Intermediate   Regular School No Elementary 04 05 2020   grade_5 87 3 12 0   5     0   3   54 56 *                     110.0 87 3 12 0   5     0   3   54 56                 110
1372917 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_5 91 5 8 0   2     0   4   48 62 *                     110.0 91 5 8 0   2     0   4   48 62                 110
1372969 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_5 9 22 76 1   2     0   0   51 59 *                     110.0 9 22 76 1   2     0   0   51 59                 110
1365520 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2020   grade_5 1 55 51 0   2     1   1   53 58 *                     111.0 1 55 51 0   2     1   1   53 58                 111
1368171 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2020   grade_5 44 7 6 0   51     0   3   65 46 *                     111.0 44 7 6 0   51     0   3   65 46                 111
1366527 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2020   grade_5 104 4 2 1   1     0   0   50 62 *                     112.0 104 4 2 1   1     0   0   50 62                 112
1366643 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2020   grade_5 59 6 43 0   1     0   3   58 54 *                     112.0 59 6 43 0   1     0   3   58 54                 112
1368119 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2020   grade_5 62 7 37 0   1     0   5   61 51 *                     112.0 62 7 37 0   1     0   5   61 51                 112
1366179 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_5 11 79 16 0   1     2   4   51 62 *                     113.0 11 79 16 0   1     2   4   51 62                 113
1367354 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_5 34 4 72 0   1     0   2   47 66 *                     113.0 34 4 72 0   1     0   2   47 66                 113
1370180 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_5 26 15 20 0   44     5   3   56 57 *                     113.0 26 15 20 0   44     5   3   56 57                 113
1374063 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_5 102 0 7 0   2     0   2   55 58 *                     113.0 102 0 7 0   2     0   2   55 58                 113
1367133 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   grade_5 44 13 41 1   4     0   11   54 60 *                     114.0 44 13 41 1   4     0   11   54 60                 114
1368992 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_5 100 4 3 1   0     0   6   49 65 *                     114.0 100 4 3 1   0     0   6   49 65                 114
1370272 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_5 52 3 49 0   6     1   3   60 54 *                     114.0 52 3 49 0   6     1   3   60 54                 114
1373706 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_5 100 1 7 0   2     0   4   54 60 *                     114.0 100 1 7 0   2     0   4   54 60                 114
1370295 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2020   grade_5 25 3 81 0   4     0   2   55 60 *                     115.0 25 3 81 0   4     0   2   55 60                 115
1364915 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_5 85 1 10 0   15     0   5   56 60 *                     116.0 85 1 10 0   15     0   5   56 60                 116
1368287 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_5 31 10 42 0   27     0   6   54 62 *                     116.0 31 10 42 0   27     0   6   54 62                 116
1368987 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_5 96 2 2 0   2     0   14   75 41 *                     116.0 96 2 2 0   2     0   14   75 41                 116
1369484 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2020   grade_5 105 0 6 0   4     0   1   63 53 *                     116.0 105 0 6 0   4     0   1   63 53                 116
1371359 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2020   grade_5 95 5 3 0   9     0   4   66 50 *                     116.0 95 5 3 0   9     0   4   66 50                 116
1372664 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_5 22 67 18 0   3     0   6   61 55 *                     116.0 22 67 18 0   3     0   6   61 55                 116
1366810 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2020   grade_5 98 2 9 0   1     0   7   60 57 *                     117.0 98 2 9 0   1     0   7   60 57                 117
1367084 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_5 19 17 77 0   1     0   3   52 65 *                     117.0 19 17 77 0   1     0   3   52 65                 117
1368799 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_5 86 2 8 8   2     0   11   56 61 *                     117.0 86 2 8 8   2     0   11   56 61                 117
1368448 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2020   grade_5 99 1 10 0   0     1   7   55 63 *                     118.0 99 1 10 0   0     1   7   55 63                 118
1368868 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2020   grade_5 74 13 14 1   13     0   3   61 57 *                     118.0 74 13 14 1   13     0   3   61 57                 118
1371154 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_5 99 2 7 2   2     0   6   68 50 *                     118.0 99 2 7 2   2     0   6   68 50                 118
1373715 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_5 107 1 8 0   1     0   2   59 60 *                     119.0 107 1 8 0   1     0   2   59 60                 119
1370491 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2020   grade_5 12 0 0 0   0     0   0   7 5 *                     12.0 12 0 0 0   0     0   0   7 5                 12
1371351 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_5 9 0 1 0   0     0   2   9 3 *                     12.0 9 0 1 0   0     0   2   9 3                 12
1373946 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   grade_5 9 0 1 0   0     0   2   7 5 *                     12.0 9 0 1 0   0     0   2   7 5                 12
1366148 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   grade_5 9 75 28 0   0     0   9   64 57 *                     121.0 9 75 28 0   0     0   9   64 57                 121
1366598 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_5 12 7 98 0   0     0   4   64 57 *                     121.0 12 7 98 0   0     0   4   64 57                 121
1369819 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2020   grade_5 96 3 18 0   0     0   4   67 54 *                     121.0 96 3 18 0   0     0   4   67 54                 121
1370844 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2020   grade_5 7 31 82 0   0     0   1   61 60 *                     121.0 7 31 82 0   0     0   1   61 60                 121
1366708 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2020   grade_5 107 5 1 0   3     0   6   61 61 *                     122.0 107 5 1 0   3     0   6   61 61                 122
1367126 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_5 50 9 45 0   8     0   10   66 56 *                     122.0 50 9 45 0   8     0   10   66 56                 122
1371779 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2020   grade_5 74 1 3 0   40     0   4   53 69 *                     122.0 74 1 3 0   40     0   4   53 69                 122
1368944 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_5 80 1 37 0   2     0   3   71 52 *                     123.0 80 1 37 0   2     0   3   71 52                 123
1366960 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_5 95 4 17 0   4     0   4   62 62 *                     124.0 95 4 17 0   4     0   4   62 62                 124
1367120 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2020   grade_5 72 11 27 0   2     0   12   69 55 *                     124.0 72 11 27 0   2     0   12   69 55                 124
1368000 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_5 6 1 117 0   0     0   0   63 61 *                     124.0 6 1 117 0   0     0   0   63 61                 124
1369062 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2020   grade_5 110 3 3 0   5     0   3   67 57 *                     124.0 110 3 3 0   5     0   3   67 57                 124
1365666 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_5 37 35 48 0   5     0   1   63 63 *                     126.0 37 35 48 0   5     0   1   63 63                 126
1366154 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   grade_5 30 62 24 1   1     1   7   69 57 *                     126.0 30 62 24 1   1     1   7   69 57                 126
1367167 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2020   grade_5 71 8 29 0   6     0   12   64 62 *                     126.0 71 8 29 0   6     0   12   64 62                 126
1367566 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_5 85 5 30 0   1     0   5   59 67 *                     126.0 85 5 30 0   1     0   5   59 67                 126
1365633 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_5 11 23 22 1   64     0   6   66 61 *                     127.0 11 23 22 1   64     0   6   66 61                 127
1365710 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_5 11 21 17 0   75     0   3   62 65 *                     127.0 11 21 17 0   75     0   3   62 65                 127

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