ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "San Benito" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193329 | 1193329 | 2021-04-06 | San Benito | California | 6069 | 5904 | 62 |
1190079 | 1190079 | 2021-04-05 | San Benito | California | 6069 | 5901 | 62 |
1186832 | 1186832 | 2021-04-04 | San Benito | California | 6069 | 5893 | 61 |
1183585 | 1183585 | 2021-04-03 | San Benito | California | 6069 | 5888 | 61 |
1180338 | 1180338 | 2021-04-02 | San Benito | California | 6069 | 5878 | 61 |
1177091 | 1177091 | 2021-04-01 | San Benito | California | 6069 | 5875 | 61 |
1173844 | 1173844 | 2021-03-31 | San Benito | California | 6069 | 5870 | 61 |
1170597 | 1170597 | 2021-03-30 | San Benito | California | 6069 | 5865 | 61 |
1167349 | 1167349 | 2021-03-29 | San Benito | California | 6069 | 5862 | 61 |
1164101 | 1164101 | 2021-03-28 | San Benito | California | 6069 | 5862 | 61 |
1160853 | 1160853 | 2021-03-27 | San Benito | California | 6069 | 5855 | 61 |
1157605 | 1157605 | 2021-03-26 | San Benito | California | 6069 | 5850 | 61 |
1154358 | 1154358 | 2021-03-25 | San Benito | California | 6069 | 5847 | 61 |
1151111 | 1151111 | 2021-03-24 | San Benito | California | 6069 | 5845 | 61 |
1147864 | 1147864 | 2021-03-23 | San Benito | California | 6069 | 5844 | 61 |
1144617 | 1144617 | 2021-03-22 | San Benito | California | 6069 | 5842 | 61 |
1141370 | 1141370 | 2021-03-21 | San Benito | California | 6069 | 5840 | 61 |
1138124 | 1138124 | 2021-03-20 | San Benito | California | 6069 | 5845 | 61 |
1134878 | 1134878 | 2021-03-19 | San Benito | California | 6069 | 5842 | 61 |
1131631 | 1131631 | 2021-03-18 | San Benito | California | 6069 | 5841 | 61 |
1128383 | 1128383 | 2021-03-17 | San Benito | California | 6069 | 5831 | 61 |
1125137 | 1125137 | 2021-03-16 | San Benito | California | 6069 | 5831 | 61 |
1121891 | 1121891 | 2021-03-15 | San Benito | California | 6069 | 5829 | 61 |
1118644 | 1118644 | 2021-03-14 | San Benito | California | 6069 | 5823 | 61 |
1115397 | 1115397 | 2021-03-13 | San Benito | California | 6069 | 5817 | 61 |
1112151 | 1112151 | 2021-03-12 | San Benito | California | 6069 | 5816 | 61 |
1108905 | 1108905 | 2021-03-11 | San Benito | California | 6069 | 5811 | 61 |
1105659 | 1105659 | 2021-03-10 | San Benito | California | 6069 | 5800 | 61 |
1102413 | 1102413 | 2021-03-09 | San Benito | California | 6069 | 5797 | 61 |
1099167 | 1099167 | 2021-03-08 | San Benito | California | 6069 | 5795 | 61 |
1095919 | 1095919 | 2021-03-07 | San Benito | California | 6069 | 5793 | 61 |
1092673 | 1092673 | 2021-03-06 | San Benito | California | 6069 | 5790 | 61 |
1089427 | 1089427 | 2021-03-05 | San Benito | California | 6069 | 5781 | 61 |
1086182 | 1086182 | 2021-03-04 | San Benito | California | 6069 | 5774 | 61 |
1082936 | 1082936 | 2021-03-03 | San Benito | California | 6069 | 5770 | 61 |
1079690 | 1079690 | 2021-03-02 | San Benito | California | 6069 | 5772 | 61 |
1076445 | 1076445 | 2021-03-01 | San Benito | California | 6069 | 5772 | 61 |
1073199 | 1073199 | 2021-02-28 | San Benito | California | 6069 | 5767 | 59 |
1069953 | 1069953 | 2021-02-27 | San Benito | California | 6069 | 5759 | 59 |
1066708 | 1066708 | 2021-02-26 | San Benito | California | 6069 | 5752 | 59 |
1063463 | 1063463 | 2021-02-25 | San Benito | California | 6069 | 5743 | 59 |
1060218 | 1060218 | 2021-02-24 | San Benito | California | 6069 | 5731 | 59 |
1056972 | 1056972 | 2021-02-23 | San Benito | California | 6069 | 5723 | 58 |
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 |
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);