ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1092666 | 1092666 | 2021-03-06 | Napa | California | 6055 | 9110 | 75 |
1089420 | 1089420 | 2021-03-05 | Napa | California | 6055 | 9095 | 75 |
1086175 | 1086175 | 2021-03-04 | Napa | California | 6055 | 9091 | 74 |
1082929 | 1082929 | 2021-03-03 | Napa | California | 6055 | 9081 | 72 |
1079683 | 1079683 | 2021-03-02 | Napa | California | 6055 | 9057 | 71 |
1076438 | 1076438 | 2021-03-01 | Napa | California | 6055 | 9054 | 69 |
1073192 | 1073192 | 2021-02-28 | Napa | California | 6055 | 9039 | 69 |
1069946 | 1069946 | 2021-02-27 | Napa | California | 6055 | 9015 | 69 |
1066701 | 1066701 | 2021-02-26 | Napa | California | 6055 | 8999 | 69 |
1063456 | 1063456 | 2021-02-25 | Napa | California | 6055 | 8977 | 68 |
1060211 | 1060211 | 2021-02-24 | Napa | California | 6055 | 8968 | 68 |
1056965 | 1056965 | 2021-02-23 | Napa | California | 6055 | 8951 | 68 |
1053719 | 1053719 | 2021-02-22 | Napa | California | 6055 | 8930 | 67 |
1050472 | 1050472 | 2021-02-21 | Napa | California | 6055 | 8911 | 67 |
1047225 | 1047225 | 2021-02-20 | Napa | California | 6055 | 8900 | 67 |
1043980 | 1043980 | 2021-02-19 | Napa | California | 6055 | 8878 | 67 |
1040735 | 1040735 | 2021-02-18 | Napa | California | 6055 | 8866 | 65 |
1037490 | 1037490 | 2021-02-17 | Napa | California | 6055 | 8855 | 64 |
1034245 | 1034245 | 2021-02-16 | Napa | California | 6055 | 8838 | 62 |
1030999 | 1030999 | 2021-02-15 | Napa | California | 6055 | 8827 | 62 |
1027752 | 1027752 | 2021-02-14 | Napa | California | 6055 | 8810 | 62 |
1024507 | 1024507 | 2021-02-13 | Napa | California | 6055 | 8786 | 62 |
1021262 | 1021262 | 2021-02-12 | Napa | California | 6055 | 8778 | 62 |
1018017 | 1018017 | 2021-02-11 | Napa | California | 6055 | 8770 | 61 |
1014772 | 1014772 | 2021-02-10 | Napa | California | 6055 | 8750 | 59 |
1011527 | 1011527 | 2021-02-09 | Napa | California | 6055 | 8720 | 59 |
1008281 | 1008281 | 2021-02-08 | Napa | California | 6055 | 8702 | 58 |
1005035 | 1005035 | 2021-02-07 | Napa | California | 6055 | 8640 | 58 |
1001789 | 1001789 | 2021-02-06 | Napa | California | 6055 | 8599 | 58 |
998543 | 998543 | 2021-02-05 | Napa | California | 6055 | 8574 | 58 |
995297 | 995297 | 2021-02-04 | Napa | California | 6055 | 8535 | 58 |
992051 | 992051 | 2021-02-03 | Napa | California | 6055 | 8506 | 57 |
988805 | 988805 | 2021-02-02 | Napa | California | 6055 | 8450 | 55 |
985558 | 985558 | 2021-02-01 | Napa | California | 6055 | 8405 | 54 |
982311 | 982311 | 2021-01-31 | Napa | California | 6055 | 8343 | 54 |
979065 | 979065 | 2021-01-30 | Napa | California | 6055 | 8277 | 54 |
975820 | 975820 | 2021-01-29 | Napa | California | 6055 | 8234 | 52 |
972575 | 972575 | 2021-01-28 | Napa | California | 6055 | 8188 | 52 |
969330 | 969330 | 2021-01-27 | Napa | California | 6055 | 8146 | 52 |
966086 | 966086 | 2021-01-26 | Napa | California | 6055 | 8071 | 50 |
962841 | 962841 | 2021-01-25 | Napa | California | 6055 | 8006 | 48 |
959596 | 959596 | 2021-01-24 | Napa | California | 6055 | 7894 | 47 |
956350 | 956350 | 2021-01-23 | Napa | California | 6055 | 7829 | 47 |
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);