home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for johns_hopkins_csse_daily_reports
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

3,188 rows where country_or_region = "New Zealand" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: longitude, combined_key, day (date), last_update (date)

province_or_state 2

  • Cook Islands 1,073
  • Niue 1,073

country_or_region 1

  • New Zealand · 3,188 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2753041 2753041 2022-12-29 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-30 04:21:04 Cook Islands, New Zealand
2753042 2753042 2022-12-29 New Zealand Niue     458 0 0   -19.0544 -169.8672 2022-12-30 04:21:04 Niue, New Zealand
2753043 2753043 2022-12-29 New Zealand       2094354 2331 0   -40.9006 174.886 2022-12-30 04:21:04 New Zealand
1074047 1074047 2022-12-28 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-29 04:21:01 Cook Islands, New Zealand
1074048 1074048 2022-12-28 New Zealand Niue     439 0 0   -19.0544 -169.8672 2022-12-29 04:21:01 Niue, New Zealand
1074049 1074049 2022-12-28 New Zealand       2094354 2331 0   -40.9006 174.886 2022-12-29 04:21:01 New Zealand
328044 328044 2022-12-27 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-28 04:21:04 Cook Islands, New Zealand
328045 328045 2022-12-27 New Zealand Niue     421 0 0   -19.0544 -169.8672 2022-12-28 04:21:04 Niue, New Zealand
328046 328046 2022-12-27 New Zealand       2094354 2331 0   -40.9006 174.886 2022-12-28 04:21:04 New Zealand
218117 218117 2022-12-26 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-27 04:21:07 Cook Islands, New Zealand
218118 218118 2022-12-26 New Zealand Niue     378 0 0   -19.0544 -169.8672 2022-12-27 04:21:07 Niue, New Zealand
218119 218119 2022-12-26 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-27 04:21:07 New Zealand
3222574 3222574 2022-12-25 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-26 04:21:06 Cook Islands, New Zealand
3222575 3222575 2022-12-25 New Zealand Niue     378 0 0   -19.0544 -169.8672 2022-12-26 04:21:06 Niue, New Zealand
3222576 3222576 2022-12-25 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-26 04:21:06 New Zealand
1018488 1018488 2022-12-24 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-25 04:21:04 Cook Islands, New Zealand
1018489 1018489 2022-12-24 New Zealand Niue     362 0 0   -19.0544 -169.8672 2022-12-25 04:21:04 Niue, New Zealand
1018490 1018490 2022-12-24 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-25 04:21:04 New Zealand
690511 690511 2022-12-23 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-24 04:21:02 Cook Islands, New Zealand
690512 690512 2022-12-23 New Zealand Niue     349 0 0   -19.0544 -169.8672 2022-12-24 04:21:02 Niue, New Zealand
690513 690513 2022-12-23 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-24 04:21:02 New Zealand
2179721 2179721 2022-12-22 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-23 04:21:04 Cook Islands, New Zealand
2179722 2179722 2022-12-22 New Zealand Niue     335 0 0   -19.0544 -169.8672 2022-12-23 04:21:04 Niue, New Zealand
2179723 2179723 2022-12-22 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-23 04:21:04 New Zealand
451525 451525 2022-12-21 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-22 04:20:56 Cook Islands, New Zealand
451526 451526 2022-12-21 New Zealand Niue     314 0 0   -19.0544 -169.8672 2022-12-22 04:20:56 Niue, New Zealand
451527 451527 2022-12-21 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-22 04:20:56 New Zealand
2951524 2951524 2022-12-20 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-21 04:21:03 Cook Islands, New Zealand
2951525 2951525 2022-12-20 New Zealand Niue     291 0 0   -19.0544 -169.8672 2022-12-21 04:21:03 Niue, New Zealand
2951526 2951526 2022-12-20 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-21 04:21:03 New Zealand
3173926 3173926 2022-12-19 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-20 04:21:04 Cook Islands, New Zealand
3173927 3173927 2022-12-19 New Zealand Niue     263 0 0   -19.0544 -169.8672 2022-12-20 04:21:04 Niue, New Zealand
3173928 3173928 2022-12-19 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-20 04:21:04 New Zealand
1628443 1628443 2022-12-18 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-19 04:21:03 Cook Islands, New Zealand
1628444 1628444 2022-12-18 New Zealand Niue     226 0 0   -19.0544 -169.8672 2022-12-19 04:21:03 Niue, New Zealand
1628445 1628445 2022-12-18 New Zealand       2062384 2288 0   -40.9006 174.886 2022-12-19 04:21:03 New Zealand
503822 503822 2022-12-17 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-18 04:21:03 Cook Islands, New Zealand
503823 503823 2022-12-17 New Zealand Niue     226 0 0   -19.0544 -169.8672 2022-12-18 04:21:03 Niue, New Zealand
503824 503824 2022-12-17 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-18 04:21:03 New Zealand
3324394 3324394 2022-12-16 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-17 04:21:04 Cook Islands, New Zealand
3324395 3324395 2022-12-16 New Zealand Niue     216 0 0   -19.0544 -169.8672 2022-12-17 04:21:04 Niue, New Zealand
3324396 3324396 2022-12-16 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-17 04:21:04 New Zealand
542906 542906 2022-12-15 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-16 04:21:01 Cook Islands, New Zealand
542907 542907 2022-12-15 New Zealand Niue     212 0 0   -19.0544 -169.8672 2022-12-16 04:21:01 Niue, New Zealand
542908 542908 2022-12-15 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-16 04:21:01 New Zealand
348434 348434 2022-12-14 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-15 04:20:58 Cook Islands, New Zealand
348435 348435 2022-12-14 New Zealand Niue     209 0 0   -19.0544 -169.8672 2022-12-15 04:20:58 Niue, New Zealand
348436 348436 2022-12-14 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-15 04:20:58 New Zealand
308022 308022 2022-12-13 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-14 04:21:04 Cook Islands, New Zealand
308023 308023 2022-12-13 New Zealand Niue     203 0 0   -19.0544 -169.8672 2022-12-14 04:21:04 Niue, New Zealand
308024 308024 2022-12-13 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-14 04:21:04 New Zealand
1149083 1149083 2022-12-12 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-13 04:21:01 Cook Islands, New Zealand
1149084 1149084 2022-12-12 New Zealand Niue     198 0 0   -19.0544 -169.8672 2022-12-13 04:21:01 Niue, New Zealand
1149085 1149085 2022-12-12 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-13 04:21:01 New Zealand
868937 868937 2022-12-11 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-12 04:21:01 Cook Islands, New Zealand
868938 868938 2022-12-11 New Zealand Niue     191 0 0   -19.0544 -169.8672 2022-12-12 04:21:01 Niue, New Zealand
868939 868939 2022-12-11 New Zealand       2019685 2257 0   -40.9006 174.886 2022-12-12 04:21:01 New Zealand
257467 257467 2022-12-10 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-11 04:20:50 Cook Islands, New Zealand
257468 257468 2022-12-10 New Zealand Niue     191 0 0   -19.0544 -169.8672 2022-12-11 04:20:50 Niue, New Zealand
257469 257469 2022-12-10 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-11 04:20:50 New Zealand
3936181 3936181 2022-12-09 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-10 04:21:02 Cook Islands, New Zealand
3936182 3936182 2022-12-09 New Zealand Niue     189 0 0   -19.0544 -169.8672 2022-12-10 04:21:02 Niue, New Zealand
3936183 3936183 2022-12-09 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-10 04:21:02 New Zealand
3377513 3377513 2022-12-08 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-09 04:21:05 Cook Islands, New Zealand
3377514 3377514 2022-12-08 New Zealand Niue     187 0 0   -19.0544 -169.8672 2022-12-09 04:21:05 Niue, New Zealand
3377515 3377515 2022-12-08 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-09 04:21:05 New Zealand
1984784 1984784 2022-12-07 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-08 04:21:07 Cook Islands, New Zealand
1984785 1984785 2022-12-07 New Zealand Niue     180 0 0   -19.0544 -169.8672 2022-12-08 04:21:07 Niue, New Zealand
1984786 1984786 2022-12-07 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-08 04:21:07 New Zealand
3714307 3714307 2022-12-06 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-07 04:20:58 Cook Islands, New Zealand
3714308 3714308 2022-12-06 New Zealand Niue     180 0 0   -19.0544 -169.8672 2022-12-07 04:20:58 Niue, New Zealand
3714309 3714309 2022-12-06 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-07 04:20:58 New Zealand
2415012 2415012 2022-12-05 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-06 04:21:03 Cook Islands, New Zealand
2415013 2415013 2022-12-05 New Zealand Niue     172 0 0   -19.0544 -169.8672 2022-12-06 04:21:03 Niue, New Zealand
2415014 2415014 2022-12-05 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-06 04:21:03 New Zealand
718620 718620 2022-12-04 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-05 04:20:58 Cook Islands, New Zealand
718621 718621 2022-12-04 New Zealand Niue     169 0 0   -19.0544 -169.8672 2022-12-05 04:20:58 Niue, New Zealand
718622 718622 2022-12-04 New Zealand       1979614 2235 0   -40.9006 174.886 2022-12-05 04:20:58 New Zealand
2816909 2816909 2022-12-03 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-04 04:20:56 Cook Islands, New Zealand
2816910 2816910 2022-12-03 New Zealand Niue     164 0 0   -19.0544 -169.8672 2022-12-04 04:20:56 Niue, New Zealand
2816911 2816911 2022-12-03 New Zealand       1945117 2212 0   -40.9006 174.886 2022-12-04 04:20:56 New Zealand
833765 833765 2022-12-02 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-03 04:21:02 Cook Islands, New Zealand
833766 833766 2022-12-02 New Zealand Niue     156 0 0   -19.0544 -169.8672 2022-12-03 04:21:02 Niue, New Zealand
833767 833767 2022-12-02 New Zealand       1945117 2212 0   -40.9006 174.886 2022-12-03 04:21:02 New Zealand
2136295 2136295 2022-12-01 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-02 04:21:07 Cook Islands, New Zealand
2136296 2136296 2022-12-01 New Zealand Niue     147 0 0   -19.0544 -169.8672 2022-12-02 04:21:07 Niue, New Zealand
2136297 2136297 2022-12-01 New Zealand       1945117 2212 0   -40.9006 174.886 2022-12-02 04:21:07 New Zealand
1964711 1964711 2022-11-30 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-12-01 04:21:03 Cook Islands, New Zealand
1964712 1964712 2022-11-30 New Zealand Niue     136 0 0   -19.0544 -169.8672 2022-12-01 04:21:03 Niue, New Zealand
1964713 1964713 2022-11-30 New Zealand       1945117 2212 0   -40.9006 174.886 2022-12-01 04:21:03 New Zealand
2556725 2556725 2022-11-29 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-11-30 04:21:07 Cook Islands, New Zealand
2556726 2556726 2022-11-29 New Zealand Niue     124 0 0   -19.0544 -169.8672 2022-11-30 04:21:07 Niue, New Zealand
2556727 2556727 2022-11-29 New Zealand       1945117 2212 0   -40.9006 174.886 2022-11-30 04:21:07 New Zealand
1239799 1239799 2022-11-28 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-11-29 04:21:05 Cook Islands, New Zealand
1239800 1239800 2022-11-28 New Zealand Niue     117 0 0   -19.0544 -169.8672 2022-11-29 04:21:05 Niue, New Zealand
1239801 1239801 2022-11-28 New Zealand       1945117 2212 0   -40.9006 174.886 2022-11-29 04:21:05 New Zealand
3551787 3551787 2022-11-27 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-11-28 04:21:02 Cook Islands, New Zealand
3551788 3551788 2022-11-27 New Zealand Niue     108 0 0   -19.0544 -169.8672 2022-11-28 04:21:02 Niue, New Zealand
3551789 3551789 2022-11-27 New Zealand       1945117 2212 0   -40.9006 174.886 2022-11-28 04:21:02 New Zealand
2100267 2100267 2022-11-26 New Zealand Cook Islands     6389 1 0   -21.2367 -159.7777 2022-11-27 04:21:05 Cook Islands, New Zealand

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Queries took 444.065ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette