enrollments

Data source: Big Local News · About: Big Local

979 rows where grade = "grade_1", state = "MA" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 979 ✖

grade ✖

  • grade_1 · 979 ✖
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
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2039827 2039827 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_1 95 3 4 0   1     0   2   55 50                       105.0 95 3 4 0   1     0   2   55 50                 105
2039837 2039837 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_1 28 1 7 0   3     0   0   17 22                       39.0 28 1 7 0   3     0   0   17 22                 39
2039842 2039842 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_1 57 1 4 0   2     0   6   42 28                       70.0 57 1 4 0   2     0   6   42 28                 70
2039847 2039847 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_1 53 4 9 0   3     0   2   37 34                       71.0 53 4 9 0   3     0   2   37 34                 71
2039852 2039852 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_1 46 2 8 0   2     0   2   30 30                       60.0 46 2 8 0   2     0   2   30 30                 60
2039867 2039867 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_1 59 0 7 0   0     0   5   42 29                       71.0 59 0 7 0   0     0   5   42 29                 71
2039873 2039873 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_1 62 2 8 0   1     0   2   38 37                       75.0 62 2 8 0   1     0   2   38 37                 75
2039892 2039892 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_1 18 4 8 2   3     0   5   21 18                       40.0 18 4 8 2   3     0   5   21 18                 40
2039899 2039899 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_1 14 2 9 0   5     0   3   12 21                       33.0 14 2 9 0   5     0   3   12 21                 33
2039906 2039906 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_1 30 5 10 0   10     0   5   28 32                       60.0 30 5 10 0   10     0   5   28 32                 60
2039913 2039913 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_1 82 2 2 0   9     0   1   48 48                       96.0 82 2 2 0   9     0   1   48 48                 96
2039919 2039919 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_1 40 3 6 0   21     0   3   46 27                       73.0 40 3 6 0   21     0   3   46 27                 73
2039926 2039926 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_1 35 1 6 0   9     0   1   21 31                       52.0 35 1 6 0   9     0   1   21 31                 52
2039932 2039932 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_1 56 1 1 1   13     0   2   39 35                       74.0 56 1 1 1   13     0   2   39 35                 74
2039938 2039938 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_1 63 2 5 0   17     0   0   46 41                       87.0 63 2 5 0   17     0   0   46 41                 87
2039958 2039958 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_1 41 4 0 0   14     0   8   40 27                       67.0 41 4 0 0   14     0   8   40 27                 67
2039964 2039964 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_1 61 0 1 0   9     0   9   42 38                       80.0 61 0 1 0   9     0   9   42 38                 80
2039970 2039970 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_1 57 0 3 0   7     0   5   41 31                       72.0 57 0 3 0   7     0   5   41 31                 72
2039976 2039976 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_1 51 4 4 0   12     0   8   36 43                       79.0 51 4 4 0   12     0   8   36 43                 79
2039983 2039983 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_1 43 4 6 0   8     0   7   34 34                       68.0 43 4 6 0   8     0   7   34 34                 68
2039989 2039989 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_1 50 1 10 0   11     0   6   35 43                       78.0 50 1 10 0   11     0   6   35 43                 78
2039995 2039995 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_1 56 1 3 0   6     0   10   36 40                       76.0 56 1 3 0   6     0   10   36 40                 76
2040009 2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
2040022 2040022 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_1 54 4 7 0   1     0   2   37 31                       68.0 54 4 7 0   1     0   2   37 31                 68
2040028 2040028 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_1 44 7 11 0   3     0   6   38 33                       71.0 44 7 11 0   3     0   6   38 33                 71
2040033 2040033 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2019   grade_1 56 4 16 0   7     0   7   42 48                       90.0 56 4 16 0   7     0   7   42 48                 90
2040038 2040038 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2019   grade_1 59 4 11 1   4     0   3   37 45                       82.0 59 4 11 1   4     0   3   37 45                 82
2040043 2040043 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2019   grade_1 59 10 6 1   9     0   7   47 45                       92.0 59 10 6 1   9     0   7   47 45                 92
2040068 2040068 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_1 79 1 11 0   3     0   2   52 44                       96.0 79 1 11 0   3     0   2   52 44                 96
2040072 2040072 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   grade_1 62 0 7 0   2     0   4   37 38                       75.0 62 0 7 0   2     0   4   37 38                 75
2040088 2040088 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   grade_1 29 10 7 0   2     0   3   31 20                       51.0 29 10 7 0   2     0   3   31 20                 51
2040103 2040103 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_1 51 3 6 0   0     0   7   39 28                       67.0 51 3 6 0   0     0   7   39 28                 67
2040107 2040107 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_1 45 4 7 0   1     0   6   34 29                       63.0 45 4 7 0   1     0   6   34 29                 63
2040111 2040111 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_1 32 9 21 0   2     0   13   35 42                       77.0 32 9 21 0   2     0   13   35 42                 77
2040115 2040115 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_1 88 2 12 0   0     0   10   57 55                       112.0 88 2 12 0   0     0   10   57 55                 112
2040129 2040129 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_1 121 13 8 0   50     0   19   92 119                       211.0 121 13 8 0   50     0   19   92 119                 211
2040147 2040147 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2019   grade_1 144 0 12 0   3     0   6   79 86                       165.0 144 0 12 0   3     0   6   79 86                 165
2040159 2040159 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_1 67 2 6 0   2     2   2   39 42                       81.0 67 2 6 0   2     2   2   39 42                 81
2040163 2040163 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_1 71 1 4 0   1     2   3   46 36                       82.0 71 1 4 0   1     2   3   46 36                 82
2040181 2040181 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2019   grade_1 59 3 4 0   15     0   7   48 40                       88.0 59 3 4 0   15     0   7   48 40                 88
2040186 2040186 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2019   grade_1 52 5 4 0   19     0   8   50 38                       88.0 52 5 4 0   19     0   8   50 38                 88
2040191 2040191 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2019   grade_1 32 0 3 0   20     0   11   36 30                       66.0 32 0 3 0   20     0   11   36 30                 66
2040197 2040197 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   grade_1 76 4 4 0   18     0   9   61 50                       111.0 76 4 4 0   18     0   9   61 50                 111
2040211 2040211 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_1 73 1 1 0   0     0   3   39 39                       78.0 73 1 1 0   0     0   3   39 39                 78
2040221 2040221 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_1 27 0 1 0   0     0   1   12 17                       29.0 27 0 1 0   0     0   1   12 17                 29
2040228 2040228 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2019   grade_1 40 3 7 0   1     0   4   24 31                       55.0 40 3 7 0   1     0   4   24 31                 55
2040233 2040233 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2019   grade_1 63 2 15 0   1     0   5   49 37                       86.0 63 2 15 0   1     0   5   49 37                 86
2040238 2040238 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2019   grade_1 54 1 10 0   3     0   1   46 23                       69.0 54 1 10 0   3     0   1   46 23                 69
2040243 2040243 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 04 2019   grade_1 49 2 6 0   2     0   2   32 29                       61.0 49 2 6 0   2     0   2   32 29                 61
2040248 2040248 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2019   grade_1 69 2 5 0   6     0   3   39 46                       85.0 69 2 5 0   6     0   3   39 46                 85
2040262 2040262 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 05 2019   grade_1 58 2 2 0   7     0   4   39 34                       73.0 58 2 2 0   7     0   4   39 34                 73
2040268 2040268 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Frederick J Dutile   Regular School No Elementary KG 05 2019   grade_1 37 4 2 0   4     0   1   24 24                       48.0 37 4 2 0   4     0   1   24 24                 48
2040274 2040274 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2019   grade_1 42 1 4 0   3     0   3   20 33                       53.0 42 1 4 0   3     0   3   20 33                 53
2040280 2040280 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2019   grade_1 56 6 9 0   13     0   3   41 46                       87.0 56 6 9 0   13     0   3   41 46                 87
2040286 2040286 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No Elementary KG 05 2019   grade_1 52 3 6 0   6     0   4   33 38                       71.0 52 3 6 0   6     0   4   33 38                 71
2040292 2040292 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2019   grade_1 30 0 4 0   2     0   3   26 13                       39.0 30 0 4 0   2     0   3   26 13                 39
2040311 2040311 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2019   grade_1 2 16 12 0   3     0   1   15 19                       34.0 2 16 12 0   3     0   1   15 19                 34
2040316 2040316 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   grade_1 5 4 14 0   9     0   3   24 11                       35.0 5 4 14 0   9     0   3   24 11                 35
2040318 2040318 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_1 4 3 3 0   1     0   1   8 4                       12.0 4 3 3 0   1     0   1   8 4                 12
2040328 2040328 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   grade_1 4 11 16 0   1     0   0   20 12                       32.0 4 11 16 0   1     0   0   20 12                 32
2040331 2040331 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_1 1 21 12 1   1     0   0   19 17                       36.0 1 21 12 1   1     0   0   19 17                 36
2040336 2040336 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2019   grade_1 11 7 31 0   0     0   0   21 28                       49.0 11 7 31 0   0     0   0   21 28                 49
2040339 2040339 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2019   grade_1 1 39 28 0   1     0   1   38 32                       70.0 1 39 28 0   1     0   1   38 32                 70
2040342 2040342 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_1 14 3 5 0   0     0   0   13 9                       22.0 14 3 5 0   0     0   0   13 9                 22
2040352 2040352 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_1 6 24 21 1   5     0   0   30 27                       57.0 6 24 21 1   5     0   0   30 27                 57
2040362 2040362 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   grade_1 0 26 16 0   1     0   0   18 25                       43.0 0 26 16 0   1     0   0   18 25                 43
2040367 2040367 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   grade_1 1 17 26 0   0     0   2   24 22                       46.0 1 17 26 0   0     0   2   24 22                 46
2040371 2040371 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   grade_1 5 69 25 0   0     0   3   62 40                       102.0 5 69 25 0   0     0   3   62 40                 102
2040375 2040375 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_1 34 15 32 0   2     0   11   57 37                       94.0 34 15 32 0   2     0   11   57 37                 94
2040385 2040385 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2019   grade_1 28 27 28 0   1     0   3   35 52                       87.0 28 27 28 0   1     0   3   35 52                 87
2040395 2040395 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2019   grade_1 16 13 47 0   1     0   4   43 38                       81.0 16 13 47 0   1     0   4   43 38                 81
2040402 2040402 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_1 1 55 18 0   2     0   1   36 41                       77.0 1 55 18 0   2     0   1   36 41                 77
2040409 2040409 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2019   grade_1 7 1 27 0   1     0   0   18 18                       36.0 7 1 27 0   1     0   0   18 18                 36
2040416 2040416 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_1 1 1 11 0   0     0   1   6 8                       14.0 1 1 11 0   0     0   1   6 8                 14
2040423 2040423 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   grade_1 2 26 38 1   1     0   2   35 35                       70.0 2 26 38 1   1     0   2   35 35                 70
2040437 2040437 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_1 15 7 18 0   0     0   1   22 19                       41.0 15 7 18 0   0     0   1   22 19                 41
2040447 2040447 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_1 2 1 54 0   1     0   1   33 26                       59.0 2 1 54 0   1     0   1   33 26                 59
2040457 2040457 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2019   grade_1 1 20 8 0   6     0   2   21 16                       37.0 1 20 8 0   6     0   2   21 16                 37
2040464 2040464 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_1 53 2 7 0   10     1   6   41 38                       79.0 53 2 7 0   10     1   6   41 38                 79
2040474 2040474 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2019   grade_1 13 16 10 0   1     0   2   21 21                       42.0 13 16 10 0   1     0   2   21 21                 42
2040481 2040481 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_1 8 14 20 0   0     0   2   27 17                       44.0 8 14 20 0   0     0   2   27 17                 44
2040491 2040491 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   grade_1 3 6 9 0   0     0   1   13 6                       19.0 3 6 9 0   0     0   1   13 6                 19
2040498 2040498 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2019   grade_1 2 18 14 0   0     0   3   17 20                       37.0 2 18 14 0   0     0   3   17 20                 37
2040505 2040505 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   grade_1 1 24 18 0   0     0   4   17 30                       47.0 1 24 18 0   0     0   4   17 30                 47
2040512 2040512 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2019   grade_1 4 2 38 0   0     0   1   24 21                       45.0 4 2 38 0   0     0   1   24 21                 45
2040519 2040519 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_1 11 30 24 0   7     0   5   43 34                       77.0 11 30 24 0   7     0   5   43 34                 77
2040528 2040528 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_1 5 12 21 0   3     0   0   19 22                       41.0 5 12 21 0   3     0   0   19 22                 41
2040538 2040538 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2019   grade_1 0 23 14 0   0     0   2   15 24                       39.0 0 23 14 0   0     0   2   15 24                 39
2040545 2040545 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2019   grade_1 11 4 42 0   1     0   1   26 33                       59.0 11 4 42 0   1     0   1   26 33                 59
2040552 2040552 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2019   grade_1 3 11 37 0   0     0   5   26 30                       56.0 3 11 37 0   0     0   5   26 30                 56
2040559 2040559 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2019   grade_1 0 57 43 1   3     0   6   59 51                       110.0 0 57 43 1   3     0   6   59 51                 110
2040566 2040566 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2019   grade_1 3 14 4 0   0     0   0   9 12                       21.0 3 14 4 0   0     0   0   9 12                 21
2040576 2040576 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   grade_1 2 29 14 0   0     0   0   29 16                       45.0 2 29 14 0   0     0   0   29 16                 45
2040583 2040583 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2019   grade_1 5 11 10 0   4     0   4   16 18                       34.0 5 11 10 0   4     0   4   16 18                 34
2040590 2040590 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_1 10 2 30 0   0     0   2   19 25                       44.0 10 2 30 0   0     0   2   19 25                 44
2040600 2040600 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_1 7 26 10 2   1     0   2   32 16                       48.0 7 26 10 2   1     0   2   32 16                 48
2040610 2040610 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2019   grade_1 12 4 4 0   0     0   3   12 11                       23.0 12 4 4 0   0     0   3   12 11                 23
2040617 2040617 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_1 35 5 8 0   9     0   2   35 24                       59.0 35 5 8 0   9     0   2   35 24                 59
2040627 2040627 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2019   grade_1 13 10 16 0   9     0   1   24 25                       49.0 13 10 16 0   9     0   1   24 25                 49

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