enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_7 · 500 ✖
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
1366219 1366219 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1366632 1366632 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_7 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1367687 1367687 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_7 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368425 1368425 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_7 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1368464 1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1368609 1368609 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_7 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1370706 1370706 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_7 * * * *   *     *   *   4 * *                     4.0                         4                   4
1371954 1371954 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_7 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1373189 1373189 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_7 * * * *   *     *   *   1 * *                     1.0                         1                   1
1374314 1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1366689 1366689 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_7 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1366714 1366714 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_7 108 3 0 0   1     0   4   70 46 *                     116.0 108 3 0 0   1     0   4   70 46                 116
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
1372692 1372692 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 2020   grade_7 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
1372848 1372848 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_7 26 0 0 0   2     0   4   9 23 *                     32.0 26 0 0 0   2     0   4   9 23                 32
1373513 1373513 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_7 124 0 0 0   2     0   2   60 68 *                     128.0 124 0 0 0   2     0   2   60 68                 128
1374000 1374000 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_7 42 0 0 0   3     0   1   24 22 *                     46.0 42 0 0 0   3     0   1   24 22                 46
1366519 1366519 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_7 49 0 1 0   6     0   8   36 28 *                     64.0 49 0 1 0   6     0   8   36 28                 64
1366931 1366931 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_7 151 9 1 1   0     1   6   100 69 *                     169.0 151 9 1 1   0     1   6   100 69                 169
1367469 1367469 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_7 84 0 1 0   2     1   0   41 47 *                     88.0 84 0 1 0   2     1   0   41 47                 88
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
1369100 1369100 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_7 56 0 1 0   2     0   1   30 30 *                     60.0 56 0 1 0   2     0   1   30 30                 60
1370375 1370375 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2020   grade_7 62 0 1 0   2     0   0   24 41 *                     65.0 62 0 1 0   2     0   0   24 41                 65
1372476 1372476 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2020   grade_7 35 0 1 0   0     0   2   16 22 *                     38.0 35 0 1 0   0     0   2   16 22                 38
1372607 1372607 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_7 0 18 1 0   0     0   0   9 10 *                     19.0 0 18 1 0   0     0   0   9 10                 19
1373144 1373144 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_7 69 5 1 0   3     0   3   34 47 *                     81.0 69 5 1 0   3     0   3   34 47                 81
1373185 1373185 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_7 159 13 1 0   4     0   8   115 70 *                     185.0 159 13 1 0   4     0   8   115 70                 185
1373618 1373618 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional School   Regular School No High 07 12 2020   grade_7 72 1 1 0   0     0   0   36 38 *                     74.0 72 1 1 0   0     0   0   36 38                 74
1373708 1373708 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_7 125 2 1 0   4     0   3   75 60 *                     135.0 125 2 1 0   4     0   3   75 60                 135
1373783 1373783 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2020   grade_7 56 1 1 0   0     0   3   29 32 *                     61.0 56 1 1 0   0     0   3   29 32                 61
1373955 1373955 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_7 38 0 1 0   0     0   1   24 16 *                     40.0 38 0 1 0   0     0   1   24 16                 40
1369676 1369676 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2020   grade_7 35 0 2 0   0     0   1   22 16 *                     38.0 35 0 2 0   0     0   1   22 16                 38
1369743 1369743 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2020   grade_7 174 0 2 0   5     0   3   107 77 *                     184.0 174 0 2 0   5     0   3   107 77                 184
1370098 1370098 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_7 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1370332 1370332 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_7 16 1 2 0   0     0   0   9 10 *                     19.0 16 1 2 0   0     0   0   9 10                 19
1372709 1372709 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_7 28 0 2 0   0     0   2   12 19 *                     32.0 28 0 2 0   0     0   2   12 19                 32
1372769 1372769 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_7 14 1 2 0   0     0   2   11 8 *                     19.0 14 1 2 0   0     0   2   11 8                 19
1373038 1373038 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_7 84 5 2 0   1     0   2   48 46 *                     94.0 84 5 2 0   1     0   2   48 46                 94
1373991 1373991 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2020   grade_7 54 3 2 0   4     0   1   36 28 *                     64.0 54 3 2 0   4     0   1   36 28                 64
1366477 1366477 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2020   grade_7 44 27 3 0   18     0   8   51 48 *                     100.0 44 27 3 0   18     0   8   51 48                 100
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
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
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
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
1370258 1370258 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_7 119 2 3 0   1     0   3   71 57 *                     128.0 119 2 3 0   1     0   3   71 57                 128
1370447 1370447 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_7 205 4 3 1   3     0   3   109 110 *                     219.0 205 4 3 1   3     0   3   109 110                 219
1371200 1371200 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_7 111 1 3 0   1     0   6   59 63 *                     122.0 111 1 3 0   1     0   6   59 63                 122
1372578 1372578 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_7 71 1 3 1   3     0   2   36 45 *                     81.0 71 1 3 1   3     0   2   36 45                 81
1372818 1372818 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 2020   grade_7 64 3 3 0   2     0   3   35 40 *                     75.0 64 3 3 0   2     0   3   35 40                 75
1372902 1372902 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_7 27 38 3 0   4     0   6   44 34 *                     78.0 27 38 3 0   4     0   6   44 34                 78
1372963 1372963 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_7 30 9 3 0   9     0   8   35 24 *                     59.0 30 9 3 0   9     0   8   35 24                 59
1373372 1373372 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2020   grade_7 57 0 3 1   0     0   1   37 25 *                     62.0 57 0 3 1   0     0   1   37 25                 62
1373587 1373587 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_7 81 3 3 0   0     0   4   50 41 *                     91.0 81 3 3 0   0     0   4   50 41                 91
1373859 1373859 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_7 45 1 3 1   0     0   4   27 27 *                     54.0 45 1 3 1   0     0   4   27 27                 54
1374036 1374036 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2020   grade_7 73 1 3 0   0     0   4   41 40 *                     81.0 73 1 3 0   0     0   4   41 40                 81
1365191 1365191 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_7 91 0 4 0   0     0   2   48 49 *                     97.0 91 0 4 0   0     0   2   48 49                 97
1366311 1366311 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_7 37 4 4 0   22     0   5   42 30 *                     72.0 37 4 4 0   22     0   5   42 30                 72
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
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
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
1369344 1369344 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_7 3 2 4 0   0     0   0   6 3 *                     9.0 3 2 4 0   0     0   0   6 3                 9
1371245 1371245 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_7 179 1 4 0   0     0   2   102 84 *                     186.0 179 1 4 0   0     0   2   102 84                 186
1372679 1372679 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 33 86 4 0   15     0   10   69 79 *                     148.0 33 86 4 0   15     0   10   69 79                 148
1372778 1372778 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_7 12 1 4 0   0     0   2   11 8 *                     19.0 12 1 4 0   0     0   2   11 8                 19
1373277 1373277 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_7 127 1 4 0   0     0   7   72 67 *                     139.0 127 1 4 0   0     0   7   72 67                 139
1373344 1373344 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_7 228 6 4 1   4     0   6   113 136 *                     249.0 228 6 4 1   4     0   6   113 136                 249
1373441 1373441 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2020   grade_7 126 1 4 0   3     0   5   69 70 *                     139.0 126 1 4 0   3     0   5   69 70                 139
1373455 1373455 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_7 10 1 4 0   0     0   0   5 10 *                     15.0 10 1 4 0   0     0   0   5 10                 15
1373524 1373524 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2020   grade_7 254 2 4 0   5     0   0   137 128 *                     265.0 254 2 4 0   5     0   0   137 128                 265
1373873 1373873 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_7 112 1 4 0   1     0   2   57 63 *                     120.0 112 1 4 0   1     0   2   57 63                 120
1374253 1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1365124 1365124 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2020   grade_7 162 7 5 0   4     1   5   101 83 *                     184.0 162 7 5 0   4     1   5   101 83                 184
1365652 1365652 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_7 6 5 5 0   2     0   2   9 11 *                     20.0 6 5 5 0   2     0   2   9 11                 20
1366048 1366048 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_7 0 3 5 0   0     0   0   6 2 *                     8.0 0 3 5 0   0     0   0   6 2                 8
1366529 1366529 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_7 116 0 5 1   0     1   0   69 54 *                     123.0 116 0 5 1   0     1   0   69 54                 123
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
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
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
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
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1369051 1369051 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 06 08 2020   grade_7 78 0 5 0   0     0   7   45 45 *                     90.0 78 0 5 0   0     0   7   45 45                 90
1369931 1369931 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2020   grade_7 222 0 5 0   2     0   2   123 108 *                     231.0 222 0 5 0   2     0   2   123 108                 231
1370518 1370518 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_7 210 8 5 0   1     0   2   116 110 *                     226.0 210 8 5 0   1     0   2   116 110                 226
1371714 1371714 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_7 91 6 5 0   1     0   4   47 60 *                     107.0 91 6 5 0   1     0   4   47 60                 107
1371785 1371785 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_7 107 6 5 2   54     0   10   100 84 *                     184.0 107 6 5 2   54     0   10   100 84                 184
1371829 1371829 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_7 108 1 5 0   1     0   8   77 46 *                     123.0 108 1 5 0   1     0   8   77 46                 123
1373286 1373286 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2020   grade_7 124 8 5 0   20     0   6   93 70 *                     163.0 124 8 5 0   20     0   6   93 70                 163
1373392 1373392 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_7 159 5 5 0   10     0   5   88 96 *                     184.0 159 5 5 0   10     0   5   88 96                 184
1373724 1373724 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2020   grade_7 186 6 5 0   4     0   13   118 96 *                     214.0 186 6 5 0   4     0   13   118 96                 214
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1365143 1365143 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_7 149 1 6 0   9     0   0   78 87 *                     165.0 149 1 6 0   9     0   0   78 87                 165
1366329 1366329 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_7 52 3 6 0   12     0   6   38 41 *                     79.0 52 3 6 0   12     0   6   38 41                 79
1366339 1366339 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_7 48 3 6 0   7     0   9   33 40 *                     73.0 48 3 6 0   7     0   9   33 40                 73
1366474 1366474 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 37 34 6 0   8     0   10   48 47 *                     95.0 37 34 6 0   8     0   10   48 47                 95
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
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
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
1369363 1369363 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2020   grade_7 154 3 6 0   2     0   7   89 83 *                     172.0 154 3 6 0   2     0   7   89 83                 172
1369702 1369702 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2020   grade_7 168 0 6 0   6     0   3   98 85 *                     183.0 168 0 6 0   6     0   3   98 85                 183
1371020 1371020 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2020   grade_7 0 4 6 0   0     0   0   9 1 *                     10.0 0 4 6 0   0     0   0   9 1                 10

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