johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where confirmed = 4610 and country_or_region = "Nauru" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118434 | 118434 | 2022-09-06 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-07 04:20:59 | Nauru | |||
256996 | 256996 | 2022-09-08 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-09 04:21:11 | Nauru | |||
966594 | 966594 | 2022-09-09 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-10 04:21:10 | Nauru | |||
1254440 | 1254440 | 2022-08-23 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-24 04:20:46 | Nauru | |||
1397360 | 1397360 | 2022-09-02 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-03 04:21:04 | Nauru | |||
1535611 | 1535611 | 2022-08-26 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-27 04:20:57 | Nauru | |||
1684185 | 1684185 | 2022-08-29 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-30 04:21:03 | Nauru | |||
1880669 | 1880669 | 2022-08-28 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-29 04:21:06 | Nauru | |||
2099796 | 2099796 | 2022-08-27 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-28 04:21:02 | Nauru | |||
2327031 | 2327031 | 2022-08-24 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-25 04:21:13 | Nauru | |||
2347109 | 2347109 | 2022-08-31 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-01 04:21:03 | Nauru | |||
2367180 | 2367180 | 2022-08-19 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-20 04:21:01 | Nauru | |||
2398484 | 2398484 | 2022-09-12 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-13 04:20:57 | Nauru | |||
2406516 | 2406516 | 2022-08-21 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-22 04:20:38 | Nauru | |||
2637406 | 2637406 | 2022-09-05 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-06 04:21:02 | Nauru | |||
2716655 | 2716655 | 2022-09-03 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-04 04:21:22 | Nauru | |||
2832498 | 2832498 | 2022-08-25 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-26 04:21:02 | Nauru | |||
2856544 | 2856544 | 2022-08-22 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-23 04:20:56 | Nauru | |||
2990970 | 2990970 | 2022-09-04 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-05 04:21:01 | Nauru | |||
3551189 | 3551189 | 2022-09-01 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-02 04:21:07 | Nauru | |||
3748794 | 3748794 | 2022-09-07 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-08 04:21:02 | Nauru | |||
3769562 | 3769562 | 2022-09-11 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-12 04:20:58 | Nauru | |||
3777589 | 3777589 | 2022-08-30 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-31 04:20:57 | Nauru | |||
3801594 | 3801594 | 2022-08-20 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-21 04:20:44 | Nauru | |||
3828137 | 3828137 | 2022-09-10 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-11 04:20:50 | Nauru |
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]);