johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Osaka" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, latitude, 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 | |||
8364 | 8364 | 2020-10-25 | Japan | Osaka | 12046 | 234 | 11128 | 684 | 34.620965000000005 | 135.507481 | 2020-10-26 04:25:02 | Osaka, Japan | ||
12372 | 12372 | 2021-01-26 | Japan | Osaka | 42105 | 857 | 35088 | 6160 | 34.620965000000005 | 135.507481 | 2021-01-27 05:23:41 | Osaka, Japan | ||
16387 | 16387 | 2021-09-18 | Japan | Osaka | 195304 | 2914 | 0 | 34.620965000000005 | 135.507481 | 2021-09-19 04:21:34 | Osaka, Japan | |||
20402 | 20402 | 2021-05-28 | Japan | Osaka | 99195 | 2260 | 85285 | 11650 | 34.620965000000005 | 135.507481 | 2021-05-29 04:20:41 | 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 | |||
36462 | 36462 | 2021-04-12 | Japan | Osaka | 60944 | 1219 | 50024 | 9701 | 34.620965000000005 | 135.507481 | 2021-04-13 04:20:37 | Osaka, Japan | ||
43724 | 43724 | 2021-11-02 | Japan | Osaka | 202509 | 3047 | 0 | 34.620965000000005 | 135.507481 | 2021-11-03 06:22:09 | Osaka, Japan | |||
50823 | 50823 | 2021-05-29 | Japan | Osaka | 99411 | 2291 | 86801 | 10319 | 34.620965000000005 | 135.507481 | 2021-05-30 04:20:55 | Osaka, Japan | ||
54837 | 54837 | 2021-03-07 | Japan | Osaka | 47669 | 1135 | 45126 | 1408 | 34.620965000000005 | 135.507481 | 2021-03-08 05:24:48 | Osaka, Japan | ||
62060 | 62060 | 2020-07-23 | Japan | Osaka | 2766 | 86 | 2012 | 668 | 34.620965000000005 | 135.507481 | 2020-07-24 05:30:40 | 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 | |||
75121 | 75121 | 2020-12-03 | Japan | Osaka | 21411 | 341 | 16245 | 4825 | 34.620965000000005 | 135.507481 | 2020-12-04 05:27:27 | Osaka, Japan | ||
79120 | 79120 | 2020-10-14 | Japan | Osaka | 11310 | 224 | 10572 | 514 | 34.620965000000005 | 135.507481 | 2020-10-15 04:24:28 | Osaka, Japan | ||
83127 | 83127 | 2021-05-25 | Japan | Osaka | 98265 | 2190 | 83782 | 12293 | 34.620965000000005 | 135.507481 | 2021-05-26 04:20:35 | 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 | |||
98411 | 98411 | 2020-08-04 | Japan | Osaka | 4719 | 92 | 3013 | 1614 | 34.620965000000005 | 135.507481 | 2020-08-05 04:34:43 | 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 | |||
107483 | 107483 | 2021-06-19 | Japan | Osaka | 102333 | 2589 | 96618 | 3126 | 34.620965000000005 | 135.507481 | 2021-06-20 04:21:48 | Osaka, Japan | ||
114768 | 114768 | 2022-09-06 | Japan | Osaka | 1970960 | 6159 | 0 | 34.620965 | 135.507481 | 2022-09-07 04:20:59 | Osaka, Japan | |||
122003 | 122003 | 2020-07-19 | Japan | Osaka | 2420 | 86 | 1873 | 461 | 34.620965000000005 | 135.507481 | 2020-07-20 05:34:40 | Osaka, Japan | ||
122736 | 122736 | 2020-11-18 | Japan | Osaka | 16038 | 265 | 13543 | 2230 | 34.620965000000005 | 135.507481 | 2020-11-19 05:25:23 | 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 | |||
146004 | 146004 | 2020-08-15 | Japan | Osaka | 6696 | 106 | 4719 | 1871 | 34.620965000000005 | 135.507481 | 2020-08-16 04:27:42 | Osaka, Japan | ||
150000 | 150000 | 2021-11-29 | Japan | Osaka | 203122 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-11-30 04:22:53 | Osaka, Japan | |||
154015 | 154015 | 2021-01-08 | Japan | Osaka | 33308 | 656 | 27515 | 5137 | 34.620965000000005 | 135.507481 | 2021-01-09 05:22:18 | 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 | |||
170076 | 170076 | 2021-04-16 | Japan | Osaka | 65587 | 1254 | 51638 | 12695 | 34.620965000000005 | 135.507481 | 2021-04-17 04:20:40 | Osaka, Japan | ||
177321 | 177321 | 2020-07-27 | Japan | Osaka | 3274 | 88 | 2080 | 1106 | 34.620965000000005 | 135.507481 | 2020-07-28 04:58:43 | Osaka, Japan | ||
178058 | 178058 | 2021-09-02 | Japan | Osaka | 174225 | 2809 | 0 | 34.620965000000005 | 135.507481 | 2021-09-03 04:21:20 | Osaka, Japan | |||
182072 | 182072 | 2021-02-21 | Japan | Osaka | 46615 | 1089 | 43612 | 1914 | 34.620965000000005 | 135.507481 | 2021-02-22 05:24:21 | Osaka, Japan | ||
186087 | 186087 | 2022-02-13 | Japan | Osaka | 504833 | 3366 | 0 | 34.620965000000005 | 135.507481 | 2022-02-14 04:20:51 | Osaka, Japan | |||
190101 | 190101 | 2021-01-11 | Japan | Osaka | 34966 | 680 | 28376 | 5910 | 34.620965000000005 | 135.507481 | 2021-01-12 05:22:15 | Osaka, Japan | ||
194099 | 194099 | 2020-08-31 | Japan | Osaka | 8542 | 152 | 7027 | 1363 | 34.620965000000005 | 135.507481 | 2020-09-01 04:28:31 | Osaka, Japan | ||
198275 | 198275 | 2022-10-19 | Japan | Osaka | 2139200 | 6557 | 0 | 34.620965 | 135.507481 | 2022-10-20 04:22:59 | Osaka, Japan | |||
202288 | 202288 | 2020-12-25 | Japan | Osaka | 28431 | 525 | 24093 | 3813 | 34.620965000000005 | 135.507481 | 2020-12-26 05:22:28 | Osaka, Japan | ||
206286 | 206286 | 2020-08-19 | Japan | Osaka | 7286 | 122 | 5284 | 1880 | 34.620965000000005 | 135.507481 | 2020-08-20 04:27:43 | Osaka, Japan | ||
210272 | 210272 | 2020-10-29 | Japan | Osaka | 12473 | 237 | 11372 | 864 | 34.620965000000005 | 135.507481 | 2020-10-30 04:24:49 | Osaka, Japan | ||
217276 | 217276 | 2020-06-08 | Japan | Osaka | 1785 | 84 | 1635 | 66 | 34.620965000000005 | 135.507481 | 2020-06-09 03:33:03 | 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 | |||
237273 | 237273 | 2021-01-18 | Japan | Osaka | 38560 | 752 | 30989 | 6819 | 34.620965000000005 | 135.507481 | 2021-01-19 05:22:15 | Osaka, Japan | ||
241287 | 241287 | 2021-04-02 | Japan | Osaka | 53430 | 1189 | 47587 | 4654 | 34.620965000000005 | 135.507481 | 2021-04-03 04:20:44 | 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 | |||
272187 | 272187 | 2020-11-10 | Japan | Osaka | 14120 | 256 | 12438 | 1426 | 34.620965000000005 | 135.507481 | 2020-11-11 05:25:30 | Osaka, Japan | ||
276199 | 276199 | 2021-11-03 | Japan | Osaka | 202562 | 3047 | 0 | 34.620965000000005 | 135.507481 | 2021-11-04 04:22:20 | Osaka, Japan | |||
280215 | 280215 | 2021-02-24 | Japan | Osaka | 46839 | 1101 | 44047 | 1691 | 34.620965000000005 | 135.507481 | 2021-02-25 05:24:57 | Osaka, Japan | ||
287284 | 287284 | 2020-06-15 | Japan | Osaka | 1787 | 86 | 1675 | 26 | 34.620965000000005 | 135.507481 | 2020-06-16 04:33:09 | 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 | |||
296044 | 296044 | 2021-07-15 | Japan | Osaka | 105849 | 2700 | 100191 | 2958 | 34.620965000000005 | 135.507481 | 2021-07-16 04:21:22 | Osaka, Japan | ||
303156 | 303156 | 2020-07-01 | Japan | Osaka | 1843 | 86 | 1705 | 52 | 34.620965000000005 | 135.507481 | 2020-07-02 04:33:46 | 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 | |||
327098 | 327098 | 2020-07-20 | Japan | Osaka | 2469 | 86 | 1873 | 510 | 34.620965000000005 | 135.507481 | 2020-07-21 04:38:46 | Osaka, Japan | ||
327923 | 327923 | 2022-12-27 | Japan | Osaka | 2503786 | 7064 | 0 | 34.620965 | 135.507481 | 2022-12-28 04:21:04 | Osaka, Japan | |||
331938 | 331938 | 2021-08-04 | Japan | Osaka | 117774 | 2724 | 105251 | 9799 | 34.620965000000005 | 135.507481 | 2021-08-05 04:21:51 | Osaka, Japan | ||
335953 | 335953 | 2022-03-18 | Japan | Osaka | 751740 | 4449 | 0 | 34.620965000000005 | 135.507481 | 2022-03-19 04:20:47 | Osaka, Japan | |||
340307 | 340307 | 2021-02-03 | Japan | Osaka | 44389 | 958 | 38709 | 4722 | 34.620965000000005 | 135.507481 | 2021-02-04 05:22:26 | Osaka, Japan | ||
344307 | 344307 | 2020-09-14 | Japan | Osaka | 9636 | 180 | 8561 | 895 | 34.620965000000005 | 135.507481 | 2020-09-15 03:22:50 | Osaka, Japan | ||
348313 | 348313 | 2022-12-14 | Japan | Osaka | 2380481 | 6866 | 0 | 34.620965 | 135.507481 | 2022-12-15 04:20:58 | Osaka, Japan | |||
352328 | 352328 | 2021-03-11 | Japan | Osaka | 47982 | 1146 | 45425 | 1411 | 34.620965000000005 | 135.507481 | 2021-03-12 05:26:50 | 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 | |||
367504 | 367504 | 2020-07-16 | Japan | Osaka | 2192 | 86 | 1826 | 280 | 34.620965000000005 | 135.507481 | 2020-07-17 04:34:50 | Osaka, Japan | ||
371476 | 371476 | 2020-08-08 | Japan | Osaka | 5573 | 95 | 3641 | 1837 | 34.620965000000005 | 135.507481 | 2020-08-09 04:34:54 | Osaka, Japan | ||
372213 | 372213 | 2022-09-13 | Japan | Osaka | 2021581 | 6264 | 0 | 34.620965 | 135.507481 | 2022-09-14 04:20:44 | Osaka, Japan | |||
376214 | 376214 | 2020-11-06 | Japan | Osaka | 13485 | 249 | 12014 | 1222 | 34.620965000000005 | 135.507481 | 2020-11-07 05:24:52 | Osaka, Japan | ||
380225 | 380225 | 2021-04-30 | Japan | Osaka | 81179 | 1456 | 59399 | 20324 | 34.620965000000005 | 135.507481 | 2021-05-01 04:20:47 | Osaka, Japan | ||
384240 | 384240 | 2022-09-23 | Japan | Osaka | 2074315 | 6393 | 0 | 34.620965 | 135.507481 | 2022-09-24 04:21:40 | Osaka, Japan | |||
388255 | 388255 | 2021-04-04 | Japan | Osaka | 54689 | 1194 | 47908 | 5587 | 34.620965000000005 | 135.507481 | 2021-04-05 04:20:35 | Osaka, Japan | ||
392267 | 392267 | 2020-11-27 | Japan | Osaka | 19166 | 302 | 15035 | 3829 | 34.620965000000005 | 135.507481 | 2020-11-28 05:25:50 | Osaka, Japan | ||
396281 | 396281 | 2022-10-07 | Japan | Osaka | 2112527 | 6496 | 0 | 34.620965 | 135.507481 | 2022-10-08 04:22:56 | Osaka, Japan | |||
400296 | 400296 | 2021-06-29 | Japan | Osaka | 103274 | 2668 | 98306 | 2300 | 34.620965000000005 | 135.507481 | 2021-06-30 04:21:41 | Osaka, Japan | ||
404310 | 404310 | 2021-12-07 | Japan | Osaka | 203228 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-12-08 04:22:46 | Osaka, Japan | |||
408326 | 408326 | 2021-07-28 | Japan | Osaka | 111280 | 2719 | 102973 | 5588 | 34.620965000000005 | 135.507481 | 2021-07-29 04:21:33 | Osaka, Japan | ||
415448 | 415448 | 2020-07-05 | Japan | Osaka | 1885 | 86 | 1723 | 76 | 34.620965000000005 | 135.507481 | 2020-07-06 04:33:57 | 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 |
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]);