Data source: Big Local News · About: Big Local

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

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
2040105 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_3 57 4 6 0   1     0   2   42 28                       70.0 57 4 6 0   1     0   2   42 28                 70
2040109 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_3 61 4 5 0   0     0   2   37 35                       72.0 61 4 5 0   0     0   2   37 35                 72
2040113 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_3 30 14 41 1   3     0   3   50 42                       92.0 30 14 41 1   3     0   3   50 42                 92
2040117 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_3 83 4 5 0   0     0   4   56 40                       96.0 83 4 5 0   0     0   4   56 40                 96
2040149 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2019   grade_3 134 4 5 2   3     0   6   84 70                       154.0 134 4 5 2   3     0   6   84 70                 154
2040161 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_3 80 0 4 0   1     0   0   47 38                       85.0 80 0 4 0   1     0   0   47 38                 85
2040165 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_3 51 0 1 0   2     0   3   30 27                       57.0 51 0 1 0   2     0   3   30 27                 57
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
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
2040364 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   grade_3 2 34 3 0   2     0   3   23 21                       44.0 2 34 3 0   2     0   3   23 21                 44
2042936 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2019   grade_3 2 3 56 0   0     0   0   35 26                       61.0 2 3 56 0   0     0   0   35 26                 61
2042963 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2019   grade_3 180 1 9 1   64     0   13   136 132                       268.0 180 1 9 1   64     0   13   136 132                 268
2043300 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2019   grade_3 36 2 22 0   3     1   4   34 34                       68.0 36 2 22 0   3     1   4   34 34                 68
2043514 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2019   grade_3 126 3 28 1   1     0   6   74 91                       165.0 126 3 28 1   1     0   6   74 91                 165
2043770 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No Elementary KG 03 2019   grade_3 46 2 8 0   0     0   2   29 29                       58.0 46 2 8 0   0     0   2   29 29                 58
2043773 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 03 2019   grade_3 61 0 4 0   1     1   5   39 33                       72.0 61 0 4 0   1     1   5   39 33                 72
2043781 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2019   grade_3 62 1 6 0   0     0   6   44 31                       75.0 62 1 6 0   0     0   6   44 31                 75
2043880 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2019   grade_3 49 1 5 0   1     0   4   32 28                       60.0 49 1 5 0   1     0   4   32 28                 60
2043888 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2019   grade_3 85 0 13 0   1     0   6   54 51                       105.0 85 0 13 0   1     0   6   54 51                 105
2043904 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2019   grade_3 174 4 6 0   11     0   6   98 103                       201.0 174 4 6 0   11     0   6   98 103                 201
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
2044432 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2019   grade_3 134 2 10 0   0     0   0   77 69                       146.0 134 2 10 0   0     0   0   77 69                 146
2044786 MA Bristol   school 2509000 218   Norton 250900001450 2180010 L G Nourse Elementary   Regular School No Elementary KG 03 2019   grade_3 58 2 2 0   0     1   4   31 36                       67.0 58 2 2 0   0     1   4   31 36                 67
2044791 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2019   grade_3 85 0 3 0   2     0   7   55 42                       97.0 85 0 3 0   2     0   7   55 42                 97
2045093 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2019   grade_3 73 4 8 0   2     0   2   47 42                       89.0 73 4 8 0   2     0   2   47 42                 89
2045807 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2019   grade_3 94 3 7 0   23     1   6   74 60                       134.0 94 3 7 0   23     1   6   74 60                 134
2046420 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2019   grade_3 81 0 2 1   1     0   2   51 36                       87.0 81 0 2 1   1     0   2   51 36                 87
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
2046588 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2019   grade_3 80 0 8 0   0     0   1   46 43                       89.0 80 0 8 0   0     0   1   46 43                 89
2046747 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2019   grade_3 65 2 3 0   27     0   0   57 40                       97.0 65 2 3 0   27     0   0   57 40                 97
2046751 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2019   grade_3 51 1 1 0   40     0   1   46 48                       94.0 51 1 1 0   40     0   1   46 48                 94
2046756 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2019   grade_3 45 3 10 0   30     0   5   46 47                       93.0 45 3 10 0   30     0   5   46 47                 93
2046782 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2019   grade_3 76 5 0 0   1     0   5   43 44                       87.0 76 5 0 0   1     0   5   43 44                 87
2046880 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2019   grade_3 46 6 9 0   15     0   10   37 49                       86.0 46 6 9 0   15     0   10   37 49                 86
2046887 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   grade_3 45 6 3 0   11     0   1   32 34                       66.0 45 6 3 0   11     0   1   32 34                 66
2047056 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_3 124 1 5 0   11     0   6   69 78                       147.0 124 1 5 0   11     0   6   69 78                 147
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
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
2047608 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_3 25 20 18 0   2     0   5   33 37                       70.0 25 20 18 0   2     0   5   33 37                 70
2048106 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   grade_3 68 1 1 0   1     0   5   29 47                       76.0 68 1 1 0   1     0   5   29 47                 76
2048235 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   grade_3 192 11 1 0   4     0   12   110 110                       220.0 192 11 1 0   4     0   12   110 110                 220
2048302 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2019   grade_3 59 11 9 1   3     0   8   52 39                       91.0 59 11 9 1   3     0   8   52 39                 91
2048307 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2019   grade_3 33 7 10 2   1     0   5   32 26                       58.0 33 7 10 2   1     0   5   32 26                 58
2048311 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   grade_3 86 7 10 0   3     0   11   60 57                       117.0 86 7 10 0   3     0   11   60 57                 117
2048399 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2019   grade_3 92 3 3 0   1     0   0   51 48                       99.0 92 3 3 0   1     0   0   51 48                 99
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
2048526 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2019   grade_3 128 1 13 1   2     0   8   84 69                       153.0 128 1 13 1   2     0   8   84 69                 153
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
2039829 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_3 98 0 5 0   0     0   6   57 52                       109.0 98 0 5 0   0     0   6   57 52                 109
2039839 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_3 36 1 9 0   0     0   2   23 25                       48.0 36 1 9 0   0     0   2   23 25                 48
2039844 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_3 56 0 2 0   2     0   0   35 25                       60.0 56 0 2 0   2     0   0   35 25                 60
2039849 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_3 66 1 6 0   3     0   2   38 40                       78.0 66 1 6 0   3     0   2   38 40                 78
2039854 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_3 56 1 7 0   1     0   3   35 33                       68.0 56 1 7 0   1     0   3   35 33                 68
2039869 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_3 61 2 2 1   0     0   4   30 40                       70.0 61 2 2 1   0     0   4   30 40                 70
2039875 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_3 82 2 10 0   2     0   1   59 38                       97.0 82 2 10 0   2     0   1   59 38                 97
2040024 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_3 58 2 13 0   5     1   11   53 37                       90.0 58 2 13 0   5     1   11   53 37                 90
2040030 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_3 61 9 12 0   2     0   4   48 40                       88.0 61 9 12 0   2     0   4   48 40                 88
2040035 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2019   grade_3 70 5 17 0   8     0   5   60 45                       105.0 70 5 17 0   8     0   5   60 45                 105
2040040 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2019   grade_3 71 6 12 0   8     0   9   59 47                       106.0 71 6 12 0   8     0   9   59 47                 106
2040045 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2019   grade_3 45 7 8 1   7     0   13   40 41                       81.0 45 7 8 1   7     0   13   40 41                 81
2040183 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2019   grade_3 58 3 3 0   24     0   8   51 45                       96.0 58 3 3 0   24     0   8   51 45                 96
2040188 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2019   grade_3 44 4 4 0   14     0   6   34 38                       72.0 44 4 4 0   14     0   6   34 38                 72
2040193 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2019   grade_3 36 3 3 2   22     0   6   37 35                       72.0 36 3 3 2   22     0   6   37 35                 72
2040199 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   grade_3 80 2 3 0   13     0   13   62 49                       111.0 80 2 3 0   13     0   13   62 49                 111
2040213 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_3 88 0 3 0   0     0   4   38 57                       95.0 88 0 3 0   0     0   4   38 57                 95
2040230 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2019   grade_3 46 0 14 0   0     0   3   31 32                       63.0 46 0 14 0   0     0   3   31 32                 63
2040235 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2019   grade_3 59 0 10 0   2     0   5   36 40                       76.0 59 0 10 0   2     0   5   36 40                 76
2040240 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2019   grade_3 44 3 5 0   1     0   3   33 23                       56.0 44 3 5 0   1     0   3   33 23                 56
2040245 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 04 2019   grade_3 43 2 15 0   0     0   3   26 37                       63.0 43 2 15 0   0     0   3   26 37                 63
2040250 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2019   grade_3 69 6 11 0   3     0   4   50 43                       93.0 69 6 11 0   3     0   4   50 43                 93
2041115 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_3 56 2 5 1   0     1   4   35 34                       69.0 56 2 5 1   0     1   4   35 34                 69
2041120 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   grade_3 73 2 10 0   1     1   2   42 47                       89.0 73 2 10 0   1     1   2   42 47                 89
2041610 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2019   grade_3 53 5 4 0   18     0   3   43 40                       83.0 53 5 4 0   18     0   3   43 40                 83
2041615 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2019   grade_3 60 1 10 0   8     0   2   42 39                       81.0 60 1 10 0   8     0   2   42 39                 81
2041620 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2019   grade_3 56 3 13 0   12     0   4   46 42                       88.0 56 3 13 0   12     0   4   46 42                 88
2041625 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2019   grade_3 75 2 9 0   7     0   3   54 42                       96.0 75 2 9 0   7     0   3   54 42                 96
2041644 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_3 7 5 101 0   2     0   1   58 58                       116.0 7 5 101 0   2     0   1   58 58                 116
2041648 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_3 13 8 113 0   1     0   4   83 56                       139.0 13 8 113 0   1     0   4   83 56                 139
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
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
2042018 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2019   grade_3 33 0 6 0   1     0   1   25 16                       41.0 33 0 6 0   1     0   1   25 16                 41
2042024 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2019   grade_3 34 0 6 0   2     0   1   23 20                       43.0 34 0 6 0   2     0   1   23 20                 43
2042029 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2019   grade_3 30 1 7 0   0     0   4   27 15                       42.0 30 1 7 0   0     0   4   27 15                 42
2042287 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_3 37 2 4 0   1     0   6   24 26                       50.0 37 2 4 0   1     0   6   24 26                 50
2042293 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   grade_3 43 5 3 0   0     0   0   21 30                       51.0 43 5 3 0   0     0   0   21 30                 51
2042298 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2019   grade_3 71 1 7 0   2     0   6   50 37                       87.0 71 1 7 0   2     0   6   50 37                 87
2042303 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_3 59 1 4 0   0     0   4   26 42                       68.0 59 1 4 0   0     0   4   26 42                 68
2042318 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   grade_3 32 8 63 1   4     0   4   62 50                       112.0 32 8 63 1   4     0   4   62 50                 112
2042324 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   grade_3 39 6 64 0   3     0   7   61 58                       119.0 39 6 64 0   3     0   7   61 58                 119
2042334 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_3 34 9 63 1   5     0   8   56 64                       120.0 34 9 63 1   5     0   8   56 64                 120
2042375 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2019   grade_3 32 2 5 1   2     0   1   24 19                       43.0 32 2 5 1   2     0   1   24 19                 43
2042380 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2019   grade_3 59 2 4 0   2     0   1   29 39                       68.0 59 2 4 0   2     0   1   29 39                 68
2042385 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2019   grade_3 38 2 0 2   3     0   1   29 17                       46.0 38 2 0 2   3     0   1   29 17                 46
2042400 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_3 45 2 14 0   6     0   6   36 37                       73.0 45 2 14 0   6     0   6   36 37                 73
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
2042627 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2019   grade_3 26 2 12 0   0     0   5   23 22                       45.0 26 2 12 0   0     0   5   23 22                 45
2042632 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_3 45 0 6 0   0     0   0   30 21                       51.0 45 0 6 0   0     0   0   30 21                 51
2042637 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2019   grade_3 24 2 15 0   2     0   3   21 25                       46.0 24 2 15 0   2     0   3   21 25                 46
2042679 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 04 2019   grade_3 70 2 1 0   1     0   0   37 37                       74.0 70 2 1 0   1     0   0   37 37                 74
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

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