enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1368743 1368743 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_5 158 13 215 0   8     0   19   198 215 *                     413.0 158 13 215 0   8     0   19   198 215                 413
1368744 1368744 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_6 120 12 215 1   14     0   9   204 167 *                     371.0 120 12 215 1   14     0   9   204 167                 371
1368745 1368745 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_7 157 13 198 0   7     0   9   197 187 *                     384.0 157 13 198 0   7     0   9   197 187                 384
1368746 1368746 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_8 108 6 179 0   4     0   13   149 161 *                     310.0 108 6 179 0   4     0   13   149 161                 310
1368483 1368483 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   kindergarten 5 6 59 0   5     0   2   39 38 *                     77.0 5 6 59 0   5     0   2   39 38                 77
1368484 1368484 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 2 1 1 0   2     0   1   6 1 *                     7.0 2 1 1 0   2     0   1   6 1                 7
1368485 1368485 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_1 9 0 52 1   14     0   0   36 40 *                     76.0 9 0 52 1   14     0   0   36 40                 76
1368486 1368486 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_2 9 6 49 0   11     0   1   30 46 *                     76.0 9 6 49 0   11     0   1   30 46                 76
1368487 1368487 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_3 6 3 54 1   6     0   2   33 39 *                     72.0 6 3 54 1   6     0   2   33 39                 72
1368488 1368488 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_4 5 3 57 0   14     0   2   45 36 *                     81.0 5 3 57 0   14     0   2   45 36                 81
1368489 1368489 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_5 3 5 55 0   14     0   4   41 40 *                     81.0 3 5 55 0   14     0   4   41 40                 81
1369370 1369370 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   kindergarten 43 0 3 0   11     0   8   29 36 *                     65.0 43 0 3 0   11     0   8   29 36                 65
1369371 1369371 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_1 63 3 2 0   9     0   9   44 42 *                     86.0 63 3 2 0   9     0   9   44 42                 86
1369372 1369372 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_2 51 4 4 0   8     0   6   40 33 *                     73.0 51 4 4 0   8     0   6   40 33                 73
1369373 1369373 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_3 68 2 6 0   16     0   7   55 44 *                     99.0 68 2 6 0   16     0   7   55 44                 99
1369374 1369374 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_4 63 1 5 0   10     0   3   37 45 *                     82.0 63 1 5 0   10     0   3   37 45                 82
1369375 1369375 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_5 61 3 7 0   18     0   8   40 57 *                     97.0 61 3 7 0   18     0   8   40 57                 97
1373160 1373160 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_3 66 3 8 0   0     0   6   38 45 *                     83.0 66 3 8 0   0     0   6   38 45                 83
1373161 1373161 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_4 105 4 7 0   1     0   6   72 51 *                     123.0 105 4 7 0   1     0   6   72 51                 123
1373162 1373162 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_5 66 1 8 0   0     0   8   45 38 *                     83.0 66 1 8 0   0     0   8   45 38                 83
1370267 1370267 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   kindergarten 34 2 53 0   7     0   3   59 40 *                     99.0 34 2 53 0   7     0   3   59 40                 99
1370268 1370268 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_1 61 2 61 0   7     0   3   66 68 *                     134.0 61 2 61 0   7     0   3   66 68                 134
1370269 1370269 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_2 60 6 64 0   4     0   4   73 65 *                     138.0 60 6 64 0   4     0   4   73 65                 138
1370270 1370270 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_3 58 4 77 0   4     0   0   81 62 *                     143.0 58 4 77 0   4     0   0   81 62                 143
1370271 1370271 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_4 55 2 61 0   4     0   2   65 59 *                     124.0 55 2 61 0   4     0   2   65 59                 124
1370272 1370272 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_5 52 3 49 0   6     1   3   60 54 *                     114.0 52 3 49 0   6     1   3   60 54                 114
1364994 1364994 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   kindergarten 55 7 11 1   1     0   2   35 42 *                     77.0 55 7 11 1   1     0   2   35 42                 77
1364995 1364995 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_1 48 4 13 0   2     0   3   31 39 *                     70.0 48 4 13 0   2     0   3   31 39                 70
1364996 1364996 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 5 7 0   1     0   1   35 36 *                     71.0 57 5 7 0   1     0   1   35 36                 71
1364997 1364997 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_3 49 5 13 0   1     0   5   35 38 *                     73.0 49 5 13 0   1     0   5   35 38                 73
1364998 1364998 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_4 57 5 12 1   4     1   8   53 35 *                     88.0 57 5 12 1   4     1   8   53 35                 88
1369815 1369815 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   grade_10 * * * *   *     *   *   2 * *                     2.0                         2                   2
1369816 1369816 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   grade_11 * * * *   *     *   *   1 * *                     1.0                         1                   1
1369817 1369817 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   grade_12 * * * *   *     *   *   4 * *                     4.0                         4                   4
1369818 1369818 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 * *                     1.0                         1                   1
1371764 1371764 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_3 73 0 2 0   22     0   3   50 50 *                     100.0 73 0 2 0   22     0   3   50 50                 100
1371765 1371765 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_4 91 0 1 0   39     0   5   61 75 *                     136.0 91 0 1 0   39     0   5   61 75                 136
1371766 1371766 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_5 99 1 1 0   27     0   6   65 69 *                     134.0 99 1 1 0   27     0   6   65 69                 134
1367290 1367290 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   kindergarten 7 0 0 0   0     0   0   3 4 *                     7.0 7 0 0 0   0     0   0   3 4                 7
1367291 1367291 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   pre_kindergarten 22 0 0 0   0     0   0   15 7 *                     22.0 22 0 0 0   0     0   0   15 7                 22
1367292 1367292 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_1 9 0 0 0   0     0   0   5 4 *                     9.0 9 0 0 0   0     0   0   5 4                 9
1367293 1367293 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_3 9 0 0 0   0     0   0   3 6 *                     9.0 9 0 0 0   0     0   0   3 6                 9
1367294 1367294 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_4 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
1367295 1367295 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_5 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1367296 1367296 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_6 14 0 0 0   0     0   0   9 5 *                     14.0 14 0 0 0   0     0   0   9 5                 14
1367297 1367297 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_7 13 1 0 0   0     0   0   9 5 *                     14.0 13 1 0 0   0     0   0   9 5                 14
1367298 1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1372659 1372659 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 2020   kindergarten 31 59 7 1   5     0   11   52 62 *                     114.0 31 59 7 1   5     0   11   52 62                 114
1372660 1372660 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 2020   grade_1 18 61 31 3   2     0   5   54 66 *                     120.0 18 61 31 3   2     0   5   54 66                 120
1372661 1372661 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 2020   grade_2 19 56 29 1   6     0   8   42 77 *                     119.0 19 56 29 1   6     0   8   42 77                 119
1372662 1372662 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 2020   grade_3 27 55 34 0   4     0   0   52 68 *                     120.0 27 55 34 0   4     0   0   52 68                 120
1372663 1372663 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 2020   grade_4 28 62 20 0   2     0   4   59 57 *                     116.0 28 62 20 0   2     0   4   59 57                 116
1372664 1372664 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 2020   grade_5 22 67 18 0   3     0   6   61 55 *                     116.0 22 67 18 0   3     0   6   61 55                 116
1372665 1372665 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 2020   grade_6 13 78 22 0   4     0   3   56 64 *                     120.0 13 78 22 0   4     0   3   56 64                 120
1372666 1372666 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 2020   grade_7 21 61 32 0   1     0   0   56 59 *                     115.0 21 61 32 0   1     0   0   56 59                 115
1372667 1372667 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 2020   grade_8 24 61 16 0   3     1   1   51 55 *                     106.0 24 61 16 0   3     1   1   51 55                 106
1372668 1372668 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 2020   grade_9 20 50 24 0   3     0   5   53 49 *                     102.0 20 50 24 0   3     0   5   53 49                 102
1372669 1372669 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 2020   grade_10 17 58 23 0   6     0   0   49 55 *                     104.0 17 58 23 0   6     0   0   49 55                 104
1372670 1372670 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 2020   grade_11 16 44 22 0   6     0   1   35 54 *                     89.0 16 44 22 0   6     0   1   35 54                 89
1372671 1372671 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 2020   grade_12 23 35 19 0   5     0   2   38 46 *                     84.0 23 35 19 0   5     0   2   38 46                 84
1371952 1371952 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_5 293 37 48 1   24     1   18   193 229 *                     422.0 293 37 48 1   24     1   18   193 229                 422
1371953 1371953 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_6 323 24 58 1   33     0   24   236 227 *                     463.0 323 24 58 1   33     0   24   236 227                 463
1371954 1371954 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_7 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1364795 1364795 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_10 127 10 12 0   4     0   3   80 76 *                     156.0 127 10 12 0   4     0   3   80 76                 156
1364796 1364796 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_11 127 8 15 0   3     0   1   80 74 *                     154.0 127 8 15 0   3     0   1   80 74                 154
1364797 1364797 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_12 102 3 6 0   4     0   2   55 62 *                     117.0 102 3 6 0   4     0   2   55 62                 117
1364798 1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1364792 1364792 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_7 139 3 12 1   4     0   5   86 78 *                     164.0 139 3 12 1   4     0   5   86 78                 164
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
1371726 1371726 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   kindergarten 19 0 11 0   5     0   3   21 17 *                     38.0 19 0 11 0   5     0   3   21 17                 38
1371727 1371727 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_1 19 1 13 0   5     0   1   22 17 *                     39.0 19 1 13 0   5     0   1   22 17                 39
1371728 1371728 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_2 29 2 13 0   3     0   1   27 21 *                     48.0 29 2 13 0   3     0   1   27 21                 48
1371729 1371729 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_3 28 2 8 0   2     0   3   21 22 *                     43.0 28 2 8 0   2     0   3   21 22                 43
1371730 1371730 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_4 21 4 12 0   3     0   0   20 20 *                     40.0 21 4 12 0   3     0   0   20 20                 40
1368477 1368477 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   kindergarten 11 6 14 0   4     0   2   19 18 *                     37.0 11 6 14 0   4     0   2   19 18                 37
1368478 1368478 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_1 19 3 19 0   6     0   5   21 31 *                     52.0 19 3 19 0   6     0   5   21 31                 52
1368479 1368479 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_2 8 2 22 1   6     0   3   21 21 *                     42.0 8 2 22 1   6     0   3   21 21                 42
1368480 1368480 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_3 8 6 13 1   7     0   4   22 17 *                     39.0 8 6 13 1   7     0   4   22 17                 39
1368481 1368481 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_4 11 4 11 0   3     0   8   18 19 *                     37.0 11 4 11 0   3     0   8   18 19                 37
1368482 1368482 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_5 12 6 19 1   2     0   1   22 19 *                     41.0 12 6 19 1   2     0   1   22 19                 41
1368313 1368313 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   kindergarten 13 2 30 0   39     0   2   36 50 *                     86.0 13 2 30 0   39     0   2   36 50                 86
1368314 1368314 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   pre_kindergarten 9 0 8 0   24     0   5   30 16 *                     46.0 9 0 8 0   24     0   5   30 16                 46
1368315 1368315 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_1 10 2 33 0   44     0   4   47 46 *                     93.0 10 2 33 0   44     0   4   47 46                 93
1368316 1368316 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_2 14 3 25 0   44     0   6   54 38 *                     92.0 14 3 25 0   44     0   6   54 38                 92
1368317 1368317 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_3 7 1 31 0   50     0   2   50 41 *                     91.0 7 1 31 0   50     0   2   50 41                 91
1368318 1368318 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_4 16 6 31 0   29     0   3   47 38 *                     85.0 16 6 31 0   29     0   3   47 38                 85
1369270 1369270 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   kindergarten 39 9 41 0   2     0   9   52 48 *                     100.0 39 9 41 0   2     0   9   52 48                 100
1369271 1369271 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_1 52 11 48 0   0     0   6   67 50 *                     117.0 52 11 48 0   0     0   6   67 50                 117
1369272 1369272 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_2 55 18 50 0   2     1   5   68 63 *                     131.0 55 18 50 0   2     1   5   68 63                 131
1369273 1369273 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_3 56 15 39 0   3     0   8   55 66 *                     121.0 56 15 39 0   3     0   8   55 66                 121
1369274 1369274 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_4 69 14 42 0   2     0   4   63 68 *                     131.0 69 14 42 0   2     0   4   63 68                 131
1369275 1369275 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_5 50 11 40 1   0     0   8   56 54 *                     110.0 50 11 40 1   0     0   8   56 54                 110
1370283 1370283 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   kindergarten 34 5 42 1   1     0   2   43 42 *                     85.0 34 5 42 1   1     0   2   43 42                 85
1370284 1370284 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   pre_kindergarten 59 3 29 0   3     0   1   54 41 *                     95.0 59 3 29 0   3     0   1   54 41                 95
1370285 1370285 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   grade_1 35 2 49 0   4     0   2   55 37 *                     92.0 35 2 49 0   4     0   2   55 37                 92
1370286 1370286 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   grade_2 25 1 57 0   4     0   2   41 48 *                     89.0 25 1 57 0   4     0   2   41 48                 89

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