johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where confirmed = 30691 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2307358 | 2307358 | 2022-04-20 | Mali | 30691 | 730 | 0 | 17.570692 | -3.996166000000001 | 2022-04-21 04:20:46 | Mali | ||||
2733950 | 2733950 | 2022-02-27 | US | Idaho | Bonneville | 16019 | 30691 | 276 | 0 | 43.38713372 | -111.6161537 | 2022-02-28 04:21:05 | Bonneville, Idaho, US | |
3047103 | 3047103 | 2022-02-26 | US | Idaho | Bonneville | 16019 | 30691 | 276 | 0 | 43.38713372 | -111.6161537 | 2022-02-27 04:21:04 | Bonneville, Idaho, US | |
575758 | 575758 | 2022-02-25 | US | Idaho | Bonneville | 16019 | 30691 | 276 | 0 | 43.38713372 | -111.6161537 | 2022-02-26 04:21:12 | Bonneville, Idaho, US | |
2329873 | 2329873 | 2022-02-04 | US | Ohio | Richland | 39139 | 30691 | 490 | 0 | 40.77180308 | -82.53799609999999 | 2022-02-05 04:21:05 | Richland, Ohio, US | |
1321134 | 1321134 | 2022-01-26 | US | Tennessee | Bradley | 47011 | 30691 | 350 | 0 | 35.15739424 | -84.857186 | 2022-01-27 04:21:19 | Bradley, Tennessee, US | |
128380 | 128380 | 2022-01-09 | US | Michigan | Jackson | 26075 | 30691 | 451 | 0 | 42.24807035 | -84.42258681 | 2022-01-10 04:22:07 | Jackson, Michigan, US | |
1217215 | 1217215 | 2022-01-08 | US | Michigan | Jackson | 26075 | 30691 | 451 | 0 | 42.24807035 | -84.42258681 | 2022-01-09 04:21:46 | Jackson, Michigan, US | |
1391308 | 1391308 | 2022-01-07 | US | Michigan | Jackson | 26075 | 30691 | 451 | 0 | 42.24807035 | -84.42258681 | 2022-01-08 04:21:53 | Jackson, Michigan, US | |
1263509 | 1263509 | 2021-09-09 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-10 04:21:20 | Okaloosa, Florida, US | |
2279879 | 2279879 | 2021-09-08 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-09 04:21:27 | Okaloosa, Florida, US | |
642658 | 642658 | 2021-09-07 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-08 04:21:31 | Okaloosa, Florida, US | |
3194721 | 3194721 | 2021-09-06 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-07 04:21:35 | Okaloosa, Florida, US | |
3281589 | 3281589 | 2021-09-05 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-06 04:21:22 | Okaloosa, Florida, US | |
250003 | 250003 | 2021-09-04 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-05 04:21:33 | Okaloosa, Florida, US | |
3975284 | 3975284 | 2021-09-03 | US | Florida | Okaloosa | 12091 | 30691 | 367 | 0 | 30.69143028 | -86.59267105 | 2021-09-04 04:21:28 | Okaloosa, Florida, US | |
827097 | 827097 | 2021-06-06 | US | Louisiana | Orleans | 22071 | 30691 | 795 | 0 | 30.06971951 | -89.92660315 | 2021-06-07 04:22:51 | Orleans, Louisiana, US | |
2587502 | 2587502 | 2021-06-05 | US | Louisiana | Orleans | 22071 | 30691 | 795 | 0 | 30.06971951 | -89.92660315 | 2021-06-06 04:24:03 | Orleans, Louisiana, US | |
2316816 | 2316816 | 2021-06-04 | US | Louisiana | Orleans | 22071 | 30691 | 795 | 0 | 30.06971951 | -89.92660315 | 2021-06-05 04:23:03 | Orleans, Louisiana, US | |
1304557 | 1304557 | 2021-04-01 | US | Ohio | Stark | 39151 | 30691 | 909 | 0 | 40.81482476 | -81.36437305 | 2021-04-02 04:20:36 | Stark, Ohio, US | |
2470325 | 2470325 | 2021-01-22 | US | Wisconsin | Brown | 55009 | 30691 | 201 | 0 | 30490 | 44.4526553 | -88.00411844 | 2021-01-23 05:22:03 | Brown, Wisconsin, US |
272252 | 272252 | 2020-11-10 | Mexico | San Luis Potosi | 30691 | 2202 | 27062 | 1427 | 22.1565 | -100.9855 | 2020-11-11 05:25:30 | San Luis Potosi, Mexico | ||
3652361 | 3652361 | 2020-10-24 | US | Georgia | Fulton | 13121 | 30691 | 618 | 0 | 30073 | 33.79216944 | -84.46319413 | 2020-10-25 04:24:36 | Fulton, Georgia, US |
1269821 | 1269821 | 2020-06-05 | Canada | Ontario | 30691 | 2372 | 24089 | 4824 | 51.2538 | -85.3232 | 2020-06-06 02:33:00 | Ontario, 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]);