enrollments

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

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,218 ✖
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
2230208 2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
737009 737009 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 01 05 2015   grade_5 62 1 4 0   7     0   0   35 39                       74 62 1 4 0   7     0   0   35 39                 74
737020 737020 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2015   grade_5 67 2 2 0   17     0   2   46 44                       90 67 2 2 0   17     0   2   46 44                 90
737031 737031 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 01 05 2015   grade_5 34 2 3 0   8     0   1   22 26                       48 34 2 3 0   8     0   1   22 26                 48
737715 737715 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2015   grade_5 92 2 1 1   0     0   3   39 60                       99 92 2 1 1   0     0   3   39 60                 99
737743 737743 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2015   grade_5 21 3 13 0   3     0   3   26 17                       43 21 3 13 0   3     0   3   26 17                 43
737748 737748 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2015   grade_5 46 2 10 0   1     0   1   31 29                       60 46 2 10 0   1     0   1   31 29                 60
737753 737753 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2015   grade_5 55 3 5 0   0     0   1   35 29                       64 55 3 5 0   0     0   1   35 29                 64
737758 737758 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2015   grade_5 31 2 1 0   1     0   2   20 17                       37 31 2 1 0   1     0   2   20 17                 37
738946 738946 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_5 2 3 89 0   0     0   0   58 36                       94 2 3 89 0   0     0   0   58 36                 94
738959 738959 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_5 1 0 69 0   0     0   0   34 36                       70 1 0 69 0   0     0   0   34 36                 70
739013 739013 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_5 1 1 14 0   0     0   0   14 2                       16 1 1 14 0   0     0   0   14 2                 16
739318 739318 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_5 * * * *   *     *   *   2 *                       2                         2                   2
739421 739421 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2015   grade_5 11 10 24 1   8     0   1   28 27                       55 11 10 24 1   8     0   1   28 27                 55
739453 739453 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_5 8 8 62 1   7     0   3   52 37                       89 8 8 62 1   7     0   3   52 37                 89
739507 739507 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2015   grade_5 7 7 35 0   8     0   1   31 27                       58 7 7 35 0   8     0   1   31 27                 58
739919 739919 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_5 122 0 11 1   0     0   4   68 70                       138 122 0 11 1   0     0   4   68 70                 138
739924 739924 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2015   grade_5 123 3 2 0   2     0   2   67 65                       132 123 3 2 0   2     0   2   67 65                 132
740189 740189 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_5 15 6 14 0   0     1   2   24 14                       38 15 6 14 0   0     1   2   24 14                 38
740698 740698 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2015   grade_5 39 8 10 0   3     0   1   31 30                       61 39 8 10 0   3     0   1   31 30                 61
740703 740703 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2015   grade_5 34 5 3 0   1     0   0   21 22                       43 34 5 3 0   1     0   0   21 22                 43
740708 740708 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2015   grade_5 48 3 2 0   4     0   0   29 28                       57 48 3 2 0   4     0   0   29 28                 57
740713 740713 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2015   grade_5 35 7 1 0   2     1   0   26 20                       46 35 7 1 0   2     1   0   26 20                 46
741709 741709 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2015   grade_5 37 1 38 0   0     0   0   39 37                       76 37 1 38 0   0     0   0   39 37                 76
741716 741716 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2015   grade_5 45 0 49 0   0     0   0   42 52                       94 45 0 49 0   0     0   0   42 52                 94
742817 742817 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2015   grade_5 23 1 13 0   2     0   0   18 21                       39 23 1 13 0   2     0   0   18 21                 39
742822 742822 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_5 19 1 7 0   0     0   0   18 9                       27 19 1 7 0   0     0   0   18 9                 27
742827 742827 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2015   grade_5 44 2 5 0   2     0   1   24 30                       54 44 2 5 0   2     0   1   24 30                 54
933886 933886 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_5 58 5 5 1   15     0   2   43 43                       86 58 5 5 1   15     0   2   43 43                 86
934574 934574 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2016   grade_5 73 2 2 0   0     0   4   46 35                       81 73 2 2 0   0     0   4   46 35                 81
934600 934600 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2016   grade_5 37 10 16 0   2     0   5   31 39                       70 37 10 16 0   2     0   5   31 39                 70
934605 934605 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2016   grade_5 42 2 6 0   2     0   2   24 30                       54 42 2 6 0   2     0   2   24 30                 54
934610 934610 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2016   grade_5 48 5 1 1   1     0   0   33 23                       56 48 5 1 1   1     0   0   33 23                 56
934615 934615 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2016   grade_5 27 2 2 1   1     0   0   16 17                       33 27 2 2 1   1     0   0   16 17                 33
935453 935453 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_5 * * * *   *     *   *   3 1                       4                         3 1                 4
935473 935473 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_5 54 0 77 0   5     2   2   64 76                       140 54 0 77 0   5     2   2   64 76                 140
935794 935794 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_5 3 0 101 0   0     0   0   57 47                       104 3 0 101 0   0     0   0   57 47                 104
935807 935807 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_5 3 0 50 0   0     0   0   25 28                       53 3 0 50 0   0     0   0   25 28                 53
935862 935862 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_5 3 0 15 0   0     0   0   16 2                       18 3 0 15 0   0     0   0   16 2                 18
936269 936269 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_5 7 2 26 1   6     0   5   24 23                       47 7 2 26 1   6     0   5   24 23                 47
936301 936301 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2016   grade_5 10 5 62 0   9     0   2   47 41                       88 10 5 62 0   9     0   2   47 41                 88
936355 936355 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_5 4 7 45 1   4     0   2   35 28                       63 4 7 45 1   4     0   2   35 28                 63
936764 936764 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_5 109 3 5 3   3     0   4   59 68                       127 109 3 5 3   3     0   4   59 68                 127
936769 936769 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2016   grade_5 98 1 5 1   2     0   5   48 64                       112 98 1 5 1   2     0   5   48 64                 112
937033 937033 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2016   grade_5 9 6 14 0   0     0   3   20 12                       32 9 6 14 0   0     0   3   20 12                 32
937527 937527 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2016   grade_5 19 12 16 0   2     0   0   25 24                       49 19 12 16 0   2     0   0   25 24                 49
937532 937532 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_5 36 3 9 0   2     0   2   25 27                       52 36 3 9 0   2     0   2   25 27                 52
937537 937537 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2016   grade_5 55 6 2 0   6     0   2   37 34                       71 55 6 2 0   6     0   2   37 34                 71
937542 937542 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_5 36 9 4 0   0     0   1   28 22                       50 36 9 4 0   0     0   1   28 22                 50
938512 938512 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2016   grade_5 38 2 49 0   0     0   1   43 47                       90 38 2 49 0   0     0   1   43 47                 90
938520 938520 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2016   grade_5 28 1 47 0   3     0   2   40 41                       81 28 1 47 0   3     0   2   40 41                 81
939622 939622 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2016   grade_5 32 0 14 1   0     0   0   25 22                       47 32 0 14 1   0     0   0   25 22                 47
939627 939627 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2016   grade_5 19 1 9 0   1     0   1   19 12                       31 19 1 9 0   1     0   1   19 12                 31
939632 939632 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2016   grade_5 38 0 2 0   2     0   1   25 18                       43 38 0 2 0   2     0   1   25 18                 43
1123136 1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1123529 1123529 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_5 55 2 4 0   14     0   0   29 46                       75 55 2 4 0   14     0   0   29 46                 75
1124340 1124340 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_5 89 0 2 0   1     0   5   48 49                       97 89 0 2 0   1     0   5   48 49                 97
1124372 1124372 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_5 32 4 14 0   3     0   2   31 24                       55 32 4 14 0   3     0   2   31 24                 55
1124378 1124378 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_5 50 3 3 0   1     0   1   37 21                       58 50 3 3 0   1     0   1   37 21                 58
1124384 1124384 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_5 39 4 5 0   1     0   3   22 30                       52 39 4 5 0   1     0   3   22 30                 52
1124390 1124390 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_5 31 1 5 0   2     0   1   25 15                       40 31 1 5 0   2     0   1   25 15                 40
1125447 1125447 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_5 66 9 84 0   2     0   1   84 78                       162 66 9 84 0   2     0   1   84 78                 162
1125827 1125827 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_5 7 1 95 0   0     0   0   54 49                       103 7 1 95 0   0     0   0   54 49                 103
1125843 1125843 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_5 1 1 51 0   0     0   0   26 27                       53 1 1 51 0   0     0   0   26 27                 53
1125882 1125882 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_5 2 0 9 0   0     0   0   9 2                       11 2 0 9 0   0     0   0   9 2                 11
1126378 1126378 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_5 10 6 27 0   4     0   6   32 21                       53 10 6 27 0   4     0   6   32 21                 53
1126415 1126415 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_5 3 4 76 0   7     0   2   44 48                       92 3 4 76 0   7     0   2   44 48                 92
1126479 1126479 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_5 4 6 49 0   3     0   5   38 29                       67 4 6 49 0   3     0   5   38 29                 67
1126967 1126967 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_5 108 1 6 2   3     0   4   66 58                       124 108 1 6 2   3     0   4   66 58                 124
1126973 1126973 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_5 109 3 2 2   2     0   7   72 53                       125 109 3 2 2   2     0   7   72 53                 125
1127875 1127875 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_5 28 3 11 0   2     0   1   21 24                       45 28 3 11 0   2     0   1   21 24                 45
1127881 1127881 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_5 33 6 6 0   2     0   0   20 27                       47 33 6 6 0   2     0   0   20 27                 47
1127887 1127887 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_5 49 4 5 0   7     0   1   36 30                       66 49 4 5 0   7     0   1   36 30                 66
1127893 1127893 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_5 28 7 4 0   4     1   0   27 17                       44 28 7 4 0   4     1   0   27 17                 44
1129049 1129049 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_5 48 2 34 0   0     0   1   46 39                       85 48 2 34 0   0     0   1   46 39                 85
1129058 1129058 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 01 05 2017   grade_5 30 1 40 1   2     0   1   37 38                       75 30 1 40 1   2     0   1   37 38                 75
1130382 1130382 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2017   grade_5 18 2 15 0   2     0   1   20 18                       38 18 2 15 0   2     0   1   20 18                 38
1130388 1130388 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2017   grade_5 26 2 4 0   1     0   1   17 17                       34 26 2 4 0   1     0   1   17 17                 34
1130394 1130394 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary 01 05 2017   grade_5 46 0 5 0   1     0   3   27 28                       55 46 0 5 0   1     0   3   27 28                 55
1366047 1366047 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_5 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1366103 1366103 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_5 58 2 4 0   28     0   2   46 48 *                     94.0 58 2 4 0   28     0   2   46 48                 94
1366584 1366584 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_5 1 0 38 0   0     0   1   17 23 *                     40.0 1 0 38 0   0     0   1   17 23                 40
1366797 1366797 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_5 78 0 2 0   1     0   7   42 46 *                     88.0 78 0 2 0   1     0   7   42 46                 88
1366824 1366824 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_5 29 7 14 1   4     0   2   26 31 *                     57.0 29 7 14 1   4     0   2   26 31                 57
1366829 1366829 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_5 51 4 2 0   1     0   3   36 25 *                     61.0 51 4 2 0   1     0   3   36 25                 61
1366834 1366834 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_5 40 5 8 0   1     0   5   28 31 *                     59.0 40 5 8 0   1     0   5   28 31                 59
1366839 1366839 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_5 20 3 10 0   1     0   0   15 19 *                     34.0 20 3 10 0   1     0   0   15 19                 34
1367969 1367969 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_5 4 1 131 0   3     0   0   84 54 *                     139.0 4 1 131 0   3     0   0   84 54                 139
1368012 1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
1368017 1368017 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_5 3 0 84 0   1     0   0   50 37 *                     88.0 3 0 84 0   1     0   0   50 37                 88
1368030 1368030 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_5 1 0 56 0   0     0   0   30 26 *                     57.0 1 0 56 0   0     0   0   30 26                 57
1368527 1368527 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_5 3 9 62 0   7     0   2   44 39 *                     83.0 3 9 62 0   7     0   2   44 39                 83
1368557 1368557 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_5 3 0 5 0   0     0   0   7 * *                     8.0 3 0 5 0   0     0   0   7                   8
1368582 1368582 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2020   grade_5 4 11 48 0   2     0   8   35 38 *                     73.0 4 11 48 0   2     0   8   35 38                 73
1368987 1368987 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_5 96 2 2 0   2     0   14   75 41 *                     116.0 96 2 2 0   2     0   14   75 41                 116
1368992 1368992 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_5 100 4 3 1   0     0   6   49 65 *                     114.0 100 4 3 1   0     0   6   49 65                 114
1369098 1369098 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_5 67 3 1 0   0     1   3   35 39 *                     75.0 67 3 1 0   0     1   3   35 39                 75
1369559 1369559 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2020   grade_5 46 5 20 0   6     0   4   37 44 *                     81.0 46 5 20 0   6     0   4   37 44                 81
1369566 1369566 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2020   grade_5 62 3 5 1   11     0   2   53 31 *                     84.0 62 3 5 1   11     0   2   53 31                 84
1369571 1369571 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2020   grade_5 36 3 8 0   2     0   3   30 22 *                     52.0 36 3 8 0   2     0   3   30 22                 52

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