enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1126675 1126675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_5 162 9 156 0   19     0   18   168 196                       364 162 9 156 0   19     0   18   168 196                 364
1126676 1126676 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_6 126 12 153 0   9     0   9   168 141                       309 126 12 153 0   9     0   9   168 141                 309
1126677 1126677 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_7 132 9 137 0   3     0   13   163 131                       294 132 9 137 0   3     0   13   163 131                 294
1126678 1126678 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_8 152 7 146 0   5     0   8   167 151                       318 152 7 146 0   5     0   8   167 151                 318
1126679 1126679 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130405 1130405 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No High 09 12 2017   grade_12 10 1 2 0   0     0   0   11 *                       13 10 1 2 0   0     0   0   11                   13
1130406 1130406 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126367 1126367 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   kindergarten 8 4 40 1   5     0   3   25 36                       61 8 4 40 1   5     0   3   25 36                 61
1126368 1126368 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_1 7 2 47 0   15     0   2   40 33                       73 7 2 47 0   15     0   2   40 33                 73
1126369 1126369 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_2 3 12 52 0   15     0   8   46 44                       90 3 12 52 0   15     0   8   46 44                 90
1126370 1126370 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_3 6 11 82 0   16     0   2   56 61                       117 6 11 82 0   16     0   2   56 61                 117
1126371 1126371 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_4 3 5 51 1   16     0   4   41 39                       80 3 5 51 1   16     0   4   41 39                 80
1126372 1126372 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_5 1 5 43 0   13     0   1   31 32                       63 1 5 43 0   13     0   1   31 32                 63
1126373 1126373 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127418 1127418 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   kindergarten 55 0 2 0   13     0   8   40 38                       78 55 0 2 0   13     0   8   40 38                 78
1127419 1127419 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_1 52 4 2 0   7     0   1   30 36                       66 52 4 2 0   7     0   1   30 36                 66
1127420 1127420 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_2 52 3 5 0   13     0   6   30 49                       79 52 3 5 0   13     0   6   30 49                 79
1127421 1127421 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_3 54 2 4 0   9     0   2   34 37                       71 54 2 4 0   9     0   2   34 37                 71
1127422 1127422 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_4 51 3 4 0   8     0   4   30 40                       70 51 3 4 0   8     0   4   30 40                 70
1127423 1127423 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_5 32 2 5 0   12     0   6   31 26                       57 32 2 5 0   12     0   6   31 26                 57
1127424 1127424 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131885 1131885 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   grade_3 89 3 8 0   3     0   5   52 56                       108 89 3 8 0   3     0   5   52 56                 108
1131886 1131886 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   grade_4 84 1 4 0   1     0   3   37 56                       93 84 1 4 0   1     0   3   37 56                 93
1131887 1131887 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   grade_5 79 3 4 1   0     0   4   49 42                       91 79 3 4 1   0     0   4   49 42                 91
1131888 1131888 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128480 1128480 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   kindergarten 57 2 51 0   6     0   2   67 51                       118 57 2 51 0   6     0   2   67 51                 118
1128481 1128481 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_1 56 3 43 0   9     0   3   57 57                       114 56 3 43 0   9     0   3   57 57                 114
1128482 1128482 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_2 46 4 52 0   7     1   3   56 57                       113 46 4 52 0   7     1   3   56 57                 113
1128483 1128483 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_3 76 2 48 0   6     0   3   75 60                       135 76 2 48 0   6     0   3   75 60                 135
1128484 1128484 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_4 55 4 54 0   7     0   2   65 57                       122 55 4 54 0   7     0   2   65 57                 122
1128485 1128485 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_5 67 3 49 0   5     0   4   63 65                       128 67 3 49 0   5     0   4   63 65                 128
1128486 1128486 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122203 1122203 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   kindergarten 35 7 26 0   0     0   5   38 35                       73 35 7 26 0   0     0   5   38 35                 73
1122204 1122204 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_1 50 5 27 1   2     1   11   51 46                       97 50 5 27 1   2     1   11   51 46                 97
1122205 1122205 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_2 61 1 28 0   2     0   2   47 47                       94 61 1 28 0   2     0   2   47 47                 94
1122206 1122206 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_3 48 1 19 0   4     0   8   41 39                       80 48 1 19 0   4     0   8   41 39                 80
1122207 1122207 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_4 67 3 23 0   0     0   4   55 42                       97 67 3 23 0   0     0   4   55 42                 97
1122208 1122208 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130271 1130271 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_3 87 0 1 1   24     0   2   47 68                       115 87 0 1 1   24     0   2   47 68                 115
1130272 1130272 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_4 97 0 0 3   15     0   3   65 53                       118 97 0 0 3   15     0   3   65 53                 118
1130273 1130273 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_5 100 1 0 3   16     0   3   58 65                       123 100 1 0 3   16     0   3   58 65                 123
1130274 1130274 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124919 1124919 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   kindergarten 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1124920 1124920 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   pre_kindergarten 10 1 0 0   0     0   0   6 5                       11 10 1 0 0   0     0   0   6 5                 11
1124921 1124921 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_1 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1124922 1124922 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_2 * * * *   *     *   *   2 3                       *                         2 3                  
1124923 1124923 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_3 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
1124924 1124924 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_4 13 0 0 0   0     0   0   5 8                       13 13 0 0 0   0     0   0   5 8                 13
1124925 1124925 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_5 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
1124926 1124926 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1124928 1124928 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131326 1131326 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   kindergarten 25 52 34 0   5     0   0   56 60                       116 25 52 34 0   5     0   0   56 60                 116
1131327 1131327 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_1 31 55 20 0   2     0   5   54 59                       113 31 55 20 0   2     0   5   54 59                 113
1131328 1131328 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_2 27 62 18 0   3     0   8   63 55                       118 27 62 18 0   3     0   8   63 55                 118
1131329 1131329 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_3 14 81 24 0   3     0   0   52 70                       122 14 81 24 0   3     0   0   52 70                 122
1131330 1131330 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_4 20 63 34 0   2     0   0   57 62                       119 20 63 34 0   2     0   0   57 62                 119
1131331 1131331 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_5 30 61 19 0   5     1   2   57 61                       118 30 61 19 0   5     1   2   57 61                 118
1131332 1131332 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_6 29 63 26 0   3     0   6   65 62                       127 29 63 26 0   3     0   6   65 62                 127
1131333 1131333 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_7 23 63 28 0   7     0   0   55 66                       121 23 63 28 0   7     0   0   55 66                 121
1131334 1131334 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_8 23 50 32 1   7     0   2   51 64                       115 23 50 32 1   7     0   2   51 64                 115
1131335 1131335 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_9 27 41 20 0   5     0   3   48 48                       96 27 41 20 0   5     0   3   48 48                 96
1131336 1131336 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_10 24 36 17 0   5     1   3   51 35                       86 24 36 17 0   5     1   3   51 35                 86
1131337 1131337 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_11 23 35 27 0   6     0   2   32 61                       93 23 35 27 0   6     0   2   32 61                 93
1131338 1131338 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_12 31 29 15 0   4     0   2   33 48                       81 31 29 15 0   4     0   2   33 48                 81
1131339 1131339 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130508 1130508 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   grade_5 360 30 52 2   24     1   12   235 246                       481 360 30 52 2   24     1   12   235 246                 481
1130509 1130509 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   grade_6 365 24 33 2   20     1   13   241 217                       458 365 24 33 2   20     1   13   241 217                 458
1130510 1130510 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121960 1121960 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_9 106 3 8 1   4     0   2   55 69                       124 106 3 8 1   4     0   2   55 69                 124
1121961 1121961 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_10 91 4 10 0   3     1   0   50 59                       109 91 4 10 0   3     1   0   50 59                 109
1121962 1121962 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_11 105 1 15 0   0     0   2   59 64                       123 105 1 15 0   0     0   2   59 64                 123
1121963 1121963 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_12 82 2 8 0   0     0   0   41 51                       92 82 2 8 0   0     0   0   41 51                 92
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130211 1130211 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   kindergarten 30 0 7 0   2     0   1   23 17                       40 30 0 7 0   2     0   1   23 17                 40
1130212 1130212 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_1 25 2 6 0   5     0   0   20 18                       38 25 2 6 0   5     0   0   20 18                 38
1130213 1130213 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_2 14 1 7 0   3     0   0   12 13                       25 14 1 7 0   3     0   0   12 13                 25
1130214 1130214 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_3 24 3 7 0   1     0   3   23 15                       38 24 3 7 0   1     0   3   23 15                 38
1130215 1130215 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_4 33 2 6 0   1     0   1   15 28                       43 33 2 6 0   1     0   1   15 28                 43
1130216 1130216 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_5 23 0 9 0   1     0   1   12 22                       34 23 0 9 0   1     0   1   12 22                 34
1130217 1130217 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126360 1126360 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   kindergarten 7 7 9 0   4     0   4   13 18                       31 7 7 9 0   4     0   4   13 18                 31
1126361 1126361 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_1 16 6 10 0   3     0   6   20 21                       41 16 6 10 0   3     0   6   20 21                 41
1126362 1126362 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_2 19 6 17 1   1     0   1   23 22                       45 19 6 17 1   1     0   1   23 22                 45
1126363 1126363 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_3 22 9 17 1   3     0   4   28 28                       56 22 9 17 1   3     0   4   28 28                 56
1126364 1126364 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_4 13 8 19 0   2     0   3   19 26                       45 13 8 19 0   2     0   3   19 26                 45
1126365 1126365 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_5 17 5 15 0   1     0   3   21 20                       41 17 5 15 0   1     0   3   21 20                 41
1126366 1126366 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126185 1126185 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   kindergarten 3 3 25 0   55     0   3   50 39                       89 3 3 25 0   55     0   3   50 39                 89
1126186 1126186 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   pre_kindergarten 7 0 11 0   27     0   4   28 21                       49 7 0 11 0   27     0   4   28 21                 49
1126187 1126187 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   grade_1 12 8 29 1   31     0   3   49 35                       84 12 8 29 1   31     0   3   49 35                 84
1126188 1126188 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   grade_2 8 5 35 0   44     0   2   45 49                       94 8 5 35 0   44     0   2   45 49                 94
1126189 1126189 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   grade_3 18 6 24 0   44     0   4   52 44                       96 18 6 24 0   44     0   4   52 44                 96
1126190 1126190 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   grade_4 13 2 26 0   41     0   8   51 39                       90 13 2 26 0   41     0   8   51 39                 90
1126191 1126191 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127305 1127305 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   kindergarten 63 14 38 0   0     0   4   52 67                       119 63 14 38 0   0     0   4   52 67                 119
1127306 1127306 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_1 71 7 37 1   1     0   8   60 65                       125 71 7 37 1   1     0   8   60 65                 125
1127307 1127307 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_2 64 11 35 0   0     0   9   63 56                       119 64 11 35 0   0     0   9   63 56                 119
1127308 1127308 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_3 80 13 53 0   1     0   8   82 73                       155 80 13 53 0   1     0   8   82 73                 155
1127309 1127309 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_4 52 13 58 0   1     0   14   72 66                       138 52 13 58 0   1     0   14   72 66                 138

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