ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where county = "Iredell" and deaths = 5 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
245110 | 245110 | 2020-06-16 | Iredell | North Carolina | 37097 | 454 | 5 |
241998 | 241998 | 2020-06-15 | Iredell | North Carolina | 37097 | 446 | 5 |
238889 | 238889 | 2020-06-14 | Iredell | North Carolina | 37097 | 441 | 5 |
235781 | 235781 | 2020-06-13 | Iredell | North Carolina | 37097 | 419 | 5 |
232676 | 232676 | 2020-06-12 | Iredell | North Carolina | 37097 | 404 | 5 |
229571 | 229571 | 2020-06-11 | Iredell | North Carolina | 37097 | 378 | 5 |
226467 | 226467 | 2020-06-10 | Iredell | North Carolina | 37097 | 363 | 5 |
223367 | 223367 | 2020-06-09 | Iredell | North Carolina | 37097 | 354 | 5 |
220273 | 220273 | 2020-06-08 | Iredell | North Carolina | 37097 | 348 | 5 |
217181 | 217181 | 2020-06-07 | Iredell | North Carolina | 37097 | 332 | 5 |
214091 | 214091 | 2020-06-06 | Iredell | North Carolina | 37097 | 325 | 5 |
211007 | 211007 | 2020-06-05 | Iredell | North Carolina | 37097 | 301 | 5 |
207925 | 207925 | 2020-06-04 | Iredell | North Carolina | 37097 | 289 | 5 |
204844 | 204844 | 2020-06-03 | Iredell | North Carolina | 37097 | 280 | 5 |
201767 | 201767 | 2020-06-02 | Iredell | North Carolina | 37097 | 273 | 5 |
198693 | 198693 | 2020-06-01 | Iredell | North Carolina | 37097 | 264 | 5 |
195620 | 195620 | 2020-05-31 | Iredell | North Carolina | 37097 | 259 | 5 |
192550 | 192550 | 2020-05-30 | Iredell | North Carolina | 37097 | 254 | 5 |
189486 | 189486 | 2020-05-29 | Iredell | North Carolina | 37097 | 244 | 5 |
186426 | 186426 | 2020-05-28 | Iredell | North Carolina | 37097 | 239 | 5 |
183369 | 183369 | 2020-05-27 | Iredell | North Carolina | 37097 | 236 | 5 |
180321 | 180321 | 2020-05-26 | Iredell | North Carolina | 37097 | 230 | 5 |
177278 | 177278 | 2020-05-25 | Iredell | North Carolina | 37097 | 230 | 5 |
174234 | 174234 | 2020-05-24 | Iredell | North Carolina | 37097 | 228 | 5 |
171192 | 171192 | 2020-05-23 | Iredell | North Carolina | 37097 | 219 | 5 |
168153 | 168153 | 2020-05-22 | Iredell | North Carolina | 37097 | 212 | 5 |
165118 | 165118 | 2020-05-21 | Iredell | North Carolina | 37097 | 206 | 5 |
162089 | 162089 | 2020-05-20 | Iredell | North Carolina | 37097 | 202 | 5 |
159062 | 159062 | 2020-05-19 | Iredell | North Carolina | 37097 | 199 | 5 |
156043 | 156043 | 2020-05-18 | Iredell | North Carolina | 37097 | 192 | 5 |
153026 | 153026 | 2020-05-17 | Iredell | North Carolina | 37097 | 188 | 5 |
150016 | 150016 | 2020-05-16 | Iredell | North Carolina | 37097 | 181 | 5 |
147009 | 147009 | 2020-05-15 | Iredell | North Carolina | 37097 | 170 | 5 |
144008 | 144008 | 2020-05-14 | Iredell | North Carolina | 37097 | 166 | 5 |
141013 | 141013 | 2020-05-13 | Iredell | North Carolina | 37097 | 162 | 5 |
138017 | 138017 | 2020-05-12 | Iredell | North Carolina | 37097 | 158 | 5 |
135027 | 135027 | 2020-05-11 | Iredell | North Carolina | 37097 | 153 | 5 |
132036 | 132036 | 2020-05-10 | Iredell | North Carolina | 37097 | 151 | 5 |
129047 | 129047 | 2020-05-09 | Iredell | North Carolina | 37097 | 147 | 5 |
126058 | 126058 | 2020-05-08 | Iredell | North Carolina | 37097 | 141 | 5 |
123075 | 123075 | 2020-05-07 | Iredell | North Carolina | 37097 | 137 | 5 |
120100 | 120100 | 2020-05-06 | Iredell | North Carolina | 37097 | 136 | 5 |
117139 | 117139 | 2020-05-05 | Iredell | North Carolina | 37097 | 128 | 5 |
114259 | 114259 | 2020-05-04 | Iredell | North Carolina | 37097 | 120 | 5 |
111378 | 111378 | 2020-05-03 | Iredell | North Carolina | 37097 | 119 | 5 |
108505 | 108505 | 2020-05-02 | Iredell | North Carolina | 37097 | 119 | 5 |
105638 | 105638 | 2020-05-01 | Iredell | North Carolina | 37097 | 112 | 5 |
102776 | 102776 | 2020-04-30 | Iredell | North Carolina | 37097 | 111 | 5 |
99923 | 99923 | 2020-04-29 | Iredell | North Carolina | 37097 | 105 | 5 |
97075 | 97075 | 2020-04-28 | Iredell | North Carolina | 37097 | 102 | 5 |
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);