johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where confirmed = 1790, country_or_region = "US" and province_or_state = "Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 25 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3573975 | 3573975 | 2022-09-19 | US | Virginia | Mathews | 51115 | 1790 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-09-20 04:22:48 | Mathews, Virginia, US | |
3025638 | 3025638 | 2022-03-23 | US | Virginia | Lancaster | 51103 | 1790 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-03-24 04:20:43 | Lancaster, Virginia, US | |
1908560 | 1908560 | 2022-03-22 | US | Virginia | Lancaster | 51103 | 1790 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-03-23 04:20:48 | Lancaster, Virginia, US | |
3241691 | 3241691 | 2022-03-21 | US | Virginia | Lancaster | 51103 | 1790 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-03-22 04:20:54 | Lancaster, Virginia, US | |
2528742 | 2528742 | 2022-03-02 | US | Virginia | Middlesex | 51119 | 1790 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-03-03 04:21:01 | Middlesex, Virginia, US | |
3522770 | 3522770 | 2022-01-02 | US | Virginia | Floyd | 51063 | 1790 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-03 02:22:25 | Floyd, Virginia, US | |
2170900 | 2170900 | 2022-01-01 | US | Virginia | Floyd | 51063 | 1790 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-02 04:20:52 | Floyd, Virginia, US | |
2780331 | 2780331 | 2021-12-31 | US | Virginia | Floyd | 51063 | 1790 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-01 04:22:14 | Floyd, Virginia, US | |
1238993 | 1238993 | 2021-09-27 | US | Virginia | Greensville | 51081 | 1790 | 26 | 0 | 36.67878901 | -77.56351439 | 2021-09-28 04:21:28 | Greensville, Virginia, US | |
653322 | 653322 | 2021-08-09 | US | Virginia | King George | 51099 | 1790 | 20 | 0 | 38.26818502 | -77.15852768 | 2021-08-10 04:21:27 | King George, Virginia, US | |
3388708 | 3388708 | 2021-07-29 | US | Virginia | Colonial Heights | 51570 | 1790 | 60 | 0 | 37.26420587 | -77.39609676 | 2021-07-30 04:21:34 | Colonial Heights, Virginia, US | |
891520 | 891520 | 2021-04-26 | US | Virginia | Scott | 51169 | 1790 | 52 | 0 | 36.71466456 | -82.60171704 | 2021-04-27 04:20:52 | Scott, Virginia, US | |
958265 | 958265 | 2021-04-25 | US | Virginia | Scott | 51169 | 1790 | 52 | 0 | 36.71466456 | -82.60171704 | 2021-04-26 04:21:04 | Scott, Virginia, US | |
1305409 | 1305409 | 2021-04-01 | US | Virginia | Louisa | 51109 | 1790 | 27 | 0 | 37.97850256 | -77.96274807 | 2021-04-02 04:20:36 | Louisa, Virginia, US | |
3670954 | 3670954 | 2021-03-06 | US | Virginia | Fredericksburg | 51630 | 1790 | 22 | 0 | 1768 | 38.2977863 | -77.4922454 | 2021-03-07 05:21:54 | Fredericksburg, Virginia, US |
1861380 | 1861380 | 2021-02-25 | US | Virginia | Nottoway | 51135 | 1790 | 32 | 0 | 1758 | 37.1435975 | -78.05065922 | 2021-02-26 05:22:40 | Nottoway, Virginia, US |
617085 | 617085 | 2021-02-08 | US | Virginia | Salem | 51775 | 1790 | 33 | 0 | 1757 | 37.2836193 | -80.06219455 | 2021-02-09 05:23:30 | Salem, Virginia, US |
1900572 | 1900572 | 2021-01-29 | US | Virginia | Wythe | 51197 | 1790 | 35 | 0 | 1755 | 36.91582035 | -81.07834059 | 2021-01-30 05:22:49 | Wythe, Virginia, US |
3157018 | 3157018 | 2021-01-27 | US | Virginia | Waynesboro | 51820 | 1790 | 22 | 0 | 1768 | 38.06451466 | -78.90293905 | 2021-01-28 05:22:24 | Waynesboro, Virginia, US |
777700 | 777700 | 2021-01-12 | US | Virginia | Lee | 51105 | 1790 | 32 | 0 | 1758 | 36.70586667 | -83.12606515 | 2021-01-13 05:22:15 | Lee, Virginia, US |
157397 | 157397 | 2021-01-08 | US | Virginia | Winchester | 51840 | 1790 | 16 | 0 | 1774 | 39.17054517 | -78.17325058 | 2021-01-09 05:22:18 | Winchester, Virginia, US |
2410246 | 2410246 | 2020-12-23 | US | Virginia | Wise | 51195 | 1790 | 53 | 0 | 1737 | 36.9746148 | -82.62410519 | 2020-12-24 05:23:04 | Wise, Virginia, US |
2350740 | 2350740 | 2020-12-07 | US | Virginia | Danville | 51590 | 1790 | 51 | 0 | 1739 | 36.58022376 | -79.40395668 | 2020-12-08 05:27:42 | Danville, Virginia, US |
613036 | 613036 | 2020-08-29 | US | Virginia | Manassas | 51683 | 1790 | 23 | 0 | 1767 | 38.7464321 | -77.48509905 | 2020-08-30 04:28:22 | Manassas, Virginia, US |
1704529 | 1704529 | 2020-07-21 | US | Virginia | Chesapeake | 51550 | 1790 | 24 | 0 | 1766 | 36.67670048 | -76.30545744 | 2020-07-22 04:34:42 | Chesapeake, 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]);