enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_8", state = "MA" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_8 · 495 ✖
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
2228766 2228766 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_8 144 5 12 0   5     0   1   84 83                       167.0 144 5 12 0   5     0   1   84 83                 167
2228783 2228783 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_8 73 0 3 0   0     0   1   42 35                       77.0 73 0 3 0   0     0   1   42 35                 77
2228815 2228815 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   grade_8 216 6 24 0   7     0   9   129 133                       262.0 216 6 24 0   7     0   9   129 133                 262
2228839 2228839 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_8 154 2 11 0   2     0   7   93 83                       176.0 154 2 11 0   2     0   7   93 83                 176
2228915 2228915 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_8 131 1 8 1   24     0   4   99 70                       169.0 131 1 8 1   24     0   4   99 70                 169
2228919 2228919 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_8 123 3 10 0   28     0   4   69 99                       168.0 123 3 10 0   28     0   4   69 99                 168
2228923 2228923 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_8 85 3 11 0   42     0   2   77 66                       143.0 85 3 11 0   42     0   2   77 66                 143
2228983 2228983 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_8 299 16 24 0   41     0   21   196 205                       401.0 299 16 24 0   41     0   21   196 205                 401
2229002 2229002 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_8 148 5 22 0   27     0   6   97 111                       208.0 148 5 22 0   27     0   6   97 111                 208
2229044 2229044 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_8 147 8 24 0   5     0   8   98 94                       192.0 147 8 24 0   5     0   8   98 94                 192
2229049 2229049 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_8 95 9 25 0   5     0   7   77 64                       141.0 95 9 25 0   5     0   7   77 64                 141
2229054 2229054 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_8 95 10 24 1   9     1   3   81 62                       143.0 95 10 24 1   9     1   3   81 62                 143
2229079 2229079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_8 184 3 14 0   5     0   10   109 107                       216.0 184 3 14 0   5     0   10   109 107                 216
2229097 2229097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_8 38 13 3 0   3     0   2   36 23                       59.0 38 13 3 0   3     0   2   36 23                 59
2229131 2229131 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_8 292 38 38 2   5     0   16   205 186                       391.0 292 38 38 2   5     0   16   205 186                 391
2229147 2229147 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_8 145 14 9 0   39     0   6   106 107                       213.0 145 14 9 0   39     0   6   106 107                 213
2229167 2229167 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Belchertown: Jabish Middle School   Regular School No Middle 07 08 2018   grade_8 181 2 1 0   2     1   5   97 95                       192.0 181 2 1 0   2     1   5   97 95                 192
2229191 2229191 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham: Bellingham High School   Regular School No High 08 12 2018   grade_8 161 6 3 0   5     0   6   85 96                       181.0 161 6 3 0   5     0   6   85 96                 181
2229197 2229197 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_8 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2229231 2229231 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_8 241 12 18 0   56     0   19   167 179                       346.0 241 12 18 0   56     0   19   167 179                 346
2229248 2229248 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_8 101 1 3 0   1     0   3   56 53                       109.0 101 1 3 0   1     0   3   56 53                 109
2229297 2229297 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   grade_8 285 13 32 0   9     0   11   198 152                       350.0 285 13 32 0   9     0   11   198 152                 350
2229348 2229348 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica: Marshall Middle School   Regular School No Middle 06 08 2018   grade_8 187 10 7 1   10     0   2   107 110                       217.0 187 10 7 1   10     0   2   107 110                 217
2229352 2229352 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica: Locke Middle   Regular School No Middle 06 08 2018   grade_8 142 5 4 0   14     0   7   93 79                       172.0 142 5 4 0   14     0   7   93 79                 172
2229378 2229378 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_8 6 3 10 0   1     0   0   12 8                       20.0 6 3 10 0   1     0   0   12 8                 20
2229407 2229407 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_8 1 12 21 0   1     0   4   28 11                       39.0 1 12 21 0   1     0   4   28 11                 39
2229418 2229418 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston: Jackson Mann   Regular School No Elementary PK 08 2018   grade_8 7 24 21 0   2     0   1   28 27                       55.0 7 24 21 0   2     0   1   28 27                 55
2229444 2229444 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_8 3 14 56 0   1     0   1   46 29                       75.0 3 14 56 0   1     0   1   46 29                 75
2229452 2229452 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2229500 2229500 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_8 1 44 16 0   0     1   0   26 36                       62.0 1 44 16 0   0     1   0   26 36                 62
2229515 2229515 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_8 5 20 18 0   1     0   1   26 19                       45.0 5 20 18 0   1     0   1   26 19                 45
2229526 2229526 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_8 3 2 69 0   0     0   1   32 43                       75.0 3 2 69 0   0     0   1   32 43                 75
2229545 2229545 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_8 9 6 7 1   2     0   1   11 15                       26.0 9 6 7 1   2     0   1   11 15                 26
2229564 2229564 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_8 2 22 24 0   0     0   0   23 25                       48.0 2 22 24 0   0     0   0   23 25                 48
2229607 2229607 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_8 9 26 21 0   4     0   5   32 33                       65.0 9 26 21 0   4     0   5   32 33                 65
2229617 2229617 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_8 0 12 34 0   0     0   0   24 22                       46.0 0 12 34 0   0     0   0   24 22                 46
2229661 2229661 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_8 3 34 82 0   10     0   0   68 61                       129.0 3 34 82 0   10     0   0   68 61                 129
2229688 2229688 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_8 0 0 16 0   0     0   0   7 9                       16.0 0 0 16 0   0     0   0   7 9                 16
2229699 2229699 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_8 2 43 15 0   4     0   1   34 31                       65.0 2 43 15 0   4     0   1   34 31                 65
2229718 2229718 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_8 6 8 10 0   3     0   0   13 14                       27.0 6 8 10 0   3     0   0   13 14                 27
2229753 2229753 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_8 0 8 18 0   0     0   1   12 15                       27.0 0 8 18 0   0     0   1   12 15                 27
2229779 2229779 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_8 7 27 13 2   37     1   2   42 47                       89.0 7 27 13 2   37     1   2   42 47                 89
2229808 2229808 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_8 0 40 39 1   0     0   4   41 43                       84.0 0 40 39 1   0     0   4   41 43                 84
2229815 2229815 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_8 10 31 44 0   2     0   1   45 43                       88.0 10 31 44 0   2     0   1   45 43                 88
2229826 2229826 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston: Lyndon   Regular School No Elementary PK 08 2018   grade_8 6 6 17 0   1     0   2   12 20                       32.0 6 6 17 0   1     0   2   12 20                 32
2229897 2229897 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_8 0 10 12 0   0     0   0   9 13                       22.0 0 10 12 0   0     0   0   9 13                 22
2229908 2229908 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston: Gardner Pilot Academy   Regular School No Elementary PK 08 2018   grade_8 5 8 24 0   3     0   2   22 20                       42.0 5 8 24 0   3     0   2   22 20                 42
2229927 2229927 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_8 7 5 15 0   1     0   0   17 11                       28.0 7 5 15 0   1     0   0   17 11                 28
2229943 2229943 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_8 2 17 14 0   1     0   3   30 7                       37.0 2 17 14 0   1     0   3   30 7                 37
2229966 2229966 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_8 0 13 9 0   0     0   1   11 12                       23.0 0 13 9 0   0     0   1   11 12                 23
2229985 2229985 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_8 7 8 33 1   9     0   1   32 27                       59.0 7 8 33 1   9     0   1   32 27                 59
2229996 2229996 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_8 2 18 7 0   0     0   0   12 15                       27.0 2 18 7 0   0     0   0   12 15                 27
2230004 2230004 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_8 0 15 18 0   0     0   2   18 17                       35.0 0 15 18 0   0     0   2   18 17                 35
2230015 2230015 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_8 1 62 18 1   2     0   0   49 35                       84.0 1 62 18 1   2     0   0   49 35                 84
2230026 2230026 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_8 1 15 17 0   0     0   1   23 11                       34.0 1 15 17 0   0     0   1   23 11                 34
2230037 2230037 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_8 5 4 8 0   0     0   1   13 5                       18.0 5 4 8 0   0     0   1   13 5                 18
2230041 2230041 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_8 3 91 87 0   18     0   3   107 95                       202.0 3 91 87 0   18     0   3   107 95                 202
2230057 2230057 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_8 17 28 14 0   6     0   3   39 29                       68.0 17 28 14 0   6     0   3   39 29                 68
2230065 2230065 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_8 7 13 71 0   5     0   3   48 51                       99.0 7 13 71 0   5     0   3   48 51                 99
2230069 2230069 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_8 3 43 45 2   0     0   2   45 50                       95.0 3 43 45 2   0     0   2   45 50                 95
2230073 2230073 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_8 5 40 86 0   0     1   5   72 65                       137.0 5 40 86 0   0     1   5   72 65                 137
2230141 2230141 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_8 83 54 62 0   45     0   13   113 144                       257.0 83 54 62 0   45     0   13   113 144                 257
2230166 2230166 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_8 167 23 55 0   113     0   22   160 220                       380.0 167 23 55 0   113     0   22   160 220                 380
2230174 2230174 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_8 0 12 14 1   40     0   1   35 33                       68.0 0 12 14 1   40     0   1   35 33                 68
2230181 2230181 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_8 32 45 49 1   31     0   2   68 92                       160.0 32 45 49 1   31     0   2   68 92                 160
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2230231 2230231 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_8 11 10 132 0   6     0   1   82 78                       160.0 11 10 132 0   6     0   1   82 78                 160
2230235 2230235 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_8 3 71 40 0   2     0   9   82 43                       125.0 3 71 40 0   2     0   9   82 43                 125
2230260 2230260 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_8 1 0 22 0   0     0   0   8 15                       23.0 1 0 22 0   0     0   0   8 15                 23
2230268 2230268 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_8 1 2 3 0   1     0   0   4 3                       7.0 1 2 3 0   1     0   0   4 3                 7
2230295 2230295 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_8 176 5 3 3   6     0   0   93 100                       193.0 176 5 3 3   6     0   0   93 100                 193
2230365 2230365 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree: East Middle School   Regular School No Middle 06 08 2018   grade_8 182 9 10 1   34     0   5   120 121                       241.0 182 9 10 1   34     0   5   120 121                 241
2230369 2230369 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_8 169 4 10 0   38     0   1   105 117                       222.0 169 4 10 0   38     0   1   105 117                 222
2230440 2230440 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_8 12 64 12 2   0     0   3   49 44                       93.0 12 64 12 2   0     0   3   49 44                 93
2230470 2230470 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230491 2230491 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton: East Middle School   Regular School No Middle 06 08 2018   grade_8 18 119 12 0   3     1   5   84 74                       158.0 18 119 12 0   3     1   5   84 74                 158
2230495 2230495 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_8 20 164 23 0   3     2   4   111 105                       216.0 20 164 23 0   3     2   4   111 105                 216
2230499 2230499 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton: South Middle School   Regular School No Middle 06 08 2018   grade_8 42 79 26 0   3     1   11   78 84                       162.0 42 79 26 0   3     1   11   78 84                 162
2230503 2230503 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_8 46 104 29 1   8     1   9   107 91                       198.0 46 104 29 1   8     1   9   107 91                 198
2230507 2230507 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton: Ashfield Middle School   Regular School No Middle 06 08 2018   grade_8 68 68 20 0   3     1   6   80 86                       166.0 68 68 20 0   3     1   6   80 86                 166
2230511 2230511 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_8 47 94 56 0   3     1   20   95 126                       221.0 47 94 56 0   3     1   20   95 126                 221
2230548 2230548 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_8 46 2 12 0   11     1   11   35 48                       83.0 46 2 12 0   11     1   11   35 48                 83
2230558 2230558 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_8 40 3 11 0   13     0   8   51 24                       75.0 40 3 11 0   13     0   8   51 24                 75
2230569 2230569 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_8 37 4 5 0   7     0   11   32 32                       64.0 37 4 5 0   7     0   11   32 32                 64
2230580 2230580 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_8 36 4 3 0   6     0   4   24 29                       53.0 36 4 3 0   6     0   4   24 29                 53
2230590 2230590 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   grade_8 42 8 7 0   16     0   6   45 34                       79.0 42 8 7 0   16     0   6   45 34                 79
2230600 2230600 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_8 35 5 8 0   8     0   5   35 26                       61.0 35 5 8 0   8     0   5   35 26                 61
2230610 2230610 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_8 49 2 10 0   17     0   5   38 45                       83.0 49 2 10 0   17     0   5   38 45                 83
2230621 2230621 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_8 40 0 8 0   8     0   14   40 30                       70.0 40 0 8 0   8     0   14   40 30                 70
2230661 2230661 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington: Marshall Simonds Middle   Regular School No Middle 06 08 2018   grade_8 196 19 13 2   34     0   12   146 130                       276.0 196 19 13 2   34     0   12   146 130                 276
2230687 2230687 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_8 9 1 10 0   1     0   4   13 12                       25.0 9 1 10 0   1     0   4   13 12                 25
2230771 2230771 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge: Cambridge Street Upper School   Regular School No Middle 06 08 2018   grade_8 21 31 21 1   7     1   9   44 47                       91.0 21 31 21 1   7     1   9   44 47                 91
2230775 2230775 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_8 23 33 19 1   9     1   8   48 46                       94.0 23 33 19 1   9     1   8   48 46                 94
2230779 2230779 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge: Rindge Avenue Upper School   Regular School No Middle 06 08 2018   grade_8 42 26 6 1   12     0   7   52 42                       94.0 42 26 6 1   12     0   7   52 42                 94
2230783 2230783 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge: Vassal Lane Upper School   Regular School No Middle 06 08 2018   grade_8 36 28 9 0   11     0   7   35 56                       91.0 36 28 9 0   11     0   7   35 56                 91
2230815 2230815 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_8 181 34 19 0   23     0   5   125 137                       262.0 181 34 19 0   23     0   5   125 137                 262
2230831 2230831 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_8 56 2 2 0   8     0   8   42 34                       76.0 56 2 2 0   8     0   8   42 34                 76
2230843 2230843 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_8 105 3 4 0   1     0   0   66 47                       113.0 105 3 4 0   1     0   0   66 47                 113
2230878 2230878 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford: Col Moses Parker School   Regular School No Middle 05 08 2018   grade_8 134 3 11 0   32     0   0   88 92                       180.0 134 3 11 0   32     0   0   88 92                 180
2230883 2230883 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_8 159 8 9 0   30     1   5   103 109                       212.0 159 8 9 0   30     1   5   103 109                 212

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