enrollments

Data source: Big Local News · About: Big Local

387 rows where grade = "grade_9", state = "MA" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 387 ✖

grade ✖

  • grade_9 · 387 ✖
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
1672018 1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
1672058 1672058 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_9 231 6 23 0   12     0   9   155 126 *                     281.0 231 6 23 0   12     0   9   155 126                 281
1672078 1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
1672148 1672148 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_9 285 19 42 0   78     0   13   209 226 *                     437.0 285 19 42 0   78     0   13   209 226                 437
1672199 1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
1672213 1672213 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland - Ashland High   Regular School No High 09 12 2021   grade_9 128 3 25 2   31     0   6   97 98 *                     195.0 128 3 25 2   31     0   6   97 98                 195
1672255 1672255 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_9 291 30 73 1   26     0   28   240 209 *                     449.0 291 30 73 1   26     0   28   240 209                 449
1672276 1672276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   grade_9 136 3 14 0   9     0   6   84 84 *                     168.0 136 3 14 0   9     0   6   84 84                 168
1672291 1672291 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_9 23 16 7 1   3     0   3   33 20 *                     53.0 23 16 7 1   3     0   3   33 20                 53
1672321 1672321 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_9 221 34 74 1   9     0   16   194 160 *                     355.0 221 34 74 1   9     0   16   194 160                 355
1672336 1672336 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford - Bedford High   Regular School No High 09 12 2021   grade_9 116 16 29 0   30     1   15   107 100 *                     207.0 116 16 29 0   30     1   15   107 100                 207
1672350 1672350 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown - Belchertown High   Regular School No High 09 12 2021   grade_9 154 4 10 0   2     1   3   69 104 *                     174.0 154 4 10 0   2     1   3   69 104                 174
1672368 1672368 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_9 122 3 15 0   8     0   6   88 66 *                     154.0 122 3 15 0   8     0   6   88 66                 154
1672372 1672372 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_9 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1672401 1672401 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_9 225 14 19 1   52     0   23   169 165 *                     334.0 225 14 19 1   52     0   23   169 165                 334
1672445 1672445 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly - Beverly High   Regular School No High 09 12 2021   grade_9 211 10 57 0   10     0   7   156 139 *                     295.0 211 10 57 0   10     0   7   156 139                 295
1672483 1672483 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica - Billerica Memorial High School   Regular School No High 08 12 2021   grade_9 191 16 27 1   26     1   4   140 125 *                     266.0 191 16 27 1   26     1   4   140 125                 266
1672568 1672568 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston - Carter School   Regular School No High 07 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1672612 1672612 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_9 1 61 24 0   0     1   3   46 44 *                     90.0 1 61 24 0   0     1   3   46 44                 90
1673020 1673020 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_9 1 10 13 0   0     0   2   21 5 *                     26.0 1 10 13 0   0     0   2   21 5                 26
1673122 1673122 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_9 6 33 18 0   5     0   5   41 26 *                     67.0 6 33 18 0   5     0   5   41 26                 67
1673135 1673135 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston - Brighton High   Regular School No High 09 12 2021   grade_9 3 19 30 0   3     0   2   29 28 *                     57.0 3 19 30 0   3     0   2   29 28                 57
1673140 1673140 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston - Boston International High School   Regular School No High 09 12 2021   grade_9 1 37 78 0   5     0   1   80 42 *                     122.0 1 37 78 0   5     0   1   80 42                 122
1673144 1673144 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston - Charlestown High   Regular School No High 09 12 2021   grade_9 4 22 82 1   6     0   3   61 57 *                     118.0 4 22 82 1   6     0   3   61 57                 118
1673149 1673149 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston - Community Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1673154 1673154 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston - Excel High School   Regular School No High 09 12 2021   grade_9 9 22 54 0   14     0   3   58 44 *                     102.0 9 22 54 0   14     0   3   58 44                 102
1673159 1673159 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_9 3 44 31 0   1     0   2   50 31 *                     81.0 3 44 31 0   1     0   2   50 31                 81
1673164 1673164 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston - East Boston High   Regular School No High 09 12 2021   grade_9 23 14 166 0   1     0   3   113 94 *                     207.0 23 14 166 0   1     0   3   113 94                 207
1673169 1673169 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston - The English High   Regular School No High 09 12 2021   grade_9 5 44 43 1   1     0   6   54 46 *                     100.0 5 44 43 1   1     0   6   54 46                 100
1673174 1673174 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston - Madison Park High   Career and Technical School No High 09 12 2021   grade_9 5 123 157 1   7     0   7   174 126 *                     300.0 5 123 157 1   7     0   7   174 126                 300
1673179 1673179 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston - Fenway High School   Alternative School No High 09 12 2021   grade_9 4 27 68 0   2     0   5   52 54 *                     106.0 4 27 68 0   2     0   5   52 54                 106
1673183 1673183 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Boston - Another Course To College   Alternative School No High 09 12 2021   grade_9 0 27 30 0   0     0   2   33 26 *                     59.0 0 27 30 0   0     0   2   33 26                 59
1673189 1673189 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_9 4 54 51 0   4     0   3   64 52 *                     116.0 4 54 51 0   4     0   3   64 52                 116
1673198 1673198 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_9 92 76 87 0   48     0   6   113 195 *                     309.0 92 76 87 0   48     0   6   113 195                 309
1673202 1673202 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston - Boston Arts Academy   Alternative School No High 09 12 2021   grade_9 8 47 66 0   3     0   6   32 97 *                     130.0 8 47 66 0   3     0   6   32 97                 130
1673208 1673208 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Boston - Margarita Muniz Academy   Regular School No High 09 12 2021   grade_9 0 8 62 0   0     0   0   32 38 *                     70.0 0 8 62 0   0     0   0   32 38                 70
1673212 1673212 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston - Boston Community Leadership Academy   Regular School No High 09 12 2021   grade_9 3 46 70 0   1     0   1   57 64 *                     121.0 3 46 70 0   1     0   1   57 64                 121
1673219 1673219 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_9 197 38 72 0   97     0   20   209 215 *                     424.0 197 38 72 0   97     0   20   209 215                 424
1673226 1673226 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_9 2 16 17 0   29     0   3   34 33 *                     67.0 2 16 17 0   29     0   3   34 33                 67
1673233 1673233 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_9 32 114 104 1   65     1   6   136 187 *                     323.0 32 114 104 1   65     1   6   136 187                 323
1673237 1673237 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston - Community Academy of Science and Health   Regular School No High 09 12 2021   grade_9 2 36 16 0   8     0   3   37 28 *                     65.0 2 36 16 0   8     0   3   37 28                 65
1673242 1673242 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston - Lyon Upper 9-12   Regular School No High 09 12 2021   grade_9 3 6 22 0   0     0   5   22 14 *                     36.0 3 6 22 0   0     0   5   22 14                 36
1673260 1673260 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_9 8 88 60 1   4     1   4   97 69 *                     166.0 8 88 60 1   4     1   4   97 69                 166
1673264 1673264 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Boston - Snowden International School at Copley   Regular School No High 09 12 2021   grade_9 8 36 72 0   9     0   1   64 62 *                     126.0 8 36 72 0   9     0   1   64 62                 126
1673303 1673303 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_9 84 1 4 3   2     0   4   49 49 *                     98.0 84 1 4 3   2     0   4   49 49                 98
1673356 1673356 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree - Braintree High   Regular School No High 09 12 2021   grade_9 253 22 20 0   70     0   1   179 186 *                     366.0 253 22 20 0   70     0   1   179 186                 366
1673441 1673441 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton - Frederick Douglass Academy   Regular School No High 09 12 2021   grade_9 1 6 2 0   0     0   0   5 4 *                     9.0 1 6 2 0   0     0   0   5 4                 9
1673454 1673454 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_9 3 4 2 0   0     0   1   8 2 *                     10.0 3 4 2 0   0     0   1   8 2                 10
1673474 1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1673479 1673479 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton - Brockton Champion High School   Alternative School No High 09 12 2021   grade_9 7 15 6 0   0     0   2   16 14 *                     30.0 7 15 6 0   0     0   2   16 14                 30
1673484 1673484 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Brockton - Edison Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1673575 1673575 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_9 256 32 79 0   86     0   56   268 240 *                     509.0 256 32 79 0   86     0   56   268 240                 509
1673608 1673608 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington - Burlington High   Regular School No High 09 12 2021   grade_9 133 14 15 3   35     0   5   105 100 *                     205.0 133 14 15 3   35     0   5   105 100                 205
1673711 1673711 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_9 162 114 73 0   43     0   36   198 228 *                     428.0 162 114 73 0   43     0   36   198 228                 428
1673738 1673738 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton - Canton High   Regular School No High 09 12 2021   grade_9 133 33 12 0   24     0   11   99 113 *                     213.0 133 33 12 0   24     0   11   99 113                 213
1673763 1673763 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_9 99 1 3 0   0     0   3   66 40 *                     106.0 99 1 3 0   0     0   3   66 40                 106
1673796 1673796 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford - Chelmsford High   Regular School No High 09 12 2021   grade_9 245 15 25 0   61     1   11   180 178 *                     358.0 245 15 25 0   61     1   11   180 178                 358
1673833 1673833 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea - Chelsea High   Regular School No High 09 12 2021   grade_9 29 18 380 1   0     0   4   222 210 *                     432.0 29 18 380 1   0     0   4   222 210                 432
1673863 1673863 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee - Chicopee Academy   Alternative School No High 07 12 2021   grade_9 2 1 7 0   0     0   1   6 5 *                     11.0 2 1 7 0   0     0   1   6 5                 11
1673902 1673902 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee - Chicopee High   Regular School No High 09 12 2021   grade_9 87 4 104 0   8     0   8   98 113 *                     211.0 87 4 104 0   8     0   8   98 113                 211
1673906 1673906 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee - Chicopee Comprehensive High School   Regular School No High 09 12 2021   grade_9 179 8 110 0   6     0   17   177 143 *                     320.0 179 8 110 0   6     0   17   177 143                 320
1673930 1673930 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton - Clinton Senior High   Regular School No High 09 12 2021   grade_9 80 2 51 0   1     0   1   70 64 *                     135.0 80 2 51 0   1     0   1   70 64                 135
1673944 1673944 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset - Cohasset High School   Regular School No High 09 12 2021   grade_9 94 3 1 0   3     0   2   52 51 *                     103.0 94 3 1 0   3     0   2   52 51                 103
1674015 1674015 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers - Danvers High   Regular School No High 09 12 2021   grade_9 181 7 17 0   7     0   6   106 112 *                     218.0 181 7 17 0   7     0   6   106 112                 218
1674043 1674043 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth - Dartmouth High   Regular School No High 09 12 2021   grade_9 220 8 16 0   0     0   16   129 131 *                     260.0 220 8 16 0   0     0   16   129 131                 260
1674072 1674072 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham - Dedham High   Regular School No High 09 12 2021   grade_9 110 15 23 0   8     0   7   86 77 *                     163.0 110 15 23 0   8     0   7   86 77                 163
1674095 1674095 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas - Douglas High School   Regular School No High 09 12 2021   grade_9 77 0 3 0   1     0   3   53 31 *                     84.0 77 0 3 0   1     0   3   53 31                 84
1674134 1674134 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_9 154 9 21 1   24     0   2   105 103 *                     211.0 154 9 21 1   24     0   2   105 103                 211
1674149 1674149 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury - Duxbury High   Regular School No High 09 12 2021   grade_9 216 2 5 0   7     0   12   123 119 *                     242.0 216 2 5 0   7     0   12   123 119                 242
1674163 1674163 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_9 132 3 4 0   0     0   4   86 57 *                     143.0 132 3 4 0   0     0   4   86 57                 143
1674194 1674194 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton - Easthampton High   Regular School No High 09 12 2021   grade_9 77 2 10 0   5     0   3   41 56 *                     97.0 77 2 10 0   5     0   3   41 56                 97
1674212 1674212 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow - East Longmeadow High   Regular School No High 09 12 2021   grade_9 171 7 11 0   9     0   5   98 105 *                     203.0 171 7 11 0   9     0   5   98 105                 203
1674233 1674233 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton - Oliver Ames High   Regular School No High 09 12 2021   grade_9 220 9 18 0   10     0   8   137 128 *                     265.0 220 9 18 0   10     0   8   137 128                 265
1674297 1674297 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_9 2 2 1 0   0     0   1   4 2 *                     6.0 2 2 1 0   0     0   1   4 2                 6
1674319 1674319 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_9 103 79 329 4   31     1   9   272 284 *                     556.0 103 79 329 4   31     1   9   272 284                 556
1674340 1674340 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven - Fairhaven High   Regular School No High 09 12 2021   grade_9 129 0 7 1   5     0   8   80 70 *                     150.0 129 0 7 1   5     0   8   80 70                 150
1674433 1674433 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_9 3 1 3 0   0     0   2   8 1 *                     9.0 3 1 3 0   0     0   2   8 1                 9
1674437 1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1674443 1674443 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_9 10 6 14 0   0     0   3   22 11 *                     33.0 10 6 14 0   0     0   3   22 11                 33
1674473 1674473 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_9 158 15 13 0   2     0   11   102 97 *                     199.0 158 15 13 0   2     0   11   102 97                 199
1674515 1674515 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg - Fitchburg High   Regular School No High 09 12 2021   grade_9 77 18 197 0   24     0   16   164 168 *                     332.0 77 18 197 0   24     0   16   164 168                 332
1674519 1674519 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Fitchburg - Goodrich Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1674553 1674553 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough - Foxborough High   Regular School No High 09 12 2021   grade_9 151 12 16 0   4     0   6   95 93 *                     189.0 151 12 16 0   4     0   6   95 93                 189
1674622 1674622 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_9 326 39 245 0   24     1   26   356 305 *                     661.0 326 39 245 0   24     1   26   356 305                 661
1674672 1674672 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_9 346 8 16 0   32     1   11   200 214 *                     414.0 346 8 16 0   32     1   11   200 214                 414
1674687 1674687 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   grade_9 110 6 41 0   1     0   12   91 79 *                     170.0 110 6 41 0   1     0   12   91 79                 170
1674692 1674692 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner - Gardner Academy for Learning and Technology   Alternative School No High 09 12 2021   grade_9 7 0 6 0   1     0   0   11 3 *                     14.0 7 0 6 0   1     0   0   11 3                 14
1674706 1674706 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown - Georgetown High School   Regular School No High 09 12 2021   grade_9 71 1 2 0   0     0   0   38 36 *                     74.0 71 1 2 0   0     0   0   38 36                 74
1674744 1674744 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_9 210 3 26 0   5     3   11   146 112 *                     258.0 210 3 26 0   5     3   11   146 112                 258
1674759 1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674782 1674782 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton - Grafton High School   Regular School No High 09 12 2021   grade_9 163 7 13 2   22     1   5   101 112 *                     213.0 163 7 13 2   22     1   5   101 112                 213
1674796 1674796 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby - Granby Jr Sr High School   Regular School No High 07 12 2021   grade_9 43 0 2 0   1     0   3   23 26 *                     49.0 43 0 2 0   1     0   3   23 26                 49
1674820 1674820 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield - Greenfield High   Regular School No High 08 12 2021   grade_9 60 2 22 0   2     0   9   56 39 *                     95.0 60 2 22 0   2     0   9   56 39                 95
1674834 1674834 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_9 36 1 5 0   2     3   3   27 23 *                     50.0 36 1 5 0   2     3   3   27 23                 50
1674863 1674863 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover - Hanover High   Regular School No High 09 12 2021   grade_9 171 2 3 0   5     0   1   103 79 *                     182.0 171 2 3 0   5     0   1   103 79                 182
1674878 1674878 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_9 67 0 5 0   11     0   2   37 48 *                     85.0 67 0 5 0   11     0   2   37 48                 85
1674892 1674892 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_9 21 1 0 0   0     0   0   12 9 *                     22.0 21 1 0 0   0     0   0   12 9                 22
1674917 1674917 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_9 2 0 8 0   0     0   0   9 1 *                     10.0 2 0 8 0   0     0   0   9 1                 10
1674955 1674955 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_9 274 28 202 2   6     2   5   277 242 *                     519.0 274 28 202 2   6     2   5   277 242                 519
1674960 1674960 MA Essex   school 2505970 128   Haverhill 250597002907 1280515 Haverhill - Crowell   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   2 * *                     3.0                         2                   3

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