johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,184 rows where confirmed = 27 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1649946 | 1649946 | 2022-06-23 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-24 04:20:58 | Unassigned, Maine, US | |
2980825 | 2980825 | 2022-06-13 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-14 04:20:52 | Unassigned, Maine, US | |
2236951 | 2236951 | 2022-06-12 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-13 04:21:14 | Unassigned, Maine, US | |
3143149 | 3143149 | 2022-06-11 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-12 04:20:53 | Unassigned, Maine, US | |
3889187 | 3889187 | 2022-06-06 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-07 04:21:08 | Unassigned, Maine, US | |
3508956 | 3508956 | 2022-06-05 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-06 04:20:57 | Unassigned, Maine, US | |
3529033 | 3529033 | 2022-06-04 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-05 04:20:55 | Unassigned, Maine, US | |
3580194 | 3580194 | 2022-06-02 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-03 04:20:58 | Unassigned, Maine, US | |
1315767 | 1315767 | 2022-05-27 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-05-28 04:21:07 | Unassigned, Maine, US | |
3584335 | 3584335 | 2022-05-17 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-18 04:20:50 | Unassigned, Michigan, US | |
1505292 | 1505292 | 2022-05-16 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-17 04:20:59 | Unassigned, Michigan, US | |
2085651 | 2085651 | 2022-05-15 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-16 04:20:47 | Unassigned, Michigan, US | |
3356361 | 3356361 | 2022-05-14 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-15 04:20:53 | Unassigned, Michigan, US | |
660006 | 660006 | 2022-05-13 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-14 04:20:48 | Unassigned, Michigan, US | |
2535089 | 2535089 | 2022-05-12 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-13 04:20:51 | Unassigned, Michigan, US | |
3446535 | 3446535 | 2022-05-11 | US | Michigan | Unassigned | 90026 | 27 | 0 | 0 | 47.63197653 | 0.0 | 2022-05-12 04:20:54 | Unassigned, Michigan, US | |
3446410 | 3446410 | 2022-05-11 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-05-12 04:20:54 | Unassigned, Maine, US | |
1549538 | 1549538 | 2022-03-07 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-08 04:20:54 | Unassigned, Maine, US | |
2201207 | 2201207 | 2022-03-06 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-07 04:20:47 | Unassigned, Maine, US | |
2093664 | 2093664 | 2022-03-05 | US | Maine | Unassigned | 90023 | 27 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-06 04:20:49 | Unassigned, Maine, US | |
1472032 | 1472032 | 2022-01-17 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-18 04:21:04 | Holy See | ||||
554706 | 554706 | 2022-01-16 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-17 04:21:08 | Holy See | ||||
3840427 | 3840427 | 2022-01-15 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-16 04:21:12 | Holy See | ||||
99242 | 99242 | 2022-01-14 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-15 04:21:07 | Holy See | ||||
3687397 | 3687397 | 2022-01-13 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-14 04:21:54 | Holy See | ||||
3612981 | 3612981 | 2022-01-12 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-13 08:00:09 | Holy See | ||||
1113506 | 1113506 | 2022-01-11 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-12 04:21:44 | Holy See | ||||
1692234 | 1692234 | 2022-01-10 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-11 04:22:01 | Holy See | ||||
126649 | 126649 | 2022-01-09 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-10 04:22:07 | Holy See | ||||
1215484 | 1215484 | 2022-01-08 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-09 04:21:46 | Holy See | ||||
1389577 | 1389577 | 2022-01-07 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-08 04:21:53 | Holy See | ||||
2609964 | 2609964 | 2022-01-06 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-07 04:22:09 | Holy See | ||||
1284008 | 1284008 | 2022-01-05 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-06 04:22:09 | Petroleum, Montana, US | |
1281906 | 1281906 | 2022-01-05 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-06 04:22:09 | Holy See | ||||
1288024 | 1288024 | 2022-01-04 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-05 04:21:59 | Petroleum, Montana, US | |
1285922 | 1285922 | 2022-01-04 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-05 04:21:59 | Holy See | ||||
1702368 | 1702368 | 2022-01-03 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-04 04:22:17 | Petroleum, Montana, US | |
1700266 | 1700266 | 2022-01-03 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-04 04:22:17 | Holy See | ||||
3521451 | 3521451 | 2022-01-02 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-03 02:22:25 | Petroleum, Montana, US | |
3519349 | 3519349 | 2022-01-02 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-03 02:22:25 | Holy See | ||||
2170724 | 2170724 | 2022-01-01 | US | Texas | Loving | 48301 | 27 | 0 | 0 | 31.84947612 | -103.5818571 | 2022-01-02 04:20:52 | Loving, Texas, US | |
2169581 | 2169581 | 2022-01-01 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-02 04:20:52 | Petroleum, Montana, US | |
2167479 | 2167479 | 2022-01-01 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-02 04:20:52 | Holy See | ||||
2779012 | 2779012 | 2021-12-31 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-01 04:22:14 | Petroleum, Montana, US | |
2776910 | 2776910 | 2021-12-31 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2022-01-01 04:22:14 | Holy See | ||||
4000669 | 4000669 | 2021-12-30 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-31 04:21:50 | Petroleum, Montana, US | |
3998567 | 3998567 | 2021-12-30 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-31 04:21:50 | Holy See | ||||
1670476 | 1670476 | 2021-12-29 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-30 04:21:25 | Petroleum, Montana, US | |
1668374 | 1668374 | 2021-12-29 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-30 04:21:25 | Holy See | ||||
1434585 | 1434585 | 2021-12-28 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-29 03:21:43 | Petroleum, Montana, US | |
1432483 | 1432483 | 2021-12-28 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-29 03:21:43 | Holy See | ||||
732546 | 732546 | 2021-12-27 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-28 04:21:47 | Petroleum, Montana, US | |
730444 | 730444 | 2021-12-27 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-28 04:21:47 | Holy See | ||||
2113718 | 2113718 | 2021-12-26 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-27 04:21:58 | Petroleum, Montana, US | |
2111616 | 2111616 | 2021-12-26 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-27 04:21:58 | Holy See | ||||
3607090 | 3607090 | 2021-12-25 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-26 04:21:50 | Petroleum, Montana, US | |
3604988 | 3604988 | 2021-12-25 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-26 04:21:50 | Holy See | ||||
2965408 | 2965408 | 2021-12-24 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-25 04:21:37 | Petroleum, Montana, US | |
2963306 | 2963306 | 2021-12-24 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-25 04:21:37 | Holy See | ||||
3818440 | 3818440 | 2021-12-23 | US | Montana | Petroleum | 30069 | 27 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-24 04:21:34 | Petroleum, Montana, US | |
3816338 | 3816338 | 2021-12-23 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-24 04:21:34 | Holy See | ||||
798346 | 798346 | 2021-12-22 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-23 04:21:21 | Holy See | ||||
3828386 | 3828386 | 2021-12-21 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-22 04:21:54 | Holy See | ||||
1254689 | 1254689 | 2021-12-20 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-21 03:21:27 | Holy See | ||||
2903632 | 2903632 | 2021-12-19 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-20 04:21:43 | Holy See | ||||
1258705 | 1258705 | 2021-12-18 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-19 04:21:11 | Holy See | ||||
2398733 | 2398733 | 2021-12-17 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-18 02:22:20 | Holy See | ||||
1716271 | 1716271 | 2021-12-16 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-17 04:22:14 | Holy See | ||||
3498232 | 3498232 | 2021-12-15 | US | Nebraska | Arthur | 31005 | 27 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-16 04:22:11 | Arthur, Nebraska, US | |
3496105 | 3496105 | 2021-12-15 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-16 04:22:11 | Holy See | ||||
2090017 | 2090017 | 2021-12-14 | US | Nebraska | Arthur | 31005 | 27 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-15 03:22:16 | Arthur, Nebraska, US | |
2087890 | 2087890 | 2021-12-14 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-15 03:22:16 | Holy See | ||||
784434 | 784434 | 2021-12-13 | US | Nebraska | Arthur | 31005 | 27 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-14 04:22:38 | Arthur, Nebraska, US | |
782307 | 782307 | 2021-12-13 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-14 04:22:38 | Holy See | ||||
1660342 | 1660342 | 2021-12-12 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-13 04:22:02 | Holy See | ||||
1664358 | 1664358 | 2021-12-11 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-12 04:22:12 | Holy See | ||||
3655510 | 3655510 | 2021-12-10 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-11 04:22:45 | Holy See | ||||
1077841 | 1077841 | 2021-12-09 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-10 04:22:28 | Holy See | ||||
550690 | 550690 | 2021-12-08 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-09 04:22:49 | Holy See | ||||
404210 | 404210 | 2021-12-07 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-08 04:22:46 | Holy See | ||||
1030292 | 1030292 | 2021-12-06 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-07 04:22:34 | Holy See | ||||
1740455 | 1740455 | 2021-12-05 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-06 04:22:34 | Holy See | ||||
137887 | 137887 | 2021-12-04 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-05 04:22:25 | Holy See | ||||
2195540 | 2195540 | 2021-12-03 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-04 04:22:18 | Holy See | ||||
246 | 246 | 2021-12-02 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-03 04:23:05 | Holy See | ||||
1144845 | 1144845 | 2021-12-01 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-02 04:22:37 | Holy See | ||||
3401357 | 3401357 | 2021-11-30 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-12-01 04:22:29 | Holy See | ||||
149900 | 149900 | 2021-11-29 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-30 04:22:53 | Holy See | ||||
1231546 | 1231546 | 2021-11-28 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-29 04:22:30 | Holy See | ||||
1358253 | 1358253 | 2021-11-27 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-28 04:22:43 | Holy See | ||||
758244 | 758244 | 2021-11-26 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-27 04:22:45 | Holy See | ||||
1802661 | 1802661 | 2021-11-25 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-26 04:22:33 | Holy See | ||||
904095 | 904095 | 2021-11-24 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-25 04:22:33 | Holy See | ||||
3069945 | 3069945 | 2021-11-23 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-24 04:22:14 | Holy See | ||||
3749043 | 3749043 | 2021-11-22 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-23 04:22:39 | Holy See | ||||
1014250 | 1014250 | 2021-11-21 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-22 04:22:20 | Holy See | ||||
722414 | 722414 | 2021-11-20 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-21 04:22:13 | Holy See | ||||
161944 | 161944 | 2021-11-19 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-20 04:22:17 | Holy See | ||||
3288831 | 3288831 | 2021-11-18 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-19 04:21:40 | Holy See | ||||
447287 | 447287 | 2021-11-17 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-11-18 04:21:33 | Holy See |
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]);