daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,604 rows where deaths = 287 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 1,239
- Liberia 91
- Russia 46
- Netherlands 44
- Japan 38
- Sweden 37
- Ukraine 11
- Chile 7
- France 7
- Peru 7
- Togo 7
- India 6
- Malaysia 5
- Colombia 4
- Germany 4
- Israel 4
- United Kingdom 4
- Bahamas 3
- Cabo Verde 3
- Mexico 3
- Spain 3
- Australia 2
- Italy 2
- Maldives 2
- Niger 2
- Pakistan 2
- Rwanda 2
- Senegal 2
- Bahrain 1
- Brazil 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-30 04:21:04 | Columbus, North Carolina, US | |
2022-12-29 | US | Missouri | Boone | 29019 | 51887 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-30 04:21:04 | Boone, Missouri, US | |
2022-12-29 | US | Minnesota | Scott | 27139 | 47085 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-30 04:21:04 | Scott, Minnesota, US | |
2022-12-28 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-29 04:21:01 | Columbus, North Carolina, US | |
2022-12-28 | US | Missouri | Boone | 29019 | 51887 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-29 04:21:01 | Boone, Missouri, US | |
2022-12-28 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-29 04:21:01 | Scott, Minnesota, US | |
2022-12-27 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-28 04:21:04 | Columbus, North Carolina, US | |
2022-12-27 | US | Missouri | Boone | 29019 | 51887 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-28 04:21:04 | Boone, Missouri, US | |
2022-12-27 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-28 04:21:04 | Scott, Minnesota, US | |
2022-12-26 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-27 04:21:07 | Columbus, North Carolina, US | |
2022-12-26 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-27 04:21:07 | Boone, Missouri, US | |
2022-12-26 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-27 04:21:07 | Scott, Minnesota, US | |
2022-12-25 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-26 04:21:06 | Columbus, North Carolina, US | |
2022-12-25 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-26 04:21:06 | Boone, Missouri, US | |
2022-12-25 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-26 04:21:06 | Scott, Minnesota, US | |
2022-12-24 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-25 04:21:04 | Columbus, North Carolina, US | |
2022-12-24 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-25 04:21:04 | Boone, Missouri, US | |
2022-12-24 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-25 04:21:04 | Scott, Minnesota, US | |
2022-12-23 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-24 04:21:02 | Columbus, North Carolina, US | |
2022-12-23 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-24 04:21:02 | Boone, Missouri, US | |
2022-12-23 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-24 04:21:02 | Scott, Minnesota, US | |
2022-12-22 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-23 04:21:04 | Columbus, North Carolina, US | |
2022-12-22 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-23 04:21:04 | Boone, Missouri, US | |
2022-12-22 | US | Minnesota | Scott | 27139 | 46955 | 287 | 0 | 44.6490231 | -93.53340251 | 2022-12-23 04:21:04 | Scott, Minnesota, US | |
2022-12-21 | US | North Carolina | Columbus | 37047 | 18522 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-22 04:20:56 | Columbus, North Carolina, US | |
2022-12-21 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-22 04:20:56 | Boone, Missouri, US | |
2022-12-21 | Japan | Yamagata | 191122 | 287 | 0 | 38.448396 | 140.102154 | 2022-12-22 04:20:56 | Yamagata, Japan | |||
2022-12-20 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-21 04:21:03 | Lewis, Washington, US | |
2022-12-20 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-21 04:21:03 | Columbus, North Carolina, US | |
2022-12-20 | US | Missouri | Boone | 29019 | 51684 | 287 | 0 | 38.99186229 | -92.30723575 | 2022-12-21 04:21:03 | Boone, Missouri, US | |
2022-12-20 | Japan | Yamagata | 189737 | 287 | 0 | 38.448396 | 140.102154 | 2022-12-21 04:21:03 | Yamagata, Japan | |||
2022-12-19 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-20 04:21:04 | Lewis, Washington, US | |
2022-12-19 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-20 04:21:04 | Columbus, North Carolina, US | |
2022-12-18 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-19 04:21:03 | Lewis, Washington, US | |
2022-12-18 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-19 04:21:03 | Columbus, North Carolina, US | |
2022-12-17 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-18 04:21:03 | Lewis, Washington, US | |
2022-12-17 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-18 04:21:03 | Columbus, North Carolina, US | |
2022-12-16 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-17 04:21:04 | Lewis, Washington, US | |
2022-12-16 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-17 04:21:04 | Columbus, North Carolina, US | |
2022-12-15 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-16 04:21:01 | Lewis, Washington, US | |
2022-12-15 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-16 04:21:01 | Columbus, North Carolina, US | |
2022-12-14 | US | Washington | Lewis | 53041 | 20395 | 287 | 0 | 46.57756476 | -122.3925769 | 2022-12-15 04:20:58 | Lewis, Washington, US | |
2022-12-14 | US | North Carolina | Columbus | 37047 | 18444 | 287 | 0 | 34.26744084 | -78.65801424 | 2022-12-15 04:20:58 | Columbus, North Carolina, US | |
2022-12-14 | US | Arkansas | Crawford | 5033 | 18250 | 287 | 0 | 35.58928601 | -94.2446814 | 2022-12-15 04:20:58 | Crawford, Arkansas, US | |
2022-12-13 | US | Arkansas | Crawford | 5033 | 18242 | 287 | 0 | 35.58928601 | -94.2446814 | 2022-12-14 04:21:04 | Crawford, Arkansas, US | |
2022-12-08 | US | Tennessee | Gibson | 47053 | 20820 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-09 04:21:05 | Gibson, Tennessee, US | |
2022-12-08 | US | Maine | Kennebec | 23011 | 28818 | 287 | 0 | 44.40759555 | -69.76738544 | 2022-12-09 04:21:05 | Kennebec, Maine, US | |
2022-12-07 | US | Tennessee | Gibson | 47053 | 20808 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-08 04:21:07 | Gibson, Tennessee, US | |
2022-12-07 | US | Tennessee | Coffee | 47031 | 20041 | 287 | 0 | 35.49090731 | -86.07311784 | 2022-12-08 04:21:07 | Coffee, Tennessee, US | |
2022-12-06 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-07 04:20:58 | Hood, Texas, US | |
2022-12-06 | US | Tennessee | Gibson | 47053 | 20794 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-07 04:20:58 | Gibson, Tennessee, US | |
2022-12-06 | US | Tennessee | Coffee | 47031 | 20018 | 287 | 0 | 35.49090731 | -86.07311784 | 2022-12-07 04:20:58 | Coffee, Tennessee, US | |
2022-12-05 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-06 04:21:03 | Hood, Texas, US | |
2022-12-05 | US | Tennessee | Gibson | 47053 | 20787 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-06 04:21:03 | Gibson, Tennessee, US | |
2022-12-05 | US | Tennessee | Coffee | 47031 | 20004 | 287 | 0 | 35.49090731 | -86.07311784 | 2022-12-06 04:21:03 | Coffee, Tennessee, US | |
2022-12-04 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-05 04:20:58 | Hood, Texas, US | |
2022-12-04 | US | Tennessee | Gibson | 47053 | 20746 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-05 04:20:58 | Gibson, Tennessee, US | |
2022-12-04 | US | Tennessee | Coffee | 47031 | 19977 | 287 | 0 | 35.49090731 | -86.07311784 | 2022-12-05 04:20:58 | Coffee, Tennessee, US | |
2022-12-03 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-04 04:20:56 | Hood, Texas, US | |
2022-12-03 | US | Tennessee | Gibson | 47053 | 20744 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-04 04:20:56 | Gibson, Tennessee, US | |
2022-12-03 | US | Tennessee | Coffee | 47031 | 19972 | 287 | 0 | 35.49090731 | -86.07311784 | 2022-12-04 04:20:56 | Coffee, Tennessee, US | |
2022-12-02 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-03 04:21:02 | Hood, Texas, US | |
2022-12-02 | US | Tennessee | Gibson | 47053 | 20737 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-03 04:21:02 | Gibson, Tennessee, US | |
2022-12-02 | US | Tennessee | Coffee | 47031 | 19961 | 287 | 0 | 35.49090731 | -86.07311784 | 2022-12-03 04:21:02 | Coffee, Tennessee, US | |
2022-12-02 | US | Ohio | Geauga | 39055 | 19434 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-12-03 04:21:02 | Geauga, Ohio, US | |
2022-12-01 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-02 04:21:07 | Hood, Texas, US | |
2022-12-01 | US | Tennessee | Gibson | 47053 | 20730 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-02 04:21:07 | Gibson, Tennessee, US | |
2022-12-01 | US | Ohio | Geauga | 39055 | 19434 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-12-02 04:21:07 | Geauga, Ohio, US | |
2022-11-30 | US | Texas | Hood | 48221 | 14599 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-12-01 04:21:03 | Hood, Texas, US | |
2022-11-30 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-12-01 04:21:03 | Geauga, Ohio, US | |
2022-11-29 | US | Texas | Hood | 48221 | 14570 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-30 04:21:07 | Hood, Texas, US | |
2022-11-29 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-30 04:21:07 | Geauga, Ohio, US | |
2022-11-28 | US | Texas | Hood | 48221 | 14570 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-29 04:21:05 | Hood, Texas, US | |
2022-11-28 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-29 04:21:05 | Geauga, Ohio, US | |
2022-11-27 | US | Texas | Hood | 48221 | 14555 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-28 04:21:02 | Hood, Texas, US | |
2022-11-27 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-28 04:21:02 | Geauga, Ohio, US | |
2022-11-26 | US | Texas | Hood | 48221 | 14555 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-27 04:21:05 | Hood, Texas, US | |
2022-11-26 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-27 04:21:05 | Geauga, Ohio, US | |
2022-11-25 | US | Texas | Hood | 48221 | 14555 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-26 04:21:11 | Hood, Texas, US | |
2022-11-25 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-26 04:21:11 | Geauga, Ohio, US | |
2022-11-25 | US | Ohio | Delaware | 39041 | 53521 | 287 | 0 | 40.27942393 | -83.00457058 | 2022-11-26 04:21:11 | Delaware, Ohio, US | |
2022-11-24 | US | Texas | Hood | 48221 | 14555 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-25 04:21:06 | Hood, Texas, US | |
2022-11-24 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-25 04:21:06 | Geauga, Ohio, US | |
2022-11-24 | US | Ohio | Delaware | 39041 | 53521 | 287 | 0 | 40.27942393 | -83.00457058 | 2022-11-25 04:21:06 | Delaware, Ohio, US | |
2022-11-23 | US | Texas | Hood | 48221 | 14555 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-24 04:21:09 | Hood, Texas, US | |
2022-11-23 | US | Ohio | Geauga | 39055 | 19326 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-24 04:21:09 | Geauga, Ohio, US | |
2022-11-23 | US | Ohio | Delaware | 39041 | 53521 | 287 | 0 | 40.27942393 | -83.00457058 | 2022-11-24 04:21:09 | Delaware, Ohio, US | |
2022-11-22 | US | Texas | Hood | 48221 | 14549 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-23 04:21:06 | Hood, Texas, US | |
2022-11-22 | US | Ohio | Geauga | 39055 | 19271 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-23 04:21:06 | Geauga, Ohio, US | |
2022-11-22 | US | Ohio | Delaware | 39041 | 53399 | 287 | 0 | 40.27942393 | -83.00457058 | 2022-11-23 04:21:06 | Delaware, Ohio, US | |
2022-11-21 | US | Texas | Hood | 48221 | 14549 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-22 04:20:47 | Hood, Texas, US | |
2022-11-21 | US | Ohio | Geauga | 39055 | 19271 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-22 04:20:47 | Geauga, Ohio, US | |
2022-11-21 | US | Ohio | Delaware | 39041 | 53399 | 287 | 0 | 40.27942393 | -83.00457058 | 2022-11-22 04:20:47 | Delaware, Ohio, US | |
2022-11-20 | US | Texas | Hood | 48221 | 14543 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-21 04:21:05 | Hood, Texas, US | |
2022-11-20 | US | Ohio | Geauga | 39055 | 19271 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-21 04:21:05 | Geauga, Ohio, US | |
2022-11-19 | US | Texas | Hood | 48221 | 14543 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-20 04:21:08 | Hood, Texas, US | |
2022-11-19 | US | Ohio | Geauga | 39055 | 19271 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-20 04:21:08 | Geauga, Ohio, US | |
2022-11-18 | US | Texas | Hood | 48221 | 14543 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-19 04:21:14 | Hood, Texas, US | |
2022-11-18 | US | Ohio | Geauga | 39055 | 19271 | 287 | 0 | 41.49952319 | -81.17935342 | 2022-11-19 04:21:14 | Geauga, Ohio, US | |
2022-11-17 | US | Texas | Hood | 48221 | 14538 | 287 | 0 | 32.42990927 | -97.83242024 | 2022-11-18 04:21:15 | Hood, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;