Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2021 · 9,436
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
1675769 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn - Robert L Ford   Regular School No Elementary 01 05 2021   grade_5 6 6 88 1   9     0   2   59 53 *                     112.0 6 6 88 1   9     0   2   59 53                 112
1675795 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_1 * * * *   *     *   *   4 * *                     4.0                         4                   4
1675796 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_2 * * * *   *     *   *   3 * *                     5.0                         3                   5
1675797 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_3 * * * *   *     *   *   5 * *                     5.0                         5                   5
1675798 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_4 1 3 5 0   0     0   0   8 * *                     9.0 1 3 5 0   0     0   0   8                   9
1675799 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_5 2 1 3 0   1     0   1   7 * *                     8.0 2 1 3 0   1     0   1   7                   8
1675819 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_1 8 4 75 0   2     0   1   51 39 *                     90.0 8 4 75 0   2     0   1   51 39                 90
1675820 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_2 4 7 72 1   4     0   1   51 38 *                     89.0 4 7 72 1   4     0   1   51 38                 89
1675821 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_3 5 7 71 0   6     0   0   42 47 *                     89.0 5 7 71 0   6     0   0   42 47                 89
1675822 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_4 9 4 65 0   5     0   3   48 38 *                     86.0 9 4 65 0   5     0   3   48 38                 86
1675823 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_5 4 8 64 0   5     0   1   38 44 *                     82.0 4 8 64 0   5     0   1   38 44                 82
1675942 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead - L H Coffin   Regular School No Elementary 01 02 2021   grade_1 76 1 7 0   0     0   4   44 44 *                     88.0 76 1 7 0   0     0   4   44 44                 88
1675943 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead - L H Coffin   Regular School No Elementary 01 02 2021   grade_2 87 3 6 0   3     0   4   53 50 *                     103.0 87 3 6 0   3     0   4   53 50                 103
1676231 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_1 89 5 2 0   0     0   5   48 53 *                     101.0 89 5 2 0   0     0   5   48 53                 101
1676232 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_2 91 3 2 0   1     0   7   53 51 *                     104.0 91 3 2 0   1     0   7   53 51                 104
1676233 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_3 94 3 5 1   1     0   7   61 50 *                     111.0 94 3 5 1   1     0   7   61 50                 111
1676234 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_4 86 1 3 0   2     0   9   47 54 *                     101.0 86 1 3 0   2     0   9   47 54                 101
1676235 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_5 95 1 3 0   0     0   8   58 49 *                     107.0 95 1 3 0   0     0   8   58 49                 107
1676236 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_1 100 2 3 2   0     0   5   62 50 *                     112.0 100 2 3 2   0     0   5   62 50                 112
1676237 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_2 94 3 0 0   2     0   6   52 53 *                     105.0 94 3 0 0   2     0   6   52 53                 105
1676238 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_3 108 3 2 0   0     0   6   52 67 *                     119.0 108 3 2 0   0     0   6   52 67                 119
1676239 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_4 108 1 0 0   3     0   5   61 56 *                     117.0 108 1 0 0   3     0   5   61 56                 117
1676240 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_5 96 2 2 0   0     0   8   56 52 *                     108.0 96 2 2 0   0     0   8   56 52                 108
1676341 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_1 65 0 2 0   0     0   2   35 34 *                     69.0 65 0 2 0   0     0   2   35 34                 69
1676342 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_2 64 0 3 0   1     0   0   26 42 *                     68.0 64 0 3 0   1     0   0   26 42                 68
1676343 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_3 49 1 7 0   1     0   2   29 31 *                     60.0 49 1 7 0   1     0   2   29 31                 60
1676344 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_4 60 0 5 0   0     0   2   40 27 *                     67.0 60 0 5 0   0     0   2   40 27                 67
1676345 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_5 62 1 7 0   0     0   3   32 41 *                     73.0 62 1 7 0   0     0   3   32 41                 73
1676346 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_6 67 3 2 0   0     1   5   35 42 *                     78.0 67 3 2 0   0     1   5   35 42                 78
1676802 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_1 43 2 19 0   4     0   3   44 27 *                     71.0 43 2 19 0   4     0   3   44 27                 71
1676803 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_2 34 6 12 0   6     0   2   31 29 *                     60.0 34 6 12 0   6     0   2   31 29                 60
1676804 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_3 30 2 22 0   6     0   2   29 33 *                     62.0 30 2 22 0   6     0   2   29 33                 62
1676805 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_4 41 3 11 0   6     0   2   35 28 *                     63.0 41 3 11 0   6     0   2   35 28                 63
1676806 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_5 43 4 17 0   2     0   1   32 35 *                     67.0 43 4 17 0   2     0   1   32 35                 67
1676809 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_1 65 0 7 0   7     0   2   39 42 *                     81.0 65 0 7 0   7     0   2   39 42                 81
1676810 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_2 48 3 5 0   6     0   4   30 36 *                     66.0 48 3 5 0   6     0   4   30 36                 66
1676811 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_3 57 5 6 0   6     0   3   45 32 *                     77.0 57 5 6 0   6     0   3   45 32                 77
1676812 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_4 53 0 7 0   15     0   4   45 34 *                     79.0 53 0 7 0   15     0   4   45 34                 79
1676813 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_5 53 1 9 0   12     0   2   40 37 *                     77.0 53 1 9 0   12     0   2   40 37                 77
1676814 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_1 34 0 2 0   1     0   0   17 20 *                     37.0 34 0 2 0   1     0   0   17 20                 37
1676815 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_2 37 1 5 0   1     0   0   29 15 *                     44.0 37 1 5 0   1     0   0   29 15                 44
1676816 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_3 44 1 4 0   0     0   4   25 28 *                     53.0 44 1 4 0   0     0   4   25 28                 53
1676817 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_4 35 2 6 0   2     1   2   26 22 *                     48.0 35 2 6 0   2     1   2   26 22                 48
1676818 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_5 37 0 6 0   2     0   1   28 18 *                     46.0 37 0 6 0   2     0   1   28 18                 46
1676819 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_1 68 1 6 0   1     0   0   38 38 *                     76.0 68 1 6 0   1     0   0   38 38                 76
1676820 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_2 73 1 4 0   9     0   6   47 46 *                     93.0 73 1 4 0   9     0   6   47 46                 93
1676821 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_3 70 1 6 0   13     0   3   45 48 *                     93.0 70 1 6 0   13     0   3   45 48                 93
1676822 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_4 65 2 8 0   10     0   3   55 33 *                     88.0 65 2 8 0   10     0   3   55 33                 88
1676823 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_5 74 0 3 0   5     0   5   32 55 *                     87.0 74 0 3 0   5     0   5   32 55                 87
1676824 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_1 43 0 16 0   1     0   1   36 25 *                     61.0 43 0 16 0   1     0   1   36 25                 61
1676825 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_2 61 1 11 0   4     0   4   40 41 *                     81.0 61 1 11 0   4     0   4   40 41                 81
1676826 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_3 41 0 6 0   1     0   1   25 24 *                     49.0 41 0 6 0   1     0   1   25 24                 49
1676827 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_4 36 3 10 0   7     0   3   22 37 *                     59.0 36 3 10 0   7     0   3   22 37                 59
1676828 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_5 53 0 10 0   2     0   3   37 31 *                     68.0 53 0 10 0   2     0   3   37 31                 68
1676996 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_1 24 8 17 0   3     1   0   27 26 *                     53.0 24 8 17 0   3     1   0   27 26                 53
1676997 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_2 23 5 19 0   6     2   0   28 27 *                     55.0 23 5 19 0   6     2   0   28 27                 55
1676998 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_3 31 6 24 0   3     0   1   36 29 *                     65.0 31 6 24 0   3     0   1   36 29                 65
1676999 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_4 29 11 27 0   2     0   1   36 34 *                     70.0 29 11 27 0   2     0   1   36 34                 70
1677000 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_5 21 8 20 0   1     0   1   23 28 *                     51.0 21 8 20 0   1     0   1   23 28                 51
1677001 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_1 25 4 8 0   3     1   1   22 20 *                     42.0 25 4 8 0   3     1   1   22 20                 42
1677002 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_2 35 10 6 0   0     0   2   25 28 *                     53.0 35 10 6 0   0     0   2   25 28                 53
1677003 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_3 31 6 1 0   6     0   1   21 24 *                     45.0 31 6 1 0   6     0   1   21 24                 45
1677004 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_4 29 6 5 0   3     0   4   25 22 *                     47.0 29 6 5 0   3     0   4   25 22                 47
1677005 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_5 20 6 2 0   3     0   3   19 15 *                     34.0 20 6 2 0   3     0   3   19 15                 34
1677006 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_1 54 5 9 0   4     0   2   36 38 *                     74.0 54 5 9 0   4     0   2   36 38                 74
1677007 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_2 45 3 5 0   3     1   2   38 21 *                     59.0 45 3 5 0   3     1   2   38 21                 59
1677008 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_3 34 3 10 0   3     1   4   29 26 *                     55.0 34 3 10 0   3     1   4   29 26                 55
1677009 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_4 44 5 8 0   5     0   0   37 25 *                     62.0 44 5 8 0   5     0   0   37 25                 62
1677010 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_5 58 4 7 0   6     0   4   39 40 *                     79.0 58 4 7 0   6     0   4   39 40                 79
1677011 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_1 35 2 4 0   2     0   1   26 18 *                     44.0 35 2 4 0   2     0   1   26 18                 44
1677012 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_2 35 7 7 0   2     1   0   24 28 *                     52.0 35 7 7 0   2     1   0   24 28                 52
1677013 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_3 32 10 5 0   3     0   1   28 23 *                     51.0 32 10 5 0   3     0   1   28 23                 51
1677014 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_4 25 6 7 0   2     0   2   21 21 *                     42.0 25 6 7 0   2     0   2   21 21                 42
1677015 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_5 34 8 10 0   5     0   0   25 32 *                     57.0 34 8 10 0   5     0   0   25 32                 57
1677194 MA Berkshire   school 2509630 236   Pittsfield 250963002914 2360030 Pittsfield - Crosby Educational Academy   Special Education School No Elementary 01 05 2021   grade_1 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1677195 MA Berkshire   school 2509630 236   Pittsfield 250963002914 2360030 Pittsfield - Crosby Educational Academy   Special Education School No Elementary 01 05 2021   grade_3 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1677196 MA Berkshire   school 2509630 236   Pittsfield 250963002914 2360030 Pittsfield - Crosby Educational Academy   Special Education School No Elementary 01 05 2021   grade_4 3 2 0 0   0     0   1   3 3 *                     6.0 3 2 0 0   0     0   1   3 3                 6
1677837 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_1 41 2 8 0   60     0   3   53 61 *                     114.0 41 2 8 0   60     0   3   53 61                 114
1677838 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_2 57 6 10 5   93     0   9   93 87 *                     180.0 57 6 10 5   93     0   9   93 87                 180
1677839 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_3 53 8 20 4   76     0   11   93 79 *                     172.0 53 8 20 4   76     0   11   93 79                 172
1677840 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_4 66 5 19 1   115     0   7   119 94 *                     213.0 66 5 19 1   115     0   7   119 94                 213
1678029 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_1 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1678030 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1678031 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_3 0 3 5 0   0     0   1   8 1 *                     9.0 0 3 5 0   0     0   1   8 1                 9
1678032 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_4 1 6 9 0   0     0   0   14 2 *                     16.0 1 6 9 0   0     0   0   14 2                 16
1678033 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_5 1 2 8 0   0     0   0   10 1 *                     11.0 1 2 8 0   0     0   0   10 1                 11
1678957 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_1 69 8 3 0   1     0   10   49 42 *                     91.0 69 8 3 0   1     0   10   49 42                 91
1678958 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_2 94 6 8 0   0     0   4   56 56 *                     112.0 94 6 8 0   0     0   4   56 56                 112
1678959 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_3 72 2 5 0   1     0   5   47 38 *                     85.0 72 2 5 0   1     0   5   47 38                 85
1679097 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_1 47 3 18 0   6     0   6   37 43 *                     80.0 47 3 18 0   6     0   6   37 43                 80
1679098 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_2 56 0 16 0   4     0   3   37 42 *                     79.0 56 0 16 0   4     0   3   37 42                 79
1679099 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_3 57 3 12 0   7     0   0   27 52 *                     79.0 57 3 12 0   7     0   0   27 52                 79
1679100 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_4 58 0 15 0   3     0   4   40 40 *                     80.0 58 0 15 0   3     0   4   40 40                 80
1679101 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_5 77 1 12 0   3     0   5   51 47 *                     98.0 77 1 12 0   3     0   5   51 47                 98
1679102 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_1 11 1 12 0   5     0   3   15 17 *                     32.0 11 1 12 0   5     0   3   15 17                 32
1679103 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_2 12 3 18 0   1     0   3   20 17 *                     37.0 12 3 18 0   1     0   3   20 17                 37
1679104 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_3 16 1 10 0   1     0   1   10 19 *                     29.0 16 1 10 0   1     0   1   10 19                 29
1679105 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_4 21 3 15 0   4     0   0   26 17 *                     43.0 21 3 15 0   4     0   0   26 17                 43
1679106 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_5 19 2 13 0   8     0   1   20 23 *                     43.0 19 2 13 0   8     0   1   20 23                 43
1679107 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield - Mittineague   Regular School No Elementary 01 05 2021   grade_1 18 1 4 0   2     0   1   16 10 *                     26.0 18 1 4 0   2     0   1   16 10                 26

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