enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_7 · 499 ✖
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
2040387 2040387 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_7 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041702 2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2043454 2043454 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_7 * * * *   *     *   *   3 *                       4.0                         3                   4
2043509 2043509 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048250 2048250 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_7 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040596 2040596 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   9 7                       16.0 0 0 16 0   0     0   0   9 7                 16
2041093 2041093 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   4 12                       16.0 0 0 16 0   0     0   0   4 12                 16
2041465 2041465 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_7 13 0 21 0   1     0   2   11 26                       37.0 13 0 21 0   1     0   2   11 26                 37
2041589 2041589 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_7 50 0 5 0   5     0   11   39 32                       71.0 50 0 5 0   5     0   11   39 32                 71
2041759 2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2041933 2041933 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_7 114 0 3 0   1     0   4   79 43                       122.0 114 0 3 0   1     0   4   79 43                 122
2042033 2042033 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_7 77 0 11 0   6     0   2   43 53                       96.0 77 0 11 0   6     0   2   43 53                 96
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2042617 2042617 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_7 50 0 4 0   1     0   1   27 29                       56.0 50 0 4 0   1     0   1   27 29                 56
2042656 2042656 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_7 33 0 3 0   3     3   3   25 20                       45.0 33 0 3 0   3     3   3   25 20                 45
2042703 2042703 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_7 64 0 4 0   10     0   2   44 36                       80.0 64 0 4 0   10     0   2   44 36                 80
2042885 2042885 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_7 12 0 29 0   0     0   0   22 19                       41.0 12 0 29 0   0     0   0   22 19                 41
2042993 2042993 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2019   grade_7 179 0 24 0   7     0   2   98 114                       212.0 179 0 24 0   7     0   2   98 114                 212
2043090 2043090 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_7 7 0 129 0   0     0   2   60 78                       138.0 7 0 129 0   0     0   2   60 78                 138
2043103 2043103 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 106 0   0     0   0   61 52                       113.0 7 0 106 0   0     0   0   61 52                 113
2043147 2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2043190 2043190 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_7 55 0 8 0   2     0   2   37 30                       67.0 55 0 8 0   2     0   2   37 30                 67
2043668 2043668 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_7 2 0 4 0   1     0   1   7 1                       8.0 2 0 4 0   1     0   1   7 1                 8
2043856 2043856 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2019   grade_7 262 0 9 0   3     0   6   141 139                       280.0 262 0 9 0   3     0   6   141 139                 280
2044416 2044416 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_7 1 0 4 0   0     0   1   3 3                       6.0 1 0 4 0   0     0   1   3 3                 6
2044750 2044750 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_7 56 0 4 0   0     0   3   35 28                       63.0 56 0 4 0   0     0   3   35 28                 63
2044817 2044817 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2019   grade_7 143 0 4 0   6     1   5   98 61                       159.0 143 0 4 0   6     1   5   98 61                 159
2045144 2045144 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2019   grade_7 230 0 4 1   1     0   10   132 114                       246.0 230 0 4 1   1     0   10   132 114                 246
2045405 2045405 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_7 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2045488 2045488 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2019   grade_7 21 0 14 0   1     0   4   22 18                       40.0 21 0 14 0   1     0   4   22 18                 40
2045521 2045521 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_7 215 0 2 0   2     0   2   102 118                       221.0 215 0 2 0   2     0   2   102 118                 221
2045713 2045713 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_7 197 0 9 0   0     0   1   106 101                       207.0 197 0 9 0   0     0   1   106 101                 207
2045809 2045809 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2019   grade_7 104 0 10 0   30     0   8   84 68                       152.0 104 0 10 0   30     0   8   84 68                 152
2046858 2046858 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_7 111 0 7 0   62     0   4   94 90                       184.0 111 0 7 0   62     0   4   94 90                 184
2046903 2046903 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2019   grade_7 137 0 7 0   0     0   6   79 71                       150.0 137 0 7 0   0     0   6   79 71                 150
2047604 2047604 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_7 0 0 32 0   1     0   0   14 19                       33.0 0 0 32 0   1     0   0   14 19                 33
2047634 2047634 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_7 102 0 9 0   21     0   12   78 66                       144.0 102 0 9 0   21     0   12   78 66                 144
2047648 2047648 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_7 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2047703 2047703 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_7 2 0 32 0   0     0   0   10 24                       34.0 2 0 32 0   0     0   0   10 24                 34
2047763 2047763 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_7 36 0 2 0   11     0   3   21 31                       52.0 36 0 2 0   11     0   3   21 31                 52
2047793 2047793 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 0 65 0   0     0   0   33 38                       71.0 6 0 65 0   0     0   0   33 38                 71
2048287 2048287 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_7 119 0 3 0   2     0   5   66 63                       129.0 119 0 3 0   2     0   5   66 63                 129
2048339 2048339 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2019   grade_7 140 0 7 0   3     0   6   85 71                       156.0 140 0 7 0   3     0   6   85 71                 156
2048535 2048535 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2019   grade_7 128 0 3 0   1     0   4   70 65                       136.0 128 0 3 0   1     0   4   70 65                 136
2048575 2048575 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_7 107 0 3 0   1     0   2   59 54                       113.0 107 0 3 0   1     0   2   59 54                 113
2048585 2048585 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2019   grade_7 281 0 9 0   13     0   6   142 167                       309.0 281 0 9 0   13     0   6   142 167                 309
2048680 2048680 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2019   grade_7 62 0 4 0   1     0   1   33 35                       68.0 62 0 4 0   1     0   1   33 35                 68
2048700 2048700 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_7 108 0 4 0   0     0   3   63 52                       115.0 108 0 4 0   0     0   3   63 52                 115
2048729 2048729 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   grade_7 53 0 2 0   11     0   2   34 34                       68.0 53 0 2 0   11     0   2   34 34                 68
2048735 2048735 MA Middlesex   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2019   grade_7 99 0 1 0   1     0   4   48 57                       105.0 99 0 1 0   1     0   4   48 57                 105
2048815 2048815 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2019   grade_7 181 0 7 0   3     0   0   90 101                       191.0 181 0 7 0   3     0   0   90 101                 191
2048892 2048892 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_7 93 0 6 0   1     0   2   60 42                       102.0 93 0 6 0   1     0   2   60 42                 102
2048931 2048931 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2019   grade_7 42 0 1 0   0     0   2   18 27                       45.0 42 0 1 0   0     0   2   18 27                 45
2048945 2048945 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_7 101 0 7 0   1     0   4   57 56                       113.0 101 0 7 0   1     0   4   57 56                 113
2049029 2049029 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_7 37 0 1 1   1     0   3   28 15                       43.0 37 0 1 1   1     0   3   28 15                 43
2049074 2049074 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_7 40 0 5 0   1     0   0   17 29                       46.0 40 0 5 0   1     0   0   17 29                 46
2040217 2040217 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 3 0   0     0   2   44 48                       92.0 86 1 3 0   0     0   2   44 48                 92
2041124 2041124 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_7 158 1 10 2   1     0   5   90 87                       177.0 158 1 10 2   1     0   5   90 87                 177
2041599 2041599 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_7 121 1 3 0   0     0   3   80 48                       128.0 121 1 3 0   0     0   3   80 48                 128
2041987 2041987 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2019   grade_7 222 1 3 0   6     0   11   119 124                       243.0 222 1 3 0   6     0   11   119 124                 243
2042137 2042137 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_7 1 1 4 0   0     0   0   4 2                       6.0 1 1 4 0   0     0   0   4 2                 6
2042270 2042270 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_7 3 1 0 0   0     0   5   8 1                       9.0 3 1 0 0   0     0   5   8 1                 9
2042278 2042278 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_7 9 1 5 0   0     0   2   7 10                       17.0 9 1 5 0   0     0   2   7 10                 17
2042541 2042541 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_7 94 1 2 0   0     0   0   51 46                       97.0 94 1 2 0   0     0   0   51 46                 97
2042717 2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
2042905 2042905 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_7 1 1 49 0   0     0   0   30 21                       51.0 1 1 49 0   0     0   0   30 21                 51
2042931 2042931 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_7 2 1 37 0   0     0   0   15 25                       40.0 2 1 37 0   0     0   0   15 25                 40
2043007 2043007 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_7 59 1 0 0   1     0   2   31 32                       63.0 59 1 0 0   1     0   2   31 32                 63
2043069 2043069 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_7 2 1 140 0   0     0   0   71 70                       143.0 2 1 140 0   0     0   0   71 70                 143
2043122 2043122 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_7 1 1 72 0   2     0   0   36 40                       76.0 1 1 72 0   2     0   0   36 40                 76
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2043161 2043161 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_7 50 1 2 0   2     0   1   31 25                       56.0 50 1 2 0   2     0   1   31 25                 56
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
2044017 2044017 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_7 77 1 47 0   9     0   7   70 71                       141.0 77 1 47 0   9     0   7   70 71                 141
2044123 2044123 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_7 75 1 12 0   6     0   6   54 46                       100.0 75 1 12 0   6     0   6   54 46                 100
2044171 2044171 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_7 54 1 6 0   2     2   3   33 35                       68.0 54 1 6 0   2     2   3   33 35                 68
2044894 2044894 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2019   grade_7 121 1 14 0   3     1   8   81 67                       148.0 121 1 14 0   3     1   8   81 67                 148
2044909 2044909 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_7 84 1 10 0   4     0   6   49 56                       105.0 84 1 10 0   4     0   6   49 56                 105
2045005 2045005 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_7 215 1 0 0   1     1   1   125 94                       219.0 215 1 0 0   1     1   1   125 94                 219
2046450 2046450 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2019   grade_7 127 1 6 1   4     0   3   78 64                       142.0 127 1 6 1   4     0   3   78 64                 142
2046525 2046525 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2019   grade_7 114 1 6 0   17     0   5   69 74                       143.0 114 1 6 0   17     0   5   69 74                 143
2047079 2047079 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_7 78 1 6 0   0     0   2   42 45                       87.0 78 1 6 0   0     0   2   42 45                 87
2047136 2047136 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2019   grade_7 121 1 35 0   3     0   4   93 71                       164.0 121 1 35 0   3     0   4   93 71                 164
2047849 2047849 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_7 17 1 1 1   0     0   0   8 12                       20.0 17 1 1 1   0     0   0   8 12                 20
2047890 2047890 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2019   grade_7 67 1 0 0   0     0   2   37 33                       70.0 67 1 0 0   0     0   2   37 33                 70
2047920 2047920 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_7 25 1 3 0   2     0   2   11 22                       33.0 25 1 3 0   2     0   2   11 22                 33
2048372 2048372 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2019   grade_7 142 1 11 0   2     0   3   80 79                       159.0 142 1 11 0   2     0   3   80 79                 159
2048478 2048478 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2019   grade_7 77 1 7 0   0     0   9   43 51                       94.0 77 1 7 0   0     0   9   43 51                 94
2048504 2048504 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_7 106 1 7 0   8     1   2   43 82                       125.0 106 1 7 0   8     1   2   43 82                 125
2048518 2048518 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_7 14 1 2 0   0     0   1   8 10                       18.0 14 1 2 0   0     0   1   8 10                 18
2048599 2048599 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_7 171 1 11 0   4     0   11   104 94                       198.0 171 1 11 0   4     0   11   104 94                 198
2048732 2048732 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2019   grade_7 83 1 4 0   2     0   3   48 45                       93.0 83 1 4 0   2     0   3   48 45                 93
2048850 2048850 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2019   grade_7 58 1 1 0   0     0   3   35 28                       63.0 58 1 1 0   0     0   3   35 28                 63
2048885 2048885 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_7 170 1 7 0   3     0   2   87 96                       183.0 170 1 7 0   3     0   2   87 96                 183
2049009 2049009 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2019   grade_7 168 1 4 0   3     0   3   91 88                       179.0 168 1 4 0   3     0   3   91 88                 179
2049065 2049065 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_7 54 1 5 0   0     0   2   34 28                       62.0 54 1 5 0   0     0   2   34 28                 62
2049087 2049087 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 4 0   1     0   2   43 51                       94.0 86 1 4 0   1     0   2   43 51                 94
2049110 2049110 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2019   grade_7 85 1 6 0   0     0   4   53 43                       96.0 85 1 6 0   0     0   4   53 43                 96

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