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)
Suggested facets: date (date)
deaths 413 ✖
- 0 1,016
- 1 178
- 2 160
- 9 153
- 53 142
- 6 122
- 8 114
- 11 71
- 17 71
- 3 51
- 29 51
- 18 44
- 13 43
- 28 42
- 54 35
- 55 35
- 184 35
- 15 33
- 57 33
- 59 28
- 45 24
- 7 21
- 5 20
- 31 20
- 4 18
- 44 18
- 136 18
- 20 17
- 19 16
- 99 16
- 139 16
- 140 16
- 12 15
- 43 15
- 56 15
- 94 15
- 102 15
- 182 15
- 22 14
- 58 14
- 92 14
- 107 14
- 108 14
- 370 14
- 26 13
- 32 13
- 33 13
- 35 13
- 62 13
- 21 12
- 61 12
- 173 12
- 105 11
- 132 11
- 98 10
- 112 10
- 392 10
- 133 9
- 159 9
- 998 9
- 24 8
- 27 8
- 30 8
- 41 8
- 83 8
- 123 8
- 126 8
- 135 8
- 170 8
- 181 8
- 185 8
- 221 8
- 34 7
- 40 7
- 47 7
- 63 7
- 128 7
- 130 7
- 134 7
- 137 7
- 187 7
- 189 7
- 190 7
- 374 7
- 401 7
- 413 7
- 796 7
- 1009 7
- 1013 7
- 1019 7
- 1022 7
- 1029 7
- 1043 7
- 1052 7
- 1058 7
- 52 6
- 80 6
- 87 6
- 147 6
- 153 6
- 164 6
- 359 6
- 388 6
- 397 6
- 404 6
- 14 5
- 36 5
- 49 5
- 51 5
- 66 5
- 67 5
- 69 5
- 86 5
- 89 5
- 95 5
- 103 5
- 109 5
- 125 5
- 151 5
- 180 5
- 224 5
- 353 5
- 369 5
- 380 5
- 405 5
- 805 5
- 16 4
- 25 4
- 46 4
- 74 4
- 76 4
- 77 4
- 104 4
- 110 4
- 118 4
- 119 4
- 138 4
- 152 4
- 157 4
- 161 4
- 167 4
- 168 4
- 349 4
- 365 4
- 377 4
- 384 4
- 399 4
- 410 4
- 433 4
- 668 4
- 747 4
- 797 4
- 811 4
- 828 4
- 957 4
- 23 3
- 37 3
- 60 3
- 81 3
- 84 3
- 90 3
- 93 3
- 106 3
- 113 3
- 114 3
- 141 3
- 145 3
- 146 3
- 150 3
- 163 3
- 165 3
- 174 3
- 178 3
- 199 3
- 211 3
- 218 3
- 242 3
- 327 3
- 333 3
- 335 3
- 340 3
- 344 3
- 361 3
- 366 3
- 372 3
- 378 3
- 408 3
- 426 3
- 455 3
- 478 3
- 503 3
- 542 3
- 573 3
- 658 3
- 687 3
- 718 3
- 732 3
- 757 3
- 767 3
- 787 3
- 845 3
- 906 3
- 929 3
- 982 3
- 993 3
- 1063 3
- 10 2
- 38 2
- 39 2
- 64 2
- 72 2
- 73 2
- 75 2
- 78 2
- 79 2
- 85 2
- 96 2
- 111 2
- 117 2
- 120 2
- 144 2
- 148 2
- 155 2
- 160 2
- 166 2
- 172 2
- 188 2
- 217 2
- 233 2
- 249 2
- 253 2
- 255 2
- 271 2
- 325 2
- 339 2
- 343 2
- 346 2
- 351 2
- 356 2
- 364 2
- 371 2
- 376 2
- 382 2
- 386 2
- 393 2
- 402 2
- 416 2
- 417 2
- 441 2
- 565 2
- 615 2
- 635 2
- 731 2
- 756 2
- 762 2
- 772 2
- 799 2
- 837 2
- 873 2
- 48 1
- 50 1
- 65 1
- 68 1
- 82 1
- 88 1
- 91 1
- 97 1
- 101 1
- 116 1
- 122 1
- 127 1
- 129 1
- 142 1
- 143 1
- 149 1
- 156 1
- 162 1
- 171 1
- 179 1
- 183 1
- 192 1
- 195 1
- 198 1
- 203 1
- 205 1
- 206 1
- 208 1
- 215 1
- 216 1
- 223 1
- 237 1
- 241 1
- 244 1
- 251 1
- 258 1
- 262 1
- 266 1
- 320 1
- 322 1
- 324 1
- 331 1
- 337 1
- 338 1
- 341 1
- 342 1
- 347 1
- 357 1
- 358 1
- 360 1
- 363 1
- 373 1
- 375 1
- 379 1
- 387 1
- 389 1
- 395 1
- 396 1
- 400 1
- 406 1
- 411 1
- 414 1
- 419 1
- 420 1
- 421 1
- 422 1
- 428 1
- 431 1
- 434 1
- 450 1
- 453 1
- 464 1
- 466 1
- 471 1
- 472 1
- 477 1
- 485 1
- 491 1
- 500 1
- 511 1
- 518 1
- 526 1
- 532 1
- 550 1
- 559 1
- 582 1
- 592 1
- 598 1
- 607 1
- 614 1
- 620 1
- 625 1
- 630 1
- 631 1
- 632 1
- 640 1
- 644 1
- 647 1
- 650 1
- 654 1
- 662 1
- 665 1
- 667 1
- 670 1
- 674 1
- 679 1
- 690 1
- 701 1
- 710 1
- 712 1
- 724 1
- 727 1
- 736 1
- 742 1
- 745 1
- 753 1
- 755 1
- 761 1
- 766 1
- 776 1
- 783 1
- 790 1
- 792 1
- 793 1
- 803 1
- 809 1
- 810 1
- 815 1
- 816 1
- 819 1
- 825 1
- 842 1
- 846 1
- 853 1
- 858 1
- 867 1
- 872 1
- 879 1
- 882 1
- 890 1
- 902 1
- 910 1
- 913 1
- 919 1
- 926 1
- 935 1
- 948 1
- 950 1
- 954 1
- 962 1
- 970 1
- 978 1
- 987 1
- 990 1
state 1
- Hawaii · 3,982 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500127 | 2500127 | 2022-05-13 | Hawaii | Hawaii | 15001 | 28425 | 190 |
2500128 | 2500128 | 2022-05-13 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2500129 | 2500129 | 2022-05-13 | Kalawao | Hawaii | 15005 | 1 | 0 |
2500130 | 2500130 | 2022-05-13 | Kauai | Hawaii | 15007 | 12864 | 29 |
2500131 | 2500131 | 2022-05-13 | Maui | Hawaii | 15009 | 32000 | 140 |
2500132 | 2500132 | 2022-05-13 | Unknown | Hawaii | 0 | 9 | |
2496869 | 2496869 | 2022-05-12 | Hawaii | Hawaii | 15001 | 28425 | 190 |
2496870 | 2496870 | 2022-05-12 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2496871 | 2496871 | 2022-05-12 | Kalawao | Hawaii | 15005 | 1 | 0 |
2496872 | 2496872 | 2022-05-12 | Kauai | Hawaii | 15007 | 12864 | 29 |
2496873 | 2496873 | 2022-05-12 | Maui | Hawaii | 15009 | 32000 | 140 |
2496874 | 2496874 | 2022-05-12 | Unknown | Hawaii | 0 | 9 | |
2493611 | 2493611 | 2022-05-11 | Hawaii | Hawaii | 15001 | 28425 | 190 |
2493612 | 2493612 | 2022-05-11 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2493613 | 2493613 | 2022-05-11 | Kalawao | Hawaii | 15005 | 1 | 0 |
2493614 | 2493614 | 2022-05-11 | Kauai | Hawaii | 15007 | 12864 | 29 |
2493615 | 2493615 | 2022-05-11 | Maui | Hawaii | 15009 | 32000 | 140 |
2493616 | 2493616 | 2022-05-11 | Unknown | Hawaii | 0 | 9 | |
2490353 | 2490353 | 2022-05-10 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2490354 | 2490354 | 2022-05-10 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2490355 | 2490355 | 2022-05-10 | Kalawao | Hawaii | 15005 | 1 | 0 |
2490356 | 2490356 | 2022-05-10 | Kauai | Hawaii | 15007 | 12473 | 29 |
2490357 | 2490357 | 2022-05-10 | Maui | Hawaii | 15009 | 31311 | 140 |
2490358 | 2490358 | 2022-05-10 | Unknown | Hawaii | 0 | 9 | |
2487096 | 2487096 | 2022-05-09 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2487097 | 2487097 | 2022-05-09 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2487098 | 2487098 | 2022-05-09 | Kalawao | Hawaii | 15005 | 1 | 0 |
2487099 | 2487099 | 2022-05-09 | Kauai | Hawaii | 15007 | 12473 | 29 |
2487100 | 2487100 | 2022-05-09 | Maui | Hawaii | 15009 | 31311 | 140 |
2487101 | 2487101 | 2022-05-09 | Unknown | Hawaii | 0 | 9 | |
2483838 | 2483838 | 2022-05-08 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2483839 | 2483839 | 2022-05-08 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2483840 | 2483840 | 2022-05-08 | Kalawao | Hawaii | 15005 | 1 | 0 |
2483841 | 2483841 | 2022-05-08 | Kauai | Hawaii | 15007 | 12473 | 29 |
2483842 | 2483842 | 2022-05-08 | Maui | Hawaii | 15009 | 31311 | 140 |
2483843 | 2483843 | 2022-05-08 | Unknown | Hawaii | 0 | 9 | |
2480580 | 2480580 | 2022-05-07 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2480581 | 2480581 | 2022-05-07 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2480582 | 2480582 | 2022-05-07 | Kalawao | Hawaii | 15005 | 1 | 0 |
2480583 | 2480583 | 2022-05-07 | Kauai | Hawaii | 15007 | 12473 | 29 |
2480584 | 2480584 | 2022-05-07 | Maui | Hawaii | 15009 | 31311 | 140 |
2480585 | 2480585 | 2022-05-07 | Unknown | Hawaii | 0 | 9 | |
2477322 | 2477322 | 2022-05-06 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2477323 | 2477323 | 2022-05-06 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2477324 | 2477324 | 2022-05-06 | Kalawao | Hawaii | 15005 | 1 | 0 |
2477325 | 2477325 | 2022-05-06 | Kauai | Hawaii | 15007 | 12473 | 29 |
2477326 | 2477326 | 2022-05-06 | Maui | Hawaii | 15009 | 31311 | 140 |
2477327 | 2477327 | 2022-05-06 | Unknown | Hawaii | 0 | 9 | |
2474064 | 2474064 | 2022-05-05 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2474065 | 2474065 | 2022-05-05 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2474066 | 2474066 | 2022-05-05 | Kalawao | Hawaii | 15005 | 1 | 0 |
2474067 | 2474067 | 2022-05-05 | Kauai | Hawaii | 15007 | 12473 | 29 |
2474068 | 2474068 | 2022-05-05 | Maui | Hawaii | 15009 | 31311 | 140 |
2474069 | 2474069 | 2022-05-05 | Unknown | Hawaii | 0 | 9 | |
2470807 | 2470807 | 2022-05-04 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2470808 | 2470808 | 2022-05-04 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2470809 | 2470809 | 2022-05-04 | Kalawao | Hawaii | 15005 | 1 | 0 |
2470810 | 2470810 | 2022-05-04 | Kauai | Hawaii | 15007 | 12473 | 29 |
2470811 | 2470811 | 2022-05-04 | Maui | Hawaii | 15009 | 31311 | 140 |
2470812 | 2470812 | 2022-05-04 | Unknown | Hawaii | 0 | 9 | |
2467551 | 2467551 | 2022-05-03 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2467552 | 2467552 | 2022-05-03 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2467553 | 2467553 | 2022-05-03 | Kalawao | Hawaii | 15005 | 1 | 0 |
2467554 | 2467554 | 2022-05-03 | Kauai | Hawaii | 15007 | 12240 | 28 |
2467555 | 2467555 | 2022-05-03 | Maui | Hawaii | 15009 | 30809 | 139 |
2467556 | 2467556 | 2022-05-03 | Unknown | Hawaii | 0 | 9 | |
2464296 | 2464296 | 2022-05-02 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2464297 | 2464297 | 2022-05-02 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2464298 | 2464298 | 2022-05-02 | Kalawao | Hawaii | 15005 | 1 | 0 |
2464299 | 2464299 | 2022-05-02 | Kauai | Hawaii | 15007 | 12240 | 28 |
2464300 | 2464300 | 2022-05-02 | Maui | Hawaii | 15009 | 30809 | 139 |
2464301 | 2464301 | 2022-05-02 | Unknown | Hawaii | 0 | 9 | |
2461040 | 2461040 | 2022-05-01 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2461041 | 2461041 | 2022-05-01 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2461042 | 2461042 | 2022-05-01 | Kalawao | Hawaii | 15005 | 1 | 0 |
2461043 | 2461043 | 2022-05-01 | Kauai | Hawaii | 15007 | 12240 | 28 |
2461044 | 2461044 | 2022-05-01 | Maui | Hawaii | 15009 | 30809 | 139 |
2461045 | 2461045 | 2022-05-01 | Unknown | Hawaii | 0 | 9 | |
2457784 | 2457784 | 2022-04-30 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2457785 | 2457785 | 2022-04-30 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2457786 | 2457786 | 2022-04-30 | Kalawao | Hawaii | 15005 | 1 | 0 |
2457787 | 2457787 | 2022-04-30 | Kauai | Hawaii | 15007 | 12240 | 28 |
2457788 | 2457788 | 2022-04-30 | Maui | Hawaii | 15009 | 30809 | 139 |
2457789 | 2457789 | 2022-04-30 | Unknown | Hawaii | 0 | 9 | |
2454528 | 2454528 | 2022-04-29 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2454529 | 2454529 | 2022-04-29 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2454530 | 2454530 | 2022-04-29 | Kalawao | Hawaii | 15005 | 1 | 0 |
2454531 | 2454531 | 2022-04-29 | Kauai | Hawaii | 15007 | 12240 | 28 |
2454532 | 2454532 | 2022-04-29 | Maui | Hawaii | 15009 | 30809 | 139 |
2454533 | 2454533 | 2022-04-29 | Unknown | Hawaii | 0 | 9 | |
2451272 | 2451272 | 2022-04-28 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2451273 | 2451273 | 2022-04-28 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2451274 | 2451274 | 2022-04-28 | Kalawao | Hawaii | 15005 | 1 | 0 |
2451275 | 2451275 | 2022-04-28 | Kauai | Hawaii | 15007 | 12240 | 28 |
2451276 | 2451276 | 2022-04-28 | Maui | Hawaii | 15009 | 30809 | 139 |
2451277 | 2451277 | 2022-04-28 | Unknown | Hawaii | 0 | 9 | |
2448016 | 2448016 | 2022-04-27 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2448017 | 2448017 | 2022-04-27 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2448018 | 2448018 | 2022-04-27 | Kalawao | Hawaii | 15005 | 1 | 0 |
2448019 | 2448019 | 2022-04-27 | Kauai | Hawaii | 15007 | 12240 | 28 |
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);