enrollments

Data source: Big Local News · About: Big Local

956 rows where grade = "grade_4", state = "MA" and year = 2016 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 956 ✖

grade ✖

  • grade_4 · 956 ✖
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
933930 933930 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_4 12 91 30 1   1     0   7   69 73                       142 12 91 30 1   1     0   7   69 73                 142
932627 932627 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_4 25 9 16 0   4     0   4   28 30                       58 25 9 16 0   4     0   4   28 30                 58
933283 933283 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2016   grade_4 1 9 13 0   0     0   0   7 16                       23 1 9 13 0   0     0   0   7 16                 23
934098 934098 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_4 29 9 12 1   13     0   3   32 35                       67 29 9 12 1   13     0   3   32 35                 67
934240 934240 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2016   grade_4 20 9 7 0   8     0   4   24 24                       48 20 9 7 0   8     0   4   24 24                 48
934355 934355 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_4 21 9 116 0   1     0   2   76 73                       149 21 9 116 0   1     0   2   76 73                 149
934806 934806 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_4 17 9 44 2   3     0   1   34 42                       76 17 9 44 2   3     0   1   34 42                 76
934915 934915 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_4 19 9 12 0   3     0   4   30 17                       47 19 9 12 0   3     0   4   30 17                 47
935097 935097 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_4 29 9 52 0   2     0   4   53 43                       96 29 9 52 0   2     0   4   53 43                 96
935139 935139 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_4 57 9 10 0   2     0   3   44 37                       81 57 9 10 0   2     0   3   44 37                 81
936288 936288 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2016   grade_4 6 9 87 0   6     0   3   55 56                       111 6 9 87 0   6     0   3   55 56                 111
936306 936306 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No 1 KG 05 2016   grade_4 18 9 52 0   7     0   2   43 45                       88 18 9 52 0   7     0   2   43 45                 88
936740 936740 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2016   grade_4 62 9 66 0   4     0   3   77 67                       144 62 9 66 0   4     0   3   77 67                 144
937728 937728 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2016   grade_4 75 9 4 0   3     0   3   48 46                       94 75 9 4 0   3     0   3   48 46                 94
938463 938463 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2016   grade_4 16 9 5 0   1     0   1   15 17                       32 16 9 5 0   1     0   1   15 17                 32
938580 938580 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_4 0 9 51 0   0     0   1   31 30                       61 0 9 51 0   0     0   1   31 30                 61
938646 938646 MA Hampden   school 2511130 281   Springfield 251113001808 2810085 Homer Street   Regular School No 1 KG 05 2016   grade_4 2 9 44 0   0     0   0   23 32                       55 2 9 44 0   0     0   0   23 32                 55
938745 938745 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No 1 KG 05 2016   grade_4 3 9 35 0   8     0   0   29 26                       55 3 9 35 0   8     0   0   29 26                 55
939022 939022 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No 1 KG 04 2016   grade_4 87 9 11 0   1     1   3   47 65                       112 87 9 11 0   1     1   3   47 65                 112
939333 939333 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No 1 KG 05 2016   grade_4 68 9 1 0   13     0   5   47 49                       96 68 9 1 0   13     0   5   47 49                 96
940141 940141 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_4 7 9 59 0   7     0   3   47 38                       85 7 9 59 0   7     0   3   47 38                 85
941329 941329 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2016   grade_4 87 9 7 1   1     1   5   55 56                       111 87 9 7 1   1     1   5   55 56                 111
941974 941974 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 05 2016   grade_4 17 9 25 0   10     0   4   39 26                       65 17 9 25 0   10     0   4   39 26                 65
933984 933984 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_4 60 85 25 2   12     0   12   103 93                       196 60 85 25 2   12     0   12   103 93                 196
933557 933557 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2016   grade_4 0 8 25 0   4     0   4   18 23                       41 0 8 25 0   4     0   4   18 23                 41
933627 933627 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_4 1 8 13 0   0     0   1   12 11                       23 1 8 13 0   0     0   1   12 11                 23
934191 934191 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2016   grade_4 13 8 1 0   4     0   4   12 18                       30 13 8 1 0   4     0   4   12 18                 30
934367 934367 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_4 14 8 149 0   2     0   0   93 80                       173 14 8 149 0   2     0   0   93 80                 173
934889 934889 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_4 74 8 19 0   7     0   12   62 58                       120 74 8 19 0   7     0   12   62 58                 120
934941 934941 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2016   grade_4 49 8 11 0   6     0   6   50 30                       80 49 8 11 0   6     0   6   50 30                 80
935076 935076 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2016   grade_4 76 8 4 0   2     0   1   53 38                       91 76 8 4 0   2     0   1   53 38                 91
936114 936114 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   grade_4 14 8 32 0   55     0   5   56 58                       114 14 8 32 0   55     0   5   56 58                 114
936853 936853 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2016   grade_4 82 8 9 0   6     0   3   65 43                       108 82 8 9 0   6     0   3   65 43                 108
937007 937007 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No 1 KG 05 2016   grade_4 29 8 21 0   2     0   3   18 45                       63 29 8 21 0   2     0   3   18 45                 63
937058 937058 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2016   grade_4 16 8 25 1   0     0   4   29 25                       54 16 8 25 1   0     0   4   29 25                 54
937065 937065 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2016   grade_4 15 8 9 0   0     0   2   20 14                       34 15 8 9 0   0     0   2   20 14                 34
937749 937749 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2016   grade_4 39 8 6 0   3     0   4   32 28                       60 39 8 6 0   3     0   4   32 28                 60
938567 938567 MA Hampden   school 2511130 281   Springfield 251113001826 2810020 Samuel Bowles   Regular School No 1 KG 05 2016   grade_4 9 8 22 0   0     1   1   21 20                       41 9 8 22 0   0     1   1   21 20                 41
938688 938688 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2016   grade_4 6 8 24 0   0     0   1   21 18                       39 6 8 24 0   0     0   1   21 18                 39
938706 938706 MA Hampden   school 2511130 281   Springfield 251113001829 2810155 Mary M Walsh   Regular School No 1 KG 05 2016   grade_4 6 8 36 0   1     0   1   32 20                       52 6 8 36 0   1     0   1   32 20                 52
938888 938888 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2016   grade_4 30 8 4 0   4     0   3   24 25                       49 30 8 4 0   4     0   3   24 25                 49
938901 938901 MA Norfolk   school 2511250 285   Stoughton 251125001861 2850025 Joseph H Gibbons   Regular School No 1 KG 05 2016   grade_4 49 8 3 0   6     0   4   42 28                       70 49 8 3 0   6     0   4   42 28                 70
939189 939189 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No 1 KG 05 2016   grade_4 68 8 5 1   5     0   0   47 40                       87 68 8 5 1   5     0   0   47 40                 87
939238 939238 MA Middlesex   school 2512000 308   Waltham 251200001978 3080050 Thomas R Plympton Elementary School   Regular School No 1 KG 05 2016   grade_4 32 8 30 0   2     0   1   40 33                       73 32 8 30 0   2     0   1   40 33                 73
939244 939244 MA Middlesex   school 2512000 308   Waltham 251200001970 3080060 James Fitzgerald Elementary School   Regular School No 1 KG 05 2016   grade_4 44 8 21 0   5     0   3   37 44                       81 44 8 21 0   5     0   3   37 44                 81
939929 939929 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_4 7 8 64 0   9     0   2   45 45                       90 7 8 64 0   9     0   2   45 45                 90
939967 939967 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_4 18 8 36 0   2     0   3   31 36                       67 18 8 36 0   2     0   3   31 36                 67
940044 940044 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   grade_4 20 8 10 0   5     0   3   20 26                       46 20 8 10 0   5     0   3   20 26                 46
940625 940625 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_4 3 79 38 0   0     0   3   56 67                       123 3 79 38 0   0     0   3   56 67                 123
933978 933978 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_4 7 74 15 0   0     0   2   55 43                       98 7 74 15 0   0     0   2   55 43                 98
933071 933071 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_4 10 7 14 1   1     0   0   8 25                       33 10 7 14 1   1     0   0   8 25                 33
933438 933438 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_4 24 7 26 0   0     0   2   30 29                       59 24 7 26 0   0     0   2   30 29                 59
934107 934107 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2016   grade_4 44 7 12 0   21     0   3   49 38                       87 44 7 12 0   21     0   3   49 38                 87
934184 934184 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2016   grade_4 17 7 7 0   2     0   2   17 18                       35 17 7 7 0   2     0   2   17 18                 35
934205 934205 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_4 23 7 6 0   0     0   7   23 20                       43 23 7 6 0   0     0   7   23 20                 43
934669 934669 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_4 59 7 4 1   6     0   0   33 44                       77 59 7 4 1   6     0   0   33 44                 77
934895 934895 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2016   grade_4 47 7 20 0   1     0   11   45 41                       86 47 7 20 0   1     0   11   45 41                 86
935032 935032 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2016   grade_4 38 7 59 0   12     0   10   65 61                       126 38 7 59 0   12     0   10   65 61                 126
935923 935923 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2016   grade_4 66 7 48 0   0     0   3   66 58                       124 66 7 48 0   0     0   3   66 58                 124
935983 935983 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2016   grade_4 32 7 4 0   23     0   8   39 35                       74 32 7 4 0   23     0   8   39 35                 74
935995 935995 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2016   grade_4 24 7 5 0   33     0   6   34 41                       75 24 7 5 0   33     0   6   34 41                 75
936143 936143 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No 1 PK 04 2016   grade_4 30 7 32 0   21     0   5   40 55                       95 30 7 32 0   21     0   5   40 55                 95
936155 936155 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No 1 PK 04 2016   grade_4 34 7 41 0   7     0   5   46 48                       94 34 7 41 0   7     0   5   46 48                 94
936268 936268 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_4 9 7 29 0   4     0   9   35 23                       58 9 7 29 0   4     0   9   35 23                 58
936354 936354 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_4 5 7 53 0   4     0   4   43 30                       73 5 7 53 0   4     0   4   43 30                 73
936700 936700 MA Middlesex   school 2507620 178   Melrose 250762001196 1780035 Roosevelt   Regular School No 1 KG 05 2016   grade_4 49 7 4 0   3     0   1   27 37                       64 49 7 4 0   3     0   1   27 37                 64
936750 936750 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2016   grade_4 73 7 62 0   4     0   4   78 72                       150 73 7 62 0   4     0   4   78 72                 150
937531 937531 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_4 31 7 9 0   2     0   0   21 28                       49 31 7 9 0   2     0   0   21 28                 49
937541 937541 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_4 31 7 4 0   5     0   0   28 19                       47 31 7 4 0   5     0   0   28 19                 47
937637 937637 MA Essex   school 2509360 229   Peabody 250936001493 2290015 Center   Regular School No 1 KG 05 2016   grade_4 49 7 2 0   1     0   3   40 22                       62 49 7 2 0   1     0   3   40 22                 62
937926 937926 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No 1 PK 05 2016   grade_4 20 7 4 0   17     0   2   30 20                       50 20 7 4 0   17     0   2   30 20                 50
938021 938021 MA Middlesex   school 2509990 246   Reading 250999001608 2460017 J Warren Killam   Regular School No 1 KG 05 2016   grade_4 62 7 0 0   5     1   0   36 39                       75 62 7 0 0   5     1   0   36 39                 75
938173 938173 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No 1 KG 08 2016   grade_4 17 7 38 0   1     0   2   30 35                       65 17 7 38 0   1     0   2   30 35                 65
938182 938182 MA Essex   school 2510380 258   Salem 251038001658 2580030 Horace Mann Laboratory   Regular School No 1 KG 05 2016   grade_4 13 7 8 0   0     0   1   15 14                       29 13 7 8 0   0     0   1   15 14                 29
938599 938599 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No 1 KG 05 2016   grade_4 2 7 43 1   0     0   0   26 27                       53 2 7 43 1   0     0   0   26 27                 53
938732 938732 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No 1 PK 05 2016   grade_4 6 7 32 0   0     0   0   26 19                       45 6 7 32 0   0     0   0   26 19                 45
939225 939225 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Douglas MacArthur Elementary School   Regular School No 1 KG 05 2016   grade_4 27 7 14 0   4     0   1   33 20                       53 27 7 14 0   4     0   1   33 20                 53
939339 939339 MA Middlesex   school 2512210 315   Wayland 251221002008 3150015 Happy Hollow School   Regular School No 1 KG 05 2016   grade_4 42 7 3 0   13     0   6   36 35                       71 42 7 3 0   13     0   6   36 35                 71
939694 939694 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Frederick C Murphy   Regular School No 1 KG 04 2016   grade_4 38 7 4 0   3     0   4   27 29                       56 38 7 4 0   3     0   4   27 29                 56
939719 939719 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Thomas W. Hamilton Primary School   Regular School No 1 KG 04 2016   grade_4 84 7 11 0   1     0   3   59 47                       106 84 7 11 0   1     0   3   59 47                 106
939871 939871 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No 1 PK 05 2016   grade_4 56 7 5 0   8     0   2   39 39                       78 56 7 5 0   8     0   2   39 39                 78
939936 939936 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_4 9 7 17 0   1     0   1   20 15                       35 9 7 17 0   1     0   1   20 15                 35
940052 940052 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   grade_4 2 7 24 0   0     0   1   19 15                       34 2 7 24 0   0     0   1   19 15                 34
940081 940081 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_4 49 7 11 0   5     0   3   35 40                       75 49 7 11 0   5     0   3   35 40                 75
940120 940120 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_4 27 7 9 0   1     0   2   23 23                       46 27 7 9 0   1     0   2   23 23                 46
933124 933124 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2016   grade_4 1 64 18 0   1     0   3   41 46                       87 1 64 18 0   1     0   3   41 46                 87
933961 933961 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_4 22 64 19 0   1     1   7   58 56                       114 22 64 19 0   1     1   7   58 56                 114
933942 933942 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2016   grade_4 23 63 62 0   0     0   5   75 78                       153 23 63 62 0   0     0   5   75 78                 153
940429 940429 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_4 31 60 22 0   5     1   3   59 63                       122 31 60 22 0   5     1   3   59 63                 122
932634 932634 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_4 30 6 15 0   7     0   5   31 32                       63 30 6 15 0   7     0   5   31 32                 63
933388 933388 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_4 3 6 10 0   3     0   2   10 14                       24 3 6 10 0   3     0   2   10 14                 24
933412 933412 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_4 15 6 4 0   1     0   0   16 10                       26 15 6 4 0   1     0   0   16 10                 26
934151 934151 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No 1 KG 05 2016   grade_4 62 6 5 0   13     0   1   41 46                       87 62 6 5 0   13     0   1   41 46                 87
934212 934212 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No 1 PK 05 2016   grade_4 9 6 4 0   2     0   1   12 10                       22 9 6 4 0   2     0   1   12 10                 22
934503 934503 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   grade_4 47 6 8 1   4     0   7   30 43                       73 47 6 8 1   4     0   7   30 43                 73
934908 934908 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_4 31 6 31 0   4     0   2   45 29                       74 31 6 31 0   4     0   2   45 29                 74
934997 934997 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_4 65 6 6 0   3     0   6   44 42                       86 65 6 6 0   3     0   6   44 42                 86
935429 935429 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2016   grade_4 59 6 50 1   3     0   1   62 58                       120 59 6 50 1   3     0   1   62 58                 120
935890 935890 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No 1 03 05 2016   grade_4 110 6 8 1   5     0   1   71 60                       131 110 6 8 1   5     0   1   71 60                 131
936098 936098 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No 1 PK 04 2016   grade_4 28 6 33 0   20     0   3   45 45                       90 28 6 33 0   20     0   3   45 45                 90

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