daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
254,491 rows where province_or_state = "Texas" sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-13 | US | Texas | Bandera | 48019 | 0 | 0 | 0 | 2 | 29.74619598 | -99.24598147 | 2020-04-13 23:07:54 | Bandera, Texas, US |
2020-04-13 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 4 | 30.26640707 | -98.3999852 | 2020-04-13 23:07:54 | Blanco, Texas, US |
2020-04-13 | US | Texas | Callahan | 48059 | 0 | 0 | 0 | 1 | 32.29760619 | -99.37326312 | 2020-04-13 23:07:54 | Callahan, Texas, US |
2020-04-13 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 2 | 33.78686685 | -98.20771198 | 2020-04-13 23:07:54 | Clay, Texas, US |
2020-04-13 | US | Texas | Cooke | 48097 | 0 | 0 | 0 | 1 | 33.63979567 | -97.21240912 | 2020-04-13 23:07:54 | Cooke, Texas, US |
2020-04-13 | US | Texas | Crosby | 48107 | 0 | 0 | 0 | 1 | 33.61431553 | -101.30003640000001 | 2020-04-13 23:07:54 | Crosby, Texas, US |
2020-04-13 | US | Texas | Dallam | 48111 | 0 | 0 | 0 | 1 | 36.27787176 | -102.60207249999999 | 2020-04-13 23:07:54 | Dallam, Texas, US |
2020-04-13 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-13 23:07:54 | Dimmit, Texas, US |
2020-04-13 | US | Texas | Falls | 48145 | 0 | 0 | 0 | 1 | 31.25350609 | -96.93630086 | 2020-04-13 23:07:54 | Falls, Texas, US |
2020-04-13 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-13 23:07:54 | Gillespie, Texas, US |
2020-04-13 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 4 | 28.65696592 | -97.42760647 | 2020-04-13 23:07:54 | Goliad, Texas, US |
2020-04-13 | US | Texas | Hansford | 48195 | 0 | 0 | 0 | 1 | 36.27743284 | -101.3545796 | 2020-04-13 23:07:54 | Hansford, Texas, US |
2020-04-13 | US | Texas | Jasper | 48241 | 0 | 0 | 0 | 7 | 30.74685667 | -94.02667579 | 2020-04-13 23:07:54 | Jasper, Texas, US |
2020-04-13 | US | Texas | Jones | 48253 | 0 | 0 | 0 | 2 | 32.73997145 | -99.87861576 | 2020-04-13 23:07:54 | Jones, Texas, US |
2020-04-13 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 2 | 28.90705334 | -97.85960149 | 2020-04-13 23:07:54 | Karnes, Texas, US |
2020-04-13 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-13 23:07:54 | Lee, Texas, US |
2020-04-13 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-13 23:07:54 | Llano, Texas, US |
2020-04-13 | US | Texas | Madison | 48313 | 0 | 0 | 0 | 1 | 30.96694679 | -95.93003775 | 2020-04-13 23:07:54 | Madison, Texas, US |
2020-04-13 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-13 23:07:54 | Martin, Texas, US |
2020-04-13 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-04-13 23:07:54 | Motley, Texas, US |
2020-04-13 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-13 23:07:54 | Newton, Texas, US |
2020-04-13 | US | Texas | Rains | 48379 | 0 | 0 | 0 | 1 | 32.87109387 | -95.79232691 | 2020-04-13 23:07:54 | Rains, Texas, US |
2020-04-13 | US | Texas | Robertson | 48395 | 0 | 0 | 0 | 2 | 31.02539637 | -96.51272246 | 2020-04-13 23:07:54 | Robertson, Texas, US |
2020-04-13 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-13 23:07:54 | Stephens, Texas, US |
2020-04-13 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-13 23:07:54 | Uvalde, Texas, US |
2020-04-17 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 5 | 30.26640707 | -98.3999852 | 2020-04-17 23:30:52 | Blanco, Texas, US |
2020-04-17 | US | Texas | Callahan | 48059 | 0 | 0 | 0 | 1 | 32.29760619 | -99.37326312 | 2020-04-17 23:30:52 | Callahan, Texas, US |
2020-04-17 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-17 23:30:52 | Clay, Texas, US |
2020-04-17 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 0 | 33.61431553 | -101.30003640000001 | 2020-04-17 23:30:52 | Crosby, Texas, US |
2020-04-17 | US | Texas | Dallam | 48111 | 0 | 0 | 0 | 3 | 36.27787176 | -102.60207249999999 | 2020-04-17 23:30:52 | Dallam, Texas, US |
2020-04-17 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-17 23:30:52 | Dimmit, Texas, US |
2020-04-17 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 1 | 27.68184592 | -98.50864568 | 2020-04-17 23:30:52 | Duval, Texas, US |
2020-04-17 | US | Texas | Falls | 48145 | 0 | 0 | 0 | 1 | 31.25350609 | -96.93630086 | 2020-04-17 23:30:52 | Falls, Texas, US |
2020-04-17 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-17 23:30:52 | Gillespie, Texas, US |
2020-04-17 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 5 | 28.65696592 | -97.42760647 | 2020-04-17 23:30:52 | Goliad, Texas, US |
2020-04-17 | US | Texas | Jones | 48253 | 0 | 0 | 0 | 3 | 32.73997145 | -99.87861576 | 2020-04-17 23:30:52 | Jones, Texas, US |
2020-04-17 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-04-17 23:30:52 | Karnes, Texas, US |
2020-04-17 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-17 23:30:52 | Lee, Texas, US |
2020-04-17 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-17 23:30:52 | Llano, Texas, US |
2020-04-17 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-17 23:30:52 | Martin, Texas, US |
2020-04-17 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-04-17 23:30:52 | Motley, Texas, US |
2020-04-17 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-17 23:30:52 | Newton, Texas, US |
2020-04-17 | US | Texas | Red River | 48387 | 0 | 0 | 0 | 1 | 33.61886692 | -95.04841765 | 2020-04-17 23:30:52 | Red River, Texas, US |
2020-04-17 | US | Texas | Robertson | 48395 | 0 | 0 | 0 | 2 | 31.02539637 | -96.51272246 | 2020-04-17 23:30:52 | Robertson, Texas, US |
2020-04-17 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-04-17 23:30:52 | Sabine, Texas, US |
2020-04-17 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-17 23:30:52 | Stephens, Texas, US |
2020-04-17 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-17 23:30:52 | Uvalde, Texas, US |
2020-04-17 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-04-17 23:30:52 | Zavala, Texas, US |
2020-05-08 | US | Texas | Bailey | 48017 | 0 | 0 | 0 | 2 | 34.06854817 | -102.8299707 | 2020-05-09 02:32:35 | Bailey, Texas, US |
2020-05-08 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 6 | 30.26640707 | -98.3999852 | 2020-05-09 02:32:35 | Blanco, Texas, US |
2020-05-08 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-05-09 02:32:35 | Brooks, Texas, US |
2020-05-08 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-05-09 02:32:35 | Clay, Texas, US |
2020-05-08 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 2 | 31.76736834 | -99.45240766 | 2020-05-09 02:32:35 | Coleman, Texas, US |
2020-05-08 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 1 | 33.61431553 | -101.3000364 | 2020-05-09 02:32:35 | Crosby, Texas, US |
2020-05-08 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-05-09 02:32:35 | Dimmit, Texas, US |
2020-05-08 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-05-09 02:32:35 | Goliad, Texas, US |
2020-05-08 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-05-09 02:32:35 | Karnes, Texas, US |
2020-05-08 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 4 | 30.31120597 | -96.97045773 | 2020-05-09 02:32:35 | Lee, Texas, US |
2020-05-08 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-05-09 02:32:35 | Llano, Texas, US |
2020-05-08 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-05-09 02:32:35 | Motley, Texas, US |
2020-05-08 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 4 | 30.78548982 | -93.74408813 | 2020-05-09 02:32:35 | Newton, Texas, US |
2020-05-08 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 2 | 31.34318809 | -93.85440451 | 2020-05-09 02:32:35 | Sabine, Texas, US |
2020-05-08 | US | Texas | Shackelford | 48417 | 0 | 0 | 0 | 1 | 32.73587756 | -99.35401337 | 2020-05-09 02:32:35 | Shackelford, Texas, US |
2020-05-08 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-05-09 02:32:35 | Stephens, Texas, US |
2020-05-08 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 7 | 29.35739637 | -99.76229172 | 2020-05-09 02:32:35 | Uvalde, Texas, US |
2020-05-08 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-05-09 02:32:35 | Zavala, Texas, US |
2020-04-29 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 6 | 30.26640707 | -98.3999852 | 2020-04-30 02:32:27 | Blanco, Texas, US |
2020-04-29 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-04-30 02:32:27 | Brooks, Texas, US |
2020-04-29 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-30 02:32:27 | Clay, Texas, US |
2020-04-29 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 1 | 31.76736834 | -99.45240766 | 2020-04-30 02:32:27 | Coleman, Texas, US |
2020-04-29 | US | Texas | Cottle | 48101 | 0 | 0 | 0 | 2 | 34.07783319 | -100.27850620000001 | 2020-04-30 02:32:27 | Cottle, Texas, US |
2020-04-29 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 1 | 33.61431553 | -101.30003640000001 | 2020-04-30 02:32:27 | Crosby, Texas, US |
2020-04-29 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-30 02:32:27 | Dimmit, Texas, US |
2020-04-29 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 2 | 27.68184592 | -98.50864568 | 2020-04-30 02:32:27 | Duval, Texas, US |
2020-04-29 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-30 02:32:27 | Gillespie, Texas, US |
2020-04-29 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-04-30 02:32:27 | Goliad, Texas, US |
2020-04-29 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-04-30 02:32:27 | Karnes, Texas, US |
2020-04-29 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-30 02:32:27 | Lee, Texas, US |
2020-04-29 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-30 02:32:27 | Llano, Texas, US |
2020-04-29 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-30 02:32:27 | Martin, Texas, US |
2020-04-29 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-04-30 02:32:27 | Motley, Texas, US |
2020-04-29 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-30 02:32:27 | Newton, Texas, US |
2020-04-29 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-04-30 02:32:27 | Sabine, Texas, US |
2020-04-29 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-30 02:32:27 | Stephens, Texas, US |
2020-04-29 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-30 02:32:27 | Uvalde, Texas, US |
2020-04-29 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-04-30 02:32:27 | Zavala, Texas, US |
2020-08-15 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-08-16 04:27:42 | Borden, Texas, US |
2020-08-15 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-16 04:27:42 | Loving, Texas, US |
2020-08-31 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-09-01 04:28:31 | Borden, Texas, US |
2020-08-31 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-09-01 04:28:31 | Loving, Texas, US |
2020-08-19 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-08-20 04:27:43 | Borden, Texas, US |
2020-08-19 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-20 04:27:43 | Loving, Texas, US |
2020-06-08 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-06-09 03:33:03 | Brooks, Texas, US |
2020-06-08 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-06-09 03:33:03 | Dimmit, Texas, US |
2020-06-08 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-06-09 03:33:03 | Goliad, Texas, US |
2020-06-08 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 4 | 28.90705334 | -97.85960149 | 2020-06-09 03:33:03 | Karnes, Texas, US |
2020-06-08 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-06-09 03:33:03 | Motley, Texas, US |
2020-06-08 | US | Texas | Shackelford | 48417 | 0 | 0 | 0 | 1 | 32.73587756 | -99.35401337 | 2020-06-09 03:33:03 | Shackelford, Texas, US |
2020-06-08 | US | Texas | Throckmorton | 48447 | 0 | 0 | 0 | 1 | 33.17751417 | -99.21226795 | 2020-06-09 03:33:03 | Throckmorton, Texas, US |
2020-04-30 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 6 | 30.26640707 | -98.3999852 | 2020-05-01 02:32:28 | Blanco, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;