daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
254,491 rows where province_or_state = "Texas" sorted by longitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▲ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-19 | US | Texas | Runnels | 48399 | 158 | 3 | 0 | 163 | 31.8314342 | -99.97616148 | 2020-08-20 04:27:43 | Runnels, Texas, US |
2020-08-19 | US | Texas | Unassigned | 90048 | 4348 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-08-20 04:27:43 | Unassigned, Texas, US |
2020-10-29 | US | Texas | Runnels | 48399 | 330 | 9 | 0 | 293 | 31.8314342 | -99.97616148 | 2020-10-30 04:24:49 | Runnels, Texas, US |
2020-10-29 | US | Texas | Unassigned | 90048 | 7028 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-10-30 04:24:49 | Unassigned, Texas, US |
2020-06-08 | US | Texas | Runnels | 48399 | 3 | 0 | 0 | 3 | 31.8314342 | -99.97616148 | 2020-06-09 03:33:03 | Runnels, Texas, US |
2020-06-08 | US | Texas | Unassigned | 90048 | 252 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-06-09 03:33:03 | Unassigned, Texas, US |
2022-12-26 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-27 04:21:07 | Runnels, Texas, US | |
2022-12-26 | US | Texas | Unassigned | 90048 | 95963 | 33 | 0 | 36.27829105 | -99.97616148 | 2022-12-27 04:21:07 | Unassigned, Texas, US | |
2022-05-09 | US | Texas | Runnels | 48399 | 2390 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-05-10 04:20:50 | Runnels, Texas, US | |
2022-05-09 | US | Texas | Unassigned | 90048 | 75874 | 30 | 0 | 36.27829105 | -99.97616148 | 2022-05-10 04:20:50 | Unassigned, Texas, US | |
2020-04-30 | US | Texas | Runnels | 48399 | 2 | 0 | 0 | 1 | 31.8314342 | -99.97616148 | 2020-05-01 02:32:28 | Runnels, Texas, US |
2020-04-30 | US | Texas | Unassigned | 90048 | 74 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-05-01 02:32:28 | Unassigned, Texas, US |
2022-05-31 | US | Texas | Runnels | 48399 | 2402 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-06-01 04:20:55 | Runnels, Texas, US | |
2022-05-31 | US | Texas | Unassigned | 90048 | 77056 | 30 | 0 | 36.27829105 | -99.97616148 | 2022-06-01 04:20:55 | Unassigned, Texas, US | |
2022-02-11 | US | Texas | Runnels | 48399 | 2207 | 61 | 0 | 31.8314342 | -99.97616148 | 2022-02-12 04:21:06 | Runnels, Texas, US | |
2022-02-11 | US | Texas | Unassigned | 90048 | 71849 | 19 | 0 | 36.27829105 | -99.97616148 | 2022-02-12 04:21:06 | Unassigned, Texas, US | |
2021-01-18 | US | Texas | Runnels | 48399 | 1083 | 25 | 0 | 1060 | 31.8314342 | -99.97616148 | 2021-01-19 05:22:15 | Runnels, Texas, US |
2021-01-18 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-01-19 05:22:15 | Unassigned, Texas, US |
2021-04-02 | US | Texas | Runnels | 48399 | 1267 | 37 | 0 | 31.8314342 | -99.97616148 | 2021-04-03 04:20:44 | Runnels, Texas, US | |
2021-04-02 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-04-03 04:20:44 | Unassigned, Texas, US | |
2021-08-17 | US | Texas | Runnels | 48399 | 1394 | 42 | 0 | 31.8314342 | -99.97616148 | 2021-08-18 04:21:35 | Runnels, Texas, US | |
2021-08-17 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-08-18 04:21:35 | Unassigned, Texas, US | |
2021-09-04 | US | Texas | Runnels | 48399 | 1524 | 48 | 0 | 31.8314342 | -99.97616148 | 2021-09-05 04:21:33 | Runnels, Texas, US | |
2021-09-04 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-09-05 04:21:33 | Unassigned, Texas, US | |
2022-09-08 | US | Texas | Runnels | 48399 | 2601 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-09 04:21:11 | Runnels, Texas, US | |
2022-09-08 | US | Texas | Unassigned | 90048 | 90725 | 30 | 0 | 36.27829105 | -99.97616148 | 2022-08-30 23:21:09 | Unassigned, Texas, US | |
2022-12-10 | US | Texas | Runnels | 48399 | 2685 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-11 04:20:50 | Runnels, Texas, US | |
2022-12-10 | US | Texas | Unassigned | 90048 | 95963 | 33 | 0 | 36.27829105 | -99.97616148 | 2022-12-11 04:20:50 | Unassigned, Texas, US | |
2022-03-15 | US | Texas | Runnels | 48399 | 2279 | 64 | 0 | 31.8314342 | -99.97616148 | 2022-03-16 04:20:50 | Runnels, Texas, US | |
2022-03-15 | US | Texas | Unassigned | 90048 | 74398 | 23 | 0 | 36.27829105 | -99.97616148 | 2022-03-16 04:20:50 | Unassigned, Texas, US | |
2020-05-21 | US | Texas | Runnels | 48399 | 2 | 0 | 0 | 2 | 31.8314342 | -99.97616148 | 2020-05-22 02:36:51 | Runnels, Texas, US |
2020-05-21 | US | Texas | Unassigned | 90048 | 147 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-05-22 02:36:51 | Unassigned, Texas, US |
2020-04-28 | US | Texas | Runnels | 48399 | 1 | 0 | 0 | 1 | 31.8314342 | -99.97616148 | 2020-04-29 02:32:29 | Runnels, Texas, US |
2020-04-28 | US | Texas | Unassigned | 90048 | 68 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-04-29 02:32:29 | Unassigned, Texas, US |
2020-11-10 | US | Texas | Runnels | 48399 | 369 | 9 | 0 | 405 | 31.8314342 | -99.97616148 | 2020-11-11 05:25:30 | Runnels, Texas, US |
2020-11-10 | US | Texas | Unassigned | 90048 | 7800 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-11-11 05:25:30 | Unassigned, Texas, US |
2021-11-03 | US | Texas | Runnels | 48399 | 1713 | 54 | 0 | 31.8314342 | -99.97616148 | 2021-11-04 04:22:20 | Runnels, Texas, US | |
2021-11-03 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-11-04 04:22:20 | Unassigned, Texas, US | |
2021-02-24 | US | Texas | Runnels | 48399 | 1240 | 36 | 0 | 1206 | 31.8314342 | -99.97616148 | 2021-02-25 05:24:57 | Runnels, Texas, US |
2021-02-24 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-02-25 05:24:57 | Unassigned, Texas, US |
2020-06-15 | US | Texas | Runnels | 48399 | 3 | 0 | 0 | 2 | 31.8314342 | -99.97616148 | 2020-06-16 04:33:09 | Runnels, Texas, US |
2020-06-15 | US | Texas | Unassigned | 90048 | 317 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-06-16 04:33:09 | Unassigned, Texas, US |
2021-10-31 | US | Texas | Runnels | 48399 | 1705 | 54 | 0 | 31.8314342 | -99.97616148 | 2021-11-01 04:22:01 | Runnels, Texas, US | |
2021-10-31 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-11-01 04:22:01 | Unassigned, Texas, US | |
2022-11-15 | US | Texas | Runnels | 48399 | 2658 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-16 04:21:09 | Runnels, Texas, US | |
2022-11-15 | US | Texas | Unassigned | 90048 | 94771 | 32 | 0 | 36.27829105 | -99.97616148 | 2022-11-16 04:21:09 | Unassigned, Texas, US | |
2021-07-15 | US | Texas | Runnels | 48399 | 1308 | 39 | 0 | 31.8314342 | -99.97616148 | 2021-07-16 04:21:22 | Runnels, Texas, US | |
2021-07-15 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-07-16 04:21:22 | Unassigned, Texas, US | |
2020-07-01 | US | Texas | Runnels | 48399 | 19 | 0 | 0 | 8 | 31.8314342 | -99.97616148 | 2020-07-02 04:33:46 | Runnels, Texas, US |
2020-07-01 | US | Texas | Unassigned | 90048 | 937 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-07-02 04:33:46 | Unassigned, Texas, US |
2022-04-16 | US | Texas | Runnels | 48399 | 2310 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-04-17 04:20:59 | Runnels, Texas, US | |
2022-04-16 | US | Texas | Unassigned | 90048 | 75233 | 26 | 0 | 36.27829105 | -99.97616148 | 2022-04-17 04:20:59 | Unassigned, Texas, US | |
2022-12-13 | US | Texas | Runnels | 48399 | 2685 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-14 04:21:04 | Runnels, Texas, US | |
2022-12-13 | US | Texas | Unassigned | 90048 | 95963 | 33 | 0 | 36.27829105 | -99.97616148 | 2022-12-14 04:21:04 | Unassigned, Texas, US | |
2022-11-13 | US | Texas | Runnels | 48399 | 2656 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-14 04:21:09 | Runnels, Texas, US | |
2022-11-13 | US | Texas | Unassigned | 90048 | 94624 | 32 | 0 | 36.27829105 | -99.97616148 | 2022-11-14 04:21:09 | Unassigned, Texas, US | |
2022-02-12 | US | Texas | Runnels | 48399 | 2207 | 61 | 0 | 31.8314342 | -99.97616148 | 2022-02-13 04:21:00 | Runnels, Texas, US | |
2022-02-12 | US | Texas | Unassigned | 90048 | 72064 | 20 | 0 | 36.27829105 | -99.97616148 | 2022-02-13 04:21:00 | Unassigned, Texas, US | |
2022-10-30 | US | Texas | Runnels | 48399 | 2628 | 70 | 0 | 31.8314342 | -99.97616148 | 2022-10-31 04:21:36 | Runnels, Texas, US | |
2022-10-30 | US | Texas | Unassigned | 90048 | 94339 | 32 | 0 | 36.27829105 | -99.97616148 | 2022-10-31 04:21:36 | Unassigned, Texas, US | |
2020-07-20 | US | Texas | Runnels | 48399 | 56 | 0 | 0 | 35 | 31.8314342 | -99.97616148 | 2020-07-21 04:38:46 | Runnels, Texas, US |
2020-07-20 | US | Texas | Unassigned | 90048 | 2100 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-07-21 04:38:46 | Unassigned, Texas, US |
2022-12-27 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-28 04:21:04 | Runnels, Texas, US | |
2022-12-27 | US | Texas | Unassigned | 90048 | 95963 | 33 | 0 | 36.27829105 | -99.97616148 | 2022-12-28 04:21:04 | Unassigned, Texas, US | |
2021-08-04 | US | Texas | Runnels | 48399 | 1342 | 40 | 0 | 31.8314342 | -99.97616148 | 2021-08-05 04:21:51 | Runnels, Texas, US | |
2021-08-04 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-08-05 04:21:51 | Unassigned, Texas, US | |
2022-03-18 | US | Texas | Runnels | 48399 | 2281 | 65 | 0 | 31.8314342 | -99.97616148 | 2022-03-19 04:20:47 | Runnels, Texas, US | |
2022-03-18 | US | Texas | Unassigned | 90048 | 74517 | 23 | 0 | 36.27829105 | -99.97616148 | 2022-03-19 04:20:47 | Unassigned, Texas, US | |
2021-02-03 | US | Texas | Runnels | 48399 | 1208 | 32 | 0 | 1178 | 31.8314342 | -99.97616148 | 2021-02-04 05:22:26 | Runnels, Texas, US |
2021-02-03 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-02-04 05:22:26 | Unassigned, Texas, US |
2020-09-14 | US | Texas | Runnels | 48399 | 219 | 5 | 0 | 227 | 31.8314342 | -99.97616148 | 2020-09-15 03:22:50 | Runnels, Texas, US |
2020-09-14 | US | Texas | Unassigned | 90048 | 5338 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-09-15 03:22:50 | Unassigned, Texas, US |
2022-12-14 | US | Texas | Runnels | 48399 | 2687 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-15 04:20:58 | Runnels, Texas, US | |
2022-12-14 | US | Texas | Unassigned | 90048 | 95963 | 33 | 0 | 36.27829105 | -99.97616148 | 2022-12-15 04:20:58 | Unassigned, Texas, US | |
2021-03-11 | US | Texas | Runnels | 48399 | 1260 | 36 | 0 | 31.8314342 | -99.97616148 | 2021-03-12 05:26:50 | Runnels, Texas, US | |
2021-03-11 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-03-12 05:26:50 | Unassigned, Texas, US | |
2022-03-11 | US | Texas | Runnels | 48399 | 2277 | 64 | 0 | 31.8314342 | -99.97616148 | 2022-03-12 04:20:50 | Runnels, Texas, US | |
2022-03-11 | US | Texas | Unassigned | 90048 | 74304 | 23 | 0 | 36.27829105 | -99.97616148 | 2022-03-12 04:20:50 | Unassigned, Texas, US | |
2022-05-07 | US | Texas | Runnels | 48399 | 2390 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-05-08 04:20:49 | Runnels, Texas, US | |
2022-05-07 | US | Texas | Unassigned | 90048 | 75848 | 30 | 0 | 36.27829105 | -99.97616148 | 2022-05-08 04:20:49 | Unassigned, Texas, US | |
2020-07-16 | US | Texas | Runnels | 48399 | 42 | 0 | 0 | 31 | 31.8314342 | -99.97616148 | 2020-07-17 04:34:50 | Runnels, Texas, US |
2020-07-16 | US | Texas | Unassigned | 90048 | 1873 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-07-17 04:34:50 | Unassigned, Texas, US |
2020-08-08 | US | Texas | Runnels | 48399 | 109 | 1 | 0 | 123 | 31.8314342 | -99.97616148 | 2020-08-09 04:34:54 | Runnels, Texas, US |
2020-08-08 | US | Texas | Unassigned | 90048 | 3714 | 239 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-08-05 23:35:35 | Unassigned, Texas, US |
2022-09-13 | US | Texas | Runnels | 48399 | 2602 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-14 04:20:44 | Runnels, Texas, US | |
2022-09-13 | US | Texas | Unassigned | 90048 | 90725 | 30 | 0 | 36.27829105 | -99.97616148 | 2022-08-30 23:21:09 | Unassigned, Texas, US | |
2020-11-06 | US | Texas | Runnels | 48399 | 350 | 9 | 0 | 393 | 31.8314342 | -99.97616148 | 2020-11-07 05:24:52 | Runnels, Texas, US |
2020-11-06 | US | Texas | Unassigned | 90048 | 7512 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-11-07 05:24:52 | Unassigned, Texas, US |
2021-04-30 | US | Texas | Runnels | 48399 | 1284 | 37 | 0 | 31.8314342 | -99.97616148 | 2021-05-01 04:20:47 | Runnels, Texas, US | |
2021-04-30 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-05-01 04:20:47 | Unassigned, Texas, US | |
2022-09-23 | US | Texas | Runnels | 48399 | 2617 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-09-24 04:21:40 | Runnels, Texas, US | |
2022-09-23 | US | Texas | Unassigned | 90048 | 90725 | 30 | 0 | 36.27829105 | -99.97616148 | 2022-08-30 23:21:09 | Unassigned, Texas, US | |
2021-04-04 | US | Texas | Runnels | 48399 | 1266 | 37 | 0 | 31.8314342 | -99.97616148 | 2021-04-05 04:20:35 | Runnels, Texas, US | |
2021-04-04 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-04-05 04:20:35 | Unassigned, Texas, US | |
2020-11-27 | US | Texas | Runnels | 48399 | 476 | 11 | 0 | 490 | 31.8314342 | -99.97616148 | 2020-11-28 05:25:50 | Runnels, Texas, US |
2020-11-27 | US | Texas | Unassigned | 90048 | 9434 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-11-28 05:25:50 | Unassigned, Texas, US |
2022-10-07 | US | Texas | Runnels | 48399 | 2623 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-08 04:22:56 | Runnels, Texas, US | |
2022-10-07 | US | Texas | Unassigned | 90048 | 93797 | 31 | 0 | 36.27829105 | -99.97616148 | 2022-10-08 04:22:56 | Unassigned, Texas, US | |
2021-06-29 | US | Texas | Runnels | 48399 | 1306 | 40 | 0 | 31.8314342 | -99.97616148 | 2021-06-30 04:21:41 | Runnels, Texas, US | |
2021-06-29 | US | Texas | Unassigned | 90048 | 13550 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-06-30 04:21:41 | Unassigned, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;