johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 14029 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3327006 | 3327006 | 2022-12-16 | US | Puerto Rico | Gurabo | 72063 | 14029 | 0 | 0 | 18.266461 | -65.979705 | 2022-12-17 04:21:04 | Gurabo, Puerto Rico, US | |
2830945 | 2830945 | 2022-08-25 | US | Nebraska | Unassigned | 90031 | 14029 | 960 | 0 | 42.8997274 | 0.0 | 2022-08-26 04:21:02 | Unassigned, Nebraska, US | |
1088268 | 1088268 | 2022-08-09 | US | New Mexico | Curry | 35009 | 14029 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-10 04:20:57 | Curry, New Mexico, US | |
1073442 | 1073442 | 2022-08-07 | US | Wisconsin | Grant | 55043 | 14029 | 151 | 0 | 42.8671731 | -90.7063218 | 2022-08-08 04:21:08 | Grant, Wisconsin, US | |
1944030 | 1944030 | 2022-08-06 | US | Wisconsin | Grant | 55043 | 14029 | 151 | 0 | 42.8671731 | -90.7063218 | 2022-08-07 04:20:54 | Grant, Wisconsin, US | |
883829 | 883829 | 2022-08-05 | US | Wisconsin | Grant | 55043 | 14029 | 151 | 0 | 42.8671731 | -90.7063218 | 2022-08-06 04:20:56 | Grant, Wisconsin, US | |
3408571 | 3408571 | 2022-07-17 | US | Texas | Harrison | 48203 | 14029 | 227 | 0 | 32.54935988 | -94.36934071 | 2022-07-18 04:20:59 | Harrison, Texas, US | |
1225299 | 1225299 | 2022-04-14 | US | Minnesota | Benton | 27009 | 14029 | 174 | 0 | 45.69804958 | -93.99514135 | 2022-04-15 04:20:57 | Benton, Minnesota, US | |
160757 | 160757 | 2022-03-29 | US | Puerto Rico | Guaynabo | 72061 | 14029 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2022-03-30 04:20:45 | Guaynabo, Puerto Rico, US | |
3049216 | 3049216 | 2022-02-26 | US | Texas | Caldwell | 48055 | 14029 | 172 | 0 | 29.83668859 | -97.61814775 | 2022-02-27 04:21:04 | Caldwell, Texas, US | |
1513731 | 1513731 | 2022-02-24 | US | North Carolina | Granville | 37077 | 14029 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-02-25 04:21:11 | Granville, North Carolina, US | |
3228677 | 3228677 | 2022-01-19 | US | New York | Cayuga | 36011 | 14029 | 127 | 0 | 42.91261714 | -76.55731592 | 2022-01-20 04:21:07 | Cayuga, New York, US | |
1286916 | 1286916 | 2022-01-04 | US | Hawaii | Hawaii | 15001 | 14029 | 153 | 0 | 19.60121157 | -155.5210167 | 2022-01-05 04:21:59 | Hawaii, Hawaii, US | |
733869 | 733869 | 2021-12-27 | US | Virginia | Frederick | 51069 | 14029 | 181 | 0 | 39.20172582 | -78.25974949 | 2021-12-28 04:21:47 | Frederick, Virginia, US | |
3828786 | 3828786 | 2021-12-21 | Sweden | Jamtland Harjedalen | 14029 | 129 | 0 | 63.1712 | 14.9592 | 2021-12-22 04:21:54 | Jamtland Harjedalen, Sweden | |||
45867 | 45867 | 2021-11-02 | US | New Hampshire | Merrimack | 33013 | 14029 | 132 | 0 | 43.29662971 | -71.6811573 | 2021-11-03 06:22:09 | Merrimack, New Hampshire, US | |
1263794 | 1263794 | 2021-09-09 | US | Illinois | LaSalle | 17099 | 14029 | 267 | 0 | 41.34426129999999 | -88.88633881 | 2021-09-10 04:21:20 | LaSalle, Illinois, US | |
1932771 | 1932771 | 2021-07-05 | Tajikistan | 14029 | 96 | 13382 | 551 | 38.861 | 71.2761 | 2021-07-06 04:21:32 | Tajikistan | |||
3113554 | 3113554 | 2021-05-06 | Mali | 14029 | 493 | 8878 | 4658 | 17.570692 | -3.996166000000001 | 2021-05-07 04:20:40 | Mali | |||
2453453 | 2453453 | 2021-05-02 | US | Pennsylvania | Monroe | 42089 | 14029 | 300 | 0 | 41.05934058 | -75.34031025 | 2021-05-03 04:20:39 | Monroe, Pennsylvania, US | |
956449 | 956449 | 2021-04-25 | US | Maryland | Washington | 24043 | 14029 | 272 | 0 | 39.60835778 | -77.82002295 | 2021-04-26 04:21:04 | Washington, Maryland, US | |
1880944 | 1880944 | 2021-03-26 | India | Meghalaya | 14029 | 150 | 13853 | 26 | 25.536934 | 91.278882 | 2021-03-27 05:25:04 | Meghalaya, India | ||
1339022 | 1339022 | 2021-02-15 | US | Georgia | Bibb | 13021 | 14029 | 355 | 0 | 13674 | 32.80904227 | -83.70489165 | 2021-02-16 05:24:38 | Bibb, Georgia, US |
3540928 | 3540928 | 2021-02-12 | US | Kentucky | Warren | 21227 | 14029 | 127 | 0 | 13902 | 36.99903045 | -86.42672751 | 2021-02-13 05:22:12 | Warren, Kentucky, US |
666150 | 666150 | 2020-09-16 | Croatia | 14029 | 236 | 11690 | 2103 | 45.1 | 15.2 | 2020-09-17 04:22:00 | Croatia | |||
3484218 | 3484218 | 2020-08-20 | Germany | Hessen | 14029 | 528 | 12064 | 1437 | 50.6521 | 9.1624 | 2020-08-21 04:27:41 | Hessen, Germany |
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]);