ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Duval" and state = "Florida" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1415 | 1415 | 2020-03-12 | Duval | Florida | 12031 | 1 | 0 |
1681 | 1681 | 2020-03-13 | Duval | Florida | 12031 | 1 | 0 |
2003 | 2003 | 2020-03-14 | Duval | Florida | 12031 | 1 | 0 |
2387 | 2387 | 2020-03-15 | Duval | Florida | 12031 | 4 | 0 |
2822 | 2822 | 2020-03-16 | Duval | Florida | 12031 | 5 | 0 |
3306 | 3306 | 2020-03-17 | Duval | Florida | 12031 | 10 | 0 |
3863 | 3863 | 2020-03-18 | Duval | Florida | 12031 | 14 | 0 |
4528 | 4528 | 2020-03-19 | Duval | Florida | 12031 | 15 | 1 |
5307 | 5307 | 2020-03-20 | Duval | Florida | 12031 | 17 | 1 |
6235 | 6235 | 2020-03-21 | Duval | Florida | 12031 | 25 | 2 |
7274 | 7274 | 2020-03-22 | Duval | Florida | 12031 | 39 | 2 |
8420 | 8420 | 2020-03-23 | Duval | Florida | 12031 | 50 | 3 |
9665 | 9665 | 2020-03-24 | Duval | Florida | 12031 | 50 | 3 |
11039 | 11039 | 2020-03-25 | Duval | Florida | 12031 | 60 | 3 |
12587 | 12587 | 2020-03-26 | Duval | Florida | 12031 | 82 | 3 |
14256 | 14256 | 2020-03-27 | Duval | Florida | 12031 | 99 | 3 |
16040 | 16040 | 2020-03-28 | Duval | Florida | 12031 | 120 | 3 |
17932 | 17932 | 2020-03-29 | Duval | Florida | 12031 | 142 | 3 |
19912 | 19912 | 2020-03-30 | Duval | Florida | 12031 | 163 | 4 |
21990 | 21990 | 2020-03-31 | Duval | Florida | 12031 | 207 | 4 |
24149 | 24149 | 2020-04-01 | Duval | Florida | 12031 | 239 | 4 |
26379 | 26379 | 2020-04-02 | Duval | Florida | 12031 | 286 | 9 |
28681 | 28681 | 2020-04-03 | Duval | Florida | 12031 | 323 | 9 |
31040 | 31040 | 2020-04-04 | Duval | Florida | 12031 | 387 | 9 |
33446 | 33446 | 2020-04-05 | Duval | Florida | 12031 | 413 | 9 |
35891 | 35891 | 2020-04-06 | Duval | Florida | 12031 | 478 | 9 |
38381 | 38381 | 2020-04-07 | Duval | Florida | 12031 | 521 | 10 |
40924 | 40924 | 2020-04-08 | Duval | Florida | 12031 | 557 | 10 |
43498 | 43498 | 2020-04-09 | Duval | Florida | 12031 | 595 | 11 |
46099 | 46099 | 2020-04-10 | Duval | Florida | 12031 | 618 | 11 |
48729 | 48729 | 2020-04-11 | Duval | Florida | 12031 | 639 | 13 |
51390 | 51390 | 2020-04-12 | Duval | Florida | 12031 | 668 | 13 |
54070 | 54070 | 2020-04-13 | Duval | Florida | 12031 | 691 | 13 |
56762 | 56762 | 2020-04-14 | Duval | Florida | 12031 | 718 | 14 |
59470 | 59470 | 2020-04-15 | Duval | Florida | 12031 | 746 | 14 |
62189 | 62189 | 2020-04-16 | Duval | Florida | 12031 | 776 | 14 |
64922 | 64922 | 2020-04-17 | Duval | Florida | 12031 | 817 | 15 |
67670 | 67670 | 2020-04-18 | Duval | Florida | 12031 | 835 | 15 |
70432 | 70432 | 2020-04-19 | Duval | Florida | 12031 | 854 | 15 |
73201 | 73201 | 2020-04-20 | Duval | Florida | 12031 | 896 | 16 |
75977 | 75977 | 2020-04-21 | Duval | Florida | 12031 | 909 | 17 |
78761 | 78761 | 2020-04-22 | Duval | Florida | 12031 | 925 | 17 |
84355 | 84355 | 2020-04-24 | Duval | Florida | 12031 | 955 | 18 |
81555 | 81555 | 2020-04-23 | Duval | Florida | 12031 | 956 | 17 |
87163 | 87163 | 2020-04-25 | Duval | Florida | 12031 | 965 | 18 |
89980 | 89980 | 2020-04-26 | Duval | Florida | 12031 | 984 | 18 |
92798 | 92798 | 2020-04-27 | Duval | Florida | 12031 | 990 | 19 |
95630 | 95630 | 2020-04-28 | Duval | Florida | 12031 | 1001 | 20 |
98475 | 98475 | 2020-04-29 | Duval | Florida | 12031 | 1007 | 20 |
101325 | 101325 | 2020-04-30 | Duval | Florida | 12031 | 1012 | 20 |
104180 | 104180 | 2020-05-01 | Duval | Florida | 12031 | 1025 | 22 |
107045 | 107045 | 2020-05-02 | Duval | Florida | 12031 | 1038 | 23 |
109914 | 109914 | 2020-05-03 | Duval | Florida | 12031 | 1045 | 24 |
112789 | 112789 | 2020-05-04 | Duval | Florida | 12031 | 1072 | 26 |
118632 | 118632 | 2020-05-06 | Duval | Florida | 12031 | 1077 | 26 |
121601 | 121601 | 2020-05-07 | Duval | Florida | 12031 | 1083 | 28 |
115672 | 115672 | 2020-05-05 | Duval | Florida | 12031 | 1084 | 26 |
124580 | 124580 | 2020-05-08 | Duval | Florida | 12031 | 1088 | 29 |
127567 | 127567 | 2020-05-09 | Duval | Florida | 12031 | 1134 | 29 |
130558 | 130558 | 2020-05-10 | Duval | Florida | 12031 | 1164 | 29 |
133549 | 133549 | 2020-05-11 | Duval | Florida | 12031 | 1171 | 29 |
136538 | 136538 | 2020-05-12 | Duval | Florida | 12031 | 1186 | 29 |
139529 | 139529 | 2020-05-13 | Duval | Florida | 12031 | 1199 | 32 |
142525 | 142525 | 2020-05-14 | Duval | Florida | 12031 | 1215 | 32 |
145525 | 145525 | 2020-05-15 | Duval | Florida | 12031 | 1252 | 32 |
148528 | 148528 | 2020-05-16 | Duval | Florida | 12031 | 1259 | 34 |
151537 | 151537 | 2020-05-17 | Duval | Florida | 12031 | 1284 | 35 |
154549 | 154549 | 2020-05-18 | Duval | Florida | 12031 | 1300 | 35 |
157565 | 157565 | 2020-05-19 | Duval | Florida | 12031 | 1318 | 36 |
160591 | 160591 | 2020-05-20 | Duval | Florida | 12031 | 1336 | 36 |
163619 | 163619 | 2020-05-21 | Duval | Florida | 12031 | 1355 | 37 |
166652 | 166652 | 2020-05-22 | Duval | Florida | 12031 | 1376 | 41 |
169689 | 169689 | 2020-05-23 | Duval | Florida | 12031 | 1406 | 41 |
172730 | 172730 | 2020-05-24 | Duval | Florida | 12031 | 1439 | 41 |
175773 | 175773 | 2020-05-25 | Duval | Florida | 12031 | 1467 | 43 |
178817 | 178817 | 2020-05-26 | Duval | Florida | 12031 | 1484 | 44 |
181861 | 181861 | 2020-05-27 | Duval | Florida | 12031 | 1507 | 46 |
184915 | 184915 | 2020-05-28 | Duval | Florida | 12031 | 1523 | 46 |
187971 | 187971 | 2020-05-29 | Duval | Florida | 12031 | 1561 | 47 |
191036 | 191036 | 2020-05-30 | Duval | Florida | 12031 | 1608 | 48 |
194103 | 194103 | 2020-05-31 | Duval | Florida | 12031 | 1644 | 50 |
197173 | 197173 | 2020-06-01 | Duval | Florida | 12031 | 1654 | 51 |
200246 | 200246 | 2020-06-02 | Duval | Florida | 12031 | 1660 | 51 |
203322 | 203322 | 2020-06-03 | Duval | Florida | 12031 | 1669 | 51 |
206402 | 206402 | 2020-06-04 | Duval | Florida | 12031 | 1702 | 51 |
209483 | 209483 | 2020-06-05 | Duval | Florida | 12031 | 1736 | 52 |
212568 | 212568 | 2020-06-06 | Duval | Florida | 12031 | 1764 | 53 |
215655 | 215655 | 2020-06-07 | Duval | Florida | 12031 | 1792 | 54 |
218746 | 218746 | 2020-06-08 | Duval | Florida | 12031 | 1806 | 55 |
221841 | 221841 | 2020-06-09 | Duval | Florida | 12031 | 1824 | 54 |
224936 | 224936 | 2020-06-10 | Duval | Florida | 12031 | 1848 | 55 |
228038 | 228038 | 2020-06-11 | Duval | Florida | 12031 | 1893 | 57 |
231141 | 231141 | 2020-06-12 | Duval | Florida | 12031 | 1923 | 57 |
234247 | 234247 | 2020-06-13 | Duval | Florida | 12031 | 1961 | 57 |
237354 | 237354 | 2020-06-14 | Duval | Florida | 12031 | 1990 | 57 |
240462 | 240462 | 2020-06-15 | Duval | Florida | 12031 | 2032 | 57 |
243573 | 243573 | 2020-06-16 | Duval | Florida | 12031 | 2112 | 59 |
246686 | 246686 | 2020-06-17 | Duval | Florida | 12031 | 2194 | 59 |
249798 | 249798 | 2020-06-18 | Duval | Florida | 12031 | 2309 | 60 |
252913 | 252913 | 2020-06-19 | Duval | Florida | 12031 | 2484 | 60 |
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);