ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Andrew" and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
49743 | 49743 | 2020-04-11 | Andrew | Missouri | 29003 | 1 | 0 |
52416 | 52416 | 2020-04-12 | Andrew | Missouri | 29003 | 1 | 0 |
55098 | 55098 | 2020-04-13 | Andrew | Missouri | 29003 | 1 | 0 |
57796 | 57796 | 2020-04-14 | Andrew | Missouri | 29003 | 1 | 0 |
60507 | 60507 | 2020-04-15 | Andrew | Missouri | 29003 | 1 | 0 |
63229 | 63229 | 2020-04-16 | Andrew | Missouri | 29003 | 1 | 0 |
65969 | 65969 | 2020-04-17 | Andrew | Missouri | 29003 | 1 | 0 |
68721 | 68721 | 2020-04-18 | Andrew | Missouri | 29003 | 1 | 0 |
71487 | 71487 | 2020-04-19 | Andrew | Missouri | 29003 | 1 | 0 |
74260 | 74260 | 2020-04-20 | Andrew | Missouri | 29003 | 1 | 0 |
77041 | 77041 | 2020-04-21 | Andrew | Missouri | 29003 | 1 | 0 |
79826 | 79826 | 2020-04-22 | Andrew | Missouri | 29003 | 1 | 0 |
82622 | 82622 | 2020-04-23 | Andrew | Missouri | 29003 | 1 | 0 |
85426 | 85426 | 2020-04-24 | Andrew | Missouri | 29003 | 1 | 0 |
88236 | 88236 | 2020-04-25 | Andrew | Missouri | 29003 | 1 | 0 |
91052 | 91052 | 2020-04-26 | Andrew | Missouri | 29003 | 1 | 0 |
93873 | 93873 | 2020-04-27 | Andrew | Missouri | 29003 | 2 | 0 |
96709 | 96709 | 2020-04-28 | Andrew | Missouri | 29003 | 2 | 0 |
99555 | 99555 | 2020-04-29 | Andrew | Missouri | 29003 | 2 | 0 |
102407 | 102407 | 2020-04-30 | Andrew | Missouri | 29003 | 2 | 0 |
105268 | 105268 | 2020-05-01 | Andrew | Missouri | 29003 | 3 | 0 |
108133 | 108133 | 2020-05-02 | Andrew | Missouri | 29003 | 3 | 0 |
111004 | 111004 | 2020-05-03 | Andrew | Missouri | 29003 | 5 | 0 |
113883 | 113883 | 2020-05-04 | Andrew | Missouri | 29003 | 6 | 0 |
116765 | 116765 | 2020-05-05 | Andrew | Missouri | 29003 | 6 | 0 |
119725 | 119725 | 2020-05-06 | Andrew | Missouri | 29003 | 6 | 0 |
122699 | 122699 | 2020-05-07 | Andrew | Missouri | 29003 | 5 | 0 |
125681 | 125681 | 2020-05-08 | Andrew | Missouri | 29003 | 6 | 0 |
128668 | 128668 | 2020-05-09 | Andrew | Missouri | 29003 | 7 | 0 |
131658 | 131658 | 2020-05-10 | Andrew | Missouri | 29003 | 8 | 0 |
134649 | 134649 | 2020-05-11 | Andrew | Missouri | 29003 | 8 | 0 |
137639 | 137639 | 2020-05-12 | Andrew | Missouri | 29003 | 8 | 0 |
140633 | 140633 | 2020-05-13 | Andrew | Missouri | 29003 | 11 | 0 |
143628 | 143628 | 2020-05-14 | Andrew | Missouri | 29003 | 11 | 0 |
146628 | 146628 | 2020-05-15 | Andrew | Missouri | 29003 | 14 | 0 |
149633 | 149633 | 2020-05-16 | Andrew | Missouri | 29003 | 14 | 0 |
152644 | 152644 | 2020-05-17 | Andrew | Missouri | 29003 | 15 | 0 |
155658 | 155658 | 2020-05-18 | Andrew | Missouri | 29003 | 17 | 0 |
158676 | 158676 | 2020-05-19 | Andrew | Missouri | 29003 | 19 | 0 |
161702 | 161702 | 2020-05-20 | Andrew | Missouri | 29003 | 20 | 0 |
164731 | 164731 | 2020-05-21 | Andrew | Missouri | 29003 | 20 | 0 |
167767 | 167767 | 2020-05-22 | Andrew | Missouri | 29003 | 20 | 0 |
170805 | 170805 | 2020-05-23 | Andrew | Missouri | 29003 | 20 | 0 |
173847 | 173847 | 2020-05-24 | Andrew | Missouri | 29003 | 23 | 0 |
176890 | 176890 | 2020-05-25 | Andrew | Missouri | 29003 | 24 | 0 |
179934 | 179934 | 2020-05-26 | Andrew | Missouri | 29003 | 24 | 0 |
182980 | 182980 | 2020-05-27 | Andrew | Missouri | 29003 | 30 | 0 |
186036 | 186036 | 2020-05-28 | Andrew | Missouri | 29003 | 30 | 0 |
189094 | 189094 | 2020-05-29 | Andrew | Missouri | 29003 | 30 | 0 |
192158 | 192158 | 2020-05-30 | Andrew | Missouri | 29003 | 30 | 0 |
195226 | 195226 | 2020-05-31 | Andrew | Missouri | 29003 | 30 | 0 |
198297 | 198297 | 2020-06-01 | Andrew | Missouri | 29003 | 30 | 0 |
201370 | 201370 | 2020-06-02 | Andrew | Missouri | 29003 | 30 | 0 |
204447 | 204447 | 2020-06-03 | Andrew | Missouri | 29003 | 31 | 0 |
207528 | 207528 | 2020-06-04 | Andrew | Missouri | 29003 | 31 | 0 |
210609 | 210609 | 2020-06-05 | Andrew | Missouri | 29003 | 32 | 0 |
213693 | 213693 | 2020-06-06 | Andrew | Missouri | 29003 | 33 | 0 |
216781 | 216781 | 2020-06-07 | Andrew | Missouri | 29003 | 33 | 0 |
219873 | 219873 | 2020-06-08 | Andrew | Missouri | 29003 | 33 | 0 |
222968 | 222968 | 2020-06-09 | Andrew | Missouri | 29003 | 33 | 0 |
226066 | 226066 | 2020-06-10 | Andrew | Missouri | 29003 | 34 | 0 |
229168 | 229168 | 2020-06-11 | Andrew | Missouri | 29003 | 34 | 0 |
232272 | 232272 | 2020-06-12 | Andrew | Missouri | 29003 | 34 | 0 |
235378 | 235378 | 2020-06-13 | Andrew | Missouri | 29003 | 35 | 0 |
238485 | 238485 | 2020-06-14 | Andrew | Missouri | 29003 | 35 | 0 |
241594 | 241594 | 2020-06-15 | Andrew | Missouri | 29003 | 35 | 0 |
244705 | 244705 | 2020-06-16 | Andrew | Missouri | 29003 | 35 | 0 |
247818 | 247818 | 2020-06-17 | Andrew | Missouri | 29003 | 35 | 0 |
250931 | 250931 | 2020-06-18 | Andrew | Missouri | 29003 | 36 | 0 |
254046 | 254046 | 2020-06-19 | Andrew | Missouri | 29003 | 39 | 0 |
257166 | 257166 | 2020-06-20 | Andrew | Missouri | 29003 | 41 | 0 |
260292 | 260292 | 2020-06-21 | Andrew | Missouri | 29003 | 41 | 0 |
263420 | 263420 | 2020-06-22 | Andrew | Missouri | 29003 | 42 | 0 |
266546 | 266546 | 2020-06-23 | Andrew | Missouri | 29003 | 43 | 0 |
269679 | 269679 | 2020-06-24 | Andrew | Missouri | 29003 | 45 | 0 |
272817 | 272817 | 2020-06-25 | Andrew | Missouri | 29003 | 45 | 0 |
275960 | 275960 | 2020-06-26 | Andrew | Missouri | 29003 | 45 | 0 |
279108 | 279108 | 2020-06-27 | Andrew | Missouri | 29003 | 49 | 0 |
282256 | 282256 | 2020-06-28 | Andrew | Missouri | 29003 | 49 | 0 |
285401 | 285401 | 2020-06-29 | Andrew | Missouri | 29003 | 50 | 0 |
288551 | 288551 | 2020-06-30 | Andrew | Missouri | 29003 | 51 | 0 |
291702 | 291702 | 2020-07-01 | Andrew | Missouri | 29003 | 52 | 0 |
294856 | 294856 | 2020-07-02 | Andrew | Missouri | 29003 | 54 | 0 |
298014 | 298014 | 2020-07-03 | Andrew | Missouri | 29003 | 55 | 0 |
301177 | 301177 | 2020-07-04 | Andrew | Missouri | 29003 | 55 | 0 |
304341 | 304341 | 2020-07-05 | Andrew | Missouri | 29003 | 55 | 0 |
307508 | 307508 | 2020-07-06 | Andrew | Missouri | 29003 | 56 | 0 |
310676 | 310676 | 2020-07-07 | Andrew | Missouri | 29003 | 59 | 0 |
313846 | 313846 | 2020-07-08 | Andrew | Missouri | 29003 | 59 | 0 |
317020 | 317020 | 2020-07-09 | Andrew | Missouri | 29003 | 58 | 0 |
320195 | 320195 | 2020-07-10 | Andrew | Missouri | 29003 | 55 | 1 |
323374 | 323374 | 2020-07-11 | Andrew | Missouri | 29003 | 55 | 1 |
326557 | 326557 | 2020-07-12 | Andrew | Missouri | 29003 | 55 | 1 |
329743 | 329743 | 2020-07-13 | Andrew | Missouri | 29003 | 55 | 1 |
332930 | 332930 | 2020-07-14 | Andrew | Missouri | 29003 | 55 | 1 |
336123 | 336123 | 2020-07-15 | Andrew | Missouri | 29003 | 55 | 1 |
339319 | 339319 | 2020-07-16 | Andrew | Missouri | 29003 | 55 | 1 |
342515 | 342515 | 2020-07-17 | Andrew | Missouri | 29003 | 59 | 1 |
345715 | 345715 | 2020-07-18 | Andrew | Missouri | 29003 | 60 | 1 |
348916 | 348916 | 2020-07-19 | Andrew | Missouri | 29003 | 65 | 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);