ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,982 rows where state = "Hawaii" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Hawaii · 902 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635436 | 635436 | 2020-10-16 | Hawaii | Hawaii | 15001 | 1037 | 18 |
635437 | 635437 | 2020-10-16 | Honolulu | Hawaii | 15003 | 12392 | 148 |
635438 | 635438 | 2020-10-16 | Kauai | Hawaii | 15007 | 59 | 0 |
635439 | 635439 | 2020-10-16 | Maui | Hawaii | 15009 | 519 | 18 |
632190 | 632190 | 2020-10-15 | Hawaii | Hawaii | 15001 | 1016 | 18 |
632191 | 632191 | 2020-10-15 | Honolulu | Hawaii | 15003 | 12321 | 147 |
632192 | 632192 | 2020-10-15 | Kauai | Hawaii | 15007 | 59 | 0 |
632193 | 632193 | 2020-10-15 | Maui | Hawaii | 15009 | 526 | 18 |
628946 | 628946 | 2020-10-14 | Hawaii | Hawaii | 15001 | 1003 | 18 |
628947 | 628947 | 2020-10-14 | Honolulu | Hawaii | 15003 | 12248 | 146 |
628948 | 628948 | 2020-10-14 | Kauai | Hawaii | 15007 | 59 | 0 |
628949 | 628949 | 2020-10-14 | Maui | Hawaii | 15009 | 524 | 18 |
625703 | 625703 | 2020-10-13 | Hawaii | Hawaii | 15001 | 985 | 15 |
625704 | 625704 | 2020-10-13 | Honolulu | Hawaii | 15003 | 12169 | 144 |
625705 | 625705 | 2020-10-13 | Kauai | Hawaii | 15007 | 59 | 0 |
625706 | 625706 | 2020-10-13 | Maui | Hawaii | 15009 | 523 | 13 |
622460 | 622460 | 2020-10-12 | Hawaii | Hawaii | 15001 | 964 | 15 |
622461 | 622461 | 2020-10-12 | Honolulu | Hawaii | 15003 | 12140 | 141 |
622462 | 622462 | 2020-10-12 | Kauai | Hawaii | 15007 | 59 | 0 |
622463 | 622463 | 2020-10-12 | Maui | Hawaii | 15009 | 512 | 12 |
619217 | 619217 | 2020-10-11 | Hawaii | Hawaii | 15001 | 959 | 15 |
619218 | 619218 | 2020-10-11 | Honolulu | Hawaii | 15003 | 12103 | 141 |
619219 | 619219 | 2020-10-11 | Kauai | Hawaii | 15007 | 59 | 0 |
619220 | 619220 | 2020-10-11 | Maui | Hawaii | 15009 | 512 | 12 |
615975 | 615975 | 2020-10-10 | Hawaii | Hawaii | 15001 | 935 | 15 |
615976 | 615976 | 2020-10-10 | Honolulu | Hawaii | 15003 | 12026 | 140 |
615977 | 615977 | 2020-10-10 | Kauai | Hawaii | 15007 | 59 | 0 |
615978 | 615978 | 2020-10-10 | Maui | Hawaii | 15009 | 512 | 12 |
612734 | 612734 | 2020-10-09 | Hawaii | Hawaii | 15001 | 922 | 15 |
612735 | 612735 | 2020-10-09 | Honolulu | Hawaii | 15003 | 11968 | 138 |
612736 | 612736 | 2020-10-09 | Kauai | Hawaii | 15007 | 59 | 0 |
612737 | 612737 | 2020-10-09 | Maui | Hawaii | 15009 | 512 | 12 |
609492 | 609492 | 2020-10-08 | Hawaii | Hawaii | 15001 | 877 | 15 |
609493 | 609493 | 2020-10-08 | Honolulu | Hawaii | 15003 | 11858 | 136 |
609494 | 609494 | 2020-10-08 | Kauai | Hawaii | 15007 | 59 | 0 |
609495 | 609495 | 2020-10-08 | Maui | Hawaii | 15009 | 503 | 12 |
606249 | 606249 | 2020-10-07 | Hawaii | Hawaii | 15001 | 863 | 15 |
606250 | 606250 | 2020-10-07 | Honolulu | Hawaii | 15003 | 11772 | 135 |
606251 | 606251 | 2020-10-07 | Kauai | Hawaii | 15007 | 59 | 0 |
606252 | 606252 | 2020-10-07 | Maui | Hawaii | 15009 | 502 | 12 |
603007 | 603007 | 2020-10-06 | Hawaii | Hawaii | 15001 | 845 | 15 |
603008 | 603008 | 2020-10-06 | Honolulu | Hawaii | 15003 | 11683 | 132 |
603009 | 603009 | 2020-10-06 | Kauai | Hawaii | 15007 | 59 | 0 |
603010 | 603010 | 2020-10-06 | Maui | Hawaii | 15009 | 503 | 12 |
599764 | 599764 | 2020-10-05 | Hawaii | Hawaii | 15001 | 831 | 15 |
599765 | 599765 | 2020-10-05 | Honolulu | Hawaii | 15003 | 11616 | 129 |
599766 | 599766 | 2020-10-05 | Kauai | Hawaii | 15007 | 59 | 0 |
599767 | 599767 | 2020-10-05 | Maui | Hawaii | 15009 | 501 | 12 |
596521 | 596521 | 2020-10-04 | Hawaii | Hawaii | 15001 | 821 | 15 |
596522 | 596522 | 2020-10-04 | Honolulu | Hawaii | 15003 | 11575 | 128 |
596523 | 596523 | 2020-10-04 | Kauai | Hawaii | 15007 | 59 | 0 |
596524 | 596524 | 2020-10-04 | Maui | Hawaii | 15009 | 502 | 12 |
593279 | 593279 | 2020-10-03 | Hawaii | Hawaii | 15001 | 806 | 15 |
593280 | 593280 | 2020-10-03 | Honolulu | Hawaii | 15003 | 11522 | 128 |
593281 | 593281 | 2020-10-03 | Kauai | Hawaii | 15007 | 59 | 0 |
593282 | 593282 | 2020-10-03 | Maui | Hawaii | 15009 | 500 | 9 |
590039 | 590039 | 2020-10-02 | Hawaii | Hawaii | 15001 | 763 | 15 |
590040 | 590040 | 2020-10-02 | Honolulu | Hawaii | 15003 | 11435 | 117 |
590041 | 590041 | 2020-10-02 | Kauai | Hawaii | 15007 | 59 | 0 |
590042 | 590042 | 2020-10-02 | Maui | Hawaii | 15009 | 497 | 9 |
586798 | 586798 | 2020-10-01 | Hawaii | Hawaii | 15001 | 745 | 15 |
586799 | 586799 | 2020-10-01 | Honolulu | Hawaii | 15003 | 11363 | 114 |
586800 | 586800 | 2020-10-01 | Kauai | Hawaii | 15007 | 59 | 0 |
586801 | 586801 | 2020-10-01 | Maui | Hawaii | 15009 | 493 | 9 |
583558 | 583558 | 2020-09-30 | Hawaii | Hawaii | 15001 | 739 | 15 |
583559 | 583559 | 2020-09-30 | Honolulu | Hawaii | 15003 | 11264 | 111 |
583560 | 583560 | 2020-09-30 | Kauai | Hawaii | 15007 | 59 | 0 |
583561 | 583561 | 2020-09-30 | Maui | Hawaii | 15009 | 493 | 9 |
580319 | 580319 | 2020-09-29 | Hawaii | Hawaii | 15001 | 712 | 15 |
580320 | 580320 | 2020-09-29 | Honolulu | Hawaii | 15003 | 11173 | 109 |
580321 | 580321 | 2020-09-29 | Kauai | Hawaii | 15007 | 59 | 0 |
580322 | 580322 | 2020-09-29 | Maui | Hawaii | 15009 | 492 | 9 |
577078 | 577078 | 2020-09-28 | Hawaii | Hawaii | 15001 | 709 | 15 |
577079 | 577079 | 2020-09-28 | Honolulu | Hawaii | 15003 | 11093 | 107 |
577080 | 577080 | 2020-09-28 | Kauai | Hawaii | 15007 | 59 | 0 |
577081 | 577081 | 2020-09-28 | Maui | Hawaii | 15009 | 490 | 9 |
573835 | 573835 | 2020-09-27 | Hawaii | Hawaii | 15001 | 709 | 15 |
573836 | 573836 | 2020-09-27 | Honolulu | Hawaii | 15003 | 11006 | 107 |
573837 | 573837 | 2020-09-27 | Kauai | Hawaii | 15007 | 59 | 0 |
573838 | 573838 | 2020-09-27 | Maui | Hawaii | 15009 | 490 | 9 |
570593 | 570593 | 2020-09-26 | Hawaii | Hawaii | 15001 | 702 | 15 |
570594 | 570594 | 2020-09-26 | Honolulu | Hawaii | 15003 | 10915 | 106 |
570595 | 570595 | 2020-09-26 | Kauai | Hawaii | 15007 | 59 | 0 |
570596 | 570596 | 2020-09-26 | Maui | Hawaii | 15009 | 490 | 9 |
567351 | 567351 | 2020-09-25 | Hawaii | Hawaii | 15001 | 700 | 15 |
567352 | 567352 | 2020-09-25 | Honolulu | Hawaii | 15003 | 10791 | 102 |
567353 | 567353 | 2020-09-25 | Kauai | Hawaii | 15007 | 58 | 0 |
567354 | 567354 | 2020-09-25 | Maui | Hawaii | 15009 | 490 | 9 |
564111 | 564111 | 2020-09-24 | Hawaii | Hawaii | 15001 | 685 | 15 |
564112 | 564112 | 2020-09-24 | Honolulu | Hawaii | 15003 | 10685 | 99 |
564113 | 564113 | 2020-09-24 | Kauai | Hawaii | 15007 | 57 | 0 |
564114 | 564114 | 2020-09-24 | Maui | Hawaii | 15009 | 481 | 9 |
560871 | 560871 | 2020-09-23 | Hawaii | Hawaii | 15001 | 680 | 15 |
560872 | 560872 | 2020-09-23 | Honolulu | Hawaii | 15003 | 10604 | 97 |
560873 | 560873 | 2020-09-23 | Kauai | Hawaii | 15007 | 57 | 0 |
560874 | 560874 | 2020-09-23 | Maui | Hawaii | 15009 | 479 | 9 |
557635 | 557635 | 2020-09-22 | Hawaii | Hawaii | 15001 | 667 | 15 |
557636 | 557636 | 2020-09-22 | Honolulu | Hawaii | 15003 | 10451 | 95 |
557637 | 557637 | 2020-09-22 | Kauai | Hawaii | 15007 | 57 | 0 |
557638 | 557638 | 2020-09-22 | Maui | Hawaii | 15009 | 478 | 9 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);