enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2047730 2047730 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   kindergarten 18 55 35 2   2     0   5   55 62                       117.0 18 55 35 2   2     0   5   55 62                 117
2047731 2047731 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_1 16 55 30 1   5     0   7   40 74                       114.0 16 55 30 1   5     0   7   40 74                 114
2047732 2047732 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_2 25 53 34 0   4     0   0   53 63                       116.0 25 53 34 0   4     0   0   53 63                 116
2047733 2047733 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_3 28 62 21 0   2     0   5   57 61                       118.0 28 62 21 0   2     0   5   57 61                 118
2047734 2047734 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_4 23 65 19 0   3     0   6   64 52                       116.0 23 65 19 0   3     0   6   64 52                 116
2047735 2047735 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_5 14 78 22 0   4     0   0   52 66                       118.0 14 78 22 0   4     0   0   52 66                 118
2047736 2047736 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_6 22 63 34 0   1     0   0   57 63                       120.0 22 63 34 0   1     0   0   57 63                 120
2047737 2047737 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_7 29 63 17 0   3     1   1   57 57                       114.0 29 63 17 0   3     1   1   57 57                 114
2047738 2047738 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_8 25 61 25 0   3     0   6   64 56                       120.0 25 61 25 0   3     0   6   64 56                 120
2047739 2047739 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_9 19 59 25 0   6     0   0   51 58                       109.0 19 59 25 0   6     0   0   51 58                 109
2047740 2047740 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_10 16 47 26 0   6     0   1   39 57                       96.0 16 47 26 0   6     0   1   39 57                 96
2047741 2047741 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_11 24 36 20 0   5     0   2   41 46                       87.0 24 36 20 0   5     0   2   41 46                 87
2047742 2047742 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_12 23 35 16 0   5     1   3   48 35                       83.0 23 35 16 0   5     1   3   48 35                 83
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
2047541 2047541 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
2047542 2047542 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_6 10 43 24 0   1     0   2   39 41                       80.0 10 43 24 0   1     0   2   39 41                 80
2047543 2047543 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_7 5 43 25 0   1     0   1   34 41                       75.0 5 43 25 0   1     0   1   34 41                 75
2047544 2047544 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_8 3 43 23 0   0     0   4   34 39                       73.0 3 43 23 0   0     0   4   34 39                 73
2047545 2047545 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_9 10 43 17 0   1     0   0   37 34                       71.0 10 43 17 0   1     0   0   37 34                 71
2047546 2047546 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_10 3 47 19 0   1     0   0   36 34                       70.0 3 47 19 0   1     0   0   36 34                 70
2047547 2047547 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_11 6 29 10 0   1     0   1   22 25                       47.0 6 29 10 0   1     0   1   22 25                 47
2047548 2047548 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_12 2 21 10 0   1     1   3   19 19                       38.0 2 21 10 0   1     1   3   19 19                 38
2048052 2048052 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 45 6 8 0   36     0   10   57 48                       105.0 45 6 8 0   36     0   10   57 48                 105
2048053 2048053 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   kindergarten 44 0 6 0   17     0   3   29 41                       70.0 44 0 6 0   17     0   3   29 41                 70
2048054 2048054 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_1 51 0 6 0   25     0   4   40 46                       86.0 51 0 6 0   25     0   4   40 46                 86
2048055 2048055 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_2 40 0 3 0   17     0   1   30 31                       61.0 40 0 3 0   17     0   1   30 31                 61
2048056 2048056 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_3 38 1 1 0   25     0   3   37 31                       68.0 38 1 1 0   25     0   3   37 31                 68
2048057 2048057 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_4 35 1 2 0   20     0   1   35 24                       59.0 35 1 2 0   20     0   1   35 24                 59
2048058 2048058 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_5 30 1 2 0   18     0   1   17 35                       52.0 30 1 2 0   18     0   1   17 35                 52
2048059 2048059 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_6 34 3 3 2   24     0   2   35 33                       68.0 34 3 3 2   24     0   2   35 33                 68
2048060 2048060 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   kindergarten 40 0 3 0   9     0   7   25 34                       59.0 40 0 3 0   9     0   7   25 34                 59
2048061 2048061 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_1 38 1 7 0   13     0   3   36 26                       62.0 38 1 7 0   13     0   3   36 26                 62
2048062 2048062 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_2 47 1 4 0   7     0   3   27 35                       62.0 47 1 4 0   7     0   3   27 35                 62
2048063 2048063 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_3 51 1 2 0   13     0   3   38 32                       70.0 51 1 2 0   13     0   3   38 32                 70
2048064 2048064 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_4 48 1 5 0   16     0   1   38 33                       71.0 48 1 5 0   16     0   1   38 33                 71
2048065 2048065 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_5 55 3 3 0   33     1   1   51 45                       96.0 55 3 3 0   33     1   1   51 45                 96
2048066 2048066 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_6 48 3 8 0   12     0   1   37 35                       72.0 48 3 8 0   12     0   1   37 35                 72
2048067 2048067 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   kindergarten 44 3 5 0   5     0   5   34 28                       62.0 44 3 5 0   5     0   5   34 28                 62
2048068 2048068 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_1 51 2 7 0   12     0   3   40 35                       75.0 51 2 7 0   12     0   3   40 35                 75
2048069 2048069 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_2 47 1 5 0   5     0   8   36 30                       66.0 47 1 5 0   5     0   8   36 30                 66
2048070 2048070 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_3 50 1 2 0   13     0   4   30 40                       70.0 50 1 2 0   13     0   4   30 40                 70
2048071 2048071 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_4 48 4 14 2   12     0   4   39 45                       84.0 48 4 14 2   12     0   4   39 45                 84
2048072 2048072 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_5 58 3 11 0   9     0   8   43 46                       89.0 58 3 11 0   9     0   8   43 46                 89
2048073 2048073 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_6 51 4 8 0   8     0   3   41 33                       74.0 51 4 8 0   8     0   3   41 33                 74
2048074 2048074 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   kindergarten 29 2 0 0   5     0   5   24 17                       41.0 29 2 0 0   5     0   5   24 17                 41
2048075 2048075 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_1 27 1 1 0   6     0   7   24 18                       42.0 27 1 1 0   6     0   7   24 18                 42
2048076 2048076 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_2 33 0 2 0   6     0   2   17 26                       43.0 33 0 2 0   6     0   2   17 26                 43
2048077 2048077 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_3 47 2 0 0   15     0   5   35 34                       69.0 47 2 0 0   15     0   5   35 34                 69
2048078 2048078 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_4 48 0 0 0   15     1   5   40 29                       69.0 48 0 0 0   15     1   5   40 29                 69
2048079 2048079 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_5 43 0 4 1   19     0   2   35 34                       69.0 43 0 4 1   19     0   2   35 34                 69
2048080 2048080 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_6 46 1 2 0   17     1   5   40 32                       72.0 46 1 2 0   17     1   5   40 32                 72
2048081 2048081 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   kindergarten 15 1 2 0   19     0   2   24 15                       39.0 15 1 2 0   19     0   2   24 15                 39
2048082 2048082 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_1 13 2 0 0   24     0   3   25 17                       42.0 13 2 0 0   24     0   3   25 17                 42
2048083 2048083 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_2 22 0 7 0   30     0   2   31 30                       61.0 22 0 7 0   30     0   2   31 30                 61
2048084 2048084 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_3 14 4 3 0   49     0   0   45 25                       70.0 14 4 3 0   49     0   0   45 25                 70
2048085 2048085 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_4 22 1 3 1   39     0   1   33 34                       67.0 22 1 3 1   39     0   1   33 34                 67
2048086 2048086 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_5 17 1 4 0   26     0   1   24 25                       49.0 17 1 4 0   26     0   1   24 25                 49
2048087 2048087 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_6 21 2 0 1   22     0   2   24 24                       48.0 21 2 0 1   22     0   2   24 24                 48
2048088 2048088 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   kindergarten 16 2 3 0   37     0   1   35 24                       59.0 16 2 3 0   37     0   1   35 24                 59
2048089 2048089 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_1 11 0 9 0   39     0   5   36 28                       64.0 11 0 9 0   39     0   5   36 28                 64
2048090 2048090 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_2 19 2 4 0   35     0   2   26 36                       62.0 19 2 4 0   35     0   2   26 36                 62
2048091 2048091 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_3 13 1 3 0   28     0   1   28 18                       46.0 13 1 3 0   28     0   1   28 18                 46
2048092 2048092 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_4 14 2 2 0   30     0   2   27 23                       50.0 14 2 2 0   30     0   2   27 23                 50
2048093 2048093 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_5 21 4 3 0   43     0   3   36 38                       74.0 21 4 3 0   43     0   3   36 38                 74
2048094 2048094 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_6 18 1 8 0   64     1   2   43 51                       94.0 18 1 8 0   64     1   2   43 51                 94
2048095 2048095 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_7 231 10 25 2   149     0   18   239 196                       435.0 231 10 25 2   149     0   18   239 196                 435
2048096 2048096 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_8 265 17 18 1   174     0   13   262 226                       488.0 265 17 18 1   174     0   13   262 226                 488
2048097 2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
2048098 2048098 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_10 243 8 11 1   143     0   23   223 206                       429.0 243 8 11 1   143     0   23   223 206                 429
2048099 2048099 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_11 259 10 16 2   140     0   18   225 220                       445.0 259 10 16 2   140     0   18   225 220                 445
2048100 2048100 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_12 294 9 21 0   159     0   17   271 229                       500.0 294 9 21 0   159     0   17   271 229                 500
2048101 2048101 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2039825 2039825 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten 44 0 1 0   0     0   1   22 24                       46.0 44 0 1 0   0     0   1   22 24                 46
2039826 2039826 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   kindergarten 113 0 2 0   1     0   5   60 61                       121.0 113 0 2 0   1     0   5   60 61                 121
2039827 2039827 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_1 95 3 4 0   1     0   2   55 50                       105.0 95 3 4 0   1     0   2   55 50                 105
2039828 2039828 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_2 71 1 4 1   0     0   3   40 40                       80.0 71 1 4 1   0     0   3   40 40                 80
2039829 2039829 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_3 98 0 5 0   0     0   6   57 52                       109.0 98 0 5 0   0     0   6   57 52                 109
2039830 2039830 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_4 95 0 7 0   0     0   2   48 56                       104.0 95 0 7 0   0     0   2   48 56                 104
2039831 2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2039832 2039832 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_6 94 0 5 0   1     0   5   57 48                       105.0 94 0 5 0   1     0   5   57 48                 105
2039833 2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2039834 2039834 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_8 108 1 1 0   0     0   1   52 59                       111.0 108 1 1 0   0     0   1   52 59                 111
2048102 2048102 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten 57 1 2 0   2     0   0   33 29                       62.0 57 1 2 0   2     0   0   33 29                 62
2048103 2048103 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   kindergarten 73 1 1 0   0     0   4   37 42                       79.0 73 1 1 0   0     0   4   37 42                 79
2048104 2048104 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   grade_1 71 2 2 0   0     0   3   45 33                       78.0 71 2 2 0   0     0   3   45 33                 78
2048105 2048105 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   grade_2 70 3 3 0   0     0   4   48 32                       80.0 70 3 3 0   0     0   4   48 32                 80

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