enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1121968 1121968 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_2 92 1 6 0   0     0   3   44 58                       102 92 1 6 0   0     0   3   44 58                 102
1121981 1121981 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_2 53 0 11 0   1     0   1   39 27                       66 53 0 11 0   1     0   1   39 27                 66
1121987 1121987 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_2 66 3 2 0   1     0   0   51 21                       72 66 3 2 0   1     0   0   51 21                 72
1121993 1121993 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_2 46 1 6 0   4     0   4   37 24                       61 46 1 6 0   4     0   4   37 24                 61
1121999 1121999 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_2 50 4 5 0   1     0   1   31 30                       61 50 4 5 0   1     0   1   31 30                 61
1122019 1122019 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_2 72 1 6 0   1     0   5   42 43                       85 72 1 6 0   1     0   5   42 43                 85
1122026 1122026 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_2 77 2 4 1   3     0   2   48 41                       89 77 2 4 1   3     0   2   48 41                 89
1122048 1122048 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_2 22 1 17 0   6     0   4   25 25                       50 22 1 17 0   6     0   4   25 25                 50
1122056 1122056 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_2 19 1 9 0   9     0   4   21 21                       42 19 1 9 0   9     0   4   21 21                 42
1122064 1122064 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_2 29 4 10 0   11     0   5   35 24                       59 29 4 10 0   11     0   5   35 24                 59
1122072 1122072 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_2 73 7 4 1   6     0   5   47 49                       96 73 7 4 1   6     0   5   47 49                 96
1122079 1122079 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_2 42 1 7 0   21     0   2   41 32                       73 42 1 7 0   21     0   2   41 32                 73
1122088 1122088 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_2 42 2 3 0   20     0   1   36 32                       68 42 2 3 0   20     0   1   36 32                 68
1122095 1122095 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_2 50 0 2 0   16     0   0   41 27                       68 50 0 2 0   16     0   0   41 27                 68
1122102 1122102 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_2 82 1 5 0   15     0   4   50 57                       107 82 1 5 0   15     0   4   50 57                 107
1122126 1122126 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_2 49 3 1 0   10     0   6   40 29                       69 49 3 1 0   10     0   6   40 29                 69
1122133 1122133 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_2 68 1 8 0   7     1   8   48 45                       93 68 1 8 0   7     1   8   48 45                 93
1122140 1122140 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_2 61 1 4 0   8     0   5   37 42                       79 61 1 4 0   8     0   5   37 42                 79
1122147 1122147 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_2 47 4 6 1   14     0   4   46 30                       76 47 4 6 1   14     0   4   46 30                 76
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1122163 1122163 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_2 55 4 6 1   13     1   6   46 40                       86 55 4 6 1   13     1   6   46 40                 86
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1122205 1122205 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_2 61 1 28 0   2     0   2   47 47                       94 61 1 28 0   2     0   2   47 47                 94
1122213 1122213 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_2 62 4 9 0   4     0   11   47 43                       90 62 4 9 0   4     0   11   47 43                 90
1122219 1122219 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_2 63 4 6 0   0     0   8   34 47                       81 63 4 6 0   0     0   8   34 47                 81
1122225 1122225 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2017   grade_2 56 4 10 0   2     0   5   46 31                       77 56 4 10 0   2     0   5   46 31                 77
1122231 1122231 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2017   grade_2 45 4 13 0   4     0   9   41 34                       75 45 4 13 0   4     0   9   41 34                 75
1122261 1122261 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_2 67 2 11 0   6     0   2   45 43                       88 67 2 11 0   6     0   2   45 43                 88
1122265 1122265 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   grade_2 76 2 10 0   3     0   2   49 44                       93 76 2 10 0   3     0   2   49 44                 93
1122284 1122284 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2017   grade_2 31 15 6 0   0     0   0   26 26                       52 31 15 6 0   0     0   0   26 26                 52
1122301 1122301 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_2 55 5 2 0   0     0   5   37 30                       67 55 5 2 0   0     0   5   37 30                 67
1122306 1122306 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_2 64 5 8 0   1     0   1   39 40                       79 64 5 8 0   1     0   1   39 40                 79
1122311 1122311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   grade_2 37 16 23 0   3     0   11   50 40                       90 37 16 23 0   3     0   11   50 40                 90
1122316 1122316 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_2 110 3 4 1   0     0   4   58 64                       122 110 3 4 1   0     0   4   58 64                 122
1122333 1122333 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_2 137 14 10 0   35     0   10   103 103                       206 137 14 10 0   35     0   10   103 103                 206
1122357 1122357 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_2 138 3 12 1   1     0   6   83 78                       161 138 3 12 1   1     0   6   83 78                 161
1122372 1122372 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No Elementary KG 03 2017   grade_2 89 0 2 0   2     0   1   47 47                       94 89 0 2 0   2     0   1   47 47                 94
1122377 1122377 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2017   grade_2 79 2 3 0   2     0   3   38 51                       89 79 2 3 0   2     0   3   38 51                 89
1122397 1122397 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2017   grade_2 64 0 3 0   24     0   5   51 45                       96 64 0 3 0   24     0   5   51 45                 96
1122403 1122403 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2017   grade_2 64 3 4 0   12     0   8   45 46                       91 64 3 4 0   12     0   8   45 46                 91
1122409 1122409 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2017   grade_2 43 3 9 0   23     0   4   48 34                       82 43 3 9 0   23     0   4   48 34                 82
1122416 1122416 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_2 97 3 0 0   15     0   7   63 59                       122 97 3 0 0   15     0   7   63 59                 122
1122433 1122433 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_2 86 0 1 0   0     0   3   48 42                       90 86 0 1 0   0     0   3   48 42                 90
1122445 1122445 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_2 20 0 0 0   0     0   0   14 6                       20 20 0 0 0   0     0   0   14 6                 20
1122454 1122454 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 05 2017   grade_2 43 2 8 0   0     0   5   32 26                       58 43 2 8 0   0     0   5   32 26                 58
1122461 1122461 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 05 2017   grade_2 69 3 6 0   1     0   4   42 41                       83 69 3 6 0   1     0   4   42 41                 83
1122468 1122468 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 05 2017   grade_2 67 1 8 0   1     0   2   35 44                       79 67 1 8 0   1     0   2   35 44                 79
1122475 1122475 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 05 2017   grade_2 49 3 9 1   0     0   0   32 30                       62 49 3 9 1   0     0   0   32 30                 62
1122482 1122482 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 05 2017   grade_2 72 4 10 0   6     0   2   47 47                       94 72 4 10 0   6     0   2   47 47                 94
1122498 1122498 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 05 2017   grade_2 65 3 5 0   8     0   8   40 49                       89 65 3 5 0   8     0   8   40 49                 89
1122505 1122505 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Frederick J Dutile   Regular School No Elementary KG 05 2017   grade_2 46 2 2 0   4     0   2   27 29                       56 46 2 2 0   4     0   2   27 29                 56
1122512 1122512 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2017   grade_2 45 0 2 0   1     0   3   25 26                       51 45 0 2 0   1     0   3   25 26                 51
1122519 1122519 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2017   grade_2 62 6 5 0   11     0   3   52 35                       87 62 6 5 0   11     0   3   52 35                 87
1122526 1122526 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No Elementary KG 05 2017   grade_2 49 2 10 0   5     0   2   40 28                       68 49 2 10 0   5     0   2   40 28                 68
1122533 1122533 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2017   grade_2 25 1 2 0   0     0   3   13 18                       31 25 1 2 0   0     0   3   13 18                 31
1122555 1122555 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 02 2017   grade_2 1 34 11 1   1     0   5   29 24                       53 1 34 11 1   1     0   5   29 24                 53
1122563 1122563 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_2 3 3 4 0   3     0   1   7 7                       14 3 3 4 0   3     0   1   7 7                 14
1122578 1122578 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2017   grade_2 1 17 16 0   0     0   1   22 13                       35 1 17 16 0   0     0   1   22 13                 35
1122592 1122592 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_2 11 4 9 0   0     0   0   11 13                       24 11 4 9 0   0     0   0   11 13                 24
1122603 1122603 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2017   grade_2 4 28 37 0   9     0   2   53 27                       80 4 28 37 0   9     0   2   53 27                 80
1122614 1122614 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 02 2017   grade_2 4 37 20 0   1     0   3   35 30                       65 4 37 20 0   1     0   3   35 30                 65
1122619 1122619 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2017   grade_2 0 23 24 0   0     1   2   25 25                       50 0 23 24 0   0     1   2   25 25                 50
1122624 1122624 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_2 20 14 45 0   1     0   2   35 47                       82 20 14 45 0   1     0   2   35 47                 82
1122635 1122635 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 03 2017   grade_2 39 29 38 0   4     0   1   54 57                       111 39 29 38 0   4     0   1   54 57                 111
1122647 1122647 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2017   grade_2 16 20 56 0   2     0   4   61 37                       98 16 20 56 0   2     0   4   61 37                 98
1122655 1122655 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2017   grade_2 0 77 14 1   1     1   3   50 47                       97 0 77 14 1   1     1   3   50 47                 97
1122663 1122663 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_2 11 0 41 0   1     0   0   27 26                       53 11 0 41 0   1     0   0   27 26                 53
1122671 1122671 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_2 5 0 9 0   0     0   2   9 7                       16 5 0 9 0   0     0   2   9 7                 16
1122680 1122680 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   grade_2 4 28 38 0   0     0   3   42 31                       73 4 28 38 0   0     0   3   42 31                 73
1122696 1122696 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_2 15 13 13 1   0     1   1   24 20                       44 15 13 13 1   0     1   1   24 20                 44
1122707 1122707 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_2 7 1 77 0   0     0   0   46 39                       85 7 1 77 0   0     0   0   46 39                 85
1122718 1122718 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2017   grade_2 0 18 13 0   8     0   1   21 19                       40 0 18 13 0   8     0   1   21 19                 40
1122726 1122726 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_2 53 3 15 0   6     0   8   43 42                       85 53 3 15 0   6     0   8   43 42                 85
1122737 1122737 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_2 16 7 12 0   0     0   6   16 25                       41 16 7 12 0   0     0   6   16 25                 41
1122745 1122745 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_2 8 14 15 0   1     0   2   21 19                       40 8 14 15 0   1     0   2   21 19                 40
1122756 1122756 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   grade_2 4 8 13 0   1     0   1   15 12                       27 4 8 13 0   1     0   1   15 12                 27
1122764 1122764 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2017   grade_2 4 15 14 0   1     1   6   22 19                       41 4 15 14 0   1     1   6   22 19                 41
1122772 1122772 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2017   grade_2 3 38 14 0   2     1   1   30 29                       59 3 38 14 0   2     1   1   30 29                 59
1122780 1122780 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2017   grade_2 1 0 39 0   1     0   1   20 22                       42 1 0 39 0   1     0   1   20 22                 42
1122788 1122788 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_2 32 29 23 0   14     0   2   54 46                       100 32 29 23 0   14     0   2   54 46                 100
1122797 1122797 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_2 5 20 33 0   1     0   2   29 32                       61 5 20 33 0   1     0   2   29 32                 61
1122808 1122808 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2017   grade_2 1 24 12 0   1     0   4   24 18                       42 1 24 12 0   1     0   4   24 18                 42
1122816 1122816 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2017   grade_2 19 5 34 0   2     0   1   35 26                       61 19 5 34 0   2     0   1   35 26                 61
1122824 1122824 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2017   grade_2 5 12 48 0   0     0   0   27 38                       65 5 12 48 0   0     0   0   27 38                 65
1122832 1122832 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   grade_2 4 62 50 0   4     0   0   60 60                       120 4 62 50 0   4     0   0   60 60                 120
1122840 1122840 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_2 10 16 15 0   0     0   2   24 19                       43 10 16 15 0   0     0   2   24 19                 43
1122852 1122852 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   grade_2 0 23 22 0   1     1   2   22 27                       49 0 23 22 0   1     1   2   22 27                 49
1122860 1122860 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_2 12 15 10 0   3     0   5   27 18                       45 12 15 10 0   3     0   5   27 18                 45
1122868 1122868 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_2 7 4 34 0   0     0   3   26 22                       48 7 4 34 0   0     0   3   26 22                 48
1122879 1122879 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_2 4 33 12 0   2     0   3   32 22                       54 4 33 12 0   2     0   3   32 22                 54
1122890 1122890 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_2 14 5 5 0   0     1   2   18 9                       27 14 5 5 0   0     1   2   18 9                 27
1122898 1122898 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_2 27 2 6 0   6     0   3   23 21                       44 27 2 6 0   6     0   3   23 21                 44
1122909 1122909 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2017   grade_2 10 19 24 1   20     0   3   44 33                       77 10 19 24 1   20     0   3   44 33                 77
1122917 1122917 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2017   grade_2 15 0 19 0   4     0   1   18 21                       39 15 0 19 0   4     0   1   18 21                 39
1122925 1122925 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   grade_2 2 78 24 0   0     0   1   49 56                       105 2 78 24 0   0     0   1   49 56                 105
1122933 1122933 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2017   grade_2 5 33 14 0   35     0   7   48 46                       94 5 33 14 0   35     0   7   48 46                 94
1122941 1122941 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_2 2 32 43 0   0     0   1   40 38                       78 2 32 43 0   0     0   1   40 38                 78
1122951 1122951 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   grade_2 3 15 14 1   2     0   2   15 22                       37 3 15 14 1   2     0   2   15 22                 37

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