enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2043539 2043539 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2019   sped_beyond_grade_12 7 0 0 0   0     0   1                             8.0 7 0 0 0   0     0   1                       8
2046156 2046156 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield Vocational Academy   Special Education School No Ungraded UG UG 2019   sped_beyond_grade_12 9 18 65 0   4     0   1                             97.0 9 18 65 0   4     0   1                       97
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041275 2041275 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_8 0 1 3 1   0     0   1   4 *                       6.0 0 1 3 1   0     0   1   4                   6
2041276 2041276 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_9 * * * *   *     *   *   4 *                       4.0                         4                   4
2041277 2041277 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_10 * * * *   *     *   *   3 *                       4.0                         3                   4
2041278 2041278 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_11 * * * *   *     *   *   2 *                       3.0                         2                   3
2046157 2046157 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield International Academy at Sci-Tech   Regular School No Secondary 09 10 2019   grade_9 1 0 16 0   2     0   0   18 1                       19.0 1 0 16 0   2     0   0   18 1                 19
2046158 2046158 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield International Academy at Sci-Tech   Regular School No Secondary 09 10 2019   grade_10 4 0 7 0   1     0   0   6 6                       12.0 4 0 7 0   1     0   0   6 6                 12
2039810 2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
2039835 2039835 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 12 0   13     0   3   79 83                       162.0 131 3 12 0   13     0   3   79 83                 162
2039924 2039924 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 36 1 3 0   23     0   3   48 18                       66.0 36 1 3 0   23     0   3   48 18                 66
2039981 2039981 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 52 5 8 0   23     0   8   65 31                       96.0 52 5 8 0   23     0   8   65 31                 96
2040007 2040007 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 74 9 0 1   30     0   2   68 48                       116.0 74 9 0 1   30     0   2   68 48                 116
2040026 2040026 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 133 9 19 0   7     0   11   107 72                       179.0 133 9 19 0   7     0   11   107 72                 179
2040101 2040101 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 78 15 30 1   1     0   21   88 58                       146.0 78 15 30 1   1     0   21   88 58                 146
2040157 2040157 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 88 2 3 0   3     0   2   54 44                       98.0 88 2 3 0   3     0   2   54 44                 98
2040226 2040226 MA Essex   school 2502640 30   Beverly 250264002854 300002 McKeown School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 96 9 10 1   5     0   2   78 45                       123.0 96 9 10 1   5     0   2   78 45                 123
2041228 2041228 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 57 107 33 0   1     1   8   109 98                       207.0 57 107 33 0   1     1   8   109 98                 207
2041333 2041333 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 27 0 5 0   16     0   9   28 29                       57.0 27 0 5 0   16     0   9   28 29                 57
2041334 2041334 MA Middlesex   school 2503150 46   Brookline 250315002793 460002 Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 23 3 6 1   12     0   3   29 19                       48.0 23 3 6 1   12     0   3   29 19                 48
2041411 2041411 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 The Lynch Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 21 6 6 0   13     0   9   24 31                       55.0 21 6 6 0   13     0   9   24 31                 55
2041554 2041554 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 54 10 9 0   11     0   3   59 28                       87.0 54 10 9 0   11     0   3   59 28                 87
2041606 2041606 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 93 2 9 1   39     0   7   92 59                       151.0 93 2 9 1   39     0   7   92 59                 151
2041680 2041680 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 137 10 66 0   2     0   14   147 82                       229.0 137 10 66 0   2     0   14   147 82                 229
2042100 2042100 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 44 36 97 0   13     0   4   114 80                       194.0 44 36 97 0   13     0   4   114 80                 194
2042396 2042396 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 145 17 69 0   32     1   12   159 117                       276.0 145 17 69 0   32     1   12   159 117                 276
2042463 2042463 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 83 1 4 1   2     11   5   61 46                       107.0 83 1 4 1   2     11   5   61 46                 107
2042533 2042533 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 81 0 1 0   2     0   5   48 41                       89.0 81 0 1 0   2     0   5   48 41                 89
2042559 2042559 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester PreSchool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 103 5 6 0   2     0   7   71 52                       123.0 103 5 6 0   2     0   7   71 52                 123
2042623 2042623 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 104 2 11 0   1     0   3   64 57                       121.0 104 2 11 0   1     0   3   64 57                 121
2042749 2042749 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 106 21 64 3   4     2   0   126 74                       200.0 106 21 64 3   4     2   0   126 74                 200
2042945 2042945 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Park Street School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 73 0 2 1   1     0   10   41 46                       87.0 73 0 2 1   1     0   10   41 46                 87
2042959 2042959 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton Pre-School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 49 0 2 0   15     0   3   48 21                       69.0 49 0 2 0   15     0   3   48 21                 69
2043196 2043196 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Bennett   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 11 30 0   3     0   6   63 38                       101.0 51 11 30 0   3     0   6   63 38                 101
2043197 2043197 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Lincoln School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 21 1 11 0   5     0   1   23 16                       39.0 21 1 11 0   5     0   1   23 16                 39
2043249 2043249 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington Children's Place   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 22 2 5 1   34     0   5   44 25                       69.0 22 2 5 1   34     0   5   44 25                 69
2043359 2043359 MA Middlesex   school 2507020 160   Lowell 250702002891 1600001 Cardinal O'Connell Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 20 7 47 0   26     0   4   70 34                       104.0 20 7 47 0   26     0   4   70 34                 104
2043682 2043682 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 34 1 1 0   1     0   5   24 18                       42.0 34 1 1 0   1     0   5   24 18                 42
2043737 2043737 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 112 50 25 0   115     0   17   194 125                       319.0 112 50 25 0   115     0   17   194 125                 319
2043752 2043752 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Roland Green School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 87 3 9 0   11     0   4   69 45                       114.0 87 3 9 0   11     0   4   69 45                 114
2043797 2043797 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 91 12 42 0   20     3   7   95 80                       175.0 91 12 42 0   20     3   7   95 80                 175
2044088 2044088 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 121 2 33 0   4     0   1   87 73                       161.0 121 2 33 0   4     0   1   87 73                 161
2044509 2044509 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 120 9 12 0   55     0   16   126 86                       212.0 120 9 12 0   55     0   16   126 86                 212
2044686 2044686 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 96 5 8 0   19     0   6   88 46                       134.0 96 5 8 0   19     0   6   88 46                 134
2045094 2045094 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 135 2 6 0   1     0   11   94 61                       155.0 135 2 6 0   1     0   11   94 61                 155
2045174 2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
2045299 2045299 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 RISE PreSchool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 98 2 3 1   9     0   2   71 44                       115.0 98 2 3 1   9     0   2   71 44                 115
2045462 2045462 MA Essex   school 2510380 258   Salem 251038000127 2580001 Salem Early Childhood   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 49 6 28 0   5     0   3   62 29                       91.0 49 6 28 0   5     0   3   62 29                 91
2045621 2045621 MA Norfolk   school 2510620 266   Sharon 251062002872 2660001 Sharon Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 23 3 6 0   12     0   5   34 15                       49.0 23 3 6 0   12     0   5   34 15                 49
2045677 2045677 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 9 11 1   106     0   6   126 116                       242.0 109 9 11 1   106     0   6   126 116                 242
2045848 2045848 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Early Childhood Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 15 26 103 2   4     0   5   105 50                       155.0 15 26 103 2   4     0   5   105 50                 155
2046190 2046190 MA Norfolk   school 2511250 285   Stoughton 251125001860 2850012 Edwin A Jones Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 47 21 13 0   4     1   5   43 48                       91.0 47 21 13 0   4     1   5   43 48                 91
2046328 2046328 MA Bristol   school 2511520 293   Taunton 251152000133 2930005 Edward F. Leddy Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 189 35 41 0   8     0   9   171 111                       282.0 189 35 41 0   8     0   9   171 111                 282
2046459 2046459 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 3 15 0   8     2   5   85 57                       142.0 109 3 15 0   8     2   5   85 57                 142
2046496 2046496 MA Norfolk   school 2511970 307   Walpole 251197002620 3070002 Daniel Feeney Preschool Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 2 2 0   5     0   4   33 31                       64.0 51 2 2 0   5     0   4   33 31                 64
2046686 2046686 MA Norfolk   school 2512270 317   Wellesley 251227002893 3170001 Preschool at Wellesley Schools   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 55 2 11 0   25     0   7   56 44                       100.0 55 2 11 0   25     0   7   56 44                 100
2046794 2046794 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 36 0   10     0   3   92 91                       183.0 131 3 36 0   10     0   3   92 91                 183
2046844 2046844 MA Middlesex   school 2512660 326   Westford 251266001572 3260013 Millennium Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 59 2 3 1   42     0   9   67 49                       116.0 59 2 3 1   42     0   9   67 49                 116
2046909 2046909 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 Cowing Early Childhood   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 58 9 28 0   18     0   3   74 42                       116.0 58 9 28 0   18     0   3   74 42                 116
2046976 2046976 MA Norfolk   school 2512810 335   Westwood 251281002115 3350050 Westwood Integrated Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 29 1 1 0   7     0   3   28 13                       41.0 29 1 1 0   7     0   3   28 13                 41
2046984 2046984 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 136 10 12 0   23     0   13   105 89                       194.0 136 10 12 0   23     0   13   105 89                 194
2047071 2047071 MA Worcester   school 2513080 343   Winchendon 251308002648 3430010 Winchendon PreSchool Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 69 1 4 0   0     0   4   39 39                       78.0 69 1 4 0   0     0   4   39 39                 78
2047196 2047196 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 311 107 99 4   9     0   21   261 290                       551.0 311 107 99 4   9     0   21   261 290                 551
2048052 2048052 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 45 6 8 0   36     0   10   57 48                       105.0 45 6 8 0   36     0   10   57 48                 105
2048443 2048443 MA Middlesex   school 2505500 673   Groton-Dunstable 250550002611 6730001 Boutwell School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 48 0 2 0   7     0   1   28 30                       58.0 48 0 2 0   7     0   1   28 30                 58
2049031 2049031 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 128 5 13 0   4     0   4   94 60                       154.0 128 5 13 0   4     0   4   94 60                 154
2040819 2040819 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_2 3 1 3 0   0     0   1   7 1                       8.0 3 1 3 0   0     0   1   7 1                 8
2040820 2040820 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_3 0 3 6 1   0     0   0   9 1                       10.0 0 3 6 1   0     0   0   9 1                 10
2040821 2040821 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_4 0 10 5 0   0     0   2   14 3                       17.0 0 10 5 0   0     0   2   14 3                 17
2040822 2040822 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_5 1 10 8 0   0     0   0   14 5                       19.0 1 10 8 0   0     0   0   14 5                 19
2040823 2040823 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_6 2 10 8 0   1     0   0   18 3                       21.0 2 10 8 0   1     0   0   18 3                 21
2040824 2040824 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_7 2 6 12 0   0     0   0   14 6                       20.0 2 6 12 0   0     0   0   14 6                 20
2040825 2040825 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_8 3 14 11 1   0     0   0   23 6                       29.0 3 14 11 1   0     0   0   23 6                 29
2040826 2040826 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_9 1 25 25 0   2     0   3   44 12                       56.0 1 25 25 0   2     0   3   44 12                 56
2040827 2040827 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_10 3 26 21 0   1     0   0   36 15                       51.0 3 26 21 0   1     0   0   36 15                 51
2040828 2040828 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_11 4 15 16 0   0     0   0   21 14                       35.0 4 15 16 0   0     0   0   21 14                 35
2040829 2040829 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_12 5 16 4 0   0     0   1   19 7                       26.0 5 16 4 0   0     0   1   19 7                 26
2040830 2040830 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   sped_beyond_grade_12 1 15 9 0   2     0   2                             29.0 1 15 9 0   2     0   2                       29
2040922 2040922 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_2 17 26 15 0   7     0   6   41 30                       71.0 17 26 15 0   7     0   6   41 30                 71
2040923 2040923 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_3 22 11 6 0   4     0   2   24 21                       45.0 22 11 6 0   4     0   2   24 21                 45
2040924 2040924 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_4 17 13 11 0   6     0   0   23 24                       47.0 17 13 11 0   6     0   0   23 24                 47
2040925 2040925 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_5 9 15 12 0   2     0   3   24 17                       41.0 9 15 12 0   2     0   3   24 17                 41
2040926 2040926 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_6 17 21 25 0   3     0   0   34 32                       66.0 17 21 25 0   3     0   0   34 32                 66
2040927 2040927 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_7 8 25 9 0   5     0   4   26 25                       51.0 8 25 9 0   5     0   4   26 25                 51
2040928 2040928 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_8 12 22 16 0   8     0   2   34 26                       60.0 12 22 16 0   8     0   2   34 26                 60
2040929 2040929 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_9 10 19 21 1   5     0   7   33 30                       63.0 10 19 21 1   5     0   7   33 30                 63
2040930 2040930 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_10 6 33 19 1   2     0   1   38 24                       62.0 6 33 19 1   2     0   1   38 24                 62
2040931 2040931 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_11 5 36 9 0   5     0   2   28 29                       57.0 5 36 9 0   5     0   2   28 29                 57
2040932 2040932 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_12 5 27 20 1   5     0   0   38 20                       58.0 5 27 20 1   5     0   0   38 20                 58
2040933 2040933 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   sped_beyond_grade_12 3 4 2 0   0     0   0                             9.0 3 4 2 0   0     0   0                       9
2041095 2041095 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041096 2041096 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_1 2 4 2 0   0     0   0   5 3                       8.0 2 4 2 0   0     0   0   5 3                 8
2041097 2041097 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_2 3 1 2 0   0     0   0   5 1                       6.0 3 1 2 0   0     0   0   5 1                 6
2041098 2041098 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_3 0 2 4 0   0     0   0   3 3                       6.0 0 2 4 0   0     0   0   3 3                 6
2041099 2041099 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_4 0 4 4 0   0     0   0   6 2                       8.0 0 4 4 0   0     0   0   6 2                 8
2041100 2041100 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_6 1 4 4 0   0     0   0   7 2                       9.0 1 4 4 0   0     0   0   7 2                 9
2041101 2041101 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_8 0 3 3 0   0     0   0   2 4                       6.0 0 3 3 0   0     0   0   2 4                 6
2041102 2041102 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_9 1 2 3 0   1     0   0   4 3                       7.0 1 2 3 0   1     0   0   4 3                 7
2041103 2041103 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_10 * * * *   *     *   *   1 2                       3.0                         1 2                 3

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