johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where confirmed = 44340 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753050 | 2753050 | 2022-12-29 | Pakistan | Azad Jammu and Kashmir | 44340 | 793 | 0 | 34.027401 | 73.947253 | 2022-12-30 04:21:04 | Azad Jammu and Kashmir, Pakistan | |||
1396684 | 1396684 | 2022-09-02 | US | Tennessee | Washington | 47179 | 44340 | 515 | 0 | 36.29472368 | -82.4945472 | 2022-09-03 04:21:04 | Washington, Tennessee, US | |
3452946 | 3452946 | 2021-03-18 | Mexico | Michoacan | 44340 | 4869 | 0 | 39471 | 19.5665 | -101.7068 | 2021-03-19 05:26:09 | Michoacan, Mexico | ||
1460423 | 1460423 | 2021-01-31 | US | Delaware | New Castle | 10003 | 44340 | 635 | 0 | 43705 | 39.57992638 | -75.64054974 | 2021-02-01 05:22:53 | New Castle, Delaware, US |
327136 | 327136 | 2020-07-20 | Brazil | Rio Grande do Norte | 44340 | 1628 | 3441 | 38931 | -5.4026 | -36.9541 | 2020-07-21 04:38:46 | Rio Grande do Norte, Brazil |
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]);