enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2044528 2044528 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2019   kindergarten 34 6 6 1   17     0   4   35 33                       68.0 34 6 6 1   17     0   4   35 33                 68
2044529 2044529 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2019   grade_1 28 4 8 0   15     0   12   31 36                       67.0 28 4 8 0   15     0   12   31 36                 67
2044530 2044530 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2019   grade_2 54 5 6 0   16     0   5   39 47                       86.0 54 5 6 0   16     0   5   39 47                 86
2044531 2044531 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2019   grade_3 39 1 6 0   14     0   6   42 24                       66.0 39 1 6 0   14     0   6   42 24                 66
2044532 2044532 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2019   grade_4 44 3 3 0   17     0   7   39 34                       74.0 44 3 3 0   17     0   7   39 34                 74
2044533 2044533 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2019   grade_5 41 5 3 0   14     0   3   29 37                       66.0 41 5 3 0   14     0   3   29 37                 66
2040892 2040892 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   pre_kindergarten 2 25 12 0   0     0   4   20 23                       43.0 2 25 12 0   0     0   4   20 23                 43
2040893 2040893 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   kindergarten 0 26 25 1   0     0   2   27 27                       54.0 0 26 25 1   0     0   2   27 27                 54
2040894 2040894 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_1 0 22 38 0   0     0   0   35 25                       60.0 0 22 38 0   0     0   0   35 25                 60
2040895 2040895 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_2 0 27 32 0   0     0   1   29 31                       60.0 0 27 32 0   0     0   1   29 31                 60
2040896 2040896 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_3 2 23 28 0   0     0   1   30 24                       54.0 2 23 28 0   0     0   1   30 24                 54
2040897 2040897 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_4 1 52 42 1   0     0   2   52 46                       98.0 1 52 42 1   0     0   2   52 46                 98
2040898 2040898 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_5 1 49 29 0   0     0   2   44 37                       81.0 1 49 29 0   0     0   2   44 37                 81
2040899 2040899 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_6 0 17 26 0   0     0   0   25 18                       43.0 0 17 26 0   0     0   0   25 18                 43
2040900 2040900 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_7 0 24 18 0   0     0   1   24 19                       43.0 0 24 18 0   0     0   1   24 19                 43
2040901 2040901 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_8 0 22 11 0   0     0   0   23 10                       33.0 0 22 11 0   0     0   0   23 10                 33
2047486 2047486 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2019   grade_9 141 54 140 1   36     1   13   172 214                       386.0 141 54 140 1   36     1   13   172 214                 386
2047487 2047487 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2019   grade_10 138 57 138 1   24     0   16   191 183                       374.0 138 57 138 1   24     0   16   191 183                 374
2047488 2047488 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2019   grade_11 122 64 115 0   26     0   10   139 198                       337.0 122 64 115 0   26     0   10   139 198                 337
2047489 2047489 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2019   grade_12 124 58 121 0   15     0   11   145 184                       329.0 124 58 121 0   15     0   11   145 184                 329
2047461 2047461 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_7 64 75 189 1   38     0   17   196 188                       384.0 64 75 189 1   38     0   17   196 188                 384
2047462 2047462 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_8 77 71 197 0   18     0   19   183 199                       382.0 77 71 197 0   18     0   19   183 199                 382
2047399 2047399 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   pre_kindergarten 12 7 4 0   4     0   0   18 9                       27.0 12 7 4 0   4     0   0   18 9                 27
2047400 2047400 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   kindergarten 27 10 14 1   6     0   1   32 27                       59.0 27 10 14 1   6     0   1   32 27                 59
2047401 2047401 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_1 32 9 14 0   2     0   2   29 30                       59.0 32 9 14 0   2     0   2   29 30                 59
2047402 2047402 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_2 23 5 11 0   3     0   5   25 22                       47.0 23 5 11 0   3     0   5   25 22                 47
2047403 2047403 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_3 28 11 10 0   4     0   4   24 33                       57.0 28 11 10 0   4     0   4   24 33                 57
2047404 2047404 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_4 27 8 11 0   2     0   7   23 32                       55.0 27 8 11 0   2     0   7   23 32                 55
2047405 2047405 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_5 32 11 14 0   0     0   2   31 28                       59.0 32 11 14 0   0     0   2   31 28                 59
2047406 2047406 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_6 19 9 8 0   3     0   4   24 19                       43.0 19 9 8 0   3     0   4   24 19                 43
2046465 2046465 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2019   kindergarten 62 1 8 0   10     0   6   47 40                       87.0 62 1 8 0   10     0   6   47 40                 87
2046466 2046466 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2019   grade_1 64 3 4 0   3     1   6   38 43                       81.0 64 3 4 0   3     1   6   38 43                 81
2046467 2046467 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2019   grade_2 57 5 5 0   4     0   7   44 34                       78.0 57 5 5 0   4     0   7   44 34                 78
2046468 2046468 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2019   grade_3 53 0 13 0   3     0   6   39 35                       75.0 53 0 13 0   3     0   6   39 35                 75
2046469 2046469 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2019   grade_4 66 4 9 0   3     0   1   38 45                       83.0 66 4 9 0   3     0   1   38 45                 83
2039811 2039811 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_3 108 5 8 0   5     1   2   55 74                       129.0 108 5 8 0   5     1   2   55 74                 129
2039812 2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
2042444 2042444 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   kindergarten 53 15 13 0   0     0   5   41 45                       86.0 53 15 13 0   0     0   5   41 45                 86
2042445 2042445 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_1 48 11 18 0   1     0   1   47 32                       79.0 48 11 18 0   1     0   1   47 32                 79
2042446 2042446 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_2 59 8 21 1   0     0   1   43 47                       90.0 59 8 21 1   0     0   1   43 47                 90
2042447 2042447 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_3 58 6 19 0   0     0   3   40 46                       86.0 58 6 19 0   0     0   3   40 46                 86
2042448 2042448 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_4 72 6 15 0   0     0   1   54 40                       94.0 72 6 15 0   0     0   1   54 40                 94
2042449 2042449 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_5 74 8 20 0   0     0   2   41 63                       104.0 74 8 20 0   0     0   2   41 63                 104
2048937 2048937 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   pre_kindergarten 40 0 3 0   0     0   1   26 18                       44.0 40 0 3 0   0     0   1   26 18                 44
2048938 2048938 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   kindergarten 91 2 7 1   0     0   3   52 52                       104.0 91 2 7 1   0     0   3   52 52                 104
2048939 2048939 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   grade_1 77 1 6 1   3     0   1   53 36                       89.0 77 1 6 1   3     0   1   53 36                 89
2048940 2048940 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   grade_2 92 2 6 0   1     0   3   55 49                       104.0 92 2 6 0   1     0   3   55 49                 104
2047212 2047212 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   kindergarten 6 12 53 0   6     0   2   47 32                       79.0 6 12 53 0   6     0   2   47 32                 79
2047213 2047213 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_1 7 2 67 1   6     0   2   46 39                       85.0 7 2 67 1   6     0   2   46 39                 85
2047214 2047214 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_2 5 7 76 0   3     0   1   46 46                       92.0 5 7 76 0   3     0   1   46 46                 92
2047215 2047215 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_3 6 12 49 0   4     0   2   29 44                       73.0 6 12 49 0   4     0   2   29 44                 73
2047216 2047216 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_4 6 4 62 0   7     0   2   38 43                       81.0 6 4 62 0   7     0   2   38 43                 81
2047217 2047217 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_5 11 8 71 0   8     0   2   52 48                       100.0 11 8 71 0   8     0   2   52 48                 100
2047218 2047218 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_6 8 8 63 1   8     0   2   48 42                       90.0 8 8 63 1   8     0   2   48 42                 90
2044089 2044089 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_3 191 13 96 2   10     0   14   169 157                       326.0 191 13 96 2   10     0   14   169 157                 326
2044090 2044090 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_4 199 13 93 9   3     1   18   179 157                       336.0 199 13 93 9   3     1   18   179 157                 336
2044091 2044091 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_5 190 11 95 8   11     0   14   178 151                       329.0 190 11 95 8   11     0   14   178 151                 329
2046883 2046883 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   pre_kindergarten 16 0 4 0   2     0   0   14 8                       22.0 16 0 4 0   2     0   0   14 8                 22
2046884 2046884 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   kindergarten 44 5 3 0   7     0   1   29 31                       60.0 44 5 3 0   7     0   1   29 31                 60
2046885 2046885 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   grade_1 36 5 6 0   11     0   2   32 28                       60.0 36 5 6 0   11     0   2   32 28                 60
2046886 2046886 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   grade_2 54 4 4 0   15     1   2   43 37                       80.0 54 4 4 0   15     1   2   43 37                 80
2046887 2046887 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   grade_3 45 6 3 0   11     0   1   32 34                       66.0 45 6 3 0   11     0   1   32 34                 66
2039949 2039949 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_6 59 3 17 1   53     0   0   73 60                       133.0 59 3 17 1   53     0   0   73 60                 133
2039950 2039950 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_7 81 4 15 0   44     0   5   82 67                       149.0 81 4 15 0   44     0   5   82 67                 149
2039951 2039951 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_8 77 2 11 0   35     0   4   54 75                       129.0 77 2 11 0   35     0   4   54 75                 129
2045324 2045324 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   kindergarten 47 1 1 0   2     0   2   18 35                       53.0 47 1 1 0   2     0   2   18 35                 53
2045325 2045325 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   grade_1 34 3 1 0   1     0   3   25 17                       42.0 34 3 1 0   1     0   3   25 17                 42
2045326 2045326 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   grade_2 46 0 2 0   1     0   1   24 26                       50.0 46 0 2 0   1     0   1   24 26                 50
2045327 2045327 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   grade_3 46 1 0 0   1     0   1   33 16                       49.0 46 1 0 0   1     0   1   33 16                 49
2045328 2045328 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   grade_4 56 2 3 0   4     0   1   32 34                       66.0 56 2 3 0   4     0   1   32 34                 66
2045329 2045329 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   grade_5 43 0 0 0   1     0   1   23 22                       45.0 43 0 0 0   1     0   1   23 22                 45
2045234 2045234 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   kindergarten 18 0 0 0   37     0   1   29 27                       56.0 18 0 0 0   37     0   1   29 27                 56
2045235 2045235 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   grade_1 20 1 1 0   32     0   1   27 28                       55.0 20 1 1 0   32     0   1   27 28                 55
2045236 2045236 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   grade_2 16 0 0 0   37     0   2   32 23                       55.0 16 0 0 0   37     0   2   32 23                 55
2045237 2045237 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   grade_3 22 0 1 0   31     0   0   27 27                       54.0 22 0 1 0   31     0   0   27 27                 54
2045238 2045238 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   grade_4 25 1 2 0   32     0   1   27 34                       61.0 25 1 2 0   32     0   1   27 34                 61
2045239 2045239 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   grade_5 14 1 0 0   40     1   0   26 30                       56.0 14 1 0 0   40     1   0   26 30                 56
2043345 2043345 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   pre_kindergarten 31 0 3 0   9     0   2   29 16                       45.0 31 0 3 0   9     0   2   29 16                 45
2043346 2043346 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   kindergarten 46 4 6 0   2     0   1   28 31                       59.0 46 4 6 0   2     0   1   28 31                 59
2043347 2043347 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   grade_1 44 4 4 0   6     0   1   30 29                       59.0 44 4 4 0   6     0   1   30 29                 59
2043348 2043348 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   grade_2 34 3 3 0   5     0   6   30 21                       51.0 34 3 3 0   5     0   6   30 21                 51
2043349 2043349 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   grade_3 42 1 1 0   4     0   3   26 25                       51.0 42 1 1 0   4     0   3   26 25                 51
2043350 2043350 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   grade_4 52 1 2 0   5     0   5   34 31                       65.0 52 1 2 0   5     0   5   34 31                 65
2043351 2043351 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   grade_5 44 2 6 0   6     0   1   33 26                       59.0 44 2 6 0   6     0   1   33 26                 59
2047054 2047054 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_1 128 4 3 0   7     0   7   70 79                       149.0 128 4 3 0   7     0   7   70 79                 149
2047055 2047055 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_2 108 2 3 1   4     0   5   65 58                       123.0 108 2 3 1   4     0   5   65 58                 123
2047056 2047056 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_3 124 1 5 0   11     0   6   69 78                       147.0 124 1 5 0   11     0   6   69 78                 147
2047192 2047192 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2019   grade_9 244 25 41 1   21     1   8   167 174                       341.0 244 25 41 1   21     1   8   167 174                 341
2047193 2047193 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2019   grade_10 220 25 37 0   19     0   6   148 159                       307.0 220 25 37 0   19     0   6   148 159                 307
2047194 2047194 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2019   grade_11 224 22 39 0   17     0   3   141 164                       305.0 224 22 39 0   17     0   3   141 164                 305
2047195 2047195 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2019   grade_12 260 18 39 1   23     1   6   165 183                       348.0 260 18 39 1   23     1   6   165 183                 348
2043580 2043580 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   pre_kindergarten 2 1 14 0   1     0   1   9 10                       19.0 2 1 14 0   1     0   1   9 10                 19
2043581 2043581 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   kindergarten 7 7 59 0   11     0   3   37 50                       87.0 7 7 59 0   11     0   3   37 50                 87
2043582 2043582 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_1 5 6 82 0   12     0   2   50 57                       107.0 5 6 82 0   12     0   2   50 57                 107
2043583 2043583 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_2 11 5 68 0   7     0   2   42 51                       93.0 11 5 68 0   7     0   2   42 51                 93
2043584 2043584 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_3 2 4 81 0   11     0   3   56 45                       101.0 2 4 81 0   11     0   3   56 45                 101
2043585 2043585 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_4 9 5 70 0   15     0   0   54 45                       99.0 9 5 70 0   15     0   0   54 45                 99
2043586 2043586 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_5 3 7 77 1   18     0   2   51 57                       108.0 3 7 77 1   18     0   2   51 57                 108
2042807 2042807 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2019   kindergarten 73 0 3 0   1     0   3   41 39                       80.0 73 0 3 0   1     0   3   41 39                 80
2042808 2042808 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2019   grade_1 62 0 7 0   1     0   5   43 32                       75.0 62 0 7 0   1     0   5   43 32                 75

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