johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 18082 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1643756 | 1643756 | 2022-11-20 | US | Virginia | Rockingham | 51165 | 18082 | 257 | 0 | 38.51006137 | -78.87260325 | 2022-11-21 04:21:05 | Rockingham, Virginia, US | |
2067313 | 2067313 | 2022-11-19 | US | Virginia | Rockingham | 51165 | 18082 | 257 | 0 | 38.51006137 | -78.87260325 | 2022-11-20 04:21:08 | Rockingham, Virginia, US | |
1758707 | 1758707 | 2022-11-18 | US | Virginia | Rockingham | 51165 | 18082 | 257 | 0 | 38.51006137 | -78.87260325 | 2022-11-19 04:21:14 | Rockingham, Virginia, US | |
2326285 | 2326285 | 2022-08-24 | US | Tennessee | Dickson | 47043 | 18082 | 253 | 0 | 36.14669837 | -87.35891709 | 2022-08-25 04:21:13 | Dickson, Tennessee, US | |
2326112 | 2326112 | 2022-08-24 | US | Puerto Rico | Mayaguez | 72097 | 18082 | 0 | 0 | 18.2013 | -67.1452 | 2022-08-25 04:21:13 | Mayaguez, Puerto Rico, US | |
1100314 | 1100314 | 2022-08-03 | US | New Mexico | Eddy | 35015 | 18082 | 305 | 0 | 32.47167456 | -104.3053527 | 2022-08-04 04:20:58 | Eddy, New Mexico, US | |
2800980 | 2800980 | 2022-04-06 | Russia | Jewish Autonomous Okrug | 18082 | 527 | 0 | 48.57527615 | 132.66307460000002 | 2022-04-07 04:20:53 | Jewish Autonomous Okrug, Russia | |||
3877851 | 3877851 | 2022-02-19 | US | New York | Sullivan | 36105 | 18082 | 124 | 0 | 41.71579493 | -74.76394559 | 2022-02-20 04:21:00 | Sullivan, New York, US | |
2475621 | 2475621 | 2022-02-03 | US | Michigan | Midland | 26111 | 18082 | 205 | 0 | 43.64330771 | -84.38804374 | 2022-02-04 04:21:10 | Midland, Michigan, US | |
2474504 | 2474504 | 2022-02-03 | US | California | Humboldt | 6023 | 18082 | 131 | 0 | 40.69923009 | -123.876044 | 2022-02-04 04:21:10 | Humboldt, California, US | |
461046 | 461046 | 2022-02-02 | US | Michigan | Midland | 26111 | 18082 | 205 | 0 | 43.64330771 | -84.38804374 | 2022-02-03 04:21:21 | Midland, Michigan, US | |
1961514 | 1961514 | 2022-01-20 | US | Idaho | Twin Falls | 16083 | 18082 | 254 | 0 | 42.35440512 | -114.6685381 | 2022-01-21 04:21:09 | Twin Falls, Idaho, US | |
1435865 | 1435865 | 2021-12-28 | US | Virginia | Alexandria | 51510 | 18082 | 161 | 0 | 38.814003 | -77.08183073 | 2021-12-29 03:21:43 | Alexandria, Virginia, US | |
798550 | 798550 | 2021-12-22 | Netherlands | Curacao | 18082 | 186 | 0 | 12.1696 | -68.99 | 2021-12-23 04:21:21 | Curacao, Netherlands | |||
2773408 | 2773408 | 2021-09-30 | US | Alaska | Matanuska-Susitna | 2170 | 18082 | 84 | 0 | 62.31305045 | -149.5741743 | 2021-10-01 04:21:35 | Matanuska-Susitna, Alaska, US | |
1443960 | 1443960 | 2021-07-07 | US | Virginia | Norfolk | 51710 | 18082 | 273 | 0 | 36.89934014 | -76.26420872 | 2021-07-08 04:21:26 | Norfolk, Virginia, US | |
3091291 | 3091291 | 2021-05-30 | US | Missouri | Boone | 29019 | 18082 | 93 | 0 | 38.99186229 | -92.30723575 | 2021-05-31 03:08:59 | Boone, Missouri, US | |
1955322 | 1955322 | 2021-05-21 | US | South Carolina | Dorchester | 45035 | 18082 | 221 | 0 | 33.0794369 | -80.40502652 | 2021-05-22 04:20:45 | Dorchester, South Carolina, US | |
955590 | 955590 | 2021-04-25 | US | Florida | Santa Rosa | 12113 | 18082 | 284 | 0 | 30.693414500000006 | -87.02458128 | 2021-04-26 04:21:04 | Santa Rosa, Florida, US | |
173725 | 173725 | 2021-04-16 | Malaysia | Pulau Pinang | 18082 | 22 | 17089 | 971 | 5.4141 | 100.3288 | 2021-04-17 04:20:40 | Pulau Pinang, Malaysia | ||
2574681 | 2574681 | 2021-04-13 | US | Tennessee | Wilson | 47189 | 18082 | 223 | 0 | 36.15496772 | -86.29775884 | 2021-04-14 04:20:41 | Wilson, Tennessee, US | |
55021 | 55021 | 2021-03-07 | Russia | Kurgan Oblast | 18082 | 322 | 16214 | 1546 | 55.7655302 | 64.5632681 | 2021-03-08 05:24:48 | Kurgan Oblast, Russia | ||
3254396 | 3254396 | 2021-03-02 | Russia | Tatarstan Republic | 18082 | 338 | 14692 | 3052 | 55.7648572 | 52.43104273 | 2021-03-03 05:23:28 | Tatarstan Republic, Russia | ||
3050244 | 3050244 | 2021-02-16 | Maldives | 18082 | 58 | 15633 | 2391 | 3.2028 | 73.2207 | 2021-02-17 05:23:10 | Maldives | |||
3778044 | 3778044 | 2020-12-27 | Pakistan | Balochistan | 18082 | 182 | 17619 | 281 | 28.328492 | 65.898403 | 2020-12-28 05:22:06 | Balochistan, Pakistan | ||
2306823 | 2306823 | 2020-06-28 | Honduras | 18082 | 479 | 1875 | 15728 | 15.2 | -86.2419 | 2020-06-29 04:33:44 | Honduras |
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]);