ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 236 and fips = 37097 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 |
---|---|---|---|---|---|---|---|
1558674 | 1558674 | 2021-07-27 | Iredell | North Carolina | 37097 | 19674 | 236 |
1555427 | 1555427 | 2021-07-26 | Iredell | North Carolina | 37097 | 19651 | 236 |
1552180 | 1552180 | 2021-07-25 | Iredell | North Carolina | 37097 | 19573 | 236 |
1548933 | 1548933 | 2021-07-24 | Iredell | North Carolina | 37097 | 19573 | 236 |
1545686 | 1545686 | 2021-07-23 | Iredell | North Carolina | 37097 | 19573 | 236 |
1542439 | 1542439 | 2021-07-22 | Iredell | North Carolina | 37097 | 19554 | 236 |
1539191 | 1539191 | 2021-07-21 | Iredell | North Carolina | 37097 | 19527 | 236 |
1535944 | 1535944 | 2021-07-20 | Iredell | North Carolina | 37097 | 19488 | 236 |
1532696 | 1532696 | 2021-07-19 | Iredell | North Carolina | 37097 | 19472 | 236 |
1529449 | 1529449 | 2021-07-18 | Iredell | North Carolina | 37097 | 19435 | 236 |
1526202 | 1526202 | 2021-07-17 | Iredell | North Carolina | 37097 | 19435 | 236 |
1522955 | 1522955 | 2021-07-16 | Iredell | North Carolina | 37097 | 19435 | 236 |
1519707 | 1519707 | 2021-07-15 | Iredell | North Carolina | 37097 | 19427 | 236 |
1516459 | 1516459 | 2021-07-14 | Iredell | North Carolina | 37097 | 19415 | 236 |
1513212 | 1513212 | 2021-07-13 | Iredell | North Carolina | 37097 | 19394 | 236 |
1509966 | 1509966 | 2021-07-12 | Iredell | North Carolina | 37097 | 19385 | 236 |
1506719 | 1506719 | 2021-07-11 | Iredell | North Carolina | 37097 | 19353 | 236 |
1503473 | 1503473 | 2021-07-10 | Iredell | North Carolina | 37097 | 19353 | 236 |
1500227 | 1500227 | 2021-07-09 | Iredell | North Carolina | 37097 | 19353 | 236 |
1496981 | 1496981 | 2021-07-08 | Iredell | North Carolina | 37097 | 19343 | 236 |
1493734 | 1493734 | 2021-07-07 | Iredell | North Carolina | 37097 | 19334 | 236 |
1490487 | 1490487 | 2021-07-06 | Iredell | North Carolina | 37097 | 19317 | 236 |
1487240 | 1487240 | 2021-07-05 | Iredell | North Carolina | 37097 | 19284 | 236 |
1483994 | 1483994 | 2021-07-04 | Iredell | North Carolina | 37097 | 19284 | 236 |
1480748 | 1480748 | 2021-07-03 | Iredell | North Carolina | 37097 | 19284 | 236 |
1477501 | 1477501 | 2021-07-02 | Iredell | North Carolina | 37097 | 19284 | 236 |
1474255 | 1474255 | 2021-07-01 | Iredell | North Carolina | 37097 | 19279 | 236 |
1471009 | 1471009 | 2021-06-30 | Iredell | North Carolina | 37097 | 19278 | 236 |
1467764 | 1467764 | 2021-06-29 | Iredell | North Carolina | 37097 | 19273 | 236 |
1464519 | 1464519 | 2021-06-28 | Iredell | North Carolina | 37097 | 19268 | 236 |
1461274 | 1461274 | 2021-06-27 | Iredell | North Carolina | 37097 | 19260 | 236 |
1458029 | 1458029 | 2021-06-26 | Iredell | North Carolina | 37097 | 19260 | 236 |
1454784 | 1454784 | 2021-06-25 | Iredell | North Carolina | 37097 | 19260 | 236 |
1451539 | 1451539 | 2021-06-24 | Iredell | North Carolina | 37097 | 19259 | 236 |
1448293 | 1448293 | 2021-06-23 | Iredell | North Carolina | 37097 | 19252 | 236 |
1445048 | 1445048 | 2021-06-22 | Iredell | North Carolina | 37097 | 19244 | 236 |
1441803 | 1441803 | 2021-06-21 | Iredell | North Carolina | 37097 | 19240 | 236 |
1438558 | 1438558 | 2021-06-20 | Iredell | North Carolina | 37097 | 19223 | 236 |
1435311 | 1435311 | 2021-06-19 | Iredell | North Carolina | 37097 | 19223 | 236 |
1432064 | 1432064 | 2021-06-18 | Iredell | North Carolina | 37097 | 19223 | 236 |
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);