Data source: Big Local News · About: Big Local

966 rows where grade = "grade_3", state = "MA" and year = 2021 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2021 · 966

grade

  • grade_3 · 966
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
1672299 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_3 42 2 6 0   0     0   6   32 24 *                     56.0 42 2 6 0   0     0   6   32 24                 56
1672303 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_3 43 6 5 0   1     0   6   34 27 *                     61.0 43 6 5 0   1     0   6   34 27                 61
1672307 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_3 37 15 24 1   1     0   3   39 42 *                     81.0 37 15 24 1   1     0   3   39 42                 81
1672311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_3 26 10 26 0   2     0   13   34 43 *                     77.0 26 10 26 0   2     0   13   34 43                 77
1672315 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_3 82 1 12 0   0     0   8   51 52 *                     103.0 82 1 12 0   0     0   8   51 52                 103
1672347 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown - Swift River Elementary   Regular School No Elementary 01 03 2021   grade_3 137 0 10 0   3     0   5   75 80 *                     155.0 137 0 10 0   3     0   5   75 80                 155
1672358 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham - Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2021   grade_3 52 2 12 0   2     2   1   34 37 *                     71.0 52 2 12 0   2     2   1   34 37                 71
1672362 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham - Stall Brook   Regular School No Elementary KG 03 2021   grade_3 59 1 2 0   1     2   3   38 30 *                     68.0 59 1 2 0   1     2   3   38 30                 68
1672492 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   grade_3 1 14 17 0   1     0   1   17 17 *                     34.0 1 14 17 0   1     0   1   17 17                 34
1672512 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   grade_3 2 20 12 1   0     0   0   22 13 *                     35.0 2 20 12 1   0     0   0   22 13                 35
1672543 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston - Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2021   grade_3 0 24 10 0   0     0   0   16 18 *                     34.0 0 24 10 0   0     0   0   16 18                 34
1674941 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Haverhill - Tilton   Regular School No Elementary KG 03 2021   grade_3 33 6 59 0   4     0   4   47 59 *                     106.0 33 6 59 0   4     0   4   47 59                 106
1675099 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 Holyoke - H.B. Lawrence School   Regular School No Elementary KG 03 2021   grade_3 6 5 29 0   0     0   2   22 20 *                     42.0 6 5 29 0   0     0   2   22 20                 42
1675128 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton - Elmwood   Regular School No Elementary 02 03 2021   grade_3 150 2 14 0   90     0   16   138 134 *                     272.0 150 2 14 0   90     0   16   138 134                 272
1675461 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   grade_3 27 4 15 1   1     1   8   29 28 *                     57.0 27 4 15 1   1     1   8   29 28                 57
1675673 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Ludlow - Chapin Street Elementary School   Regular School No Elementary 02 03 2021   grade_3 116 1 24 0   2     0   6   73 76 *                     149.0 116 1 24 0   2     0   6   73 76                 149
1675952 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Marblehead - Glover   Regular School No Elementary PK 03 2021   grade_3 76 2 3 0   0     0   4   37 48 *                     85.0 76 2 3 0   0     0   4   37 48                 85
1676059 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Mattapoisett - Center   Regular School No Elementary PK 03 2021   grade_3 46 0 3 0   1     0   4   25 29 *                     54.0 46 0 3 0   1     0   4   25 29                 54
1676067 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard - Green Meadow   Regular School No Elementary PK 03 2021   grade_3 82 1 18 0   1     0   8   56 54 *                     110.0 82 1 18 0   1     0   8   56 54                 110
1676084 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield - Ralph Wheelock School   Regular School No Elementary 02 03 2021   grade_3 165 5 5 0   5     0   10   78 112 *                     190.0 165 5 5 0   5     0   10   78 112                 190
1676281 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury - Elmwood Street   Regular School No Elementary PK 03 2021   grade_3 102 4 12 0   2     0   4   55 69 *                     124.0 102 4 12 0   2     0   4   55 69                 124
1676608 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport - Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2021   grade_3 107 2 7 0   3     0   3   49 73 *                     122.0 107 2 7 0   3     0   3   49 73                 122
1676959 MA Bristol   school 2509000 218   Norton 250900001450 2180010 Norton - L G Nourse Elementary   Regular School No Elementary KG 03 2021   grade_3 60 1 4 0   4     0   2   40 31 *                     71.0 60 1 4 0   4     0   2   40 31                 71
1676964 MA Bristol   school 2509000 218   Norton 250900001449 2180015 Norton - J C Solmonese   Regular School No Elementary PK 03 2021   grade_3 95 2 4 0   0     0   6   50 57 *                     107.0 95 2 4 0   0     0   6   50 57                 107
1677267 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Plainville - Anna Ware Jackson   Regular School No Elementary PK 03 2021   grade_3 68 6 9 0   4     0   2   42 47 *                     89.0 68 6 9 0   4     0   2   42 47                 89
1677983 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough - Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2021   grade_3 98 0 7 0   20     0   8   68 65 *                     133.0 98 0 7 0   20     0   8   68 65                 133
1678596 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Topsfield - Steward Elementary   Regular School No Elementary PK 03 2021   grade_3 74 1 4 1   1     0   3   42 42 *                     84.0 74 1 4 1   1     0   3   42 42                 84
1678622 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_3 115 2 6 3   0     0   2   66 62 *                     128.0 115 2 6 3   0     0   2   66 62                 128
1678766 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Ware - Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2021   grade_3 64 2 3 0   0     0   2   31 40 *                     71.0 64 2 3 0   0     0   2   31 40                 71
1678923 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 Westborough - J Harding Armstrong   Regular School No Elementary KG 03 2021   grade_3 52 2 7 0   50     0   2   62 51 *                     113.0 52 2 7 0   50     0   2   62 51                 113
1678927 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough - Annie E Fales   Regular School No Elementary KG 03 2021   grade_3 41 2 2 0   26     0   3   27 47 *                     74.0 41 2 2 0   26     0   3   27 47                 74
1678932 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Westborough - Elsie A Hastings Elementary   Regular School No Elementary PK 03 2021   grade_3 37 1 19 0   38     0   2   45 52 *                     97.0 37 1 19 0   38     0   2   45 52                 97
1678959 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_3 72 2 5 0   1     0   5   47 38 *                     85.0 72 2 5 0   1     0   5   47 38                 85
1679059 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Weston - Country   Regular School No Elementary PK 03 2021   grade_3 41 5 7 0   18     0   1   33 39 *                     72.0 41 5 7 0   18     0   1   33 39                 72
1679066 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Weston - Woodland   Regular School No Elementary PK 03 2021   grade_3 23 6 8 0   7     0   2   27 19 *                     46.0 23 6 8 0   7     0   2   27 19                 46
1679242 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington - Woburn Street   Regular School No Elementary 01 03 2021   grade_3 118 4 4 0   7     0   7   61 79 *                     140.0 118 4 4 0   7     0   7   61 79                 140
1679245 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington - Shawsheen Elementary   Regular School No Elementary 01 03 2021   grade_3 89 2 7 0   7     0   4   53 56 *                     109.0 89 2 7 0   7     0   4   53 56                 109
1679692 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham - Delaney   Regular School No Elementary PK 03 2021   grade_3 109 3 7 0   4     0   10   63 70 *                     133.0 109 3 7 0   4     0   10   63 70                 133
1680298 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Regional - Hoosac Valley Elementary School   Regular School No Elementary PK 03 2021   grade_3 63 3 2 0   0     0   2   40 30 *                     70.0 63 3 2 0   0     0   2   40 30                 70
1680437 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   grade_3 219 11 13 0   5     2   8   140 118 *                     258.0 219 11 13 0   5     2   8   140 118                 258
1680504 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth - Ezra H Baker Innovation School   Regular School No Elementary PK 03 2021   grade_3 34 3 9 0   0     1   5   29 23 *                     52.0 34 3 9 0   0     1   5   29 23                 52
1680509 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth - Marguerite E Small Elementary   Regular School No Elementary PK 03 2021   grade_3 25 9 7 1   2     0   2   22 24 *                     46.0 25 9 7 1   2     0   2   22 24                 46
1680513 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth - Station Avenue Elementary   Regular School No Elementary KG 03 2021   grade_3 74 5 7 1   5     1   4   42 55 *                     97.0 74 5 7 1   5     1   4   42 55                 97
1680601 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown-Lakeville - Freetown Elementary School   Regular School No Elementary PK 03 2021   grade_3 90 1 3 0   1     0   2   44 53 *                     97.0 90 1 3 0   1     0   2   44 53                 97
1680605 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville - Assawompset Elementary School   Regular School No Elementary KG 03 2021   grade_3 101 4 6 0   0     0   2   60 53 *                     113.0 101 4 6 0   0     0   2   60 53                 113
1680728 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Hampden-Wilbraham - Stony Hill School   Regular School No Elementary 02 03 2021   grade_3 126 5 7 0   3     0   3   68 76 *                     144.0 126 5 7 0   3     0   3   68 76                 144
1672009 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_3 117 10 11 2   3     0   1   67 77 *                     144.0 117 10 11 2   3     0   1   67 77                 144
1672027 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_3 85 3 3 0   1     0   3   48 47 *                     95.0 85 3 3 0   1     0   3   48 47                 95
1672037 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_3 30 1 7 0   2     0   0   20 20 *                     40.0 30 1 7 0   2     0   0   20 20                 40
1672042 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_3 55 0 8 0   2     0   5   38 32 *                     70.0 55 0 8 0   2     0   5   38 32                 70
1672047 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_3 47 3 10 0   3     0   1   36 28 *                     64.0 47 3 10 0   3     0   1   36 28                 64
1672052 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_3 44 2 7 0   1     0   2   26 30 *                     56.0 44 2 7 0   1     0   2   26 30                 56
1672066 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_3 38 0 5 0   0     0   4   27 20 *                     47.0 38 0 5 0   0     0   4   27 20                 47
1672072 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_3 58 2 14 0   1     0   3   42 36 *                     78.0 58 2 14 0   1     0   3   42 36                 78
1672220 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro - A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2021   grade_3 53 4 8 0   2     0   1   34 34 *                     68.0 53 4 8 0   2     0   1   34 34                 68
1672226 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Attleboro - Thomas Willett Elementary School   Regular School No Elementary KG 04 2021   grade_3 42 7 9 0   3     0   9   39 31 *                     70.0 42 7 9 0   3     0   9   39 31                 70
1672231 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_3 61 3 21 0   4     0   9   48 50 *                     98.0 61 3 21 0   4     0   9   48 50                 98
1672236 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro - Hill-Roberts Elementary School   Regular School No Elementary KG 04 2021   grade_3 61 3 11 1   3     0   3   34 48 *                     82.0 61 3 11 1   3     0   3   34 48                 82
1672241 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro - Peter Thacher Elementary School   Regular School No Elementary KG 04 2021   grade_3 54 11 7 1   10     0   6   47 42 *                     89.0 54 11 7 1   10     0   6   47 42                 89
1672379 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont - Winn Brook   Regular School No Elementary KG 04 2021   grade_3 63 2 3 0   17     0   8   51 42 *                     93.0 63 2 3 0   17     0   8   51 42                 93
1672384 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont - Mary Lee Burbank   Regular School No Elementary KG 04 2021   grade_3 40 5 3 0   18     0   8   37 37 *                     74.0 40 5 3 0   18     0   8   37 37                 74
1672389 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Belmont - Daniel Butler   Regular School No Elementary KG 04 2021   grade_3 29 0 2 0   23     0   13   38 29 *                     67.0 29 0 2 0   23     0   13   38 29                 67
1672395 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_3 82 4 3 0   17     0   8   57 57 *                     114.0 82 4 3 0   17     0   8   57 57                 114
1672409 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_3 69 1 1 0   0     0   4   36 39 *                     75.0 69 1 1 0   0     0   4   36 39                 75
1672419 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly - Centerville Elementary   Regular School No Elementary KG 04 2021   grade_3 36 1 6 0   1     0   0   20 24 *                     44.0 36 1 6 0   1     0   0   20 24                 44
1672424 MA Essex   school 2502640 30   Beverly 250264000168 300015 Beverly - Cove Elementary   Regular School No Elementary KG 04 2021   grade_3 45 0 13 0   1     0   3   32 30 *                     62.0 45 0 13 0   1     0   3   32 30                 62
1672429 MA Essex   school 2502640 30   Beverly 250264000169 300033 Beverly - Hannah Elementary   Regular School No Elementary KG 04 2021   grade_3 35 0 4 0   4     0   0   27 16 *                     43.0 35 0 4 0   4     0   0   27 16                 43
1672434 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly - North Beverly Elementary   Regular School No Elementary KG 04 2021   grade_3 47 2 6 0   2     0   1   30 28 *                     58.0 47 2 6 0   2     0   1   30 28                 58
1672439 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly - Ayers/Ryal Side School   Regular School No Elementary KG 04 2021   grade_3 104 9 25 0   5     0   9   80 72 *                     152.0 104 9 25 0   5     0   9   80 72                 152
1672453 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica - Thomas Ditson   Regular School No Elementary KG 04 2021   grade_3 83 4 7 0   11     0   6   67 44 *                     111.0 83 4 7 0   11     0   6   67 44                 111
1672458 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica - Frederick J Dutile   Regular School No Elementary KG 04 2021   grade_3 38 3 2 0   4     0   2   23 26 *                     49.0 38 3 2 0   4     0   2   23 26                 49
1672463 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica - John F Kennedy   Regular School No Elementary KG 04 2021   grade_3 51 0 7 0   3     0   5   31 35 *                     66.0 51 0 7 0   3     0   5   31 35                 66
1672468 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Billerica - Parker   Regular School No Elementary KG 04 2021   grade_3 56 5 4 0   10     0   4   34 45 *                     79.0 56 5 4 0   10     0   4   34 45                 79
1672473 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Billerica - Hajjar Elementary   Regular School No Elementary KG 04 2021   grade_3 47 2 5 0   3     0   2   25 34 *                     59.0 47 2 5 0   3     0   2   25 34                 59
1672552 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Boston - Mattahunt Elementary School   Regular School No Elementary PK 04 2021   grade_3 3 45 17 0   0     0   4   42 27 *                     69.0 3 45 17 0   0     0   4   42 27                 69
1673771 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_3 66 4 6 0   23     0   3   53 49 *                     102.0 66 4 6 0   23     0   3   53 49                 102
1673776 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford - South Row   Regular School No Elementary KG 04 2021   grade_3 57 7 5 0   15     0   3   37 50 *                     87.0 57 7 5 0   15     0   3   37 50                 87
1673781 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_3 54 7 11 0   24     1   0   48 49 *                     97.0 54 7 11 0   24     1   0   48 49                 97
1673786 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford - Byam School   Regular School No Elementary KG 04 2021   grade_3 71 1 6 1   21     0   5   54 51 *                     105.0 71 1 6 1   21     0   5   54 51                 105
1673805 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_3 6 10 105 0   0     0   6   65 62 *                     127.0 6 10 105 0   0     0   6   65 62                 127
1673809 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_3 18 6 122 0   0     0   2   74 74 *                     148.0 18 6 122 0   0     0   2   74 74                 148
1673819 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_3 12 8 118 0   0     0   2   64 76 *                     140.0 12 8 118 0   0     0   2   64 76                 140
1673923 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton - Clinton Elementary   Regular School No Elementary PK 04 2021   grade_3 86 2 43 0   0     0   4   70 65 *                     135.0 86 2 43 0   0     0   4   70 65                 135
1674177 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton - Center School   Regular School No Elementary KG 04 2021   grade_3 31 1 4 0   0     0   0   12 24 *                     36.0 31 1 4 0   0     0   0   12 24                 36
1674183 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Easthampton - Maple   Regular School No Elementary PK 04 2021   grade_3 24 0 4 1   2     0   2   19 14 *                     33.0 24 0 4 1   2     0   2   19 14                 33
1674188 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton - Neil A Pepin   Regular School No Elementary KG 04 2021   grade_3 22 0 9 1   3     0   3   21 17 *                     38.0 22 0 9 1   3     0   3   21 17                 38
1674451 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_3 31 3 5 1   1     0   4   23 22 *                     45.0 31 3 5 1   1     0   4   23 22                 45
1674457 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_3 33 4 6 0   1     0   5   30 19 *                     49.0 33 4 6 0   1     0   5   30 19                 49
1674462 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_3 62 4 7 0   1     0   9   56 27 *                     83.0 62 4 7 0   1     0   9   56 27                 83
1674467 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_3 67 2 6 0   1     0   6   40 42 *                     82.0 67 2 6 0   1     0   6   40 42                 82
1674482 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_3 26 6 54 0   4     0   10   51 49 *                     100.0 26 6 54 0   4     0   10   51 49                 100
1674488 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   grade_3 26 7 57 0   2     0   10   59 43 *                     102.0 26 7 57 0   2     0   10   59 43                 102
1674498 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg - South Street Elementary   Regular School No Elementary PK 04 2021   grade_3 31 10 67 0   5     0   3   60 56 *                     116.0 31 10 67 0   5     0   3   60 56                 116
1674537 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Foxborough - Mabelle M Burrell   Regular School No Elementary PK 04 2021   grade_3 40 1 5 0   4     0   1   22 29 *                     51.0 40 1 5 0   4     0   1   22 29                 51
1674542 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Foxborough - Vincent M Igo Elementary   Regular School No Elementary KG 04 2021   grade_3 58 4 6 0   8     0   2   43 35 *                     78.0 58 4 6 0   8     0   2   43 35                 78
1674547 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough - Charles Taylor Elementary   Regular School No Elementary KG 04 2021   grade_3 27 2 3 0   4     0   2   20 18 *                     38.0 27 2 3 0   4     0   2   20 18                 38
1674678 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner - Elm Street School   Regular School No Elementary 02 04 2021   grade_3 97 5 49 0   4     0   12   78 89 *                     167.0 97 5 49 0   4     0   12   78 89                 167
1674804 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Greenfield - Federal Street School   Regular School No Elementary KG 04 2021   grade_3 32 3 7 0   0     0   5   25 22 *                     47.0 32 3 7 0   0     0   5   25 22                 47
1674809 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield - Discovery School at Four Corners   Regular School No Elementary KG 04 2021   grade_3 38 0 4 0   1     0   1   28 16 *                     44.0 38 0 4 0   1     0   1   28 16                 44
1674814 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Greenfield - Newton School   Regular School No Elementary KG 04 2021   grade_3 20 1 16 0   0     0   2   17 22 *                     39.0 20 1 16 0   0     0   2   17 22                 39

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