ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Jefferson" and fips = 18077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947141 | 947141 | 2021-01-20 | Jefferson | Indiana | 18077 | 2562 | 42 |
943894 | 943894 | 2021-01-19 | Jefferson | Indiana | 18077 | 2542 | 42 |
940649 | 940649 | 2021-01-18 | Jefferson | Indiana | 18077 | 2535 | 42 |
937404 | 937404 | 2021-01-17 | Jefferson | Indiana | 18077 | 2511 | 42 |
934159 | 934159 | 2021-01-16 | Jefferson | Indiana | 18077 | 2489 | 42 |
930914 | 930914 | 2021-01-15 | Jefferson | Indiana | 18077 | 2451 | 42 |
927669 | 927669 | 2021-01-14 | Jefferson | Indiana | 18077 | 2431 | 42 |
924423 | 924423 | 2021-01-13 | Jefferson | Indiana | 18077 | 2410 | 42 |
921178 | 921178 | 2021-01-12 | Jefferson | Indiana | 18077 | 2391 | 42 |
917933 | 917933 | 2021-01-11 | Jefferson | Indiana | 18077 | 2380 | 42 |
914688 | 914688 | 2021-01-10 | Jefferson | Indiana | 18077 | 2366 | 42 |
911443 | 911443 | 2021-01-09 | Jefferson | Indiana | 18077 | 2345 | 42 |
908198 | 908198 | 2021-01-08 | Jefferson | Indiana | 18077 | 2326 | 42 |
904952 | 904952 | 2021-01-07 | Jefferson | Indiana | 18077 | 2300 | 42 |
901707 | 901707 | 2021-01-06 | Jefferson | Indiana | 18077 | 2259 | 42 |
898462 | 898462 | 2021-01-05 | Jefferson | Indiana | 18077 | 2240 | 42 |
895217 | 895217 | 2021-01-04 | Jefferson | Indiana | 18077 | 2225 | 41 |
891970 | 891970 | 2021-01-03 | Jefferson | Indiana | 18077 | 2209 | 41 |
888724 | 888724 | 2021-01-02 | Jefferson | Indiana | 18077 | 2202 | 39 |
885478 | 885478 | 2021-01-01 | Jefferson | Indiana | 18077 | 2188 | 39 |
882233 | 882233 | 2020-12-31 | Jefferson | Indiana | 18077 | 2162 | 36 |
878988 | 878988 | 2020-12-30 | Jefferson | Indiana | 18077 | 2125 | 35 |
875743 | 875743 | 2020-12-29 | Jefferson | Indiana | 18077 | 2110 | 35 |
872498 | 872498 | 2020-12-28 | Jefferson | Indiana | 18077 | 2095 | 35 |
869253 | 869253 | 2020-12-27 | Jefferson | Indiana | 18077 | 2080 | 35 |
866008 | 866008 | 2020-12-26 | Jefferson | Indiana | 18077 | 2065 | 33 |
862763 | 862763 | 2020-12-25 | Jefferson | Indiana | 18077 | 2043 | 33 |
859518 | 859518 | 2020-12-24 | Jefferson | Indiana | 18077 | 2005 | 33 |
856273 | 856273 | 2020-12-23 | Jefferson | Indiana | 18077 | 1963 | 30 |
853028 | 853028 | 2020-12-22 | Jefferson | Indiana | 18077 | 1943 | 28 |
849783 | 849783 | 2020-12-21 | Jefferson | Indiana | 18077 | 1931 | 28 |
846538 | 846538 | 2020-12-20 | Jefferson | Indiana | 18077 | 1908 | 28 |
843292 | 843292 | 2020-12-19 | Jefferson | Indiana | 18077 | 1874 | 27 |
840047 | 840047 | 2020-12-18 | Jefferson | Indiana | 18077 | 1840 | 26 |
836802 | 836802 | 2020-12-17 | Jefferson | Indiana | 18077 | 1829 | 24 |
833556 | 833556 | 2020-12-16 | Jefferson | Indiana | 18077 | 1786 | 24 |
830309 | 830309 | 2020-12-15 | Jefferson | Indiana | 18077 | 1748 | 24 |
827063 | 827063 | 2020-12-14 | Jefferson | Indiana | 18077 | 1730 | 23 |
823816 | 823816 | 2020-12-13 | Jefferson | Indiana | 18077 | 1713 | 23 |
820570 | 820570 | 2020-12-12 | Jefferson | Indiana | 18077 | 1665 | 23 |
817324 | 817324 | 2020-12-11 | Jefferson | Indiana | 18077 | 1634 | 23 |
814078 | 814078 | 2020-12-10 | Jefferson | Indiana | 18077 | 1595 | 22 |
810833 | 810833 | 2020-12-09 | Jefferson | Indiana | 18077 | 1555 | 20 |
807588 | 807588 | 2020-12-08 | Jefferson | Indiana | 18077 | 1528 | 20 |
804343 | 804343 | 2020-12-07 | Jefferson | Indiana | 18077 | 1517 | 20 |
801098 | 801098 | 2020-12-06 | Jefferson | Indiana | 18077 | 1509 | 20 |
797853 | 797853 | 2020-12-05 | Jefferson | Indiana | 18077 | 1466 | 20 |
794608 | 794608 | 2020-12-04 | Jefferson | Indiana | 18077 | 1412 | 19 |
791363 | 791363 | 2020-12-03 | Jefferson | Indiana | 18077 | 1398 | 19 |
788118 | 788118 | 2020-12-02 | Jefferson | Indiana | 18077 | 1377 | 18 |
784874 | 784874 | 2020-12-01 | Jefferson | Indiana | 18077 | 1348 | 16 |
781629 | 781629 | 2020-11-30 | Jefferson | Indiana | 18077 | 1335 | 16 |
778383 | 778383 | 2020-11-29 | Jefferson | Indiana | 18077 | 1314 | 16 |
775138 | 775138 | 2020-11-28 | Jefferson | Indiana | 18077 | 1271 | 16 |
771893 | 771893 | 2020-11-27 | Jefferson | Indiana | 18077 | 1242 | 16 |
768648 | 768648 | 2020-11-26 | Jefferson | Indiana | 18077 | 1230 | 16 |
765402 | 765402 | 2020-11-25 | Jefferson | Indiana | 18077 | 1189 | 16 |
762157 | 762157 | 2020-11-24 | Jefferson | Indiana | 18077 | 1163 | 16 |
758912 | 758912 | 2020-11-23 | Jefferson | Indiana | 18077 | 1143 | 14 |
755665 | 755665 | 2020-11-22 | Jefferson | Indiana | 18077 | 1104 | 14 |
752419 | 752419 | 2020-11-21 | Jefferson | Indiana | 18077 | 1083 | 14 |
749173 | 749173 | 2020-11-20 | Jefferson | Indiana | 18077 | 1041 | 14 |
745927 | 745927 | 2020-11-19 | Jefferson | Indiana | 18077 | 1006 | 14 |
742680 | 742680 | 2020-11-18 | Jefferson | Indiana | 18077 | 907 | 14 |
739433 | 739433 | 2020-11-17 | Jefferson | Indiana | 18077 | 845 | 13 |
736189 | 736189 | 2020-11-16 | Jefferson | Indiana | 18077 | 829 | 12 |
732943 | 732943 | 2020-11-15 | Jefferson | Indiana | 18077 | 808 | 11 |
729698 | 729698 | 2020-11-14 | Jefferson | Indiana | 18077 | 781 | 11 |
726455 | 726455 | 2020-11-13 | Jefferson | Indiana | 18077 | 739 | 9 |
723212 | 723212 | 2020-11-12 | Jefferson | Indiana | 18077 | 703 | 8 |
719969 | 719969 | 2020-11-11 | Jefferson | Indiana | 18077 | 668 | 8 |
716726 | 716726 | 2020-11-10 | Jefferson | Indiana | 18077 | 637 | 6 |
713482 | 713482 | 2020-11-09 | Jefferson | Indiana | 18077 | 606 | 6 |
710238 | 710238 | 2020-11-08 | Jefferson | Indiana | 18077 | 591 | 6 |
706994 | 706994 | 2020-11-07 | Jefferson | Indiana | 18077 | 547 | 6 |
703751 | 703751 | 2020-11-06 | Jefferson | Indiana | 18077 | 523 | 6 |
700509 | 700509 | 2020-11-05 | Jefferson | Indiana | 18077 | 515 | 6 |
697265 | 697265 | 2020-11-04 | Jefferson | Indiana | 18077 | 498 | 6 |
694023 | 694023 | 2020-11-03 | Jefferson | Indiana | 18077 | 480 | 6 |
690780 | 690780 | 2020-11-02 | Jefferson | Indiana | 18077 | 468 | 5 |
687535 | 687535 | 2020-11-01 | Jefferson | Indiana | 18077 | 449 | 5 |
684291 | 684291 | 2020-10-31 | Jefferson | Indiana | 18077 | 441 | 5 |
681048 | 681048 | 2020-10-30 | Jefferson | Indiana | 18077 | 424 | 5 |
677805 | 677805 | 2020-10-29 | Jefferson | Indiana | 18077 | 417 | 5 |
674562 | 674562 | 2020-10-28 | Jefferson | Indiana | 18077 | 410 | 5 |
671320 | 671320 | 2020-10-27 | Jefferson | Indiana | 18077 | 366 | 5 |
668077 | 668077 | 2020-10-26 | Jefferson | Indiana | 18077 | 366 | 5 |
664833 | 664833 | 2020-10-25 | Jefferson | Indiana | 18077 | 353 | 5 |
661588 | 661588 | 2020-10-24 | Jefferson | Indiana | 18077 | 346 | 5 |
658344 | 658344 | 2020-10-23 | Jefferson | Indiana | 18077 | 344 | 5 |
655099 | 655099 | 2020-10-22 | Jefferson | Indiana | 18077 | 342 | 5 |
651854 | 651854 | 2020-10-21 | Jefferson | Indiana | 18077 | 331 | 5 |
648610 | 648610 | 2020-10-20 | Jefferson | Indiana | 18077 | 331 | 5 |
645365 | 645365 | 2020-10-19 | Jefferson | Indiana | 18077 | 329 | 5 |
642118 | 642118 | 2020-10-18 | Jefferson | Indiana | 18077 | 328 | 5 |
638871 | 638871 | 2020-10-17 | Jefferson | Indiana | 18077 | 326 | 4 |
635625 | 635625 | 2020-10-16 | Jefferson | Indiana | 18077 | 322 | 4 |
632379 | 632379 | 2020-10-15 | Jefferson | Indiana | 18077 | 317 | 4 |
629135 | 629135 | 2020-10-14 | Jefferson | Indiana | 18077 | 315 | 4 |
625892 | 625892 | 2020-10-13 | Jefferson | Indiana | 18077 | 309 | 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);