Data source: Big Local News · About: Big Local

386 rows where grade = "grade_9", state = "MA" and year = 2015 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2015 · 386

grade

  • grade_9 · 386
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
737986 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_9 2 1 4 0   0     0   0   5 2                       7 2 1 4 0   0     0   0   5 2                 7
739017 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_9 0 1 19 0   0     0   0   18 2                       20 0 1 19 0   0     0   0   18 2                 20
738606 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
736779 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_9 7 49 11 0   2     0   2   43 28                       71 7 49 11 0   2     0   2   43 28                 71
743430 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_9 6 33 12 0   0     0   1   22 30                       52 6 33 12 0   0     0   1   22 30                 52
743502 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_9 10 28 69 0   2     0   3   61 51                       112 10 28 69 0   2     0   3   61 51                 112
743525 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_9 83 4 8 0   9     0   7   51 60                       111 83 4 8 0   9     0   7   51 60                 111
743641 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_9 54 13 9 2   4     0   4   32 54                       86 54 13 9 2   4     0   4   32 54                 86
743812 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_9 78 2 1 0   0     0   4   39 46                       85 78 2 1 0   0     0   4   39 46                 85
743896 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_9 33 4 7 1   1     0   6   26 26                       52 33 4 7 1   1     0   6   26 26                 52
736280 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_9 3 46 12 1   1     0   3   39 27                       66 3 46 12 1   1     0   3   39 27                 66
736883 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_9 2 12 11 0   19     0   1   23 22                       45 2 12 11 0   19     0   1   23 22                 45
736925 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_9 7 113 39 1   5     1   2   97 71                       168 7 113 39 1   5     1   2   97 71                 168
737452 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_9 120 2 2 1   0     1   1   61 66                       127 120 2 2 1   0     1   1   61 66                 127
737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
737635 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_9 91 5 1 1   1     0   0   60 39                       99 91 5 1 1   1     0   0   60 39                 99
738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
739064 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_9 56 0 3 0   4     0   1   33 31                       64 56 0 3 0   4     0   1   33 31                 64
740288 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_9 6 6 9 0   0     0   4   22 3                       25 6 6 9 0   0     0   4   22 3                 25
741720 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_9 65 6 88 0   1     0   3   85 78                       163 65 6 88 0   1     0   3   85 78                 163
741951 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_9 36 19 37 0   2     0   8   54 48                       102 36 19 37 0   2     0   8   54 48                 102
741958 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 2 06 09 2015   grade_9 6 18 29 0   0     0   0   35 18                       53 6 18 29 0   0     0   0   35 18                 53
741993 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No 2 06 09 2015   grade_9 8 18 34 0   0     0   0   15 45                       60 8 18 34 0   0     0   0   15 45                 60
742651 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   grade_9 69 0 3 0   0     0   2   38 36                       74 69 0 3 0   0     0   2   38 36                 74
743421 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2015   grade_9 3 35 29 1   2     0   1   39 32                       71 3 35 29 1   2     0   1   39 32                 71
743443 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_9 43 7 4 0   2     1   0   22 35                       57 43 7 4 0   2     1   0   22 35                 57
743454 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_9 4 55 16 0   0     0   0   42 33                       75 4 55 16 0   0     0   0   42 33                 75
743509 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_9 79 3 6 0   22     0   6   66 50                       116 79 3 6 0   22     0   6   66 50                 116
743532 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_9 1 46 14 1   0     1   3   34 32                       66 1 46 14 1   0     1   3   34 32                 66
743823 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2015   grade_9 22 5 24 0   2     0   0   31 22                       53 22 5 24 0   2     0   0   31 22                 53
743917 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2015   grade_9 29 5 15 0   4     0   4   24 33                       57 29 5 15 0   4     0   4   24 33                 57
743987 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_9 73 4 1 0   0     0   1   38 41                       79 73 4 1 0   0     0   1   38 41                 79
744085 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_9 77 0 0 0   4     0   4   46 39                       85 77 0 0 0   4     0   4   46 39                 85
735946 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_9 22 27 7 0   3     0   2   25 36                       61 22 27 7 0   3     0   2   25 36                 61
736031 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_9 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
736239 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   1 2                       3                         1 2                 3
736856 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_9 90 97 68 1   73     1   6   144 192                       336 90 97 68 1   73     1   6   144 192                 336
736876 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_9 185 59 78 0   111     0   15   193 255                       448 185 59 78 0   111     0   15   193 255                 448
736890 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_9 30 112 98 0   72     0   11   154 169                       323 30 112 98 0   72     0   11   154 169                 323
737130 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_9 2 9 1 0   0     0   0   8 4                       12 2 9 1 0   0     0   0   8 4                 12
737855 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_9 157 9 3 0   0     2   2   82 91                       173 157 9 3 0   0     2   2   82 91                 173
738460 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2015   grade_9 58 0 3 0   2     0   0   25 38                       63 58 0 3 0   2     0   0   25 38                 63
738501 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_9 33 0 1 0   1     0   2   17 20                       37 33 0 1 0   1     0   2   17 20                 37
738564 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_9 28 1 1 0   0     0   2   16 16                       32 28 1 1 0   0     0   2   16 16                 32
738679 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_9 36 23 7 0   3     0   6   42 33                       75 36 23 7 0   3     0   6   42 33                 75
738791 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_9 89 0 0 0   1     0   0   44 46                       90 89 0 0 0   1     0   0   44 46                 90
739036 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_9 50 0 3 0   0     0   1   28 26                       54 50 0 3 0   0     0   1   28 26                 54
739529 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 6 6 17 0   4     0   2   18 17                       35 6 6 17 0   4     0   2   18 17                 35
739536 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_9 30 28 167 1   9     0   6   149 92                       241 30 28 167 1   9     0   6   149 92                 241
739971 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_9 103 1 3 2   1     0   1   53 58                       111 103 1 3 2   1     0   1   53 58                 111
740281 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_9 7 0 3 0   0     0   0   9 1                       10 7 0 3 0   0     0   0   9 1                 10
740625 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_9 24 2 2 0   0     0   1   15 14                       29 24 2 2 0   0     0   1   15 14                 29
742465 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 64 2 6 0   1     0   2   43 32                       75 64 2 6 0   1     0   2   43 32                 75
742481 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   3                         3                         3                   3
742485 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 9 0 2 0   0     0   0   6 5                       11 9 0 2 0   0     0   0   6 5                 11
742555 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   grade_9 97 5 24 0   2     0   10   75 63                       138 97 5 24 0   2     0   10   75 63                 138
742666 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_9 90 2 1 0   3     1   3   40 60                       100 90 2 1 0   3     1   3   40 60                 100
743353 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2015   grade_9 4 4 23 0   9     0   1   26 15                       41 4 4 23 0   9     0   1   26 15                 41
743359 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_9 7 17 58 0   9     0   2   44 49                       93 7 17 58 0   9     0   2   44 49                 93
743436 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_9 32 0 2 0   1     0   1   23 13                       36 32 0 2 0   1     0   1   23 13                 36
743761 MA Worcester   school 2500073 474   The Sizer School: A North Central Charter Essential (District) 250007301750 4740505 The Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2015   grade_9 49 4 14 0   1     0   3   35 36                       71 49 4 14 0   1     0   3   35 36                 71
743778 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes 3 07 12 2015   grade_9 63 0 2 0   1     0   3   33 36                       69 63 0 2 0   1     0   3   33 36                 69
743784 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2015   grade_9 50 3 10 0   2     0   3   24 44                       68 50 3 10 0   2     0   3   24 44                 68
743888 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2015   grade_9 17 18 16 0   7     0   1   26 33                       59 17 18 16 0   7     0   1   26 33                 59
744296 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2015   grade_9 75 1 3 0   1     0   2   44 38                       82 75 1 3 0   1     0   2   44 38                 82
744416 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2015   grade_9 108 1 4 0   0     0   2   48 67                       115 108 1 4 0   0     0   2   48 67                 115
744517 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_9 85 2 2 0   0     0   2   40 51                       91 85 2 2 0   0     0   2   40 51                 91
744554 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2015   grade_9 65 0 5 0   2     0   1   38 35                       73 65 0 5 0   2     0   1   38 35                 73
744722 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2015   grade_9 70 1 0 0   1     0   1   38 35                       73 70 1 0 0   1     0   1   38 35                 73
744765 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_9 114 1 7 0   2     0   5   64 65                       129 114 1 7 0   2     0   5   64 65                 129
744804 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2015   grade_9 47 0 3 0   0     0   0   25 25                       50 47 0 3 0   0     0   0   25 25                 50
745166 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes 4 07 10 2015   grade_9 13 33 2 0   13     0   3   33 31                       64 13 33 2 0   13     0   3   33 31                 64
735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
737169 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2015   grade_9 15 22 20 1   1     0   6   42 23                       65 15 22 20 1   1     0   6   42 23                 65
738486 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_9 68 1 20 0   2     0   1   42 50                       92 68 1 20 0   2     0   1   42 50                 92
738832 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   grade_9 184 4 12 1   3     0   3   100 107                       207 184 4 12 1   3     0   3   100 107                 207
739340 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2015   grade_9 1 2 3 0   0     0   0   5 *                       6 1 2 3 0   0     0   0   5                   6
739390 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_9 102 1 3 0   1     0   1   50 58                       108 102 1 3 0   1     0   1   50 58                 108
739753 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_9 71 6 11 0   4     0   3   37 58                       95 71 6 11 0   4     0   3   37 58                 95
739956 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_9 185 8 80 5   11     1   6   136 160                       296 185 8 80 5   11     1   6   136 160                 296
740453 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_9 65 2 5 0   0     0   6   37 41                       78 65 2 5 0   0     0   6   37 41                 78
740782 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2015   grade_9 84 2 1 0   1     0   2   48 42                       90 84 2 1 0   1     0   2   48 42                 90
742249 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_9 352 66 41 0   7     0   17   256 227                       483 352 66 41 0   7     0   17   256 227                 483
742254 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2015   grade_9 2 3 1 0   0     0   1   6 1                       7 2 3 1 0   0     0   1   6 1                 7
742796 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport High   Regular School No 3 08 12 2015   grade_9 68 1 1 0   0     0   1   39 32                       71 68 1 1 0   0     0   1   39 32                 71
743034 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2015   grade_9 98 2 11 2   0     0   3   55 61                       116 98 2 11 2   0     0   3   55 61                 116
744201 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_9 157 15 20 1   8     0   10   113 98                       211 157 15 20 1   8     0   10   113 98                 211
744510 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2015   grade_9 100 14 9 1   4     0   7   71 64                       135 100 14 9 1   4     0   7   71 64                 135
735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
735710 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_9 281 6 15 0   7     1   7   172 145                       317 281 6 15 0   7     1   7   172 145                 317
735730 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_9 147 0 8 0   1     0   4   91 69                       160 147 0 8 0   1     0   4   91 69                 160
735801 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_9 321 7 23 0   61     0   8   199 221                       420 321 7 23 0   61     0   8   199 221                 420
735852 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_9 249 16 15 0   20     0   6   153 153                       306 249 16 15 0   20     0   6   153 153                 306
735866 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_9 138 3 9 1   17     0   6   91 83                       174 138 3 9 1   17     0   6   91 83                 174
735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
735931 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_9 146 5 12 0   5     0   3   73 98                       171 146 5 12 0   5     0   3   73 98                 171
735988 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_9 159 20 11 0   30     0   10   99 131                       230 159 20 11 0   30     0   10   99 131                 230
736002 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_9 169 3 5 1   2     1   3   97 87                       184 169 3 5 1   2     1   3   97 87                 184
736026 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_9 108 4 5 1   2     0   1   64 57                       121 108 4 5 1   2     0   1   64 57                 121

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