enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2039810 2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
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
2039813 2039813 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   kindergarten 130 10 5 1   6     0   1   79 74                       153.0 130 10 5 1   6     0   1   79 74                 153
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2039817 2039817 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_6 136 1 10 1   2     0   4   80 74                       154.0 136 1 10 1   2     0   4   80 74                 154
2039818 2039818 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_7 170 2 12 0   3     0   0   104 83                       187.0 170 2 12 0   3     0   0   104 83                 187
2039819 2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
2039820 2039820 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_9 134 8 12 0   4     0   1   82 77                       159.0 134 8 12 0   4     0   1   82 77                 159
2039821 2039821 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_10 127 6 13 0   2     0   1   79 70                       149.0 127 6 13 0   2     0   1   79 70                 149
2039822 2039822 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_11 108 3 8 0   4     0   2   56 69                       125.0 108 3 8 0   4     0   2   56 69                 125
2039823 2039823 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_12 90 4 9 0   3     1   0   48 59                       107.0 90 4 9 0   3     1   0   48 59                 107
2039824 2039824 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2039957 2039957 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   kindergarten 61 3 5 0   14     0   9   50 42                       92.0 61 3 5 0   14     0   9   50 42                 92
2039958 2039958 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_1 41 4 0 0   14     0   8   40 27                       67.0 41 4 0 0   14     0   8   40 27                 67
2039959 2039959 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_2 54 4 2 0   14     0   1   44 31                       75.0 54 4 2 0   14     0   1   44 31                 75
2039960 2039960 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_3 52 0 1 0   15     2   5   37 38                       75.0 52 0 1 0   15     2   5   37 38                 75
2039961 2039961 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_4 51 3 2 0   11     0   5   42 30                       72.0 51 3 2 0   11     0   5   42 30                 72
2039962 2039962 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_5 54 3 3 0   7     0   4   35 36                       71.0 54 3 3 0   7     0   4   35 36                 71
2039963 2039963 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   kindergarten 77 0 4 0   7     0   13   54 47                       101.0 77 0 4 0   7     0   13   54 47                 101
2039964 2039964 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_1 61 0 1 0   9     0   9   42 38                       80.0 61 0 1 0   9     0   9   42 38                 80
2039965 2039965 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_2 69 2 3 0   16     0   4   52 42                       94.0 69 2 3 0   16     0   4   52 42                 94
2039966 2039966 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_3 52 0 3 0   5     0   4   31 33                       64.0 52 0 3 0   5     0   4   31 33                 64
2039967 2039967 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_4 69 2 8 0   8     1   9   53 44                       97.0 69 2 8 0   8     1   9   53 44                 97
2039968 2039968 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_5 63 2 4 0   5     0   7   42 39                       81.0 63 2 4 0   5     0   7   42 39                 81
2039969 2039969 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   kindergarten 57 2 4 0   11     0   9   42 41                       83.0 57 2 4 0   11     0   9   42 41                 83
2039970 2039970 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_1 57 0 3 0   7     0   5   41 31                       72.0 57 0 3 0   7     0   5   41 31                 72
2039971 2039971 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_2 67 1 2 0   19     0   1   49 41                       90.0 67 1 2 0   19     0   1   49 41                 90
2039972 2039972 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_3 58 1 2 0   8     0   2   34 37                       71.0 58 1 2 0   8     0   2   34 37                 71
2039973 2039973 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_4 61 1 4 0   9     0   5   40 40                       80.0 61 1 4 0   9     0   5   40 40                 80
2039974 2039974 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_5 67 4 7 0   6     0   4   43 45                       88.0 67 4 7 0   6     0   4   43 45                 88
2039975 2039975 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   kindergarten 59 2 3 0   11     0   5   48 32                       80.0 59 2 3 0   11     0   5   48 32                 80
2039976 2039976 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_1 51 4 4 0   12     0   8   36 43                       79.0 51 4 4 0   12     0   8   36 43                 79
2039977 2039977 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_2 62 1 7 0   16     0   0   48 38                       86.0 62 1 7 0   16     0   0   48 38                 86
2039978 2039978 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_3 51 4 4 0   11     1   3   43 31                       74.0 51 4 4 0   11     1   3   43 31                 74
2039979 2039979 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_4 45 5 4 1   11     0   3   40 29                       69.0 45 5 4 1   11     0   3   40 29                 69
2039980 2039980 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_5 42 7 4 0   6     0   4   32 31                       63.0 42 7 4 0   6     0   4   32 31                 63
2039981 2039981 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 52 5 8 0   23     0   8   65 31                       96.0 52 5 8 0   23     0   8   65 31                 96
2039982 2039982 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   kindergarten 36 2 8 0   12     0   3   29 32                       61.0 36 2 8 0   12     0   3   29 32                 61
2039983 2039983 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_1 43 4 6 0   8     0   7   34 34                       68.0 43 4 6 0   8     0   7   34 34                 68
2039984 2039984 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_2 31 1 0 0   9     0   1   26 16                       42.0 31 1 0 0   9     0   1   26 16                 42
2039985 2039985 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_3 33 2 2 0   6     0   2   18 27                       45.0 33 2 2 0   6     0   2   18 27                 45
2039986 2039986 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_4 25 4 5 0   5     0   4   18 25                       43.0 25 4 5 0   5     0   4   18 25                 43
2039987 2039987 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_5 42 1 5 0   1     0   0   31 18                       49.0 42 1 5 0   1     0   0   31 18                 49
2039988 2039988 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   kindergarten 53 3 9 0   11     0   13   50 39                       89.0 53 3 9 0   11     0   13   50 39                 89
2039989 2039989 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_1 50 1 10 0   11     0   6   35 43                       78.0 50 1 10 0   11     0   6   35 43                 78
2039990 2039990 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_2 60 6 12 1   14     0   0   40 53                       93.0 60 6 12 1   14     0   0   40 53                 93
2039991 2039991 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_3 60 5 7 0   10     0   6   45 43                       88.0 60 5 7 0   10     0   6   45 43                 88
2039992 2039992 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_4 52 5 5 1   14     0   7   44 40                       84.0 52 5 5 1   14     0   7   44 40                 84
2039993 2039993 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_5 42 4 13 0   12     0   4   38 37                       75.0 42 4 13 0   12     0   4   38 37                 75
2039994 2039994 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   kindergarten 46 3 4 0   20     0   8   45 36                       81.0 46 3 4 0   20     0   8   45 36                 81
2039995 2039995 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_1 56 1 3 0   6     0   10   36 40                       76.0 56 1 3 0   6     0   10   36 40                 76
2039996 2039996 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_2 41 2 4 0   23     0   1   41 30                       71.0 41 2 4 0   23     0   1   41 30                 71
2039997 2039997 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_3 47 4 6 0   9     0   7   32 41                       73.0 47 4 6 0   9     0   7   32 41                 73
2039998 2039998 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_4 48 2 4 0   6     0   3   31 32                       63.0 48 2 4 0   6     0   3   31 32                 63
2039999 2039999 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_5 46 2 2 0   6     0   6   32 30                       62.0 46 2 2 0   6     0   6   32 30                 62
2040000 2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
2040001 2040001 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_7 329 10 29 0   52     2   19   205 236                       441.0 329 10 29 0   52     2   19   205 236                 441
2040002 2040002 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_8 301 18 21 0   42     0   32   184 230                       414.0 301 18 21 0   42     0   32   184 230                 414
2040003 2040003 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_9 270 15 18 0   39     0   22   175 189                       364.0 270 15 18 0   39     0   22   175 189                 364
2040004 2040004 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_10 258 12 24 0   36     0   14   170 173                       344.0 258 12 24 0   36     0   14   170 173                 344
2040005 2040005 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_11 249 11 24 0   35     1   8   172 154                       328.0 249 11 24 0   35     1   8   172 154                 328
2040006 2040006 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_12 245 13 21 0   46     0   19   156 188                       344.0 245 13 21 0   46     0   19   156 188                 344
2042396 2042396 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 145 17 69 0   32     1   12   159 117                       276.0 145 17 69 0   32     1   12   159 117                 276
2042397 2042397 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   kindergarten 43 2 6 0   9     0   6   33 33                       66.0 43 2 6 0   9     0   6   33 33                 66
2042398 2042398 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_1 41 1 4 0   5     0   7   31 27                       58.0 41 1 4 0   5     0   7   31 27                 58
2042399 2042399 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_2 45 6 2 0   8     0   5   38 28                       66.0 45 6 2 0   8     0   5   38 28                 66
2042400 2042400 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_3 45 2 14 0   6     0   6   36 37                       73.0 45 2 14 0   6     0   6   36 37                 73
2042401 2042401 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_4 41 2 10 0   3     0   4   35 25                       60.0 41 2 10 0   3     0   4   35 25                 60
2042402 2042402 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   kindergarten 32 5 33 0   7     0   3   37 43                       80.0 32 5 33 0   7     0   3   37 43                 80
2042403 2042403 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_1 21 5 34 0   3     0   2   32 33                       65.0 21 5 34 0   3     0   2   32 33                 65
2042404 2042404 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_2 19 6 30 0   1     0   2   27 31                       58.0 19 6 30 0   1     0   2   27 31                 58
2042405 2042405 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_3 25 7 42 0   2     0   1   37 40                       77.0 25 7 42 0   2     0   1   37 40                 77
2042406 2042406 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_4 24 4 47 0   4     0   0   45 34                       79.0 24 4 47 0   4     0   0   45 34                 79
2042407 2042407 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_5 34 8 55 0   6     0   2   56 49                       105.0 34 8 55 0   6     0   2   56 49                 105
2042408 2042408 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   kindergarten 52 11 13 0   5     0   5   44 42                       86.0 52 11 13 0   5     0   5   44 42                 86
2042409 2042409 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_1 47 4 6 0   5     0   1   38 25                       63.0 47 4 6 0   5     0   1   38 25                 63
2042410 2042410 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_2 43 10 8 0   11     0   2   48 26                       74.0 43 10 8 0   11     0   2   48 26                 74
2042411 2042411 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_3 50 6 3 0   8     0   1   34 34                       68.0 50 6 3 0   8     0   1   34 34                 68
2042412 2042412 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_4 46 4 9 0   12     0   0   29 42                       71.0 46 4 9 0   12     0   0   29 42                 71
2042413 2042413 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_5 66 3 10 0   14     0   2   50 45                       95.0 66 3 10 0   14     0   2   50 45                 95
2042414 2042414 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   kindergarten 63 3 14 0   11     0   12   56 47                       103.0 63 3 14 0   11     0   12   56 47                 103
2042415 2042415 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_1 48 10 13 0   7     0   8   40 46                       86.0 48 10 13 0   7     0   8   40 46                 86
2042416 2042416 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_2 61 6 13 1   8     1   2   45 47                       92.0 61 6 13 1   8     1   2   45 47                 92
2042417 2042417 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_3 63 3 9 0   8     0   8   43 48                       91.0 63 3 9 0   8     0   8   43 48                 91
2042418 2042418 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_4 70 5 6 0   10     0   3   54 40                       94.0 70 5 6 0   10     0   3   54 40                 94
2042419 2042419 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_5 72 3 9 0   8     0   5   46 51                       97.0 72 3 9 0   8     0   5   46 51                 97
2042420 2042420 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   kindergarten 17 5 93 0   0     0   6   53 68                       121.0 17 5 93 0   0     0   6   53 68                 121
2042421 2042421 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_1 19 3 93 0   1     0   4   49 71                       120.0 19 3 93 0   1     0   4   49 71                 120
2042422 2042422 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_2 19 7 74 0   0     0   4   46 58                       104.0 19 7 74 0   0     0   4   46 58                 104
2042423 2042423 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_3 20 3 82 0   0     0   5   55 55                       110.0 20 3 82 0   0     0   5   55 55                 110
2042424 2042424 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_4 36 4 79 0   1     0   2   50 72                       122.0 36 4 79 0   1     0   2   50 72                 122
2042425 2042425 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_5 25 3 63 1   2     0   1   48 47                       95.0 25 3 63 1   2     0   1   48 47                 95
2042426 2042426 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   kindergarten 67 6 9 0   1     0   4   48 39                       87.0 67 6 9 0   1     0   4   48 39                 87
2042427 2042427 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_1 58 11 8 0   3     0   6   39 47                       86.0 58 11 8 0   3     0   6   39 47                 86
2042428 2042428 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_2 57 11 5 0   6     1   8   46 42                       88.0 57 11 5 0   6     1   8   46 42                 88
2042429 2042429 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_3 70 6 9 0   5     0   2   48 44                       92.0 70 6 9 0   5     0   2   48 44                 92
2042430 2042430 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_4 65 7 7 0   4     0   3   39 47                       86.0 65 7 7 0   4     0   3   39 47                 86

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