enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 894 ✖

grade ✖

  • grade_5 · 894 ✖
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
1122674 1122674 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   3 1                       *                         3 1                  
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1125191 1125191 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125265 1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1126250 1126250 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_5 * * * *   *     *   *   2 *                       *                         2                    
1126351 1126351 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1128753 1128753 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1130461 1130461 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1132594 1132594 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1122098 1122098 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_5 66 0 4 0   19     0   0   40 49                       89 66 0 4 0   19     0   0   40 49                 89
1122448 1122448 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_5 30 0 1 0   1     0   4   24 12                       36 30 0 1 0   1     0   4   24 12                 36
1122666 1122666 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_5 4 0 34 0   0     0   0   25 13                       38 4 0 34 0   0     0   0   25 13                 38
1122819 1122819 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2017   grade_5 4 0 41 0   1     0   0   20 26                       46 4 0 41 0   1     0   0   20 26                 46
1122871 1122871 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_5 8 0 21 0   0     0   2   15 16                       31 8 0 21 0   0     0   2   15 16                 31
1123029 1123029 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2017   grade_5 2 0 20 0   1     0   0   11 12                       23 2 0 20 0   1     0   0   11 12                 23
1123491 1123491 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_5 98 0 3 0   4     0   1   46 60                       106 98 0 3 0   4     0   1   46 60                 106
1123719 1123719 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 40 0 1 0   0     0   1   24 18                       42 40 0 1 0   0     0   1   24 18                 42
1123869 1123869 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_5 13 0 18 0   1     0   2   10 24                       34 13 0 18 0   1     0   2   10 24                 34
1124013 1124013 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_5 51 0 4 0   4     0   11   37 33                       70 51 0 4 0   4     0   11   37 33                 70
1124212 1124212 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_5 18 0 0 0   0     0   0   10 8                       18 18 0 0 0   0     0   0   10 8                 18
1124285 1124285 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_5 23 0 0 0   0     0   1   14 10                       24 23 0 0 0   0     0   1   14 10                 24
1124315 1124315 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No Elementary KG 05 2017   grade_5 54 0 5 0   4     0   0   37 26                       63 54 0 5 0   4     0   0   37 26                 63
1124322 1124322 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No Elementary KG 05 2017   grade_5 55 0 5 1   2     0   0   35 28                       63 55 0 5 1   2     0   0   35 28                 63
1124340 1124340 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_5 89 0 2 0   1     0   5   48 49                       97 89 0 2 0   1     0   5   48 49                 97
1124407 1124407 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_5 49 0 3 0   2     0   5   33 26                       59 49 0 3 0   2     0   5   33 26                 59
1124476 1124476 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   grade_5 220 0 3 0   5     0   11   118 121                       239 220 0 3 0   5     0   11   118 121                 239
1124536 1124536 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_5 89 0 9 0   6     0   1   48 57                       105 89 0 9 0   6     0   1   48 57                 105
1124613 1124613 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_5 19 0 1 0   0     0   2   12 10                       22 19 0 1 0   0     0   2   12 10                 22
1124785 1124785 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2017   grade_5 33 0 7 0   1     0   2   17 26                       43 33 0 7 0   1     0   2   17 26                 43
1124817 1124817 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_5 3 0 1 0   0     0   2   6 *                       6 3 0 1 0   0     0   2   6                   6
1124925 1124925 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_5 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
1124990 1124990 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_5 25 0 77 0   0     0   1   51 52                       103 25 0 77 0   0     0   1   51 52                 103
1125065 1125065 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   grade_5 71 0 3 0   4     0   2   41 39                       80 71 0 3 0   4     0   2   41 39                 80
1125079 1125079 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_5 58 0 4 0   1     1   2   32 34                       66 58 0 4 0   1     1   2   32 34                 66
1125151 1125151 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_5 39 0 2 0   0     0   3   23 21                       44 39 0 2 0   0     0   3   23 21                 44
1125160 1125160 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_5 31 0 1 0   0     0   0   16 16                       32 31 0 1 0   0     0   0   16 16                 32
1125229 1125229 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary 04 06 2017   grade_5 55 0 5 0   1     0   2   32 31                       63 55 0 5 0   1     0   2   32 31                 63
1125320 1125320 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_5 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
1125463 1125463 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2017   grade_5 85 0 1 0   0     0   3   48 41                       89 85 0 1 0   0     0   3   48 41                 89
1125477 1125477 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2017   grade_5 85 0 2 0   1     0   5   50 43                       93 85 0 2 0   1     0   5   50 43                 93
1125550 1125550 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_5 19 0 29 0   0     0   0   25 23                       48 19 0 29 0   0     0   0   25 23                 48
1125685 1125685 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2017   grade_5 198 0 20 0   7     0   4   108 121                       229 198 0 20 0   7     0   4   108 121                 229
1125718 1125718 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2017   grade_5 63 0 5 0   1     0   1   29 41                       70 63 0 5 0   1     0   1   29 41                 70
1125752 1125752 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_5 32 0 0 0   0     0   0   13 19                       32 32 0 0 0   0     0   0   13 19                 32
1125811 1125811 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_5 8 0 100 0   0     0   2   46 64                       110 8 0 100 0   0     0   2   46 64                 110
1125882 1125882 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_5 2 0 9 0   0     0   0   9 2                       11 2 0 9 0   0     0   0   9 2                 11
1125936 1125936 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_5 52 0 5 0   4     0   0   36 25                       61 52 0 5 0   4     0   0   36 25                 61
1126009 1126009 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_5 13 0 2 0   0     0   2   11 6                       17 13 0 2 0   0     0   2   11 6                 17
1126436 1126436 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2017   grade_5 6 0 16 0   9     0   3   21 13                       34 6 0 16 0   9     0   3   21 13                 34
1126443 1126443 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2017   grade_5 19 0 8 1   1     0   6   15 20                       35 19 0 8 1   1     0   6   15 20                 35
1126690 1126690 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2017   grade_5 48 0 1 0   0     0   0   26 23                       49 48 0 1 0   0     0   0   26 23                 49
1126697 1126697 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2017   grade_5 55 0 1 0   0     0   1   29 28                       57 55 0 1 0   0     0   1   29 28                 57
1126705 1126705 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No Elementary PK 05 2017   grade_5 35 0 1 0   0     0   1   20 17                       37 35 0 1 0   0     0   1   20 17                 37
1126712 1126712 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary KG 05 2017   grade_5 67 0 1 0   0     0   3   31 40                       71 67 0 1 0   0     0   3   31 40                 71
1126720 1126720 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No Elementary PK 05 2017   grade_5 57 0 1 0   3     0   1   34 28                       62 57 0 1 0   3     0   1   34 28                 62
1126875 1126875 MA Middlesex   school 2507620 178   Melrose 250762001190 1780017 Herbert Clark Hoover   Regular School No Elementary KG 05 2017   grade_5 33 0 1 0   1     0   2   21 16                       37 33 0 1 0   1     0   2   21 16                 37
1126920 1126920 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_5 82 0 40 0   7     0   7   69 67                       136 82 0 40 0   7     0   7   69 67                 136
1126942 1126942 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_5 63 0 68 0   4     0   10   83 62                       145 63 0 68 0   4     0   10   83 62                 145
1126953 1126953 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_5 71 0 62 0   4     0   10   73 74                       147 71 0 62 0   4     0   10   73 74                 147
1127101 1127101 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_5 58 0 3 0   2     2   2   33 34                       67 58 0 3 0   2     2   2   33 34                 67
1127117 1127117 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   0   10 7                       17 17 0 0 0   0     0   0   10 7                 17
1127356 1127356 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2017   grade_5 25 0 10 0   1     0   1   15 22                       37 25 0 10 0   1     0   1   15 22                 37
1127437 1127437 MA Middlesex   school 2508610 207   Newton 250861001359 2070020 C C Burr   Regular School No Elementary KG 05 2017   grade_5 45 0 10 0   11     0   4   41 29                       70 45 0 10 0   11     0   4   41 29                 70
1127479 1127479 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2017   grade_5 51 0 2 0   11     0   4   38 30                       68 51 0 2 0   11     0   4   38 30                 68
1127493 1127493 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Memorial Spaulding   Regular School No Elementary KG 05 2017   grade_5 49 0 2 0   14     0   3   35 33                       68 49 0 2 0   14     0   3   35 33                 68
1127516 1127516 MA Middlesex   school 2508610 207   Newton 250861001382 2070125 Williams   Regular School No Elementary KG 05 2017   grade_5 25 0 5 0   9     0   0   24 15                       39 25 0 5 0   9     0   0   24 15                 39
1127623 1127623 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No Elementary KG 05 2017   grade_5 26 0 14 0   0     0   3   22 21                       43 26 0 14 0   0     0   3   22 21                 43
1127691 1127691 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No Elementary KG 05 2017   grade_5 41 0 1 0   2     0   2   20 26                       46 41 0 1 0   2     0   2   20 26                 46
1127705 1127705 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2017   grade_5 47 0 0 0   2     0   1   24 26                       50 47 0 0 0   2     0   1   24 26                 50
1127737 1127737 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No Elementary KG 05 2017   grade_5 27 0 6 1   7     1   2   18 26                       44 27 0 6 1   7     1   2   18 26                 44
1127782 1127782 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 49 0 2 0   0     0   2   29 24                       53 49 0 2 0   0     0   2   29 24                 53
1127798 1127798 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No Elementary PK 05 2017   grade_5 41 0 4 0   3     0   1   28 21                       49 41 0 4 0   3     0   1   28 21                 49
1127805 1127805 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No Elementary KG 05 2017   grade_5 64 0 0 0   1     0   2   31 36                       67 64 0 0 0   1     0   2   31 36                 67
1127852 1127852 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No Elementary PK 05 2017   grade_5 71 0 3 0   5     0   2   48 33                       81 71 0 3 0   5     0   2   48 33                 81
1127860 1127860 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2017   grade_5 70 0 3 0   1     1   3   51 27                       78 70 0 3 0   1     1   3   51 27                 78
1127939 1127939 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   grade_5 32 0 0 0   2     0   1   19 16                       35 32 0 0 0   2     0   1   19 16                 35
1127993 1127993 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2017   grade_5 58 0 2 0   0     0   0   30 30                       60 58 0 2 0   0     0   0   30 30                 60
1128015 1128015 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2017   grade_5 31 0 3 0   2     0   1   24 13                       37 31 0 3 0   2     0   1   24 13                 37
1128039 1128039 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2017   grade_5 28 0 0 0   1     0   0   16 13                       29 28 0 0 0   1     0   0   16 13                 29
1128071 1128071 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2017   grade_5 60 0 0 0   0     0   0   37 23                       60 60 0 0 0   0     0   0   37 23                 60
1128096 1128096 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_5 17 0 0 0   0     0   1   12 6                       18 17 0 0 0   0     0   1   12 6                 18
1128194 1128194 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No Elementary KG 05 2017   grade_5 33 0 5 0   1     0   4   24 19                       43 33 0 5 0   1     0   4   24 19                 43
1128201 1128201 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No Elementary KG 05 2017   grade_5 34 0 4 0   1     0   4   18 25                       43 34 0 4 0   1     0   4   18 25                 43
1128215 1128215 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2017   grade_5 112 0 1 1   0     0   1   62 53                       115 112 0 1 1   0     0   1   62 53                 115
1128222 1128222 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No Elementary KG 05 2017   grade_5 58 0 2 0   0     0   1   32 29                       61 58 0 2 0   0     0   1   32 29                 61
1128242 1128242 MA Plymouth   school 2509720 239   Plymouth 250972001548 2390047 West Elementary   Regular School No Elementary KG 05 2017   grade_5 59 0 2 1   0     0   2   42 22                       64 59 0 2 1   0     0   2   42 22                 64
1128268 1128268 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_5 31 0 0 0   1     0   0   17 15                       32 31 0 0 0   1     0   0   17 15                 32
1128289 1128289 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2017   grade_5 37 0 1 0   24     0   1   26 37                       63 37 0 1 0   24     0   1   26 37                 63
1128296 1128296 MA Norfolk   school 2509870 243   Quincy 250987001568 2430025 Charles A Bernazzani Elementary   Regular School No Elementary KG 05 2017   grade_5 43 0 3 0   13     0   4   35 28                       63 43 0 3 0   13     0   4   35 28                 63
1128309 1128309 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No Elementary KG 05 2017   grade_5 38 0 4 0   1     0   4   26 21                       47 38 0 4 0   1     0   4   26 21                 47
1128329 1128329 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No Elementary KG 05 2017   grade_5 28 0 2 0   42     1   5   37 41                       78 28 0 2 0   42     1   5   37 41                 78
1128601 1128601 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No Elementary PK 05 2017   grade_5 67 0 0 0   2     0   0   43 26                       69 67 0 0 0   2     0   0   43 26                 69
1128618 1128618 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_5 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1128658 1128658 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_5 29 0 15 0   1     0   5   22 28                       50 29 0 15 0   1     0   5   22 28                 50
1128697 1128697 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_5 231 0 4 0   2     0   1   108 130                       238 231 0 4 0   2     0   1   108 130                 238
1128736 1128736 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No Elementary KG 05 2017   grade_5 24 0 8 0   4     0   1   21 16                       37 24 0 8 0   4     0   1   21 16                 37
1128857 1128857 MA Middlesex   school 2510710 269   Sherborn 251071001709 2690010 Pine Hill   Regular School No Elementary PK 05 2017   grade_5 57 0 1 0   11     0   3   39 33                       72 57 0 1 0   11     0   3   39 33                 72
1128904 1128904 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   1   6 12                       18 17 0 0 0   0     0   1   6 12                 18
1128913 1128913 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No Elementary PK 05 2017   grade_5 61 0 1 0   0     0   0   30 32                       62 61 0 1 0   0     0   0   30 32                 62
1128920 1128920 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2017   grade_5 88 0 3 0   0     0   3   53 41                       94 88 0 3 0   0     0   3   53 41                 94

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