enrollments

Data source: Big Local News · About: Big Local

986 rows where grade = "grade_1", state = "MA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 986 ✖

grade ✖

  • grade_1 · 986 ✖
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
1123444 1123444 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_1 * * * *   *     *   *   2 3                       *                         2 3                  
1125187 1125187 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_1 * * * *   *     *   *   * *                       *                                              
1125261 1125261 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_1 * * * *   *     *   *   * *                       *                                              
1125316 1125316 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_1 * * * *   *     *   *   3 1                       *                         3 1                  
1126446 1126446 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_1 * * * *   *     *   *   4 *                       *                         4                    
1128614 1128614 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_1 * * * *   *     *   *   1 2                       *                         1 2                  
1128749 1128749 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_1 * * * *   *     *   *   2 1                       *                         2 1                  
1132818 1132818 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   grade_1 * * * *   *     *   *   2 2                       *                         2 2                  
1131072 1131072 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_1 10 0 0 0   0     0   0   3 7                       10 10 0 0 0   0     0   0   3 7                 10
1132696 1132696 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   grade_1 9 0 0 0   0     0   1   4 6                       10 9 0 0 0   0     0   1   4 6                 10
1123608 1123608 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_1 34 41 7 0   7     0   11   48 52                       100 34 41 7 0   7     0   11   48 52                 100
1126397 1126397 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2017   grade_1 2 6 73 0   14     0   5   54 46                       100 2 6 73 0   14     0   5   54 46                 100
1127299 1127299 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2017   grade_1 28 10 54 0   0     0   8   42 58                       100 28 10 54 0   0     0   8   42 58                 100
1128312 1128312 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2017   grade_1 40 7 8 0   42     1   2   55 45                       100 40 7 8 0   42     1   2   55 45                 100
1128501 1128501 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_1 47 7 45 0   1     0   0   57 43                       100 47 7 45 0   1     0   0   57 43                 100
1128977 1128977 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2017   grade_1 29 3 62 0   5     0   1   51 49                       100 29 3 62 0   5     0   1   51 49                 100
1129324 1129324 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   grade_1 3 16 78 0   2     0   1   49 51                       100 3 16 78 0   2     0   1   49 51                 100
1123737 1123737 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_1 68 7 11 0   9     0   6   56 45                       101 68 7 11 0   9     0   6   56 45                 101
1125124 1125124 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_1 92 0 4 0   4     0   1   54 47                       101 92 0 4 0   4     0   1   54 47                 101
1125497 1125497 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 03 2017   grade_1 62 16 7 0   3     0   13   55 46                       101 62 16 7 0   3     0   13   55 46                 101
1126969 1126969 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_1 93 2 1 0   0     0   5   51 50                       101 93 2 1 0   0     0   5   51 50                 101
1122315 1122315 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_1 91 2 5 0   0     0   4   57 45                       102 91 2 5 0   0     0   4   57 45                 102
1124636 1124636 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_1 28 13 58 0   2     0   1   51 51                       102 28 13 58 0   2     0   1   51 51                 102
1124737 1124737 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   grade_1 58 7 31 0   1     0   5   40 62                       102 58 7 31 0   1     0   5   40 62                 102
1125918 1125918 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2017   grade_1 80 9 6 0   6     0   1   67 35                       102 80 9 6 0   6     0   1   67 35                 102
1126154 1126154 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary PK 05 2017   grade_1 25 8 40 0   27     0   2   52 50                       102 25 8 40 0   27     0   2   52 50                 102
1126542 1126542 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_1 39 13 9 0   35     0   6   60 42                       102 39 13 9 0   35     0   6   60 42                 102
1126963 1126963 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_1 90 4 4 0   0     0   5   60 43                       103 90 4 4 0   0     0   5   60 43                 103
1124715 1124715 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_1 68 6 16 0   6     0   8   59 45                       104 68 6 16 0   6     0   8   59 45                 104
1128299 1128299 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2017   grade_1 45 11 9 0   34     0   5   54 50                       104 45 11 9 0   34     0   5   54 50                 104
1126927 1126927 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_1 57 0 36 0   8     0   4   50 55                       105 57 0 36 0   8     0   4   50 55                 105
1130286 1130286 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2017   grade_1 78 0 1 0   24     0   2   58 47                       105 78 0 1 0   24     0   2   58 47                 105
1131080 1131080 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_1 90 1 5 0   3     1   5   52 53                       105 90 1 5 0   3     1   5   52 53                 105
1123601 1123601 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_1 38 58 6 0   0     0   4   54 52                       106 38 58 6 0   0     0   4   54 52                 106
1126389 1126389 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2017   grade_1 4 14 82 0   6     0   0   60 46                       106 4 14 82 0   6     0   0   60 46                 106
1126658 1126658 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2017   grade_1 56 6 41 0   2     0   1   61 45                       106 56 6 41 0   2     0   1   61 45                 106
1126664 1126664 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No Elementary KG 04 2017   grade_1 41 3 57 0   2     0   3   51 55                       106 41 3 57 0   2     0   3   51 55                 106
1127144 1127144 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2017   grade_1 56 2 11 0   32     0   5   61 45                       106 56 2 11 0   32     0   5   61 45                 106
1129718 1129718 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2017   grade_1 99 1 1 0   1     0   4   51 55                       106 99 1 1 0   1     0   4   51 55                 106
1131614 1131614 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_1 86 5 8 0   2     0   5   46 60                       106 86 5 8 0   2     0   5   46 60                 106
1122481 1122481 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 05 2017   grade_1 80 4 18 0   1     0   4   58 49                       107 80 4 18 0   1     0   4   58 49                 107
1127213 1127213 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2017   grade_1 77 6 6 0   10     0   8   52 55                       107 77 6 6 0   10     0   8   52 55                 107
1129221 1129221 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2017   grade_1 9 22 71 0   1     0   4   49 58                       107 9 22 71 0   1     0   4   49 58                 107
1129523 1129523 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_1 97 0 7 0   0     0   3   62 45                       107 97 0 7 0   0     0   3   62 45                 107
1132521 1132521 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2017   grade_1 90 5 7 1   0     0   4   63 44                       107 90 5 7 1   0     0   4   63 44                 107
1122831 1122831 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   grade_1 10 48 31 0   12     0   8   44 65                       109 10 48 31 0   12     0   8   44 65                 109
1123486 1123486 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2017   grade_1 96 0 5 1   3     0   4   58 51                       109 96 0 5 1   3     0   4   58 51                 109
1126425 1126425 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2017   grade_1 12 8 65 0   14     0   10   54 55                       109 12 8 65 0   14     0   10   54 55                 109
1126761 1126761 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2017   grade_1 90 0 11 0   2     0   6   56 53                       109 90 0 11 0   2     0   6   56 53                 109
1131992 1131992 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_1 86 3 8 0   3     0   9   55 54                       109 86 3 8 0   3     0   9   55 54                 109
1122415 1122415 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_1 76 4 2 0   10     0   18   62 48                       110 76 4 2 0   10     0   18   62 48                 110
1124241 1124241 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2017   grade_1 102 4 1 0   3     0   0   59 51                       110 102 4 1 0   3     0   0   59 51                 110
1125330 1125330 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2017   grade_1 105 0 2 0   2     0   1   49 61                       110 105 0 2 0   2     0   1   49 61                 110
1133124 1133124 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_1 20 25 36 0   24     0   5   47 63                       110 20 25 36 0   24     0   5   47 63                 110
1125791 1125791 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2017   grade_1 10 1 97 0   2     0   1   58 53                       111 10 1 97 0   2     0   1   58 53                 111
1126214 1126214 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 04 2017   grade_1 59 3 36 0   8     0   5   61 50                       111 59 3 36 0   8     0   5   61 50                 111
1126331 1126331 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2017   grade_1 93 2 8 0   4     0   4   61 50                       111 93 2 8 0   4     0   4   61 50                 111
1128508 1128508 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2017   grade_1 33 9 66 1   1     0   1   50 61                       111 33 9 66 1   1     0   1   50 61                 111
1132016 1132016 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary KG 04 2017   grade_1 100 0 9 0   2     0   0   56 55                       111 100 0 9 0   2     0   0   56 55                 111
1124767 1124767 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_1 62 6 27 0   6     0   11   59 53                       112 62 6 27 0   6     0   11   59 53                 112
1130365 1130365 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No Elementary KG 05 2017   grade_1 67 7 17 0   19     0   2   52 60                       112 67 7 17 0   19     0   2   52 60                 112
1131302 1131302 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_1 20 31 50 0   5     0   6   60 52                       112 20 31 50 0   5     0   6   60 52                 112
1123789 1123789 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_1 64 7 5 0   28     0   9   58 55                       113 64 7 5 0   28     0   9   58 55                 113
1129654 1129654 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2017   grade_1 90 9 6 0   1     0   7   63 50                       113 90 9 6 0   1     0   7   63 50                 113
1131327 1131327 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_1 31 55 20 0   2     0   5   54 59                       113 31 55 20 0   2     0   5   54 59                 113
1132945 1132945 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   grade_1 103 2 4 0   0     0   4   60 53                       113 103 2 4 0   0     0   4   60 53                 113
1123625 1123625 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2017   grade_1 38 54 10 0   3     0   9   48 66                       114 38 54 10 0   3     0   9   48 66                 114
1124094 1124094 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_1 10 5 97 0   0     0   2   58 56                       114 10 5 97 0   0     0   2   58 56                 114
1125206 1125206 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2017   grade_1 86 0 4 0   13     1   10   59 55                       114 86 0 4 0   13     1   10   59 55                 114
1128481 1128481 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_1 56 3 43 0   9     0   3   57 57                       114 56 3 43 0   9     0   3   57 57                 114
1130345 1130345 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   grade_1 108 0 2 0   0     0   4   67 47                       114 108 0 2 0   0     0   4   67 47                 114
1131341 1131341 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_1 43 49 3 0   10     0   9   53 61                       114 43 49 3 0   10     0   9   53 61                 114
1124729 1124729 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   grade_1 45 12 44 0   6     0   9   57 59                       116 45 12 44 0   6     0   9   57 59                 116
1126733 1126733 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_1 80 6 10 8   3     0   9   60 56                       116 80 6 10 8   3     0   9   60 56                 116
1124079 1124079 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_1 7 6 104 0   0     0   0   65 52                       117 7 6 104 0   0     0   0   65 52                 117
1127122 1127122 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 05 2017   grade_1 69 10 32 0   2     1   3   65 52                       117 69 10 32 0   2     1   3   65 52                 117
1131874 1131874 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2017   grade_1 103 2 8 0   1     0   3   70 47                       117 103 2 8 0   1     0   3   70 47                 117
1123054 1123054 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2017   grade_1 12 15 12 1   73     0   5   58 60                       118 12 15 12 1   73     0   5   58 60                 118
1126411 1126411 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_1 7 3 96 1   8     0   3   65 53                       118 7 3 96 1   8     0   3   65 53                 118
1124665 1124665 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_1 34 26 55 1   0     0   3   70 49                       119 34 26 55 1   0     0   3   70 49                 119
1124875 1124875 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_1 41 10 56 0   3     0   9   57 62                       119 41 10 56 0   3     0   9   57 62                 119
1124986 1124986 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_1 18 4 92 0   0     0   5   61 58                       119 18 4 92 0   0     0   5   61 58                 119
1125390 1125390 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2017   grade_1 74 1 43 0   0     0   1   56 63                       119 74 1 43 0   0     0   1   56 63                 119
1127138 1127138 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2017   grade_1 84 2 6 0   11     0   16   50 69                       119 84 2 6 0   11     0   16   50 69                 119
1130294 1130294 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2017   grade_1 67 1 4 0   38     0   9   53 66                       119 67 1 4 0   38     0   9   53 66                 119
1130518 1130518 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_1 11 0 1 0   0     0   0   7 5                       12 11 0 1 0   0     0   0   7 5                 12
1132088 1132088 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_1 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
1132409 1132409 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   grade_1 11 0 0 1   0     0   0   4 8                       12 11 0 0 1   0     0   0   4 8                 12
1123661 1123661 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_1 26 60 22 1   3     0   8   68 52                       120 26 60 22 1   3     0   8   68 52                 120
1125202 1125202 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2017   grade_1 91 2 4 0   22     0   1   61 59                       120 91 2 4 0   22     0   1   61 59                 120
1131482 1131482 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_1 52 28 14 0   21     0   5   62 58                       120 52 28 14 0   21     0   5   62 58                 120
1132052 1132052 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2017   grade_1 101 3 14 0   0     0   2   60 60                       120 101 3 14 0   0     0   2   60 60                 120
1132102 1132102 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2017   grade_1 108 5 0 0   1     0   6   54 66                       120 108 5 0 0   1     0   6   54 66                 120
1127022 1127022 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2017   grade_1 106 0 6 0   4     0   5   78 43                       121 106 0 6 0   4     0   5   78 43                 121
1124869 1124869 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_1 40 7 66 2   3     0   4   65 57                       122 40 7 66 2   3     0   4   65 57                 122
1126094 1126094 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2017   grade_1 106 3 2 0   8     0   3   56 66                       122 106 3 2 0   8     0   3   56 66                 122
1124020 1124020 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_1 117 2 1 0   2     0   1   67 56                       123 117 2 1 0   2     0   1   67 56                 123
1124887 1124887 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2017   grade_1 43 6 63 0   5     0   6   59 64                       123 43 6 63 0   5     0   6   59 64                 123
1125770 1125770 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_1 3 2 118 0   0     0   0   62 61                       123 3 2 118 0   0     0   0   62 61                 123
1128523 1128523 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   grade_1 33 4 76 0   7     0   3   61 62                       123 33 4 76 0   7     0   3   61 62                 123

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