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 day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185141 | 185141 | 2021-02-21 | US | Texas | Harris | 48201 | 409846 | 4851 | 0 | 337458 | 29.85864939 | -95.39339521 | 2021-02-22 05:24:21 | Harris, Texas, US |
185142 | 185142 | 2021-02-21 | US | Texas | Harrison | 48203 | 5026 | 90 | 0 | 4418 | 32.54935988 | -94.36934071 | 2021-02-22 05:24:21 | Harrison, Texas, US |
185143 | 185143 | 2021-02-21 | US | Texas | Hartley | 48205 | 599 | 2 | 0 | 432 | 35.84008013 | -102.6029022 | 2021-02-22 05:24:21 | Hartley, Texas, US |
185144 | 185144 | 2021-02-21 | US | Texas | Haskell | 48207 | 426 | 21 | 0 | 406 | 33.17823584 | -99.73037358 | 2021-02-22 05:24:21 | Haskell, Texas, US |
185145 | 185145 | 2021-02-21 | US | Texas | Hays | 48209 | 18084 | 202 | 0 | 17396 | 30.05669873 | -98.02944344 | 2021-02-22 05:24:21 | Hays, Texas, US |
185146 | 185146 | 2021-02-21 | US | Texas | Hemphill | 48211 | 653 | 2 | 0 | 542 | 35.83764858 | -100.2703577 | 2021-02-22 05:24:21 | Hemphill, Texas, US |
185147 | 185147 | 2021-02-21 | US | Texas | Henderson | 48213 | 4247 | 148 | 0 | 5300 | 32.21128872 | -95.85846587 | 2021-02-22 05:24:21 | Henderson, Texas, US |
185148 | 185148 | 2021-02-21 | US | Texas | Hidalgo | 48215 | 80856 | 2584 | 0 | 70139 | 26.39418217 | -98.18299696 | 2021-02-22 05:24:21 | Hidalgo, Texas, US |
185149 | 185149 | 2021-02-21 | US | Texas | Hill | 48217 | 5032 | 89 | 0 | 4193 | 31.99045053 | -97.13423143 | 2021-02-22 05:24:21 | Hill, Texas, US |
185150 | 185150 | 2021-02-21 | US | Texas | Hockley | 48219 | 3265 | 98 | 0 | 2215 | 33.60771256 | -102.3431676 | 2021-02-22 05:24:21 | Hockley, Texas, US |
185151 | 185151 | 2021-02-21 | US | Texas | Hood | 48221 | 5980 | 107 | 0 | 6008 | 32.42990927 | -97.83242024 | 2021-02-22 05:24:21 | Hood, Texas, US |
185152 | 185152 | 2021-02-21 | US | Texas | Hopkins | 48223 | 2555 | 99 | 0 | 2777 | 33.14875072 | -95.56351139 | 2021-02-22 05:24:21 | Hopkins, Texas, US |
185153 | 185153 | 2021-02-21 | US | Texas | Houston | 48225 | 1568 | 37 | 0 | 1500 | 31.31925973 | -95.42226208 | 2021-02-22 05:24:21 | Houston, Texas, US |
185154 | 185154 | 2021-02-21 | US | Texas | Howard | 48227 | 3832 | 95 | 0 | 4374 | 32.30621324 | -101.4356444 | 2021-02-22 05:24:21 | Howard, Texas, US |
185155 | 185155 | 2021-02-21 | US | Texas | Hudspeth | 48229 | 647 | 11 | 0 | 484 | 31.45628381 | -105.388178 | 2021-02-22 05:24:21 | Hudspeth, Texas, US |
185156 | 185156 | 2021-02-21 | US | Texas | Hunt | 48231 | 4858 | 138 | 0 | 5117 | 33.12351514 | -96.08551032 | 2021-02-22 05:24:21 | Hunt, Texas, US |
185157 | 185157 | 2021-02-21 | US | Texas | Hutchinson | 48233 | 2550 | 68 | 0 | 1453 | 35.84006574 | -101.3546643 | 2021-02-22 05:24:21 | Hutchinson, Texas, US |
185158 | 185158 | 2021-02-21 | US | Texas | Irion | 48235 | 103 | 1 | 0 | 106 | 31.30375559 | -100.982439 | 2021-02-22 05:24:21 | Irion, Texas, US |
185159 | 185159 | 2021-02-21 | US | Texas | Jack | 48237 | 589 | 13 | 0 | 583 | 33.23377248 | -98.17283469 | 2021-02-22 05:24:21 | Jack, Texas, US |
185160 | 185160 | 2021-02-21 | US | Texas | Jackson | 48239 | 1613 | 28 | 0 | 1544 | 28.95472367 | -96.57749563 | 2021-02-22 05:24:21 | Jackson, Texas, US |
185161 | 185161 | 2021-02-21 | US | Texas | Jasper | 48241 | 2598 | 70 | 0 | 2194 | 30.74685667 | -94.02667579 | 2021-02-22 05:24:21 | Jasper, Texas, US |
185162 | 185162 | 2021-02-21 | US | Texas | Jeff Davis | 48243 | 160 | 2 | 0 | 170 | 30.71490589 | -104.1399973 | 2021-02-22 05:24:21 | Jeff Davis, Texas, US |
185163 | 185163 | 2021-02-21 | US | Texas | Jefferson | 48245 | 17409 | 335 | 0 | 17527 | 29.8832777 | -94.16434171 | 2021-02-22 05:24:21 | Jefferson, Texas, US |
185164 | 185164 | 2021-02-21 | US | Texas | Jim Hogg | 48247 | 680 | 14 | 0 | 587 | 27.04453923 | -98.6968187 | 2021-02-22 05:24:21 | Jim Hogg, Texas, US |
185165 | 185165 | 2021-02-21 | US | Texas | Jim Wells | 48249 | 4203 | 81 | 0 | 3737 | 27.73103938 | -98.0904705 | 2021-02-22 05:24:21 | Jim Wells, Texas, US |
185166 | 185166 | 2021-02-21 | US | Texas | Johnson | 48251 | 18382 | 308 | 0 | 17919 | 32.37877812 | -97.36615819 | 2021-02-22 05:24:21 | Johnson, Texas, US |
185167 | 185167 | 2021-02-21 | US | Texas | Jones | 48253 | 3052 | 47 | 0 | 2688 | 32.73997145 | -99.87861576 | 2021-02-22 05:24:21 | Jones, Texas, US |
185168 | 185168 | 2021-02-21 | US | Texas | Karnes | 48255 | 1704 | 31 | 0 | 1638 | 28.90705334 | -97.85960149 | 2021-02-22 05:24:21 | Karnes, Texas, US |
185169 | 185169 | 2021-02-21 | US | Texas | Kaufman | 48257 | 14366 | 212 | 0 | 14292 | 32.599141700000004 | -96.28734728 | 2021-02-22 05:24:21 | Kaufman, Texas, US |
185170 | 185170 | 2021-02-21 | US | Texas | Kendall | 48259 | 3051 | 60 | 0 | 2630 | 29.94414155 | -98.7113588 | 2021-02-22 05:24:21 | Kendall, Texas, US |
185171 | 185171 | 2021-02-21 | US | Texas | Kenedy | 48261 | 34 | 2 | 0 | 31 | 26.92601662 | -97.66413984 | 2021-02-22 05:24:21 | Kenedy, Texas, US |
185172 | 185172 | 2021-02-21 | US | Texas | Kent | 48263 | 77 | 1 | 0 | 76 | 33.18104136 | -100.7780939 | 2021-02-22 05:24:21 | Kent, Texas, US |
185173 | 185173 | 2021-02-21 | US | Texas | Kerr | 48265 | 4067 | 80 | 0 | 3907 | 30.06040006 | -99.34930144 | 2021-02-22 05:24:21 | Kerr, Texas, US |
185174 | 185174 | 2021-02-21 | US | Texas | Kimble | 48267 | 238 | 6 | 0 | 249 | 30.48678918 | -99.74856473 | 2021-02-22 05:24:21 | Kimble, Texas, US |
185175 | 185175 | 2021-02-21 | US | Texas | King | 48269 | 22 | 0 | 0 | 13 | 33.61643847 | -100.2558057 | 2021-02-22 05:24:21 | King, Texas, US |
185176 | 185176 | 2021-02-21 | US | Texas | Kinney | 48271 | 385 | 6 | 0 | 326 | 29.34967888 | -100.4186638 | 2021-02-22 05:24:21 | Kinney, Texas, US |
185177 | 185177 | 2021-02-21 | US | Texas | Kleberg | 48273 | 2515 | 78 | 0 | 2250 | 27.42435506 | -97.69894948 | 2021-02-22 05:24:21 | Kleberg, Texas, US |
185178 | 185178 | 2021-02-21 | US | Texas | Knox | 48275 | 249 | 15 | 0 | 238 | 33.60519951 | -99.7422906 | 2021-02-22 05:24:21 | Knox, Texas, US |
185179 | 185179 | 2021-02-21 | US | Texas | La Salle | 48283 | 975 | 22 | 0 | 785 | 28.34453111 | -99.09908775 | 2021-02-22 05:24:21 | La Salle, Texas, US |
185180 | 185180 | 2021-02-21 | US | Texas | Lamar | 48277 | 3439 | 140 | 0 | 5421 | 33.66981763 | -95.57404777 | 2021-02-22 05:24:21 | Lamar, Texas, US |
185181 | 185181 | 2021-02-21 | US | Texas | Lamb | 48279 | 2542 | 79 | 0 | 1880 | 34.06859623 | -102.3516289 | 2021-02-22 05:24:21 | Lamb, Texas, US |
185182 | 185182 | 2021-02-21 | US | Texas | Lampasas | 48281 | 2371 | 26 | 0 | 1993 | 31.19531316 | -98.24206613 | 2021-02-22 05:24:21 | Lampasas, Texas, US |
185183 | 185183 | 2021-02-21 | US | Texas | Lavaca | 48285 | 2152 | 70 | 0 | 2109 | 29.38508402 | -96.93186692 | 2021-02-22 05:24:21 | Lavaca, Texas, US |
185184 | 185184 | 2021-02-21 | US | Texas | Lee | 48287 | 2001 | 36 | 0 | 1913 | 30.31120597 | -96.97045773 | 2021-02-22 05:24:21 | Lee, Texas, US |
185185 | 185185 | 2021-02-21 | US | Texas | Leon | 48289 | 1874 | 36 | 0 | 1481 | 31.29872538 | -95.9936328 | 2021-02-22 05:24:21 | Leon, Texas, US |
185186 | 185186 | 2021-02-21 | US | Texas | Liberty | 48291 | 6753 | 153 | 0 | 6573 | 30.15152688 | -94.81205615 | 2021-02-22 05:24:21 | Liberty, Texas, US |
185187 | 185187 | 2021-02-21 | US | Texas | Limestone | 48293 | 2763 | 58 | 0 | 2519 | 31.5454767 | -96.58095444 | 2021-02-22 05:24:21 | Limestone, Texas, US |
185188 | 185188 | 2021-02-21 | US | Texas | Lipscomb | 48295 | 343 | 11 | 0 | 281 | 36.27783108 | -100.2733151 | 2021-02-22 05:24:21 | Lipscomb, Texas, US |
185189 | 185189 | 2021-02-21 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-22 05:24:21 | Live Oak, Texas, US |
185190 | 185190 | 2021-02-21 | US | Texas | Llano | 48299 | 1631 | 44 | 0 | 1417 | 30.70645047 | -98.68475262 | 2021-02-22 05:24:21 | Llano, Texas, US |
185191 | 185191 | 2021-02-21 | US | Texas | Loving | 48301 | 1 | 0 | 0 | 1 | 31.84947612 | -103.5818571 | 2021-02-22 05:24:21 | Loving, Texas, US |
185192 | 185192 | 2021-02-21 | US | Texas | Lubbock | 48303 | 41078 | 758 | 0 | 47218 | 33.61008596 | -101.8204789 | 2021-02-22 05:24:21 | Lubbock, Texas, US |
185193 | 185193 | 2021-02-21 | US | Texas | Lynn | 48305 | 592 | 22 | 0 | 585 | 33.17657705 | -101.8162849 | 2021-02-22 05:24:21 | Lynn, Texas, US |
185194 | 185194 | 2021-02-21 | US | Texas | Madison | 48313 | 2106 | 24 | 0 | 1824 | 30.96694679 | -95.93003775 | 2021-02-22 05:24:21 | Madison, Texas, US |
185195 | 185195 | 2021-02-21 | US | Texas | Marion | 48315 | 592 | 24 | 0 | 486 | 32.79868409 | -94.3566123 | 2021-02-22 05:24:21 | Marion, Texas, US |
185196 | 185196 | 2021-02-21 | US | Texas | Martin | 48317 | 569 | 18 | 0 | 595 | 32.30600051 | -101.9513518 | 2021-02-22 05:24:21 | Martin, Texas, US |
185197 | 185197 | 2021-02-21 | US | Texas | Mason | 48319 | 340 | 4 | 0 | 373 | 30.71780434 | -99.22629416 | 2021-02-22 05:24:21 | Mason, Texas, US |
185198 | 185198 | 2021-02-21 | US | Texas | Matagorda | 48321 | 3155 | 89 | 0 | 3018 | 28.81955746 | -96.01230294 | 2021-02-22 05:24:21 | Matagorda, Texas, US |
185199 | 185199 | 2021-02-21 | US | Texas | Maverick | 48323 | 9172 | 283 | 0 | 9748 | 28.7429195 | -100.3157686 | 2021-02-22 05:24:21 | Maverick, Texas, US |
185200 | 185200 | 2021-02-21 | US | Texas | McCulloch | 48307 | 504 | 15 | 0 | 512 | 31.1925468 | -99.34682807 | 2021-02-22 05:24:21 | McCulloch, Texas, US |
185201 | 185201 | 2021-02-21 | US | Texas | McLennan | 48309 | 20439 | 424 | 0 | 23844 | 31.55255453 | -97.20217694 | 2021-02-22 05:24:21 | McLennan, Texas, US |
185202 | 185202 | 2021-02-21 | US | Texas | McMullen | 48311 | 85 | 4 | 0 | 76 | 28.35251708 | -98.56769164 | 2021-02-22 05:24:21 | McMullen, Texas, US |
185203 | 185203 | 2021-02-21 | US | Texas | Medina | 48325 | 4463 | 91 | 0 | 4447 | 29.3557301 | -99.11030298 | 2021-02-22 05:24:21 | Medina, Texas, US |
185204 | 185204 | 2021-02-21 | US | Texas | Menard | 48327 | 195 | 7 | 0 | 198 | 30.88990665 | -99.8204794 | 2021-02-22 05:24:21 | Menard, Texas, US |
185205 | 185205 | 2021-02-21 | US | Texas | Midland | 48329 | 18224 | 236 | 0 | 15904 | 31.86904128 | -102.0315682 | 2021-02-22 05:24:21 | Midland, Texas, US |
185206 | 185206 | 2021-02-21 | US | Texas | Milam | 48331 | 1880 | 37 | 0 | 2258 | 30.785818300000006 | -96.97718698 | 2021-02-22 05:24:21 | Milam, Texas, US |
185207 | 185207 | 2021-02-21 | US | Texas | Mills | 48333 | 723 | 20 | 0 | 590 | 31.49557106 | -98.59272068 | 2021-02-22 05:24:21 | Mills, Texas, US |
185208 | 185208 | 2021-02-21 | US | Texas | Mitchell | 48335 | 1127 | 29 | 0 | 546 | 32.30623474 | -100.9212058 | 2021-02-22 05:24:21 | Mitchell, Texas, US |
185209 | 185209 | 2021-02-21 | US | Texas | Montague | 48337 | 2029 | 61 | 0 | 1911 | 33.67521893 | -97.72500958 | 2021-02-22 05:24:21 | Montague, Texas, US |
185210 | 185210 | 2021-02-21 | US | Texas | Montgomery | 48339 | 44689 | 439 | 0 | 43621 | 30.30079133 | -95.50572772 | 2021-02-22 05:24:21 | Montgomery, Texas, US |
185211 | 185211 | 2021-02-21 | US | Texas | Moore | 48341 | 2779 | 68 | 0 | 2145 | 35.83769242 | -101.8930281 | 2021-02-22 05:24:21 | Moore, Texas, US |
185212 | 185212 | 2021-02-21 | US | Texas | Morris | 48343 | 969 | 24 | 0 | 799 | 33.11304005 | -94.73255695 | 2021-02-22 05:24:21 | Morris, Texas, US |
185213 | 185213 | 2021-02-21 | US | Texas | Motley | 48345 | 123 | 7 | 0 | 78 | 34.07408766 | -100.779722 | 2021-02-22 05:24:21 | Motley, Texas, US |
185214 | 185214 | 2021-02-21 | US | Texas | Nacogdoches | 48347 | 4573 | 143 | 0 | 3865 | 31.62017125 | -94.61803994 | 2021-02-22 05:24:21 | Nacogdoches, Texas, US |
185215 | 185215 | 2021-02-21 | US | Texas | Navarro | 48349 | 5800 | 113 | 0 | 5362 | 32.04620681 | -96.47428766 | 2021-02-22 05:24:21 | Navarro, Texas, US |
185216 | 185216 | 2021-02-21 | US | Texas | Newton | 48351 | 491 | 29 | 0 | 537 | 30.78548982 | -93.74408813 | 2021-02-22 05:24:21 | Newton, Texas, US |
185217 | 185217 | 2021-02-21 | US | Texas | Nolan | 48353 | 1373 | 50 | 0 | 1438 | 32.30365282 | -100.4060208 | 2021-02-22 05:24:21 | Nolan, Texas, US |
185218 | 185218 | 2021-02-21 | US | Texas | Nueces | 48355 | 28955 | 697 | 0 | 36556 | 27.736286 | -97.5433285 | 2021-02-22 05:24:21 | Nueces, Texas, US |
185219 | 185219 | 2021-02-21 | US | Texas | Ochiltree | 48357 | 1177 | 25 | 0 | 1001 | 36.27829105 | -100.8158184 | 2021-02-22 05:24:21 | Ochiltree, Texas, US |
185220 | 185220 | 2021-02-21 | US | Texas | Oldham | 48359 | 297 | 3 | 0 | 237 | 35.40425596 | -102.6027606 | 2021-02-22 05:24:21 | Oldham, Texas, US |
185221 | 185221 | 2021-02-21 | US | Texas | Orange | 48361 | 6027 | 103 | 0 | 7237 | 30.11879481 | -93.89412775 | 2021-02-22 05:24:21 | Orange, Texas, US |
185222 | 185222 | 2021-02-21 | US | Texas | Palo Pinto | 48363 | 2799 | 63 | 0 | 2677 | 32.75310985 | -98.31319001 | 2021-02-22 05:24:21 | Palo Pinto, Texas, US |
185223 | 185223 | 2021-02-21 | US | Texas | Panola | 48365 | 1718 | 62 | 0 | 1405 | 32.163959600000005 | -94.30552481 | 2021-02-22 05:24:21 | Panola, Texas, US |
185224 | 185224 | 2021-02-21 | US | Texas | Parker | 48367 | 14473 | 158 | 0 | 14309 | 32.77757172 | -97.80500621 | 2021-02-22 05:24:21 | Parker, Texas, US |
185225 | 185225 | 2021-02-21 | US | Texas | Parmer | 48369 | 1344 | 34 | 0 | 1129 | 34.52993409 | -102.7844668 | 2021-02-22 05:24:21 | Parmer, Texas, US |
185226 | 185226 | 2021-02-21 | US | Texas | Pecos | 48371 | 1154 | 32 | 0 | 1413 | 30.78097267 | -102.7241261 | 2021-02-22 05:24:21 | Pecos, Texas, US |
185227 | 185227 | 2021-02-21 | US | Texas | Polk | 48373 | 2895 | 87 | 0 | 2770 | 30.79472531 | -94.8276624 | 2021-02-22 05:24:21 | Polk, Texas, US |
185228 | 185228 | 2021-02-21 | US | Texas | Potter | 48375 | 14505 | 393 | 0 | 16337 | 35.40133773 | -101.893964 | 2021-02-22 05:24:21 | Potter, Texas, US |
185229 | 185229 | 2021-02-21 | US | Texas | Presidio | 48377 | 715 | 23 | 0 | 757 | 29.99954402 | -104.2408079 | 2021-02-22 05:24:21 | Presidio, Texas, US |
185230 | 185230 | 2021-02-21 | US | Texas | Rains | 48379 | 486 | 23 | 0 | 724 | 32.87109387 | -95.79232691 | 2021-02-22 05:24:21 | Rains, Texas, US |
185231 | 185231 | 2021-02-21 | US | Texas | Randall | 48381 | 12351 | 259 | 0 | 15796 | 34.96585996 | -101.8971322 | 2021-02-22 05:24:21 | Randall, Texas, US |
185232 | 185232 | 2021-02-21 | US | Texas | Reagan | 48383 | 321 | 8 | 0 | 359 | 31.36607041 | -101.5232659 | 2021-02-22 05:24:21 | Reagan, Texas, US |
185233 | 185233 | 2021-02-21 | US | Texas | Real | 48385 | 314 | 12 | 0 | 284 | 29.83321503 | -99.82018052 | 2021-02-22 05:24:21 | Real, Texas, US |
185234 | 185234 | 2021-02-21 | US | Texas | Red River | 48387 | 679 | 34 | 0 | 603 | 33.61886692 | -95.04841765 | 2021-02-22 05:24:21 | Red River, Texas, US |
185235 | 185235 | 2021-02-21 | US | Texas | Reeves | 48389 | 1383 | 38 | 0 | 1658 | 31.32323325 | -103.6903896 | 2021-02-22 05:24:21 | Reeves, Texas, US |
185236 | 185236 | 2021-02-21 | US | Texas | Refugio | 48391 | 644 | 17 | 0 | 585 | 28.3238976 | -97.15766311 | 2021-02-22 05:24:21 | Refugio, Texas, US |
185237 | 185237 | 2021-02-21 | US | Texas | Roberts | 48393 | 67 | 1 | 0 | 54 | 35.83809685 | -100.813175 | 2021-02-22 05:24:21 | Roberts, Texas, US |
185238 | 185238 | 2021-02-21 | US | Texas | Robertson | 48395 | 2490 | 33 | 0 | 1959 | 31.02539637 | -96.51272246 | 2021-02-22 05:24:21 | Robertson, Texas, US |
185239 | 185239 | 2021-02-21 | US | Texas | Rockwall | 48397 | 11091 | 116 | 0 | 10220 | 32.89779518 | -96.40771592 | 2021-02-22 05:24:21 | Rockwall, Texas, US |
185240 | 185240 | 2021-02-21 | US | Texas | Runnels | 48399 | 1240 | 36 | 0 | 1206 | 31.8314342 | -99.97616148 | 2021-02-22 05:24:21 | Runnels, 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]);