johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 22387 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954888 | 2954888 | 2022-12-20 | US | West Virginia | Mercer | 54055 | 22387 | 283 | 0 | 37.40481169 | -81.11023142 | 2022-12-21 04:21:03 | Mercer, West Virginia, US | |
2417036 | 2417036 | 2022-12-05 | US | New Hampshire | Grafton | 33009 | 22387 | 86 | 0 | 43.93779815 | -71.82057197 | 2022-12-06 04:21:03 | Grafton, New Hampshire, US | |
541240 | 541240 | 2022-10-26 | US | Ohio | Lawrence | 39087 | 22387 | 284 | 0 | 38.59743452 | -82.53466552 | 2022-10-27 04:22:01 | Lawrence, Ohio, US | |
1832641 | 1832641 | 2022-10-25 | US | Ohio | Lawrence | 39087 | 22387 | 283 | 0 | 38.59743452 | -82.53466552 | 2022-10-26 04:22:19 | Lawrence, Ohio, US | |
796902 | 796902 | 2022-10-24 | US | Ohio | Lawrence | 39087 | 22387 | 283 | 0 | 38.59743452 | -82.53466552 | 2022-10-25 04:21:53 | Lawrence, Ohio, US | |
3279357 | 3279357 | 2022-10-23 | US | Ohio | Lawrence | 39087 | 22387 | 283 | 0 | 38.59743452 | -82.53466552 | 2022-10-24 04:22:29 | Lawrence, Ohio, US | |
2270395 | 2270395 | 2022-10-22 | US | Ohio | Lawrence | 39087 | 22387 | 283 | 0 | 38.59743452 | -82.53466552 | 2022-10-23 04:22:46 | Lawrence, Ohio, US | |
1594695 | 1594695 | 2022-10-21 | US | Ohio | Lawrence | 39087 | 22387 | 283 | 0 | 38.59743452 | -82.53466552 | 2022-10-22 04:22:53 | Lawrence, Ohio, US | |
2274411 | 2274411 | 2022-10-20 | US | Ohio | Lawrence | 39087 | 22387 | 283 | 0 | 38.59743452 | -82.53466552 | 2022-10-21 04:22:23 | Lawrence, Ohio, US | |
2987793 | 2987793 | 2022-09-04 | US | Arkansas | Lonoke | 5085 | 22387 | 256 | 0 | 34.75392199 | -91.88742357 | 2022-09-05 04:21:01 | Lonoke, Arkansas, US | |
3723163 | 3723163 | 2022-04-25 | US | Illinois | Adams | 17001 | 22387 | 209 | 0 | 39.98815591 | -91.18786813 | 2022-04-26 04:20:51 | Adams, Illinois, US | |
3821248 | 3821248 | 2022-02-16 | US | Georgia | Glynn | 13127 | 22387 | 379 | 0 | 31.23279254 | -81.53811412 | 2022-02-17 04:20:56 | Glynn, Georgia, US | |
567629 | 567629 | 2021-10-29 | US | Arkansas | Sebastian | 5131 | 22387 | 377 | 0 | 35.19605503 | -94.27162713 | 2021-10-30 04:22:03 | Sebastian, Arkansas, US | |
2315262 | 2315262 | 2021-06-04 | India | Nagaland | 22387 | 416 | 17276 | 4695 | 26.06702 | 94.470302 | 2021-06-05 04:23:03 | Nagaland, India | ||
1915835 | 1915835 | 2021-05-20 | US | Oregon | Marion | 41047 | 22387 | 310 | 0 | 44.90287942 | -122.5815117 | 2021-05-21 04:20:43 | Marion, Oregon, US | |
2256872 | 2256872 | 2021-05-19 | US | Indiana | Vanderburgh | 18163 | 22387 | 397 | 0 | 38.02658833 | -87.58763124 | 2021-05-20 04:21:05 | Vanderburgh, Indiana, US | |
2360368 | 2360368 | 2021-03-08 | US | Hawaii | Honolulu | 15003 | 22387 | 353 | 0 | 21.45803166 | -157.97121819999995 | 2021-03-09 05:28:19 | Honolulu, Hawaii, US | |
1000662 | 1000662 | 2021-03-01 | US | New York | Dutchess | 36027 | 22387 | 408 | 0 | 21979 | 41.76486060000001 | -73.74356679 | 2021-03-02 05:23:30 | Dutchess, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);