daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
254,491 rows where province_or_state = "Texas" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | US | Texas | Cameron | 48061 | 71026 | 1821 | 0 | 26.14524221 | -97.48140372 | 2021-12-03 04:23:05 | Cameron, Texas, US | |
2021-10-28 | US | Texas | Cameron | 48061 | 69654 | 1776 | 0 | 26.14524221 | -97.48140372 | 2021-10-29 04:22:03 | Cameron, Texas, US | |
2020-10-25 | US | Texas | Cameron | 48061 | 18750 | 1075 | 0 | 22901 | 26.14524221 | -97.48140372 | 2020-10-26 04:25:02 | Cameron, Texas, US |
2021-01-26 | US | Texas | Cameron | 48061 | 38179 | 1275 | 0 | 32984 | 26.14524221 | -97.48140372 | 2021-01-27 05:23:41 | Cameron, Texas, US |
2021-09-18 | US | Texas | Cameron | 48061 | 66209 | 1664 | 0 | 26.14524221 | -97.48140372 | 2021-09-19 04:21:34 | Cameron, Texas, US | |
2021-05-28 | US | Texas | Cameron | 48061 | 45121 | 1647 | 0 | 26.14524221 | -97.48140372 | 2021-05-29 04:20:41 | Cameron, Texas, US | |
2022-03-20 | US | Texas | Cameron | 48061 | 100295 | 2013 | 0 | 26.14524221 | -97.48140372 | 2022-03-21 04:20:50 | Cameron, Texas, US | |
2021-11-11 | US | Texas | Cameron | 48061 | 70271 | 1794 | 0 | 26.14524221 | -97.48140372 | 2021-11-12 04:22:01 | Cameron, Texas, US | |
2021-08-25 | US | Texas | Cameron | 48061 | 61704 | 1754 | 0 | 26.14524221 | -97.48140372 | 2021-08-26 04:21:28 | Cameron, Texas, US | |
2021-04-12 | US | Texas | Cameron | 48061 | 43015 | 1593 | 0 | 26.14524221 | -97.48140372 | 2021-04-13 04:20:37 | Cameron, Texas, US | |
2020-04-13 | US | Texas | Cameron | 48061 | 52 | 3 | 0 | 192 | 26.14524221 | -97.48140372 | 2020-04-13 23:07:54 | Cameron, Texas, US |
2021-11-02 | US | Texas | Cameron | 48061 | 69919 | 1780 | 0 | 26.14524221 | -97.48140372 | 2021-11-03 06:22:09 | Cameron, Texas, US | |
2020-04-17 | US | Texas | Cameron | 48061 | 68 | 4 | 0 | 266 | 26.14524221 | -97.48140372 | 2020-04-17 23:30:52 | Cameron, Texas, US |
2021-05-29 | US | Texas | Cameron | 48061 | 45141 | 1647 | 0 | 26.14524221 | -97.48140372 | 2021-05-30 04:20:55 | Cameron, Texas, US | |
2021-03-07 | US | Texas | Cameron | 48061 | 41486 | 1506 | 0 | 26.14524221 | -97.48140372 | 2021-03-08 05:24:48 | Cameron, Texas, US | |
2020-07-23 | US | Texas | Cameron | 48061 | 5757 | 137 | 0 | 6717 | 26.14524221 | -97.48140372 | 2020-07-24 05:30:40 | Cameron, Texas, US |
2022-11-12 | US | Texas | Cameron | 48061 | 127495 | 2092 | 0 | 26.14524221 | -97.48140372 | 2022-11-13 04:21:14 | Cameron, Texas, US | |
2021-09-01 | US | Texas | Cameron | 48061 | 63271 | 1786 | 0 | 26.14524221 | -97.48140372 | 2021-09-02 04:21:15 | Cameron, Texas, US | |
2022-02-07 | US | Texas | Cameron | 48061 | 94489 | 1898 | 0 | 26.14524221 | -97.48140372 | 2022-02-08 04:21:15 | Cameron, Texas, US | |
2020-12-03 | US | Texas | Cameron | 48061 | 28298 | 1127 | 0 | 25215 | 26.14524221 | -97.48140372 | 2020-12-04 05:27:27 | Cameron, Texas, US |
2020-10-14 | US | Texas | Cameron | 48061 | 18515 | 1052 | 0 | 22507 | 26.14524221 | -97.48140372 | 2020-10-15 04:24:28 | Cameron, Texas, US |
2021-05-25 | US | Texas | Cameron | 48061 | 45044 | 1647 | 0 | 26.14524221 | -97.48140372 | 2021-05-26 04:20:35 | Cameron, Texas, US | |
2021-11-09 | US | Texas | Cameron | 48061 | 70176 | 1791 | 0 | 26.14524221 | -97.48140372 | 2021-11-10 04:21:38 | Cameron, Texas, US | |
2022-07-23 | US | Texas | Cameron | 48061 | 117494 | 2053 | 0 | 26.14524221 | -97.48140372 | 2022-07-24 04:20:47 | Cameron, Texas, US | |
2020-08-04 | US | Texas | Cameron | 48061 | 8947 | 383 | 0 | 14398 | 26.14524221 | -97.48140372 | 2020-08-05 04:34:43 | Cameron, Texas, US |
2022-01-14 | US | Texas | Cameron | 48061 | 80587 | 1847 | 0 | 26.14524221 | -97.48140372 | 2022-01-15 04:21:07 | Cameron, Texas, US | |
2021-08-15 | US | Texas | Cameron | 48061 | 59100 | 1731 | 0 | 26.14524221 | -97.48140372 | 2021-08-16 04:21:31 | Cameron, Texas, US | |
2021-06-19 | US | Texas | Cameron | 48061 | 45787 | 1647 | 0 | 26.14524221 | -97.48140372 | 2021-06-20 04:21:48 | Cameron, Texas, US | |
2020-05-08 | US | Texas | Cameron | 48061 | 96 | 20 | 0 | 463 | 26.14524221 | -97.48140372 | 2020-05-09 02:32:35 | Cameron, Texas, US |
2022-09-06 | US | Texas | Cameron | 48061 | 123571 | 2075 | 0 | 26.14524221 | -97.48140372 | 2022-09-07 04:20:59 | Cameron, Texas, US | |
2020-07-19 | US | Texas | Cameron | 48061 | 4295 | 96 | 0 | 5795 | 26.14524221 | -97.48140372 | 2020-07-20 05:34:40 | Cameron, Texas, US |
2020-11-18 | US | Texas | Cameron | 48061 | 26982 | 1103 | 0 | 24131 | 26.14524221 | -97.48140372 | 2020-11-19 05:25:23 | Cameron, Texas, US |
2022-01-09 | US | Texas | Cameron | 48061 | 76822 | 1845 | 0 | 26.14524221 | -97.48140372 | 2022-01-10 04:22:07 | Cameron, Texas, US | |
2022-10-04 | US | Texas | Cameron | 48061 | 125649 | 2085 | 0 | 26.14524221 | -97.48140372 | 2022-10-05 04:23:06 | Cameron, Texas, US | |
2020-04-29 | US | Texas | Cameron | 48061 | 82 | 16 | 0 | 371 | 26.14524221 | -97.48140372 | 2020-04-30 02:32:27 | Cameron, Texas, US |
2021-12-04 | US | Texas | Cameron | 48061 | 71097 | 1821 | 0 | 26.14524221 | -97.48140372 | 2021-12-05 04:22:25 | Cameron, Texas, US | |
2022-07-09 | US | Texas | Cameron | 48061 | 114305 | 2046 | 0 | 26.14524221 | -97.48140372 | 2022-07-10 04:20:54 | Cameron, Texas, US | |
2020-08-15 | US | Texas | Cameron | 48061 | 13417 | 547 | 0 | 17269 | 26.14524221 | -97.48140372 | 2020-08-16 04:27:42 | Cameron, Texas, US |
2021-11-29 | US | Texas | Cameron | 48061 | 70835 | 1821 | 0 | 26.14524221 | -97.48140372 | 2021-11-30 04:22:53 | Cameron, Texas, US | |
2021-01-08 | US | Texas | Cameron | 48061 | 34889 | 1100 | 0 | 29869 | 26.14524221 | -97.48140372 | 2021-01-09 05:22:18 | Cameron, Texas, US |
2022-03-29 | US | Texas | Cameron | 48061 | 101135 | 2017 | 0 | 26.14524221 | -97.48140372 | 2022-03-30 04:20:45 | Cameron, Texas, US | |
2021-11-19 | US | Texas | Cameron | 48061 | 70594 | 1812 | 0 | 26.14524221 | -97.48140372 | 2021-11-20 04:22:17 | Cameron, Texas, US | |
2022-06-21 | US | Texas | Cameron | 48061 | 110210 | 2037 | 0 | 26.14524221 | -97.48140372 | 2022-06-22 04:20:54 | Cameron, Texas, US | |
2021-04-16 | US | Texas | Cameron | 48061 | 43361 | 1594 | 0 | 26.14524221 | -97.48140372 | 2021-04-17 04:20:40 | Cameron, Texas, US | |
2020-07-27 | US | Texas | Cameron | 48061 | 6950 | 272 | 0 | 7555 | 26.14524221 | -97.48140372 | 2020-07-28 04:58:43 | Cameron, Texas, US |
2021-09-02 | US | Texas | Cameron | 48061 | 63569 | 1789 | 0 | 26.14524221 | -97.48140372 | 2021-09-03 04:21:20 | Cameron, Texas, US | |
2021-02-21 | US | Texas | Cameron | 48061 | 40822 | 1411 | 0 | 35491 | 26.14524221 | -97.48140372 | 2021-02-22 05:24:21 | Cameron, Texas, US |
2022-02-13 | US | Texas | Cameron | 48061 | 96167 | 1919 | 0 | 26.14524221 | -97.48140372 | 2022-02-14 04:20:51 | Cameron, Texas, US | |
2021-01-11 | US | Texas | Cameron | 48061 | 35112 | 1205 | 0 | 29987 | 26.14524221 | -97.48140372 | 2021-01-12 05:22:15 | Cameron, Texas, US |
2020-08-31 | US | Texas | Cameron | 48061 | 15092 | 757 | 0 | 20202 | 26.14524221 | -97.48140372 | 2020-09-01 04:28:31 | Cameron, Texas, US |
2022-10-19 | US | Texas | Cameron | 48061 | 126434 | 2089 | 0 | 26.14524221 | -97.48140372 | 2022-10-20 04:22:59 | Cameron, Texas, US | |
2020-12-25 | US | Texas | Cameron | 48061 | 32486 | 1164 | 0 | 27711 | 26.14524221 | -97.48140372 | 2020-12-26 05:22:28 | Cameron, Texas, US |
2020-08-19 | US | Texas | Cameron | 48061 | 13959 | 602 | 0 | 17736 | 26.14524221 | -97.48140372 | 2020-08-20 04:27:43 | Cameron, Texas, US |
2020-10-29 | US | Texas | Cameron | 48061 | 26419 | 1081 | 0 | 23099 | 26.14524221 | -97.48140372 | 2020-10-30 04:24:49 | Cameron, Texas, US |
2020-06-08 | US | Texas | Cameron | 48061 | 268 | 39 | 0 | 853 | 26.14524221 | -97.48140372 | 2020-06-09 03:33:03 | Cameron, Texas, US |
2022-12-26 | US | Texas | Cameron | 48061 | 130040 | 2095 | 0 | 26.14524221 | -97.48140372 | 2022-12-27 04:21:07 | Cameron, Texas, US | |
2022-05-09 | US | Texas | Cameron | 48061 | 104424 | 2030 | 0 | 26.14524221 | -97.48140372 | 2022-05-10 04:20:50 | Cameron, Texas, US | |
2020-04-30 | US | Texas | Cameron | 48061 | 86 | 17 | 0 | 384 | 26.14524221 | -97.48140372 | 2020-05-01 02:32:28 | Cameron, Texas, US |
2022-05-31 | US | Texas | Cameron | 48061 | 106903 | 2035 | 0 | 26.14524221 | -97.48140372 | 2022-06-01 04:20:55 | Cameron, Texas, US | |
2022-02-11 | US | Texas | Cameron | 48061 | 95623 | 1912 | 0 | 26.14524221 | -97.48140372 | 2022-02-12 04:21:06 | Cameron, Texas, US | |
2021-01-18 | US | Texas | Cameron | 48061 | 36618 | 1222 | 0 | 31476 | 26.14524221 | -97.48140372 | 2021-01-19 05:22:15 | Cameron, Texas, US |
2021-04-02 | US | Texas | Cameron | 48061 | 42600 | 1577 | 0 | 26.14524221 | -97.48140372 | 2021-04-03 04:20:44 | Cameron, Texas, US | |
2021-08-17 | US | Texas | Cameron | 48061 | 59660 | 1738 | 0 | 26.14524221 | -97.48140372 | 2021-08-18 04:21:35 | Cameron, Texas, US | |
2021-09-04 | US | Texas | Cameron | 48061 | 64058 | 1792 | 0 | 26.14524221 | -97.48140372 | 2021-09-05 04:21:33 | Cameron, Texas, US | |
2022-09-08 | US | Texas | Cameron | 48061 | 123731 | 2076 | 0 | 26.14524221 | -97.48140372 | 2022-09-09 04:21:11 | Cameron, Texas, US | |
2022-12-10 | US | Texas | Cameron | 48061 | 128947 | 2094 | 0 | 26.14524221 | -97.48140372 | 2022-12-11 04:20:50 | Cameron, Texas, US | |
2022-03-15 | US | Texas | Cameron | 48061 | 99855 | 2006 | 0 | 26.14524221 | -97.48140372 | 2022-03-16 04:20:50 | Cameron, Texas, US | |
2020-05-21 | US | Texas | Cameron | 48061 | 110 | 32 | 0 | 632 | 26.14524221 | -97.48140372 | 2020-05-22 02:36:51 | Cameron, Texas, US |
2020-04-28 | US | Texas | Cameron | 48061 | 80 | 14 | 0 | 362 | 26.14524221 | -97.48140372 | 2020-04-29 02:32:29 | Cameron, Texas, US |
2020-11-10 | US | Texas | Cameron | 48061 | 26671 | 1094 | 0 | 23653 | 26.14524221 | -97.48140372 | 2020-11-11 05:25:30 | Cameron, Texas, US |
2021-11-03 | US | Texas | Cameron | 48061 | 69972 | 1783 | 0 | 26.14524221 | -97.48140372 | 2021-11-04 04:22:20 | Cameron, Texas, US | |
2021-02-24 | US | Texas | Cameron | 48061 | 41026 | 1411 | 0 | 35695 | 26.14524221 | -97.48140372 | 2021-02-25 05:24:57 | Cameron, Texas, US |
2020-06-15 | US | Texas | Cameron | 48061 | 462 | 44 | 0 | 1094 | 26.14524221 | -97.48140372 | 2020-06-16 04:33:09 | Cameron, Texas, US |
2021-10-31 | US | Texas | Cameron | 48061 | 69781 | 1778 | 0 | 26.14524221 | -97.48140372 | 2021-11-01 04:22:01 | Cameron, Texas, US | |
2022-11-15 | US | Texas | Cameron | 48061 | 127781 | 2092 | 0 | 26.14524221 | -97.48140372 | 2022-11-16 04:21:09 | Cameron, Texas, US | |
2021-07-15 | US | Texas | Cameron | 48061 | 46908 | 1699 | 0 | 26.14524221 | -97.48140372 | 2021-07-16 04:21:22 | Cameron, Texas, US | |
2020-07-01 | US | Texas | Cameron | 48061 | 1587 | 55 | 0 | 2344 | 26.14524221 | -97.48140372 | 2020-07-02 04:33:46 | Cameron, Texas, US |
2022-04-16 | US | Texas | Cameron | 48061 | 102771 | 2021 | 0 | 26.14524221 | -97.48140372 | 2022-04-17 04:20:59 | Cameron, Texas, US | |
2022-12-13 | US | Texas | Cameron | 48061 | 128947 | 2094 | 0 | 26.14524221 | -97.48140372 | 2022-12-14 04:21:04 | Cameron, Texas, US | |
2022-11-13 | US | Texas | Cameron | 48061 | 127495 | 2092 | 0 | 26.14524221 | -97.48140372 | 2022-11-14 04:21:09 | Cameron, Texas, US | |
2022-02-12 | US | Texas | Cameron | 48061 | 95949 | 1912 | 0 | 26.14524221 | -97.48140372 | 2022-02-13 04:21:00 | Cameron, Texas, US | |
2022-10-30 | US | Texas | Cameron | 48061 | 126937 | 2091 | 0 | 26.14524221 | -97.48140372 | 2022-10-31 04:21:36 | Cameron, Texas, US | |
2020-07-20 | US | Texas | Cameron | 48061 | 4718 | 96 | 0 | 5795 | 26.14524221 | -97.48140372 | 2020-07-21 04:38:46 | Cameron, Texas, US |
2022-12-27 | US | Texas | Cameron | 48061 | 130040 | 2095 | 0 | 26.14524221 | -97.48140372 | 2022-12-28 04:21:04 | Cameron, Texas, US | |
2021-08-04 | US | Texas | Cameron | 48061 | 48883 | 1713 | 0 | 26.14524221 | -97.48140372 | 2021-08-05 04:21:51 | Cameron, Texas, US | |
2022-03-18 | US | Texas | Cameron | 48061 | 100078 | 2013 | 0 | 26.14524221 | -97.48140372 | 2022-03-19 04:20:47 | Cameron, Texas, US | |
2021-02-03 | US | Texas | Cameron | 48061 | 39405 | 1341 | 0 | 34144 | 26.14524221 | -97.48140372 | 2021-02-04 05:22:26 | Cameron, Texas, US |
2020-09-14 | US | Texas | Cameron | 48061 | 16520 | 843 | 0 | 21140 | 26.14524221 | -97.48140372 | 2020-09-15 03:22:50 | Cameron, Texas, US |
2022-12-14 | US | Texas | Cameron | 48061 | 129400 | 2094 | 0 | 26.14524221 | -97.48140372 | 2022-12-15 04:20:58 | Cameron, Texas, US | |
2021-03-11 | US | Texas | Cameron | 48061 | 41747 | 1532 | 0 | 26.14524221 | -97.48140372 | 2021-03-12 05:26:50 | Cameron, Texas, US | |
2022-03-11 | US | Texas | Cameron | 48061 | 99573 | 2005 | 0 | 26.14524221 | -97.48140372 | 2022-03-12 04:20:50 | Cameron, Texas, US | |
2022-05-07 | US | Texas | Cameron | 48061 | 104392 | 2030 | 0 | 26.14524221 | -97.48140372 | 2022-05-08 04:20:49 | Cameron, Texas, US | |
2020-07-16 | US | Texas | Cameron | 48061 | 3669 | 79 | 0 | 4826 | 26.14524221 | -97.48140372 | 2020-07-17 04:34:50 | Cameron, Texas, US |
2020-08-08 | US | Texas | Cameron | 48061 | 10984 | 425 | 0 | 15865 | 26.14524221 | -97.48140372 | 2020-08-09 04:34:54 | Cameron, Texas, US |
2022-09-13 | US | Texas | Cameron | 48061 | 124085 | 2076 | 0 | 26.14524221 | -97.48140372 | 2022-09-14 04:20:44 | Cameron, Texas, US | |
2020-11-06 | US | Texas | Cameron | 48061 | 26598 | 1091 | 0 | 23470 | 26.14524221 | -97.48140372 | 2020-11-07 05:24:52 | Cameron, Texas, US |
2021-04-30 | US | Texas | Cameron | 48061 | 44216 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-05-01 04:20:47 | Cameron, Texas, US | |
2022-09-23 | US | Texas | Cameron | 48061 | 124887 | 2083 | 0 | 26.14524221 | -97.48140372 | 2022-09-24 04:21:40 | Cameron, Texas, US | |
2021-04-04 | US | Texas | Cameron | 48061 | 42600 | 1577 | 0 | 26.14524221 | -97.48140372 | 2021-04-05 04:20:35 | Cameron, Texas, US | |
2020-11-27 | US | Texas | Cameron | 48061 | 27746 | 1108 | 0 | 24747 | 26.14524221 | -97.48140372 | 2020-11-28 05:25:50 | Cameron, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;