enrollments

Data source: Big Local News · About: Big Local

988 rows where grade = "grade_1", state = "MA" and year = 2016 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 988 ✖

grade ✖

  • grade_1 · 988 ✖
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
933927 933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
933981 933981 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_1 21 92 14 2   8     0   7   79 65                       144 21 92 14 2   8     0   7   79 65                 144
933208 933208 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2016   grade_1 4 9 13 0   1     0   1   14 14                       28 4 9 13 0   1     0   1   14 14                 28
933464 933464 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2016   grade_1 10 9 14 0   5     0   1   23 16                       39 10 9 14 0   5     0   1   23 16                 39
933526 933526 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_1 38 9 14 0   3     0   4   34 34                       68 38 9 14 0   3     0   4   34 34                 68
934164 934164 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2016   grade_1 34 9 7 0   5     0   5   34 26                       60 34 9 7 0   5     0   5   34 26                 60
934912 934912 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_1 28 9 19 0   6     0   7   34 35                       69 28 9 19 0   6     0   7   34 35                 69
935130 935130 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_1 44 9 23 0   2     0   6   34 50                       84 44 9 23 0   2     0   6   34 50                 84
936015 936015 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No 1 PK 03 2016   grade_1 38 9 7 0   1     0   6   34 27                       61 38 9 7 0   1     0   6   34 27                 61
936020 936020 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_1 44 9 7 1   1     0   7   33 36                       69 44 9 7 1   1     0   7   33 36                 69
936303 936303 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No 1 KG 05 2016   grade_1 14 9 55 0   5     0   3   49 37                       86 14 9 55 0   5     0   3   49 37                 86
936971 936971 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2016   grade_1 73 9 3 0   11     1   5   53 49                       102 73 9 3 0   11     1   5   53 49                 102
938577 938577 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_1 0 9 42 0   0     0   0   28 23                       51 0 9 42 0   0     0   0   28 23                 51
938872 938872 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No 1 KG 05 2016   grade_1 26 9 8 0   0     1   2   22 24                       46 26 9 8 0   0     1   2   22 24                 46
939024 939024 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No 1 KG 04 2016   grade_1 90 9 9 1   3     0   3   54 61                       115 90 9 9 1   3     0   3   54 61                 115
939222 939222 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Douglas MacArthur Elementary School   Regular School No 1 KG 05 2016   grade_1 40 9 15 0   4     0   0   34 34                       68 40 9 15 0   4     0   0   34 34                 68
940124 940124 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2016   grade_1 31 9 6 0   6     0   3   32 23                       55 31 9 6 0   6     0   3   32 23                 55
940622 940622 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_1 2 82 28 0   0     0   4   58 58                       116 2 82 28 0   0     0   4   58 58                 116
933499 933499 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_1 2 8 36 0   0     1   0   23 24                       47 2 8 36 0   0     1   0   23 24                 47
933624 933624 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_1 9 8 5 0   0     0   2   11 13                       24 9 8 5 0   0     0   2   11 13                 24
934095 934095 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_1 30 8 6 0   17     0   6   31 36                       67 30 8 6 0   17     0   6   31 36                 67
934216 934216 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2016   grade_1 16 8 6 0   7     0   4   21 20                       41 16 8 6 0   7     0   4   21 20                 41
934666 934666 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_1 52 8 3 0   3     0   1   35 32                       67 52 8 3 0   3     0   1   35 32                 67
934772 934772 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No 1 PK 02 2016   grade_1 62 8 5 0   2     0   1   35 43                       78 62 8 5 0   2     0   1   35 43                 78
934886 934886 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_1 71 8 23 0   3     0   14   67 52                       119 71 8 23 0   3     0   14   67 52                 119
935029 935029 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2016   grade_1 38 8 68 0   7     0   11   61 71                       132 38 8 68 0   7     0   11   61 71                 132
935920 935920 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2016   grade_1 68 8 59 0   4     0   7   76 70                       146 68 8 59 0   4     0   7   76 70                 146
935926 935926 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No 1 KG 05 2016   grade_1 32 8 31 0   3     0   6   45 35                       80 32 8 31 0   3     0   6   45 35                 80
935932 935932 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2016   grade_1 84 8 32 1   5     0   6   56 80                       136 84 8 32 1   5     0   6   56 80                 136
936265 936265 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_1 12 8 38 0   6     0   5   43 26                       69 12 8 38 0   6     0   5   43 26                 69
936457 936457 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2016   grade_1 195 8 3 1   12     0   11   119 111                       230 195 8 3 1   12     0   11   119 111                 230
937017 937017 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2016   grade_1 30 8 27 0   2     0   2   35 34                       69 30 8 27 0   2     0   2   35 34                 69
937035 937035 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2016   grade_1 11 8 29 0   0     0   3   24 27                       51 11 8 29 0   0     0   3   24 27                 51
937179 937179 MA Middlesex   school 2508610 207   Newton 250861001370 2070070 Lincoln-Eliot   Regular School No 1 KG 05 2016   grade_1 31 8 6 0   5     0   6   27 29                       56 31 8 6 0   5     0   6   27 29                 56
937746 937746 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2016   grade_1 39 8 12 0   1     0   7   35 32                       67 39 8 12 0   1     0   7   35 32                 67
938584 938584 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No 1 PK 05 2016   grade_1 2 8 35 0   0     0   1   24 22                       46 2 8 35 0   0     0   1   24 22                 46
938742 938742 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No 1 KG 05 2016   grade_1 2 8 41 0   5     0   1   23 34                       57 2 8 41 0   5     0   1   23 34                 57
939019 939019 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No 1 KG 04 2016   grade_1 79 8 7 1   2     0   3   48 52                       100 79 8 7 1   2     0   3   48 52                 100
939706 939706 MA Norfolk   school 2512840 336   Weymouth 251284002125 3360080 William Seach   Regular School No 1 KG 04 2016   grade_1 38 8 8 1   7     0   3   33 32                       65 38 8 8 1   7     0   3   33 32                 65
939849 939849 MA Middlesex   school 2513200 347   Woburn 251320002184 3470005 Goodyear Elementary School   Regular School No 1 KG 05 2016   grade_1 35 8 4 1   2     0   2   24 28                       52 35 8 4 1   2     0   2   24 28                 52
939868 939868 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No 1 PK 05 2016   grade_1 48 8 2 0   2     0   3   28 35                       63 48 8 2 0   2     0   3   28 35                 63
939926 939926 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_1 9 8 73 0   8     0   6   50 54                       104 9 8 73 0   8     0   6   50 54                 104
939980 939980 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   grade_1 22 8 33 0   9     0   2   35 39                       74 22 8 33 0   9     0   2   35 39                 74
940003 940003 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2016   grade_1 9 8 32 1   5     0   3   31 27                       58 9 8 32 1   5     0   3   31 27                 58
940026 940026 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2016   grade_1 25 8 7 0   8     0   2   22 28                       50 25 8 7 0   8     0   2   22 28                 50
940064 940064 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_1 16 8 10 0   3     0   1   20 18                       38 16 8 10 0   3     0   1   20 18                 38
933355 933355 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   grade_1 4 79 30 0   0     0   2   58 57                       115 4 79 30 0   0     0   2   58 57                 115
933958 933958 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_1 18 73 14 0   2     2   6   55 60                       115 18 73 14 0   2     2   6   55 60                 115
933121 933121 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2016   grade_1 0 72 14 0   1     0   5   41 51                       92 0 72 14 0   1     0   5   41 51                 92
932638 932638 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_1 74 7 5 1   4     0   6   47 50                       97 74 7 5 1   4     0   6   47 50                 97
933570 933570 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2016   grade_1 14 7 13 0   4     0   4   18 24                       42 14 7 13 0   4     0   4   18 24                 42
934500 934500 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   grade_1 53 7 5 0   3     0   7   36 39                       75 53 7 5 0   3     0   7   36 39                 75
934764 934764 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2016   grade_1 83 7 0 0   3     1   1   58 37                       95 83 7 0 0   3     1   1   58 37                 95
935019 935019 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2016   grade_1 48 7 52 0   5     0   12   60 64                       124 48 7 52 0   5     0   12   60 64                 124
935106 935106 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2016   grade_1 75 7 15 0   8     0   3   60 48                       108 75 7 15 0   8     0   3   60 48                 108
935210 935210 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   grade_1 137 7 26 1   0     0   26   106 91                       197 137 7 26 1   0     0   26   106 91                 197
936084 936084 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers Early Learning Center   Regular School No 1 PK 03 2016   grade_1 25 7 42 0   31     0   6   50 61                       111 25 7 42 0   31     0   6   50 61                 111
936095 936095 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No 1 PK 04 2016   grade_1 21 7 45 0   17     0   5   51 44                       95 21 7 45 0   17     0   5   51 44                 95
936129 936129 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No 1 PK 04 2016   grade_1 38 7 25 0   26     0   5   49 52                       101 38 7 25 0   26     0   5   49 52                 101
936285 936285 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2016   grade_1 6 7 74 0   17     0   3   56 51                       107 6 7 74 0   17     0   3   56 51                 107
936747 936747 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2016   grade_1 67 7 63 0   8     0   3   72 76                       148 67 7 63 0   8     0   3   72 76                 148
936850 936850 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2016   grade_1 73 7 0 0   6     0   6   45 47                       92 73 7 0 0   6     0   6   45 47                 92
937069 937069 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2016   grade_1 80 7 13 0   0     0   9   54 55                       109 80 7 13 0   0     0   9   54 55                 109
937888 937888 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2016   grade_1 35 7 12 1   39     0   3   57 40                       97 35 7 12 1   39     0   3   57 40                 97
938069 938069 MA Suffolk   school 2510050 248   Revere 251005001629 2480050 Paul Revere   Regular School No 1 KG 05 2016   grade_1 30 7 38 0   6     0   5   43 43                       86 30 7 38 0   6     0   5   43 43                 86
938558 938558 MA Hampden   school 2511130 281   Springfield 251113001833 2810015 Thomas M Balliet   Regular School No 1 PK 05 2016   grade_1 7 7 28 0   1     0   0   22 21                       43 7 7 28 0   1     0   0   22 21                 43
938722 938722 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2016   grade_1 10 7 19 0   5     0   2   25 18                       43 10 7 19 0   5     0   2   25 18                 43
939941 939941 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   grade_1 12 7 24 1   8     0   2   29 25                       54 12 7 24 1   8     0   2   29 25                 54
940019 940019 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_1 20 7 27 0   6     0   7   33 34                       67 20 7 27 0   6     0   7   33 34                 67
940101 940101 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2016   grade_1 25 7 21 0   4     0   5   33 29                       62 25 7 21 0   4     0   5   33 29                 62
941010 941010 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2016   grade_1 77 7 4 1   1     0   8   50 48                       98 77 7 4 1   1     0   8   50 48                 98
942004 942004 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes 1 KG 05 2016   grade_1 21 7 26 0   2     0   1   36 21                       57 21 7 26 0   2     0   1   36 21                 57
933996 933996 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_1 21 65 14 1   1     3   13   65 53                       118 21 65 14 1   1     3   13   65 53                 118
933933 933933 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2016   grade_1 38 63 17 1   1     0   6   69 57                       126 38 63 17 1   1     0   6   69 57                 126
933975 933975 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_1 10 63 13 0   0     0   7   54 39                       93 10 63 13 0   0     0   7   54 39                 93
940426 940426 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_1 27 61 17 0   3     0   8   62 54                       116 27 61 17 0   3     0   8   62 54                 116
932763 932763 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2016   grade_1 65 6 11 0   3     0   7   48 44                       92 65 6 11 0   3     0   7   48 44                 92
933054 933054 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2016   grade_1 3 6 22 0   3     0   1   12 23                       35 3 6 22 0   3     0   1   12 23                 35
933191 933191 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2016   grade_1 16 6 14 0   0     0   6   17 25                       42 16 6 14 0   0     0   6   17 25                 42
933409 933409 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_1 11 6 5 0   1     0   1   17 7                       24 11 6 5 0   1     0   1   17 7                 24
933813 933813 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_1 1 6 3 0   0     0   0   8 2                       10 1 6 3 0   0     0   0   8 2                 10
934048 934048 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_1 54 6 7 0   39     0   5   50 61                       111 54 6 7 0   39     0   5   50 61                 111
934352 934352 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_1 25 6 110 0   2     0   2   86 59                       145 25 6 110 0   2     0   2   86 59                 145
934393 934393 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2016   grade_1 49 6 39 0   0     0   0   52 42                       94 49 6 39 0   0     0   0   52 42                 94
934471 934471 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2016   grade_1 107 6 33 0   1     0   2   76 73                       149 107 6 33 0   1     0   2   76 73                 149
934489 934489 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2016   grade_1 110 6 1 0   3     0   4   62 62                       124 110 6 1 0   3     0   4   62 62                 124
934813 934813 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No 1 PK 04 2016   grade_1 25 6 30 0   3     0   1   37 28                       65 25 6 30 0   3     0   1   37 28                 65
934921 934921 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_1 28 6 11 0   2     0   9   27 29                       56 28 6 11 0   2     0   9   27 29                 56
934983 934983 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_1 41 6 2 1   1     0   1   21 31                       52 41 6 2 1   1     0   1   21 31                 52
935968 935968 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_1 48 6 3 1   39     0   0   52 45                       97 48 6 3 1   39     0   0   52 45                 97
936111 936111 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   grade_1 9 6 33 0   46     0   2   48 48                       96 9 6 33 0   46     0   2   48 48                 96
936248 936248 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No 1 KG 05 2016   grade_1 7 6 54 2   11     0   4   37 47                       84 7 6 54 2   11     0   4   37 47                 84
936297 936297 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2016   grade_1 9 6 71 0   8     0   2   52 44                       96 9 6 71 0   8     0   2   52 44                 96
936333 936333 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No 1 KG 05 2016   grade_1 15 6 26 0   1     0   1   28 21                       49 15 6 26 0   1     0   1   28 21                 49
936340 936340 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No 1 PK 05 2016   grade_1 29 6 13 0   2     0   5   30 25                       55 29 6 13 0   2     0   5   30 25                 55
936791 936791 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 06 2016   grade_1 112 6 40 2   1     0   8   91 78                       169 112 6 40 2   1     0   8   91 78                 169
936844 936844 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No 1 KG 05 2016   grade_1 69 6 3 0   7     0   0   45 40                       85 69 6 3 0   7     0   0   45 40                 85
937062 937062 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2016   grade_1 17 6 19 0   0     0   5   20 27                       47 17 6 19 0   0     0   5   20 27                 47
937076 937076 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No 1 PK 04 2016   grade_1 6 6 23 0   0     0   4   21 18                       39 6 6 23 0   0     0   4   21 18                 39
937099 937099 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No 1 KG 05 2016   grade_1 44 6 11 0   2     0   4   33 34                       67 44 6 11 0   2     0   4   33 34                 67

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