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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
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);