ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 6113 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193351 | 1193351 | 2021-04-06 | Yolo | California | 6113 | 13427 | 198 |
1190101 | 1190101 | 2021-04-05 | Yolo | California | 6113 | 13425 | 198 |
1186854 | 1186854 | 2021-04-04 | Yolo | California | 6113 | 13414 | 198 |
1183607 | 1183607 | 2021-04-03 | Yolo | California | 6113 | 13381 | 198 |
1180360 | 1180360 | 2021-04-02 | Yolo | California | 6113 | 13342 | 198 |
1177113 | 1177113 | 2021-04-01 | Yolo | California | 6113 | 13359 | 198 |
1173866 | 1173866 | 2021-03-31 | Yolo | California | 6113 | 13353 | 198 |
1170619 | 1170619 | 2021-03-30 | Yolo | California | 6113 | 13346 | 196 |
1167371 | 1167371 | 2021-03-29 | Yolo | California | 6113 | 13325 | 196 |
1164123 | 1164123 | 2021-03-28 | Yolo | California | 6113 | 13317 | 196 |
1160875 | 1160875 | 2021-03-27 | Yolo | California | 6113 | 13299 | 196 |
1157627 | 1157627 | 2021-03-26 | Yolo | California | 6113 | 13287 | 196 |
1154380 | 1154380 | 2021-03-25 | Yolo | California | 6113 | 13269 | 196 |
1151133 | 1151133 | 2021-03-24 | Yolo | California | 6113 | 13255 | 196 |
1147886 | 1147886 | 2021-03-23 | Yolo | California | 6113 | 13243 | 196 |
1144639 | 1144639 | 2021-03-22 | Yolo | California | 6113 | 13235 | 191 |
1141392 | 1141392 | 2021-03-21 | Yolo | California | 6113 | 13226 | 191 |
1138146 | 1138146 | 2021-03-20 | Yolo | California | 6113 | 13197 | 191 |
1134900 | 1134900 | 2021-03-19 | Yolo | California | 6113 | 13183 | 191 |
1131653 | 1131653 | 2021-03-18 | Yolo | California | 6113 | 13169 | 192 |
1128405 | 1128405 | 2021-03-17 | Yolo | California | 6113 | 13162 | 190 |
1125159 | 1125159 | 2021-03-16 | Yolo | California | 6113 | 13131 | 190 |
1121913 | 1121913 | 2021-03-15 | Yolo | California | 6113 | 13128 | 190 |
1118666 | 1118666 | 2021-03-14 | Yolo | California | 6113 | 13087 | 190 |
1115419 | 1115419 | 2021-03-13 | Yolo | California | 6113 | 13061 | 190 |
1112173 | 1112173 | 2021-03-12 | Yolo | California | 6113 | 13041 | 190 |
1108927 | 1108927 | 2021-03-11 | Yolo | California | 6113 | 13021 | 190 |
1105681 | 1105681 | 2021-03-10 | Yolo | California | 6113 | 13015 | 189 |
1102435 | 1102435 | 2021-03-09 | Yolo | California | 6113 | 13000 | 186 |
1099189 | 1099189 | 2021-03-08 | Yolo | California | 6113 | 12988 | 186 |
1095941 | 1095941 | 2021-03-07 | Yolo | California | 6113 | 12951 | 185 |
1092695 | 1092695 | 2021-03-06 | Yolo | California | 6113 | 12920 | 185 |
1089449 | 1089449 | 2021-03-05 | Yolo | California | 6113 | 12895 | 185 |
1086204 | 1086204 | 2021-03-04 | Yolo | California | 6113 | 12890 | 185 |
1082958 | 1082958 | 2021-03-03 | Yolo | California | 6113 | 12867 | 185 |
1079712 | 1079712 | 2021-03-02 | Yolo | California | 6113 | 12854 | 185 |
1076467 | 1076467 | 2021-03-01 | Yolo | California | 6113 | 12851 | 185 |
1073221 | 1073221 | 2021-02-28 | Yolo | California | 6113 | 12834 | 185 |
1069975 | 1069975 | 2021-02-27 | Yolo | California | 6113 | 12816 | 185 |
1066730 | 1066730 | 2021-02-26 | Yolo | California | 6113 | 12787 | 185 |
1063485 | 1063485 | 2021-02-25 | Yolo | California | 6113 | 12760 | 185 |
1060240 | 1060240 | 2021-02-24 | Yolo | California | 6113 | 12729 | 185 |
1056994 | 1056994 | 2021-02-23 | Yolo | California | 6113 | 12689 | 185 |
1053748 | 1053748 | 2021-02-22 | Yolo | California | 6113 | 12670 | 181 |
1050501 | 1050501 | 2021-02-21 | Yolo | California | 6113 | 12639 | 181 |
1047254 | 1047254 | 2021-02-20 | Yolo | California | 6113 | 12606 | 181 |
1044009 | 1044009 | 2021-02-19 | Yolo | California | 6113 | 12549 | 181 |
1040764 | 1040764 | 2021-02-18 | Yolo | California | 6113 | 12506 | 181 |
1037519 | 1037519 | 2021-02-17 | Yolo | California | 6113 | 12457 | 181 |
1034274 | 1034274 | 2021-02-16 | Yolo | California | 6113 | 12412 | 172 |
1031028 | 1031028 | 2021-02-15 | Yolo | California | 6113 | 12399 | 172 |
1027781 | 1027781 | 2021-02-14 | Yolo | California | 6113 | 12374 | 172 |
1024536 | 1024536 | 2021-02-13 | Yolo | California | 6113 | 12340 | 172 |
1021291 | 1021291 | 2021-02-12 | Yolo | California | 6113 | 12303 | 172 |
1018046 | 1018046 | 2021-02-11 | Yolo | California | 6113 | 12276 | 172 |
1014801 | 1014801 | 2021-02-10 | Yolo | California | 6113 | 12220 | 172 |
1011556 | 1011556 | 2021-02-09 | Yolo | California | 6113 | 12169 | 170 |
1008310 | 1008310 | 2021-02-08 | Yolo | California | 6113 | 12135 | 158 |
1005064 | 1005064 | 2021-02-07 | Yolo | California | 6113 | 12061 | 158 |
1001818 | 1001818 | 2021-02-06 | Yolo | California | 6113 | 12025 | 158 |
998572 | 998572 | 2021-02-05 | Yolo | California | 6113 | 11982 | 158 |
995326 | 995326 | 2021-02-04 | Yolo | California | 6113 | 11933 | 158 |
992080 | 992080 | 2021-02-03 | Yolo | California | 6113 | 11886 | 158 |
988834 | 988834 | 2021-02-02 | Yolo | California | 6113 | 11824 | 156 |
985587 | 985587 | 2021-02-01 | Yolo | California | 6113 | 11771 | 149 |
982340 | 982340 | 2021-01-31 | Yolo | California | 6113 | 11698 | 149 |
979094 | 979094 | 2021-01-30 | Yolo | California | 6113 | 11612 | 149 |
975849 | 975849 | 2021-01-29 | Yolo | California | 6113 | 11500 | 149 |
972604 | 972604 | 2021-01-28 | Yolo | California | 6113 | 11427 | 149 |
969359 | 969359 | 2021-01-27 | Yolo | California | 6113 | 11361 | 147 |
966115 | 966115 | 2021-01-26 | Yolo | California | 6113 | 11276 | 146 |
962870 | 962870 | 2021-01-25 | Yolo | California | 6113 | 11210 | 138 |
959625 | 959625 | 2021-01-24 | Yolo | California | 6113 | 11087 | 138 |
956379 | 956379 | 2021-01-23 | Yolo | California | 6113 | 11014 | 138 |
953134 | 953134 | 2021-01-22 | Yolo | California | 6113 | 10940 | 138 |
949889 | 949889 | 2021-01-21 | Yolo | California | 6113 | 10852 | 138 |
946643 | 946643 | 2021-01-20 | Yolo | California | 6113 | 10789 | 138 |
943396 | 943396 | 2021-01-19 | Yolo | California | 6113 | 10620 | 131 |
940151 | 940151 | 2021-01-18 | Yolo | California | 6113 | 10519 | 131 |
936906 | 936906 | 2021-01-17 | Yolo | California | 6113 | 10406 | 131 |
933661 | 933661 | 2021-01-16 | Yolo | California | 6113 | 10240 | 131 |
930416 | 930416 | 2021-01-15 | Yolo | California | 6113 | 10097 | 131 |
927171 | 927171 | 2021-01-14 | Yolo | California | 6113 | 9933 | 131 |
923925 | 923925 | 2021-01-13 | Yolo | California | 6113 | 9857 | 131 |
920680 | 920680 | 2021-01-12 | Yolo | California | 6113 | 9699 | 130 |
917435 | 917435 | 2021-01-11 | Yolo | California | 6113 | 9610 | 127 |
914190 | 914190 | 2021-01-10 | Yolo | California | 6113 | 9524 | 127 |
910945 | 910945 | 2021-01-09 | Yolo | California | 6113 | 9391 | 127 |
907700 | 907700 | 2021-01-08 | Yolo | California | 6113 | 9207 | 127 |
904454 | 904454 | 2021-01-07 | Yolo | California | 6113 | 9083 | 126 |
901209 | 901209 | 2021-01-06 | Yolo | California | 6113 | 8980 | 125 |
897964 | 897964 | 2021-01-05 | Yolo | California | 6113 | 8834 | 123 |
894719 | 894719 | 2021-01-04 | Yolo | California | 6113 | 8673 | 117 |
891472 | 891472 | 2021-01-03 | Yolo | California | 6113 | 8571 | 117 |
888225 | 888225 | 2021-01-02 | Yolo | California | 6113 | 8461 | 117 |
884980 | 884980 | 2021-01-01 | Yolo | California | 6113 | 8295 | 111 |
881735 | 881735 | 2020-12-31 | Yolo | California | 6113 | 8238 | 111 |
878490 | 878490 | 2020-12-30 | Yolo | California | 6113 | 8124 | 109 |
875245 | 875245 | 2020-12-29 | Yolo | California | 6113 | 8031 | 109 |
872000 | 872000 | 2020-12-28 | Yolo | California | 6113 | 7919 | 109 |
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);