ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "St. Johns" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293755 | 293755 | 2020-07-02 | St. Johns | Florida | 12109 | 1088 | 8 |
290601 | 290601 | 2020-07-01 | St. Johns | Florida | 12109 | 989 | 7 |
287450 | 287450 | 2020-06-30 | St. Johns | Florida | 12109 | 948 | 7 |
284304 | 284304 | 2020-06-29 | St. Johns | Florida | 12109 | 895 | 7 |
281158 | 281158 | 2020-06-28 | St. Johns | Florida | 12109 | 837 | 7 |
278011 | 278011 | 2020-06-27 | St. Johns | Florida | 12109 | 756 | 7 |
274863 | 274863 | 2020-06-26 | St. Johns | Florida | 12109 | 682 | 7 |
271723 | 271723 | 2020-06-25 | St. Johns | Florida | 12109 | 599 | 7 |
268587 | 268587 | 2020-06-24 | St. Johns | Florida | 12109 | 548 | 7 |
265457 | 265457 | 2020-06-23 | St. Johns | Florida | 12109 | 510 | 7 |
262329 | 262329 | 2020-06-22 | St. Johns | Florida | 12109 | 496 | 7 |
259202 | 259202 | 2020-06-21 | St. Johns | Florida | 12109 | 461 | 7 |
256075 | 256075 | 2020-06-20 | St. Johns | Florida | 12109 | 433 | 7 |
252956 | 252956 | 2020-06-19 | St. Johns | Florida | 12109 | 398 | 7 |
249841 | 249841 | 2020-06-18 | St. Johns | Florida | 12109 | 365 | 7 |
246729 | 246729 | 2020-06-17 | St. Johns | Florida | 12109 | 347 | 6 |
243616 | 243616 | 2020-06-16 | St. Johns | Florida | 12109 | 333 | 6 |
240505 | 240505 | 2020-06-15 | St. Johns | Florida | 12109 | 315 | 6 |
237397 | 237397 | 2020-06-14 | St. Johns | Florida | 12109 | 307 | 6 |
234290 | 234290 | 2020-06-13 | St. Johns | Florida | 12109 | 298 | 6 |
231184 | 231184 | 2020-06-12 | St. Johns | Florida | 12109 | 292 | 6 |
228081 | 228081 | 2020-06-11 | St. Johns | Florida | 12109 | 287 | 6 |
224979 | 224979 | 2020-06-10 | St. Johns | Florida | 12109 | 288 | 6 |
221884 | 221884 | 2020-06-09 | St. Johns | Florida | 12109 | 287 | 6 |
218789 | 218789 | 2020-06-08 | St. Johns | Florida | 12109 | 282 | 6 |
215698 | 215698 | 2020-06-07 | St. Johns | Florida | 12109 | 279 | 6 |
212611 | 212611 | 2020-06-06 | St. Johns | Florida | 12109 | 272 | 6 |
209526 | 209526 | 2020-06-05 | St. Johns | Florida | 12109 | 270 | 6 |
206445 | 206445 | 2020-06-04 | St. Johns | Florida | 12109 | 267 | 6 |
203365 | 203365 | 2020-06-03 | St. Johns | Florida | 12109 | 269 | 6 |
200289 | 200289 | 2020-06-02 | St. Johns | Florida | 12109 | 262 | 6 |
197216 | 197216 | 2020-06-01 | St. Johns | Florida | 12109 | 260 | 6 |
194146 | 194146 | 2020-05-31 | St. Johns | Florida | 12109 | 260 | 6 |
191079 | 191079 | 2020-05-30 | St. Johns | Florida | 12109 | 256 | 6 |
188014 | 188014 | 2020-05-29 | St. Johns | Florida | 12109 | 252 | 6 |
184958 | 184958 | 2020-05-28 | St. Johns | Florida | 12109 | 247 | 5 |
181904 | 181904 | 2020-05-27 | St. Johns | Florida | 12109 | 245 | 5 |
178860 | 178860 | 2020-05-26 | St. Johns | Florida | 12109 | 241 | 5 |
175816 | 175816 | 2020-05-25 | St. Johns | Florida | 12109 | 240 | 5 |
172773 | 172773 | 2020-05-24 | St. Johns | Florida | 12109 | 239 | 5 |
169732 | 169732 | 2020-05-23 | St. Johns | Florida | 12109 | 238 | 5 |
166695 | 166695 | 2020-05-22 | St. Johns | Florida | 12109 | 236 | 5 |
163662 | 163662 | 2020-05-21 | St. Johns | Florida | 12109 | 235 | 5 |
160634 | 160634 | 2020-05-20 | St. Johns | Florida | 12109 | 233 | 5 |
157608 | 157608 | 2020-05-19 | St. Johns | Florida | 12109 | 233 | 5 |
154592 | 154592 | 2020-05-18 | St. Johns | Florida | 12109 | 232 | 5 |
151580 | 151580 | 2020-05-17 | St. Johns | Florida | 12109 | 231 | 5 |
148571 | 148571 | 2020-05-16 | St. Johns | Florida | 12109 | 231 | 5 |
145568 | 145568 | 2020-05-15 | St. Johns | Florida | 12109 | 231 | 5 |
142568 | 142568 | 2020-05-14 | St. Johns | Florida | 12109 | 231 | 5 |
139572 | 139572 | 2020-05-13 | St. Johns | Florida | 12109 | 229 | 4 |
136581 | 136581 | 2020-05-12 | St. Johns | Florida | 12109 | 223 | 4 |
133592 | 133592 | 2020-05-11 | St. Johns | Florida | 12109 | 222 | 4 |
130601 | 130601 | 2020-05-10 | St. Johns | Florida | 12109 | 222 | 4 |
127610 | 127610 | 2020-05-09 | St. Johns | Florida | 12109 | 222 | 4 |
124623 | 124623 | 2020-05-08 | St. Johns | Florida | 12109 | 223 | 4 |
121644 | 121644 | 2020-05-07 | St. Johns | Florida | 12109 | 222 | 4 |
118675 | 118675 | 2020-05-06 | St. Johns | Florida | 12109 | 216 | 4 |
115715 | 115715 | 2020-05-05 | St. Johns | Florida | 12109 | 214 | 4 |
112832 | 112832 | 2020-05-04 | St. Johns | Florida | 12109 | 211 | 4 |
109957 | 109957 | 2020-05-03 | St. Johns | Florida | 12109 | 211 | 4 |
107088 | 107088 | 2020-05-02 | St. Johns | Florida | 12109 | 212 | 4 |
104223 | 104223 | 2020-05-01 | St. Johns | Florida | 12109 | 210 | 4 |
101368 | 101368 | 2020-04-30 | St. Johns | Florida | 12109 | 208 | 4 |
98518 | 98518 | 2020-04-29 | St. Johns | Florida | 12109 | 207 | 4 |
95673 | 95673 | 2020-04-28 | St. Johns | Florida | 12109 | 207 | 4 |
92841 | 92841 | 2020-04-27 | St. Johns | Florida | 12109 | 204 | 4 |
90023 | 90023 | 2020-04-26 | St. Johns | Florida | 12109 | 204 | 4 |
87206 | 87206 | 2020-04-25 | St. Johns | Florida | 12109 | 203 | 4 |
84398 | 84398 | 2020-04-24 | St. Johns | Florida | 12109 | 203 | 4 |
81598 | 81598 | 2020-04-23 | St. Johns | Florida | 12109 | 200 | 4 |
78804 | 78804 | 2020-04-22 | St. Johns | Florida | 12109 | 195 | 4 |
76020 | 76020 | 2020-04-21 | St. Johns | Florida | 12109 | 194 | 4 |
73244 | 73244 | 2020-04-20 | St. Johns | Florida | 12109 | 192 | 4 |
70475 | 70475 | 2020-04-19 | St. Johns | Florida | 12109 | 190 | 4 |
67713 | 67713 | 2020-04-18 | St. Johns | Florida | 12109 | 188 | 4 |
64965 | 64965 | 2020-04-17 | St. Johns | Florida | 12109 | 186 | 4 |
62232 | 62232 | 2020-04-16 | St. Johns | Florida | 12109 | 182 | 3 |
59513 | 59513 | 2020-04-15 | St. Johns | Florida | 12109 | 179 | 3 |
56805 | 56805 | 2020-04-14 | St. Johns | Florida | 12109 | 177 | 2 |
54113 | 54113 | 2020-04-13 | St. Johns | Florida | 12109 | 176 | 2 |
51433 | 51433 | 2020-04-12 | St. Johns | Florida | 12109 | 173 | 2 |
48772 | 48772 | 2020-04-11 | St. Johns | Florida | 12109 | 170 | 2 |
46142 | 46142 | 2020-04-10 | St. Johns | Florida | 12109 | 165 | 2 |
43540 | 43540 | 2020-04-09 | St. Johns | Florida | 12109 | 163 | 2 |
40966 | 40966 | 2020-04-08 | St. Johns | Florida | 12109 | 156 | 2 |
38422 | 38422 | 2020-04-07 | St. Johns | Florida | 12109 | 154 | 2 |
35931 | 35931 | 2020-04-06 | St. Johns | Florida | 12109 | 147 | 2 |
33485 | 33485 | 2020-04-05 | St. Johns | Florida | 12109 | 141 | 2 |
31079 | 31079 | 2020-04-04 | St. Johns | Florida | 12109 | 132 | 2 |
28719 | 28719 | 2020-04-03 | St. Johns | Florida | 12109 | 119 | 2 |
26416 | 26416 | 2020-04-02 | St. Johns | Florida | 12109 | 102 | 2 |
24186 | 24186 | 2020-04-01 | St. Johns | Florida | 12109 | 90 | 2 |
22023 | 22023 | 2020-03-31 | St. Johns | Florida | 12109 | 79 | 2 |
19945 | 19945 | 2020-03-30 | St. Johns | Florida | 12109 | 61 | 2 |
17964 | 17964 | 2020-03-29 | St. Johns | Florida | 12109 | 59 | 2 |
16071 | 16071 | 2020-03-28 | St. Johns | Florida | 12109 | 50 | 2 |
14286 | 14286 | 2020-03-27 | St. Johns | Florida | 12109 | 42 | 2 |
12616 | 12616 | 2020-03-26 | St. Johns | Florida | 12109 | 36 | 1 |
11068 | 11068 | 2020-03-25 | St. Johns | Florida | 12109 | 28 | 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);