SODA date range match

Justin Hewitt shared this question 2 years ago

How do i form a URL that allows a report to track a date range or isolate on a date range ?


Searching a date range across any of the SODA datasets that expose a date field is

via a where clause.


NY Inmates for Month of March


Parameter $where=admitted_dt%20between%20%272017-03-01T00:00:00%27%20and%20%272017-03-31T23:59:59%27

In the above example

• Where, between, and = selection clause

• admitted_dt = unique date field for the NY inmate dataset; in other datasets, the date

fields will be named differently

• %20 = a space character

• %27 = single quote character

Working URL$where=admitted_dt%20between%20%272017-03-01T00:00:00%27%20and%20%272017-03-31T23:59:59%27