johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
76 rows where confirmed = 2 and province_or_state = "Cook Islands" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 1
- Cook Islands · 76 ✖
country_or_region 1
- New Zealand 76
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3820574 | 3820574 | 2022-02-16 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-17 04:20:56 | Cook Islands, New Zealand | |||
3671788 | 3671788 | 2022-02-15 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-16 04:21:10 | Cook Islands, New Zealand | |||
2641889 | 2641889 | 2022-02-14 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-15 04:21:09 | Cook Islands, New Zealand | |||
186206 | 186206 | 2022-02-13 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-14 04:20:51 | Cook Islands, New Zealand | |||
316052 | 316052 | 2022-02-12 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-13 04:21:00 | Cook Islands, New Zealand | |||
233378 | 233378 | 2022-02-11 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-12 04:21:06 | Cook Islands, New Zealand | |||
1464220 | 1464220 | 2022-02-10 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-11 04:21:09 | Cook Islands, New Zealand | |||
3074181 | 3074181 | 2022-02-09 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-10 04:21:14 | Cook Islands, New Zealand | |||
1362488 | 1362488 | 2022-02-08 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-09 04:21:04 | Cook Islands, New Zealand | |||
71226 | 71226 | 2022-02-07 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-08 04:21:15 | Cook Islands, New Zealand | |||
2012842 | 2012842 | 2022-02-06 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-07 04:21:05 | Cook Islands, New Zealand | |||
1294171 | 1294171 | 2022-02-05 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-06 04:21:00 | Cook Islands, New Zealand | |||
2327499 | 2327499 | 2022-02-04 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-05 04:21:05 | Cook Islands, New Zealand | |||
2474090 | 2474090 | 2022-02-03 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-04 04:21:10 | Cook Islands, New Zealand | |||
459515 | 459515 | 2022-02-02 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-03 04:21:21 | Cook Islands, New Zealand | |||
979084 | 979084 | 2022-02-01 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-02 04:21:09 | Cook Islands, New Zealand | |||
2657926 | 2657926 | 2022-01-31 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-01 04:21:11 | Cook Islands, New Zealand | |||
3300343 | 3300343 | 2022-01-30 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-31 04:21:09 | Cook Islands, New Zealand | |||
3062134 | 3062134 | 2022-01-29 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-30 04:21:26 | Cook Islands, New Zealand | |||
3810068 | 3810068 | 2022-01-28 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-29 04:21:10 | Cook Islands, New Zealand | |||
1779522 | 1779522 | 2022-01-27 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-28 04:21:09 | Cook Islands, New Zealand | |||
1318350 | 1318350 | 2022-01-26 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-27 04:21:19 | Cook Islands, New Zealand | |||
2052018 | 2052018 | 2022-01-25 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-26 04:21:07 | Cook Islands, New Zealand | |||
1227749 | 1227749 | 2022-01-24 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-25 04:21:05 | Cook Islands, New Zealand | |||
1141048 | 1141048 | 2022-01-23 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-24 04:21:12 | Cook Islands, New Zealand | |||
2832966 | 2832966 | 2022-01-22 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-23 04:21:13 | Cook Islands, New Zealand | |||
3425084 | 3425084 | 2022-01-21 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-22 04:21:13 | Cook Islands, New Zealand | |||
1960692 | 1960692 | 2022-01-20 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-21 04:21:09 | Cook Islands, New Zealand | |||
3226587 | 3226587 | 2022-01-19 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-20 04:21:07 | Cook Islands, New Zealand | |||
3464312 | 3464312 | 2022-01-18 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-19 04:21:23 | Cook Islands, New Zealand | |||
1472251 | 1472251 | 2022-01-17 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-18 04:21:04 | Cook Islands, New Zealand | |||
554925 | 554925 | 2022-01-16 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-17 04:21:08 | Cook Islands, New Zealand | |||
3840646 | 3840646 | 2022-01-15 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-16 04:21:12 | Cook Islands, New Zealand | |||
99461 | 99461 | 2022-01-14 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-15 04:21:07 | Cook Islands, New Zealand | |||
3687616 | 3687616 | 2022-01-13 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-14 04:21:54 | Cook Islands, New Zealand | |||
3613200 | 3613200 | 2022-01-12 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-13 08:00:09 | Cook Islands, New Zealand | |||
1113725 | 1113725 | 2022-01-11 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-12 04:21:44 | Cook Islands, New Zealand | |||
1692453 | 1692453 | 2022-01-10 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-11 04:22:01 | Cook Islands, New Zealand | |||
126868 | 126868 | 2022-01-09 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-10 04:22:07 | Cook Islands, New Zealand | |||
1215703 | 1215703 | 2022-01-08 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-09 04:21:46 | Cook Islands, New Zealand | |||
1389796 | 1389796 | 2022-01-07 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-08 04:21:53 | Cook Islands, New Zealand | |||
2610183 | 2610183 | 2022-01-06 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-07 04:22:09 | Cook Islands, New Zealand | |||
1282125 | 1282125 | 2022-01-05 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-06 04:22:09 | Cook Islands, New Zealand | |||
1286141 | 1286141 | 2022-01-04 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-05 04:21:59 | Cook Islands, New Zealand | |||
1700485 | 1700485 | 2022-01-03 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-04 04:22:17 | Cook Islands, New Zealand | |||
3519568 | 3519568 | 2022-01-02 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-03 02:22:25 | Cook Islands, New Zealand | |||
2167698 | 2167698 | 2022-01-01 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-02 04:20:52 | Cook Islands, New Zealand | |||
2777129 | 2777129 | 2021-12-31 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-01 04:22:14 | Cook Islands, New Zealand | |||
3998786 | 3998786 | 2021-12-30 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-31 04:21:50 | Cook Islands, New Zealand | |||
1668593 | 1668593 | 2021-12-29 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-30 04:21:25 | Cook Islands, New Zealand | |||
1432702 | 1432702 | 2021-12-28 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-29 03:21:43 | Cook Islands, New Zealand | |||
730663 | 730663 | 2021-12-27 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-28 04:21:47 | Cook Islands, New Zealand | |||
2111835 | 2111835 | 2021-12-26 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-27 04:21:58 | Cook Islands, New Zealand | |||
3605207 | 3605207 | 2021-12-25 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-26 04:21:50 | Cook Islands, New Zealand | |||
2963525 | 2963525 | 2021-12-24 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-25 04:21:37 | Cook Islands, New Zealand | |||
3816557 | 3816557 | 2021-12-23 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-24 04:21:34 | Cook Islands, New Zealand | |||
798565 | 798565 | 2021-12-22 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-23 04:21:21 | Cook Islands, New Zealand | |||
3828605 | 3828605 | 2021-12-21 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-22 04:21:54 | Cook Islands, New Zealand | |||
1254908 | 1254908 | 2021-12-20 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-21 03:21:27 | Cook Islands, New Zealand | |||
2903851 | 2903851 | 2021-12-19 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-20 04:21:43 | Cook Islands, New Zealand | |||
1258924 | 1258924 | 2021-12-18 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-19 04:21:11 | Cook Islands, New Zealand | |||
2398952 | 2398952 | 2021-12-17 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-18 02:22:20 | Cook Islands, New Zealand | |||
1716490 | 1716490 | 2021-12-16 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-17 04:22:14 | Cook Islands, New Zealand | |||
3496324 | 3496324 | 2021-12-15 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-16 04:22:11 | Cook Islands, New Zealand | |||
2088109 | 2088109 | 2021-12-14 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-15 03:22:16 | Cook Islands, New Zealand | |||
782526 | 782526 | 2021-12-13 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-14 04:22:38 | Cook Islands, New Zealand | |||
1660561 | 1660561 | 2021-12-12 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-13 04:22:02 | Cook Islands, New Zealand | |||
1664577 | 1664577 | 2021-12-11 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-12 04:22:12 | Cook Islands, New Zealand | |||
3655729 | 3655729 | 2021-12-10 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-11 04:22:45 | Cook Islands, New Zealand | |||
1078060 | 1078060 | 2021-12-09 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-10 04:22:28 | Cook Islands, New Zealand | |||
550909 | 550909 | 2021-12-08 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-09 04:22:49 | Cook Islands, New Zealand | |||
404429 | 404429 | 2021-12-07 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-08 04:22:46 | Cook Islands, New Zealand | |||
1030511 | 1030511 | 2021-12-06 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-07 04:22:34 | Cook Islands, New Zealand | |||
1740674 | 1740674 | 2021-12-05 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-06 04:22:34 | Cook Islands, New Zealand | |||
138106 | 138106 | 2021-12-04 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-05 04:22:25 | Cook Islands, New Zealand | |||
2195759 | 2195759 | 2021-12-03 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-04 04:22:18 | Cook Islands, New Zealand |
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]);