[Developers] Flash Data Mob #2: Spinoffs

Alec Flett alecf at metaweb.com
Mon Apr 23 17:23:02 UTC 2007


I found this really cool page on Wikipedia:
http://en.wikipedia.org/wiki/List_of_television_spin-offs

This is a whole list of all the shows that have spun off of other shows.

Many people have been painstakingly editing this page to keep this 
accurate and in sync with their respective articles, but this is an area 
where Freebase really shines - once the data is in there, it's entirely 
possible to render this page programmatically.

So the challenge here is a two parter - one for the TV geeks to enter as 
much of this data as possible, and one for some MJT hackers.

Here are the details:
1) Look through this list and find at least 5 shows with spin-offs, and 
connect them up in freebase. Just search for their titles in the search 
box that's on every freebase page. I've already hooked up the Happy Days 
chain (who knew Happy Days itself was a spin-off?)
http://www.freebase.com/view?id=%239202a8c04000641f80000000001379b3

To get you started, here are a few of the more interesting "roots" of 
these spinoff trees.. you'll find some real gems even if you don't 
recognize the root show...

Looney Toons: 
http://www.freebase.com/view?id=%239202a8c04000641f8000000000062641
Sam and Friends: 
http://www.freebase.com/view?id=%239202a8c04000641f80000000003fccf6
Broadway Open House: 
http://www.freebase.com/view?id=%239202a8c04000641f800000000019716d
Cheers: http://www.freebase.com/view?id=%239202a8c04000641f800000000000e101
Diff'ren Strokes: 
http://www.freebase.com/view?id=%239202a8c04000641f800000000005bbc2
Law & Order: 
http://www.freebase.com/view?id=%239202a8c04000641f800000000013b473
(and yeah, we're fixing that '&' problem!)
All in the Family: 
http://www.freebase.com/view?id=%239202a8c04000641f800000000012d68a


2) The MJT challenge see if you can render the equivalent of the 
Wikipedia page with MJT. This is a good test of MQL and MJT - how easy 
is it to query AND render this multi-level hierarchy? This is 
potentially a weak part of MQL, but I'd love to see how some creative 
folks approach the problem.

Alec





More information about the Developers mailing list