johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where confirmed = 17417 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 22
- Italy 1
- Liechtenstein 1
- United Arab Emirates 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3747901 | 3747901 | 2022-09-07 | US | Puerto Rico | Vega Baja | 72145 | 17417 | 0 | 0 | 18.428262 | -66.397924 | 2022-09-08 04:21:02 | Vega Baja, Puerto Rico, US | |
633269 | 633269 | 2022-07-12 | US | Virginia | James City | 51095 | 17417 | 127 | 0 | 37.31156958 | -76.76950618 | 2022-07-13 04:20:58 | James City, Virginia, US | |
632224 | 632224 | 2022-07-12 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-13 04:20:58 | Duplin, North Carolina, US | |
1213868 | 1213868 | 2022-07-11 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-12 04:20:51 | Duplin, North Carolina, US | |
2791350 | 2791350 | 2022-07-10 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-11 04:20:46 | Duplin, North Carolina, US | |
144303 | 144303 | 2022-07-09 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-10 04:20:54 | Duplin, North Carolina, US | |
1419403 | 1419403 | 2022-07-08 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-09 04:20:59 | Duplin, North Carolina, US | |
2743328 | 2743328 | 2022-07-07 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-08 04:20:56 | Duplin, North Carolina, US | |
1202123 | 1202123 | 2022-07-06 | US | North Carolina | Duplin | 37061 | 17417 | 248 | 0 | 34.93449805 | -77.93140529 | 2022-07-07 04:20:55 | Duplin, North Carolina, US | |
2999354 | 2999354 | 2022-05-24 | Liechtenstein | 17417 | 84 | 0 | 47.14 | 9.55 | 2022-05-25 04:20:56 | Liechtenstein | ||||
2803837 | 2803837 | 2022-04-06 | US | Texas | Coryell | 48099 | 17417 | 210 | 0 | 31.39078397 | -97.79936155 | 2022-04-07 04:20:53 | Coryell, Texas, US | |
879205 | 879205 | 2022-03-27 | US | Tennessee | Gibson | 47053 | 17417 | 253 | 0 | 35.99438059 | -88.93358327 | 2022-03-28 04:20:33 | Gibson, Tennessee, US | |
2166488 | 2166488 | 2022-03-26 | US | Tennessee | Gibson | 47053 | 17417 | 253 | 0 | 35.99438059 | -88.93358327 | 2022-03-27 04:20:47 | Gibson, Tennessee, US | |
1723424 | 1723424 | 2022-03-25 | US | Tennessee | Gibson | 47053 | 17417 | 253 | 0 | 35.99438059 | -88.93358327 | 2022-03-26 04:20:23 | Gibson, Tennessee, US | |
2448600 | 2448600 | 2022-02-22 | US | Mississippi | Lowndes | 28087 | 17417 | 225 | 0 | 33.47386518 | -88.44191529999998 | 2022-02-23 04:21:09 | Lowndes, Mississippi, US | |
557192 | 557192 | 2022-01-16 | US | North Dakota | Grand Forks | 38035 | 17417 | 106 | 0 | 47.92093639 | -97.45450447 | 2022-01-17 04:21:08 | Grand Forks, North Dakota, US | |
2763718 | 2763718 | 2021-05-03 | US | South Carolina | Berkeley | 45015 | 17417 | 193 | 0 | 33.20222596 | -79.94654523 | 2021-05-04 04:20:34 | Berkeley, South Carolina, US | |
891691 | 891691 | 2021-04-26 | US | Wisconsin | Rock | 55105 | 17417 | 187 | 0 | 42.67151616 | -89.07147900000002 | 2021-04-27 04:20:52 | Rock, Wisconsin, US | |
3131736 | 3131736 | 2021-04-18 | US | New York | Broome | 36007 | 17417 | 348 | 0 | 42.15903158 | -75.81326086 | 2021-04-19 04:20:57 | Broome, New York, US | |
390022 | 390022 | 2021-04-04 | US | Mississippi | Harrison | 28047 | 17417 | 299 | 0 | 30.51359752 | -89.12467576 | 2021-04-05 04:20:35 | Harrison, Mississippi, US | |
1747539 | 1747539 | 2021-03-20 | US | Tennessee | Wilson | 47189 | 17417 | 214 | 0 | 36.15496772 | -86.29775884 | 2021-03-21 05:25:44 | Wilson, Tennessee, US | |
1818778 | 1818778 | 2020-12-08 | Italy | P.A. Trento | 17417 | 719 | 14241 | 2457 | 46.06893511 | 11.12123097 | 2020-12-09 05:28:01 | P.A. Trento, Italy | ||
2347964 | 2347964 | 2020-12-07 | US | California | Imperial | 6025 | 17417 | 364 | 0 | 17064 | 33.0393082 | -115.3669042 | 2020-12-08 05:27:42 | Imperial, California, US |
875038 | 875038 | 2020-05-24 | US | Massachusetts | Suffolk | 25025 | 17417 | 838 | 0 | 16579 | 42.3279514 | -71.07850442 | 2020-05-25 02:32:44 | Suffolk, Massachusetts, US |
2899324 | 2899324 | 2020-05-09 | United Arab Emirates | 17417 | 185 | 4295 | 12937 | 23.424076 | 53.847818 | 2020-05-10 02:32:30 | United Arab Emirates |
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]);