enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,271 ✖
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
2229499 2229499 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_7 0 33 22 0   0     0   1   31 25                       56.0 0 33 22 0   0     0   1   31 25                 56
736290 736290 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   grade_7 3 10 10 0   0     0   1   14 10                       24 3 10 10 0   0     0   1   14 10                 24
933161 933161 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_7 5 19 24 0   0     0   3   21 30                       51 5 19 24 0   0     0   3   21 30                 51
1122701 1122701 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_7 5 18 18 0   1     0   0   22 20                       42 5 18 18 0   1     0   0   22 20                 42
1365400 1365400 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_7 1 15 21 0   0     1   3   18 23 *                     41.0 1 15 21 0   0     1   3   18 23                 41
1672624 1672624 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_7 2 12 7 0   0     0   3   13 11 *                     24.0 2 12 7 0   0     0   3   13 11                 24
2040443 2040443 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_7 2 13 10 0   0     0   3   13 15                       28.0 2 13 10 0   0     0   3   13 15                 28
2229514 2229514 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_7 4 11 24 0   1     0   1   18 23                       41.0 4 11 24 0   1     0   1   18 23                 41
736298 736298 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2015   grade_7 2 4 51 0   0     0   0   32 25                       57 2 4 51 0   0     0   0   32 25                 57
933170 933170 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_7 7 4 66 0   0     0   1   44 34                       78 7 4 66 0   0     0   1   44 34                 78
1122712 1122712 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_7 1 2 72 0   0     0   1   33 43                       76 1 2 72 0   0     0   1   33 43                 76
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1672634 1672634 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_7 7 1 89 0   1     0   2   51 49 *                     100.0 7 1 89 0   1     0   2   51 49                 100
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2229525 2229525 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_7 12 2 85 0   1     0   1   47 54                       101.0 12 2 85 0   1     0   1   47 54                 101
736321 736321 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_7 3 5 14 0   0     0   0   13 9                       22 3 5 14 0   0     0   0   13 9                 22
933187 933187 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_7 8 7 11 0   3     0   1   20 10                       30 8 7 11 0   3     0   1   20 10                 30
1122731 1122731 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_7 7 7 9 1   1     0   1   12 14                       26 7 7 9 1   1     0   1   12 14                 26
1365427 1365427 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_7 15 8 14 0   5     0   1   23 20 *                     43.0 15 8 14 0   5     0   1   23 20                 43
1672652 1672652 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_7 12 6 16 0   8     0   2   27 17 *                     44.0 12 6 16 0   8     0   2   27 17                 44
2040470 2040470 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_7 6 3 12 0   2     0   1   12 12                       24.0 6 3 12 0   2     0   1   12 12                 24
2229544 2229544 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_7 11 2 12 0   2     0   2   16 13                       29.0 11 2 12 0   2     0   2   16 13                 29
736338 736338 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_7 5 19 19 0   1     0   2   21 25                       46 5 19 19 0   1     0   2   21 25                 46
933204 933204 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   grade_7 5 19 22 0   1     0   0   26 21                       47 5 19 22 0   1     0   0   26 21                 47
1122750 1122750 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_7 3 19 26 0   0     0   0   22 26                       48 3 19 26 0   0     0   0   22 26                 48
1365444 1365444 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_7 1 19 21 0   1     0   2   24 20 *                     44.0 1 19 21 0   1     0   2   24 20                 44
1672669 1672669 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_7 2 20 18 0   1     0   2   21 22 *                     43.0 2 20 18 0   1     0   2   21 22                 43
2040487 2040487 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_7 4 23 15 0   0     0   1   18 25                       43.0 4 23 15 0   0     0   1   18 25                 43
2229563 2229563 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_7 3 15 18 1   0     0   0   25 12                       37.0 3 15 18 1   0     0   0   25 12                 37
1122793 1122793 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_7 10 26 20 0   4     0   5   32 33                       65 10 26 20 0   4     0   5   32 33                 65
1365482 1365482 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_7 20 28 32 0   2     0   1   42 41 *                     83.0 20 28 32 0   2     0   1   42 41                 83
1672709 1672709 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_7 6 26 38 0   5     0   3   39 39 *                     78.0 6 26 38 0   5     0   3   39 39                 78
2040525 2040525 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_7 9 32 34 0   5     0   2   50 32                       82.0 9 32 34 0   5     0   2   50 32                 82
2229606 2229606 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_7 9 27 34 0   4     0   2   44 32                       76.0 9 27 34 0   4     0   2   44 32                 76
933249 933249 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 07 2016   grade_7 0 19 43 0   1     1   0   35 29                       64 0 19 43 0   1     1   0   35 29                 64
1122802 1122802 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_7 0 13 35 0   2     0   0   25 25                       50 0 13 35 0   2     0   0   25 25                 50
1365491 1365491 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_7 4 14 55 0   0     0   2   35 40 *                     75.0 4 14 55 0   0     0   2   35 40                 75
1672718 1672718 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_7 1 21 62 0   2     0   0   40 46 *                     86.0 1 21 62 0   2     0   0   40 46                 86
2040534 2040534 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_7 1 13 36 0   1     0   1   24 28                       52.0 1 13 36 0   1     0   1   24 28                 52
2229616 2229616 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_7 1 17 41 0   0     0   0   22 37                       59.0 1 17 41 0   0     0   0   22 37                 59
736417 736417 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_7 11 76 90 0   17     0   5   112 87                       199 11 76 90 0   17     0   5   112 87                 199
933286 933286 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2016   grade_7 9 62 81 0   11     0   2   84 81                       165 9 62 81 0   11     0   2   84 81                 165
1122846 1122846 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2017   grade_7 6 38 89 0   10     0   0   72 71                       143 6 38 89 0   10     0   0   72 71                 143
1365529 1365529 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_7 8 36 61 1   3     0   2   48 63 *                     111.0 8 36 61 1   3     0   2   48 63                 111
1672757 1672757 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_7 2 24 48 0   4     0   1   45 34 *                     79.0 2 24 48 0   4     0   1   45 34                 79
2040572 2040572 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2019   grade_7 4 30 75 0   4     0   7   70 50                       120.0 4 30 75 0   4     0   7   70 50                 120
2229660 2229660 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_7 8 40 71 0   3     0   2   62 62                       124.0 8 40 71 0   3     0   2   62 62                 124
736441 736441 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_7 1 0 17 0   0     0   0   9 9                       18 1 0 17 0   0     0   0   9 9                 18
933310 933310 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2016   grade_7 0 0 17 0   0     0   0   5 12                       17 0 0 17 0   0     0   0   5 12                 17
1122873 1122873 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_7 1 0 18 0   0     0   0   10 9                       19 1 0 18 0   0     0   0   10 9                 19
1365553 1365553 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_7 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1672782 1672782 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_7 2 1 16 0   0     0   0   10 9 *                     19.0 2 1 16 0   0     0   0   10 9                 19
2040596 2040596 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   9 7                       16.0 0 0 16 0   0     0   0   9 7                 16
2229687 2229687 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_7 0 0 17 0   0     0   0   6 11                       17.0 0 0 17 0   0     0   0   6 11                 17
736451 736451 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2015   grade_7 1 40 15 0   4     0   4   41 23                       64 1 40 15 0   4     0   4   41 23                 64
933320 933320 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   grade_7 4 38 22 0   3     0   1   42 26                       68 4 38 22 0   3     0   1   42 26                 68
1122884 1122884 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_7 1 42 14 0   3     0   0   33 27                       60 1 42 14 0   3     0   0   33 27                 60
1365563 1365563 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_7 1 32 21 0   4     0   6   31 33 *                     64.0 1 32 21 0   4     0   6   31 33                 64
1672792 1672792 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_7 0 36 23 0   3     0   7   32 37 *                     69.0 0 36 23 0   3     0   7   32 37                 69
2040606 2040606 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_7 2 30 19 0   3     0   2   34 22                       56.0 2 30 19 0   3     0   2   34 22                 56
2229698 2229698 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_7 2 35 22 0   2     2   5   38 30                       68.0 2 35 22 0   2     2   5   38 30                 68
736468 736468 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_7 8 4 8 0   1     0   0   10 11                       21 8 4 8 0   1     0   0   10 11                 21
933337 933337 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2016   grade_7 10 4 6 1   1     0   3   10 15                       25 10 4 6 1   1     0   3   10 15                 25
1122903 1122903 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_7 7 8 7 0   0     0   0   12 10                       22 7 8 7 0   0     0   0   12 10                 22
1365580 1365580 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_7 10 1 11 0   2     0   1   12 13 *                     25.0 10 1 11 0   2     0   1   12 13                 25
1672810 1672810 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_7 11 11 18 0   1     0   0   24 17 *                     41.0 11 11 18 0   1     0   0   24 17                 41
2040623 2040623 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_7 6 2 6 0   0     0   0   7 7                       14.0 6 2 6 0   0     0   0   7 7                 14
2229717 2229717 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_7 12 7 8 0   0     0   0   9 18                       27.0 12 7 8 0   0     0   0   9 18                 27
736506 736506 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_7 0 7 16 0   0     0   0   9 14                       23 0 7 16 0   0     0   0   9 14                 23
933375 933375 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_7 0 8 33 0   0     0   0   25 16                       41 0 8 33 0   0     0   0   25 16                 41
1122946 1122946 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_7 0 8 19 0   0     0   1   15 13                       28 0 8 19 0   0     0   1   15 13                 28
1365611 1365611 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_7 1 10 27 0   1     0   0   10 29 *                     39.0 1 10 27 0   1     0   0   10 29                 39
1672843 1672843 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_7 2 19 26 0   1     0   1   31 18 *                     49.0 2 19 26 0   1     0   1   31 18                 49
2040654 2040654 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_7 1 9 23 0   3     0   0   18 18                       36.0 1 9 23 0   3     0   0   18 18                 36
2229752 2229752 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_7 0 4 21 0   0     0   0   10 15                       25.0 0 4 21 0   0     0   0   10 15                 25
736529 736529 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_7 15 30 11 1   20     0   2   37 42                       79 15 30 11 1   20     0   2   37 42                 79
933398 933398 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_7 12 26 18 0   25     1   6   56 32                       88 12 26 18 0   25     1   6   56 32                 88
1122972 1122972 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_7 10 26 14 1   36     1   1   41 48                       89 10 26 14 1   36     1   1   41 48                 89
1365635 1365635 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_7 3 19 32 0   24     0   3   47 34 *                     81.0 3 19 32 0   24     0   3   47 34                 81
1672868 1672868 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_7 6 20 21 0   46     0   4   47 50 *                     97.0 6 20 21 0   46     0   4   47 50                 97
2040678 2040678 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   grade_7 4 11 29 0   21     0   4   35 34                       69.0 4 11 29 0   21     0   4   35 34                 69
2229778 2229778 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_7 9 22 15 0   36     0   2   46 38                       84.0 9 22 15 0   36     0   2   46 38                 84
736546 736546 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_7 7 4 6 0   0     0   0   7 10                       17 7 4 6 0   0     0   0   7 10                 17
933415 933415 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_7 8 2 5 0   0     1   2   12 6                       18 8 2 5 0   0     1   2   12 6                 18
1122991 1122991 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_7 5 4 4 0   1     0   0   13 1                       14 5 4 4 0   1     0   0   13 1                 14
1365652 1365652 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_7 6 5 5 0   2     0   2   9 11 *                     20.0 6 5 5 0   2     0   2   9 11                 20
2040695 2040695 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_7 10 7 4 0   0     0   1   15 7                       22.0 10 7 4 0   0     0   1   15 7                 22
2229797 2229797 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_7 9 2 1 0   0     0   0   5 7                       12.0 9 2 1 0   0     0   0   5 7                 12
736556 736556 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_7 1 33 43 0   1     1   2   27 54                       81 1 33 43 0   1     1   2   27 54                 81
933425 933425 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_7 1 27 43 0   2     0   1   39 35                       74 1 27 43 0   2     0   1   39 35                 74
1123002 1123002 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_7 0 43 44 1   0     0   4   42 50                       92 0 43 44 1   0     0   4   42 50                 92
1365662 1365662 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_7 1 43 42 0   0     1   0   39 48 *                     87.0 1 43 42 0   0     1   0   39 48                 87
1672895 1672895 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_7 2 31 45 1   0     1   3   35 48 *                     83.0 2 31 45 1   0     1   3   35 48                 83
2040705 2040705 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_7 2 41 38 1   2     0   2   43 43                       86.0 2 41 38 1   2     0   2   43 43                 86
2229807 2229807 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_7 3 42 38 0   2     1   3   50 39                       89.0 3 42 38 0   2     1   3   50 39                 89
736562 736562 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_7 7 31 48 0   2     0   2   56 34                       90 7 31 48 0   2     0   2   56 34                 90
933431 933431 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_7 9 26 46 0   3     0   7   60 31                       91 9 26 46 0   3     0   7   60 31                 91
1123009 1123009 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_7 7 31 41 0   2     0   1   44 38                       82 7 31 41 0   2     0   1   44 38                 82
1365668 1365668 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_7 6 25 41 0   0     0   3   41 34 *                     75.0 6 25 41 0   0     0   3   41 34                 75
1672901 1672901 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_7 11 25 40 0   1     0   4   42 39 *                     81.0 11 25 40 0   1     0   4   42 39                 81

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