johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where "last_update" is on date 2020-09-04 and province_or_state = "Texas" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1357338 | 1357338 | 2020-09-03 | US | Texas | Cameron | 48061 | 15478 | 793 | 0 | 20549 | 26.14524221 | -97.48140372 | 2020-09-04 04:28:26 | Cameron, Texas, US |
1357415 | 1357415 | 2020-09-03 | US | Texas | Hidalgo | 48215 | 33610 | 1233 | 0 | 26945 | 26.39418217 | -98.18299696 | 2020-09-04 04:28:26 | Hidalgo, Texas, US |
1357553 | 1357553 | 2020-09-03 | US | Texas | Willacy | 48489 | 1078 | 43 | 0 | 848 | 26.47411727 | -97.61535848 | 2020-09-04 04:28:26 | Willacy, Texas, US |
1357521 | 1357521 | 2020-09-03 | US | Texas | Starr | 48427 | 3092 | 140 | 0 | 2642 | 26.56150059 | -98.73892358 | 2020-09-04 04:28:26 | Starr, Texas, US |
1357438 | 1357438 | 2020-09-03 | US | Texas | Kenedy | 48261 | 6 | 1 | 0 | 6 | 26.92601662 | -97.66413984 | 2020-09-04 04:28:26 | Kenedy, Texas, US |
1357561 | 1357561 | 2020-09-03 | US | Texas | Zapata | 48505 | 289 | 4 | 0 | 277 | 27.00156391 | -99.16987152 | 2020-09-04 04:28:26 | Zapata, Texas, US |
1357331 | 1357331 | 2020-09-03 | US | Texas | Brooks | 48047 | 295 | 16 | 0 | 235 | 27.03103197 | -98.21808402 | 2020-09-04 04:28:26 | Brooks, Texas, US |
1357431 | 1357431 | 2020-09-03 | US | Texas | Jim Hogg | 48247 | 95 | 2 | 0 | 77 | 27.04453923 | -98.6968187 | 2020-09-04 04:28:26 | Jim Hogg, Texas, US |
1357444 | 1357444 | 2020-09-03 | US | Texas | Kleberg | 48273 | 875 | 29 | 0 | 644 | 27.42435506 | -97.69894948 | 2020-09-04 04:28:26 | Kleberg, Texas, US |
1357373 | 1357373 | 2020-09-03 | US | Texas | Duval | 48131 | 335 | 10 | 0 | 341 | 27.68184592 | -98.50864568 | 2020-09-04 04:28:26 | Duval, Texas, US |
1357432 | 1357432 | 2020-09-03 | US | Texas | Jim Wells | 48249 | 1365 | 24 | 0 | 1064 | 27.73103938 | -98.0904705 | 2020-09-04 04:28:26 | Jim Wells, Texas, US |
1357485 | 1357485 | 2020-09-03 | US | Texas | Nueces | 48355 | 12525 | 368 | 0 | 18682 | 27.736286 | -97.5433285 | 2020-09-04 04:28:26 | Nueces, Texas, US |
1357548 | 1357548 | 2020-09-03 | US | Texas | Webb | 48479 | 9721 | 251 | 0 | 11391 | 27.7610369 | -99.33237355 | 2020-09-04 04:28:26 | Webb, Texas, US |
1357512 | 1357512 | 2020-09-03 | US | Texas | San Patricio | 48409 | 1562 | 60 | 0 | 1266 | 28.00880118 | -97.51763891 | 2020-09-04 04:28:26 | San Patricio, Texas, US |
1357311 | 1357311 | 2020-09-03 | US | Texas | Aransas | 48007 | 267 | 18 | 0 | 197 | 28.10556197 | -96.9995047 | 2020-09-04 04:28:26 | Aransas, Texas, US |
1357503 | 1357503 | 2020-09-03 | US | Texas | Refugio | 48391 | 300 | 10 | 0 | 263 | 28.3238976 | -97.15766311 | 2020-09-04 04:28:26 | Refugio, Texas, US |
1357446 | 1357446 | 2020-09-03 | US | Texas | La Salle | 48283 | 452 | 4 | 0 | 361 | 28.34453111 | -99.09908775 | 2020-09-04 04:28:26 | La Salle, Texas, US |
1357456 | 1357456 | 2020-09-03 | US | Texas | Live Oak | 48297 | 300 | 7 | 0 | 346 | 28.35101362 | -98.1246786 | 2020-09-04 04:28:26 | Live Oak, Texas, US |
1357469 | 1357469 | 2020-09-03 | US | Texas | McMullen | 48311 | 23 | 0 | 0 | 16 | 28.35251708 | -98.56769164 | 2020-09-04 04:28:26 | McMullen, Texas, US |
1357320 | 1357320 | 2020-09-03 | US | Texas | Bee | 48025 | 2214 | 24 | 0 | 1619 | 28.41761668 | -97.74215593 | 2020-09-04 04:28:26 | Bee, Texas, US |
1357371 | 1357371 | 2020-09-03 | US | Texas | Dimmit | 48127 | 193 | 6 | 0 | 180 | 28.42270064 | -99.75645095 | 2020-09-04 04:28:26 | Dimmit, Texas, US |
1357336 | 1357336 | 2020-09-03 | US | Texas | Calhoun | 48057 | 796 | 7 | 0 | 607 | 28.47048236 | -96.61633945 | 2020-09-04 04:28:26 | Calhoun, Texas, US |
1357395 | 1357395 | 2020-09-03 | US | Texas | Goliad | 48175 | 176 | 6 | 0 | 115 | 28.65696592 | -97.42760647 | 2020-09-04 04:28:26 | Goliad, Texas, US |
1357466 | 1357466 | 2020-09-03 | US | Texas | Maverick | 48323 | 2761 | 84 | 0 | 3251 | 28.7429195 | -100.3157686 | 2020-09-04 04:28:26 | Maverick, Texas, US |
1357543 | 1357543 | 2020-09-03 | US | Texas | Victoria | 48469 | 3967 | 82 | 0 | 3737 | 28.79780988 | -96.96813006 | 2020-09-04 04:28:26 | Victoria, Texas, US |
1357465 | 1357465 | 2020-09-03 | US | Texas | Matagorda | 48321 | 941 | 39 | 0 | 900 | 28.81955746 | -96.01230294 | 2020-09-04 04:28:26 | Matagorda, Texas, US |
1357562 | 1357562 | 2020-09-03 | US | Texas | Zavala | 48507 | 286 | 11 | 0 | 255 | 28.86617238 | -99.76050829 | 2020-09-04 04:28:26 | Zavala, Texas, US |
1357389 | 1357389 | 2020-09-03 | US | Texas | Frio | 48163 | 844 | 7 | 0 | 634 | 28.86751206 | -99.10804207 | 2020-09-04 04:28:26 | Frio, Texas, US |
1357314 | 1357314 | 2020-09-03 | US | Texas | Atascosa | 48013 | 1134 | 27 | 0 | 549 | 28.89333001 | -98.52730485 | 2020-09-04 04:28:26 | Atascosa, Texas, US |
1357435 | 1357435 | 2020-09-03 | US | Texas | Karnes | 48255 | 875 | 12 | 0 | 734 | 28.90705334 | -97.85960149 | 2020-09-04 04:28:26 | Karnes, Texas, US |
1357427 | 1357427 | 2020-09-03 | US | Texas | Jackson | 48239 | 553 | 14 | 0 | 491 | 28.95472367 | -96.57749563 | 2020-09-04 04:28:26 | Jackson, Texas, US |
1357366 | 1357366 | 2020-09-03 | US | Texas | DeWitt | 48123 | 716 | 25 | 0 | 845 | 29.08101855 | -97.3568117 | 2020-09-04 04:28:26 | DeWitt, Texas, US |
1357555 | 1357555 | 2020-09-03 | US | Texas | Wilson | 48493 | 875 | 25 | 0 | 516 | 29.1732598 | -98.08693082 | 2020-09-04 04:28:26 | Wilson, Texas, US |
1357327 | 1357327 | 2020-09-03 | US | Texas | Brazoria | 48039 | 10969 | 143 | 0 | 9448 | 29.18757369 | -95.44563172 | 2020-09-04 04:28:26 | Brazoria, Texas, US |
1357549 | 1357549 | 2020-09-03 | US | Texas | Wharton | 48481 | 1215 | 43 | 0 | 1172 | 29.27765923 | -96.22319248 | 2020-09-04 04:28:26 | Wharton, Texas, US |
1357443 | 1357443 | 2020-09-03 | US | Texas | Kinney | 48271 | 34 | 1 | 0 | 22 | 29.34967888 | -100.4186638 | 2020-09-04 04:28:26 | Kinney, Texas, US |
1357470 | 1357470 | 2020-09-03 | US | Texas | Medina | 48325 | 1249 | 37 | 0 | 1096 | 29.3557301 | -99.11030298 | 2020-09-04 04:28:26 | Medina, Texas, US |
1357540 | 1357540 | 2020-09-03 | US | Texas | Uvalde | 48463 | 752 | 24 | 0 | 681 | 29.35739637 | -99.76229172 | 2020-09-04 04:28:26 | Uvalde, Texas, US |
1357450 | 1357450 | 2020-09-03 | US | Texas | Lavaca | 48285 | 800 | 32 | 0 | 656 | 29.38508402 | -96.93186692 | 2020-09-04 04:28:26 | Lavaca, Texas, US |
1357391 | 1357391 | 2020-09-03 | US | Texas | Galveston | 48167 | 9685 | 143 | 0 | 10572 | 29.40167322 | -94.90469073 | 2020-09-04 04:28:26 | Galveston, Texas, US |
1357322 | 1357322 | 2020-09-03 | US | Texas | Bexar | 48029 | 56158 | 1136 | 0 | 45934 | 29.44928723 | -98.52019748 | 2020-09-04 04:28:26 | Bexar, Texas, US |
1357396 | 1357396 | 2020-09-03 | US | Texas | Gonzales | 48177 | 985 | 13 | 0 | 805 | 29.45634206 | -97.49424032 | 2020-09-04 04:28:26 | Gonzales, Texas, US |
1357386 | 1357386 | 2020-09-03 | US | Texas | Fort Bend | 48157 | 17396 | 243 | 0 | 14838 | 29.52704478 | -95.77219463 | 2020-09-04 04:28:26 | Fort Bend, Texas, US |
1357401 | 1357401 | 2020-09-03 | US | Texas | Guadalupe | 48187 | 3414 | 74 | 0 | 1829 | 29.58165339 | -97.94786822 | 2020-09-04 04:28:26 | Guadalupe, Texas, US |
1357352 | 1357352 | 2020-09-03 | US | Texas | Colorado | 48089 | 451 | 4 | 0 | 444 | 29.622098 | -96.5273805 | 2020-09-04 04:28:26 | Colorado, Texas, US |
1357343 | 1357343 | 2020-09-03 | US | Texas | Chambers | 48071 | 668 | 5 | 0 | 1161 | 29.70972016 | -94.67154501 | 2020-09-04 04:28:26 | Chambers, Texas, US |
1357317 | 1357317 | 2020-09-03 | US | Texas | Bandera | 48019 | 152 | 6 | 0 | 103 | 29.74619598 | -99.24598147 | 2020-09-04 04:28:26 | Bandera, Texas, US |
1357353 | 1357353 | 2020-09-03 | US | Texas | Comal | 48091 | 2702 | 96 | 0 | 2299 | 29.80811278 | -98.27647225 | 2020-09-04 04:28:26 | Comal, Texas, US |
1357329 | 1357329 | 2020-09-03 | US | Texas | Brewster | 48043 | 204 | 2 | 0 | 201 | 29.81008251 | -103.2520326 | 2020-09-04 04:28:26 | Brewster, Texas, US |
1357500 | 1357500 | 2020-09-03 | US | Texas | Real | 48385 | 107 | 5 | 0 | 100 | 29.83321503 | -99.82018052 | 2020-09-04 04:28:26 | Real, Texas, US |
1357335 | 1357335 | 2020-09-03 | US | Texas | Caldwell | 48055 | 1286 | 34 | 0 | 1221 | 29.83668859 | -97.61814775 | 2020-09-04 04:28:26 | Caldwell, Texas, US |
1357408 | 1357408 | 2020-09-03 | US | Texas | Harris | 48201 | 148710 | 2281 | 0 | 106538 | 29.85864939 | -95.39339521 | 2020-09-04 04:28:26 | Harris, Texas, US |
1357382 | 1357382 | 2020-09-03 | US | Texas | Fayette | 48149 | 459 | 17 | 0 | 457 | 29.87788372 | -96.92076062 | 2020-09-04 04:28:26 | Fayette, Texas, US |
1357430 | 1357430 | 2020-09-03 | US | Texas | Jefferson | 48245 | 5618 | 107 | 0 | 6573 | 29.8832777 | -94.16434171 | 2020-09-04 04:28:26 | Jefferson, Texas, US |
1357315 | 1357315 | 2020-09-03 | US | Texas | Austin | 48015 | 450 | 6 | 0 | 413 | 29.88548725 | -96.27736949 | 2020-09-04 04:28:26 | Austin, Texas, US |
1357541 | 1357541 | 2020-09-03 | US | Texas | Val Verde | 48465 | 1045 | 86 | 0 | 1871 | 29.89149232 | -101.1525205 | 2020-09-04 04:28:26 | Val Verde, Texas, US |
1357437 | 1357437 | 2020-09-03 | US | Texas | Kendall | 48259 | 436 | 5 | 0 | 192 | 29.94414155 | -98.7113588 | 2020-09-04 04:28:26 | Kendall, Texas, US |
1357376 | 1357376 | 2020-09-03 | US | Texas | Edwards | 48137 | 62 | 1 | 0 | 33 | 29.98202582 | -100.304252 | 2020-09-04 04:28:26 | Edwards, Texas, US |
1357496 | 1357496 | 2020-09-03 | US | Texas | Presidio | 48377 | 86 | 5 | 0 | 61 | 29.99954402 | -104.2408079 | 2020-09-04 04:28:26 | Presidio, Texas, US |
1357545 | 1357545 | 2020-09-03 | US | Texas | Waller | 48473 | 718 | 8 | 0 | 677 | 30.01058447 | -95.99011759 | 2020-09-04 04:28:26 | Waller, Texas, US |
1357412 | 1357412 | 2020-09-03 | US | Texas | Hays | 48209 | 5140 | 58 | 0 | 5388 | 30.05669873 | -98.02944344 | 2020-09-04 04:28:26 | Hays, Texas, US |
1357440 | 1357440 | 2020-09-03 | US | Texas | Kerr | 48265 | 532 | 9 | 0 | 430 | 30.06040006 | -99.34930144 | 2020-09-04 04:28:26 | Kerr, Texas, US |
1357318 | 1357318 | 2020-09-03 | US | Texas | Bastrop | 48021 | 1719 | 27 | 0 | 1589 | 30.10370699 | -97.31206354 | 2020-09-04 04:28:26 | Bastrop, Texas, US |
1357488 | 1357488 | 2020-09-03 | US | Texas | Orange | 48361 | 684 | 36 | 0 | 1763 | 30.11879481 | -93.89412775 | 2020-09-04 04:28:26 | Orange, Texas, US |
1357453 | 1357453 | 2020-09-03 | US | Texas | Liberty | 48291 | 1887 | 43 | 0 | 1817 | 30.15152688 | -94.81205615 | 2020-09-04 04:28:26 | Liberty, Texas, US |
1357547 | 1357547 | 2020-09-03 | US | Texas | Washington | 48477 | 410 | 45 | 0 | 530 | 30.21498498 | -96.40946246 | 2020-09-04 04:28:26 | Washington, Texas, US |
1357529 | 1357529 | 2020-09-03 | US | Texas | Terrell | 48443 | 5 | 0 | 0 | 3 | 30.22429013 | -102.0766732 | 2020-09-04 04:28:26 | Terrell, Texas, US |
1357323 | 1357323 | 2020-09-03 | US | Texas | Blanco | 48031 | 99 | 5 | 0 | 124 | 30.26640707 | -98.3999852 | 2020-09-04 04:28:26 | Blanco, Texas, US |
1357477 | 1357477 | 2020-09-03 | US | Texas | Montgomery | 48339 | 8933 | 132 | 0 | 8914 | 30.30079133 | -95.50572772 | 2020-09-04 04:28:26 | Montgomery, Texas, US |
1357451 | 1357451 | 2020-09-03 | US | Texas | Lee | 48287 | 281 | 14 | 0 | 183 | 30.31120597 | -96.97045773 | 2020-09-04 04:28:26 | Lee, Texas, US |
1357393 | 1357393 | 2020-09-03 | US | Texas | Gillespie | 48171 | 270 | 7 | 0 | 196 | 30.31824095 | -98.94676915 | 2020-09-04 04:28:26 | Gillespie, Texas, US |
1357407 | 1357407 | 2020-09-03 | US | Texas | Hardin | 48199 | 532 | 21 | 0 | 1160 | 30.33364686 | -94.38931817 | 2020-09-04 04:28:26 | Hardin, Texas, US |
1357534 | 1357534 | 2020-09-03 | US | Texas | Travis | 48453 | 26729 | 389 | 0 | 26337 | 30.33432034 | -97.7853562 | 2020-09-04 04:28:26 | Travis, Texas, US |
1357441 | 1357441 | 2020-09-03 | US | Texas | Kimble | 48267 | 48 | 1 | 0 | 15 | 30.48678918 | -99.74856473 | 2020-09-04 04:28:26 | Kimble, Texas, US |
1357333 | 1357333 | 2020-09-03 | US | Texas | Burleson | 48051 | 265 | 6 | 0 | 287 | 30.49273808 | -96.62158484 | 2020-09-04 04:28:26 | Burleson, Texas, US |
1357525 | 1357525 | 2020-09-03 | US | Texas | Sutton | 48435 | 83 | 2 | 0 | 75 | 30.49856623 | -100.5382014 | 2020-09-04 04:28:26 | Sutton, Texas, US |
1357400 | 1357400 | 2020-09-03 | US | Texas | Grimes | 48185 | 957 | 31 | 0 | 969 | 30.54579585 | -95.98902499 | 2020-09-04 04:28:26 | Grimes, Texas, US |
1357511 | 1357511 | 2020-09-03 | US | Texas | San Jacinto | 48407 | 337 | 8 | 0 | 196 | 30.57933681 | -95.16260304 | 2020-09-04 04:28:26 | San Jacinto, Texas, US |
1357554 | 1357554 | 2020-09-03 | US | Texas | Williamson | 48491 | 7560 | 126 | 0 | 7880 | 30.64655664 | -97.6004854 | 2020-09-04 04:28:26 | Williamson, Texas, US |
1357328 | 1357328 | 2020-09-03 | US | Texas | Brazos | 48041 | 5192 | 57 | 0 | 5350 | 30.663644800000004 | -96.30205577 | 2020-09-04 04:28:26 | Brazos, Texas, US |
1357457 | 1357457 | 2020-09-03 | US | Texas | Llano | 48299 | 87 | 1 | 0 | 100 | 30.70645047 | -98.68475262 | 2020-09-04 04:28:26 | Llano, Texas, US |
1357429 | 1357429 | 2020-09-03 | US | Texas | Jeff Davis | 48243 | 19 | 0 | 0 | 13 | 30.71490589 | -104.1399973 | 2020-09-04 04:28:26 | Jeff Davis, Texas, US |
1357464 | 1357464 | 2020-09-03 | US | Texas | Mason | 48319 | 87 | 1 | 0 | 72 | 30.71780434 | -99.22629416 | 2020-09-04 04:28:26 | Mason, Texas, US |
1357360 | 1357360 | 2020-09-03 | US | Texas | Crockett | 48105 | 168 | 6 | 0 | 156 | 30.72367027 | -101.4134238 | 2020-09-04 04:28:26 | Crockett, Texas, US |
1357544 | 1357544 | 2020-09-03 | US | Texas | Walker | 48471 | 3966 | 48 | 0 | 3369 | 30.73872995 | -95.57440968 | 2020-09-04 04:28:26 | Walker, Texas, US |
1357428 | 1357428 | 2020-09-03 | US | Texas | Jasper | 48241 | 663 | 19 | 0 | 391 | 30.74685667 | -94.02667579 | 2020-09-04 04:28:26 | Jasper, Texas, US |
1357536 | 1357536 | 2020-09-03 | US | Texas | Tyler | 48457 | 149 | 4 | 0 | 187 | 30.77031716 | -94.37690895 | 2020-09-04 04:28:26 | Tyler, Texas, US |
1357493 | 1357493 | 2020-09-03 | US | Texas | Pecos | 48371 | 347 | 4 | 0 | 306 | 30.78097267 | -102.7241261 | 2020-09-04 04:28:26 | Pecos, Texas, US |
1357483 | 1357483 | 2020-09-03 | US | Texas | Newton | 48351 | 113 | 8 | 0 | 156 | 30.78548982 | -93.74408813 | 2020-09-04 04:28:26 | Newton, Texas, US |
1357473 | 1357473 | 2020-09-03 | US | Texas | Milam | 48331 | 233 | 5 | 0 | 436 | 30.785818300000006 | -96.97718698 | 2020-09-04 04:28:26 | Milam, Texas, US |
1357334 | 1357334 | 2020-09-03 | US | Texas | Burnet | 48053 | 839 | 12 | 0 | 657 | 30.78801353 | -98.181887 | 2020-09-04 04:28:26 | Burnet, Texas, US |
1357494 | 1357494 | 2020-09-03 | US | Texas | Polk | 48373 | 1391 | 18 | 0 | 760 | 30.79472531 | -94.8276624 | 2020-09-04 04:28:26 | Polk, Texas, US |
1357471 | 1357471 | 2020-09-03 | US | Texas | Menard | 48327 | 24 | 0 | 0 | 20 | 30.88990665 | -99.8204794 | 2020-09-04 04:28:26 | Menard, Texas, US |
1357514 | 1357514 | 2020-09-03 | US | Texas | Schleicher | 48413 | 51 | 2 | 0 | 49 | 30.89740592 | -100.5384842 | 2020-09-04 04:28:26 | Schleicher, Texas, US |
1357461 | 1357461 | 2020-09-03 | US | Texas | Madison | 48313 | 722 | 5 | 0 | 690 | 30.96694679 | -95.93003775 | 2020-09-04 04:28:26 | Madison, Texas, US |
1357505 | 1357505 | 2020-09-03 | US | Texas | Robertson | 48395 | 235 | 5 | 0 | 247 | 31.02539637 | -96.51272246 | 2020-09-04 04:28:26 | Robertson, Texas, US |
1357321 | 1357321 | 2020-09-03 | US | Texas | Bell | 48027 | 1585 | 65 | 0 | 4877 | 31.03736027 | -97.4785025 | 2020-09-04 04:28:26 | Bell, Texas, US |
1357535 | 1357535 | 2020-09-03 | US | Texas | Trinity | 48455 | 221 | 6 | 0 | 174 | 31.0879489 | -95.1367187 | 2020-09-04 04:28:26 | Trinity, Texas, US |
1357513 | 1357513 | 2020-09-03 | US | Texas | San Saba | 48411 | 34 | 0 | 0 | 39 | 31.1577796 | -98.81758731 | 2020-09-04 04:28:26 | San Saba, Texas, US |
1357467 | 1357467 | 2020-09-03 | US | Texas | McCulloch | 48307 | 117 | 1 | 0 | 113 | 31.1925468 | -99.34682807 | 2020-09-04 04:28:26 | McCulloch, 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]);