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 · 2,053 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417681 | 1417681 | 2021-06-14 | Hawaii | Hawaii | 15001 | 3142 | 54 |
1417682 | 1417682 | 2021-06-14 | Honolulu | Hawaii | 15003 | 27490 | 392 |
1417683 | 1417683 | 2021-06-14 | Kalawao | Hawaii | 15005 | 1 | 0 |
1417684 | 1417684 | 2021-06-14 | Kauai | Hawaii | 15007 | 335 | 2 |
1417685 | 1417685 | 2021-06-14 | Maui | Hawaii | 15009 | 4801 | 55 |
1414435 | 1414435 | 2021-06-13 | Hawaii | Hawaii | 15001 | 3138 | 54 |
1414436 | 1414436 | 2021-06-13 | Honolulu | Hawaii | 15003 | 27469 | 392 |
1414437 | 1414437 | 2021-06-13 | Kalawao | Hawaii | 15005 | 1 | 0 |
1414438 | 1414438 | 2021-06-13 | Kauai | Hawaii | 15007 | 328 | 2 |
1414439 | 1414439 | 2021-06-13 | Maui | Hawaii | 15009 | 4787 | 55 |
1411190 | 1411190 | 2021-06-12 | Hawaii | Hawaii | 15001 | 3136 | 54 |
1411191 | 1411191 | 2021-06-12 | Honolulu | Hawaii | 15003 | 27453 | 392 |
1411192 | 1411192 | 2021-06-12 | Kalawao | Hawaii | 15005 | 1 | 0 |
1411193 | 1411193 | 2021-06-12 | Kauai | Hawaii | 15007 | 328 | 2 |
1411194 | 1411194 | 2021-06-12 | Maui | Hawaii | 15009 | 4775 | 55 |
1407945 | 1407945 | 2021-06-11 | Hawaii | Hawaii | 15001 | 3090 | 54 |
1407946 | 1407946 | 2021-06-11 | Honolulu | Hawaii | 15003 | 27420 | 392 |
1407947 | 1407947 | 2021-06-11 | Kalawao | Hawaii | 15005 | 1 | 0 |
1407948 | 1407948 | 2021-06-11 | Kauai | Hawaii | 15007 | 327 | 2 |
1407949 | 1407949 | 2021-06-11 | Maui | Hawaii | 15009 | 4757 | 55 |
1404699 | 1404699 | 2021-06-10 | Hawaii | Hawaii | 15001 | 3060 | 53 |
1404700 | 1404700 | 2021-06-10 | Honolulu | Hawaii | 15003 | 27387 | 392 |
1404701 | 1404701 | 2021-06-10 | Kalawao | Hawaii | 15005 | 1 | 0 |
1404702 | 1404702 | 2021-06-10 | Kauai | Hawaii | 15007 | 327 | 2 |
1404703 | 1404703 | 2021-06-10 | Maui | Hawaii | 15009 | 4747 | 55 |
1401454 | 1401454 | 2021-06-09 | Hawaii | Hawaii | 15001 | 3050 | 53 |
1401455 | 1401455 | 2021-06-09 | Honolulu | Hawaii | 15003 | 27355 | 392 |
1401456 | 1401456 | 2021-06-09 | Kalawao | Hawaii | 15005 | 1 | 0 |
1401457 | 1401457 | 2021-06-09 | Kauai | Hawaii | 15007 | 325 | 2 |
1401458 | 1401458 | 2021-06-09 | Maui | Hawaii | 15009 | 4730 | 55 |
1398209 | 1398209 | 2021-06-08 | Hawaii | Hawaii | 15001 | 3045 | 53 |
1398210 | 1398210 | 2021-06-08 | Honolulu | Hawaii | 15003 | 27338 | 392 |
1398211 | 1398211 | 2021-06-08 | Kalawao | Hawaii | 15005 | 1 | 0 |
1398212 | 1398212 | 2021-06-08 | Kauai | Hawaii | 15007 | 325 | 2 |
1398213 | 1398213 | 2021-06-08 | Maui | Hawaii | 15009 | 4713 | 55 |
1394962 | 1394962 | 2021-06-07 | Hawaii | Hawaii | 15001 | 3043 | 53 |
1394963 | 1394963 | 2021-06-07 | Honolulu | Hawaii | 15003 | 27323 | 392 |
1394964 | 1394964 | 2021-06-07 | Kalawao | Hawaii | 15005 | 1 | 0 |
1394965 | 1394965 | 2021-06-07 | Kauai | Hawaii | 15007 | 324 | 2 |
1394966 | 1394966 | 2021-06-07 | Maui | Hawaii | 15009 | 4700 | 55 |
1391717 | 1391717 | 2021-06-06 | Hawaii | Hawaii | 15001 | 3040 | 53 |
1391718 | 1391718 | 2021-06-06 | Honolulu | Hawaii | 15003 | 27306 | 392 |
1391719 | 1391719 | 2021-06-06 | Kalawao | Hawaii | 15005 | 1 | 0 |
1391720 | 1391720 | 2021-06-06 | Kauai | Hawaii | 15007 | 325 | 2 |
1391721 | 1391721 | 2021-06-06 | Maui | Hawaii | 15009 | 4688 | 55 |
1388472 | 1388472 | 2021-06-05 | Hawaii | Hawaii | 15001 | 3005 | 53 |
1388473 | 1388473 | 2021-06-05 | Honolulu | Hawaii | 15003 | 27274 | 389 |
1388474 | 1388474 | 2021-06-05 | Kalawao | Hawaii | 15005 | 1 | 0 |
1388475 | 1388475 | 2021-06-05 | Kauai | Hawaii | 15007 | 325 | 2 |
1388476 | 1388476 | 2021-06-05 | Maui | Hawaii | 15009 | 4676 | 55 |
1385227 | 1385227 | 2021-06-04 | Hawaii | Hawaii | 15001 | 2996 | 53 |
1385228 | 1385228 | 2021-06-04 | Honolulu | Hawaii | 15003 | 27233 | 388 |
1385229 | 1385229 | 2021-06-04 | Kalawao | Hawaii | 15005 | 1 | 0 |
1385230 | 1385230 | 2021-06-04 | Kauai | Hawaii | 15007 | 324 | 2 |
1385231 | 1385231 | 2021-06-04 | Maui | Hawaii | 15009 | 4663 | 55 |
1381981 | 1381981 | 2021-06-03 | Hawaii | Hawaii | 15001 | 2971 | 53 |
1381982 | 1381982 | 2021-06-03 | Honolulu | Hawaii | 15003 | 27206 | 388 |
1381983 | 1381983 | 2021-06-03 | Kalawao | Hawaii | 15005 | 1 | 0 |
1381984 | 1381984 | 2021-06-03 | Kauai | Hawaii | 15007 | 324 | 2 |
1381985 | 1381985 | 2021-06-03 | Maui | Hawaii | 15009 | 4650 | 55 |
1378736 | 1378736 | 2021-06-02 | Hawaii | Hawaii | 15001 | 2968 | 53 |
1378737 | 1378737 | 2021-06-02 | Honolulu | Hawaii | 15003 | 27170 | 388 |
1378738 | 1378738 | 2021-06-02 | Kalawao | Hawaii | 15005 | 1 | 0 |
1378739 | 1378739 | 2021-06-02 | Kauai | Hawaii | 15007 | 323 | 2 |
1378740 | 1378740 | 2021-06-02 | Maui | Hawaii | 15009 | 4649 | 54 |
1375490 | 1375490 | 2021-06-01 | Hawaii | Hawaii | 15001 | 2968 | 53 |
1375491 | 1375491 | 2021-06-01 | Honolulu | Hawaii | 15003 | 27157 | 388 |
1375492 | 1375492 | 2021-06-01 | Kalawao | Hawaii | 15005 | 1 | 0 |
1375493 | 1375493 | 2021-06-01 | Kauai | Hawaii | 15007 | 324 | 2 |
1375494 | 1375494 | 2021-06-01 | Maui | Hawaii | 15009 | 4640 | 54 |
1372245 | 1372245 | 2021-05-31 | Hawaii | Hawaii | 15001 | 2949 | 53 |
1372246 | 1372246 | 2021-05-31 | Honolulu | Hawaii | 15003 | 27127 | 388 |
1372247 | 1372247 | 2021-05-31 | Kalawao | Hawaii | 15005 | 1 | 0 |
1372248 | 1372248 | 2021-05-31 | Kauai | Hawaii | 15007 | 321 | 2 |
1372249 | 1372249 | 2021-05-31 | Maui | Hawaii | 15009 | 4637 | 54 |
1369000 | 1369000 | 2021-05-30 | Hawaii | Hawaii | 15001 | 2949 | 53 |
1369001 | 1369001 | 2021-05-30 | Honolulu | Hawaii | 15003 | 27107 | 388 |
1369002 | 1369002 | 2021-05-30 | Kalawao | Hawaii | 15005 | 1 | 0 |
1369003 | 1369003 | 2021-05-30 | Kauai | Hawaii | 15007 | 320 | 2 |
1369004 | 1369004 | 2021-05-30 | Maui | Hawaii | 15009 | 4631 | 54 |
1365754 | 1365754 | 2021-05-29 | Hawaii | Hawaii | 15001 | 2886 | 53 |
1365755 | 1365755 | 2021-05-29 | Honolulu | Hawaii | 15003 | 27059 | 387 |
1365756 | 1365756 | 2021-05-29 | Kalawao | Hawaii | 15005 | 1 | 0 |
1365757 | 1365757 | 2021-05-29 | Kauai | Hawaii | 15007 | 318 | 2 |
1365758 | 1365758 | 2021-05-29 | Maui | Hawaii | 15009 | 4625 | 54 |
1362508 | 1362508 | 2021-05-28 | Hawaii | Hawaii | 15001 | 2875 | 53 |
1362509 | 1362509 | 2021-05-28 | Honolulu | Hawaii | 15003 | 27031 | 386 |
1362510 | 1362510 | 2021-05-28 | Kalawao | Hawaii | 15005 | 1 | 0 |
1362511 | 1362511 | 2021-05-28 | Kauai | Hawaii | 15007 | 318 | 2 |
1362512 | 1362512 | 2021-05-28 | Maui | Hawaii | 15009 | 4619 | 54 |
1359261 | 1359261 | 2021-05-27 | Hawaii | Hawaii | 15001 | 2870 | 53 |
1359262 | 1359262 | 2021-05-27 | Honolulu | Hawaii | 15003 | 27007 | 386 |
1359263 | 1359263 | 2021-05-27 | Kalawao | Hawaii | 15005 | 1 | 0 |
1359264 | 1359264 | 2021-05-27 | Kauai | Hawaii | 15007 | 318 | 2 |
1359265 | 1359265 | 2021-05-27 | Maui | Hawaii | 15009 | 4611 | 54 |
1356015 | 1356015 | 2021-05-26 | Hawaii | Hawaii | 15001 | 2864 | 53 |
1356016 | 1356016 | 2021-05-26 | Honolulu | Hawaii | 15003 | 26969 | 384 |
1356017 | 1356017 | 2021-05-26 | Kalawao | Hawaii | 15005 | 1 | 0 |
1356018 | 1356018 | 2021-05-26 | Kauai | Hawaii | 15007 | 318 | 2 |
1356019 | 1356019 | 2021-05-26 | Maui | Hawaii | 15009 | 4602 | 54 |
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);