enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2043813 2043813 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_5 152 12 210 1   15     0   12   219 183                       402.0 152 12 210 1   15     0   12   219 183                 402
2043814 2043814 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_6 166 13 186 0   7     0   9   191 190                       381.0 166 13 186 0   7     0   9   191 190                 381
2043815 2043815 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_7 113 8 162 0   4     0   12   142 157                       299.0 113 8 162 0   4     0   12   142 157                 299
2043816 2043816 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_8 117 13 174 0   8     0   8   178 142                       320.0 117 13 174 0   8     0   8   178 142                 320
2043555 2043555 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   kindergarten 10 1 48 1   15     0   0   40 35                       75.0 10 1 48 1   15     0   0   40 35                 75
2043556 2043556 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_1 6 7 49 0   12     0   1   30 45                       75.0 6 7 49 0   12     0   1   30 45                 75
2043557 2043557 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_2 7 5 51 1   6     0   2   33 39                       72.0 7 5 51 1   6     0   2   33 39                 72
2043558 2043558 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_3 5 3 55 0   13     0   3   41 38                       79.0 5 3 55 0   13     0   3   41 38                 79
2043559 2043559 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_4 2 6 56 0   15     0   6   43 42                       85.0 2 6 56 0   15     0   6   43 42                 85
2043560 2043560 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_5 6 13 78 0   15     0   1   57 56                       113.0 6 13 78 0   15     0   1   57 56                 113
2044443 2044443 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   kindergarten 60 3 2 0   11     0   8   43 41                       84.0 60 3 2 0   11     0   8   43 41                 84
2044444 2044444 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_1 51 4 5 0   8     0   5   38 35                       73.0 51 4 5 0   8     0   5   38 35                 73
2044445 2044445 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_2 66 2 6 0   16     0   7   51 46                       97.0 66 2 6 0   16     0   7   51 46                 97
2044446 2044446 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_3 67 1 5 0   10     0   3   40 46                       86.0 67 1 5 0   10     0   3   40 46                 86
2044447 2044447 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_4 57 3 6 0   16     0   7   32 57                       89.0 57 3 6 0   16     0   7   32 57                 89
2044448 2044448 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_5 56 2 1 0   13     0   2   37 37                       74.0 56 2 1 0   13     0   2   37 37                 74
2048220 2048220 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_3 103 1 9 0   1     0   5   72 47                       119.0 103 1 9 0   1     0   5   72 47                 119
2048221 2048221 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_4 76 1 6 0   0     0   7   50 40                       90.0 76 1 6 0   0     0   7   50 40                 90
2048222 2048222 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_5 86 3 9 0   2     0   5   50 55                       105.0 86 3 9 0   2     0   5   50 55                 105
2047884 2047884 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_7 44 6 18 1   3     0   2   43 31                       74.0 44 6 18 1   3     0   2   43 31                 74
2047885 2047885 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_8 47 4 20 0   0     0   3   39 35                       74.0 47 4 20 0   0     0   3   39 35                 74
2047886 2047886 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_9 43 5 17 0   1     0   2   31 35                       68.0 43 5 17 0   1     0   2   31 35                 68
2047887 2047887 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_10 44 3 18 0   0     0   0   39 26                       65.0 44 3 18 0   0     0   0   39 26                 65
2047888 2047888 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_11 38 4 8 0   0     0   1   23 28                       51.0 38 4 8 0   0     0   1   23 28                 51
2047889 2047889 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_12 31 0 6 0   0     0   0   22 15                       37.0 31 0 6 0   0     0   0   22 15                 37
2045340 2045340 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   kindergarten 62 0 55 0   8     0   3   70 58                       128.0 62 0 55 0   8     0   3   70 58                 128
2045341 2045341 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_1 59 7 64 0   4     0   4   74 64                       138.0 59 7 64 0   4     0   4   74 64                 138
2045342 2045342 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_2 58 2 70 0   6     0   1   76 61                       137.0 58 2 70 0   6     0   1   76 61                 137
2045343 2045343 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_3 59 2 56 0   6     0   2   68 57                       125.0 59 2 56 0   6     0   2   68 57                 125
2045344 2045344 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_4 52 4 61 0   6     1   1   62 63                       125.0 52 4 61 0   6     1   1   62 63                 125
2045345 2045345 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_5 70 2 57 0   3     0   1   68 64                       133.0 70 2 57 0   3     0   1   68 64                 133
2040021 2040021 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   kindergarten 55 5 18 0   4     0   5   40 47                       87.0 55 5 18 0   4     0   5   40 47                 87
2040022 2040022 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_1 54 4 7 0   1     0   2   37 31                       68.0 54 4 7 0   1     0   2   37 31                 68
2040023 2040023 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_2 47 7 13 0   1     0   4   32 40                       72.0 47 7 13 0   1     0   4   32 40                 72
2040024 2040024 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_3 58 2 13 0   5     1   11   53 37                       90.0 58 2 13 0   5     1   11   53 37                 90
2040025 2040025 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_4 56 2 17 0   3     0   1   40 39                       79.0 56 2 17 0   3     0   1   40 39                 79
2046838 2046838 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_3 93 0 1 0   36     0   5   62 73                       135.0 93 0 1 0   36     0   5   62 73                 135
2046839 2046839 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_4 95 1 1 0   26     0   6   64 65                       129.0 95 1 1 0   26     0   6   64 65                 129
2046840 2046840 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_5 84 0 2 1   28     0   2   47 70                       117.0 84 0 2 1   28     0   2   47 70                 117
2042361 2042361 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   pre_kindergarten 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
2042362 2042362 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   kindergarten 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2042363 2042363 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_1 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2042364 2042364 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_2 8 0 0 0   0     0   0   3 5                       8.0 8 0 0 0   0     0   0   3 5                 8
2042365 2042365 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_3 7 0 0 0   0     0   0   3 4                       7.0 7 0 0 0   0     0   0   3 4                 7
2042366 2042366 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_4 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2042367 2042367 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_5 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2042368 2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2042370 2042370 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
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
2047027 2047027 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2019   grade_5 319 30 50 1   33     0   21   240 214                       454.0 319 30 50 1   33     0   21   240 214                 454
2047028 2047028 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2019   grade_6 319 32 46 1   17     0   16   211 220                       431.0 319 32 46 1   17     0   16   211 220                 431
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
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
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
2046800 2046800 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   kindergarten 16 1 13 0   9     0   3   24 18                       42.0 16 1 13 0   9     0   3   24 18                 42
2046801 2046801 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_1 28 1 14 0   3     0   1   28 19                       47.0 28 1 14 0   3     0   1   28 19                 47
2046802 2046802 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_2 32 1 9 0   3     0   3   21 27                       48.0 32 1 9 0   3     0   3   21 27                 48
2046803 2046803 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_3 29 4 12 0   5     0   0   25 25                       50.0 29 4 12 0   5     0   0   25 25                 50
2046804 2046804 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_4 19 1 5 0   5     0   1   13 18                       31.0 19 1 5 0   5     0   1   13 18                 31
2043549 2043549 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   kindergarten 14 3 18 0   5     0   5   17 28                       45.0 14 3 18 0   5     0   5   17 28                 45
2043550 2043550 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_1 10 2 24 1   4     0   4   23 22                       45.0 10 2 24 1   4     0   4   23 22                 45
2043551 2043551 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_2 6 6 11 1   7     0   5   18 18                       36.0 6 6 11 1   7     0   5   18 18                 36
2043552 2043552 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_3 11 5 12 0   3     0   9   18 22                       40.0 11 5 12 0   3     0   9   18 22                 40
2043553 2043553 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_4 15 7 18 1   2     0   1   24 20                       44.0 15 7 18 1   2     0   1   24 20                 44
2043554 2043554 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_5 17 6 17 1   3     0   2   24 22                       46.0 17 6 17 1   3     0   2   24 22                 46
2043396 2043396 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   pre_kindergarten 6 2 10 0   28     0   1   23 24                       47.0 6 2 10 0   28     0   1   23 24                 47
2043397 2043397 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   kindergarten 13 1 31 0   44     0   4   49 44                       93.0 13 1 31 0   44     0   4   49 44                 93
2043398 2043398 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_1 13 1 23 0   48     0   6   52 39                       91.0 13 1 23 0   48     0   6   52 39                 91
2043399 2043399 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_2 6 1 28 0   54     0   2   51 40                       91.0 6 1 28 0   54     0   2   51 40                 91
2043400 2043400 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_3 12 6 29 1   35     0   4   49 38                       87.0 12 6 29 1   35     0   4   49 38                 87
2043401 2043401 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_4 11 5 36 0   45     0   3   51 49                       100.0 11 5 36 0   45     0   3   51 49                 100
2044343 2044343 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   kindergarten 48 10 39 0   0     0   8   59 46                       105.0 48 10 39 0   0     0   8   59 46                 105
2044344 2044344 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_1 60 18 45 0   1     1   4   72 57                       129.0 60 18 45 0   1     1   4   72 57                 129
2044345 2044345 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_2 55 16 37 0   2     0   7   56 61                       117.0 55 16 37 0   2     0   7   56 61                 117
2044346 2044346 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_3 66 9 32 1   2     0   4   58 56                       114.0 66 9 32 1   2     0   4   58 56                 114
2044347 2044347 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_4 51 8 39 1   0     0   9   57 51                       108.0 51 8 39 1   0     0   9   57 51                 108
2044348 2044348 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_5 67 10 33 0   1     0   4   60 55                       115.0 67 10 33 0   1     0   4   60 55                 115
2045356 2045356 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   pre_kindergarten 66 0 34 0   1     0   0   61 40                       101.0 66 0 34 0   1     0   0   61 40                 101
2045357 2045357 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   kindergarten 35 1 46 0   4     0   2   52 36                       88.0 35 1 46 0   4     0   2   52 36                 88
2045358 2045358 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_1 28 1 63 0   4     0   1   45 52                       97.0 28 1 63 0   4     0   1   45 52                 97

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