daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

15 rows where "day" is on date 2020-06-09 and province_or_state = "Vermont" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Vermont · 15 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-09 US Vermont Addison 50001 66 2 0 64 44.03217337 -73.14130877 2020-06-10 04:07:00 Addison, Vermont, US
2020-06-09 US Vermont Bennington 50003 66 1 0 65 43.03519828 -73.09048868 2020-06-10 04:07:00 Bennington, Vermont, US
2020-06-09 US Vermont Caledonia 50005 16 0 0 16 44.46548598 -72.10314651 2020-06-10 04:07:00 Caledonia, Vermont, US
2020-06-09 US Vermont Chittenden 50007 535 39 0 496 44.46322849 -73.08359212 2020-06-10 04:07:00 Chittenden, Vermont, US
2020-06-09 US Vermont Essex 50009 3 0 0 3 44.72736416 -71.73579864 2020-06-10 04:07:00 Essex, Vermont, US
2020-06-09 US Vermont Franklin 50011 100 5 0 95 44.85627605 -72.91249563 2020-06-10 04:07:00 Franklin, Vermont, US
2020-06-09 US Vermont Grand Isle 50013 7 0 0 7 44.797582399999996 -73.29679772 2020-06-10 04:07:00 Grand Isle, Vermont, US
2020-06-09 US Vermont Lamoille 50015 29 1 0 28 44.60353043 -72.64356694 2020-06-10 04:07:00 Lamoille, Vermont, US
2020-06-09 US Vermont Orange 50017 9 0 0 9 44.00470222 -72.37640104 2020-06-10 04:07:00 Orange, Vermont, US
2020-06-09 US Vermont Orleans 50019 13 0 0 13 44.82964024 -72.24562697 2020-06-10 04:07:00 Orleans, Vermont, US
2020-06-09 US Vermont Rutland 50021 57 1 0 56 43.57723578 -73.03741676 2020-06-10 04:07:00 Rutland, Vermont, US
2020-06-09 US Vermont Unassigned 90050 5 0 0 5 44.85627605 0.0 2020-06-10 04:07:00 Unassigned, Vermont, US
2020-06-09 US Vermont Washington 50023 39 1 0 38 44.27343241 -72.61604978 2020-06-10 04:07:00 Washington, Vermont, US
2020-06-09 US Vermont Windham 50025 83 3 0 80 42.986982 -72.71268875 2020-06-10 04:07:00 Windham, Vermont, US
2020-06-09 US Vermont Windsor 50027 56 2 0 54 43.58010937 -72.58595157 2020-06-10 04:07:00 Windsor, Vermont, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;