johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 12404 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330325 | 1330325 | 2021-07-24 | Mexico | Campeche | 13830 | 1426 | 0 | 12404 | 19.8301 | -90.5349 | 2021-07-25 04:22:12 | Campeche, Mexico | ||
3740987 | 3740987 | 2021-07-12 | Georgia | 377811 | 5468 | 359939 | 12404 | 42.3154 | 43.3569 | 2021-07-13 04:21:18 | Georgia | |||
3668618 | 3668618 | 2021-03-06 | US | Illinois | Kankakee | 17091 | 12594 | 190 | 0 | 12404 | 41.13746989 | -87.86205334 | 2021-03-07 05:21:54 | Kankakee, Illinois, US |
3052525 | 3052525 | 2021-02-16 | US | North Carolina | Randolph | 37151 | 12598 | 194 | 0 | 12404 | 35.71015088 | -79.80570339 | 2021-02-17 05:23:10 | Randolph, North Carolina, US |
1678929 | 1678929 | 2021-02-01 | US | Ohio | Greene | 39057 | 12622 | 218 | 0 | 12404 | 39.69116283 | -83.89032084 | 2021-02-02 05:22:49 | Greene, Ohio, US |
2865960 | 2865960 | 2021-01-06 | US | Iowa | Woodbury | 19193 | 12575 | 171 | 0 | 12404 | 42.38979414 | -96.0459439 | 2021-01-07 05:22:03 | Woodbury, Iowa, US |
125863 | 125863 | 2020-11-18 | US | Texas | McLennan | 48309 | 6357 | 168 | 0 | 12404 | 31.55255453 | -97.20217694 | 2020-11-19 05:25:23 | McLennan, Texas, US |
2816369 | 2816369 | 2020-09-25 | Ukraine | Lviv Oblast | 19465 | 543 | 6518 | 12404 | 49.8397 | 24.0297 | 2020-09-26 04:23:00 | Lviv Oblast, Ukraine | ||
1273880 | 1273880 | 2020-06-11 | Portugal | 35910 | 1504 | 22002 | 12404 | 39.3999 | -8.2245 | 2020-06-12 05:09:52 | Portugal |
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]);