enrollments

Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 490 ✖

grade ✖

  • grade_8 · 490 ✖
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
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1123449 1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1123655 1123655 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_8 * * * *   *     *   *   3 1                       *                         3 1                  
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1128684 1128684 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_8 * * * *   *     *   *   2 *                       *                         2                    
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1124016 1124016 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_8 54 0 0 0   9     0   5   35 33                       68 54 0 0 0   9     0   5   35 33                 68
1124215 1124215 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_8 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
1124246 1124246 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_8 126 3 0 0   5     0   0   68 66                       134 126 3 0 0   5     0   0   68 66                 134
1125083 1125083 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_8 141 3 0 0   7     0   1   77 75                       152 141 3 0 0   7     0   1   77 75                 152
1125132 1125132 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_8 112 0 0 0   1     0   1   59 55                       114 112 0 0 0   1     0   1   59 55                 114
1127104 1127104 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_8 90 2 0 0   0     0   0   42 50                       92 90 2 0 0   0     0   0   42 50                 92
1128605 1128605 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2017   grade_8 67 1 0 0   1     0   7   39 37                       76 67 1 0 0   1     0   7   39 37                 76
1131510 1131510 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2017   grade_8 61 1 0 0   1     0   1   26 37                       64 61 1 0 0   1     0   1   26 37                 64
1131759 1131759 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_8 86 8 0 0   2     0   0   55 41                       96 86 8 0 0   2     0   0   55 41                 96
1122440 1122440 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_8 93 1 1 0   1     0   3   44 55                       99 93 1 1 0   1     0   3   44 55                 99
1124028 1124028 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_8 150 0 1 0   0     1   3   79 76                       155 150 0 1 0   0     1   3   79 76                 155
1125091 1125091 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   grade_8 137 3 1 1   12     0   2   72 84                       156 137 3 1 1   12     0   2   72 84                 156
1125372 1125372 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_8 32 1 1 0   0     0   0   25 9                       34 32 1 1 0   0     0   0   25 9                 34
1125639 1125639 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_8 81 0 1 1   4     0   1   43 45                       88 81 0 1 1   4     0   1   43 45                 88
1125705 1125705 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2017   grade_8 73 2 1 0   0     0   2   38 40                       78 73 2 1 0   0     0   2   38 40                 78
1125906 1125906 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_8 57 0 1 0   1     0   0   25 34                       59 57 0 1 0   1     0   0   25 34                 59
1127786 1127786 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2017   grade_8 29 0 1 0   0     0   1   14 17                       31 29 0 1 0   0     0   1   14 17                 31
1128556 1128556 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_8 5 1 1 0   0     0   1   2 6                       8 5 1 1 0   0     0   1   2 6                 8
1130299 1130299 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_8 142 2 1 2   57     0   5   97 112                       209 142 2 1 2   57     0   5   97 112                 209
1131362 1131362 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 29 0 1 0   14     0   2   32 14                       46 29 0 1 0   14     0   2   32 14                 46
1131457 1131457 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_8 11 0 1 0   2     0   1   12 3                       15 11 0 1 0   2     0   1   12 3                 15
1131549 1131549 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_8 87 0 1 0   1     0   1   39 51                       90 87 0 1 0   1     0   1   39 51                 90
1131602 1131602 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_8 42 15 1 2   4     0   2   29 37                       66 42 15 1 2   4     0   2   29 37                 66
1132308 1132308 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2017   grade_8 125 0 1 0   4     0   1   62 69                       131 125 0 1 0   4     0   1   62 69                 131
1132472 1132472 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2017   grade_8 93 1 1 0   2     0   1   46 52                       98 93 1 1 0   2     0   1   46 52                 98
1132480 1132480 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2017   grade_8 81 0 1 0   5     0   0   57 30                       87 81 0 1 0   5     0   0   57 30                 87
1132538 1132538 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2017   grade_8 222 9 1 0   3     0   10   115 130                       245 222 9 1 0   3     0   10   115 130                 245
1132681 1132681 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2017   grade_8 289 3 1 0   4     0   1   147 151                       298 289 3 1 0   4     0   1   147 151                 298
1123192 1123192 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_8 0 15 10 0   1     0   3   16 13                       29 0 15 10 0   1     0   3   16 13                 29
1123744 1123744 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_8 44 5 10 0   8     0   8   39 36                       75 44 5 10 0   8     0   8   39 36                 75
1123956 1123956 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2017   grade_8 33 28 10 1   8     0   3   44 39                       83 33 28 10 1   8     0   3   44 39                 83
1124752 1124752 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_8 42 5 10 0   4     0   5   33 33                       66 42 5 10 0   4     0   5   33 33                 66
1125221 1125221 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2017   grade_8 174 4 10 0   19     0   7   106 108                       214 174 4 10 0   19     0   7   106 108                 214
1126058 1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
1126980 1126980 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_8 246 6 10 2   2     0   6   142 130                       272 246 6 10 2   2     0   6   142 130                 272
1128661 1128661 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_8 24 0 10 0   0     0   3   13 24                       37 24 0 10 0   0     0   3   13 24                 37
1128963 1128963 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   grade_8 39 6 10 0   0     0   0   30 25                       55 39 6 10 0   0     0   0   30 25                 55
1128995 1128995 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_8 19 4 10 0   2     0   3   20 18                       38 19 4 10 0   2     0   3   20 18                 38
1130446 1130446 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_8 221 8 10 0   19     0   2   118 142                       260 221 8 10 0   19     0   2   118 142                 260
1130565 1130565 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_8 257 6 10 0   14     0   9   142 154                       296 257 6 10 0   14     0   9   142 154                 296
1131224 1131224 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_8 101 1 10 0   32     0   5   73 76                       149 101 1 10 0   32     0   5   73 76                 149
1133190 1133190 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_8 51 6 10 0   1     0   2   28 42                       70 51 6 10 0   1     0   2   28 42                 70
1125831 1125831 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_8 1 1 100 0   1     0   0   49 54                       103 1 1 100 0   1     0   0   49 54                 103
1129398 1129398 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No Middle 06 08 2017   grade_8 15 20 100 0   2     0   1   69 69                       138 15 20 100 0   2     0   1   69 69                 138
1128531 1128531 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2017   grade_8 57 7 101 2   14     0   4   82 103                       185 57 7 101 2   14     0   4   82 103                 185
1127374 1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293
1124107 1124107 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_8 8 5 104 0   3     0   2   66 56                       122 8 5 104 0   3     0   2   66 56                 122
1127378 1127378 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_8 188 19 104 4   2     2   10   181 148                       329 188 19 104 4   2     2   10   181 148                 329
1128535 1128535 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2017   grade_8 65 5 105 2   3     0   4   84 100                       184 65 5 105 2   3     0   4   84 100                 184
1131558 1131558 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_8 2 129 108 0   0     1   1   123 118                       241 2 129 108 0   0     1   1   123 118                 241
1121958 1121958 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_8 151 6 11 0   1     0   0   91 78                       169 151 6 11 0   1     0   0   91 78                 169
1122033 1122033 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_8 142 4 11 1   2     0   10   91 79                       170 142 4 11 1   2     0   10   91 79                 170
1122732 1122732 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_8 7 7 11 0   2     0   0   17 10                       27 7 7 11 0   2     0   0   17 10                 27
1123547 1123547 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2017   grade_8 184 16 11 0   37     0   3   132 119                       251 184 16 11 0   37     0   3   132 119                 251
1123693 1123693 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_8 63 72 11 0   1     1   7   77 78                       155 63 72 11 0   1     1   7   77 78                 155
1123734 1123734 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_8 39 3 11 0   19     1   6   42 37                       79 39 3 11 0   19     1   6   42 37                 79
1123796 1123796 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_8 40 10 11 0   11     0   8   38 42                       80 40 10 11 0   11     0   8   38 42                 80
1123960 1123960 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2017   grade_8 22 29 11 0   10     2   4   31 47                       78 22 29 11 0   10     2   4   31 47                 78
1127769 1127769 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_8 172 0 11 0   2     1   5   101 90                       191 172 0 11 0   2     1   5   101 90                 191
1127958 1127958 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2017   grade_8 125 2 11 0   5     0   3   77 69                       146 125 2 11 0   5     0   3   77 69                 146
1128844 1128844 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_8 161 13 11 0   83     1   10   152 127                       279 161 13 11 0   83     1   10   152 127                 279
1129883 1129883 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_8 136 10 11 1   2     0   2   82 80                       162 136 10 11 1   2     0   2   82 80                 162
1131496 1131496 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2017   grade_8 55 3 11 0   1     0   1   36 35                       71 55 3 11 0   1     0   1   36 35                 71
1132079 1132079 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_8 167 6 11 2   4     0   3   89 104                       193 167 6 11 2   4     0   3   89 104                 193
1123268 1123268 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2017   grade_8 1 41 110 0   0     0   3   90 65                       155 1 41 110 0   0     0   3   90 65                 155
1123411 1123411 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_8 15 5 111 0   5     0   2   73 65                       138 15 5 111 0   5     0   2   73 65                 138
1125814 1125814 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_8 11 0 113 0   1     0   1   70 56                       126 11 0 113 0   1     0   1   70 56                 126
1125861 1125861 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_8 2 2 113 0   0     0   0   61 56                       117 2 2 113 0   0     0   0   61 56                 117
1127382 1127382 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_8 101 34 113 1   1     0   17   138 129                       267 101 34 113 1   1     0   17   138 129                 267
1129355 1129355 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2017   grade_8 29 43 116 1   9     0   3   103 98                       201 29 43 116 1   9     0   3   103 98                 201
1131032 1131032 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_8 73 55 116 1   11     0   12   129 139                       268 73 55 116 1   11     0   12   129 139                 268
1125809 1125809 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_8 2 2 119 0   4     0   2   62 67                       129 2 2 119 0   4     0   2   62 67                 129
1122238 1122238 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_8 136 6 12 0   5     0   4   81 82                       163 136 6 12 0   5     0   4   81 82                 163
1122423 1122423 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_8 226 10 12 1   55     0   21   159 166                       325 226 10 12 1   55     0   21   159 166                 325
1124000 1124000 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2017   grade_8 177 30 12 0   34     0   13   127 139                       266 177 30 12 0   34     0   13   127 139                 266
1124277 1124277 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_8 184 11 12 0   14     0   6   118 109                       227 184 11 12 0   14     0   6   118 109                 227
1126724 1126724 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2017   grade_8 304 0 12 1   4     0   3   155 169                       324 304 0 12 1   4     0   3   155 169                 324
1127527 1127527 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_8 96 15 12 2   27     1   10   77 86                       163 96 15 12 2   27     1   10   77 86                 163
1127718 1127718 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_8 308 9 12 0   19     0   11   189 170                       359 308 9 12 0   19     0   11   189 170                 359
1128375 1128375 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2017   grade_8 31 12 12 1   24     0   2   48 34                       82 31 12 12 1   24     0   2   48 34                 82
1129964 1129964 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2017   grade_8 81 4 12 0   0     1   4   59 43                       102 81 4 12 0   0     1   4   59 43                 102
1131253 1131253 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes Other 06 12 2017   grade_8 3 39 12 0   3     0   0   29 28                       57 3 39 12 0   3     0   0   29 28                 57
1131517 1131517 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2017   grade_8 45 6 12 0   1     0   4   23 45                       68 45 6 12 0   1     0   4   23 45                 68
1131735 1131735 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_8 257 10 12 1   139     0   23   240 202                       442 257 10 12 1   139     0   23   240 202                 442
1131841 1131841 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_8 91 6 12 2   5     0   13   62 67                       129 91 6 12 2   5     0   13   62 67                 129
1131891 1131891 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2017   grade_8 120 2 12 0   3     0   1   70 68                       138 120 2 12 0   3     0   1   70 68                 138
1124112 1124112 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_8 7 13 124 0   3     0   0   75 72                       147 7 13 124 0   3     0   0   75 72                 147
1122341 1122341 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2017   grade_8 114 6 13 0   18     0   7   81 77                       158 114 6 13 0   18     0   7   81 77                 158
1123872 1123872 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_8 10 2 13 0   0     0   2   8 19                       27 10 2 13 0   0     0   2   8 19                 27
1124589 1124589 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_8 248 17 13 0   10     0   5   135 158                       293 248 17 13 0   10     0   5   135 158                 293
1125506 1125506 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_8 57 12 13 0   5     0   2   50 39                       89 57 12 13 0   5     0   2   50 39                 89
1126549 1126549 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_8 30 12 13 0   24     1   4   43 41                       84 30 12 13 0   24     1   4   43 41                 84

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