johns_hopkins_csse_daily_reports
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)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40449 | 40449 | 2020-04-13 | US | Texas | Bandera | 48019 | 0 | 0 | 0 | 2 | 29.74619598 | -99.24598147 | 2020-04-13 23:07:54 | Bandera, Texas, US |
40526 | 40526 | 2020-04-13 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 4 | 30.26640707 | -98.3999852 | 2020-04-13 23:07:54 | Blanco, Texas, US |
40646 | 40646 | 2020-04-13 | US | Texas | Callahan | 48059 | 0 | 0 | 0 | 1 | 32.29760619 | -99.37326312 | 2020-04-13 23:07:54 | Callahan, Texas, US |
40819 | 40819 | 2020-04-13 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 2 | 33.78686685 | -98.20771198 | 2020-04-13 23:07:54 | Clay, Texas, US |
40885 | 40885 | 2020-04-13 | US | Texas | Cooke | 48097 | 0 | 0 | 0 | 1 | 33.63979567 | -97.21240912 | 2020-04-13 23:07:54 | Cooke, Texas, US |
40928 | 40928 | 2020-04-13 | US | Texas | Crosby | 48107 | 0 | 0 | 0 | 1 | 33.61431553 | -101.30003640000001 | 2020-04-13 23:07:54 | Crosby, Texas, US |
40955 | 40955 | 2020-04-13 | US | Texas | Dallam | 48111 | 0 | 0 | 0 | 1 | 36.27787176 | -102.60207249999999 | 2020-04-13 23:07:54 | Dallam, Texas, US |
41018 | 41018 | 2020-04-13 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-13 23:07:54 | Dimmit, Texas, US |
41114 | 41114 | 2020-04-13 | US | Texas | Falls | 48145 | 0 | 0 | 0 | 1 | 31.25350609 | -96.93630086 | 2020-04-13 23:07:54 | Falls, Texas, US |
41232 | 41232 | 2020-04-13 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-13 23:07:54 | Gillespie, Texas, US |
41244 | 41244 | 2020-04-13 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 4 | 28.65696592 | -97.42760647 | 2020-04-13 23:07:54 | Goliad, Texas, US |
41354 | 41354 | 2020-04-13 | US | Texas | Hansford | 48195 | 0 | 0 | 0 | 1 | 36.27743284 | -101.3545796 | 2020-04-13 23:07:54 | Hansford, Texas, US |
41521 | 41521 | 2020-04-13 | US | Texas | Jasper | 48241 | 0 | 0 | 0 | 7 | 30.74685667 | -94.02667579 | 2020-04-13 23:07:54 | Jasper, Texas, US |
41576 | 41576 | 2020-04-13 | US | Texas | Jones | 48253 | 0 | 0 | 0 | 2 | 32.73997145 | -99.87861576 | 2020-04-13 23:07:54 | Jones, Texas, US |
41589 | 41589 | 2020-04-13 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 2 | 28.90705334 | -97.85960149 | 2020-04-13 23:07:54 | Karnes, Texas, US |
41719 | 41719 | 2020-04-13 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-13 23:07:54 | Lee, Texas, US |
41779 | 41779 | 2020-04-13 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-13 23:07:54 | Llano, Texas, US |
41844 | 41844 | 2020-04-13 | US | Texas | Madison | 48313 | 0 | 0 | 0 | 1 | 30.96694679 | -95.93003775 | 2020-04-13 23:07:54 | Madison, Texas, US |
41895 | 41895 | 2020-04-13 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-13 23:07:54 | Martin, Texas, US |
42065 | 42065 | 2020-04-13 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-04-13 23:07:54 | Motley, Texas, US |
42111 | 42111 | 2020-04-13 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-13 23:07:54 | Newton, Texas, US |
42374 | 42374 | 2020-04-13 | US | Texas | Rains | 48379 | 0 | 0 | 0 | 1 | 32.87109387 | -95.79232691 | 2020-04-13 23:07:54 | Rains, Texas, US |
42428 | 42428 | 2020-04-13 | US | Texas | Robertson | 48395 | 0 | 0 | 0 | 2 | 31.02539637 | -96.51272246 | 2020-04-13 23:07:54 | Robertson, Texas, US |
42640 | 42640 | 2020-04-13 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-13 23:07:54 | Stephens, Texas, US |
42838 | 42838 | 2020-04-13 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-13 23:07:54 | Uvalde, Texas, US |
47586 | 47586 | 2020-04-17 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 5 | 30.26640707 | -98.3999852 | 2020-04-17 23:30:52 | Blanco, Texas, US |
47706 | 47706 | 2020-04-17 | US | Texas | Callahan | 48059 | 0 | 0 | 0 | 1 | 32.29760619 | -99.37326312 | 2020-04-17 23:30:52 | Callahan, Texas, US |
47882 | 47882 | 2020-04-17 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-17 23:30:52 | Clay, Texas, US |
47991 | 47991 | 2020-04-17 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 0 | 33.61431553 | -101.30003640000001 | 2020-04-17 23:30:52 | Crosby, Texas, US |
48018 | 48018 | 2020-04-17 | US | Texas | Dallam | 48111 | 0 | 0 | 0 | 3 | 36.27787176 | -102.60207249999999 | 2020-04-17 23:30:52 | Dallam, Texas, US |
48083 | 48083 | 2020-04-17 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-17 23:30:52 | Dimmit, Texas, US |
48122 | 48122 | 2020-04-17 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 1 | 27.68184592 | -98.50864568 | 2020-04-17 23:30:52 | Duval, Texas, US |
48178 | 48178 | 2020-04-17 | US | Texas | Falls | 48145 | 0 | 0 | 0 | 1 | 31.25350609 | -96.93630086 | 2020-04-17 23:30:52 | Falls, Texas, US |
48297 | 48297 | 2020-04-17 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-17 23:30:52 | Gillespie, Texas, US |
48309 | 48309 | 2020-04-17 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 5 | 28.65696592 | -97.42760647 | 2020-04-17 23:30:52 | Goliad, Texas, US |
48646 | 48646 | 2020-04-17 | US | Texas | Jones | 48253 | 0 | 0 | 0 | 3 | 32.73997145 | -99.87861576 | 2020-04-17 23:30:52 | Jones, Texas, US |
48658 | 48658 | 2020-04-17 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-04-17 23:30:52 | Karnes, Texas, US |
48790 | 48790 | 2020-04-17 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-17 23:30:52 | Lee, Texas, US |
48852 | 48852 | 2020-04-17 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-17 23:30:52 | Llano, Texas, US |
48969 | 48969 | 2020-04-17 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-17 23:30:52 | Martin, Texas, US |
49144 | 49144 | 2020-04-17 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-04-17 23:30:52 | Motley, Texas, US |
49191 | 49191 | 2020-04-17 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-17 23:30:52 | Newton, Texas, US |
49480 | 49480 | 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 |
49515 | 49515 | 2020-04-17 | US | Texas | Robertson | 48395 | 0 | 0 | 0 | 2 | 31.02539637 | -96.51272246 | 2020-04-17 23:30:52 | Robertson, Texas, US |
49549 | 49549 | 2020-04-17 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-04-17 23:30:52 | Sabine, Texas, US |
49732 | 49732 | 2020-04-17 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-17 23:30:52 | Stephens, Texas, US |
49933 | 49933 | 2020-04-17 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-17 23:30:52 | Uvalde, Texas, US |
50170 | 50170 | 2020-04-17 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-04-17 23:30:52 | Zavala, Texas, US |
111259 | 111259 | 2020-05-08 | US | Texas | Bailey | 48017 | 0 | 0 | 0 | 2 | 34.06854817 | -102.8299707 | 2020-05-09 02:32:35 | Bailey, Texas, US |
111350 | 111350 | 2020-05-08 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 6 | 30.26640707 | -98.3999852 | 2020-05-09 02:32:35 | Blanco, Texas, US |
111406 | 111406 | 2020-05-08 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-05-09 02:32:35 | Brooks, Texas, US |
111668 | 111668 | 2020-05-08 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-05-09 02:32:35 | Clay, Texas, US |
111706 | 111706 | 2020-05-08 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 2 | 31.76736834 | -99.45240766 | 2020-05-09 02:32:35 | Coleman, Texas, US |
111784 | 111784 | 2020-05-08 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 1 | 33.61431553 | -101.3000364 | 2020-05-09 02:32:35 | Crosby, Texas, US |
111882 | 111882 | 2020-05-08 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-05-09 02:32:35 | Dimmit, Texas, US |
112129 | 112129 | 2020-05-08 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-05-09 02:32:35 | Goliad, Texas, US |
112506 | 112506 | 2020-05-08 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-05-09 02:32:35 | Karnes, Texas, US |
112645 | 112645 | 2020-05-08 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 4 | 30.31120597 | -96.97045773 | 2020-05-09 02:32:35 | Lee, Texas, US |
112711 | 112711 | 2020-05-08 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-05-09 02:32:35 | Llano, Texas, US |
113016 | 113016 | 2020-05-08 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-05-09 02:32:35 | Motley, Texas, US |
113066 | 113066 | 2020-05-08 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 4 | 30.78548982 | -93.74408813 | 2020-05-09 02:32:35 | Newton, Texas, US |
113448 | 113448 | 2020-05-08 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 2 | 31.34318809 | -93.85440451 | 2020-05-09 02:32:35 | Sabine, Texas, US |
113535 | 113535 | 2020-05-08 | US | Texas | Shackelford | 48417 | 0 | 0 | 0 | 1 | 32.73587756 | -99.35401337 | 2020-05-09 02:32:35 | Shackelford, Texas, US |
113641 | 113641 | 2020-05-08 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-05-09 02:32:35 | Stephens, Texas, US |
113857 | 113857 | 2020-05-08 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 7 | 29.35739637 | -99.76229172 | 2020-05-09 02:32:35 | Uvalde, Texas, US |
114108 | 114108 | 2020-05-08 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-05-09 02:32:35 | Zavala, Texas, US |
134630 | 134630 | 2020-04-29 | US | Texas | Blanco | 48031 | 0 | 0 | 0 | 6 | 30.26640707 | -98.3999852 | 2020-04-30 02:32:27 | Blanco, Texas, US |
134683 | 134683 | 2020-04-29 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-04-30 02:32:27 | Brooks, Texas, US |
134941 | 134941 | 2020-04-29 | US | Texas | Clay | 48077 | 0 | 0 | 0 | 3 | 33.78686685 | -98.20771198 | 2020-04-30 02:32:27 | Clay, Texas, US |
134977 | 134977 | 2020-04-29 | US | Texas | Coleman | 48083 | 0 | 0 | 0 | 1 | 31.76736834 | -99.45240766 | 2020-04-30 02:32:27 | Coleman, Texas, US |
135020 | 135020 | 2020-04-29 | US | Texas | Cottle | 48101 | 0 | 0 | 0 | 2 | 34.07783319 | -100.27850620000001 | 2020-04-30 02:32:27 | Cottle, Texas, US |
135053 | 135053 | 2020-04-29 | US | Texas | Crosby | 48107 | 0 | 1 | 0 | 1 | 33.61431553 | -101.30003640000001 | 2020-04-30 02:32:27 | Crosby, Texas, US |
135148 | 135148 | 2020-04-29 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-04-30 02:32:27 | Dimmit, Texas, US |
135189 | 135189 | 2020-04-29 | US | Texas | Duval | 48131 | 0 | 0 | 0 | 2 | 27.68184592 | -98.50864568 | 2020-04-30 02:32:27 | Duval, Texas, US |
135373 | 135373 | 2020-04-29 | US | Texas | Gillespie | 48171 | 0 | 0 | 0 | 1 | 30.31824095 | -98.94676915 | 2020-04-30 02:32:27 | Gillespie, Texas, US |
135386 | 135386 | 2020-04-29 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-04-30 02:32:27 | Goliad, Texas, US |
135755 | 135755 | 2020-04-29 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 3 | 28.90705334 | -97.85960149 | 2020-04-30 02:32:27 | Karnes, Texas, US |
135890 | 135890 | 2020-04-29 | US | Texas | Lee | 48287 | 0 | 0 | 0 | 2 | 30.31120597 | -96.97045773 | 2020-04-30 02:32:27 | Lee, Texas, US |
135955 | 135955 | 2020-04-29 | US | Texas | Llano | 48299 | 0 | 0 | 0 | 3 | 30.70645047 | -98.68475262 | 2020-04-30 02:32:27 | Llano, Texas, US |
136076 | 136076 | 2020-04-29 | US | Texas | Martin | 48317 | 0 | 0 | 0 | 2 | 32.30600051 | -101.9513518 | 2020-04-30 02:32:27 | Martin, Texas, US |
136258 | 136258 | 2020-04-29 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.77972199999999 | 2020-04-30 02:32:27 | Motley, Texas, US |
136308 | 136308 | 2020-04-29 | US | Texas | Newton | 48351 | 0 | 0 | 0 | 2 | 30.78548982 | -93.74408813 | 2020-04-30 02:32:27 | Newton, Texas, US |
136682 | 136682 | 2020-04-29 | US | Texas | Sabine | 48403 | 0 | 0 | 0 | 1 | 31.34318809 | -93.85440451 | 2020-04-30 02:32:27 | Sabine, Texas, US |
136874 | 136874 | 2020-04-29 | US | Texas | Stephens | 48429 | 0 | 0 | 0 | 1 | 32.73553157 | -98.83631615 | 2020-04-30 02:32:27 | Stephens, Texas, US |
137085 | 137085 | 2020-04-29 | US | Texas | Uvalde | 48463 | 0 | 0 | 0 | 6 | 29.35739637 | -99.76229172 | 2020-04-30 02:32:27 | Uvalde, Texas, US |
137333 | 137333 | 2020-04-29 | US | Texas | Zavala | 48507 | 0 | 0 | 0 | 1 | 28.86617238 | -99.76050829 | 2020-04-30 02:32:27 | Zavala, Texas, US |
148971 | 148971 | 2020-08-15 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-08-16 04:27:42 | Borden, Texas, US |
149105 | 149105 | 2020-08-15 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-16 04:27:42 | Loving, Texas, US |
197075 | 197075 | 2020-08-31 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-09-01 04:28:31 | Borden, Texas, US |
197209 | 197209 | 2020-08-31 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-09-01 04:28:31 | Loving, Texas, US |
209257 | 209257 | 2020-08-19 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-08-20 04:27:43 | Borden, Texas, US |
209391 | 209391 | 2020-08-19 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-20 04:27:43 | Loving, Texas, US |
214201 | 214201 | 2020-06-08 | US | Texas | Brooks | 48047 | 0 | 0 | 0 | 1 | 27.03103197 | -98.21808402 | 2020-06-09 03:33:03 | Brooks, Texas, US |
214685 | 214685 | 2020-06-08 | US | Texas | Dimmit | 48127 | 0 | 0 | 0 | 1 | 28.42270064 | -99.75645095 | 2020-06-09 03:33:03 | Dimmit, Texas, US |
214941 | 214941 | 2020-06-08 | US | Texas | Goliad | 48175 | 0 | 0 | 0 | 7 | 28.65696592 | -97.42760647 | 2020-06-09 03:33:03 | Goliad, Texas, US |
215333 | 215333 | 2020-06-08 | US | Texas | Karnes | 48255 | 0 | 0 | 0 | 4 | 28.90705334 | -97.85960149 | 2020-06-09 03:33:03 | Karnes, Texas, US |
215856 | 215856 | 2020-06-08 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-06-09 03:33:03 | Motley, Texas, US |
216388 | 216388 | 2020-06-08 | US | Texas | Shackelford | 48417 | 0 | 0 | 0 | 1 | 32.73587756 | -99.35401337 | 2020-06-09 03:33:03 | Shackelford, Texas, US |
216588 | 216588 | 2020-06-08 | US | Texas | Throckmorton | 48447 | 0 | 0 | 0 | 1 | 33.17751417 | -99.21226795 | 2020-06-09 03:33:03 | Throckmorton, Texas, US |
225876 | 225876 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);