ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 12021 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060330 | 1060330 | 2021-02-24 | Collier | Florida | 12021 | 29963 | 450 |
1057084 | 1057084 | 2021-02-23 | Collier | Florida | 12021 | 29865 | 448 |
1053838 | 1053838 | 2021-02-22 | Collier | Florida | 12021 | 29751 | 443 |
1050591 | 1050591 | 2021-02-21 | Collier | Florida | 12021 | 29706 | 443 |
1047344 | 1047344 | 2021-02-20 | Collier | Florida | 12021 | 29652 | 440 |
1044099 | 1044099 | 2021-02-19 | Collier | Florida | 12021 | 29560 | 440 |
1040854 | 1040854 | 2021-02-18 | Collier | Florida | 12021 | 29460 | 438 |
1037609 | 1037609 | 2021-02-17 | Collier | Florida | 12021 | 29347 | 434 |
1034364 | 1034364 | 2021-02-16 | Collier | Florida | 12021 | 29250 | 433 |
1031118 | 1031118 | 2021-02-15 | Collier | Florida | 12021 | 29195 | 431 |
1027871 | 1027871 | 2021-02-14 | Collier | Florida | 12021 | 29136 | 430 |
1024626 | 1024626 | 2021-02-13 | Collier | Florida | 12021 | 29058 | 430 |
1021381 | 1021381 | 2021-02-12 | Collier | Florida | 12021 | 28978 | 428 |
1018136 | 1018136 | 2021-02-11 | Collier | Florida | 12021 | 28883 | 426 |
1014891 | 1014891 | 2021-02-10 | Collier | Florida | 12021 | 28783 | 422 |
1011646 | 1011646 | 2021-02-09 | Collier | Florida | 12021 | 28691 | 422 |
1008400 | 1008400 | 2021-02-08 | Collier | Florida | 12021 | 28581 | 422 |
1005154 | 1005154 | 2021-02-07 | Collier | Florida | 12021 | 28524 | 420 |
1001908 | 1001908 | 2021-02-06 | Collier | Florida | 12021 | 28454 | 420 |
998662 | 998662 | 2021-02-05 | Collier | Florida | 12021 | 28361 | 419 |
995416 | 995416 | 2021-02-04 | Collier | Florida | 12021 | 28224 | 414 |
992170 | 992170 | 2021-02-03 | Collier | Florida | 12021 | 28139 | 413 |
988924 | 988924 | 2021-02-02 | Collier | Florida | 12021 | 28019 | 410 |
985677 | 985677 | 2021-02-01 | Collier | Florida | 12021 | 27867 | 404 |
982430 | 982430 | 2021-01-31 | Collier | Florida | 12021 | 27810 | 404 |
979184 | 979184 | 2021-01-30 | Collier | Florida | 12021 | 27723 | 404 |
975939 | 975939 | 2021-01-29 | Collier | Florida | 12021 | 27543 | 403 |
972694 | 972694 | 2021-01-28 | Collier | Florida | 12021 | 27416 | 402 |
969449 | 969449 | 2021-01-27 | Collier | Florida | 12021 | 27214 | 398 |
966205 | 966205 | 2021-01-26 | Collier | Florida | 12021 | 27060 | 396 |
962960 | 962960 | 2021-01-25 | Collier | Florida | 12021 | 26924 | 394 |
959715 | 959715 | 2021-01-24 | Collier | Florida | 12021 | 26832 | 386 |
956469 | 956469 | 2021-01-23 | Collier | Florida | 12021 | 26709 | 386 |
953224 | 953224 | 2021-01-22 | Collier | Florida | 12021 | 26573 | 386 |
949979 | 949979 | 2021-01-21 | Collier | Florida | 12021 | 26361 | 386 |
946733 | 946733 | 2021-01-20 | Collier | Florida | 12021 | 26164 | 382 |
943486 | 943486 | 2021-01-19 | Collier | Florida | 12021 | 25979 | 381 |
940241 | 940241 | 2021-01-18 | Collier | Florida | 12021 | 25874 | 377 |
936996 | 936996 | 2021-01-17 | Collier | Florida | 12021 | 25782 | 376 |
933751 | 933751 | 2021-01-16 | Collier | Florida | 12021 | 25645 | 375 |
930506 | 930506 | 2021-01-15 | Collier | Florida | 12021 | 25419 | 371 |
927261 | 927261 | 2021-01-14 | Collier | Florida | 12021 | 25220 | 370 |
924015 | 924015 | 2021-01-13 | Collier | Florida | 12021 | 25046 | 367 |
920770 | 920770 | 2021-01-12 | Collier | Florida | 12021 | 24814 | 363 |
917525 | 917525 | 2021-01-11 | Collier | Florida | 12021 | 24575 | 363 |
914280 | 914280 | 2021-01-10 | Collier | Florida | 12021 | 24443 | 363 |
911035 | 911035 | 2021-01-09 | Collier | Florida | 12021 | 24304 | 361 |
907790 | 907790 | 2021-01-08 | Collier | Florida | 12021 | 24012 | 360 |
904544 | 904544 | 2021-01-07 | Collier | Florida | 12021 | 23707 | 354 |
901299 | 901299 | 2021-01-06 | Collier | Florida | 12021 | 23502 | 350 |
898054 | 898054 | 2021-01-05 | Collier | Florida | 12021 | 23323 | 346 |
894809 | 894809 | 2021-01-04 | Collier | Florida | 12021 | 23197 | 341 |
891562 | 891562 | 2021-01-03 | Collier | Florida | 12021 | 23070 | 339 |
888315 | 888315 | 2021-01-02 | Collier | Florida | 12021 | 22911 | 339 |
885070 | 885070 | 2021-01-01 | Collier | Florida | 12021 | 22506 | 332 |
881825 | 881825 | 2020-12-31 | Collier | Florida | 12021 | 22506 | 332 |
878580 | 878580 | 2020-12-30 | Collier | Florida | 12021 | 22267 | 333 |
875335 | 875335 | 2020-12-29 | Collier | Florida | 12021 | 22132 | 331 |
872090 | 872090 | 2020-12-28 | Collier | Florida | 12021 | 22004 | 328 |
868845 | 868845 | 2020-12-27 | Collier | Florida | 12021 | 21683 | 326 |
865600 | 865600 | 2020-12-26 | Collier | Florida | 12021 | 21558 | 326 |
862355 | 862355 | 2020-12-25 | Collier | Florida | 12021 | 21428 | 325 |
859110 | 859110 | 2020-12-24 | Collier | Florida | 12021 | 21428 | 325 |
855865 | 855865 | 2020-12-23 | Collier | Florida | 12021 | 21213 | 322 |
852620 | 852620 | 2020-12-22 | Collier | Florida | 12021 | 21050 | 321 |
849375 | 849375 | 2020-12-21 | Collier | Florida | 12021 | 20971 | 317 |
846130 | 846130 | 2020-12-20 | Collier | Florida | 12021 | 20825 | 317 |
842884 | 842884 | 2020-12-19 | Collier | Florida | 12021 | 20770 | 315 |
839639 | 839639 | 2020-12-18 | Collier | Florida | 12021 | 20629 | 315 |
836394 | 836394 | 2020-12-17 | Collier | Florida | 12021 | 20482 | 314 |
833148 | 833148 | 2020-12-16 | Collier | Florida | 12021 | 20294 | 312 |
829901 | 829901 | 2020-12-15 | Collier | Florida | 12021 | 20151 | 310 |
826655 | 826655 | 2020-12-14 | Collier | Florida | 12021 | 20021 | 310 |
823408 | 823408 | 2020-12-13 | Collier | Florida | 12021 | 19935 | 308 |
820162 | 820162 | 2020-12-12 | Collier | Florida | 12021 | 19854 | 308 |
816916 | 816916 | 2020-12-11 | Collier | Florida | 12021 | 19684 | 306 |
813670 | 813670 | 2020-12-10 | Collier | Florida | 12021 | 19496 | 303 |
810426 | 810426 | 2020-12-09 | Collier | Florida | 12021 | 19351 | 303 |
807181 | 807181 | 2020-12-08 | Collier | Florida | 12021 | 19133 | 299 |
803936 | 803936 | 2020-12-07 | Collier | Florida | 12021 | 19026 | 295 |
800691 | 800691 | 2020-12-06 | Collier | Florida | 12021 | 18926 | 294 |
797446 | 797446 | 2020-12-05 | Collier | Florida | 12021 | 18751 | 293 |
794201 | 794201 | 2020-12-04 | Collier | Florida | 12021 | 18548 | 289 |
790956 | 790956 | 2020-12-03 | Collier | Florida | 12021 | 18334 | 285 |
787711 | 787711 | 2020-12-02 | Collier | Florida | 12021 | 18132 | 284 |
784467 | 784467 | 2020-12-01 | Collier | Florida | 12021 | 17911 | 281 |
781222 | 781222 | 2020-11-30 | Collier | Florida | 12021 | 17757 | 280 |
777976 | 777976 | 2020-11-29 | Collier | Florida | 12021 | 17693 | 280 |
774731 | 774731 | 2020-11-28 | Collier | Florida | 12021 | 17647 | 280 |
771486 | 771486 | 2020-11-27 | Collier | Florida | 12021 | 17556 | 280 |
768241 | 768241 | 2020-11-26 | Collier | Florida | 12021 | 17262 | 279 |
764995 | 764995 | 2020-11-25 | Collier | Florida | 12021 | 17262 | 279 |
761750 | 761750 | 2020-11-24 | Collier | Florida | 12021 | 17095 | 279 |
758505 | 758505 | 2020-11-23 | Collier | Florida | 12021 | 16947 | 276 |
755258 | 755258 | 2020-11-22 | Collier | Florida | 12021 | 16864 | 276 |
752012 | 752012 | 2020-11-21 | Collier | Florida | 12021 | 16749 | 273 |
748766 | 748766 | 2020-11-20 | Collier | Florida | 12021 | 16618 | 273 |
745520 | 745520 | 2020-11-19 | Collier | Florida | 12021 | 16447 | 269 |
742273 | 742273 | 2020-11-18 | Collier | Florida | 12021 | 16308 | 268 |
739026 | 739026 | 2020-11-17 | Collier | Florida | 12021 | 16117 | 268 |
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);