ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19193 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281664 | 281664 | 2020-06-28 | Woodbury | Iowa | 19193 | 3140 | 44 |
278516 | 278516 | 2020-06-27 | Woodbury | Iowa | 19193 | 3133 | 44 |
275368 | 275368 | 2020-06-26 | Woodbury | Iowa | 19193 | 3122 | 44 |
272226 | 272226 | 2020-06-25 | Woodbury | Iowa | 19193 | 3106 | 43 |
269089 | 269089 | 2020-06-24 | Woodbury | Iowa | 19193 | 3090 | 43 |
265959 | 265959 | 2020-06-23 | Woodbury | Iowa | 19193 | 3083 | 43 |
262831 | 262831 | 2020-06-22 | Woodbury | Iowa | 19193 | 3073 | 42 |
259704 | 259704 | 2020-06-21 | Woodbury | Iowa | 19193 | 3068 | 42 |
256578 | 256578 | 2020-06-20 | Woodbury | Iowa | 19193 | 3055 | 42 |
253458 | 253458 | 2020-06-19 | Woodbury | Iowa | 19193 | 3054 | 42 |
250343 | 250343 | 2020-06-18 | Woodbury | Iowa | 19193 | 3041 | 42 |
247231 | 247231 | 2020-06-17 | Woodbury | Iowa | 19193 | 3029 | 42 |
244118 | 244118 | 2020-06-16 | Woodbury | Iowa | 19193 | 3015 | 40 |
241007 | 241007 | 2020-06-15 | Woodbury | Iowa | 19193 | 3011 | 40 |
237899 | 237899 | 2020-06-14 | Woodbury | Iowa | 19193 | 3004 | 39 |
234792 | 234792 | 2020-06-13 | Woodbury | Iowa | 19193 | 2999 | 40 |
231686 | 231686 | 2020-06-12 | Woodbury | Iowa | 19193 | 2994 | 40 |
228583 | 228583 | 2020-06-11 | Woodbury | Iowa | 19193 | 2973 | 39 |
225481 | 225481 | 2020-06-10 | Woodbury | Iowa | 19193 | 2960 | 38 |
222386 | 222386 | 2020-06-09 | Woodbury | Iowa | 19193 | 2947 | 38 |
219291 | 219291 | 2020-06-08 | Woodbury | Iowa | 19193 | 2939 | 37 |
216199 | 216199 | 2020-06-07 | Woodbury | Iowa | 19193 | 2927 | 37 |
213112 | 213112 | 2020-06-06 | Woodbury | Iowa | 19193 | 2909 | 37 |
210027 | 210027 | 2020-06-05 | Woodbury | Iowa | 19193 | 2887 | 37 |
206946 | 206946 | 2020-06-04 | Woodbury | Iowa | 19193 | 2854 | 37 |
203865 | 203865 | 2020-06-03 | Woodbury | Iowa | 19193 | 2819 | 37 |
200789 | 200789 | 2020-06-02 | Woodbury | Iowa | 19193 | 2786 | 37 |
197717 | 197717 | 2020-06-01 | Woodbury | Iowa | 19193 | 2768 | 36 |
194647 | 194647 | 2020-05-31 | Woodbury | Iowa | 19193 | 2754 | 34 |
191579 | 191579 | 2020-05-30 | Woodbury | Iowa | 19193 | 2745 | 34 |
188515 | 188515 | 2020-05-29 | Woodbury | Iowa | 19193 | 2726 | 34 |
185457 | 185457 | 2020-05-28 | Woodbury | Iowa | 19193 | 2678 | 33 |
182403 | 182403 | 2020-05-27 | Woodbury | Iowa | 19193 | 2668 | 31 |
179358 | 179358 | 2020-05-26 | Woodbury | Iowa | 19193 | 2644 | 28 |
176314 | 176314 | 2020-05-25 | Woodbury | Iowa | 19193 | 2635 | 24 |
173270 | 173270 | 2020-05-24 | Woodbury | Iowa | 19193 | 2594 | 24 |
170229 | 170229 | 2020-05-23 | Woodbury | Iowa | 19193 | 2468 | 23 |
167191 | 167191 | 2020-05-22 | Woodbury | Iowa | 19193 | 2468 | 23 |
164159 | 164159 | 2020-05-21 | Woodbury | Iowa | 19193 | 2448 | 23 |
161130 | 161130 | 2020-05-20 | Woodbury | Iowa | 19193 | 2406 | 22 |
158105 | 158105 | 2020-05-19 | Woodbury | Iowa | 19193 | 2342 | 17 |
155088 | 155088 | 2020-05-18 | Woodbury | Iowa | 19193 | 2278 | 17 |
152076 | 152076 | 2020-05-17 | Woodbury | Iowa | 19193 | 2215 | 16 |
149065 | 149065 | 2020-05-16 | Woodbury | Iowa | 19193 | 2157 | 16 |
146061 | 146061 | 2020-05-15 | Woodbury | Iowa | 19193 | 2111 | 14 |
143061 | 143061 | 2020-05-14 | Woodbury | Iowa | 19193 | 2078 | 14 |
140065 | 140065 | 2020-05-13 | Woodbury | Iowa | 19193 | 2054 | 14 |
137072 | 137072 | 2020-05-12 | Woodbury | Iowa | 19193 | 1988 | 11 |
134082 | 134082 | 2020-05-11 | Woodbury | Iowa | 19193 | 1676 | 9 |
131091 | 131091 | 2020-05-10 | Woodbury | Iowa | 19193 | 1627 | 8 |
128101 | 128101 | 2020-05-09 | Woodbury | Iowa | 19193 | 1554 | 7 |
125114 | 125114 | 2020-05-08 | Woodbury | Iowa | 19193 | 1532 | 7 |
122132 | 122132 | 2020-05-07 | Woodbury | Iowa | 19193 | 1429 | 4 |
119162 | 119162 | 2020-05-06 | Woodbury | Iowa | 19193 | 1323 | 4 |
116201 | 116201 | 2020-05-05 | Woodbury | Iowa | 19193 | 1296 | 3 |
113319 | 113319 | 2020-05-04 | Woodbury | Iowa | 19193 | 1152 | 2 |
110444 | 110444 | 2020-05-03 | Woodbury | Iowa | 19193 | 1112 | 2 |
107573 | 107573 | 2020-05-02 | Woodbury | Iowa | 19193 | 1074 | 2 |
104708 | 104708 | 2020-05-01 | Woodbury | Iowa | 19193 | 922 | 1 |
101848 | 101848 | 2020-04-30 | Woodbury | Iowa | 19193 | 742 | 1 |
98997 | 98997 | 2020-04-29 | Woodbury | Iowa | 19193 | 728 | 1 |
96152 | 96152 | 2020-04-28 | Woodbury | Iowa | 19193 | 695 | 1 |
93320 | 93320 | 2020-04-27 | Woodbury | Iowa | 19193 | 495 | 1 |
90499 | 90499 | 2020-04-26 | Woodbury | Iowa | 19193 | 409 | 1 |
87683 | 87683 | 2020-04-25 | Woodbury | Iowa | 19193 | 316 | 1 |
84874 | 84874 | 2020-04-24 | Woodbury | Iowa | 19193 | 189 | 1 |
82073 | 82073 | 2020-04-23 | Woodbury | Iowa | 19193 | 120 | 1 |
79281 | 79281 | 2020-04-22 | Woodbury | Iowa | 19193 | 100 | 1 |
76497 | 76497 | 2020-04-21 | Woodbury | Iowa | 19193 | 81 | 0 |
73717 | 73717 | 2020-04-20 | Woodbury | Iowa | 19193 | 44 | 0 |
70946 | 70946 | 2020-04-19 | Woodbury | Iowa | 19193 | 37 | 0 |
68185 | 68185 | 2020-04-18 | Woodbury | Iowa | 19193 | 35 | 0 |
65436 | 65436 | 2020-04-17 | Woodbury | Iowa | 19193 | 25 | 0 |
62701 | 62701 | 2020-04-16 | Woodbury | Iowa | 19193 | 22 | 0 |
59980 | 59980 | 2020-04-15 | Woodbury | Iowa | 19193 | 21 | 0 |
57272 | 57272 | 2020-04-14 | Woodbury | Iowa | 19193 | 20 | 0 |
54579 | 54579 | 2020-04-13 | Woodbury | Iowa | 19193 | 19 | 0 |
51897 | 51897 | 2020-04-12 | Woodbury | Iowa | 19193 | 18 | 0 |
49233 | 49233 | 2020-04-11 | Woodbury | Iowa | 19193 | 18 | 0 |
46599 | 46599 | 2020-04-10 | Woodbury | Iowa | 19193 | 15 | 0 |
43992 | 43992 | 2020-04-09 | Woodbury | Iowa | 19193 | 12 | 0 |
41416 | 41416 | 2020-04-08 | Woodbury | Iowa | 19193 | 11 | 0 |
38870 | 38870 | 2020-04-07 | Woodbury | Iowa | 19193 | 9 | 0 |
36369 | 36369 | 2020-04-06 | Woodbury | Iowa | 19193 | 8 | 0 |
33912 | 33912 | 2020-04-05 | Woodbury | Iowa | 19193 | 8 | 0 |
31499 | 31499 | 2020-04-04 | Woodbury | Iowa | 19193 | 8 | 0 |
29127 | 29127 | 2020-04-03 | Woodbury | Iowa | 19193 | 8 | 0 |
26813 | 26813 | 2020-04-02 | Woodbury | Iowa | 19193 | 7 | 0 |
24571 | 24571 | 2020-04-01 | Woodbury | Iowa | 19193 | 4 | 0 |
22396 | 22396 | 2020-03-31 | Woodbury | Iowa | 19193 | 4 | 0 |
20300 | 20300 | 2020-03-30 | Woodbury | Iowa | 19193 | 4 | 0 |
18288 | 18288 | 2020-03-29 | Woodbury | Iowa | 19193 | 4 | 0 |
16383 | 16383 | 2020-03-28 | Woodbury | Iowa | 19193 | 3 | 0 |
14576 | 14576 | 2020-03-27 | Woodbury | Iowa | 19193 | 3 | 0 |
12881 | 12881 | 2020-03-26 | Woodbury | Iowa | 19193 | 2 | 0 |
11314 | 11314 | 2020-03-25 | Woodbury | Iowa | 19193 | 2 | 0 |
9917 | 9917 | 2020-03-24 | Woodbury | Iowa | 19193 | 2 | 0 |
8637 | 8637 | 2020-03-23 | Woodbury | Iowa | 19193 | 2 | 0 |
7477 | 7477 | 2020-03-22 | Woodbury | Iowa | 19193 | 1 | 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);