ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 12005 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6228 | 6228 | 2020-03-21 | Bay | Florida | 12005 | 1 | 0 |
7264 | 7264 | 2020-03-22 | Bay | Florida | 12005 | 1 | 0 |
8410 | 8410 | 2020-03-23 | Bay | Florida | 12005 | 1 | 0 |
9655 | 9655 | 2020-03-24 | Bay | Florida | 12005 | 1 | 0 |
11029 | 11029 | 2020-03-25 | Bay | Florida | 12005 | 3 | 0 |
12577 | 12577 | 2020-03-26 | Bay | Florida | 12005 | 3 | 0 |
14246 | 14246 | 2020-03-27 | Bay | Florida | 12005 | 4 | 0 |
16030 | 16030 | 2020-03-28 | Bay | Florida | 12005 | 5 | 0 |
17922 | 17922 | 2020-03-29 | Bay | Florida | 12005 | 6 | 0 |
19902 | 19902 | 2020-03-30 | Bay | Florida | 12005 | 6 | 0 |
21979 | 21979 | 2020-03-31 | Bay | Florida | 12005 | 8 | 0 |
24138 | 24138 | 2020-04-01 | Bay | Florida | 12005 | 13 | 0 |
26368 | 26368 | 2020-04-02 | Bay | Florida | 12005 | 15 | 0 |
28670 | 28670 | 2020-04-03 | Bay | Florida | 12005 | 18 | 0 |
31028 | 31028 | 2020-04-04 | Bay | Florida | 12005 | 23 | 1 |
33434 | 33434 | 2020-04-05 | Bay | Florida | 12005 | 24 | 1 |
35879 | 35879 | 2020-04-06 | Bay | Florida | 12005 | 24 | 1 |
38369 | 38369 | 2020-04-07 | Bay | Florida | 12005 | 25 | 1 |
40912 | 40912 | 2020-04-08 | Bay | Florida | 12005 | 28 | 1 |
43486 | 43486 | 2020-04-09 | Bay | Florida | 12005 | 34 | 1 |
46087 | 46087 | 2020-04-10 | Bay | Florida | 12005 | 36 | 1 |
48717 | 48717 | 2020-04-11 | Bay | Florida | 12005 | 36 | 1 |
51378 | 51378 | 2020-04-12 | Bay | Florida | 12005 | 37 | 1 |
54058 | 54058 | 2020-04-13 | Bay | Florida | 12005 | 39 | 1 |
56750 | 56750 | 2020-04-14 | Bay | Florida | 12005 | 38 | 2 |
59458 | 59458 | 2020-04-15 | Bay | Florida | 12005 | 39 | 2 |
62177 | 62177 | 2020-04-16 | Bay | Florida | 12005 | 42 | 2 |
64910 | 64910 | 2020-04-17 | Bay | Florida | 12005 | 43 | 2 |
67658 | 67658 | 2020-04-18 | Bay | Florida | 12005 | 48 | 2 |
70420 | 70420 | 2020-04-19 | Bay | Florida | 12005 | 55 | 2 |
73189 | 73189 | 2020-04-20 | Bay | Florida | 12005 | 57 | 2 |
75965 | 75965 | 2020-04-21 | Bay | Florida | 12005 | 58 | 2 |
78749 | 78749 | 2020-04-22 | Bay | Florida | 12005 | 59 | 2 |
81543 | 81543 | 2020-04-23 | Bay | Florida | 12005 | 60 | 2 |
84343 | 84343 | 2020-04-24 | Bay | Florida | 12005 | 63 | 2 |
87151 | 87151 | 2020-04-25 | Bay | Florida | 12005 | 63 | 2 |
89968 | 89968 | 2020-04-26 | Bay | Florida | 12005 | 65 | 2 |
92786 | 92786 | 2020-04-27 | Bay | Florida | 12005 | 68 | 2 |
95618 | 95618 | 2020-04-28 | Bay | Florida | 12005 | 70 | 2 |
98463 | 98463 | 2020-04-29 | Bay | Florida | 12005 | 70 | 2 |
101313 | 101313 | 2020-04-30 | Bay | Florida | 12005 | 72 | 3 |
104168 | 104168 | 2020-05-01 | Bay | Florida | 12005 | 72 | 3 |
107033 | 107033 | 2020-05-02 | Bay | Florida | 12005 | 75 | 3 |
109902 | 109902 | 2020-05-03 | Bay | Florida | 12005 | 76 | 3 |
112777 | 112777 | 2020-05-04 | Bay | Florida | 12005 | 76 | 3 |
115660 | 115660 | 2020-05-05 | Bay | Florida | 12005 | 76 | 3 |
118620 | 118620 | 2020-05-06 | Bay | Florida | 12005 | 76 | 3 |
121589 | 121589 | 2020-05-07 | Bay | Florida | 12005 | 76 | 3 |
124568 | 124568 | 2020-05-08 | Bay | Florida | 12005 | 76 | 3 |
127555 | 127555 | 2020-05-09 | Bay | Florida | 12005 | 76 | 3 |
130546 | 130546 | 2020-05-10 | Bay | Florida | 12005 | 76 | 3 |
133537 | 133537 | 2020-05-11 | Bay | Florida | 12005 | 76 | 3 |
136526 | 136526 | 2020-05-12 | Bay | Florida | 12005 | 77 | 3 |
139517 | 139517 | 2020-05-13 | Bay | Florida | 12005 | 77 | 3 |
142513 | 142513 | 2020-05-14 | Bay | Florida | 12005 | 78 | 3 |
145513 | 145513 | 2020-05-15 | Bay | Florida | 12005 | 80 | 3 |
148516 | 148516 | 2020-05-16 | Bay | Florida | 12005 | 83 | 3 |
151525 | 151525 | 2020-05-17 | Bay | Florida | 12005 | 84 | 3 |
154537 | 154537 | 2020-05-18 | Bay | Florida | 12005 | 85 | 3 |
157553 | 157553 | 2020-05-19 | Bay | Florida | 12005 | 86 | 3 |
160579 | 160579 | 2020-05-20 | Bay | Florida | 12005 | 86 | 3 |
163607 | 163607 | 2020-05-21 | Bay | Florida | 12005 | 87 | 3 |
166640 | 166640 | 2020-05-22 | Bay | Florida | 12005 | 92 | 3 |
169677 | 169677 | 2020-05-23 | Bay | Florida | 12005 | 94 | 3 |
172718 | 172718 | 2020-05-24 | Bay | Florida | 12005 | 95 | 3 |
175761 | 175761 | 2020-05-25 | Bay | Florida | 12005 | 97 | 3 |
178805 | 178805 | 2020-05-26 | Bay | Florida | 12005 | 97 | 3 |
181849 | 181849 | 2020-05-27 | Bay | Florida | 12005 | 97 | 3 |
184903 | 184903 | 2020-05-28 | Bay | Florida | 12005 | 97 | 3 |
187959 | 187959 | 2020-05-29 | Bay | Florida | 12005 | 98 | 3 |
191024 | 191024 | 2020-05-30 | Bay | Florida | 12005 | 97 | 3 |
194091 | 194091 | 2020-05-31 | Bay | Florida | 12005 | 98 | 3 |
197161 | 197161 | 2020-06-01 | Bay | Florida | 12005 | 100 | 3 |
200234 | 200234 | 2020-06-02 | Bay | Florida | 12005 | 99 | 3 |
203310 | 203310 | 2020-06-03 | Bay | Florida | 12005 | 105 | 3 |
206390 | 206390 | 2020-06-04 | Bay | Florida | 12005 | 111 | 4 |
209471 | 209471 | 2020-06-05 | Bay | Florida | 12005 | 115 | 4 |
212556 | 212556 | 2020-06-06 | Bay | Florida | 12005 | 123 | 4 |
215643 | 215643 | 2020-06-07 | Bay | Florida | 12005 | 130 | 4 |
218734 | 218734 | 2020-06-08 | Bay | Florida | 12005 | 132 | 4 |
221829 | 221829 | 2020-06-09 | Bay | Florida | 12005 | 133 | 4 |
224924 | 224924 | 2020-06-10 | Bay | Florida | 12005 | 135 | 4 |
228026 | 228026 | 2020-06-11 | Bay | Florida | 12005 | 135 | 4 |
231129 | 231129 | 2020-06-12 | Bay | Florida | 12005 | 139 | 4 |
234235 | 234235 | 2020-06-13 | Bay | Florida | 12005 | 141 | 4 |
237342 | 237342 | 2020-06-14 | Bay | Florida | 12005 | 145 | 4 |
240450 | 240450 | 2020-06-15 | Bay | Florida | 12005 | 153 | 4 |
243561 | 243561 | 2020-06-16 | Bay | Florida | 12005 | 157 | 4 |
246674 | 246674 | 2020-06-17 | Bay | Florida | 12005 | 161 | 4 |
249786 | 249786 | 2020-06-18 | Bay | Florida | 12005 | 167 | 4 |
252901 | 252901 | 2020-06-19 | Bay | Florida | 12005 | 175 | 4 |
256020 | 256020 | 2020-06-20 | Bay | Florida | 12005 | 188 | 4 |
259147 | 259147 | 2020-06-21 | Bay | Florida | 12005 | 190 | 4 |
262274 | 262274 | 2020-06-22 | Bay | Florida | 12005 | 205 | 4 |
265402 | 265402 | 2020-06-23 | Bay | Florida | 12005 | 230 | 4 |
268532 | 268532 | 2020-06-24 | Bay | Florida | 12005 | 240 | 4 |
271668 | 271668 | 2020-06-25 | Bay | Florida | 12005 | 248 | 4 |
274808 | 274808 | 2020-06-26 | Bay | Florida | 12005 | 287 | 4 |
277956 | 277956 | 2020-06-27 | Bay | Florida | 12005 | 305 | 4 |
281103 | 281103 | 2020-06-28 | Bay | Florida | 12005 | 322 | 4 |
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);