johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where confirmed = 16435 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1489942 | 1489942 | 2022-07-26 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-27 04:21:04 | Pender, North Carolina, US | |
2596388 | 2596388 | 2022-07-25 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-26 04:20:58 | Pender, North Carolina, US | |
898503 | 898503 | 2022-07-24 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-25 04:20:51 | Pender, North Carolina, US | |
93497 | 93497 | 2022-07-23 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-24 04:20:47 | Pender, North Carolina, US | |
902519 | 902519 | 2022-07-22 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-23 04:20:53 | Pender, North Carolina, US | |
672655 | 672655 | 2022-07-21 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-22 04:21:15 | Pender, North Carolina, US | |
1610618 | 1610618 | 2022-07-20 | US | North Carolina | Pender | 37141 | 16435 | 133 | 0 | 34.52265624 | -77.90352133 | 2022-07-21 04:21:10 | Pender, North Carolina, US | |
2240274 | 2240274 | 2022-06-28 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-29 04:20:59 | Spalding, Georgia, US | |
2148516 | 2148516 | 2022-06-27 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-28 04:20:58 | Spalding, Georgia, US | |
476317 | 476317 | 2022-06-26 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-27 04:21:00 | Spalding, Georgia, US | |
939692 | 939692 | 2022-06-25 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-26 04:21:02 | Spalding, Georgia, US | |
3347512 | 3347512 | 2022-06-24 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-25 04:20:57 | Spalding, Georgia, US | |
1649253 | 1649253 | 2022-06-23 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-24 04:20:58 | Spalding, Georgia, US | |
2188488 | 2188488 | 2022-06-22 | US | Georgia | Spalding | 13255 | 16435 | 423 | 0 | 33.26310031 | -84.28013991 | 2022-06-23 04:20:55 | Spalding, Georgia, US | |
166535 | 166535 | 2022-06-21 | US | Arkansas | Greene | 5055 | 16435 | 175 | 0 | 36.1173546 | -90.55832668 | 2022-06-22 04:20:54 | Greene, Arkansas, US | |
2054387 | 2054387 | 2022-01-25 | US | Ohio | Pickaway | 39129 | 16435 | 207 | 0 | 39.64170392 | -83.0243386 | 2022-01-26 04:21:07 | Pickaway, Ohio, US | |
1033987 | 1033987 | 2021-12-06 | US | Wyoming | Natrona | 56025 | 16435 | 219 | 0 | 42.96180148 | -106.79788500000001 | 2021-12-07 04:22:34 | Natrona, Wyoming, US | |
1014253 | 1014253 | 2021-11-21 | Iceland | 16435 | 34 | 0 | 64.9631 | -19.0208 | 2021-11-22 04:22:20 | Iceland | ||||
722417 | 722417 | 2021-11-20 | Iceland | 16435 | 34 | 0 | 64.9631 | -19.0208 | 2021-11-21 04:22:13 | Iceland | ||||
161947 | 161947 | 2021-11-19 | Iceland | 16435 | 34 | 0 | 64.9631 | -19.0208 | 2021-11-20 04:22:17 | Iceland | ||||
45723 | 45723 | 2021-11-02 | US | Montana | Missoula | 30063 | 16435 | 164 | 0 | 47.03728583 | -113.92135079999998 | 2021-11-03 06:22:09 | Missoula, Montana, US | |
3906887 | 3906887 | 2021-07-31 | US | Tennessee | Blount | 47009 | 16435 | 203 | 0 | 35.68938198 | -83.92847788 | 2021-08-01 04:21:50 | Blount, Tennessee, US | |
410972 | 410972 | 2021-07-28 | US | Pennsylvania | Lebanon | 42075 | 16435 | 295 | 0 | 40.36680311 | -76.45651841 | 2021-07-29 04:21:33 | Lebanon, Pennsylvania, US | |
1935995 | 1935995 | 2021-07-05 | US | Wisconsin | Marathon | 55073 | 16435 | 227 | 0 | 44.89792533 | -89.75863384 | 2021-07-06 04:21:32 | Marathon, Wisconsin, US | |
242150 | 242150 | 2021-04-02 | US | Georgia | Whitfield | 13313 | 16435 | 237 | 0 | 34.80987459 | -84.96093476 | 2021-04-03 04:20:44 | Whitfield, Georgia, US | |
2457335 | 2457335 | 2020-09-19 | US | Oklahoma | Oklahoma | 40109 | 16435 | 180 | 0 | 16255 | 35.55140095 | -97.40716948 | 2020-09-20 04:22:00 | Oklahoma, Oklahoma, US |
3161775 | 3161775 | 2020-09-06 | Peru | Cusco | 16435 | 1145 | 0 | 15290 | -13.191068 | -72.153609 | 2020-09-07 04:28:30 | Cusco, Peru |
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]);