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 active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3044765 | 3044765 | 2020-07-02 | US | Texas | Travis | 48453 | 9050 | 128 | 0 | 9996 | 30.33432034 | -97.78535620000001 | 2020-07-03 04:33:54 | Travis, Texas, US |
197120 | 197120 | 2020-08-31 | US | Texas | Denton | 48121 | 9012 | 131 | 0 | 9995 | 33.20521901 | -97.11691153 | 2020-09-01 04:28:31 | Denton, Texas, US |
1822012 | 1822012 | 2020-12-08 | US | Texas | Tom Green | 48451 | 6398 | 161 | 0 | 9993 | 31.40464436 | -100.462443 | 2020-12-09 05:28:01 | Tom Green, Texas, US |
3542658 | 3542658 | 2021-02-12 | US | Texas | Rockwall | 48397 | 10861 | 114 | 0 | 9992 | 32.89779518 | -96.40771592 | 2021-02-13 05:22:12 | Rockwall, Texas, US |
2867843 | 2867843 | 2021-01-06 | US | Texas | Kaufman | 48257 | 9983 | 131 | 0 | 9990 | 32.599141700000004 | -96.28734728 | 2021-01-07 05:22:03 | Kaufman, Texas, US |
343279 | 343279 | 2021-02-03 | US | Texas | Aransas | 48007 | 1025 | 31 | 0 | 999 | 28.10556197 | -96.9995047 | 2021-02-04 05:22:26 | Aransas, Texas, US |
438585 | 438585 | 2021-01-21 | US | Texas | Tyler | 48457 | 1103 | 21 | 0 | 999 | 30.77031716 | -94.37690895 | 2021-01-22 05:22:10 | Tyler, Texas, US |
820670 | 820670 | 2020-10-09 | US | Texas | Hood | 48221 | 1043 | 31 | 0 | 999 | 32.42990927 | -97.83242024 | 2020-10-10 04:23:57 | Hood, Texas, US |
824696 | 824696 | 2020-11-19 | US | Texas | Karnes | 48255 | 981 | 18 | 0 | 999 | 28.90705334 | -97.85960149 | 2020-11-20 05:26:28 | Karnes, Texas, US |
1180571 | 1180571 | 2020-10-22 | US | Texas | Frio | 48163 | 927 | 9 | 0 | 999 | 28.86751206 | -99.10804207 | 2020-10-23 04:24:46 | Frio, Texas, US |
2194676 | 2194676 | 2020-10-21 | US | Texas | Frio | 48163 | 925 | 9 | 0 | 999 | 28.86751206 | -99.10804207 | 2020-10-22 04:24:27 | Frio, Texas, US |
2485209 | 2485209 | 2021-01-28 | US | Texas | Ward | 48475 | 941 | 16 | 0 | 999 | 31.50999644 | -103.0927909 | 2021-01-29 05:22:23 | Ward, Texas, US |
2692817 | 2692817 | 2020-10-08 | US | Texas | Lavaca | 48285 | 950 | 36 | 0 | 999 | 29.38508402 | -96.93186692 | 2020-10-09 04:23:59 | Lavaca, Texas, US |
2704636 | 2704636 | 2020-11-20 | US | Texas | Karnes | 48255 | 984 | 18 | 0 | 999 | 28.90705334 | -97.85960149 | 2020-11-21 05:25:51 | Karnes, Texas, US |
2738776 | 2738776 | 2020-08-03 | US | Texas | Nacogdoches | 48347 | 802 | 36 | 0 | 999 | 31.62017125 | -94.61803994 | 2020-08-04 04:41:59 | Nacogdoches, Texas, US |
3542638 | 3542638 | 2021-02-12 | US | Texas | Ochiltree | 48357 | 1173 | 23 | 0 | 999 | 36.27829105 | -100.8158184 | 2021-02-13 05:22:12 | Ochiltree, Texas, US |
3804996 | 3804996 | 2020-10-05 | US | Texas | Henderson | 48213 | 610 | 23 | 0 | 999 | 32.21128872 | -95.85846587 | 2020-10-06 04:23:33 | Henderson, Texas, US |
3882640 | 3882640 | 2021-01-14 | US | Texas | Duval | 48131 | 1063 | 31 | 0 | 999 | 27.68184592 | -98.50864568 | 2021-01-15 05:22:24 | Duval, Texas, US |
3882772 | 3882772 | 2021-01-14 | US | Texas | Robertson | 48395 | 1520 | 23 | 0 | 999 | 31.02539637 | -96.51272246 | 2021-01-15 05:22:24 | Robertson, Texas, US |
3981756 | 3981756 | 2021-02-10 | US | Texas | Ochiltree | 48357 | 1171 | 21 | 0 | 999 | 36.27829105 | -100.8158184 | 2021-02-11 05:23:55 | Ochiltree, Texas, US |
2429997 | 2429997 | 2021-01-23 | US | Texas | Guadalupe | 48187 | 10640 | 135 | 0 | 9987 | 29.58165339 | -97.94786822 | 2021-01-24 05:22:35 | Guadalupe, Texas, US |
2246438 | 2246438 | 2020-10-30 | US | Texas | Dallas | 48113 | 92834 | 1355 | 0 | 99858 | 32.76670599 | -96.7779605 | 2020-10-31 04:24:44 | Dallas, Texas, US |
2570758 | 2570758 | 2021-01-25 | US | Texas | Guadalupe | 48187 | 10641 | 139 | 0 | 9984 | 29.58165339 | -97.94786822 | 2021-01-26 05:22:02 | Guadalupe, Texas, US |
1762390 | 1762390 | 2021-01-24 | US | Texas | Guadalupe | 48187 | 10640 | 139 | 0 | 9983 | 29.58165339 | -97.94786822 | 2021-01-25 05:22:16 | Guadalupe, Texas, US |
11409 | 11409 | 2020-10-25 | US | Texas | Frio | 48163 | 927 | 9 | 0 | 998 | 28.86751206 | -99.10804207 | 2020-10-26 04:25:02 | Frio, Texas, US |
441862 | 441862 | 2020-07-26 | US | Texas | Taylor | 48441 | 998 | 14 | 0 | 998 | 32.30163422 | -99.89007449 | 2020-07-27 04:35:02 | Taylor, Texas, US |
474591 | 474591 | 2021-02-19 | US | Texas | Ochiltree | 48357 | 1174 | 25 | 0 | 998 | 36.27829105 | -100.8158184 | 2021-02-20 05:22:51 | Ochiltree, Texas, US |
1044959 | 1044959 | 2020-10-07 | US | Texas | Lavaca | 48285 | 945 | 35 | 0 | 998 | 29.38508402 | -96.93186692 | 2020-10-08 04:23:56 | Lavaca, Texas, US |
1056901 | 1056901 | 2020-10-23 | US | Texas | Frio | 48163 | 927 | 9 | 0 | 998 | 28.86751206 | -99.10804207 | 2020-10-24 04:24:46 | Frio, Texas, US |
1353345 | 1353345 | 2020-11-24 | US | Texas | Calhoun | 48057 | 986 | 9 | 0 | 998 | 28.47048236 | -96.61633945 | 2020-11-25 05:27:20 | Calhoun, Texas, US |
2609176 | 2609176 | 2020-09-24 | US | Texas | Matagorda | 48321 | 1039 | 46 | 0 | 998 | 28.81955746 | -96.01230294 | 2020-09-25 04:23:00 | Matagorda, Texas, US |
2621909 | 2621909 | 2020-06-25 | US | Texas | Bell | 48027 | 312 | 11 | 0 | 998 | 31.03736027 | -97.4785025 | 2020-06-26 04:33:43 | Bell, Texas, US |
2978343 | 2978343 | 2020-12-09 | US | Texas | Hutchinson | 48233 | 1721 | 29 | 0 | 998 | 35.84006574 | -101.3546643 | 2020-12-10 05:26:19 | Hutchinson, Texas, US |
3341823 | 3341823 | 2020-11-17 | US | Texas | Uvalde | 48463 | 999 | 38 | 0 | 998 | 29.35739637 | -99.76229172 | 2020-11-18 05:40:31 | Uvalde, Texas, US |
3654646 | 3654646 | 2020-10-24 | US | Texas | Frio | 48163 | 927 | 9 | 0 | 998 | 28.86751206 | -99.10804207 | 2020-10-25 04:24:36 | Frio, Texas, US |
3902984 | 3902984 | 2021-01-09 | US | Texas | Burleson | 48051 | 1442 | 19 | 0 | 998 | 30.49273808 | -96.62158484 | 2021-01-10 05:22:12 | Burleson, Texas, US |
1530989 | 1530989 | 2021-02-09 | US | Texas | Gregg | 48183 | 8361 | 275 | 0 | 9973 | 32.47940482 | -94.81591935 | 2021-02-10 05:22:41 | Gregg, Texas, US |
3981669 | 3981669 | 2021-02-10 | US | Texas | Gregg | 48183 | 8361 | 277 | 0 | 9971 | 32.47940482 | -94.81591935 | 2021-02-11 05:23:55 | Gregg, Texas, US |
213293 | 213293 | 2020-10-29 | US | Texas | Dallas | 48113 | 92431 | 1345 | 0 | 99706 | 32.76670599 | -96.7779605 | 2020-10-30 04:24:49 | Dallas, Texas, US |
616901 | 616901 | 2021-02-08 | US | Texas | Somervell | 48425 | 1016 | 10 | 0 | 997 | 32.22236802 | -97.77403489 | 2021-02-09 05:23:30 | Somervell, Texas, US |
978131 | 978131 | 2021-02-06 | US | Texas | Somervell | 48425 | 1016 | 10 | 0 | 997 | 32.22236802 | -97.77403489 | 2021-02-07 05:23:00 | Somervell, Texas, US |
1013348 | 1013348 | 2020-12-30 | US | Texas | Colorado | 48089 | 986 | 15 | 0 | 997 | 29.622098 | -96.5273805 | 2020-12-31 05:22:49 | Colorado, Texas, US |
1675670 | 1675670 | 2021-02-07 | US | Texas | Somervell | 48425 | 1016 | 10 | 0 | 997 | 32.22236802 | -97.77403489 | 2021-02-08 05:22:39 | Somervell, Texas, US |
2429921 | 2429921 | 2021-01-23 | US | Texas | Bosque | 48035 | 1288 | 21 | 0 | 997 | 31.89978581 | -97.63613524 | 2021-01-24 05:22:35 | Bosque, Texas, US |
2469823 | 2469823 | 2021-01-22 | US | Texas | Bosque | 48035 | 1288 | 21 | 0 | 997 | 31.89978581 | -97.63613524 | 2021-01-23 05:22:03 | Bosque, Texas, US |
2470034 | 2470034 | 2021-01-22 | US | Texas | Tyler | 48457 | 1103 | 23 | 0 | 997 | 30.77031716 | -94.37690895 | 2021-01-23 05:22:03 | Tyler, Texas, US |
2656919 | 2656919 | 2020-09-23 | US | Texas | Matagorda | 48321 | 1035 | 44 | 0 | 997 | 28.81955746 | -96.01230294 | 2020-09-24 04:23:00 | Matagorda, Texas, US |
2839967 | 2839967 | 2020-09-21 | US | Texas | Matagorda | 48321 | 1027 | 42 | 0 | 997 | 28.81955746 | -96.01230294 | 2020-09-22 04:23:00 | Matagorda, Texas, US |
3258414 | 3258414 | 2020-05-18 | US | Texas | Collin | 48085 | 1195 | 31 | 0 | 997 | 33.18820114 | -96.57264368 | 2020-05-19 02:32:18 | Collin, Texas, US |
3698533 | 3698533 | 2020-12-31 | US | Texas | Colorado | 48089 | 1039 | 15 | 0 | 997 | 29.622098 | -96.5273805 | 2021-01-01 05:23:07 | Colorado, Texas, US |
1791441 | 1791441 | 2020-05-31 | US | Texas | Dallas | 48113 | 6395 | 269 | 0 | 9965 | 32.76670599 | -96.7779605 | 2020-06-01 02:32:46 | Dallas, Texas, US |
2640814 | 2640814 | 2021-02-11 | US | Texas | Gregg | 48183 | 8361 | 283 | 0 | 9965 | 32.47940482 | -94.81591935 | 2021-02-12 05:23:29 | Gregg, Texas, US |
15370 | 15370 | 2021-01-26 | US | Texas | Callahan | 48059 | 1017 | 30 | 0 | 996 | 32.29760619 | -99.37326312 | 2021-01-27 05:23:41 | Callahan, Texas, US |
125933 | 125933 | 2020-11-18 | US | Texas | Upshur | 48459 | 863 | 17 | 0 | 996 | 32.73706798 | -94.93999853 | 2020-11-19 05:25:23 | Upshur, Texas, US |
867826 | 867826 | 2020-11-12 | US | Texas | Dawson | 48115 | 625 | 30 | 0 | 996 | 32.74255572 | -101.9477242 | 2020-11-13 05:25:30 | Dawson, Texas, US |
1124720 | 1124720 | 2020-09-17 | US | Texas | Lamar | 48277 | 242 | 31 | 0 | 996 | 33.66981763 | -95.57404777 | 2020-09-18 05:05:00 | Lamar, Texas, US |
1462840 | 1462840 | 2021-01-31 | US | Texas | Freestone | 48161 | 1259 | 33 | 0 | 996 | 31.70422788 | -96.15072516 | 2021-02-01 05:22:53 | Freestone, Texas, US |
1762314 | 1762314 | 2021-01-24 | US | Texas | Bosque | 48035 | 1288 | 22 | 0 | 996 | 31.89978581 | -97.63613524 | 2021-01-25 05:22:16 | Bosque, Texas, US |
1821907 | 1821907 | 2020-12-08 | US | Texas | Jasper | 48241 | 1191 | 37 | 0 | 996 | 30.74685667 | -94.02667579 | 2020-12-09 05:28:01 | Jasper, Texas, US |
1926931 | 1926931 | 2020-07-30 | US | Texas | Moore | 48341 | 1048 | 12 | 0 | 996 | 35.83769242 | -101.8930281 | 2020-07-31 04:35:18 | Moore, Texas, US |
2218829 | 2218829 | 2020-08-23 | US | Texas | Navarro | 48349 | 1275 | 13 | 0 | 996 | 32.04620681 | -96.47428766 | 2020-08-24 04:27:56 | Navarro, Texas, US |
2302611 | 2302611 | 2020-08-22 | US | Texas | Navarro | 48349 | 1261 | 13 | 0 | 996 | 32.04620681 | -96.47428766 | 2020-08-23 04:27:48 | Navarro, Texas, US |
2570682 | 2570682 | 2021-01-25 | US | Texas | Bosque | 48035 | 1288 | 22 | 0 | 996 | 31.89978581 | -97.63613524 | 2021-01-26 05:22:02 | Bosque, Texas, US |
2994434 | 2994434 | 2020-08-24 | US | Texas | Navarro | 48349 | 1293 | 13 | 0 | 996 | 32.04620681 | -96.47428766 | 2020-08-25 04:28:02 | Navarro, Texas, US |
3263223 | 3263223 | 2020-07-31 | US | Texas | Moore | 48341 | 1051 | 12 | 0 | 996 | 35.83769242 | -101.8930281 | 2020-08-01 04:36:27 | Moore, Texas, US |
2640921 | 2640921 | 2021-02-11 | US | Texas | Rockwall | 48397 | 10827 | 113 | 0 | 9959 | 32.89779518 | -96.40771592 | 2021-02-12 05:23:29 | Rockwall, Texas, US |
863689 | 863689 | 2020-12-11 | US | Texas | Bell | 48027 | 10231 | 137 | 0 | 9956 | 31.03736027 | -97.4785025 | 2020-12-12 05:26:19 | Bell, Texas, US |
3863041 | 3863041 | 2020-12-04 | US | Texas | Smith | 48423 | 5004 | 207 | 0 | 9955 | 32.37474036 | -95.2717568 | 2020-12-05 05:27:36 | Smith, Texas, US |
2513272 | 2513272 | 2020-08-27 | US | Texas | Harris | 48201 | 141301 | 2140 | 0 | 99530 | 29.85864939 | -95.39339521 | 2020-08-28 04:28:11 | Harris, Texas, US |
930796 | 930796 | 2020-12-21 | US | Texas | Hays | 48209 | 10626 | 120 | 0 | 9953 | 30.05669873 | -98.02944344 | 2020-12-22 05:22:33 | Hays, Texas, US |
125835 | 125835 | 2020-11-18 | US | Texas | Kerr | 48265 | 942 | 19 | 0 | 995 | 30.06040006 | -99.34930144 | 2020-11-19 05:25:23 | Kerr, Texas, US |
438374 | 438374 | 2021-01-21 | US | Texas | Bosque | 48035 | 1286 | 21 | 0 | 995 | 31.89978581 | -97.63613524 | 2021-01-22 05:22:10 | Bosque, Texas, US |
438423 | 438423 | 2021-01-21 | US | Texas | Eastland | 48133 | 997 | 26 | 0 | 995 | 32.32743996 | -98.83243566 | 2021-01-22 05:22:10 | Eastland, Texas, US |
681339 | 681339 | 2020-11-23 | US | Texas | Calhoun | 48057 | 982 | 9 | 0 | 995 | 28.47048236 | -96.61633945 | 2020-11-24 05:27:31 | Calhoun, Texas, US |
895227 | 895227 | 2020-11-05 | US | Texas | Hockley | 48219 | 1131 | 23 | 0 | 995 | 33.60771256 | -102.3431676 | 2020-11-06 05:24:55 | Hockley, Texas, US |
1603462 | 1603462 | 2020-12-10 | US | Texas | Wilbarger | 48487 | 1179 | 16 | 0 | 995 | 34.07945812 | -99.24178437 | 2020-12-11 05:26:59 | Wilbarger, Texas, US |
1687505 | 1687505 | 2021-02-02 | US | Texas | Aransas | 48007 | 1021 | 31 | 0 | 995 | 28.10556197 | -96.9995047 | 2021-02-03 05:22:52 | Aransas, Texas, US |
2214748 | 2214748 | 2021-01-30 | US | Texas | Freestone | 48161 | 1258 | 33 | 0 | 995 | 31.70422788 | -96.15072516 | 2021-01-31 05:22:42 | Freestone, Texas, US |
2978347 | 2978347 | 2020-12-09 | US | Texas | Jasper | 48241 | 1206 | 38 | 0 | 995 | 30.74685667 | -94.02667579 | 2020-12-10 05:26:19 | Jasper, Texas, US |
3193015 | 3193015 | 2020-11-22 | US | Texas | Calhoun | 48057 | 970 | 9 | 0 | 995 | 28.47048236 | -96.61633945 | 2020-11-23 05:25:26 | Calhoun, Texas, US |
3319368 | 3319368 | 2020-09-22 | US | Texas | Matagorda | 48321 | 1029 | 44 | 0 | 995 | 28.81955746 | -96.01230294 | 2020-09-23 04:23:00 | Matagorda, Texas, US |
3839509 | 3839509 | 2020-11-21 | US | Texas | Calhoun | 48057 | 967 | 9 | 0 | 995 | 28.47048236 | -96.61633945 | 2020-11-22 05:25:45 | Calhoun, Texas, US |
3172656 | 3172656 | 2020-11-16 | US | Texas | Brazos | 48041 | 8209 | 94 | 0 | 9948 | 30.663644800000004 | -96.30205577 | 2020-11-17 05:25:54 | Brazos, Texas, US |
157181 | 157181 | 2021-01-08 | US | Texas | Runnels | 48399 | 1014 | 22 | 0 | 994 | 31.8314342 | -99.97616148 | 2021-01-09 05:22:18 | Runnels, Texas, US |
226539 | 226539 | 2020-04-30 | US | Texas | Fort Bend | 48157 | 562 | 24 | 0 | 994 | 29.52704478 | -95.77219463 | 2020-05-01 02:32:28 | Fort Bend, Texas, US |
751149 | 751149 | 2020-08-01 | US | Texas | Grayson | 48181 | 972 | 11 | 0 | 994 | 33.62744998 | -96.67753461 | 2020-08-02 04:34:47 | Grayson, Texas, US |
765422 | 765422 | 2020-10-18 | US | Texas | Howard | 48227 | 1347 | 19 | 0 | 994 | 32.30621324 | -101.4356444 | 2020-10-19 04:24:16 | Howard, Texas, US |
820618 | 820618 | 2020-10-09 | US | Texas | DeWitt | 48123 | 852 | 42 | 0 | 994 | 29.08101855 | -97.3568117 | 2020-10-10 04:23:57 | DeWitt, Texas, US |
848722 | 848722 | 2020-12-12 | US | Texas | Madison | 48313 | 1138 | 16 | 0 | 994 | 30.96694679 | -95.93003775 | 2020-12-13 05:27:20 | Madison, Texas, US |
1004468 | 1004468 | 2020-07-09 | US | Texas | Randall | 48381 | 921 | 7 | 0 | 994 | 34.96585996 | -101.8971322 | 2020-07-10 04:34:24 | Randall, Texas, US |
1029460 | 1029460 | 2020-10-17 | US | Texas | Howard | 48227 | 1342 | 19 | 0 | 994 | 32.30621324 | -101.4356444 | 2020-10-18 04:24:25 | Howard, Texas, US |
1591389 | 1591389 | 2021-02-05 | US | Texas | Somervell | 48425 | 1012 | 9 | 0 | 994 | 32.22236802 | -97.77403489 | 2021-02-06 05:23:55 | Somervell, Texas, US |
1619447 | 1619447 | 2021-03-05 | US | Texas | San Jacinto | 48407 | 1613 | 29 | 0 | 994 | 30.57933681 | -95.16260304 | 2021-03-06 04:23:41 | San Jacinto, Texas, US |
1797739 | 1797739 | 2020-10-19 | US | Texas | Howard | 48227 | 1359 | 19 | 0 | 994 | 32.30621324 | -101.4356444 | 2020-10-20 04:24:22 | Howard, Texas, US |
1821933 | 1821933 | 2020-12-08 | US | Texas | Limestone | 48293 | 917 | 20 | 0 | 994 | 31.5454767 | -96.58095444 | 2020-12-09 05:28:01 | Limestone, Texas, US |
2294495 | 2294495 | 2020-10-12 | US | Texas | DeWitt | 48123 | 854 | 42 | 0 | 994 | 29.08101855 | -97.3568117 | 2020-10-13 04:24:02 | DeWitt, Texas, US |
2501152 | 2501152 | 2020-11-03 | US | Texas | Kleberg | 48273 | 1138 | 53 | 0 | 994 | 27.42435506 | -97.69894948 | 2020-11-04 05:25:09 | Kleberg, Texas, US |
2605085 | 2605085 | 2020-10-10 | US | Texas | DeWitt | 48123 | 853 | 42 | 0 | 994 | 29.08101855 | -97.3568117 | 2020-10-11 04:23:46 | DeWitt, Texas, US |
2692733 | 2692733 | 2020-10-08 | US | Texas | DeWitt | 48123 | 851 | 42 | 0 | 994 | 29.08101855 | -97.3568117 | 2020-10-09 04:23:59 | DeWitt, Texas, US |
2805581 | 2805581 | 2020-08-02 | US | Texas | Grayson | 48181 | 979 | 11 | 0 | 994 | 33.62744998 | -96.67753461 | 2020-08-03 04:34:35 | Grayson, 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]);