johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where deaths = 2911 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1073929 | 1073929 | 2022-12-28 | Japan | Saitama | 1586195 | 2911 | 0 | 35.997101 | 139.347635 | 2022-12-29 04:21:01 | Saitama, Japan | |||
3038329 | 3038329 | 2022-10-27 | Japan | Hyogo | 1039248 | 2911 | 0 | 35.039913 | 134.828057 | 2022-10-28 04:22:31 | Hyogo, Japan | |||
3215902 | 3215902 | 2022-10-12 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-11 23:22:35 | Essex, Massachusetts, US | |
3251751 | 3251751 | 2022-10-11 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-11 23:22:35 | Essex, Massachusetts, US | |
2969010 | 2969010 | 2022-10-10 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-11 04:23:05 | Essex, Massachusetts, US | |
3099046 | 3099046 | 2022-10-09 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-10 04:22:32 | Essex, Massachusetts, US | |
4004271 | 4004271 | 2022-10-08 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-09 04:21:16 | Essex, Massachusetts, US | |
397868 | 397868 | 2022-10-07 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-08 04:22:56 | Essex, Massachusetts, US | |
2530985 | 2530985 | 2022-10-06 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-07 04:23:08 | Essex, Massachusetts, US | |
3619258 | 3619258 | 2022-08-01 | US | New Jersey | Middlesex | 34023 | 233159 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-08-02 04:20:53 | Middlesex, New Jersey, US | |
3873738 | 3873738 | 2022-07-31 | US | New Jersey | Middlesex | 34023 | 233000 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-08-01 04:21:03 | Middlesex, New Jersey, US | |
676492 | 676492 | 2022-07-30 | US | New Jersey | Middlesex | 34023 | 232774 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-07-31 04:21:02 | Middlesex, New Jersey, US | |
1785691 | 1785691 | 2022-07-29 | US | New Jersey | Middlesex | 34023 | 232486 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-07-30 04:20:42 | Middlesex, New Jersey, US | |
1722662 | 1722662 | 2022-03-25 | US | New Jersey | Ocean | 34029 | 161147 | 2911 | 0 | 39.8895449 | -74.28089251 | 2022-03-26 04:20:23 | Ocean, New Jersey, US | |
1865810 | 1865810 | 2022-03-10 | Sweden | Vastra Gotaland | 429811 | 2911 | 0 | 58.2528 | 13.0596 | 2022-03-11 04:20:50 | Vastra Gotaland, Sweden | |||
3859458 | 3859458 | 2022-02-18 | Ukraine | Cherkasy Oblast | 157456 | 2911 | 0 | 49.4444 | 32.0598 | 2022-02-19 04:21:11 | Cherkasy Oblast, Ukraine | |||
782613 | 782613 | 2021-12-13 | Russia | Leningrad Oblast | 95311 | 2911 | 0 | 60.185329599999996 | 32.3925325 | 2021-12-14 04:22:38 | Leningrad Oblast, Russia | |||
404529 | 404529 | 2021-12-07 | Russia | Omsk Oblast | 118613 | 2911 | 0 | 56.09352629999999 | 73.5099936 | 2021-12-08 04:22:46 | Omsk Oblast, Russia | |||
1030504 | 1030504 | 2021-12-06 | Netherlands | Noord-Holland | 457844 | 2911 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-12-07 04:22:34 | Noord-Holland, Netherlands | |||
1802944 | 1802944 | 2021-11-25 | Russia | Dagestan Republic | 60376 | 2911 | 0 | 43.05749160000001 | 47.1332224 | 2021-11-26 04:22:33 | Dagestan Republic, Russia | |||
450451 | 450451 | 2021-11-17 | US | Texas | El Paso | 48141 | 133981 | 2911 | 0 | 31.76980765 | -106.23632749999999 | 2021-11-18 04:21:33 | El Paso, Texas, US | |
3495799 | 3495799 | 2021-10-26 | Ukraine | Crimea Republic* | 93314 | 2911 | 0 | 45.2835 | 34.2008 | 2021-10-27 04:22:32 | Crimea Republic*, Ukraine | |||
245105 | 245105 | 2021-08-17 | Colombia | Bolivar | 153695 | 2911 | 0 | 8.6704 | -74.03 | 2021-08-18 04:21:35 | Bolivar, Colombia | |||
2353598 | 2353598 | 2021-08-10 | US | New Jersey | Bergen | 34003 | 107723 | 2911 | 0 | 40.96010917 | -74.07164325 | 2021-08-11 04:21:58 | Bergen, New Jersey, US | |
652127 | 652127 | 2021-08-09 | US | New Jersey | Bergen | 34003 | 107533 | 2911 | 0 | 40.96010917 | -74.07164325 | 2021-08-10 04:21:27 | Bergen, New Jersey, US | |
589481 | 589481 | 2021-08-08 | Colombia | Narino | 87533 | 2911 | 0 | 1.2892 | -77.3579 | 2021-08-09 04:21:24 | Narino, Colombia | |||
1935551 | 1935551 | 2021-07-05 | US | Texas | Hidalgo | 48215 | 100570 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-06 04:21:32 | Hidalgo, Texas, US | |
1168282 | 1168282 | 2021-07-04 | US | Texas | Hidalgo | 48215 | 100570 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-05 04:21:28 | Hidalgo, Texas, US | |
1498716 | 1498716 | 2021-07-03 | US | Texas | Hidalgo | 48215 | 100570 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-04 04:21:38 | Hidalgo, Texas, US | |
2075031 | 2075031 | 2021-07-02 | US | Texas | Hidalgo | 48215 | 100510 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-03 04:21:37 | Hidalgo, Texas, US | |
2768047 | 2768047 | 2021-07-01 | US | Texas | Hidalgo | 48215 | 100404 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-02 04:21:47 | Hidalgo, Texas, US | |
1207459 | 1207459 | 2021-03-22 | United Kingdom | Northern Ireland | 116019 | 2911 | 0 | 113914 | 54.7877 | -6.4923 | 2021-03-23 05:26:18 | Northern Ireland, United Kingdom | ||
342960 | 342960 | 2021-02-03 | US | Pennsylvania | Philadelphia | 42101 | 112145 | 2911 | 0 | 109234 | 40.00338507 | -75.1379271 | 2021-02-04 05:22:26 | Philadelphia, Pennsylvania, US |
3230432 | 3230432 | 2021-01-03 | Italy | Campania | 192418 | 2911 | 111682 | 77825 | 40.83956555 | 14.25084984 | 2021-01-04 05:22:02 | Campania, Italy | ||
1136831 | 1136831 | 2021-01-01 | India | Haryana | 262611 | 2911 | 255853 | 3847 | 29.20004 | 76.332824 | 2021-01-02 05:22:33 | Haryana, India | ||
845554 | 845554 | 2020-12-12 | Italy | Lazio | 138337 | 2911 | 48108 | 87318 | 41.89277044 | 12.48366722 | 2020-12-13 05:27:20 | Lazio, Italy | ||
2935377 | 2935377 | 2020-11-28 | Pakistan | Sindh | 171595 | 2911 | 150765 | 17919 | 26.009446 | 68.77680699999999 | 2020-11-29 05:25:55 | Sindh, Pakistan | ||
2191433 | 2191433 | 2020-10-21 | Colombia | Antioquia | 147450 | 2911 | 135903 | 8636 | 7.1986 | -75.3412 | 2020-10-22 04:24:27 | Antioquia, Colombia |
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]);