johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
997 rows where confirmed = 292 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954625 | 2954625 | 2022-12-20 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-21 04:21:03 | Throckmorton, Texas, US | |
3177027 | 3177027 | 2022-12-19 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-20 04:21:04 | Throckmorton, Texas, US | |
1631544 | 1631544 | 2022-12-18 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-19 04:21:03 | Throckmorton, Texas, US | |
506923 | 506923 | 2022-12-17 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-18 04:21:03 | Throckmorton, Texas, US | |
3327495 | 3327495 | 2022-12-16 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-17 04:21:04 | Throckmorton, Texas, US | |
546007 | 546007 | 2022-12-15 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-16 04:21:01 | Throckmorton, Texas, US | |
351535 | 351535 | 2022-12-14 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-15 04:20:58 | Throckmorton, Texas, US | |
311123 | 311123 | 2022-12-13 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-14 04:21:04 | Throckmorton, Texas, US | |
1152184 | 1152184 | 2022-12-12 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-13 04:21:01 | Throckmorton, Texas, US | |
1150761 | 1150761 | 2022-12-12 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-13 04:21:01 | Issaquena, Mississippi, US | |
872038 | 872038 | 2022-12-11 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-12 04:21:01 | Throckmorton, Texas, US | |
870615 | 870615 | 2022-12-11 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-12 04:21:01 | Issaquena, Mississippi, US | |
260568 | 260568 | 2022-12-10 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-11 04:20:50 | Throckmorton, Texas, US | |
259145 | 259145 | 2022-12-10 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-11 04:20:50 | Issaquena, Mississippi, US | |
3939282 | 3939282 | 2022-12-09 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-10 04:21:02 | Throckmorton, Texas, US | |
3937859 | 3937859 | 2022-12-09 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-10 04:21:02 | Issaquena, Mississippi, US | |
3380614 | 3380614 | 2022-12-08 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-09 04:21:05 | Throckmorton, Texas, US | |
3379191 | 3379191 | 2022-12-08 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-09 04:21:05 | Issaquena, Mississippi, US | |
1987885 | 1987885 | 2022-12-07 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-08 04:21:07 | Throckmorton, Texas, US | |
1986462 | 1986462 | 2022-12-07 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-08 04:21:07 | Issaquena, Mississippi, US | |
3717408 | 3717408 | 2022-12-06 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-07 04:20:58 | Throckmorton, Texas, US | |
3715985 | 3715985 | 2022-12-06 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-07 04:20:58 | Issaquena, Mississippi, US | |
2418113 | 2418113 | 2022-12-05 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-06 04:21:03 | Throckmorton, Texas, US | |
2416690 | 2416690 | 2022-12-05 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-06 04:21:03 | Issaquena, Mississippi, US | |
721721 | 721721 | 2022-12-04 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-05 04:20:58 | Throckmorton, Texas, US | |
720298 | 720298 | 2022-12-04 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-05 04:20:58 | Issaquena, Mississippi, US | |
719125 | 719125 | 2022-12-04 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-12-05 04:20:58 | Mineral, Colorado, US | |
2820010 | 2820010 | 2022-12-03 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-04 04:20:56 | Throckmorton, Texas, US | |
2818587 | 2818587 | 2022-12-03 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-04 04:20:56 | Issaquena, Mississippi, US | |
2817414 | 2817414 | 2022-12-03 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-12-04 04:20:56 | Mineral, Colorado, US | |
836866 | 836866 | 2022-12-02 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-03 04:21:02 | Throckmorton, Texas, US | |
835443 | 835443 | 2022-12-02 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-03 04:21:02 | Issaquena, Mississippi, US | |
834270 | 834270 | 2022-12-02 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-12-03 04:21:02 | Mineral, Colorado, US | |
2139396 | 2139396 | 2022-12-01 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-02 04:21:07 | Throckmorton, Texas, US | |
2137973 | 2137973 | 2022-12-01 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-02 04:21:07 | Issaquena, Mississippi, US | |
2136800 | 2136800 | 2022-12-01 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-12-02 04:21:07 | Mineral, Colorado, US | |
1967812 | 1967812 | 2022-11-30 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-12-01 04:21:03 | Throckmorton, Texas, US | |
1966389 | 1966389 | 2022-11-30 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-12-01 04:21:03 | Issaquena, Mississippi, US | |
1965216 | 1965216 | 2022-11-30 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-12-01 04:21:03 | Mineral, Colorado, US | |
2559826 | 2559826 | 2022-11-29 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-30 04:21:07 | Throckmorton, Texas, US | |
2558403 | 2558403 | 2022-11-29 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-30 04:21:07 | Issaquena, Mississippi, US | |
2557230 | 2557230 | 2022-11-29 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-30 04:21:07 | Mineral, Colorado, US | |
1242900 | 1242900 | 2022-11-28 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-29 04:21:05 | Throckmorton, Texas, US | |
1241477 | 1241477 | 2022-11-28 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-29 04:21:05 | Issaquena, Mississippi, US | |
1240304 | 1240304 | 2022-11-28 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-29 04:21:05 | Mineral, Colorado, US | |
3554888 | 3554888 | 2022-11-27 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-28 04:21:02 | Throckmorton, Texas, US | |
3553465 | 3553465 | 2022-11-27 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-28 04:21:02 | Issaquena, Mississippi, US | |
3552292 | 3552292 | 2022-11-27 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-28 04:21:02 | Mineral, Colorado, US | |
2103368 | 2103368 | 2022-11-26 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-27 04:21:05 | Throckmorton, Texas, US | |
2101945 | 2101945 | 2022-11-26 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-27 04:21:05 | Issaquena, Mississippi, US | |
2100772 | 2100772 | 2022-11-26 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-27 04:21:05 | Mineral, Colorado, US | |
490859 | 490859 | 2022-11-25 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-26 04:21:11 | Throckmorton, Texas, US | |
489436 | 489436 | 2022-11-25 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-26 04:21:11 | Issaquena, Mississippi, US | |
488263 | 488263 | 2022-11-25 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-26 04:21:11 | Mineral, Colorado, US | |
3526688 | 3526688 | 2022-11-24 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-25 04:21:06 | Throckmorton, Texas, US | |
3525265 | 3525265 | 2022-11-24 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-25 04:21:06 | Issaquena, Mississippi, US | |
3524092 | 3524092 | 2022-11-24 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-25 04:21:06 | Mineral, Colorado, US | |
3315471 | 3315471 | 2022-11-23 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-24 04:21:09 | Throckmorton, Texas, US | |
3314048 | 3314048 | 2022-11-23 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-24 04:21:09 | Issaquena, Mississippi, US | |
3312875 | 3312875 | 2022-11-23 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-24 04:21:09 | Mineral, Colorado, US | |
1623512 | 1623512 | 2022-11-22 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-23 04:21:06 | Throckmorton, Texas, US | |
1622089 | 1622089 | 2022-11-22 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-23 04:21:06 | Issaquena, Mississippi, US | |
1620916 | 1620916 | 2022-11-22 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-23 04:21:06 | Mineral, Colorado, US | |
3463400 | 3463400 | 2022-11-21 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-22 04:20:47 | Throckmorton, Texas, US | |
3461977 | 3461977 | 2022-11-21 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-22 04:20:47 | Issaquena, Mississippi, US | |
3460804 | 3460804 | 2022-11-21 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-22 04:20:47 | Mineral, Colorado, US | |
1643585 | 1643585 | 2022-11-20 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-21 04:21:05 | Throckmorton, Texas, US | |
1642162 | 1642162 | 2022-11-20 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-21 04:21:05 | Issaquena, Mississippi, US | |
1640989 | 1640989 | 2022-11-20 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-21 04:21:05 | Mineral, Colorado, US | |
2067142 | 2067142 | 2022-11-19 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-20 04:21:08 | Throckmorton, Texas, US | |
2065719 | 2065719 | 2022-11-19 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-20 04:21:08 | Issaquena, Mississippi, US | |
2064546 | 2064546 | 2022-11-19 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-20 04:21:08 | Mineral, Colorado, US | |
1758536 | 1758536 | 2022-11-18 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-19 04:21:14 | Throckmorton, Texas, US | |
1757113 | 1757113 | 2022-11-18 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-19 04:21:14 | Issaquena, Mississippi, US | |
1755940 | 1755940 | 2022-11-18 | US | Colorado | Mineral | 8079 | 292 | 4 | 0 | 37.66954283 | -106.9281698 | 2022-11-19 04:21:14 | Mineral, Colorado, US | |
3029529 | 3029529 | 2022-11-17 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-18 04:21:15 | Throckmorton, Texas, US | |
3028106 | 3028106 | 2022-11-17 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-18 04:21:15 | Issaquena, Mississippi, US | |
3026933 | 3026933 | 2022-11-17 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-18 04:21:15 | Mineral, Colorado, US | |
2489240 | 2489240 | 2022-11-16 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-17 04:21:11 | Throckmorton, Texas, US | |
2487817 | 2487817 | 2022-11-16 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-17 04:21:11 | Issaquena, Mississippi, US | |
2486644 | 2486644 | 2022-11-16 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-17 04:21:11 | Mineral, Colorado, US | |
295251 | 295251 | 2022-11-15 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-16 04:21:09 | Throckmorton, Texas, US | |
293828 | 293828 | 2022-11-15 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-16 04:21:09 | Issaquena, Mississippi, US | |
292655 | 292655 | 2022-11-15 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-16 04:21:09 | Mineral, Colorado, US | |
3600281 | 3600281 | 2022-11-14 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-15 04:21:16 | Throckmorton, Texas, US | |
3598858 | 3598858 | 2022-11-14 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-15 04:21:16 | Issaquena, Mississippi, US | |
3597685 | 3597685 | 2022-11-14 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-15 04:21:16 | Mineral, Colorado, US | |
315139 | 315139 | 2022-11-13 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-14 04:21:09 | Throckmorton, Texas, US | |
313716 | 313716 | 2022-11-13 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-14 04:21:09 | Issaquena, Mississippi, US | |
312543 | 312543 | 2022-11-13 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-14 04:21:09 | Mineral, Colorado, US | |
66300 | 66300 | 2022-11-12 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-13 04:21:14 | Throckmorton, Texas, US | |
64877 | 64877 | 2022-11-12 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-13 04:21:14 | Issaquena, Mississippi, US | |
63704 | 63704 | 2022-11-12 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-13 04:21:14 | Mineral, Colorado, US | |
2930462 | 2930462 | 2022-11-11 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-12 04:20:41 | Throckmorton, Texas, US | |
2929039 | 2929039 | 2022-11-11 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-12 04:20:41 | Issaquena, Mississippi, US | |
2927866 | 2927866 | 2022-11-11 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-12 04:20:41 | Mineral, Colorado, US | |
2509298 | 2509298 | 2022-11-10 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-11 04:21:22 | Throckmorton, Texas, US | |
2507875 | 2507875 | 2022-11-10 | US | Mississippi | Issaquena | 28055 | 292 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-11 04:21:22 | Issaquena, Mississippi, US | |
2506702 | 2506702 | 2022-11-10 | US | Colorado | Mineral | 8079 | 292 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-11-11 04:21:22 | Mineral, Colorado, US | |
2434173 | 2434173 | 2022-11-09 | US | Texas | Throckmorton | 48447 | 292 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-10 04:21:16 | Throckmorton, 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]);