Structured Query Language (SQL) Press RUNSQL to execute commands
SHOW TABLES
Delimiter:
Comments and Instructions (instructions will overwrite content)
Put queries in upper text area and you can paste old queries in lower text area. However be aware that if you use the helper links at the bottom of this page they will replace contents of both text areas and you will lose that content forever. 'SHOW TABLES' is a MYSQL command. It will give you a list of all of the tables in the database. If you have any additional questions please feel free send me your question in an email. If you don't wish to learn SQL you can download the CSV files available at the bottom of the page. I won't guarantee the accuracy of this data. I'll just say that I tried to reproduce the data from the Lakewood Ledger as accurately as I can with the two exceptions of deleting embedded single & double quotes. However, before you draw any conclusion you may wish to compare your results with data taken directly from the Lakewood Ledger.
Lakewood Ledger Data in a Searchable Database
(Email Natalie)
Clear Comments
show tables
describe
Searching on various terms that might be in the description field.
Search on a different set of terms that might be in the description field.
Two Queries that do almost the same thing.
Monthly Downloads (csv)