enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
735917 735917 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_5 86 1 2 0   1     0   5   47 48                       95 86 1 2 0   1     0   5   47 48                 95
735923 735923 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_5 80 1 6 0   4     0   5   46 50                       96 80 1 6 0   4     0   5   46 50                 96
736080 736080 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_5 28 0 0 0   0     0   1   19 10                       29 28 0 0 0   0     0   1   19 10                 29
736997 736997 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_5 54 1 2 0   2     0   0   31 28                       59 54 1 2 0   2     0   0   31 28                 59
737183 737183 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_5 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
737615 737615 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_5 86 3 25 0   3     0   4   64 57                       121 86 3 25 0   3     0   4   64 57                 121
737780 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
738169 738169 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_5 44 7 92 0   9     0   12   80 84                       164 44 7 92 0   9     0   12   80 84                 164
738179 738179 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_5 44 4 52 0   7     0   15   71 51                       122 44 4 52 0   7     0   15   71 51                 122
738189 738189 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_5 24 2 37 0   5     0   7   31 44                       75 24 2 37 0   5     0   7   31 44                 75
738353 738353 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_5 140 6 24 1   3     0   20   111 83                       194 140 6 24 1   3     0   20   111 83                 194
738436 738436 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_5 93 2 4 0   13     0   4   60 56                       116 93 2 4 0   13     0   4   60 56                 116
738441 738441 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_5 123 1 7 0   26     0   4   75 86                       161 123 1 7 0   26     0   4   75 86                 161
738546 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
738787 738787 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_5 88 3 5 0   1     0   1   45 53                       98 88 3 5 0   1     0   1   45 53                 98
739042 739042 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No 1 03 05 2015   grade_5 140 5 8 2   2     0   1   76 82                       158 140 5 8 2   2     0   1   76 82                 158
739076 739076 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_5 62 10 29 0   0     0   2   49 54                       103 62 10 29 0   0     0   2   49 54                 103
739082 739082 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Southeast School   Regular School No 1 KG 05 2015   grade_5 53 3 35 1   12     0   3   64 43                       107 53 3 35 1   12     0   3   64 43                 107
739088 739088 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2015   grade_5 76 11 39 1   3     0   2   69 63                       132 76 11 39 1   3     0   2   69 63                 132
739094 739094 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2015   grade_5 79 8 41 0   6     0   8   70 72                       142 79 8 41 0   6     0   8   70 72                 142
739386 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
739952 739952 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_5 201 7 67 3   5     0   10   163 130                       293 201 7 67 3   5     0   10   163 130                 293
739967 739967 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2015   grade_5 114 3 12 0   5     0   6   70 70                       140 114 3 12 0   5     0   6   70 70                 140
740577 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
740583 740583 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No 1 KG 05 2015   grade_5 35 0 1 0   9     0   2   26 21                       47 35 0 1 0   9     0   2   26 21                 47
740589 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
740596 740596 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No 1 PK 05 2015   grade_5 44 0 2 0   7     0   2   28 27                       55 44 0 2 0   7     0   2   28 27                 55
740606 740606 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_5 197 1 10 0   4     0   4   114 102                       216 197 1 10 0   4     0   4   114 102                 216
740621 740621 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_5 47 0 5 0   0     0   1   26 27                       53 47 0 5 0   0     0   1   26 27                 53
740763 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
740888 740888 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_5 12 0 3 0   0     0   2   8 9                       17 12 0 3 0   0     0   2   8 9                 17
741570 741570 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_5 293 6 38 2   131     0   17   250 237                       487 293 6 38 2   131     0   17   250 237                 487
741699 741699 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No 2 04 05 2015   grade_5 129 2 7 0   21     0   7   79 87                       166 129 2 7 0   21     0   7   79 87                 166
741709 741709 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2015   grade_5 37 1 38 0   0     0   0   39 37                       76 37 1 38 0   0     0   0   39 37                 76
741716 741716 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2015   grade_5 45 0 49 0   0     0   0   42 52                       94 45 0 49 0   0     0   0   42 52                 94
742106 742106 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_5 117 2 11 0   5     0   9   76 68                       144 117 2 11 0   5     0   9   76 68                 144
742150 742150 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No 1 03 05 2015   grade_5 120 0 1 0   1     0   5   63 64                       127 120 0 1 0   1     0   5   63 64                 127
742326 742326 MA Worcester   school 2511850 304   Uxbridge 251185002762 3040020 Whitin Elementary School   Regular School No 1 03 05 2015   grade_5 118 0 6 0   3     0   5   64 68                       132 118 0 6 0   3     0   5   64 68                 132
742551 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
742632 742632 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2015   grade_5 184 2 23 0   77     0   18   152 152                       304 184 2 23 0   77     0   18   152 152                 304
742647 742647 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No 1 PK 05 2015   grade_5 71 0 4 1   2     0   2   35 45                       80 71 0 4 1   2     0   2   35 45                 80
742978 742978 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No 1 03 05 2015   grade_5 78 4 6 1   3     0   2   51 43                       94 78 4 6 1   3     0   2   51 43                 94
743106 743106 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_5 4 13 29 0   5     0   3   28 26                       54 4 13 29 0   5     0   3   28 26                 54
743113 743113 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_5 7 5 11 0   0     0   2   13 12                       25 7 5 11 0   0     0   2   13 12                 25
743121 743121 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_5 5 7 47 0   6     0   1   30 36                       66 5 7 47 0   6     0   1   30 36                 66
743128 743128 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   grade_5 4 0 20 0   1     0   1   15 11                       26 4 0 20 0   1     0   1   15 11                 26
743136 743136 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_5 7 8 19 0   13     0   2   18 31                       49 7 8 19 0   13     0   2   18 31                 49
743143 743143 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2015   grade_5 6 8 33 0   1     0   1   25 24                       49 6 8 33 0   1     0   1   25 24                 49
743151 743151 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_5 6 1 62 0   4     0   1   33 41                       74 6 1 62 0   4     0   1   33 41                 74
743159 743159 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_5 14 7 40 0   1     0   7   40 29                       69 14 7 40 0   1     0   7   40 29                 69
743167 743167 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_5 7 6 15 0   2     0   3   18 15                       33 7 6 15 0   2     0   3   18 15                 33
743175 743175 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_5 2 5 28 0   3     0   6   23 21                       44 2 5 28 0   3     0   6   23 21                 44
743182 743182 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   grade_5 50 3 10 0   5     0   3   37 34                       71 50 3 10 0   5     0   3   37 34                 71
743190 743190 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   grade_5 6 5 24 0   6     0   6   31 16                       47 6 5 24 0   6     0   6   31 16                 47
743198 743198 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   grade_5 3 4 35 0   5     0   3   28 22                       50 3 4 35 0   5     0   3   28 22                 50
743206 743206 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_5 31 9 32 0   21     0   6   65 34                       99 31 9 32 0   21     0   6   65 34                 99
743214 743214 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   grade_5 20 4 18 0   3     0   3   21 27                       48 20 4 18 0   3     0   3   21 27                 48
743221 743221 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2015   grade_5 22 5 9 0   4     0   2   27 15                       42 22 5 9 0   4     0   2   27 15                 42
743229 743229 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_5 9 10 26 0   0     0   6   23 28                       51 9 10 26 0   0     0   6   23 28                 51
743236 743236 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   grade_5 22 4 6 0   1     0   0   15 18                       33 22 4 6 0   1     0   0   15 18                 33
743244 743244 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   grade_5 7 1 18 0   1     0   1   17 11                       28 7 1 18 0   1     0   1   17 11                 28
743251 743251 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2015   grade_5 25 5 9 0   5     0   1   25 20                       45 25 5 9 0   5     0   1   25 20                 45
743259 743259 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_5 9 9 8 0   3     0   1   19 11                       30 9 9 8 0   3     0   1   19 11                 30
743266 743266 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2015   grade_5 21 0 3 0   1     0   2   16 11                       27 21 0 3 0   1     0   2   16 11                 27
743273 743273 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2015   grade_5 57 7 7 0   6     0   4   43 38                       81 57 7 7 0   6     0   4   43 38                 81
743281 743281 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   grade_5 43 7 22 0   1     0   3   39 37                       76 43 7 22 0   1     0   3   39 37                 76
743289 743289 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_5 32 9 30 0   9     0   5   44 41                       85 32 9 30 0   9     0   5   44 41                 85
743296 743296 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_5 20 10 20 0   6     0   2   27 31                       58 20 10 20 0   6     0   2   27 31                 58
743304 743304 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_5 38 8 31 0   5     0   2   42 42                       84 38 8 31 0   5     0   2   42 42                 84
743312 743312 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_5 19 10 8 0   2     0   4   14 29                       43 19 10 8 0   2     0   4   14 29                 43
743319 743319 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   grade_5 27 11 19 0   3     0   3   30 33                       63 27 11 19 0   3     0   3   30 33                 63
743326 743326 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   grade_5 35 0 15 0   2     0   2   28 26                       54 35 0 15 0   2     0   2   28 26                 54
743333 743333 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_5 9 5 31 0   0     0   5   35 15                       50 9 5 31 0   0     0   5   35 15                 50
743341 743341 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   grade_5 20 5 4 0   2     0   3   15 19                       34 20 5 4 0   2     0   3   15 19                 34
743349 743349 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   grade_5 13 14 25 0   1     0   2   28 27                       55 13 14 25 0   1     0   2   28 27                 55
743607 743607 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_5 29 65 27 0   7     0   0   61 67                       128 29 65 27 0   7     0   0   61 67                 128
743832 743832 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_5 5 27 36 0   0     0   4   40 32                       72 5 27 36 0   0     0   4   40 32                 72
744001 744001 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No 1 02 05 2015   grade_5 66 0 2 0   1     0   0   42 27                       69 66 0 2 0   1     0   0   42 27                 69
744010 744010 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No 1 PK 05 2015   grade_5 83 0 3 0   0     0   1   43 44                       87 83 0 3 0   0     0   1   43 44                 87
744035 744035 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_5 17 0 2 0   1     0   0   11 9                       20 17 0 2 0   1     0   0   11 9                 20
744037 744037 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_5 87 2 2 0   0     0   4   50 45                       95 87 2 2 0   0     0   4   50 45                 95
744099 744099 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No 1 PK 05 2015   grade_5 33 0 1 0   0     0   1   19 16                       35 33 0 1 0   0     0   1   19 16                 35
744101 744101 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_5 99 1 5 0   1     0   3   49 60                       109 99 1 5 0   1     0   3   49 60                 109
744247 744247 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2015   grade_5 135 2 11 0   2     0   2   73 79                       152 135 2 11 0   2     0   2   73 79                 152
744251 744251 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_5 161 2 5 0   3     0   4   97 78                       175 161 2 5 0   3     0   4   97 78                 175
744479 744479 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_5 186 1 10 0   3     0   1   105 96                       201 186 1 10 0   3     0   1   105 96                 201
744569 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
744583 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
744590 744590 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No 1 PK 05 2015   grade_5 107 0 4 0   2     0   0   47 66                       113 107 0 4 0   2     0   0   47 66                 113
744597 744597 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_5 88 0 4 0   3     0   4   42 57                       99 88 0 4 0   3     0   4   42 57                 99
744731 744731 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_5 32 0 3 0   0     0   0   23 12                       35 32 0 3 0   0     0   0   23 12                 35
744738 744738 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_5 39 0 1 0   0     0   0   17 23                       40 39 0 1 0   0     0   0   17 23                 40
744746 744746 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_5 38 0 4 0   1     0   0   22 21                       43 38 0 4 0   1     0   0   22 21                 43
744753 744753 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_5 56 0 4 0   0     0   1   24 37                       61 56 0 4 0   0     0   1   24 37                 61
744837 744837 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_5 20 0 2 0   0     0   2   12 12                       24 20 0 2 0   0     0   2   12 12                 24
744845 744845 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_5 76 0 9 0   1     0   4   46 44                       90 76 0 9 0   1     0   4   46 44                 90
744921 744921 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Davis Hill Elementary   Regular School No 1 KG 05 2015   grade_5 78 2 3 0   1     0   2   50 36                       86 78 2 3 0   1     0   2   50 36                 86
744927 744927 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Dawson   Regular School No 1 KG 05 2015   grade_5 68 4 4 0   5     0   2   42 41                       83 68 4 4 0   5     0   2   42 41                 83
744938 744938 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No 1 KG 05 2015   grade_5 66 2 6 0   2     0   4   42 38                       80 66 2 6 0   2     0   4   42 38                 80
744944 744944 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_5 55 1 4 0   2     0   0   36 26                       62 55 1 4 0   2     0   0   36 26                 62

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