enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,579 ✖
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
737546 737546 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_4 42 2 15 0   0     0   3   25 37                       62 42 2 15 0   0     0   3   25 37                 62
737570 737570 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_4 29 2 33 0   0     0   5   41 28                       69 29 2 33 0   0     0   5   41 28                 69
737604 737604 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_4 16 0 0 0   0     0   0   8 8                       16 16 0 0 0   0     0   0   8 8                 16
737614 737614 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_4 101 3 24 0   0     0   1   69 60                       129 101 3 24 0   0     0   1   69 60                 129
737667 737667 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_4 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
737680 737680 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No 1 KG 05 2015   grade_4 58 1 5 0   0     0   0   27 37                       64 58 1 5 0   0     0   0   27 37                 64
737720 737720 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_4 59 2 3 0   0     0   2   36 30                       66 59 2 3 0   0     0   2   36 30                 66
737876 737876 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2015   grade_4 33 1 3 0   0     0   0   20 17                       37 33 1 3 0   0     0   0   20 17                 37
737936 737936 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_4 25 1 5 0   0     0   4   16 19                       35 25 1 5 0   0     0   4   16 19                 35
737946 737946 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_4 14 0 1 0   0     0   0   8 7                       15 14 0 1 0   0     0   0   8 7                 15
738017 738017 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No 1 PK 05 2015   grade_4 61 0 2 0   0     0   1   33 31                       64 61 0 2 0   0     0   1   33 31                 64
738138 738138 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_4 55 5 5 1   0     0   3   29 40                       69 55 5 5 1   0     0   3   29 40                 69
738143 738143 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_4 101 4 3 0   0     0   5   58 55                       113 101 4 3 0   0     0   5   58 55                 113
738218 738218 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   grade_4 49 1 2 0   0     0   4   34 22                       56 49 1 2 0   0     0   4   34 22                 56
738285 738285 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_4 68 7 14 0   0     0   2   46 45                       91 68 7 14 0   0     0   2   46 45                 91
738397 738397 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_4 45 0 2 0   0     0   2   31 18                       49 45 0 2 0   0     0   2   31 18                 49
738416 738416 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_4 42 2 2 2   0     0   1   26 23                       49 42 2 2 2   0     0   1   26 23                 49
738450 738450 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2015   grade_4 58 0 4 0   0     0   1   41 22                       63 58 0 4 0   0     0   1   41 22                 63
738510 738510 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_4 87 0 0 0   0     1   0   53 35                       88 87 0 0 0   0     1   0   53 35                 88
738559 738559 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_4 31 0 4 0   0     0   0   19 16                       35 31 0 4 0   0     0   0   19 16                 35
738626 738626 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_4 13 0 19 0   0     0   0   11 21                       32 13 0 19 0   0     0   0   11 21                 32
738723 738723 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_4 0 3 31 0   0     0   0   13 21                       34 0 3 31 0   0     0   0   13 21                 34
738728 738728 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_4 6 2 54 0   0     0   0   40 22                       62 6 2 54 0   0     0   0   40 22                 62
738737 738737 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_4 2 1 47 0   0     0   0   29 21                       50 2 1 47 0   0     0   0   29 21                 50
738746 738746 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_4 8 0 39 0   0     0   1   19 29                       48 8 0 39 0   0     0   1   19 29                 48
738755 738755 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_4 13 1 50 0   0     0   1   33 32                       65 13 1 50 0   0     0   1   33 32                 65
738764 738764 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_4 8 3 47 1   0     0   0   32 27                       59 8 3 47 1   0     0   0   32 27                 59
738815 738815 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   grade_4 57 1 2 0   0     0   1   32 29                       61 57 1 2 0   0     0   1   32 29                 61
738841 738841 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_4 68 0 0 0   0     0   0   41 27                       68 68 0 0 0   0     0   0   41 27                 68
738855 738855 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   grade_4 61 1 2 0   0     0   2   27 39                       66 61 1 2 0   0     0   2   27 39                 66
738884 738884 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_4 18 0 0 0   0     0   1   9 10                       19 18 0 0 0   0     0   1   9 10                 19
738901 738901 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_4 1 2 123 0   0     0   0   67 59                       126 1 2 123 0   0     0   0   67 59                 126
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
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
738954 738954 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_4 8 1 130 0   0     0   0   74 65                       139 8 1 130 0   0     0   0   74 65                 139
738958 738958 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_4 1 0 58 0   0     0   0   30 29                       59 1 0 58 0   0     0   0   30 29                 59
739012 739012 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_4 3 0 12 0   0     0   0   14 1                       15 3 0 12 0   0     0   0   14 1                 15
739059 739059 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_4 52 0 2 0   0     0   0   29 25                       54 52 0 2 0   0     0   0   29 25                 54
739212 739212 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No 1 PK 05 2015   grade_4 55 0 2 0   0     0   0   33 24                       57 55 0 2 0   0     0   0   33 24                 57
739370 739370 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No 2 04 05 2015   grade_4 181 2 13 0   0     1   6   98 105                       203 181 2 13 0   0     1   6   98 105                 203
739385 739385 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_4 99 2 11 0   0     1   2   68 47                       115 99 2 11 0   0     1   2   68 47                 115
739409 739409 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_4 13 2 18 0   0     0   4   20 17                       37 13 2 18 0   0     0   4   20 17                 37
739481 739481 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_4 2 4 2 0   0     0   0   6 2                       8 2 4 2 0   0     0   0   6 2                 8
739488 739488 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No 1 PK 05 2015   grade_4 21 4 29 1   0     0   3   30 28                       58 21 4 29 1   0     0   3   30 28                 58
739686 739686 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   grade_4 46 0 0 0   0     0   0   22 24                       46 46 0 0 0   0     0   0   22 24                 46
739699 739699 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2015   grade_4 55 0 2 0   0     0   1   36 22                       58 55 0 2 0   0     0   1   36 22                 58
739705 739705 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   grade_4 77 0 2 0   0     0   1   40 40                       80 77 0 2 0   0     0   1   40 40                 80
739837 739837 MA Middlesex   school 2507620 178   Melrose 250762001190 1780017 Herbert Clark Hoover   Regular School No 1 KG 05 2015   grade_4 38 0 2 0   0     0   2   25 17                       42 38 0 2 0   0     0   2   25 17                 42
740007 740007 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2015   grade_4 63 10 5 0   0     0   3   42 39                       81 63 10 5 0   0     0   3   42 39                 81
740029 740029 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   grade_4 59 0 1 0   0     0   0   27 33                       60 59 0 1 0   0     0   0   27 33                 60
740044 740044 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_4 14 0 0 0   0     0   0   9 5                       14 14 0 0 0   0     0   0   9 5                 14
740143 740143 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No 1 KG 05 2015   grade_4 50 2 11 0   0     0   2   40 25                       65 50 2 11 0   0     0   2   40 25                 65
740157 740157 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No 1 PK 05 2015   grade_4 9 2 10 0   0     0   1   10 12                       22 9 2 10 0   0     0   1   10 12                 22
740163 740163 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No 1 KG 05 2015   grade_4 21 3 7 0   0     0   4   21 14                       35 21 3 7 0   0     0   4   21 14                 35
740170 740170 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_4 48 15 38 0   0     0   10   61 50                       111 48 15 38 0   0     0   10   61 50                 111
740176 740176 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2015   grade_4 23 8 20 0   0     0   1   29 23                       52 23 8 20 0   0     0   1   29 23                 52
740183 740183 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   grade_4 21 23 56 1   0     0   5   48 58                       106 21 23 56 1   0     0   5   48 58                 106
740188 740188 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_4 12 6 19 0   0     0   3   20 20                       40 12 6 19 0   0     0   3   20 20                 40
740194 740194 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2015   grade_4 10 3 26 0   0     0   3   24 18                       42 10 3 26 0   0     0   3   24 18                 42
740201 740201 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2015   grade_4 37 13 54 2   0     0   7   56 57                       113 37 13 54 2   0     0   7   56 57                 113
740207 740207 MA Bristol   school 2508430 201   New Bedford 250843001328 2010085 Horatio A Kempton   Regular School No 1 KG 05 2015   grade_4 13 2 2 0   0     0   1   7 11                       18 13 2 2 0   0     0   1   7 11                 18
740220 740220 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2015   grade_4 18 13 21 2   0     0   4   32 26                       58 18 13 21 2   0     0   4   32 26                 58
740227 740227 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2015   grade_4 20 8 16 0   0     0   4   28 20                       48 20 8 16 0   0     0   4   28 20                 48
740246 740246 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No 1 PK 05 2015   grade_4 7 6 10 0   0     0   0   10 13                       23 7 6 10 0   0     0   0   10 13                 23
740258 740258 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No 1 KG 05 2015   grade_4 23 1 6 0   0     0   1   21 10                       31 23 1 6 0   0     0   1   21 10                 31
740431 740431 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_4 32 2 1 0   0     1   3   21 18                       39 32 2 1 0   0     1   3   21 18                 39
740439 740439 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_4 29 0 2 0   0     0   1   17 15                       32 29 0 2 0   0     0   1   17 15                 32
740474 740474 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No 1 KG 05 2015   grade_4 47 0 11 0   0     0   5   30 33                       63 47 0 11 0   0     0   5   30 33                 63
740480 740480 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No 1 KG 05 2015   grade_4 31 0 11 0   0     0   1   24 19                       43 31 0 11 0   0     0   1   24 19                 43
740620 740620 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_4 40 1 3 0   0     0   3   28 19                       47 40 1 3 0   0     0   3   28 19                 47
740634 740634 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No 1 PK 05 2015   grade_4 49 1 1 0   0     0   1   28 24                       52 49 1 1 0   0     0   1   28 24                 52
740640 740640 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No 1 KG 05 2015   grade_4 72 1 2 0   0     0   5   36 44                       80 72 1 2 0   0     0   5   36 44                 80
740734 740734 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_4 31 2 9 2   0     0   6   24 26                       50 31 2 9 2   0     0   6   24 26                 50
740777 740777 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No 1 PK 04 2015   grade_4 107 2 10 0   0     0   9   78 50                       128 107 2 10 0   0     0   9   78 50                 128
740798 740798 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No 1 KG 05 2015   grade_4 46 1 3 0   0     0   1   38 13                       51 46 1 3 0   0     0   1   38 13                 51
740831 740831 MA Essex   school 2509360 229   Peabody 250936001502 2290035 South Memorial   Regular School No 1 PK 05 2015   grade_4 58 4 4 0   0     0   0   28 38                       66 58 4 4 0   0     0   0   28 38                 66
740838 740838 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No 1 PK 05 2015   grade_4 48 1 3 0   0     0   0   26 26                       52 48 1 3 0   0     0   0   26 26                 52
740858 740858 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   grade_4 85 3 0 0   0     0   0   46 42                       88 85 3 0 0   0     0   0   46 42                 88
740887 740887 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_4 16 0 0 0   0     0   1   9 8                       17 16 0 0 0   0     0   1   9 8                 17
740907 740907 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   grade_4 32 0 1 1   0     0   0   16 18                       34 32 0 1 1   0     0   0   16 18                 34
740914 740914 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No 1 PK 05 2015   grade_4 39 13 17 0   0     0   11   49 31                       80 39 13 17 0   0     0   11   49 31                 80
740921 740921 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2015   grade_4 30 10 4 0   0     0   9   27 26                       53 30 10 4 0   0     0   9   27 26                 53
740927 740927 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   grade_4 35 0 1 0   0     1   3   20 20                       40 35 0 1 0   0     1   3   20 20                 40
740969 740969 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No 1 KG 05 2015   grade_4 25 0 6 0   0     0   4   20 15                       35 25 0 6 0   0     0   4   20 15                 35
741006 741006 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No 1 PK 04 2015   grade_4 127 2 3 1   0     1   4   77 61                       138 127 2 3 1   0     1   4   77 61                 138
741032 741032 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_4 31 0 0 0   0     0   0   10 21                       31 31 0 0 0   0     0   0   10 21                 31
741040 741040 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_4 8 1 4 0   0     0   1   7 7                       14 8 1 4 0   0     0   1   7 7                 14
741181 741181 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2015   grade_4 64 0 0 0   0     0   1   34 31                       65 64 0 0 0   0     0   1   34 31                 65
741222 741222 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No 1 PK 05 2015   grade_4 22 3 18 0   0     0   4   19 28                       47 22 3 18 0   0     0   4   19 28                 47
741273 741273 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_4 12 0 0 0   0     0   1   6 7                       13 12 0 0 0   0     0   1   6 7                 13
741283 741283 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2015   grade_4 58 1 1 0   0     0   1   34 27                       61 58 1 1 0   0     0   1   34 27                 61
741314 741314 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No 1 PK 05 2015   grade_4 63 0 2 0   0     0   1   26 40                       66 63 0 2 0   0     0   1   26 40                 66
741335 741335 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No 1 KG 05 2015   grade_4 27 4 17 0   0     0   0   27 21                       48 27 4 17 0   0     0   0   27 21                 48
741341 741341 MA Essex   school 2510380 258   Salem 251038001654 2580005 Bentley   Regular School No 1 KG 05 2015   grade_4 13 3 11 0   0     0   1   12 16                       28 13 3 11 0   0     0   1   12 16                 28
741368 741368 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2015   grade_4 30 1 13 0   0     0   2   21 25                       46 30 1 13 0   0     0   2   21 25                 46
741401 741401 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_4 76 0 1 2   0     0   0   34 45                       79 76 0 1 2   0     0   0   34 45                 79
741440 741440 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No 1 KG 05 2015   grade_4 33 2 5 0   0     0   0   19 21                       40 33 2 5 0   0     0   0   19 21                 40
741461 741461 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2015   grade_4 46 2 2 0   0     0   0   24 26                       50 46 2 2 0   0     0   0   24 26                 50
741483 741483 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2015   grade_4 39 1 0 0   0     0   0   22 18                       40 39 1 0 0   0     0   0   22 18                 40
741582 741582 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_4 12 0 0 0   0     0   2   7 7                       14 12 0 0 0   0     0   2   7 7                 14

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