ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Collier" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
735782 | 735782 | 2020-11-16 | Collier | Florida | 12021 | 16019 | 267 |
732536 | 732536 | 2020-11-15 | Collier | Florida | 12021 | 15938 | 267 |
729291 | 729291 | 2020-11-14 | Collier | Florida | 12021 | 15836 | 267 |
726048 | 726048 | 2020-11-13 | Collier | Florida | 12021 | 15729 | 267 |
722805 | 722805 | 2020-11-12 | Collier | Florida | 12021 | 15611 | 267 |
719562 | 719562 | 2020-11-11 | Collier | Florida | 12021 | 15566 | 265 |
716319 | 716319 | 2020-11-10 | Collier | Florida | 12021 | 15441 | 261 |
713075 | 713075 | 2020-11-09 | Collier | Florida | 12021 | 15314 | 260 |
709831 | 709831 | 2020-11-08 | Collier | Florida | 12021 | 15263 | 259 |
706587 | 706587 | 2020-11-07 | Collier | Florida | 12021 | 15173 | 259 |
703344 | 703344 | 2020-11-06 | Collier | Florida | 12021 | 15091 | 259 |
700101 | 700101 | 2020-11-05 | Collier | Florida | 12021 | 15005 | 259 |
696857 | 696857 | 2020-11-04 | Collier | Florida | 12021 | 14909 | 256 |
693615 | 693615 | 2020-11-03 | Collier | Florida | 12021 | 14839 | 256 |
690372 | 690372 | 2020-11-02 | Collier | Florida | 12021 | 14742 | 256 |
687127 | 687127 | 2020-11-01 | Collier | Florida | 12021 | 14664 | 256 |
683883 | 683883 | 2020-10-31 | Collier | Florida | 12021 | 14587 | 256 |
680640 | 680640 | 2020-10-30 | Collier | Florida | 12021 | 14542 | 256 |
677397 | 677397 | 2020-10-29 | Collier | Florida | 12021 | 14404 | 255 |
674154 | 674154 | 2020-10-28 | Collier | Florida | 12021 | 14326 | 255 |
670912 | 670912 | 2020-10-27 | Collier | Florida | 12021 | 14247 | 255 |
667669 | 667669 | 2020-10-26 | Collier | Florida | 12021 | 14135 | 253 |
664424 | 664424 | 2020-10-25 | Collier | Florida | 12021 | 14087 | 253 |
661180 | 661180 | 2020-10-24 | Collier | Florida | 12021 | 14025 | 253 |
657936 | 657936 | 2020-10-23 | Collier | Florida | 12021 | 13927 | 251 |
654691 | 654691 | 2020-10-22 | Collier | Florida | 12021 | 13864 | 249 |
651446 | 651446 | 2020-10-21 | Collier | Florida | 12021 | 13762 | 249 |
648202 | 648202 | 2020-10-20 | Collier | Florida | 12021 | 13716 | 249 |
644957 | 644957 | 2020-10-19 | Collier | Florida | 12021 | 13653 | 246 |
641709 | 641709 | 2020-10-18 | Collier | Florida | 12021 | 13621 | 245 |
638462 | 638462 | 2020-10-17 | Collier | Florida | 12021 | 13588 | 244 |
635217 | 635217 | 2020-10-16 | Collier | Florida | 12021 | 13492 | 243 |
631971 | 631971 | 2020-10-15 | Collier | Florida | 12021 | 13432 | 242 |
628727 | 628727 | 2020-10-14 | Collier | Florida | 12021 | 13382 | 239 |
625484 | 625484 | 2020-10-13 | Collier | Florida | 12021 | 13330 | 239 |
622241 | 622241 | 2020-10-12 | Collier | Florida | 12021 | 13262 | 237 |
618998 | 618998 | 2020-10-11 | Collier | Florida | 12021 | 13236 | 237 |
615756 | 615756 | 2020-10-10 | Collier | Florida | 12021 | 13139 | 234 |
612515 | 612515 | 2020-10-09 | Collier | Florida | 12021 | 13139 | 234 |
609273 | 609273 | 2020-10-08 | Collier | Florida | 12021 | 13089 | 232 |
606030 | 606030 | 2020-10-07 | Collier | Florida | 12021 | 13010 | 230 |
602788 | 602788 | 2020-10-06 | Collier | Florida | 12021 | 12961 | 228 |
599545 | 599545 | 2020-10-05 | Collier | Florida | 12021 | 12920 | 228 |
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);