Data source: Big Local News · About: Big Local

887 rows where grade = "grade_5", state = "MA" and year = 2016 sorted by white

View and edit SQL

year

  • 2016 · 887

grade

  • grade_5 · 887
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
933139 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   grade_5 * * * *   *     *   *   2 2                       4                         2 2                 4
935063 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_5 * * * *   *     *   *   2 1                       3                         2 1                 3
935277 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_5 * * * *   *     *   *   * *                       1                                             1
935453 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_5 * * * *   *     *   *   3 1                       4                         3 1                 4
936165 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_5 * * * *   *     *   *   3 *                       4                         3                   4
936246 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2016   grade_5 * * * *   *     *   *   2 1                       3                         2 1                 3
939687 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_5 * * * *   *     *   *   1 1                       2                         1 1                 2
933195 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2016   grade_5 0 5 9 0   0     1   1   10 6                       16 0 5 9 0   0     1   1   10 6                 16
933226 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   grade_5 0 26 17 0   1     1   3   22 26                       48 0 26 17 0   1     1   3   22 26                 48
933256 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2016   grade_5 0 18 10 0   0     0   3   13 18                       31 0 18 10 0   0     0   3   13 18                 31
933277 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2016   grade_5 0 25 51 0   1     0   12   45 44                       89 0 25 51 0   1     0   12   45 44                 89
933406 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2016   grade_5 0 12 6 0   0     0   0   9 9                       18 0 12 6 0   0     0   0   9 9                 18
933503 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_5 0 9 27 0   1     0   0   17 20                       37 0 9 27 0   1     0   0   17 20                 37
933600 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_5 0 16 12 0   0     0   1   16 13                       29 0 16 12 0   0     0   1   16 13                 29
933608 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_5 0 13 10 1   1     0   0   12 13                       25 0 13 10 1   1     0   0   12 13                 25
933618 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_5 0 18 16 0   0     0   0   15 19                       34 0 18 16 0   0     0   0   15 19                 34
933654 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 05 08 2016   grade_5 0 4 7 0   0     0   0   5 6                       11 0 4 7 0   0     0   0   5 6                 11
933781 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_5 0 3 23 0   0     0   0   11 15                       26 0 3 23 0   0     0   0   11 15                 26
933807 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_5 0 0 36 0   0     0   1   14 23                       37 0 0 36 0   0     0   1   14 23                 37
933815 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_5 0 3 4 0   0     0   0   3 4                       7 0 3 4 0   0     0   0   3 4                 7
938581 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_5 0 8 33 0   0     0   0   10 31                       41 0 8 33 0   0     0   0   10 31                 41
938682 MA Hampden   school 2511130 281   Springfield 251113001815 2810120 Lincoln   Regular School No 1 KG 05 2016   grade_5 0 6 48 0   0     1   0   26 29                       55 0 6 48 0   0     1   0   26 29                 55
940292 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_5 0 26 9 1   1     0   2   19 20                       39 0 26 9 1   1     0   2   19 20                 39
940366 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_5 0 17 3 0   0     0   0   11 9                       20 0 17 3 0   0     0   0   11 9                 20
940496 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_5 0 0 56 0   0     0   0   26 30                       56 0 0 56 0   0     0   0   26 30                 56
940595 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_5 0 34 9 0   0     0   0   24 19                       43 0 34 9 0   0     0   0   24 19                 43
940626 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_5 0 68 18 0   0     0   1   48 39                       87 0 68 18 0   0     0   1   48 39                 87
940712 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence   Regular School Yes 1 KG 05 2016   grade_5 0 26 28 1   0     0   3   36 22                       58 0 26 28 1   0     0   3   36 22                 58
933118 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No 1 PK 05 2016   grade_5 1 14 36 1   1     0   0   25 28                       53 1 14 36 1   1     0   0   25 28                 53
933125 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2016   grade_5 1 53 10 1   3     0   2   39 31                       70 1 53 10 1   3     0   2   39 31                 70
933146 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2016   grade_5 1 10 29 0   0     0   0   20 20                       40 1 10 29 0   0     0   0   20 20                 40
933178 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No 1 PK 05 2016   grade_5 1 16 15 0   8     0   2   25 17                       42 1 16 15 0   8     0   2   25 17                 42
933212 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2016   grade_5 1 13 8 0   0     0   1   15 8                       23 1 13 8 0   0     0   1   15 8                 23
933219 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No 1 PK 05 2016   grade_5 1 16 10 0   0     0   0   12 15                       27 1 16 10 0   0     0   0   12 15                 27
933366 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2016   grade_5 1 27 17 0   34     1   6   50 36                       86 1 27 17 0   34     1   6   50 36                 86
933382 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_5 1 9 8 0   1     0   0   8 11                       19 1 9 8 0   1     0   0   8 11                 19
933449 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2016   grade_5 1 1 23 0   0     0   0   14 11                       25 1 1 23 0   0     0   0   14 11                 25
933496 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   grade_5 1 14 12 0   0     0   2   13 16                       29 1 14 12 0   0     0   2   13 16                 29
933523 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2016   grade_5 1 23 8 1   3     0   2   20 18                       38 1 23 8 1   3     0   2   20 18                 38
933540 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2016   grade_5 1 23 11 0   1     0   0   22 14                       36 1 23 11 0   1     0   0   22 14                 36
933565 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_5 1 26 14 0   0     0   1   25 17                       42 1 26 14 0   0     0   1   25 17                 42
933591 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_5 1 24 12 0   0     0   0   21 16                       37 1 24 12 0   0     0   0   21 16                 37
935570 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_5 1 1 37 0   0     0   0   17 22                       39 1 1 37 0   0     0   0   17 22                 39
935789 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_5 1 0 92 0   0     0   0   45 48                       93 1 0 92 0   0     0   0   45 48                 93
938575 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No 1 PK 05 2016   grade_5 1 4 60 0   0     0   0   29 36                       65 1 4 60 0   0     0   0   29 36                 65
939960 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   grade_5 1 5 57 0   3     0   2   31 37                       68 1 5 57 0   3     0   2   31 37                 68
940389 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_5 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
940534 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   grade_5 1 43 24 0   1     0   1   40 30                       70 1 43 24 0   1     0   1   40 30                 70
934192 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2016   grade_5 10 13 1 0   2     1   4   14 17                       31 10 13 1 0   2     1   4   14 17                 31
934376 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2016   grade_5 10 6 110 0   3     0   0   63 66                       129 10 6 110 0   3     0   0   63 66                 129
934807 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_5 10 15 44 3   2     0   2   40 36                       76 10 15 44 3   2     0   2   40 36                 76
935594 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_5 10 1 45 0   0     0   1   27 30                       57 10 1 45 0   0     0   1   27 30                 57
936174 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_5 10 6 23 0   16     0   2   23 34                       57 10 6 23 0   16     0   2   23 34                 57
936301 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2016   grade_5 10 5 62 0   9     0   2   47 41                       88 10 5 62 0   9     0   2   47 41                 88
938386 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2016   grade_5 10 0 0 0   0     0   2   6 6                       12 10 0 0 0   0     0   2   6 6                 12
938464 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2016   grade_5 10 4 6 0   2     0   0   12 10                       22 10 4 6 0   2     0   0   12 10                 22
939251 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No 1 KG 05 2016   grade_5 10 4 38 0   0     0   2   30 24                       54 10 4 38 0   0     0   2   30 24                 54
939984 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   grade_5 10 4 27 0   5     0   4   29 21                       50 10 4 27 0   5     0   4   29 21                 50
940142 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_5 10 11 43 0   3     0   3   36 34                       70 10 11 43 0   3     0   3   36 34                 70
940743 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes 2 05 08 2016   grade_5 10 23 59 0   1     0   1   46 48                       94 10 23 59 0   1     0   1   46 48                 94
941543 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_5 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
935333 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_5 100 1 23 0   1     0   9   66 68                       134 100 1 23 0   1     0   9   66 68                 134
935506 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2016   grade_5 100 0 0 0   3     0   1   62 42                       104 100 0 0 0   3     0   1   62 42                 104
934475 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_5 101 6 24 0   1     0   0   75 57                       132 101 6 24 0   1     0   0   75 57                 132
937256 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2016   grade_5 101 3 5 0   1     0   2   61 51                       112 101 3 5 0   1     0   2   61 51                 112
936233 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_5 103 2 11 0   0     0   2   67 51                       118 103 2 11 0   0     0   2   67 51                 118
936573 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_5 103 5 3 13   6     0   5   58 77                       135 103 5 3 13   6     0   5   58 77                 135
932642 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_5 104 0 3 1   15     0   4   65 62                       127 104 0 3 1   15     0   4   65 62                 127
941460 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_5 104 0 1 0   0     0   2   49 58                       107 104 0 1 0   0     0   2   49 58                 107
932667 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 KG 05 2016   grade_5 105 2 5 0   14     0   6   66 66                       132 105 2 5 0   14     0   6   66 66                 132
939597 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_5 106 2 1 0   1     0   5   60 55                       115 106 2 1 0   1     0   5   60 55                 115
935288 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_5 107 1 4 0   10     0   2   52 72                       124 107 1 4 0   10     0   2   52 72                 124
937607 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2016   grade_5 108 2 14 0   0     0   8   78 54                       132 108 2 14 0   0     0   8   78 54                 132
938502 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No 2 04 05 2016   grade_5 108 1 3 0   23     0   2   70 67                       137 108 1 3 0   23     0   2   70 67                 137
935211 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_5 109 1 27 0   3     0   19   74 85                       159 109 1 27 0   3     0   19   74 85                 159
935230 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_5 109 2 1 0   2     0   1   62 53                       115 109 2 1 0   2     0   1   62 53                 115
935424 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   grade_5 109 7 25 0   3     0   2   79 67                       146 109 7 25 0   3     0   2   79 67                 146
936721 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2016   grade_5 109 4 30 0   3     0   2   71 77                       148 109 4 30 0   3     0   2   71 77                 148
936764 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_5 109 3 5 3   3     0   4   59 68                       127 109 3 5 3   3     0   4   59 68                 127
933159 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_5 11 12 20 0   1     0   3   23 24                       47 11 12 20 0   1     0   3   23 24                 47
933301 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No 1 PK 05 2016   grade_5 11 11 9 0   4     0   1   24 12                       36 11 11 9 0   4     0   1   24 12                 36
933328 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   grade_5 11 6 7 0   1     0   1   18 8                       26 11 6 7 0   1     0   1   18 8                 26
933468 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2016   grade_5 11 20 16 0   2     0   2   21 30                       51 11 20 16 0   2     0   2   21 30                 51
934234 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2016   grade_5 11 4 2 0   7     0   2   12 14                       26 11 4 2 0   7     0   2   12 14                 26
936203 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2016   grade_5 11 6 53 0   76     0   9   82 73                       155 11 6 53 0   76     0   9   82 73                 155
937978 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No 1 PK 05 2016   grade_5 11 26 8 0   8     0   2   29 26                       55 11 26 8 0   8     0   2   29 26                 55
938568 MA Hampden   school 2511130 281   Springfield 251113001826 2810020 Samuel Bowles   Regular School No 1 KG 05 2016   grade_5 11 4 34 0   0     0   1   28 22                       50 11 4 34 0   0     0   1   28 22                 50
938654 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_5 11 9 14 0   0     0   1   15 20                       35 11 9 14 0   0     0   1   15 20                 35
940318 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_5 11 23 85 0   2     0   3   71 53                       124 11 23 85 0   2     0   3   71 53                 124
940524 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 08 2016   grade_5 11 18 29 0   1     0   1   33 27                       60 11 18 29 0   1     0   1   33 27                 60
938916 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2016   grade_5 110 0 6 0   1     0   12   69 60                       129 110 0 6 0   1     0   12   69 60                 129
941469 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_5 110 0 5 0   3     0   2   66 54                       120 110 0 5 0   3     0   2   66 54                 120
933854 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_5 111 1 4 0   1     1   4   70 52                       122 111 1 4 0   1     1   4   70 52                 122
937380 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No 1 KG 05 2016   grade_5 111 2 5 1   7     0   2   66 62                       128 111 2 5 1   7     0   2   66 62                 128
932772 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_5 112 7 14 0   8     0   13   82 72                       154 112 7 14 0   8     0   13   82 72                 154
935293 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_5 113 0 3 0   22     0   4   69 73                       142 113 0 3 0   22     0   4   69 73                 142
939578 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No 2 04 05 2016   grade_5 113 11 6 1   20     0   9   91 69                       160 113 11 6 1   20     0   9   91 69                 160
936039 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2016   grade_5 114 0 1 1   5     1   4   66 60                       126 114 0 1 1   5     1   4   66 60                 126
932557 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_5 115 0 1 0   0     0   0   62 54                       116 115 0 1 0   0     0   0   62 54                 116
939118 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No 1 PK 05 2016   grade_5 115 2 4 0   10     0   4   67 68                       135 115 2 4 0   10     0   4   67 68                 135

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