ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 24 and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2257555 | 2257555 | 2022-02-27 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2254304 | 2254304 | 2022-02-26 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2251053 | 2251053 | 2022-02-25 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2247802 | 2247802 | 2022-02-24 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2244551 | 2244551 | 2022-02-23 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2241300 | 2241300 | 2022-02-22 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2238049 | 2238049 | 2022-02-21 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2234798 | 2234798 | 2022-02-20 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2231547 | 2231547 | 2022-02-19 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2228296 | 2228296 | 2022-02-18 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2225045 | 2225045 | 2022-02-17 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2221794 | 2221794 | 2022-02-16 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2218543 | 2218543 | 2022-02-15 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2215292 | 2215292 | 2022-02-14 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2212041 | 2212041 | 2022-02-13 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2208788 | 2208788 | 2022-02-12 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2205535 | 2205535 | 2022-02-11 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2202282 | 2202282 | 2022-02-10 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2199028 | 2199028 | 2022-02-09 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2195774 | 2195774 | 2022-02-08 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2192520 | 2192520 | 2022-02-07 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2189266 | 2189266 | 2022-02-06 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2186013 | 2186013 | 2022-02-05 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2182761 | 2182761 | 2022-02-04 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2179509 | 2179509 | 2022-02-03 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2176258 | 2176258 | 2022-02-02 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2173005 | 2173005 | 2022-02-01 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
204940 | 204940 | 2020-06-03 | Unknown | Northern Mariana Islands | 24 | 2 |
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);