daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
636 rows where deaths = 474 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 441
- Italy 58
- Russia 36
- Sweden 29
- Japan 12
- Cameroon 10
- Ukraine 6
- India 5
- Netherlands 5
- Brazil 4
- Colombia 4
- Chile 3
- Germany 2
- Mexico 2
- Angola 1
- Bahrain 1
- Belarus 1
- Dominican Republic 1
- Ecuador 1
- Estonia 1
- Kenya 1
- Korea, South 1
- Kuwait 1
- Libya 1
- Malaysia 1
- Mali 1
- Malta 1
- Montenegro 1
- Namibia 1
- Paraguay 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Tennessee | Madison | 47113 | 37652 | 474 | 0 | 35.61181957 | -88.84076036 | 2022-12-30 04:21:04 | Madison, Tennessee, US | |
2022-12-29 | US | California | Butte | 6007 | 50721 | 474 | 0 | 39.66727762 | -121.6005252 | 2022-12-30 04:21:04 | Butte, California, US | |
2022-12-28 | US | Tennessee | Madison | 47113 | 37652 | 474 | 0 | 35.61181957 | -88.84076036 | 2022-12-29 04:21:01 | Madison, Tennessee, US | |
2022-12-28 | US | California | Solano | 6095 | 118806 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-29 04:21:01 | Solano, California, US | |
2022-12-28 | Japan | Oita | 242768 | 474 | 0 | 33.200697 | 131.43324 | 2022-12-29 04:21:01 | Oita, Japan | |||
2022-12-27 | US | California | Solano | 6095 | 118806 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-28 04:21:04 | Solano, California, US | |
2022-12-26 | US | California | Solano | 6095 | 118117 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-27 04:21:07 | Solano, California, US | |
2022-12-25 | US | California | Solano | 6095 | 118117 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-26 04:21:06 | Solano, California, US | |
2022-12-24 | US | California | Solano | 6095 | 118117 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-25 04:21:04 | Solano, California, US | |
2022-12-23 | US | California | Solano | 6095 | 118117 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-24 04:21:02 | Solano, California, US | |
2022-12-22 | US | California | Solano | 6095 | 118117 | 474 | 0 | 38.26827353 | -121.9357113 | 2022-12-23 04:21:04 | Solano, California, US | |
2022-12-20 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-21 04:21:03 | Bartow, Georgia, US | |
2022-12-20 | Japan | Yamaguchi | 220471 | 474 | 0 | 34.20119 | 131.573293 | 2022-12-21 04:21:03 | Yamaguchi, Japan | |||
2022-12-19 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-20 04:21:04 | Bartow, Georgia, US | |
2022-12-18 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-19 04:21:03 | Bartow, Georgia, US | |
2022-12-17 | US | Tennessee | Madison | 47113 | 37472 | 474 | 0 | 35.61181957 | -88.84076036 | 2022-12-18 04:21:03 | Madison, Tennessee, US | |
2022-12-17 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-18 04:21:03 | Bartow, Georgia, US | |
2022-12-16 | US | Tennessee | Madison | 47113 | 37458 | 474 | 0 | 35.61181957 | -88.84076036 | 2022-12-17 04:21:04 | Madison, Tennessee, US | |
2022-12-16 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-17 04:21:04 | Bartow, Georgia, US | |
2022-12-15 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-16 04:21:01 | Bartow, Georgia, US | |
2022-12-14 | US | Georgia | Bartow | 13015 | 34179 | 474 | 0 | 34.23732119 | -84.83887523 | 2022-12-15 04:20:58 | Bartow, Georgia, US | |
2022-12-13 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-14 04:21:04 | Howard, Indiana, US | |
2022-12-12 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-13 04:21:01 | Howard, Indiana, US | |
2022-12-11 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-12 04:21:01 | Howard, Indiana, US | |
2022-12-10 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-11 04:20:50 | Howard, Indiana, US | |
2022-12-09 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-10 04:21:02 | Howard, Indiana, US | |
2022-12-08 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-09 04:21:05 | Howard, Indiana, US | |
2022-12-07 | US | Indiana | Howard | 18067 | 29217 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-08 04:21:07 | Howard, Indiana, US | |
2022-12-06 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-07 04:20:58 | Howard, Indiana, US | |
2022-12-06 | Japan | Okayama | 339835 | 474 | 0 | 34.89246 | 133.826252 | 2022-12-07 04:20:58 | Okayama, Japan | |||
2022-12-05 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-06 04:21:03 | Howard, Indiana, US | |
2022-12-04 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-05 04:20:58 | Howard, Indiana, US | |
2022-12-03 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-04 04:20:56 | Howard, Indiana, US | |
2022-12-02 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-03 04:21:02 | Howard, Indiana, US | |
2022-12-01 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-02 04:21:07 | Howard, Indiana, US | |
2022-11-30 | US | Indiana | Howard | 18067 | 28987 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-12-01 04:21:03 | Howard, Indiana, US | |
2022-11-29 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-30 04:21:07 | Howard, Indiana, US | |
2022-11-28 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-29 04:21:05 | Howard, Indiana, US | |
2022-11-27 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-28 04:21:02 | Howard, Indiana, US | |
2022-11-26 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-27 04:21:05 | Howard, Indiana, US | |
2022-11-25 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-26 04:21:11 | Howard, Indiana, US | |
2022-11-24 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-25 04:21:06 | Howard, Indiana, US | |
2022-11-23 | US | Indiana | Howard | 18067 | 28897 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-24 04:21:09 | Howard, Indiana, US | |
2022-11-22 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-23 04:21:06 | Howard, Indiana, US | |
2022-11-22 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-23 04:21:06 | Walker, Alabama, US | |
2022-11-21 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-22 04:20:47 | Howard, Indiana, US | |
2022-11-21 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-22 04:20:47 | Walker, Alabama, US | |
2022-11-20 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-21 04:21:05 | Howard, Indiana, US | |
2022-11-20 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-21 04:21:05 | Walker, Alabama, US | |
2022-11-19 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-20 04:21:08 | Howard, Indiana, US | |
2022-11-19 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-20 04:21:08 | Walker, Alabama, US | |
2022-11-18 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-19 04:21:14 | Howard, Indiana, US | |
2022-11-18 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-19 04:21:14 | Walker, Alabama, US | |
2022-11-17 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-18 04:21:15 | Howard, Indiana, US | |
2022-11-17 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-18 04:21:15 | Walker, Alabama, US | |
2022-11-16 | US | Indiana | Howard | 18067 | 28837 | 474 | 0 | 40.48527731 | -86.11351892 | 2022-11-17 04:21:11 | Howard, Indiana, US | |
2022-11-16 | US | Alabama | Walker | 1127 | 22519 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-17 04:21:11 | Walker, Alabama, US | |
2022-11-15 | US | Alabama | Walker | 1127 | 22511 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-16 04:21:09 | Walker, Alabama, US | |
2022-11-14 | US | Ohio | Portage | 39133 | 41576 | 474 | 0 | 41.16793482 | -81.19735782 | 2022-11-15 04:21:16 | Portage, Ohio, US | |
2022-11-14 | US | Alabama | Walker | 1127 | 22511 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-15 04:21:16 | Walker, Alabama, US | |
2022-11-13 | US | Ohio | Portage | 39133 | 41576 | 474 | 0 | 41.16793482 | -81.19735782 | 2022-11-14 04:21:09 | Portage, Ohio, US | |
2022-11-13 | US | Alabama | Walker | 1127 | 22511 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-14 04:21:09 | Walker, Alabama, US | |
2022-11-12 | US | Ohio | Portage | 39133 | 41576 | 474 | 0 | 41.16793482 | -81.19735782 | 2022-11-13 04:21:14 | Portage, Ohio, US | |
2022-11-12 | US | Alabama | Walker | 1127 | 22511 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-13 04:21:14 | Walker, Alabama, US | |
2022-11-11 | US | Ohio | Portage | 39133 | 41576 | 474 | 0 | 41.16793482 | -81.19735782 | 2022-11-12 04:20:41 | Portage, Ohio, US | |
2022-11-11 | US | Alabama | Walker | 1127 | 22511 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-12 04:20:41 | Walker, Alabama, US | |
2022-11-10 | US | Alabama | Walker | 1127 | 22511 | 474 | 0 | 33.80270512 | -87.30027177 | 2022-11-11 04:21:22 | Walker, Alabama, US | |
2022-11-06 | US | Texas | Parker | 48367 | 38917 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-07 04:21:26 | Parker, Texas, US | |
2022-11-05 | US | Texas | Parker | 48367 | 38917 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-06 04:21:24 | Parker, Texas, US | |
2022-11-04 | US | Texas | Parker | 48367 | 38917 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-05 04:21:52 | Parker, Texas, US | |
2022-11-03 | US | Texas | Parker | 48367 | 38892 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-04 04:22:11 | Parker, Texas, US | |
2022-11-02 | US | Texas | Parker | 48367 | 38892 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-03 04:22:05 | Parker, Texas, US | |
2022-11-01 | US | Texas | Parker | 48367 | 38882 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-02 04:22:09 | Parker, Texas, US | |
2022-10-31 | US | Texas | Parker | 48367 | 38882 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-11-01 04:22:36 | Parker, Texas, US | |
2022-10-30 | US | Texas | Parker | 48367 | 38867 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-10-31 04:21:36 | Parker, Texas, US | |
2022-10-29 | US | Texas | Parker | 48367 | 38867 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-10-30 04:22:14 | Parker, Texas, US | |
2022-10-28 | US | Texas | Parker | 48367 | 38867 | 474 | 0 | 32.77757172 | -97.80500621 | 2022-10-29 04:21:13 | Parker, Texas, US | |
2022-10-26 | US | Colorado | Douglas | 8035 | 96515 | 474 | 0 | 39.33133796 | -104.930001 | 2022-10-27 04:22:01 | Douglas, Colorado, US | |
2022-10-25 | US | Colorado | Douglas | 8035 | 96468 | 474 | 0 | 39.33133796 | -104.930001 | 2022-10-26 04:22:19 | Douglas, Colorado, US | |
2022-10-06 | Japan | Gunma | 239836 | 474 | 0 | 36.504479 | 138.985605 | 2022-10-07 04:23:08 | Gunma, Japan | |||
2022-10-05 | Japan | Gunma | 239276 | 474 | 0 | 36.504479 | 138.985605 | 2022-10-06 04:21:22 | Gunma, Japan | |||
2022-09-29 | US | Texas | Maverick | 48323 | 23397 | 474 | 0 | 28.7429195 | -100.3157686 | 2022-09-30 04:23:09 | Maverick, Texas, US | |
2022-09-28 | US | Texas | Maverick | 48323 | 23383 | 474 | 0 | 28.7429195 | -100.3157686 | 2022-09-29 04:22:34 | Maverick, Texas, US | |
2022-09-27 | US | Texas | Maverick | 48323 | 23383 | 474 | 0 | 28.7429195 | -100.3157686 | 2022-09-28 04:23:01 | Maverick, Texas, US | |
2022-09-27 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-28 04:23:01 | Newton, Georgia, US | |
2022-09-26 | US | Texas | Maverick | 48323 | 23383 | 474 | 0 | 28.7429195 | -100.3157686 | 2022-09-27 04:23:01 | Maverick, Texas, US | |
2022-09-26 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-27 04:23:01 | Newton, Georgia, US | |
2022-09-25 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-26 04:20:52 | Newton, Georgia, US | |
2022-09-24 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-25 04:23:31 | Newton, Georgia, US | |
2022-09-23 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-24 04:21:40 | Newton, Georgia, US | |
2022-09-22 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-23 04:23:13 | Newton, Georgia, US | |
2022-09-21 | US | Utah | Weber-Morgan | 83450 | 474 | 0 | 41.27116049 | -111.9145117 | 2022-09-22 04:22:56 | Weber-Morgan, Utah, US | ||
2022-09-21 | US | Georgia | Newton | 13217 | 28598 | 474 | 0 | 33.55514538 | -83.8454714 | 2022-09-22 04:22:56 | Newton, Georgia, US | |
2022-09-20 | US | Utah | Weber-Morgan | 83450 | 474 | 0 | 41.27116049 | -111.9145117 | 2022-09-21 04:23:22 | Weber-Morgan, Utah, US | ||
2022-09-20 | US | Tennessee | Blount | 47009 | 45471 | 474 | 0 | 35.68938198 | -83.92847788 | 2022-09-21 04:23:22 | Blount, Tennessee, US | |
2022-09-19 | US | Utah | Weber-Morgan | 83450 | 474 | 0 | 41.27116049 | -111.9145117 | 2022-09-20 04:22:48 | Weber-Morgan, Utah, US | ||
2022-09-19 | US | Tennessee | Blount | 47009 | 45434 | 474 | 0 | 35.68938198 | -83.92847788 | 2022-09-20 04:22:48 | Blount, Tennessee, US | |
2022-09-18 | US | Utah | Weber-Morgan | 83450 | 474 | 0 | 41.27116049 | -111.9145117 | 2022-09-19 04:21:49 | Weber-Morgan, Utah, US | ||
2022-09-17 | US | Utah | Weber-Morgan | 83450 | 474 | 0 | 41.27116049 | -111.9145117 | 2022-09-18 04:22:50 | Weber-Morgan, Utah, US | ||
2022-09-16 | US | Utah | Weber-Morgan | 83450 | 474 | 0 | 41.27116049 | -111.9145117 | 2022-09-17 04:20:19 | Weber-Morgan, Utah, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;