My personal fork of the original YQL Community tables. If you want to find the latest version of the YQL tables, please go to the original.
JavaScript Ruby
Pull request Compare This branch is 72 commits ahead, 724 commits behind yql:master.
Latest commit a89e3f8 Mar 25, 2012 @spier is redirected to
Trying the 2nd URL instead.
Failed to load latest commit information.
3taps added 3taps pipe Apr 15, 2011
Bungie fixed sample query for bungie.reach Nov 24, 2010
accessibility reverting two changes, so that pull requests becomes autonom Jun 14, 2011
akismet Added Akismet YQL table Feb 16, 2010
amazon added paging elements for amazon.ecs Jun 7, 2011
amee sorted out mlformed xml Sep 7, 2009
ap changing .xml paths to new branch Jan 31, 2011
apigee cleanup indentation Oct 21, 2011
apple linking to absolute path for JSON2.js Nov 22, 2010
arxiv fix Jun 19, 2010
auth also add refreshing Jan 24, 2010
basecamp add rudimentary support for basecamp to show people how Mar 16, 2010
batlas Changed descriptions Oct 22, 2010
bbc remove the use statement in the sample query Oct 6, 2010
bible Grammar correction. Oct 31, 2011
bing Added category key May 18, 2011
bitly made format a constant Nov 1, 2011
bizrate fixing bizrate example Feb 18, 2010
blabla blabla and diigo odt May 16, 2011
blackcountryhistory No commit message Jul 15, 2010
boss yahoo boss v2 yql table Apr 12, 2011
boston Adding boston.bippic table for scraping images from The Big Picture. Jul 25, 2010
brazil Updating next courses URL in Caelum's tables Aug 1, 2011
britishmuseum Changed example Jul 12, 2010
brooklyn Changed itemtype to item_type as in docs Sep 16, 2010
campfire Basic campfire table. Returns topic for a room; useful in Geckoboard. Jan 26, 2011
christies aa Oct 8, 2010
cinetelerevue Upgrade to new site layout. May 1, 2011
comicvine Added paging elements to all list calls with offset parameters for co… Oct 22, 2009
couprecoup Added a data table for Nov 19, 2010
craigslist added open table Jul 15, 2009
darkhelmet really get the host Dec 29, 2009
data complete refactoring to match the current spec Jan 24, 2012
delicious tweaks Feb 5, 2009
deviantart Changed the documenation location Jun 13, 2011
digg Renamed wrong input from medium to media Jan 12, 2011
digitalnz Removed an extraneous / Sep 16, 2010
diigo blabla and diigo odt May 16, 2011
donorschoose file deleted Apr 18, 2011
dopplr A few tweaks Feb 7, 2009
dostopsi Added data table Dec 29, 2009
ecb whitespace cleanup Dec 18, 2011
edu/wsu Fix API Endpoint. Dec 17, 2010
embedly Added embedly table Nov 9, 2010
ericssonlabs added ericsson labs apis for cellid and sms Dec 29, 2009
esme Adding warning message to esme.users.followees as deletion from this … Sep 7, 2009
etsy Etsy user favorites Mar 25, 2009
euparliament add euparliament tables May 8, 2011
eyefi Adding Oct 21, 2010
facebook Merge pull request #135 from dstricks/master Oct 6, 2011
fcc I've changed the xpath to avoid removing the attribute that defines t… Nov 12, 2010
firstnames adding a better description Jan 31, 2011
fitbit No commit message Oct 24, 2010
flickr Forgot to add the api key to too. Sep 9, 2011
flugaktiv Initial release of flugaktiv tables providing aviaition related infor… Aug 11, 2011
foursquare Added foursquare API V2. Working with OAuth 2.0 Authentication. Dec 11, 2010
freckle Fixed documentation link May 2, 2011
friendfeed fix the batching Feb 5, 2009
fun fixing Oct 29, 2010
gdacs table meta adjustment Feb 24, 2010
geo removing conflicting geo files Mar 29, 2011
github fix itemPath for github.user.commits Feb 18, 2012
google Merge pull request #166 from axl8713/master Mar 16, 2012
gov/us/usaspending adding usapsending tables Jun 17, 2009
gowalla adding basic gowalla tables Mar 2, 2010
greader New greader Mar 5, 2009
greenbookings add green bookings for a 3rd party Jun 11, 2009
guardian fixed mappings for Guardian API Nov 14, 2010
hackernews Added hackernews.submitted.xml datatable based on hackernews.frontpag… Apr 10, 2011
hatena Added Atom API table. Aug 20, 2010
huffduffer Added rule for new item search. Nov 16, 2011
ia I deleted the hia and yvoices folders and replaced them with the ia m… Mar 17, 2012
ign add ign table Nov 9, 2009
infochimps pulling infochimps Sep 15, 2010
instapaper Complete working Instapaper add API Aug 3, 2009
iplocation renaming to ip.location Dec 7, 2010
javascript adding JSON2.js Nov 22, 2010
keywordfinder fixed keywordfinder Jul 24, 2010
kiva Added <sampleQuery></sampleQuery> to empty <meta> elements; otherwise… Dec 29, 2009
klout release Jun 13, 2011
lastfm added optional from and to search dates Mar 1, 2012
levenshtein adding namespace Jun 1, 2011
limewirestore Fix cdata issue May 13, 2009
livedoor Added livedoor weather API table. Aug 11, 2010
longurl Merge branch 'programmableweb' Feb 10, 2012
md5 Adding MD5 table to yql to get the MD5 hash/checksum of any online file Mar 9, 2010
mediawikiapi Really fix paging (last page was still too big) May 19, 2009
meetup Merge commit 'upstream/master' Feb 27, 2010
mendeley updating the sample query with {table} Dec 13, 2010
mimetype added mimetype webservice Aug 28, 2009
misc adding form to table convertor Mar 4, 2010
mixi Updated mixi tables. Mar 14, 2011
movies Fixed link element in results when selecting without any input keys -… Sep 16, 2010
mozillalabs/jetpackgallery - removed unused variable Jan 14, 2010
museumoflondon Changed item paths Jun 9, 2010
mynewsdesk changed the name from partner to channel Aug 25, 2010
ncbi/entrez added esummary table Sep 17, 2009
nestoria fix a typo Apr 5, 2009
netflix get around a bug where oauth.js assumes a browser is running the code Nov 25, 2009
newegg strip whitespace Dec 2, 2010
nextbus Update the url for NextBus web services Mar 8, 2012
ngmoco Adding We Farm facets Aug 2, 2010
nmm Added parameters to limit search by year Dec 29, 2009
nmsi Table for the Science Museum mashup competition. Dec 29, 2009
noaa Add last categorical level HIGH Apr 24, 2010
npr make the sample query for npr stations more terse May 28, 2010
nyt proper itemPath for NYT NewsWire API Feb 28, 2009
oauth fix oauth post issues Sep 2, 2010
olympics winter olympics medals Feb 18, 2010
openaustralia adding open australia Oct 21, 2009
opencalais initial version of opencalais Mar 28, 2010
opencontext Added Opencontext api table Jul 6, 2010
openid now setting test table via request param May 27, 2010
opensocial fix the itemPath and response object. add a sample query. May 12, 2009
paypal adding new transaction search and details tables for PayPal Oct 15, 2010
peerindex updated documentation Feb 25, 2012
pikchur added new pikchur feed table Mar 23, 2010
pivotal Basic Pivotal Tracker table. Useful for bugs/chores/features red/ambe… Jan 26, 2011
plos plos alm table added Nov 7, 2009
powerhousemuseum Updating all sample queries to use the {table} syntax Mar 31, 2011
presseportal finalizing (ch version could be integrated too) Dec 18, 2011
prlog reverting two changes, so that pull requests becomes autonom Jun 14, 2011
programmableweb minor cleanup Feb 4, 2012
pubsubhubbub Added a simple pubsubhubbub publishing client Sep 7, 2009
quickbase add insert/update/delete to quickbase Jul 15, 2009
readabilitySAX Deleted node url module Nov 30, 2011
recovery adding 7mary4 changes Nov 3, 2010
regex add ign object service Nov 9, 2009
rtm CRLF fix. Nov 14, 2010
salesforce salesforce bug fix May 28, 2009
seafoodwatch Remove unnecessary .env file Dec 8, 2010
search Add a paging model to search.imageweb Jun 5, 2009
sears Adding new tables for Sears Developer Network Feb 28, 2010
seomoz updating ParamTypes Jun 18, 2010
shelfari shelfari friends table Aug 23, 2010
shipping - Changed XML select itemPath Feb 16, 2010
shopping add salesforce, tweak a couple of yahoo ones May 27, 2009
shoppingcart Updated REST API endpoint and added some required variables Aug 5, 2010
silobreaker .env file Jul 24, 2011
simplegeo Merge branch 'master' of Apr 18, 2010
slideshare Merge remote branch 'chesterbr/master' May 11, 2010
smushit Refactoring smushit table, removing unnecessary complexity as the tab… Mar 9, 2010
social sample tables from the blog post May 3, 2009
socialgraph push the initial url as a trusted url Jun 29, 2009
socialinfluence changing response type to XML Jun 25, 2011
socialmention changing the required value to false for "lang" Dec 13, 2010
songkick Adding api tables Feb 26, 2012
soundcloud Added soundcloud groups and playlists. Jun 7, 2011
sparql Import from and… Mar 4, 2010
spotify use the {table} var. Jan 15, 2011
steam fixing sample queries for steam open table Mar 6, 2011
sunlight refine results path, make apikey required Apr 22, 2010
sux Added SUX - Short URL eXpander table for SUX.js util Jan 22, 2012
tarpipe Adding test content. Aug 3, 2009
text adding text table Apr 11, 2010
themoviedb Adding new tables for Feb 28, 2010
thesaurus Change table name to be dynamic. Jun 9, 2010
thetvdb Updating paramTypes May 29, 2010
timeout Added Open Data Table for Time Out London Search Mar 14, 2010
tinysong updated sample query Sep 9, 2011
tmdb added example of manipulating query results in an execute block Jul 27, 2010
topsy trying authorsearch Jun 23, 2011
trygger Updating Nov 28, 2011
tumblr adding new tumblr tables Mar 2, 2010
tvrage Adding tvrage Oct 20, 2010
tweetmeme Adding tweetmeme url unshortening api's Dec 29, 2009
twfy Put key in quotes Sep 16, 2010
twitter Merge pull request #136 from spier/twitter Oct 6, 2011
ukgeocode Migrated to subdomain running faster web server, so updating Jun 19, 2010
uknutritionals Adding datatable for UK composition of food data, courtesy of OPSI Apr 10, 2010
ukparliament Added UK Parliament members and constituencies Apr 10, 2010
ukpostcode Changed parameter to lng Sep 16, 2010
urbanesia Changed Google Seaarch default language from French to English. Aug 3, 2010
url use method for url.status Aug 28, 2011
usgs fixed usgs.waterquality url and sample query Dec 29, 2009
victoriaandalbert Changed colon for semi-colon Sep 16, 2010
vimeo Removing Vimeo video search - not possible to have it on YQL due to V… Sep 29, 2010
w3c added more query samples Apr 20, 2011
weather paramType should be path vs. query. Dec 14, 2010
webdav added propfind and get handlers Feb 10, 2010
wefeelfine minor update Oct 15, 2011
wesabe add support for one of wesabes public apis Feb 9, 2009
whitepages add whitepages support. you will need an api key for this. Feb 10, 2009
wikileaks Adicionando Wikileaks Jun 7, 2011
wordpress Changed to use HTTP method supported by Wordpress (POST instead of PUT). May 23, 2011
worldbank fixed broken links Dec 1, 2010
wuala change wuala example query Oct 14, 2009
wufoo fixed sample queries Nov 29, 2010
wunderground Weather Underground Nov 14, 2010
yahoo Update yahoo/finance/ Mar 21, 2012
yahoojp Added Chiebukuro APIs tables. Feb 26, 2011
yahoovoices I deleted the hia and yvoices folders and replaced them with the ia m… Mar 17, 2012
yelp add a yelp search table Feb 17, 2009
ygroups All these files have changed documentationurl entries May 15, 2011
youtube adding youtube.user.videos Feb 29, 2012
yui Added md5 table created by @miraglia May 3, 2010
zillow adding zillow search api Feb 14, 2009
zugmonitor is redirected to Mar 25, 2012
.gitignore Ignore DS_store. Dec 29, 2009 minor fixes May 28, 2011
Rakefile adding new PeerIndex call: profile/show Feb 25, 2012
alltables.env recovering my own environment file Jan 31, 2011
alltables_forked.env Adding new .env file for newly merged in tables. Mar 22, 2012
index.html Update index.html Dec 20, 2011
table.xsd some handy rake tasks for YQL table creation Jul 24, 2011 Edited via GitHub Sep 10, 2011

My Personal Fork of the YQL Datatables


This is my personal fork of the original YQL open data tables. If you want to find the latest version of the YQL tables, please go to the original.

What is YQL?

From the Yahoo's YQL website:

The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint.

Why do you have a personal fork?

I am a YQL enthusiast. I love the general idea and also the current implementation (for the most parts). The Open Data Tables are great but sometimes a bit slow when it comes to incorporating recent updates. Therefore I am using this repository as my personal playground. I pull the latest changes from the YQL Community tables as I need them but at the same time I can always do random experiments here without being depended on the original repository.

YQL issues

As I said, YQL is great. As any piece of software it also has some flaws (as in bugs) and some other things that I just don't like that much, which is more a matter of personal taste. Also there are some areas of YQL that I just don't understand.

Therefore I am sometimes collecting some thoughts about YQL on Twitter. See some examples below. I am happy to learn more about them or discuss with anybody who is interested in YQL.

  1. How to keep a given API and the corresponding datatable in sync as API gets updated?
  2. How to measure the "coverage" of a datatable, meaning how many calls of an API are implemented by the datatable? #in
  3. How to introduce and maintain naming conventions for the naming of "keys" across different datatables?
  4. Would be great to access usage stats for datatables that I did, to see how people use them. #optimization #motivation
  5. How to search for existing community datatables? The console is fine but could be better.
  6. Why can I not access/use values from a Sub-Select besides using the IN-syntax? Would allow for richer queries.
  7. How to test datatables, e.g. to be notified when the underlying API changes or gets deprecated like
  8. The error messages are just not clear :( Except this one of course "Yahoo! - 999 Unable to process request at this time"

YQL Resources