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 |
---|---|---|---|---|---|---|---|
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 |
953114 | 953114 | 2021-01-22 | San Diego | California | 6073 | 222641 | 2301 |
949869 | 949869 | 2021-01-21 | San Diego | California | 6073 | 219794 | 2222 |
946623 | 946623 | 2021-01-20 | San Diego | California | 6073 | 218618 | 2174 |
943376 | 943376 | 2021-01-19 | San Diego | California | 6073 | 216898 | 2109 |
940131 | 940131 | 2021-01-18 | San Diego | California | 6073 | 211850 | 2103 |
936886 | 936886 | 2021-01-17 | San Diego | California | 6073 | 211850 | 2103 |
933641 | 933641 | 2021-01-16 | San Diego | California | 6073 | 209960 | 2065 |
930396 | 930396 | 2021-01-15 | San Diego | California | 6073 | 206933 | 2037 |
927151 | 927151 | 2021-01-14 | San Diego | California | 6073 | 204238 | 2005 |
923905 | 923905 | 2021-01-13 | San Diego | California | 6073 | 201643 | 1952 |
920660 | 920660 | 2021-01-12 | San Diego | California | 6073 | 198382 | 1898 |
917415 | 917415 | 2021-01-11 | San Diego | California | 6073 | 194858 | 1857 |
914170 | 914170 | 2021-01-10 | San Diego | California | 6073 | 191951 | 1857 |
910925 | 910925 | 2021-01-09 | San Diego | California | 6073 | 188663 | 1824 |
907680 | 907680 | 2021-01-08 | San Diego | California | 6073 | 185125 | 1771 |
904434 | 904434 | 2021-01-07 | San Diego | California | 6073 | 180575 | 1738 |
901189 | 901189 | 2021-01-06 | San Diego | California | 6073 | 176725 | 1691 |
897944 | 897944 | 2021-01-05 | San Diego | California | 6073 | 172910 | 1654 |
894699 | 894699 | 2021-01-04 | San Diego | California | 6073 | 171096 | 1598 |
891452 | 891452 | 2021-01-03 | San Diego | California | 6073 | 168083 | 1592 |
888205 | 888205 | 2021-01-02 | San Diego | California | 6073 | 164563 | 1592 |
884960 | 884960 | 2021-01-01 | San Diego | California | 6073 | 155658 | 1534 |
881715 | 881715 | 2020-12-31 | San Diego | California | 6073 | 155658 | 1534 |
878470 | 878470 | 2020-12-30 | San Diego | California | 6073 | 152575 | 1472 |
875225 | 875225 | 2020-12-29 | San Diego | California | 6073 | 150127 | 1435 |
871980 | 871980 | 2020-12-28 | San Diego | California | 6073 | 147593 | 1404 |
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);