johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "US", deaths = 251 and province_or_state = "West Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
466883 | 466883 | 2022-05-02 | US | West Virginia | Harrison | 54033 | 19907 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-05-03 04:21:00 | Harrison, West Virginia, US | |
3919522 | 3919522 | 2022-05-01 | US | West Virginia | Harrison | 54033 | 19888 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-05-02 04:21:10 | Harrison, West Virginia, US | |
2844326 | 2844326 | 2022-04-30 | US | West Virginia | Harrison | 54033 | 19888 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-05-01 04:20:57 | Harrison, West Virginia, US | |
1160639 | 1160639 | 2022-04-29 | US | West Virginia | Harrison | 54033 | 19888 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-04-30 04:21:05 | Harrison, West Virginia, US | |
1699821 | 1699821 | 2022-04-28 | US | West Virginia | Harrison | 54033 | 19881 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-04-29 04:20:59 | Harrison, West Virginia, US | |
3855304 | 3855304 | 2022-04-27 | US | West Virginia | Harrison | 54033 | 19874 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-04-28 04:20:47 | Harrison, West Virginia, US | |
1329734 | 1329734 | 2022-04-26 | US | West Virginia | Harrison | 54033 | 19870 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-04-27 04:20:52 | Harrison, West Virginia, US | |
2481458 | 2481458 | 2022-03-30 | US | West Virginia | Harrison | 54033 | 19780 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-03-31 04:20:56 | Harrison, West Virginia, US | |
161499 | 161499 | 2022-03-29 | US | West Virginia | Harrison | 54033 | 19778 | 251 | 0 | 39.2853852 | -80.37919577 | 2022-03-30 04:20:45 | Harrison, West Virginia, US | |
3675124 | 3675124 | 2022-02-15 | US | West Virginia | Berkeley | 54003 | 34828 | 251 | 0 | 39.46704621 | -78.02414609 | 2022-02-16 04:21:10 | Berkeley, West Virginia, US | |
2645225 | 2645225 | 2022-02-14 | US | West Virginia | Berkeley | 54003 | 34804 | 251 | 0 | 39.46704621 | -78.02414609 | 2022-02-15 04:21:09 | Berkeley, West Virginia, US | |
189542 | 189542 | 2022-02-13 | US | West Virginia | Berkeley | 54003 | 34782 | 251 | 0 | 39.46704621 | -78.02414609 | 2022-02-14 04:20:51 | Berkeley, West Virginia, US | |
319388 | 319388 | 2022-02-12 | US | West Virginia | Berkeley | 54003 | 34735 | 251 | 0 | 39.46704621 | -78.02414609 | 2022-02-13 04:21:00 | Berkeley, West Virginia, US | |
236714 | 236714 | 2022-02-11 | US | West Virginia | Berkeley | 54003 | 34691 | 251 | 0 | 39.46704621 | -78.02414609 | 2022-02-12 04:21:06 | Berkeley, West Virginia, US | |
1467556 | 1467556 | 2022-02-10 | US | West Virginia | Berkeley | 54003 | 34625 | 251 | 0 | 39.46704621 | -78.02414609 | 2022-02-11 04:21:09 | Berkeley, West Virginia, US | |
2004185 | 2004185 | 2021-11-07 | US | West Virginia | Wood | 54107 | 13382 | 251 | 0 | 39.20967886 | -81.5162836 | 2021-11-08 04:21:43 | Wood, West Virginia, US | |
499176 | 499176 | 2021-11-06 | US | West Virginia | Wood | 54107 | 13353 | 251 | 0 | 39.20967886 | -81.5162836 | 2021-11-07 04:21:53 | Wood, West Virginia, US | |
3125031 | 3125031 | 2021-11-05 | US | West Virginia | Wood | 54107 | 13324 | 251 | 0 | 39.20967886 | -81.5162836 | 2021-11-06 04:21:51 | Wood, West Virginia, US | |
495110 | 495110 | 2021-10-14 | US | West Virginia | Cabell | 54011 | 14382 | 251 | 0 | 38.42424062 | -82.23855912 | 2021-10-15 04:21:26 | Cabell, West Virginia, US | |
2571143 | 2571143 | 2021-01-25 | US | West Virginia | Kanawha | 54039 | 10718 | 251 | 0 | 10467 | 38.33860077 | -81.52857054 | 2021-01-26 05:22:02 | Kanawha, West Virginia, US |
1762775 | 1762775 | 2021-01-24 | US | West Virginia | Kanawha | 54039 | 10678 | 251 | 0 | 10427 | 38.33860077 | -81.52857054 | 2021-01-25 05:22:16 | Kanawha, West Virginia, 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]);