ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Jefferson" and fips = 28063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947846 | 947846 | 2021-01-20 | Jefferson | Mississippi | 28063 | 554 | 19 |
944599 | 944599 | 2021-01-19 | Jefferson | Mississippi | 28063 | 549 | 19 |
941354 | 941354 | 2021-01-18 | Jefferson | Mississippi | 28063 | 543 | 19 |
938109 | 938109 | 2021-01-17 | Jefferson | Mississippi | 28063 | 538 | 19 |
934864 | 934864 | 2021-01-16 | Jefferson | Mississippi | 28063 | 534 | 19 |
931619 | 931619 | 2021-01-15 | Jefferson | Mississippi | 28063 | 530 | 19 |
928374 | 928374 | 2021-01-14 | Jefferson | Mississippi | 28063 | 520 | 19 |
925128 | 925128 | 2021-01-13 | Jefferson | Mississippi | 28063 | 514 | 19 |
921883 | 921883 | 2021-01-12 | Jefferson | Mississippi | 28063 | 512 | 18 |
918638 | 918638 | 2021-01-11 | Jefferson | Mississippi | 28063 | 511 | 18 |
915393 | 915393 | 2021-01-10 | Jefferson | Mississippi | 28063 | 508 | 17 |
912148 | 912148 | 2021-01-09 | Jefferson | Mississippi | 28063 | 504 | 17 |
908903 | 908903 | 2021-01-08 | Jefferson | Mississippi | 28063 | 494 | 17 |
905657 | 905657 | 2021-01-07 | Jefferson | Mississippi | 28063 | 491 | 16 |
902412 | 902412 | 2021-01-06 | Jefferson | Mississippi | 28063 | 487 | 16 |
899167 | 899167 | 2021-01-05 | Jefferson | Mississippi | 28063 | 472 | 16 |
895922 | 895922 | 2021-01-04 | Jefferson | Mississippi | 28063 | 469 | 14 |
892675 | 892675 | 2021-01-03 | Jefferson | Mississippi | 28063 | 469 | 14 |
889429 | 889429 | 2021-01-02 | Jefferson | Mississippi | 28063 | 469 | 14 |
886183 | 886183 | 2021-01-01 | Jefferson | Mississippi | 28063 | 467 | 14 |
882938 | 882938 | 2020-12-31 | Jefferson | Mississippi | 28063 | 466 | 14 |
879693 | 879693 | 2020-12-30 | Jefferson | Mississippi | 28063 | 465 | 14 |
876448 | 876448 | 2020-12-29 | Jefferson | Mississippi | 28063 | 461 | 14 |
873203 | 873203 | 2020-12-28 | Jefferson | Mississippi | 28063 | 460 | 14 |
869958 | 869958 | 2020-12-27 | Jefferson | Mississippi | 28063 | 459 | 14 |
866713 | 866713 | 2020-12-26 | Jefferson | Mississippi | 28063 | 458 | 14 |
863468 | 863468 | 2020-12-25 | Jefferson | Mississippi | 28063 | 458 | 14 |
860223 | 860223 | 2020-12-24 | Jefferson | Mississippi | 28063 | 458 | 14 |
856978 | 856978 | 2020-12-23 | Jefferson | Mississippi | 28063 | 457 | 14 |
853733 | 853733 | 2020-12-22 | Jefferson | Mississippi | 28063 | 455 | 13 |
850488 | 850488 | 2020-12-21 | Jefferson | Mississippi | 28063 | 453 | 13 |
847243 | 847243 | 2020-12-20 | Jefferson | Mississippi | 28063 | 450 | 13 |
843997 | 843997 | 2020-12-19 | Jefferson | Mississippi | 28063 | 447 | 13 |
840752 | 840752 | 2020-12-18 | Jefferson | Mississippi | 28063 | 445 | 12 |
837507 | 837507 | 2020-12-17 | Jefferson | Mississippi | 28063 | 434 | 12 |
834261 | 834261 | 2020-12-16 | Jefferson | Mississippi | 28063 | 432 | 12 |
831014 | 831014 | 2020-12-15 | Jefferson | Mississippi | 28063 | 428 | 12 |
827768 | 827768 | 2020-12-14 | Jefferson | Mississippi | 28063 | 424 | 12 |
824521 | 824521 | 2020-12-13 | Jefferson | Mississippi | 28063 | 418 | 12 |
821275 | 821275 | 2020-12-12 | Jefferson | Mississippi | 28063 | 411 | 12 |
818029 | 818029 | 2020-12-11 | Jefferson | Mississippi | 28063 | 407 | 12 |
814783 | 814783 | 2020-12-10 | Jefferson | Mississippi | 28063 | 403 | 12 |
811538 | 811538 | 2020-12-09 | Jefferson | Mississippi | 28063 | 398 | 12 |
808293 | 808293 | 2020-12-08 | Jefferson | Mississippi | 28063 | 398 | 12 |
805048 | 805048 | 2020-12-07 | Jefferson | Mississippi | 28063 | 396 | 12 |
801803 | 801803 | 2020-12-06 | Jefferson | Mississippi | 28063 | 395 | 12 |
798558 | 798558 | 2020-12-05 | Jefferson | Mississippi | 28063 | 393 | 12 |
795313 | 795313 | 2020-12-04 | Jefferson | Mississippi | 28063 | 390 | 12 |
792068 | 792068 | 2020-12-03 | Jefferson | Mississippi | 28063 | 387 | 12 |
788823 | 788823 | 2020-12-02 | Jefferson | Mississippi | 28063 | 383 | 12 |
785578 | 785578 | 2020-12-01 | Jefferson | Mississippi | 28063 | 371 | 12 |
782334 | 782334 | 2020-11-30 | Jefferson | Mississippi | 28063 | 364 | 11 |
779088 | 779088 | 2020-11-29 | Jefferson | Mississippi | 28063 | 357 | 11 |
775843 | 775843 | 2020-11-28 | Jefferson | Mississippi | 28063 | 352 | 11 |
772598 | 772598 | 2020-11-27 | Jefferson | Mississippi | 28063 | 348 | 11 |
769353 | 769353 | 2020-11-26 | Jefferson | Mississippi | 28063 | 347 | 11 |
766107 | 766107 | 2020-11-25 | Jefferson | Mississippi | 28063 | 342 | 11 |
762862 | 762862 | 2020-11-24 | Jefferson | Mississippi | 28063 | 338 | 11 |
759617 | 759617 | 2020-11-23 | Jefferson | Mississippi | 28063 | 340 | 11 |
756370 | 756370 | 2020-11-22 | Jefferson | Mississippi | 28063 | 335 | 11 |
753124 | 753124 | 2020-11-21 | Jefferson | Mississippi | 28063 | 335 | 11 |
749878 | 749878 | 2020-11-20 | Jefferson | Mississippi | 28063 | 332 | 11 |
746632 | 746632 | 2020-11-19 | Jefferson | Mississippi | 28063 | 328 | 11 |
743385 | 743385 | 2020-11-18 | Jefferson | Mississippi | 28063 | 306 | 11 |
740138 | 740138 | 2020-11-17 | Jefferson | Mississippi | 28063 | 302 | 11 |
736894 | 736894 | 2020-11-16 | Jefferson | Mississippi | 28063 | 301 | 11 |
733648 | 733648 | 2020-11-15 | Jefferson | Mississippi | 28063 | 299 | 11 |
730403 | 730403 | 2020-11-14 | Jefferson | Mississippi | 28063 | 298 | 11 |
727160 | 727160 | 2020-11-13 | Jefferson | Mississippi | 28063 | 298 | 11 |
723917 | 723917 | 2020-11-12 | Jefferson | Mississippi | 28063 | 298 | 11 |
720674 | 720674 | 2020-11-11 | Jefferson | Mississippi | 28063 | 293 | 11 |
717431 | 717431 | 2020-11-10 | Jefferson | Mississippi | 28063 | 293 | 11 |
714187 | 714187 | 2020-11-09 | Jefferson | Mississippi | 28063 | 293 | 11 |
710943 | 710943 | 2020-11-08 | Jefferson | Mississippi | 28063 | 292 | 11 |
707699 | 707699 | 2020-11-07 | Jefferson | Mississippi | 28063 | 292 | 11 |
704456 | 704456 | 2020-11-06 | Jefferson | Mississippi | 28063 | 291 | 11 |
701214 | 701214 | 2020-11-05 | Jefferson | Mississippi | 28063 | 288 | 11 |
697970 | 697970 | 2020-11-04 | Jefferson | Mississippi | 28063 | 286 | 11 |
694727 | 694727 | 2020-11-03 | Jefferson | Mississippi | 28063 | 287 | 11 |
691485 | 691485 | 2020-11-02 | Jefferson | Mississippi | 28063 | 287 | 10 |
688240 | 688240 | 2020-11-01 | Jefferson | Mississippi | 28063 | 287 | 10 |
684996 | 684996 | 2020-10-31 | Jefferson | Mississippi | 28063 | 287 | 10 |
681753 | 681753 | 2020-10-30 | Jefferson | Mississippi | 28063 | 284 | 10 |
678509 | 678509 | 2020-10-29 | Jefferson | Mississippi | 28063 | 281 | 10 |
675267 | 675267 | 2020-10-28 | Jefferson | Mississippi | 28063 | 279 | 10 |
672024 | 672024 | 2020-10-27 | Jefferson | Mississippi | 28063 | 277 | 10 |
668782 | 668782 | 2020-10-26 | Jefferson | Mississippi | 28063 | 277 | 10 |
665538 | 665538 | 2020-10-25 | Jefferson | Mississippi | 28063 | 276 | 10 |
662293 | 662293 | 2020-10-24 | Jefferson | Mississippi | 28063 | 276 | 10 |
659049 | 659049 | 2020-10-23 | Jefferson | Mississippi | 28063 | 275 | 10 |
655804 | 655804 | 2020-10-22 | Jefferson | Mississippi | 28063 | 274 | 10 |
652559 | 652559 | 2020-10-21 | Jefferson | Mississippi | 28063 | 271 | 10 |
649314 | 649314 | 2020-10-20 | Jefferson | Mississippi | 28063 | 270 | 10 |
646070 | 646070 | 2020-10-19 | Jefferson | Mississippi | 28063 | 263 | 10 |
642823 | 642823 | 2020-10-18 | Jefferson | Mississippi | 28063 | 262 | 10 |
639576 | 639576 | 2020-10-17 | Jefferson | Mississippi | 28063 | 262 | 10 |
636330 | 636330 | 2020-10-16 | Jefferson | Mississippi | 28063 | 259 | 10 |
633084 | 633084 | 2020-10-15 | Jefferson | Mississippi | 28063 | 256 | 10 |
629839 | 629839 | 2020-10-14 | Jefferson | Mississippi | 28063 | 255 | 10 |
626595 | 626595 | 2020-10-13 | Jefferson | Mississippi | 28063 | 255 | 10 |
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);