ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 5143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635067 | 635067 | 2020-10-16 | Washington | Arkansas | 5143 | 10748 | 131 |
631821 | 631821 | 2020-10-15 | Washington | Arkansas | 5143 | 10663 | 129 |
628577 | 628577 | 2020-10-14 | Washington | Arkansas | 5143 | 10552 | 129 |
625334 | 625334 | 2020-10-13 | Washington | Arkansas | 5143 | 10487 | 127 |
622091 | 622091 | 2020-10-12 | Washington | Arkansas | 5143 | 10442 | 127 |
618848 | 618848 | 2020-10-11 | Washington | Arkansas | 5143 | 10380 | 126 |
615606 | 615606 | 2020-10-10 | Washington | Arkansas | 5143 | 10353 | 123 |
612365 | 612365 | 2020-10-09 | Washington | Arkansas | 5143 | 10280 | 123 |
609123 | 609123 | 2020-10-08 | Washington | Arkansas | 5143 | 10171 | 122 |
605880 | 605880 | 2020-10-07 | Washington | Arkansas | 5143 | 10072 | 121 |
602638 | 602638 | 2020-10-06 | Washington | Arkansas | 5143 | 10030 | 120 |
599395 | 599395 | 2020-10-05 | Washington | Arkansas | 5143 | 9949 | 119 |
596152 | 596152 | 2020-10-04 | Washington | Arkansas | 5143 | 9899 | 118 |
592910 | 592910 | 2020-10-03 | Washington | Arkansas | 5143 | 9877 | 118 |
589670 | 589670 | 2020-10-02 | Washington | Arkansas | 5143 | 9809 | 118 |
586429 | 586429 | 2020-10-01 | Washington | Arkansas | 5143 | 9763 | 118 |
583189 | 583189 | 2020-09-30 | Washington | Arkansas | 5143 | 9645 | 118 |
579950 | 579950 | 2020-09-29 | Washington | Arkansas | 5143 | 9549 | 118 |
576709 | 576709 | 2020-09-28 | Washington | Arkansas | 5143 | 9457 | 118 |
573466 | 573466 | 2020-09-27 | Washington | Arkansas | 5143 | 9415 | 117 |
570224 | 570224 | 2020-09-26 | Washington | Arkansas | 5143 | 9379 | 115 |
566982 | 566982 | 2020-09-25 | Washington | Arkansas | 5143 | 9328 | 114 |
563742 | 563742 | 2020-09-24 | Washington | Arkansas | 5143 | 9250 | 112 |
560503 | 560503 | 2020-09-23 | Washington | Arkansas | 5143 | 9178 | 109 |
557267 | 557267 | 2020-09-22 | Washington | Arkansas | 5143 | 9103 | 108 |
554030 | 554030 | 2020-09-21 | Washington | Arkansas | 5143 | 9006 | 107 |
550791 | 550791 | 2020-09-20 | Washington | Arkansas | 5143 | 8950 | 107 |
547552 | 547552 | 2020-09-19 | Washington | Arkansas | 5143 | 8914 | 107 |
544314 | 544314 | 2020-09-18 | Washington | Arkansas | 5143 | 8697 | 106 |
541078 | 541078 | 2020-09-17 | Washington | Arkansas | 5143 | 8618 | 105 |
537841 | 537841 | 2020-09-16 | Washington | Arkansas | 5143 | 8512 | 105 |
534605 | 534605 | 2020-09-15 | Washington | Arkansas | 5143 | 8396 | 105 |
531370 | 531370 | 2020-09-14 | Washington | Arkansas | 5143 | 8244 | 89 |
528133 | 528133 | 2020-09-13 | Washington | Arkansas | 5143 | 8212 | 87 |
524897 | 524897 | 2020-09-12 | Washington | Arkansas | 5143 | 8194 | 85 |
521661 | 521661 | 2020-09-11 | Washington | Arkansas | 5143 | 7935 | 84 |
518424 | 518424 | 2020-09-10 | Washington | Arkansas | 5143 | 7822 | 82 |
515189 | 515189 | 2020-09-09 | Washington | Arkansas | 5143 | 7769 | 80 |
511956 | 511956 | 2020-09-08 | Washington | Arkansas | 5143 | 7703 | 80 |
508723 | 508723 | 2020-09-07 | Washington | Arkansas | 5143 | 7666 | 80 |
505491 | 505491 | 2020-09-06 | Washington | Arkansas | 5143 | 7639 | 79 |
502257 | 502257 | 2020-09-05 | Washington | Arkansas | 5143 | 7577 | 78 |
499023 | 499023 | 2020-09-04 | Washington | Arkansas | 5143 | 7429 | 78 |
495790 | 495790 | 2020-09-03 | Washington | Arkansas | 5143 | 7203 | 78 |
492556 | 492556 | 2020-09-02 | Washington | Arkansas | 5143 | 6991 | 73 |
489323 | 489323 | 2020-09-01 | Washington | Arkansas | 5143 | 6921 | 68 |
486090 | 486090 | 2020-08-31 | Washington | Arkansas | 5143 | 6900 | 65 |
482855 | 482855 | 2020-08-30 | Washington | Arkansas | 5143 | 6883 | 61 |
479621 | 479621 | 2020-08-29 | Washington | Arkansas | 5143 | 6850 | 58 |
476388 | 476388 | 2020-08-28 | Washington | Arkansas | 5143 | 6715 | 56 |
473155 | 473155 | 2020-08-27 | Washington | Arkansas | 5143 | 6673 | 55 |
469923 | 469923 | 2020-08-26 | Washington | Arkansas | 5143 | 6659 | 55 |
466694 | 466694 | 2020-08-25 | Washington | Arkansas | 5143 | 6631 | 55 |
463465 | 463465 | 2020-08-24 | Washington | Arkansas | 5143 | 6615 | 54 |
460236 | 460236 | 2020-08-23 | Washington | Arkansas | 5143 | 6610 | 54 |
457009 | 457009 | 2020-08-22 | Washington | Arkansas | 5143 | 6597 | 53 |
453781 | 453781 | 2020-08-21 | Washington | Arkansas | 5143 | 6582 | 53 |
450553 | 450553 | 2020-08-20 | Washington | Arkansas | 5143 | 6517 | 53 |
447325 | 447325 | 2020-08-19 | Washington | Arkansas | 5143 | 6507 | 53 |
444098 | 444098 | 2020-08-18 | Washington | Arkansas | 5143 | 6472 | 53 |
440872 | 440872 | 2020-08-17 | Washington | Arkansas | 5143 | 6442 | 53 |
437646 | 437646 | 2020-08-16 | Washington | Arkansas | 5143 | 6430 | 53 |
434420 | 434420 | 2020-08-15 | Washington | Arkansas | 5143 | 6400 | 53 |
431195 | 431195 | 2020-08-14 | Washington | Arkansas | 5143 | 6394 | 53 |
427967 | 427967 | 2020-08-13 | Washington | Arkansas | 5143 | 6373 | 53 |
424743 | 424743 | 2020-08-12 | Washington | Arkansas | 5143 | 6352 | 53 |
421522 | 421522 | 2020-08-11 | Washington | Arkansas | 5143 | 6321 | 52 |
418301 | 418301 | 2020-08-10 | Washington | Arkansas | 5143 | 6310 | 51 |
415080 | 415080 | 2020-08-09 | Washington | Arkansas | 5143 | 6298 | 52 |
411860 | 411860 | 2020-08-08 | Washington | Arkansas | 5143 | 6268 | 51 |
408641 | 408641 | 2020-08-07 | Washington | Arkansas | 5143 | 6231 | 51 |
405421 | 405421 | 2020-08-06 | Washington | Arkansas | 5143 | 6188 | 51 |
402203 | 402203 | 2020-08-05 | Washington | Arkansas | 5143 | 6168 | 50 |
398987 | 398987 | 2020-08-04 | Washington | Arkansas | 5143 | 6120 | 48 |
395771 | 395771 | 2020-08-03 | Washington | Arkansas | 5143 | 6072 | 47 |
392555 | 392555 | 2020-08-02 | Washington | Arkansas | 5143 | 6005 | 46 |
389338 | 389338 | 2020-08-01 | Washington | Arkansas | 5143 | 5952 | 46 |
386121 | 386121 | 2020-07-31 | Washington | Arkansas | 5143 | 5896 | 45 |
382903 | 382903 | 2020-07-30 | Washington | Arkansas | 5143 | 5855 | 43 |
379686 | 379686 | 2020-07-29 | Washington | Arkansas | 5143 | 5812 | 43 |
376470 | 376470 | 2020-07-28 | Washington | Arkansas | 5143 | 5783 | 42 |
373256 | 373256 | 2020-07-27 | Washington | Arkansas | 5143 | 5729 | 40 |
370044 | 370044 | 2020-07-26 | Washington | Arkansas | 5143 | 5662 | 40 |
366834 | 366834 | 2020-07-25 | Washington | Arkansas | 5143 | 5576 | 40 |
363627 | 363627 | 2020-07-24 | Washington | Arkansas | 5143 | 5536 | 40 |
360420 | 360420 | 2020-07-23 | Washington | Arkansas | 5143 | 5451 | 40 |
357215 | 357215 | 2020-07-22 | Washington | Arkansas | 5143 | 5350 | 39 |
354012 | 354012 | 2020-07-21 | Washington | Arkansas | 5143 | 5312 | 39 |
350810 | 350810 | 2020-07-20 | Washington | Arkansas | 5143 | 5234 | 38 |
347609 | 347609 | 2020-07-19 | Washington | Arkansas | 5143 | 5139 | 37 |
344409 | 344409 | 2020-07-18 | Washington | Arkansas | 5143 | 5059 | 37 |
341210 | 341210 | 2020-07-17 | Washington | Arkansas | 5143 | 4913 | 37 |
338014 | 338014 | 2020-07-16 | Washington | Arkansas | 5143 | 4860 | 37 |
334819 | 334819 | 2020-07-15 | Washington | Arkansas | 5143 | 4778 | 37 |
331626 | 331626 | 2020-07-14 | Washington | Arkansas | 5143 | 4721 | 37 |
328440 | 328440 | 2020-07-13 | Washington | Arkansas | 5143 | 4594 | 37 |
325254 | 325254 | 2020-07-12 | Washington | Arkansas | 5143 | 4526 | 36 |
322073 | 322073 | 2020-07-11 | Washington | Arkansas | 5143 | 4456 | 36 |
318894 | 318894 | 2020-07-10 | Washington | Arkansas | 5143 | 4344 | 36 |
315721 | 315721 | 2020-07-09 | Washington | Arkansas | 5143 | 4309 | 35 |
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);