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 day
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2039723 | 2039723 | 2020-06-27 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-06-28 04:34:04 | Grand Princess, US | |
2306387 | 2306387 | 2020-06-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-29 04:33:44 | Grand Princess, Canada | ||
2306388 | 2306388 | 2020-06-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-06-29 04:33:44 | Grand Princess, US | |
2632824 | 2632824 | 2020-06-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-30 04:33:48 | Grand Princess, Canada | ||
2632825 | 2632825 | 2020-06-29 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-06-30 04:33:48 | Grand Princess, US | |
2974347 | 2974347 | 2020-06-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-01 04:33:52 | Grand Princess, Canada | ||
2974348 | 2974348 | 2020-06-30 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-01 04:33:52 | Grand Princess, US | |
302969 | 302969 | 2020-07-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-02 04:33:46 | Grand Princess, Canada | ||
302970 | 302970 | 2020-07-01 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-02 04:33:46 | Grand Princess, US | |
3045278 | 3045278 | 2020-07-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-03 04:33:54 | Grand Princess, Canada | ||
3045279 | 3045279 | 2020-07-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-03 04:33:54 | Grand Princess, US | |
2234484 | 2234484 | 2020-07-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-04 04:33:51 | Grand Princess, Canada | ||
2234485 | 2234485 | 2020-07-03 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-04 04:33:51 | 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 | |
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 | |
2684796 | 2684796 | 2020-07-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-07 04:34:00 | Grand Princess, Canada | ||
2684797 | 2684797 | 2020-07-06 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-07 04:34:00 | Grand Princess, US | |
887236 | 887236 | 2020-07-07 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-08 05:33:48 | Grand Princess, Canada | ||
887237 | 887237 | 2020-07-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-08 05:33:48 | Grand Princess, US | |
2222627 | 2222627 | 2020-07-08 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-09 04:34:23 | Grand Princess, Canada | ||
2222628 | 2222628 | 2020-07-08 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-09 04:34:23 | Grand Princess, US | |
1005411 | 1005411 | 2020-07-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-10 04:34:24 | Grand Princess, Canada | ||
1005412 | 1005412 | 2020-07-09 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-10 04:34:24 | Grand Princess, US | |
3237426 | 3237426 | 2020-07-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-11 04:34:26 | Grand Princess, Canada | ||
3237427 | 3237427 | 2020-07-10 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-11 04:34:26 | Grand Princess, US | |
3435928 | 3435928 | 2020-07-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-12 04:34:30 | Grand Princess, Canada | ||
3435929 | 3435929 | 2020-07-11 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-12 04:34:30 | Grand Princess, US | |
3737533 | 3737533 | 2020-07-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 04:43:04 | Grand Princess, Canada | ||
3737534 | 3737534 | 2020-07-12 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-13 04:43:04 | Grand Princess, US | |
3491271 | 3491271 | 2020-07-13 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-14 04:34:46 | Grand Princess, US | |
3491806 | 3491806 | 2020-07-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2158630 | 2158630 | 2020-07-14 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-15 04:34:39 | Grand Princess, US | |
2159164 | 2159164 | 2020-07-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2747986 | 2747986 | 2020-07-15 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-16 04:44:59 | Grand Princess, US | |
2748520 | 2748520 | 2020-07-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
367318 | 367318 | 2020-07-16 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-17 04:34:50 | Grand Princess, US | |
367852 | 367852 | 2020-07-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2708503 | 2708503 | 2020-07-17 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-18 04:34:45 | Grand Princess, US | |
2709046 | 2709046 | 2020-07-17 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
3205201 | 3205201 | 2020-07-18 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-19 04:34:58 | Grand Princess, US | |
3205744 | 3205744 | 2020-07-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
121812 | 121812 | 2020-07-19 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-20 05:34:40 | Grand Princess, US | |
122356 | 122356 | 2020-07-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
326907 | 326907 | 2020-07-20 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-21 04:38:46 | Grand Princess, US | |
327539 | 327539 | 2020-07-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
1707416 | 1707416 | 2020-07-21 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-22 04:34:42 | Grand Princess, US | |
1707960 | 1707960 | 2020-07-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
844677 | 844677 | 2020-07-22 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-23 05:15:04 | Grand Princess, US | |
845221 | 845221 | 2020-07-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
61879 | 61879 | 2020-07-23 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-24 05:30:40 | Grand Princess, US | |
62433 | 62433 | 2020-07-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2563657 | 2563657 | 2020-07-24 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-25 04:47:39 | Grand Princess, US | |
2564202 | 2564202 | 2020-07-24 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
1502687 | 1502687 | 2020-07-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-26 04:35:00 | Grand Princess, US | |
1503232 | 1503232 | 2020-07-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
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 | ||
177130 | 177130 | 2020-07-27 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-28 04:58:43 | Grand Princess, US | |
177675 | 177675 | 2020-07-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
3185078 | 3185078 | 2020-07-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-29 04:35:11 | Grand Princess, US | |
3185624 | 3185624 | 2020-07-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2958462 | 2958462 | 2020-07-29 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-30 04:35:05 | Grand Princess, US | |
2959007 | 2959007 | 2020-07-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
1928294 | 1928294 | 2020-07-30 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-31 04:35:18 | Grand Princess, US | |
1928839 | 1928839 | 2020-07-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
3264587 | 3264587 | 2020-07-31 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-01 04:36:27 | Grand Princess, US | |
3265130 | 3265130 | 2020-07-31 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
753422 | 753422 | 2020-08-01 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-02 04:34:47 | Grand Princess, US | |
753965 | 753965 | 2020-08-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2807854 | 2807854 | 2020-08-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-03 04:34:35 | Grand Princess, US | |
2808397 | 2808397 | 2020-08-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
2740102 | 2740102 | 2020-08-03 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 04:41:59 | Grand Princess, US | |
2740645 | 2740645 | 2020-08-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
98219 | 98219 | 2020-08-04 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-05 04:34:43 | Grand Princess, US | |
98763 | 98763 | 2020-08-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
3792983 | 3792983 | 2020-08-05 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-06 04:35:02 | Grand Princess, US | |
3793528 | 3793528 | 2020-08-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
3612153 | 3612153 | 2020-08-06 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-07 04:35:11 | Grand Princess, US | |
3612698 | 3612698 | 2020-08-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
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 | ||
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 | ||
3923116 | 3923116 | 2020-08-09 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-10 04:34:55 | Grand Princess, US | |
3923661 | 3923661 | 2020-08-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
1920307 | 1920307 | 2020-08-10 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-11 04:35:08 | Grand Princess, US | |
1920852 | 1920852 | 2020-08-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
662069 | 662069 | 2020-08-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-12 04:27:29 | Grand Princess, Canada | ||
663235 | 663235 | 2020-08-11 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
3531220 | 3531220 | 2020-08-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-13 04:29:15 | Grand Princess, Canada | ||
3532340 | 3532340 | 2020-08-12 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
582601 | 582601 | 2020-08-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-14 04:51:19 | Grand Princess, Canada | ||
583721 | 583721 | 2020-08-13 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
1612017 | 1612017 | 2020-08-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-15 04:27:31 | Grand Princess, Canada | ||
1613137 | 1613137 | 2020-08-14 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
145742 | 145742 | 2020-08-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-16 04:27:42 | Grand Princess, Canada | ||
146862 | 146862 | 2020-08-15 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
1555740 | 1555740 | 2020-08-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-17 04:27:20 | Grand Princess, Canada |
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]);