ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Polk" and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39418 | 39418 | 2020-04-07 | Polk | Missouri | 29167 | 1 | 0 |
41972 | 41972 | 2020-04-08 | Polk | Missouri | 29167 | 1 | 0 |
44549 | 44549 | 2020-04-09 | Polk | Missouri | 29167 | 1 | 0 |
47158 | 47158 | 2020-04-10 | Polk | Missouri | 29167 | 1 | 0 |
49806 | 49806 | 2020-04-11 | Polk | Missouri | 29167 | 1 | 0 |
52479 | 52479 | 2020-04-12 | Polk | Missouri | 29167 | 1 | 0 |
55161 | 55161 | 2020-04-13 | Polk | Missouri | 29167 | 1 | 0 |
57859 | 57859 | 2020-04-14 | Polk | Missouri | 29167 | 1 | 0 |
60573 | 60573 | 2020-04-15 | Polk | Missouri | 29167 | 1 | 0 |
63295 | 63295 | 2020-04-16 | Polk | Missouri | 29167 | 1 | 0 |
66035 | 66035 | 2020-04-17 | Polk | Missouri | 29167 | 1 | 0 |
68789 | 68789 | 2020-04-18 | Polk | Missouri | 29167 | 1 | 0 |
71556 | 71556 | 2020-04-19 | Polk | Missouri | 29167 | 1 | 0 |
74329 | 74329 | 2020-04-20 | Polk | Missouri | 29167 | 1 | 0 |
77110 | 77110 | 2020-04-21 | Polk | Missouri | 29167 | 1 | 0 |
79897 | 79897 | 2020-04-22 | Polk | Missouri | 29167 | 1 | 0 |
82693 | 82693 | 2020-04-23 | Polk | Missouri | 29167 | 1 | 0 |
85497 | 85497 | 2020-04-24 | Polk | Missouri | 29167 | 1 | 0 |
88307 | 88307 | 2020-04-25 | Polk | Missouri | 29167 | 1 | 0 |
91123 | 91123 | 2020-04-26 | Polk | Missouri | 29167 | 1 | 0 |
93944 | 93944 | 2020-04-27 | Polk | Missouri | 29167 | 1 | 0 |
96780 | 96780 | 2020-04-28 | Polk | Missouri | 29167 | 1 | 0 |
99626 | 99626 | 2020-04-29 | Polk | Missouri | 29167 | 1 | 0 |
102478 | 102478 | 2020-04-30 | Polk | Missouri | 29167 | 1 | 0 |
105339 | 105339 | 2020-05-01 | Polk | Missouri | 29167 | 1 | 0 |
108204 | 108204 | 2020-05-02 | Polk | Missouri | 29167 | 1 | 0 |
111076 | 111076 | 2020-05-03 | Polk | Missouri | 29167 | 1 | 0 |
113955 | 113955 | 2020-05-04 | Polk | Missouri | 29167 | 1 | 0 |
116837 | 116837 | 2020-05-05 | Polk | Missouri | 29167 | 1 | 0 |
119797 | 119797 | 2020-05-06 | Polk | Missouri | 29167 | 1 | 0 |
122771 | 122771 | 2020-05-07 | Polk | Missouri | 29167 | 1 | 0 |
125753 | 125753 | 2020-05-08 | Polk | Missouri | 29167 | 1 | 0 |
128741 | 128741 | 2020-05-09 | Polk | Missouri | 29167 | 1 | 0 |
131731 | 131731 | 2020-05-10 | Polk | Missouri | 29167 | 1 | 0 |
134722 | 134722 | 2020-05-11 | Polk | Missouri | 29167 | 1 | 0 |
137712 | 137712 | 2020-05-12 | Polk | Missouri | 29167 | 1 | 0 |
140706 | 140706 | 2020-05-13 | Polk | Missouri | 29167 | 1 | 0 |
143701 | 143701 | 2020-05-14 | Polk | Missouri | 29167 | 1 | 0 |
146702 | 146702 | 2020-05-15 | Polk | Missouri | 29167 | 1 | 0 |
149707 | 149707 | 2020-05-16 | Polk | Missouri | 29167 | 2 | 0 |
152718 | 152718 | 2020-05-17 | Polk | Missouri | 29167 | 2 | 0 |
155732 | 155732 | 2020-05-18 | Polk | Missouri | 29167 | 2 | 0 |
158750 | 158750 | 2020-05-19 | Polk | Missouri | 29167 | 2 | 0 |
161776 | 161776 | 2020-05-20 | Polk | Missouri | 29167 | 2 | 0 |
164805 | 164805 | 2020-05-21 | Polk | Missouri | 29167 | 2 | 0 |
167841 | 167841 | 2020-05-22 | Polk | Missouri | 29167 | 2 | 0 |
170880 | 170880 | 2020-05-23 | Polk | Missouri | 29167 | 3 | 0 |
173922 | 173922 | 2020-05-24 | Polk | Missouri | 29167 | 2 | 0 |
176965 | 176965 | 2020-05-25 | Polk | Missouri | 29167 | 2 | 0 |
180009 | 180009 | 2020-05-26 | Polk | Missouri | 29167 | 2 | 0 |
183056 | 183056 | 2020-05-27 | Polk | Missouri | 29167 | 2 | 0 |
186112 | 186112 | 2020-05-28 | Polk | Missouri | 29167 | 2 | 0 |
189170 | 189170 | 2020-05-29 | Polk | Missouri | 29167 | 2 | 0 |
192234 | 192234 | 2020-05-30 | Polk | Missouri | 29167 | 2 | 0 |
195304 | 195304 | 2020-05-31 | Polk | Missouri | 29167 | 2 | 0 |
198375 | 198375 | 2020-06-01 | Polk | Missouri | 29167 | 2 | 0 |
201448 | 201448 | 2020-06-02 | Polk | Missouri | 29167 | 3 | 0 |
204525 | 204525 | 2020-06-03 | Polk | Missouri | 29167 | 3 | 0 |
207606 | 207606 | 2020-06-04 | Polk | Missouri | 29167 | 4 | 0 |
210687 | 210687 | 2020-06-05 | Polk | Missouri | 29167 | 4 | 0 |
213771 | 213771 | 2020-06-06 | Polk | Missouri | 29167 | 4 | 0 |
216859 | 216859 | 2020-06-07 | Polk | Missouri | 29167 | 4 | 0 |
219951 | 219951 | 2020-06-08 | Polk | Missouri | 29167 | 4 | 0 |
223046 | 223046 | 2020-06-09 | Polk | Missouri | 29167 | 4 | 0 |
226145 | 226145 | 2020-06-10 | Polk | Missouri | 29167 | 4 | 0 |
229248 | 229248 | 2020-06-11 | Polk | Missouri | 29167 | 7 | 0 |
232352 | 232352 | 2020-06-12 | Polk | Missouri | 29167 | 7 | 0 |
235458 | 235458 | 2020-06-13 | Polk | Missouri | 29167 | 8 | 0 |
238565 | 238565 | 2020-06-14 | Polk | Missouri | 29167 | 8 | 0 |
241675 | 241675 | 2020-06-15 | Polk | Missouri | 29167 | 10 | 0 |
244786 | 244786 | 2020-06-16 | Polk | Missouri | 29167 | 9 | 0 |
247899 | 247899 | 2020-06-17 | Polk | Missouri | 29167 | 10 | 0 |
251012 | 251012 | 2020-06-18 | Polk | Missouri | 29167 | 11 | 0 |
254127 | 254127 | 2020-06-19 | Polk | Missouri | 29167 | 10 | 0 |
257248 | 257248 | 2020-06-20 | Polk | Missouri | 29167 | 10 | 0 |
260374 | 260374 | 2020-06-21 | Polk | Missouri | 29167 | 10 | 0 |
263502 | 263502 | 2020-06-22 | Polk | Missouri | 29167 | 10 | 0 |
266628 | 266628 | 2020-06-23 | Polk | Missouri | 29167 | 12 | 0 |
269761 | 269761 | 2020-06-24 | Polk | Missouri | 29167 | 11 | 0 |
272900 | 272900 | 2020-06-25 | Polk | Missouri | 29167 | 11 | 0 |
276043 | 276043 | 2020-06-26 | Polk | Missouri | 29167 | 13 | 0 |
279191 | 279191 | 2020-06-27 | Polk | Missouri | 29167 | 13 | 0 |
282339 | 282339 | 2020-06-28 | Polk | Missouri | 29167 | 13 | 0 |
285484 | 285484 | 2020-06-29 | Polk | Missouri | 29167 | 13 | 0 |
288634 | 288634 | 2020-06-30 | Polk | Missouri | 29167 | 15 | 0 |
291785 | 291785 | 2020-07-01 | Polk | Missouri | 29167 | 16 | 0 |
294939 | 294939 | 2020-07-02 | Polk | Missouri | 29167 | 16 | 0 |
298097 | 298097 | 2020-07-03 | Polk | Missouri | 29167 | 15 | 0 |
301260 | 301260 | 2020-07-04 | Polk | Missouri | 29167 | 15 | 0 |
304424 | 304424 | 2020-07-05 | Polk | Missouri | 29167 | 15 | 0 |
307591 | 307591 | 2020-07-06 | Polk | Missouri | 29167 | 15 | 0 |
310759 | 310759 | 2020-07-07 | Polk | Missouri | 29167 | 16 | 0 |
313930 | 313930 | 2020-07-08 | Polk | Missouri | 29167 | 17 | 0 |
317104 | 317104 | 2020-07-09 | Polk | Missouri | 29167 | 19 | 0 |
320279 | 320279 | 2020-07-10 | Polk | Missouri | 29167 | 19 | 0 |
323458 | 323458 | 2020-07-11 | Polk | Missouri | 29167 | 20 | 0 |
326641 | 326641 | 2020-07-12 | Polk | Missouri | 29167 | 21 | 0 |
329827 | 329827 | 2020-07-13 | Polk | Missouri | 29167 | 22 | 0 |
333014 | 333014 | 2020-07-14 | Polk | Missouri | 29167 | 22 | 0 |
336207 | 336207 | 2020-07-15 | Polk | Missouri | 29167 | 23 | 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);