johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where confirmed = 15815 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 28
- Russia 3
- United Kingdom 2
- Colombia 1
- Mexico 1
- Netherlands 1
- Syria 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2355951 | 2355951 | 2022-09-16 | US | Arkansas | Crittenden | 5035 | 15815 | 234 | 0 | 35.21247318 | -90.30839406 | 2022-09-17 04:20:19 | Crittenden, Arkansas, US | |
1891657 | 1891657 | 2022-09-14 | US | Ohio | Sandusky | 39143 | 15815 | 253 | 0 | 41.35624126 | -83.137872 | 2022-09-15 04:21:02 | Sandusky, Ohio, US | |
374712 | 374712 | 2022-09-13 | US | Ohio | Sandusky | 39143 | 15815 | 253 | 0 | 41.35624126 | -83.137872 | 2022-09-14 04:20:44 | Sandusky, Ohio, US | |
2397314 | 2397314 | 2022-09-12 | US | Ohio | Sandusky | 39143 | 15815 | 253 | 0 | 41.35624126 | -83.137872 | 2022-09-13 04:20:57 | Sandusky, Ohio, US | |
3768392 | 3768392 | 2022-09-11 | US | Ohio | Sandusky | 39143 | 15815 | 252 | 0 | 41.35624126 | -83.137872 | 2022-09-12 04:20:58 | Sandusky, Ohio, US | |
3826967 | 3826967 | 2022-09-10 | US | Ohio | Sandusky | 39143 | 15815 | 252 | 0 | 41.35624126 | -83.137872 | 2022-09-11 04:20:50 | Sandusky, Ohio, US | |
965424 | 965424 | 2022-09-09 | US | Ohio | Sandusky | 39143 | 15815 | 252 | 0 | 41.35624126 | -83.137872 | 2022-09-10 04:21:10 | Sandusky, Ohio, US | |
255826 | 255826 | 2022-09-08 | US | Ohio | Sandusky | 39143 | 15815 | 252 | 0 | 41.35624126 | -83.137872 | 2022-09-09 04:21:11 | Sandusky, Ohio, US | |
1490626 | 1490626 | 2022-07-26 | US | Texas | Caldwell | 48055 | 15815 | 179 | 0 | 29.83668859 | -97.61814775 | 2022-07-27 04:21:04 | Caldwell, Texas, US | |
3357796 | 3357796 | 2022-05-14 | US | Texas | Hunt | 48231 | 15815 | 363 | 0 | 33.12351514 | -96.08551032 | 2022-05-15 04:20:53 | Hunt, Texas, US | |
2478450 | 2478450 | 2022-03-30 | US | Arkansas | Crawford | 5033 | 15815 | 247 | 0 | 35.58928601 | -94.2446814 | 2022-03-31 04:20:56 | Crawford, Arkansas, US | |
1296807 | 1296807 | 2022-02-05 | US | Puerto Rico | Ponce | 72113 | 15815 | 0 | 0 | 18.059498 | -66.613748 | 2022-02-06 04:21:00 | Ponce, Puerto Rico, US | |
459828 | 459828 | 2022-02-02 | US | Arizona | Gila | 4007 | 15815 | 341 | 0 | 33.80190085 | -110.8132779 | 2022-02-03 04:21:21 | Gila, Arizona, US | |
1392097 | 1392097 | 2022-01-07 | US | North Dakota | Ward | 38101 | 15815 | 235 | 0 | 48.22390169 | -101.54367629999999 | 2022-01-08 04:21:53 | Ward, North Dakota, US | |
1703338 | 1703338 | 2022-01-03 | US | Tennessee | Robertson | 47147 | 15815 | 234 | 0 | 36.52454807 | -86.87346725 | 2022-01-04 04:22:17 | Robertson, Tennessee, US | |
686726 | 686726 | 2021-11-13 | US | Alabama | Elmore | 1051 | 15815 | 294 | 0 | 32.59785413 | -86.14415284 | 2021-11-14 04:21:31 | Elmore, Alabama, US | |
3794013 | 3794013 | 2021-10-25 | Netherlands | Aruba | 15815 | 171 | 0 | 12.5211 | -69.9683 | 2021-10-26 04:22:09 | Aruba, Netherlands | |||
2901350 | 2901350 | 2021-08-12 | US | Michigan | Monroe | 26115 | 15815 | 267 | 0 | 41.92734151 | -83.53749864 | 2021-08-13 04:21:24 | Monroe, Michigan, US | |
2899541 | 2899541 | 2021-08-12 | Colombia | Putumayo | 15815 | 646 | 0 | 0.436 | -75.5277 | 2021-08-13 04:21:24 | Putumayo, Colombia | |||
1343954 | 1343954 | 2021-08-11 | US | Michigan | Monroe | 26115 | 15815 | 267 | 0 | 41.92734151 | -83.53749864 | 2021-08-12 04:21:25 | Monroe, Michigan, US | |
334574 | 334574 | 2021-08-04 | US | Pennsylvania | Franklin | 42055 | 15815 | 377 | 0 | 39.92956518 | -77.72157791 | 2021-08-05 04:21:51 | Franklin, Pennsylvania, US | |
3476495 | 3476495 | 2021-07-22 | Russia | Adygea Republic | 15815 | 283 | 14805 | 727 | 44.6939006 | 40.1520421 | 2021-07-23 04:21:29 | Adygea Republic, Russia | ||
2676018 | 2676018 | 2021-07-18 | US | New Mexico | San Juan | 35045 | 15815 | 501 | 0 | 36.50838318 | -108.320437 | 2021-07-19 04:21:24 | San Juan, New Mexico, US | |
3708330 | 3708330 | 2021-07-17 | US | New Mexico | San Juan | 35045 | 15815 | 501 | 0 | 36.50838318 | -108.320437 | 2021-07-18 04:22:07 | San Juan, New Mexico, US | |
2949561 | 2949561 | 2021-07-16 | US | New Mexico | San Juan | 35045 | 15815 | 501 | 0 | 36.50838318 | -108.320437 | 2021-07-17 04:22:22 | San Juan, New Mexico, US | |
2886010 | 2886010 | 2021-06-20 | US | Michigan | Jackson | 26075 | 15815 | 290 | 0 | 42.24807035 | -84.42258681 | 2021-06-21 04:21:41 | Jackson, Michigan, US | |
109093 | 109093 | 2021-06-19 | US | Michigan | Jackson | 26075 | 15815 | 290 | 0 | 42.24807035 | -84.42258681 | 2021-06-20 04:21:48 | Jackson, Michigan, US | |
1127236 | 1127236 | 2021-06-18 | US | Michigan | Jackson | 26075 | 15815 | 290 | 0 | 42.24807035 | -84.42258681 | 2021-06-19 04:22:33 | Jackson, Michigan, US | |
2825039 | 2825039 | 2021-05-01 | Russia | Tyva Republic | 15815 | 202 | 15446 | 167 | 51.4017149 | 93.8582593 | 2021-05-02 04:20:48 | Tyva Republic, Russia | ||
2207982 | 2207982 | 2021-03-04 | Syria | 15815 | 1050 | 10123 | 4642 | 34.802075 | 38.99681500000001 | 2021-03-05 05:26:29 | Syria | |||
977918 | 977918 | 2021-02-06 | US | Tennessee | Wilson | 47189 | 15815 | 191 | 0 | 15367 | 36.15496772 | -86.29775884 | 2021-02-07 05:23:00 | Wilson, Tennessee, US |
2223702 | 2223702 | 2020-12-26 | Russia | Chuvashia Republic | 15815 | 475 | 14156 | 1184 | 55.4259922 | 47.0849429 | 2020-12-27 05:22:55 | Chuvashia Republic, Russia | ||
822625 | 822625 | 2020-11-19 | US | Indiana | Allen | 18003 | 15815 | 289 | 0 | 15526 | 41.09194313 | -85.06800636 | 2020-11-20 05:26:28 | Allen, Indiana, US |
839104 | 839104 | 2020-08-17 | US | Louisiana | Jefferson | 22051 | 15815 | 531 | 0 | 15284 | 29.74075478 | -90.11115756 | 2020-08-18 04:27:56 | Jefferson, Louisiana, US |
3205414 | 3205414 | 2020-07-18 | Mexico | Puebla | 15815 | 1965 | 12974 | 876 | 19.0414 | -98.2063 | 2020-07-19 04:34:58 | Puebla, Mexico | ||
3045627 | 3045627 | 2020-07-02 | United Kingdom | Wales | 15815 | 2494 | 0 | 14291 | 52.1307 | -3.7837 | 2020-07-03 04:33:54 | Wales, United Kingdom | ||
2306643 | 2306643 | 2020-06-28 | United Kingdom | Scotland | 15815 | 4172 | 0 | 13333 | 56.4907 | -4.2026 | 2020-06-29 04:33:44 | Scotland, United Kingdom |
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]);