enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 9,499 ✖
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
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
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
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
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
932838 932838 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   kindergarten 96 2 3 0   1     0   4   59 47                       106 96 2 3 0   1     0   4   59 47                 106
932839 932839 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   grade_1 102 4 4 1   0     0   3   51 63                       114 102 4 4 1   0     0   3   51 63                 114
932840 932840 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   grade_2 91 2 8 1   2     1   6   49 62                       111 91 2 8 1   2     1   6   49 62                 111
932841 932841 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   grade_3 113 0 5 0   2     0   4   69 55                       124 113 0 5 0   2     0   4   69 55                 124
932842 932842 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_4 307 27 52 0   9     0   18   227 186                       413 307 27 52 0   9     0   18   227 186                 413
932843 932843 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_5 279 22 34 2   5     1   24   176 191                       367 279 22 34 2   5     1   24   176 191                 367
932844 932844 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_6 290 34 27 2   8     0   16   190 187                       377 290 34 27 2   8     0   16   190 187                 377
932845 932845 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_7 264 27 42 1   3     2   13   203 149                       352 264 27 42 1   3     2   13   203 149                 352
932846 932846 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_8 297 36 44 4   12     1   12   199 207                       406 297 36 44 4   12     1   12   199 207                 406
932847 932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
932848 932848 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_10 275 28 40 6   16     2   14   187 194                       381 275 28 40 6   16     2   14   187 194                 381
932849 932849 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_11 280 34 43 5   11     0   14   185 202                       387 280 34 43 5   11     0   14   185 202                 387
932850 932850 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_12 278 22 27 6   15     0   12   171 189                       360 278 22 27 6   15     0   12   171 189                 360
932851 932851 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   sped_beyond_grade_12 11 0 0 1   0     1   2   10 5                       15 11 0 0 1   0     1   2   10 5                 15
933829 933829 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   kindergarten 67 2 7 1   1     2   6   48 38                       86 67 2 7 1   1     2   6   48 38                 86
933830 933830 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   pre_kindergarten 52 1 0 0   0     0   0   31 22                       53 52 1 0 0   0     0   0   31 22                 53
933831 933831 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_1 72 2 7 1   0     0   2   52 32                       84 72 2 7 1   0     0   2   52 32                 84
933832 933832 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_2 65 0 0 1   1     0   0   33 34                       67 65 0 0 1   1     0   0   33 34                 67
933833 933833 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_3 63 0 3 0   1     0   0   36 31                       67 63 0 3 0   1     0   0   36 31                 67
933834 933834 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_4 65 0 3 1   0     0   2   40 31                       71 65 0 3 1   0     0   2   40 31                 71
933835 933835 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   kindergarten 34 2 1 0   0     0   2   21 18                       39 34 2 1 0   0     0   2   21 18                 39
933836 933836 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_1 55 1 1 1   2     0   1   28 33                       61 55 1 1 1   2     0   1   28 33                 61
933837 933837 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_2 59 2 1 3   2     0   5   34 38                       72 59 2 1 3   2     0   5   34 38                 72
933838 933838 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_3 68 0 2 1   1     0   5   48 29                       77 68 0 2 1   1     0   5   48 29                 77
933839 933839 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_4 74 1 5 0   1     0   0   41 40                       81 74 1 5 0   1     0   0   41 40                 81
933840 933840 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_5 148 0 2 0   6     0   8   71 93                       164 148 0 2 0   6     0   8   71 93                 164
933841 933841 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_6 172 4 1 2   6     0   2   90 97                       187 172 4 1 2   6     0   2   90 97                 187
933842 933842 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_7 155 3 5 1   6     0   12   103 79                       182 155 3 5 1   6     0   12   103 79                 182
933843 933843 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_8 166 3 4 0   5     0   7   90 95                       185 166 3 4 0   5     0   7   90 95                 185
933844 933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
933845 933845 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_10 92 1 4 0   2     0   3   48 54                       102 92 1 4 0   2     0   3   48 54                 102
933846 933846 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_11 84 0 3 0   3     0   5   52 43                       95 84 0 3 0   3     0   5   52 43                 95
933847 933847 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_12 119 2 8 0   4     1   6   76 64                       140 119 2 8 0   4     1   6   76 64                 140
933911 933911 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   kindergarten 57 2 4 0   0     0   5   36 32                       68 57 2 4 0   0     0   5   36 32                 68
933912 933912 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   pre_kindergarten 35 1 3 0   0     0   0   26 13                       39 35 1 3 0   0     0   0   26 13                 39
933913 933913 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   grade_1 66 2 7 0   1     0   2   35 43                       78 66 2 7 0   1     0   2   35 43                 78
933914 933914 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   grade_2 72 0 4 0   1     0   5   44 38                       82 72 0 4 0   1     0   5   44 38                 82
933915 933915 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2016   grade_3 68 1 2 0   1     0   1   36 37                       73 68 1 2 0   1     0   1   36 37                 73
933916 933916 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2016   grade_4 67 3 6 0   0     0   1   36 41                       77 67 3 6 0   0     0   1   36 41                 77
933917 933917 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No 1 03 05 2016   grade_5 65 3 1 0   2     0   2   37 36                       73 65 3 1 0   2     0   2   37 36                 73
934713 934713 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   kindergarten 25 2 3 0   0     0   0   13 17                       30 25 2 3 0   0     0   0   13 17                 30
934714 934714 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 8 1 1 0   0     0   0   8 2                       10 8 1 1 0   0     0   0   8 2                 10
934715 934715 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_1 23 0 1 1   0     0   1   10 16                       26 23 0 1 1   0     0   1   10 16                 26
934716 934716 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_2 20 1 0 0   1     0   1   13 10                       23 20 1 0 0   1     0   1   13 10                 23
934717 934717 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_3 36 2 0 1   0     0   0   18 21                       39 36 2 0 1   0     0   0   18 21                 39
934718 934718 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_4 22 1 0 0   1     0   0   13 11                       24 22 1 0 0   1     0   0   13 11                 24
934719 934719 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_5 24 0 0 0   1     0   0   11 14                       25 24 0 0 0   1     0   0   11 14                 25
934981 934981 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   kindergarten 36 2 4 0   1     0   7   30 20                       50 36 2 4 0   1     0   7   30 20                 50
934982 934982 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   pre_kindergarten 72 3 3 1   1     0   5   44 41                       85 72 3 3 1   1     0   5   44 41                 85
934983 934983 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_1 41 6 2 1   1     0   1   21 31                       52 41 6 2 1   1     0   1   21 31                 52
934984 934984 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_2 54 1 1 2   0     0   5   38 25                       63 54 1 1 2   0     0   5   38 25                 63
934985 934985 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_3 38 7 0 1   1     0   2   27 22                       49 38 7 0 1   1     0   2   27 22                 49
934986 934986 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_4 43 4 0 1   0     0   1   26 23                       49 43 4 0 1   0     0   1   26 23                 49
934987 934987 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   kindergarten 48 7 6 0   1     0   3   27 38                       65 48 7 6 0   1     0   3   27 38                 65
934988 934988 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   pre_kindergarten 10 0 2 0   0     0   2   11 3                       14 10 0 2 0   0     0   2   11 3                 14
934989 934989 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   grade_1 50 3 2 0   1     0   2   36 22                       58 50 3 2 0   1     0   2   36 22                 58
934990 934990 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   grade_2 34 3 0 4   1     0   5   26 21                       47 34 3 0 4   1     0   5   26 21                 47
934991 934991 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   grade_3 47 1 4 0   4     0   3   30 29                       59 47 1 4 0   4     0   3   30 29                 59
934992 934992 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   grade_4 55 4 6 1   0     0   4   41 29                       70 55 4 6 1   0     0   4   41 29                 70
934993 934993 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   kindergarten 75 1 2 0   4     0   6   47 41                       88 75 1 2 0   4     0   6   47 41                 88
934994 934994 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_1 86 4 5 2   4     0   3   55 49                       104 86 4 5 2   4     0   3   55 49                 104
934995 934995 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_2 78 0 3 3   3     0   5   50 42                       92 78 0 3 3   3     0   5   50 42                 92
934996 934996 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_3 80 3 9 0   3     0   8   55 48                       103 80 3 9 0   3     0   8   55 48                 103
934997 934997 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_4 65 6 6 0   3     0   6   44 42                       86 65 6 6 0   3     0   6   44 42                 86
934998 934998 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   kindergarten 49 2 1 0   1     0   4   23 34                       57 49 2 1 0   1     0   4   23 34                 57
934999 934999 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_1 63 0 4 0   2     0   4   38 35                       73 63 0 4 0   2     0   4   38 35                 73
935000 935000 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_2 57 1 7 0   0     0   3   32 36                       68 57 1 7 0   0     0   3   32 36                 68
935001 935001 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_3 61 1 2 0   2     0   2   34 34                       68 61 1 2 0   2     0   2   34 34                 68
935002 935002 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_4 51 4 5 1   0     0   4   29 36                       65 51 4 5 1   0     0   4   29 36                 65
935003 935003 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2016   grade_5 263 17 14 1   6     1   15   154 163                       317 263 17 14 1   6     1   15   154 163                 317
935004 935004 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2016   grade_6 239 13 16 3   6     0   19   160 136                       296 239 13 16 3   6     0   19   160 136                 296
935005 935005 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2016   grade_7 233 10 7 4   7     0   19   136 144                       280 233 10 7 4   7     0   19   136 144                 280
935006 935006 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2016   grade_8 239 15 11 1   8     0   16   147 143                       290 239 15 11 1   8     0   16   147 143                 290
935007 935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
935008 935008 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_10 183 11 12 2   6     0   16   114 116                       230 183 11 12 2   6     0   16   114 116                 230
935009 935009 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_11 198 12 6 2   7     0   8   134 99                       233 198 12 6 2   7     0   8   134 99                 233
935010 935010 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_12 145 7 5 5   9     1   4   83 93                       176 145 7 5 5   9     1   4   83 93                 176
935011 935011 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 2                       5                         3 2                 5
936565 936565 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   kindergarten 86 5 10 8   2     0   9   61 59                       120 86 5 10 8   2     0   9   61 59                 120
936566 936566 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   pre_kindergarten 61 7 4 5   1     1   2   46 35                       81 61 7 4 5   1     1   2   46 35                 81
936567 936567 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_1 72 1 8 9   1     0   9   47 53                       100 72 1 8 9   1     0   9   47 53                 100
936568 936568 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_2 101 5 4 8   1     0   6   62 63                       125 101 5 4 8   1     0   6   62 63                 125
936569 936569 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_7 123 7 6 8   3     0   2   69 80                       149 123 7 6 8   3     0   2   69 80                 149
936570 936570 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_8 103 6 4 6   3     0   5   65 62                       127 103 6 4 6   3     0   5   65 62                 127
936571 936571 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_3 109 2 3 8   3     0   10   69 66                       135 109 2 3 8   3     0   10   69 66                 135
936572 936572 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_4 85 2 4 6   2     0   5   62 42                       104 85 2 4 6   2     0   5   62 42                 104
936573 936573 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_5 103 5 3 13   6     0   5   58 77                       135 103 5 3 13   6     0   5   58 77                 135

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