ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" 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 |
---|---|---|---|---|---|---|---|
1052185 | 1052185 | 2021-02-21 | Clay | North Carolina | 37043 | 646 | 18 |
1048938 | 1048938 | 2021-02-20 | Clay | North Carolina | 37043 | 645 | 18 |
1045691 | 1045691 | 2021-02-19 | Clay | North Carolina | 37043 | 642 | 18 |
1042446 | 1042446 | 2021-02-18 | Clay | North Carolina | 37043 | 640 | 18 |
1039201 | 1039201 | 2021-02-17 | Clay | North Carolina | 37043 | 634 | 18 |
1035956 | 1035956 | 2021-02-16 | Clay | North Carolina | 37043 | 633 | 18 |
1032711 | 1032711 | 2021-02-15 | Clay | North Carolina | 37043 | 633 | 18 |
1029465 | 1029465 | 2021-02-14 | Clay | North Carolina | 37043 | 631 | 18 |
1026218 | 1026218 | 2021-02-13 | Clay | North Carolina | 37043 | 628 | 18 |
1022973 | 1022973 | 2021-02-12 | Clay | North Carolina | 37043 | 627 | 18 |
1019728 | 1019728 | 2021-02-11 | Clay | North Carolina | 37043 | 622 | 18 |
1016483 | 1016483 | 2021-02-10 | Clay | North Carolina | 37043 | 622 | 18 |
1013238 | 1013238 | 2021-02-09 | Clay | North Carolina | 37043 | 623 | 11 |
1009993 | 1009993 | 2021-02-08 | Clay | North Carolina | 37043 | 621 | 11 |
1006747 | 1006747 | 2021-02-07 | Clay | North Carolina | 37043 | 618 | 11 |
1003501 | 1003501 | 2021-02-06 | Clay | North Carolina | 37043 | 616 | 11 |
1000255 | 1000255 | 2021-02-05 | Clay | North Carolina | 37043 | 615 | 5 |
997009 | 997009 | 2021-02-04 | Clay | North Carolina | 37043 | 610 | 5 |
993763 | 993763 | 2021-02-03 | Clay | North Carolina | 37043 | 602 | 5 |
990517 | 990517 | 2021-02-02 | Clay | North Carolina | 37043 | 602 | 5 |
987271 | 987271 | 2021-02-01 | Clay | North Carolina | 37043 | 597 | 5 |
984024 | 984024 | 2021-01-31 | Clay | North Carolina | 37043 | 596 | 5 |
980777 | 980777 | 2021-01-30 | Clay | North Carolina | 37043 | 587 | 5 |
977531 | 977531 | 2021-01-29 | Clay | North Carolina | 37043 | 587 | 5 |
974286 | 974286 | 2021-01-28 | Clay | North Carolina | 37043 | 584 | 5 |
971041 | 971041 | 2021-01-27 | Clay | North Carolina | 37043 | 581 | 5 |
967796 | 967796 | 2021-01-26 | Clay | North Carolina | 37043 | 578 | 5 |
964552 | 964552 | 2021-01-25 | Clay | North Carolina | 37043 | 573 | 5 |
961307 | 961307 | 2021-01-24 | Clay | North Carolina | 37043 | 570 | 5 |
958062 | 958062 | 2021-01-23 | Clay | North Carolina | 37043 | 560 | 5 |
954816 | 954816 | 2021-01-22 | Clay | North Carolina | 37043 | 552 | 5 |
951571 | 951571 | 2021-01-21 | Clay | North Carolina | 37043 | 548 | 5 |
948326 | 948326 | 2021-01-20 | Clay | North Carolina | 37043 | 543 | 5 |
945079 | 945079 | 2021-01-19 | Clay | North Carolina | 37043 | 535 | 5 |
941833 | 941833 | 2021-01-18 | Clay | North Carolina | 37043 | 533 | 5 |
938588 | 938588 | 2021-01-17 | Clay | North Carolina | 37043 | 533 | 5 |
935343 | 935343 | 2021-01-16 | Clay | North Carolina | 37043 | 531 | 5 |
932098 | 932098 | 2021-01-15 | Clay | North Carolina | 37043 | 519 | 5 |
928853 | 928853 | 2021-01-14 | Clay | North Carolina | 37043 | 510 | 5 |
925608 | 925608 | 2021-01-13 | Clay | North Carolina | 37043 | 506 | 5 |
922362 | 922362 | 2021-01-12 | Clay | North Carolina | 37043 | 496 | 5 |
919117 | 919117 | 2021-01-11 | Clay | North Carolina | 37043 | 494 | 5 |
915872 | 915872 | 2021-01-10 | Clay | North Carolina | 37043 | 490 | 5 |
912627 | 912627 | 2021-01-09 | Clay | North Carolina | 37043 | 483 | 5 |
909382 | 909382 | 2021-01-08 | Clay | North Carolina | 37043 | 467 | 5 |
906137 | 906137 | 2021-01-07 | Clay | North Carolina | 37043 | 451 | 5 |
902891 | 902891 | 2021-01-06 | Clay | North Carolina | 37043 | 445 | 5 |
899646 | 899646 | 2021-01-05 | Clay | North Carolina | 37043 | 428 | 5 |
896401 | 896401 | 2021-01-04 | Clay | North Carolina | 37043 | 415 | 5 |
893155 | 893155 | 2021-01-03 | Clay | North Carolina | 37043 | 412 | 5 |
889909 | 889909 | 2021-01-02 | Clay | North Carolina | 37043 | 405 | 5 |
886662 | 886662 | 2021-01-01 | Clay | North Carolina | 37043 | 368 | 5 |
883417 | 883417 | 2020-12-31 | Clay | North Carolina | 37043 | 368 | 5 |
880172 | 880172 | 2020-12-30 | Clay | North Carolina | 37043 | 365 | 5 |
876927 | 876927 | 2020-12-29 | Clay | North Carolina | 37043 | 365 | 5 |
873682 | 873682 | 2020-12-28 | Clay | North Carolina | 37043 | 365 | 5 |
870437 | 870437 | 2020-12-27 | Clay | North Carolina | 37043 | 364 | 5 |
867192 | 867192 | 2020-12-26 | Clay | North Carolina | 37043 | 358 | 5 |
863947 | 863947 | 2020-12-25 | Clay | North Carolina | 37043 | 340 | 5 |
860702 | 860702 | 2020-12-24 | Clay | North Carolina | 37043 | 340 | 5 |
857457 | 857457 | 2020-12-23 | Clay | North Carolina | 37043 | 340 | 5 |
854212 | 854212 | 2020-12-22 | Clay | North Carolina | 37043 | 340 | 5 |
850967 | 850967 | 2020-12-21 | Clay | North Carolina | 37043 | 332 | 5 |
847722 | 847722 | 2020-12-20 | Clay | North Carolina | 37043 | 332 | 5 |
844477 | 844477 | 2020-12-19 | Clay | North Carolina | 37043 | 328 | 5 |
841231 | 841231 | 2020-12-18 | Clay | North Carolina | 37043 | 320 | 5 |
837986 | 837986 | 2020-12-17 | Clay | North Carolina | 37043 | 316 | 5 |
834740 | 834740 | 2020-12-16 | Clay | North Carolina | 37043 | 316 | 5 |
831494 | 831494 | 2020-12-15 | Clay | North Carolina | 37043 | 316 | 5 |
828247 | 828247 | 2020-12-14 | Clay | North Carolina | 37043 | 315 | 5 |
825001 | 825001 | 2020-12-13 | Clay | North Carolina | 37043 | 312 | 5 |
821754 | 821754 | 2020-12-12 | Clay | North Carolina | 37043 | 309 | 5 |
818508 | 818508 | 2020-12-11 | Clay | North Carolina | 37043 | 304 | 5 |
815262 | 815262 | 2020-12-10 | Clay | North Carolina | 37043 | 304 | 5 |
812017 | 812017 | 2020-12-09 | Clay | North Carolina | 37043 | 303 | 5 |
808772 | 808772 | 2020-12-08 | Clay | North Carolina | 37043 | 302 | 5 |
805527 | 805527 | 2020-12-07 | Clay | North Carolina | 37043 | 301 | 5 |
802282 | 802282 | 2020-12-06 | Clay | North Carolina | 37043 | 301 | 5 |
799037 | 799037 | 2020-12-05 | Clay | North Carolina | 37043 | 301 | 5 |
795792 | 795792 | 2020-12-04 | Clay | North Carolina | 37043 | 293 | 5 |
792547 | 792547 | 2020-12-03 | Clay | North Carolina | 37043 | 285 | 5 |
789302 | 789302 | 2020-12-02 | Clay | North Carolina | 37043 | 284 | 5 |
786057 | 786057 | 2020-12-01 | Clay | North Carolina | 37043 | 284 | 5 |
782813 | 782813 | 2020-11-30 | Clay | North Carolina | 37043 | 282 | 5 |
779567 | 779567 | 2020-11-29 | Clay | North Carolina | 37043 | 280 | 5 |
776322 | 776322 | 2020-11-28 | Clay | North Carolina | 37043 | 278 | 5 |
773077 | 773077 | 2020-11-27 | Clay | North Carolina | 37043 | 277 | 5 |
769832 | 769832 | 2020-11-26 | Clay | North Carolina | 37043 | 276 | 5 |
766586 | 766586 | 2020-11-25 | Clay | North Carolina | 37043 | 276 | 5 |
763341 | 763341 | 2020-11-24 | Clay | North Carolina | 37043 | 276 | 5 |
760096 | 760096 | 2020-11-23 | Clay | North Carolina | 37043 | 276 | 5 |
756850 | 756850 | 2020-11-22 | Clay | North Carolina | 37043 | 275 | 5 |
753603 | 753603 | 2020-11-21 | Clay | North Carolina | 37043 | 272 | 5 |
750357 | 750357 | 2020-11-20 | Clay | North Carolina | 37043 | 269 | 5 |
747111 | 747111 | 2020-11-19 | Clay | North Carolina | 37043 | 266 | 5 |
743865 | 743865 | 2020-11-18 | Clay | North Carolina | 37043 | 266 | 5 |
740618 | 740618 | 2020-11-17 | Clay | North Carolina | 37043 | 265 | 5 |
737373 | 737373 | 2020-11-16 | Clay | North Carolina | 37043 | 265 | 6 |
734129 | 734129 | 2020-11-15 | Clay | North Carolina | 37043 | 265 | 6 |
730883 | 730883 | 2020-11-14 | Clay | North Carolina | 37043 | 262 | 5 |
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);