ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 6107 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053745 | 1053745 | 2021-02-22 | Tulare | California | 6107 | 47562 | 722 |
1050498 | 1050498 | 2021-02-21 | Tulare | California | 6107 | 47399 | 720 |
1047251 | 1047251 | 2021-02-20 | Tulare | California | 6107 | 47399 | 720 |
1044006 | 1044006 | 2021-02-19 | Tulare | California | 6107 | 47399 | 720 |
1040761 | 1040761 | 2021-02-18 | Tulare | California | 6107 | 47311 | 717 |
1037516 | 1037516 | 2021-02-17 | Tulare | California | 6107 | 46444 | 697 |
1034271 | 1034271 | 2021-02-16 | Tulare | California | 6107 | 46344 | 691 |
1031025 | 1031025 | 2021-02-15 | Tulare | California | 6107 | 46263 | 691 |
1027778 | 1027778 | 2021-02-14 | Tulare | California | 6107 | 46162 | 691 |
1024533 | 1024533 | 2021-02-13 | Tulare | California | 6107 | 46016 | 691 |
1021288 | 1021288 | 2021-02-12 | Tulare | California | 6107 | 45897 | 684 |
1018043 | 1018043 | 2021-02-11 | Tulare | California | 6107 | 45782 | 672 |
1014798 | 1014798 | 2021-02-10 | Tulare | California | 6107 | 45704 | 661 |
1011553 | 1011553 | 2021-02-09 | Tulare | California | 6107 | 45617 | 651 |
1008307 | 1008307 | 2021-02-08 | Tulare | California | 6107 | 45520 | 645 |
1005061 | 1005061 | 2021-02-07 | Tulare | California | 6107 | 45349 | 645 |
1001815 | 1001815 | 2021-02-06 | Tulare | California | 6107 | 45138 | 645 |
998569 | 998569 | 2021-02-05 | Tulare | California | 6107 | 44983 | 632 |
995323 | 995323 | 2021-02-04 | Tulare | California | 6107 | 44838 | 619 |
992077 | 992077 | 2021-02-03 | Tulare | California | 6107 | 44720 | 606 |
988831 | 988831 | 2021-02-02 | Tulare | California | 6107 | 44569 | 598 |
985584 | 985584 | 2021-02-01 | Tulare | California | 6107 | 44440 | 588 |
982337 | 982337 | 2021-01-31 | Tulare | California | 6107 | 44203 | 588 |
979091 | 979091 | 2021-01-30 | Tulare | California | 6107 | 43925 | 588 |
975846 | 975846 | 2021-01-29 | Tulare | California | 6107 | 43742 | 573 |
972601 | 972601 | 2021-01-28 | Tulare | California | 6107 | 43574 | 542 |
969356 | 969356 | 2021-01-27 | Tulare | California | 6107 | 43574 | 542 |
966112 | 966112 | 2021-01-26 | Tulare | California | 6107 | 43574 | 542 |
962867 | 962867 | 2021-01-25 | Tulare | California | 6107 | 43574 | 542 |
959622 | 959622 | 2021-01-24 | Tulare | California | 6107 | 42759 | 531 |
956376 | 956376 | 2021-01-23 | Tulare | California | 6107 | 42759 | 531 |
953131 | 953131 | 2021-01-22 | Tulare | California | 6107 | 42759 | 531 |
949886 | 949886 | 2021-01-21 | Tulare | California | 6107 | 42541 | 529 |
946640 | 946640 | 2021-01-20 | Tulare | California | 6107 | 42186 | 515 |
943393 | 943393 | 2021-01-19 | Tulare | California | 6107 | 41867 | 506 |
940148 | 940148 | 2021-01-18 | Tulare | California | 6107 | 41016 | 501 |
936903 | 936903 | 2021-01-17 | Tulare | California | 6107 | 40655 | 501 |
933658 | 933658 | 2021-01-16 | Tulare | California | 6107 | 40176 | 501 |
930413 | 930413 | 2021-01-15 | Tulare | California | 6107 | 40176 | 501 |
927168 | 927168 | 2021-01-14 | Tulare | California | 6107 | 39723 | 494 |
923922 | 923922 | 2021-01-13 | Tulare | California | 6107 | 39347 | 482 |
920677 | 920677 | 2021-01-12 | Tulare | California | 6107 | 38909 | 474 |
917432 | 917432 | 2021-01-11 | Tulare | California | 6107 | 38284 | 464 |
914187 | 914187 | 2021-01-10 | Tulare | California | 6107 | 37684 | 455 |
910942 | 910942 | 2021-01-09 | Tulare | California | 6107 | 36946 | 455 |
907697 | 907697 | 2021-01-08 | Tulare | California | 6107 | 36936 | 455 |
904451 | 904451 | 2021-01-07 | Tulare | California | 6107 | 36214 | 442 |
901206 | 901206 | 2021-01-06 | Tulare | California | 6107 | 35890 | 433 |
897961 | 897961 | 2021-01-05 | Tulare | California | 6107 | 35286 | 421 |
894716 | 894716 | 2021-01-04 | Tulare | California | 6107 | 34742 | 419 |
891469 | 891469 | 2021-01-03 | Tulare | California | 6107 | 34479 | 406 |
888222 | 888222 | 2021-01-02 | Tulare | California | 6107 | 33994 | 406 |
884977 | 884977 | 2021-01-01 | Tulare | California | 6107 | 33443 | 406 |
881732 | 881732 | 2020-12-31 | Tulare | California | 6107 | 33443 | 406 |
878487 | 878487 | 2020-12-30 | Tulare | California | 6107 | 33125 | 399 |
875242 | 875242 | 2020-12-29 | Tulare | California | 6107 | 32578 | 389 |
871997 | 871997 | 2020-12-28 | Tulare | California | 6107 | 32109 | 386 |
868752 | 868752 | 2020-12-27 | Tulare | California | 6107 | 31665 | 373 |
865507 | 865507 | 2020-12-26 | Tulare | California | 6107 | 31323 | 373 |
862262 | 862262 | 2020-12-25 | Tulare | California | 6107 | 30827 | 373 |
859017 | 859017 | 2020-12-24 | Tulare | California | 6107 | 30422 | 373 |
855772 | 855772 | 2020-12-23 | Tulare | California | 6107 | 30422 | 373 |
852527 | 852527 | 2020-12-22 | Tulare | California | 6107 | 30051 | 360 |
849282 | 849282 | 2020-12-21 | Tulare | California | 6107 | 29364 | 354 |
846037 | 846037 | 2020-12-20 | Tulare | California | 6107 | 28734 | 353 |
842791 | 842791 | 2020-12-19 | Tulare | California | 6107 | 28322 | 353 |
839546 | 839546 | 2020-12-18 | Tulare | California | 6107 | 28130 | 353 |
836301 | 836301 | 2020-12-17 | Tulare | California | 6107 | 27790 | 346 |
833055 | 833055 | 2020-12-16 | Tulare | California | 6107 | 27390 | 339 |
829808 | 829808 | 2020-12-15 | Tulare | California | 6107 | 26669 | 332 |
826562 | 826562 | 2020-12-14 | Tulare | California | 6107 | 25707 | 330 |
823315 | 823315 | 2020-12-13 | Tulare | California | 6107 | 25333 | 327 |
820069 | 820069 | 2020-12-12 | Tulare | California | 6107 | 25042 | 327 |
816823 | 816823 | 2020-12-11 | Tulare | California | 6107 | 25042 | 327 |
813577 | 813577 | 2020-12-10 | Tulare | California | 6107 | 24624 | 326 |
810333 | 810333 | 2020-12-09 | Tulare | California | 6107 | 24239 | 323 |
807088 | 807088 | 2020-12-08 | Tulare | California | 6107 | 23662 | 319 |
803843 | 803843 | 2020-12-07 | Tulare | California | 6107 | 22857 | 317 |
800598 | 800598 | 2020-12-06 | Tulare | California | 6107 | 22660 | 317 |
797353 | 797353 | 2020-12-05 | Tulare | California | 6107 | 22386 | 317 |
794108 | 794108 | 2020-12-04 | Tulare | California | 6107 | 22386 | 317 |
790863 | 790863 | 2020-12-03 | Tulare | California | 6107 | 22088 | 315 |
787618 | 787618 | 2020-12-02 | Tulare | California | 6107 | 21778 | 314 |
784374 | 784374 | 2020-12-01 | Tulare | California | 6107 | 21332 | 312 |
781129 | 781129 | 2020-11-30 | Tulare | California | 6107 | 20913 | 312 |
777883 | 777883 | 2020-11-29 | Tulare | California | 6107 | 20701 | 308 |
774638 | 774638 | 2020-11-28 | Tulare | California | 6107 | 20634 | 308 |
771393 | 771393 | 2020-11-27 | Tulare | California | 6107 | 20649 | 308 |
768148 | 768148 | 2020-11-26 | Tulare | California | 6107 | 20550 | 308 |
764902 | 764902 | 2020-11-25 | Tulare | California | 6107 | 20550 | 308 |
761657 | 761657 | 2020-11-24 | Tulare | California | 6107 | 20352 | 305 |
758412 | 758412 | 2020-11-23 | Tulare | California | 6107 | 19882 | 304 |
755165 | 755165 | 2020-11-22 | Tulare | California | 6107 | 19752 | 303 |
751919 | 751919 | 2020-11-21 | Tulare | California | 6107 | 19673 | 303 |
748673 | 748673 | 2020-11-20 | Tulare | California | 6107 | 19673 | 303 |
745427 | 745427 | 2020-11-19 | Tulare | California | 6107 | 19553 | 303 |
742180 | 742180 | 2020-11-18 | Tulare | California | 6107 | 19461 | 301 |
738933 | 738933 | 2020-11-17 | Tulare | California | 6107 | 19320 | 301 |
735689 | 735689 | 2020-11-16 | Tulare | California | 6107 | 19054 | 300 |
732443 | 732443 | 2020-11-15 | Tulare | California | 6107 | 18896 | 300 |
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);