johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 16559 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1563110 | 1563110 | 2022-09-28 | US | Texas | Angelina | 48005 | 16559 | 495 | 0 | 31.25457347 | -94.60901487 | 2022-09-29 04:22:34 | Angelina, Texas, US | |
3997653 | 3997653 | 2022-09-27 | US | Texas | Angelina | 48005 | 16559 | 495 | 0 | 31.25457347 | -94.60901487 | 2022-09-28 04:23:01 | Angelina, Texas, US | |
2771981 | 2771981 | 2022-09-26 | US | Texas | Angelina | 48005 | 16559 | 495 | 0 | 31.25457347 | -94.60901487 | 2022-09-27 04:23:01 | Angelina, Texas, US | |
3617688 | 3617688 | 2022-08-01 | US | Colorado | Broomfield | 8014 | 16559 | 122 | 0 | 39.95998787 | -105.0566324 | 2022-08-02 04:20:53 | Broomfield, Colorado, US | |
2322842 | 2322842 | 2022-03-16 | US | West Virginia | Putnam | 54079 | 16559 | 172 | 0 | 38.50782345 | -81.9082131 | 2022-03-17 04:20:56 | Putnam, West Virginia, US | |
1647313 | 1647313 | 2022-03-03 | US | Tennessee | Hawkins | 47073 | 16559 | 290 | 0 | 36.44355426 | -82.94885298 | 2022-03-04 04:21:09 | Hawkins, Tennessee, US | |
2400702 | 2400702 | 2021-12-17 | US | Missouri | Cass | 29037 | 16559 | 216 | 0 | 38.64789422 | -94.353399 | 2021-12-18 02:22:20 | Cass, Missouri, US | |
1238745 | 1238745 | 2021-09-27 | US | Texas | Grayson | 48181 | 16559 | 428 | 0 | 33.62744998 | -96.67753461 | 2021-09-28 04:21:28 | Grayson, Texas, US | |
2079046 | 2079046 | 2021-09-26 | US | Texas | Grayson | 48181 | 16559 | 428 | 0 | 33.62744998 | -96.67753461 | 2021-09-27 04:21:16 | Grayson, Texas, US | |
1727598 | 1727598 | 2021-09-25 | US | Texas | Grayson | 48181 | 16559 | 428 | 0 | 33.62744998 | -96.67753461 | 2021-09-26 04:21:29 | Grayson, Texas, US | |
1117928 | 1117928 | 2021-08-06 | Togo | 16559 | 156 | 0 | 8.6195 | 0.8248 | 2021-08-07 04:21:30 | Togo | ||||
565479 | 565479 | 2021-06-22 | US | Ohio | Trumbull | 39155 | 16559 | 490 | 0 | 41.31735028 | -80.76109643 | 2021-06-23 04:21:46 | Trumbull, Ohio, US | |
3090997 | 3090997 | 2021-05-30 | US | Maryland | Harford | 24025 | 16559 | 292 | 0 | 39.55010644 | -76.30775940000002 | 2021-05-31 03:08:59 | Harford, Maryland, US | |
3884484 | 3884484 | 2021-04-11 | US | Georgia | Whitfield | 13313 | 16559 | 239 | 0 | 34.80987459 | -84.96093476 | 2021-04-12 04:21:00 | Whitfield, Georgia, US | |
2370497 | 2370497 | 2021-02-28 | US | Tennessee | Wilson | 47189 | 16559 | 210 | 0 | 16161 | 36.15496772 | -86.29775884 | 2021-03-01 05:23:01 | Wilson, Tennessee, US |
863490 | 863490 | 2020-12-11 | US | South Carolina | Horry | 45051 | 16559 | 283 | 0 | 16276 | 33.9212828 | -78.99555293 | 2020-12-12 05:26:19 | Horry, South Carolina, US |
862839 | 862839 | 2020-12-11 | US | New Jersey | Mercer | 34021 | 16559 | 682 | 0 | 15877 | 40.28047017 | -74.70479631 | 2020-12-12 05:26:19 | Mercer, New Jersey, US |
1862838 | 1862838 | 2020-05-22 | US | Texas | Harris | 48201 | 16559 | 217 | 0 | 10309 | 29.86 | -95.39 | 2020-05-23 02:32:42 | Harris, Texas, 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]);