johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where deaths = 30 and province_or_state = "Iwate" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2571694 | 2571694 | 2021-04-13 | Japan | Iwate | 763 | 30 | 633 | 100 | 39.593287 | 141.361777 | 2021-04-14 04:20:41 | Iwate, Japan | ||
36445 | 36445 | 2021-04-12 | Japan | Iwate | 761 | 30 | 612 | 119 | 39.593287 | 141.361777 | 2021-04-13 04:20:37 | Iwate, Japan | ||
3883604 | 3883604 | 2021-04-11 | Japan | Iwate | 752 | 30 | 599 | 123 | 39.593287 | 141.361777 | 2021-04-12 04:21:00 | Iwate, Japan | ||
2983272 | 2983272 | 2021-04-10 | Japan | Iwate | 745 | 30 | 579 | 136 | 39.593287 | 141.361777 | 2021-04-11 04:20:56 | Iwate, Japan | ||
605704 | 605704 | 2021-04-09 | Japan | Iwate | 737 | 30 | 579 | 128 | 39.593287 | 141.361777 | 2021-04-10 04:20:59 | Iwate, Japan | ||
2645768 | 2645768 | 2021-04-08 | Japan | Iwate | 732 | 30 | 564 | 138 | 39.593287 | 141.361777 | 2021-04-09 04:21:13 | Iwate, Japan | ||
2247410 | 2247410 | 2021-04-07 | Japan | Iwate | 722 | 30 | 564 | 128 | 39.593287 | 141.361777 | 2021-04-08 04:21:13 | Iwate, Japan | ||
3003320 | 3003320 | 2021-04-06 | Japan | Iwate | 713 | 30 | 562 | 121 | 39.593287 | 141.361777 | 2021-04-07 04:20:53 | Iwate, Japan | ||
3085315 | 3085315 | 2021-04-05 | Japan | Iwate | 705 | 30 | 561 | 114 | 39.593287 | 141.361777 | 2021-04-06 04:20:32 | Iwate, Japan | ||
388238 | 388238 | 2021-04-04 | Japan | Iwate | 704 | 30 | 560 | 114 | 39.593287 | 141.361777 | 2021-04-05 04:20:35 | Iwate, Japan | ||
3710154 | 3710154 | 2021-04-03 | Japan | Iwate | 687 | 30 | 556 | 101 | 39.593287 | 141.361777 | 2021-04-04 04:20:49 | Iwate, Japan | ||
241270 | 241270 | 2021-04-02 | Japan | Iwate | 673 | 30 | 554 | 89 | 39.593287 | 141.361777 | 2021-04-03 04:20:44 | Iwate, Japan | ||
1302067 | 1302067 | 2021-04-01 | Japan | Iwate | 646 | 30 | 553 | 63 | 39.593287 | 141.361777 | 2021-04-02 04:20:36 | Iwate, Japan | ||
637939 | 637939 | 2021-03-31 | Japan | Iwate | 621 | 30 | 550 | 41 | 39.593287 | 141.361777 | 2021-04-01 04:27:05 | Iwate, Japan | ||
3643568 | 3643568 | 2021-03-30 | Japan | Iwate | 614 | 30 | 549 | 35 | 39.593287 | 141.361777 | 2021-03-31 04:26:25 | Iwate, Japan | ||
1290021 | 1290021 | 2021-03-29 | Japan | Iwate | 609 | 30 | 543 | 36 | 39.593287 | 141.361777 | 2021-03-30 04:26:23 | Iwate, Japan | ||
1535943 | 1535943 | 2021-03-28 | Japan | Iwate | 608 | 30 | 533 | 45 | 39.593287 | 141.361777 | 2021-03-29 04:28:35 | Iwate, Japan | ||
1219583 | 1219583 | 2021-03-27 | Japan | Iwate | 604 | 30 | 533 | 41 | 39.593287 | 141.361777 | 2021-03-28 05:28:10 | Iwate, Japan | ||
1881001 | 1881001 | 2021-03-26 | Japan | Iwate | 601 | 30 | 533 | 38 | 39.593287 | 141.361777 | 2021-03-27 05:25:04 | Iwate, Japan | ||
1980631 | 1980631 | 2021-03-25 | Japan | Iwate | 596 | 30 | 532 | 34 | 39.593287 | 141.361777 | 2021-03-26 05:26:55 | Iwate, Japan | ||
2781009 | 2781009 | 2021-03-24 | Japan | Iwate | 591 | 30 | 532 | 29 | 39.593287 | 141.361777 | 2021-03-25 05:27:00 | Iwate, Japan | ||
1798654 | 1798654 | 2021-03-23 | Japan | Iwate | 589 | 30 | 532 | 27 | 39.593287 | 141.361777 | 2021-03-24 05:25:40 | Iwate, Japan | ||
1203822 | 1203822 | 2021-03-22 | Japan | Iwate | 588 | 30 | 530 | 28 | 39.593287 | 141.361777 | 2021-03-23 05:26:18 | Iwate, Japan | ||
3369344 | 3369344 | 2021-03-21 | Japan | Iwate | 587 | 30 | 528 | 29 | 39.593287 | 141.361777 | 2021-03-22 05:25:43 | Iwate, Japan | ||
1744554 | 1744554 | 2021-03-20 | Japan | Iwate | 585 | 30 | 528 | 27 | 39.593287 | 141.361777 | 2021-03-21 05:25:44 | Iwate, Japan | ||
3420934 | 3420934 | 2021-03-19 | Japan | Iwate | 583 | 30 | 527 | 26 | 39.593287 | 141.361777 | 2021-03-20 05:25:46 | Iwate, Japan | ||
3452872 | 3452872 | 2021-03-18 | Japan | Iwate | 575 | 30 | 525 | 20 | 39.593287 | 141.361777 | 2021-03-19 05:26:09 | Iwate, Japan | ||
3621096 | 3621096 | 2021-03-17 | Japan | Iwate | 571 | 30 | 525 | 16 | 39.593287 | 141.361777 | 2021-03-18 05:26:22 | Iwate, Japan | ||
702420 | 702420 | 2021-03-16 | Japan | Iwate | 565 | 30 | 525 | 10 | 39.593287 | 141.361777 | 2021-03-17 05:25:07 | Iwate, Japan | ||
2055898 | 2055898 | 2021-03-15 | Japan | Iwate | 565 | 30 | 525 | 10 | 39.593287 | 141.361777 | 2021-03-16 05:25:13 | Iwate, Japan | ||
1732510 | 1732510 | 2021-03-14 | Japan | Iwate | 564 | 30 | 525 | 9 | 39.593287 | 141.361777 | 2021-03-15 05:25:51 | Iwate, Japan | ||
1580167 | 1580167 | 2021-03-13 | Japan | Iwate | 561 | 30 | 525 | 6 | 39.593287 | 141.361777 | 2021-03-14 05:25:37 | Iwate, Japan | ||
1837946 | 1837946 | 2021-03-12 | Japan | Iwate | 558 | 30 | 524 | 4 | 39.593287 | 141.361777 | 2021-03-13 05:25:15 | Iwate, Japan | ||
352311 | 352311 | 2021-03-11 | Japan | Iwate | 557 | 30 | 524 | 3 | 39.593287 | 141.361777 | 2021-03-12 05:26:50 | Iwate, Japan | ||
3962535 | 3962535 | 2021-03-10 | Japan | Iwate | 555 | 30 | 524 | 1 | 39.593287 | 141.361777 | 2021-03-11 05:25:48 | Iwate, Japan | ||
3663623 | 3663623 | 2021-03-09 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-10 05:24:35 | Iwate, Japan | ||
2359482 | 2359482 | 2021-03-08 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-09 05:28:19 | Iwate, Japan | ||
54820 | 54820 | 2021-03-07 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-08 05:24:48 | Iwate, Japan | ||
3667637 | 3667637 | 2021-03-06 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-07 05:21:54 | Iwate, Japan | ||
1616258 | 1616258 | 2021-03-05 | Japan | Iwate | 555 | 30 | 522 | 3 | 39.593287 | 141.361777 | 2021-03-06 04:23:41 | Iwate, Japan | ||
2207669 | 2207669 | 2021-03-04 | Japan | Iwate | 554 | 30 | 517 | 7 | 39.593287 | 141.361777 | 2021-03-05 05:26:29 | Iwate, Japan | ||
1090090 | 1090090 | 2021-03-03 | Japan | Iwate | 554 | 30 | 517 | 7 | 39.593287 | 141.361777 | 2021-03-04 05:24:24 | Iwate, Japan | ||
3254162 | 3254162 | 2021-03-02 | Japan | Iwate | 554 | 30 | 516 | 8 | 39.593287 | 141.361777 | 2021-03-03 05:23:28 | Iwate, Japan | ||
998454 | 998454 | 2021-03-01 | Japan | Iwate | 554 | 30 | 510 | 14 | 39.593287 | 141.361777 | 2021-03-02 05:23:30 | Iwate, Japan | ||
2367512 | 2367512 | 2021-02-28 | Japan | Iwate | 554 | 30 | 510 | 14 | 39.593287 | 141.361777 | 2021-03-01 05:23:01 | Iwate, Japan | ||
3066014 | 3066014 | 2021-02-27 | Japan | Iwate | 554 | 30 | 506 | 18 | 39.593287 | 141.361777 | 2021-02-28 05:22:20 | Iwate, Japan | ||
2183598 | 2183598 | 2021-02-26 | Japan | Iwate | 553 | 30 | 497 | 26 | 39.593287 | 141.361777 | 2021-02-27 05:22:28 | Iwate, Japan | ||
1858020 | 1858020 | 2021-02-25 | Japan | Iwate | 553 | 30 | 497 | 26 | 39.593287 | 141.361777 | 2021-02-26 05:22:40 | Iwate, Japan | ||
280198 | 280198 | 2021-02-24 | Japan | Iwate | 553 | 30 | 493 | 30 | 39.593287 | 141.361777 | 2021-02-25 05:24:57 | Iwate, Japan | ||
1936466 | 1936466 | 2021-02-23 | Japan | Iwate | 553 | 30 | 493 | 30 | 39.593287 | 141.361777 | 2021-02-24 05:29:16 | Iwate, Japan | ||
530721 | 530721 | 2021-02-22 | Japan | Iwate | 553 | 30 | 492 | 31 | 39.593287 | 141.361777 | 2021-02-23 05:23:41 | Iwate, Japan | ||
182055 | 182055 | 2021-02-21 | Japan | Iwate | 553 | 30 | 492 | 31 | 39.593287 | 141.361777 | 2021-02-22 05:24:21 | Iwate, Japan | ||
742329 | 742329 | 2021-02-20 | Japan | Iwate | 553 | 30 | 489 | 34 | 39.593287 | 141.361777 | 2021-02-21 05:24:33 | Iwate, Japan | ||
471427 | 471427 | 2021-02-19 | Japan | Iwate | 549 | 30 | 486 | 33 | 39.593287 | 141.361777 | 2021-02-20 05:22:51 | Iwate, 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]);