johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,040 rows where province_or_state = "Grand Princess" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
371284 | 371284 | 2020-08-08 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-09 04:34:54 | Grand Princess, US | |
371829 | 371829 | 2020-08-08 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
371947 | 371947 | 2022-09-13 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
373109 | 373109 | 2022-09-13 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
375951 | 375951 | 2020-11-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-07 05:24:52 | Grand Princess, Canada | ||
377078 | 377078 | 2020-11-06 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
379959 | 379959 | 2021-04-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
381093 | 381093 | 2021-04-30 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
383974 | 383974 | 2022-09-23 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
385136 | 385136 | 2022-09-23 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
387989 | 387989 | 2021-04-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
389123 | 389123 | 2021-04-04 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
392003 | 392003 | 2020-11-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-28 05:25:50 | Grand Princess, Canada | ||
393132 | 393132 | 2020-11-27 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
396015 | 396015 | 2022-10-07 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
397177 | 397177 | 2022-10-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
400030 | 400030 | 2021-06-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
401168 | 401168 | 2021-06-29 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
404044 | 404044 | 2021-12-07 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
405202 | 405202 | 2021-12-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
408060 | 408060 | 2021-07-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
409198 | 409198 | 2021-07-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
415261 | 415261 | 2020-07-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-06 04:33:57 | Grand Princess, Canada | ||
415262 | 415262 | 2020-07-05 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-06 04:33:57 | Grand Princess, US | |
418721 | 418721 | 2020-04-18 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 2020-04-18 22:40:03 | Grand Princess, Canada | ||
418722 | 418722 | 2020-04-18 | US | Grand Princess | 99999 | 103 | 0 | 0 | 103 | 37.64894 | 0.0 | 2020-04-18 22:32:47 | Grand Princess, US | |
419086 | 419086 | 2022-09-18 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
420248 | 420248 | 2022-09-18 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
423101 | 423101 | 2021-10-10 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
424258 | 424258 | 2021-10-10 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
427106 | 427106 | 2020-09-07 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-08 04:28:25 | Grand Princess, Canada | ||
428227 | 428227 | 2020-09-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
431108 | 431108 | 2022-11-03 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
432270 | 432270 | 2022-11-03 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
435123 | 435123 | 2021-01-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
436254 | 436254 | 2021-01-21 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
442443 | 442443 | 2020-07-26 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-27 04:35:02 | Grand Princess, US | |
442988 | 442988 | 2020-07-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
443105 | 443105 | 2021-10-20 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
444262 | 444262 | 2021-10-20 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
447121 | 447121 | 2021-11-17 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
448279 | 448279 | 2021-11-17 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
451138 | 451138 | 2022-12-21 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
452300 | 452300 | 2022-12-21 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
458468 | 458468 | 2020-08-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-08 04:34:53 | Grand Princess, US | |
459013 | 459013 | 2020-08-07 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
459130 | 459130 | 2022-02-02 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
460288 | 460288 | 2022-02-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
463147 | 463147 | 2022-05-02 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
464305 | 464305 | 2022-05-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
467162 | 467162 | 2021-10-07 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
468319 | 468319 | 2021-10-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
471178 | 471178 | 2021-02-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
472310 | 472310 | 2021-02-19 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
475193 | 475193 | 2022-06-26 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
476352 | 476352 | 2022-06-26 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
479341 | 479341 | 2022-11-08 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
480503 | 480503 | 2022-11-08 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
483356 | 483356 | 2021-07-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
484494 | 484494 | 2021-07-19 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
487371 | 487371 | 2022-11-25 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
488533 | 488533 | 2022-11-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
491386 | 491386 | 2021-10-14 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
492543 | 492543 | 2021-10-14 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
495402 | 495402 | 2021-11-06 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
496560 | 496560 | 2021-11-06 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
499419 | 499419 | 2022-04-02 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
500577 | 500577 | 2022-04-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
503435 | 503435 | 2022-12-17 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
504597 | 504597 | 2022-12-17 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
507450 | 507450 | 2021-08-14 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
508588 | 508588 | 2021-08-14 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
511464 | 511464 | 2021-08-19 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
512602 | 512602 | 2021-08-19 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
515479 | 515479 | 2022-10-15 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
516641 | 516641 | 2022-10-15 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
522259 | 522259 | 2020-04-21 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 2020-04-21 23:38:53 | Grand Princess, Canada | ||
522260 | 522260 | 2020-04-21 | US | Grand Princess | 99999 | 103 | 0 | 0 | 103 | 37.64894 | 0.0 | 2020-04-21 23:30:50 | Grand Princess, US | |
522623 | 522623 | 2021-06-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
523758 | 523758 | 2021-06-09 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
529823 | 529823 | 2020-07-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-05 04:33:46 | Grand Princess, Canada | ||
529824 | 529824 | 2020-07-04 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-05 04:33:46 | Grand Princess, US | |
530472 | 530472 | 2021-02-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
531604 | 531604 | 2021-02-22 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
534486 | 534486 | 2021-10-27 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
535643 | 535643 | 2021-10-27 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
538503 | 538503 | 2022-10-26 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
539665 | 539665 | 2022-10-26 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
542519 | 542519 | 2022-12-15 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
543681 | 543681 | 2022-12-15 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
546523 | 546523 | 2020-09-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-13 04:30:52 | Grand Princess, Canada | ||
547644 | 547644 | 2020-09-12 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
550524 | 550524 | 2021-12-08 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
551682 | 551682 | 2021-12-08 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
554540 | 554540 | 2022-01-16 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
555698 | 555698 | 2022-01-16 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
558557 | 558557 | 2022-06-16 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
559716 | 559716 | 2022-06-16 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
562733 | 562733 | 2021-06-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
563870 | 563870 | 2021-06-22 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, 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]);