enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 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
935278 935278 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_6 * * * *   *     *   *   * *                       1                                             1
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
936166 936166 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
938478 938478 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2016   grade_6 * * * *   *     *   *   2 *                       2                         2                   2
938785 938785 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2016   grade_6 * * * *   *     *   *   2 1                       3                         2 1                 3
940209 940209 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
941367 941367 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 1                       3                         2 1                 3
941528 941528 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   4 1                       5                         4 1                 5
941544 941544 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
933374 933374 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_6 0 8 19 0   0     0   1   16 12                       28 0 8 19 0   0     0   1   16 12                 28
933424 933424 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_6 0 45 42 1   1     0   4   44 49                       93 0 45 42 1   1     0   4   44 49                 93
933504 933504 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_6 0 14 16 0   0     0   0   12 18                       30 0 14 16 0   0     0   0   12 18                 30
933566 933566 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_6 0 20 14 0   0     1   3   19 19                       38 0 20 14 0   0     1   3   19 19                 38
933601 933601 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_6 0 24 20 0   0     0   3   25 22                       47 0 24 20 0   0     0   3   25 22                 47
940284 940284 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 2016   grade_6 0 52 6 0   0     0   1   33 26                       59 0 52 6 0   0     0   1   33 26                 59
940367 940367 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_6 0 16 5 0   0     0   1   9 13                       22 0 16 5 0   0     0   1   9 13                 22
940497 940497 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_6 0 1 54 0   0     0   0   20 35                       55 0 1 54 0   0     0   0   20 35                 55
940596 940596 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_6 0 23 15 0   0     0   0   22 16                       38 0 23 15 0   0     0   0   22 16                 38
933147 933147 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_6 1 40 14 0   1     0   0   30 26                       56 1 40 14 0   1     0   0   30 26                 56
933592 933592 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_6 1 19 7 0   0     0   0   14 13                       27 1 19 7 0   0     0   0   14 13                 27
933609 933609 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_6 1 68 28 2   2     0   1   57 45                       102 1 68 28 2   2     0   1   57 45                 102
933619 933619 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_6 1 20 21 0   0     0   0   25 17                       42 1 20 21 0   0     0   0   25 17                 42
933658 933658 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2016   grade_6 1 42 75 0   0     1   6   66 59                       125 1 42 75 0   0     1   6   66 59                 125
933808 933808 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_6 1 0 32 0   0     0   0   12 21                       33 1 0 32 0   0     0   0   12 21                 33
933816 933816 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_6 1 2 3 0   1     0   0   4 3                       7 1 2 3 0   1     0   0   4 3                 7
935571 935571 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_6 1 1 33 0   0     0   0   13 22                       35 1 1 33 0   0     0   0   13 22                 35
935585 935585 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_6 1 1 59 0   0     0   0   39 22                       61 1 1 59 0   0     0   0   39 22                 61
935777 935777 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_6 1 2 134 0   2     0   0   67 72                       139 1 2 134 0   2     0   0   67 72                 139
940268 940268 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_6 1 39 15 0   1     0   1   33 24                       57 1 39 15 0   1     0   1   33 24                 57
940293 940293 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_6 1 32 4 0   1     0   0   20 18                       38 1 32 4 0   1     0   0   20 18                 38
940412 940412 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_6 1 37 8 1   0     0   0   26 21                       47 1 37 8 1   0     0   0   26 21                 47
940535 940535 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   grade_6 1 45 26 0   0     0   1   40 33                       73 1 45 26 0   0     0   1   40 33                 73
940627 940627 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_6 1 50 33 0   3     0   1   43 45                       88 1 50 33 0   3     0   1   43 45                 88
940646 940646 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_6 1 129 115 0   1     0   2   127 121                       248 1 129 115 0   1     0   2   127 121                 248
933083 933083 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_6 10 27 27 0   9     0   2   43 32                       75 10 27 27 0   9     0   2   43 32                 75
933651 933651 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2016   grade_6 10 14 79 0   10     0   2   62 53                       115 10 14 79 0   10     0   2   62 53                 115
935595 935595 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_6 10 2 45 0   0     0   1   25 33                       58 10 2 45 0   0     0   1   25 33                 58
940159 940159 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2016   grade_6 10 14 23 0   1     0   3   25 26                       51 10 14 23 0   1     0   3   25 26                 51
933855 933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109
941394 941394 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_6 100 2 4 0   0     1   1   56 52                       108 100 2 4 0   0     1   1   56 52                 108
935334 935334 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_6 101 3 20 0   3     0   8   69 66                       135 101 3 20 0   3     0   8   69 66                 135
937110 937110 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2016   grade_6 102 37 112 0   2     1   13   133 134                       267 102 37 112 0   2     1   13   133 134                 267
937608 937608 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2016   grade_6 102 3 10 0   1     0   2   68 50                       118 102 3 10 0   1     0   2   68 50                 118
939361 939361 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_6 102 9 33 1   3     1   13   71 91                       162 102 9 33 1   3     1   13   71 91                 162
938535 938535 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2016   grade_6 103 4 17 1   3     0   4   65 67                       132 103 4 17 1   3     0   4   65 67                 132
935438 935438 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_6 104 6 18 0   1     1   1   61 70                       131 104 6 18 0   1     1   1   61 70                 131
935474 935474 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_6 105 5 93 0   4     0   1   100 108                       208 105 5 93 0   4     0   1   100 108                 208
941784 941784 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_6 105 1 4 0   0     0   5   65 50                       115 105 1 4 0   0     0   5   65 50                 115
941428 941428 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_6 106 1 4 0   2     0   0   47 66                       113 106 1 4 0   2     0   0   47 66                 113
936069 936069 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_6 107 1 6 0   7     0   4   67 58                       125 107 1 6 0   7     0   4   67 58                 125
939322 939322 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_6 107 8 17 1   20     0   11   86 78                       164 107 8 17 1   20     0   11   86 78                 164
941646 941646 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_6 107 4 2 0   0     0   2   56 59                       115 107 4 2 0   0     0   2   56 59                 115
934309 934309 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_6 108 2 4 0   1     0   0   69 46                       115 108 2 4 0   1     0   0   69 46                 115
937946 937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
933073 933073 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_6 11 11 24 0   2     0   5   30 23                       53 11 11 24 0   2     0   5   30 23                 53
935965 935965 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_6 11 0 0 0   0     0   4   6 9                       15 11 0 0 0   0     0   4   6 9                 15
939969 939969 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_6 11 8 36 0   1     0   5   35 26                       61 11 8 36 0   1     0   5   35 26                 61
940024 940024 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_6 11 6 8 0   2     0   0   11 16                       27 11 6 8 0   2     0   0   11 16                 27
940143 940143 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_6 11 4 30 0   2     0   7   37 17                       54 11 4 30 0   2     0   7   37 17                 54
940319 940319 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_6 11 33 72 0   2     0   6   60 64                       124 11 33 72 0   2     0   6   60 64                 124
940617 940617 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2016   grade_6 11 83 60 1   11     2   7   93 82                       175 11 83 60 1   11     2   7   93 82                 175
941174 941174 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2016   grade_6 11 0 0 0   0     0   0   1 10                       11 11 0 0 0   0     0   0   1 10                 11
934737 934737 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2016   grade_6 110 2 16 0   5     0   3   66 70                       136 110 2 16 0   5     0   3   66 70                 136
937242 937242 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No 2 06 08 2016   grade_6 110 10 12 0   40     0   20   89 103                       192 110 10 12 0   40     0   20   89 103                 192
941331 941331 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_6 113 2 10 2   3     1   7   71 67                       138 113 2 10 2   3     1   7   71 67                 138
936814 936814 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2016   grade_6 114 3 11 0   5     0   5   67 71                       138 114 3 11 0   5     0   5   67 71                 138
940997 940997 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2016   grade_6 114 2 3 0   1     0   5   69 56                       125 114 2 3 0   1     0   5   69 56                 125
938961 938961 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2016   grade_6 115 0 1 0   1     0   4   58 63                       121 115 0 1 0   1     0   4   58 63                 121
941470 941470 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_6 115 0 5 0   0     0   5   60 65                       125 115 0 5 0   0     0   5   60 65                 125
939119 939119 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2016   grade_6 116 3 5 0   6     0   5   67 68                       135 116 3 5 0   6     0   5   67 68                 135
939598 939598 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_6 116 0 4 0   2     0   5   70 57                       127 116 0 4 0   2     0   5   70 57                 127
937593 937593 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_6 117 2 11 2   1     2   5   58 82                       140 117 2 11 2   1     2   5   58 82                 140
934638 934638 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_6 118 1 3 0   2     1   2   70 57                       127 118 1 3 0   2     1   2   70 57                 127
934958 934958 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_6 118 11 46 0   7     1   10   113 80                       193 118 11 46 0   7     1   10   113 80                 193
935141 935141 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_6 118 13 34 1   4     0   6   91 85                       176 118 13 34 1   4     0   6   91 85                 176
936234 936234 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_6 118 3 12 1   2     3   1   74 66                       140 118 3 12 1   2     3   1   74 66                 140
937233 937233 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_6 118 8 13 2   26     0   12   84 95                       179 118 8 13 2   26     0   12   84 95                 179
938917 938917 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2016   grade_6 119 1 10 0   5     0   10   77 68                       145 119 1 10 0   5     0   10   77 68                 145
939584 939584 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2016   grade_6 119 14 8 2   24     0   7   78 96                       174 119 14 8 2   24     0   7   78 96                 174
935781 935781 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2016   grade_6 12 6 133 0   0     0   1   85 67                       152 12 6 133 0   0     0   1   85 67                 152
938446 938446 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_6 12 2 19 0   6     0   2   21 20                       41 12 2 19 0   6     0   2   21 20                 41
938801 938801 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No 2 06 08 2016   grade_6 12 16 77 0   4     0   2   60 51                       111 12 16 77 0   4     0   2   60 51                 111
940236 940236 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_6 12 11 143 3   2     0   0   83 88                       171 12 11 143 3   2     0   0   83 88                 171
941360 941360 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2016   grade_6 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
932671 932671 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2016   grade_6 120 4 10 0   26     0   4   73 91                       164 120 4 10 0   26     0   4   73 91                 164
935294 935294 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_6 123 0 6 0   23     0   4   73 83                       156 123 0 6 0   23     0   4   73 83                 156
936643 936643 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2016   grade_6 123 22 14 0   8     0   10   92 85                       177 123 22 14 0   8     0   10   92 85                 177
938505 938505 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2016   grade_6 123 1 8 0   20     0   8   75 85                       160 123 1 8 0   20     0   8   75 85                 160
939130 939130 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2016   grade_6 123 0 6 0   3     0   5   68 69                       137 123 0 6 0   3     0   5   68 69                 137
935147 935147 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_6 124 16 80 0   23     0   9   129 123                       252 124 16 80 0   23     0   9   129 123                 252
939556 939556 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2016   grade_6 124 4 4 1   43     0   7   87 96                       183 124 4 4 1   43     0   7   87 96                 183
937257 937257 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2016   grade_6 125 0 3 0   2     0   2   64 68                       132 125 0 3 0   2     0   2   64 68                 132
941461 941461 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_6 125 0 7 0   2     0   4   63 75                       138 125 0 7 0   2     0   4   63 75                 138
941209 941209 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2016   grade_6 126 0 6 0   2     0   0   73 61                       134 126 0 6 0   2     0   0   73 61                 134
941279 941279 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2016   grade_6 126 0 3 0   3     0   1   65 68                       133 126 0 3 0   3     0   1   65 68                 133
936933 936933 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2016   grade_6 127 4 3 0   11     0   7   75 77                       152 127 4 3 0   11     0   7   75 77                 152
940936 940936 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2016   grade_6 127 1 7 0   2     0   5   66 76                       142 127 1 7 0   2     0   5   66 76                 142
934491 934491 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_6 128 4 3 2   3     0   2   77 65                       142 128 4 3 2   3     0   2   77 65                 142
935212 935212 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_6 128 6 29 1   3     0   21   102 86                       188 128 6 29 1   3     0   21   102 86                 188

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