johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
510 rows where "last_update" is on date 2022-05-26 and province_or_state = "Texas" sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
625025 | 625025 | 2022-05-22 | US | Texas | King | 48269 | 52 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-05-26 04:20:50 | King, Texas, US | |
2051014 | 2051014 | 2022-05-25 | US | Texas | King | 48269 | 52 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-05-26 04:20:50 | King, Texas, US | |
625041 | 625041 | 2022-05-22 | US | Texas | Loving | 48301 | 207 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-26 04:20:50 | Loving, Texas, US | |
2051030 | 2051030 | 2022-05-25 | US | Texas | Loving | 48301 | 207 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-26 04:20:50 | Loving, Texas, US | |
624907 | 624907 | 2022-05-22 | US | Texas | Borden | 48033 | 100 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-05-26 04:20:50 | Borden, Texas, US | |
625021 | 625021 | 2022-05-22 | US | Texas | Kenedy | 48261 | 86 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-05-26 04:20:50 | Kenedy, Texas, US | |
625087 | 625087 | 2022-05-22 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-26 04:20:50 | Roberts, Texas, US | |
2050896 | 2050896 | 2022-05-25 | US | Texas | Borden | 48033 | 100 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-05-26 04:20:50 | Borden, Texas, US | |
2051010 | 2051010 | 2022-05-25 | US | Texas | Kenedy | 48261 | 86 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-05-26 04:20:50 | Kenedy, Texas, US | |
2051076 | 2051076 | 2022-05-25 | US | Texas | Roberts | 48393 | 175 | 2 | 0 | 35.83809685 | -100.813175 | 2022-05-26 04:20:50 | Roberts, Texas, US | |
624977 | 624977 | 2022-05-22 | US | Texas | Glasscock | 48173 | 199 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-05-26 04:20:50 | Glasscock, Texas, US | |
624993 | 624993 | 2022-05-22 | US | Texas | Hartley | 48205 | 1365 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-05-26 04:20:50 | Hartley, Texas, US | |
625008 | 625008 | 2022-05-22 | US | Texas | Irion | 48235 | 448 | 3 | 0 | 31.30375559 | -100.982439 | 2022-05-26 04:20:50 | Irion, Texas, US | |
625112 | 625112 | 2022-05-22 | US | Texas | Terrell | 48443 | 121 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-05-26 04:20:50 | Terrell, Texas, US | |
2050966 | 2050966 | 2022-05-25 | US | Texas | Glasscock | 48173 | 199 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-05-26 04:20:50 | Glasscock, Texas, US | |
2050982 | 2050982 | 2022-05-25 | US | Texas | Hartley | 48205 | 1365 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-05-26 04:20:50 | Hartley, Texas, US | |
2050997 | 2050997 | 2022-05-25 | US | Texas | Irion | 48235 | 448 | 3 | 0 | 31.30375559 | -100.982439 | 2022-05-26 04:20:50 | Irion, Texas, US | |
2051101 | 2051101 | 2022-05-25 | US | Texas | Terrell | 48443 | 121 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-05-26 04:20:50 | Terrell, Texas, US | |
625022 | 625022 | 2022-05-22 | US | Texas | Kent | 48263 | 210 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-05-26 04:20:50 | Kent, Texas, US | |
2051011 | 2051011 | 2022-05-25 | US | Texas | Kent | 48263 | 210 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-05-26 04:20:50 | Kent, Texas, US | |
625070 | 625070 | 2022-05-22 | US | Texas | Oldham | 48359 | 565 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-05-26 04:20:50 | Oldham, Texas, US | |
2051059 | 2051059 | 2022-05-25 | US | Texas | Oldham | 48359 | 565 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-05-26 04:20:50 | Oldham, Texas, US | |
624996 | 624996 | 2022-05-22 | US | Texas | Hemphill | 48211 | 1242 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-26 04:20:50 | Hemphill, Texas, US | |
625106 | 625106 | 2022-05-22 | US | Texas | Sterling | 48431 | 245 | 7 | 0 | 31.82781912 | -101.0500746 | 2022-05-26 04:20:50 | Sterling, Texas, US | |
625107 | 625107 | 2022-05-22 | US | Texas | Stonewall | 48433 | 362 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-05-26 04:20:50 | Stonewall, Texas, US | |
2050985 | 2050985 | 2022-05-25 | US | Texas | Hemphill | 48211 | 1242 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-26 04:20:50 | Hemphill, Texas, US | |
2051095 | 2051095 | 2022-05-25 | US | Texas | Sterling | 48431 | 245 | 7 | 0 | 31.82781912 | -101.0500746 | 2022-05-26 04:20:50 | Sterling, Texas, US | |
2051096 | 2051096 | 2022-05-25 | US | Texas | Stonewall | 48433 | 362 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-05-26 04:20:50 | Stonewall, Texas, US | |
624913 | 624913 | 2022-05-22 | US | Texas | Briscoe | 48045 | 465 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-05-26 04:20:50 | Briscoe, Texas, US | |
625114 | 625114 | 2022-05-22 | US | Texas | Throckmorton | 48447 | 272 | 8 | 0 | 33.17751417 | -99.21226795 | 2022-05-26 04:20:50 | Throckmorton, Texas, US | |
2050902 | 2050902 | 2022-05-25 | US | Texas | Briscoe | 48045 | 465 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-05-26 04:20:50 | Briscoe, Texas, US | |
2051103 | 2051103 | 2022-05-25 | US | Texas | Throckmorton | 48447 | 272 | 8 | 0 | 33.17751417 | -99.21226795 | 2022-05-26 04:20:50 | Throckmorton, Texas, US | |
624896 | 624896 | 2022-05-22 | US | Texas | Armstrong | 48011 | 555 | 9 | 0 | 34.96507426 | -101.3574874 | 2022-05-26 04:20:50 | Armstrong, Texas, US | |
624941 | 624941 | 2022-05-22 | US | Texas | Cottle | 48101 | 322 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-05-26 04:20:50 | Cottle, Texas, US | |
625012 | 625012 | 2022-05-22 | US | Texas | Jeff Davis | 48243 | 224 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-26 04:20:50 | Jeff Davis, Texas, US | |
625052 | 625052 | 2022-05-22 | US | Texas | McMullen | 48311 | 169 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-05-26 04:20:50 | McMullen, Texas, US | |
625097 | 625097 | 2022-05-22 | US | Texas | Schleicher | 48413 | 530 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-05-26 04:20:50 | Schleicher, Texas, US | |
2050885 | 2050885 | 2022-05-25 | US | Texas | Armstrong | 48011 | 555 | 9 | 0 | 34.96507426 | -101.3574874 | 2022-05-26 04:20:50 | Armstrong, Texas, US | |
2050930 | 2050930 | 2022-05-25 | US | Texas | Cottle | 48101 | 322 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-05-26 04:20:50 | Cottle, Texas, US | |
2051001 | 2051001 | 2022-05-25 | US | Texas | Jeff Davis | 48243 | 224 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-26 04:20:50 | Jeff Davis, Texas, US | |
2051041 | 2051041 | 2022-05-25 | US | Texas | McMullen | 48311 | 169 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-05-26 04:20:50 | McMullen, Texas, US | |
2051086 | 2051086 | 2022-05-25 | US | Texas | Schleicher | 48413 | 530 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-05-26 04:20:50 | Schleicher, Texas, US | |
624938 | 624938 | 2022-05-22 | US | Texas | Concho | 48095 | 1091 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-05-26 04:20:50 | Concho, Texas, US | |
624959 | 624959 | 2022-05-22 | US | Texas | Edwards | 48137 | 470 | 11 | 0 | 29.98202582 | -100.304252 | 2022-05-26 04:20:50 | Edwards, Texas, US | |
624968 | 624968 | 2022-05-22 | US | Texas | Foard | 48155 | 209 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-26 04:20:50 | Foard, Texas, US | |
625026 | 625026 | 2022-05-22 | US | Texas | Kinney | 48271 | 742 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-05-26 04:20:50 | Kinney, Texas, US | |
2050927 | 2050927 | 2022-05-25 | US | Texas | Concho | 48095 | 1091 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-05-26 04:20:50 | Concho, Texas, US | |
2050948 | 2050948 | 2022-05-25 | US | Texas | Edwards | 48137 | 470 | 11 | 0 | 29.98202582 | -100.304252 | 2022-05-26 04:20:50 | Edwards, Texas, US | |
2050957 | 2050957 | 2022-05-25 | US | Texas | Foard | 48155 | 209 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-26 04:20:50 | Foard, Texas, US | |
2051015 | 2051015 | 2022-05-25 | US | Texas | Kinney | 48271 | 742 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-05-26 04:20:50 | Kinney, Texas, US | |
625047 | 625047 | 2022-05-22 | US | Texas | Mason | 48319 | 793 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-05-26 04:20:50 | Mason, Texas, US | |
625054 | 625054 | 2022-05-22 | US | Texas | Menard | 48327 | 516 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-05-26 04:20:50 | Menard, Texas, US | |
625099 | 625099 | 2022-05-22 | US | Texas | Shackelford | 48417 | 694 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-05-26 04:20:50 | Shackelford, Texas, US | |
625108 | 625108 | 2022-05-22 | US | Texas | Sutton | 48435 | 848 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-05-26 04:20:50 | Sutton, Texas, US | |
2051036 | 2051036 | 2022-05-25 | US | Texas | Mason | 48319 | 793 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-05-26 04:20:50 | Mason, Texas, US | |
2051043 | 2051043 | 2022-05-25 | US | Texas | Menard | 48327 | 516 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-05-26 04:20:50 | Menard, Texas, US | |
2051088 | 2051088 | 2022-05-25 | US | Texas | Shackelford | 48417 | 694 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-05-26 04:20:50 | Shackelford, Texas, US | |
2051097 | 2051097 | 2022-05-25 | US | Texas | Sutton | 48435 | 848 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-05-26 04:20:50 | Sutton, Texas, US | |
625063 | 625063 | 2022-05-22 | US | Texas | Motley | 48345 | 286 | 13 | 0 | 34.07408766 | -100.779722 | 2022-05-26 04:20:50 | Motley, Texas, US | |
2051052 | 2051052 | 2022-05-25 | US | Texas | Motley | 48345 | 286 | 13 | 0 | 34.07408766 | -100.779722 | 2022-05-26 04:20:50 | Motley, Texas, US | |
624945 | 624945 | 2022-05-22 | US | Texas | Culberson | 48109 | 514 | 14 | 0 | 31.44506775 | -104.5185739 | 2022-05-26 04:20:50 | Culberson, Texas, US | |
625082 | 625082 | 2022-05-22 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-26 04:20:50 | Reagan, Texas, US | |
2050934 | 2050934 | 2022-05-25 | US | Texas | Culberson | 48109 | 514 | 14 | 0 | 31.44506775 | -104.5185739 | 2022-05-26 04:20:50 | Culberson, Texas, US | |
2051071 | 2051071 | 2022-05-25 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-26 04:20:50 | Reagan, Texas, US | |
625024 | 625024 | 2022-05-22 | US | Texas | Kimble | 48267 | 723 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-05-26 04:20:50 | Kimble, Texas, US | |
2051013 | 2051013 | 2022-05-25 | US | Texas | Kimble | 48267 | 723 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-05-26 04:20:50 | Kimble, Texas, US | |
624934 | 624934 | 2022-05-22 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-26 04:20:50 | Collingsworth, Texas, US | |
624953 | 624953 | 2022-05-22 | US | Texas | Dickens | 48125 | 453 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-05-26 04:20:50 | Dickens, Texas, US | |
625038 | 625038 | 2022-05-22 | US | Texas | Lipscomb | 48295 | 724 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-05-26 04:20:50 | Lipscomb, Texas, US | |
625101 | 625101 | 2022-05-22 | US | Texas | Sherman | 48421 | 499 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-05-26 04:20:50 | Sherman, Texas, US | |
2050923 | 2050923 | 2022-05-25 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-26 04:20:50 | Collingsworth, Texas, US | |
2050942 | 2050942 | 2022-05-25 | US | Texas | Dickens | 48125 | 453 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-05-26 04:20:50 | Dickens, Texas, US | |
2051027 | 2051027 | 2022-05-25 | US | Texas | Lipscomb | 48295 | 724 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-05-26 04:20:50 | Lipscomb, Texas, US | |
2051090 | 2051090 | 2022-05-25 | US | Texas | Sherman | 48421 | 499 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-05-26 04:20:50 | Sherman, Texas, US | |
625005 | 625005 | 2022-05-22 | US | Texas | Hudspeth | 48229 | 997 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-26 04:20:50 | Hudspeth, Texas, US | |
625122 | 625122 | 2022-05-22 | US | Texas | Upton | 48461 | 833 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-05-26 04:20:50 | Upton, Texas, US | |
2050994 | 2050994 | 2022-05-25 | US | Texas | Hudspeth | 48229 | 997 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-26 04:20:50 | Hudspeth, Texas, US | |
2051111 | 2051111 | 2022-05-25 | US | Texas | Upton | 48461 | 833 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-05-26 04:20:50 | Upton, Texas, US | |
624943 | 624943 | 2022-05-22 | US | Texas | Crockett | 48105 | 1087 | 19 | 0 | 30.72367027 | -101.4134238 | 2022-05-26 04:20:50 | Crockett, Texas, US | |
624989 | 624989 | 2022-05-22 | US | Texas | Hardeman | 48197 | 556 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-05-26 04:20:50 | Hardeman, Texas, US | |
2050932 | 2050932 | 2022-05-25 | US | Texas | Crockett | 48105 | 1087 | 19 | 0 | 30.72367027 | -101.4134238 | 2022-05-26 04:20:50 | Crockett, Texas, US | |
2050978 | 2050978 | 2022-05-25 | US | Texas | Hardeman | 48197 | 556 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-05-26 04:20:50 | Hardeman, Texas, US | |
624931 | 624931 | 2022-05-22 | US | Texas | Coke | 48081 | 844 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-05-26 04:20:50 | Coke, Texas, US | |
2050920 | 2050920 | 2022-05-25 | US | Texas | Coke | 48081 | 844 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-05-26 04:20:50 | Coke, Texas, US | |
625014 | 625014 | 2022-05-22 | US | Texas | Jim Hogg | 48247 | 2661 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-05-26 04:20:50 | Jim Hogg, Texas, US | |
2051003 | 2051003 | 2022-05-25 | US | Texas | Jim Hogg | 48247 | 2661 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-05-26 04:20:50 | Jim Hogg, Texas, US | |
624930 | 624930 | 2022-05-22 | US | Texas | Cochran | 48079 | 892 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-26 04:20:50 | Cochran, Texas, US | |
625133 | 625133 | 2022-05-22 | US | Texas | Wheeler | 48483 | 1193 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-05-26 04:20:50 | Wheeler, Texas, US | |
2050919 | 2050919 | 2022-05-25 | US | Texas | Cochran | 48079 | 892 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-26 04:20:50 | Cochran, Texas, US | |
2051122 | 2051122 | 2022-05-25 | US | Texas | Wheeler | 48483 | 1193 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-05-26 04:20:50 | Wheeler, Texas, US | |
624942 | 624942 | 2022-05-22 | US | Texas | Crane | 48103 | 1290 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-26 04:20:50 | Crane, Texas, US | |
624966 | 624966 | 2022-05-22 | US | Texas | Fisher | 48151 | 610 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-05-26 04:20:50 | Fisher, Texas, US | |
624986 | 624986 | 2022-05-22 | US | Texas | Hall | 48191 | 1102 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-05-26 04:20:50 | Hall, Texas, US | |
2050931 | 2050931 | 2022-05-25 | US | Texas | Crane | 48103 | 1290 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-26 04:20:50 | Crane, Texas, US | |
2050955 | 2050955 | 2022-05-25 | US | Texas | Fisher | 48151 | 610 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-05-26 04:20:50 | Fisher, Texas, US | |
2050975 | 2050975 | 2022-05-25 | US | Texas | Hall | 48191 | 1102 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-05-26 04:20:50 | Hall, Texas, US | |
624951 | 624951 | 2022-05-22 | US | Texas | Delta | 48119 | 1825 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-05-26 04:20:50 | Delta, Texas, US | |
625028 | 625028 | 2022-05-22 | US | Texas | Knox | 48275 | 492 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-05-26 04:20:50 | Knox, Texas, US | |
625083 | 625083 | 2022-05-22 | US | Texas | Real | 48385 | 818 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-05-26 04:20:50 | Real, Texas, US | |
2050940 | 2050940 | 2022-05-25 | US | Texas | Delta | 48119 | 1825 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-05-26 04:20:50 | Delta, 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]);