title: Using Socrata SODA API to query most recent rows by datetime
body: <p>I am new to this site and this is my first question.  I am trying to query the "Seattle Real Time Fire 911 Calls" database from the Socrata Seattle Open Data site: <a href="https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj" rel="nofollow">https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj</a>.  I'm not an expert at using the SODA API, and I'm having difficulty figuring out how to query the most recent entries in the database.  All attempts to use the "order" or "where" SoQL statements give me data from 2010 or 2011, and I cannot figure out how to query the most recent 300 entries.  Querying the "top" rows yields the oldest entries.  Using a full OData feed pull yields data as recent as today, but I need to use a fast json or csv SODA API query.</p>
  
  <p>Note: The datetime field does not respond to any "where" statements that I use.</p>
  
  <p>Thank you!</p>