daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
256 rows where country_or_region = "US", deaths = 121 and province_or_state = "Texas" sorted by day 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-27 | US | Texas | Lavaca | 48285 | 4476 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-28 04:20:56 | Lavaca, Texas, US | |
2022-07-26 | US | Texas | Lavaca | 48285 | 4473 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-27 04:21:04 | Lavaca, Texas, US | |
2022-07-25 | US | Texas | Lavaca | 48285 | 4468 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-26 04:20:58 | Lavaca, Texas, US | |
2022-07-24 | US | Texas | Lavaca | 48285 | 4463 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-25 04:20:51 | Lavaca, Texas, US | |
2022-07-23 | US | Texas | Lavaca | 48285 | 4462 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-24 04:20:47 | Lavaca, Texas, US | |
2022-07-22 | US | Texas | Lavaca | 48285 | 4460 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-23 04:20:53 | Lavaca, Texas, US | |
2022-07-21 | US | Texas | Lavaca | 48285 | 4457 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-22 04:21:15 | Lavaca, Texas, US | |
2022-07-20 | US | Texas | Lavaca | 48285 | 4449 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-21 04:21:10 | Lavaca, Texas, US | |
2022-07-19 | US | Texas | Lavaca | 48285 | 4445 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-20 04:20:59 | Lavaca, Texas, US | |
2022-07-18 | US | Texas | Lavaca | 48285 | 4438 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-19 04:20:58 | Lavaca, Texas, US | |
2022-07-17 | US | Texas | Lavaca | 48285 | 4436 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-18 04:20:59 | Lavaca, Texas, US | |
2022-07-16 | US | Texas | Lavaca | 48285 | 4436 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-17 04:21:15 | Lavaca, Texas, US | |
2022-07-15 | US | Texas | Lavaca | 48285 | 4433 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-16 04:21:05 | Lavaca, Texas, US | |
2022-07-14 | US | Texas | Lavaca | 48285 | 4426 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-15 04:20:53 | Lavaca, Texas, US | |
2022-07-13 | US | Texas | Lavaca | 48285 | 4419 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-14 04:20:57 | Lavaca, Texas, US | |
2022-07-12 | US | Texas | Lavaca | 48285 | 4413 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-13 04:20:58 | Lavaca, Texas, US | |
2022-07-11 | US | Texas | Lavaca | 48285 | 4407 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-12 04:20:51 | Lavaca, Texas, US | |
2022-07-10 | US | Texas | Lavaca | 48285 | 4405 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-11 04:20:46 | Lavaca, Texas, US | |
2022-07-09 | US | Texas | Lavaca | 48285 | 4402 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-10 04:20:54 | Lavaca, Texas, US | |
2022-07-08 | US | Texas | Lavaca | 48285 | 4401 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-09 04:20:59 | Lavaca, Texas, US | |
2022-07-07 | US | Texas | Lavaca | 48285 | 4398 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-08 04:20:56 | Lavaca, Texas, US | |
2022-07-06 | US | Texas | Lavaca | 48285 | 4396 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-07 04:20:55 | Lavaca, Texas, US | |
2022-07-05 | US | Texas | Lavaca | 48285 | 4390 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-06 04:20:58 | Lavaca, Texas, US | |
2022-07-04 | US | Texas | Lavaca | 48285 | 4382 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-05 04:20:45 | Lavaca, Texas, US | |
2022-07-03 | US | Texas | Lavaca | 48285 | 4382 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-04 04:20:54 | Lavaca, Texas, US | |
2022-07-02 | US | Texas | Lavaca | 48285 | 4382 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-03 04:20:59 | Lavaca, Texas, US | |
2022-07-01 | US | Texas | Lavaca | 48285 | 4382 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-02 04:21:16 | Lavaca, Texas, US | |
2022-06-30 | US | Texas | Lavaca | 48285 | 4378 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-01 04:21:10 | Lavaca, Texas, US | |
2022-06-29 | US | Texas | Lavaca | 48285 | 4374 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-30 04:21:01 | Lavaca, Texas, US | |
2022-06-28 | US | Texas | Lavaca | 48285 | 4370 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-29 04:20:59 | Lavaca, Texas, US | |
2022-06-27 | US | Texas | Lavaca | 48285 | 4364 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-28 04:20:58 | Lavaca, Texas, US | |
2022-06-26 | US | Texas | Lavaca | 48285 | 4361 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-27 04:21:00 | Lavaca, Texas, US | |
2022-06-25 | US | Texas | Lavaca | 48285 | 4361 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-26 04:21:02 | Lavaca, Texas, US | |
2022-06-24 | US | Texas | Lavaca | 48285 | 4359 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-25 04:20:57 | Lavaca, Texas, US | |
2022-06-23 | US | Texas | Lavaca | 48285 | 4353 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-24 04:20:58 | Lavaca, Texas, US | |
2022-06-22 | US | Texas | Grimes | 48185 | 8705 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-23 04:20:55 | Grimes, Texas, US | |
2022-06-22 | US | Texas | Lavaca | 48285 | 4350 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-23 04:20:55 | Lavaca, Texas, US | |
2022-06-21 | US | Texas | Grimes | 48185 | 8695 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-22 04:20:54 | Grimes, Texas, US | |
2022-06-21 | US | Texas | Lavaca | 48285 | 4329 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-22 04:20:54 | Lavaca, Texas, US | |
2022-06-20 | US | Texas | Grimes | 48185 | 8673 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-21 04:20:56 | Grimes, Texas, US | |
2022-06-20 | US | Texas | Lavaca | 48285 | 4322 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-21 04:20:56 | Lavaca, Texas, US | |
2022-06-19 | US | Texas | Grimes | 48185 | 8668 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-20 04:21:01 | Grimes, Texas, US | |
2022-06-19 | US | Texas | Lavaca | 48285 | 4319 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-20 04:21:01 | Lavaca, Texas, US | |
2022-06-18 | US | Texas | Grimes | 48185 | 8661 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-19 04:20:51 | Grimes, Texas, US | |
2022-06-18 | US | Texas | Lavaca | 48285 | 4316 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-19 04:20:51 | Lavaca, Texas, US | |
2022-06-17 | US | Texas | Grimes | 48185 | 8655 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-18 04:21:10 | Grimes, Texas, US | |
2022-06-17 | US | Texas | Lavaca | 48285 | 4314 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-18 04:21:10 | Lavaca, Texas, US | |
2022-06-16 | US | Texas | Grimes | 48185 | 8652 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-17 04:20:56 | Grimes, Texas, US | |
2022-06-16 | US | Texas | Lavaca | 48285 | 4313 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-17 04:20:56 | Lavaca, Texas, US | |
2022-06-15 | US | Texas | Grimes | 48185 | 8647 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-16 04:20:55 | Grimes, Texas, US | |
2022-06-15 | US | Texas | Lavaca | 48285 | 4306 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-06-16 04:20:55 | Lavaca, Texas, US | |
2022-06-14 | US | Texas | Grimes | 48185 | 8644 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-15 04:20:54 | Grimes, Texas, US | |
2022-06-13 | US | Texas | Grimes | 48185 | 8633 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-14 04:20:52 | Grimes, Texas, US | |
2022-06-12 | US | Texas | Grimes | 48185 | 8627 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-13 04:21:14 | Grimes, Texas, US | |
2022-06-11 | US | Texas | Grimes | 48185 | 8621 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-12 04:20:53 | Grimes, Texas, US | |
2022-06-10 | US | Texas | Grimes | 48185 | 8614 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-11 04:21:01 | Grimes, Texas, US | |
2022-06-09 | US | Texas | Grimes | 48185 | 8610 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-10 04:20:55 | Grimes, Texas, US | |
2022-06-08 | US | Texas | Grimes | 48185 | 8606 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-09 04:20:54 | Grimes, Texas, US | |
2022-06-08 | US | Texas | Kendall | 48259 | 8460 | 121 | 0 | 29.94414155 | -98.7113588 | 2022-06-09 04:20:54 | Kendall, Texas, US | |
2022-06-07 | US | Texas | Grimes | 48185 | 8602 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-08 04:20:55 | Grimes, Texas, US | |
2022-06-06 | US | Texas | Grimes | 48185 | 8597 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-07 04:21:08 | Grimes, Texas, US | |
2022-06-05 | US | Texas | Grimes | 48185 | 8595 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-06 04:20:57 | Grimes, Texas, US | |
2022-06-04 | US | Texas | Grimes | 48185 | 8588 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-05 04:20:55 | Grimes, Texas, US | |
2022-06-03 | US | Texas | Grimes | 48185 | 8583 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-04 04:20:58 | Grimes, Texas, US | |
2022-06-02 | US | Texas | Grimes | 48185 | 8581 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-03 04:20:58 | Grimes, Texas, US | |
2022-06-01 | US | Texas | Grimes | 48185 | 8577 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-02 05:20:39 | Grimes, Texas, US | |
2022-05-31 | US | Texas | Grimes | 48185 | 8570 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-01 04:20:55 | Grimes, Texas, US | |
2022-03-04 | US | Texas | Erath | 48143 | 8597 | 121 | 0 | 32.23602653 | -98.21773417 | 2022-03-05 04:21:10 | Erath, Texas, US | |
2022-03-03 | US | Texas | Erath | 48143 | 8582 | 121 | 0 | 32.23602653 | -98.21773417 | 2022-03-04 04:21:09 | Erath, Texas, US | |
2022-03-03 | US | Texas | Lamb | 48279 | 4268 | 121 | 0 | 34.06859623 | -102.35162890000001 | 2022-03-04 04:21:09 | Lamb, Texas, US | |
2022-03-03 | US | Texas | Montague | 48337 | 4625 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-03-04 04:21:09 | Montague, Texas, US | |
2022-03-02 | US | Texas | Erath | 48143 | 8561 | 121 | 0 | 32.23602653 | -98.21773417 | 2022-03-03 04:21:01 | Erath, Texas, US | |
2022-03-02 | US | Texas | Montague | 48337 | 4622 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-03-03 04:21:01 | Montague, Texas, US | |
2022-03-01 | US | Texas | Montague | 48337 | 4621 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-03-02 04:21:07 | Montague, Texas, US | |
2022-02-28 | US | Texas | Montague | 48337 | 4620 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-03-01 04:21:09 | Montague, Texas, US | |
2022-02-27 | US | Texas | Montague | 48337 | 4620 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-02-28 04:21:05 | Montague, Texas, US | |
2022-02-26 | US | Texas | Montague | 48337 | 4620 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-02-27 04:21:04 | Montague, Texas, US | |
2022-02-18 | US | Texas | Gray | 48179 | 6014 | 121 | 0 | 35.40081878 | -100.8129222 | 2022-02-19 04:21:11 | Gray, Texas, US | |
2022-02-15 | US | Texas | Titus | 48449 | 8145 | 121 | 0 | 33.21339719 | -94.96797273 | 2022-02-16 04:21:10 | Titus, Texas, US | |
2022-02-14 | US | Texas | Titus | 48449 | 8117 | 121 | 0 | 33.21339719 | -94.96797273 | 2022-02-15 04:21:09 | Titus, Texas, US | |
2022-02-13 | US | Texas | Titus | 48449 | 8112 | 121 | 0 | 33.21339719 | -94.96797273 | 2022-02-14 04:20:51 | Titus, Texas, US | |
2022-02-08 | US | Texas | Cooke | 48097 | 7014 | 121 | 0 | 33.63979567 | -97.21240912 | 2022-02-09 04:21:04 | Cooke, Texas, US | |
2022-02-08 | US | Texas | Shelby | 48419 | 4220 | 121 | 0 | 31.79211404 | -94.14550696 | 2022-02-09 04:21:04 | Shelby, Texas, US | |
2022-02-07 | US | Texas | Shelby | 48419 | 4212 | 121 | 0 | 31.79211404 | -94.14550696 | 2022-02-08 04:21:15 | Shelby, Texas, US | |
2022-02-07 | US | Texas | Willacy | 48489 | 6467 | 121 | 0 | 26.47411727 | -97.61535848 | 2022-02-08 04:21:15 | Willacy, Texas, US | |
2022-02-06 | US | Texas | Shelby | 48419 | 4204 | 121 | 0 | 31.79211404 | -94.14550696 | 2022-02-07 04:21:05 | Shelby, Texas, US | |
2022-02-06 | US | Texas | Willacy | 48489 | 6447 | 121 | 0 | 26.47411727 | -97.61535848 | 2022-02-07 04:21:05 | Willacy, Texas, US | |
2022-02-05 | US | Texas | Willacy | 48489 | 6439 | 121 | 0 | 26.47411727 | -97.61535848 | 2022-02-06 04:21:00 | Willacy, Texas, US | |
2022-02-04 | US | Texas | Willacy | 48489 | 6417 | 121 | 0 | 26.47411727 | -97.61535848 | 2022-02-05 04:21:05 | Willacy, Texas, US | |
2022-02-03 | US | Texas | Willacy | 48489 | 6402 | 121 | 0 | 26.47411727 | -97.61535848 | 2022-02-04 04:21:10 | Willacy, Texas, US | |
2022-02-01 | US | Texas | Hutchinson | 48233 | 6314 | 121 | 0 | 35.84006574 | -101.3546643 | 2022-02-02 04:21:09 | Hutchinson, Texas, US | |
2022-02-01 | US | Texas | Uvalde | 48463 | 10137 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-02-02 04:21:09 | Uvalde, Texas, US | |
2022-01-31 | US | Texas | Uvalde | 48463 | 10109 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-02-01 04:21:11 | Uvalde, Texas, US | |
2022-01-30 | US | Texas | Uvalde | 48463 | 10022 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-01-31 04:21:09 | Uvalde, Texas, US | |
2022-01-29 | US | Texas | Hutchinson | 48233 | 6248 | 121 | 0 | 35.84006574 | -101.3546643 | 2022-01-30 04:21:26 | Hutchinson, Texas, US | |
2022-01-29 | US | Texas | Uvalde | 48463 | 9983 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-01-30 04:21:26 | Uvalde, Texas, US | |
2022-01-28 | US | Texas | Hutchinson | 48233 | 6207 | 121 | 0 | 35.84006574 | -101.3546643 | 2022-01-29 04:21:10 | Hutchinson, Texas, US | |
2022-01-28 | US | Texas | Uvalde | 48463 | 9907 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-01-29 04:21:10 | Uvalde, Texas, US | |
2022-01-27 | US | Texas | Uvalde | 48463 | 9840 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-01-28 04:21:09 | Uvalde, Texas, US | |
2022-01-26 | US | Texas | Uvalde | 48463 | 9749 | 121 | 0 | 29.35739637 | -99.76229172 | 2022-01-27 04:21:19 | Uvalde, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;