ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 12073 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193466 | 1193466 | 2021-04-06 | Leon | Florida | 12073 | 30487 | 307 |
1190216 | 1190216 | 2021-04-05 | Leon | Florida | 12073 | 30439 | 310 |
1186969 | 1186969 | 2021-04-04 | Leon | Florida | 12073 | 30429 | 306 |
1183722 | 1183722 | 2021-04-03 | Leon | Florida | 12073 | 30405 | 306 |
1180475 | 1180475 | 2021-04-02 | Leon | Florida | 12073 | 30378 | 306 |
1177228 | 1177228 | 2021-04-01 | Leon | Florida | 12073 | 30344 | 305 |
1173981 | 1173981 | 2021-03-31 | Leon | Florida | 12073 | 30306 | 305 |
1170734 | 1170734 | 2021-03-30 | Leon | Florida | 12073 | 30282 | 303 |
1167486 | 1167486 | 2021-03-29 | Leon | Florida | 12073 | 30252 | 309 |
1164238 | 1164238 | 2021-03-28 | Leon | Florida | 12073 | 30241 | 301 |
1160990 | 1160990 | 2021-03-27 | Leon | Florida | 12073 | 30212 | 301 |
1157742 | 1157742 | 2021-03-26 | Leon | Florida | 12073 | 30167 | 301 |
1154495 | 1154495 | 2021-03-25 | Leon | Florida | 12073 | 30126 | 301 |
1151248 | 1151248 | 2021-03-24 | Leon | Florida | 12073 | 30086 | 301 |
1148001 | 1148001 | 2021-03-23 | Leon | Florida | 12073 | 30040 | 301 |
1144754 | 1144754 | 2021-03-22 | Leon | Florida | 12073 | 29991 | 298 |
1141507 | 1141507 | 2021-03-21 | Leon | Florida | 12073 | 29981 | 298 |
1138261 | 1138261 | 2021-03-20 | Leon | Florida | 12073 | 29965 | 298 |
1135015 | 1135015 | 2021-03-19 | Leon | Florida | 12073 | 29921 | 298 |
1131768 | 1131768 | 2021-03-18 | Leon | Florida | 12073 | 29889 | 296 |
1128520 | 1128520 | 2021-03-17 | Leon | Florida | 12073 | 29849 | 297 |
1125274 | 1125274 | 2021-03-16 | Leon | Florida | 12073 | 29813 | 296 |
1122028 | 1122028 | 2021-03-15 | Leon | Florida | 12073 | 29790 | 294 |
1118781 | 1118781 | 2021-03-14 | Leon | Florida | 12073 | 29777 | 294 |
1115534 | 1115534 | 2021-03-13 | Leon | Florida | 12073 | 29753 | 293 |
1112288 | 1112288 | 2021-03-12 | Leon | Florida | 12073 | 29707 | 293 |
1109042 | 1109042 | 2021-03-11 | Leon | Florida | 12073 | 29659 | 291 |
1105796 | 1105796 | 2021-03-10 | Leon | Florida | 12073 | 29621 | 291 |
1102550 | 1102550 | 2021-03-09 | Leon | Florida | 12073 | 29581 | 293 |
1099304 | 1099304 | 2021-03-08 | Leon | Florida | 12073 | 29531 | 292 |
1096056 | 1096056 | 2021-03-07 | Leon | Florida | 12073 | 29519 | 292 |
1092810 | 1092810 | 2021-03-06 | Leon | Florida | 12073 | 29482 | 291 |
1089564 | 1089564 | 2021-03-05 | Leon | Florida | 12073 | 29423 | 293 |
1086319 | 1086319 | 2021-03-04 | Leon | Florida | 12073 | 29366 | 287 |
1083073 | 1083073 | 2021-03-03 | Leon | Florida | 12073 | 29316 | 286 |
1079827 | 1079827 | 2021-03-02 | Leon | Florida | 12073 | 29242 | 282 |
1076582 | 1076582 | 2021-03-01 | Leon | Florida | 12073 | 29168 | 283 |
1073336 | 1073336 | 2021-02-28 | Leon | Florida | 12073 | 29153 | 283 |
1070090 | 1070090 | 2021-02-27 | Leon | Florida | 12073 | 29105 | 279 |
1066845 | 1066845 | 2021-02-26 | Leon | Florida | 12073 | 29052 | 283 |
1063600 | 1063600 | 2021-02-25 | Leon | Florida | 12073 | 28960 | 276 |
1060355 | 1060355 | 2021-02-24 | Leon | Florida | 12073 | 28884 | 277 |
1057109 | 1057109 | 2021-02-23 | Leon | Florida | 12073 | 28795 | 273 |
1053863 | 1053863 | 2021-02-22 | Leon | Florida | 12073 | 28688 | 273 |
1050616 | 1050616 | 2021-02-21 | Leon | Florida | 12073 | 28676 | 272 |
1047369 | 1047369 | 2021-02-20 | Leon | Florida | 12073 | 28602 | 272 |
1044124 | 1044124 | 2021-02-19 | Leon | Florida | 12073 | 28496 | 272 |
1040879 | 1040879 | 2021-02-18 | Leon | Florida | 12073 | 28396 | 269 |
1037634 | 1037634 | 2021-02-17 | Leon | Florida | 12073 | 28290 | 266 |
1034389 | 1034389 | 2021-02-16 | Leon | Florida | 12073 | 28186 | 265 |
1031143 | 1031143 | 2021-02-15 | Leon | Florida | 12073 | 28075 | 266 |
1027896 | 1027896 | 2021-02-14 | Leon | Florida | 12073 | 28075 | 260 |
1024651 | 1024651 | 2021-02-13 | Leon | Florida | 12073 | 28011 | 259 |
1021406 | 1021406 | 2021-02-12 | Leon | Florida | 12073 | 27936 | 260 |
1018161 | 1018161 | 2021-02-11 | Leon | Florida | 12073 | 27806 | 258 |
1014916 | 1014916 | 2021-02-10 | Leon | Florida | 12073 | 27664 | 256 |
1011671 | 1011671 | 2021-02-09 | Leon | Florida | 12073 | 27560 | 252 |
1008425 | 1008425 | 2021-02-08 | Leon | Florida | 12073 | 27370 | 252 |
1005179 | 1005179 | 2021-02-07 | Leon | Florida | 12073 | 27358 | 250 |
1001933 | 1001933 | 2021-02-06 | Leon | Florida | 12073 | 27253 | 250 |
998687 | 998687 | 2021-02-05 | Leon | Florida | 12073 | 27143 | 248 |
995441 | 995441 | 2021-02-04 | Leon | Florida | 12073 | 26989 | 245 |
992195 | 992195 | 2021-02-03 | Leon | Florida | 12073 | 26837 | 239 |
988949 | 988949 | 2021-02-02 | Leon | Florida | 12073 | 26722 | 235 |
985702 | 985702 | 2021-02-01 | Leon | Florida | 12073 | 26542 | 235 |
982455 | 982455 | 2021-01-31 | Leon | Florida | 12073 | 26502 | 231 |
979209 | 979209 | 2021-01-30 | Leon | Florida | 12073 | 26394 | 230 |
975964 | 975964 | 2021-01-29 | Leon | Florida | 12073 | 26166 | 228 |
972719 | 972719 | 2021-01-28 | Leon | Florida | 12073 | 25986 | 224 |
969474 | 969474 | 2021-01-27 | Leon | Florida | 12073 | 25758 | 221 |
966230 | 966230 | 2021-01-26 | Leon | Florida | 12073 | 25548 | 218 |
962985 | 962985 | 2021-01-25 | Leon | Florida | 12073 | 25275 | 212 |
959740 | 959740 | 2021-01-24 | Leon | Florida | 12073 | 25159 | 209 |
956494 | 956494 | 2021-01-23 | Leon | Florida | 12073 | 24990 | 209 |
953249 | 953249 | 2021-01-22 | Leon | Florida | 12073 | 24737 | 207 |
950004 | 950004 | 2021-01-21 | Leon | Florida | 12073 | 24478 | 205 |
946758 | 946758 | 2021-01-20 | Leon | Florida | 12073 | 24177 | 204 |
943511 | 943511 | 2021-01-19 | Leon | Florida | 12073 | 23921 | 203 |
940266 | 940266 | 2021-01-18 | Leon | Florida | 12073 | 23661 | 203 |
937021 | 937021 | 2021-01-17 | Leon | Florida | 12073 | 23628 | 202 |
933776 | 933776 | 2021-01-16 | Leon | Florida | 12073 | 23393 | 201 |
930531 | 930531 | 2021-01-15 | Leon | Florida | 12073 | 23232 | 200 |
927286 | 927286 | 2021-01-14 | Leon | Florida | 12073 | 22975 | 192 |
924040 | 924040 | 2021-01-13 | Leon | Florida | 12073 | 22734 | 190 |
920795 | 920795 | 2021-01-12 | Leon | Florida | 12073 | 22530 | 188 |
917550 | 917550 | 2021-01-11 | Leon | Florida | 12073 | 22217 | 184 |
914305 | 914305 | 2021-01-10 | Leon | Florida | 12073 | 22137 | 184 |
911060 | 911060 | 2021-01-09 | Leon | Florida | 12073 | 21969 | 184 |
907815 | 907815 | 2021-01-08 | Leon | Florida | 12073 | 21701 | 182 |
904569 | 904569 | 2021-01-07 | Leon | Florida | 12073 | 21336 | 177 |
901324 | 901324 | 2021-01-06 | Leon | Florida | 12073 | 20954 | 177 |
898079 | 898079 | 2021-01-05 | Leon | Florida | 12073 | 20545 | 176 |
894834 | 894834 | 2021-01-04 | Leon | Florida | 12073 | 20167 | 176 |
891587 | 891587 | 2021-01-03 | Leon | Florida | 12073 | 20093 | 176 |
888340 | 888340 | 2021-01-02 | Leon | Florida | 12073 | 20020 | 175 |
885095 | 885095 | 2021-01-01 | Leon | Florida | 12073 | 19573 | 175 |
881850 | 881850 | 2020-12-31 | Leon | Florida | 12073 | 19573 | 175 |
878605 | 878605 | 2020-12-30 | Leon | Florida | 12073 | 19290 | 173 |
875360 | 875360 | 2020-12-29 | Leon | Florida | 12073 | 19015 | 173 |
872115 | 872115 | 2020-12-28 | Leon | Florida | 12073 | 18741 | 173 |
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);