enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1124814 1124814 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1124922 1124922 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_2 * * * *   *     *   *   2 3                       *                         2 3                  
1125188 1125188 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125262 1125262 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125317 1125317 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_2 * * * *   *     *   *   2 1                       *                         2 1                  
1125422 1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1126247 1126247 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126349 1126349 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_2 * * * *   *     *   *   1 1                       *                         1 1                  
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1132608 1132608 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_2 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
1122788 1122788 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_2 32 29 23 0   14     0   2   54 46                       100 32 29 23 0   14     0   2   54 46                 100
1124351 1124351 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_2 85 1 6 0   1     0   7   54 46                       100 85 1 6 0   1     0   7   54 46                 100
1126163 1126163 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No Elementary PK 04 2017   grade_2 23 6 54 0   16     0   1   58 42                       100 23 6 54 0   16     0   1   58 42                 100
1126202 1126202 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2017   grade_2 23 5 8 0   61     0   3   47 53                       100 23 5 8 0   61     0   3   47 53                 100
1126964 1126964 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_2 85 1 1 0   2     1   10   64 36                       100 85 1 1 0   2     1   10   64 36                 100
1132430 1132430 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2017   grade_2 89 0 5 0   0     0   6   49 51                       100 89 0 5 0   0     0   6   49 51                 100
1123602 1123602 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_2 22 58 13 0   2     1   5   55 46                       101 22 58 13 0   2     1   5   55 46                 101
1124980 1124980 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_2 73 7 11 0   7     0   3   57 44                       101 73 7 11 0   7     0   3   57 44                 101
1132755 1132755 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_2 89 1 8 0   1     0   2   52 49                       101 89 1 8 0   1     0   2   52 49                 101
1121968 1121968 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_2 92 1 6 0   0     0   3   44 58                       102 92 1 6 0   0     0   3   44 58                 102
1132017 1132017 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary KG 04 2017   grade_2 89 2 3 0   2     0   6   48 54                       102 89 2 3 0   2     0   6   48 54                 102
1123662 1123662 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_2 12 62 17 0   1     2   9   57 46                       103 12 62 17 0   1     2   9   57 46                 103
1123728 1123728 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_2 53 5 7 0   33     0   5   49 54                       103 53 5 7 0   33     0   5   49 54                 103
1124676 1124676 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_2 20 16 64 0   0     0   3   50 53                       103 20 16 64 0   0     0   3   50 53                 103
1125015 1125015 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_2 72 9 21 0   0     0   1   52 51                       103 72 9 21 0   0     0   1   52 51                 103
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1126215 1126215 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 04 2017   grade_2 51 3 37 0   9     0   3   61 42                       103 51 3 37 0   9     0   3   61 42                 103
1126762 1126762 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2017   grade_2 77 3 11 0   3     0   9   53 50                       103 77 3 11 0   3     0   9   53 50                 103
1127214 1127214 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2017   grade_2 77 8 3 0   11     1   3   51 52                       103 77 8 3 0   11     1   3   51 52                 103
1129667 1129667 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary KG 04 2017   grade_2 64 17 16 0   1     0   5   46 57                       103 64 17 16 0   1     0   5   46 57                 103
1129771 1129771 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2017   grade_2 88 4 3 0   6     0   2   53 50                       103 88 4 3 0   6     0   2   53 50                 103
1132160 1132160 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2017   grade_2 86 1 2 0   11     0   3   48 55                       103 86 1 2 0   11     0   3   48 55                 103
1132362 1132362 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_2 85 2 7 1   0     0   8   49 54                       103 85 2 7 1   0     0   8   49 54                 103
1122925 1122925 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   grade_2 2 78 24 0   0     0   1   49 56                       105 2 78 24 0   0     0   1   49 56                 105
1124576 1124576 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2017   grade_2 89 3 6 0   1     0   6   49 56                       105 89 3 6 0   1     0   6   49 56                 105
1126665 1126665 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No Elementary KG 04 2017   grade_2 37 5 55 0   2     0   6   51 54                       105 37 5 55 0   2     0   6   51 54                 105
1127040 1127040 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 04 2017   grade_2 95 1 3 0   1     0   5   52 53                       105 95 1 3 0   1     0   5   52 53                 105
1123790 1123790 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_2 52 2 12 0   31     0   9   50 56                       106 52 2 12 0   31     0   9   50 56                 106
1126155 1126155 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary PK 05 2017   grade_2 23 8 40 0   28     0   7   50 56                       106 23 8 40 0   28     0   7   50 56                 106
1127559 1127559 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2017   grade_2 97 0 6 0   2     0   1   63 43                       106 97 0 6 0   2     0   1   63 43                 106
1129719 1129719 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2017   grade_2 97 3 2 0   1     0   3   51 55                       106 97 3 2 0   1     0   3   51 55                 106
1130550 1130550 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2017   grade_2 88 0 8 0   5     0   5   58 48                       106 88 0 8 0   5     0   5   58 48                 106
1131993 1131993 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_2 83 6 2 3   1     0   11   54 52                       106 83 6 2 3   1     0   11   54 52                 106
1132458 1132458 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2017   grade_2 93 2 3 0   5     0   3   51 55                       106 93 2 3 0   5     0   3   51 55                 106
1122102 1122102 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_2 82 1 5 0   15     0   4   50 57                       107 82 1 5 0   15     0   4   50 57                 107
1124050 1124050 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2017   grade_2 74 4 7 0   19     0   3   60 47                       107 74 4 7 0   19     0   3   60 47                 107
1126553 1126553 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_2 28 23 30 0   20     0   6   46 61                       107 28 23 30 0   20     0   6   46 61                 107
1126573 1126573 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_2 47 20 22 0   15     0   3   58 49                       107 47 20 22 0   15     0   3   58 49                 107
1127331 1127331 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   grade_2 75 10 16 0   0     0   6   52 55                       107 75 10 16 0   0     0   6   52 55                 107
1127967 1127967 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2017   grade_2 75 2 24 0   4     0   2   61 46                       107 75 2 24 0   4     0   2   61 46                 107
1129055 1129055 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 01 05 2017   grade_2 47 1 55 0   2     0   2   58 49                       107 47 1 55 0   2     0   2   58 49                 107
1129524 1129524 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_2 97 0 3 2   2     0   3   64 43                       107 97 0 3 2   2     0   3   64 43                 107
1131615 1131615 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_2 89 5 6 0   2     0   5   47 60                       107 89 5 6 0   2     0   5   47 60                 107
1132522 1132522 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2017   grade_2 96 0 4 0   1     0   6   59 48                       107 96 0 4 0   1     0   6   59 48                 107
1132946 1132946 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   grade_2 98 0 5 0   2     0   2   58 49                       107 98 0 5 0   2     0   2   58 49                 107
1123609 1123609 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_2 31 50 12 0   4     0   11   56 52                       108 31 50 12 0   4     0   11   56 52                 108
1126543 1126543 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_2 33 17 18 0   35     0   5   54 54                       108 33 17 18 0   35     0   5   54 54                 108
1128524 1128524 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   grade_2 23 3 70 0   12     0   0   46 62                       108 23 3 70 0   12     0   0   46 62                 108
1129222 1129222 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2017   grade_2 11 18 73 0   2     0   4   56 52                       108 11 18 73 0   2     0   4   56 52                 108
1129575 1129575 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2017   grade_2 96 1 2 0   3     0   6   56 52                       108 96 1 2 0   3     0   6   56 52                 108
1130366 1130366 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No Elementary KG 05 2017   grade_2 71 3 15 0   18     0   1   57 51                       108 71 3 15 0   18     0   1   57 51                 108
1127262 1127262 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_2 39 27 35 0   1     0   7   67 42                       109 39 27 35 0   1     0   7   67 42                 109
1124610 1124610 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_2 8 0 0 0   0     0   3   3 8                       11 8 0 0 0   0     0   3   3 8                 11
1129762 1129762 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_2 9 0 0 0   0     0   2   9 2                       11 9 0 0 0   0     0   2   9 2                 11
1126970 1126970 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_2 103 3 2 1   0     0   1   44 66                       110 103 3 2 1   0     0   1   44 66                 110
1122635 1122635 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 03 2017   grade_2 39 29 38 0   4     0   1   54 57                       111 39 29 38 0   4     0   1   54 57                 111
1123616 1123616 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_2 21 68 13 0   1     2   6   55 56                       111 21 68 13 0   1     2   6   55 56                 111
1124870 1124870 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_2 39 6 55 0   1     1   9   61 50                       111 39 6 55 0   1     1   9   61 50                 111
1126426 1126426 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2017   grade_2 7 15 74 0   10     1   4   50 61                       111 7 15 74 0   10     1   4   50 61                 111
1126822 1126822 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2017   grade_2 76 13 6 0   12     0   4   61 50                       111 76 13 6 0   12     0   4   61 50                 111
1128233 1128233 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 04 2017   grade_2 100 4 2 0   0     0   5   60 51                       111 100 4 2 0   0     0   5   60 51                 111
1130942 1130942 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2017   grade_2 40 28 34 0   7     0   2   58 53                       111 40 28 34 0   7     0   2   58 53                 111
1126928 1126928 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_2 51 0 51 0   4     0   6   48 64                       112 51 0 51 0   4     0   6   48 64                 112
1130554 1130554 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2017   grade_2 92 1 10 0   5     0   4   57 55                       112 92 1 10 0   5     0   4   57 55                 112
1124716 1124716 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_2 73 7 21 0   2     0   10   65 48                       113 73 7 21 0   2     0   10   65 48                 113
1128482 1128482 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_2 46 4 52 0   7     1   3   56 57                       113 46 4 52 0   7     1   3   56 57                 113
1131342 1131342 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_2 56 38 5 0   8     0   6   53 60                       113 56 38 5 0   8     0   6   53 60                 113
1126406 1126406 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2017   grade_2 8 10 85 0   10     0   2   54 61                       115 8 10 85 0   10     0   2   54 61                 115
1128226 1128226 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2017   grade_2 98 1 4 0   2     0   10   57 58                       115 98 1 4 0   2     0   10   57 58                 115
1124768 1124768 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_2 70 4 24 0   6     0   12   57 59                       116 70 4 24 0   6     0   12   57 59                 116
1126332 1126332 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2017   grade_2 100 0 8 0   0     1   7   57 59                       116 100 0 8 0   0     1   7   57 59                 116
1129673 1129673 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2017   grade_2 65 18 20 0   3     0   10   58 58                       116 65 18 20 0   3     0   10   58 58                 116
1124987 1124987 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_2 30 3 81 0   1     0   2   47 70                       117 30 3 81 0   1     0   2   47 70                 117
1128509 1128509 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2017   grade_2 34 3 75 0   3     0   2   56 61                       117 34 3 75 0   3     0   2   56 61                 117
1131328 1131328 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_2 27 62 18 0   3     0   8   63 55                       118 27 62 18 0   3     0   8   63 55                 118
1124021 1124021 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_2 114 4 1 0   0     0   0   48 71                       119 114 4 1 0   0     0   0   48 71                 119
1125331 1125331 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2017   grade_2 114 0 1 0   2     0   2   60 59                       119 114 0 1 0   2     0   2   60 59                 119
1125771 1125771 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_2 1 0 118 0   0     0   0   57 62                       119 1 0 118 0   0     0   0   57 62                 119
1127307 1127307 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_2 64 11 35 0   0     0   9   63 56                       119 64 11 35 0   0     0   9   63 56                 119
1131530 1131530 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_2 1 83 31 0   0     0   4   61 58                       119 1 83 31 0   0     0   4   61 58                 119
1128274 1128274 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_2 9 2 0 0   0     0   1   5 7                       12 9 2 0 0   0     0   1   5 7                 12
1122832 1122832 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   grade_2 4 62 50 0   4     0   0   60 60                       120 4 62 50 0   4     0   0   60 60                 120
1123626 1123626 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2017   grade_2 48 50 10 1   5     1   5   51 69                       120 48 50 10 1   5     1   5   51 69                 120
1127057 1127057 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   grade_2 110 1 1 0   5     0   3   64 56                       120 110 1 1 0   5     0   3   64 56                 120
1130346 1130346 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   grade_2 108 0 3 1   1     0   7   58 62                       120 108 0 3 1   1     0   7   58 62                 120
1131483 1131483 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_2 63 27 6 1   13     0   10   57 63                       120 63 27 6 1   13     0   10   57 63                 120
1127123 1127123 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 05 2017   grade_2 54 7 57 0   0     0   3   64 57                       121 54 7 57 0   0     0   3   64 57                 121
1130295 1130295 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2017   grade_2 60 2 1 0   51     0   7   62 59                       121 60 2 1 0   51     0   7   62 59                 121
1122316 1122316 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_2 110 3 4 1   0     0   4   58 64                       122 110 3 4 1   0     0   4   58 64                 122
1122416 1122416 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_2 97 3 0 0   15     0   7   63 59                       122 97 3 0 0   15     0   7   63 59                 122

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