ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "Manatee" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
78786 | 78786 | 2020-04-22 | Manatee | Florida | 12081 | 445 | 34 |
76002 | 76002 | 2020-04-21 | Manatee | Florida | 12081 | 443 | 34 |
73226 | 73226 | 2020-04-20 | Manatee | Florida | 12081 | 433 | 33 |
70457 | 70457 | 2020-04-19 | Manatee | Florida | 12081 | 417 | 31 |
67695 | 67695 | 2020-04-18 | Manatee | Florida | 12081 | 362 | 31 |
64947 | 64947 | 2020-04-17 | Manatee | Florida | 12081 | 326 | 29 |
62214 | 62214 | 2020-04-16 | Manatee | Florida | 12081 | 309 | 20 |
59495 | 59495 | 2020-04-15 | Manatee | Florida | 12081 | 277 | 19 |
56787 | 56787 | 2020-04-14 | Manatee | Florida | 12081 | 261 | 19 |
54095 | 54095 | 2020-04-13 | Manatee | Florida | 12081 | 252 | 15 |
51415 | 51415 | 2020-04-12 | Manatee | Florida | 12081 | 236 | 13 |
48754 | 48754 | 2020-04-11 | Manatee | Florida | 12081 | 221 | 13 |
46124 | 46124 | 2020-04-10 | Manatee | Florida | 12081 | 200 | 13 |
43522 | 43522 | 2020-04-09 | Manatee | Florida | 12081 | 179 | 11 |
40948 | 40948 | 2020-04-08 | Manatee | Florida | 12081 | 172 | 8 |
38404 | 38404 | 2020-04-07 | Manatee | Florida | 12081 | 164 | 7 |
35913 | 35913 | 2020-04-06 | Manatee | Florida | 12081 | 145 | 5 |
33467 | 33467 | 2020-04-05 | Manatee | Florida | 12081 | 136 | 3 |
31061 | 31061 | 2020-04-04 | Manatee | Florida | 12081 | 129 | 3 |
28701 | 28701 | 2020-04-03 | Manatee | Florida | 12081 | 104 | 3 |
26398 | 26398 | 2020-04-02 | Manatee | Florida | 12081 | 89 | 3 |
24168 | 24168 | 2020-04-01 | Manatee | Florida | 12081 | 70 | 3 |
22006 | 22006 | 2020-03-31 | Manatee | Florida | 12081 | 53 | 2 |
19928 | 19928 | 2020-03-30 | Manatee | Florida | 12081 | 42 | 1 |
17947 | 17947 | 2020-03-29 | Manatee | Florida | 12081 | 38 | 1 |
16054 | 16054 | 2020-03-28 | Manatee | Florida | 12081 | 32 | 1 |
14269 | 14269 | 2020-03-27 | Manatee | Florida | 12081 | 29 | 1 |
12599 | 12599 | 2020-03-26 | Manatee | Florida | 12081 | 25 | 1 |
11051 | 11051 | 2020-03-25 | Manatee | Florida | 12081 | 26 | 1 |
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);