johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where active = 2 and province_or_state = "Aomori" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3781905 | 3781905 | 2020-10-13 | Japan | Aomori | 39 | 1 | 36 | 2 | 40.781541 | 140.828896 | 2020-10-14 04:24:05 | Aomori, Japan | ||
1041826 | 1041826 | 2020-10-07 | Japan | Aomori | 37 | 1 | 34 | 2 | 40.781541 | 140.828896 | 2020-10-08 04:23:56 | Aomori, Japan | ||
3117487 | 3117487 | 2020-10-06 | Japan | Aomori | 37 | 1 | 34 | 2 | 40.781541 | 140.828896 | 2020-10-07 04:23:40 | Aomori, Japan | ||
3801899 | 3801899 | 2020-10-05 | Japan | Aomori | 37 | 1 | 34 | 2 | 40.781541 | 140.828896 | 2020-10-06 04:23:33 | Aomori, Japan | ||
1822789 | 1822789 | 2020-10-04 | Japan | Aomori | 37 | 1 | 34 | 2 | 40.781541 | 140.828896 | 2020-10-05 04:23:33 | Aomori, Japan | ||
2514173 | 2514173 | 2020-10-03 | Japan | Aomori | 37 | 1 | 34 | 2 | 40.781541 | 140.828896 | 2020-10-04 04:23:44 | Aomori, Japan | ||
3389391 | 3389391 | 2020-10-02 | Japan | Aomori | 37 | 1 | 34 | 2 | 40.781541 | 140.828896 | 2020-10-03 04:23:40 | Aomori, Japan | ||
2653771 | 2653771 | 2020-09-23 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-24 04:23:00 | Aomori, Japan | ||
3316220 | 3316220 | 2020-09-22 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-23 04:23:00 | Aomori, Japan | ||
2836819 | 2836819 | 2020-09-21 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-22 04:23:00 | Aomori, Japan | ||
3093423 | 3093423 | 2020-09-20 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-21 04:23:00 | Aomori, Japan | ||
2454773 | 2454773 | 2020-09-19 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-20 04:22:00 | Aomori, Japan | ||
2848842 | 2848842 | 2020-09-18 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-19 04:22:00 | Aomori, Japan | ||
1121591 | 1121591 | 2020-09-17 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-18 05:05:00 | Aomori, Japan | ||
666280 | 666280 | 2020-09-16 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-17 04:22:00 | Aomori, Japan | ||
2729005 | 2729005 | 2020-09-15 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-16 04:22:53 | Aomori, Japan | ||
344277 | 344277 | 2020-09-14 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-15 03:22:50 | Aomori, Japan | ||
2868716 | 2868716 | 2020-09-13 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-14 04:26:00 | Aomori, Japan | ||
546755 | 546755 | 2020-09-12 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-13 04:30:52 | Aomori, Japan | ||
1444584 | 1444584 | 2020-09-11 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-12 04:25:05 | Aomori, Japan | ||
1173185 | 1173185 | 2020-09-10 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-11 04:46:23 | Aomori, Japan | ||
2171550 | 2171550 | 2020-09-09 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-10 04:29:01 | Aomori, Japan | ||
1243759 | 1243759 | 2020-09-08 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-09 04:28:48 | Aomori, Japan | ||
427338 | 427338 | 2020-09-07 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-08 04:28:25 | Aomori, Japan | ||
3161623 | 3161623 | 2020-09-06 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-07 04:28:30 | Aomori, Japan | ||
813578 | 813578 | 2020-09-05 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-06 04:28:33 | Aomori, Japan | ||
2661778 | 2661778 | 2020-09-04 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-05 04:28:19 | Aomori, Japan | ||
1354318 | 1354318 | 2020-09-03 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-04 04:28:26 | Aomori, Japan | ||
1105555 | 1105555 | 2020-09-02 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-03 04:28:22 | Aomori, Japan | ||
2059884 | 2059884 | 2020-09-01 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-02 04:28:25 | Aomori, Japan | ||
194069 | 194069 | 2020-08-31 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-01 04:28:31 | Aomori, Japan | ||
3932028 | 3932028 | 2020-08-30 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-08-31 04:28:27 | Aomori, Japan | ||
609690 | 609690 | 2020-08-29 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-08-30 04:28:22 | Aomori, Japan | ||
1523185 | 1523185 | 2020-08-28 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-08-29 04:28:19 | Aomori, Japan | ||
2510186 | 2510186 | 2020-08-27 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-08-28 04:28:11 | Aomori, Japan | ||
582833 | 582833 | 2020-08-13 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-14 04:51:19 | Aomori, Japan | ||
3531452 | 3531452 | 2020-08-12 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-13 04:29:15 | Aomori, Japan | ||
662301 | 662301 | 2020-08-11 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-12 04:27:29 | Aomori, Japan | ||
1920182 | 1920182 | 2020-08-10 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-11 04:35:08 | Aomori, Japan | ||
3922991 | 3922991 | 2020-08-09 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-10 04:34:55 | Aomori, Japan | ||
371159 | 371159 | 2020-08-08 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-09 04:34:54 | Aomori, Japan | ||
458343 | 458343 | 2020-08-07 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-08 04:34:53 | Aomori, Japan | ||
3612028 | 3612028 | 2020-08-06 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-07 04:35:11 | Aomori, Japan | ||
753297 | 753297 | 2020-08-01 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-02 04:34:47 | Aomori, Japan | ||
3264462 | 3264462 | 2020-07-31 | Japan | Aomori | 32 | 1 | 29 | 2 | 40.781541 | 140.828896 | 2020-08-01 04:36:27 | Aomori, Japan | ||
3237305 | 3237305 | 2020-07-10 | Japan | Aomori | 29 | 1 | 26 | 2 | 40.781541 | 140.828896 | 2020-07-11 04:34:26 | Aomori, Japan | ||
2712118 | 2712118 | 2020-05-28 | Japan | Aomori | 27 | 1 | 24 | 2 | 40.781541 | 140.828896 | 2020-05-29 02:32:50 | Aomori, Japan |
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]);