Data source: Big Local News · About: Big Local

887 rows where grade = "grade_5", state = "MA" and year = 2016 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2016 · 887

grade

  • grade_5 · 887
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
933886 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_5 58 5 5 1   15     0   2   43 43                       86 58 5 5 1   15     0   2   43 43                 86
934574 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2016   grade_5 73 2 2 0   0     0   4   46 35                       81 73 2 2 0   0     0   4   46 35                 81
934600 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2016   grade_5 37 10 16 0   2     0   5   31 39                       70 37 10 16 0   2     0   5   31 39                 70
934605 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2016   grade_5 42 2 6 0   2     0   2   24 30                       54 42 2 6 0   2     0   2   24 30                 54
934610 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2016   grade_5 48 5 1 1   1     0   0   33 23                       56 48 5 1 1   1     0   0   33 23                 56
934615 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2016   grade_5 27 2 2 1   1     0   0   16 17                       33 27 2 2 1   1     0   0   16 17                 33
935453 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_5 * * * *   *     *   *   3 1                       4                         3 1                 4
935473 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_5 54 0 77 0   5     2   2   64 76                       140 54 0 77 0   5     2   2   64 76                 140
935794 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_5 3 0 101 0   0     0   0   57 47                       104 3 0 101 0   0     0   0   57 47                 104
935807 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_5 3 0 50 0   0     0   0   25 28                       53 3 0 50 0   0     0   0   25 28                 53
935862 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_5 3 0 15 0   0     0   0   16 2                       18 3 0 15 0   0     0   0   16 2                 18
936269 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_5 7 2 26 1   6     0   5   24 23                       47 7 2 26 1   6     0   5   24 23                 47
936301 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2016   grade_5 10 5 62 0   9     0   2   47 41                       88 10 5 62 0   9     0   2   47 41                 88
936355 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_5 4 7 45 1   4     0   2   35 28                       63 4 7 45 1   4     0   2   35 28                 63
936764 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_5 109 3 5 3   3     0   4   59 68                       127 109 3 5 3   3     0   4   59 68                 127
936769 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2016   grade_5 98 1 5 1   2     0   5   48 64                       112 98 1 5 1   2     0   5   48 64                 112
937033 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2016   grade_5 9 6 14 0   0     0   3   20 12                       32 9 6 14 0   0     0   3   20 12                 32
937527 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2016   grade_5 19 12 16 0   2     0   0   25 24                       49 19 12 16 0   2     0   0   25 24                 49
937532 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_5 36 3 9 0   2     0   2   25 27                       52 36 3 9 0   2     0   2   25 27                 52
937537 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2016   grade_5 55 6 2 0   6     0   2   37 34                       71 55 6 2 0   6     0   2   37 34                 71
937542 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_5 36 9 4 0   0     0   1   28 22                       50 36 9 4 0   0     0   1   28 22                 50
938512 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2016   grade_5 38 2 49 0   0     0   1   43 47                       90 38 2 49 0   0     0   1   43 47                 90
938520 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2016   grade_5 28 1 47 0   3     0   2   40 41                       81 28 1 47 0   3     0   2   40 41                 81
939622 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2016   grade_5 32 0 14 1   0     0   0   25 22                       47 32 0 14 1   0     0   0   25 22                 47
939627 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2016   grade_5 19 1 9 0   1     0   1   19 12                       31 19 1 9 0   1     0   1   19 12                 31
939632 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2016   grade_5 38 0 2 0   2     0   1   25 18                       43 38 0 2 0   2     0   1   25 18                 43
934637 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2016   grade_5 91 0 7 0   4     0   1   52 51                       103 91 0 7 0   4     0   1   52 51                 103
935288 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_5 107 1 4 0   10     0   2   52 72                       124 107 1 4 0   10     0   2   52 72                 124
935293 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_5 113 0 3 0   22     0   4   69 73                       142 113 0 3 0   22     0   4   69 73                 142
936165 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_5 * * * *   *     *   *   3 *                       4                         3                   4
940835 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No 1 02 05 2016   grade_5 85 0 5 0   1     0   1   40 52                       92 85 0 5 0   1     0   1   40 52                 92
941181 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No 1 02 05 2016   grade_5 49 5 6 0   0     0   4   39 25                       64 49 5 6 0   0     0   4   39 25                 64
941571 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2016   grade_5 35 0 1 0   1     0   1   22 16                       38 35 0 1 0   1     0   1   22 16                 38
932738 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2016   grade_5 138 6 16 2   29     0   6   102 95                       197 138 6 16 2   29     0   6   102 95                 197
932800 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No 1 03 05 2016   grade_5 169 4 12 1   8     0   4   110 88                       198 169 4 12 1   8     0   4   110 88                 198
932857 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2016   grade_5 126 8 13 3   26     0   4   91 89                       180 126 8 13 3   26     0   4   91 89                 180
933429 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_5 39 17 43 0   5     2   1   60 47                       107 39 17 43 0   5     2   1   60 47                 107
933854 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_5 111 1 4 0   1     1   4   70 52                       122 111 1 4 0   1     1   4   70 52                 122
933917 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2016   grade_5 65 3 1 0   2     0   2   37 36                       73 65 3 1 0   2     0   2   37 36                 73
934486 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No 1 03 05 2016   grade_5 131 3 1 0   4     0   1   64 76                       140 131 3 1 0   4     0   1   64 76                 140
934687 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2016   grade_5 230 0 3 0   2     0   9   137 107                       244 230 0 3 0   2     0   9   137 107                 244
934705 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_5 162 5 2 1   3     0   3   81 95                       176 162 5 2 1   3     0   3   81 95                 176
934747 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No 1 03 05 2016   grade_5 86 7 6 0   6     0   0   58 47                       105 86 7 6 0   6     0   0   58 47                 105
934754 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No 1 03 05 2016   grade_5 96 1 5 0   3     0   3   60 48                       108 96 1 5 0   3     0   3   60 48                 108
934776 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No 1 03 05 2016   grade_5 265 15 6 0   7     0   4   152 145                       297 265 15 6 0   7     0   4   152 145                 297
935539 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No 1 03 05 2016   grade_5 174 1 13 1   13     0   6   109 99                       208 174 1 13 1   13     0   6   109 99                 208
935726 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2016   grade_5 147 3 2 0   2     0   1   80 75                       155 147 3 2 0   2     0   1   80 75                 155
935755 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_5 8 0 93 0   3     0   0   47 57                       104 8 0 93 0   3     0   0   47 57                 104
935891 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No 1 03 05 2016   grade_5 96 6 12 0   2     0   4   53 67                       120 96 6 12 0   2     0   4   53 67                 120
936039 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2016   grade_5 114 0 1 1   5     1   4   66 60                       126 114 0 1 1   5     1   4   66 60                 126
936461 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No 1 03 05 2016   grade_5 269 4 16 0   9     0   13   169 142                       311 269 4 16 0   9     0   13   169 142                 311
936573 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_5 103 5 3 13   6     0   5   58 77                       135 103 5 3 13   6     0   5   58 77                 135
936785 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2016   grade_5 92 1 6 0   5     0   2   55 51                       106 92 1 6 0   5     0   2   55 51                 106
937256 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2016   grade_5 101 3 5 0   1     0   2   61 51                       112 101 3 5 0   1     0   2   61 51                 112
937569 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2016   grade_5 80 1 5 0   1     0   1   48 40                       88 80 1 5 0   1     0   1   48 40                 88
938216 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 03 06 2016   grade_5 230 1 1 2   7     0   1   122 120                       242 230 1 1 2   7     0   1   122 120                 242
938960 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No 1 03 05 2016   grade_5 116 1 2 0   4     0   6   70 59                       129 116 1 2 0   4     0   6   70 59                 129
938994 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No 1 03 05 2016   grade_5 89 2 5 0   0     0   2   51 47                       98 89 2 5 0   0     0   2   51 47                 98
939004 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No 1 03 05 2016   grade_5 56 2 1 0   0     0   0   28 31                       59 56 2 1 0   0     0   0   28 31                 59
939135 MA Worcester   school 2511850 304   Uxbridge 251185002762 3040020 Whitin Elementary School   Regular School No 1 03 05 2016   grade_5 117 3 6 0   2     0   1   73 56                       129 117 3 6 0   2     0   1   73 56                 129
939536 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2016   grade_5 122 0 0 0   30     0   5   89 68                       157 122 0 0 0   30     0   5   89 68                 157
939539 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No 1 03 05 2016   grade_5 80 2 0 0   53     0   1   76 60                       136 80 2 0 0   53     0   1   76 60                 136
939549 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No 1 03 05 2016   grade_5 93 2 0 0   40     0   1   70 66                       136 93 2 0 0   40     0   1   70 66                 136
939597 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_5 106 2 1 0   1     0   5   60 55                       115 106 2 1 0   1     0   5   60 55                 115
939782 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No 1 03 05 2016   grade_5 81 0 5 0   4     0   6   54 42                       96 81 0 5 0   4     0   6   54 42                 96
940935 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 1 03 05 2016   grade_5 87 2 5 0   0     0   4   45 53                       98 87 2 5 0   0     0   4   45 53                 98
941112 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No 1 03 05 2016   grade_5 235 4 2 0   2     0   2   131 114                       245 235 4 2 0   2     0   2   131 114                 245
941494 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2016   grade_5 60 0 2 0   0     0   3   42 23                       65 60 0 2 0   0     0   3   42 23                 65
941645 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_5 93 3 2 0   2     0   0   50 50                       100 93 3 2 0   2     0   0   50 50                 100
941780 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No 1 03 05 2016   grade_5 117 0 3 0   5     0   9   76 58                       134 117 0 3 0   5     0   9   76 58                 134
941836 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No 1 03 05 2016   grade_5 129 1 5 0   0     0   2   85 52                       137 129 1 5 0   0     0   2   85 52                 137
932582 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_5 254 7 24 0   14     0   7   160 146                       306 254 7 24 0   14     0   7   160 146                 306
932843 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_5 279 22 34 2   5     1   24   176 191                       367 279 22 34 2   5     1   24   176 191                 367
932869 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_5 181 2 6 0   6     1   8   109 95                       204 181 2 6 0   6     1   8   109 95                 204
932891 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_5 153 3 7 0   7     0   1   81 90                       171 153 3 7 0   7     0   1   81 90                 171
933643 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_5 7 12 11 0   3     0   0   21 12                       33 7 12 11 0   3     0   0   21 12                 33
934475 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_5 101 6 24 0   1     0   0   75 57                       132 101 6 24 0   1     0   0   75 57                 132
935302 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2016   grade_5 56 0 5 0   0     0   2   41 22                       63 56 0 5 0   0     0   2   41 22                 63
935333 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_5 100 1 23 0   1     0   9   66 68                       134 100 1 23 0   1     0   9   66 68                 134
935521 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2016   grade_5 49 18 15 0   4     0   6   44 48                       92 49 18 15 0   4     0   6   44 48                 92
935575 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2016   grade_5 4 1 51 0   0     0   0   34 22                       56 4 1 51 0   0     0   0   34 22                 56
935650 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No 2 04 05 2016   grade_5 235 2 6 0   32     0   7   138 144                       282 235 2 6 0   32     0   7   138 144                 282
936029 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_5 32 8 9 0   2     0   8   27 32                       59 32 8 9 0   2     0   8   27 32                 59
936218 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No 2 04 05 2016   grade_5 191 2 10 0   0     1   5   101 108                       209 191 2 10 0   0     1   5   101 108                 209
936233 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_5 103 2 11 0   0     0   2   67 51                       118 103 2 11 0   0     0   2   67 51                 118
936479 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No 2 04 06 2016   grade_5 204 11 14 0   4     0   2   116 119                       235 204 11 14 0   4     0   2   116 119                 235
936585 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No 2 04 06 2016   grade_5 67 1 3 0   1     0   2   47 27                       74 67 1 3 0   1     0   2   47 27                 74
936593 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2016   grade_5 72 1 13 0   3     0   2   49 42                       91 72 1 13 0   3     0   2   49 42                 91
936605 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No 2 04 05 2016   grade_5 184 2 3 0   7     0   6   94 108                       202 184 2 3 0   7     0   6   94 108                 202
936813 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2016   grade_5 123 3 9 0   2     0   2   58 81                       139 123 3 9 0   2     0   2   58 81                 139
937133 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Edward G. Molin Elementary School   Regular School No 2 04 05 2016   grade_5 176 0 4 0   2     0   3   96 89                       185 176 0 4 0   2     0   3   96 89                 185
937494 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2016   grade_5 176 3 5 1   2     0   5   93 99                       192 176 3 5 1   2     0   5   93 99                 192
937785 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_5 88 1 4 0   3     0   4   56 44                       100 88 1 4 0   3     0   4   56 44                 100
938502 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No 2 04 05 2016   grade_5 108 1 3 0   23     0   2   70 67                       137 108 1 3 0   23     0   2   70 67                 137
939097 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2016   grade_5 83 0 5 0   0     0   2   45 45                       90 83 0 5 0   0     0   2   45 45                 90
939268 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2016   grade_5 89 1 8 0   2     0   5   50 55                       105 89 1 8 0   2     0   5   50 55                 105
939440 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2016   grade_5 159 2 15 0   81     0   15   144 128                       272 159 2 15 0   81     0   15   144 128                 272
939468 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2016   grade_5 84 2 4 0   1     0   0   53 38                       91 84 2 4 0   1     0   0   53 38                 91
939578 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No 2 04 05 2016   grade_5 113 11 6 1   20     0   9   91 69                       160 113 11 6 1   20     0   9   91 69                 160
939766 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 North Intermediate   Regular School No 2 04 05 2016   grade_5 128 2 2 0   5     0   7   75 69                       144 128 2 2 0   5     0   7   75 69                 144

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