johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 1252, country_or_region = "US" and province_or_state = "Oklahoma" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
402820 | 402820 | 2021-06-29 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-30 04:21:41 | Hughes, Oklahoma, US | |
3128063 | 3128063 | 2021-06-28 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-29 04:21:28 | Hughes, Oklahoma, US | |
2592558 | 2592558 | 2021-06-27 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-28 04:21:29 | Hughes, Oklahoma, US | |
3961062 | 3961062 | 2021-06-26 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-27 04:21:39 | Hughes, Oklahoma, US | |
1714881 | 1714881 | 2021-06-25 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-26 04:21:43 | Hughes, Oklahoma, US | |
2298006 | 2298006 | 2021-06-24 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-25 04:21:33 | Hughes, Oklahoma, US | |
2425445 | 2425445 | 2021-06-23 | US | Oklahoma | Hughes | 40063 | 1252 | 29 | 0 | 35.04912569 | -96.24921145 | 2021-06-24 04:21:55 | Hughes, Oklahoma, US | |
192645 | 192645 | 2021-01-11 | US | Oklahoma | Pawnee | 40117 | 1252 | 16 | 0 | 1236 | 36.31743373 | -96.7033176 | 2021-01-12 05:22:15 | Pawnee, Oklahoma, US |
3192546 | 3192546 | 2020-11-22 | US | Oklahoma | Logan | 40083 | 1252 | 3 | 0 | 1249 | 35.91899576 | -97.44352845 | 2020-11-23 05:25:26 | Logan, Oklahoma, US |
2882757 | 2882757 | 2020-11-15 | US | Oklahoma | Kay | 40071 | 1252 | 20 | 0 | 1232 | 36.81799745 | -97.14421435 | 2020-11-16 05:25:57 | Kay, Oklahoma, US |
81656 | 81656 | 2020-10-14 | US | Oklahoma | Osage | 40113 | 1252 | 13 | 0 | 1239 | 36.62888819 | -96.39635704 | 2020-10-15 04:24:28 | Osage, Oklahoma, US |
1246337 | 1246337 | 2020-09-08 | US | Oklahoma | Texas | 40139 | 1252 | 7 | 0 | 1245 | 36.74777635 | -101.4889765 | 2020-09-09 04:28:48 | Texas, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);