enrollments

Data source: Big Local News · About: Big Local

972 rows where grade = "grade_2", state = "MA" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 972 ✖

grade ✖

  • grade_2 · 972 ✖
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
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1364802 1364802 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_2 96 4 5 0   1     0   3   56 53 *                     109.0 96 4 5 0   1     0   3   56 53                 109
1364812 1364812 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_2 28 1 6 0   3     0   0   20 18 *                     38.0 28 1 6 0   3     0   0   20 18                 38
1364817 1364817 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_2 56 0 6 0   2     0   5   39 30 *                     69.0 56 0 6 0   2     0   5   39 30                 69
1364822 1364822 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_2 53 3 8 0   3     0   1   33 35 *                     68.0 53 3 8 0   3     0   1   33 35                 68
1364827 1364827 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_2 47 2 6 0   2     0   2   28 31 *                     59.0 47 2 6 0   2     0   2   28 31                 59
1364841 1364841 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_2 58 0 9 0   0     0   4   42 29 *                     71.0 58 0 9 0   0     0   4   42 29                 71
1364847 1364847 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_2 61 2 10 0   1     0   2   41 35 *                     76.0 61 2 10 0   1     0   2   41 35                 76
1364866 1364866 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_2 20 3 9 2   4     0   6   24 19 *                     44.0 20 3 9 2   4     0   6   24 19                 44
1364873 1364873 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_2 13 2 8 0   5     0   3   14 17 *                     31.0 13 2 8 0   5     0   3   14 17                 31
1364880 1364880 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_2 30 9 11 0   11     0   3   30 34 *                     64.0 30 9 11 0   11     0   3   30 34                 64
1364887 1364887 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_2 84 2 2 0   7     0   2   51 46 *                     97.0 84 2 2 0   7     0   2   51 46                 97
1364893 1364893 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_2 40 4 7 0   30     0   3   57 27 *                     84.0 40 4 7 0   30     0   3   57 27                 84
1364900 1364900 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_2 36 2 4 0   11     0   1   23 31 *                     54.0 36 2 4 0   11     0   1   23 31                 54
1364906 1364906 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_2 55 1 2 0   17     0   3   40 38 *                     78.0 55 1 2 0   17     0   3   40 38                 78
1364912 1364912 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_2 61 2 5 0   18     0   0   44 42 *                     86.0 61 2 5 0   18     0   0   44 42                 86
1364932 1364932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_2 40 4 0 0   16     0   7   39 28 *                     67.0 40 4 0 0   16     0   7   39 28                 67
1364938 1364938 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_2 62 1 1 0   9     0   9   43 39 *                     82.0 62 1 1 0   9     0   9   43 39                 82
1364944 1364944 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_2 60 1 3 0   7     0   4   41 34 *                     75.0 60 1 3 0   7     0   4   41 34                 75
1364950 1364950 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_2 49 3 5 0   12     0   10   33 46 *                     79.0 49 3 5 0   12     0   10   33 46                 79
1364957 1364957 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_2 43 4 4 0   7     0   7   34 31 *                     65.0 43 4 4 0   7     0   7   34 31                 65
1364963 1364963 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_2 50 1 8 0   9     0   4   32 39 *                     72.0 50 1 8 0   9     0   4   32 39                 72
1364969 1364969 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_2 57 1 3 0   7     0   9   36 41 *                     77.0 57 1 3 0   7     0   9   36 41                 77
1364983 1364983 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_2 118 7 27 0   43     0   9   103 101 *                     204.0 118 7 27 0   43     0   9   103 101                 204
1364996 1364996 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 5 7 0   1     0   1   35 36 *                     71.0 57 5 7 0   1     0   1   35 36                 71
1365002 1365002 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_2 42 6 8 0   4     0   8   41 27 *                     68.0 42 6 8 0   4     0   8   41 27                 68
1365007 1365007 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 3 21 0   4     0   7   44 48 *                     92.0 57 3 21 0   4     0   7   44 48                 92
1365012 1365012 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 2 11 1   3     0   4   35 43 *                     78.0 57 2 11 1   3     0   4   35 43                 78
1365017 1365017 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 14 9 1   10     0   7   51 47 *                     98.0 57 14 9 1   10     0   7   51 47                 98
1365041 1365041 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_2 78 2 12 0   3     0   1   52 44 *                     96.0 78 2 12 0   3     0   1   52 44                 96
1365045 1365045 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_2 62 0 5 0   4     0   4   36 39 *                     75.0 62 0 5 0   4     0   4   36 39                 75
1365060 1365060 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_2 30 13 7 0   3     0   4   34 23 *                     57.0 30 13 7 0   3     0   4   34 23                 57
1365074 1365074 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_2 47 2 6 0   0     0   7   36 26 *                     62.0 47 2 6 0   0     0   7   36 26                 62
1365078 1365078 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_2 42 4 6 0   1     0   7   34 26 *                     60.0 42 4 6 0   1     0   7   34 26                 60
1365082 1365082 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_2 44 11 25 1   1     0   2   42 42 *                     84.0 44 11 25 1   1     0   2   42 42                 84
1365086 1365086 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_2 29 11 28 0   3     0   13   35 49 *                     84.0 29 11 28 0   3     0   13   35 49                 84
1365090 1365090 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_2 89 2 14 0   0     0   10   59 56 *                     115.0 89 2 14 0   0     0   10   59 56                 115
1365105 1365105 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_2 125 11 10 0   51     0   20   94 123 *                     217.0 125 11 10 0   51     0   20   94 123                 217
1365122 1365122 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_2 148 0 12 0   3     0   5   81 87 *                     168.0 148 0 12 0   3     0   5   81 87                 168
1365134 1365134 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2020   grade_2 62 2 13 0   3     2   2   43 41 *                     84.0 62 2 13 0   3     2   2   43 41                 84
1365138 1365138 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_2 58 1 3 0   1     2   4   38 31 *                     69.0 58 1 3 0   1     2   4   38 31                 69
1365156 1365156 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2020   grade_2 61 3 3 0   20     0   9   54 42 *                     96.0 61 3 3 0   20     0   9   54 42                 96
1365161 1365161 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2020   grade_2 45 5 4 0   24     0   10   47 41 *                     88.0 45 5 4 0   24     0   10   47 41                 88
1365166 1365166 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2020   grade_2 32 0 3 0   24     0   13   41 31 *                     72.0 32 0 3 0   24     0   13   41 31                 72
1365172 1365172 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_2 83 3 3 0   17     0   6   58 54 *                     112.0 83 3 3 0   17     0   6   58 54                 112
1365186 1365186 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_2 74 1 1 0   0     0   4   40 40 *                     80.0 74 1 1 0   0     0   4   40 40                 80
1365196 1365196 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2020   grade_2 39 4 9 0   1     0   3   24 32 *                     56.0 39 4 9 0   1     0   3   24 32                 56
1365201 1365201 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2020   grade_2 57 2 15 0   1     0   5   44 36 *                     80.0 57 2 15 0   1     0   5   44 36                 80
1365206 1365206 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2020   grade_2 52 1 11 0   3     0   1   46 22 *                     68.0 52 1 11 0   3     0   1   46 22                 68
1365211 1365211 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 04 2020   grade_2 53 2 10 0   2     0   2   38 31 *                     69.0 53 2 10 0   2     0   2   38 31                 69
1365216 1365216 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2020   grade_2 74 2 5 0   4     0   2   40 47 *                     87.0 74 2 5 0   4     0   2   40 47                 87
1365230 1365230 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 04 2020   grade_2 83 4 6 0   10     0   6   66 43 *                     109.0 83 4 6 0   10     0   6   66 43                 109
1365235 1365235 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Frederick J Dutile   Regular School No Elementary KG 04 2020   grade_2 36 2 3 0   4     0   2   22 25 *                     47.0 36 2 3 0   4     0   2   22 25                 47
1365240 1365240 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 04 2020   grade_2 49 0 6 0   3     0   4   28 34 *                     62.0 49 0 6 0   3     0   4   28 34                 62
1365245 1365245 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 04 2020   grade_2 61 5 5 0   10     0   3   36 48 *                     84.0 61 5 5 0   10     0   3   36 48                 84
1365250 1365250 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No Elementary KG 04 2020   grade_2 46 2 6 0   4     0   2   26 34 *                     60.0 46 2 6 0   4     0   2   26 34                 60
1365269 1365269 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2020   grade_2 2 14 18 0   1     0   1   19 17 *                     36.0 2 14 18 0   1     0   1   19 17                 36
1365276 1365276 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_2 5 5 3 0   1     0   1   11 4 *                     15.0 5 5 3 0   1     0   1   11 4                 15
1365289 1365289 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2020   grade_2 2 23 11 1   0     0   0   20 17 *                     37.0 2 23 11 1   0     0   0   20 17                 37
1365300 1365300 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_2 14 4 4 0   0     0   0   13 9 *                     22.0 14 4 4 0   0     0   0   13 9                 22
1365310 1365310 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_2 6 20 23 1   5     0   0   29 26 *                     55.0 6 20 23 1   5     0   0   29 26                 55
1365320 1365320 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2020   grade_2 1 20 12 0   0     0   0   13 20 *                     33.0 1 20 12 0   0     0   0   13 20                 33
1365325 1365325 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2020   grade_2 1 14 24 0   0     0   1   22 18 *                     40.0 1 14 24 0   0     0   1   22 18                 40
1365329 1365329 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 03 2020   grade_2 3 55 21 0   0     0   5   52 32 *                     84.0 3 55 21 0   0     0   5   52 32                 84
1365334 1365334 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_2 33 13 32 0   1     0   11   53 37 *                     90.0 33 13 32 0   1     0   11   53 37                 90
1365344 1365344 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2020   grade_2 28 33 26 0   2     0   3   43 49 *                     92.0 28 33 26 0   2     0   3   43 49                 92
1365353 1365353 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2020   grade_2 19 12 44 0   3     0   4   43 39 *                     82.0 19 12 44 0   3     0   4   43 39                 82
1365360 1365360 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2020   grade_2 1 42 16 0   1     0   1   33 28 *                     61.0 1 42 16 0   1     0   1   33 28                 61
1365367 1365367 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2020   grade_2 6 1 31 0   0     0   0   15 23 *                     38.0 6 1 31 0   0     0   0   15 23                 38
1365374 1365374 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2020   grade_2 1 1 10 0   1     0   1   6 8 *                     14.0 1 1 10 0   1     0   1   6 8                 14
1365381 1365381 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2020   grade_2 1 26 31 0   0     0   2   31 29 *                     60.0 1 26 31 0   0     0   2   31 29                 60
1365395 1365395 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_2 15 8 17 0   1     0   1   21 21 *                     42.0 15 8 17 0   1     0   1   21 21                 42
1365405 1365405 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_2 9 4 75 0   0     0   3   45 46 *                     91.0 9 4 75 0   0     0   3   45 46                 91
1365415 1365415 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2020   grade_2 1 19 13 0   5     0   2   20 20 *                     40.0 1 19 13 0   5     0   2   20 20                 40
1365422 1365422 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_2 56 3 7 0   8     1   6   43 38 *                     81.0 56 3 7 0   8     1   6   43 38                 81
1365432 1365432 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2020   grade_2 14 16 8 0   1     0   2   21 20 *                     41.0 14 16 8 0   1     0   2   21 20                 41
1365439 1365439 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_2 4 15 16 0   1     0   2   24 14 *                     38.0 4 15 16 0   1     0   2   24 14                 38
1365449 1365449 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2020   grade_2 4 7 11 0   0     0   1   15 8 *                     23.0 4 7 11 0   0     0   1   15 8                 23
1365456 1365456 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2020   grade_2 2 17 16 0   0     0   1   17 19 *                     36.0 2 17 16 0   0     0   1   17 19                 36
1365463 1365463 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2020   grade_2 1 22 14 0   0     0   2   19 20 *                     39.0 1 22 14 0   0     0   2   19 20                 39
1365470 1365470 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2020   grade_2 5 2 39 0   0     0   1   26 21 *                     47.0 5 2 39 0   0     0   1   26 21                 47
1365477 1365477 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_2 11 33 26 0   5     0   6   45 36 *                     81.0 11 33 26 0   5     0   6   45 36                 81
1365486 1365486 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_2 5 20 32 0   2     0   0   30 29 *                     59.0 5 20 32 0   2     0   0   30 29                 59
1365496 1365496 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2020   grade_2 0 24 13 0   0     0   1   11 27 *                     38.0 0 24 13 0   0     0   1   11 27                 38
1365503 1365503 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2020   grade_2 14 2 46 0   1     0   0   26 37 *                     63.0 14 2 46 0   1     0   0   26 37                 63
1365510 1365510 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2020   grade_2 4 11 43 0   0     0   3   31 30 *                     61.0 4 11 43 0   0     0   3   31 30                 61
1365517 1365517 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2020   grade_2 0 59 45 1   2     0   5   57 55 *                     112.0 0 59 45 1   2     0   5   57 55                 112
1365524 1365524 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2020   grade_2 2 11 7 0   0     0   0   12 8 *                     20.0 2 11 7 0   0     0   0   12 8                 20
1365534 1365534 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2020   grade_2 2 25 12 0   0     0   0   23 16 *                     39.0 2 25 12 0   0     0   0   23 16                 39
1365541 1365541 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2020   grade_2 0 10 8 0   2     0   4   6 18 *                     24.0 0 10 8 0   2     0   4   6 18                 24
1365548 1365548 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_2 10 1 36 0   0     0   2   21 28 *                     49.0 10 1 36 0   0     0   2   21 28                 49
1365558 1365558 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_2 5 30 12 2   1     0   2   33 19 *                     52.0 5 30 12 2   1     0   2   33 19                 52
1365568 1365568 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2020   grade_2 13 2 4 0   1     0   3   9 14 *                     23.0 13 2 4 0   1     0   3   9 14                 23
1365575 1365575 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_2 34 2 6 0   9     0   2   32 21 *                     53.0 34 2 6 0   9     0   2   32 21                 53
1365585 1365585 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2020   grade_2 11 10 16 0   8     0   1   23 23 *                     46.0 11 10 16 0   8     0   1   23 23                 46
1365592 1365592 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2020   grade_2 14 1 19 0   6     0   1   24 17 *                     41.0 14 1 19 0   6     0   1   24 17                 41
1365599 1365599 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2020   grade_2 2 29 16 0   25     0   8   37 43 *                     80.0 2 29 16 0   25     0   8   37 43                 80
1365606 1365606 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_2 4 13 30 0   2     0   0   18 31 *                     49.0 4 13 30 0   2     0   0   18 31                 49
1365616 1365616 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2020   grade_2 3 6 7 0   2     0   1   11 8 *                     19.0 3 6 7 0   2     0   1   11 8                 19
1365623 1365623 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2020   grade_2 8 4 9 2   1     0   1   18 7 *                     25.0 8 4 9 2   1     0   1   18 7                 25

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