enrollments

Data source: Big Local News · About: Big Local

979 rows where grade = "grade_1", state = "MA" and year = 2019 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 979 ✖

grade ✖

  • grade_1 · 979 ✖
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
2042765 2042765 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2043143 2043143 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2043542 2043542 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2019   grade_1 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2039867 2039867 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_1 59 0 7 0   0     0   5   42 29                       71.0 59 0 7 0   0     0   5   42 29                 71
2039964 2039964 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_1 61 0 1 0   9     0   9   42 38                       80.0 61 0 1 0   9     0   9   42 38                 80
2039970 2039970 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_1 57 0 3 0   7     0   5   41 31                       72.0 57 0 3 0   7     0   5   41 31                 72
2040072 2040072 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   grade_1 62 0 7 0   2     0   4   37 38                       75.0 62 0 7 0   2     0   4   37 38                 75
2040147 2040147 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2019   grade_1 144 0 12 0   3     0   6   79 86                       165.0 144 0 12 0   3     0   6   79 86                 165
2040191 2040191 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2019   grade_1 32 0 3 0   20     0   11   36 30                       66.0 32 0 3 0   20     0   11   36 30                 66
2040221 2040221 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_1 27 0 1 0   0     0   1   12 17                       29.0 27 0 1 0   0     0   1   12 17                 29
2040292 2040292 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2019   grade_1 30 0 4 0   2     0   3   26 13                       39.0 30 0 4 0   2     0   3   26 13                 39
2040725 2040725 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2019   grade_1 2 0 37 0   3     0   0   23 19                       42.0 2 0 37 0   3     0   0   23 19                 42
2041118 2041118 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   grade_1 56 0 4 0   1     0   4   26 39                       65.0 56 0 4 0   1     0   4   26 39                 65
2041133 2041133 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2019   grade_1 77 0 0 0   2     0   6   43 42                       85.0 77 0 0 0   2     0   6   43 42                 85
2041154 2041154 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2019   grade_1 44 0 3 0   16     0   1   32 32                       64.0 44 0 3 0   16     0   1   32 32                 64
2041196 2041196 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   grade_1 53 0 1 0   0     0   1   34 21                       55.0 53 0 1 0   0     0   1   34 21                 55
2041203 2041203 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_1 35 0 0 0   0     0   0   17 18                       35.0 35 0 0 0   0     0   0   17 18                 35
2041327 2041327 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_1 35 0 5 0   0     0   2   22 20                       42.0 35 0 5 0   0     0   2   22 20                 42
2041583 2041583 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_1 50 0 3 0   4     0   5   29 33                       62.0 50 0 3 0   4     0   5   29 33                 62
2041697 2041697 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2019   grade_1 26 0 6 0   0     0   2   15 19                       34.0 26 0 6 0   0     0   2   15 19                 34
2041715 2041715 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No Elementary KG 05 2019   grade_1 28 0 17 0   0     0   1   24 22                       46.0 28 0 17 0   0     0   1   24 22                 46
2041753 2041753 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_1 30 0 0 0   0     0   1   18 13                       31.0 30 0 0 0   0     0   1   18 13                 31
2041806 2041806 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No Elementary PK 05 2019   grade_1 59 0 4 0   4     0   4   34 37                       71.0 59 0 4 0   4     0   4   34 37                 71
2041816 2041816 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_1 14 0 1 0   0     0   0   8 7                       15.0 14 0 1 0   0     0   0   8 7                 15
2041848 2041848 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No Elementary KG 05 2019   grade_1 49 0 3 0   1     0   0   25 28                       53.0 49 0 3 0   1     0   0   25 28                 53
2041863 2041863 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2019   grade_1 69 0 1 0   1     0   7   40 38                       78.0 69 0 1 0   1     0   7   40 38                 78
2041895 2041895 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2019   grade_1 38 0 3 0   0     0   2   25 18                       43.0 38 0 3 0   0     0   2   25 18                 43
2041919 2041919 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2019   grade_1 51 0 1 0   0     0   2   26 28                       54.0 51 0 1 0   0     0   2   26 28                 54
2041927 2041927 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2019   grade_1 71 0 4 0   0     0   6   40 41                       81.0 71 0 4 0   0     0   6   40 41                 81
2042016 2042016 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2019   grade_1 32 0 4 1   0     0   2   19 20                       39.0 32 0 4 1   0     0   2   19 20                 39
2042027 2042027 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2019   grade_1 27 0 6 0   3     0   2   18 20                       38.0 27 0 6 0   3     0   2   18 20                 38
2042093 2042093 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_1 9 0 0 0   0     0   0   5 4                       9.0 9 0 0 0   0     0   0   5 4                 9
2042174 2042174 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No Elementary PK 05 2019   grade_1 62 0 1 1   2     0   4   40 30                       70.0 62 0 1 1   2     0   4   40 30                 70
2042363 2042363 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_1 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2042465 2042465 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_1 46 0 5 0   8     1   1   37 24                       61.0 46 0 5 0   8     1   1   37 24                 61
2042477 2042477 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_1 62 0 3 0   3     0   0   41 27                       68.0 62 0 3 0   3     0   0   41 27                 68
2042535 2042535 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_1 99 0 2 0   2     0   2   56 49                       105.0 99 0 2 0   2     0   2   56 49                 105
2042548 2042548 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_1 35 0 9 0   0     0   3   22 25                       47.0 35 0 9 0   0     0   3   22 25                 47
2042554 2042554 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_1 23 0 2 0   0     0   0   12 13                       25.0 23 0 2 0   0     0   0   12 13                 25
2042561 2042561 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   grade_1 33 0 3 0   0     0   1   20 17                       37.0 33 0 3 0   0     0   1   20 17                 37
2042588 2042588 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2019   grade_1 96 0 5 0   23     0   3   71 56                       127.0 96 0 5 0   23     0   3   71 56                 127
2042611 2042611 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_1 46 0 5 0   1     0   2   31 23                       54.0 46 0 5 0   1     0   2   31 23                 54
2042630 2042630 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_1 49 0 4 0   0     0   1   36 18                       54.0 49 0 4 0   0     0   1   36 18                 54
2042635 2042635 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2019   grade_1 34 0 13 0   0     0   4   23 28                       51.0 34 0 13 0   0     0   4   23 28                 51
2042677 2042677 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 04 2019   grade_1 66 0 0 0   0     0   0   33 33                       66.0 66 0 0 0   0     0   0   33 33                 66
2042682 2042682 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2019   grade_1 95 0 7 0   0     0   3   61 44                       105.0 95 0 7 0   0     0   3   61 44                 105
2042711 2042711 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_1 21 0 1 0   0     0   0   9 13                       22.0 21 0 1 0   0     0   0   9 13                 22
2042802 2042802 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2019   grade_1 60 0 3 0   1     0   2   34 32                       66.0 60 0 3 0   1     0   2   34 32                 66
2042808 2042808 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2019   grade_1 62 0 7 0   1     0   5   43 32                       75.0 62 0 7 0   1     0   5   43 32                 75
2042900 2042900 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_1 1 0 53 0   0     0   0   32 22                       54.0 1 0 53 0   0     0   0   32 22                 54
2042915 2042915 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_1 3 0 36 0   1     0   0   25 15                       40.0 3 0 36 0   1     0   0   25 15                 40
2042976 2042976 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2019   grade_1 33 0 8 0   1     0   1   27 16                       43.0 33 0 8 0   1     0   1   27 16                 43
2043038 2043038 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   grade_1 139 0 5 1   2     0   0   77 70                       147.0 139 0 5 1   2     0   0   77 70                 147
2043055 2043055 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_1 2 0 115 0   0     0   0   59 58                       117.0 2 0 115 0   0     0   0   59 58                 117
2043072 2043072 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   grade_1 8 0 91 0   6     0   1   55 51                       106.0 8 0 91 0   6     0   1   55 51                 106
2043110 2043110 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_1 0 0 65 0   0     0   0   37 28                       65.0 0 0 65 0   0     0   0   37 28                 65
2043116 2043116 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_1 3 0 66 0   2     0   0   34 37                       71.0 3 0 66 0   2     0   0   34 37                 71
2043155 2043155 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_1 51 0 2 0   2     0   1   30 26                       56.0 51 0 2 0   2     0   1   30 26                 56
2043184 2043184 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2019   grade_1 37 0 2 0   2     0   3   19 25                       44.0 37 0 2 0   2     0   3   19 25                 44
2043243 2043243 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_1 11 0 1 0   0     0   4   11 5                       16.0 11 0 1 0   0     0   4   11 5                 16
2043269 2043269 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2019   grade_1 40 0 3 0   14     0   11   35 33                       68.0 40 0 3 0   14     0   11   35 33                 68
2043318 2043318 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   grade_1 112 0 3 0   20     0   1   60 76                       136.0 112 0 3 0   20     0   1   60 76                 136
2043331 2043331 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_1 44 0 2 0   11     0   7   31 33                       64.0 44 0 2 0   11     0   7   31 33                 64
2043618 2043618 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2019   grade_1 16 0 4 0   4     0   2   11 15                       26.0 16 0 4 0   4     0   2   11 15                 26
2043771 2043771 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 03 2019   grade_1 52 0 6 0   0     0   3   31 30                       61.0 52 0 6 0   0     0   3   31 30                 61
2043791 2043791 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2019   grade_1 52 0 5 0   0     0   1   32 26                       58.0 52 0 5 0   0     0   1   32 26                 58
2043823 2043823 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2019   grade_1 44 0 0 0   0     0   0   24 20                       44.0 44 0 0 0   0     0   0   24 20                 44
2043829 2043829 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2019   grade_1 46 0 1 0   0     0   1   22 26                       48.0 46 0 1 0   0     0   1   22 26                 48
2043878 2043878 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2019   grade_1 51 0 4 0   2     0   3   26 34                       60.0 51 0 4 0   2     0   3   26 34                 60
2043957 2043957 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2019   grade_1 140 0 4 0   3     1   2   72 78                       150.0 140 0 4 0   3     1   2   72 78                 150
2043984 2043984 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No Elementary KG 05 2019   grade_1 43 0 0 0   0     0   5   20 28                       48.0 43 0 0 0   0     0   5   20 28                 48
2044180 2044180 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_1 14 0 0 0   0     0   0   8 6                       14.0 14 0 0 0   0     0   0   8 6                 14
2044206 2044206 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2019   grade_1 42 0 7 1   30     0   8   43 45                       88.0 42 0 7 1   30     0   8   43 45                 88
2044251 2044251 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Hillside Elementary   Regular School No Elementary KG 05 2019   grade_1 66 0 2 0   11     0   7   46 40                       86.0 66 0 2 0   11     0   7   46 40                 86
2044492 2044492 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2019   grade_1 50 0 2 0   9     0   7   33 35                       68.0 50 0 2 0   9     0   7   33 35                 68
2044517 2044517 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 John Ward   Regular School No Elementary KG 05 2019   grade_1 31 0 2 0   3     0   3   25 14                       39.0 31 0 2 0   3     0   3   25 14                 39
2044565 2044565 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2019   grade_1 29 0 2 1   0     0   5   20 17                       37.0 29 0 2 1   0     0   5   20 17                 37
2044581 2044581 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_1 28 0 3 0   0     0   3   16 18                       34.0 28 0 3 0   0     0   3   16 18                 34
2044596 2044596 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2019   grade_1 33 0 9 0   4     0   2   22 26                       48.0 33 0 9 0   4     0   2   22 26                 48
2044609 2044609 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No Elementary PK 05 2019   grade_1 28 0 10 0   0     0   6   23 21                       44.0 28 0 10 0   0     0   6   23 21                 44
2044650 2044650 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2019   grade_1 33 0 6 0   2     0   0   22 19                       41.0 33 0 6 0   2     0   0   22 19                 41
2044681 2044681 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2019   grade_1 32 0 1 0   2     0   0   18 17                       35.0 32 0 1 0   2     0   0   18 17                 35
2044701 2044701 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No Elementary KG 05 2019   grade_1 29 0 0 1   9     0   1   19 21                       40.0 29 0 0 1   9     0   1   19 21                 40
2044707 2044707 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No Elementary KG 05 2019   grade_1 29 0 3 0   0     0   6   23 15                       38.0 29 0 3 0   0     0   6   23 15                 38
2044713 2044713 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No Elementary KG 05 2019   grade_1 26 0 7 0   1     0   1   16 19                       35.0 26 0 7 0   1     0   1   16 19                 35
2044719 2044719 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No Elementary KG 05 2019   grade_1 32 0 1 0   5     0   2   26 14                       40.0 32 0 1 0   5     0   2   26 14                 40
2044732 2044732 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2019   grade_1 125 0 21 0   0     0   7   90 63                       153.0 125 0 21 0   0     0   7   90 63                 153
2044764 2044764 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No Elementary KG 05 2019   grade_1 61 0 2 0   3     0   5   40 31                       71.0 61 0 2 0   3     0   5   40 31                 71
2044770 2044770 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No Elementary KG 05 2019   grade_1 41 0 3 0   4     1   2   27 24                       51.0 41 0 3 0   4     1   2   27 24                 51
2044804 2044804 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No Elementary PK 05 2019   grade_1 71 0 1 0   5     0   2   46 33                       79.0 71 0 1 0   5     0   2   46 33                 79
2044811 2044811 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2019   grade_1 77 0 2 0   0     0   4   45 38                       83.0 77 0 2 0   0     0   4   45 38                 83
2044923 2044923 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2019   grade_1 31 0 0 0   0     0   0   18 13                       31.0 31 0 0 0   0     0   0   18 13                 31
2044977 2044977 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2019   grade_1 9 0 2 0   1     0   1   10 3                       13.0 9 0 2 0   1     0   1   10 3                 13
2044991 2044991 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_1 55 0 0 0   1     0   1   25 32                       57.0 55 0 0 0   1     0   1   25 32                 57
2045013 2045013 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_1 7 0 2 0   0     0   0   7 2                       9.0 7 0 2 0   0     0   0   7 2                 9
2045096 2045096 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No Elementary KG 05 2019   grade_1 29 0 5 0   1     0   2   16 21                       37.0 29 0 5 0   1     0   2   16 21                 37
2045120 2045120 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No Elementary KG 05 2019   grade_1 34 0 3 0   0     0   1   11 27                       38.0 34 0 3 0   0     0   1   11 27                 38
2045158 2045158 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_1 32 0 1 0   0     0   0   17 16                       33.0 32 0 1 0   0     0   0   17 16                 33
2045307 2045307 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No Elementary KG 05 2019   grade_1 50 0 2 0   7     0   1   32 28                       60.0 50 0 2 0   7     0   1   32 28                 60
2045313 2045313 MA Middlesex   school 2509990 246   Reading 250999001609 2460010 Joshua Eaton   Regular School No Elementary KG 05 2019   grade_1 50 0 4 0   6     0   4   31 33                       64.0 50 0 4 0   6     0   4   31 33                 64

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