enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
1675640 1675640 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell - Henry J Robinson Middle   Regular School No Middle 05 08 2021   grade_7 46 18 75 0   22     0   4   83 82 *                     165.0 46 18 75 0   22     0   4   83 82                 165
1675644 1675644 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell - James Sullivan Middle School   Regular School No Middle 05 08 2021   grade_7 49 7 77 0   25     0   8   79 87 *                     166.0 49 7 77 0   25     0   8   79 87                 166
1675648 1675648 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell - Dr An Wang School   Regular School No Middle 05 08 2021   grade_7 50 15 69 0   20     0   14   86 82 *                     168.0 50 15 69 0   20     0   14   86 82                 168
1675652 1675652 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell - Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2021   grade_7 26 9 49 0   80     0   4   91 77 *                     168.0 26 9 49 0   80     0   4   91 77                 168
1675677 1675677 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_7 150 4 41 0   0     0   7   102 100 *                     202.0 150 4 41 0   0     0   7   102 100                 202
1675691 1675691 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_7 120 1 9 0   4     2   5   73 68 *                     141.0 120 1 9 0   4     2   5   73 68                 141
1675842 1675842 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_7 3 0 7 0   0     0   0   8 2 *                     10.0 3 0 7 0   0     0   0   8 2                 10
1675870 1675870 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield - Lynnfield Middle School   Regular School No Middle 05 08 2021   grade_7 131 4 8 0   16     0   3   87 75 *                     162.0 131 4 8 0   16     0   3   87 75                 162
1675883 1675883 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_7 28 19 18 0   33     0   2   45 55 *                     100.0 28 19 18 0   33     0   2   45 55                 100
1675892 1675892 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_7 19 14 39 0   20     0   4   47 48 *                     96.0 19 14 39 0   20     0   4   47 48                 96
1675901 1675901 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden - Forestdale   Regular School No Elementary KG 08 2021   grade_7 29 12 22 0   7     0   4   42 32 *                     74.0 29 12 22 0   7     0   4   42 32                 74
1675910 1675910 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_7 27 16 19 0   14     0   8   46 38 *                     84.0 27 16 19 0   14     0   8   46 38                 84
1675920 1675920 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden - Salemwood   Regular School No Elementary KG 08 2021   grade_7 28 23 44 0   17     0   4   66 50 *                     116.0 28 23 44 0   17     0   4   66 50                 116
1675935 1675935 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield - Harold L Qualters Middle   Regular School No Middle 06 08 2021   grade_7 225 12 23 0   17     0   6   150 133 *                     283.0 225 12 23 0   17     0   6   150 133                 283
1675954 1675954 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead - Marblehead Veterans Middle School   Regular School No Middle 07 08 2021   grade_7 171 3 17 0   5     0   7   99 104 *                     203.0 171 3 17 0   5     0   7   99 104                 203
1676035 1676035 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield - Furnace Brook Middle   Regular School No Middle 06 08 2021   grade_7 260 2 15 0   5     1   3   145 141 *                     286.0 260 2 15 0   5     1   3   145 141                 286
1676071 1676071 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_7 72 4 15 0   0     0   3   44 50 *                     94.0 72 4 15 0   0     0   3   44 50                 94
1676086 1676086 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield - Thomas Blake Middle   Regular School No Middle 06 08 2021   grade_7 160 0 14 0   3     0   9   96 90 *                     186.0 160 0 14 0   3     0   9   96 90                 186
1676141 1676141 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway - Medway Middle   Regular School No Middle 05 08 2021   grade_7 150 4 9 0   7     1   7   70 108 *                     178.0 150 4 9 0   7     1   7   70 108                 178
1676180 1676180 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose - Melrose Middle   Regular School No Middle 06 08 2021   grade_7 215 20 15 0   18     0   10   134 144 *                     278.0 215 20 15 0   18     0   10   134 144                 278
1676195 1676195 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_7 78 3 46 0   3     0   3   71 62 *                     133.0 78 3 46 0   3     0   3   71 62                 133
1676205 1676205 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_7 64 7 43 0   8     0   7   72 57 *                     129.0 64 7 43 0   8     0   7   72 57                 129
1676215 1676215 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_7 52 5 71 0   2     0   8   77 61 *                     138.0 52 5 71 0   2     0   8   77 61                 138
1676225 1676225 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_7 58 8 69 0   8     0   5   79 69 *                     148.0 58 8 69 0   8     0   5   79 69                 148
1676285 1676285 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury - Millbury Junior/Senior High   Regular School No High 07 12 2021   grade_7 93 1 14 0   3     0   9   55 65 *                     120.0 93 1 14 0   3     0   9   55 65                 120
1676299 1676299 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis - Millis Middle   Regular School No Middle 06 08 2021   grade_7 64 0 9 0   2     0   2   39 38 *                     77.0 64 0 9 0   2     0   2   39 38                 77
1676347 1676347 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson - Monson High School   Regular School No High 07 12 2021   grade_7 64 1 4 0   1     0   2   35 36 *                     72.0 64 1 4 0   1     0   2   35 36                 72
1676367 1676367 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Nantucket - Cyrus Peirce   Regular School No Middle 06 08 2021   grade_7 81 21 43 0   2     0   4   74 77 *                     151.0 81 21 43 0   2     0   4   74 77                 151
1676403 1676403 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_7 147 0 15 0   21     0   4   102 85 *                     187.0 147 0 15 0   21     0   4   102 85                 187
1676445 1676445 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Needham - Pollard Middle   Regular School No Middle 07 08 2021   grade_7 357 12 42 0   31     0   19   218 243 *                     461.0 357 12 42 0   31     0   19   218 243                 461
1676581 1676581 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford - Normandin Middle School   Regular School No Middle 06 08 2021   grade_7 179 33 148 0   5     0   12   195 182 *                     377.0 179 33 148 0   5     0   12   195 182                 377
1676584 1676584 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford - Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_7 95 41 132 0   0     1   15   147 137 *                     284.0 95 41 132 0   0     1   15   147 137                 284
1676592 1676592 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_7 6 4 2 0   0     0   0   10 2 *                     12.0 6 4 2 0   0     0   0   10 2                 12
1676612 1676612 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Newburyport - Rupert A Nock Middle   Regular School No Middle 06 08 2021   grade_7 156 3 0 0   4     0   2   85 80 *                     165.0 156 3 0 0   4     0   2   85 80                 165
1676711 1676711 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Newton - Bigelow Middle   Regular School No Middle 06 08 2021   grade_7 108 6 13 0   29     0   8   72 92 *                     164.0 108 6 13 0   29     0   8   72 92                 164
1676720 1676720 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_7 135 17 11 0   59     0   9   123 108 *                     231.0 135 17 11 0   59     0   9   123 108                 231
1676763 1676763 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams - Drury High   Regular School No High 07 12 2021   grade_7 68 8 7 0   0     1   7   45 46 *                     91.0 68 8 7 0   0     1   7   45 46                 91
1676796 1676796 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 142 9 33 0   4     0   18   102 103 *                     206.0 142 9 33 0   4     0   18   102 103                 206

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