johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where active = 3557 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3632222 | 3632222 | 2021-07-14 | Russia | Yaroslavl Oblast | 46321 | 772 | 41992 | 3557 | 57.77819760000001 | 39.0021095 | 2021-07-15 04:21:48 | Yaroslavl Oblast, Russia | ||
3663270 | 3663270 | 2021-07-11 | Malaysia | Melaka | 21870 | 204 | 18109 | 3557 | 2.1896 | 102.2501 | 2021-07-12 04:21:34 | Melaka, Malaysia | ||
829535 | 829535 | 2021-07-09 | India | Arunachal Pradesh | 39085 | 186 | 35342 | 3557 | 27.768456 | 96.384277 | 2021-07-10 04:21:25 | Arunachal Pradesh, India | ||
1189050 | 1189050 | 2021-05-31 | Sudan | 35495 | 2631 | 29307 | 3557 | 12.8628 | 30.2176 | 2021-06-01 04:23:09 | Sudan | |||
3066456 | 3066456 | 2021-02-27 | US | Arkansas | Boone | 5009 | 3636 | 79 | 0 | 3557 | 36.3084504 | -93.09374925 | 2021-02-28 05:22:20 | Boone, Arkansas, US |
533282 | 533282 | 2021-02-22 | US | Oklahoma | Ottawa | 40115 | 3599 | 42 | 0 | 3557 | 36.83532655 | -94.81011909 | 2021-02-23 05:23:41 | Ottawa, Oklahoma, US |
742573 | 742573 | 2021-02-20 | Russia | Vologda Oblast | 37785 | 749 | 33479 | 3557 | 60.0391461 | 43.1215213 | 2021-02-21 05:24:33 | Vologda Oblast, Russia | ||
3978925 | 3978925 | 2021-02-10 | US | Alabama | Chilton | 1021 | 3643 | 86 | 0 | 3557 | 32.85044126 | -86.7173256 | 2021-02-11 05:23:55 | Chilton, Alabama, US |
616057 | 616057 | 2021-02-08 | US | North Carolina | Watauga | 37189 | 3582 | 25 | 0 | 3557 | 36.23103603 | -81.70033724 | 2021-02-09 05:23:30 | Watauga, North Carolina, US |
1675692 | 1675692 | 2021-02-07 | US | Texas | Van Zandt | 48467 | 3060 | 100 | 0 | 3557 | 32.56483801 | -95.83766469 | 2021-02-08 05:22:39 | Van Zandt, Texas, US |
2211875 | 2211875 | 2021-01-30 | Russia | Khabarovsk Krai | 44238 | 251 | 40430 | 3557 | 51.6312684 | 136.121524 | 2021-01-31 05:22:42 | Khabarovsk Krai, Russia | ||
436373 | 436373 | 2021-01-21 | US | Illinois | Monroe | 17133 | 3628 | 71 | 0 | 3557 | 38.27594376 | -90.17761038 | 2021-01-22 05:22:10 | Monroe, Illinois, US |
3104940 | 3104940 | 2021-01-16 | US | West Virginia | Raleigh | 54081 | 3594 | 37 | 0 | 3557 | 37.76936795 | -81.2456041 | 2021-01-17 05:22:17 | Raleigh, West Virginia, US |
3880641 | 3880641 | 2021-01-14 | US | Indiana | Clinton | 18023 | 3598 | 41 | 0 | 3557 | 40.30319754 | -86.47277257 | 2021-01-15 05:22:24 | Clinton, Indiana, US |
3879490 | 3879490 | 2021-01-14 | Germany | Mecklenburg-Vorpommern | 15684 | 268 | 12159 | 3557 | 53.6127 | 12.4296 | 2021-01-15 05:22:24 | Mecklenburg-Vorpommern, Germany | ||
776516 | 776516 | 2021-01-12 | US | New Jersey | Salem | 34033 | 3676 | 119 | 0 | 3557 | 39.58719656 | -75.34696629999998 | 2021-01-13 05:22:15 | Salem, New Jersey, US |
190761 | 190761 | 2021-01-11 | US | Florida | Hendry | 12051 | 3609 | 52 | 0 | 3557 | 26.55386945 | -81.16469006 | 2021-01-12 05:22:15 | Hendry, Florida, US |
2408793 | 2408793 | 2020-12-23 | US | Missouri | Taney | 29213 | 3608 | 51 | 0 | 3557 | 36.65465345 | -93.04075153 | 2020-12-24 05:23:04 | Taney, Missouri, US |
2119910 | 2119910 | 2020-12-20 | Russia | Irkutsk Oblast | 37568 | 1077 | 32934 | 3557 | 56.6370122 | 104.719221 | 2020-12-21 05:27:58 | Irkutsk Oblast, Russia | ||
3151948 | 3151948 | 2020-12-16 | US | North Carolina | Stanly | 37167 | 3635 | 78 | 0 | 3557 | 35.31647813 | -80.25093221 | 2020-12-17 05:28:12 | Stanly, North Carolina, US |
1037325 | 1037325 | 2020-12-15 | US | Tennessee | Lawrence | 47099 | 3672 | 47 | 0 | 3557 | 35.21675201 | -87.39787695 | 2020-12-16 05:28:04 | Lawrence, Tennessee, US |
393322 | 393322 | 2020-11-27 | US | Indiana | Howard | 18067 | 3641 | 84 | 0 | 3557 | 40.48527731 | -86.11351892 | 2020-11-28 05:25:50 | Howard, Indiana, US |
865647 | 865647 | 2020-11-12 | US | Georgia | Troup | 13285 | 3672 | 115 | 0 | 3557 | 33.03349196 | -85.02812115 | 2020-11-13 05:25:30 | Troup, Georgia, US |
275713 | 275713 | 2020-11-10 | US | Wisconsin | Ozaukee | 55089 | 3584 | 27 | 0 | 3557 | 43.38352225 | -87.94625009 | 2020-11-11 05:25:30 | Ozaukee, Wisconsin, US |
1545006 | 1545006 | 2020-11-07 | US | Indiana | Clark | 18019 | 3627 | 70 | 0 | 3557 | 38.48015445 | -85.70510334 | 2020-11-08 05:24:56 | Clark, Indiana, US |
891980 | 891980 | 2020-11-05 | Colombia | Santander | 44184 | 1742 | 38885 | 3557 | 6.6437 | -73.6536 | 2020-11-06 05:24:55 | Santander, Colombia | ||
3307172 | 3307172 | 2020-11-02 | US | Tennessee | Sevier | 47155 | 3550 | 23 | 0 | 3557 | 35.78077323 | -83.52244332 | 2020-11-03 06:00:16 | Sevier, Tennessee, US |
3992927 | 3992927 | 2020-10-20 | US | North Carolina | Iredell | 37097 | 3591 | 34 | 0 | 3557 | 35.80950511 | -80.8743128 | 2020-10-21 04:24:14 | Iredell, North Carolina, US |
82695 | 82695 | 2020-10-14 | Ukraine | Cherkasy Oblast | 6047 | 66 | 2424 | 3557 | 49.4444 | 32.0598 | 2020-10-15 04:24:28 | Cherkasy Oblast, Ukraine | ||
1446144 | 1446144 | 2020-09-11 | US | Maryland | Frederick | 24021 | 3684 | 127 | 0 | 3557 | 39.47296601 | -77.39999394 | 2020-09-12 04:25:05 | Frederick, Maryland, US |
3932269 | 3932269 | 2020-08-30 | Russia | Stavropol Krai | 11857 | 233 | 8067 | 3557 | 44.86325770000001 | 43.4406913 | 2020-08-31 04:28:27 | Stavropol Krai, Russia | ||
1998152 | 1998152 | 2020-08-26 | US | Louisiana | Rapides | 22079 | 3691 | 134 | 0 | 3557 | 31.19778499 | -92.52997303 | 2020-08-27 04:28:15 | Rapides, Louisiana, US |
3793472 | 3793472 | 2020-08-05 | North Macedonia | 11289 | 511 | 7221 | 3557 | 41.6086 | 21.7453 | 2020-08-06 04:35:02 | North Macedonia | |||
1928606 | 1928606 | 2020-07-30 | Peru | Tumbes | 4090 | 533 | 0 | 3557 | -3.857496 | -80.54525500000003 | 2020-07-31 04:35:18 | Tumbes, Peru | ||
2956496 | 2956496 | 2020-07-29 | US | Colorado | Jefferson | 8059 | 4092 | 232 | 0 | 3557 | 39.58635604 | -105.2517692 | 2020-07-30 04:35:05 | Jefferson, Colorado, US |
3489112 | 3489112 | 2020-07-13 | US | North Carolina | Guilford | 37081 | 3682 | 125 | 0 | 3557 | 36.07959451 | -79.78824948 | 2020-07-14 04:34:46 | Guilford, North Carolina, US |
3435550 | 3435550 | 2020-07-11 | US | Florida | Volusia | 12127 | 3634 | 77 | 0 | 3557 | 29.05858895 | -81.18263252 | 2020-07-12 04:34:30 | Volusia, Florida, US |
1003266 | 1003266 | 2020-07-09 | US | Georgia | Hall | 13139 | 3620 | 63 | 0 | 3557 | 34.32207823 | -83.81896936 | 2020-07-10 04:34:24 | Hall, Georgia, US |
2974829 | 2974829 | 2020-06-30 | North Macedonia | 6334 | 302 | 2475 | 3557 | 41.6086 | 21.7453 | 2020-07-01 04:33:52 | North Macedonia |
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]);