ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193295 | 1193295 | 2021-04-06 | Alameda | California | 6001 | 84028 | 1432 |
1190045 | 1190045 | 2021-04-05 | Alameda | California | 6001 | 83972 | 1426 |
1186798 | 1186798 | 2021-04-04 | Alameda | California | 6001 | 83882 | 1426 |
1183551 | 1183551 | 2021-04-03 | Alameda | California | 6001 | 83797 | 1425 |
1180304 | 1180304 | 2021-04-02 | Alameda | California | 6001 | 83595 | 1425 |
1177057 | 1177057 | 2021-04-01 | Alameda | California | 6001 | 83496 | 1423 |
1173810 | 1173810 | 2021-03-31 | Alameda | California | 6001 | 83416 | 1423 |
1170563 | 1170563 | 2021-03-30 | Alameda | California | 6001 | 83359 | 1401 |
1167315 | 1167315 | 2021-03-29 | Alameda | California | 6001 | 83264 | 1399 |
1164067 | 1164067 | 2021-03-28 | Alameda | California | 6001 | 83190 | 1395 |
1160819 | 1160819 | 2021-03-27 | Alameda | California | 6001 | 83064 | 1395 |
1157571 | 1157571 | 2021-03-26 | Alameda | California | 6001 | 82966 | 1395 |
1154324 | 1154324 | 2021-03-25 | Alameda | California | 6001 | 82892 | 1392 |
1151077 | 1151077 | 2021-03-24 | Alameda | California | 6001 | 82839 | 1377 |
1147830 | 1147830 | 2021-03-23 | Alameda | California | 6001 | 82769 | 1370 |
1144583 | 1144583 | 2021-03-22 | Alameda | California | 6001 | 82705 | 1369 |
1141336 | 1141336 | 2021-03-21 | Alameda | California | 6001 | 82635 | 1369 |
1138090 | 1138090 | 2021-03-20 | Alameda | California | 6001 | 82561 | 1356 |
1134844 | 1134844 | 2021-03-19 | Alameda | California | 6001 | 82481 | 1366 |
1131597 | 1131597 | 2021-03-18 | Alameda | California | 6001 | 82389 | 1366 |
1128349 | 1128349 | 2021-03-17 | Alameda | California | 6001 | 82280 | 1358 |
1125103 | 1125103 | 2021-03-16 | Alameda | California | 6001 | 82189 | 1330 |
1121857 | 1121857 | 2021-03-15 | Alameda | California | 6001 | 82137 | 1328 |
1118610 | 1118610 | 2021-03-14 | Alameda | California | 6001 | 82055 | 1329 |
1115363 | 1115363 | 2021-03-13 | Alameda | California | 6001 | 81990 | 1325 |
1112117 | 1112117 | 2021-03-12 | Alameda | California | 6001 | 81887 | 1327 |
1108871 | 1108871 | 2021-03-11 | Alameda | California | 6001 | 81768 | 1324 |
1105625 | 1105625 | 2021-03-10 | Alameda | California | 6001 | 81679 | 1311 |
1102379 | 1102379 | 2021-03-09 | Alameda | California | 6001 | 81594 | 1301 |
1099133 | 1099133 | 2021-03-08 | Alameda | California | 6001 | 81454 | 1293 |
1095885 | 1095885 | 2021-03-07 | Alameda | California | 6001 | 81366 | 1292 |
1092639 | 1092639 | 2021-03-06 | Alameda | California | 6001 | 81276 | 1289 |
1089393 | 1089393 | 2021-03-05 | Alameda | California | 6001 | 81189 | 1285 |
1086148 | 1086148 | 2021-03-04 | Alameda | California | 6001 | 81107 | 1281 |
1082902 | 1082902 | 2021-03-03 | Alameda | California | 6001 | 80971 | 1271 |
1079656 | 1079656 | 2021-03-02 | Alameda | California | 6001 | 80894 | 1244 |
1076411 | 1076411 | 2021-03-01 | Alameda | California | 6001 | 80798 | 1242 |
1073165 | 1073165 | 2021-02-28 | Alameda | California | 6001 | 80689 | 1242 |
1069919 | 1069919 | 2021-02-27 | Alameda | California | 6001 | 80517 | 1241 |
1066674 | 1066674 | 2021-02-26 | Alameda | California | 6001 | 80300 | 1241 |
1063429 | 1063429 | 2021-02-25 | Alameda | California | 6001 | 80109 | 1224 |
1060184 | 1060184 | 2021-02-24 | Alameda | California | 6001 | 79969 | 1218 |
1056938 | 1056938 | 2021-02-23 | Alameda | California | 6001 | 79817 | 1200 |
1053692 | 1053692 | 2021-02-22 | Alameda | California | 6001 | 79670 | 1200 |
1050445 | 1050445 | 2021-02-21 | Alameda | California | 6001 | 79560 | 1200 |
1047198 | 1047198 | 2021-02-20 | Alameda | California | 6001 | 79492 | 1175 |
1043953 | 1043953 | 2021-02-19 | Alameda | California | 6001 | 79318 | 1171 |
1040708 | 1040708 | 2021-02-18 | Alameda | California | 6001 | 79113 | 1126 |
1037463 | 1037463 | 2021-02-17 | Alameda | California | 6001 | 79037 | 1125 |
1034218 | 1034218 | 2021-02-16 | Alameda | California | 6001 | 78904 | 1122 |
1030972 | 1030972 | 2021-02-15 | Alameda | California | 6001 | 78735 | 1121 |
1027725 | 1027725 | 2021-02-14 | Alameda | California | 6001 | 78377 | 1120 |
1024480 | 1024480 | 2021-02-13 | Alameda | California | 6001 | 78306 | 1120 |
1021235 | 1021235 | 2021-02-12 | Alameda | California | 6001 | 77947 | 1088 |
1017990 | 1017990 | 2021-02-11 | Alameda | California | 6001 | 77653 | 1064 |
1014745 | 1014745 | 2021-02-10 | Alameda | California | 6001 | 77237 | 1063 |
1011500 | 1011500 | 2021-02-09 | Alameda | California | 6001 | 77130 | 1051 |
1008254 | 1008254 | 2021-02-08 | Alameda | California | 6001 | 76669 | 1041 |
1005008 | 1005008 | 2021-02-07 | Alameda | California | 6001 | 76191 | 1041 |
1001762 | 1001762 | 2021-02-06 | Alameda | California | 6001 | 75758 | 1037 |
998516 | 998516 | 2021-02-05 | Alameda | California | 6001 | 75443 | 1030 |
995270 | 995270 | 2021-02-04 | Alameda | California | 6001 | 75196 | 1021 |
992024 | 992024 | 2021-02-03 | Alameda | California | 6001 | 74980 | 999 |
988778 | 988778 | 2021-02-02 | Alameda | California | 6001 | 74682 | 991 |
985531 | 985531 | 2021-02-01 | Alameda | California | 6001 | 74108 | 982 |
982284 | 982284 | 2021-01-31 | Alameda | California | 6001 | 73792 | 980 |
979038 | 979038 | 2021-01-30 | Alameda | California | 6001 | 73563 | 974 |
975793 | 975793 | 2021-01-29 | Alameda | California | 6001 | 73136 | 959 |
972548 | 972548 | 2021-01-28 | Alameda | California | 6001 | 72618 | 937 |
969303 | 969303 | 2021-01-27 | Alameda | California | 6001 | 72045 | 929 |
966059 | 966059 | 2021-01-26 | Alameda | California | 6001 | 71319 | 906 |
962814 | 962814 | 2021-01-25 | Alameda | California | 6001 | 70844 | 896 |
959569 | 959569 | 2021-01-24 | Alameda | California | 6001 | 70355 | 894 |
956323 | 956323 | 2021-01-23 | Alameda | California | 6001 | 69714 | 886 |
953078 | 953078 | 2021-01-22 | Alameda | California | 6001 | 69575 | 856 |
949833 | 949833 | 2021-01-21 | Alameda | California | 6001 | 69128 | 842 |
946587 | 946587 | 2021-01-20 | Alameda | California | 6001 | 68670 | 788 |
943340 | 943340 | 2021-01-19 | Alameda | California | 6001 | 67973 | 765 |
940095 | 940095 | 2021-01-18 | Alameda | California | 6001 | 67396 | 764 |
936850 | 936850 | 2021-01-17 | Alameda | California | 6001 | 66604 | 757 |
933605 | 933605 | 2021-01-16 | Alameda | California | 6001 | 65700 | 757 |
930360 | 930360 | 2021-01-15 | Alameda | California | 6001 | 64781 | 768 |
927115 | 927115 | 2021-01-14 | Alameda | California | 6001 | 63887 | 776 |
923869 | 923869 | 2021-01-13 | Alameda | California | 6001 | 62964 | 776 |
920624 | 920624 | 2021-01-12 | Alameda | California | 6001 | 62067 | 763 |
917379 | 917379 | 2021-01-11 | Alameda | California | 6001 | 61132 | 736 |
914134 | 914134 | 2021-01-10 | Alameda | California | 6001 | 60146 | 732 |
910889 | 910889 | 2021-01-09 | Alameda | California | 6001 | 59193 | 732 |
907644 | 907644 | 2021-01-08 | Alameda | California | 6001 | 57942 | 729 |
904398 | 904398 | 2021-01-07 | Alameda | California | 6001 | 57102 | 713 |
901153 | 901153 | 2021-01-06 | Alameda | California | 6001 | 56453 | 697 |
897908 | 897908 | 2021-01-05 | Alameda | California | 6001 | 55920 | 681 |
894663 | 894663 | 2021-01-04 | Alameda | California | 6001 | 55094 | 656 |
891416 | 891416 | 2021-01-03 | Alameda | California | 6001 | 54539 | 656 |
888169 | 888169 | 2021-01-02 | Alameda | California | 6001 | 53539 | 656 |
884924 | 884924 | 2021-01-01 | Alameda | California | 6001 | 52496 | 657 |
881679 | 881679 | 2020-12-31 | Alameda | California | 6001 | 51611 | 657 |
878434 | 878434 | 2020-12-30 | Alameda | California | 6001 | 50967 | 625 |
875189 | 875189 | 2020-12-29 | Alameda | California | 6001 | 50426 | 625 |
871944 | 871944 | 2020-12-28 | Alameda | California | 6001 | 49817 | 625 |
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);