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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687465 | 3687465 | 2022-01-13 | Japan | Aichi | 110606 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-14 04:21:54 | Aichi, Japan | |||
3613049 | 3613049 | 2022-01-12 | Japan | Aichi | 109570 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-13 08:00:09 | Aichi, Japan | |||
1113574 | 1113574 | 2022-01-11 | Japan | Aichi | 108848 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-12 04:21:44 | Aichi, Japan | |||
1692302 | 1692302 | 2022-01-10 | Japan | Aichi | 108612 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-11 04:22:01 | Aichi, Japan | |||
126717 | 126717 | 2022-01-09 | Japan | Aichi | 108371 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-10 04:22:07 | Aichi, Japan | |||
1215552 | 1215552 | 2022-01-08 | Japan | Aichi | 108005 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-09 04:21:46 | Aichi, Japan | |||
1389645 | 1389645 | 2022-01-07 | Japan | Aichi | 107607 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-08 04:21:53 | Aichi, Japan | |||
2610032 | 2610032 | 2022-01-06 | Japan | Aichi | 107411 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-07 04:22:09 | Aichi, Japan | |||
1281974 | 1281974 | 2022-01-05 | Japan | Aichi | 107253 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-06 04:22:09 | Aichi, Japan | |||
1285990 | 1285990 | 2022-01-04 | Japan | Aichi | 107180 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-05 04:21:59 | Aichi, Japan | |||
1700334 | 1700334 | 2022-01-03 | Japan | Aichi | 107146 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-04 04:22:17 | Aichi, Japan | |||
3519417 | 3519417 | 2022-01-02 | Japan | Aichi | 107131 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-03 02:22:25 | Aichi, Japan | |||
2167547 | 2167547 | 2022-01-01 | Japan | Aichi | 107109 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-02 04:20:52 | Aichi, Japan | |||
2776978 | 2776978 | 2021-12-31 | Japan | Aichi | 107096 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-01 04:22:14 | Aichi, Japan | |||
3998635 | 3998635 | 2021-12-30 | Japan | Aichi | 107078 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-31 04:21:50 | Aichi, Japan | |||
1668442 | 1668442 | 2021-12-29 | Japan | Aichi | 107062 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-30 04:21:25 | Aichi, Japan | |||
1432551 | 1432551 | 2021-12-28 | Japan | Aichi | 107045 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-29 03:21:43 | Aichi, Japan | |||
730512 | 730512 | 2021-12-27 | Japan | Aichi | 107034 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-28 04:21:47 | Aichi, Japan | |||
2111684 | 2111684 | 2021-12-26 | Japan | Aichi | 107032 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-27 04:21:58 | Aichi, Japan | |||
3605056 | 3605056 | 2021-12-25 | Japan | Aichi | 107026 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-26 04:21:50 | Aichi, Japan | |||
2963374 | 2963374 | 2021-12-24 | Japan | Aichi | 107022 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-25 04:21:37 | Aichi, Japan | |||
3816406 | 3816406 | 2021-12-23 | Japan | Aichi | 107017 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-24 04:21:34 | Aichi, Japan | |||
798414 | 798414 | 2021-12-22 | Japan | Aichi | 107013 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-23 04:21:21 | Aichi, Japan | |||
3828454 | 3828454 | 2021-12-21 | Japan | Aichi | 107010 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-22 04:21:54 | Aichi, Japan | |||
1254757 | 1254757 | 2021-12-20 | Japan | Aichi | 107001 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-21 03:21:27 | Aichi, Japan | |||
2903700 | 2903700 | 2021-12-19 | Japan | Aichi | 106998 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-20 04:21:43 | Aichi, Japan | |||
1258773 | 1258773 | 2021-12-18 | Japan | Aichi | 106998 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-19 04:21:11 | Aichi, Japan | |||
2398801 | 2398801 | 2021-12-17 | Japan | Aichi | 106991 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-18 02:22:20 | Aichi, Japan | |||
1716339 | 1716339 | 2021-12-16 | Japan | Aichi | 106986 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-17 04:22:14 | Aichi, Japan | |||
3496173 | 3496173 | 2021-12-15 | Japan | Aichi | 106983 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-16 04:22:11 | Aichi, Japan | |||
2087958 | 2087958 | 2021-12-14 | Japan | Aichi | 106977 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-15 03:22:16 | Aichi, Japan | |||
782375 | 782375 | 2021-12-13 | Japan | Aichi | 106968 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-14 04:22:38 | Aichi, Japan | |||
1660410 | 1660410 | 2021-12-12 | Japan | Aichi | 106966 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-13 04:22:02 | Aichi, Japan | |||
1664426 | 1664426 | 2021-12-11 | Japan | Aichi | 106958 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-12 04:22:12 | Aichi, Japan | |||
3655578 | 3655578 | 2021-12-10 | Japan | Aichi | 106953 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-11 04:22:45 | Aichi, Japan | |||
1077909 | 1077909 | 2021-12-09 | Japan | Aichi | 106942 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-10 04:22:28 | Aichi, Japan | |||
550758 | 550758 | 2021-12-08 | Japan | Aichi | 106933 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-09 04:22:49 | Aichi, Japan | |||
404278 | 404278 | 2021-12-07 | Japan | Aichi | 106926 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-08 04:22:46 | Aichi, Japan | |||
1030360 | 1030360 | 2021-12-06 | Japan | Aichi | 106915 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-07 04:22:34 | Aichi, Japan | |||
1740523 | 1740523 | 2021-12-05 | Japan | Aichi | 106914 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-06 04:22:34 | Aichi, Japan | |||
137955 | 137955 | 2021-12-04 | Japan | Aichi | 106910 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-05 04:22:25 | Aichi, Japan | |||
2195608 | 2195608 | 2021-12-03 | Japan | Aichi | 106904 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-04 04:22:18 | Aichi, Japan | |||
314 | 314 | 2021-12-02 | Japan | Aichi | 106899 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-03 04:23:05 | Aichi, Japan | |||
1144913 | 1144913 | 2021-12-01 | Japan | Aichi | 106895 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-02 04:22:37 | Aichi, Japan | |||
3401425 | 3401425 | 2021-11-30 | Japan | Aichi | 106888 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-01 04:22:29 | Aichi, Japan | |||
149968 | 149968 | 2021-11-29 | Japan | Aichi | 106878 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-30 04:22:53 | Aichi, Japan | |||
1231614 | 1231614 | 2021-11-28 | Japan | Aichi | 106872 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-29 04:22:30 | Aichi, Japan | |||
1358321 | 1358321 | 2021-11-27 | Japan | Aichi | 106869 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-28 04:22:43 | Aichi, Japan | |||
758312 | 758312 | 2021-11-26 | Japan | Aichi | 106861 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-27 04:22:45 | Aichi, Japan | |||
1802729 | 1802729 | 2021-11-25 | Japan | Aichi | 106857 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-26 04:22:33 | Aichi, Japan | |||
904163 | 904163 | 2021-11-24 | Japan | Aichi | 106851 | 1160 | 0 | 35.035551 | 137.211621 | 2021-11-25 04:22:33 | Aichi, Japan | |||
3070013 | 3070013 | 2021-11-23 | Japan | Aichi | 106843 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-24 04:22:14 | Aichi, Japan | |||
3749111 | 3749111 | 2021-11-22 | Japan | Aichi | 106832 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-23 04:22:39 | Aichi, Japan | |||
1014318 | 1014318 | 2021-11-21 | Japan | Aichi | 106827 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-22 04:22:20 | Aichi, Japan | |||
722482 | 722482 | 2021-11-20 | Japan | Aichi | 106825 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-21 04:22:13 | Aichi, Japan | |||
162012 | 162012 | 2021-11-19 | Japan | Aichi | 106821 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-20 04:22:17 | Aichi, Japan | |||
3288899 | 3288899 | 2021-11-18 | Japan | Aichi | 106814 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-19 04:21:40 | Aichi, Japan | |||
447355 | 447355 | 2021-11-17 | Japan | Aichi | 106807 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-18 04:21:33 | Aichi, Japan | |||
3342605 | 3342605 | 2021-11-16 | Japan | Aichi | 106794 | 1158 | 0 | 35.035551 | 137.211621 | 2021-11-17 04:21:48 | Aichi, Japan | |||
2287441 | 2287441 | 2021-11-15 | Japan | Aichi | 106786 | 1158 | 0 | 35.035551 | 137.211621 | 2021-11-16 04:21:10 | Aichi, Japan | |||
1322215 | 1322215 | 2021-11-14 | Japan | Aichi | 106784 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-15 04:21:36 | Aichi, Japan | |||
686341 | 686341 | 2021-11-13 | Japan | Aichi | 106773 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-14 04:21:31 | Aichi, Japan | |||
714450 | 714450 | 2021-11-12 | Japan | Aichi | 106764 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-13 04:21:38 | Aichi, Japan | |||
28400 | 28400 | 2021-11-11 | Japan | Aichi | 106746 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-12 04:22:01 | Aichi, Japan | |||
2844839 | 2844839 | 2021-11-10 | Japan | Aichi | 106737 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-11 04:21:45 | Aichi, Japan | |||
87109 | 87109 | 2021-11-09 | Japan | Aichi | 106729 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-10 04:21:38 | Aichi, Japan | |||
3639537 | 3639537 | 2021-11-08 | Japan | Aichi | 106724 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-09 04:21:36 | Aichi, Japan | |||
2000645 | 2000645 | 2021-11-07 | Japan | Aichi | 106720 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-08 04:21:43 | Aichi, Japan | |||
495636 | 495636 | 2021-11-06 | Japan | Aichi | 106704 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-07 04:21:53 | Aichi, Japan | |||
3121491 | 3121491 | 2021-11-05 | Japan | Aichi | 106693 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-06 04:21:51 | Aichi, Japan | |||
698389 | 698389 | 2021-11-04 | Japan | Aichi | 106678 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-05 04:21:54 | Aichi, Japan | |||
276167 | 276167 | 2021-11-03 | Japan | Aichi | 106677 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-04 04:22:20 | Aichi, Japan | |||
43692 | 43692 | 2021-11-02 | Japan | Aichi | 106655 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-03 06:22:09 | Aichi, Japan | |||
3511388 | 3511388 | 2021-11-01 | Japan | Aichi | 106645 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-02 04:22:03 | Aichi, Japan | |||
287980 | 287980 | 2021-10-31 | Japan | Aichi | 106640 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-01 04:22:01 | Aichi, Japan | |||
2720986 | 2720986 | 2021-10-30 | Japan | Aichi | 106628 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-31 04:22:08 | Aichi, Japan | |||
567088 | 567088 | 2021-10-29 | Japan | Aichi | 106610 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-30 04:22:03 | Aichi, Japan | |||
4330 | 4330 | 2021-10-28 | Japan | Aichi | 106589 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-29 04:22:03 | Aichi, Japan | |||
534720 | 534720 | 2021-10-27 | Japan | Aichi | 106566 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-28 04:22:08 | Aichi, Japan | |||
3492157 | 3492157 | 2021-10-26 | Japan | Aichi | 106546 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-27 04:22:32 | Aichi, Japan | |||
3793879 | 3793879 | 2021-10-25 | Japan | Aichi | 106511 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-26 04:22:09 | Aichi, Japan | |||
682325 | 682325 | 2021-10-24 | Japan | Aichi | 106503 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-25 04:22:31 | Aichi, Japan | |||
770333 | 770333 | 2021-10-23 | Japan | Aichi | 106485 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-24 04:21:22 | Aichi, Japan | |||
653980 | 653980 | 2021-10-22 | Japan | Aichi | 106463 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-23 04:21:32 | Aichi, Japan | |||
2123727 | 2123727 | 2021-10-21 | Japan | Aichi | 106427 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-22 04:21:14 | Aichi, Japan | |||
443339 | 443339 | 2021-10-20 | Japan | Aichi | 106405 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-21 04:21:18 | Aichi, Japan | |||
597658 | 597658 | 2021-10-19 | Japan | Aichi | 106379 | 1155 | 0 | 35.035551 | 137.211621 | 2021-10-20 04:21:00 | Aichi, Japan | |||
2043835 | 2043835 | 2021-10-18 | Japan | Aichi | 106364 | 1153 | 0 | 35.035551 | 137.211621 | 2021-10-19 04:20:54 | Aichi, Japan | |||
1909196 | 1909196 | 2021-10-17 | Japan | Aichi | 106354 | 1153 | 0 | 35.035551 | 137.211621 | 2021-10-18 04:21:10 | Aichi, Japan | |||
934785 | 934785 | 2021-10-16 | Japan | Aichi | 106325 | 1152 | 0 | 35.035551 | 137.211621 | 2021-10-17 04:21:29 | Aichi, Japan | |||
2943340 | 2943340 | 2021-10-15 | Japan | Aichi | 106292 | 1152 | 0 | 35.035551 | 137.211621 | 2021-10-16 04:21:15 | Aichi, Japan | |||
491620 | 491620 | 2021-10-14 | Japan | Aichi | 106258 | 1152 | 0 | 35.035551 | 137.211621 | 2021-10-15 04:21:26 | Aichi, Japan | |||
633908 | 633908 | 2021-10-13 | Japan | Aichi | 106224 | 1152 | 0 | 35.035551 | 137.211621 | 2021-10-14 04:21:29 | Aichi, Japan | |||
1491586 | 1491586 | 2021-10-12 | Japan | Aichi | 106184 | 1151 | 0 | 35.035551 | 137.211621 | 2021-10-13 04:20:51 | Aichi, Japan | |||
3007319 | 3007319 | 2021-10-11 | Japan | Aichi | 106149 | 1148 | 0 | 35.035551 | 137.211621 | 2021-10-12 04:21:09 | Aichi, Japan | |||
423335 | 423335 | 2021-10-10 | Japan | Aichi | 106134 | 1146 | 0 | 35.035551 | 137.211621 | 2021-10-11 04:21:31 | Aichi, Japan | |||
2876192 | 2876192 | 2021-10-09 | Japan | Aichi | 106099 | 1146 | 0 | 35.035551 | 137.211621 | 2021-10-10 04:21:38 | Aichi, Japan | |||
2959358 | 2959358 | 2021-10-08 | Japan | Aichi | 106056 | 1144 | 0 | 35.035551 | 137.211621 | 2021-10-09 04:21:34 | Aichi, Japan | |||
467396 | 467396 | 2021-10-07 | Japan | Aichi | 106014 | 1144 | 0 | 35.035551 | 137.211621 | 2021-10-08 04:21:25 | Aichi, Japan | |||
2458776 | 2458776 | 2021-10-06 | Japan | Aichi | 105953 | 1143 | 0 | 35.035551 | 137.211621 | 2021-10-07 04:21:36 | 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]);