Data source: Big Local News · About: Big Local

950 rows where grade = "grade_4", state = "MA" and year = 2020 sorted by total

View and edit SQL

year

  • 2020 · 950

grade

  • grade_4 · 950
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
1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1374311 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1370776 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_4 1 2 7 0   0     0   0   9 1 *                     10.0 1 2 7 0   0     0   0   9 1                 10
1365009 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_4 66 4 18 0   6     0   6   54 46 *                     100.0 66 4 18 0   6     0   6   54 46                 100
1365659 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_4 0 62 33 1   1     0   3   55 45 *                     100.0 0 62 33 1   1     0   3   55 45                 100
1368130 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2020   grade_4 37 11 40 0   7     0   5   47 53 *                     100.0 37 11 40 0   7     0   5   47 53                 100
1368176 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2020   grade_4 50 5 3 0   33     0   9   55 45 *                     100.0 50 5 3 0   33     0   9   55 45                 100
1368818 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_4 79 1 13 0   1     0   6   50 50 *                     100.0 79 1 13 0   1     0   6   50 50                 100
1372790 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_4 2 50 48 0   0     0   0   48 52 *                     100.0 2 50 48 0   0     0   0   48 52                 100
1369138 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2020   grade_4 54 1 10 0   33     0   3   51 50 *                     101.0 54 1 10 0   33     0   3   51 50                 101
1373077 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2020   grade_4 79 1 15 0   1     0   5   51 50 *                     101.0 79 1 15 0   1     0   5   51 50                 101
1364889 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_4 79 2 7 0   8     0   6   58 44 *                     102.0 79 2 7 0   8     0   6   58 44                 102
1364914 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_4 70 2 8 0   21     0   1   49 53 *                     102.0 70 2 8 0   21     0   1   49 53                 102
1366280 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_4 63 11 9 0   12     0   7   55 47 *                     102.0 63 11 9 0   12     0   7   55 47                 102
1368986 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_4 89 1 3 0   0     0   9   59 43 *                     102.0 89 1 3 0   0     0   9   59 43                 102
1370055 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2020   grade_4 90 0 6 0   2     0   4   49 53 *                     102.0 90 0 6 0   2     0   4   49 53                 102
1370557 MA Norfolk   school 2510620 266   Sharon 251062001703 2660010 East Elementary   Regular School No Elementary KG 05 2020   grade_4 51 6 8 0   31     0   6   55 47 *                     102.0 51 6 8 0   31     0   6   55 47                 102
1371319 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Louise Davy Trahan   Regular School No Elementary 03 04 2020   grade_4 92 1 2 0   2     0   5   45 57 *                     102.0 92 1 2 0   2     0   5   45 57                 102
1374059 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_4 93 1 4 0   1     0   3   53 49 *                     102.0 93 1 4 0   1     0   3   53 49                 102
1366326 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_4 66 8 4 0   19     0   7   50 54 *                     104.0 66 8 4 0   19     0   7   50 54                 104
1367708 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_4 40 3 59 1   0     0   1   50 54 *                     104.0 40 3 59 1   0     0   1   50 54                 104
1369061 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2020   grade_4 85 3 4 0   8     0   4   62 42 *                     104.0 85 3 4 0   8     0   4   62 42                 104
1373053 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2020   grade_4 98 1 4 0   0     0   1   55 49 *                     104.0 98 1 4 0   0     0   1   55 49                 104
1366809 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2020   grade_4 86 2 5 0   3     0   9   58 47 *                     105.0 86 2 5 0   3     0   9   58 47                 105
1367466 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_4 99 0 4 0   2     0   0   59 46 *                     105.0 99 0 4 0   2     0   0   59 46                 105
1368621 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2020   grade_4 82 2 8 0   8     0   5   46 59 *                     105.0 82 2 8 0   8     0   5   46 59                 105
1370307 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2020   grade_4 26 4 71 0   2     0   2   61 44 *                     105.0 26 4 71 0   2     0   2   61 44                 105
1365665 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_4 35 37 27 0   3     0   4   49 57 *                     106.0 35 37 27 0   3     0   4   49 57                 106
1373389 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2020   grade_4 91 1 1 1   7     0   5   55 51 *                     106.0 91 1 1 1   7     0   5   55 51                 106
1373562 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   grade_4 78 9 6 1   4     0   8   63 43 *                     106.0 78 9 6 1   4     0   8   63 43                 106
1366153 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   grade_4 28 51 19 0   3     0   6   60 47 *                     107.0 28 51 19 0   3     0   6   60 47                 107
1367353 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_4 19 3 80 0   0     0   5   53 53 *                     107.0 19 3 80 0   0     0   5   53 53                 107
1369196 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2020   grade_4 81 6 6 0   7     0   7   50 57 *                     107.0 81 6 6 0   7     0   7   50 57                 107
1370892 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2020   grade_4 9 23 72 0   0     0   3   54 53 *                     107.0 9 23 72 0   0     0   3   54 53                 107
1368182 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2020   grade_4 38 3 4 0   58     0   5   61 47 *                     108.0 38 3 4 0   58     0   5   61 47                 108
1368991 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_4 94 2 3 0   0     0   9   57 51 *                     108.0 94 2 3 0   0     0   9   57 51                 108
1370061 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2020   grade_4 90 1 9 1   1     1   5   53 55 *                     108.0 90 1 9 1   1     1   5   53 55                 108
1371197 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2020   grade_4 98 0 3 0   2     0   5   56 52 *                     108.0 98 0 3 0   2     0   5   56 52                 108
1366178 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_4 13 68 22 0   0     0   6   50 59 *                     109.0 13 68 22 0   0     0   6   50 59                 109
1366707 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2020   grade_4 102 3 0 0   4     0   0   60 49 *                     109.0 102 3 0 0   4     0   0   60 49                 109
1368170 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2020   grade_4 48 6 7 1   43     0   4   49 60 *                     109.0 48 6 7 1   43     0   4   49 60                 109
1368514 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2020   grade_4 4 4 86 0   10     0   5   61 48 *                     109.0 4 4 86 0   10     0   5   61 48                 109
1366214 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_4 19 58 23 1   1     0   8   60 50 *                     110.0 19 58 23 1   1     0   8   60 50                 110
1367522 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_4 84 0 5 0   13     1   7   55 55 *                     110.0 84 0 5 0   13     1   7   55 55                 110
1367757 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2020   grade_4 57 22 13 0   7     0   11   63 47 *                     110.0 57 22 13 0   7     0   11   63 47                 110
1372916 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_4 88 6 9 0   2     0   5   48 62 *                     110.0 88 6 9 0   2     0   5   48 62                 110
1364804 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_4 99 0 4 0   1     0   7   56 55 *                     111.0 99 0 4 0   1     0   7   56 55                 111
1370843 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2020   grade_4 5 29 72 0   0     0   6   61 51 *                     112.0 5 29 72 0   0     0   6   61 51                 112
1373870 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_4 107 2 3 0   0     0   0   56 56 *                     112.0 107 2 3 0   0     0   0   56 56                 112
1365174 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_4 84 1 3 0   12     0   13   61 52 *                     113.0 84 1 3 0   12     0   13   61 52                 113
1368732 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2020   grade_4 53 3 53 0   3     0   1   66 47 *                     113.0 53 3 53 0   3     0   1   66 47                 113
1367653 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2020   grade_4 61 1 50 0   0     0   2   50 64 *                     114.0 61 1 50 0   0     0   2   50 64                 114
1369123 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket Intermediate School   Regular School No Elementary 03 05 2020   grade_4 68 8 33 0   2     0   3   67 47 *                     114.0 68 8 33 0   2     0   3   67 47                 114
1374200 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_4 16 25 36 0   32     0   5   52 62 *                     114.0 16 25 36 0   32     0   5   52 62                 114
1365232 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 04 2020   grade_4 80 11 9 0   12     0   3   59 56 *                     115.0 80 11 9 0   12     0   3   59 56                 115
1367249 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   grade_4 29 8 66 1   4     0   7   60 55 *                     115.0 29 8 66 1   4     0   7   60 55                 115
1367265 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_4 32 8 64 0   3     0   8   55 60 *                     115.0 32 8 64 0   3     0   8   55 60                 115
1371153 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_4 99 1 10 0   0     0   5   68 47 *                     115.0 99 1 10 0   0     0   5   68 47                 115
1372429 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_4 94 1 6 2   4     1   7   54 61 *                     115.0 94 1 6 2   4     1   7   54 61                 115
1366172 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_4 25 65 11 0   5     0   10   57 59 *                     116.0 25 65 11 0   5     0   10   57 59                 116
1366575 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_4 8 4 101 0   0     0   3   60 56 *                     116.0 8 4 101 0   0     0   3   60 56                 116
1367132 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   grade_4 43 13 46 0   4     0   10   65 51 *                     116.0 43 13 46 0   4     0   10   65 51                 116
1367255 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2020   grade_4 36 6 63 0   4     0   7   62 54 *                     116.0 36 6 63 0   4     0   7   62 54                 116
1368526 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_4 6 7 91 1   9     0   2   60 56 *                     116.0 6 7 91 1   9     0   2   60 56                 116
1370294 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2020   grade_4 31 5 77 1   2     0   0   48 68 *                     116.0 31 5 77 1   2     0   0   48 68                 116
1372663 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_4 28 62 20 0   2     0   4   59 57 *                     116.0 28 62 20 0   2     0   4   59 57                 116
1369268 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2020   grade_4 23 11 78 0   0     0   5   54 63 *                     117.0 23 11 78 0   0     0   5   54 63                 117
1371778 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2020   grade_4 72 2 5 0   34     0   4   64 53 *                     117.0 72 2 5 0   34     0   4   64 53                 117
1373714 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2020   grade_4 100 5 8 1   0     0   3   62 55 *                     117.0 100 5 8 1   0     0   3   62 55                 117
1369133 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2020   grade_4 85 3 5 0   8     0   17   52 66 *                     118.0 85 3 5 0   8     0   17   52 66                 118
1371278 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2020   grade_4 68 27 17 0   1     0   5   63 55 *                     118.0 68 27 17 0   1     0   5   63 55                 118
1366077 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_4 103 2 4 1   4     0   5   64 55 *                     119.0 103 2 4 1   4     0   5   64 55                 119
1368943 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_4 67 0 42 0   4     0   6   62 57 *                     119.0 67 0 42 0   4     0   6   62 57                 119
1373270 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2020   grade_4 109 0 7 0   2     0   1   62 57 *                     119.0 109 0 7 0   2     0   1   62 57                 119
1370614 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   grade_4 10 0 1 0   0     0   1   6 6 *                     12.0 10 0 1 0   0     0   1   6 6                 12
1371965 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2020   grade_4 11 0 1 0   0     0   0   6 6 *                     12.0 11 0 1 0   0     0   0   6 6                 12
1373849 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2020   grade_4 10 0 1 0   0     0   1   5 7 *                     12.0 10 0 1 0   0     0   1   5 7                 12
1366147 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   grade_4 13 76 17 2   2     0   10   72 48 *                     120.0 13 76 17 2   2     0   10   72 48                 120
1368798 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_4 84 6 10 8   2     0   10   60 60 *                     120.0 84 6 10 8   2     0   10   60 60                 120
1371768 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2020   grade_4 61 4 6 0   41     0   8   54 66 *                     120.0 61 4 6 0   41     0   8   54 66                 120
1366583 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_4 10 6 104 0   1     0   0   52 69 *                     121.0 10 6 104 0   1     0   0   52 69                 121
1368118 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2020   grade_4 60 6 45 0   2     0   8   61 60 *                     121.0 60 6 45 0   2     0   8   61 60                 121
1368447 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2020   grade_4 99 3 12 0   7     0   1   66 56 *                     122.0 99 3 12 0   7     0   1   66 56                 122
1371358 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2020   grade_4 93 9 7 0   7     0   6   55 67 *                     122.0 93 9 7 0   7     0   6   55 67                 122
1371372 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2020   grade_4 106 2 7 0   2     0   5   64 58 *                     122.0 106 2 7 0   2     0   5   64 58                 122
1367974 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_4 4 2 117 0   0     0   0   72 50 1                     123.0 4 2 117 0   0     0   0   72 50 1               123
1373161 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_4 105 4 7 0   1     0   6   72 51 *                     123.0 105 4 7 0   1     0   6   72 51                 123
1365632 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_4 28 24 21 0   49     1   1   69 55 *                     124.0 28 24 21 0   49     1   1   69 55                 124
1367166 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2020   grade_4 67 5 30 0   9     0   13   62 62 *                     124.0 67 5 30 0   9     0   13   62 62                 124
1370271 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_4 55 2 61 0   4     0   2   65 59 *                     124.0 55 2 61 0   4     0   2   65 59                 124
1371267 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No Elementary KG 04 2020   grade_4 81 17 16 0   1     0   9   54 70 *                     124.0 81 17 16 0   1     0   9   54 70                 124
1371826 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_4 115 1 5 0   0     0   3   76 48 *                     124.0 115 1 5 0   0     0   3   76 48                 124
1372551 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_4 6 24 85 0   6     0   3   69 55 *                     124.0 6 24 85 0   6     0   3   69 55                 124
1365709 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_4 11 15 13 0   81     0   5   58 67 *                     125.0 11 15 13 0   81     0   5   58 67                 125
1367999 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_4 3 4 115 0   2     0   1   68 57 *                     125.0 3 4 115 0   2     0   1   68 57                 125
1371988 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 West Intermediate   Regular School No Elementary 04 05 2020   grade_4 109 1 6 0   7     0   2   68 57 *                     125.0 109 1 6 0   7     0   2   68 57                 125
1367680 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2020   grade_4 76 3 46 0   0     0   1   60 66 *                     126.0 76 3 46 0   0     0   1   60 66                 126
1368953 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_4 61 2 49 0   7     0   7   63 63 *                     126.0 61 2 49 0   7     0   7   63 63                 126
1365519 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2020   grade_4 2 55 55 0   10     0   5   55 72 *                     127.0 2 55 55 0   10     0   5   55 72                 127
1369034 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2020   grade_4 109 2 9 0   3     0   4   81 46 *                     127.0 109 2 9 0   3     0   4   81 46                 127

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