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 |
---|---|---|---|---|---|---|---|
293740 | 293740 | 2020-07-02 | Miami-Dade | Florida | 12086 | 40264 | 1018 |
290586 | 290586 | 2020-07-01 | Miami-Dade | Florida | 12086 | 37960 | 1000 |
287435 | 287435 | 2020-06-30 | Miami-Dade | Florida | 12086 | 36819 | 991 |
284289 | 284289 | 2020-06-29 | Miami-Dade | Florida | 12086 | 35221 | 975 |
281143 | 281143 | 2020-06-28 | Miami-Dade | Florida | 12086 | 33713 | 953 |
277996 | 277996 | 2020-06-27 | Miami-Dade | Florida | 12086 | 31561 | 947 |
274848 | 274848 | 2020-06-26 | Miami-Dade | Florida | 12086 | 30195 | 946 |
271708 | 271708 | 2020-06-25 | Miami-Dade | Florida | 12086 | 28663 | 935 |
268572 | 268572 | 2020-06-24 | Miami-Dade | Florida | 12086 | 27778 | 926 |
265442 | 265442 | 2020-06-23 | Miami-Dade | Florida | 12086 | 26821 | 902 |
262314 | 262314 | 2020-06-22 | Miami-Dade | Florida | 12086 | 26238 | 884 |
259187 | 259187 | 2020-06-21 | Miami-Dade | Florida | 12086 | 25789 | 884 |
256060 | 256060 | 2020-06-20 | Miami-Dade | Florida | 12086 | 25079 | 874 |
252941 | 252941 | 2020-06-19 | Miami-Dade | Florida | 12086 | 24375 | 864 |
249826 | 249826 | 2020-06-18 | Miami-Dade | Florida | 12086 | 23853 | 859 |
246714 | 246714 | 2020-06-17 | Miami-Dade | Florida | 12086 | 23272 | 850 |
243601 | 243601 | 2020-06-16 | Miami-Dade | Florida | 12086 | 22740 | 847 |
240490 | 240490 | 2020-06-15 | Miami-Dade | Florida | 12086 | 22196 | 826 |
237382 | 237382 | 2020-06-14 | Miami-Dade | Florida | 12086 | 21916 | 825 |
234275 | 234275 | 2020-06-13 | Miami-Dade | Florida | 12086 | 21632 | 822 |
231169 | 231169 | 2020-06-12 | Miami-Dade | Florida | 12086 | 20871 | 809 |
228066 | 228066 | 2020-06-11 | Miami-Dade | Florida | 12086 | 20547 | 798 |
224964 | 224964 | 2020-06-10 | Miami-Dade | Florida | 12086 | 20276 | 784 |
221869 | 221869 | 2020-06-09 | Miami-Dade | Florida | 12086 | 19979 | 774 |
218774 | 218774 | 2020-06-08 | Miami-Dade | Florida | 12086 | 19755 | 767 |
215683 | 215683 | 2020-06-07 | Miami-Dade | Florida | 12086 | 19546 | 765 |
212596 | 212596 | 2020-06-06 | Miami-Dade | Florida | 12086 | 19298 | 765 |
209511 | 209511 | 2020-06-05 | Miami-Dade | Florida | 12086 | 19055 | 760 |
206430 | 206430 | 2020-06-04 | Miami-Dade | Florida | 12086 | 18778 | 746 |
203350 | 203350 | 2020-06-03 | Miami-Dade | Florida | 12086 | 18455 | 731 |
200274 | 200274 | 2020-06-02 | Miami-Dade | Florida | 12086 | 18223 | 722 |
197201 | 197201 | 2020-06-01 | Miami-Dade | Florida | 12086 | 18138 | 702 |
194131 | 194131 | 2020-05-31 | Miami-Dade | Florida | 12086 | 17999 | 700 |
191064 | 191064 | 2020-05-30 | Miami-Dade | Florida | 12086 | 17825 | 700 |
187999 | 187999 | 2020-05-29 | Miami-Dade | Florida | 12086 | 17640 | 685 |
184943 | 184943 | 2020-05-28 | Miami-Dade | Florida | 12086 | 17395 | 669 |
181889 | 181889 | 2020-05-27 | Miami-Dade | Florida | 12086 | 17224 | 655 |
178845 | 178845 | 2020-05-26 | Miami-Dade | Florida | 12086 | 17167 | 633 |
175801 | 175801 | 2020-05-25 | Miami-Dade | Florida | 12086 | 17040 | 633 |
172758 | 172758 | 2020-05-24 | Miami-Dade | Florida | 12086 | 16844 | 631 |
169717 | 169717 | 2020-05-23 | Miami-Dade | Florida | 12086 | 16693 | 629 |
166680 | 166680 | 2020-05-22 | Miami-Dade | Florida | 12086 | 16521 | 614 |
163647 | 163647 | 2020-05-21 | Miami-Dade | Florida | 12086 | 16366 | 602 |
160619 | 160619 | 2020-05-20 | Miami-Dade | Florida | 12086 | 16033 | 578 |
157593 | 157593 | 2020-05-19 | Miami-Dade | Florida | 12086 | 15941 | 578 |
154577 | 154577 | 2020-05-18 | Miami-Dade | Florida | 12086 | 15863 | 566 |
151565 | 151565 | 2020-05-17 | Miami-Dade | Florida | 12086 | 15657 | 561 |
148556 | 148556 | 2020-05-16 | Miami-Dade | Florida | 12086 | 15365 | 559 |
145553 | 145553 | 2020-05-15 | Miami-Dade | Florida | 12086 | 15010 | 548 |
142553 | 142553 | 2020-05-14 | Miami-Dade | Florida | 12086 | 14741 | 535 |
139557 | 139557 | 2020-05-13 | Miami-Dade | Florida | 12086 | 14467 | 518 |
136566 | 136566 | 2020-05-12 | Miami-Dade | Florida | 12086 | 14384 | 505 |
133577 | 133577 | 2020-05-11 | Miami-Dade | Florida | 12086 | 14166 | 490 |
130586 | 130586 | 2020-05-10 | Miami-Dade | Florida | 12086 | 14006 | 487 |
127595 | 127595 | 2020-05-09 | Miami-Dade | Florida | 12086 | 13840 | 482 |
124608 | 124608 | 2020-05-08 | Miami-Dade | Florida | 12086 | 13663 | 468 |
121629 | 121629 | 2020-05-07 | Miami-Dade | Florida | 12086 | 13584 | 454 |
118660 | 118660 | 2020-05-06 | Miami-Dade | Florida | 12086 | 13370 | 432 |
115700 | 115700 | 2020-05-05 | Miami-Dade | Florida | 12086 | 13223 | 407 |
112817 | 112817 | 2020-05-04 | Miami-Dade | Florida | 12086 | 13091 | 378 |
109942 | 109942 | 2020-05-03 | Miami-Dade | Florida | 12086 | 12774 | 369 |
107073 | 107073 | 2020-05-02 | Miami-Dade | Florida | 12086 | 12631 | 367 |
104208 | 104208 | 2020-05-01 | Miami-Dade | Florida | 12086 | 12388 | 358 |
101353 | 101353 | 2020-04-30 | Miami-Dade | Florida | 12086 | 12063 | 352 |
98503 | 98503 | 2020-04-29 | Miami-Dade | Florida | 12086 | 11926 | 338 |
95658 | 95658 | 2020-04-28 | Miami-Dade | Florida | 12086 | 11830 | 324 |
92826 | 92826 | 2020-04-27 | Miami-Dade | Florida | 12086 | 11569 | 302 |
90008 | 90008 | 2020-04-26 | Miami-Dade | Florida | 12086 | 11350 | 301 |
87191 | 87191 | 2020-04-25 | Miami-Dade | Florida | 12086 | 11004 | 295 |
84383 | 84383 | 2020-04-24 | Miami-Dade | Florida | 12086 | 10925 | 287 |
81583 | 81583 | 2020-04-23 | Miami-Dade | Florida | 12086 | 10587 | 270 |
78789 | 78789 | 2020-04-22 | Miami-Dade | Florida | 12086 | 10152 | 240 |
76005 | 76005 | 2020-04-21 | Miami-Dade | Florida | 12086 | 10055 | 233 |
73229 | 73229 | 2020-04-20 | Miami-Dade | Florida | 12086 | 9656 | 223 |
70460 | 70460 | 2020-04-19 | Miami-Dade | Florida | 12086 | 9353 | 207 |
67698 | 67698 | 2020-04-18 | Miami-Dade | Florida | 12086 | 9044 | 198 |
64950 | 64950 | 2020-04-17 | Miami-Dade | Florida | 12086 | 8823 | 195 |
62217 | 62217 | 2020-04-16 | Miami-Dade | Florida | 12086 | 8325 | 183 |
59498 | 59498 | 2020-04-15 | Miami-Dade | Florida | 12086 | 8066 | 155 |
56790 | 56790 | 2020-04-14 | Miami-Dade | Florida | 12086 | 7711 | 143 |
54098 | 54098 | 2020-04-13 | Miami-Dade | Florida | 12086 | 7458 | 109 |
51418 | 51418 | 2020-04-12 | Miami-Dade | Florida | 12086 | 7057 | 97 |
48757 | 48757 | 2020-04-11 | Miami-Dade | Florida | 12086 | 6757 | 93 |
46127 | 46127 | 2020-04-10 | Miami-Dade | Florida | 12086 | 6299 | 84 |
43525 | 43525 | 2020-04-09 | Miami-Dade | Florida | 12086 | 5897 | 66 |
40951 | 40951 | 2020-04-08 | Miami-Dade | Florida | 12086 | 5460 | 50 |
38407 | 38407 | 2020-04-07 | Miami-Dade | Florida | 12086 | 5125 | 47 |
35916 | 35916 | 2020-04-06 | Miami-Dade | Florida | 12086 | 4670 | 41 |
33470 | 33470 | 2020-04-05 | Miami-Dade | Florida | 12086 | 4145 | 31 |
31064 | 31064 | 2020-04-04 | Miami-Dade | Florida | 12086 | 3889 | 31 |
28704 | 28704 | 2020-04-03 | Miami-Dade | Florida | 12086 | 3363 | 25 |
26401 | 26401 | 2020-04-02 | Miami-Dade | Florida | 12086 | 2885 | 20 |
24171 | 24171 | 2020-04-01 | Miami-Dade | Florida | 12086 | 2415 | 11 |
22009 | 22009 | 2020-03-31 | Miami-Dade | Florida | 12086 | 2123 | 7 |
19931 | 19931 | 2020-03-30 | Miami-Dade | Florida | 12086 | 1700 | 4 |
17950 | 17950 | 2020-03-29 | Miami-Dade | Florida | 12086 | 1471 | 3 |
16057 | 16057 | 2020-03-28 | Miami-Dade | Florida | 12086 | 1121 | 3 |
14272 | 14272 | 2020-03-27 | Miami-Dade | Florida | 12086 | 869 | 2 |
12602 | 12602 | 2020-03-26 | Miami-Dade | Florida | 12086 | 653 | 0 |
11054 | 11054 | 2020-03-25 | Miami-Dade | Florida | 12086 | 489 | 0 |
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);