enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1127518 1127518 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   kindergarten 45 3 1 0   11     0   5   29 36                       65 45 3 1 0   11     0   5   29 36                 65
1127519 1127519 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_1 36 0 4 0   12     0   4   33 23                       56 36 0 4 0   12     0   4   33 23                 56
1127520 1127520 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_2 38 2 3 0   8     0   6   26 31                       57 38 2 3 0   8     0   6   26 31                 57
1127521 1127521 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_3 36 6 3 0   10     0   2   27 30                       57 36 6 3 0   10     0   2   27 30                 57
1127522 1127522 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_4 37 1 2 1   10     0   4   31 24                       55 37 1 2 1   10     0   4   31 24                 55
1127523 1127523 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   grade_5 25 4 4 0   10     1   3   30 17                       47 25 4 4 0   10     1   3   30 17                 47
1127524 1127524 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123213 1123213 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   kindergarten 1 25 33 0   0     0   1   30 30                       60 1 25 33 0   0     0   1   30 30                 60
1123214 1123214 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   pre_kindergarten 0 28 23 1   0     0   0   24 28                       52 0 28 23 1   0     0   0   24 28                 52
1123215 1123215 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_1 3 31 29 0   0     0   1   31 33                       64 3 31 29 0   0     0   1   31 33                 64
1123216 1123216 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_2 0 29 31 0   0     0   3   31 32                       63 0 29 31 0   0     0   3   31 32                 63
1123217 1123217 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_3 2 60 35 0   0     0   2   46 53                       99 2 60 35 0   0     0   2   46 53                 99
1123218 1123218 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_4 0 32 27 0   0     0   0   30 29                       59 0 32 27 0   0     0   0   30 29                 59
1123219 1123219 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_5 2 25 20 0   0     0   0   25 22                       47 2 25 20 0   0     0   0   25 22                 47
1123220 1123220 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_6 0 30 15 0   0     0   0   24 21                       45 0 30 15 0   0     0   0   24 21                 45
1123221 1123221 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_7 1 25 23 0   0     0   1   31 19                       50 1 25 23 0   0     0   1   31 19                 50
1123222 1123222 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_8 0 21 21 0   0     0   1   27 16                       43 0 21 21 0   0     0   1   27 16                 43
1123223 1123223 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130704 1130704 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   kindergarten 19 1 3 0   5     0   1   15 14                       29 19 1 3 0   5     0   1   15 14                 29
1130705 1130705 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_1 29 0 2 0   2     0   1   17 17                       34 29 0 2 0   2     0   1   17 17                 34
1130706 1130706 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_2 28 0 4 0   3     0   1   14 22                       36 28 0 4 0   3     0   1   14 22                 36
1130707 1130707 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_3 13 1 0 0   4     0   0   10 8                       18 13 1 0 0   4     0   0   10 8                 18
1130708 1130708 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_4 26 0 4 0   2     0   3   16 19                       35 26 0 4 0   2     0   3   16 19                 35
1130709 1130709 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_5 27 0 0 0   1     0   1   12 17                       29 27 0 0 0   1     0   1   12 17                 29
1130710 1130710 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131065 1131065 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_9 130 72 118 0   28     0   11   142 217                       359 130 72 118 0   28     0   11   142 217                 359
1131066 1131066 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_10 121 59 118 0   15     0   12   142 183                       325 121 59 118 0   15     0   12   142 183                 325
1131067 1131067 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_11 130 47 139 0   20     0   11   153 194                       347 130 47 139 0   20     0   11   153 194                 347
1131068 1131068 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_12 135 52 136 0   28     0   7   155 203                       358 135 52 136 0   28     0   7   155 203                 358
1131069 1131069 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131037 1131037 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_6 19 17 32 0   6     0   5   34 45                       79 19 17 32 0   6     0   5   34 45                 79
1131038 1131038 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_7 84 60 190 0   22     0   9   193 172                       365 84 60 190 0   22     0   9   193 172                 365
1131039 1131039 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_8 72 79 171 0   29     0   21   196 176                       372 72 79 171 0   29     0   21   196 176                 372
1131040 1131040 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130965 1130965 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   kindergarten 30 6 10 0   4     0   5   33 22                       55 30 6 10 0   4     0   5   33 22                 55
1130966 1130966 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   pre_kindergarten 12 4 7 0   4     0   0   14 13                       27 12 4 7 0   4     0   0   14 13                 27
1130967 1130967 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_1 28 12 13 0   8     0   3   27 37                       64 28 12 13 0   8     0   3   27 37                 64
1130968 1130968 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_2 29 10 11 0   2     0   8   27 33                       60 29 10 11 0   2     0   8   27 33                 60
1130969 1130969 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_3 37 10 10 0   1     0   4   32 30                       62 37 10 10 0   1     0   4   32 30                 62
1130970 1130970 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_4 22 8 11 0   5     0   5   23 28                       51 22 8 11 0   5     0   5   23 28                 51
1130971 1130971 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_5 25 7 10 0   1     0   1   20 24                       44 25 7 10 0   1     0   1   20 24                 44
1130972 1130972 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_6 25 5 8 0   0     0   4   14 28                       42 25 5 8 0   0     0   4   14 28                 42
1130973 1130973 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129815 1129815 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   kindergarten 97 3 5 1   6     0   7   65 54                       119 97 3 5 1   6     0   7   65 54                 119
1129816 1129816 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   grade_1 55 0 15 0   3     0   8   43 37                       81 55 0 15 0   3     0   8   43 37                 81
1129817 1129817 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   grade_2 64 3 8 0   3     0   1   39 40                       79 64 3 8 0   3     0   1   39 40                 79
1129818 1129818 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   grade_3 57 2 5 0   4     0   2   37 33                       70 57 2 5 0   4     0   2   37 33                 70
1129819 1129819 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   grade_4 76 0 14 0   2     0   1   50 43                       93 76 0 14 0   2     0   1   50 43                 93
1129820 1129820 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121954 1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1121956 1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125013 1125013 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   kindergarten 45 6 23 1   0     0   2   36 41                       77 45 6 23 1   0     0   2   36 41                 77
1125014 1125014 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_1 65 7 24 0   0     0   2   48 50                       98 65 7 24 0   0     0   2   48 50                 98
1125015 1125015 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_2 72 9 21 0   0     0   1   52 51                       103 72 9 21 0   0     0   1   52 51                 103
1125016 1125016 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_3 61 12 24 0   1     0   5   46 57                       103 61 12 24 0   1     0   5   46 57                 103
1125017 1125017 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_4 79 8 19 0   0     0   1   55 52                       107 79 8 19 0   0     0   1   55 52                 107
1125018 1125018 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_5 66 7 13 0   1     0   1   49 39                       88 66 7 13 0   1     0   1   49 39                 88
1125019 1125019 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132720 1132720 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   kindergarten 72 2 7 0   1     0   3   45 40                       85 72 2 7 0   1     0   3   45 40                 85
1132721 1132721 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   pre_kindergarten 52 0 9 0   0     0   1   34 28                       62 52 0 9 0   0     0   1   34 28                 62
1132722 1132722 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_1 88 2 4 0   0     0   0   51 43                       94 88 2 4 0   0     0   0   51 43                 94
1132723 1132723 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_2 85 1 6 0   1     0   4   47 50                       97 85 1 6 0   1     0   4   47 50                 97
1132724 1132724 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130750 1130750 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   kindergarten 10 8 73 0   6     0   1   45 53                       98 10 8 73 0   6     0   1   45 53                 98
1130751 1130751 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 10 0   1     0   2   8 5                       13 0 0 10 0   1     0   2   8 5                 13
1130752 1130752 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_1 8 10 54 0   6     0   3   39 42                       81 8 10 54 0   6     0   3   39 42                 81
1130753 1130753 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_2 6 6 67 0   9     0   3   43 48                       91 6 6 67 0   9     0   3   43 48                 91
1130754 1130754 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_3 12 3 65 0   8     0   4   49 43                       92 12 3 65 0   8     0   4   49 43                 92
1130755 1130755 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_4 9 3 51 1   10     0   3   36 41                       77 9 3 51 1   10     0   3   36 41                 77
1130756 1130756 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_5 8 9 72 0   10     0   1   52 48                       100 8 9 72 0   10     0   1   52 48                 100
1130757 1130757 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_6 3 7 57 0   8     0   0   41 34                       75 3 7 57 0   8     0   0   41 34                 75
1130758 1130758 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127007 1127007 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_3 193 11 87 8   7     0   13   161 158                       319 193 11 87 8   7     0   13   161 158                 319
1127008 1127008 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_4 192 8 100 13   4     0   14   175 156                       331 192 8 100 13   4     0   14   175 156                 331
1127009 1127009 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_5 217 6 82 8   10     0   10   182 151                       333 217 6 82 8   10     0   10   182 151                 333
1127010 1127010 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130328 1130328 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   kindergarten 52 4 3 0   9     1   2   39 32                       71 52 4 3 0   9     1   2   39 32                 71
1130329 1130329 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   pre_kindergarten 18 0 1 0   2     0   0   13 8                       21 18 0 1 0   2     0   0   13 8                 21
1130330 1130330 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   grade_1 41 6 2 0   10     0   0   28 31                       59 41 6 2 0   10     0   0   28 31                 59
1130331 1130331 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   grade_2 59 3 4 0   9     0   1   39 37                       76 59 3 4 0   9     0   1   39 37                 76
1130332 1130332 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   grade_3 47 5 6 0   15     0   2   34 41                       75 47 5 6 0   15     0   2   34 41                 75
1130333 1130333 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122115 1122115 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_6 72 3 9 0   32     0   4   50 70                       120 72 3 9 0   32     0   4   50 70                 120
1122116 1122116 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_7 88 3 10 0   39     0   3   76 67                       143 88 3 10 0   39     0   3   76 67                 143
1122117 1122117 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_8 99 7 7 0   40     0   3   66 90                       156 99 7 7 0   40     0   3   66 90                 156
1122118 1122118 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128460 1128460 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   kindergarten 41 0 4 0   1     0   1   19 28                       47 41 0 4 0   1     0   1   19 28                 47
1128461 1128461 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   grade_1 42 1 0 0   1     0   0   31 13                       44 42 1 0 0   1     0   0   31 13                 44
1128462 1128462 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   grade_2 56 3 2 0   5     0   1   34 33                       67 56 3 2 0   5     0   1   34 33                 67
1128463 1128463 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   grade_3 45 1 0 0   1     0   1   23 25                       48 45 1 0 0   1     0   1   23 25                 48
1128464 1128464 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   grade_4 37 0 2 0   1     0   1   21 20                       41 37 0 2 0   1     0   1   21 20                 41
1128465 1128465 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   grade_5 54 3 3 0   5     0   3   35 33                       68 54 3 3 0   5     0   3   35 33                 68
1128466 1128466 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128353 1128353 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2017   kindergarten 17 1 0 0   44     0   1   40 23                       63 17 1 0 0   44     0   1   40 23                 63
1128354 1128354 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2017   grade_1 21 1 1 0   34     0   0   28 29                       57 21 1 1 0   34     0   0   28 29                 57
1128355 1128355 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2017   grade_2 19 2 2 0   33     1   1   23 35                       58 19 2 2 0   33     1   1   23 35                 58
1128356 1128356 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2017   grade_3 13 1 1 0   41     0   0   26 30                       56 13 1 1 0   41     0   0   26 30                 56
1128357 1128357 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2017   grade_4 18 2 0 0   39     0   0   28 31                       59 18 2 0 0   39     0   0   28 31                 59
1128358 1128358 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2017   grade_5 21 4 0 0   19     0   1   23 22                       45 21 4 0 0   19     0   1   23 22                 45

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