enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 976 ✖

grade ✖

  • grade_2 · 976 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230264 2230264 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2231639 2231639 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232017 2232017 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232130 2232130 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2235437 2235437 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2237223 2237223 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2228776 2228776 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_2 89 0 4 0   0     0   6   53 46                       99.0 89 0 4 0   0     0   6   53 46                 99
2228795 2228795 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   grade_2 63 0 1 0   1     0   0   38 27                       65.0 63 0 1 0   1     0   0   38 27                 65
2228894 2228894 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover: Henry C Sanborn Elementary   Regular School No Elementary KG 05 2018   grade_2 46 0 1 0   22     0   1   35 35                       70.0 46 0 1 0   22     0   1   35 35                 70
2228932 2228932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_2 49 0 0 0   15     2   4   32 38                       70.0 49 0 0 0   15     2   4   32 38                 70
2228939 2228939 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_2 57 0 3 0   4     0   4   33 35                       68.0 57 0 3 0   4     0   4   33 35                 68
2229183 2229183 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   grade_2 64 0 2 0   2     0   2   37 33                       70.0 64 0 2 0   2     0   2   37 33                 70
2229241 2229241 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_2 88 0 2 0   0     0   3   39 54                       93.0 88 0 2 0   0     0   3   39 54                 93
2229253 2229253 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_2 27 0 2 0   0     0   2   18 13                       31.0 27 0 2 0   0     0   2   18 13                 31
2229262 2229262 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly: Centerville Elementary   Regular School No Elementary KG 05 2018   grade_2 41 0 12 0   0     0   3   28 28                       56.0 41 0 12 0   0     0   3   28 28                 56
2229485 2229485 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston: Dante Alighieri Montessori School   Regular School No Elementary PK 05 2018   grade_2 5 0 5 0   0     0   2   6 6                       12.0 5 0 5 0   0     0   2   6 6                 12
2229831 2229831 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston: Patrick J Kennedy   Regular School No Elementary PK 05 2018   grade_2 5 0 44 0   1     0   0   33 17                       50.0 5 0 44 0   1     0   0   33 17                 50
2230305 2230305 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford: Harry Lee Cole   Regular School No Elementary PK 02 2018   grade_2 100 0 4 1   3     0   5   60 53                       113.0 100 0 4 1   3     0   5   60 53                 113
2230315 2230315 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston: Boylston Elementary   Regular School No Elementary PK 05 2018   grade_2 42 0 2 0   3     0   2   26 23                       49.0 42 0 2 0   3     0   2   26 23                 49
2230530 2230530 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 40 0 2 0   0     0   0   19 23                       42.0 40 0 2 0   0     0   0   19 23                 42
2230574 2230574 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_2 34 0 8 0   12     0   7   37 24                       61.0 34 0 8 0   12     0   7   37 24                 61
2230640 2230640 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington: Memorial   Regular School No Elementary KG 05 2018   grade_2 56 0 4 1   8     0   7   35 41                       76.0 56 0 4 1   8     0   7   35 41                 76
2230825 2230825 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_2 52 0 2 0   4     0   2   35 25                       60.0 52 0 2 0   4     0   2   35 25                 60
2230859 2230859 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford: South Row   Regular School No Elementary KG 04 2018   grade_2 56 0 11 0   8     0   2   41 36                       77.0 56 0 11 0   8     0   2   41 36                 77
2230938 2230938 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Chicopee: Barry   Regular School No Elementary KG 05 2018   grade_2 39 0 15 0   1     0   2   28 29                       57.0 39 0 15 0   1     0   2   28 29                 57
2231024 2231024 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_2 19 0 1 0   0     0   1   6 15                       21.0 19 0 1 0   0     0   1   6 15                 21
2231098 2231098 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_2 19 0 0 0   0     0   1   9 11                       20.0 19 0 0 0   0     0   1   9 11                 20
2231135 2231135 MA Essex   school 2503990 71   Danvers 250399000538 710045 Danvers: Willis E Thorpe   Regular School No Elementary KG 05 2018   grade_2 42 0 3 0   1     0   0   24 22                       46.0 42 0 3 0   1     0   0   24 22                 46
2231153 2231153 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_2 62 0 2 0   0     0   3   31 36                       67.0 62 0 2 0   0     0   3   31 36                 67
2231221 2231221 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield: Deerfield Elementary   Regular School No Elementary PK 06 2018   grade_2 34 0 2 0   0     0   2   12 26                       38.0 34 0 2 0   0     0   2   12 26                 38
2231231 2231231 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas: Douglas Elementary School   Regular School No Elementary 02 05 2018   grade_2 94 0 5 0   1     0   2   50 52                       102.0 94 0 5 0   1     0   2   50 52                 102
2231336 2231336 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton: Center School   Regular School No Elementary KG 04 2018   grade_2 31 0 7 0   0     0   2   25 15                       40.0 31 0 7 0   0     0   2   25 15                 40
2231343 2231343 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Easthampton: Maple   Regular School No Elementary PK 04 2018   grade_2 31 0 5 0   2     0   1   20 19                       39.0 31 0 5 0   2     0   1   20 19                 39
2231349 2231349 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton: Neil A Pepin   Regular School No Elementary KG 04 2018   grade_2 33 0 5 0   0     0   3   27 14                       41.0 33 0 5 0   0     0   3   27 14                 41
2231427 2231427 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_2 18 0 1 0   0     0   1   11 9                       20.0 18 0 1 0   0     0   1   11 9                 20
2231673 2231673 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth: Mullen-Hall   Regular School No Elementary KG 04 2018   grade_2 74 0 5 0   2     0   6   47 40                       87.0 74 0 5 0   2     0   6   47 40                 87
2231750 2231750 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_2 8 0 0 0   0     0   0   4 4                       8.0 8 0 0 0   0     0   0   4 4                 8
2231884 2231884 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_2 54 0 1 0   6     1   1   34 29                       63.0 54 0 1 0   6     1   1   34 29                 63
2231891 2231891 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   grade_2 39 0 1 0   3     0   1   28 16                       44.0 39 0 1 0   3     0   1   28 16                 44
2231905 2231905 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_2 33 0 0 0   0     0   0   18 15                       33.0 33 0 0 0   0     0   0   18 15                 33
2231954 2231954 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_2 93 0 4 0   3     0   0   55 45                       100.0 93 0 4 0   3     0   0   55 45                 100
2231977 2231977 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   grade_2 36 0 4 0   0     0   3   22 21                       43.0 36 0 4 0   0     0   3   22 21                 43
2231993 2231993 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester: Veterans Memorial   Regular School No Elementary KG 05 2018   grade_2 23 0 11 0   0     0   2   18 18                       36.0 23 0 11 0   0     0   2   18 18                 36
2232000 2232000 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester: West Parish   Regular School No Elementary KG 05 2018   grade_2 54 0 5 0   0     0   6   33 32                       65.0 54 0 5 0   0     0   6   33 32                 65
2232037 2232037 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_2 81 0 5 0   11     1   10   54 54                       108.0 81 0 5 0   11     1   10   54 54                 108
2232064 2232064 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 Granby: West Street   Regular School No Elementary PK 03 2018   grade_2 44 0 4 1   1     0   1   28 23                       51.0 44 0 4 1   1     0   1   28 23                 51
2232084 2232084 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield: Discovery School at Four Corners   Regular School No Elementary KG 04 2018   grade_2 42 0 5 0   0     0   0   27 20                       47.0 42 0 5 0   0     0   0   27 20                 47
2232107 2232107 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_2 24 0 5 0   0     1   2   18 14                       32.0 24 0 5 0   0     1   2   18 14                 32
2232144 2232144 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover: Center Elementary   Regular School No Elementary KG 02 2018   grade_2 111 0 2 0   2     0   1   51 65                       116.0 111 0 2 0   2     0   1   51 65                 116
2232178 2232178 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_2 22 0 2 0   1     0   0   13 12                       25.0 22 0 2 0   1     0   0   13 12                 25
2232193 2232193 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_2 25 0 10 0   0     0   0   20 15                       35.0 25 0 10 0   0     0   0   20 15                 35
2232254 2232254 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Haverhill: Walnut Square   Regular School No Elementary KG 02 2018   grade_2 42 0 8 0   0     0   1   21 30                       51.0 42 0 8 0   0     0   1   21 30                 51
2232391 2232391 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_2 2 0 72 0   0     0   1   40 35                       75.0 2 0 72 0   0     0   1   40 35                 75
2232532 2232532 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Ipswich: Paul F Doyon Memorial   Regular School No Elementary PK 05 2018   grade_2 57 0 4 0   1     0   2   32 32                       64.0 57 0 4 0   1     0   2   32 32                 64
2232556 2232556 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston: Kingston Elementary   Regular School No Elementary KG 02 2018   grade_2 161 0 4 1   0     0   0   88 78                       166.0 161 0 4 1   0     0   0   88 78                 166
2232641 2232641 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_2 4 0 77 0   0     0   0   36 45                       81.0 4 0 77 0   0     0   0   36 45                 81
2232652 2232652 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence: Edward F. Parthum   Regular School No Elementary KG 04 2018   grade_2 7 0 128 0   1     0   1   77 60                       137.0 7 0 128 0   1     0   1   77 60                 137
2232657 2232657 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_2 2 0 66 0   0     0   1   39 30                       69.0 2 0 66 0   0     0   1   39 30                 69
2232695 2232695 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_2 1 0 5 0   0     0   0   5 1                       6.0 1 0 5 0   0     0   0   5 1                 6
2232715 2232715 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   grade_2 48 0 2 0   0     0   1   30 21                       51.0 48 0 2 0   0     0   1   30 21                 51
2232822 2232822 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_2 10 0 1 0   0     0   1   7 5                       12.0 10 0 1 0   0     0   1   7 5                 12
2233256 2233256 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lynn: Lincoln-Thomson   Regular School No Elementary KG 05 2018   grade_2 9 0 21 0   2     0   1   16 17                       33.0 9 0 21 0   2     0   1   16 17                 33
2233443 2233443 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead: L H Coffin   Regular School No Elementary 02 03 2018   grade_2 62 0 4 0   2     1   4   40 33                       73.0 62 0 4 0   2     1   4   40 33                 73
2233508 2233508 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield: Eames Way School   Regular School No Elementary KG 05 2018   grade_2 37 0 0 0   0     0   2   23 16                       39.0 37 0 0 0   0     0   2   23 16                 39
2233515 2233515 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 Marshfield: South River   Regular School No Elementary KG 05 2018   grade_2 43 0 4 0   0     0   1   24 24                       48.0 43 0 4 0   0     0   1   24 24                 48
2233523 2233523 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield: Daniel Webster   Regular School No Elementary PK 05 2018   grade_2 53 0 3 1   1     1   2   29 32                       61.0 53 0 3 1   1     1   2   29 32                 61
2233530 2233530 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Marshfield: Gov Edward Winslow   Regular School No Elementary KG 05 2018   grade_2 69 0 1 0   0     0   1   26 45                       71.0 69 0 1 0   0     0   1   26 45                 71
2233538 2233538 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield: Martinson Elementary   Regular School No Elementary PK 05 2018   grade_2 45 0 1 0   2     0   0   19 29                       48.0 45 0 1 0   2     0   0   19 29                 48
2233583 2233583 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard: Green Meadow   Regular School No Elementary PK 03 2018   grade_2 88 0 12 0   1     0   6   55 52                       107.0 88 0 12 0   1     0   6   55 52                 107
2233689 2233689 MA Middlesex   school 2507620 178   Melrose 250762001190 1780017 Melrose: Herbert Clark Hoover   Regular School No Elementary KG 05 2018   grade_2 38 0 3 0   1     0   0   19 23                       42.0 38 0 3 0   1     0   0   19 23                 42
2233717 2233717 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Melrose: Winthrop   Regular School No Elementary KG 05 2018   grade_2 63 0 0 0   0     0   6   36 33                       69.0 63 0 0 0   0     0   6   36 33                 69
2233734 2233734 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_2 72 0 40 0   3     0   4   65 54                       119.0 72 0 40 0   3     0   4   65 54                 119
2233840 2233840 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury: Elmwood Street   Regular School No Elementary PK 03 2018   grade_2 109 0 7 0   4     0   5   79 46                       125.0 109 0 7 0   4     0   5   79 46                 125
2233931 2233931 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_2 19 0 0 0   0     0   0   8 11                       19.0 19 0 0 0   0     0   0   8 11                 19
2233969 2233969 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Natick: Johnson   Regular School No Elementary KG 04 2018   grade_2 37 0 5 0   0     0   3   24 21                       45.0 37 0 5 0   0     0   3   24 21                 45
2234024 2234024 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 Needham: William Mitchell   Regular School No Elementary KG 05 2018   grade_2 72 0 4 0   9     0   7   40 52                       92.0 72 0 4 0   9     0   7   40 52                 92
2234164 2234164 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford: Thomas R Rodman   Regular School No Elementary KG 05 2018   grade_2 13 0 8 0   0     0   0   10 11                       21.0 13 0 8 0   0     0   0   10 11                 21
2234298 2234298 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Newton: Mason-Rice   Regular School No Elementary KG 05 2018   grade_2 66 0 3 0   12     0   8   42 47                       89.0 66 0 3 0   12     0   8   42 47                 89
2234321 2234321 MA Middlesex   school 2508610 207   Newton 250861001379 2070115 Newton: Underwood   Regular School No Elementary KG 05 2018   grade_2 27 0 3 0   10     0   0   20 20                       40.0 27 0 3 0   10     0   0   20 20                 40
2234328 2234328 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 Newton: John Ward   Regular School No Elementary KG 05 2018   grade_2 35 0 2 0   8     0   4   24 25                       49.0 35 0 2 0   8     0   4   24 25                 49
2234381 2234381 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 Norfolk: H Olive Day   Regular School No Elementary PK 02 2018   grade_2 134 0 7 0   2     0   4   81 66                       147.0 134 0 7 0   2     0   4   81 66                 147
2234435 2234435 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Northampton: Leeds   Regular School No Elementary PK 05 2018   grade_2 29 0 4 0   0     0   1   15 19                       34.0 29 0 4 0   0     0   1   15 19                 34
2234473 2234473 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover: Kittredge   Regular School No Elementary KG 05 2018   grade_2 36 0 2 0   2     0   1   26 15                       41.0 36 0 2 0   2     0   1   26 15                 41
2234480 2234480 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover: Annie L Sargent School   Regular School No Elementary KG 05 2018   grade_2 77 0 3 0   6     0   5   35 56                       91.0 77 0 3 0   6     0   5   35 56                 91
2234487 2234487 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover: Thomson   Regular School No Elementary KG 05 2018   grade_2 48 0 9 0   3     0   3   32 31                       63.0 48 0 9 0   3     0   3   32 31                 63
2234549 2234549 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Northborough: Lincoln Street   Regular School No Elementary KG 05 2018   grade_2 34 0 0 1   7     1   2   19 26                       45.0 34 0 0 1   7     1   2   19 26                 45
2234556 2234556 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough: Marguerite E Peaslee   Regular School No Elementary KG 05 2018   grade_2 46 0 6 0   9     0   4   38 27                       65.0 46 0 6 0   9     0   4   38 27                 65
2234600 2234600 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield: North Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 34 0 0 0   0     0   0   20 14                       34.0 34 0 0 0   0     0   0   20 14                 34
2234616 2234616 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 North Reading: E Ethel Little School   Regular School No Elementary PK 05 2018   grade_2 46 0 2 0   1     0   4   29 24                       53.0 46 0 2 0   1     0   4   29 24                 53
2234623 2234623 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 North Reading: L D Batchelder   Regular School No Elementary KG 05 2018   grade_2 59 0 8 0   5     0   6   46 32                       78.0 59 0 8 0   5     0   6   46 32                 78
2234652 2234652 MA Bristol   school 2509000 218   Norton 250900001449 2180015 Norton: J C Solmonese   Regular School No Elementary PK 03 2018   grade_2 85 0 1 0   2     0   7   54 41                       95.0 85 0 1 0   2     0   7   54 41                 95
2234678 2234678 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell: William G Vinal   Regular School No Elementary PK 05 2018   grade_2 72 0 2 0   3     0   2   42 37                       79.0 72 0 2 0   3     0   2   42 37                 79
2234738 2234738 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs: Oak Bluffs Elementary   Regular School No Elementary PK 08 2018   grade_2 32 0 13 1   0     0   4   22 28                       50.0 32 0 13 1   0     0   4   22 28                 50
2234754 2234754 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Orange: Fisher Hill   Regular School No Elementary PK 02 2018   grade_2 63 0 9 0   1     0   4   34 43                       77.0 63 0 9 0   1     0   4   34 43                 77
2234758 2234758 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans: Orleans Elementary   Regular School No Elementary KG 05 2018   grade_2 30 0 4 0   1     0   1   15 21                       36.0 30 0 4 0   1     0   1   15 21                 36
2234874 2234874 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_2 13 0 4 0   0     0   1   8 10                       18.0 13 0 4 0   0     0   1   8 10                 18
2234882 2234882 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke: Bryantville Elementary   Regular School No Elementary KG 06 2018   grade_2 71 0 0 0   0     0   4   43 32                       75.0 71 0 0 0   0     0   4   43 32                 75
2234890 2234890 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke: Hobomock Elementary   Regular School No Elementary KG 06 2018   grade_2 68 0 0 0   1     0   0   37 32                       69.0 68 0 0 0   1     0   0   37 32                 69
2234915 2234915 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_2 14 0 1 0   0     0   1   10 6                       16.0 14 0 1 0   0     0   1   10 6                 16

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