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 |
---|---|---|---|---|---|---|---|
1063607 | 1063607 | 2021-02-25 | Miami-Dade | Florida | 12086 | 406986 | 5369 |
1060362 | 1060362 | 2021-02-24 | Miami-Dade | Florida | 12086 | 405562 | 5353 |
1057116 | 1057116 | 2021-02-23 | Miami-Dade | Florida | 12086 | 404498 | 5338 |
1053870 | 1053870 | 2021-02-22 | Miami-Dade | Florida | 12086 | 403258 | 5314 |
1050623 | 1050623 | 2021-02-21 | Miami-Dade | Florida | 12086 | 402264 | 5290 |
1047376 | 1047376 | 2021-02-20 | Miami-Dade | Florida | 12086 | 401136 | 5280 |
1044131 | 1044131 | 2021-02-19 | Miami-Dade | Florida | 12086 | 399592 | 5270 |
1040886 | 1040886 | 2021-02-18 | Miami-Dade | Florida | 12086 | 398042 | 5242 |
1037641 | 1037641 | 2021-02-17 | Miami-Dade | Florida | 12086 | 397225 | 5229 |
1034396 | 1034396 | 2021-02-16 | Miami-Dade | Florida | 12086 | 395827 | 5207 |
1031150 | 1031150 | 2021-02-15 | Miami-Dade | Florida | 12086 | 394491 | 5185 |
1027903 | 1027903 | 2021-02-14 | Miami-Dade | Florida | 12086 | 393970 | 5170 |
1024658 | 1024658 | 2021-02-13 | Miami-Dade | Florida | 12086 | 392841 | 5141 |
1021413 | 1021413 | 2021-02-12 | Miami-Dade | Florida | 12086 | 391161 | 5121 |
1018168 | 1018168 | 2021-02-11 | Miami-Dade | Florida | 12086 | 389518 | 5081 |
1014923 | 1014923 | 2021-02-10 | Miami-Dade | Florida | 12086 | 387939 | 5062 |
1011678 | 1011678 | 2021-02-09 | Miami-Dade | Florida | 12086 | 386424 | 5058 |
1008432 | 1008432 | 2021-02-08 | Miami-Dade | Florida | 12086 | 384970 | 5039 |
1005186 | 1005186 | 2021-02-07 | Miami-Dade | Florida | 12086 | 383600 | 5011 |
1001940 | 1001940 | 2021-02-06 | Miami-Dade | Florida | 12086 | 382185 | 4979 |
998694 | 998694 | 2021-02-05 | Miami-Dade | Florida | 12086 | 380715 | 4964 |
995448 | 995448 | 2021-02-04 | Miami-Dade | Florida | 12086 | 377998 | 4942 |
992202 | 992202 | 2021-02-03 | Miami-Dade | Florida | 12086 | 376551 | 4919 |
988956 | 988956 | 2021-02-02 | Miami-Dade | Florida | 12086 | 375321 | 4907 |
985709 | 985709 | 2021-02-01 | Miami-Dade | Florida | 12086 | 373422 | 4905 |
982462 | 982462 | 2021-01-31 | Miami-Dade | Florida | 12086 | 372119 | 4874 |
979216 | 979216 | 2021-01-30 | Miami-Dade | Florida | 12086 | 370641 | 4845 |
975971 | 975971 | 2021-01-29 | Miami-Dade | Florida | 12086 | 368136 | 4817 |
972726 | 972726 | 2021-01-28 | Miami-Dade | Florida | 12086 | 366126 | 4797 |
969481 | 969481 | 2021-01-27 | Miami-Dade | Florida | 12086 | 364122 | 4768 |
966237 | 966237 | 2021-01-26 | Miami-Dade | Florida | 12086 | 362600 | 4759 |
962992 | 962992 | 2021-01-25 | Miami-Dade | Florida | 12086 | 360830 | 4747 |
959747 | 959747 | 2021-01-24 | Miami-Dade | Florida | 12086 | 358800 | 4730 |
956501 | 956501 | 2021-01-23 | Miami-Dade | Florida | 12086 | 357037 | 4703 |
953256 | 953256 | 2021-01-22 | Miami-Dade | Florida | 12086 | 354703 | 4678 |
950011 | 950011 | 2021-01-21 | Miami-Dade | Florida | 12086 | 352404 | 4644 |
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 |
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);