Data source: Big Local News · About: Big Local

395 rows where grade = "grade_12", state = "MA" and year = 2018 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2018 · 395

grade

  • grade_12 · 395
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
2230215 MA Suffolk   school   35   Boston   350652               2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2229947 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_12 3 35 15 0   3     0   3   45 14                       59.0 3 35 15 0   3     0   3   45 14                 59
2231480 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_12 3 4 0 0   0     0   0   3 4                       7.0 3 4 0 0   0     0   0   3 4                 7
2232705 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_12 1 0 11 0   0     0   0   10 2                       12.0 1 0 11 0   0     0   0   10 2                 12
2230061 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_12 8 30 15 0   3     0   2   29 29                       58.0 8 30 15 0   3     0   2   29 29                 58
2230487 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_12 5 4 0 0   0     0   0   5 4                       9.0 5 4 0 0   0     0   0   5 4                 9
2237959 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_12 4 22 11 0   0     0   1   15 23                       38.0 4 22 11 0   0     0   1   15 23                 38
2238080 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_12 71 2 9 0   8     0   4   44 50                       94.0 71 2 9 0   8     0   4   44 50                 94
2238203 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_12 50 11 7 2   3     0   3   29 47                       76.0 50 11 7 2   3     0   3   29 47                 76
2238386 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District): Rising Tide Charter Public School   Regular School Yes High 05 12 2018   grade_12 61 1 2 0   2     0   6   35 37                       72.0 61 1 2 0   2     0   6   35 37                 72
2238492 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_12 24 3 5 1   0     0   5   18 20                       38.0 24 3 5 1   0     0   5   18 20                 38
2229504 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_12 2 24 7 1   1     0   1   23 13                       36.0 2 24 7 1   1     0   1   23 13                 36
2230178 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_12 4 11 15 0   20     0   2   26 26                       52.0 4 11 15 0   20     0   2   26 26                 52
2230239 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_12 2 101 25 0   5     1   2   67 69                       136.0 2 101 25 0   5     1   2   67 69                 136
2230847 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_12 92 1 1 1   0     0   4   40 59                       99.0 92 1 1 1   0     0   4   40 59                 99
2230967 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_12 5 2 4 0   0     0   0   8 3                       11.0 5 2 4 0   0     0   0   8 3                 11
2231065 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_12 86 5 1 1   1     0   0   57 37                       94.0 86 5 1 1   1     0   0   57 37                 94
2232173 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_12 84 1 4 0   14     0   3   56 50                       106.0 84 1 4 0   14     0   3   56 50                 106
2232223 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill: Haverhill Alternative School   Regular School No High 06 12 2018   grade_12 4 1 5 0   0     0   0   5 5                       10.0 4 1 5 0   0     0   0   5 5                 10
2232325 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_12 30 26 8 0   2     0   6   40 32                       72.0 30 26 8 0   2     0   6   40 32                 72
2232760 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_12 56 1 4 0   4     0   1   35 31                       66.0 56 1 4 0   4     0   1   35 31                 66
2233336 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_12 30 24 157 1   8     0   4   141 83                       224.0 30 24 157 1   8     0   4   141 83                 224
2234213 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford: Trinity Day Academy   Regular School No High 06 12 2018   grade_12 6 1 4 0   0     1   0   7 5                       12.0 6 1 4 0   0     1   0   7 5                 12
2234220 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford: Whaling City Junior/Senior High School   Regular School No High 06 12 2018   grade_12 5 1 3 0   0     0   2   9 2                       11.0 5 1 3 0   0     0   2   9 2                 11
2234801 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_12 79 3 6 0   1     1   3   49 44                       93.0 79 3 6 0   1     1   3   49 44                 93
2236155 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_12 32 16 33 0   1     0   3   44 41                       85.0 32 16 33 0   1     0   3   44 41                 85
2236163 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield: John J Duggan Middle   Regular School No High 06 12 2018   grade_12 2 15 23 0   0     0   0   21 19                       40.0 2 15 23 0   0     0   0   21 19                 40
2236209 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield: Conservatory of the Arts   Regular School No High 06 12 2018   grade_12 5 16 28 0   0     0   0   16 33                       49.0 5 16 28 0   0     0   0   16 33                 49
2236997 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston: West Boylston Junior/Senior High   Regular School No High 06 12 2018   grade_12 55 0 2 0   1     0   2   27 33                       60.0 55 0 2 0   1     0   2   27 33                 60
2237950 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District): Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2018   grade_12 3 39 29 1   1     0   1   43 31                       74.0 3 39 29 1   1     0   1   43 31                 74
2237974 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_12 25 2 1 0   2     1   0   11 20                       31.0 25 2 1 0   2     1   0   11 20                 31
2237982 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District): Boston Preparatory Charter Public School   Regular School Yes High 06 12 2018   grade_12 2 41 9 0   0     0   0   29 23                       52.0 2 41 9 0   0     0   0   29 23                 52
2238058 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_12 72 3 6 0   18     0   5   63 41                       104.0 72 3 6 0   18     0   5   63 41                 104
2238088 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District): Community Charter School of Cambridge   Regular School Yes High 06 12 2018   grade_12 0 34 13 1   0     0   3   27 24                       51.0 0 34 13 1   0     0   3   27 24                 51
2238402 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District): Salem Academy Charter School   Regular School Yes High 06 12 2018   grade_12 18 4 19 0   3     0   0   25 19                       44.0 18 4 19 0   3     0   0   25 19                 44
2238519 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East (District): Hampden Charter School of Science East   Regular School Yes High 06 12 2018   grade_12 14 2 10 0   3     0   1   11 19                       30.0 14 2 10 0   3     0   1   11 19                 30
2238702 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston: Tahanto Regional High   Regular School No High 06 12 2018   grade_12 71 0 0 0   3     0   4   42 36                       78.0 71 0 0 0   3     0   4   42 36                 78
2229101 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_12 15 18 3 0   2     0   1   15 23                       39.0 15 18 3 0   2     0   1   15 23                 39
2229456 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_12 2 7 4 0   1     0   0   9 5                       14.0 2 7 4 0   1     0   0   9 5                 14
2230134 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston: New Mission High School   Alternative School No High 07 12 2018   grade_12 0 58 17 0   0     0   1   47 29                       76.0 0 58 17 0   0     0   1   47 29                 76
2230145 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_12 77 82 53 1   64     1   4   118 164                       282.0 77 82 53 1   64     1   4   118 164                 282
2230170 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_12 172 52 63 0   114     1   10   183 229                       412.0 172 52 63 0   114     1   10   183 229                 412
2230185 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_12 24 101 81 0   74     0   6   133 153                       286.0 24 101 81 0   74     0   6   133 153                 286
2231324 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater: East Bridgewater JR./SR. High School   Regular School No High 07 12 2018   grade_12 152 7 3 0   0     1   2   86 79                       165.0 152 7 3 0   0     1   2   86 79                 165
2231656 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_12 23 2 11 0   2     1   1   23 17                       40.0 23 2 11 0   2     1   1   23 17                 40
2232027 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2232072 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_12 49 0 6 0   2     0   0   25 32                       57.0 49 0 6 0   2     0   0   25 32                 57
2232118 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_12 30 0 3 0   1     0   2   18 18                       36.0 30 0 3 0   1     0   2   18 18                 36
2232189 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield: Smith Academy   Regular School No High 07 12 2018   grade_12 25 2 0 0   0     0   2   15 14                       29.0 25 2 0 0   0     0   2   15 14                 29
2232460 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_12 87 1 1 0   1     0   0   45 45                       90.0 87 1 1 0   1     0   0   45 45                 90
2232726 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_12 48 0 4 0   0     0   1   26 27                       53.0 48 0 4 0   0     0   1   26 27                 53
2233328 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_12 3 2 7 0   2     0   1   8 7                       15.0 3 2 7 0   2     0   1   8 7                 15
2233852 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury: Millbury Junior/Senior High   Regular School No High 07 12 2018   grade_12 103 1 3 2   1     0   1   53 58                       111.0 103 1 3 2   1     0   1   53 58                 111
2234415 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   grade_12 60 3 4 0   0     0   4   33 38                       71.0 60 3 4 0   0     0   4   33 38                 71
2234611 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield: North Brookfield High   Regular School No High 07 12 2018   grade_12 29 1 2 0   0     0   0   14 18                       32.0 29 1 2 0   0     0   0   14 18                 32
2236783 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_12 51 3 4 0   0     0   1   30 29                       59.0 51 3 4 0   0     0   1   30 29                 59
2237015 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_12 83 3 1 1   2     1   3   33 61                       94.0 83 3 1 1   2     1   3   33 61                 94
2237173 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_12 63 1 2 0   0     0   1   38 29                       67.0 63 1 2 0   0     0   1   38 29                 67
2237847 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_12 5 4 19 0   9     0   1   25 13                       38.0 5 4 19 0   9     0   1   25 13                 38
2237854 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_12 4 10 65 0   10     0   0   42 47                       89.0 4 10 65 0   10     0   0   42 47                 89
2237966 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District): Four Rivers Charter Public School   Regular School Yes High 07 12 2018   grade_12 34 0 1 0   0     0   2   21 16                       37.0 34 0 1 0   0     0   2   21 16                 37
2238333 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2018   grade_12 24 0 1 0   1     0   1   10 17                       27.0 24 0 1 0   1     0   1   10 17                 27
2238347 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District): Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2018   grade_12 60 0 2 0   1     0   4   31 36                       67.0 60 0 2 0   1     0   4   31 36                 67
2238354 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_12 43 4 10 1   2     0   4   21 42                       64.0 43 4 10 1   2     0   4   21 42                 64
2238954 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier: Frontier Regional   Regular School No High 07 12 2018   grade_12 75 2 4 0   1     0   3   47 38                       85.0 75 2 4 0   1     0   3   47 38                 85
2239098 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire: Hampshire Regional High   Regular School No High 07 12 2018   grade_12 96 1 3 0   0     0   2   45 57                       102.0 96 1 3 0   0     0   2   45 57                 102
2239212 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock: Mt Greylock Regional High   Regular School No High 07 12 2018   grade_12 75 1 2 0   0     0   3   38 43                       81.0 75 1 2 0   0     0   3   38 43                 81
2239246 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail: Mohawk Trail Regional High   Regular School No High 07 12 2018   grade_12 57 0 5 0   1     0   1   34 30                       64.0 57 0 5 0   1     0   1   34 30                 64
2239444 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley: Pioneer Valley Regional   Regular School No High 07 12 2018   grade_12 56 0 0 0   0     0   1   30 27                       57.0 56 0 0 0   0     0   1   30 27                 57
2239496 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar: Ralph C Mahar Regional   Regular School No High 07 12 2018   grade_12 86 0 6 0   2     0   3   49 48                       97.0 86 0 6 0   2     0   3   49 48                 97
2239540 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire: Mt Everett Regional   Regular School No High 07 12 2018   grade_12 44 0 1 0   0     0   0   22 23                       45.0 44 0 1 0   0     0   0   22 23                 45
2239557 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   grade_12 116 1 3 0   1     0   3   64 60                       124.0 116 1 3 0   1     0   3   64 60                 124
2239969 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District): Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2018   grade_12 5 15 3 0   6     0   1   11 19                       30.0 5 15 3 0   6     0   1   11 19                 30
2229135 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_12 250 29 36 3   13     2   12   169 176                       345.0 250 29 36 3   13     2   12   169 176                 345
2229195 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham: Bellingham High School   Regular School No High 08 12 2018   grade_12 111 4 9 1   3     0   2   71 59                       130.0 111 4 9 1   3     0   2   71 59                 130
2229201 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_12 8 0 1 0   0     0   0   6 3                       9.0 8 0 1 0   0     0   0   6 3                 9
2231943 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_12 90 2 12 0   1     0   9   56 58                       114.0 90 2 12 0   1     0   9   56 58                 114
2232102 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield: Greenfield High   Regular School No High 08 12 2018   grade_12 61 3 16 0   3     0   2   37 48                       85.0 61 3 16 0   3     0   2   37 48                 85
2232510 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson: Hudson High   Regular School No High 08 12 2018   grade_12 157 4 13 1   4     0   3   87 95                       182.0 157 4 13 1   4     0   3   87 95                 182
2234775 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_12 8 0 2 0   0     0   0   8 *                       10.0 8 0 2 0   0     0   0   8                   10
2234785 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford: Oxford High   Regular School No High 08 12 2018   grade_12 84 2 9 2   0     0   4   52 49                       101.0 84 2 9 2   0     0   4   52 49                 101
2235510 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem: Salem Prep High School   Regular School No High 08 12 2018   grade_12 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2236522 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_12 286 67 33 0   8     0   13   196 211                       407.0 286 67 33 0   8     0   13   196 211                 407
2238594 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Adams-Cheshire: Hoosac Valley High School   Regular School No High 08 12 2018   grade_12 81 3 1 0   0     0   0   45 40                       85.0 81 3 1 0   0     0   0   45 40                 85
2238838 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_12 151 18 24 2   8     0   8   117 94                       211.0 151 18 24 2   8     0   8   117 94                 211
2239205 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   grade_12 92 9 6 1   4     0   5   61 56                       117.0 92 9 6 1   4     0   5   61 56                 117
2228771 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_12 105 2 14 0   0     0   2   59 64                       123.0 105 2 14 0   0     0   2   59 64                 123
2228820 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_12 245 5 13 0   6     1   7   155 122                       277.0 245 5 13 0   6     1   7   155 122                 277
2228844 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_12 136 1 6 0   2     0   2   86 61                       147.0 136 1 6 0   2     0   2   86 61                 147
2228849 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_12 10 0 0 0   0     0   3   9 4                       13.0 10 0 0 0   0     0   3   9 4                 13
2228928 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_12 311 9 19 0   64     0   8   197 213                       411.0 311 9 19 0   64     0   8   197 213                 411
2228988 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_12 255 13 15 0   26     1   5   158 155                       315.0 255 13 15 0   26     1   5   158 155                 315
2229007 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_12 134 3 14 1   18     0   9   91 88                       179.0 134 3 14 1   18     0   9   91 88                 179
2229059 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_12 289 23 40 2   16     2   18   199 191                       390.0 289 23 40 2   16     2   18   199 191                 390
2229062 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro: Attleboro Community Academy   Alternative School No High 09 12 2018   grade_12 27 3 4 0   1     0   2   20 17                       37.0 27 3 4 0   1     0   2   20 17                 37
2229085 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_12 147 5 13 0   5     0   4   77 97                       174.0 147 5 13 0   5     0   4   77 97                 174
2229153 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_12 147 18 15 0   27     0   10   101 114                       217.0 147 18 15 0   27     0   10   101 114                 217
2229172 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown: Belchertown High   Regular School No High 09 12 2018   grade_12 151 4 2 1   2     1   2   82 81                       163.0 151 4 2 1   2     1   2   82 81                 163
2229236 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont: Belmont High   Regular School No High 09 12 2018   grade_12 234 16 7 0   58     1   14   163 167                       330.0 234 16 7 0   58     1   14   163 167                 330
2229302 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   grade_12 284 8 25 0   13     0   9   161 177                       339.0 284 8 25 0   13     0   9   161 177                 339

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