enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,880 ✖
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
745187 745187 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_1 7 0 0 0   0     0   2   6 3                       9 7 0 0 0   0     0   2   6 3                 9
942023 942023 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_1 13 2 1 0   2     0   2   10 10                       20 13 2 1 0   2     0   2   10 10                 20
1133197 1133197 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_1 15 3 3 1   1     0   4   17 10                       27 15 3 3 1   1     0   4   17 10                 27
1374294 1374294 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_1 21 7 10 0   1     0   2   25 16 *                     41.0 21 7 10 0   1     0   2   25 16                 41
1681532 1681532 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_1 25 11 15 0   2     0   5   34 24 *                     58.0 25 11 15 0   2     0   5   34 24                 58
2049363 2049363 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_1 27 9 16 1   1     0   5   36 23                       59.0 27 9 16 1   1     0   5   36 23                 59
2240025 2240025 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_1 18 4 11 0   0     0   2   15 20                       35.0 18 4 11 0   0     0   2   15 20                 35
745174 745174 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_1 39 6 9 0   2     0   4   30 30                       60 39 6 9 0   2     0   4   30 30                 60
942010 942010 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_1 25 6 10 0   1     0   1   18 25                       43 25 6 10 0   1     0   1   18 25                 43
1133183 1133183 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_1 18 6 6 0   0     0   2   16 16                       32 18 6 6 0   0     0   2   16 16                 32
1374281 1374281 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_1 11 2 2 0   2     0   2   6 13 *                     19.0 11 2 2 0   2     0   2   6 13                 19
1681519 1681519 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_1 23 3 10 0   1     0   0   16 21 0                     37.0 23 3 10 0   1     0   0   16 21 0               37
2049350 2049350 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_1 13 7 2 0   1     0   1   10 14                       24.0 13 7 2 0   1     0   1   10 14                 24
2240011 2240011 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_1 9 5 3 0   0     0   0   9 8                       17.0 9 5 3 0   0     0   0   9 8                 17
1374262 1374262 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_1 32 1 5 0   1     0   1   20 20 *                     40.0 32 1 5 0   1     0   1   20 20                 40
1681499 1681499 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_1 34 2 4 0   0     0   0   18 22 *                     40.0 34 2 4 0   0     0   0   18 22                 40
2049333 2049333 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_1 31 4 5 0   0     0   0   23 17                       40.0 31 4 5 0   0     0   0   23 17                 40
2240006 2240006 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School (District): Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 03 2018   grade_1 32 2 5 0   1     0   0   16 24                       40.0 32 2 5 0   1     0   0   16 24                 40
942004 942004 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes 1 KG 05 2016   grade_1 21 7 26 0   2     0   1   36 21                       57 21 7 26 0   2     0   1   36 21                 57
1133172 1133172 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_1 23 4 14 0   1     0   1   21 22                       43 23 4 14 0   1     0   1   21 22                 43
1374247 1374247 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_1 7 5 40 0   1     0   4   24 33 *                     57.0 7 5 40 0   1     0   4   24 33                 57
2049320 2049320 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_1 15 9 37 0   0     0   2   34 29                       63.0 15 9 37 0   0     0   2   34 29                 63
2239992 2239992 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_1 16 8 33 0   2     0   1   27 33                       60.0 16 8 33 0   2     0   1   27 33                 60
942002 942002 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes 1 KG 01 2016   grade_1 3 12 35 0   0     0   4   27 27                       54 3 12 35 0   0     0   4   27 27                 54
1133168 1133168 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   grade_1 2 10 39 0   2     0   1   26 28                       54 2 10 39 0   2     0   1   26 28                 54
1374241 1374241 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_1 3 7 41 0   1     0   1   32 21 *                     53.0 3 7 41 0   1     0   1   32 21                 53
1681482 1681482 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_1 5 9 38 0   1     0   1   26 28 *                     54.0 5 9 38 0   1     0   1   26 28                 54
2049315 2049315 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_1 3 10 39 0   2     0   0   22 32                       54.0 3 10 39 0   2     0   0   22 32                 54
2239987 2239987 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 03 2018   grade_1 4 18 30 0   1     0   1   27 27                       54.0 4 18 30 0   1     0   1   27 27                 54
745158 745158 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_1 2 55 34 0   2     0   3   52 44                       96 2 55 34 0   2     0   3   52 44                 96
941981 941981 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_1 8 32 23 0   2     0   1   33 33                       66 8 32 23 0   2     0   1   33 33                 66
1133138 1133138 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_1 0 42 27 0   1     0   2   42 30                       72 0 42 27 0   1     0   2   42 30                 72
1374212 1374212 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_1 1 39 30 0   0     0   2   36 36 *                     72.0 1 39 30 0   0     0   2   36 36                 72
1681457 1681457 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_1 1 37 29 0   0     1   2   32 38 *                     70.0 1 37 29 0   0     1   2   32 38                 70
2049287 2049287 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_1 2 39 30 0   0     0   2   38 35                       73.0 2 39 30 0   0     0   2   38 35                 73
2239955 2239955 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_1 2 43 23 1   1     0   1   35 36                       71.0 2 43 23 1   1     0   1   35 36                 71
745150 745150 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 04 2015   grade_1 12 20 30 0   20     0   6   41 47                       88 12 20 30 0   20     0   6   41 47                 88
941971 941971 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 05 2016   grade_1 16 20 28 1   15     0   2   39 43                       82 16 20 28 1   15     0   2   39 43                 82
1133124 1133124 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_1 20 25 36 0   24     0   5   47 63                       110 20 25 36 0   24     0   5   47 63                 110
1374197 1374197 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_1 18 20 33 0   31     0   5   46 61 *                     107.0 18 20 33 0   31     0   5   46 61                 107
1681445 1681445 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_1 14 17 30 0   22     0   1   46 38 *                     84.0 14 17 30 0   22     0   1   46 38                 84
2049273 2049273 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_1 10 22 36 0   38     0   4   63 47                       110.0 10 22 36 0   38     0   4   63 47                 110
2239940 2239940 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_1 13 21 44 0   24     0   9   63 48                       111.0 13 21 44 0   24     0   9   63 48                 111
1374056 1374056 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_1 88 1 5 0   2     0   2   44 54 *                     98.0 88 1 5 0   2     0   2   44 54                 98
1681304 1681304 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson - Indian Head   Regular School No Elementary KG 04 2021   grade_1 85 1 5 0   2     0   3   41 55 *                     96.0 85 1 5 0   2     0   3   41 55                 96
2049129 2049129 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   grade_1 89 2 4 0   1     0   2   53 45                       98.0 89 2 4 0   1     0   2   53 45                 98
745008 745008 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2015   grade_1 75 2 3 2   0     0   5   36 51                       87 75 2 3 2   0     0   5   36 51                 87
941829 941829 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2016   grade_1 65 3 3 0   0     1   3   38 37                       75 65 3 3 0   0     1   3   38 37                 75
1132949 1132949 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2017   grade_1 58 1 5 0   1     0   5   33 37                       70 58 1 5 0   1     0   5   33 37                 70
1374050 1374050 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2020   grade_1 60 1 5 0   0     0   7   41 32 *                     73.0 60 1 5 0   0     0   7   41 32                 73
1681298 1681298 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson - John H Duval   Regular School No Elementary KG 05 2021   grade_1 51 5 8 0   2     0   4   32 38 *                     70.0 51 5 8 0   2     0   4   32 38                 70
2049123 2049123 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2019   grade_1 66 2 4 0   4     0   1   43 34                       77.0 66 2 4 0   4     0   1   43 34                 77
2239764 2239764 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson: John H Duval   Regular School No Elementary KG 05 2018   grade_1 63 0 6 0   0     0   3   39 33                       72.0 63 0 6 0   0     0   3   39 33                 72
745005 745005 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2015   grade_1 97 0 2 0   0     0   2   57 44                       101 97 0 2 0   0     0   2   57 44                 101
941826 941826 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   grade_1 99 0 6 0   2     0   2   60 49                       109 99 0 6 0   2     0   2   60 49                 109
1132945 1132945 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   grade_1 103 2 4 0   0     0   4   60 53                       113 103 2 4 0   0     0   4   60 53                 113
2239760 2239760 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   grade_1 97 0 3 1   2     0   4   66 41                       107.0 97 0 3 1   2     0   4   66 41                 107
744998 744998 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2015   grade_1 92 2 4 0   1     0   0   54 45                       99 92 2 4 0   1     0   0   54 45                 99
941819 941819 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2016   grade_1 74 2 6 1   1     0   1   47 38                       85 74 2 6 1   1     0   1   47 38                 85
1132937 1132937 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   grade_1 81 4 2 0   1     0   2   45 45                       90 81 4 2 0   1     0   2   45 45                 90
1374044 1374044 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2020   grade_1 67 1 5 0   0     0   4   39 38 *                     77.0 67 1 5 0   0     0   4   39 38                 77
1681292 1681292 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson - Louise A Conley   Regular School No Elementary KG 05 2021   grade_1 70 5 5 0   1     0   1   43 39 *                     82.0 70 5 5 0   1     0   1   43 39                 82
2049117 2049117 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2019   grade_1 77 1 4 0   2     0   3   44 43                       87.0 77 1 4 0   2     0   3   44 43                 87
2239752 2239752 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson: Louise A Conley   Regular School No Elementary KG 05 2018   grade_1 73 2 8 2   0     0   1   42 44                       86.0 73 2 8 2   0     0   1   42 44                 86
744985 744985 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_1 33 0 1 0   0     0   0   18 16                       34 33 0 1 0   0     0   0   18 16                 34
941806 941806 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2016   grade_1 35 0 2 0   0     0   2   21 18                       39 35 0 2 0   0     0   2   21 18                 39
1132921 1132921 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 32 0 4 0   0     0   3   20 19                       39 32 0 4 0   0     0   3   20 19                 39
1374030 1374030 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_1 31 0 7 0   0     0   0   21 17 *                     38.0 31 0 7 0   0     0   0   21 17                 38
1681278 1681278 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional - West Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_1 30 0 0 0   1     0   2   19 14 *                     33.0 30 0 0 0   1     0   2   19 14                 33
2049104 2049104 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_1 33 0 0 0   0     0   2   18 17                       35.0 33 0 0 0   0     0   2   18 17                 35
2239736 2239736 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_1 34 0 1 0   1     0   1   21 16                       37.0 34 0 1 0   1     0   1   21 16                 37
744977 744977 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   grade_1 42 0 1 0   0     0   2   17 28                       45 42 0 1 0   0     0   2   17 28                 45
941798 941798 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2016   grade_1 55 0 6 0   0     0   3   32 32                       64 55 0 6 0   0     0   3   32 32                 64
1132912 1132912 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2017   grade_1 47 1 5 0   0     0   3   23 33                       56 47 1 5 0   0     0   3   23 33                 56
1374022 1374022 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2020   grade_1 45 0 6 0   0     0   3   24 30 *                     54.0 45 0 6 0   0     0   3   24 30                 54
1681270 1681270 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional - Warren Elementary   Regular School No Elementary PK 06 2021   grade_1 37 1 3 0   0     0   1   24 18 *                     42.0 37 1 3 0   0     0   1   24 18                 42
2049096 2049096 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2019   grade_1 45 3 4 0   0     0   2   28 26                       54.0 45 3 4 0   0     0   2   28 26                 54
2239727 2239727 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional: Warren Elementary   Regular School No Elementary PK 06 2018   grade_1 41 0 3 0   0     0   2   29 17                       46.0 41 0 3 0   0     0   2   29 17                 46
744949 744949 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_1 33 1 0 0   0     0   3   21 16                       37 33 1 0 0   0     0   3   21 16                 37
941770 941770 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_1 45 0 1 0   0     0   2   25 23                       48 45 0 1 0   0     0   2   25 23                 48
1132879 1132879 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2017   grade_1 34 0 1 0   0     0   0   14 21                       35 34 0 1 0   0     0   0   14 21                 35
1373994 1373994 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_1 21 1 3 0   1     0   0   15 11 *                     26.0 21 1 3 0   1     0   0   15 11                 26
1681242 1681242 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_1 34 0 0 0   0     0   1   26 9 *                     35.0 34 0 0 0   0     0   1   26 9                 35
2049068 2049068 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_1 35 0 1 0   0     0   0   17 19                       36.0 35 0 1 0   0     0   0   17 19                 36
2239694 2239694 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_1 43 0 3 0   0     0   2   28 20                       48.0 43 0 3 0   0     0   2   28 20                 48
744940 744940 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_1 37 2 3 0   1     0   0   22 21                       43 37 2 3 0   1     0   0   22 21                 43
941761 941761 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_1 44 2 4 0   0     0   0   29 21                       50 44 2 4 0   0     0   0   29 21                 50
1132869 1132869 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2017   grade_1 31 0 5 0   0     0   0   16 20                       36 31 0 5 0   0     0   0   16 20                 36
1373985 1373985 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2020   grade_1 33 0 4 0   0     0   0   22 15 *                     37.0 33 0 4 0   0     0   0   22 15                 37
1681233 1681233 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett - Paxton Center   Regular School No Elementary KG 08 2021   grade_1 37 0 2 0   1     0   0   12 28 *                     40.0 37 0 2 0   1     0   0   12 28                 40
2049059 2049059 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_1 27 0 1 0   0     0   2   15 15                       30.0 27 0 1 0   0     0   2   15 15                 30
2239684 2239684 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_1 38 0 2 0   0     0   1   17 24                       41.0 38 0 2 0   0     0   1   17 24                 41
744934 744934 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No 1 KG 05 2015   grade_1 73 1 2 0   6     0   0   44 38                       82 73 1 2 0   6     0   0   44 38                 82
941755 941755 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No 1 KG 05 2016   grade_1 72 3 7 0   1     0   0   49 34                       83 72 3 7 0   1     0   0   49 34                 83
1132862 1132862 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2017   grade_1 66 1 1 0   7     0   1   46 30                       76 66 1 1 0   7     0   1   46 30                 76
1373979 1373979 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2020   grade_1 66 3 5 0   2     1   2   39 40 *                     79.0 66 3 5 0   2     1   2   39 40                 79
1681227 1681227 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Wachusett - Leroy E.Mayo   Regular School No Elementary KG 05 2021   grade_1 57 3 4 0   1     0   3   35 33 *                     68.0 57 3 4 0   1     0   3   35 33                 68
2049053 2049053 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2019   grade_1 52 3 7 0   3     0   1   27 39                       66.0 52 3 7 0   3     0   1   27 39                 66
2239677 2239677 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Wachusett: Leroy E.Mayo   Regular School No Elementary KG 05 2018   grade_1 67 2 3 0   4     0   3   41 38                       79.0 67 2 3 0   4     0   3   41 38                 79
744929 744929 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No 1 KG 04 2015   grade_1 82 0 5 0   0     0   4   50 41                       91 82 0 5 0   0     0   4   50 41                 91

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