johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where active = 6306 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20073 | 20073 | 2021-05-28 | Austria | 638376 | 12889 | 626815 | 6306 | 47.5162 | 14.5501 | 2021-05-29 04:20:41 | Austria | |||
3393336 | 3393336 | 2021-04-28 | India | Chandigarh | 41122 | 457 | 34359 | 6306 | 30.733839 | 76.76827800000002 | 2021-04-29 04:20:55 | Chandigarh, India | ||
185668 | 185668 | 2021-02-21 | Ukraine | Lviv Oblast | 76154 | 2228 | 67620 | 6306 | 49.8397 | 24.0297 | 2021-02-22 05:24:21 | Lviv Oblast, Ukraine | ||
3604383 | 3604383 | 2021-02-17 | US | Virginia | Hanover | 51085 | 6411 | 105 | 0 | 6306 | 37.7583355 | -77.49464673 | 2021-02-18 05:22:58 | Hanover, Virginia, US |
1591535 | 1591535 | 2021-02-05 | US | Virginia | Lynchburg | 51680 | 6388 | 82 | 0 | 6306 | 37.40021399 | -79.19888138 | 2021-02-06 05:23:55 | Lynchburg, Virginia, US |
2568456 | 2568456 | 2021-01-25 | US | Georgia | Fayette | 13113 | 6411 | 105 | 0 | 6306 | 33.41357794 | -84.49089434 | 2021-01-26 05:22:02 | Fayette, Georgia, US |
240805 | 240805 | 2021-01-18 | US | Wisconsin | Portage | 55097 | 6366 | 60 | 0 | 6306 | 44.47558711 | -89.50152965 | 2021-01-19 05:22:15 | Portage, Wisconsin, US |
1010981 | 1010981 | 2020-12-30 | US | Florida | Citrus | 12017 | 6567 | 261 | 0 | 6306 | 28.84804315 | -82.47614748 | 2020-12-31 05:22:49 | Citrus, Florida, US |
204914 | 204914 | 2020-12-25 | US | Pennsylvania | Fayette | 42051 | 6393 | 87 | 0 | 6306 | 39.92041012 | -79.64291195 | 2020-12-26 05:22:28 | Fayette, Pennsylvania, US |
3772969 | 3772969 | 2020-12-22 | US | Texas | Guadalupe | 48187 | 6488 | 100 | 0 | 6306 | 29.58165339 | -97.94786822 | 2020-12-23 05:22:03 | Guadalupe, Texas, US |
3850744 | 3850744 | 2020-12-13 | US | Tennessee | Madison | 47113 | 6529 | 128 | 0 | 6306 | 35.61181957 | -88.84076036 | 2020-12-14 05:26:27 | Madison, Tennessee, US |
1633012 | 1633012 | 2020-12-05 | US | Florida | Martin | 12085 | 6485 | 179 | 0 | 6306 | 27.0772071 | -80.43109784 | 2020-12-06 05:26:18 | Martin, Florida, US |
3441021 | 3441021 | 2020-11-11 | Russia | Khabarovsk Krai | 18877 | 145 | 12426 | 6306 | 51.6312684 | 136.121524 | 2020-11-12 05:25:55 | Khabarovsk Krai, Russia | ||
1728411 | 1728411 | 2020-11-08 | Guatemala | 111262 | 3821 | 101135 | 6306 | 15.7835 | -90.2308 | 2020-11-09 05:25:45 | Guatemala | |||
376858 | 376858 | 2020-11-06 | US | Florida | Clay | 12019 | 6433 | 127 | 0 | 6306 | 29.98319144 | -81.85609986 | 2020-11-07 05:24:52 | Clay, Florida, US |
1822665 | 1822665 | 2020-10-04 | Denmark | 29680 | 658 | 22716 | 6306 | 56.2639 | 9.5018 | 2020-10-05 04:23:33 | Denmark | |||
3178127 | 3178127 | 2020-08-18 | Netherlands | Gelderland | 7129 | 687 | 0 | 6306 | 52.061738 | 5.939114 | 2020-08-19 04:27:00 | Gelderland, Netherlands | ||
1556881 | 1556881 | 2020-08-16 | US | Idaho | Canyon | 16027 | 6362 | 56 | 0 | 6306 | 43.61970148 | -116.7095499 | 2020-08-17 04:27:20 | Canyon, Idaho, US |
2804773 | 2804773 | 2020-08-02 | US | Pennsylvania | Bucks | 42017 | 6885 | 579 | 0 | 6306 | 40.33682119 | -75.10836643 | 2020-08-03 04:34:35 | Bucks, Pennsylvania, US |
3185555 | 3185555 | 2020-07-28 | Moldova | 23521 | 753 | 16462 | 6306 | 47.4116 | 28.3699 | 2020-07-29 04:35:11 | Moldova | |||
1501341 | 1501341 | 2020-07-25 | US | New Jersey | Morris | 34027 | 7133 | 827 | 0 | 6306 | 40.86095313 | -74.54553709999998 | 2020-07-26 04:35:00 | Morris, New Jersey, US |
1500885 | 1500885 | 2020-07-25 | US | Indiana | Lake | 18089 | 6590 | 284 | 0 | 6306 | 41.41874274 | -87.38277575 | 2020-07-26 04:35:00 | Lake, Indiana, US |
1508070 | 1508070 | 2020-06-22 | US | Nebraska | Douglas | 31055 | 6386 | 80 | 0 | 6306 | 41.29518299 | -96.15085305 | 2020-06-23 04:33:22 | Douglas, Nebraska, US |
3863877 | 3863877 | 2020-06-03 | US | New Jersey | Camden | 34007 | 6652 | 346 | 0 | 6306 | 39.80343818 | -74.96388753 | 2020-06-04 02:33:14 | Camden, New Jersey, US |
1102059 | 1102059 | 2020-05-25 | US | Massachusetts | Bristol | 25005 | 6681 | 375 | 0 | 6306 | 41.79228404 | -71.10872211 | 2020-05-26 02:32:35 | Bristol, 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]);