johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where confirmed = 15511 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
596575 | 596575 | 2022-07-01 | US | Tennessee | Bedford | 47003 | 15511 | 239 | 0 | 35.51123746 | -86.45549096 | 2022-07-02 04:21:16 | Bedford, Tennessee, US | |
3509209 | 3509209 | 2022-06-05 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-06-06 04:20:57 | Lafayette, Mississippi, US | |
3529286 | 3529286 | 2022-06-04 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-06-05 04:20:55 | Lafayette, Mississippi, US | |
3135372 | 3135372 | 2022-06-03 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-06-04 04:20:58 | Lafayette, Mississippi, US | |
3580447 | 3580447 | 2022-06-02 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-06-03 04:20:58 | Lafayette, Mississippi, US | |
972740 | 972740 | 2022-06-01 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-06-02 05:20:39 | Lafayette, Mississippi, US | |
231047 | 231047 | 2022-05-31 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-06-01 04:20:55 | Lafayette, Mississippi, US | |
3187812 | 3187812 | 2022-05-30 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-31 04:20:51 | Lafayette, Mississippi, US | |
3199961 | 3199961 | 2022-05-29 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-30 04:20:50 | Lafayette, Mississippi, US | |
2726839 | 2726839 | 2022-05-28 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-29 04:20:53 | Lafayette, Mississippi, US | |
1316020 | 1316020 | 2022-05-27 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-28 04:21:07 | Lafayette, Mississippi, US | |
1851812 | 1851812 | 2022-05-26 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-27 04:20:56 | Lafayette, Mississippi, US | |
2049688 | 2049688 | 2022-05-25 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-26 04:20:50 | Lafayette, Mississippi, US | |
3001126 | 3001126 | 2022-05-24 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-25 04:20:56 | Lafayette, Mississippi, US | |
3595747 | 3595747 | 2022-05-23 | US | Puerto Rico | Arecibo | 72013 | 15511 | 0 | 0 | 18.406631 | -66.675077 | 2022-05-24 04:20:57 | Arecibo, Puerto Rico, US | |
3594847 | 3594847 | 2022-05-23 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-24 04:20:57 | Lafayette, Mississippi, US | |
623699 | 623699 | 2022-05-22 | US | Mississippi | Lafayette | 28071 | 15511 | 179 | 0 | 34.35687874 | -89.48490961 | 2022-05-26 04:20:50 | Lafayette, Mississippi, US | |
1187760 | 1187760 | 2022-05-18 | US | Texas | Angelina | 48005 | 15511 | 481 | 0 | 31.25457347 | -94.60901487 | 2022-05-19 04:20:54 | Angelina, Texas, US | |
1225176 | 1225176 | 2022-04-14 | US | Maryland | Cecil | 24015 | 15511 | 258 | 0 | 39.56647682 | -75.94627411 | 2022-04-15 04:20:57 | Cecil, Maryland, US | |
1541605 | 1541605 | 2022-03-31 | US | Michigan | Isabella | 26073 | 15511 | 207 | 0 | 43.64060976 | -84.84664923 | 2022-04-01 04:20:28 | Isabella, Michigan, US | |
2479618 | 2479618 | 2022-03-30 | US | Michigan | Isabella | 26073 | 15511 | 207 | 0 | 43.64060976 | -84.84664923 | 2022-03-31 04:20:56 | Isabella, Michigan, US | |
2446805 | 2446805 | 2022-02-22 | Japan | Yamanashi | 15511 | 42 | 0 | 35.612364 | 138.61148899999998 | 2022-02-23 04:21:09 | Yamanashi, Japan | |||
1230081 | 1230081 | 2022-01-24 | US | Ohio | Geauga | 39055 | 15511 | 254 | 0 | 41.49952319 | -81.17935342 | 2022-01-25 04:21:05 | Geauga, Ohio, US | |
1258812 | 1258812 | 2021-12-18 | Japan | Tochigi | 15511 | 117 | 0 | 36.689912 | 139.819213 | 2021-12-19 04:21:11 | Tochigi, Japan | |||
3404792 | 3404792 | 2021-11-30 | US | Virginia | Hampton | 51650 | 15511 | 249 | 0 | 37.03513786 | -76.35879121 | 2021-12-01 04:22:29 | Hampton, Virginia, US | |
1491673 | 1491673 | 2021-10-12 | Mali | 15511 | 554 | 0 | 17.570692 | -3.996166000000001 | 2021-10-13 04:20:51 | Mali | ||||
1923887 | 1923887 | 2021-09-24 | US | Pennsylvania | Fayette | 42051 | 15511 | 348 | 0 | 39.92041012 | -79.64291195 | 2021-09-25 04:21:31 | Fayette, Pennsylvania, US | |
3476644 | 3476644 | 2021-07-22 | Taiwan* | 15511 | 782 | 12456 | 2273 | 23.7 | 121.0 | 2021-07-23 04:21:29 | Taiwan* | |||
3333791 | 3333791 | 2021-07-21 | US | New York | Saratoga | 36091 | 15511 | 168 | 0 | 43.10904162 | -73.86653895 | 2021-07-22 04:21:19 | Saratoga, New York, US | |
3474962 | 3474962 | 2021-06-08 | US | Pennsylvania | Franklin | 42055 | 15511 | 371 | 0 | 39.92956518 | -77.72157791 | 2021-06-09 04:23:31 | Franklin, Pennsylvania, US | |
827785 | 827785 | 2021-06-06 | US | New Mexico | San Juan | 35045 | 15511 | 487 | 0 | 36.50838318 | -108.320437 | 2021-06-07 04:22:51 | San Juan, New Mexico, US | |
2588190 | 2588190 | 2021-06-05 | US | New Mexico | San Juan | 35045 | 15511 | 487 | 0 | 36.50838318 | -108.320437 | 2021-06-06 04:24:03 | San Juan, New Mexico, US | |
2317504 | 2317504 | 2021-06-04 | US | New Mexico | San Juan | 35045 | 15511 | 487 | 0 | 36.50838318 | -108.320437 | 2021-06-05 04:23:03 | San Juan, New Mexico, US | |
1710952 | 1710952 | 2021-06-02 | US | Pennsylvania | Beaver | 42007 | 15511 | 384 | 0 | 40.6825484 | -80.34921611 | 2021-06-03 04:23:32 | Beaver, Pennsylvania, US | |
2006568 | 2006568 | 2021-05-12 | US | Missouri | Jasper | 29097 | 15511 | 233 | 0 | 37.20351921 | -94.34050458 | 2021-05-13 04:20:51 | Jasper, Missouri, US | |
1552144 | 1552144 | 2021-05-08 | Peru | Tumbes | 15511 | 1382 | 0 | 14129 | -3.857496 | -80.54525500000003 | 2021-05-09 04:20:35 | Tumbes, Peru | ||
1845076 | 1845076 | 2021-04-14 | US | Texas | Kaufman | 48257 | 15511 | 248 | 0 | 32.599141700000004 | -96.28734728 | 2021-04-15 04:20:54 | Kaufman, Texas, US | |
3885345 | 3885345 | 2021-04-11 | US | Minnesota | Scott | 27139 | 15511 | 116 | 0 | 44.6490231 | -93.53340251 | 2021-04-12 04:21:00 | Scott, Minnesota, US | |
282457 | 282457 | 2021-02-24 | US | North Carolina | Alamance | 37001 | 15511 | 221 | 0 | 15290 | 36.0434701 | -79.39976137 | 2021-02-25 05:24:57 | Alamance, North Carolina, US |
3542287 | 3542287 | 2021-02-12 | US | South Carolina | Pickens | 45077 | 15511 | 247 | 0 | 15264 | 34.88807695 | -82.72791551 | 2021-02-13 05:22:12 | Pickens, South Carolina, US |
860753 | 860753 | 2020-12-11 | Mexico | Baja California Sur | 15511 | 704 | 0 | 14807 | 26.0444 | -111.6661 | 2020-12-12 05:26:19 | Baja California Sur, Mexico | ||
2702217 | 2702217 | 2020-11-20 | US | Florida | Manatee | 12081 | 15511 | 364 | 0 | 15147 | 27.47196942 | -82.31831044 | 2020-11-21 05:25:51 | Manatee, Florida, US |
3338780 | 3338780 | 2020-11-17 | Russia | Bryansk Oblast | 15511 | 99 | 11394 | 4018 | 52.8873315 | 33.41585300000001 | 2020-11-18 05:40:31 | Bryansk Oblast, Russia | ||
1247372 | 1247372 | 2020-09-08 | Ukraine | Kiev | 15511 | 246 | 4826 | 10439 | 50.4501 | 30.5234 | 2020-09-09 04:28:48 | Kiev, Ukraine |
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]);