⚠️ 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

84,661 rows where province_or_state = "Texas" sorted by day descending

View and edit SQL

province_or_state

  • Texas · 84,661

country_or_region

  • US 84,661
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
907428 2021-03-03 US Texas Anderson 48001 6063 107 0 5956 31.81534745 -95.65354823 2021-03-04 05:24:24 Anderson, Texas, US
907429 2021-03-03 US Texas Andrews 48003 1694 46 0 1648 32.30468633 -102.6376548 2021-03-04 05:24:24 Andrews, Texas, US
907430 2021-03-03 US Texas Angelina 48005 7984 260 0 7724 31.25457347 -94.60901487 2021-03-04 05:24:24 Angelina, Texas, US
907431 2021-03-03 US Texas Aransas 48007 1140 35 0 1105 28.10556197 -96.9995047 2021-03-04 05:24:24 Aransas, Texas, US
907432 2021-03-03 US Texas Archer 48009 773 11 0 762 33.61569967 -98.68754589 2021-03-04 05:24:24 Archer, Texas, US
907433 2021-03-03 US Texas Armstrong 48011 149 6 0 143 34.96507426 -101.3574874 2021-03-04 05:24:24 Armstrong, Texas, US
907434 2021-03-03 US Texas Atascosa 48013 5395 139 0 5256 28.89333001 -98.52730485 2021-03-04 05:24:24 Atascosa, Texas, US
907435 2021-03-03 US Texas Austin 48015 1842 30 0 1812 29.88548725 -96.27736949 2021-03-04 05:24:24 Austin, Texas, US
907436 2021-03-03 US Texas Bailey 48017 793 17 0 776 34.06854817 -102.8299707 2021-03-04 05:24:24 Bailey, Texas, US
907437 2021-03-03 US Texas Bandera 48019 1272 24 0 1248 29.74619598 -99.24598147 2021-03-04 05:24:24 Bandera, Texas, US
907438 2021-03-03 US Texas Bastrop 48021 8459 80 0 8379 30.10370699 -97.31206354 2021-03-04 05:24:24 Bastrop, Texas, US
907439 2021-03-03 US Texas Baylor 48023 291 11 0 280 33.61640794 -99.21352901 2021-03-04 05:24:24 Baylor, Texas, US
907440 2021-03-03 US Texas Bee 48025 3398 64 0 3334 28.41761668 -97.74215593 2021-03-04 05:24:24 Bee, Texas, US
907441 2021-03-03 US Texas Bell 48027 20668 360 0 20308 31.03736027 -97.4785025 2021-03-04 05:24:24 Bell, Texas, US
907442 2021-03-03 US Texas Bexar 48029 197255 2953 0 194302 29.44928723 -98.52019748 2021-03-04 05:24:24 Bexar, Texas, US
907443 2021-03-03 US Texas Blanco 48031 684 18 0 666 30.26640707 -98.3999852 2021-03-04 05:24:24 Blanco, Texas, US
907444 2021-03-03 US Texas Borden 48033 21 2 0 19 32.74363984 -101.4316509 2021-03-04 05:24:24 Borden, Texas, US
907445 2021-03-03 US Texas Bosque 48035 1597 31 0 1566 31.89978581 -97.63613524 2021-03-04 05:24:24 Bosque, Texas, US
907446 2021-03-03 US Texas Bowie 48037 6582 183 0 6399 33.44626922 -94.41834132 2021-03-04 05:24:24 Bowie, Texas, US
907447 2021-03-03 US Texas Brazoria 48039 33152 387 0 32765 29.18757369 -95.44563172 2021-03-04 05:24:24 Brazoria, Texas, US
907448 2021-03-03 US Texas Brazos 48041 21243 215 0 21028 30.663644800000004 -96.30205577 2021-03-04 05:24:24 Brazos, Texas, US
907449 2021-03-03 US Texas Brewster 48043 890 11 0 879 29.81008251 -103.2520326 2021-03-04 05:24:24 Brewster, Texas, US
907450 2021-03-03 US Texas Briscoe 48045 137 4 0 133 34.53026962 -101.2084947 2021-03-04 05:24:24 Briscoe, Texas, US
907451 2021-03-03 US Texas Brooks 48047 758 32 0 726 27.03103197 -98.21808402 2021-03-04 05:24:24 Brooks, Texas, US
907452 2021-03-03 US Texas Brown 48049 4125 115 0 4010 31.77430356 -98.99907113 2021-03-04 05:24:24 Brown, Texas, US
907453 2021-03-03 US Texas Burleson 48051 2211 36 0 2175 30.49273808 -96.62158484 2021-03-04 05:24:24 Burleson, Texas, US
907454 2021-03-03 US Texas Burnet 48053 4239 59 0 4180 30.78801353 -98.181887 2021-03-04 05:24:24 Burnet, Texas, US
907455 2021-03-03 US Texas Caldwell 48055 5212 87 0 5125 29.83668859 -97.61814775 2021-03-04 05:24:24 Caldwell, Texas, US
907456 2021-03-03 US Texas Calhoun 48057 2029 20 0 2009 28.47048236 -96.61633945 2021-03-04 05:24:24 Calhoun, Texas, US
907457 2021-03-03 US Texas Callahan 48059 1145 38 0 1107 32.29760619 -99.37326312 2021-03-04 05:24:24 Callahan, Texas, US
907458 2021-03-03 US Texas Cameron 48061 37454 1498 0 35956 26.14524221 -97.48140372 2021-03-04 05:24:24 Cameron, Texas, US
907459 2021-03-03 US Texas Camp 48063 1186 41 0 1145 32.97195142 -94.97790104 2021-03-04 05:24:24 Camp, Texas, US
907460 2021-03-03 US Texas Carson 48065 397 14 0 383 35.40365929 -101.3542669 2021-03-04 05:24:24 Carson, Texas, US
907461 2021-03-03 US Texas Cass 48067 1789 78 0 1711 33.07499881 -94.34646905 2021-03-04 05:24:24 Cass, Texas, US
907462 2021-03-03 US Texas Castro 48069 899 29 0 870 34.53016752 -102.2617243 2021-03-04 05:24:24 Castro, Texas, US
907463 2021-03-03 US Texas Chambers 48071 4279 22 0 4257 29.70972016 -94.67154501 2021-03-04 05:24:24 Chambers, Texas, US
907464 2021-03-03 US Texas Cherokee 48073 4036 123 0 3913 31.837258 -95.16559897 2021-03-04 05:24:24 Cherokee, Texas, US
907465 2021-03-03 US Texas Childress 48075 1333 17 0 1316 34.529304100000004 -100.2077916 2021-03-04 05:24:24 Childress, Texas, US
907466 2021-03-03 US Texas Clay 48077 1001 16 0 985 33.78686685 -98.20771198 2021-03-04 05:24:24 Clay, Texas, US
907467 2021-03-03 US Texas Cochran 48079 250 14 0 236 33.60425307 -102.8284499 2021-03-04 05:24:24 Cochran, Texas, US
907468 2021-03-03 US Texas Coke 48081 468 11 0 457 31.88911733 -100.5297533 2021-03-04 05:24:24 Coke, Texas, US
907469 2021-03-03 US Texas Coleman 48083 709 30 0 679 31.76736834 -99.45240766 2021-03-04 05:24:24 Coleman, Texas, US
907470 2021-03-03 US Texas Collin 48085 83404 732 0 82672 33.18820114 -96.57264368 2021-03-04 05:24:24 Collin, Texas, US
907471 2021-03-03 US Texas Collingsworth 48087 259 9 0 250 34.96489496 -100.2700111 2021-03-04 05:24:24 Collingsworth, Texas, US
907472 2021-03-03 US Texas Colorado 48089 1548 25 0 1523 29.622098 -96.5273805 2021-03-04 05:24:24 Colorado, Texas, US
907473 2021-03-03 US Texas Comal 48091 9201 267 0 8934 29.80811278 -98.27647225 2021-03-04 05:24:24 Comal, Texas, US
907474 2021-03-03 US Texas Comanche 48093 1486 51 0 1435 31.94854689 -98.55876441 2021-03-04 05:24:24 Comanche, Texas, US
907475 2021-03-03 US Texas Concho 48095 319 8 0 311 31.32635934 -99.86473038 2021-03-04 05:24:24 Concho, Texas, US
907476 2021-03-03 US Texas Cooke 48097 3469 64 0 3405 33.63979567 -97.21240912 2021-03-04 05:24:24 Cooke, Texas, US
907477 2021-03-03 US Texas Coryell 48099 6836 77 0 6759 31.39078397 -97.79936155 2021-03-04 05:24:24 Coryell, Texas, US
907478 2021-03-03 US Texas Cottle 48101 186 7 0 179 34.07783319 -100.2785062 2021-03-04 05:24:24 Cottle, Texas, US
907479 2021-03-03 US Texas Crane 48103 512 12 0 500 31.43052248 -102.5143314 2021-03-04 05:24:24 Crane, Texas, US
907480 2021-03-03 US Texas Crockett 48105 571 15 0 556 30.72367027 -101.4134238 2021-03-04 05:24:24 Crockett, Texas, US
907481 2021-03-03 US Texas Crosby 48107 518 28 0 490 33.61431553 -101.3000364 2021-03-04 05:24:24 Crosby, Texas, US
907482 2021-03-03 US Texas Culberson 48109 346 7 0 339 31.44506775 -104.5185739 2021-03-04 05:24:24 Culberson, Texas, US
907483 2021-03-03 US Texas Dallam 48111 751 22 0 729 36.27787176 -102.6020725 2021-03-04 05:24:24 Dallam, Texas, US
907484 2021-03-03 US Texas Dallas 48113 282399 3477 0 278922 32.76670599 -96.7779605 2021-03-04 05:24:24 Dallas, Texas, US
907485 2021-03-03 US Texas Dawson 48115 1710 68 0 1642 32.74255572 -101.9477242 2021-03-04 05:24:24 Dawson, Texas, US
907486 2021-03-03 US Texas DeWitt 48123 1856 57 0 1799 29.08101855 -97.3568117 2021-03-04 05:24:24 DeWitt, Texas, US
907487 2021-03-03 US Texas Deaf Smith 48117 2625 64 0 2561 34.96522957 -102.6054267 2021-03-04 05:24:24 Deaf Smith, Texas, US
907488 2021-03-03 US Texas Delta 48119 297 10 0 287 33.38570922 -95.66921122 2021-03-04 05:24:24 Delta, Texas, US
907489 2021-03-03 US Texas Denton 48121 65821 654 0 65167 33.20521901 -97.11691153 2021-03-04 05:24:24 Denton, Texas, US
907490 2021-03-03 US Texas Dickens 48125 156 10 0 146 33.61616822 -100.7788855 2021-03-04 05:24:24 Dickens, Texas, US
907491 2021-03-03 US Texas Dimmit 48127 1533 22 0 1511 28.42270064 -99.75645095 2021-03-04 05:24:24 Dimmit, Texas, US
907492 2021-03-03 US Texas Donley 48129 346 14 0 332 34.96517499 -100.8140093 2021-03-04 05:24:24 Donley, Texas, US
907493 2021-03-03 US Texas Duval 48131 1160 39 0 1121 27.68184592 -98.50864568 2021-03-04 05:24:24 Duval, Texas, US
907494 2021-03-03 US Texas Eastland 48133 1296 42 0 1254 32.32743996 -98.83243566 2021-03-04 05:24:24 Eastland, Texas, US
907495 2021-03-03 US Texas Ector 48135 16373 336 0 16037 31.86898877 -102.5429428 2021-03-04 05:24:24 Ector, Texas, US
907496 2021-03-03 US Texas Edwards 48137 243 4 0 239 29.98202582 -100.304252 2021-03-04 05:24:24 Edwards, Texas, US
907497 2021-03-03 US Texas El Paso 48141 124438 2366 0 122072 31.76980765 -106.2363275 2021-03-04 05:24:24 El Paso, Texas, US
907498 2021-03-03 US Texas Ellis 48139 20936 280 0 20656 32.34894117 -96.79371841 2021-03-04 05:24:24 Ellis, Texas, US
907499 2021-03-03 US Texas Erath 48143 3975 67 0 3908 32.23602653 -98.21773417 2021-03-04 05:24:24 Erath, Texas, US
907500 2021-03-03 US Texas Falls 48145 1993 29 0 1964 31.25350609 -96.93630086 2021-03-04 05:24:24 Falls, Texas, US
907501 2021-03-03 US Texas Fannin 48147 3224 101 0 3123 33.59564294 -96.10751083 2021-03-04 05:24:24 Fannin, Texas, US
907502 2021-03-03 US Texas Fayette 48149 2285 53 0 2232 29.87788372 -96.92076062 2021-03-04 05:24:24 Fayette, Texas, US
907503 2021-03-03 US Texas Fisher 48151 290 14 0 276 32.74281316 -100.4019302 2021-03-04 05:24:24 Fisher, Texas, US
907504 2021-03-03 US Texas Floyd 48153 765 29 0 736 34.07227468 -101.3031546 2021-03-04 05:24:24 Floyd, Texas, US
907505 2021-03-03 US Texas Foard 48155 119 8 0 111 33.97308618 -99.7767797 2021-03-04 05:24:24 Foard, Texas, US
907506 2021-03-03 US Texas Fort Bend 48157 58663 569 0 58094 29.52704478 -95.77219463 2021-03-04 05:24:24 Fort Bend, Texas, US
907507 2021-03-03 US Texas Franklin 48159 697 25 0 672 33.17653242 -95.21917243 2021-03-04 05:24:24 Franklin, Texas, US
907508 2021-03-03 US Texas Freestone 48161 1752 45 0 1707 31.70422788 -96.15072516 2021-03-04 05:24:24 Freestone, Texas, US
907509 2021-03-03 US Texas Frio 48163 2665 42 0 2623 28.86751206 -99.10804207 2021-03-04 05:24:24 Frio, Texas, US
907510 2021-03-03 US Texas Gaines 48165 1412 41 0 1371 32.74055318 -102.6353295 2021-03-04 05:24:24 Gaines, Texas, US
907511 2021-03-03 US Texas Galveston 48167 34896 347 0 34549 29.40167322 -94.90469073 2021-03-04 05:24:24 Galveston, Texas, US
907512 2021-03-03 US Texas Garza 48169 369 20 0 349 33.17969345 -101.2984114 2021-03-04 05:24:24 Garza, Texas, US
907513 2021-03-03 US Texas Gillespie 48171 2452 48 0 2404 30.31824095 -98.94676915 2021-03-04 05:24:24 Gillespie, Texas, US
907514 2021-03-03 US Texas Glasscock 48173 97 2 0 95 31.86942909 -101.5207776 2021-03-04 05:24:24 Glasscock, Texas, US
907515 2021-03-03 US Texas Goliad 48175 438 13 0 425 28.65696592 -97.42760647 2021-03-04 05:24:24 Goliad, Texas, US
907516 2021-03-03 US Texas Gonzales 48177 2616 51 0 2565 29.45634206 -97.49424032 2021-03-04 05:24:24 Gonzales, Texas, US
907517 2021-03-03 US Texas Gray 48179 1992 53 0 1939 35.40081878 -100.8129222 2021-03-04 05:24:24 Gray, Texas, US
907518 2021-03-03 US Texas Grayson 48181 10850 316 0 10534 33.62744998 -96.67753461 2021-03-04 05:24:24 Grayson, Texas, US
907519 2021-03-03 US Texas Gregg 48183 10693 313 0 10380 32.47940482 -94.81591935 2021-03-04 05:24:24 Gregg, Texas, US
907520 2021-03-03 US Texas Grimes 48185 3439 62 0 3377 30.54579585 -95.98902499 2021-03-04 05:24:24 Grimes, Texas, US
907521 2021-03-03 US Texas Guadalupe 48187 13423 191 0 13232 29.58165339 -97.94786822 2021-03-04 05:24:24 Guadalupe, Texas, US
907522 2021-03-03 US Texas Hale 48189 6043 152 0 5891 34.07044901 -101.8268114 2021-03-04 05:24:24 Hale, Texas, US
907523 2021-03-03 US Texas Hall 48191 421 14 0 407 34.5307555 -100.6813852 2021-03-04 05:24:24 Hall, Texas, US
907524 2021-03-03 US Texas Hamilton 48193 743 25 0 718 31.70470573 -98.11083887 2021-03-04 05:24:24 Hamilton, Texas, US
907525 2021-03-03 US Texas Hansford 48195 816 21 0 795 36.27743284 -101.3545796 2021-03-04 05:24:24 Hansford, Texas, US
907526 2021-03-03 US Texas Hardeman 48197 366 12 0 354 34.28944521 -99.74632408 2021-03-04 05:24:24 Hardeman, Texas, US
907527 2021-03-03 US Texas Hardin 48199 4885 95 0 4790 30.33364686 -94.38931817 2021-03-04 05:24:24 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] INTEGER,
   [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]);