johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,284,537 rows where country_or_region = "US" sorted by longitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region 1
- US · 3,284,537 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▲ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2769 | 2769 | 2021-12-02 | US | Northern Mariana Islands | 69 | 1062 | 3 | 0 | 15.0979 | 145.6739 | 2021-12-03 04:23:05 | Northern Mariana Islands, US | ||
6784 | 6784 | 2021-10-28 | US | Northern Mariana Islands | 69 | 298 | 3 | 0 | 15.0979 | 145.6739 | 2021-10-29 04:22:03 | Northern Mariana Islands, US | ||
10756 | 10756 | 2020-10-25 | US | Northern Mariana Islands | 69 | 88 | 2 | 0 | 86 | 15.0979 | 145.6739 | 2020-10-26 04:25:02 | Northern Mariana Islands, US | |
14769 | 14769 | 2021-01-26 | US | Northern Mariana Islands | 69 | 132 | 2 | 0 | 130 | 15.0979 | 145.6739 | 2021-01-27 05:23:41 | Northern Mariana Islands, US | |
18791 | 18791 | 2021-09-18 | US | Northern Mariana Islands | 69 | 258 | 2 | 0 | 15.0979 | 145.6739 | 2021-09-19 04:21:34 | Northern Mariana Islands, US | ||
22802 | 22802 | 2021-05-28 | US | Northern Mariana Islands | 69 | 183 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-29 04:20:41 | Northern Mariana Islands, US | ||
26840 | 26840 | 2022-03-20 | US | Northern Mariana Islands | 69 | 10689 | 31 | 0 | 15.0979 | 145.6739 | 2022-03-21 04:20:50 | Northern Mariana Islands, US | ||
30855 | 30855 | 2021-11-11 | US | Northern Mariana Islands | 69 | 381 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-12 04:22:01 | Northern Mariana Islands, US | ||
34851 | 34851 | 2021-08-25 | US | Northern Mariana Islands | 69 | 229 | 2 | 0 | 15.0979 | 145.6739 | 2021-08-26 04:21:28 | Northern Mariana Islands, US | ||
38861 | 38861 | 2021-04-12 | US | Northern Mariana Islands | 69 | 160 | 2 | 0 | 15.0979 | 145.6739 | 2021-04-13 04:20:37 | Northern Mariana Islands, US | ||
43125 | 43125 | 2020-04-13 | US | Northern Mariana Islands | 11 | 2 | 0 | 9 | 15.0979 | 145.6739 | 2020-04-13 23:07:54 | Northern Mariana Islands, US | ||
46147 | 46147 | 2021-11-02 | US | Northern Mariana Islands | 69 | 329 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-03 06:22:09 | Northern Mariana Islands, US | ||
50224 | 50224 | 2020-04-17 | US | Northern Mariana Islands | 69 | 13 | 2 | 0 | 11 | 15.0979 | 145.6739 | 2020-04-17 23:30:52 | Northern Mariana Islands, US | |
53223 | 53223 | 2021-05-29 | US | Northern Mariana Islands | 69 | 183 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-30 04:20:55 | Northern Mariana Islands, US | ||
57234 | 57234 | 2021-03-07 | US | Northern Mariana Islands | 69 | 145 | 2 | 0 | 15.0979 | 145.6739 | 2021-03-08 05:24:48 | Northern Mariana Islands, US | ||
62041 | 62041 | 2020-07-23 | US | Northern Mariana Islands | 69 | 38 | 2 | 0 | 36 | 15.0979 | 145.6739 | 2020-07-24 05:30:40 | Northern Mariana Islands, US | |
65505 | 65505 | 2022-11-12 | US | Northern Mariana Islands | 69 | 13219 | 41 | 0 | 15.0979 | 145.6739 | 2022-11-13 04:21:14 | Northern Mariana Islands, US | ||
69496 | 69496 | 2021-09-01 | US | Northern Mariana Islands | 69 | 243 | 2 | 0 | 15.0979 | 145.6739 | 2021-09-02 04:21:15 | Northern Mariana Islands, US | ||
73530 | 73530 | 2022-02-07 | US | Northern Mariana Islands | 69 | 6332 | 23 | 0 | 15.0979 | 145.6739 | 2022-02-08 04:21:15 | Northern Mariana Islands, US | ||
77516 | 77516 | 2020-12-03 | US | Northern Mariana Islands | 69 | 106 | 2 | 0 | 104 | 15.0979 | 145.6739 | 2020-12-04 05:27:27 | Northern Mariana Islands, US | |
81510 | 81510 | 2020-10-14 | US | Northern Mariana Islands | 69 | 77 | 2 | 0 | 75 | 15.0979 | 145.6739 | 2020-10-15 04:24:28 | Northern Mariana Islands, US | |
85526 | 85526 | 2021-05-25 | US | Northern Mariana Islands | 69 | 181 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-26 04:20:35 | Northern Mariana Islands, US | ||
89564 | 89564 | 2021-11-09 | US | Northern Mariana Islands | 69 | 369 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-10 04:21:38 | Northern Mariana Islands, US | ||
93582 | 93582 | 2022-07-23 | US | Northern Mariana Islands | 69 | 12398 | 35 | 0 | 15.0979 | 145.6739 | 2022-07-24 04:20:47 | Northern Mariana Islands, US | ||
98390 | 98390 | 2020-08-04 | US | Northern Mariana Islands | 69 | 46 | 2 | 0 | 44 | 15.0979 | 145.6739 | 2020-08-05 04:34:43 | Northern Mariana Islands, US | |
101765 | 101765 | 2022-01-14 | US | Northern Mariana Islands | 69 | 3868 | 21 | 0 | 15.0979 | 145.6739 | 2022-01-15 04:21:07 | Northern Mariana Islands, US | ||
105761 | 105761 | 2021-08-15 | US | Northern Mariana Islands | 69 | 214 | 2 | 0 | 15.0979 | 145.6739 | 2021-08-16 04:21:31 | Northern Mariana Islands, US | ||
109885 | 109885 | 2021-06-19 | US | Northern Mariana Islands | 69 | 183 | 2 | 0 | 15.0979 | 145.6739 | 2021-06-20 04:21:48 | Northern Mariana Islands, US | ||
114164 | 114164 | 2020-05-08 | US | Northern Mariana Islands | 69 | 15 | 2 | 0 | 13 | 15.0979 | 145.6739 | 2020-05-09 02:32:35 | Northern Mariana Islands, US | |
117192 | 117192 | 2022-09-06 | US | Northern Mariana Islands | 69 | 13120 | 40 | 0 | 15.0979 | 145.6739 | 2022-09-07 04:20:59 | Northern Mariana Islands, US | ||
121982 | 121982 | 2020-07-19 | US | Northern Mariana Islands | 69 | 37 | 2 | 0 | 35 | 15.0979 | 145.6739 | 2020-07-20 05:34:40 | Northern Mariana Islands, US | |
125131 | 125131 | 2020-11-18 | US | Northern Mariana Islands | 69 | 103 | 2 | 0 | 101 | 15.0979 | 145.6739 | 2020-11-19 05:25:23 | Northern Mariana Islands, US | |
129172 | 129172 | 2022-01-09 | US | Northern Mariana Islands | 69 | 3598 | 19 | 0 | 15.0979 | 145.6739 | 2022-01-10 04:22:07 | Northern Mariana Islands, US | ||
133193 | 133193 | 2022-10-04 | US | Northern Mariana Islands | 69 | 13171 | 40 | 0 | 15.0979 | 145.6739 | 2022-10-05 04:23:06 | Northern Mariana Islands, US | ||
137388 | 137388 | 2020-04-29 | US | Northern Mariana Islands | 69 | 14 | 2 | 0 | 12 | 15.0979 | 145.6739 | 2020-04-30 02:32:27 | Northern Mariana Islands, US | |
140410 | 140410 | 2021-12-04 | US | Northern Mariana Islands | 69 | 1182 | 5 | 0 | 15.0979 | 145.6739 | 2021-12-05 04:22:25 | Northern Mariana Islands, US | ||
144428 | 144428 | 2022-07-09 | US | Northern Mariana Islands | 69 | 11829 | 35 | 0 | 15.0979 | 145.6739 | 2022-07-10 04:20:54 | Northern Mariana Islands, US | ||
148383 | 148383 | 2020-08-15 | US | Northern Mariana Islands | 69 | 50 | 2 | 0 | 48 | 15.0979 | 145.6739 | 2020-08-16 04:27:42 | Northern Mariana Islands, US | |
152423 | 152423 | 2021-11-29 | US | Northern Mariana Islands | 69 | 812 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-30 04:22:53 | Northern Mariana Islands, US | ||
156410 | 156410 | 2021-01-08 | US | Northern Mariana Islands | 69 | 125 | 2 | 0 | 123 | 15.0979 | 145.6739 | 2021-01-09 05:22:18 | Northern Mariana Islands, US | |
160452 | 160452 | 2022-03-29 | US | Northern Mariana Islands | 69 | 11065 | 33 | 0 | 15.0979 | 145.6739 | 2022-03-30 04:20:45 | Northern Mariana Islands, US | ||
164467 | 164467 | 2021-11-19 | US | Northern Mariana Islands | 69 | 438 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-20 04:22:17 | Northern Mariana Islands, US | ||
168485 | 168485 | 2022-06-21 | US | Northern Mariana Islands | 69 | 11569 | 34 | 0 | 15.0979 | 145.6739 | 2022-06-22 04:20:54 | Northern Mariana Islands, US | ||
172475 | 172475 | 2021-04-16 | US | Northern Mariana Islands | 69 | 162 | 2 | 0 | 15.0979 | 145.6739 | 2021-04-17 04:20:40 | Northern Mariana Islands, US | ||
177300 | 177300 | 2020-07-27 | US | Northern Mariana Islands | 69 | 40 | 2 | 0 | 38 | 15.0979 | 145.6739 | 2020-07-28 04:58:43 | Northern Mariana Islands, US | |
180461 | 180461 | 2021-09-02 | US | Northern Mariana Islands | 69 | 243 | 2 | 0 | 15.0979 | 145.6739 | 2021-09-03 04:21:20 | Northern Mariana Islands, US | ||
184469 | 184469 | 2021-02-21 | US | Northern Mariana Islands | 69 | 143 | 2 | 0 | 141 | 15.0979 | 145.6739 | 2021-02-22 05:24:21 | Northern Mariana Islands, US | |
188510 | 188510 | 2022-02-13 | US | Northern Mariana Islands | 69 | 7530 | 23 | 0 | 15.0979 | 145.6739 | 2022-02-14 04:20:51 | Northern Mariana Islands, US | ||
192496 | 192496 | 2021-01-11 | US | Northern Mariana Islands | 69 | 125 | 2 | 0 | 123 | 15.0979 | 145.6739 | 2021-01-12 05:22:15 | Northern Mariana Islands, US | |
196487 | 196487 | 2020-08-31 | US | Northern Mariana Islands | 69 | 56 | 2 | 0 | 54 | 15.0979 | 145.6739 | 2020-09-01 04:28:31 | Northern Mariana Islands, US | |
200702 | 200702 | 2022-10-19 | US | Northern Mariana Islands | 69 | 13171 | 40 | 0 | 15.0979 | 145.6739 | 2022-10-20 04:22:59 | Northern Mariana Islands, US | ||
204683 | 204683 | 2020-12-25 | US | Northern Mariana Islands | 69 | 122 | 2 | 0 | 120 | 15.0979 | 145.6739 | 2020-12-26 05:22:28 | Northern Mariana Islands, US | |
208669 | 208669 | 2020-08-19 | US | Northern Mariana Islands | 69 | 54 | 2 | 0 | 52 | 15.0979 | 145.6739 | 2020-08-20 04:27:43 | Northern Mariana Islands, US | |
212665 | 212665 | 2020-10-29 | US | Northern Mariana Islands | 69 | 92 | 2 | 0 | 90 | 15.0979 | 145.6739 | 2020-10-30 04:24:49 | Northern Mariana Islands, US | |
217256 | 217256 | 2020-06-08 | US | Northern Mariana Islands | 69 | 27 | 2 | 0 | 25 | 15.0979 | 145.6739 | 2020-06-09 03:33:03 | Northern Mariana Islands, US | |
220423 | 220423 | 2022-12-26 | US | Northern Mariana Islands | 69 | 13274 | 41 | 0 | 15.0979 | 145.6739 | 2022-12-27 04:21:07 | Northern Mariana Islands, US | ||
224435 | 224435 | 2022-05-09 | US | Northern Mariana Islands | 69 | 11305 | 34 | 0 | 15.0979 | 145.6739 | 2022-05-10 04:20:50 | Northern Mariana Islands, US | ||
228641 | 228641 | 2020-04-30 | US | Northern Mariana Islands | 69 | 14 | 2 | 0 | 12 | 15.0979 | 145.6739 | 2020-05-01 02:32:28 | Northern Mariana Islands, US | |
231667 | 231667 | 2022-05-31 | US | Northern Mariana Islands | 69 | 11333 | 34 | 0 | 15.0979 | 145.6739 | 2022-06-01 04:20:55 | Northern Mariana Islands, US | ||
235682 | 235682 | 2022-02-11 | US | Northern Mariana Islands | 69 | 7199 | 23 | 0 | 15.0979 | 145.6739 | 2022-02-12 04:21:06 | Northern Mariana Islands, US | ||
239669 | 239669 | 2021-01-18 | US | Northern Mariana Islands | 69 | 129 | 2 | 0 | 127 | 15.0979 | 145.6739 | 2021-01-19 05:22:15 | Northern Mariana Islands, US | |
243686 | 243686 | 2021-04-02 | US | Northern Mariana Islands | 69 | 159 | 2 | 0 | 15.0979 | 145.6739 | 2021-04-03 04:20:44 | Northern Mariana Islands, US | ||
247704 | 247704 | 2021-08-17 | US | Northern Mariana Islands | 69 | 219 | 2 | 0 | 15.0979 | 145.6739 | 2021-08-18 04:21:35 | Northern Mariana Islands, US | ||
251718 | 251718 | 2021-09-04 | US | Northern Mariana Islands | 69 | 243 | 2 | 0 | 15.0979 | 145.6739 | 2021-09-05 04:21:33 | Northern Mariana Islands, US | ||
255754 | 255754 | 2022-09-08 | US | Northern Mariana Islands | 69 | 13147 | 40 | 0 | 15.0979 | 145.6739 | 2022-09-09 04:21:11 | Northern Mariana Islands, US | ||
259773 | 259773 | 2022-12-10 | US | Northern Mariana Islands | 69 | 13227 | 41 | 0 | 15.0979 | 145.6739 | 2022-12-11 04:20:50 | Northern Mariana Islands, US | ||
263972 | 263972 | 2022-03-15 | US | Northern Mariana Islands | 69 | 10535 | 31 | 0 | 15.0979 | 145.6739 | 2022-03-16 04:20:50 | Northern Mariana Islands, US | ||
268350 | 268350 | 2020-05-21 | US | Northern Mariana Islands | 69 | 21 | 2 | 0 | 19 | 15.0979 | 145.6739 | 2020-05-22 02:36:51 | Northern Mariana Islands, US | |
271602 | 271602 | 2020-04-28 | US | Northern Mariana Islands | 69 | 14 | 2 | 0 | 12 | 15.0979 | 145.6739 | 2020-04-29 02:32:29 | Northern Mariana Islands, US | |
274581 | 274581 | 2020-11-10 | US | Northern Mariana Islands | 69 | 100 | 2 | 0 | 98 | 15.0979 | 145.6739 | 2020-11-11 05:25:30 | Northern Mariana Islands, US | |
278622 | 278622 | 2021-11-03 | US | Northern Mariana Islands | 69 | 330 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-04 04:22:20 | Northern Mariana Islands, US | ||
282612 | 282612 | 2021-02-24 | US | Northern Mariana Islands | 69 | 143 | 2 | 0 | 141 | 15.0979 | 145.6739 | 2021-02-25 05:24:57 | Northern Mariana Islands, US | |
287263 | 287263 | 2020-06-15 | US | Northern Mariana Islands | 69 | 30 | 2 | 0 | 28 | 15.0979 | 145.6739 | 2020-06-16 04:33:09 | Northern Mariana Islands, US | |
290434 | 290434 | 2021-10-31 | US | Northern Mariana Islands | 69 | 312 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-01 04:22:01 | Northern Mariana Islands, US | ||
294456 | 294456 | 2022-11-15 | US | Northern Mariana Islands | 69 | 13219 | 41 | 0 | 15.0979 | 145.6739 | 2022-11-16 04:21:09 | Northern Mariana Islands, US | ||
298447 | 298447 | 2021-07-15 | US | Northern Mariana Islands | 69 | 187 | 2 | 0 | 15.0979 | 145.6739 | 2021-07-16 04:21:22 | Northern Mariana Islands, US | ||
303135 | 303135 | 2020-07-01 | US | Northern Mariana Islands | 69 | 30 | 2 | 0 | 28 | 15.0979 | 145.6739 | 2020-07-02 04:33:46 | Northern Mariana Islands, US | |
306308 | 306308 | 2022-04-16 | US | Northern Mariana Islands | 69 | 11203 | 34 | 0 | 15.0979 | 145.6739 | 2022-04-17 04:20:59 | Northern Mariana Islands, US | ||
310328 | 310328 | 2022-12-13 | US | Northern Mariana Islands | 69 | 13227 | 41 | 0 | 15.0979 | 145.6739 | 2022-12-14 04:21:04 | Northern Mariana Islands, US | ||
314344 | 314344 | 2022-11-13 | US | Northern Mariana Islands | 69 | 13219 | 41 | 0 | 15.0979 | 145.6739 | 2022-11-14 04:21:09 | Northern Mariana Islands, US | ||
318356 | 318356 | 2022-02-12 | US | Northern Mariana Islands | 69 | 7353 | 23 | 0 | 15.0979 | 145.6739 | 2022-02-13 04:21:00 | Northern Mariana Islands, US | ||
322376 | 322376 | 2022-10-30 | US | Northern Mariana Islands | 69 | 13171 | 40 | 0 | 15.0979 | 145.6739 | 2022-10-31 04:21:36 | Northern Mariana Islands, US | ||
327077 | 327077 | 2020-07-20 | US | Northern Mariana Islands | 69 | 37 | 2 | 0 | 35 | 15.0979 | 145.6739 | 2020-07-21 04:38:46 | Northern Mariana Islands, US | |
330350 | 330350 | 2022-12-27 | US | Northern Mariana Islands | 69 | 13274 | 41 | 0 | 15.0979 | 145.6739 | 2022-12-28 04:21:04 | Northern Mariana Islands, US | ||
334341 | 334341 | 2021-08-04 | US | Northern Mariana Islands | 69 | 198 | 2 | 0 | 15.0979 | 145.6739 | 2021-08-05 04:21:51 | Northern Mariana Islands, US | ||
338376 | 338376 | 2022-03-18 | US | Northern Mariana Islands | 69 | 10689 | 31 | 0 | 15.0979 | 145.6739 | 2022-03-19 04:20:47 | Northern Mariana Islands, US | ||
342704 | 342704 | 2021-02-03 | US | Northern Mariana Islands | 69 | 133 | 2 | 0 | 131 | 15.0979 | 145.6739 | 2021-02-04 05:22:26 | Northern Mariana Islands, US | |
346695 | 346695 | 2020-09-14 | US | Northern Mariana Islands | 69 | 60 | 2 | 0 | 58 | 15.0979 | 145.6739 | 2020-09-15 03:22:50 | Northern Mariana Islands, US | |
350740 | 350740 | 2022-12-14 | US | Northern Mariana Islands | 69 | 13227 | 41 | 0 | 15.0979 | 145.6739 | 2022-12-15 04:20:58 | Northern Mariana Islands, US | ||
354725 | 354725 | 2021-03-11 | US | Northern Mariana Islands | 69 | 146 | 2 | 0 | 15.0979 | 145.6739 | 2021-03-12 05:26:50 | Northern Mariana Islands, US | ||
358766 | 358766 | 2022-03-11 | US | Northern Mariana Islands | 69 | 10379 | 30 | 0 | 15.0979 | 145.6739 | 2022-03-12 04:20:50 | Northern Mariana Islands, US | ||
362782 | 362782 | 2022-05-07 | US | Northern Mariana Islands | 69 | 11281 | 34 | 0 | 15.0979 | 145.6739 | 2022-05-08 04:20:49 | Northern Mariana Islands, US | ||
367483 | 367483 | 2020-07-16 | US | Northern Mariana Islands | 69 | 36 | 2 | 0 | 34 | 15.0979 | 145.6739 | 2020-07-17 04:34:50 | Northern Mariana Islands, US | |
371455 | 371455 | 2020-08-08 | US | Northern Mariana Islands | 69 | 47 | 2 | 0 | 45 | 15.0979 | 145.6739 | 2020-08-09 04:34:54 | Northern Mariana Islands, US | |
374640 | 374640 | 2022-09-13 | US | Northern Mariana Islands | 69 | 13155 | 40 | 0 | 15.0979 | 145.6739 | 2022-09-14 04:20:44 | Northern Mariana Islands, US | ||
378608 | 378608 | 2020-11-06 | US | Northern Mariana Islands | 69 | 98 | 2 | 0 | 96 | 15.0979 | 145.6739 | 2020-11-07 05:24:52 | Northern Mariana Islands, US | |
382624 | 382624 | 2021-04-30 | US | Northern Mariana Islands | 69 | 164 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-01 04:20:47 | Northern Mariana Islands, US | ||
386667 | 386667 | 2022-09-23 | US | Northern Mariana Islands | 69 | 13166 | 40 | 0 | 15.0979 | 145.6739 | 2022-09-24 04:21:40 | Northern Mariana Islands, US | ||
390654 | 390654 | 2021-04-04 | US | Northern Mariana Islands | 69 | 159 | 2 | 0 | 15.0979 | 145.6739 | 2021-04-05 04:20:35 | Northern Mariana Islands, US | ||
394662 | 394662 | 2020-11-27 | US | Northern Mariana Islands | 69 | 104 | 2 | 0 | 102 | 15.0979 | 145.6739 | 2020-11-28 05:25:50 | Northern Mariana Islands, 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]);