enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2229686 2229686 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_6 8 0 20 0   0     0   2   15 15                       30.0 8 0 20 0   0     0   2   15 15                 30
2230310 2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
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
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
2230685 2230685 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_6 13 0 20 0   1     0   2   11 25                       36.0 13 0 20 0   1     0   2   11 25                 36
2230829 2230829 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_6 51 0 3 0   5     0   11   39 31                       70.0 51 0 3 0   5     0   11   39 31                 70
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
2231225 2231225 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield: Deerfield Elementary   Regular School No Elementary PK 06 2018   grade_6 47 0 3 0   1     0   5   31 25                       56.0 47 0 3 0   1     0   5   31 25                 56
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
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
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
2232059 2232059 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby: East Meadow   Regular School No Middle 04 06 2018   grade_6 52 0 3 0   1     0   1   28 29                       57.0 52 0 3 0   1     0   1   28 29                 57
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
2232167 2232167 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_6 64 0 5 0   11     0   1   47 34                       81.0 64 0 5 0   11     0   1   47 34                 81
2232367 2232367 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_6 18 0 36 0   0     0   0   29 25                       54.0 18 0 36 0   0     0   0   29 25                 54
2232503 2232503 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson: David J. Quinn Middle School   Regular School No Middle 05 07 2018   grade_6 178 0 23 0   7     0   2   97 113                       210.0 178 0 23 0   7     0   2   97 113                 210
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
2232629 2232629 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_6 7 0 115 0   0     0   2   55 69                       124.0 7 0 115 0   0     0   2   55 69                 124
2232699 2232699 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_6 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2232754 2232754 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_6 52 0 6 0   4     0   1   37 26                       63.0 52 0 6 0   4     0   1   37 26                 63
2232826 2232826 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_6 12 0 2 0   0     0   3   10 7                       17.0 12 0 2 0   0     0   3   10 7                 17
2233543 2233543 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield: Furnace Brook Middle   Regular School No Middle 06 08 2018   grade_6 260 0 7 0   3     0   6   138 138                       276.0 260 0 7 0   3     0   6   138 138                 276
2233738 2233738 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_6 80 0 43 0   6     0   7   68 68                       136.0 80 0 43 0   6     0   7   68 68                 136
2233760 2233760 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen: Tenney Grammar School   Regular School No Elementary PK 08 2018   grade_6 59 0 78 0   4     0   10   84 67                       151.0 59 0 78 0   4     0   10   84 67                 151
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
2234604 2234604 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield: North Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 51 0 2 0   0     0   2   28 27                       55.0 51 0 2 0   0     0   2   28 27                 55
2234749 2234749 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange: Dexter Park   Regular School No Elementary 03 06 2018   grade_6 66 0 5 0   1     0   1   44 29                       73.0 66 0 5 0   1     0   1   44 29                 73
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
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
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
2235375 2235375 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_6 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2235425 2235425 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport: Rockport Middle   Regular School No Middle 06 08 2018   grade_6 71 0 2 0   0     0   0   43 30                       73.0 71 0 2 0   0     0   0   43 30                 73
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
2235482 2235482 MA Essex   school 2510380 258   Salem 251038000773 2580050 Salem: Saltonstall School   Regular School No Elementary KG 08 2018   grade_6 18 0 13 0   2     0   4   19 18                       37.0 18 0 13 0   2     0   4   19 18                 37
2235520 2235520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_6 216 0 4 0   2     0   1   102 121                       223.0 216 0 4 0   2     0   1   102 121                 223
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
2235849 2235849 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 Southampton: William E Norris   Regular School No Elementary PK 06 2018   grade_6 70 0 2 0   1     0   2   42 33                       75.0 70 0 2 0   1     0   2   42 33                 75
2235861 2235861 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough: P Brent Trottier   Regular School No Middle 06 08 2018   grade_6 110 0 9 0   31     1   8   88 71                       159.0 110 0 9 0   31     1   8   88 71                 159
2236663 2236663 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales: Wales Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 3 0   0     0   1   14 7                       21.0 17 0 3 0   0     0   1   14 7                 21
2237112 2237112 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_6 113 0 5 0   56     0   5   90 89                       179.0 113 0 5 0   56     0   5   90 89                 179
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
2237166 2237166 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport: Westport Elementary   Regular School No Elementary 03 06 2018   grade_6 138 0 8 0   0     0   7   79 74                       153.0 138 0 8 0   0     0   7   79 74                 153
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
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
2238021 2238021 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District): Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 06 2018   grade_6 1 0 34 0   1     0   0   16 20                       36.0 1 0 34 0   1     0   0   16 20                 36
2238052 2238052 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_6 102 0 8 0   21     0   13   77 67                       144.0 102 0 8 0   21     0   13   77 67                 144
2238067 2238067 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District): Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 06 2018   grade_6 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2238128 2238128 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_6 2 0 31 0   0     0   0   9 24                       33.0 2 0 31 0   0     0   0   9 24                 33
2238192 2238192 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   grade_6 34 0 4 0   10     0   2   18 32                       50.0 34 0 4 0   10     0   2   18 32                 50
2238537 2238537 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_6 50 0 5 0   13     0   3   43 28                       71.0 50 0 5 0   13     0   3   43 28                 71
2238553 2238553 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_6 46 0 4 0   15     0   3   35 33                       68.0 46 0 4 0   15     0   3   35 33                 68
2238642 2238642 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston: Royalston Community School   Regular School No Elementary KG 06 2018   grade_6 20 0 3 0   0     0   1   13 11                       24.0 20 0 3 0   0     0   1   13 11                 24
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
2238795 2238795 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_6 121 0 3 0   1     0   5   69 61                       130.0 121 0 3 0   1     0   5   69 61                 130
2238858 2238858 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_6 139 0 6 0   3     0   6   82 72                       154.0 139 0 6 0   3     0   6   82 72                 154
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
2239022 2239022 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague: Great Falls Middle   Regular School No Middle 06 08 2018   grade_6 54 0 8 0   0     0   4   30 36                       66.0 54 0 8 0   0     0   4   30 36                 66
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
2239137 2239137 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional: Manchester Essex Regional Middle School   Regular School No Middle 06 08 2018   grade_6 111 0 3 0   1     0   2   62 55                       117.0 111 0 3 0   1     0   2   62 55                 117
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
2239230 2239230 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   grade_6 17 0 2 0   0     0   0   7 12                       19.0 17 0 2 0   0     0   0   7 12                 19
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
2239263 2239263 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_6 113 0 2 0   0     0   3   61 57                       118.0 113 0 2 0   0     0   3   61 57                 118
2239295 2239295 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba: Florence Sawyer School   Regular School No Elementary PK 08 2018   grade_6 52 0 2 0   11     0   1   32 34                       66.0 52 0 2 0   11     0   1   32 34                 66
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
2239319 2239319 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_6 16 0 2 0   0     0   0   7 11                       18.0 16 0 2 0   0     0   0   7 11                 18
2239377 2239377 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Pentucket: Elmer S Bagnall   Regular School No Elementary PK 06 2018   grade_6 70 0 3 0   0     0   0   40 33                       73.0 70 0 3 0   0     0   0   40 33                 73
2239382 2239382 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Pentucket: Helen R Donaghue School   Regular School No Elementary 03 06 2018   grade_6 66 0 5 0   1     0   0   33 39                       72.0 66 0 5 0   1     0   0   33 39                 72
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
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
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
2239452 2239452 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_6 33 0 2 0   0     0   1   12 24                       36.0 33 0 2 0   0     0   1   12 24                 36
2239460 2239460 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Quabbin: Hubbardston Center   Regular School No Elementary KG 06 2018   grade_6 41 0 3 0   0     0   0   24 20                       44.0 41 0 3 0   0     0   0   24 20                 44
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
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
2239604 2239604 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton: Salisbury Elementary   Regular School No Elementary PK 06 2018   grade_6 52 0 2 0   2     0   1   26 31                       57.0 52 0 2 0   2     0   1   26 31                 57
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
2239699 2239699 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_6 45 0 4 0   1     0   0   20 30                       50.0 45 0 4 0   1     0   0   20 30                 50
2239716 2239716 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_6 88 0 4 0   1     0   2   43 52                       95.0 88 0 4 0   1     0   2   43 52                 95
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
2229246 2229246 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_6 86 1 3 0   0     0   1   46 45                       91.0 86 1 3 0   0     0   1   46 45                 91
2229716 2229716 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_6 24 1 16 0   2     0   1   23 21                       44.0 24 1 16 0   2     0   1   23 21                 44
2230258 2230258 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_6 1 1 23 0   0     0   0   7 18                       25.0 1 1 23 0   0     0   0   7 18                 25

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