ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 12086 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277908 | 1277908 | 2021-05-02 | Miami-Dade | Florida | 12086 | 485299 | 6182 |
1274661 | 1274661 | 2021-05-01 | Miami-Dade | Florida | 12086 | 484513 | 6175 |
1271414 | 1271414 | 2021-04-30 | Miami-Dade | Florida | 12086 | 483370 | 6159 |
1268167 | 1268167 | 2021-04-29 | Miami-Dade | Florida | 12086 | 482442 | 6141 |
1264920 | 1264920 | 2021-04-28 | Miami-Dade | Florida | 12086 | 481396 | 6140 |
1261673 | 1261673 | 2021-04-27 | Miami-Dade | Florida | 12086 | 480482 | 6130 |
1258426 | 1258426 | 2021-04-26 | Miami-Dade | Florida | 12086 | 479425 | 6125 |
1255179 | 1255179 | 2021-04-25 | Miami-Dade | Florida | 12086 | 478659 | 6112 |
1251932 | 1251932 | 2021-04-24 | Miami-Dade | Florida | 12086 | 477781 | 6097 |
1248685 | 1248685 | 2021-04-23 | Miami-Dade | Florida | 12086 | 476285 | 6089 |
1245438 | 1245438 | 2021-04-22 | Miami-Dade | Florida | 12086 | 475230 | 6077 |
1242191 | 1242191 | 2021-04-21 | Miami-Dade | Florida | 12086 | 474068 | 6059 |
1238944 | 1238944 | 2021-04-20 | Miami-Dade | Florida | 12086 | 472940 | 6058 |
1235697 | 1235697 | 2021-04-19 | Miami-Dade | Florida | 12086 | 471594 | 6049 |
1232450 | 1232450 | 2021-04-18 | Miami-Dade | Florida | 12086 | 470667 | 6044 |
1229201 | 1229201 | 2021-04-17 | Miami-Dade | Florida | 12086 | 468907 | 6043 |
1225953 | 1225953 | 2021-04-16 | Miami-Dade | Florida | 12086 | 467463 | 6029 |
1222706 | 1222706 | 2021-04-15 | Miami-Dade | Florida | 12086 | 465999 | 6014 |
1219458 | 1219458 | 2021-04-14 | Miami-Dade | Florida | 12086 | 464556 | 5996 |
1216210 | 1216210 | 2021-04-13 | Miami-Dade | Florida | 12086 | 463364 | 5993 |
1212963 | 1212963 | 2021-04-12 | Miami-Dade | Florida | 12086 | 461040 | 5980 |
1209715 | 1209715 | 2021-04-11 | Miami-Dade | Florida | 12086 | 460652 | 5981 |
1206466 | 1206466 | 2021-04-10 | Miami-Dade | Florida | 12086 | 459492 | 5969 |
1203218 | 1203218 | 2021-04-09 | Miami-Dade | Florida | 12086 | 457917 | 5954 |
1199970 | 1199970 | 2021-04-08 | Miami-Dade | Florida | 12086 | 456316 | 5940 |
1196721 | 1196721 | 2021-04-07 | Miami-Dade | Florida | 12086 | 454404 | 5930 |
1193473 | 1193473 | 2021-04-06 | Miami-Dade | Florida | 12086 | 453344 | 5924 |
1190223 | 1190223 | 2021-04-05 | Miami-Dade | Florida | 12086 | 451828 | 5917 |
1186976 | 1186976 | 2021-04-04 | Miami-Dade | Florida | 12086 | 451018 | 5917 |
1183729 | 1183729 | 2021-04-03 | Miami-Dade | Florida | 12086 | 449890 | 5900 |
1180482 | 1180482 | 2021-04-02 | Miami-Dade | Florida | 12086 | 448478 | 5890 |
1177235 | 1177235 | 2021-04-01 | Miami-Dade | Florida | 12086 | 447041 | 5878 |
1173988 | 1173988 | 2021-03-31 | Miami-Dade | Florida | 12086 | 445463 | 5855 |
1170741 | 1170741 | 2021-03-30 | Miami-Dade | Florida | 12086 | 444486 | 5845 |
1167493 | 1167493 | 2021-03-29 | Miami-Dade | Florida | 12086 | 443206 | 5815 |
1164245 | 1164245 | 2021-03-28 | Miami-Dade | Florida | 12086 | 442336 | 5814 |
1160997 | 1160997 | 2021-03-27 | Miami-Dade | Florida | 12086 | 441274 | 5797 |
1157749 | 1157749 | 2021-03-26 | Miami-Dade | Florida | 12086 | 439969 | 5792 |
1154502 | 1154502 | 2021-03-25 | Miami-Dade | Florida | 12086 | 438703 | 5767 |
1151255 | 1151255 | 2021-03-24 | Miami-Dade | Florida | 12086 | 437451 | 5751 |
1148008 | 1148008 | 2021-03-23 | Miami-Dade | Florida | 12086 | 436393 | 5742 |
1144761 | 1144761 | 2021-03-22 | Miami-Dade | Florida | 12086 | 435134 | 5728 |
1141514 | 1141514 | 2021-03-21 | Miami-Dade | Florida | 12086 | 434351 | 5725 |
1138268 | 1138268 | 2021-03-20 | Miami-Dade | Florida | 12086 | 433451 | 5724 |
1135022 | 1135022 | 2021-03-19 | Miami-Dade | Florida | 12086 | 432176 | 5716 |
1131775 | 1131775 | 2021-03-18 | Miami-Dade | Florida | 12086 | 430941 | 5710 |
1128527 | 1128527 | 2021-03-17 | Miami-Dade | Florida | 12086 | 429833 | 5699 |
1125281 | 1125281 | 2021-03-16 | Miami-Dade | Florida | 12086 | 428872 | 5688 |
1122035 | 1122035 | 2021-03-15 | Miami-Dade | Florida | 12086 | 427599 | 5669 |
1118788 | 1118788 | 2021-03-14 | Miami-Dade | Florida | 12086 | 426899 | 5660 |
1115541 | 1115541 | 2021-03-13 | Miami-Dade | Florida | 12086 | 426148 | 5651 |
1112295 | 1112295 | 2021-03-12 | Miami-Dade | Florida | 12086 | 424902 | 5638 |
1109049 | 1109049 | 2021-03-11 | Miami-Dade | Florida | 12086 | 423713 | 5619 |
1105803 | 1105803 | 2021-03-10 | Miami-Dade | Florida | 12086 | 422539 | 5619 |
1102557 | 1102557 | 2021-03-09 | Miami-Dade | Florida | 12086 | 421432 | 5612 |
1099311 | 1099311 | 2021-03-08 | Miami-Dade | Florida | 12086 | 420339 | 5560 |
1096063 | 1096063 | 2021-03-07 | Miami-Dade | Florida | 12086 | 419478 | 5558 |
1092817 | 1092817 | 2021-03-06 | Miami-Dade | Florida | 12086 | 418410 | 5554 |
1089571 | 1089571 | 2021-03-05 | Miami-Dade | Florida | 12086 | 417446 | 5530 |
1086326 | 1086326 | 2021-03-04 | Miami-Dade | Florida | 12086 | 416020 | 5511 |
1083080 | 1083080 | 2021-03-03 | Miami-Dade | Florida | 12086 | 414775 | 5503 |
1079834 | 1079834 | 2021-03-02 | Miami-Dade | Florida | 12086 | 412907 | 5481 |
1076589 | 1076589 | 2021-03-01 | Miami-Dade | Florida | 12086 | 410951 | 5449 |
1073343 | 1073343 | 2021-02-28 | Miami-Dade | Florida | 12086 | 410716 | 5429 |
1070097 | 1070097 | 2021-02-27 | Miami-Dade | Florida | 12086 | 409215 | 5422 |
1066852 | 1066852 | 2021-02-26 | Miami-Dade | Florida | 12086 | 408095 | 5396 |
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 |
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);