Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2238163 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_5 20 62 34 0   2     0   0   57 61                       118.0 20 62 34 0   2     0   0   57 61                 118
2228763 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_5 138 1 8 1   3     0   3   80 74                       154.0 138 1 8 1   3     0   3   80 74                 154
2237952 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_5 9 46 23 0   1     0   1   38 42                       80.0 9 46 23 0   1     0   1   38 42                 80
2238528 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_5 35 3 2 2   25     0   2   36 33                       69.0 35 3 2 2   25     0   2   36 33                 69
2238552 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_5 46 0 2 0   15     1   5   39 30                       69.0 46 0 2 0   15     1   5   39 30                 69
2238568 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_5 18 2 7 0   63     1   2   40 53                       93.0 18 2 7 0   63     1   2   40 53                 93
2238544 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_5 50 1 9 0   7     0   3   34 36                       70.0 50 1 9 0   7     0   3   34 36                 70
2238536 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_5 52 3 6 0   10     0   1   35 37                       72.0 52 3 6 0   10     0   1   35 37                 72
2238560 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_5 20 2 0 1   22     0   2   22 25                       47.0 20 2 0 1   22     0   2   22 25                 47
2228780 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_5 100 1 2 0   0     0   0   59 44                       103.0 100 1 2 0   0     0   0   59 44                 103
2238586 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_5 95 6 5 0   0     0   0   56 50                       106.0 95 6 5 0   0     0   0   56 50                 106
2228811 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_5 237 10 14 0   5     0   5   131 140                       271.0 237 10 14 0   5     0   5   131 140                 271
2237931 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_5 10 8 25 0   0     0   3   18 28                       46.0 10 8 25 0   0     0   3   18 28                 46
2228836 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_5 145 1 13 1   2     1   4   81 86                       167.0 145 1 13 1   2     1   4   81 86                 167
2228857 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_5 15 7 8 0   7     0   2   19 20                       39.0 15 7 8 0   7     0   2   19 20                 39
2228865 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_5 36 7 17 0   8     0   5   45 28                       73.0 36 7 17 0   8     0   5   45 28                 73
2228873 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_5 30 6 12 0   12     0   10   41 29                       70.0 30 6 12 0   12     0   10   41 29                 70
2228881 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover: Bancroft Elementary   Regular School No Elementary KG 05 2018   grade_5 88 3 8 1   10     0   5   58 57                       115.0 88 3 8 1   10     0   5   58 57                 115
2228897 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover: Henry C Sanborn Elementary   Regular School No Elementary KG 05 2018   grade_5 46 1 4 0   22     0   0   33 40                       73.0 46 1 4 0   22     0   0   33 40                 73
2228888 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover: High Plain Elementary   Regular School No Elementary KG 05 2018   grade_5 48 2 9 0   37     0   0   61 35                       96.0 48 2 9 0   37     0   0   61 35                 96
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
2228911 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   grade_5 77 2 7 1   19     0   7   68 45                       113.0 77 2 7 1   19     0   7   68 45                 113
2228942 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_5 52 1 4 0   9     0   4   38 32                       70.0 52 1 4 0   9     0   4   38 32                 70
2228949 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   grade_5 55 3 4 0   13     1   2   42 36                       78.0 55 3 4 0   13     1   2   42 36                 78
2228956 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   grade_5 40 3 6 0   9     0   4   40 22                       62.0 40 3 6 0   9     0   4   40 22                 62
2228935 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_5 44 5 4 0   8     1   3   32 33                       65.0 44 5 4 0   8     1   3   32 33                 65
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
2228965 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   grade_5 33 2 5 0   5     0   3   20 28                       48.0 33 2 5 0   5     0   3   20 28                 48
2228972 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   grade_5 53 4 6 1   13     0   4   46 35                       81.0 53 4 6 1   13     0   4   46 35                 81
2238618 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Ashburnham-Westminster: Briggs Elementary   Regular School No Elementary PK 05 2018   grade_5 81 0 1 0   1     0   3   42 44                       86.0 81 0 1 0   1     0   3   42 44                 86
2238607 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster: Westminster Elementary   Regular School No Elementary 02 05 2018   grade_5 91 1 4 0   0     0   2   53 45                       98.0 91 1 4 0   0     0   2   53 45                 98
2228998 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland: David Mindess   Regular School No Elementary 03 05 2018   grade_5 143 7 26 0   32     0   8   109 107                       216.0 143 7 26 0   32     0   8   109 107                 216
2238644 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_5 81 1 11 0   2     0   4   55 44                       99.0 81 1 11 0   2     0   4   55 44                 99
2238641 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston: Royalston Community School   Regular School No Elementary KG 06 2018   grade_5 22 0 0 0   1     0   0   15 8                       23.0 22 0 0 0   1     0   0   15 8                 23
2238452 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_5 89 3 12 0   0     0   6   52 58                       110.0 89 3 12 0   0     0   6   52 58                 110
2229046 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_5 101 11 35 0   9     0   9   96 69                       165.0 101 11 35 0   9     0   9   96 69                 165
2229041 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_5 124 9 19 0   4     0   12   93 75                       168.0 124 9 19 0   4     0   12   93 75                 168
2229051 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_5 86 11 23 0   12     0   3   59 76                       135.0 86 11 23 0   12     0   3   59 76                 135
2229075 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn: Swanson Road Intermediate School   Regular School No Elementary 03 05 2018   grade_5 144 1 20 0   8     0   7   93 87                       180.0 144 1 20 0   8     0   7   93 87                 180
2229093 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_5 36 15 4 0   4     0   4   31 32                       63.0 36 15 4 0   4     0   4   31 32                 63
2238660 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Ayer Shirley School District: Lura A. White Elementary School   Regular School No Elementary PK 05 2018   grade_5 55 2 7 0   1     0   1   32 34                       66.0 55 2 7 0   1     0   1   32 34                 66
2238668 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Ayer Shirley School District: Page Hilltop Elementary School   Regular School No Elementary PK 05 2018   grade_5 71 3 10 0   0     0   4   47 41                       88.0 71 3 10 0   0     0   4   47 41                 88
2229126 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   grade_5 324 29 53 0   11     3   13   216 217                       433.0 324 29 53 0   11     3   13   216 217                 433
2229143 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford: Lt Job Lane School   Regular School No Elementary 03 05 2018   grade_5 143 10 10 0   31     0   1   110 85                       195.0 143 10 10 0   31     0   1   110 85                 195
2229159 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown: Chestnut Hill Community School   Regular School No Middle 04 06 2018   grade_5 164 7 5 0   7     1   2   101 85                       186.0 164 7 5 0   7     1   2   101 85                 186
2229187 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham: Bellingham Memorial School   Regular School No Middle 04 07 2018   grade_5 152 1 5 1   12     0   1   86 86                       172.0 152 1 5 1   12     0   1   86 86                 172
2229228 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_5 230 15 17 0   78     1   30   191 180                       371.0 230 15 17 0   78     1   30   191 180                 371
2238007 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   grade_5 1 48 7 0   1     0   0   32 25                       57.0 1 48 7 0   1     0   0   32 25                 57
2238191 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   grade_5 37 1 0 0   14     0   0   21 31                       52.0 37 1 0 0   14     0   0   21 31                 52
2239996 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School (District): Bentley Academy Charter School   Regular School Yes Elementary KG 05 2018   grade_5 9 6 18 0   2     0   1   20 16                       36.0 9 6 18 0   2     0   1   20 16                 36
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
2238686 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_5 63 2 6 0   2     0   5   44 34                       78.0 63 2 6 0   2     0   5   44 34                 78
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
2229293 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly: Ayers/Ryal Side School   Regular School No Elementary KG 05 2018   grade_5 55 1 14 0   6     0   0   44 32                       76.0 55 1 14 0   6     0   0   44 32                 76
2229265 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly: Centerville Elementary   Regular School No Elementary KG 05 2018   grade_5 46 1 10 0   0     0   2   32 27                       59.0 46 1 10 0   0     0   2   32 27                 59
2229272 MA Essex   school 2502640 30   Beverly 250264000168 300015 Beverly: Cove Elementary   Regular School No Elementary KG 05 2018   grade_5 62 2 8 0   3     1   1   39 38                       77.0 62 2 8 0   3     1   1   39 38                 77
2229279 MA Essex   school 2502640 30   Beverly 250264000169 300033 Beverly: Hannah Elementary   Regular School No Elementary KG 05 2018   grade_5 63 1 12 0   2     0   4   40 42                       82.0 63 1 12 0   2     0   4   40 42                 82
2229286 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly: North Beverly Elementary   Regular School No Elementary KG 05 2018   grade_5 58 2 4 0   2     0   0   34 32                       66.0 58 2 4 0   2     0   0   34 32                 66
2229344 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Billerica: Eugene C Vining   Regular School No Elementary KG 05 2018   grade_5 21 1 5 0   2     0   2   16 15                       31.0 21 1 5 0   2     0   2   16 15                 31
2229316 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica: Frederick J Dutile   Regular School No Elementary KG 05 2018   grade_5 46 3 0 0   2     0   1   28 24                       52.0 46 3 0 0   2     0   1   28 24                 52
2229337 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Billerica: Hajjar Elementary   Regular School No Elementary KG 05 2018   grade_5 52 6 6 1   5     0   0   32 38                       70.0 52 6 6 1   5     0   0   32 38                 70
2229323 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica: John F Kennedy   Regular School No Elementary KG 05 2018   grade_5 44 1 0 0   2     0   0   21 26                       47.0 44 1 0 0   2     0   0   21 26                 47
2229330 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Billerica: Parker   Regular School No Elementary KG 05 2018   grade_5 63 3 7 0   5     0   3   45 36                       81.0 63 3 7 0   5     0   3   45 36                 81
2229309 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica: Thomas Ditson   Regular School No Elementary KG 05 2018   grade_5 76 4 5 0   13     0   7   52 53                       105.0 76 4 5 0   13     0   7   52 53                 105
2238718 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville: A F Maloney   Regular School No Elementary 03 05 2018   grade_5 88 1 7 0   1     0   3   44 56                       100.0 88 1 7 0   1     0   3   44 56                 100
2238714 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Blackstone-Millville: Millville Elementary   Regular School No Elementary PK 05 2018   grade_5 44 0 3 0   1     0   1   23 26                       49.0 44 0 3 0   1     0   1   23 26                 49
2238196 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_5 50 35 5 0   1     0   5   57 39                       96.0 50 35 5 0   1     0   5   57 39                 96
2238366 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_5 0 66 30 0   1     0   0   46 51                       97.0 0 66 30 0   1     0   0   46 51                 97
2230049 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston: Blackstone   Regular School No Elementary PK 05 2018   grade_5 1 19 63 0   0     0   1   40 44                       84.0 1 19 63 0   0     0   1   40 44                 84
2229404 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_5 7 11 13 0   0     0   0   19 12                       31.0 7 11 13 0   0     0   0   19 12                 31
2229472 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   grade_5 1 53 14 0   0     0   1   32 37                       69.0 1 53 14 0   0     0   1   32 37                 69
2229464 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston: Charles Sumner   Regular School No Elementary PK 05 2018   grade_5 3 17 40 0   2     0   3   33 32                       65.0 3 17 40 0   2     0   3   33 32                 65
2229441 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_5 20 21 59 0   3     0   5   54 54                       108.0 20 21 59 0   3     0   5   54 54                 108
2229480 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston: Curtis Guild   Regular School No Elementary PK 05 2018   grade_5 3 1 48 0   0     0   0   27 25                       52.0 3 1 48 0   0     0   0   27 25                 52
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
2229496 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston: David A Ellis   Regular School No Elementary PK 05 2018   grade_5 1 21 23 0   0     0   1   23 23                       46.0 1 21 23 0   0     0   1   23 23                 46
2229512 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_5 16 22 22 0   1     1   4   29 37                       66.0 16 22 22 0   1     1   4   29 37                 66
2229523 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_5 8 1 82 0   1     0   0   44 48                       92.0 8 1 82 0   1     0   0   44 48                 92
2230054 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_5 18 13 14 0   1     0   0   25 21                       46.0 18 13 14 0   1     0   0   25 21                 46
2229982 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_5 6 11 45 1   10     0   1   36 38                       74.0 6 11 45 1   10     0   1   36 38                 74
2229534 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston: Edward Everett   Regular School No Elementary PK 05 2018   grade_5 0 19 17 0   4     0   1   18 23                       41.0 0 19 17 0   4     0   1   18 23                 41
2229542 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_5 37 12 19 0   5     0   1   38 36                       74.0 37 12 19 0   5     0   1   38 36                 74
2229553 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston: Ellis Mendell   Regular School No Elementary PK 05 2018   grade_5 12 7 10 0   0     0   1   17 13                       30.0 12 7 10 0   0     0   1   17 13                 30
2229561 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_5 5 15 23 0   1     0   2   29 17                       46.0 5 15 23 0   1     0   2   29 17                 46
2229905 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston: Gardner Pilot Academy   Regular School No Elementary PK 08 2018   grade_5 8 7 21 0   1     0   4   21 20                       41.0 8 7 21 0   1     0   4   21 20                 41
2229572 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston: George H Conley   Regular School No Elementary PK 05 2018   grade_5 1 13 8 0   0     0   1   10 13                       23.0 1 13 8 0   0     0   1   10 13                 23
2229726 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Boston: Harvard-Kent   Regular School No Elementary PK 05 2018   grade_5 11 14 30 0   17     0   2   47 27                       74.0 11 14 30 0   17     0   2   47 27                 74
2229580 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Boston: Henry Grew   Regular School No Elementary PK 05 2018   grade_5 2 15 20 0   0     0   2   13 26                       39.0 2 15 20 0   0     0   2   13 26                 39
2230001 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_5 2 20 26 0   0     0   3   29 22                       51.0 2 20 26 0   0     0   3   29 22                 51
2230266 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_5 1 4 3 0   0     0   0   6 2                       8.0 1 4 3 0   0     0   0   6 2                 8
2229596 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston: Hugh Roe O'Donnell   Regular School No Elementary PK 05 2018   grade_5 2 1 34 0   0     0   0   17 20                       37.0 2 1 34 0   0     0   0   17 20                 37
2229415 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston: Jackson Mann   Regular School No Elementary PK 08 2018   grade_5 5 26 28 0   12     0   3   41 33                       74.0 5 26 28 0   12     0   3   41 33                 74
2229604 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_5 29 46 40 1   5     1   3   60 65                       125.0 29 46 40 1   5     1   3   60 65                 125
2229625 MA Suffolk   school 2502790 35   Boston 250279000255 350154 Boston: James J Chittick   Regular School No Elementary PK 05 2018   grade_5 1 27 9 0   1     0   3   20 21                       41.0 1 27 9 0   1     0   3   20 21                 41
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
2229614 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_5 7 21 63 0   2     0   1   40 54                       94.0 7 21 63 0   2     0   1   40 54                 94
2229657 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   grade_5 1 10 6 0   0     0   0   10 7                       17.0 1 10 6 0   0     0   0   10 7                 17
2229641 MA Suffolk   school 2502790 35   Boston 250279000265 350166 Boston: John F Kennedy   Regular School No Elementary PK 05 2018   grade_5 0 11 39 0   0     0   0   28 22                       50.0 0 11 39 0   0     0   0   28 22                 50
2229669 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston: John Winthrop   Regular School No Elementary PK 05 2018   grade_5 0 27 12 0   3     2   1   19 26                       45.0 0 27 12 0   3     2   1   19 26                 45

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