enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1364785 1364785 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_3 135 6 21 0   2     1   0   81 84 *                     165.0 135 6 21 0   2     1   0   81 84                 165
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
1364787 1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1364792 1364792 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_7 139 3 12 1   4     0   5   86 78 *                     164.0 139 3 12 1   4     0   5   86 78                 164
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1364795 1364795 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_10 127 10 12 0   4     0   3   80 76 *                     156.0 127 10 12 0   4     0   3   80 76                 156
1364796 1364796 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_11 127 8 15 0   3     0   1   80 74 *                     154.0 127 8 15 0   3     0   1   80 74                 154
1364797 1364797 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_12 102 3 6 0   4     0   2   55 62 *                     117.0 102 3 6 0   4     0   2   55 62                 117
1364798 1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1364930 1364930 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   kindergarten 44 3 3 0   8     0   13   35 36 *                     71.0 44 3 3 0   8     0   13   35 36                 71
1364931 1364931 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_1 61 1 7 0   14     0   10   50 43 *                     93.0 61 1 7 0   14     0   10   50 43                 93
1364932 1364932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_2 40 4 0 0   16     0   7   39 28 *                     67.0 40 4 0 0   16     0   7   39 28                 67
1364933 1364933 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_3 53 3 2 0   11     0   1   41 29 *                     70.0 53 3 2 0   11     0   1   41 29                 70
1364934 1364934 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_4 46 0 2 0   14     2   6   33 37 *                     70.0 46 0 2 0   14     2   6   33 37                 70
1364935 1364935 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_5 51 2 1 0   10     0   5   41 28 *                     69.0 51 2 1 0   10     0   5   41 28                 69
1364936 1364936 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   kindergarten 59 1 5 0   13     0   9   51 36 *                     87.0 59 1 5 0   13     0   9   51 36                 87
1364937 1364937 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_1 82 0 4 0   7     0   13   59 47 *                     106.0 82 0 4 0   7     0   13   59 47                 106
1364938 1364938 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_2 62 1 1 0   9     0   9   43 39 *                     82.0 62 1 1 0   9     0   9   43 39                 82
1364939 1364939 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_3 67 3 3 0   15     0   5   52 41 *                     93.0 67 3 3 0   15     0   5   52 41                 93
1364940 1364940 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_4 55 0 3 0   5     0   4   31 36 *                     67.0 55 0 3 0   5     0   4   31 36                 67
1364941 1364941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_5 71 2 8 0   9     1   9   55 45 *                     100.0 71 2 8 0   9     1   9   55 45                 100
1364942 1364942 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   kindergarten 47 0 4 0   10     0   9   28 42 *                     70.0 47 0 4 0   10     0   9   28 42                 70
1364943 1364943 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_1 59 3 5 0   11     0   9   45 42 *                     87.0 59 3 5 0   11     0   9   45 42                 87
1364944 1364944 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_2 60 1 3 0   7     0   4   41 34 *                     75.0 60 1 3 0   7     0   4   41 34                 75
1364945 1364945 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_3 66 1 0 0   19     0   1   49 38 *                     87.0 66 1 0 0   19     0   1   49 38                 87
1364946 1364946 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_4 60 1 2 0   8     0   1   35 37 *                     72.0 60 1 2 0   8     0   1   35 37                 72
1364947 1364947 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_5 60 1 4 0   10     0   6   42 39 *                     81.0 60 1 4 0   10     0   6   42 39                 81
1364948 1364948 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   kindergarten 47 0 4 0   11     0   6   34 34 *                     68.0 47 0 4 0   11     0   6   34 34                 68
1364949 1364949 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_1 54 2 2 0   11     0   6   41 34 *                     75.0 54 2 2 0   11     0   6   41 34                 75
1364950 1364950 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_2 49 3 5 0   12     0   10   33 46 *                     79.0 49 3 5 0   12     0   10   33 46                 79
1364951 1364951 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_3 59 0 6 0   13     0   0   41 37 *                     78.0 59 0 6 0   13     0   0   41 37                 78
1364952 1364952 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_4 51 4 4 0   11     0   5   44 31 *                     75.0 51 4 4 0   11     0   5   44 31                 75
1364953 1364953 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_5 46 5 4 1   11     0   2   39 30 *                     69.0 46 5 4 1   11     0   2   39 30                 69
1364954 1364954 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 51 4 3 0   20     0   11   56 33 *                     89.0 51 4 3 0   20     0   11   56 33                 89
1364955 1364955 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   kindergarten 38 2 2 1   9     0   5   27 30 *                     57.0 38 2 2 1   9     0   5   27 30                 57
1364956 1364956 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_1 30 3 8 0   13     0   3   25 32 *                     57.0 30 3 8 0   13     0   3   25 32                 57
1364957 1364957 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_2 43 4 4 0   7     0   7   34 31 *                     65.0 43 4 4 0   7     0   7   34 31                 65
1364958 1364958 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_3 30 1 0 0   8     0   1   27 13 *                     40.0 30 1 0 0   8     0   1   27 13                 40
1364959 1364959 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_4 31 2 2 0   6     0   1   16 26 *                     42.0 31 2 2 0   6     0   1   16 26                 42
1364960 1364960 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_5 27 5 5 0   5     0   4   20 26 *                     46.0 27 5 5 0   5     0   4   20 26                 46
1364961 1364961 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   kindergarten 54 2 4 0   16     0   11   39 48 *                     87.0 54 2 4 0   16     0   11   39 48                 87
1364962 1364962 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_1 55 4 9 0   12     0   12   51 41 *                     92.0 55 4 9 0   12     0   12   51 41                 92
1364963 1364963 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_2 50 1 8 0   9     0   4   32 39 *                     72.0 50 1 8 0   9     0   4   32 39                 72
1364964 1364964 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_3 58 5 14 1   14     0   1   40 53 *                     93.0 58 5 14 1   14     0   1   40 53                 93
1364965 1364965 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_4 60 6 6 0   12     0   6   48 42 *                     90.0 60 6 6 0   12     0   6   48 42                 90
1364966 1364966 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_5 48 4 5 1   16     0   6   41 39 *                     80.0 48 4 5 1   16     0   6   41 39                 80
1364967 1364967 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   kindergarten 41 4 9 0   16     0   14   39 45 *                     84.0 41 4 9 0   16     0   14   39 45                 84
1364968 1364968 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_1 48 2 4 0   22     0   8   47 37 *                     84.0 48 2 4 0   22     0   8   47 37                 84
1364969 1364969 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_2 57 1 3 0   7     0   9   36 41 *                     77.0 57 1 3 0   7     0   9   36 41                 77
1364970 1364970 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_3 42 2 3 0   24     0   1   42 30 *                     72.0 42 2 3 0   24     0   1   42 30                 72
1364971 1364971 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_4 47 4 5 0   9     0   6   32 39 *                     71.0 47 4 5 0   9     0   6   32 39                 71
1364972 1364972 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_5 47 2 5 0   5     0   3   30 32 *                     62.0 47 2 5 0   5     0   3   30 32                 62
1364973 1364973 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2020   grade_6 356 20 40 0   40     0   30   255 231 *                     486.0 356 20 40 0   40     0   30   255 231                 486
1364974 1364974 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_7 321 15 33 1   53     1   31   247 207 *                     455.0 321 15 33 1   53     1   31   247 207                 455
1364975 1364975 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_8 328 12 31 0   51     1   21   203 240 *                     444.0 328 12 31 0   51     1   21   203 240                 444
1364976 1364976 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_9 272 17 20 0   36     0   23   162 205 *                     368.0 272 17 20 0   36     0   23   162 205                 368
1364977 1364977 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_10 269 16 19 0   38     0   22   172 192 *                     364.0 269 16 19 0   38     0   22   172 192                 364
1364978 1364978 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_11 252 11 23 0   41     0   15   169 172 *                     342.0 252 11 23 0   41     0   15   169 172                 342
1364979 1364979 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_12 260 13 22 0   33     1   8   182 153 *                     337.0 260 13 22 0   33     1   8   182 153                 337
1367324 1367324 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 176 18 75 1   30     1   8   197 112 *                     309.0 176 18 75 1   30     1   8   197 112                 309
1367325 1367325 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   kindergarten 41 3 6 0   10     0   5   35 30 *                     65.0 41 3 6 0   10     0   5   35 30                 65
1367326 1367326 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_1 46 3 11 0   10     0   7   37 40 *                     77.0 46 3 11 0   10     0   7   37 40                 77
1367327 1367327 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_2 44 3 6 0   6     0   6   33 32 *                     65.0 44 3 6 0   6     0   6   33 32                 65
1367328 1367328 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_3 51 5 5 0   6     0   5   43 29 *                     72.0 51 5 5 0   6     0   5   43 29                 72
1367329 1367329 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_4 43 2 14 0   6     0   2   32 35 *                     67.0 43 2 14 0   6     0   2   32 35                 67
1367330 1367330 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_5 43 4 20 0   2     0   4   40 33 *                     73.0 43 4 20 0   2     0   4   40 33                 73
1367331 1367331 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   kindergarten 25 4 45 0   2     0   4   40 40 *                     80.0 25 4 45 0   2     0   4   40 40                 80
1367332 1367332 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_1 26 6 42 1   6     0   6   43 44 *                     87.0 26 6 42 1   6     0   6   43 44                 87
1367333 1367333 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_2 16 5 41 0   1     0   2   33 32 *                     65.0 16 5 41 0   1     0   2   33 32                 65
1367334 1367334 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_3 20 4 44 0   1     0   2   33 38 *                     71.0 20 4 44 0   1     0   2   33 38                 71
1367335 1367335 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_4 21 8 48 0   3     0   2   36 46 *                     82.0 21 8 48 0   3     0   2   36 46                 82
1367336 1367336 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_5 23 2 57 0   3     0   0   46 39 *                     85.0 23 2 57 0   3     0   0   46 39                 85
1367337 1367337 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   kindergarten 35 3 14 0   5     0   6   30 33 *                     63.0 35 3 14 0   5     0   6   30 33                 63
1367338 1367338 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_1 57 10 21 0   3     0   5   48 48 *                     96.0 57 10 21 0   3     0   5   48 48                 96
1367339 1367339 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_2 45 4 6 0   5     0   1   37 24 *                     61.0 45 4 6 0   5     0   1   37 24                 61
1367340 1367340 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_3 46 9 8 0   10     0   2   47 28 *                     75.0 46 9 8 0   10     0   2   47 28                 75
1367341 1367341 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_4 51 3 6 0   8     0   1   33 36 *                     69.0 51 3 6 0   8     0   1   33 36                 69
1367342 1367342 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_5 46 4 11 0   11     0   0   31 41 *                     72.0 46 4 11 0   11     0   0   31 41                 72
1367343 1367343 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   kindergarten 42 5 27 0   11     0   4   45 44 *                     89.0 42 5 27 0   11     0   4   45 44                 89
1367344 1367344 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_1 59 4 12 0   10     0   12   52 45 *                     97.0 59 4 12 0   10     0   12   52 45                 97
1367345 1367345 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_2 47 12 16 0   5     0   9   44 45 *                     89.0 47 12 16 0   5     0   9   44 45                 89
1367346 1367346 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_3 59 7 9 1   4     0   4   37 47 *                     84.0 59 7 9 1   4     0   4   37 47                 84
1367347 1367347 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_4 61 4 12 0   8     0   8   43 50 *                     93.0 61 4 12 0   8     0   8   43 50                 93
1367348 1367348 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_5 69 6 6 0   10     0   3   52 42 *                     94.0 69 6 6 0   10     0   3   52 42                 94
1367349 1367349 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   kindergarten 17 0 93 0   2     0   6   53 65 *                     118.0 17 0 93 0   2     0   6   53 65                 118
1367350 1367350 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_1 15 4 97 0   0     0   6   51 71 *                     122.0 15 4 97 0   0     0   6   51 71                 122
1367351 1367351 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_2 19 4 94 0   0     0   4   47 74 *                     121.0 19 4 94 0   0     0   4   47 74                 121
1367352 1367352 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_3 19 6 80 0   0     0   4   55 54 *                     109.0 19 6 80 0   0     0   4   55 54                 109
1367353 1367353 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_4 19 3 80 0   0     0   5   53 53 *                     107.0 19 3 80 0   0     0   5   53 53                 107
1367354 1367354 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_5 34 4 72 0   1     0   2   47 66 *                     113.0 34 4 72 0   1     0   2   47 66                 113
1367355 1367355 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   kindergarten 37 5 35 0   3     0   5   38 47 *                     85.0 37 5 35 0   3     0   5   38 47                 85
1367356 1367356 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_1 68 6 12 0   1     0   4   52 39 *                     91.0 68 6 12 0   1     0   4   52 39                 91
1367357 1367357 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_2 57 10 11 0   3     0   6   39 48 *                     87.0 57 10 11 0   3     0   6   39 48                 87
1367358 1367358 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_3 58 13 7 0   5     1   8   49 43 *                     92.0 58 13 7 0   5     1   8   49 43                 92

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