johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 18355 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1151105 | 1151105 | 2022-12-12 | US | New Hampshire | Cheshire | 33005 | 18355 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-13 04:21:01 | Cheshire, New Hampshire, US | |
3041324 | 3041324 | 2022-10-27 | US | Tennessee | Roane | 47145 | 18355 | 256 | 0 | 35.84923189 | -84.52458689 | 2022-10-28 04:22:31 | Roane, Tennessee, US | |
2743954 | 2743954 | 2022-07-07 | US | Tennessee | Gibson | 47053 | 18355 | 263 | 0 | 35.99438059 | -88.93358327 | 2022-07-08 04:20:56 | Gibson, Tennessee, US | |
1323826 | 1323826 | 2021-11-14 | US | Massachusetts | Barnstable | 25001 | 18355 | 426 | 0 | 41.72980578 | -70.28854339 | 2021-11-15 04:21:36 | Barnstable, Massachusetts, US | |
687952 | 687952 | 2021-11-13 | US | Massachusetts | Barnstable | 25001 | 18355 | 426 | 0 | 41.72980578 | -70.28854339 | 2021-11-14 04:21:31 | Barnstable, Massachusetts, US | |
716061 | 716061 | 2021-11-12 | US | Massachusetts | Barnstable | 25001 | 18355 | 426 | 0 | 41.72980578 | -70.28854339 | 2021-11-13 04:21:38 | Barnstable, Massachusetts, US | |
7554 | 7554 | 2021-10-28 | US | Texas | Rockwall | 48397 | 18355 | 218 | 0 | 32.89779518 | -96.40771592 | 2021-10-29 04:22:03 | Rockwall, Texas, US | |
1818334 | 1818334 | 2021-09-19 | US | Wisconsin | Marathon | 55073 | 18355 | 243 | 0 | 44.89792533 | -89.75863384 | 2021-09-20 04:21:22 | Marathon, Wisconsin, US | |
19914 | 19914 | 2021-09-18 | US | Wisconsin | Marathon | 55073 | 18355 | 243 | 0 | 44.89792533 | -89.75863384 | 2021-09-19 04:21:34 | Marathon, Wisconsin, US | |
2621599 | 2621599 | 2021-09-17 | US | Wisconsin | Marathon | 55073 | 18355 | 243 | 0 | 44.89792533 | -89.75863384 | 2021-09-18 04:21:24 | Marathon, Wisconsin, US | |
3386022 | 3386022 | 2021-07-29 | US | Colorado | Mesa | 8077 | 18355 | 276 | 0 | 39.01787888 | -108.469799 | 2021-07-30 04:21:34 | Mesa, Colorado, US | |
3478657 | 3478657 | 2021-07-22 | US | North Carolina | Onslow | 37133 | 18355 | 156 | 0 | 34.72607366 | -77.42908179 | 2021-07-23 04:21:29 | Onslow, North Carolina, US | |
3659780 | 3659780 | 2021-07-11 | Russia | Altai Republic | 18355 | 259 | 17291 | 805 | 50.7114101 | 86.8572186 | 2021-07-12 04:21:34 | Altai Republic, Russia | ||
3005598 | 3005598 | 2021-04-06 | US | North Carolina | Catawba | 37035 | 18355 | 294 | 0 | 35.66211129 | -81.2132617 | 2021-04-07 04:20:53 | Catawba, North Carolina, US | |
1837724 | 1837724 | 2021-03-12 | Chile | Nuble | 18355 | 354 | 17571 | 430 | -36.7226 | -71.7622 | 2021-03-13 05:25:15 | Nuble, Chile | ||
1137339 | 1137339 | 2021-01-01 | US | Arkansas | Benton | 5007 | 18355 | 266 | 0 | 18089 | 36.33644656 | -94.25680817 | 2021-01-02 05:22:33 | Benton, Arkansas, US |
3847778 | 3847778 | 2020-12-13 | Italy | P.A. Trento | 18355 | 767 | 15073 | 2515 | 46.06893511 | 11.12123097 | 2020-12-14 05:26:27 | P.A. Trento, Italy | ||
194215 | 194215 | 2020-08-31 | Peru | Ancash | 18355 | 2283 | 0 | 16072 | -9.407125 | -77.67179499999997 | 2020-09-01 04:28:31 | Ancash, Peru | ||
2215753 | 2215753 | 2020-08-23 | Mexico | Jalisco | 18355 | 2226 | 14388 | 1741 | 20.6595 | -103.3494 | 2020-08-24 04:27:56 | Jalisco, Mexico | ||
3330027 | 3330027 | 2020-05-11 | US | Pennsylvania | Philadelphia | 42101 | 18355 | 893 | 0 | 17462 | 40.00338507 | -75.1379271 | 2020-05-12 03:32:27 | Philadelphia, Pennsylvania, 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]);