johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

255 rows where "last_update" is on date 2021-01-29 and province_or_state = "Texas" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Texas · 255 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2484971 2484971 2021-01-28 US Texas Anderson 48001 5455 86 0 5699 31.81534745 -95.65354823 2021-01-29 05:22:23 Anderson, Texas, US
2484972 2484972 2021-01-28 US Texas Andrews 48003 1332 40 0 1590 32.30468633 -102.6376548 2021-01-29 05:22:23 Andrews, Texas, US
2484973 2484973 2021-01-28 US Texas Angelina 48005 6006 213 0 6908 31.25457347 -94.60901487 2021-01-29 05:22:23 Angelina, Texas, US
2484974 2484974 2021-01-28 US Texas Aransas 48007 956 30 0 931 28.10556197 -96.9995047 2021-01-29 05:22:23 Aransas, Texas, US
2484975 2484975 2021-01-28 US Texas Archer 48009 767 10 0 733 33.61569967 -98.68754589 2021-01-29 05:22:23 Archer, Texas, US
2484976 2484976 2021-01-28 US Texas Armstrong 48011 210 6 0 133 34.96507426 -101.3574874 2021-01-29 05:22:23 Armstrong, Texas, US
2484977 2484977 2021-01-28 US Texas Atascosa 48013 4599 103 0 4274 28.89333001 -98.52730485 2021-01-29 05:22:23 Atascosa, Texas, US
2484978 2484978 2021-01-28 US Texas Austin 48015 1606 22 0 1513 29.88548725 -96.27736949 2021-01-29 05:22:23 Austin, Texas, US
2484979 2484979 2021-01-28 US Texas Bailey 48017 848 16 0 746 34.06854817 -102.8299707 2021-01-29 05:22:23 Bailey, Texas, US
2484980 2484980 2021-01-28 US Texas Bandera 48019 1067 21 0 937 29.74619598 -99.24598147 2021-01-29 05:22:23 Bandera, Texas, US
2484981 2484981 2021-01-28 US Texas Bastrop 48021 5504 62 0 4843 30.10370699 -97.31206354 2021-01-29 05:22:23 Bastrop, Texas, US
2484982 2484982 2021-01-28 US Texas Baylor 48023 265 11 0 273 33.61640794 -99.21352901 2021-01-29 05:22:23 Baylor, Texas, US
2484983 2484983 2021-01-28 US Texas Bee 48025 3894 56 0 3161 28.41761668 -97.74215593 2021-01-29 05:22:23 Bee, Texas, US
2484984 2484984 2021-01-28 US Texas Bell 48027 21112 248 0 17789 31.03736027 -97.4785025 2021-01-29 05:22:23 Bell, Texas, US
2484985 2484985 2021-01-28 US Texas Bexar 48029 168849 2262 0 163760 29.44928723 -98.52019748 2021-01-29 05:22:23 Bexar, Texas, US
2484986 2484986 2021-01-28 US Texas Blanco 48031 431 12 0 347 30.26640707 -98.3999852 2021-01-29 05:22:23 Blanco, Texas, US
2484987 2484987 2021-01-28 US Texas Borden 48033 34 0 0 17 32.74363984 -101.4316509 2021-01-29 05:22:23 Borden, Texas, US
2484988 2484988 2021-01-28 US Texas Bosque 48035 1302 24 0 1008 31.89978581 -97.63613524 2021-01-29 05:22:23 Bosque, Texas, US
2484989 2484989 2021-01-28 US Texas Bowie 48037 6312 154 0 5569 33.44626922 -94.41834132 2021-01-29 05:22:23 Bowie, Texas, US
2484990 2484990 2021-01-28 US Texas Brazoria 48039 29150 303 0 28011 29.18757369 -95.44563172 2021-01-29 05:22:23 Brazoria, Texas, US
2484991 2484991 2021-01-28 US Texas Brazos 48041 18275 175 0 18199 30.663644800000004 -96.30205577 2021-01-29 05:22:23 Brazos, Texas, US
2484992 2484992 2021-01-28 US Texas Brewster 48043 662 8 0 833 29.81008251 -103.2520326 2021-01-29 05:22:23 Brewster, Texas, US
2484993 2484993 2021-01-28 US Texas Briscoe 48045 167 4 0 116 34.53026962 -101.2084947 2021-01-29 05:22:23 Briscoe, Texas, US
2484994 2484994 2021-01-28 US Texas Brooks 48047 741 31 0 681 27.03103197 -98.21808402 2021-01-29 05:22:23 Brooks, Texas, US
2484995 2484995 2021-01-28 US Texas Brown 48049 3970 88 0 3641 31.77430356 -98.99907113 2021-01-29 05:22:23 Brown, Texas, US
2484996 2484996 2021-01-28 US Texas Burleson 48051 1582 24 0 1133 30.49273808 -96.62158484 2021-01-29 05:22:23 Burleson, Texas, US
2484997 2484997 2021-01-28 US Texas Burnet 48053 2821 41 0 2264 30.78801353 -98.181887 2021-01-29 05:22:23 Burnet, Texas, US
2484998 2484998 2021-01-28 US Texas Caldwell 48055 3325 64 0 2796 29.83668859 -97.61814775 2021-01-29 05:22:23 Caldwell, Texas, US
2484999 2484999 2021-01-28 US Texas Calhoun 48057 1610 13 0 1530 28.47048236 -96.61633945 2021-01-29 05:22:23 Calhoun, Texas, US
2485000 2485000 2021-01-28 US Texas Callahan 48059 1041 31 0 1019 32.29760619 -99.37326312 2021-01-29 05:22:23 Callahan, Texas, US
2485001 2485001 2021-01-28 US Texas Cameron 48061 38510 1296 0 34294 26.14524221 -97.48140372 2021-01-29 05:22:23 Cameron, Texas, US
2485002 2485002 2021-01-28 US Texas Camp 48063 1060 33 0 1010 32.97195142 -94.97790104 2021-01-29 05:22:23 Camp, Texas, US
2485003 2485003 2021-01-28 US Texas Carson 48065 616 12 0 334 35.40365929 -101.3542669 2021-01-29 05:22:23 Carson, Texas, US
2485004 2485004 2021-01-28 US Texas Cass 48067 1576 66 0 1534 33.07499881 -94.34646905 2021-01-29 05:22:23 Cass, Texas, US
2485005 2485005 2021-01-28 US Texas Castro 48069 1082 25 0 822 34.53016752 -102.2617243 2021-01-29 05:22:23 Castro, Texas, US
2485006 2485006 2021-01-28 US Texas Chambers 48071 2584 16 0 3705 29.70972016 -94.67154501 2021-01-29 05:22:23 Chambers, Texas, US
2485007 2485007 2021-01-28 US Texas Cherokee 48073 2921 103 0 3654 31.837258 -95.16559897 2021-01-29 05:22:23 Cherokee, Texas, US
2485008 2485008 2021-01-28 US Texas Childress 48075 1430 13 0 1297 34.529304100000004 -100.2077916 2021-01-29 05:22:23 Childress, Texas, US
2485009 2485009 2021-01-28 US Texas Clay 48077 972 13 0 926 33.78686685 -98.20771198 2021-01-29 05:22:23 Clay, Texas, US
2485010 2485010 2021-01-28 US Texas Cochran 48079 309 12 0 210 33.60425307 -102.8284499 2021-01-29 05:22:23 Cochran, Texas, US
2485011 2485011 2021-01-28 US Texas Coke 48081 362 11 0 424 31.88911733 -100.5297533 2021-01-29 05:22:23 Coke, Texas, US
2485012 2485012 2021-01-28 US Texas Coleman 48083 704 21 0 611 31.76736834 -99.45240766 2021-01-29 05:22:23 Coleman, Texas, US
2485013 2485013 2021-01-28 US Texas Collin 48085 68178 561 0 70618 33.18820114 -96.57264368 2021-01-29 05:22:23 Collin, Texas, US
2485014 2485014 2021-01-28 US Texas Collingsworth 48087 304 8 0 241 34.96489496 -100.2700111 2021-01-29 05:22:23 Collingsworth, Texas, US
2485015 2485015 2021-01-28 US Texas Colorado 48089 1368 21 0 1320 29.622098 -96.5273805 2021-01-29 05:22:23 Colorado, Texas, US
2485016 2485016 2021-01-28 US Texas Comal 48091 9229 216 0 7770 29.80811278 -98.27647225 2021-01-29 05:22:23 Comal, Texas, US
2485017 2485017 2021-01-28 US Texas Comanche 48093 1196 40 0 1100 31.94854689 -98.55876441 2021-01-29 05:22:23 Comanche, Texas, US
2485018 2485018 2021-01-28 US Texas Concho 48095 317 5 0 257 31.32635934 -99.86473038 2021-01-29 05:22:23 Concho, Texas, US
2485019 2485019 2021-01-28 US Texas Cooke 48097 3279 53 0 3058 33.63979567 -97.21240912 2021-01-29 05:22:23 Cooke, Texas, US
2485020 2485020 2021-01-28 US Texas Coryell 48099 5978 53 0 4406 31.39078397 -97.79936155 2021-01-29 05:22:23 Coryell, Texas, US
2485021 2485021 2021-01-28 US Texas Cottle 48101 176 7 0 172 34.07783319 -100.2785062 2021-01-29 05:22:23 Cottle, Texas, US
2485022 2485022 2021-01-28 US Texas Crane 48103 361 11 0 484 31.43052248 -102.5143314 2021-01-29 05:22:23 Crane, Texas, US
2485023 2485023 2021-01-28 US Texas Crockett 48105 360 15 0 489 30.72367027 -101.4134238 2021-01-29 05:22:23 Crockett, Texas, US
2485024 2485024 2021-01-28 US Texas Crosby 48107 726 24 0 404 33.61431553 -101.3000364 2021-01-29 05:22:23 Crosby, Texas, US
2485025 2485025 2021-01-28 US Texas Culberson 48109 295 7 0 314 31.44506775 -104.5185739 2021-01-29 05:22:23 Culberson, Texas, US
2485026 2485026 2021-01-28 US Texas Dallam 48111 943 20 0 535 36.27787176 -102.6020725 2021-01-29 05:22:23 Dallam, Texas, US
2485027 2485027 2021-01-28 US Texas Dallas 48113 228376 2748 0 250936 32.76670599 -96.7779605 2021-01-29 05:22:23 Dallas, Texas, US
2485028 2485028 2021-01-28 US Texas Dawson 48115 1315 65 0 1605 32.74255572 -101.9477242 2021-01-29 05:22:23 Dawson, Texas, US
2485029 2485029 2021-01-28 US Texas DeWitt 48123 3732 53 0 1629 29.08101855 -97.3568117 2021-01-29 05:22:23 DeWitt, Texas, US
2485030 2485030 2021-01-28 US Texas Deaf Smith 48117 2320 61 0 2415 34.96522957 -102.6054267 2021-01-29 05:22:23 Deaf Smith, Texas, US
2485031 2485031 2021-01-28 US Texas Delta 48119 880 6 0 239 33.38570922 -95.66921122 2021-01-29 05:22:23 Delta, Texas, US
2485032 2485032 2021-01-28 US Texas Denton 48121 48502 498 0 52096 33.20521901 -97.11691153 2021-01-29 05:22:23 Denton, Texas, US
2485033 2485033 2021-01-28 US Texas Dickens 48125 178 7 0 130 33.61616822 -100.7788855 2021-01-29 05:22:23 Dickens, Texas, US
2485034 2485034 2021-01-28 US Texas Dimmit 48127 1251 18 0 1136 28.42270064 -99.75645095 2021-01-29 05:22:23 Dimmit, Texas, US
2485035 2485035 2021-01-28 US Texas Donley 48129 418 11 0 315 34.96517499 -100.8140093 2021-01-29 05:22:23 Donley, Texas, US
2485036 2485036 2021-01-28 US Texas Duval 48131 1140 34 0 1073 27.68184592 -98.50864568 2021-01-29 05:22:23 Duval, Texas, US
2485037 2485037 2021-01-28 US Texas Eastland 48133 1037 28 0 1033 32.32743996 -98.83243566 2021-01-29 05:22:23 Eastland, Texas, US
2485038 2485038 2021-01-28 US Texas Ector 48135 13259 293 0 13139 31.86898877 -102.5429428 2021-01-29 05:22:23 Ector, Texas, US
2485039 2485039 2021-01-28 US Texas Edwards 48137 239 4 0 220 29.98202582 -100.304252 2021-01-29 05:22:23 Edwards, Texas, US
2485040 2485040 2021-01-28 US Texas El Paso 48141 91978 2086 0 110173 31.76980765 -106.2363275 2021-01-29 05:22:23 El Paso, Texas, US
2485041 2485041 2021-01-28 US Texas Ellis 48139 18035 229 0 18084 32.34894117 -96.79371841 2021-01-29 05:22:23 Ellis, Texas, US
2485042 2485042 2021-01-28 US Texas Erath 48143 3404 52 0 3602 32.23602653 -98.21773417 2021-01-29 05:22:23 Erath, Texas, US
2485043 2485043 2021-01-28 US Texas Falls 48145 1625 25 0 1343 31.25350609 -96.93630086 2021-01-29 05:22:23 Falls, Texas, US
2485044 2485044 2021-01-28 US Texas Fannin 48147 2924 77 0 2718 33.59564294 -96.10751083 2021-01-29 05:22:23 Fannin, Texas, US
2485045 2485045 2021-01-28 US Texas Fayette 48149 1631 48 0 1516 29.87788372 -96.92076062 2021-01-29 05:22:23 Fayette, Texas, US
2485046 2485046 2021-01-28 US Texas Fisher 48151 305 12 0 269 32.74281316 -100.4019302 2021-01-29 05:22:23 Fisher, Texas, US
2485047 2485047 2021-01-28 US Texas Floyd 48153 907 28 0 657 34.07227468 -101.3031546 2021-01-29 05:22:23 Floyd, Texas, US
2485048 2485048 2021-01-28 US Texas Foard 48155 73 6 0 90 33.97308618 -99.7767797 2021-01-29 05:22:23 Foard, Texas, US
2485049 2485049 2021-01-28 US Texas Fort Bend 48157 50744 474 0 49055 29.52704478 -95.77219463 2021-01-29 05:22:23 Fort Bend, Texas, US
2485050 2485050 2021-01-28 US Texas Franklin 48159 720 19 0 583 33.17653242 -95.21917243 2021-01-29 05:22:23 Franklin, Texas, US
2485051 2485051 2021-01-28 US Texas Freestone 48161 1246 33 0 983 31.70422788 -96.15072516 2021-01-29 05:22:23 Freestone, Texas, US
2485052 2485052 2021-01-28 US Texas Frio 48163 2229 29 0 2301 28.86751206 -99.10804207 2021-01-29 05:22:23 Frio, Texas, US
2485053 2485053 2021-01-28 US Texas Gaines 48165 601 36 0 1343 32.74055318 -102.6353295 2021-01-29 05:22:23 Gaines, Texas, US
2485054 2485054 2021-01-28 US Texas Galveston 48167 27898 280 0 29433 29.40167322 -94.90469073 2021-01-29 05:22:23 Galveston, Texas, US
2485055 2485055 2021-01-28 US Texas Garza 48169 491 18 0 282 33.17969345 -101.2984114 2021-01-29 05:22:23 Garza, Texas, US
2485056 2485056 2021-01-28 US Texas Gillespie 48171 2295 41 0 2062 30.31824095 -98.94676915 2021-01-29 05:22:23 Gillespie, Texas, US
2485057 2485057 2021-01-28 US Texas Glasscock 48173 95 2 0 102 31.86942909 -101.5207776 2021-01-29 05:22:23 Glasscock, Texas, US
2485058 2485058 2021-01-28 US Texas Goliad 48175 446 9 0 353 28.65696592 -97.42760647 2021-01-29 05:22:23 Goliad, Texas, US
2485059 2485059 2021-01-28 US Texas Gonzales 48177 2261 35 0 2200 29.45634206 -97.49424032 2021-01-29 05:22:23 Gonzales, Texas, US
2485060 2485060 2021-01-28 US Texas Gray 48179 2475 46 0 1803 35.40081878 -100.8129222 2021-01-29 05:22:23 Gray, Texas, US
2485061 2485061 2021-01-28 US Texas Grayson 48181 10781 254 0 9340 33.62744998 -96.67753461 2021-01-29 05:22:23 Grayson, Texas, US
2485062 2485062 2021-01-28 US Texas Gregg 48183 7561 253 0 9195 32.47940482 -94.81591935 2021-01-29 05:22:23 Gregg, Texas, US
2485063 2485063 2021-01-28 US Texas Grimes 48185 2585 55 0 1881 30.54579585 -95.98902499 2021-01-29 05:22:23 Grimes, Texas, US
2485064 2485064 2021-01-28 US Texas Guadalupe 48187 11135 147 0 10470 29.58165339 -97.94786822 2021-01-29 05:22:23 Guadalupe, Texas, US
2485065 2485065 2021-01-28 US Texas Hale 48189 2271 144 0 5681 34.07044901 -101.8268114 2021-01-29 05:22:23 Hale, Texas, US
2485066 2485066 2021-01-28 US Texas Hall 48191 532 13 0 366 34.5307555 -100.6813852 2021-01-29 05:22:23 Hall, Texas, US
2485067 2485067 2021-01-28 US Texas Hamilton 48193 624 23 0 568 31.70470573 -98.11083887 2021-01-29 05:22:23 Hamilton, Texas, US
2485068 2485068 2021-01-28 US Texas Hansford 48195 911 18 0 701 36.27743284 -101.3545796 2021-01-29 05:22:23 Hansford, Texas, US
2485069 2485069 2021-01-28 US Texas Hardeman 48197 323 12 0 319 34.28944521 -99.74632408 2021-01-29 05:22:23 Hardeman, Texas, US
2485070 2485070 2021-01-28 US Texas Hardin 48199 3472 77 0 4141 30.33364686 -94.38931817 2021-01-29 05:22:23 Hardin, Texas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);