johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where confirmed = 20472 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1880522 | 1880522 | 2022-08-28 | US | Wisconsin | Chippewa | 55017 | 20472 | 197 | 0 | 45.06939744 | -91.28068855 | 2022-08-29 04:21:06 | Chippewa, Wisconsin, US | |
2099649 | 2099649 | 2022-08-27 | US | Wisconsin | Chippewa | 55017 | 20472 | 197 | 0 | 45.06939744 | -91.28068855 | 2022-08-28 04:21:02 | Chippewa, Wisconsin, US | |
1535464 | 1535464 | 2022-08-26 | US | Wisconsin | Chippewa | 55017 | 20472 | 197 | 0 | 45.06939744 | -91.28068855 | 2022-08-27 04:20:57 | Chippewa, Wisconsin, US | |
3873762 | 3873762 | 2022-07-31 | US | New Mexico | Lea | 35025 | 20472 | 380 | 0 | 32.79215361 | -103.4123733 | 2022-08-01 04:21:03 | Lea, New Mexico, US | |
676516 | 676516 | 2022-07-30 | US | New Mexico | Lea | 35025 | 20472 | 380 | 0 | 32.79215361 | -103.4123733 | 2022-07-31 04:21:02 | Lea, New Mexico, US | |
1785715 | 1785715 | 2022-07-29 | US | New Mexico | Lea | 35025 | 20472 | 380 | 0 | 32.79215361 | -103.4123733 | 2022-07-30 04:20:42 | Lea, New Mexico, US | |
2982554 | 2982554 | 2022-06-13 | US | Virgin Islands | 78 | 20472 | 115 | 0 | 18.3358 | -64.8963 | 2022-06-14 04:20:52 | Virgin Islands, US | ||
1436423 | 1436423 | 2022-03-28 | Colombia | Putumayo | 20472 | 774 | 0 | 0.436 | -75.5277 | 2022-03-29 04:20:46 | Putumayo, Colombia | |||
876104 | 876104 | 2022-03-27 | Colombia | Putumayo | 20472 | 774 | 0 | 0.436 | -75.5277 | 2022-03-28 04:20:33 | Putumayo, Colombia | |||
2163387 | 2163387 | 2022-03-26 | Colombia | Putumayo | 20472 | 772 | 0 | 0.436 | -75.5277 | 2022-03-27 04:20:47 | Putumayo, Colombia | |||
1720323 | 1720323 | 2022-03-25 | Colombia | Putumayo | 20472 | 772 | 0 | 0.436 | -75.5277 | 2022-03-26 04:20:23 | Putumayo, Colombia | |||
1467940 | 1467940 | 2022-03-24 | Colombia | Putumayo | 20472 | 772 | 0 | 0.436 | -75.5277 | 2022-03-25 04:20:46 | Putumayo, Colombia | |||
1994930 | 1994930 | 2022-03-01 | US | New York | St. Lawrence | 36089 | 20472 | 176 | 0 | 44.4976179 | -75.06550039 | 2022-03-02 04:21:07 | St. Lawrence, New York, US | |
3168700 | 3168700 | 2021-08-23 | US | Texas | Ector | 48135 | 20472 | 398 | 0 | 31.86898877 | -102.54294279999999 | 2021-08-24 04:21:19 | Ector, Texas, US | |
2178627 | 2178627 | 2021-08-22 | US | Texas | Ector | 48135 | 20472 | 398 | 0 | 31.86898877 | -102.54294279999999 | 2021-08-23 04:21:27 | Ector, Texas, US | |
3558723 | 3558723 | 2021-08-21 | US | Texas | Ector | 48135 | 20472 | 397 | 0 | 31.86898877 | -102.54294279999999 | 2021-08-22 04:21:29 | Ector, Texas, US | |
2518130 | 2518130 | 2021-08-18 | India | Ladakh | 20472 | 207 | 0 | 34.1526 | 77.5771 | 2021-08-19 04:21:15 | Ladakh, India | |||
1120596 | 1120596 | 2021-08-06 | US | Tennessee | Wilson | 47189 | 20472 | 260 | 0 | 36.15496772 | -86.29775884 | 2021-08-07 04:21:30 | Wilson, Tennessee, US | |
3389028 | 3389028 | 2021-07-29 | Ukraine | Sevastopol* | 20472 | 840 | 17860 | 1772 | 44.6054 | 33.522 | 2021-07-30 04:21:34 | Sevastopol*, Ukraine | ||
2297803 | 2297803 | 2021-06-24 | US | North Carolina | Pitt | 37147 | 20472 | 96 | 0 | 35.59535426 | -77.37353178 | 2021-06-25 04:21:33 | Pitt, North Carolina, US | |
1708517 | 1708517 | 2021-06-02 | Russia | Karachay-Cherkess Republic | 20472 | 139 | 20122 | 211 | 43.7368326 | 41.7267991 | 2021-06-03 04:23:32 | Karachay-Cherkess Republic, Russia | ||
1082147 | 1082147 | 2021-05-14 | Russia | Mordovia Republic | 20472 | 257 | 18333 | 1882 | 54.4419829 | 44.4661144 | 2021-05-15 04:20:58 | Mordovia Republic, Russia | ||
282839 | 282839 | 2021-02-24 | US | Pennsylvania | Dauphin | 42043 | 20472 | 487 | 0 | 19985 | 40.41377078 | -76.77993242 | 2021-02-25 05:24:57 | Dauphin, Pennsylvania, US |
3601600 | 3601600 | 2021-02-17 | US | California | Placer | 6061 | 20472 | 230 | 0 | 20295 | 39.06167234 | -120.7240569 | 2021-02-18 05:22:58 | Placer, California, US |
3050360 | 3050360 | 2021-02-16 | Russia | Amur Oblast | 20472 | 153 | 18870 | 1449 | 52.8032368 | 128.437295 | 2021-02-17 05:23:10 | Amur Oblast, Russia |
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]);