enrollments

Data source: Big Local News · About: Big Local

896 rows where grade = "grade_5", state = "MA" and year = 2018 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 896 ✖

grade ✖

  • grade_5 · 896 ✖
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
2229488 2229488 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston: Dante Alighieri Montessori School   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230208 2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2231627 2231627 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_5 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231642 2231642 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_5 * * * *   *     *   *   * *                       0.0                                             0
2232020 2232020 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2232132 2232132 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2233067 2233067 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2233131 2233131 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell: Lowell Day School on Broadway   Special Education School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2233173 2233173 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Lynn: Early Childhood Center   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2233271 2233271 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn: William R Fallon   Regular School No Elementary KG 06 2018   grade_5 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2235440 2235440 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2235575 2235575 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy: Emma L Miller Elementary School   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2237226 2237226 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2237289 2237289 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2237901 2237901 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2228904 2228904 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover: South Elementary   Regular School No Elementary KG 05 2018   grade_5 63 0 3 0   20     1   0   45 42                       87.0 63 0 3 0   20     1   0   45 42                 87
2228979 2228979 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   grade_5 50 0 4 0   11     0   5   35 35                       70.0 50 0 4 0   11     0   5   35 35                 70
2229245 2229245 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_5 89 0 2 0   1     0   2   47 47                       94.0 89 0 2 0   1     0   2   47 47                 94
2229256 2229256 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_5 30 0 1 0   0     0   1   16 16                       32.0 30 0 1 0   0     0   1   16 16                 32
2229633 2229633 MA Suffolk   school 2502790 35   Boston 250279000257 350156 Boston: James Otis   Regular School No Elementary PK 05 2018   grade_5 4 0 43 0   1     0   0   21 27                       48.0 4 0 43 0   1     0   0   21 27                 48
2229834 2229834 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston: Patrick J Kennedy   Regular School No Elementary PK 05 2018   grade_5 3 0 37 0   0     0   0   18 22                       40.0 3 0 37 0   0     0   0   18 22                 40
2230257 2230257 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_5 3 0 32 0   0     0   0   18 17                       35.0 3 0 32 0   0     0   0   18 17                 35
2230533 2230533 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_5 35 0 1 0   0     0   4   18 22                       40.0 35 0 1 0   0     0   4   18 22                 40
2230684 2230684 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_5 20 0 22 0   0     0   4   24 22                       46.0 20 0 22 0   0     0   4   24 22                 46
2230828 2230828 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_5 50 0 1 0   6     0   8   37 28                       65.0 50 0 1 0   6     0   8   37 28                 65
2230839 2230839 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver: Carver Elementary School   Regular School No Elementary PK 05 2018   grade_5 115 0 3 0   1     0   0   67 52                       119.0 115 0 3 0   1     0   0   67 52                 119
2230953 2230953 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Chicopee: Bowe   Regular School No Elementary PK 05 2018   grade_5 22 0 41 1   1     0   3   39 29                       68.0 22 0 41 1   1     0   3   39 29                 68
2230995 2230995 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee: Streiber Memorial School   Regular School No Elementary KG 05 2018   grade_5 34 0 13 0   1     0   2   30 20                       50.0 34 0 13 0   1     0   2   30 20                 50
2231027 2231027 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_5 18 0 0 0   0     0   2   12 8                       20.0 18 0 0 0   0     0   2   12 8                 20
2231089 2231089 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Concord: Willard   Regular School No Elementary PK 05 2018   grade_5 64 0 2 1   7     0   5   41 38                       79.0 64 0 2 1   7     0   5   41 38                 79
2231101 2231101 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_5 20 0 1 0   0     0   0   10 11                       21.0 20 0 1 0   0     0   0   10 11                 21
2231224 2231224 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield: Deerfield Elementary   Regular School No Elementary PK 06 2018   grade_5 53 0 3 0   0     0   2   34 24                       58.0 53 0 3 0   0     0   2   34 24                 58
2231234 2231234 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas: Douglas Elementary School   Regular School No Elementary 02 05 2018   grade_5 97 0 3 0   3     0   4   45 62                       107.0 97 0 3 0   3     0   4   45 62                 107
2231293 2231293 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury: Alden School   Regular School No Elementary 03 05 2018   grade_5 236 0 6 1   4     0   6   114 139                       253.0 236 0 6 1   4     0   6   114 139                 253
2231430 2231430 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_5 17 0 0 0   0     0   3   8 12                       20.0 17 0 0 0   0     0   3   8 12                 20
2231520 2231520 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Fairhaven: Leroy Wood   Regular School No Elementary PK 05 2018   grade_5 81 0 1 0   2     0   2   40 46                       86.0 81 0 1 0   2     0   2   40 46                 86
2231753 2231753 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_5 14 0 0 0   0     0   0   6 8                       14.0 14 0 0 0   0     0   0   6 8                 14
2231880 2231880 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   grade_5 80 0 1 0   4     0   0   46 39                       85.0 80 0 1 0   4     0   0   46 39                 85
2231887 2231887 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_5 53 0 2 0   9     0   0   38 26                       64.0 53 0 2 0   9     0   0   38 26                 64
2231973 2231973 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester: Beeman Memorial   Regular School No Elementary KG 05 2018   grade_5 51 0 8 0   3     0   0   22 40                       62.0 51 0 8 0   3     0   0   22 40                 62
2231980 2231980 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   grade_5 33 0 2 0   0     0   0   19 16                       35.0 33 0 2 0   0     0   0   19 16                 35
2231996 2231996 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester: Veterans Memorial   Regular School No Elementary KG 05 2018   grade_5 19 0 5 0   1     0   0   14 11                       25.0 19 0 5 0   1     0   0   14 11                 25
2232058 2232058 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby: East Meadow   Regular School No Middle 04 06 2018   grade_5 43 0 3 0   0     0   1   28 19                       47.0 43 0 3 0   0     0   1   28 19                 47
2232110 2232110 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_5 32 0 5 0   0     0   1   22 16                       38.0 32 0 5 0   0     0   1   22 16                 38
2232181 2232181 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_5 40 0 0 0   0     0   1   22 19                       41.0 40 0 0 0   0     0   1   22 19                 41
2232240 2232240 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_5 3 0 2 0   0     0   1   5 1                       6.0 3 0 2 0   0     0   1   5 1                 6
2232279 2232279 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 Hingham: East Elementary School   Regular School No Elementary PK 05 2018   grade_5 72 0 1 0   3     0   3   42 37                       79.0 72 0 1 0   3     0   3   42 37                 79
2232286 2232286 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Hingham: Wm L Foster Elementary   Regular School No Elementary KG 05 2018   grade_5 67 0 1 0   0     0   1   37 32                       69.0 67 0 1 0   0     0   1   37 32                 69
2232333 2232333 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_5 30 0 3 0   0     0   0   16 17                       33.0 30 0 3 0   0     0   0   16 17                 33
2232338 2232338 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston: Miller School   Regular School No Elementary 03 05 2018   grade_5 201 0 15 1   14     0   7   130 108                       238.0 201 0 15 1   14     0   7   130 108                 238
2232394 2232394 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_5 4 0 58 0   0     0   0   30 32                       62.0 4 0 58 0   0     0   0   30 32                 62
2232426 2232426 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke: Maurice A Donahue Elementary   Regular School No Elementary PK 08 2018   grade_5 6 0 45 0   0     0   0   24 27                       51.0 6 0 45 0   0     0   0   24 27                 51
2232518 2232518 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Hull: Lillian M Jacobs   Regular School No Elementary PK 05 2018   grade_5 53 0 0 0   0     0   1   25 29                       54.0 53 0 0 0   0     0   1   25 29                 54
2232535 2232535 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Ipswich: Paul F Doyon Memorial   Regular School No Elementary PK 05 2018   grade_5 56 0 4 0   2     0   2   27 37                       64.0 56 0 4 0   2     0   2   27 37                 64
2232543 2232543 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Ipswich: Winthrop   Regular School No Elementary PK 05 2018   grade_5 61 0 2 0   1     0   2   36 30                       66.0 61 0 2 0   1     0   2   36 30                 66
2232597 2232597 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_5 6 0 71 0   2     0   0   37 42                       79.0 6 0 71 0   2     0   0   37 42                 79
2232602 2232602 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_5 2 0 136 0   0     0   0   70 68                       138.0 2 0 136 0   0     0   0   70 68                 138
2232623 2232623 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_5 6 0 103 0   0     0   0   50 59                       109.0 6 0 103 0   0     0   0   50 59                 109
2232638 2232638 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_5 3 0 66 0   0     0   0   33 36                       69.0 3 0 66 0   0     0   0   33 36                 69
2232644 2232644 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_5 2 0 88 0   0     0   1   52 39                       91.0 2 0 88 0   0     0   1   52 39                 91
2232660 2232660 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_5 0 0 60 0   0     0   1   30 31                       61.0 0 0 60 0   0     0   1   30 31                 61
2232698 2232698 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_5 1 0 8 0   0     0   1   9 1                       10.0 1 0 8 0   0     0   1   9 1                 10
2232718 2232718 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   grade_5 30 0 4 0   0     0   2   9 27                       36.0 30 0 4 0   0     0   2   9 27                 36
2232752 2232752 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox: Morris   Regular School No Elementary PK 05 2018   grade_5 44 0 3 0   2     0   1   27 23                       50.0 44 0 3 0   2     0   1   27 23                 50
2232825 2232825 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_5 11 0 2 0   0     0   2   6 9                       15.0 11 0 2 0   0     0   2   6 9                 15
2233266 2233266 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn: Lynn Woods   Regular School No Elementary KG 05 2018   grade_5 18 0 9 0   1     0   2   16 14                       30.0 18 0 9 0   1     0   2   16 14                 30
2233511 2233511 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield: Eames Way School   Regular School No Elementary KG 05 2018   grade_5 36 0 0 0   0     0   1   26 11                       37.0 36 0 0 0   0     0   1   26 11                 37
2233533 2233533 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Marshfield: Gov Edward Winslow   Regular School No Elementary KG 05 2018   grade_5 89 0 0 0   0     0   4   48 45                       93.0 89 0 0 0   0     0   4   48 45                 93
2233541 2233541 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield: Martinson Elementary   Regular School No Elementary PK 05 2018   grade_5 70 0 2 3   2     0   2   32 47                       79.0 70 0 2 3   2     0   2   32 47                 79
2233706 2233706 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Melrose: Horace Mann   Regular School No Elementary KG 05 2018   grade_5 43 0 2 0   1     0   2   23 25                       48.0 43 0 2 0   1     0   2   23 25                 48
2233770 2233770 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen: Donald P Timony Grammar   Regular School No Elementary PK 08 2018   grade_5 67 0 68 1   7     0   9   74 78                       152.0 67 0 68 1   7     0   9   74 78                 152
2233811 2233811 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_5 78 0 1 0   6     0   2   52 35                       87.0 78 0 1 0   6     0   2   52 35                 87
2233877 2233877 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton: Collicot   Regular School No Elementary PK 05 2018   grade_5 84 0 1 0   9     0   1   50 45                       95.0 84 0 1 0   9     0   1   50 45                 95
2233918 2233918 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_5 60 0 2 0   2     0   1   32 33                       65.0 60 0 2 0   2     0   1   32 33                 65
2233934 2233934 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_5 23 0 0 0   0     0   0   10 13                       23.0 23 0 0 0   0     0   0   10 13                 23
2234020 2234020 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Needham: Hillside Elementary   Regular School No Elementary KG 05 2018   grade_5 63 0 7 0   6     0   3   40 39                       79.0 63 0 7 0   6     0   3   40 39                 79
2234167 2234167 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford: Thomas R Rodman   Regular School No Elementary KG 05 2018   grade_5 15 0 8 0   1     0   2   14 12                       26.0 15 0 8 0   1     0   2   14 12                 26
2234174 2234174 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 New Bedford: Jireh Swift   Regular School No Elementary KG 05 2018   grade_5 34 0 7 0   0     0   0   18 23                       41.0 34 0 7 0   0     0   0   18 23                 41
2234294 2234294 MA Middlesex   school 2508610 207   Newton 250861001367 2070075 Newton: Horace Mann   Regular School No Elementary KG 05 2018   grade_5 43 0 8 0   14     0   6   39 32                       71.0 43 0 8 0   14     0   6   39 32                 71
2234308 2234308 MA Middlesex   school 2508610 207   Newton 250861001377 2070100 Newton: Peirce   Regular School No Elementary KG 05 2018   grade_5 37 0 1 0   10     0   1   23 26                       49.0 37 0 1 0   10     0   1   23 26                 49
2234469 2234469 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover: Franklin   Regular School No Elementary KG 05 2018   grade_5 53 0 6 0   14     0   1   36 38                       74.0 53 0 6 0   14     0   1   36 38                 74
2234559 2234559 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough: Marguerite E Peaslee   Regular School No Elementary KG 05 2018   grade_5 29 0 7 0   5     1   2   26 18                       44.0 29 0 7 0   5     1   2   26 18                 44
2234573 2234573 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Northborough: Marion E Zeh   Regular School No Elementary KG 05 2018   grade_5 29 0 5 0   4     0   2   17 23                       40.0 29 0 5 0   4     0   2   17 23                 40
2234603 2234603 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield: North Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_5 44 0 1 0   0     0   2   27 20                       47.0 44 0 1 0   0     0   2   27 20                 47
2234619 2234619 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 North Reading: E Ethel Little School   Regular School No Elementary PK 05 2018   grade_5 32 0 2 0   1     0   0   19 16                       35.0 32 0 2 0   1     0   0   19 16                 35
2234626 2234626 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 North Reading: L D Batchelder   Regular School No Elementary KG 05 2018   grade_5 80 0 2 0   3     0   0   38 47                       85.0 80 0 2 0   3     0   0   38 47                 85
2234633 2234633 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 North Reading: J Turner Hood   Regular School No Elementary KG 05 2018   grade_5 51 0 1 0   3     0   2   38 19                       57.0 51 0 1 0   3     0   2   38 19                 57
2234673 2234673 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Norwell: Grace Farrar Cole   Regular School No Elementary PK 05 2018   grade_5 88 0 1 0   3     0   2   58 36                       94.0 88 0 1 0   3     0   2   58 36                 94
2234748 2234748 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange: Dexter Park   Regular School No Elementary 03 06 2018   grade_5 70 0 7 0   1     0   7   56 29                       85.0 70 0 7 0   1     0   7   56 29                 85
2234861 2234861 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody: West Memorial   Regular School No Elementary PK 05 2018   grade_5 33 0 4 0   1     0   0   26 12                       38.0 33 0 4 0   1     0   0   26 12                 38
2234877 2234877 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_5 15 0 2 0   0     0   0   6 11                       17.0 15 0 2 0   0     0   0   6 11                 17
2234885 2234885 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke: Bryantville Elementary   Regular School No Elementary KG 06 2018   grade_5 82 0 0 0   1     0   0   48 35                       83.0 82 0 0 0   1     0   0   48 35                 83
2234893 2234893 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke: Hobomock Elementary   Regular School No Elementary KG 06 2018   grade_5 77 0 1 0   0     0   0   39 39                       78.0 77 0 1 0   0     0   0   39 39                 78
2234902 2234902 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 Pembroke: North Pembroke Elementary   Regular School No Elementary PK 06 2018   grade_5 61 0 2 0   1     0   3   37 30                       67.0 61 0 2 0   1     0   3   37 30                 67
2234918 2234918 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_5 14 0 2 0   0     0   0   9 7                       16.0 14 0 2 0   0     0   0   9 7                 16
2234971 2234971 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Pittsfield: Williams   Regular School No Elementary KG 05 2018   grade_5 50 0 2 0   5     0   6   26 37                       63.0 50 0 2 0   5     0   6   26 37                 63
2235043 2235043 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Plymouth: Manomet Elementary   Regular School No Elementary KG 05 2018   grade_5 49 0 1 0   0     0   3   23 30                       53.0 49 0 1 0   0     0   3   23 30                 53
2235089 2235089 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_5 26 0 2 0   0     0   0   13 15                       28.0 26 0 2 0   0     0   0   13 15                 28
2235110 2235110 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Quincy: Beechwood Knoll Elementary   Regular School No Elementary KG 05 2018   grade_5 30 0 0 0   26     0   0   22 34                       56.0 30 0 0 0   26     0   0   22 34                 56
2235150 2235150 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Quincy: Montclair   Regular School No Elementary KG 05 2018   grade_5 24 0 2 0   35     1   1   28 35                       63.0 24 0 2 0   35     1   1   28 35                 63

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