johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where confirmed = 30651 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329813 | 329813 | 2022-12-27 | US | Missouri | Franklin | 29071 | 30651 | 406 | 0 | 38.41127108 | -91.07522826 | 2022-12-28 04:21:04 | Franklin, Missouri, US | |
3777569 | 3777569 | 2022-08-30 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-31 04:20:57 | Guernsey, United Kingdom | |||
1684165 | 1684165 | 2022-08-29 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-30 04:21:03 | Guernsey, United Kingdom | |||
1880649 | 1880649 | 2022-08-28 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-29 04:21:06 | Guernsey, United Kingdom | |||
2099776 | 2099776 | 2022-08-27 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-28 04:21:02 | Guernsey, United Kingdom | |||
1535591 | 1535591 | 2022-08-26 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-27 04:20:57 | Guernsey, United Kingdom | |||
1531698 | 1531698 | 2022-08-26 | Chile | Aysen | 30651 | 194 | 0 | -45.9864 | -73.7669 | 2022-08-27 04:20:57 | Aysen, Chile | |||
2832478 | 2832478 | 2022-08-25 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-26 04:21:02 | Guernsey, United Kingdom | |||
2327011 | 2327011 | 2022-08-24 | United Kingdom | Guernsey | 30651 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-25 04:21:13 | Guernsey, United Kingdom | |||
1253388 | 1253388 | 2022-08-23 | US | Oregon | Linn | 41043 | 30651 | 302 | 0 | 44.48899494 | -122.5373154 | 2022-08-24 04:20:46 | Linn, Oregon, US | |
1490273 | 1490273 | 2022-07-26 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-27 04:21:04 | Lycoming, Pennsylvania, US | |
2596719 | 2596719 | 2022-07-25 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-26 04:20:58 | Lycoming, Pennsylvania, US | |
898834 | 898834 | 2022-07-24 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-25 04:20:51 | Lycoming, Pennsylvania, US | |
93828 | 93828 | 2022-07-23 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-24 04:20:47 | Lycoming, Pennsylvania, US | |
902850 | 902850 | 2022-07-22 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-23 04:20:53 | Lycoming, Pennsylvania, US | |
672986 | 672986 | 2022-07-21 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-22 04:21:15 | Lycoming, Pennsylvania, US | |
1610949 | 1610949 | 2022-07-20 | US | Pennsylvania | Lycoming | 42081 | 30651 | 542 | 0 | 41.34310539 | -77.06629984 | 2022-07-21 04:21:10 | Lycoming, Pennsylvania, US | |
2727988 | 2727988 | 2022-05-28 | US | Tennessee | Madison | 47113 | 30651 | 429 | 0 | 35.61181957 | -88.84076036 | 2022-05-29 04:20:53 | Madison, Tennessee, US | |
303940 | 303940 | 2022-04-16 | Mali | 30651 | 729 | 0 | 17.570692 | -3.996166000000001 | 2022-04-17 04:20:59 | Mali | ||||
2445993 | 2445993 | 2022-04-13 | US | Texas | Tom Green | 48451 | 30651 | 465 | 0 | 31.40464436 | -100.46244300000001 | 2022-04-13 23:21:06 | Tom Green, Texas, US | |
2447611 | 2447611 | 2022-02-22 | US | Georgia | Lowndes | 13185 | 30651 | 358 | 0 | 30.83568832 | -83.27056716 | 2022-02-23 04:21:09 | Lowndes, Georgia, US | |
3718373 | 3718373 | 2022-02-21 | Russia | Altai Republic | 30651 | 584 | 0 | 50.7114101 | 86.8572186 | 2022-02-22 04:21:01 | Altai Republic, Russia | |||
1389705 | 1389705 | 2022-01-07 | Lesotho | 30651 | 678 | 0 | -29.61 | 28.2336 | 2022-01-08 04:21:53 | Lesotho | ||||
470544 | 470544 | 2021-10-07 | US | Texas | Jefferson | 48245 | 30651 | 649 | 0 | 29.8832777 | -94.16434171 | 2021-10-08 04:21:25 | Jefferson, Texas, US | |
2811231 | 2811231 | 2021-09-16 | US | Ohio | Lorain | 39093 | 30651 | 551 | 0 | 41.29553751 | -82.15083537 | 2021-09-17 04:21:46 | Lorain, Ohio, US | |
3360835 | 3360835 | 2021-06-21 | US | New Jersey | Gloucester | 34015 | 30651 | 643 | 0 | 39.71581067 | -75.13995546 | 2021-06-22 04:21:34 | Gloucester, New Jersey, US | |
1709825 | 1709825 | 2021-06-02 | US | Louisiana | Orleans | 22071 | 30651 | 795 | 0 | 30.06971951 | -89.92660315 | 2021-06-03 04:23:32 | Orleans, Louisiana, US | |
1413302 | 1413302 | 2021-05-24 | Russia | Smolensk Oblast | 30651 | 990 | 28876 | 785 | 55.03434960000001 | 33.0192065 | 2021-05-25 04:21:08 | Smolensk Oblast, Russia | ||
2362917 | 2362917 | 2021-03-08 | US | Washington | Snohomish | 53061 | 30651 | 538 | 0 | 48.04615983 | -121.7170703 | 2021-03-09 05:28:19 | Snohomish, Washington, US | |
204491 | 204491 | 2020-12-25 | US | New York | Monroe | 36055 | 30651 | 495 | 0 | 30156 | 43.14638895 | -77.69322942 | 2020-12-26 05:22:28 | Monroe, New York, US |
2701669 | 2701669 | 2020-11-20 | Peru | Ica | 30651 | 3486 | 0 | 27165 | -14.235097 | -75.574821 | 2020-11-21 05:25:51 | Ica, Peru |
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]);