johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where country_or_region = "US", deaths = 272 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 · 34 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3380686 | 3380686 | 2022-12-08 | US | Virginia | Bedford | 51019 | 20886 | 272 | 0 | 37.3080028 | -79.5281964 | 2022-12-09 04:21:05 | Bedford, Virginia, US | |
2139503 | 2139503 | 2022-12-01 | US | Virginia | Frederick | 51069 | 25366 | 272 | 0 | 39.20172582 | -78.25974949 | 2022-12-02 04:21:07 | Frederick, Virginia, US | |
1967919 | 1967919 | 2022-11-30 | US | Virginia | Frederick | 51069 | 25349 | 272 | 0 | 39.20172582 | -78.25974949 | 2022-12-01 04:21:03 | Frederick, Virginia, US | |
2744369 | 2744369 | 2022-07-07 | US | Virginia | Henry | 51089 | 13205 | 272 | 0 | 36.68542395 | -79.87634026 | 2022-07-08 04:20:56 | Henry, Virginia, US | |
879634 | 879634 | 2022-03-27 | US | Virginia | Lynchburg | 51680 | 20323 | 272 | 0 | 37.40021399 | -79.19888138 | 2022-03-28 04:20:33 | Lynchburg, Virginia, US | |
2166917 | 2166917 | 2022-03-26 | US | Virginia | Lynchburg | 51680 | 20323 | 272 | 0 | 37.40021399 | -79.19888138 | 2022-03-27 04:20:47 | Lynchburg, Virginia, US | |
1723853 | 1723853 | 2022-03-25 | US | Virginia | Lynchburg | 51680 | 20323 | 272 | 0 | 37.40021399 | -79.19888138 | 2022-03-26 04:20:23 | Lynchburg, Virginia, US | |
2322685 | 2322685 | 2022-03-16 | US | Virginia | Hanover | 51085 | 21533 | 272 | 0 | 37.7583355 | -77.49464673 | 2022-03-17 04:20:56 | Hanover, Virginia, US | |
1551374 | 1551374 | 2022-03-07 | US | Virginia | Roanoke | 51161 | 21174 | 272 | 0 | 37.26865804 | -80.06396753 | 2022-03-08 04:20:54 | Roanoke, Virginia, US | |
1996072 | 1996072 | 2022-03-01 | US | Virginia | Spotsylvania | 51177 | 26238 | 272 | 0 | 38.18574462 | -77.655399 | 2022-03-02 04:21:07 | Spotsylvania, Virginia, US | |
946246 | 946246 | 2022-02-28 | US | Virginia | Spotsylvania | 51177 | 26213 | 272 | 0 | 38.18574462 | -77.655399 | 2022-03-01 04:21:09 | Spotsylvania, Virginia, US | |
2645169 | 2645169 | 2022-02-14 | US | Virginia | Suffolk | 51800 | 18345 | 272 | 0 | 36.70155394 | -76.63603554 | 2022-02-15 04:21:09 | Suffolk, Virginia, US | |
3522836 | 3522836 | 2022-01-02 | US | Virginia | Roanoke City | 51770 | 14290 | 272 | 0 | 37.27791025 | -79.96189766 | 2022-01-03 02:22:25 | Roanoke City, Virginia, US | |
2170966 | 2170966 | 2022-01-01 | US | Virginia | Roanoke City | 51770 | 14290 | 272 | 0 | 37.27791025 | -79.96189766 | 2022-01-02 04:20:52 | Roanoke City, Virginia, US | |
2780397 | 2780397 | 2021-12-31 | US | Virginia | Roanoke City | 51770 | 14290 | 272 | 0 | 37.27791025 | -79.96189766 | 2022-01-01 04:22:14 | Roanoke City, Virginia, US | |
2003964 | 2003964 | 2021-11-07 | US | Virginia | Arlington | 51013 | 18766 | 272 | 0 | 38.8767675 | -77.10139853 | 2021-11-08 04:21:43 | Arlington, Virginia, US | |
498955 | 498955 | 2021-11-06 | US | Virginia | Arlington | 51013 | 18766 | 272 | 0 | 38.8767675 | -77.10139853 | 2021-11-07 04:21:53 | Arlington, Virginia, US | |
3124810 | 3124810 | 2021-11-05 | US | Virginia | Arlington | 51013 | 18766 | 272 | 0 | 38.8767675 | -77.10139853 | 2021-11-06 04:21:51 | Arlington, Virginia, US | |
701708 | 701708 | 2021-11-04 | US | Virginia | Arlington | 51013 | 18739 | 272 | 0 | 38.8767675 | -77.10139853 | 2021-11-05 04:21:54 | Arlington, Virginia, US | |
279486 | 279486 | 2021-11-03 | US | Virginia | Arlington | 51013 | 18722 | 272 | 0 | 38.8767675 | -77.10139853 | 2021-11-04 04:22:20 | Arlington, Virginia, US | |
2697065 | 2697065 | 2021-07-06 | US | Virginia | Norfolk | 51710 | 18078 | 272 | 0 | 36.89934014 | -76.26420872 | 2021-07-07 04:21:20 | Norfolk, Virginia, US | |
1935814 | 1935814 | 2021-07-05 | US | Virginia | Norfolk | 51710 | 18074 | 272 | 0 | 36.89934014 | -76.26420872 | 2021-07-06 04:21:32 | Norfolk, Virginia, US | |
1168545 | 1168545 | 2021-07-04 | US | Virginia | Norfolk | 51710 | 18069 | 272 | 0 | 36.89934014 | -76.26420872 | 2021-07-05 04:21:28 | Norfolk, Virginia, US | |
1498979 | 1498979 | 2021-07-03 | US | Virginia | Norfolk | 51710 | 18066 | 272 | 0 | 36.89934014 | -76.26420872 | 2021-07-04 04:21:38 | Norfolk, Virginia, US | |
2075294 | 2075294 | 2021-07-02 | US | Virginia | Norfolk | 51710 | 18059 | 272 | 0 | 36.89934014 | -76.26420872 | 2021-07-03 04:21:37 | Norfolk, Virginia, US | |
2075314 | 2075314 | 2021-07-02 | US | Virginia | Richmond City | 51760 | 17083 | 272 | 0 | 37.53255773 | -77.47966921 | 2021-07-03 04:21:37 | Richmond City, Virginia, US | |
2768310 | 2768310 | 2021-07-01 | US | Virginia | Norfolk | 51710 | 18053 | 272 | 0 | 36.89934014 | -76.26420872 | 2021-07-02 04:21:47 | Norfolk, Virginia, US | |
2768330 | 2768330 | 2021-07-01 | US | Virginia | Richmond City | 51760 | 17120 | 272 | 0 | 37.53255773 | -77.47966921 | 2021-07-02 04:21:47 | Richmond City, Virginia, US | |
1896538 | 1896538 | 2021-06-30 | US | Virginia | Richmond City | 51760 | 17139 | 272 | 0 | 37.53255773 | -77.47966921 | 2021-07-01 04:21:19 | Richmond City, Virginia, US | |
403661 | 403661 | 2021-06-29 | US | Virginia | Richmond City | 51760 | 17150 | 272 | 0 | 37.53255773 | -77.47966921 | 2021-06-30 04:21:41 | Richmond City, Virginia, US | |
3362065 | 3362065 | 2021-06-21 | US | Virginia | Richmond City | 51760 | 17145 | 272 | 0 | 37.53255773 | -77.47966921 | 2021-06-22 04:21:34 | Richmond City, Virginia, US | |
2887764 | 2887764 | 2021-06-20 | US | Virginia | Richmond City | 51760 | 17142 | 272 | 0 | 37.53255773 | -77.47966921 | 2021-06-21 04:21:41 | Richmond City, Virginia, US | |
641234 | 641234 | 2021-03-31 | US | Virginia | Chesapeake | 51550 | 19503 | 272 | 0 | 36.67670048 | -76.30545744 | 2021-04-01 04:27:05 | Chesapeake, Virginia, US | |
1904509 | 1904509 | 2020-12-18 | US | Virginia | Henrico | 51087 | 10488 | 272 | 0 | 10216 | 37.53460572 | -77.39326555 | 2020-12-19 05:27:52 | Henrico, 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]);