ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 12085 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4538 | 4538 | 2020-03-19 | Martin | Florida | 12085 | 1 | 0 |
5317 | 5317 | 2020-03-20 | Martin | Florida | 12085 | 1 | 0 |
6247 | 6247 | 2020-03-21 | Martin | Florida | 12085 | 1 | 0 |
7287 | 7287 | 2020-03-22 | Martin | Florida | 12085 | 2 | 0 |
8433 | 8433 | 2020-03-23 | Martin | Florida | 12085 | 4 | 0 |
9678 | 9678 | 2020-03-24 | Martin | Florida | 12085 | 4 | 0 |
11053 | 11053 | 2020-03-25 | Martin | Florida | 12085 | 7 | 0 |
12601 | 12601 | 2020-03-26 | Martin | Florida | 12085 | 11 | 0 |
14271 | 14271 | 2020-03-27 | Martin | Florida | 12085 | 17 | 0 |
16056 | 16056 | 2020-03-28 | Martin | Florida | 12085 | 26 | 0 |
17949 | 17949 | 2020-03-29 | Martin | Florida | 12085 | 27 | 0 |
19930 | 19930 | 2020-03-30 | Martin | Florida | 12085 | 27 | 0 |
22008 | 22008 | 2020-03-31 | Martin | Florida | 12085 | 28 | 0 |
24170 | 24170 | 2020-04-01 | Martin | Florida | 12085 | 33 | 0 |
26400 | 26400 | 2020-04-02 | Martin | Florida | 12085 | 34 | 0 |
28703 | 28703 | 2020-04-03 | Martin | Florida | 12085 | 42 | 0 |
31063 | 31063 | 2020-04-04 | Martin | Florida | 12085 | 53 | 0 |
33469 | 33469 | 2020-04-05 | Martin | Florida | 12085 | 60 | 0 |
35915 | 35915 | 2020-04-06 | Martin | Florida | 12085 | 85 | 0 |
38406 | 38406 | 2020-04-07 | Martin | Florida | 12085 | 100 | 0 |
40950 | 40950 | 2020-04-08 | Martin | Florida | 12085 | 108 | 1 |
43524 | 43524 | 2020-04-09 | Martin | Florida | 12085 | 109 | 1 |
46126 | 46126 | 2020-04-10 | Martin | Florida | 12085 | 115 | 3 |
48756 | 48756 | 2020-04-11 | Martin | Florida | 12085 | 117 | 3 |
51417 | 51417 | 2020-04-12 | Martin | Florida | 12085 | 122 | 3 |
54097 | 54097 | 2020-04-13 | Martin | Florida | 12085 | 129 | 3 |
56789 | 56789 | 2020-04-14 | Martin | Florida | 12085 | 135 | 4 |
59497 | 59497 | 2020-04-15 | Martin | Florida | 12085 | 140 | 4 |
62216 | 62216 | 2020-04-16 | Martin | Florida | 12085 | 142 | 4 |
64949 | 64949 | 2020-04-17 | Martin | Florida | 12085 | 147 | 4 |
67697 | 67697 | 2020-04-18 | Martin | Florida | 12085 | 148 | 4 |
70459 | 70459 | 2020-04-19 | Martin | Florida | 12085 | 151 | 4 |
73228 | 73228 | 2020-04-20 | Martin | Florida | 12085 | 155 | 4 |
76004 | 76004 | 2020-04-21 | Martin | Florida | 12085 | 160 | 4 |
78788 | 78788 | 2020-04-22 | Martin | Florida | 12085 | 161 | 4 |
81582 | 81582 | 2020-04-23 | Martin | Florida | 12085 | 166 | 5 |
84382 | 84382 | 2020-04-24 | Martin | Florida | 12085 | 169 | 5 |
87190 | 87190 | 2020-04-25 | Martin | Florida | 12085 | 169 | 5 |
90007 | 90007 | 2020-04-26 | Martin | Florida | 12085 | 174 | 5 |
92825 | 92825 | 2020-04-27 | Martin | Florida | 12085 | 183 | 5 |
95657 | 95657 | 2020-04-28 | Martin | Florida | 12085 | 185 | 5 |
98502 | 98502 | 2020-04-29 | Martin | Florida | 12085 | 186 | 5 |
101352 | 101352 | 2020-04-30 | Martin | Florida | 12085 | 191 | 6 |
104207 | 104207 | 2020-05-01 | Martin | Florida | 12085 | 197 | 6 |
107072 | 107072 | 2020-05-02 | Martin | Florida | 12085 | 199 | 6 |
109941 | 109941 | 2020-05-03 | Martin | Florida | 12085 | 202 | 6 |
112816 | 112816 | 2020-05-04 | Martin | Florida | 12085 | 215 | 6 |
115699 | 115699 | 2020-05-05 | Martin | Florida | 12085 | 218 | 6 |
118659 | 118659 | 2020-05-06 | Martin | Florida | 12085 | 224 | 6 |
121628 | 121628 | 2020-05-07 | Martin | Florida | 12085 | 233 | 6 |
124607 | 124607 | 2020-05-08 | Martin | Florida | 12085 | 243 | 6 |
127594 | 127594 | 2020-05-09 | Martin | Florida | 12085 | 245 | 6 |
130585 | 130585 | 2020-05-10 | Martin | Florida | 12085 | 255 | 6 |
133576 | 133576 | 2020-05-11 | Martin | Florida | 12085 | 261 | 6 |
136565 | 136565 | 2020-05-12 | Martin | Florida | 12085 | 274 | 6 |
139556 | 139556 | 2020-05-13 | Martin | Florida | 12085 | 275 | 6 |
142552 | 142552 | 2020-05-14 | Martin | Florida | 12085 | 281 | 6 |
145552 | 145552 | 2020-05-15 | Martin | Florida | 12085 | 294 | 6 |
148555 | 148555 | 2020-05-16 | Martin | Florida | 12085 | 296 | 6 |
151564 | 151564 | 2020-05-17 | Martin | Florida | 12085 | 321 | 7 |
154576 | 154576 | 2020-05-18 | Martin | Florida | 12085 | 371 | 7 |
157592 | 157592 | 2020-05-19 | Martin | Florida | 12085 | 396 | 8 |
160618 | 160618 | 2020-05-20 | Martin | Florida | 12085 | 419 | 8 |
163646 | 163646 | 2020-05-21 | Martin | Florida | 12085 | 472 | 8 |
166679 | 166679 | 2020-05-22 | Martin | Florida | 12085 | 476 | 9 |
169716 | 169716 | 2020-05-23 | Martin | Florida | 12085 | 483 | 9 |
172757 | 172757 | 2020-05-24 | Martin | Florida | 12085 | 494 | 9 |
175800 | 175800 | 2020-05-25 | Martin | Florida | 12085 | 510 | 9 |
178844 | 178844 | 2020-05-26 | Martin | Florida | 12085 | 535 | 9 |
181888 | 181888 | 2020-05-27 | Martin | Florida | 12085 | 550 | 9 |
184942 | 184942 | 2020-05-28 | Martin | Florida | 12085 | 557 | 9 |
187998 | 187998 | 2020-05-29 | Martin | Florida | 12085 | 601 | 9 |
191063 | 191063 | 2020-05-30 | Martin | Florida | 12085 | 626 | 9 |
194130 | 194130 | 2020-05-31 | Martin | Florida | 12085 | 651 | 9 |
197200 | 197200 | 2020-06-01 | Martin | Florida | 12085 | 652 | 9 |
200273 | 200273 | 2020-06-02 | Martin | Florida | 12085 | 680 | 10 |
203349 | 203349 | 2020-06-03 | Martin | Florida | 12085 | 729 | 10 |
206429 | 206429 | 2020-06-04 | Martin | Florida | 12085 | 764 | 10 |
209510 | 209510 | 2020-06-05 | Martin | Florida | 12085 | 810 | 12 |
212595 | 212595 | 2020-06-06 | Martin | Florida | 12085 | 849 | 12 |
215682 | 215682 | 2020-06-07 | Martin | Florida | 12085 | 907 | 13 |
218773 | 218773 | 2020-06-08 | Martin | Florida | 12085 | 917 | 13 |
221868 | 221868 | 2020-06-09 | Martin | Florida | 12085 | 934 | 15 |
224963 | 224963 | 2020-06-10 | Martin | Florida | 12085 | 958 | 15 |
228065 | 228065 | 2020-06-11 | Martin | Florida | 12085 | 1020 | 16 |
231168 | 231168 | 2020-06-12 | Martin | Florida | 12085 | 1056 | 17 |
234274 | 234274 | 2020-06-13 | Martin | Florida | 12085 | 1134 | 18 |
237381 | 237381 | 2020-06-14 | Martin | Florida | 12085 | 1170 | 18 |
240489 | 240489 | 2020-06-15 | Martin | Florida | 12085 | 1218 | 18 |
243600 | 243600 | 2020-06-16 | Martin | Florida | 12085 | 1296 | 18 |
246713 | 246713 | 2020-06-17 | Martin | Florida | 12085 | 1311 | 18 |
249825 | 249825 | 2020-06-18 | Martin | Florida | 12085 | 1324 | 19 |
252940 | 252940 | 2020-06-19 | Martin | Florida | 12085 | 1421 | 19 |
256059 | 256059 | 2020-06-20 | Martin | Florida | 12085 | 1460 | 20 |
259186 | 259186 | 2020-06-21 | Martin | Florida | 12085 | 1525 | 20 |
262313 | 262313 | 2020-06-22 | Martin | Florida | 12085 | 1582 | 20 |
265441 | 265441 | 2020-06-23 | Martin | Florida | 12085 | 1611 | 22 |
268571 | 268571 | 2020-06-24 | Martin | Florida | 12085 | 1639 | 22 |
271707 | 271707 | 2020-06-25 | Martin | Florida | 12085 | 1673 | 23 |
274847 | 274847 | 2020-06-26 | Martin | Florida | 12085 | 1713 | 23 |
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);