johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where active = 4006 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408086 | 408086 | 2021-07-28 | Chile | Metropolitana | 672267 | 18193 | 650068 | 4006 | -33.4376 | -70.6505 | 2021-07-29 04:21:33 | Metropolitana, Chile | ||
2673542 | 2673542 | 2021-07-18 | Brazil | Alagoas | 225999 | 5641 | 216352 | 4006 | -9.5713 | -36.782 | 2021-07-19 04:21:24 | Alagoas, Brazil | ||
3958839 | 3958839 | 2021-06-26 | Taiwan* | 14545 | 623 | 9916 | 4006 | 23.7 | 121.0 | 2021-06-27 04:21:39 | Taiwan* | |||
1203771 | 1203771 | 2021-03-22 | India | Rajasthan | 326026 | 2803 | 319217 | 4006 | 26.583423 | 73.847973 | 2021-03-23 05:26:18 | Rajasthan, India | ||
2056068 | 2056068 | 2021-03-15 | Russia | Arkhangelsk Oblast | 58329 | 753 | 53570 | 4006 | 63.5589686 | 43.1221646 | 2021-03-16 05:25:13 | Arkhangelsk Oblast, Russia | ||
1732437 | 1732437 | 2021-03-14 | India | Chhattisgarh | 317329 | 3890 | 309433 | 4006 | 21.264705 | 82.035366 | 2021-03-15 05:25:51 | Chhattisgarh, India | ||
1837877 | 1837877 | 2021-03-12 | India | Gujarat | 276622 | 4420 | 268196 | 4006 | 22.694884 | 71.590923 | 2021-03-13 05:25:15 | Gujarat, India | ||
1837618 | 1837618 | 2021-03-12 | Afghanistan | 55959 | 2454 | 49499 | 4006 | 33.93911 | 67.709953 | 2021-03-13 05:25:15 | Afghanistan | |||
744664 | 744664 | 2021-02-20 | US | North Carolina | Richmond | 37153 | 4093 | 87 | 0 | 4006 | 35.00417719 | -79.74491009 | 2021-02-21 05:24:33 | Richmond, North Carolina, US |
2680781 | 2680781 | 2021-02-13 | US | Tennessee | Lincoln | 47103 | 4048 | 60 | 0 | 4006 | 35.13738622 | -86.58910106 | 2021-02-14 05:23:43 | Lincoln, Tennessee, US |
2679043 | 2679043 | 2021-02-13 | US | Iowa | Muscatine | 19139 | 4093 | 87 | 0 | 4006 | 41.48370744 | -91.1121697 | 2021-02-14 05:23:43 | Muscatine, Iowa, US |
2678984 | 2678984 | 2021-02-13 | US | Iowa | Buena Vista | 19021 | 4042 | 36 | 0 | 4006 | 42.73545875 | -95.15100162 | 2021-02-14 05:23:43 | Buena Vista, Iowa, US |
1674685 | 1674685 | 2021-02-07 | US | New York | Genesee | 36037 | 4120 | 114 | 0 | 4006 | 43.0022601 | -78.19135193 | 2021-02-08 05:22:39 | Genesee, New York, US |
1590265 | 1590265 | 2021-02-05 | US | Nebraska | Madison | 31119 | 4046 | 40 | 0 | 4006 | 41.91676024 | -97.6005481 | 2021-02-06 05:23:55 | Madison, Nebraska, US |
343384 | 343384 | 2021-02-03 | US | Texas | Hill | 48217 | 4822 | 66 | 0 | 4006 | 31.99045053 | -97.13423143 | 2021-02-04 05:22:26 | Hill, Texas, US |
3155519 | 3155519 | 2021-01-27 | US | Missouri | Lincoln | 29113 | 4030 | 24 | 0 | 4006 | 39.05345619 | -90.95588181 | 2021-01-28 05:22:24 | Lincoln, Missouri, US |
2627560 | 2627560 | 2021-01-10 | US | Minnesota | Benton | 27009 | 4090 | 84 | 0 | 4006 | 45.69804958 | -93.99514135 | 2021-01-11 05:21:50 | Benton, Minnesota, US |
3037632 | 3037632 | 2021-01-05 | US | Virginia | Frederick | 51069 | 4038 | 32 | 0 | 4006 | 39.20172582 | -78.25974949 | 2021-01-06 05:22:16 | Frederick, Virginia, US |
3151909 | 3151909 | 2020-12-16 | US | North Carolina | Henderson | 37089 | 4091 | 85 | 0 | 4006 | 35.33788927 | -82.4766782 | 2020-12-17 05:28:12 | Henderson, North Carolina, US |
1035993 | 1035993 | 2020-12-15 | US | Michigan | Eaton | 26045 | 4077 | 71 | 0 | 4006 | 42.59599185 | -84.83740035 | 2020-12-16 05:28:04 | Eaton, Michigan, US |
3860673 | 3860673 | 2020-12-04 | US | Georgia | Newton | 13217 | 4116 | 110 | 0 | 4006 | 33.55514538 | -83.84547140000002 | 2020-12-05 05:27:36 | Newton, Georgia, US |
2538820 | 2538820 | 2020-12-01 | US | Kentucky | Madison | 21151 | 4024 | 18 | 0 | 4006 | 37.71659336 | -84.27220275 | 2020-12-02 05:27:41 | Madison, Kentucky, US |
1587532 | 1587532 | 2020-11-30 | US | Virginia | Newport News | 51700 | 4061 | 55 | 0 | 4006 | 37.08166899 | -76.51754109 | 2020-12-01 05:26:18 | Newport News, Virginia, US |
378481 | 378481 | 2020-11-06 | US | North Carolina | Davidson | 37057 | 4053 | 47 | 0 | 4006 | 35.79115496 | -80.21256572 | 2020-11-07 05:24:52 | Davidson, North Carolina, US |
895075 | 895075 | 2020-11-05 | US | Tennessee | Madison | 47113 | 4064 | 86 | 0 | 4006 | 35.61181957 | -88.84076036 | 2020-11-06 05:24:55 | Madison, Tennessee, US |
756651 | 756651 | 2020-10-28 | US | North Carolina | Rowan | 37159 | 4122 | 116 | 0 | 4006 | 35.64003916 | -80.52446628 | 2020-10-29 04:24:49 | Rowan, North Carolina, US |
3481091 | 3481091 | 2020-10-26 | US | Georgia | Douglas | 13097 | 4078 | 72 | 0 | 4006 | 33.70291126 | -84.77026156 | 2020-10-27 04:24:45 | Douglas, Georgia, US |
3653723 | 3653723 | 2020-10-24 | US | New Jersey | Cumberland | 34011 | 4168 | 162 | 0 | 4006 | 39.37199394 | -75.10712559 | 2020-10-25 04:24:36 | Cumberland, New Jersey, US |
1795194 | 1795194 | 2020-10-19 | US | California | San Luis Obispo | 6079 | 4038 | 31 | 0 | 4006 | 35.38822029 | -120.4039028 | 2020-10-20 04:24:22 | San Luis Obispo, California, US |
763815 | 763815 | 2020-10-18 | US | Louisiana | Livingston | 22063 | 4085 | 79 | 0 | 4006 | 30.44143993 | -90.73061664 | 2020-10-19 04:24:16 | Livingston, Louisiana, US |
1029986 | 1029986 | 2020-10-17 | Ukraine | Zhytomyr Oblast | 9539 | 168 | 5365 | 4006 | 50.2547 | 28.6587 | 2020-10-18 04:24:25 | Zhytomyr Oblast, Ukraine | ||
1045441 | 1045441 | 2020-10-07 | Ukraine | Kiev Oblast | 10291 | 209 | 6076 | 4006 | 50.053 | 30.7667 | 2020-10-08 04:23:56 | Kiev Oblast, Ukraine | ||
2379865 | 2379865 | 2020-10-01 | Russia | Rostov Oblast | 22143 | 504 | 17633 | 4006 | 47.6222451 | 40.7957942 | 2020-10-02 04:23:51 | Rostov Oblast, Russia | ||
2607534 | 2607534 | 2020-09-24 | US | Louisiana | Rapides | 22079 | 4154 | 148 | 0 | 4006 | 31.19778499 | -92.52997303 | 2020-09-25 04:23:00 | Rapides, Louisiana, US |
3095561 | 3095561 | 2020-09-20 | US | New Hampshire | Hillsborough | 33011 | 4294 | 288 | 0 | 4006 | 42.91537785 | -71.7200253 | 2020-09-21 04:23:00 | Hillsborough, New Hampshire, US |
326605 | 326605 | 2020-07-20 | US | Nevada | Washoe | 32031 | 4108 | 102 | 0 | 4006 | 40.66562265 | -119.6631594 | 2020-07-21 04:38:46 | Washoe, Nevada, US |
3491344 | 3491344 | 2020-07-13 | Ukraine | Kiev | 6238 | 124 | 2108 | 4006 | 50.4501 | 30.5234 | 2020-07-14 04:34:46 | Kiev, Ukraine | ||
529781 | 529781 | 2020-07-04 | Mexico | Ciudad de Mexico | 51658 | 6921 | 40731 | 4006 | 19.4326 | -99.1332 | 2020-07-05 04:33:46 | Ciudad de Mexico, 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]);