johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where active = 5030 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2552503 | 2552503 | 2021-04-15 | Ukraine | Kirovohrad Oblast | 15502 | 539 | 9933 | 5030 | 48.5079 | 32.2623 | 2021-04-16 04:20:46 | Kirovohrad Oblast, Ukraine | ||
2247506 | 2247506 | 2021-04-07 | Montenegro | 93309 | 1334 | 86945 | 5030 | 42.708678000000006 | 19.37439 | 2021-04-08 04:21:13 | Montenegro | |||
1881133 | 1881133 | 2021-03-26 | Panama | 353017 | 6087 | 341900 | 5030 | 8.538 | -80.7821 | 2021-03-27 05:25:04 | Panama | |||
1980763 | 1980763 | 2021-03-25 | Panama | 352579 | 6073 | 341476 | 5030 | 8.538 | -80.7821 | 2021-03-26 05:26:55 | Panama | |||
2183505 | 2183505 | 2021-02-26 | Germany | Thuringen | 75430 | 2827 | 68070 | 5030 | 51.011 | 10.8453 | 2021-02-27 05:22:28 | Thuringen, Germany | ||
1861626 | 1861626 | 2021-02-25 | Ukraine | Kharkiv Oblast | 82806 | 1559 | 76217 | 5030 | 49.9935 | 36.2304 | 2021-02-26 05:22:40 | Kharkiv Oblast, Ukraine | ||
181957 | 181957 | 2021-02-21 | Germany | Rheinland-Pfalz | 99781 | 2989 | 92106 | 5030 | 50.1183 | 7.309 | 2021-02-22 05:24:21 | Rheinland-Pfalz, Germany | ||
1156149 | 1156149 | 2021-02-18 | US | Texas | Caldwell | 48055 | 5568 | 73 | 0 | 5030 | 29.83668859 | -97.61814775 | 2021-02-19 05:24:16 | Caldwell, Texas, US |
1155921 | 1155921 | 2021-02-18 | US | South Carolina | Cherokee | 45021 | 5159 | 129 | 0 | 5030 | 35.05122251 | -81.61828622 | 2021-02-19 05:24:16 | Cherokee, South Carolina, US |
3542385 | 3542385 | 2021-02-12 | US | Tennessee | Dyer | 47045 | 5215 | 96 | 0 | 5030 | 36.05931946 | -89.41542855 | 2021-02-13 05:22:12 | Dyer, Tennessee, US |
3541786 | 3541786 | 2021-02-12 | US | North Carolina | Lenoir | 37107 | 5129 | 99 | 0 | 5030 | 35.24032589999999 | -77.64245615 | 2021-02-13 05:22:12 | Lenoir, North Carolina, US |
1530455 | 1530455 | 2021-02-09 | US | Oklahoma | Le Flore | 40079 | 5072 | 42 | 0 | 5030 | 34.89851864 | -94.70392124 | 2021-02-10 05:22:41 | Le Flore, Oklahoma, US |
1677158 | 1677158 | 2021-02-01 | US | Florida | Gadsden | 12039 | 5100 | 70 | 0 | 5030 | 30.57796289 | -84.61915825 | 2021-02-02 05:22:49 | Gadsden, Florida, US |
1899398 | 1899398 | 2021-01-29 | US | New York | Ontario | 36069 | 5116 | 86 | 0 | 5030 | 42.85145728 | -77.30874425 | 2021-01-30 05:22:49 | Ontario, New York, US |
2466502 | 2466502 | 2021-01-22 | Australia | New South Wales | 5084 | 54 | 0 | 5030 | -33.8688 | 151.2093 | 2021-01-23 05:22:03 | New South Wales, Australia | ||
1097000 | 1097000 | 2021-01-20 | US | Tennessee | Carter | 47019 | 5427 | 115 | 0 | 5030 | 36.28969086 | -82.12588974 | 2021-01-21 05:22:01 | Carter, Tennessee, US |
1093785 | 1093785 | 2021-01-20 | Australia | New South Wales | 5084 | 54 | 0 | 5030 | -33.8688 | 151.2093 | 2021-01-21 05:22:01 | New South Wales, Australia | ||
3518379 | 3518379 | 2021-01-15 | US | Tennessee | Roane | 47145 | 5044 | 77 | 0 | 5030 | 35.84923189 | -84.52458689 | 2021-01-16 05:22:40 | Roane, Tennessee, US |
2627491 | 2627491 | 2021-01-10 | US | Michigan | Eaton | 26045 | 5136 | 106 | 0 | 5030 | 42.59599185 | -84.83740035 | 2021-01-11 05:21:50 | Eaton, Michigan, US |
3901579 | 3901579 | 2021-01-09 | US | Michigan | Eaton | 26045 | 5136 | 106 | 0 | 5030 | 42.59599185 | -84.83740035 | 2021-01-10 05:22:12 | Eaton, Michigan, US |
3036752 | 3036752 | 2021-01-05 | US | Ohio | Erie | 39043 | 5149 | 119 | 0 | 5030 | 41.36796058 | -82.62904521 | 2021-01-06 05:22:16 | Erie, Ohio, US |
3769817 | 3769817 | 2020-12-22 | India | Bihar | 247108 | 1362 | 240716 | 5030 | 25.679658 | 85.60484 | 2020-12-23 05:22:03 | Bihar, India | ||
1036816 | 1036816 | 2020-12-15 | US | Ohio | Columbiana | 39029 | 5168 | 138 | 0 | 5030 | 40.76932373 | -80.78094576 | 2020-12-16 05:28:04 | Columbiana, Ohio, US |
3849354 | 3849354 | 2020-12-13 | US | Maryland | Charles | 24017 | 5142 | 112 | 0 | 5030 | 38.51092331 | -76.98580666 | 2020-12-14 05:26:27 | Charles, Maryland, US |
1819039 | 1819039 | 2020-12-08 | Russia | Tver Oblast | 16888 | 403 | 11455 | 5030 | 57.1134475 | 35.174442799999994 | 2020-12-09 05:28:01 | Tver Oblast, Russia | ||
678618 | 678618 | 2020-11-23 | Sweden | Dalarna | 5219 | 189 | 0 | 5030 | 61.0917 | 14.6664 | 2020-11-24 05:27:31 | Dalarna, Sweden | ||
3190294 | 3190294 | 2020-11-22 | Sweden | Dalarna | 5219 | 189 | 0 | 5030 | 61.0917 | 14.6664 | 2020-11-23 05:25:26 | Dalarna, Sweden | ||
3836788 | 3836788 | 2020-11-21 | Sweden | Dalarna | 5219 | 189 | 0 | 5030 | 61.0917 | 14.6664 | 2020-11-22 05:25:45 | Dalarna, Sweden | ||
2701816 | 2701816 | 2020-11-20 | Sweden | Dalarna | 5219 | 189 | 0 | 5030 | 61.0917 | 14.6664 | 2020-11-21 05:25:51 | Dalarna, Sweden | ||
1826414 | 1826414 | 2020-10-04 | Ukraine | Ternopil Oblast | 14295 | 177 | 9088 | 5030 | 49.5535 | 25.5948 | 2020-10-05 04:23:33 | Ternopil Oblast, Ukraine | ||
1173128 | 1173128 | 2020-09-10 | India | Goa | 22890 | 268 | 17592 | 5030 | 15.359682 | 74.057396 | 2020-09-11 04:46:23 | Goa, India | ||
2215830 | 2215830 | 2020-08-23 | Peru | Madre de Dios | 5158 | 128 | 0 | 5030 | -11.972699 | -70.53171999999998 | 2020-08-24 04:27:56 | Madre de Dios, Peru | ||
1613590 | 1613590 | 2020-08-14 | US | Kansas | Wyandotte | 20209 | 5137 | 107 | 0 | 5030 | 39.11727348 | -94.76378225 | 2020-08-15 04:27:31 | Wyandotte, Kansas, US |
1920165 | 1920165 | 2020-08-10 | Brazil | Alagoas | 68237 | 1694 | 61519 | 5030 | -9.5713 | -36.782 | 2020-08-11 04:35:08 | Alagoas, Brazil | ||
526623 | 526623 | 2020-07-04 | US | Maryland | Anne Arundel | 24003 | 5239 | 209 | 0 | 5030 | 39.00670238 | -76.60329337 | 2020-07-05 04:33:46 | Anne Arundel, Maryland, 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]);