ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Fairbanks North Star Borough" and deaths = 43 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 |
---|---|---|---|---|---|---|---|
1404222 | 1404222 | 2021-06-10 | Fairbanks North Star Borough | Alaska | 2090 | 7978 | 43 |
1400977 | 1400977 | 2021-06-09 | Fairbanks North Star Borough | Alaska | 2090 | 7978 | 43 |
1397732 | 1397732 | 2021-06-08 | Fairbanks North Star Borough | Alaska | 2090 | 7970 | 43 |
1394485 | 1394485 | 2021-06-07 | Fairbanks North Star Borough | Alaska | 2090 | 7970 | 43 |
1391240 | 1391240 | 2021-06-06 | Fairbanks North Star Borough | Alaska | 2090 | 7969 | 43 |
1387995 | 1387995 | 2021-06-05 | Fairbanks North Star Borough | Alaska | 2090 | 7969 | 43 |
1384750 | 1384750 | 2021-06-04 | Fairbanks North Star Borough | Alaska | 2090 | 7969 | 43 |
1381504 | 1381504 | 2021-06-03 | Fairbanks North Star Borough | Alaska | 2090 | 7967 | 43 |
1378259 | 1378259 | 2021-06-02 | Fairbanks North Star Borough | Alaska | 2090 | 7962 | 43 |
1375013 | 1375013 | 2021-06-01 | Fairbanks North Star Borough | Alaska | 2090 | 7953 | 43 |
1371768 | 1371768 | 2021-05-31 | Fairbanks North Star Borough | Alaska | 2090 | 7938 | 43 |
1368522 | 1368522 | 2021-05-30 | Fairbanks North Star Borough | Alaska | 2090 | 7938 | 43 |
1365276 | 1365276 | 2021-05-29 | Fairbanks North Star Borough | Alaska | 2090 | 7938 | 43 |
1362030 | 1362030 | 2021-05-28 | Fairbanks North Star Borough | Alaska | 2090 | 7938 | 43 |
1358784 | 1358784 | 2021-05-27 | Fairbanks North Star Borough | Alaska | 2090 | 7935 | 43 |
1355538 | 1355538 | 2021-05-26 | Fairbanks North Star Borough | Alaska | 2090 | 7930 | 43 |
1352292 | 1352292 | 2021-05-25 | Fairbanks North Star Borough | Alaska | 2090 | 7923 | 43 |
1349046 | 1349046 | 2021-05-24 | Fairbanks North Star Borough | Alaska | 2090 | 7913 | 43 |
1345798 | 1345798 | 2021-05-23 | Fairbanks North Star Borough | Alaska | 2090 | 7904 | 43 |
1342550 | 1342550 | 2021-05-22 | Fairbanks North Star Borough | Alaska | 2090 | 7904 | 43 |
1339302 | 1339302 | 2021-05-21 | Fairbanks North Star Borough | Alaska | 2090 | 7904 | 43 |
1336055 | 1336055 | 2021-05-20 | Fairbanks North Star Borough | Alaska | 2090 | 7897 | 43 |
1332808 | 1332808 | 2021-05-19 | Fairbanks North Star Borough | Alaska | 2090 | 7884 | 43 |
1329561 | 1329561 | 2021-05-18 | Fairbanks North Star Borough | Alaska | 2090 | 7871 | 43 |
1326315 | 1326315 | 2021-05-17 | Fairbanks North Star Borough | Alaska | 2090 | 7866 | 43 |
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);