ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 12081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386299 | 386299 | 2020-07-31 | Manatee | Florida | 12081 | 8517 | 182 |
383081 | 383081 | 2020-07-30 | Manatee | Florida | 12081 | 8337 | 176 |
379864 | 379864 | 2020-07-29 | Manatee | Florida | 12081 | 8187 | 173 |
376647 | 376647 | 2020-07-28 | Manatee | Florida | 12081 | 8090 | 158 |
373433 | 373433 | 2020-07-27 | Manatee | Florida | 12081 | 7982 | 156 |
370221 | 370221 | 2020-07-26 | Manatee | Florida | 12081 | 7859 | 154 |
367011 | 367011 | 2020-07-25 | Manatee | Florida | 12081 | 7709 | 154 |
363804 | 363804 | 2020-07-24 | Manatee | Florida | 12081 | 7520 | 153 |
360597 | 360597 | 2020-07-23 | Manatee | Florida | 12081 | 7252 | 152 |
357392 | 357392 | 2020-07-22 | Manatee | Florida | 12081 | 7078 | 149 |
354189 | 354189 | 2020-07-21 | Manatee | Florida | 12081 | 6871 | 149 |
350987 | 350987 | 2020-07-20 | Manatee | Florida | 12081 | 6738 | 144 |
347786 | 347786 | 2020-07-19 | Manatee | Florida | 12081 | 6569 | 143 |
344586 | 344586 | 2020-07-18 | Manatee | Florida | 12081 | 6280 | 143 |
341387 | 341387 | 2020-07-17 | Manatee | Florida | 12081 | 6133 | 143 |
338190 | 338190 | 2020-07-16 | Manatee | Florida | 12081 | 5914 | 143 |
334995 | 334995 | 2020-07-15 | Manatee | Florida | 12081 | 5564 | 139 |
331802 | 331802 | 2020-07-14 | Manatee | Florida | 12081 | 5419 | 140 |
328615 | 328615 | 2020-07-13 | Manatee | Florida | 12081 | 5266 | 140 |
325429 | 325429 | 2020-07-12 | Manatee | Florida | 12081 | 5112 | 138 |
322248 | 322248 | 2020-07-11 | Manatee | Florida | 12081 | 4632 | 138 |
319069 | 319069 | 2020-07-10 | Manatee | Florida | 12081 | 4432 | 138 |
315896 | 315896 | 2020-07-09 | Manatee | Florida | 12081 | 4266 | 138 |
312721 | 312721 | 2020-07-08 | Manatee | Florida | 12081 | 4080 | 135 |
309551 | 309551 | 2020-07-07 | Manatee | Florida | 12081 | 3890 | 135 |
306383 | 306383 | 2020-07-06 | Manatee | Florida | 12081 | 3785 | 132 |
303219 | 303219 | 2020-07-05 | Manatee | Florida | 12081 | 3716 | 131 |
300055 | 300055 | 2020-07-04 | Manatee | Florida | 12081 | 3554 | 131 |
296893 | 296893 | 2020-07-03 | Manatee | Florida | 12081 | 3261 | 131 |
293737 | 293737 | 2020-07-02 | Manatee | Florida | 12081 | 3175 | 130 |
290583 | 290583 | 2020-07-01 | Manatee | Florida | 12081 | 3015 | 129 |
287432 | 287432 | 2020-06-30 | Manatee | Florida | 12081 | 2856 | 130 |
284286 | 284286 | 2020-06-29 | Manatee | Florida | 12081 | 2810 | 130 |
281140 | 281140 | 2020-06-28 | Manatee | Florida | 12081 | 2737 | 130 |
277993 | 277993 | 2020-06-27 | Manatee | Florida | 12081 | 2642 | 129 |
274845 | 274845 | 2020-06-26 | Manatee | Florida | 12081 | 2368 | 128 |
271705 | 271705 | 2020-06-25 | Manatee | Florida | 12081 | 2202 | 128 |
268569 | 268569 | 2020-06-24 | Manatee | Florida | 12081 | 2132 | 127 |
265439 | 265439 | 2020-06-23 | Manatee | Florida | 12081 | 2013 | 127 |
262311 | 262311 | 2020-06-22 | Manatee | Florida | 12081 | 1977 | 126 |
259184 | 259184 | 2020-06-21 | Manatee | Florida | 12081 | 1890 | 126 |
256057 | 256057 | 2020-06-20 | Manatee | Florida | 12081 | 1786 | 126 |
252938 | 252938 | 2020-06-19 | Manatee | Florida | 12081 | 1649 | 124 |
249823 | 249823 | 2020-06-18 | Manatee | Florida | 12081 | 1548 | 122 |
246711 | 246711 | 2020-06-17 | Manatee | Florida | 12081 | 1523 | 117 |
243598 | 243598 | 2020-06-16 | Manatee | Florida | 12081 | 1483 | 116 |
240487 | 240487 | 2020-06-15 | Manatee | Florida | 12081 | 1421 | 115 |
237379 | 237379 | 2020-06-14 | Manatee | Florida | 12081 | 1377 | 115 |
234272 | 234272 | 2020-06-13 | Manatee | Florida | 12081 | 1353 | 115 |
231166 | 231166 | 2020-06-12 | Manatee | Florida | 12081 | 1309 | 114 |
228063 | 228063 | 2020-06-11 | Manatee | Florida | 12081 | 1253 | 114 |
224961 | 224961 | 2020-06-10 | Manatee | Florida | 12081 | 1245 | 112 |
221866 | 221866 | 2020-06-09 | Manatee | Florida | 12081 | 1229 | 111 |
218771 | 218771 | 2020-06-08 | Manatee | Florida | 12081 | 1219 | 105 |
215680 | 215680 | 2020-06-07 | Manatee | Florida | 12081 | 1189 | 105 |
212593 | 212593 | 2020-06-06 | Manatee | Florida | 12081 | 1177 | 105 |
209508 | 209508 | 2020-06-05 | Manatee | Florida | 12081 | 1162 | 105 |
206427 | 206427 | 2020-06-04 | Manatee | Florida | 12081 | 1134 | 100 |
203347 | 203347 | 2020-06-03 | Manatee | Florida | 12081 | 1110 | 98 |
200271 | 200271 | 2020-06-02 | Manatee | Florida | 12081 | 1074 | 98 |
197198 | 197198 | 2020-06-01 | Manatee | Florida | 12081 | 1057 | 97 |
194128 | 194128 | 2020-05-31 | Manatee | Florida | 12081 | 1045 | 97 |
191061 | 191061 | 2020-05-30 | Manatee | Florida | 12081 | 1037 | 97 |
187996 | 187996 | 2020-05-29 | Manatee | Florida | 12081 | 1022 | 96 |
184940 | 184940 | 2020-05-28 | Manatee | Florida | 12081 | 1007 | 95 |
181886 | 181886 | 2020-05-27 | Manatee | Florida | 12081 | 996 | 93 |
178842 | 178842 | 2020-05-26 | Manatee | Florida | 12081 | 990 | 91 |
175798 | 175798 | 2020-05-25 | Manatee | Florida | 12081 | 988 | 91 |
172755 | 172755 | 2020-05-24 | Manatee | Florida | 12081 | 975 | 91 |
169714 | 169714 | 2020-05-23 | Manatee | Florida | 12081 | 958 | 91 |
166677 | 166677 | 2020-05-22 | Manatee | Florida | 12081 | 946 | 90 |
163644 | 163644 | 2020-05-21 | Manatee | Florida | 12081 | 933 | 88 |
160616 | 160616 | 2020-05-20 | Manatee | Florida | 12081 | 893 | 84 |
157590 | 157590 | 2020-05-19 | Manatee | Florida | 12081 | 888 | 82 |
154574 | 154574 | 2020-05-18 | Manatee | Florida | 12081 | 867 | 81 |
151562 | 151562 | 2020-05-17 | Manatee | Florida | 12081 | 849 | 81 |
148553 | 148553 | 2020-05-16 | Manatee | Florida | 12081 | 834 | 81 |
145550 | 145550 | 2020-05-15 | Manatee | Florida | 12081 | 826 | 79 |
142550 | 142550 | 2020-05-14 | Manatee | Florida | 12081 | 813 | 78 |
139554 | 139554 | 2020-05-13 | Manatee | Florida | 12081 | 806 | 75 |
136563 | 136563 | 2020-05-12 | Manatee | Florida | 12081 | 795 | 74 |
133574 | 133574 | 2020-05-11 | Manatee | Florida | 12081 | 783 | 74 |
130583 | 130583 | 2020-05-10 | Manatee | Florida | 12081 | 776 | 74 |
127592 | 127592 | 2020-05-09 | Manatee | Florida | 12081 | 756 | 74 |
124605 | 124605 | 2020-05-08 | Manatee | Florida | 12081 | 742 | 72 |
121626 | 121626 | 2020-05-07 | Manatee | Florida | 12081 | 737 | 68 |
118657 | 118657 | 2020-05-06 | Manatee | Florida | 12081 | 722 | 64 |
115697 | 115697 | 2020-05-05 | Manatee | Florida | 12081 | 684 | 61 |
112814 | 112814 | 2020-05-04 | Manatee | Florida | 12081 | 636 | 59 |
109939 | 109939 | 2020-05-03 | Manatee | Florida | 12081 | 619 | 59 |
107070 | 107070 | 2020-05-02 | Manatee | Florida | 12081 | 607 | 59 |
104205 | 104205 | 2020-05-01 | Manatee | Florida | 12081 | 591 | 57 |
101350 | 101350 | 2020-04-30 | Manatee | Florida | 12081 | 580 | 55 |
98500 | 98500 | 2020-04-29 | Manatee | Florida | 12081 | 567 | 49 |
95655 | 95655 | 2020-04-28 | Manatee | Florida | 12081 | 563 | 46 |
92823 | 92823 | 2020-04-27 | Manatee | Florida | 12081 | 533 | 42 |
90005 | 90005 | 2020-04-26 | Manatee | Florida | 12081 | 508 | 42 |
87188 | 87188 | 2020-04-25 | Manatee | Florida | 12081 | 497 | 42 |
84380 | 84380 | 2020-04-24 | Manatee | Florida | 12081 | 491 | 42 |
81580 | 81580 | 2020-04-23 | Manatee | Florida | 12081 | 473 | 39 |
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);