enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2015 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
736957 736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
738475 738475 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_6 * * * *   *     *   *   2 *                       3                         2                   3
738603 738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
739319 739319 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
740285 740285 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
741675 741675 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_6 * * * *   *     *   *   2 *                       2                         2                   2
736505 736505 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_6 0 7 34 0   1     0   0   24 18                       42 0 7 34 0   1     0   0   24 18                 42
736636 736636 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_6 0 12 30 0   0     0   0   21 21                       42 0 12 30 0   0     0   0   21 21                 42
736734 736734 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_6 0 15 9 0   2     0   0   13 13                       26 0 15 9 0   2     0   0   13 13                 26
738912 738912 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_6 0 3 135 0   0     0   0   76 62                       138 0 3 135 0   0     0   0   76 62                 138
738972 738972 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_6 0 1 99 0   0     0   0   55 45                       100 0 1 99 0   0     0   0   55 45                 100
743466 743466 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_6 0 55 12 0   0     1   1   36 33                       69 0 55 12 0   0     1   1   36 33                 69
743475 743475 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_6 0 29 9 0   0     0   0   16 22                       38 0 29 9 0   0     0   0   16 22                 38
743495 743495 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_6 0 39 9 0   1     0   4   24 29                       53 0 39 9 0   1     0   4   24 29                 53
743707 743707 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 2 05 07 2015   grade_6 0 49 22 0   0     0   1   41 31                       72 0 49 22 0   0     0   1   41 31                 72
743767 743767 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_6 0 19 8 0   0     2   0   18 11                       29 0 19 8 0   0     2   0   18 11                 29
745163 745163 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 06 2015   grade_6 0 28 20 0   0     0   2   26 24                       50 0 28 20 0   0     0   2   26 24                 50
736555 736555 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_6 1 31 43 0   1     0   1   41 36                       77 1 31 43 0   1     0   1   41 36                 77
736699 736699 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_6 1 34 16 0   0     0   0   22 29                       51 1 34 16 0   0     0   0   22 29                 51
736724 736724 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_6 1 20 13 0   1     0   5   20 20                       40 1 20 13 0   1     0   5   20 20                 40
736740 736740 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_6 1 77 26 1   5     0   0   57 53                       110 1 77 26 1   5     0   0   57 53                 110
736763 736763 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_6 1 76 57 1   10     0   2   85 62                       147 1 76 57 1   10     0   2   85 62                 147
738725 738725 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_6 1 2 40 0   0     0   0   21 22                       43 1 2 40 0   0     0   0   21 22                 43
738907 738907 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_6 1 1 88 0   3     0   0   53 40                       93 1 1 88 0   3     0   0   53 40                 93
738947 738947 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_6 1 1 102 0   1     0   0   52 53                       105 1 1 102 0   1     0   0   52 53                 105
739014 739014 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_6 1 0 19 0   0     0   0   16 4                       20 1 0 19 0   0     0   0   16 4                 20
741971 741971 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2015   grade_6 1 6 9 0   0     0   0   13 3                       16 1 6 9 0   0     0   0   13 3                 16
741977 741977 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2015   grade_6 1 14 79 0   2     0   1   53 44                       97 1 14 79 0   2     0   1   53 44                 97
741980 741980 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2015   grade_6 1 0 5 0   0     0   0   4 2                       6 1 0 5 0   0     0   0   4 2                 6
743545 743545 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_6 1 18 2 0   0     0   0   7 14                       21 1 18 2 0   0     0   0   7 14                 21
743589 743589 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   grade_6 1 23 12 0   0     0   2   19 19                       38 1 23 12 0   0     0   2   19 19                 38
743673 743673 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_6 1 0 55 0   0     0   0   26 30                       56 1 0 55 0   0     0   0   26 30                 56
743798 743798 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_6 1 58 29 0   2     0   6   44 52                       96 1 58 29 0   2     0   6   44 52                 96
743817 743817 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_6 1 135 100 1   2     2   3   123 121                       244 1 135 100 1   2     2   3   123 121                 244
736180 736180 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2015   grade_6 10 1 4 0   2     0   1   11 7                       18 10 1 4 0   2     0   1   11 7                 18
736230 736230 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   grade_6 10 23 58 1   2     0   3   44 53                       97 10 23 58 1   2     0   3   44 53                 97
737316 737316 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_6 10 2 9 0   0     0   4   7 18                       25 10 2 9 0   0     0   4   7 18                 25
743137 743137 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_6 10 8 22 0   5     0   1   27 19                       46 10 8 22 0   5     0   1   27 19                 46
743260 743260 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_6 10 4 3 0   0     0   1   7 11                       18 10 4 3 0   0     0   1   7 11                 18
744719 744719 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   grade_6 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
739223 739223 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2015   grade_6 100 1 4 1   8     0   2   52 64                       116 100 1 4 1   8     0   2   52 64                 116
737616 737616 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_6 101 9 27 0   2     0   3   72 70                       142 101 9 27 0   2     0   3   72 70                 142
739750 739750 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2015   grade_6 101 2 5 0   2     0   4   54 60                       114 101 2 5 0   2     0   4   54 60                 114
740031 740031 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_6 101 1 0 0   0     0   0   48 54                       102 101 1 0 0   0     0   0   48 54                 102
736990 736990 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_6 102 1 2 0   7     1   1   56 58                       114 102 1 2 0   7     1   1   56 58                 114
740860 740860 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   grade_6 102 3 2 0   0     0   0   56 51                       107 102 3 2 0   0     0   0   56 51                 107
741379 741379 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_6 102 13 64 0   8     0   7   99 95                       194 102 13 64 0   8     0   7   99 95                 194
735798 735798 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_6 104 7 5 0   38     0   4   67 91                       158 104 7 5 0   38     0   4   67 91                 158
739983 739983 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_6 104 0 2 0   6     1   4   78 39                       117 104 0 2 0   6     1   4   78 39                 117
744060 744060 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2015   grade_6 104 7 11 2   6     0   11   70 71                       141 104 7 11 2   6     0   11   70 71                 141
741477 741477 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No 1 KG 06 2015   grade_6 105 4 0 0   2     0   2   57 56                       113 105 4 0 0   2     0   2   57 56                 113
739194 739194 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2015   grade_6 106 1 5 1   9     0   1   51 72                       123 106 1 5 1   9     0   1   51 72                 123
742552 742552 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_6 106 11 29 0   2     1   7   78 78                       156 106 11 29 0   2     1   7   78 78                 156
744216 744216 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2015   grade_6 108 1 4 0   1     0   2   64 52                       116 108 1 4 0   1     0   2   64 52                 116
735984 735984 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_6 109 4 13 0   12     0   7   71 74                       145 109 4 13 0   12     0   7   71 74                 145
740272 740272 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_6 109 31 105 1   0     0   17   124 139                       263 109 31 105 1   0     0   17   124 139                 263
742151 742151 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_6 109 3 0 0   3     0   7   66 56                       122 109 3 0 0   3     0   7   66 56                 122
737149 737149 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_6 11 113 29 0   3     1   6   83 80                       163 11 113 29 0   3     1   6   83 80                 163
738715 738715 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_6 11 0 25 1   1     0   1   23 16                       39 11 0 25 1   1     0   1   23 16                 39
738766 738766 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_6 11 4 59 0   1     0   0   44 31                       75 11 4 59 0   1     0   0   44 31                 75
743215 743215 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   grade_6 11 4 15 0   3     0   2   21 14                       35 11 4 15 0   3     0   2   21 14                 35
743297 743297 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_6 11 9 16 0   1     0   4   23 18                       41 11 9 16 0   1     0   4   23 18                 41
743499 743499 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_6 11 22 80 0   5     0   3   52 69                       121 11 22 80 0   5     0   3   52 69                 121
738589 738589 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_6 110 6 20 0   3     0   0   71 68                       139 110 6 20 0   3     0   0   71 68                 139
739387 739387 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_6 111 0 4 2   0     0   1   71 47                       118 111 0 4 2   0     0   1   71 47                 118
738108 738108 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_6 112 13 30 0   6     1   13   98 77                       175 112 13 30 0   6     1   13   98 77                 175
742310 742310 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2015   grade_6 112 2 3 1   4     0   6   56 72                       128 112 2 3 1   4     0   6   56 72                 128
744637 744637 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2015   grade_6 112 1 3 0   2     0   6   61 63                       124 112 1 3 0   2     0   6   61 63                 124
735680 735680 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_6 113 1 1 0   1     0   0   55 61                       116 113 1 1 0   1     0   0   55 61                 116
738380 738380 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_6 113 0 0 0   2     0   1   62 54                       116 113 0 0 0   2     0   1   62 54                 116
739877 739877 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_6 113 4 29 0   5     0   2   76 77                       153 113 4 29 0   5     0   2   76 77                 153
739942 739942 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2015   grade_6 114 1 6 0   6     0   1   66 62                       128 114 1 6 0   6     0   1   66 62                 128
738105 738105 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_6 115 8 48 0   15     0   6   88 104                       192 115 8 48 0   15     0   6   88 104                 192
738287 738287 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_6 115 12 39 0   2     0   6   89 85                       174 115 12 39 0   2     0   6   89 85                 174
744507 744507 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2015   grade_6 117 7 5 1   0     0   5   60 75                       135 117 7 5 1   0     0   5   60 75                 135
740779 740779 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2015   grade_6 118 2 2 0   1     0   0   69 54                       123 118 2 2 0   1     0   0   69 54                 123
744963 744963 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2015   grade_6 118 3 6 0   3     0   3   71 62                       133 118 3 6 0   3     0   3   71 62                 133
742398 742398 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2015   grade_6 119 5 4 0   9     0   4   66 75                       141 119 5 4 0   9     0   4   66 75                 141
736289 736289 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   grade_6 12 12 17 0   0     0   3   24 20                       44 12 12 17 0   0     0   3   24 20                 44
736337 736337 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_6 12 15 20 0   0     0   0   24 23                       47 12 15 20 0   0     0   0   24 23                 47
736880 736880 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_6 12 17 18 0   77     1   6   75 56                       131 12 17 18 0   77     1   6   75 56                 131
737948 737948 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   1   6 8                       14 12 0 1 0   0     0   1   6 8                 14
738933 738933 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_6 12 1 94 0   1     0   1   60 49                       109 12 1 94 0   1     0   1   60 49                 109
738970 738970 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 05 07 2015   grade_6 12 1 133 0   6     0   0   64 88                       152 12 1 133 0   6     0   0   64 88                 152
743168 743168 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_6 12 2 20 0   1     0   2   17 20                       37 12 2 20 0   1     0   2   17 20                 37
743720 743720 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_6 12 1 1 0   2     0   1   11 6                       17 12 1 1 0   2     0   1   11 6                 17
744529 744529 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2015   grade_6 12 0 0 0   0     0   2   9 5                       14 12 0 0 0   0     0   2   9 5                 14
744544 744544 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   0   8 5                       13 12 0 1 0   0     0   0   8 5                 13
744820 744820 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_6 12 0 1 0   0     1   1   7 8                       15 12 0 1 0   0     1   1   7 8                 15
740406 740406 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No 2 06 08 2015   grade_6 121 11 14 0   49     0   14   98 111                       209 121 11 14 0   49     0   14   98 111                 209
741117 741117 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_6 121 6 6 0   90     1   6   117 113                       230 121 6 6 0   90     1   6   117 113                 230
742107 742107 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_6 121 0 7 0   1     0   2   63 68                       131 121 0 7 0   1     0   2   63 68                 131
745019 745019 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2015   grade_6 121 2 1 0   2     0   4   70 60                       130 121 2 1 0   2     0   4   70 60                 130
741702 741702 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2015   grade_6 122 0 5 0   21     1   4   81 72                       153 122 0 5 0   21     1   4   81 72                 153
741731 741731 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_6 122 4 11 0   1     0   5   70 73                       143 122 4 11 0   1     0   5   70 73                 143
740422 740422 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_6 123 3 0 0   0     0   9   71 64                       135 123 3 0 0   0     0   9   71 64                 135
740942 740942 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2015   grade_6 123 19 26 0   0     0   13   87 94                       181 123 19 26 0   0     0   13   87 94                 181
744383 744383 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2015   grade_6 123 3 2 0   7     0   4   72 67                       139 123 3 2 0   7     0   4   72 67                 139
738025 738025 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_6 124 2 8 2   5     0   2   77 66                       143 124 2 8 2   5     0   2   77 66                 143
742792 742792 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_6 124 1 2 3   1     0   3   80 54                       134 124 1 2 3   1     0   3   80 54                 134

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