Qodex.ai

Querying Data-Tabulate Queries

Number of APIs: 4

  1. Tabulate confirmed cases, across gender and age in Canada. GET http://covid19.richdataservices.com/rds/api/query/ca/ca_statcan_cases/tabulate?dims=gender,age_group&measure=COUNT:COUNT(*)&format=amcharts&inject=true&orderby=gender ASC, age_group DESC

  2. Visualize confirmed cases in 2020 for Canada, China, Spain, Italy, and USA GET https://covid19.richdataservices.com/rds/api/query/int/jhu_country/tabulate?dims=date_stamp,iso3166_1&where=(year_stamp=2020) AND (iso3166_1=US OR iso3166_1=CA OR iso3166_1=ES OR iso3166_1=IT OR iso3166_1=CN)&measure=cnt_confirmed:SUM(cnt_confirmed)&inject=true&metadata=true&orderBy=date_stamp ASC,iso3166_1 ASC&totals=true&format=amcharts

  3. Confirmed cases per day in NY & Kings counties GET https://covid19.richdataservices.com/rds/api/query/us_ny/ny_doh_tests/tabulate?dims=date_stamp,us_county_fips&where=(date_stamp>=2020-03-01) AND (us_county_fips=36061 OR us_county_fips=36047)&measure=cnt_confirmed_new:SUM(cnt_confirmed_new)&inject=true&metadata=true&orderBy=date_stamp ASC,us_county_fips ASC&totals=true

  4. Build your own tabulate query GET http://covid19.richdataservices.com/rds/api/query/{catalog}/{dataProductId}/tabulate?count=<boolean>&dims=<string>&format=<formatEnum>&groupby=<string>,<string>&inject=<boolean>&limit=<number>&measure=<string>&metadata=<boolean>&offset=<number>&orderby=<string>&totals=<boolean>&weights=<string>,<string>&where=<string>