ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Clay" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193440 | 1193440 | 2021-04-06 | Clay | Florida | 12019 | 17496 | 329 |
1190190 | 1190190 | 2021-04-05 | Clay | Florida | 12019 | 17480 | 329 |
1186943 | 1186943 | 2021-04-04 | Clay | Florida | 12019 | 17462 | 329 |
1183696 | 1183696 | 2021-04-03 | Clay | Florida | 12019 | 17447 | 329 |
1180449 | 1180449 | 2021-04-02 | Clay | Florida | 12019 | 17414 | 329 |
1177202 | 1177202 | 2021-04-01 | Clay | Florida | 12019 | 17390 | 329 |
1173955 | 1173955 | 2021-03-31 | Clay | Florida | 12019 | 17368 | 329 |
1170708 | 1170708 | 2021-03-30 | Clay | Florida | 12019 | 17347 | 325 |
1167460 | 1167460 | 2021-03-29 | Clay | Florida | 12019 | 17328 | 325 |
1164212 | 1164212 | 2021-03-28 | Clay | Florida | 12019 | 17315 | 325 |
1160964 | 1160964 | 2021-03-27 | Clay | Florida | 12019 | 17291 | 325 |
1157716 | 1157716 | 2021-03-26 | Clay | Florida | 12019 | 17269 | 325 |
1154469 | 1154469 | 2021-03-25 | Clay | Florida | 12019 | 17245 | 325 |
1151222 | 1151222 | 2021-03-24 | Clay | Florida | 12019 | 17216 | 325 |
1147975 | 1147975 | 2021-03-23 | Clay | Florida | 12019 | 17192 | 325 |
1144728 | 1144728 | 2021-03-22 | Clay | Florida | 12019 | 17170 | 325 |
1141481 | 1141481 | 2021-03-21 | Clay | Florida | 12019 | 17146 | 325 |
1138235 | 1138235 | 2021-03-20 | Clay | Florida | 12019 | 17118 | 325 |
1134989 | 1134989 | 2021-03-19 | Clay | Florida | 12019 | 17084 | 325 |
1131742 | 1131742 | 2021-03-18 | Clay | Florida | 12019 | 17063 | 323 |
1128494 | 1128494 | 2021-03-17 | Clay | Florida | 12019 | 17042 | 318 |
1125248 | 1125248 | 2021-03-16 | Clay | Florida | 12019 | 17019 | 318 |
1122002 | 1122002 | 2021-03-15 | Clay | Florida | 12019 | 17005 | 318 |
1118755 | 1118755 | 2021-03-14 | Clay | Florida | 12019 | 17002 | 318 |
1115508 | 1115508 | 2021-03-13 | Clay | Florida | 12019 | 16988 | 318 |
1112262 | 1112262 | 2021-03-12 | Clay | Florida | 12019 | 16961 | 324 |
1109016 | 1109016 | 2021-03-11 | Clay | Florida | 12019 | 16943 | 322 |
1105770 | 1105770 | 2021-03-10 | Clay | Florida | 12019 | 16929 | 315 |
1102524 | 1102524 | 2021-03-09 | Clay | Florida | 12019 | 16906 | 315 |
1099278 | 1099278 | 2021-03-08 | Clay | Florida | 12019 | 16880 | 315 |
1096030 | 1096030 | 2021-03-07 | Clay | Florida | 12019 | 16867 | 315 |
1092784 | 1092784 | 2021-03-06 | Clay | Florida | 12019 | 16845 | 315 |
1089538 | 1089538 | 2021-03-05 | Clay | Florida | 12019 | 16818 | 315 |
1086293 | 1086293 | 2021-03-04 | Clay | Florida | 12019 | 16805 | 315 |
1083047 | 1083047 | 2021-03-03 | Clay | Florida | 12019 | 16777 | 315 |
1079801 | 1079801 | 2021-03-02 | Clay | Florida | 12019 | 16750 | 304 |
1076556 | 1076556 | 2021-03-01 | Clay | Florida | 12019 | 16719 | 304 |
1073310 | 1073310 | 2021-02-28 | Clay | Florida | 12019 | 16716 | 304 |
1070064 | 1070064 | 2021-02-27 | Clay | Florida | 12019 | 16695 | 304 |
1066819 | 1066819 | 2021-02-26 | Clay | Florida | 12019 | 16673 | 304 |
1063574 | 1063574 | 2021-02-25 | Clay | Florida | 12019 | 16641 | 304 |
1060329 | 1060329 | 2021-02-24 | Clay | Florida | 12019 | 16603 | 299 |
1057083 | 1057083 | 2021-02-23 | Clay | Florida | 12019 | 16571 | 299 |
1053837 | 1053837 | 2021-02-22 | Clay | Florida | 12019 | 16546 | 299 |
1050590 | 1050590 | 2021-02-21 | Clay | Florida | 12019 | 16524 | 299 |
1047343 | 1047343 | 2021-02-20 | Clay | Florida | 12019 | 16500 | 297 |
1044098 | 1044098 | 2021-02-19 | Clay | Florida | 12019 | 16462 | 297 |
1040853 | 1040853 | 2021-02-18 | Clay | Florida | 12019 | 16417 | 295 |
1037608 | 1037608 | 2021-02-17 | Clay | Florida | 12019 | 16375 | 283 |
1034363 | 1034363 | 2021-02-16 | Clay | Florida | 12019 | 16331 | 283 |
1031117 | 1031117 | 2021-02-15 | Clay | Florida | 12019 | 16267 | 283 |
1027870 | 1027870 | 2021-02-14 | Clay | Florida | 12019 | 16227 | 283 |
1024625 | 1024625 | 2021-02-13 | Clay | Florida | 12019 | 16189 | 283 |
1021380 | 1021380 | 2021-02-12 | Clay | Florida | 12019 | 16129 | 283 |
1018135 | 1018135 | 2021-02-11 | Clay | Florida | 12019 | 16080 | 283 |
1014890 | 1014890 | 2021-02-10 | Clay | Florida | 12019 | 15995 | 283 |
1011645 | 1011645 | 2021-02-09 | Clay | Florida | 12019 | 15950 | 274 |
1008399 | 1008399 | 2021-02-08 | Clay | Florida | 12019 | 15899 | 266 |
1005153 | 1005153 | 2021-02-07 | Clay | Florida | 12019 | 15853 | 266 |
1001907 | 1001907 | 2021-02-06 | Clay | Florida | 12019 | 15788 | 265 |
998661 | 998661 | 2021-02-05 | Clay | Florida | 12019 | 15737 | 265 |
995415 | 995415 | 2021-02-04 | Clay | Florida | 12019 | 15655 | 266 |
992169 | 992169 | 2021-02-03 | Clay | Florida | 12019 | 15625 | 265 |
988923 | 988923 | 2021-02-02 | Clay | Florida | 12019 | 15551 | 244 |
985676 | 985676 | 2021-02-01 | Clay | Florida | 12019 | 15429 | 244 |
982429 | 982429 | 2021-01-31 | Clay | Florida | 12019 | 15387 | 244 |
979183 | 979183 | 2021-01-30 | Clay | Florida | 12019 | 15318 | 243 |
975938 | 975938 | 2021-01-29 | Clay | Florida | 12019 | 15170 | 243 |
972693 | 972693 | 2021-01-28 | Clay | Florida | 12019 | 15056 | 243 |
969448 | 969448 | 2021-01-27 | Clay | Florida | 12019 | 14963 | 242 |
966204 | 966204 | 2021-01-26 | Clay | Florida | 12019 | 14906 | 240 |
962959 | 962959 | 2021-01-25 | Clay | Florida | 12019 | 14813 | 226 |
959714 | 959714 | 2021-01-24 | Clay | Florida | 12019 | 14749 | 226 |
956468 | 956468 | 2021-01-23 | Clay | Florida | 12019 | 14658 | 226 |
953223 | 953223 | 2021-01-22 | Clay | Florida | 12019 | 14574 | 226 |
949978 | 949978 | 2021-01-21 | Clay | Florida | 12019 | 14393 | 226 |
946732 | 946732 | 2021-01-20 | Clay | Florida | 12019 | 14286 | 221 |
943485 | 943485 | 2021-01-19 | Clay | Florida | 12019 | 14190 | 221 |
940240 | 940240 | 2021-01-18 | Clay | Florida | 12019 | 14084 | 221 |
936995 | 936995 | 2021-01-17 | Clay | Florida | 12019 | 14000 | 221 |
933750 | 933750 | 2021-01-16 | Clay | Florida | 12019 | 13904 | 221 |
930505 | 930505 | 2021-01-15 | Clay | Florida | 12019 | 13781 | 210 |
927260 | 927260 | 2021-01-14 | Clay | Florida | 12019 | 13618 | 209 |
924014 | 924014 | 2021-01-13 | Clay | Florida | 12019 | 13496 | 209 |
920769 | 920769 | 2021-01-12 | Clay | Florida | 12019 | 13340 | 198 |
917524 | 917524 | 2021-01-11 | Clay | Florida | 12019 | 13171 | 197 |
914279 | 914279 | 2021-01-10 | Clay | Florida | 12019 | 13073 | 197 |
911034 | 911034 | 2021-01-09 | Clay | Florida | 12019 | 12938 | 197 |
907789 | 907789 | 2021-01-08 | Clay | Florida | 12019 | 12768 | 197 |
904543 | 904543 | 2021-01-07 | Clay | Florida | 12019 | 12543 | 193 |
901298 | 901298 | 2021-01-06 | Clay | Florida | 12019 | 12316 | 193 |
898053 | 898053 | 2021-01-05 | Clay | Florida | 12019 | 12090 | 189 |
894808 | 894808 | 2021-01-04 | Clay | Florida | 12019 | 11886 | 188 |
891561 | 891561 | 2021-01-03 | Clay | Florida | 12019 | 11798 | 188 |
888314 | 888314 | 2021-01-02 | Clay | Florida | 12019 | 11639 | 188 |
885069 | 885069 | 2021-01-01 | Clay | Florida | 12019 | 11261 | 186 |
881824 | 881824 | 2020-12-31 | Clay | Florida | 12019 | 11261 | 186 |
878579 | 878579 | 2020-12-30 | Clay | Florida | 12019 | 11114 | 184 |
875334 | 875334 | 2020-12-29 | Clay | Florida | 12019 | 10991 | 184 |
872089 | 872089 | 2020-12-28 | Clay | Florida | 12019 | 10829 | 183 |
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);