ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 6111 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193350 | 1193350 | 2021-04-06 | Ventura | California | 6111 | 79830 | 987 |
1190100 | 1190100 | 2021-04-05 | Ventura | California | 6111 | 79820 | 986 |
1186853 | 1186853 | 2021-04-04 | Ventura | California | 6111 | 79774 | 986 |
1183606 | 1183606 | 2021-04-03 | Ventura | California | 6111 | 79774 | 986 |
1180359 | 1180359 | 2021-04-02 | Ventura | California | 6111 | 79774 | 986 |
1177112 | 1177112 | 2021-04-01 | Ventura | California | 6111 | 79716 | 984 |
1173865 | 1173865 | 2021-03-31 | Ventura | California | 6111 | 79668 | 981 |
1170618 | 1170618 | 2021-03-30 | Ventura | California | 6111 | 79621 | 974 |
1167370 | 1167370 | 2021-03-29 | Ventura | California | 6111 | 79588 | 972 |
1164122 | 1164122 | 2021-03-28 | Ventura | California | 6111 | 79472 | 969 |
1160874 | 1160874 | 2021-03-27 | Ventura | California | 6111 | 79472 | 969 |
1157626 | 1157626 | 2021-03-26 | Ventura | California | 6111 | 79472 | 969 |
1154379 | 1154379 | 2021-03-25 | Ventura | California | 6111 | 79390 | 966 |
1151132 | 1151132 | 2021-03-24 | Ventura | California | 6111 | 79309 | 961 |
1147885 | 1147885 | 2021-03-23 | Ventura | California | 6111 | 79243 | 957 |
1144638 | 1144638 | 2021-03-22 | Ventura | California | 6111 | 79219 | 950 |
1141391 | 1141391 | 2021-03-21 | Ventura | California | 6111 | 79090 | 943 |
1138145 | 1138145 | 2021-03-20 | Ventura | California | 6111 | 79090 | 943 |
1134899 | 1134899 | 2021-03-19 | Ventura | California | 6111 | 79090 | 943 |
1131652 | 1131652 | 2021-03-18 | Ventura | California | 6111 | 79028 | 940 |
1128404 | 1128404 | 2021-03-17 | Ventura | California | 6111 | 78968 | 937 |
1125158 | 1125158 | 2021-03-16 | Ventura | California | 6111 | 78871 | 934 |
1121912 | 1121912 | 2021-03-15 | Ventura | California | 6111 | 78792 | 932 |
1118665 | 1118665 | 2021-03-14 | Ventura | California | 6111 | 78713 | 925 |
1115418 | 1115418 | 2021-03-13 | Ventura | California | 6111 | 78713 | 925 |
1112172 | 1112172 | 2021-03-12 | Ventura | California | 6111 | 78697 | 917 |
1108926 | 1108926 | 2021-03-11 | Ventura | California | 6111 | 78609 | 917 |
1105680 | 1105680 | 2021-03-10 | Ventura | California | 6111 | 78526 | 909 |
1102434 | 1102434 | 2021-03-09 | Ventura | California | 6111 | 78526 | 901 |
1099188 | 1099188 | 2021-03-08 | Ventura | California | 6111 | 78487 | 895 |
1095940 | 1095940 | 2021-03-07 | Ventura | California | 6111 | 78439 | 883 |
1092694 | 1092694 | 2021-03-06 | Ventura | California | 6111 | 78368 | 883 |
1089448 | 1089448 | 2021-03-05 | Ventura | California | 6111 | 78184 | 883 |
1086203 | 1086203 | 2021-03-04 | Ventura | California | 6111 | 78057 | 876 |
1082957 | 1082957 | 2021-03-03 | Ventura | California | 6111 | 77952 | 870 |
1079711 | 1079711 | 2021-03-02 | Ventura | California | 6111 | 77849 | 858 |
1076466 | 1076466 | 2021-03-01 | Ventura | California | 6111 | 77749 | 852 |
1073220 | 1073220 | 2021-02-28 | Ventura | California | 6111 | 77623 | 844 |
1069974 | 1069974 | 2021-02-27 | Ventura | California | 6111 | 77534 | 844 |
1066729 | 1066729 | 2021-02-26 | Ventura | California | 6111 | 77395 | 844 |
1063484 | 1063484 | 2021-02-25 | Ventura | California | 6111 | 77238 | 834 |
1060239 | 1060239 | 2021-02-24 | Ventura | California | 6111 | 77093 | 820 |
1056993 | 1056993 | 2021-02-23 | Ventura | California | 6111 | 76947 | 805 |
1053747 | 1053747 | 2021-02-22 | Ventura | California | 6111 | 76862 | 794 |
1050500 | 1050500 | 2021-02-21 | Ventura | California | 6111 | 76757 | 782 |
1047253 | 1047253 | 2021-02-20 | Ventura | California | 6111 | 76582 | 782 |
1044008 | 1044008 | 2021-02-19 | Ventura | California | 6111 | 76442 | 782 |
1040763 | 1040763 | 2021-02-18 | Ventura | California | 6111 | 76234 | 775 |
1037518 | 1037518 | 2021-02-17 | Ventura | California | 6111 | 76043 | 767 |
1034273 | 1034273 | 2021-02-16 | Ventura | California | 6111 | 75889 | 751 |
1031027 | 1031027 | 2021-02-15 | Ventura | California | 6111 | 75742 | 732 |
1027780 | 1027780 | 2021-02-14 | Ventura | California | 6111 | 75481 | 732 |
1024535 | 1024535 | 2021-02-13 | Ventura | California | 6111 | 75210 | 732 |
1021290 | 1021290 | 2021-02-12 | Ventura | California | 6111 | 74959 | 732 |
1018045 | 1018045 | 2021-02-11 | Ventura | California | 6111 | 74651 | 714 |
1014800 | 1014800 | 2021-02-10 | Ventura | California | 6111 | 74333 | 696 |
1011555 | 1011555 | 2021-02-09 | Ventura | California | 6111 | 74068 | 683 |
1008309 | 1008309 | 2021-02-08 | Ventura | California | 6111 | 73759 | 678 |
1005063 | 1005063 | 2021-02-07 | Ventura | California | 6111 | 73431 | 664 |
1001817 | 1001817 | 2021-02-06 | Ventura | California | 6111 | 72953 | 664 |
998571 | 998571 | 2021-02-05 | Ventura | California | 6111 | 72595 | 664 |
995325 | 995325 | 2021-02-04 | Ventura | California | 6111 | 72124 | 648 |
992079 | 992079 | 2021-02-03 | Ventura | California | 6111 | 71557 | 634 |
988833 | 988833 | 2021-02-02 | Ventura | California | 6111 | 71212 | 629 |
985586 | 985586 | 2021-02-01 | Ventura | California | 6111 | 70799 | 618 |
982339 | 982339 | 2021-01-31 | Ventura | California | 6111 | 69931 | 598 |
979093 | 979093 | 2021-01-30 | Ventura | California | 6111 | 69511 | 598 |
975848 | 975848 | 2021-01-29 | Ventura | California | 6111 | 69050 | 598 |
972603 | 972603 | 2021-01-28 | Ventura | California | 6111 | 68397 | 579 |
969358 | 969358 | 2021-01-27 | Ventura | California | 6111 | 67533 | 564 |
966114 | 966114 | 2021-01-26 | Ventura | California | 6111 | 67066 | 546 |
962869 | 962869 | 2021-01-25 | Ventura | California | 6111 | 66402 | 525 |
959624 | 959624 | 2021-01-24 | Ventura | California | 6111 | 65581 | 507 |
956378 | 956378 | 2021-01-23 | Ventura | California | 6111 | 64404 | 507 |
953133 | 953133 | 2021-01-22 | Ventura | California | 6111 | 63995 | 507 |
949888 | 949888 | 2021-01-21 | Ventura | California | 6111 | 63608 | 491 |
946642 | 946642 | 2021-01-20 | Ventura | California | 6111 | 62774 | 462 |
943395 | 943395 | 2021-01-19 | Ventura | California | 6111 | 62101 | 436 |
940150 | 940150 | 2021-01-18 | Ventura | California | 6111 | 61257 | 412 |
936905 | 936905 | 2021-01-17 | Ventura | California | 6111 | 60368 | 412 |
933660 | 933660 | 2021-01-16 | Ventura | California | 6111 | 59061 | 412 |
930415 | 930415 | 2021-01-15 | Ventura | California | 6111 | 57941 | 412 |
927170 | 927170 | 2021-01-14 | Ventura | California | 6111 | 56453 | 401 |
923924 | 923924 | 2021-01-13 | Ventura | California | 6111 | 55342 | 388 |
920679 | 920679 | 2021-01-12 | Ventura | California | 6111 | 54202 | 372 |
917434 | 917434 | 2021-01-11 | Ventura | California | 6111 | 53095 | 351 |
914189 | 914189 | 2021-01-10 | Ventura | California | 6111 | 51988 | 334 |
910944 | 910944 | 2021-01-09 | Ventura | California | 6111 | 50553 | 334 |
907699 | 907699 | 2021-01-08 | Ventura | California | 6111 | 49083 | 334 |
904453 | 904453 | 2021-01-07 | Ventura | California | 6111 | 47428 | 313 |
901208 | 901208 | 2021-01-06 | Ventura | California | 6111 | 46456 | 305 |
897963 | 897963 | 2021-01-05 | Ventura | California | 6111 | 45014 | 297 |
894718 | 894718 | 2021-01-04 | Ventura | California | 6111 | 43747 | 289 |
891471 | 891471 | 2021-01-03 | Ventura | California | 6111 | 43397 | 263 |
888224 | 888224 | 2021-01-02 | Ventura | California | 6111 | 42026 | 263 |
884979 | 884979 | 2021-01-01 | Ventura | California | 6111 | 40854 | 263 |
881734 | 881734 | 2020-12-31 | Ventura | California | 6111 | 39559 | 263 |
878489 | 878489 | 2020-12-30 | Ventura | California | 6111 | 38669 | 260 |
875244 | 875244 | 2020-12-29 | Ventura | California | 6111 | 37572 | 255 |
871999 | 871999 | 2020-12-28 | Ventura | California | 6111 | 36661 | 244 |
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);