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

1,663 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: latitude, longitude, combined_key, day (date), last_update (date)

province_or_state 1

  • Cook Islands 850

country_or_region 1

  • New Zealand · 1,663 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1733605 1733605 2022-05-20 New Zealand Cook Islands     5543 1 0   -21.2367 -159.7777 2022-05-21 04:20:58 Cook Islands, New Zealand
1733606 1733606 2022-05-20 New Zealand       1094192 997 0   -40.9006 174.886 2022-05-21 04:20:58 New Zealand
2573023 2573023 2022-05-19 New Zealand Cook Islands     5508 1 0   -21.2367 -159.7777 2022-05-20 04:20:57 Cook Islands, New Zealand
2573024 2573024 2022-05-19 New Zealand       1087466 990 0   -40.9006 174.886 2022-05-20 04:20:57 New Zealand
1432409 1432409 2022-05-18 New Zealand Cook Islands     5508 1 0   -21.2367 -159.7777 2022-05-19 04:20:54 Cook Islands, New Zealand
1432410 1432410 2022-05-18 New Zealand       1079557 973 0   -40.9006 174.886 2022-05-19 04:20:54 New Zealand
1599685 1599685 2022-05-17 New Zealand Cook Islands     5480 1 0   -21.2367 -159.7777 2022-05-18 04:20:50 Cook Islands, New Zealand
1599686 1599686 2022-05-17 New Zealand       1070373 967 0   -40.9006 174.886 2022-05-18 04:20:50 New Zealand
2425803 2425803 2022-05-16 New Zealand Cook Islands     5443 1 0   -21.2367 -159.7777 2022-05-17 04:20:59 Cook Islands, New Zealand
2425804 2425804 2022-05-16 New Zealand       1060710 937 0   -40.9006 174.886 2022-05-17 04:20:59 New Zealand
1317127 1317127 2022-05-15 New Zealand Cook Islands     5410 1 0   -21.2367 -159.7777 2022-05-16 04:20:47 Cook Islands, New Zealand
1317128 1317128 2022-05-15 New Zealand       1050797 929 0   -40.9006 174.886 2022-05-16 04:20:47 New Zealand
2632310 2632310 2022-05-14 New Zealand Cook Islands     5410 1 0   -21.2367 -159.7777 2022-05-15 04:20:53 Cook Islands, New Zealand
2632311 2632311 2022-05-14 New Zealand       1043683 923 0   -40.9006 174.886 2022-05-15 04:20:53 New Zealand
2671492 2671492 2022-05-13 New Zealand Cook Islands     5410 1 0   -21.2367 -159.7777 2022-05-14 04:20:48 Cook Islands, New Zealand
2671493 2671493 2022-05-13 New Zealand       1037855 909 0   -40.9006 174.886 2022-05-14 04:20:48 New Zealand
1896361 1896361 2022-05-12 New Zealand Cook Islands     5390 1 0   -21.2367 -159.7777 2022-05-13 04:20:51 Cook Islands, New Zealand
1896362 1896362 2022-05-12 New Zealand       1030733 892 0   -40.9006 174.886 2022-05-13 04:20:51 New Zealand
1369310 1369310 2022-05-11 New Zealand Cook Islands     5367 1 0   -21.2367 -159.7777 2022-05-12 04:20:54 Cook Islands, New Zealand
1369311 1369311 2022-05-11 New Zealand       1023205 863 0   -40.9006 174.886 2022-05-12 04:20:54 New Zealand
1979082 1979082 2022-05-10 New Zealand Cook Islands     5336 1 0   -21.2367 -159.7777 2022-05-11 04:20:48 Cook Islands, New Zealand
1979083 1979083 2022-05-10 New Zealand       1013721 855 0   -40.9006 174.886 2022-05-11 04:20:48 New Zealand
1053542 1053542 2022-05-09 New Zealand Cook Islands     5306 1 0   -21.2367 -159.7777 2022-05-10 04:20:50 Cook Islands, New Zealand
1053543 1053543 2022-05-09 New Zealand       1005674 826 0   -40.9006 174.886 2022-05-10 04:20:50 New Zealand
2457340 2457340 2022-05-08 New Zealand Cook Islands     5267 1 0   -21.2367 -159.7777 2022-05-09 04:20:54 Cook Islands, New Zealand
2457341 2457341 2022-05-08 New Zealand       996417 812 0   -40.9006 174.886 2022-05-09 04:20:54 New Zealand
1127403 1127403 2022-05-07 New Zealand Cook Islands     5267 1 0   -21.2367 -159.7777 2022-05-08 04:20:49 Cook Islands, New Zealand
1127404 1127404 2022-05-07 New Zealand       989946 810 0   -40.9006 174.886 2022-05-08 04:20:49 New Zealand
1916414 1916414 2022-05-06 New Zealand Cook Islands     5267 1 0   -21.2367 -159.7777 2022-05-07 04:21:09 Cook Islands, New Zealand
1916415 1916415 2022-05-06 New Zealand       984218 808 0   -40.9006 174.886 2022-05-07 04:21:09 New Zealand
3008079 3008079 2022-05-05 New Zealand Cook Islands     5246 1 0   -21.2367 -159.7777 2022-05-06 04:21:00 Cook Islands, New Zealand
3008080 3008080 2022-05-05 New Zealand       977380 797 0   -40.9006 174.886 2022-05-06 04:21:00 New Zealand
2066262 2066262 2022-05-04 New Zealand Cook Islands     5229 1 0   -21.2367 -159.7777 2022-05-05 04:20:55 Cook Islands, New Zealand
2066263 2066263 2022-05-04 New Zealand       969959 774 0   -40.9006 174.886 2022-05-05 04:20:55 New Zealand
1709546 1709546 2022-05-03 New Zealand Cook Islands     5200 1 0   -21.2367 -159.7777 2022-05-04 04:20:59 Cook Islands, New Zealand
1709547 1709547 2022-05-03 New Zealand       961262 753 0   -40.9006 174.886 2022-05-04 04:20:59 New Zealand
1385345 1385345 2022-05-02 New Zealand Cook Islands     5116 1 0   -21.2367 -159.7777 2022-05-03 04:21:00 Cook Islands, New Zealand
1385346 1385346 2022-05-02 New Zealand       952697 731 0   -40.9006 174.886 2022-05-03 04:21:00 New Zealand
513375 513375 2022-05-01 New Zealand Cook Islands     5070 1 0   -21.2367 -159.7777 2022-05-02 04:21:10 Cook Islands, New Zealand
513376 513376 2022-05-01 New Zealand       943428 713 0   -40.9006 174.886 2022-05-02 04:21:10 New Zealand
611805 611805 2022-04-30 New Zealand Cook Islands     5031 1 0   -21.2367 -159.7777 2022-05-01 04:20:57 Cook Islands, New Zealand
611806 611806 2022-04-30 New Zealand       936697 707 0   -40.9006 174.886 2022-05-01 04:20:57 New Zealand
318945 318945 2022-04-29 New Zealand Cook Islands     5031 1 0   -21.2367 -159.7777 2022-04-30 04:21:05 Cook Islands, New Zealand
318946 318946 2022-04-29 New Zealand       930969 702 0   -40.9006 174.886 2022-04-30 04:21:05 New Zealand
2972013 2972013 2022-04-28 New Zealand Cook Islands     4990 1 0   -21.2367 -159.7777 2022-04-29 04:20:59 Cook Islands, New Zealand
2972014 2972014 2022-04-28 New Zealand       923847 696 0   -40.9006 174.886 2022-04-29 04:20:59 New Zealand
1021419 1021419 2022-04-27 New Zealand Cook Islands     4932 1 0   -21.2367 -159.7777 2022-04-28 04:20:47 Cook Islands, New Zealand
1021420 1021420 2022-04-27 New Zealand       915522 683 0   -40.9006 174.886 2022-04-28 04:20:47 New Zealand
1005334 1005334 2022-04-26 New Zealand Cook Islands     4854 1 0   -21.2367 -159.7777 2022-04-27 04:20:52 Cook Islands, New Zealand
1005335 1005335 2022-04-26 New Zealand       906397 671 0   -40.9006 174.886 2022-04-27 04:20:52 New Zealand
1045522 1045522 2022-04-25 New Zealand Cook Islands     4727 1 0   -21.2367 -159.7777 2022-04-26 04:20:51 Cook Islands, New Zealand
1045523 1045523 2022-04-25 New Zealand       896495 649 0   -40.9006 174.886 2022-04-26 04:20:51 New Zealand
1830124 1830124 2022-04-24 New Zealand Cook Islands     4727 0 0   -21.2367 -159.7777 2022-04-25 04:20:56 Cook Islands, New Zealand
1830125 1830125 2022-04-24 New Zealand       890039 644 0   -40.9006 174.886 2022-04-25 04:20:56 New Zealand
2608796 2608796 2022-04-23 New Zealand Cook Islands     4609 0 0   -21.2367 -159.7777 2022-04-24 04:20:56 Cook Islands, New Zealand
2608797 2608797 2022-04-23 New Zealand       884289 636 0   -40.9006 174.886 2022-04-24 04:20:56 New Zealand
788630 788630 2022-04-22 New Zealand Cook Islands     4609 0 0   -21.2367 -159.7777 2022-04-23 04:20:50 Cook Islands, New Zealand
788631 788631 2022-04-22 New Zealand       878575 627 0   -40.9006 174.886 2022-04-23 04:20:50 New Zealand
3086410 3086410 2022-04-21 New Zealand Cook Islands     4490 0 0   -21.2367 -159.7777 2022-04-22 04:20:45 Cook Islands, New Zealand
3086411 3086411 2022-04-21 New Zealand       870591 610 0   -40.9006 174.886 2022-04-22 04:20:45 New Zealand
1630958 1630958 2022-04-20 New Zealand Cook Islands     4404 0 0   -21.2367 -159.7777 2022-04-21 04:20:46 Cook Islands, New Zealand
1630959 1630959 2022-04-20 New Zealand       861118 600 0   -40.9006 174.886 2022-04-21 04:20:46 New Zealand
198710 198710 2022-04-19 New Zealand Cook Islands     4201 0 0   -21.2367 -159.7777 2022-04-20 04:20:45 Cook Islands, New Zealand
198711 198711 2022-04-19 New Zealand       850747 582 0   -40.9006 174.886 2022-04-20 04:20:45 New Zealand
2726791 2726791 2022-04-18 New Zealand Cook Islands     3941 0 0   -21.2367 -159.7777 2022-04-19 04:21:00 Cook Islands, New Zealand
2726792 2726792 2022-04-18 New Zealand       831149 564 0   -40.9006 174.886 2022-04-19 04:21:00 New Zealand
740371 740371 2022-04-17 New Zealand Cook Islands     3941 0 0   -21.2367 -159.7777 2022-04-18 04:21:12 Cook Islands, New Zealand
740372 740372 2022-04-17 New Zealand       831149 564 0   -40.9006 174.886 2022-04-18 04:21:12 New Zealand
2294576 2294576 2022-04-16 New Zealand Cook Islands     3941 0 0   -21.2367 -159.7777 2022-04-17 04:20:59 Cook Islands, New Zealand
2294577 2294577 2022-04-16 New Zealand       824867 554 0   -40.9006 174.886 2022-04-17 04:20:59 New Zealand
2493348 2493348 2022-04-15 New Zealand Cook Islands     3788 0 0   -21.2367 -159.7777 2022-04-16 04:20:48 Cook Islands, New Zealand
2493349 2493349 2022-04-15 New Zealand       818882 543 0   -40.9006 174.886 2022-04-16 04:20:48 New Zealand
1217547 1217547 2022-04-14 New Zealand Cook Islands     3788 0 0   -21.2367 -159.7777 2022-04-15 04:20:57 Cook Islands, New Zealand
1217548 1217548 2022-04-14 New Zealand       813070 534 0   -40.9006 174.886 2022-04-15 04:20:57 New Zealand
1135424 1135424 2022-04-13 New Zealand Cook Islands     3688 0 0   -21.2367 -159.7777 2022-04-13 23:21:06 Cook Islands, New Zealand
1135425 1135425 2022-04-13 New Zealand       795606 497 0   -40.9006 174.886 2022-04-13 23:21:06 New Zealand
1487474 1487474 2022-04-12 New Zealand Cook Islands     3584 0 0   -21.2367 -159.7777 2022-04-13 04:21:03 Cook Islands, New Zealand
1487475 1487475 2022-04-12 New Zealand       795606 497 0   -40.9006 174.886 2022-04-13 04:21:03 New Zealand
190690 190690 2022-04-11 New Zealand Cook Islands     3449 0 0   -21.2367 -159.7777 2022-04-12 04:20:49 Cook Islands, New Zealand
190691 190691 2022-04-11 New Zealand       786058 483 0   -40.9006 174.886 2022-04-12 04:20:49 New Zealand
2988057 2988057 2022-04-10 New Zealand Cook Islands     3171 0 0   -21.2367 -159.7777 2022-04-11 04:21:02 Cook Islands, New Zealand
2988058 2988058 2022-04-10 New Zealand       774928 469 0   -40.9006 174.886 2022-04-11 04:21:02 New Zealand
1475443 1475443 2022-04-09 New Zealand Cook Islands     3171 0 0   -21.2367 -159.7777 2022-04-10 04:20:52 Cook Islands, New Zealand
1475444 1475444 2022-04-09 New Zealand       767295 457 0   -40.9006 174.886 2022-04-10 04:20:52 New Zealand
1203194 1203194 2022-04-08 New Zealand Cook Islands     3171 0 0   -21.2367 -159.7777 2022-04-09 04:20:42 Cook Islands, New Zealand
1203195 1203195 2022-04-08 New Zealand       760540 445 0   -40.9006 174.886 2022-04-09 04:20:42 New Zealand
2121925 2121925 2022-04-07 New Zealand Cook Islands     3035 0 0   -21.2367 -159.7777 2022-04-08 04:20:48 Cook Islands, New Zealand
2121926 2121926 2022-04-07 New Zealand       741987 426 0   -40.9006 174.886 2022-04-08 04:20:48 New Zealand
631090 631090 2022-04-06 New Zealand Cook Islands     2875 0 0   -21.2367 -159.7777 2022-04-07 04:20:53 Cook Islands, New Zealand
631091 631091 2022-04-06 New Zealand       741987 426 0   -40.9006 174.886 2022-04-07 04:20:53 New Zealand
2984046 2984046 2022-04-05 New Zealand Cook Islands     2715 0 0   -21.2367 -159.7777 2022-04-06 04:20:49 Cook Islands, New Zealand
2984047 2984047 2022-04-05 New Zealand       730285 404 0   -40.9006 174.886 2022-04-06 04:20:49 New Zealand
302903 302903 2022-04-04 New Zealand Cook Islands     2526 0 0   -21.2367 -159.7777 2022-04-05 04:20:48 Cook Islands, New Zealand
302904 302904 2022-04-04 New Zealand       717650 386 0   -40.9006 174.886 2022-04-05 04:20:48 New Zealand
310925 310925 2022-04-03 New Zealand Cook Islands     2296 0 0   -21.2367 -159.7777 2022-04-04 04:20:51 Cook Islands, New Zealand
310926 310926 2022-04-03 New Zealand       703467 363 0   -40.9006 174.886 2022-04-04 04:20:51 New Zealand
812627 812627 2022-04-02 New Zealand Cook Islands     2118 0 0   -21.2367 -159.7777 2022-04-03 04:20:48 Cook Islands, New Zealand
812628 812628 2022-04-02 New Zealand       693219 350 0   -40.9006 174.886 2022-04-03 04:20:48 New Zealand
2695329 2695329 2022-04-01 New Zealand Cook Islands     2118 0 0   -21.2367 -159.7777 2022-04-02 04:20:47 Cook Islands, New Zealand
2695330 2695330 2022-04-01 New Zealand       684374 330 0   -40.9006 174.886 2022-04-02 04:20:47 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 482.116ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette