Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
2237290 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_6 * * * *   *     *   *   1 2                       3.0                         1 2                 3
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
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
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
2239437 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Pioneer Valley: Warwick Community School   Regular School No Elementary PK 06 2018   grade_6 7 0 0 0   0     0   0   4 3                       7.0 7 0 0 0   0     0   0   4 3                 7
2231754 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_6 8 0 0 0   0     0   0   2 6                       8.0 8 0 0 0   0     0   0   2 6                 8
2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
2235099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_6 5 3 1 0   0     0   1   6 4                       10.0 5 3 1 0   0     0   1   6 4                 10
2235441 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2239239 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail: Sanderson Academy   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2232699 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_6 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2239011 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague: Gill Elementary   Regular School No Elementary KG 06 2018   grade_6 9 0 0 0   0     0   2   6 5                       11.0 9 0 0 0   0     0   2   6 5                 11
2238924 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_6 11 0 0 0   0     0   1   7 5                       12.0 11 0 0 0   0     0   1   7 5                 12
2234878 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_6 14 0 1 0   1     0   0   7 9                       16.0 14 0 1 0   1     0   0   7 9                 16
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
2229376 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_6 3 3 7 0   2     0   2   12 5                       17.0 3 3 7 0   2     0   2   12 5                 17
2232826 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_6 12 0 2 0   0     0   3   10 7                       17.0 12 0 2 0   0     0   3   10 7                 17
2237132 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   1   9 8                       17.0 16 0 0 0   0     0   1   9 8                 17
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
2229941 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_6 1 5 12 0   0     0   0   15 3                       18.0 1 5 12 0   0     0   0   15 3                 18
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
2236177 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield: Springfield Public Day Middle School   Regular School No Middle 06 08 2018   grade_6 2 3 13 0   0     0   0   16 2                       18.0 2 3 13 0   0     0   0   16 2                 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
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
2239566 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 1 0   0     0   0   12 6                       18.0 17 0 1 0   0     0   0   12 6                 18
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
2231431 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   2   11 8                       19.0 16 0 1 0   0     0   2   11 8                 19
2233935 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_6 18 0 0 0   1     0   0   10 9                       19.0 18 0 0 0   1     0   0   10 9                 19
2234919 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_6 18 0 0 0   0     0   1   13 6                       19.0 18 0 0 0   0     0   1   13 6                 19
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
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
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
2239221 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Mohawk Trail: Buckland-Shelburne Regional   Regular School No Elementary PK 06 2018   grade_6 18 0 1 0   1     0   0   12 8                       20.0 18 0 1 0   1     0   0   12 8                 20
2236663 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales: Wales Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 3 0   0     0   1   14 7                       21.0 17 0 3 0   0     0   1   14 7                 21
2229796 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_6 14 5 4 0   0     0   0   14 9                       23.0 14 5 4 0   0     0   0   14 9                 23
2231102 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_6 22 0 0 0   0     0   1   14 9                       23.0 22 0 0 0   0     0   1   14 9                 23
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
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
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
2230258 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_6 1 1 23 0   0     0   0   7 18                       25.0 1 1 23 0   0     0   0   7 18                 25
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
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
2234408 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   grade_6 20 2 1 0   0     0   4   11 16                       27.0 20 2 1 0   0     0   4   11 16                 27
2236387 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland: Sunderland Elementary   Regular School No Elementary PK 06 2018   grade_6 19 2 1 0   4     0   2   23 5                       28.0 19 2 1 0   4     0   2   23 5                 28
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
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
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
2229686 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_6 8 0 20 0   0     0   2   15 15                       30.0 8 0 20 0   0     0   2   15 15                 30
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
2239428 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   grade_6 27 0 1 0   0     0   3   15 16                       31.0 27 0 1 0   0     0   3   15 16                 31
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
2232182 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_6 30 1 1 0   0     0   0   17 15                       32.0 30 1 1 0   0     0   0   17 15                 32
2232570 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_6 31 0 0 0   0     0   1   13 19                       32.0 31 0 0 0   0     0   1   13 19                 32
2235090 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_6 30 0 0 1   1     0   0   16 16                       32.0 30 0 0 1   1     0   0   16 16                 32
2235813 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville: West Somerville Neighborhood   Regular School No Elementary PK 08 2018   grade_6 16 7 7 0   1     0   1   17 15                       32.0 16 7 7 0   1     0   1   17 15                 32
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
2238211 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_6 23 1 4 0   0     0   4   17 15                       32.0 23 1 4 0   0     0   4   17 15                 32
2238375 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_6 26 1 1 0   2     0   2   9 23                       32.0 26 1 1 0   2     0   2   9 23                 32
2238128 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_6 2 0 31 0   0     0   0   9 24                       33.0 2 0 31 0   0     0   0   9 24                 33
2237636 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester: Clark St Community   Regular School No Elementary PK 06 2018   grade_6 5 5 20 0   1     0   3   16 18                       34.0 5 5 20 0   1     0   3   16 18                 34
2237991 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District): Bridge Boston Charter School   Regular School Yes Elementary PK 06 2018   grade_6 0 23 10 0   1     0   1   18 17                       35.0 0 23 10 0   1     0   1   18 17                 35
2238247 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_6 21 3 9 0   0     0   2   13 22                       35.0 21 3 9 0   0     0   2   13 22                 35
2230685 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_6 13 0 20 0   1     0   2   11 25                       36.0 13 0 20 0   1     0   2   11 25                 36
2232334 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_6 34 2 0 0   0     0   0   17 19                       36.0 34 2 0 0   0     0   0   17 19                 36
2237687 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester: Grafton Street   Regular School No Elementary KG 06 2018   grade_6 8 8 16 0   3     0   1   21 15                       36.0 8 8 16 0   3     0   1   21 15                 36
2237704 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_6 7 10 18 0   0     0   1   17 19                       36.0 7 10 18 0   0     0   1   17 19                 36
2238021 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District): Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 06 2018   grade_6 1 0 34 0   1     0   0   16 20                       36.0 1 0 34 0   1     0   0   16 20                 36
2239452 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_6 33 0 2 0   0     0   1   12 24                       36.0 33 0 2 0   0     0   1   12 24                 36
2231420 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_6 30 2 4 0   0     0   1   17 20                       37.0 30 2 4 0   0     0   1   17 20                 37
2235482 MA Essex   school 2510380 258   Salem 251038000773 2580050 Salem: Saltonstall School   Regular School No Elementary KG 08 2018   grade_6 18 0 13 0   2     0   4   19 18                       37.0 18 0 13 0   2     0   4   19 18                 37
2236561 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_6 16 3 8 2   1     0   7   19 18                       37.0 16 3 8 2   1     0   7   19 18                 37
2237695 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester: Heard Street   Regular School No Elementary KG 06 2018   grade_6 16 6 7 0   6     0   2   16 21                       37.0 16 6 7 0   6     0   2   16 21                 37
2237720 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_6 6 7 22 0   1     0   1   20 17                       37.0 6 7 22 0   1     0   1   20 17                 37
2237797 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   grade_6 23 5 7 0   1     0   1   18 19                       37.0 23 5 7 0   1     0   1   18 19                 37
2238082 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District): Community Charter School of Cambridge   Regular School Yes High 06 12 2018   grade_6 6 19 7 0   3     0   2   19 18                       37.0 6 19 7 0   3     0   2   19 18                 37
2238008 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   grade_6 2 32 4 0   0     0   0   14 24                       38.0 2 32 4 0   0     0   0   14 24                 38
2232378 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_6 1 1 36 0   0     0   1   16 23                       39.0 1 1 36 0   0     0   1   16 23                 39
2236034 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield: Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2018   grade_6 9 13 16 0   0     0   1   18 21                       39.0 9 13 16 0   0     0   1   18 21                 39
2237592 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   grade_6 9 6 20 0   1     0   3   21 18                       39.0 9 6 20 0   1     0   3   21 18                 39
2237831 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_6 25 4 3 0   3     0   4   17 22                       39.0 25 4 3 0   3     0   4   17 22                 39
2229751 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_6 0 15 23 0   1     0   1   20 20                       40.0 0 15 23 0   1     0   1   20 20                 40
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
2235465 MA Essex   school 2510380 258   Salem 251038002559 2580025 Salem: Nathaniel Bowditch   Regular School No Elementary KG 08 2018   grade_6 6 4 26 0   2     0   2   20 20                       40.0 6 4 26 0   2     0   2   20 20                 40
2230534 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2234399 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   grade_6 35 2 2 0   2     0   0   22 19                       41.0 35 2 2 0   2     0   0   22 19                 41
2237806 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_6 15 12 10 0   3     0   1   15 26                       41.0 15 12 10 0   3     0   1   15 26                 41
2238117 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_6 5 22 14 0   0     0   0   12 29                       41.0 5 22 14 0   0     0   0   12 29                 41
2239741 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2235792 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Somerville: Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2018   grade_6 17 3 14 0   5     0   3   23 19                       42.0 17 3 14 0   5     0   3   23 19                 42
2237779 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Worcester: Rice Square   Regular School No Elementary KG 06 2018   grade_6 12 8 14 0   5     0   3   20 22                       42.0 12 8 14 0   5     0   3   20 22                 42

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