Restaurant Inspection Scores

Data can be found here: http://apps.lanecounty.org/RIS/

1. To get at the data just click search without filling in any fields
2. Copy and paste HTML table into a Google spreadsheet or Excel
3. Download/save as a CSV
4. Open in Sublime or preferred text editor
5. Replace each \n" with ;
6. Replace each " with nothing
7. Replace each \n with ,
8. Replace each ; with \n
9. Replace each ,\s with \s

You should be left with a clean, CSV-formatted text file. Feel free to add in the table head values or do that back in Google Drive or Excel. Import to Fusion Tables and use the marker buckets. Make sure to "use these values" so that the 100 scores are included.

To do: Create Sublime Text macro to clean data