daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
621 rows where deaths = 63 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-12-29 | US | Texas | Lee | 48287 | 5101 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-30 04:21:04 | Lee, Texas, US | |
2022-12-29 | US | Texas | Newton | 48351 | 1703 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-30 04:21:04 | Newton, Texas, US | |
2022-12-28 | US | Texas | Lee | 48287 | 5101 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-29 04:21:01 | Lee, Texas, US | |
2022-12-28 | US | Texas | Newton | 48351 | 1703 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-29 04:21:01 | Newton, Texas, US | |
2022-12-27 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-28 04:21:04 | Lee, Texas, US | |
2022-12-27 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-28 04:21:04 | Newton, Texas, US | |
2022-12-26 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-27 04:21:07 | Lee, Texas, US | |
2022-12-26 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-27 04:21:07 | Newton, Texas, US | |
2022-12-25 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-26 04:21:06 | Lee, Texas, US | |
2022-12-25 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-26 04:21:06 | Newton, Texas, US | |
2022-12-24 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-25 04:21:04 | Lee, Texas, US | |
2022-12-24 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-25 04:21:04 | Newton, Texas, US | |
2022-12-23 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-24 04:21:02 | Lee, Texas, US | |
2022-12-23 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-24 04:21:02 | Newton, Texas, US | |
2022-12-22 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-23 04:21:04 | Lee, Texas, US | |
2022-12-22 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-23 04:21:04 | Newton, Texas, US | |
2022-12-21 | US | Texas | Lee | 48287 | 5081 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-22 04:20:56 | Lee, Texas, US | |
2022-12-21 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-22 04:20:56 | Newton, Texas, US | |
2022-12-20 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-21 04:21:03 | Lee, Texas, US | |
2022-12-20 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-21 04:21:03 | Newton, Texas, US | |
2022-12-19 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-20 04:21:04 | Lee, Texas, US | |
2022-12-19 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-20 04:21:04 | Newton, Texas, US | |
2022-12-18 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-19 04:21:03 | Lee, Texas, US | |
2022-12-18 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-19 04:21:03 | Newton, Texas, US | |
2022-12-17 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-18 04:21:03 | Lee, Texas, US | |
2022-12-17 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-18 04:21:03 | Newton, Texas, US | |
2022-12-16 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-17 04:21:04 | Lee, Texas, US | |
2022-12-16 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-17 04:21:04 | Newton, Texas, US | |
2022-12-15 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-16 04:21:01 | Lee, Texas, US | |
2022-12-15 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-16 04:21:01 | Newton, Texas, US | |
2022-12-14 | US | Texas | Lee | 48287 | 5066 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-15 04:20:58 | Lee, Texas, US | |
2022-12-14 | US | Texas | Newton | 48351 | 1700 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-15 04:20:58 | Newton, Texas, US | |
2022-12-13 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-14 04:21:04 | Lee, Texas, US | |
2022-12-13 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-14 04:21:04 | Newton, Texas, US | |
2022-12-12 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-13 04:21:01 | Lee, Texas, US | |
2022-12-12 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-13 04:21:01 | Newton, Texas, US | |
2022-12-11 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-12 04:21:01 | Lee, Texas, US | |
2022-12-11 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-12 04:21:01 | Newton, Texas, US | |
2022-12-10 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-11 04:20:50 | Lee, Texas, US | |
2022-12-10 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-11 04:20:50 | Newton, Texas, US | |
2022-12-09 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-10 04:21:02 | Lee, Texas, US | |
2022-12-09 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-10 04:21:02 | Newton, Texas, US | |
2022-12-08 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-09 04:21:05 | Lee, Texas, US | |
2022-12-08 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-09 04:21:05 | Newton, Texas, US | |
2022-12-07 | US | Texas | Lee | 48287 | 5048 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-08 04:21:07 | Lee, Texas, US | |
2022-12-07 | US | Texas | Newton | 48351 | 1699 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-08 04:21:07 | Newton, Texas, US | |
2022-12-06 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-07 04:20:58 | Lee, Texas, US | |
2022-12-06 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-07 04:20:58 | Newton, Texas, US | |
2022-12-05 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-06 04:21:03 | Lee, Texas, US | |
2022-12-05 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-06 04:21:03 | Newton, Texas, US | |
2022-12-04 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-05 04:20:58 | Lee, Texas, US | |
2022-12-04 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-05 04:20:58 | Newton, Texas, US | |
2022-12-03 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-04 04:20:56 | Lee, Texas, US | |
2022-12-03 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-04 04:20:56 | Newton, Texas, US | |
2022-12-02 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-03 04:21:02 | Lee, Texas, US | |
2022-12-02 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-03 04:21:02 | Newton, Texas, US | |
2022-12-01 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-02 04:21:07 | Lee, Texas, US | |
2022-12-01 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-02 04:21:07 | Newton, Texas, US | |
2022-11-30 | US | Texas | Lee | 48287 | 5020 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-12-01 04:21:03 | Lee, Texas, US | |
2022-11-30 | US | Texas | Newton | 48351 | 1697 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-12-01 04:21:03 | Newton, Texas, US | |
2022-11-29 | US | Texas | Lee | 48287 | 5009 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-30 04:21:07 | Lee, Texas, US | |
2022-11-29 | US | Texas | Newton | 48351 | 1696 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-30 04:21:07 | Newton, Texas, US | |
2022-11-28 | US | Texas | Lee | 48287 | 5009 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-29 04:21:05 | Lee, Texas, US | |
2022-11-28 | US | Texas | Newton | 48351 | 1696 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-29 04:21:05 | Newton, Texas, US | |
2022-11-27 | US | Texas | Lee | 48287 | 5003 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-28 04:21:02 | Lee, Texas, US | |
2022-11-27 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-28 04:21:02 | Newton, Texas, US | |
2022-11-26 | US | Texas | Lee | 48287 | 5003 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-27 04:21:05 | Lee, Texas, US | |
2022-11-26 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-27 04:21:05 | Newton, Texas, US | |
2022-11-25 | US | Texas | Lee | 48287 | 5003 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-26 04:21:11 | Lee, Texas, US | |
2022-11-25 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-26 04:21:11 | Newton, Texas, US | |
2022-11-24 | US | Texas | Lee | 48287 | 5003 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-25 04:21:06 | Lee, Texas, US | |
2022-11-24 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-25 04:21:06 | Newton, Texas, US | |
2022-11-23 | US | Texas | Lee | 48287 | 5003 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-24 04:21:09 | Lee, Texas, US | |
2022-11-23 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-24 04:21:09 | Newton, Texas, US | |
2022-11-22 | US | Texas | Lee | 48287 | 5001 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-23 04:21:06 | Lee, Texas, US | |
2022-11-22 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-23 04:21:06 | Newton, Texas, US | |
2022-11-21 | US | Texas | Lee | 48287 | 5001 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-22 04:20:47 | Lee, Texas, US | |
2022-11-21 | US | Texas | Newton | 48351 | 1694 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-22 04:20:47 | Newton, Texas, US | |
2022-11-20 | US | Texas | Lee | 48287 | 4996 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-21 04:21:05 | Lee, Texas, US | |
2022-11-20 | US | Texas | Newton | 48351 | 1693 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-21 04:21:05 | Newton, Texas, US | |
2022-11-19 | US | Texas | Lee | 48287 | 4996 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-20 04:21:08 | Lee, Texas, US | |
2022-11-19 | US | Texas | Newton | 48351 | 1693 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-20 04:21:08 | Newton, Texas, US | |
2022-11-18 | US | Texas | Lee | 48287 | 4996 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-19 04:21:14 | Lee, Texas, US | |
2022-11-18 | US | Texas | Newton | 48351 | 1693 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-19 04:21:14 | Newton, Texas, US | |
2022-11-17 | US | Texas | Lee | 48287 | 4993 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-18 04:21:15 | Lee, Texas, US | |
2022-11-17 | US | Texas | Newton | 48351 | 1693 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-18 04:21:15 | Newton, Texas, US | |
2022-11-16 | US | Texas | Lee | 48287 | 4993 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-17 04:21:11 | Lee, Texas, US | |
2022-11-16 | US | Texas | Newton | 48351 | 1693 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-17 04:21:11 | Newton, Texas, US | |
2022-11-15 | US | Texas | Lee | 48287 | 4983 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-16 04:21:09 | Lee, Texas, US | |
2022-11-15 | US | Texas | Newton | 48351 | 1692 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-16 04:21:09 | Newton, Texas, US | |
2022-11-14 | US | Texas | Lee | 48287 | 4983 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-15 04:21:16 | Lee, Texas, US | |
2022-11-14 | US | Texas | Newton | 48351 | 1692 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-15 04:21:16 | Newton, Texas, US | |
2022-11-13 | US | Texas | Lee | 48287 | 4982 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-14 04:21:09 | Lee, Texas, US | |
2022-11-13 | US | Texas | Newton | 48351 | 1692 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-14 04:21:09 | Newton, Texas, US | |
2022-11-12 | US | Texas | Lee | 48287 | 4982 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-13 04:21:14 | Lee, Texas, US | |
2022-11-12 | US | Texas | Newton | 48351 | 1692 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-13 04:21:14 | Newton, Texas, US | |
2022-11-11 | US | Texas | Lee | 48287 | 4982 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-12 04:20:41 | Lee, Texas, US | |
2022-11-11 | US | Texas | Newton | 48351 | 1692 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-12 04:20:41 | Newton, Texas, US | |
2022-11-10 | US | Texas | Lee | 48287 | 4982 | 63 | 0 | 30.31120597 | -96.97045773 | 2022-11-11 04:21:22 | Lee, Texas, US | |
2022-11-10 | US | Texas | Newton | 48351 | 1692 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-11-11 04:21:22 | Newton, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;