enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2040095 2040095 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_8 35 19 7 0   1     0   4   28 38                       66.0 35 19 7 0   1     0   4   28 38                 66
2040096 2040096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_9 22 24 3 0   3     0   4   33 23                       56.0 22 24 3 0   3     0   4   33 23                 56
2040097 2040097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_10 16 21 3 0   1     0   1   28 14                       42.0 16 21 3 0   1     0   1   28 14                 42
2040098 2040098 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_11 19 17 3 0   4     0   4   21 26                       47.0 19 17 3 0   4     0   4   21 26                 47
2040099 2040099 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_12 20 24 3 0   3     0   1   27 24                       51.0 20 24 3 0   3     0   1   27 24                 51
2040100 2040100 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2229096 2229096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_7 34 18 7 0   1     0   5   29 36                       65.0 34 18 7 0   1     0   5   29 36                 65
2229097 2229097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_8 38 13 3 0   3     0   2   36 23                       59.0 38 13 3 0   3     0   2   36 23                 59
2229098 2229098 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_9 19 16 1 0   2     0   1   29 10                       39.0 19 16 1 0   2     0   1   29 10                 39
2229099 2229099 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_10 22 21 3 0   4     0   3   23 29                       53.0 22 21 3 0   4     0   3   23 29                 53
2229100 2229100 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_11 24 23 4 0   2     0   1   28 26                       54.0 24 23 4 0   2     0   1   28 26                 54
2229101 2229101 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_12 15 18 3 0   2     0   1   15 23                       39.0 15 18 3 0   2     0   1   15 23                 39
2229102 2229102 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
932825 932825 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No 1 PK PK 2016   pre_kindergarten 77 7 11 0   1     0   6   68 34                       102 77 7 11 0   1     0   6   68 34                 102
1122297 1122297 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 92 7 14 0   3     0   10   69 57                       126 92 7 14 0   3     0   10   69 57                 126
1122298 1122298 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1365071 1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1672295 1672295 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable - Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 75 7 18 0   6     0   18   85 39 *                     124.0 75 7 18 0   6     0   18   85 39                 124
2040101 2040101 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 78 15 30 1   1     0   21   88 58                       146.0 78 15 30 1   1     0   21   88 58                 146
2229103 2229103 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 85 11 26 2   1     0   10   75 60                       135.0 85 11 26 2   1     0   10   75 60                 135
2229104 2229104 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
735951 735951 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   kindergarten 49 4 3 0   0     0   3   34 25                       59 49 4 3 0   0     0   3   34 25                 59
735952 735952 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_1 58 2 5 0   1     0   2   36 32                       68 58 2 5 0   1     0   2   36 32                 68
735953 735953 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_2 54 1 6 0   2     0   3   32 34                       66 54 1 6 0   2     0   3   32 34                 66
735954 735954 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_3 67 1 3 0   1     0   2   40 34                       74 67 1 3 0   1     0   2   40 34                 74
932826 932826 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   kindergarten 52 0 2 0   1     0   0   30 25                       55 52 0 2 0   1     0   0   30 25                 55
932827 932827 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   grade_1 56 1 3 0   0     0   4   32 32                       64 56 1 3 0   0     0   4   32 32                 64
932828 932828 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   grade_2 56 3 9 0   2     0   1   38 33                       71 56 3 9 0   2     0   1   38 33                 71
932829 932829 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   grade_3 53 1 7 0   2     0   2   31 34                       65 53 1 7 0   2     0   2   31 34                 65
1122299 1122299 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   kindergarten 48 5 5 0   2     0   1   33 28                       61 48 5 5 0   2     0   1   33 28                 61
1122300 1122300 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_1 57 2 3 0   1     0   2   40 25                       65 57 2 3 0   1     0   2   40 25                 65
1122301 1122301 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_2 55 5 2 0   0     0   5   37 30                       67 55 5 2 0   0     0   5   37 30                 67
1122302 1122302 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_3 57 0 7 0   2     0   1   37 30                       67 57 0 7 0   2     0   1   37 30                 67
1122303 1122303 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1365072 1365072 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   kindergarten 41 2 11 0   0     0   4   34 24 *                     58.0 41 2 11 0   0     0   4   34 24                 58
1365073 1365073 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_1 45 1 4 0   3     0   9   31 31 *                     62.0 45 1 4 0   3     0   9   31 31                 62
1365074 1365074 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_2 47 2 6 0   0     0   7   36 26 *                     62.0 47 2 6 0   0     0   7   36 26                 62
1365075 1365075 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_3 49 2 6 0   2     0   4   36 27 *                     63.0 49 2 6 0   2     0   4   36 27                 63
1672296 1672296 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   kindergarten 32 2 12 0   1     0   5   31 21 *                     52.0 32 2 12 0   1     0   5   31 21                 52
1672297 1672297 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_1 45 2 11 0   0     0   5   34 29 *                     63.0 45 2 11 0   0     0   5   34 29                 63
1672298 1672298 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_2 35 1 4 0   2     0   8   22 28 *                     50.0 35 1 4 0   2     0   8   22 28                 50
1672299 1672299 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_3 42 2 6 0   0     0   6   32 24 *                     56.0 42 2 6 0   0     0   6   32 24                 56
2040102 2040102 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   kindergarten 40 3 3 0   3     0   8   33 24                       57.0 40 3 3 0   3     0   8   33 24                 57
2040103 2040103 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_1 51 3 6 0   0     0   7   39 28                       67.0 51 3 6 0   0     0   7   39 28                 67
2040104 2040104 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_2 48 3 6 0   3     0   4   36 28                       64.0 48 3 6 0   3     0   4   36 28                 64
2040105 2040105 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_3 57 4 6 0   1     0   2   42 28                       70.0 57 4 6 0   1     0   2   42 28                 70
2229105 2229105 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   kindergarten 51 3 4 0   0     0   4   34 28                       62.0 51 3 4 0   0     0   4   34 28                 62
2229106 2229106 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_1 49 4 6 0   1     0   3   33 30                       63.0 49 4 6 0   1     0   3   33 30                 63
2229107 2229107 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_2 57 2 5 0   1     0   1   41 25                       66.0 57 2 5 0   1     0   1   41 25                 66
2229108 2229108 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_3 57 4 4 0   0     0   4   36 33                       69.0 57 4 4 0   0     0   4   36 33                 69
2229109 2229109 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
735955 735955 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   kindergarten 69 7 8 0   0     0   1   42 43                       85 69 7 8 0   0     0   1   42 43                 85
735956 735956 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 59 16 10 1   2     0   5   65 28                       93 59 16 10 1   2     0   5   65 28                 93
735957 735957 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_1 74 2 9 1   2     0   0   50 38                       88 74 2 9 1   2     0   0   50 38                 88
735958 735958 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_2 72 2 9 0   0     0   5   44 44                       88 72 2 9 0   0     0   5   44 44                 88
735959 735959 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_3 55 7 6 0   2     0   3   39 34                       73 55 7 6 0   2     0   3   39 34                 73
932830 932830 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   kindergarten 54 8 9 1   0     0   1   43 30                       73 54 8 9 1   0     0   1   43 30                 73
932831 932831 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   grade_1 68 5 9 1   1     0   1   45 40                       85 68 5 9 1   1     0   1   45 40                 85
932832 932832 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   grade_2 70 1 8 1   2     0   0   46 36                       82 70 1 8 1   2     0   0   46 36                 82
932833 932833 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   grade_3 73 3 8 0   1     0   4   46 43                       89 73 3 8 0   1     0   4   46 43                 89
1122304 1122304 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   kindergarten 44 3 4 0   1     0   4   32 24                       56 44 3 4 0   1     0   4   32 24                 56
1122305 1122305 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_1 55 5 6 0   0     0   3   37 32                       69 55 5 6 0   0     0   3   37 32                 69
1122306 1122306 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_2 64 5 8 0   1     0   1   39 40                       79 64 5 8 0   1     0   1   39 40                 79
1122307 1122307 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_3 78 1 7 1   2     0   0   50 39                       89 78 1 7 1   2     0   0   50 39                 89
1122308 1122308 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1365076 1365076 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   kindergarten 32 4 11 0   0     0   8   25 30 *                     55.0 32 4 11 0   0     0   8   25 30                 55
1365077 1365077 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_1 47 5 15 0   0     0   4   42 29 *                     71.0 47 5 15 0   0     0   4   42 29                 71
1365078 1365078 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_2 42 4 6 0   1     0   7   34 26 *                     60.0 42 4 6 0   1     0   7   34 26                 60
1365079 1365079 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_3 36 4 12 0   2     0   3   30 27 *                     57.0 36 4 12 0   2     0   3   30 27                 57
1672300 1672300 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   kindergarten 32 4 8 0   0     0   11   31 24 *                     55.0 32 4 8 0   0     0   11   31 24                 55
1672301 1672301 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_1 34 4 11 0   0     0   8   31 26 *                     57.0 34 4 11 0   0     0   8   31 26                 57
1672302 1672302 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_2 43 5 12 0   0     0   4   38 26 *                     64.0 43 5 12 0   0     0   4   38 26                 64
1672303 1672303 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_3 43 6 5 0   1     0   6   34 27 *                     61.0 43 6 5 0   1     0   6   34 27                 61
2040106 2040106 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   kindergarten 42 6 13 0   0     0   3   38 26                       64.0 42 6 13 0   0     0   3   38 26                 64
2040107 2040107 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_1 45 4 7 0   1     0   6   34 29                       63.0 45 4 7 0   1     0   6   34 29                 63
2040108 2040108 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_2 35 5 7 0   2     0   3   29 23                       52.0 35 5 7 0   2     0   3   29 23                 52
2040109 2040109 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_3 61 4 5 0   0     0   2   37 35                       72.0 61 4 5 0   0     0   2   37 35                 72
2229110 2229110 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   kindergarten 50 4 2 0   1     0   8   34 31                       65.0 50 4 2 0   1     0   8   34 31                 65
2229111 2229111 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_1 36 3 4 0   2     0   3   28 20                       48.0 36 3 4 0   2     0   3   28 20                 48
2229112 2229112 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_2 59 2 5 0   0     0   2   36 32                       68.0 59 2 5 0   0     0   2   36 32                 68
2229113 2229113 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_3 60 5 10 0   1     0   2   39 39                       78.0 60 5 10 0   1     0   2   39 39                 78
2229114 2229114 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1365080 1365080 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   kindergarten 23 10 22 3   4     0   4   40 26 *                     66.0 23 10 22 3   4     0   4   40 26                 66
1365081 1365081 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_1 36 6 25 0   5     0   5   40 37 *                     77.0 36 6 25 0   5     0   5   40 37                 77
1365082 1365082 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_2 44 11 25 1   1     0   2   42 42 *                     84.0 44 11 25 1   1     0   2   42 42                 84
1365083 1365083 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_3 39 6 17 0   2     0   1   33 32 *                     65.0 39 6 17 0   2     0   1   33 32                 65
1672304 1672304 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   kindergarten 22 9 27 0   1     0   6   38 27 *                     65.0 22 9 27 0   1     0   6   38 27                 65
1672305 1672305 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_1 25 9 24 3   4     0   3   38 30 *                     68.0 25 9 24 3   4     0   3   38 30                 68
1672306 1672306 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_2 36 7 24 0   5     0   6   38 39 *                     78.0 36 7 24 0   5     0   6   38 39                 78
1672307 1672307 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_3 37 15 24 1   1     0   3   39 42 *                     81.0 37 15 24 1   1     0   3   39 42                 81
735960 735960 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   kindergarten 32 11 19 1   3     0   15   46 35                       81 32 11 19 1   3     0   15   46 35                 81
735961 735961 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_1 43 13 20 0   6     1   9   57 35                       92 43 13 20 0   6     1   9   57 35                 92
735962 735962 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_2 54 17 14 1   1     1   6   42 52                       94 54 17 14 1   1     1   6   42 52                 94
735963 735963 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_3 35 16 26 0   2     0   9   56 32                       88 35 16 26 0   2     0   9   56 32                 88
932834 932834 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   kindergarten 24 11 24 0   2     0   3   30 34                       64 24 11 24 0   2     0   3   30 34                 64
932835 932835 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   grade_1 34 16 23 0   3     0   10   49 37                       86 34 16 23 0   3     0   10   49 37                 86
932836 932836 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   grade_2 43 10 20 0   2     1   9   52 33                       85 43 10 20 0   2     1   9   52 33                 85
932837 932837 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   grade_3 56 14 16 0   1     1   8   42 54                       96 56 14 16 0   1     1   8   42 54                 96
1122309 1122309 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   kindergarten 38 17 20 0   2     0   9   40 46                       86 38 17 20 0   2     0   9   40 46                 86
1122310 1122310 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   grade_1 32 18 32 1   2     0   4   50 39                       89 32 18 32 1   2     0   4   50 39                 89

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);