enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
735964 735964 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   kindergarten 83 2 3 2   1     0   3   43 51                       94 83 2 3 2   1     0   3   43 51                 94
735965 735965 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_1 69 18 7 0   3     1   6   46 58                       104 69 18 7 0   3     1   6   46 58                 104
735966 735966 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_2 118 6 5 0   2     0   4   76 59                       135 118 6 5 0   2     0   4   76 59                 135
735967 735967 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_3 103 3 4 0   3     0   4   60 57                       117 103 3 4 0   3     0   4   60 57                 117
735968 735968 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_4 302 22 35 1   4     1   24   184 205                       389 302 22 35 1   4     1   24   184 205                 389
735969 735969 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_5 299 29 29 2   7     0   17   186 197                       383 299 29 29 2   7     0   17   186 197                 383
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
735971 735971 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_7 292 29 38 4   13     1   11   185 203                       388 292 29 38 4   13     1   11   185 203                 388
735972 735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
735974 735974 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_10 269 29 42 6   11     0   12   180 189                       369 269 29 42 6   11     0   12   180 189                 369
735975 735975 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_11 313 28 28 4   13     0   13   189 210                       399 313 28 28 4   13     0   13   189 210                 399
735976 735976 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_12 273 18 20 2   9     2   10   161 173                       334 273 18 20 2   9     2   10   161 173                 334
735977 735977 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   SP 12 0 0 0   0     1   2                             15 12 0 0 0   0     1   2                       15
736964 736964 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   kindergarten 84 4 4 1   1     0   2   63 33                       96 84 4 4 1   1     0   2   63 33                 96
736965 736965 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   pre_kindergarten 46 0 3 1   0     0   1   31 20                       51 46 0 3 1   0     0   1   31 20                 51
736966 736966 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_1 68 0 1 1   1     0   0   36 35                       71 68 0 1 1   1     0   0   36 35                 71
736967 736967 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_2 62 0 3 0   1     0   0   36 30                       66 62 0 3 0   1     0   0   36 30                 66
736968 736968 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_3 66 0 3 1   0     0   2   40 32                       72 66 0 3 1   0     0   2   40 32                 72
736969 736969 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_4 70 0 2 0   2     0   5   37 42                       79 70 0 2 0   2     0   5   37 42                 79
736970 736970 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   kindergarten 36 0 2 0   1     0   1   19 21                       40 36 0 2 0   1     0   1   19 21                 40
736971 736971 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_1 74 1 2 2   2     0   3   42 42                       84 74 1 2 2   2     0   3   42 42                 84
736972 736972 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_2 73 0 3 2   1     0   7   51 35                       86 73 0 3 2   1     0   7   51 35                 86
736973 736973 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_3 78 1 8 0   1     0   0   48 40                       88 78 1 8 0   1     0   0   48 40                 88
736974 736974 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_4 83 1 1 0   4     0   4   42 51                       93 83 1 1 0   4     0   4   42 51                 93
736975 736975 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_5 172 6 2 2   5     0   3   89 101                       190 172 6 2 2   5     0   3   89 101                 190
736976 736976 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_6 156 3 5 1   5     0   12   101 81                       182 156 3 5 1   5     0   12   101 81                 182
736977 736977 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_7 167 3 6 0   4     0   7   92 95                       187 167 3 6 0   4     0   7   92 95                 187
736978 736978 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_8 151 1 5 1   0     0   8   75 91                       166 151 1 5 1   0     0   8   75 91                 166
736979 736979 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_9 98 1 3 0   1     0   6   55 54                       109 98 1 3 0   1     0   6   55 54                 109
736980 736980 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_10 81 0 3 0   3     0   6   48 45                       93 81 0 3 0   3     0   6   48 45                 93
736981 736981 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_11 125 5 8 0   5     1   8   90 62                       152 125 5 8 0   5     1   8   90 62                 152
736982 736982 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_12 93 1 3 0   1     0   10   55 53                       108 93 1 3 0   1     0   10   55 53                 108
737044 737044 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   kindergarten 67 0 7 0   1     0   2   34 43                       77 67 0 7 0   1     0   2   34 43                 77
737045 737045 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 31 1 3 0   0     0   1   24 12                       36 31 1 3 0   0     0   1   24 12                 36
737046 737046 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   grade_1 75 0 3 0   1     0   4   45 38                       83 75 0 3 0   1     0   4   45 38                 83
737047 737047 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   grade_2 66 0 2 0   1     0   2   38 33                       71 66 0 2 0   1     0   2   38 33                 71
737048 737048 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2015   grade_3 66 2 7 0   2     0   1   36 42                       78 66 2 7 0   2     0   1   36 42                 78
737049 737049 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2015   grade_4 65 4 2 0   1     0   2   36 38                       74 65 4 2 0   1     0   2   36 38                 74
737050 737050 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2015   grade_5 54 5 2 0   1     0   0   37 25                       62 54 5 2 0   1     0   0   37 25                 62
737859 737859 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   kindergarten 22 2 1 1   0     0   2   11 17                       28 22 2 1 1   0     0   2   11 17                 28
737860 737860 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 7 1 0 0   0     0   0   3 5                       8 7 1 0 0   0     0   0   3 5                 8
737861 737861 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_1 20 1 0 0   1     0   1   12 11                       23 20 1 0 0   1     0   1   12 11                 23
737862 737862 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_2 36 2 0 1   0     0   0   17 22                       39 36 2 0 1   0     0   0   17 22                 39
737863 737863 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_3 20 2 0 0   1     0   0   13 10                       23 20 2 0 0   1     0   0   13 10                 23
737864 737864 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_4 23 0 0 0   1     0   0   9 15                       24 23 0 0 0   1     0   0   9 15                 24
737865 737865 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_5 34 0 0 1   1     0   1   22 15                       37 34 0 0 1   1     0   1   22 15                 37
738127 738127 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   kindergarten 40 6 1 1   1     0   2   21 30                       51 40 6 1 1   1     0   2   21 30                 51
738128 738128 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 72 4 4 2   1     0   7   50 40                       90 72 4 4 2   1     0   7   50 40                 90
738129 738129 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_1 52 2 1 1   1     0   6   37 26                       63 52 2 1 1   1     0   6   37 26                 63
738130 738130 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_2 33 7 0 1   1     0   1   24 19                       43 33 7 0 1   1     0   1   24 19                 43
738131 738131 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_3 43 2 0 1   0     0   1   27 20                       47 43 2 0 1   0     0   1   27 20                 47
738132 738132 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_4 41 6 2 0   1     0   1   23 28                       51 41 6 2 0   1     0   1   23 28                 51
738133 738133 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   kindergarten 57 2 1 0   1     0   2   38 25                       63 57 2 1 0   1     0   2   38 25                 63
738134 738134 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   pre_kindergarten 8 1 1 0   0     0   2   9 3                       12 8 1 1 0   0     0   2   9 3                 12
738135 738135 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_1 35 2 1 5   1     0   4   26 22                       48 35 2 1 5   1     0   4   26 22                 48
738136 738136 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_2 43 1 3 0   4     0   5   28 28                       56 43 1 3 0   4     0   5   28 28                 56
738137 738137 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_3 51 3 6 1   0     0   4   36 29                       65 51 3 6 1   0     0   4   36 29                 65
738138 738138 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_4 55 5 5 1   0     0   3   29 40                       69 55 5 5 1   0     0   3   29 40                 69
738139 738139 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   kindergarten 77 6 8 1   2     0   3   53 44                       97 77 6 8 1   2     0   3   53 44                 97
738140 738140 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_1 76 0 7 3   4     0   4   45 49                       94 76 0 7 3   4     0   4   45 49                 94
738141 738141 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_2 81 4 7 0   3     0   7   52 50                       102 81 4 7 0   3     0   7   52 50                 102
738142 738142 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_3 65 8 11 0   4     0   6   42 52                       94 65 8 11 0   4     0   6   42 52                 94
738143 738143 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_4 101 4 3 0   0     0   5   58 55                       113 101 4 3 0   0     0   5   58 55                 113
738144 738144 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   kindergarten 65 0 7 0   2     0   4   42 36                       78 65 0 7 0   2     0   4   42 36                 78
738145 738145 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_1 62 0 6 1   0     0   4   39 34                       73 62 0 6 1   0     0   4   39 34                 73
738146 738146 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_2 60 1 4 0   1     0   3   36 33                       69 60 1 4 0   1     0   3   36 33                 69
738147 738147 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_3 55 4 3 1   0     0   5   31 37                       68 55 4 3 1   0     0   5   31 37                 68
738148 738148 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_4 70 0 7 0   3     1   4   43 42                       85 70 0 7 0   3     1   4   43 42                 85
738149 738149 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_5 236 8 14 3   6     0   18   156 129                       285 236 8 14 3   6     0   18   156 129                 285
738150 738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
738151 738151 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_7 247 14 9 1   7     0   18   152 144                       296 247 14 9 1   7     0   18   152 144                 296
738152 738152 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_8 228 15 8 3   9     0   12   133 142                       275 228 15 8 3   9     0   12   133 142                 275
738153 738153 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_9 186 8 10 1   6     1   18   114 116                       230 186 8 10 1   6     1   18   114 116                 230
738154 738154 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_10 210 13 5 3   6     0   7   138 106                       244 210 13 5 3   6     0   7   138 106                 244
738155 738155 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_11 159 8 4 5   9     1   5   95 96                       191 159 8 4 5   9     1   5   95 96                 191
738156 738156 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_12 166 10 7 4   11     0   3   101 100                       201 166 10 7 4   11     0   3   101 100                 201
738157 738157 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
739721 739721 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   kindergarten 74 2 11 9   1     0   9   52 54                       106 74 2 11 9   1     0   9   52 54                 106
739722 739722 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   pre_kindergarten 68 4 6 5   3     0   6   51 41                       92 68 4 6 5   3     0   6   51 41                 92
739723 739723 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_1 98 3 5 8   1     0   7   62 60                       122 98 3 5 8   1     0   7   62 60                 122
739724 739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
739725 739725 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_7 101 6 4 5   5     0   6   66 61                       127 101 6 4 5   5     0   6   66 61                 127
739726 739726 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_8 111 6 5 10   3     0   6   76 65                       141 111 6 5 10   3     0   6   76 65                 141
739727 739727 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_3 86 4 5 6   3     0   5   69 40                       109 86 4 5 6   3     0   5   69 40                 109
739728 739728 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_4 107 4 3 12   6     0   4   58 78                       136 107 4 3 12   6     0   4   58 78                 136
739729 739729 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_5 109 5 4 7   3     1   2   74 57                       131 109 5 4 7   3     1   2   74 57                 131

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