johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where deaths = 3869 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2743471 | 2743471 | 2022-07-07 | US | Ohio | Cuyahoga | 39035 | 292507 | 3869 | 0 | 41.424119 | -81.65918339 | 2022-07-08 04:20:56 | Cuyahoga, Ohio, US | |
1202266 | 1202266 | 2022-07-06 | US | Ohio | Cuyahoga | 39035 | 290752 | 3869 | 0 | 41.424119 | -81.65918339 | 2022-07-07 04:20:55 | Cuyahoga, Ohio, US | |
3969009 | 3969009 | 2022-07-05 | US | Ohio | Cuyahoga | 39035 | 290752 | 3869 | 0 | 41.424119 | -81.65918339 | 2022-07-06 04:20:58 | Cuyahoga, Ohio, US | |
166502 | 166502 | 2022-06-21 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-22 04:20:54 | Pima, Arizona, US | |
1763785 | 1763785 | 2022-06-20 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-21 04:20:56 | Pima, Arizona, US | |
3269971 | 3269971 | 2022-06-19 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-20 04:21:01 | Pima, Arizona, US | |
3397883 | 3397883 | 2022-06-18 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-19 04:20:51 | Pima, Arizona, US | |
2311760 | 2311760 | 2022-06-17 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-18 04:21:10 | Pima, Arizona, US | |
559264 | 559264 | 2022-06-16 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-17 04:20:56 | Pima, Arizona, US | |
3983066 | 3983066 | 2022-06-15 | US | Arizona | Pima | 4019 | 265106 | 3869 | 0 | 32.0971334 | -111.7890033 | 2022-06-16 04:20:55 | Pima, Arizona, US | |
231477 | 231477 | 2022-05-31 | US | New York | Nassau | 36059 | 440284 | 3869 | 0 | 40.74066522 | -73.58941873 | 2022-06-01 04:20:55 | Nassau, New York, US | |
3073891 | 3073891 | 2022-02-09 | Colombia | Tolima | 123104 | 3869 | 0 | 4.0925 | -75.1545 | 2022-02-10 04:21:14 | Tolima, Colombia | |||
1282043 | 1282043 | 2022-01-05 | Malaysia | Johor | 246730 | 3869 | 0 | 1.4854 | 103.7618 | 2022-01-06 04:22:09 | Johor, Malaysia | |||
1286059 | 1286059 | 2022-01-04 | Malaysia | Johor | 246386 | 3869 | 0 | 1.4854 | 103.7618 | 2022-01-05 04:21:59 | Johor, Malaysia | |||
597962 | 597962 | 2021-10-19 | Spain | Aragon | 162039 | 3869 | 0 | 41.5976 | -0.9057 | 2021-10-20 04:21:00 | Aragon, Spain | |||
1728128 | 1728128 | 2021-09-25 | Ukraine | Kharkiv Oblast | 162009 | 3869 | 0 | 49.9935 | 36.2304 | 2021-09-26 04:21:29 | Kharkiv Oblast, Ukraine | |||
1385728 | 1385728 | 2021-09-13 | Mexico | Quintana Roo | 56391 | 3869 | 0 | 19.1817 | -88.4791 | 2021-09-14 04:21:41 | Quintana Roo, Mexico | |||
2793001 | 2793001 | 2021-08-28 | India | Telangana | 657119 | 3869 | 0 | 18.1124 | 79.0193 | 2021-08-29 04:21:14 | Telangana, India | |||
1596778 | 1596778 | 2021-08-26 | US | California | San Diego | 6073 | 347630 | 3869 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-27 04:21:37 | San Diego, California, US | |
507746 | 507746 | 2021-08-14 | Libya | 279099 | 3869 | 0 | 26.3351 | 17.228331 | 2021-08-15 04:21:41 | Libya | ||||
1483618 | 1483618 | 2021-08-13 | Libya | 279099 | 3869 | 0 | 26.3351 | 17.228331 | 2021-08-14 04:21:25 | Libya | ||||
3358586 | 3358586 | 2021-06-21 | Germany | Rheinland-Pfalz | 154895 | 3869 | 150000 | 1065 | 50.1183 | 7.309 | 2021-06-22 04:21:34 | Rheinland-Pfalz, Germany | ||
2884285 | 2884285 | 2021-06-20 | Germany | Rheinland-Pfalz | 154863 | 3869 | 150000 | 1033 | 50.1183 | 7.309 | 2021-06-21 04:21:41 | Rheinland-Pfalz, Germany | ||
888183 | 888183 | 2021-04-26 | Lithuania | 242117 | 3869 | 218011 | 20004 | 55.1694 | 23.8813 | 2021-04-27 04:20:52 | Lithuania | |||
2983163 | 2983163 | 2021-04-10 | Georgia | 287689 | 3869 | 276711 | 7109 | 42.3154 | 43.3569 | 2021-04-11 04:20:56 | Georgia | |||
1305109 | 1305109 | 2021-04-01 | US | Texas | Dallas | 48113 | 267591 | 3869 | 0 | 32.76670599 | -96.7779605 | 2021-04-02 04:20:36 | Dallas, Texas, US | |
2781143 | 2781143 | 2021-03-24 | Paraguay | 200823 | 3869 | 164401 | 32553 | -23.4425 | -58.4438 | 2021-03-25 05:27:00 | Paraguay | |||
352860 | 352860 | 2021-03-11 | US | California | San Bernardino | 6071 | 291868 | 3869 | 0 | 34.84060306 | -116.1774685 | 2021-03-12 05:26:50 | San Bernardino, California, US | |
1338269 | 1338269 | 2021-02-15 | Italy | Sicilia | 146076 | 3869 | 107658 | 34549 | 38.11569725 | 13.362356699999998 | 2021-02-16 05:24:38 | Sicilia, Italy | ||
3515146 | 3515146 | 2021-01-15 | Brazil | Paraiba | 175997 | 3869 | 132352 | 39776 | -7.24 | -36.782 | 2021-01-16 05:22:40 | Paraiba, Brazil | ||
3879662 | 3879662 | 2021-01-14 | Mexico | Hidalgo | 27439 | 3869 | 0 | 23570 | 20.0911 | -98.7624 | 2021-01-15 05:22:24 | Hidalgo, Mexico | ||
3785636 | 3785636 | 2020-10-11 | Brazil | Maranhao | 178765 | 3869 | 167126 | 7770 | -4.9609 | -45.2744 | 2020-10-12 04:23:45 | Maranhao, Brazil | ||
327354 | 327354 | 2020-07-20 | Iraq | 94693 | 3869 | 62836 | 27988 | 33.223191 | 43.679291 | 2020-07-21 04:38:46 | Iraq |
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]);