johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where confirmed = 15890 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 42
- Russia 2
- Azerbaijan 1
- Japan 1
- Mexico 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1372651 | 1372651 | 2022-09-21 | US | New Hampshire | Belknap | 33001 | 15890 | 191 | 0 | 43.51637314 | -71.41684235 | 2022-09-22 04:22:56 | Belknap, New Hampshire, US | |
2715937 | 2715937 | 2022-09-03 | US | Tennessee | Lawrence | 47099 | 15890 | 213 | 0 | 35.21675201 | -87.39787695 | 2022-09-04 04:21:22 | Lawrence, Tennessee, US | |
1877952 | 1877952 | 2022-08-28 | US | Illinois | Boone | 17007 | 15890 | 120 | 0 | 42.32359279 | -88.82345779 | 2022-08-29 04:21:06 | Boone, Illinois, US | |
2097079 | 2097079 | 2022-08-27 | US | Illinois | Boone | 17007 | 15890 | 120 | 0 | 42.32359279 | -88.82345779 | 2022-08-28 04:21:02 | Boone, Illinois, US | |
1532894 | 1532894 | 2022-08-26 | US | Illinois | Boone | 17007 | 15890 | 120 | 0 | 42.32359279 | -88.82345779 | 2022-08-27 04:20:57 | Boone, Illinois, US | |
1164592 | 1164592 | 2022-08-18 | US | Virginia | Washington | 51191 | 15890 | 223 | 0 | 36.72341572 | -81.95666289 | 2022-08-19 04:20:54 | Washington, Virginia, US | |
3584290 | 3584290 | 2022-05-17 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-18 04:20:50 | Isabella, Michigan, US | |
1505247 | 1505247 | 2022-05-16 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-17 04:20:59 | Isabella, Michigan, US | |
2085606 | 2085606 | 2022-05-15 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-16 04:20:47 | Isabella, Michigan, US | |
3356316 | 3356316 | 2022-05-14 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-15 04:20:53 | Isabella, Michigan, US | |
659961 | 659961 | 2022-05-13 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-14 04:20:48 | Isabella, Michigan, US | |
2535044 | 2535044 | 2022-05-12 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-13 04:20:51 | Isabella, Michigan, US | |
3446490 | 3446490 | 2022-05-11 | US | Michigan | Isabella | 26073 | 15890 | 211 | 0 | 43.64060976 | -84.84664923 | 2022-05-12 04:20:54 | Isabella, Michigan, US | |
3024500 | 3024500 | 2022-03-23 | US | New York | Cayuga | 36011 | 15890 | 144 | 0 | 42.91261714 | -76.55731592 | 2022-03-24 04:20:43 | Cayuga, New York, US | |
1907422 | 1907422 | 2022-03-22 | US | New York | Cayuga | 36011 | 15890 | 144 | 0 | 42.91261714 | -76.55731592 | 2022-03-23 04:20:48 | Cayuga, New York, US | |
26708 | 26708 | 2022-03-20 | US | North Carolina | Columbus | 37047 | 15890 | 266 | 0 | 34.26744084 | -78.65801424 | 2022-03-21 04:20:50 | Columbus, North Carolina, US | |
1658718 | 1658718 | 2022-03-19 | US | North Carolina | Columbus | 37047 | 15890 | 266 | 0 | 34.26744084 | -78.65801424 | 2022-03-20 04:20:45 | Columbus, North Carolina, US | |
338244 | 338244 | 2022-03-18 | US | North Carolina | Columbus | 37047 | 15890 | 266 | 0 | 34.26744084 | -78.65801424 | 2022-03-19 04:20:47 | Columbus, North Carolina, US | |
1060474 | 1060474 | 2022-02-23 | US | Oregon | Josephine | 41033 | 15890 | 313 | 0 | 42.3665549 | -123.5561938 | 2022-02-24 04:21:14 | Josephine, Oregon, US | |
2659799 | 2659799 | 2022-01-31 | US | Montana | Lewis and Clark | 30049 | 15890 | 163 | 0 | 47.12610041 | -112.39469799999999 | 2022-02-01 04:21:11 | Lewis and Clark, Montana, US | |
130074 | 130074 | 2022-01-09 | US | Virginia | Frederick | 51069 | 15890 | 185 | 0 | 39.20172582 | -78.25974949 | 2022-01-10 04:22:07 | Frederick, Virginia, US | |
1218909 | 1218909 | 2022-01-08 | US | Virginia | Frederick | 51069 | 15890 | 185 | 0 | 39.20172582 | -78.25974949 | 2022-01-09 04:21:46 | Frederick, Virginia, US | |
1215591 | 1215591 | 2022-01-08 | Japan | Tochigi | 15890 | 117 | 0 | 36.689912 | 139.819213 | 2022-01-09 04:21:46 | Tochigi, Japan | |||
1393002 | 1393002 | 2022-01-07 | US | Virginia | Frederick | 51069 | 15890 | 185 | 0 | 39.20172582 | -78.25974949 | 2022-01-08 04:21:53 | Frederick, Virginia, US | |
3402676 | 3402676 | 2021-11-30 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-12-01 04:22:29 | Pottawattamie, Iowa, US | |
151219 | 151219 | 2021-11-29 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-11-30 04:22:53 | Pottawattamie, Iowa, US | |
1232865 | 1232865 | 2021-11-28 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-11-29 04:22:30 | Pottawattamie, Iowa, US | |
1359572 | 1359572 | 2021-11-27 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-11-28 04:22:43 | Pottawattamie, Iowa, US | |
759563 | 759563 | 2021-11-26 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-11-27 04:22:45 | Pottawattamie, Iowa, US | |
1803980 | 1803980 | 2021-11-25 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-11-26 04:22:33 | Pottawattamie, Iowa, US | |
905414 | 905414 | 2021-11-24 | US | Iowa | Pottawattamie | 19155 | 15890 | 213 | 0 | 41.33640314 | -95.53907776 | 2021-11-25 04:22:33 | Pottawattamie, Iowa, US | |
3751286 | 3751286 | 2021-11-22 | US | New Hampshire | Merrimack | 33013 | 15890 | 143 | 0 | 43.29662971 | -71.6811573 | 2021-11-23 04:22:39 | Merrimack, New Hampshire, US | |
598160 | 598160 | 2021-10-19 | US | Arkansas | Garland | 5051 | 15890 | 382 | 0 | 34.57692074 | -93.14921604 | 2021-10-20 04:21:00 | Garland, Arkansas, US | |
2047393 | 2047393 | 2021-10-18 | US | Wisconsin | Eau Claire | 55035 | 15890 | 137 | 0 | 44.726614 | -91.28609183 | 2021-10-19 04:20:54 | Eau Claire, Wisconsin, US | |
334821 | 334821 | 2021-08-04 | US | Tennessee | Bradley | 47011 | 15890 | 155 | 0 | 35.15739424 | -84.857186 | 2021-08-05 04:21:51 | Bradley, Tennessee, US | |
2425803 | 2425803 | 2021-06-23 | US | Tennessee | Blount | 47009 | 15890 | 197 | 0 | 35.68938198 | -83.92847788 | 2021-06-24 04:21:55 | Blount, Tennessee, US | |
1799211 | 1799211 | 2021-03-23 | US | California | Santa Cruz | 6087 | 15890 | 201 | 0 | 37.05580291 | -122.0066524 | 2021-03-24 05:25:40 | Santa Cruz, California, US | |
55033 | 55033 | 2021-03-07 | Russia | North Ossetia - Alania Republic | 15890 | 157 | 14550 | 1183 | 42.79336110000001 | 44.6324493 | 2021-03-08 05:24:48 | North Ossetia - Alania Republic, Russia | ||
3067865 | 3067865 | 2021-02-27 | US | Missouri | Boone | 29019 | 15890 | 80 | 0 | 15810 | 38.99186229 | -92.30723575 | 2021-02-28 05:22:20 | Boone, Missouri, US |
1860975 | 1860975 | 2021-02-25 | US | Tennessee | Out of TN | 80047 | 15890 | 93 | 0 | 16672 | 36.55606529 | 0.0 | 2021-02-26 05:22:40 | Out of TN, Tennessee, US |
3541489 | 3541489 | 2021-02-12 | US | Montana | Yellowstone | 30111 | 15890 | 227 | 0 | 15663 | 45.93955949 | -108.2691486 | 2021-02-13 05:22:12 | Yellowstone, Montana, US |
1897376 | 1897376 | 2021-01-29 | Russia | Mordovia Republic | 15890 | 134 | 13327 | 2429 | 54.4419829 | 44.4661144 | 2021-01-30 05:22:49 | Mordovia Republic, Russia | ||
3517200 | 3517200 | 2021-01-15 | US | Mississippi | Hinds | 28049 | 15890 | 312 | 0 | 15578 | 32.2656285 | -90.44435448 | 2021-01-16 05:22:40 | Hinds, Mississippi, US |
3409529 | 3409529 | 2020-11-01 | Mexico | Hidalgo | 15890 | 2291 | 12653 | 946 | 20.0911 | -98.7624 | 2020-11-02 05:25:04 | Hidalgo, Mexico | ||
764768 | 764768 | 2020-10-18 | US | Ohio | Hamilton | 39061 | 15890 | 305 | 0 | 15585 | 39.19673558 | -84.54502924 | 2020-10-19 04:24:16 | Hamilton, Ohio, US |
415609 | 415609 | 2020-07-05 | United Kingdom | Wales | 15890 | 2502 | 0 | 14359 | 52.1307 | -3.7837 | 2020-07-06 04:33:57 | Wales, United Kingdom | ||
2040098 | 2040098 | 2020-06-27 | Azerbaijan | 15890 | 193 | 8719 | 6978 | 40.1431 | 47.5769 | 2020-06-28 04:34:04 | Azerbaijan | |||
2547189 | 2547189 | 2020-05-27 | US | New Jersey | Passaic | 34031 | 15890 | 899 | 0 | 14991 | 41.03238628 | -74.29954144 | 2020-05-28 02:32:31 | Passaic, New Jersey, 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]);