johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where deaths = 80 and province_or_state = "Yamaguchi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2175600 | 2175600 | 2021-08-22 | Japan | Yamaguchi | 4358 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-23 04:21:27 | Yamaguchi, Japan | |||
3555696 | 3555696 | 2021-08-21 | Japan | Yamaguchi | 4294 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-22 04:21:29 | Yamaguchi, Japan | |||
1854038 | 1854038 | 2021-08-20 | Japan | Yamaguchi | 4208 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-21 04:21:38 | Yamaguchi, Japan | |||
511745 | 511745 | 2021-08-19 | Japan | Yamaguchi | 4114 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-20 04:21:33 | Yamaguchi, Japan | |||
2518224 | 2518224 | 2021-08-18 | Japan | Yamaguchi | 3995 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-19 04:21:15 | Yamaguchi, Japan | |||
245316 | 245316 | 2021-08-17 | Japan | Yamaguchi | 3890 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-18 04:21:35 | Yamaguchi, Japan | |||
1604279 | 1604279 | 2021-08-16 | Japan | Yamaguchi | 3815 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-17 04:21:49 | Yamaguchi, Japan | |||
103373 | 103373 | 2021-08-15 | Japan | Yamaguchi | 3768 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-16 04:21:31 | Yamaguchi, Japan | |||
507731 | 507731 | 2021-08-14 | Japan | Yamaguchi | 3730 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-15 04:21:41 | Yamaguchi, Japan | |||
1483603 | 1483603 | 2021-08-13 | Japan | Yamaguchi | 3661 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-14 04:21:25 | Yamaguchi, Japan | |||
2899733 | 2899733 | 2021-08-12 | Japan | Yamaguchi | 3600 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-13 04:21:24 | Yamaguchi, Japan | |||
1342337 | 1342337 | 2021-08-11 | Japan | Yamaguchi | 3543 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-12 04:21:25 | Yamaguchi, Japan | |||
2351484 | 2351484 | 2021-08-10 | Japan | Yamaguchi | 3496 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-11 04:21:58 | Yamaguchi, Japan | |||
650013 | 650013 | 2021-08-09 | Japan | Yamaguchi | 3464 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-10 04:21:27 | Yamaguchi, Japan | |||
589675 | 589675 | 2021-08-08 | Japan | Yamaguchi | 3444 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-09 04:21:24 | Yamaguchi, Japan | |||
2203687 | 2203687 | 2021-08-07 | Japan | Yamaguchi | 3420 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-08 04:21:33 | Yamaguchi, Japan | |||
1117637 | 1117637 | 2021-08-06 | Japan | Yamaguchi | 3389 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-07 04:21:30 | Yamaguchi, Japan | |||
1956574 | 1956574 | 2021-08-05 | Japan | Yamaguchi | 3368 | 80 | 0 | 34.201190000000004 | 131.573293 | 2021-08-06 04:21:18 | Yamaguchi, Japan | |||
331953 | 331953 | 2021-08-04 | Japan | Yamaguchi | 3351 | 80 | 3123 | 148 | 34.201190000000004 | 131.573293 | 2021-08-05 04:21:51 | Yamaguchi, Japan | ||
3468224 | 3468224 | 2021-08-03 | Japan | Yamaguchi | 3324 | 80 | 3116 | 128 | 34.201190000000004 | 131.573293 | 2021-08-04 04:21:25 | Yamaguchi, Japan | ||
3683498 | 3683498 | 2021-08-02 | Japan | Yamaguchi | 3309 | 80 | 3113 | 116 | 34.201190000000004 | 131.573293 | 2021-08-03 04:21:39 | Yamaguchi, Japan | ||
3015397 | 3015397 | 2021-08-01 | Japan | Yamaguchi | 3306 | 80 | 3110 | 116 | 34.201190000000004 | 131.573293 | 2021-08-02 04:21:36 | Yamaguchi, Japan | ||
3904020 | 3904020 | 2021-07-31 | Japan | Yamaguchi | 3297 | 80 | 3109 | 108 | 34.201190000000004 | 131.573293 | 2021-08-01 04:21:50 | Yamaguchi, Japan | ||
3296225 | 3296225 | 2021-07-30 | Japan | Yamaguchi | 3280 | 80 | 3111 | 89 | 34.201190000000004 | 131.573293 | 2021-07-31 04:21:35 | Yamaguchi, Japan | ||
3385436 | 3385436 | 2021-07-29 | Japan | Yamaguchi | 3253 | 80 | 3111 | 62 | 34.201190000000004 | 131.573293 | 2021-07-30 04:21:34 | Yamaguchi, Japan | ||
408341 | 408341 | 2021-07-28 | Japan | Yamaguchi | 3237 | 80 | 3102 | 55 | 34.201190000000004 | 131.573293 | 2021-07-29 04:21:33 | Yamaguchi, Japan | ||
1306202 | 1306202 | 2021-07-27 | Japan | Yamaguchi | 3227 | 80 | 3098 | 49 | 34.201190000000004 | 131.573293 | 2021-07-28 04:21:39 | Yamaguchi, Japan | ||
3218345 | 3218345 | 2021-07-26 | Japan | Yamaguchi | 3218 | 80 | 3095 | 43 | 34.201190000000004 | 131.573293 | 2021-07-27 04:21:18 | Yamaguchi, Japan | ||
1378554 | 1378554 | 2021-07-25 | Japan | Yamaguchi | 3211 | 80 | 3090 | 41 | 34.201190000000004 | 131.573293 | 2021-07-26 04:21:28 | Yamaguchi, Japan | ||
1330294 | 1330294 | 2021-07-24 | Japan | Yamaguchi | 3206 | 80 | 3088 | 38 | 34.201190000000004 | 131.573293 | 2021-07-25 04:22:12 | Yamaguchi, Japan | ||
3137598 | 3137598 | 2021-07-23 | Japan | Yamaguchi | 3204 | 80 | 3082 | 42 | 34.201190000000004 | 131.573293 | 2021-07-24 00:21:36 | Yamaguchi, Japan | ||
3476358 | 3476358 | 2021-07-22 | Japan | Yamaguchi | 3204 | 80 | 3082 | 42 | 34.201190000000004 | 131.573293 | 2021-07-23 04:21:29 | Yamaguchi, Japan | ||
3331577 | 3331577 | 2021-07-21 | Japan | Yamaguchi | 3200 | 80 | 3081 | 39 | 34.201190000000004 | 131.573293 | 2021-07-22 04:21:19 | Yamaguchi, Japan | ||
2371558 | 2371558 | 2021-07-20 | Japan | Yamaguchi | 3196 | 80 | 3081 | 35 | 34.201190000000004 | 131.573293 | 2021-07-21 04:21:40 | Yamaguchi, Japan | ||
483637 | 483637 | 2021-07-19 | Japan | Yamaguchi | 3193 | 80 | 3081 | 32 | 34.201190000000004 | 131.573293 | 2021-07-20 04:21:48 | Yamaguchi, Japan | ||
2673860 | 2673860 | 2021-07-18 | Japan | Yamaguchi | 3193 | 80 | 3078 | 35 | 34.201190000000004 | 131.573293 | 2021-07-19 04:21:24 | Yamaguchi, Japan | ||
3706172 | 3706172 | 2021-07-17 | Japan | Yamaguchi | 3191 | 80 | 3077 | 34 | 34.201190000000004 | 131.573293 | 2021-07-18 04:22:07 | Yamaguchi, Japan | ||
2947403 | 2947403 | 2021-07-16 | Japan | Yamaguchi | 3185 | 80 | 3075 | 30 | 34.201190000000004 | 131.573293 | 2021-07-17 04:22:22 | Yamaguchi, Japan | ||
296059 | 296059 | 2021-07-15 | Japan | Yamaguchi | 3181 | 80 | 3069 | 32 | 34.201190000000004 | 131.573293 | 2021-07-16 04:21:22 | Yamaguchi, Japan | ||
3632004 | 3632004 | 2021-07-14 | Japan | Yamaguchi | 3180 | 80 | 3065 | 35 | 34.201190000000004 | 131.573293 | 2021-07-15 04:21:48 | Yamaguchi, Japan | ||
578879 | 578879 | 2021-07-13 | Japan | Yamaguchi | 3177 | 80 | 3058 | 39 | 34.201190000000004 | 131.573293 | 2021-07-14 04:21:35 | Yamaguchi, Japan | ||
3741128 | 3741128 | 2021-07-12 | Japan | Yamaguchi | 3175 | 80 | 3057 | 38 | 34.201190000000004 | 131.573293 | 2021-07-13 04:21:18 | Yamaguchi, Japan | ||
3659641 | 3659641 | 2021-07-11 | Japan | Yamaguchi | 3175 | 80 | 3051 | 44 | 34.201190000000004 | 131.573293 | 2021-07-12 04:21:34 | Yamaguchi, Japan | ||
625925 | 625925 | 2021-07-10 | Japan | Yamaguchi | 3173 | 80 | 3051 | 42 | 34.201190000000004 | 131.573293 | 2021-07-11 04:21:43 | Yamaguchi, Japan | ||
829644 | 829644 | 2021-07-09 | Japan | Yamaguchi | 3171 | 80 | 3045 | 46 | 34.201190000000004 | 131.573293 | 2021-07-10 04:21:25 | Yamaguchi, Japan | ||
778408 | 778408 | 2021-07-08 | Japan | Yamaguchi | 3169 | 80 | 3038 | 51 | 34.201190000000004 | 131.573293 | 2021-07-09 04:21:21 | Yamaguchi, Japan | ||
1440630 | 1440630 | 2021-07-07 | Japan | Yamaguchi | 3163 | 80 | 3036 | 47 | 34.201190000000004 | 131.573293 | 2021-07-08 04:21:26 | Yamaguchi, Japan | ||
2693735 | 2693735 | 2021-07-06 | Japan | Yamaguchi | 3162 | 80 | 3028 | 54 | 34.201190000000004 | 131.573293 | 2021-07-07 04:21:20 | Yamaguchi, Japan | ||
1932484 | 1932484 | 2021-07-05 | Japan | Yamaguchi | 3160 | 80 | 3025 | 55 | 34.201190000000004 | 131.573293 | 2021-07-06 04:21:32 | Yamaguchi, Japan | ||
1165215 | 1165215 | 2021-07-04 | Japan | Yamaguchi | 3159 | 80 | 3021 | 58 | 34.201190000000004 | 131.573293 | 2021-07-05 04:21:28 | Yamaguchi, 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]);