enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1122005 1122005 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1122638 1122638 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_7 * * * *   *     *   *   1 2                       *                         1 2                  
1123668 1123668 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_7 * * * *   *     *   *   4 1                       *                         4 1                  
1124658 1124658 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_7 * * * *   *     *   *   2 2                       *                         2 2                  
1125193 1125193 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125267 1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1129009 1129009 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_7 * * * *   *     *   *   3 *                       *                         3                    
1131924 1131924 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_7 * * * *   *     *   *   1 *                       *                         1                    
1122686 1122686 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_7 0 40 12 0   0     0   0   24 28                       52 0 40 12 0   0     0   0   24 28                 52
1122802 1122802 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_7 0 13 35 0   2     0   0   25 25                       50 0 13 35 0   2     0   0   25 25                 50
1122946 1122946 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_7 0 8 19 0   0     0   1   15 13                       28 0 8 19 0   0     0   1   15 13                 28
1123002 1123002 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_7 0 43 44 1   0     0   4   42 50                       92 0 43 44 1   0     0   4   42 50                 92
1123092 1123092 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_7 0 8 14 0   0     0   0   8 14                       22 0 8 14 0   0     0   0   8 14                 22
1123161 1123161 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_7 0 15 11 0   0     1   1   17 11                       28 0 15 11 0   0     1   1   17 11                 28
1123200 1123200 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_7 0 18 24 1   0     0   4   25 22                       47 0 18 24 1   0     0   4   25 22                 47
1123267 1123267 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2017   grade_7 0 41 68 0   1     1   6   66 51                       117 0 41 68 0   1     1   6   66 51                 117
1123368 1123368 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_7 0 12 17 1   40     0   1   38 33                       71 0 12 17 1   40     0   1   38 33                 71
1131170 1131170 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 Middle 06 08 2017   grade_7 0 71 6 0   0     0   0   39 38                       77 0 71 6 0   0     0   0   39 38                 77
1131272 1131272 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_7 0 15 4 0   0     0   1   8 12                       20 0 15 4 0   0     0   1   8 12                 20
1131406 1131406 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_7 0 1 51 0   0     0   0   19 33                       52 0 1 51 0   0     0   0   19 33                 52
1131440 1131440 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2017   grade_7 0 44 24 0   0     0   1   37 32                       69 0 44 24 0   0     0   1   37 32                 69
1131557 1131557 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_7 0 125 117 0   2     0   2   117 129                       246 0 125 117 0   2     0   2   117 129                 246
1133144 1133144 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 2017   grade_7 0 45 26 2   0     0   0   28 45                       73 0 45 26 2   0     0   0   28 45                 73
1122597 1122597 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_7 1 10 20 0   1     0   3   25 10                       35 1 10 20 0   1     0   3   25 10                 35
1122712 1122712 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_7 1 2 72 0   0     0   1   33 43                       76 1 2 72 0   0     0   1   33 43                 76
1122873 1122873 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_7 1 0 18 0   0     0   0   10 9                       19 1 0 18 0   0     0   0   10 9                 19
1122884 1122884 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_7 1 42 14 0   3     0   0   33 27                       60 1 42 14 0   3     0   0   33 27                 60
1123138 1123138 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_7 1 11 14 0   0     0   4   23 7                       30 1 11 14 0   0     0   4   23 7                 30
1123191 1123191 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_7 1 14 4 0   0     0   0   10 9                       19 1 14 4 0   0     0   0   10 9                 19
1123210 1123210 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_7 1 62 19 2   2     0   0   49 37                       86 1 62 19 2   2     0   0   49 37                 86
1123221 1123221 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_7 1 25 23 0   0     0   1   31 19                       50 1 25 23 0   0     0   1   31 19                 50
1123439 1123439 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_7 1 0 25 0   0     0   0   9 17                       26 1 0 25 0   0     0   0   9 17                 26
1123448 1123448 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_7 1 2 3 0   1     0   0   4 3                       7 1 2 3 0   1     0   0   4 3                 7
1124106 1124106 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_7 1 2 117 0   2     0   1   65 58                       123 1 2 117 0   2     0   1   65 58                 123
1124147 1124147 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_7 1 0 9 0   0     0   0   9 1                       10 1 0 9 0   0     0   0   9 1                 10
1124819 1124819 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_7 1 2 2 0   0     0   2   6 *                       7 1 2 2 0   0     0   2   6                   7
1125563 1125563 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_7 1 1 34 0   1     0   0   14 23                       37 1 1 34 0   1     0   0   14 23                 37
1125579 1125579 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_7 1 1 51 0   0     0   0   30 23                       53 1 1 51 0   0     0   0   30 23                 53
1125808 1125808 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_7 1 2 125 0   2     0   0   57 73                       130 1 2 125 0   2     0   0   57 73                 130
1129358 1129358 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2017   grade_7 1 4 11 0   0     0   0   12 4                       16 1 4 11 0   0     0   0   12 4                 16
1129370 1129370 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_7 1 2 8 0   0     0   0   7 4                       11 1 2 8 0   0     0   0   7 4                 11
1131150 1131150 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_7 1 38 20 0   1     0   1   34 27                       61 1 38 20 0   1     0   1   34 27                 61
1122793 1122793 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_7 10 26 20 0   4     0   5   32 33                       65 10 26 20 0   4     0   5   32 33                 65
1122972 1122972 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_7 10 26 14 1   36     1   1   41 48                       89 10 26 14 1   36     1   1   41 48                 89
1124625 1124625 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_7 10 7 33 0   3     0   1   25 29                       54 10 7 33 0   3     0   1   25 29                 54
1128643 1128643 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No Elementary KG 08 2017   grade_7 10 0 33 0   0     0   0   24 19                       43 10 0 33 0   0     0   0   24 19                 43
1129393 1129393 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No Middle 06 08 2017   grade_7 10 16 67 0   3     0   2   52 46                       98 10 16 67 0   3     0   2   52 46                 98
1131456 1131456 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_7 10 2 1 0   0     0   1   5 9                       14 10 2 1 0   0     0   1   5 9                 14
1131587 1131587 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_7 10 59 19 0   5     0   2   40 55                       95 10 59 19 0   5     0   2   40 55                 95
1124538 1124538 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_7 100 1 17 0   4     0   2   57 67                       124 100 1 17 0   4     0   2   57 67                 124
1125406 1125406 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_7 100 6 21 0   2     0   1   64 66                       130 100 6 21 0   2     0   1   64 66                 130
1127973 1127973 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No Middle 06 07 2017   grade_7 102 4 10 0   1     0   2   67 52                       119 102 4 10 0   1     0   2   67 52                 119
1128369 1128369 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_7 102 6 6 0   86     2   5   112 95                       207 102 6 6 0   86     2   5   112 95                 207
1130018 1130018 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2017   grade_7 102 8 24 0   19     0   10   87 76                       163 102 8 24 0   19     0   10   87 76                 163
1132666 1132666 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_7 102 3 3 0   1     0   7   53 63                       116 102 3 3 0   1     0   7   53 63                 116
1127381 1127381 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_7 103 43 109 1   2     1   12   141 130                       271 103 43 109 1   2     1   12   141 130                 271
1131042 1131042 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_7 103 57 181 1   49     0   22   209 204                       413 103 57 181 1   49     0   22   209 204                 413
1131223 1131223 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_7 103 3 9 0   27     0   9   71 80                       151 103 3 9 0   27     0   9   71 80                 151
1131758 1131758 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_7 104 6 1 0   1     0   0   58 54                       112 104 6 1 0   1     0   0   58 54                 112
1131857 1131857 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_7 104 1 10 1   1     0   2   42 77                       119 104 1 10 1   1     0   2   42 77                 119
1126736 1126736 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_7 105 4 4 7   3     1   5   71 58                       129 105 4 4 7   3     1   5   71 58                 129
1130195 1130195 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_7 105 2 5 0   1     0   0   61 52                       113 105 2 5 0   1     0   0   61 52                 113
1131031 1131031 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_7 105 31 120 0   14     0   25   161 134                       295 105 31 120 0   14     0   25   161 134                 295
1129079 1129079 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_7 106 4 18 0   4     0   5   65 72                       137 106 4 18 0   4     0   5   65 72                 137
1132368 1132368 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_7 108 3 13 2   2     1   6   67 68                       135 108 3 13 2   2     1   6   67 68                 135
1132479 1132479 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2017   grade_7 108 1 3 0   2     0   0   49 65                       114 108 1 3 0   2     0   0   49 65                 114
1124027 1124027 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_7 109 2 4 0   1     0   0   70 46                       116 109 2 4 0   1     0   0   70 46                 116
1132897 1132897 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_7 109 1 4 0   1     0   5   67 53                       120 109 1 4 0   1     0   5   67 53                 120
1123410 1123410 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_7 11 7 131 0   6     0   1   81 75                       156 11 7 131 0   6     0   1   81 75                 156
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1127538 1127538 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_7 110 11 12 0   37     0   19   88 101                       189 110 11 12 0   37     0   19   88 101                 189
1130335 1130335 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2017   grade_7 110 13 9 2   28     0   6   76 92                       168 110 13 9 2   28     0   6   76 92                 168
1126137 1126137 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_7 111 1 5 0   6     0   4   68 59                       127 111 1 5 0   6     0   4   68 59                 127
1127956 1127956 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_7 111 4 11 1   1     2   7   60 77                       137 111 4 11 1   1     2   7   60 77                 137
1125131 1125131 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_7 112 1 1 0   2     0   1   66 51                       117 112 1 1 0   2     0   1   66 51                 117
1127030 1127030 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2017   grade_7 112 5 12 0   5     0   6   71 69                       140 112 5 12 0   5     0   6   71 69                 140
1132517 1132517 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_7 112 0 7 0   2     0   4   57 68                       125 112 0 7 0   2     0   4   57 68                 125
1132528 1132528 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_7 112 2 5 0   0     0   3   59 63                       122 112 2 5 0   0     0   3   59 63                 122
1126828 1126828 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2017   grade_7 113 21 15 0   8     0   10   88 79                       167 113 21 15 0   8     0   10   88 79                 167
1124245 1124245 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_7 114 4 3 2   3     0   2   64 64                       128 114 4 3 2   3     0   2   64 64                 128
1130353 1130353 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_7 114 0 3 0   2     0   5   66 58                       124 114 0 3 0   2     0   5   66 58                 124
1124420 1124420 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_7 115 0 3 0   2     1   2   68 55                       123 115 0 3 0   2     1   2   68 55                 123
1129791 1129791 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No Middle 06 08 2017   grade_7 116 0 7 0   3     0   5   67 64                       131 116 0 7 0   3     0   5   67 64                 131
1125021 1125021 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_7 117 12 36 1   6     0   6   93 85                       178 117 12 36 1   6     0   6   93 85                 178
1124799 1124799 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_7 119 14 50 0   7     1   13   123 81                       204 119 14 50 0   7     1   13   123 81                 204
1126339 1126339 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_7 119 3 15 2   2     3   1   76 69                       145 119 3 15 2   2     3   1   76 69                 145
1132737 1132737 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_7 119 3 3 0   0     0   1   62 64                       126 119 3 3 0   0     0   1   62 64                 126
1125813 1125813 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_7 12 5 127 0   0     0   1   82 63                       145 12 5 127 0   0     0   1   82 63                 145
1126262 1126262 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_7 12 7 18 0   22     0   0   30 29                       59 12 7 18 0   22     0   0   30 29                 59
1127526 1127526 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_7 120 10 15 2   26     0   11   90 94                       184 120 10 15 2   26     0   11   90 94                 184
1129582 1129582 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_7 120 0 1 0   1     0   4   61 65                       126 120 0 1 0   1     0   4   61 65                 126
1129042 1129042 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2017   grade_7 122 1 8 0   18     0   8   73 84                       157 122 1 8 0   18     0   8   73 84                 157
1125108 1125108 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_7 123 6 30 1   3     0   18   96 85                       181 123 6 30 1   3     0   18   96 85                 181
1131967 1131967 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_7 123 2 2 0   1     0   6   76 58                       134 123 2 2 0   1     0   6   76 58                 134
1127373 1127373 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_7 124 43 104 2   4     0   19   165 131                       296 124 43 104 2   4     0   19   165 131                 296
1129886 1129886 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2017   grade_7 124 5 6 0   16     0   6   88 69                       157 124 5 6 0   16     0   6   88 69                 157
1129777 1129777 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2017   grade_7 125 4 7 0   7     0   5   75 73                       148 125 4 7 0   7     0   5   75 73                 148
1127169 1127169 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2017   grade_7 126 4 5 0   13     0   7   79 76                       155 126 4 5 0   13     0   7   79 76                 155
1130302 1130302 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_7 126 4 3 1   45     0   7   88 98                       186 126 4 3 1   45     0   7   88 98                 186

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