johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where deaths = 5702 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
374451 | 374451 | 2022-09-13 | US | New York | New York | 36061 | 526377 | 5702 | 0 | 40.7672726 | -73.97152637 | 2022-09-14 04:20:44 | New York, New York, US | |
2853097 | 2853097 | 2022-08-22 | Russia | Novosibirsk Oblast | 266013 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-23 04:20:56 | Novosibirsk Oblast, Russia | |||
2403069 | 2403069 | 2022-08-21 | Russia | Novosibirsk Oblast | 265605 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-22 04:20:38 | Novosibirsk Oblast, Russia | |||
3798147 | 3798147 | 2022-08-20 | Russia | Novosibirsk Oblast | 265215 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-21 04:20:44 | Novosibirsk Oblast, Russia | |||
2363733 | 2363733 | 2022-08-19 | Russia | Novosibirsk Oblast | 264873 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-20 04:21:01 | Novosibirsk Oblast, Russia | |||
1161404 | 1161404 | 2022-08-18 | Russia | Novosibirsk Oblast | 264566 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-19 04:20:54 | Novosibirsk Oblast, Russia | |||
3950728 | 3950728 | 2022-08-17 | Russia | Novosibirsk Oblast | 264285 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-18 04:21:11 | Novosibirsk Oblast, Russia | |||
3726410 | 3726410 | 2022-06-07 | Russia | Bashkortostan Republic | 289176 | 5702 | 0 | 54.8573563 | 57.1439682 | 2022-06-08 04:20:55 | Bashkortostan Republic, Russia | |||
1849649 | 1849649 | 2022-04-18 | Venezuela | 522049 | 5702 | 0 | 6.4238 | -66.5897 | 2022-04-19 04:21:00 | Venezuela | ||||
1551202 | 1551202 | 2022-03-07 | US | Texas | Tarrant | 48439 | 559334 | 5702 | 0 | 32.77143818 | -97.29101614 | 2022-03-08 04:20:54 | Tarrant, Texas, US | |
1227709 | 1227709 | 2022-01-24 | Mexico | Oaxaca | 94932 | 5702 | 0 | 17.0732 | -96.7266 | 2022-01-25 04:21:05 | Oaxaca, Mexico | |||
1141008 | 1141008 | 2022-01-23 | Mexico | Oaxaca | 94702 | 5702 | 0 | 17.0732 | -96.7266 | 2022-01-24 04:21:12 | Oaxaca, Mexico | |||
2832928 | 2832928 | 2022-01-22 | Mexico | Queretaro | 114483 | 5702 | 0 | 20.5888 | -100.3899 | 2022-01-23 04:21:13 | Queretaro, Mexico | |||
3425046 | 3425046 | 2022-01-21 | Mexico | Queretaro | 114483 | 5702 | 0 | 20.5888 | -100.3899 | 2022-01-22 04:21:13 | Queretaro, Mexico | |||
3655701 | 3655701 | 2021-12-10 | Mexico | Yucatan | 75356 | 5702 | 0 | 20.7099 | -89.0943 | 2021-12-11 04:22:45 | Yucatan, Mexico | |||
1078032 | 1078032 | 2021-12-09 | Mexico | Yucatan | 75356 | 5702 | 0 | 20.7099 | -89.0943 | 2021-12-10 04:22:28 | Yucatan, Mexico | |||
2279028 | 2279028 | 2021-09-08 | Costa Rica | 483984 | 5702 | 0 | 9.7489 | -83.7534 | 2021-09-09 04:21:27 | Costa Rica | ||||
3706273 | 3706273 | 2021-07-17 | Pakistan | Sindh | 355462 | 5702 | 320215 | 29545 | 26.009446 | 68.77680699999999 | 2021-07-18 04:22:07 | Sindh, Pakistan | ||
1424849 | 1424849 | 2021-05-09 | Brazil | Rio Grande do Norte | 233836 | 5702 | 150649 | 75216 | -5.4026 | -36.9541 | 2021-05-10 04:20:38 | Rio Grande do Norte, Brazil | ||
3242551 | 3242551 | 2021-04-21 | Russia | Moscow Oblast | 244379 | 5702 | 201344 | 37333 | 55.50431579999999 | 38.0353929 | 2021-04-22 04:20:53 | Moscow Oblast, Russia | ||
2056173 | 2056173 | 2021-03-15 | Spain | Castilla - La Mancha | 172947 | 5702 | 6392 | 160853 | 39.2796 | -3.0977 | 2021-03-16 05:25:13 | Castilla - La Mancha, Spain | ||
194018 | 194018 | 2020-08-31 | India | Karnataka | 342423 | 5702 | 249467 | 87254 | 14.70518 | 76.166436 | 2020-09-01 04:28:31 | Karnataka, India | ||
3265008 | 3265008 | 2020-07-31 | Ecuador | 85355 | 5702 | 36044 | 43609 | -1.8312 | -78.1834 | 2020-08-01 04:36:27 | Ecuador | |||
327127 | 327127 | 2020-07-20 | Canada | Quebec | 57660 | 5702 | 50190 | 1768 | 52.9399 | -73.5491 | 2020-07-21 04:38:46 | Quebec, Canada | ||
122032 | 122032 | 2020-07-19 | Canada | Quebec | 57529 | 5702 | 50050 | 1777 | 52.9399 | -73.5491 | 2020-07-20 05:34:40 | Quebec, Canada |
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]);