Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2019 sorted by hispanic

View and edit SQL

year

  • 2019 · 572

grade

  • grade_6 · 572
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
2040420 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041287 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042269 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2043675 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045461 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2047496 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2048406 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Middle 04 06 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041138 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_6 94 1 0 0   5     0   0   48 52                       100.0 94 1 0 0   5     0   0   48 52                 100
2041758 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_6 21 0 0 0   0     0   2   12 11                       23.0 21 0 0 0   0     0   2   12 11                 23
2041783 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_6 112 3 0 0   1     0   4   71 49                       120.0 112 3 0 0   1     0   4   71 49                 120
2042098 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_6 17 0 0 0   0     0   3   8 12                       20.0 17 0 0 0   0     0   3   8 12                 20
2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2044185 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_6 23 0 0 0   0     0   0   9 14                       23.0 23 0 0 0   0     0   0   9 14                 23
2044989 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2019   grade_6 79 0 0 0   1     0   0   47 33                       80.0 79 0 0 0   1     0   0   47 33                 80
2046415 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2019   grade_6 72 1 0 0   1     0   3   37 40                       77.0 72 1 0 0   1     0   3   37 40                 77
2047049 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_6 16 1 0 0   0     0   0   8 9                       17.0 16 1 0 0   0     0   0   8 9                 17
2047762 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_6 36 2 0 0   14     0   0   22 30                       52.0 36 2 0 0   14     0   0   22 30                 52
2047839 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_6 46 3 0 1   0     0   2   29 23                       52.0 46 3 0 1   0     0   2   29 23                 52
2047919 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_6 30 0 0 0   2     0   1   8 25                       33.0 30 0 0 0   2     0   1   8 25                 33
2048087 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_6 21 2 0 1   22     0   2   24 24                       48.0 21 2 0 1   22     0   2   24 24                 48
2048157 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2019   grade_6 19 0 0 0   1     0   0   14 6                       20.0 19 0 0 0   1     0   0   14 6                 20
2048245 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_6 161 10 0 0   3     0   6   113 67                       180.0 161 10 0 0   3     0   6   113 67                 180
2048265 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_6 19 1 0 0   0     0   0   13 7                       20.0 19 1 0 0   0     0   0   13 7                 20
2048394 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_6 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2048469 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2019   grade_6 13 0 0 0   0     0   1   7 7                       14.0 13 0 0 0   0     0   1   7 7                 14
2048574 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_6 124 0 0 0   2     0   1   59 68                       127.0 124 0 0 0   2     0   1   59 68                 127
2048640 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2019   grade_6 29 1 0 0   0     0   0   14 16                       30.0 29 1 0 0   0     0   0   14 16                 30
2048663 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2019   grade_6 33 0 0 0   0     0   0   14 19                       33.0 33 0 0 0   0     0   0   14 19                 33
2048679 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2019   grade_6 17 0 0 0   0     0   0   14 3                       17.0 17 0 0 0   0     0   0   14 3                 17
2048841 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2019   grade_6 25 0 0 0   0     0   1   13 13                       26.0 25 0 0 0   0     0   1   13 13                 26
2048869 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_6 43 1 0 0   1     0   1   22 24                       46.0 43 1 0 0   1     0   1   22 24                 46
2048876 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_6 28 2 0 0   0     0   0   11 19                       30.0 28 2 0 0   0     0   0   11 19                 30
2041208 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 1 1 0   1     0   0   21 20                       41.0 38 1 1 0   1     0   0   21 20                 41
2041588 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_6 50 0 1 0   5     0   8   36 28                       64.0 50 0 1 0   5     0   8   36 28                 64
2041821 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_6 19 0 1 0   0     0   0   9 11                       20.0 19 0 1 0   0     0   0   9 11                 20
2042540 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_6 89 1 1 0   2     1   0   40 54                       94.0 89 1 1 0   2     1   0   40 54                 94
2042669 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_6 84 1 1 0   0     0   1   42 45                       87.0 84 1 1 0   0     0   1   42 45                 87
2042716 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 0 1 0   0     0   1   22 18                       40.0 38 0 1 0   0     0   1   22 18                 40
2043796 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2019   grade_6 65 3 1 0   2     0   5   43 33                       76.0 65 3 1 0   2     0   5   43 33                 76
2044170 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_6 57 0 1 0   2     0   1   31 30                       61.0 57 0 1 0   2     0   1   31 30                 61
2044570 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2019   grade_6 42 1 1 0   1     0   1   22 24                       46.0 42 1 1 0   1     0   1   22 24                 46
2044749 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 43 0 1 0   0     0   2   26 20                       46.0 43 0 1 0   0     0   2   26 20                 46
2044996 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_6 82 0 1 0   0     0   0   41 42                       83.0 82 0 1 0   0     0   0   41 42                 83
2045171 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_6 2 6 1 0   0     0   0   3 6                       9.0 2 6 1 0   0     0   0   3 6                 9
2045447 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2019   grade_6 64 0 1 0   2     0   0   28 39                       67.0 64 0 1 0   2     0   0   28 39                 67
2045692 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_6 10 1 1 0   0     0   1   8 5                       13.0 10 1 1 0   0     0   1   8 5                 13
2046495 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_6 18 0 1 0   0     0   1   14 6                       20.0 18 0 1 0   0     0   1   14 6                 20
2046875 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   grade_6 16 0 1 0   0     0   0   9 8                       17.0 16 0 1 0   0     0   0   9 8                 17
2047578 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_6 138 0 1 0   0     0   0   72 67                       139.0 138 0 1 0   0     0   0   72 67                 139
2048549 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2019   grade_6 16 1 1 0   0     0   1   9 10                       19.0 16 1 1 0   0     0   1   9 10                 19
2048671 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   grade_6 13 1 1 0   0     0   0   5 10                       15.0 13 1 1 0   0     0   0   5 10                 15
2048767 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_6 122 2 1 0   5     0   3   72 61                       133.0 122 2 1 0   5     0   3   72 61                 133
2048828 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   grade_6 23 0 1 0   0     0   2   11 15                       26.0 23 0 1 0   0     0   2   11 15                 26
2048849 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_6 8 0 1 0   0     0   0   7 2                       9.0 8 0 1 0   0     0   0   7 2                 9
2048959 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 18 0 1 0   0     0   1   9 11                       20.0 18 0 1 0   0     0   1   9 11                 20
2049000 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2019   grade_6 51 0 1 0   0     1   0   34 19                       53.0 51 0 1 0   0     1   0   34 19                 53
2049008 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2019   grade_6 57 0 1 0   1     0   2   35 26                       61.0 57 0 1 0   1     0   2   35 26                 61
2049073 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_6 44 0 1 0   2     0   1   23 25                       48.0 44 0 1 0   2     0   1   23 25                 48
2039817 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_6 136 1 10 1   2     0   4   80 74                       154.0 136 1 10 1   2     0   4   80 74                 154
2039911 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_6 30 3 10 0   13     0   11   39 28                       67.0 30 3 10 0   13     0   11   39 28                 67
2043962 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2019   grade_6 142 1 10 0   7     0   8   88 80                       168.0 142 1 10 0   7     0   8   88 80                 168
2044107 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2019   grade_6 122 4 10 0   9     0   13   83 75                       158.0 122 4 10 0   9     0   13   83 75                 158
2045143 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2019   grade_6 205 3 10 1   2     0   5   114 112                       226.0 205 3 10 1   2     0   5   114 112                 226
2045250 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2019   grade_6 36 11 10 0   26     1   3   55 32                       87.0 36 11 10 0   26     1   3   55 32                 87
2045255 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2019   grade_6 32 17 10 0   31     0   5   46 49                       95.0 32 17 10 0   31     0   5   46 49                 95
2045640 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_6 170 10 10 0   82     0   14   138 148                       286.0 170 10 10 0   82     0   14   138 148                 286
2045739 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary KG 08 2019   grade_6 35 4 10 0   3     0   1   30 23                       53.0 35 4 10 0   3     0   1   30 23                 53
2045768 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2019   grade_6 28 2 10 0   3     0   2   25 20                       45.0 28 2 10 0   3     0   2   25 20                 45
2045800 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2019   grade_6 62 0 10 0   0     0   2   39 35                       74.0 62 0 10 0   0     0   2   39 35                 74
2046086 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_6 0 2 10 0   0     0   1   11 2                       13.0 0 2 10 0   0     0   1   11 2                 13
2046393 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2019   grade_6 219 12 10 0   12     0   1   128 126                       254.0 219 12 10 0   12     0   1   128 126                 254
2046664 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2019   grade_6 162 16 10 0   42     1   11   112 130                       242.0 162 16 10 0   42     1   11   112 130                 242
2046773 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2019   grade_6 56 1 10 0   0     0   4   29 42                       71.0 56 1 10 0   0     0   4   29 42                 71
2046977 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2019   grade_6 186 4 10 0   29     0   5   131 103                       234.0 186 4 10 0   29     0   5   131 103                 234
2048966 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_6 84 2 10 1   2     0   4   52 51                       103.0 84 2 10 1   2     0   4   52 51                 103
2046097 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_6 4 12 100 1   1     0   0   65 53                       118.0 4 12 100 1   1     0   0   65 53                 118
2044036 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2019   grade_6 58 4 101 0   7     0   10   100 80                       180.0 58 4 101 0   7     0   10   100 80                 180
2042792 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_6 127 13 103 1   7     0   3   126 128                       254.0 127 13 103 1   7     0   3   126 128                 254
2043136 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_6 14 4 104 0   8     0   2   69 63                       132.0 14 4 104 0   8     0   2   69 63                 132
2043102 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 106 0   0     0   0   57 50                       107.0 1 0 106 0   0     0   0   57 50                 107
2044092 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_6 193 9 107 14   5     0   13   185 156                       341.0 193 9 107 14   5     0   13   185 156                 341
2043085 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_6 4 0 108 0   0     0   1   53 60                       113.0 4 0 108 0   0     0   1   53 60                 113
2039943 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_6 139 3 11 1   23     1   5   96 87                       183.0 139 3 11 1   23     1   5   96 87                 183
2040297 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_6 156 14 11 1   12     0   4   101 97                       198.0 156 14 11 1   12     0   4   101 97                 198
2040300 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2019   grade_6 142 7 11 0   16     0   8   90 94                       184.0 142 7 11 0   16     0   8   90 94                 184
2041123 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_6 136 2 11 2   2     0   9   94 68                       162.0 136 2 11 2   2     0   9   94 68                 162
2041361 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_6 41 3 11 0   8     0   10   31 42                       73.0 41 3 11 0   8     0   10   31 42                 73
2041628 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2019   grade_6 135 3 11 2   25     0   2   107 71                       178.0 135 3 11 2   25     0   2   107 71                 178
2041881 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_6 272 3 11 0   2     1   18   173 134                       307.0 272 3 11 0   2     1   18   173 134                 307
2043146 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_6 2 0 11 0   0     0   1   11 3                       14.0 2 0 11 0   0     0   1   11 3                 14
2043940 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2019   grade_6 98 8 11 1   12     0   12   80 62                       142.0 98 8 11 1   12     0   12   80 62                 142
2044908 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_6 98 4 11 0   1     0   7   49 72                       121.0 98 4 11 0   1     0   7   49 72                 121
2046521 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_6 106 5 11 0   5     0   3   62 68                       130.0 106 5 11 0   5     0   3   62 68                 130
2047121 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_6 245 3 11 1   63     0   30   178 175                       353.0 245 3 11 1   63     0   30   178 175                 353
2047316 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2019   grade_6 13 4 11 0   4     0   2   17 17                       34.0 13 4 11 0   4     0   2   17 17                 34
2048598 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_6 177 0 11 0   6     0   7   105 96                       201.0 177 0 11 0   6     0   7   105 96                 201
2041660 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_6 9 7 110 0   1     0   3   58 72                       130.0 9 7 110 0   1     0   3   58 72                 130
2043657 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_6 74 24 110 1   24     0   15   128 120                       248.0 74 24 110 1   24     0   15   128 120                 248
2041741 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_6 122 9 111 1   8     0   9   141 119                       260.0 122 9 111 1   8     0   9   141 119                 260

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