enrollments

Data source: Big Local News · About: Big Local

950 rows where grade = "grade_4", state = "MA" and year = 2020 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 950 ✖

grade ✖

  • grade_4 · 950 ✖
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
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
1364804 1364804 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_4 99 0 4 0   1     0   7   56 55 *                     111.0 99 0 4 0   1     0   7   56 55                 111
1364814 1364814 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_4 35 1 11 0   0     0   2   24 25 *                     49.0 35 1 11 0   0     0   2   24 25                 49
1364819 1364819 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_4 57 0 1 0   2     0   0   34 26 *                     60.0 57 0 1 0   2     0   0   34 26                 60
1364824 1364824 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_4 69 1 6 0   3     0   1   39 41 *                     80.0 69 1 6 0   3     0   1   39 41                 80
1364829 1364829 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_4 55 1 6 0   1     0   3   33 33 *                     66.0 55 1 6 0   1     0   3   33 33                 66
1364843 1364843 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_4 59 1 2 1   0     0   3   29 37 *                     66.0 59 1 2 1   0     0   3   29 37                 66
1364849 1364849 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_4 78 2 12 0   2     0   3   57 40 *                     97.0 78 2 12 0   2     0   3   57 40                 97
1364998 1364998 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_4 57 5 12 1   4     1   8   53 35 *                     88.0 57 5 12 1   4     1   8   53 35                 88
1365004 1365004 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_4 63 8 15 0   2     0   6   51 43 *                     94.0 63 8 15 0   2     0   6   51 43                 94
1365009 1365009 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_4 66 4 18 0   6     0   6   54 46 *                     100.0 66 4 18 0   6     0   6   54 46                 100
1365014 1365014 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_4 68 6 10 0   7     0   8   55 44 *                     99.0 68 6 10 0   7     0   8   55 44                 99
1365019 1365019 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_4 41 9 11 0   8     0   14   40 43 *                     83.0 41 9 11 0   8     0   14   40 43                 83
1365158 1365158 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2020   grade_4 55 3 4 0   24     0   9   48 47 *                     95.0 55 3 4 0   24     0   9   48 47                 95
1365163 1365163 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2020   grade_4 42 9 4 0   20     0   12   43 44 *                     87.0 42 9 4 0   20     0   12   43 44                 87
1365168 1365168 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2020   grade_4 33 3 4 2   24     0   6   34 38 *                     72.0 33 3 4 2   24     0   6   34 38                 72
1365174 1365174 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_4 84 1 3 0   12     0   13   61 52 *                     113.0 84 1 3 0   12     0   13   61 52                 113
1365188 1365188 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_4 90 0 3 0   0     0   5   38 60 *                     98.0 90 0 3 0   0     0   5   38 60                 98
1365198 1365198 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2020   grade_4 48 0 14 0   0     0   3   31 34 *                     65.0 48 0 14 0   0     0   3   31 34                 65
1365203 1365203 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2020   grade_4 61 2 10 0   1     0   5   38 41 *                     79.0 61 2 10 0   1     0   5   38 41                 79
1365208 1365208 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2020   grade_4 42 3 7 0   1     0   3   31 25 *                     56.0 42 3 7 0   1     0   3   31 25                 56
1365213 1365213 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 04 2020   grade_4 41 3 14 0   1     0   3   27 35 *                     62.0 41 3 14 0   1     0   3   27 35                 62
1365218 1365218 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2020   grade_4 70 4 12 0   2     0   3   51 40 *                     91.0 70 4 12 0   2     0   3   51 40                 91
1365232 1365232 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 04 2020   grade_4 80 11 9 0   12     0   3   59 56 *                     115.0 80 11 9 0   12     0   3   59 56                 115
1365237 1365237 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Frederick J Dutile   Regular School No Elementary KG 04 2020   grade_4 36 3 6 0   2     0   1   24 24 *                     48.0 36 3 6 0   2     0   1   24 24                 48
1365242 1365242 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 04 2020   grade_4 69 2 7 0   2     0   1   37 44 *                     81.0 69 2 7 0   2     0   1   37 44                 81
1365247 1365247 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 04 2020   grade_4 64 5 9 1   14     0   6   54 45 *                     99.0 64 5 9 1   14     0   6   54 45                 99
1365252 1365252 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No Elementary KG 04 2020   grade_4 50 5 8 1   10     0   1   34 41 *                     75.0 50 5 8 1   10     0   1   34 41                 75
1366541 1366541 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2020   grade_4 58 4 5 0   18     0   4   47 42 *                     89.0 58 4 5 0   18     0   4   47 42                 89
1366546 1366546 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2020   grade_4 63 2 10 0   11     0   2   43 45 *                     88.0 63 2 10 0   11     0   2   43 45                 88
1366551 1366551 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_4 56 4 13 0   13     0   5   50 41 *                     91.0 56 4 13 0   13     0   5   50 41                 91
1366556 1366556 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_4 75 0 12 0   6     0   6   55 44 *                     99.0 75 0 12 0   6     0   6   55 44                 99
1366575 1366575 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_4 8 4 101 0   0     0   3   60 56 *                     116.0 8 4 101 0   0     0   3   60 56                 116
1366579 1366579 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_4 13 4 115 0   0     0   5   78 59 *                     137.0 13 4 115 0   0     0   5   78 59                 137
1366589 1366589 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_4 12 4 124 0   0     0   2   73 69 *                     142.0 12 4 124 0   0     0   2   73 69                 142
1366696 1366696 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2020   grade_4 107 5 31 0   3     0   2   69 79 *                     148.0 107 5 31 0   3     0   2   69 79                 148
1366948 1366948 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2020   grade_4 33 0 6 0   2     0   2   27 16 *                     43.0 33 0 6 0   2     0   2   27 16                 43
1366954 1366954 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2020   grade_4 31 0 7 0   2     0   2   23 19 *                     42.0 31 0 7 0   2     0   2   23 19                 42
1366959 1366959 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2020   grade_4 31 1 9 1   0     0   3   28 17 *                     45.0 31 1 9 1   0     0   3   28 17                 45
1367218 1367218 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_4 32 2 4 0   1     0   6   21 24 *                     45.0 32 2 4 0   1     0   6   21 24                 45
1367224 1367224 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_4 44 4 3 0   0     0   2   23 30 *                     53.0 44 4 3 0   0     0   2   23 30                 53
1367229 1367229 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_4 75 2 8 0   3     0   6   54 40 *                     94.0 75 2 8 0   3     0   6   54 40                 94
1367234 1367234 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_4 58 2 4 0   0     0   4   26 42 *                     68.0 58 2 4 0   0     0   4   26 42                 68
1367249 1367249 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   grade_4 29 8 66 1   4     0   7   60 55 *                     115.0 29 8 66 1   4     0   7   60 55                 115
1367255 1367255 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2020   grade_4 36 6 63 0   4     0   7   62 54 *                     116.0 36 6 63 0   4     0   7   62 54                 116
1367265 1367265 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_4 32 8 64 0   3     0   8   55 60 *                     115.0 32 8 64 0   3     0   8   55 60                 115
1367304 1367304 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2020   grade_4 31 2 6 1   2     0   1   24 19 *                     43.0 31 2 6 1   2     0   1   24 19                 43
1367309 1367309 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2020   grade_4 58 4 4 0   3     0   2   27 44 *                     71.0 58 4 4 0   3     0   2   27 44                 71
1367314 1367314 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2020   grade_4 38 2 0 2   3     0   1   29 17 *                     46.0 38 2 0 2   3     0   1   29 17                 46
1367445 1367445 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_4 107 8 53 0   7     0   14   88 101 *                     189.0 107 8 53 0   7     0   14   88 101                 189
1367555 1367555 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2020   grade_4 26 1 13 0   0     0   5   20 25 *                     45.0 26 1 13 0   0     0   5   20 25                 45
1367560 1367560 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2020   grade_4 45 0 5 0   1     0   0   29 22 *                     51.0 45 0 5 0   1     0   0   29 22                 51
1367565 1367565 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2020   grade_4 23 2 13 0   1     0   4   21 22 *                     43.0 23 2 13 0   1     0   4   21 22                 43
1367607 1367607 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary 02 04 2020   grade_4 183 2 3 0   6     0   1   91 104 *                     195.0 183 2 3 0   6     0   1   91 104                 195
1367648 1367648 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2020   grade_4 44 1 26 0   1     0   3   41 34 *                     75.0 44 1 26 0   1     0   3   41 34                 75
1367653 1367653 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2020   grade_4 61 1 50 0   0     0   2   50 64 *                     114.0 61 1 50 0   0     0   2   50 64                 114
1367675 1367675 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2020   grade_4 79 2 45 1   0     0   2   62 67 *                     129.0 79 2 45 1   0     0   2   62 67                 129
1367811 1367811 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2020   grade_4 0 3 49 0   1     0   0   32 21 *                     53.0 0 3 49 0   1     0   0   32 21                 53
1367899 1367899 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2020   grade_4 42 1 3 0   2     0   3   27 24 *                     51.0 42 1 3 0   2     0   3   27 24                 51
1367904 1367904 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No Elementary KG 04 2020   grade_4 61 0 6 0   0     0   5   38 34 *                     72.0 61 0 6 0   0     0   5   38 34                 72
1367910 1367910 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2020   grade_4 59 1 19 0   4     0   2   38 47 *                     85.0 59 1 19 0   4     0   2   38 47                 85
1367974 1367974 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_4 4 2 117 0   0     0   0   72 50 1                     123.0 4 2 117 0   0     0   0   72 50 1               123
1367991 1367991 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   grade_4 11 5 116 0   1     0   1   67 67 *                     134.0 11 5 116 0   1     0   1   67 67                 134
1367999 1367999 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_4 3 4 115 0   2     0   1   68 57 *                     125.0 3 4 115 0   2     0   1   68 57                 125
1368025 1368025 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2020   grade_4 5 0 137 0   2     0   1   74 71 *                     145.0 5 0 137 0   2     0   1   74 71                 145
1368089 1368089 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Elementary   Regular School No Elementary KG 04 2020   grade_4 70 6 8 0   5     0   3   60 32 *                     92.0 70 6 8 0   5     0   3   60 32                 92
1368281 1368281 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2020   grade_4 26 7 20 0   32     0   4   54 35 *                     89.0 26 7 20 0   32     0   4   54 35                 89
1368296 1368296 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No Elementary PK 04 2020   grade_4 17 8 46 0   16     0   1   42 46 *                     88.0 17 8 46 0   16     0   1   42 46                 88
1368302 1368302 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No Elementary PK 04 2020   grade_4 25 9 42 0   9     0   3   42 46 *                     88.0 25 9 42 0   9     0   3   42 46                 88
1368318 1368318 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_4 16 6 31 0   29     0   3   47 38 *                     85.0 16 6 31 0   29     0   3   47 38                 85
1368323 1368323 MA Middlesex   school 2507020 160   Lowell 250702000068 1600027 Moody Elementary   Regular School No Elementary KG 04 2020   grade_4 18 2 18 0   6     0   1   19 26 *                     45.0 18 2 18 0   6     0   1   19 26                 45
1368329 1368329 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2020   grade_4 11 5 10 0   59     0   2   44 43 *                     87.0 11 5 10 0   59     0   2   44 43                 87
1368335 1368335 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2020   grade_4 35 11 26 0   16     0   4   51 41 *                     92.0 35 11 26 0   16     0   4   51 41                 92
1368341 1368341 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary PK 04 2020   grade_4 43 1 33 0   8     0   5   44 46 *                     90.0 43 1 33 0   8     0   5   44 46                 90
1368347 1368347 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No Elementary PK 04 2020   grade_4 24 4 34 0   31     0   1   49 45 *                     94.0 24 4 34 0   31     0   1   49 45                 94
1368353 1368353 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No Elementary PK 04 2020   grade_4 8 4 12 0   16     0   1   16 25 *                     41.0 8 4 12 0   16     0   1   16 25                 41
1368359 1368359 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2020   grade_4 29 6 54 0   8     0   1   49 49 *                     98.0 29 6 54 0   8     0   1   49 49                 98
1368365 1368365 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2020   grade_4 8 6 29 0   36     0   2   48 33 *                     81.0 8 6 29 0   36     0   2   48 33                 81
1368621 1368621 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2020   grade_4 82 2 8 0   8     0   5   46 59 *                     105.0 82 2 8 0   8     0   5   46 59                 105
1368626 1368626 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Summer Street   Regular School No Elementary KG 04 2020   grade_4 81 1 5 0   1     0   2   50 40 *                     90.0 81 1 5 0   1     0   2   50 40                 90
1368732 1368732 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2020   grade_4 53 3 53 0   3     0   1   66 47 *                     113.0 53 3 53 0   3     0   1   66 47                 113
1368737 1368737 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No Elementary KG 04 2020   grade_4 43 5 88 0   3     0   6   78 67 *                     145.0 43 5 88 0   3     0   6   78 67                 145
1368742 1368742 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2020   grade_4 72 5 75 1   9     0   5   86 81 *                     167.0 72 5 75 1   9     0   5   86 81                 167
1368889 1368889 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2020   grade_4 156 5 3 0   2     1   5   91 81 *                     172.0 156 5 3 0   2     1   5   91 81                 172
1369133 1369133 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2020   grade_4 85 3 5 0   8     0   17   52 66 *                     118.0 85 3 5 0   8     0   17   52 66                 118
1369138 1369138 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2020   grade_4 54 1 10 0   33     0   3   51 50 *                     101.0 54 1 10 0   33     0   3   51 50                 101
1369143 1369143 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No Elementary KG 04 2020   grade_4 36 0 4 0   2     0   3   25 20 *                     45.0 36 0 4 0   2     0   3   25 20                 45
1369148 1369148 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No Elementary KG 04 2020   grade_4 69 2 11 0   4     0   4   41 49 *                     90.0 69 2 11 0   4     0   4   41 49                 90
1369153 1369153 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2020   grade_4 56 2 2 0   8     0   7   46 29 *                     75.0 56 2 2 0   8     0   7   46 29                 75
1369656 1369656 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2020   grade_4 123 0 14 0   1     0   9   57 90 *                     147.0 123 0 14 0   1     0   9   57 90                 147
1369811 1369811 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2020   grade_4 102 3 19 0   0     0   9   72 61 *                     133.0 102 3 19 0   0     0   9   72 61                 133
1370117 1370117 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   grade_4 39 14 8 0   25     0   5   50 41 *                     91.0 39 14 8 0   25     0   5   50 41                 91
1370128 1370128 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2020   grade_4 36 11 11 0   30     0   2   49 41 *                     90.0 36 11 11 0   30     0   2   49 41                 90
1370346 1370346 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No Elementary KG 04 2020   grade_4 40 2 13 0   0     0   2   24 33 *                     57.0 40 2 13 0   0     0   2   24 33                 57
1370351 1370351 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary KG 04 2020   grade_4 51 11 12 0   1     0   3   48 30 *                     78.0 51 11 12 0   1     0   3   48 30                 78
1370356 1370356 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Jefferson Elementary School   Regular School No Elementary KG 04 2020   grade_4 41 3 7 0   2     0   2   27 28 *                     55.0 41 3 7 0   2     0   2   27 28                 55
1370585 1370585 MA Worcester   school 2510770 271   Shrewsbury 251077001713 2710015 Calvin Coolidge   Regular School No Elementary KG 04 2020   grade_4 30 1 12 1   27     0   4   35 40 *                     75.0 30 1 12 1   27     0   4   35 40                 75
1370589 1370589 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_4 76 9 16 0   111     0   6   112 106 *                     218.0 76 9 16 0   111     0   6   112 106                 218
1370594 1370594 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No Elementary KG 04 2020   grade_4 61 0 8 0   16     0   1   43 43 *                     86.0 61 0 8 0   16     0   1   43 43                 86
1370601 1370601 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Spring Street   Regular School No Elementary KG 04 2020   grade_4 42 3 1 0   28     0   6   42 38 *                     80.0 42 3 1 0   28     0   6   42 38                 80

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