ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Pike" and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20742 | 20742 | 2020-03-30 | Pike | Missouri | 29163 | 1 | 0 |
22861 | 22861 | 2020-03-31 | Pike | Missouri | 29163 | 1 | 0 |
25049 | 25049 | 2020-04-01 | Pike | Missouri | 29163 | 1 | 0 |
27306 | 27306 | 2020-04-02 | Pike | Missouri | 29163 | 1 | 0 |
29627 | 29627 | 2020-04-03 | Pike | Missouri | 29163 | 2 | 0 |
32008 | 32008 | 2020-04-04 | Pike | Missouri | 29163 | 2 | 0 |
34436 | 34436 | 2020-04-05 | Pike | Missouri | 29163 | 2 | 0 |
36902 | 36902 | 2020-04-06 | Pike | Missouri | 29163 | 2 | 0 |
39416 | 39416 | 2020-04-07 | Pike | Missouri | 29163 | 2 | 0 |
41970 | 41970 | 2020-04-08 | Pike | Missouri | 29163 | 4 | 0 |
44547 | 44547 | 2020-04-09 | Pike | Missouri | 29163 | 5 | 0 |
47156 | 47156 | 2020-04-10 | Pike | Missouri | 29163 | 5 | 0 |
49804 | 49804 | 2020-04-11 | Pike | Missouri | 29163 | 6 | 0 |
52477 | 52477 | 2020-04-12 | Pike | Missouri | 29163 | 6 | 0 |
55159 | 55159 | 2020-04-13 | Pike | Missouri | 29163 | 6 | 0 |
57857 | 57857 | 2020-04-14 | Pike | Missouri | 29163 | 6 | 0 |
60571 | 60571 | 2020-04-15 | Pike | Missouri | 29163 | 6 | 0 |
63293 | 63293 | 2020-04-16 | Pike | Missouri | 29163 | 6 | 0 |
66033 | 66033 | 2020-04-17 | Pike | Missouri | 29163 | 6 | 0 |
68787 | 68787 | 2020-04-18 | Pike | Missouri | 29163 | 6 | 0 |
71554 | 71554 | 2020-04-19 | Pike | Missouri | 29163 | 6 | 0 |
74327 | 74327 | 2020-04-20 | Pike | Missouri | 29163 | 6 | 0 |
77108 | 77108 | 2020-04-21 | Pike | Missouri | 29163 | 6 | 0 |
79895 | 79895 | 2020-04-22 | Pike | Missouri | 29163 | 6 | 0 |
82691 | 82691 | 2020-04-23 | Pike | Missouri | 29163 | 6 | 0 |
85495 | 85495 | 2020-04-24 | Pike | Missouri | 29163 | 6 | 0 |
88305 | 88305 | 2020-04-25 | Pike | Missouri | 29163 | 7 | 0 |
91121 | 91121 | 2020-04-26 | Pike | Missouri | 29163 | 8 | 0 |
93942 | 93942 | 2020-04-27 | Pike | Missouri | 29163 | 9 | 0 |
96778 | 96778 | 2020-04-28 | Pike | Missouri | 29163 | 9 | 0 |
99624 | 99624 | 2020-04-29 | Pike | Missouri | 29163 | 10 | 0 |
102476 | 102476 | 2020-04-30 | Pike | Missouri | 29163 | 11 | 0 |
105337 | 105337 | 2020-05-01 | Pike | Missouri | 29163 | 11 | 0 |
108202 | 108202 | 2020-05-02 | Pike | Missouri | 29163 | 11 | 0 |
111074 | 111074 | 2020-05-03 | Pike | Missouri | 29163 | 11 | 0 |
113953 | 113953 | 2020-05-04 | Pike | Missouri | 29163 | 11 | 0 |
116835 | 116835 | 2020-05-05 | Pike | Missouri | 29163 | 11 | 0 |
119795 | 119795 | 2020-05-06 | Pike | Missouri | 29163 | 12 | 0 |
122769 | 122769 | 2020-05-07 | Pike | Missouri | 29163 | 12 | 0 |
125751 | 125751 | 2020-05-08 | Pike | Missouri | 29163 | 13 | 0 |
128739 | 128739 | 2020-05-09 | Pike | Missouri | 29163 | 12 | 0 |
131729 | 131729 | 2020-05-10 | Pike | Missouri | 29163 | 12 | 0 |
134720 | 134720 | 2020-05-11 | Pike | Missouri | 29163 | 12 | 0 |
137710 | 137710 | 2020-05-12 | Pike | Missouri | 29163 | 12 | 1 |
140704 | 140704 | 2020-05-13 | Pike | Missouri | 29163 | 13 | 1 |
143699 | 143699 | 2020-05-14 | Pike | Missouri | 29163 | 14 | 1 |
146700 | 146700 | 2020-05-15 | Pike | Missouri | 29163 | 13 | 1 |
149705 | 149705 | 2020-05-16 | Pike | Missouri | 29163 | 13 | 1 |
152716 | 152716 | 2020-05-17 | Pike | Missouri | 29163 | 13 | 1 |
155730 | 155730 | 2020-05-18 | Pike | Missouri | 29163 | 14 | 1 |
158748 | 158748 | 2020-05-19 | Pike | Missouri | 29163 | 14 | 1 |
161774 | 161774 | 2020-05-20 | Pike | Missouri | 29163 | 14 | 1 |
164803 | 164803 | 2020-05-21 | Pike | Missouri | 29163 | 14 | 1 |
167839 | 167839 | 2020-05-22 | Pike | Missouri | 29163 | 14 | 1 |
170878 | 170878 | 2020-05-23 | Pike | Missouri | 29163 | 14 | 1 |
173920 | 173920 | 2020-05-24 | Pike | Missouri | 29163 | 14 | 1 |
176963 | 176963 | 2020-05-25 | Pike | Missouri | 29163 | 14 | 1 |
180007 | 180007 | 2020-05-26 | Pike | Missouri | 29163 | 15 | 1 |
183054 | 183054 | 2020-05-27 | Pike | Missouri | 29163 | 16 | 1 |
186110 | 186110 | 2020-05-28 | Pike | Missouri | 29163 | 17 | 1 |
189168 | 189168 | 2020-05-29 | Pike | Missouri | 29163 | 17 | 1 |
192232 | 192232 | 2020-05-30 | Pike | Missouri | 29163 | 19 | 1 |
195302 | 195302 | 2020-05-31 | Pike | Missouri | 29163 | 22 | 1 |
198373 | 198373 | 2020-06-01 | Pike | Missouri | 29163 | 22 | 1 |
201446 | 201446 | 2020-06-02 | Pike | Missouri | 29163 | 25 | 1 |
204523 | 204523 | 2020-06-03 | Pike | Missouri | 29163 | 27 | 1 |
207604 | 207604 | 2020-06-04 | Pike | Missouri | 29163 | 27 | 1 |
210685 | 210685 | 2020-06-05 | Pike | Missouri | 29163 | 28 | 1 |
213769 | 213769 | 2020-06-06 | Pike | Missouri | 29163 | 28 | 1 |
216857 | 216857 | 2020-06-07 | Pike | Missouri | 29163 | 28 | 1 |
219949 | 219949 | 2020-06-08 | Pike | Missouri | 29163 | 28 | 1 |
223044 | 223044 | 2020-06-09 | Pike | Missouri | 29163 | 28 | 1 |
226143 | 226143 | 2020-06-10 | Pike | Missouri | 29163 | 29 | 1 |
229246 | 229246 | 2020-06-11 | Pike | Missouri | 29163 | 29 | 1 |
232350 | 232350 | 2020-06-12 | Pike | Missouri | 29163 | 31 | 1 |
235456 | 235456 | 2020-06-13 | Pike | Missouri | 29163 | 31 | 1 |
238563 | 238563 | 2020-06-14 | Pike | Missouri | 29163 | 31 | 1 |
241673 | 241673 | 2020-06-15 | Pike | Missouri | 29163 | 32 | 1 |
244784 | 244784 | 2020-06-16 | Pike | Missouri | 29163 | 31 | 1 |
247897 | 247897 | 2020-06-17 | Pike | Missouri | 29163 | 31 | 1 |
251010 | 251010 | 2020-06-18 | Pike | Missouri | 29163 | 31 | 1 |
254125 | 254125 | 2020-06-19 | Pike | Missouri | 29163 | 33 | 1 |
257246 | 257246 | 2020-06-20 | Pike | Missouri | 29163 | 33 | 1 |
260372 | 260372 | 2020-06-21 | Pike | Missouri | 29163 | 33 | 1 |
263500 | 263500 | 2020-06-22 | Pike | Missouri | 29163 | 34 | 1 |
266626 | 266626 | 2020-06-23 | Pike | Missouri | 29163 | 34 | 1 |
269759 | 269759 | 2020-06-24 | Pike | Missouri | 29163 | 34 | 1 |
272898 | 272898 | 2020-06-25 | Pike | Missouri | 29163 | 36 | 1 |
276041 | 276041 | 2020-06-26 | Pike | Missouri | 29163 | 36 | 1 |
279189 | 279189 | 2020-06-27 | Pike | Missouri | 29163 | 36 | 1 |
282337 | 282337 | 2020-06-28 | Pike | Missouri | 29163 | 37 | 1 |
285482 | 285482 | 2020-06-29 | Pike | Missouri | 29163 | 37 | 1 |
288632 | 288632 | 2020-06-30 | Pike | Missouri | 29163 | 37 | 1 |
291783 | 291783 | 2020-07-01 | Pike | Missouri | 29163 | 37 | 1 |
294937 | 294937 | 2020-07-02 | Pike | Missouri | 29163 | 37 | 1 |
298095 | 298095 | 2020-07-03 | Pike | Missouri | 29163 | 37 | 1 |
301258 | 301258 | 2020-07-04 | Pike | Missouri | 29163 | 37 | 1 |
304422 | 304422 | 2020-07-05 | Pike | Missouri | 29163 | 37 | 1 |
307589 | 307589 | 2020-07-06 | Pike | Missouri | 29163 | 37 | 1 |
310757 | 310757 | 2020-07-07 | Pike | Missouri | 29163 | 37 | 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);