Data source: Big Local News · About: Big Local

966 rows where grade = "grade_3", state = "MA" and year = 2021

View and edit SQL

year

  • 2021 · 966

grade

  • grade_3 · 966
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
1672009 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_3 117 10 11 2   3     0   1   67 77 *                     144.0 117 10 11 2   3     0   1   67 77                 144
1672027 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_3 85 3 3 0   1     0   3   48 47 *                     95.0 85 3 3 0   1     0   3   48 47                 95
1672037 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_3 30 1 7 0   2     0   0   20 20 *                     40.0 30 1 7 0   2     0   0   20 20                 40
1672042 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_3 55 0 8 0   2     0   5   38 32 *                     70.0 55 0 8 0   2     0   5   38 32                 70
1672047 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_3 47 3 10 0   3     0   1   36 28 *                     64.0 47 3 10 0   3     0   1   36 28                 64
1672052 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_3 44 2 7 0   1     0   2   26 30 *                     56.0 44 2 7 0   1     0   2   26 30                 56
1672066 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_3 38 0 5 0   0     0   4   27 20 *                     47.0 38 0 5 0   0     0   4   27 20                 47
1672072 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_3 58 2 14 0   1     0   3   42 36 *                     78.0 58 2 14 0   1     0   3   42 36                 78
1672090 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_3 19 4 8 2   6     0   2   19 21 *                     41.0 19 4 8 2   6     0   2   19 21                 41
1672097 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_3 14 3 9 0   4     0   2   14 18 *                     32.0 14 3 9 0   4     0   2   14 18                 32
1672104 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_3 29 12 9 0   5     0   4   28 31 *                     59.0 29 12 9 0   5     0   4   28 31                 59
1672111 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   grade_3 83 2 3 0   6     0   3   49 48 *                     97.0 83 2 3 0   6     0   3   49 48                 97
1672117 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover - High Plain Elementary   Regular School No Elementary KG 05 2021   grade_3 42 4 9 0   30     0   2   55 32 *                     87.0 42 4 9 0   30     0   2   55 32                 87
1672124 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover - Henry C Sanborn Elementary   Regular School No Elementary KG 05 2021   grade_3 37 2 3 0   14     0   2   26 32 *                     58.0 37 2 3 0   14     0   2   26 32                 58
1672130 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover - South Elementary   Regular School No Elementary KG 05 2021   grade_3 52 1 3 0   16     0   2   37 37 *                     74.0 52 1 3 0   16     0   2   37 37                 74
1672136 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   grade_3 55 4 6 0   20     0   1   43 43 *                     86.0 55 4 6 0   20     0   1   43 43                 86
1672156 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_3 36 3 0 0   9     0   7   31 24 *                     55.0 36 3 0 0   9     0   7   31 24                 55
1672162 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_3 51 0 1 0   8     0   8   33 35 *                     68.0 51 0 1 0   8     0   8   33 35                 68
1672168 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington - Cyrus E Dallin   Regular School No Elementary KG 05 2021   grade_3 57 1 3 0   8     0   5   41 33 *                     74.0 57 1 3 0   8     0   5   41 33                 74
1672174 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington - Hardy   Regular School No Elementary KG 05 2021   grade_3 43 3 3 0   12     0   8   25 44 *                     69.0 43 3 3 0   12     0   8   25 44                 69
1672181 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington - Peirce   Regular School No Elementary KG 05 2021   grade_3 38 4 4 0   7     0   7   33 27 *                     60.0 38 4 4 0   7     0   7   33 27                 60
1672187 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington - Thompson   Regular School No Elementary KG 05 2021   grade_3 45 1 9 0   8     0   4   28 38 *                     67.0 45 1 9 0   8     0   4   28 38                 67
1672193 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_3 56 1 3 0   5     0   9   34 40 *                     74.0 56 1 3 0   5     0   9   34 40                 74
1672207 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland - David Mindess   Regular School No Elementary 03 05 2021   grade_3 112 8 28 0   44     0   8   103 97 *                     200.0 112 8 28 0   44     0   8   103 97                 200
1672220 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro - A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2021   grade_3 53 4 8 0   2     0   1   34 34 *                     68.0 53 4 8 0   2     0   1   34 34                 68
1672226 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Attleboro - Thomas Willett Elementary School   Regular School No Elementary KG 04 2021   grade_3 42 7 9 0   3     0   9   39 31 *                     70.0 42 7 9 0   3     0   9   39 31                 70
1672231 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_3 61 3 21 0   4     0   9   48 50 *                     98.0 61 3 21 0   4     0   9   48 50                 98
1672236 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro - Hill-Roberts Elementary School   Regular School No Elementary KG 04 2021   grade_3 61 3 11 1   3     0   3   34 48 *                     82.0 61 3 11 1   3     0   3   34 48                 82
1672241 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro - Peter Thacher Elementary School   Regular School No Elementary KG 04 2021   grade_3 54 11 7 1   10     0   6   47 42 *                     89.0 54 11 7 1   10     0   6   47 42                 89
1672269 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn - Swanson Road Intermediate School   Regular School No Elementary 03 05 2021   grade_3 134 1 18 0   8     0   6   86 81 *                     167.0 134 1 18 0   8     0   6   86 81                 167
1672285 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_3 26 15 7 0   2     0   4   30 24 *                     54.0 26 15 7 0   2     0   4   30 24                 54
1672299 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_3 42 2 6 0   0     0   6   32 24 *                     56.0 42 2 6 0   0     0   6   32 24                 56
1672303 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_3 43 6 5 0   1     0   6   34 27 *                     61.0 43 6 5 0   1     0   6   34 27                 61
1672307 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_3 37 15 24 1   1     0   3   39 42 *                     81.0 37 15 24 1   1     0   3   39 42                 81
1672311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_3 26 10 26 0   2     0   13   34 43 *                     77.0 26 10 26 0   2     0   13   34 43                 77
1672315 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_3 82 1 12 0   0     0   8   51 52 *                     103.0 82 1 12 0   0     0   8   51 52                 103
1672330 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford - Lt Job Lane School   Regular School No Elementary 03 05 2021   grade_3 122 12 9 0   50     0   20   92 121 *                     213.0 122 12 9 0   50     0   20   92 121                 213
1672347 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown - Swift River Elementary   Regular School No Elementary 01 03 2021   grade_3 137 0 10 0   3     0   5   75 80 *                     155.0 137 0 10 0   3     0   5   75 80                 155
1672358 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham - Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2021   grade_3 52 2 12 0   2     2   1   34 37 *                     71.0 52 2 12 0   2     2   1   34 37                 71
1672362 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham - Stall Brook   Regular School No Elementary KG 03 2021   grade_3 59 1 2 0   1     2   3   38 30 *                     68.0 59 1 2 0   1     2   3   38 30                 68
1672379 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont - Winn Brook   Regular School No Elementary KG 04 2021   grade_3 63 2 3 0   17     0   8   51 42 *                     93.0 63 2 3 0   17     0   8   51 42                 93
1672384 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont - Mary Lee Burbank   Regular School No Elementary KG 04 2021   grade_3 40 5 3 0   18     0   8   37 37 *                     74.0 40 5 3 0   18     0   8   37 37                 74
1672389 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Belmont - Daniel Butler   Regular School No Elementary KG 04 2021   grade_3 29 0 2 0   23     0   13   38 29 *                     67.0 29 0 2 0   23     0   13   38 29                 67
1672395 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_3 82 4 3 0   17     0   8   57 57 *                     114.0 82 4 3 0   17     0   8   57 57                 114
1672409 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_3 69 1 1 0   0     0   4   36 39 *                     75.0 69 1 1 0   0     0   4   36 39                 75
1672419 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly - Centerville Elementary   Regular School No Elementary KG 04 2021   grade_3 36 1 6 0   1     0   0   20 24 *                     44.0 36 1 6 0   1     0   0   20 24                 44
1672424 MA Essex   school 2502640 30   Beverly 250264000168 300015 Beverly - Cove Elementary   Regular School No Elementary KG 04 2021   grade_3 45 0 13 0   1     0   3   32 30 *                     62.0 45 0 13 0   1     0   3   32 30                 62
1672429 MA Essex   school 2502640 30   Beverly 250264000169 300033 Beverly - Hannah Elementary   Regular School No Elementary KG 04 2021   grade_3 35 0 4 0   4     0   0   27 16 *                     43.0 35 0 4 0   4     0   0   27 16                 43
1672434 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly - North Beverly Elementary   Regular School No Elementary KG 04 2021   grade_3 47 2 6 0   2     0   1   30 28 *                     58.0 47 2 6 0   2     0   1   30 28                 58
1672439 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly - Ayers/Ryal Side School   Regular School No Elementary KG 04 2021   grade_3 104 9 25 0   5     0   9   80 72 *                     152.0 104 9 25 0   5     0   9   80 72                 152
1672453 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica - Thomas Ditson   Regular School No Elementary KG 04 2021   grade_3 83 4 7 0   11     0   6   67 44 *                     111.0 83 4 7 0   11     0   6   67 44                 111
1672458 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica - Frederick J Dutile   Regular School No Elementary KG 04 2021   grade_3 38 3 2 0   4     0   2   23 26 *                     49.0 38 3 2 0   4     0   2   23 26                 49
1672463 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica - John F Kennedy   Regular School No Elementary KG 04 2021   grade_3 51 0 7 0   3     0   5   31 35 *                     66.0 51 0 7 0   3     0   5   31 35                 66
1672468 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Billerica - Parker   Regular School No Elementary KG 04 2021   grade_3 56 5 4 0   10     0   4   34 45 *                     79.0 56 5 4 0   10     0   4   34 45                 79
1672473 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Billerica - Hajjar Elementary   Regular School No Elementary KG 04 2021   grade_3 47 2 5 0   3     0   2   25 34 *                     59.0 47 2 5 0   3     0   2   25 34                 59
1672492 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   grade_3 1 14 17 0   1     0   1   17 17 *                     34.0 1 14 17 0   1     0   1   17 17                 34
1672499 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_3 3 5 3 0   2     0   1   11 3 *                     14.0 3 5 3 0   2     0   1   11 3                 14
1672512 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   grade_3 2 20 12 1   0     0   0   22 13 *                     35.0 2 20 12 1   0     0   0   22 13                 35
1672523 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_3 17 5 2 0   0     0   0   13 11 *                     24.0 17 5 2 0   0     0   0   13 11                 24
1672533 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_3 4 18 20 1   5     0   0   25 23 *                     48.0 4 18 20 1   5     0   0   25 23                 48
1672543 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston - Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2021   grade_3 0 24 10 0   0     0   0   16 18 *                     34.0 0 24 10 0   0     0   0   16 18                 34
1672552 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Boston - Mattahunt Elementary School   Regular School No Elementary PK 04 2021   grade_3 3 45 17 0   0     0   4   42 27 *                     69.0 3 45 17 0   0     0   4   42 27                 69
1672558 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_3 32 15 35 0   1     0   13   57 39 *                     96.0 32 15 35 0   1     0   13   57 39                 96
1672576 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston - Charles Sumner   Regular School No Elementary PK 05 2021   grade_3 16 13 41 0   2     0   4   42 34 *                     76.0 16 13 41 0   2     0   4   42 34                 76
1672583 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston - Charles H Taylor   Regular School No Elementary PK 05 2021   grade_3 0 46 14 0   1     0   0   31 30 *                     61.0 0 46 14 0   1     0   0   31 30                 61
1672590 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston - Curtis Guild   Regular School No Elementary PK 06 2021   grade_3 6 1 32 0   0     0   0   18 21 *                     39.0 6 1 32 0   0     0   0   18 21                 39
1672598 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_3 1 1 10 0   1     0   1   6 8 *                     14.0 1 1 10 0   1     0   1   6 8                 14
1672606 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston - David A Ellis   Regular School No Elementary PK 05 2021   grade_3 1 23 29 0   0     0   2   31 24 *                     55.0 1 23 29 0   0     0   2   31 24                 55
1672620 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_3 14 9 18 0   1     0   2   20 24 *                     44.0 14 9 18 0   1     0   2   20 24                 44
1672630 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_3 6 4 71 0   0     0   3   41 43 *                     84.0 6 4 71 0   0     0   3   41 43                 84
1672640 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston - Edward Everett   Regular School No Elementary PK 06 2021   grade_3 1 17 15 0   5     0   1   21 18 *                     39.0 1 17 15 0   5     0   1   21 18                 39
1672648 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_3 67 5 8 0   8     1   5   52 42 *                     94.0 67 5 8 0   8     1   5   52 42                 94
1672658 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston - Ellis Mendell   Regular School No Elementary PK 05 2021   grade_3 12 20 9 0   1     0   2   22 22 *                     44.0 12 20 9 0   1     0   2   22 22                 44
1672665 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_3 4 17 13 0   1     0   2   25 12 *                     37.0 4 17 13 0   1     0   2   25 12                 37
1672675 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_3 2 7 9 0   0     0   0   12 6 *                     18.0 2 7 9 0   0     0   0   12 6                 18
1672683 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Boston - Henry Grew   Regular School No Elementary PK 05 2021   grade_3 3 14 16 0   0     0   1   16 18 *                     34.0 3 14 16 0   0     0   1   16 18                 34
1672690 MA Suffolk   school 2502790 35   Boston 250279002569 350138 Boston - O W Holmes   Regular School No Elementary PK 05 2021   grade_3 0 20 11 0   0     0   2   17 16 *                     33.0 0 20 11 0   0     0   2   17 16                 33
1672697 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_3 2 1 40 0   0     0   0   28 15 *                     43.0 2 1 40 0   0     0   0   28 15                 43
1672705 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_3 9 33 26 0   6     0   6   43 37 *                     80.0 9 33 26 0   6     0   6   43 37                 80
1672714 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_3 4 20 35 0   2     0   0   31 30 *                     61.0 4 20 35 0   2     0   0   31 30                 61
1672724 MA Suffolk   school 2502790 35   Boston 250279000255 350154 Boston - James J Chittick   Regular School No Elementary PK 05 2021   grade_3 0 21 14 0   0     0   0   10 25 *                     35.0 0 21 14 0   0     0   0   10 25                 35
1672731 MA Suffolk   school 2502790 35   Boston 250279000257 350156 Boston - James Otis   Regular School No Elementary PK 06 2021   grade_3 14 2 43 0   1     0   0   28 32 *                     60.0 14 2 43 0   1     0   0   28 32                 60
1672739 MA Suffolk   school 2502790 35   Boston 250279000265 350166 Boston - John F Kennedy   Regular School No Elementary PK 05 2021   grade_3 5 10 40 0   0     0   3   29 29 *                     58.0 5 10 40 0   0     0   3   29 29                 58
1672746 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   grade_3 0 58 44 1   2     0   3   57 51 *                     108.0 0 58 44 1   2     0   3   57 51                 108
1672753 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston - John D Philbrick   Regular School No Elementary PK 05 2021   grade_3 0 10 5 0   0     0   0   9 6 *                     15.0 0 10 5 0   0     0   0   9 6                 15
1672763 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston - John Winthrop   Regular School No Elementary PK 05 2021   grade_3 2 23 10 0   0     0   1   19 17 *                     36.0 2 23 10 0   0     0   1   19 17                 36
1672770 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston - Joseph P Tynan   Regular School No Elementary PK 06 2021   grade_3 0 9 7 0   0     0   4   7 13 *                     20.0 0 9 7 0   0     0   4   7 13                 20
1672778 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_3 9 1 30 0   0     0   2   17 25 *                     42.0 9 1 30 0   0     0   2   17 25                 42
1672788 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_3 4 30 16 1   1     0   2   35 19 *                     54.0 4 30 16 1   1     0   2   35 19                 54
1672798 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston - Joseph P Manning   Regular School No Elementary PK 06 2021   grade_3 12 4 5 0   1     0   3   11 14 *                     25.0 12 4 5 0   1     0   3   11 14                 25
1672806 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_3 30 2 5 0   9     0   2   28 20 *                     48.0 30 2 5 0   9     0   2   28 20                 48
1672816 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Boston - Harvard-Kent   Regular School No Elementary PK 06 2021   grade_3 10 9 17 0   8     0   1   24 21 *                     45.0 10 9 17 0   8     0   1   24 21                 45
1672824 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Boston - Manassah E Bradley   Regular School No Elementary PK 06 2021   grade_3 14 1 20 0   6     0   2   23 20 *                     43.0 14 1 20 0   6     0   2   23 20                 43
1672832 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Boston - Mather   Regular School No Elementary PK 05 2021   grade_3 2 28 17 0   21     0   6   34 40 *                     74.0 2 28 17 0   21     0   6   34 40                 74
1672839 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_3 3 11 35 0   1     0   0   20 30 *                     50.0 3 11 35 0   1     0   0   20 30                 50
1672849 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_3 2 6 7 0   1     0   1   7 10 *                     17.0 2 6 7 0   1     0   1   7 10                 17
1672857 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Boston - Mozart   Regular School No Elementary PK 05 2021   grade_3 7 8 6 1   1     0   1   19 5 *                     24.0 7 8 6 1   1     0   1   19 5                 24
1672864 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_3 8 18 12 0   48     0   4   46 44 *                     90.0 8 18 12 0   48     0   4   46 44                 90
1672874 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_3 3 13 6 0   1     0   0   13 10 *                     23.0 3 13 6 0   1     0   0   13 10                 23
1672882 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_3 20 5 5 0   0     0   0   18 12 *                     30.0 20 5 5 0   0     0   0   18 12                 30

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