johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 21060 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
422496 | 422496 | 2022-09-18 | US | Texas | Liberty | 48291 | 21060 | 409 | 0 | 30.15152688 | -94.81205615 | 2022-09-19 04:21:49 | Liberty, Texas, US | |
3376520 | 3376520 | 2022-09-17 | US | Texas | Liberty | 48291 | 21060 | 409 | 0 | 30.15152688 | -94.81205615 | 2022-09-18 04:22:50 | Liberty, Texas, US | |
2358628 | 2358628 | 2022-09-16 | US | Texas | Liberty | 48291 | 21060 | 409 | 0 | 30.15152688 | -94.81205615 | 2022-09-17 04:20:19 | Liberty, Texas, US | |
3064167 | 3064167 | 2022-01-29 | US | New Jersey | Cape May | 34009 | 21060 | 272 | 0 | 39.15008829 | -74.80170244 | 2022-01-30 04:21:26 | Cape May, New Jersey, US | |
1286529 | 1286529 | 2022-01-04 | US | Arkansas | Saline | 5125 | 21060 | 260 | 0 | 34.64916145 | -92.67583224 | 2022-01-05 04:21:59 | Saline, Arkansas, US | |
3958815 | 3958815 | 2021-06-26 | Suriname | 21060 | 499 | 16484 | 4077 | 3.9193 | -56.0278 | 2021-06-27 04:21:39 | Suriname | |||
1619314 | 1619314 | 2021-03-05 | US | Texas | Ellis | 48139 | 21060 | 284 | 0 | 21054 | 32.34894117 | -96.79371841 | 2021-03-06 04:23:41 | Ellis, Texas, US |
1860637 | 1860637 | 2021-02-25 | US | Oregon | Washington | 41067 | 21060 | 212 | 0 | 20848 | 45.55972701 | -123.0955257 | 2021-02-26 05:22:40 | Washington, Oregon, US |
3601250 | 3601250 | 2021-02-17 | Russia | Khakassia Republic | 21060 | 430 | 19684 | 946 | 53.72258845 | 91.44293627 | 2021-02-18 05:22:58 | Khakassia Republic, Russia | ||
1588117 | 1588117 | 2021-02-05 | India | Chandigarh | 21060 | 338 | 20535 | 187 | 30.733839 | 76.76827800000002 | 2021-02-06 05:23:55 | Chandigarh, India | ||
237109 | 237109 | 2021-01-18 | Congo (Kinshasa) | 21060 | 634 | 14810 | 5616 | -4.0383 | 21.7587 | 2021-01-19 05:22:15 | Congo (Kinshasa) | |||
3769798 | 3769798 | 2020-12-22 | Germany | Schleswig-Holstein | 21060 | 333 | 16057 | 5450 | 54.2194 | 9.6961 | 2020-12-23 05:22:03 | Schleswig-Holstein, 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]);