ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 22, fips = 18107 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 |
---|---|---|---|---|---|---|---|
580523 | 580523 | 2020-09-29 | Montgomery | Indiana | 18107 | 515 | 22 |
577282 | 577282 | 2020-09-28 | Montgomery | Indiana | 18107 | 513 | 22 |
574040 | 574040 | 2020-09-27 | Montgomery | Indiana | 18107 | 513 | 22 |
570797 | 570797 | 2020-09-26 | Montgomery | Indiana | 18107 | 513 | 22 |
567555 | 567555 | 2020-09-25 | Montgomery | Indiana | 18107 | 510 | 22 |
564315 | 564315 | 2020-09-24 | Montgomery | Indiana | 18107 | 509 | 22 |
561075 | 561075 | 2020-09-23 | Montgomery | Indiana | 18107 | 507 | 22 |
557839 | 557839 | 2020-09-22 | Montgomery | Indiana | 18107 | 507 | 22 |
554602 | 554602 | 2020-09-21 | Montgomery | Indiana | 18107 | 507 | 22 |
551363 | 551363 | 2020-09-20 | Montgomery | Indiana | 18107 | 507 | 22 |
548124 | 548124 | 2020-09-19 | Montgomery | Indiana | 18107 | 504 | 22 |
544886 | 544886 | 2020-09-18 | Montgomery | Indiana | 18107 | 497 | 22 |
541650 | 541650 | 2020-09-17 | Montgomery | Indiana | 18107 | 496 | 22 |
538413 | 538413 | 2020-09-16 | Montgomery | Indiana | 18107 | 495 | 22 |
535177 | 535177 | 2020-09-15 | Montgomery | Indiana | 18107 | 495 | 22 |
531942 | 531942 | 2020-09-14 | Montgomery | Indiana | 18107 | 495 | 22 |
528705 | 528705 | 2020-09-13 | Montgomery | Indiana | 18107 | 494 | 22 |
525469 | 525469 | 2020-09-12 | Montgomery | Indiana | 18107 | 492 | 22 |
522233 | 522233 | 2020-09-11 | Montgomery | Indiana | 18107 | 487 | 22 |
518996 | 518996 | 2020-09-10 | Montgomery | Indiana | 18107 | 476 | 22 |
515761 | 515761 | 2020-09-09 | Montgomery | Indiana | 18107 | 474 | 22 |
512528 | 512528 | 2020-09-08 | Montgomery | Indiana | 18107 | 471 | 22 |
509295 | 509295 | 2020-09-07 | Montgomery | Indiana | 18107 | 470 | 22 |
506063 | 506063 | 2020-09-06 | Montgomery | Indiana | 18107 | 467 | 22 |
502829 | 502829 | 2020-09-05 | Montgomery | Indiana | 18107 | 465 | 22 |
499595 | 499595 | 2020-09-04 | Montgomery | Indiana | 18107 | 457 | 22 |
496362 | 496362 | 2020-09-03 | Montgomery | Indiana | 18107 | 454 | 22 |
493128 | 493128 | 2020-09-02 | Montgomery | Indiana | 18107 | 448 | 22 |
489895 | 489895 | 2020-09-01 | Montgomery | Indiana | 18107 | 428 | 22 |
486662 | 486662 | 2020-08-31 | Montgomery | Indiana | 18107 | 427 | 22 |
483427 | 483427 | 2020-08-30 | Montgomery | Indiana | 18107 | 425 | 22 |
480193 | 480193 | 2020-08-29 | Montgomery | Indiana | 18107 | 420 | 22 |
476960 | 476960 | 2020-08-28 | Montgomery | Indiana | 18107 | 398 | 22 |
473727 | 473727 | 2020-08-27 | Montgomery | Indiana | 18107 | 395 | 22 |
470495 | 470495 | 2020-08-26 | Montgomery | Indiana | 18107 | 393 | 22 |
467266 | 467266 | 2020-08-25 | Montgomery | Indiana | 18107 | 390 | 22 |
464037 | 464037 | 2020-08-24 | Montgomery | Indiana | 18107 | 390 | 22 |
460808 | 460808 | 2020-08-23 | Montgomery | Indiana | 18107 | 388 | 22 |
457581 | 457581 | 2020-08-22 | Montgomery | Indiana | 18107 | 386 | 22 |
454353 | 454353 | 2020-08-21 | Montgomery | Indiana | 18107 | 381 | 22 |
451125 | 451125 | 2020-08-20 | Montgomery | Indiana | 18107 | 378 | 22 |
447897 | 447897 | 2020-08-19 | Montgomery | Indiana | 18107 | 374 | 22 |
444670 | 444670 | 2020-08-18 | Montgomery | Indiana | 18107 | 372 | 22 |
441444 | 441444 | 2020-08-17 | Montgomery | Indiana | 18107 | 372 | 22 |
438218 | 438218 | 2020-08-16 | Montgomery | Indiana | 18107 | 371 | 22 |
434992 | 434992 | 2020-08-15 | Montgomery | Indiana | 18107 | 370 | 22 |
431767 | 431767 | 2020-08-14 | Montgomery | Indiana | 18107 | 369 | 22 |
428539 | 428539 | 2020-08-13 | Montgomery | Indiana | 18107 | 365 | 22 |
425315 | 425315 | 2020-08-12 | Montgomery | Indiana | 18107 | 362 | 22 |
422094 | 422094 | 2020-08-11 | Montgomery | Indiana | 18107 | 361 | 22 |
418871 | 418871 | 2020-08-10 | Montgomery | Indiana | 18107 | 356 | 22 |
415650 | 415650 | 2020-08-09 | Montgomery | Indiana | 18107 | 356 | 22 |
412430 | 412430 | 2020-08-08 | Montgomery | Indiana | 18107 | 354 | 22 |
409211 | 409211 | 2020-08-07 | Montgomery | Indiana | 18107 | 350 | 22 |
405991 | 405991 | 2020-08-06 | Montgomery | Indiana | 18107 | 348 | 22 |
402773 | 402773 | 2020-08-05 | Montgomery | Indiana | 18107 | 345 | 22 |
399557 | 399557 | 2020-08-04 | Montgomery | Indiana | 18107 | 344 | 22 |
396341 | 396341 | 2020-08-03 | Montgomery | Indiana | 18107 | 345 | 22 |
393125 | 393125 | 2020-08-02 | Montgomery | Indiana | 18107 | 340 | 22 |
389908 | 389908 | 2020-08-01 | Montgomery | Indiana | 18107 | 338 | 22 |
386691 | 386691 | 2020-07-31 | Montgomery | Indiana | 18107 | 336 | 22 |
383473 | 383473 | 2020-07-30 | Montgomery | Indiana | 18107 | 328 | 22 |
380256 | 380256 | 2020-07-29 | Montgomery | Indiana | 18107 | 326 | 22 |
377039 | 377039 | 2020-07-28 | Montgomery | Indiana | 18107 | 323 | 22 |
373824 | 373824 | 2020-07-27 | Montgomery | Indiana | 18107 | 321 | 22 |
370612 | 370612 | 2020-07-26 | Montgomery | Indiana | 18107 | 319 | 22 |
367402 | 367402 | 2020-07-25 | Montgomery | Indiana | 18107 | 317 | 22 |
364195 | 364195 | 2020-07-24 | Montgomery | Indiana | 18107 | 312 | 22 |
360988 | 360988 | 2020-07-23 | Montgomery | Indiana | 18107 | 310 | 22 |
357783 | 357783 | 2020-07-22 | Montgomery | Indiana | 18107 | 309 | 22 |
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);