ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29013 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384217 | 384217 | 2020-07-30 | Bates | Missouri | 29013 | 34 | 1 |
381001 | 381001 | 2020-07-29 | Bates | Missouri | 29013 | 32 | 1 |
377784 | 377784 | 2020-07-28 | Bates | Missouri | 29013 | 32 | 1 |
374569 | 374569 | 2020-07-27 | Bates | Missouri | 29013 | 32 | 1 |
371357 | 371357 | 2020-07-26 | Bates | Missouri | 29013 | 29 | 1 |
368146 | 368146 | 2020-07-25 | Bates | Missouri | 29013 | 29 | 1 |
364938 | 364938 | 2020-07-24 | Bates | Missouri | 29013 | 28 | 1 |
361731 | 361731 | 2020-07-23 | Bates | Missouri | 29013 | 24 | 1 |
358526 | 358526 | 2020-07-22 | Bates | Missouri | 29013 | 24 | 1 |
355323 | 355323 | 2020-07-21 | Bates | Missouri | 29013 | 20 | 1 |
352121 | 352121 | 2020-07-20 | Bates | Missouri | 29013 | 19 | 1 |
348921 | 348921 | 2020-07-19 | Bates | Missouri | 29013 | 18 | 1 |
345720 | 345720 | 2020-07-18 | Bates | Missouri | 29013 | 17 | 1 |
342520 | 342520 | 2020-07-17 | Bates | Missouri | 29013 | 17 | 1 |
339324 | 339324 | 2020-07-16 | Bates | Missouri | 29013 | 17 | 1 |
336128 | 336128 | 2020-07-15 | Bates | Missouri | 29013 | 16 | 1 |
332935 | 332935 | 2020-07-14 | Bates | Missouri | 29013 | 16 | 1 |
329748 | 329748 | 2020-07-13 | Bates | Missouri | 29013 | 14 | 1 |
326562 | 326562 | 2020-07-12 | Bates | Missouri | 29013 | 13 | 1 |
323379 | 323379 | 2020-07-11 | Bates | Missouri | 29013 | 13 | 1 |
320200 | 320200 | 2020-07-10 | Bates | Missouri | 29013 | 13 | 1 |
317025 | 317025 | 2020-07-09 | Bates | Missouri | 29013 | 12 | 1 |
313851 | 313851 | 2020-07-08 | Bates | Missouri | 29013 | 12 | 1 |
310681 | 310681 | 2020-07-07 | Bates | Missouri | 29013 | 12 | 1 |
307513 | 307513 | 2020-07-06 | Bates | Missouri | 29013 | 12 | 1 |
304346 | 304346 | 2020-07-05 | Bates | Missouri | 29013 | 12 | 1 |
301182 | 301182 | 2020-07-04 | Bates | Missouri | 29013 | 12 | 1 |
298019 | 298019 | 2020-07-03 | Bates | Missouri | 29013 | 12 | 1 |
294861 | 294861 | 2020-07-02 | Bates | Missouri | 29013 | 12 | 1 |
291707 | 291707 | 2020-07-01 | Bates | Missouri | 29013 | 12 | 1 |
288556 | 288556 | 2020-06-30 | Bates | Missouri | 29013 | 12 | 1 |
285406 | 285406 | 2020-06-29 | Bates | Missouri | 29013 | 12 | 1 |
282261 | 282261 | 2020-06-28 | Bates | Missouri | 29013 | 12 | 1 |
279113 | 279113 | 2020-06-27 | Bates | Missouri | 29013 | 12 | 1 |
275965 | 275965 | 2020-06-26 | Bates | Missouri | 29013 | 12 | 1 |
272822 | 272822 | 2020-06-25 | Bates | Missouri | 29013 | 12 | 1 |
269684 | 269684 | 2020-06-24 | Bates | Missouri | 29013 | 12 | 1 |
266551 | 266551 | 2020-06-23 | Bates | Missouri | 29013 | 12 | 1 |
263425 | 263425 | 2020-06-22 | Bates | Missouri | 29013 | 12 | 1 |
260297 | 260297 | 2020-06-21 | Bates | Missouri | 29013 | 12 | 1 |
257171 | 257171 | 2020-06-20 | Bates | Missouri | 29013 | 12 | 1 |
254051 | 254051 | 2020-06-19 | Bates | Missouri | 29013 | 12 | 1 |
250936 | 250936 | 2020-06-18 | Bates | Missouri | 29013 | 12 | 1 |
247823 | 247823 | 2020-06-17 | Bates | Missouri | 29013 | 12 | 1 |
244710 | 244710 | 2020-06-16 | Bates | Missouri | 29013 | 12 | 1 |
241599 | 241599 | 2020-06-15 | Bates | Missouri | 29013 | 12 | 1 |
238490 | 238490 | 2020-06-14 | Bates | Missouri | 29013 | 12 | 1 |
235383 | 235383 | 2020-06-13 | Bates | Missouri | 29013 | 12 | 1 |
232277 | 232277 | 2020-06-12 | Bates | Missouri | 29013 | 12 | 1 |
229173 | 229173 | 2020-06-11 | Bates | Missouri | 29013 | 12 | 1 |
226070 | 226070 | 2020-06-10 | Bates | Missouri | 29013 | 12 | 1 |
222972 | 222972 | 2020-06-09 | Bates | Missouri | 29013 | 12 | 1 |
219877 | 219877 | 2020-06-08 | Bates | Missouri | 29013 | 12 | 1 |
216785 | 216785 | 2020-06-07 | Bates | Missouri | 29013 | 12 | 1 |
213697 | 213697 | 2020-06-06 | Bates | Missouri | 29013 | 12 | 1 |
210613 | 210613 | 2020-06-05 | Bates | Missouri | 29013 | 12 | 1 |
207532 | 207532 | 2020-06-04 | Bates | Missouri | 29013 | 12 | 1 |
204451 | 204451 | 2020-06-03 | Bates | Missouri | 29013 | 10 | 1 |
201374 | 201374 | 2020-06-02 | Bates | Missouri | 29013 | 10 | 1 |
198301 | 198301 | 2020-06-01 | Bates | Missouri | 29013 | 9 | 1 |
195230 | 195230 | 2020-05-31 | Bates | Missouri | 29013 | 7 | 1 |
192162 | 192162 | 2020-05-30 | Bates | Missouri | 29013 | 7 | 1 |
189098 | 189098 | 2020-05-29 | Bates | Missouri | 29013 | 7 | 1 |
186040 | 186040 | 2020-05-28 | Bates | Missouri | 29013 | 7 | 1 |
182984 | 182984 | 2020-05-27 | Bates | Missouri | 29013 | 7 | 1 |
179938 | 179938 | 2020-05-26 | Bates | Missouri | 29013 | 7 | 1 |
176894 | 176894 | 2020-05-25 | Bates | Missouri | 29013 | 7 | 1 |
173851 | 173851 | 2020-05-24 | Bates | Missouri | 29013 | 7 | 1 |
170809 | 170809 | 2020-05-23 | Bates | Missouri | 29013 | 7 | 1 |
167771 | 167771 | 2020-05-22 | Bates | Missouri | 29013 | 7 | 1 |
164735 | 164735 | 2020-05-21 | Bates | Missouri | 29013 | 7 | 1 |
161706 | 161706 | 2020-05-20 | Bates | Missouri | 29013 | 7 | 1 |
158680 | 158680 | 2020-05-19 | Bates | Missouri | 29013 | 7 | 1 |
155662 | 155662 | 2020-05-18 | Bates | Missouri | 29013 | 7 | 1 |
152648 | 152648 | 2020-05-17 | Bates | Missouri | 29013 | 7 | 1 |
149637 | 149637 | 2020-05-16 | Bates | Missouri | 29013 | 7 | 1 |
146632 | 146632 | 2020-05-15 | Bates | Missouri | 29013 | 6 | 1 |
143632 | 143632 | 2020-05-14 | Bates | Missouri | 29013 | 6 | 1 |
140637 | 140637 | 2020-05-13 | Bates | Missouri | 29013 | 6 | 1 |
137643 | 137643 | 2020-05-12 | Bates | Missouri | 29013 | 6 | 1 |
134653 | 134653 | 2020-05-11 | Bates | Missouri | 29013 | 6 | 1 |
131662 | 131662 | 2020-05-10 | Bates | Missouri | 29013 | 6 | 1 |
128672 | 128672 | 2020-05-09 | Bates | Missouri | 29013 | 6 | 1 |
125685 | 125685 | 2020-05-08 | Bates | Missouri | 29013 | 6 | 1 |
122703 | 122703 | 2020-05-07 | Bates | Missouri | 29013 | 6 | 1 |
119729 | 119729 | 2020-05-06 | Bates | Missouri | 29013 | 6 | 1 |
116769 | 116769 | 2020-05-05 | Bates | Missouri | 29013 | 6 | 1 |
113887 | 113887 | 2020-05-04 | Bates | Missouri | 29013 | 6 | 1 |
111008 | 111008 | 2020-05-03 | Bates | Missouri | 29013 | 6 | 1 |
108137 | 108137 | 2020-05-02 | Bates | Missouri | 29013 | 6 | 1 |
105272 | 105272 | 2020-05-01 | Bates | Missouri | 29013 | 6 | 1 |
102411 | 102411 | 2020-04-30 | Bates | Missouri | 29013 | 6 | 1 |
99559 | 99559 | 2020-04-29 | Bates | Missouri | 29013 | 6 | 1 |
96713 | 96713 | 2020-04-28 | Bates | Missouri | 29013 | 6 | 1 |
93877 | 93877 | 2020-04-27 | Bates | Missouri | 29013 | 6 | 1 |
91056 | 91056 | 2020-04-26 | Bates | Missouri | 29013 | 6 | 1 |
88240 | 88240 | 2020-04-25 | Bates | Missouri | 29013 | 6 | 1 |
85430 | 85430 | 2020-04-24 | Bates | Missouri | 29013 | 6 | 1 |
82626 | 82626 | 2020-04-23 | Bates | Missouri | 29013 | 6 | 1 |
79830 | 79830 | 2020-04-22 | Bates | Missouri | 29013 | 6 | 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);