ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where county = "Crawford", deaths = 0 and fips = 29055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
455117 | 455117 | 2020-08-21 | Crawford | Missouri | 29055 | 132 | 0 |
451889 | 451889 | 2020-08-20 | Crawford | Missouri | 29055 | 126 | 0 |
448661 | 448661 | 2020-08-19 | Crawford | Missouri | 29055 | 121 | 0 |
445435 | 445435 | 2020-08-18 | Crawford | Missouri | 29055 | 115 | 0 |
442209 | 442209 | 2020-08-17 | Crawford | Missouri | 29055 | 115 | 0 |
438982 | 438982 | 2020-08-16 | Crawford | Missouri | 29055 | 111 | 0 |
435757 | 435757 | 2020-08-15 | Crawford | Missouri | 29055 | 102 | 0 |
432531 | 432531 | 2020-08-14 | Crawford | Missouri | 29055 | 97 | 0 |
429304 | 429304 | 2020-08-13 | Crawford | Missouri | 29055 | 90 | 0 |
426080 | 426080 | 2020-08-12 | Crawford | Missouri | 29055 | 83 | 0 |
422858 | 422858 | 2020-08-11 | Crawford | Missouri | 29055 | 79 | 0 |
419636 | 419636 | 2020-08-10 | Crawford | Missouri | 29055 | 78 | 0 |
416415 | 416415 | 2020-08-09 | Crawford | Missouri | 29055 | 73 | 0 |
413195 | 413195 | 2020-08-08 | Crawford | Missouri | 29055 | 71 | 0 |
409975 | 409975 | 2020-08-07 | Crawford | Missouri | 29055 | 71 | 0 |
406755 | 406755 | 2020-08-06 | Crawford | Missouri | 29055 | 69 | 0 |
403537 | 403537 | 2020-08-05 | Crawford | Missouri | 29055 | 62 | 0 |
400320 | 400320 | 2020-08-04 | Crawford | Missouri | 29055 | 58 | 0 |
397106 | 397106 | 2020-08-03 | Crawford | Missouri | 29055 | 57 | 0 |
393890 | 393890 | 2020-08-02 | Crawford | Missouri | 29055 | 56 | 0 |
390673 | 390673 | 2020-08-01 | Crawford | Missouri | 29055 | 52 | 0 |
387456 | 387456 | 2020-07-31 | Crawford | Missouri | 29055 | 47 | 0 |
384238 | 384238 | 2020-07-30 | Crawford | Missouri | 29055 | 40 | 0 |
381022 | 381022 | 2020-07-29 | Crawford | Missouri | 29055 | 36 | 0 |
377805 | 377805 | 2020-07-28 | Crawford | Missouri | 29055 | 33 | 0 |
374590 | 374590 | 2020-07-27 | Crawford | Missouri | 29055 | 35 | 0 |
371378 | 371378 | 2020-07-26 | Crawford | Missouri | 29055 | 34 | 0 |
368167 | 368167 | 2020-07-25 | Crawford | Missouri | 29055 | 33 | 0 |
364959 | 364959 | 2020-07-24 | Crawford | Missouri | 29055 | 32 | 0 |
361752 | 361752 | 2020-07-23 | Crawford | Missouri | 29055 | 32 | 0 |
358547 | 358547 | 2020-07-22 | Crawford | Missouri | 29055 | 31 | 0 |
355344 | 355344 | 2020-07-21 | Crawford | Missouri | 29055 | 30 | 0 |
352142 | 352142 | 2020-07-20 | Crawford | Missouri | 29055 | 28 | 0 |
348942 | 348942 | 2020-07-19 | Crawford | Missouri | 29055 | 28 | 0 |
345741 | 345741 | 2020-07-18 | Crawford | Missouri | 29055 | 28 | 0 |
342541 | 342541 | 2020-07-17 | Crawford | Missouri | 29055 | 27 | 0 |
339345 | 339345 | 2020-07-16 | Crawford | Missouri | 29055 | 26 | 0 |
336149 | 336149 | 2020-07-15 | Crawford | Missouri | 29055 | 24 | 0 |
332956 | 332956 | 2020-07-14 | Crawford | Missouri | 29055 | 23 | 0 |
329769 | 329769 | 2020-07-13 | Crawford | Missouri | 29055 | 22 | 0 |
326583 | 326583 | 2020-07-12 | Crawford | Missouri | 29055 | 22 | 0 |
323400 | 323400 | 2020-07-11 | Crawford | Missouri | 29055 | 21 | 0 |
320221 | 320221 | 2020-07-10 | Crawford | Missouri | 29055 | 21 | 0 |
317046 | 317046 | 2020-07-09 | Crawford | Missouri | 29055 | 19 | 0 |
313872 | 313872 | 2020-07-08 | Crawford | Missouri | 29055 | 19 | 0 |
310702 | 310702 | 2020-07-07 | Crawford | Missouri | 29055 | 18 | 0 |
307534 | 307534 | 2020-07-06 | Crawford | Missouri | 29055 | 17 | 0 |
304367 | 304367 | 2020-07-05 | Crawford | Missouri | 29055 | 17 | 0 |
301203 | 301203 | 2020-07-04 | Crawford | Missouri | 29055 | 16 | 0 |
298040 | 298040 | 2020-07-03 | Crawford | Missouri | 29055 | 15 | 0 |
294882 | 294882 | 2020-07-02 | Crawford | Missouri | 29055 | 13 | 0 |
291728 | 291728 | 2020-07-01 | Crawford | Missouri | 29055 | 12 | 0 |
288577 | 288577 | 2020-06-30 | Crawford | Missouri | 29055 | 12 | 0 |
285427 | 285427 | 2020-06-29 | Crawford | Missouri | 29055 | 12 | 0 |
282282 | 282282 | 2020-06-28 | Crawford | Missouri | 29055 | 11 | 0 |
279134 | 279134 | 2020-06-27 | Crawford | Missouri | 29055 | 11 | 0 |
275986 | 275986 | 2020-06-26 | Crawford | Missouri | 29055 | 11 | 0 |
272843 | 272843 | 2020-06-25 | Crawford | Missouri | 29055 | 10 | 0 |
269705 | 269705 | 2020-06-24 | Crawford | Missouri | 29055 | 10 | 0 |
266572 | 266572 | 2020-06-23 | Crawford | Missouri | 29055 | 10 | 0 |
263446 | 263446 | 2020-06-22 | Crawford | Missouri | 29055 | 10 | 0 |
260318 | 260318 | 2020-06-21 | Crawford | Missouri | 29055 | 10 | 0 |
257192 | 257192 | 2020-06-20 | Crawford | Missouri | 29055 | 10 | 0 |
254072 | 254072 | 2020-06-19 | Crawford | Missouri | 29055 | 10 | 0 |
250957 | 250957 | 2020-06-18 | Crawford | Missouri | 29055 | 10 | 0 |
247844 | 247844 | 2020-06-17 | Crawford | Missouri | 29055 | 9 | 0 |
244731 | 244731 | 2020-06-16 | Crawford | Missouri | 29055 | 9 | 0 |
241620 | 241620 | 2020-06-15 | Crawford | Missouri | 29055 | 9 | 0 |
238511 | 238511 | 2020-06-14 | Crawford | Missouri | 29055 | 8 | 0 |
235404 | 235404 | 2020-06-13 | Crawford | Missouri | 29055 | 8 | 0 |
232298 | 232298 | 2020-06-12 | Crawford | Missouri | 29055 | 8 | 0 |
229194 | 229194 | 2020-06-11 | Crawford | Missouri | 29055 | 8 | 0 |
226091 | 226091 | 2020-06-10 | Crawford | Missouri | 29055 | 8 | 0 |
222993 | 222993 | 2020-06-09 | Crawford | Missouri | 29055 | 8 | 0 |
219898 | 219898 | 2020-06-08 | Crawford | Missouri | 29055 | 8 | 0 |
216806 | 216806 | 2020-06-07 | Crawford | Missouri | 29055 | 8 | 0 |
213718 | 213718 | 2020-06-06 | Crawford | Missouri | 29055 | 8 | 0 |
210634 | 210634 | 2020-06-05 | Crawford | Missouri | 29055 | 8 | 0 |
207553 | 207553 | 2020-06-04 | Crawford | Missouri | 29055 | 8 | 0 |
204472 | 204472 | 2020-06-03 | Crawford | Missouri | 29055 | 8 | 0 |
201395 | 201395 | 2020-06-02 | Crawford | Missouri | 29055 | 8 | 0 |
198322 | 198322 | 2020-06-01 | Crawford | Missouri | 29055 | 8 | 0 |
195251 | 195251 | 2020-05-31 | Crawford | Missouri | 29055 | 8 | 0 |
192183 | 192183 | 2020-05-30 | Crawford | Missouri | 29055 | 8 | 0 |
189119 | 189119 | 2020-05-29 | Crawford | Missouri | 29055 | 8 | 0 |
186061 | 186061 | 2020-05-28 | Crawford | Missouri | 29055 | 8 | 0 |
183005 | 183005 | 2020-05-27 | Crawford | Missouri | 29055 | 8 | 0 |
179959 | 179959 | 2020-05-26 | Crawford | Missouri | 29055 | 8 | 0 |
176915 | 176915 | 2020-05-25 | Crawford | Missouri | 29055 | 8 | 0 |
173872 | 173872 | 2020-05-24 | Crawford | Missouri | 29055 | 8 | 0 |
170830 | 170830 | 2020-05-23 | Crawford | Missouri | 29055 | 8 | 0 |
167792 | 167792 | 2020-05-22 | Crawford | Missouri | 29055 | 8 | 0 |
164756 | 164756 | 2020-05-21 | Crawford | Missouri | 29055 | 8 | 0 |
161727 | 161727 | 2020-05-20 | Crawford | Missouri | 29055 | 8 | 0 |
158701 | 158701 | 2020-05-19 | Crawford | Missouri | 29055 | 8 | 0 |
155683 | 155683 | 2020-05-18 | Crawford | Missouri | 29055 | 9 | 0 |
152669 | 152669 | 2020-05-17 | Crawford | Missouri | 29055 | 9 | 0 |
149658 | 149658 | 2020-05-16 | Crawford | Missouri | 29055 | 8 | 0 |
146653 | 146653 | 2020-05-15 | Crawford | Missouri | 29055 | 8 | 0 |
143653 | 143653 | 2020-05-14 | Crawford | Missouri | 29055 | 8 | 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);