enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by ccd_charter_school

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
736656 736656 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   kindergarten 45 6 11 0   2     0   5   33 36                       69 45 6 11 0   2     0   5   33 36                 69
736657 736657 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   pre_kindergarten * * * *   *     *   *   2 2                       4                         2 2                 4
736658 736658 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_1 44 6 11 0   3     0   4   34 34                       68 44 6 11 0   3     0   4   34 34                 68
736659 736659 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_2 43 4 19 0   4     0   1   36 35                       71 43 4 19 0   4     0   1   36 35                 71
736660 736660 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_3 34 10 23 0   3     0   1   35 36                       71 34 10 23 0   3     0   1   35 36                 71
736661 736661 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_4 38 10 11 1   2     1   5   33 35                       68 38 10 11 1   2     1   5   33 35                 68
736662 736662 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_5 26 8 16 0   5     0   2   35 22                       57 26 8 16 0   5     0   2   35 22                 57
736663 736663 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_6 28 11 13 1   2     0   1   35 21                       56 28 11 13 1   2     0   1   35 21                 56
736664 736664 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_7 7 6 8 0   0     0   0   10 11                       21 7 6 8 0   0     0   0   10 11                 21
736665 736665 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_8 17 5 21 0   1     0   3   27 20                       47 17 5 21 0   1     0   3   27 20                 47
736666 736666 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   kindergarten 4 17 8 1   0     0   1   18 13                       31 4 17 8 1   0     0   1   18 13                 31
736667 736667 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   pre_kindergarten 0 17 10 0   1     0   1   19 10                       29 0 17 10 0   1     0   1   19 10                 29
736668 736668 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_1 1 25 12 0   0     0   3   24 17                       41 1 25 12 0   0     0   3   24 17                 41
736669 736669 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_2 2 11 29 0   0     0   1   20 23                       43 2 11 29 0   0     0   1   20 23                 43
736670 736670 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_3 2 29 20 0   0     0   1   24 28                       52 2 29 20 0   0     0   1   24 28                 52
736671 736671 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_4 1 28 20 0   2     0   0   28 23                       51 1 28 20 0   2     0   0   28 23                 51
736672 736672 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_5 1 32 14 0   0     0   1   17 31                       48 1 32 14 0   0     0   1   17 31                 48
736673 736673 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
736674 736674 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_2 3 6 2 0   0     0   1   11 1                       12 3 6 2 0   0     0   1   11 1                 12
736675 736675 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_3 1 5 6 0   0     0   0   10 2                       12 1 5 6 0   0     0   0   10 2                 12
736676 736676 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_5 3 12 14 0   0     0   3   27 5                       32 3 12 14 0   0     0   3   27 5                 32
736677 736677 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_6 2 14 11 0   0     0   1   22 6                       28 2 14 11 0   0     0   1   22 6                 28
736678 736678 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_7 3 11 13 0   0     0   0   24 3                       27 3 11 13 0   0     0   0   24 3                 27
736679 736679 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_8 3 14 12 0   0     0   0   17 12                       29 3 14 12 0   0     0   0   17 12                 29
736680 736680 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_9 3 27 11 0   1     0   1   32 11                       43 3 27 11 0   1     0   1   32 11                 43
736681 736681 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_10 7 19 23 0   1     0   4   29 25                       54 7 19 23 0   1     0   4   29 25                 54
736682 736682 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_11 3 37 17 1   1     0   0   41 18                       59 3 37 17 1   1     0   0   41 18                 59
736683 736683 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_12 5 20 5 1   0     0   1   20 12                       32 5 20 5 1   0     0   1   20 12                 32
736684 736684 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   SP 6 18 4 0   0     0   2                             30 6 18 4 0   0     0   2                       30
736685 736685 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   kindergarten 1 13 37 1   5     0   1   30 28                       58 1 13 37 1   5     0   1   30 28                 58
736686 736686 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   pre_kindergarten 1 25 23 0   10     1   1   35 26                       61 1 25 23 0   10     1   1   35 26                 61
736687 736687 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_1 2 28 42 0   10     0   1   43 40                       83 2 28 42 0   10     0   1   43 40                 83
736688 736688 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_2 1 17 35 0   4     0   2   36 23                       59 1 17 35 0   4     0   2   36 23                 59
736689 736689 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_3 1 9 26 0   5     0   4   22 23                       45 1 9 26 0   5     0   4   22 23                 45
736690 736690 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_4 2 9 25 0   3     0   1   19 21                       40 2 9 25 0   3     0   1   19 21                 40
736691 736691 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_5 0 10 28 0   1     0   2   26 15                       41 0 10 28 0   1     0   2   26 15                 41
736692 736692 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   kindergarten 6 41 16 0   0     0   2   38 27                       65 6 41 16 0   0     0   2   38 27                 65
736693 736693 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   pre_kindergarten 4 22 21 0   0     0   1   26 22                       48 4 22 21 0   0     0   1   26 22                 48
736694 736694 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_1 6 55 28 0   0     0   5   46 48                       94 6 55 28 0   0     0   5   46 48                 94
736695 736695 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_2 3 52 29 0   0     2   2   40 48                       88 3 52 29 0   0     2   2   40 48                 88
736696 736696 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_3 2 27 21 0   0     0   3   23 30                       53 2 27 21 0   0     0   3   23 30                 53
736697 736697 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_4 1 32 15 0   0     0   2   28 22                       50 1 32 15 0   0     0   2   28 22                 50
736698 736698 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_5 0 24 11 0   0     1   3   21 18                       39 0 24 11 0   0     1   3   21 18                 39
736699 736699 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_6 1 34 16 0   0     0   0   22 29                       51 1 34 16 0   0     0   0   22 29                 51
736700 736700 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   kindergarten 17 7 20 0   4     0   4   23 29                       52 17 7 20 0   4     0   4   23 29                 52
736701 736701 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 10 5 8 0   1     0   2   14 12                       26 10 5 8 0   1     0   2   14 12                 26
736702 736702 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   grade_1 16 11 16 0   3     0   1   29 18                       47 16 11 16 0   3     0   1   29 18                 47
736703 736703 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   grade_2 17 14 21 0   8     0   4   35 29                       64 17 14 21 0   8     0   4   35 29                 64
736704 736704 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   grade_3 6 10 15 0   7     1   4   27 16                       43 6 10 15 0   7     1   4   27 16                 43
736705 736705 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   grade_4 7 12 16 0   4     0   2   21 20                       41 7 12 16 0   4     0   2   21 20                 41
736706 736706 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   grade_5 9 10 18 0   2     0   1   18 22                       40 9 10 18 0   2     0   1   18 22                 40
736707 736707 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   kindergarten 13 8 17 0   10     0   1   26 23                       49 13 8 17 0   10     0   1   26 23                 49
736708 736708 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   pre_kindergarten 5 8 12 0   2     0   0   7 20                       27 5 8 12 0   2     0   0   7 20                 27
736709 736709 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_1 17 19 23 1   10     0   1   38 33                       71 17 19 23 1   10     0   1   38 33                 71
736710 736710 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_2 18 18 50 0   7     0   0   52 41                       93 18 18 50 0   7     0   0   52 41                 93
736711 736711 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_3 13 15 35 0   10     0   2   42 33                       75 13 15 35 0   10     0   2   42 33                 75
736712 736712 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_4 7 28 37 0   12     0   0   50 34                       84 7 28 37 0   12     0   0   50 34                 84
736713 736713 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_5 13 11 44 1   11     0   3   48 35                       83 13 11 44 1   11     0   3   48 35                 83
736714 736714 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_6 21 20 38 1   26     0   3   56 53                       109 21 20 38 1   26     0   3   56 53                 109
736715 736715 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_7 5 24 35 0   6     1   1   41 31                       72 5 24 35 0   6     1   1   41 31                 72
736716 736716 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_8 21 25 55 1   11     0   3   62 54                       116 21 25 55 1   11     0   3   62 54                 116
736717 736717 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   kindergarten 0 45 20 0   1     0   4   41 29                       70 0 45 20 0   1     0   4   41 29                 70
736718 736718 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   pre_kindergarten 2 35 20 0   1     1   2   39 22                       61 2 35 20 0   1     1   2   39 22                 61
736719 736719 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_1 0 44 19 0   0     0   3   36 30                       66 0 44 19 0   0     0   3   36 30                 66
736720 736720 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_2 1 39 20 0   0     0   4   32 32                       64 1 39 20 0   0     0   4   32 32                 64
736721 736721 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_3 0 41 24 0   1     0   4   37 33                       70 0 41 24 0   1     0   4   37 33                 70
736722 736722 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_4 1 34 15 0   0     0   0   28 22                       50 1 34 15 0   0     0   0   28 22                 50
736723 736723 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_5 1 18 8 0   0     0   0   15 12                       27 1 18 8 0   0     0   0   15 12                 27
736724 736724 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_6 1 20 13 0   1     0   5   20 20                       40 1 20 13 0   1     0   5   20 20                 40
736725 736725 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_7 1 14 7 0   0     0   1   12 11                       23 1 14 7 0   0     0   1   12 11                 23
736726 736726 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_8 0 14 8 0   0     1   1   14 10                       24 0 14 8 0   0     1   1   14 10                 24
736727 736727 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   kindergarten 3 42 19 1   2     0   3   34 36                       70 3 42 19 1   2     0   3   34 36                 70
736728 736728 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   pre_kindergarten * * * *   *     *   *   4 1                       5                         4 1                 5
736729 736729 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_1 3 28 14 0   0     1   4   27 23                       50 3 28 14 0   0     1   4   27 23                 50
736730 736730 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_2 0 23 22 0   0     0   3   22 26                       48 0 23 22 0   0     0   3   22 26                 48
736731 736731 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_3 0 44 22 0   0     0   3   36 33                       69 0 44 22 0   0     0   3   36 33                 69
736732 736732 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_4 1 28 18 0   0     0   2   25 24                       49 1 28 18 0   0     0   2   25 24                 49
736733 736733 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_5 0 23 16 0   0     0   3   24 18                       42 0 23 16 0   0     0   3   24 18                 42
736734 736734 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_6 0 15 9 0   2     0   0   13 13                       26 0 15 9 0   2     0   0   13 13                 26
736735 736735 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_7 0 20 7 1   0     0   0   18 10                       28 0 20 7 1   0     0   0   18 10                 28
736736 736736 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_8 1 15 11 0   0     0   2   13 16                       29 1 15 11 0   0     0   2   13 16                 29
736737 736737 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   kindergarten 1 32 7 0   0     0   2   21 21                       42 1 32 7 0   0     0   2   21 21                 42
736738 736738 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_4 0 16 7 1   1     0   0   11 14                       25 0 16 7 1   1     0   0   11 14                 25
736739 736739 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_5 1 24 9 1   1     0   1   19 18                       37 1 24 9 1   1     0   1   19 18                 37
736740 736740 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_6 1 77 26 1   5     0   0   57 53                       110 1 77 26 1   5     0   0   57 53                 110
736741 736741 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_7 2 44 14 0   0     0   2   28 34                       62 2 44 14 0   0     0   2   28 34                 62
736742 736742 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_8 1 76 25 1   2     0   1   68 38                       106 1 76 25 1   2     0   1   68 38                 106
736743 736743 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   kindergarten 0 18 22 0   0     0   3   27 16                       43 0 18 22 0   0     0   3   27 16                 43
736744 736744 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   pre_kindergarten 2 17 16 0   0     0   2   15 22                       37 2 17 16 0   0     0   2   15 22                 37
736745 736745 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_1 1 31 26 0   0     0   0   24 34                       58 1 31 26 0   0     0   0   24 34                 58
736746 736746 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_2 0 31 27 0   0     0   0   31 27                       58 0 31 27 0   0     0   0   31 27                 58
736747 736747 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_3 1 28 28 0   0     0   1   29 29                       58 1 28 28 0   0     0   1   29 29                 58
736748 736748 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_4 0 27 27 0   0     0   0   26 28                       54 0 27 27 0   0     0   0   26 28                 54
736749 736749 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_5 1 20 24 1   0     0   0   26 20                       46 1 20 24 1   0     0   0   26 20                 46
736750 736750 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_6 2 22 27 0   0     0   1   34 18                       52 2 22 27 0   0     0   1   34 18                 52
736751 736751 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_7 0 33 15 0   0     0   0   33 15                       48 0 33 15 0   0     0   0   33 15                 48
736752 736752 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_8 1 25 23 1   2     0   1   24 29                       53 1 25 23 1   2     0   1   24 29                 53
736753 736753 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   kindergarten 11 7 6 0   0     0   2   12 14                       26 11 7 6 0   0     0   2   12 14                 26
736754 736754 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   pre_kindergarten 17 5 8 0   1     1   4   22 14                       36 17 5 8 0   1     1   4   22 14                 36
736755 736755 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_1 11 2 5 0   0     0   2   16 4                       20 11 2 5 0   0     0   2   16 4                 20

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