daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

946 rows where province_or_state = "Ishikawa" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Ishikawa · 946 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-29 Japan Ishikawa     237984 380 0   36.769464 136.771027 2022-12-30 04:21:04 Ishikawa, Japan
2022-12-28 Japan Ishikawa     236569 377 0   36.769464 136.771027 2022-12-29 04:21:01 Ishikawa, Japan
2022-12-27 Japan Ishikawa     234963 370 0   36.769464 136.771027 2022-12-28 04:21:04 Ishikawa, Japan
2022-12-26 Japan Ishikawa     232971 366 0   36.769464 136.771027 2022-12-27 04:21:07 Ishikawa, Japan
2022-12-25 Japan Ishikawa     232493 365 0   36.769464 136.771027 2022-12-26 04:21:06 Ishikawa, Japan
2022-12-24 Japan Ishikawa     231558 364 0   36.769464 136.771027 2022-12-25 04:21:04 Ishikawa, Japan
2022-12-23 Japan Ishikawa     230311 361 0   36.769464 136.771027 2022-12-24 04:21:02 Ishikawa, Japan
2022-12-22 Japan Ishikawa     228952 356 0   36.769464 136.771027 2022-12-23 04:21:04 Ishikawa, Japan
2022-12-21 Japan Ishikawa     227469 353 0   36.769464 136.771027 2022-12-22 04:20:56 Ishikawa, Japan
2022-12-20 Japan Ishikawa     225788 352 0   36.769464 136.771027 2022-12-21 04:21:03 Ishikawa, Japan
2022-12-19 Japan Ishikawa     223967 352 0   36.769464 136.771027 2022-12-20 04:21:04 Ishikawa, Japan
2022-12-18 Japan Ishikawa     223501 352 0   36.769464 136.771027 2022-12-19 04:21:03 Ishikawa, Japan
2022-12-17 Japan Ishikawa     222384 351 0   36.769464 136.771027 2022-12-18 04:21:03 Ishikawa, Japan
2022-12-16 Japan Ishikawa     220962 349 0   36.769464 136.771027 2022-12-17 04:21:04 Ishikawa, Japan
2022-12-15 Japan Ishikawa     219488 346 0   36.769464 136.771027 2022-12-16 04:21:01 Ishikawa, Japan
2022-12-14 Japan Ishikawa     218028 342 0   36.769464 136.771027 2022-12-15 04:20:58 Ishikawa, Japan
2022-12-13 Japan Ishikawa     216270 338 0   36.769464 136.771027 2022-12-14 04:21:04 Ishikawa, Japan
2022-12-12 Japan Ishikawa     214161 336 0   36.769464 136.771027 2022-12-13 04:21:01 Ishikawa, Japan
2022-12-11 Japan Ishikawa     213633 336 0   36.769464 136.771027 2022-12-12 04:21:01 Ishikawa, Japan
2022-12-10 Japan Ishikawa     212602 335 0   36.769464 136.771027 2022-12-11 04:20:50 Ishikawa, Japan
2022-12-09 Japan Ishikawa     211213 334 0   36.769464 136.771027 2022-12-10 04:21:02 Ishikawa, Japan
2022-12-08 Japan Ishikawa     209991 334 0   36.769464 136.771027 2022-12-09 04:21:05 Ishikawa, Japan
2022-12-07 Japan Ishikawa     208621 332 0   36.769464 136.771027 2022-12-08 04:21:07 Ishikawa, Japan
2022-12-06 Japan Ishikawa     207120 328 0   36.769464 136.771027 2022-12-07 04:20:58 Ishikawa, Japan
2022-12-05 Japan Ishikawa     205442 327 0   36.769464 136.771027 2022-12-06 04:21:03 Ishikawa, Japan
2022-12-04 Japan Ishikawa     205033 325 0   36.769464 136.771027 2022-12-05 04:20:58 Ishikawa, Japan
2022-12-03 Japan Ishikawa     204297 323 0   36.769464 136.771027 2022-12-04 04:20:56 Ishikawa, Japan
2022-12-02 Japan Ishikawa     203151 320 0   36.769464 136.771027 2022-12-03 04:21:02 Ishikawa, Japan
2022-12-01 Japan Ishikawa     202060 320 0   36.769464 136.771027 2022-12-02 04:21:07 Ishikawa, Japan
2022-11-30 Japan Ishikawa     200847 320 0   36.769464 136.771027 2022-12-01 04:21:03 Ishikawa, Japan
2022-11-29 Japan Ishikawa     199485 317 0   36.769464 136.771027 2022-11-30 04:21:07 Ishikawa, Japan
2022-11-28 Japan Ishikawa     197828 317 0   36.769464 136.771027 2022-11-29 04:21:05 Ishikawa, Japan
2022-11-27 Japan Ishikawa     197452 317 0   36.769464 136.771027 2022-11-28 04:21:02 Ishikawa, Japan
2022-11-26 Japan Ishikawa     196533 314 0   36.769464 136.771027 2022-11-27 04:21:05 Ishikawa, Japan
2022-11-25 Japan Ishikawa     195245 312 0   36.769464 136.771027 2022-11-26 04:21:11 Ishikawa, Japan
2022-11-24 Japan Ishikawa     193941 310 0   36.769464 136.771027 2022-11-25 04:21:06 Ishikawa, Japan
2022-11-23 Japan Ishikawa     193383 310 0   36.769464 136.771027 2022-11-24 04:21:09 Ishikawa, Japan
2022-11-22 Japan Ishikawa     191852 309 0   36.769464 136.771027 2022-11-23 04:21:06 Ishikawa, Japan
2022-11-21 Japan Ishikawa     190271 306 0   36.769464 136.771027 2022-11-22 04:20:47 Ishikawa, Japan
2022-11-20 Japan Ishikawa     189945 306 0   36.769464 136.771027 2022-11-21 04:21:05 Ishikawa, Japan
2022-11-19 Japan Ishikawa     189153 305 0   36.769464 136.771027 2022-11-20 04:21:08 Ishikawa, Japan
2022-11-18 Japan Ishikawa     188144 305 0   36.769464 136.771027 2022-11-19 04:21:14 Ishikawa, Japan
2022-11-17 Japan Ishikawa     187201 305 0   36.769464 136.771027 2022-11-18 04:21:15 Ishikawa, Japan
2022-11-16 Japan Ishikawa     186227 304 0   36.769464 136.771027 2022-11-17 04:21:11 Ishikawa, Japan
2022-11-15 Japan Ishikawa     185109 303 0   36.769464 136.771027 2022-11-16 04:21:09 Ishikawa, Japan
2022-11-14 Japan Ishikawa     183792 303 0   36.769464 136.771027 2022-11-15 04:21:16 Ishikawa, Japan
2022-11-13 Japan Ishikawa     183447 303 0   36.769464 136.771027 2022-11-14 04:21:09 Ishikawa, Japan
2022-11-12 Japan Ishikawa     182749 301 0   36.769464 136.771027 2022-11-13 04:21:14 Ishikawa, Japan
2022-11-11 Japan Ishikawa     181825 299 0   36.769464 136.771027 2022-11-12 04:20:41 Ishikawa, Japan
2022-11-10 Japan Ishikawa     181072 299 0   36.769464 136.771027 2022-11-11 04:21:22 Ishikawa, Japan
2022-11-09 Japan Ishikawa     180344 299 0   36.769464 136.771027 2022-11-10 04:21:16 Ishikawa, Japan
2022-11-08 Japan Ishikawa     179470 299 0   36.769464 136.771027 2022-11-09 04:21:22 Ishikawa, Japan
2022-11-07 Japan Ishikawa     178464 299 0   36.769464 136.771027 2022-11-08 04:21:21 Ishikawa, Japan
2022-11-06 Japan Ishikawa     178212 299 0   36.769464 136.771027 2022-11-07 04:21:26 Ishikawa, Japan
2022-11-05 Japan Ishikawa     177668 299 0   36.769464 136.771027 2022-11-06 04:21:24 Ishikawa, Japan
2022-11-04 Japan Ishikawa     176674 299 0   36.769464 136.771027 2022-11-05 04:21:52 Ishikawa, Japan
2022-11-03 Japan Ishikawa     176427 298 0   36.769464 136.771027 2022-11-04 04:22:11 Ishikawa, Japan
2022-11-02 Japan Ishikawa     175660 297 0   36.769464 136.771027 2022-11-03 04:22:05 Ishikawa, Japan
2022-11-01 Japan Ishikawa     174896 296 0   36.769464 136.771027 2022-11-02 04:22:09 Ishikawa, Japan
2022-10-31 Japan Ishikawa     174074 295 0   36.769464 136.771027 2022-11-01 04:22:36 Ishikawa, Japan
2022-10-30 Japan Ishikawa     173926 295 0   36.769464 136.771027 2022-10-31 04:21:36 Ishikawa, Japan
2022-10-29 Japan Ishikawa     173492 295 0   36.769464 136.771027 2022-10-30 04:22:14 Ishikawa, Japan
2022-10-28 Japan Ishikawa     172937 295 0   36.769464 136.771027 2022-10-29 04:21:13 Ishikawa, Japan
2022-10-27 Japan Ishikawa     172449 295 0   36.769464 136.771027 2022-10-28 04:22:31 Ishikawa, Japan
2022-10-26 Japan Ishikawa     171907 295 0   36.769464 136.771027 2022-10-27 04:22:01 Ishikawa, Japan
2022-10-25 Japan Ishikawa     171304 295 0   36.769464 136.771027 2022-10-26 04:22:19 Ishikawa, Japan
2022-10-24 Japan Ishikawa     170638 295 0   36.769464 136.771027 2022-10-25 04:21:53 Ishikawa, Japan
2022-10-23 Japan Ishikawa     170493 295 0   36.769464 136.771027 2022-10-24 04:22:29 Ishikawa, Japan
2022-10-22 Japan Ishikawa     170100 295 0   36.769464 136.771027 2022-10-23 04:22:46 Ishikawa, Japan
2022-10-21 Japan Ishikawa     169667 295 0   36.769464 136.771027 2022-10-22 04:22:53 Ishikawa, Japan
2022-10-20 Japan Ishikawa     169348 292 0   36.769464 136.771027 2022-10-21 04:22:23 Ishikawa, Japan
2022-10-19 Japan Ishikawa     168986 291 0   36.769464 136.771027 2022-10-20 04:22:59 Ishikawa, Japan
2022-10-18 Japan Ishikawa     168517 291 0   36.769464 136.771027 2022-10-19 04:22:26 Ishikawa, Japan
2022-10-17 Japan Ishikawa     168019 288 0   36.769464 136.771027 2022-10-18 04:22:42 Ishikawa, Japan
2022-10-16 Japan Ishikawa     167882 288 0   36.769464 136.771027 2022-10-17 04:20:31 Ishikawa, Japan
2022-10-15 Japan Ishikawa     167529 287 0   36.769464 136.771027 2022-10-16 04:22:39 Ishikawa, Japan
2022-10-14 Japan Ishikawa     167059 286 0   36.769464 136.771027 2022-10-15 04:22:00 Ishikawa, Japan
2022-10-13 Japan Ishikawa     166590 286 0   36.769464 136.771027 2022-10-14 04:22:28 Ishikawa, Japan
2022-10-12 Japan Ishikawa     165996 285 0   36.769464 136.771027 2022-10-13 04:22:39 Ishikawa, Japan
2022-10-11 Japan Ishikawa     165325 285 0   36.769464 136.771027 2022-10-12 04:22:51 Ishikawa, Japan
2022-10-10 Japan Ishikawa     165149 285 0   36.769464 136.771027 2022-10-11 04:23:05 Ishikawa, Japan
2022-10-09 Japan Ishikawa     164990 285 0   36.769464 136.771027 2022-10-10 04:22:32 Ishikawa, Japan
2022-10-08 Japan Ishikawa     164678 285 0   36.769464 136.771027 2022-10-09 04:21:16 Ishikawa, Japan
2022-10-07 Japan Ishikawa     164340 285 0   36.769464 136.771027 2022-10-08 04:22:56 Ishikawa, Japan
2022-10-06 Japan Ishikawa     163990 285 0   36.769464 136.771027 2022-10-07 04:23:08 Ishikawa, Japan
2022-10-05 Japan Ishikawa     163595 285 0   36.769464 136.771027 2022-10-06 04:21:22 Ishikawa, Japan
2022-10-04 Japan Ishikawa     163130 285 0   36.769464 136.771027 2022-10-05 04:23:06 Ishikawa, Japan
2022-10-03 Japan Ishikawa     162623 284 0   36.769464 136.771027 2022-10-04 04:22:55 Ishikawa, Japan
2022-10-02 Japan Ishikawa     162457 284 0   36.769464 136.771027 2022-10-03 04:23:11 Ishikawa, Japan
2022-10-01 Japan Ishikawa     162196 284 0   36.769464 136.771027 2022-10-02 04:21:23 Ishikawa, Japan
2022-09-30 Japan Ishikawa     161807 282 0   36.769464 136.771027 2022-10-01 04:23:01 Ishikawa, Japan
2022-09-29 Japan Ishikawa     161442 282 0   36.769464 136.771027 2022-09-30 04:23:09 Ishikawa, Japan
2022-09-28 Japan Ishikawa     160989 282 0   36.769464 136.771027 2022-09-29 04:22:34 Ishikawa, Japan
2022-09-27 Japan Ishikawa     160473 281 0   36.769464 136.771027 2022-09-28 04:23:01 Ishikawa, Japan
2022-09-26 Japan Ishikawa     159956 280 0   36.769464 136.771027 2022-09-27 04:23:01 Ishikawa, Japan
2022-09-25 Japan Ishikawa     159270 280 0   36.769464 136.771027 2022-09-26 04:20:52 Ishikawa, Japan
2022-09-24 Japan Ishikawa     159026 280 0   36.769464 136.771027 2022-09-25 04:23:31 Ishikawa, Japan
2022-09-23 Japan Ishikawa     158432 280 0   36.769464 136.771027 2022-09-24 04:21:40 Ishikawa, Japan
2022-09-22 Japan Ishikawa     157828 280 0   36.769464 136.771027 2022-09-23 04:23:13 Ishikawa, Japan
2022-09-21 Japan Ishikawa     156931 277 0   36.769464 136.771027 2022-09-22 04:22:56 Ishikawa, Japan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;