johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 17976 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2439223 | 2439223 | 2022-11-07 | US | Arkansas | Crawford | 5033 | 17976 | 279 | 0 | 35.58928601 | -94.2446814 | 2022-11-08 04:21:21 | Crawford, Arkansas, US | |
1050321 | 1050321 | 2022-11-06 | US | Arkansas | Crawford | 5033 | 17976 | 279 | 0 | 35.58928601 | -94.2446814 | 2022-11-07 04:21:26 | Crawford, Arkansas, US | |
3100913 | 3100913 | 2022-10-09 | US | Washington | Walla Walla | 53071 | 17976 | 156 | 0 | 46.23040051 | -118.4775539 | 2022-10-10 04:22:32 | Walla Walla, Washington, US | |
4006138 | 4006138 | 2022-10-08 | US | Washington | Walla Walla | 53071 | 17976 | 156 | 0 | 46.23040051 | -118.4775539 | 2022-10-09 04:21:16 | Walla Walla, Washington, US | |
399735 | 399735 | 2022-10-07 | US | Washington | Walla Walla | 53071 | 17976 | 156 | 0 | 46.23040051 | -118.4775539 | 2022-10-08 04:22:56 | Walla Walla, Washington, US | |
2636712 | 2636712 | 2022-09-05 | US | Tennessee | Roane | 47145 | 17976 | 248 | 0 | 35.84923189 | -84.52458689 | 2022-09-06 04:21:02 | Roane, Tennessee, US | |
3407684 | 3407684 | 2022-07-17 | US | New York | Cayuga | 36011 | 17976 | 161 | 0 | 42.91261714 | -76.55731592 | 2022-07-18 04:20:59 | Cayuga, New York, US | |
950157 | 950157 | 2022-06-14 | US | Virginia | Bedford | 51019 | 17976 | 242 | 0 | 37.3080028 | -79.5281964 | 2022-06-15 04:20:54 | Bedford, Virginia, US | |
3447073 | 3447073 | 2022-05-11 | US | New York | Clinton | 36019 | 17976 | 90 | 0 | 44.74530905 | -73.67875352 | 2022-05-12 04:20:54 | Clinton, New York, US | |
277778 | 277778 | 2021-11-03 | US | Massachusetts | Barnstable | 25001 | 17976 | 424 | 0 | 41.72980578 | -70.28854339 | 2021-11-04 04:22:20 | Barnstable, Massachusetts, US | |
860667 | 860667 | 2020-12-11 | Italy | P.A. Trento | 17976 | 754 | 14783 | 2439 | 46.06893511 | 11.12123097 | 2020-12-12 05:26:19 | P.A. Trento, Italy | ||
2081491 | 2081491 | 2020-10-31 | US | Maryland | Baltimore City | 24510 | 17976 | 504 | 0 | 17472 | 39.30211911 | -76.61151012 | 2020-11-01 04:36:19 | Baltimore City, Maryland, US |
2511280 | 2511280 | 2020-08-27 | US | Indiana | Marion | 18097 | 17976 | 783 | 0 | 17193 | 39.78163624 | -86.13826325 | 2020-08-28 04:28:11 | Marion, Indiana, US |
3791603 | 3791603 | 2020-08-05 | US | Maryland | Montgomery | 24031 | 17976 | 794 | 0 | 17182 | 39.13676329 | -77.20358245 | 2020-08-06 04:35:02 | Montgomery, Maryland, 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]);