enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2228781 2228781 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_6 109 2 2 0   0     0   1   62 52                       114.0 109 2 2 0   0     0   1   62 52                 114
2230841 2230841 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_6 119 1 2 0   0     0   3   78 47                       125.0 119 1 2 0   0     0   3   78 47                 125
2231958 2231958 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_6 95 2 2 0   0     0   0   53 46                       99.0 95 2 2 0   0     0   0   53 46                 99
2232126 2232126 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax: Halifax Elementary   Regular School No Elementary KG 06 2018   grade_6 68 2 2 0   2     1   2   45 32                       77.0 68 2 2 0   2     1   2   45 32                 77
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
2233812 2233812 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_6 92 1 2 0   6     0   5   55 51                       106.0 92 1 2 0   6     0   5   55 51                 106
2234399 2234399 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   grade_6 35 2 2 0   2     0   0   22 19                       41.0 35 2 2 0   2     0   0   22 19                 41
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
2235066 2235066 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth: Plymouth South Middle   Regular School No Middle 06 08 2018   grade_6 232 1 2 1   2     0   10   129 119                       248.0 232 1 2 1   2     0   10   129 119                 248
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
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
2236398 2236398 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton: Sutton Middle School   Regular School No Middle 06 08 2018   grade_6 102 2 2 0   2     0   3   55 56                       111.0 102 2 2 0   2     0   3   55 56                 111
2238102 2238102 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_6 0 18 2 0   0     0   0   9 11                       20.0 0 18 2 0   0     0   0   9 11                 20
2238380 2238380 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District): Rising Tide Charter Public School   Regular School Yes High 05 12 2018   grade_6 78 2 2 1   2     0   7   49 43                       92.0 78 2 2 1   2     0   7   49 43                 92
2238500 2238500 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District): Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2018   grade_6 30 6 2 0   9     0   7   23 31                       54.0 30 6 2 0   9     0   7   23 31                 54
2238529 2238529 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_6 39 3 2 0   27     0   3   41 33                       74.0 39 3 2 0   27     0   3   41 33                 74
2238587 2238587 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_6 87 2 2 1   0     0   0   43 49                       92.0 87 2 2 1   0     0   0   43 49                 92
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
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
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
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
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
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
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
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
2231059 2231059 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_6 109 3 3 0   3     0   1   64 55                       119.0 109 3 3 0   3     0   1   64 55                 119
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
2231236 2231236 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas: Douglas Middle School   Regular School No Middle 06 08 2018   grade_6 119 1 3 0   2     0   3   80 48                       128.0 119 1 3 0   2     0   3   80 48                 128
2231300 2231300 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_6 225 1 3 0   6     0   11   122 124                       246.0 225 1 3 0   6     0   11   122 124                 246

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