ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Marshall" and fips = 18099 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
300442 | 300442 | 2020-07-04 | Marshall | Indiana | 18099 | 482 | 3 |
306771 | 306771 | 2020-07-06 | Marshall | Indiana | 18099 | 490 | 4 |
303606 | 303606 | 2020-07-05 | Marshall | Indiana | 18099 | 492 | 4 |
309939 | 309939 | 2020-07-07 | Marshall | Indiana | 18099 | 492 | 6 |
313109 | 313109 | 2020-07-08 | Marshall | Indiana | 18099 | 501 | 6 |
316283 | 316283 | 2020-07-09 | Marshall | Indiana | 18099 | 521 | 7 |
319456 | 319456 | 2020-07-10 | Marshall | Indiana | 18099 | 530 | 8 |
322635 | 322635 | 2020-07-11 | Marshall | Indiana | 18099 | 544 | 9 |
325816 | 325816 | 2020-07-12 | Marshall | Indiana | 18099 | 557 | 9 |
329002 | 329002 | 2020-07-13 | Marshall | Indiana | 18099 | 570 | 11 |
332189 | 332189 | 2020-07-14 | Marshall | Indiana | 18099 | 574 | 12 |
335382 | 335382 | 2020-07-15 | Marshall | Indiana | 18099 | 601 | 12 |
338578 | 338578 | 2020-07-16 | Marshall | Indiana | 18099 | 623 | 12 |
341774 | 341774 | 2020-07-17 | Marshall | Indiana | 18099 | 636 | 12 |
344974 | 344974 | 2020-07-18 | Marshall | Indiana | 18099 | 645 | 13 |
348175 | 348175 | 2020-07-19 | Marshall | Indiana | 18099 | 659 | 13 |
351375 | 351375 | 2020-07-20 | Marshall | Indiana | 18099 | 663 | 13 |
354577 | 354577 | 2020-07-21 | Marshall | Indiana | 18099 | 671 | 14 |
357779 | 357779 | 2020-07-22 | Marshall | Indiana | 18099 | 682 | 16 |
360984 | 360984 | 2020-07-23 | Marshall | Indiana | 18099 | 686 | 18 |
364191 | 364191 | 2020-07-24 | Marshall | Indiana | 18099 | 695 | 18 |
367398 | 367398 | 2020-07-25 | Marshall | Indiana | 18099 | 700 | 19 |
370608 | 370608 | 2020-07-26 | Marshall | Indiana | 18099 | 702 | 19 |
373820 | 373820 | 2020-07-27 | Marshall | Indiana | 18099 | 712 | 19 |
377035 | 377035 | 2020-07-28 | Marshall | Indiana | 18099 | 718 | 20 |
380252 | 380252 | 2020-07-29 | Marshall | Indiana | 18099 | 720 | 20 |
383469 | 383469 | 2020-07-30 | Marshall | Indiana | 18099 | 722 | 21 |
386687 | 386687 | 2020-07-31 | Marshall | Indiana | 18099 | 732 | 22 |
389904 | 389904 | 2020-08-01 | Marshall | Indiana | 18099 | 739 | 22 |
393121 | 393121 | 2020-08-02 | Marshall | Indiana | 18099 | 742 | 22 |
396337 | 396337 | 2020-08-03 | Marshall | Indiana | 18099 | 742 | 22 |
399553 | 399553 | 2020-08-04 | Marshall | Indiana | 18099 | 744 | 22 |
402769 | 402769 | 2020-08-05 | Marshall | Indiana | 18099 | 752 | 22 |
405987 | 405987 | 2020-08-06 | Marshall | Indiana | 18099 | 758 | 22 |
409207 | 409207 | 2020-08-07 | Marshall | Indiana | 18099 | 771 | 22 |
412426 | 412426 | 2020-08-08 | Marshall | Indiana | 18099 | 774 | 22 |
415646 | 415646 | 2020-08-09 | Marshall | Indiana | 18099 | 784 | 22 |
418867 | 418867 | 2020-08-10 | Marshall | Indiana | 18099 | 790 | 22 |
422090 | 422090 | 2020-08-11 | Marshall | Indiana | 18099 | 793 | 23 |
425311 | 425311 | 2020-08-12 | Marshall | Indiana | 18099 | 794 | 23 |
428535 | 428535 | 2020-08-13 | Marshall | Indiana | 18099 | 801 | 23 |
431763 | 431763 | 2020-08-14 | Marshall | Indiana | 18099 | 805 | 23 |
434988 | 434988 | 2020-08-15 | Marshall | Indiana | 18099 | 807 | 23 |
438214 | 438214 | 2020-08-16 | Marshall | Indiana | 18099 | 808 | 23 |
441440 | 441440 | 2020-08-17 | Marshall | Indiana | 18099 | 814 | 23 |
444666 | 444666 | 2020-08-18 | Marshall | Indiana | 18099 | 814 | 23 |
447893 | 447893 | 2020-08-19 | Marshall | Indiana | 18099 | 821 | 23 |
451121 | 451121 | 2020-08-20 | Marshall | Indiana | 18099 | 827 | 23 |
454349 | 454349 | 2020-08-21 | Marshall | Indiana | 18099 | 848 | 23 |
457577 | 457577 | 2020-08-22 | Marshall | Indiana | 18099 | 851 | 23 |
460804 | 460804 | 2020-08-23 | Marshall | Indiana | 18099 | 853 | 23 |
464033 | 464033 | 2020-08-24 | Marshall | Indiana | 18099 | 858 | 23 |
467262 | 467262 | 2020-08-25 | Marshall | Indiana | 18099 | 858 | 23 |
470491 | 470491 | 2020-08-26 | Marshall | Indiana | 18099 | 864 | 23 |
473723 | 473723 | 2020-08-27 | Marshall | Indiana | 18099 | 871 | 23 |
476956 | 476956 | 2020-08-28 | Marshall | Indiana | 18099 | 877 | 23 |
480189 | 480189 | 2020-08-29 | Marshall | Indiana | 18099 | 884 | 23 |
483423 | 483423 | 2020-08-30 | Marshall | Indiana | 18099 | 888 | 23 |
486658 | 486658 | 2020-08-31 | Marshall | Indiana | 18099 | 895 | 23 |
489891 | 489891 | 2020-09-01 | Marshall | Indiana | 18099 | 895 | 23 |
493124 | 493124 | 2020-09-02 | Marshall | Indiana | 18099 | 901 | 23 |
496358 | 496358 | 2020-09-03 | Marshall | Indiana | 18099 | 910 | 23 |
499591 | 499591 | 2020-09-04 | Marshall | Indiana | 18099 | 916 | 23 |
502825 | 502825 | 2020-09-05 | Marshall | Indiana | 18099 | 926 | 23 |
506059 | 506059 | 2020-09-06 | Marshall | Indiana | 18099 | 927 | 23 |
509291 | 509291 | 2020-09-07 | Marshall | Indiana | 18099 | 931 | 23 |
512524 | 512524 | 2020-09-08 | Marshall | Indiana | 18099 | 934 | 23 |
515757 | 515757 | 2020-09-09 | Marshall | Indiana | 18099 | 938 | 23 |
518992 | 518992 | 2020-09-10 | Marshall | Indiana | 18099 | 942 | 23 |
522229 | 522229 | 2020-09-11 | Marshall | Indiana | 18099 | 948 | 23 |
525465 | 525465 | 2020-09-12 | Marshall | Indiana | 18099 | 951 | 23 |
528701 | 528701 | 2020-09-13 | Marshall | Indiana | 18099 | 958 | 23 |
531938 | 531938 | 2020-09-14 | Marshall | Indiana | 18099 | 965 | 23 |
535173 | 535173 | 2020-09-15 | Marshall | Indiana | 18099 | 966 | 23 |
538409 | 538409 | 2020-09-16 | Marshall | Indiana | 18099 | 972 | 23 |
541646 | 541646 | 2020-09-17 | Marshall | Indiana | 18099 | 974 | 23 |
544882 | 544882 | 2020-09-18 | Marshall | Indiana | 18099 | 975 | 24 |
548120 | 548120 | 2020-09-19 | Marshall | Indiana | 18099 | 980 | 24 |
551359 | 551359 | 2020-09-20 | Marshall | Indiana | 18099 | 985 | 24 |
554598 | 554598 | 2020-09-21 | Marshall | Indiana | 18099 | 988 | 24 |
557835 | 557835 | 2020-09-22 | Marshall | Indiana | 18099 | 989 | 24 |
561071 | 561071 | 2020-09-23 | Marshall | Indiana | 18099 | 994 | 24 |
564311 | 564311 | 2020-09-24 | Marshall | Indiana | 18099 | 997 | 24 |
570793 | 570793 | 2020-09-26 | Marshall | Indiana | 18099 | 1007 | 24 |
567551 | 567551 | 2020-09-25 | Marshall | Indiana | 18099 | 1008 | 24 |
574036 | 574036 | 2020-09-27 | Marshall | Indiana | 18099 | 1012 | 24 |
577278 | 577278 | 2020-09-28 | Marshall | Indiana | 18099 | 1015 | 24 |
580519 | 580519 | 2020-09-29 | Marshall | Indiana | 18099 | 1021 | 24 |
583758 | 583758 | 2020-09-30 | Marshall | Indiana | 18099 | 1029 | 24 |
586998 | 586998 | 2020-10-01 | Marshall | Indiana | 18099 | 1030 | 24 |
590239 | 590239 | 2020-10-02 | Marshall | Indiana | 18099 | 1045 | 24 |
593480 | 593480 | 2020-10-03 | Marshall | Indiana | 18099 | 1053 | 25 |
596722 | 596722 | 2020-10-04 | Marshall | Indiana | 18099 | 1068 | 25 |
599964 | 599964 | 2020-10-05 | Marshall | Indiana | 18099 | 1072 | 25 |
603207 | 603207 | 2020-10-06 | Marshall | Indiana | 18099 | 1077 | 25 |
606449 | 606449 | 2020-10-07 | Marshall | Indiana | 18099 | 1091 | 26 |
609692 | 609692 | 2020-10-08 | Marshall | Indiana | 18099 | 1105 | 26 |
612934 | 612934 | 2020-10-09 | Marshall | Indiana | 18099 | 1123 | 26 |
616175 | 616175 | 2020-10-10 | Marshall | Indiana | 18099 | 1137 | 26 |
619417 | 619417 | 2020-10-11 | Marshall | Indiana | 18099 | 1157 | 26 |
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);