johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 14422 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543823 | 543823 | 2022-12-15 | US | Illinois | Stephenson | 17177 | 14422 | 178 | 0 | 42.35129217 | -89.662598 | 2022-12-16 04:21:01 | Stephenson, Illinois, US | |
2396339 | 2396339 | 2022-09-12 | US | Louisiana | St. Martin | 22099 | 14422 | 195 | 0 | 30.13112107 | -91.61403569 | 2022-09-13 04:20:57 | St. Martin, Louisiana, US | |
903182 | 903182 | 2022-07-22 | US | Texas | Atascosa | 48013 | 14422 | 233 | 0 | 28.89333001 | -98.52730485 | 2022-07-23 04:20:53 | Atascosa, Texas, US | |
3406595 | 3406595 | 2022-07-17 | US | Indiana | Shelby | 18145 | 14422 | 184 | 0 | 39.52305623 | -85.7915857 | 2022-07-18 04:20:59 | Shelby, Indiana, US | |
2152795 | 2152795 | 2022-07-16 | US | Indiana | Shelby | 18145 | 14422 | 184 | 0 | 39.52305623 | -85.7915857 | 2022-07-17 04:21:15 | Shelby, Indiana, US | |
2420028 | 2420028 | 2022-07-15 | US | Indiana | Shelby | 18145 | 14422 | 184 | 0 | 39.52305623 | -85.7915857 | 2022-07-16 04:21:05 | Shelby, Indiana, US | |
3982882 | 3982882 | 2022-06-15 | Samoa | 14422 | 28 | 0 | -13.759 | -172.1046 | 2022-06-16 04:20:55 | Samoa | ||||
947123 | 947123 | 2022-06-14 | Samoa | 14422 | 28 | 0 | -13.759 | -172.1046 | 2022-06-15 04:20:54 | Samoa | ||||
3535598 | 3535598 | 2022-05-10 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-11 04:20:48 | Nicaragua | ||||
222133 | 222133 | 2022-05-09 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-10 04:20:50 | Nicaragua | ||||
2331518 | 2331518 | 2022-05-08 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-09 04:20:54 | Nicaragua | ||||
360480 | 360480 | 2022-05-07 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-08 04:20:49 | Nicaragua | ||||
1397831 | 1397831 | 2022-05-06 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-07 04:21:09 | Nicaragua | ||||
2598186 | 2598186 | 2022-05-05 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-06 04:21:00 | Nicaragua | ||||
3265635 | 3265635 | 2022-05-04 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-05 04:20:55 | Nicaragua | ||||
3227325 | 3227325 | 2022-01-19 | US | Georgia | Spalding | 13255 | 14422 | 350 | 0 | 33.26310031 | -84.28013991 | 2022-01-20 04:21:07 | Spalding, Georgia, US | |
289880 | 289880 | 2021-10-31 | US | Missouri | Cass | 29037 | 14422 | 164 | 0 | 38.64789422 | -94.353399 | 2021-11-01 04:22:01 | Cass, Missouri, US | |
1374481 | 1374481 | 2021-09-15 | Italy | Molise | 14422 | 495 | 0 | 41.55774754 | 14.65916051 | 2021-09-16 04:22:19 | Molise, Italy | |||
1599760 | 1599760 | 2021-08-26 | US | Wisconsin | La Crosse | 55063 | 14422 | 94 | 0 | 43.90632465 | -91.11451093 | 2021-08-27 04:21:37 | La Crosse, Wisconsin, US | |
2206607 | 2206607 | 2021-08-07 | US | Tennessee | Maury | 47119 | 14422 | 181 | 0 | 35.6187413 | -87.07462444 | 2021-08-08 04:21:33 | Maury, Tennessee, US | |
400334 | 400334 | 2021-06-29 | Mali | 14422 | 525 | 10059 | 3838 | 17.570692 | -3.996166000000001 | 2021-06-30 04:21:41 | Mali | |||
2591370 | 2591370 | 2021-06-27 | US | Kentucky | Boone | 21015 | 14422 | 147 | 0 | 38.97065142 | -84.72615357 | 2021-06-28 04:21:29 | Boone, Kentucky, US | |
2717507 | 2717507 | 2021-06-10 | US | California | Butte | 6007 | 14422 | 194 | 0 | 39.66727762 | -121.6005252 | 2021-06-11 04:23:20 | Butte, California, US | |
1873345 | 1873345 | 2021-05-15 | US | Alabama | Morgan | 1103 | 14422 | 280 | 0 | 34.45500589 | -86.85475946 | 2021-05-16 04:20:49 | Morgan, Alabama, US | |
745111 | 745111 | 2021-02-20 | US | South Carolina | Berkeley | 45015 | 14422 | 163 | 0 | 14259 | 33.20222596 | -79.94654523 | 2021-02-21 05:24:33 | Berkeley, South Carolina, US |
3233105 | 3233105 | 2021-01-03 | US | Pennsylvania | Dauphin | 42043 | 14422 | 321 | 0 | 14101 | 40.41377078 | -76.77993242 | 2021-01-04 05:22:02 | Dauphin, Pennsylvania, US |
2931392 | 2931392 | 2020-12-19 | Peru | Tacna | 14422 | 783 | 0 | 13639 | -17.644160999999997 | -70.27756 | 2020-12-20 05:27:32 | Tacna, Peru | ||
1901338 | 1901338 | 2020-12-18 | Peru | Tacna | 14422 | 783 | 0 | 13639 | -17.644160999999997 | -70.27756 | 2020-12-19 05:27:52 | Tacna, Peru | ||
2128164 | 2128164 | 2020-12-17 | Peru | Tacna | 14422 | 782 | 0 | 13640 | -17.644160999999997 | -70.27756 | 2020-12-18 05:28:18 | Tacna, Peru | ||
392388 | 392388 | 2020-11-27 | Peru | Ayacucho | 14422 | 798 | 0 | 13624 | -14.091648 | -74.08344 | 2020-11-28 05:25:50 | Ayacucho, Peru | ||
3491599 | 3491599 | 2020-07-13 | Colombia | Valle del Cauca | 14422 | 600 | 6664 | 7158 | 3.8009 | -76.6413 | 2020-07-14 04:34:46 | Valle del Cauca, Colombia | ||
997956 | 997956 | 2020-05-23 | Dominican Republic | 14422 | 458 | 7854 | 6110 | 18.7357 | -70.1627 | 2020-05-24 02:32:43 | Dominican Republic |
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]);