johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where active = 903, country_or_region = "US" and province_or_state = "Texas" 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 · 10 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
283322 | 283322 | 2021-02-24 | US | Texas | La Salle | 48283 | 1093 | 22 | 0 | 903 | 28.34453111 | -99.09908775 | 2021-02-25 05:24:57 | La Salle, Texas, US |
911207 | 911207 | 2021-01-19 | US | Texas | Callahan | 48059 | 922 | 28 | 0 | 903 | 32.29760619 | -99.37326312 | 2021-01-20 05:21:54 | Callahan, Texas, US |
1065046 | 1065046 | 2021-01-04 | US | Texas | Runnels | 48399 | 919 | 18 | 0 | 903 | 31.8314342 | -99.97616148 | 2021-01-05 05:21:49 | Runnels, Texas, US |
3764608 | 3764608 | 2020-12-28 | US | Texas | Burleson | 48051 | 1055 | 14 | 0 | 903 | 30.49273808 | -96.62158484 | 2020-12-29 05:22:37 | Burleson, Texas, US |
3764836 | 3764836 | 2020-12-28 | US | Texas | Zapata | 48505 | 959 | 9 | 0 | 903 | 27.00156391 | -99.16987152 | 2020-12-29 05:22:37 | Zapata, Texas, US |
3781156 | 3781156 | 2020-12-27 | US | Texas | Zapata | 48505 | 941 | 9 | 0 | 903 | 27.00156391 | -99.16987152 | 2020-12-28 05:22:06 | Zapata, Texas, US |
3862946 | 3862946 | 2020-12-04 | US | Texas | Hutchinson | 48233 | 1605 | 29 | 0 | 903 | 35.84006574 | -101.3546643 | 2020-12-05 05:27:36 | Hutchinson, Texas, US |
2788136 | 2788136 | 2020-11-13 | US | Texas | Kerr | 48265 | 867 | 17 | 0 | 903 | 30.06040006 | -99.34930144 | 2020-11-14 05:25:37 | Kerr, Texas, US |
2609219 | 2609219 | 2020-09-24 | US | Texas | Rusk | 48401 | 915 | 11 | 0 | 903 | 32.10773545 | -94.76176432 | 2020-09-25 04:23:00 | Rusk, Texas, US |
1181970 | 1181970 | 2020-05-01 | US | Texas | El Paso | 48141 | 401 | 21 | 0 | 903 | 31.76980765 | -106.23632749999999 | 2020-05-02 02:32:27 | El Paso, Texas, 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]);