johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where confirmed = 18013 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2377090 | 2377090 | 2022-09-29 | US | Louisiana | Vermilion | 22113 | 18013 | 238 | 0 | 29.83517605 | -92.30292538 | 2022-09-30 04:23:09 | Vermilion, Louisiana, US | |
3996947 | 3996947 | 2022-09-27 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-28 04:23:01 | Columbus, North Carolina, US | |
2771275 | 2771275 | 2022-09-26 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-27 04:23:01 | Columbus, North Carolina, US | |
1978928 | 1978928 | 2022-09-25 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-26 04:20:52 | Columbus, North Carolina, US | |
2652095 | 2652095 | 2022-09-24 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-25 04:23:31 | Columbus, North Carolina, US | |
386535 | 386535 | 2022-09-23 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-24 04:21:40 | Columbus, North Carolina, US | |
1626601 | 1626601 | 2022-09-22 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-23 04:23:13 | Columbus, North Carolina, US | |
1372805 | 1372805 | 2022-09-21 | US | North Carolina | Columbus | 37047 | 18013 | 280 | 0 | 34.26744084 | -78.65801424 | 2022-09-22 04:22:56 | Columbus, North Carolina, US | |
2491589 | 2491589 | 2022-06-29 | US | Maryland | Allegany | 24001 | 18013 | 365 | 0 | 39.62357628 | -78.69280486 | 2022-06-30 04:21:01 | Allegany, Maryland, US | |
749116 | 749116 | 2022-04-23 | US | Puerto Rico | Ponce | 72113 | 18013 | 0 | 0 | 18.059498 | -66.613748 | 2022-04-24 04:20:56 | Ponce, Puerto Rico, US | |
3673926 | 3673926 | 2022-02-15 | US | New York | Sullivan | 36105 | 18013 | 124 | 0 | 41.71579493 | -74.76394559 | 2022-02-16 04:21:10 | Sullivan, New York, US | |
1365182 | 1365182 | 2022-02-08 | US | South Carolina | Laurens | 45059 | 18013 | 264 | 0 | 34.48244419 | -82.00490796 | 2022-02-09 04:21:04 | Laurens, South Carolina, US | |
2330064 | 2330064 | 2022-02-04 | US | Pennsylvania | Somerset | 42111 | 18013 | 379 | 0 | 39.97172723 | -79.02699593 | 2022-02-05 04:21:05 | Somerset, Pennsylvania, US | |
3427219 | 3427219 | 2022-01-21 | US | New York | St. Lawrence | 36089 | 18013 | 164 | 0 | 44.4976179 | -75.06550039 | 2022-01-22 04:21:13 | St. Lawrence, New York, US | |
2112798 | 2112798 | 2021-12-26 | US | Indiana | Howard | 18067 | 18013 | 340 | 0 | 40.48527731 | -86.11351892 | 2021-12-27 04:21:58 | Howard, Indiana, US | |
3606170 | 3606170 | 2021-12-25 | US | Indiana | Howard | 18067 | 18013 | 340 | 0 | 40.48527731 | -86.11351892 | 2021-12-26 04:21:50 | Howard, Indiana, US | |
2964488 | 2964488 | 2021-12-24 | US | Indiana | Howard | 18067 | 18013 | 340 | 0 | 40.48527731 | -86.11351892 | 2021-12-25 04:21:37 | Howard, Indiana, US | |
3817520 | 3817520 | 2021-12-23 | US | Indiana | Howard | 18067 | 18013 | 340 | 0 | 40.48527731 | -86.11351892 | 2021-12-24 04:21:34 | Howard, Indiana, US | |
799528 | 799528 | 2021-12-22 | US | Indiana | Howard | 18067 | 18013 | 340 | 0 | 40.48527731 | -86.11351892 | 2021-12-23 04:21:21 | Howard, Indiana, US | |
470647 | 470647 | 2021-10-07 | US | Texas | Tom Green | 48451 | 18013 | 376 | 0 | 31.40464436 | -100.46244300000001 | 2021-10-08 04:21:25 | Tom Green, Texas, US | |
2767749 | 2767749 | 2021-07-01 | US | South Carolina | Florence | 45041 | 18013 | 424 | 0 | 34.02361754 | -79.70189312 | 2021-07-02 04:21:47 | Florence, South Carolina, US | |
2426266 | 2426266 | 2021-06-23 | US | Virginia | Norfolk | 51710 | 18013 | 269 | 0 | 36.89934014 | -76.26420872 | 2021-06-24 04:21:55 | Norfolk, Virginia, US | |
3643876 | 3643876 | 2021-03-30 | Sweden | Vasterbotten | 18013 | 166 | 0 | 17847 | 65.3337 | 16.5162 | 2021-03-31 04:26:25 | Vasterbotten, Sweden | ||
1206098 | 1206098 | 2021-03-22 | US | North Carolina | Catawba | 37035 | 18013 | 289 | 0 | 35.66211129 | -81.2132617 | 2021-03-23 05:26:18 | Catawba, North Carolina, US | |
1672662 | 1672662 | 2021-02-07 | Russia | Karachay-Cherkess Republic | 18013 | 60 | 16360 | 1593 | 43.7368326 | 41.7267991 | 2021-02-08 05:22:39 | Karachay-Cherkess Republic, Russia | ||
1137084 | 1137084 | 2021-01-01 | Russia | Kaliningrad Oblast | 18013 | 178 | 16305 | 1530 | 54.7293041 | 21.1489473 | 2021-01-02 05:22:33 | Kaliningrad Oblast, Russia | ||
824453 | 824453 | 2020-11-19 | US | South Dakota | Minnehaha | 46099 | 18013 | 149 | 0 | 17864 | 43.67441641 | -96.7910885 | 2020-11-20 05:26:28 | Minnehaha, South Dakota, US |
2860471 | 2860471 | 2020-10-16 | Ukraine | Odessa Oblast | 18013 | 279 | 2853 | 14881 | 46.4846 | 30.7326 | 2020-10-17 04:24:12 | Odessa Oblast, Ukraine | ||
610210 | 610210 | 2020-08-29 | US | California | Alameda | 6001 | 18013 | 250 | 0 | 17773 | 37.64629437 | -121.8929271 | 2020-08-30 04:28:22 | Alameda, California, US |
1837121 | 1837121 | 2020-06-14 | Pakistan | Khyber Pakhtunkhwa | 18013 | 675 | 4539 | 12799 | 34.485332 | 72.09169 | 2020-06-15 03:33:14 | Khyber Pakhtunkhwa, Pakistan | ||
1038254 | 1038254 | 2020-05-26 | US | New Jersey | Bergen | 34003 | 18013 | 1528 | 0 | 16485 | 40.96010917 | -74.07164325 | 2020-05-27 02:32:31 | Bergen, New Jersey, 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]);