ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where county = "Marin" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193315 | 1193315 | 2021-04-06 | Marin | California | 6041 | 13666 | 221 |
1190065 | 1190065 | 2021-04-05 | Marin | California | 6041 | 13663 | 221 |
1186818 | 1186818 | 2021-04-04 | Marin | California | 6041 | 13658 | 221 |
1183571 | 1183571 | 2021-04-03 | Marin | California | 6041 | 13649 | 221 |
1180324 | 1180324 | 2021-04-02 | Marin | California | 6041 | 13635 | 221 |
1177077 | 1177077 | 2021-04-01 | Marin | California | 6041 | 13624 | 221 |
1173830 | 1173830 | 2021-03-31 | Marin | California | 6041 | 13611 | 221 |
1170583 | 1170583 | 2021-03-30 | Marin | California | 6041 | 13600 | 220 |
1167335 | 1167335 | 2021-03-29 | Marin | California | 6041 | 13594 | 221 |
1164087 | 1164087 | 2021-03-28 | Marin | California | 6041 | 13579 | 222 |
1160839 | 1160839 | 2021-03-27 | Marin | California | 6041 | 13553 | 221 |
1157591 | 1157591 | 2021-03-26 | Marin | California | 6041 | 13538 | 219 |
1154344 | 1154344 | 2021-03-25 | Marin | California | 6041 | 13526 | 219 |
1151097 | 1151097 | 2021-03-24 | Marin | California | 6041 | 13514 | 221 |
1147850 | 1147850 | 2021-03-23 | Marin | California | 6041 | 13501 | 221 |
1144603 | 1144603 | 2021-03-22 | Marin | California | 6041 | 13495 | 220 |
1141356 | 1141356 | 2021-03-21 | Marin | California | 6041 | 13470 | 220 |
1138110 | 1138110 | 2021-03-20 | Marin | California | 6041 | 13441 | 220 |
1134864 | 1134864 | 2021-03-19 | Marin | California | 6041 | 13435 | 219 |
1131617 | 1131617 | 2021-03-18 | Marin | California | 6041 | 13428 | 218 |
1128369 | 1128369 | 2021-03-17 | Marin | California | 6041 | 13419 | 218 |
1125123 | 1125123 | 2021-03-16 | Marin | California | 6041 | 13408 | 218 |
1121877 | 1121877 | 2021-03-15 | Marin | California | 6041 | 13405 | 218 |
1118630 | 1118630 | 2021-03-14 | Marin | California | 6041 | 13391 | 218 |
1115383 | 1115383 | 2021-03-13 | Marin | California | 6041 | 13375 | 218 |
1112137 | 1112137 | 2021-03-12 | Marin | California | 6041 | 13356 | 198 |
1108891 | 1108891 | 2021-03-11 | Marin | California | 6041 | 13348 | 200 |
1105645 | 1105645 | 2021-03-10 | Marin | California | 6041 | 13335 | 199 |
1102399 | 1102399 | 2021-03-09 | Marin | California | 6041 | 13328 | 199 |
1099153 | 1099153 | 2021-03-08 | Marin | California | 6041 | 13313 | 199 |
1095905 | 1095905 | 2021-03-07 | Marin | California | 6041 | 13289 | 198 |
1092659 | 1092659 | 2021-03-06 | Marin | California | 6041 | 13275 | 198 |
1089413 | 1089413 | 2021-03-05 | Marin | California | 6041 | 13240 | 198 |
1086168 | 1086168 | 2021-03-04 | Marin | California | 6041 | 13216 | 198 |
1082922 | 1082922 | 2021-03-03 | Marin | California | 6041 | 13186 | 197 |
1079676 | 1079676 | 2021-03-02 | Marin | California | 6041 | 13161 | 197 |
1076431 | 1076431 | 2021-03-01 | Marin | California | 6041 | 13152 | 197 |
1073185 | 1073185 | 2021-02-28 | Marin | California | 6041 | 13134 | 197 |
1069939 | 1069939 | 2021-02-27 | Marin | California | 6041 | 13091 | 197 |
1066694 | 1066694 | 2021-02-26 | Marin | California | 6041 | 13067 | 197 |
1063449 | 1063449 | 2021-02-25 | Marin | California | 6041 | 13044 | 197 |
1060204 | 1060204 | 2021-02-24 | Marin | California | 6041 | 13015 | 197 |
1056958 | 1056958 | 2021-02-23 | Marin | California | 6041 | 12991 | 195 |
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 |
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);