Data source: Big Local News · About: Big Local

395 rows where grade = "grade_10", state = "MA" and year = 2018

View and edit SQL

year

  • 2018 · 395

grade

  • grade_10 · 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
2228769 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_10 109 3 11 1   4     0   2   58 72                       130.0 109 3 11 1   4     0   2   58 72                 130
2228818 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_10 254 4 12 0   6     0   3   139 140                       279.0 254 4 12 0   6     0   3   139 140                 279
2228842 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_10 134 1 6 0   2     0   3   73 73                       146.0 134 1 6 0   2     0   3   73 73                 146
2228847 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_10 11 0 1 0   0     0   0   5 7                       12.0 11 0 1 0   0     0   0   5 7                 12
2228926 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_10 317 9 27 1   63     0   10   214 213                       427.0 317 9 27 1   63     0   10   214 213                 427
2228986 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_10 245 15 18 0   34     1   8   172 147                       321.0 245 15 18 0   34     1   8   172 147                 321
2229005 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_10 144 7 31 1   23     0   1   101 106                       207.0 144 7 31 1   23     0   1   101 106                 207
2229057 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_10 305 23 74 2   14     0   23   230 211                       441.0 305 23 74 2   14     0   23   230 211                 441
2229083 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_10 145 2 18 1   9     0   9   91 93                       184.0 145 2 18 1   9     0   9   91 93                 184
2229099 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_10 22 21 3 0   4     0   3   23 29                       53.0 22 21 3 0   4     0   3   23 29                 53
2229133 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_10 252 32 49 1   9     1   12   157 199                       356.0 252 32 49 1   9     1   12   157 199                 356
2229151 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_10 143 13 19 0   25     1   9   104 106                       210.0 143 13 19 0   25     1   9   104 106                 210
2229170 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown: Belchertown High   Regular School No High 09 12 2018   grade_10 163 1 11 0   2     0   1   90 88                       178.0 163 1 11 0   2     0   1   90 88                 178
2229193 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham: Bellingham High School   Regular School No High 08 12 2018   grade_10 127 1 12 1   5     0   3   68 81                       149.0 127 1 12 1   5     0   3   68 81                 149
2229199 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_10 8 0 1 0   0     0   0   6 3                       9.0 8 0 1 0   0     0   0   6 3                 9
2229234 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont: Belmont High   Regular School No High 09 12 2018   grade_10 234 11 18 0   54     0   14   152 179                       331.0 234 11 18 0   54     0   14   152 179                 331
2229300 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   grade_10 236 6 54 0   6     0   10   159 153                       312.0 236 6 54 0   6     0   10   159 153                 312
2229356 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_10 289 9 20 0   22     0   7   167 180                       347.0 289 9 20 0   22     0   7   167 180                 347
2229454 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_10 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2229502 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_10 0 27 4 0   0     0   4   18 17                       35.0 0 27 4 0   0     0   4   18 17                 35
2229945 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_10 4 27 21 0   0     0   0   34 18                       52.0 4 27 21 0   0     0   0   34 18                 52
2230059 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_10 6 32 12 0   3     0   3   30 26                       56.0 6 32 12 0   3     0   3   30 26                 56
2230076 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston: Brighton High   Regular School No High 09 12 2018   grade_10 5 60 70 1   5     0   0   96 45                       141.0 5 60 70 1   5     0   0   96 45                 141
2230081 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston: Boston International High School   Regular School No High 09 12 2018   grade_10 1 42 43 0   2     1   1   37 53                       90.0 1 42 43 0   2     1   1   37 53                 90
2230086 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_10 12 59 105 1   29     0   3   129 80                       209.0 12 59 105 1   29     0   3   129 80                 209
2230091 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston: Community Academy   Regular School No High 09 12 2018   grade_10 3 7 4 0   0     0   0   7 7                       14.0 3 7 4 0   0     0   0   7 7                 14
2230096 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston: Excel High School   Regular School No High 09 12 2018   grade_10 10 38 42 0   19     0   1   61 49                       110.0 10 38 42 0   19     0   1   61 49                 110
2230101 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston: Jeremiah E Burke High   Regular School No High 09 12 2018   grade_10 4 60 21 0   1     0   1   46 41                       87.0 4 60 21 0   1     0   1   46 41                 87
2230106 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_10 27 11 228 1   4     0   3   147 127                       274.0 27 11 228 1   4     0   3   147 127                 274
2230111 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston: The English High   Regular School No High 09 12 2018   grade_10 1 43 53 0   1     0   0   48 50                       98.0 1 43 53 0   1     0   0   48 50                 98
2230116 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_10 2 72 155 1   2     0   6   130 108                       238.0 2 72 155 1   2     0   6   130 108                 238
2230121 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston: Fenway High School   Alternative School No High 09 12 2018   grade_10 2 33 60 0   1     0   1   44 53                       97.0 2 33 60 0   1     0   1   44 53                 97
2230126 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Boston: Another Course To College   Alternative School No High 09 12 2018   grade_10 4 27 22 0   1     0   1   25 30                       55.0 4 27 22 0   1     0   1   25 30                 55
2230132 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston: New Mission High School   Alternative School No High 07 12 2018   grade_10 3 38 29 0   0     0   3   32 41                       73.0 3 38 29 0   0     0   3   32 41                 73
2230136 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Boston: Greater Egleston Community High School   Regular School No High 10 12 2018   grade_10 0 6 7 0   0     0   0   6 7                       13.0 0 6 7 0   0     0   0   6 7                 13
2230143 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_10 95 51 61 0   66     0   12   125 160                       285.0 95 51 61 0   66     0   12   125 160                 285
2230148 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston: Boston Arts Academy   Alternative School No High 09 12 2018   grade_10 13 56 59 0   4     0   4   48 88                       136.0 13 56 59 0   4     0   4   48 88                 136
2230156 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Boston: Margarita Muniz Academy   Regular School No High 09 12 2018   grade_10 1 2 70 0   0     0   0   27 46                       73.0 1 2 70 0   0     0   0   27 46                 73
2230161 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston: Boston Community Leadership Academy   Regular School No High 09 12 2018   grade_10 6 44 71 0   8     0   2   73 58                       131.0 6 44 71 0   8     0   2   73 58                 131
2230168 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_10 188 31 51 1   122     0   18   179 232                       411.0 188 31 51 1   122     0   18   179 232                 411
2230176 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_10 5 14 17 0   24     0   0   29 31                       60.0 5 14 17 0   24     0   0   29 31                 60
2230183 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_10 19 85 82 1   68     0   9   104 160                       264.0 19 85 82 1   68     0   9   104 160                 264
2230188 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Boston: Urban Science Academy   Regular School No High 09 12 2018   grade_10 2 39 26 0   0     0   2   39 29                       69.0 2 39 26 0   0     0   2   39 29                 69
2230193 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston: Community Academy of Science and Health   Regular School No High 09 12 2018   grade_10 1 37 20 0   3     0   2   34 29                       63.0 1 37 20 0   3     0   2   34 29                 63
2230198 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Boston: Dorchester Academy   Regular School No High 09 12 2018   grade_10 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230213 MA Suffolk   school   35   Boston   350652               2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2230218 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston: Lyon Upper 9-12   Regular School No High 09 12 2018   grade_10 8 10 12 0   3     0   1   16 18                       34.0 8 10 12 0   3     0   1   16 18                 34
2230237 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_10 3 109 26 1   5     0   4   73 75                       148.0 3 109 26 1   5     0   4   73 75                 148
2230242 MA Suffolk   school 2502790 35   Boston 250279002729 350658 Boston: West Roxbury Academy   Regular School No High 09 12 2018   grade_10 8 49 25 0   0     0   2   44 40                       84.0 8 49 25 0   0     0   2   44 40                 84
2230247 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Boston: Snowden International School at Copley   Regular School No High 09 12 2018   grade_10 4 32 56 0   10     0   2   50 54                       104.0 4 32 56 0   10     0   2   50 54                 104
2230270 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_10 0 3 5 0   1     0   1   7 3                       10.0 0 3 5 0   1     0   1   7 3                 10
2230275 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston: Boston Collaborative High School   Alternative School No High 09 12 2018   grade_10 0 12 20 0   0     0   2   17 17                       34.0 0 12 20 0   0     0   2   17 17                 34
2230298 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne: Bourne High School   Regular School No High 09 12 2018   grade_10 106 2 8 1   5     1   4   62 65                       127.0 106 2 8 1   5     1   4   62 65                 127
2230373 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree: Braintree High   Regular School No High 09 12 2018   grade_10 323 18 17 0   65     0   3   209 217                       426.0 323 18 17 0   65     0   3   209 217                 426
2230472 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_10 1 6 1 0   0     0   0   5 3                       8.0 1 6 1 0   0     0   0   5 3                 8
2230485 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_10 1 7 0 0   0     0   0   5 3                       8.0 1 7 0 0   0     0   0   5 3                 8
2230514 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_10 167 642 144 6   27     2   34   556 466                       1022.0 167 642 144 6   27     2   34   556 466                 1022
2230519 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton: Brockton Champion High School   Regular School No High 09 12 2018   grade_10 9 13 10 0   0     0   3   23 12                       35.0 9 13 10 0   0     0   3   23 12                 35
2230523 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Brockton: Edison Academy   Regular School No High 09 12 2018   grade_10 5 11 3 0   0     0   1   11 9                       20.0 5 11 3 0   0     0   1   11 9                 20
2230627 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   grade_10 268 37 56 0   102     0   47   269 241                       510.0 268 37 56 0   102     0   47   269 241                 510
2230666 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   grade_10 174 14 17 2   37     0   7   130 121                       251.0 174 14 17 2   37     0   7   130 121                 251
2230786 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_10 195 134 63 3   54     1   36   245 241                       486.0 195 134 63 3   54     1   36   245 241                 486
2230818 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton: Canton High   Regular School No High 09 12 2018   grade_10 167 28 11 0   23     0   10   118 119                       239.0 167 28 11 0   23     0   10   118 119                 239
2230845 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_10 103 2 0 0   0     0   0   50 55                       105.0 103 2 0 0   0     0   0   50 55                 105
2230886 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford: Chelmsford High   Regular School No High 09 12 2018   grade_10 284 10 12 0   55     1   5   169 198                       367.0 284 10 12 0   55     1   5   169 198                 367
2230930 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_10 21 21 361 0   7     1   2   218 195                       413.0 21 21 361 0   7     1   2   218 195                 413
2230965 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_10 7 0 10 0   0     0   0   12 5                       17.0 7 0 10 0   0     0   0   12 5                 17
2231013 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee: Chicopee High   Regular School No High 09 12 2018   grade_10 120 4 99 0   2     0   1   118 108                       226.0 120 4 99 0   2     0   1   118 108                 226
2231018 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee: Chicopee Comprehensive High School   Regular School No High 09 12 2018   grade_10 208 8 101 0   5     0   9   175 156                       331.0 208 8 101 0   5     0   9   175 156                 331
2231046 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton: Clinton Senior High   Regular School No High 09 12 2018   grade_10 68 6 34 0   2     0   1   64 47                       111.0 68 6 34 0   2     0   1   64 47                 111
2231063 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_10 113 4 3 0   7     0   0   60 67                       127.0 113 4 3 0   7     0   0   60 67                 127
2231145 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers: Danvers High   Regular School No High 09 12 2018   grade_10 209 3 10 0   9     0   3   109 125                       234.0 209 3 10 0   9     0   3   109 125                 234
2231178 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth: Dartmouth High   Regular School No High 09 12 2018   grade_10 254 3 6 0   1     0   19   164 119                       283.0 254 3 6 0   1     0   19   164 119                 283
2231214 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham: Dedham High   Regular School No High 09 12 2018   grade_10 140 22 31 0   4     0   1   95 103                       198.0 140 22 31 0   4     0   1   95 103                 198
2231241 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas: Douglas High School   Regular School No High 09 12 2018   grade_10 91 0 3 0   3     1   2   42 58                       100.0 91 0 3 0   3     1   2   42 58                 100
2231287 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut: Dracut Senior High   Regular School No High 09 12 2018   grade_10 166 21 9 0   13     0   4   113 100                       213.0 166 21 9 0   13     0   4   113 100                 213
2231305 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury: Duxbury High   Regular School No High 09 12 2018   grade_10 247 1 4 0   2     0   4   130 128                       258.0 247 1 4 0   2     0   4   130 128                 258
2231322 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_10 159 9 4 0   0     0   2   80 94                       174.0 159 9 4 0   0     0   2   80 94                 174
2231359 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton: Easthampton High   Regular School No High 09 12 2018   grade_10 98 1 14 0   6     0   2   51 70                       121.0 98 1 14 0   6     0   2   51 70                 121
2231381 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow: East Longmeadow High   Regular School No High 09 12 2018   grade_10 188 8 10 2   15     0   3   113 113                       226.0 188 8 10 2   15     0   3   113 113                 226
2231409 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton: Oliver Ames High   Regular School No High 09 12 2018   grade_10 228 14 15 1   6     0   6   132 138                       270.0 228 14 15 1   6     0   6   132 138                 270
2231479 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_10 4 0 2 0   0     0   0   2 4                       6.0 4 0 2 0   0     0   0   2 4                 6
2231502 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_10 132 91 266 2   27     2   5   271 254                       525.0 132 91 266 2   27     2   5   271 254                 525
2231527 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven: Fairhaven High   Regular School No High 09 12 2018   grade_10 152 0 11 1   2     0   5   74 97                       171.0 152 0 11 1   2     0   5   74 97                 171
2231632 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River: B M C Durfee High   Regular School No High 09 12 2018   grade_10 315 42 131 2   31     1   22   253 291                       544.0 315 42 131 2   31     1   22   253 291                 544
2231647 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2231654 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_10 16 4 11 0   1     0   0   16 16                       32.0 16 4 11 0   1     0   0   16 16                 32
2231690 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_10 185 12 9 1   6     0   9   106 115                       222.0 185 12 9 1   6     0   9   106 115                 222
2231738 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg: Fitchburg High   Regular School No High 09 12 2018   grade_10 88 22 130 0   18     0   18   147 129                       276.0 88 22 130 0   18     0   18   147 129                 276
2231743 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Fitchburg: Goodrich Academy   Regular School No High 09 12 2018   grade_10 15 1 9 0   0     0   1   11 15                       26.0 15 1 9 0   0     0   1   11 15                 26
2231782 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough: Foxborough High   Regular School No High 09 12 2018   grade_10 181 14 9 0   6     0   7   106 111                       217.0 181 14 9 0   6     0   7   106 111                 217
2231862 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham: Framingham High School   Regular School No High 09 12 2018   grade_10 342 28 136 0   27     1   18   283 269                       552.0 342 28 136 0   27     1   18   283 269                 552
2231923 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_10 385 7 9 0   20     2   14   214 223                       437.0 385 7 9 0   20     2   14   214 223                 437
2231941 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_10 96 7 24 1   5     0   3   67 69                       136.0 96 7 24 1   5     0   3   67 69                 136
2231946 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner: Gardner Academy for Learning and Technology   Alternative School No High 09 12 2018   grade_10 17 2 3 0   0     0   4   15 11                       26.0 17 2 3 0   0     0   4   15 11                 26
2231964 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown: Georgetown High School   Regular School No High 09 12 2018   grade_10 93 0 4 0   1     0   5   46 57                       103.0 93 0 4 0   1     0   5   46 57                 103
2232010 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   grade_10 171 3 30 0   2     1   6   111 102                       213.0 171 3 30 0   2     1   6   111 102                 213
2232025 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2232053 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton: Grafton High School   Regular School No High 09 12 2018   grade_10 180 1 9 0   22     0   6   113 105                       218.0 180 1 9 0   22     0   6   113 105                 218
2232070 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_10 49 0 3 0   2     0   0   26 28                       54.0 49 0 3 0   2     0   0   26 28                 54

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