enrollments

Data source: Big Local News · About: Big Local

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

✎ 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                    
1122874 1122874 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_8 0 0 17 0   0     0   0   5 12                       17 0 0 17 0   0     0   0   5 12                 17
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
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
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
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
1125285 1125285 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_8 66 0 15 0   2     0   7   53 37                       90 66 0 15 0   2     0   7   53 37                 90
1125301 1125301 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2017   grade_8 45 0 2 0   0     0   2   28 21                       49 45 0 2 0   0     0   2   28 21                 49
1125399 1125399 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2017   grade_8 5 0 4 0   0     0   0   7 2                       9 5 0 4 0   0     0   0   7 2                 9
1125553 1125553 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_8 10 0 33 1   0     0   0   29 15                       44 10 0 33 1   0     0   0   29 15                 44
1125564 1125564 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_8 0 0 39 0   0     0   0   19 20                       39 0 0 39 0   0     0   0   19 20                 39
1125570 1125570 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_8 5 0 65 0   0     0   0   37 33                       70 5 0 65 0   0     0   0   37 33                 70
1125580 1125580 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_8 1 0 40 0   2     0   0   17 26                       43 1 0 40 0   2     0   0   17 26                 43
1125591 1125591 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_8 8 0 35 0   0     0   2   21 24                       45 8 0 35 0   0     0   2   21 24                 45
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
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
1125853 1125853 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_8 4 0 87 0   4     0   1   52 44                       96 4 0 87 0   4     0   1   52 44                 96
1125857 1125857 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2017   grade_8 8 0 147 0   5     0   0   75 85                       160 8 0 147 0   5     0   0   75 85                 160
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
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
1125940 1125940 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_8 54 0 5 0   7     0   3   37 32                       69 54 0 5 0   7     0   3   37 32                 69
1126103 1126103 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_8 104 0 3 1   11     0   3   49 73                       122 104 0 3 1   11     0   3   49 73                 122
1126504 1126504 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_8 11 0 6 0   0     0   0   10 7                       17 11 0 6 0   0     0   0   10 7                 17
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
1126923 1126923 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_8 103 0 29 0   3     0   6   69 72                       141 103 0 29 0   3     0   6   69 72                 141
1126934 1126934 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_8 83 0 48 0   7     0   5   72 71                       143 83 0 48 0   7     0   5   72 71                 143
1126945 1126945 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_8 61 0 56 0   11     0   7   70 65                       135 61 0 56 0   11     0   7   70 65                 135
1126956 1126956 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_8 72 0 67 1   3     0   8   83 68                       151 72 0 67 1   3     0   8   83 68                 151
1127411 1127411 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_8 180 0 2 0   5     0   4   97 94                       191 180 0 2 0   5     0   4   97 94                 191
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
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
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
1128813 1128813 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2017   grade_8 161 0 9 0   4     0   2   88 87                       176 161 0 9 0   4     0   2   88 87                 176
1129043 1129043 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2017   grade_8 123 0 9 0   24     0   4   85 75                       160 123 0 9 0   24     0   4   85 75                 160
1130584 1130584 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_8 92 0 8 1   2     0   5   51 57                       108 92 0 8 1   2     0   5   51 57                 108
1131135 1131135 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_8 27 0 7 0   2     0   1   18 19                       37 27 0 7 0   2     0   1   18 19                 37
1131240 1131240 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_8 70 0 5 0   1     0   4   32 48                       80 70 0 5 0   1     0   4   32 48                 80
1131299 1131299 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_8 2 0 44 0   0     0   0   24 22                       46 2 0 44 0   0     0   0   24 22                 46
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
1131381 1131381 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 27 0 2 0   0     0   0   16 13                       29 27 0 2 0   0     0   0   16 13                 29
1131407 1131407 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 0 54 0   0     0   0   26 29                       55 1 0 54 0   0     0   0   26 29                 55
1131447 1131447 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_8 37 0 2 0   1     0   0   19 21                       40 37 0 2 0   1     0   0   19 21                 40
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
1131544 1131544 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_8 26 0 2 0   4     0   0   16 16                       32 26 0 2 0   4     0   0   16 16                 32
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
1131791 1131791 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2017   grade_8 191 0 8 0   3     0   2   101 103                       204 191 0 8 0   3     0   2   101 103                 204
1131816 1131816 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_8 99 0 9 0   0     0   4   60 52                       112 99 0 9 0   0     0   4   60 52                 112
1132143 1132143 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2017   grade_8 73 0 5 0   1     0   1   42 38                       80 73 0 5 0   1     0   1   42 38                 80
1132193 1132193 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2017   grade_8 68 0 8 0   0     0   3   30 49                       79 68 0 8 0   0     0   3   30 49                 79
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
1132417 1132417 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2017   grade_8 88 0 2 1   0     0   1   44 48                       92 88 0 2 1   0     0   1   44 48                 92
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
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
1122569 1122569 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_8 11 1 3 0   1     0   1   10 7                       17 11 1 3 0   1     0   1   10 7                 17
1123440 1123440 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_8 0 1 24 0   0     0   0   12 13                       25 0 1 24 0   0     0   0   12 13                 25
1124148 1124148 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_8 4 1 8 0   0     0   0   9 4                       13 4 1 8 0   0     0   0   9 4                 13
1124485 1124485 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_8 245 1 9 0   5     0   5   137 128                       265 245 1 9 0   5     0   5   137 128                 265
1124605 1124605 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_8 34 1 4 1   0     0   0   15 25                       40 34 1 4 1   0     0   0   15 25                 40
1124706 1124706 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2017   grade_8 137 1 6 2   5     0   1   84 68                       152 137 1 6 2   5     0   1   84 68                 152
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1125239 1125239 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2017   grade_8 51 1 6 0   3     0   0   39 22                       61 51 1 6 0   3     0   0   39 22                 61
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
1125532 1125532 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_8 193 1 6 2   17     0   5   115 109                       224 193 1 6 2   17     0   5   115 109                 224
1125601 1125601 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_8 5 1 47 0   2     0   1   29 27                       56 5 1 47 0   2     0   1   29 27                 56
1125730 1125730 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2017   grade_8 146 1 5 0   4     0   4   81 79                       160 146 1 5 0   4     0   4   81 79                 160
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1125788 1125788 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_8 2 1 143 0   0     0   0   73 73                       146 2 1 143 0   0     0   0   73 73                 146
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
1126138 1126138 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_8 97 1 5 1   8     0   4   60 56                       116 97 1 5 1   8     0   4   60 56                 116
1126340 1126340 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_8 116 1 5 1   0     0   0   71 52                       123 116 1 5 1   0     0   0   71 52                 123
1126534 1126534 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_8 170 1 7 0   7     0   5   89 101                       190 170 1 7 0   7     0   5   89 101                 190
1127047 1127047 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_8 99 1 2 0   6     1   3   70 42                       112 99 1 2 0   6     1   3   70 42                 112
1128280 1128280 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_8 9 1 4 0   0     0   3   11 6                       17 9 1 4 0   0     0   3   11 6                 17
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
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
1128644 1128644 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No Elementary KG 08 2017   grade_8 5 1 31 0   0     0   0   19 18                       37 5 1 31 0   0     0   0   19 18                 37
1129638 1129638 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2017   grade_8 155 1 3 0   3     0   6   88 80                       168 155 1 3 0   3     0   6   88 80                 168
1129747 1129747 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_8 24 1 7 1   1     0   2   17 19                       36 24 1 7 1   1     0   2   17 19                 36
1130303 1130303 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_8 188 1 6 0   50     0   9   129 125                       254 188 1 6 0   50     0   9   129 125                 254
1130354 1130354 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_8 126 1 3 2   2     0   4   79 59                       138 126 1 3 2   2     0   4   79 59                 138
1130652 1130652 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_8 145 1 20 0   1     0   1   80 88                       168 145 1 20 0   1     0   1   80 88                 168
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
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
1131867 1131867 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No Other 06 12 2017   grade_8 76 1 2 0   4     0   4   45 42                       87 76 1 2 0   4     0   4   45 42                 87
1131968 1131968 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_8 136 1 6 1   2     0   5   79 72                       151 136 1 6 1   2     0   5   79 72                 151
1132024 1132024 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_8 111 1 5 0   0     0   2   66 53                       119 111 1 5 0   0     0   2   66 53                 119
1132070 1132070 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_8 178 1 19 0   1     0   6   105 100                       205 178 1 19 0   1     0   6   105 100                 205
1132111 1132111 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2017   grade_8 249 1 2 0   3     0   3   131 127                       258 249 1 2 0   3     0   3   131 127                 258
1132119 1132119 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_8 113 1 5 0   6     0   2   68 59                       127 113 1 5 0   6     0   2   68 59                 127
1132263 1132263 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2017   grade_8 128 1 5 1   2     0   1   60 78                       138 128 1 5 1   2     0   1   60 78                 138
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
1132518 1132518 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_8 106 1 5 0   1     1   7   59 62                       121 106 1 5 0   1     1   7   59 62                 121
1132529 1132529 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_8 135 1 3 1   2     0   7   77 72                       149 135 1 3 1   2     0   7   77 72                 149
1132656 1132656 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_8 198 1 7 0   1     0   9   103 113                       216 198 1 7 0   1     0   9   103 113                 216

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