enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_7", state = "MA" and year = 2018 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_7 · 495 ✖
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
2230210 2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2230483 2230483 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230962 2230962 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231476 2231476 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_7 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2231644 2231644 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2232022 2232022 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_7 * * * *   *     *   *   * *                       1.0                                             1
2233069 2233069 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_7 * * * *   *     *   *   4 *                       5.0                         4                   5
2233332 2233332 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2237228 2237228 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2229247 2229247 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_7 92 0 0 0   0     0   5   47 50                       97.0 92 0 0 0   0     0   5   47 50                 97
2231029 2231029 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_7 16 0 0 0   0     0   0   7 9                       16.0 16 0 0 0   0     0   0   7 9                 16
2232521 2232521 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull: Memorial Middle   Regular School No Middle 06 08 2018   grade_7 65 0 0 0   0     0   0   40 25                       65.0 65 0 0 0   0     0   0   40 25                 65
2235376 2235376 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_7 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2237117 2237117 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford: Stony Brook School   Regular School No Middle 06 08 2018   grade_7 174 0 0 0   73     0   4   145 106                       251.0 174 0 0 0   73     0   4   145 106                 251
2238751 2238751 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham: Bridgewater Middle School   Regular School No Middle 07 08 2018   grade_7 232 9 0 1   4     0   9   133 122                       255.0 232 9 0 1   4     0   9   133 122                 255
2239138 2239138 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional: Manchester Essex Regional Middle School   Regular School No Middle 06 08 2018   grade_7 121 0 0 0   2     0   2   72 53                       125.0 121 0 0 0   2     0   2   72 53                 125
2239241 2239241 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail: Mohawk Trail Regional High   Regular School No High 07 12 2018   grade_7 54 0 0 0   0     0   0   20 34                       54.0 54 0 0 0   0     0   0   20 34                 54
2228782 2228782 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_7 116 1 1 0   0     0   1   58 61                       119.0 116 1 1 0   0     0   1   58 61                 119
2229797 2229797 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_7 9 2 1 0   0     0   0   5 7                       12.0 9 2 1 0   0     0   0   5 7                 12
2230830 2230830 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_7 52 1 1 0   15     0   4   35 38                       73.0 52 1 1 0   15     0   4   35 38                 73
2231060 2231060 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_7 124 3 1 0   4     0   1   65 68                       133.0 124 3 1 0   4     0   1   65 68                 133
2231960 2231960 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_7 107 2 1 0   1     0   1   62 50                       112.0 107 2 1 0   1     0   1   62 50                 112
2232918 2232918 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton: Littleton Middle School   Regular School No Middle 06 08 2018   grade_7 103 0 1 1   8     0   6   57 62                       119.0 103 0 1 1   8     0   6   57 62                 119
2233920 2233920 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_7 48 0 1 1   0     0   0   21 29                       50.0 48 0 1 1   0     0   0   21 29                 50
2234684 2234684 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell: Norwell Middle School   Regular School No Middle 06 08 2018   grade_7 170 0 1 0   4     0   2   81 96                       177.0 170 0 1 0   4     0   2   81 96                 177
2234905 2234905 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke: Pembroke Community Middle School   Regular School No Middle 07 08 2018   grade_7 238 3 1 0   3     0   0   131 114                       245.0 238 3 1 0   3     0   0   131 114                 245
2235522 2235522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_7 221 1 1 4   6     0   1   120 114                       234.0 221 1 1 4   6     0   1   120 114                 234
2237113 2237113 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_7 133 2 1 0   56     0   1   103 90                       193.0 133 2 1 0   56     0   1   103 90                 193
2238212 2238212 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_7 26 0 1 0   0     0   3   17 13                       30.0 26 0 1 0   0     0   3   17 13                 30
2238279 2238279 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_7 35 2 1 1   2     0   0   30 11                       41.0 35 2 1 1   2     0   0   30 11                 41
2238376 2238376 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_7 27 1 1 0   0     0   2   11 20                       31.0 27 1 1 0   0     0   2   11 20                 31
2238501 2238501 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District): Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2018   grade_7 32 3 1 0   6     0   8   22 28                       50.0 32 3 1 0   6     0   8   22 28                 50
2238588 2238588 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_7 86 4 1 0   0     0   1   46 46                       92.0 86 4 1 0   0     0   1   46 46                 92
2239342 2239342 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_7 105 0 1 0   0     0   2   46 62                       108.0 105 0 1 0   0     0   2   46 62                 108
2239439 2239439 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley: Pioneer Valley Regional   Regular School No High 07 12 2018   grade_7 68 0 1 0   1     0   4   39 35                       74.0 68 0 1 0   1     0   4   39 35                 74
2239647 2239647 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_7 45 2 1 1   2     0   2   24 29                       53.0 45 2 1 1   2     0   2   24 29                 53
2229043 2229043 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_7 109 2 10 0   5     0   11   69 68                       137.0 109 2 10 0   5     0   11   69 68                 137
2229230 2229230 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_7 231 15 10 0   67     1   19   162 181                       343.0 231 15 10 0   67     1   19   162 181                 343
2229995 2229995 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_7 1 17 10 0   0     0   0   15 13                       28.0 1 17 10 0   0     0   0   15 13                 28
2230364 2230364 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree: East Middle School   Regular School No Middle 06 08 2018   grade_7 170 24 10 2   31     0   5   121 120                       242.0 170 24 10 2   31     0   5   121 120                 242
2230368 2230368 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_7 173 6 10 1   37     0   3   114 116                       230.0 173 6 10 1   37     0   3   114 116                 230
2230557 2230557 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_7 43 7 10 0   7     0   11   41 37                       78.0 43 7 10 0   7     0   11   41 37                 78
2231405 2231405 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_7 264 18 10 0   10     0   3   157 148                       305.0 264 18 10 0   10     0   3   157 148                 305
2231523 2231523 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven: Hastings Middle   Regular School No Middle 06 08 2018   grade_7 145 3 10 1   4     0   5   83 85                       168.0 145 3 10 1   4     0   5   83 85                 168
2232738 2232738 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester: Leicester Middle   Regular School No Middle 06 08 2018   grade_7 93 4 10 0   2     0   7   54 62                       116.0 93 4 10 0   2     0   7   54 62                 116
2233369 2233369 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_7 23 11 10 0   41     0   2   40 47                       87.0 23 11 10 0   41     0   2   40 47                 87
2234589 2234589 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge: Northbridge Middle   Regular School No Middle 05 08 2018   grade_7 164 1 10 0   0     0   10   103 82                       185.0 164 1 10 0   0     0   10   103 82                 185
2235814 2235814 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville: West Somerville Neighborhood   Regular School No Elementary PK 08 2018   grade_7 16 4 10 0   3     0   2   18 17                       35.0 16 4 10 0   3     0   2   18 17                 35
2236795 2236795 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham: Wareham Middle   Regular School No Middle 05 08 2018   grade_7 139 15 10 2   0     0   14   92 88                       180.0 139 15 10 2   0     0   14   92 88                 180
2237273 2237273 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood: E W Thurston Middle   Regular School No Middle 06 08 2018   grade_7 208 13 10 0   19     0   11   124 137                       261.0 208 13 10 0   19     0   11   124 137                 261
2237547 2237547 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 112 10 10 3   10     0   2   68 79                       147.0 112 10 10 3   10     0   2   68 79                 147
2237551 2237551 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn: Daniel L Joyce Middle School   Regular School No Middle 06 08 2018   grade_7 128 8 10 1   7     0   5   83 76                       159.0 128 8 10 1   7     0   5   83 76                 159
2238688 2238688 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 10 0   4     0   3   51 50                       101.0 83 1 10 0   4     0   3   51 50                 101
2238900 2238900 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg: Charlton Middle School   Regular School No Middle 05 08 2018   grade_7 166 0 10 0   2     1   2   87 94                       181.0 166 0 10 0   2     1   2   87 94                 181
2239114 2239114 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip: King Philip Middle School   Regular School No Middle 07 08 2018   grade_7 314 8 10 0   4     0   10   177 169                       346.0 314 8 10 0   4     0   10   177 169                 346
2239775 2239775 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_7 162 9 10 3   3     1   7   112 83                       195.0 162 9 10 3   3     1   7   112 83                 195
2239999 2239999 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
2232265 2232265 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_7 97 6 101 0   5     1   3   95 118                       213.0 97 6 101 0   5     1   3   95 118                 213
2235351 2235351 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere: Garfield Middle School   Regular School No Middle 06 08 2018   grade_7 59 6 101 0   13     0   2   93 88                       181.0 59 6 101 0   13     0   2   93 88                 181
2236197 2236197 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield: Impact Prep at Chestnut   Regular School No Middle 06 07 2018   grade_7 4 15 101 0   0     0   0   54 66                       120.0 4 15 101 0   0     0   0   54 66                 120
2235880 2235880 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge: Southbridge Middle School   Regular School No Middle 06 08 2018   grade_7 53 3 105 0   4     0   2   87 80                       167.0 53 3 105 0   4     0   2   87 80                 167
2236170 2236170 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_7 12 33 106 1   2     0   3   90 67                       157.0 12 33 106 1   2     0   3   90 67                 157
2231005 2231005 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_7 139 9 108 0   2     0   10   144 124                       268.0 139 9 108 0   2     0   10   144 124                 268
2235355 2235355 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere: Susan B. Anthony Middle School   Regular School No Middle 06 08 2018   grade_7 59 11 109 1   10     0   5   85 110                       195.0 59 11 109 1   10     0   5   85 110                 195
2228922 2228922 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_7 73 2 11 0   35     0   4   50 75                       125.0 73 2 11 0   35     0   4   50 75                 125
2230003 2230003 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_7 0 12 11 0   0     0   2   13 12                       25.0 0 12 11 0   0     0   2   13 12                 25
2230609 2230609 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_7 49 5 11 0   13     0   6   34 50                       84.0 49 5 11 0   13     0   6   34 50                 84
2232873 2232873 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington: Jonas Clarke Middle   Regular School No Middle 06 08 2018   grade_7 136 13 11 0   139     0   10   171 138                       309.0 136 13 11 0   139     0   10   171 138                 309
2233459 2233459 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_7 208 11 11 0   4     0   2   115 121                       236.0 208 11 11 0   4     0   2   115 121                 236
2233589 2233589 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_7 70 2 11 0   2     0   5   48 42                       90.0 70 2 11 0   2     0   5   48 42                 90
2236377 2236377 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury: Ephraim Curtis Middle   Regular School No Middle 06 08 2018   grade_7 238 8 11 0   27     0   19   142 161                       303.0 238 8 11 0   27     0   19   142 161                 303
2237392 2237392 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_7 220 5 11 0   10     0   10   131 125                       256.0 220 5 11 0   10     0   10   131 125                 256
2238118 2238118 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_7 2 19 11 0   0     0   1   15 18                       33.0 2 19 11 0   0     0   1   15 18                 33
2238454 2238454 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_7 85 7 11 0   3     0   3   56 53                       109.0 85 7 11 0   3     0   3   56 53                 109
2239085 2239085 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_7 170 3 11 2   7     0   2   102 93                       195.0 170 3 11 2   7     0   2   102 93                 195
2239708 2239708 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett: Mountview Middle   Regular School No Middle 06 08 2018   grade_7 224 7 11 0   12     0   4   133 125                       258.0 224 7 11 0   12     0   4   133 125                 258
2234192 2234192 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_7 121 38 111 1   2     1   12   140 146                       286.0 121 38 111 1   2     1   12   140 146                 286
2232687 2232687 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_7 7 1 112 0   3     0   1   72 52                       124.0 7 1 112 0   3     0   1   72 52                 124
2232647 2232647 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_7 3 1 115 0   0     0   0   61 58                       119.0 3 1 115 0   0     0   0   61 58                 119
2228765 2228765 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_7 155 7 12 0   2     0   2   85 93                       178.0 155 7 12 0   2     0   2   85 93                 178
2228838 2228838 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_7 144 1 12 0   1     0   9   86 81                       167.0 144 1 12 0   1     0   9   86 81                 167
2229146 2229146 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_7 129 11 12 0   30     0   7   94 95                       189.0 129 11 12 0   30     0   7   94 95                 189
2229544 2229544 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_7 11 2 12 0   2     0   2   16 13                       29.0 11 2 12 0   2     0   2   16 13                 29
2229942 2229942 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_7 3 15 12 1   0     0   0   25 6                       31.0 3 15 12 1   0     0   0   25 6                 31
2230439 2230439 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_7 14 63 12 0   0     1   10   42 58                       100.0 14 63 12 0   0     1   10   42 58                 100
2231174 2231174 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_7 268 6 12 0   0     0   19   178 127                       305.0 268 6 12 0   0     0   19   178 127                 305
2231355 2231355 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_7 86 2 12 0   3     0   2   60 45                       105.0 86 2 12 0   3     0   2   60 45                 105
2233162 2233162 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_7 107 2 12 0   2     0   2   74 51                       125.0 107 2 12 0   2     0   2   74 51                 125
2233649 2233649 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford: Madeleine Dugger Andrews   Regular School No Middle 06 08 2018   grade_7 127 13 12 0   6     0   7   90 75                       165.0 127 13 12 0   6     0   7   90 75                 165
2233796 2233796 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_7 215 6 12 4   6     0   10   114 139                       253.0 215 6 12 4   6     0   10   114 139                 253
2233863 2233863 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_7 89 1 12 0   0     0   3   53 52                       105.0 89 1 12 0   0     0   3   53 52                 105
2233902 2233902 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton: Charles S Pierce Middle   Regular School No Middle 06 08 2018   grade_7 215 55 12 0   16     0   7   133 172                       305.0 215 55 12 0   16     0   7   133 172                 305
2234360 2234360 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton: Oak Hill Middle   Regular School No Middle 06 08 2018   grade_7 143 8 12 0   53     0   17   108 125                       233.0 143 8 12 0   53     0   17   108 125                 233
2235195 2235195 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy: Reay E Sterling Middle   Regular School No Middle 05 08 2018   grade_7 40 12 12 0   18     0   3   42 43                       85.0 40 12 12 0   18     0   3   42 43                 85
2236283 2236283 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham: Stoneham Central Middle School   Regular School No Middle 05 08 2018   grade_7 141 2 12 1   7     1   7   90 81                       171.0 141 2 12 1   7     1   7   90 81                 171
2238053 2238053 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_7 109 4 12 0   18     0   15   87 71                       158.0 109 4 12 0   18     0   15   87 71                 158
2238349 2238349 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2018   grade_7 48 5 12 0   1     0   2   18 50                       68.0 48 5 12 0   1     0   2   18 50                 68
2239576 2239576 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_7 100 1 12 0   2     0   1   67 49                       116.0 100 1 12 0   2     0   1   67 49                 116
2230921 2230921 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea: Clark Avenue School   Regular School No Middle 05 08 2018   grade_7 5 7 121 1   1     0   1   78 58                       136.0 5 7 121 1   1     0   1   78 58                 136
2237938 2237938 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_7 26 13 122 5   3     2   0   80 91                       171.0 26 13 122 5   3     2   0   80 91                 171

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