johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where confirmed = 14241 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1640905 | 1640905 | 2022-11-20 | US | California | Lake | 6033 | 14241 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-11-21 04:21:05 | Lake, California, US | |
2064462 | 2064462 | 2022-11-19 | US | California | Lake | 6033 | 14241 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-11-20 04:21:08 | Lake, California, US | |
1755856 | 1755856 | 2022-11-18 | US | California | Lake | 6033 | 14241 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-11-19 04:21:14 | Lake, California, US | |
2366435 | 2366435 | 2022-08-19 | US | Tennessee | Dyer | 47045 | 14241 | 215 | 0 | 36.05931946 | -89.41542855 | 2022-08-20 04:21:01 | Dyer, Tennessee, US | |
2744542 | 2744542 | 2022-07-07 | US | Wisconsin | Barron | 55005 | 14241 | 147 | 0 | 45.42372701 | -91.84833627 | 2022-07-08 04:20:56 | Barron, Wisconsin, US | |
1950836 | 1950836 | 2022-04-12 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-13 04:21:03 | Granville, North Carolina, US | |
3208589 | 3208589 | 2022-04-11 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-12 04:20:49 | Granville, North Carolina, US | |
1578475 | 1578475 | 2022-04-10 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-11 04:21:02 | Granville, North Carolina, US | |
1654717 | 1654717 | 2022-04-09 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-10 04:20:52 | Granville, North Carolina, US | |
2118039 | 2118039 | 2022-04-08 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-09 04:20:42 | Granville, North Carolina, US | |
3322563 | 3322563 | 2022-04-07 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-08 04:20:48 | Granville, North Carolina, US | |
2803099 | 2803099 | 2022-04-06 | US | North Carolina | Granville | 37077 | 14241 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-07 04:20:53 | Granville, North Carolina, US | |
1141402 | 1141402 | 2022-01-23 | US | Arkansas | Greene | 5055 | 14241 | 140 | 0 | 36.11735460000001 | -90.55832668 | 2022-01-24 04:21:12 | Greene, Arkansas, US | |
3521060 | 3521060 | 2022-01-02 | US | Michigan | Clinton | 26037 | 14241 | 163 | 0 | 42.94400871 | -84.60145248 | 2022-01-03 02:22:25 | Clinton, Michigan, US | |
2169190 | 2169190 | 2022-01-01 | US | Michigan | Clinton | 26037 | 14241 | 163 | 0 | 42.94400871 | -84.60145248 | 2022-01-02 04:20:52 | Clinton, Michigan, US | |
2778621 | 2778621 | 2021-12-31 | US | Michigan | Clinton | 26037 | 14241 | 163 | 0 | 42.94400871 | -84.60145248 | 2022-01-01 04:22:14 | Clinton, Michigan, US | |
4000278 | 4000278 | 2021-12-30 | US | Michigan | Clinton | 26037 | 14241 | 163 | 0 | 42.94400871 | -84.60145248 | 2021-12-31 04:21:50 | Clinton, Michigan, US | |
1670085 | 1670085 | 2021-12-29 | US | Michigan | Clinton | 26037 | 14241 | 163 | 0 | 42.94400871 | -84.60145248 | 2021-12-30 04:21:25 | Clinton, Michigan, US | |
1911848 | 1911848 | 2021-10-17 | US | Oregon | Umatilla | 41059 | 14241 | 144 | 0 | 45.59073056 | -118.7353826 | 2021-10-18 04:21:10 | Umatilla, Oregon, US | |
937437 | 937437 | 2021-10-16 | US | Oregon | Umatilla | 41059 | 14241 | 144 | 0 | 45.59073056 | -118.7353826 | 2021-10-17 04:21:29 | Umatilla, Oregon, US | |
2945992 | 2945992 | 2021-10-15 | US | Oregon | Umatilla | 41059 | 14241 | 144 | 0 | 45.59073056 | -118.7353826 | 2021-10-16 04:21:15 | Umatilla, Oregon, US | |
3011702 | 3011702 | 2021-09-22 | US | Alabama | Elmore | 1051 | 14241 | 256 | 0 | 32.59785413 | -86.14415284 | 2021-09-23 04:21:43 | Elmore, Alabama, US | |
810682 | 810682 | 2021-09-20 | US | Indiana | LaPorte | 18091 | 14241 | 237 | 0 | 41.54366008 | -86.74072188 | 2021-09-21 04:21:26 | LaPorte, Indiana, US | |
1378028 | 1378028 | 2021-09-15 | US | Wisconsin | Dodge | 55027 | 14241 | 211 | 0 | 43.41576662 | -88.70928178 | 2021-09-16 04:22:19 | Dodge, Wisconsin, US | |
2519742 | 2519742 | 2021-08-18 | US | Maine | York | 23031 | 14241 | 142 | 0 | 43.47808377 | -70.71052375 | 2021-08-19 04:21:15 | York, Maine, US | |
2765302 | 2765302 | 2021-07-01 | US | Alabama | Etowah | 1055 | 14241 | 366 | 0 | 34.04567266 | -86.04051873 | 2021-07-02 04:21:47 | Etowah, Alabama, US | |
1896368 | 1896368 | 2021-06-30 | US | Texas | Taylor | 48441 | 14241 | 415 | 0 | 32.30163422 | -99.89007449 | 2021-07-01 04:21:19 | Taylor, Texas, US | |
1893510 | 1893510 | 2021-06-30 | US | Alabama | Etowah | 1055 | 14241 | 366 | 0 | 34.04567266 | -86.04051873 | 2021-07-01 04:21:19 | Etowah, Alabama, US | |
403491 | 403491 | 2021-06-29 | US | Texas | Taylor | 48441 | 14241 | 415 | 0 | 32.30163422 | -99.89007449 | 2021-06-30 04:21:41 | Taylor, Texas, US | |
1450073 | 1450073 | 2021-06-03 | US | Louisiana | Bossier | 22015 | 14241 | 306 | 0 | 32.67932307 | -93.60460152 | 2021-06-04 04:23:37 | Bossier, Louisiana, US | |
1771412 | 1771412 | 2021-05-23 | Mali | 14241 | 514 | 9442 | 4285 | 17.570692 | -3.996166000000001 | 2021-05-24 04:20:53 | Mali | |||
2021352 | 2021352 | 2021-04-20 | US | Colorado | Mesa | 8077 | 14241 | 218 | 0 | 39.01787888 | -108.469799 | 2021-04-21 04:21:14 | Mesa, Colorado, US | |
605893 | 605893 | 2021-04-09 | Russia | Kamchatka Krai | 14241 | 213 | 13474 | 554 | 57.1914882 | 160.03838190000005 | 2021-04-10 04:20:59 | Kamchatka Krai, Russia | ||
3644337 | 3644337 | 2021-03-30 | US | Georgia | Douglas | 13097 | 14241 | 202 | 0 | 33.70291126 | -84.77026156 | 2021-03-31 04:26:25 | Douglas, Georgia, US | |
3883143 | 3883143 | 2021-01-14 | US | Wisconsin | Rock | 55105 | 14241 | 136 | 0 | 14105 | 42.67151616 | -89.07147900000002 | 2021-01-15 05:22:24 | Rock, Wisconsin, US |
2060139 | 2060139 | 2020-09-01 | Russia | Voronezh Oblast | 14241 | 115 | 12684 | 1442 | 50.9800393 | 40.15065070000001 | 2020-09-02 04:28:25 | Voronezh Oblast, Russia | ||
177289 | 177289 | 2020-07-27 | Germany | Niedersachsen | 14241 | 648 | 13200 | 392 | 52.6367 | 9.8451 | 2020-07-28 04:58:43 | Niedersachsen, Germany |
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]);