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)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-30 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-05-01 02:32:28 | Brooks, Texas, US |
2020-04-30 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-05-01 02:32:28 | Clay, Texas, US |
2020-04-30 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 1 | 31.76736834 | -99.45240766 | 2020-05-01 02:32:28 | Coleman, Texas, US |
2020-04-30 | US | Texas | Cottle | 48101 | 0 | 0 | 0 | 2 | 34.07783319 | -100.27850620000001 | 2020-05-01 02:32:28 | Cottle, Texas, US |
2020-04-30 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 1 | 33.61431553 | -101.30003640000001 | 2020-05-01 02:32:28 | Crosby, Texas, US |
2020-04-30 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-05-01 02:32:28 | Dimmit, Texas, US |
2020-04-30 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 2 | 27.68184592 | -98.50864568 | 2020-05-01 02:32:28 | Duval, Texas, US |
2020-04-30 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-05-01 02:32:28 | Goliad, Texas, US |
2020-04-30 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-05-01 02:32:28 | Karnes, Texas, US |
2020-04-30 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-05-01 02:32:28 | Lee, Texas, US |
2020-04-30 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-05-01 02:32:28 | Llano, Texas, US |
2020-04-30 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-05-01 02:32:28 | Martin, Texas, US |
2020-04-30 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-05-01 02:32:28 | Motley, Texas, US |
2020-04-30 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-05-01 02:32:28 | Newton, Texas, US |
2020-04-30 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-05-01 02:32:28 | Sabine, Texas, US |
2020-04-30 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-05-01 02:32:28 | Stephens, Texas, US |
2020-04-30 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-05-01 02:32:28 | Uvalde, Texas, US |
2020-04-30 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-05-01 02:32:28 | Zavala, Texas, US |
2020-05-21 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-05-22 02:36:51 | Brooks, Texas, US |
2020-05-21 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-05-22 02:36:51 | Clay, Texas, US |
2020-05-21 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 2 | 31.76736834 | -99.45240766 | 2020-05-22 02:36:51 | Coleman, Texas, US |
2020-05-21 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-05-22 02:36:51 | Dimmit, Texas, US |
2020-05-21 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-05-22 02:36:51 | Goliad, Texas, US |
2020-05-21 | US | Texas | Haskell | 48207 | 0 | 0 | 0 | 2 | 33.17823584 | -99.73037358 | 2020-05-22 02:36:51 | Haskell, Texas, US |
2020-05-21 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 4 | 28.90705334 | -97.85960149 | 2020-05-22 02:36:51 | Karnes, Texas, US |
2020-05-21 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-05-22 02:36:51 | Motley, Texas, US |
2020-05-21 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 4 | 30.78548982 | -93.74408813 | 2020-05-22 02:36:51 | Newton, Texas, US |
2020-05-21 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 4 | 31.34318809 | -93.85440451 | 2020-05-22 02:36:51 | Sabine, Texas, US |
2020-05-21 | US | Texas | Shackelford | 48417 | 0 | 0 | 0 | 1 | 32.73587756 | -99.35401337 | 2020-05-22 02:36:51 | Shackelford, Texas, US |
2020-05-21 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-05-22 02:36:51 | Uvalde, Texas, US |
2020-04-28 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 6 | 30.26640707 | -98.3999852 | 2020-04-29 02:32:29 | Blanco, Texas, US |
2020-04-28 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-04-29 02:32:29 | Brooks, Texas, US |
2020-04-28 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-29 02:32:29 | Clay, Texas, US |
2020-04-28 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 1 | 31.76736834 | -99.45240766 | 2020-04-29 02:32:29 | Coleman, Texas, US |
2020-04-28 | US | Texas | Cottle | 48101 | 0 | 0 | 0 | 1 | 34.07783319 | -100.2785062 | 2020-04-29 02:32:29 | Cottle, Texas, US |
2020-04-28 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 1 | 33.61431553 | -101.3000364 | 2020-04-29 02:32:29 | Crosby, Texas, US |
2020-04-28 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-29 02:32:29 | Dimmit, Texas, US |
2020-04-28 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 2 | 27.68184592 | -98.50864568 | 2020-04-29 02:32:29 | Duval, Texas, US |
2020-04-28 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-29 02:32:29 | Gillespie, Texas, US |
2020-04-28 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-04-29 02:32:29 | Goliad, Texas, US |
2020-04-28 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-04-29 02:32:29 | Karnes, Texas, US |
2020-04-28 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-29 02:32:29 | Lee, Texas, US |
2020-04-28 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-29 02:32:29 | Llano, Texas, US |
2020-04-28 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-29 02:32:29 | Martin, Texas, US |
2020-04-28 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-04-29 02:32:29 | Motley, Texas, US |
2020-04-28 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-29 02:32:29 | Newton, Texas, US |
2020-04-28 | US | Texas | Robertson | 48395 | 0 | 0 | 0 | 2 | 31.02539637 | -96.51272246 | 2020-04-29 02:32:29 | Robertson, Texas, US |
2020-04-28 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-04-29 02:32:29 | Sabine, Texas, US |
2020-04-28 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-29 02:32:29 | Stephens, Texas, US |
2020-04-28 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-29 02:32:29 | Uvalde, Texas, US |
2020-04-28 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-04-29 02:32:29 | Zavala, Texas, US |
2020-06-15 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-06-16 04:33:09 | Dimmit, Texas, US |
2020-06-15 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-06-16 04:33:09 | Goliad, Texas, US |
2020-06-15 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 4 | 28.90705334 | -97.85960149 | 2020-06-16 04:33:09 | Karnes, Texas, US |
2020-06-15 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-06-16 04:33:09 | Motley, Texas, US |
2020-06-15 | US | Texas | Shackelford | 48417 | 0 | 0 | 0 | 1 | 32.73587756 | -99.35401337 | 2020-06-16 04:33:09 | Shackelford, Texas, US |
2020-06-15 | US | Texas | Throckmorton | 48447 | 0 | 0 | 0 | 1 | 33.17751417 | -99.21226795 | 2020-06-16 04:33:09 | Throckmorton, Texas, US |
2020-06-15 | US | Texas | Upton | 48461 | 0 | 0 | 0 | 1 | 31.36868194 | -102.0423217 | 2020-06-16 04:33:09 | Upton, Texas, US |
2020-07-01 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-07-02 04:33:46 | Motley, Texas, US |
2020-09-14 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-09-15 03:22:50 | Loving, Texas, US |
2020-07-16 | US | Texas | Foard | 48155 | 0 | 0 | 0 | 1 | 33.97308618 | -99.7767797 | 2020-07-17 04:34:50 | Foard, Texas, US |
2020-08-08 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.43165090000001 | 2020-08-09 04:34:54 | Borden, Texas, US |
2020-08-08 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-09 04:34:54 | Loving, Texas, US |
2020-07-05 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-07-06 04:33:57 | Motley, Texas, US |
2020-07-05 | US | Texas | Sterling | 48431 | 0 | 0 | 0 | 1 | 31.82781912 | -101.0500746 | 2020-07-06 04:33:57 | Sterling, Texas, US |
2020-04-18 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 5 | 30.26640707 | -98.3999852 | 2020-04-18 22:32:47 | Blanco, Texas, US |
2020-04-18 | US | Texas | Callahan | 48059 | 0 | 0 | 0 | 1 | 32.29760619 | -99.37326312 | 2020-04-18 22:32:47 | Callahan, Texas, US |
2020-04-18 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-18 22:32:47 | Clay, Texas, US |
2020-04-18 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 0 | 33.61431553 | -101.3000364 | 2020-04-18 22:32:47 | Crosby, Texas, US |
2020-04-18 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-18 22:32:47 | Dimmit, Texas, US |
2020-04-18 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 1 | 27.68184592 | -98.50864568 | 2020-04-18 22:32:47 | Duval, Texas, US |
2020-04-18 | US | Texas | Falls | 48145 | 0 | 0 | 0 | 1 | 31.25350609 | -96.93630086 | 2020-04-18 22:32:47 | Falls, Texas, US |
2020-04-18 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-18 22:32:47 | Gillespie, Texas, US |
2020-04-18 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 5 | 28.65696592 | -97.42760647 | 2020-04-18 22:32:47 | Goliad, Texas, US |
2020-04-18 | US | Texas | Houston | 48225 | 0 | 0 | 0 | 3 | 31.31925973 | -95.42226208 | 2020-04-18 22:32:47 | Houston, Texas, US |
2020-04-18 | US | Texas | Jones | 48253 | 0 | 0 | 0 | 3 | 32.73997145 | -99.87861576 | 2020-04-18 22:32:47 | Jones, Texas, US |
2020-04-18 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-04-18 22:32:47 | Karnes, Texas, US |
2020-04-18 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-18 22:32:47 | Lee, Texas, US |
2020-04-18 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-18 22:32:47 | Llano, Texas, US |
2020-04-18 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-18 22:32:47 | Martin, Texas, US |
2020-04-18 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-04-18 22:32:47 | Motley, Texas, US |
2020-04-18 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-18 22:32:47 | Newton, Texas, US |
2020-04-18 | US | Texas | Red River | 48387 | 0 | 0 | 0 | 1 | 33.61886692 | -95.04841765 | 2020-04-18 22:32:47 | Red River, Texas, US |
2020-04-18 | US | Texas | Robertson | 48395 | 0 | 0 | 0 | 2 | 31.02539637 | -96.51272246 | 2020-04-18 22:32:47 | Robertson, Texas, US |
2020-04-18 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-04-18 22:32:47 | Sabine, Texas, US |
2020-04-18 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-18 22:32:47 | Stephens, Texas, US |
2020-04-18 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-18 22:32:47 | Uvalde, Texas, US |
2020-04-18 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-04-18 22:32:47 | Zavala, Texas, US |
2020-09-07 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-09-08 04:28:25 | Borden, Texas, US |
2020-09-07 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-09-08 04:28:25 | Loving, Texas, US |
2020-08-07 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.43165090000001 | 2020-08-08 04:34:53 | Borden, Texas, US |
2020-08-07 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-08 04:34:53 | Loving, Texas, US |
2020-04-21 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 5 | 30.26640707 | -98.3999852 | 2020-04-21 23:30:50 | Blanco, Texas, US |
2020-04-21 | US | Texas | Callahan | 48059 | 0 | 0 | 0 | 1 | 32.29760619 | -99.37326312 | 2020-04-21 23:30:50 | Callahan, Texas, US |
2020-04-21 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-21 23:30:50 | Clay, Texas, US |
2020-04-21 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 0 | 33.61431553 | -101.3000364 | 2020-04-21 23:30:50 | Crosby, Texas, US |
2020-04-21 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-21 23:30:50 | Dimmit, Texas, US |
2020-04-21 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 1 | 27.68184592 | -98.50864568 | 2020-04-21 23:30:50 | Duval, Texas, US |
2020-04-21 | US | Texas | Falls | 48145 | 0 | 0 | 0 | 1 | 31.25350609 | -96.93630086 | 2020-04-21 23:30:50 | Falls, Texas, US |
2020-04-21 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-21 23:30:50 | Gillespie, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;