ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Miami-Dade" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946765 | 946765 | 2021-01-20 | Miami-Dade | Florida | 12086 | 350251 | 4630 |
943518 | 943518 | 2021-01-19 | Miami-Dade | Florida | 12086 | 347964 | 4622 |
940273 | 940273 | 2021-01-18 | Miami-Dade | Florida | 12086 | 346089 | 4617 |
937028 | 937028 | 2021-01-17 | Miami-Dade | Florida | 12086 | 344245 | 4595 |
933783 | 933783 | 2021-01-16 | Miami-Dade | Florida | 12086 | 341841 | 4561 |
930538 | 930538 | 2021-01-15 | Miami-Dade | Florida | 12086 | 339433 | 4528 |
927293 | 927293 | 2021-01-14 | Miami-Dade | Florida | 12086 | 336748 | 4500 |
924047 | 924047 | 2021-01-13 | Miami-Dade | Florida | 12086 | 334216 | 4472 |
920802 | 920802 | 2021-01-12 | Miami-Dade | Florida | 12086 | 331648 | 4452 |
917557 | 917557 | 2021-01-11 | Miami-Dade | Florida | 12086 | 328700 | 4441 |
914312 | 914312 | 2021-01-10 | Miami-Dade | Florida | 12086 | 326606 | 4413 |
911067 | 911067 | 2021-01-09 | Miami-Dade | Florida | 12086 | 324259 | 4365 |
907822 | 907822 | 2021-01-08 | Miami-Dade | Florida | 12086 | 321554 | 4332 |
904576 | 904576 | 2021-01-07 | Miami-Dade | Florida | 12086 | 318114 | 4297 |
901331 | 901331 | 2021-01-06 | Miami-Dade | Florida | 12086 | 314741 | 4260 |
898086 | 898086 | 2021-01-05 | Miami-Dade | Florida | 12086 | 311605 | 4257 |
894841 | 894841 | 2021-01-04 | Miami-Dade | Florida | 12086 | 308258 | 4256 |
891594 | 891594 | 2021-01-03 | Miami-Dade | Florida | 12086 | 305733 | 4251 |
888347 | 888347 | 2021-01-02 | Miami-Dade | Florida | 12086 | 304186 | 4239 |
885102 | 885102 | 2021-01-01 | Miami-Dade | Florida | 12086 | 298872 | 4188 |
881857 | 881857 | 2020-12-31 | Miami-Dade | Florida | 12086 | 298872 | 4188 |
878612 | 878612 | 2020-12-30 | Miami-Dade | Florida | 12086 | 295935 | 4169 |
875367 | 875367 | 2020-12-29 | Miami-Dade | Florida | 12086 | 293187 | 4164 |
872122 | 872122 | 2020-12-28 | Miami-Dade | Florida | 12086 | 290362 | 4155 |
868877 | 868877 | 2020-12-27 | Miami-Dade | Florida | 12086 | 288305 | 4150 |
865632 | 865632 | 2020-12-26 | Miami-Dade | Florida | 12086 | 286661 | 4127 |
862387 | 862387 | 2020-12-25 | Miami-Dade | Florida | 12086 | 283284 | 4108 |
859142 | 859142 | 2020-12-24 | Miami-Dade | Florida | 12086 | 283284 | 4108 |
855897 | 855897 | 2020-12-23 | Miami-Dade | Florida | 12086 | 280981 | 4096 |
852652 | 852652 | 2020-12-22 | Miami-Dade | Florida | 12086 | 278738 | 4095 |
849407 | 849407 | 2020-12-21 | Miami-Dade | Florida | 12086 | 276413 | 4097 |
846162 | 846162 | 2020-12-20 | Miami-Dade | Florida | 12086 | 274116 | 4066 |
842916 | 842916 | 2020-12-19 | Miami-Dade | Florida | 12086 | 272097 | 4050 |
839671 | 839671 | 2020-12-18 | Miami-Dade | Florida | 12086 | 269715 | 4034 |
836426 | 836426 | 2020-12-17 | Miami-Dade | Florida | 12086 | 267254 | 4022 |
833180 | 833180 | 2020-12-16 | Miami-Dade | Florida | 12086 | 264672 | 4017 |
829933 | 829933 | 2020-12-15 | Miami-Dade | Florida | 12086 | 262297 | 4005 |
826687 | 826687 | 2020-12-14 | Miami-Dade | Florida | 12086 | 260137 | 4002 |
823440 | 823440 | 2020-12-13 | Miami-Dade | Florida | 12086 | 257856 | 3981 |
820194 | 820194 | 2020-12-12 | Miami-Dade | Florida | 12086 | 255461 | 3965 |
816948 | 816948 | 2020-12-11 | Miami-Dade | Florida | 12086 | 253402 | 3959 |
813702 | 813702 | 2020-12-10 | Miami-Dade | Florida | 12086 | 251282 | 3943 |
810458 | 810458 | 2020-12-09 | Miami-Dade | Florida | 12086 | 249042 | 3930 |
807213 | 807213 | 2020-12-08 | Miami-Dade | Florida | 12086 | 246914 | 3926 |
803968 | 803968 | 2020-12-07 | Miami-Dade | Florida | 12086 | 245063 | 3934 |
800723 | 800723 | 2020-12-06 | Miami-Dade | Florida | 12086 | 243049 | 3913 |
797478 | 797478 | 2020-12-05 | Miami-Dade | Florida | 12086 | 241050 | 3896 |
794233 | 794233 | 2020-12-04 | Miami-Dade | Florida | 12086 | 238812 | 3888 |
790988 | 790988 | 2020-12-03 | Miami-Dade | Florida | 12086 | 236307 | 3868 |
787743 | 787743 | 2020-12-02 | Miami-Dade | Florida | 12086 | 234053 | 3860 |
784499 | 784499 | 2020-12-01 | Miami-Dade | Florida | 12086 | 231760 | 3839 |
781254 | 781254 | 2020-11-30 | Miami-Dade | Florida | 12086 | 229617 | 3835 |
778008 | 778008 | 2020-11-29 | Miami-Dade | Florida | 12086 | 227655 | 3834 |
774763 | 774763 | 2020-11-28 | Miami-Dade | Florida | 12086 | 225631 | 3823 |
771518 | 771518 | 2020-11-27 | Miami-Dade | Florida | 12086 | 224165 | 3799 |
768273 | 768273 | 2020-11-26 | Miami-Dade | Florida | 12086 | 220413 | 3792 |
765027 | 765027 | 2020-11-25 | Miami-Dade | Florida | 12086 | 220413 | 3792 |
761782 | 761782 | 2020-11-24 | Miami-Dade | Florida | 12086 | 218293 | 3789 |
758537 | 758537 | 2020-11-23 | Miami-Dade | Florida | 12086 | 216441 | 3782 |
755290 | 755290 | 2020-11-22 | Miami-Dade | Florida | 12086 | 214942 | 3766 |
752044 | 752044 | 2020-11-21 | Miami-Dade | Florida | 12086 | 213196 | 3753 |
748798 | 748798 | 2020-11-20 | Miami-Dade | Florida | 12086 | 211256 | 3746 |
745552 | 745552 | 2020-11-19 | Miami-Dade | Florida | 12086 | 209165 | 3738 |
742305 | 742305 | 2020-11-18 | Miami-Dade | Florida | 12086 | 207220 | 3731 |
739058 | 739058 | 2020-11-17 | Miami-Dade | Florida | 12086 | 205535 | 3723 |
735814 | 735814 | 2020-11-16 | Miami-Dade | Florida | 12086 | 203653 | 3709 |
732568 | 732568 | 2020-11-15 | Miami-Dade | Florida | 12086 | 202643 | 3709 |
729323 | 729323 | 2020-11-14 | Miami-Dade | Florida | 12086 | 200258 | 3707 |
726080 | 726080 | 2020-11-13 | Miami-Dade | Florida | 12086 | 199071 | 3706 |
722837 | 722837 | 2020-11-12 | Miami-Dade | Florida | 12086 | 197195 | 3701 |
719594 | 719594 | 2020-11-11 | Miami-Dade | Florida | 12086 | 195990 | 3693 |
716351 | 716351 | 2020-11-10 | Miami-Dade | Florida | 12086 | 195272 | 3690 |
713107 | 713107 | 2020-11-09 | Miami-Dade | Florida | 12086 | 194878 | 3688 |
709863 | 709863 | 2020-11-08 | Miami-Dade | Florida | 12086 | 194355 | 3683 |
706619 | 706619 | 2020-11-07 | Miami-Dade | Florida | 12086 | 192645 | 3682 |
703376 | 703376 | 2020-11-06 | Miami-Dade | Florida | 12086 | 191837 | 3671 |
700133 | 700133 | 2020-11-05 | Miami-Dade | Florida | 12086 | 190727 | 3670 |
696889 | 696889 | 2020-11-04 | Miami-Dade | Florida | 12086 | 189331 | 3670 |
693647 | 693647 | 2020-11-03 | Miami-Dade | Florida | 12086 | 188635 | 3675 |
690404 | 690404 | 2020-11-02 | Miami-Dade | Florida | 12086 | 187756 | 3669 |
687159 | 687159 | 2020-11-01 | Miami-Dade | Florida | 12086 | 186808 | 3662 |
683915 | 683915 | 2020-10-31 | Miami-Dade | Florida | 12086 | 185890 | 3647 |
680672 | 680672 | 2020-10-30 | Miami-Dade | Florida | 12086 | 185551 | 3643 |
677429 | 677429 | 2020-10-29 | Miami-Dade | Florida | 12086 | 184668 | 3634 |
674186 | 674186 | 2020-10-28 | Miami-Dade | Florida | 12086 | 183995 | 3625 |
670944 | 670944 | 2020-10-27 | Miami-Dade | Florida | 12086 | 183249 | 3624 |
667701 | 667701 | 2020-10-26 | Miami-Dade | Florida | 12086 | 182522 | 3615 |
664456 | 664456 | 2020-10-25 | Miami-Dade | Florida | 12086 | 181941 | 3612 |
661212 | 661212 | 2020-10-24 | Miami-Dade | Florida | 12086 | 181632 | 3605 |
657968 | 657968 | 2020-10-23 | Miami-Dade | Florida | 12086 | 181016 | 3597 |
654723 | 654723 | 2020-10-22 | Miami-Dade | Florida | 12086 | 180496 | 3585 |
651478 | 651478 | 2020-10-21 | Miami-Dade | Florida | 12086 | 179643 | 3572 |
648234 | 648234 | 2020-10-20 | Miami-Dade | Florida | 12086 | 179285 | 3561 |
644989 | 644989 | 2020-10-19 | Miami-Dade | Florida | 12086 | 178725 | 3547 |
641741 | 641741 | 2020-10-18 | Miami-Dade | Florida | 12086 | 178353 | 3540 |
638494 | 638494 | 2020-10-17 | Miami-Dade | Florida | 12086 | 177892 | 3537 |
635249 | 635249 | 2020-10-16 | Miami-Dade | Florida | 12086 | 177338 | 3520 |
632003 | 632003 | 2020-10-15 | Miami-Dade | Florida | 12086 | 176808 | 3501 |
628759 | 628759 | 2020-10-14 | Miami-Dade | Florida | 12086 | 176270 | 3485 |
625516 | 625516 | 2020-10-13 | Miami-Dade | Florida | 12086 | 175836 | 3465 |
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);