Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by school

View and edit SQL

grade

year

  • 2015 · 9,523
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
744100 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_4 85 2 5 0   0     0   5   44 53                       97 85 2 5 0   0     0   5   44 53                 97
744101 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_5 99 1 5 0   1     0   3   49 60                       109 99 1 5 0   1     0   3   49 60                 109
741211 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   kindergarten 40 5 31 0   7     1   2   40 46                       86 40 5 31 0   7     1   2   40 46                 86
741212 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_1 73 1 41 1   3     0   3   66 56                       122 73 1 41 1   3     0   3   66 56                 122
741213 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_2 54 5 40 0   8     0   2   54 55                       109 54 5 40 0   8     0   2   54 55                 109
741214 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_3 69 3 40 0   6     0   4   62 60                       122 69 3 40 0   6     0   4   62 60                 122
741215 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_4 83 4 43 1   10     0   0   70 71                       141 83 4 43 1   10     0   0   70 71                 141
741216 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_5 66 3 32 0   8     0   4   52 61                       113 66 3 32 0   8     0   4   52 61                 113
735870 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   kindergarten 56 0 33 0   2     0   0   44 47                       91 56 0 33 0   2     0   0   44 47                 91
735871 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_1 50 0 17 0   4     0   7   36 42                       78 50 0 17 0   4     0   7   36 42                 78
735872 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_2 62 3 28 0   1     0   1   50 45                       95 62 3 28 0   1     0   1   50 45                 95
735873 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_3 58 0 30 0   3     0   5   48 48                       96 58 0 30 0   3     0   5   48 48                 96
735874 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_4 52 0 21 1   1     0   4   37 42                       79 52 0 21 1   1     0   4   37 42                 79
738076 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_3 * * * *   *     *   *   1 *                       2                         1                   2
738077 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_4 * * * *   *     *   *   4 *                       4                         4                   4
738078 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_5 1 3 2 0   0     0   1   7 *                       7 1 3 2 0   0     0   1   7                   7
742728 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_3 95 1 0 0   15     0   3   51 63                       114 95 1 0 0   15     0   3   51 63                 114
742729 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_4 126 0 0 0   27     0   5   89 69                       158 126 0 0 0   27     0   5   89 69                 158
742730 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_5 90 3 1 1   21     0   2   59 59                       118 90 3 1 1   21     0   2   59 59                 118
738203 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   kindergarten 6 0 0 0   0     0   1   3 4                       7 6 0 0 0   0     0   1   3 4                 7
738204 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   pre_kindergarten 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
738205 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_1 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
738206 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_2 13 0 0 0   0     0   0   5 8                       13 13 0 0 0   0     0   0   5 8                 13
738207 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_3 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
738208 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_4 * * * *   *     *   *   2 2                       4                         2 2                 4
738209 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_5 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738211 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_7 8 2 0 0   0     0   1   7 4                       11 8 2 0 0   0     0   1   7 4                 11
738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
743602 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   kindergarten 29 63 14 0   2     0   9   62 55                       117 29 63 14 0   2     0   9   62 55                 117
743603 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_1 15 79 26 0   4     0   1   57 68                       125 15 79 26 0   4     0   1   57 68                 125
743604 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_2 26 60 34 0   2     0   0   58 64                       122 26 60 34 0   2     0   0   58 64                 122
743605 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_3 31 61 22 0   5     1   3   57 66                       123 31 61 22 0   5     1   3   57 66                 123
743606 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_4 30 53 29 0   3     0   6   60 61                       121 30 53 29 0   3     0   6   60 61                 121
743607 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_5 29 65 27 0   7     0   0   61 67                       128 29 65 27 0   7     0   0   61 67                 128
743608 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_6 29 49 35 1   7     0   2   56 67                       123 29 49 35 1   7     0   2   56 67                 123
743609 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_7 38 23 47 0   5     0   4   59 58                       117 38 23 47 0   5     0   4   59 58                 117
743610 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_8 30 42 25 0   7     1   4   68 41                       109 30 42 25 0   7     1   4   68 41                 109
743611 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_9 24 35 29 0   6     0   2   33 63                       96 24 35 29 0   6     0   2   33 63                 96
743612 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_10 34 30 17 0   4     0   2   38 49                       87 34 30 17 0   4     0   2   38 49                 87
743613 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_11 19 24 28 0   3     0   7   37 44                       81 19 24 28 0   3     0   7   37 44                 81
743614 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_12 23 25 17 0   5     0   9   31 48                       79 23 25 17 0   5     0   9   31 48                 79
742919 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_5 389 36 30 0   18     1   22   262 234                       496 389 36 30 0   18     1   22   262 234                 496
742920 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_6 369 31 31 2   20     0   17   237 233                       470 369 31 31 2   20     0   17   237 233                 470
735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
735669 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_10 82 3 10 0   0     0   1   46 50                       96 82 3 10 0   0     0   1   46 50                 96
735670 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_11 105 6 2 0   2     0   2   59 58                       117 105 6 2 0   2     0   2   59 58                 117
735671 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_12 117 1 8 0   2     0   0   57 71                       128 117 1 8 0   2     0   0   57 71                 128
735672 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
742677 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   kindergarten 21 0 7 0   2     0   1   17 14                       31 21 0 7 0   2     0   1   17 14                 31
742678 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_1 27 4 5 0   0     0   1   21 16                       37 27 4 5 0   0     0   1   21 16                 37
742679 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_2 31 0 6 0   1     0   1   15 24                       39 31 0 6 0   1     0   1   15 24                 39
742680 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_3 25 1 4 0   1     0   0   11 20                       31 25 1 4 0   1     0   0   11 20                 31
742681 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_4 29 0 5 0   3     0   0   16 21                       37 29 0 5 0   3     0   0   16 21                 37
742682 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_5 32 0 9 0   0     0   0   22 19                       41 32 0 9 0   0     0   0   22 19                 41
739405 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   kindergarten 15 3 12 1   1     0   1   16 17                       33 15 3 12 1   1     0   1   16 17                 33
739406 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_1 24 8 17 1   3     0   5   26 32                       58 24 8 17 1   3     0   5   26 32                 58
739407 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_2 11 9 18 0   3     0   3   21 23                       44 11 9 18 0   3     0   3   21 23                 44
739408 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_3 18 6 23 0   0     0   4   27 24                       51 18 6 23 0   0     0   4   27 24                 51
739409 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_4 13 2 18 0   0     0   4   20 17                       37 13 2 18 0   0     0   4   20 17                 37
739410 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_5 21 4 6 0   1     0   3   16 19                       35 21 4 6 0   1     0   3   16 19                 35
739262 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   kindergarten 12 6 31 0   46     0   3   44 54                       98 12 6 31 0   46     0   3   44 54                 98
739263 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   pre_kindergarten 6 3 9 0   18     0   3   25 14                       39 6 3 9 0   18     0   3   25 14                 39
739264 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_1 19 3 26 0   43     0   3   52 42                       94 19 3 26 0   43     0   3   52 42                 94
739265 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_2 14 3 24 0   44     0   8   55 38                       93 14 3 24 0   44     0   8   55 38                 93
739266 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_3 15 8 34 0   52     0   4   57 56                       113 15 8 34 0   52     0   4   57 56                 113
739267 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_4 8 2 31 0   32     0   4   35 42                       77 8 2 31 0   32     0   4   35 42                 77
740209 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   kindergarten 59 15 38 0   0     0   11   67 56                       123 59 15 38 0   0     0   11   67 56                 123
740210 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_1 82 11 53 0   1     0   7   81 73                       154 82 11 53 0   1     0   7   81 73                 154
740211 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_2 60 11 53 1   1     0   14   68 72                       140 60 11 53 1   1     0   14   68 72                 140
740212 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_3 77 16 34 1   2     0   7   80 57                       137 77 16 34 1   2     0   7   80 57                 137
740213 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_4 60 10 26 1   1     0   10   56 52                       108 60 10 26 1   1     0   10   56 52                 108
740214 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_5 60 10 30 0   1     0   2   52 51                       103 60 10 30 0   1     0   2   52 51                 103
741227 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   kindergarten 38 4 50 0   2     0   0   41 53                       94 38 4 50 0   2     0   0   41 53                 94
741228 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   pre_kindergarten 49 2 25 1   4     0   0   39 42                       81 49 2 25 1   4     0   0   39 42                 81
741229 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_1 51 7 52 0   4     0   1   54 61                       115 51 7 52 0   4     0   1   54 61                 115
741230 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_2 58 3 46 0   4     0   3   53 61                       114 58 3 46 0   4     0   3   53 61                 114
741231 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_3 45 6 33 0   2     0   2   48 40                       88 45 6 33 0   2     0   2   48 40                 88
741232 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_4 42 6 37 0   1     0   4   41 49                       90 42 6 37 0   1     0   4   41 49                 90
741233 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_5 39 8 45 0   4     0   3   55 44                       99 39 8 45 0   4     0   3   55 44                 99
742877 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   kindergarten 40 4 6 0   4     0   2   29 27                       56 40 4 6 0   4     0   2   29 27                 56
742878 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   grade_1 64 4 10 0   5     0   2   46 39                       85 64 4 10 0   5     0   2   46 39                 85
742879 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   grade_2 45 1 12 0   7     0   1   35 31                       66 45 1 12 0   7     0   1   35 31                 66
742880 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   grade_3 60 4 8 0   4     0   0   35 41                       76 60 4 8 0   4     0   0   35 41                 76
742881 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   grade_4 51 2 6 0   4     1   0   26 38                       64 51 2 6 0   4     1   0   26 38                 64
743426 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 4 05 12 2015   grade_5 16 41 19 0   0     0   1   38 39                       77 16 41 19 0   0     0   1   38 39                 77
743427 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 4 05 12 2015   grade_6 4 47 22 0   0     0   1   36 38                       74 4 47 22 0   0     0   1   36 38                 74
743428 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 4 05 12 2015   grade_7 12 48 14 0   1     0   2   38 39                       77 12 48 14 0   1     0   2   38 39                 77
743429 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 4 05 12 2015   grade_8 10 41 20 0   2     0   5   37 41                       78 10 41 20 0   2     0   5   37 41                 78
743430 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 4 05 12 2015   grade_9 6 33 12 0   0     0   1   22 30                       52 6 33 12 0   0     0   1   22 30                 52
743431 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 4 05 12 2015   grade_10 11 32 10 0   0     0   3   21 35                       56 11 32 10 0   0     0   3   21 35                 56
743432 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 4 05 12 2015   grade_11 14 37 4 0   0     0   3   27 31                       58 14 37 4 0   0     0   3   27 31                 58
743433 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 4 05 12 2015   grade_12 9 27 8 0   2     0   1   17 30                       47 9 27 8 0   2     0   1   17 30                 47
743967 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_9 294 7 13 2   115     0   26   229 228                       457 294 7 13 2   115     0   26   229 228                 457
743968 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_10 325 4 20 1   118     0   11   243 236                       479 325 4 20 1   118     0   11   243 236                 479
743969 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_11 338 8 14 1   114     0   11   251 235                       486 338 8 14 1   114     0   11   251 235                 486
743970 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_12 344 2 16 1   112     0   6   235 246                       481 344 2 16 1   112     0   6   235 246                 481
735673 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   kindergarten 92 0 4 0   0     0   0   45 51                       96 92 0 4 0   0     0   0   45 51                 96
735674 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   pre_kindergarten 48 0 1 0   0     0   2   27 24                       51 48 0 1 0   0     0   2   27 24                 51
735675 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_1 101 0 0 0   0     0   0   58 43                       101 101 0 0 0   0     0   0   58 43                 101

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