enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 400 ✖

grade ✖

  • grade_7 · 400 ✖
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
1373226 1373226 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_7 115 1 7 0   0     0   5   74 54 *                     128.0 115 1 7 0   0     0   5   74 54                 128
1373273 1373273 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_7 84 1 7 0   0     0   5   47 50 *                     97.0 84 1 7 0   0     0   5   47 50                 97
1373277 1373277 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_7 127 1 4 0   0     0   7   72 67 *                     139.0 127 1 4 0   0     0   7   72 67                 139
1373372 1373372 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2020   grade_7 57 0 3 1   0     0   1   37 25 *                     62.0 57 0 3 1   0     0   1   37 25                 62
1373414 1373414 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2020   grade_7 56 0 11 1   0     0   11   36 43 *                     79.0 56 0 11 1   0     0   11   36 43                 79
1373455 1373455 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_7 10 1 4 0   0     0   0   5 10 *                     15.0 10 1 4 0   0     0   0   5 10                 15
1373587 1373587 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_7 81 3 3 0   0     0   4   50 41 *                     91.0 81 3 3 0   0     0   4   50 41                 91
1373618 1373618 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional School   Regular School No High 07 12 2020   grade_7 72 1 1 0   0     0   0   36 38 *                     74.0 72 1 1 0   0     0   0   36 38                 74
1373639 1373639 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_7 106 2 9 0   0     1   4   65 57 *                     122.0 106 2 9 0   0     1   4   65 57                 122
1373783 1373783 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2020   grade_7 56 1 1 0   0     0   3   29 32 *                     61.0 56 1 1 0   0     0   3   29 32                 61
1373859 1373859 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_7 45 1 3 1   0     0   4   27 27 *                     54.0 45 1 3 1   0     0   4   27 27                 54
1373955 1373955 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_7 38 0 1 0   0     0   1   24 16 *                     40.0 38 0 1 0   0     0   1   24 16                 40
1374036 1374036 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2020   grade_7 73 1 3 0   0     0   4   41 40 *                     81.0 73 1 3 0   0     0   4   41 40                 81
1374190 1374190 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_7 3 15 57 0   0     0   0   35 40 *                     75.0 3 15 57 0   0     0   0   35 40                 75
1374218 1374218 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_7 2 40 34 0   0     0   1   39 38 *                     77.0 2 40 34 0   0     0   1   39 38                 77
1374253 1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1374268 1374268 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_7 36 9 21 0   0     0   1   33 34 *                     67.0 36 9 21 0   0     0   1   33 34                 67
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1365281 1365281 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_7 2 3 8 0   1     0   1   12 3 *                     15.0 2 3 8 0   1     0   1   12 3                 15
1365339 1365339 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 20 64 0   1     0   3   42 49 *                     91.0 3 20 64 0   1     0   3   42 49                 91
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1365444 1365444 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_7 1 19 21 0   1     0   2   24 20 *                     44.0 1 19 21 0   1     0   2   24 20                 44
1365611 1365611 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_7 1 10 27 0   1     0   0   10 29 *                     39.0 1 10 27 0   1     0   0   10 29                 39
1365781 1365781 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_7 2 14 12 0   1     0   0   21 8 *                     29.0 2 14 12 0   1     0   0   21 8                 29
1365803 1365803 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_7 1 15 9 0   1     2   0   20 8 *                     28.0 1 15 9 0   1     2   0   20 8                 28
1366018 1366018 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_7 7 1 142 1   1     0   1   75 78 *                     153.0 7 1 142 1   1     0   1   75 78                 153
1366699 1366699 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_7 92 7 36 0   1     1   3   83 57 *                     140.0 92 7 36 0   1     1   3   83 57                 140
1366714 1366714 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_7 108 3 0 0   1     0   4   70 46 *                     116.0 108 3 0 0   1     0   4   70 46                 116
1367017 1367017 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_7 25 1 7 2   1     0   2   20 18 *                     38.0 25 1 7 2   1     0   2   20 18                 38
1367507 1367507 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_7 173 2 21 3   1     0   2   86 116 *                     202.0 173 2 21 3   1     0   2   86 116                 202
1367804 1367804 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_7 19 2 23 0   1     0   0   25 20 *                     45.0 19 2 23 0   1     0   0   25 20                 45
1367981 1367981 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_7 4 0 78 0   1     0   0   40 43 *                     83.0 4 0 78 0   1     0   0   40 43                 83
1368006 1368006 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_7 12 3 140 0   1     0   0   71 83 *                     156.0 12 3 140 0   1     0   0   71 83                 156
1368038 1368038 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_7 6 1 65 0   1     0   1   36 38 *                     74.0 6 1 65 0   1     0   1   36 38                 74
1368230 1368230 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_7 26 6 7 0   1     0   4   19 25 *                     44.0 26 6 7 0   1     0   4   19 25                 44
1369514 1369514 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_7 103 2 8 0   1     1   10   60 65 *                     125.0 103 2 8 0   1     1   10   60 65                 125
1370258 1370258 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_7 119 2 3 0   1     0   3   71 57 *                     128.0 119 2 3 0   1     0   3   71 57                 128
1370359 1370359 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_7 133 12 35 0   1     0   11   102 90 *                     192.0 133 12 35 0   1     0   11   102 90                 192
1370518 1370518 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_7 210 8 5 0   1     0   2   116 110 *                     226.0 210 8 5 0   1     0   2   116 110                 226
1371023 1371023 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_7 5 11 115 0   1     0   0   73 59 *                     132.0 5 11 115 0   1     0   0   73 59                 132
1371200 1371200 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_7 111 1 3 0   1     0   6   59 63 *                     122.0 111 1 3 0   1     0   6   59 63                 122
1371533 1371533 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_7 123 10 7 2   1     0   14   84 73 *                     157.0 123 10 7 2   1     0   14   84 73                 157
1371700 1371700 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2020   grade_7 57 1 12 0   1     0   5   30 46 *                     76.0 57 1 12 0   1     0   5   30 46                 76
1371714 1371714 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_7 91 6 5 0   1     0   4   47 60 *                     107.0 91 6 5 0   1     0   4   47 60                 107
1371829 1371829 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_7 108 1 5 0   1     0   8   77 46 *                     123.0 108 1 5 0   1     0   8   77 46                 123
1372062 1372062 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2020   grade_7 124 3 26 0   1     0   1   69 86 *                     155.0 124 3 26 0   1     0   1   69 86                 155
1372490 1372490 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_7 2 65 24 0   1     0   5   52 45 *                     97.0 2 65 24 0   1     0   5   52 45                 97
1372575 1372575 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2020   grade_7 1 0 34 0   1     0   0   16 20 *                     36.0 1 0 34 0   1     0   0   16 20                 36
1372654 1372654 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_7 7 39 21 1   1     0   1   42 28 *                     70.0 7 39 21 1   1     0   1   42 28                 70
1372666 1372666 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_7 21 61 32 0   1     0   0   56 59 *                     115.0 21 61 32 0   1     0   0   56 59                 115
1372722 1372722 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2020   grade_7 1 0 71 0   1     0   2   39 36 *                     75.0 1 0 71 0   1     0   2   39 36                 75
1372741 1372741 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2020   grade_7 20 2 10 0   1     0   0   10 23 *                     33.0 20 2 10 0   1     0   0   10 23                 33
1372793 1372793 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_7 1 44 41 0   1     0   3   34 56 *                     90.0 1 44 41 0   1     0   3   34 56                 90
1372812 1372812 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2020   grade_7 50 2 13 0   1     0   1   40 27 *                     67.0 50 2 13 0   1     0   1   40 27                 67
1372824 1372824 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2020   grade_7 37 5 17 0   1     1   8   17 52 *                     69.0 37 5 17 0   1     1   8   17 52                 69
1372852 1372852 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2020   grade_7 72 3 6 1   1     0   8   58 33 *                     91.0 72 3 6 1   1     0   8   58 33                 91
1372860 1372860 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_7 0 134 98 0   1     0   1   119 115 *                     234.0 0 134 98 0   1     0   1   119 115                 234
1372950 1372950 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_7 35 9 40 1   1     0   3   42 47 *                     89.0 35 9 40 1   1     0   3   42 47                 89
1373038 1373038 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_7 84 5 2 0   1     0   2   48 46 *                     94.0 84 5 2 0   1     0   2   48 46                 94
1373065 1373065 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_7 175 1 7 0   1     0   6   97 93 *                     190.0 175 1 7 0   1     0   6   97 93                 190
1373108 1373108 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_7 113 3 19 1   1     0   4   78 63 *                     141.0 113 3 19 1   1     0   4   78 63                 141
1373306 1373306 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_7 113 2 8 1   1     0   1   62 64 *                     126.0 113 2 8 1   1     0   1   62 64                 126
1373472 1373472 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2020   grade_7 105 1 11 0   1     0   3   63 58 *                     121.0 105 1 11 0   1     0   3   63 58                 121
1373671 1373671 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2020   grade_7 65 1 8 0   1     0   2   37 40 *                     77.0 65 1 8 0   1     0   2   37 40                 77
1373755 1373755 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2020   grade_7 186 2 10 0   1     0   5   101 103 *                     204.0 186 2 10 0   1     0   5   101 103                 204
1373832 1373832 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2020   grade_7 242 4 10 1   1     0   4   133 129 *                     262.0 242 4 10 1   1     0   4   133 129                 262
1373873 1373873 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_7 112 1 4 0   1     0   2   57 63 *                     120.0 112 1 4 0   1     0   2   57 63                 120
1373894 1373894 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_7 90 3 12 1   1     0   5   55 57 *                     112.0 90 3 12 1   1     0   5   55 57                 112
1373900 1373900 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2020   grade_7 261 3 16 1   1     1   10   154 139 *                     293.0 261 3 16 1   1     1   10   154 139                 293
1374259 1374259 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_7 1 15 72 0   1     0   1   44 46 *                     90.0 1 15 72 0   1     0   1   44 46                 90
1365482 1365482 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_7 20 28 32 0   2     0   1   42 41 *                     83.0 20 28 32 0   2     0   1   42 41                 83
1365580 1365580 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_7 10 1 11 0   2     0   1   12 13 *                     25.0 10 1 11 0   2     0   1   12 13                 25
1365652 1365652 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_7 6 5 5 0   2     0   2   9 11 *                     20.0 6 5 5 0   2     0   2   9 11                 20
1365750 1365750 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_7 6 8 20 0   2     0   2   22 16 *                     38.0 6 8 20 0   2     0   2   22 16                 38
1365891 1365891 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_7 15 21 91 0   2     0   0   66 63 *                     129.0 15 21 91 0   2     0   0   66 63                 129
1365897 1365897 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_7 1 43 58 0   2     0   0   55 49 *                     104.0 1 43 58 0   2     0   0   55 49                 104
1366021 1366021 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_7 7 67 35 0   2     0   5   58 58 *                     116.0 7 67 35 0   2     0   5   58 58                 116
1366065 1366065 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_7 140 3 12 3   2     0   6   94 72 *                     166.0 140 3 12 3   2     0   6   94 72                 166
1366181 1366181 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_7 16 84 19 1   2     0   7   65 64 *                     129.0 16 84 19 1   2     0   7   65 64                 129
1366596 1366596 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_7 10 6 147 1   2     0   2   96 72 *                     168.0 10 6 147 1   2     0   2   96 72                 168
1366812 1366812 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_7 274 3 11 0   2     1   16   173 134 *                     307.0 274 3 11 0   2     1   16   173 134                 307
1366864 1366864 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_7 96 1 4 0   2     0   2   47 58 *                     105.0 96 1 4 0   2     0   2   47 58                 105
1367383 1367383 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_7 67 21 101 0   2     0   5   115 81 *                     196.0 67 21 101 0   2     0   5   115 81                 196
1367469 1367469 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_7 84 0 1 0   2     1   0   41 47 *                     88.0 84 0 1 0   2     1   0   41 47                 88
1367568 1367568 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_7 88 2 21 0   2     0   5   59 59 *                     118.0 88 2 21 0   2     0   5   59 59                 118
1367702 1367702 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_7 108 6 33 0   2     0   0   77 72 *                     149.0 108 6 33 0   2     0   0   77 72                 149
1367840 1367840 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_7 11 1 49 0   2     0   0   33 30 *                     63.0 11 1 49 0   2     0   0   33 30                 63
1367859 1367859 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_7 9 6 79 0   2     0   2   52 46 *                     98.0 9 6 79 0   2     0   2   52 46                 98
1367913 1367913 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_7 159 6 25 0   2     0   11   105 98 *                     203.0 159 6 25 0   2     0   11   105 98                 203
1368041 1368041 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_7 3 3 147 0   2     0   3   90 68 *                     158.0 3 3 147 0   2     0   3   90 68                 158
1368106 1368106 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_7 50 0 6 0   2     0   4   34 28 *                     62.0 50 0 6 0   2     0   4   34 28                 62
1368311 1368311 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2020   grade_7 22 6 22 0   2     0   3   23 32 *                     55.0 22 6 22 0   2     0   3   23 32                 55
1368713 1368713 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2020   grade_7 233 6 14 0   2     0   5   139 121 *                     260.0 233 6 14 0   2     0   5   139 121                 260
1368821 1368821 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_7 74 3 13 0   2     0   2   55 38 *                     94.0 74 3 13 0   2     0   2   55 38                 94
1368946 1368946 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_7 95 3 28 0   2     0   8   70 66 *                     136.0 95 3 28 0   2     0   8   70 66                 136
1369100 1369100 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_7 56 0 1 0   2     0   1   30 30 *                     60.0 56 0 1 0   2     0   1   30 30                 60
1369332 1369332 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_7 174 44 162 3   2     0   27   212 200 *                     412.0 174 44 162 3   2     0   27   212 200                 412
1369363 1369363 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2020   grade_7 154 3 6 0   2     0   7   89 83 *                     172.0 154 3 6 0   2     0   7   89 83                 172
1369662 1369662 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2020   grade_7 120 2 18 0   2     0   12   70 84 *                     154.0 120 2 18 0   2     0   12   70 84                 154
1369821 1369821 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2020   grade_7 112 2 23 0   2     0   9   77 71 *                     148.0 112 2 23 0   2     0   9   77 71                 148

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