Visualize COVID-19 cases over time in the U.S.
Let's say we are interested in examining COVID-19 cases over time. By using the Johns Hopkins country-level dataset's (jhu_country) confirmed (cnt_confirmed), recovered (cnt_recovered), and death count (cnt_death) variables, and specifying that we are only interested in US case data, we can easily query data that is directly consumable by our charting library (amCharts, in this case). After sending the request, you can head over to the Visualize tab to see the graph below.
Of course, you can also leave off the format parameter to have the data returned record by record. An example of this is available in the Example Response section. Try out this query and apply your own filters in the RDS Explorer.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
cols | string | We want to see cases on a timeline, so lets make date the dimension, and plot counts of confirmed, deaths, and recovered cases. | |
where | string | Let's limit it to just the US. Want to see another country? Change this to the country code of your choice. |
We can see the codes for the iso3166_1 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/int/jhu_country/classification/iso3166_1/codes |
| format | string | | Our desired charting library, used to return the data in a way that is directly consumable by amCharts. Leaving this off will return the data record by record. |
| limit | number | | Limit results to 5000 |
RESPONSES
status: OK
{"dataProvider":[{"date_stamp":"2020-01-22","cnt_confirmed":1,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-23","cnt_confirmed":1,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-24","cnt_confirmed":2,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-25","cnt_confirmed":2,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-26","cnt_confirmed":5,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-27","cnt_confirmed":5,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-28","cnt_confirmed":5,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-29","cnt_confirmed":5,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-30","cnt_confirmed":5,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-01-31","cnt_confirmed":6,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-01","cnt_confirmed":8,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-02","cnt_confirmed":8,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-03","cnt_confirmed":11,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-04","cnt_confirmed":11,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-05","cnt_confirmed":12,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-06","cnt_confirmed":12,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-07","cnt_confirmed":12,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-08","cnt_confirmed":12,"cnt_death":0,"cnt_recovered":0},{"date_stamp":"2020-02-09","cnt_confirmed":12,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-10","cnt_confirmed":12,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-11","cnt_confirmed":13,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-12","cnt_confirmed":13,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-13","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-14","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-15","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-16","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-17","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-18","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-19","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-20","cnt_confirmed":15,"cnt_death":0,"cnt_recovered":3},{"date_stamp":"2020-02-21","cnt_confirmed":35,"cnt_death":0,"cnt_recovered":5},{"date_stamp":"2020-02-22","cnt_confirmed":35,"cnt_death":0,"cnt_recovered":5},{"date_stamp":"2020-02-23","cnt_confirmed":35,"cnt_death":0,"cnt_recovered":5},{"date_stamp":"2020-02-24","cnt_confirmed":53,"cnt_death":0,"cnt_recovered":5},{"date_stamp":"2020-02-25","cnt_confirmed":53,"cnt_death":0,"cnt_recovered":6},{"date_stamp":"2020-02-26","cnt_confirmed":59,"cnt_death":0,"cnt_recovered":6},{"date_stamp":"2020-02-27","cnt_confirmed":60,"cnt_death":0,"cnt_recovered":6},{"date_stamp":"2020-02-28","cnt_confirmed":62,"cnt_death":0,"cnt_recovered":7},{"date_stamp":"2020-02-29","cnt_confirmed":70,"cnt_death":1,"cnt_recovered":7},{"date_stamp":"2020-03-01","cnt_confirmed":76,"cnt_death":1,"cnt_recovered":7},{"date_stamp":"2020-03-02","cnt_confirmed":101,"cnt_death":6,"cnt_recovered":7},{"date_stamp":"2020-03-03","cnt_confirmed":122,"cnt_death":7,"cnt_recovered":8},{"date_stamp":"2020-03-04","cnt_confirmed":153,"cnt_death":11,"cnt_recovered":8},{"date_stamp":"2020-03-05","cnt_confirmed":221,"cnt_death":12,"cnt_recovered":8},{"date_stamp":"2020-03-06","cnt_confirmed":278,"cnt_death":14,"cnt_recovered":8},{"date_stamp":"2020-03-07","cnt_confirmed":417,"cnt_death":17,"cnt_recovered":8},{"date_stamp":"2020-03-08","cnt_confirmed":537,"cnt_death":21,"cnt_recovered":8},{"date_stamp":"2020-03-09","cnt_confirmed":605,"cnt_death":22,"cnt_recovered":8},{"date_stamp":"2020-03-10","cnt_confirmed":959,"cnt_death":28,"cnt_recovered":8},{"date_stamp":"2020-03-11","cnt_confirmed":1281,"cnt_death":36,"cnt_recovered":8},{"date_stamp":"2020-03-12","cnt_confirmed":1663,"cnt_death":40,"cnt_recovered":12},{"date_stamp":"2020-03-13","cnt_confirmed":2179,"cnt_death":47,"cnt_recovered":12},{"date_stamp":"2020-03-14","cnt_confirmed":2726,"cnt_death":54,"cnt_recovered":12},{"date_stamp":"2020-03-15","cnt_confirmed":3499,"cnt_death":63,"cnt_recovered":12},{"date_stamp":"2020-03-16","cnt_confirmed":4632,"cnt_death":85,"cnt_recovered":17},{"date_stamp":"2020-03-17","cnt_confirmed":6421,"cnt_death":108,"cnt_recovered":17},{"date_stamp":"2020-03-18","cnt_confirmed":7786,"cnt_death":118,"cnt_recovered":106},{"date_stamp":"2020-03-19","cnt_confirmed":13680,"cnt_death":200,"cnt_recovered":108},{"date_stamp":"2020-03-20","cnt_confirmed":19101,"cnt_death":244,"cnt_recovered":147},{"date_stamp":"2020-03-21","cnt_confirmed":25514,"cnt_death":307,"cnt_recovered":171},{"date_stamp":"2020-03-22","cnt_confirmed":33848,"cnt_death":427,"cnt_recovered":0},{"date_stamp":"2020-03-23","cnt_confirmed":43663,"cnt_death":552,"cnt_recovered":0},{"date_stamp":"2020-03-24","cnt_confirmed":53736,"cnt_death":706,"cnt_recovered":348},{"date_stamp":"2020-03-25","cnt_confirmed":65778,"cnt_death":942,"cnt_recovered":361},{"date_stamp":"2020-03-26","cnt_confirmed":83836,"cnt_death":1209,"cnt_recovered":681},{"date_stamp":"2020-03-27","cnt_confirmed":101657,"cnt_death":1581,"cnt_recovered":869},{"date_stamp":"2020-03-28","cnt_confirmed":121465,"cnt_death":2026,"cnt_recovered":1072},{"date_stamp":"2020-03-29","cnt_confirmed":140909,"cnt_death":2467,"cnt_recovered":2665},{"date_stamp":"2020-03-30","cnt_confirmed":161831,"cnt_death":2978,"cnt_recovered":5644},{"date_stamp":"2020-03-31","cnt_confirmed":188172,"cnt_death":3873,"cnt_recovered":7024},{"date_stamp":"2020-04-01","cnt_confirmed":213372,"cnt_death":4757,"cnt_recovered":8474},{"date_stamp":"2020-04-02","cnt_confirmed":243599,"cnt_death":5926,"cnt_recovered":9001},{"date_stamp":"2020-04-03","cnt_confirmed":275586,"cnt_death":7087,"cnt_recovered":9707},{"date_stamp":"2020-04-04","cnt_confirmed":308853,"cnt_death":8407,"cnt_recovered":14652},{"date_stamp":"2020-04-05","cnt_confirmed":337072,"cnt_death":9619,"cnt_recovered":17448},{"date_stamp":"2020-04-06","cnt_confirmed":366667,"cnt_death":10783,"cnt_recovered":19581},{"date_stamp":"2020-04-07","cnt_confirmed":396223,"cnt_death":12722,"cnt_recovered":21763},{"date_stamp":"2020-04-08","cnt_confirmed":429052,"cnt_death":14695,"cnt_recovered":23559},{"date_stamp":"2020-04-09","cnt_confirmed":461437,"cnt_death":16478,"cnt_recovered":25410},{"date_stamp":"2020-04-10","cnt_confirmed":496535,"cnt_death":18586,"cnt_recovered":28790},{"date_stamp":"2020-04-11","cnt_confirmed":526396,"cnt_death":20462,"cnt_recovered":31270},{"date_stamp":"2020-04-12","cnt_confirmed":555313,"cnt_death":22019,"cnt_recovered":32988},{"date_stamp":"2020-04-13","cnt_confirmed":580619,"cnt_death":23528,"cnt_recovered":43482},{"date_stamp":"2020-04-14","cnt_confirmed":607670,"cnt_death":25831,"cnt_recovered":47763},{"date_stamp":"2020-04-15","cnt_confirmed":636350,"cnt_death":28325,"cnt_recovered":52096},{"date_stamp":"2020-04-16","cnt_confirmed":667801,"cnt_death":32916,"cnt_recovered":54703},{"date_stamp":"2020-04-17","cnt_confirmed":699706,"cnt_death":36773,"cnt_recovered":58545},{"date_stamp":"2020-04-18","cnt_confirmed":732197,"cnt_death":38664,"cnt_recovered":64840},{"date_stamp":"2020-04-19","cnt_confirmed":759086,"cnt_death":40661,"cnt_recovered":70337},{"date_stamp":"2020-04-20","cnt_confirmed":784326,"cnt_death":42094,"cnt_recovered":72329},{"date_stamp":"2020-04-21","cnt_confirmed":812036,"cnt_death":44444,"cnt_recovered":75204},{"date_stamp":"2020-04-22","cnt_confirmed":839675,"cnt_death":46583,"cnt_recovered":77366},{"date_stamp":"2020-04-23","cnt_confirmed":869170,"cnt_death":49954,"cnt_recovered":80203},{"date_stamp":"2020-04-24","cnt_confirmed":905333,"cnt_death":51949,"cnt_recovered":99079},{"date_stamp":"2020-04-25","cnt_confirmed":938154,"cnt_death":53755,"cnt_recovered":100372},{"date_stamp":"2020-04-26","cnt_confirmed":965783,"cnt_death":54881,"cnt_recovered":106988},{"date_stamp":"2020-04-27","cnt_confirmed":988197,"cnt_death":56259,"cnt_recovered":111424},{"date_stamp":"2020-04-28","cnt_confirmed":1012582,"cnt_death":58355,"cnt_recovered":115936},{"date_stamp":"2020-04-29","cnt_confirmed":1039909,"cnt_death":60967,"cnt_recovered":120720},{"date_stamp":"2020-04-30","cnt_confirmed":1069424,"cnt_death":62996,"cnt_recovered":153947},{"date_stamp":"2020-05-01","cnt_confirmed":1103461,"cnt_death":64943,"cnt_recovered":164015},{"date_stamp":"2020-05-02","cnt_confirmed":1132539,"cnt_death":66369,"cnt_recovered":175382},{"date_stamp":"2020-05-03","cnt_confirmed":1158040,"cnt_death":67682,"cnt_recovered":180152},{"date_stamp":"2020-05-04","cnt_confirmed":1180375,"cnt_death":68922,"cnt_recovered":187180},{"date_stamp":"2020-05-05","cnt_confirmed":1204351,"cnt_death":71064,"cnt_recovered":189791},{"date_stamp":"2020-05-06","cnt_confirmed":1228603,"cnt_death":73431,"cnt_recovered":189910},{"date_stamp":"2020-05-07","cnt_confirmed":1257023,"cnt_death":75662,"cnt_recovered":195036},{"date_stamp":"2020-05-08","cnt_confirmed":1283929,"cnt_death":77180,"cnt_recovered":198993},{"date_stamp":"2020-05-09","cnt_confirmed":1309550,"cnt_death":78795,"cnt_recovered":212534},{"date_stamp":"2020-05-10","cnt_confirmed":1329260,"cnt_death":79526,"cnt_recovered":216169},{"date_stamp":"2020-05-11","cnt_confirmed":1347881,"cnt_death":80682,"cnt_recovered":232733},{"date_stamp":"2020-05-12","cnt_confirmed":1369574,"cnt_death":82376,"cnt_recovered":230287},{"date_stamp":"2020-05-13","cnt_confirmed":1390406,"cnt_death":84119,"cnt_recovered":243430},{"date_stamp":"2020-05-14","cnt_confirmed":1417774,"cnt_death":85898,"cnt_recovered":246414},{"date_stamp":"2020-05-15","cnt_confirmed":1442824,"cnt_death":87530,"cnt_recovered":250747},{"date_stamp":"2020-05-16","cnt_confirmed":1467820,"cnt_death":88754,"cnt_recovered":268376},{"date_stamp":"2020-05-17","cnt_confirmed":1486757,"cnt_death":89562,"cnt_recovered":272265},{"date_stamp":"2020-05-18","cnt_confirmed":1508308,"cnt_death":90347,"cnt_recovered":283178},{"date_stamp":"2020-05-19","cnt_confirmed":1528568,"cnt_death":91921,"cnt_recovered":289392},{"date_stamp":"2020-05-20","cnt_confirmed":1551853,"cnt_death":93439,"cnt_recovered":294312},{"date_stamp":"2020-05-21","cnt_confirmed":1577147,"cnt_death":94702,"cnt_recovered":298418},{"date_stamp":"2020-05-22","cnt_confirmed":1600937,"cnt_death":95979,"cnt_recovered":350135},{"date_stamp":"2020-05-23","cnt_confirmed":1622612,"cnt_death":97087,"cnt_recovered":361239},{"date_stamp":"2020-05-24","cnt_confirmed":1643246,"cnt_death":97720,"cnt_recovered":366736},{"date_stamp":"2020-05-25","cnt_confirmed":1662302,"cnt_death":98220,"cnt_recovered":379157},{"date_stamp":"2020-05-26","cnt_confirmed":1680913,"cnt_death":98913,"cnt_recovered":384902},{"date_stamp":"2020-05-27","cnt_confirmed":1699176,"cnt_death":100418,"cnt_recovered":391508},{"date_stamp":"2020-05-28","cnt_confirmed":1721753,"cnt_death":101616,"cnt_recovered":399991},{"date_stamp":"2020-05-29","cnt_confirmed":1746019,"cnt_death":102809,"cnt_recovered":406446},{"date_stamp":"2020-05-30","cnt_confirmed":1770165,"cnt_death":103776,"cnt_recovered":416461},{"date_stamp":"2020-05-31","cnt_confirmed":1790172,"cnt_death":104381,"cnt_recovered":444758},{"date_stamp":"2020-06-01","cnt_confirmed":1811360,"cnt_death":105165,"cnt_recovered":458231},{"date_stamp":"2020-06-02","cnt_confirmed":1831821,"cnt_death":106180,"cnt_recovered":463868},{"date_stamp":"2020-06-03","cnt_confirmed":1851520,"cnt_death":107175,"cnt_recovered":479258},{"date_stamp":"2020-06-04","cnt_confirmed":1872660,"cnt_death":108211,"cnt_recovered":485002},{"date_stamp":"2020-06-05","cnt_confirmed":1897380,"cnt_death":109132,"cnt_recovered":491706},{"date_stamp":"2020-06-06","cnt_confirmed":1920061,"cnt_death":109802,"cnt_recovered":500849},{"date_stamp":"2020-06-07","cnt_confirmed":1942363,"cnt_death":110514,"cnt_recovered":506367},{"date_stamp":"2020-06-08","cnt_confirmed":1960897,"cnt_death":110990,"cnt_recovered":518522},{"date_stamp":"2020-06-09","cnt_confirmed":1979411,"cnt_death":111989,"cnt_recovered":524855},{"date_stamp":"2020-06-10","cnt_confirmed":2000464,"cnt_death":112924,"cnt_recovered":533504}]}