johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where active = 316, country_or_region = "US" and province_or_state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
394016 | 394016 | 2020-11-27 | US | Mississippi | Choctaw | 28019 | 323 | 7 | 0 | 316 | 33.34598242 | -89.24809382 | 2020-11-28 05:25:50 | Choctaw, Mississippi, US |
611513 | 611513 | 2020-08-29 | US | Mississippi | Quitman | 28119 | 319 | 3 | 0 | 316 | 34.25157572 | -90.28908 | 2020-08-30 04:28:22 | Quitman, Mississippi, US |
3564360 | 3564360 | 2020-08-25 | US | Mississippi | Humphreys | 28053 | 329 | 13 | 0 | 316 | 33.12825718 | -90.52252707 | 2020-08-26 04:28:11 | Humphreys, Mississippi, US |
2993064 | 2993064 | 2020-08-24 | US | Mississippi | Humphreys | 28053 | 328 | 12 | 0 | 316 | 33.12825718 | -90.52252707 | 2020-08-25 04:28:02 | Humphreys, Mississippi, US |
2217459 | 2217459 | 2020-08-23 | US | Mississippi | Humphreys | 28053 | 328 | 12 | 0 | 316 | 33.12825718 | -90.52252707 | 2020-08-24 04:27:56 | Humphreys, Mississippi, US |
839458 | 839458 | 2020-08-17 | US | Mississippi | Yalobusha | 28161 | 326 | 10 | 0 | 316 | 34.02824175 | -89.70762049999998 | 2020-08-18 04:27:56 | Yalobusha, Mississippi, US |
1557814 | 1557814 | 2020-08-16 | US | Mississippi | Yalobusha | 28161 | 326 | 10 | 0 | 316 | 34.02824175 | -89.70762049999998 | 2020-08-17 04:27:20 | Yalobusha, Mississippi, US |
457960 | 457960 | 2020-08-07 | US | Mississippi | Tunica | 28143 | 322 | 6 | 0 | 316 | 34.64967704 | -90.37481167 | 2020-08-08 04:34:53 | Tunica, Mississippi, US |
2739555 | 2739555 | 2020-08-03 | US | Mississippi | Tishomingo | 28141 | 320 | 4 | 0 | 316 | 34.74023475 | -88.23917219 | 2020-08-04 04:41:59 | Tishomingo, Mississippi, US |
2705715 | 2705715 | 2020-07-17 | US | Mississippi | Claiborne | 28021 | 328 | 12 | 0 | 316 | 31.97061673 | -90.90702196 | 2020-07-18 04:34:45 | Claiborne, Mississippi, US |
2037978 | 2037978 | 2020-06-27 | US | Mississippi | Lafayette | 28071 | 320 | 4 | 0 | 316 | 34.35687874 | -89.48490961 | 2020-06-28 04:34:04 | Lafayette, Mississippi, US |
1521084 | 1521084 | 2020-06-23 | US | Mississippi | Newton | 28101 | 324 | 8 | 0 | 316 | 32.40021118 | -89.11843336 | 2020-06-24 04:33:28 | Newton, Mississippi, US |
3247590 | 3247590 | 2020-06-21 | US | Mississippi | Lee | 28081 | 330 | 14 | 0 | 316 | 34.291877500000005 | -88.68149954 | 2020-06-22 04:33:20 | Lee, Mississippi, US |
2436183 | 2436183 | 2020-06-20 | US | Mississippi | Lee | 28081 | 330 | 14 | 0 | 316 | 34.291877500000005 | -88.68149954 | 2020-06-21 04:33:19 | Lee, Mississippi, US |
1689761 | 1689761 | 2020-06-19 | US | Mississippi | Lee | 28081 | 330 | 14 | 0 | 316 | 34.291877500000005 | -88.68149954 | 2020-06-20 04:33:19 | Lee, Mississippi, US |
3680911 | 3680911 | 2020-06-18 | US | Mississippi | Lee | 28081 | 330 | 14 | 0 | 316 | 34.291877500000005 | -88.68149954 | 2020-06-19 04:33:17 | Lee, Mississippi, US |
1194115 | 1194115 | 2020-06-17 | US | Mississippi | Lee | 28081 | 330 | 14 | 0 | 316 | 34.291877500000005 | -88.68149954 | 2020-06-18 04:33:18 | Lee, Mississippi, US |
285872 | 285872 | 2020-06-15 | US | Mississippi | Newton | 28101 | 322 | 6 | 0 | 316 | 32.40021118 | -89.11843336 | 2020-06-16 04:33:09 | Newton, Mississippi, US |
227999 | 227999 | 2020-04-30 | US | Mississippi | Scott | 28123 | 316 | 0 | 0 | 316 | 32.406704100000006 | -89.53789439 | 2020-05-01 02:32:28 | Scott, 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]);