ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where fips = 6073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277766 | 1277766 | 2021-05-02 | San Diego | California | 6073 | 276430 | 3706 |
1274519 | 1274519 | 2021-05-01 | San Diego | California | 6073 | 276220 | 3702 |
1271272 | 1271272 | 2021-04-30 | San Diego | California | 6073 | 276024 | 3700 |
1268025 | 1268025 | 2021-04-29 | San Diego | California | 6073 | 275884 | 3698 |
1264778 | 1264778 | 2021-04-28 | San Diego | California | 6073 | 275748 | 3692 |
1261531 | 1261531 | 2021-04-27 | San Diego | California | 6073 | 275604 | 3692 |
1258284 | 1258284 | 2021-04-26 | San Diego | California | 6073 | 275475 | 3692 |
1255037 | 1255037 | 2021-04-25 | San Diego | California | 6073 | 275315 | 3688 |
1251790 | 1251790 | 2021-04-24 | San Diego | California | 6073 | 275160 | 3684 |
1248543 | 1248543 | 2021-04-23 | San Diego | California | 6073 | 275976 | 3684 |
1245296 | 1245296 | 2021-04-22 | San Diego | California | 6073 | 275695 | 3681 |
1242049 | 1242049 | 2021-04-21 | San Diego | California | 6073 | 275432 | 3674 |
1238802 | 1238802 | 2021-04-20 | San Diego | California | 6073 | 275176 | 3674 |
1235555 | 1235555 | 2021-04-19 | San Diego | California | 6073 | 275024 | 3674 |
1232308 | 1232308 | 2021-04-18 | San Diego | California | 6073 | 274875 | 3674 |
1229059 | 1229059 | 2021-04-17 | San Diego | California | 6073 | 274874 | 3674 |
1225811 | 1225811 | 2021-04-16 | San Diego | California | 6073 | 274313 | 3662 |
1222564 | 1222564 | 2021-04-15 | San Diego | California | 6073 | 274032 | 3653 |
1219316 | 1219316 | 2021-04-14 | San Diego | California | 6073 | 274031 | 3648 |
1216068 | 1216068 | 2021-04-13 | San Diego | California | 6073 | 273771 | 3621 |
1212821 | 1212821 | 2021-04-12 | San Diego | California | 6073 | 273493 | 3621 |
1209573 | 1209573 | 2021-04-11 | San Diego | California | 6073 | 273349 | 3621 |
1206324 | 1206324 | 2021-04-10 | San Diego | California | 6073 | 272760 | 3600 |
1203076 | 1203076 | 2021-04-09 | San Diego | California | 6073 | 272759 | 3600 |
1199828 | 1199828 | 2021-04-08 | San Diego | California | 6073 | 272557 | 3592 |
1196579 | 1196579 | 2021-04-07 | San Diego | California | 6073 | 272257 | 3588 |
1193331 | 1193331 | 2021-04-06 | San Diego | California | 6073 | 271929 | 3585 |
1190081 | 1190081 | 2021-04-05 | San Diego | California | 6073 | 271717 | 3583 |
1186834 | 1186834 | 2021-04-04 | San Diego | California | 6073 | 271590 | 3583 |
1183587 | 1183587 | 2021-04-03 | San Diego | California | 6073 | 271397 | 3571 |
1180340 | 1180340 | 2021-04-02 | San Diego | California | 6073 | 271098 | 3568 |
1177093 | 1177093 | 2021-04-01 | San Diego | California | 6073 | 270602 | 3555 |
1173846 | 1173846 | 2021-03-31 | San Diego | California | 6073 | 270350 | 3555 |
1170599 | 1170599 | 2021-03-30 | San Diego | California | 6073 | 270060 | 3555 |
1167351 | 1167351 | 2021-03-29 | San Diego | California | 6073 | 269833 | 3547 |
1164103 | 1164103 | 2021-03-28 | San Diego | California | 6073 | 269543 | 3547 |
1160855 | 1160855 | 2021-03-27 | San Diego | California | 6073 | 269338 | 3540 |
1157607 | 1157607 | 2021-03-26 | San Diego | California | 6073 | 269112 | 3525 |
1154360 | 1154360 | 2021-03-25 | San Diego | California | 6073 | 268690 | 3520 |
1151113 | 1151113 | 2021-03-24 | San Diego | California | 6073 | 268480 | 3509 |
1147866 | 1147866 | 2021-03-23 | San Diego | California | 6073 | 268223 | 3498 |
1144619 | 1144619 | 2021-03-22 | San Diego | California | 6073 | 267980 | 3494 |
1141372 | 1141372 | 2021-03-21 | San Diego | California | 6073 | 267791 | 3494 |
1138126 | 1138126 | 2021-03-20 | San Diego | California | 6073 | 267599 | 3492 |
1134880 | 1134880 | 2021-03-19 | San Diego | California | 6073 | 267240 | 3491 |
1131633 | 1131633 | 2021-03-18 | San Diego | California | 6073 | 266819 | 3478 |
1128385 | 1128385 | 2021-03-17 | San Diego | California | 6073 | 266380 | 3470 |
1125139 | 1125139 | 2021-03-16 | San Diego | California | 6073 | 265969 | 3462 |
1121893 | 1121893 | 2021-03-15 | San Diego | California | 6073 | 265712 | 3452 |
1118646 | 1118646 | 2021-03-14 | San Diego | California | 6073 | 265534 | 3452 |
1115399 | 1115399 | 2021-03-13 | San Diego | California | 6073 | 265336 | 3444 |
1112153 | 1112153 | 2021-03-12 | San Diego | California | 6073 | 264590 | 3422 |
1108907 | 1108907 | 2021-03-11 | San Diego | California | 6073 | 264590 | 3422 |
1105661 | 1105661 | 2021-03-10 | San Diego | California | 6073 | 264160 | 3413 |
1102415 | 1102415 | 2021-03-09 | San Diego | California | 6073 | 263811 | 3405 |
1099169 | 1099169 | 2021-03-08 | San Diego | California | 6073 | 263338 | 3390 |
1095921 | 1095921 | 2021-03-07 | San Diego | California | 6073 | 262844 | 3385 |
1092675 | 1092675 | 2021-03-06 | San Diego | California | 6073 | 262844 | 3385 |
1089429 | 1089429 | 2021-03-05 | San Diego | California | 6073 | 262423 | 3371 |
1086184 | 1086184 | 2021-03-04 | San Diego | California | 6073 | 261924 | 3359 |
1082938 | 1082938 | 2021-03-03 | San Diego | California | 6073 | 261416 | 3342 |
1079692 | 1079692 | 2021-03-02 | San Diego | California | 6073 | 261064 | 3317 |
1076447 | 1076447 | 2021-03-01 | San Diego | California | 6073 | 260688 | 3303 |
1073201 | 1073201 | 2021-02-28 | San Diego | California | 6073 | 260419 | 3303 |
1069955 | 1069955 | 2021-02-27 | San Diego | California | 6073 | 260157 | 3284 |
1066710 | 1066710 | 2021-02-26 | San Diego | California | 6073 | 259707 | 3271 |
1063465 | 1063465 | 2021-02-25 | San Diego | California | 6073 | 259045 | 3260 |
1060220 | 1060220 | 2021-02-24 | San Diego | California | 6073 | 258526 | 3230 |
1056974 | 1056974 | 2021-02-23 | San Diego | California | 6073 | 257868 | 3218 |
1053728 | 1053728 | 2021-02-22 | San Diego | California | 6073 | 257414 | 3190 |
1050481 | 1050481 | 2021-02-21 | San Diego | California | 6073 | 257093 | 3190 |
1047234 | 1047234 | 2021-02-20 | San Diego | California | 6073 | 256576 | 3188 |
1043989 | 1043989 | 2021-02-19 | San Diego | California | 6073 | 255865 | 3169 |
1040744 | 1040744 | 2021-02-18 | San Diego | California | 6073 | 255053 | 3135 |
1037499 | 1037499 | 2021-02-17 | San Diego | California | 6073 | 254243 | 3099 |
1034254 | 1034254 | 2021-02-16 | San Diego | California | 6073 | 253704 | 3042 |
1031008 | 1031008 | 2021-02-15 | San Diego | California | 6073 | 252313 | 3037 |
1027761 | 1027761 | 2021-02-14 | San Diego | California | 6073 | 252313 | 3037 |
1024516 | 1024516 | 2021-02-13 | San Diego | California | 6073 | 251745 | 3009 |
1021271 | 1021271 | 2021-02-12 | San Diego | California | 6073 | 250854 | 2979 |
1018026 | 1018026 | 2021-02-11 | San Diego | California | 6073 | 250037 | 2955 |
1014781 | 1014781 | 2021-02-10 | San Diego | California | 6073 | 248924 | 2904 |
1011536 | 1011536 | 2021-02-09 | San Diego | California | 6073 | 248114 | 2853 |
1008290 | 1008290 | 2021-02-08 | San Diego | California | 6073 | 247525 | 2821 |
1005044 | 1005044 | 2021-02-07 | San Diego | California | 6073 | 246627 | 2821 |
1001798 | 1001798 | 2021-02-06 | San Diego | California | 6073 | 245397 | 2812 |
998552 | 998552 | 2021-02-05 | San Diego | California | 6073 | 244132 | 2777 |
995306 | 995306 | 2021-02-04 | San Diego | California | 6073 | 242679 | 2738 |
992060 | 992060 | 2021-02-03 | San Diego | California | 6073 | 241081 | 2683 |
988814 | 988814 | 2021-02-02 | San Diego | California | 6073 | 240113 | 2629 |
985567 | 985567 | 2021-02-01 | San Diego | California | 6073 | 239205 | 2619 |
982320 | 982320 | 2021-01-31 | San Diego | California | 6073 | 238105 | 2619 |
979074 | 979074 | 2021-01-30 | San Diego | California | 6073 | 236831 | 2603 |
975829 | 975829 | 2021-01-29 | San Diego | California | 6073 | 234703 | 2571 |
972584 | 972584 | 2021-01-28 | San Diego | California | 6073 | 233033 | 2534 |
969339 | 969339 | 2021-01-27 | San Diego | California | 6073 | 231544 | 2465 |
966095 | 966095 | 2021-01-26 | San Diego | California | 6073 | 230129 | 2421 |
962850 | 962850 | 2021-01-25 | San Diego | California | 6073 | 228695 | 2375 |
959605 | 959605 | 2021-01-24 | San Diego | California | 6073 | 227258 | 2375 |
956359 | 956359 | 2021-01-23 | San Diego | California | 6073 | 225621 | 2344 |
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);