johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where confirmed = 15392 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1419330 | 1419330 | 2022-07-08 | US | New York | Herkimer | 36043 | 15392 | 197 | 0 | 43.42034246 | -74.96145307 | 2022-07-09 04:20:59 | Herkimer, New York, US | |
466514 | 466514 | 2022-05-02 | US | Texas | Henderson | 48213 | 15392 | 424 | 0 | 32.21128872 | -95.85846587 | 2022-05-03 04:21:00 | Henderson, Texas, US | |
3919153 | 3919153 | 2022-05-01 | US | Texas | Henderson | 48213 | 15392 | 424 | 0 | 32.21128872 | -95.85846587 | 2022-05-02 04:21:10 | Henderson, Texas, US | |
1846597 | 1846597 | 2022-04-18 | US | Colorado | Garfield | 8045 | 15392 | 92 | 0 | 39.59921777 | -107.902708 | 2022-04-19 04:21:00 | Garfield, Colorado, US | |
2478860 | 2478860 | 2022-03-30 | US | Georgia | Troup | 13285 | 15392 | 374 | 0 | 33.03349196 | -85.02812115 | 2022-03-31 04:20:56 | Troup, Georgia, US | |
3721073 | 3721073 | 2022-02-21 | US | South Dakota | Lincoln | 46083 | 15392 | 97 | 0 | 43.27841182 | -96.72039050000001 | 2022-02-22 04:21:01 | Lincoln, South Dakota, US | |
3914907 | 3914907 | 2022-02-20 | US | South Dakota | Lincoln | 46083 | 15392 | 97 | 0 | 43.27841182 | -96.72039050000001 | 2022-02-21 04:21:05 | Lincoln, South Dakota, US | |
3878465 | 3878465 | 2022-02-19 | US | South Dakota | Lincoln | 46083 | 15392 | 97 | 0 | 43.27841182 | -96.72039050000001 | 2022-02-20 04:21:00 | Lincoln, South Dakota, US | |
3858721 | 3858721 | 2022-02-18 | US | South Dakota | Lincoln | 46083 | 15392 | 97 | 0 | 43.27841182 | -96.72039050000001 | 2022-02-19 04:21:11 | Lincoln, South Dakota, US | |
2013580 | 2013580 | 2022-02-06 | US | Georgia | Spalding | 13255 | 15392 | 366 | 0 | 33.26310031 | -84.28013991 | 2022-02-07 04:21:05 | Spalding, Georgia, US | |
1294909 | 1294909 | 2022-02-05 | US | Georgia | Spalding | 13255 | 15392 | 366 | 0 | 33.26310031 | -84.28013991 | 2022-02-06 04:21:00 | Spalding, Georgia, US | |
2328237 | 2328237 | 2022-02-04 | US | Georgia | Spalding | 13255 | 15392 | 366 | 0 | 33.26310031 | -84.28013991 | 2022-02-05 04:21:05 | Spalding, Georgia, US | |
3639567 | 3639567 | 2021-11-08 | Japan | Okayama | 15392 | 136 | 0 | 34.89246 | 133.826252 | 2021-11-09 04:21:36 | Okayama, Japan | |||
1491625 | 1491625 | 2021-10-12 | Japan | Tochigi | 15392 | 116 | 0 | 36.689912 | 139.819213 | 2021-10-13 04:20:51 | Tochigi, Japan | |||
2175724 | 2175724 | 2021-08-22 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-23 04:21:27 | Pasco, Peru | |||
3555820 | 3555820 | 2021-08-21 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-22 04:21:29 | Pasco, Peru | |||
1854162 | 1854162 | 2021-08-20 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-21 04:21:38 | Pasco, Peru | |||
511869 | 511869 | 2021-08-19 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-20 04:21:33 | Pasco, Peru | |||
2518348 | 2518348 | 2021-08-18 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-19 04:21:15 | Pasco, Peru | |||
245440 | 245440 | 2021-08-17 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-18 04:21:35 | Pasco, Peru | |||
1604403 | 1604403 | 2021-08-16 | Peru | Pasco | 15392 | 1024 | 0 | -10.39655 | -75.307635 | 2021-08-17 04:21:49 | Pasco, Peru | |||
2676728 | 2676728 | 2021-07-18 | US | Tennessee | Bradley | 47011 | 15392 | 153 | 0 | 35.15739424 | -84.857186 | 2021-07-19 04:21:24 | Bradley, Tennessee, US | |
2426083 | 2426083 | 2021-06-23 | US | Texas | Potter | 48375 | 15392 | 458 | 0 | 35.40133773 | -101.893964 | 2021-06-24 04:21:55 | Potter, Texas, US | |
3383036 | 3383036 | 2021-06-13 | US | Michigan | Monroe | 26115 | 15392 | 261 | 0 | 41.92734151 | -83.53749864 | 2021-06-14 04:22:46 | Monroe, Michigan, US | |
1738170 | 1738170 | 2021-06-12 | US | Michigan | Monroe | 26115 | 15392 | 261 | 0 | 41.92734151 | -83.53749864 | 2021-06-13 04:22:44 | Monroe, Michigan, US | |
890504 | 890504 | 2021-04-26 | US | North Dakota | Burleigh | 38015 | 15392 | 190 | 0 | 46.97847375 | -100.4645214 | 2021-04-27 04:20:52 | Burleigh, North Dakota, US | |
2986027 | 2986027 | 2021-04-10 | US | Puerto Rico | San Juan | 72127 | 15392 | 0 | 0 | 18.386933 | -66.061128 | 2021-04-11 04:20:56 | San Juan, Puerto Rico, US | |
388972 | 388972 | 2021-04-04 | US | Georgia | Bibb | 13021 | 15392 | 424 | 0 | 32.80904227 | -83.70489165 | 2021-04-05 04:20:35 | Bibb, Georgia, US | |
3104985 | 3104985 | 2021-01-16 | US | Wisconsin | Kenosha | 55059 | 15392 | 259 | 0 | 15133 | 42.57639354 | -88.04051686 | 2021-01-17 05:22:17 | Kenosha, Wisconsin, US |
2226917 | 2226917 | 2020-12-26 | US | Virginia | Virginia Beach | 51810 | 15392 | 141 | 0 | 15251 | 36.73285734 | -76.04566934 | 2020-12-27 05:22:55 | Virginia Beach, Virginia, US |
2119810 | 2119810 | 2020-12-20 | Mexico | Quintana Roo | 15392 | 1997 | 0 | 13395 | 19.1817 | -88.4791 | 2020-12-21 05:27:58 | Quintana Roo, Mexico | ||
1632224 | 1632224 | 2020-12-05 | Germany | Schleswig-Holstein | 15392 | 264 | 12462 | 2901 | 54.2194 | 9.6961 | 2020-12-06 05:26:18 | Schleswig-Holstein, Germany | ||
2922763 | 2922763 | 2020-11-04 | US | Wisconsin | Waukesha | 55133 | 15392 | 133 | 0 | 15259 | 43.01833055 | -88.30431188 | 2020-11-05 06:05:03 | Waukesha, Wisconsin, US |
1026621 | 1026621 | 2020-10-17 | Senegal | 15392 | 317 | 13756 | 1319 | 14.4974 | -14.4524 | 2020-10-18 04:24:25 | Senegal | |||
367495 | 367495 | 2020-07-16 | India | Odisha | 15392 | 79 | 10877 | 4436 | 20.505428 | 84.418059 | 2020-07-17 04:34:50 | Odisha, India |
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]);