ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Union" and fips = 28145 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636371 | 636371 | 2020-10-16 | Union | Mississippi | 28145 | 1119 | 25 |
633125 | 633125 | 2020-10-15 | Union | Mississippi | 28145 | 1106 | 25 |
629880 | 629880 | 2020-10-14 | Union | Mississippi | 28145 | 1102 | 24 |
626636 | 626636 | 2020-10-13 | Union | Mississippi | 28145 | 1098 | 24 |
623394 | 623394 | 2020-10-12 | Union | Mississippi | 28145 | 1089 | 24 |
620151 | 620151 | 2020-10-11 | Union | Mississippi | 28145 | 1087 | 24 |
616909 | 616909 | 2020-10-10 | Union | Mississippi | 28145 | 1087 | 24 |
613668 | 613668 | 2020-10-09 | Union | Mississippi | 28145 | 1073 | 24 |
610426 | 610426 | 2020-10-08 | Union | Mississippi | 28145 | 1068 | 24 |
607184 | 607184 | 2020-10-07 | Union | Mississippi | 28145 | 1065 | 24 |
603941 | 603941 | 2020-10-06 | Union | Mississippi | 28145 | 1062 | 24 |
600699 | 600699 | 2020-10-05 | Union | Mississippi | 28145 | 1049 | 24 |
597456 | 597456 | 2020-10-04 | Union | Mississippi | 28145 | 1046 | 24 |
594215 | 594215 | 2020-10-03 | Union | Mississippi | 28145 | 1043 | 24 |
590974 | 590974 | 2020-10-02 | Union | Mississippi | 28145 | 1029 | 24 |
587733 | 587733 | 2020-10-01 | Union | Mississippi | 28145 | 1013 | 24 |
584493 | 584493 | 2020-09-30 | Union | Mississippi | 28145 | 1012 | 24 |
581252 | 581252 | 2020-09-29 | Union | Mississippi | 28145 | 1002 | 24 |
578011 | 578011 | 2020-09-28 | Union | Mississippi | 28145 | 999 | 24 |
574770 | 574770 | 2020-09-27 | Union | Mississippi | 28145 | 998 | 24 |
571527 | 571527 | 2020-09-26 | Union | Mississippi | 28145 | 998 | 24 |
568285 | 568285 | 2020-09-25 | Union | Mississippi | 28145 | 997 | 24 |
565045 | 565045 | 2020-09-24 | Union | Mississippi | 28145 | 993 | 24 |
561805 | 561805 | 2020-09-23 | Union | Mississippi | 28145 | 988 | 24 |
558568 | 558568 | 2020-09-22 | Union | Mississippi | 28145 | 983 | 24 |
555331 | 555331 | 2020-09-21 | Union | Mississippi | 28145 | 978 | 24 |
552093 | 552093 | 2020-09-20 | Union | Mississippi | 28145 | 978 | 24 |
548854 | 548854 | 2020-09-19 | Union | Mississippi | 28145 | 978 | 24 |
545616 | 545616 | 2020-09-18 | Union | Mississippi | 28145 | 977 | 24 |
542379 | 542379 | 2020-09-17 | Union | Mississippi | 28145 | 965 | 24 |
539143 | 539143 | 2020-09-16 | Union | Mississippi | 28145 | 962 | 23 |
535906 | 535906 | 2020-09-15 | Union | Mississippi | 28145 | 957 | 23 |
532671 | 532671 | 2020-09-14 | Union | Mississippi | 28145 | 952 | 23 |
529435 | 529435 | 2020-09-13 | Union | Mississippi | 28145 | 952 | 23 |
526199 | 526199 | 2020-09-12 | Union | Mississippi | 28145 | 951 | 23 |
522963 | 522963 | 2020-09-11 | Union | Mississippi | 28145 | 943 | 23 |
519726 | 519726 | 2020-09-10 | Union | Mississippi | 28145 | 938 | 23 |
516491 | 516491 | 2020-09-09 | Union | Mississippi | 28145 | 927 | 23 |
513257 | 513257 | 2020-09-08 | Union | Mississippi | 28145 | 914 | 23 |
510025 | 510025 | 2020-09-07 | Union | Mississippi | 28145 | 912 | 23 |
506792 | 506792 | 2020-09-06 | Union | Mississippi | 28145 | 910 | 23 |
503559 | 503559 | 2020-09-05 | Union | Mississippi | 28145 | 909 | 23 |
500325 | 500325 | 2020-09-04 | Union | Mississippi | 28145 | 903 | 23 |
497091 | 497091 | 2020-09-03 | Union | Mississippi | 28145 | 899 | 23 |
493858 | 493858 | 2020-09-02 | Union | Mississippi | 28145 | 894 | 23 |
490624 | 490624 | 2020-09-01 | Union | Mississippi | 28145 | 887 | 23 |
487391 | 487391 | 2020-08-31 | Union | Mississippi | 28145 | 881 | 23 |
484157 | 484157 | 2020-08-30 | Union | Mississippi | 28145 | 878 | 21 |
480922 | 480922 | 2020-08-29 | Union | Mississippi | 28145 | 876 | 21 |
477690 | 477690 | 2020-08-28 | Union | Mississippi | 28145 | 867 | 21 |
474457 | 474457 | 2020-08-27 | Union | Mississippi | 28145 | 857 | 21 |
471225 | 471225 | 2020-08-26 | Union | Mississippi | 28145 | 849 | 21 |
467995 | 467995 | 2020-08-25 | Union | Mississippi | 28145 | 838 | 20 |
464766 | 464766 | 2020-08-24 | Union | Mississippi | 28145 | 826 | 20 |
461535 | 461535 | 2020-08-23 | Union | Mississippi | 28145 | 823 | 20 |
458308 | 458308 | 2020-08-22 | Union | Mississippi | 28145 | 821 | 20 |
455080 | 455080 | 2020-08-21 | Union | Mississippi | 28145 | 813 | 19 |
451852 | 451852 | 2020-08-20 | Union | Mississippi | 28145 | 802 | 19 |
448624 | 448624 | 2020-08-19 | Union | Mississippi | 28145 | 796 | 19 |
445398 | 445398 | 2020-08-18 | Union | Mississippi | 28145 | 780 | 19 |
442172 | 442172 | 2020-08-17 | Union | Mississippi | 28145 | 772 | 19 |
438945 | 438945 | 2020-08-16 | Union | Mississippi | 28145 | 763 | 19 |
435720 | 435720 | 2020-08-15 | Union | Mississippi | 28145 | 761 | 19 |
432494 | 432494 | 2020-08-14 | Union | Mississippi | 28145 | 750 | 17 |
429267 | 429267 | 2020-08-13 | Union | Mississippi | 28145 | 732 | 17 |
426043 | 426043 | 2020-08-12 | Union | Mississippi | 28145 | 700 | 17 |
422821 | 422821 | 2020-08-11 | Union | Mississippi | 28145 | 662 | 16 |
419599 | 419599 | 2020-08-10 | Union | Mississippi | 28145 | 643 | 16 |
416378 | 416378 | 2020-08-09 | Union | Mississippi | 28145 | 636 | 16 |
413158 | 413158 | 2020-08-08 | Union | Mississippi | 28145 | 627 | 16 |
409938 | 409938 | 2020-08-07 | Union | Mississippi | 28145 | 601 | 16 |
406718 | 406718 | 2020-08-06 | Union | Mississippi | 28145 | 562 | 15 |
403500 | 403500 | 2020-08-05 | Union | Mississippi | 28145 | 552 | 15 |
400283 | 400283 | 2020-08-04 | Union | Mississippi | 28145 | 538 | 14 |
397069 | 397069 | 2020-08-03 | Union | Mississippi | 28145 | 531 | 13 |
393853 | 393853 | 2020-08-02 | Union | Mississippi | 28145 | 519 | 13 |
390636 | 390636 | 2020-08-01 | Union | Mississippi | 28145 | 513 | 13 |
387419 | 387419 | 2020-07-31 | Union | Mississippi | 28145 | 503 | 13 |
384201 | 384201 | 2020-07-30 | Union | Mississippi | 28145 | 467 | 13 |
380984 | 380984 | 2020-07-29 | Union | Mississippi | 28145 | 452 | 13 |
377767 | 377767 | 2020-07-28 | Union | Mississippi | 28145 | 439 | 13 |
374552 | 374552 | 2020-07-27 | Union | Mississippi | 28145 | 410 | 13 |
371340 | 371340 | 2020-07-26 | Union | Mississippi | 28145 | 408 | 12 |
368130 | 368130 | 2020-07-25 | Union | Mississippi | 28145 | 402 | 12 |
364922 | 364922 | 2020-07-24 | Union | Mississippi | 28145 | 391 | 12 |
361715 | 361715 | 2020-07-23 | Union | Mississippi | 28145 | 374 | 11 |
358510 | 358510 | 2020-07-22 | Union | Mississippi | 28145 | 353 | 11 |
355307 | 355307 | 2020-07-21 | Union | Mississippi | 28145 | 338 | 11 |
352105 | 352105 | 2020-07-20 | Union | Mississippi | 28145 | 325 | 11 |
348905 | 348905 | 2020-07-19 | Union | Mississippi | 28145 | 323 | 11 |
345704 | 345704 | 2020-07-18 | Union | Mississippi | 28145 | 319 | 11 |
342504 | 342504 | 2020-07-17 | Union | Mississippi | 28145 | 307 | 11 |
339308 | 339308 | 2020-07-16 | Union | Mississippi | 28145 | 282 | 11 |
336112 | 336112 | 2020-07-15 | Union | Mississippi | 28145 | 266 | 11 |
332919 | 332919 | 2020-07-14 | Union | Mississippi | 28145 | 258 | 11 |
329732 | 329732 | 2020-07-13 | Union | Mississippi | 28145 | 256 | 12 |
326546 | 326546 | 2020-07-12 | Union | Mississippi | 28145 | 254 | 12 |
323363 | 323363 | 2020-07-11 | Union | Mississippi | 28145 | 252 | 11 |
320184 | 320184 | 2020-07-10 | Union | Mississippi | 28145 | 246 | 11 |
317009 | 317009 | 2020-07-09 | Union | Mississippi | 28145 | 238 | 11 |
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);