johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where confirmed = 14486 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3174347 | 3174347 | 2022-12-19 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-20 04:21:04 | Lake, California, US | |
1628864 | 1628864 | 2022-12-18 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-19 04:21:03 | Lake, California, US | |
504243 | 504243 | 2022-12-17 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-18 04:21:03 | Lake, California, US | |
3324815 | 3324815 | 2022-12-16 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-17 04:21:04 | Lake, California, US | |
543327 | 543327 | 2022-12-15 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-16 04:21:01 | Lake, California, US | |
348855 | 348855 | 2022-12-14 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-15 04:20:58 | Lake, California, US | |
308443 | 308443 | 2022-12-13 | US | California | Lake | 6033 | 14486 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-14 04:21:04 | Lake, California, US | |
3253273 | 3253273 | 2022-10-11 | US | Texas | Hood | 48221 | 14486 | 285 | 0 | 32.42990927 | -97.83242024 | 2022-10-12 04:22:51 | Hood, Texas, US | |
2970532 | 2970532 | 2022-10-10 | US | Texas | Hood | 48221 | 14486 | 285 | 0 | 32.42990927 | -97.83242024 | 2022-10-11 04:23:05 | Hood, Texas, US | |
2358392 | 2358392 | 2022-09-16 | US | Tennessee | Campbell | 47013 | 14486 | 179 | 0 | 36.40355516 | -84.1510856 | 2022-09-17 04:20:19 | Campbell, Tennessee, US | |
3550942 | 3550942 | 2022-09-01 | US | Washington | Clallam | 53009 | 14486 | 167 | 0 | 48.04754642 | -123.9226319 | 2022-09-02 04:21:07 | Clallam, Washington, US | |
2346862 | 2346862 | 2022-08-31 | US | Washington | Clallam | 53009 | 14486 | 167 | 0 | 48.04754642 | -123.9226319 | 2022-09-01 04:21:03 | Clallam, Washington, US | |
231527 | 231527 | 2022-05-31 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-06-01 04:20:55 | Carteret, North Carolina, US | |
3188292 | 3188292 | 2022-05-30 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-31 04:20:51 | Carteret, North Carolina, US | |
3200441 | 3200441 | 2022-05-29 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-30 04:20:50 | Carteret, North Carolina, US | |
2727319 | 2727319 | 2022-05-28 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-29 04:20:53 | Carteret, North Carolina, US | |
1316500 | 1316500 | 2022-05-27 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-28 04:21:07 | Carteret, North Carolina, US | |
1852292 | 1852292 | 2022-05-26 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-27 04:20:56 | Carteret, North Carolina, US | |
2050168 | 2050168 | 2022-05-25 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-26 04:20:50 | Carteret, North Carolina, US | |
624179 | 624179 | 2022-05-22 | US | North Carolina | Carteret | 37031 | 14486 | 125 | 0 | 34.8932941 | -76.54120135 | 2022-05-26 04:20:50 | Carteret, North Carolina, US | |
2963925 | 2963925 | 2021-12-24 | US | Arkansas | White | 5145 | 14486 | 209 | 0 | 35.25688493 | -91.74908296 | 2021-12-25 04:21:37 | White, Arkansas, US | |
140914 | 140914 | 2021-12-04 | US | Tennessee | Greene | 47059 | 14486 | 247 | 0 | 36.17470125 | -82.84691273 | 2021-12-05 04:22:25 | Greene, Tennessee, US | |
1724471 | 1724471 | 2021-09-25 | Italy | Molise | 14486 | 496 | 0 | 41.55774754 | 14.65916051 | 2021-09-26 04:21:29 | Molise, Italy | |||
3011357 | 3011357 | 2021-09-22 | Japan | Mie | 14486 | 158 | 0 | 34.508018 | 136.376013 | 2021-09-23 04:21:43 | Mie, Japan | |||
3706459 | 3706459 | 2021-07-17 | Tajikistan | 14486 | 111 | 13659 | 716 | 38.861 | 71.2761 | 2021-07-18 04:22:07 | Tajikistan | |||
578902 | 578902 | 2021-07-13 | Mali | 14486 | 528 | 10655 | 3303 | 17.570692 | -3.996166000000001 | 2021-07-14 04:21:35 | Mali | |||
2339931 | 2339931 | 2021-06-15 | US | California | Butte | 6007 | 14486 | 194 | 0 | 39.66727762 | -121.6005252 | 2021-06-16 04:22:32 | Butte, California, US | |
3574876 | 3574876 | 2021-05-17 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-18 04:20:33 | Somalia | |||
2939606 | 2939606 | 2021-05-16 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-17 04:20:34 | Somalia | |||
1873236 | 1873236 | 2021-05-15 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-16 04:20:49 | Somalia | |||
1084606 | 1084606 | 2021-05-14 | US | Pennsylvania | Monroe | 42089 | 14486 | 308 | 0 | 41.05934058 | -75.34031025 | 2021-05-15 04:20:58 | Monroe, Pennsylvania, US | |
1082205 | 1082205 | 2021-05-14 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-15 04:20:58 | Somalia | |||
3054471 | 3054471 | 2021-05-13 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-14 04:20:41 | Somalia | |||
2004941 | 2004941 | 2021-05-12 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-13 04:20:51 | Somalia | |||
3954772 | 3954772 | 2021-05-11 | Somalia | 14486 | 753 | 6325 | 7408 | 5.152149 | 46.199616 | 2021-05-12 04:21:29 | Somalia | |||
3675856 | 3675856 | 2021-05-04 | Russia | Kamchatka Krai | 14486 | 230 | 13835 | 421 | 57.1914882 | 160.03838190000005 | 2021-05-05 04:20:43 | Kamchatka Krai, Russia | ||
1529535 | 1529535 | 2021-02-09 | US | Michigan | Kalamazoo | 26077 | 14486 | 315 | 0 | 14171 | 42.24542231 | -85.53038622 | 2021-02-10 05:22:41 | Kalamazoo, Michigan, US |
3691683 | 3691683 | 2020-12-24 | Russia | Karachay-Cherkess Republic | 14486 | 38 | 12905 | 1543 | 43.7368326 | 41.7267991 | 2020-12-25 05:22:48 | Karachay-Cherkess Republic, Russia | ||
1732115 | 1732115 | 2020-11-08 | Ukraine | Sumy Oblast | 14486 | 224 | 5793 | 8469 | 50.9077 | 34.7981 | 2020-11-09 05:25:45 | Sumy Oblast, Ukraine | ||
894258 | 894258 | 2020-11-05 | US | Nevada | Washoe | 32031 | 14486 | 203 | 0 | 14283 | 40.66562265 | -119.6631594 | 2020-11-06 05:24:55 | Washoe, Nevada, US |
3307368 | 3307368 | 2020-11-02 | US | Texas | Nueces | 48355 | 14486 | 449 | 0 | 20983 | 27.736286 | -97.5433285 | 2020-11-03 06:00:16 | Nueces, Texas, US |
3562730 | 3562730 | 2020-08-25 | Peru | Loreto | 14486 | 2584 | 0 | 11902 | -4.124847 | -74.424115 | 2020-08-26 04:28:11 | Loreto, 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]);