enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1122674 1122674 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   3 1                       *                         3 1                  
1123667 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                  
1125191 1125191 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125265 1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1126250 1126250 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_5 * * * *   *     *   *   2 *                       *                         2                    
1126351 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 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 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 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                  
1368462 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 1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1675703 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 2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2231642 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 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 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
738426 738426 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 04 05 2015   grade_5 * * * *   *     *   *   * *                       1                                             1
935277 935277 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_5 * * * *   *     *   *   * *                       1                                             1
1368367 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
1674755 1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
941253 941253 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2016   grade_5 9 0 0 1   0     0   0   3 7                       10 9 0 0 1   0     0   0   3 7                 10
941543 941543 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_5 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
1126450 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
1128618 1128618 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_5 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1130138 1130138 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_5 9 0 0 0   0     0   1   5 5                       10 9 0 0 0   0     0   1   5 5                 10
1132822 1132822 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   grade_5 9 0 0 0   1     0   0   7 3                       10 9 0 0 0   1     0   0   7 3                 10
1372422 1372422 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1373330 1373330 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1680595 1680595 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680878 1680878 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
2042367 2042367 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_5 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2048670 2048670 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   grade_5 7 0 3 0   0     0   0   6 4                       10.0 7 0 3 0   0     0   0   6 4                 10
2232698 2232698 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_5 1 0 8 0   0     0   1   9 1                       10.0 1 0 8 0   0     0   1   9 1                 10
736379 736379 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 06 2015   grade_5 3 25 69 0   3     0   0   47 53                       100 3 25 69 0   3     0   0   47 53                 100
737721 737721 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_5 87 2 5 0   1     0   5   43 57                       100 87 2 5 0   1     0   5   43 57                 100
738280 738280 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_5 53 13 26 0   5     0   3   51 49                       100 53 13 26 0   5     0   3   51 49                 100
739941 739941 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2015   grade_5 92 0 4 0   2     0   2   45 55                       100 92 0 4 0   2     0   2   45 55                 100
740184 740184 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   grade_5 23 14 58 1   2     0   2   49 51                       100 23 14 58 1   2     0   2   49 51                 100
741000 741000 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No 1 KG 05 2015   grade_5 95 1 1 0   2     0   1   50 50                       100 95 1 1 0   2     0   1   50 50                 100
743871 743871 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_5 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
744073 744073 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_5 88 0 8 1   1     0   2   38 62                       100 88 0 8 1   1     0   2   38 62                 100
934736 934736 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2016   grade_5 81 3 13 0   3     0   0   56 44                       100 81 3 13 0   3     0   0   56 44                 100
935166 935166 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_5 94 0 1 0   4     0   1   60 40                       100 94 0 1 0   4     0   1   60 40                 100
936419 936419 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_5 24 23 31 0   15     0   7   49 51                       100 24 23 31 0   15     0   7   49 51                 100
936437 936437 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_5 43 13 16 1   24     0   3   47 53                       100 43 13 16 1   24     0   3   47 53                 100
937052 937052 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_5 55 9 22 1   1     0   12   50 50                       100 55 9 22 1   1     0   12   50 50                 100
937785 937785 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_5 88 1 4 0   3     0   4   56 44                       100 88 1 4 0   3     0   4   56 44                 100
937953 937953 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2016   grade_5 37 13 8 0   39     0   3   57 43                       100 37 13 8 0   39     0   3   57 43                 100
940460 940460 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_5 50 24 23 0   1     0   2   59 41                       100 50 24 23 0   1     0   2   59 41                 100
940701 940701 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_5 81 5 7 0   4     0   3   53 47                       100 81 5 7 0   4     0   3   53 47                 100
941645 941645 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_5 93 3 2 0   2     0   0   50 50                       100 93 3 2 0   2     0   0   50 50                 100
1124969 1124969 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_5 30 11 53 0   2     0   4   56 44                       100 30 11 53 0   2     0   4   56 44                 100
1126026 1126026 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2017   grade_5 47 4 4 0   38     0   7   50 50                       100 47 4 4 0   38     0   7   50 50                 100
1126393 1126393 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2017   grade_5 4 10 75 0   8     0   3   52 48                       100 4 10 75 0   8     0   3   52 48                 100
1127334 1127334 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   grade_5 70 6 12 0   3     0   9   59 41                       100 70 6 12 0   3     0   9   59 41                 100
1127647 1127647 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary KG 05 2017   grade_5 81 2 8 0   8     0   1   50 50                       100 81 2 8 0   8     0   1   50 50                 100
1129099 1129099 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2017   grade_5 10 13 75 0   1     0   1   57 43                       100 10 13 75 0   1     0   1   57 43                 100
1130756 1130756 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_5 8 9 72 0   10     0   1   52 48                       100 8 9 72 0   10     0   1   52 48                 100
1131242 1131242 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_5 72 0 11 0   7     0   10   44 56                       100 72 0 11 0   7     0   10   44 56                 100
1131618 1131618 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_5 82 4 10 0   2     0   2   47 53                       100 82 4 10 0   2     0   2   47 53                 100
1364941 1364941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_5 71 2 8 0   9     1   9   55 45 *                     100.0 71 2 8 0   9     1   9   55 45                 100
1369049 1369049 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 05 2020   grade_5 88 0 6 0   1     0   5   48 52 *                     100.0 88 0 6 0   1     0   5   48 52                 100
1371516 1371516 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2020   grade_5 75 0 13 1   1     0   10   50 50 *                     100.0 75 0 13 1   1     0   10   50 50                 100
1371987 1371987 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 North Intermediate   Regular School No Elementary 04 05 2020   grade_5 86 0 5 0   5     0   4   55 45 *                     100.0 86 0 5 0   5     0   4   55 45                 100
1372580 1372580 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_5 69 6 9 0   8     0   8   59 41 *                     100.0 69 6 9 0   8     0   8   59 41                 100
1673829 1673829 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_5 8 6 83 0   0     0   3   51 49 *                     100.0 8 6 83 0   0     0   3   51 49                 100
1679843 1679843 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_5 70 6 12 0   5     0   7   44 56 *                     100.0 70 6 12 0   5     0   7   44 56                 100
2043203 2043203 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2019   grade_5 55 4 34 1   4     0   2   54 45                       100.0 55 4 34 1   4     0   2   54 45                 100
2045917 2045917 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   grade_5 6 22 69 0   0     0   3   52 48                       100.0 6 22 69 0   0     0   3   52 48                 100
2047217 2047217 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_5 11 8 71 0   8     0   2   52 48                       100.0 11 8 71 0   8     0   2   52 48                 100
2047652 2047652 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_5 75 3 9 1   8     0   4   47 53                       100.0 75 3 9 1   8     0   4   47 53                 100
2230454 2230454 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton: Gilmore Elementary School   Regular School No Elementary KG 05 2018   grade_5 3 81 13 1   0     0   2   48 52                       100.0 3 81 13 1   0     0   2   48 52                 100
2232778 2232778 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Leominster: Frances Drake School   Regular School No Elementary KG 05 2018   grade_5 41 3 46 0   6     0   4   52 48                       100.0 41 3 46 0   6     0   4   52 48                 100
2235050 2235050 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Plymouth: Nathaniel Morton Elementary   Regular School No Elementary KG 05 2018   grade_5 91 2 4 0   1     0   2   43 57                       100.0 91 2 4 0   1     0   2   43 57                 100
2235741 2235741 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 Somerset: North Elementary   Regular School No Elementary KG 05 2018   grade_5 88 3 7 0   2     0   0   55 45                       100.0 88 3 7 0   2     0   0   55 45                 100
2238073 2238073 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_5 81 1 7 0   10     0   1   54 46                       100.0 81 1 7 0   10     0   1   54 46                 100
2238718 2238718 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville: A F Maloney   Regular School No Elementary 03 05 2018   grade_5 88 1 7 0   1     0   3   44 56                       100.0 88 1 7 0   1     0   3   44 56                 100
932648 932648 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2016   grade_5 63 3 9 0   23     0   3   45 56                       101 63 3 9 0   23     0   3   45 56                 101
936628 936628 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2016   grade_5 73 10 9 0   6     0   3   52 49                       101 73 10 9 0   6     0   3   52 49                 101
937515 937515 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2016   grade_5 98 0 0 0   2     0   1   46 55                       101 98 0 0 0   2     0   1   46 55                 101
941833 941833 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2016   grade_5 86 4 2 2   1     1   5   59 42                       101 86 4 2 2   1     1   5   59 42                 101
1124557 1124557 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2017   grade_5 88 1 6 0   3     0   3   56 45                       101 88 1 6 0   3     0   3   56 45                 101
1125011 1125011 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   grade_5 59 10 25 0   2     0   5   56 45                       101 59 10 25 0   2     0   5   56 45                 101
1125502 1125502 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No Elementary 04 06 2017   grade_5 64 15 10 0   3     0   9   51 50                       101 64 15 10 0   3     0   9   51 50                 101
1365660 1365660 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_5 1 62 35 0   1     0   2   42 59 *                     101.0 1 62 35 0   1     0   2   42 59                 101
1366271 1366271 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_5 51 6 8 0   30     0   6   51 50 *                     101.0 51 6 8 0   30     0   6   51 50                 101
1367700 1367700 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_5 59 2 36 1   1     0   2   58 43 *                     101.0 59 2 36 1   1     0   2   58 43                 101
1368090 1368090 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_5 79 4 10 0   3     0   5   52 49 *                     101.0 79 4 10 0   3     0   5   52 49                 101
1368177 1368177 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2020   grade_5 43 5 6 0   33     0   14   53 48 *                     101.0 43 5 6 0   33     0   14   53 48                 101
1368183 1368183 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2020   grade_5 38 5 3 0   45     0   10   56 45 *                     101.0 38 5 3 0   45     0   10   56 45                 101
1368667 1368667 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_5 38 20 22 0   18     0   3   52 49 *                     101.0 38 20 22 0   18     0   3   52 49                 101
1373637 1373637 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Elementary School   Regular School No Elementary PK 05 2020   grade_5 87 1 6 0   0     0   7   52 49 *                     101.0 87 1 6 0   0     0   7   52 49                 101
1675100 1675100 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_5 1 4 94 0   1     0   1   52 49 *                     101.0 1 4 94 0   1     0   1   52 49                 101
1675257 1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
1675782 1675782 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_5 7 10 70 0   7     0   7   49 52 *                     101.0 7 10 70 0   7     0   7   49 52                 101
1676444 1676444 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham - Newman Elementary   Regular School No Elementary PK 05 2021   grade_5 74 6 5 0   9     0   7   49 52 *                     101.0 74 6 5 0   9     0   7   49 52                 101
2040703 2040703 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_5 4 45 46 1   1     1   3   53 48                       101.0 4 45 46 1   1     1   3   53 48                 101
2044134 2044134 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2019   grade_5 82 5 2 0   6     1   5   52 49                       101.0 82 5 2 0   6     1   5   52 49                 101
2045118 2045118 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2019   grade_5 96 1 3 0   0     0   1   53 48                       101.0 96 1 3 0   0     0   1   53 48                 101
2045705 2045705 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2019   grade_5 91 2 4 0   0     0   4   52 49                       101.0 91 2 4 0   0     0   4   52 49                 101

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