johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
60 rows where confirmed = 25 and province_or_state = "Saint Pierre and Miquelon" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2339296 | 2339296 | 2021-06-15 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-16 04:22:32 | Saint Pierre and Miquelon, France | ||
1563992 | 1563992 | 2021-06-14 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-15 04:22:22 | Saint Pierre and Miquelon, France | ||
3381275 | 3381275 | 2021-06-13 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-14 04:22:46 | Saint Pierre and Miquelon, France | ||
1736409 | 1736409 | 2021-06-12 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-13 04:22:44 | Saint Pierre and Miquelon, France | ||
3970450 | 3970450 | 2021-06-11 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-12 04:22:22 | Saint Pierre and Miquelon, France | ||
2716872 | 2716872 | 2021-06-10 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-11 04:23:20 | Saint Pierre and Miquelon, France | ||
522757 | 522757 | 2021-06-09 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-10 04:23:17 | Saint Pierre and Miquelon, France | ||
3472197 | 3472197 | 2021-06-08 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-09 04:23:31 | Saint Pierre and Miquelon, France | ||
3145481 | 3145481 | 2021-06-07 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-08 04:22:35 | Saint Pierre and Miquelon, France | ||
825483 | 825483 | 2021-06-06 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-07 04:22:51 | Saint Pierre and Miquelon, France | ||
2585888 | 2585888 | 2021-06-05 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-06 04:24:03 | Saint Pierre and Miquelon, France | ||
2315202 | 2315202 | 2021-06-04 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-05 04:23:03 | Saint Pierre and Miquelon, France | ||
1448487 | 1448487 | 2021-06-03 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-04 04:23:37 | Saint Pierre and Miquelon, France | ||
1708211 | 1708211 | 2021-06-02 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-03 04:23:32 | Saint Pierre and Miquelon, France | ||
2104029 | 2104029 | 2021-06-01 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-02 04:24:34 | Saint Pierre and Miquelon, France | ||
1188645 | 1188645 | 2021-05-31 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-06-01 04:23:09 | Saint Pierre and Miquelon, France | ||
3089322 | 3089322 | 2021-05-30 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-31 03:08:59 | Saint Pierre and Miquelon, France | ||
50691 | 50691 | 2021-05-29 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-30 04:20:55 | Saint Pierre and Miquelon, France | ||
20270 | 20270 | 2021-05-28 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-29 04:20:41 | Saint Pierre and Miquelon, France | ||
1806645 | 1806645 | 2021-05-27 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-28 04:20:36 | Saint Pierre and Miquelon, France | ||
1310069 | 1310069 | 2021-05-26 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-27 04:20:59 | Saint Pierre and Miquelon, France | ||
82995 | 82995 | 2021-05-25 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-26 04:20:35 | Saint Pierre and Miquelon, France | ||
1412957 | 1412957 | 2021-05-24 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-25 04:21:08 | Saint Pierre and Miquelon, France | ||
1771243 | 1771243 | 2021-05-23 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-24 04:20:53 | Saint Pierre and Miquelon, France | ||
726398 | 726398 | 2021-05-22 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-23 04:20:51 | Saint Pierre and Miquelon, France | ||
1952413 | 1952413 | 2021-05-21 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-22 04:20:45 | Saint Pierre and Miquelon, France | ||
1913112 | 1913112 | 2021-05-20 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-21 04:20:43 | Saint Pierre and Miquelon, France | ||
2255633 | 2255633 | 2021-05-19 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-20 04:21:05 | Saint Pierre and Miquelon, France | ||
2390671 | 2390671 | 2021-05-18 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-19 04:20:42 | Saint Pierre and Miquelon, France | ||
3574496 | 3574496 | 2021-05-17 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-18 04:20:33 | Saint Pierre and Miquelon, France | ||
2939226 | 2939226 | 2021-05-16 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-17 04:20:34 | Saint Pierre and Miquelon, France | ||
1872856 | 1872856 | 2021-05-15 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-16 04:20:49 | Saint Pierre and Miquelon, France | ||
1081825 | 1081825 | 2021-05-14 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-15 04:20:58 | Saint Pierre and Miquelon, France | ||
3054091 | 3054091 | 2021-05-13 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-14 04:20:41 | Saint Pierre and Miquelon, France | ||
2004561 | 2004561 | 2021-05-12 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-13 04:20:51 | Saint Pierre and Miquelon, France | ||
3954392 | 3954392 | 2021-05-11 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-12 04:21:29 | Saint Pierre and Miquelon, France | ||
2820671 | 2820671 | 2021-05-10 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-11 04:20:41 | Saint Pierre and Miquelon, France | ||
1425003 | 1425003 | 2021-05-09 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-10 04:20:38 | Saint Pierre and Miquelon, France | ||
1551871 | 1551871 | 2021-05-08 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-09 04:20:35 | Saint Pierre and Miquelon, France | ||
2501929 | 2501929 | 2021-05-07 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-08 04:21:04 | Saint Pierre and Miquelon, France | ||
3113385 | 3113385 | 2021-05-06 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-07 04:20:40 | Saint Pierre and Miquelon, France | ||
645852 | 645852 | 2021-05-05 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-06 04:20:38 | Saint Pierre and Miquelon, France | ||
3675552 | 3675552 | 2021-05-04 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-05 04:20:43 | Saint Pierre and Miquelon, France | ||
2760819 | 2760819 | 2021-05-03 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-04 04:20:34 | Saint Pierre and Miquelon, France | ||
2450672 | 2450672 | 2021-05-02 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-03 04:20:39 | Saint Pierre and Miquelon, France | ||
2824685 | 2824685 | 2021-05-01 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-02 04:20:48 | Saint Pierre and Miquelon, France | ||
380093 | 380093 | 2021-04-30 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-05-01 04:20:47 | Saint Pierre and Miquelon, France | ||
1636216 | 1636216 | 2021-04-29 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-04-30 04:21:03 | Saint Pierre and Miquelon, France | ||
3393295 | 3393295 | 2021-04-28 | France | Saint Pierre and Miquelon | 25 | 0 | 25 | 0 | 46.8852 | -56.3159 | 2021-04-29 04:20:55 | Saint Pierre and Miquelon, France | ||
3702011 | 3702011 | 2021-04-27 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-28 04:20:32 | Saint Pierre and Miquelon, France | ||
888020 | 888020 | 2021-04-26 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-27 04:20:52 | Saint Pierre and Miquelon, France | ||
954765 | 954765 | 2021-04-25 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-26 04:21:04 | Saint Pierre and Miquelon, France | ||
3923912 | 3923912 | 2021-04-24 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-25 04:20:32 | Saint Pierre and Miquelon, France | ||
1408943 | 1408943 | 2021-04-23 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-24 04:20:38 | Saint Pierre and Miquelon, France | ||
1568006 | 1568006 | 2021-04-22 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-23 04:20:52 | Saint Pierre and Miquelon, France | ||
3242227 | 3242227 | 2021-04-21 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-22 04:20:53 | Saint Pierre and Miquelon, France | ||
2020623 | 2020623 | 2021-04-20 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-21 04:21:14 | Saint Pierre and Miquelon, France | ||
2410744 | 2410744 | 2021-04-19 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-20 04:20:41 | Saint Pierre and Miquelon, France | ||
3129421 | 3129421 | 2021-04-18 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-19 04:20:57 | Saint Pierre and Miquelon, France | ||
982849 | 982849 | 2021-04-17 | France | Saint Pierre and Miquelon | 25 | 0 | 24 | 1 | 46.8852 | -56.3159 | 2021-04-18 04:20:41 | Saint Pierre and Miquelon, France |
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]);