johns_hopkins_csse_daily_reports

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

31,876 rows where province_or_state = "Texas" sorted by day descending

View and edit SQL

province_or_state

  • Texas · 31,876

country_or_region

  • US 31,876
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391151 2020-08-08 US Texas Anderson 48001 2402 12 0 2390 31.81534745 -95.65354823 2020-08-09 04:34:54 Anderson, Texas, US
391153 2020-08-08 US Texas Andrews 48003 297 7 0 290 32.30468633 -102.63765479999999 2020-08-09 04:34:54 Andrews, Texas, US
391155 2020-08-08 US Texas Angelina 48005 1796 45 0 1751 31.25457347 -94.60901487 2020-08-09 04:34:54 Angelina, Texas, US
391165 2020-08-08 US Texas Aransas 48007 172 13 0 159 28.10556197 -96.9995047 2020-08-09 04:34:54 Aransas, Texas, US
391167 2020-08-08 US Texas Archer 48009 21 0 0 21 33.61569967 -98.68754589 2020-08-09 04:34:54 Archer, Texas, US
391174 2020-08-08 US Texas Armstrong 48011 8 0 0 8 34.96507426 -101.35748740000001 2020-08-09 04:34:54 Armstrong, Texas, US
391186 2020-08-08 US Texas Atascosa 48013 437 18 0 419 28.89333001 -98.52730485 2020-08-09 04:34:54 Atascosa, Texas, US
391199 2020-08-08 US Texas Austin 48015 230 3 0 227 29.88548725 -96.27736949 2020-08-09 04:34:54 Austin, Texas, US
391205 2020-08-08 US Texas Bailey 48017 171 4 0 167 34.06854817 -102.8299707 2020-08-09 04:34:54 Bailey, Texas, US
391215 2020-08-08 US Texas Bandera 48019 91 3 0 88 29.74619598 -99.24598147 2020-08-09 04:34:54 Bandera, Texas, US
391237 2020-08-08 US Texas Bastrop 48021 1358 21 0 1337 30.10370699 -97.31206354 2020-08-09 04:34:54 Bastrop, Texas, US
391246 2020-08-08 US Texas Baylor 48023 11 0 0 11 33.61640794 -99.21352901 2020-08-09 04:34:54 Baylor, Texas, US
391261 2020-08-08 US Texas Bee 48025 1073 9 0 1064 28.41761668 -97.74215593 2020-08-09 04:34:54 Bee, Texas, US
391264 2020-08-08 US Texas Bell 48027 3831 37 0 3794 31.03736027 -97.4785025 2020-08-09 04:34:54 Bell, Texas, US
391293 2020-08-08 US Texas Bexar 48029 42531 773 0 41758 29.44928723 -98.52019748 2020-08-09 04:34:54 Bexar, Texas, US
391310 2020-08-08 US Texas Blanco 48031 98 5 0 93 30.26640707 -98.3999852 2020-08-09 04:34:54 Blanco, Texas, US
391332 2020-08-08 US Texas Borden 48033 0 0 0 0 32.74363984 -101.43165090000001 2020-08-09 04:34:54 Borden, Texas, US
391333 2020-08-08 US Texas Bosque 48035 161 2 0 159 31.89978581 -97.63613524 2020-08-09 04:34:54 Bosque, Texas, US
391341 2020-08-08 US Texas Bowie 48037 764 32 0 732 33.44626922 -94.41834132 2020-08-09 04:34:54 Bowie, Texas, US
391355 2020-08-08 US Texas Brazoria 48039 7215 92 0 7123 29.18757369 -95.44563172 2020-08-09 04:34:54 Brazoria, Texas, US
391356 2020-08-08 US Texas Brazos 48041 4040 48 0 3992 30.663644800000004 -96.30205577 2020-08-09 04:34:54 Brazos, Texas, US
391361 2020-08-08 US Texas Brewster 48043 188 2 0 186 29.81008251 -103.25203259999999 2020-08-09 04:34:54 Brewster, Texas, US
391362 2020-08-08 US Texas Briscoe 48045 12 1 0 11 34.53026962 -101.2084947 2020-08-09 04:34:54 Briscoe, Texas, US
391371 2020-08-08 US Texas Brooks 48047 99 3 0 96 27.03103197 -98.21808402 2020-08-09 04:34:54 Brooks, Texas, US
391382 2020-08-08 US Texas Brown 48049 391 16 0 375 31.77430356 -98.99907113 2020-08-09 04:34:54 Brown, Texas, US
391408 2020-08-08 US Texas Burleson 48051 240 6 0 234 30.49273808 -96.62158484 2020-08-09 04:34:54 Burleson, Texas, US
391410 2020-08-08 US Texas Burnet 48053 552 9 0 543 30.78801353 -98.181887 2020-08-09 04:34:54 Burnet, Texas, US
391436 2020-08-08 US Texas Caldwell 48055 1136 26 0 1110 29.83668859 -97.61814775 2020-08-09 04:34:54 Caldwell, Texas, US
391447 2020-08-08 US Texas Calhoun 48057 544 4 0 540 28.47048236 -96.61633945 2020-08-09 04:34:54 Calhoun, Texas, US
391449 2020-08-08 US Texas Callahan 48059 46 3 0 43 32.29760619 -99.37326312 2020-08-09 04:34:54 Callahan, Texas, US
391462 2020-08-08 US Texas Cameron 48061 16290 425 0 15865 26.14524221 -97.48140372 2020-08-09 04:34:54 Cameron, Texas, US
391463 2020-08-08 US Texas Camp 48063 233 5 0 228 32.97195142 -94.97790104 2020-08-09 04:34:54 Camp, Texas, US
391499 2020-08-08 US Texas Carson 48065 15 0 0 15 35.40365929 -101.35426690000001 2020-08-09 04:34:54 Carson, Texas, US
391517 2020-08-08 US Texas Cass 48067 174 8 0 166 33.07499881 -94.34646905 2020-08-09 04:34:54 Cass, Texas, US
391519 2020-08-08 US Texas Castro 48069 200 4 0 196 34.53016752 -102.2617243 2020-08-09 04:34:54 Castro, Texas, US
391540 2020-08-08 US Texas Chambers 48071 951 3 0 948 29.70972016 -94.67154501 2020-08-09 04:34:54 Chambers, Texas, US
391574 2020-08-08 US Texas Cherokee 48073 1107 7 0 1100 31.837258000000002 -95.16559897 2020-08-09 04:34:54 Cherokee, Texas, US
391589 2020-08-08 US Texas Childress 48075 40 0 0 40 34.529304100000004 -100.2077916 2020-08-09 04:34:54 Childress, Texas, US
391652 2020-08-08 US Texas Clay 48077 40 1 0 39 33.78686685 -98.20771198 2020-08-09 04:34:54 Clay, Texas, US
391682 2020-08-08 US Texas Cochran 48079 32 0 0 32 33.60425307 -102.82844990000001 2020-08-09 04:34:54 Cochran, Texas, US
391690 2020-08-08 US Texas Coke 48081 42 2 0 40 31.88911733 -100.5297533 2020-08-09 04:34:54 Coke, Texas, US
391693 2020-08-08 US Texas Coleman 48083 19 0 0 19 31.76736834 -99.45240766 2020-08-09 04:34:54 Coleman, Texas, US
391699 2020-08-08 US Texas Collin 48085 7439 89 0 7350 33.18820114 -96.57264368 2020-08-09 04:34:54 Collin, Texas, US
391700 2020-08-08 US Texas Collingsworth 48087 11 0 0 11 34.96489496 -100.27001109999999 2020-08-09 04:34:54 Collingsworth, Texas, US
391702 2020-08-08 US Texas Colorado 48089 278 2 0 276 29.622097999999998 -96.5273805 2020-08-09 04:34:54 Colorado, Texas, US
391715 2020-08-08 US Texas Comal 48091 1816 69 0 1747 29.80811278 -98.27647225 2020-08-09 04:34:54 Comal, Texas, US
391718 2020-08-08 US Texas Comanche 48093 142 3 0 139 31.94854689 -98.55876441 2020-08-09 04:34:54 Comanche, Texas, US
391720 2020-08-08 US Texas Concho 48095 28 0 0 28 31.32635934 -99.86473038 2020-08-09 04:34:54 Concho, Texas, US
391730 2020-08-08 US Texas Cooke 48097 223 3 0 220 33.63979567 -97.21240912 2020-08-09 04:34:54 Cooke, Texas, US
391739 2020-08-08 US Texas Coryell 48099 667 5 0 662 31.39078397 -97.79936155 2020-08-09 04:34:54 Coryell, Texas, US
391742 2020-08-08 US Texas Cottle 48101 18 2 0 16 34.07783319 -100.27850620000001 2020-08-09 04:34:54 Cottle, Texas, US
391754 2020-08-08 US Texas Crane 48103 70 2 0 68 31.43052248 -102.5143314 2020-08-09 04:34:54 Crane, Texas, US
391773 2020-08-08 US Texas Crockett 48105 155 3 0 152 30.72367027 -101.4134238 2020-08-09 04:34:54 Crockett, Texas, US
391776 2020-08-08 US Texas Crosby 48107 63 1 0 62 33.61431553 -101.30003640000001 2020-08-09 04:34:54 Crosby, Texas, US
391780 2020-08-08 US Texas Culberson 48109 17 2 0 15 31.44506775 -104.5185739 2020-08-09 04:34:54 Culberson, Texas, US
391808 2020-08-08 US Texas Dallam 48111 190 5 0 185 36.27787176 -102.60207249999999 2020-08-09 04:34:54 Dallam, Texas, US
391813 2020-08-08 US Texas Dallas 48113 53831 751 0 53080 32.76670599 -96.77796049999999 2020-08-09 04:34:54 Dallas, Texas, US
391834 2020-08-08 US Texas Dawson 48115 145 4 0 141 32.74255572 -101.94772420000001 2020-08-09 04:34:54 Dawson, Texas, US
391847 2020-08-08 US Texas DeWitt 48123 693 18 0 675 29.08101855 -97.35681170000001 2020-08-09 04:34:54 DeWitt, Texas, US
391848 2020-08-08 US Texas Deaf Smith 48117 667 17 0 650 34.96522957 -102.6054267 2020-08-09 04:34:54 Deaf Smith, Texas, US
391866 2020-08-08 US Texas Delta 48119 16 0 0 16 33.38570922 -95.66921122 2020-08-09 04:34:54 Delta, Texas, US
391869 2020-08-08 US Texas Denton 48121 7586 87 0 7499 33.20521901 -97.11691153 2020-08-09 04:34:54 Denton, Texas, US
391878 2020-08-08 US Texas Dickens 48125 5 1 0 4 33.61616822 -100.7788855 2020-08-09 04:34:54 Dickens, Texas, US
391887 2020-08-08 US Texas Dimmit 48127 150 3 0 147 28.42270064 -99.75645095 2020-08-09 04:34:54 Dimmit, Texas, US
391901 2020-08-08 US Texas Donley 48129 48 0 0 48 34.96517499 -100.8140093 2020-08-09 04:34:54 Donley, Texas, US
391933 2020-08-08 US Texas Duval 48131 173 6 0 167 27.68184592 -98.50864568 2020-08-09 04:34:54 Duval, Texas, US
391940 2020-08-08 US Texas Eastland 48133 73 1 0 72 32.32743996 -98.83243566 2020-08-09 04:34:54 Eastland, Texas, US
391944 2020-08-08 US Texas Ector 48135 3531 56 0 3475 31.86898877 -102.54294279999999 2020-08-09 04:34:54 Ector, Texas, US
391954 2020-08-08 US Texas Edwards 48137 28 0 0 28 29.98202582 -100.304252 2020-08-09 04:34:54 Edwards, Texas, US
391959 2020-08-08 US Texas El Paso 48141 16040 291 0 15749 31.76980765 -106.23632749999999 2020-08-09 04:34:54 El Paso, Texas, US
391969 2020-08-08 US Texas Ellis 48139 2855 41 0 2814 32.34894117 -96.79371841 2020-08-09 04:34:54 Ellis, Texas, US
391978 2020-08-08 US Texas Erath 48143 527 5 0 522 32.23602653 -98.21773417 2020-08-09 04:34:54 Erath, Texas, US
392004 2020-08-08 US Texas Falls 48145 125 3 0 122 31.25350609 -96.93630086 2020-08-09 04:34:54 Falls, Texas, US
392007 2020-08-08 US Texas Fannin 48147 246 8 0 238 33.59564294 -96.10751083 2020-08-09 04:34:54 Fannin, Texas, US
392021 2020-08-08 US Texas Fayette 48149 378 14 0 364 29.87788372 -96.92076062 2020-08-09 04:34:54 Fayette, Texas, US
392030 2020-08-08 US Texas Fisher 48151 28 1 0 27 32.74281316 -100.40193020000001 2020-08-09 04:34:54 Fisher, Texas, US
392041 2020-08-08 US Texas Floyd 48153 89 6 0 83 34.07227468 -101.3031546 2020-08-09 04:34:54 Floyd, Texas, US
392044 2020-08-08 US Texas Foard 48155 2 0 0 2 33.97308618 -99.7767797 2020-08-09 04:34:54 Foard, Texas, US
392053 2020-08-08 US Texas Fort Bend 48157 9533 161 0 9372 29.52704478 -95.77219463 2020-08-09 04:34:54 Fort Bend, Texas, US
392077 2020-08-08 US Texas Franklin 48159 92 2 0 90 33.17653242 -95.21917243 2020-08-09 04:34:54 Franklin, Texas, US
392086 2020-08-08 US Texas Freestone 48161 156 0 0 156 31.70422788 -96.15072516 2020-08-09 04:34:54 Freestone, Texas, US
392092 2020-08-08 US Texas Frio 48163 512 5 0 507 28.86751206 -99.10804207 2020-08-09 04:34:54 Frio, Texas, US
392105 2020-08-08 US Texas Gaines 48165 161 3 0 158 32.74055318 -102.6353295 2020-08-09 04:34:54 Gaines, Texas, US
392111 2020-08-08 US Texas Galveston 48167 9376 113 0 9263 29.40167322 -94.90469073 2020-08-09 04:34:54 Galveston, Texas, US
392122 2020-08-08 US Texas Garza 48169 99 3 0 96 33.17969345 -101.2984114 2020-08-09 04:34:54 Garza, Texas, US
392141 2020-08-08 US Texas Gillespie 48171 175 6 0 169 30.31824095 -98.94676915 2020-08-09 04:34:54 Gillespie, Texas, US
392150 2020-08-08 US Texas Glasscock 48173 6 0 0 6 31.86942909 -101.5207776 2020-08-09 04:34:54 Glasscock, Texas, US
392158 2020-08-08 US Texas Goliad 48175 89 4 0 85 28.65696592 -97.42760647 2020-08-09 04:34:54 Goliad, Texas, US
392159 2020-08-08 US Texas Gonzales 48177 683 9 0 674 29.45634206 -97.49424032 2020-08-09 04:34:54 Gonzales, Texas, US
392198 2020-08-08 US Texas Gray 48179 215 2 0 213 35.40081878 -100.8129222 2020-08-09 04:34:54 Gray, Texas, US
392201 2020-08-08 US Texas Grayson 48181 1118 13 0 1105 33.62744998 -96.67753461 2020-08-09 04:34:54 Grayson, Texas, US
392230 2020-08-08 US Texas Gregg 48183 1416 25 0 1391 32.47940482 -94.81591935 2020-08-09 04:34:54 Gregg, Texas, US
392234 2020-08-08 US Texas Grimes 48185 874 23 0 851 30.54579585 -95.98902499 2020-08-09 04:34:54 Grimes, Texas, US
392240 2020-08-08 US Texas Guadalupe 48187 1679 54 0 1625 29.58165339 -97.94786822 2020-08-09 04:34:54 Guadalupe, Texas, US
392256 2020-08-08 US Texas Hale 48189 1285 26 0 1259 34.07044901 -101.82681140000001 2020-08-09 04:34:54 Hale, Texas, US
392261 2020-08-08 US Texas Hall 48191 11 1 0 10 34.5307555 -100.68138520000001 2020-08-09 04:34:54 Hall, Texas, US
392272 2020-08-08 US Texas Hamilton 48193 82 3 0 79 31.70470573 -98.11083887 2020-08-09 04:34:54 Hamilton, Texas, US
392291 2020-08-08 US Texas Hansford 48195 73 2 0 71 36.27743284 -101.3545796 2020-08-09 04:34:54 Hansford, Texas, US
392296 2020-08-08 US Texas Hardeman 48197 18 0 0 18 34.28944521 -99.74632408 2020-08-09 04:34:54 Hardeman, Texas, US
392302 2020-08-08 US Texas Hardin 48199 973 15 0 958 30.33364686 -94.38931817 2020-08-09 04:34:54 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]);
Powered by Datasette · Query took 2456.284ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette