johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 21268 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076676 | 1076676 | 2022-12-28 | US | Puerto Rico | Mayaguez | 72097 | 21268 | 0 | 0 | 18.2013 | -67.1452 | 2022-12-29 04:21:01 | Mayaguez, Puerto Rico, US | |
1073958 | 1073958 | 2022-12-28 | Liechtenstein | 21268 | 88 | 0 | 47.14 | 9.55 | 2022-12-29 04:21:01 | Liechtenstein | ||||
133537 | 133537 | 2022-10-04 | US | Puerto Rico | Toa Baja | 72137 | 21268 | 0 | 0 | 18.431446 | -66.213553 | 2022-10-05 04:23:06 | Toa Baja, Puerto Rico, US | |
695457 | 695457 | 2022-03-17 | US | Indiana | Bartholomew | 18005 | 21268 | 241 | 0 | 39.20744865 | -85.89558181 | 2022-03-18 04:20:55 | Bartholomew, Indiana, US | |
72892 | 72892 | 2022-02-07 | US | Mississippi | Forrest | 28035 | 21268 | 283 | 0 | 31.18961454 | -89.25832496 | 2022-02-08 04:21:15 | Forrest, Mississippi, US | |
716048 | 716048 | 2021-11-12 | US | Maryland | Harford | 24025 | 21268 | 361 | 0 | 39.55010644 | -76.30775940000002 | 2021-11-13 04:21:38 | Harford, Maryland, US | |
1413306 | 1413306 | 2021-05-24 | Russia | Tatarstan Republic | 21268 | 490 | 18181 | 2597 | 55.7648572 | 52.43104273 | 2021-05-25 04:21:08 | Tatarstan Republic, Russia | ||
3710050 | 3710050 | 2021-04-03 | Germany | Bremen | 21268 | 406 | 19380 | 1907 | 53.0793 | 8.8017 | 2021-04-04 04:20:49 | Bremen, Germany | ||
352364 | 352364 | 2021-03-11 | Maldives | 21268 | 64 | 18695 | 2509 | 3.2028 | 73.2207 | 2021-03-12 05:26:50 | Maldives | |||
3541630 | 3541630 | 2021-02-12 | US | New Jersey | Somerset | 34035 | 21268 | 765 | 0 | 20503 | 40.56465737 | -74.61683016 | 2021-02-13 05:22:12 | Somerset, New Jersey, US |
3516415 | 3516415 | 2021-01-15 | US | Illinois | McHenry | 17111 | 21268 | 226 | 0 | 21042 | 42.32451172 | -88.45248227 | 2021-01-16 05:22:40 | McHenry, Illinois, US |
2224192 | 2224192 | 2020-12-26 | US | Florida | Escambia | 12033 | 21268 | 356 | 0 | 20912 | 30.67652764 | -87.37284571 | 2020-12-27 05:22:55 | Escambia, Florida, US |
846286 | 846286 | 2020-12-12 | US | Florida | Osceola | 12097 | 21268 | 268 | 0 | 21000 | 28.06312234 | -81.14882926 | 2020-12-13 05:27:20 | Osceola, Florida, US |
2936934 | 2936934 | 2020-11-28 | US | Minnesota | Dakota | 27037 | 21268 | 190 | 0 | 21078 | 44.67172617 | -93.06299363 | 2020-11-29 05:25:55 | Dakota, Minnesota, 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]);