johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

946 rows where country_or_region = "Japan" and province_or_state = "Aomori" 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

  • Aomori · 946 ✖

country_or_region 1

  • Japan · 946 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752890 2752890 2022-12-29 Japan Aomori     249739 526 0   40.781541 140.828896 2022-12-30 04:21:04 Aomori, Japan
1073896 1073896 2022-12-28 Japan Aomori     248443 521 0   40.781541 140.828896 2022-12-29 04:21:01 Aomori, Japan
327893 327893 2022-12-27 Japan Aomori     246897 512 0   40.781541 140.828896 2022-12-28 04:21:04 Aomori, Japan
217966 217966 2022-12-26 Japan Aomori     244940 510 0   40.781541 140.828896 2022-12-27 04:21:07 Aomori, Japan
3222423 3222423 2022-12-25 Japan Aomori     244348 508 0   40.781541 140.828896 2022-12-26 04:21:06 Aomori, Japan
1018337 1018337 2022-12-24 Japan Aomori     243287 506 0   40.781541 140.828896 2022-12-25 04:21:04 Aomori, Japan
690360 690360 2022-12-23 Japan Aomori     241683 500 0   40.781541 140.828896 2022-12-24 04:21:02 Aomori, Japan
2179570 2179570 2022-12-22 Japan Aomori     240056 494 0   40.781541 140.828896 2022-12-23 04:21:04 Aomori, Japan
451374 451374 2022-12-21 Japan Aomori     238386 488 0   40.781541 140.828896 2022-12-22 04:20:56 Aomori, Japan
2951373 2951373 2022-12-20 Japan Aomori     236548 484 0   40.781541 140.828896 2022-12-21 04:21:03 Aomori, Japan
3173775 3173775 2022-12-19 Japan Aomori     234384 479 0   40.781541 140.828896 2022-12-20 04:21:04 Aomori, Japan
1628292 1628292 2022-12-18 Japan Aomori     233709 477 0   40.781541 140.828896 2022-12-19 04:21:03 Aomori, Japan
503671 503671 2022-12-17 Japan Aomori     232672 473 0   40.781541 140.828896 2022-12-18 04:21:03 Aomori, Japan
3324243 3324243 2022-12-16 Japan Aomori     231065 470 0   40.781541 140.828896 2022-12-17 04:21:04 Aomori, Japan
542755 542755 2022-12-15 Japan Aomori     229445 464 0   40.781541 140.828896 2022-12-16 04:21:01 Aomori, Japan
348283 348283 2022-12-14 Japan Aomori     227632 455 0   40.781541 140.828896 2022-12-15 04:20:58 Aomori, Japan
307871 307871 2022-12-13 Japan Aomori     225598 452 0   40.781541 140.828896 2022-12-14 04:21:04 Aomori, Japan
1148932 1148932 2022-12-12 Japan Aomori     222715 446 0   40.781541 140.828896 2022-12-13 04:21:01 Aomori, Japan
868786 868786 2022-12-11 Japan Aomori     221963 441 0   40.781541 140.828896 2022-12-12 04:21:01 Aomori, Japan
257316 257316 2022-12-10 Japan Aomori     220865 438 0   40.781541 140.828896 2022-12-11 04:20:50 Aomori, Japan
3936030 3936030 2022-12-09 Japan Aomori     219062 434 0   40.781541 140.828896 2022-12-10 04:21:02 Aomori, Japan
3377362 3377362 2022-12-08 Japan Aomori     218065 427 0   40.781541 140.828896 2022-12-09 04:21:05 Aomori, Japan
1984633 1984633 2022-12-07 Japan Aomori     216456 423 0   40.781541 140.828896 2022-12-08 04:21:07 Aomori, Japan
3714156 3714156 2022-12-06 Japan Aomori     214780 417 0   40.781541 140.828896 2022-12-07 04:20:58 Aomori, Japan
2414861 2414861 2022-12-05 Japan Aomori     212885 412 0   40.781541 140.828896 2022-12-06 04:21:03 Aomori, Japan
718469 718469 2022-12-04 Japan Aomori     212359 408 0   40.781541 140.828896 2022-12-05 04:20:58 Aomori, Japan
2816758 2816758 2022-12-03 Japan Aomori     211483 403 0   40.781541 140.828896 2022-12-04 04:20:56 Aomori, Japan
833614 833614 2022-12-02 Japan Aomori     210163 401 0   40.781541 140.828896 2022-12-03 04:21:02 Aomori, Japan
2136144 2136144 2022-12-01 Japan Aomori     208778 398 0   40.781541 140.828896 2022-12-02 04:21:07 Aomori, Japan
1964560 1964560 2022-11-30 Japan Aomori     207410 394 0   40.781541 140.828896 2022-12-01 04:21:03 Aomori, Japan
2556574 2556574 2022-11-29 Japan Aomori     205672 387 0   40.781541 140.828896 2022-11-30 04:21:07 Aomori, Japan
1239648 1239648 2022-11-28 Japan Aomori     195503 387 0   40.781541 140.828896 2022-11-29 04:21:05 Aomori, Japan
3551636 3551636 2022-11-27 Japan Aomori     194892 386 0   40.781541 140.828896 2022-11-28 04:21:02 Aomori, Japan
2100116 2100116 2022-11-26 Japan Aomori     193907 382 0   40.781541 140.828896 2022-11-27 04:21:05 Aomori, Japan
487607 487607 2022-11-25 Japan Aomori     192356 378 0   40.781541 140.828896 2022-11-26 04:21:11 Aomori, Japan
3523436 3523436 2022-11-24 Japan Aomori     190468 375 0   40.781541 140.828896 2022-11-25 04:21:06 Aomori, Japan
3312219 3312219 2022-11-23 Japan Aomori     189795 372 0   40.781541 140.828896 2022-11-24 04:21:09 Aomori, Japan
1620260 1620260 2022-11-22 Japan Aomori     188189 366 0   40.781541 140.828896 2022-11-23 04:21:06 Aomori, Japan
3460148 3460148 2022-11-21 Japan Aomori     186180 365 0   40.781541 140.828896 2022-11-22 04:20:47 Aomori, Japan
1640333 1640333 2022-11-20 Japan Aomori     185657 362 0   40.781541 140.828896 2022-11-21 04:21:05 Aomori, Japan
2063890 2063890 2022-11-19 Japan Aomori     184783 361 0   40.781541 140.828896 2022-11-20 04:21:08 Aomori, Japan
1755284 1755284 2022-11-18 Japan Aomori     183575 357 0   40.781541 140.828896 2022-11-19 04:21:14 Aomori, Japan
3026277 3026277 2022-11-17 Japan Aomori     184830 351 0   40.781541 140.828896 2022-11-18 04:21:15 Aomori, Japan
2485988 2485988 2022-11-16 Japan Aomori     181310 351 0   40.781541 140.828896 2022-11-17 04:21:11 Aomori, Japan
291999 291999 2022-11-15 Japan Aomori     179879 346 0   40.781541 140.828896 2022-11-16 04:21:09 Aomori, Japan
3597029 3597029 2022-11-14 Japan Aomori     184830 351 0   40.781541 140.828896 2022-11-15 04:21:16 Aomori, Japan
311887 311887 2022-11-13 Japan Aomori     184453 349 0   40.781541 140.828896 2022-11-14 04:21:09 Aomori, Japan
63048 63048 2022-11-12 Japan Aomori     183718 348 0   40.781541 140.828896 2022-11-13 04:21:14 Aomori, Japan
2927210 2927210 2022-11-11 Japan Aomori     182752 347 0   40.781541 140.828896 2022-11-12 04:20:41 Aomori, Japan
2506046 2506046 2022-11-10 Japan Aomori     181908 346 0   40.781541 140.828896 2022-11-11 04:21:22 Aomori, Japan
2430921 2430921 2022-11-09 Japan Aomori     181004 345 0   40.781541 140.828896 2022-11-10 04:21:16 Aomori, Japan
479577 479577 2022-11-08 Japan Aomori     179989 343 0   40.781541 140.828896 2022-11-09 04:21:22 Aomori, Japan
2438727 2438727 2022-11-07 Japan Aomori     178913 342 0   40.781541 140.828896 2022-11-08 04:21:21 Aomori, Japan
1049825 1049825 2022-11-06 Japan Aomori     178577 341 0   40.781541 140.828896 2022-11-07 04:21:26 Aomori, Japan
617849 617849 2022-11-05 Japan Aomori     178014 340 0   40.781541 140.828896 2022-11-06 04:21:24 Aomori, Japan
1022353 1022353 2022-11-04 Japan Aomori     176977 338 0   40.781541 140.828896 2022-11-05 04:21:52 Aomori, Japan
431344 431344 2022-11-03 Japan Aomori     176672 337 0   40.781541 140.828896 2022-11-04 04:22:11 Aomori, Japan
849586 849586 2022-11-02 Japan Aomori     175904 336 0   40.781541 140.828896 2022-11-03 04:22:05 Aomori, Japan
710437 710437 2022-11-01 Japan Aomori     175096 335 0   40.781541 140.828896 2022-11-02 04:22:09 Aomori, Japan
3284886 3284886 2022-10-31 Japan Aomori     174216 334 0   40.781541 140.828896 2022-11-01 04:22:36 Aomori, Japan
319919 319919 2022-10-30 Japan Aomori     173929 334 0   40.781541 140.828896 2022-10-31 04:21:36 Aomori, Japan
912195 912195 2022-10-29 Japan Aomori     173470 334 0   40.781541 140.828896 2022-10-30 04:22:14 Aomori, Japan
1366464 1366464 2022-10-28 Japan Aomori     172849 331 0   40.781541 140.828896 2022-10-29 04:21:13 Aomori, Japan
3038319 3038319 2022-10-27 Japan Aomori     172341 330 0   40.781541 140.828896 2022-10-28 04:22:31 Aomori, Japan
538739 538739 2022-10-26 Japan Aomori     171810 326 0   40.781541 140.828896 2022-10-27 04:22:01 Aomori, Japan
1830140 1830140 2022-10-25 Japan Aomori     171227 323 0   40.781541 140.828896 2022-10-26 04:22:19 Aomori, Japan
794401 794401 2022-10-24 Japan Aomori     170615 321 0   40.781541 140.828896 2022-10-25 04:21:53 Aomori, Japan
3276856 3276856 2022-10-23 Japan Aomori     170441 321 0   40.781541 140.828896 2022-10-24 04:22:29 Aomori, Japan
2267894 2267894 2022-10-22 Japan Aomori     170162 320 0   40.781541 140.828896 2022-10-23 04:22:46 Aomori, Japan
1592194 1592194 2022-10-21 Japan Aomori     169752 318 0   40.781541 140.828896 2022-10-22 04:22:53 Aomori, Japan
2271910 2271910 2022-10-20 Japan Aomori     169389 317 0   40.781541 140.828896 2022-10-21 04:22:23 Aomori, Japan
198245 198245 2022-10-19 Japan Aomori     168986 317 0   40.781541 140.828896 2022-10-20 04:22:59 Aomori, Japan
2756906 2756906 2022-10-18 Japan Aomori     168606 316 0   40.781541 140.828896 2022-10-19 04:22:26 Aomori, Japan
2024740 2024740 2022-10-17 Japan Aomori     168080 316 0   40.781541 140.828896 2022-10-18 04:22:42 Aomori, Japan
2159518 2159518 2022-10-16 Japan Aomori     167957 316 0   40.781541 140.828896 2022-10-17 04:20:31 Aomori, Japan
515715 515715 2022-10-15 Japan Aomori     167695 316 0   40.781541 140.828896 2022-10-16 04:22:39 Aomori, Japan
2032772 2032772 2022-10-14 Japan Aomori     167348 314 0   40.781541 140.828896 2022-10-15 04:22:00 Aomori, Japan
3753460 3753460 2022-10-13 Japan Aomori     166996 314 0   40.781541 140.828896 2022-10-14 04:22:28 Aomori, Japan
3214285 3214285 2022-10-12 Japan Aomori     166534 314 0   40.781541 140.828896 2022-10-13 04:22:39 Aomori, Japan
3250134 3250134 2022-10-11 Japan Aomori     165980 314 0   40.781541 140.828896 2022-10-12 04:22:51 Aomori, Japan
2967393 2967393 2022-10-10 Japan Aomori     165819 314 0   40.781541 140.828896 2022-10-11 04:23:05 Aomori, Japan
3097429 3097429 2022-10-09 Japan Aomori     165706 314 0   40.781541 140.828896 2022-10-10 04:22:32 Aomori, Japan
4002654 4002654 2022-10-08 Japan Aomori     165529 313 0   40.781541 140.828896 2022-10-09 04:21:16 Aomori, Japan
396251 396251 2022-10-07 Japan Aomori     165271 311 0   40.781541 140.828896 2022-10-08 04:22:56 Aomori, Japan
2529368 2529368 2022-10-06 Japan Aomori     164997 310 0   40.781541 140.828896 2022-10-07 04:23:08 Aomori, Japan
1810762 1810762 2022-10-05 Japan Aomori     164737 309 0   40.781541 140.828896 2022-10-06 04:21:22 Aomori, Japan
130736 130736 2022-10-04 Japan Aomori     164422 308 0   40.781541 140.828896 2022-10-05 04:23:06 Aomori, Japan
2685683 2685683 2022-10-03 Japan Aomori     163975 307 0   40.781541 140.828896 2022-10-04 04:22:55 Aomori, Japan
2259750 2259750 2022-10-02 Japan Aomori     163866 305 0   40.781541 140.828896 2022-10-03 04:23:11 Aomori, Japan
2995276 2995276 2022-10-01 Japan Aomori     163633 304 0   40.781541 140.828896 2022-10-02 04:21:23 Aomori, Japan
853602 853602 2022-09-30 Japan Aomori     163349 304 0   40.781541 140.828896 2022-10-01 04:23:01 Aomori, Japan
2375528 2375528 2022-09-29 Japan Aomori     163107 299 0   40.781541 140.828896 2022-09-30 04:23:09 Aomori, Japan
1560079 1560079 2022-09-28 Japan Aomori     162804 299 0   40.781541 140.828896 2022-09-29 04:22:34 Aomori, Japan
3994622 3994622 2022-09-27 Japan Aomori     162460 293 0   40.781541 140.828896 2022-09-28 04:23:01 Aomori, Japan
2768950 2768950 2022-09-26 Japan Aomori     161912 293 0   40.781541 140.828896 2022-09-27 04:23:01 Aomori, Japan
1976603 1976603 2022-09-25 Japan Aomori     161572 293 0   40.781541 140.828896 2022-09-26 04:20:52 Aomori, Japan
2649770 2649770 2022-09-24 Japan Aomori     161336 293 0   40.781541 140.828896 2022-09-25 04:23:31 Aomori, Japan
384210 384210 2022-09-23 Japan Aomori     160962 291 0   40.781541 140.828896 2022-09-24 04:21:40 Aomori, Japan
1624276 1624276 2022-09-22 Japan Aomori     160542 291 0   40.781541 140.828896 2022-09-23 04:23:13 Aomori, Japan
1370480 1370480 2022-09-21 Japan Aomori     159962 288 0   40.781541 140.828896 2022-09-22 04:22:56 Aomori, Japan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);