ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 6069 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053726 | 1053726 | 2021-02-22 | San Benito | California | 6069 | 5716 | 57 |
1050479 | 1050479 | 2021-02-21 | San Benito | California | 6069 | 5709 | 57 |
1047232 | 1047232 | 2021-02-20 | San Benito | California | 6069 | 5699 | 57 |
1043987 | 1043987 | 2021-02-19 | San Benito | California | 6069 | 5697 | 57 |
1040742 | 1040742 | 2021-02-18 | San Benito | California | 6069 | 5661 | 57 |
1037497 | 1037497 | 2021-02-17 | San Benito | California | 6069 | 5659 | 57 |
1034252 | 1034252 | 2021-02-16 | San Benito | California | 6069 | 5649 | 57 |
1031006 | 1031006 | 2021-02-15 | San Benito | California | 6069 | 5641 | 57 |
1027759 | 1027759 | 2021-02-14 | San Benito | California | 6069 | 5633 | 57 |
1024514 | 1024514 | 2021-02-13 | San Benito | California | 6069 | 5622 | 57 |
1021269 | 1021269 | 2021-02-12 | San Benito | California | 6069 | 5609 | 57 |
1018024 | 1018024 | 2021-02-11 | San Benito | California | 6069 | 5591 | 57 |
1014779 | 1014779 | 2021-02-10 | San Benito | California | 6069 | 5566 | 57 |
1011534 | 1011534 | 2021-02-09 | San Benito | California | 6069 | 5553 | 57 |
1008288 | 1008288 | 2021-02-08 | San Benito | California | 6069 | 5548 | 55 |
1005042 | 1005042 | 2021-02-07 | San Benito | California | 6069 | 5516 | 55 |
1001796 | 1001796 | 2021-02-06 | San Benito | California | 6069 | 5502 | 55 |
998550 | 998550 | 2021-02-05 | San Benito | California | 6069 | 5488 | 55 |
995304 | 995304 | 2021-02-04 | San Benito | California | 6069 | 5463 | 55 |
992058 | 992058 | 2021-02-03 | San Benito | California | 6069 | 5444 | 54 |
988812 | 988812 | 2021-02-02 | San Benito | California | 6069 | 5432 | 54 |
985565 | 985565 | 2021-02-01 | San Benito | California | 6069 | 5425 | 54 |
982318 | 982318 | 2021-01-31 | San Benito | California | 6069 | 5401 | 52 |
979072 | 979072 | 2021-01-30 | San Benito | California | 6069 | 5386 | 52 |
975827 | 975827 | 2021-01-29 | San Benito | California | 6069 | 5344 | 52 |
972582 | 972582 | 2021-01-28 | San Benito | California | 6069 | 5284 | 52 |
969337 | 969337 | 2021-01-27 | San Benito | California | 6069 | 5251 | 52 |
966093 | 966093 | 2021-01-26 | San Benito | California | 6069 | 5238 | 51 |
962848 | 962848 | 2021-01-25 | San Benito | California | 6069 | 5223 | 51 |
959603 | 959603 | 2021-01-24 | San Benito | California | 6069 | 5166 | 48 |
956357 | 956357 | 2021-01-23 | San Benito | California | 6069 | 5143 | 48 |
953112 | 953112 | 2021-01-22 | San Benito | California | 6069 | 5101 | 48 |
949867 | 949867 | 2021-01-21 | San Benito | California | 6069 | 5042 | 46 |
946621 | 946621 | 2021-01-20 | San Benito | California | 6069 | 5003 | 46 |
943374 | 943374 | 2021-01-19 | San Benito | California | 6069 | 4963 | 43 |
940129 | 940129 | 2021-01-18 | San Benito | California | 6069 | 4941 | 43 |
936884 | 936884 | 2021-01-17 | San Benito | California | 6069 | 4882 | 43 |
933639 | 933639 | 2021-01-16 | San Benito | California | 6069 | 4850 | 43 |
930394 | 930394 | 2021-01-15 | San Benito | California | 6069 | 4778 | 43 |
927149 | 927149 | 2021-01-14 | San Benito | California | 6069 | 4698 | 41 |
923903 | 923903 | 2021-01-13 | San Benito | California | 6069 | 4596 | 41 |
920658 | 920658 | 2021-01-12 | San Benito | California | 6069 | 4508 | 39 |
917413 | 917413 | 2021-01-11 | San Benito | California | 6069 | 4451 | 39 |
914168 | 914168 | 2021-01-10 | San Benito | California | 6069 | 4403 | 36 |
910923 | 910923 | 2021-01-09 | San Benito | California | 6069 | 4363 | 36 |
907678 | 907678 | 2021-01-08 | San Benito | California | 6069 | 4266 | 36 |
904432 | 904432 | 2021-01-07 | San Benito | California | 6069 | 4127 | 35 |
901187 | 901187 | 2021-01-06 | San Benito | California | 6069 | 4035 | 34 |
897942 | 897942 | 2021-01-05 | San Benito | California | 6069 | 3952 | 34 |
894697 | 894697 | 2021-01-04 | San Benito | California | 6069 | 3882 | 34 |
891450 | 891450 | 2021-01-03 | San Benito | California | 6069 | 3853 | 29 |
888203 | 888203 | 2021-01-02 | San Benito | California | 6069 | 3802 | 29 |
884958 | 884958 | 2021-01-01 | San Benito | California | 6069 | 3739 | 29 |
881713 | 881713 | 2020-12-31 | San Benito | California | 6069 | 3673 | 29 |
878468 | 878468 | 2020-12-30 | San Benito | California | 6069 | 3538 | 28 |
875223 | 875223 | 2020-12-29 | San Benito | California | 6069 | 3489 | 28 |
871978 | 871978 | 2020-12-28 | San Benito | California | 6069 | 3431 | 28 |
868733 | 868733 | 2020-12-27 | San Benito | California | 6069 | 3394 | 26 |
865488 | 865488 | 2020-12-26 | San Benito | California | 6069 | 3365 | 26 |
862243 | 862243 | 2020-12-25 | San Benito | California | 6069 | 3288 | 26 |
858998 | 858998 | 2020-12-24 | San Benito | California | 6069 | 3231 | 26 |
855753 | 855753 | 2020-12-23 | San Benito | California | 6069 | 3171 | 26 |
852508 | 852508 | 2020-12-22 | San Benito | California | 6069 | 3074 | 24 |
849263 | 849263 | 2020-12-21 | San Benito | California | 6069 | 2964 | 23 |
846018 | 846018 | 2020-12-20 | San Benito | California | 6069 | 2907 | 23 |
842772 | 842772 | 2020-12-19 | San Benito | California | 6069 | 2854 | 23 |
839527 | 839527 | 2020-12-18 | San Benito | California | 6069 | 2760 | 23 |
836282 | 836282 | 2020-12-17 | San Benito | California | 6069 | 2687 | 23 |
833036 | 833036 | 2020-12-16 | San Benito | California | 6069 | 2642 | 22 |
829789 | 829789 | 2020-12-15 | San Benito | California | 6069 | 2538 | 22 |
826543 | 826543 | 2020-12-14 | San Benito | California | 6069 | 2477 | 21 |
823296 | 823296 | 2020-12-13 | San Benito | California | 6069 | 2447 | 19 |
820050 | 820050 | 2020-12-12 | San Benito | California | 6069 | 2401 | 19 |
816804 | 816804 | 2020-12-11 | San Benito | California | 6069 | 2348 | 19 |
813558 | 813558 | 2020-12-10 | San Benito | California | 6069 | 2314 | 19 |
810314 | 810314 | 2020-12-09 | San Benito | California | 6069 | 2264 | 19 |
807069 | 807069 | 2020-12-08 | San Benito | California | 6069 | 2214 | 19 |
803824 | 803824 | 2020-12-07 | San Benito | California | 6069 | 2177 | 19 |
800579 | 800579 | 2020-12-06 | San Benito | California | 6069 | 2159 | 18 |
797334 | 797334 | 2020-12-05 | San Benito | California | 6069 | 2124 | 18 |
794089 | 794089 | 2020-12-04 | San Benito | California | 6069 | 2051 | 18 |
790844 | 790844 | 2020-12-03 | San Benito | California | 6069 | 2007 | 17 |
787599 | 787599 | 2020-12-02 | San Benito | California | 6069 | 1968 | 17 |
784355 | 784355 | 2020-12-01 | San Benito | California | 6069 | 1929 | 17 |
781110 | 781110 | 2020-11-30 | San Benito | California | 6069 | 1893 | 16 |
777864 | 777864 | 2020-11-29 | San Benito | California | 6069 | 1880 | 16 |
774619 | 774619 | 2020-11-28 | San Benito | California | 6069 | 1865 | 16 |
771374 | 771374 | 2020-11-27 | San Benito | California | 6069 | 1837 | 16 |
768129 | 768129 | 2020-11-26 | San Benito | California | 6069 | 1813 | 16 |
764883 | 764883 | 2020-11-25 | San Benito | California | 6069 | 1784 | 16 |
761638 | 761638 | 2020-11-24 | San Benito | California | 6069 | 1767 | 16 |
758393 | 758393 | 2020-11-23 | San Benito | California | 6069 | 1746 | 15 |
755146 | 755146 | 2020-11-22 | San Benito | California | 6069 | 1741 | 15 |
751900 | 751900 | 2020-11-21 | San Benito | California | 6069 | 1711 | 15 |
748654 | 748654 | 2020-11-20 | San Benito | California | 6069 | 1694 | 15 |
745408 | 745408 | 2020-11-19 | San Benito | California | 6069 | 1676 | 15 |
742161 | 742161 | 2020-11-18 | San Benito | California | 6069 | 1652 | 15 |
738914 | 738914 | 2020-11-17 | San Benito | California | 6069 | 1643 | 15 |
735670 | 735670 | 2020-11-16 | San Benito | California | 6069 | 1620 | 15 |
732424 | 732424 | 2020-11-15 | San Benito | California | 6069 | 1614 | 15 |
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);