As stated in the note from the Sunlight Foundation′s Board Chair, as of September 2020 the Sunlight Foundation is no longer active. This site is maintained as a static archive only.

Follow Us

Tag Archive: Guest Blog

OpenGov Voices: FreedomHack: A Hackathon for Good

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are Barrett_Holmes_Pitner_headshottheirs alone and do not reflect the opinions of the Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.

Barrett Holmes Pitner is the Senior Global Editor, Cont3nt.com (one of the organizers of the FreedomHack. You can reach him at barrett@cont3nt.com @barrettpitner

This weekend, August 10-11, coders, hackers, policy experts and journalists will spend 24 hours at a hackathon feverishly working together to develop tools and products that will help those living in the most dangerous parts of the world tell their stories. This is FreedomHack.

FreedomHack 1 We have all been to hackathons and witnessed how the combination of energy, enthusiasm, intelligence, creativity and technical expertise consistently results in products that could take months to conceive in a traditional corporate structure. We understand how removing the monotony of “work” from the equation and replacing it with “fun and passion” can create brilliant results, and this is what we aim to achieve this weekend.

When the organizers of FreedomHack conceived the idea, it was just a handful of us in a room trying to figure out the best way to help these communities. A hackathon clearly rose to the top because of its inventive, spontaneous and fun structure.

From the onset, we have always referred to FreedomHack as “a hack for good.” FreedomHack will allow every participant the opportunity to have fun and work hard over one weekend for the benefit of people who live in embattled communities who desperately need your expertise.

This hackathon will focus on developing secure tools and products for those who live in parts of Mexico that have been overrun by cartel violence and human rights related issues. Citizen reporters and journalists regularly face threats on their lives and at the very least, censorship on the vital topics they are reporting.

Register for the FreedomHack hackathon.

Continue reading

OpenGov Voices: PySEC, bringing corporate financial data to the masses

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone andLuke Rosiak do not reflect the opinions of the Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.

Luke Rosiak is a former Sunlight Foundation reporter and database analyst who now writes for the Washington Examiner. This post addresses the tooling around Extensible Business Reporting Language and provides recommendations on what needs to be done. You can reach Luke on Twitter at @lukerosiak.

In the early 1990s, long before most federal agencies had embraced the digital era, the Securities and Exchange Commission (SEC) undertook a truly “big data” initiative that showcased some of the best that open data had to offer: Its quarterly reports were uploaded in real time, in text, rather than PDF, format, to a public FTP server called EDGAR. (File Transfer Protocol or FTP is a standard network protocol used to copy a file from one host to another over a network.)

Like with the Federal Election Commission, the companies submitted their own reports, but they immediately entered the public record, and it was the government who required the submissions, dictated the forms and made them available.

EDGAR, which was implemented in part by Sunlight Foundation supporter Carl Malamud, revolutionized a massive industry of financial watchers who used the reports to decide what companies to invest in--and which to dump. Firms like Bloomberg and Reuters processed the text files into structured data, and analysts pored over them.

washington times imageAnd before long, the SEC was pushing the ball even further, with talk of XBRL or Extensible Business Reporting Language. After all, financial information was almost entirely numbers-based, lending itself to computer analysis, and was fairly structured, with accountants all using a core of the same carefully-defined terms--though Wall Street accounting is too complex to fit in simple columns and rows, necessitating nested structures and the ability to dynamically define new terms.

The X in XBRL was a double-edged sword there. XBRL’s power, advocates said, was derived from its flexibility. It was a unified language that could express financial ideas whether the company was trading goats in Ethiopia or derivatives in Manhattan. To provide that kind of flexibility, it allowed accountants to define their own terms in financial documents, extending from a base of agreed-upon terms, in America called the US-GAAP.

But the US-GAAP itself had thousands of terms, and accountants who were accustomed to filing paper reports never bothered to learn its structure. Lazy filers created their own custom terms when buried somewhere in the GAAP, there was already a universal term that meant the same thing. That defeated the purpose of structured reporting, because it made comparing across companies impossible.

Continue reading

OpenGov Voices: Improve voter experience in NYC — Come to the Voting Information Project Hackathon!

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone and do not reflect the opinions of the Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.J.Marcotte

Jared Marcotte is a manager for The Pew Charitable Trusts Election Initiatives. Recently, as a senior engineer at the New Organizing Institute, Jared worked on the Voting Information Project -- a collaboration with state and local officials, Google, Microsoft and Pew to develop and populate an open API and database of election-related information for all 50 states. Jared is also an interface and interaction designer and has worked on the Election Protection Coalition’s Our Vote Live and KCET.org.

Casting a vote is the most basic way we participate in our democracy, and effective election systems are fundamental to that participation. But in many cases, finding the information you need to cast your ballot – where your polling place is, what’s on your ballot, and what you need to bring with you – is not as simple as it should be. The Pew Charitable Trusts’ Voting Information Project (VIP) works to improve the voter experience by providing up-to-date election information where voters are most likely to look for it - online. Like everything else today, when people want information the web is the first place they look. VIP brings election information directly to the voter by allowing states to expose official election data such as polling locations, registration deadlines, and ballot information on various mediums and platforms like the web and mobile.

Modern voters expect online tools to help them cast an informed vote, and VIP is here to provide new platforms to enhance their experience. On August 2-3 we are hosting our first-ever New York City hackathon at AlleyNYC in midtown Manhattan. The event will bring together 150 developers, designers, and usability experts to generate socially innovative applications that can improve the voting experience in New York City for the 2013 primary and general elections, including the mayoral race.

We’ll be capping the registration at 150 so register today!

Screen Shot 2013-07-22 at 2.47.43 PM

Continue reading

OpenGov Voices: Open Data in Latin America: Here to stay

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone and Fabriziodo not reflect the opinions of the Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog. Fabrizio Scrollini is currently working on a PhD on transparency and accountability in Latin America at the London School of Economics and Political Science. He co-founded DATAuy which supports Quesabes -- the first website in Uruguay that helps citizens request for public information from their government. DATAuy has also championed open government, open parliament, and transparency in Uruguay by collaborating with other NGOs in the region and organizing hackathons. Two weeks ago Uruguay, a small Latin American country, had the pleasure of hosting open data and transparency activists from different corners of Latin America and the world for the first Latin American open data unconference. ABRELATAM (named after a plan on the Spanish word “abrelatas,” which means can opener), was organized by DATA Uruguay and Ciudadano Inteligente from Chile in a pioneer partnership to advance transparency and open data in the region. In this post I would like to share with you a snapshot of the awesome discussions that took place at the ABRELATAM. Uruguay TCamp 1Community matters. This is hardly a surprise but community can mean different things. Indeed people are interested in open data for all sorts of reasons, but when it comes to a particular area or group of datasets, and the aim is social change, the need for different skills and common goals becomes crucial. Some of the greatest sessions were about how to link the different worlds of technology, communication, policy and social problem solving. Open data (or the lack of it) is sometimes a great excuse to put minds together working to achieve better outcomes. People working together (not just data) will deliver change, and this is done online, but offline engagement is crucial as well. Communities need to be expanded to involve more people and organizations who can also help to promote open data and use it for their own ends.

Continue reading

OpenGov Voices: Bringing Senate Campaigns into the 21st Century

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone. Sunlight Foundation is not responsible for the accuracy Jon Testerof any of the information within the guest blog.

Jon Tester is the junior Senator from Montana. He and his wife, Sharla, still farm the 1,800 acres his grandparents homesteaded in 1912.

With the NSA’s secrets spilling into the news, folks around the country – including U.S. Senators – are demanding more transparency and accountability from the federal government. I fully support these calls for reform.

Transparency matters in the legislative branch, too. My fellow Senators must not neglect their own backyards. My colleagues need to hold themselves accountable to the American people and join me in lifting the veil that hides how Senators and Senate candidates report the money that funds their campaigns.

The Senate’s reporting system is stuck in the Dark Ages, and it’s hurting our democracy.

Continue reading

OpenGov Voices: Local Government Financial Transparency: Scaling It Up

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone and do not reflect the opinions of the Joffe_Headshot_1Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.

Marc Joffe is the founder of Public Sector Credit Solutions (PSCS) which applies open data and analytics to rating government bonds. Before starting PSCS, Marc was a Senior Director at Moody’s Analytics. You can contact him at marc@publicsectorcredit.org.

Groups like OpenOakland and Open City have done some great work in making local government financial data more accessible. Machine readable data sets and visualizations help citizens better understand how their tax money is being used.

Because these efforts typically require volunteers and/or visionary political leaders, they tend to focus on individual governmental units. Since the U.S. has some 80,000 local governments, it is unlikely that these standalone projects will give us anything like nationwide transparency of local government fiscal data. Building a nationwide open data set would be very beneficial because it would allow users to compare their city or county to comparable units across the country. It could answer such questions as “how does our public safety spending stack up against other cities with similar population and crime rate?” It could also allow us to compare the fiscal condition of cities in order to see which are headed in the direction of Detroit, Harrisburg, San Bernardino and Stockton – toward bankruptcy.

ca_credit_scoring_mapA Mountain View California based company, OpenGov.com, is working with several local governments to place their fiscal data online, in graphical form. If successful, this firm could greatly increase the amount of open government financial data – for those governments that are willing to subscribe to their transparency service.

But what about situations in which a local government is unwilling to cooperate and volunteers are unavailable? This universe is likely to include some of the more fiscally irresponsible governments in places that lack tech-savvy, engaged citizens.

In these cases, we can collect and report data on behalf of those governments. Recently, my group, Public Sector Credit Solutions, collected legally mandated financial reports from 260 city governments in California. We extracted standardized data from these reports and placed the information online for free here. We’d love to work with other groups to roll out this type of fiscal transparency to other types of local governments (like counties and regional transportation districts) and to the rest of the country.

Continue reading

OpenGov Voices: Hack the Budget! (or try to)

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone and do not reflect the opinions of the Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.

This is a guest post from Anthony Holley, a member of the intrepid Hack for Western Mass team that spent the weekend of June 1 trying to track money reported in USASpending.gov back to the federal budget. Anthony is a writer living and working in Amherst, MA. He is interested in helping good non-profits grow so that they can do their best work.

Advocacy groups like the Sunlight Foundation and National Priorities Project have long lamented the state of data gathered on USAspending.gov, which remains the key, searchable data repository for those interested in learning about and educating others on our federal spending. Individual federal agencies are responsible for reporting their expenditures to USAspending.gov in the interest of contributing to an open, transparent government. A working group at the Western Massachusetts Civic Day of Hacking sought to reconcile the information on USAspending.gov with the information in the budget appendix, published by the Office of Management and Budget (OMB), keeping in mind that true transparency means being able to track expenditures from the budget to USAspending.gov. A group of computer programmers, data managers, and political activists got together to work on this problem over the weekend of June 1 and 2. What we found was that this goal was at least very difficult, and perhaps impossible, to achieve.

We started by looking at the data on the OMB website to see if we could parse it for useful identifiers that we could then match up with the data on USAspending.gov. The data on the OMB website turns out to be particularly user unfriendly for these purposes, presented in XML and PDF formats that are not easy to search by category. Each section of the budget has a Treasury ID, so we took that as our starting point for trying to match expenditures listed on the budget with USASpending.gov.

Hack for Western Mass

Hack for Western Mass team. Photo credit: Molly McLeod

Continue reading

OpenGov Voices: Keeping Tabs on Your Local City Council with Councilmatic

by

Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone and do not reflect the opinions of the Sunlight Foundation or any Derek Ederemployee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.

Derek Eder is a co-founder of Open City, a group of volunteers in Chicago that create apps with open data to improve citizen understanding of our government through transparency, and owner of DataMade, a civic technology and open data consultancy.

City councils shape nearly every aspect of city life, from what kind of canopy you can have on a storefront, to how much we pay in taxes, to the number of cops on the street.

Unfortunately, it is hard for citizens to keep tabs on what their city council is doing. A few years ago, if you wanted to be informed about a city council’s actions, you had to go to the clerk’s office and page through the hundreds or thousands of bills that were added or updated every month.

In recent years, many city clerks have taken a big step forward by publishing this legislation online. However, the current generation of municipal legislative information systems are mainly built to help councilmembers and clerks’ offices manage legislation. They were not built to help the public to understand what their city council is doing.

Well, like so many of our problems, now there’s an app for that: Councilmatic.

Chicago Councilmatic 1

Continue reading

CFC (Combined Federal Campaign) Today 59063

Charity Navigator