ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Lee" and fips = 19111 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
31469 | 31469 | 2020-04-04 | Lee | Iowa | 19111 | 1 | 0 |
33882 | 33882 | 2020-04-05 | Lee | Iowa | 19111 | 1 | 0 |
36337 | 36337 | 2020-04-06 | Lee | Iowa | 19111 | 1 | 0 |
38838 | 38838 | 2020-04-07 | Lee | Iowa | 19111 | 1 | 0 |
41384 | 41384 | 2020-04-08 | Lee | Iowa | 19111 | 1 | 0 |
43960 | 43960 | 2020-04-09 | Lee | Iowa | 19111 | 1 | 0 |
46565 | 46565 | 2020-04-10 | Lee | Iowa | 19111 | 1 | 0 |
49199 | 49199 | 2020-04-11 | Lee | Iowa | 19111 | 1 | 0 |
51863 | 51863 | 2020-04-12 | Lee | Iowa | 19111 | 1 | 0 |
54545 | 54545 | 2020-04-13 | Lee | Iowa | 19111 | 2 | 0 |
57238 | 57238 | 2020-04-14 | Lee | Iowa | 19111 | 2 | 0 |
59946 | 59946 | 2020-04-15 | Lee | Iowa | 19111 | 2 | 0 |
62667 | 62667 | 2020-04-16 | Lee | Iowa | 19111 | 3 | 0 |
65401 | 65401 | 2020-04-17 | Lee | Iowa | 19111 | 3 | 0 |
68150 | 68150 | 2020-04-18 | Lee | Iowa | 19111 | 3 | 0 |
70912 | 70912 | 2020-04-19 | Lee | Iowa | 19111 | 3 | 0 |
73683 | 73683 | 2020-04-20 | Lee | Iowa | 19111 | 3 | 0 |
76462 | 76462 | 2020-04-21 | Lee | Iowa | 19111 | 3 | 0 |
79246 | 79246 | 2020-04-22 | Lee | Iowa | 19111 | 3 | 0 |
82039 | 82039 | 2020-04-23 | Lee | Iowa | 19111 | 3 | 0 |
84839 | 84839 | 2020-04-24 | Lee | Iowa | 19111 | 4 | 0 |
87649 | 87649 | 2020-04-25 | Lee | Iowa | 19111 | 4 | 0 |
90465 | 90465 | 2020-04-26 | Lee | Iowa | 19111 | 5 | 0 |
93284 | 93284 | 2020-04-27 | Lee | Iowa | 19111 | 5 | 0 |
96116 | 96116 | 2020-04-28 | Lee | Iowa | 19111 | 7 | 0 |
98961 | 98961 | 2020-04-29 | Lee | Iowa | 19111 | 8 | 0 |
101812 | 101812 | 2020-04-30 | Lee | Iowa | 19111 | 8 | 0 |
104670 | 104670 | 2020-05-01 | Lee | Iowa | 19111 | 9 | 0 |
107535 | 107535 | 2020-05-02 | Lee | Iowa | 19111 | 12 | 0 |
110405 | 110405 | 2020-05-03 | Lee | Iowa | 19111 | 13 | 0 |
113280 | 113280 | 2020-05-04 | Lee | Iowa | 19111 | 14 | 0 |
116163 | 116163 | 2020-05-05 | Lee | Iowa | 19111 | 16 | 0 |
119123 | 119123 | 2020-05-06 | Lee | Iowa | 19111 | 16 | 0 |
122093 | 122093 | 2020-05-07 | Lee | Iowa | 19111 | 17 | 0 |
125074 | 125074 | 2020-05-08 | Lee | Iowa | 19111 | 18 | 0 |
128061 | 128061 | 2020-05-09 | Lee | Iowa | 19111 | 18 | 0 |
131052 | 131052 | 2020-05-10 | Lee | Iowa | 19111 | 18 | 0 |
134042 | 134042 | 2020-05-11 | Lee | Iowa | 19111 | 18 | 0 |
137032 | 137032 | 2020-05-12 | Lee | Iowa | 19111 | 18 | 0 |
140025 | 140025 | 2020-05-13 | Lee | Iowa | 19111 | 18 | 0 |
143021 | 143021 | 2020-05-14 | Lee | Iowa | 19111 | 18 | 0 |
146021 | 146021 | 2020-05-15 | Lee | Iowa | 19111 | 18 | 0 |
149025 | 149025 | 2020-05-16 | Lee | Iowa | 19111 | 18 | 0 |
152035 | 152035 | 2020-05-17 | Lee | Iowa | 19111 | 18 | 0 |
155047 | 155047 | 2020-05-18 | Lee | Iowa | 19111 | 19 | 0 |
158063 | 158063 | 2020-05-19 | Lee | Iowa | 19111 | 20 | 0 |
161089 | 161089 | 2020-05-20 | Lee | Iowa | 19111 | 20 | 0 |
164117 | 164117 | 2020-05-21 | Lee | Iowa | 19111 | 20 | 0 |
167150 | 167150 | 2020-05-22 | Lee | Iowa | 19111 | 20 | 0 |
170187 | 170187 | 2020-05-23 | Lee | Iowa | 19111 | 20 | 0 |
173228 | 173228 | 2020-05-24 | Lee | Iowa | 19111 | 22 | 0 |
179316 | 179316 | 2020-05-26 | Lee | Iowa | 19111 | 22 | 0 |
176272 | 176272 | 2020-05-25 | Lee | Iowa | 19111 | 23 | 0 |
182361 | 182361 | 2020-05-27 | Lee | Iowa | 19111 | 23 | 0 |
185415 | 185415 | 2020-05-28 | Lee | Iowa | 19111 | 24 | 0 |
188473 | 188473 | 2020-05-29 | Lee | Iowa | 19111 | 25 | 0 |
191538 | 191538 | 2020-05-30 | Lee | Iowa | 19111 | 25 | 0 |
194605 | 194605 | 2020-05-31 | Lee | Iowa | 19111 | 27 | 0 |
197675 | 197675 | 2020-06-01 | Lee | Iowa | 19111 | 27 | 0 |
200748 | 200748 | 2020-06-02 | Lee | Iowa | 19111 | 27 | 0 |
203824 | 203824 | 2020-06-03 | Lee | Iowa | 19111 | 28 | 0 |
206904 | 206904 | 2020-06-04 | Lee | Iowa | 19111 | 29 | 0 |
209985 | 209985 | 2020-06-05 | Lee | Iowa | 19111 | 30 | 0 |
213070 | 213070 | 2020-06-06 | Lee | Iowa | 19111 | 30 | 0 |
216157 | 216157 | 2020-06-07 | Lee | Iowa | 19111 | 31 | 0 |
219249 | 219249 | 2020-06-08 | Lee | Iowa | 19111 | 32 | 0 |
222344 | 222344 | 2020-06-09 | Lee | Iowa | 19111 | 34 | 0 |
225439 | 225439 | 2020-06-10 | Lee | Iowa | 19111 | 36 | 1 |
231644 | 231644 | 2020-06-12 | Lee | Iowa | 19111 | 37 | 1 |
228541 | 228541 | 2020-06-11 | Lee | Iowa | 19111 | 38 | 1 |
234750 | 234750 | 2020-06-13 | Lee | Iowa | 19111 | 38 | 1 |
237857 | 237857 | 2020-06-14 | Lee | Iowa | 19111 | 38 | 1 |
240965 | 240965 | 2020-06-15 | Lee | Iowa | 19111 | 40 | 1 |
244076 | 244076 | 2020-06-16 | Lee | Iowa | 19111 | 40 | 1 |
247189 | 247189 | 2020-06-17 | Lee | Iowa | 19111 | 40 | 1 |
250301 | 250301 | 2020-06-18 | Lee | Iowa | 19111 | 41 | 1 |
253416 | 253416 | 2020-06-19 | Lee | Iowa | 19111 | 42 | 1 |
256536 | 256536 | 2020-06-20 | Lee | Iowa | 19111 | 43 | 1 |
265917 | 265917 | 2020-06-23 | Lee | Iowa | 19111 | 43 | 1 |
262789 | 262789 | 2020-06-22 | Lee | Iowa | 19111 | 44 | 1 |
269047 | 269047 | 2020-06-24 | Lee | Iowa | 19111 | 44 | 1 |
272184 | 272184 | 2020-06-25 | Lee | Iowa | 19111 | 44 | 1 |
275326 | 275326 | 2020-06-26 | Lee | Iowa | 19111 | 44 | 1 |
259662 | 259662 | 2020-06-21 | Lee | Iowa | 19111 | 45 | 1 |
278474 | 278474 | 2020-06-27 | Lee | Iowa | 19111 | 45 | 1 |
281622 | 281622 | 2020-06-28 | Lee | Iowa | 19111 | 47 | 1 |
284767 | 284767 | 2020-06-29 | Lee | Iowa | 19111 | 47 | 1 |
287916 | 287916 | 2020-06-30 | Lee | Iowa | 19111 | 48 | 2 |
291066 | 291066 | 2020-07-01 | Lee | Iowa | 19111 | 49 | 2 |
294220 | 294220 | 2020-07-02 | Lee | Iowa | 19111 | 50 | 2 |
297378 | 297378 | 2020-07-03 | Lee | Iowa | 19111 | 53 | 2 |
300540 | 300540 | 2020-07-04 | Lee | Iowa | 19111 | 54 | 2 |
303704 | 303704 | 2020-07-05 | Lee | Iowa | 19111 | 54 | 2 |
306869 | 306869 | 2020-07-06 | Lee | Iowa | 19111 | 54 | 2 |
310037 | 310037 | 2020-07-07 | Lee | Iowa | 19111 | 54 | 2 |
313207 | 313207 | 2020-07-08 | Lee | Iowa | 19111 | 54 | 2 |
316381 | 316381 | 2020-07-09 | Lee | Iowa | 19111 | 54 | 2 |
319554 | 319554 | 2020-07-10 | Lee | Iowa | 19111 | 54 | 2 |
322733 | 322733 | 2020-07-11 | Lee | Iowa | 19111 | 54 | 2 |
325914 | 325914 | 2020-07-12 | Lee | Iowa | 19111 | 54 | 2 |
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);