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
This request demonstrates how RDS can automatically generate a count of all of the records that meet our criteria. In this data set from the Ohio Department of Health, we are able to zero in on a specific demographic of cases: individuals who are male and age 50 or older. Try out this query in the RDS Explorer.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
count | boolean | Receive a count of the records. This will be displayed as rowCount in the returned "info" object | |
where | string | Using the AND and OR operators, we are telling RDS that we want records where the sex is male and the age falls into one of our specified age groups. |
We can see the codes for thes age group classification by sending the following request. Note that you will need to use the code'scodeValue property and not thename property when querying. http://covid19.richdataservices.com/rds/api/catalog/us_oh/oh_doh_cases/classification/age_group/codes |
| metadata | boolean | | This tells RDS to return information about each of the variables in the records to give more context to the data. |
RESPONSES
status: OK
{"info":{"cached":false,"columnCount":8,"columnOffset":0,"end":"2020-06-18T15:39:06.511Z","includeMetadata":true,"moreColumns":false,"moreRows":true,"notes":[],"postQueryTime":8,"preQueryTime":58,"queryTime":78,"rowCount":6695,"rowLimit":20,"rowOffset":0,"start":"2020-06-18T15:39:06.367Z","totalProcessingTime":144},"records":[["2020-01-10","39113","1","60",1,0,0,null],["2020-01-15","39025","1","70",1,0,0,null],["2020-01-20","39153","1","50",1,0,0,null],["2020-01-26","39109","1","60",1,0,0,null],["2020-01-26","39091","1","50",1,0,0,null],["2020-01-27","39165","1","50",1,0,0,null],["2020-01-31","39099","1","60",1,0,0,null],["2020-02-01","39153","1","60",1,0,0,null],["2020-02-01","39103","1","70",1,0,0,null],["2020-02-01","39021","1","60",1,0,0,null],["2020-02-04","39113","1","60",1,0,0,null],["2020-02-08","39159","1","50",1,0,0,null],["2020-02-10","39003","1","60",1,0,0,null],["2020-02-10","39043","1","80",1,0,0,null],["2020-02-12","39043","1","60",1,0,0,null],["2020-02-12","39113","1","60",1,0,1,null],["2020-02-15","39035","1","60",1,0,1,null],["2020-02-15","39113","1","60",1,0,0,null],["2020-02-16","39103","1","50",1,0,0,null],["2020-02-19","39095","1","50",1,0,0,null]],"totals":[],"variables":[{"dataType":"DATE","description":"Date the counts were reported.","fixedStorageWidth":0,"format":"YYYY-MM-DD (\u003ca href=\"https://en.wikipedia.org/wiki/ISO_8601\" target=\"_blank\"\u003eISO 8601\u003c/a\u003e)","id":"date_stamp","index":1,"isDimension":true,"isMeasure":false,"label":"Date Reported","name":"date_stamp","reference":false,"revisionNumber":0,"storageType":"DATE","uri":"842073b8-e59f-4003-8249-2f574e7323ae"},{"classificationUri":"4eafde7a-d65e-4e42-9a0f-fcccd138fbec","dataType":"TEXT","description":"U.S. FIPS 6-4 county code (5-digit).","fixedStorageWidth":5,"format":"FIPS 6-4 County Code","id":"us_county_fips","index":2,"isDimension":true,"isMeasure":false,"label":"County Code (5-digit)","name":"us_county_fips","reference":false,"revisionNumber":0,"storageType":"VARCHAR","uri":"644d3213-730b-46be-99ab-4d1b3a010a58"},{"classificationUri":"14adaf0e-2139-41c3-9f8b-6e518ec788a6","dataType":"TEXT","description":"Sex of the individuals.","fixedStorageWidth":1,"format":"","id":"sex","index":3,"isDimension":true,"isMeasure":false,"label":"Sex","name":"sex","reference":false,"revisionNumber":0,"storageType":"VARCHAR","uri":"0d5f2754-63ca-44fd-9c3c-4285e3c99e01"},{"classificationUri":"f3bf04e8-db73-4559-9e37-0c6b719a02ab","dataType":"TEXT","description":"Age group that these individuals are a part of.","fixedStorageWidth":3,"format":"","id":"age_group","index":4,"isDimension":true,"isMeasure":false,"label":"Age Group","name":"age_group","reference":false,"revisionNumber":0,"storageType":"VARCHAR","uri":"b46614ee-d0c8-4023-a77b-f4b208d5e781"},{"dataType":"NUMERIC","decimals":0,"description":"Total number of confirmed cases for this age group, sex, and county on this specific date.","fixedStorageWidth":32,"format":"","id":"cnt_confirmed","index":5,"isMeasure":true,"label":"Confirmed Count","name":"cnt_confirmed","reference":false,"revisionNumber":0,"storageType":"INT","uri":"9736abaa-26b7-4653-b683-5d3d59044701"},{"dataType":"NUMERIC","decimals":0,"description":"Total number of hospitalizations for this age group, sex, and county on this specific date.","fixedStorageWidth":32,"format":"","id":"cnt_hospitalized","index":6,"isMeasure":true,"label":"Hospitalized Count","name":"cnt_hospitalized","reference":false,"revisionNumber":0,"storageType":"INT","uri":"b205fbfb-5b9a-4821-87f3-80d80f741646"},{"dataType":"NUMERIC","decimals":0,"description":"The total number of deaths for this age group, sex, and county on this specific date.","fixedStorageWidth":32,"format":"","id":"cnt_death","index":7,"isMeasure":true,"label":"Deaths Count","name":"cnt_death","reference":false,"revisionNumber":0,"storageType":"INT","uri":"d0fc2a3c-4f45-4833-9b02-829c4bd53261"},{"dataType":"DATE","description":"Date of the death of the individuals represented by this record.","fixedStorageWidth":0,"format":"YYYY-MM-DD (\u003ca href=\"https://en.wikipedia.org/wiki/ISO_8601\" target=\"_blank\"\u003eISO 8601\u003c/a\u003e)","id":"date_stamp_death","index":8,"isDimension":true,"isMeasure":false,"label":"Date of Death","name":"date_stamp_death","reference":false,"revisionNumber":0,"storageType":"DATE","uri":"bf720259-3bd8-47ba-963c-a266ac94f4c4"}]}