johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where confirmed = 19828 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 53
- Russia 4
- Timor-Leste 3
- Bulgaria 1
- Japan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954025 | 2954025 | 2022-12-20 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-21 04:21:03 | Polk, Oregon, US | |
3176427 | 3176427 | 2022-12-19 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-20 04:21:04 | Polk, Oregon, US | |
1630944 | 1630944 | 2022-12-18 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-19 04:21:03 | Polk, Oregon, US | |
506323 | 506323 | 2022-12-17 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-18 04:21:03 | Polk, Oregon, US | |
3326895 | 3326895 | 2022-12-16 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-17 04:21:04 | Polk, Oregon, US | |
545407 | 545407 | 2022-12-15 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-16 04:21:01 | Polk, Oregon, US | |
350935 | 350935 | 2022-12-14 | US | Oregon | Polk | 41053 | 19828 | 160 | 0 | 44.90322804 | -123.4128888 | 2022-12-15 04:20:58 | Polk, Oregon, US | |
796111 | 796111 | 2022-10-24 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-25 04:21:53 | Van Buren, Michigan, US | |
3278566 | 3278566 | 2022-10-23 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-24 04:22:29 | Van Buren, Michigan, US | |
2269604 | 2269604 | 2022-10-22 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-23 04:22:46 | Van Buren, Michigan, US | |
1593904 | 1593904 | 2022-10-21 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-22 04:22:53 | Van Buren, Michigan, US | |
2273620 | 2273620 | 2022-10-20 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-21 04:22:23 | Van Buren, Michigan, US | |
199955 | 199955 | 2022-10-19 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-20 04:22:59 | Van Buren, Michigan, US | |
2758616 | 2758616 | 2022-10-18 | US | Michigan | Van Buren | 26159 | 19828 | 302 | 0 | 42.25190229 | -86.01939087 | 2022-10-19 04:22:26 | Van Buren, Michigan, US | |
518683 | 518683 | 2022-10-15 | US | Tennessee | Hawkins | 47073 | 19828 | 345 | 0 | 36.44355426 | -82.94885298 | 2022-10-16 04:22:39 | Hawkins, Tennessee, US | |
2345708 | 2345708 | 2022-08-31 | US | New York | Wayne | 36117 | 19828 | 191 | 0 | 43.15494365 | -77.02976528 | 2022-09-01 04:21:03 | Wayne, New York, US | |
3775595 | 3775595 | 2022-08-30 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-31 04:20:57 | Shiawassee, Michigan, US | |
1682191 | 1682191 | 2022-08-29 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-30 04:21:03 | Shiawassee, Michigan, US | |
1878675 | 1878675 | 2022-08-28 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-29 04:21:06 | Shiawassee, Michigan, US | |
2097802 | 2097802 | 2022-08-27 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-28 04:21:02 | Shiawassee, Michigan, US | |
1533617 | 1533617 | 2022-08-26 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-27 04:20:57 | Shiawassee, Michigan, US | |
2830504 | 2830504 | 2022-08-25 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-26 04:21:02 | Shiawassee, Michigan, US | |
2325037 | 2325037 | 2022-08-24 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-25 04:21:13 | Shiawassee, Michigan, US | |
1252446 | 1252446 | 2022-08-23 | US | Michigan | Shiawassee | 26155 | 19828 | 235 | 0 | 42.953928 | -84.14585902 | 2022-08-24 04:20:46 | Shiawassee, Michigan, US | |
2853382 | 2853382 | 2022-08-22 | US | Arkansas | Pope | 5115 | 19828 | 216 | 0 | 35.44871474 | -93.03212219 | 2022-08-23 04:20:56 | Pope, Arkansas, US | |
961262 | 961262 | 2022-07-19 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-20 04:20:59 | Sampson, North Carolina, US | |
3212649 | 3212649 | 2022-07-18 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-19 04:20:58 | Sampson, North Carolina, US | |
3407824 | 3407824 | 2022-07-17 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-18 04:20:59 | Sampson, North Carolina, US | |
2154024 | 2154024 | 2022-07-16 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-17 04:21:15 | Sampson, North Carolina, US | |
2421257 | 2421257 | 2022-07-15 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-16 04:21:05 | Sampson, North Carolina, US | |
3431332 | 3431332 | 2022-07-14 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-15 04:20:53 | Sampson, North Carolina, US | |
3111852 | 3111852 | 2022-07-13 | US | North Carolina | Sampson | 37163 | 19828 | 188 | 0 | 34.98820368 | -78.36914061 | 2022-07-14 04:20:57 | Sampson, North Carolina, US | |
2187839 | 2187839 | 2022-06-22 | Russia | Magadan Oblast | 19828 | 390 | 0 | 62.48858785 | 153.9903764 | 2022-06-23 04:20:55 | Magadan Oblast, Russia | |||
166270 | 166270 | 2022-06-21 | Russia | Magadan Oblast | 19828 | 390 | 0 | 62.48858785 | 153.9903764 | 2022-06-22 04:20:54 | Magadan Oblast, Russia | |||
1763553 | 1763553 | 2022-06-20 | Russia | Magadan Oblast | 19828 | 390 | 0 | 62.48858785 | 153.9903764 | 2022-06-21 04:20:56 | Magadan Oblast, Russia | |||
231889 | 231889 | 2022-05-31 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-06-01 04:20:55 | Clearfield, Pennsylvania, US | |
3188654 | 3188654 | 2022-05-30 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-31 04:20:51 | Clearfield, Pennsylvania, US | |
3200803 | 3200803 | 2022-05-29 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-30 04:20:50 | Clearfield, Pennsylvania, US | |
2727681 | 2727681 | 2022-05-28 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-29 04:20:53 | Clearfield, Pennsylvania, US | |
1316862 | 1316862 | 2022-05-27 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-28 04:21:07 | Clearfield, Pennsylvania, US | |
1852654 | 1852654 | 2022-05-26 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-27 04:20:56 | Clearfield, Pennsylvania, US | |
2050530 | 2050530 | 2022-05-25 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-26 04:20:50 | Clearfield, Pennsylvania, US | |
624541 | 624541 | 2022-05-22 | US | Pennsylvania | Clearfield | 42033 | 19828 | 351 | 0 | 41.00110782 | -78.47592663 | 2022-05-26 04:20:50 | Clearfield, Pennsylvania, US | |
3267091 | 3267091 | 2022-05-04 | US | Maryland | Wicomico | 24045 | 19828 | 327 | 0 | 38.37301947 | -75.62705831 | 2022-05-05 04:20:55 | Wicomico, Maryland, US | |
2446243 | 2446243 | 2022-04-13 | US | West Virginia | Harrison | 54033 | 19828 | 248 | 0 | 39.2853852 | -80.37919577 | 2022-04-13 23:21:06 | Harrison, West Virginia, US | |
336486 | 336486 | 2022-03-18 | US | California | Humboldt | 6023 | 19828 | 141 | 0 | 40.69923009 | -123.876044 | 2022-03-19 04:20:47 | Humboldt, California, US | |
1057881 | 1057881 | 2022-02-23 | Japan | Yamaguchi | 19828 | 120 | 0 | 34.201190000000004 | 131.573293 | 2022-02-24 04:21:14 | Yamaguchi, Japan | |||
1033679 | 1033679 | 2021-12-06 | US | Virginia | Arlington | 51013 | 19828 | 276 | 0 | 38.8767675 | -77.10139853 | 2021-12-07 04:22:34 | Arlington, Virginia, US | |
1030714 | 1030714 | 2021-12-06 | Timor-Leste | 19828 | 122 | 0 | -8.874217 | 125.727539 | 2021-12-07 04:22:34 | Timor-Leste | ||||
1740877 | 1740877 | 2021-12-05 | Timor-Leste | 19828 | 122 | 0 | -8.874217 | 125.727539 | 2021-12-06 04:22:34 | Timor-Leste | ||||
138309 | 138309 | 2021-12-04 | Timor-Leste | 19828 | 122 | 0 | -8.874217 | 125.727539 | 2021-12-05 04:22:25 | Timor-Leste | ||||
470973 | 470973 | 2021-10-07 | US | Wisconsin | Marathon | 55073 | 19828 | 254 | 0 | 44.89792533 | -89.75863384 | 2021-10-08 04:21:25 | Marathon, Wisconsin, US | |
1777955 | 1777955 | 2021-08-30 | US | Oklahoma | Unassigned | 90040 | 19828 | 0 | 0 | 36.83532655 | 0.0 | 2021-08-31 04:21:46 | Unassigned, Oklahoma, US | |
2352561 | 2352561 | 2021-08-10 | US | Indiana | Porter | 18127 | 19828 | 328 | 0 | 41.45986947 | -87.06848888 | 2021-08-11 04:21:58 | Porter, Indiana, US | |
2424465 | 2424465 | 2021-06-23 | US | Maryland | Frederick | 24021 | 19828 | 342 | 0 | 39.47296601 | -77.39999394 | 2021-06-24 04:21:55 | Frederick, Maryland, US | |
3883794 | 3883794 | 2021-04-11 | Russia | Karachay-Cherkess Republic | 19828 | 73 | 19482 | 273 | 43.7368326 | 41.7267991 | 2021-04-12 04:21:00 | Karachay-Cherkess Republic, Russia | ||
1220772 | 1220772 | 2021-03-27 | US | Iowa | Linn | 19113 | 19828 | 324 | 0 | 42.07923082 | -91.59809485 | 2021-03-28 05:28:10 | Linn, Iowa, US | |
3455336 | 3455336 | 2021-03-18 | US | Ohio | Mahoning | 39099 | 19828 | 597 | 0 | 41.01631101 | -80.77287029 | 2021-03-19 05:26:09 | Mahoning, Ohio, US | |
2812508 | 2812508 | 2020-09-25 | Bulgaria | 19828 | 789 | 14132 | 4907 | 42.7339 | 25.4858 | 2020-09-26 04:23:00 | Bulgaria | |||
2850495 | 2850495 | 2020-09-18 | US | Michigan | Oakland | 26125 | 19828 | 1191 | 0 | 18637 | 42.66090111 | -83.38595416 | 2020-09-19 04:22:00 | Oakland, Michigan, US |
3489239 | 3489239 | 2020-07-13 | US | Florida | Hillsborough | 12057 | 19828 | 188 | 0 | 19640 | 27.9276559 | -82.32013172 | 2020-07-14 04:34:46 | Hillsborough, Florida, US |
2681715 | 2681715 | 2020-07-06 | US | New Jersey | Bergen | 34003 | 19828 | 2006 | 0 | 17822 | 40.96010917 | -74.07164325 | 2020-07-07 04:34:00 | Bergen, New Jersey, 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]);