enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
2228764 2228764 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_6 173 2 10 0   3     0   0   106 82                       188.0 173 2 10 0   3     0   0   106 82                 188
2228781 2228781 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_6 109 2 2 0   0     0   1   62 52                       114.0 109 2 2 0   0     0   1   62 52                 114
2228812 2228812 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_6 249 9 18 0   14     0   10   169 131                       300.0 249 9 18 0   14     0   10   169 131                 300
2228837 2228837 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_6 145 4 14 0   0     1   3   77 90                       167.0 145 4 14 0   0     1   3   77 90                 167
2228858 2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
2228866 2228866 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_6 25 9 13 0   0     0   3   24 26                       50.0 25 9 13 0   0     0   3   24 26                 50
2228874 2228874 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_6 27 11 12 1   4     0   4   29 30                       59.0 27 11 12 1   4     0   4   29 30                 59
2228913 2228913 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_6 142 4 15 0   18     0   6   82 103                       185.0 142 4 15 0   18     0   6   82 103                 185
2228917 2228917 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_6 126 7 10 1   28     0   4   96 80                       176.0 126 7 10 1   28     0   4   96 80                 176
2228921 2228921 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_6 77 4 13 1   44     0   4   79 64                       143.0 77 4 13 1   44     0   4   79 64                 143
2228981 2228981 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_6 328 11 28 0   52     1   22   204 238                       442.0 328 11 28 0   52     1   22   204 238                 442
2229000 2229000 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_6 139 4 27 1   30     0   6   101 106                       207.0 139 4 27 1   30     0   6   101 106                 207
2229042 2229042 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_6 121 5 22 0   8     0   11   82 85                       167.0 121 5 22 0   8     0   11   82 85                 167
2229047 2229047 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_6 93 5 29 1   9     0   7   69 75                       144.0 93 5 29 1   9     0   7   69 75                 144
2229052 2229052 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_6 104 6 27 0   7     0   11   80 75                       155.0 104 6 27 0   7     0   11   80 75                 155
2229077 2229077 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_6 166 3 15 0   8     0   6   109 89                       198.0 166 3 15 0   8     0   6   109 89                 198
2229094 2229094 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_6 32 17 4 1   2     0   3   33 26                       59.0 32 17 4 1   2     0   3   33 26                 59
2229128 2229128 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_6 263 30 58 0   9     0   18   206 172                       378.0 263 30 58 0   9     0   18   206 172                 378
2229145 2229145 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_6 121 10 10 0   28     0   12   100 81                       181.0 121 10 10 0   28     0   12   100 81                 181
2229160 2229160 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown: Chestnut Hill Community School   Regular School No Middle 04 06 2018   grade_6 164 3 12 0   3     1   4   75 112                       187.0 164 3 12 0   3     1   4   75 112                 187
2229188 2229188 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham: Bellingham Memorial School   Regular School No Middle 04 07 2018   grade_6 162 3 9 1   8     0   6   106 83                       189.0 162 3 9 1   8     0   6   106 83                 189
2229229 2229229 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_6 246 13 24 1   52     0   25   178 183                       361.0 246 13 24 1   52     0   25   178 183                 361
2229246 2229246 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_6 86 1 3 0   0     0   1   46 45                       91.0 86 1 3 0   0     0   1   46 45                 91
2229295 2229295 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   grade_6 242 11 48 0   9     0   8   166 152                       318.0 242 11 48 0   9     0   8   166 152                 318
2229346 2229346 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica: Marshall Middle School   Regular School No Middle 06 08 2018   grade_6 182 5 17 1   19     0   1   119 106                       225.0 182 5 17 1   19     0   1   119 106                 225
2229350 2229350 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica: Locke Middle   Regular School No Middle 06 08 2018   grade_6 128 6 11 0   11     2   4   87 75                       162.0 128 6 11 0   11     2   4   87 75                 162
2229376 2229376 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_6 3 3 7 0   2     0   2   12 5                       17.0 3 3 7 0   2     0   2   12 5                 17
2229405 2229405 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_6 20 8 15 0   1     0   2   20 26                       46.0 20 8 15 0   1     0   2   20 26                 46
2229416 2229416 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston: Jackson Mann   Regular School No Elementary PK 08 2018   grade_6 4 25 28 0   6     0   4   37 30                       67.0 4 25 28 0   6     0   4   37 30                 67
2229442 2229442 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_6 16 25 64 0   3     0   3   52 59                       111.0 16 25 64 0   3     0   3   52 59                 111
2229498 2229498 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_6 0 36 24 0   0     1   1   30 32                       62.0 0 36 24 0   0     1   1   30 32                 62
2229513 2229513 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_6 9 15 20 0   1     0   3   21 27                       48.0 9 15 20 0   1     0   3   21 27                 48
2229524 2229524 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_6 6 3 88 0   0     0   1   47 51                       98.0 6 3 88 0   0     0   1   47 51                 98
2229543 2229543 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_6 24 7 11 0   5     0   1   22 26                       48.0 24 7 11 0   5     0   1   22 26                 48
2229562 2229562 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_6 10 23 19 0   1     0   2   23 32                       55.0 10 23 19 0   1     0   2   23 32                 55
2229605 2229605 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_6 25 39 44 0   9     0   4   66 55                       121.0 25 39 44 0   9     0   4   66 55                 121
2229615 2229615 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_6 0 20 49 0   2     0   1   36 36                       72.0 0 20 49 0   2     0   1   36 36                 72
2229659 2229659 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_6 7 34 65 0   5     0   7   70 48                       118.0 7 34 65 0   5     0   7   70 48                 118
2229686 2229686 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_6 8 0 20 0   0     0   2   15 15                       30.0 8 0 20 0   0     0   2   15 15                 30
2229697 2229697 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_6 4 39 20 0   10     0   6   46 33                       79.0 4 39 20 0   10     0   6   46 33                 79
2229716 2229716 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_6 24 1 16 0   2     0   1   23 21                       44.0 24 1 16 0   2     0   1   23 21                 44
2229751 2229751 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_6 0 15 23 0   1     0   1   20 20                       40.0 0 15 23 0   1     0   1   20 20                 40
2229777 2229777 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_6 22 18 40 0   61     0   5   70 76                       146.0 22 18 40 0   61     0   5   70 76                 146
2229796 2229796 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_6 14 5 4 0   0     0   0   14 9                       23.0 14 5 4 0   0     0   0   14 9                 23
2229806 2229806 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_6 1 45 41 1   2     0   2   45 47                       92.0 1 45 41 1   2     0   2   45 47                 92
2229813 2229813 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_6 30 31 57 0   2     0   6   65 61                       126.0 30 31 57 0   2     0   6   65 61                 126
2229824 2229824 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston: Lyndon   Regular School No Elementary PK 08 2018   grade_6 23 8 24 0   1     0   3   30 29                       59.0 23 8 24 0   1     0   3   30 29                 59
2229895 2229895 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_6 1 13 25 0   0     0   1   26 14                       40.0 1 13 25 0   0     0   1   26 14                 40
2229906 2229906 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston: Gardner Pilot Academy   Regular School No Elementary PK 08 2018   grade_6 6 6 30 0   3     0   2   24 23                       47.0 6 6 30 0   3     0   2   24 23                 47
2229925 2229925 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_6 27 12 25 0   5     0   2   35 36                       71.0 27 12 25 0   5     0   2   35 36                 71
2229941 2229941 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_6 1 5 12 0   0     0   0   15 3                       18.0 1 5 12 0   0     0   0   15 3                 18
2229964 2229964 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_6 4 19 16 0   0     0   6   21 24                       45.0 4 19 16 0   0     0   6   21 24                 45
2229983 2229983 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_6 16 14 39 1   13     0   2   48 37                       85.0 16 14 39 1   13     0   2   48 37                 85
2229994 2229994 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_6 1 22 18 0   1     0   4   18 28                       46.0 1 22 18 0   1     0   4   18 28                 46
2230002 2230002 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_6 0 20 21 0   0     0   4   22 23                       45.0 0 20 21 0   0     0   4   22 23                 45
2230013 2230013 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_6 2 72 27 2   0     0   5   54 54                       108.0 2 72 27 2   0     0   5   54 54                 108
2230024 2230024 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_6 1 24 23 0   0     0   0   27 21                       48.0 1 24 23 0   0     0   0   27 21                 48
2230035 2230035 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_6 1 6 11 0   0     0   1   9 10                       19.0 1 6 11 0   0     0   1   9 10                 19
2230039 2230039 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_6 2 66 65 0   5     0   5   76 67                       143.0 2 66 65 0   5     0   5   76 67                 143
2230055 2230055 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_6 10 33 11 0   5     0   3   32 30                       62.0 10 33 11 0   5     0   3   32 30                 62
2230063 2230063 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_6 7 13 69 0   11     0   2   61 41                       102.0 7 13 69 0   11     0   2   61 41                 102
2230067 2230067 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_6 14 46 57 1   3     0   5   59 67                       126.0 14 46 57 1   3     0   5   59 67                 126
2230071 2230071 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_6 0 31 67 0   2     0   2   43 59                       102.0 0 31 67 0   2     0   2   43 59                 102
2230172 2230172 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_6 9 29 28 0   76     0   5   68 79                       147.0 9 29 28 0   76     0   5   68 79                 147
2230209 2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2230229 2230229 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_6 16 5 177 0   6     0   1   104 101                       205.0 16 5 177 0   6     0   1   104 101                 205
2230233 2230233 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_6 1 58 43 0   6     0   4   57 55                       112.0 1 58 43 0   6     0   4   57 55                 112
2230258 2230258 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_6 1 1 23 0   0     0   0   7 18                       25.0 1 1 23 0   0     0   0   7 18                 25
2230293 2230293 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_6 156 2 10 1   1     0   3   86 87                       173.0 156 2 10 1   1     0   3   86 87                 173
2230310 2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2230363 2230363 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree: East Middle School   Regular School No Middle 06 08 2018   grade_6 164 8 16 1   41     0   2   122 110                       232.0 164 8 16 1   41     0   2   122 110                 232
2230367 2230367 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_6 163 9 10 0   32     0   0   106 108                       214.0 163 9 10 0   32     0   0   106 108                 214
2230393 2230393 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_6 43 0 0 0   1     0   0   20 24                       44.0 43 0 0 0   1     0   0   20 24                 44
2230438 2230438 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_6 20 69 17 0   0     1   6   56 57                       113.0 20 69 17 0   0     1   6   56 57                 113
2230482 2230482 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_6 2 3 0 0   0     0   1   5 1                       6.0 2 3 0 0   0     0   1   5 1                 6
2230489 2230489 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton: East Middle School   Regular School No Middle 06 08 2018   grade_6 30 100 19 0   2     0   6   89 68                       157.0 30 100 19 0   2     0   6   89 68                 157
2230493 2230493 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_6 18 145 33 2   6     0   8   126 86                       212.0 18 145 33 2   6     0   8   126 86                 212
2230497 2230497 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton: South Middle School   Regular School No Middle 06 08 2018   grade_6 34 85 35 0   2     0   8   88 76                       164.0 34 85 35 0   2     0   8   88 76                 164
2230501 2230501 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_6 46 122 31 0   6     1   7   115 98                       213.0 46 122 31 0   6     1   7   115 98                 213
2230505 2230505 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton: Ashfield Middle School   Regular School No Middle 06 08 2018   grade_6 58 79 21 1   5     0   6   90 80                       170.0 58 79 21 1   5     0   6   90 80                 170
2230509 2230509 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_6 60 85 69 0   8     0   10   102 130                       232.0 60 85 69 0   8     0   10   102 130                 232
2230534 2230534 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2230546 2230546 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_6 35 4 12 0   25     0   9   54 31                       85.0 35 4 12 0   25     0   9   54 31                 85
2230556 2230556 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_6 47 5 14 0   18     0   10   41 53                       94.0 47 5 14 0   18     0   10   41 53                 94
2230567 2230567 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_6 34 6 9 0   13     0   13   39 36                       75.0 34 6 9 0   13     0   13   39 36                 75
2230578 2230578 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_6 34 2 5 0   10     0   4   33 22                       55.0 34 2 5 0   10     0   4   33 22                 55
2230588 2230588 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   grade_6 36 5 13 0   13     0   8   38 37                       75.0 36 5 13 0   13     0   8   38 37                 75
2230598 2230598 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_6 28 7 11 0   11     0   3   28 32                       60.0 28 7 11 0   11     0   3   28 32                 60
2230608 2230608 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_6 42 6 13 0   12     0   3   43 33                       76.0 42 6 13 0   12     0   3   43 33                 76
2230619 2230619 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_6 38 2 8 0   8     0   9   36 29                       65.0 38 2 8 0   8     0   9   36 29                 65
2230659 2230659 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington: Marshall Simonds Middle   Regular School No Middle 06 08 2018   grade_6 179 15 14 1   40     0   4   120 133                       253.0 179 15 14 1   40     0   4   120 133                 253
2230685 2230685 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_6 13 0 20 0   1     0   2   11 25                       36.0 13 0 20 0   1     0   2   11 25                 36
2230769 2230769 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge: Cambridge Street Upper School   Regular School No Middle 06 08 2018   grade_6 30 19 17 0   3     0   8   43 34                       77.0 30 19 17 0   3     0   8   43 34                 77
2230773 2230773 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_6 22 29 11 0   12     0   5   43 36                       79.0 22 29 11 0   12     0   5   43 36                 79
2230777 2230777 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge: Rindge Avenue Upper School   Regular School No Middle 06 08 2018   grade_6 38 24 7 0   7     0   8   34 50                       84.0 38 24 7 0   7     0   8   34 50                 84
2230781 2230781 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge: Vassal Lane Upper School   Regular School No Middle 06 08 2018   grade_6 36 22 11 0   13     0   8   36 54                       90.0 36 22 11 0   13     0   8   36 54                 90
2230813 2230813 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_6 163 27 13 0   20     0   12   114 121                       235.0 163 27 13 0   20     0   12   114 121                 235
2230829 2230829 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_6 51 0 3 0   5     0   11   39 31                       70.0 51 0 3 0   5     0   11   39 31                 70
2230841 2230841 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_6 119 1 2 0   0     0   3   78 47                       125.0 119 1 2 0   0     0   3   78 47                 125
2230876 2230876 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford: Col Moses Parker School   Regular School No Middle 05 08 2018   grade_6 125 4 14 0   30     0   3   84 92                       176.0 125 4 14 0   30     0   3   84 92                 176

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