daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where "last_update" is on date 2020-08-24 and province_or_state = "Texas" sorted by latitude
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-08-23 | US | Texas | Cameron | 48061 | 14355 | 653 | 0 | 18572 | 26.14524221 | -97.48140372 | 2020-08-24 04:27:56 | Cameron, Texas, US |
2020-08-23 | US | Texas | Hidalgo | 48215 | 30200 | 1091 | 0 | 23403 | 26.39418217 | -98.18299696 | 2020-08-24 04:27:56 | Hidalgo, Texas, US |
2020-08-23 | US | Texas | Willacy | 48489 | 1004 | 40 | 0 | 770 | 26.47411727 | -97.61535848 | 2020-08-24 04:27:56 | Willacy, Texas, US |
2020-08-23 | US | Texas | Starr | 48427 | 2807 | 117 | 0 | 2452 | 26.56150059 | -98.73892358 | 2020-08-24 04:27:56 | Starr, Texas, US |
2020-08-23 | US | Texas | Kenedy | 48261 | 5 | 1 | 0 | 6 | 26.92601662 | -97.66413984 | 2020-08-24 04:27:56 | Kenedy, Texas, US |
2020-08-23 | US | Texas | Zapata | 48505 | 257 | 3 | 0 | 235 | 27.00156391 | -99.16987152 | 2020-08-24 04:27:56 | Zapata, Texas, US |
2020-08-23 | US | Texas | Brooks | 48047 | 255 | 14 | 0 | 176 | 27.03103197 | -98.21808402 | 2020-08-24 04:27:56 | Brooks, Texas, US |
2020-08-23 | US | Texas | Jim Hogg | 48247 | 81 | 2 | 0 | 71 | 27.04453923 | -98.6968187 | 2020-08-24 04:27:56 | Jim Hogg, Texas, US |
2020-08-23 | US | Texas | Kleberg | 48273 | 777 | 21 | 0 | 530 | 27.42435506 | -97.69894948 | 2020-08-24 04:27:56 | Kleberg, Texas, US |
2020-08-23 | US | Texas | Duval | 48131 | 296 | 8 | 0 | 214 | 27.68184592 | -98.50864568 | 2020-08-24 04:27:56 | Duval, Texas, US |
2020-08-23 | US | Texas | Jim Wells | 48249 | 1225 | 23 | 0 | 907 | 27.73103938 | -98.0904705 | 2020-08-24 04:27:56 | Jim Wells, Texas, US |
2020-08-23 | US | Texas | Nueces | 48355 | 11952 | 313 | 0 | 17756 | 27.736286 | -97.5433285 | 2020-08-24 04:27:56 | Nueces, Texas, US |
2020-08-23 | US | Texas | Webb | 48479 | 8108 | 228 | 0 | 9902 | 27.7610369 | -99.33237355 | 2020-08-24 04:27:56 | Webb, Texas, US |
2020-08-23 | US | Texas | San Patricio | 48409 | 1504 | 52 | 0 | 1150 | 28.00880118 | -97.51763891 | 2020-08-24 04:27:56 | San Patricio, Texas, US |
2020-08-23 | US | Texas | Aransas | 48007 | 242 | 16 | 0 | 181 | 28.10556197 | -96.9995047 | 2020-08-24 04:27:56 | Aransas, Texas, US |
2020-08-23 | US | Texas | Refugio | 48391 | 285 | 9 | 0 | 238 | 28.3238976 | -97.15766311 | 2020-08-24 04:27:56 | Refugio, Texas, US |
2020-08-23 | US | Texas | La Salle | 48283 | 450 | 2 | 0 | 365 | 28.34453111 | -99.09908775 | 2020-08-24 04:27:56 | La Salle, Texas, US |
2020-08-23 | US | Texas | Live Oak | 48297 | 230 | 5 | 0 | 277 | 28.35101362 | -98.1246786 | 2020-08-24 04:27:56 | Live Oak, Texas, US |
2020-08-23 | US | Texas | McMullen | 48311 | 16 | 0 | 0 | 11 | 28.35251708 | -98.56769164 | 2020-08-24 04:27:56 | McMullen, Texas, US |
2020-08-23 | US | Texas | Bee | 48025 | 2087 | 18 | 0 | 1451 | 28.41761668 | -97.74215593 | 2020-08-24 04:27:56 | Bee, Texas, US |
2020-08-23 | US | Texas | Dimmit | 48127 | 173 | 5 | 0 | 166 | 28.42270064 | -99.75645095 | 2020-08-24 04:27:56 | Dimmit, Texas, US |
2020-08-23 | US | Texas | Calhoun | 48057 | 750 | 7 | 0 | 572 | 28.47048236 | -96.61633945 | 2020-08-24 04:27:56 | Calhoun, Texas, US |
2020-08-23 | US | Texas | Goliad | 48175 | 169 | 6 | 0 | 115 | 28.65696592 | -97.42760647 | 2020-08-24 04:27:56 | Goliad, Texas, US |
2020-08-23 | US | Texas | Maverick | 48323 | 2437 | 67 | 0 | 3050 | 28.7429195 | -100.3157686 | 2020-08-24 04:27:56 | Maverick, Texas, US |
2020-08-23 | US | Texas | Victoria | 48469 | 3786 | 69 | 0 | 3643 | 28.79780988 | -96.96813006 | 2020-08-24 04:27:56 | Victoria, Texas, US |
2020-08-23 | US | Texas | Matagorda | 48321 | 887 | 38 | 0 | 837 | 28.81955746 | -96.01230294 | 2020-08-24 04:27:56 | Matagorda, Texas, US |
2020-08-23 | US | Texas | Zavala | 48507 | 278 | 8 | 0 | 245 | 28.86617238 | -99.76050829 | 2020-08-24 04:27:56 | Zavala, Texas, US |
2020-08-23 | US | Texas | Frio | 48163 | 740 | 7 | 0 | 606 | 28.86751206 | -99.10804207 | 2020-08-24 04:27:56 | Frio, Texas, US |
2020-08-23 | US | Texas | Atascosa | 48013 | 1040 | 23 | 0 | 521 | 28.89333001 | -98.52730485 | 2020-08-24 04:27:56 | Atascosa, Texas, US |
2020-08-23 | US | Texas | Karnes | 48255 | 808 | 10 | 0 | 710 | 28.90705334 | -97.85960149 | 2020-08-24 04:27:56 | Karnes, Texas, US |
2020-08-23 | US | Texas | Jackson | 48239 | 522 | 13 | 0 | 464 | 28.95472367 | -96.57749563 | 2020-08-24 04:27:56 | Jackson, Texas, US |
2020-08-23 | US | Texas | DeWitt | 48123 | 636 | 24 | 0 | 758 | 29.08101855 | -97.3568117 | 2020-08-24 04:27:56 | DeWitt, Texas, US |
2020-08-23 | US | Texas | Wilson | 48493 | 834 | 24 | 0 | 500 | 29.1732598 | -98.08693082 | 2020-08-24 04:27:56 | Wilson, Texas, US |
2020-08-23 | US | Texas | Brazoria | 48039 | 9681 | 124 | 0 | 8538 | 29.18757369 | -95.44563172 | 2020-08-24 04:27:56 | Brazoria, Texas, US |
2020-08-23 | US | Texas | Wharton | 48481 | 1172 | 39 | 0 | 1073 | 29.27765923 | -96.22319248 | 2020-08-24 04:27:56 | Wharton, Texas, US |
2020-08-23 | US | Texas | Kinney | 48271 | 29 | 1 | 0 | 21 | 29.34967888 | -100.4186638 | 2020-08-24 04:27:56 | Kinney, Texas, US |
2020-08-23 | US | Texas | Medina | 48325 | 1160 | 34 | 0 | 1035 | 29.3557301 | -99.11030298 | 2020-08-24 04:27:56 | Medina, Texas, US |
2020-08-23 | US | Texas | Uvalde | 48463 | 667 | 16 | 0 | 638 | 29.35739637 | -99.76229172 | 2020-08-24 04:27:56 | Uvalde, Texas, US |
2020-08-23 | US | Texas | Lavaca | 48285 | 754 | 28 | 0 | 633 | 29.38508402 | -96.93186692 | 2020-08-24 04:27:56 | Lavaca, Texas, US |
2020-08-23 | US | Texas | Galveston | 48167 | 9320 | 132 | 0 | 10218 | 29.40167322 | -94.90469073 | 2020-08-24 04:27:56 | Galveston, Texas, US |
2020-08-23 | US | Texas | Bexar | 48029 | 53439 | 998 | 0 | 44257 | 29.44928723 | -98.52019748 | 2020-08-24 04:27:56 | Bexar, Texas, US |
2020-08-23 | US | Texas | Gonzales | 48177 | 914 | 12 | 0 | 771 | 29.45634206 | -97.49424032 | 2020-08-24 04:27:56 | Gonzales, Texas, US |
2020-08-23 | US | Texas | Fort Bend | 48157 | 16452 | 216 | 0 | 13818 | 29.52704478 | -95.77219463 | 2020-08-24 04:27:56 | Fort Bend, Texas, US |
2020-08-23 | US | Texas | Guadalupe | 48187 | 3277 | 66 | 0 | 1792 | 29.58165339 | -97.94786822 | 2020-08-24 04:27:56 | Guadalupe, Texas, US |
2020-08-23 | US | Texas | Colorado | 48089 | 427 | 3 | 0 | 413 | 29.622098 | -96.5273805 | 2020-08-24 04:27:56 | Colorado, Texas, US |
2020-08-23 | US | Texas | Chambers | 48071 | 599 | 5 | 0 | 1075 | 29.70972016 | -94.67154501 | 2020-08-24 04:27:56 | Chambers, Texas, US |
2020-08-23 | US | Texas | Bandera | 48019 | 141 | 3 | 0 | 103 | 29.74619598 | -99.24598147 | 2020-08-24 04:27:56 | Bandera, Texas, US |
2020-08-23 | US | Texas | Comal | 48091 | 2378 | 93 | 0 | 2182 | 29.80811278 | -98.27647225 | 2020-08-24 04:27:56 | Comal, Texas, US |
2020-08-23 | US | Texas | Brewster | 48043 | 191 | 2 | 0 | 187 | 29.81008251 | -103.2520326 | 2020-08-24 04:27:56 | Brewster, Texas, US |
2020-08-23 | US | Texas | Real | 48385 | 85 | 5 | 0 | 94 | 29.83321503 | -99.82018052 | 2020-08-24 04:27:56 | Real, Texas, US |
2020-08-23 | US | Texas | Caldwell | 48055 | 1236 | 31 | 0 | 1179 | 29.83668859 | -97.61814775 | 2020-08-24 04:27:56 | Caldwell, Texas, US |
2020-08-23 | US | Texas | Harris | 48201 | 136543 | 2028 | 0 | 96478 | 29.85864939 | -95.39339521 | 2020-08-24 04:27:56 | Harris, Texas, US |
2020-08-23 | US | Texas | Fayette | 48149 | 430 | 15 | 0 | 427 | 29.87788372 | -96.92076062 | 2020-08-24 04:27:56 | Fayette, Texas, US |
2020-08-23 | US | Texas | Jefferson | 48245 | 5425 | 103 | 0 | 6396 | 29.8832777 | -94.16434171 | 2020-08-24 04:27:56 | Jefferson, Texas, US |
2020-08-23 | US | Texas | Austin | 48015 | 428 | 5 | 0 | 386 | 29.88548725 | -96.27736949 | 2020-08-24 04:27:56 | Austin, Texas, US |
2020-08-23 | US | Texas | Val Verde | 48465 | 974 | 83 | 0 | 1786 | 29.89149232 | -101.1525205 | 2020-08-24 04:27:56 | Val Verde, Texas, US |
2020-08-23 | US | Texas | Kendall | 48259 | 390 | 4 | 0 | 189 | 29.94414155 | -98.7113588 | 2020-08-24 04:27:56 | Kendall, Texas, US |
2020-08-23 | US | Texas | Edwards | 48137 | 62 | 0 | 0 | 34 | 29.98202582 | -100.304252 | 2020-08-24 04:27:56 | Edwards, Texas, US |
2020-08-23 | US | Texas | Presidio | 48377 | 67 | 4 | 0 | 45 | 29.99954402 | -104.2408079 | 2020-08-24 04:27:56 | Presidio, Texas, US |
2020-08-23 | US | Texas | Waller | 48473 | 673 | 5 | 0 | 620 | 30.01058447 | -95.99011759 | 2020-08-24 04:27:56 | Waller, Texas, US |
2020-08-23 | US | Texas | Hays | 48209 | 4813 | 52 | 0 | 5198 | 30.05669873 | -98.02944344 | 2020-08-24 04:27:56 | Hays, Texas, US |
2020-08-23 | US | Texas | Kerr | 48265 | 508 | 9 | 0 | 417 | 30.06040006 | -99.34930144 | 2020-08-24 04:27:56 | Kerr, Texas, US |
2020-08-23 | US | Texas | Bastrop | 48021 | 1645 | 25 | 0 | 1506 | 30.10370699 | -97.31206354 | 2020-08-24 04:27:56 | Bastrop, Texas, US |
2020-08-23 | US | Texas | Orange | 48361 | 618 | 33 | 0 | 1703 | 30.11879481 | -93.89412775 | 2020-08-24 04:27:56 | Orange, Texas, US |
2020-08-23 | US | Texas | Liberty | 48291 | 1653 | 39 | 0 | 1300 | 30.15152688 | -94.81205615 | 2020-08-24 04:27:56 | Liberty, Texas, US |
2020-08-23 | US | Texas | Washington | 48477 | 381 | 43 | 0 | 516 | 30.21498498 | -96.40946246 | 2020-08-24 04:27:56 | Washington, Texas, US |
2020-08-23 | US | Texas | Terrell | 48443 | 5 | 0 | 0 | 3 | 30.22429013 | -102.0766732 | 2020-08-24 04:27:56 | Terrell, Texas, US |
2020-08-23 | US | Texas | Blanco | 48031 | 95 | 5 | 0 | 122 | 30.26640707 | -98.3999852 | 2020-08-24 04:27:56 | Blanco, Texas, US |
2020-08-23 | US | Texas | Montgomery | 48339 | 7975 | 113 | 0 | 7802 | 30.30079133 | -95.50572772 | 2020-08-24 04:27:56 | Montgomery, Texas, US |
2020-08-23 | US | Texas | Lee | 48287 | 267 | 13 | 0 | 175 | 30.31120597 | -96.97045773 | 2020-08-24 04:27:56 | Lee, Texas, US |
2020-08-23 | US | Texas | Gillespie | 48171 | 250 | 6 | 0 | 187 | 30.31824095 | -98.94676915 | 2020-08-24 04:27:56 | Gillespie, Texas, US |
2020-08-23 | US | Texas | Hardin | 48199 | 474 | 18 | 0 | 1199 | 30.33364686 | -94.38931817 | 2020-08-24 04:27:56 | Hardin, Texas, US |
2020-08-23 | US | Texas | Travis | 48453 | 24868 | 357 | 0 | 25379 | 30.33432034 | -97.7853562 | 2020-08-24 04:27:56 | Travis, Texas, US |
2020-08-23 | US | Texas | Kimble | 48267 | 47 | 1 | 0 | 15 | 30.48678918 | -99.74856473 | 2020-08-24 04:27:56 | Kimble, Texas, US |
2020-08-23 | US | Texas | Burleson | 48051 | 249 | 6 | 0 | 269 | 30.49273808 | -96.62158484 | 2020-08-24 04:27:56 | Burleson, Texas, US |
2020-08-23 | US | Texas | Sutton | 48435 | 82 | 2 | 0 | 74 | 30.49856623 | -100.5382014 | 2020-08-24 04:27:56 | Sutton, Texas, US |
2020-08-23 | US | Texas | Grimes | 48185 | 914 | 29 | 0 | 950 | 30.54579585 | -95.98902499 | 2020-08-24 04:27:56 | Grimes, Texas, US |
2020-08-23 | US | Texas | San Jacinto | 48407 | 315 | 8 | 0 | 185 | 30.57933681 | -95.16260304 | 2020-08-24 04:27:56 | San Jacinto, Texas, US |
2020-08-23 | US | Texas | Williamson | 48491 | 7230 | 113 | 0 | 7574 | 30.64655664 | -97.6004854 | 2020-08-24 04:27:56 | Williamson, Texas, US |
2020-08-23 | US | Texas | Brazos | 48041 | 4618 | 53 | 0 | 4299 | 30.663644800000004 | -96.30205577 | 2020-08-24 04:27:56 | Brazos, Texas, US |
2020-08-23 | US | Texas | Llano | 48299 | 83 | 1 | 0 | 98 | 30.70645047 | -98.68475262 | 2020-08-24 04:27:56 | Llano, Texas, US |
2020-08-23 | US | Texas | Jeff Davis | 48243 | 14 | 0 | 0 | 8 | 30.71490589 | -104.1399973 | 2020-08-24 04:27:56 | Jeff Davis, Texas, US |
2020-08-23 | US | Texas | Mason | 48319 | 76 | 0 | 0 | 64 | 30.71780434 | -99.22629416 | 2020-08-24 04:27:56 | Mason, Texas, US |
2020-08-23 | US | Texas | Crockett | 48105 | 164 | 4 | 0 | 156 | 30.72367027 | -101.4134238 | 2020-08-24 04:27:56 | Crockett, Texas, US |
2020-08-23 | US | Texas | Walker | 48471 | 3810 | 46 | 0 | 3274 | 30.73872995 | -95.57440968 | 2020-08-24 04:27:56 | Walker, Texas, US |
2020-08-23 | US | Texas | Jasper | 48241 | 626 | 17 | 0 | 376 | 30.74685667 | -94.02667579 | 2020-08-24 04:27:56 | Jasper, Texas, US |
2020-08-23 | US | Texas | Tyler | 48457 | 129 | 3 | 0 | 172 | 30.77031716 | -94.37690895 | 2020-08-24 04:27:56 | Tyler, Texas, US |
2020-08-23 | US | Texas | Pecos | 48371 | 291 | 2 | 0 | 270 | 30.78097267 | -102.7241261 | 2020-08-24 04:27:56 | Pecos, Texas, US |
2020-08-23 | US | Texas | Newton | 48351 | 103 | 6 | 0 | 156 | 30.78548982 | -93.74408813 | 2020-08-24 04:27:56 | Newton, Texas, US |
2020-08-23 | US | Texas | Milam | 48331 | 190 | 4 | 0 | 396 | 30.785818300000006 | -96.97718698 | 2020-08-24 04:27:56 | Milam, Texas, US |
2020-08-23 | US | Texas | Burnet | 48053 | 751 | 12 | 0 | 592 | 30.78801353 | -98.181887 | 2020-08-24 04:27:56 | Burnet, Texas, US |
2020-08-23 | US | Texas | Polk | 48373 | 1369 | 15 | 0 | 758 | 30.79472531 | -94.8276624 | 2020-08-24 04:27:56 | Polk, Texas, US |
2020-08-23 | US | Texas | Menard | 48327 | 24 | 0 | 0 | 20 | 30.88990665 | -99.8204794 | 2020-08-24 04:27:56 | Menard, Texas, US |
2020-08-23 | US | Texas | Schleicher | 48413 | 47 | 1 | 0 | 35 | 30.89740592 | -100.5384842 | 2020-08-24 04:27:56 | Schleicher, Texas, US |
2020-08-23 | US | Texas | Madison | 48313 | 700 | 3 | 0 | 686 | 30.96694679 | -95.93003775 | 2020-08-24 04:27:56 | Madison, Texas, US |
2020-08-23 | US | Texas | Robertson | 48395 | 220 | 3 | 0 | 241 | 31.02539637 | -96.51272246 | 2020-08-24 04:27:56 | Robertson, Texas, US |
2020-08-23 | US | Texas | Bell | 48027 | 1454 | 55 | 0 | 4479 | 31.03736027 | -97.4785025 | 2020-08-24 04:27:56 | Bell, Texas, US |
2020-08-23 | US | Texas | Trinity | 48455 | 206 | 4 | 0 | 165 | 31.0879489 | -95.1367187 | 2020-08-24 04:27:56 | Trinity, Texas, US |
2020-08-23 | US | Texas | San Saba | 48411 | 29 | 0 | 0 | 33 | 31.1577796 | -98.81758731 | 2020-08-24 04:27:56 | San Saba, Texas, US |
2020-08-23 | US | Texas | McCulloch | 48307 | 73 | 1 | 0 | 73 | 31.1925468 | -99.34682807 | 2020-08-24 04:27:56 | McCulloch, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;