Twitter status id conundrum

Posted by jamiet on SQL Blog See other posts from SQL Blog or by jamiet
Published on Sun, 18 Apr 2010 15:05:38 GMT Indexed on 2010/04/18 15:14 UTC
Read the original article Hit count: 430

Filed under:

I have an interest, a slightly perverse one some might say, in using online services and trying to figure out what the underlying (logical) data model is and in this day and age Twitter is one that lends itself very well to scrutiny. Consider this recent tweet of mine:

odata rdf tweet screenshot

The URL that enables you to see that tweet is We can interpret that URL to mean "a tweet by jamiet with an id of 12154647354" and hence we might further assume that the unique identifier for the tweet is {jamiet,12154647354}.

However, its well-known that Twitter gives each status a unique ID regardless of who tweeted it so we might expect we could reach that tweet just by using a URL of however (at the time of writing) that only redirects to Twitter's homepage. That seems strange to me especially given that we can use Twitter's API to access information about that tweet using only the id of the status. Witness

screenshot of twitter api result

[We can also access a JSON version of that information using]

I'm puzzled as to why a tweet can't be accessed using on the main twitter website using the id alone. Anyone have any suggestions?


© SQL Blog or respective owner

Related posts about data modelling

Related posts about twitter