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-19 and province_or_state = "Texas" sorted by longitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3181030 | 3181030 | 2020-08-18 | US | Texas | Childress | 48075 | 68 | 0 | 0 | 53 | 34.5293041 | -100.2077916 | 2020-08-19 04:27:00 | Childress, Texas, US |
3181209 | 3181209 | 2020-08-18 | US | Texas | Stonewall | 48433 | 6 | 0 | 0 | 7 | 33.17906744 | -100.2538401 | 2020-08-19 04:27:00 | Stonewall, Texas, US |
3181127 | 3181127 | 2020-08-18 | US | Texas | King | 48269 | 3 | 0 | 0 | 0 | 33.61643847 | -100.2558057 | 2020-08-19 04:27:00 | King, Texas, US |
3181235 | 3181235 | 2020-08-18 | US | Texas | Wheeler | 48483 | 41 | 0 | 0 | 39 | 35.40114335 | -100.2699514 | 2020-08-19 04:27:00 | Wheeler, Texas, US |
3181036 | 3181036 | 2020-08-18 | US | Texas | Collingsworth | 48087 | 17 | 0 | 0 | 14 | 34.96489496 | -100.2700111 | 2020-08-19 04:27:00 | Collingsworth, Texas, US |
3181098 | 3181098 | 2020-08-18 | US | Texas | Hemphill | 48211 | 48 | 0 | 0 | 45 | 35.83764858 | -100.2703577 | 2020-08-19 04:27:00 | Hemphill, Texas, US |
3181140 | 3181140 | 2020-08-18 | US | Texas | Lipscomb | 48295 | 24 | 0 | 0 | 22 | 36.27783108 | -100.2733151 | 2020-08-19 04:27:00 | Lipscomb, Texas, US |
3181043 | 3181043 | 2020-08-18 | US | Texas | Cottle | 48101 | 17 | 2 | 0 | 16 | 34.07783319 | -100.2785062 | 2020-08-19 04:27:00 | Cottle, Texas, US |
3181061 | 3181061 | 2020-08-18 | US | Texas | Edwards | 48137 | 61 | 0 | 0 | 30 | 29.98202582 | -100.304252 | 2020-08-19 04:27:00 | Edwards, Texas, US |
3181151 | 3181151 | 2020-08-18 | US | Texas | Maverick | 48323 | 2209 | 54 | 0 | 2542 | 28.7429195 | -100.3157686 | 2020-08-19 04:27:00 | Maverick, Texas, US |
3181068 | 3181068 | 2020-08-18 | US | Texas | Fisher | 48151 | 35 | 1 | 0 | 35 | 32.74281316 | -100.4019302 | 2020-08-19 04:27:00 | Fisher, Texas, US |
3181169 | 3181169 | 2020-08-18 | US | Texas | Nolan | 48353 | 120 | 3 | 0 | 138 | 32.30365282 | -100.4060208 | 2020-08-19 04:27:00 | Nolan, Texas, US |
3181128 | 3181128 | 2020-08-18 | US | Texas | Kinney | 48271 | 28 | 0 | 0 | 21 | 29.34967888 | -100.4186638 | 2020-08-19 04:27:00 | Kinney, Texas, US |
3181218 | 3181218 | 2020-08-18 | US | Texas | Tom Green | 48451 | 1641 | 50 | 0 | 2906 | 31.40464436 | -100.462443 | 2020-08-19 04:27:00 | Tom Green, Texas, US |
3181033 | 3181033 | 2020-08-18 | US | Texas | Coke | 48081 | 51 | 2 | 0 | 41 | 31.88911733 | -100.5297533 | 2020-08-19 04:27:00 | Coke, Texas, US |
3181210 | 3181210 | 2020-08-18 | US | Texas | Sutton | 48435 | 74 | 1 | 0 | 69 | 30.49856623 | -100.5382014 | 2020-08-19 04:27:00 | Sutton, Texas, US |
3181199 | 3181199 | 2020-08-18 | US | Texas | Schleicher | 48413 | 47 | 1 | 0 | 35 | 30.89740592 | -100.5384842 | 2020-08-19 04:27:00 | Schleicher, Texas, US |
3181088 | 3181088 | 2020-08-18 | US | Texas | Hall | 48191 | 17 | 1 | 0 | 14 | 34.5307555 | -100.6813852 | 2020-08-19 04:27:00 | Hall, Texas, US |
3181124 | 3181124 | 2020-08-18 | US | Texas | Kent | 48263 | 4 | 0 | 0 | 4 | 33.18104136 | -100.7780939 | 2020-08-19 04:27:00 | Kent, Texas, US |
3181055 | 3181055 | 2020-08-18 | US | Texas | Dickens | 48125 | 5 | 1 | 0 | 4 | 33.61616822 | -100.7788855 | 2020-08-19 04:27:00 | Dickens, Texas, US |
3181165 | 3181165 | 2020-08-18 | US | Texas | Motley | 48345 | 4 | 0 | 0 | 6 | 34.07408766 | -100.779722 | 2020-08-19 04:27:00 | Motley, Texas, US |
3181082 | 3181082 | 2020-08-18 | US | Texas | Gray | 48179 | 268 | 2 | 0 | 228 | 35.40081878 | -100.8129222 | 2020-08-19 04:27:00 | Gray, Texas, US |
3181189 | 3181189 | 2020-08-18 | US | Texas | Roberts | 48393 | 7 | 0 | 0 | 6 | 35.83809685 | -100.813175 | 2020-08-19 04:27:00 | Roberts, Texas, US |
3181057 | 3181057 | 2020-08-18 | US | Texas | Donley | 48129 | 49 | 0 | 0 | 49 | 34.96517499 | -100.8140093 | 2020-08-19 04:27:00 | Donley, Texas, US |
3181171 | 3181171 | 2020-08-18 | US | Texas | Ochiltree | 48357 | 105 | 2 | 0 | 98 | 36.27829105 | -100.8158184 | 2020-08-19 04:27:00 | Ochiltree, Texas, US |
3181200 | 3181200 | 2020-08-18 | US | Texas | Scurry | 48415 | 312 | 2 | 0 | 505 | 32.74613808 | -100.9162664 | 2020-08-19 04:27:00 | Scurry, Texas, US |
3181160 | 3181160 | 2020-08-18 | US | Texas | Mitchell | 48335 | 571 | 1 | 0 | 69 | 32.30623474 | -100.9212058 | 2020-08-19 04:27:00 | Mitchell, Texas, US |
3181110 | 3181110 | 2020-08-18 | US | Texas | Irion | 48235 | 14 | 0 | 0 | 9 | 31.30375559 | -100.982439 | 2020-08-19 04:27:00 | Irion, Texas, US |
3181208 | 3181208 | 2020-08-18 | US | Texas | Sterling | 48431 | 2 | 0 | 0 | 1 | 31.82781912 | -101.0500746 | 2020-08-19 04:27:00 | Sterling, Texas, US |
3181226 | 3181226 | 2020-08-18 | US | Texas | Val Verde | 48465 | 907 | 49 | 0 | 1644 | 29.89149232 | -101.1525205 | 2020-08-19 04:27:00 | Val Verde, Texas, US |
3181015 | 3181015 | 2020-08-18 | US | Texas | Briscoe | 48045 | 14 | 1 | 0 | 11 | 34.53026962 | -101.2084947 | 2020-08-19 04:27:00 | Briscoe, Texas, US |
3181077 | 3181077 | 2020-08-18 | US | Texas | Garza | 48169 | 100 | 3 | 0 | 98 | 33.17969345 | -101.2984114 | 2020-08-19 04:27:00 | Garza, Texas, US |
3181046 | 3181046 | 2020-08-18 | US | Texas | Crosby | 48107 | 65 | 1 | 0 | 68 | 33.61431553 | -101.3000364 | 2020-08-19 04:27:00 | Crosby, Texas, US |
3181069 | 3181069 | 2020-08-18 | US | Texas | Floyd | 48153 | 130 | 6 | 0 | 88 | 34.07227468 | -101.3031546 | 2020-08-19 04:27:00 | Floyd, Texas, US |
3181025 | 3181025 | 2020-08-18 | US | Texas | Carson | 48065 | 25 | 0 | 0 | 17 | 35.40365929 | -101.3542669 | 2020-08-19 04:27:00 | Carson, Texas, US |
3181090 | 3181090 | 2020-08-18 | US | Texas | Hansford | 48195 | 103 | 2 | 0 | 95 | 36.27743284 | -101.3545796 | 2020-08-19 04:27:00 | Hansford, Texas, US |
3181109 | 3181109 | 2020-08-18 | US | Texas | Hutchinson | 48233 | 165 | 3 | 0 | 130 | 35.84006574 | -101.3546643 | 2020-08-19 04:27:00 | Hutchinson, Texas, US |
3180998 | 3180998 | 2020-08-18 | US | Texas | Armstrong | 48011 | 9 | 0 | 0 | 8 | 34.96507426 | -101.3574874 | 2020-08-19 04:27:00 | Armstrong, Texas, US |
3181045 | 3181045 | 2020-08-18 | US | Texas | Crockett | 48105 | 163 | 4 | 0 | 153 | 30.72367027 | -101.4134238 | 2020-08-19 04:27:00 | Crockett, Texas, US |
3181009 | 3181009 | 2020-08-18 | US | Texas | Borden | 48033 | 0 | 0 | 0 | 0 | 32.74363984 | -101.4316509 | 2020-08-19 04:27:00 | Borden, Texas, US |
3181106 | 3181106 | 2020-08-18 | US | Texas | Howard | 48227 | 354 | 8 | 0 | 209 | 32.30621324 | -101.4356444 | 2020-08-19 04:27:00 | Howard, Texas, US |
3181079 | 3181079 | 2020-08-18 | US | Texas | Glasscock | 48173 | 9 | 0 | 0 | 6 | 31.86942909 | -101.5207776 | 2020-08-19 04:27:00 | Glasscock, Texas, US |
3181184 | 3181184 | 2020-08-18 | US | Texas | Reagan | 48383 | 76 | 5 | 0 | 61 | 31.36607041 | -101.5232659 | 2020-08-19 04:27:00 | Reagan, Texas, US |
3181211 | 3181211 | 2020-08-18 | US | Texas | Swisher | 48437 | 131 | 3 | 0 | 81 | 34.53028891 | -101.7349174 | 2020-08-19 04:27:00 | Swisher, Texas, US |
3181145 | 3181145 | 2020-08-18 | US | Texas | Lynn | 48305 | 44 | 4 | 0 | 70 | 33.17657705 | -101.8162849 | 2020-08-19 04:27:00 | Lynn, Texas, US |
3181144 | 3181144 | 2020-08-18 | US | Texas | Lubbock | 48303 | 2666 | 80 | 0 | 6462 | 33.61008596 | -101.8204789 | 2020-08-19 04:27:00 | Lubbock, Texas, US |
3181087 | 3181087 | 2020-08-18 | US | Texas | Hale | 48189 | 442 | 32 | 0 | 1459 | 34.07044901 | -101.8268114 | 2020-08-19 04:27:00 | Hale, Texas, US |
3181163 | 3181163 | 2020-08-18 | US | Texas | Moore | 48341 | 1213 | 14 | 0 | 1078 | 35.83769242 | -101.8930281 | 2020-08-19 04:27:00 | Moore, Texas, US |
3181203 | 3181203 | 2020-08-18 | US | Texas | Sherman | 48421 | 53 | 0 | 0 | 46 | 36.27751473 | -101.8933156 | 2020-08-19 04:27:00 | Sherman, Texas, US |
3181180 | 3181180 | 2020-08-18 | US | Texas | Potter | 48375 | 3882 | 47 | 0 | 3819 | 35.40133773 | -101.893964 | 2020-08-19 04:27:00 | Potter, Texas, US |
3181183 | 3181183 | 2020-08-18 | US | Texas | Randall | 48381 | 1656 | 25 | 0 | 1902 | 34.96585996 | -101.8971322 | 2020-08-19 04:27:00 | Randall, Texas, US |
3181050 | 3181050 | 2020-08-18 | US | Texas | Dawson | 48115 | 202 | 5 | 0 | 167 | 32.74255572 | -101.9477242 | 2020-08-19 04:27:00 | Dawson, Texas, US |
3181148 | 3181148 | 2020-08-18 | US | Texas | Martin | 48317 | 83 | 5 | 0 | 64 | 32.30600051 | -101.9513518 | 2020-08-19 04:27:00 | Martin, Texas, US |
3181157 | 3181157 | 2020-08-18 | US | Texas | Midland | 48329 | 2219 | 60 | 0 | 2893 | 31.86904128 | -102.0315682 | 2020-08-19 04:27:00 | Midland, Texas, US |
3181224 | 3181224 | 2020-08-18 | US | Texas | Upton | 48461 | 27 | 1 | 0 | 15 | 31.36868194 | -102.0423217 | 2020-08-19 04:27:00 | Upton, Texas, US |
3181214 | 3181214 | 2020-08-18 | US | Texas | Terrell | 48443 | 5 | 0 | 0 | 3 | 30.22429013 | -102.0766732 | 2020-08-19 04:27:00 | Terrell, Texas, US |
3181027 | 3181027 | 2020-08-18 | US | Texas | Castro | 48069 | 232 | 4 | 0 | 206 | 34.53016752 | -102.2617243 | 2020-08-19 04:27:00 | Castro, Texas, US |
3181215 | 3181215 | 2020-08-18 | US | Texas | Terry | 48445 | 36 | 2 | 0 | 171 | 33.17402785 | -102.3354521 | 2020-08-19 04:27:00 | Terry, Texas, US |
3181102 | 3181102 | 2020-08-18 | US | Texas | Hockley | 48219 | 199 | 5 | 0 | 223 | 33.60771256 | -102.3431676 | 2020-08-19 04:27:00 | Hockley, Texas, US |
3181133 | 3181133 | 2020-08-18 | US | Texas | Lamb | 48279 | 237 | 18 | 0 | 231 | 34.06859623 | -102.3516289 | 2020-08-19 04:27:00 | Lamb, Texas, US |
3181044 | 3181044 | 2020-08-18 | US | Texas | Crane | 48103 | 100 | 2 | 0 | 68 | 31.43052248 | -102.5143314 | 2020-08-19 04:27:00 | Crane, Texas, US |
3181060 | 3181060 | 2020-08-18 | US | Texas | Ector | 48135 | 2251 | 62 | 0 | 3827 | 31.86898877 | -102.5429428 | 2020-08-19 04:27:00 | Ector, Texas, US |
3181048 | 3181048 | 2020-08-18 | US | Texas | Dallam | 48111 | 240 | 6 | 0 | 193 | 36.27787176 | -102.6020725 | 2020-08-19 04:27:00 | Dallam, Texas, US |
3181172 | 3181172 | 2020-08-18 | US | Texas | Oldham | 48359 | 16 | 1 | 0 | 13 | 35.40425596 | -102.6027606 | 2020-08-19 04:27:00 | Oldham, Texas, US |
3181095 | 3181095 | 2020-08-18 | US | Texas | Hartley | 48205 | 70 | 0 | 0 | 95 | 35.84008013 | -102.6029022 | 2020-08-19 04:27:00 | Hartley, Texas, US |
3181052 | 3181052 | 2020-08-18 | US | Texas | Deaf Smith | 48117 | 874 | 19 | 0 | 719 | 34.96522957 | -102.6054267 | 2020-08-19 04:27:00 | Deaf Smith, Texas, US |
3181075 | 3181075 | 2020-08-18 | US | Texas | Gaines | 48165 | 61 | 4 | 0 | 195 | 32.74055318 | -102.6353295 | 2020-08-19 04:27:00 | Gaines, Texas, US |
3180994 | 3180994 | 2020-08-18 | US | Texas | Andrews | 48003 | 258 | 7 | 0 | 339 | 32.30468633 | -102.6376548 | 2020-08-19 04:27:00 | Andrews, Texas, US |
3181178 | 3181178 | 2020-08-18 | US | Texas | Pecos | 48371 | 282 | 2 | 0 | 261 | 30.78097267 | -102.7241261 | 2020-08-19 04:27:00 | Pecos, Texas, US |
3181177 | 3181177 | 2020-08-18 | US | Texas | Parmer | 48369 | 397 | 7 | 0 | 356 | 34.52993409 | -102.7844668 | 2020-08-19 04:27:00 | Parmer, Texas, US |
3181244 | 3181244 | 2020-08-18 | US | Texas | Yoakum | 48501 | 58 | 3 | 0 | 121 | 33.17320212 | -102.8276433 | 2020-08-19 04:27:00 | Yoakum, Texas, US |
3181032 | 3181032 | 2020-08-18 | US | Texas | Cochran | 48079 | 30 | 0 | 0 | 34 | 33.60425307 | -102.8284499 | 2020-08-19 04:27:00 | Cochran, Texas, US |
3181001 | 3181001 | 2020-08-18 | US | Texas | Bailey | 48017 | 206 | 4 | 0 | 191 | 34.06854817 | -102.8299707 | 2020-08-19 04:27:00 | Bailey, Texas, US |
3181241 | 3181241 | 2020-08-18 | US | Texas | Winkler | 48495 | 107 | 1 | 0 | 87 | 31.85008651 | -103.0485163 | 2020-08-19 04:27:00 | Winkler, Texas, US |
3181231 | 3181231 | 2020-08-18 | US | Texas | Ward | 48475 | 116 | 1 | 0 | 99 | 31.50999644 | -103.0927909 | 2020-08-19 04:27:00 | Ward, Texas, US |
3181014 | 3181014 | 2020-08-18 | US | Texas | Brewster | 48043 | 187 | 2 | 0 | 185 | 29.81008251 | -103.2520326 | 2020-08-19 04:27:00 | Brewster, Texas, US |
3181143 | 3181143 | 2020-08-18 | US | Texas | Loving | 48301 | 0 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-08-19 04:27:00 | Loving, Texas, US |
3181187 | 3181187 | 2020-08-18 | US | Texas | Reeves | 48389 | 207 | 5 | 0 | 149 | 31.32323325 | -103.6903896 | 2020-08-19 04:27:00 | Reeves, Texas, US |
3181114 | 3181114 | 2020-08-18 | US | Texas | Jeff Davis | 48243 | 14 | 0 | 0 | 8 | 30.71490589 | -104.1399973 | 2020-08-19 04:27:00 | Jeff Davis, Texas, US |
3181181 | 3181181 | 2020-08-18 | US | Texas | Presidio | 48377 | 66 | 4 | 0 | 45 | 29.99954402 | -104.2408079 | 2020-08-19 04:27:00 | Presidio, Texas, US |
3181047 | 3181047 | 2020-08-18 | US | Texas | Culberson | 48109 | 22 | 2 | 0 | 20 | 31.44506775 | -104.5185739 | 2020-08-19 04:27:00 | Culberson, Texas, US |
3181107 | 3181107 | 2020-08-18 | US | Texas | Hudspeth | 48229 | 75 | 2 | 0 | 33 | 31.45628381 | -105.388178 | 2020-08-19 04:27:00 | Hudspeth, Texas, US |
3181062 | 3181062 | 2020-08-18 | US | Texas | El Paso | 48141 | 11343 | 366 | 0 | 18316 | 31.76980765 | -106.2363275 | 2020-08-19 04:27:00 | El Paso, Texas, US |
3181168 | 3181168 | 2020-08-18 | US | Texas | Newton | 48351 | 94 | 4 | 0 | 120 | 30.78548982 | -93.74408813 | 2020-08-19 04:27:00 | Newton, Texas, US |
3181194 | 3181194 | 2020-08-18 | US | Texas | Sabine | 48403 | 43 | 6 | 0 | 60 | 31.34318809 | -93.85440451 | 2020-08-19 04:27:00 | Sabine, Texas, US |
3181173 | 3181173 | 2020-08-18 | US | Texas | Orange | 48361 | 562 | 29 | 0 | 1595 | 30.11879481 | -93.89412775 | 2020-08-19 04:27:00 | Orange, Texas, US |
3181113 | 3181113 | 2020-08-18 | US | Texas | Jasper | 48241 | 598 | 15 | 0 | 347 | 30.74685667 | -94.02667579 | 2020-08-19 04:27:00 | Jasper, Texas, US |
3181202 | 3181202 | 2020-08-18 | US | Texas | Shelby | 48419 | 439 | 18 | 0 | 398 | 31.79211404 | -94.14550696 | 2020-08-19 04:27:00 | Shelby, Texas, US |
3181115 | 3181115 | 2020-08-18 | US | Texas | Jefferson | 48245 | 5124 | 96 | 0 | 6220 | 29.8832777 | -94.16434171 | 2020-08-19 04:27:00 | Jefferson, Texas, US |
3181195 | 3181195 | 2020-08-18 | US | Texas | San Augustine | 48405 | 100 | 11 | 0 | 170 | 31.39457611 | -94.17000399 | 2020-08-19 04:27:00 | San Augustine, Texas, US |
3181175 | 3181175 | 2020-08-18 | US | Texas | Panola | 48365 | 281 | 18 | 0 | 283 | 32.1639596 | -94.30552481 | 2020-08-19 04:27:00 | Panola, Texas, US |
3181026 | 3181026 | 2020-08-18 | US | Texas | Cass | 48067 | 208 | 9 | 0 | 197 | 33.07499881 | -94.34646905 | 2020-08-19 04:27:00 | Cass, Texas, US |
3181147 | 3181147 | 2020-08-18 | US | Texas | Marion | 48315 | 99 | 10 | 0 | 126 | 32.79868409 | -94.3566123 | 2020-08-19 04:27:00 | Marion, Texas, US |
3181094 | 3181094 | 2020-08-18 | US | Texas | Harrison | 48203 | 686 | 24 | 0 | 725 | 32.54935988 | -94.36934071 | 2020-08-19 04:27:00 | Harrison, Texas, US |
3181221 | 3181221 | 2020-08-18 | US | Texas | Tyler | 48457 | 107 | 3 | 0 | 149 | 30.77031716 | -94.37690895 | 2020-08-19 04:27:00 | Tyler, Texas, US |
3181092 | 3181092 | 2020-08-18 | US | Texas | Hardin | 48199 | 446 | 18 | 0 | 1126 | 30.33364686 | -94.38931817 | 2020-08-19 04:27:00 | Hardin, Texas, US |
3181011 | 3181011 | 2020-08-18 | US | Texas | Bowie | 48037 | 983 | 39 | 0 | 772 | 33.44626922 | -94.41834132 | 2020-08-19 04:27:00 | Bowie, Texas, US |
3180995 | 3180995 | 2020-08-18 | US | Texas | Angelina | 48005 | 1665 | 54 | 0 | 1876 | 31.25457347 | -94.60901487 | 2020-08-19 04:27:00 | Angelina, Texas, US |
3181166 | 3181166 | 2020-08-18 | US | Texas | Nacogdoches | 48347 | 1430 | 44 | 0 | 1177 | 31.62017125 | -94.61803994 | 2020-08-19 04:27:00 | Nacogdoches, Texas, US |
3181028 | 3181028 | 2020-08-18 | US | Texas | Chambers | 48071 | 550 | 5 | 0 | 1023 | 29.70972016 | -94.67154501 | 2020-08-19 04:27:00 | Chambers, 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]);