Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by native_hawaiian_pacific_islander descending

View and edit SQL

year

grade

  • grade_5 · 6,218
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
1676885 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_5 41 0 6 0   4     8   3   36 26 *                     62.0 41 0 6 0   4     8   3   36 26                 62
935348 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_5 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1370180 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_5 26 15 20 0   44     5   3   56 57 *                     113.0 26 15 20 0   44     5   3   56 57                 113
737118 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_5 57 85 21 0   7     3   10   92 91                       183 57 85 21 0   7     3   10   92 91                 183
739193 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_5 92 2 4 0   4     3   1   55 51                       106 92 2 4 0   4     3   1   55 51                 106
739386 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_5 112 3 12 1   2     3   1   69 65                       134 112 3 12 1   2     3   1   69 65                 134
1125297 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_5 42 1 4 0   1     3   2   28 25                       53 42 1 4 0   1     3   2   28 25                 53
1373432 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2020   grade_5 39 0 0 0   0     3   1   22 21 *                     43.0 39 0 0 0   0     3   1   22 21                 43
2229126 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   grade_5 324 29 53 0   11     3   13   216 217                       433.0 324 29 53 0   11     3   13   216 217                 433
2236312 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton: South Elementary   Regular School No Elementary KG 05 2018   grade_5 30 8 2 0   2     3   2   21 26                       47.0 30 8 2 0   2     3   2   21 26                 47
736373 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 05 2015   grade_5 24 44 34 0   10     2   7   60 61                       121 24 44 34 0   10     2   7   60 61                 121
736425 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_5 0 26 13 0   0     2   0   15 26                       41 0 26 13 0   0     2   0   15 26                 41
740030 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_5 96 1 1 0   0     2   3   50 53                       103 96 1 1 0   0     2   3   50 53                 103
740735 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_5 17 4 5 0   0     2   2   20 10                       30 17 4 5 0   0     2   2   20 10                 30
740752 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2015   grade_5 37 1 2 0   0     2   0   22 20                       42 37 1 2 0   0     2   0   22 20                 42
741057 MA Norfolk   school 2509870 243   Quincy 250987001568 2430025 Charles A Bernazzani Elementary   Regular School No 1 KG 05 2015   grade_5 41 4 1 0   12     2   3   38 25                       63 41 4 1 0   12     2   3   38 25                 63
741120 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2015   grade_5 39 12 10 0   25     2   4   45 47                       92 39 12 10 0   25     2   4   45 47                 92
744583 MA Worcester   school 2508310 725   Nashoba 250831000948 7250010 Mary Rowlandson Elementary   Regular School No 1 PK 05 2015   grade_5 64 2 3 0   0     2   1   28 44                       72 64 2 3 0   0     2   1   28 44                 72
933429 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_5 39 17 43 0   5     2   1   60 47                       107 39 17 43 0   5     2   1   60 47                 107
935473 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_5 54 0 77 0   5     2   2   64 76                       140 54 0 77 0   5     2   2   64 76                 140
940235 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_5 25 14 117 5   2     2   0   73 92                       165 25 14 117 5   2     2   0   73 92                 165
1124065 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_5 162 9 11 0   32     2   2   118 100                       218 162 9 11 0   32     2   2   118 100                 218
1125211 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_5 89 1 7 2   7     2   3   61 50                       111 89 1 7 2   7     2   3   61 50                 111
1127101 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_5 58 0 3 0   2     2   2   33 34                       67 58 0 3 0   2     2   2   33 34                 67
1128377 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2017   grade_5 27 7 8 0   32     2   2   46 32                       78 27 7 8 0   32     2   2   46 32                 78
1129697 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_5 201 22 28 0   4     2   12   135 134                       269 201 22 28 0   4     2   12   135 134                 269
1366179 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_5 11 79 16 0   1     2   4   51 62 *                     113.0 11 79 16 0   1     2   4   51 62                 113
1366496 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_5 62 5 2 0   7     2   5   40 43 *                     83.0 62 5 2 0   7     2   5   40 43                 83
1367428 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_5 34 0 0 0   0     2   0   20 16 *                     36.0 34 0 0 0   0     2   0   20 16                 36
1368228 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_5 31 4 17 0   0     2   9   31 32 *                     63.0 31 4 17 0   0     2   9   31 32                 63
1369405 MA Middlesex   school 2508610 207   Newton 250861001366 2070055 Franklin   Regular School No Elementary KG 05 2020   grade_5 59 3 4 0   7     2   6   38 43 *                     81.0 59 3 4 0   7     2   6   38 43                 81
1672158 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_5 42 0 1 0   14     2   6   31 34 *                     65.0 42 0 1 0   14     2   6   31 34                 65
1677696 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_5 173 2 8 0   7     2   0   99 93 *                     192.0 173 2 8 0   7     2   0   99 93                 192
2041572 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2019   grade_5 65 8 3 0   12     2   5   42 53                       95.0 65 8 3 0   12     2   5   42 53                 95
2043335 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_5 64 0 4 0   21     2   3   41 53                       94.0 64 0 4 0   21     2   3   41 53                 94
2049354 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_5 26 7 7 0   2     2   6   29 21                       50.0 26 7 7 0   2     2   6   29 21                 50
2229669 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston: John Winthrop   Regular School No Elementary PK 05 2018   grade_5 0 27 12 0   3     2   1   19 26                       45.0 0 27 12 0   3     2   1   19 26                 45
2229963 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_5 2 37 20 0   1     2   3   41 24                       65.0 2 37 20 0   1     2   3   41 24                 65
2236359 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Sudbury: Israel Loring School   Regular School No Elementary KG 05 2018   grade_5 60 2 4 0   7     2   3   41 37                       78.0 60 2 4 0   7     2   3   41 37                 78
2238743 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_5 258 15 0 1   3     2   21   148 152                       300.0 258 15 0 1   3     2   21   148 152                 300
735748 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_5 36 3 11 1   6     1   2   25 35                       60 36 3 11 1   6     1   2   25 35                 60
735900 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_5 94 7 17 0   4     1   8   71 60                       131 94 7 17 0   4     1   8   71 60                 131
735904 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_5 90 3 28 0   10     1   5   73 64                       137 90 3 28 0   10     1   5   73 64                 137
735995 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2015   grade_5 166 0 4 0   2     1   3   93 83                       176 166 0 4 0   2     1   3   93 83                 176
736527 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_5 20 20 17 0   56     1   0   53 61                       114 20 20 17 0   56     1   0   53 61                 114
736655 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2015   grade_5 4 21 8 1   1     1   1   17 20                       37 4 21 8 1   1     1   1   17 20                 37
736698 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_5 0 24 11 0   0     1   3   21 18                       39 0 24 11 0   0     1   3   21 18                 39
737064 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   grade_5 17 69 25 0   0     1   11   65 58                       123 17 69 25 0   0     1   11   65 58                 123
737083 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2015   grade_5 44 43 6 0   0     1   5   51 48                       99 44 43 6 0   0     1   5   51 48                 99
737104 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   grade_5 40 46 10 1   7     1   5   59 51                       110 40 46 10 1   7     1   5   59 51                 110
737112 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2015   grade_5 13 56 7 0   1     1   4   35 47                       82 13 56 7 0   1     1   4   35 47                 82
737124 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_5 9 99 14 0   3     1   6   65 67                       132 9 99 14 0   3     1   6   65 67                 132
737192 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_5 54 2 9 0   22     1   10   50 48                       98 54 2 9 0   22     1   10   50 48                 98
737325 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2015   grade_5 5 12 4 0   4     1   2   16 12                       28 5 12 4 0   4     1   2   16 12                 28
737360 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2015   grade_5 8 15 5 1   6     1   2   15 23                       38 8 15 5 1   6     1   2   15 23                 38
737482 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_5 160 3 5 0   28     1   4   97 104                       201 160 3 5 0   28     1   4   97 104                 201
737780 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_5 124 1 3 0   3     1   2   72 62                       134 124 1 3 0   3     1   2   72 62                 134
738038 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   grade_5 74 7 18 0   4     1   7   59 52                       111 74 7 18 0   4     1   7   59 52                 111
738497 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_5 35 2 2 1   0     1   3   27 17                       44 35 2 2 1   0     1   3   27 17                 44
738546 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2015   grade_5 72 2 4 0   9     1   1   41 48                       89 72 2 4 0   9     1   1   41 48                 89
738574 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_5 98 6 21 0   1     1   0   56 71                       127 98 6 21 0   1     1   0   56 71                 127
738618 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_5 94 5 28 0   3     1   0   71 60                       131 94 5 28 0   3     1   0   71 60                 131
738654 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   grade_5 71 2 3 0   3     1   1   48 33                       81 71 2 3 0   3     1   1   48 33                 81
738827 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2015   grade_5 201 3 16 0   0     1   7   103 125                       228 201 3 16 0   0     1   7   103 125                 228
739729 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_5 109 5 4 7   3     1   2   74 57                       131 109 5 4 7   3     1   2   74 57                 131
739906 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2015   grade_5 55 4 70 0   9     1   6   71 74                       145 55 4 70 0   9     1   6   71 74                 145
740008 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2015   grade_5 68 3 7 0   6     1   3   51 37                       88 68 3 7 0   6     1   3   51 37                 88
740171 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_5 33 19 31 1   2     1   9   55 41                       96 33 19 31 1   2     1   9   55 41                 96
740189 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_5 15 6 14 0   0     1   2   24 14                       38 15 6 14 0   0     1   2   24 14                 38
740247 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No 1 PK 05 2015   grade_5 9 4 1 1   0     1   0   9 7                       16 9 4 1 1   0     1   0   9 7                 16
740502 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No 1 KG 05 2015   grade_5 77 2 2 0   12     1   0   49 45                       94 77 2 2 0   12     1   0   49 45                 94
740520 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No 1 KG 05 2015   grade_5 37 2 12 0   4     1   0   36 20                       56 37 2 12 0   4     1   0   36 20                 56
740577 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No 1 KG 05 2015   grade_5 47 1 0 0   3     1   1   27 26                       53 47 1 0 0   3     1   1   27 26                 53
740589 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No 1 KG 05 2015   grade_5 41 2 2 0   3     1   3   30 22                       52 41 2 2 0   3     1   3   30 22                 52
740713 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2015   grade_5 35 7 1 0   2     1   0   26 20                       46 35 7 1 0   2     1   0   26 20                 46
740763 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2015   grade_5 122 1 14 1   1     1   4   64 80                       144 122 1 14 1   1     1   4   64 80                 144
741013 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_5 103 2 1 0   0     1   7   56 58                       114 103 2 1 0   0     1   7   56 58                 114
741091 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No 1 KG 05 2015   grade_5 7 2 0 0   40     1   1   25 26                       51 7 2 0 0   40     1   1   25 26                 51
741591 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No 1 PK 05 2015   grade_5 47 1 2 0   0     1   0   21 30                       51 47 1 2 0   0     1   0   21 30                 51
741651 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_5 5 4 47 0   1     1   1   29 30                       59 5 4 47 0   1     1   1   29 30                 59
741934 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No 1 PK 05 2015   grade_5 6 15 40 0   6     1   2   30 40                       70 6 15 40 0   6     1   2   30 40                 70
741940 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No 1 KG 05 2015   grade_5 5 11 29 0   1     1   0   30 17                       47 5 11 29 0   1     1   0   30 17                 47
742078 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2015   grade_5 23 7 3 0   4     1   2   22 18                       40 23 7 3 0   4     1   2   22 18                 40
742119 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2015   grade_5 71 2 3 0   3     1   6   43 43                       86 71 2 3 0   3     1   6   43 43                 86
742142 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_5 16 1 3 0   1     1   1   11 12                       23 16 1 3 0   1     1   1   11 12                 23
742526 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No 1 KG 05 2015   grade_5 78 4 3 0   19     1   1   49 57                       106 78 4 3 0   19     1   1   49 57                 106
742551 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_5 109 10 24 1   2     1   13   77 83                       160 109 10 24 1   2     1   13   77 83                 160
742743 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No 1 03 05 2015   grade_5 103 1 1 3   33     1   0   71 71                       142 103 1 1 3   33     1   0   71 71                 142
742919 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_5 389 36 30 0   18     1   22   262 234                       496 389 36 30 0   18     1   22   262 234                 496
743010 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Muraco Elementary   Regular School No 1 KG 05 2015   grade_5 39 0 4 1   14     1   3   38 24                       62 39 0 4 1   14     1   3   38 24                 62
743063 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No 1 PK 05 2015   grade_5 62 4 5 1   9     1   3   41 44                       85 62 4 5 1   9     1   3   41 44                 85
744059 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Page Hilltop Elementary School   Regular School No 1 PK 05 2015   grade_5 68 4 7 1   1     1   4   43 43                       86 68 4 7 1   1     1   4   43 43                 86
744286 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No 1 03 05 2015   grade_5 208 3 4 2   2     1   4   110 114                       224 208 3 4 2   2     1   4   110 114                 224
744333 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_5 169 1 3 0   19     1   3   98 98                       196 169 1 3 0   19     1   3   98 98                 196
744506 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2015   grade_5 123 5 12 3   3     1   7   77 77                       154 123 5 12 3   3     1   7   77 77                 154
744569 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_5 94 1 2 0   0     1   1   52 47                       99 94 1 2 0   0     1   1   52 47                 99
744879 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2015   grade_5 79 1 0 0   2     1   0   41 42                       83 79 1 0 0   2     1   0   41 42                 83
932843 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_5 279 22 34 2   5     1   24   176 191                       367 279 22 34 2   5     1   24   176 191                 367
932869 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_5 181 2 6 0   6     1   8   109 95                       204 181 2 6 0   6     1   8   109 95                 204
932925 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_5 231 14 8 0   60     1   18   168 164                       332 231 14 8 0   60     1   18   168 164                 332

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