Data source: Big Local News · About: Big Local

975 rows where grade = "grade_1", state = "MA" and year = 2020 sorted by total

View and edit SQL

year

  • 2020 · 975

grade

  • grade_1 · 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
1368458 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1374308 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1372419 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_1 8 0 1 0   0     0   1   5 5 *                     10.0 8 0 1 0   0     0   1   5 5                 10
1373942 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   grade_1 9 0 0 0   0     0   1   5 5 *                     10.0 9 0 0 0   0     0   1   5 5                 10
1366169 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_1 21 61 12 0   3     0   3   49 51 *                     100.0 21 61 12 0   3     0   3   49 51                 100
1367516 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   grade_1 74 1 6 0   14     0   5   62 38 *                     100.0 74 1 6 0   14     0   5   62 38                 100
1368815 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2020   grade_1 78 4 16 0   0     0   2   53 47 *                     100.0 78 4 16 0   0     0   2   53 47                 100
1369830 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2020   grade_1 81 3 10 0   1     0   5   51 49 *                     100.0 81 3 10 0   1     0   5   51 49                 100
1370866 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2020   grade_1 17 11 63 0   3     0   6   56 44 *                     100.0 17 11 63 0   3     0   6   56 44                 100
1371999 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2020   grade_1 90 1 3 0   3     0   3   51 49 *                     100.0 90 1 3 0   3     0   3   51 49                 100
1372126 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_1 13 20 57 0   7     0   3   50 50 *                     100.0 13 20 57 0   7     0   3   50 50                 100
1372320 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2020   grade_1 28 23 39 1   3     0   6   43 57 *                     100.0 28 23 39 1   3     0   6   43 57                 100
1365044 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_1 82 2 12 0   3     0   2   55 46 *                     101.0 82 2 12 0   3     0   2   55 46                 101
1366548 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_1 62 5 8 0   22     0   4   44 57 *                     101.0 62 5 8 0   22     0   4   44 57                 101
1366586 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_1 10 2 87 0   1     0   1   49 52 *                     101.0 10 2 87 0   1     0   1   49 52                 101
1368983 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_1 92 1 2 0   1     0   5   50 51 *                     101.0 92 1 2 0   1     0   5   50 51                 101
1369291 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2020   grade_1 68 6 19 1   3     0   4   57 44 *                     101.0 68 6 19 1   3     0   4   57 44                 101
1371675 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2020   grade_1 48 1 2 0   49     1   0   54 47 *                     101.0 48 1 2 0   49     1   0   54 47                 101
1364911 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_1 69 5 11 0   12     0   5   51 51 *                     102.0 69 5 11 0   12     0   5   51 51                 102
1367116 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2020   grade_1 53 12 21 0   1     0   15   47 55 *                     102.0 53 12 21 0   1     0   15   47 55                 102
1369168 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2020   grade_1 67 4 6 0   15     0   10   50 52 *                     102.0 67 4 6 0   15     0   10   50 52                 102
1370114 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   grade_1 36 7 8 2   42     0   7   56 46 *                     102.0 36 7 8 2   42     0   7   56 46                 102
1372305 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2020   grade_1 25 20 52 1   2     0   2   57 45 *                     102.0 25 20 52 1   2     0   2   57 45                 102
1372444 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_1 20 11 69 0   0     0   2   45 57 *                     102.0 20 11 69 0   0     0   2   45 57                 102
1366571 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   grade_1 4 1 98 0   0     0   0   46 57 *                     103.0 4 1 98 0   0     0   0   46 57                 103
1367519 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   grade_1 76 2 4 0   21     0   0   53 50 *                     103.0 76 2 4 0   21     0   0   53 50                 103
1368013 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_1 2 0 100 0   1     0   0   60 43 *                     103.0 2 0 100 0   1     0   0   60 43                 103
1369004 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2020   grade_1 81 1 9 1   5     0   6   52 51 *                     103.0 81 1 9 1   5     0   6   52 51                 103
1370980 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2020   grade_1 4 14 82 0   1     0   2   52 51 *                     103.0 4 14 82 0   1     0   2   52 51                 103
1372426 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_1 89 0 6 0   4     0   4   55 48 *                     103.0 89 0 6 0   4     0   4   55 48                 103
1367163 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2020   grade_1 39 10 41 0   3     0   11   52 52 *                     104.0 39 10 41 0   3     0   11   52 52                 104
1369193 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2020   grade_1 83 3 4 0   7     0   7   58 46 *                     104.0 83 3 4 0   7     0   7   58 46                 104
1369602 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2020   grade_1 91 3 4 0   3     0   3   56 48 *                     104.0 91 3 4 0   3     0   3   56 48                 104
1365089 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_1 84 1 9 0   5     0   6   54 50 *                     105.0 84 1 9 0   5     0   6   54 50                 105
1366711 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   grade_1 96 6 1 0   1     0   1   52 53 *                     105.0 96 6 1 0   1     0   1   52 53                 105
1368673 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_1 25 24 45 0   10     0   1   48 57 *                     105.0 25 24 45 0   10     0   1   48 57                 105
1369058 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2020   grade_1 85 1 3 0   11     0   5   51 54 *                     105.0 85 1 3 0   11     0   5   51 54                 105
1369130 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2020   grade_1 69 4 8 0   16     0   8   51 54 *                     105.0 69 4 8 0   16     0   8   51 54                 105
1371194 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2020   grade_1 95 2 4 0   1     0   3   66 39 *                     105.0 95 2 4 0   1     0   3   66 39                 105
1364892 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_1 49 5 10 0   36     0   6   56 50 *                     106.0 49 5 10 0   36     0   6   56 50                 106
1364937 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_1 82 0 4 0   7     0   13   59 47 *                     106.0 82 0 4 0   7     0   13   59 47                 106
1366576 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_1 12 8 84 0   0     0   2   44 62 *                     106.0 12 8 84 0   0     0   2   44 62                 106
1366580 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_1 6 5 95 0   0     0   0   52 54 *                     106.0 6 5 95 0   0     0   0   52 54                 106
1368950 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_1 49 5 47 0   3     0   2   61 45 *                     106.0 49 5 47 0   3     0   2   61 45                 106
1371782 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary PK 02 2020   grade_1 64 3 2 0   33     0   4   60 46 *                     106.0 64 3 2 0   33     0   4   60 46                 106
1371823 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2020   grade_1 98 1 4 0   0     0   3   47 59 *                     106.0 98 1 4 0   0     0   3   47 59                 106
1366538 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2020   grade_1 75 2 7 0   20     0   3   58 49 *                     107.0 75 2 7 0   20     0   3   58 49                 107
1370040 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2020   grade_1 100 0 2 0   1     0   4   51 56 *                     107.0 100 0 2 0   1     0   4   51 56                 107
1371275 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2020   grade_1 56 17 20 1   1     0   12   53 54 *                     107.0 56 17 20 1   1     0   12   53 54                 107
1371312 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2020   grade_1 88 7 7 0   3     0   2   48 59 *                     107.0 88 7 7 0   3     0   2   48 59                 107
1371553 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   grade_1 64 5 19 0   9     0   10   56 51 *                     107.0 64 5 19 0   9     0   10   56 51                 107
1371772 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2020   grade_1 90 0 1 0   15     0   1   46 61 *                     107.0 90 0 1 0   15     0   1   46 61                 107
1373386 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2020   grade_1 83 1 8 1   7     0   7   64 43 *                     107.0 83 1 8 1   7     0   7   64 43                 107
1373959 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2020   grade_1 103 0 1 0   2     0   1   53 54 *                     107.0 103 0 1 0   2     0   1   53 54                 107
1374197 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_1 18 20 33 0   31     0   5   46 61 *                     107.0 18 20 33 0   31     0   5   46 61                 107
1365171 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_1 74 8 1 0   15     0   10   49 59 *                     108.0 74 8 1 0   15     0   10   49 59                 108
1368504 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2020   grade_1 4 9 91 0   3     0   1   63 45 *                     108.0 4 9 91 0   3     0   1   63 45                 108
1368518 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2020   grade_1 16 9 69 0   9     0   5   54 54 *                     108.0 16 9 69 0   9     0   5   54 54                 108
1373074 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2020   grade_1 90 4 11 0   0     0   3   57 51 *                     108.0 90 4 11 0   0     0   3   57 51                 108
1373711 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2020   grade_1 96 1 6 0   1     0   4   51 57 *                     108.0 96 1 6 0   1     0   4   51 57                 108
1367080 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_1 8 13 86 0   2     0   0   48 61 *                     109.0 8 13 86 0   2     0   0   48 61                 109
1369856 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No Elementary KG 05 2020   grade_1 73 4 29 0   3     0   0   49 60 *                     109.0 73 4 29 0   3     0   0   49 60                 109
1370092 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_1 3 7 0 0   0     0   1   3 8 *                     11.0 3 7 0 0   0     0   1   3 8                 11
1365229 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 04 2020   grade_1 86 4 8 0   8     0   4   52 58 *                     110.0 86 4 8 0   8     0   4   52 58                 110
1371270 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary PK 04 2020   grade_1 56 31 17 0   2     0   4   51 59 *                     110.0 56 31 17 0   2     0   4   51 59                 110
1372913 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_1 89 5 7 0   3     1   5   54 56 *                     110.0 89 5 7 0   3     1   5   54 56                 110
1367463 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_1 106 0 0 0   0     0   5   56 55 *                     111.0 106 0 0 0   0     0   5   56 55                 111
1368729 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2020   grade_1 42 3 60 0   4     0   2   58 53 *                     111.0 42 3 60 0   4     0   2   58 53                 111
1369265 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2020   grade_1 23 20 63 0   0     1   4   60 51 *                     111.0 23 20 63 0   0     1   4   60 51                 111
1371983 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2020   grade_1 93 1 3 0   7     1   6   62 49 *                     111.0 93 1 3 0   7     1   6   62 49                 111
1373867 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   grade_1 96 3 8 1   0     0   3   53 58 *                     111.0 96 3 8 1   0     0   3   53 58                 111
1367645 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2020   grade_1 50 3 52 0   2     0   5   62 50 *                     112.0 50 3 52 0   2     0   5   62 50                 112
1368988 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_1 101 2 1 1   2     0   5   60 52 *                     112.0 101 2 1 1   2     0   5   60 52                 112
1369814 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   grade_1 92 1 15 1   0     0   3   54 58 *                     112.0 92 1 15 1   0     0   3   54 58                 112
1371264 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No Elementary KG 04 2020   grade_1 78 20 7 0   0     0   7   54 58 *                     112.0 78 20 7 0   0     0   7   54 58                 112
1371706 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2020   grade_1 95 4 8 0   0     0   5   54 58 *                     112.0 95 4 8 0   0     0   5   54 58                 112
1368127 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2020   grade_1 63 8 34 0   2     0   6   63 50 *                     113.0 63 8 34 0   2     0   6   63 50                 113
1373056 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2020   grade_1 102 1 7 0   1     0   2   59 54 *                     113.0 102 1 7 0   1     0   2   59 54                 113
1365706 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_1 19 13 10 0   67     0   5   52 62 *                     114.0 19 13 10 0   67     0   5   52 62                 114
1368636 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_1 44 9 20 0   40     0   1   55 59 *                     114.0 44 9 20 0   40     0   1   55 59                 114
1368701 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_1 96 3 7 0   3     0   5   55 59 *                     114.0 96 3 7 0   3     0   5   55 59                 114
1369071 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2020   grade_1 91 10 1 1   5     0   6   50 64 *                     114.0 91 10 1 1   5     0   6   50 64                 114
1366277 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_1 76 4 15 0   8     0   12   54 60 *                     115.0 76 4 15 0   8     0   12   54 60                 115
1368115 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2020   grade_1 54 13 40 0   3     0   5   56 59 *                     115.0 54 13 40 0   3     0   5   56 59                 115
1372634 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_1 26 35 47 0   2     0   5   66 49 *                     115.0 26 35 47 0   2     0   5   66 49                 115
1373247 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   grade_1 85 7 10 1   4     0   8   58 57 *                     115.0 85 7 10 1   4     0   8   58 57                 115
1373297 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2020   grade_1 92 1 14 1   1     0   6   68 47 *                     115.0 92 1 14 1   1     0   6   68 47                 115
1365516 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2020   grade_1 1 62 49 1   3     0   0   51 65 *                     116.0 1 62 49 1   3     0   0   51 65                 116
1366196 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_1 25 67 12 0   6     0   6   64 52 *                     116.0 25 67 12 0   6     0   6   64 52                 116
1367754 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2020   grade_1 63 27 12 0   5     0   10   61 56 *                     117.0 63 27 12 0   5     0   10   61 56                 117
1367988 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   grade_1 5 3 102 0   6     0   1   59 56 *                     117.0 5 3 102 0   6     0   1   59 56                 117
1369271 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_1 52 11 48 0   0     0   6   67 50 *                     117.0 52 11 48 0   0     0   6   67 50                 117
1370125 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2020   grade_1 35 15 12 0   54     0   1   47 70 *                     117.0 35 15 12 0   54     0   1   47 70                 117
1370727 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   grade_1 89 1 6 1   14     0   6   58 59 *                     117.0 89 1 6 1   14     0   6   58 59                 117
1369232 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2020   grade_1 46 20 42 0   3     0   7   67 51 *                     118.0 46 20 42 0   3     0   7   67 51                 118
1367122 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_1 49 12 40 0   2     0   16   57 62 *                     119.0 49 12 40 0   2     0   16   57 62                 119
1368940 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_1 62 6 47 0   2     1   1   57 62 *                     119.0 62 6 47 0   2     1   1   57 62                 119
1369117 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   grade_1 62 6 42 0   4     0   5   55 64 *                     119.0 62 6 42 0   4     0   5   55 64                 119
1370840 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2020   grade_1 4 38 72 2   0     0   3   58 61 *                     119.0 4 38 72 2   0     0   3   58 61                 119
1370611 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   grade_1 12 0 0 0   0     0   0   4 8 *                     12.0 12 0 0 0   0     0   0   4 8                 12

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