johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where confirmed = 30 and province_or_state = "Greenland" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12216 | 12216 | 2021-01-26 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-27 05:23:41 | Greenland, Denmark | ||
181916 | 181916 | 2021-02-21 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-22 05:24:21 | Greenland, Denmark | ||
237117 | 237117 | 2021-01-18 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-19 05:22:15 | Greenland, Denmark | ||
280059 | 280059 | 2021-02-24 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-25 05:24:57 | Greenland, Denmark | ||
340151 | 340151 | 2021-02-03 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-04 05:22:26 | Greenland, Denmark | ||
435232 | 435232 | 2021-01-21 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-22 05:22:10 | Greenland, Denmark | ||
471288 | 471288 | 2021-02-19 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-20 05:22:51 | Greenland, Denmark | ||
530582 | 530582 | 2021-02-22 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-23 05:23:41 | Greenland, Denmark | ||
613564 | 613564 | 2021-02-08 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-09 05:23:30 | Greenland, Denmark | ||
742190 | 742190 | 2021-02-20 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-21 05:24:33 | Greenland, Denmark | ||
790259 | 790259 | 2021-02-04 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-05 05:22:38 | Greenland, Denmark | ||
908054 | 908054 | 2021-01-19 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-20 05:21:54 | Greenland, Denmark | ||
974794 | 974794 | 2021-02-06 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-07 05:23:00 | Greenland, Denmark | ||
998315 | 998315 | 2021-03-01 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-03-02 05:23:30 | Greenland, Denmark | ||
1089951 | 1089951 | 2021-03-03 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-03-04 05:24:24 | Greenland, Denmark | ||
1093964 | 1093964 | 2021-01-20 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-21 05:22:01 | Greenland, Denmark | ||
1152997 | 1152997 | 2021-02-18 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-19 05:24:16 | Greenland, Denmark | ||
1338151 | 1338151 | 2021-02-15 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-16 05:24:38 | Greenland, Denmark | ||
1459635 | 1459635 | 2021-01-31 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-01 05:22:53 | Greenland, Denmark | ||
1527773 | 1527773 | 2021-02-09 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-10 05:22:41 | Greenland, Denmark | ||
1588052 | 1588052 | 2021-02-05 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-06 05:23:55 | Greenland, Denmark | ||
1672333 | 1672333 | 2021-02-07 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-08 05:22:39 | Greenland, Denmark | ||
1676347 | 1676347 | 2021-02-01 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-02 05:22:49 | Greenland, Denmark | ||
1684377 | 1684377 | 2021-02-02 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-03 05:22:52 | Greenland, Denmark | ||
1759172 | 1759172 | 2021-01-24 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-25 05:22:16 | Greenland, Denmark | ||
1857881 | 1857881 | 2021-02-25 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-26 05:22:40 | Greenland, Denmark | ||
1897030 | 1897030 | 2021-01-29 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-30 05:22:49 | Greenland, Denmark | ||
1936327 | 1936327 | 2021-02-23 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-24 05:29:16 | Greenland, Denmark | ||
2183459 | 2183459 | 2021-02-26 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-27 05:22:28 | Greenland, Denmark | ||
2211543 | 2211543 | 2021-01-30 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-31 05:22:42 | Greenland, Denmark | ||
2283302 | 2283302 | 2021-02-14 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-15 05:24:49 | Greenland, Denmark | ||
2367373 | 2367373 | 2021-02-28 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-03-01 05:23:01 | Greenland, Denmark | ||
2426779 | 2426779 | 2021-01-23 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-24 05:22:35 | Greenland, Denmark | ||
2466681 | 2466681 | 2021-01-22 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-23 05:22:03 | Greenland, Denmark | ||
2481846 | 2481846 | 2021-01-28 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-29 05:22:23 | Greenland, Denmark | ||
2567540 | 2567540 | 2021-01-25 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-26 05:22:02 | Greenland, Denmark | ||
2637598 | 2637598 | 2021-02-11 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-12 05:23:29 | Greenland, Denmark | ||
2677702 | 2677702 | 2021-02-13 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-14 05:23:43 | Greenland, Denmark | ||
3050052 | 3050052 | 2021-02-16 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-17 05:23:10 | Greenland, Denmark | ||
3065875 | 3065875 | 2021-02-27 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-28 05:22:20 | Greenland, Denmark | ||
3101317 | 3101317 | 2021-01-16 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-17 05:22:17 | Greenland, Denmark | ||
3153481 | 3153481 | 2021-01-27 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-01-28 05:22:24 | Greenland, Denmark | ||
3254023 | 3254023 | 2021-03-02 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-03-03 05:23:28 | Greenland, Denmark | ||
3503234 | 3503234 | 2021-01-17 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-18 05:22:34 | Greenland, Denmark | ||
3515279 | 3515279 | 2021-01-15 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-16 05:22:40 | Greenland, Denmark | ||
3539335 | 3539335 | 2021-02-12 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-13 05:22:12 | Greenland, Denmark | ||
3600917 | 3600917 | 2021-02-17 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-18 05:22:58 | Greenland, Denmark | ||
3879452 | 3879452 | 2021-01-14 | Denmark | Greenland | 30 | 0 | 29 | 1 | 71.7069 | -42.6043 | 2021-01-15 05:22:24 | Greenland, Denmark | ||
3978453 | 3978453 | 2021-02-10 | Denmark | Greenland | 30 | 0 | 30 | 0 | 71.7069 | -42.6043 | 2021-02-11 05:23:55 | Greenland, Denmark |
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]);