Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by male

View and edit SQL

year

grade

  • grade_5 · 6,218
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
738426 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 04 05 2015   grade_5 * * * *   *     *   *   * *                       1                                             1
935277 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_5 * * * *   *     *   *   * *                       1                                             1
1125191 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2231642 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_5 * * * *   *     *   *   * *                       0.0                                             0
2232020 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2237226 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
744543 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_5 * * * *   *     *   *   1 1                       2                         1 1                 2
939687 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_5 * * * *   *     *   *   1 1                       2                         1 1                 2
1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1126351 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1128753 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1130461 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1132594 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1367295 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_5 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1368367 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_5 * * * *   *     *   *   1 * *                     1.0                         1                   1
1673451 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_5 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1675612 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_5 * * * *   *     *   *   1 * *                     2.0                         1                   2
1677633 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   1 4 *                     5.0                         1 4                 5
2043507 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2233131 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell: Lowell Day School on Broadway   Special Education School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2233173 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Lynn: Early Childhood Center   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2237289 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2237901 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   1 2                       3.0                         1 2                 3
736203 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   grade_5 3 4 9 0   2     0   2   10 10                       20 3 4 9 0   2     0   2   10 10                 20
736520 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_5 2 7 10 0   2     0   0   10 11                       21 2 7 10 0   2     0   0   10 11                 21
737947 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_5 25 0 2 0   0     0   1   10 18                       28 25 0 2 0   0     0   1   10 18                 28
743977 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2015   grade_5 28 1 0 0   0     0   0   10 19                       29 28 1 0 0   0     0   0   10 19                 29
933195 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2016   grade_5 0 5 9 0   0     1   1   10 6                       16 0 5 9 0   0     1   1   10 6                 16
933628 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_5 6 4 7 1   0     0   0   10 8                       18 6 4 7 1   0     0   0   10 8                 18
937870 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_5 7 2 4 0   0     0   1   10 4                       14 7 2 4 0   0     0   1   10 4                 14
938581 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_5 0 8 33 0   0     0   0   10 31                       41 0 8 33 0   0     0   0   10 31                 41
940996 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No 1 PK 05 2016   grade_5 18 0 1 0   0     0   1   10 10                       20 18 0 1 0   0     0   1   10 10                 20
1123082 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   grade_5 0 14 7 0   0     0   2   10 13                       23 0 14 7 0   0     0   2   10 13                 23
1123869 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_5 13 0 18 0   1     0   2   10 24                       34 13 0 18 0   1     0   2   10 24                 34
1124212 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_5 18 0 0 0   0     0   0   10 8                       18 18 0 0 0   0     0   0   10 8                 18
1126450 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_5 2 1 6 0   0     0   1   10 *                       10 2 1 6 0   0     0   1   10                   10
1127117 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   0   10 7                       17 17 0 0 0   0     0   0   10 7                 17
1127242 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   grade_5 19 5 11 0   0     0   1   10 26                       36 19 5 11 0   0     0   1   10 26                 36
1127370 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2017   grade_5 19 2 2 0   0     0   3   10 16                       26 19 2 2 0   0     0   3   10 16                 26
1131541 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_5 27 0 2 0   2     0   2   10 23                       33 27 0 2 0   2     0   2   10 23                 33
1132626 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_5 26 0 2 0   0     0   0   10 18                       28 26 0 2 0   0     0   0   10 18                 28
1365303 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_5 14 4 6 0   0     0   1   10 15 *                     25.0 14 4 6 0   0     0   1   10 15                 25
1365418 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2020   grade_5 0 13 11 0   3     0   1   10 18 *                     28.0 0 13 11 0   3     0   1   10 18                 28
1365537 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2020   grade_5 0 12 13 0   0     1   3   10 19 *                     29.0 0 12 13 0   0     1   3   10 19                 29
1365619 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2020   grade_5 3 8 9 0   1     0   1   10 12 *                     22.0 3 8 9 0   1     0   1   10 12                 22
1366750 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   grade_5 16 0 2 0   0     0   0   10 8 *                     18.0 16 0 2 0   0     0   0   10 8                 18
1369288 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2020   grade_5 7 5 9 0   0     0   3   10 14 *                     24.0 7 5 9 0   0     0   3   10 14                 24
1370088 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2020   grade_5 21 0 0 0   0     0   0   10 11 *                     21.0 21 0 0 0   0     0   0   10 11                 21
1370615 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   grade_5 18 0 1 0   1     0   1   10 11 *                     21.0 18 0 1 0   1     0   1   10 11                 21
1372264 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2020   grade_5 3 7 10 0   1     0   1   10 12 *                     22.0 3 7 10 0   1     0   1   10 12                 22
1372605 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_5 0 17 1 0   0     0   1   10 9 *                     19.0 0 17 1 0   0     0   1   10 9                 19
1373485 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2020   grade_5 16 0 1 0   0     0   1   10 8 *                     18.0 16 0 1 0   0     0   1   10 8                 18
1373775 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_5 21 0 1 0   0     0   1   10 13 *                     23.0 21 0 1 0   0     0   1   10 13                 23
1373795 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_5 19 0 3 1   0     0   0   10 13 *                     23.0 19 0 3 1   0     0   0   10 13                 23
1672851 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_5 4 10 9 0   0     0   1   10 14 *                     24.0 4 10 9 0   0     0   1   10 14                 24
1672959 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_5 5 1 19 0   0     0   0   10 15 *                     25.0 5 1 19 0   0     0   0   10 15                 25
1673071 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_5 0 9 14 0   0     0   0   10 13 *                     23.0 0 9 14 0   0     0   0   10 13                 23
1676590 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_5 4 1 7 0   0     0   0   10 2 *                     12.0 4 1 7 0   0     0   0   10 2                 12
1677578 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_5 14 1 2 0   0     0   0   10 7 *                     17.0 14 1 2 0   0     0   0   10 7                 17
1678033 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_5 1 2 8 0   0     0   0   10 1 *                     11.0 1 2 8 0   0     0   0   10 1                 11
1679347 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Woburn - Linscott-Rumford   Regular School No Elementary KG 05 2021   grade_5 11 3 3 0   4     0   3   10 14 *                     24.0 11 3 3 0   4     0   3   10 14                 24
1679971 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 2021   grade_5 21 0 0 0   0     0   1   10 12 *                     22.0 21 0 0 0   0     0   1   10 12                 22
1680111 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 2021   grade_5 31 0 0 0   0     0   1   10 22 *                     32.0 31 0 0 0   0     0   1   10 22                 32
1680669 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague - Gill Elementary   Regular School No Elementary KG 06 2021   grade_5 16 0 0 0   0     0   0   10 6 *                     16.0 16 0 0 0   0     0   0   10 6                 16
2040614 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2019   grade_5 8 4 5 0   3     0   0   10 10                       20.0 8 4 5 0   3     0   0   10 10                 20
2040818 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2019   grade_5 0 10 5 0   0     0   1   10 6                       16.0 0 10 5 0   0     0   1   10 6                 16
2047040 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_5 16 0 1 0   0     0   1   10 8                       18.0 16 0 1 0   0     0   1   10 8                 18
2048393 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_5 11 0 0 0   0     0   0   10 1                       11.0 11 0 0 0   0     0   0   10 1                 11
2229572 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston: George H Conley   Regular School No Elementary PK 05 2018   grade_5 1 13 8 0   0     0   1   10 13                       23.0 1 13 8 0   0     0   1   10 13                 23
2229657 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   grade_5 1 10 6 0   0     0   0   10 7                       17.0 1 10 6 0   0     0   0   10 7                 17
2229935 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston: William Ellery Channing   Regular School No Elementary PK 05 2018   grade_5 0 7 15 0   1     0   1   10 14                       24.0 0 7 15 0   1     0   1   10 14                 24
2231101 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_5 20 0 1 0   0     0   0   10 11                       21.0 20 0 1 0   0     0   0   10 11                 21
2233934 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_5 23 0 0 0   0     0   0   10 13                       23.0 23 0 0 0   0     0   0   10 13                 23
2236953 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   grade_5 26 0 3 0   0     0   0   10 19                       29.0 26 0 3 0   0     0   0   10 19                 29
2237359 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_5 18 1 0 0   0     0   0   10 9                       19.0 18 1 0 0   0     0   0   10 9                 19
2237575 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_5 11 4 6 0   1     0   0   10 12                       22.0 11 4 6 0   1     0   0   10 12                 22
2238101 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_5 0 19 0 0   0     0   0   10 9                       19.0 0 19 0 0   0     0   0   10 9                 19
2238287 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_5 14 1 4 0   0     0   2   10 11                       21.0 14 1 4 0   0     0   2   10 11                 21
2238778 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire: Becket Washington School   Regular School No Elementary PK 05 2018   grade_5 17 0 0 0   0     0   0   10 7                       17.0 17 0 0 0   0     0   0   10 7                 17
2239106 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_5 19 1 1 0   0     0   1   10 12                       22.0 19 1 1 0   0     0   1   10 12                 22
2239318 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_5 18 0 1 0   1     0   1   10 11                       21.0 18 0 1 0   1     0   1   10 11                 21
739824 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2015   grade_5 172 1 6 1   8     0   4   100 92                       192 172 1 6 1   8     0   4   100 92                 192
740665 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2015   grade_5 178 4 5 0   1     0   5   100 93                       193 178 4 5 0   1     0   5   100 93                 193
1122337 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2017   grade_5 120 12 11 0   26     0   13   100 82                       182 120 12 11 0   26     0   13   100 82                 182
1123646 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_5 55 81 26 2   12     0   12   100 88                       188 55 81 26 2   12     0   12   100 88                 188
1126781 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2017   grade_5 168 2 5 2   8     0   6   100 91                       191 168 2 5 2   8     0   6   100 91                 191
1675630 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_5 38 12 29 0   89     0   5   100 73 *                     173.0 38 12 29 0   89     0   5   100 73                 173
1678537 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton - Joseph H Martin   Regular School No Middle 05 07 2021   grade_5 124 40 32 0   3     0   11   100 110 *                     210.0 124 40 32 0   3     0   11   100 110                 210
2239197 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_5 162 14 10 0   1     1   2   100 90                       190.0 162 14 10 0   1     1   2   100 90                 190
735896 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_5 153 7 18 0   6     0   7   101 90                       191 153 7 18 0   6     0   7   101 90                 191
936218 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No 2 04 05 2016   grade_5 191 2 10 0   0     1   5   101 108                       209 191 2 10 0   0     1   5   101 108                 209
1122192 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_5 140 4 21 1   25     0   7   101 97                       198 140 4 21 1   25     0   7   101 97                 198
1122381 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_5 164 3 8 1   8     0   4   101 87                       188 164 3 8 1   8     0   4   101 87                 188
1672475 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica - Marshall Middle School   Regular School No Middle 05 07 2021   grade_5 136 16 20 1   23     0   4   101 99 *                     200.0 136 16 20 1   23     0   4   101 99                 200

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