of the victims rights law known as Marsy’s Law was allowing police agencies to hide public crime data. Also in 2020, SpotCrime won a FOIA appeal in Harrisburg, Pennsylvania. SpotCrime requested blotter information, but the city of Harrisburg denied the request claiming that records do not exist, it does not possess the requested report, and is unable to create such a report by extracting information from its database. SpotCrime appealed to the Pennsylvania Office of Open Records (PA ORR) on the basis that the data is available in the city’s database and is therefore public information. The PA OOR appeal office noted that “to the extent required information exists in a database, it must be provided; an agency cannot claim otherwise under Section 705 of the RTKL…Information contained within an agency’s database is subject to public access regardless of the agency’s difficulty in retrieving the information” and granted SpotCrime’s appeal for the public data. In 2021, the city of York, Pennsylvania denied SpotCrime’s request on the same grounds as the city of Harrisburg denial. The PA OOR appeals office ruled again in SpotCrime’s favor and the city of York released the data. In 2022, the city of York then stopped providing the data file, pointing SpotCrime to a third party private website with a terms of use and no ability to download the data SpotCrime was seeking. SpotCrime appealed this denial and the PA OOR appeals office ruled in SpotCrime’s favor again, noting that “the City has not shown that it is unable to extract the requested information from the city’s contracted RMS/CAD vendor, especially since the city’s vendor shares the same information with a third party private website”. Legislative testimony on access to public data SpotCrime has provided testimony on open data and FOIA laws in the US. In March 2014, SpotCrime provided written and verbal legislative testimony on Maryland Open Data Bill (SB644) advocating for open and public data in Maryland. The bill was passed in April 2014. In 2022, SpotCrime provided written testimony on Kansas FOIA SB386 advocating for equitable access to open and public crime data under FOIA in relation to FOIA fees assessed in the state of Kansas. Open crime data transparency ranking In 2013, SpotCrime created a periodically updated transparency ranking for public crime data across the US. SpotCrime ranked many of the major cities around the nation on a scale of 0 to