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 = "Osaka" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
346 | 346 | 2021-12-02 | Japan | Osaka | 203166 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-12-03 04:23:05 | Osaka, Japan | |||
4362 | 4362 | 2021-10-28 | Japan | Osaka | 202320 | 3044 | 0 | 34.620965000000005 | 135.507481 | 2021-10-29 04:22:03 | Osaka, Japan | |||
16387 | 16387 | 2021-09-18 | Japan | Osaka | 195304 | 2914 | 0 | 34.620965000000005 | 135.507481 | 2021-09-19 04:21:34 | Osaka, Japan | |||
24417 | 24417 | 2022-03-20 | Japan | Osaka | 758281 | 4489 | 0 | 34.620965000000005 | 135.507481 | 2022-03-21 04:20:50 | Osaka, Japan | |||
28432 | 28432 | 2021-11-11 | Japan | Osaka | 202825 | 3056 | 0 | 34.620965000000005 | 135.507481 | 2021-11-12 04:22:01 | Osaka, Japan | |||
32448 | 32448 | 2021-08-25 | Japan | Osaka | 154097 | 2772 | 0 | 34.620965000000005 | 135.507481 | 2021-08-26 04:21:28 | Osaka, Japan | |||
43724 | 43724 | 2021-11-02 | Japan | Osaka | 202509 | 3047 | 0 | 34.620965000000005 | 135.507481 | 2021-11-03 06:22:09 | Osaka, Japan | |||
63078 | 63078 | 2022-11-12 | Japan | Osaka | 2208968 | 6666 | 0 | 34.620965 | 135.507481 | 2022-11-13 04:21:14 | Osaka, Japan | |||
67093 | 67093 | 2021-09-01 | Japan | Osaka | 171724 | 2801 | 0 | 34.620965000000005 | 135.507481 | 2021-09-02 04:21:15 | Osaka, Japan | |||
71107 | 71107 | 2022-02-07 | Japan | Osaka | 421515 | 3218 | 0 | 34.620965000000005 | 135.507481 | 2022-02-08 04:21:15 | Osaka, Japan | |||
87141 | 87141 | 2021-11-09 | Japan | Osaka | 202735 | 3054 | 0 | 34.620965000000005 | 135.507481 | 2021-11-10 04:21:38 | Osaka, Japan | |||
91158 | 91158 | 2022-07-23 | Japan | Osaka | 1213341 | 5262 | 0 | 34.620965 | 135.507481 | 2022-07-24 04:20:47 | Osaka, Japan | |||
99342 | 99342 | 2022-01-14 | Japan | Osaka | 215408 | 3069 | 0 | 34.620965000000005 | 135.507481 | 2022-01-15 04:21:07 | Osaka, Japan | |||
103358 | 103358 | 2021-08-15 | Japan | Osaka | 132444 | 2742 | 0 | 34.620965000000005 | 135.507481 | 2021-08-16 04:21:31 | Osaka, Japan | |||
114768 | 114768 | 2022-09-06 | Japan | Osaka | 1970960 | 6159 | 0 | 34.620965 | 135.507481 | 2022-09-07 04:20:59 | Osaka, Japan | |||
126749 | 126749 | 2022-01-09 | Japan | Osaka | 207311 | 3066 | 0 | 34.620965000000005 | 135.507481 | 2022-01-10 04:22:07 | Osaka, Japan | |||
130766 | 130766 | 2022-10-04 | Japan | Osaka | 2104992 | 6471 | 0 | 34.620965 | 135.507481 | 2022-10-05 04:23:06 | Osaka, Japan | |||
137987 | 137987 | 2021-12-04 | Japan | Osaka | 203199 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-12-05 04:22:25 | Osaka, Japan | |||
142004 | 142004 | 2022-07-09 | Japan | Osaka | 1046138 | 5220 | 0 | 34.620965 | 135.507481 | 2022-07-10 04:20:54 | Osaka, Japan | |||
150000 | 150000 | 2021-11-29 | Japan | Osaka | 203122 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-11-30 04:22:53 | Osaka, Japan | |||
158029 | 158029 | 2022-03-29 | Japan | Osaka | 786559 | 4620 | 0 | 34.620965000000005 | 135.507481 | 2022-03-30 04:20:45 | Osaka, Japan | |||
162044 | 162044 | 2021-11-19 | Japan | Osaka | 202992 | 3060 | 0 | 34.620965000000005 | 135.507481 | 2021-11-20 04:22:17 | Osaka, Japan | |||
166061 | 166061 | 2022-06-21 | Japan | Osaka | 1000262 | 5106 | 0 | 34.620965 | 135.507481 | 2022-06-22 04:20:54 | Osaka, Japan | |||
178058 | 178058 | 2021-09-02 | Japan | Osaka | 174225 | 2809 | 0 | 34.620965000000005 | 135.507481 | 2021-09-03 04:21:20 | Osaka, Japan | |||
186087 | 186087 | 2022-02-13 | Japan | Osaka | 504833 | 3366 | 0 | 34.620965000000005 | 135.507481 | 2022-02-14 04:20:51 | Osaka, Japan | |||
198275 | 198275 | 2022-10-19 | Japan | Osaka | 2139200 | 6557 | 0 | 34.620965 | 135.507481 | 2022-10-20 04:22:59 | Osaka, Japan | |||
217996 | 217996 | 2022-12-26 | Japan | Osaka | 2489801 | 7051 | 0 | 34.620965 | 135.507481 | 2022-12-27 04:21:07 | Osaka, Japan | |||
222012 | 222012 | 2022-05-09 | Japan | Osaka | 914893 | 4967 | 0 | 34.620965 | 135.507481 | 2022-05-10 04:20:50 | Osaka, Japan | |||
229243 | 229243 | 2022-05-31 | Japan | Osaka | 973820 | 5046 | 0 | 34.620965 | 135.507481 | 2022-06-01 04:20:55 | Osaka, Japan | |||
233259 | 233259 | 2022-02-11 | Japan | Osaka | 485513 | 3329 | 0 | 34.620965000000005 | 135.507481 | 2022-02-12 04:21:06 | Osaka, Japan | |||
245301 | 245301 | 2021-08-17 | Japan | Osaka | 135264 | 2747 | 0 | 34.620965000000005 | 135.507481 | 2021-08-18 04:21:35 | Osaka, Japan | |||
249315 | 249315 | 2021-09-04 | Japan | Osaka | 178881 | 2827 | 0 | 34.620965000000005 | 135.507481 | 2021-09-05 04:21:33 | Osaka, Japan | |||
253330 | 253330 | 2022-09-08 | Japan | Osaka | 1988847 | 6205 | 0 | 34.620965 | 135.507481 | 2022-09-09 04:21:11 | Osaka, Japan | |||
257346 | 257346 | 2022-12-10 | Japan | Osaka | 2349441 | 6820 | 0 | 34.620965 | 135.507481 | 2022-12-11 04:20:50 | Osaka, Japan | |||
261549 | 261549 | 2022-03-15 | Japan | Osaka | 737142 | 4350 | 0 | 34.620965000000005 | 135.507481 | 2022-03-16 04:20:50 | Osaka, Japan | |||
276199 | 276199 | 2021-11-03 | Japan | Osaka | 202562 | 3047 | 0 | 34.620965000000005 | 135.507481 | 2021-11-04 04:22:20 | Osaka, Japan | |||
288012 | 288012 | 2021-10-31 | Japan | Osaka | 202466 | 3045 | 0 | 34.620965000000005 | 135.507481 | 2021-11-01 04:22:01 | Osaka, Japan | |||
292029 | 292029 | 2022-11-15 | Japan | Osaka | 2219137 | 6661 | 0 | 34.620965 | 135.507481 | 2022-11-16 04:21:09 | Osaka, Japan | |||
303885 | 303885 | 2022-04-16 | Japan | Osaka | 856087 | 4863 | 0 | 34.620965000000005 | 135.507481 | 2022-04-17 04:20:59 | Osaka, Japan | |||
307901 | 307901 | 2022-12-13 | Japan | Osaka | 2370146 | 6852 | 0 | 34.620965 | 135.507481 | 2022-12-14 04:21:04 | Osaka, Japan | |||
311917 | 311917 | 2022-11-13 | Japan | Osaka | 2212237 | 6670 | 0 | 34.620965 | 135.507481 | 2022-11-14 04:21:09 | Osaka, Japan | |||
315933 | 315933 | 2022-02-12 | Japan | Osaka | 492259 | 3340 | 0 | 34.620965000000005 | 135.507481 | 2022-02-13 04:21:00 | Osaka, Japan | |||
319949 | 319949 | 2022-10-30 | Japan | Osaka | 2165708 | 6619 | 0 | 34.620965 | 135.507481 | 2022-10-31 04:21:36 | Osaka, Japan | |||
327923 | 327923 | 2022-12-27 | Japan | Osaka | 2503786 | 7064 | 0 | 34.620965 | 135.507481 | 2022-12-28 04:21:04 | Osaka, Japan | |||
335953 | 335953 | 2022-03-18 | Japan | Osaka | 751740 | 4449 | 0 | 34.620965000000005 | 135.507481 | 2022-03-19 04:20:47 | Osaka, Japan | |||
348313 | 348313 | 2022-12-14 | Japan | Osaka | 2380481 | 6866 | 0 | 34.620965 | 135.507481 | 2022-12-15 04:20:58 | Osaka, Japan | |||
356343 | 356343 | 2022-03-11 | Japan | Osaka | 719240 | 4271 | 0 | 34.620965000000005 | 135.507481 | 2022-03-12 04:20:50 | Osaka, Japan | |||
360359 | 360359 | 2022-05-07 | Japan | Osaka | 910087 | 4967 | 0 | 34.620965 | 135.507481 | 2022-05-08 04:20:49 | Osaka, Japan | |||
372213 | 372213 | 2022-09-13 | Japan | Osaka | 2021581 | 6264 | 0 | 34.620965 | 135.507481 | 2022-09-14 04:20:44 | Osaka, Japan | |||
384240 | 384240 | 2022-09-23 | Japan | Osaka | 2074315 | 6393 | 0 | 34.620965 | 135.507481 | 2022-09-24 04:21:40 | Osaka, Japan | |||
396281 | 396281 | 2022-10-07 | Japan | Osaka | 2112527 | 6496 | 0 | 34.620965 | 135.507481 | 2022-10-08 04:22:56 | Osaka, Japan | |||
404310 | 404310 | 2021-12-07 | Japan | Osaka | 203228 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-12-08 04:22:46 | Osaka, Japan | |||
419352 | 419352 | 2022-09-18 | Japan | Osaka | 2051549 | 6346 | 0 | 34.620965 | 135.507481 | 2022-09-19 04:21:49 | Osaka, Japan | |||
423367 | 423367 | 2021-10-10 | Japan | Osaka | 201152 | 3005 | 0 | 34.620965000000005 | 135.507481 | 2021-10-11 04:21:31 | Osaka, Japan | |||
431374 | 431374 | 2022-11-03 | Japan | Osaka | 2178537 | 6633 | 0 | 34.620965 | 135.507481 | 2022-11-04 04:22:11 | Osaka, Japan | |||
443371 | 443371 | 2021-10-20 | Japan | Osaka | 201940 | 3031 | 0 | 34.620965000000005 | 135.507481 | 2021-10-21 04:21:18 | Osaka, Japan | |||
447387 | 447387 | 2021-11-17 | Japan | Osaka | 202938 | 3058 | 0 | 34.620965000000005 | 135.507481 | 2021-11-18 04:21:33 | Osaka, Japan | |||
451404 | 451404 | 2022-12-21 | Japan | Osaka | 2443633 | 6958 | 0 | 34.620965 | 135.507481 | 2022-12-22 04:20:56 | Osaka, Japan | |||
459396 | 459396 | 2022-02-02 | Japan | Osaka | 354408 | 3157 | 0 | 34.620965000000005 | 135.507481 | 2022-02-03 04:21:21 | Osaka, Japan | |||
463413 | 463413 | 2022-05-02 | Japan | Osaka | 898325 | 4950 | 0 | 34.620965 | 135.507481 | 2022-05-03 04:21:00 | Osaka, Japan | |||
467428 | 467428 | 2021-10-07 | Japan | Osaka | 200757 | 2990 | 0 | 34.620965000000005 | 135.507481 | 2021-10-08 04:21:25 | Osaka, Japan | |||
475459 | 475459 | 2022-06-26 | Japan | Osaka | 1006882 | 5114 | 0 | 34.620965 | 135.507481 | 2022-06-27 04:21:00 | Osaka, Japan | |||
479607 | 479607 | 2022-11-08 | Japan | Osaka | 2193290 | 6645 | 0 | 34.620965 | 135.507481 | 2022-11-09 04:21:22 | Osaka, Japan | |||
487637 | 487637 | 2022-11-25 | Japan | Osaka | 2263052 | 6713 | 0 | 34.620965 | 135.507481 | 2022-11-26 04:21:11 | Osaka, Japan | |||
491652 | 491652 | 2021-10-14 | Japan | Osaka | 201541 | 3018 | 0 | 34.620965000000005 | 135.507481 | 2021-10-15 04:21:26 | Osaka, Japan | |||
495668 | 495668 | 2021-11-06 | Japan | Osaka | 202653 | 3053 | 0 | 34.620965000000005 | 135.507481 | 2021-11-07 04:21:53 | Osaka, Japan | |||
499685 | 499685 | 2022-04-02 | Japan | Osaka | 802145 | 4714 | 0 | 34.620965000000005 | 135.507481 | 2022-04-03 04:20:48 | Osaka, Japan | |||
503701 | 503701 | 2022-12-17 | Japan | Osaka | 2407955 | 6907 | 0 | 34.620965 | 135.507481 | 2022-12-18 04:21:03 | Osaka, Japan | |||
507716 | 507716 | 2021-08-14 | Japan | Osaka | 130680 | 2742 | 0 | 34.620965000000005 | 135.507481 | 2021-08-15 04:21:41 | Osaka, Japan | |||
511730 | 511730 | 2021-08-19 | Japan | Osaka | 140003 | 2753 | 0 | 34.620965000000005 | 135.507481 | 2021-08-20 04:21:33 | Osaka, Japan | |||
515745 | 515745 | 2022-10-15 | Japan | Osaka | 2129690 | 6543 | 0 | 34.620965 | 135.507481 | 2022-10-16 04:22:39 | Osaka, Japan | |||
534752 | 534752 | 2021-10-27 | Japan | Osaka | 202259 | 3044 | 0 | 34.620965000000005 | 135.507481 | 2021-10-28 04:22:08 | Osaka, Japan | |||
538769 | 538769 | 2022-10-26 | Japan | Osaka | 2155882 | 6597 | 0 | 34.620965 | 135.507481 | 2022-10-27 04:22:01 | Osaka, Japan | |||
542785 | 542785 | 2022-12-15 | Japan | Osaka | 2390067 | 6881 | 0 | 34.620965 | 135.507481 | 2022-12-16 04:21:01 | Osaka, Japan | |||
550790 | 550790 | 2021-12-08 | Japan | Osaka | 203241 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-12-09 04:22:49 | Osaka, Japan | |||
554806 | 554806 | 2022-01-16 | Japan | Osaka | 222860 | 3069 | 0 | 34.620965000000005 | 135.507481 | 2022-01-17 04:21:08 | Osaka, Japan | |||
558823 | 558823 | 2022-06-16 | Japan | Osaka | 995095 | 5099 | 0 | 34.620965 | 135.507481 | 2022-06-17 04:20:56 | Osaka, Japan | |||
567120 | 567120 | 2021-10-29 | Japan | Osaka | 202372 | 3045 | 0 | 34.620965000000005 | 135.507481 | 2021-10-30 04:22:03 | Osaka, Japan | |||
574849 | 574849 | 2022-02-25 | Japan | Osaka | 625452 | 3814 | 0 | 34.620965000000005 | 135.507481 | 2022-02-26 04:21:12 | Osaka, Japan | |||
589660 | 589660 | 2021-08-08 | Japan | Osaka | 122456 | 2733 | 0 | 34.620965000000005 | 135.507481 | 2021-08-09 04:21:24 | Osaka, Japan | |||
593675 | 593675 | 2022-07-01 | Japan | Osaka | 1016315 | 5210 | 0 | 34.620965 | 135.507481 | 2022-07-02 04:21:16 | Osaka, Japan | |||
597690 | 597690 | 2021-10-19 | Japan | Osaka | 201867 | 3030 | 0 | 34.620965000000005 | 135.507481 | 2021-10-20 04:21:00 | Osaka, Japan | |||
601706 | 601706 | 2021-09-23 | Japan | Osaka | 197415 | 2940 | 0 | 34.620965000000005 | 135.507481 | 2021-09-24 04:21:44 | Osaka, Japan | |||
617879 | 617879 | 2022-11-05 | Japan | Osaka | 2184232 | 6639 | 0 | 34.620965 | 135.507481 | 2022-11-06 04:21:24 | Osaka, Japan | |||
621895 | 621895 | 2022-05-22 | Japan | Osaka | 962488 | 5029 | 0 | 34.620965 | 135.507481 | 2022-05-26 04:20:50 | Osaka, Japan | |||
629925 | 629925 | 2022-07-12 | Japan | Osaka | 1063693 | 5223 | 0 | 34.620965 | 135.507481 | 2022-07-13 04:20:58 | Osaka, Japan | |||
633940 | 633940 | 2021-10-13 | Japan | Osaka | 201429 | 3015 | 0 | 34.620965000000005 | 135.507481 | 2021-10-14 04:21:29 | Osaka, Japan | |||
641970 | 641970 | 2021-09-07 | Japan | Osaka | 183273 | 2838 | 0 | 34.620965000000005 | 135.507481 | 2021-09-08 04:21:31 | Osaka, Japan | |||
649998 | 649998 | 2021-08-09 | Japan | Osaka | 123451 | 2733 | 0 | 34.620965000000005 | 135.507481 | 2021-08-10 04:21:27 | Osaka, Japan | |||
654012 | 654012 | 2021-10-22 | Japan | Osaka | 202033 | 3039 | 0 | 34.620965000000005 | 135.507481 | 2021-10-23 04:21:32 | Osaka, Japan | |||
658331 | 658331 | 2022-05-13 | Japan | Osaka | 929311 | 4988 | 0 | 34.620965 | 135.507481 | 2022-05-14 04:20:48 | Osaka, Japan | |||
670316 | 670316 | 2022-07-21 | Japan | Osaka | 1170891 | 5248 | 0 | 34.620965 | 135.507481 | 2022-07-22 04:21:15 | Osaka, Japan | |||
674332 | 674332 | 2022-07-30 | Japan | Osaka | 1354667 | 5342 | 0 | 34.620965 | 135.507481 | 2022-07-31 04:21:02 | Osaka, Japan | |||
682357 | 682357 | 2021-10-24 | Japan | Osaka | 202117 | 3040 | 0 | 34.620965000000005 | 135.507481 | 2021-10-25 04:22:31 | Osaka, Japan | |||
686373 | 686373 | 2021-11-13 | Japan | Osaka | 202881 | 3056 | 0 | 34.620965000000005 | 135.507481 | 2021-11-14 04:21:31 | Osaka, Japan | |||
690390 | 690390 | 2022-12-23 | Japan | Osaka | 2465352 | 6995 | 0 | 34.620965 | 135.507481 | 2022-12-24 04:21:02 | Osaka, Japan | |||
694406 | 694406 | 2022-03-17 | Japan | Osaka | 747882 | 4425 | 0 | 34.620965000000005 | 135.507481 | 2022-03-18 04:20:55 | Osaka, Japan | |||
698421 | 698421 | 2021-11-04 | Japan | Osaka | 202582 | 3047 | 0 | 34.620965000000005 | 135.507481 | 2021-11-05 04:21:54 | Osaka, Japan | |||
706451 | 706451 | 2021-09-29 | Japan | Osaka | 199286 | 2966 | 0 | 34.620965000000005 | 135.507481 | 2021-09-30 04:21:20 | Osaka, Japan | |||
710467 | 710467 | 2022-11-01 | Japan | Osaka | 2170888 | 6620 | 0 | 34.620965 | 135.507481 | 2022-11-02 04:22:09 | Osaka, 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]);