Data source: Big Local News · About: Big Local

967 rows where grade = "grade_3", state = "MA" and year = 2019 sorted by white

View and edit SQL

year

  • 2019 · 967

grade

  • grade_3 · 967
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
2042268 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042672 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2042767 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   2 *                       2.0                         2                   2
2043451 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_3 * * * *   *     *   *   1 *                       1.0                         1                   1
2045458 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2048846 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2040333 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_3 0 19 13 0   0     0   0   17 15                       32.0 0 19 13 0   0     0   0   17 15                 32
2040530 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_3 0 25 39 0   1     0   0   30 35                       65.0 0 25 39 0   1     0   0   30 35                 65
2040650 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_3 0 14 36 1   0     0   0   26 25                       51.0 0 14 36 1   0     0   0   26 25                 51
2040684 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   grade_3 0 19 4 0   2     0   0   13 12                       25.0 0 19 4 0   2     0   0   13 12                 25
2040779 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_3 0 13 33 0   0     0   2   22 26                       48.0 0 13 33 0   0     0   2   22 26                 48
2040820 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_3 0 3 6 1   0     0   0   9 1                       10.0 0 3 6 1   0     0   0   9 1                 10
2040835 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2019   grade_3 0 20 29 1   6     1   0   23 34                       57.0 0 20 29 1   6     1   0   23 34                 57
2040876 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_3 0 14 23 0   0     0   0   23 14                       37.0 0 14 23 0   0     0   0   23 14                 37
2040886 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_3 0 36 9 0   1     0   1   20 27                       47.0 0 36 9 0   1     0   1   20 27                 47
2041098 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_3 0 2 4 0   0     0   0   3 3                       6.0 0 2 4 0   0     0   0   3 3                 6
2042891 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2019   grade_3 0 4 46 0   1     0   0   29 22                       51.0 0 4 46 0   1     0   0   29 22                 51
2047513 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_3 0 20 19 0   0     0   0   16 23                       39.0 0 20 19 0   0     0   0   16 23                 39
2047573 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_3 0 26 13 0   1     0   0   20 20                       40.0 0 26 13 0   1     0   0   20 20                 40
2047644 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_3 0 0 42 0   1     0   0   26 17                       43.0 0 0 42 0   1     0   0   26 17                 43
2047675 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_3 0 15 5 0   0     0   0   10 10                       20.0 0 15 5 0   0     0   0   10 10                 20
2047699 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_3 0 1 49 0   0     0   0   22 28                       50.0 0 1 49 0   0     0   0   22 28                 50
2047831 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2019   grade_3 0 50 23 0   0     0   0   41 32                       73.0 0 50 23 0   0     0   0   41 32                 73
2049289 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_3 0 44 27 0   1     0   2   39 35                       74.0 0 44 27 0   1     0   2   39 35                 74
2040313 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2019   grade_3 1 30 16 0   3     0   0   26 24                       50.0 1 30 16 0   3     0   0   26 24                 50
2040404 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_3 1 67 12 1   0     0   2   38 45                       83.0 1 67 12 1   0     0   2   38 45                 83
2040425 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   grade_3 1 18 38 2   1     0   0   24 36                       60.0 1 18 38 2   1     0   0   24 36                 60
2040507 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   grade_3 1 31 12 0   1     0   8   35 18                       53.0 1 31 12 0   1     0   8   35 18                 53
2040514 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2019   grade_3 1 1 39 0   0     0   0   20 21                       41.0 1 1 39 0   0     0   0   20 21                 41
2040578 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   grade_3 1 21 13 0   2     0   2   12 27                       39.0 1 21 13 0   2     0   2   12 27                 39
2040629 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2019   grade_3 1 18 22 0   14     0   3   40 18                       58.0 1 18 22 0   14     0   3   40 18                 58
2040701 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_3 1 56 32 1   2     0   4   49 47                       96.0 1 56 32 1   2     0   4   49 47                 96
2040772 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2019   grade_3 1 20 13 1   0     0   2   22 15                       37.0 1 20 13 1   0     0   2   22 15                 37
2040842 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_3 1 31 30 0   0     0   1   33 30                       63.0 1 31 30 0   0     0   1   33 30                 63
2040869 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_3 1 18 15 1   0     1   3   22 17                       39.0 1 18 15 1   0     1   3   22 17                 39
2041062 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_3 1 2 59 0   1     0   0   35 28                       63.0 1 2 59 0   1     0   0   35 28                 63
2043061 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_3 1 1 86 0   1     0   1   40 50                       90.0 1 1 86 0   1     0   1   40 50                 90
2043118 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_3 1 0 71 0   0     0   2   34 40                       74.0 1 0 71 0   0     0   2   34 40                 74
2045876 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2019   grade_3 1 15 67 0   0     0   2   40 45                       85.0 1 15 67 0   0     0   2   40 45                 85
2045902 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No Elementary KG 05 2019   grade_3 1 7 26 0   1     0   0   16 19                       35.0 1 7 26 0   1     0   0   16 19                 35
2045973 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No Elementary PK 05 2019   grade_3 1 9 39 0   1     0   1   24 27                       51.0 1 9 39 0   1     0   1   24 27                 51
2047799 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_3 1 0 81 0   0     0   0   35 47                       82.0 1 0 81 0   0     0   0   35 47                 82
2047909 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_3 1 80 50 0   0     0   5   69 67                       136.0 1 80 50 0   0     0   5   69 67                 136
2049317 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_3 1 12 35 0   2     0   0   28 22                       50.0 1 12 35 0   2     0   0   28 22                 50
2040320 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_3 10 2 0 0   0     0   3   9 6                       15.0 10 2 0 0   0     0   3   9 6                 15
2040483 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_3 10 11 19 0   2     1   2   27 18                       45.0 10 11 19 0   2     1   2   27 18                 45
2040493 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   grade_3 10 16 21 0   2     0   3   26 26                       52.0 10 16 21 0   2     0   3   26 26                 52
2040667 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2019   grade_3 10 8 6 0   2     0   1   19 8                       27.0 10 8 6 0   2     0   1   19 8                 27
2041485 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2019   grade_3 10 10 8 0   5     0   11   20 24                       44.0 10 10 8 0   5     0   11   20 24                 44
2043448 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_3 10 7 28 0   40     0   4   54 35                       89.0 10 7 28 0   40     0   4   54 35                 89
2043608 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2019   grade_3 10 9 58 1   12     0   5   45 50                       95.0 10 9 58 1   12     0   5   45 50                 95
2045775 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_3 10 5 19 0   1     0   3   22 15                       38.0 10 5 19 0   1     0   3   22 15                 38
2045956 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_3 10 12 20 0   0     0   1   22 21                       43.0 10 12 20 0   0     0   1   22 21                 43
2047201 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   grade_3 10 20 41 0   4     0   2   40 37                       77.0 10 20 41 0   4     0   2   40 37                 77
2047222 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2019   grade_3 10 7 32 0   0     0   3   27 25                       52.0 10 7 32 0   0     0   3   27 25                 52
2047291 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2019   grade_3 10 6 34 2   3     0   2   31 26                       57.0 10 6 34 2   3     0   2   31 26                 57
2047948 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_3 10 43 26 0   0     0   7   45 41                       86.0 10 43 26 0   0     0   7   45 41                 86
2048391 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_3 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2047501 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2019   grade_3 100 1 5 0   5     1   6   58 60                       118.0 100 1 5 0   5     1   6   58 60                 118
2041135 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_3 101 1 4 1   4     0   5   62 54                       116.0 101 1 4 1   4     0   5   62 54                 116
2048331 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2019   grade_3 101 0 9 0   2     0   1   58 55                       113.0 101 0 9 0   2     0   1   58 55                 113
2043529 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2019   grade_3 102 3 9 0   5     0   2   65 56                       121.0 102 3 9 0   5     0   2   65 56                 121
2044883 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2019   grade_3 103 3 16 0   2     0   9   71 62                       133.0 103 3 16 0   2     0   9   71 62                 133
2048220 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_3 103 1 9 0   1     0   5   72 47                       119.0 103 1 9 0   1     0   5   72 47                 119
2041765 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2019   grade_3 105 5 31 0   2     0   3   69 77                       146.0 105 5 31 0   2     0   3   69 77                 146
2041776 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2019   grade_3 105 5 0 0   3     0   0   63 50                       113.0 105 5 0 0   3     0   0   63 50                 113
2048355 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2019   grade_3 105 5 15 0   0     0   5   64 66                       130.0 105 5 15 0   0     0   5   64 66                 130
2048941 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_3 105 2 2 0   0     0   0   56 53                       109.0 105 2 2 0   0     0   0   56 53                 109
2044061 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2019   grade_3 107 2 2 0   0     0   4   59 56                       115.0 107 2 2 0   0     0   4   59 56                 115
2047132 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2019   grade_3 107 1 21 0   0     0   3   64 68                       132.0 107 1 21 0   0     0   3   64 68                 132
2039811 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_3 108 5 8 0   5     1   2   55 74                       129.0 108 5 8 0   5     1   2   55 74                 129
2043320 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2019   grade_3 108 2 3 0   10     1   3   57 70                       127.0 108 2 3 0   10     1   3   57 70                 127
2046446 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 03 2019   grade_3 108 3 5 0   3     0   4   62 61                       123.0 108 3 5 0   3     0   4   62 61                 123
2040397 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2019   grade_3 11 16 50 0   0     0   3   38 42                       80.0 11 16 50 0   0     0   3   38 42                 80
2040439 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_3 11 16 14 0   0     0   5   26 20                       46.0 11 16 14 0   0     0   5   26 20                 46
2042104 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_3 11 9 51 2   7     0   1   35 46                       81.0 11 9 51 2   7     0   1   35 46                 81
2043412 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2019   grade_3 11 6 8 1   64     0   2   44 48                       92.0 11 6 8 1   64     0   2   44 48                 92
2043552 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_3 11 5 12 0   3     0   9   18 22                       40.0 11 5 12 0   3     0   9   18 22                 40
2043630 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No Elementary KG 05 2019   grade_3 11 3 28 0   4     0   2   34 14                       48.0 11 3 28 0   4     0   2   34 14                 48
2045218 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No Elementary KG 05 2019   grade_3 11 1 2 0   30     0   4   31 17                       48.0 11 1 2 0   30     0   4   31 17                 48
2045478 MA Essex   school 2510380 258   Salem 251038001658 2580030 Horace Mann Laboratory   Regular School No Elementary KG 05 2019   grade_3 11 3 25 0   1     0   1   19 22                       41.0 11 3 25 0   1     0   1   19 22                 41
2045689 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_3 11 0 1 0   0     0   0   6 6                       12.0 11 0 1 0   0     0   0   6 6                 12
2045943 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2019   grade_3 11 14 43 0   3     0   4   35 40                       75.0 11 14 43 0   3     0   4   35 40                 75
2045966 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2019   grade_3 11 23 80 0   0     0   3   59 58                       117.0 11 23 80 0   0     0   3   59 58                 117
2047237 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2019   grade_3 11 11 53 0   4     0   2   46 35                       81.0 11 11 53 0   4     0   2   46 35                 81
2042515 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_3 110 9 44 0   6     0   14   89 94                       183.0 110 9 44 0   6     0   14   89 94                 183
2046603 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2019   grade_3 110 13 17 5   1     0   20   95 71                       166.0 110 13 17 5   1     0   20   95 71                 166
2047059 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2019   grade_3 110 2 6 0   7     0   2   68 59                       127.0 110 2 6 0   7     0   2   68 59                 127
2042684 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2019   grade_3 111 0 3 0   5     0   1   52 68                       120.0 111 0 3 0   5     0   1   52 68                 120
2045837 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2019   grade_3 111 0 22 0   1     0   2   75 61                       136.0 111 0 22 0   1     0   2   75 61                 136
2044104 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2019   grade_3 112 1 9 0   5     0   5   83 49                       132.0 112 1 9 0   5     0   5   83 49                 132
2041595 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   grade_3 113 1 3 0   2     0   2   67 54                       121.0 113 1 3 0   2     0   2   67 54                 121
2046899 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_3 113 0 3 0   0     0   4   72 48                       120.0 113 0 3 0   0     0   4   72 48                 120
2048403 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2019   grade_3 114 5 1 0   2     0   7   57 72                       129.0 114 5 1 0   2     0   7   57 72                 129
2046390 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No Elementary 03 04 2019   grade_3 118 5 9 0   4     0   2   75 63                       138.0 118 5 9 0   4     0   2   75 63                 138
2049076 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2019   grade_3 118 4 9 1   1     0   2   65 70                       135.0 118 4 9 1   1     0   2   65 70                 135
2040751 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_3 12 16 13 1   77     0   6   61 64                       125.0 12 16 13 1   77     0   6   61 64                 125
2041657 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2019   grade_3 12 5 117 0   0     0   2   66 70                       136.0 12 5 117 0   0     0   2   66 70                 136
2043390 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_3 12 3 20 0   9     0   2   25 21                       46.0 12 3 20 0   9     0   2   25 21                 46
2043400 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_3 12 6 29 1   35     0   4   49 38                       87.0 12 6 29 1   35     0   4   49 38                 87

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