Data from Socrata

Socrata is the company that powers Somerville's open data portal. This site contains several of the datasets that are of most interest to the public. Data can be accessed and visualized online, or downloaded in any major format.

The following example is a real-time breakdown of work order data from DPW. This format makes it possible to see the percent of work orders that are completed on time side-by-side with the total number of work orders that are submitted via 311:

Powered by Socrata

This example drills down into one of the several work orders that are included above.

Powered by Socrata

The open data portal also contains financial data, results from the happiness survey and much more.

Data from Other Internal Sources

SomerStat Data
SomerStat is the performance management arm of city government that facilitates regular data-driven meetings between the Mayor and his department heads to help them make informed decisions, implement efficiencies and improve city services. More information about SomerStat is available on the City's webpage.

Budget Data
During the budgeting process for fiscal year 2011, ResiStat took a lead role in informing the public and gathering opinions about the proposed budget. It was a difficult year for the City, which faced a $12 million shortfall. Find out more on our "Budget" page.

ResiStat 2.0
A Harvard Kennedy School Master of Public Policy candidate completed his Policy Analysis Exercise (PAE) on Somerville's ResiStat program. The report looks at input from residents (using an online survey that you may have participated in), as well as information from City staff, and from the observation of a ResiStat community meeting. It provides both an in-depth look at how the program currently works, and recommendations on how to move forward in the future.

Crime Data
Data on crimes reported in Somerville over the past six months is available through and the Somerville Police Department. Information is available on crimes by type, time period, and location down to the street level.

Mayor-for-a-Day Exercise
Residents were invited to work with data that City officials used this spring to make budget decisions. Feel free to try the exercise yourself. The PowerPoint attachment explains the decision areas available for discussion and the Excel sheet shows the analysis City officials undertook. Also attached below are comments from participants.
PowerPoint Decision Area Explanation
Data Analysis Exercise
Feedback from Participants

Resident Survey Data
Somerville has conducted multiple surveys to solicit feedback and input from its residents. Results and analysis of some recent surveys can be found below.
FY10 Resident Budget Survey
2006 Resident Survey

Data from External Sources

The Census has data on the City's demographics, economy, and social make up, as well as many other interesting statistics about the City.

City-Data, the social networking and information site, has an impressive database on Somerville.

Massachusetts Department of Revenue has a useful website with tons of data regarding state and local budgets, especially in the 'Municipal Data Bank' section.

The Massachusetts Department of Education has some great data online concerning individual public schools as well as broader school districts.

The FBI has detailed spreadsheets documenting crime in every county of each state, and can provide some interesting information.

The Boston Metropolitan Area Planning Council has put together a fantastic website that details new developments in the Greater Boston area, and its data section has some wonderfully fresh ideas and analyses.