johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 20038 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 22
- Russia 2
- India 1
- Seychelles 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2262828 | 2262828 | 2022-10-02 | US | Texas | Coryell | 48099 | 20038 | 218 | 0 | 31.39078397 | -97.79936155 | 2022-10-03 04:23:11 | Coryell, Texas, US | |
2998354 | 2998354 | 2022-10-01 | US | Texas | Coryell | 48099 | 20038 | 218 | 0 | 31.39078397 | -97.79936155 | 2022-10-02 04:21:23 | Coryell, Texas, US | |
856680 | 856680 | 2022-09-30 | US | Texas | Coryell | 48099 | 20038 | 218 | 0 | 31.39078397 | -97.79936155 | 2022-10-01 04:23:01 | Coryell, Texas, US | |
2492529 | 2492529 | 2022-06-29 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-30 04:21:01 | Ross, Ohio, US | |
2241911 | 2241911 | 2022-06-28 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-29 04:20:59 | Ross, Ohio, US | |
2150153 | 2150153 | 2022-06-27 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-28 04:20:58 | Ross, Ohio, US | |
477954 | 477954 | 2022-06-26 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-27 04:21:00 | Ross, Ohio, US | |
941329 | 941329 | 2022-06-25 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-26 04:21:02 | Ross, Ohio, US | |
3349149 | 3349149 | 2022-06-24 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-25 04:20:57 | Ross, Ohio, US | |
1650890 | 1650890 | 2022-06-23 | US | Ohio | Ross | 39141 | 20038 | 305 | 0 | 39.33705391 | -83.06000914 | 2022-06-24 04:20:58 | Ross, Ohio, US | |
3437379 | 3437379 | 2022-04-22 | US | California | Humboldt | 6023 | 20038 | 145 | 0 | 40.69923009 | -123.876044 | 2022-04-23 04:20:50 | Humboldt, California, US | |
3025304 | 3025304 | 2022-03-23 | US | Texas | Bowie | 48037 | 20038 | 428 | 0 | 33.44626922 | -94.41834132 | 2022-03-24 04:20:43 | Bowie, Texas, US | |
980043 | 980043 | 2022-02-01 | US | Indiana | Hancock | 18059 | 20038 | 226 | 0 | 39.82304555 | -85.77566351 | 2022-02-02 04:21:09 | Hancock, Indiana, US | |
2612209 | 2612209 | 2022-01-06 | US | New Hampshire | Strafford | 33017 | 20038 | 168 | 0 | 43.291833000000004 | -71.02336013 | 2022-01-07 04:22:09 | Strafford, New Hampshire, US | |
2068180 | 2068180 | 2021-08-31 | Seychelles | 20038 | 102 | 0 | -4.6796 | 55.492 | 2021-09-01 04:21:38 | Seychelles | ||||
3168082 | 3168082 | 2021-08-23 | US | Ohio | Delaware | 39041 | 20038 | 140 | 0 | 40.27942393 | -83.00457058 | 2021-08-24 04:21:19 | Delaware, Ohio, US | |
781490 | 781490 | 2021-07-08 | US | Texas | Jefferson | 48245 | 20038 | 443 | 0 | 29.8832777 | -94.16434171 | 2021-07-09 04:21:21 | Jefferson, Texas, US | |
400217 | 400217 | 2021-06-29 | India | Ladakh | 20038 | 202 | 19565 | 271 | 34.1526 | 77.5771 | 2021-06-30 04:21:41 | Ladakh, India | ||
1636538 | 1636538 | 2021-04-29 | Russia | Mordovia Republic | 20038 | 242 | 18047 | 1749 | 54.4419829 | 44.4661144 | 2021-04-30 04:21:03 | Mordovia Republic, Russia | ||
3393600 | 3393600 | 2021-04-28 | Russia | Karachay-Cherkess Republic | 20038 | 73 | 19895 | 70 | 43.7368326 | 41.7267991 | 2021-04-29 04:20:55 | Karachay-Cherkess Republic, Russia | ||
3131995 | 3131995 | 2021-04-18 | US | Ohio | Lake | 39085 | 20038 | 369 | 0 | 41.69710807 | -81.23676539 | 2021-04-19 04:20:57 | Lake, Ohio, US | |
1842661 | 1842661 | 2021-04-14 | US | Florida | Okaloosa | 12091 | 20038 | 357 | 0 | 30.69143028 | -86.59267105 | 2021-04-15 04:20:54 | Okaloosa, Florida, US | |
3087588 | 3087588 | 2021-04-05 | US | North Carolina | Cabarrus | 37025 | 20038 | 242 | 0 | 35.3877799 | -80.55267168 | 2021-04-06 04:20:32 | Cabarrus, North Carolina, US | |
2059470 | 2059470 | 2021-03-15 | US | Wisconsin | Winnebago | 55139 | 20038 | 205 | 0 | 44.06886922 | -88.64477096 | 2021-03-16 05:25:13 | Winnebago, Wisconsin, US | |
926509 | 926509 | 2020-11-26 | US | South Carolina | Richland | 45079 | 20038 | 298 | 0 | 19740 | 34.01791263 | -80.90267209 | 2020-11-27 05:26:53 | Richland, South Carolina, US |
1975414 | 1975414 | 2020-11-25 | US | South Carolina | Richland | 45079 | 20038 | 298 | 0 | 19740 | 34.01791263 | -80.90267209 | 2020-11-26 05:27:44 | Richland, South Carolina, 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]);