enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1131326 1131326 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 2017   kindergarten 25 52 34 0   5     0   0   56 60                       116 25 52 34 0   5     0   0   56 60                 116
1131327 1131327 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 2017   grade_1 31 55 20 0   2     0   5   54 59                       113 31 55 20 0   2     0   5   54 59                 113
1131328 1131328 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 2017   grade_2 27 62 18 0   3     0   8   63 55                       118 27 62 18 0   3     0   8   63 55                 118
1131329 1131329 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 2017   grade_3 14 81 24 0   3     0   0   52 70                       122 14 81 24 0   3     0   0   52 70                 122
1131330 1131330 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 2017   grade_4 20 63 34 0   2     0   0   57 62                       119 20 63 34 0   2     0   0   57 62                 119
1131331 1131331 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 2017   grade_5 30 61 19 0   5     1   2   57 61                       118 30 61 19 0   5     1   2   57 61                 118
1131332 1131332 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 2017   grade_6 29 63 26 0   3     0   6   65 62                       127 29 63 26 0   3     0   6   65 62                 127
1131333 1131333 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 2017   grade_7 23 63 28 0   7     0   0   55 66                       121 23 63 28 0   7     0   0   55 66                 121
1131334 1131334 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 2017   grade_8 23 50 32 1   7     0   2   51 64                       115 23 50 32 1   7     0   2   51 64                 115
1131335 1131335 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 2017   grade_9 27 41 20 0   5     0   3   48 48                       96 27 41 20 0   5     0   3   48 48                 96
1131336 1131336 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 2017   grade_10 24 36 17 0   5     1   3   51 35                       86 24 36 17 0   5     1   3   51 35                 86
1131337 1131337 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 2017   grade_11 23 35 27 0   6     0   2   32 61                       93 23 35 27 0   6     0   2   32 61                 93
1131338 1131338 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 2017   grade_12 31 29 15 0   4     0   2   33 48                       81 31 29 15 0   4     0   2   33 48                 81
1131339 1131339 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 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121946 1121946 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   kindergarten 115 5 12 0   2     0   0   73 61                       134 115 5 12 0   2     0   0   73 61                 134
1121947 1121947 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten 57 3 5 0   4     0   0   37 32                       69 57 3 5 0   4     0   0   37 32                 69
1121948 1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121949 1121949 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_1 109 1 10 1   3     1   0   52 73                       125 109 1 10 1   3     1   0   52 73                 125
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1121951 1121951 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_3 127 5 11 1   3     0   1   77 71                       148 127 5 11 1   3     0   1   77 71                 148
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1121953 1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121954 1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1121956 1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121957 1121957 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_7 142 2 9 0   5     0   1   84 75                       159 142 2 9 0   5     0   1   84 75                 159
1121958 1121958 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_8 151 6 11 0   1     0   0   91 78                       169 151 6 11 0   1     0   0   91 78                 169
1121959 1121959 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121960 1121960 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_9 106 3 8 1   4     0   2   55 69                       124 106 3 8 1   4     0   2   55 69                 124
1121961 1121961 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_10 91 4 10 0   3     1   0   50 59                       109 91 4 10 0   3     1   0   50 59                 109
1121962 1121962 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_11 105 1 15 0   0     0   2   59 64                       123 105 1 15 0   0     0   2   59 64                 123
1121963 1121963 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_12 82 2 8 0   0     0   0   41 51                       92 82 2 8 0   0     0   0   41 51                 92
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131125 1131125 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 Other 05 12 2017   grade_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1131126 1131126 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 Other 05 12 2017   grade_6 5 40 26 0   0     0   6   39 38                       77 5 40 26 0   0     0   6   39 38                 77
1131127 1131127 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 Other 05 12 2017   grade_7 13 47 20 0   1     0   0   37 44                       81 13 47 20 0   1     0   0   37 44                 81
1131128 1131128 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 Other 05 12 2017   grade_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1131129 1131129 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 Other 05 12 2017   grade_9 5 45 11 0   1     0   2   35 29                       64 5 45 11 0   1     0   2   35 29                 64
1131130 1131130 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 Other 05 12 2017   grade_10 6 29 14 0   1     1   4   29 26                       55 6 29 14 0   1     1   4   29 26                 55
1131131 1131131 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 Other 05 12 2017   grade_11 5 26 11 0   0     0   1   17 26                       43 5 26 11 0   0     0   1   17 26                 43
1131132 1131132 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 Other 05 12 2017   grade_12 12 25 10 0   0     0   2   18 31                       49 12 25 10 0   0     0   2   18 31                 49
1131133 1131133 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 Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131684 1131684 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Elementary PK PK 2017   pre_kindergarten 45 5 3 3   39     0   2   58 39                       97 45 5 3 3   39     0   2   58 39                 97
1131685 1131685 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131686 1131686 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   kindergarten 41 0 1 0   16     0   2   31 29                       60 41 0 1 0   16     0   2   31 29                 60
1131687 1131687 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_1 27 0 1 0   20     0   4   28 24                       52 27 0 1 0   20     0   4   28 24                 52
1131688 1131688 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_2 35 0 1 0   16     0   1   33 20                       53 35 0 1 0   16     0   1   33 20                 53
1131689 1131689 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_3 26 0 3 0   16     0   0   14 31                       45 26 0 3 0   16     0   0   14 31                 45
1131690 1131690 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_4 33 3 3 2   20     0   2   31 32                       63 33 3 3 2   20     0   2   31 32                 63
1131691 1131691 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_5 37 2 2 0   26     0   3   40 30                       70 37 2 2 0   26     0   3   40 30                 70
1131692 1131692 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_6 43 2 2 0   23     0   0   37 33                       70 43 2 2 0   23     0   0   37 33                 70
1131693 1131693 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131694 1131694 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   kindergarten 45 2 4 0   7     0   5   26 37                       63 45 2 4 0   7     0   5   26 37                 63
1131695 1131695 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_1 44 2 3 0   8     0   2   32 27                       59 44 2 3 0   8     0   2   32 27                 59
1131696 1131696 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_2 49 0 3 0   16     0   1   36 33                       69 49 0 3 0   16     0   1   36 33                 69
1131697 1131697 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_3 52 3 4 0   24     1   0   48 36                       84 52 3 4 0   24     1   0   48 36                 84
1131698 1131698 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_4 50 3 6 0   13     0   2   38 36                       74 50 3 6 0   13     0   2   38 36                 74
1131699 1131699 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_5 49 0 5 0   11     0   4   43 26                       69 49 0 5 0   11     0   4   43 26                 69
1131700 1131700 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_6 63 3 3 0   27     0   3   55 44                       99 63 3 3 0   27     0   3   55 44                 99
1131701 1131701 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131702 1131702 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   kindergarten 49 1 5 0   2     0   6   34 29                       63 49 1 5 0   2     0   6   34 29                 63
1131703 1131703 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_1 42 1 2 0   10     0   3   24 34                       58 42 1 2 0   10     0   3   24 34                 58
1131704 1131704 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_2 43 3 9 2   8     0   3   36 32                       68 43 3 9 2   8     0   3   36 32                 68
1131705 1131705 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_3 50 3 6 0   6     0   6   35 36                       71 50 3 6 0   6     0   6   35 36                 71
1131706 1131706 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_4 51 1 9 0   9     0   2   35 37                       72 51 1 9 0   9     0   2   35 37                 72
1131707 1131707 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_5 44 4 7 1   8     0   5   37 32                       69 44 4 7 1   8     0   5   37 32                 69
1131708 1131708 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_6 54 3 5 0   11     0   1   42 32                       74 54 3 5 0   11     0   1   42 32                 74
1131709 1131709 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131710 1131710 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   kindergarten 33 0 2 0   8     0   3   19 27                       46 33 0 2 0   8     0   3   19 27                 46
1131711 1131711 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_1 42 0 0 0   12     0   5   31 28                       59 42 0 0 0   12     0   5   31 28                 59
1131712 1131712 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_2 48 0 0 0   16     0   5   38 31                       69 48 0 0 0   16     0   5   38 31                 69
1131713 1131713 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_3 42 0 4 1   22     0   3   36 36                       72 42 0 4 1   22     0   3   36 36                 72
1131714 1131714 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_4 48 0 1 0   14     0   5   39 29                       68 48 0 1 0   14     0   5   39 29                 68
1131715 1131715 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_5 48 0 4 0   12     0   4   38 30                       68 48 0 4 0   12     0   4   38 30                 68
1131716 1131716 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_6 39 1 4 0   27     0   3   36 38                       74 39 1 4 0   27     0   3   36 38                 74
1131717 1131717 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131718 1131718 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   kindergarten 17 0 3 0   18     0   2   22 18                       40 17 0 3 0   18     0   2   22 18                 40
1131719 1131719 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_1 14 1 2 0   38     1   1   33 24                       57 14 1 2 0   38     1   1   33 24                 57
1131720 1131720 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_2 26 2 1 2   36     0   1   32 36                       68 26 2 1 2   36     0   1   32 36                 68
1131721 1131721 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_3 17 1 4 0   27     0   1   26 24                       50 17 1 4 0   27     0   1   26 24                 50
1131722 1131722 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_4 21 2 0 1   19     0   2   21 24                       45 21 2 0 1   19     0   2   21 24                 45
1131723 1131723 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_5 28 1 3 1   34     0   3   34 36                       70 28 1 3 1   34     0   3   34 36                 70
1131724 1131724 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_6 38 0 1 0   34     0   1   44 30                       74 38 0 1 0   34     0   1   44 30                 74
1131725 1131725 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131726 1131726 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   kindergarten 23 2 4 0   25     0   4   28 30                       58 23 2 4 0   25     0   4   28 30                 58
1131727 1131727 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_1 11 2 3 0   24     0   0   25 15                       40 11 2 3 0   24     0   0   25 15                 40
1131728 1131728 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_2 11 2 1 0   30     0   1   24 21                       45 11 2 1 0   30     0   1   24 21                 45
1131729 1131729 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_3 22 4 3 0   43     0   3   36 39                       75 22 4 3 0   43     0   3   36 39                 75
1131730 1131730 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_4 18 1 7 0   62     0   2   39 51                       90 18 1 7 0   62     0   2   39 51                 90
1131731 1131731 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_5 20 1 1 0   45     0   1   38 30                       68 20 1 1 0   45     0   1   38 30                 68
1131732 1131732 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_6 28 1 0 0   45     0   1   36 39                       75 28 1 0 0   45     0   1   36 39                 75
1131733 1131733 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131734 1131734 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_7 260 8 22 0   151     0   28   236 233                       469 260 8 22 0   151     0   28   236 233                 469
1131735 1131735 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_8 257 10 12 1   139     0   23   240 202                       442 257 10 12 1   139     0   23   240 202                 442
1131736 1131736 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131737 1131737 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_9 270 9 12 1   138     0   18   224 224                       448 270 9 12 1   138     0   18   224 224                 448
1131738 1131738 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_10 297 7 18 0   153     0   17   258 234                       492 297 7 18 0   153     0   17   258 234                 492
1131739 1131739 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_11 291 8 13 2   117     0   25   224 232                       456 291 8 13 2   117     0   25   224 232                 456
1131740 1131740 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_12 316 4 21 0   117     0   9   236 231                       467 316 4 21 0   117     0   9   236 231                 467
1131741 1131741 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              

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