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 |
---|---|---|---|---|---|---|---|
1193348 | 1193348 | 2021-04-06 | Tulare | California | 6107 | 49175 | 818 |
1190098 | 1190098 | 2021-04-05 | Tulare | California | 6107 | 49129 | 818 |
1186851 | 1186851 | 2021-04-04 | Tulare | California | 6107 | 49100 | 818 |
1183604 | 1183604 | 2021-04-03 | Tulare | California | 6107 | 49100 | 818 |
1180357 | 1180357 | 2021-04-02 | Tulare | California | 6107 | 49100 | 817 |
1177110 | 1177110 | 2021-04-01 | Tulare | California | 6107 | 49071 | 816 |
1173863 | 1173863 | 2021-03-31 | Tulare | California | 6107 | 49054 | 815 |
1170616 | 1170616 | 2021-03-30 | Tulare | California | 6107 | 49039 | 815 |
1167368 | 1167368 | 2021-03-29 | Tulare | California | 6107 | 49005 | 815 |
1164120 | 1164120 | 2021-03-28 | Tulare | California | 6107 | 48960 | 813 |
1160872 | 1160872 | 2021-03-27 | Tulare | California | 6107 | 48960 | 813 |
1157624 | 1157624 | 2021-03-26 | Tulare | California | 6107 | 48960 | 811 |
1154377 | 1154377 | 2021-03-25 | Tulare | California | 6107 | 48931 | 808 |
1151130 | 1151130 | 2021-03-24 | Tulare | California | 6107 | 48901 | 808 |
1147883 | 1147883 | 2021-03-23 | Tulare | California | 6107 | 48878 | 807 |
1144636 | 1144636 | 2021-03-22 | Tulare | California | 6107 | 48832 | 807 |
1141389 | 1141389 | 2021-03-21 | Tulare | California | 6107 | 48770 | 804 |
1138143 | 1138143 | 2021-03-20 | Tulare | California | 6107 | 48770 | 805 |
1134897 | 1134897 | 2021-03-19 | Tulare | California | 6107 | 48770 | 805 |
1131650 | 1131650 | 2021-03-18 | Tulare | California | 6107 | 48740 | 805 |
1128402 | 1128402 | 2021-03-17 | Tulare | California | 6107 | 48691 | 803 |
1125156 | 1125156 | 2021-03-16 | Tulare | California | 6107 | 48649 | 800 |
1121910 | 1121910 | 2021-03-15 | Tulare | California | 6107 | 48604 | 800 |
1118663 | 1118663 | 2021-03-14 | Tulare | California | 6107 | 48550 | 798 |
1115416 | 1115416 | 2021-03-13 | Tulare | California | 6107 | 48550 | 798 |
1112170 | 1112170 | 2021-03-12 | Tulare | California | 6107 | 48550 | 784 |
1108924 | 1108924 | 2021-03-11 | Tulare | California | 6107 | 48479 | 782 |
1105678 | 1105678 | 2021-03-10 | Tulare | California | 6107 | 48432 | 781 |
1102432 | 1102432 | 2021-03-09 | Tulare | California | 6107 | 48399 | 776 |
1099186 | 1099186 | 2021-03-08 | Tulare | California | 6107 | 48319 | 773 |
1095938 | 1095938 | 2021-03-07 | Tulare | California | 6107 | 48203 | 770 |
1092692 | 1092692 | 2021-03-06 | Tulare | California | 6107 | 48203 | 770 |
1089446 | 1089446 | 2021-03-05 | Tulare | California | 6107 | 48203 | 770 |
1086201 | 1086201 | 2021-03-04 | Tulare | California | 6107 | 48163 | 768 |
1082955 | 1082955 | 2021-03-03 | Tulare | California | 6107 | 48114 | 768 |
1079709 | 1079709 | 2021-03-02 | Tulare | California | 6107 | 48086 | 766 |
1076464 | 1076464 | 2021-03-01 | Tulare | California | 6107 | 48013 | 761 |
1073218 | 1073218 | 2021-02-28 | Tulare | California | 6107 | 47869 | 758 |
1069972 | 1069972 | 2021-02-27 | Tulare | California | 6107 | 47869 | 758 |
1066727 | 1066727 | 2021-02-26 | Tulare | California | 6107 | 47869 | 758 |
1063482 | 1063482 | 2021-02-25 | Tulare | California | 6107 | 47784 | 746 |
1060237 | 1060237 | 2021-02-24 | Tulare | California | 6107 | 47730 | 739 |
1056991 | 1056991 | 2021-02-23 | Tulare | California | 6107 | 47680 | 731 |
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 |
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);