daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
621 rows where deaths = 506 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Tennessee | Blount | 47009 | 47336 | 506 | 0 | 35.68938198 | -83.92847788 | 2022-12-30 04:21:04 | Blount, Tennessee, US | |
2022-12-29 | US | Illinois | Tazewell | 17179 | 45157 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-30 04:21:04 | Tazewell, Illinois, US | |
2022-12-28 | US | Tennessee | Blount | 47009 | 47336 | 506 | 0 | 35.68938198 | -83.92847788 | 2022-12-29 04:21:01 | Blount, Tennessee, US | |
2022-12-28 | US | Illinois | Tazewell | 17179 | 45117 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-29 04:21:01 | Tazewell, Illinois, US | |
2022-12-27 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-28 04:21:04 | Randall, Texas, US | |
2022-12-27 | US | Illinois | Tazewell | 17179 | 45093 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-28 04:21:04 | Tazewell, Illinois, US | |
2022-12-26 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-27 04:21:07 | Randall, Texas, US | |
2022-12-26 | US | Illinois | Tazewell | 17179 | 45038 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-27 04:21:07 | Tazewell, Illinois, US | |
2022-12-25 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-26 04:21:06 | Randall, Texas, US | |
2022-12-25 | US | Illinois | Tazewell | 17179 | 45038 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-26 04:21:06 | Tazewell, Illinois, US | |
2022-12-24 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-25 04:21:04 | Randall, Texas, US | |
2022-12-24 | US | Illinois | Tazewell | 17179 | 45038 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-25 04:21:04 | Tazewell, Illinois, US | |
2022-12-24 | Japan | Aomori | 243287 | 506 | 0 | 40.781541 | 140.828896 | 2022-12-25 04:21:04 | Aomori, Japan | |||
2022-12-23 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-24 04:21:02 | Randall, Texas, US | |
2022-12-23 | US | Illinois | Tazewell | 17179 | 45038 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-24 04:21:02 | Tazewell, Illinois, US | |
2022-12-22 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-23 04:21:04 | Randall, Texas, US | |
2022-12-22 | US | Illinois | Tazewell | 17179 | 44977 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-23 04:21:04 | Tazewell, Illinois, US | |
2022-12-21 | US | Texas | Randall | 48381 | 29410 | 506 | 0 | 34.96585996 | -101.8971322 | 2022-12-22 04:20:56 | Randall, Texas, US | |
2022-12-21 | US | Illinois | Tazewell | 17179 | 44946 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-22 04:20:56 | Tazewell, Illinois, US | |
2022-12-20 | US | Illinois | Tazewell | 17179 | 44895 | 506 | 0 | 40.50716185 | -89.51404662 | 2022-12-21 04:21:03 | Tazewell, Illinois, US | |
2022-12-08 | US | Illinois | Rock Island | 17161 | 40788 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-09 04:21:05 | Rock Island, Illinois, US | |
2022-12-07 | US | Illinois | Rock Island | 17161 | 40755 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-08 04:21:07 | Rock Island, Illinois, US | |
2022-12-06 | US | Illinois | Rock Island | 17161 | 40724 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-07 04:20:58 | Rock Island, Illinois, US | |
2022-12-05 | US | Illinois | Rock Island | 17161 | 40683 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-06 04:21:03 | Rock Island, Illinois, US | |
2022-12-04 | US | Illinois | Rock Island | 17161 | 40623 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-05 04:20:58 | Rock Island, Illinois, US | |
2022-12-03 | US | Illinois | Rock Island | 17161 | 40623 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-04 04:20:56 | Rock Island, Illinois, US | |
2022-12-02 | US | Illinois | Rock Island | 17161 | 40623 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-03 04:21:02 | Rock Island, Illinois, US | |
2022-12-01 | US | Illinois | Rock Island | 17161 | 40583 | 506 | 0 | 41.46613806 | -90.57042164 | 2022-12-02 04:21:07 | Rock Island, Illinois, US | |
2022-11-29 | US | Illinois | McHenry | 17111 | 93678 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-30 04:21:07 | McHenry, Illinois, US | |
2022-11-28 | US | Illinois | McHenry | 17111 | 93636 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-29 04:21:05 | McHenry, Illinois, US | |
2022-11-27 | US | Illinois | McHenry | 17111 | 93411 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-28 04:21:02 | McHenry, Illinois, US | |
2022-11-27 | Japan | Miyagi | 351996 | 506 | 0 | 38.446859 | 140.927086 | 2022-11-28 04:21:02 | Miyagi, Japan | |||
2022-11-26 | US | Illinois | McHenry | 17111 | 93411 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-27 04:21:05 | McHenry, Illinois, US | |
2022-11-25 | US | Illinois | McHenry | 17111 | 93411 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-26 04:21:11 | McHenry, Illinois, US | |
2022-11-24 | US | Illinois | McHenry | 17111 | 93411 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-25 04:21:06 | McHenry, Illinois, US | |
2022-11-23 | US | Illinois | McHenry | 17111 | 93411 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-24 04:21:09 | McHenry, Illinois, US | |
2022-11-22 | US | Illinois | McHenry | 17111 | 93360 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-23 04:21:06 | McHenry, Illinois, US | |
2022-11-21 | US | Illinois | McHenry | 17111 | 93308 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-22 04:20:47 | McHenry, Illinois, US | |
2022-11-20 | US | Illinois | McHenry | 17111 | 93171 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-21 04:21:05 | McHenry, Illinois, US | |
2022-11-19 | US | Illinois | McHenry | 17111 | 93171 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-20 04:21:08 | McHenry, Illinois, US | |
2022-11-18 | US | Illinois | McHenry | 17111 | 93171 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-19 04:21:14 | McHenry, Illinois, US | |
2022-11-17 | US | Illinois | McHenry | 17111 | 93128 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-18 04:21:15 | McHenry, Illinois, US | |
2022-11-16 | US | Illinois | McHenry | 17111 | 93048 | 506 | 0 | 42.32451172 | -88.45248227 | 2022-11-17 04:21:11 | McHenry, Illinois, US | |
2022-10-25 | Japan | Gunma | 250259 | 506 | 0 | 36.504479 | 138.985605 | 2022-10-26 04:22:19 | Gunma, Japan | |||
2022-10-13 | US | Virginia | Norfolk | 51710 | 50353 | 506 | 0 | 36.89934014 | -76.26420872 | 2022-10-14 04:22:28 | Norfolk, Virginia, US | |
2022-10-10 | US | New Jersey | Sussex | 34037 | 41462 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-11 04:23:05 | Sussex, New Jersey, US | |
2022-10-09 | US | New Jersey | Sussex | 34037 | 41434 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-10 04:22:32 | Sussex, New Jersey, US | |
2022-10-08 | US | New Jersey | Sussex | 34037 | 41406 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-09 04:21:16 | Sussex, New Jersey, US | |
2022-10-07 | US | New Jersey | Sussex | 34037 | 41359 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-08 04:22:56 | Sussex, New Jersey, US | |
2022-10-06 | US | New Jersey | Sussex | 34037 | 41322 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-07 04:23:08 | Sussex, New Jersey, US | |
2022-10-05 | US | New Jersey | Sussex | 34037 | 41263 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-06 04:21:22 | Sussex, New Jersey, US | |
2022-10-04 | US | New Jersey | Sussex | 34037 | 41225 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-05 04:23:06 | Sussex, New Jersey, US | |
2022-10-03 | US | New Jersey | Sussex | 34037 | 41189 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-04 04:22:55 | Sussex, New Jersey, US | |
2022-10-03 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-10-04 04:22:55 | Monroe, Michigan, US | |
2022-10-02 | US | New Jersey | Sussex | 34037 | 41165 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-03 04:23:11 | Sussex, New Jersey, US | |
2022-10-02 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-10-03 04:23:11 | Monroe, Michigan, US | |
2022-10-01 | US | New Jersey | Sussex | 34037 | 41144 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-02 04:21:23 | Sussex, New Jersey, US | |
2022-10-01 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-10-02 04:21:23 | Monroe, Michigan, US | |
2022-09-30 | US | New Jersey | Sussex | 34037 | 41103 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-10-01 04:23:01 | Sussex, New Jersey, US | |
2022-09-30 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-10-01 04:23:01 | Monroe, Michigan, US | |
2022-09-29 | US | New Jersey | Sussex | 34037 | 41063 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-09-30 04:23:09 | Sussex, New Jersey, US | |
2022-09-29 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-30 04:23:09 | Monroe, Michigan, US | |
2022-09-28 | US | New Jersey | Sussex | 34037 | 41014 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-09-29 04:22:34 | Sussex, New Jersey, US | |
2022-09-28 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-29 04:22:34 | Monroe, Michigan, US | |
2022-09-27 | US | Michigan | Monroe | 26115 | 44825 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-28 04:23:01 | Monroe, Michigan, US | |
2022-09-26 | US | New York | Out of NY | 80036 | 0 | 506 | 0 | 44.74530905 | 0.0 | 2022-09-27 04:23:01 | Out of NY, New York, US | |
2022-09-26 | US | New Jersey | Sussex | 34037 | 40943 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-09-27 04:23:01 | Sussex, New Jersey, US | |
2022-09-26 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-27 04:23:01 | Monroe, Michigan, US | |
2022-09-25 | US | New York | Out of NY | 80036 | 0 | 506 | 0 | 44.74530905 | 0.0 | 2022-09-26 04:20:52 | Out of NY, New York, US | |
2022-09-25 | US | New Jersey | Sussex | 34037 | 40924 | 506 | 0 | 41.13891592 | -74.69118243 | 2022-09-26 04:20:52 | Sussex, New Jersey, US | |
2022-09-25 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-26 04:20:52 | Monroe, Michigan, US | |
2022-09-24 | US | New York | Out of NY | 80036 | 0 | 506 | 0 | 44.74530905 | 0.0 | 2022-09-25 04:23:31 | Out of NY, New York, US | |
2022-09-24 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-25 04:23:31 | Monroe, Michigan, US | |
2022-09-23 | US | New York | Out of NY | 80036 | 0 | 506 | 0 | 44.74530905 | 0.0 | 2022-09-24 04:21:40 | Out of NY, New York, US | |
2022-09-23 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-24 04:21:40 | Monroe, Michigan, US | |
2022-09-22 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-23 04:23:13 | Monroe, Michigan, US | |
2022-09-21 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-22 04:22:56 | Monroe, Michigan, US | |
2022-09-20 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-21 04:23:22 | Iredell, North Carolina, US | |
2022-09-20 | US | Michigan | Monroe | 26115 | 44523 | 506 | 0 | 41.92734151 | -83.53749864 | 2022-09-21 04:23:22 | Monroe, Michigan, US | |
2022-09-19 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-20 04:22:48 | Iredell, North Carolina, US | |
2022-09-18 | US | Washington | Benton | 53005 | 59295 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-19 04:21:49 | Benton, Washington, US | |
2022-09-18 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-19 04:21:49 | Iredell, North Carolina, US | |
2022-09-17 | US | Washington | Benton | 53005 | 59295 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-18 04:22:50 | Benton, Washington, US | |
2022-09-17 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-18 04:22:50 | Iredell, North Carolina, US | |
2022-09-16 | US | Washington | Benton | 53005 | 59295 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-17 04:20:19 | Benton, Washington, US | |
2022-09-16 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-17 04:20:19 | Iredell, North Carolina, US | |
2022-09-16 | Japan | Mie | 241853 | 506 | 0 | 34.508018 | 136.376013 | 2022-09-17 04:20:19 | Mie, Japan | |||
2022-09-15 | US | Washington | Benton | 53005 | 59121 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-16 04:21:19 | Benton, Washington, US | |
2022-09-15 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-16 04:21:19 | Iredell, North Carolina, US | |
2022-09-14 | US | Washington | Benton | 53005 | 59121 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-15 04:21:02 | Benton, Washington, US | |
2022-09-14 | US | North Carolina | Iredell | 37097 | 56345 | 506 | 0 | 35.80950511 | -80.8743128 | 2022-09-15 04:21:02 | Iredell, North Carolina, US | |
2022-09-13 | US | Washington | Benton | 53005 | 59121 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-14 04:20:44 | Benton, Washington, US | |
2022-09-12 | US | Washington | Benton | 53005 | 59121 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-13 04:20:57 | Benton, Washington, US | |
2022-09-08 | US | Washington | Benton | 53005 | 58971 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-09 04:21:11 | Benton, Washington, US | |
2022-09-07 | US | Washington | Benton | 53005 | 58971 | 506 | 0 | 46.23946995 | -119.5120834 | 2022-09-08 04:21:02 | Benton, Washington, US | |
2022-09-06 | US | Georgia | Coweta | 13077 | 38152 | 506 | 0 | 33.35334302 | -84.76129976 | 2022-09-07 04:20:59 | Coweta, Georgia, US | |
2022-09-05 | US | Georgia | Coweta | 13077 | 38152 | 506 | 0 | 33.35334302 | -84.76129976 | 2022-09-06 04:21:02 | Coweta, Georgia, US | |
2022-09-04 | US | Georgia | Coweta | 13077 | 38152 | 506 | 0 | 33.35334302 | -84.76129976 | 2022-09-05 04:21:01 | Coweta, Georgia, US | |
2022-09-03 | US | Georgia | Coweta | 13077 | 38152 | 506 | 0 | 33.35334302 | -84.76129976 | 2022-09-04 04:21:22 | Coweta, Georgia, US | |
2022-09-02 | US | Georgia | Coweta | 13077 | 38152 | 506 | 0 | 33.35334302 | -84.76129976 | 2022-09-03 04:21:04 | Coweta, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;