ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and state = "Missouri" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
313872 | 313872 | 2020-07-08 | Crawford | Missouri | 29055 | 19 | 0 |
317046 | 317046 | 2020-07-09 | Crawford | Missouri | 29055 | 19 | 0 |
320221 | 320221 | 2020-07-10 | Crawford | Missouri | 29055 | 21 | 0 |
323400 | 323400 | 2020-07-11 | Crawford | Missouri | 29055 | 21 | 0 |
326583 | 326583 | 2020-07-12 | Crawford | Missouri | 29055 | 22 | 0 |
329769 | 329769 | 2020-07-13 | Crawford | Missouri | 29055 | 22 | 0 |
332956 | 332956 | 2020-07-14 | Crawford | Missouri | 29055 | 23 | 0 |
336149 | 336149 | 2020-07-15 | Crawford | Missouri | 29055 | 24 | 0 |
339345 | 339345 | 2020-07-16 | Crawford | Missouri | 29055 | 26 | 0 |
342541 | 342541 | 2020-07-17 | Crawford | Missouri | 29055 | 27 | 0 |
345741 | 345741 | 2020-07-18 | Crawford | Missouri | 29055 | 28 | 0 |
348942 | 348942 | 2020-07-19 | Crawford | Missouri | 29055 | 28 | 0 |
352142 | 352142 | 2020-07-20 | Crawford | Missouri | 29055 | 28 | 0 |
355344 | 355344 | 2020-07-21 | Crawford | Missouri | 29055 | 30 | 0 |
358547 | 358547 | 2020-07-22 | Crawford | Missouri | 29055 | 31 | 0 |
361752 | 361752 | 2020-07-23 | Crawford | Missouri | 29055 | 32 | 0 |
364959 | 364959 | 2020-07-24 | Crawford | Missouri | 29055 | 32 | 0 |
368167 | 368167 | 2020-07-25 | Crawford | Missouri | 29055 | 33 | 0 |
371378 | 371378 | 2020-07-26 | Crawford | Missouri | 29055 | 34 | 0 |
374590 | 374590 | 2020-07-27 | Crawford | Missouri | 29055 | 35 | 0 |
377805 | 377805 | 2020-07-28 | Crawford | Missouri | 29055 | 33 | 0 |
381022 | 381022 | 2020-07-29 | Crawford | Missouri | 29055 | 36 | 0 |
384238 | 384238 | 2020-07-30 | Crawford | Missouri | 29055 | 40 | 0 |
387456 | 387456 | 2020-07-31 | Crawford | Missouri | 29055 | 47 | 0 |
390673 | 390673 | 2020-08-01 | Crawford | Missouri | 29055 | 52 | 0 |
393890 | 393890 | 2020-08-02 | Crawford | Missouri | 29055 | 56 | 0 |
397106 | 397106 | 2020-08-03 | Crawford | Missouri | 29055 | 57 | 0 |
400320 | 400320 | 2020-08-04 | Crawford | Missouri | 29055 | 58 | 0 |
403537 | 403537 | 2020-08-05 | Crawford | Missouri | 29055 | 62 | 0 |
406755 | 406755 | 2020-08-06 | Crawford | Missouri | 29055 | 69 | 0 |
409975 | 409975 | 2020-08-07 | Crawford | Missouri | 29055 | 71 | 0 |
413195 | 413195 | 2020-08-08 | Crawford | Missouri | 29055 | 71 | 0 |
416415 | 416415 | 2020-08-09 | Crawford | Missouri | 29055 | 73 | 0 |
419636 | 419636 | 2020-08-10 | Crawford | Missouri | 29055 | 78 | 0 |
422858 | 422858 | 2020-08-11 | Crawford | Missouri | 29055 | 79 | 0 |
426080 | 426080 | 2020-08-12 | Crawford | Missouri | 29055 | 83 | 0 |
429304 | 429304 | 2020-08-13 | Crawford | Missouri | 29055 | 90 | 0 |
432531 | 432531 | 2020-08-14 | Crawford | Missouri | 29055 | 97 | 0 |
435757 | 435757 | 2020-08-15 | Crawford | Missouri | 29055 | 102 | 0 |
438982 | 438982 | 2020-08-16 | Crawford | Missouri | 29055 | 111 | 0 |
442209 | 442209 | 2020-08-17 | Crawford | Missouri | 29055 | 115 | 0 |
445435 | 445435 | 2020-08-18 | Crawford | Missouri | 29055 | 115 | 0 |
448661 | 448661 | 2020-08-19 | Crawford | Missouri | 29055 | 121 | 0 |
451889 | 451889 | 2020-08-20 | Crawford | Missouri | 29055 | 126 | 0 |
455117 | 455117 | 2020-08-21 | Crawford | Missouri | 29055 | 132 | 0 |
458345 | 458345 | 2020-08-22 | Crawford | Missouri | 29055 | 137 | 1 |
461572 | 461572 | 2020-08-23 | Crawford | Missouri | 29055 | 141 | 1 |
464803 | 464803 | 2020-08-24 | Crawford | Missouri | 29055 | 146 | 1 |
468032 | 468032 | 2020-08-25 | Crawford | Missouri | 29055 | 148 | 1 |
471262 | 471262 | 2020-08-26 | Crawford | Missouri | 29055 | 159 | 1 |
474494 | 474494 | 2020-08-27 | Crawford | Missouri | 29055 | 164 | 1 |
477727 | 477727 | 2020-08-28 | Crawford | Missouri | 29055 | 175 | 1 |
480959 | 480959 | 2020-08-29 | Crawford | Missouri | 29055 | 178 | 1 |
484194 | 484194 | 2020-08-30 | Crawford | Missouri | 29055 | 179 | 1 |
487428 | 487428 | 2020-08-31 | Crawford | Missouri | 29055 | 186 | 1 |
490661 | 490661 | 2020-09-01 | Crawford | Missouri | 29055 | 193 | 1 |
493895 | 493895 | 2020-09-02 | Crawford | Missouri | 29055 | 198 | 1 |
497128 | 497128 | 2020-09-03 | Crawford | Missouri | 29055 | 209 | 1 |
500362 | 500362 | 2020-09-04 | Crawford | Missouri | 29055 | 215 | 1 |
503596 | 503596 | 2020-09-05 | Crawford | Missouri | 29055 | 219 | 1 |
506829 | 506829 | 2020-09-06 | Crawford | Missouri | 29055 | 217 | 2 |
510062 | 510062 | 2020-09-07 | Crawford | Missouri | 29055 | 220 | 2 |
513294 | 513294 | 2020-09-08 | Crawford | Missouri | 29055 | 218 | 2 |
516528 | 516528 | 2020-09-09 | Crawford | Missouri | 29055 | 221 | 2 |
519763 | 519763 | 2020-09-10 | Crawford | Missouri | 29055 | 225 | 2 |
523000 | 523000 | 2020-09-11 | Crawford | Missouri | 29055 | 231 | 2 |
526236 | 526236 | 2020-09-12 | Crawford | Missouri | 29055 | 242 | 2 |
529472 | 529472 | 2020-09-13 | Crawford | Missouri | 29055 | 249 | 2 |
532708 | 532708 | 2020-09-14 | Crawford | Missouri | 29055 | 280 | 2 |
535943 | 535943 | 2020-09-15 | Crawford | Missouri | 29055 | 294 | 2 |
539180 | 539180 | 2020-09-16 | Crawford | Missouri | 29055 | 307 | 2 |
542416 | 542416 | 2020-09-17 | Crawford | Missouri | 29055 | 330 | 2 |
545653 | 545653 | 2020-09-18 | Crawford | Missouri | 29055 | 339 | 2 |
548891 | 548891 | 2020-09-19 | Crawford | Missouri | 29055 | 345 | 2 |
552130 | 552130 | 2020-09-20 | Crawford | Missouri | 29055 | 349 | 2 |
555368 | 555368 | 2020-09-21 | Crawford | Missouri | 29055 | 361 | 2 |
558605 | 558605 | 2020-09-22 | Crawford | Missouri | 29055 | 362 | 2 |
561842 | 561842 | 2020-09-23 | Crawford | Missouri | 29055 | 369 | 4 |
565082 | 565082 | 2020-09-24 | Crawford | Missouri | 29055 | 388 | 4 |
568322 | 568322 | 2020-09-25 | Crawford | Missouri | 29055 | 391 | 4 |
571564 | 571564 | 2020-09-26 | Crawford | Missouri | 29055 | 397 | 4 |
574807 | 574807 | 2020-09-27 | Crawford | Missouri | 29055 | 402 | 4 |
578048 | 578048 | 2020-09-28 | Crawford | Missouri | 29055 | 407 | 4 |
581289 | 581289 | 2020-09-29 | Crawford | Missouri | 29055 | 407 | 4 |
584530 | 584530 | 2020-09-30 | Crawford | Missouri | 29055 | 402 | 5 |
587770 | 587770 | 2020-10-01 | Crawford | Missouri | 29055 | 416 | 5 |
591011 | 591011 | 2020-10-02 | Crawford | Missouri | 29055 | 417 | 5 |
594252 | 594252 | 2020-10-03 | Crawford | Missouri | 29055 | 421 | 5 |
597493 | 597493 | 2020-10-04 | Crawford | Missouri | 29055 | 425 | 5 |
600736 | 600736 | 2020-10-05 | Crawford | Missouri | 29055 | 426 | 5 |
603978 | 603978 | 2020-10-06 | Crawford | Missouri | 29055 | 432 | 5 |
607221 | 607221 | 2020-10-07 | Crawford | Missouri | 29055 | 434 | 5 |
610463 | 610463 | 2020-10-08 | Crawford | Missouri | 29055 | 443 | 5 |
613705 | 613705 | 2020-10-09 | Crawford | Missouri | 29055 | 451 | 7 |
616946 | 616946 | 2020-10-10 | Crawford | Missouri | 29055 | 481 | 7 |
620188 | 620188 | 2020-10-11 | Crawford | Missouri | 29055 | 481 | 7 |
623431 | 623431 | 2020-10-12 | Crawford | Missouri | 29055 | 481 | 7 |
626673 | 626673 | 2020-10-13 | Crawford | Missouri | 29055 | 481 | 7 |
629917 | 629917 | 2020-10-14 | Crawford | Missouri | 29055 | 500 | 6 |
633162 | 633162 | 2020-10-15 | Crawford | Missouri | 29055 | 511 | 6 |
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);