ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 19085 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1727 | 1727 | 2020-03-13 | Harrison | Iowa | 19085 | 1 | 0 |
2061 | 2061 | 2020-03-14 | Harrison | Iowa | 19085 | 1 | 0 |
2456 | 2456 | 2020-03-15 | Harrison | Iowa | 19085 | 1 | 0 |
2901 | 2901 | 2020-03-16 | Harrison | Iowa | 19085 | 1 | 0 |
3394 | 3394 | 2020-03-17 | Harrison | Iowa | 19085 | 1 | 0 |
3968 | 3968 | 2020-03-18 | Harrison | Iowa | 19085 | 1 | 0 |
4648 | 4648 | 2020-03-19 | Harrison | Iowa | 19085 | 1 | 0 |
5459 | 5459 | 2020-03-20 | Harrison | Iowa | 19085 | 1 | 0 |
6401 | 6401 | 2020-03-21 | Harrison | Iowa | 19085 | 1 | 0 |
7462 | 7462 | 2020-03-22 | Harrison | Iowa | 19085 | 3 | 0 |
8621 | 8621 | 2020-03-23 | Harrison | Iowa | 19085 | 3 | 0 |
9899 | 9899 | 2020-03-24 | Harrison | Iowa | 19085 | 3 | 0 |
11296 | 11296 | 2020-03-25 | Harrison | Iowa | 19085 | 3 | 0 |
12860 | 12860 | 2020-03-26 | Harrison | Iowa | 19085 | 3 | 0 |
14551 | 14551 | 2020-03-27 | Harrison | Iowa | 19085 | 7 | 0 |
16355 | 16355 | 2020-03-28 | Harrison | Iowa | 19085 | 8 | 0 |
18260 | 18260 | 2020-03-29 | Harrison | Iowa | 19085 | 8 | 0 |
20269 | 20269 | 2020-03-30 | Harrison | Iowa | 19085 | 8 | 0 |
22365 | 22365 | 2020-03-31 | Harrison | Iowa | 19085 | 9 | 0 |
24537 | 24537 | 2020-04-01 | Harrison | Iowa | 19085 | 10 | 0 |
26778 | 26778 | 2020-04-02 | Harrison | Iowa | 19085 | 10 | 0 |
29089 | 29089 | 2020-04-03 | Harrison | Iowa | 19085 | 10 | 0 |
31458 | 31458 | 2020-04-04 | Harrison | Iowa | 19085 | 10 | 0 |
33871 | 33871 | 2020-04-05 | Harrison | Iowa | 19085 | 10 | 0 |
36326 | 36326 | 2020-04-06 | Harrison | Iowa | 19085 | 10 | 0 |
38827 | 38827 | 2020-04-07 | Harrison | Iowa | 19085 | 10 | 0 |
41373 | 41373 | 2020-04-08 | Harrison | Iowa | 19085 | 11 | 0 |
43949 | 43949 | 2020-04-09 | Harrison | Iowa | 19085 | 11 | 0 |
46554 | 46554 | 2020-04-10 | Harrison | Iowa | 19085 | 12 | 0 |
49188 | 49188 | 2020-04-11 | Harrison | Iowa | 19085 | 12 | 0 |
51852 | 51852 | 2020-04-12 | Harrison | Iowa | 19085 | 12 | 0 |
54534 | 54534 | 2020-04-13 | Harrison | Iowa | 19085 | 12 | 0 |
57227 | 57227 | 2020-04-14 | Harrison | Iowa | 19085 | 12 | 0 |
59935 | 59935 | 2020-04-15 | Harrison | Iowa | 19085 | 12 | 0 |
62656 | 62656 | 2020-04-16 | Harrison | Iowa | 19085 | 12 | 0 |
65390 | 65390 | 2020-04-17 | Harrison | Iowa | 19085 | 12 | 0 |
68139 | 68139 | 2020-04-18 | Harrison | Iowa | 19085 | 12 | 0 |
70901 | 70901 | 2020-04-19 | Harrison | Iowa | 19085 | 13 | 0 |
73672 | 73672 | 2020-04-20 | Harrison | Iowa | 19085 | 14 | 0 |
76450 | 76450 | 2020-04-21 | Harrison | Iowa | 19085 | 14 | 0 |
79234 | 79234 | 2020-04-22 | Harrison | Iowa | 19085 | 15 | 0 |
82027 | 82027 | 2020-04-23 | Harrison | Iowa | 19085 | 15 | 0 |
84827 | 84827 | 2020-04-24 | Harrison | Iowa | 19085 | 15 | 0 |
87637 | 87637 | 2020-04-25 | Harrison | Iowa | 19085 | 15 | 0 |
90453 | 90453 | 2020-04-26 | Harrison | Iowa | 19085 | 15 | 0 |
93272 | 93272 | 2020-04-27 | Harrison | Iowa | 19085 | 15 | 0 |
96104 | 96104 | 2020-04-28 | Harrison | Iowa | 19085 | 15 | 0 |
98949 | 98949 | 2020-04-29 | Harrison | Iowa | 19085 | 16 | 0 |
101800 | 101800 | 2020-04-30 | Harrison | Iowa | 19085 | 16 | 0 |
104658 | 104658 | 2020-05-01 | Harrison | Iowa | 19085 | 16 | 0 |
107523 | 107523 | 2020-05-02 | Harrison | Iowa | 19085 | 16 | 0 |
110393 | 110393 | 2020-05-03 | Harrison | Iowa | 19085 | 16 | 0 |
113268 | 113268 | 2020-05-04 | Harrison | Iowa | 19085 | 16 | 0 |
116151 | 116151 | 2020-05-05 | Harrison | Iowa | 19085 | 17 | 0 |
119111 | 119111 | 2020-05-06 | Harrison | Iowa | 19085 | 17 | 0 |
122081 | 122081 | 2020-05-07 | Harrison | Iowa | 19085 | 17 | 0 |
125062 | 125062 | 2020-05-08 | Harrison | Iowa | 19085 | 17 | 0 |
128049 | 128049 | 2020-05-09 | Harrison | Iowa | 19085 | 17 | 0 |
131040 | 131040 | 2020-05-10 | Harrison | Iowa | 19085 | 17 | 0 |
134030 | 134030 | 2020-05-11 | Harrison | Iowa | 19085 | 17 | 0 |
137019 | 137019 | 2020-05-12 | Harrison | Iowa | 19085 | 17 | 0 |
140012 | 140012 | 2020-05-13 | Harrison | Iowa | 19085 | 17 | 0 |
143008 | 143008 | 2020-05-14 | Harrison | Iowa | 19085 | 17 | 0 |
146008 | 146008 | 2020-05-15 | Harrison | Iowa | 19085 | 17 | 0 |
149012 | 149012 | 2020-05-16 | Harrison | Iowa | 19085 | 17 | 0 |
152022 | 152022 | 2020-05-17 | Harrison | Iowa | 19085 | 17 | 0 |
155034 | 155034 | 2020-05-18 | Harrison | Iowa | 19085 | 18 | 0 |
158050 | 158050 | 2020-05-19 | Harrison | Iowa | 19085 | 18 | 0 |
161076 | 161076 | 2020-05-20 | Harrison | Iowa | 19085 | 18 | 0 |
164104 | 164104 | 2020-05-21 | Harrison | Iowa | 19085 | 18 | 0 |
167137 | 167137 | 2020-05-22 | Harrison | Iowa | 19085 | 18 | 0 |
170174 | 170174 | 2020-05-23 | Harrison | Iowa | 19085 | 18 | 0 |
173215 | 173215 | 2020-05-24 | Harrison | Iowa | 19085 | 19 | 0 |
176259 | 176259 | 2020-05-25 | Harrison | Iowa | 19085 | 19 | 0 |
179303 | 179303 | 2020-05-26 | Harrison | Iowa | 19085 | 19 | 0 |
182348 | 182348 | 2020-05-27 | Harrison | Iowa | 19085 | 19 | 0 |
185402 | 185402 | 2020-05-28 | Harrison | Iowa | 19085 | 21 | 0 |
188460 | 188460 | 2020-05-29 | Harrison | Iowa | 19085 | 21 | 0 |
191525 | 191525 | 2020-05-30 | Harrison | Iowa | 19085 | 23 | 0 |
194592 | 194592 | 2020-05-31 | Harrison | Iowa | 19085 | 23 | 0 |
197662 | 197662 | 2020-06-01 | Harrison | Iowa | 19085 | 24 | 0 |
200735 | 200735 | 2020-06-02 | Harrison | Iowa | 19085 | 25 | 0 |
203811 | 203811 | 2020-06-03 | Harrison | Iowa | 19085 | 26 | 0 |
206891 | 206891 | 2020-06-04 | Harrison | Iowa | 19085 | 26 | 0 |
209972 | 209972 | 2020-06-05 | Harrison | Iowa | 19085 | 26 | 0 |
213057 | 213057 | 2020-06-06 | Harrison | Iowa | 19085 | 26 | 0 |
216144 | 216144 | 2020-06-07 | Harrison | Iowa | 19085 | 26 | 0 |
219236 | 219236 | 2020-06-08 | Harrison | Iowa | 19085 | 27 | 0 |
222331 | 222331 | 2020-06-09 | Harrison | Iowa | 19085 | 27 | 0 |
225426 | 225426 | 2020-06-10 | Harrison | Iowa | 19085 | 30 | 0 |
228528 | 228528 | 2020-06-11 | Harrison | Iowa | 19085 | 32 | 0 |
231631 | 231631 | 2020-06-12 | Harrison | Iowa | 19085 | 33 | 0 |
234737 | 234737 | 2020-06-13 | Harrison | Iowa | 19085 | 39 | 0 |
237844 | 237844 | 2020-06-14 | Harrison | Iowa | 19085 | 39 | 0 |
244063 | 244063 | 2020-06-16 | Harrison | Iowa | 19085 | 40 | 0 |
240952 | 240952 | 2020-06-15 | Harrison | Iowa | 19085 | 41 | 0 |
247176 | 247176 | 2020-06-17 | Harrison | Iowa | 19085 | 41 | 0 |
250288 | 250288 | 2020-06-18 | Harrison | Iowa | 19085 | 41 | 0 |
253403 | 253403 | 2020-06-19 | Harrison | Iowa | 19085 | 41 | 0 |
256523 | 256523 | 2020-06-20 | Harrison | Iowa | 19085 | 41 | 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);