Data source: Big Local News · About: Big Local

976 rows where grade = "grade_3", state = "MA" and year = 2018 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2018 · 976

grade

  • grade_3 · 976
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
2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2229164 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_3 133 4 14 1   1     0   9   84 78                       162.0 133 4 14 1   1     0   9   84 78                 162
2229938 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_3 0 9 3 0   0     0   0   10 2                       12.0 0 9 3 0   0     0   0   10 2                 12
2229999 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_3 1 42 35 1   1     0   3   46 37                       83.0 1 42 35 1   1     0   3   46 37                 83
2230345 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_3 61 1 4 0   26     0   2   46 48                       94.0 61 1 4 0   26     0   2   46 48                 94
2230896 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_3 18 5 112 0   3     0   1   80 59                       139.0 18 5 112 0   3     0   1   80 59                 139
2230901 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_3 16 12 138 0   1     0   2   86 83                       169.0 16 12 138 0   1     0   2   86 83                 169
2230906 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_3 5 4 140 0   2     0   1   83 69                       152.0 5 4 140 0   2     0   1   83 69                 152
2230911 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_3 10 15 119 0   2     0   4   76 74                       150.0 10 15 119 0   2     0   4   76 74                 150
2231154 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_3 76 1 2 0   0     0   5   41 43                       84.0 76 1 2 0   0     0   5   41 43                 84
2231187 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_3 31 6 14 1   3     0   2   27 30                       57.0 31 6 14 1   3     0   2   27 30                 57
2231193 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_3 48 1 0 0   0     0   3   28 24                       52.0 48 1 0 0   0     0   3   28 24                 52
2231199 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_3 40 6 5 0   2     0   5   29 29                       58.0 40 6 5 0   2     0   5   29 29                 58
2231205 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_3 21 2 9 0   1     0   0   16 17                       33.0 21 2 9 0   1     0   0   16 17                 33
2231473 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_3 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231494 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_3 21 16 77 0   2     0   3   62 57                       119.0 21 16 77 0   2     0   3   62 57                 119
2232205 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill: Golden Hill   Regular School No Elementary 01 04 2018   grade_3 65 4 51 0   3     0   6   61 68                       129.0 65 4 51 0   3     0   6   61 68                 129
2232582 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence: South Lawrence East Elementary School   Regular School No Elementary 01 05 2018   grade_3 7 2 125 0   5     0   0   81 58                       139.0 7 2 125 0   5     0   0   81 58                 139
2232620 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence: Gerard A. Guilmette   Regular School No Elementary 01 04 2018   grade_3 7 5 125 0   0     0   0   67 70                       137.0 7 5 125 0   0     0   0   67 70                 137
2232642 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_3 6 0 75 0   1     0   0   47 35                       82.0 6 0 75 0   1     0   0   47 35                 82
2232658 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_3 3 1 68 0   0     0   0   42 30                       72.0 3 1 68 0   0     0   0   42 30                 72
2232696 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_3 2 0 7 0   0     0   0   6 3                       9.0 2 0 7 0   0     0   0   6 3                 9
2233236 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn: Robert L Ford   Regular School No Elementary 01 05 2018   grade_3 9 6 57 1   10     0   1   50 34                       84.0 9 6 57 1   10     0   1   50 34                 84
2233297 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn: Tracy   Regular School No Elementary 01 05 2018   grade_3 7 11 57 0   2     0   9   37 49                       86.0 7 11 57 0   2     0   9   37 49                 86
2233782 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough: Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2018   grade_3 89 2 2 0   2     1   9   67 38                       105.0 89 2 2 0   2     1   9   67 38                 105
2233788 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough: Mary K. Goode Elementary School   Regular School No Elementary 01 05 2018   grade_3 101 4 3 1   0     0   1   46 64                       110.0 101 4 3 1   0     0   1   46 64                 110
2234694 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood: Balch   Regular School No Elementary 01 05 2018   grade_3 28 4 21 0   1     0   2   23 33                       56.0 28 4 21 0   1     0   2   23 33                 56
2234700 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood: Cornelius M Callahan   Regular School No Elementary 01 05 2018   grade_3 36 3 2 0   1     0   1   25 18                       43.0 36 3 2 0   1     0   1   25 18                 43
2234706 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood: F A Cleveland   Regular School No Elementary 01 05 2018   grade_3 53 3 7 0   5     0   1   41 28                       69.0 53 3 7 0   5     0   1   41 28                 69
2234712 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood: John P Oldham   Regular School No Elementary 01 05 2018   grade_3 33 3 5 0   3     0   0   20 24                       44.0 33 3 5 0   3     0   0   20 24                 44
2235020 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth: Hedge   Regular School No Elementary 01 05 2018   grade_3 25 0 1 0   1     0   2   15 14                       29.0 25 0 1 0   1     0   2   15 14                 29
2235691 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_3 71 7 11 2   93     0   8   103 89                       192.0 71 7 11 2   93     0   8   103 89                 192
2236643 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Wakefield: Walton   Regular School No Elementary 01 04 2018   grade_3 41 0 2 0   2     0   2   25 22                       47.0 41 0 2 0   2     0   2   25 22                 47
2237001 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater: Rose L Macdonald   Regular School No Elementary 01 03 2018   grade_3 69 5 2 0   2     0   0   40 38                       78.0 69 5 2 0   2     0   0   40 38                 78
2237188 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield: John R Fausey   Regular School No Elementary 01 05 2018   grade_3 60 5 17 1   5     0   4   59 33                       92.0 60 5 17 1   5     0   4   59 33                 92
2237194 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield: Memorial   Regular School No Elementary 01 05 2018   grade_3 25 2 8 0   6     0   2   23 20                       43.0 25 2 8 0   6     0   2   23 20                 43
2237200 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield: Mittineague   Regular School No Elementary 01 05 2018   grade_3 23 2 7 0   0     0   0   12 20                       32.0 23 2 7 0   0     0   0   12 20                 32
2237379 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington: Woburn Street   Regular School No Elementary 01 03 2018   grade_3 89 0 6 0   5     0   4   57 47                       104.0 89 0 6 0   5     0   4   57 47                 104
2237383 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington: Shawsheen Elementary   Regular School No Elementary 01 03 2018   grade_3 90 2 9 0   5     0   5   56 55                       111.0 90 2 9 0   5     0   5   56 55                 111
2230052 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_3 18 12 14 0   7     0   0   23 28                       51.0 18 12 14 0   7     0   0   23 28                 51
2231232 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas: Douglas Elementary School   Regular School No Elementary 02 05 2018   grade_3 82 0 1 0   0     0   2   46 39                       85.0 82 0 1 0   0     0   2   46 39                 85
2231625 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_3 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2231928 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_3 127 3 27 1   0     0   27   102 83                       185.0 127 3 27 1   0     0   27   102 83                 185
2232038 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_3 114 0 7 0   11     0   7   70 69                       139.0 114 0 7 0   11     0   7   70 69                 139
2232044 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_3 95 1 10 0   26     0   1   69 64                       133.0 95 1 10 0   26     0   1   69 64                 133
2232468 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton: Elmwood   Regular School No Elementary 02 03 2018   grade_3 200 3 7 1   41     1   10   142 121                       263.0 200 3 7 1   41     1   10   142 121                 263
2233138 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Ludlow: Chapin Street Elementary School   Regular School No Elementary 02 03 2018   grade_3 136 2 15 1   1     0   5   72 88                       160.0 136 2 15 1   1     0   5   72 88                 160
2233444 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead: L H Coffin   Regular School No Elementary 02 03 2018   grade_3 61 2 9 0   3     0   5   42 38                       80.0 61 2 9 0   3     0   5   42 38                 80
2233605 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield: Ralph Wheelock School   Regular School No Elementary 02 03 2018   grade_3 156 2 14 3   5     0   3   109 74                       183.0 156 2 14 3   5     0   3   109 74                 183
2233672 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Medway: Burke/Memorial Elementary School   Regular School No Elementary 02 04 2018   grade_3 149 1 4 0   1     0   6   79 82                       161.0 149 1 4 0   1     0   6   79 82                 161
2234580 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge: W Edward Balmer   Regular School No Elementary 02 04 2018   grade_3 148 1 11 0   0     0   9   78 91                       169.0 148 1 11 0   0     0   9   78 91                 169
2234764 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford: Clara Barton   Regular School No Elementary 02 04 2018   grade_3 105 5 13 0   0     0   8   70 61                       131.0 105 5 13 0   0     0   8   70 61                 131
2235859 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough: Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2018   grade_3 87 1 5 0   26     0   9   65 63                       128.0 87 1 5 0   26     0   9   65 63                 128
2235866 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Southbridge: Charlton Street   Regular School No Elementary 02 05 2018   grade_3 27 2 40 1   1     0   1   36 36                       72.0 27 2 40 1   1     0   1   36 36                 72
2235875 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 Southbridge: West Street   Regular School No Elementary 02 05 2018   grade_3 33 0 47 0   1     0   2   46 37                       83.0 33 0 47 0   1     0   2   46 37                 83
2235893 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 South Hadley: Mosier   Regular School No Elementary 02 04 2018   grade_3 115 2 31 1   2     0   3   75 79                       154.0 115 2 31 1   2     0   3   75 79                 154
2238605 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster: Westminster Elementary   Regular School No Elementary 02 05 2018   grade_3 71 2 5 0   0     0   3   44 37                       81.0 71 2 5 0   0     0   3   44 37                 81
2238739 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Bridgewater-Raynham: Laliberte Elementary School   Regular School No Elementary 02 04 2018   grade_3 141 10 0 1   4     0   5   71 90                       161.0 141 10 0 1   4     0   5   71 90                 161
2238878 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg: Dudley Elementary   Regular School No Elementary 02 04 2018   grade_3 119 2 13 0   0     0   3   83 54                       137.0 119 2 13 0   0     0   3   83 54                 137
2238890 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Dudley-Charlton Reg: Heritage School   Regular School No Elementary 02 04 2018   grade_3 130 4 13 1   0     0   6   85 69                       154.0 130 4 13 1   0     0   6   85 69                 154
2239018 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Gill-Montague: Sheffield Elementary School   Regular School No Elementary 02 05 2018   grade_3 41 0 9 0   0     0   5   33 22                       55.0 41 0 9 0   0     0   5   33 22                 55
2239078 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Hampden-Wilbraham: Stony Hill School   Regular School No Elementary 02 03 2018   grade_3 126 3 14 0   5     0   7   84 71                       155.0 126 3 14 0   5     0   7   84 71                 155
2239256 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Narragansett: Baldwinville Elementary   Regular School No Elementary 02 04 2018   grade_3 86 1 5 0   0     0   7   49 50                       99.0 86 1 5 0   0     0   7   49 50                 99
2239466 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_3 30 0 1 0   0     0   0   11 20                       31.0 30 0 1 0   0     0   0   11 20                 31
2228756 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   grade_3 146 3 15 0   3     0   1   92 76                       168.0 146 3 15 0   3     0   1   92 76                 168
2228996 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland: David Mindess   Regular School No Elementary 03 05 2018   grade_3 155 6 16 5   32     0   6   110 110                       220.0 155 6 16 5   32     0   6   110 110                 220
2229073 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn: Swanson Road Intermediate School   Regular School No Elementary 03 05 2018   grade_3 154 6 24 0   12     0   4   103 97                       200.0 154 6 24 0   12     0   4   103 97                 200
2229141 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford: Lt Job Lane School   Regular School No Elementary 03 05 2018   grade_3 140 13 10 0   39     0   9   106 105                       211.0 140 13 10 0   39     0   9   106 105                 211
2229810 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_3 38 32 40 0   6     0   1   57 60                       117.0 38 32 40 0   6     0   1   57 60                 117
2230307 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_3 79 1 1 0   6     0   3   50 40                       90.0 79 1 1 0   6     0   3   50 40                 90
2230382 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster: Eddy Elementary   Regular School No Elementary 03 05 2018   grade_3 66 2 8 0   2     0   4   39 43                       82.0 66 2 8 0   2     0   4   39 43                 82
2231050 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset: Deer Hill   Regular School No Elementary 03 05 2018   grade_3 109 6 1 0   5     0   6   63 64                       127.0 109 6 1 0   5     0   6   63 64                 127
2231291 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury: Alden School   Regular School No Elementary 03 05 2018   grade_3 166 0 3 0   3     0   19   96 95                       191.0 166 0 3 0   3     0   19   96 95                 191
2231314 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater: Gordon W Mitchell   Regular School No Elementary 03 06 2018   grade_3 134 5 3 1   0     0   4   76 71                       147.0 134 5 3 1   0     0   4   76 71                 147
2231363 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 East Longmeadow: Mapleshade   Regular School No Elementary 03 05 2018   grade_3 71 6 13 0   5     0   3   60 38                       98.0 71 6 13 0   5     0   3   60 38                 98
2231372 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 East Longmeadow: Mountain View   Regular School No Elementary 03 05 2018   grade_3 67 2 7 1   4     0   3   50 34                       84.0 67 2 7 1   4     0   3   50 34                 84
2231400 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton: Richardson Olmsted School   Regular School No Elementary 03 05 2018   grade_3 234 23 13 0   7     1   7   144 141                       285.0 234 23 13 0   7     1   7   144 141                 285
2232146 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Hanover: Sylvester   Regular School No Elementary 03 04 2018   grade_3 113 1 1 0   2     0   3   61 59                       120.0 113 1 1 0   2     0   3   61 59                 120
2232261 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_3 19 2 41 0   1     0   2   37 28                       65.0 19 2 41 0   1     0   2   37 28                 65
2232336 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston: Miller School   Regular School No Elementary 03 05 2018   grade_3 172 4 9 0   27     0   9   107 114                       221.0 172 4 9 0   27     0   9   107 114                 221
2232558 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston: Kingston Intermediate   Regular School No Elementary 03 06 2018   grade_3 133 2 3 1   0     0   0   68 71                       139.0 133 2 3 1   0     0   0   68 71                 139
2232595 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_3 3 1 81 0   1     0   0   37 49                       86.0 3 1 81 0   1     0   0   37 49                 86
2232728 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester: Leicester Memorial Elementary   Regular School No Elementary 03 05 2018   grade_3 81 5 8 2   3     0   3   50 52                       102.0 81 5 8 2   3     0   3   50 52                 102
2232913 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Littleton: Russell St Elementary   Regular School No Elementary 03 05 2018   grade_3 112 2 3 1   14     0   1   74 59                       133.0 112 2 3 1   14     0   1   74 59                 133
2233157 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg: Turkey Hill Elementary School   Regular School No Elementary 03 05 2018   grade_3 98 0 9 1   0     1   8   57 60                       117.0 98 0 9 1   0     1   8   57 60                 117
2233425 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield: Jordan/Jackson Elementary   Regular School No Elementary 03 05 2018   grade_3 201 12 4 0   17     0   9   128 115                       243.0 201 12 4 0   17     0   9   128 115                 243
2233560 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_3 84 2 8 9   1     0   12   54 62                       116.0 84 2 8 9   1     0   12   54 62                 116
2233809 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_3 77 0 1 0   5     0   0   41 42                       83.0 77 0 1 0   5     0   0   41 42                 83
2233824 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_3 198 13 82 7   5     1   18   178 146                       324.0 198 13 82 7   5     1   18   178 146                 324
2233946 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket: Nantucket Intermediate School   Regular School No Elementary 03 05 2018   grade_3 55 8 56 0   0     0   5   67 57                       124.0 55 8 56 0   0     0   5   67 57                 124
2234373 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk: Freeman-Kennedy School   Regular School No Elementary 03 06 2018   grade_3 103 0 7 0   3     0   1   66 48                       114.0 103 0 7 0   3     0   1   66 48                 114
2234746 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange: Dexter Park   Regular School No Elementary 03 06 2018   grade_3 59 1 3 0   0     0   2   35 30                       65.0 59 1 3 0   0     0   2   35 30                 65
2235517 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_3 173 2 5 0   2     0   2   96 88                       184.0 173 2 5 0   2     0   2   96 88                 184
2236394 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton: Sutton Elementary   Regular School No Elementary 03 05 2018   grade_3 96 1 2 0   3     0   6   57 51                       108.0 96 1 2 0   3     0   6   57 51                 108
2236436 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Swansea: Elizabeth S Brown   Regular School No Elementary 03 05 2018   grade_3 77 1 0 1   0     0   1   39 41                       80.0 77 1 0 1   0     0   1   39 41                 80
2236449 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Swansea: Joseph G Luther   Regular School No Elementary 03 05 2018   grade_3 66 0 2 1   2     0   6   37 40                       77.0 66 0 2 1   2     0   6   37 40                 77
2236537 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 Tewksbury: North Street   Regular School No Elementary 03 04 2018   grade_3 119 9 11 0   6     0   1   75 71                       146.0 119 9 11 0   6     0   1   75 71                 146
2236543 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Tewksbury: Louise Davy Trahan   Regular School No Elementary 03 04 2018   grade_3 93 2 4 0   1     0   3   49 54                       103.0 93 2 4 0   1     0   3   49 54                 103
2236609 MA Worcester   school 2511850 304   Uxbridge 251185002762 3040020 Uxbridge: Whitin Elementary School   Regular School No Elementary 03 05 2018   grade_3 118 2 2 0   0     0   3   65 60                       125.0 118 2 2 0   0     0   3   65 60                 125
2236790 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Wareham: Minot Forest   Regular School No Elementary 03 04 2018   grade_3 148 17 13 1   2     0   24   112 93                       205.0 148 17 13 1   2     0   24   112 93                 205

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