johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where deaths = 5749 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753636 | 2753636 | 2022-12-29 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-30 04:21:04 | Palm Beach, Florida, US | |
1074642 | 1074642 | 2022-12-28 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-29 04:21:01 | Palm Beach, Florida, US | |
328639 | 328639 | 2022-12-27 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-28 04:21:04 | Palm Beach, Florida, US | |
218712 | 218712 | 2022-12-26 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-27 04:21:07 | Palm Beach, Florida, US | |
3223169 | 3223169 | 2022-12-25 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-26 04:21:06 | Palm Beach, Florida, US | |
1019083 | 1019083 | 2022-12-24 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-25 04:21:04 | Palm Beach, Florida, US | |
691106 | 691106 | 2022-12-23 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-24 04:21:02 | Palm Beach, Florida, US | |
2180316 | 2180316 | 2022-12-22 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-23 04:21:04 | Palm Beach, Florida, US | |
452120 | 452120 | 2022-12-21 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-22 04:20:56 | Palm Beach, Florida, US | |
2952119 | 2952119 | 2022-12-20 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-21 04:21:03 | Palm Beach, Florida, US | |
3174521 | 3174521 | 2022-12-19 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-20 04:21:04 | Palm Beach, Florida, US | |
1629038 | 1629038 | 2022-12-18 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-19 04:21:03 | Palm Beach, Florida, US | |
504417 | 504417 | 2022-12-17 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-18 04:21:03 | Palm Beach, Florida, US | |
3324989 | 3324989 | 2022-12-16 | US | Florida | Palm Beach | 12099 | 463102 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-17 04:21:04 | Palm Beach, Florida, US | |
543501 | 543501 | 2022-12-15 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-16 04:21:01 | Palm Beach, Florida, US | |
349029 | 349029 | 2022-12-14 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-15 04:20:58 | Palm Beach, Florida, US | |
308617 | 308617 | 2022-12-13 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-14 04:21:04 | Palm Beach, Florida, US | |
1149678 | 1149678 | 2022-12-12 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-13 04:21:01 | Palm Beach, Florida, US | |
869532 | 869532 | 2022-12-11 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-12 04:21:01 | Palm Beach, Florida, US | |
258062 | 258062 | 2022-12-10 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-11 04:20:50 | Palm Beach, Florida, US | |
3936776 | 3936776 | 2022-12-09 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-10 04:21:02 | Palm Beach, Florida, US | |
3378108 | 3378108 | 2022-12-08 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-09 04:21:05 | Palm Beach, Florida, US | |
1985379 | 1985379 | 2022-12-07 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-08 04:21:07 | Palm Beach, Florida, US | |
3714902 | 3714902 | 2022-12-06 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-07 04:20:58 | Palm Beach, Florida, US | |
2415607 | 2415607 | 2022-12-05 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-06 04:21:03 | Palm Beach, Florida, US | |
719215 | 719215 | 2022-12-04 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-05 04:20:58 | Palm Beach, Florida, US | |
2817504 | 2817504 | 2022-12-03 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-04 04:20:56 | Palm Beach, Florida, US | |
834360 | 834360 | 2022-12-02 | US | Florida | Palm Beach | 12099 | 459951 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-03 04:21:02 | Palm Beach, Florida, US | |
2136890 | 2136890 | 2022-12-01 | US | Florida | Palm Beach | 12099 | 457678 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-02 04:21:07 | Palm Beach, Florida, US | |
1965306 | 1965306 | 2022-11-30 | US | Florida | Palm Beach | 12099 | 457678 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-12-01 04:21:03 | Palm Beach, Florida, US | |
2557320 | 2557320 | 2022-11-29 | US | Florida | Palm Beach | 12099 | 457678 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-11-30 04:21:07 | Palm Beach, Florida, US | |
1240394 | 1240394 | 2022-11-28 | US | Florida | Palm Beach | 12099 | 457678 | 5749 | 0 | 26.64676272 | -80.46536002 | 2022-11-29 04:21:05 | Palm Beach, Florida, US | |
3437068 | 3437068 | 2022-04-22 | Russia | Penza Oblast | 183587 | 5749 | 0 | 53.1655415 | 44.78791810000001 | 2022-04-23 04:20:50 | Penza Oblast, Russia | |||
1868709 | 1868709 | 2022-03-10 | US | Texas | Tarrant | 48439 | 560120 | 5749 | 0 | 32.77143818 | -97.29101614 | 2022-03-11 04:20:50 | Tarrant, Texas, US | |
3810030 | 3810030 | 2022-01-28 | Mexico | Queretaro | 123491 | 5749 | 0 | 20.5888 | -100.3899 | 2022-01-29 04:21:10 | Queretaro, Mexico | |||
733595 | 733595 | 2021-12-27 | US | Texas | Dallas | 48113 | 408442 | 5749 | 0 | 32.76670599 | -96.77796049999999 | 2021-12-28 04:21:47 | Dallas, Texas, US | |
897 | 897 | 2021-12-02 | US | California | Orange | 6059 | 334940 | 5749 | 0 | 33.70147516 | -117.76459979999998 | 2021-12-03 04:23:05 | Orange, California, US | |
3401627 | 3401627 | 2021-11-30 | Russia | Altai Krai | 104046 | 5749 | 0 | 52.693224300000004 | 82.69314240000001 | 2021-12-01 04:22:29 | Altai Krai, Russia | |||
3106192 | 3106192 | 2021-08-24 | US | Florida | Unassigned | 90012 | 35417 | 5749 | 0 | 30.86747479 | 0.0 | 2021-08-25 04:21:41 | Unassigned, Florida, US | |
2175655 | 2175655 | 2021-08-22 | Mexico | Tamaulipas | 82370 | 5749 | 0 | 24.2669 | -98.8363 | 2021-08-23 04:21:27 | Tamaulipas, Mexico | |||
3555751 | 3555751 | 2021-08-21 | Mexico | Tamaulipas | 82174 | 5749 | 0 | 24.2669 | -98.8363 | 2021-08-22 04:21:29 | Tamaulipas, Mexico | |||
2255822 | 2255822 | 2021-05-19 | Mexico | Michoacan | 47962 | 5749 | 0 | 42213 | 19.5665 | -101.7068 | 2021-05-20 04:21:05 | Michoacan, Mexico | ||
2857024 | 2857024 | 2020-10-16 | Romania | 172516 | 5749 | 127076 | 39691 | 45.9432 | 24.9668 | 2020-10-17 04:24:12 | Romania | |||
2060170 | 2060170 | 2020-09-01 | Spain | Catalonia | 110667 | 5749 | 26203 | 78715 | 41.5912 | 1.5209 | 2020-09-02 04:28:25 | Catalonia, Spain |
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]);