enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_2", state = "MA" and year = 2019 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 975 ✖

grade ✖

  • grade_2 · 975 ✖
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
2040875 2040875 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2042766 2042766 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_2 * * * *   *     *   *   2 *                       2.0                         2                   2
2043450 2043450 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 *                       1.0                         1                   1
2048832 2048832 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 04 2019   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2040312 2040312 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2019   grade_2 0 18 16 1   3     0   1   24 15                       39.0 0 18 16 1   3     0   1   24 15                 39
2040363 2040363 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   grade_2 0 28 10 0   0     0   2   18 22                       40.0 0 28 10 0   0     0   2   18 22                 40
2040368 2040368 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   grade_2 0 17 32 0   1     0   1   30 21                       51.0 0 17 32 0   1     0   1   30 21                 51
2040424 2040424 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   grade_2 0 36 35 0   0     0   1   32 40                       72.0 0 36 35 0   0     0   1   32 40                 72
2040458 2040458 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2019   grade_2 0 17 11 2   9     0   4   26 17                       43.0 0 17 11 2   9     0   4   26 17                 43
2040506 2040506 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   grade_2 0 28 19 0   0     0   2   27 22                       49.0 0 28 19 0   0     0   2   27 22                 49
2040649 2040649 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_2 0 16 41 0   0     0   1   27 31                       58.0 0 16 41 0   0     0   1   27 31                 58
2040700 2040700 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_2 0 47 37 1   2     2   3   45 47                       92.0 0 47 37 1   2     2   3   45 47                 92
2040778 2040778 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_2 0 6 38 0   0     0   2   19 27                       46.0 0 6 38 0   0     0   2   19 27                 46
2040841 2040841 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_2 0 40 20 1   0     0   3   29 35                       64.0 0 40 20 1   0     0   3   29 35                 64
2040895 2040895 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_2 0 27 32 0   0     0   1   29 31                       60.0 0 27 32 0   0     0   1   29 31                 60
2043623 2043623 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_2 0 1 5 0   0     0   0   5 1                       6.0 0 1 5 0   0     0   0   5 1                 6
2045849 2045849 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2019   grade_2 0 5 7 0   0     0   0   10 2                       12.0 0 5 7 0   0     0   0   10 2                 12
2047512 2047512 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   grade_2 0 28 13 1   0     0   0   21 21                       42.0 0 28 13 1   0     0   0   21 21                 42
2047599 2047599 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_2 0 0 42 0   0     0   0   15 27                       42.0 0 0 42 0   0     0   0   15 27                 42
2047674 2047674 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_2 0 16 4 0   0     0   0   7 13                       20.0 0 16 4 0   0     0   0   7 13                 20
2047798 2047798 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_2 0 0 84 0   0     0   0   35 49                       84.0 0 0 84 0   0     0   0   35 49                 84
2047999 2047999 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence   Regular School Yes Elementary KG 05 2019   grade_2 0 17 41 0   2     0   4   33 31                       64.0 0 17 41 0   2     0   4   33 31                 64
2040332 2040332 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_2 1 16 18 0   0     0   1   22 14                       36.0 1 16 18 0   0     0   1   22 14                 36
2040372 2040372 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   grade_2 1 44 13 0   1     0   1   30 30                       60.0 1 44 13 0   1     0   1   30 30                 60
2040403 2040403 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_2 1 56 20 0   2     0   1   44 36                       80.0 1 56 20 0   2     0   1   44 36                 80
2040726 2040726 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2019   grade_2 1 3 30 0   1     0   0   17 18                       35.0 1 3 30 0   1     0   0   17 18                 35
2040918 2040918 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2019   grade_2 1 17 61 0   3     0   0   45 37                       82.0 1 17 61 0   3     0   0   45 37                 82
2042890 2042890 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2019   grade_2 1 0 44 0   0     0   2   18 29                       47.0 1 0 44 0   0     0   2   18 29                 47
2043056 2043056 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_2 1 2 122 0   0     0   2   61 66                       127.0 1 2 122 0   0     0   2   61 66                 127
2043098 2043098 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_2 1 1 107 0   1     0   0   56 54                       110.0 1 1 107 0   1     0   0   56 54                 110
2043111 2043111 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_2 1 1 49 0   0     0   1   28 24                       52.0 1 1 49 0   0     0   1   28 24                 52
2043117 2043117 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_2 1 0 71 0   0     0   0   39 33                       72.0 1 0 71 0   0     0   0   39 33                 72
2045882 2045882 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2019   grade_2 1 10 33 0   0     0   0   25 19                       44.0 1 10 33 0   0     0   0   25 19                 44
2047572 2047572 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_2 1 34 5 0   0     0   0   15 25                       40.0 1 34 5 0   0     0   0   15 25                 40
2047587 2047587 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_2 1 40 6 0   0     0   3   24 26                       50.0 1 40 6 0   0     0   3   24 26                 50
2047643 2047643 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_2 1 1 42 0   0     0   0   22 22                       44.0 1 1 42 0   0     0   0   22 22                 44
2047817 2047817 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2019   grade_2 1 19 53 0   15     0   6   33 61                       94.0 1 19 53 0   15     0   6   33 61                 94
2047908 2047908 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   grade_2 1 81 50 0   0     0   5   61 76                       137.0 1 81 50 0   0     0   5   61 76                 137
2049288 2049288 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_2 1 43 22 2   0     1   1   33 37                       70.0 1 43 22 2   0     1   1   33 37                 70
2040343 2040343 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_2 10 6 4 0   1     0   0   12 9                       21.0 10 6 4 0   1     0   0   12 9                 21
2041212 2041212 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   grade_2 10 78 21 0   0     0   12   69 52                       121.0 10 78 21 0   0     0   12   69 52                 121
2041484 2041484 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2019   grade_2 10 12 2 0   9     0   9   24 18                       42.0 10 12 2 0   9     0   9   24 18                 42
2042103 2042103 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_2 10 11 53 1   3     0   0   48 30                       78.0 10 11 53 1   3     0   0   48 30                 78
2042880 2042880 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_2 10 2 24 0   2     0   0   25 13                       38.0 10 2 24 0   2     0   0   25 13                 38
2042910 2042910 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 05 2019   grade_2 10 0 51 0   0     0   0   32 29                       61.0 10 0 51 0   0     0   0   32 29                 61
2043107 2043107 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   grade_2 10 3 115 0   0     0   0   75 53                       128.0 10 3 115 0   0     0   0   75 53                 128
2043435 2043435 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No Elementary PK 04 2019   grade_2 10 0 9 0   17     0   6   27 15                       42.0 10 0 9 0   17     0   6   27 15                 42
2043595 2043595 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_2 10 8 68 0   5     0   5   42 54                       96.0 10 8 68 0   5     0   5   42 54                 96
2043607 2043607 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2019   grade_2 10 5 76 1   6     0   1   50 49                       99.0 10 5 76 1   6     0   1   50 49                 99
2043647 2043647 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2019   grade_2 10 7 66 0   6     0   5   53 41                       94.0 10 7 66 0   6     0   5   53 41                 94
2045457 2045457 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_2 10 0 1 0   0     0   1   7 5                       12.0 10 0 1 0   0     0   1   7 5                 12
2045855 2045855 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2019   grade_2 10 7 71 0   2     0   1   53 38                       91.0 10 7 71 0   2     0   1   53 38                 91
2045991 2045991 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2019   grade_2 10 7 22 0   4     0   0   25 18                       43.0 10 7 22 0   4     0   0   25 18                 43
2046017 2046017 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Sumner Avenue   Regular School No Elementary PK 05 2019   grade_2 10 11 46 0   2     0   6   41 34                       75.0 10 11 46 0   2     0   6   41 34                 75
2046534 2046534 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 02 2019   grade_2 10 1 24 0   2     0   1   20 18                       38.0 10 1 24 0   2     0   1   20 18                 38
2043319 2043319 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   grade_2 100 0 0 0   13     0   3   60 56                       116.0 100 0 0 0   13     0   3   60 56                 116
2043528 2043528 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2019   grade_2 100 3 8 0   4     0   3   56 62                       118.0 100 3 8 0   4     0   3   56 62                 118
2046674 2046674 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2019   grade_2 100 8 41 0   3     0   10   80 82                       162.0 100 8 41 0   3     0   10   80 82                 162
2048402 2048402 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2019   grade_2 101 1 2 0   0     0   8   58 54                       112.0 101 1 2 0   0     0   8   58 54                 112
2049034 2049034 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   grade_2 106 2 5 0   1     0   2   59 57                       116.0 106 2 5 0   1     0   2   59 57                 116
2044676 2044676 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2019   grade_2 107 4 4 0   6     0   3   71 53                       124.0 107 4 4 0   6     0   3   71 53                 124
2046602 2046602 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_2 107 13 14 1   1     0   18   66 88                       154.0 107 13 14 1   1     0   18   66 88                 154
2041782 2041782 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   grade_2 108 2 2 0   2     0   4   63 55                       118.0 108 2 2 0   2     0   4   63 55                 118
2047055 2047055 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_2 108 2 3 1   4     0   5   65 58                       123.0 108 2 3 1   4     0   5   65 58                 123
2047500 2047500 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2019   grade_2 108 2 8 0   3     0   3   65 59                       124.0 108 2 8 0   3     0   3   65 59                 124
2046431 2046431 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2019   grade_2 109 7 9 0   13     0   5   82 61                       143.0 109 7 9 0   13     0   5   82 61                 143
2040438 2040438 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_2 11 11 15 0   0     0   3   21 19                       40.0 11 11 15 0   0     0   3   21 19                 40
2040750 2040750 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_2 11 13 14 0   81     0   3   64 58                       122.0 11 13 14 0   81     0   3   64 58                 122
2042153 2042153 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_2 11 16 70 0   4     0   0   45 56                       101.0 11 16 70 0   4     0   0   45 56                 101
2043447 2043447 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_2 11 7 29 0   37     0   5   43 46                       89.0 11 7 29 0   37     0   5   43 46                 89
2043583 2043583 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_2 11 5 68 0   7     0   2   42 51                       93.0 11 5 68 0   7     0   2   42 51                 93
2044351 2044351 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary KG 05 2019   grade_2 11 12 30 0   1     0   3   33 24                       57.0 11 12 30 0   1     0   3   33 24                 57
2046740 2046740 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   grade_2 11 0 2 0   1     0   2   9 7                       16.0 11 0 2 0   1     0   2   9 7                 16
2047282 2047282 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary KG 06 2019   grade_2 11 2 34 0   1     0   1   25 24                       49.0 11 2 34 0   1     0   1   25 24                 49
2047721 2047721 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_2 11 16 7 0   2     0   4   15 25                       40.0 11 16 7 0   2     0   4   15 25                 40
2049351 2049351 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_2 11 10 2 0   1     0   2   15 11                       26.0 11 10 2 0   1     0   2   15 11                 26
2046389 2046389 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2019   grade_2 111 3 7 0   6     0   1   66 62                       128.0 111 3 7 0   6     0   1   66 62                 128
2044060 2044060 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2019   grade_2 112 4 0 0   1     0   2   62 57                       119.0 112 4 0 0   1     0   2   62 57                 119
2046445 2046445 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 03 2019   grade_2 112 0 5 0   0     0   3   64 56                       120.0 112 0 5 0   0     0   3   64 56                 120
2044882 2044882 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2019   grade_2 113 4 14 0   0     0   8   74 65                       139.0 113 4 14 0   0     0   8   74 65                 139
2042683 2042683 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2019   grade_2 118 1 5 0   1     0   1   69 57                       126.0 118 1 5 0   1     0   1   69 57                 126
2044562 2044562 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2019   grade_2 118 1 1 0   5     0   6   70 61                       131.0 118 1 1 0   5     0   6   70 61                 131
2047131 2047131 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2019   grade_2 119 2 22 0   0     0   2   70 75                       145.0 119 2 22 0   0     0   2   70 75                 145
2040546 2040546 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2019   grade_2 12 4 39 0   1     0   2   30 28                       58.0 12 4 39 0   1     0   2   30 28                 58
2045726 2045726 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_2 12 7 26 0   3     0   1   32 17                       49.0 12 7 26 0   3     0   1   32 17                 49
2045965 2045965 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2019   grade_2 12 16 57 0   0     0   3   47 41                       88.0 12 16 57 0   0     0   3   47 41                 88
2047348 2047348 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2019   grade_2 12 6 12 0   0     0   2   19 13                       32.0 12 6 12 0   0     0   2   19 13                 32
2048667 2048667 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   grade_2 12 0 1 0   0     0   0   5 8                       13.0 12 0 1 0   0     0   0   5 8                 13
2045836 2045836 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2019   grade_2 120 3 24 0   3     0   5   76 79                       155.0 120 3 24 0   3     0   5   76 79                 155
2044727 2044727 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2019   grade_2 121 0 14 1   4     0   9   79 70                       149.0 121 0 14 1   4     0   9   79 70                 149
2044431 2044431 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2019   grade_2 122 1 6 0   4     0   3   69 67                       136.0 122 1 6 0   4     0   3   69 67                 136
2042514 2042514 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_2 124 2 39 0   3     0   11   83 96                       179.0 124 2 39 0   3     0   11   83 96                 179
2040130 2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2046386 2046386 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   grade_2 127 8 17 0   3     1   2   81 77                       158.0 127 8 17 0   3     1   2   81 77                 158
2040396 2040396 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2019   grade_2 13 14 49 0   0     0   10   48 38                       86.0 13 14 49 0   0     0   10   48 38                 86
2040482 2040482 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_2 13 13 14 0   2     0   1   22 21                       43.0 13 13 14 0   2     0   1   22 21                 43
2041817 2041817 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_2 13 0 2 0   0     0   0   10 5                       15.0 13 0 2 0   0     0   0   10 5                 15
2042119 2042119 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_2 13 6 51 0   9     0   0   35 44                       79.0 13 6 51 0   9     0   0   35 44                 79
2043619 2043619 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2019   grade_2 13 0 7 0   3     0   5   12 16                       28.0 13 0 7 0   3     0   5   12 16                 28
2046491 2046491 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_2 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13

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