daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where confirmed = 17690 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 20
- Malaysia 1
- Mauritania 1
- Mexico 1
- Netherlands 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-22 | US | New Jersey | Salem | 34033 | 17690 | 261 | 0 | 39.58719656 | -75.3469663 | 2022-12-23 04:21:04 | Salem, New Jersey, US | |
2022-07-12 | Malaysia | Perlis | 17690 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-13 04:20:58 | Perlis, Malaysia | |||
2022-05-17 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-18 04:20:50 | Indiana, Pennsylvania, US | |
2022-05-16 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-17 04:20:59 | Indiana, Pennsylvania, US | |
2022-05-15 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-16 04:20:47 | Indiana, Pennsylvania, US | |
2022-05-14 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-15 04:20:53 | Indiana, Pennsylvania, US | |
2022-05-13 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-14 04:20:48 | Indiana, Pennsylvania, US | |
2022-05-12 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-13 04:20:51 | Indiana, Pennsylvania, US | |
2022-05-11 | US | Pennsylvania | Indiana | 42063 | 17690 | 356 | 0 | 40.65241041 | -79.08963285 | 2022-05-12 04:20:54 | Indiana, Pennsylvania, US | |
2022-01-11 | US | Kansas | Douglas | 20045 | 17690 | 113 | 0 | 38.88503636 | -95.2925121 | 2022-01-12 04:21:44 | Douglas, Kansas, US | |
2022-01-10 | US | Kansas | Douglas | 20045 | 17690 | 113 | 0 | 38.88503636 | -95.2925121 | 2022-01-11 04:22:01 | Douglas, Kansas, US | |
2021-11-17 | US | Kentucky | Daviess | 21059 | 17690 | 272 | 0 | 37.73028906 | -87.09019479999998 | 2021-11-18 04:21:33 | Daviess, Kentucky, US | |
2021-07-18 | US | South Carolina | Aiken | 45003 | 17690 | 225 | 0 | 33.54338026 | -81.63645384 | 2021-07-19 04:21:24 | Aiken, South Carolina, US | |
2021-07-17 | US | South Carolina | Aiken | 45003 | 17690 | 225 | 0 | 33.54338026 | -81.63645384 | 2021-07-18 04:22:07 | Aiken, South Carolina, US | |
2021-07-16 | US | South Carolina | Aiken | 45003 | 17690 | 225 | 0 | 33.54338026 | -81.63645384 | 2021-07-17 04:22:22 | Aiken, South Carolina, US | |
2021-05-08 | US | South Carolina | Florence | 45041 | 17690 | 415 | 0 | 34.02361754 | -79.70189312 | 2021-05-09 04:20:35 | Florence, South Carolina, US | |
2021-03-24 | Mauritania | 17690 | 447 | 16947 | 296 | 21.0079 | -10.9408 | 2021-03-25 05:27:00 | Mauritania | |||
2021-03-23 | US | Pennsylvania | Cumberland | 42041 | 17690 | 492 | 0 | 40.1625372 | -77.26130755 | 2021-03-24 05:25:40 | Cumberland, Pennsylvania, US | |
2021-03-11 | Netherlands | Zeeland | 17690 | 201 | 0 | 17461 | 51.47936 | 3.861559 | 2021-03-12 05:26:50 | Zeeland, Netherlands | ||
2021-01-11 | US | Alabama | Shelby | 1117 | 17690 | 106 | 0 | 17584 | 33.26879845 | -86.66232561 | 2021-01-12 05:22:15 | Shelby, Alabama, US |
2020-09-29 | US | Illinois | DuPage | 17043 | 17690 | 562 | 0 | 17128 | 41.85116968 | -88.08642662 | 2020-09-30 04:23:33 | DuPage, Illinois, US |
2020-09-26 | US | Texas | Cameron | 48061 | 17690 | 903 | 0 | 21795 | 26.14524221 | -97.48140372 | 2020-09-27 04:23:00 | Cameron, Texas, US |
2020-08-25 | US | Indiana | Marion | 18097 | 17690 | 782 | 0 | 16908 | 39.78163624 | -86.13826325 | 2020-08-26 04:28:11 | Marion, Indiana, US |
2020-05-22 | Mexico | Ciudad de Mexico | 17690 | 1854 | 12341 | 3495 | 19.4326 | -99.1332 | 2020-05-23 02:32:42 | Ciudad de Mexico, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;