Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_4 · 6,579
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
2238451 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_4 91 1 11 0   2     0   1   46 60                       106.0 91 1 11 0   2     0   1   46 60                 106
2238432 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   grade_4 37 18 2 0   2     0   7   33 33                       66.0 37 18 2 0   2     0   7   33 33                 66
2238418 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_4 8 54 24 0   6     1   2   47 48                       95.0 8 54 24 0   6     1   2   47 48                 95
2238408 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter Public (District): Seven Hills Charter School   Regular School Yes Elementary KG 08 2018   grade_4 5 43 31 0   0     0   2   41 40                       81.0 5 43 31 0   0     0   2   41 40                 81
2238373 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_4 28 0 2 1   1     0   0   12 20                       32.0 28 0 2 1   1     0   0   12 20                 32
2238365 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_4 2 75 30 0   1     0   7   52 63                       115.0 2 75 30 0   1     0   7   52 63                 115
2238339 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter (District): Silver Hill Horace Mann Charter School   Regular School Yes Elementary KG 05 2018   grade_4 62 3 23 0   3     0   2   47 46                       93.0 62 3 23 0   3     0   2   47 46                 93
2238318 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_4 73 25 10 0   32     0   8   80 68                       148.0 73 25 10 0   32     0   8   80 68                 148
2238304 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_4 3 45 43 1   1     0   3   40 56                       96.0 3 45 43 1   1     0   3   40 56                 96
2238286 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_4 14 0 1 0   0     0   2   4 13                       17.0 14 0 1 0   0     0   2   4 13                 17
2238276 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_4 41 3 2 0   5     0   0   31 20                       51.0 41 3 2 0   5     0   0   31 20                 51
2238256 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District): Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2018   grade_4 4 21 42 0   18     0   4   44 45                       89.0 4 21 42 0   18     0   4   44 45                 89
2238245 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_4 30 1 4 0   0     0   0   15 20                       35.0 30 1 4 0   0     0   0   15 20                 35
2238235 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_4 1 0 81 0   0     0   0   46 36                       82.0 1 0 81 0   0     0   0   46 36                 82
2238224 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District): Holyoke Community Charter School   Regular School Yes Elementary KG 08 2018   grade_4 2 2 80 0   1     0   3   42 46                       88.0 2 2 80 0   1     0   3   42 46                 88
2238209 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_4 17 0 0 0   1     0   3   9 12                       21.0 17 0 0 0   1     0   3   9 12                 21
2238190 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   grade_4 35 0 3 0   10     0   3   28 23                       51.0 35 0 3 0   10     0   3   28 23                 51
2238176 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_4 60 44 6 1   16     1   5   62 71                       133.0 60 44 6 1   16     1   5   62 71                 133
2238162 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_4 14 81 23 0   4     0   0   53 69                       122.0 14 81 23 0   4     0   0   53 69                 122
2238151 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_4 8 26 6 1   1     0   3   18 27                       45.0 8 26 6 1   1     0   3   18 27                 45
2238136 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_4 22 43 47 0   10     0   7   64 65                       129.0 22 43 47 0   10     0   7   64 65                 129
2238126 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_4 0 0 48 0   0     0   0   23 25                       48.0 0 0 48 0   0     0   0   23 25                 48
2238115 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_4 4 28 10 0   2     0   3   22 25                       47.0 4 28 10 0   2     0   3   22 25                 47
2238100 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_4 0 14 6 0   0     0   0   13 7                       20.0 0 14 6 0   0     0   0   13 7                 20
2238065 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District): Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 06 2018   grade_4 5 2 31 0   1     0   0   13 26                       39.0 5 2 31 0   1     0   0   13 26                 39
2238032 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_4 8 107 65 0   5     0   2   87 100                       187.0 8 107 65 0   5     0   2   87 100                 187
2238019 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District): Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 06 2018   grade_4 1 1 37 0   0     0   0   24 15                       39.0 1 1 37 0   0     0   0   24 15                 39
2238006 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   grade_4 0 43 4 0   0     0   0   26 21                       47.0 0 43 4 0   0     0   0   26 21                 47
2237989 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District): Bridge Boston Charter School   Regular School Yes Elementary PK 06 2018   grade_4 0 26 13 0   1     0   0   19 21                       40.0 0 26 13 0   1     0   0   19 21                 40
2237930 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_4 18 4 22 0   0     0   2   19 27                       46.0 18 4 22 0   0     0   2   19 27                 46
2237923 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School (District): Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2018   grade_4 0 25 17 0   0     0   0   19 23                       42.0 0 25 17 0   0     0   0   19 23                 42
2237909 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_4 139 4 7 0   4     0   7   92 69                       161.0 139 4 7 0   4     0   7   92 69                 161
2237900 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_4 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2237838 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_4 24 18 30 0   2     0   6   37 43                       80.0 24 18 30 0   2     0   6   37 43                 80
2237829 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_4 34 0 7 0   2     0   2   19 26                       45.0 34 0 7 0   2     0   2   19 26                 45
2237820 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester: Union Hill School   Regular School No Elementary KG 06 2018   grade_4 20 8 36 0   1     0   3   37 31                       68.0 20 8 36 0   1     0   3   37 31                 68
2237812 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   grade_4 27 6 17 0   3     0   4   26 31                       57.0 27 6 17 0   3     0   4   26 31                 57
2237804 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_4 29 14 11 0   3     0   7   30 34                       64.0 29 14 11 0   3     0   7   30 34                 64
2237795 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   grade_4 33 11 12 0   1     0   3   32 28                       60.0 33 11 12 0   1     0   3   32 28                 60
2237786 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   grade_4 47 16 17 0   3     0   6   50 39                       89.0 47 16 17 0   3     0   6   50 39                 89
2237777 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Worcester: Rice Square   Regular School No Elementary KG 06 2018   grade_4 17 12 26 0   4     0   4   28 35                       63.0 17 12 26 0   4     0   4   28 35                 63
2237769 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester: Quinsigamond   Regular School No Elementary PK 06 2018   grade_4 42 20 45 0   9     0   5   64 57                       121.0 42 20 45 0   9     0   5   64 57                 121
2237760 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Worcester: Norrback Avenue   Regular School No Elementary PK 06 2018   grade_4 37 17 18 0   2     0   4   44 34                       78.0 37 17 18 0   2     0   4   44 34                 78
2237751 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Worcester: Nelson Place   Regular School No Elementary PK 06 2018   grade_4 39 9 9 0   4     0   4   38 27                       65.0 39 9 9 0   4     0   4   38 27                 65
2237742 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_4 22 3 2 0   3     0   8   22 16                       38.0 22 3 2 0   3     0   8   22 16                 38
2237734 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_4 17 2 11 0   0     0   0   10 20                       30.0 17 2 11 0   0     0   0   10 20                 30
2237726 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 Worcester: May Street   Regular School No Elementary KG 06 2018   grade_4 26 4 15 0   5     0   3   26 27                       53.0 26 4 15 0   5     0   3   26 27                 53
2237718 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_4 8 7 12 0   2     0   1   15 15                       30.0 8 7 12 0   2     0   1   15 15                 30
2237710 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   grade_4 31 7 4 0   5     0   3   25 25                       50.0 31 7 4 0   5     0   3   25 25                 50
2237702 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_4 10 15 22 0   0     0   1   26 22                       48.0 10 15 22 0   0     0   1   26 22                 48
2237693 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester: Heard Street   Regular School No Elementary KG 06 2018   grade_4 23 5 7 0   3     0   2   24 16                       40.0 23 5 7 0   3     0   2   24 16                 40
2237685 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester: Grafton Street   Regular School No Elementary KG 06 2018   grade_4 15 15 20 0   4     0   2   32 24                       56.0 15 15 20 0   4     0   2   32 24                 56
2237677 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Worcester: Gates Lane   Regular School No Elementary PK 06 2018   grade_4 23 12 27 0   11     0   4   40 37                       77.0 23 12 27 0   11     0   4   40 37                 77
2237668 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Worcester: Goddard School/Science Technical   Regular School No Elementary PK 06 2018   grade_4 13 5 36 0   9     0   1   35 29                       64.0 13 5 36 0   9     0   1   35 29                 64
2237659 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Worcester: Elm Park Community   Regular School No Elementary KG 06 2018   grade_4 22 10 32 0   1     0   2   36 31                       67.0 22 10 32 0   1     0   2   36 31                 67
2237651 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Worcester: Flagg Street   Regular School No Elementary KG 06 2018   grade_4 48 3 5 0   3     0   0   31 28                       59.0 48 3 5 0   3     0   0   31 28                 59
2237643 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   grade_4 24 7 23 0   2     0   2   33 25                       58.0 24 7 23 0   2     0   2   33 25                 58
2237634 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester: Clark St Community   Regular School No Elementary PK 06 2018   grade_4 8 7 12 0   0     0   0   19 8                       27.0 8 7 12 0   0     0   0   19 8                 27
2237625 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_4 16 6 28 0   3     0   0   25 28                       53.0 16 6 28 0   3     0   0   25 28                 53
2237616 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_4 9 3 59 0   0     0   3   37 37                       74.0 9 3 59 0   0     0   3   37 37                 74
2237607 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Worcester: Chandler Elementary Community   Regular School No Elementary KG 06 2018   grade_4 13 8 35 0   5     0   3   35 29                       64.0 13 8 35 0   5     0   3   35 29                 64
2237599 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   grade_4 9 10 24 1   3     0   2   30 19                       49.0 9 10 24 1   3     0   2   30 19                 49
2237590 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   grade_4 14 13 19 0   1     0   2   25 24                       49.0 14 13 19 0   1     0   2   25 24                 49
2237582 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Worcester: Woodland Academy   Regular School No Elementary KG 06 2018   grade_4 9 7 69 0   10     0   3   51 47                       98.0 9 7 69 0   10     0   3   51 47                 98
2237574 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_4 10 1 15 0   1     0   1   13 15                       28.0 10 1 15 0   1     0   1   13 15                 28
2237566 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   grade_4 15 20 42 0   3     0   3   54 29                       83.0 15 20 42 0   3     0   3   54 29                 83
2237543 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Woburn: Mary D Altavesta   Regular School No Elementary KG 05 2018   grade_4 19 7 8 1   5     0   3   25 18                       43.0 19 7 8 1   5     0   3   25 18                 43
2237536 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Woburn: Wyman   Regular School No Elementary KG 05 2018   grade_4 13 1 0 0   4     0   0   11 7                       18.0 13 1 0 0   4     0   0   11 7                 18
2237529 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Woburn: Malcolm White   Regular School No Elementary KG 05 2018   grade_4 42 6 4 0   2     0   4   26 32                       58.0 42 6 4 0   2     0   4   26 32                 58
2237522 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Woburn: Shamrock   Regular School No Elementary PK 05 2018   grade_4 24 3 9 0   2     0   3   25 16                       41.0 24 3 9 0   2     0   3   25 16                 41
2237514 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Woburn: Clyde Reeves   Regular School No Elementary PK 05 2018   grade_4 63 4 6 1   5     0   3   51 31                       82.0 63 4 6 1   5     0   3   51 31                 82
2237506 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Woburn: Linscott-Rumford   Regular School No Elementary KG 05 2018   grade_4 14 4 1 0   7     0   1   12 15                       27.0 14 4 1 0   7     0   1   12 15                 27
2237499 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Woburn: Daniel P Hurld   Regular School No Elementary KG 05 2018   grade_4 26 1 0 0   1     0   0   12 16                       28.0 26 1 0 0   1     0   0   12 16                 28
2237492 MA Middlesex   school 2513200 347   Woburn 251320002184 3470005 Woburn: Goodyear Elementary School   Regular School No Elementary KG 05 2018   grade_4 47 4 4 1   2     0   1   33 26                       59.0 47 4 4 1   2     0   1   33 26                 59
2237475 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Winthrop: Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2018   grade_4 126 2 27 1   1     0   3   84 76                       160.0 126 2 27 1   1     0   3   84 76                 160
2237457 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Winchester: Ambrose Elementary   Regular School No Elementary KG 05 2018   grade_4 73 0 2 0   1     0   2   42 36                       78.0 73 0 2 0   1     0   2   42 36                 78
2237450 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Winchester: Muraco Elementary   Regular School No Elementary KG 05 2018   grade_4 43 1 2 0   21     0   4   33 38                       71.0 43 1 2 0   21     0   4   33 38                 71
2237443 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Winchester: Vinson-Owen Elementary   Regular School No Elementary PK 05 2018   grade_4 60 0 1 0   11     0   12   47 37                       84.0 60 0 1 0   11     0   12   47 37                 84
2237435 MA Middlesex   school 2513110 344   Winchester 251311002166 3440020 Winchester: Lynch Elementary   Regular School No Elementary PK 05 2018   grade_4 53 3 1 0   29     0   5   47 44                       91.0 53 3 1 0   29     0   5   47 44                 91
2237427 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Winchester: Lincoln Elementary   Regular School No Elementary KG 05 2018   grade_4 57 2 2 0   6     0   6   42 31                       73.0 57 2 2 0   6     0   6   42 31                 73
2237407 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Winchendon: Toy Town Elementary   Regular School No Elementary 03 05 2018   grade_4 79 0 7 0   1     0   5   43 49                       92.0 79 0 7 0   1     0   5   43 49                 92
2237388 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 Wilmington: West Intermediate   Regular School No Elementary 04 05 2018   grade_4 101 0 11 0   6     0   5   66 57                       123.0 101 0 11 0   6     0   5   66 57                 123
2237385 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 Wilmington: North Intermediate   Regular School No Elementary 04 05 2018   grade_4 151 3 2 0   4     0   6   91 75                       166.0 151 3 2 0   4     0   6   91 75                 166
2237367 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown: Williamstown Elementary   Regular School No Elementary PK 06 2018   grade_4 41 1 8 0   3     0   3   30 26                       56.0 41 1 8 0   3     0   3   30 26                 56
2237358 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_4 21 0 1 0   1     0   0   13 10                       23.0 21 0 1 0   1     0   0   13 10                 23
2237349 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_4 16 0 1 0   0     0   0   9 8                       17.0 16 0 1 0   0     0   0   9 8                 17
2237334 MA Norfolk   school 2512840 336   Weymouth 251284002122 3360110 Weymouth: Wessagusset   Regular School No Elementary KG 04 2018   grade_4 41 0 5 0   6     0   2   26 28                       54.0 41 0 5 0   6     0   2   26 28                 54
2237328 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Weymouth: Thomas W. Hamilton Primary School   Regular School No Elementary KG 04 2018   grade_4 54 3 9 1   9     0   2   36 42                       78.0 54 3 9 1   9     0   2   36 42                 78
2237322 MA Norfolk   school 2512840 336   Weymouth 251284002116 3360085 Weymouth: Ralph Talbot   Regular School No Elementary KG 04 2018   grade_4 35 3 3 0   4     0   1   34 12                       46.0 35 3 3 0   4     0   1   34 12                 46
2237316 MA Norfolk   school 2512840 336   Weymouth 251284002125 3360080 Weymouth: William Seach   Regular School No Elementary KG 04 2018   grade_4 30 10 15 0   7     0   3   31 34                       65.0 30 10 15 0   7     0   3   31 34                 65
2237310 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Weymouth: Lawrence W Pingree   Regular School No Elementary KG 04 2018   grade_4 29 2 1 0   1     0   2   18 17                       35.0 29 2 1 0   1     0   2   18 17                 35
2237304 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Weymouth: Thomas V Nash   Regular School No Elementary KG 04 2018   grade_4 40 3 3 0   3     0   4   22 31                       53.0 40 3 3 0   3     0   4   22 31                 53
2237298 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Weymouth: Frederick C Murphy   Regular School No Elementary KG 04 2018   grade_4 40 7 5 0   1     0   7   33 27                       60.0 40 7 5 0   1     0   7   33 27                 60
2237287 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Weymouth: Academy Avenue   Regular School No Elementary KG 04 2018   grade_4 61 2 10 0   6     0   0   42 37                       79.0 61 2 10 0   6     0   0   42 37                 79
2237267 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 Westwood: William E Sheehan   Regular School No Elementary KG 05 2018   grade_4 42 1 6 0   2     0   0   31 20                       51.0 42 1 6 0   2     0   0   31 20                 51
2237260 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Westwood: Martha Jones   Regular School No Elementary KG 05 2018   grade_4 40 1 1 0   6     0   3   22 29                       51.0 40 1 1 0   6     0   3   22 29                 51
2237253 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Westwood: Paul Hanlon   Regular School No Elementary KG 05 2018   grade_4 33 1 1 0   7     0   0   20 22                       42.0 33 1 1 0   7     0   0   20 22                 42
2237246 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Westwood: Downey   Regular School No Elementary KG 05 2018   grade_4 31 0 1 0   10     0   3   25 20                       45.0 31 0 1 0   10     0   3   25 20                 45
2237239 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Westwood: Deerfield School   Regular School No Elementary KG 05 2018   grade_4 19 1 4 0   2     0   4   19 11                       30.0 19 1 4 0   2     0   4   19 11                 30
2237225 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0

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