Samples of using YQL with PeerIndex API

peerindex1.xml

<profile>
	<name>Sebastian Spier</name>
	<twitter>sebastianspier</twitter>
	<slug>sebastianspier</slug>
	<known>1</known>
	<authority>35</authority>
	<activity>34</activity>
	<audience>31</audience>
	<peerindex>34</peerindex>
	<url>http://pi.mu/i2VL</url>
	<topics>
		<topic>open source</topic>
	</topics>
</profile>

peerindex2.sql

SELECT * FROM peerindex.profile WHERE id='sebastianspier'

peerindex3.sql

SELECT * FROM twitter.users WHERE id='sebastianspier'

peerindex4.sql

SELECT created_at, from_user, text 
FROM twitter.search 
WHERE q="PeerIndex" AND rpp="5"

peerindex5.sql

SELECT name, twitter, peerindex 
FROM peerindex.profile 
WHERE id IN (
    SELECT from_user
    FROM twitter.search 
    WHERE q="PeerIndex" AND rpp="5"
) 
| sort(field="peerindex", descending="true")

peerindex5.xml

<results>
     <created_at>Tue, 26 Jul 2011 21:19:29 +0000</created_at>
     <from_user>Mike_Rossetti</from_user>
     <text>Tweet frequency has been inversely proportional with this account's PeerIndex. #socialinfluence</text>
 </results>
 <results>
     <created_at>Tue, 26 Jul 2011 21:04:13 +0000</created_at>
     <from_user>focus2grow</from_user>
     <text>RT @pamelamuldoon: I've just claimed my @PeerIndex profile, check it out http://t.co/KMt6Dox</text>
 </results>
 <results>
     <created_at>Tue, 26 Jul 2011 20:54:28 +0000</created_at>
     <from_user>dfolwell</from_user>
     <text>Cool site @Peerindex Check out your score compared to others? http://t.co/DsIKmnm</text>
 </results>
 <results>
     <created_at>Tue, 26 Jul 2011 20:50:10 +0000</created_at>
     <from_user>benri</from_user>
     <text>I've just curated a group on Design featuring @creativehat (3) @fcircunflexo (11) @art21web (19) see it here http://t.co/bag6Mgu</text>
 </results>
 <results>
     <created_at>Tue, 26 Jul 2011 20:37:21 +0000</created_at>
     <from_user>beth_tk</from_user>
     <text>RT @azeem: PeerIndex is looking for a Data engineer http://t.co/XAd0pMq &amp;amp; a Senior Data Scientist http://t.co/lFnldfb - free cookies! pls RT</text>
 </results>

peerindex6.sql

SELECT name, twitter, peerindex 
FROM peerindex.profile 
WHERE id IN (
    SELECT from_user 
    FROM twitter.search 
    WHERE q="PeerIndex" AND rpp="5"
) 
| sort(field="peerindex", descending="true")

peerindex7.xml

<results>
    <json>
        <peerindex>51</peerindex>
        <twitter>benri</twitter>
        <name>Benoit Richard</name>
    </json>
    <json>
        <twitter>focus2grow</twitter>
        <peerindex>37</peerindex>
        <name>Teicko Huber</name>
    </json>
    <json>
        <twitter>beth_tk</twitter>
        <peerindex>28</peerindex>
        <name>Beth Holmes</name>
    </json>
    <json>
        <twitter>Mike_Rossetti</twitter>
        <peerindex>18</peerindex>
        <name>Mike Rossetti</name>
    </json>
    <json>
        <twitter>dfolwell</twitter>
        <name>David Folwell</name>
    </json>
</results>