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 = "Aichi" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533382 | 2533382 | 2022-05-12 | Japan | Aichi | 506057 | 2035 | 0 | 35.035551 | 137.211621 | 2022-05-13 04:20:51 | Aichi, Japan | |||
3444828 | 3444828 | 2022-05-11 | Japan | Aichi | 503684 | 2035 | 0 | 35.035551 | 137.211621 | 2022-05-12 04:20:54 | Aichi, Japan | |||
3535445 | 3535445 | 2022-05-10 | Japan | Aichi | 500955 | 2033 | 0 | 35.035551 | 137.211621 | 2022-05-11 04:20:48 | Aichi, Japan | |||
221980 | 221980 | 2022-05-09 | Japan | Aichi | 497955 | 2032 | 0 | 35.035551 | 137.211621 | 2022-05-10 04:20:50 | Aichi, Japan | |||
2331365 | 2331365 | 2022-05-08 | Japan | Aichi | 496746 | 2028 | 0 | 35.035551 | 137.211621 | 2022-05-09 04:20:54 | Aichi, Japan | |||
360327 | 360327 | 2022-05-07 | Japan | Aichi | 494439 | 2026 | 0 | 35.035551 | 137.211621 | 2022-05-08 04:20:49 | Aichi, Japan | |||
1397678 | 1397678 | 2022-05-06 | Japan | Aichi | 491780 | 2025 | 0 | 35.035551 | 137.211621 | 2022-05-07 04:21:09 | Aichi, Japan | |||
2598033 | 2598033 | 2022-05-05 | Japan | Aichi | 490785 | 2024 | 0 | 35.035551 | 137.211621 | 2022-05-06 04:21:00 | Aichi, Japan | |||
3265482 | 3265482 | 2022-05-04 | Japan | Aichi | 489899 | 2023 | 0 | 35.035551 | 137.211621 | 2022-05-05 04:20:55 | Aichi, Japan | |||
1572121 | 1572121 | 2022-05-03 | Japan | Aichi | 488772 | 2022 | 0 | 35.035551 | 137.211621 | 2022-05-04 04:20:59 | Aichi, Japan | |||
463381 | 463381 | 2022-05-02 | Japan | Aichi | 486842 | 2020 | 0 | 35.035551 | 137.211621 | 2022-05-03 04:21:00 | Aichi, Japan | |||
3916020 | 3916020 | 2022-05-01 | Japan | Aichi | 486028 | 2018 | 0 | 35.035551 | 137.211621 | 2022-05-02 04:21:10 | Aichi, Japan | |||
2840824 | 2840824 | 2022-04-30 | Japan | Aichi | 484600 | 2018 | 0 | 35.035551 | 137.211621 | 2022-05-01 04:20:57 | Aichi, Japan | |||
1157137 | 1157137 | 2022-04-29 | Japan | Aichi | 483649 | 2018 | 0 | 35.035551 | 137.211621 | 2022-04-30 04:21:05 | Aichi, Japan | |||
1696319 | 1696319 | 2022-04-28 | Japan | Aichi | 481790 | 2017 | 0 | 35.035551 | 137.211621 | 2022-04-29 04:20:59 | Aichi, Japan | |||
3851802 | 3851802 | 2022-04-27 | Japan | Aichi | 479477 | 2016 | 0 | 35.035551 | 137.211621 | 2022-04-28 04:20:47 | Aichi, Japan | |||
1326232 | 1326232 | 2022-04-26 | Japan | Aichi | 476835 | 2013 | 0 | 35.035551 | 137.211621 | 2022-04-27 04:20:52 | Aichi, Japan | |||
3722186 | 3722186 | 2022-04-25 | Japan | Aichi | 474063 | 2011 | 0 | 35.035551 | 137.211621 | 2022-04-26 04:20:51 | Aichi, Japan | |||
2028754 | 2028754 | 2022-04-24 | Japan | Aichi | 473077 | 2011 | 0 | 35.035551 | 137.211621 | 2022-04-25 04:20:56 | Aichi, Japan | |||
746329 | 746329 | 2022-04-23 | Japan | Aichi | 471087 | 2011 | 0 | 35.035551 | 137.211621 | 2022-04-24 04:20:56 | Aichi, Japan | |||
3436814 | 3436814 | 2022-04-22 | Japan | Aichi | 468618 | 2011 | 0 | 35.035551 | 137.211621 | 2022-04-23 04:20:50 | Aichi, Japan | |||
2892399 | 2892399 | 2022-04-21 | Japan | Aichi | 466252 | 2008 | 0 | 35.035551 | 137.211621 | 2022-04-22 04:20:45 | Aichi, Japan | |||
2307271 | 2307271 | 2022-04-20 | Japan | Aichi | 463758 | 2006 | 0 | 35.035551 | 137.211621 | 2022-04-21 04:20:46 | Aichi, Japan | |||
2251410 | 2251410 | 2022-04-19 | Japan | Aichi | 461120 | 2004 | 0 | 35.035551 | 137.211621 | 2022-04-20 04:20:45 | Aichi, Japan | |||
1845960 | 1845960 | 2022-04-18 | Japan | Aichi | 458680 | 2000 | 0 | 35.035551 | 137.211621 | 2022-04-19 04:21:00 | Aichi, Japan | |||
3416904 | 3416904 | 2022-04-17 | Japan | Aichi | 457894 | 1998 | 0 | 35.035551 | 137.211621 | 2022-04-18 04:21:12 | Aichi, Japan | |||
303853 | 303853 | 2022-04-16 | Japan | Aichi | 456040 | 1997 | 0 | 35.035551 | 137.211621 | 2022-04-17 04:20:59 | Aichi, Japan | |||
2669798 | 2669798 | 2022-04-15 | Japan | Aichi | 453566 | 1996 | 0 | 35.035551 | 137.211621 | 2022-04-16 04:20:48 | Aichi, Japan | |||
1223583 | 1223583 | 2022-04-14 | Japan | Aichi | 451035 | 1994 | 0 | 35.035551 | 137.211621 | 2022-04-15 04:20:57 | Aichi, Japan | |||
2442741 | 2442741 | 2022-04-13 | Japan | Aichi | 448102 | 1994 | 0 | 35.035551 | 137.211621 | 2022-04-13 23:21:06 | Aichi, Japan | |||
1948498 | 1948498 | 2022-04-12 | Japan | Aichi | 444672 | 1992 | 0 | 35.035551 | 137.211621 | 2022-04-13 04:21:03 | Aichi, Japan | |||
3206251 | 3206251 | 2022-04-11 | Japan | Aichi | 441272 | 1989 | 0 | 35.035551 | 137.211621 | 2022-04-12 04:20:49 | Aichi, Japan | |||
1576137 | 1576137 | 2022-04-10 | Japan | Aichi | 440074 | 1989 | 0 | 35.035551 | 137.211621 | 2022-04-11 04:21:02 | Aichi, Japan | |||
1652379 | 1652379 | 2022-04-09 | Japan | Aichi | 437820 | 1988 | 0 | 35.035551 | 137.211621 | 2022-04-10 04:20:52 | Aichi, Japan | |||
2115701 | 2115701 | 2022-04-08 | Japan | Aichi | 435094 | 1986 | 0 | 35.035551 | 137.211621 | 2022-04-09 04:20:42 | Aichi, Japan | |||
3320225 | 3320225 | 2022-04-07 | Japan | Aichi | 432242 | 1982 | 0 | 35.035551 | 137.211621 | 2022-04-08 04:20:48 | Aichi, Japan | |||
2800761 | 2800761 | 2022-04-06 | Japan | Aichi | 429459 | 1981 | 0 | 35.035551 | 137.211621 | 2022-04-07 04:20:53 | Aichi, Japan | |||
3867530 | 3867530 | 2022-04-05 | Japan | Aichi | 426244 | 1979 | 0 | 35.035551 | 137.211621 | 2022-04-06 04:20:49 | Aichi, Japan | |||
2748872 | 2748872 | 2022-04-04 | Japan | Aichi | 423116 | 1977 | 0 | 35.035551 | 137.211621 | 2022-04-05 04:20:48 | Aichi, Japan | |||
3730218 | 3730218 | 2022-04-03 | Japan | Aichi | 422042 | 1973 | 0 | 35.035551 | 137.211621 | 2022-04-04 04:20:51 | Aichi, Japan | |||
499653 | 499653 | 2022-04-02 | Japan | Aichi | 419954 | 1972 | 0 | 35.035551 | 137.211621 | 2022-04-03 04:20:48 | Aichi, Japan | |||
3350638 | 3350638 | 2022-04-01 | Japan | Aichi | 417391 | 1970 | 0 | 35.035551 | 137.211621 | 2022-04-02 04:20:47 | Aichi, Japan | |||
1539943 | 1539943 | 2022-03-31 | Japan | Aichi | 414701 | 1969 | 0 | 35.035551 | 137.211621 | 2022-04-01 04:20:28 | Aichi, Japan | |||
2477956 | 2477956 | 2022-03-30 | Japan | Aichi | 412008 | 1964 | 0 | 35.035551 | 137.211621 | 2022-03-31 04:20:56 | Aichi, Japan | |||
157997 | 157997 | 2022-03-29 | Japan | Aichi | 408731 | 1958 | 0 | 35.035551 | 137.211621 | 2022-03-30 04:20:45 | Aichi, Japan | |||
1436568 | 1436568 | 2022-03-28 | Japan | Aichi | 405804 | 1953 | 0 | 35.035551 | 137.211621 | 2022-03-29 04:20:46 | Aichi, Japan | |||
876249 | 876249 | 2022-03-27 | Japan | Aichi | 404720 | 1950 | 0 | 35.035551 | 137.211621 | 2022-03-28 04:20:33 | Aichi, Japan | |||
2163532 | 2163532 | 2022-03-26 | Japan | Aichi | 402430 | 1947 | 0 | 35.035551 | 137.211621 | 2022-03-27 04:20:47 | Aichi, Japan | |||
1720468 | 1720468 | 2022-03-25 | Japan | Aichi | 399836 | 1938 | 0 | 35.035551 | 137.211621 | 2022-03-26 04:20:23 | Aichi, Japan | |||
1468085 | 1468085 | 2022-03-24 | Japan | Aichi | 397117 | 1932 | 0 | 35.035551 | 137.211621 | 2022-03-25 04:20:46 | Aichi, Japan | |||
3022259 | 3022259 | 2022-03-23 | Japan | Aichi | 393893 | 1924 | 0 | 35.035551 | 137.211621 | 2022-03-24 04:20:43 | Aichi, Japan | |||
1905181 | 1905181 | 2022-03-22 | Japan | Aichi | 390735 | 1918 | 0 | 35.035551 | 137.211621 | 2022-03-23 04:20:48 | Aichi, Japan | |||
3238312 | 3238312 | 2022-03-21 | Japan | Aichi | 389795 | 1915 | 0 | 35.035551 | 137.211621 | 2022-03-22 04:20:54 | Aichi, Japan | |||
24385 | 24385 | 2022-03-20 | Japan | Aichi | 388713 | 1910 | 0 | 35.035551 | 137.211621 | 2022-03-21 04:20:50 | Aichi, Japan | |||
1656395 | 1656395 | 2022-03-19 | Japan | Aichi | 386676 | 1910 | 0 | 35.035551 | 137.211621 | 2022-03-20 04:20:45 | Aichi, Japan | |||
335921 | 335921 | 2022-03-18 | Japan | Aichi | 384268 | 1905 | 0 | 35.035551 | 137.211621 | 2022-03-19 04:20:47 | Aichi, Japan | |||
694374 | 694374 | 2022-03-17 | Japan | Aichi | 381670 | 1888 | 0 | 35.035551 | 137.211621 | 2022-03-18 04:20:55 | Aichi, Japan | |||
2319317 | 2319317 | 2022-03-16 | Japan | Aichi | 378884 | 1868 | 0 | 35.035551 | 137.211621 | 2022-03-17 04:20:56 | Aichi, Japan | |||
261517 | 261517 | 2022-03-15 | Japan | Aichi | 375123 | 1854 | 0 | 35.035551 | 137.211621 | 2022-03-16 04:20:50 | Aichi, Japan | |||
2263876 | 2263876 | 2022-03-14 | Japan | Aichi | 371607 | 1846 | 0 | 35.035551 | 137.211621 | 2022-03-15 04:20:47 | Aichi, Japan | |||
3627942 | 3627942 | 2022-03-13 | Japan | Aichi | 370289 | 1839 | 0 | 35.035551 | 137.211621 | 2022-03-14 04:20:46 | Aichi, Japan | |||
950850 | 950850 | 2022-03-12 | Japan | Aichi | 367742 | 1836 | 0 | 35.035551 | 137.211621 | 2022-03-13 04:20:49 | Aichi, Japan | |||
356311 | 356311 | 2022-03-11 | Japan | Aichi | 364168 | 1823 | 0 | 35.035551 | 137.211621 | 2022-03-12 04:20:50 | Aichi, Japan | |||
1865463 | 1865463 | 2022-03-10 | Japan | Aichi | 361067 | 1796 | 0 | 35.035551 | 137.211621 | 2022-03-11 04:20:50 | Aichi, Japan | |||
2140158 | 2140158 | 2022-03-09 | Japan | Aichi | 358069 | 1785 | 0 | 35.035551 | 137.211621 | 2022-03-10 04:20:48 | Aichi, Japan | |||
919669 | 919669 | 2022-03-08 | Japan | Aichi | 353432 | 1764 | 0 | 35.035551 | 137.211621 | 2022-03-09 04:20:59 | Aichi, Japan | |||
1547956 | 1547956 | 2022-03-07 | Japan | Aichi | 349090 | 1751 | 0 | 35.035551 | 137.211621 | 2022-03-08 04:20:54 | Aichi, Japan | |||
2199625 | 2199625 | 2022-03-06 | Japan | Aichi | 346892 | 1741 | 0 | 35.035551 | 137.211621 | 2022-03-07 04:20:47 | Aichi, Japan | |||
2092082 | 2092082 | 2022-03-05 | Japan | Aichi | 343839 | 1733 | 0 | 35.035551 | 137.211621 | 2022-03-06 04:20:49 | Aichi, Japan | |||
2665782 | 2665782 | 2022-03-04 | Japan | Aichi | 339609 | 1720 | 0 | 35.035551 | 137.211621 | 2022-03-05 04:21:10 | Aichi, Japan | |||
1644347 | 1644347 | 2022-03-03 | Japan | Aichi | 335305 | 1707 | 0 | 35.035551 | 137.211621 | 2022-03-04 04:21:09 | Aichi, Japan | |||
2525350 | 2525350 | 2022-03-02 | Japan | Aichi | 330497 | 1680 | 0 | 35.035551 | 137.211621 | 2022-03-03 04:21:01 | Aichi, Japan | |||
1992644 | 1992644 | 2022-03-01 | Japan | Aichi | 325272 | 1657 | 0 | 35.035551 | 137.211621 | 2022-03-02 04:21:07 | Aichi, Japan | |||
942818 | 942818 | 2022-02-28 | Japan | Aichi | 320637 | 1642 | 0 | 35.035551 | 137.211621 | 2022-03-01 04:21:09 | Aichi, Japan | |||
2733009 | 2733009 | 2022-02-27 | Japan | Aichi | 317382 | 1612 | 0 | 35.035551 | 137.211621 | 2022-02-28 04:21:05 | Aichi, Japan | |||
3046162 | 3046162 | 2022-02-26 | Japan | Aichi | 313038 | 1599 | 0 | 35.035551 | 137.211621 | 2022-02-27 04:21:04 | Aichi, Japan | |||
574817 | 574817 | 2022-02-25 | Japan | Aichi | 307859 | 1580 | 0 | 35.035551 | 137.211621 | 2022-02-26 04:21:12 | Aichi, Japan | |||
1511393 | 1511393 | 2022-02-24 | Japan | Aichi | 303673 | 1553 | 0 | 35.035551 | 137.211621 | 2022-02-25 04:21:11 | Aichi, Japan | |||
1057834 | 1057834 | 2022-02-23 | Japan | Aichi | 299298 | 1525 | 0 | 35.035551 | 137.211621 | 2022-02-24 04:21:14 | Aichi, Japan | |||
2446757 | 2446757 | 2022-02-22 | Japan | Aichi | 293256 | 1495 | 0 | 35.035551 | 137.211621 | 2022-02-23 04:21:09 | Aichi, Japan | |||
3718170 | 3718170 | 2022-02-21 | Japan | Aichi | 288471 | 1470 | 0 | 35.035551 | 137.211621 | 2022-02-22 04:21:01 | Aichi, Japan | |||
3912004 | 3912004 | 2022-02-20 | Japan | Aichi | 284794 | 1454 | 0 | 35.035551 | 137.211621 | 2022-02-21 04:21:05 | Aichi, Japan | |||
3875562 | 3875562 | 2022-02-19 | Japan | Aichi | 280104 | 1446 | 0 | 35.035551 | 137.211621 | 2022-02-20 04:21:00 | Aichi, Japan | |||
3855818 | 3855818 | 2022-02-18 | Japan | Aichi | 274353 | 1422 | 0 | 35.035551 | 137.211621 | 2022-02-19 04:21:11 | Aichi, Japan | |||
1298037 | 1298037 | 2022-02-17 | Japan | Aichi | 267954 | 1404 | 0 | 35.035551 | 137.211621 | 2022-02-18 04:21:04 | Aichi, Japan | |||
3820423 | 3820423 | 2022-02-16 | Japan | Aichi | 261570 | 1380 | 0 | 35.035551 | 137.211621 | 2022-02-17 04:20:56 | Aichi, Japan | |||
3671637 | 3671637 | 2022-02-15 | Japan | Aichi | 254979 | 1367 | 0 | 35.035551 | 137.211621 | 2022-02-16 04:21:10 | Aichi, Japan | |||
2641738 | 2641738 | 2022-02-14 | Japan | Aichi | 248317 | 1339 | 0 | 35.035551 | 137.211621 | 2022-02-15 04:21:09 | Aichi, Japan | |||
186055 | 186055 | 2022-02-13 | Japan | Aichi | 243897 | 1326 | 0 | 35.035551 | 137.211621 | 2022-02-14 04:20:51 | Aichi, Japan | |||
315901 | 315901 | 2022-02-12 | Japan | Aichi | 238431 | 1319 | 0 | 35.035551 | 137.211621 | 2022-02-13 04:21:00 | Aichi, Japan | |||
233227 | 233227 | 2022-02-11 | Japan | Aichi | 233331 | 1306 | 0 | 35.035551 | 137.211621 | 2022-02-12 04:21:06 | Aichi, Japan | |||
1464069 | 1464069 | 2022-02-10 | Japan | Aichi | 226692 | 1293 | 0 | 35.035551 | 137.211621 | 2022-02-11 04:21:09 | Aichi, Japan | |||
3074030 | 3074030 | 2022-02-09 | Japan | Aichi | 220571 | 1281 | 0 | 35.035551 | 137.211621 | 2022-02-10 04:21:14 | Aichi, Japan | |||
1362337 | 1362337 | 2022-02-08 | Japan | Aichi | 214284 | 1267 | 0 | 35.035551 | 137.211621 | 2022-02-09 04:21:04 | Aichi, Japan | |||
71075 | 71075 | 2022-02-07 | Japan | Aichi | 208429 | 1258 | 0 | 35.035551 | 137.211621 | 2022-02-08 04:21:15 | Aichi, Japan | |||
2012691 | 2012691 | 2022-02-06 | Japan | Aichi | 204322 | 1251 | 0 | 35.035551 | 137.211621 | 2022-02-07 04:21:05 | Aichi, Japan | |||
1294020 | 1294020 | 2022-02-05 | Japan | Aichi | 199624 | 1246 | 0 | 35.035551 | 137.211621 | 2022-02-06 04:21:00 | Aichi, Japan | |||
2327348 | 2327348 | 2022-02-04 | Japan | Aichi | 193179 | 1236 | 0 | 35.035551 | 137.211621 | 2022-02-05 04:21:05 | Aichi, Japan | |||
2473939 | 2473939 | 2022-02-03 | Japan | Aichi | 186978 | 1223 | 0 | 35.035551 | 137.211621 | 2022-02-04 04:21:10 | Aichi, Japan | |||
459364 | 459364 | 2022-02-02 | Japan | Aichi | 181151 | 1212 | 0 | 35.035551 | 137.211621 | 2022-02-03 04:21:21 | Aichi, 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]);