johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 4951 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1564060 | 1564060 | 2021-06-14 | India | Tripura | 59849 | 624 | 54274 | 4951 | 23.746783 | 91.743565 | 2021-06-15 04:22:22 | Tripura, India | ||
3129393 | 3129393 | 2021-04-18 | Cuba | 93511 | 525 | 88035 | 4951 | 21.521757 | -77.78116700000002 | 2021-04-19 04:20:57 | Cuba | |||
183492 | 183492 | 2021-02-21 | US | Kentucky | Pike | 21195 | 5008 | 57 | 0 | 4951 | 37.47088263 | -82.39487445 | 2021-02-22 05:24:21 | Pike, Kentucky, US |
3050048 | 3050048 | 2021-02-16 | Cuba | 39941 | 274 | 34716 | 4951 | 21.521757 | -77.78116700000002 | 2021-02-17 05:23:10 | Cuba | |||
1591292 | 1591292 | 2021-02-05 | US | Texas | Hunt | 48231 | 4685 | 131 | 0 | 4951 | 33.12351514 | -96.08551032 | 2021-02-06 05:23:55 | Hunt, Texas, US |
911703 | 911703 | 2021-01-19 | US | Wisconsin | Columbia | 55021 | 4995 | 44 | 0 | 4951 | 43.46492199 | -89.33589004 | 2021-01-20 05:21:54 | Columbia, Wisconsin, US |
2230172 | 2230172 | 2021-01-02 | US | Pennsylvania | Crawford | 42039 | 5035 | 84 | 0 | 4951 | 41.68447709 | -80.10760592 | 2021-01-03 05:22:52 | Crawford, Pennsylvania, US |
3694480 | 3694480 | 2020-12-24 | US | Texas | Angelina | 48005 | 3772 | 135 | 0 | 4951 | 31.25457347 | -94.60901487 | 2020-12-25 05:22:48 | Angelina, Texas, US |
2348698 | 2348698 | 2020-12-07 | US | Kansas | Finney | 20055 | 4980 | 29 | 0 | 4951 | 38.04340344 | -100.7381938 | 2020-12-08 05:27:42 | Finney, Kansas, US |
738250 | 738250 | 2020-12-02 | India | Jammu and Kashmir | 111130 | 1708 | 104471 | 4951 | 33.75943 | 76.612638 | 2020-12-03 05:28:22 | Jammu and Kashmir, India | ||
3412864 | 3412864 | 2020-11-01 | US | Washington | Clark | 53011 | 5041 | 90 | 0 | 4951 | 45.77568046 | -122.4829204 | 2020-11-02 05:25:04 | Clark, Washington, US |
2860466 | 2860466 | 2020-10-16 | Ukraine | Kiev Oblast | 12207 | 261 | 6995 | 4951 | 50.053 | 30.7667 | 2020-10-17 04:24:12 | Kiev Oblast, Ukraine | ||
79792 | 79792 | 2020-10-14 | US | Florida | Martin | 12085 | 5102 | 151 | 0 | 4951 | 27.0772071 | -80.43109784 | 2020-10-15 04:24:28 | Martin, Florida, US |
79374 | 79374 | 2020-10-14 | Spain | Cantabria | 7478 | 240 | 2287 | 4951 | 43.1828 | -3.9878 | 2020-10-15 04:24:28 | Cantabria, Spain | ||
429015 | 429015 | 2020-09-07 | US | Minnesota | Anoka | 27003 | 5076 | 125 | 0 | 4951 | 45.27476015 | -93.24604565 | 2020-09-08 04:28:25 | Anoka, Minnesota, US |
1481718 | 1481718 | 2020-08-21 | US | New Jersey | Somerset | 34035 | 5515 | 564 | 0 | 4951 | 40.56465737 | -74.61683016 | 2020-08-22 04:27:49 | Somerset, New Jersey, US |
96604 | 96604 | 2020-08-04 | US | Alabama | Madison | 1089 | 4978 | 27 | 0 | 4951 | 34.76327133 | -86.55069633 | 2020-08-05 04:34:43 | Madison, Alabama, US |
2806276 | 2806276 | 2020-08-02 | US | California | Marin | 6041 | 4994 | 43 | 0 | 4951 | 38.07122463 | -122.7210631 | 2020-08-03 04:34:35 | Marin, California, US |
3262359 | 3262359 | 2020-07-31 | US | North Carolina | Guilford | 37081 | 5093 | 142 | 0 | 4951 | 36.07959451 | -79.78824948 | 2020-08-01 04:36:27 | Guilford, North Carolina, US |
805440 | 805440 | 2020-06-01 | Brazil | Piaui | 5506 | 180 | 0 | 4951 | -7.7183 | -42.7289 | 2020-06-02 02:33:08 | Piaui, Brazil |
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]);