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 country_or_region = "US", "day" is on date 2022-04-16 and province_or_state = "Vermont" sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-04-16 US Vermont Addison 50001 5653 15 0   44.03217337 -73.14130877 2022-04-17 04:20:59 Addison, Vermont, US
2022-04-16 US Vermont Bennington 50003 9524 69 0   43.03519828 -73.09048868 2022-04-17 04:20:59 Bennington, Vermont, US
2022-04-16 US Vermont Caledonia 50005 5718 24 0   44.46548598 -72.10314651 2022-04-17 04:20:59 Caledonia, Vermont, US
2022-04-16 US Vermont Chittenden 50007 32039 167 0   44.46322849 -73.08359212 2022-04-17 04:20:59 Chittenden, Vermont, US
2022-04-16 US Vermont Essex 50009 1285 3 0   44.72736416 -71.73579864 2022-04-17 04:20:59 Essex, Vermont, US
2022-04-16 US Vermont Franklin 50011 9718 66 0   44.85627605 -72.91249563 2022-04-17 04:20:59 Franklin, Vermont, US
2022-04-16 US Vermont Grand Isle 50013 1053 5 0   44.797582399999996 -73.29679772 2022-04-17 04:20:59 Grand Isle, Vermont, US
2022-04-16 US Vermont Lamoille 50015 3894 17 0   44.60353043 -72.64356694 2022-04-17 04:20:59 Lamoille, Vermont, US
2022-04-16 US Vermont Orange 50017 4900 14 0   44.00470222 -72.37640104 2022-04-17 04:20:59 Orange, Vermont, US
2022-04-16 US Vermont Orleans 50019 6328 37 0   44.82964024 -72.24562697 2022-04-17 04:20:59 Orleans, Vermont, US
2022-04-16 US Vermont Rutland 50021 12632 73 0   43.57723578 -73.03741676 2022-04-17 04:20:59 Rutland, Vermont, US
2022-04-16 US Vermont Unassigned 90050 1092 1 0   44.85627605 0.0 2022-04-17 04:20:59 Unassigned, Vermont, US
2022-04-16 US Vermont Washington 50023 10176 47 0   44.27343241 -72.61604978 2022-04-17 04:20:59 Washington, Vermont, US
2022-04-16 US Vermont Windham 50025 6730 35 0   42.986982 -72.71268875 2022-04-17 04:20:59 Windham, Vermont, US
2022-04-16 US Vermont Windsor 50027 8871 50 0   43.58010937 -72.58595157 2022-04-17 04:20:59 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;