johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 30763 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1767910 | 1767910 | 2022-07-03 | US | California | Napa | 6055 | 30763 | 145 | 0 | 38.50735751 | -122.332839 | 2022-07-04 04:20:54 | Napa, California, US | |
3365896 | 3365896 | 2022-07-02 | US | California | Napa | 6055 | 30763 | 145 | 0 | 38.50735751 | -122.332839 | 2022-07-03 04:20:59 | Napa, California, US | |
594225 | 594225 | 2022-07-01 | US | California | Napa | 6055 | 30763 | 145 | 0 | 38.50735751 | -122.332839 | 2022-07-02 04:21:16 | Napa, California, US | |
3537622 | 3537622 | 2022-05-10 | US | New Hampshire | Strafford | 33017 | 30763 | 209 | 0 | 43.291833 | -71.02336013 | 2022-05-11 04:20:48 | Strafford, New Hampshire, US | |
3919272 | 3919272 | 2022-05-01 | US | Texas | Tom Green | 48451 | 30763 | 465 | 0 | 31.40464436 | -100.462443 | 2022-05-02 04:21:10 | Tom Green, Texas, US | |
3238851 | 3238851 | 2022-03-21 | US | Arkansas | Saline | 5125 | 30763 | 327 | 0 | 34.64916145 | -92.67583224 | 2022-03-22 04:20:54 | Saline, Arkansas, US | |
2266615 | 2266615 | 2022-03-14 | US | Puerto Rico | Bayamon | 72021 | 30763 | 0 | 0 | 18.34946 | -66.168435 | 2022-03-15 04:20:47 | Bayamon, Puerto Rico, US | |
1231542 | 1231542 | 2021-11-28 | Guinea | 30763 | 387 | 0 | 9.9456 | -9.6966 | 2021-11-29 04:22:30 | Guinea | ||||
1358249 | 1358249 | 2021-11-27 | Guinea | 30763 | 387 | 0 | 9.9456 | -9.6966 | 2021-11-28 04:22:43 | Guinea | ||||
2808708 | 2808708 | 2021-09-16 | India | Nagaland | 30763 | 648 | 0 | 26.06702 | 94.470302 | 2021-09-17 04:21:46 | Nagaland, India | |||
2451538 | 2451538 | 2021-05-02 | US | Georgia | Cherokee | 13057 | 30763 | 316 | 0 | 34.24393976 | -84.47431861 | 2021-05-03 04:20:39 | Cherokee, Georgia, US | |
1411199 | 1411199 | 2021-04-23 | US | New Jersey | Atlantic | 34001 | 30763 | 651 | 0 | 39.47538693 | -74.65848483 | 2021-04-24 04:20:38 | Atlantic, New Jersey, US | |
3421495 | 3421495 | 2021-03-19 | US | California | Solano | 6095 | 30763 | 172 | 0 | 38.26827353 | -121.9357113 | 2021-03-20 05:25:46 | Solano, California, US | |
1153829 | 1153829 | 2021-02-18 | US | Florida | Manatee | 12081 | 30763 | 568 | 0 | 30195 | 27.47196942 | -82.31831044 | 2021-02-19 05:24:16 | Manatee, Florida, US |
1005277 | 1005277 | 2020-07-09 | Brazil | Amapa | 30763 | 467 | 19644 | 10652 | 0.902 | -52.003 | 2020-07-10 04:34:24 | Amapa, Brazil |
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]);