johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 576, country_or_region = "US" and province_or_state = "Indiana" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1585273 | 1585273 | 2020-11-30 | US | Indiana | Newton | 18111 | 594 | 18 | 0 | 576 | 40.95610449 | -87.39635768 | 2020-12-01 05:26:18 | Newton, Indiana, US |
2702587 | 2702587 | 2020-11-20 | US | Indiana | Franklin | 18047 | 601 | 25 | 0 | 576 | 39.4142482 | -85.06062647 | 2020-11-21 05:25:51 | Franklin, Indiana, US |
3170779 | 3170779 | 2020-11-16 | US | Indiana | Washington | 18175 | 581 | 5 | 0 | 576 | 38.60219804 | -86.1049363 | 2020-11-17 05:25:54 | Washington, Indiana, US |
273280 | 273280 | 2020-11-10 | US | Indiana | Spencer | 18147 | 583 | 7 | 0 | 576 | 38.01519732 | -87.0079644 | 2020-11-11 05:25:30 | Spencer, Indiana, US |
2300568 | 2300568 | 2020-08-22 | US | Indiana | Shelby | 18145 | 604 | 28 | 0 | 576 | 39.52305623 | -85.79158570000001 | 2020-08-23 04:27:48 | Shelby, Indiana, US |
750275 | 750275 | 2020-08-01 | US | Indiana | Boone | 18011 | 626 | 50 | 0 | 576 | 40.0509304 | -86.46841646 | 2020-08-02 04:34:47 | Boone, Indiana, US |
750806 | 750806 | 2020-08-01 | US | Indiana | Delaware | 18035 | 628 | 52 | 0 | 576 | 40.22787247 | -85.39732772 | 2020-08-02 04:34:47 | Delaware, Indiana, US |
3183799 | 3183799 | 2020-07-28 | US | Indiana | Noble | 18113 | 605 | 29 | 0 | 576 | 41.39672484 | -85.41966713 | 2020-07-29 04:35:11 | Noble, Indiana, US |
520431 | 520431 | 2020-04-21 | US | Indiana | Hamilton | 18057 | 615 | 39 | 0 | 576 | 40.07306535 | -86.05244729 | 2020-04-21 23:30:50 | Hamilton, Indiana, 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]);