enrollments

Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 9,541 ✖
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
735883 735883 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2015   grade_2 60 6 15 0   12     0   6   45 54                       99 60 6 15 0   12     0   6   45 54                 99
736496 736496 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2015   grade_4 2 41 19 0   32     0   5   56 43                       99 2 41 19 0   32     0   5   56 43                 99
736768 736768 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_1 2 32 63 0   0     1   1   46 53                       99 2 32 63 0   0     1   1   46 53                 99
736813 736813 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2015   grade_10 18 34 25 1   20     0   1   62 37                       99 18 34 25 1   20     0   1   62 37                 99
736907 736907 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_12 2 64 22 1   6     1   3   45 54                       99 2 64 22 1   6     1   3   45 54                 99
736987 736987 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_3 93 0 2 0   3     0   1   43 56                       99 93 0 2 0   3     0   1   43 56                 99
737083 737083 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2015   grade_5 44 43 6 0   0     1   5   51 48                       99 44 43 6 0   0     1   5   51 48                 99
737109 737109 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2015   grade_2 7 77 12 1   1     0   1   54 45                       99 7 77 12 1   1     0   1   54 45                 99
737622 737622 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_11 61 6 29 0   3     0   0   48 51                       99 61 6 29 0   3     0   0   48 51                 99
737623 737623 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_12 65 7 23 0   3     0   1   61 38                       99 65 7 23 0   3     0   1   61 38                 99
737635 737635 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_9 91 5 1 1   1     0   0   60 39                       99 91 5 1 1   1     0   0   60 39                 99
737657 737657 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No 1 PK 05 2015   grade_4 81 5 3 0   4     0   6   45 54                       99 81 5 3 0   4     0   6   45 54                 99
737715 737715 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2015   grade_5 92 2 1 1   0     0   3   39 60                       99 92 2 1 1   0     0   3   39 60                 99
737817 737817 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No 1 KG 05 2015   grade_4 81 1 10 1   5     0   1   47 52                       99 81 1 10 1   5     0   1   47 52                 99
737979 737979 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_5 29 18 42 1   8     0   1   53 46                       99 29 18 42 1   8     0   1   53 46                 99
738547 738547 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_6 80 3 3 0   11     0   2   53 46                       99 80 3 3 0   11     0   2   53 46                 99
738552 738552 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_11 92 0 1 0   6     0   0   54 45                       99 92 0 1 0   6     0   0   54 45                 99
738575 738575 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Crowell   Regular School No 1 KG KG 2015   kindergarten 57 2 38 0   1     0   1   50 49                       99 57 2 38 0   1     0   1   50 49                 99
738676 738676 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2015   grade_6 69 11 11 0   5     0   3   57 42                       99 69 11 11 0   5     0   3   57 42                 99
738940 738940 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_4 1 1 97 0   0     0   0   47 52                       99 1 1 97 0   0     0   0   47 52                 99
739124 739124 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_3 45 6 4 0   37     0   7   53 46                       99 45 6 4 0   37     0   7   53 46                 99
739214 739214 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2015   grade_6 73 4 5 0   12     0   5   53 46                       99 73 4 5 0   12     0   5   53 46                 99
739232 739232 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2015   grade_1 35 5 16 0   35     0   8   45 54                       99 35 5 16 0   35     0   8   45 54                 99
739240 739240 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2015   kindergarten 33 4 45 0   14     0   3   53 46                       99 33 4 45 0   14     0   3   53 46                 99
739242 739242 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2015   grade_1 24 7 51 0   10     0   7   51 48                       99 24 7 51 0   10     0   7   51 48                 99
739276 739276 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2015   grade_1 23 2 12 0   60     0   2   63 36                       99 23 2 12 0   60     0   2   63 36                 99
739565 739565 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_5 28 17 14 0   37     0   3   44 55                       99 28 17 14 0   37     0   3   44 55                 99
739574 739574 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2015   grade_5 23 29 22 1   23     0   1   41 58                       99 23 29 22 1   23     0   1   41 58                 99
739733 739733 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_11 76 2 7 7   2     1   4   41 58                       99 76 2 7 7   2     1   4   41 58                 99
739992 739992 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2015   grade_1 79 5 4 0   6     1   4   49 50                       99 79 5 4 0   6     1   4   49 50                 99
740426 740426 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2015   grade_2 88 1 7 0   0     0   3   49 50                       99 88 1 7 0   0     0   3   49 50                 99
740741 740741 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2015   grade_5 91 2 3 0   0     0   3   40 59                       99 91 2 3 0   0     0   3   40 59                 99
740874 740874 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_5 93 0 3 0   1     0   2   48 51                       99 93 0 3 0   1     0   2   48 51                 99
740956 740956 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2015   grade_4 89 0 4 0   2     0   4   57 42                       99 89 0 4 0   2     0   4   57 42                 99
740984 740984 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_1 96 0 2 0   0     0   1   45 54                       99 96 0 2 0   0     0   1   45 54                 99
741127 741127 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2015   grade_8 57 7 8 0   21     1   5   50 49                       99 57 7 8 0   21     1   5   50 49                 99
741233 741233 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_5 39 8 45 0   4     0   3   55 44                       99 39 8 45 0   4     0   3   55 44                 99
741236 741236 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   grade_2 30 6 56 1   1     0   5   45 54                       99 30 6 56 1   1     0   5   45 54                 99
741953 741953 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_11 16 22 53 0   1     0   7   52 47                       99 16 22 53 0   1     0   7   52 47                 99
741976 741976 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2015   grade_8 14 29 50 0   3     0   3   61 38                       99 14 29 50 0   3     0   3   61 38                 99
742144 742144 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2015   kindergarten 89 1 3 0   2     1   3   49 50                       99 89 1 3 0   2     1   3   49 50                 99
742185 742185 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No 1 03 05 2015   grade_5 95 0 4 0   0     0   0   53 46                       99 95 0 4 0   0     0   0   53 46                 99
742503 742503 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No 1 PK 05 2015   grade_2 76 4 5 2   9     0   3   56 43                       99 76 4 5 2   9     0   3   56 43                 99
742558 742558 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   grade_12 82 7 5 1   2     0   2   55 44                       99 82 7 5 1   2     0   2   55 44                 99
742627 742627 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 41 4 12 0   39     0   3   64 35                       99 41 4 12 0   39     0   3   64 35                 99
742808 742808 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2015   grade_1 77 2 13 0   5     0   2   48 51                       99 77 2 13 0   5     0   2   48 51                 99
743206 743206 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_5 31 9 32 0   21     0   6   65 34                       99 31 9 32 0   21     0   6   65 34                 99
743301 743301 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_2 37 16 33 0   6     0   7   51 48                       99 37 16 33 0   6     0   7   51 48                 99
743756 743756 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_10 54 26 3 0   13     0   3   43 56                       99 54 26 3 0   13     0   3   43 56                 99
744040 744040 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_8 89 1 5 0   0     0   4   53 46                       99 89 1 5 0   0     0   4   53 46                 99
744192 744192 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   kindergarten 79 4 3 2   1     0   10   51 48                       99 79 4 3 2   1     0   10   51 48                 99
744569 744569 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_5 94 1 2 0   0     1   1   52 47                       99 94 1 2 0   0     1   1   52 47                 99
744597 744597 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_5 88 0 4 0   3     0   4   42 57                       99 88 0 4 0   3     0   4   42 57                 99
744998 744998 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2015   grade_1 92 2 4 0   1     0   0   54 45                       99 92 2 4 0   1     0   0   54 45                 99
735884 735884 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2015   grade_3 61 7 15 0   9     0   6   50 48                       98 61 7 15 0   9     0   6   50 48                 98
735915 735915 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_3 77 3 8 0   6     0   4   52 46                       98 77 3 8 0   6     0   4   52 46                 98
736070 736070 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2015   grade_5 93 1 2 0   1     0   1   50 48                       98 93 1 2 0   1     0   1   50 48                 98
736495 736495 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2015   grade_3 5 44 19 0   24     1   5   47 51                       98 5 44 19 0   24     1   5   47 51                 98
736563 736563 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_8 7 45 46 0   0     0   0   56 42                       98 7 45 46 0   0     0   0   56 42                 98
736770 736770 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_3 3 22 72 0   0     0   1   43 55                       98 3 22 72 0   0     0   1   43 55                 98
737003 737003 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No 1 KG 05 2015   grade_5 79 1 4 0   14     0   0   49 49                       98 79 1 4 0   14     0   0   49 49                 98
737099 737099 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   kindergarten 43 36 10 0   3     0   6   45 53                       98 43 36 10 0   3     0   6   45 53                 98
737192 737192 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_5 54 2 9 0   22     1   10   50 48                       98 54 2 9 0   22     1   10   50 48                 98
737475 737475 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_2 78 0 5 0   14     0   1   63 35                       98 78 0 5 0   14     0   1   63 35                 98
737476 737476 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_3 77 0 4 0   15     0   2   43 55                       98 77 0 4 0   15     0   2   43 55                 98
737981 737981 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_7 38 12 38 0   7     0   3   54 44                       98 38 12 38 0   7     0   3   54 44                 98
737997 737997 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_8 44 19 30 0   5     0   0   52 46                       98 44 19 30 0   5     0   0   52 46                 98
737999 737999 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_1 26 14 53 0   2     0   3   45 53                       98 26 14 53 0   2     0   3   45 53                 98
738004 738004 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_6 30 26 39 0   1     0   2   50 48                       98 30 26 39 0   1     0   2   50 48                 98
738384 738384 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2015   grade_10 94 0 2 0   0     0   2   41 57                       98 94 0 2 0   0     0   2   41 57                 98
738484 738484 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_7 71 2 18 0   2     0   5   55 43                       98 71 2 18 0   2     0   5   55 43                 98
738580 738580 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   grade_4 56 1 36 0   3     0   2   49 49                       98 56 1 36 0   3     0   2   49 49                 98
738734 738734 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_1 2 1 92 0   2     0   1   50 48                       98 2 1 92 0   2     0   1   50 48                 98
738787 738787 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_5 88 3 5 0   1     0   1   45 53                       98 88 3 5 0   1     0   1   45 53                 98
738826 738826 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   grade_4 87 3 3 0   1     0   4   48 50                       98 87 3 3 0   1     0   4   48 50                 98
738905 738905 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_4 9 1 84 0   4     0   0   47 51                       98 9 1 84 0   4     0   0   47 51                 98
738915 738915 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   kindergarten 18 1 78 0   1     0   0   42 56                       98 18 1 78 0   1     0   0   42 56                 98
738941 738941 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_5 4 1 93 0   0     0   0   48 50                       98 4 1 93 0   0     0   0   48 50                 98
738945 738945 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_4 3 0 95 0   0     0   0   57 41                       98 3 0 95 0   0     0   0   57 41                 98
739043 739043 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   kindergarten 85 3 4 2   3     0   1   50 48                       98 85 3 4 2   3     0   1   50 48                 98
739130 739130 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_3 45 5 4 0   36     0   8   48 50                       98 45 5 4 0   36     0   8   48 50                 98
739262 739262 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   kindergarten 12 6 31 0   46     0   3   44 54                       98 12 6 31 0   46     0   3   44 54                 98
739392 739392 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_11 87 2 5 0   3     0   1   54 44                       98 87 2 5 0   3     0   1   54 44                 98
739564 739564 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_4 30 12 14 1   38     0   3   49 49                       98 30 12 14 1   38     0   3   49 49                 98
739568 739568 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_8 43 17 8 1   25     0   4   51 47                       98 43 17 8 1   25     0   4   51 47                 98
739587 739587 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2015   kindergarten 39 18 24 0   14     0   3   52 46                       98 39 18 24 0   14     0   3   52 46                 98
740033 740033 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_8 93 0 1 0   1     0   3   54 44                       98 93 0 1 0   1     0   3   54 44                 98
740068 740068 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No 1 KG 04 2015   grade_1 58 1 4 0   31     0   4   49 49                       98 58 1 4 0   31     0   4   49 49                 98
740082 740082 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2015   kindergarten 91 0 1 0   1     0   5   57 41                       98 91 0 1 0   1     0   5   57 41                 98
740233 740233 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2015   grade_3 78 8 4 0   2     0   6   58 40                       98 78 8 4 0   2     0   6   58 40                 98
740452 740452 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_8 77 4 11 0   0     0   6   41 57                       98 77 4 11 0   0     0   6   41 57                 98
740456 740456 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_12 83 2 4 0   0     2   7   48 50                       98 83 2 4 0   0     2   7   48 50                 98
740549 740549 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No 1 KG 05 2015   grade_4 90 0 1 0   5     0   2   54 44                       98 90 0 1 0   5     0   2   54 44                 98
740604 740604 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 89 0 3 0   1     0   5   55 43                       98 89 0 3 0   1     0   5   55 43                 98
740660 740660 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No 1 KG 03 2015   kindergarten 88 2 2 1   2     0   3   50 48                       98 88 2 2 1   2     0   3   50 48                 98
740720 740720 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No 1 PK KG 2015   pre_kindergarten 66 6 10 0   15     0   1   59 39                       98 66 6 10 0   15     0   1   59 39                 98
741060 741060 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_2 43 13 11 0   25     3   3   57 41                       98 43 13 11 0   25     3   3   57 41                 98
741234 741234 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   kindergarten 33 2 59 0   3     0   1   44 54                       98 33 2 59 0   3     0   1   44 54                 98
741238 741238 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   grade_4 34 6 55 0   3     0   0   56 42                       98 34 6 55 0   3     0   0   56 42                 98
741433 741433 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2015   grade_3 68 3 21 0   6     0   0   52 46                       98 68 3 21 0   6     0   0   52 46                 98

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