johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where deaths = 3498 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2268133 | 2268133 | 2022-10-22 | Russia | Leningrad Oblast | 235468 | 3498 | 0 | 60.1853296 | 32.3925325 | 2022-10-23 04:22:46 | Leningrad Oblast, Russia | |||
1592433 | 1592433 | 2022-10-21 | Russia | Leningrad Oblast | 235371 | 3498 | 0 | 60.1853296 | 32.3925325 | 2022-10-22 04:22:53 | Leningrad Oblast, Russia | |||
2272149 | 2272149 | 2022-10-20 | Russia | Leningrad Oblast | 235234 | 3498 | 0 | 60.1853296 | 32.3925325 | 2022-10-21 04:22:23 | Leningrad Oblast, Russia | |||
198484 | 198484 | 2022-10-19 | Russia | Leningrad Oblast | 235141 | 3498 | 0 | 60.1853296 | 32.3925325 | 2022-10-20 04:22:59 | Leningrad Oblast, Russia | |||
2757145 | 2757145 | 2022-10-18 | Russia | Leningrad Oblast | 235025 | 3498 | 0 | 60.1853296 | 32.3925325 | 2022-10-19 04:22:26 | Leningrad Oblast, Russia | |||
2024979 | 2024979 | 2022-10-17 | Russia | Leningrad Oblast | 234996 | 3498 | 0 | 60.1853296 | 32.3925325 | 2022-10-18 04:22:42 | Leningrad Oblast, Russia | |||
2378539 | 2378539 | 2022-09-29 | US | Tennessee | Shelby | 47157 | 273942 | 3498 | 0 | 35.1864775 | -89.89692423 | 2022-09-30 04:23:09 | Shelby, Tennessee, US | |
1563090 | 1563090 | 2022-09-28 | US | Tennessee | Shelby | 47157 | 273850 | 3498 | 0 | 35.1864775 | -89.89692423 | 2022-09-29 04:22:34 | Shelby, Tennessee, US | |
3988597 | 3988597 | 2022-09-15 | US | Missouri | St. Louis | 29189 | 268912 | 3498 | 0 | 38.6377004 | -90.4458375 | 2022-09-16 04:21:19 | St. Louis, Missouri, US | |
1891114 | 1891114 | 2022-09-14 | US | Missouri | St. Louis | 29189 | 268680 | 3498 | 0 | 38.6377004 | -90.4458375 | 2022-09-15 04:21:02 | St. Louis, Missouri, US | |
1783777 | 1783777 | 2022-07-29 | Russia | Vladimir Oblast | 152767 | 3498 | 0 | 56.0503336 | 40.6561633 | 2022-07-30 04:20:42 | Vladimir Oblast, Russia | |||
1066140 | 1066140 | 2022-07-28 | Russia | Vladimir Oblast | 152733 | 3498 | 0 | 56.0503336 | 40.6561633 | 2022-07-29 04:20:45 | Vladimir Oblast, Russia | |||
2239071 | 2239071 | 2022-06-28 | Albania | 279167 | 3498 | 0 | 41.1533 | 20.1683 | 2022-06-29 04:20:59 | Albania | ||||
3887920 | 3887920 | 2022-06-06 | Spain | Galicia | 660013 | 3498 | 0 | 42.5751 | -8.1339 | 2022-06-07 04:21:08 | Galicia, Spain | |||
3507689 | 3507689 | 2022-06-05 | Spain | Galicia | 660013 | 3498 | 0 | 42.5751 | -8.1339 | 2022-06-06 04:20:57 | Galicia, Spain | |||
3527766 | 3527766 | 2022-06-04 | Spain | Galicia | 660013 | 3498 | 0 | 42.5751 | -8.1339 | 2022-06-05 04:20:55 | Galicia, Spain | |||
3133852 | 3133852 | 2022-06-03 | Spain | Galicia | 660013 | 3498 | 0 | 42.5751 | -8.1339 | 2022-06-04 04:20:58 | Galicia, Spain | |||
1696411 | 1696411 | 2022-04-28 | Mexico | Aguascalientes | 65804 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-29 04:20:59 | Aguascalientes, Mexico | |||
3851894 | 3851894 | 2022-04-27 | Mexico | Aguascalientes | 65782 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-28 04:20:47 | Aguascalientes, Mexico | |||
1326324 | 1326324 | 2022-04-26 | Mexico | Aguascalientes | 65736 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-27 04:20:52 | Aguascalientes, Mexico | |||
3722278 | 3722278 | 2022-04-25 | Mexico | Aguascalientes | 65687 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-26 04:20:51 | Aguascalientes, Mexico | |||
2028846 | 2028846 | 2022-04-24 | Mexico | Aguascalientes | 65687 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-25 04:20:56 | Aguascalientes, Mexico | |||
746421 | 746421 | 2022-04-23 | Mexico | Aguascalientes | 65687 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-24 04:20:56 | Aguascalientes, Mexico | |||
3436906 | 3436906 | 2022-04-22 | Mexico | Aguascalientes | 65623 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-23 04:20:50 | Aguascalientes, Mexico | |||
2892491 | 2892491 | 2022-04-21 | Mexico | Aguascalientes | 65623 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-22 04:20:45 | Aguascalientes, Mexico | |||
2307363 | 2307363 | 2022-04-20 | Mexico | Aguascalientes | 65584 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-21 04:20:46 | Aguascalientes, Mexico | |||
2251502 | 2251502 | 2022-04-19 | Mexico | Aguascalientes | 65543 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-20 04:20:45 | Aguascalientes, Mexico | |||
3840346 | 3840346 | 2022-01-15 | Colombia | Magdalena | 105284 | 3498 | 0 | 10.4113 | -74.4057 | 2022-01-16 04:21:12 | Magdalena, Colombia | |||
1078185 | 1078185 | 2021-12-09 | Russia | Ulyanovsk Oblast | 114392 | 3498 | 0 | 54.146317700000004 | 47.2324921 | 2021-12-10 04:22:28 | Ulyanovsk Oblast, Russia | |||
567366 | 567366 | 2021-10-29 | Russia | Volgograd Oblast | 103124 | 3498 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-30 04:22:03 | Volgograd Oblast, Russia | |||
1376761 | 1376761 | 2021-09-15 | US | New York | Suffolk | 36103 | 224068 | 3498 | 0 | 40.88320119 | -72.8012172 | 2021-09-16 04:22:19 | Suffolk, New York, US | |
1330388 | 1330388 | 2021-07-24 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-25 04:22:12 | Oman | |||
3137692 | 3137692 | 2021-07-23 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-24 00:21:36 | Oman | |||
3476452 | 3476452 | 2021-07-22 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-23 04:21:29 | Oman | |||
3331671 | 3331671 | 2021-07-21 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-22 04:21:19 | Oman | |||
2371652 | 2371652 | 2021-07-20 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-21 04:21:40 | Oman | |||
483731 | 483731 | 2021-07-19 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-20 04:21:48 | Oman | |||
2673954 | 2673954 | 2021-07-18 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-19 04:21:24 | Oman | |||
3706266 | 3706266 | 2021-07-17 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-18 04:22:07 | Oman | |||
2947497 | 2947497 | 2021-07-16 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-17 04:22:22 | Oman | |||
296153 | 296153 | 2021-07-15 | Oman | 289042 | 3498 | 263752 | 21792 | 21.512583 | 55.92325500000001 | 2021-07-16 04:21:22 | Oman | |||
2717063 | 2717063 | 2021-06-10 | Mexico | Morelos | 34005 | 3498 | 0 | 30507 | 18.6813 | -99.1013 | 2021-06-11 04:23:20 | Morelos, Mexico | ||
3116502 | 3116502 | 2021-05-06 | US | Texas | Bexar | 48029 | 223398 | 3498 | 0 | 29.44928723 | -98.52019748 | 2021-05-07 04:20:40 | Bexar, Texas, US | |
241114 | 241114 | 2021-04-02 | Colombia | Santander | 94684 | 3498 | 89512 | 1674 | 6.6437 | -73.6536 | 2021-04-03 04:20:44 | Santander, Colombia | ||
1799204 | 1799204 | 2021-03-23 | US | California | San Diego | 6073 | 281495 | 3498 | 0 | 33.03484597 | -116.7365326 | 2021-03-24 05:25:40 | San Diego, California, US | |
678471 | 678471 | 2020-11-23 | Peru | Ica | 30718 | 3498 | 0 | 27220 | -14.235097 | -75.574821 | 2020-11-24 05:27:31 | Ica, Peru | ||
3389130 | 3389130 | 2020-10-02 | Brazil | Mato Grosso | 126106 | 3498 | 105557 | 15385 | -12.6819 | -56.9211 | 2020-10-03 04:23:40 | Mato Grosso, 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]);