ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,029 rows where state = "Hawaii" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Hawaii · 929 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
51596 | 51596 | 2022-09-20 | Hawaii | 15 | 333547 | 1662 |
51540 | 51540 | 2022-09-19 | Hawaii | 15 | 333547 | 1662 |
51484 | 51484 | 2022-09-18 | Hawaii | 15 | 333547 | 1662 |
51428 | 51428 | 2022-09-17 | Hawaii | 15 | 333547 | 1662 |
51372 | 51372 | 2022-09-16 | Hawaii | 15 | 333547 | 1662 |
51316 | 51316 | 2022-09-15 | Hawaii | 15 | 333547 | 1662 |
51260 | 51260 | 2022-09-14 | Hawaii | 15 | 333547 | 1662 |
51204 | 51204 | 2022-09-13 | Hawaii | 15 | 332278 | 1652 |
51148 | 51148 | 2022-09-12 | Hawaii | 15 | 332278 | 1652 |
51092 | 51092 | 2022-09-11 | Hawaii | 15 | 332278 | 1652 |
51036 | 51036 | 2022-09-10 | Hawaii | 15 | 332278 | 1652 |
50980 | 50980 | 2022-09-09 | Hawaii | 15 | 332278 | 1652 |
50924 | 50924 | 2022-09-08 | Hawaii | 15 | 332278 | 1652 |
50868 | 50868 | 2022-09-07 | Hawaii | 15 | 332278 | 1652 |
50812 | 50812 | 2022-09-06 | Hawaii | 15 | 331095 | 1641 |
50756 | 50756 | 2022-09-05 | Hawaii | 15 | 331095 | 1641 |
50700 | 50700 | 2022-09-04 | Hawaii | 15 | 331095 | 1641 |
50644 | 50644 | 2022-09-03 | Hawaii | 15 | 331095 | 1641 |
50588 | 50588 | 2022-09-02 | Hawaii | 15 | 331095 | 1641 |
50532 | 50532 | 2022-09-01 | Hawaii | 15 | 331095 | 1641 |
50476 | 50476 | 2022-08-31 | Hawaii | 15 | 331095 | 1641 |
50420 | 50420 | 2022-08-30 | Hawaii | 15 | 329351 | 1629 |
50364 | 50364 | 2022-08-29 | Hawaii | 15 | 329351 | 1629 |
50308 | 50308 | 2022-08-28 | Hawaii | 15 | 329351 | 1629 |
50252 | 50252 | 2022-08-27 | Hawaii | 15 | 329351 | 1629 |
50196 | 50196 | 2022-08-26 | Hawaii | 15 | 329351 | 1629 |
50140 | 50140 | 2022-08-25 | Hawaii | 15 | 329351 | 1629 |
50084 | 50084 | 2022-08-24 | Hawaii | 15 | 329351 | 1629 |
50028 | 50028 | 2022-08-23 | Hawaii | 15 | 327175 | 1616 |
49972 | 49972 | 2022-08-22 | Hawaii | 15 | 327175 | 1616 |
49916 | 49916 | 2022-08-21 | Hawaii | 15 | 327175 | 1616 |
49860 | 49860 | 2022-08-20 | Hawaii | 15 | 327175 | 1616 |
49804 | 49804 | 2022-08-19 | Hawaii | 15 | 327175 | 1616 |
49748 | 49748 | 2022-08-18 | Hawaii | 15 | 327175 | 1616 |
49692 | 49692 | 2022-08-17 | Hawaii | 15 | 327175 | 1616 |
49636 | 49636 | 2022-08-16 | Hawaii | 15 | 324519 | 1603 |
49580 | 49580 | 2022-08-15 | Hawaii | 15 | 324519 | 1603 |
49524 | 49524 | 2022-08-14 | Hawaii | 15 | 324519 | 1603 |
49468 | 49468 | 2022-08-13 | Hawaii | 15 | 324519 | 1603 |
49412 | 49412 | 2022-08-12 | Hawaii | 15 | 324519 | 1603 |
49356 | 49356 | 2022-08-11 | Hawaii | 15 | 324519 | 1603 |
49300 | 49300 | 2022-08-10 | Hawaii | 15 | 324519 | 1603 |
49244 | 49244 | 2022-08-09 | Hawaii | 15 | 321378 | 1589 |
49188 | 49188 | 2022-08-08 | Hawaii | 15 | 321378 | 1589 |
49132 | 49132 | 2022-08-07 | Hawaii | 15 | 321378 | 1589 |
49076 | 49076 | 2022-08-06 | Hawaii | 15 | 321378 | 1589 |
49020 | 49020 | 2022-08-05 | Hawaii | 15 | 321378 | 1589 |
48964 | 48964 | 2022-08-04 | Hawaii | 15 | 321378 | 1589 |
48908 | 48908 | 2022-08-03 | Hawaii | 15 | 321378 | 1589 |
48852 | 48852 | 2022-08-02 | Hawaii | 15 | 317785 | 1568 |
48796 | 48796 | 2022-08-01 | Hawaii | 15 | 317785 | 1568 |
48740 | 48740 | 2022-07-31 | Hawaii | 15 | 317785 | 1568 |
48684 | 48684 | 2022-07-30 | Hawaii | 15 | 317785 | 1568 |
48628 | 48628 | 2022-07-29 | Hawaii | 15 | 317785 | 1568 |
48572 | 48572 | 2022-07-28 | Hawaii | 15 | 317785 | 1568 |
48516 | 48516 | 2022-07-27 | Hawaii | 15 | 317785 | 1568 |
48460 | 48460 | 2022-07-26 | Hawaii | 15 | 313805 | 1545 |
48404 | 48404 | 2022-07-25 | Hawaii | 15 | 313805 | 1545 |
48348 | 48348 | 2022-07-24 | Hawaii | 15 | 313805 | 1545 |
48292 | 48292 | 2022-07-23 | Hawaii | 15 | 313805 | 1545 |
48236 | 48236 | 2022-07-22 | Hawaii | 15 | 313805 | 1545 |
48180 | 48180 | 2022-07-21 | Hawaii | 15 | 313805 | 1545 |
48124 | 48124 | 2022-07-20 | Hawaii | 15 | 313805 | 1545 |
48068 | 48068 | 2022-07-19 | Hawaii | 15 | 309561 | 1532 |
48012 | 48012 | 2022-07-18 | Hawaii | 15 | 309561 | 1532 |
47956 | 47956 | 2022-07-17 | Hawaii | 15 | 309561 | 1532 |
47900 | 47900 | 2022-07-16 | Hawaii | 15 | 309561 | 1532 |
47844 | 47844 | 2022-07-15 | Hawaii | 15 | 309561 | 1532 |
47788 | 47788 | 2022-07-14 | Hawaii | 15 | 309561 | 1532 |
47732 | 47732 | 2022-07-13 | Hawaii | 15 | 309561 | 1532 |
47676 | 47676 | 2022-07-12 | Hawaii | 15 | 305348 | 1521 |
47620 | 47620 | 2022-07-11 | Hawaii | 15 | 305348 | 1521 |
47564 | 47564 | 2022-07-10 | Hawaii | 15 | 305348 | 1521 |
47508 | 47508 | 2022-07-09 | Hawaii | 15 | 305348 | 1521 |
47452 | 47452 | 2022-07-08 | Hawaii | 15 | 305348 | 1521 |
47396 | 47396 | 2022-07-07 | Hawaii | 15 | 305348 | 1521 |
47340 | 47340 | 2022-07-06 | Hawaii | 15 | 305348 | 1521 |
47284 | 47284 | 2022-07-05 | Hawaii | 15 | 301246 | 1501 |
47228 | 47228 | 2022-07-04 | Hawaii | 15 | 301246 | 1501 |
47172 | 47172 | 2022-07-03 | Hawaii | 15 | 301246 | 1501 |
47116 | 47116 | 2022-07-02 | Hawaii | 15 | 301246 | 1501 |
47060 | 47060 | 2022-07-01 | Hawaii | 15 | 301246 | 1501 |
47004 | 47004 | 2022-06-30 | Hawaii | 15 | 301246 | 1501 |
46948 | 46948 | 2022-06-29 | Hawaii | 15 | 301246 | 1501 |
46892 | 46892 | 2022-06-28 | Hawaii | 15 | 296007 | 1486 |
46836 | 46836 | 2022-06-27 | Hawaii | 15 | 296007 | 1486 |
46780 | 46780 | 2022-06-26 | Hawaii | 15 | 296007 | 1486 |
46724 | 46724 | 2022-06-25 | Hawaii | 15 | 296007 | 1486 |
46668 | 46668 | 2022-06-24 | Hawaii | 15 | 296007 | 1486 |
46612 | 46612 | 2022-06-23 | Hawaii | 15 | 296007 | 1486 |
46556 | 46556 | 2022-06-22 | Hawaii | 15 | 296007 | 1486 |
46500 | 46500 | 2022-06-21 | Hawaii | 15 | 290652 | 1471 |
46444 | 46444 | 2022-06-20 | Hawaii | 15 | 290652 | 1471 |
46388 | 46388 | 2022-06-19 | Hawaii | 15 | 290652 | 1471 |
46332 | 46332 | 2022-06-18 | Hawaii | 15 | 290652 | 1471 |
46276 | 46276 | 2022-06-17 | Hawaii | 15 | 290652 | 1471 |
46220 | 46220 | 2022-06-16 | Hawaii | 15 | 290652 | 1471 |
46164 | 46164 | 2022-06-15 | Hawaii | 15 | 290652 | 1471 |
46108 | 46108 | 2022-06-14 | Hawaii | 15 | 283574 | 1462 |
46052 | 46052 | 2022-06-13 | Hawaii | 15 | 283574 | 1462 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );