johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where active = 4944 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903966 | 3903966 | 2021-07-31 | Italy | Sardegna | 62051 | 1502 | 55605 | 4944 | 39.21531192 | 9.110616306 | 2021-08-01 04:21:50 | Sardegna, Italy | ||
388516 | 388516 | 2021-04-04 | Spain | Ceuta | 5203 | 96 | 163 | 4944 | 35.8894 | -5.3213 | 2021-04-05 04:20:35 | Ceuta, Spain | ||
3710432 | 3710432 | 2021-04-03 | Spain | Ceuta | 5203 | 96 | 163 | 4944 | 35.8894 | -5.3213 | 2021-04-04 04:20:49 | Ceuta, Spain | ||
1798389 | 1798389 | 2021-03-23 | Brazil | Roraima | 88157 | 1301 | 81632 | 4944 | -2.7376 | -62.0751 | 2021-03-24 05:25:40 | Roraima, Brazil | ||
3052730 | 3052730 | 2021-02-16 | US | Oklahoma | Kay | 40071 | 5013 | 69 | 0 | 4944 | 36.81799745 | -97.14421435 | 2021-02-17 05:23:10 | Kay, Oklahoma, US |
1590502 | 1590502 | 2021-02-05 | US | North Carolina | Lee | 37105 | 5009 | 65 | 0 | 4944 | 35.47623147 | -79.17569362 | 2021-02-06 05:23:55 | Lee, North Carolina, US |
1459447 | 1459447 | 2021-01-31 | Afghanistan | 55023 | 2400 | 47679 | 4944 | 33.93911 | 67.709953 | 2021-02-01 05:22:53 | Afghanistan | |||
1762833 | 1762833 | 2021-01-24 | US | Wisconsin | Grant | 55043 | 5027 | 83 | 0 | 4944 | 42.8671731 | -90.7063218 | 2021-01-25 05:22:16 | Grant, Wisconsin, US |
3506875 | 3506875 | 2021-01-17 | US | Wisconsin | Barron | 55005 | 5008 | 64 | 0 | 4944 | 45.42372701 | -91.84833627 | 2021-01-18 05:22:34 | Barron, Wisconsin, US |
3504079 | 3504079 | 2021-01-17 | US | Florida | Putnam | 12107 | 5033 | 89 | 0 | 4944 | 29.60779729 | -81.74230285 | 2021-01-18 05:22:34 | Putnam, Florida, US |
3902863 | 3902863 | 2021-01-09 | US | Tennessee | Bedford | 47003 | 5140 | 76 | 0 | 4944 | 35.51123746 | -86.45549096 | 2021-01-10 05:22:12 | Bedford, Tennessee, US |
156264 | 156264 | 2021-01-08 | US | North Carolina | Brunswick | 37019 | 5018 | 74 | 0 | 4944 | 34.070565 | -78.22814204 | 2021-01-09 05:22:18 | Brunswick, North Carolina, US |
2867519 | 2867519 | 2021-01-06 | US | South Carolina | Darlington | 45031 | 5046 | 102 | 0 | 4944 | 34.33358335 | -79.96027485 | 2021-01-07 05:22:03 | Darlington, South Carolina, US |
3780720 | 3780720 | 2020-12-27 | US | South Carolina | Lancaster | 45057 | 5025 | 81 | 0 | 4944 | 34.68270843 | -80.70513032 | 2020-12-28 05:22:06 | Lancaster, South Carolina, US |
2409095 | 2409095 | 2020-12-23 | US | New York | Ulster | 36111 | 5079 | 135 | 0 | 4944 | 41.89027881 | -74.26252104 | 2020-12-24 05:23:04 | Ulster, New York, US |
3770091 | 3770091 | 2020-12-22 | Russia | Krasnoyarsk Krai | 43576 | 1530 | 37102 | 4944 | 63.3233807 | 97.0979974 | 2020-12-23 05:22:03 | Krasnoyarsk Krai, Russia | ||
1034822 | 1034822 | 2020-12-15 | US | Arizona | Santa Cruz | 4023 | 5028 | 84 | 0 | 4944 | 31.52508998 | -110.8479088 | 2020-12-16 05:28:04 | Santa Cruz, Arizona, US |
845945 | 845945 | 2020-12-12 | US | Alabama | Lauderdale | 1077 | 5005 | 61 | 0 | 4944 | 34.90171875 | -87.65624729 | 2020-12-13 05:27:20 | Lauderdale, Alabama, US |
1007797 | 1007797 | 2020-12-06 | US | Louisiana | Lafourche | 22057 | 5086 | 142 | 0 | 4944 | 29.52470226 | -90.40976986 | 2020-12-07 05:26:14 | Lafourche, Louisiana, US |
3860781 | 3860781 | 2020-12-04 | US | Illinois | Adams | 17001 | 4995 | 51 | 0 | 4944 | 39.98815591 | -91.18786813 | 2020-12-05 05:27:36 | Adams, Illinois, US |
2537756 | 2537756 | 2020-12-01 | US | Alabama | DeKalb | 1049 | 4981 | 37 | 0 | 4944 | 34.45946862 | -85.80782906 | 2020-12-02 05:27:41 | DeKalb, Alabama, US |
823402 | 823402 | 2020-11-19 | US | Mississippi | Rankin | 28121 | 5038 | 94 | 0 | 4944 | 32.26469147 | -89.94537876 | 2020-11-20 05:26:28 | Rankin, Mississippi, US |
754847 | 754847 | 2020-10-28 | US | California | Madera | 6039 | 4999 | 53 | 0 | 4944 | 37.21513971 | -119.76655890000002 | 2020-10-29 04:24:49 | Madera, California, US |
3789526 | 3789526 | 2020-10-11 | Ukraine | Zakarpattia Oblast | 10850 | 320 | 5586 | 4944 | 48.6208 | 22.2879 | 2020-10-12 04:23:45 | Zakarpattia Oblast, Ukraine | ||
1124416 | 1124416 | 2020-09-17 | US | South Carolina | York | 45091 | 5008 | 64 | 0 | 4944 | 34.97281497 | -81.18085944 | 2020-09-18 05:05:00 | York, South Carolina, US |
2174335 | 2174335 | 2020-09-09 | US | South Carolina | Beaufort | 45013 | 5017 | 73 | 0 | 4944 | 32.39226291 | -80.72619758 | 2020-09-10 04:29:01 | Beaufort, South Carolina, US |
663669 | 663669 | 2020-08-11 | US | Kansas | Sedgwick | 20173 | 4990 | 46 | 0 | 4944 | 37.6842718 | -97.4608198 | 2020-08-12 04:27:29 | Sedgwick, Kansas, US |
3273692 | 3273692 | 2020-05-15 | US | Nevada | Clark | 32003 | 5235 | 291 | 0 | 4944 | 36.21458855 | -115.0130241 | 2020-05-16 02:32:19 | Clark, Nevada, US |
2471284 | 2471284 | 2020-04-20 | US | Massachusetts | Essex | 25009 | 5153 | 209 | 0 | 4944 | 42.6687626 | -70.94687179 | 2020-04-20 23:36:47 | Essex, Massachusetts, US |
1382982 | 1382982 | 2020-04-19 | US | Massachusetts | Essex | 25009 | 5153 | 209 | 0 | 4944 | 42.6687626 | -70.94687179 | 2020-04-19 23:41:01 | Essex, Massachusetts, 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]);