johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where confirmed = 30355 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717383 | 3717383 | 2022-12-06 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-07 04:20:58 | Rockwall, Texas, US | |
2418088 | 2418088 | 2022-12-05 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-06 04:21:03 | Rockwall, Texas, US | |
721696 | 721696 | 2022-12-04 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-05 04:20:58 | Rockwall, Texas, US | |
2819985 | 2819985 | 2022-12-03 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-04 04:20:56 | Rockwall, Texas, US | |
836841 | 836841 | 2022-12-02 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-03 04:21:02 | Rockwall, Texas, US | |
2139371 | 2139371 | 2022-12-01 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-02 04:21:07 | Rockwall, Texas, US | |
1967787 | 1967787 | 2022-11-30 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-01 04:21:03 | Rockwall, Texas, US | |
1052944 | 1052944 | 2022-11-06 | US | Texas | Grayson | 48181 | 30355 | 663 | 0 | 33.62744998 | -96.67753461 | 2022-11-07 04:21:26 | Grayson, Texas, US | |
620968 | 620968 | 2022-11-05 | US | Texas | Grayson | 48181 | 30355 | 663 | 0 | 33.62744998 | -96.67753461 | 2022-11-06 04:21:24 | Grayson, Texas, US | |
1025472 | 1025472 | 2022-11-04 | US | Texas | Grayson | 48181 | 30355 | 663 | 0 | 33.62744998 | -96.67753461 | 2022-11-05 04:21:52 | Grayson, Texas, US | |
2672806 | 2672806 | 2022-04-15 | US | Tennessee | Sevier | 47155 | 30355 | 415 | 0 | 35.78077323 | -83.52244332 | 2022-04-16 04:20:48 | Sevier, Tennessee, US | |
1437599 | 1437599 | 2022-03-28 | US | Illinois | Macon | 17115 | 30355 | 340 | 0 | 39.86064913 | -88.96342505 | 2022-03-29 04:20:46 | Macon, Illinois, US | |
3241559 | 3241559 | 2022-03-21 | US | Texas | Taylor | 48441 | 30355 | 713 | 0 | 32.30163422 | -99.89007449 | 2022-03-22 04:20:54 | Taylor, Texas, US | |
1057921 | 1057921 | 2022-02-23 | Mali | 30355 | 722 | 0 | 17.570692 | -3.996166000000001 | 2022-02-24 04:21:14 | Mali | ||||
3425174 | 3425174 | 2022-01-21 | Russia | Mari El Republic | 30355 | 961 | 0 | 56.576750399999995 | 47.881751200000004 | 2022-01-22 04:21:13 | Mari El Republic, Russia | |||
582100 | 582100 | 2021-07-13 | US | Utah | Southwest Utah | 30355 | 285 | 0 | 37.85447192 | -111.4418764 | 2021-07-14 04:21:35 | Southwest Utah, Utah, US | ||
3659726 | 3659726 | 2021-07-11 | Netherlands | Zeeland | 30355 | 249 | 0 | 30056 | 51.47936 | 3.861559 | 2021-07-12 04:21:34 | Zeeland, Netherlands | ||
3090031 | 3090031 | 2021-05-30 | US | Colorado | Douglas | 8035 | 30355 | 242 | 0 | 39.33133796 | -104.930001 | 2021-05-31 03:08:59 | Douglas, Colorado, US | |
909738 | 909738 | 2021-01-19 | US | Maryland | Anne Arundel | 24003 | 30355 | 424 | 0 | 29931 | 39.00670238 | -76.60329337 | 2021-01-20 05:21:54 | Anne Arundel, Maryland, US |
3859675 | 3859675 | 2020-12-04 | Colombia | Cesar | 30355 | 923 | 27620 | 1812 | 9.3373 | -73.6536 | 2020-12-05 05:27:36 | Cesar, Colombia | ||
2537245 | 2537245 | 2020-12-01 | Colombia | Huila | 30355 | 969 | 28469 | 917 | 2.5359 | -75.5277 | 2020-12-02 05:27:41 | Huila, Colombia |
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]);