ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6055 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417343 | 1417343 | 2021-06-14 | Napa | California | 6055 | 9996 | 80 |
1414097 | 1414097 | 2021-06-13 | Napa | California | 6055 | 9987 | 80 |
1410852 | 1410852 | 2021-06-12 | Napa | California | 6055 | 9978 | 80 |
1407607 | 1407607 | 2021-06-11 | Napa | California | 6055 | 9975 | 80 |
1404361 | 1404361 | 2021-06-10 | Napa | California | 6055 | 9972 | 80 |
1401116 | 1401116 | 2021-06-09 | Napa | California | 6055 | 9963 | 80 |
1397871 | 1397871 | 2021-06-08 | Napa | California | 6055 | 9963 | 80 |
1394624 | 1394624 | 2021-06-07 | Napa | California | 6055 | 9964 | 80 |
1391379 | 1391379 | 2021-06-06 | Napa | California | 6055 | 9961 | 80 |
1388134 | 1388134 | 2021-06-05 | Napa | California | 6055 | 9959 | 80 |
1384889 | 1384889 | 2021-06-04 | Napa | California | 6055 | 9958 | 81 |
1381643 | 1381643 | 2021-06-03 | Napa | California | 6055 | 9954 | 82 |
1378398 | 1378398 | 2021-06-02 | Napa | California | 6055 | 9950 | 82 |
1375152 | 1375152 | 2021-06-01 | Napa | California | 6055 | 9949 | 82 |
1371907 | 1371907 | 2021-05-31 | Napa | California | 6055 | 9949 | 82 |
1368662 | 1368662 | 2021-05-30 | Napa | California | 6055 | 9949 | 82 |
1365416 | 1365416 | 2021-05-29 | Napa | California | 6055 | 9942 | 82 |
1362170 | 1362170 | 2021-05-28 | Napa | California | 6055 | 9935 | 82 |
1358923 | 1358923 | 2021-05-27 | Napa | California | 6055 | 9933 | 82 |
1355677 | 1355677 | 2021-05-26 | Napa | California | 6055 | 9927 | 82 |
1352431 | 1352431 | 2021-05-25 | Napa | California | 6055 | 9925 | 82 |
1349185 | 1349185 | 2021-05-24 | Napa | California | 6055 | 9924 | 82 |
1345938 | 1345938 | 2021-05-23 | Napa | California | 6055 | 9919 | 82 |
1342690 | 1342690 | 2021-05-22 | Napa | California | 6055 | 9914 | 82 |
1339442 | 1339442 | 2021-05-21 | Napa | California | 6055 | 9914 | 82 |
1336195 | 1336195 | 2021-05-20 | Napa | California | 6055 | 9907 | 82 |
1332948 | 1332948 | 2021-05-19 | Napa | California | 6055 | 9906 | 82 |
1329701 | 1329701 | 2021-05-18 | Napa | California | 6055 | 9895 | 82 |
1326454 | 1326454 | 2021-05-17 | Napa | California | 6055 | 9892 | 82 |
1323208 | 1323208 | 2021-05-16 | Napa | California | 6055 | 9888 | 82 |
1319962 | 1319962 | 2021-05-15 | Napa | California | 6055 | 9884 | 82 |
1316715 | 1316715 | 2021-05-14 | Napa | California | 6055 | 9878 | 82 |
1313468 | 1313468 | 2021-05-13 | Napa | California | 6055 | 9871 | 82 |
1310221 | 1310221 | 2021-05-12 | Napa | California | 6055 | 9871 | 81 |
1306975 | 1306975 | 2021-05-11 | Napa | California | 6055 | 9861 | 81 |
1303729 | 1303729 | 2021-05-10 | Napa | California | 6055 | 9858 | 81 |
1300482 | 1300482 | 2021-05-09 | Napa | California | 6055 | 9854 | 81 |
1297235 | 1297235 | 2021-05-08 | Napa | California | 6055 | 9850 | 81 |
1293989 | 1293989 | 2021-05-07 | Napa | California | 6055 | 9844 | 81 |
1290743 | 1290743 | 2021-05-06 | Napa | California | 6055 | 9834 | 81 |
1287497 | 1287497 | 2021-05-05 | Napa | California | 6055 | 9825 | 81 |
1284251 | 1284251 | 2021-05-04 | Napa | California | 6055 | 9816 | 81 |
1281004 | 1281004 | 2021-05-03 | Napa | California | 6055 | 9806 | 81 |
1277757 | 1277757 | 2021-05-02 | Napa | California | 6055 | 9801 | 81 |
1274510 | 1274510 | 2021-05-01 | Napa | California | 6055 | 9793 | 81 |
1271263 | 1271263 | 2021-04-30 | Napa | California | 6055 | 9790 | 81 |
1268016 | 1268016 | 2021-04-29 | Napa | California | 6055 | 9778 | 81 |
1264769 | 1264769 | 2021-04-28 | Napa | California | 6055 | 9775 | 81 |
1261522 | 1261522 | 2021-04-27 | Napa | California | 6055 | 9770 | 79 |
1258275 | 1258275 | 2021-04-26 | Napa | California | 6055 | 9763 | 79 |
1255028 | 1255028 | 2021-04-25 | Napa | California | 6055 | 9757 | 79 |
1251781 | 1251781 | 2021-04-24 | Napa | California | 6055 | 9753 | 79 |
1248534 | 1248534 | 2021-04-23 | Napa | California | 6055 | 9735 | 79 |
1245287 | 1245287 | 2021-04-22 | Napa | California | 6055 | 9728 | 79 |
1242040 | 1242040 | 2021-04-21 | Napa | California | 6055 | 9712 | 79 |
1238793 | 1238793 | 2021-04-20 | Napa | California | 6055 | 9681 | 79 |
1235546 | 1235546 | 2021-04-19 | Napa | California | 6055 | 9675 | 79 |
1232299 | 1232299 | 2021-04-18 | Napa | California | 6055 | 9667 | 79 |
1229050 | 1229050 | 2021-04-17 | Napa | California | 6055 | 9655 | 79 |
1225802 | 1225802 | 2021-04-16 | Napa | California | 6055 | 9655 | 79 |
1222555 | 1222555 | 2021-04-15 | Napa | California | 6055 | 9646 | 79 |
1219307 | 1219307 | 2021-04-14 | Napa | California | 6055 | 9637 | 79 |
1216059 | 1216059 | 2021-04-13 | Napa | California | 6055 | 9619 | 80 |
1212812 | 1212812 | 2021-04-12 | Napa | California | 6055 | 9598 | 80 |
1209564 | 1209564 | 2021-04-11 | Napa | California | 6055 | 9570 | 79 |
1206315 | 1206315 | 2021-04-10 | Napa | California | 6055 | 9575 | 80 |
1203067 | 1203067 | 2021-04-09 | Napa | California | 6055 | 9570 | 80 |
1199819 | 1199819 | 2021-04-08 | Napa | California | 6055 | 9557 | 80 |
1196570 | 1196570 | 2021-04-07 | Napa | California | 6055 | 9528 | 78 |
1193322 | 1193322 | 2021-04-06 | Napa | California | 6055 | 9517 | 78 |
1190072 | 1190072 | 2021-04-05 | Napa | California | 6055 | 9500 | 78 |
1186825 | 1186825 | 2021-04-04 | Napa | California | 6055 | 9474 | 78 |
1183578 | 1183578 | 2021-04-03 | Napa | California | 6055 | 9454 | 78 |
1180331 | 1180331 | 2021-04-02 | Napa | California | 6055 | 9454 | 78 |
1177084 | 1177084 | 2021-04-01 | Napa | California | 6055 | 9416 | 78 |
1173837 | 1173837 | 2021-03-31 | Napa | California | 6055 | 9395 | 78 |
1170590 | 1170590 | 2021-03-30 | Napa | California | 6055 | 9395 | 78 |
1167342 | 1167342 | 2021-03-29 | Napa | California | 6055 | 9385 | 78 |
1164094 | 1164094 | 2021-03-28 | Napa | California | 6055 | 9361 | 78 |
1160846 | 1160846 | 2021-03-27 | Napa | California | 6055 | 9350 | 78 |
1157598 | 1157598 | 2021-03-26 | Napa | California | 6055 | 9337 | 78 |
1154351 | 1154351 | 2021-03-25 | Napa | California | 6055 | 9322 | 78 |
1151104 | 1151104 | 2021-03-24 | Napa | California | 6055 | 9306 | 78 |
1147857 | 1147857 | 2021-03-23 | Napa | California | 6055 | 9297 | 77 |
1144610 | 1144610 | 2021-03-22 | Napa | California | 6055 | 9283 | 77 |
1141363 | 1141363 | 2021-03-21 | Napa | California | 6055 | 9275 | 77 |
1138117 | 1138117 | 2021-03-20 | Napa | California | 6055 | 9257 | 77 |
1134871 | 1134871 | 2021-03-19 | Napa | California | 6055 | 9248 | 77 |
1131624 | 1131624 | 2021-03-18 | Napa | California | 6055 | 9234 | 76 |
1128376 | 1128376 | 2021-03-17 | Napa | California | 6055 | 9210 | 75 |
1125130 | 1125130 | 2021-03-16 | Napa | California | 6055 | 9197 | 75 |
1121884 | 1121884 | 2021-03-15 | Napa | California | 6055 | 9195 | 75 |
1118637 | 1118637 | 2021-03-14 | Napa | California | 6055 | 9191 | 75 |
1115390 | 1115390 | 2021-03-13 | Napa | California | 6055 | 9181 | 75 |
1112144 | 1112144 | 2021-03-12 | Napa | California | 6055 | 9174 | 75 |
1108898 | 1108898 | 2021-03-11 | Napa | California | 6055 | 9166 | 75 |
1105652 | 1105652 | 2021-03-10 | Napa | California | 6055 | 9156 | 75 |
1102406 | 1102406 | 2021-03-09 | Napa | California | 6055 | 9147 | 75 |
1099160 | 1099160 | 2021-03-08 | Napa | California | 6055 | 9138 | 75 |
1095912 | 1095912 | 2021-03-07 | Napa | California | 6055 | 9130 | 75 |
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);