[ddj] SQL resources
Nicola Hughes
nicola at scraperwiki.com
Tue Oct 18 15:27:51 UTC 2011
Here's a good site you can play around with for SQL which goes into
the operators:
http://www.w3schools.com/sql/default.asp
Here is a little application you can 'fork' to play around with the
relational outputs of any dataset in ScraperWiki:
https://scraperwiki.com/views/pcc_sql_query_view_2/
A general overview of the layout of ScraperWiki can be seen here:
http://youtu.be/G1uL_0Nakok
And how to an example use of the view here:
http://youtu.be/AIHN2PRGWWc
you can change the query to look at different scraper data by typing
in the name of the scraper (the stuff after scraperwiki.com/scrapers)
in the box that is currently occupied by pcc-decisions-mark-3
More information about the data-driven-journalism
mailing list