ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Leon" and state = "Florida" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3868 | 3868 | 2020-03-18 | Leon | Florida | 12073 | 1 | 0 |
4536 | 4536 | 2020-03-19 | Leon | Florida | 12073 | 3 | 0 |
5315 | 5315 | 2020-03-20 | Leon | Florida | 12073 | 4 | 0 |
6244 | 6244 | 2020-03-21 | Leon | Florida | 12073 | 4 | 0 |
7284 | 7284 | 2020-03-22 | Leon | Florida | 12073 | 4 | 0 |
8430 | 8430 | 2020-03-23 | Leon | Florida | 12073 | 5 | 0 |
9675 | 9675 | 2020-03-24 | Leon | Florida | 12073 | 6 | 0 |
11050 | 11050 | 2020-03-25 | Leon | Florida | 12073 | 7 | 0 |
12598 | 12598 | 2020-03-26 | Leon | Florida | 12073 | 12 | 0 |
14267 | 14267 | 2020-03-27 | Leon | Florida | 12073 | 15 | 0 |
16052 | 16052 | 2020-03-28 | Leon | Florida | 12073 | 17 | 0 |
17945 | 17945 | 2020-03-29 | Leon | Florida | 12073 | 16 | 0 |
19926 | 19926 | 2020-03-30 | Leon | Florida | 12073 | 21 | 0 |
22004 | 22004 | 2020-03-31 | Leon | Florida | 12073 | 26 | 0 |
24165 | 24165 | 2020-04-01 | Leon | Florida | 12073 | 32 | 0 |
26395 | 26395 | 2020-04-02 | Leon | Florida | 12073 | 34 | 0 |
28698 | 28698 | 2020-04-03 | Leon | Florida | 12073 | 38 | 0 |
31058 | 31058 | 2020-04-04 | Leon | Florida | 12073 | 41 | 0 |
33464 | 33464 | 2020-04-05 | Leon | Florida | 12073 | 41 | 0 |
35910 | 35910 | 2020-04-06 | Leon | Florida | 12073 | 58 | 0 |
38401 | 38401 | 2020-04-07 | Leon | Florida | 12073 | 67 | 0 |
40945 | 40945 | 2020-04-08 | Leon | Florida | 12073 | 71 | 0 |
43519 | 43519 | 2020-04-09 | Leon | Florida | 12073 | 77 | 0 |
46120 | 46120 | 2020-04-10 | Leon | Florida | 12073 | 90 | 0 |
48750 | 48750 | 2020-04-11 | Leon | Florida | 12073 | 112 | 0 |
51411 | 51411 | 2020-04-12 | Leon | Florida | 12073 | 119 | 0 |
54091 | 54091 | 2020-04-13 | Leon | Florida | 12073 | 149 | 0 |
56783 | 56783 | 2020-04-14 | Leon | Florida | 12073 | 149 | 0 |
59491 | 59491 | 2020-04-15 | Leon | Florida | 12073 | 155 | 0 |
62210 | 62210 | 2020-04-16 | Leon | Florida | 12073 | 164 | 0 |
64943 | 64943 | 2020-04-17 | Leon | Florida | 12073 | 173 | 1 |
67691 | 67691 | 2020-04-18 | Leon | Florida | 12073 | 168 | 1 |
70453 | 70453 | 2020-04-19 | Leon | Florida | 12073 | 175 | 1 |
73222 | 73222 | 2020-04-20 | Leon | Florida | 12073 | 183 | 1 |
75998 | 75998 | 2020-04-21 | Leon | Florida | 12073 | 185 | 1 |
78782 | 78782 | 2020-04-22 | Leon | Florida | 12073 | 185 | 1 |
81576 | 81576 | 2020-04-23 | Leon | Florida | 12073 | 190 | 2 |
84376 | 84376 | 2020-04-24 | Leon | Florida | 12073 | 206 | 2 |
87184 | 87184 | 2020-04-25 | Leon | Florida | 12073 | 207 | 2 |
90001 | 90001 | 2020-04-26 | Leon | Florida | 12073 | 209 | 2 |
92819 | 92819 | 2020-04-27 | Leon | Florida | 12073 | 211 | 3 |
95651 | 95651 | 2020-04-28 | Leon | Florida | 12073 | 212 | 3 |
98496 | 98496 | 2020-04-29 | Leon | Florida | 12073 | 213 | 3 |
101346 | 101346 | 2020-04-30 | Leon | Florida | 12073 | 218 | 3 |
104201 | 104201 | 2020-05-01 | Leon | Florida | 12073 | 225 | 3 |
107066 | 107066 | 2020-05-02 | Leon | Florida | 12073 | 232 | 3 |
109935 | 109935 | 2020-05-03 | Leon | Florida | 12073 | 233 | 4 |
112810 | 112810 | 2020-05-04 | Leon | Florida | 12073 | 242 | 5 |
115693 | 115693 | 2020-05-05 | Leon | Florida | 12073 | 242 | 5 |
118653 | 118653 | 2020-05-06 | Leon | Florida | 12073 | 242 | 6 |
121622 | 121622 | 2020-05-07 | Leon | Florida | 12073 | 248 | 6 |
124601 | 124601 | 2020-05-08 | Leon | Florida | 12073 | 248 | 6 |
127588 | 127588 | 2020-05-09 | Leon | Florida | 12073 | 251 | 6 |
130579 | 130579 | 2020-05-10 | Leon | Florida | 12073 | 253 | 6 |
133570 | 133570 | 2020-05-11 | Leon | Florida | 12073 | 253 | 6 |
136559 | 136559 | 2020-05-12 | Leon | Florida | 12073 | 265 | 6 |
139550 | 139550 | 2020-05-13 | Leon | Florida | 12073 | 270 | 6 |
142546 | 142546 | 2020-05-14 | Leon | Florida | 12073 | 274 | 6 |
145546 | 145546 | 2020-05-15 | Leon | Florida | 12073 | 275 | 6 |
148549 | 148549 | 2020-05-16 | Leon | Florida | 12073 | 275 | 6 |
151558 | 151558 | 2020-05-17 | Leon | Florida | 12073 | 279 | 6 |
154570 | 154570 | 2020-05-18 | Leon | Florida | 12073 | 289 | 6 |
157586 | 157586 | 2020-05-19 | Leon | Florida | 12073 | 303 | 6 |
160612 | 160612 | 2020-05-20 | Leon | Florida | 12073 | 305 | 6 |
163640 | 163640 | 2020-05-21 | Leon | Florida | 12073 | 319 | 6 |
166673 | 166673 | 2020-05-22 | Leon | Florida | 12073 | 328 | 6 |
169710 | 169710 | 2020-05-23 | Leon | Florida | 12073 | 329 | 6 |
172751 | 172751 | 2020-05-24 | Leon | Florida | 12073 | 331 | 6 |
175794 | 175794 | 2020-05-25 | Leon | Florida | 12073 | 371 | 6 |
178838 | 178838 | 2020-05-26 | Leon | Florida | 12073 | 374 | 6 |
181882 | 181882 | 2020-05-27 | Leon | Florida | 12073 | 376 | 6 |
184936 | 184936 | 2020-05-28 | Leon | Florida | 12073 | 378 | 6 |
187992 | 187992 | 2020-05-29 | Leon | Florida | 12073 | 400 | 6 |
191057 | 191057 | 2020-05-30 | Leon | Florida | 12073 | 405 | 6 |
194124 | 194124 | 2020-05-31 | Leon | Florida | 12073 | 403 | 7 |
197194 | 197194 | 2020-06-01 | Leon | Florida | 12073 | 404 | 7 |
200267 | 200267 | 2020-06-02 | Leon | Florida | 12073 | 410 | 7 |
203343 | 203343 | 2020-06-03 | Leon | Florida | 12073 | 427 | 7 |
206423 | 206423 | 2020-06-04 | Leon | Florida | 12073 | 431 | 7 |
209504 | 209504 | 2020-06-05 | Leon | Florida | 12073 | 433 | 7 |
212589 | 212589 | 2020-06-06 | Leon | Florida | 12073 | 437 | 7 |
215676 | 215676 | 2020-06-07 | Leon | Florida | 12073 | 441 | 7 |
218767 | 218767 | 2020-06-08 | Leon | Florida | 12073 | 442 | 7 |
221862 | 221862 | 2020-06-09 | Leon | Florida | 12073 | 447 | 7 |
224957 | 224957 | 2020-06-10 | Leon | Florida | 12073 | 450 | 8 |
228059 | 228059 | 2020-06-11 | Leon | Florida | 12073 | 455 | 8 |
231162 | 231162 | 2020-06-12 | Leon | Florida | 12073 | 463 | 8 |
234268 | 234268 | 2020-06-13 | Leon | Florida | 12073 | 463 | 8 |
237375 | 237375 | 2020-06-14 | Leon | Florida | 12073 | 468 | 8 |
240483 | 240483 | 2020-06-15 | Leon | Florida | 12073 | 473 | 8 |
243594 | 243594 | 2020-06-16 | Leon | Florida | 12073 | 482 | 8 |
246707 | 246707 | 2020-06-17 | Leon | Florida | 12073 | 484 | 8 |
249819 | 249819 | 2020-06-18 | Leon | Florida | 12073 | 494 | 8 |
252934 | 252934 | 2020-06-19 | Leon | Florida | 12073 | 507 | 8 |
256053 | 256053 | 2020-06-20 | Leon | Florida | 12073 | 556 | 8 |
259180 | 259180 | 2020-06-21 | Leon | Florida | 12073 | 572 | 8 |
262307 | 262307 | 2020-06-22 | Leon | Florida | 12073 | 586 | 8 |
265435 | 265435 | 2020-06-23 | Leon | Florida | 12073 | 595 | 8 |
268565 | 268565 | 2020-06-24 | Leon | Florida | 12073 | 613 | 8 |
271701 | 271701 | 2020-06-25 | Leon | Florida | 12073 | 641 | 8 |
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);