johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 22224 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2415305 | 2415305 | 2022-12-05 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-12-06 04:21:03 | Kenai Peninsula, Alaska, US | |
718913 | 718913 | 2022-12-04 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-12-05 04:20:58 | Kenai Peninsula, Alaska, US | |
2817202 | 2817202 | 2022-12-03 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-12-04 04:20:56 | Kenai Peninsula, Alaska, US | |
834058 | 834058 | 2022-12-02 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-12-03 04:21:02 | Kenai Peninsula, Alaska, US | |
2136588 | 2136588 | 2022-12-01 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-12-02 04:21:07 | Kenai Peninsula, Alaska, US | |
1965004 | 1965004 | 2022-11-30 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-12-01 04:21:03 | Kenai Peninsula, Alaska, US | |
2557018 | 2557018 | 2022-11-29 | US | Alaska | Kenai Peninsula | 2122 | 22224 | 125 | 0 | 60.24429722 | -151.5388884 | 2022-11-30 04:21:07 | Kenai Peninsula, Alaska, US | |
3189014 | 3189014 | 2022-05-30 | US | Texas | Bastrop | 48021 | 22224 | 239 | 0 | 30.10370699 | -97.31206354 | 2022-05-31 04:20:51 | Bastrop, Texas, US | |
3201163 | 3201163 | 2022-05-29 | US | Texas | Bastrop | 48021 | 22224 | 239 | 0 | 30.10370699 | -97.31206354 | 2022-05-30 04:20:50 | Bastrop, Texas, US | |
2728041 | 2728041 | 2022-05-28 | US | Texas | Bastrop | 48021 | 22224 | 239 | 0 | 30.10370699 | -97.31206354 | 2022-05-29 04:20:53 | Bastrop, Texas, US | |
1317222 | 1317222 | 2022-05-27 | US | Texas | Bastrop | 48021 | 22224 | 239 | 0 | 30.10370699 | -97.31206354 | 2022-05-28 04:21:07 | Bastrop, Texas, US | |
1328650 | 1328650 | 2022-04-26 | US | North Dakota | Grand Forks | 38035 | 22224 | 125 | 0 | 47.92093639 | -97.45450447 | 2022-04-27 04:20:52 | Grand Forks, North Dakota, US | |
2528003 | 2528003 | 2022-03-02 | US | Oregon | Umatilla | 41059 | 22224 | 201 | 0 | 45.59073056 | -118.7353826 | 2022-03-03 04:21:01 | Umatilla, Oregon, US | |
2660627 | 2660627 | 2022-01-31 | US | South Carolina | Oconee | 45073 | 22224 | 283 | 0 | 34.75225169 | -83.06742317 | 2022-02-01 04:21:11 | Oconee, South Carolina, US | |
3303044 | 3303044 | 2022-01-30 | US | South Carolina | Oconee | 45073 | 22224 | 283 | 0 | 34.75225169 | -83.06742317 | 2022-01-31 04:21:09 | Oconee, South Carolina, US | |
3064835 | 3064835 | 2022-01-29 | US | South Carolina | Oconee | 45073 | 22224 | 283 | 0 | 34.75225169 | -83.06742317 | 2022-01-30 04:21:26 | Oconee, South Carolina, US | |
3812769 | 3812769 | 2022-01-28 | US | South Carolina | Oconee | 45073 | 22224 | 283 | 0 | 34.75225169 | -83.06742317 | 2022-01-29 04:21:10 | Oconee, South Carolina, US | |
3519370 | 3519370 | 2022-01-02 | India | Ladakh | 22224 | 220 | 0 | 34.1526 | 77.5771 | 2022-01-03 02:22:25 | Ladakh, India | |||
54595 | 54595 | 2021-03-07 | Chile | Magallanes | 22224 | 324 | 21533 | 367 | -52.368 | -70.9863 | 2021-03-08 05:24:48 | Magallanes, Chile | ||
3691696 | 3691696 | 2020-12-24 | Russia | Leningrad Oblast | 22224 | 221 | 20014 | 1989 | 60.1853296 | 32.3925325 | 2020-12-25 05:22:48 | Leningrad Oblast, Russia | ||
3691336 | 3691336 | 2020-12-24 | Colombia | Quindio | 22224 | 606 | 19984 | 1634 | 4.461 | -75.6674 | 2020-12-25 05:22:48 | Quindio, Colombia | ||
803924 | 803924 | 2020-06-01 | US | Massachusetts | Middlesex | 25017 | 22224 | 1650 | 0 | 20574 | 42.48607732 | -71.39049229 | 2020-06-02 02:33:08 | Middlesex, Massachusetts, US |
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]);