ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where county = "West Carroll" 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 |
---|---|---|---|---|---|---|---|
412855 | 412855 | 2020-08-08 | West Carroll | Louisiana | 22123 | 287 | 5 |
409635 | 409635 | 2020-08-07 | West Carroll | Louisiana | 22123 | 287 | 5 |
406415 | 406415 | 2020-08-06 | West Carroll | Louisiana | 22123 | 277 | 5 |
403197 | 403197 | 2020-08-05 | West Carroll | Louisiana | 22123 | 275 | 5 |
399980 | 399980 | 2020-08-04 | West Carroll | Louisiana | 22123 | 272 | 5 |
396765 | 396765 | 2020-08-03 | West Carroll | Louisiana | 22123 | 259 | 5 |
393549 | 393549 | 2020-08-02 | West Carroll | Louisiana | 22123 | 258 | 5 |
390332 | 390332 | 2020-08-01 | West Carroll | Louisiana | 22123 | 247 | 5 |
387115 | 387115 | 2020-07-31 | West Carroll | Louisiana | 22123 | 247 | 5 |
383897 | 383897 | 2020-07-30 | West Carroll | Louisiana | 22123 | 242 | 5 |
380680 | 380680 | 2020-07-29 | West Carroll | Louisiana | 22123 | 234 | 5 |
377463 | 377463 | 2020-07-28 | West Carroll | Louisiana | 22123 | 226 | 5 |
374248 | 374248 | 2020-07-27 | West Carroll | Louisiana | 22123 | 226 | 5 |
371036 | 371036 | 2020-07-26 | West Carroll | Louisiana | 22123 | 225 | 5 |
367826 | 367826 | 2020-07-25 | West Carroll | Louisiana | 22123 | 218 | 5 |
364619 | 364619 | 2020-07-24 | West Carroll | Louisiana | 22123 | 218 | 5 |
361412 | 361412 | 2020-07-23 | West Carroll | Louisiana | 22123 | 213 | 5 |
358207 | 358207 | 2020-07-22 | West Carroll | Louisiana | 22123 | 211 | 5 |
355004 | 355004 | 2020-07-21 | West Carroll | Louisiana | 22123 | 206 | 5 |
351802 | 351802 | 2020-07-20 | West Carroll | Louisiana | 22123 | 205 | 5 |
348602 | 348602 | 2020-07-19 | West Carroll | Louisiana | 22123 | 198 | 5 |
345401 | 345401 | 2020-07-18 | West Carroll | Louisiana | 22123 | 191 | 5 |
342201 | 342201 | 2020-07-17 | West Carroll | Louisiana | 22123 | 191 | 5 |
339005 | 339005 | 2020-07-16 | West Carroll | Louisiana | 22123 | 182 | 5 |
335809 | 335809 | 2020-07-15 | West Carroll | Louisiana | 22123 | 173 | 5 |
332616 | 332616 | 2020-07-14 | West Carroll | Louisiana | 22123 | 173 | 5 |
329429 | 329429 | 2020-07-13 | West Carroll | Louisiana | 22123 | 176 | 5 |
326243 | 326243 | 2020-07-12 | West Carroll | Louisiana | 22123 | 176 | 5 |
323060 | 323060 | 2020-07-11 | West Carroll | Louisiana | 22123 | 169 | 5 |
319881 | 319881 | 2020-07-10 | West Carroll | Louisiana | 22123 | 166 | 5 |
316706 | 316706 | 2020-07-09 | West Carroll | Louisiana | 22123 | 161 | 5 |
313532 | 313532 | 2020-07-08 | West Carroll | Louisiana | 22123 | 158 | 5 |
310362 | 310362 | 2020-07-07 | West Carroll | Louisiana | 22123 | 155 | 5 |
307194 | 307194 | 2020-07-06 | West Carroll | Louisiana | 22123 | 152 | 5 |
304027 | 304027 | 2020-07-05 | West Carroll | Louisiana | 22123 | 149 | 5 |
300863 | 300863 | 2020-07-04 | West Carroll | Louisiana | 22123 | 141 | 5 |
297701 | 297701 | 2020-07-03 | West Carroll | Louisiana | 22123 | 141 | 5 |
294543 | 294543 | 2020-07-02 | West Carroll | Louisiana | 22123 | 138 | 5 |
291389 | 291389 | 2020-07-01 | West Carroll | Louisiana | 22123 | 134 | 5 |
288238 | 288238 | 2020-06-30 | West Carroll | Louisiana | 22123 | 124 | 5 |
285089 | 285089 | 2020-06-29 | West Carroll | Louisiana | 22123 | 118 | 5 |
281943 | 281943 | 2020-06-28 | West Carroll | Louisiana | 22123 | 115 | 5 |
278795 | 278795 | 2020-06-27 | West Carroll | Louisiana | 22123 | 114 | 5 |
275647 | 275647 | 2020-06-26 | West Carroll | Louisiana | 22123 | 114 | 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);