enrollments

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 396 ✖

grade ✖

  • grade_7 · 396 ✖
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
1673900 1673900 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee - Dupont Middle   Regular School No Middle 06 08 2021   grade_7 125 15 124 0   4     0   7   145 130 *                     275.0 125 15 124 0   4     0   7   145 130                 275
1673917 1673917 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_7 30 0 0 0   0     0   0   13 17 *                     30.0 30 0 0 0   0     0   0   13 17                 30
1673927 1673927 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_7 112 6 40 0   2     0   5   94 71 *                     165.0 112 6 40 0   2     0   5   94 71                 165
1673942 1673942 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_7 124 4 1 0   1     0   0   64 66 *                     130.0 124 4 1 0   1     0   0   64 66                 130
1673970 1673970 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_7 165 18 19 0   16     0   12   119 111 *                     230.0 165 18 19 0   16     0   12   119 111                 230
1674013 1674013 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers - Holten Richmond Middle School   Regular School No Middle 06 08 2021   grade_7 218 3 23 0   7     0   7   144 114 *                     258.0 218 3 23 0   7     0   7   144 114                 258
1674041 1674041 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth - Dartmouth Middle   Regular School No Middle 06 08 2021   grade_7 247 3 17 0   1     0   12   125 155 *                     280.0 247 3 17 0   1     0   12   125 155                 280
1674070 1674070 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham - Dedham Middle School   Regular School No Middle 06 08 2021   grade_7 158 12 28 0   2     0   9   116 93 *                     209.0 158 12 28 0   2     0   9   116 93                 209
1674093 1674093 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_7 78 0 3 0   1     0   4   44 42 *                     86.0 78 0 3 0   1     0   4   44 42                 86
1674132 1674132 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Dracut - Justus C. Richardson Middle School   Regular School No Middle 06 08 2021   grade_7 219 24 33 0   21     0   6   143 160 *                     303.0 219 24 33 0   21     0   6   143 160                 303
1674147 1674147 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury - Duxbury Middle   Regular School No Middle 06 08 2021   grade_7 208 1 8 0   3     0   7   123 104 *                     227.0 208 1 8 0   3     0   7   123 104                 227
1674161 1674161 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_7 154 9 6 1   1     0   7   103 75 *                     178.0 154 9 6 1   1     0   7   103 75                 178
1674192 1674192 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_7 68 1 15 0   7     0   1   59 32 *                     92.0 68 1 15 0   7     0   1   59 32                 92
1674210 1674210 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow - Birchland Park   Regular School No Middle 06 08 2021   grade_7 159 7 8 0   19     0   11   100 104 *                     204.0 159 7 8 0   19     0   11   100 104                 204
1674231 1674231 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton - Easton Middle School   Regular School No Middle 06 08 2021   grade_7 221 13 15 0   11     0   8   134 134 *                     268.0 221 13 15 0   11     0   8   134 134                 268
1674246 1674246 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_7 22 3 7 1   0     0   2   14 21 *                     35.0 22 3 7 1   0     0   2   14 21                 35
1674265 1674265 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_7 6 10 51 0   4     0   1   32 40 *                     72.0 6 10 51 0   4     0   1   32 40                 72
1674280 1674280 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_7 28 6 45 0   6     0   3   46 42 *                     88.0 28 6 45 0   6     0   3   46 42                 88
1674289 1674289 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_7 19 5 94 0   2     0   1   69 52 *                     121.0 19 5 94 0   2     0   1   69 52                 121
1674295 1674295 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_7 4 2 3 0   0     0   1   9 1 *                     10.0 4 2 3 0   0     0   1   9 1                 10
1674308 1674308 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_7 30 19 68 0   13     0   1   64 67 *                     131.0 30 19 68 0   13     0   1   64 67                 131
1674317 1674317 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_7 11 14 77 0   3     0   1   53 53 *                     106.0 11 14 77 0   3     0   1   53 53                 106
1674338 1674338 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_7 121 6 12 1   4     0   6   76 74 *                     150.0 121 6 12 1   4     0   6   76 74                 150
1674380 1674380 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_7 38 6 25 0   3     0   15   52 35 *                     87.0 38 6 25 0   3     0   15   52 35                 87
1674390 1674390 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_7 24 3 17 0   1     0   3   25 23 *                     48.0 24 3 17 0   1     0   3   25 23                 48
1674419 1674419 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_7 84 15 70 1   5     0   23   105 93 *                     198.0 84 15 70 1   5     0   23   105 93                 198
1674422 1674422 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_7 127 22 59 1   10     0   16   132 103 *                     235.0 127 22 59 1   10     0   16   132 103                 235
1674425 1674425 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_7 144 13 52 0   12     0   24   116 129 *                     245.0 144 13 52 0   12     0   24   116 129                 245
1674431 1674431 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_7 7 1 0 0   0     0   0   7 1 *                     8.0 7 1 0 0   0     0   0   7 1                 8
1674441 1674441 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_7 4 0 3 0   0     0   0   4 3 *                     7.0 4 0 3 0   0     0   0   4 3                 7
1674471 1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
1674492 1674492 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_7 50 10 84 0   6     1   11   70 92 *                     162.0 50 10 84 0   6     1   11   70 92                 162
1674502 1674502 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_7 42 14 89 0   5     0   15   82 83 *                     165.0 42 14 89 0   5     0   15   82 83                 165
1674512 1674512 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   grade_7 9 6 41 0   1     0   4   27 34 *                     61.0 9 6 41 0   1     0   4   27 34                 61
1674531 1674531 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_7 18 0 0 0   0     0   0   11 7 *                     18.0 18 0 0 0   0     0   0   11 7                 18
1674551 1674551 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_7 172 13 16 1   8     0   5   115 100 *                     215.0 172 13 16 1   8     0   5   115 100                 215
1674614 1674614 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham - Cameron Middle School   Regular School No Middle 06 08 2021   grade_7 136 13 42 0   2     0   10   107 96 *                     203.0 136 13 42 0   2     0   10   107 96                 203
1674617 1674617 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_7 58 15 101 1   4     0   8   111 76 *                     187.0 58 15 101 1   4     0   8   111 76                 187
1674620 1674620 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_7 148 9 86 0   16     0   7   127 139 *                     266.0 148 9 86 0   16     0   7   127 139                 266
1674664 1674664 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_7 109 6 9 0   6     0   1   66 65 *                     131.0 109 6 9 0   6     0   1   66 65                 131
1674667 1674667 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_7 104 4 5 1   6     0   1   64 57 *                     121.0 104 4 5 1   6     0   1   64 57                 121
1674670 1674670 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_7 111 2 4 0   8     2   4   70 61 *                     131.0 111 2 4 0   8     2   4   70 61                 131
1674685 1674685 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_7 117 4 38 0   4     0   13   96 80 *                     176.0 117 4 38 0   4     0   13   96 80                 176
1674704 1674704 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown - Georgetown Middle School   Regular School No Middle 07 08 2021   grade_7 111 2 1 0   0     1   1   59 57 *                     116.0 111 2 1 0   0     1   1   59 57                 116
1674742 1674742 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester - Ralph B O'Maley Middle   Regular School No Middle 06 08 2021   grade_7 166 2 23 1   3     0   6   104 97 *                     201.0 166 2 23 1   3     0   6   104 97                 201
1674757 1674757 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_7 * * * *   *     *   *   * * *                     2.0                                             2
1674780 1674780 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton - Grafton Middle   Regular School No Middle 07 08 2021   grade_7 186 6 20 1   28     0   5   138 108 *                     246.0 186 6 20 1   28     0   5   138 108                 246
1674794 1674794 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby - Granby Jr Sr High School   Regular School No High 07 12 2021   grade_7 42 0 6 0   1     0   2   30 20 *                     51.0 42 0 6 0   1     0   2   30 20                 51
1674818 1674818 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_7 85 5 19 0   1     0   9   61 58 *                     119.0 85 5 19 0   1     0   9   61 58                 119
1674832 1674832 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_7 32 1 5 0   3     1   2   20 24 *                     44.0 32 1 5 0   3     1   2   20 24                 44
1674861 1674861 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_7 170 1 8 0   4     0   0   103 80 *                     183.0 170 1 8 0   4     0   0   103 80                 183
1674876 1674876 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_7 71 1 3 0   4     0   7   36 49 *                     86.0 71 1 3 0   4     0   7   36 49                 86
1674890 1674890 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_7 31 1 1 0   0     0   0   17 16 *                     33.0 31 1 1 0   0     0   0   17 16                 33
1674913 1674913 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_7 112 9 46 1   3     0   1   88 84 *                     172.0 112 9 46 1   3     0   1   88 84                 172
1674915 1674915 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1674923 1674923 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_7 53 11 75 0   2     0   2   81 62 *                     143.0 53 11 75 0   2     0   2   81 62                 143
1674947 1674947 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_7 60 8 66 0   2     1   3   60 80 *                     140.0 60 8 66 0   2     1   3   60 80                 140
1674951 1674951 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_7 81 10 115 0   6     0   4   120 96 *                     216.0 81 10 115 0   6     0   4   120 96                 216
1674990 1674990 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_7 297 5 12 0   15     0   7   183 153 *                     336.0 297 5 12 0   15     0   7   183 153                 336
1675005 1675005 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_7 51 18 17 1   5     0   9   54 47 *                     101.0 51 18 17 1   5     0   9   54 47                 101
1675028 1675028 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston - Robert H. Adams Middle School   Regular School No Middle 06 08 2021   grade_7 182 3 16 0   14     1   6   109 113 *                     222.0 182 3 16 0   14     1   6   109 113                 222
1675050 1675050 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_7 14 0 26 0   1     0   2   25 18 *                     43.0 14 0 26 0   1     0   2   25 18                 43
1675061 1675061 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_7 4 1 49 0   0     0   1   34 21 *                     55.0 4 1 49 0   0     0   1   34 21                 55
1675085 1675085 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_7 3 0 56 0   0     0   1   35 25 *                     60.0 3 0 56 0   0     0   1   35 25                 60
1675094 1675094 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke - Maurice A Donahue Elementary   Regular School No Elementary PK 08 2021   grade_7 3 3 36 0   0     0   0   21 21 *                     42.0 3 3 36 0   0     0   0   21 21                 42
1675102 1675102 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_7 3 6 108 0   1     0   1   64 55 *                     119.0 3 6 108 0   1     0   1   64 55                 119
1675104 1675104 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke - Holyoke STEM Academy   Regular School No Middle 06 08 2021   grade_7 6 2 47 0   0     0   1   30 26 *                     56.0 6 2 47 0   0     0   1   30 26                 56
1675118 1675118 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale - Hopedale Jr Sr High   Regular School No High 07 12 2021   grade_7 73 1 11 0   1     1   3   47 43 *                     90.0 73 1 11 0   1     1   3   47 43                 90
1675132 1675132 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton - Hopkinton Middle School   Regular School No Middle 06 08 2021   grade_7 194 3 15 1   67     0   17   149 148 *                     297.0 194 3 15 1   67     0   17   149 148                 297
1675158 1675158 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson - David J. Quinn Middle School   Regular School No Middle 05 07 2021   grade_7 161 2 29 0   3     0   5   98 102 *                     200.0 161 2 29 0   3     0   5   98 102                 200
1675172 1675172 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull - Memorial Middle   Regular School No Middle 06 08 2021   grade_7 58 1 1 0   0     0   2   37 25 *                     62.0 58 1 1 0   0     0   2   37 25                 62
1675192 1675192 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_7 104 3 9 0   1     0   5   63 59 *                     122.0 104 3 9 0   1     0   5   63 59                 122
1675226 1675226 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_7 3 1 90 0   2     0   0   47 49 *                     96.0 3 1 90 0   2     0   0   47 49                 96
1675230 1675230 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_7 4 1 139 1   0     0   0   72 73 *                     145.0 4 1 139 1   0     0   0   72 73                 145
1675247 1675247 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_7 1 3 130 0   1     0   0   82 53 *                     135.0 1 3 130 0   1     0   0   82 53                 135
1675251 1675251 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_7 5 0 160 0   1     0   1   82 85 *                     167.0 5 0 160 0   1     0   1   82 85                 167
1675264 1675264 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_7 0 0 100 0   0     0   0   49 50 *                     100.0 0 0 100 0   0     0   0   49 50                 100
1675283 1675283 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_7 4 1 69 0   0     0   0   34 40 *                     74.0 4 1 69 0   0     0   0   34 40                 74
1675286 1675286 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence - Spark Academy   Regular School No Middle 06 08 2021   grade_7 8 0 153 0   2     0   1   85 79 *                     164.0 8 0 153 0   2     0   1   85 79                 164
1675289 1675289 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence - UP Academy Leonard Middle School   Regular School No Middle 06 08 2021   grade_7 4 0 105 0   0     0   0   51 58 *                     109.0 4 0 105 0   0     0   0   51 58                 109
1675298 1675298 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_7 9 3 113 0   3     0   6   74 60 *                     134.0 9 3 113 0   3     0   6   74 60                 134
1675306 1675306 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_7 0 0 11 0   0     0   0   10 1 *                     11.0 0 0 11 0   0     0   0   10 1                 11
1675323 1675323 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee - Lee Middle/High School   Regular School No High 07 12 2021   grade_7 32 0 5 0   2     0   1   20 19 *                     40.0 32 0 5 0   2     0   1   20 19                 40
1675338 1675338 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester - Leicester Middle   Regular School No Middle 05 08 2021   grade_7 100 7 17 0   2     0   2   75 53 *                     128.0 100 7 17 0   2     0   2   75 53                 128
1675352 1675352 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox - Lenox Memorial High   Regular School No High 06 12 2021   grade_7 50 0 5 0   3     0   4   32 30 *                     62.0 50 0 5 0   3     0   4   32 30                 62
1675386 1675386 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Leominster - Samoset School   Regular School No Middle 06 08 2021   grade_7 78 11 69 0   8     0   4   85 84 *                     170.0 78 11 69 0   8     0   4   85 84                 170
1675389 1675389 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster - Sky View Middle School   Regular School No Middle 06 08 2021   grade_7 136 34 97 1   14     0   12   151 143 *                     294.0 136 34 97 1   14     0   12   151 143                 294
1675448 1675448 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_7 139 15 10 1   127     1   9   172 130 *                     302.0 139 15 10 1   127     1   9   172 130                 302
1675451 1675451 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_7 113 13 9 0   140     0   24   144 155 *                     299.0 113 13 9 0   140     0   24   144 155                 299
1675470 1675470 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   grade_7 42 5 5 0   5     0   3   26 34 *                     60.0 42 5 5 0   5     0   3   26 34                 60
1675475 1675475 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_7 33 3 13 0   0     0   3   28 24 *                     52.0 33 3 13 0   0     0   3   28 24                 52
1675485 1675485 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton - Littleton Middle School   Regular School No Middle 06 08 2021   grade_7 100 4 3 0   19     0   3   64 65 *                     129.0 100 4 3 0   19     0   3   64 65                 129
1675504 1675504 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_7 80 5 7 0   15     0   2   62 47 *                     109.0 80 5 7 0   15     0   2   62 47                 109
1675514 1675514 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_7 94 0 7 0   17     2   9   55 74 *                     129.0 94 0 7 0   17     2   9   55 74                 129
1675534 1675534 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_7 23 11 45 0   27     0   3   62 47 *                     109.0 23 11 45 0   27     0   3   62 47                 109
1675556 1675556 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell - Pyne Arts   Regular School No Elementary PK 08 2021   grade_7 19 2 28 0   8     0   2   37 22 *                     59.0 19 2 28 0   8     0   2   37 22                 59
1675614 1675614 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_7 1 0 5 0   0     0   1   7 * *                     7.0 1 0 5 0   0     0   1   7                   7
1675624 1675624 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell - Bartlett Community Partnership   Regular School No Elementary PK 08 2021   grade_7 9 0 25 0   18     0   5   24 33 *                     57.0 9 0 25 0   18     0   5   24 33                 57
1675628 1675628 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell - B.F. Butler Middle School   Regular School No Middle 05 08 2021   grade_7 26 7 49 0   45     0   13   71 69 *                     140.0 26 7 49 0   45     0   13   71 69                 140
1675632 1675632 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_7 44 8 25 0   82     0   10   92 77 *                     169.0 44 8 25 0   82     0   10   92 77                 169

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