johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where deaths = 12731 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2201884 | 2201884 | 2022-03-06 | US | New York | Kings | 36047 | 687128 | 12731 | 0 | 40.636182500000004 | -73.94935552 | 2022-03-07 04:20:47 | Kings, New York, US | |
1281845 | 1281845 | 2022-01-05 | Croatia | 736486 | 12731 | 0 | 45.1 | 15.2 | 2022-01-06 04:22:09 | Croatia | ||||
1660316 | 1660316 | 2021-12-12 | Georgia | 889286 | 12731 | 0 | 42.3154 | 43.3569 | 2021-12-13 04:22:02 | Georgia | ||||
423632 | 423632 | 2021-10-10 | Slovakia | 821714 | 12731 | 0 | 48.669 | 19.699 | 2021-10-11 04:21:31 | Slovakia | ||||
1235953 | 1235953 | 2021-09-27 | Sri Lanka | 514592 | 12731 | 0 | 7.873054 | 80.77179699999998 | 2021-09-28 04:21:28 | Sri Lanka | ||||
1495527 | 1495527 | 2021-07-03 | Greece | 425347 | 12731 | 93764 | 318852 | 39.0742 | 21.8243 | 2021-07-04 04:21:38 | Greece | |||
1409025 | 1409025 | 2021-04-23 | Italy | Emilia-Romagna | 362801 | 12731 | 295521 | 54549 | 44.49436681 | 11.3417208 | 2021-04-24 04:20:38 | Emilia-Romagna, Italy | ||
3242052 | 3242052 | 2021-04-21 | Bolivia | 293061 | 12731 | 241563 | 38767 | -16.2902 | -63.5887 | 2021-04-22 04:20:53 | Bolivia | |||
2247346 | 2247346 | 2021-04-07 | India | Karnataka | 1033560 | 12731 | 971556 | 49273 | 14.70518 | 76.166436 | 2021-04-08 04:21:13 | Karnataka, India |
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]);