enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2018 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
2230209 2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2231475 2231475 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231643 2231643 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2232021 2232021 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2233068 2233068 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_6 * * * *   *     *   *   4 *                       4.0                         4                   4
2233331 2233331 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2235828 2235828 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_6 * * * *   *     *   *   2 *                       2.0                         2                   2
2236188 2236188 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield: Balliet Middle School   Regular School No Middle 06 08 2018   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2237227 2237227 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2237290 2237290 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_6 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2239419 2239419 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pioneer Valley: Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230393 2230393 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_6 43 0 0 0   1     0   0   20 24                       44.0 43 0 0 0   1     0   0   20 24                 44
2230482 2230482 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_6 2 3 0 0   0     0   1   5 1                       6.0 2 3 0 0   0     0   1   5 1                 6
2231028 2231028 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_6 18 0 0 0   0     0   2   10 10                       20.0 18 0 0 0   0     0   2   10 10                 20
2231102 2231102 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_6 22 0 0 0   0     0   1   14 9                       23.0 22 0 0 0   0     0   1   14 9                 23
2231754 2231754 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_6 8 0 0 0   0     0   0   2 6                       8.0 8 0 0 0   0     0   0   2 6                 8
2232133 2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
2232334 2232334 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_6 34 2 0 0   0     0   0   17 19                       36.0 34 2 0 0   0     0   0   17 19                 36
2232520 2232520 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull: Memorial Middle   Regular School No Middle 06 08 2018   grade_6 60 1 0 0   0     0   0   31 30                       61.0 60 1 0 0   0     0   0   31 30                 61
2232570 2232570 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_6 31 0 0 0   0     0   1   13 19                       32.0 31 0 0 0   0     0   1   13 19                 32
2233935 2233935 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_6 18 0 0 0   1     0   0   10 9                       19.0 18 0 0 0   1     0   0   10 9                 19
2234390 2234390 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 North Adams: Colegrove Park Elementary   Regular School No Elementary PK 06 2018   grade_6 48 2 0 0   0     0   1   27 24                       51.0 48 2 0 0   0     0   1   27 24                 51
2234886 2234886 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke: Bryantville Elementary   Regular School No Elementary KG 06 2018   grade_6 70 1 0 0   1     1   0   36 37                       73.0 70 1 0 0   1     1   0   36 37                 73
2234894 2234894 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke: Hobomock Elementary   Regular School No Elementary KG 06 2018   grade_6 61 0 0 0   0     0   0   40 21                       61.0 61 0 0 0   0     0   0   40 21                 61
2234903 2234903 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 Pembroke: North Pembroke Elementary   Regular School No Elementary PK 06 2018   grade_6 81 1 0 0   1     0   1   48 36                       84.0 81 1 0 0   1     0   1   48 36                 84
2234919 2234919 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_6 18 0 0 0   0     0   1   13 6                       19.0 18 0 0 0   0     0   1   13 6                 19
2235090 2235090 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_6 30 0 0 1   1     0   0   16 16                       32.0 30 0 0 1   1     0   0   16 16                 32
2235441 2235441 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2235726 2235726 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury: Shutesbury Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 0 0   0     0   1   6 12                       18.0 17 0 0 0   0     0   1   6 12                 18
2237116 2237116 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford: Stony Brook School   Regular School No Middle 06 08 2018   grade_6 142 3 0 0   52     0   7   100 104                       204.0 142 3 0 0   52     0   7   100 104                 204
2237132 2237132 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   1   9 8                       17.0 16 0 0 0   0     0   1   9 8                 17
2237360 2237360 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_6 30 0 0 0   0     0   0   16 14                       30.0 30 0 0 0   0     0   0   16 14                 30
2238278 2238278 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_6 42 4 0 0   2     0   3   30 21                       51.0 42 4 0 0   2     0   3   30 21                 51
2238744 2238744 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_6 215 16 0 0   1     0   16   146 102                       248.0 215 16 0 0   1     0   16   146 102                 248
2238770 2238770 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   0   6 10                       16.0 16 0 0 0   0     0   0   6 10                 16
2238924 2238924 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_6 11 0 0 0   0     0   1   7 5                       12.0 11 0 0 0   0     0   1   7 5                 12
2239011 2239011 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague: Gill Elementary   Regular School No Elementary KG 06 2018   grade_6 9 0 0 0   0     0   2   6 5                       11.0 9 0 0 0   0     0   2   6 5                 11
2239239 2239239 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail: Sanderson Academy   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2239303 2239303 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba: Hale   Regular School No Middle 06 08 2018   grade_6 101 0 0 0   1     0   2   47 57                       104.0 101 0 0 0   1     0   2   47 57                 104
2239391 2239391 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Pentucket: Dr John C Page School   Regular School No Elementary PK 06 2018   grade_6 41 0 0 0   2     0   0   17 26                       43.0 41 0 0 0   2     0   0   17 26                 43
2239413 2239413 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_6 23 1 0 0   0     0   2   14 12                       26.0 23 1 0 0   0     0   2   14 12                 26
2239437 2239437 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Pioneer Valley: Warwick Community School   Regular School No Elementary PK 06 2018   grade_6 7 0 0 0   0     0   0   4 3                       7.0 7 0 0 0   0     0   0   4 3                 7
2239469 2239469 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_6 26 0 0 0   0     0   0   13 13                       26.0 26 0 0 0   0     0   0   13 13                 26
2239613 2239613 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton: Newbury Elementary   Regular School No Elementary PK 06 2018   grade_6 70 1 0 0   1     0   1   37 36                       73.0 70 1 0 0   1     0   1   37 36                 73
2239622 2239622 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton: Pine Grove   Regular School No Elementary PK 06 2018   grade_6 55 0 0 0   0     0   2   31 26                       57.0 55 0 0 0   0     0   2   31 26                 57
2239646 2239646 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_6 37 0 0 0   0     0   5   26 16                       42.0 37 0 0 0   0     0   5   26 16                 42
2230534 2230534 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2231431 2231431 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   2   11 8                       19.0 16 0 1 0   0     0   2   11 8                 19
2231914 2231914 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   grade_6 137 4 1 0   7     0   4   77 76                       153.0 137 4 1 0   7     0   4   77 76                 153
2232182 2232182 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_6 30 1 1 0   0     0   0   17 15                       32.0 30 1 1 0   0     0   0   17 15                 32
2233578 2233578 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Mattapoisett: Old Hammondtown   Regular School No Middle 04 06 2018   grade_6 66 2 1 0   1     0   4   36 38                       74.0 66 2 1 0   1     0   4   36 38                 74
2234408 2234408 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   grade_6 20 2 1 0   0     0   4   11 16                       27.0 20 2 1 0   0     0   4   11 16                 27
2234878 2234878 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_6 14 0 1 0   1     0   0   7 9                       16.0 14 0 1 0   1     0   0   7 9                 16
2235099 2235099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_6 5 3 1 0   0     0   1   6 4                       10.0 5 3 1 0   0     0   1   6 4                 10
2235386 2235386 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester: Rochester Memorial   Regular School No Elementary PK 06 2018   grade_6 59 1 1 0   0     0   5   35 31                       66.0 59 1 1 0   0     0   5   35 31                 66
2236387 2236387 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland: Sunderland Elementary   Regular School No Elementary PK 06 2018   grade_6 19 2 1 0   4     0   2   23 5                       28.0 19 2 1 0   4     0   2   23 5                 28
2236567 2236567 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Topsfield: Proctor Elementary   Regular School No Middle 04 06 2018   grade_6 72 1 1 0   2     0   0   34 42                       76.0 72 1 1 0   2     0   0   34 42                 76
2237351 2237351 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   1   6 12                       18.0 16 0 1 0   0     0   1   6 12                 18
2238288 2238288 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_6 18 1 1 0   0     0   0   9 11                       20.0 18 1 1 0   0     0   0   9 11                 20
2238375 2238375 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_6 26 1 1 0   2     0   2   9 23                       32.0 26 1 1 0   2     0   2   9 23                 32
2238569 2238569 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_6 18 1 1 0   47     0   1   36 32                       68.0 18 1 1 0   47     0   1   36 32                 68
2238996 2238996 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_6 188 2 1 1   8     1   4   103 102                       205.0 188 2 1 1   8     1   4   103 102                 205
2239107 2239107 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_6 14 0 1 0   0     0   2   6 11                       17.0 14 0 1 0   0     0   2   6 11                 17
2239221 2239221 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Mohawk Trail: Buckland-Shelburne Regional   Regular School No Elementary PK 06 2018   grade_6 18 0 1 0   1     0   0   12 8                       20.0 18 0 1 0   1     0   0   12 8                 20
2239428 2239428 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   grade_6 27 0 1 0   0     0   3   15 16                       31.0 27 0 1 0   0     0   3   15 16                 31
2239478 2239478 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin: Ruggles Lane   Regular School No Elementary PK 06 2018   grade_6 70 0 1 0   1     0   1   36 37                       73.0 70 0 1 0   1     0   1   36 37                 73
2239533 2239533 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   grade_6 42 0 1 0   0     0   2   17 28                       45.0 42 0 1 0   0     0   2   17 28                 45
2239566 2239566 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 1 0   0     0   0   12 6                       18.0 17 0 1 0   0     0   0   12 6                 18
2239741 2239741 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2228764 2228764 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_6 173 2 10 0   3     0   0   106 82                       188.0 173 2 10 0   3     0   0   106 82                 188
2228917 2228917 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_6 126 7 10 1   28     0   4   96 80                       176.0 126 7 10 1   28     0   4   96 80                 176
2229145 2229145 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_6 121 10 10 0   28     0   12   100 81                       181.0 121 10 10 0   28     0   12   100 81                 181
2230293 2230293 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_6 156 2 10 1   1     0   3   86 87                       173.0 156 2 10 1   1     0   3   86 87                 173
2230367 2230367 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_6 163 9 10 0   32     0   0   106 108                       214.0 163 9 10 0   32     0   0   106 108                 214
2231354 2231354 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_6 86 0 10 0   6     0   2   46 58                       104.0 86 0 10 0   6     0   2   46 58                 104
2232345 2232345 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston: Robert H. Adams Middle School   Regular School No Middle 06 08 2018   grade_6 194 3 10 1   14     0   3   112 113                       225.0 194 3 10 1   14     0   3   112 113                 225
2234359 2234359 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton: Oak Hill Middle   Regular School No Middle 06 08 2018   grade_6 112 8 10 1   44     1   11   104 83                       187.0 112 8 10 1   44     1   11   104 83                 187
2234588 2234588 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge: Northbridge Middle   Regular School No Middle 05 08 2018   grade_6 160 3 10 0   1     1   5   86 94                       180.0 160 3 10 0   1     1   5   86 94                 180
2234795 2234795 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_6 85 1 10 0   4     0   7   49 58                       107.0 85 1 10 0   4     0   7   49 58                 107
2235663 2235663 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon: Sharon Middle   Regular School No Middle 06 08 2018   grade_6 168 11 10 1   82     0   13   154 131                       285.0 168 11 10 1   82     0   13   154 131                 285
2235781 2235781 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 Somerville: John F Kennedy   Regular School No Elementary KG 08 2018   grade_6 55 4 10 0   4     0   2   47 28                       75.0 55 4 10 0   4     0   2   47 28                 75
2237576 2237576 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_6 8 2 10 0   3     0   0   13 10                       23.0 8 2 10 0   3     0   0   13 10                 23
2237806 2237806 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_6 15 12 10 0   3     0   1   15 26                       41.0 15 12 10 0   3     0   1   15 26                 41
2237866 2237866 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_6 27 3 10 0   6     0   2   22 26                       48.0 27 3 10 0   6     0   2   22 26                 48
2237991 2237991 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District): Bridge Boston Charter School   Regular School Yes Elementary PK 06 2018   grade_6 0 23 10 0   1     0   1   18 17                       35.0 0 23 10 0   1     0   1   18 17                 35
2238178 2238178 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_6 47 61 10 0   13     0   5   67 69                       136.0 47 61 10 0   13     0   5   67 69                 136
2239998 2239998 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_6 2 94 10 1   0     0   0   52 55                       107.0 2 94 10 1   0     0   0   52 55                 107
2232686 2232686 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_6 13 3 100 0   7     0   0   61 62                       123.0 13 3 100 0   7     0   0   61 62                 123
2238389 2238389 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_6 4 135 100 0   5     1   3   136 112                       248.0 4 135 100 0   5     1   3   136 112                 248
2232646 2232646 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_6 7 1 103 0   0     0   0   58 53                       111.0 7 1 103 0   0     0   0   58 53                 111
2231008 2231008 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_6 131 7 104 0   2     0   9   128 125                       253.0 131 7 104 0   2     0   9   128 125                 253
2231004 2231004 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_6 134 6 106 0   6     0   11   127 136                       263.0 134 6 106 0   6     0   11   127 136                 263
2233309 2233309 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_6 68 10 106 1   18     0   14   117 100                       217.0 68 10 106 1   18     0   14   117 100                 217
2236759 2236759 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_6 87 19 107 0   10     0   4   105 122                       227.0 87 19 107 0   10     0   4   105 122                 227
2234199 2234199 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_6 112 50 109 1   1     1   12   145 141                       286.0 112 50 109 1   1     1   12   145 141                 286
2229350 2229350 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica: Locke Middle   Regular School No Middle 06 08 2018   grade_6 128 6 11 0   11     2   4   87 75                       162.0 128 6 11 0   11     2   4   87 75                 162
2229543 2229543 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_6 24 7 11 0   5     0   1   22 26                       48.0 24 7 11 0   5     0   1   22 26                 48
2230035 2230035 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_6 1 6 11 0   0     0   1   9 10                       19.0 1 6 11 0   0     0   1   9 10                 19
2230055 2230055 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_6 10 33 11 0   5     0   3   32 30                       62.0 10 33 11 0   5     0   3   32 30                 62
2230598 2230598 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_6 28 7 11 0   11     0   3   28 32                       60.0 28 7 11 0   11     0   3   28 32                 60

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