enrollments

Data source: Big Local News · About: Big Local

972 rows where grade = "grade_2", state = "MA" and year = 2020 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 972 ✖

grade ✖

  • grade_2 · 972 ✖
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
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
1367598 1367598 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_2 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1367682 1367682 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_2 * * * *   *     *   *   1 * *                     1.0                         1                   1
1368459 1368459 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1368608 1368608 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1373605 1373605 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   grade_2 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1374309 1374309 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1364817 1364817 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_2 56 0 6 0   2     0   5   39 30 *                     69.0 56 0 6 0   2     0   5   39 30                 69
1364841 1364841 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_2 58 0 9 0   0     0   4   42 29 *                     71.0 58 0 9 0   0     0   4   42 29                 71
1365045 1365045 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_2 62 0 5 0   4     0   4   36 39 *                     75.0 62 0 5 0   4     0   4   36 39                 75
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
1365166 1365166 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2020   grade_2 32 0 3 0   24     0   13   41 31 *                     72.0 32 0 3 0   24     0   13   41 31                 72
1365240 1365240 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 04 2020   grade_2 49 0 6 0   3     0   4   28 34 *                     62.0 49 0 6 0   3     0   4   28 34                 62
1365683 1365683 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2020   grade_2 2 0 36 0   3     0   0   23 18 *                     41.0 2 0 36 0   3     0   0   23 18                 41
1366075 1366075 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   grade_2 78 0 1 0   2     0   6   41 46 *                     87.0 78 0 1 0   2     0   6   41 46                 87
1366089 1366089 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2020   grade_2 41 0 1 0   21     0   1   34 30 *                     64.0 41 0 1 0   21     0   1   34 30                 64
1366130 1366130 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_2 54 0 1 0   0     0   2   36 21 *                     57.0 54 0 1 0   0     0   2   36 21                 57
1366137 1366137 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_2 40 0 0 0   0     0   0   18 22 *                     40.0 40 0 0 0   0     0   0   18 22                 40
1366258 1366258 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_2 36 0 3 0   0     0   2   23 18 *                     41.0 36 0 3 0   0     0   2   23 18                 41
1366514 1366514 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_2 52 0 4 0   4     0   5   31 34 *                     65.0 52 0 4 0   4     0   5   31 34                 65
1366613 1366613 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2020   grade_2 49 0 20 0   2     0   1   35 37 *                     72.0 49 0 20 0   2     0   1   35 37                 72
1366628 1366628 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2020   grade_2 29 0 6 0   1     0   2   18 20 *                     38.0 29 0 6 0   1     0   2   18 20                 38
1366640 1366640 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2020   grade_2 18 0 5 0   1     0   0   14 10 *                     24.0 18 0 5 0   1     0   0   14 10                 24
1366684 1366684 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_2 31 0 1 0   0     0   0   19 13 *                     32.0 31 0 1 0   0     0   0   19 13                 32
1366737 1366737 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No Elementary PK 05 2020   grade_2 58 0 5 0   5     0   4   34 38 *                     72.0 58 0 5 0   5     0   4   34 38                 72
1366747 1366747 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   grade_2 14 0 2 0   0     0   0   9 7 *                     16.0 14 0 2 0   0     0   0   9 7                 16
1366773 1366773 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No Elementary KG 05 2020   grade_2 42 0 2 0   0     0   0   25 19 *                     44.0 42 0 2 0   0     0   0   25 19                 44
1366851 1366851 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2020   grade_2 50 0 2 0   0     0   2   27 27 *                     54.0 50 0 2 0   0     0   2   27 27                 54
1366859 1366859 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2020   grade_2 68 0 5 0   0     0   6   39 40 *                     79.0 68 0 5 0   0     0   6   39 40                 79
1366946 1366946 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2020   grade_2 32 0 5 0   3     0   2   20 22 *                     42.0 32 0 5 0   3     0   2   20 22                 42
1366952 1366952 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2020   grade_2 27 0 5 1   1     0   3   18 19 *                     37.0 27 0 5 1   1     0   3   18 19                 37
1367022 1367022 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   grade_2 10 0 0 0   0     0   0   5 5 *                     10.0 10 0 0 0   0     0   0   5 5                 10
1367102 1367102 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No Elementary PK 05 2020   grade_2 66 0 2 1   2     0   4   43 32 *                     75.0 66 0 2 1   2     0   4   43 32                 75
1367395 1367395 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2020   grade_2 53 0 6 0   10     1   1   40 31 *                     71.0 53 0 6 0   10     1   1   40 31                 71
1367407 1367407 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_2 66 0 4 0   3     0   0   45 28 *                     73.0 66 0 4 0   3     0   0   45 28                 73
1367425 1367425 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_2 19 0 1 0   0     0   3   11 12 *                     23.0 19 0 1 0   0     0   3   11 12                 23
1367464 1367464 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_2 100 0 2 0   2     0   2   54 52 *                     106.0 100 0 2 0   2     0   2   54 52                 106
1367477 1367477 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2020   grade_2 34 0 10 0   1     0   4   22 27 *                     49.0 34 0 10 0   1     0   4   22 27                 49
1367483 1367483 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2020   grade_2 22 0 2 0   0     0   0   11 13 *                     24.0 22 0 2 0   0     0   0   11 13                 24
1367490 1367490 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2020   grade_2 33 0 2 0   0     0   1   19 17 *                     36.0 33 0 2 0   0     0   1   19 17                 36
1367525 1367525 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_2 98 0 4 0   24     0   3   73 56 *                     129.0 98 0 4 0   24     0   3   73 56                 129
1367539 1367539 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2020   grade_2 43 0 7 0   0     0   5   32 23 *                     55.0 43 0 7 0   0     0   5   32 23                 55
1367558 1367558 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2020   grade_2 47 0 4 0   1     0   1   33 20 *                     53.0 47 0 4 0   1     0   1   33 20                 53
1367605 1367605 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary 02 04 2020   grade_2 158 0 8 0   1     0   2   90 79 *                     169.0 158 0 8 0   1     0   2   90 79                 169
1367633 1367633 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   grade_2 20 0 1 0   0     0   0   10 11 *                     21.0 20 0 1 0   0     0   0   10 11                 21
1367722 1367722 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2020   grade_2 66 0 2 0   0     0   2   35 35 *                     70.0 66 0 2 0   0     0   2   35 35                 70
1367728 1367728 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2020   grade_2 65 0 8 0   1     0   6   43 37 *                     80.0 65 0 8 0   1     0   6   43 37                 80
1367781 1367781 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   grade_2 164 0 13 2   18     0   13   109 101 *                     210.0 164 0 13 2   18     0   13   109 101                 210
1367835 1367835 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_2 3 0 33 0   1     0   0   23 14 *                     37.0 3 0 33 0   1     0   0   23 14                 37
1367897 1367897 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2020   grade_2 34 0 9 0   1     0   1   28 17 *                     45.0 34 0 9 0   1     0   1   28 17                 45
1367935 1367935 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary KG 05 2020   grade_2 61 0 4 0   0     0   1   32 34 *                     66.0 61 0 4 0   0     0   1   32 34                 66
1367955 1367955 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2020   grade_2 146 0 4 1   2     0   1   82 72 *                     154.0 146 0 4 1   2     0   1   82 72                 154
1367972 1367972 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_2 2 0 120 0   0     0   0   64 58 0                     122.0 2 0 120 0   0     0   0   64 58 0               122
1367989 1367989 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   grade_2 10 0 89 0   6     0   1   53 53 *                     106.0 10 0 89 0   6     0   1   53 53                 106
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
1368033 1368033 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_2 3 0 67 0   1     0   0   34 37 *                     71.0 3 0 67 0   1     0   0   34 37                 71
1368059 1368059 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_2 1 0 6 0   0     0   0   6 1 *                     7.0 1 0 6 0   0     0   0   6 1                 7
1368072 1368072 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2020   grade_2 51 0 3 0   3     0   1   31 27 *                     58.0 51 0 3 0   3     0   1   31 27                 58
1368101 1368101 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2020   grade_2 37 0 3 0   1     0   5   23 23 *                     46.0 37 0 3 0   1     0   5   23 23                 46
1368160 1368160 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2020   grade_2 16 0 0 0   0     0   4   14 6 *                     20.0 16 0 0 0   0     0   4   14 6                 20
1368235 1368235 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2020   grade_2 112 0 4 0   20     0   1   61 76 *                     137.0 112 0 4 0   20     0   1   61 76                 137
1368248 1368248 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2020   grade_2 49 0 1 0   11     0   6   33 34 *                     67.0 49 0 1 0   11     0   6   33 34                 67
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
1368722 1368722 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2020   grade_2 47 0 5 0   0     0   1   26 27 *                     53.0 47 0 5 0   0     0   1   26 27                 53
1368754 1368754 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2020   grade_2 41 0 0 0   0     0   0   22 19 *                     41.0 41 0 0 0   0     0   0   22 19                 41
1368760 1368760 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2020   grade_2 46 0 2 0   0     0   1   24 25 *                     49.0 46 0 2 0   0     0   1   24 25                 49
1368773 1368773 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary KG 05 2020   grade_2 55 0 1 0   0     0   0   26 30 *                     56.0 55 0 1 0   0     0   0   26 30                 56
1368780 1368780 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No Elementary PK 05 2020   grade_2 56 0 3 0   0     0   3   35 27 *                     62.0 56 0 3 0   0     0   3   35 27                 62
1368808 1368808 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2020   grade_2 50 0 3 0   2     0   5   29 31 *                     60.0 50 0 3 0   2     0   5   29 31                 60
1368914 1368914 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No Elementary KG 05 2020   grade_2 43 0 0 0   0     0   5   20 28 *                     48.0 43 0 0 0   0     0   5   20 28                 48
1369046 1369046 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 05 2020   grade_2 75 0 15 1   2     0   2   47 48 *                     95.0 75 0 15 1   2     0   2   47 48                 95
1369110 1369110 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2020   grade_2 13 0 1 0   0     0   0   8 6 *                     14.0 13 0 1 0   0     0   0   8 6                 14
1369136 1369136 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2020   grade_2 42 0 5 1   29     0   7   42 42 *                     84.0 42 0 5 1   29     0   7   42 42                 84
1369181 1369181 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Sunita L. Williams Elementary   Regular School No Elementary KG 05 2020   grade_2 73 0 2 0   10     0   7   51 41 *                     92.0 73 0 2 0   10     0   7   51 41                 92
1369420 1369420 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2020   grade_2 47 0 4 0   10     0   6   31 36 *                     67.0 47 0 4 0   10     0   6   31 36                 67
1369445 1369445 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 John Ward   Regular School No Elementary KG 05 2020   grade_2 27 0 2 0   4     0   2   21 14 *                     35.0 27 0 2 0   4     0   2   21 14                 35
1369489 1369489 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2020   grade_2 114 0 1 0   2     0   0   64 53 *                     117.0 114 0 1 0   2     0   0   64 53                 117
1369493 1369493 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2020   grade_2 31 0 1 1   0     0   2   23 12 *                     35.0 31 0 1 1   0     0   2   23 12                 35
1369509 1369509 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2020   grade_2 25 0 4 0   0     0   4   17 16 *                     33.0 25 0 4 0   0     0   4   17 16                 33
1369609 1369609 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2020   grade_2 37 0 1 0   2     0   0   22 18 *                     40.0 37 0 1 0   2     0   0   22 18                 40
1369629 1369629 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No Elementary KG 05 2020   grade_2 36 0 2 1   9     0   3   27 24 *                     51.0 36 0 2 1   9     0   3   27 24                 51
1369641 1369641 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No Elementary KG 05 2020   grade_2 27 0 6 0   4     0   2   17 22 *                     39.0 27 0 6 0   4     0   2   17 22                 39
1369647 1369647 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No Elementary KG 05 2020   grade_2 31 0 2 0   5     0   2   27 13 *                     40.0 31 0 2 0   5     0   2   27 13                 40
1369654 1369654 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2020   grade_2 118 0 15 0   0     0   4   79 58 *                     137.0 118 0 15 0   0     0   4   79 58                 137
1369691 1369691 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No Elementary KG 05 2020   grade_2 62 0 2 0   3     0   6   41 32 *                     73.0 62 0 2 0   3     0   6   41 32                 73
1369697 1369697 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No Elementary KG 05 2020   grade_2 40 0 4 0   4     1   2   26 25 *                     51.0 40 0 4 0   4     1   2   26 25                 51
1369711 1369711 MA Bristol   school 2509000 218   Norton 250900001450 2180010 L G Nourse Elementary   Regular School No Elementary KG 03 2020   grade_2 64 0 4 0   4     0   2   41 33 *                     74.0 64 0 4 0   4     0   2   41 33                 74
1369731 1369731 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No Elementary PK 05 2020   grade_2 70 0 2 0   4     0   3   46 33 *                     79.0 70 0 2 0   4     0   3   46 33                 79
1369738 1369738 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2020   grade_2 80 0 2 0   0     0   4   48 38 *                     86.0 80 0 2 0   0     0   4   48 38                 86
1369851 1369851 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2020   grade_2 28 0 1 0   0     0   0   16 13 *                     29.0 28 0 1 0   0     0   0   16 13                 29
1369891 1369891 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2020   grade_2 29 0 3 0   0     0   0   16 16 *                     32.0 29 0 3 0   0     0   0   16 16                 32
1369904 1369904 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2020   grade_2 10 0 3 0   1     0   1   10 5 *                     15.0 10 0 3 0   1     0   1   10 5                 15
1369918 1369918 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2020   grade_2 56 0 1 0   2     0   2   28 33 *                     61.0 56 0 1 0   2     0   2   28 33                 61
1369940 1369940 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2020   grade_2 6 0 2 0   0     0   0   6 2 *                     8.0 6 0 2 0   0     0   0   6 2                 8
1370023 1370023 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No Elementary KG 05 2020   grade_2 29 0 6 0   1     0   1   13 24 *                     37.0 29 0 6 0   1     0   1   13 24                 37
1370047 1370047 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No Elementary KG 05 2020   grade_2 38 0 2 0   0     0   1   12 29 *                     41.0 38 0 2 0   0     0   1   12 29                 41
1370085 1370085 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2020   grade_2 34 0 2 0   0     0   0   18 18 *                     36.0 34 0 2 0   0     0   0   18 18                 36
1370327 1370327 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_2 16 0 1 0   0     0   1   13 5 *                     18.0 16 0 1 0   0     0   1   13 5                 18
1370337 1370337 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2020   grade_2 73 0 2 0   0     0   3   41 37 *                     78.0 73 0 2 0   0     0   3   41 37                 78
1370383 1370383 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2020   grade_2 6 0 1 0   0     0   1   3 5 *                     8.0 6 0 1 0   0     0   1   3 5                 8

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