enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 9,499 ✖
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
934026 934026 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_11 204 610 130 3   22     1   24   465 529                       994 204 610 130 3   22     1   24   465 529                 994
934027 934027 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_12 225 618 104 1   23     0   23   503 491                       994 225 618 104 1   23     0   23   503 491                 994
932762 932762 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2016   kindergarten 75 5 5 1   5     0   8   56 43                       99 75 5 5 1   5     0   8   56 43                 99
932994 932994 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No 1 KG 05 2016   grade_5 82 3 7 0   4     1   2   41 58                       99 82 3 7 0   4     1   2   41 58                 99
933763 933763 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2016   grade_9 7 70 20 0   0     0   2   57 42                       99 7 70 20 0   0     0   2   57 42                 99
934337 934337 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2016   grade_4 72 2 7 0   17     0   1   46 53                       99 72 2 7 0   17     0   1   46 53                 99
934418 934418 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2016   grade_4 64 3 25 0   1     0   6   53 46                       99 64 3 25 0   1     0   6   53 46                 99
934517 934517 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No 1 PK 05 2016   grade_5 82 4 3 0   4     0   6   43 56                       99 82 4 3 0   4     0   6   43 56                 99
934583 934583 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2016   grade_2 88 1 1 0   2     0   7   38 61                       99 88 1 1 0   2     0   7   38 61                 99
934631 934631 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2016   kindergarten 90 1 5 0   2     0   1   54 45                       99 90 1 5 0   2     0   1   54 45                 99
934851 934851 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_1 24 18 54 0   0     1   2   49 50                       99 24 18 54 0   0     1   2   49 50                 99
935398 935398 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_7 79 3 3 0   11     0   3   52 47                       99 79 3 3 0   11     0   3   52 47                 99
935491 935491 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2016   grade_2 85 1 2 0   6     0   5   51 48                       99 85 1 2 0   6     0   5   51 48                 99
935736 935736 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2016   kindergarten 6 0 92 0   1     0   0   54 45                       99 6 0 92 0   1     0   0   54 45                 99
936089 936089 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2016   grade_1 25 5 50 0   18     0   1   51 48                       99 25 5 50 0   18     0   1   51 48                 99
936141 936141 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No 1 PK 04 2016   grade_2 29 1 38 0   27     0   4   50 49                       99 29 1 38 0   27     0   4   50 49                 99
936158 936158 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No 1 PK 04 2016   grade_1 10 4 27 0   53     0   5   58 41                       99 10 4 27 0   53     0   5   58 41                 99
936227 936227 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2016   kindergarten 86 1 6 0   4     0   2   55 44                       99 86 1 6 0   4     0   2   55 44                 99
936308 936308 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2016   kindergarten 11 7 54 0   16     0   11   41 58                       99 11 7 54 0   16     0   11   41 58                 99
936414 936414 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   kindergarten 27 24 19 1   20     0   8   50 49                       99 27 24 19 1   20     0   8   50 49                 99
936597 936597 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2016   grade_9 72 2 14 1   4     0   6   50 49                       99 72 2 14 1   4     0   6   50 49                 99
936820 936820 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_12 94 2 3 0   0     0   0   66 33                       99 94 2 3 0   0     0   0   66 33                 99
936846 936846 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No 1 KG 05 2016   grade_3 80 9 5 0   3     0   2   60 39                       99 80 9 5 0   3     0   2   60 39                 99
937034 937034 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2016   kindergarten 27 11 55 1   2     0   3   54 45                       99 27 11 55 1   2     0   3   54 45                 99
937046 937046 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   grade_5 31 12 51 1   0     0   4   47 52                       99 31 12 51 1   0     0   4   47 52                 99
937150 937150 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No 1 KG 05 2016   grade_2 57 7 3 0   30     0   2   54 45                       99 57 7 3 0   30     0   2   54 45                 99
937337 937337 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No 1 KG 05 2016   grade_5 86 2 2 0   7     1   1   48 51                       99 86 2 2 0   7     1   1   48 51                 99
937703 937703 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2016   grade_6 93 0 3 0   1     0   2   48 51                       99 93 0 3 0   1     0   2   48 51                 99
937816 937816 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2016   grade_5 92 0 2 0   1     0   4   53 46                       99 92 0 2 0   1     0   4   53 46                 99
938070 938070 MA Suffolk   school 2510050 248   Revere 251005001629 2480050 Paul Revere   Regular School No 1 KG 05 2016   grade_2 47 3 40 0   5     0   4   54 45                       99 47 3 40 0   5     0   4   54 45                 99
938156 938156 MA Essex   school 2510380 258   Salem 251038000127 2580001 Salem Early Childhood   Regular School No 1 PK PK 2016   pre_kindergarten 58 13 18 0   2     0   8   58 41                       99 58 13 18 0   2     0   8   58 41                 99
938641 938641 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   grade_5 20 10 66 0   2     0   1   48 51                       99 20 10 66 0   2     0   1   48 51                 99
938992 938992 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No 1 03 05 2016   grade_3 95 1 2 0   1     0   0   57 42                       99 95 1 2 0   1     0   0   57 42                 99
939214 939214 MA Middlesex   school 2512000 308   Waltham 251200001973 3080005 William F. Stanley Elementary School   Regular School No 1 PK 05 2016   kindergarten 28 10 49 0   7     0   5   60 39                       99 28 10 49 0   7     0   5   60 39                 99
939473 939473 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_10 87 3 2 1   2     1   3   37 62                       99 87 3 2 1   2     1   3   37 62                 99
940700 940700 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_4 82 4 10 0   2     0   1   46 53                       99 82 4 10 0   2     0   1   46 53                 99
940704 940704 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_8 78 6 9 0   1     0   5   35 64                       99 78 6 9 0   1     0   5   35 64                 99
941105 941105 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No 1 PK 03 2016   grade_2 99 0 0 0   0     0   0   46 53                       99 99 0 0 0   0     0   0   46 53                 99
941109 941109 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No 1 KG 03 2016   grade_2 97 0 1 0   1     0   0   51 48                       99 97 0 1 0   1     0   0   51 48                 99
941283 941283 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_10 99 0 0 0   0     0   0   46 53                       99 99 0 0 0   0     0   0   46 53                 99
932639 932639 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_2 74 1 8 0   8     0   7   45 53                       98 74 1 8 0   8     0   7   45 53                 98
932749 932749 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_3 68 3 25 0   1     0   1   55 43                       98 68 3 25 0   1     0   1   55 43                 98
932885 932885 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 03 2016   grade_3 88 0 3 0   7     0   0   44 54                       98 88 0 3 0   7     0   0   44 54                 98
932958 932958 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 KG 05 2016   grade_1 81 4 7 0   1     0   5   51 47                       98 81 4 7 0   1     0   5   51 47                 98
933246 933246 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 07 2016   grade_4 2 30 62 0   1     0   3   50 48                       98 2 30 62 0   1     0   3   50 48                 98
933848 933848 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2016   kindergarten 88 0 5 1   3     0   1   50 48                       98 88 0 5 1   3     0   1   50 48                 98
933875 933875 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 KG 05 2016   grade_5 85 1 3 0   8     0   1   47 51                       98 85 1 3 0   8     0   1   47 51                 98
933978 933978 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_4 7 74 15 0   0     0   2   55 43                       98 7 74 15 0   0     0   2   55 43                 98
934332 934332 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No 1 KG 04 2016   grade_4 66 4 8 0   16     0   4   51 47                       98 66 4 8 0   16     0   4   51 47                 98
934495 934495 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_10 91 4 1 1   1     0   0   59 39                       98 91 4 1 1   1     0   0   59 39                 98
934828 934828 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_2 34 13 46 1   1     0   3   57 41                       98 34 13 46 1   1     0   3   57 41                 98
934884 934884 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   kindergarten 66 5 13 0   5     0   9   53 45                       98 66 5 13 0   5     0   9   53 45                 98
934905 934905 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_1 45 5 37 1   1     0   9   51 47                       98 45 5 37 1   1     0   9   51 47                 98
935015 935015 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2016   grade_2 31 5 54 0   4     0   4   50 48                       98 31 5 54 0   4     0   4   50 48                 98
935137 935137 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_2 61 13 20 0   2     0   2   44 54                       98 61 13 20 0   2     0   2   44 54                 98
935397 935397 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_6 76 2 5 0   14     0   1   46 52                       98 76 2 5 0   14     0   1   46 52                 98
935403 935403 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_12 91 0 1 0   6     0   0   53 45                       98 91 0 1 0   6     0   0   53 45                 98
935626 935626 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_10 5 2 90 0   1     0   0   65 33                       98 5 2 90 0   1     0   0   65 33                 98
935637 935637 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_6 90 2 5 0   0     0   1   47 51                       98 90 2 5 0   0     0   1   47 51                 98
935892 935892 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2016   kindergarten 82 8 3 0   5     0   0   64 34                       98 82 8 3 0   5     0   0   64 34                 98
935929 935929 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No 1 KG 05 2016   grade_4 47 5 40 0   5     0   1   54 44                       98 47 5 40 0   5     0   1   54 44                 98
936079 936079 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2016   grade_2 33 4 20 0   34     0   7   49 49                       98 33 4 20 0   34     0   7   49 49                 98
936085 936085 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers Early Learning Center   Regular School No 1 PK 03 2016   grade_2 34 8 36 0   17     0   3   49 49                       98 34 8 36 0   17     0   3   49 49                 98
936124 936124 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2016   grade_2 24 2 13 0   56     0   3   62 36                       98 24 2 13 0   56     0   3   62 36                 98
936598 936598 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2016   grade_10 75 5 11 0   4     0   3   38 60                       98 75 5 11 0   4     0   3   38 60                 98
936924 936924 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No 1 KG 04 2016   grade_2 78 5 4 0   8     0   3   46 52                       98 78 5 4 0   8     0   3   46 52                 98
936969 936969 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2016   kindergarten 72 3 4 0   11     0   8   50 48                       98 72 3 4 0   11     0   8   50 48                 98
937044 937044 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   grade_3 25 14 49 2   0     0   8   55 43                       98 25 14 49 2   0     0   8   55 43                 98
937287 937287 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_8 84 6 5 0   0     0   3   55 43                       98 84 6 5 0   0     0   3   55 43                 98
938118 938118 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2016   grade_2 67 6 19 0   2     0   4   49 49                       98 67 6 19 0   2     0   4   49 49                 98
938239 938239 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2016   grade_2 65 6 19 1   4     0   3   44 54                       98 65 6 19 1   4     0   3   44 54                 98
938400 938400 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No 1 KG 05 2016   grade_5 88 3 4 0   0     0   3   52 46                       98 88 3 4 0   0     0   3   52 46                 98
938639 938639 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   grade_3 17 19 57 0   4     0   1   50 48                       98 17 19 57 0   4     0   1   50 48                 98
938658 938658 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No 1 PK 05 2016   kindergarten 15 17 63 0   0     0   3   43 55                       98 15 17 63 0   0     0   3   43 55                 98
938747 938747 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   kindergarten 3 17 75 0   2     0   1   48 50                       98 3 17 75 0   2     0   1   48 50                 98
938751 938751 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   grade_3 0 11 87 0   0     0   0   41 57                       98 0 11 87 0   0     0   0   41 57                 98
938752 938752 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   grade_4 5 12 81 0   0     0   0   57 41                       98 5 12 81 0   0     0   0   57 41                 98
938757 938757 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_9 25 27 43 0   2     0   1   49 49                       98 25 27 43 0   2     0   1   49 49                 98
938760 938760 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_12 21 24 51 0   1     0   1   50 48                       98 21 24 51 0   1     0   1   50 48                 98
938779 938779 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_6 13 24 59 0   2     0   0   66 32                       98 13 24 59 0   2     0   0   66 32                 98
938994 938994 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No 1 03 05 2016   grade_5 89 2 5 0   0     0   2   51 47                       98 89 2 5 0   0     0   2   51 47                 98
939265 939265 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No 1 PK 03 2016   grade_2 87 1 6 0   0     0   4   60 38                       98 87 1 6 0   0     0   4   60 38                 98
939310 939310 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No 1 PK 05 2016   grade_1 64 3 14 0   8     0   9   43 55                       98 64 3 14 0   8     0   9   43 55                 98
939332 939332 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No 1 KG 05 2016   grade_3 75 7 1 0   10     0   5   41 57                       98 75 7 1 0   10     0   5   41 57                 98
939874 939874 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No 1 PK 05 2016   pre_kindergarten 66 7 7 1   13     0   4   61 37                       98 66 7 7 1   13     0   4   61 37                 98
939912 939912 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_2 26 20 45 0   5     0   2   62 36                       98 26 20 45 0   5     0   2   62 36                 98
940016 940016 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   grade_6 31 10 32 0   19     0   6   65 33                       98 31 10 32 0   19     0   6   65 33                 98
940602 940602 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes 1 KG 05 2016   grade_3 65 8 19 0   6     0   0   51 47                       98 65 8 19 0   6     0   0   51 47                 98
940935 940935 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 1 03 05 2016   grade_5 87 2 5 0   0     0   4   45 53                       98 87 2 5 0   0     0   4   45 53                 98
941010 941010 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2016   grade_1 77 7 4 1   1     0   8   50 48                       98 77 7 4 1   1     0   8   50 48                 98
941102 941102 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No 1 PK 03 2016   kindergarten 92 2 3 0   1     0   0   48 50                       98 92 2 3 0   1     0   0   48 50                 98
941412 941412 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No 1 PK 05 2016   grade_3 81 0 5 0   11     0   1   54 44                       98 81 0 5 0   11     0   1   54 44                 98
941666 941666 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_5 90 0 7 0   1     0   0   61 37                       98 90 0 7 0   1     0   0   61 37                 98
941751 941751 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No 1 KG 04 2016   grade_2 87 1 5 0   0     0   5   56 42                       98 87 1 5 0   0     0   5   56 42                 98
941813 941813 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2016   grade_8 88 3 6 0   1     0   0   55 43                       98 88 3 6 0   1     0   0   55 43                 98
941983 941983 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   grade_3 2 51 42 0   0     0   3   50 48                       98 2 51 42 0   0     0   3   50 48                 98
932638 932638 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_1 74 7 5 1   4     0   6   47 50                       97 74 7 5 1   4     0   6   47 50                 97
932883 932883 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 03 2016   grade_1 92 1 1 0   2     0   1   44 53                       97 92 1 1 0   2     0   1   44 53                 97
932957 932957 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 KG 05 2016   kindergarten 80 0 9 0   0     0   8   55 42                       97 80 0 9 0   0     0   8   55 42                 97
933357 933357 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   grade_3 0 71 25 0   0     0   1   47 50                       97 0 71 25 0   0     0   1   47 50                 97

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