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 |
---|---|---|---|---|---|---|---|
1417350 | 1417350 | 2021-06-14 | San Benito | California | 6069 | 6086 | 63 |
1414104 | 1414104 | 2021-06-13 | San Benito | California | 6069 | 6083 | 63 |
1410859 | 1410859 | 2021-06-12 | San Benito | California | 6069 | 6082 | 63 |
1407614 | 1407614 | 2021-06-11 | San Benito | California | 6069 | 6079 | 63 |
1404368 | 1404368 | 2021-06-10 | San Benito | California | 6069 | 6078 | 63 |
1401123 | 1401123 | 2021-06-09 | San Benito | California | 6069 | 6076 | 63 |
1397878 | 1397878 | 2021-06-08 | San Benito | California | 6069 | 6074 | 63 |
1394631 | 1394631 | 2021-06-07 | San Benito | California | 6069 | 6074 | 63 |
1391386 | 1391386 | 2021-06-06 | San Benito | California | 6069 | 6074 | 63 |
1388141 | 1388141 | 2021-06-05 | San Benito | California | 6069 | 6073 | 63 |
1384896 | 1384896 | 2021-06-04 | San Benito | California | 6069 | 6073 | 63 |
1381650 | 1381650 | 2021-06-03 | San Benito | California | 6069 | 6073 | 63 |
1378405 | 1378405 | 2021-06-02 | San Benito | California | 6069 | 6073 | 63 |
1375159 | 1375159 | 2021-06-01 | San Benito | California | 6069 | 6072 | 63 |
1371914 | 1371914 | 2021-05-31 | San Benito | California | 6069 | 6072 | 63 |
1368669 | 1368669 | 2021-05-30 | San Benito | California | 6069 | 6072 | 63 |
1365423 | 1365423 | 2021-05-29 | San Benito | California | 6069 | 6074 | 63 |
1362177 | 1362177 | 2021-05-28 | San Benito | California | 6069 | 6074 | 63 |
1358930 | 1358930 | 2021-05-27 | San Benito | California | 6069 | 6074 | 63 |
1355684 | 1355684 | 2021-05-26 | San Benito | California | 6069 | 6073 | 63 |
1352438 | 1352438 | 2021-05-25 | San Benito | California | 6069 | 6072 | 63 |
1349192 | 1349192 | 2021-05-24 | San Benito | California | 6069 | 6072 | 63 |
1345945 | 1345945 | 2021-05-23 | San Benito | California | 6069 | 6071 | 63 |
1342697 | 1342697 | 2021-05-22 | San Benito | California | 6069 | 6068 | 63 |
1339449 | 1339449 | 2021-05-21 | San Benito | California | 6069 | 6067 | 63 |
1336202 | 1336202 | 2021-05-20 | San Benito | California | 6069 | 6064 | 63 |
1332955 | 1332955 | 2021-05-19 | San Benito | California | 6069 | 6065 | 63 |
1329708 | 1329708 | 2021-05-18 | San Benito | California | 6069 | 6067 | 63 |
1326461 | 1326461 | 2021-05-17 | San Benito | California | 6069 | 6067 | 63 |
1323215 | 1323215 | 2021-05-16 | San Benito | California | 6069 | 6066 | 63 |
1319969 | 1319969 | 2021-05-15 | San Benito | California | 6069 | 6064 | 63 |
1316722 | 1316722 | 2021-05-14 | San Benito | California | 6069 | 6062 | 63 |
1313475 | 1313475 | 2021-05-13 | San Benito | California | 6069 | 6062 | 63 |
1310228 | 1310228 | 2021-05-12 | San Benito | California | 6069 | 6058 | 63 |
1306982 | 1306982 | 2021-05-11 | San Benito | California | 6069 | 6058 | 63 |
1303736 | 1303736 | 2021-05-10 | San Benito | California | 6069 | 6056 | 63 |
1300489 | 1300489 | 2021-05-09 | San Benito | California | 6069 | 6048 | 63 |
1297242 | 1297242 | 2021-05-08 | San Benito | California | 6069 | 6048 | 63 |
1293996 | 1293996 | 2021-05-07 | San Benito | California | 6069 | 6045 | 63 |
1290750 | 1290750 | 2021-05-06 | San Benito | California | 6069 | 6046 | 63 |
1287504 | 1287504 | 2021-05-05 | San Benito | California | 6069 | 6039 | 63 |
1284258 | 1284258 | 2021-05-04 | San Benito | California | 6069 | 6038 | 63 |
1281011 | 1281011 | 2021-05-03 | San Benito | California | 6069 | 6037 | 63 |
1277764 | 1277764 | 2021-05-02 | San Benito | California | 6069 | 6030 | 63 |
1274517 | 1274517 | 2021-05-01 | San Benito | California | 6069 | 6024 | 63 |
1271270 | 1271270 | 2021-04-30 | San Benito | California | 6069 | 6023 | 63 |
1268023 | 1268023 | 2021-04-29 | San Benito | California | 6069 | 6021 | 63 |
1264776 | 1264776 | 2021-04-28 | San Benito | California | 6069 | 6016 | 63 |
1261529 | 1261529 | 2021-04-27 | San Benito | California | 6069 | 6013 | 63 |
1258282 | 1258282 | 2021-04-26 | San Benito | California | 6069 | 6014 | 63 |
1255035 | 1255035 | 2021-04-25 | San Benito | California | 6069 | 6007 | 63 |
1251788 | 1251788 | 2021-04-24 | San Benito | California | 6069 | 6005 | 63 |
1248541 | 1248541 | 2021-04-23 | San Benito | California | 6069 | 5998 | 63 |
1245294 | 1245294 | 2021-04-22 | San Benito | California | 6069 | 5998 | 63 |
1242047 | 1242047 | 2021-04-21 | San Benito | California | 6069 | 5988 | 63 |
1238800 | 1238800 | 2021-04-20 | San Benito | California | 6069 | 5989 | 63 |
1235553 | 1235553 | 2021-04-19 | San Benito | California | 6069 | 5989 | 63 |
1232306 | 1232306 | 2021-04-18 | San Benito | California | 6069 | 5986 | 63 |
1229057 | 1229057 | 2021-04-17 | San Benito | California | 6069 | 5982 | 63 |
1225809 | 1225809 | 2021-04-16 | San Benito | California | 6069 | 5969 | 63 |
1222562 | 1222562 | 2021-04-15 | San Benito | California | 6069 | 5960 | 63 |
1219314 | 1219314 | 2021-04-14 | San Benito | California | 6069 | 5946 | 63 |
1216066 | 1216066 | 2021-04-13 | San Benito | California | 6069 | 5942 | 62 |
1212819 | 1212819 | 2021-04-12 | San Benito | California | 6069 | 5941 | 62 |
1209571 | 1209571 | 2021-04-11 | San Benito | California | 6069 | 5932 | 62 |
1206322 | 1206322 | 2021-04-10 | San Benito | California | 6069 | 5925 | 62 |
1203074 | 1203074 | 2021-04-09 | San Benito | California | 6069 | 5914 | 62 |
1199826 | 1199826 | 2021-04-08 | San Benito | California | 6069 | 5912 | 62 |
1196577 | 1196577 | 2021-04-07 | San Benito | California | 6069 | 5907 | 62 |
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 |
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);