Qodex.ai

Querying Data-Select Queries

Number of APIs: 4

  1. Ohio COVID cases for males 50+ GET https://covid19.richdataservices.com/rds/api/query/us_oh/oh_doh_cases/select?count=true&where=(sex=1) AND (age_group=50 OR age_group=60 OR age_group=70 OR age_group=80)&metadata=true

  2. Build your own select query GET http://host/api/query/{catalog}/{dataProductId}/select?collimit=&lt;integer&gt;&amp;coloffset=&lt;integer&gt;&amp;cols=&lt;string&gt;&amp;count=&lt;boolean&gt;&amp;format=&lt;format enum>&groupby=<string array>&inject=<boolean>&limit=<number>&lock=<string>&metadata=<boolean>&offset=<number>&orderby=<string>&weights=<string array>&where=<string>

  3. Visualize positive and total COVID-19 tests per state GET https://covid19.richdataservices.com/rds/api/query/us/covidtracking_state/select?where=(us_state_postal=NY OR us_state_postal=CA OR us_state_postal=TX) AND (date_stamp=2020-06-17)&cols=us_state_postal,cnt_tested_pos,cnt_tested&format=amcharts

  4. Visualize COVID-19 cases over time in the U.S. GET https://covid19.richdataservices.com/rds/api/query/int/jhu_country/select?cols=date_stamp,cnt_confirmed,cnt_death,cnt_recovered&amp;where=(iso3166_1=US)&amp;format=amcharts&amp;limit=5000