ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Linn" and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29613 | 29613 | 2020-04-03 | Linn | Missouri | 29115 | 1 | 0 |
31993 | 31993 | 2020-04-04 | Linn | Missouri | 29115 | 1 | 0 |
34421 | 34421 | 2020-04-05 | Linn | Missouri | 29115 | 1 | 0 |
36885 | 36885 | 2020-04-06 | Linn | Missouri | 29115 | 2 | 0 |
39398 | 39398 | 2020-04-07 | Linn | Missouri | 29115 | 3 | 0 |
41952 | 41952 | 2020-04-08 | Linn | Missouri | 29115 | 3 | 0 |
44529 | 44529 | 2020-04-09 | Linn | Missouri | 29115 | 3 | 0 |
47138 | 47138 | 2020-04-10 | Linn | Missouri | 29115 | 3 | 0 |
49786 | 49786 | 2020-04-11 | Linn | Missouri | 29115 | 3 | 0 |
52459 | 52459 | 2020-04-12 | Linn | Missouri | 29115 | 3 | 0 |
55141 | 55141 | 2020-04-13 | Linn | Missouri | 29115 | 4 | 1 |
57839 | 57839 | 2020-04-14 | Linn | Missouri | 29115 | 5 | 1 |
60552 | 60552 | 2020-04-15 | Linn | Missouri | 29115 | 5 | 1 |
63274 | 63274 | 2020-04-16 | Linn | Missouri | 29115 | 5 | 1 |
66014 | 66014 | 2020-04-17 | Linn | Missouri | 29115 | 5 | 1 |
68767 | 68767 | 2020-04-18 | Linn | Missouri | 29115 | 5 | 1 |
71534 | 71534 | 2020-04-19 | Linn | Missouri | 29115 | 5 | 1 |
74307 | 74307 | 2020-04-20 | Linn | Missouri | 29115 | 5 | 1 |
77088 | 77088 | 2020-04-21 | Linn | Missouri | 29115 | 5 | 1 |
79874 | 79874 | 2020-04-22 | Linn | Missouri | 29115 | 5 | 1 |
82670 | 82670 | 2020-04-23 | Linn | Missouri | 29115 | 5 | 1 |
85474 | 85474 | 2020-04-24 | Linn | Missouri | 29115 | 5 | 1 |
88284 | 88284 | 2020-04-25 | Linn | Missouri | 29115 | 5 | 1 |
91100 | 91100 | 2020-04-26 | Linn | Missouri | 29115 | 5 | 1 |
93921 | 93921 | 2020-04-27 | Linn | Missouri | 29115 | 5 | 1 |
96757 | 96757 | 2020-04-28 | Linn | Missouri | 29115 | 5 | 1 |
99603 | 99603 | 2020-04-29 | Linn | Missouri | 29115 | 5 | 1 |
102455 | 102455 | 2020-04-30 | Linn | Missouri | 29115 | 5 | 1 |
105316 | 105316 | 2020-05-01 | Linn | Missouri | 29115 | 5 | 1 |
108181 | 108181 | 2020-05-02 | Linn | Missouri | 29115 | 5 | 1 |
111053 | 111053 | 2020-05-03 | Linn | Missouri | 29115 | 5 | 1 |
113932 | 113932 | 2020-05-04 | Linn | Missouri | 29115 | 5 | 1 |
116814 | 116814 | 2020-05-05 | Linn | Missouri | 29115 | 5 | 1 |
119774 | 119774 | 2020-05-06 | Linn | Missouri | 29115 | 5 | 1 |
122748 | 122748 | 2020-05-07 | Linn | Missouri | 29115 | 5 | 1 |
125730 | 125730 | 2020-05-08 | Linn | Missouri | 29115 | 5 | 1 |
128718 | 128718 | 2020-05-09 | Linn | Missouri | 29115 | 5 | 1 |
131708 | 131708 | 2020-05-10 | Linn | Missouri | 29115 | 5 | 1 |
134699 | 134699 | 2020-05-11 | Linn | Missouri | 29115 | 5 | 1 |
137689 | 137689 | 2020-05-12 | Linn | Missouri | 29115 | 5 | 1 |
140683 | 140683 | 2020-05-13 | Linn | Missouri | 29115 | 5 | 1 |
143678 | 143678 | 2020-05-14 | Linn | Missouri | 29115 | 5 | 1 |
146679 | 146679 | 2020-05-15 | Linn | Missouri | 29115 | 5 | 1 |
149684 | 149684 | 2020-05-16 | Linn | Missouri | 29115 | 5 | 1 |
152695 | 152695 | 2020-05-17 | Linn | Missouri | 29115 | 5 | 1 |
155709 | 155709 | 2020-05-18 | Linn | Missouri | 29115 | 5 | 1 |
158727 | 158727 | 2020-05-19 | Linn | Missouri | 29115 | 5 | 1 |
161753 | 161753 | 2020-05-20 | Linn | Missouri | 29115 | 5 | 1 |
164782 | 164782 | 2020-05-21 | Linn | Missouri | 29115 | 5 | 1 |
167818 | 167818 | 2020-05-22 | Linn | Missouri | 29115 | 5 | 1 |
170857 | 170857 | 2020-05-23 | Linn | Missouri | 29115 | 5 | 1 |
173899 | 173899 | 2020-05-24 | Linn | Missouri | 29115 | 6 | 1 |
176942 | 176942 | 2020-05-25 | Linn | Missouri | 29115 | 6 | 1 |
179986 | 179986 | 2020-05-26 | Linn | Missouri | 29115 | 6 | 1 |
183032 | 183032 | 2020-05-27 | Linn | Missouri | 29115 | 6 | 1 |
186088 | 186088 | 2020-05-28 | Linn | Missouri | 29115 | 6 | 1 |
189146 | 189146 | 2020-05-29 | Linn | Missouri | 29115 | 6 | 1 |
192210 | 192210 | 2020-05-30 | Linn | Missouri | 29115 | 9 | 1 |
195279 | 195279 | 2020-05-31 | Linn | Missouri | 29115 | 9 | 1 |
198350 | 198350 | 2020-06-01 | Linn | Missouri | 29115 | 9 | 1 |
201423 | 201423 | 2020-06-02 | Linn | Missouri | 29115 | 9 | 1 |
204500 | 204500 | 2020-06-03 | Linn | Missouri | 29115 | 10 | 1 |
207581 | 207581 | 2020-06-04 | Linn | Missouri | 29115 | 10 | 1 |
210662 | 210662 | 2020-06-05 | Linn | Missouri | 29115 | 10 | 1 |
213746 | 213746 | 2020-06-06 | Linn | Missouri | 29115 | 10 | 1 |
216834 | 216834 | 2020-06-07 | Linn | Missouri | 29115 | 10 | 1 |
219926 | 219926 | 2020-06-08 | Linn | Missouri | 29115 | 10 | 1 |
223021 | 223021 | 2020-06-09 | Linn | Missouri | 29115 | 10 | 1 |
226120 | 226120 | 2020-06-10 | Linn | Missouri | 29115 | 11 | 1 |
229223 | 229223 | 2020-06-11 | Linn | Missouri | 29115 | 11 | 1 |
232327 | 232327 | 2020-06-12 | Linn | Missouri | 29115 | 11 | 1 |
235433 | 235433 | 2020-06-13 | Linn | Missouri | 29115 | 11 | 1 |
238540 | 238540 | 2020-06-14 | Linn | Missouri | 29115 | 11 | 1 |
241650 | 241650 | 2020-06-15 | Linn | Missouri | 29115 | 11 | 1 |
244761 | 244761 | 2020-06-16 | Linn | Missouri | 29115 | 11 | 1 |
247874 | 247874 | 2020-06-17 | Linn | Missouri | 29115 | 12 | 1 |
250987 | 250987 | 2020-06-18 | Linn | Missouri | 29115 | 13 | 1 |
254102 | 254102 | 2020-06-19 | Linn | Missouri | 29115 | 13 | 1 |
257222 | 257222 | 2020-06-20 | Linn | Missouri | 29115 | 13 | 1 |
260348 | 260348 | 2020-06-21 | Linn | Missouri | 29115 | 13 | 1 |
263476 | 263476 | 2020-06-22 | Linn | Missouri | 29115 | 13 | 1 |
266602 | 266602 | 2020-06-23 | Linn | Missouri | 29115 | 14 | 1 |
269735 | 269735 | 2020-06-24 | Linn | Missouri | 29115 | 14 | 1 |
272874 | 272874 | 2020-06-25 | Linn | Missouri | 29115 | 14 | 1 |
276017 | 276017 | 2020-06-26 | Linn | Missouri | 29115 | 14 | 1 |
279165 | 279165 | 2020-06-27 | Linn | Missouri | 29115 | 15 | 1 |
282313 | 282313 | 2020-06-28 | Linn | Missouri | 29115 | 16 | 1 |
285458 | 285458 | 2020-06-29 | Linn | Missouri | 29115 | 16 | 1 |
288608 | 288608 | 2020-06-30 | Linn | Missouri | 29115 | 16 | 1 |
291759 | 291759 | 2020-07-01 | Linn | Missouri | 29115 | 16 | 1 |
294913 | 294913 | 2020-07-02 | Linn | Missouri | 29115 | 16 | 1 |
298071 | 298071 | 2020-07-03 | Linn | Missouri | 29115 | 17 | 1 |
301234 | 301234 | 2020-07-04 | Linn | Missouri | 29115 | 18 | 1 |
304398 | 304398 | 2020-07-05 | Linn | Missouri | 29115 | 18 | 1 |
307565 | 307565 | 2020-07-06 | Linn | Missouri | 29115 | 18 | 1 |
310733 | 310733 | 2020-07-07 | Linn | Missouri | 29115 | 19 | 1 |
313904 | 313904 | 2020-07-08 | Linn | Missouri | 29115 | 19 | 1 |
317078 | 317078 | 2020-07-09 | Linn | Missouri | 29115 | 20 | 1 |
320253 | 320253 | 2020-07-10 | Linn | Missouri | 29115 | 20 | 1 |
323432 | 323432 | 2020-07-11 | Linn | Missouri | 29115 | 20 | 1 |
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);