Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • grade_5 · 6,118
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
1369576 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_5 85 3 5 1   7     0   3   57 47 *                     104.0 85 3 5 1   7     0   3   57 47                 104
1369581 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2020   grade_5 41 2 9 0   5     0   1   26 32 *                     58.0 41 2 9 0   5     0   1   26 32                 58
1369753 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_5 24 7 23 0   2     0   1   26 31 *                     57.0 24 7 23 0   2     0   1   26 31                 57
1369758 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2020   grade_5 30 5 5 0   0     0   1   24 17 *                     41.0 30 5 5 0   0     0   1   24 17                 41
1369763 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2020   grade_5 55 3 9 0   3     0   2   42 30 *                     72.0 55 3 9 0   3     0   2   42 30                 72
1369768 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2020   grade_5 31 4 5 0   2     0   1   22 21 *                     43.0 31 4 5 0   2     0   1   22 21                 43
1370777 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_5 3 1 15 0   0     0   0   17 2 *                     19.0 3 1 15 0   0     0   0   17 2                 19
1371847 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary 01 05 2020   grade_5 65 4 17 0   4     0   1   56 35 *                     91.0 65 4 17 0   4     0   1   56 35                 91
1371852 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2020   grade_5 27 0 13 0   6     0   2   22 26 *                     48.0 27 0 13 0   6     0   2   22 26                 48
1371857 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2020   grade_5 24 2 8 0   1     0   0   16 19 *                     35.0 24 2 8 0   1     0   0   16 19                 35
1373781 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_5 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1673282 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673337 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_5 55 1 4 0   35     1   3   47 52 *                     99.0 55 1 4 0   35     1   3   47 52                 99
1673815 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_5 2 1 27 0   0     0   0   14 16 *                     30.0 2 1 27 0   0     0   0   14 16                 30
1674026 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth - Joseph Demello   Regular School No Elementary 01 05 2021   grade_5 62 0 5 0   1     0   4   35 37 *                     72.0 62 0 5 0   1     0   4   35 37                 72
1674053 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham - Avery   Regular School No Elementary 01 05 2021   grade_5 23 7 19 0   2     0   4   24 31 *                     55.0 23 7 19 0   2     0   4   24 31                 55
1674058 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham - Greenlodge   Regular School No Elementary 01 05 2021   grade_5 28 3 3 0   1     0   0   19 16 *                     35.0 28 3 3 0   1     0   0   19 16                 35
1674063 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham - Oakdale   Regular School No Elementary 01 05 2021   grade_5 35 3 7 0   0     0   4   17 32 *                     49.0 35 3 7 0   0     0   4   17 32                 49
1674068 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham - Riverdale   Regular School No Elementary 01 05 2021   grade_5 25 3 2 0   0     0   2   13 19 *                     32.0 25 3 2 0   0     0   2   13 19                 32
1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1675214 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_5 3 2 143 0   0     0   0   80 68 *                     148.0 3 2 143 0   0     0   0   80 68                 148
1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
1675262 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_5 2 0 86 0   0     0   0   46 42 *                     88.0 2 0 86 0   0     0   0   46 42                 88
1675275 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_5 0 0 63 0   0     0   0   40 23 *                     63.0 0 0 63 0   0     0   0   40 23                 63
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1679111 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield - Mittineague   Regular School No Elementary 01 05 2021   grade_5 19 1 9 0   3     0   2   16 18 *                     34.0 19 1 9 0   3     0   2   16 18                 34
2040822 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_5 1 10 8 0   0     0   0   14 5                       19.0 1 10 8 0   0     0   0   14 5                 19
2041169 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2019   grade_5 52 4 4 0   31     0   1   43 49                       92.0 52 4 4 0   31     0   1   43 49                 92
2041654 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 05 2019   grade_5 0 0 39 0   0     0   0   16 23                       39.0 0 0 39 0   0     0   0   16 23                 39
2041867 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2019   grade_5 78 1 7 0   0     0   1   40 47                       87.0 78 1 7 0   0     0   1   40 47                 87
2041894 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_5 39 5 16 0   1     0   5   35 31                       66.0 39 5 16 0   1     0   5   35 31                 66
2041899 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2019   grade_5 51 2 6 0   1     0   1   33 28                       61.0 51 2 6 0   1     0   1   33 28                 61
2041904 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2019   grade_5 42 1 7 0   0     0   1   33 18                       51.0 42 1 7 0   0     0   1   33 18                 51
2041909 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2019   grade_5 29 2 2 0   1     0   4   21 17                       38.0 29 2 2 0   1     0   4   21 17                 38
2042769 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2043053 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_5 11 1 141 0   3     0   1   77 80                       157.0 11 1 141 0   3     0   1   77 80                 157
2043096 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_5 1 0 87 0   0     0   0   45 43                       88.0 1 0 87 0   0     0   0   45 43                 88
2043101 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_5 2 0 101 0   1     0   0   50 53                       104.0 2 0 101 0   1     0   0   50 53                 104
2043114 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_5 1 0 42 0   0     0   0   24 19                       43.0 1 0 42 0   0     0   0   24 19                 43
2043145 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_5 0 0 8 0   0     0   0   7 1                       8.0 0 0 8 0   0     0   0   7 1                 8
2043598 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_5 4 4 67 0   6     0   3   36 48                       84.0 4 4 67 0   6     0   3   36 48                 84
2043650 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2019   grade_5 8 10 50 0   6     0   2   36 40                       76.0 8 10 50 0   6     0   2   36 40                 76
2044058 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_5 108 2 4 0   0     0   12   56 70                       126.0 108 2 4 0   0     0   12   56 70                 126
2044063 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2019   grade_5 121 3 4 1   1     0   6   74 62                       136.0 121 3 4 1   1     0   6   74 62                 136
2044632 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2019   grade_5 41 7 15 1   9     0   4   37 40                       77.0 41 7 15 1   9     0   4   37 40                 77
2044639 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2019   grade_5 61 1 7 1   10     0   4   43 41                       84.0 61 1 7 1   10     0   4   43 41                 84
2044644 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2019   grade_5 33 2 2 0   5     0   3   26 19                       45.0 33 2 2 0   5     0   3   26 19                 45
2044649 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_5 74 1 7 0   8     0   4   40 54                       94.0 74 1 7 0   8     0   4   40 54                 94
2044654 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2019   grade_5 49 3 15 0   2     0   5   37 37                       74.0 49 3 15 0   2     0   5   37 37                 74
2044827 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_5 32 4 14 0   2     0   2   29 25                       54.0 32 4 14 0   2     0   2   29 25                 54
2044832 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2019   grade_5 16 2 6 0   3     0   3   14 16                       30.0 16 2 6 0   3     0   3   14 16                 30
2044837 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2019   grade_5 38 7 3 0   3     0   0   24 27                       51.0 38 7 3 0   3     0   0   24 27                 51
2044842 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2019   grade_5 38 7 6 0   1     0   2   29 25                       54.0 38 7 6 0   1     0   2   29 25                 54
2044847 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary 01 05 2019   grade_5 28 4 0 0   4     0   1   21 16                       37.0 28 4 0 0   4     0   1   21 16                 37
2045851 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2019   grade_5 2 4 10 0   0     0   0   15 1                       16.0 2 4 10 0   0     0   0   15 1                 16
2046926 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2019   grade_5 23 1 19 0   7     0   2   27 25                       52.0 23 1 19 0   7     0   2   27 25                 52
2046931 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2019   grade_5 19 0 5 0   2     0   4   13 17                       30.0 19 0 5 0   2     0   4   13 17                 30
2229940 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_5 4 9 5 0   0     0   0   16 2                       18.0 4 9 5 0   0     0   0   16 2                 18
2230001 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_5 2 20 26 0   0     0   3   29 22                       51.0 2 20 26 0   0     0   3   29 22                 51
2230347 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_5 79 5 4 0   22     0   0   55 55                       110.0 79 5 4 0   22     0   0   55 55                 110
2231156 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_5 91 1 1 0   0     0   6   56 43                       99.0 91 1 1 0   0     0   6   56 43                 99
2231189 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_5 41 5 20 1   2     0   5   39 35                       74.0 41 5 20 1   2     0   5   39 35                 74
2231195 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_5 52 2 6 0   2     0   4   34 32                       66.0 52 2 6 0   2     0   4   34 32                 66
2231201 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_5 49 6 8 0   1     0   5   27 42                       69.0 49 6 8 0   1     0   5   27 42                 69
2231207 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_5 35 2 8 0   0     0   1   31 15                       46.0 35 2 8 0   0     0   1   31 15                 46
2231496 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_5 17 19 67 0   4     0   3   54 56                       110.0 17 19 67 0   4     0   3   54 56                 110
2232584 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence: South Lawrence East Elementary School   Regular School No Elementary 01 05 2018   grade_5 5 2 127 0   1     0   2   73 64                       137.0 5 2 127 0   1     0   2   73 64                 137
2232644 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_5 2 0 88 0   0     0   1   52 39                       91.0 2 0 88 0   0     0   1   52 39                 91
2232660 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_5 0 0 60 0   0     0   1   30 31                       61.0 0 0 60 0   0     0   1   30 31                 61
2232698 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_5 1 0 8 0   0     0   1   9 1                       10.0 1 0 8 0   0     0   1   9 1                 10
2233238 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn: Robert L Ford   Regular School No Elementary 01 05 2018   grade_5 7 9 81 0   7     0   1   48 57                       105.0 7 9 81 0   7     0   1   48 57                 105
2233299 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn: Tracy   Regular School No Elementary 01 05 2018   grade_5 3 5 74 0   4     0   0   47 39                       86.0 3 5 74 0   4     0   0   47 39                 86
2233784 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough: Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2018   grade_5 115 4 8 1   1     0   5   66 68                       134.0 115 4 8 1   1     0   5   66 68                 134
2233790 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough: Mary K. Goode Elementary School   Regular School No Elementary 01 05 2018   grade_5 114 7 3 2   0     0   3   65 64                       129.0 114 7 3 2   0     0   3   65 64                 129
2234696 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood: Balch   Regular School No Elementary 01 05 2018   grade_5 33 5 16 0   4     0   2   30 30                       60.0 33 5 16 0   4     0   2   30 30                 60
2234702 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood: Cornelius M Callahan   Regular School No Elementary 01 05 2018   grade_5 34 5 3 0   1     0   1   22 22                       44.0 34 5 3 0   1     0   1   22 22                 44
2234708 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood: F A Cleveland   Regular School No Elementary 01 05 2018   grade_5 51 6 4 0   8     1   1   28 43                       71.0 51 6 4 0   8     1   1   28 43                 71
2234714 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood: John P Oldham   Regular School No Elementary 01 05 2018   grade_5 27 4 2 0   1     0   0   17 17                       34.0 27 4 2 0   1     0   0   17 17                 34
2235022 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth: Hedge   Regular School No Elementary 01 05 2018   grade_5 33 1 2 0   2     0   3   26 15                       41.0 33 1 2 0   2     0   3   26 15                 41
2237190 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield: John R Fausey   Regular School No Elementary 01 05 2018   grade_5 60 4 13 0   6     1   1   49 36                       85.0 60 4 13 0   6     1   1   49 36                 85
2237196 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield: Memorial   Regular School No Elementary 01 05 2018   grade_5 37 4 17 0   8     0   3   43 26                       69.0 37 4 17 0   8     0   3   43 26                 69
2237202 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield: Mittineague   Regular School No Elementary 01 05 2018   grade_5 19 1 7 0   0     0   1   11 17                       28.0 19 1 7 0   0     0   1   11 17                 28
737780 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_5 124 1 3 0   3     1   2   72 62                       134 124 1 3 0   3     1   2   72 62                 134

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