johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Ehime" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533386 | 2533386 | 2022-05-12 | Japan | Ehime | 35839 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-13 04:20:51 | Ehime, Japan | |||
3444832 | 3444832 | 2022-05-11 | Japan | Ehime | 35598 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-12 04:20:54 | Ehime, Japan | |||
3535449 | 3535449 | 2022-05-10 | Japan | Ehime | 35361 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-11 04:20:48 | Ehime, Japan | |||
221984 | 221984 | 2022-05-09 | Japan | Ehime | 35040 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-10 04:20:50 | Ehime, Japan | |||
2331369 | 2331369 | 2022-05-08 | Japan | Ehime | 34880 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-09 04:20:54 | Ehime, Japan | |||
360331 | 360331 | 2022-05-07 | Japan | Ehime | 34626 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-08 04:20:49 | Ehime, Japan | |||
1397682 | 1397682 | 2022-05-06 | Japan | Ehime | 34273 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-07 04:21:09 | Ehime, Japan | |||
2598037 | 2598037 | 2022-05-05 | Japan | Ehime | 34138 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-06 04:21:00 | Ehime, Japan | |||
3265486 | 3265486 | 2022-05-04 | Japan | Ehime | 34008 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-05 04:20:55 | Ehime, Japan | |||
1572125 | 1572125 | 2022-05-03 | Japan | Ehime | 33905 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-04 04:20:59 | Ehime, Japan | |||
463385 | 463385 | 2022-05-02 | Japan | Ehime | 33633 | 137 | 0 | 33.624835 | 132.856842 | 2022-05-03 04:21:00 | Ehime, Japan | |||
3916024 | 3916024 | 2022-05-01 | Japan | Ehime | 33535 | 136 | 0 | 33.624835 | 132.856842 | 2022-05-02 04:21:10 | Ehime, Japan | |||
2840828 | 2840828 | 2022-04-30 | Japan | Ehime | 33323 | 135 | 0 | 33.624835 | 132.856842 | 2022-05-01 04:20:57 | Ehime, Japan | |||
1157141 | 1157141 | 2022-04-29 | Japan | Ehime | 33206 | 135 | 0 | 33.624835 | 132.856842 | 2022-04-30 04:21:05 | Ehime, Japan | |||
1696323 | 1696323 | 2022-04-28 | Japan | Ehime | 32905 | 135 | 0 | 33.624835 | 132.856842 | 2022-04-29 04:20:59 | Ehime, Japan | |||
3851806 | 3851806 | 2022-04-27 | Japan | Ehime | 32614 | 135 | 0 | 33.624835 | 132.856842 | 2022-04-28 04:20:47 | Ehime, Japan | |||
1326236 | 1326236 | 2022-04-26 | Japan | Ehime | 32266 | 135 | 0 | 33.624835 | 132.856842 | 2022-04-27 04:20:52 | Ehime, Japan | |||
3722190 | 3722190 | 2022-04-25 | Japan | Ehime | 31862 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-26 04:20:51 | Ehime, Japan | |||
2028758 | 2028758 | 2022-04-24 | Japan | Ehime | 31738 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-25 04:20:56 | Ehime, Japan | |||
746333 | 746333 | 2022-04-23 | Japan | Ehime | 31519 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-24 04:20:56 | Ehime, Japan | |||
3436818 | 3436818 | 2022-04-22 | Japan | Ehime | 31236 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-23 04:20:50 | Ehime, Japan | |||
2892403 | 2892403 | 2022-04-21 | Japan | Ehime | 30950 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-22 04:20:45 | Ehime, Japan | |||
2307275 | 2307275 | 2022-04-20 | Japan | Ehime | 30677 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-21 04:20:46 | Ehime, Japan | |||
2251414 | 2251414 | 2022-04-19 | Japan | Ehime | 30376 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-20 04:20:45 | Ehime, Japan | |||
1845964 | 1845964 | 2022-04-18 | Japan | Ehime | 29976 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-19 04:21:00 | Ehime, Japan | |||
3416908 | 3416908 | 2022-04-17 | Japan | Ehime | 29851 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-18 04:21:12 | Ehime, Japan | |||
303857 | 303857 | 2022-04-16 | Japan | Ehime | 29654 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-17 04:20:59 | Ehime, Japan | |||
2669802 | 2669802 | 2022-04-15 | Japan | Ehime | 29379 | 134 | 0 | 33.624835 | 132.856842 | 2022-04-16 04:20:48 | Ehime, Japan | |||
1223587 | 1223587 | 2022-04-14 | Japan | Ehime | 29049 | 133 | 0 | 33.624835 | 132.856842 | 2022-04-15 04:20:57 | Ehime, Japan | |||
2442745 | 2442745 | 2022-04-13 | Japan | Ehime | 28709 | 133 | 0 | 33.624835 | 132.856842 | 2022-04-13 23:21:06 | Ehime, Japan | |||
1948502 | 1948502 | 2022-04-12 | Japan | Ehime | 28301 | 133 | 0 | 33.624835 | 132.856842 | 2022-04-13 04:21:03 | Ehime, Japan | |||
3206255 | 3206255 | 2022-04-11 | Japan | Ehime | 27852 | 133 | 0 | 33.624835 | 132.856842 | 2022-04-12 04:20:49 | Ehime, Japan | |||
1576141 | 1576141 | 2022-04-10 | Japan | Ehime | 27702 | 131 | 0 | 33.624835 | 132.856842 | 2022-04-11 04:21:02 | Ehime, Japan | |||
1652383 | 1652383 | 2022-04-09 | Japan | Ehime | 27424 | 131 | 0 | 33.624835 | 132.856842 | 2022-04-10 04:20:52 | Ehime, Japan | |||
2115705 | 2115705 | 2022-04-08 | Japan | Ehime | 27112 | 130 | 0 | 33.624835 | 132.856842 | 2022-04-09 04:20:42 | Ehime, Japan | |||
3320229 | 3320229 | 2022-04-07 | Japan | Ehime | 26772 | 130 | 0 | 33.624835 | 132.856842 | 2022-04-08 04:20:48 | Ehime, Japan | |||
2800765 | 2800765 | 2022-04-06 | Japan | Ehime | 26461 | 130 | 0 | 33.624835 | 132.856842 | 2022-04-07 04:20:53 | Ehime, Japan | |||
3867534 | 3867534 | 2022-04-05 | Japan | Ehime | 26161 | 130 | 0 | 33.624835 | 132.856842 | 2022-04-06 04:20:49 | Ehime, Japan | |||
2748876 | 2748876 | 2022-04-04 | Japan | Ehime | 25775 | 130 | 0 | 33.624835 | 132.856842 | 2022-04-05 04:20:48 | Ehime, Japan | |||
3730222 | 3730222 | 2022-04-03 | Japan | Ehime | 25650 | 129 | 0 | 33.624835 | 132.856842 | 2022-04-04 04:20:51 | Ehime, Japan | |||
499657 | 499657 | 2022-04-02 | Japan | Ehime | 25415 | 129 | 0 | 33.624835 | 132.856842 | 2022-04-03 04:20:48 | Ehime, Japan | |||
3350642 | 3350642 | 2022-04-01 | Japan | Ehime | 25131 | 129 | 0 | 33.624835 | 132.856842 | 2022-04-02 04:20:47 | Ehime, Japan | |||
1539947 | 1539947 | 2022-03-31 | Japan | Ehime | 24870 | 129 | 0 | 33.624835 | 132.856842 | 2022-04-01 04:20:28 | Ehime, Japan | |||
2477960 | 2477960 | 2022-03-30 | Japan | Ehime | 24598 | 129 | 0 | 33.624835 | 132.856842 | 2022-03-31 04:20:56 | Ehime, Japan | |||
158001 | 158001 | 2022-03-29 | Japan | Ehime | 24334 | 129 | 0 | 33.624835 | 132.856842 | 2022-03-30 04:20:45 | Ehime, Japan | |||
1436572 | 1436572 | 2022-03-28 | Japan | Ehime | 23972 | 128 | 0 | 33.624835 | 132.856842 | 2022-03-29 04:20:46 | Ehime, Japan | |||
876253 | 876253 | 2022-03-27 | Japan | Ehime | 23830 | 127 | 0 | 33.624835 | 132.856842 | 2022-03-28 04:20:33 | Ehime, Japan | |||
2163536 | 2163536 | 2022-03-26 | Japan | Ehime | 23617 | 127 | 0 | 33.624835 | 132.856842 | 2022-03-27 04:20:47 | Ehime, Japan | |||
1720472 | 1720472 | 2022-03-25 | Japan | Ehime | 23360 | 126 | 0 | 33.624835 | 132.856842 | 2022-03-26 04:20:23 | Ehime, Japan | |||
1468089 | 1468089 | 2022-03-24 | Japan | Ehime | 23040 | 126 | 0 | 33.624835 | 132.856842 | 2022-03-25 04:20:46 | Ehime, Japan | |||
3022263 | 3022263 | 2022-03-23 | Japan | Ehime | 22775 | 126 | 0 | 33.624835 | 132.856842 | 2022-03-24 04:20:43 | Ehime, Japan | |||
1905185 | 1905185 | 2022-03-22 | Japan | Ehime | 22457 | 126 | 0 | 33.624835 | 132.856842 | 2022-03-23 04:20:48 | Ehime, Japan | |||
3238316 | 3238316 | 2022-03-21 | Japan | Ehime | 22378 | 126 | 0 | 33.624835 | 132.856842 | 2022-03-22 04:20:54 | Ehime, Japan | |||
24389 | 24389 | 2022-03-20 | Japan | Ehime | 22262 | 125 | 0 | 33.624835 | 132.856842 | 2022-03-21 04:20:50 | Ehime, Japan | |||
1656399 | 1656399 | 2022-03-19 | Japan | Ehime | 22046 | 125 | 0 | 33.624835 | 132.856842 | 2022-03-20 04:20:45 | Ehime, Japan | |||
335925 | 335925 | 2022-03-18 | Japan | Ehime | 21799 | 125 | 0 | 33.624835 | 132.856842 | 2022-03-19 04:20:47 | Ehime, Japan | |||
694378 | 694378 | 2022-03-17 | Japan | Ehime | 21551 | 125 | 0 | 33.624835 | 132.856842 | 2022-03-18 04:20:55 | Ehime, Japan | |||
2319321 | 2319321 | 2022-03-16 | Japan | Ehime | 21310 | 125 | 0 | 33.624835 | 132.856842 | 2022-03-17 04:20:56 | Ehime, Japan | |||
261521 | 261521 | 2022-03-15 | Japan | Ehime | 21039 | 124 | 0 | 33.624835 | 132.856842 | 2022-03-16 04:20:50 | Ehime, Japan | |||
2263880 | 2263880 | 2022-03-14 | Japan | Ehime | 20695 | 124 | 0 | 33.624835 | 132.856842 | 2022-03-15 04:20:47 | Ehime, Japan | |||
3627946 | 3627946 | 2022-03-13 | Japan | Ehime | 20540 | 123 | 0 | 33.624835 | 132.856842 | 2022-03-14 04:20:46 | Ehime, Japan | |||
950854 | 950854 | 2022-03-12 | Japan | Ehime | 20315 | 123 | 0 | 33.624835 | 132.856842 | 2022-03-13 04:20:49 | Ehime, Japan | |||
356315 | 356315 | 2022-03-11 | Japan | Ehime | 20013 | 122 | 0 | 33.624835 | 132.856842 | 2022-03-12 04:20:50 | Ehime, Japan | |||
1865467 | 1865467 | 2022-03-10 | Japan | Ehime | 19724 | 122 | 0 | 33.624835 | 132.856842 | 2022-03-11 04:20:50 | Ehime, Japan | |||
2140162 | 2140162 | 2022-03-09 | Japan | Ehime | 19383 | 121 | 0 | 33.624835 | 132.856842 | 2022-03-10 04:20:48 | Ehime, Japan | |||
919673 | 919673 | 2022-03-08 | Japan | Ehime | 19088 | 121 | 0 | 33.624835 | 132.856842 | 2022-03-09 04:20:59 | Ehime, Japan | |||
1547960 | 1547960 | 2022-03-07 | Japan | Ehime | 18736 | 120 | 0 | 33.624835 | 132.856842 | 2022-03-08 04:20:54 | Ehime, Japan | |||
2199629 | 2199629 | 2022-03-06 | Japan | Ehime | 18590 | 120 | 0 | 33.624835 | 132.856842 | 2022-03-07 04:20:47 | Ehime, Japan | |||
2092086 | 2092086 | 2022-03-05 | Japan | Ehime | 18346 | 119 | 0 | 33.624835 | 132.856842 | 2022-03-06 04:20:49 | Ehime, Japan | |||
2665786 | 2665786 | 2022-03-04 | Japan | Ehime | 18052 | 118 | 0 | 33.624835 | 132.856842 | 2022-03-05 04:21:10 | Ehime, Japan | |||
1644351 | 1644351 | 2022-03-03 | Japan | Ehime | 17752 | 118 | 0 | 33.624835 | 132.856842 | 2022-03-04 04:21:09 | Ehime, Japan | |||
2525354 | 2525354 | 2022-03-02 | Japan | Ehime | 17471 | 117 | 0 | 33.624835 | 132.856842 | 2022-03-03 04:21:01 | Ehime, Japan | |||
1992648 | 1992648 | 2022-03-01 | Japan | Ehime | 17169 | 116 | 0 | 33.624835 | 132.856842 | 2022-03-02 04:21:07 | Ehime, Japan | |||
942822 | 942822 | 2022-02-28 | Japan | Ehime | 16808 | 114 | 0 | 33.624835 | 132.856842 | 2022-03-01 04:21:09 | Ehime, Japan | |||
2733013 | 2733013 | 2022-02-27 | Japan | Ehime | 16625 | 112 | 0 | 33.624835 | 132.856842 | 2022-02-28 04:21:05 | Ehime, Japan | |||
3046166 | 3046166 | 2022-02-26 | Japan | Ehime | 16416 | 112 | 0 | 33.624835 | 132.856842 | 2022-02-27 04:21:04 | Ehime, Japan | |||
574821 | 574821 | 2022-02-25 | Japan | Ehime | 16189 | 112 | 0 | 33.624835 | 132.856842 | 2022-02-26 04:21:12 | Ehime, Japan | |||
1511397 | 1511397 | 2022-02-24 | Japan | Ehime | 15923 | 112 | 0 | 33.624835 | 132.856842 | 2022-02-25 04:21:11 | Ehime, Japan | |||
1057838 | 1057838 | 2022-02-23 | Japan | Ehime | 15773 | 111 | 0 | 33.624835 | 132.856842 | 2022-02-24 04:21:14 | Ehime, Japan | |||
2446761 | 2446761 | 2022-02-22 | Japan | Ehime | 15497 | 110 | 0 | 33.624835 | 132.856842 | 2022-02-23 04:21:09 | Ehime, Japan | |||
3718174 | 3718174 | 2022-02-21 | Japan | Ehime | 15273 | 108 | 0 | 33.624835 | 132.856842 | 2022-02-22 04:21:01 | Ehime, Japan | |||
3912008 | 3912008 | 2022-02-20 | Japan | Ehime | 15122 | 106 | 0 | 33.624835 | 132.856842 | 2022-02-21 04:21:05 | Ehime, Japan | |||
3875566 | 3875566 | 2022-02-19 | Japan | Ehime | 14909 | 106 | 0 | 33.624835 | 132.856842 | 2022-02-20 04:21:00 | Ehime, Japan | |||
3855822 | 3855822 | 2022-02-18 | Japan | Ehime | 14693 | 105 | 0 | 33.624835 | 132.856842 | 2022-02-19 04:21:11 | Ehime, Japan | |||
1298041 | 1298041 | 2022-02-17 | Japan | Ehime | 14484 | 105 | 0 | 33.624835 | 132.856842 | 2022-02-18 04:21:04 | Ehime, Japan | |||
3820427 | 3820427 | 2022-02-16 | Japan | Ehime | 14205 | 105 | 0 | 33.624835 | 132.856842 | 2022-02-17 04:20:56 | Ehime, Japan | |||
3671641 | 3671641 | 2022-02-15 | Japan | Ehime | 13944 | 104 | 0 | 33.624835 | 132.856842 | 2022-02-16 04:21:10 | Ehime, Japan | |||
2641742 | 2641742 | 2022-02-14 | Japan | Ehime | 13663 | 101 | 0 | 33.624835 | 132.856842 | 2022-02-15 04:21:09 | Ehime, Japan | |||
186059 | 186059 | 2022-02-13 | Japan | Ehime | 13536 | 101 | 0 | 33.624835 | 132.856842 | 2022-02-14 04:20:51 | Ehime, Japan | |||
315905 | 315905 | 2022-02-12 | Japan | Ehime | 13288 | 99 | 0 | 33.624835 | 132.856842 | 2022-02-13 04:21:00 | Ehime, Japan | |||
233231 | 233231 | 2022-02-11 | Japan | Ehime | 13172 | 98 | 0 | 33.624835 | 132.856842 | 2022-02-12 04:21:06 | Ehime, Japan | |||
1464073 | 1464073 | 2022-02-10 | Japan | Ehime | 12939 | 98 | 0 | 33.624835 | 132.856842 | 2022-02-11 04:21:09 | Ehime, Japan | |||
3074034 | 3074034 | 2022-02-09 | Japan | Ehime | 12709 | 94 | 0 | 33.624835 | 132.856842 | 2022-02-10 04:21:14 | Ehime, Japan | |||
1362341 | 1362341 | 2022-02-08 | Japan | Ehime | 12449 | 94 | 0 | 33.624835 | 132.856842 | 2022-02-09 04:21:04 | Ehime, Japan | |||
71079 | 71079 | 2022-02-07 | Japan | Ehime | 12205 | 94 | 0 | 33.624835 | 132.856842 | 2022-02-08 04:21:15 | Ehime, Japan | |||
2012695 | 2012695 | 2022-02-06 | Japan | Ehime | 12046 | 92 | 0 | 33.624835 | 132.856842 | 2022-02-07 04:21:05 | Ehime, Japan | |||
1294024 | 1294024 | 2022-02-05 | Japan | Ehime | 11867 | 92 | 0 | 33.624835 | 132.856842 | 2022-02-06 04:21:00 | Ehime, Japan | |||
2327352 | 2327352 | 2022-02-04 | Japan | Ehime | 11554 | 90 | 0 | 33.624835 | 132.856842 | 2022-02-05 04:21:05 | Ehime, Japan | |||
2473943 | 2473943 | 2022-02-03 | Japan | Ehime | 11291 | 89 | 0 | 33.624835 | 132.856842 | 2022-02-04 04:21:10 | Ehime, Japan | |||
459368 | 459368 | 2022-02-02 | Japan | Ehime | 10952 | 87 | 0 | 33.624835 | 132.856842 | 2022-02-03 04:21:21 | Ehime, 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]);