Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by district_state_id descending

View and edit SQL

year

grade

  • grade_2 · 6,831
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
738216 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   grade_2 57 0 0 0   4     0   1   38 24                       62 57 0 0 0   4     0   1   38 24                 62
738221 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2015   grade_2 63 2 2 0   8     0   0   41 34                       75 63 2 2 0   8     0   0   41 34                 75
738226 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No 1 KG 04 2015   grade_2 48 0 0 0   2     0   1   29 22                       51 48 0 0 0   2     0   1   29 22                 51
935069 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2016   grade_2 52 0 2 0   2     1   0   26 31                       57 52 0 2 0   2     1   0   26 31                 57
935074 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2016   grade_2 66 5 2 0   6     0   4   37 46                       83 66 5 2 0   6     0   4   37 46                 83
935079 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No 1 KG 04 2016   grade_2 51 1 2 0   2     0   1   39 18                       57 51 1 2 0   2     0   1   39 18                 57
1124932 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2017   grade_2 31 2 3 0   2     0   1   22 17                       39 31 2 3 0   2     0   1   22 17                 39
1124938 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2017   grade_2 63 3 4 2   4     0   5   45 36                       81 63 3 4 2   4     0   5   45 36                 81
1124944 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2017   grade_2 35 2 2 0   2     0   1   17 25                       42 35 2 2 0   2     0   1   17 25                 42
1367302 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2020   grade_2 41 2 4 0   4     0   1   24 28 *                     52.0 41 2 4 0   4     0   1   24 28                 52
1367307 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2020   grade_2 59 3 5 0   8     0   2   42 35 *                     77.0 59 3 5 0   8     0   2   42 35                 77
1367312 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2020   grade_2 27 2 5 0   4     0   2   21 19 *                     40.0 27 2 5 0   4     0   2   21 19                 40
1674536 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Foxborough - Mabelle M Burrell   Regular School No Elementary PK 04 2021   grade_2 42 4 1 0   1     0   1   21 28 *                     49.0 42 4 1 0   1     0   1   21 28                 49
1674541 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Foxborough - Vincent M Igo Elementary   Regular School No Elementary KG 04 2021   grade_2 45 5 3 0   4     1   4   37 25 *                     62.0 45 5 3 0   4     1   4   37 25                 62
1674546 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough - Charles Taylor Elementary   Regular School No Elementary KG 04 2021   grade_2 32 0 7 0   2     0   3   24 20 *                     44.0 32 0 7 0   2     0   3   24 20                 44
2042374 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2019   grade_2 36 2 1 0   3     0   1   24 19                       43.0 36 2 1 0   3     0   1   24 19                 43
2042379 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2019   grade_2 63 1 5 0   6     0   3   40 38                       78.0 63 1 5 0   6     0   3   40 38                 78
2042384 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2019   grade_2 44 2 4 0   0     1   2   28 25                       53.0 44 2 4 0   0     1   2   28 25                 53
2231760 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Foxborough: Mabelle M Burrell   Regular School No Elementary PK 04 2018   grade_2 33 3 5 1   1     0   2   26 19                       45.0 33 3 5 1   1     0   2   26 19                 45
2231766 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Foxborough: Vincent M Igo Elementary   Regular School No Elementary KG 04 2018   grade_2 57 1 4 0   4     0   0   30 36                       66.0 57 1 4 0   4     0   0   30 36                 66
2231772 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough: Charles Taylor Elementary   Regular School No Elementary KG 04 2018   grade_2 36 1 1 3   3     0   1   28 17                       45.0 36 1 1 3   3     0   1   28 17                 45
738206 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_2 13 0 0 0   0     0   0   5 8                       13 13 0 0 0   0     0   0   5 8                 13
935060 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_2 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1124922 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_2 * * * *   *     *   *   2 3                       *                         2 3                  
1674526 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_2 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
2042364 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_2 8 0 0 0   0     0   0   3 5                       8.0 8 0 0 0   0     0   0   3 5                 8
2231750 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_2 8 0 0 0   0     0   0   4 4                       8.0 8 0 0 0   0     0   0   4 4                 8
738161 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_2 31 3 49 0   2     0   12   44 53                       97 31 3 49 0   2     0   12   44 53                 97
738166 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_2 48 3 58 0   6     0   11   60 66                       126 48 3 58 0   6     0   11   60 66                 126
738176 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_2 44 4 55 0   9     1   8   58 63                       121 44 4 55 0   9     1   8   58 63                 121
738186 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_2 23 1 28 0   10     0   11   42 31                       73 23 1 28 0   10     0   11   42 31                 73
935015 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2016   grade_2 31 5 54 0   4     0   4   50 48                       98 31 5 54 0   4     0   4   50 48                 98
935020 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2016   grade_2 52 9 48 0   4     1   9   65 58                       123 52 9 48 0   4     1   9   65 58                 123
935030 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2016   grade_2 40 7 67 0   7     0   13   57 77                       134 40 7 67 0   7     0   13   57 77                 134
935040 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_2 18 2 40 0   6     0   3   30 39                       69 18 2 40 0   6     0   3   30 39                 69
1124870 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_2 39 6 55 0   1     1   9   61 50                       111 39 6 55 0   1     1   9   61 50                 111
1124876 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_2 53 8 62 0   3     0   10   71 65                       136 53 8 62 0   3     0   10   71 65                 136
1124888 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2017   grade_2 31 9 75 0   8     0   12   67 68                       135 31 9 75 0   8     0   12   67 68                 135
1124900 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_2 24 5 39 0   7     0   7   36 46                       82 24 5 39 0   7     0   7   36 46                 82
1367247 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   grade_2 25 5 57 0   5     0   11   51 52 *                     103.0 25 5 57 0   5     0   11   51 52                 103
1367253 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2020   grade_2 28 8 58 0   2     0   11   61 46 *                     107.0 28 8 58 0   2     0   11   61 46                 107
1367263 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_2 32 9 58 0   5     0   3   55 52 *                     107.0 32 9 58 0   5     0   3   55 52                 107
1367273 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_2 20 4 36 0   7     0   4   42 29 *                     71.0 20 4 36 0   7     0   4   42 29                 71
1674481 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_2 32 7 81 0   3     0   7   70 60 *                     130.0 32 7 81 0   3     0   7   70 60                 130
1674487 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   grade_2 42 3 74 0   7     0   7   80 53 *                     133.0 42 3 74 0   7     0   7   80 53                 133
1674497 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg - South Street Elementary   Regular School No Elementary PK 04 2021   grade_2 22 10 82 0   2     0   13   67 62 *                     129.0 22 10 82 0   2     0   13   67 62                 129
1674507 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   grade_2 19 7 39 0   4     0   7   37 39 *                     76.0 19 7 39 0   4     0   7   37 39                 76
2042317 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   grade_2 39 5 68 0   3     0   12   72 55                       127.0 39 5 68 0   3     0   12   72 55                 127
2042323 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   grade_2 38 5 69 0   5     0   11   75 53                       128.0 38 5 69 0   5     0   11   75 53                 128
2042333 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_2 28 9 66 0   5     0   8   65 51                       116.0 28 9 66 0   5     0   8   65 51                 116
2042343 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   grade_2 15 8 39 0   6     0   3   37 34                       71.0 15 8 39 0   6     0   3   37 34                 71
2231697 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg: Crocker Elementary   Regular School No Elementary PK 04 2018   grade_2 39 7 63 1   4     0   5   66 53                       119.0 39 7 63 1   4     0   5   66 53                 119
2231704 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg: Reingold Elementary   Regular School No Elementary PK 04 2018   grade_2 39 8 63 0   3     0   9   60 62                       122.0 39 8 63 0   3     0   9   60 62                 122
2231716 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg: South Street Elementary   Regular School No Elementary PK 04 2018   grade_2 40 10 62 1   3     0   5   60 61                       121.0 40 10 62 1   3     0   5   60 61                 121
2231728 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_2 28 1 33 0   6     0   5   34 39                       73.0 28 1 33 0   6     0   5   34 39                 73
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
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
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
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
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
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
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
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
1124833 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   grade_2 48 5 3 1   1     0   1   24 35                       59 48 5 3 1   1     0   1   24 35                 59
1124840 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   grade_2 50 3 2 0   1     0   2   34 24                       58 50 3 2 0   1     0   2   34 24                 58
1124846 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_2 81 6 5 1   2     0   3   52 46                       98 81 6 5 1   2     0   3   52 46                 98
1124852 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   grade_2 65 0 3 0   2     0   4   35 39                       74 65 0 3 0   2     0   4   35 39                 74
1367216 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_2 30 2 5 1   1     0   5   20 24 *                     44.0 30 2 5 1   1     0   5   20 24                 44
1367222 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_2 33 4 7 0   1     0   5   31 19 *                     50.0 33 4 7 0   1     0   5   31 19                 50
1367227 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_2 69 3 8 0   1     0   8   59 30 *                     89.0 69 3 8 0   1     0   8   59 30                 89
1367232 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_2 65 3 7 0   1     0   3   39 40 *                     79.0 65 3 7 0   1     0   3   39 40                 79
1674450 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_2 32 1 8 0   3     0   1   21 24 *                     45.0 32 1 8 0   3     0   1   21 24                 45
1674456 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_2 27 7 1 1   0     0   2   17 21 *                     38.0 27 7 1 1   0     0   2   17 21                 38
1674461 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_2 63 4 10 0   2     0   4   34 49 *                     83.0 63 4 10 0   2     0   4   34 49                 83
1674466 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_2 49 3 6 0   0     0   4   26 36 *                     62.0 49 3 6 0   0     0   4   26 36                 62
2042286 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_2 33 2 2 3   0     0   4   26 18                       44.0 33 2 2 3   0     0   4   26 18                 44
2042292 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   grade_2 33 8 3 1   0     0   8   26 27                       53.0 33 8 3 1   0     0   8   26 27                 53
2042297 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2019   grade_2 62 2 6 2   1     0   9   44 38                       82.0 62 2 6 2   1     0   9   44 38                 82
2042302 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_2 45 2 3 0   2     0   2   33 21                       54.0 45 2 3 0   2     0   2   33 21                 54
2231660 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_2 39 2 4 0   1     0   6   27 25                       52.0 39 2 4 0   1     0   6   27 25                 52
2231667 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_2 43 6 5 0   0     0   0   21 33                       54.0 43 6 5 0   0     0   0   21 33                 54
2231673 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth: Mullen-Hall   Regular School No Elementary KG 04 2018   grade_2 74 0 5 0   2     0   6   47 40                       87.0 74 0 5 0   2     0   6   47 40                 87
2231679 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth: North Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_2 51 1 5 0   0     0   4   23 38                       61.0 51 1 5 0   0     0   4   23 38                 61
738035 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   grade_2 71 12 20 0   4     1   14   65 57                       122 71 12 20 0   4     1   14   65 57                 122
738041 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_2 63 9 32 0   6     0   17   63 64                       127 63 9 32 0   6     0   17   63 64                 127
738047 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   grade_2 62 14 43 1   6     0   10   59 77                       136 62 14 43 1   6     0   10   59 77                 136
738054 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2015   grade_2 49 5 40 1   2     0   6   52 51                       103 49 5 40 1   2     0   6   52 51                 103
738061 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   grade_2 27 0 17 1   2     0   6   27 26                       53 27 0 17 1   2     0   6   27 26                 53
738069 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_2 33 2 22 0   1     0   5   30 33                       63 33 2 22 0   1     0   5   30 33                 63
738082 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   grade_2 85 7 17 0   4     0   11   59 65                       124 85 7 17 0   4     0   11   59 65                 124
738089 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2015   grade_2 71 3 16 0   3     0   8   50 51                       101 71 3 16 0   3     0   8   50 51                 101
738095 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2015   grade_2 43 0 5 0   1     0   6   25 30                       55 43 0 5 0   1     0   6   25 30                 55
738101 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No 1 KG 05 2015   grade_2 20 1 8 0   1     0   3   15 18                       33 20 1 8 0   1     0   3   15 18                 33
934887 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_2 83 4 23 0   2     0   10   65 57                       122 83 4 23 0   2     0   10   65 57                 122
934893 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2016   grade_2 55 10 37 0   1     0   10   58 55                       113 55 10 37 0   1     0   10   58 55                 113
934899 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2016   grade_2 60 16 40 0   9     0   16   66 75                       141 60 16 40 0   9     0   16   66 75                 141
934906 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_2 49 7 41 0   4     0   7   63 45                       108 49 7 41 0   4     0   7   63 45                 108
934913 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_2 32 10 22 0   4     0   10   43 35                       78 32 10 22 0   4     0   10   43 35                 78
934922 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_2 31 7 15 1   1     0   8   34 29                       63 31 7 15 1   1     0   8   34 29                 63
934932 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2016   grade_2 61 8 24 1   6     0   9   54 55                       109 61 8 24 1   6     0   9   54 55                 109

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