ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 144 and state = "Guam" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1622243 | 1622243 | 2021-08-16 | Unknown | Guam | 9987 | 144 | |
1618996 | 1618996 | 2021-08-15 | Unknown | Guam | 9880 | 144 | |
1615748 | 1615748 | 2021-08-14 | Unknown | Guam | 9880 | 144 | |
1612499 | 1612499 | 2021-08-13 | Unknown | Guam | 9880 | 144 | |
1609251 | 1609251 | 2021-08-12 | Unknown | Guam | 9834 | 144 | |
1606002 | 1606002 | 2021-08-11 | Unknown | Guam | 9786 | 144 | |
1602753 | 1602753 | 2021-08-10 | Unknown | Guam | 9738 | 144 | |
1599504 | 1599504 | 2021-08-09 | Unknown | Guam | 9694 | 144 | |
1596255 | 1596255 | 2021-08-08 | Unknown | Guam | 9642 | 144 | |
1593006 | 1593006 | 2021-08-07 | Unknown | Guam | 9642 | 144 | |
1589757 | 1589757 | 2021-08-06 | Unknown | Guam | 9642 | 144 | |
1586508 | 1586508 | 2021-08-05 | Unknown | Guam | 9621 | 144 | |
1583258 | 1583258 | 2021-08-04 | Unknown | Guam | 9592 | 144 | |
1580008 | 1580008 | 2021-08-03 | Unknown | Guam | 9562 | 144 | |
1576760 | 1576760 | 2021-08-02 | Unknown | Guam | 9533 | 144 | |
1573512 | 1573512 | 2021-08-01 | Unknown | Guam | 9510 | 144 | |
1570264 | 1570264 | 2021-07-31 | Unknown | Guam | 9510 | 144 | |
1567016 | 1567016 | 2021-07-30 | Unknown | Guam | 9510 | 144 | |
1563768 | 1563768 | 2021-07-29 | Unknown | Guam | 9498 | 144 | |
1560520 | 1560520 | 2021-07-28 | Unknown | Guam | 9491 | 144 | |
1557273 | 1557273 | 2021-07-27 | Unknown | Guam | 9483 | 144 | |
1554026 | 1554026 | 2021-07-26 | Unknown | Guam | 9475 | 144 | |
1550779 | 1550779 | 2021-07-25 | Unknown | Guam | 9470 | 144 | |
1547532 | 1547532 | 2021-07-24 | Unknown | Guam | 9470 | 144 | |
1544285 | 1544285 | 2021-07-23 | Unknown | Guam | 9470 | 144 | |
1541037 | 1541037 | 2021-07-22 | Unknown | Guam | 9469 | 144 | |
1537790 | 1537790 | 2021-07-21 | Unknown | Guam | 9455 | 144 | |
1534542 | 1534542 | 2021-07-20 | Unknown | Guam | 9455 | 144 | |
1531295 | 1531295 | 2021-07-19 | Unknown | Guam | 9447 | 144 |
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);