Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by school_nces_id

View and edit SQL

grade

year

  • 2015 · 9,541
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
744757 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2015   grade_9 195 3 10 0   2     0   7   107 110                       217 195 3 10 0   2     0   7   107 110                 217
744758 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2015   grade_10 161 2 6 0   1     0   5   87 88                       175 161 2 6 0   1     0   5   87 88                 175
744759 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2015   grade_11 164 2 8 0   4     0   3   80 101                       181 164 2 8 0   4     0   3   80 101                 181
744760 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2015   grade_12 165 6 9 1   2     0   5   91 97                       188 165 6 9 1   2     0   5   91 97                 188
744755 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2015   grade_7 188 1 4 0   2     0   5   102 98                       200 188 1 4 0   2     0   5   102 98                 200
744756 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2015   grade_8 189 1 9 0   2     0   4   106 99                       205 189 1 9 0   2     0   4   106 99                 205
744726 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   kindergarten 19 0 0 1   0     0   0   9 11                       20 19 0 0 1   0     0   0   9 11                 20
744727 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_1 31 0 5 0   0     0   0   20 16                       36 31 0 5 0   0     0   0   20 16                 36
744728 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_2 31 1 2 0   0     0   0   19 15                       34 31 1 2 0   0     0   0   19 15                 34
744729 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_3 27 0 2 0   0     0   0   10 19                       29 27 0 2 0   0     0   0   10 19                 29
744730 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_4 28 0 2 0   0     0   0   17 13                       30 28 0 2 0   0     0   0   17 13                 30
744731 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_5 32 0 3 0   0     0   0   23 12                       35 32 0 3 0   0     0   0   23 12                 35
744732 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_6 29 0 0 0   0     0   1   22 8                       30 29 0 0 0   0     0   1   22 8                 30
744733 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   kindergarten 38 0 1 0   0     0   0   15 24                       39 38 0 1 0   0     0   0   15 24                 39
744734 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_1 44 0 1 0   0     0   0   19 26                       45 44 0 1 0   0     0   0   19 26                 45
744735 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_2 38 1 0 0   0     0   1   18 22                       40 38 1 0 0   0     0   1   18 22                 40
744736 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_3 42 0 1 0   0     0   0   24 19                       43 42 0 1 0   0     0   0   24 19                 43
744737 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_4 43 0 1 0   0     0   0   16 28                       44 43 0 1 0   0     0   0   16 28                 44
744738 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_5 39 0 1 0   0     0   0   17 23                       40 39 0 1 0   0     0   0   17 23                 40
744739 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_6 58 0 3 0   0     0   0   27 34                       61 58 0 3 0   0     0   0   27 34                 61
744740 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   kindergarten 33 0 0 0   0     0   0   10 23                       33 33 0 0 0   0     0   0   10 23                 33
744741 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   pre_kindergarten 66 0 7 0   0     0   2   33 42                       75 66 0 7 0   0     0   2   33 42                 75
744742 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   grade_1 21 0 3 0   0     0   0   14 10                       24 21 0 3 0   0     0   0   14 10                 24
744743 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_2 26 0 0 0   0     0   0   11 15                       26 26 0 0 0   0     0   0   11 15                 26
744744 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_3 28 0 0 0   0     0   1   13 16                       29 28 0 0 0   0     0   1   13 16                 29
744745 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_4 35 0 2 0   2     0   1   22 18                       40 35 0 2 0   2     0   1   22 18                 40
744746 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_5 38 0 4 0   1     0   0   22 21                       43 38 0 4 0   1     0   0   22 21                 43
744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
744748 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   kindergarten 63 0 3 0   1     0   3   39 31                       70 63 0 3 0   1     0   3   39 31                 70
744749 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_1 46 0 4 0   1     1   0   31 21                       52 46 0 4 0   1     1   0   31 21                 52
744750 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_2 47 0 3 0   0     0   1   25 26                       51 47 0 3 0   0     0   1   25 26                 51
744751 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_3 65 0 3 0   0     0   1   33 36                       69 65 0 3 0   0     0   1   33 36                 69
744752 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_4 52 0 3 0   0     0   4   26 33                       59 52 0 3 0   0     0   4   26 33                 59
744753 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_5 56 0 4 0   0     0   1   24 37                       61 56 0 4 0   0     0   1   24 37                 61
744754 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_6 54 0 0 0   1     0   1   21 35                       56 54 0 0 0   1     0   1   21 35                 56
744761 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No 3 11 12 2015   grade_11 23 0 0 0   1     0   1   7 18                       25 23 0 0 0   1     0   1   7 18                 25
744762 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No 3 11 12 2015   grade_12 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
744846 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_6 84 1 6 1   0     0   2   42 52                       94 84 1 6 1   0     0   2   42 52                 94
744847 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_7 99 2 13 0   1     0   1   77 39                       116 99 2 13 0   1     0   1   77 39                 116
744848 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_8 118 1 9 0   1     0   6   74 61                       135 118 1 9 0   1     0   6   74 61                 135
744832 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   kindergarten 18 0 2 1   0     0   3   13 11                       24 18 0 2 1   0     0   3   13 11                 24
744833 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_1 27 0 2 0   0     0   0   15 14                       29 27 0 2 0   0     0   0   15 14                 29
744834 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_2 21 0 2 0   0     0   2   14 11                       25 21 0 2 0   0     0   2   14 11                 25
744835 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_3 22 0 4 0   1     0   0   18 9                       27 22 0 4 0   1     0   0   18 9                 27
744836 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_4 28 0 3 0   1     0   1   19 14                       33 28 0 3 0   1     0   1   19 14                 33
744837 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_5 20 0 2 0   0     0   2   12 12                       24 20 0 2 0   0     0   2   12 12                 24
744838 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_6 24 1 3 0   0     0   0   14 14                       28 24 1 3 0   0     0   0   14 14                 28
744849 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   grade_9 86 2 12 0   2     0   3   50 55                       105 86 2 12 0   2     0   3   50 55                 105
744850 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   grade_10 116 0 11 0   0     0   8   75 60                       135 116 0 11 0   0     0   8   75 60                 135
744851 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   grade_11 72 0 6 0   2     0   3   39 44                       83 72 0 6 0   2     0   3   39 44                 83
744852 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   grade_12 82 2 5 0   1     0   4   49 45                       94 82 2 5 0   1     0   4   49 45                 94
744853 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
744842 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_2 95 3 10 0   1     0   4   56 57                       113 95 3 10 0   1     0   4   56 57                 113
744843 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_3 96 2 13 0   1     0   4   75 41                       116 96 2 13 0   1     0   4   75 41                 116
744844 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_4 98 1 7 0   1     0   1   65 43                       108 98 1 7 0   1     0   1   65 43                 108
744845 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_5 76 0 9 0   1     0   4   46 44                       90 76 0 9 0   1     0   4   46 44                 90
744839 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   kindergarten 99 1 8 0   1     0   1   62 48                       110 99 1 8 0   1     0   1   62 48                 110
744840 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   pre_kindergarten 89 0 6 0   0     0   3   48 50                       98 89 0 6 0   0     0   3   48 50                 98
744841 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   grade_1 90 3 10 0   1     0   4   56 52                       108 90 3 10 0   1     0   4   56 52                 108
744823 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_5 100 3 1 0   1     0   1   52 54                       106 100 3 1 0   1     0   1   52 54                 106
744824 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_6 94 1 7 0   0     0   1   57 46                       103 94 1 7 0   0     0   1   57 46                 103
744825 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_7 118 2 2 0   1     0   0   73 50                       123 118 2 2 0   1     0   0   73 50                 123
744826 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_8 106 5 5 0   1     0   1   57 61                       118 106 5 5 0   1     0   1   57 61                 118
744827 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   grade_9 123 1 2 0   2     0   3   65 66                       131 123 1 2 0   2     0   3   65 66                 131
744828 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   grade_10 115 4 3 0   0     0   1   60 63                       123 115 4 3 0   0     0   1   60 63                 123
744829 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   grade_11 144 3 3 0   4     0   2   85 71                       156 144 3 3 0   4     0   2   85 71                 156
744830 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   grade_12 117 4 2 0   0     1   2   60 66                       126 117 4 2 0   0     1   2   60 66                 126
744831 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
744808 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   kindergarten 79 3 8 0   0     0   3   45 48                       93 79 3 8 0   0     0   3   45 48                 93
744809 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 44 0 3 0   0     0   1   24 24                       48 44 0 3 0   0     0   1   24 24                 48
744810 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_1 72 3 11 0   1     0   0   42 45                       87 72 3 11 0   1     0   0   42 45                 87
744811 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_2 92 1 2 0   0     0   3   50 48                       98 92 1 2 0   0     0   3   50 48                 98
744812 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_3 82 2 4 0   1     0   4   47 46                       93 82 2 4 0   1     0   4   47 46                 93
744813 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_4 99 3 3 0   2     0   0   54 53                       107 99 3 3 0   2     0   0   54 53                 107
744814 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   kindergarten 8 0 0 1   0     0   0   8 1                       9 8 0 0 1   0     0   0   8 1                 9
744815 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_1 15 0 0 0   0     0   1   7 9                       16 15 0 0 0   0     0   1   7 9                 16
744816 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_2 14 0 0 0   0     0   0   7 7                       14 14 0 0 0   0     0   0   7 7                 14
744817 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_3 9 0 2 0   0     0   1   6 6                       12 9 0 2 0   0     0   1   6 6                 12
744818 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_4 10 0 0 0   1     0   0   4 7                       11 10 0 0 0   1     0   0   4 7                 11
744819 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_5 13 0 1 0   0     0   0   7 7                       14 13 0 1 0   0     0   0   7 7                 14
744820 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_6 12 0 1 0   0     1   1   7 8                       15 12 0 1 0   0     1   1   7 8                 15
744821 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_7 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
744822 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_8 14 0 1 0   0     0   1   7 9                       16 14 0 1 0   0     0   1   7 9                 16
744134 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   kindergarten 18 0 1 1   0     0   0   13 7                       20 18 0 1 1   0     0   0   13 7                 20
744135 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 13 0 0 0   0     0   0   8 5                       13 13 0 0 0   0     0   0   8 5                 13
744136 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_1 11 0 1 0   0     0   0   2 10                       12 11 0 1 0   0     0   0   2 10                 12
744137 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_2 21 0 0 0   0     0   1   13 9                       22 21 0 0 0   0     0   1   13 9                 22
744138 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_3 18 0 0 0   0     0   0   8 10                       18 18 0 0 0   0     0   0   8 10                 18
744139 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_4 22 0 0 0   0     0   0   13 9                       22 22 0 0 0   0     0   0   13 9                 22
744140 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_5 23 0 0 0   1     0   1   9 16                       25 23 0 0 0   1     0   1   9 16                 25
744141 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
743426 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 4 05 12 2015   grade_5 16 41 19 0   0     0   1   38 39                       77 16 41 19 0   0     0   1   38 39                 77
743427 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 4 05 12 2015   grade_6 4 47 22 0   0     0   1   36 38                       74 4 47 22 0   0     0   1   36 38                 74
743428 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 4 05 12 2015   grade_7 12 48 14 0   1     0   2   38 39                       77 12 48 14 0   1     0   2   38 39                 77
743429 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 4 05 12 2015   grade_8 10 41 20 0   2     0   5   37 41                       78 10 41 20 0   2     0   5   37 41                 78
743430 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 4 05 12 2015   grade_9 6 33 12 0   0     0   1   22 30                       52 6 33 12 0   0     0   1   22 30                 52
743431 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 4 05 12 2015   grade_10 11 32 10 0   0     0   3   21 35                       56 11 32 10 0   0     0   3   21 35                 56
743432 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 4 05 12 2015   grade_11 14 37 4 0   0     0   3   27 31                       58 14 37 4 0   0     0   3   27 31                 58
743433 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 4 05 12 2015   grade_12 9 27 8 0   2     0   1   17 30                       47 9 27 8 0   2     0   1   17 30                 47
743469 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   kindergarten 1 54 12 0   0     0   0   31 36                       67 1 54 12 0   0     0   0   31 36                 67

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