johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where active = 344, country_or_region = "US" and province_or_state = "North Carolina" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
274482 | 274482 | 2020-11-10 | US | North Carolina | Madison | 37115 | 351 | 7 | 0 | 344 | 35.85402722 | -82.71346418 | 2020-11-11 05:25:30 | Madison, North Carolina, US |
378455 | 378455 | 2020-11-06 | US | North Carolina | Alleghany | 37005 | 345 | 1 | 0 | 344 | 36.49360862 | -81.12857041 | 2020-11-07 05:24:52 | Alleghany, North Carolina, US |
2664125 | 2664125 | 2020-09-04 | US | North Carolina | Stokes | 37169 | 347 | 3 | 0 | 344 | 36.4017975 | -80.23893369 | 2020-09-05 04:28:19 | Stokes, North Carolina, US |
3180267 | 3180267 | 2020-08-18 | US | North Carolina | Alexander | 37003 | 346 | 2 | 0 | 344 | 35.9223796 | -81.17751948 | 2020-08-19 04:27:00 | Alexander, North Carolina, US |
839965 | 839965 | 2020-08-17 | US | North Carolina | Watauga | 37189 | 344 | 0 | 0 | 344 | 36.23103603 | -81.70033724 | 2020-08-18 04:27:56 | Watauga, North Carolina, US |
2037110 | 2037110 | 2020-06-27 | US | North Carolina | Craven | 37049 | 350 | 6 | 0 | 344 | 35.11833364 | -77.08398081 | 2020-06-28 04:34:04 | Craven, North Carolina, US |
1133087 | 1133087 | 2020-06-26 | US | North Carolina | Caldwell | 37027 | 348 | 4 | 0 | 344 | 35.95204977 | -81.54799522 | 2020-06-27 04:33:35 | Caldwell, North Carolina, US |
3247989 | 3247989 | 2020-06-21 | US | North Carolina | Nash | 37127 | 348 | 4 | 0 | 344 | 35.96575634 | -77.98422508 | 2020-06-22 04:33:20 | Nash, North Carolina, US |
2436541 | 2436541 | 2020-06-20 | US | North Carolina | Moore | 37125 | 355 | 11 | 0 | 344 | 35.30885257 | -79.48474178 | 2020-06-21 04:33:19 | Moore, North Carolina, US |
1195186 | 1195186 | 2020-06-17 | US | North Carolina | Surry | 37171 | 346 | 2 | 0 | 344 | 36.41689489 | -80.69102283 | 2020-06-18 04:33:18 | Surry, North Carolina, US |
216731 | 216731 | 2020-06-08 | US | North Carolina | Vance | 37181 | 370 | 26 | 0 | 344 | 36.36880673 | -78.40670845 | 2020-06-09 03:33:03 | Vance, North Carolina, US |
1278268 | 1278268 | 2020-06-04 | US | North Carolina | Buncombe | 37021 | 374 | 30 | 0 | 344 | 35.61113393 | -82.53305 | 2020-06-05 02:33:06 | Buncombe, North Carolina, US |
1864052 | 1864052 | 2020-05-22 | US | North Carolina | Sampson | 37163 | 345 | 1 | 0 | 344 | 34.98820368 | -78.36914061 | 2020-05-23 02:32:42 | Sampson, North Carolina, US |
136670 | 136670 | 2020-04-29 | US | North Carolina | Rowan | 37159 | 366 | 22 | 0 | 344 | 35.64003916 | -80.52446628 | 2020-04-30 02:32:27 | Rowan, North Carolina, 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]);