ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 12086 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 487 ✖
- 1173564 14
- 1176694 14
- 1182222 14
- 1192800 14
- 677570 11
- 1209302 8
- 495624 7
- 497726 7
- 499504 7
- 501540 7
- 504470 7
- 508841 7
- 515810 7
- 526897 7
- 542481 7
- 562190 7
- 583845 7
- 603878 7
- 620499 7
- 632579 7
- 642199 7
- 649565 7
- 656813 7
- 661638 7
- 665202 7
- 667933 7
- 670019 7
- 671987 7
- 673883 7
- 675844 7
- 681185 7
- 683842 7
- 695385 7
- 747820 7
- 847746 7
- 958187 7
- 1051508 7
- 1098467 7
- 1121486 7
- 1137694 7
- 1161882 7
- 1166573 7
- 1169782 7
- 1171903 7
- 500322 4
- 679200 3
- 8 2
- 174111 2
- 220413 2
- 283284 2
- 298872 2
- 1 1
- 2 1
- 13 1
- 23 1
- 43 1
- 77 1
- 101 1
- 124 1
- 170 1
- 228 1
- 277 1
- 365 1
- 489 1
- 653 1
- 869 1
- 1121 1
- 1471 1
- 1700 1
- 2123 1
- 2415 1
- 2885 1
- 3363 1
- 3889 1
- 4145 1
- 4670 1
- 5125 1
- 5460 1
- 5897 1
- 6299 1
- 6757 1
- 7057 1
- 7458 1
- 7711 1
- 8066 1
- 8325 1
- 8823 1
- 9044 1
- 9353 1
- 9656 1
- 10055 1
- 10152 1
- 10587 1
- 10925 1
- 11004 1
- 11350 1
- 11569 1
- 11830 1
- 11926 1
- 12063 1
- 12388 1
- 12631 1
- 12774 1
- 13091 1
- 13223 1
- 13370 1
- 13584 1
- 13663 1
- 13840 1
- 14006 1
- 14166 1
- 14384 1
- 14467 1
- 14741 1
- 15010 1
- 15365 1
- 15657 1
- 15863 1
- 15941 1
- 16033 1
- 16366 1
- 16521 1
- 16693 1
- 16844 1
- 17040 1
- 17167 1
- 17224 1
- 17395 1
- 17640 1
- 17825 1
- 17999 1
- 18138 1
- 18223 1
- 18455 1
- 18778 1
- 19055 1
- 19298 1
- 19546 1
- 19755 1
- 19979 1
- 20276 1
- 20547 1
- 20871 1
- 21632 1
- 21916 1
- 22196 1
- 22740 1
- 23272 1
- 23853 1
- 24375 1
- 25079 1
- 25789 1
- 26238 1
- 26821 1
- 27778 1
- 28663 1
- 30195 1
- 31561 1
- 33713 1
- 35221 1
- 36819 1
- 37960 1
- 40264 1
- 42310 1
- 44728 1
- 47010 1
- 48991 1
- 51057 1
- 53973 1
- 55960 1
- 58340 1
- 60867 1
- 64443 1
- 67712 1
- 69802 1
- 72316 1
- 75424 1
- 77866 1
- 81025 1
- 84237 1
- 87034 1
- 89556 1
- 92344 1
- 95067 1
- 98429 1
- 101853 1
- 104754 1
- 107314 1
- 110351 1
- 113142 1
- 115915 1
- 118461 1
- 121206 1
- 122689 1
- 123643 1
- 124758 1
- 125948 1
- 127676 1
- 129408 1
- 131216 1
- 132460 1
- 133622 1
- 135129 1
- 139270 1
- 140983 1
- 142661 1
- 144406 1
- 145306 1
- 146025 1
- 146989 1
- 148092 1
- 149161 1
- 150304 1
- 151213 1
- 151985 1
- 152611 1
- 153384 1
- 154134 1
- 154756 1
- 155417 1
- 156037 1
- 156558 1
- 156909 1
- 159058 1
- 159399 1
- 159977 1
- 160468 1
- 161017 1
- 161362 1
- 161636 1
- 162025 1
- 162432 1
- 162893 1
- 163374 1
- 163789 1
- 164085 1
- 164298 1
- 164687 1
- 165146 1
- 165594 1
- 165979 1
- 166515 1
- 166880 1
- 167152 1
- 167514 1
- 167879 1
- 168271 1
- 168774 1
- 169143 1
- 169425 1
- 169465 1
- 170085 1
- 170399 1
- 170881 1
- 171390 1
- 171875 1
- 172204 1
- 172397 1
- 172848 1
- 173279 1
- 173720 1
- 175117 1
- 175396 1
- 175836 1
- 176270 1
- 176808 1
- 177338 1
- 177892 1
- 178353 1
- 178725 1
- 179285 1
- 179643 1
- 180496 1
- 181016 1
- 181632 1
- 181941 1
- 182522 1
- 183249 1
- 183995 1
- 184668 1
- 185551 1
- 185890 1
- 186808 1
- 187756 1
- 188635 1
- 189331 1
- 190727 1
- 191837 1
- 192645 1
- 194355 1
- 194878 1
- 195272 1
- 195990 1
- 197195 1
- 199071 1
- 200258 1
- 202643 1
- 203653 1
- 205535 1
- 207220 1
- 209165 1
- 211256 1
- 213196 1
- 214942 1
- 216441 1
- 218293 1
- 224165 1
- 225631 1
- 227655 1
- 229617 1
- 231760 1
- 234053 1
- 236307 1
- 238812 1
- 241050 1
- 243049 1
- 245063 1
- 246914 1
- 249042 1
- 251282 1
- 253402 1
- 255461 1
- 257856 1
- 260137 1
- 262297 1
- 264672 1
- 267254 1
- 269715 1
- 272097 1
- 274116 1
- 276413 1
- 278738 1
- 280981 1
- 286661 1
- 288305 1
- 290362 1
- 293187 1
- 295935 1
- 304186 1
- 305733 1
- 308258 1
- 311605 1
- 314741 1
- 318114 1
- 321554 1
- 324259 1
- 326606 1
- 328700 1
- 331648 1
- 334216 1
- 336748 1
- 339433 1
- 341841 1
- 344245 1
- 346089 1
- 347964 1
- 350251 1
- 352404 1
- 354703 1
- 357037 1
- 358800 1
- 360830 1
- 362600 1
- 364122 1
- 366126 1
- 368136 1
- 370641 1
- 372119 1
- 373422 1
- 375321 1
- 376551 1
- 377998 1
- 380715 1
- 382185 1
- 383600 1
- 384970 1
- 386424 1
- 387939 1
- 389518 1
- 391161 1
- 392841 1
- 393970 1
- 394491 1
- 395827 1
- 397225 1
- 398042 1
- 399592 1
- 401136 1
- 402264 1
- 403258 1
- 404498 1
- 405562 1
- 406986 1
- 408095 1
- 409215 1
- 410716 1
- 410951 1
- 412907 1
- 414775 1
- 416020 1
- 417446 1
- 418410 1
- 419478 1
- 420339 1
- 421432 1
- 422539 1
- 423713 1
- 424902 1
- 426148 1
- 426899 1
- 427599 1
- 428872 1
- 429833 1
- 430941 1
- 432176 1
- 433451 1
- 434351 1
- 435134 1
- 436393 1
- 437451 1
- 438703 1
- 439969 1
- 441274 1
- 442336 1
- 443206 1
- 444486 1
- 445463 1
- 447041 1
- 448478 1
- 449890 1
- 451018 1
- 451828 1
- 453344 1
- 454404 1
- 456316 1
- 457917 1
- 459492 1
- 460652 1
- 461040 1
- 463364 1
- 464556 1
- 465999 1
- 467463 1
- 468907 1
- 470667 1
- 471594 1
- 472940 1
- 474068 1
- 475230 1
- 476285 1
- 477781 1
- 478659 1
- 479425 1
- 480482 1
- 481396 1
- 482442 1
- 483370 1
- 484513 1
- 485299 1
- 486024 1
- 486807 1
- 487543 1
- 488302 1
- 489013 1
- 489838 1
- 490498 1
- 491027 1
- 491702 1
- 492231 1
- 493006 1
- 493722 1
- 494373 1
- 494902 1
- 495366 1
- 495920 1
- 496421 1
- 496960 1
- 497370 1
- 498093 1
- 498556 1
- 498952 1
- 499200 1
- 499511 1
- 499955 1
- 501422 1
- 501638 1
- 501925 1
state 1
- Florida 794
fips 1
- 12086 · 794 ✖
county 1
- Miami-Dade 794
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1208 | 1208 | 2020-03-11 | Miami-Dade | Florida | 12086 | 1 | 0 |
1419 | 1419 | 2020-03-12 | Miami-Dade | Florida | 12086 | 2 | 0 |
1685 | 1685 | 2020-03-13 | Miami-Dade | Florida | 12086 | 8 | 0 |
2007 | 2007 | 2020-03-14 | Miami-Dade | Florida | 12086 | 8 | 0 |
2391 | 2391 | 2020-03-15 | Miami-Dade | Florida | 12086 | 13 | 0 |
2828 | 2828 | 2020-03-16 | Miami-Dade | Florida | 12086 | 23 | 0 |
3312 | 3312 | 2020-03-17 | Miami-Dade | Florida | 12086 | 43 | 0 |
3870 | 3870 | 2020-03-18 | Miami-Dade | Florida | 12086 | 77 | 0 |
4539 | 4539 | 2020-03-19 | Miami-Dade | Florida | 12086 | 101 | 0 |
5318 | 5318 | 2020-03-20 | Miami-Dade | Florida | 12086 | 124 | 0 |
6248 | 6248 | 2020-03-21 | Miami-Dade | Florida | 12086 | 170 | 0 |
7288 | 7288 | 2020-03-22 | Miami-Dade | Florida | 12086 | 228 | 0 |
8434 | 8434 | 2020-03-23 | Miami-Dade | Florida | 12086 | 277 | 0 |
9679 | 9679 | 2020-03-24 | Miami-Dade | Florida | 12086 | 365 | 0 |
11054 | 11054 | 2020-03-25 | Miami-Dade | Florida | 12086 | 489 | 0 |
12602 | 12602 | 2020-03-26 | Miami-Dade | Florida | 12086 | 653 | 0 |
14272 | 14272 | 2020-03-27 | Miami-Dade | Florida | 12086 | 869 | 2 |
16057 | 16057 | 2020-03-28 | Miami-Dade | Florida | 12086 | 1121 | 3 |
17950 | 17950 | 2020-03-29 | Miami-Dade | Florida | 12086 | 1471 | 3 |
19931 | 19931 | 2020-03-30 | Miami-Dade | Florida | 12086 | 1700 | 4 |
22009 | 22009 | 2020-03-31 | Miami-Dade | Florida | 12086 | 2123 | 7 |
24171 | 24171 | 2020-04-01 | Miami-Dade | Florida | 12086 | 2415 | 11 |
26401 | 26401 | 2020-04-02 | Miami-Dade | Florida | 12086 | 2885 | 20 |
28704 | 28704 | 2020-04-03 | Miami-Dade | Florida | 12086 | 3363 | 25 |
31064 | 31064 | 2020-04-04 | Miami-Dade | Florida | 12086 | 3889 | 31 |
33470 | 33470 | 2020-04-05 | Miami-Dade | Florida | 12086 | 4145 | 31 |
35916 | 35916 | 2020-04-06 | Miami-Dade | Florida | 12086 | 4670 | 41 |
38407 | 38407 | 2020-04-07 | Miami-Dade | Florida | 12086 | 5125 | 47 |
40951 | 40951 | 2020-04-08 | Miami-Dade | Florida | 12086 | 5460 | 50 |
43525 | 43525 | 2020-04-09 | Miami-Dade | Florida | 12086 | 5897 | 66 |
46127 | 46127 | 2020-04-10 | Miami-Dade | Florida | 12086 | 6299 | 84 |
48757 | 48757 | 2020-04-11 | Miami-Dade | Florida | 12086 | 6757 | 93 |
51418 | 51418 | 2020-04-12 | Miami-Dade | Florida | 12086 | 7057 | 97 |
54098 | 54098 | 2020-04-13 | Miami-Dade | Florida | 12086 | 7458 | 109 |
56790 | 56790 | 2020-04-14 | Miami-Dade | Florida | 12086 | 7711 | 143 |
59498 | 59498 | 2020-04-15 | Miami-Dade | Florida | 12086 | 8066 | 155 |
62217 | 62217 | 2020-04-16 | Miami-Dade | Florida | 12086 | 8325 | 183 |
64950 | 64950 | 2020-04-17 | Miami-Dade | Florida | 12086 | 8823 | 195 |
67698 | 67698 | 2020-04-18 | Miami-Dade | Florida | 12086 | 9044 | 198 |
70460 | 70460 | 2020-04-19 | Miami-Dade | Florida | 12086 | 9353 | 207 |
73229 | 73229 | 2020-04-20 | Miami-Dade | Florida | 12086 | 9656 | 223 |
76005 | 76005 | 2020-04-21 | Miami-Dade | Florida | 12086 | 10055 | 233 |
78789 | 78789 | 2020-04-22 | Miami-Dade | Florida | 12086 | 10152 | 240 |
81583 | 81583 | 2020-04-23 | Miami-Dade | Florida | 12086 | 10587 | 270 |
84383 | 84383 | 2020-04-24 | Miami-Dade | Florida | 12086 | 10925 | 287 |
87191 | 87191 | 2020-04-25 | Miami-Dade | Florida | 12086 | 11004 | 295 |
90008 | 90008 | 2020-04-26 | Miami-Dade | Florida | 12086 | 11350 | 301 |
92826 | 92826 | 2020-04-27 | Miami-Dade | Florida | 12086 | 11569 | 302 |
95658 | 95658 | 2020-04-28 | Miami-Dade | Florida | 12086 | 11830 | 324 |
98503 | 98503 | 2020-04-29 | Miami-Dade | Florida | 12086 | 11926 | 338 |
101353 | 101353 | 2020-04-30 | Miami-Dade | Florida | 12086 | 12063 | 352 |
104208 | 104208 | 2020-05-01 | Miami-Dade | Florida | 12086 | 12388 | 358 |
107073 | 107073 | 2020-05-02 | Miami-Dade | Florida | 12086 | 12631 | 367 |
109942 | 109942 | 2020-05-03 | Miami-Dade | Florida | 12086 | 12774 | 369 |
112817 | 112817 | 2020-05-04 | Miami-Dade | Florida | 12086 | 13091 | 378 |
115700 | 115700 | 2020-05-05 | Miami-Dade | Florida | 12086 | 13223 | 407 |
118660 | 118660 | 2020-05-06 | Miami-Dade | Florida | 12086 | 13370 | 432 |
121629 | 121629 | 2020-05-07 | Miami-Dade | Florida | 12086 | 13584 | 454 |
124608 | 124608 | 2020-05-08 | Miami-Dade | Florida | 12086 | 13663 | 468 |
127595 | 127595 | 2020-05-09 | Miami-Dade | Florida | 12086 | 13840 | 482 |
130586 | 130586 | 2020-05-10 | Miami-Dade | Florida | 12086 | 14006 | 487 |
133577 | 133577 | 2020-05-11 | Miami-Dade | Florida | 12086 | 14166 | 490 |
136566 | 136566 | 2020-05-12 | Miami-Dade | Florida | 12086 | 14384 | 505 |
139557 | 139557 | 2020-05-13 | Miami-Dade | Florida | 12086 | 14467 | 518 |
142553 | 142553 | 2020-05-14 | Miami-Dade | Florida | 12086 | 14741 | 535 |
145553 | 145553 | 2020-05-15 | Miami-Dade | Florida | 12086 | 15010 | 548 |
148556 | 148556 | 2020-05-16 | Miami-Dade | Florida | 12086 | 15365 | 559 |
151565 | 151565 | 2020-05-17 | Miami-Dade | Florida | 12086 | 15657 | 561 |
154577 | 154577 | 2020-05-18 | Miami-Dade | Florida | 12086 | 15863 | 566 |
157593 | 157593 | 2020-05-19 | Miami-Dade | Florida | 12086 | 15941 | 578 |
160619 | 160619 | 2020-05-20 | Miami-Dade | Florida | 12086 | 16033 | 578 |
163647 | 163647 | 2020-05-21 | Miami-Dade | Florida | 12086 | 16366 | 602 |
166680 | 166680 | 2020-05-22 | Miami-Dade | Florida | 12086 | 16521 | 614 |
169717 | 169717 | 2020-05-23 | Miami-Dade | Florida | 12086 | 16693 | 629 |
172758 | 172758 | 2020-05-24 | Miami-Dade | Florida | 12086 | 16844 | 631 |
175801 | 175801 | 2020-05-25 | Miami-Dade | Florida | 12086 | 17040 | 633 |
178845 | 178845 | 2020-05-26 | Miami-Dade | Florida | 12086 | 17167 | 633 |
181889 | 181889 | 2020-05-27 | Miami-Dade | Florida | 12086 | 17224 | 655 |
184943 | 184943 | 2020-05-28 | Miami-Dade | Florida | 12086 | 17395 | 669 |
187999 | 187999 | 2020-05-29 | Miami-Dade | Florida | 12086 | 17640 | 685 |
191064 | 191064 | 2020-05-30 | Miami-Dade | Florida | 12086 | 17825 | 700 |
194131 | 194131 | 2020-05-31 | Miami-Dade | Florida | 12086 | 17999 | 700 |
197201 | 197201 | 2020-06-01 | Miami-Dade | Florida | 12086 | 18138 | 702 |
200274 | 200274 | 2020-06-02 | Miami-Dade | Florida | 12086 | 18223 | 722 |
203350 | 203350 | 2020-06-03 | Miami-Dade | Florida | 12086 | 18455 | 731 |
206430 | 206430 | 2020-06-04 | Miami-Dade | Florida | 12086 | 18778 | 746 |
209511 | 209511 | 2020-06-05 | Miami-Dade | Florida | 12086 | 19055 | 760 |
212596 | 212596 | 2020-06-06 | Miami-Dade | Florida | 12086 | 19298 | 765 |
215683 | 215683 | 2020-06-07 | Miami-Dade | Florida | 12086 | 19546 | 765 |
218774 | 218774 | 2020-06-08 | Miami-Dade | Florida | 12086 | 19755 | 767 |
221869 | 221869 | 2020-06-09 | Miami-Dade | Florida | 12086 | 19979 | 774 |
224964 | 224964 | 2020-06-10 | Miami-Dade | Florida | 12086 | 20276 | 784 |
228066 | 228066 | 2020-06-11 | Miami-Dade | Florida | 12086 | 20547 | 798 |
231169 | 231169 | 2020-06-12 | Miami-Dade | Florida | 12086 | 20871 | 809 |
234275 | 234275 | 2020-06-13 | Miami-Dade | Florida | 12086 | 21632 | 822 |
237382 | 237382 | 2020-06-14 | Miami-Dade | Florida | 12086 | 21916 | 825 |
240490 | 240490 | 2020-06-15 | Miami-Dade | Florida | 12086 | 22196 | 826 |
243601 | 243601 | 2020-06-16 | Miami-Dade | Florida | 12086 | 22740 | 847 |
246714 | 246714 | 2020-06-17 | Miami-Dade | Florida | 12086 | 23272 | 850 |
249826 | 249826 | 2020-06-18 | Miami-Dade | Florida | 12086 | 23853 | 859 |
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);