ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Wayne" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635675 | 635675 | 2020-10-16 | Wayne | Indiana | 18177 | 1477 | 19 |
632429 | 632429 | 2020-10-15 | Wayne | Indiana | 18177 | 1442 | 18 |
629185 | 629185 | 2020-10-14 | Wayne | Indiana | 18177 | 1400 | 18 |
625942 | 625942 | 2020-10-13 | Wayne | Indiana | 18177 | 1384 | 18 |
622700 | 622700 | 2020-10-12 | Wayne | Indiana | 18177 | 1364 | 17 |
619456 | 619456 | 2020-10-11 | Wayne | Indiana | 18177 | 1335 | 16 |
616214 | 616214 | 2020-10-10 | Wayne | Indiana | 18177 | 1301 | 16 |
612973 | 612973 | 2020-10-09 | Wayne | Indiana | 18177 | 1281 | 16 |
609731 | 609731 | 2020-10-08 | Wayne | Indiana | 18177 | 1257 | 16 |
606488 | 606488 | 2020-10-07 | Wayne | Indiana | 18177 | 1233 | 16 |
603246 | 603246 | 2020-10-06 | Wayne | Indiana | 18177 | 1218 | 16 |
600003 | 600003 | 2020-10-05 | Wayne | Indiana | 18177 | 1211 | 16 |
596761 | 596761 | 2020-10-04 | Wayne | Indiana | 18177 | 1199 | 15 |
593519 | 593519 | 2020-10-03 | Wayne | Indiana | 18177 | 1195 | 15 |
590278 | 590278 | 2020-10-02 | Wayne | Indiana | 18177 | 1183 | 15 |
587037 | 587037 | 2020-10-01 | Wayne | Indiana | 18177 | 1153 | 15 |
583797 | 583797 | 2020-09-30 | Wayne | Indiana | 18177 | 1145 | 15 |
580558 | 580558 | 2020-09-29 | Wayne | Indiana | 18177 | 1132 | 14 |
577317 | 577317 | 2020-09-28 | Wayne | Indiana | 18177 | 1129 | 14 |
574075 | 574075 | 2020-09-27 | Wayne | Indiana | 18177 | 1128 | 14 |
570832 | 570832 | 2020-09-26 | Wayne | Indiana | 18177 | 1121 | 14 |
567590 | 567590 | 2020-09-25 | Wayne | Indiana | 18177 | 1113 | 14 |
564350 | 564350 | 2020-09-24 | Wayne | Indiana | 18177 | 1110 | 14 |
561110 | 561110 | 2020-09-23 | Wayne | Indiana | 18177 | 1106 | 14 |
557874 | 557874 | 2020-09-22 | Wayne | Indiana | 18177 | 1103 | 14 |
554637 | 554637 | 2020-09-21 | Wayne | Indiana | 18177 | 1099 | 14 |
551398 | 551398 | 2020-09-20 | Wayne | Indiana | 18177 | 1096 | 14 |
548159 | 548159 | 2020-09-19 | Wayne | Indiana | 18177 | 1094 | 14 |
544921 | 544921 | 2020-09-18 | Wayne | Indiana | 18177 | 1092 | 14 |
541685 | 541685 | 2020-09-17 | Wayne | Indiana | 18177 | 1078 | 14 |
538448 | 538448 | 2020-09-16 | Wayne | Indiana | 18177 | 1074 | 14 |
535212 | 535212 | 2020-09-15 | Wayne | Indiana | 18177 | 1073 | 14 |
531977 | 531977 | 2020-09-14 | Wayne | Indiana | 18177 | 1065 | 13 |
528740 | 528740 | 2020-09-13 | Wayne | Indiana | 18177 | 1055 | 13 |
525504 | 525504 | 2020-09-12 | Wayne | Indiana | 18177 | 1047 | 13 |
522268 | 522268 | 2020-09-11 | Wayne | Indiana | 18177 | 1035 | 13 |
519031 | 519031 | 2020-09-10 | Wayne | Indiana | 18177 | 1025 | 12 |
515796 | 515796 | 2020-09-09 | Wayne | Indiana | 18177 | 1011 | 12 |
512563 | 512563 | 2020-09-08 | Wayne | Indiana | 18177 | 995 | 11 |
509330 | 509330 | 2020-09-07 | Wayne | Indiana | 18177 | 990 | 10 |
506098 | 506098 | 2020-09-06 | Wayne | Indiana | 18177 | 981 | 10 |
502864 | 502864 | 2020-09-05 | Wayne | Indiana | 18177 | 971 | 10 |
499630 | 499630 | 2020-09-04 | Wayne | Indiana | 18177 | 938 | 10 |
496397 | 496397 | 2020-09-03 | Wayne | Indiana | 18177 | 923 | 10 |
493163 | 493163 | 2020-09-02 | Wayne | Indiana | 18177 | 907 | 10 |
489930 | 489930 | 2020-09-01 | Wayne | Indiana | 18177 | 897 | 10 |
486697 | 486697 | 2020-08-31 | Wayne | Indiana | 18177 | 887 | 10 |
483462 | 483462 | 2020-08-30 | Wayne | Indiana | 18177 | 876 | 10 |
480228 | 480228 | 2020-08-29 | Wayne | Indiana | 18177 | 865 | 10 |
476995 | 476995 | 2020-08-28 | Wayne | Indiana | 18177 | 859 | 10 |
473762 | 473762 | 2020-08-27 | Wayne | Indiana | 18177 | 855 | 10 |
470530 | 470530 | 2020-08-26 | Wayne | Indiana | 18177 | 832 | 10 |
467301 | 467301 | 2020-08-25 | Wayne | Indiana | 18177 | 829 | 10 |
464072 | 464072 | 2020-08-24 | Wayne | Indiana | 18177 | 820 | 10 |
460843 | 460843 | 2020-08-23 | Wayne | Indiana | 18177 | 802 | 10 |
457616 | 457616 | 2020-08-22 | Wayne | Indiana | 18177 | 793 | 10 |
454388 | 454388 | 2020-08-21 | Wayne | Indiana | 18177 | 784 | 10 |
451160 | 451160 | 2020-08-20 | Wayne | Indiana | 18177 | 775 | 10 |
447932 | 447932 | 2020-08-19 | Wayne | Indiana | 18177 | 763 | 10 |
444705 | 444705 | 2020-08-18 | Wayne | Indiana | 18177 | 754 | 10 |
441479 | 441479 | 2020-08-17 | Wayne | Indiana | 18177 | 746 | 10 |
438253 | 438253 | 2020-08-16 | Wayne | Indiana | 18177 | 741 | 10 |
435027 | 435027 | 2020-08-15 | Wayne | Indiana | 18177 | 735 | 10 |
431802 | 431802 | 2020-08-14 | Wayne | Indiana | 18177 | 721 | 10 |
428574 | 428574 | 2020-08-13 | Wayne | Indiana | 18177 | 710 | 10 |
425350 | 425350 | 2020-08-12 | Wayne | Indiana | 18177 | 696 | 10 |
422129 | 422129 | 2020-08-11 | Wayne | Indiana | 18177 | 669 | 10 |
418906 | 418906 | 2020-08-10 | Wayne | Indiana | 18177 | 662 | 10 |
415685 | 415685 | 2020-08-09 | Wayne | Indiana | 18177 | 662 | 10 |
412465 | 412465 | 2020-08-08 | Wayne | Indiana | 18177 | 653 | 10 |
409246 | 409246 | 2020-08-07 | Wayne | Indiana | 18177 | 639 | 10 |
406026 | 406026 | 2020-08-06 | Wayne | Indiana | 18177 | 631 | 10 |
402808 | 402808 | 2020-08-05 | Wayne | Indiana | 18177 | 622 | 10 |
399592 | 399592 | 2020-08-04 | Wayne | Indiana | 18177 | 610 | 10 |
396376 | 396376 | 2020-08-03 | Wayne | Indiana | 18177 | 593 | 9 |
393160 | 393160 | 2020-08-02 | Wayne | Indiana | 18177 | 591 | 9 |
389943 | 389943 | 2020-08-01 | Wayne | Indiana | 18177 | 588 | 9 |
386726 | 386726 | 2020-07-31 | Wayne | Indiana | 18177 | 579 | 9 |
383508 | 383508 | 2020-07-30 | Wayne | Indiana | 18177 | 560 | 8 |
380291 | 380291 | 2020-07-29 | Wayne | Indiana | 18177 | 549 | 8 |
377074 | 377074 | 2020-07-28 | Wayne | Indiana | 18177 | 522 | 8 |
373859 | 373859 | 2020-07-27 | Wayne | Indiana | 18177 | 502 | 7 |
370647 | 370647 | 2020-07-26 | Wayne | Indiana | 18177 | 494 | 7 |
367437 | 367437 | 2020-07-25 | Wayne | Indiana | 18177 | 485 | 7 |
364230 | 364230 | 2020-07-24 | Wayne | Indiana | 18177 | 471 | 7 |
361023 | 361023 | 2020-07-23 | Wayne | Indiana | 18177 | 458 | 7 |
357818 | 357818 | 2020-07-22 | Wayne | Indiana | 18177 | 436 | 7 |
354616 | 354616 | 2020-07-21 | Wayne | Indiana | 18177 | 432 | 7 |
351414 | 351414 | 2020-07-20 | Wayne | Indiana | 18177 | 408 | 6 |
348214 | 348214 | 2020-07-19 | Wayne | Indiana | 18177 | 400 | 6 |
345013 | 345013 | 2020-07-18 | Wayne | Indiana | 18177 | 395 | 6 |
341813 | 341813 | 2020-07-17 | Wayne | Indiana | 18177 | 381 | 6 |
338617 | 338617 | 2020-07-16 | Wayne | Indiana | 18177 | 378 | 6 |
335421 | 335421 | 2020-07-15 | Wayne | Indiana | 18177 | 364 | 6 |
332228 | 332228 | 2020-07-14 | Wayne | Indiana | 18177 | 360 | 6 |
329041 | 329041 | 2020-07-13 | Wayne | Indiana | 18177 | 354 | 6 |
325855 | 325855 | 2020-07-12 | Wayne | Indiana | 18177 | 346 | 6 |
322674 | 322674 | 2020-07-11 | Wayne | Indiana | 18177 | 342 | 6 |
319495 | 319495 | 2020-07-10 | Wayne | Indiana | 18177 | 340 | 6 |
316322 | 316322 | 2020-07-09 | Wayne | Indiana | 18177 | 330 | 6 |
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);