Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2018 sorted by female

View and edit SQL

year

  • 2018 · 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
2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2231643 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2232021 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2233068 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_6 * * * *   *     *   *   4 *                       4.0                         4                   4
2235828 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_6 * * * *   *     *   *   2 *                       2.0                         2                   2
2237227 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2230482 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_6 2 3 0 0   0     0   1   5 1                       6.0 2 3 0 0   0     0   1   5 1                 6
2231475 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2233331 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2236188 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield: Balliet Middle School   Regular School No Middle 06 08 2018   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2239419 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pioneer Valley: Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230035 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_6 1 6 11 0   0     0   1   9 10                       19.0 1 6 11 0   0     0   1   9 10                 19
2231028 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_6 18 0 0 0   0     0   2   10 10                       20.0 18 0 0 0   0     0   2   10 10                 20
2237576 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_6 8 2 10 0   3     0   0   13 10                       23.0 8 2 10 0   3     0   0   13 10                 23
2238770 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   0   6 10                       16.0 16 0 0 0   0     0   0   6 10                 16
2233309 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_6 68 10 106 1   18     0   14   117 100                       217.0 68 10 106 1   18     0   14   117 100                 217
2235316 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere: Rumney Marsh Academy   Regular School No Middle 06 08 2018   grade_6 69 9 111 1   10     0   5   105 100                       205.0 69 9 111 1   10     0   5   105 100                 205
2230229 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_6 16 5 177 0   6     0   1   104 101                       205.0 16 5 177 0   6     0   1   104 101                 205
2234658 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton: Norton Middle   Regular School No Middle 06 08 2018   grade_6 152 3 11 1   5     0   12   83 101                       184.0 152 3 11 1   5     0   12   83 101                 184
2235560 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus: Belmonte Saugus Middle   Regular School No Middle 06 08 2018   grade_6 144 8 51 1   11     0   1   115 101                       216.0 144 8 51 1   11     0   1   115 101                 216
2236501 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton: Joseph H Martin   Regular School No Middle 05 07 2018   grade_6 159 30 21 1   2     0   13   124 102                       226.0 159 30 21 1   2     0   13   124 102                 226
2238744 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_6 215 16 0 0   1     0   16   146 102                       248.0 215 16 0 0   1     0   16   146 102                 248
2238996 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_6 188 2 1 1   8     1   4   103 102                       205.0 188 2 1 1   8     1   4   103 102                 205
2228913 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_6 142 4 15 0   18     0   6   82 103                       185.0 142 4 15 0   18     0   6   82 103                 185
2232264 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_6 114 11 89 1   2     0   1   115 103                       218.0 114 11 89 1   2     0   1   115 103                 218
2239084 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_6 168 6 9 0   4     0   7   91 103                       194.0 168 6 9 0   4     0   7   91 103                 194
2234575 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_6 145 7 14 0   21     2   11   96 104                       200.0 145 7 14 0   21     2   11   96 104                 200
2237116 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford: Stony Brook School   Regular School No Middle 06 08 2018   grade_6 142 3 0 0   52     0   7   100 104                       204.0 142 3 0 0   52     0   7   100 104                 204
2230881 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_6 163 11 14 0   31     1   4   119 105                       224.0 163 11 14 0   31     1   4   119 105                 224
2231376 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow: Birchland Park   Regular School No Middle 06 08 2018   grade_6 180 5 15 0   8     0   4   107 105                       212.0 180 5 15 0   8     0   4   107 105                 212
2233451 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead: Village School   Regular School No Middle 04 06 2018   grade_6 177 10 17 2   2     0   7   110 105                       215.0 177 10 17 2   2     0   7   110 105                 215
2229000 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_6 139 4 27 1   30     0   6   101 106                       207.0 139 4 27 1   30     0   6   101 106                 207
2229346 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica: Marshall Middle School   Regular School No Middle 06 08 2018   grade_6 182 5 17 1   19     0   1   119 106                       225.0 182 5 17 1   19     0   1   119 106                 225
2230367 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_6 163 9 10 0   32     0   0   106 108                       214.0 163 9 10 0   32     0   0   106 108                 214
2232005 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_6 197 6 13 0   4     1   7   120 108                       228.0 197 6 13 0   4     1   7   120 108                 228
2234985 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_6 156 27 24 0   3     0   12   113 109                       222.0 156 27 24 0   3     0   12   113 109                 222
2235375 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_6 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2237744 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_6 17 4 4 0   2     0   1   17 11                       28.0 17 4 4 0   2     0   1   17 11                 28
2238102 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_6 0 18 2 0   0     0   0   9 11                       20.0 0 18 2 0   0     0   0   9 11                 20
2238288 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_6 18 1 1 0   0     0   0   9 11                       20.0 18 1 1 0   0     0   0   9 11                 20
2238642 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston: Royalston Community School   Regular School No Elementary KG 06 2018   grade_6 20 0 3 0   0     0   1   13 11                       24.0 20 0 3 0   0     0   1   13 11                 24
2239107 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_6 14 0 1 0   0     0   2   6 11                       17.0 14 0 1 0   0     0   2   6 11                 17
2239319 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_6 16 0 2 0   0     0   0   7 11                       18.0 16 0 2 0   0     0   0   7 11                 18
2240016 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_6 18 3 7 0   0     0   3   20 11                       31.0 18 3 7 0   0     0   3   20 11                 31
2230363 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree: East Middle School   Regular School No Middle 06 08 2018   grade_6 164 8 16 1   41     0   2   122 110                       232.0 164 8 16 1   41     0   2   122 110                 232
2234351 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton: Charles E Brown Middle   Regular School No Middle 06 08 2018   grade_6 144 4 17 0   53     0   12   120 110                       230.0 144 4 17 0   53     0   12   120 110                 230
2233109 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell: Dr An Wang School   Regular School No Middle 05 08 2018   grade_6 64 12 78 0   36     0   7   86 111                       197.0 64 12 78 0   36     0   7   86 111                 197
2236862 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland: Wayland Middle School   Regular School No Middle 06 08 2018   grade_6 150 17 7 0   34     0   13   110 111                       221.0 150 17 7 0   34     0   13   110 111                 221
2229160 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown: Chestnut Hill Community School   Regular School No Middle 04 06 2018   grade_6 164 3 12 0   3     1   4   75 112                       187.0 164 3 12 0   3     1   4   75 112                 187
2238389 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_6 4 135 100 0   5     1   3   136 112                       248.0 4 135 100 0   5     1   3   136 112                 248
2232345 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston: Robert H. Adams Middle School   Regular School No Middle 06 08 2018   grade_6 194 3 10 1   14     0   3   112 113                       225.0 194 3 10 1   14     0   3   112 113                 225
2232503 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson: David J. Quinn Middle School   Regular School No Middle 05 07 2018   grade_6 178 0 23 0   7     0   2   97 113                       210.0 178 0 23 0   7     0   2   97 113                 210
2235189 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_6 121 4 5 0   69     1   6   92 114                       206.0 121 4 5 0   69     1   6   92 114                 206
2232473 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton: Hopkinton Middle School   Regular School No Middle 06 08 2018   grade_6 187 4 7 1   25     0   10   119 115                       234.0 187 4 7 1   25     0   10   119 115                 234
2233991 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick: Wilson Middle   Regular School No Middle 05 08 2018   grade_6 200 6 9 0   14     0   14   128 115                       243.0 200 6 9 0   14     0   14   128 115                 243
2233795 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_6 219 7 8 4   7     0   11   140 116                       256.0 219 7 8 4   7     0   11   140 116                 256
2234726 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Norwood: Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2018   grade_6 169 25 29 0   16     1   4   128 116                       244.0 169 25 29 0   16     1   4   128 116                 244
2238830 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_6 150 18 34 5   4     0   14   107 118                       225.0 150 18 34 5   4     0   14   107 118                 225
2235066 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth: Plymouth South Middle   Regular School No Middle 06 08 2018   grade_6 232 1 2 1   2     0   10   129 119                       248.0 232 1 2 1   2     0   10   129 119                 248
2235726 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury: Shutesbury Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 0 0   0     0   1   6 12                       18.0 17 0 0 0   0     0   1   6 12                 18
2237351 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   1   6 12                       18.0 16 0 1 0   0     0   1   6 12                 18
2239080 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Hampden-Wilbraham: Thornton Burgess   Regular School No Middle 06 08 2018   grade_6 23 1 3 0   0     0   1   16 12                       28.0 23 1 3 0   0     0   1   16 12                 28
2239230 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   grade_6 17 0 2 0   0     0   0   7 12                       19.0 17 0 2 0   0     0   0   7 12                 19
2239413 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_6 23 1 0 0   0     0   2   14 12                       26.0 23 1 0 0   0     0   2   14 12                 26
2235606 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate: Gates Middle School   Regular School No Middle 06 08 2018   grade_6 220 5 3 0   3     0   3   114 120                       234.0 220 5 3 0   3     0   3   114 120                 234
2230813 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_6 163 27 13 0   20     0   12   114 121                       235.0 163 27 13 0   20     0   12   114 121                 235
2235520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_6 216 0 4 0   2     0   1   102 121                       223.0 216 0 4 0   2     0   1   102 121                 223
2237272 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood: E W Thurston Middle   Regular School No Middle 06 08 2018   grade_6 207 8 12 0   35     0   9   150 121                       271.0 207 8 12 0   35     0   9   150 121                 271
2231091 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord: Concord Middle   Regular School No Middle 06 08 2018   grade_6 169 12 17 1   14     0   17   108 122                       230.0 169 12 17 1   14     0   17   108 122                 230
2236759 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_6 87 19 107 0   10     0   4   105 122                       227.0 87 19 107 0   10     0   4   105 122                 227
2236541 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 Tewksbury: John F. Ryan   Regular School No Middle 05 06 2018   grade_6 238 6 8 0   9     1   2   141 123                       264.0 238 6 8 0   9     1   2   141 123                 264
2231300 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_6 225 1 3 0   6     0   11   122 124                       246.0 225 1 3 0   6     0   11   122 124                 246
2231857 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_6 148 8 92 0   9     0   5   138 124                       262.0 148 8 92 0   9     0   5   138 124                 262
2236165 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_6 8 43 168 0   24     0   1   120 124                       244.0 8 43 168 0   24     0   1   120 124                 244
2236647 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield: Galvin Middle School   Regular School No Middle 05 08 2018   grade_6 207 8 20 0   8     0   7   126 124                       250.0 207 8 20 0   8     0   7   126 124                 250
2231008 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_6 131 7 104 0   2     0   9   128 125                       253.0 131 7 104 0   2     0   9   128 125                 253
2237068 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 Westfield: North Middle School   Regular School No Middle 06 08 2018   grade_6 203 5 24 0   5     0   8   120 125                       245.0 203 5 24 0   5     0   8   120 125                 245
2237391 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_6 241 4 7 1   6     0   10   144 125                       269.0 241 4 7 1   6     0   10   144 125                 269
2236515 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_6 191 22 24 0   3     2   14   127 129                       256.0 191 22 24 0   3     2   14   127 129                 256
2237712 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   grade_6 11 2 7 0   5     0   3   15 13                       28.0 11 2 7 0   5     0   3   15 13                 28
2237736 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_6 8 5 14 1   0     0   0   15 13                       28.0 8 5 14 1   0     0   0   15 13                 28
2239469 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_6 26 0 0 0   0     0   0   13 13                       26.0 26 0 0 0   0     0   0   13 13                 26
2230509 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_6 60 85 69 0   8     0   10   102 130                       232.0 60 85 69 0   8     0   10   102 130                 232
2228812 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_6 249 9 18 0   14     0   10   169 131                       300.0 249 9 18 0   14     0   10   169 131                 300
2235663 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon: Sharon Middle   Regular School No Middle 06 08 2018   grade_6 168 11 10 1   82     0   13   154 131                       285.0 168 11 10 1   82     0   13   154 131                 285
2230659 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington: Marshall Simonds Middle   Regular School No Middle 06 08 2018   grade_6 179 15 14 1   40     0   4   120 133                       253.0 179 15 14 1   40     0   4   120 133                 253
2231621 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_6 150 25 48 0   15     0   18   123 133                       256.0 150 25 48 0   15     0   18   123 133                 256
2236329 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_6 174 72 33 1   28     2   12   188 134                       322.0 174 72 33 1   28     2   12   188 134                 322
2231004 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_6 134 6 106 0   6     0   11   127 136                       263.0 134 6 106 0   6     0   11   127 136                 263
2231140 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_6 231 5 19 1   10     0   7   136 137                       273.0 231 5 19 1   10     0   7   136 137                 273
2231404 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_6 250 9 11 0   10     0   6   149 137                       286.0 250 9 11 0   10     0   6   149 137                 286
2232876 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_6 123 13 11 0   93     0   25   128 137                       265.0 123 13 11 0   93     0   25   128 137                 265
2233543 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield: Furnace Brook Middle   Regular School No Middle 06 08 2018   grade_6 260 0 7 0   3     0   6   138 138                       276.0 260 0 7 0   3     0   6   138 138                 276
2231684 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   grade_6 221 20 17 2   2     1   15   139 139                       278.0 221 20 17 2   2     1   15   139 139                 278
2233901 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton: Charles S Pierce Middle   Regular School No Middle 06 08 2018   grade_6 233 39 17 0   22     0   12   184 139                       323.0 233 39 17 0   22     0   12   184 139                 323
2238940 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_6 251 2 6 1   0     0   4   125 139                       264.0 251 2 6 1   0     0   4   125 139                 264
2229895 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_6 1 13 25 0   0     0   1   26 14                       40.0 1 13 25 0   0     0   1   26 14                 40
2237360 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_6 30 0 0 0   0     0   0   16 14                       30.0 30 0 0 0   0     0   0   16 14                 30
2238067 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District): Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 06 2018   grade_6 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2233722 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose: Melrose Middle   Regular School No Middle 06 08 2018   grade_6 201 31 18 0   9     0   6   125 140                       265.0 201 31 18 0   9     0   6   125 140                 265

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