ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 26 and fips = 46009 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 |
---|---|---|---|---|---|---|---|
1202071 | 1202071 | 2021-04-08 | Bon Homme | South Dakota | 46009 | 1516 | 26 |
1198822 | 1198822 | 2021-04-07 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1195573 | 1195573 | 2021-04-06 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1192325 | 1192325 | 2021-04-05 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1189076 | 1189076 | 2021-04-04 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1185829 | 1185829 | 2021-04-03 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1182582 | 1182582 | 2021-04-02 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1179335 | 1179335 | 2021-04-01 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1176088 | 1176088 | 2021-03-31 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1172841 | 1172841 | 2021-03-30 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1169594 | 1169594 | 2021-03-29 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1166346 | 1166346 | 2021-03-28 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1163098 | 1163098 | 2021-03-27 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1159849 | 1159849 | 2021-03-26 | Bon Homme | South Dakota | 46009 | 1512 | 26 |
1156602 | 1156602 | 2021-03-25 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1153355 | 1153355 | 2021-03-24 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1150108 | 1150108 | 2021-03-23 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1146861 | 1146861 | 2021-03-22 | Bon Homme | South Dakota | 46009 | 1512 | 26 |
1143614 | 1143614 | 2021-03-21 | Bon Homme | South Dakota | 46009 | 1512 | 26 |
1140367 | 1140367 | 2021-03-20 | Bon Homme | South Dakota | 46009 | 1511 | 26 |
1137121 | 1137121 | 2021-03-19 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1133875 | 1133875 | 2021-03-18 | Bon Homme | South Dakota | 46009 | 1511 | 26 |
1130627 | 1130627 | 2021-03-17 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1127380 | 1127380 | 2021-03-16 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1124134 | 1124134 | 2021-03-15 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1120888 | 1120888 | 2021-03-14 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1117641 | 1117641 | 2021-03-13 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1114394 | 1114394 | 2021-03-12 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
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);