johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 1790, country_or_region = "US" and province_or_state = "Texas" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3650637 | 3650637 | 2022-08-14 | US | Texas | Coleman | 48083 | 1790 | 72 | 0 | 31.76736834 | -99.45240766 | 2022-08-15 04:20:59 | Coleman, Texas, US | |
1971643 | 1971643 | 2022-08-13 | US | Texas | Coleman | 48083 | 1790 | 72 | 0 | 31.76736834 | -99.45240766 | 2022-08-14 04:20:55 | Coleman, Texas, US | |
2891452 | 2891452 | 2022-08-12 | US | Texas | Coleman | 48083 | 1790 | 72 | 0 | 31.76736834 | -99.45240766 | 2022-08-13 04:20:52 | Coleman, Texas, US | |
2736096 | 2736096 | 2022-02-27 | US | Texas | Delta | 48119 | 1790 | 24 | 0 | 33.38570922 | -95.66921122 | 2022-02-28 04:21:05 | Delta, Texas, US | |
3049249 | 3049249 | 2022-02-26 | US | Texas | Delta | 48119 | 1790 | 24 | 0 | 33.38570922 | -95.66921122 | 2022-02-27 04:21:04 | Delta, Texas, US | |
3229681 | 3229681 | 2022-01-19 | US | Texas | Swisher | 48437 | 1790 | 28 | 0 | 34.53028891 | -101.73491740000001 | 2022-01-20 04:21:07 | Swisher, Texas, US | |
1081120 | 1081120 | 2021-12-09 | US | Texas | Parmer | 48369 | 1790 | 42 | 0 | 34.52993409 | -102.78446679999999 | 2021-12-10 04:22:28 | Parmer, Texas, US | |
553969 | 553969 | 2021-12-08 | US | Texas | Parmer | 48369 | 1790 | 42 | 0 | 34.52993409 | -102.78446679999999 | 2021-12-09 04:22:49 | Parmer, Texas, US | |
2126924 | 2126924 | 2021-10-21 | US | Texas | Morris | 48343 | 1790 | 52 | 0 | 33.11304005 | -94.73255695 | 2021-10-22 04:21:14 | Morris, Texas, US | |
2126980 | 2126980 | 2021-10-21 | US | Texas | Trinity | 48455 | 1790 | 59 | 0 | 31.0879489 | -95.1367187 | 2021-10-22 04:21:14 | Trinity, Texas, US | |
446536 | 446536 | 2021-10-20 | US | Texas | Morris | 48343 | 1790 | 52 | 0 | 33.11304005 | -94.73255695 | 2021-10-21 04:21:18 | Morris, Texas, US | |
600855 | 600855 | 2021-10-19 | US | Texas | Morris | 48343 | 1790 | 51 | 0 | 33.11304005 | -94.73255695 | 2021-10-20 04:21:00 | Morris, Texas, US | |
1924413 | 1924413 | 2021-09-24 | US | Texas | Pecos | 48371 | 1790 | 42 | 0 | 30.78097267 | -102.72412609999999 | 2021-09-25 04:21:31 | Pecos, Texas, US | |
1896192 | 1896192 | 2021-06-30 | US | Texas | Colorado | 48089 | 1790 | 32 | 0 | 29.622098 | -96.5273805 | 2021-07-01 04:21:19 | Colorado, Texas, US | |
403315 | 403315 | 2021-06-29 | US | Texas | Colorado | 48089 | 1790 | 32 | 0 | 29.622098 | -96.5273805 | 2021-06-30 04:21:41 | Colorado, Texas, US | |
2426008 | 2426008 | 2021-06-23 | US | Texas | Houston | 48225 | 1790 | 58 | 0 | 31.31925973 | -95.42226208 | 2021-06-24 04:21:55 | Houston, Texas, US | |
2107342 | 2107342 | 2021-06-01 | US | Texas | Shelby | 48419 | 1790 | 68 | 0 | 31.79211404 | -94.14550696 | 2021-06-02 04:24:34 | Shelby, Texas, US | |
1191958 | 1191958 | 2021-05-31 | US | Texas | Shelby | 48419 | 1790 | 68 | 0 | 31.79211404 | -94.14550696 | 2021-06-01 04:23:09 | Shelby, Texas, US | |
1747573 | 1747573 | 2021-03-20 | US | Texas | Cass | 48067 | 1790 | 79 | 0 | 33.07499881 | -94.34646905 | 2021-03-21 05:25:44 | Cass, Texas, US | |
3423953 | 3423953 | 2021-03-19 | US | Texas | Cass | 48067 | 1790 | 79 | 0 | 33.07499881 | -94.34646905 | 2021-03-20 05:25:46 | Cass, Texas, US | |
3455891 | 3455891 | 2021-03-18 | US | Texas | Cass | 48067 | 1790 | 79 | 0 | 33.07499881 | -94.34646905 | 2021-03-19 05:26:09 | Cass, Texas, US | |
3624115 | 3624115 | 2021-03-17 | US | Texas | Cass | 48067 | 1790 | 79 | 0 | 33.07499881 | -94.34646905 | 2021-03-18 05:26:22 | Cass, Texas, US | |
3542488 | 3542488 | 2021-02-12 | US | Texas | Calhoun | 48057 | 1790 | 15 | 0 | 1708 | 28.47048236 | -96.61633945 | 2021-02-13 05:22:12 | Calhoun, Texas, US |
848685 | 848685 | 2020-12-12 | US | Texas | Hutchinson | 48233 | 1790 | 32 | 0 | 1032 | 35.84006574 | -101.3546643 | 2020-12-13 05:27:20 | Hutchinson, Texas, US |
895209 | 895209 | 2020-11-05 | US | Texas | Gregg | 48183 | 1790 | 88 | 0 | 3560 | 32.47940482 | -94.81591935 | 2020-11-06 05:24:55 | Gregg, Texas, US |
11532 | 11532 | 2020-10-25 | US | Texas | San Patricio | 48409 | 1790 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-26 04:25:02 | San Patricio, Texas, US |
3654769 | 3654769 | 2020-10-24 | US | Texas | San Patricio | 48409 | 1790 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-25 04:24:36 | San Patricio, Texas, US |
2605225 | 2605225 | 2020-10-10 | US | Texas | Rockwall | 48397 | 1790 | 30 | 0 | 1699 | 32.89779518 | -96.40771592 | 2020-10-11 04:23:46 | Rockwall, 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]);