enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 976 ✖

grade ✖

  • grade_2 · 976 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2228761 2228761 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_2 113 4 8 0   5     1   1   59 73                       132.0 113 4 8 0   5     1   1   59 73                 132
2228994 2228994 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   grade_2 123 3 24 0   31     1   7   92 97                       189.0 123 3 24 0   31     1   7   92 97                 189
2229066 2229066 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Auburn: Bryn Mawr   Regular School No Elementary KG 02 2018   grade_2 75 1 14 0   1     0   3   48 46                       94.0 75 1 14 0   1     0   3   48 46                 94
2229071 2229071 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   grade_2 77 2 7 0   4     0   2   54 38                       92.0 77 2 7 0   4     0   2   54 38                 92
2229139 2229139 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_2 123 12 14 0   36     0   16   98 103                       201.0 123 12 14 0   36     0   16   98 103                 201
2229429 2229429 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston: Higginson   Regular School No Elementary PK 02 2018   grade_2 0 18 25 1   1     0   0   22 23                       45.0 0 18 25 1   1     0   0   22 23                 45
2230305 2230305 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford: Harry Lee Cole   Regular School No Elementary PK 02 2018   grade_2 100 0 4 1   3     0   5   60 53                       113.0 100 0 4 1   3     0   5   60 53                 113
2230380 2230380 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster: Stony Brook Elementary   Regular School No Elementary PK 02 2018   grade_2 60 2 5 0   0     0   5   37 35                       72.0 60 2 5 0   0     0   5   37 35                 72
2230945 2230945 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee: Belcher   Regular School No Elementary KG 02 2018   grade_2 45 7 22 0   0     0   2   40 36                       76.0 45 7 22 0   0     0   2   40 36                 76
2231057 2231057 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset: Joseph Osgood   Regular School No Elementary PK 02 2018   grade_2 101 4 0 0   3     0   0   57 51                       108.0 101 4 0 0   3     0   0   57 51                 108
2231298 2231298 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury: Chandler Elementary   Regular School No Elementary PK 02 2018   grade_2 188 2 8 0   2     0   6   100 106                       206.0 188 2 8 0   2     0   6   100 106                 206
2231312 2231312 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 East Bridgewater: Central   Regular School No Elementary PK 02 2018   grade_2 140 6 2 1   3     0   10   84 78                       162.0 140 6 2 1   3     0   10   84 78                 162
2231370 2231370 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 East Longmeadow: Meadow Brook   Regular School No Elementary PK 02 2018   grade_2 142 2 18 0   9     0   7   92 86                       178.0 142 2 18 0   9     0   7   92 86                 178
2231388 2231388 MA Bristol   school 2504620 88   Easton 250462000980 880003 Easton: Center School   Regular School No Elementary PK 02 2018   grade_2 71 9 0 0   3     0   3   47 39                       86.0 71 9 0 0   3     0   3   47 39                 86
2231393 2231393 MA Bristol   school 2504620 88   Easton 250462000624 880015 Easton: Parkview Elementary   Regular School No Elementary PK 02 2018   grade_2 80 4 6 0   1     0   9   55 45                       100.0 80 4 6 0   1     0   9   55 45                 100
2231398 2231398 MA Bristol   school 2504620 88   Easton 250462002381 880020 Easton: Moreau Hall   Regular School No Elementary PK 02 2018   grade_2 52 2 2 2   1     0   1   33 27                       60.0 52 2 2 2   1     0   1   33 27                 60
2232144 2232144 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover: Center Elementary   Regular School No Elementary KG 02 2018   grade_2 111 0 2 0   2     0   1   51 65                       116.0 111 0 2 0   2     0   1   51 65                 116
2232193 2232193 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_2 25 0 10 0   0     0   0   20 15                       35.0 25 0 10 0   0     0   0   20 15                 35
2232254 2232254 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Haverhill: Walnut Square   Regular School No Elementary KG 02 2018   grade_2 42 0 8 0   0     0   1   21 30                       51.0 42 0 8 0   0     0   1   21 30                 51
2232343 2232343 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston: Placentino Elementary   Regular School No Elementary PK 02 2018   grade_2 173 2 10 1   20     0   7   116 97                       213.0 173 2 10 1   20     0   7   116 97                 213
2232556 2232556 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston: Kingston Elementary   Regular School No Elementary KG 02 2018   grade_2 161 0 4 1   0     0   0   88 78                       166.0 161 0 4 1   0     0   0   88 78                 166
2232616 2232616 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence: James F Hennessey   Regular School No Elementary PK 02 2018   grade_2 4 1 84 0   1     0   2   41 51                       92.0 4 1 84 0   1     0   2   41 51                 92
2232735 2232735 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester: Leicester Primary School   Regular School No Elementary PK 02 2018   grade_2 76 8 9 0   5     0   1   64 35                       99.0 76 8 9 0   5     0   1   64 35                 99
2232911 2232911 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton: Shaker Lane Elementary   Regular School No Elementary PK 02 2018   grade_2 110 2 2 0   9     0   3   57 69                       126.0 110 2 2 0   9     0   3   57 69                 126
2233155 2233155 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg: Lunenburg Primary School   Regular School No Elementary PK 02 2018   grade_2 103 3 8 0   5     0   4   63 60                       123.0 103 3 8 0   5     0   4   63 60                 123
2233423 2233423 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   grade_2 184 5 19 1   29     0   17   147 108                       255.0 184 5 19 1   29     0   17   147 108                 255
2233555 2233555 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_2 84 6 9 8   1     0   11   60 59                       119.0 84 6 9 8   1     0   11   60 59                 119
2233806 2233806 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton: Fuller Meadow   Regular School No Elementary KG 02 2018   grade_2 61 1 2 0   2     0   5   38 33                       71.0 61 1 2 0   2     0   5   38 33                 71
2233816 2233816 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Milford: Memorial   Regular School No Elementary KG 02 2018   grade_2 94 4 50 1   5     0   7   83 78                       161.0 94 4 50 1   5     0   7   83 78                 161
2233820 2233820 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford: Brookside   Regular School No Elementary KG 02 2018   grade_2 102 6 47 1   5     0   6   85 82                       167.0 102 6 47 1   5     0   6   85 82                 167
2233940 2233940 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket: Nantucket Elementary   Regular School No Elementary PK 02 2018   grade_2 67 11 32 0   2     0   3   64 51                       115.0 67 11 32 0   2     0   3   64 51                 115
2234381 2234381 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 Norfolk: H Olive Day   Regular School No Elementary PK 02 2018   grade_2 134 0 7 0   2     0   4   81 66                       147.0 134 0 7 0   2     0   4   81 66                 147
2234754 2234754 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Orange: Fisher Hill   Regular School No Elementary PK 02 2018   grade_2 63 0 9 0   1     0   4   34 43                       77.0 63 0 9 0   1     0   4   34 43                 77
2235515 2235515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_2 195 3 9 0   6     1   0   106 108                       214.0 195 3 9 0   6     1   0   106 108                 214
2236392 2236392 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton: Sutton Early Learning   Regular School No Elementary PK 02 2018   grade_2 91 0 1 0   1     0   4   48 49                       97.0 91 0 1 0   1     0   4   48 49                 97
2236442 2236442 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Swansea: Gardner   Regular School No Elementary KG 02 2018   grade_2 74 0 3 0   0     0   1   38 40                       78.0 74 0 3 0   0     0   1   38 40                 78
2236447 2236447 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Swansea: Mark G Hoyle Elementary   Regular School No Elementary PK 02 2018   grade_2 50 0 1 0   1     0   1   25 28                       53.0 50 0 1 0   1     0   1   25 28                 53
2236531 2236531 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 Tewksbury: L F Dewing   Regular School No Elementary PK 02 2018   grade_2 113 5 7 0   3     0   2   73 57                       130.0 113 5 7 0   3     0   2   73 57                 130
2236535 2236535 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Tewksbury: Heath-Brook   Regular School No Elementary KG 02 2018   grade_2 99 0 1 0   2     0   4   51 55                       106.0 99 0 1 0   2     0   4   51 55                 106
2236603 2236603 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge: Taft Early Learning Center   Regular School No Elementary PK 02 2018   grade_2 110 4 7 0   2     0   4   66 61                       127.0 110 4 7 0   2     0   4   66 61                 127
2236787 2236787 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   grade_2 139 9 16 4   1     0   27   105 91                       196.0 139 9 16 4   1     0   27   105 91                 196
2237098 2237098 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Westford: Nabnasset   Regular School No Elementary KG 02 2018   grade_2 90 1 1 0   32     0   5   57 72                       129.0 90 1 1 0   32     0   5   57 72                 129
2237102 2237102 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Westford: Col John Robinson   Regular School No Elementary KG 02 2018   grade_2 70 2 1 0   23     0   1   54 43                       97.0 70 2 1 0   23     0   1   54 43                 97
2237110 2237110 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Westford: Rita E. Miller Elementary School   Regular School No Elementary KG 02 2018   grade_2 65 2 6 0   35     0   11   52 67                       119.0 65 2 6 0   35     0   11   52 67                 119
2237161 2237161 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport: Alice A Macomber   Regular School No Elementary PK 02 2018   grade_2 110 0 2 0   0     0   4   67 49                       116.0 110 0 2 0   0     0   4   67 49                 116
2237404 2237404 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Winchendon: Memorial   Regular School No Elementary KG 02 2018   grade_2 81 1 6 0   2     0   4   51 43                       94.0 81 1 6 0   2     0   4   51 43                 94
2237472 2237472 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 Winthrop: William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2018   grade_2 107 1 25 0   0     0   3   63 73                       136.0 107 1 25 0   0     0   3   63 73                 136
2238706 2238706 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 Blackstone-Millville: John F Kennedy Elementary   Regular School No Elementary KG 02 2018   grade_2 102 2 8 0   1     0   6   74 45                       119.0 102 2 8 0   1     0   6   74 45                 119
2239396 2239396 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Pentucket: Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2018   grade_2 58 0 6 0   0     0   0   28 36                       64.0 58 0 6 0   0     0   0   28 36                 64
2239545 2239545 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District: Woodland School   Regular School No Elementary PK 02 2018   grade_2 102 2 3 0   0     0   1   58 50                       108.0 102 2 3 0   0     0   1   58 50                 108
2239654 2239654 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett: Naquag Elementary School   Regular School No Elementary KG 02 2018   grade_2 120 2 9 1   2     0   2   64 72                       136.0 120 2 9 1   2     0   2   64 72                 136
2239761 2239761 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   grade_2 101 1 2 0   0     0   6   59 51                       110.0 101 1 2 0   0     0   6   59 51                 110
2229107 2229107 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_2 57 2 5 0   1     0   1   41 25                       66.0 57 2 5 0   1     0   1   41 25                 66
2229112 2229112 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_2 59 2 5 0   0     0   2   36 32                       68.0 59 2 5 0   0     0   2   36 32                 68
2229117 2229117 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   grade_2 29 17 36 1   3     0   4   50 40                       90.0 29 17 36 1   3     0   4   50 40                 90
2229122 2229122 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   grade_2 82 3 6 0   0     0   4   55 40                       95.0 82 3 6 0   0     0   4   55 40                 95
2229163 2229163 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_2 138 4 4 2   3     0   5   82 74                       156.0 138 4 4 2   3     0   5   82 74                 156
2229178 2229178 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   grade_2 77 1 4 0   1     0   0   45 38                       83.0 77 1 4 0   1     0   0   45 38                 83
2229183 2229183 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   grade_2 64 0 2 0   2     0   2   37 33                       70.0 64 0 2 0   2     0   2   37 33                 70
2229363 2229363 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   grade_2 2 30 15 0   4     1   0   27 25                       52.0 2 30 15 0   4     1   0   27 25                 52
2229387 2229387 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston: Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2018   grade_2 0 18 20 0   0     0   0   17 21                       38.0 0 18 20 0   0     0   0   17 21                 38
2229423 2229423 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston: Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2018   grade_2 3 29 6 0   3     0   4   26 19                       45.0 3 29 6 0   3     0   4   26 19                 45
2229449 2229449 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Boston: Beethoven   Regular School No Elementary PK 03 2018   grade_2 40 32 16 0   3     0   2   44 49                       93.0 40 32 16 0   3     0   2   44 49                 93
2231035 2231035 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton: Clinton Elementary   Regular School No Elementary PK 03 2018   grade_2 104 5 30 0   3     0   3   73 72                       145.0 104 5 30 0   3     0   3   73 72                 145
2231790 2231790 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   grade_2 47 3 16 0   7     0   7   41 39                       80.0 47 3 16 0   7     0   7   41 39                 80
2232064 2232064 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 Granby: West Street   Regular School No Elementary PK 03 2018   grade_2 44 0 4 1   1     0   1   28 23                       51.0 44 0 4 1   1     0   1   28 23                 51
2232357 2232357 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke: Joseph Metcalf School   Regular School No Elementary PK 03 2018   grade_2 18 4 18 0   1     0   1   16 26                       42.0 18 4 18 0   1     0   1   16 26                 42
2232433 2232433 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 Holyoke: H.B. Lawrence School   Regular School No Elementary KG 03 2018   grade_2 1 3 67 0   0     0   1   39 33                       72.0 1 3 67 0   0     0   1   39 33                 72
2232467 2232467 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton: Elmwood   Regular School No Elementary 02 03 2018   grade_2 171 1 6 1   46     0   13   119 119                       238.0 171 1 6 1   46     0   13   119 119                 238
2232888 2232888 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln: Hanscom Primary   Regular School No Elementary PK 03 2018   grade_2 43 1 24 0   2     1   4   39 36                       75.0 43 1 24 0   2     1   4   39 36                 75
2233137 2233137 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Ludlow: Chapin Street Elementary School   Regular School No Elementary 02 03 2018   grade_2 126 1 25 1   1     0   8   74 88                       162.0 126 1 25 1   1     0   8   74 88                 162
2233440 2233440 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Marblehead: Malcolm L Bell   Regular School No Elementary KG 03 2018   grade_2 51 3 8 0   0     0   2   32 32                       64.0 51 3 8 0   0     0   2   32 32                 64
2233443 2233443 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead: L H Coffin   Regular School No Elementary 02 03 2018   grade_2 62 0 4 0   2     1   4   40 33                       73.0 62 0 4 0   2     1   4   40 33                 73
2233456 2233456 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Marblehead: Glover   Regular School No Elementary PK 03 2018   grade_2 57 1 9 0   0     0   6   42 31                       73.0 57 1 9 0   0     0   6   42 31                 73
2233573 2233573 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Mattapoisett: Center   Regular School No Elementary PK 03 2018   grade_2 50 1 4 0   1     0   2   32 26                       58.0 50 1 4 0   1     0   2   32 26                 58
2233583 2233583 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard: Green Meadow   Regular School No Elementary PK 03 2018   grade_2 88 0 12 0   1     0   6   55 52                       107.0 88 0 12 0   1     0   6   55 52                 107
2233604 2233604 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield: Ralph Wheelock School   Regular School No Elementary 02 03 2018   grade_2 170 5 5 0   9     0   6   95 100                       195.0 170 5 5 0   9     0   6   95 100                 195
2233840 2233840 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury: Elmwood Street   Regular School No Elementary PK 03 2018   grade_2 109 0 7 0   4     0   5   79 46                       125.0 109 0 7 0   4     0   5   79 46                 125
2234225 2234225 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport: Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2018   grade_2 126 2 10 0   0     0   0   73 65                       138.0 126 2 10 0   0     0   0   73 65                 138
2234646 2234646 MA Bristol   school 2509000 218   Norton 250900001450 2180010 Norton: L G Nourse Elementary   Regular School No Elementary KG 03 2018   grade_2 54 1 2 0   0     0   3   28 32                       60.0 54 1 2 0   0     0   3   28 32                 60
2234652 2234652 MA Bristol   school 2509000 218   Norton 250900001449 2180015 Norton: J C Solmonese   Regular School No Elementary PK 03 2018   grade_2 85 0 1 0   2     0   7   54 41                       95.0 85 0 1 0   2     0   7   54 41                 95
2235006 2235006 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Plainville: Anna Ware Jackson   Regular School No Elementary PK 03 2018   grade_2 72 2 7 0   2     0   0   45 38                       83.0 72 2 7 0   2     0   0   45 38                 83
2235858 2235858 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough: Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2018   grade_2 93 3 9 0   25     1   7   78 60                       138.0 93 3 9 0   25     1   7   78 60                 138
2236572 2236572 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Topsfield: Steward Elementary   Regular School No Elementary PK 03 2018   grade_2 79 0 1 1   1     0   2   48 36                       84.0 79 0 1 1   1     0   2   48 36                 84
2236771 2236771 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Ware: Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2018   grade_2 76 0 8 0   0     0   2   45 41                       86.0 76 0 8 0   0     0   2   45 41                 86
2236957 2236957 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 Westborough: J Harding Armstrong   Regular School No Elementary KG 03 2018   grade_2 61 1 2 0   31     0   0   55 40                       95.0 61 1 2 0   31     0   0   55 40                 95
2236962 2236962 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough: Annie E Fales   Regular School No Elementary KG 03 2018   grade_2 52 1 1 0   37     0   1   48 44                       92.0 52 1 1 0   37     0   1   48 44                 92
2236968 2236968 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Westborough: Elsie A Hastings Elementary   Regular School No Elementary PK 03 2018   grade_2 46 2 6 0   31     0   4   41 48                       89.0 46 2 6 0   31     0   4   41 48                 89
2237000 2237000 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater: Rose L Macdonald   Regular School No Elementary 01 03 2018   grade_2 75 5 0 0   0     0   5   44 41                       85.0 75 5 0 0   0     0   5   44 41                 85
2237137 2237137 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Weston: Country   Regular School No Elementary PK 03 2018   grade_2 43 5 10 0   13     0   10   35 46                       81.0 43 5 10 0   13     0   10   35 46                 81
2237146 2237146 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Weston: Woodland   Regular School No Elementary PK 03 2018   grade_2 42 5 2 0   10     0   1   29 31                       60.0 42 5 2 0   10     0   1   29 31                 60
2237378 2237378 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington: Woburn Street   Regular School No Elementary 01 03 2018   grade_2 124 2 5 0   11     0   5   69 78                       147.0 124 2 5 0   11     0   5   69 78                 147
2237382 2237382 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington: Shawsheen Elementary   Regular School No Elementary 01 03 2018   grade_2 107 3 5 0   5     0   3   62 61                       123.0 107 3 5 0   5     0   3   62 61                 123
2237906 2237906 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_2 97 1 4 0   4     1   6   55 58                       113.0 97 1 4 0   4     1   6   55 58                 113
2238025 2238025 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public (District): Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2018   grade_2 27 23 17 0   3     0   5   36 39                       75.0 27 23 17 0   3     0   5   36 39                 75
2238582 2238582 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Adams-Cheshire: Hoosac Valley Elementary School   Regular School No Elementary PK 03 2018   grade_2 71 2 2 0   1     0   4   32 48                       80.0 71 2 2 0   1     0   4   32 48                 80
2238732 2238732 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham: Mitchell Elementary School   Regular School No Elementary PK 03 2018   grade_2 190 9 0 0   3     0   11   108 105                       213.0 190 9 0 0   3     0   11   108 105                 213
2238819 2238819 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_2 34 4 11 3   1     0   6   29 30                       59.0 34 4 11 3   1     0   6   29 30                 59
2238824 2238824 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   grade_2 85 7 9 0   3     0   12   59 57                       116.0 85 7 9 0   3     0   12   59 57                 116

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