ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Henry" and state = "Iowa" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6402 | 6402 | 2020-03-21 | Henry | Iowa | 19087 | 1 | 0 |
7463 | 7463 | 2020-03-22 | Henry | Iowa | 19087 | 1 | 0 |
8622 | 8622 | 2020-03-23 | Henry | Iowa | 19087 | 1 | 0 |
9900 | 9900 | 2020-03-24 | Henry | Iowa | 19087 | 1 | 0 |
11297 | 11297 | 2020-03-25 | Henry | Iowa | 19087 | 1 | 0 |
12861 | 12861 | 2020-03-26 | Henry | Iowa | 19087 | 1 | 0 |
14552 | 14552 | 2020-03-27 | Henry | Iowa | 19087 | 2 | 0 |
16356 | 16356 | 2020-03-28 | Henry | Iowa | 19087 | 2 | 0 |
18261 | 18261 | 2020-03-29 | Henry | Iowa | 19087 | 3 | 0 |
20270 | 20270 | 2020-03-30 | Henry | Iowa | 19087 | 3 | 0 |
22366 | 22366 | 2020-03-31 | Henry | Iowa | 19087 | 3 | 0 |
24538 | 24538 | 2020-04-01 | Henry | Iowa | 19087 | 5 | 0 |
26779 | 26779 | 2020-04-02 | Henry | Iowa | 19087 | 5 | 0 |
29090 | 29090 | 2020-04-03 | Henry | Iowa | 19087 | 6 | 0 |
31459 | 31459 | 2020-04-04 | Henry | Iowa | 19087 | 6 | 0 |
33872 | 33872 | 2020-04-05 | Henry | Iowa | 19087 | 8 | 1 |
36327 | 36327 | 2020-04-06 | Henry | Iowa | 19087 | 9 | 1 |
38828 | 38828 | 2020-04-07 | Henry | Iowa | 19087 | 13 | 1 |
41374 | 41374 | 2020-04-08 | Henry | Iowa | 19087 | 15 | 1 |
43950 | 43950 | 2020-04-09 | Henry | Iowa | 19087 | 15 | 1 |
46555 | 46555 | 2020-04-10 | Henry | Iowa | 19087 | 17 | 1 |
49189 | 49189 | 2020-04-11 | Henry | Iowa | 19087 | 19 | 1 |
51853 | 51853 | 2020-04-12 | Henry | Iowa | 19087 | 19 | 1 |
54535 | 54535 | 2020-04-13 | Henry | Iowa | 19087 | 20 | 1 |
57228 | 57228 | 2020-04-14 | Henry | Iowa | 19087 | 22 | 1 |
59936 | 59936 | 2020-04-15 | Henry | Iowa | 19087 | 22 | 1 |
62657 | 62657 | 2020-04-16 | Henry | Iowa | 19087 | 22 | 1 |
65391 | 65391 | 2020-04-17 | Henry | Iowa | 19087 | 26 | 1 |
68140 | 68140 | 2020-04-18 | Henry | Iowa | 19087 | 27 | 1 |
70902 | 70902 | 2020-04-19 | Henry | Iowa | 19087 | 28 | 1 |
73673 | 73673 | 2020-04-20 | Henry | Iowa | 19087 | 28 | 1 |
76451 | 76451 | 2020-04-21 | Henry | Iowa | 19087 | 30 | 1 |
79235 | 79235 | 2020-04-22 | Henry | Iowa | 19087 | 31 | 1 |
82028 | 82028 | 2020-04-23 | Henry | Iowa | 19087 | 31 | 1 |
84828 | 84828 | 2020-04-24 | Henry | Iowa | 19087 | 32 | 1 |
87638 | 87638 | 2020-04-25 | Henry | Iowa | 19087 | 32 | 1 |
90454 | 90454 | 2020-04-26 | Henry | Iowa | 19087 | 32 | 1 |
93273 | 93273 | 2020-04-27 | Henry | Iowa | 19087 | 32 | 1 |
96105 | 96105 | 2020-04-28 | Henry | Iowa | 19087 | 32 | 1 |
98950 | 98950 | 2020-04-29 | Henry | Iowa | 19087 | 32 | 1 |
101801 | 101801 | 2020-04-30 | Henry | Iowa | 19087 | 32 | 1 |
104659 | 104659 | 2020-05-01 | Henry | Iowa | 19087 | 32 | 1 |
107524 | 107524 | 2020-05-02 | Henry | Iowa | 19087 | 32 | 1 |
110394 | 110394 | 2020-05-03 | Henry | Iowa | 19087 | 33 | 1 |
113269 | 113269 | 2020-05-04 | Henry | Iowa | 19087 | 34 | 1 |
116152 | 116152 | 2020-05-05 | Henry | Iowa | 19087 | 37 | 1 |
119112 | 119112 | 2020-05-06 | Henry | Iowa | 19087 | 40 | 1 |
122082 | 122082 | 2020-05-07 | Henry | Iowa | 19087 | 42 | 1 |
125063 | 125063 | 2020-05-08 | Henry | Iowa | 19087 | 42 | 1 |
128050 | 128050 | 2020-05-09 | Henry | Iowa | 19087 | 43 | 1 |
131041 | 131041 | 2020-05-10 | Henry | Iowa | 19087 | 43 | 1 |
134031 | 134031 | 2020-05-11 | Henry | Iowa | 19087 | 43 | 1 |
137020 | 137020 | 2020-05-12 | Henry | Iowa | 19087 | 43 | 1 |
140013 | 140013 | 2020-05-13 | Henry | Iowa | 19087 | 43 | 1 |
143009 | 143009 | 2020-05-14 | Henry | Iowa | 19087 | 43 | 1 |
146009 | 146009 | 2020-05-15 | Henry | Iowa | 19087 | 44 | 1 |
149013 | 149013 | 2020-05-16 | Henry | Iowa | 19087 | 44 | 1 |
152023 | 152023 | 2020-05-17 | Henry | Iowa | 19087 | 47 | 1 |
155035 | 155035 | 2020-05-18 | Henry | Iowa | 19087 | 46 | 1 |
158051 | 158051 | 2020-05-19 | Henry | Iowa | 19087 | 47 | 1 |
161077 | 161077 | 2020-05-20 | Henry | Iowa | 19087 | 49 | 1 |
164105 | 164105 | 2020-05-21 | Henry | Iowa | 19087 | 50 | 1 |
167138 | 167138 | 2020-05-22 | Henry | Iowa | 19087 | 56 | 1 |
170175 | 170175 | 2020-05-23 | Henry | Iowa | 19087 | 56 | 1 |
173216 | 173216 | 2020-05-24 | Henry | Iowa | 19087 | 61 | 1 |
176260 | 176260 | 2020-05-25 | Henry | Iowa | 19087 | 63 | 1 |
179304 | 179304 | 2020-05-26 | Henry | Iowa | 19087 | 67 | 1 |
182349 | 182349 | 2020-05-27 | Henry | Iowa | 19087 | 67 | 1 |
185403 | 185403 | 2020-05-28 | Henry | Iowa | 19087 | 67 | 1 |
188461 | 188461 | 2020-05-29 | Henry | Iowa | 19087 | 71 | 1 |
191526 | 191526 | 2020-05-30 | Henry | Iowa | 19087 | 71 | 1 |
194593 | 194593 | 2020-05-31 | Henry | Iowa | 19087 | 71 | 1 |
197663 | 197663 | 2020-06-01 | Henry | Iowa | 19087 | 72 | 1 |
200736 | 200736 | 2020-06-02 | Henry | Iowa | 19087 | 72 | 2 |
203812 | 203812 | 2020-06-03 | Henry | Iowa | 19087 | 72 | 2 |
206892 | 206892 | 2020-06-04 | Henry | Iowa | 19087 | 73 | 2 |
209973 | 209973 | 2020-06-05 | Henry | Iowa | 19087 | 74 | 2 |
213058 | 213058 | 2020-06-06 | Henry | Iowa | 19087 | 74 | 2 |
216145 | 216145 | 2020-06-07 | Henry | Iowa | 19087 | 74 | 2 |
219237 | 219237 | 2020-06-08 | Henry | Iowa | 19087 | 73 | 2 |
222332 | 222332 | 2020-06-09 | Henry | Iowa | 19087 | 73 | 2 |
225427 | 225427 | 2020-06-10 | Henry | Iowa | 19087 | 73 | 2 |
228529 | 228529 | 2020-06-11 | Henry | Iowa | 19087 | 73 | 2 |
231632 | 231632 | 2020-06-12 | Henry | Iowa | 19087 | 73 | 2 |
234738 | 234738 | 2020-06-13 | Henry | Iowa | 19087 | 73 | 2 |
237845 | 237845 | 2020-06-14 | Henry | Iowa | 19087 | 73 | 2 |
240953 | 240953 | 2020-06-15 | Henry | Iowa | 19087 | 74 | 2 |
244064 | 244064 | 2020-06-16 | Henry | Iowa | 19087 | 74 | 2 |
247177 | 247177 | 2020-06-17 | Henry | Iowa | 19087 | 75 | 3 |
250289 | 250289 | 2020-06-18 | Henry | Iowa | 19087 | 75 | 3 |
253404 | 253404 | 2020-06-19 | Henry | Iowa | 19087 | 75 | 3 |
256524 | 256524 | 2020-06-20 | Henry | Iowa | 19087 | 76 | 3 |
259650 | 259650 | 2020-06-21 | Henry | Iowa | 19087 | 78 | 3 |
262777 | 262777 | 2020-06-22 | Henry | Iowa | 19087 | 78 | 3 |
265905 | 265905 | 2020-06-23 | Henry | Iowa | 19087 | 79 | 3 |
269035 | 269035 | 2020-06-24 | Henry | Iowa | 19087 | 80 | 3 |
272172 | 272172 | 2020-06-25 | Henry | Iowa | 19087 | 79 | 3 |
275314 | 275314 | 2020-06-26 | Henry | Iowa | 19087 | 80 | 3 |
278462 | 278462 | 2020-06-27 | Henry | Iowa | 19087 | 80 | 3 |
281610 | 281610 | 2020-06-28 | Henry | Iowa | 19087 | 81 | 3 |
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);