daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 2281, country_or_region = "US" and province_or_state = "Texas" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-08-10 | US | Texas | Gaines | 48165 | 2281 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-08-11 04:20:49 | Gaines, Texas, US | |
2022-07-31 | US | Texas | Clay | 48077 | 2281 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-08-01 04:21:03 | Clay, Texas, US | |
2022-07-30 | US | Texas | Clay | 48077 | 2281 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-07-31 04:21:02 | Clay, Texas, US | |
2022-07-29 | US | Texas | Clay | 48077 | 2281 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-07-30 04:20:42 | Clay, Texas, US | |
2022-07-09 | US | Texas | Franklin | 48159 | 2281 | 44 | 0 | 33.17653242 | -95.21917243 | 2022-07-10 04:20:54 | Franklin, Texas, US | |
2022-04-17 | US | Texas | Swisher | 48437 | 2281 | 34 | 0 | 34.53028891 | -101.73491740000001 | 2022-04-18 04:21:12 | Swisher, Texas, US | |
2022-04-16 | US | Texas | Swisher | 48437 | 2281 | 34 | 0 | 34.53028891 | -101.73491740000001 | 2022-04-17 04:20:59 | Swisher, Texas, US | |
2022-04-15 | US | Texas | Swisher | 48437 | 2281 | 34 | 0 | 34.53028891 | -101.73491740000001 | 2022-04-16 04:20:48 | Swisher, Texas, US | |
2022-04-14 | US | Texas | Swisher | 48437 | 2281 | 34 | 0 | 34.53028891 | -101.73491740000001 | 2022-04-15 04:20:57 | Swisher, Texas, US | |
2022-03-30 | US | Texas | Castro | 48069 | 2281 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-03-31 04:20:56 | Castro, Texas, US | |
2022-03-18 | US | Texas | Runnels | 48399 | 2281 | 65 | 0 | 31.8314342 | -99.97616148 | 2022-03-19 04:20:47 | Runnels, Texas, US | |
2022-03-14 | US | Texas | Red River | 48387 | 2281 | 64 | 0 | 33.61886692 | -95.04841765 | 2022-03-15 04:20:47 | Red River, Texas, US | |
2022-03-13 | US | Texas | Red River | 48387 | 2281 | 64 | 0 | 33.61886692 | -95.04841765 | 2022-03-14 04:20:46 | Red River, Texas, US | |
2022-03-12 | US | Texas | Red River | 48387 | 2281 | 64 | 0 | 33.61886692 | -95.04841765 | 2022-03-13 04:20:49 | Red River, Texas, US | |
2022-01-13 | US | Texas | Duval | 48131 | 2281 | 62 | 0 | 27.68184592 | -98.50864568 | 2022-01-14 04:21:54 | Duval, Texas, US | |
2021-09-09 | US | Texas | Tyler | 48457 | 2281 | 53 | 0 | 30.77031716 | -94.37690895 | 2021-09-10 04:21:20 | Tyler, Texas, US | |
2021-06-10 | US | Texas | Austin | 48015 | 2281 | 37 | 0 | 29.88548725 | -96.27736949 | 2021-06-11 04:23:20 | Austin, Texas, US | |
2021-04-09 | US | Texas | Falls | 48145 | 2281 | 32 | 0 | 31.25350609 | -96.93630086 | 2021-04-10 04:20:59 | Falls, Texas, US | |
2021-01-18 | US | Texas | Hutchinson | 48233 | 2281 | 57 | 0 | 1195 | 35.84006574 | -101.3546643 | 2021-01-19 05:22:15 | Hutchinson, Texas, US |
2021-01-17 | US | Texas | Hutchinson | 48233 | 2281 | 57 | 0 | 1195 | 35.84006574 | -101.3546643 | 2021-01-18 05:22:34 | Hutchinson, Texas, US |
2021-01-16 | US | Texas | Hutchinson | 48233 | 2281 | 57 | 0 | 1195 | 35.84006574 | -101.3546643 | 2021-01-17 05:22:17 | Hutchinson, Texas, US |
2021-01-15 | US | Texas | Hutchinson | 48233 | 2281 | 57 | 0 | 1195 | 35.84006574 | -101.3546643 | 2021-01-16 05:22:40 | Hutchinson, Texas, US |
2021-01-14 | US | Texas | Hutchinson | 48233 | 2281 | 56 | 0 | 1196 | 35.84006574 | -101.3546643 | 2021-01-15 05:22:24 | Hutchinson, Texas, US |
2020-12-18 | US | Texas | Harrison | 48203 | 2281 | 58 | 0 | 2144 | 32.54935988 | -94.36934071 | 2020-12-19 05:27:52 | Harrison, Texas, US |
2020-11-19 | US | Texas | Bastrop | 48021 | 2281 | 34 | 0 | 2568 | 30.10370699 | -97.31206354 | 2020-11-20 05:26:28 | Bastrop, Texas, US |
2020-09-04 | US | Texas | Anderson | 48001 | 2281 | 18 | 0 | 2520 | 31.81534745 | -95.65354823 | 2020-09-05 04:28:19 | Anderson, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;