johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 20188 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1988160 | 1988160 | 2022-12-07 | US | West Virginia | Putnam | 54079 | 20188 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-08 04:21:07 | Putnam, West Virginia, US | |
898793 | 898793 | 2022-07-24 | US | Oregon | Yamhill | 41071 | 20188 | 231 | 0 | 45.23330449 | -123.3086963 | 2022-07-25 04:20:51 | Yamhill, Oregon, US | |
897303 | 897303 | 2022-07-24 | US | Indiana | Wayne | 18177 | 20188 | 340 | 0 | 39.8633444 | -85.01044989 | 2022-07-25 04:20:51 | Wayne, Indiana, US | |
93787 | 93787 | 2022-07-23 | US | Oregon | Yamhill | 41071 | 20188 | 231 | 0 | 45.23330449 | -123.3086963 | 2022-07-24 04:20:47 | Yamhill, Oregon, US | |
92297 | 92297 | 2022-07-23 | US | Indiana | Wayne | 18177 | 20188 | 340 | 0 | 39.8633444 | -85.01044989 | 2022-07-24 04:20:47 | Wayne, Indiana, US | |
902809 | 902809 | 2022-07-22 | US | Oregon | Yamhill | 41071 | 20188 | 231 | 0 | 45.23330449 | -123.3086963 | 2022-07-23 04:20:53 | Yamhill, Oregon, US | |
901319 | 901319 | 2022-07-22 | US | Indiana | Wayne | 18177 | 20188 | 340 | 0 | 39.8633444 | -85.01044989 | 2022-07-23 04:20:53 | Wayne, Indiana, US | |
1421609 | 1421609 | 2022-06-08 | US | Arkansas | Lonoke | 5085 | 20188 | 246 | 0 | 34.75392199 | -91.88742357 | 2022-06-09 04:20:54 | Lonoke, Arkansas, US | |
3870915 | 3870915 | 2022-04-05 | US | Virginia | Lynchburg | 51680 | 20188 | 267 | 0 | 37.40021399 | -79.19888138 | 2022-04-06 04:20:49 | Lynchburg, Virginia, US | |
1365745 | 1365745 | 2022-02-08 | US | Virginia | Portsmouth | 51740 | 20188 | 275 | 0 | 36.85914825 | -76.35971629 | 2022-02-09 04:21:04 | Portsmouth, Virginia, US | |
1695419 | 1695419 | 2022-01-10 | US | Texas | Grayson | 48181 | 20188 | 542 | 0 | 33.62744998 | -96.67753461 | 2022-01-11 04:22:01 | Grayson, Texas, US | |
44633 | 44633 | 2021-11-02 | US | Idaho | Bonneville | 16019 | 20188 | 212 | 0 | 43.38713372 | -111.6161537 | 2021-11-03 06:22:09 | Bonneville, Idaho, US | |
105237 | 105237 | 2021-08-15 | US | Missouri | Jasper | 29097 | 20188 | 283 | 0 | 37.20351921 | -94.34050458 | 2021-08-16 04:21:31 | Jasper, Missouri, US | |
410166 | 410166 | 2021-07-28 | US | Missouri | Boone | 29019 | 20188 | 100 | 0 | 38.99186229 | -92.30723575 | 2021-07-29 04:21:33 | Boone, Missouri, US | |
1810374 | 1810374 | 2021-05-27 | Ukraine | Kirovohrad Oblast | 20188 | 788 | 16536 | 2864 | 48.5079 | 32.2623 | 2021-05-28 04:20:36 | Kirovohrad Oblast, Ukraine | ||
1554628 | 1554628 | 2021-05-08 | US | Pennsylvania | Cumberland | 42041 | 20188 | 517 | 0 | 40.1625372 | -77.26130755 | 2021-05-09 04:20:35 | Cumberland, Pennsylvania, US | |
955081 | 955081 | 2021-04-25 | Russia | Kurgan Oblast | 20188 | 383 | 18796 | 1009 | 55.7655302 | 64.5632681 | 2021-04-26 04:21:04 | Kurgan Oblast, Russia | ||
2572885 | 2572885 | 2021-04-13 | US | Iowa | Linn | 19113 | 20188 | 329 | 0 | 42.07923082 | -91.59809485 | 2021-04-14 04:20:41 | Linn, Iowa, US | |
1090801 | 1090801 | 2021-03-03 | US | Florida | St. Johns | 12109 | 20188 | 197 | 0 | 19991 | 29.90096506 | -81.43589967 | 2021-03-04 05:24:24 | St. Johns, Florida, US |
3232613 | 3232613 | 2021-01-03 | US | New Jersey | Mercer | 34021 | 20188 | 725 | 0 | 19463 | 40.28047017 | -74.70479631 | 2021-01-04 05:22:02 | Mercer, New Jersey, US |
1046186 | 1046186 | 2020-09-30 | US | Alabama | Jefferson | 1073 | 20188 | 352 | 0 | 19836 | 33.55554728 | -86.89506300000002 | 2020-10-01 04:23:42 | Jefferson, Alabama, US |
2868862 | 2868862 | 2020-09-13 | Peru | Ancash | 20188 | 2402 | 0 | 17786 | -9.407125 | -77.671795 | 2020-09-14 04:26:00 | Ancash, 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]);