Data source: Big Local News · About: Big Local

489 rows where grade = "grade_8", state = "MA" and year = 2015 sorted by total

View and edit SQL

year

  • 2015 · 489

grade

  • grade_8 · 489
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
741044 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_8 5 2 1 0   1     0   1   4 6                       10 5 2 1 0   1     0   1   4 6                 10
741277 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_8 8 0 0 0   2     0   0   5 5                       10 8 0 0 0   2     0   0   5 5                 10
738732 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_8 8 4 85 0   2     0   1   52 48                       100 8 4 85 0   2     0   1   52 48                 100
743524 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_8 86 5 2 0   3     0   4   47 53                       100 86 5 2 0   3     0   4   47 53                 100
743874 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_8 86 3 5 0   3     0   3   44 56                       100 86 3 5 0   3     0   3   44 56                 100
738949 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_8 2 0 97 1   0     0   1   54 47                       101 2 0 97 1   0     0   1   54 47                 101
739985 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_8 95 2 2 1   1     0   0   42 59                       101 95 2 2 1   1     0   0   42 59                 101
741950 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_8 31 27 34 0   2     0   7   52 49                       101 31 27 34 0   2     0   7   52 49                 101
743419 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_8 15 9 71 0   6     0   1   52 50                       102 15 9 71 0   6     0   1   52 50                 102
738549 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_8 83 4 3 0   12     0   1   56 47                       103 83 4 3 0   12     0   1   56 47                 103
744076 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_8 94 3 3 0   0     0   4   52 52                       104 94 3 3 0   0     0   4   52 52                 104
741979 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2015   grade_8 3 14 86 0   1     0   1   60 45                       105 3 14 86 0   1     0   1   60 45                 105
744600 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_8 94 1 3 0   3     0   4   37 68                       105 94 1 3 0   3     0   4   37 68                 105
736742 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_8 1 76 25 1   2     0   1   68 38                       106 1 76 25 1   2     0   1   68 38                 106
737127 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_8 16 74 8 1   1     0   6   51 55                       106 16 74 8 1   1     0   6   51 55                 106
737973 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_8 47 18 37 0   0     0   4   62 44                       106 47 18 37 0   0     0   4   62 44                 106
741985 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2015   grade_8 6 10 89 0   1     0   0   54 52                       106 6 10 89 0   1     0   0   54 52                 106
744295 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2015   grade_8 97 1 4 0   1     0   3   59 47                       106 97 1 4 0   1     0   3   59 47                 106
744516 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_8 97 2 1 0   2     0   4   59 47                       106 97 2 1 0   2     0   4   59 47                 106
739752 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_8 79 3 12 0   4     0   9   55 52                       107 79 3 12 0   4     0   9   55 52                 107
743623 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_8 59 27 5 0   13     0   3   51 56                       107 59 27 5 0   13     0   3   51 56                 107
740056 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2015   grade_8 71 12 19 0   1     0   5   56 52                       108 71 12 19 0   1     0   5   56 52                 108
743754 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_8 60 17 6 0   23     0   2   54 54                       108 60 17 6 0   23     0   2   54 54                 108
743610 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_8 30 42 25 0   7     1   4   68 41                       109 30 42 25 0   7     1   4   68 41                 109
738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
737098 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_8 20 73 12 0   2     0   3   55 55                       110 20 73 12 0   2     0   3   55 55                 110
738182 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_8 31 11 53 0   7     0   10   50 62                       112 31 11 53 0   7     0   10   50 62                 112
738382 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_8 110 0 0 0   1     0   1   56 56                       112 110 0 0 0   1     0   1   56 56                 112
739196 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2015   grade_8 104 1 1 0   1     1   4   48 64                       112 104 1 1 0   1     1   4   48 64                 112
744969 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_8 105 0 4 0   4     0   0   57 56                       113 105 0 4 0   4     0   0   57 56                 113
736232 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   grade_8 1 31 78 1   1     0   2   62 52                       114 1 31 78 1   1     0   2   62 52                 114
738974 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_8 3 1 110 0   0     0   0   70 44                       114 3 1 110 0   0     0   0   70 44                 114
735682 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_8 114 0 0 0   1     0   0   55 60                       115 114 0 0 0   1     0   0   55 60                 115
738596 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_8 70 3 42 0   0     0   0   60 55                       115 70 3 42 0   0     0   0   60 55                 115
739605 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2015   grade_8 28 22 30 0   30     0   5   59 56                       115 28 22 30 0   30     0   5   59 56                 115
741116 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2015   grade_8 78 6 8 0   19     0   4   63 52                       115 78 6 8 0   19     0   4   63 52                 115
743986 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_8 103 3 4 2   3     0   0   57 58                       115 103 3 4 2   3     0   0   57 58                 115
736716 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_8 21 25 55 1   11     0   3   62 54                       116 21 25 55 1   11     0   3   62 54                 116
742665 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_8 107 3 2 0   1     0   3   51 65                       116 107 3 2 0   1     0   3   51 65                 116
738621 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_8 88 5 19 0   3     0   2   74 43                       117 88 5 19 0   3     0   2   74 43                 117
738978 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2015   grade_8 9 2 101 0   5     0   1   54 64                       118 9 2 101 0   5     0   1   54 64                 118
739970 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_8 99 1 13 0   1     0   4   60 58                       118 99 1 13 0   1     0   4   60 58                 118
744826 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_8 106 5 5 0   1     0   1   57 61                       118 106 5 5 0   1     0   1   57 61                 118
744415 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2015   grade_8 114 0 3 0   0     0   2   63 56                       119 114 0 3 0   0     0   2   63 56                 119
737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
741677 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_8 5 2 3 0   2     0   0   8 *                       12 5 2 3 0   2     0   0   8                   12
743559 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_8 1 8 2 0   1     0   0   5 7                       12 1 8 2 0   1     0   0   5 7                 12
738485 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_8 89 2 22 1   3     0   3   68 52                       120 89 2 22 1   3     0   3   68 52                 120
744456 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2015   grade_8 118 0 0 0   0     0   2   55 65                       120 118 0 0 0   0     0   2   55 65                 120
743465 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_8 83 9 14 2   10     0   3   55 66                       121 83 9 14 2   10     0   3   55 66                 121
737451 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_8 119 2 0 0   0     0   1   67 55                       122 119 2 0 0   0     0   1   67 55                 122
742981 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2015   grade_8 102 3 10 0   3     0   4   58 64                       122 102 3 10 0   3     0   4   58 64                 122
740781 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2015   grade_8 108 2 6 0   5     0   2   56 67                       123 108 2 6 0   5     0   2   56 67                 123
738006 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_8 27 17 79 0   1     0   0   52 72                       124 27 17 79 0   1     0   0   52 72                 124
744648 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2015   grade_8 113 2 4 0   0     0   6   58 67                       125 113 2 4 0   0     0   6   58 67                 125
738931 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_8 2 2 118 0   4     0   0   53 73                       126 2 2 118 0   4     0   0   53 73                 126
739389 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_8 109 2 5 2   8     1   0   65 62                       127 109 2 5 2   8     1   0   65 62                 127
744992 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2015   grade_8 120 4 5 0   0     0   0   70 59                       129 120 4 5 0   0     0   0   70 59                 129
736442 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_8 0 0 12 0   0     0   1   7 6                       13 0 0 12 0   0     0   1   7 6                 13
738120 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_8 9 0 2 0   0     1   1   10 *                       13 9 0 2 0   0     1   1   10                   13
738914 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_8 3 2 125 0   0     0   0   63 67                       130 3 2 125 0   0     0   0   63 67                 130
737511 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_8 18 13 97 0   3     0   1   58 74                       132 18 13 97 0   3     0   1   58 74                 132
737783 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_8 131 0 1 0   0     0   0   70 62                       132 131 0 1 0   0     0   0   70 62                 132
737634 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_8 126 4 1 0   2     0   0   61 72                       133 126 4 1 0   2     0   0   61 72                 133
738027 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_8 125 0 5 0   1     0   2   73 60                       133 125 0 5 0   1     0   2   73 60                 133
739049 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_8 118 5 7 0   2     1   0   68 65                       133 118 5 7 0   2     1   0   68 65                 133
744572 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_8 130 2 0 0   1     0   2   69 66                       135 130 2 0 0   1     0   2   69 66                 135
744848 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_8 118 1 9 0   1     0   6   74 61                       135 118 1 9 0   1     0   6   74 61                 135
736787 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_8 6 62 60 0   3     0   5   71 65                       136 6 62 60 0   3     0   5   71 65                 136
737618 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_8 97 4 31 0   4     0   0   61 75                       136 97 4 31 0   4     0   0   61 75                 136
737885 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2015   grade_8 112 2 17 0   3     0   2   73 63                       136 112 2 17 0   3     0   2   73 63                 136
735800 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_8 98 2 7 0   28     0   2   76 61                       137 98 2 7 0   28     0   2   76 61                 137
738591 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_8 109 9 17 0   2     1   0   64 74                       138 109 9 17 0   2     1   0   64 74                 138
735907 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_8 102 8 21 1   3     0   4   72 67                       139 102 8 21 1   3     0   4   72 67                 139
739528 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_8 4 1 5 1   1     0   2   9 5                       14 4 1 5 1   1     0   2   9 5                 14
736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
739225 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2015   grade_8 121 4 7 0   6     0   2   68 72                       140 121 4 7 0   6     0   2   68 72                 140
742794 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_8 128 1 3 0   4     0   4   66 74                       140 128 1 3 0   4     0   4   66 74                 140
737515 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_8 9 4 126 0   1     0   1   75 66                       141 9 4 126 0   1     0   1   75 66                 141
739726 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_8 111 6 5 10   3     0   6   76 65                       141 111 6 5 10   3     0   6   76 65                 141
736889 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_8 19 48 49 1   26     0   0   69 74                       143 19 48 49 1   26     0   0   69 74                 143
739334 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2015   grade_8 54 7 39 0   38     0   5   83 60                       143 54 7 39 0   38     0   5   83 60                 143
739879 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_8 99 5 35 0   3     0   1   71 72                       143 99 5 35 0   3     0   1   71 72                 143
739889 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2015   grade_8 90 0 45 0   5     0   3   93 50                       143 90 0 45 0   5     0   3   93 50                 143
740090 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2015   grade_8 126 0 4 0   11     0   2   67 76                       143 126 0 4 0   11     0   2   67 76                 143
744639 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2015   grade_8 132 1 5 0   1     0   4   65 78                       143 132 1 5 0   1     0   4   65 78                 143
744764 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_8 118 3 13 2   1     0   6   73 70                       143 118 3 13 2   1     0   6   73 70                 143
743508 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_8 99 4 2 2   26     0   12   62 83                       145 99 4 2 2   26     0   12   62 83                 145
735903 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_8 102 8 27 0   2     1   6   82 64                       146 102 8 27 0   2     1   6   82 64                 146
738345 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_8 127 1 3 1   9     1   4   78 68                       146 127 1 3 1   9     1   4   78 68                 146
742312 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2015   grade_8 125 1 7 0   6     1   6   76 70                       146 125 1 7 0   6     1   6   76 70                 146
736921 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_8 28 13 102 1   4     0   0   81 67                       148 28 13 102 1   4     0   0   81 67                 148
738866 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No 2 06 08 2015   grade_8 131 1 5 0   5     0   6   77 71                       148 131 1 5 0   5     0   6   77 71                 148
741733 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_8 126 2 6 0   6     0   8   76 72                       148 126 2 6 0   6     0   8   76 72                 148
744062 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2015   grade_8 119 6 14 0   3     0   6   74 74                       148 119 6 14 0   3     0   6   74 74                 148
735667 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_8 131 6 7 0   4     1   0   74 75                       149 131 6 7 0   4     1   0   74 75                 149
735899 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_8 121 5 10 0   7     0   7   80 70                       150 121 5 10 0   7     0   7   80 70                 150
737148 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_8 22 101 17 0   1     1   8   71 79                       150 22 101 17 0   1     1   8   71 79                 150
738342 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_8 134 0 6 0   6     2   2   73 77                       150 134 0 6 0   6     2   2   73 77                 150
738935 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_8 9 2 136 0   1     0   3   76 75                       151 9 2 136 0   1     0   3   76 75                 151

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