johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where country_or_region = "US", deaths = 221 and province_or_state = "Mississippi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 24 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1765160 | 1765160 | 2022-06-20 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-21 04:20:56 | Monroe, Mississippi, US | |
3271346 | 3271346 | 2022-06-19 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-20 04:21:01 | Monroe, Mississippi, US | |
3399258 | 3399258 | 2022-06-18 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-19 04:20:51 | Monroe, Mississippi, US | |
2313135 | 2313135 | 2022-06-17 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-18 04:21:10 | Monroe, Mississippi, US | |
560639 | 560639 | 2022-06-16 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-17 04:20:56 | Monroe, Mississippi, US | |
3984441 | 3984441 | 2022-06-15 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-16 04:20:55 | Monroe, Mississippi, US | |
948682 | 948682 | 2022-06-14 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-15 04:20:54 | Monroe, Mississippi, US | |
2981090 | 2981090 | 2022-06-13 | US | Mississippi | Monroe | 28095 | 11135 | 221 | 0 | 33.89236763 | -88.4808438 | 2022-06-14 04:20:52 | Monroe, Mississippi, US | |
3673480 | 3673480 | 2022-02-15 | US | Mississippi | Lowndes | 28087 | 17343 | 221 | 0 | 33.47386518 | -88.44191529999998 | 2022-02-16 04:21:10 | Lowndes, Mississippi, US | |
2643581 | 2643581 | 2022-02-14 | US | Mississippi | Lowndes | 28087 | 17315 | 221 | 0 | 33.47386518 | -88.44191529999998 | 2022-02-15 04:21:09 | Lowndes, Mississippi, US | |
1364186 | 1364186 | 2022-02-08 | US | Mississippi | Neshoba | 28099 | 10093 | 221 | 0 | 32.75339664 | -89.11726492 | 2022-02-09 04:21:04 | Neshoba, Mississippi, US | |
72924 | 72924 | 2022-02-07 | US | Mississippi | Neshoba | 28099 | 10070 | 221 | 0 | 32.75339664 | -89.11726492 | 2022-02-08 04:21:15 | Neshoba, Mississippi, US | |
2014540 | 2014540 | 2022-02-06 | US | Mississippi | Neshoba | 28099 | 9922 | 221 | 0 | 32.75339664 | -89.11726492 | 2022-02-07 04:21:05 | Neshoba, Mississippi, US | |
1295869 | 1295869 | 2022-02-05 | US | Mississippi | Neshoba | 28099 | 9922 | 221 | 0 | 32.75339664 | -89.11726492 | 2022-02-06 04:21:00 | Neshoba, Mississippi, US | |
2329197 | 2329197 | 2022-02-04 | US | Mississippi | Neshoba | 28099 | 9922 | 221 | 0 | 32.75339664 | -89.11726492 | 2022-02-05 04:21:05 | Neshoba, Mississippi, US | |
1336099 | 1336099 | 2021-09-28 | US | Mississippi | Lee | 28081 | 15016 | 221 | 0 | 34.291877500000005 | -88.68149954 | 2021-09-29 04:21:45 | Lee, Mississippi, US | |
1237468 | 1237468 | 2021-09-27 | US | Mississippi | Lee | 28081 | 14963 | 221 | 0 | 34.291877500000005 | -88.68149954 | 2021-09-28 04:21:28 | Lee, Mississippi, US | |
1237482 | 1237482 | 2021-09-27 | US | Mississippi | Pearl River | 28109 | 9151 | 221 | 0 | 30.77090935 | -89.58677275 | 2021-09-28 04:21:28 | Pearl River, Mississippi, US | |
2077783 | 2077783 | 2021-09-26 | US | Mississippi | Pearl River | 28109 | 9098 | 221 | 0 | 30.77090935 | -89.58677275 | 2021-09-27 04:21:16 | Pearl River, Mississippi, US | |
1726335 | 1726335 | 2021-09-25 | US | Mississippi | Pearl River | 28109 | 9098 | 221 | 0 | 30.77090935 | -89.58677275 | 2021-09-26 04:21:29 | Pearl River, Mississippi, US | |
1923055 | 1923055 | 2021-09-24 | US | Mississippi | Pearl River | 28109 | 9098 | 221 | 0 | 30.77090935 | -89.58677275 | 2021-09-25 04:21:31 | Pearl River, Mississippi, US | |
811390 | 811390 | 2021-09-20 | US | Mississippi | Jones | 28067 | 13216 | 221 | 0 | 31.62257767 | -89.16896899999998 | 2021-09-21 04:21:26 | Jones, Mississippi, US | |
2639512 | 2639512 | 2021-02-11 | US | Mississippi | DeSoto | 28033 | 18991 | 221 | 0 | 18770 | 34.87625235 | -89.99091418 | 2021-02-12 05:23:29 | DeSoto, Mississippi, US |
2569498 | 2569498 | 2021-01-25 | US | Mississippi | Rankin | 28121 | 11280 | 221 | 0 | 11059 | 32.26469147 | -89.94537876 | 2021-01-26 05:22:02 | Rankin, Mississippi, 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]);