johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 34597 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2379089 | 2379089 | 2022-09-29 | US | Wisconsin | Eau Claire | 55035 | 34597 | 200 | 0 | 44.726614 | -91.28609183 | 2022-09-30 04:23:09 | Eau Claire, Wisconsin, US | |
3728545 | 3728545 | 2022-06-07 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-08 04:20:55 | Harnett, North Carolina, US | |
3889947 | 3889947 | 2022-06-06 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-07 04:21:08 | Harnett, North Carolina, US | |
3509716 | 3509716 | 2022-06-05 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-06 04:20:57 | Harnett, North Carolina, US | |
3529793 | 3529793 | 2022-06-04 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-05 04:20:55 | Harnett, North Carolina, US | |
3135879 | 3135879 | 2022-06-03 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-04 04:20:58 | Harnett, North Carolina, US | |
3580954 | 3580954 | 2022-06-02 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-03 04:20:58 | Harnett, North Carolina, US | |
973247 | 973247 | 2022-06-01 | US | North Carolina | Harnett | 37085 | 34597 | 339 | 0 | 35.36731853 | -78.87243571 | 2022-06-02 05:20:39 | Harnett, North Carolina, US | |
1159851 | 1159851 | 2022-04-29 | US | Pennsylvania | Schuylkill | 42107 | 34597 | 674 | 0 | 40.70497338 | -76.2150785 | 2022-04-30 04:21:05 | Schuylkill, Pennsylvania, US | |
1329442 | 1329442 | 2022-04-26 | US | Texas | Parker | 48367 | 34597 | 450 | 0 | 32.77757172 | -97.80500621 | 2022-04-27 04:20:52 | Parker, Texas, US | |
2802692 | 2802692 | 2022-04-06 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-07 04:20:53 | Jasper, Missouri, US | |
3869461 | 3869461 | 2022-04-05 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-06 04:20:49 | Jasper, Missouri, US | |
2750803 | 2750803 | 2022-04-04 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-05 04:20:48 | Jasper, Missouri, US | |
3732149 | 3732149 | 2022-04-03 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-04 04:20:51 | Jasper, Missouri, US | |
501584 | 501584 | 2022-04-02 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-03 04:20:48 | Jasper, Missouri, US | |
3352569 | 3352569 | 2022-04-01 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-02 04:20:47 | Jasper, Missouri, US | |
1541874 | 1541874 | 2022-03-31 | US | Missouri | Jasper | 29097 | 34597 | 527 | 0 | 37.20351921 | -94.34050458 | 2022-04-01 04:20:28 | Jasper, Missouri, US | |
1228466 | 1228466 | 2022-01-24 | US | Georgia | Muscogee | 13215 | 34597 | 692 | 0 | 32.50931999 | -84.87142262 | 2022-01-25 04:21:05 | Muscogee, Georgia, US | |
1342873 | 1342873 | 2021-08-11 | US | California | Sonoma | 6097 | 34597 | 333 | 0 | 38.52746429 | -122.88625060000001 | 2021-08-12 04:21:25 | Sonoma, California, US | |
107649 | 107649 | 2021-06-19 | Russia | Dagestan Republic | 34597 | 1515 | 31955 | 1127 | 43.05749160000001 | 47.1332224 | 2021-06-20 04:21:48 | Dagestan Republic, Russia | ||
1736765 | 1736765 | 2021-06-12 | Russia | Udmurt Republic | 34597 | 991 | 31502 | 2104 | 57.1961165 | 52.69598320000001 | 2021-06-13 04:22:44 | Udmurt Republic, Russia | ||
1451290 | 1451290 | 2021-06-03 | US | Pennsylvania | Westmoreland | 42129 | 34597 | 769 | 0 | 40.31377979999999 | -79.46615476 | 2021-06-04 04:23:37 | Westmoreland, Pennsylvania, US | |
3113274 | 3113274 | 2021-05-06 | Chile | Los Rios | 34597 | 389 | 33178 | 1030 | -40.231 | -72.3311 | 2021-05-07 04:20:40 | Los Rios, Chile | ||
976622 | 976622 | 2021-02-06 | US | Minnesota | Dakota | 27037 | 34597 | 370 | 0 | 34227 | 44.67172617 | -93.06299363 | 2021-02-07 05:23:00 | Dakota, Minnesota, US |
777975 | 777975 | 2021-01-12 | Ukraine | Mykolaiv Oblast | 34597 | 558 | 15527 | 18512 | 46.975 | 31.9946 | 2021-01-13 05:22:15 | Mykolaiv Oblast, Ukraine | ||
2700369 | 2700369 | 2020-06-24 | US | New York | Westchester | 36119 | 34597 | 1416 | 0 | 33181 | 41.16278376 | -73.75741653 | 2020-06-25 05:26:54 | Westchester, New York, US |
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]);