Data source: Big Local News · About: Big Local

953 rows where grade = "grade_4", state = "MA" and year = 2015 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2015 · 953

grade

  • grade_4 · 953
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
735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
737008 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 01 05 2015   grade_4 80 1 2 0   5     0   1   41 48                       89 80 1 2 0   5     0   1   41 48                 89
737019 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2015   grade_4 60 5 4 1   12     0   2   41 43                       84 60 5 4 1   12     0   2   41 43                 84
737030 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 01 05 2015   grade_4 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
737495 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_4 10 11 92 0   1     0   1   63 52                       115 10 11 92 0   1     0   1   63 52                 115
737499 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_4 8 9 88 2   3     0   3   57 56                       113 8 9 88 2   3     0   3   57 56                 113
737503 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_4 12 5 124 0   2     0   0   75 68                       143 12 5 124 0   2     0   0   75 68                 143
737507 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_4 13 7 122 1   5     0   0   75 73                       148 13 7 122 1   5     0   0   75 73                 148
737714 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2015   grade_4 73 2 3 0   4     0   0   45 37                       82 73 2 3 0   4     0   0   45 37                 82
737742 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2015   grade_4 39 9 12 0   1     0   5   30 36                       66 39 9 12 0   1     0   5   30 36                 66
737747 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2015   grade_4 42 2 6 0   3     0   2   25 30                       55 42 2 6 0   3     0   2   25 30                 55
737752 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2015   grade_4 47 5 1 0   1     0   0   31 23                       54 47 5 1 0   1     0   0   31 23                 54
737757 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2015   grade_4 28 2 2 2   1     0   0   17 18                       35 28 2 2 2   1     0   0   17 18                 35
738895 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 01 04 2015   grade_4 8 2 130 0   3     0   1   68 76                       144 8 2 130 0   3     0   1   68 76                 144
738927 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2015   grade_4 4 7 132 0   1     0   1   72 73                       145 4 7 132 0   1     0   1   72 73                 145
738945 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_4 3 0 95 0   0     0   0   57 41                       98 3 0 95 0   0     0   0   57 41                 98
738958 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_4 1 0 58 0   0     0   0   30 29                       59 1 0 58 0   0     0   0   30 29                 59
739012 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_4 3 0 12 0   0     0   0   14 1                       15 3 0 12 0   0     0   0   14 1                 15
739317 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_4 * * * *   *     *   *   3 *                       4                         3                   4
739420 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2015   grade_4 8 5 25 1   10     0   6   29 26                       55 8 5 25 1   10     0   6   29 26                 55
739452 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_4 10 8 64 0   10     0   2   50 44                       94 10 8 64 0   10     0   2   50 44                 94
739481 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_4 2 4 2 0   0     0   0   6 2                       8 2 4 2 0   0     0   0   6 2                 8
739506 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2015   grade_4 3 5 48 1   5     0   3   36 29                       65 3 5 48 1   5     0   3   36 29                 65
739918 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_4 120 3 4 2   3     0   3   64 71                       135 120 3 4 2   3     0   3   64 71                 135
739923 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2015   grade_4 96 4 4 1   2     0   5   50 62                       112 96 4 4 1   2     0   5   50 62                 112
740188 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_4 12 6 19 0   0     0   3   20 20                       40 12 6 19 0   0     0   3   20 20                 40
740697 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2015   grade_4 21 11 16 0   3     0   0   27 24                       51 21 11 16 0   3     0   0   27 24                 51
740702 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2015   grade_4 40 4 8 0   3     0   2   27 30                       57 40 4 8 0   3     0   2   27 30                 57
740707 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2015   grade_4 57 7 2 0   8     0   2   41 35                       76 57 7 2 0   8     0   2   41 35                 76
740712 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2015   grade_4 35 6 4 0   1     0   0   25 21                       46 35 6 4 0   1     0   0   25 21                 46
741289 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2015   grade_4 40 2 3 0   1     0   0   26 20                       46 40 2 3 0   1     0   0   26 20                 46
741293 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2015   grade_4 71 7 2 0   1     0   3   45 39                       84 71 7 2 0   1     0   3   45 39                 84
741556 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_4 104 5 10 1   71     0   6   107 90                       197 104 5 10 1   71     0   6   107 90                 197
741708 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2015   grade_4 40 2 55 0   0     0   0   50 47                       97 40 2 55 0   0     0   0   50 47                 97
741715 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2015   grade_4 35 1 33 0   3     0   0   37 35                       72 35 1 33 0   3     0   0   37 35                 72
742352 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2015   grade_4 34 0 3 0   0     0   2   23 16                       39 34 0 3 0   0     0   2   23 16                 39
742816 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2015   grade_4 28 0 13 1   0     0   0   23 19                       42 28 0 13 1   0     0   0   23 19                 42
742821 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_4 16 0 8 0   0     0   0   13 11                       24 16 0 8 0   0     0   0   13 11                 24
742826 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2015   grade_4 40 0 3 0   1     0   1   25 20                       45 40 0 3 0   1     0   1   25 20                 45
737779 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_4 90 0 7 0   4     0   2   50 53                       103 90 0 7 0   4     0   2   50 53                 103
738378 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_4 100 1 2 0   2     0   2   60 47                       107 100 1 2 0   2     0   2   60 47                 107
738435 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_4 104 1 2 0   9     0   2   51 67                       118 104 1 2 0   9     0   2   51 67                 118
738440 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_4 111 1 2 0   25     0   6   71 74                       145 111 1 2 0   25     0   6   71 74                 145
738602 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_4 * * * *   *     *   *   3 1                       4                         3 1                 4
739823 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No 1 02 04 2015   grade_4 154 1 5 1   4     0   2   76 91                       167 154 1 5 1   4     0   2   76 91                 167
740602 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2015   grade_4 171 0 12 0   1     0   9   113 80                       193 171 0 12 0   1     0   9   113 80                 193
741729 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No 1 02 04 2015   grade_4 116 2 20 0   1     0   8   66 81                       147 116 2 20 0   1     0   8   66 81                 147
742790 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 02 05 2015   grade_4 107 3 1 0   1     0   5   57 60                       117 107 3 1 0   1     0   5   57 60                 117
744000 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No 1 02 05 2015   grade_4 84 0 5 0   1     0   1   40 51                       91 84 0 5 0   1     0   1   40 51                 91
744119 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No 1 02 04 2015   grade_4 161 6 5 0   1     0   5   89 89                       178 161 6 5 0   1     0   5   89 89                 178
744237 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No 1 02 04 2015   grade_4 125 3 8 0   3     0   4   59 84                       143 125 3 8 0   3     0   4   59 84                 143
744246 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No 1 02 04 2015   grade_4 159 0 7 0   3     1   2   85 87                       172 159 0 7 0   3     1   2   85 87                 172
744354 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No 1 02 05 2015   grade_4 50 3 6 0   0     0   7   41 25                       66 50 3 6 0   0     0   7   41 25                 66
744566 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No 1 02 04 2015   grade_4 56 1 2 0   0     0   1   30 30                       60 56 1 2 0   0     0   1   30 30                 60
744745 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_4 35 0 2 0   2     0   1   22 18                       40 35 0 2 0   2     0   1   22 18                 40
744844 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_4 98 1 7 0   1     0   1   65 43                       108 98 1 7 0   1     0   1   65 43                 108
735861 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2015   grade_4 130 6 16 0   25     0   6   93 90                       183 130 6 16 0   25     0   6   93 90                 183
735916 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_4 91 0 7 0   7     0   3   63 45                       108 91 0 7 0   7     0   3   63 45                 108
735922 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_4 76 2 4 0   2     0   1   47 38                       85 76 2 4 0   2     0   1   47 38                 85
735982 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_4 121 11 12 0   26     0   4   89 85                       174 121 11 12 0   26     0   4   89 85                 174
736559 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_4 41 21 44 0   6     1   2   63 52                       115 41 21 44 0   6     1   2   63 52                 115
736988 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_4 107 1 4 0   1     1   4   68 50                       118 107 1 4 0   1     1   4   68 50                 118
737049 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2015   grade_4 65 4 2 0   1     0   2   36 38                       74 65 4 2 0   1     0   2   36 38                 74
737626 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No 1 03 05 2015   grade_4 133 3 1 0   3     0   1   62 79                       141 133 3 1 0   3     0   1   62 79                 141
737832 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2015   grade_4 222 0 2 0   1     0   7   136 96                       232 222 0 2 0   1     0   7   136 96                 232
737850 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2015   grade_4 163 4 1 1   3     0   3   84 91                       175 163 4 1 1   3     0   3   84 91                 175
737892 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No 1 03 05 2015   grade_4 88 7 8 0   4     0   0   56 51                       107 88 7 8 0   4     0   0   56 51                 107
737899 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No 1 03 05 2015   grade_4 97 1 3 0   3     0   3   59 48                       107 97 1 3 0   3     0   3   59 48                 107
737922 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson - Olmsted School   Regular School No 1 03 05 2015   grade_4 262 15 7 1   7     0   3   150 145                       295 262 15 7 1   7     0   3   150 145                 295
738077 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_4 * * * *   *     *   *   4 *                       4                         4                   4
738352 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_4 120 1 28 0   2     0   20   84 87                       171 120 1 28 0   2     0   20   84 87                 171
738530 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No 1 03 04 2015   grade_4 99 0 2 0   2     0   0   54 49                       103 99 0 2 0   2     0   0   54 49                 103
738693 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No 1 03 05 2015   grade_4 166 2 13 1   11     0   6   104 95                       199 166 2 13 1   11     0   6   104 95                 199
738876 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2015   grade_4 154 2 2 0   2     0   0   82 78                       160 154 2 2 0   2     0   0   82 78                 160
738905 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_4 9 1 84 0   4     0   0   47 51                       98 9 1 84 0   4     0   0   47 51                 98
739041 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No 1 03 05 2015   grade_4 93 5 8 0   2     0   2   47 63                       110 93 5 8 0   2     0   2   47 63                 110
739192 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_4 117 1 2 0   3     0   3   66 60                       126 117 1 2 0   3     0   3   66 60                 126
739615 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No 1 03 05 2015   grade_4 269 6 14 0   8     0   13   169 141                       310 269 6 14 0   8     0   13   169 141                 310
739728 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_4 107 4 3 12   6     0   4   58 78                       136 107 4 3 12   6     0   4   58 78                 136
739940 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2015   grade_4 91 1 5 0   5     0   2   54 50                       104 91 1 5 0   5     0   2   54 50                 104
739951 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2015   grade_4 230 13 79 4   7     0   12   172 173                       345 230 13 79 4   7     0   12   172 173                 345
740420 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_4 103 3 6 0   1     0   2   62 53                       115 103 3 6 0   1     0   2   62 53                 115
740740 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2015   grade_4 76 1 0 0   1     0   2   41 39                       80 76 1 0 0   1     0   2   41 39                 80
740755 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No 1 03 04 2015   grade_4 124 1 19 0   3     0   1   76 72                       148 124 1 19 0   3     0   1   76 72                 148
742149 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No 1 03 05 2015   grade_4 119 1 2 0   4     0   6   71 61                       132 119 1 2 0   4     0   6   71 61                 132
742184 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No 1 03 05 2015   grade_4 86 1 3 0   0     0   1   47 44                       91 86 1 3 0   0     0   1   47 44                 91
742194 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No 1 03 05 2015   grade_4 55 1 2 0   0     0   1   28 31                       59 55 1 2 0   0     0   1   28 31                 59
742266 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No 1 03 04 2015   grade_4 137 2 2 0   4     0   1   81 65                       146 137 2 2 0   4     0   1   81 65                 146
742270 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Louise Davy Trahan   Regular School No 1 03 04 2015   grade_4 122 1 2 0   2     0   1   65 63                       128 122 1 2 0   2     0   1   65 63                 128
742325 MA Worcester   school 2511850 304   Uxbridge 251185002762 3040020 Whitin Elementary School   Regular School No 1 03 05 2015   grade_4 120 2 6 0   2     0   1   74 57                       131 120 2 6 0   2     0   1   74 57                 131
742475 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No 1 03 04 2015   grade_4 176 14 12 3   0     0   15   108 112                       220 176 14 12 3   0     0   15   108 112                 220
742550 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_4 105 5 37 0   2     0   8   65 92                       157 105 5 37 0   2     0   8   65 92                 157
742729 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_4 126 0 0 0   27     0   5   89 69                       158 126 0 0 0   27     0   5   89 69                 158
742732 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No 1 03 05 2015   grade_4 77 2 2 0   54     0   2   76 61                       137 77 2 2 0   54     0   2   76 61                 137
742742 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No 1 03 05 2015   grade_4 94 1 0 0   31     0   0   66 60                       126 94 1 0 0   31     0   0   66 60                 126
742977 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No 1 03 05 2015   grade_4 76 0 5 0   4     0   6   51 40                       91 76 0 5 0   4     0   6   51 40                 91
744285 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No 1 03 05 2015   grade_4 229 1 1 0   2     0   1   127 107                       234 229 1 1 0   2     0   1   127 107                 234
744670 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2015   grade_4 59 0 2 0   0     0   4   40 25                       65 59 0 2 0   0     0   4   40 25                 65
744958 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No 1 03 05 2015   grade_4 119 0 5 0   5     0   9   82 56                       138 119 0 5 0   5     0   9   82 56                 138
745014 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No 1 03 05 2015   grade_4 124 1 4 0   0     0   2   80 51                       131 124 1 4 0   0     0   2   80 51                 131

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