Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2015 · 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
736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
738475 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_6 * * * *   *     *   *   2 *                       3                         2                   3
738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
739319 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
740285 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
741675 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_6 * * * *   *     *   *   2 *                       2                         2                   2
737439 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_6 59 1 0 0   7     0   5   39 33                       72 59 1 0 0   7     0   5   39 33                 72
737449 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_6 158 0 0 0   0     1   0   81 78                       159 158 0 0 0   0     1   0   81 78                 159
737852 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2015   grade_6 173 3 0 1   3     0   5   85 100                       185 173 3 0 1   3     0   5   85 100                 185
738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738380 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_6 113 0 0 0   2     0   1   62 54                       116 113 0 0 0   2     0   1   62 54                 116
738512 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_6 90 2 0 0   3     0   1   43 53                       96 90 2 0 0   3     0   1   43 53                 96
738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738561 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   0     0   0   24 10                       34 34 0 0 0   0     0   0   24 10                 34
738691 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_6 32 1 0 0   1     0   1   21 14                       35 32 1 0 0   1     0   1   21 14                 35
738878 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2015   grade_6 168 2 0 0   2     0   0   82 90                       172 168 2 0 0   2     0   0   82 90                 172
738886 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   1     0   2   14 23                       37 34 0 0 0   1     0   2   14 23                 37
739119 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_6 15 0 0 0   0     0   2   7 10                       17 15 0 0 0   0     0   2   7 10                 17
739656 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2015   grade_6 57 4 0 0   2     0   2   24 41                       65 57 4 0 0   2     0   2   24 41                 65
739742 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No 2 04 06 2015   grade_6 72 3 0 0   0     0   4   42 37                       79 72 3 0 0   0     0   4   42 37                 79
740031 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_6 101 1 0 0   0     0   0   48 54                       102 101 1 0 0   0     0   0   48 54                 102
740422 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_6 123 3 0 0   0     0   9   71 64                       135 123 3 0 0   0     0   9   71 64                 135
740433 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_6 27 0 0 0   0     0   4   17 14                       31 27 0 0 0   0     0   4   17 14                 31
740867 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   grade_6 61 0 0 0   1     0   1   36 27                       63 61 0 0 0   1     0   1   36 27                 63
740889 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_6 15 0 0 0   0     0   0   7 8                       15 15 0 0 0   0     0   0   7 8                 15
741014 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_6 239 3 0 1   4     0   5   135 117                       252 239 3 0 1   4     0   5   135 117                 252
741034 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_6 36 0 0 0   0     0   0   22 14                       36 36 0 0 0   0     0   0   22 14                 36
741285 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2015   grade_6 83 2 0 0   0     0   4   42 47                       89 83 2 0 0   0     0   4   42 47                 89
741316 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No 2 06 08 2015   grade_6 75 1 0 0   1     0   7   45 39                       84 75 1 0 0   1     0   7   45 39                 84
741329 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 0 0   0     0   0   4 10                       14 14 0 0 0   0     0   0   4 10                 14
741396 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_6 62 1 0 0   5     0   0   39 29                       68 62 1 0 0   5     0   0   39 29                 68
741463 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2015   grade_6 62 0 0 0   0     0   2   26 38                       64 62 0 0 0   0     0   2   26 38                 64
741477 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No 1 KG 06 2015   grade_6 105 4 0 0   2     0   2   57 56                       113 105 4 0 0   2     0   2   57 56                 113
741485 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2015   grade_6 64 1 0 0   0     0   1   36 30                       66 64 1 0 0   0     0   1   36 30                 66
742151 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_6 109 3 0 0   3     0   7   66 56                       122 109 3 0 0   3     0   7   66 56                 122
742764 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_6 23 0 0 0   0     0   0   9 14                       23 23 0 0 0   0     0   0   9 14                 23
743809 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_6 88 0 0 0   1     0   0   40 49                       89 88 0 0 0   1     0   0   40 49                 89
743957 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2015   grade_6 37 4 0 0   30     0   1   44 28                       72 37 4 0 0   30     0   1   44 28                 72
743964 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2015   grade_6 29 1 0 0   40     0   2   37 35                       72 29 1 0 0   40     0   2   37 35                 72
743984 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_6 90 5 0 0   1     0   0   56 40                       96 90 5 0 0   1     0   0   56 40                 96
744036 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_6 16 0 0 0   1     0   0   10 7                       17 16 0 0 0   1     0   0   10 7                 17
744141 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
744274 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_6 16 1 0 0   0     0   1   11 7                       18 16 1 0 0   0     0   1   11 7                 18
744348 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2015   grade_6 16 1 0 0   0     0   0   4 13                       17 16 1 0 0   0     0   0   4 13                 17
744428 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2015   grade_6 18 0 0 1   0     0   0   8 11                       19 18 0 0 1   0     0   0   8 11                 19
744529 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2015   grade_6 12 0 0 0   0     0   2   9 5                       14 12 0 0 0   0     0   2   9 5                 14
744668 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No 1 PK 06 2015   grade_6 80 1 0 0   3     0   1   49 36                       85 80 1 0 0   3     0   1   49 36                 85
744719 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   grade_6 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
744732 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_6 29 0 0 0   0     0   1   22 8                       30 29 0 0 0   0     0   1   22 8                 30
744754 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_6 54 0 0 0   1     0   1   21 35                       56 54 0 0 0   1     0   1   21 35                 56
744990 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 49 0 0 0   0     0   0   28 21                       49 49 0 0 0   0     0   0   28 21                 49
735680 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_6 113 1 1 0   1     0   0   55 61                       116 113 1 1 0   1     0   0   55 61                 116
737058 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2015   grade_6 33 0 1 0   1     0   0   19 16                       35 33 0 1 0   1     0   0   19 16                 35
737606 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_6 17 0 1 0   0     0   0   7 11                       18 17 0 1 0   0     0   0   7 11                 18
737632 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_6 136 6 1 0   5     0   0   75 73                       148 136 6 1 0   5     0   0   75 73                 148
737773 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   grade_6 64 0 1 1   0     0   2   35 33                       68 64 0 1 1   0     0   2   35 33                 68
737948 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   1   6 8                       14 12 0 1 0   0     0   1   6 8                 14
738337 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2015   grade_6 139 2 1 0   7     0   1   76 74                       150 139 2 1 0   7     0   1   76 74                 150
738343 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_6 134 2 1 1   12     0   2   72 80                       152 134 2 1 1   12     0   2   72 80                 152
738788 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_6 84 0 1 1   4     0   1   46 45                       91 84 0 1 1   4     0   1   46 45                 91
738843 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2015   grade_6 73 2 1 0   1     0   2   39 40                       79 73 2 1 0   1     0   2   39 40                 79
740046 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_6 26 0 1 0   4     0   0   20 11                       31 26 0 1 0   4     0   0   20 11                 31
740853 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   grade_6 13 0 1 0   1     0   2   9 8                       17 13 0 1 0   1     0   2   9 8                 17
740875 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_6 85 0 1 0   1     0   1   48 40                       88 85 0 1 0   1     0   1   48 40                 88
741201 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2015   grade_6 147 2 1 0   5     0   5   84 76                       160 147 2 1 0   5     0   5   84 76                 160
741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
741403 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_6 83 1 1 1   1     0   0   44 43                       87 83 1 1 1   1     0   0   44 43                 87
741410 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_6 75 0 1 2   2     0   1   40 41                       81 75 0 1 2   2     0   1   40 41                 81
741470 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2015   grade_6 51 2 1 0   0     0   0   35 19                       54 51 2 1 0   0     0   0   35 19                 54
742369 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   5 16                       21 20 0 1 0   0     0   0   5 16                 21
742747 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2015   grade_6 137 2 1 2   46     0   6   86 108                       194 137 2 1 2   46     0   6   86 108                 194
742933 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 1 0   0     0   0   7 8                       15 14 0 1 0   0     0   0   7 8                 15
743440 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_6 51 17 1 0   0     0   3   39 33                       72 51 17 1 0   0     0   3   39 33                 72
743634 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 31 0 1 0   15     0   3   31 19                       50 31 0 1 0   15     0   3   31 19                 50
743651 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 31 0 1 0   0     0   0   19 13                       32 31 0 1 0   0     0   0   19 13                 32
743720 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_6 12 1 1 0   2     0   1   11 6                       17 12 1 1 0   2     0   1   11 6                 17
743928 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2015   grade_6 46 2 1 0   24     0   2   46 29                       75 46 2 1 0   24     0   2   46 29                 75
743950 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2015   grade_6 45 2 1 0   17     0   7   41 31                       72 45 2 1 0   17     0   7   41 31                 72
744082 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_6 74 1 1 0   5     0   5   45 41                       86 74 1 1 0   5     0   5   45 41                 86
744454 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2015   grade_6 127 0 1 0   3     0   1   57 75                       132 127 0 1 0   3     0   1   57 75                 132
744537 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   14 7                       21 20 0 1 0   0     0   0   14 7                 21
744544 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   0   8 5                       13 12 0 1 0   0     0   0   8 5                 13
744551 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 KG 06 2015   grade_6 23 0 1 0   0     0   0   12 12                       24 23 0 1 0   0     0   0   12 12                 24
744604 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2015   grade_6 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
744619 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No 1 PK 06 2015   grade_6 19 0 1 0   0     0   2   9 13                       22 19 0 1 0   0     0   2   9 13                 22
744672 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2015   grade_6 86 1 1 0   0     0   4   41 51                       92 86 1 1 0   0     0   4   41 51                 92
744680 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No 1 PK 06 2015   grade_6 72 1 1 0   4     0   0   39 39                       78 72 1 1 0   4     0   0   39 39                 78
744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
744820 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_6 12 0 1 0   0     1   1   7 8                       15 12 0 1 0   0     1   1   7 8                 15
744909 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   grade_6 16 2 1 1   0     0   0   9 11                       20 16 2 1 1   0     0   0   9 11                 20
745019 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2015   grade_6 121 2 1 0   2     0   4   70 60                       130 121 2 1 0   2     0   4   70 60                 130
735749 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_6 27 3 10 0   8     0   4   18 34                       52 27 3 10 0   8     0   4   18 34                 52
736320 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_6 16 7 10 0   5     0   1   26 13                       39 16 7 10 0   5     0   1   26 13                 39
736760 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_6 4 4 10 0   0     0   0   13 5                       18 4 4 10 0   0     0   0   13 5                 18
737659 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_6 196 12 10 0   14     0   8   120 120                       240 196 12 10 0   14     0   8   120 120                 240
739047 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_6 99 0 10 0   2     0   1   62 50                       112 99 0 10 0   2     0   1   62 50                 112
739259 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2015   grade_6 35 10 10 0   10     0   2   29 38                       67 35 10 10 0   10     0   2   29 38                 67
740607 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_6 172 0 10 0   3     1   7   104 89                       193 172 0 10 0   3     1   7   104 89                 193
740764 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2015   grade_6 135 2 10 0   4     0   2   80 73                       153 135 2 10 0   4     0   2   80 73                 153
742133 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2015   grade_6 287 9 10 0   15     0   7   160 168                       328 287 9 10 0   15     0   7   160 168                 328

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