enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 399 ✖

grade ✖

  • grade_7 · 399 ✖
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
2045405 2045405 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_7 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2045554 2045554 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_7 130 10 54 1   12     0   1   106 102                       208.0 130 10 54 1   12     0   1   106 102                 208
2045713 2045713 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_7 197 0 9 0   0     0   1   106 101                       207.0 197 0 9 0   0     0   1   106 101                 207
2045731 2045731 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_7 18 7 17 0   3     0   1   17 29                       46.0 18 7 17 0   3     0   1   17 29                 46
2045769 2045769 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2019   grade_7 18 4 6 0   1     0   1   16 14                       30.0 18 4 6 0   1     0   1   16 14                 30
2045779 2045779 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_7 12 13 31 0   5     0   1   34 28                       62.0 12 13 31 0   5     0   1   34 28                 62
2045823 2045823 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2019   grade_7 71 3 84 1   4     0   1   88 76                       164.0 71 3 84 1   4     0   1   88 76                 164
2045960 2045960 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_7 6 12 16 0   0     0   1   15 20                       35.0 6 12 16 0   0     0   1   15 20                 35
2046084 2046084 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2019   grade_7 25 45 135 0   7     0   1   123 90                       213.0 25 45 135 0   7     0   1   123 90                 213
2046093 2046093 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_7 1 8 75 0   0     0   1   41 44                       85.0 1 8 75 0   0     0   1   41 44                 85
2046104 2046104 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2019   grade_7 17 20 72 1   2     0   1   51 62                       113.0 17 20 72 1   2     0   1   51 62                 113
2046114 2046114 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_7 11 11 69 0   0     0   1   48 44                       92.0 11 11 69 0   0     0   1   48 44                 92
2046321 2046321 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2019   grade_7 186 3 5 0   1     0   1   105 91                       196.0 186 3 5 0   1     0   1   105 91                 196
2046522 2046522 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_7 137 8 13 1   9     0   1   91 78                       169.0 137 8 13 1   9     0   1   91 78                 169
2046774 2046774 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2019   grade_7 58 2 7 0   2     0   1   38 32                       70.0 58 2 7 0   2     0   1   38 32                 70
2047445 2047445 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2019   grade_7 7 7 24 0   5     0   1   22 22                       44.0 7 7 24 0   5     0   1   22 22                 44
2047543 2047543 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_7 5 43 25 0   1     0   1   34 41                       75.0 5 43 25 0   1     0   1   34 41                 75
2047577 2047577 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_7 0 16 7 0   0     0   1   12 12                       24.0 0 16 7 0   0     0   1   12 12                 24
2047627 2047627 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_7 4 20 96 0   1     0   1   60 62                       122.0 4 20 96 0   1     0   1   60 62                 122
2047661 2047661 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2019   grade_7 3 38 11 0   3     0   1   23 33                       56.0 3 38 11 0   3     0   1   23 33                 56
2047737 2047737 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 2019   grade_7 29 63 17 0   3     1   1   57 57                       114.0 29 63 17 0   3     1   1   57 57                 114
2047835 2047835 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2019   grade_7 0 44 14 0   0     0   1   26 33                       59.0 0 44 14 0   0     0   1   26 33                 59
2047865 2047865 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_7 1 29 61 0   0     0   1   44 48                       92.0 1 29 61 0   0     0   1   44 48                 92
2047939 2047939 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2019   grade_7 31 8 33 0   3     0   1   37 39                       76.0 31 8 33 0   3     0   1   37 39                 76
2047952 2047952 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 35 32 0   0     0   1   43 31                       74.0 6 35 32 0   0     0   1   43 31                 74
2048110 2048110 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_7 87 2 0 1   0     0   1   44 47                       91.0 87 2 0 1   0     0   1   44 47                 91
2048436 2048436 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2019   grade_7 60 2 1 0   0     0   1   31 33                       64.0 60 2 1 0   0     0   1   31 33                 64
2048518 2048518 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_7 14 1 2 0   0     0   1   8 10                       18.0 14 1 2 0   0     0   1   8 10                 18
2048649 2048649 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   grade_7 116 3 1 0   1     0   1   50 72                       122.0 116 3 1 0   1     0   1   50 72                 122
2048680 2048680 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2019   grade_7 62 0 4 0   1     0   1   33 35                       68.0 62 0 4 0   1     0   1   33 35                 68
2049138 2049138 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_7 115 2 4 0   2     0   1   66 58                       124.0 115 2 4 0   2     0   1   66 58                 124
2049293 2049293 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 2019   grade_7 0 37 36 0   2     1   1   36 41                       77.0 0 37 36 0   2     1   1   36 41                 77
2049338 2049338 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 09 2019   grade_7 35 5 13 1   1     0   1   31 25                       56.0 35 5 13 1   1     0   1   31 25                 56
2040217 2040217 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 3 0   0     0   2   44 48                       92.0 86 1 3 0   0     0   2   44 48                 92
2040324 2040324 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_7 3 3 8 0   2     0   2   9 9                       18.0 3 3 8 0   2     0   2   9 9                 18
2040525 2040525 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_7 9 32 34 0   5     0   2   50 32                       82.0 9 32 34 0   5     0   2   50 32                 82
2040606 2040606 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_7 2 30 19 0   3     0   2   34 22                       56.0 2 30 19 0   3     0   2   34 22                 56
2040705 2040705 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_7 2 41 38 1   2     0   2   43 43                       86.0 2 41 38 1   2     0   2   43 43                 86
2040721 2040721 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_7 4 11 18 0   0     0   2   22 13                       35.0 4 11 18 0   0     0   2   22 13                 35
2040793 2040793 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_7 2 6 26 0   0     0   2   19 17                       36.0 2 6 26 0   0     0   2   19 17                 36
2040910 2040910 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_7 0 6 10 0   0     0   2   11 7                       18.0 0 6 10 0   0     0   2   11 7                 18
2040941 2040941 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_7 1 41 54 0   0     0   2   42 56                       98.0 1 41 54 0   0     0   2   42 56                 98
2041465 2041465 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_7 13 0 21 0   1     0   2   11 26                       37.0 13 0 21 0   1     0   2   11 26                 37
2041629 2041629 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2019   grade_7 121 4 16 0   28     0   2   81 90                       171.0 121 4 16 0   28     0   2   81 90                 171
2041759 2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2042033 2042033 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_7 77 0 11 0   6     0   2   43 53                       96.0 77 0 11 0   6     0   2   43 53                 96
2042108 2042108 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_7 10 5 35 1   4     0   2   31 26                       57.0 10 5 35 1   4     0   2   31 26                 57
2042124 2042124 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_7 41 10 50 2   7     1   2   57 56                       113.0 41 10 50 2   7     1   2   57 56                 113
2042278 2042278 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_7 9 1 5 0   0     0   2   7 10                       17.0 9 1 5 0   0     0   2   7 10                 17
2042348 2042348 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   grade_7 21 3 33 0   3     0   2   34 28                       62.0 21 3 33 0   3     0   2   34 28                 62
2042703 2042703 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_7 64 0 4 0   10     0   2   44 36                       80.0 64 0 4 0   10     0   2   44 36                 80
2042993 2042993 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2019   grade_7 179 0 24 0   7     0   2   98 114                       212.0 179 0 24 0   7     0   2   98 114                 212
2043007 2043007 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_7 59 1 0 0   1     0   2   31 32                       63.0 59 1 0 0   1     0   2   31 32                 63
2043090 2043090 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_7 7 0 129 0   0     0   2   60 78                       138.0 7 0 129 0   0     0   2   60 78                 138
2043190 2043190 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_7 55 0 8 0   2     0   2   37 30                       67.0 55 0 8 0   2     0   2   37 30                 67
2043394 2043394 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_7 25 2 26 0   5     0   2   31 29                       60.0 25 2 26 0   5     0   2   31 29                 60
2043464 2043464 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_7 10 5 14 0   22     0   2   23 30                       53.0 10 5 14 0   22     0   2   23 30                 53
2043745 2043745 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   grade_7 31 27 46 0   25     0   2   60 71                       131.0 31 27 46 0   25     0   2   60 71                 131
2044191 2044191 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2019   grade_7 65 17 35 0   3     0   2   58 64                       122.0 65 17 35 0   3     0   2   58 64                 122
2044866 2044866 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_7 32 3 8 2   0     0   2   18 29                       47.0 32 3 8 2   0     0   2   18 29                 47
2045256 2045256 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2019   grade_7 25 7 7 0   28     0   2   36 33                       69.0 25 7 7 0   28     0   2   36 33                 69
2045521 2045521 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_7 215 0 2 0   2     0   2   102 118                       221.0 215 0 2 0   2     0   2   102 118                 221
2046078 2046078 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2019   grade_7 9 48 168 0   20     0   2   124 123                       247.0 9 48 168 0   20     0   2   124 123                 247
2046090 2046090 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_7 13 11 68 0   4     0   2   54 44                       98.0 13 11 68 0   4     0   2   54 44                 98
2046098 2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101
2046300 2046300 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2019   grade_7 137 9 21 0   4     0   2   84 89                       173.0 137 9 21 0   4     0   2   84 89                 173
2046396 2046396 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2019   grade_7 243 9 9 0   12     0   2   149 126                       275.0 243 9 9 0   12     0   2   149 126                 275
2046574 2046574 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_7 101 19 47 0   6     0   2   87 88                       175.0 101 19 47 0   6     0   2   87 88                 175
2047079 2047079 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_7 78 1 6 0   0     0   2   42 45                       87.0 78 1 6 0   0     0   2   42 45                 87
2047190 2047190 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_7 130 14 21 0   8     1   2   88 88                       176.0 130 14 21 0   8     1   2   88 88                 176
2047527 2047527 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_7 20 6 142 1   3     1   2   93 82                       175.0 20 6 142 1   3     1   2   93 82                 175
2047812 2047812 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 2019   grade_7 22 3 8 0   0     0   2   13 22                       35.0 22 3 8 0   0     0   2   13 22                 35
2047822 2047822 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2019   grade_7 3 22 30 0   19     0   2   40 36                       76.0 3 22 30 0   19     0   2   40 36                 76
2047884 2047884 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_7 44 6 18 1   3     0   2   43 31                       74.0 44 6 18 1   3     0   2   43 31                 74
2047890 2047890 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2019   grade_7 67 1 0 0   0     0   2   37 33                       70.0 67 1 0 0   0     0   2   37 33                 70
2047920 2047920 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_7 25 1 3 0   2     0   2   11 22                       33.0 25 1 3 0   2     0   2   11 22                 33
2047932 2047932 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_7 1 134 95 1   4     1   2   134 104                       238.0 1 134 95 1   4     1   2   134 104                 238
2047961 2047961 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_7 21 51 8 0   7     0   2   52 37                       89.0 21 51 8 0   7     0   2   52 37                 89
2047991 2047991 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_7 87 5 14 0   2     0   2   53 57                       110.0 87 5 14 0   2     0   2   53 57                 110
2048022 2048022 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_7 35 12 40 1   0     0   2   45 45                       90.0 35 12 40 1   0     0   2   45 45                 90
2048138 2048138 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2019   grade_7 167 2 13 1   1     0   2   94 92                       186.0 167 2 13 1   1     0   2   94 92                 186
2048246 2048246 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_7 120 9 5 0   6     0   2   70 72                       142.0 120 9 5 0   6     0   2   70 72                 142
2048504 2048504 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_7 106 1 7 0   8     1   2   43 82                       125.0 106 1 7 0   8     1   2   43 82                 125
2048575 2048575 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_7 107 0 3 0   1     0   2   59 54                       113.0 107 0 3 0   1     0   2   59 54                 113
2048729 2048729 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   grade_7 53 0 2 0   11     0   2   34 34                       68.0 53 0 2 0   11     0   2   34 34                 68
2048777 2048777 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2019   grade_7 114 3 6 0   3     0   2   75 53                       128.0 114 3 6 0   3     0   2   75 53                 128
2048885 2048885 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_7 170 1 7 0   3     0   2   87 96                       183.0 170 1 7 0   3     0   2   87 96                 183
2048892 2048892 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_7 93 0 6 0   1     0   2   60 42                       102.0 93 0 6 0   1     0   2   60 42                 102
2048931 2048931 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2019   grade_7 42 0 1 0   0     0   2   18 27                       45.0 42 0 1 0   0     0   2   18 27                 45
2049065 2049065 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_7 54 1 5 0   0     0   2   34 28                       62.0 54 1 5 0   0     0   2   34 28                 62
2049087 2049087 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 4 0   1     0   2   43 51                       94.0 86 1 4 0   1     0   2   43 51                 94
2049266 2049266 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_7 6 19 53 0   1     1   2   40 42                       82.0 6 19 53 0   1     1   2   40 42                 82
2049295 2049295 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_7 19 18 16 0   6     0   2   35 26                       61.0 19 18 16 0   6     0   2   35 26                 61
2049331 2049331 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_7 2 10 77 0   0     0   2   55 36                       91.0 2 10 77 0   0     0   2   55 36                 91
2040094 2040094 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_7 29 17 4 1   3     0   3   32 25                       57.0 29 17 4 1   3     0   3   32 25                 57
2040358 2040358 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_7 3 18 19 0   2     0   3   30 15                       45.0 3 18 19 0   2     0   3   30 15                 45
2040443 2040443 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_7 2 13 10 0   0     0   3   13 15                       28.0 2 13 10 0   0     0   3   13 15                 28
2040873 2040873 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_7 0 22 16 0   0     0   3   17 24                       41.0 0 22 16 0   0     0   3   17 24                 41
2040890 2040890 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_7 3 62 23 2   0     0   3   47 46                       93.0 3 62 23 2   0     0   3   47 46                 93
2040935 2040935 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_7 7 18 67 0   13     0   3   64 44                       108.0 7 18 67 0   13     0   3   64 44                 108

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