johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where confirmed = 2558, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954540 | 2954540 | 2022-12-20 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-21 04:21:03 | La Salle, Texas, US | |
3176942 | 3176942 | 2022-12-19 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-20 04:21:04 | La Salle, Texas, US | |
1631459 | 1631459 | 2022-12-18 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-19 04:21:03 | La Salle, Texas, US | |
506838 | 506838 | 2022-12-17 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-18 04:21:03 | La Salle, Texas, US | |
3327410 | 3327410 | 2022-12-16 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-17 04:21:04 | La Salle, Texas, US | |
545922 | 545922 | 2022-12-15 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-16 04:21:01 | La Salle, Texas, US | |
351450 | 351450 | 2022-12-14 | US | Texas | La Salle | 48283 | 2558 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-15 04:20:58 | La Salle, Texas, US | |
3029385 | 3029385 | 2022-11-17 | US | Texas | Franklin | 48159 | 2558 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-11-18 04:21:15 | Franklin, Texas, US | |
2489096 | 2489096 | 2022-11-16 | US | Texas | Franklin | 48159 | 2558 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-11-17 04:21:11 | Franklin, Texas, US | |
295107 | 295107 | 2022-11-15 | US | Texas | Franklin | 48159 | 2558 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-11-16 04:21:09 | Franklin, Texas, US | |
3600137 | 3600137 | 2022-11-14 | US | Texas | Franklin | 48159 | 2558 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-11-15 04:21:16 | Franklin, Texas, US | |
1627489 | 1627489 | 2022-09-22 | US | Texas | Parmer | 48369 | 2558 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-09-23 04:23:13 | Parmer, Texas, US | |
1373693 | 1373693 | 2022-09-21 | US | Texas | Parmer | 48369 | 2558 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-09-22 04:22:56 | Parmer, Texas, US | |
3748317 | 3748317 | 2022-09-07 | US | Texas | Red River | 48387 | 2558 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-09-08 04:21:02 | Red River, Texas, US | |
3953683 | 3953683 | 2022-08-17 | US | Texas | Ochiltree | 48357 | 2558 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-08-18 04:21:11 | Ochiltree, Texas, US | |
2079210 | 2079210 | 2021-09-26 | US | Texas | Zavala | 48507 | 2558 | 52 | 0 | 28.86617238 | -99.76050829 | 2021-09-27 04:21:16 | Zavala, Texas, US | |
1727762 | 1727762 | 2021-09-25 | US | Texas | Zavala | 48507 | 2558 | 52 | 0 | 28.86617238 | -99.76050829 | 2021-09-26 04:21:29 | Zavala, Texas, US | |
1924482 | 1924482 | 2021-09-24 | US | Texas | Zavala | 48507 | 2558 | 52 | 0 | 28.86617238 | -99.76050829 | 2021-09-25 04:21:31 | Zavala, Texas, US | |
604953 | 604953 | 2021-09-23 | US | Texas | Zavala | 48507 | 2558 | 52 | 0 | 28.86617238 | -99.76050829 | 2021-09-24 04:21:44 | Zavala, Texas, US | |
812601 | 812601 | 2021-09-20 | US | Texas | Bosque | 48035 | 2558 | 48 | 0 | 31.89978581 | -97.63613524 | 2021-09-21 04:21:26 | Bosque, Texas, US | |
1817800 | 1817800 | 2021-09-19 | US | Texas | Bosque | 48035 | 2558 | 48 | 0 | 31.89978581 | -97.63613524 | 2021-09-20 04:21:22 | Bosque, Texas, US | |
19380 | 19380 | 2021-09-18 | US | Texas | Bosque | 48035 | 2558 | 48 | 0 | 31.89978581 | -97.63613524 | 2021-09-19 04:21:34 | Bosque, Texas, US | |
3451994 | 3451994 | 2021-09-10 | US | Texas | Leon | 48289 | 2558 | 52 | 0 | 31.29872538 | -95.9936328 | 2021-09-11 04:21:30 | Leon, Texas, US | |
3168836 | 3168836 | 2021-08-23 | US | Texas | San Jacinto | 48407 | 2558 | 41 | 0 | 30.57933681 | -95.16260304 | 2021-08-24 04:21:19 | San Jacinto, Texas, US | |
244455 | 244455 | 2021-04-02 | US | Texas | Robertson | 48395 | 2558 | 39 | 0 | 31.02539637 | -96.51272246 | 2021-04-03 04:20:44 | Robertson, Texas, US | |
3981667 | 3981667 | 2021-02-10 | US | Texas | Gray | 48179 | 2558 | 48 | 0 | 1884 | 35.40081878 | -100.8129222 | 2021-02-11 05:23:55 | Gray, Texas, US |
15522 | 15522 | 2021-01-26 | US | Texas | Palo Pinto | 48363 | 2558 | 52 | 0 | 2447 | 32.75310985 | -98.31319001 | 2021-01-27 05:23:41 | Palo Pinto, Texas, US |
3307374 | 3307374 | 2020-11-02 | US | Texas | Parker | 48367 | 2558 | 52 | 0 | 2890 | 32.77757172 | -97.80500621 | 2020-11-03 06:00:16 | Parker, Texas, US |
2851957 | 2851957 | 2020-09-18 | US | Texas | Johnson | 48251 | 2558 | 48 | 0 | 2747 | 32.37877812 | -97.36615819 | 2020-09-19 04:22:00 | Johnson, Texas, US |
149106 | 149106 | 2020-08-15 | US | Texas | Lubbock | 48303 | 2558 | 78 | 0 | 6417 | 33.61008596 | -101.8204789 | 2020-08-16 04:27:42 | Lubbock, Texas, US |
3921620 | 3921620 | 2020-08-09 | US | Texas | McLennan | 48309 | 2558 | 55 | 0 | 4891 | 31.55255453 | -97.20217694 | 2020-08-10 04:34:55 | McLennan, 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]);