johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where confirmed = 9018 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756055 | 2756055 | 2022-12-29 | US | Texas | Kleberg | 48273 | 9018 | 153 | 0 | 27.42435506 | -97.69894948 | 2022-12-30 04:21:04 | Kleberg, Texas, US | |
1077061 | 1077061 | 2022-12-28 | US | Texas | Kleberg | 48273 | 9018 | 153 | 0 | 27.42435506 | -97.69894948 | 2022-12-29 04:21:01 | Kleberg, Texas, US | |
434916 | 434916 | 2022-11-03 | US | Wisconsin | Juneau | 55057 | 9018 | 74 | 0 | 43.92456975 | -90.11120239 | 2022-11-04 04:22:11 | Juneau, Wisconsin, US | |
434790 | 434790 | 2022-11-03 | US | Virginia | Wythe | 51197 | 9018 | 164 | 0 | 36.91582035 | -81.07834059 | 2022-11-04 04:22:11 | Wythe, Virginia, US | |
3769142 | 3769142 | 2022-09-11 | US | Texas | Wood | 48499 | 9018 | 296 | 0 | 32.78722382 | -95.38236368 | 2022-09-12 04:20:58 | Wood, Texas, US | |
3827717 | 3827717 | 2022-09-10 | US | Texas | Wood | 48499 | 9018 | 296 | 0 | 32.78722382 | -95.38236368 | 2022-09-11 04:20:50 | Wood, Texas, US | |
966174 | 966174 | 2022-09-09 | US | Texas | Wood | 48499 | 9018 | 296 | 0 | 32.78722382 | -95.38236368 | 2022-09-10 04:21:10 | Wood, Texas, US | |
1490344 | 1490344 | 2022-07-26 | US | Puerto Rico | Las Piedras | 72085 | 9018 | 0 | 0 | 18.187527 | -65.869468 | 2022-07-27 04:21:04 | Las Piedras, Puerto Rico, US | |
2049624 | 2049624 | 2022-05-25 | US | Minnesota | Polk | 27119 | 9018 | 107 | 0 | 47.77372465 | -96.40134647 | 2022-05-26 04:20:50 | Polk, Minnesota, US | |
623635 | 623635 | 2022-05-22 | US | Minnesota | Polk | 27119 | 9018 | 107 | 0 | 47.77372465 | -96.40134647 | 2022-05-26 04:20:50 | Polk, Minnesota, US | |
944996 | 944996 | 2022-02-28 | US | New Hampshire | Sullivan | 33019 | 9018 | 67 | 0 | 43.36094111 | -72.22203125 | 2022-03-01 04:21:09 | Sullivan, New Hampshire, US | |
2834781 | 2834781 | 2022-01-22 | US | Missouri | Platte | 29165 | 9018 | 83 | 0 | 39.38154439 | -94.77068479 | 2022-01-23 04:21:13 | Platte, Missouri, US | |
801434 | 801434 | 2021-12-22 | US | Tennessee | Warren | 47177 | 9018 | 144 | 0 | 35.672829899999996 | -85.77969117 | 2021-12-23 04:21:21 | Warren, Tennessee, US | |
1716424 | 1716424 | 2021-12-16 | Malaysia | W.P. Putrajaya | 9018 | 21 | 0 | 2.9264 | 101.6964 | 2021-12-17 04:22:14 | W.P. Putrajaya, Malaysia | |||
3403141 | 3403141 | 2021-11-30 | US | Minnesota | Benton | 27009 | 9018 | 125 | 0 | 45.69804958 | -93.99514135 | 2021-12-01 04:22:29 | Benton, Minnesota, US | |
1231996 | 1231996 | 2021-11-28 | US | Alabama | Dale | 1045 | 9018 | 191 | 0 | 31.43037123 | -85.61095742 | 2021-11-29 04:22:30 | Dale, Alabama, US | |
1358703 | 1358703 | 2021-11-27 | US | Alabama | Dale | 1045 | 9018 | 191 | 0 | 31.43037123 | -85.61095742 | 2021-11-28 04:22:43 | Dale, Alabama, US | |
3495357 | 3495357 | 2021-10-26 | US | Texas | Navarro | 48349 | 9018 | 184 | 0 | 32.04620681 | -96.47428766 | 2021-10-27 04:22:32 | Navarro, Texas, US | |
3007900 | 3007900 | 2021-10-11 | US | California | Nevada | 6057 | 9018 | 90 | 0 | 39.30394768 | -120.76272809999999 | 2021-10-12 04:21:09 | Nevada, California, US | |
1236763 | 1236763 | 2021-09-27 | US | Indiana | Morgan | 18109 | 9018 | 160 | 0 | 39.47899078 | -86.44573375 | 2021-09-28 04:21:28 | Morgan, Indiana, US | |
2465738 | 2465738 | 2021-09-14 | US | Tennessee | Hawkins | 47073 | 9018 | 138 | 0 | 36.44355426 | -82.94885298 | 2021-09-15 03:22:37 | Hawkins, Tennessee, US | |
644863 | 644863 | 2021-09-07 | US | Tennessee | Coffee | 47031 | 9018 | 133 | 0 | 35.49090731 | -86.07311784 | 2021-09-08 04:21:31 | Coffee, Tennessee, US | |
33479 | 33479 | 2021-08-25 | US | Indiana | Bartholomew | 18005 | 9018 | 159 | 0 | 39.20744865 | -85.89558181 | 2021-08-26 04:21:28 | Bartholomew, Indiana, US | |
1605137 | 1605137 | 2021-08-16 | US | Guam | 66 | 9018 | 143 | 0 | 13.4443 | 144.7937 | 2021-08-17 04:21:49 | Guam, US | ||
3683478 | 3683478 | 2021-08-02 | Japan | Nara | 9018 | 133 | 8561 | 324 | 34.317451 | 135.871644 | 2021-08-03 04:21:39 | Nara, Japan | ||
1774602 | 1774602 | 2021-05-23 | US | Utah | Central Utah | 9018 | 68 | 0 | 39.37231946 | -111.5758676 | 2021-05-24 04:20:53 | Central Utah, Utah, US | ||
2503623 | 2503623 | 2021-05-07 | US | Massachusetts | Hampshire | 25015 | 9018 | 230 | 0 | 42.33997957 | -72.65898478 | 2021-05-08 04:21:04 | Hampshire, Massachusetts, US | |
702474 | 702474 | 2021-03-16 | Mali | 9018 | 364 | 6526 | 2128 | 17.570692 | -3.996166000000001 | 2021-03-17 05:25:07 | Mali | |||
2185755 | 2185755 | 2021-02-26 | US | New Jersey | Sussex | 34037 | 9018 | 273 | 0 | 8745 | 41.13891592 | -74.69118243 | 2021-02-27 05:22:28 | Sussex, New Jersey, US |
2640401 | 2640401 | 2021-02-11 | US | Pennsylvania | Monroe | 42089 | 9018 | 253 | 0 | 8765 | 41.05934058 | -75.34031025 | 2021-02-12 05:23:29 | Monroe, Pennsylvania, US |
436528 | 436528 | 2021-01-21 | US | Iowa | Dallas | 19049 | 9018 | 72 | 0 | 8946 | 41.68560356 | -94.04127625 | 2021-01-22 05:22:10 | Dallas, Iowa, US |
202772 | 202772 | 2020-12-25 | US | Arkansas | Sebastian | 5131 | 9018 | 146 | 0 | 8872 | 35.19605503 | -94.27162713 | 2020-12-26 05:22:28 | Sebastian, Arkansas, US |
8290 | 8290 | 2020-10-25 | India | Meghalaya | 9018 | 81 | 7332 | 1605 | 25.536934 | 91.278882 | 2020-10-26 04:25:02 | Meghalaya, India | ||
786364 | 786364 | 2020-10-15 | Italy | Marche | 9018 | 992 | 6362 | 1664 | 43.61675973 | 13.5188753 | 2020-10-16 04:24:01 | Marche, Italy | ||
97015 | 97015 | 2020-08-04 | US | Florida | Osceola | 12097 | 9018 | 88 | 0 | 8930 | 28.06312234 | -81.14882926 | 2020-08-05 04:34:43 | Osceola, Florida, US |
3184016 | 3184016 | 2020-07-28 | US | Massachusetts | Plymouth | 25023 | 9018 | 706 | 0 | 8312 | 41.94070556 | -70.80802823 | 2020-07-29 04:35:11 | Plymouth, Massachusetts, US |
1281553 | 1281553 | 2020-06-04 | Moldova | 9018 | 315 | 5009 | 3694 | 47.4116 | 28.3699 | 2020-06-05 02:33:06 | Moldova |
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]);