johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where confirmed = 21792 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1070399 | 1070399 | 2022-08-07 | US | Arkansas | Lonoke | 5085 | 21792 | 251 | 0 | 34.75392199 | -91.88742357 | 2022-08-08 04:21:08 | Lonoke, Arkansas, US | |
1487656 | 1487656 | 2022-07-26 | Malaysia | W.P. Labuan | 21792 | 155 | 0 | 5.2831 | 115.2308 | 2022-07-27 04:21:04 | W.P. Labuan, Malaysia | |||
749366 | 749366 | 2022-04-23 | US | Texas | Bastrop | 48021 | 21792 | 238 | 0 | 30.10370699 | -97.31206354 | 2022-04-24 04:20:56 | Bastrop, Texas, US | |
2480140 | 2480140 | 2022-03-30 | US | New Jersey | Cape May | 34009 | 21792 | 297 | 0 | 39.15008829 | -74.80170244 | 2022-03-31 04:20:56 | Cape May, New Jersey, US | |
923143 | 923143 | 2022-03-08 | US | Washington | Skagit | 53057 | 21792 | 189 | 0 | 48.48171488 | -121.766131 | 2022-03-09 04:20:59 | Skagit, Washington, US | |
1551430 | 1551430 | 2022-03-07 | US | Washington | Skagit | 53057 | 21792 | 189 | 0 | 48.48171488 | -121.766131 | 2022-03-08 04:20:54 | Skagit, Washington, US | |
1287261 | 1287261 | 2022-01-04 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2022-01-05 04:21:59 | Woodbury, Iowa, US | |
1701605 | 1701605 | 2022-01-03 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2022-01-04 04:22:17 | Woodbury, Iowa, US | |
3520688 | 3520688 | 2022-01-02 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2022-01-03 02:22:25 | Woodbury, Iowa, US | |
2168818 | 2168818 | 2022-01-01 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2022-01-02 04:20:52 | Woodbury, Iowa, US | |
2778249 | 2778249 | 2021-12-31 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2022-01-01 04:22:14 | Woodbury, Iowa, US | |
3999906 | 3999906 | 2021-12-30 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2021-12-31 04:21:50 | Woodbury, Iowa, US | |
1669713 | 1669713 | 2021-12-29 | US | Iowa | Woodbury | 19193 | 21792 | 282 | 0 | 42.38979414 | -96.0459439 | 2021-12-30 04:21:25 | Woodbury, Iowa, US | |
3655531 | 3655531 | 2021-12-10 | India | Ladakh | 21792 | 215 | 0 | 34.1526 | 77.5771 | 2021-12-11 04:22:45 | Ladakh, India | |||
2959368 | 2959368 | 2021-10-08 | Japan | Hiroshima | 21792 | 199 | 0 | 34.605309000000005 | 132.788719 | 2021-10-09 04:21:34 | Hiroshima, Japan | |||
2939896 | 2939896 | 2021-05-16 | US | California | San Luis Obispo | 6079 | 21792 | 256 | 0 | 35.38822029 | -120.4039028 | 2021-05-17 04:20:34 | San Luis Obispo, California, US | |
2573166 | 2573166 | 2021-04-13 | US | Louisiana | Calcasieu | 22019 | 21792 | 411 | 0 | 30.22931235 | -93.35400434 | 2021-04-14 04:20:41 | Calcasieu, Louisiana, US | |
1800545 | 1800545 | 2021-03-23 | US | Missouri | Jefferson | 29099 | 21792 | 232 | 0 | 38.25926778 | -90.53870896 | 2021-03-24 05:25:40 | Jefferson, Missouri, US | |
2359661 | 2359661 | 2021-03-08 | Russia | Chuvashia Republic | 21792 | 1078 | 19937 | 777 | 55.4259922 | 47.0849429 | 2021-03-09 05:28:19 | Chuvashia Republic, Russia | ||
2211906 | 2211906 | 2021-01-30 | Russia | Ryazan Oblast | 21792 | 227 | 19877 | 1688 | 54.42267320000001 | 40.57052460000001 | 2021-01-31 05:22:42 | Ryazan Oblast, Russia | ||
2193759 | 2193759 | 2020-10-21 | US | New Jersey | Middlesex | 34023 | 21792 | 1441 | 0 | 20351 | 40.43629879 | -74.41426991 | 2020-10-22 04:24:27 | Middlesex, 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]);