Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by school_state_id descending

View and edit SQL

year

grade

  • grade_4 · 6,679
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
745190 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_4 9 2 1 0   0     0   1   8 5                       13 9 2 1 0   0     0   1   8 5                 13
942026 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_4 18 3 7 0   2     0   2   14 18                       32 18 3 7 0   2     0   2   14 18                 32
1133200 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 16 8 5 0   1     0   3   23 10                       33 16 8 5 0   1     0   3   23 10                 33
1374297 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_4 36 9 16 1   4     0   4   30 40 *                     70.0 36 9 16 1   4     0   4   30 40                 70
1681535 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_4 58 10 20 0   2     2   4   34 62 *                     96.0 58 10 20 0   2     2   4   34 62                 96
2049366 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 35 8 14 0   2     0   11   35 35                       70.0 35 8 14 0   2     0   11   35 35                 70
2240028 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_4 22 5 12 0   2     0   2   29 14                       43.0 22 5 12 0   2     0   2   29 14                 43
745177 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_4 37 5 5 0   1     0   1   23 26                       49 37 5 5 0   1     0   1   23 26                 49
942013 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_4 33 3 1 0   1     0   0   22 16                       38 33 3 1 0   1     0   0   22 16                 38
1133186 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 22 8 9 0   3     0   4   21 25                       46 22 8 9 0   3     0   4   21 25                 46
1374284 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_4 17 5 3 0   1     0   0   15 11 *                     26.0 17 5 3 0   1     0   0   15 11                 26
1681522 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_4 30 6 5 0   3     0   2   18 28 0                     46.0 30 6 5 0   3     0   2   18 28 0               46
2049353 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 18 6 8 0   1     0   0   20 13                       33.0 18 6 8 0   1     0   0   20 13                 33
2240014 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_4 26 6 8 0   0     2   6   28 20                       48.0 26 6 8 0   0     2   6   28 20                 48
1374265 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_4 29 4 6 0   1     0   0   24 16 *                     40.0 29 4 6 0   1     0   0   24 16                 40
1681502 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School (District) - Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 06 2021   grade_4 35 1 3 0   1     0   0   18 22 *                     40.0 35 1 3 0   1     0   0   18 22                 40
2049336 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   grade_4 36 2 2 0   0     0   0   20 20                       40.0 36 2 2 0   0     0   0   20 20                 40
942007 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes 1 KG 05 2016   grade_4 7 3 24 0   1     0   1   17 19                       36 7 3 24 0   1     0   1   17 19                 36
1133175 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_4 9 6 15 0   2     0   2   18 16                       34 9 6 15 0   2     0   2   18 16                 34
1374250 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_4 22 4 28 0   1     0   0   25 30 *                     55.0 22 4 28 0   1     0   0   25 30                 55
2049323 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_4 13 7 34 0   3     0   0   26 31                       57.0 13 7 34 0   3     0   0   26 31                 57
2239995 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School (District): Bentley Academy Charter School   Regular School Yes Elementary KG 05 2018   grade_4 13 6 16 0   1     0   2   23 15                       38.0 13 6 16 0   1     0   2   23 15                 38
1374244 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_4 3 11 38 0   2     0   0   29 25 *                     54.0 3 11 38 0   2     0   0   29 25                 54
1681485 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School (District) - Springfield Preparatory Charter School   Regular School Yes Elementary KG 06 2021   grade_4 6 12 33 0   1     0   2   33 21 *                     54.0 6 12 33 0   1     0   2   33 21                 54
2049318 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_4 10 12 33 0   0     0   3   30 28                       58.0 10 12 33 0   0     0   3   30 28                 58
745161 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 06 2015   grade_4 1 43 24 0   1     0   5   33 41                       74 1 43 24 0   1     0   5   33 41                 74
941984 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   grade_4 2 38 44 0   3     1   4   44 48                       92 2 38 44 0   3     1   4   44 48                 92
1133141 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_4 2 56 39 0   0     0   2   51 48                       99 2 56 39 0   0     0   2   51 48                 99
1374215 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_4 0 45 27 0   1     0   2   40 35 *                     75.0 0 45 27 0   1     0   2   40 35                 75
1681460 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District) - UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2021   grade_4 1 42 28 1   0     1   2   35 40 *                     75.0 1 42 28 1   0     1   2   35 40                 75
2049290 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_4 0 45 26 0   1     1   0   40 33                       73.0 0 45 26 0   1     1   0   40 33                 73
2239958 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2018   grade_4 1 48 38 0   1     0   2   51 39                       90.0 1 48 38 0   1     0   2   51 39                 90
745153 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 04 2015   grade_4 19 7 12 0   11     0   1   22 28                       50 19 7 12 0   11     0   1   22 28                 50
941974 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 05 2016   grade_4 17 9 25 0   10     0   4   39 26                       65 17 9 25 0   10     0   4   39 26                 65
1133127 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_4 14 18 29 0   25     0   4   42 48                       90 14 18 29 0   25     0   4   42 48                 90
1374200 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_4 16 25 36 0   32     0   5   52 62 *                     114.0 16 25 36 0   32     0   5   52 62                 114
1681448 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_4 14 29 42 0   24     0   7   61 55 *                     116.0 14 29 42 0   24     0   7   61 55                 116
2049276 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_4 13 16 44 1   19     0   1   45 49                       94.0 13 16 44 1   19     0   1   45 49                 94
2239943 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District): Collegiate Charter School of Lowell   Regular School Yes Elementary KG 07 2018   grade_4 18 25 51 0   24     0   7   50 75                       125.0 18 25 51 0   24     0   7   50 75                 125
745014 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No 1 03 05 2015   grade_4 124 1 4 0   0     0   2   80 51                       131 124 1 4 0   0     0   2   80 51                 131
941835 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No 1 03 05 2016   grade_4 120 1 3 0   3     0   0   63 64                       127 120 1 3 0   3     0   0   63 64                 127
1132956 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary 03 05 2017   grade_4 103 2 4 0   1     0   1   55 56                       111 103 2 4 0   1     0   1   55 56                 111
1374059 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_4 93 1 4 0   1     0   3   53 49 *                     102.0 93 1 4 0   1     0   3   53 49                 102
1681307 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson - Indian Head   Regular School No Elementary KG 04 2021   grade_4 90 0 5 1   2     0   2   55 45 *                     100.0 90 0 5 1   2     0   2   55 45                 100
2049132 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   grade_4 99 0 6 0   2     0   3   58 52                       110.0 99 0 6 0   2     0   3   58 52                 110
2239771 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson: Indian Head   Regular School No Elementary 03 05 2018   grade_4 99 0 2 0   0     0   2   51 52                       103.0 99 0 2 0   0     0   2   51 52                 103
745011 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2015   grade_4 85 4 2 2   0     1   4   55 43                       98 85 4 2 2   0     1   4   55 43                 98
941832 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2016   grade_4 80 3 7 1   0     0   2   53 40                       93 80 3 7 1   0     0   2   53 40                 93
1132952 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2017   grade_4 78 1 9 0   2     0   3   42 51                       93 78 1 9 0   2     0   3   42 51                 93
1374053 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2020   grade_4 57 2 11 0   2     0   1   34 39 *                     73.0 57 2 11 0   2     0   1   34 39                 73
1681301 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson - John H Duval   Regular School No Elementary KG 05 2021   grade_4 63 4 4 1   0     0   3   40 35 *                     75.0 63 4 4 1   0     0   3   40 35                 75
2049126 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2019   grade_4 67 4 3 1   0     1   4   45 35                       80.0 67 4 3 1   0     1   4   45 35                 80
2239767 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson: John H Duval   Regular School No Elementary KG 05 2018   grade_4 68 1 4 1   1     0   5   35 45                       80.0 68 1 4 1   1     0   5   35 45                 80
745001 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2015   grade_4 79 4 2 1   0     0   2   53 35                       88 79 4 2 1   0     0   2   53 35                 88
941822 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2016   grade_4 70 3 4 0   1     0   3   46 35                       81 70 3 4 0   1     0   3   46 35                 81
1132940 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   grade_4 97 2 6 0   1     0   4   40 70                       110 97 2 6 0   1     0   4   40 70                 110
1374047 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2020   grade_4 82 4 2 0   1     0   3   49 43 *                     92.0 82 4 2 0   1     0   3   49 43                 92
1681295 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson - Louise A Conley   Regular School No Elementary KG 05 2021   grade_4 72 4 9 2   1     0   2   44 46 *                     90.0 72 4 9 2   1     0   2   44 46                 90
2049120 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2019   grade_4 70 0 7 1   1     0   1   48 32                       80.0 70 0 7 1   1     0   1   48 32                 80
2239755 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson: Louise A Conley   Regular School No Elementary KG 05 2018   grade_4 95 6 6 1   0     0   2   58 52                       110.0 95 6 6 1   0     0   2   58 52                 110
744988 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_4 46 2 0 0   0     0   0   26 22                       48 46 2 0 0   0     0   0   26 22                 48
941809 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2016   grade_4 39 0 2 0   0     0   1   22 20                       42 39 0 2 0   0     0   1   22 20                 42
1132924 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_4 32 1 2 0   0     0   3   16 22                       38 32 1 2 0   0     0   3   16 22                 38
1374033 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_4 30 0 4 0   0     0   2   18 18 *                     36.0 30 0 4 0   0     0   2   18 18                 36
1681281 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional - West Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_4 31 0 3 0   0     0   2   19 17 *                     36.0 31 0 3 0   0     0   2   19 17                 36
2049107 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_4 40 0 1 0   0     0   4   21 24                       45.0 40 0 1 0   0     0   4   21 24                 45
2239739 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_4 43 0 0 0   0     0   0   24 19                       43.0 43 0 0 0   0     0   0   24 19                 43
744980 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   grade_4 62 0 4 0   0     0   1   35 32                       67 62 0 4 0   0     0   1   35 32                 67
941801 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2016   grade_4 55 2 7 0   0     0   2   36 30                       66 55 2 7 0   0     0   2   36 30                 66
1132915 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2017   grade_4 62 0 5 0   0     0   1   31 37                       68 62 0 5 0   0     0   1   31 37                 68
1374025 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2020   grade_4 48 0 6 0   0     0   4   27 31 *                     58.0 48 0 6 0   0     0   4   27 31                 58
1681273 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional - Warren Elementary   Regular School No Elementary PK 06 2021   grade_4 35 0 4 0   1     0   2   27 15 *                     42.0 35 0 4 0   1     0   2   27 15                 42
2049099 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2019   grade_4 61 0 5 0   0     0   6   37 35                       72.0 61 0 5 0   0     0   6   37 35                 72
2239730 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional: Warren Elementary   Regular School No Elementary PK 06 2018   grade_4 54 0 3 0   0     0   0   24 33                       57.0 54 0 3 0   0     0   0   24 33                 57
744958 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No 1 03 05 2015   grade_4 119 0 5 0   5     0   9   82 56                       138 119 0 5 0   5     0   9   82 56                 138
941779 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No 1 03 05 2016   grade_4 106 1 4 0   0     0   3   52 62                       114 106 1 4 0   0     0   3   52 62                 114
1132889 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2017   grade_4 112 3 8 0   5     0   3   66 65                       131 112 3 8 0   5     0   3   66 65                 131
1374003 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2020   grade_4 117 4 9 1   1     0   3   65 70 *                     135.0 117 4 9 1   1     0   3   65 70                 135
1681251 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett - Glenwood Elementary School   Regular School No Elementary 03 05 2021   grade_4 98 2 10 0   1     0   1   56 56 *                     112.0 98 2 10 0   1     0   1   56 56                 112
2049077 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2019   grade_4 97 2 3 2   1     0   4   56 53                       109.0 97 2 3 2   1     0   4   56 53                 109
2239704 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett: Glenwood Elementary School   Regular School No Elementary 03 05 2018   grade_4 92 2 7 0   5     0   6   57 55                       112.0 92 2 7 0   5     0   6   57 55                 112
744952 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_4 37 0 1 0   0     0   0   17 21                       38 37 0 1 0   0     0   0   17 21                 38
941773 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_4 41 0 3 0   1     0   0   15 30                       45 41 0 3 0   1     0   0   15 30                 45
1132882 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2017   grade_4 37 0 1 0   2     0   0   18 22                       40 37 0 1 0   2     0   0   18 22                 40
1373997 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_4 35 0 1 0   0     0   0   15 21 *                     36.0 35 0 1 0   0     0   0   15 21                 36
1681245 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_4 36 0 3 0   0     0   2   25 16 *                     41.0 36 0 3 0   0     0   2   25 16                 41
2049071 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_4 48 0 1 0   0     0   0   22 27                       49.0 48 0 1 0   0     0   0   22 27                 49
2239697 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_4 41 2 1 0   0     0   3   30 17                       47.0 41 2 1 0   0     0   3   30 17                 47
744943 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_4 58 1 3 0   0     0   1   35 28                       63 58 1 3 0   0     0   1   35 28                 63
941764 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_4 59 1 6 0   0     0   2   37 31                       68 59 1 6 0   0     0   2   37 31                 68
1132872 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2017   grade_4 51 2 5 0   4     0   0   31 31                       62 51 2 5 0   4     0   0   31 31                 62
1373988 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2020   grade_4 38 0 3 0   0     0   0   20 21 *                     41.0 38 0 3 0   0     0   0   20 21                 41
1681236 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett - Paxton Center   Regular School No Elementary KG 08 2021   grade_4 44 0 4 0   3     0   1   17 35 *                     52.0 44 0 4 0   3     0   1   17 35                 52
2049062 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_4 47 2 5 0   2     0   0   33 23                       56.0 47 2 5 0   2     0   0   33 23                 56
2239687 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_4 45 1 6 0   3     0   0   29 26                       55.0 45 1 6 0   3     0   0   29 26                 55
744937 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No 1 KG 05 2015   grade_4 74 0 3 0   5     0   3   42 43                       85 74 0 3 0   5     0   3   42 43                 85
941758 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No 1 KG 05 2016   grade_4 81 1 4 0   5     0   0   39 52                       91 81 1 4 0   5     0   0   39 52                 91
1132865 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2017   grade_4 66 1 10 0   5     0   3   43 42                       85 66 1 10 0   5     0   3   43 42                 85
1373982 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2020   grade_4 79 1 2 0   7     0   2   53 38 *                     91.0 79 1 2 0   7     0   2   53 38                 91
1681230 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Wachusett - Leroy E.Mayo   Regular School No Elementary KG 05 2021   grade_4 75 5 4 0   4     0   2   48 42 *                     90.0 75 5 4 0   4     0   2   48 42                 90

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