johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where active = 707, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1001654 | 1001654 | 2021-03-01 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-03-02 05:23:30 | Stephens, Texas, US |
2370712 | 2370712 | 2021-02-28 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-03-01 05:23:01 | Stephens, Texas, US |
3069214 | 3069214 | 2021-02-27 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-02-28 05:22:20 | Stephens, Texas, US |
2680850 | 2680850 | 2021-02-13 | US | Texas | Brooks | 48047 | 768 | 32 | 0 | 707 | 27.03103197 | -98.21808402 | 2021-02-14 05:23:43 | Brooks, Texas, US |
1591395 | 1591395 | 2021-02-05 | US | Texas | Swisher | 48437 | 868 | 15 | 0 | 707 | 34.53028891 | -101.7349174 | 2021-02-06 05:23:55 | Swisher, Texas, US |
343490 | 343490 | 2021-02-03 | US | Texas | Stephens | 48429 | 799 | 21 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-02-04 05:22:26 | Stephens, Texas, US |
1900326 | 1900326 | 2021-01-29 | US | Texas | Morris | 48343 | 872 | 19 | 0 | 707 | 33.11304005 | -94.73255695 | 2021-01-30 05:22:49 | Morris, Texas, US |
438361 | 438361 | 2021-01-21 | US | Texas | Archer | 48009 | 741 | 10 | 0 | 707 | 33.61569967 | -98.68754589 | 2021-01-22 05:22:10 | Archer, Texas, US |
1013312 | 1013312 | 2020-12-30 | US | Texas | Bailey | 48017 | 794 | 12 | 0 | 707 | 34.06854817 | -102.8299707 | 2020-12-31 05:22:49 | Bailey, Texas, US |
3764727 | 3764727 | 2020-12-28 | US | Texas | Leon | 48289 | 929 | 22 | 0 | 707 | 31.29872538 | -95.9936328 | 2020-12-29 05:22:37 | Leon, Texas, US |
3781047 | 3781047 | 2020-12-27 | US | Texas | Leon | 48289 | 914 | 22 | 0 | 707 | 31.29872538 | -95.9936328 | 2020-12-28 05:22:06 | Leon, Texas, US |
1821833 | 1821833 | 2020-12-08 | US | Texas | Comanche | 48093 | 696 | 9 | 0 | 707 | 31.94854689 | -98.55876441 | 2020-12-09 05:28:01 | Comanche, Texas, US |
1587331 | 1587331 | 2020-11-30 | US | Texas | Montague | 48337 | 774 | 16 | 0 | 707 | 33.67521893 | -97.72500958 | 2020-12-01 05:26:18 | Montague, Texas, US |
3569734 | 3569734 | 2020-11-29 | US | Texas | Montague | 48337 | 769 | 16 | 0 | 707 | 33.67521893 | -97.72500958 | 2020-11-30 05:26:13 | Montague, Texas, US |
1991882 | 1991882 | 2020-11-09 | US | Texas | Young | 48503 | 738 | 13 | 0 | 707 | 33.17659707 | -98.68790885 | 2020-11-10 05:40:07 | Young, Texas, US |
1731556 | 1731556 | 2020-11-08 | US | Texas | Fayette | 48149 | 620 | 23 | 0 | 707 | 29.87788372 | -96.92076062 | 2020-11-09 05:25:45 | Fayette, Texas, US |
1731734 | 1731734 | 2020-11-08 | US | Texas | Young | 48503 | 731 | 13 | 0 | 707 | 33.17659707 | -98.68790885 | 2020-11-09 05:25:45 | Young, Texas, US |
1547016 | 1547016 | 2020-11-07 | US | Texas | Fayette | 48149 | 617 | 23 | 0 | 707 | 29.87788372 | -96.92076062 | 2020-11-08 05:24:56 | Fayette, Texas, US |
1547194 | 1547194 | 2020-11-07 | US | Texas | Young | 48503 | 729 | 13 | 0 | 707 | 33.17659707 | -98.68790885 | 2020-11-08 05:24:56 | Young, Texas, US |
379254 | 379254 | 2020-11-06 | US | Texas | Fayette | 48149 | 617 | 23 | 0 | 707 | 29.87788372 | -96.92076062 | 2020-11-07 05:24:52 | Fayette, Texas, US |
379432 | 379432 | 2020-11-06 | US | Texas | Young | 48503 | 729 | 13 | 0 | 707 | 33.17659707 | -98.68790885 | 2020-11-07 05:24:52 | Young, Texas, US |
3307400 | 3307400 | 2020-11-02 | US | Texas | Shelby | 48419 | 703 | 31 | 0 | 707 | 31.79211404 | -94.14550696 | 2020-11-03 06:00:16 | Shelby, Texas, US |
3412512 | 3412512 | 2020-11-01 | US | Texas | Falls | 48145 | 640 | 6 | 0 | 707 | 31.25350609 | -96.93630086 | 2020-11-02 05:25:04 | Falls, Texas, US |
1124734 | 1124734 | 2020-09-17 | US | Texas | Madison | 48313 | 755 | 6 | 0 | 707 | 30.96694679 | -95.93003775 | 2020-09-18 05:05:00 | Madison, Texas, US |
1615288 | 1615288 | 2020-08-14 | US | Texas | DeWitt | 48123 | 576 | 21 | 0 | 707 | 29.08101855 | -97.3568117 | 2020-08-15 04:27:31 | DeWitt, Texas, US |
585872 | 585872 | 2020-08-13 | US | Texas | DeWitt | 48123 | 562 | 20 | 0 | 707 | 29.08101855 | -97.3568117 | 2020-08-14 04:51:19 | DeWitt, Texas, US |
3329780 | 3329780 | 2020-05-11 | US | Texas | Montgomery | 48339 | 531 | 17 | 0 | 707 | 30.30079133 | -95.50572772 | 2020-05-12 03:32:27 | Montgomery, 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]);