johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where active = 5596 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3970490 | 3970490 | 2021-06-11 | India | Bihar | 716296 | 9466 | 701234 | 5596 | 25.679658 | 85.60484 | 2021-06-12 04:22:22 | Bihar, India | ||
829251 | 829251 | 2021-06-06 | Zambia | 100278 | 1308 | 93374 | 5596 | -13.133897 | 27.849332 | 2021-06-07 04:22:51 | Zambia | |||
534143 | 534143 | 2021-02-22 | US | Washington | Kitsap | 53035 | 5680 | 84 | 0 | 5596 | 47.63479026 | -122.6436061 | 2021-02-23 05:23:41 | Kitsap, Washington, US |
616499 | 616499 | 2021-02-08 | US | South Carolina | Georgetown | 45043 | 5726 | 130 | 0 | 5596 | 33.43443342 | -79.33202141 | 2021-02-09 05:23:30 | Georgetown, South Carolina, US |
793304 | 793304 | 2021-02-04 | US | Tennessee | Cumberland | 47035 | 5891 | 97 | 0 | 5596 | 35.95271721 | -84.99840585 | 2021-02-05 05:22:38 | Cumberland, Tennessee, US |
13294 | 13294 | 2021-01-26 | US | Illinois | Boone | 17007 | 5664 | 68 | 0 | 5596 | 42.32359279 | -88.82345779 | 2021-01-27 05:23:41 | Boone, Illinois, US |
1096303 | 1096303 | 2021-01-20 | US | New York | Chautauqua | 36013 | 5660 | 64 | 0 | 5596 | 42.22769210000001 | -79.36691763 | 2021-01-21 05:22:01 | Chautauqua, New York, US |
2627430 | 2627430 | 2021-01-10 | US | Maryland | Allegany | 24001 | 5758 | 162 | 0 | 5596 | 39.62357628 | -78.69280486 | 2021-01-11 05:21:50 | Allegany, Maryland, US |
3780218 | 3780218 | 2020-12-27 | US | North Carolina | Harnett | 37085 | 5685 | 89 | 0 | 5596 | 35.36731853 | -78.87243571 | 2020-12-28 05:22:06 | Harnett, North Carolina, US |
2538152 | 2538152 | 2020-12-01 | US | Georgia | Carroll | 13045 | 5692 | 96 | 0 | 5596 | 33.58138199 | -85.07976677 | 2020-12-02 05:27:41 | Carroll, Georgia, US |
123092 | 123092 | 2020-11-18 | US | Alabama | Morgan | 1103 | 5640 | 44 | 0 | 5596 | 34.45500589 | -86.85475946 | 2020-11-19 05:25:23 | Morgan, Alabama, US |
2785951 | 2785951 | 2020-11-13 | US | Idaho | Twin Falls | 16083 | 5664 | 68 | 0 | 5596 | 42.35440512 | -114.6685381 | 2020-11-14 05:25:37 | Twin Falls, Idaho, US |
212390 | 212390 | 2020-10-29 | US | New Jersey | Atlantic | 34001 | 5863 | 267 | 0 | 5596 | 39.47538693 | -74.65848483 | 2020-10-30 04:24:49 | Atlantic, New Jersey, US |
1794508 | 1794508 | 2020-10-19 | Denmark | 35844 | 686 | 29562 | 5596 | 56.2639 | 9.5018 | 2020-10-20 04:24:22 | Denmark | |||
347371 | 347371 | 2020-09-14 | US | Texas | Hays | 48209 | 5537 | 60 | 0 | 5596 | 30.05669873 | -98.02944344 | 2020-09-15 03:22:50 | Hays, Texas, US |
3934499 | 3934499 | 2020-08-30 | US | Ohio | Montgomery | 39113 | 5728 | 132 | 0 | 5596 | 39.75394919 | -84.29050975 | 2020-08-31 04:28:27 | Montgomery, Ohio, US |
368217 | 368217 | 2020-08-08 | US | New Jersey | Burlington | 34005 | 6068 | 472 | 0 | 5596 | 39.87681124 | -74.66927768 | 2020-08-09 04:34:54 | Burlington, 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]);