enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by native_hawaiian_pacific_islander_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 400 ✖

grade ✖

  • grade_7 · 400 ✖
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
1366742 1366742 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2020   grade_7 176 11 11 1   26     0   11   123 113 *                     236.0 176 11 11 1   26     0   11   123 113                 236
1366784 1366784 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_7 215 10 27 1   4     0   8   135 130 *                     265.0 215 10 27 1   4     0   8   135 130                 265
1366841 1366841 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_7 173 21 45 1   5     0   13   137 121 *                     258.0 173 21 45 1   5     0   13   137 121                 258
1366864 1366864 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_7 96 1 4 0   2     0   2   47 58 *                     105.0 96 1 4 0   2     0   2   47 58                 105
1366903 1366903 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2020   grade_7 241 22 49 0   20     0   3   175 160 *                     335.0 241 22 49 0   20     0   3   175 160                 335
1366917 1366917 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_7 241 0 6 1   3     0   7   114 144 *                     258.0 241 0 6 1   3     0   7   114 144                 258
1366962 1366962 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_7 85 1 17 1   6     0   1   53 58 *                     111.0 85 1 17 1   6     0   1   53 58                 111
1366980 1366980 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_7 145 13 15 0   8     0   9   88 102 *                     190.0 145 13 15 0   8     0   9   88 102                 190
1367002 1367002 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_7 246 28 17 0   7     0   9   150 157 *                     307.0 246 28 17 0   7     0   9   150 157                 307
1367017 1367017 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_7 25 1 7 2   1     0   2   20 18 *                     38.0 25 1 7 2   1     0   2   20 18                 38
1367036 1367036 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_7 9 4 43 0   4     0   1   31 30 *                     61.0 9 4 43 0   4     0   1   31 30                 61
1367052 1367052 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_7 31 15 38 0   6     0   1   46 45 *                     91.0 31 15 38 0   6     0   1   46 45                 91
1367061 1367061 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_7 32 21 66 0   7     0   4   65 65 *                     130.0 32 21 66 0   7     0   4   65 65                 130
1367065 1367065 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_7 1 4 3 0   0     0   1   8 1 *                     9.0 1 4 3 0   0     0   1   8 1                 9
1367077 1367077 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_7 38 17 74 1   4     0   4   70 68 *                     138.0 38 17 74 1   4     0   4   70 68                 138
1367086 1367086 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_7 15 19 78 0   4     0   3   53 66 *                     119.0 15 19 78 0   4     0   3   53 66                 119
1367107 1367107 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_7 126 1 7 2   4     0   4   74 70 *                     144.0 126 1 7 2   4     0   4   74 70                 144
1367149 1367149 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_7 27 7 38 0   5     0   8   38 47 *                     85.0 27 7 38 0   5     0   8   38 47                 85
1367159 1367159 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_7 26 2 21 0   0     0   4   27 26 *                     53.0 26 2 21 0   0     0   4   27 26                 53
1367188 1367188 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_7 81 10 63 0   8     0   13   98 77 *                     175.0 81 10 63 0   8     0   13   98 77                 175
1367194 1367194 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_7 148 16 63 0   11     0   22   112 148 *                     260.0 148 16 63 0   11     0   22   112 148                 260
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1367207 1367207 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_7 3 2 8 0   0     0   3   12 4 *                     16.0 3 2 8 0   0     0   3   12 4                 16
1367237 1367237 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_7 205 15 14 1   13     0   18   142 124 *                     266.0 205 15 14 1   13     0   18   142 124                 266
1367258 1367258 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_7 43 7 83 0   14     0   13   79 81 *                     160.0 43 7 83 0   14     0   13   79 81                 160
1367278 1367278 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_7 18 3 38 0   4     0   10   33 40 *                     73.0 18 3 38 0   4     0   10   33 40                 73
1367297 1367297 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_7 13 1 0 0   0     0   0   9 5 *                     14.0 13 1 0 0   0     0   0   9 5                 14
1367317 1367317 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_7 181 13 8 1   8     0   5   117 99 *                     216.0 181 13 8 1   8     0   5   117 99                 216
1367380 1367380 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_7 144 14 35 0   8     0   4   93 112 *                     205.0 144 14 35 0   8     0   4   93 112                 205
1367383 1367383 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_7 67 21 101 0   2     0   5   115 81 *                     196.0 67 21 101 0   2     0   5   115 81                 196
1367386 1367386 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_7 132 10 69 1   9     0   16   114 123 *                     237.0 132 10 69 1   9     0   16   114 123                 237
1367430 1367430 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_7 105 2 10 1   4     0   0   68 54 *                     122.0 105 2 10 1   4     0   0   68 54                 122
1367433 1367433 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_7 104 5 6 0   10     0   1   69 57 *                     126.0 104 5 6 0   10     0   1   69 57                 126
1367436 1367436 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_7 140 2 10 0   13     0   2   100 67 *                     167.0 140 2 10 0   13     0   2   100 67                 167
1367451 1367451 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2020   grade_7 126 3 47 0   5     0   19   104 96 *                     200.0 126 3 47 0   5     0   19   104 96                 200
1367507 1367507 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_7 173 2 21 3   1     0   2   86 116 *                     202.0 173 2 21 3   1     0   2   86 116                 202
1367530 1367530 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_7 214 3 17 0   26     0   10   150 120 *                     270.0 214 3 17 0   26     0   10   150 120                 270
1367544 1367544 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2020   grade_7 47 0 4 0   0     0   1   29 23 *                     52.0 47 0 4 0   0     0   1   29 23                 52
1367568 1367568 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_7 88 2 21 0   2     0   5   59 59 *                     118.0 88 2 21 0   2     0   5   59 59                 118
1367582 1367582 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_7 36 2 7 0   3     0   1   30 19 *                     49.0 36 2 7 0   3     0   1   30 19                 49
1367610 1367610 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_7 193 6 7 0   6     0   3   99 116 *                     215.0 193 6 7 0   6     0   3   99 116                 215
1367624 1367624 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_7 64 3 5 0   6     0   2   42 38 *                     80.0 64 3 5 0   6     0   2   42 38                 80
1367638 1367638 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_7 37 0 1 0   0     0   1   22 17 *                     39.0 37 0 1 0   0     0   1   22 17                 39
1367661 1367661 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_7 120 12 36 0   3     0   3   85 89 *                     174.0 120 12 36 0   3     0   3   85 89                 174
1367702 1367702 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_7 108 6 33 0   2     0   0   77 72 *                     149.0 108 6 33 0   2     0   0   77 72                 149
1367706 1367706 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_7 118 14 82 1   7     0   2   118 106 *                     224.0 118 14 82 1   7     0   2   118 106                 224
1367745 1367745 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2020   grade_7 268 5 9 0   12     0   13   152 155 *                     307.0 268 5 9 0   12     0   13   152 155                 307
1367760 1367760 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_7 45 20 13 0   7     0   9   40 53 *                     94.0 45 20 13 0   7     0   9   40 53                 94
1367783 1367783 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2020   grade_7 199 0 15 0   14     0   7   125 110 *                     235.0 199 0 15 0   14     0   7   125 110                 235
1367804 1367804 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_7 19 2 23 0   1     0   0   25 20 *                     45.0 19 2 23 0   1     0   0   25 20                 45
1367815 1367815 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_7 3 2 48 0   0     0   0   33 20 *                     53.0 3 2 48 0   0     0   0   33 20                 53
1367823 1367823 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2020   grade_7 2 0 47 0   0     0   0   26 23 *                     49.0 2 0 47 0   0     0   0   26 23                 49
1367840 1367840 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_7 11 1 49 0   2     0   0   33 30 *                     63.0 11 1 49 0   2     0   0   33 30                 63
1367850 1367850 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_7 6 0 42 0   0     0   0   21 27 *                     48.0 6 0 42 0   0     0   0   21 27                 48
1367859 1367859 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_7 9 6 79 0   2     0   2   52 46 *                     98.0 9 6 79 0   2     0   2   52 46                 98
1367873 1367873 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2020   grade_7 70 3 10 0   0     0   2   44 41 *                     85.0 70 3 10 0   0     0   2   44 41                 85
1367887 1367887 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2020   grade_7 216 1 15 0   73     0   11   157 159 *                     316.0 216 1 15 0   73     0   11   157 159                 316
1367913 1367913 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_7 159 6 25 0   2     0   11   105 98 *                     203.0 159 6 25 0   2     0   11   105 98                 203
1367927 1367927 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2020   grade_7 53 0 3 0   0     0   1   26 31 *                     57.0 53 0 3 0   0     0   1   26 31                 57
1367947 1367947 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_7 113 0 10 0   3     0   1   61 66 *                     127.0 113 0 10 0   3     0   1   61 66                 127
1367981 1367981 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_7 4 0 78 0   1     0   0   40 43 *                     83.0 4 0 78 0   1     0   0   40 43                 83
1367985 1367985 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_7 1 1 162 0   0     0   1   82 83 *                     165.0 1 1 162 0   0     0   1   82 83                 165
1368002 1368002 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_7 5 2 114 0   0     0   2   61 62 *                     123.0 5 2 114 0   0     0   2   61 62                 123
1368006 1368006 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_7 12 3 140 0   1     0   0   71 83 *                     156.0 12 3 140 0   1     0   0   71 83                 156
1368019 1368019 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 106 0   0     0   1   58 51 *                     109.0 2 0 106 0   0     0   1   58 51                 109
1368038 1368038 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_7 6 1 65 0   1     0   1   36 38 *                     74.0 6 1 65 0   1     0   1   36 38                 74
1368041 1368041 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_7 3 3 147 0   2     0   3   90 68 *                     158.0 3 3 147 0   2     0   3   90 68                 158
1368044 1368044 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 80 0   0     0   1   42 40 *                     83.0 2 0 80 0   0     0   1   42 40                 83
1368053 1368053 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_7 14 3 109 0   8     0   2   76 60 *                     136.0 14 3 109 0   8     0   2   76 60                 136
1368062 1368062 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_7 2 0 13 0   0     0   1   14 2 *                     16.0 2 0 13 0   0     0   1   14 2                 16
1368077 1368077 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_7 42 0 5 0   3     0   3   19 34 *                     53.0 42 0 5 0   3     0   3   19 34                 53
1368092 1368092 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_7 83 7 13 0   3     0   5   62 49 *                     111.0 83 7 13 0   3     0   5   62 49                 111
1368106 1368106 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_7 50 0 6 0   2     0   4   34 28 *                     62.0 50 0 6 0   2     0   4   34 28                 62
1368143 1368143 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_7 128 25 111 0   9     0   12   141 144 *                     285.0 128 25 111 0   9     0   12   141 144                 285
1368203 1368203 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2020   grade_7 140 10 16 0   127     0   11   145 159 *                     304.0 140 10 16 0   127     0   11   145 159                 304
1368206 1368206 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_7 133 8 10 0   140     0   30   154 167 *                     321.0 133 8 10 0   140     0   30   154 167                 321
1368225 1368225 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_7 29 7 3 0   3     0   6   25 23 *                     48.0 29 7 3 0   3     0   6   25 23                 48
1368230 1368230 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_7 26 6 7 0   1     0   4   19 25 *                     44.0 26 6 7 0   1     0   4   19 25                 44
1368240 1368240 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_7 103 1 7 0   7     0   4   63 59 *                     122.0 103 1 7 0   7     0   4   63 59                 122
1368269 1368269 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_7 94 1 3 0   7     0   7   57 55 *                     112.0 94 1 3 0   7     0   7   57 55                 112
1368289 1368289 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_7 18 19 50 0   24     0   4   57 58 *                     115.0 18 19 50 0   24     0   4   57 58                 115
1368311 1368311 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2020   grade_7 22 6 22 0   2     0   3   23 32 *                     55.0 22 6 22 0   2     0   3   23 32                 55
1368369 1368369 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_7 4 0 5 0   0     0   0   8 * *                     9.0 4 0 5 0   0     0   0   8                   9
1368379 1368379 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2020   grade_7 10 5 23 0   16     0   1   30 25 *                     55.0 10 5 23 0   16     0   1   30 25                 55
1368383 1368383 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2020   grade_7 37 11 47 0   41     0   8   71 73 *                     144.0 37 11 47 0   41     0   8   71 73                 144
1368387 1368387 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2020   grade_7 41 8 34 0   76     0   7   96 70 *                     166.0 41 8 34 0   76     0   7   96 70                 166
1368396 1368396 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2020   grade_7 32 15 84 0   23     0   4   80 78 *                     158.0 32 15 84 0   23     0   4   80 78                 158
1368400 1368400 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_7 55 11 70 0   26     0   13   80 95 *                     175.0 55 11 70 0   26     0   13   80 95                 175
1368404 1368404 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2020   grade_7 52 12 71 0   30     0   7   102 70 *                     172.0 52 12 71 0   30     0   7   102 70                 172
1368408 1368408 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2020   grade_7 17 11 48 0   81     0   10   82 85 *                     167.0 17 11 48 0   81     0   10   82 85                 167
1368435 1368435 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2020   grade_7 175 5 18 2   0     0   5   109 96 *                     205.0 175 5 18 2   0     0   5   109 96                 205
1368584 1368584 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_7 39 38 341 0   36     0   6   240 220 *                     460.0 39 38 341 0   36     0   6   240 220                 460
1368587 1368587 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_7 62 51 348 1   43     0   13   255 263 *                     518.0 62 51 348 1   43     0   13   255 263                 518
1368590 1368590 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_7 65 24 107 1   22     0   14   122 111 *                     233.0 65 24 107 1   22     0   14   122 111                 233
1368601 1368601 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_7 3 0 4 0   0     0   2   8 1 *                     9.0 3 0 4 0   0     0   2   8 1                 9
1368629 1368629 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2020   grade_7 135 2 8 0   14     0   2   88 73 *                     161.0 135 2 8 0   14     0   2   88 73                 161
1368642 1368642 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_7 25 13 18 0   39     0   3   55 43 *                     98.0 25 13 18 0   39     0   3   55 43                 98
1368651 1368651 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_7 29 24 43 0   17     0   9   61 61 *                     122.0 29 24 43 0   17     0   9   61 61                 122
1368660 1368660 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2020   grade_7 31 13 23 0   4     0   4   27 48 *                     75.0 31 13 23 0   4     0   4   27 48                 75
1368669 1368669 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_7 38 18 13 0   23     0   5   49 48 *                     97.0 38 18 13 0   23     0   5   49 48                 97

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