ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Madison" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922397 | 922397 | 2021-01-12 | Madison | North Carolina | 37115 | 983 | 21 |
919152 | 919152 | 2021-01-11 | Madison | North Carolina | 37115 | 977 | 20 |
915907 | 915907 | 2021-01-10 | Madison | North Carolina | 37115 | 968 | 20 |
912662 | 912662 | 2021-01-09 | Madison | North Carolina | 37115 | 949 | 20 |
909417 | 909417 | 2021-01-08 | Madison | North Carolina | 37115 | 926 | 20 |
906172 | 906172 | 2021-01-07 | Madison | North Carolina | 37115 | 897 | 20 |
902926 | 902926 | 2021-01-06 | Madison | North Carolina | 37115 | 880 | 20 |
899681 | 899681 | 2021-01-05 | Madison | North Carolina | 37115 | 867 | 19 |
896436 | 896436 | 2021-01-04 | Madison | North Carolina | 37115 | 865 | 19 |
893190 | 893190 | 2021-01-03 | Madison | North Carolina | 37115 | 848 | 19 |
889944 | 889944 | 2021-01-02 | Madison | North Carolina | 37115 | 838 | 19 |
886697 | 886697 | 2021-01-01 | Madison | North Carolina | 37115 | 797 | 19 |
883452 | 883452 | 2020-12-31 | Madison | North Carolina | 37115 | 797 | 19 |
880207 | 880207 | 2020-12-30 | Madison | North Carolina | 37115 | 793 | 19 |
876962 | 876962 | 2020-12-29 | Madison | North Carolina | 37115 | 789 | 19 |
873717 | 873717 | 2020-12-28 | Madison | North Carolina | 37115 | 785 | 19 |
870472 | 870472 | 2020-12-27 | Madison | North Carolina | 37115 | 779 | 19 |
867227 | 867227 | 2020-12-26 | Madison | North Carolina | 37115 | 776 | 19 |
863982 | 863982 | 2020-12-25 | Madison | North Carolina | 37115 | 740 | 19 |
860737 | 860737 | 2020-12-24 | Madison | North Carolina | 37115 | 740 | 19 |
857492 | 857492 | 2020-12-23 | Madison | North Carolina | 37115 | 740 | 19 |
854247 | 854247 | 2020-12-22 | Madison | North Carolina | 37115 | 735 | 19 |
851002 | 851002 | 2020-12-21 | Madison | North Carolina | 37115 | 729 | 19 |
847757 | 847757 | 2020-12-20 | Madison | North Carolina | 37115 | 724 | 19 |
844512 | 844512 | 2020-12-19 | Madison | North Carolina | 37115 | 721 | 18 |
841266 | 841266 | 2020-12-18 | Madison | North Carolina | 37115 | 707 | 18 |
838021 | 838021 | 2020-12-17 | Madison | North Carolina | 37115 | 694 | 18 |
834775 | 834775 | 2020-12-16 | Madison | North Carolina | 37115 | 681 | 17 |
831529 | 831529 | 2020-12-15 | Madison | North Carolina | 37115 | 681 | 17 |
828282 | 828282 | 2020-12-14 | Madison | North Carolina | 37115 | 668 | 17 |
825036 | 825036 | 2020-12-13 | Madison | North Carolina | 37115 | 659 | 17 |
821789 | 821789 | 2020-12-12 | Madison | North Carolina | 37115 | 641 | 17 |
818543 | 818543 | 2020-12-11 | Madison | North Carolina | 37115 | 638 | 17 |
815297 | 815297 | 2020-12-10 | Madison | North Carolina | 37115 | 617 | 17 |
812052 | 812052 | 2020-12-09 | Madison | North Carolina | 37115 | 611 | 17 |
808807 | 808807 | 2020-12-08 | Madison | North Carolina | 37115 | 607 | 17 |
805562 | 805562 | 2020-12-07 | Madison | North Carolina | 37115 | 593 | 17 |
802317 | 802317 | 2020-12-06 | Madison | North Carolina | 37115 | 582 | 17 |
799072 | 799072 | 2020-12-05 | Madison | North Carolina | 37115 | 573 | 17 |
795827 | 795827 | 2020-12-04 | Madison | North Carolina | 37115 | 564 | 17 |
792582 | 792582 | 2020-12-03 | Madison | North Carolina | 37115 | 555 | 17 |
789337 | 789337 | 2020-12-02 | Madison | North Carolina | 37115 | 545 | 17 |
786092 | 786092 | 2020-12-01 | Madison | North Carolina | 37115 | 536 | 17 |
782848 | 782848 | 2020-11-30 | Madison | North Carolina | 37115 | 530 | 17 |
779602 | 779602 | 2020-11-29 | Madison | North Carolina | 37115 | 525 | 17 |
776357 | 776357 | 2020-11-28 | Madison | North Carolina | 37115 | 516 | 17 |
773112 | 773112 | 2020-11-27 | Madison | North Carolina | 37115 | 505 | 17 |
769867 | 769867 | 2020-11-26 | Madison | North Carolina | 37115 | 493 | 17 |
766621 | 766621 | 2020-11-25 | Madison | North Carolina | 37115 | 493 | 17 |
763376 | 763376 | 2020-11-24 | Madison | North Carolina | 37115 | 475 | 7 |
760131 | 760131 | 2020-11-23 | Madison | North Carolina | 37115 | 464 | 7 |
756885 | 756885 | 2020-11-22 | Madison | North Carolina | 37115 | 457 | 7 |
753638 | 753638 | 2020-11-21 | Madison | North Carolina | 37115 | 440 | 7 |
750392 | 750392 | 2020-11-20 | Madison | North Carolina | 37115 | 428 | 7 |
747146 | 747146 | 2020-11-19 | Madison | North Carolina | 37115 | 411 | 7 |
743900 | 743900 | 2020-11-18 | Madison | North Carolina | 37115 | 403 | 7 |
740653 | 740653 | 2020-11-17 | Madison | North Carolina | 37115 | 399 | 7 |
737408 | 737408 | 2020-11-16 | Madison | North Carolina | 37115 | 395 | 7 |
734164 | 734164 | 2020-11-15 | Madison | North Carolina | 37115 | 390 | 7 |
730918 | 730918 | 2020-11-14 | Madison | North Carolina | 37115 | 376 | 7 |
727674 | 727674 | 2020-11-13 | Madison | North Carolina | 37115 | 364 | 7 |
724430 | 724430 | 2020-11-12 | Madison | North Carolina | 37115 | 359 | 7 |
721187 | 721187 | 2020-11-11 | Madison | North Carolina | 37115 | 352 | 7 |
717944 | 717944 | 2020-11-10 | Madison | North Carolina | 37115 | 351 | 7 |
714701 | 714701 | 2020-11-09 | Madison | North Carolina | 37115 | 342 | 7 |
711457 | 711457 | 2020-11-08 | Madison | North Carolina | 37115 | 336 | 7 |
708213 | 708213 | 2020-11-07 | Madison | North Carolina | 37115 | 334 | 7 |
704970 | 704970 | 2020-11-06 | Madison | North Carolina | 37115 | 332 | 5 |
701727 | 701727 | 2020-11-05 | Madison | North Carolina | 37115 | 321 | 5 |
698483 | 698483 | 2020-11-04 | Madison | North Carolina | 37115 | 311 | 5 |
695240 | 695240 | 2020-11-03 | Madison | North Carolina | 37115 | 309 | 5 |
691998 | 691998 | 2020-11-02 | Madison | North Carolina | 37115 | 304 | 5 |
688754 | 688754 | 2020-11-01 | Madison | North Carolina | 37115 | 303 | 5 |
685509 | 685509 | 2020-10-31 | Madison | North Carolina | 37115 | 295 | 5 |
682266 | 682266 | 2020-10-30 | Madison | North Carolina | 37115 | 281 | 1 |
679023 | 679023 | 2020-10-29 | Madison | North Carolina | 37115 | 247 | 1 |
675780 | 675780 | 2020-10-28 | Madison | North Carolina | 37115 | 246 | 1 |
672537 | 672537 | 2020-10-27 | Madison | North Carolina | 37115 | 244 | 1 |
669295 | 669295 | 2020-10-26 | Madison | North Carolina | 37115 | 218 | 1 |
666051 | 666051 | 2020-10-25 | Madison | North Carolina | 37115 | 208 | 1 |
662806 | 662806 | 2020-10-24 | Madison | North Carolina | 37115 | 208 | 1 |
659562 | 659562 | 2020-10-23 | Madison | North Carolina | 37115 | 198 | 1 |
656318 | 656318 | 2020-10-22 | Madison | North Carolina | 37115 | 192 | 1 |
653073 | 653073 | 2020-10-21 | Madison | North Carolina | 37115 | 161 | 1 |
649828 | 649828 | 2020-10-20 | Madison | North Carolina | 37115 | 159 | 1 |
646584 | 646584 | 2020-10-19 | Madison | North Carolina | 37115 | 154 | 1 |
643338 | 643338 | 2020-10-18 | Madison | North Carolina | 37115 | 149 | 1 |
640090 | 640090 | 2020-10-17 | Madison | North Carolina | 37115 | 140 | 1 |
636844 | 636844 | 2020-10-16 | Madison | North Carolina | 37115 | 135 | 1 |
633598 | 633598 | 2020-10-15 | Madison | North Carolina | 37115 | 134 | 1 |
630353 | 630353 | 2020-10-14 | Madison | North Carolina | 37115 | 131 | 1 |
627109 | 627109 | 2020-10-13 | Madison | North Carolina | 37115 | 130 | 1 |
623867 | 623867 | 2020-10-12 | Madison | North Carolina | 37115 | 130 | 1 |
620624 | 620624 | 2020-10-11 | Madison | North Carolina | 37115 | 130 | 1 |
617382 | 617382 | 2020-10-10 | Madison | North Carolina | 37115 | 129 | 1 |
614140 | 614140 | 2020-10-09 | Madison | North Carolina | 37115 | 127 | 1 |
610899 | 610899 | 2020-10-08 | Madison | North Carolina | 37115 | 123 | 1 |
607657 | 607657 | 2020-10-07 | Madison | North Carolina | 37115 | 121 | 1 |
604414 | 604414 | 2020-10-06 | Madison | North Carolina | 37115 | 120 | 1 |
601172 | 601172 | 2020-10-05 | Madison | North Carolina | 37115 | 118 | 1 |
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);