ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Washington" 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 |
---|---|---|---|---|---|---|---|
1055503 | 1055503 | 2021-02-22 | Washington | North Carolina | 37187 | 965 | 28 |
1052257 | 1052257 | 2021-02-21 | Washington | North Carolina | 37187 | 963 | 28 |
1049010 | 1049010 | 2021-02-20 | Washington | North Carolina | 37187 | 951 | 28 |
1045763 | 1045763 | 2021-02-19 | Washington | North Carolina | 37187 | 948 | 28 |
1042518 | 1042518 | 2021-02-18 | Washington | North Carolina | 37187 | 945 | 28 |
1039273 | 1039273 | 2021-02-17 | Washington | North Carolina | 37187 | 939 | 28 |
1036028 | 1036028 | 2021-02-16 | Washington | North Carolina | 37187 | 938 | 27 |
1032783 | 1032783 | 2021-02-15 | Washington | North Carolina | 37187 | 933 | 26 |
1029537 | 1029537 | 2021-02-14 | Washington | North Carolina | 37187 | 921 | 26 |
1026290 | 1026290 | 2021-02-13 | Washington | North Carolina | 37187 | 909 | 26 |
1023045 | 1023045 | 2021-02-12 | Washington | North Carolina | 37187 | 896 | 25 |
1019800 | 1019800 | 2021-02-11 | Washington | North Carolina | 37187 | 888 | 25 |
1016555 | 1016555 | 2021-02-10 | Washington | North Carolina | 37187 | 878 | 24 |
1013310 | 1013310 | 2021-02-09 | Washington | North Carolina | 37187 | 871 | 24 |
1010065 | 1010065 | 2021-02-08 | Washington | North Carolina | 37187 | 866 | 24 |
1006819 | 1006819 | 2021-02-07 | Washington | North Carolina | 37187 | 850 | 24 |
1003573 | 1003573 | 2021-02-06 | Washington | North Carolina | 37187 | 836 | 24 |
1000327 | 1000327 | 2021-02-05 | Washington | North Carolina | 37187 | 831 | 24 |
997081 | 997081 | 2021-02-04 | Washington | North Carolina | 37187 | 820 | 24 |
993835 | 993835 | 2021-02-03 | Washington | North Carolina | 37187 | 810 | 23 |
990589 | 990589 | 2021-02-02 | Washington | North Carolina | 37187 | 800 | 23 |
987343 | 987343 | 2021-02-01 | Washington | North Carolina | 37187 | 799 | 22 |
984096 | 984096 | 2021-01-31 | Washington | North Carolina | 37187 | 780 | 22 |
980849 | 980849 | 2021-01-30 | Washington | North Carolina | 37187 | 759 | 22 |
977603 | 977603 | 2021-01-29 | Washington | North Carolina | 37187 | 759 | 22 |
974358 | 974358 | 2021-01-28 | Washington | North Carolina | 37187 | 751 | 22 |
971113 | 971113 | 2021-01-27 | Washington | North Carolina | 37187 | 727 | 22 |
967868 | 967868 | 2021-01-26 | Washington | North Carolina | 37187 | 723 | 21 |
964624 | 964624 | 2021-01-25 | Washington | North Carolina | 37187 | 717 | 21 |
961379 | 961379 | 2021-01-24 | Washington | North Carolina | 37187 | 715 | 21 |
958134 | 958134 | 2021-01-23 | Washington | North Carolina | 37187 | 702 | 21 |
954888 | 954888 | 2021-01-22 | Washington | North Carolina | 37187 | 693 | 21 |
951643 | 951643 | 2021-01-21 | Washington | North Carolina | 37187 | 669 | 20 |
948398 | 948398 | 2021-01-20 | Washington | North Carolina | 37187 | 666 | 19 |
945152 | 945152 | 2021-01-19 | Washington | North Carolina | 37187 | 662 | 19 |
941905 | 941905 | 2021-01-18 | Washington | North Carolina | 37187 | 655 | 19 |
938660 | 938660 | 2021-01-17 | Washington | North Carolina | 37187 | 655 | 19 |
935415 | 935415 | 2021-01-16 | Washington | North Carolina | 37187 | 636 | 19 |
932170 | 932170 | 2021-01-15 | Washington | North Carolina | 37187 | 629 | 19 |
928925 | 928925 | 2021-01-14 | Washington | North Carolina | 37187 | 611 | 19 |
925680 | 925680 | 2021-01-13 | Washington | North Carolina | 37187 | 597 | 18 |
922434 | 922434 | 2021-01-12 | Washington | North Carolina | 37187 | 589 | 17 |
919189 | 919189 | 2021-01-11 | Washington | North Carolina | 37187 | 581 | 16 |
915944 | 915944 | 2021-01-10 | Washington | North Carolina | 37187 | 573 | 16 |
912699 | 912699 | 2021-01-09 | Washington | North Carolina | 37187 | 561 | 16 |
909454 | 909454 | 2021-01-08 | Washington | North Carolina | 37187 | 540 | 13 |
906209 | 906209 | 2021-01-07 | Washington | North Carolina | 37187 | 529 | 13 |
902963 | 902963 | 2021-01-06 | Washington | North Carolina | 37187 | 513 | 13 |
899718 | 899718 | 2021-01-05 | Washington | North Carolina | 37187 | 509 | 13 |
896473 | 896473 | 2021-01-04 | Washington | North Carolina | 37187 | 506 | 12 |
893227 | 893227 | 2021-01-03 | Washington | North Carolina | 37187 | 503 | 12 |
889981 | 889981 | 2021-01-02 | Washington | North Carolina | 37187 | 501 | 12 |
886734 | 886734 | 2021-01-01 | Washington | North Carolina | 37187 | 444 | 10 |
883489 | 883489 | 2020-12-31 | Washington | North Carolina | 37187 | 444 | 10 |
880244 | 880244 | 2020-12-30 | Washington | North Carolina | 37187 | 436 | 10 |
876999 | 876999 | 2020-12-29 | Washington | North Carolina | 37187 | 428 | 10 |
873754 | 873754 | 2020-12-28 | Washington | North Carolina | 37187 | 423 | 10 |
870509 | 870509 | 2020-12-27 | Washington | North Carolina | 37187 | 423 | 10 |
867264 | 867264 | 2020-12-26 | Washington | North Carolina | 37187 | 421 | 10 |
864019 | 864019 | 2020-12-25 | Washington | North Carolina | 37187 | 393 | 10 |
860774 | 860774 | 2020-12-24 | Washington | North Carolina | 37187 | 393 | 10 |
857529 | 857529 | 2020-12-23 | Washington | North Carolina | 37187 | 393 | 10 |
854284 | 854284 | 2020-12-22 | Washington | North Carolina | 37187 | 389 | 10 |
851039 | 851039 | 2020-12-21 | Washington | North Carolina | 37187 | 385 | 10 |
847794 | 847794 | 2020-12-20 | Washington | North Carolina | 37187 | 385 | 10 |
844549 | 844549 | 2020-12-19 | Washington | North Carolina | 37187 | 383 | 10 |
841303 | 841303 | 2020-12-18 | Washington | North Carolina | 37187 | 379 | 10 |
838058 | 838058 | 2020-12-17 | Washington | North Carolina | 37187 | 372 | 10 |
834812 | 834812 | 2020-12-16 | Washington | North Carolina | 37187 | 371 | 9 |
831566 | 831566 | 2020-12-15 | Washington | North Carolina | 37187 | 371 | 8 |
828319 | 828319 | 2020-12-14 | Washington | North Carolina | 37187 | 368 | 8 |
825073 | 825073 | 2020-12-13 | Washington | North Carolina | 37187 | 367 | 8 |
821826 | 821826 | 2020-12-12 | Washington | North Carolina | 37187 | 362 | 8 |
818580 | 818580 | 2020-12-11 | Washington | North Carolina | 37187 | 360 | 8 |
815334 | 815334 | 2020-12-10 | Washington | North Carolina | 37187 | 353 | 8 |
812089 | 812089 | 2020-12-09 | Washington | North Carolina | 37187 | 345 | 8 |
808844 | 808844 | 2020-12-08 | Washington | North Carolina | 37187 | 343 | 8 |
805599 | 805599 | 2020-12-07 | Washington | North Carolina | 37187 | 342 | 8 |
802354 | 802354 | 2020-12-06 | Washington | North Carolina | 37187 | 339 | 8 |
799109 | 799109 | 2020-12-05 | Washington | North Carolina | 37187 | 335 | 8 |
795864 | 795864 | 2020-12-04 | Washington | North Carolina | 37187 | 331 | 8 |
792619 | 792619 | 2020-12-03 | Washington | North Carolina | 37187 | 329 | 8 |
789374 | 789374 | 2020-12-02 | Washington | North Carolina | 37187 | 321 | 8 |
786129 | 786129 | 2020-12-01 | Washington | North Carolina | 37187 | 321 | 8 |
782885 | 782885 | 2020-11-30 | Washington | North Carolina | 37187 | 322 | 8 |
779639 | 779639 | 2020-11-29 | Washington | North Carolina | 37187 | 315 | 8 |
776394 | 776394 | 2020-11-28 | Washington | North Carolina | 37187 | 312 | 8 |
773149 | 773149 | 2020-11-27 | Washington | North Carolina | 37187 | 309 | 8 |
769904 | 769904 | 2020-11-26 | Washington | North Carolina | 37187 | 303 | 8 |
766658 | 766658 | 2020-11-25 | Washington | North Carolina | 37187 | 303 | 8 |
763413 | 763413 | 2020-11-24 | Washington | North Carolina | 37187 | 301 | 8 |
760168 | 760168 | 2020-11-23 | Washington | North Carolina | 37187 | 300 | 8 |
756922 | 756922 | 2020-11-22 | Washington | North Carolina | 37187 | 298 | 8 |
753675 | 753675 | 2020-11-21 | Washington | North Carolina | 37187 | 294 | 8 |
750429 | 750429 | 2020-11-20 | Washington | North Carolina | 37187 | 294 | 8 |
747183 | 747183 | 2020-11-19 | Washington | North Carolina | 37187 | 294 | 8 |
743937 | 743937 | 2020-11-18 | Washington | North Carolina | 37187 | 293 | 8 |
740690 | 740690 | 2020-11-17 | Washington | North Carolina | 37187 | 291 | 8 |
737445 | 737445 | 2020-11-16 | Washington | North Carolina | 37187 | 286 | 8 |
734201 | 734201 | 2020-11-15 | Washington | North Carolina | 37187 | 285 | 8 |
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);