johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 25733 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453662 | 453662 | 2022-12-21 | US | New York | St. Lawrence | 36089 | 25733 | 216 | 0 | 44.4976179 | -75.06550039 | 2022-12-22 04:20:56 | St. Lawrence, New York, US | |
3265876 | 3265876 | 2022-05-04 | US | Alabama | Houston | 1069 | 25733 | 506 | 0 | 31.15197924 | -85.29939599 | 2022-05-05 04:20:55 | Houston, Alabama, US | |
2321684 | 2321684 | 2022-03-16 | US | North Carolina | Orange | 37135 | 25733 | 124 | 0 | 36.06092947 | -79.12167935 | 2022-03-17 04:20:56 | Orange, North Carolina, US | |
263884 | 263884 | 2022-03-15 | US | North Carolina | Orange | 37135 | 25733 | 124 | 0 | 36.06092947 | -79.12167935 | 2022-03-16 04:20:50 | Orange, North Carolina, US | |
3009 | 3009 | 2021-12-02 | US | Pennsylvania | Lackawanna | 42069 | 25733 | 549 | 0 | 41.43564672 | -75.60379201 | 2021-12-03 04:23:05 | Lackawanna, Pennsylvania, US | |
289474 | 289474 | 2021-10-31 | US | Kentucky | Warren | 21227 | 25733 | 254 | 0 | 36.99903045 | -86.42672751 | 2021-11-01 04:22:01 | Warren, Kentucky, US | |
1724957 | 1724957 | 2021-09-25 | US | Arizona | Yavapai | 4025 | 25733 | 634 | 0 | 34.59933926 | -112.5538588 | 2021-09-26 04:21:29 | Yavapai, Arizona, US | |
1167650 | 1167650 | 2021-07-04 | US | Ohio | Lorain | 39093 | 25733 | 509 | 0 | 41.29553751 | -82.15083537 | 2021-07-05 04:21:28 | Lorain, Ohio, US | |
1498084 | 1498084 | 2021-07-03 | US | Ohio | Lorain | 39093 | 25733 | 509 | 0 | 41.29553751 | -82.15083537 | 2021-07-04 04:21:38 | Lorain, Ohio, US | |
2074399 | 2074399 | 2021-07-02 | US | Ohio | Lorain | 39093 | 25733 | 509 | 0 | 41.29553751 | -82.15083537 | 2021-07-03 04:21:37 | Lorain, Ohio, US | |
1775024 | 1775024 | 2021-05-23 | Malaysia | Pulau Pinang | 25733 | 58 | 23093 | 2582 | 5.4141 | 100.3288 | 2021-05-24 04:20:53 | Pulau Pinang, Malaysia | ||
2567896 | 2567896 | 2021-01-25 | Russia | Orel Oblast | 25733 | 325 | 22693 | 2715 | 52.96854329999999 | 36.0692477 | 2021-01-26 05:22:02 | Orel Oblast, Russia | ||
3859991 | 3859991 | 2020-12-04 | Peru | Junin | 25733 | 2330 | 0 | 23403 | -11.541783 | -74.876968 | 2020-12-05 05:27:36 | Junin, Peru | ||
75249 | 75249 | 2020-12-03 | Peru | Junin | 25733 | 2328 | 0 | 23405 | -11.541783 | -74.876968 | 2020-12-04 05:27:27 | Junin, Peru | ||
3480077 | 3480077 | 2020-10-26 | Canada | Alberta | 25733 | 307 | 20949 | 4477 | 53.9333 | -116.5765 | 2020-10-27 04:24:45 | Alberta, Canada | ||
2685087 | 2685087 | 2020-07-06 | India | Telangana | 25733 | 306 | 14781 | 10646 | 18.1124 | 79.0193 | 2020-07-07 04:34:00 | Telangana, India | ||
2038660 | 2038660 | 2020-06-27 | US | Pennsylvania | Philadelphia | 42101 | 25733 | 1591 | 0 | 24142 | 40.00338507 | -75.1379271 | 2020-06-28 04:34:04 | Philadelphia, Pennsylvania, 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]);