johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 18253 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 16
- Peru 3
- Mali 1
- New Zealand 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1025159 | 1025159 | 2022-11-04 | US | Puerto Rico | Vega Baja | 72145 | 18253 | 0 | 0 | 18.428262 | -66.397924 | 2022-11-05 04:21:52 | Vega Baja, Puerto Rico, US | |
711941 | 711941 | 2022-11-01 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-11-02 04:22:09 | Acadia, Louisiana, US | |
3286390 | 3286390 | 2022-10-31 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-11-01 04:22:36 | Acadia, Louisiana, US | |
321423 | 321423 | 2022-10-30 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-10-31 04:21:36 | Acadia, Louisiana, US | |
913699 | 913699 | 2022-10-29 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-10-30 04:22:14 | Acadia, Louisiana, US | |
1367968 | 1367968 | 2022-10-28 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-10-29 04:21:13 | Acadia, Louisiana, US | |
3039823 | 3039823 | 2022-10-27 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-10-28 04:22:31 | Acadia, Louisiana, US | |
540243 | 540243 | 2022-10-26 | US | Louisiana | Acadia | 22001 | 18253 | 302 | 0 | 30.2950649 | -92.41419698 | 2022-10-27 04:22:01 | Acadia, Louisiana, US | |
2856123 | 2856123 | 2022-08-22 | US | Texas | Wise | 48497 | 18253 | 275 | 0 | 33.21570665 | -97.65460265 | 2022-08-23 04:20:56 | Wise, Texas, US | |
3596184 | 3596184 | 2022-05-23 | US | Texas | Liberty | 48291 | 18253 | 404 | 0 | 30.15152688 | -94.81205615 | 2022-05-24 04:20:57 | Liberty, Texas, US | |
71227 | 71227 | 2022-02-07 | New Zealand | 18253 | 52 | 0 | -40.9006 | 174.886 | 2022-02-08 04:21:15 | New Zealand | ||||
2835745 | 2835745 | 2022-01-22 | US | Tennessee | Anderson | 47001 | 18253 | 283 | 0 | 36.12684348 | -84.19965764 | 2022-01-23 04:21:13 | Anderson, Tennessee, US | |
550845 | 550845 | 2021-12-08 | Mali | 18253 | 621 | 0 | 17.570692 | -3.996166000000001 | 2021-12-09 04:22:49 | Mali | ||||
2069555 | 2069555 | 2021-08-31 | US | Michigan | Livingston | 26093 | 18253 | 203 | 0 | 42.60302282 | -83.91297209 | 2021-09-01 04:21:38 | Livingston, Michigan, US | |
1777009 | 1777009 | 2021-08-30 | US | Michigan | Livingston | 26093 | 18253 | 203 | 0 | 42.60302282 | -83.91297209 | 2021-08-31 04:21:46 | Livingston, Michigan, US | |
508066 | 508066 | 2021-08-14 | US | Alabama | Lee | 1081 | 18253 | 185 | 0 | 32.60154883 | -85.35132246 | 2021-08-15 04:21:41 | Lee, Alabama, US | |
1483938 | 1483938 | 2021-08-13 | US | Alabama | Lee | 1081 | 18253 | 185 | 0 | 32.60154883 | -85.35132246 | 2021-08-14 04:21:25 | Lee, Alabama, US | |
3962736 | 3962736 | 2021-03-10 | Russia | Kurgan Oblast | 18253 | 322 | 16402 | 1529 | 55.7655302 | 64.5632681 | 2021-03-11 05:25:48 | Kurgan Oblast, Russia | ||
1460520 | 1460520 | 2021-01-31 | US | Georgia | Chatham | 13051 | 18253 | 301 | 0 | 17952 | 32.00043026 | -81.12489526 | 2021-02-01 05:22:53 | Chatham, Georgia, US |
2931370 | 2931370 | 2020-12-19 | Peru | Amazonas | 18253 | 558 | 0 | 17695 | -5.077253 | -78.050172 | 2020-12-20 05:27:32 | Amazonas, Peru | ||
1901316 | 1901316 | 2020-12-18 | Peru | Amazonas | 18253 | 558 | 0 | 17695 | -5.077253 | -78.050172 | 2020-12-19 05:27:52 | Amazonas, Peru | ||
2128142 | 2128142 | 2020-12-17 | Peru | Amazonas | 18253 | 558 | 0 | 17695 | -5.077253 | -78.050172 | 2020-12-18 05:28:18 | Amazonas, Peru |
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]);