johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where active = 5285 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
579032 | 579032 | 2021-07-13 | Russia | Irkutsk Oblast | 78324 | 3115 | 69924 | 5285 | 56.6370122 | 104.719221 | 2021-07-14 04:21:35 | Irkutsk Oblast, Russia | ||
107449 | 107449 | 2021-06-19 | Italy | Veneto | 424983 | 11602 | 408096 | 5285 | 45.43490485 | 12.33845213 | 2021-06-20 04:21:48 | Veneto, Italy | ||
3883285 | 3883285 | 2021-04-11 | Australia | New South Wales | 5339 | 54 | 0 | 5285 | -33.8688 | 151.2093 | 2021-04-12 04:21:00 | New South Wales, Australia | ||
472099 | 472099 | 2021-02-19 | US | Florida | Gadsden | 12039 | 5365 | 80 | 0 | 5285 | 30.57796289 | -84.61915825 | 2021-02-20 05:22:51 | Gadsden, Florida, US |
1675370 | 1675370 | 2021-02-07 | US | Tennessee | Carter | 47019 | 5735 | 139 | 0 | 5285 | 36.28969086 | -82.12588974 | 2021-02-08 05:22:39 | Carter, Tennessee, US |
1674761 | 1674761 | 2021-02-07 | US | North Carolina | Duplin | 37061 | 5404 | 119 | 0 | 5285 | 34.93449805 | -77.93140529 | 2021-02-08 05:22:39 | Duplin, North Carolina, US |
1591351 | 1591351 | 2021-02-05 | US | Texas | Navarro | 48349 | 5706 | 96 | 0 | 5285 | 32.04620681 | -96.47428766 | 2021-02-06 05:23:55 | Navarro, Texas, US |
1678996 | 1678996 | 2021-02-01 | US | Oklahoma | Bryan | 40013 | 5330 | 45 | 0 | 5285 | 33.96472458 | -96.25903472 | 2021-02-02 05:22:49 | Bryan, Oklahoma, US |
437001 | 437001 | 2021-01-21 | US | Michigan | Lenawee | 26091 | 5370 | 85 | 0 | 5285 | 41.89475156 | -84.06603727 | 2021-01-22 05:22:10 | Lenawee, Michigan, US |
240165 | 240165 | 2021-01-18 | US | Tennessee | Dickson | 47043 | 5424 | 78 | 0 | 5285 | 36.14669837 | -87.35891709 | 2021-01-19 05:22:15 | Dickson, Tennessee, US |
1062082 | 1062082 | 2021-01-04 | Russia | Perm Krai | 31907 | 1173 | 25449 | 5285 | 58.5951603 | 56.3159546 | 2021-01-05 05:21:49 | Perm Krai, Russia | ||
2409764 | 2409764 | 2020-12-23 | US | Tennessee | Hamblen | 47063 | 5322 | 75 | 0 | 5285 | 36.21990035 | -83.26586179 | 2020-12-24 05:23:04 | Hamblen, Tennessee, US |
2977118 | 2977118 | 2020-12-09 | US | Missouri | Franklin | 29071 | 5380 | 95 | 0 | 5285 | 38.41127108 | -91.07522826 | 2020-12-10 05:26:19 | Franklin, Missouri, US |
1006768 | 1006768 | 2020-12-06 | US | Arkansas | Faulkner | 5045 | 5345 | 60 | 0 | 5285 | 35.14719007 | -92.33717519 | 2020-12-07 05:26:14 | Faulkner, Arkansas, US |
3566938 | 3566938 | 2020-11-29 | US | Alabama | Houston | 1069 | 5323 | 38 | 0 | 5285 | 31.15197924 | -85.29939599 | 2020-11-30 05:26:13 | Houston, Alabama, US |
2498727 | 2498727 | 2020-11-03 | US | Florida | Martin | 12085 | 5455 | 170 | 0 | 5285 | 27.0772071 | -80.43109784 | 2020-11-04 05:25:09 | Martin, Florida, US |
1455953 | 1455953 | 2020-10-27 | US | Virginia | Norfolk | 51710 | 5369 | 84 | 0 | 5285 | 36.89934014 | -76.26420872 | 2020-10-28 04:24:39 | Norfolk, Virginia, US |
3482529 | 3482529 | 2020-10-26 | US | New York | Dutchess | 36027 | 5450 | 165 | 0 | 5285 | 41.76486060000001 | -73.74356679 | 2020-10-27 04:24:45 | Dutchess, New York, US |
3654357 | 3654357 | 2020-10-24 | US | South Carolina | Anderson | 45007 | 5486 | 201 | 0 | 5285 | 34.51828081 | -82.63959517 | 2020-10-25 04:24:36 | Anderson, South Carolina, US |
1796786 | 1796786 | 2020-10-19 | US | New Jersey | Gloucester | 34015 | 5520 | 235 | 0 | 5285 | 39.71581067 | -75.13995546 | 2020-10-20 04:24:22 | Gloucester, New Jersey, US |
2513922 | 2513922 | 2020-10-03 | Brazil | Rio de Janeiro | 271575 | 18749 | 247541 | 5285 | -22.9068 | -43.1729 | 2020-10-04 04:23:44 | Rio de Janeiro, Brazil | ||
814697 | 814697 | 2020-09-05 | US | Indiana | St. Joseph | 18141 | 5391 | 106 | 0 | 5285 | 41.61756781 | -86.29040834 | 2020-09-06 04:28:33 | St. Joseph, Indiana, US |
194731 | 194731 | 2020-08-31 | US | Florida | Bay | 12005 | 5363 | 78 | 0 | 5285 | 30.26548745 | -85.62122584 | 2020-09-01 04:28:31 | Bay, Florida, US |
3932595 | 3932595 | 2020-08-30 | US | California | Solano | 6095 | 5317 | 34 | 0 | 5285 | 38.26827353 | -121.9357113 | 2020-08-31 04:28:27 | Solano, California, US |
610257 | 610257 | 2020-08-29 | US | California | Solano | 6095 | 5317 | 34 | 0 | 5285 | 38.26827353 | -121.9357113 | 2020-08-30 04:28:22 | Solano, California, US |
2513276 | 2513276 | 2020-08-27 | US | Texas | Hays | 48209 | 4957 | 55 | 0 | 5285 | 30.05669873 | -98.02944344 | 2020-08-28 04:28:11 | Hays, Texas, US |
840219 | 840219 | 2020-08-17 | US | Oregon | Multnomah | 41051 | 5387 | 102 | 0 | 5285 | 45.54747959 | -122.4169351 | 2020-08-18 04:27:56 | Multnomah, Oregon, US |
145897 | 145897 | 2020-08-15 | Greece | 6858 | 226 | 1347 | 5285 | 39.0742 | 21.8243 | 2020-08-16 04:27:42 | Greece | |||
3182019 | 3182019 | 2020-07-28 | US | New Jersey | Burlington | 34005 | 5756 | 471 | 0 | 5285 | 39.87681124 | -74.66927768 | 2020-07-29 04:35:11 | Burlington, New Jersey, US |
3435088 | 3435088 | 2020-07-11 | US | California | Sacramento | 6067 | 5374 | 84 | 0 | 5285 | 38.45106826 | -121.34253740000001 | 2020-07-12 04:34:30 | Sacramento, California, US |
228549 | 228549 | 2020-04-30 | US | Massachusetts | Worcester | 25027 | 5550 | 265 | 0 | 5285 | 42.35026951 | -71.90493363 | 2020-05-01 02:32:28 | Worcester, 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]);