enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 894 ✖

grade ✖

  • grade_5 · 894 ✖
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                  
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
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
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
1126019 1126019 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_5 43 5 5 0   42     0   7   54 48                       102 43 5 5 0   42     0   7   54 48                 102
1126741 1126741 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_5 83 3 3 6   2     0   5   60 42                       102 83 3 3 6   2     0   5   60 42                 102
1128729 1128729 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_5 69 4 23 0   6     0   0   56 46                       102 69 4 23 0   6     0   0   56 46                 102
1124990 1124990 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_5 25 0 77 0   0     0   1   51 52                       103 25 0 77 0   0     0   1   51 52                 103
1125128 1125128 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_5 99 2 2 0   0     0   0   58 45                       103 99 2 2 0   0     0   0   58 45                 103
1125827 1125827 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_5 7 1 95 0   0     0   0   54 49                       103 7 1 95 0   0     0   0   54 49                 103
1128839 1128839 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No Elementary KG 05 2017   grade_5 66 2 4 1   24     0   6   59 44                       103 66 2 4 1   24     0   6   59 44                 103
1128229 1128229 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2017   grade_5 85 2 6 0   6     0   5   53 51                       104 85 2 6 0   6     0   5   53 51                 104
1131533 1131533 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_5 1 66 35 0   0     0   2   51 53                       104 1 66 35 0   0     0   2   51 53                 104
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1123605 1123605 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_5 34 53 14 0   2     0   2   55 50                       105 34 53 14 0   2     0   2   55 50                 105
1124536 1124536 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_5 89 0 9 0   6     0   1   48 57                       105 89 0 9 0   6     0   1   48 57                 105
1126576 1126576 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_5 41 21 13 1   26     0   3   61 44                       105 41 21 13 1   26     0   3   61 44                 105
1127044 1127044 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_5 82 1 11 0   5     0   6   63 42                       105 82 1 11 0   5     0   6   63 42                 105
1132437 1132437 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_5 100 0 1 0   0     0   4   52 53                       105 100 0 1 0   0     0   4   52 53                 105
1122835 1122835 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   grade_5 0 40 54 0   2     0   10   58 48                       106 0 40 54 0   2     0   10   58 48                 106
1123491 1123491 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_5 98 0 3 0   4     0   1   46 60                       106 98 0 3 0   4     0   1   46 60                 106
1127074 1127074 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2017   grade_5 77 10 10 0   6     0   3   63 43                       106 77 10 10 0   6     0   3   63 43                 106
1122082 1122082 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_5 62 4 8 0   29     0   4   58 49                       107 62 4 8 0   29     0   4   58 49                 107
1125962 1125962 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2017   grade_5 50 10 41 0   5     0   1   53 54                       107 50 10 41 0   5     0   1   53 54                 107
1126931 1126931 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_5 63 1 32 0   6     0   5   50 57                       107 63 1 32 0   6     0   5   50 57                 107
1126994 1126994 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2017   grade_5 92 1 4 0   6     0   4   56 51                       107 92 1 4 0   6     0   4   56 51                 107
1132461 1132461 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2017   grade_5 103 0 0 0   1     0   3   49 58                       107 103 0 0 0   1     0   3   49 58                 107
1123007 1123007 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_5 28 21 54 0   2     0   3   59 49                       108 28 21 54 0   2     0   3   59 49                 108
1123629 1123629 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2017   grade_5 34 50 17 0   3     1   4   64 45                       109 34 50 17 0   3     1   4   64 45                 109
1125969 1125969 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2017   grade_5 59 15 24 0   7     0   4   61 48                       109 59 15 24 0   7     0   4   61 48                 109
1129621 1129621 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No Elementary 03 05 2017   grade_5 107 0 2 0   0     0   0   56 53                       109 107 0 2 0   0     0   0   56 53                 109
1125882 1125882 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_5 2 0 9 0   0     0   0   9 2                       11 2 0 9 0   0     0   0   9 2                 11
1132413 1132413 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   grade_5 10 0 0 0   1     0   0   7 4                       11 10 0 0 0   1     0   0   7 4                 11
1132611 1132611 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_5 10 0 0 0   1     0   0   5 6                       11 10 0 0 0   1     0   0   5 6                 11
1132729 1132729 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_5 9 0 1 0   0     0   1   4 7                       11 9 0 1 0   0     0   1   4 7                 11
1124159 1124159 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_5 68 3 33 0   1     0   5   61 49                       110 68 3 33 0   1     0   5   61 49                 110
1125811 1125811 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_5 8 0 100 0   0     0   2   46 64                       110 8 0 100 0   0     0   2   46 64                 110
1128178 1128178 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Elementary 04 06 2017   grade_5 96 1 6 1   6     0   0   52 58                       110 96 1 6 1   6     0   0   52 58                 110
1131345 1131345 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_5 52 36 6 0   13     0   3   47 63                       110 52 36 6 0   13     0   3   47 63                 110
1124669 1124669 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_5 30 23 46 1   6     0   5   46 65                       111 30 23 46 1   6     0   5   46 65                 111
1125211 1125211 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_5 89 1 7 2   7     2   3   61 50                       111 89 1 7 2   7     2   3   61 50                 111
1123665 1123665 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_5 25 58 20 2   3     0   4   58 54                       112 25 58 20 2   3     0   4   58 54                 112
1126766 1126766 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_5 91 2 9 0   4     0   6   54 58                       112 91 2 9 0   4     0   6   54 58                 112
1132759 1132759 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_5 90 2 13 0   0     0   7   67 45                       112 90 2 13 0   0     0   7   67 45                 112
1127217 1127217 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2017   grade_5 87 2 10 0   7     0   7   54 59                       113 87 2 10 0   7     0   7   54 59                 113
1127970 1127970 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2017   grade_5 91 2 11 0   3     0   6   50 63                       113 91 2 11 0   3     0   6   50 63                 113
1129579 1129579 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2017   grade_5 102 2 3 0   2     1   3   56 57                       113 102 2 3 0   2     1   3   56 57                 113
1131776 1131776 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2017   grade_5 101 1 8 1   1     0   1   57 56                       113 101 1 8 1   1     0   1   57 56                 113
1127126 1127126 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 05 2017   grade_5 69 10 32 0   2     0   1   55 59                       114 69 10 32 0   2     0   1   55 59                 114
1124719 1124719 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_5 75 5 18 0   6     0   11   61 54                       115 75 5 18 0   6     0   11   61 54                 115
1128215 1128215 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2017   grade_5 112 0 1 1   0     0   1   62 53                       115 112 0 1 1   0     0   1   62 53                 115
1125806 1125806 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_5 2 3 110 0   1     0   0   57 59                       116 2 3 110 0   1     0   0   57 59                 116
1129166 1129166 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2017   grade_5 7 28 80 1   0     0   0   58 58                       116 7 28 80 1   0     0   0   58 58                 116
1129774 1129774 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2017   grade_5 95 4 7 1   6     0   3   58 58                       116 95 4 7 1   6     0   3   58 58                 116
1122075 1122075 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_5 93 4 10 0   6     0   5   57 61                       118 93 4 10 0   6     0   5   57 61                 118
1124733 1124733 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   grade_5 56 10 30 1   7     0   14   65 53                       118 56 10 30 1   7     0   14   65 53                 118
1128244 1128244 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 05 08 2017   grade_5 110 1 2 0   0     0   5   55 63                       118 110 1 2 0   0     0   5   55 63                 118
1131331 1131331 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_5 30 61 19 0   5     1   2   57 61                       118 30 61 19 0   5     1   2   57 61                 118
1132890 1132890 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2017   grade_5 108 1 5 0   1     0   3   52 66                       118 108 1 5 0   1     0   3   52 66                 118
1122105 1122105 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_5 89 5 7 0   13     0   5   68 51                       119 89 5 7 0   13     0   5   68 51                 119
1122970 1122970 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_5 22 18 30 0   45     0   4   58 61                       119 22 18 30 0   45     0   4   58 61                 119
1129960 1129960 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Elementary 04 06 2017   grade_5 103 4 5 0   0     1   6   51 68                       119 103 4 5 0   0     1   6   51 68                 119
1132092 1132092 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_5 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
1124237 1124237 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2017   grade_5 113 3 1 0   3     0   0   67 53                       120 113 3 1 0   3     0   0   67 53                 120
1125411 1125411 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_5 60 5 50 0   3     1   1   63 57                       120 60 5 50 0   3     1   1   63 57                 120
1123589 1123589 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2017   grade_5 42 55 14 0   3     0   7   65 56                       121 42 55 14 0   3     0   7   65 56                 121
1126429 1126429 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2017   grade_5 11 15 83 0   12     0   0   63 58                       121 11 15 83 0   12     0   0   63 58                 121
1128527 1128527 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   grade_5 25 2 91 0   2     0   1   53 68                       121 25 2 91 0   2     0   1   53 68                 121
1130291 1130291 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2017   grade_5 79 0 3 0   36     0   3   64 57                       121 79 0 3 0   36     0   3   64 57                 121
1125868 1125868 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_5 15 3 96 0   7     0   1   55 67                       122 15 3 96 0   7     0   1   55 67                 122
1125438 1125438 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_5 77 4 40 1   1     0   0   69 54                       123 77 4 40 1   1     0   0   69 54                 123
1127265 1127265 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_5 50 20 40 0   2     0   11   70 53                       123 50 20 40 0   2     0   11   70 53                 123
1130273 1130273 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_5 100 1 0 3   16     0   3   58 65                       123 100 1 0 3   16     0   3   58 65                 123
1124354 1124354 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_5 110 1 4 0   0     0   9   78 46                       124 110 1 4 0   0     0   9   78 46                 124
1126967 1126967 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_5 108 1 6 2   3     0   4   66 58                       124 108 1 6 2   3     0   4   66 58                 124
1123619 1123619 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_5 23 73 19 0   0     1   9   67 58                       125 23 73 19 0   0     1   9   67 58                 125
1126973 1126973 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_5 109 3 2 2   2     0   7   72 53                       125 109 3 2 2   2     0   7   72 53                 125
1127553 1127553 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2017   grade_5 114 2 3 0   0     0   6   71 54                       125 114 2 3 0   0     0   6   71 54                 125
1124024 1124024 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_5 121 1 1 0   0     0   3   78 48                       126 121 1 1 0   0     0   3   78 48                 126

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