ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where county = "Saline" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Saline · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
603136 | 603136 | 2020-10-06 | Saline | Illinois | 17165 | 403 | 4 |
599893 | 599893 | 2020-10-05 | Saline | Illinois | 17165 | 399 | 4 |
596651 | 596651 | 2020-10-04 | Saline | Illinois | 17165 | 391 | 4 |
593409 | 593409 | 2020-10-03 | Saline | Illinois | 17165 | 382 | 4 |
590168 | 590168 | 2020-10-02 | Saline | Illinois | 17165 | 379 | 4 |
586927 | 586927 | 2020-10-01 | Saline | Illinois | 17165 | 372 | 4 |
583687 | 583687 | 2020-09-30 | Saline | Illinois | 17165 | 362 | 4 |
580448 | 580448 | 2020-09-29 | Saline | Illinois | 17165 | 350 | 4 |
577207 | 577207 | 2020-09-28 | Saline | Illinois | 17165 | 346 | 4 |
573965 | 573965 | 2020-09-27 | Saline | Illinois | 17165 | 340 | 4 |
570722 | 570722 | 2020-09-26 | Saline | Illinois | 17165 | 334 | 4 |
567480 | 567480 | 2020-09-25 | Saline | Illinois | 17165 | 319 | 4 |
392544 | 392544 | 2020-08-02 | Saline | Arkansas | 5125 | 879 | 4 |
389327 | 389327 | 2020-08-01 | Saline | Arkansas | 5125 | 868 | 4 |
386110 | 386110 | 2020-07-31 | Saline | Arkansas | 5125 | 855 | 4 |
382892 | 382892 | 2020-07-30 | Saline | Arkansas | 5125 | 827 | 4 |
379675 | 379675 | 2020-07-29 | Saline | Arkansas | 5125 | 809 | 4 |
376459 | 376459 | 2020-07-28 | Saline | Arkansas | 5125 | 798 | 4 |
377261 | 377261 | 2020-07-28 | Saline | Kansas | 20169 | 327 | 4 |
374046 | 374046 | 2020-07-27 | Saline | Kansas | 20169 | 327 | 4 |
313938 | 313938 | 2020-07-08 | Saline | Missouri | 29195 | 295 | 4 |
310767 | 310767 | 2020-07-07 | Saline | Missouri | 29195 | 290 | 4 |
307599 | 307599 | 2020-07-06 | Saline | Missouri | 29195 | 287 | 4 |
304432 | 304432 | 2020-07-05 | Saline | Missouri | 29195 | 284 | 4 |
301268 | 301268 | 2020-07-04 | Saline | Missouri | 29195 | 284 | 4 |
298105 | 298105 | 2020-07-03 | Saline | Missouri | 29195 | 284 | 4 |
294947 | 294947 | 2020-07-02 | Saline | Missouri | 29195 | 283 | 4 |
291793 | 291793 | 2020-07-01 | Saline | Missouri | 29195 | 283 | 4 |
288642 | 288642 | 2020-06-30 | Saline | Missouri | 29195 | 283 | 4 |
285492 | 285492 | 2020-06-29 | Saline | Missouri | 29195 | 283 | 4 |
282347 | 282347 | 2020-06-28 | Saline | Missouri | 29195 | 283 | 4 |
279199 | 279199 | 2020-06-27 | Saline | Missouri | 29195 | 282 | 4 |
276051 | 276051 | 2020-06-26 | Saline | Missouri | 29195 | 282 | 4 |
272908 | 272908 | 2020-06-25 | Saline | Missouri | 29195 | 282 | 4 |
269769 | 269769 | 2020-06-24 | Saline | Missouri | 29195 | 278 | 4 |
266636 | 266636 | 2020-06-23 | Saline | Missouri | 29195 | 278 | 4 |
263510 | 263510 | 2020-06-22 | Saline | Missouri | 29195 | 278 | 4 |
260382 | 260382 | 2020-06-21 | Saline | Missouri | 29195 | 278 | 4 |
257256 | 257256 | 2020-06-20 | Saline | Missouri | 29195 | 278 | 4 |
254135 | 254135 | 2020-06-19 | Saline | Missouri | 29195 | 278 | 4 |
251020 | 251020 | 2020-06-18 | Saline | Missouri | 29195 | 277 | 4 |
247907 | 247907 | 2020-06-17 | Saline | Missouri | 29195 | 274 | 4 |
244794 | 244794 | 2020-06-16 | Saline | Missouri | 29195 | 272 | 4 |
241683 | 241683 | 2020-06-15 | Saline | Missouri | 29195 | 270 | 4 |
238573 | 238573 | 2020-06-14 | Saline | Missouri | 29195 | 271 | 4 |
235466 | 235466 | 2020-06-13 | Saline | Missouri | 29195 | 271 | 4 |
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);