Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 11,248
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
1132629 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   kindergarten 44 1 0 0   1     0   0   24 22                       46 44 1 0 0   1     0   0   24 22                 46
1132630 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_1 38 0 1 0   0     0   0   20 19                       39 38 0 1 0   0     0   0   20 19                 39
1132631 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_2 44 0 1 0   0     0   0   18 27                       45 44 0 1 0   0     0   0   18 27                 45
1132632 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_3 49 0 1 0   0     0   0   21 29                       50 49 0 1 0   0     0   0   21 29                 50
1132633 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_4 39 1 0 0   1     0   1   19 23                       42 39 1 0 0   1     0   1   19 23                 42
1132634 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_5 45 0 1 0   0     0   0   27 19                       46 45 0 1 0   0     0   0   27 19                 46
1132635 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_6 47 0 1 0   0     0   0   15 33                       48 47 0 1 0   0     0   0   15 33                 48
1132636 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132637 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   kindergarten 19 0 0 0   0     0   0   8 11                       19 19 0 0 0   0     0   0   8 11                 19
1132638 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   pre_kindergarten 58 0 6 0   0     0   1   38 27                       65 58 0 6 0   0     0   1   38 27                 65
1132639 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   grade_1 21 0 2 0   0     0   1   10 14                       24 21 0 2 0   0     0   1   10 14                 24
1132640 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132641 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_2 28 0 0 0   0     0   0   8 20                       28 28 0 0 0   0     0   0   8 20                 28
1132642 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_3 23 0 3 0   0     0   0   14 12                       26 23 0 3 0   0     0   0   14 12                 26
1132643 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_4 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29
1132644 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_5 28 0 0 0   0     0   1   12 17                       29 28 0 0 0   0     0   1   12 17                 29
1132645 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_6 34 0 1 0   1     0   1   22 15                       37 34 0 1 0   1     0   1   22 15                 37
1132646 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132647 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   kindergarten 37 0 2 0   0     0   0   20 19                       39 37 0 2 0   0     0   0   20 19                 39
1132648 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_1 47 0 3 0   2     0   2   27 27                       54 47 0 3 0   2     0   2   27 27                 54
1132649 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_2 52 0 3 0   1     0   2   30 28                       58 52 0 3 0   1     0   2   30 28                 58
1132650 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_3 51 0 4 0   1     1   0   34 23                       57 51 0 4 0   1     1   0   34 23                 57
1132651 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_4 39 0 3 0   0     0   1   21 22                       43 39 0 3 0   0     0   1   21 22                 43
1132652 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_5 57 0 2 0   1     0   1   30 31                       61 57 0 2 0   1     0   1   30 31                 61
1132653 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_6 50 0 2 0   0     0   4   25 31                       56 50 0 2 0   0     0   4   25 31                 56
1132654 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132663 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   grade_11 6 1 0 0   0     0   0   * 5                       7 6 1 0 0   0     0   0     5                 7
1132664 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   grade_12 5 1 0 0   0     0   0   * 4                       6 5 1 0 0   0     0   0     4                 6
1132665 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132759 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_5 90 2 13 0   0     0   7   67 45                       112 90 2 13 0   0     0   7   67 45                 112
1132760 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_6 87 1 9 0   1     0   0   57 41                       98 87 1 9 0   1     0   0   57 41                 98
1132761 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_7 82 0 10 0   1     0   4   52 45                       97 82 0 10 0   1     0   4   52 45                 97
1132762 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_8 94 1 8 1   0     0   3   51 56                       107 94 1 8 1   0     0   3   51 56                 107
1132763 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132744 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1132745 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 40 1 3 0   0     0   2   24 22                       46 40 1 3 0   0     0   2   24 22                 46
1132746 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 24 0 2 0   0     0   1   15 12                       27 24 0 2 0   0     0   1   15 12                 27
1132747 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 16 0 1 1   0     0   2   10 10                       20 16 0 1 1   0     0   2   10 10                 20
1132748 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_3 29 1 1 0   0     0   1   16 16                       32 29 1 1 0   0     0   1   16 16                 32
1132749 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 2 0   0     0   2   12 11                       23 19 0 2 0   0     0   2   12 11                 23
1132750 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 17 0 1 0   0     0   0   11 7                       18 17 0 1 0   0     0   0   11 7                 18
1132751 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 25 0 3 0   1     0   2   18 13                       31 25 0 3 0   1     0   2   18 13                 31
1132752 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132764 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_9 58 1 9 0   2     0   2   47 25                       72 58 1 9 0   2     0   2   47 25                 72
1132765 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_10 80 1 5 0   0     0   4   48 42                       90 80 1 5 0   0     0   4   48 42                 90
1132766 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_11 55 2 7 0   2     0   6   31 41                       72 55 2 7 0   2     0   6   31 41                 72
1132767 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_12 90 0 7 0   0     0   5   57 45                       102 90 0 7 0   0     0   5   57 45                 102
1132768 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132753 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   kindergarten 49 1 7 0   0     0   3   34 26                       60 49 1 7 0   0     0   3   34 26                 60
1132754 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_1 63 0 8 0   0     0   3   30 44                       74 63 0 8 0   0     0   3   30 44                 74
1132755 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_2 89 1 8 0   1     0   2   52 49                       101 89 1 8 0   1     0   2   52 49                 101
1132756 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_3 81 0 10 0   2     0   3   46 50                       96 81 0 10 0   2     0   3   46 50                 96
1132757 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_4 85 2 5 0   3     0   4   50 49                       99 85 2 5 0   3     0   4   50 49                 99
1132758 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132737 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_7 119 3 3 0   0     0   1   62 64                       126 119 3 3 0   0     0   1   62 64                 126
1132738 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_8 109 2 9 0   1     0   1   63 59                       122 109 2 9 0   1     0   1   63 59                 122
1132739 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_9 109 1 2 0   1     0   1   63 51                       114 109 1 2 0   1     0   1   63 51                 114
1132740 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_10 113 3 8 0   0     0   1   61 64                       125 113 3 8 0   0     0   1   61 64                 125
1132741 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_11 119 1 4 0   1     0   3   68 60                       128 119 1 4 0   1     0   3   68 60                 128
1132742 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_12 113 4 2 0   0     0   1   55 65                       120 113 4 2 0   0     0   1   55 65                 120
1132743 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132720 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   kindergarten 72 2 7 0   1     0   3   45 40                       85 72 2 7 0   1     0   3   45 40                 85
1132721 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   pre_kindergarten 52 0 9 0   0     0   1   34 28                       62 52 0 9 0   0     0   1   34 28                 62
1132722 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_1 88 2 4 0   0     0   0   51 43                       94 88 2 4 0   0     0   0   51 43                 94
1132723 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_2 85 1 6 0   1     0   4   47 50                       97 85 1 6 0   1     0   4   47 50                 97
1132724 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132732 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_3 76 3 11 0   1     0   0   42 49                       91 76 3 11 0   1     0   0   42 49                 91
1132733 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_4 95 1 3 0   1     0   3   50 53                       103 95 1 3 0   1     0   3   50 53                 103
1132734 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_5 87 2 6 0   1     0   3   50 49                       99 87 2 6 0   1     0   3   50 49                 99
1132735 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_6 90 3 3 0   2     0   1   49 50                       99 90 3 3 0   2     0   1   49 50                 99
1132736 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132725 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   kindergarten 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1132726 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_1 13 0 0 0   0     0   1   8 6                       14 13 0 0 0   0     0   1   8 6                 14
1132727 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_3 18 0 0 0   0     0   2   9 11                       20 18 0 0 0   0     0   2   9 11                 20
1132728 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_4 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1132729 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_5 9 0 1 0   0     0   1   4 7                       11 9 0 1 0   0     0   1   4 7                 11
1132730 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_6 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
1132731 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131934 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   kindergarten 21 0 0 1   0     0   0   11 11                       22 21 0 0 1   0     0   0   11 11                 22
1131935 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 13 1 1 0   0     0   0   8 7                       15 13 1 1 0   0     0   0   8 7                 15
1131936 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_1 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1131937 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_2 17 0 1 1   0     0   0   11 8                       19 17 0 1 1   0     0   0   11 8                 19
1131938 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 0 0   0     0   0   13 6                       19 19 0 0 0   0     0   0   13 6                 19
1131939 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_5 19 0 0 0   0     0   0   6 13                       19 19 0 0 0   0     0   0   6 13                 19
1131940 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
1131941 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131125 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1131126 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_6 5 40 26 0   0     0   6   39 38                       77 5 40 26 0   0     0   6   39 38                 77
1131127 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_7 13 47 20 0   1     0   0   37 44                       81 13 47 20 0   1     0   0   37 44                 81
1131128 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1131129 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_9 5 45 11 0   1     0   2   35 29                       64 5 45 11 0   1     0   2   35 29                 64
1131130 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_10 6 29 14 0   1     1   4   29 26                       55 6 29 14 0   1     1   4   29 26                 55
1131131 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_11 5 26 11 0   0     0   1   17 26                       43 5 26 11 0   0     0   1   17 26                 43
1131132 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_12 12 25 10 0   0     0   2   18 31                       49 12 25 10 0   0     0   2   18 31                 49
1131133 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131173 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   kindergarten 2 40 4 1   0     0   1   23 25                       48 2 40 4 1   0     0   1   23 25                 48
1131174 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   pre_kindergarten 1 18 1 0   1     0   2   13 10                       23 1 18 1 0   1     0   2   13 10                 23
1131175 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_1 2 36 5 0   3     0   0   28 18                       46 2 36 5 0   3     0   0   28 18                 46
1131176 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_2 0 38 8 1   0     0   0   24 23                       47 0 38 8 1   0     0   0   24 23                 47
1131177 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_3 0 38 9 0   1     0   0   25 23                       48 0 38 9 0   1     0   0   25 23                 48

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