ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053712 | 1053712 | 2021-02-22 | Marin | California | 6041 | 12968 | 195 |
1050465 | 1050465 | 2021-02-21 | Marin | California | 6041 | 12945 | 194 |
1047218 | 1047218 | 2021-02-20 | Marin | California | 6041 | 12919 | 194 |
1043973 | 1043973 | 2021-02-19 | Marin | California | 6041 | 12895 | 192 |
1040728 | 1040728 | 2021-02-18 | Marin | California | 6041 | 12881 | 192 |
1037483 | 1037483 | 2021-02-17 | Marin | California | 6041 | 12832 | 188 |
1034238 | 1034238 | 2021-02-16 | Marin | California | 6041 | 12810 | 187 |
1030992 | 1030992 | 2021-02-15 | Marin | California | 6041 | 12784 | 184 |
1027745 | 1027745 | 2021-02-14 | Marin | California | 6041 | 12757 | 184 |
1024500 | 1024500 | 2021-02-13 | Marin | California | 6041 | 12720 | 184 |
1021255 | 1021255 | 2021-02-12 | Marin | California | 6041 | 12682 | 182 |
1018010 | 1018010 | 2021-02-11 | Marin | California | 6041 | 12651 | 181 |
1014765 | 1014765 | 2021-02-10 | Marin | California | 6041 | 12623 | 181 |
1011520 | 1011520 | 2021-02-09 | Marin | California | 6041 | 12591 | 176 |
1008274 | 1008274 | 2021-02-08 | Marin | California | 6041 | 12571 | 176 |
1005028 | 1005028 | 2021-02-07 | Marin | California | 6041 | 12531 | 176 |
1001782 | 1001782 | 2021-02-06 | Marin | California | 6041 | 12479 | 176 |
998536 | 998536 | 2021-02-05 | Marin | California | 6041 | 12431 | 174 |
995290 | 995290 | 2021-02-04 | Marin | California | 6041 | 12406 | 174 |
992044 | 992044 | 2021-02-03 | Marin | California | 6041 | 12367 | 174 |
988798 | 988798 | 2021-02-02 | Marin | California | 6041 | 12341 | 173 |
985551 | 985551 | 2021-02-01 | Marin | California | 6041 | 12297 | 172 |
982304 | 982304 | 2021-01-31 | Marin | California | 6041 | 12344 | 172 |
979058 | 979058 | 2021-01-30 | Marin | California | 6041 | 12282 | 172 |
975813 | 975813 | 2021-01-29 | Marin | California | 6041 | 12223 | 172 |
972568 | 972568 | 2021-01-28 | Marin | California | 6041 | 12155 | 170 |
969323 | 969323 | 2021-01-27 | Marin | California | 6041 | 12113 | 166 |
966079 | 966079 | 2021-01-26 | Marin | California | 6041 | 12064 | 165 |
962834 | 962834 | 2021-01-25 | Marin | California | 6041 | 12012 | 163 |
959589 | 959589 | 2021-01-24 | Marin | California | 6041 | 11953 | 163 |
956343 | 956343 | 2021-01-23 | Marin | California | 6041 | 11933 | 163 |
953098 | 953098 | 2021-01-22 | Marin | California | 6041 | 11899 | 163 |
949853 | 949853 | 2021-01-21 | Marin | California | 6041 | 11808 | 159 |
946607 | 946607 | 2021-01-20 | Marin | California | 6041 | 11726 | 157 |
943360 | 943360 | 2021-01-19 | Marin | California | 6041 | 11691 | 154 |
940115 | 940115 | 2021-01-18 | Marin | California | 6041 | 11627 | 153 |
936870 | 936870 | 2021-01-17 | Marin | California | 6041 | 11569 | 153 |
933625 | 933625 | 2021-01-16 | Marin | California | 6041 | 11463 | 153 |
930380 | 930380 | 2021-01-15 | Marin | California | 6041 | 11214 | 149 |
927135 | 927135 | 2021-01-14 | Marin | California | 6041 | 11214 | 148 |
923889 | 923889 | 2021-01-13 | Marin | California | 6041 | 11126 | 146 |
920644 | 920644 | 2021-01-12 | Marin | California | 6041 | 11042 | 145 |
917399 | 917399 | 2021-01-11 | Marin | California | 6041 | 10928 | 144 |
914154 | 914154 | 2021-01-10 | Marin | California | 6041 | 10810 | 143 |
910909 | 910909 | 2021-01-09 | Marin | California | 6041 | 10696 | 143 |
907664 | 907664 | 2021-01-08 | Marin | California | 6041 | 10588 | 143 |
904418 | 904418 | 2021-01-07 | Marin | California | 6041 | 10468 | 143 |
901173 | 901173 | 2021-01-06 | Marin | California | 6041 | 10346 | 143 |
897928 | 897928 | 2021-01-05 | Marin | California | 6041 | 10286 | 140 |
894683 | 894683 | 2021-01-04 | Marin | California | 6041 | 10121 | 139 |
891436 | 891436 | 2021-01-03 | Marin | California | 6041 | 10121 | 139 |
888189 | 888189 | 2021-01-02 | Marin | California | 6041 | 10024 | 139 |
884944 | 884944 | 2021-01-01 | Marin | California | 6041 | 9902 | 139 |
881699 | 881699 | 2020-12-31 | Marin | California | 6041 | 9800 | 139 |
878454 | 878454 | 2020-12-30 | Marin | California | 6041 | 9730 | 139 |
875209 | 875209 | 2020-12-29 | Marin | California | 6041 | 9663 | 138 |
871964 | 871964 | 2020-12-28 | Marin | California | 6041 | 9616 | 138 |
868719 | 868719 | 2020-12-27 | Marin | California | 6041 | 9569 | 136 |
865474 | 865474 | 2020-12-26 | Marin | California | 6041 | 9505 | 136 |
862229 | 862229 | 2020-12-25 | Marin | California | 6041 | 9449 | 136 |
858984 | 858984 | 2020-12-24 | Marin | California | 6041 | 9360 | 136 |
855739 | 855739 | 2020-12-23 | Marin | California | 6041 | 9306 | 136 |
852494 | 852494 | 2020-12-22 | Marin | California | 6041 | 9205 | 136 |
849249 | 849249 | 2020-12-21 | Marin | California | 6041 | 9132 | 136 |
846004 | 846004 | 2020-12-20 | Marin | California | 6041 | 9020 | 136 |
842758 | 842758 | 2020-12-19 | Marin | California | 6041 | 8902 | 136 |
839513 | 839513 | 2020-12-18 | Marin | California | 6041 | 8851 | 136 |
836268 | 836268 | 2020-12-17 | Marin | California | 6041 | 8803 | 136 |
833022 | 833022 | 2020-12-16 | Marin | California | 6041 | 8752 | 136 |
829775 | 829775 | 2020-12-15 | Marin | California | 6041 | 8616 | 134 |
826529 | 826529 | 2020-12-14 | Marin | California | 6041 | 8538 | 134 |
823282 | 823282 | 2020-12-13 | Marin | California | 6041 | 8491 | 132 |
820036 | 820036 | 2020-12-12 | Marin | California | 6041 | 8411 | 132 |
816790 | 816790 | 2020-12-11 | Marin | California | 6041 | 8362 | 132 |
813544 | 813544 | 2020-12-10 | Marin | California | 6041 | 8314 | 132 |
810300 | 810300 | 2020-12-09 | Marin | California | 6041 | 8252 | 132 |
807055 | 807055 | 2020-12-08 | Marin | California | 6041 | 8195 | 132 |
803810 | 803810 | 2020-12-07 | Marin | California | 6041 | 8105 | 132 |
800565 | 800565 | 2020-12-06 | Marin | California | 6041 | 8067 | 131 |
797320 | 797320 | 2020-12-05 | Marin | California | 6041 | 8020 | 131 |
794075 | 794075 | 2020-12-04 | Marin | California | 6041 | 7966 | 130 |
790830 | 790830 | 2020-12-03 | Marin | California | 6041 | 7895 | 129 |
787585 | 787585 | 2020-12-02 | Marin | California | 6041 | 7873 | 129 |
784341 | 784341 | 2020-12-01 | Marin | California | 6041 | 7840 | 129 |
781096 | 781096 | 2020-11-30 | Marin | California | 6041 | 7808 | 129 |
777850 | 777850 | 2020-11-29 | Marin | California | 6041 | 7775 | 129 |
774605 | 774605 | 2020-11-28 | Marin | California | 6041 | 7753 | 129 |
771360 | 771360 | 2020-11-27 | Marin | California | 6041 | 7702 | 129 |
768115 | 768115 | 2020-11-26 | Marin | California | 6041 | 7670 | 129 |
764869 | 764869 | 2020-11-25 | Marin | California | 6041 | 7629 | 129 |
761624 | 761624 | 2020-11-24 | Marin | California | 6041 | 7622 | 128 |
758379 | 758379 | 2020-11-23 | Marin | California | 6041 | 7596 | 128 |
755132 | 755132 | 2020-11-22 | Marin | California | 6041 | 7560 | 128 |
751886 | 751886 | 2020-11-21 | Marin | California | 6041 | 7518 | 128 |
748640 | 748640 | 2020-11-20 | Marin | California | 6041 | 7506 | 128 |
745394 | 745394 | 2020-11-19 | Marin | California | 6041 | 7489 | 128 |
742147 | 742147 | 2020-11-18 | Marin | California | 6041 | 7467 | 128 |
738900 | 738900 | 2020-11-17 | Marin | California | 6041 | 7448 | 128 |
735656 | 735656 | 2020-11-16 | Marin | California | 6041 | 7409 | 127 |
732410 | 732410 | 2020-11-15 | Marin | California | 6041 | 7378 | 127 |
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);