johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 35492 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
658259 | 658259 | 2022-05-13 | India | Nagaland | 35492 | 760 | 0 | 26.06702 | 94.470302 | 2022-05-14 04:20:48 | Nagaland, India | |||
2533342 | 2533342 | 2022-05-12 | India | Nagaland | 35492 | 760 | 0 | 26.06702 | 94.470302 | 2022-05-13 04:20:51 | Nagaland, India | |||
3444788 | 3444788 | 2022-05-11 | India | Nagaland | 35492 | 760 | 0 | 26.06702 | 94.470302 | 2022-05-12 04:20:54 | Nagaland, India | |||
3535405 | 3535405 | 2022-05-10 | India | Nagaland | 35492 | 760 | 0 | 26.06702 | 94.470302 | 2022-05-11 04:20:48 | Nagaland, India | |||
2253785 | 2253785 | 2022-04-19 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-20 04:20:45 | Randolph, North Carolina, US | |
1848335 | 1848335 | 2022-04-18 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-19 04:21:00 | Randolph, North Carolina, US | |
3419279 | 3419279 | 2022-04-17 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-18 04:21:12 | Randolph, North Carolina, US | |
306228 | 306228 | 2022-04-16 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-17 04:20:59 | Randolph, North Carolina, US | |
2672173 | 2672173 | 2022-04-15 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-16 04:20:48 | Randolph, North Carolina, US | |
1225958 | 1225958 | 2022-04-14 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-15 04:20:57 | Randolph, North Carolina, US | |
2445116 | 2445116 | 2022-04-13 | US | North Carolina | Randolph | 37151 | 35492 | 403 | 0 | 35.71015088 | -79.80570339 | 2022-04-13 23:21:06 | Randolph, North Carolina, US | |
1695451 | 1695451 | 2022-01-10 | US | Texas | Jefferson | 48245 | 35492 | 741 | 0 | 29.8832777 | -94.16434171 | 2022-01-11 04:22:01 | Jefferson, Texas, US | |
2648404 | 2648404 | 2021-04-08 | US | Pennsylvania | Chester | 42029 | 35492 | 765 | 0 | 39.97291773 | -75.74768357 | 2021-04-09 04:21:13 | Chester, Pennsylvania, US | |
1799358 | 1799358 | 2021-03-23 | US | Florida | Pasco | 12101 | 35492 | 680 | 0 | 28.30810945 | -82.40227529 | 2021-03-24 05:25:40 | Pasco, Florida, US | |
1056802 | 1056802 | 2020-10-23 | US | Tennessee | Shelby | 47157 | 35492 | 562 | 0 | 35002 | 35.1864775 | -89.89692423 | 2020-10-24 04:24:46 | Shelby, Tennessee, 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]);