enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 9,541 ✖
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
739673 739673 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_5 188 11 131 0   10     0   17   190 167                       357 188 11 131 0   10     0   17   190 167                 357
739674 739674 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_6 148 5 135 0   6     0   8   156 146                       302 148 5 135 0   6     0   8   156 146                 302
739675 739675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_7 177 6 115 1   10     0   8   158 159                       317 177 6 115 1   10     0   8   158 159                 317
739676 739676 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_8 190 7 141 0   5     0   6   177 172                       349 190 7 141 0   5     0   6   177 172                 349
742836 742836 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No 3 09 12 2015   grade_11 * * * *   *     *   *   2 *                       2                         2                   2
742837 742837 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No 3 09 12 2015   grade_12 3 0 7 0   0     0   0   7 *                       10 3 0 7 0   0     0   0   7                   10
739411 739411 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   kindergarten 8 6 56 0   13     0   5   51 37                       88 8 6 56 0   13     0   5   51 37                 88
739412 739412 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_1 14 13 86 0   17     0   2   73 59                       132 14 13 86 0   17     0   2   73 59                 132
739413 739413 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_2 10 3 50 1   15     0   2   44 37                       81 10 3 50 1   15     0   2   44 37                 81
739414 739414 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_3 5 4 48 0   13     0   2   38 34                       72 5 4 48 0   13     0   2   38 34                 72
739415 739415 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_4 8 3 48 0   16     0   0   46 29                       75 8 3 48 0   16     0   0   46 29                 75
739416 739416 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_5 7 2 38 1   15     0   0   33 30                       63 7 2 38 1   15     0   0   33 30                 63
740306 740306 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   kindergarten 43 1 4 0   11     0   6   27 38                       65 43 1 4 0   11     0   6   27 38                 65
740307 740307 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_1 54 1 2 0   9     0   1   35 32                       67 54 1 2 0   9     0   1   35 32                 67
740308 740308 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_2 46 4 4 0   6     0   5   30 35                       65 46 4 4 0   6     0   5   30 35                 65
740309 740309 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_3 40 3 4 0   11     0   7   35 30                       65 40 3 4 0   11     0   7   35 30                 65
740310 740310 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_4 53 4 5 0   11     0   2   37 38                       75 53 4 5 0   11     0   2   37 38                 75
740311 740311 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_5 33 7 7 0   10     0   7   36 28                       64 33 7 7 0   10     0   7   36 28                 64
744100 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 735672 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
742677 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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