ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Clay", fips = 12019 and state = "Florida" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1413 | 1413 | 2020-03-12 | Clay | Florida | 12019 | 1 | 0 |
1679 | 1679 | 2020-03-13 | Clay | Florida | 12019 | 1 | 0 |
2001 | 2001 | 2020-03-14 | Clay | Florida | 12019 | 1 | 0 |
2385 | 2385 | 2020-03-15 | Clay | Florida | 12019 | 3 | 0 |
2820 | 2820 | 2020-03-16 | Clay | Florida | 12019 | 3 | 0 |
3304 | 3304 | 2020-03-17 | Clay | Florida | 12019 | 4 | 0 |
3861 | 3861 | 2020-03-18 | Clay | Florida | 12019 | 4 | 1 |
4526 | 4526 | 2020-03-19 | Clay | Florida | 12019 | 4 | 1 |
5305 | 5305 | 2020-03-20 | Clay | Florida | 12019 | 4 | 1 |
6233 | 6233 | 2020-03-21 | Clay | Florida | 12019 | 6 | 1 |
7270 | 7270 | 2020-03-22 | Clay | Florida | 12019 | 7 | 1 |
8416 | 8416 | 2020-03-23 | Clay | Florida | 12019 | 8 | 2 |
9661 | 9661 | 2020-03-24 | Clay | Florida | 12019 | 10 | 2 |
11035 | 11035 | 2020-03-25 | Clay | Florida | 12019 | 16 | 2 |
12583 | 12583 | 2020-03-26 | Clay | Florida | 12019 | 20 | 4 |
14252 | 14252 | 2020-03-27 | Clay | Florida | 12019 | 22 | 4 |
16036 | 16036 | 2020-03-28 | Clay | Florida | 12019 | 26 | 4 |
17928 | 17928 | 2020-03-29 | Clay | Florida | 12019 | 35 | 4 |
19908 | 19908 | 2020-03-30 | Clay | Florida | 12019 | 34 | 5 |
21986 | 21986 | 2020-03-31 | Clay | Florida | 12019 | 41 | 5 |
24145 | 24145 | 2020-04-01 | Clay | Florida | 12019 | 53 | 5 |
26375 | 26375 | 2020-04-02 | Clay | Florida | 12019 | 58 | 6 |
28677 | 28677 | 2020-04-03 | Clay | Florida | 12019 | 69 | 6 |
31035 | 31035 | 2020-04-04 | Clay | Florida | 12019 | 74 | 6 |
33441 | 33441 | 2020-04-05 | Clay | Florida | 12019 | 79 | 6 |
35886 | 35886 | 2020-04-06 | Clay | Florida | 12019 | 81 | 6 |
38376 | 38376 | 2020-04-07 | Clay | Florida | 12019 | 88 | 7 |
40919 | 40919 | 2020-04-08 | Clay | Florida | 12019 | 99 | 7 |
43493 | 43493 | 2020-04-09 | Clay | Florida | 12019 | 110 | 7 |
46094 | 46094 | 2020-04-10 | Clay | Florida | 12019 | 144 | 8 |
48724 | 48724 | 2020-04-11 | Clay | Florida | 12019 | 161 | 8 |
51385 | 51385 | 2020-04-12 | Clay | Florida | 12019 | 163 | 8 |
54065 | 54065 | 2020-04-13 | Clay | Florida | 12019 | 165 | 9 |
56757 | 56757 | 2020-04-14 | Clay | Florida | 12019 | 168 | 9 |
59465 | 59465 | 2020-04-15 | Clay | Florida | 12019 | 170 | 9 |
62184 | 62184 | 2020-04-16 | Clay | Florida | 12019 | 184 | 9 |
64917 | 64917 | 2020-04-17 | Clay | Florida | 12019 | 216 | 9 |
67665 | 67665 | 2020-04-18 | Clay | Florida | 12019 | 223 | 9 |
70427 | 70427 | 2020-04-19 | Clay | Florida | 12019 | 247 | 11 |
73196 | 73196 | 2020-04-20 | Clay | Florida | 12019 | 249 | 11 |
75972 | 75972 | 2020-04-21 | Clay | Florida | 12019 | 256 | 11 |
78756 | 78756 | 2020-04-22 | Clay | Florida | 12019 | 257 | 11 |
81550 | 81550 | 2020-04-23 | Clay | Florida | 12019 | 264 | 12 |
84350 | 84350 | 2020-04-24 | Clay | Florida | 12019 | 266 | 14 |
87158 | 87158 | 2020-04-25 | Clay | Florida | 12019 | 267 | 14 |
89975 | 89975 | 2020-04-26 | Clay | Florida | 12019 | 267 | 13 |
92793 | 92793 | 2020-04-27 | Clay | Florida | 12019 | 271 | 14 |
95625 | 95625 | 2020-04-28 | Clay | Florida | 12019 | 272 | 14 |
98470 | 98470 | 2020-04-29 | Clay | Florida | 12019 | 272 | 15 |
101320 | 101320 | 2020-04-30 | Clay | Florida | 12019 | 273 | 15 |
104175 | 104175 | 2020-05-01 | Clay | Florida | 12019 | 276 | 16 |
107040 | 107040 | 2020-05-02 | Clay | Florida | 12019 | 278 | 18 |
109909 | 109909 | 2020-05-03 | Clay | Florida | 12019 | 279 | 18 |
112784 | 112784 | 2020-05-04 | Clay | Florida | 12019 | 285 | 18 |
115667 | 115667 | 2020-05-05 | Clay | Florida | 12019 | 287 | 18 |
118627 | 118627 | 2020-05-06 | Clay | Florida | 12019 | 288 | 19 |
121596 | 121596 | 2020-05-07 | Clay | Florida | 12019 | 292 | 19 |
124575 | 124575 | 2020-05-08 | Clay | Florida | 12019 | 293 | 19 |
127562 | 127562 | 2020-05-09 | Clay | Florida | 12019 | 299 | 19 |
130553 | 130553 | 2020-05-10 | Clay | Florida | 12019 | 300 | 19 |
133544 | 133544 | 2020-05-11 | Clay | Florida | 12019 | 302 | 21 |
136533 | 136533 | 2020-05-12 | Clay | Florida | 12019 | 303 | 22 |
139524 | 139524 | 2020-05-13 | Clay | Florida | 12019 | 303 | 22 |
142520 | 142520 | 2020-05-14 | Clay | Florida | 12019 | 306 | 22 |
145520 | 145520 | 2020-05-15 | Clay | Florida | 12019 | 308 | 23 |
148523 | 148523 | 2020-05-16 | Clay | Florida | 12019 | 313 | 25 |
151532 | 151532 | 2020-05-17 | Clay | Florida | 12019 | 317 | 25 |
154544 | 154544 | 2020-05-18 | Clay | Florida | 12019 | 320 | 25 |
157560 | 157560 | 2020-05-19 | Clay | Florida | 12019 | 321 | 25 |
160586 | 160586 | 2020-05-20 | Clay | Florida | 12019 | 333 | 25 |
163614 | 163614 | 2020-05-21 | Clay | Florida | 12019 | 351 | 25 |
166647 | 166647 | 2020-05-22 | Clay | Florida | 12019 | 354 | 25 |
169684 | 169684 | 2020-05-23 | Clay | Florida | 12019 | 354 | 27 |
172725 | 172725 | 2020-05-24 | Clay | Florida | 12019 | 357 | 27 |
175768 | 175768 | 2020-05-25 | Clay | Florida | 12019 | 362 | 27 |
178812 | 178812 | 2020-05-26 | Clay | Florida | 12019 | 365 | 27 |
181856 | 181856 | 2020-05-27 | Clay | Florida | 12019 | 366 | 28 |
184910 | 184910 | 2020-05-28 | Clay | Florida | 12019 | 369 | 28 |
187966 | 187966 | 2020-05-29 | Clay | Florida | 12019 | 374 | 28 |
191031 | 191031 | 2020-05-30 | Clay | Florida | 12019 | 380 | 28 |
194098 | 194098 | 2020-05-31 | Clay | Florida | 12019 | 382 | 28 |
197168 | 197168 | 2020-06-01 | Clay | Florida | 12019 | 383 | 28 |
200241 | 200241 | 2020-06-02 | Clay | Florida | 12019 | 387 | 30 |
203317 | 203317 | 2020-06-03 | Clay | Florida | 12019 | 390 | 33 |
206397 | 206397 | 2020-06-04 | Clay | Florida | 12019 | 394 | 32 |
209478 | 209478 | 2020-06-05 | Clay | Florida | 12019 | 393 | 32 |
212563 | 212563 | 2020-06-06 | Clay | Florida | 12019 | 396 | 32 |
215650 | 215650 | 2020-06-07 | Clay | Florida | 12019 | 400 | 32 |
218741 | 218741 | 2020-06-08 | Clay | Florida | 12019 | 405 | 32 |
221836 | 221836 | 2020-06-09 | Clay | Florida | 12019 | 411 | 32 |
224931 | 224931 | 2020-06-10 | Clay | Florida | 12019 | 420 | 32 |
228033 | 228033 | 2020-06-11 | Clay | Florida | 12019 | 427 | 32 |
231136 | 231136 | 2020-06-12 | Clay | Florida | 12019 | 429 | 32 |
234242 | 234242 | 2020-06-13 | Clay | Florida | 12019 | 429 | 32 |
237349 | 237349 | 2020-06-14 | Clay | Florida | 12019 | 435 | 32 |
240457 | 240457 | 2020-06-15 | Clay | Florida | 12019 | 440 | 32 |
243568 | 243568 | 2020-06-16 | Clay | Florida | 12019 | 443 | 32 |
246681 | 246681 | 2020-06-17 | Clay | Florida | 12019 | 450 | 32 |
249793 | 249793 | 2020-06-18 | Clay | Florida | 12019 | 456 | 32 |
252908 | 252908 | 2020-06-19 | Clay | Florida | 12019 | 468 | 32 |
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);