Data source: Big Local News · About: Big Local

2,773 rows where grade = "grade_11" and state = "MA"

View and edit SQL

year

grade

  • grade_11 · 2,773
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
735670 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_11 105 6 2 0   2     0   2   59 58                       117 105 6 2 0   2     0   2   59 58                 117
735712 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_11 288 7 19 1   6     1   7   171 158                       329 288 7 19 1   6     1   7   171 158                 329
735732 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_11 149 1 9 0   2     0   7   86 82                       168 149 1 9 0   2     0   7   86 82                 168
735803 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_11 331 5 18 2   63     0   13   208 224                       432 331 5 18 2   63     0   13   208 224                 432
735854 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_11 243 12 16 1   35     0   3   141 169                       310 243 12 16 1   35     0   3   141 169                 310
735868 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_11 161 1 13 0   10     0   4   101 88                       189 161 1 13 0   10     0   4   101 88                 189
735910 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_11 324 26 56 3   23     1   19   241 211                       452 324 26 56 3   23     1   19   241 211                 452
735913 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2015   grade_11 6 0 4 0   2     1   1   10 4                       14 6 0 4 0   2     1   1   10 4                 14
735933 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_11 140 3 11 0   4     0   4   66 96                       162 140 3 11 0   4     0   4   66 96                 162
735948 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_11 23 20 4 0   2     0   1   25 25                       50 23 20 4 0   2     0   1   25 25                 50
735975 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_11 313 28 28 4   13     0   13   189 210                       399 313 28 28 4   13     0   13   189 210                 399
735990 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_11 156 14 12 1   15     0   6   109 95                       204 156 14 12 1   15     0   6   109 95                 204
736004 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_11 161 1 6 0   5     0   4   90 87                       177 161 1 6 0   5     0   4   90 87                 177
736028 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_11 144 3 5 1   2     0   5   95 65                       160 144 3 5 1   2     0   5   95 65                 160
736033 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_11 * * * *   *     *   *   1 3                       4                         1 3                 4
736062 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_11 210 14 12 0   61     0   15   136 176                       312 210 14 12 0   61     0   15   136 176                 312
736117 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_11 296 7 18 0   7     0   6   150 184                       334 296 7 18 0   7     0   6   150 184                 334
736165 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   grade_11 274 4 6 0   13     0   4   139 162                       301 274 4 6 0   13     0   4   139 162                 301
736682 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_11 3 37 17 1   1     0   0   41 18                       59 3 37 17 1   1     0   0   41 18                 59
736781 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_11 4 18 7 2   1     0   0   14 18                       32 4 18 7 2   1     0   0   14 18                 32
736796 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   grade_11 11 113 97 0   6     0   6   128 105                       233 11 113 97 0   6     0   6   128 105                 233
736801 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_11 2 32 27 0   4     0   1   38 28                       66 2 32 27 0   4     0   1   38 28                 66
736805 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_11 16 79 74 1   47     1   6   117 107                       224 16 79 74 1   47     1   6   117 107                 224
736810 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_11 5 6 2 0   0     0   0   10 3                       13 5 6 2 0   0     0   0   10 3                 13
736814 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2015   grade_11 23 65 40 0   34     0   4   105 61                       166 23 65 40 0   34     0   4   105 61                 166
736819 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2015   grade_11 3 111 32 1   2     0   2   80 71                       151 3 111 32 1   2     0   2   80 71                 151
736824 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_11 52 34 195 1   6     0   3   155 136                       291 52 34 195 1   6     0   3   155 136                 291
736829 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2015   grade_11 4 55 60 0   1     0   1   64 57                       121 4 55 60 0   1     0   1   64 57                 121
736834 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_11 11 108 116 1   2     0   2   146 94                       240 11 108 116 1   2     0   2   146 94                 240
736839 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_11 7 32 38 1   4     0   2   44 40                       84 7 32 38 1   4     0   2   44 40                 84
736843 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_11 5 25 24 0   4     0   1   21 38                       59 5 25 24 0   4     0   1   21 38                 59
736847 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_11 3 44 32 1   2     0   1   35 48                       83 3 44 32 1   2     0   1   35 48                 83
736851 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2015   grade_11 3 11 22 0   1     0   1   18 20                       38 3 11 22 0   1     0   1   18 20                 38
736858 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_11 76 78 56 2   50     0   4   97 169                       266 76 78 56 2   50     0   4   97 169                 266
736862 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_11 18 43 51 1   5     0   1   46 73                       119 18 43 51 1   5     0   1   46 73                 119
736864 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2015   grade_11 1 30 23 0   4     0   0   34 24                       58 1 30 23 0   4     0   0   34 24                 58
736868 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 4 09 11 2015   grade_11 2 5 64 1   1     0   0   33 40                       73 2 5 64 1   1     0   0   33 40                 73
736871 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2015   grade_11 13 50 63 0   6     0   3   59 76                       135 13 50 63 0   6     0   3   59 76                 135
736878 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_11 187 40 37 0   142     1   8   207 208                       415 187 40 37 0   142     1   8   207 208                 415
736885 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_11 3 12 6 0   31     0   0   29 23                       52 3 12 6 0   31     0   0   29 23                 52
736892 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_11 33 100 67 0   59     0   5   122 142                       264 33 100 67 0   59     0   5   122 142                 264
736896 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2015   grade_11 8 65 58 0   4     0   3   74 64                       138 8 65 58 0   4     0   3   74 64                 138
736901 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_11 2 84 16 0   1     0   1   55 49                       104 2 84 16 0   1     0   1   55 49                 104
736906 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_11 2 67 14 1   5     0   1   51 39                       90 2 67 14 1   5     0   1   51 39                 90
736911 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_11 13 9 11 0   1     0   2   20 16                       36 13 9 11 0   1     0   2   20 16                 36
736927 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_11 4 102 20 2   6     0   4   81 57                       138 4 102 20 2   6     0   4   81 57                 138
736932 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2015   grade_11 11 77 64 2   2     1   2   86 73                       159 11 77 64 2   2     1   2   86 73                 159
736937 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2015   grade_11 9 40 33 0   9     0   2   52 41                       93 9 40 33 0   9     0   2   52 41                 93
736981 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_11 125 5 8 0   5     1   8   90 62                       152 125 5 8 0   5     1   8   90 62                 152
737041 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   grade_11 304 22 12 0   56     0   3   203 194                       397 304 22 12 0   56     0   3   203 194                 397
737132 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_11 0 5 0 1   0     0   0   5 1                       6 0 5 0 1   0     0   0   5 1                 6
737144 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_11 5 4 1 0   0     0   2   8 4                       12 5 4 1 0   0     0   2   8 4                 12
737166 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_11 231 627 106 3   26     0   23   530 486                       1016 231 627 106 3   26     0   23   530 486                 1016
737171 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2015   grade_11 11 21 7 0   0     0   2   23 18                       41 11 21 7 0   0     0   2   23 18                 41
737175 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No 3 09 12 2015   grade_11 15 63 9 0   1     1   3   49 43                       92 15 63 9 0   1     1   3   49 43                 92
737266 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_11 257 37 48 0   60     0   29   218 213                       431 257 37 48 0   60     0   29   218 213                 431
737300 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_11 186 18 3 0   25     0   9   125 116                       241 186 18 3 0   25     0   9   125 116                 241
737403 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_11 169 157 53 3   41     0   16   215 224                       439 169 157 53 3   41     0   16   215 224                 439
737430 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No 3 09 12 2015   grade_11 167 26 9 0   13     0   7   115 107                       222 167 26 9 0   13     0   7   115 107                 222
737454 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_11 102 3 0 0   0     0   1   50 56                       106 102 3 0 0   0     0   1   50 56                 106
737488 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_11 363 3 8 0   45     1   3   202 221                       423 363 3 8 0   45     1   3   202 221                 423
737522 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_11 20 25 259 2   5     0   1   162 150                       312 20 25 259 2   5     0   1   162 150                 312
737552 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_11 6 0 11 0   0     0   1   10 8                       18 6 0 11 0   0     0   1   10 8                 18
737592 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2015   grade_11 126 8 109 0   12     0   5   126 134                       260 126 8 109 0   12     0   5   126 134                 260
737597 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_11 240 12 90 0   8     0   12   194 168                       362 240 12 90 0   8     0   12   194 168                 362
737622 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_11 61 6 29 0   3     0   0   48 51                       99 61 6 29 0   3     0   0   48 51                 99
737637 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_11 105 4 0 0   2     0   1   59 53                       112 105 4 0 0   2     0   1   59 53                 112
737706 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2015   grade_11 235 6 10 0   3     0   3   126 131                       257 235 6 10 0   3     0   3   126 131                 257
737733 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_11 242 6 4 1   13     0   4   121 149                       270 242 6 4 1   13     0   4   121 149                 270
737764 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No 3 09 12 2015   grade_11 133 15 24 0   7     0   5   99 85                       184 133 15 24 0   7     0   5   99 85                 184
737786 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_11 91 0 2 0   0     0   1   49 45                       94 91 0 2 0   0     0   1   49 45                 94
737824 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2015   grade_11 210 8 8 0   8     0   0   107 127                       234 210 8 8 0   8     0   0   107 127                 234
737829 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_11 * * * *   *     *   *   * *                       2                                             2
737843 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No 3 09 12 2015   grade_11 253 1 4 1   5     0   3   134 133                       267 253 1 4 1   5     0   3   134 133                 267
737857 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_11 135 0 1 0   2     1   2   71 70                       141 135 0 1 0   2     1   2   71 70                 141
737888 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No 3 09 12 2015   grade_11 103 1 5 0   3     0   1   62 51                       113 103 1 5 0   3     0   1   62 51                 113
737906 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2015   grade_11 203 3 10 1   5     0   0   100 122                       222 203 3 10 1   5     0   0   100 122                 222
737929 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No 3 09 12 2015   grade_11 236 18 8 0   6     0   5   138 135                       273 236 18 8 0   6     0   5   138 135                 273
738009 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_11 163 99 149 2   30     0   6   236 213                       449 163 99 149 2   30     0   6   236 213                 449
738030 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No 3 09 12 2015   grade_11 154 1 6 0   3     0   2   88 78                       166 154 1 6 0   3     0   2   88 78                 166
738116 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2015   grade_11 32 6 13 0   2     0   0   33 20                       53 32 6 13 0   2     0   0   33 20                 53
738125 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_11 355 53 110 2   27     0   11   244 314                       558 355 53 110 2   27     0   11   244 314                 558
738155 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_11 159 8 4 5   9     1   5   95 96                       191 159 8 4 5   9     1   5   95 96                 191
738196 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   grade_11 98 20 143 1   24     0   10   154 142                       296 98 20 143 1   24     0   10   154 142                 296
738201 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No 3 09 12 2015   grade_11 32 3 27 0   1     0   1   30 34                       64 32 3 27 0   1     0   1   30 34                 64
738235 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2015   grade_11 199 10 6 1   7     0   1   104 120                       224 199 10 6 1   7     0   1   104 120                 224
738298 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_11 340 36 84 1   35     0   1   241 256                       497 340 36 84 1   35     0   1   241 256                 497
738348 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_11 370 8 7 2   22     0   7   182 234                       416 370 8 7 2   22     0   7   182 234                 416
738366 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_11 105 1 9 2   3     2   3   73 52                       125 105 1 9 2   3     2   3   73 52                 125
738371 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_11 22 0 1 0   0     0   0   11 12                       23 22 0 1 0   0     0   0   11 12                 23
738385 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2015   grade_11 96 0 2 0   1     0   1   46 54                       100 96 0 2 0   1     0   1   46 54                 100
738423 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_11 185 2 11 1   4     0   1   103 101                       204 185 2 11 1   4     0   1   103 101                 204
738447 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2015   grade_11 189 4 6 1   11     0   5   101 115                       216 189 4 6 1   11     0   5   101 115                 216
738462 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2015   grade_11 75 0 0 0   0     0   0   35 40                       75 75 0 0 0   0     0   0   35 40                 75
738488 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_11 63 3 13 0   3     0   3   48 37                       85 63 3 13 0   3     0   3   48 37                 85
738503 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_11 46 0 5 0   3     0   2   31 25                       56 46 0 5 0   3     0   2   31 25                 56
738537 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2015   grade_11 196 4 3 0   0     0   0   97 106                       203 196 4 3 0   0     0   0   97 106                 203
738552 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_11 92 0 1 0   6     0   0   54 45                       99 92 0 1 0   6     0   0   54 45                 99
738566 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_11 28 1 0 0   1     0   1   12 19                       31 28 1 0 0   1     0   1   12 19                 31
738587 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_11 5 2 4 0   0     0   0   9 2                       11 5 2 4 0   0     0   0   9 2                 11

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