johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 22125 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1628533 | 1628533 | 2022-12-18 | Russia | Magadan Oblast | 22125 | 393 | 0 | 62.48858785 | 153.9903764 | 2022-12-19 04:21:03 | Magadan Oblast, Russia | |||
131623 | 131623 | 2022-10-04 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-10-05 04:23:06 | Rockdale, Georgia, US | |
2686570 | 2686570 | 2022-10-03 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-10-04 04:22:55 | Rockdale, Georgia, US | |
2260637 | 2260637 | 2022-10-02 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-10-03 04:23:11 | Rockdale, Georgia, US | |
2996163 | 2996163 | 2022-10-01 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-10-02 04:21:23 | Rockdale, Georgia, US | |
854489 | 854489 | 2022-09-30 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-10-01 04:23:01 | Rockdale, Georgia, US | |
2376415 | 2376415 | 2022-09-29 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-09-30 04:23:09 | Rockdale, Georgia, US | |
1560966 | 1560966 | 2022-09-28 | US | Georgia | Rockdale | 13247 | 22125 | 333 | 0 | 33.65145002 | -84.02202167 | 2022-09-29 04:22:34 | Rockdale, Georgia, US | |
3550923 | 3550923 | 2022-09-01 | US | Virginia | Suffolk | 51800 | 22125 | 318 | 0 | 36.70155394 | -76.63603554 | 2022-09-02 04:21:07 | Suffolk, Virginia, US | |
2643631 | 2643631 | 2022-02-14 | US | Missouri | Buchanan | 29021 | 22125 | 284 | 0 | 39.65816401 | -94.80138942 | 2022-02-15 04:21:09 | Buchanan, Missouri, US | |
1232107 | 1232107 | 2021-11-28 | US | Arkansas | Craighead | 5031 | 22125 | 249 | 0 | 35.83018283 | -90.63235729 | 2021-11-29 04:22:30 | Craighead, Arkansas, US | |
2943706 | 2943706 | 2021-10-15 | US | Alabama | Calhoun | 1015 | 22125 | 469 | 0 | 33.77483727 | -85.82630386 | 2021-10-16 04:21:15 | Calhoun, Alabama, US | |
2774105 | 2774105 | 2021-09-30 | US | Indiana | Porter | 18127 | 22125 | 354 | 0 | 41.45986947 | -87.06848888 | 2021-10-01 04:21:35 | Porter, Indiana, US | |
706350 | 706350 | 2021-09-29 | Haiti | 22125 | 622 | 0 | 18.9712 | -72.2852 | 2021-09-30 04:21:20 | Haiti | ||||
3015190 | 3015190 | 2021-08-01 | Colombia | Caqueta | 22125 | 878 | 20803 | 444 | 0.8699 | -73.8419 | 2021-08-02 04:21:36 | Caqueta, Colombia | ||
1410182 | 1410182 | 2021-04-23 | US | Indiana | Vanderburgh | 18163 | 22125 | 394 | 0 | 38.02658833 | -87.58763124 | 2021-04-24 04:20:38 | Vanderburgh, Indiana, US | |
702599 | 702599 | 2021-03-16 | Russia | Chuvashia Republic | 22125 | 1121 | 20208 | 796 | 55.4259922 | 47.0849429 | 2021-03-17 05:25:07 | Chuvashia Republic, Russia | ||
1177568 | 1177568 | 2020-10-22 | Mexico | Baja California | 22125 | 3733 | 17479 | 913 | 30.8406 | -115.2838 | 2020-10-23 04:24:46 | Baja California, Mexico |
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]);