enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1122383 1122383 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_7 165 5 3 0   5     0   4   86 96                       182 165 5 3 0   5     0   4   86 96                 182
1122568 1122568 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_7 5 3 9 0   0     0   0   11 6                       17 5 3 9 0   0     0   0   11 6                 17
1122597 1122597 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_7 1 10 20 0   1     0   3   25 10                       35 1 10 20 0   1     0   3   25 10                 35
1122608 1122608 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2017   grade_7 6 27 22 0   1     0   1   32 25                       57 6 27 22 0   1     0   1   32 25                 57
1122629 1122629 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_7 2 16 51 0   1     0   0   45 25                       70 2 16 51 0   1     0   0   45 25                 70
1122701 1122701 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_7 5 18 18 0   1     0   0   22 20                       42 5 18 18 0   1     0   0   22 20                 42
1122712 1122712 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_7 1 2 72 0   0     0   1   33 43                       76 1 2 72 0   0     0   1   33 43                 76
1122731 1122731 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_7 7 7 9 1   1     0   1   12 14                       26 7 7 9 1   1     0   1   12 14                 26
1122750 1122750 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_7 3 19 26 0   0     0   0   22 26                       48 3 19 26 0   0     0   0   22 26                 48
1122793 1122793 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_7 10 26 20 0   4     0   5   32 33                       65 10 26 20 0   4     0   5   32 33                 65
1122802 1122802 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_7 0 13 35 0   2     0   0   25 25                       50 0 13 35 0   2     0   0   25 25                 50
1122873 1122873 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_7 1 0 18 0   0     0   0   10 9                       19 1 0 18 0   0     0   0   10 9                 19
1122884 1122884 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_7 1 42 14 0   3     0   0   33 27                       60 1 42 14 0   3     0   0   33 27                 60
1122903 1122903 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_7 7 8 7 0   0     0   0   12 10                       22 7 8 7 0   0     0   0   12 10                 22
1122946 1122946 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_7 0 8 19 0   0     0   1   15 13                       28 0 8 19 0   0     0   1   15 13                 28
1122972 1122972 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_7 10 26 14 1   36     1   1   41 48                       89 10 26 14 1   36     1   1   41 48                 89
1122991 1122991 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_7 5 4 4 0   1     0   0   13 1                       14 5 4 4 0   1     0   0   13 1                 14
1123002 1123002 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_7 0 43 44 1   0     0   4   42 50                       92 0 43 44 1   0     0   4   42 50                 92
1123009 1123009 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_7 7 31 41 0   2     0   1   44 38                       82 7 31 41 0   2     0   1   44 38                 82
1123020 1123020 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_7 5 4 19 0   0     0   2   11 19                       30 5 4 19 0   0     0   2   11 19                 30
1123092 1123092 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_7 0 8 14 0   0     0   0   8 14                       22 0 8 14 0   0     0   0   8 14                 22
1123103 1123103 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_7 5 7 23 0   4     0   0   18 21                       39 5 7 23 0   4     0   0   18 21                 39
1123122 1123122 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_7 7 5 12 0   2     0   0   18 8                       26 7 5 12 0   2     0   0   18 8                 26
1123161 1123161 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_7 0 15 11 0   0     1   1   17 11                       28 0 15 11 0   0     1   1   17 11                 28
1123180 1123180 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_7 17 9 41 0   5     0   1   41 32                       73 17 9 41 0   5     0   1   41 32                 73
1123191 1123191 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_7 1 14 4 0   0     0   0   10 9                       19 1 14 4 0   0     0   0   10 9                 19
1123200 1123200 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_7 0 18 24 1   0     0   4   25 22                       47 0 18 24 1   0     0   4   25 22                 47
1123210 1123210 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_7 1 62 19 2   2     0   0   49 37                       86 1 62 19 2   2     0   0   49 37                 86
1123221 1123221 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_7 1 25 23 0   0     0   1   31 19                       50 1 25 23 0   0     0   1   31 19                 50
1123232 1123232 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_7 6 5 9 0   0     0   1   15 6                       21 6 5 9 0   0     0   1   15 6                 21
1123410 1123410 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_7 11 7 131 0   6     0   1   81 75                       156 11 7 131 0   6     0   1   81 75                 156
1123439 1123439 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_7 1 0 25 0   0     0   0   9 17                       26 1 0 25 0   0     0   0   9 17                 26
1123621 1123621 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_7 14 70 12 2   0     0   2   52 48                       100 14 70 12 2   0     0   2   52 48                 100
1123733 1123733 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_7 50 3 12 0   14     1   11   43 48                       91 50 3 12 0   14     1   11   43 48                 91
1123743 1123743 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_7 37 4 11 0   14     0   6   48 24                       72 37 4 11 0   14     0   6   48 24                 72
1123754 1123754 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2017   grade_7 40 4 4 0   7     0   11   35 31                       66 40 4 4 0   7     0   11   35 31                 66
1123765 1123765 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2017   grade_7 35 4 3 0   7     0   3   22 30                       52 35 4 3 0   7     0   3   22 30                 52
1123775 1123775 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2017   grade_7 42 8 8 0   18     0   3   41 38                       79 42 8 8 0   18     0   3   41 38                 79
1123785 1123785 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_7 36 4 8 0   7     0   5   32 28                       60 36 4 8 0   7     0   5   32 28                 60
1123795 1123795 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_7 53 2 10 0   16     0   5   40 46                       86 53 2 10 0   16     0   5   40 46                 86
1123806 1123806 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2017   grade_7 41 0 8 0   8     0   13   40 30                       70 41 0 8 0   8     0   13   40 30                 70
1123871 1123871 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_7 8 1 11 0   1     0   4   13 12                       25 8 1 11 0   1     0   4   13 12                 25
1124015 1124015 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_7 52 2 3 0   8     0   8   42 31                       73 52 2 3 0   8     0   8   42 31                 73
1124214 1124214 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_7 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
1124226 1124226 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_7 90 4 30 0   1     0   2   70 57                       127 90 4 30 0   1     0   2   70 57                 127
1124604 1124604 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_7 27 1 6 0   0     0   0   23 11                       34 27 1 6 0   0     0   0   23 11                 34
1124625 1124625 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_7 10 7 33 0   3     0   1   25 29                       54 10 7 33 0   3     0   1   25 29                 54
1124642 1124642 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_7 32 12 38 0   2     0   3   45 42                       87 32 12 38 0   2     0   3   45 42                 87
1124652 1124652 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_7 29 20 40 1   8     0   1   56 43                       99 29 20 40 1   8     0   1   56 43                 99
1124671 1124671 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_7 37 22 37 0   5     0   3   50 54                       104 37 22 37 0   5     0   3   50 54                 104
1124681 1124681 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_7 15 16 70 2   1     0   0   52 52                       104 15 16 70 2   1     0   0   52 52                 104
1124751 1124751 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_7 33 2 20 0   6     0   7   30 38                       68 33 2 20 0   6     0   7   30 38                 68
1124762 1124762 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_7 30 3 13 0   0     0   2   26 22                       48 30 3 13 0   0     0   2   26 22                 48
1124819 1124819 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_7 1 2 2 0   0     0   2   6 *                       7 1 2 2 0   0     0   2   6                   7
1124905 1124905 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_7 20 3 36 0   4     0   5   29 39                       68 20 3 36 0   4     0   5   29 39                 68
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1125267 1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125283 1125283 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_7 88 4 20 0   4     0   9   66 59                       125 88 4 20 0   4     0   9   66 59                 125
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1125552 1125552 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_7 14 0 37 0   0     0   1   30 22                       52 14 0 37 0   0     0   1   30 22                 52
1125563 1125563 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_7 1 1 34 0   1     0   0   14 23                       37 1 1 34 0   1     0   0   14 23                 37
1125569 1125569 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_7 7 2 84 0   0     0   0   47 46                       93 7 2 84 0   0     0   0   47 46                 93
1125579 1125579 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_7 1 1 51 0   0     0   0   30 23                       53 1 1 51 0   0     0   0   30 23                 53
1125590 1125590 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_7 6 1 42 0   0     0   1   25 25                       50 6 1 42 0   0     0   1   25 25                 50
1125600 1125600 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_7 6 0 44 0   0     0   2   26 26                       52 6 0 44 0   0     0   2   26 26                 52
1125611 1125611 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_7 6 3 49 0   0     0   0   36 22                       58 6 3 49 0   0     0   0   36 22                 58
1125782 1125782 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_7 2 2 75 0   0     0   0   39 40                       79 2 2 75 0   0     0   0   39 40                 79
1125852 1125852 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_7 8 0 77 0   3     0   0   44 44                       88 8 0 77 0   3     0   0   44 44                 88
1126083 1126083 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_7 40 10 3 0   4     0   5   31 31                       62 40 10 3 0   4     0   5   31 31                 62
1126089 1126089 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_7 27 5 9 0   1     0   7   24 24                       49 27 5 9 0   1     0   7   24 24                 49
1126182 1126182 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2017   grade_7 33 2 9 0   4     0   2   28 22                       50 33 2 9 0   4     0   2   28 22                 50
1126252 1126252 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_7 2 0 3 0   0     0   1   6 *                       6 2 0 3 0   0     0   1   6                   6
1126262 1126262 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_7 12 7 18 0   22     0   0   30 29                       59 12 7 18 0   22     0   0   30 29                 59
1126548 1126548 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_7 24 13 10 0   37     0   1   35 50                       85 24 13 10 0   37     0   1   35 50                 85
1126558 1126558 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_7 18 24 28 1   22     0   1   37 57                       94 18 24 28 1   22     0   1   37 57                 94
1126568 1126568 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_7 23 9 11 0   3     0   5   21 30                       51 23 9 11 0   3     0   5   21 30                 51
1126578 1126578 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_7 28 20 20 0   17     0   2   50 37                       87 28 20 20 0   17     0   2   50 37                 87
1126590 1126590 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_7 27 38 50 1   25     0   5   78 68                       146 27 38 50 1   25     0   5   78 68                 146
1126768 1126768 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_7 93 4 13 1   1     0   2   54 60                       114 93 4 13 1   1     0   2   54 60                 114
1126922 1126922 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_7 96 2 25 0   2     0   3   67 61                       128 96 2 25 0   2     0   3   67 61                 128
1126933 1126933 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_7 95 0 36 0   11     0   5   83 64                       147 95 0 36 0   11     0   5   83 64                 147
1126944 1126944 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_7 77 0 69 0   1     0   7   82 72                       154 77 0 69 0   1     0   7   82 72                 154
1126955 1126955 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_7 50 0 80 0   8     1   12   73 78                       151 50 0 80 0   8     1   12   73 78                 151
1127568 1127568 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_7 24 0 0 0   0     0   1   11 14                       25 24 0 0 0   0     0   1   11 14                 25
1127577 1127577 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_7 29 1 2 0   0     0   4   16 20                       36 29 1 2 0   0     0   4   16 20                 36
1127587 1127587 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_7 24 0 2 0   0     0   2   16 12                       28 24 0 2 0   0     0   2   16 12                 28
1127921 1127921 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   grade_7 15 5 4 0   0     2   0   19 7                       26 15 5 4 0   0     2   0   19 7                 26
1128279 1128279 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_7 4 2 4 0   0     0   0   4 6                       10 4 2 4 0   0     0   0   4 6                 10
1128555 1128555 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_7 20 0 1 0   0     0   0   7 14                       21 20 0 1 0   0     0   0   7 14                 21
1128643 1128643 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No Elementary KG 08 2017   grade_7 10 0 33 0   0     0   0   24 19                       43 10 0 33 0   0     0   0   24 19                 43
1128660 1128660 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_7 20 2 15 0   0     0   5   21 21                       42 20 2 15 0   0     0   5   21 21                 42
1128951 1128951 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_7 21 1 20 0   2     0   2   23 23                       46 21 1 20 0   2     0   2   23 23                 46
1128962 1128962 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   grade_7 34 6 13 0   7     0   2   37 25                       62 34 6 13 0   7     0   2   37 25                 62
1128973 1128973 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_7 18 2 19 0   7     0   2   20 28                       48 18 2 19 0   7     0   2   20 28                 48
1128983 1128983 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2017   grade_7 5 5 42 0   1     1   0   26 28                       54 5 5 42 0   1     1   0   26 28                 54
1128994 1128994 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_7 26 9 10 0   3     0   3   27 24                       51 26 9 10 0   3     0   3   27 24                 51
1129005 1129005 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_7 5 7 45 0   6     0   1   35 29                       64 5 7 45 0   6     0   1   35 29                 64
1129216 1129216 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_7 6 9 14 0   0     0   2   15 16                       31 6 9 14 0   0     0   2   15 16                 31
1129746 1129746 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_7 23 0 9 3   1     0   3   19 20                       39 23 0 9 3   1     0   3   19 20                 39
1131108 1131108 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_7 15 7 13 0   2     0   3   17 23                       40 15 7 13 0   2     0   3   17 23                 40

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