johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where confirmed = 30700 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2772559 | 2772559 | 2022-09-26 | US | Wisconsin | Walworth | 55127 | 30700 | 294 | 0 | 42.66858202 | -88.54163073 | 2022-09-27 04:23:01 | Walworth, Wisconsin, US | |
2357645 | 2357645 | 2022-09-16 | US | New Jersey | Hunterdon | 34019 | 30700 | 285 | 0 | 40.56335249 | -74.91284156 | 2022-09-17 04:20:19 | Hunterdon, New Jersey, US | |
2855120 | 2855120 | 2022-08-22 | US | New York | Oswego | 36075 | 30700 | 201 | 0 | 43.42778894 | -76.14635194 | 2022-08-23 04:20:56 | Oswego, New York, US | |
2405092 | 2405092 | 2022-08-21 | US | New York | Oswego | 36075 | 30700 | 201 | 0 | 43.42778894 | -76.14635194 | 2022-08-22 04:20:38 | Oswego, New York, US | |
2597446 | 2597446 | 2022-07-25 | US | Virginia | Spotsylvania | 51177 | 30700 | 306 | 0 | 38.18574462 | -77.655399 | 2022-07-26 04:20:58 | Spotsylvania, Virginia, US | |
2892486 | 2892486 | 2022-04-21 | Mali | 30700 | 731 | 0 | 17.570692 | -3.996166000000001 | 2022-04-22 04:20:45 | Mali | ||||
2612360 | 2612360 | 2022-01-06 | US | North Carolina | Davidson | 37057 | 30700 | 345 | 0 | 35.79115496 | -80.21256572 | 2022-01-07 04:22:09 | Davidson, North Carolina, US | |
682567 | 682567 | 2021-10-24 | Russia | Mordovia Republic | 30700 | 672 | 0 | 54.4419829 | 44.466114399999995 | 2021-10-25 04:22:31 | Mordovia Republic, Russia | |||
1440654 | 1440654 | 2021-07-07 | Malta | 30700 | 420 | 30170 | 110 | 35.9375 | 14.3754 | 2021-07-08 04:21:26 | Malta | |||
3253941 | 3253941 | 2021-03-02 | Chile | OHiggins | 30700 | 769 | 28748 | 1183 | -34.5755 | -71.0022 | 2021-03-03 05:23:28 | OHiggins, Chile | ||
3307818 | 3307818 | 2020-11-02 | Ukraine | Lviv Oblast | 30700 | 891 | 12125 | 17684 | 49.8397 | 24.0297 | 2020-11-03 06:00:16 | Lviv Oblast, Ukraine |
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]);