daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,250 rows where deaths = 366 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,068
- Spain 53
- Russia 18
- Sweden 16
- Japan 14
- Chile 8
- Mexico 7
- Netherlands 7
- Burkina Faso 6
- France 6
- India 5
- Ukraine 5
- Italy 4
- Malaysia 4
- Peru 4
- Bahrain 3
- Germany 3
- Pakistan 3
- Colombia 2
- Congo (Kinshasa) 2
- Angola 1
- Cabo Verde 1
- Cuba 1
- Cyprus 1
- Greece 1
- Mali 1
- Rwanda 1
- Slovakia 1
- United Arab Emirates 1
- Uzbekistan 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Virginia | Hampton | 51650 | 36881 | 366 | 0 | 37.03513786 | -76.35879121 | 2022-12-30 04:21:04 | Hampton, Virginia, US | |
2022-12-28 | US | Virginia | Hampton | 51650 | 36881 | 366 | 0 | 37.03513786 | -76.35879121 | 2022-12-29 04:21:01 | Hampton, Virginia, US | |
2022-12-26 | Netherlands | Groningen | 262948 | 366 | 0 | 53.217922 | 6.741514 | 2022-12-27 04:21:07 | Groningen, Netherlands | |||
2022-12-26 | Japan | Ishikawa | 232971 | 366 | 0 | 36.769464 | 136.771027 | 2022-12-27 04:21:07 | Ishikawa, Japan | |||
2022-12-25 | Netherlands | Groningen | 262948 | 366 | 0 | 53.217922 | 6.741514 | 2022-12-26 04:21:06 | Groningen, Netherlands | |||
2022-12-24 | Netherlands | Groningen | 262948 | 366 | 0 | 53.217922 | 6.741514 | 2022-12-25 04:21:04 | Groningen, Netherlands | |||
2022-12-23 | Netherlands | Groningen | 262948 | 366 | 0 | 53.217922 | 6.741514 | 2022-12-24 04:21:02 | Groningen, Netherlands | |||
2022-12-18 | Japan | Ehime | 221641 | 366 | 0 | 33.624835 | 132.856842 | 2022-12-19 04:21:03 | Ehime, Japan | |||
2022-12-17 | Japan | Kagawa | 185235 | 366 | 0 | 34.217292 | 133.969047 | 2022-12-18 04:21:03 | Kagawa, Japan | |||
2022-12-06 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-07 04:20:58 | Harnett, North Carolina, US | |
2022-12-05 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-06 04:21:03 | Harnett, North Carolina, US | |
2022-12-04 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-05 04:20:58 | Harnett, North Carolina, US | |
2022-12-03 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-04 04:20:56 | Harnett, North Carolina, US | |
2022-12-02 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-03 04:21:02 | Harnett, North Carolina, US | |
2022-12-01 | US | Tennessee | Carter | 47019 | 20379 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-12-02 04:21:07 | Carter, Tennessee, US | |
2022-12-01 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-02 04:21:07 | Harnett, North Carolina, US | |
2022-11-30 | US | Tennessee | Carter | 47019 | 20339 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-12-01 04:21:03 | Carter, Tennessee, US | |
2022-11-30 | US | North Carolina | Harnett | 37085 | 40478 | 366 | 0 | 35.36731853 | -78.87243571 | 2022-12-01 04:21:03 | Harnett, North Carolina, US | |
2022-11-29 | US | Tennessee | Carter | 47019 | 20314 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-30 04:21:07 | Carter, Tennessee, US | |
2022-11-29 | US | Arkansas | Craighead | 5031 | 44748 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-30 04:21:07 | Craighead, Arkansas, US | |
2022-11-28 | US | West Virginia | Wood | 54107 | 27056 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-29 04:21:05 | Wood, West Virginia, US | |
2022-11-28 | US | Tennessee | Carter | 47019 | 20283 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-29 04:21:05 | Carter, Tennessee, US | |
2022-11-28 | US | Arkansas | Craighead | 5031 | 44719 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-29 04:21:05 | Craighead, Arkansas, US | |
2022-11-27 | US | West Virginia | Wood | 54107 | 27012 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-28 04:21:02 | Wood, West Virginia, US | |
2022-11-27 | US | Tennessee | Carter | 47019 | 20262 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-28 04:21:02 | Carter, Tennessee, US | |
2022-11-27 | US | Arkansas | Craighead | 5031 | 44717 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-28 04:21:02 | Craighead, Arkansas, US | |
2022-11-26 | US | West Virginia | Wood | 54107 | 27012 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-27 04:21:05 | Wood, West Virginia, US | |
2022-11-26 | US | Tennessee | Carter | 47019 | 20251 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-27 04:21:05 | Carter, Tennessee, US | |
2022-11-26 | US | Arkansas | Craighead | 5031 | 44701 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-27 04:21:05 | Craighead, Arkansas, US | |
2022-11-25 | US | West Virginia | Wood | 54107 | 27012 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-26 04:21:11 | Wood, West Virginia, US | |
2022-11-25 | US | Tennessee | Carter | 47019 | 20234 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-26 04:21:11 | Carter, Tennessee, US | |
2022-11-25 | US | Arkansas | Craighead | 5031 | 44692 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-26 04:21:11 | Craighead, Arkansas, US | |
2022-11-24 | US | West Virginia | Wood | 54107 | 27012 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-25 04:21:06 | Wood, West Virginia, US | |
2022-11-24 | US | Tennessee | Carter | 47019 | 20231 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-25 04:21:06 | Carter, Tennessee, US | |
2022-11-24 | US | Arkansas | Craighead | 5031 | 44689 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-25 04:21:06 | Craighead, Arkansas, US | |
2022-11-23 | US | West Virginia | Wood | 54107 | 27012 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-24 04:21:09 | Wood, West Virginia, US | |
2022-11-23 | US | Tennessee | Carter | 47019 | 20230 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-24 04:21:09 | Carter, Tennessee, US | |
2022-11-23 | US | Arkansas | Craighead | 5031 | 44669 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-24 04:21:09 | Craighead, Arkansas, US | |
2022-11-22 | US | West Virginia | Wood | 54107 | 27005 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-23 04:21:06 | Wood, West Virginia, US | |
2022-11-22 | US | New Mexico | Santa Fe | 35049 | 38754 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-23 04:21:06 | Santa Fe, New Mexico, US | |
2022-11-22 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-23 04:21:06 | Fayette, Georgia, US | |
2022-11-22 | US | Arkansas | Craighead | 5031 | 44648 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-23 04:21:06 | Craighead, Arkansas, US | |
2022-11-22 | Japan | Aomori | 188189 | 366 | 0 | 40.781541 | 140.828896 | 2022-11-23 04:21:06 | Aomori, Japan | |||
2022-11-21 | US | West Virginia | Wood | 54107 | 26997 | 366 | 0 | 39.20967886 | -81.5162836 | 2022-11-22 04:20:47 | Wood, West Virginia, US | |
2022-11-21 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-22 04:20:47 | Oconee, South Carolina, US | |
2022-11-21 | US | New Mexico | Santa Fe | 35049 | 38703 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-22 04:20:47 | Santa Fe, New Mexico, US | |
2022-11-21 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-22 04:20:47 | Fayette, Georgia, US | |
2022-11-21 | US | Arkansas | Craighead | 5031 | 44630 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-22 04:20:47 | Craighead, Arkansas, US | |
2022-11-20 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-21 04:21:05 | Oconee, South Carolina, US | |
2022-11-20 | US | New Mexico | Santa Fe | 35049 | 38607 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-21 04:21:05 | Santa Fe, New Mexico, US | |
2022-11-20 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-21 04:21:05 | Fayette, Georgia, US | |
2022-11-20 | US | Arkansas | Craighead | 5031 | 44626 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-21 04:21:05 | Craighead, Arkansas, US | |
2022-11-19 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-20 04:21:08 | Oconee, South Carolina, US | |
2022-11-19 | US | New Mexico | Santa Fe | 35049 | 38607 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-20 04:21:08 | Santa Fe, New Mexico, US | |
2022-11-19 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-20 04:21:08 | Fayette, Georgia, US | |
2022-11-19 | US | Arkansas | Craighead | 5031 | 44622 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-20 04:21:08 | Craighead, Arkansas, US | |
2022-11-18 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-19 04:21:14 | Oconee, South Carolina, US | |
2022-11-18 | US | New Mexico | Santa Fe | 35049 | 38607 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-19 04:21:14 | Santa Fe, New Mexico, US | |
2022-11-18 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-19 04:21:14 | Fayette, Georgia, US | |
2022-11-18 | US | Arkansas | Craighead | 5031 | 44614 | 366 | 0 | 35.83018283 | -90.63235729 | 2022-11-19 04:21:14 | Craighead, Arkansas, US | |
2022-11-17 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-18 04:21:15 | Oconee, South Carolina, US | |
2022-11-17 | US | New Mexico | Santa Fe | 35049 | 38556 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-18 04:21:15 | Santa Fe, New Mexico, US | |
2022-11-17 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-18 04:21:15 | Fayette, Georgia, US | |
2022-11-16 | US | Tennessee | Carter | 47019 | 20106 | 366 | 0 | 36.28969086 | -82.12588974 | 2022-11-17 04:21:11 | Carter, Tennessee, US | |
2022-11-16 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-17 04:21:11 | Oconee, South Carolina, US | |
2022-11-16 | US | New Mexico | Santa Fe | 35049 | 38523 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-17 04:21:11 | Santa Fe, New Mexico, US | |
2022-11-16 | US | Georgia | Fayette | 13113 | 27809 | 366 | 0 | 33.41357794 | -84.49089434 | 2022-11-17 04:21:11 | Fayette, Georgia, US | |
2022-11-15 | US | South Carolina | Oconee | 45073 | 27753 | 366 | 0 | 34.75225169 | -83.06742317 | 2022-11-16 04:21:09 | Oconee, South Carolina, US | |
2022-11-15 | US | New Mexico | Santa Fe | 35049 | 38480 | 366 | 0 | 35.50708973 | -105.9774716 | 2022-11-16 04:21:09 | Santa Fe, New Mexico, US | |
2022-11-01 | Japan | Shiga | 246869 | 366 | 0 | 35.215827 | 136.138064 | 2022-11-02 04:22:09 | Shiga, Japan | |||
2022-10-31 | Japan | Shiga | 246038 | 366 | 0 | 35.215827 | 136.138064 | 2022-11-01 04:22:36 | Shiga, Japan | |||
2022-10-30 | Japan | Shiga | 245827 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-31 04:21:36 | Shiga, Japan | |||
2022-10-29 | Japan | Shiga | 245421 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-30 04:22:14 | Shiga, Japan | |||
2022-10-28 | Japan | Shiga | 244909 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-29 04:21:13 | Shiga, Japan | |||
2022-10-05 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-06 04:21:22 | Unassigned, Minnesota, US | |
2022-10-04 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Minnesota, US | |
2022-10-04 | Japan | Miyazaki | 196262 | 366 | 0 | 32.193204 | 131.299374 | 2022-10-05 04:23:06 | Miyazaki, Japan | |||
2022-10-03 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-04 04:22:55 | Unassigned, Minnesota, US | |
2022-10-02 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-03 04:23:11 | Unassigned, Minnesota, US | |
2022-10-01 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-02 04:21:23 | Unassigned, Minnesota, US | |
2022-09-30 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-01 04:23:01 | Unassigned, Minnesota, US | |
2022-09-30 | US | Arkansas | Saline | 5125 | 35006 | 366 | 0 | 34.64916145 | -92.67583224 | 2022-10-01 04:23:01 | Saline, Arkansas, US | |
2022-09-29 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-09-30 04:23:09 | Unassigned, Minnesota, US | |
2022-09-28 | US | Texas | Orange | 48361 | 16691 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-29 04:22:34 | Orange, Texas, US | |
2022-09-28 | Japan | Oita | 175258 | 366 | 0 | 33.200697 | 131.43324 | 2022-09-29 04:22:34 | Oita, Japan | |||
2022-09-27 | US | Texas | Orange | 48361 | 16691 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-28 04:23:01 | Orange, Texas, US | |
2022-09-27 | US | North Carolina | Durham | 37063 | 93903 | 366 | 0 | 36.03638492 | -78.87608331 | 2022-09-28 04:23:01 | Durham, North Carolina, US | |
2022-09-26 | US | Texas | Orange | 48361 | 16691 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-27 04:23:01 | Orange, Texas, US | |
2022-09-26 | US | North Carolina | Durham | 37063 | 93903 | 366 | 0 | 36.03638492 | -78.87608331 | 2022-09-27 04:23:01 | Durham, North Carolina, US | |
2022-09-25 | US | Texas | Orange | 48361 | 16682 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-26 04:20:52 | Orange, Texas, US | |
2022-09-25 | US | North Carolina | Durham | 37063 | 93903 | 366 | 0 | 36.03638492 | -78.87608331 | 2022-09-26 04:20:52 | Durham, North Carolina, US | |
2022-09-24 | US | Texas | Orange | 48361 | 16682 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-25 04:23:31 | Orange, Texas, US | |
2022-09-24 | US | North Carolina | Durham | 37063 | 93903 | 366 | 0 | 36.03638492 | -78.87608331 | 2022-09-25 04:23:31 | Durham, North Carolina, US | |
2022-09-23 | US | Texas | Orange | 48361 | 16682 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-24 04:21:40 | Orange, Texas, US | |
2022-09-23 | US | North Carolina | Durham | 37063 | 93903 | 366 | 0 | 36.03638492 | -78.87608331 | 2022-09-24 04:21:40 | Durham, North Carolina, US | |
2022-09-22 | US | Texas | Orange | 48361 | 16676 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-23 04:23:13 | Orange, Texas, US | |
2022-09-22 | US | Tennessee | Maury | 47119 | 33065 | 366 | 0 | 35.6187413 | -87.07462444 | 2022-09-23 04:23:13 | Maury, Tennessee, US | |
2022-09-22 | US | North Carolina | Durham | 37063 | 93903 | 366 | 0 | 36.03638492 | -78.87608331 | 2022-09-23 04:23:13 | Durham, North Carolina, US | |
2022-09-21 | US | Texas | Orange | 48361 | 16676 | 366 | 0 | 30.11879481 | -93.89412775 | 2022-09-22 04:22:56 | Orange, Texas, US | |
2022-09-21 | US | Tennessee | Maury | 47119 | 33056 | 366 | 0 | 35.6187413 | -87.07462444 | 2022-09-22 04:22:56 | Maury, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;