ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193328 | 1193328 | 2021-04-06 | Sacramento | California | 6067 | 99041 | 1620 |
1190078 | 1190078 | 2021-04-05 | Sacramento | California | 6067 | 98847 | 1617 |
1186831 | 1186831 | 2021-04-04 | Sacramento | California | 6067 | 98659 | 1613 |
1183584 | 1183584 | 2021-04-03 | Sacramento | California | 6067 | 98647 | 1613 |
1180337 | 1180337 | 2021-04-02 | Sacramento | California | 6067 | 98487 | 1613 |
1177090 | 1177090 | 2021-04-01 | Sacramento | California | 6067 | 97882 | 1610 |
1173843 | 1173843 | 2021-03-31 | Sacramento | California | 6067 | 97717 | 1603 |
1170596 | 1170596 | 2021-03-30 | Sacramento | California | 6067 | 97616 | 1603 |
1167348 | 1167348 | 2021-03-29 | Sacramento | California | 6067 | 97480 | 1602 |
1164100 | 1164100 | 2021-03-28 | Sacramento | California | 6067 | 97246 | 1599 |
1160852 | 1160852 | 2021-03-27 | Sacramento | California | 6067 | 97039 | 1599 |
1157604 | 1157604 | 2021-03-26 | Sacramento | California | 6067 | 96989 | 1599 |
1154357 | 1154357 | 2021-03-25 | Sacramento | California | 6067 | 96781 | 1593 |
1151110 | 1151110 | 2021-03-24 | Sacramento | California | 6067 | 96615 | 1590 |
1147863 | 1147863 | 2021-03-23 | Sacramento | California | 6067 | 96504 | 1586 |
1144616 | 1144616 | 2021-03-22 | Sacramento | California | 6067 | 96376 | 1582 |
1141369 | 1141369 | 2021-03-21 | Sacramento | California | 6067 | 96125 | 1576 |
1138123 | 1138123 | 2021-03-20 | Sacramento | California | 6067 | 95963 | 1576 |
1134877 | 1134877 | 2021-03-19 | Sacramento | California | 6067 | 95963 | 1576 |
1131630 | 1131630 | 2021-03-18 | Sacramento | California | 6067 | 95836 | 1565 |
1128382 | 1128382 | 2021-03-17 | Sacramento | California | 6067 | 95666 | 1559 |
1125136 | 1125136 | 2021-03-16 | Sacramento | California | 6067 | 95555 | 1551 |
1121890 | 1121890 | 2021-03-15 | Sacramento | California | 6067 | 95440 | 1548 |
1118643 | 1118643 | 2021-03-14 | Sacramento | California | 6067 | 95191 | 1541 |
1115396 | 1115396 | 2021-03-13 | Sacramento | California | 6067 | 95087 | 1541 |
1112150 | 1112150 | 2021-03-12 | Sacramento | California | 6067 | 95087 | 1541 |
1108904 | 1108904 | 2021-03-11 | Sacramento | California | 6067 | 94906 | 1537 |
1105658 | 1105658 | 2021-03-10 | Sacramento | California | 6067 | 94769 | 1531 |
1102412 | 1102412 | 2021-03-09 | Sacramento | California | 6067 | 94698 | 1525 |
1099166 | 1099166 | 2021-03-08 | Sacramento | California | 6067 | 94560 | 1521 |
1095918 | 1095918 | 2021-03-07 | Sacramento | California | 6067 | 94331 | 1510 |
1092672 | 1092672 | 2021-03-06 | Sacramento | California | 6067 | 94181 | 1510 |
1089426 | 1089426 | 2021-03-05 | Sacramento | California | 6067 | 94128 | 1510 |
1086181 | 1086181 | 2021-03-04 | Sacramento | California | 6067 | 93946 | 1506 |
1082935 | 1082935 | 2021-03-03 | Sacramento | California | 6067 | 93789 | 1498 |
1079689 | 1079689 | 2021-03-02 | Sacramento | California | 6067 | 93677 | 1488 |
1076444 | 1076444 | 2021-03-01 | Sacramento | California | 6067 | 93527 | 1484 |
1073198 | 1073198 | 2021-02-28 | Sacramento | California | 6067 | 93280 | 1472 |
1069952 | 1069952 | 2021-02-27 | Sacramento | California | 6067 | 93179 | 1472 |
1066707 | 1066707 | 2021-02-26 | Sacramento | California | 6067 | 93159 | 1472 |
1063462 | 1063462 | 2021-02-25 | Sacramento | California | 6067 | 92943 | 1464 |
1060217 | 1060217 | 2021-02-24 | Sacramento | California | 6067 | 92771 | 1456 |
1056971 | 1056971 | 2021-02-23 | Sacramento | California | 6067 | 92620 | 1446 |
1053725 | 1053725 | 2021-02-22 | Sacramento | California | 6067 | 92427 | 1438 |
1050478 | 1050478 | 2021-02-21 | Sacramento | California | 6067 | 92056 | 1431 |
1047231 | 1047231 | 2021-02-20 | Sacramento | California | 6067 | 91814 | 1431 |
1043986 | 1043986 | 2021-02-19 | Sacramento | California | 6067 | 91796 | 1431 |
1040741 | 1040741 | 2021-02-18 | Sacramento | California | 6067 | 91392 | 1412 |
1037496 | 1037496 | 2021-02-17 | Sacramento | California | 6067 | 91245 | 1402 |
1034251 | 1034251 | 2021-02-16 | Sacramento | California | 6067 | 91090 | 1382 |
1031005 | 1031005 | 2021-02-15 | Sacramento | California | 6067 | 90855 | 1372 |
1027758 | 1027758 | 2021-02-14 | Sacramento | California | 6067 | 90400 | 1372 |
1024513 | 1024513 | 2021-02-13 | Sacramento | California | 6067 | 90251 | 1372 |
1021268 | 1021268 | 2021-02-12 | Sacramento | California | 6067 | 89987 | 1372 |
1018023 | 1018023 | 2021-02-11 | Sacramento | California | 6067 | 89652 | 1360 |
1014778 | 1014778 | 2021-02-10 | Sacramento | California | 6067 | 89377 | 1352 |
1011533 | 1011533 | 2021-02-09 | Sacramento | California | 6067 | 89266 | 1335 |
1008287 | 1008287 | 2021-02-08 | Sacramento | California | 6067 | 88918 | 1318 |
1005041 | 1005041 | 2021-02-07 | Sacramento | California | 6067 | 88531 | 1302 |
1001795 | 1001795 | 2021-02-06 | Sacramento | California | 6067 | 87991 | 1302 |
998549 | 998549 | 2021-02-05 | Sacramento | California | 6067 | 87703 | 1302 |
995303 | 995303 | 2021-02-04 | Sacramento | California | 6067 | 87414 | 1288 |
992057 | 992057 | 2021-02-03 | Sacramento | California | 6067 | 87106 | 1281 |
988811 | 988811 | 2021-02-02 | Sacramento | California | 6067 | 86855 | 1271 |
985564 | 985564 | 2021-02-01 | Sacramento | California | 6067 | 86559 | 1262 |
982317 | 982317 | 2021-01-31 | Sacramento | California | 6067 | 86387 | 1239 |
979071 | 979071 | 2021-01-30 | Sacramento | California | 6067 | 86319 | 1239 |
975826 | 975826 | 2021-01-29 | Sacramento | California | 6067 | 85697 | 1239 |
972581 | 972581 | 2021-01-28 | Sacramento | California | 6067 | 85427 | 1216 |
969336 | 969336 | 2021-01-27 | Sacramento | California | 6067 | 85061 | 1208 |
966092 | 966092 | 2021-01-26 | Sacramento | California | 6067 | 84652 | 1194 |
962847 | 962847 | 2021-01-25 | Sacramento | California | 6067 | 84109 | 1185 |
959602 | 959602 | 2021-01-24 | Sacramento | California | 6067 | 83407 | 1157 |
956356 | 956356 | 2021-01-23 | Sacramento | California | 6067 | 82860 | 1157 |
953111 | 953111 | 2021-01-22 | Sacramento | California | 6067 | 82302 | 1157 |
949866 | 949866 | 2021-01-21 | Sacramento | California | 6067 | 81686 | 1145 |
946620 | 946620 | 2021-01-20 | Sacramento | California | 6067 | 81182 | 1128 |
943373 | 943373 | 2021-01-19 | Sacramento | California | 6067 | 80677 | 1111 |
940128 | 940128 | 2021-01-18 | Sacramento | California | 6067 | 80153 | 1080 |
936883 | 936883 | 2021-01-17 | Sacramento | California | 6067 | 79121 | 1080 |
933638 | 933638 | 2021-01-16 | Sacramento | California | 6067 | 80278 | 1080 |
930393 | 930393 | 2021-01-15 | Sacramento | California | 6067 | 79136 | 1080 |
927148 | 927148 | 2021-01-14 | Sacramento | California | 6067 | 78267 | 1062 |
923902 | 923902 | 2021-01-13 | Sacramento | California | 6067 | 77200 | 1044 |
920657 | 920657 | 2021-01-12 | Sacramento | California | 6067 | 76008 | 1031 |
917412 | 917412 | 2021-01-11 | Sacramento | California | 6067 | 75393 | 1015 |
914167 | 914167 | 2021-01-10 | Sacramento | California | 6067 | 74481 | 977 |
910922 | 910922 | 2021-01-09 | Sacramento | California | 6067 | 73244 | 977 |
907677 | 907677 | 2021-01-08 | Sacramento | California | 6067 | 72341 | 977 |
904431 | 904431 | 2021-01-07 | Sacramento | California | 6067 | 71571 | 955 |
901186 | 901186 | 2021-01-06 | Sacramento | California | 6067 | 70676 | 941 |
897941 | 897941 | 2021-01-05 | Sacramento | California | 6067 | 70163 | 917 |
894696 | 894696 | 2021-01-04 | Sacramento | California | 6067 | 69110 | 898 |
891449 | 891449 | 2021-01-03 | Sacramento | California | 6067 | 67809 | 857 |
888202 | 888202 | 2021-01-02 | Sacramento | California | 6067 | 66955 | 857 |
884957 | 884957 | 2021-01-01 | Sacramento | California | 6067 | 65816 | 857 |
881712 | 881712 | 2020-12-31 | Sacramento | California | 6067 | 65540 | 857 |
878467 | 878467 | 2020-12-30 | Sacramento | California | 6067 | 65077 | 844 |
875222 | 875222 | 2020-12-29 | Sacramento | California | 6067 | 64321 | 833 |
871977 | 871977 | 2020-12-28 | Sacramento | California | 6067 | 63415 | 827 |
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);