enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,731 ✖
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
1125430 1125430 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_2 50 2 84 2   0     0   2   86 54                       140 50 2 84 2   0     0   2   86 54                 140
1125444 1125444 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_2 17 2 26 0   0     0   2   25 22                       47 17 2 26 0   0     0   2   25 22                 47
1125802 1125802 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_2 6 4 124 0   0     0   1   67 68                       135 6 4 124 0   0     0   1   67 68                 135
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1125840 1125840 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_2 1 0 75 0   0     0   0   45 31                       76 1 0 75 0   0     0   0   45 31                 76
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1126375 1126375 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_2 11 10 35 0   7     0   4   38 29                       67 11 10 35 0   7     0   4   38 29                 67
1126412 1126412 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_2 8 4 60 0   9     0   2   49 34                       83 8 4 60 0   9     0   2   49 34                 83
1126476 1126476 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_2 9 11 62 0   2     0   8   42 50                       92 9 11 62 0   2     0   8   42 50                 92
1126964 1126964 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_2 85 1 1 0   2     1   10   64 36                       100 85 1 1 0   2     1   10   64 36                 100
1126970 1126970 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_2 103 3 2 1   0     0   1   44 66                       110 103 3 2 1   0     0   1   44 66                 110
1127872 1127872 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_2 29 3 22 0   1     0   3   27 31                       58 29 3 22 0   1     0   3   27 31                 58
1127878 1127878 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_2 32 4 1 0   0     0   1   21 17                       38 32 4 1 0   0     0   1   21 17                 38
1127884 1127884 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_2 52 2 6 0   7     0   1   41 27                       68 52 2 6 0   7     0   1   41 27                 68
1127890 1127890 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_2 35 5 4 0   4     0   0   22 26                       48 35 5 4 0   4     0   0   22 26                 48
1128574 1128574 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   grade_2 52 6 8 0   0     0   2   36 32                       68 52 6 8 0   0     0   2   36 32                 68
1128869 1128869 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_2 65 5 13 2   95     0   10   98 92                       190 65 5 13 2   95     0   10   98 92                 190
1129046 1129046 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_2 36 3 42 1   1     0   1   48 36                       84 36 3 42 1   1     0   1   48 36                 84
1129055 1129055 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 01 05 2017   grade_2 47 1 55 0   2     0   2   58 49                       107 47 1 55 0   2     0   2   58 49                 107
1129828 1129828 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No Elementary 01 04 2017   grade_2 41 0 2 0   2     0   3   25 23                       48 41 0 2 0   2     0   3   25 23                 48
1130185 1130185 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2017   grade_2 70 4 4 0   3     0   0   38 43                       81 70 4 4 0   3     0   0   38 43                 81
1130379 1130379 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2017   grade_2 26 3 13 0   6     0   2   25 25                       50 26 3 13 0   6     0   2   25 25                 50
1130385 1130385 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2017   grade_2 21 2 7 0   0     0   0   12 18                       30 21 2 7 0   0     0   0   12 18                 30
1130391 1130391 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary 01 05 2017   grade_2 40 1 5 0   0     0   1   26 21                       47 40 1 5 0   0     0   1   26 21                 47
1130550 1130550 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2017   grade_2 88 0 8 0   5     0   5   58 48                       106 88 0 8 0   5     0   5   58 48                 106
1130554 1130554 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2017   grade_2 92 1 10 0   5     0   4   57 55                       112 92 1 10 0   5     0   4   57 55                 112
1365122 1365122 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_2 148 0 12 0   3     0   5   81 87 *                     168.0 148 0 12 0   3     0   5   81 87                 168
1366044 1366044 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_2 2 5 2 0   0     0   0   6 3 *                     9.0 2 5 2 0   0     0   0   6 3                 9
1366100 1366100 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_2 40 4 4 0   19     1   3   42 29 *                     71.0 40 4 4 0   19     1   3   42 29                 71
1366573 1366573 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_2 6 10 108 0   0     0   7   66 65 *                     131.0 6 10 108 0   0     0   7   66 65                 131
1366577 1366577 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_2 20 7 122 0   0     0   1   74 76 *                     150.0 20 7 122 0   0     0   1   74 76                 150
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1366587 1366587 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_2 12 7 124 0   0     0   2   66 79 *                     145.0 12 7 124 0   0     0   2   66 79                 145
1366794 1366794 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_2 68 1 1 0   1     0   7   40 38 *                     78.0 68 1 1 0   1     0   7   40 38                 78
1366821 1366821 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_2 33 4 15 0   1     1   1   28 27 *                     55.0 33 4 15 0   1     1   1   28 27                 55
1366826 1366826 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_2 40 2 4 0   0     0   2   28 20 *                     48.0 40 2 4 0   0     0   2   28 20                 48
1366831 1366831 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_2 37 5 5 0   1     0   4   23 29 *                     52.0 37 5 5 0   1     0   4   23 29                 52
1366836 1366836 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_2 22 2 5 0   1     0   1   21 10 *                     31.0 22 2 5 0   1     0   1   21 10                 31
1367196 1367196 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_2 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367966 1367966 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_2 5 3 129 0   2     0   0   68 71 *                     139.0 5 3 129 0   2     0   0   68 71                 139
1367997 1367997 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_2 3 3 133 0   1     0   0   68 72 *                     140.0 3 3 133 0   1     0   0   68 72                 140
1368009 1368009 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_2 1 2 84 0   0     0   0   42 45 *                     87.0 1 2 84 0   0     0   0   42 45                 87
1368014 1368014 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_2 3 1 83 0   0     0   0   41 46 *                     87.0 3 1 83 0   0     0   0   41 46                 87
1368027 1368027 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_2 1 0 54 0   0     0   0   33 22 *                     55.0 1 0 54 0   0     0   0   33 22                 55
1368524 1368524 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_2 3 9 80 0   9     0   4   51 54 *                     105.0 3 9 80 0   9     0   4   51 54                 105
1368554 1368554 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_2 1 0 5 0   0     0   0   6 * *                     6.0 1 0 5 0   0     0   0   6                   6
1368579 1368579 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2020   grade_2 6 8 72 0   7     0   0   45 48 *                     93.0 6 8 72 0   7     0   0   45 48                 93
1368702 1368702 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_2 97 2 9 0   0     0   4   63 49 *                     112.0 97 2 9 0   0     0   4   63 49                 112
1368984 1368984 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_2 94 3 3 3   1     0   5   62 47 *                     109.0 94 3 3 3   1     0   5   62 47                 109
1368989 1368989 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_2 113 3 4 0   0     0   7   58 69 *                     127.0 113 3 4 0   0     0   7   58 69                 127
1369095 1369095 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_2 52 1 7 0   1     0   1   30 32 *                     62.0 52 1 7 0   1     0   1   30 32                 62
1369556 1369556 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2020   grade_2 31 3 22 0   7     0   2   31 34 *                     65.0 31 3 22 0   7     0   2   31 34                 65
1369563 1369563 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2020   grade_2 53 5 5 0   6     0   3   44 28 *                     72.0 53 5 5 0   6     0   3   44 28                 72
1369568 1369568 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2020   grade_2 39 1 4 0   1     0   4   24 25 *                     49.0 39 1 4 0   1     0   4   24 25                 49
1369573 1369573 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_2 70 2 7 0   12     0   3   50 44 *                     94.0 70 2 7 0   12     0   3   50 44                 94
1369578 1369578 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2020   grade_2 43 1 6 0   1     0   0   27 24 *                     51.0 43 1 6 0   1     0   0   27 24                 51
1369750 1369750 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_2 32 5 26 0   4     1   2   36 34 *                     70.0 32 5 26 0   4     1   2   36 34                 70
1369755 1369755 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2020   grade_2 33 6 1 0   6     0   1   23 24 *                     47.0 33 6 1 0   6     0   1   23 24                 47
1369760 1369760 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2020   grade_2 35 3 9 0   5     1   4   31 26 *                     57.0 35 3 9 0   5     1   4   31 26                 57
1369765 1369765 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2020   grade_2 35 13 5 0   3     0   1   31 26 *                     57.0 35 13 5 0   3     0   1   31 26                 57
1370587 1370587 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_2 57 11 18 4   77     0   13   102 78 *                     180.0 57 11 18 4   77     0   13   102 78                 180
1370774 1370774 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_2 0 3 5 0   0     0   0   7 1 *                     8.0 0 3 5 0   0     0   0   7 1                 8
1371707 1371707 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2020   grade_2 78 2 4 0   1     0   5   49 41 *                     90.0 78 2 4 0   1     0   5   49 41                 90
1371844 1371844 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary 01 05 2020   grade_2 56 2 12 0   5     0   1   31 45 *                     76.0 56 2 12 0   5     0   1   31 45                 76
1371849 1371849 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2020   grade_2 20 1 9 0   0     0   1   13 18 *                     31.0 20 1 9 0   0     0   1   13 18                 31
1371854 1371854 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2020   grade_2 25 2 6 0   1     0   1   14 21 *                     35.0 25 2 6 0   1     0   1   14 21                 35
1371981 1371981 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2020   grade_2 126 4 5 0   6     0   7   68 80 *                     148.0 126 4 5 0   6     0   7   68 80                 148
1371984 1371984 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2020   grade_2 99 1 7 0   6     0   5   55 63 *                     118.0 99 1 7 0   6     0   5   55 63                 118
1373778 1373778 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_2 12 0 0 0   0     0   0   7 5 *                     12.0 12 0 0 0   0     0   0   7 5                 12
1672346 1672346 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown - Swift River Elementary   Regular School No Elementary 01 03 2021   grade_2 120 2 11 0   2     0   11   68 78 *                     146.0 120 2 11 0   2     0   11   68 78                 146
1673279 1673279 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1673334 1673334 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_2 38 1 2 0   24     1   2   38 30 *                     68.0 38 1 2 0   24     1   2   38 30                 68
1673804 1673804 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_2 13 4 125 0   0     0   2   72 72 *                     144.0 13 4 125 0   0     0   2   72 72                 144
1673808 1673808 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_2 15 9 105 0   0     0   2   57 74 *                     131.0 15 9 105 0   0     0   2   57 74                 131
1673812 1673812 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_2 6 4 102 0   0     0   0   55 57 *                     112.0 6 4 102 0   0     0   0   55 57                 112
1673818 1673818 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_2 11 3 113 0   1     0   0   61 67 *                     128.0 11 3 113 0   1     0   0   61 67                 128
1674023 1674023 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth - Joseph Demello   Regular School No Elementary 01 05 2021   grade_2 51 1 2 0   1     0   4   31 28 *                     59.0 51 1 2 0   1     0   4   31 28                 59
1674050 1674050 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham - Avery   Regular School No Elementary 01 05 2021   grade_2 28 3 15 0   1     0   2   23 26 *                     49.0 28 3 15 0   1     0   2   23 26                 49
1674055 1674055 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham - Greenlodge   Regular School No Elementary 01 05 2021   grade_2 40 0 8 0   0     0   4   26 26 *                     52.0 40 0 8 0   0     0   4   26 26                 52
1674060 1674060 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham - Oakdale   Regular School No Elementary 01 05 2021   grade_2 24 4 4 0   0     0   4   19 17 *                     36.0 24 4 4 0   0     0   4   19 17                 36
1674065 1674065 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham - Riverdale   Regular School No Elementary 01 05 2021   grade_2 34 1 4 0   4     0   3   20 26 *                     46.0 34 1 4 0   4     0   3   20 26                 46
1675211 1675211 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_2 6 5 127 0   5     0   1   72 72 *                     144.0 6 5 127 0   5     0   1   72 72                 144
1675242 1675242 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_2 2 2 106 0   1     0   0   63 48 *                     111.0 2 2 106 0   1     0   0   63 48                 111
1675254 1675254 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_2 3 1 72 0   0     0   0   42 33 *                     76.0 3 1 72 0   0     0   0   42 33                 76
1675259 1675259 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_2 1 0 87 0   1     0   0   49 40 *                     89.0 1 0 87 0   1     0   0   49 40                 89
1675272 1675272 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_2 2 0 57 0   0     0   0   34 25 *                     59.0 2 0 57 0   0     0   0   34 25                 59
1675766 1675766 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn - Robert L Ford   Regular School No Elementary 01 05 2021   grade_2 5 10 73 0   6     0   3   51 46 *                     97.0 5 10 73 0   6     0   3   51 46                 97
1675796 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
1675820 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
1675943 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
1676232 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
1676237 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
1676342 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
1676803 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
1676810 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
1676815 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
1676820 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
1676825 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
1676997 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
1677002 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

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