johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where "last_update" is on date 2020-08-20 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
209271 | 209271 | 2020-08-19 | US | Texas | Cameron | 48061 | 13959 | 602 | 0 | 17736 | 26.14524221 | -97.48140372 | 2020-08-20 04:27:43 | Cameron, Texas, US |
209348 | 209348 | 2020-08-19 | US | Texas | Hidalgo | 48215 | 29219 | 1019 | 0 | 22097 | 26.39418217 | -98.18299696 | 2020-08-20 04:27:43 | Hidalgo, Texas, US |
209486 | 209486 | 2020-08-19 | US | Texas | Willacy | 48489 | 963 | 34 | 0 | 753 | 26.47411727 | -97.61535848 | 2020-08-20 04:27:43 | Willacy, Texas, US |
209454 | 209454 | 2020-08-19 | US | Texas | Starr | 48427 | 2660 | 98 | 0 | 2371 | 26.56150059 | -98.73892358 | 2020-08-20 04:27:43 | Starr, Texas, US |
209371 | 209371 | 2020-08-19 | US | Texas | Kenedy | 48261 | 5 | 1 | 0 | 6 | 26.92601662 | -97.66413984 | 2020-08-20 04:27:43 | Kenedy, Texas, US |
209494 | 209494 | 2020-08-19 | US | Texas | Zapata | 48505 | 240 | 3 | 0 | 228 | 27.00156391 | -99.16987152 | 2020-08-20 04:27:43 | Zapata, Texas, US |
209264 | 209264 | 2020-08-19 | US | Texas | Brooks | 48047 | 238 | 9 | 0 | 143 | 27.03103197 | -98.21808402 | 2020-08-20 04:27:43 | Brooks, Texas, US |
209364 | 209364 | 2020-08-19 | US | Texas | Jim Hogg | 48247 | 76 | 2 | 0 | 66 | 27.04453923 | -98.6968187 | 2020-08-20 04:27:43 | Jim Hogg, Texas, US |
209377 | 209377 | 2020-08-19 | US | Texas | Kleberg | 48273 | 727 | 19 | 0 | 510 | 27.42435506 | -97.69894948 | 2020-08-20 04:27:43 | Kleberg, Texas, US |
209306 | 209306 | 2020-08-19 | US | Texas | Duval | 48131 | 280 | 7 | 0 | 204 | 27.68184592 | -98.50864568 | 2020-08-20 04:27:43 | Duval, Texas, US |
209365 | 209365 | 2020-08-19 | US | Texas | Jim Wells | 48249 | 1162 | 19 | 0 | 860 | 27.73103938 | -98.0904705 | 2020-08-20 04:27:43 | Jim Wells, Texas, US |
209418 | 209418 | 2020-08-19 | US | Texas | Nueces | 48355 | 11753 | 300 | 0 | 17194 | 27.736286 | -97.5433285 | 2020-08-20 04:27:43 | Nueces, Texas, US |
209481 | 209481 | 2020-08-19 | US | Texas | Webb | 48479 | 7685 | 215 | 0 | 9742 | 27.7610369 | -99.33237355 | 2020-08-20 04:27:43 | Webb, Texas, US |
209445 | 209445 | 2020-08-19 | US | Texas | San Patricio | 48409 | 1472 | 44 | 0 | 1124 | 28.00880118 | -97.51763891 | 2020-08-20 04:27:43 | San Patricio, Texas, US |
209244 | 209244 | 2020-08-19 | US | Texas | Aransas | 48007 | 232 | 16 | 0 | 174 | 28.10556197 | -96.9995047 | 2020-08-20 04:27:43 | Aransas, Texas, US |
209436 | 209436 | 2020-08-19 | US | Texas | Refugio | 48391 | 273 | 9 | 0 | 237 | 28.3238976 | -97.15766311 | 2020-08-20 04:27:43 | Refugio, Texas, US |
209379 | 209379 | 2020-08-19 | US | Texas | La Salle | 48283 | 448 | 2 | 0 | 365 | 28.34453111 | -99.09908775 | 2020-08-20 04:27:43 | La Salle, Texas, US |
209389 | 209389 | 2020-08-19 | US | Texas | Live Oak | 48297 | 161 | 5 | 0 | 235 | 28.35101362 | -98.1246786 | 2020-08-20 04:27:43 | Live Oak, Texas, US |
209402 | 209402 | 2020-08-19 | US | Texas | McMullen | 48311 | 11 | 0 | 0 | 10 | 28.35251708 | -98.56769164 | 2020-08-20 04:27:43 | McMullen, Texas, US |
209253 | 209253 | 2020-08-19 | US | Texas | Bee | 48025 | 2003 | 17 | 0 | 1412 | 28.41761668 | -97.74215593 | 2020-08-20 04:27:43 | Bee, Texas, US |
209304 | 209304 | 2020-08-19 | US | Texas | Dimmit | 48127 | 172 | 4 | 0 | 164 | 28.42270064 | -99.75645095 | 2020-08-20 04:27:43 | Dimmit, Texas, US |
209269 | 209269 | 2020-08-19 | US | Texas | Calhoun | 48057 | 734 | 7 | 0 | 555 | 28.47048236 | -96.61633945 | 2020-08-20 04:27:43 | Calhoun, Texas, US |
209328 | 209328 | 2020-08-19 | US | Texas | Goliad | 48175 | 168 | 6 | 0 | 115 | 28.65696592 | -97.42760647 | 2020-08-20 04:27:43 | Goliad, Texas, US |
209399 | 209399 | 2020-08-19 | US | Texas | Maverick | 48323 | 2235 | 57 | 0 | 2539 | 28.7429195 | -100.3157686 | 2020-08-20 04:27:43 | Maverick, Texas, US |
209476 | 209476 | 2020-08-19 | US | Texas | Victoria | 48469 | 3735 | 65 | 0 | 3567 | 28.79780988 | -96.96813006 | 2020-08-20 04:27:43 | Victoria, Texas, US |
209398 | 209398 | 2020-08-19 | US | Texas | Matagorda | 48321 | 866 | 37 | 0 | 808 | 28.81955746 | -96.01230294 | 2020-08-20 04:27:43 | Matagorda, Texas, US |
209495 | 209495 | 2020-08-19 | US | Texas | Zavala | 48507 | 272 | 7 | 0 | 241 | 28.86617238 | -99.76050829 | 2020-08-20 04:27:43 | Zavala, Texas, US |
209322 | 209322 | 2020-08-19 | US | Texas | Frio | 48163 | 715 | 7 | 0 | 597 | 28.86751206 | -99.10804207 | 2020-08-20 04:27:43 | Frio, Texas, US |
209247 | 209247 | 2020-08-19 | US | Texas | Atascosa | 48013 | 1002 | 20 | 0 | 503 | 28.89333001 | -98.52730485 | 2020-08-20 04:27:43 | Atascosa, Texas, US |
209368 | 209368 | 2020-08-19 | US | Texas | Karnes | 48255 | 796 | 10 | 0 | 683 | 28.90705334 | -97.85960149 | 2020-08-20 04:27:43 | Karnes, Texas, US |
209360 | 209360 | 2020-08-19 | US | Texas | Jackson | 48239 | 505 | 12 | 0 | 431 | 28.95472367 | -96.57749563 | 2020-08-20 04:27:43 | Jackson, Texas, US |
209299 | 209299 | 2020-08-19 | US | Texas | DeWitt | 48123 | 600 | 23 | 0 | 740 | 29.08101855 | -97.3568117 | 2020-08-20 04:27:43 | DeWitt, Texas, US |
209488 | 209488 | 2020-08-19 | US | Texas | Wilson | 48493 | 811 | 21 | 0 | 486 | 29.1732598 | -98.08693082 | 2020-08-20 04:27:43 | Wilson, Texas, US |
209260 | 209260 | 2020-08-19 | US | Texas | Brazoria | 48039 | 9357 | 118 | 0 | 8249 | 29.18757369 | -95.44563172 | 2020-08-20 04:27:43 | Brazoria, Texas, US |
209482 | 209482 | 2020-08-19 | US | Texas | Wharton | 48481 | 1136 | 33 | 0 | 1016 | 29.27765923 | -96.22319248 | 2020-08-20 04:27:43 | Wharton, Texas, US |
209376 | 209376 | 2020-08-19 | US | Texas | Kinney | 48271 | 28 | 0 | 0 | 21 | 29.34967888 | -100.4186638 | 2020-08-20 04:27:43 | Kinney, Texas, US |
209403 | 209403 | 2020-08-19 | US | Texas | Medina | 48325 | 1125 | 33 | 0 | 1023 | 29.3557301 | -99.11030298 | 2020-08-20 04:27:43 | Medina, Texas, US |
209473 | 209473 | 2020-08-19 | US | Texas | Uvalde | 48463 | 626 | 15 | 0 | 600 | 29.35739637 | -99.76229172 | 2020-08-20 04:27:43 | Uvalde, Texas, US |
209383 | 209383 | 2020-08-19 | US | Texas | Lavaca | 48285 | 746 | 27 | 0 | 630 | 29.38508402 | -96.93186692 | 2020-08-20 04:27:43 | Lavaca, Texas, US |
209324 | 209324 | 2020-08-19 | US | Texas | Galveston | 48167 | 9160 | 128 | 0 | 10084 | 29.40167322 | -94.90469073 | 2020-08-20 04:27:43 | Galveston, Texas, US |
209255 | 209255 | 2020-08-19 | US | Texas | Bexar | 48029 | 52523 | 935 | 0 | 43521 | 29.44928723 | -98.52019748 | 2020-08-20 04:27:43 | Bexar, Texas, US |
209329 | 209329 | 2020-08-19 | US | Texas | Gonzales | 48177 | 894 | 11 | 0 | 739 | 29.45634206 | -97.49424032 | 2020-08-20 04:27:43 | Gonzales, Texas, US |
209319 | 209319 | 2020-08-19 | US | Texas | Fort Bend | 48157 | 16144 | 198 | 0 | 13407 | 29.52704478 | -95.77219463 | 2020-08-20 04:27:43 | Fort Bend, Texas, US |
209334 | 209334 | 2020-08-19 | US | Texas | Guadalupe | 48187 | 3188 | 61 | 0 | 1755 | 29.58165339 | -97.94786822 | 2020-08-20 04:27:43 | Guadalupe, Texas, US |
209285 | 209285 | 2020-08-19 | US | Texas | Colorado | 48089 | 416 | 2 | 0 | 368 | 29.622098 | -96.5273805 | 2020-08-20 04:27:43 | Colorado, Texas, US |
209276 | 209276 | 2020-08-19 | US | Texas | Chambers | 48071 | 584 | 5 | 0 | 1049 | 29.70972016 | -94.67154501 | 2020-08-20 04:27:43 | Chambers, Texas, US |
209250 | 209250 | 2020-08-19 | US | Texas | Bandera | 48019 | 135 | 3 | 0 | 99 | 29.74619598 | -99.24598147 | 2020-08-20 04:27:43 | Bandera, Texas, US |
209286 | 209286 | 2020-08-19 | US | Texas | Comal | 48091 | 2311 | 88 | 0 | 2112 | 29.80811278 | -98.27647225 | 2020-08-20 04:27:43 | Comal, Texas, US |
209262 | 209262 | 2020-08-19 | US | Texas | Brewster | 48043 | 189 | 2 | 0 | 185 | 29.81008251 | -103.2520326 | 2020-08-20 04:27:43 | Brewster, Texas, US |
209433 | 209433 | 2020-08-19 | US | Texas | Real | 48385 | 84 | 4 | 0 | 87 | 29.83321503 | -99.82018052 | 2020-08-20 04:27:43 | Real, Texas, US |
209268 | 209268 | 2020-08-19 | US | Texas | Caldwell | 48055 | 1218 | 30 | 0 | 1165 | 29.83668859 | -97.61814775 | 2020-08-20 04:27:43 | Caldwell, Texas, US |
209341 | 209341 | 2020-08-19 | US | Texas | Harris | 48201 | 132725 | 1920 | 0 | 92756 | 29.85864939 | -95.39339521 | 2020-08-20 04:27:43 | Harris, Texas, US |
209315 | 209315 | 2020-08-19 | US | Texas | Fayette | 48149 | 411 | 15 | 0 | 403 | 29.87788372 | -96.92076062 | 2020-08-20 04:27:43 | Fayette, Texas, US |
209363 | 209363 | 2020-08-19 | US | Texas | Jefferson | 48245 | 5315 | 96 | 0 | 6264 | 29.8832777 | -94.16434171 | 2020-08-20 04:27:43 | Jefferson, Texas, US |
209248 | 209248 | 2020-08-19 | US | Texas | Austin | 48015 | 413 | 4 | 0 | 340 | 29.88548725 | -96.27736949 | 2020-08-20 04:27:43 | Austin, Texas, US |
209474 | 209474 | 2020-08-19 | US | Texas | Val Verde | 48465 | 909 | 51 | 0 | 1724 | 29.89149232 | -101.1525205 | 2020-08-20 04:27:43 | Val Verde, Texas, US |
209370 | 209370 | 2020-08-19 | US | Texas | Kendall | 48259 | 374 | 4 | 0 | 182 | 29.94414155 | -98.7113588 | 2020-08-20 04:27:43 | Kendall, Texas, US |
209309 | 209309 | 2020-08-19 | US | Texas | Edwards | 48137 | 61 | 0 | 0 | 30 | 29.98202582 | -100.304252 | 2020-08-20 04:27:43 | Edwards, Texas, US |
209429 | 209429 | 2020-08-19 | US | Texas | Presidio | 48377 | 66 | 4 | 0 | 46 | 29.99954402 | -104.2408079 | 2020-08-20 04:27:43 | Presidio, Texas, US |
209478 | 209478 | 2020-08-19 | US | Texas | Waller | 48473 | 654 | 5 | 0 | 545 | 30.01058447 | -95.99011759 | 2020-08-20 04:27:43 | Waller, Texas, US |
209345 | 209345 | 2020-08-19 | US | Texas | Hays | 48209 | 4733 | 46 | 0 | 5164 | 30.05669873 | -98.02944344 | 2020-08-20 04:27:43 | Hays, Texas, US |
209373 | 209373 | 2020-08-19 | US | Texas | Kerr | 48265 | 501 | 6 | 0 | 413 | 30.06040006 | -99.34930144 | 2020-08-20 04:27:43 | Kerr, Texas, US |
209251 | 209251 | 2020-08-19 | US | Texas | Bastrop | 48021 | 1616 | 24 | 0 | 1453 | 30.10370699 | -97.31206354 | 2020-08-20 04:27:43 | Bastrop, Texas, US |
209421 | 209421 | 2020-08-19 | US | Texas | Orange | 48361 | 592 | 30 | 0 | 1609 | 30.11879481 | -93.89412775 | 2020-08-20 04:27:43 | Orange, Texas, US |
209386 | 209386 | 2020-08-19 | US | Texas | Liberty | 48291 | 1364 | 39 | 0 | 1144 | 30.15152688 | -94.81205615 | 2020-08-20 04:27:43 | Liberty, Texas, US |
209480 | 209480 | 2020-08-19 | US | Texas | Washington | 48477 | 379 | 41 | 0 | 507 | 30.21498498 | -96.40946246 | 2020-08-20 04:27:43 | Washington, Texas, US |
209462 | 209462 | 2020-08-19 | US | Texas | Terrell | 48443 | 5 | 0 | 0 | 3 | 30.22429013 | -102.0766732 | 2020-08-20 04:27:43 | Terrell, Texas, US |
209256 | 209256 | 2020-08-19 | US | Texas | Blanco | 48031 | 93 | 5 | 0 | 123 | 30.26640707 | -98.3999852 | 2020-08-20 04:27:43 | Blanco, Texas, US |
209410 | 209410 | 2020-08-19 | US | Texas | Montgomery | 48339 | 7528 | 109 | 0 | 7424 | 30.30079133 | -95.50572772 | 2020-08-20 04:27:43 | Montgomery, Texas, US |
209384 | 209384 | 2020-08-19 | US | Texas | Lee | 48287 | 264 | 12 | 0 | 174 | 30.31120597 | -96.97045773 | 2020-08-20 04:27:43 | Lee, Texas, US |
209326 | 209326 | 2020-08-19 | US | Texas | Gillespie | 48171 | 246 | 6 | 0 | 185 | 30.31824095 | -98.94676915 | 2020-08-20 04:27:43 | Gillespie, Texas, US |
209340 | 209340 | 2020-08-19 | US | Texas | Hardin | 48199 | 460 | 18 | 0 | 1138 | 30.33364686 | -94.38931817 | 2020-08-20 04:27:43 | Hardin, Texas, US |
209467 | 209467 | 2020-08-19 | US | Texas | Travis | 48453 | 24188 | 346 | 0 | 24716 | 30.33432034 | -97.7853562 | 2020-08-20 04:27:43 | Travis, Texas, US |
209374 | 209374 | 2020-08-19 | US | Texas | Kimble | 48267 | 47 | 1 | 0 | 15 | 30.48678918 | -99.74856473 | 2020-08-20 04:27:43 | Kimble, Texas, US |
209266 | 209266 | 2020-08-19 | US | Texas | Burleson | 48051 | 241 | 6 | 0 | 259 | 30.49273808 | -96.62158484 | 2020-08-20 04:27:43 | Burleson, Texas, US |
209458 | 209458 | 2020-08-19 | US | Texas | Sutton | 48435 | 74 | 1 | 0 | 70 | 30.49856623 | -100.5382014 | 2020-08-20 04:27:43 | Sutton, Texas, US |
209333 | 209333 | 2020-08-19 | US | Texas | Grimes | 48185 | 898 | 29 | 0 | 907 | 30.54579585 | -95.98902499 | 2020-08-20 04:27:43 | Grimes, Texas, US |
209444 | 209444 | 2020-08-19 | US | Texas | San Jacinto | 48407 | 273 | 8 | 0 | 183 | 30.57933681 | -95.16260304 | 2020-08-20 04:27:43 | San Jacinto, Texas, US |
209487 | 209487 | 2020-08-19 | US | Texas | Williamson | 48491 | 7132 | 110 | 0 | 7514 | 30.64655664 | -97.6004854 | 2020-08-20 04:27:43 | Williamson, Texas, US |
209261 | 209261 | 2020-08-19 | US | Texas | Brazos | 48041 | 4509 | 52 | 0 | 4173 | 30.663644800000004 | -96.30205577 | 2020-08-20 04:27:43 | Brazos, Texas, US |
209390 | 209390 | 2020-08-19 | US | Texas | Llano | 48299 | 80 | 1 | 0 | 94 | 30.70645047 | -98.68475262 | 2020-08-20 04:27:43 | Llano, Texas, US |
209362 | 209362 | 2020-08-19 | US | Texas | Jeff Davis | 48243 | 14 | 0 | 0 | 8 | 30.71490589 | -104.1399973 | 2020-08-20 04:27:43 | Jeff Davis, Texas, US |
209397 | 209397 | 2020-08-19 | US | Texas | Mason | 48319 | 74 | 0 | 0 | 63 | 30.71780434 | -99.22629416 | 2020-08-20 04:27:43 | Mason, Texas, US |
209293 | 209293 | 2020-08-19 | US | Texas | Crockett | 48105 | 163 | 4 | 0 | 153 | 30.72367027 | -101.4134238 | 2020-08-20 04:27:43 | Crockett, Texas, US |
209477 | 209477 | 2020-08-19 | US | Texas | Walker | 48471 | 3763 | 44 | 0 | 3158 | 30.73872995 | -95.57440968 | 2020-08-20 04:27:43 | Walker, Texas, US |
209361 | 209361 | 2020-08-19 | US | Texas | Jasper | 48241 | 608 | 15 | 0 | 355 | 30.74685667 | -94.02667579 | 2020-08-20 04:27:43 | Jasper, Texas, US |
209469 | 209469 | 2020-08-19 | US | Texas | Tyler | 48457 | 114 | 3 | 0 | 154 | 30.77031716 | -94.37690895 | 2020-08-20 04:27:43 | Tyler, Texas, US |
209426 | 209426 | 2020-08-19 | US | Texas | Pecos | 48371 | 284 | 2 | 0 | 265 | 30.78097267 | -102.7241261 | 2020-08-20 04:27:43 | Pecos, Texas, US |
209416 | 209416 | 2020-08-19 | US | Texas | Newton | 48351 | 96 | 4 | 0 | 120 | 30.78548982 | -93.74408813 | 2020-08-20 04:27:43 | Newton, Texas, US |
209406 | 209406 | 2020-08-19 | US | Texas | Milam | 48331 | 186 | 4 | 0 | 387 | 30.785818300000006 | -96.97718698 | 2020-08-20 04:27:43 | Milam, Texas, US |
209267 | 209267 | 2020-08-19 | US | Texas | Burnet | 48053 | 577 | 11 | 0 | 575 | 30.78801353 | -98.181887 | 2020-08-20 04:27:43 | Burnet, Texas, US |
209427 | 209427 | 2020-08-19 | US | Texas | Polk | 48373 | 1338 | 14 | 0 | 758 | 30.79472531 | -94.8276624 | 2020-08-20 04:27:43 | Polk, Texas, US |
209404 | 209404 | 2020-08-19 | US | Texas | Menard | 48327 | 23 | 0 | 0 | 19 | 30.88990665 | -99.8204794 | 2020-08-20 04:27:43 | Menard, Texas, US |
209447 | 209447 | 2020-08-19 | US | Texas | Schleicher | 48413 | 47 | 1 | 0 | 35 | 30.89740592 | -100.5384842 | 2020-08-20 04:27:43 | Schleicher, Texas, US |
209394 | 209394 | 2020-08-19 | US | Texas | Madison | 48313 | 698 | 3 | 0 | 682 | 30.96694679 | -95.93003775 | 2020-08-20 04:27:43 | Madison, Texas, US |
209438 | 209438 | 2020-08-19 | US | Texas | Robertson | 48395 | 217 | 3 | 0 | 238 | 31.02539637 | -96.51272246 | 2020-08-20 04:27:43 | Robertson, Texas, US |
209254 | 209254 | 2020-08-19 | US | Texas | Bell | 48027 | 1385 | 51 | 0 | 4372 | 31.03736027 | -97.4785025 | 2020-08-20 04:27:43 | Bell, Texas, US |
209468 | 209468 | 2020-08-19 | US | Texas | Trinity | 48455 | 195 | 4 | 0 | 163 | 31.0879489 | -95.1367187 | 2020-08-20 04:27:43 | Trinity, Texas, US |
209446 | 209446 | 2020-08-19 | US | Texas | San Saba | 48411 | 25 | 0 | 0 | 29 | 31.1577796 | -98.81758731 | 2020-08-20 04:27:43 | San Saba, Texas, US |
209400 | 209400 | 2020-08-19 | US | Texas | McCulloch | 48307 | 63 | 1 | 0 | 68 | 31.1925468 | -99.34682807 | 2020-08-20 04:27:43 | 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]);