enrollments

Data source: Big Local News · About: Big Local

973 rows where grade = "grade_2", state = "MA" and year = 2016 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 973 ✖

grade ✖

  • grade_2 · 973 ✖
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
935366 935366 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 4                       5                         1 4                 5
936162 936162 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_2 * * * *   *     *   *   1 *                       1                         1                   1
938152 938152 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   2 2                       4                         2 2                 4
938260 938260 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2016   grade_2 * * * *   *     *   *   3 1                       4                         3 1                 4
941364 941364 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 1                       2                         1 1                 2
941525 941525 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 4                       5                         1 4                 5
941540 941540 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   2 2                       4                         2 2                 4
932554 932554 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_2 108 0 0 0   0     0   0   62 46                       108 108 0 0 0   0     0   0   62 46                 108
932564 932564 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2016   grade_2 51 0 7 0   1     0   3   29 33                       62 51 0 7 0   1     0   3   29 33                 62
932569 932569 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2016   grade_2 72 0 6 0   4     0   4   44 42                       86 72 0 6 0   4     0   4   44 42                 86
932652 932652 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No 1 KG 05 2016   grade_2 39 0 1 1   13     0   1   38 17                       55 39 0 1 1   13     0   1   38 17                 55
932936 932936 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2016   grade_2 103 0 0 0   0     0   4   53 54                       107 103 0 0 0   0     0   4   53 54                 107
932946 932946 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_2 23 0 2 0   1     0   0   16 10                       26 23 0 2 0   1     0   0   16 10                 26
932965 932965 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No 1 KG 05 2016   grade_2 51 0 3 0   1     0   2   35 22                       57 51 0 3 0   1     0   2   35 22                 57
933003 933003 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No 1 KG 05 2016   grade_2 52 0 1 0   2     0   0   31 24                       55 52 0 1 0   2     0   0   31 24                 55
933021 933021 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No 1 KG 05 2016   grade_2 22 0 4 0   2     0   3   22 9                       31 22 0 4 0   2     0   3   22 9                 31
933129 933129 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2016   grade_2 20 0 42 0   1     0   0   29 34                       63 20 0 42 0   1     0   0   29 34                 63
933136 933136 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   grade_2 7 0 5 0   0     0   0   5 7                       12 7 0 5 0   0     0   0   5 7                 12
933832 933832 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_2 65 0 0 1   1     0   0   33 34                       67 65 0 0 1   1     0   0   33 34                 67
933859 933859 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2016   grade_2 37 0 1 0   1     0   1   20 20                       40 37 0 1 0   1     0   1   20 20                 40
933914 933914 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   grade_2 72 0 4 0   1     0   5   44 38                       82 72 0 4 0   1     0   5   44 38                 82
934040 934040 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_2 32 0 2 0   0     0   2   15 21                       36 32 0 2 0   0     0   2   15 21                 36
934295 934295 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_2 62 0 1 0   7     0   4   41 33                       74 62 0 1 0   7     0   4   41 33                 74
934388 934388 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2016   grade_2 46 0 19 0   5     1   2   41 32                       73 46 0 19 0   5     1   2   41 32                 73
934462 934462 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_2 28 0 0 0   0     0   1   14 15                       29 28 0 0 0   0     0   1   14 15                 29
934524 934524 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_2 17 0 1 0   0     0   0   12 6                       18 17 0 1 0   0     0   0   12 6                 18
934577 934577 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2016   grade_2 60 0 1 0   0     0   4   30 35                       65 60 0 1 0   0     0   4   30 35                 65
934626 934626 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2016   grade_2 42 0 5 0   1     0   5   25 28                       53 42 0 5 0   1     0   5   25 28                 53
934634 934634 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2016   grade_2 78 0 0 0   1     0   3   44 38                       82 78 0 0 0   1     0   3   44 38                 82
934691 934691 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2016   grade_2 206 0 9 0   2     0   5   114 108                       222 206 0 9 0   2     0   5   114 108                 222
934728 934728 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2016   grade_2 34 0 4 0   2     0   0   25 15                       40 34 0 4 0   2     0   0   25 15                 40
934733 934733 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2016   grade_2 38 0 3 0   1     0   2   26 18                       44 38 0 3 0   1     0   2   26 18                 44
934773 934773 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No 1 PK 02 2016   grade_2 46 0 5 0   2     0   1   31 23                       54 46 0 5 0   2     0   1   31 23                 54
934796 934796 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_2 13 0 0 0   0     0   3   11 5                       16 13 0 0 0   0     0   3   11 5                 16
934867 934867 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No 1 PK 05 2016   grade_2 55 0 7 0   2     0   5   39 30                       69 55 0 7 0   2     0   5   39 30                 69
934995 934995 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_2 78 0 3 3   3     0   5   50 42                       92 78 0 3 3   3     0   5   50 42                 92
935060 935060 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_2 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
935069 935069 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2016   grade_2 52 0 2 0   2     1   0   26 31                       57 52 0 2 0   2     1   0   26 31                 57
935181 935181 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2016   grade_2 46 0 3 1   3     0   0   31 22                       53 46 0 3 1   3     0   0   31 22                 53
935253 935253 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_2 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
935259 935259 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_2 34 0 5 0   0     1   1   21 20                       41 34 0 5 0   0     1   1   21 20                 41
935307 935307 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2016   grade_2 39 0 4 0   3     0   2   27 21                       48 39 0 4 0   3     0   2   27 21                 48
935318 935318 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 04 2016   grade_2 40 0 8 0   0     0   4   24 28                       52 40 0 8 0   0     0   4   24 28                 52
935329 935329 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 04 2016   grade_2 27 0 9 0   0     0   9   23 22                       45 27 0 9 0   0     0   9   23 22                 45
935345 935345 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_2 36 0 3 0   1     1   1   20 22                       42 36 0 3 0   1     1   1   20 22                 42
935378 935378 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   grade_2 103 0 2 0   0     0   0   52 53                       105 103 0 2 0   0     0   0   52 53                 105
935407 935407 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_2 33 0 3 0   0     0   0   17 19                       36 33 0 3 0   0     0   0   17 19                 36
935464 935464 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2016   grade_2 32 0 11 0   0     0   2   12 33                       45 32 0 11 0   0     0   2   12 33                 45
935485 935485 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2016   grade_2 87 0 1 0   2     0   1   55 36                       91 87 0 1 0   2     0   1   55 36                 91
935497 935497 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2016   grade_2 81 0 4 0   1     0   2   38 50                       88 81 0 4 0   1     0   2   38 50                 88
935532 935532 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_2 18 0 0 0   1     0   0   10 9                       19 18 0 0 0   1     0   0   10 9                 19
935557 935557 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   grade_2 17 0 30 0   2     0   2   29 22                       51 17 0 30 0   2     0   2   29 22                 51
935633 935633 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_2 79 0 4 0   0     1   1   49 36                       85 79 0 4 0   0     1   1   49 36                 85
935662 935662 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2016   grade_2 46 0 2 0   1     0   2   28 23                       51 46 0 2 0   1     0   2   28 23                 51
935673 935673 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2016   grade_2 100 0 8 0   2     0   2   54 58                       112 100 0 8 0   2     0   2   54 58                 112
935723 935723 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2016   grade_2 137 0 2 1   1     0   1   71 71                       142 137 0 2 1   1     0   1   71 71                 142
935731 935731 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_2 31 0 0 0   1     0   1   20 13                       33 31 0 0 0   1     0   1   20 13                 33
935748 935748 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   grade_2 3 0 124 0   0     0   0   64 63                       127 3 0 124 0   0     0   0   64 63                 127
935804 935804 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_2 3 0 70 0   0     0   0   34 39                       73 3 0 70 0   0     0   0   34 39                 73
935810 935810 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_2 3 0 79 0   1     0   0   40 43                       83 3 0 79 0   1     0   0   40 43                 83
935859 935859 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_2 0 0 7 0   0     0   0   6 1                       7 0 0 7 0   0     0   0   6 1                 7
935878 935878 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   grade_2 31 0 4 0   3     0   1   16 23                       39 31 0 4 0   3     0   1   16 23                 39
935906 935906 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2016   grade_2 43 0 3 0   1     0   1   29 19                       48 43 0 3 0   1     0   1   29 19                 48
935961 935961 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_2 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
935987 935987 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2016   grade_2 51 0 2 0   22     0   11   41 45                       86 51 0 2 0   22     0   11   41 45                 86
936049 936049 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2016   grade_2 64 0 4 0   19     2   3   43 49                       92 64 0 4 0   19     2   3   43 49                 92
936322 936322 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2016   grade_2 16 0 2 1   0     0   1   10 10                       20 16 0 2 1   0     0   1   10 10                 20
936474 936474 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No 1 02 03 2016   grade_2 74 0 6 0   2     0   1   42 41                       83 74 0 6 0   2     0   1   42 41                 83
936496 936496 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2016   grade_2 53 0 0 0   1     0   3   27 30                       57 53 0 0 0   1     0   3   27 30                 57
936528 936528 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2016   grade_2 34 0 0 0   0     0   1   25 10                       35 34 0 0 0   0     0   1   25 10                 35
936534 936534 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2016   grade_2 50 0 3 0   0     0   2   31 24                       55 50 0 3 0   0     0   2   31 24                 55
936541 936541 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2016   grade_2 44 0 0 0   1     0   0   23 22                       45 44 0 0 0   1     0   0   23 22                 45
936547 936547 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2016   grade_2 62 0 4 0   1     0   0   32 35                       67 62 0 4 0   1     0   0   32 35                 67
936582 936582 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No 1 PK 03 2016   grade_2 55 0 1 0   1     0   2   34 25                       59 55 0 1 0   1     0   2   34 25                 59
936686 936686 MA Middlesex   school 2507620 178   Melrose 250762001192 1780020 Lincoln   Regular School No 1 KG 05 2016   grade_2 57 0 4 0   2     0   6   35 34                       69 57 0 4 0   2     0   6   35 34                 69
936692 936692 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2016   grade_2 38 0 0 0   1     0   3   20 22                       42 38 0 0 0   1     0   3   20 22                 42
936825 936825 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2016   grade_2 70 0 6 0   1     0   1   36 42                       78 70 0 6 0   1     0   1   36 42                 78
936888 936888 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2016   grade_2 11 0 0 0   1     0   0   6 6                       12 11 0 0 0   1     0   0   6 6                 12
936929 936929 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2016   grade_2 66 0 3 0   4     0   1   35 39                       74 66 0 3 0   4     0   1   35 39                 74
936965 936965 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 William Mitchell   Regular School No 1 KG 05 2016   grade_2 68 0 4 0   6     0   1   39 40                       79 68 0 4 0   6     0   1   39 40                 79
937088 937088 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No 1 KG 05 2016   grade_2 29 0 6 0   1     0   1   21 16                       37 29 0 6 0   1     0   1   21 16                 37
937192 937192 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No 1 KG 05 2016   grade_2 75 0 3 0   9     0   4   49 42                       91 75 0 3 0   9     0   4   49 42                 91
937272 937272 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2016   grade_2 32 0 2 0   0     1   3   22 16                       38 32 0 2 0   0     1   3   22 16                 38
937296 937296 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No 1 PK 05 2016   grade_2 20 0 6 0   1     0   3   20 10                       30 20 0 6 0   1     0   3   20 10                 30
937308 937308 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No 1 KG 05 2016   grade_2 44 0 10 0   1     0   5   22 38                       60 44 0 10 0   1     0   5   22 38                 60
937314 937314 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No 1 KG 05 2016   grade_2 25 0 6 0   2     0   3   20 16                       36 25 0 6 0   2     0   3   20 16                 36
937346 937346 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No 1 KG 05 2016   grade_2 78 0 6 0   5     0   4   41 52                       93 78 0 6 0   5     0   4   41 52                 93
937416 937416 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No 1 KG 05 2016   grade_2 23 0 4 0   6     0   2   22 13                       35 23 0 4 0   6     0   2   22 13                 35
937423 937423 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No 1 PK 05 2016   grade_2 29 0 6 0   9     0   2   18 28                       46 29 0 6 0   9     0   2   18 28                 46
937430 937430 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2016   grade_2 172 0 20 0   1     0   6   115 84                       199 172 0 20 0   1     0   6   115 84                 199
937461 937461 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No 1 PK 05 2016   grade_2 41 0 3 0   7     0   2   23 30                       53 41 0 3 0   7     0   2   23 30                 53
937467 937467 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No 1 KG 05 2016   grade_2 72 0 4 0   3     0   2   29 52                       81 72 0 4 0   3     0   2   29 52                 81
937473 937473 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No 1 PK 05 2016   grade_2 58 0 0 0   4     0   0   29 33                       62 58 0 0 0   4     0   0   29 33                 62
937505 937505 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No 1 PK 05 2016   grade_2 66 0 0 1   0     0   2   38 31                       69 66 0 0 1   0     0   2   38 31                 69
937512 937512 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2016   grade_2 72 0 2 0   2     0   2   43 35                       78 72 0 2 0   2     0   2   43 35                 78
937529 937529 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_2 21 0 5 0   3     0   2   15 16                       31 21 0 5 0   3     0   2   15 16                 31
937577 937577 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2016   grade_2 41 0 1 0   3     0   0   27 18                       45 41 0 1 0   3     0   0   27 18                 45
937623 937623 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No 1 KG 05 2016   grade_2 49 0 2 0   1     0   2   26 28                       54 49 0 2 0   1     0   2   26 28                 54
937642 937642 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No 1 PK 05 2016   grade_2 36 0 2 0   1     0   2   26 15                       41 36 0 2 0   1     0   2   26 15                 41
937663 937663 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No 1 PK 05 2016   grade_2 33 0 2 0   0     0   0   20 15                       35 33 0 2 0   0     0   0   20 15                 35

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