enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
740391 740391 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   kindergarten 35 3 4 0   5     0   6   24 29                       53 35 3 4 0   5     0   6   24 29                 53
740392 740392 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_1 39 5 2 0   7     0   1   22 32                       54 39 5 2 0   7     0   1   22 32                 54
740393 740393 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_2 38 2 2 1   9     0   3   33 22                       55 38 2 2 1   9     0   3   33 22                 55
740394 740394 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_3 26 4 3 0   7     1   2   24 19                       43 26 4 3 0   7     1   2   24 19                 43
740395 740395 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_4 41 0 0 1   8     0   9   28 31                       59 41 0 0 1   8     0   9   28 31                 59
740396 740396 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_5 36 0 1 0   4     0   4   23 22                       45 36 0 1 0   4     0   4   23 22                 45
937227 937227 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2016   kindergarten 29 0 3 0   8     0   4   27 17                       44 29 0 3 0   8     0   4   27 17                 44
937228 937228 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2016   grade_1 37 3 3 0   4     0   6   25 28                       53 37 3 3 0   4     0   6   25 28                 53
937229 937229 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2016   grade_2 37 6 2 0   8     0   1   24 30                       54 37 6 2 0   8     0   1   24 30                 54
937230 937230 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2016   grade_3 37 2 3 1   8     0   3   32 22                       54 37 2 3 1   8     0   3   32 22                 54
937231 937231 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2016   grade_4 24 3 3 0   9     1   3   24 19                       43 24 3 3 0   9     1   3   24 19                 43
937232 937232 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2016   grade_5 41 0 0 1   9     0   9   29 31                       60 41 0 0 1   9     0   9   29 31                 60
1127518 1127518 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   kindergarten 45 3 1 0   11     0   5   29 36                       65 45 3 1 0   11     0   5   29 36                 65
1127519 1127519 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_1 36 0 4 0   12     0   4   33 23                       56 36 0 4 0   12     0   4   33 23                 56
1127520 1127520 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_2 38 2 3 0   8     0   6   26 31                       57 38 2 3 0   8     0   6   26 31                 57
1127521 1127521 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_3 36 6 3 0   10     0   2   27 30                       57 36 6 3 0   10     0   2   27 30                 57
1127522 1127522 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_4 37 1 2 1   10     0   4   31 24                       55 37 1 2 1   10     0   4   31 24                 55
1127523 1127523 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_5 25 4 4 0   10     1   3   30 17                       47 25 4 4 0   10     1   3   30 17                 47
1127524 1127524 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1369455 1369455 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   kindergarten 43 4 3 1   19     0   9   34 45 *                     79.0 43 4 3 1   19     0   9   34 45                 79
1369456 1369456 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_1 36 7 6 1   20     2   4   36 40 *                     76.0 36 7 6 1   20     2   4   36 40                 76
1369457 1369457 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_2 26 4 7 0   15     0   12   33 31 *                     64.0 26 4 7 0   15     0   12   33 31                 64
1369458 1369458 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_3 51 5 6 0   15     0   6   39 44 *                     83.0 51 5 6 0   15     0   6   39 44                 83
1369459 1369459 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_4 38 1 5 0   11     0   6   37 24 *                     61.0 38 1 5 0   11     0   6   37 24                 61
1369460 1369460 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_5 42 3 3 0   17     0   6   37 33 *                     71.0 42 3 3 0   17     0   6   37 33                 71
736743 736743 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   kindergarten 0 18 22 0   0     0   3   27 16                       43 0 18 22 0   0     0   3   27 16                 43
736744 736744 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   pre_kindergarten 2 17 16 0   0     0   2   15 22                       37 2 17 16 0   0     0   2   15 22                 37
736745 736745 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_1 1 31 26 0   0     0   0   24 34                       58 1 31 26 0   0     0   0   24 34                 58
736746 736746 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_2 0 31 27 0   0     0   0   31 27                       58 0 31 27 0   0     0   0   31 27                 58
736747 736747 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_3 1 28 28 0   0     0   1   29 29                       58 1 28 28 0   0     0   1   29 29                 58
736748 736748 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_4 0 27 27 0   0     0   0   26 28                       54 0 27 27 0   0     0   0   26 28                 54
736749 736749 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_5 1 20 24 1   0     0   0   26 20                       46 1 20 24 1   0     0   0   26 20                 46
736750 736750 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_6 2 22 27 0   0     0   1   34 18                       52 2 22 27 0   0     0   1   34 18                 52
736751 736751 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_7 0 33 15 0   0     0   0   33 15                       48 0 33 15 0   0     0   0   33 15                 48
736752 736752 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_8 1 25 23 1   2     0   1   24 29                       53 1 25 23 1   2     0   1   24 29                 53
933612 933612 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   kindergarten 3 23 22 0   0     0   0   22 26                       48 3 23 22 0   0     0   0   22 26                 48
933613 933613 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   pre_kindergarten 1 15 18 0   0     0   0   13 21                       34 1 15 18 0   0     0   0   13 21                 34
933614 933614 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_1 0 22 26 0   0     0   3   31 20                       51 0 22 26 0   0     0   3   31 20                 51
933615 933615 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_2 2 65 45 0   0     0   3   53 62                       115 2 65 45 0   0     0   3   53 62                 115
933616 933616 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_3 0 34 30 0   0     0   0   35 29                       64 0 34 30 0   0     0   0   35 29                 64
933617 933617 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_4 3 33 27 0   0     0   0   33 30                       63 3 33 27 0   0     0   0   33 30                 63
933618 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
933619 933619 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_6 1 20 21 0   0     0   0   25 17                       42 1 20 21 0   0     0   0   25 17                 42
933620 933620 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_7 0 22 24 0   0     0   1   31 16                       47 0 22 24 0   0     0   1   31 16                 47
933621 933621 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_8 0 31 13 0   0     0   0   31 13                       44 0 31 13 0   0     0   0   31 13                 44
1123213 1123213 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   kindergarten 1 25 33 0   0     0   1   30 30                       60 1 25 33 0   0     0   1   30 30                 60
1123214 1123214 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   pre_kindergarten 0 28 23 1   0     0   0   24 28                       52 0 28 23 1   0     0   0   24 28                 52
1123215 1123215 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_1 3 31 29 0   0     0   1   31 33                       64 3 31 29 0   0     0   1   31 33                 64
1123216 1123216 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_2 0 29 31 0   0     0   3   31 32                       63 0 29 31 0   0     0   3   31 32                 63
1123217 1123217 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_3 2 60 35 0   0     0   2   46 53                       99 2 60 35 0   0     0   2   46 53                 99
1123218 1123218 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_4 0 32 27 0   0     0   0   30 29                       59 0 32 27 0   0     0   0   30 29                 59
1123219 1123219 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_5 2 25 20 0   0     0   0   25 22                       47 2 25 20 0   0     0   0   25 22                 47
1123220 1123220 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_6 0 30 15 0   0     0   0   24 21                       45 0 30 15 0   0     0   0   24 21                 45
1123221 1123221 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_7 1 25 23 0   0     0   1   31 19                       50 1 25 23 0   0     0   1   31 19                 50
1123222 1123222 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_8 0 21 21 0   0     0   1   27 16                       43 0 21 21 0   0     0   1   27 16                 43
1123223 1123223 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1365848 1365848 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   kindergarten 0 18 31 0   0     0   2   25 26 *                     51.0 0 18 31 0   0     0   2   25 26                 51
1365849 1365849 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   pre_kindergarten 0 26 18 0   0     0   2   22 24 *                     46.0 0 26 18 0   0     0   2   22 24                 46
1365850 1365850 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_1 0 30 27 0   0     0   0   31 26 *                     57.0 0 30 27 0   0     0   0   31 26                 57
1365851 1365851 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_2 1 22 40 0   0     0   0   37 26 *                     63.0 1 22 40 0   0     0   0   37 26                 63
1365852 1365852 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_3 0 26 31 0   0     0   1   27 31 *                     58.0 0 26 31 0   0     0   1   27 31                 58
1365853 1365853 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_4 1 42 42 0   1     0   1   43 44 *                     87.0 1 42 42 0   1     0   1   43 44                 87
1365854 1365854 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_5 0 40 38 1   0     0   3   45 37 *                     82.0 0 40 38 1   0     0   3   45 37                 82
1365855 1365855 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_6 1 45 26 0   0     0   2   38 36 *                     74.0 1 45 26 0   0     0   2   38 36                 74
1365856 1365856 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_7 0 19 23 0   0     0   0   22 20 *                     42.0 0 19 23 0   0     0   0   22 20                 42
1365857 1365857 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_8 0 19 18 0   0     0   1   23 15 *                     38.0 0 19 18 0   0     0   1   23 15                 38
743077 743077 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2015   kindergarten 32 0 2 0   4     0   0   16 22                       38 32 0 2 0   4     0   0   16 22                 38
743078 743078 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2015   grade_1 13 1 0 0   3     0   0   10 7                       17 13 1 0 0   3     0   0   10 7                 17
743079 743079 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2015   grade_2 27 1 3 1   4     0   0   16 20                       36 27 1 3 1   4     0   0   16 20                 36
743080 743080 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2015   grade_3 27 0 0 0   2     0   0   13 16                       29 27 0 0 0   2     0   0   13 16                 29
743081 743081 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2015   grade_4 27 0 1 0   1     0   0   12 17                       29 27 0 1 0   1     0   0   12 17                 29
743082 743082 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2015   grade_5 35 1 2 0   2     0   0   26 14                       40 35 1 2 0   2     0   0   26 14                 40
939886 939886 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   kindergarten 28 0 2 0   2     0   1   18 15                       33 28 0 2 0   2     0   1   18 15                 33
939887 939887 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_1 30 0 3 0   4     0   0   14 23                       37 30 0 3 0   4     0   0   14 23                 37
939888 939888 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_2 12 1 0 0   4     0   0   10 7                       17 12 1 0 0   4     0   0   10 7                 17
939889 939889 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_3 28 1 3 1   2     0   0   15 20                       35 28 1 3 1   2     0   0   15 20                 35
939890 939890 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_4 27 0 0 0   2     0   0   13 16                       29 27 0 0 0   2     0   0   13 16                 29
939891 939891 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_5 28 0 1 0   1     0   0   12 18                       30 28 0 1 0   1     0   0   12 18                 30
1130704 1130704 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   kindergarten 19 1 3 0   5     0   1   15 14                       29 19 1 3 0   5     0   1   15 14                 29
1130705 1130705 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_1 29 0 2 0   2     0   1   17 17                       34 29 0 2 0   2     0   1   17 17                 34
1130706 1130706 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_2 28 0 4 0   3     0   1   14 22                       36 28 0 4 0   3     0   1   14 22                 36
1130707 1130707 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_3 13 1 0 0   4     0   0   10 8                       18 13 1 0 0   4     0   0   10 8                 18
1130708 1130708 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_4 26 0 4 0   2     0   3   16 19                       35 26 0 4 0   2     0   3   16 19                 35
1130709 1130709 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_5 27 0 0 0   1     0   1   12 17                       29 27 0 0 0   1     0   1   12 17                 29

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