ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 29, fips = 18113 and state = "Indiana" 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 |
---|---|---|---|---|---|---|---|
396344 | 396344 | 2020-08-03 | Noble | Indiana | 18113 | 641 | 29 |
393128 | 393128 | 2020-08-02 | Noble | Indiana | 18113 | 639 | 29 |
389911 | 389911 | 2020-08-01 | Noble | Indiana | 18113 | 628 | 29 |
386694 | 386694 | 2020-07-31 | Noble | Indiana | 18113 | 621 | 29 |
383476 | 383476 | 2020-07-30 | Noble | Indiana | 18113 | 617 | 29 |
380259 | 380259 | 2020-07-29 | Noble | Indiana | 18113 | 612 | 29 |
377042 | 377042 | 2020-07-28 | Noble | Indiana | 18113 | 609 | 29 |
373827 | 373827 | 2020-07-27 | Noble | Indiana | 18113 | 606 | 29 |
370615 | 370615 | 2020-07-26 | Noble | Indiana | 18113 | 603 | 29 |
367405 | 367405 | 2020-07-25 | Noble | Indiana | 18113 | 598 | 29 |
364198 | 364198 | 2020-07-24 | Noble | Indiana | 18113 | 595 | 29 |
360991 | 360991 | 2020-07-23 | Noble | Indiana | 18113 | 592 | 29 |
357786 | 357786 | 2020-07-22 | Noble | Indiana | 18113 | 583 | 29 |
354584 | 354584 | 2020-07-21 | Noble | Indiana | 18113 | 578 | 29 |
351382 | 351382 | 2020-07-20 | Noble | Indiana | 18113 | 570 | 29 |
348182 | 348182 | 2020-07-19 | Noble | Indiana | 18113 | 560 | 29 |
344981 | 344981 | 2020-07-18 | Noble | Indiana | 18113 | 555 | 29 |
341781 | 341781 | 2020-07-17 | Noble | Indiana | 18113 | 550 | 29 |
338585 | 338585 | 2020-07-16 | Noble | Indiana | 18113 | 540 | 29 |
335389 | 335389 | 2020-07-15 | Noble | Indiana | 18113 | 534 | 29 |
332196 | 332196 | 2020-07-14 | Noble | Indiana | 18113 | 530 | 29 |
329009 | 329009 | 2020-07-13 | Noble | Indiana | 18113 | 528 | 29 |
325823 | 325823 | 2020-07-12 | Noble | Indiana | 18113 | 524 | 29 |
322642 | 322642 | 2020-07-11 | Noble | Indiana | 18113 | 517 | 29 |
319463 | 319463 | 2020-07-10 | Noble | Indiana | 18113 | 505 | 29 |
316290 | 316290 | 2020-07-09 | Noble | Indiana | 18113 | 495 | 29 |
313116 | 313116 | 2020-07-08 | Noble | Indiana | 18113 | 489 | 29 |
309946 | 309946 | 2020-07-07 | Noble | Indiana | 18113 | 488 | 29 |
306778 | 306778 | 2020-07-06 | Noble | Indiana | 18113 | 486 | 29 |
303613 | 303613 | 2020-07-05 | Noble | Indiana | 18113 | 481 | 29 |
300449 | 300449 | 2020-07-04 | Noble | Indiana | 18113 | 472 | 29 |
297287 | 297287 | 2020-07-03 | Noble | Indiana | 18113 | 460 | 29 |
294129 | 294129 | 2020-07-02 | Noble | Indiana | 18113 | 454 | 29 |
290975 | 290975 | 2020-07-01 | Noble | Indiana | 18113 | 450 | 29 |
287825 | 287825 | 2020-06-30 | Noble | Indiana | 18113 | 437 | 29 |
284676 | 284676 | 2020-06-29 | Noble | Indiana | 18113 | 434 | 29 |
281531 | 281531 | 2020-06-28 | Noble | Indiana | 18113 | 430 | 29 |
278383 | 278383 | 2020-06-27 | Noble | Indiana | 18113 | 420 | 29 |
275235 | 275235 | 2020-06-26 | Noble | Indiana | 18113 | 407 | 29 |
272093 | 272093 | 2020-06-25 | Noble | Indiana | 18113 | 395 | 29 |
268956 | 268956 | 2020-06-24 | Noble | Indiana | 18113 | 385 | 29 |
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);