Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

147 lines (139 sloc) 6.209 kb
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-us" lang="en-us">
<head>
<title>YQL - Community Open Data Tables</title>
<style>
html {
height:100%;
min-height:100%;
width:100%;
}
body {
font-family:arial,helvetica,clean,sans-serif;
font-size:13px;
font-size-adjust:none;
font-style:normal;
font-variant:normal;
font-weight:normal;
color:#222;
}
h1 {
color:#008DC7;
margin:12px 0 4px 0;
font-size:300%;
}
h2 {
margin:12px 0 4px 0;
}
a {
color:#2288BB;
text-decoration:none;
}
a:hover {
text-decoration:underline;
}
.nav a {
font-weight:bold;
}
.nav {
display:block;
width:100%;
text-align:center;
margin:4px 0 40px 0;
}
.nav ul {
display:block;
}
.nav li {
color:#222;
display:block;
float:left;
padding-left:8px;
}
.nav a {
padding-right:8px;
}
.nav.header {
padding-bottom:20px;
border-bottom:1px solid #eee;
clear:both;
}
.nav.footer {
border-top:1px solid #eee;
clear:both;
}
.banner {
display:block;
}
.banner img {
vertical-align:middle;
}
.banner h1 {
display:inline;
}
h2 {
clear:both;
}
code, pre {
color:#008040;
}
h2 b {
text-decoration:underline;
}
</style>
</head>
<body>
<div class='nav header'>
<ul>
<li><a href="http://developer.yahoo.com/yql">YQL</a>|</li>
<li><a href="http://yqlblog.net">YQL Blog</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">YQL console + open data tables</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console">YQL console (built-in tables only)</a>|</li>
<li><a href="http://github.com/yql/yql-tables/tree/master">github Open Data Tables</a>|</li>
<li><a href="http://developer.yahoo.net/forum/index.php?showforum=41">YQL forum</a></li>
</ul>
</div>
<div class="banner">
<img src="http://l.yimg.com/a/i/us/pps/yql128.gif" />
<h1>Community Open Data Tables for YQL</h1>
</div>
<h2>What's <a href="http://developer.yahoo.com/yql">YQL</a>? <code>select * from internet</code></h2>
The Yahoo! Query Language (YQL) platform enables developers to query, filter, and combine data across the web. YQL exposes a SQL-like syntax that is both familiar to developers and expressive enough for getting the right data. YQL supports three SQL-like verbs:
<ul>
<li><code>SELECT</code> for fetching, combining, filtering and projecting data.</li>
<li><code>DESC</code> for describing the input fields for a table and other meta information.</li>
<li><code>SHOW</code> for getting a list of the tables/data sources supported by the language/platform.</li>
</ul>
The SELECT statement is the primary verb for YQL:
<pre>
SELECT what FROM table WHERE filter
</pre>
In addition, YQL also supports several post-query functions like sort and unique.
<h2>What are <a href="http://developer.yahoo.com/yql/guide/yql-opentables-chapter.html">open data tables</a>?</h2>
Open Data Tables are XML files that can be "plugged" into the <a href="http://developer.yahoo.com/yql/">Yahoo! Query Language open platform (YQL)</a>. These files describe how the YQL SQL-like language can be mapped onto any web service or source on internet. Once mapped, these data sources can be used by developers in many ways in YQL.
<h2>What are <b>community</b> open data tables?</h2>
While anyone can develop and share an open data table for YQL, we are encouraging the community of open data table developers to contribute their tables to the open data tables <a href="http://github.com/yql/yql-tables/tree/master">github</a> project. This makes tables much easier to find and share, and try out in the YQL console.
<h2>Why isn't this site on github?</h2>
While github is a great source control site, it's not intended to serve content quickly. datatables.org keeps a copy of the github master tree and automatically creates a single "env" file. Environment files enable the YQL console and web service to load up many open data tables from a single URL.
<h2>How can I <a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">try</a> a table in the console?</h2>
You can import <b>all</b> the current open data tables <a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">in the console</a>. This uses the <a href="http://datatables.org/alltables.env">environment file</a> hosted here. If you want a single one try the <code>use</code> verb. Read about that <a href="http://developer.yahoo.com/yql/guide/yql-opentables-import.html">here</a>.
<h2>How can I build my own tables?</h2>
A quick read of the <a href="http://developer.yahoo.com/yql/guide/">YQL guide</a> is a great starting point, in particular:
<ul>
<li><a href="http://developer.yahoo.com/yql/guide/yql-opentables-chapter.html">Open Data tables</a></li>
<li>Running your own code with <a href="http://developer.yahoo.com/yql/guide/yql-execute-chapter.html">Execute</a> in Open Data Tables</li>
</ul>
One the other easy way of working out how to do something is to <a href="http://github.com/yql/yql-tables/tree/master">look at someone else's open data table</a> that wraps a data source similar to what you want to enable.
<br/>
<div class="nav footer">
<ul>
<li><a href="http://developer.yahoo.com/yql">YQL</a>|</li>
<li><a href="http://yqlblog.net">YQL Blog</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">YQL console + open data tables</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console">YQL console (built-in tables only)</a>|</li>
<li><a href="http://github.com/yql/yql-tables/tree/master">github Open Data Tables</a>|</li>
<li><a href="http://developer.yahoo.net/forum/index.php?showforum=41">YQL forum</a></li>
</ul>
</div>
</body>
</html>
Jump to Line
Something went wrong with that request. Please try again.