ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19065 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6400 | 6400 | 2020-03-21 | Fayette | Iowa | 19065 | 1 | 0 |
7461 | 7461 | 2020-03-22 | Fayette | Iowa | 19065 | 1 | 0 |
8619 | 8619 | 2020-03-23 | Fayette | Iowa | 19065 | 1 | 0 |
9897 | 9897 | 2020-03-24 | Fayette | Iowa | 19065 | 1 | 0 |
11294 | 11294 | 2020-03-25 | Fayette | Iowa | 19065 | 1 | 0 |
12858 | 12858 | 2020-03-26 | Fayette | Iowa | 19065 | 1 | 0 |
14548 | 14548 | 2020-03-27 | Fayette | Iowa | 19065 | 1 | 0 |
16352 | 16352 | 2020-03-28 | Fayette | Iowa | 19065 | 2 | 0 |
18257 | 18257 | 2020-03-29 | Fayette | Iowa | 19065 | 2 | 0 |
20265 | 20265 | 2020-03-30 | Fayette | Iowa | 19065 | 2 | 0 |
22361 | 22361 | 2020-03-31 | Fayette | Iowa | 19065 | 2 | 0 |
24533 | 24533 | 2020-04-01 | Fayette | Iowa | 19065 | 2 | 0 |
26774 | 26774 | 2020-04-02 | Fayette | Iowa | 19065 | 2 | 0 |
29085 | 29085 | 2020-04-03 | Fayette | Iowa | 19065 | 3 | 0 |
31453 | 31453 | 2020-04-04 | Fayette | Iowa | 19065 | 3 | 0 |
33865 | 33865 | 2020-04-05 | Fayette | Iowa | 19065 | 3 | 0 |
36319 | 36319 | 2020-04-06 | Fayette | Iowa | 19065 | 3 | 0 |
38819 | 38819 | 2020-04-07 | Fayette | Iowa | 19065 | 3 | 0 |
41365 | 41365 | 2020-04-08 | Fayette | Iowa | 19065 | 3 | 0 |
43941 | 43941 | 2020-04-09 | Fayette | Iowa | 19065 | 3 | 0 |
46546 | 46546 | 2020-04-10 | Fayette | Iowa | 19065 | 4 | 0 |
49180 | 49180 | 2020-04-11 | Fayette | Iowa | 19065 | 4 | 0 |
51844 | 51844 | 2020-04-12 | Fayette | Iowa | 19065 | 4 | 0 |
54526 | 54526 | 2020-04-13 | Fayette | Iowa | 19065 | 5 | 0 |
57219 | 57219 | 2020-04-14 | Fayette | Iowa | 19065 | 5 | 0 |
59927 | 59927 | 2020-04-15 | Fayette | Iowa | 19065 | 5 | 0 |
62648 | 62648 | 2020-04-16 | Fayette | Iowa | 19065 | 5 | 0 |
65382 | 65382 | 2020-04-17 | Fayette | Iowa | 19065 | 6 | 0 |
68131 | 68131 | 2020-04-18 | Fayette | Iowa | 19065 | 6 | 0 |
70893 | 70893 | 2020-04-19 | Fayette | Iowa | 19065 | 6 | 0 |
73664 | 73664 | 2020-04-20 | Fayette | Iowa | 19065 | 6 | 0 |
76442 | 76442 | 2020-04-21 | Fayette | Iowa | 19065 | 7 | 0 |
79226 | 79226 | 2020-04-22 | Fayette | Iowa | 19065 | 7 | 0 |
82019 | 82019 | 2020-04-23 | Fayette | Iowa | 19065 | 7 | 0 |
84819 | 84819 | 2020-04-24 | Fayette | Iowa | 19065 | 10 | 0 |
87629 | 87629 | 2020-04-25 | Fayette | Iowa | 19065 | 12 | 0 |
90445 | 90445 | 2020-04-26 | Fayette | Iowa | 19065 | 15 | 0 |
93264 | 93264 | 2020-04-27 | Fayette | Iowa | 19065 | 16 | 0 |
96096 | 96096 | 2020-04-28 | Fayette | Iowa | 19065 | 17 | 0 |
98941 | 98941 | 2020-04-29 | Fayette | Iowa | 19065 | 20 | 0 |
101792 | 101792 | 2020-04-30 | Fayette | Iowa | 19065 | 20 | 0 |
104649 | 104649 | 2020-05-01 | Fayette | Iowa | 19065 | 21 | 0 |
107514 | 107514 | 2020-05-02 | Fayette | Iowa | 19065 | 22 | 0 |
110384 | 110384 | 2020-05-03 | Fayette | Iowa | 19065 | 22 | 0 |
113259 | 113259 | 2020-05-04 | Fayette | Iowa | 19065 | 23 | 0 |
116142 | 116142 | 2020-05-05 | Fayette | Iowa | 19065 | 23 | 0 |
119102 | 119102 | 2020-05-06 | Fayette | Iowa | 19065 | 24 | 0 |
122072 | 122072 | 2020-05-07 | Fayette | Iowa | 19065 | 24 | 0 |
125052 | 125052 | 2020-05-08 | Fayette | Iowa | 19065 | 24 | 0 |
128039 | 128039 | 2020-05-09 | Fayette | Iowa | 19065 | 24 | 0 |
131030 | 131030 | 2020-05-10 | Fayette | Iowa | 19065 | 24 | 0 |
134020 | 134020 | 2020-05-11 | Fayette | Iowa | 19065 | 24 | 0 |
137009 | 137009 | 2020-05-12 | Fayette | Iowa | 19065 | 24 | 0 |
140002 | 140002 | 2020-05-13 | Fayette | Iowa | 19065 | 24 | 0 |
142998 | 142998 | 2020-05-14 | Fayette | Iowa | 19065 | 24 | 0 |
145998 | 145998 | 2020-05-15 | Fayette | Iowa | 19065 | 25 | 0 |
149002 | 149002 | 2020-05-16 | Fayette | Iowa | 19065 | 25 | 0 |
152012 | 152012 | 2020-05-17 | Fayette | Iowa | 19065 | 25 | 0 |
155024 | 155024 | 2020-05-18 | Fayette | Iowa | 19065 | 25 | 0 |
158040 | 158040 | 2020-05-19 | Fayette | Iowa | 19065 | 25 | 0 |
161066 | 161066 | 2020-05-20 | Fayette | Iowa | 19065 | 25 | 0 |
164094 | 164094 | 2020-05-21 | Fayette | Iowa | 19065 | 25 | 0 |
167127 | 167127 | 2020-05-22 | Fayette | Iowa | 19065 | 26 | 0 |
170164 | 170164 | 2020-05-23 | Fayette | Iowa | 19065 | 26 | 0 |
173205 | 173205 | 2020-05-24 | Fayette | Iowa | 19065 | 26 | 0 |
176249 | 176249 | 2020-05-25 | Fayette | Iowa | 19065 | 26 | 0 |
179293 | 179293 | 2020-05-26 | Fayette | Iowa | 19065 | 26 | 0 |
182338 | 182338 | 2020-05-27 | Fayette | Iowa | 19065 | 26 | 0 |
185392 | 185392 | 2020-05-28 | Fayette | Iowa | 19065 | 26 | 0 |
188450 | 188450 | 2020-05-29 | Fayette | Iowa | 19065 | 26 | 0 |
191515 | 191515 | 2020-05-30 | Fayette | Iowa | 19065 | 27 | 0 |
194582 | 194582 | 2020-05-31 | Fayette | Iowa | 19065 | 27 | 0 |
197652 | 197652 | 2020-06-01 | Fayette | Iowa | 19065 | 27 | 0 |
200725 | 200725 | 2020-06-02 | Fayette | Iowa | 19065 | 27 | 0 |
203801 | 203801 | 2020-06-03 | Fayette | Iowa | 19065 | 28 | 0 |
206881 | 206881 | 2020-06-04 | Fayette | Iowa | 19065 | 28 | 0 |
209962 | 209962 | 2020-06-05 | Fayette | Iowa | 19065 | 27 | 0 |
213047 | 213047 | 2020-06-06 | Fayette | Iowa | 19065 | 27 | 0 |
216134 | 216134 | 2020-06-07 | Fayette | Iowa | 19065 | 28 | 0 |
219226 | 219226 | 2020-06-08 | Fayette | Iowa | 19065 | 28 | 0 |
222321 | 222321 | 2020-06-09 | Fayette | Iowa | 19065 | 28 | 0 |
225416 | 225416 | 2020-06-10 | Fayette | Iowa | 19065 | 28 | 0 |
228518 | 228518 | 2020-06-11 | Fayette | Iowa | 19065 | 28 | 0 |
231621 | 231621 | 2020-06-12 | Fayette | Iowa | 19065 | 28 | 0 |
234727 | 234727 | 2020-06-13 | Fayette | Iowa | 19065 | 28 | 0 |
237834 | 237834 | 2020-06-14 | Fayette | Iowa | 19065 | 28 | 0 |
240942 | 240942 | 2020-06-15 | Fayette | Iowa | 19065 | 28 | 0 |
244053 | 244053 | 2020-06-16 | Fayette | Iowa | 19065 | 28 | 0 |
247166 | 247166 | 2020-06-17 | Fayette | Iowa | 19065 | 28 | 0 |
250278 | 250278 | 2020-06-18 | Fayette | Iowa | 19065 | 28 | 0 |
253393 | 253393 | 2020-06-19 | Fayette | Iowa | 19065 | 28 | 0 |
256513 | 256513 | 2020-06-20 | Fayette | Iowa | 19065 | 28 | 0 |
259639 | 259639 | 2020-06-21 | Fayette | Iowa | 19065 | 29 | 0 |
262766 | 262766 | 2020-06-22 | Fayette | Iowa | 19065 | 29 | 0 |
265894 | 265894 | 2020-06-23 | Fayette | Iowa | 19065 | 30 | 0 |
269024 | 269024 | 2020-06-24 | Fayette | Iowa | 19065 | 30 | 0 |
272161 | 272161 | 2020-06-25 | Fayette | Iowa | 19065 | 30 | 0 |
275303 | 275303 | 2020-06-26 | Fayette | Iowa | 19065 | 30 | 0 |
278451 | 278451 | 2020-06-27 | Fayette | Iowa | 19065 | 31 | 0 |
281599 | 281599 | 2020-06-28 | Fayette | Iowa | 19065 | 31 | 0 |
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);