johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
61 rows where confirmed = 397, country_or_region = "US" and province_or_state = "Texas" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129881 | 129881 | 2022-01-09 | US | Texas | Knox | 48275 | 397 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2022-01-10 04:22:07 | Knox, Texas, US | |
1289071 | 1289071 | 2022-01-04 | US | Texas | Culberson | 48109 | 397 | 13 | 0 | 31.44506775 | -104.5185739 | 2022-01-05 04:21:59 | Culberson, Texas, US | |
1703415 | 1703415 | 2022-01-03 | US | Texas | Culberson | 48109 | 397 | 13 | 0 | 31.44506775 | -104.5185739 | 2022-01-04 04:22:17 | Culberson, Texas, US | |
2962592 | 2962592 | 2021-10-08 | US | Texas | Shackelford | 48417 | 397 | 5 | 0 | 32.73587756 | -99.35401337 | 2021-10-09 04:21:34 | Shackelford, Texas, US | |
3760691 | 3760691 | 2021-09-21 | US | Texas | Sherman | 48421 | 397 | 13 | 0 | 36.27751473 | -101.8933156 | 2021-09-22 04:21:45 | Sherman, Texas, US | |
812794 | 812794 | 2021-09-20 | US | Texas | Sherman | 48421 | 397 | 13 | 0 | 36.27751473 | -101.8933156 | 2021-09-21 04:21:26 | Sherman, Texas, US | |
1817993 | 1817993 | 2021-09-19 | US | Texas | Sherman | 48421 | 397 | 13 | 0 | 36.27751473 | -101.8933156 | 2021-09-20 04:21:22 | Sherman, Texas, US | |
19573 | 19573 | 2021-09-18 | US | Texas | Sherman | 48421 | 397 | 13 | 0 | 36.27751473 | -101.8933156 | 2021-09-19 04:21:34 | Sherman, Texas, US | |
645020 | 645020 | 2021-09-07 | US | Texas | Fisher | 48151 | 397 | 15 | 0 | 32.74281316 | -100.40193020000001 | 2021-09-08 04:21:31 | Fisher, Texas, US | |
3197083 | 3197083 | 2021-09-06 | US | Texas | Fisher | 48151 | 397 | 15 | 0 | 32.74281316 | -100.40193020000001 | 2021-09-07 04:21:35 | Fisher, Texas, US | |
3283951 | 3283951 | 2021-09-05 | US | Texas | Fisher | 48151 | 397 | 15 | 0 | 32.74281316 | -100.40193020000001 | 2021-09-06 04:21:22 | Fisher, Texas, US | |
252365 | 252365 | 2021-09-04 | US | Texas | Fisher | 48151 | 397 | 15 | 0 | 32.74281316 | -100.40193020000001 | 2021-09-05 04:21:33 | Fisher, Texas, US | |
3977646 | 3977646 | 2021-09-03 | US | Texas | Fisher | 48151 | 397 | 14 | 0 | 32.74281316 | -100.40193020000001 | 2021-09-04 04:21:28 | Fisher, Texas, US | |
1599406 | 1599406 | 2021-08-26 | US | Texas | Real | 48385 | 397 | 14 | 0 | 29.83321503 | -99.82018052 | 2021-08-27 04:21:37 | Real, Texas, US | |
248319 | 248319 | 2021-08-17 | US | Texas | Collingsworth | 48087 | 397 | 9 | 0 | 34.96489496 | -100.27001109999999 | 2021-08-18 04:21:35 | Collingsworth, Texas, US | |
248374 | 248374 | 2021-08-17 | US | Texas | Hardeman | 48197 | 397 | 12 | 0 | 34.28944521 | -99.74632408 | 2021-08-18 04:21:35 | Hardeman, Texas, US | |
653129 | 653129 | 2021-08-09 | US | Texas | Mason | 48319 | 397 | 6 | 0 | 30.71780434 | -99.22629416 | 2021-08-10 04:21:27 | Mason, Texas, US | |
592791 | 592791 | 2021-08-08 | US | Texas | Mason | 48319 | 397 | 6 | 0 | 30.71780434 | -99.22629416 | 2021-08-09 04:21:24 | Mason, Texas, US | |
3479358 | 3479358 | 2021-07-22 | US | Texas | Coke | 48081 | 397 | 13 | 0 | 31.88911733 | -100.5297533 | 2021-07-23 04:21:29 | Coke, Texas, US | |
3334577 | 3334577 | 2021-07-21 | US | Texas | Coke | 48081 | 397 | 13 | 0 | 31.88911733 | -100.5297533 | 2021-07-22 04:21:19 | Coke, Texas, US | |
2374558 | 2374558 | 2021-07-20 | US | Texas | Coke | 48081 | 397 | 13 | 0 | 31.88911733 | -100.5297533 | 2021-07-21 04:21:40 | Coke, Texas, US | |
1085075 | 1085075 | 2021-05-14 | US | Texas | Lipscomb | 48295 | 397 | 12 | 0 | 36.27783108 | -100.2733151 | 2021-05-15 04:20:58 | Lipscomb, Texas, US | |
3057341 | 3057341 | 2021-05-13 | US | Texas | Lipscomb | 48295 | 397 | 12 | 0 | 36.27783108 | -100.2733151 | 2021-05-14 04:20:41 | Lipscomb, Texas, US | |
2007715 | 2007715 | 2021-05-12 | US | Texas | Crane | 48103 | 397 | 12 | 0 | 31.43052248 | -102.5143314 | 2021-05-13 04:20:51 | Crane, Texas, US | |
2007811 | 2007811 | 2021-05-12 | US | Texas | Lipscomb | 48295 | 397 | 12 | 0 | 36.27783108 | -100.2733151 | 2021-05-13 04:20:51 | Lipscomb, Texas, US | |
3957546 | 3957546 | 2021-05-11 | US | Texas | Crane | 48103 | 397 | 12 | 0 | 31.43052248 | -102.5143314 | 2021-05-12 04:21:29 | Crane, Texas, US | |
2823825 | 2823825 | 2021-05-10 | US | Texas | Crane | 48103 | 397 | 12 | 0 | 31.43052248 | -102.5143314 | 2021-05-11 04:20:41 | Crane, Texas, US | |
1428157 | 1428157 | 2021-05-09 | US | Texas | Crane | 48103 | 397 | 12 | 0 | 31.43052248 | -102.5143314 | 2021-05-10 04:20:38 | Crane, Texas, US | |
1555025 | 1555025 | 2021-05-08 | US | Texas | Crane | 48103 | 397 | 12 | 0 | 31.43052248 | -102.5143314 | 2021-05-09 04:20:35 | Crane, Texas, US | |
2505083 | 2505083 | 2021-05-07 | US | Texas | Crane | 48103 | 397 | 12 | 0 | 31.43052248 | -102.5143314 | 2021-05-08 04:21:04 | Crane, Texas, US | |
3965561 | 3965561 | 2021-03-10 | US | Texas | Coke | 48081 | 397 | 11 | 0 | 31.88911733 | -100.5297533 | 2021-03-11 05:25:48 | Coke, Texas, US | |
57846 | 57846 | 2021-03-07 | US | Texas | Coke | 48081 | 397 | 11 | 0 | 31.88911733 | -100.5297533 | 2021-03-08 05:24:48 | Coke, Texas, US | |
3670663 | 3670663 | 2021-03-06 | US | Texas | Coke | 48081 | 397 | 11 | 0 | 459 | 31.88911733 | -100.5297533 | 2021-03-07 05:21:54 | Coke, Texas, US |
343328 | 343328 | 2021-02-03 | US | Texas | Crockett | 48105 | 397 | 15 | 0 | 526 | 30.72367027 | -101.4134238 | 2021-02-04 05:22:26 | Crockett, Texas, US |
3903010 | 3903010 | 2021-01-09 | US | Texas | Crane | 48103 | 397 | 9 | 0 | 522 | 31.43052248 | -102.5143314 | 2021-01-10 05:22:12 | Crane, Texas, US |
3764776 | 3764776 | 2020-12-28 | US | Texas | Red River | 48387 | 397 | 24 | 0 | 407 | 33.61886692 | -95.04841765 | 2020-12-29 05:22:37 | Red River, Texas, US |
3152674 | 3152674 | 2020-12-16 | US | Texas | Gaines | 48165 | 397 | 23 | 0 | 1090 | 32.74055318 | -102.6353295 | 2020-12-17 05:28:12 | Gaines, Texas, US |
1037528 | 1037528 | 2020-12-15 | US | Texas | Martin | 48317 | 397 | 11 | 0 | 453 | 32.30600051 | -101.9513518 | 2020-12-16 05:28:04 | Martin, Texas, US |
848573 | 848573 | 2020-12-12 | US | Texas | Archer | 48009 | 397 | 4 | 0 | 391 | 33.61569967 | -98.68754589 | 2020-12-13 05:27:20 | Archer, Texas, US |
1009356 | 1009356 | 2020-12-06 | US | Texas | Dimmit | 48127 | 397 | 9 | 0 | 405 | 28.42270064 | -99.75645095 | 2020-12-07 05:26:14 | Dimmit, Texas, US |
741414 | 741414 | 2020-12-02 | US | Texas | Hudspeth | 48229 | 397 | 4 | 0 | 278 | 31.45628381 | -105.388178 | 2020-12-03 05:28:22 | Hudspeth, Texas, US |
2540508 | 2540508 | 2020-12-01 | US | Texas | Hudspeth | 48229 | 397 | 4 | 0 | 267 | 31.45628381 | -105.388178 | 2020-12-02 05:27:41 | Hudspeth, Texas, US |
3341790 | 3341790 | 2020-11-17 | US | Texas | Runnels | 48399 | 397 | 10 | 0 | 423 | 31.8314342 | -99.97616148 | 2020-11-18 05:40:31 | Runnels, Texas, US |
2883380 | 2883380 | 2020-11-15 | US | Texas | Nolan | 48353 | 397 | 7 | 0 | 548 | 32.30365282 | -100.4060208 | 2020-11-16 05:25:57 | Nolan, Texas, US |
867912 | 867912 | 2020-11-12 | US | Texas | Lee | 48287 | 397 | 15 | 0 | 451 | 30.31120597 | -96.97045773 | 2020-11-13 05:25:30 | Lee, Texas, US |
1991798 | 1991798 | 2020-11-09 | US | Texas | Montague | 48337 | 397 | 13 | 0 | 364 | 33.67521893 | -97.72500958 | 2020-11-10 05:40:07 | Montague, Texas, US |
1180507 | 1180507 | 2020-10-22 | US | Texas | Bosque | 48035 | 397 | 10 | 0 | 375 | 31.89978581 | -97.63613524 | 2020-10-23 04:24:46 | Bosque, Texas, US |
1180513 | 1180513 | 2020-10-22 | US | Texas | Brooks | 48047 | 397 | 23 | 0 | 318 | 27.03103197 | -98.21808402 | 2020-10-23 04:24:46 | Brooks, Texas, US |
1825869 | 1825869 | 2020-10-04 | US | Texas | Gray | 48179 | 397 | 7 | 0 | 325 | 35.40081878 | -100.8129222 | 2020-10-05 04:23:33 | Gray, Texas, US |
2517253 | 2517253 | 2020-10-03 | US | Texas | Gray | 48179 | 397 | 6 | 0 | 326 | 35.40081878 | -100.8129222 | 2020-10-04 04:23:44 | Gray, Texas, US |
1447781 | 1447781 | 2020-09-11 | US | Texas | Scurry | 48415 | 397 | 2 | 0 | 576 | 32.74613808 | -100.9162664 | 2020-09-12 04:25:05 | Scurry, Texas, US |
1176382 | 1176382 | 2020-09-10 | US | Texas | Scurry | 48415 | 397 | 2 | 0 | 561 | 32.74613808 | -100.9162664 | 2020-09-11 04:46:23 | Scurry, Texas, US |
3164843 | 3164843 | 2020-09-06 | US | Texas | Upshur | 48459 | 397 | 8 | 0 | 324 | 32.73706798 | -94.93999853 | 2020-09-07 04:28:30 | Upshur, Texas, US |
1108726 | 1108726 | 2020-09-02 | US | Texas | Palo Pinto | 48363 | 397 | 11 | 0 | 417 | 32.75310985 | -98.31319001 | 2020-09-03 04:28:22 | Palo Pinto, Texas, US |
2994389 | 2994389 | 2020-08-24 | US | Texas | Kendall | 48259 | 397 | 4 | 0 | 189 | 29.94414155 | -98.7113588 | 2020-08-25 04:28:02 | Kendall, Texas, US |
3181000 | 3181000 | 2020-08-18 | US | Texas | Austin | 48015 | 397 | 4 | 0 | 331 | 29.88548725 | -96.27736949 | 2020-08-19 04:27:00 | Austin, Texas, US |
3181177 | 3181177 | 2020-08-18 | US | Texas | Parmer | 48369 | 397 | 7 | 0 | 356 | 34.52993409 | -102.7844668 | 2020-08-19 04:27:00 | Parmer, Texas, US |
3262738 | 3262738 | 2020-07-31 | US | Texas | Kleberg | 48273 | 397 | 4 | 0 | 337 | 27.42435506 | -97.69894948 | 2020-08-01 04:36:27 | Kleberg, Texas, US |
440619 | 440619 | 2020-07-26 | US | Texas | La Salle | 48283 | 397 | 0 | 0 | 351 | 28.34453111 | -99.09908775 | 2020-07-27 04:35:02 | La Salle, Texas, US |
3293762 | 3293762 | 2020-05-07 | US | Texas | Hidalgo | 48215 | 397 | 7 | 0 | 352 | 26.39418217 | -98.18299696 | 2020-05-08 02:32:32 | Hidalgo, Texas, US |
3500777 | 3500777 | 2020-04-25 | US | Texas | Galveston | 48167 | 397 | 21 | 0 | 501 | 29.40167322 | -94.90469073 | 2020-04-26 02:30:51 | Galveston, 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]);