ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Washington" and fips = 37187 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
730955 | 730955 | 2020-11-14 | Washington | North Carolina | 37187 | 283 | 8 |
727711 | 727711 | 2020-11-13 | Washington | North Carolina | 37187 | 282 | 8 |
724467 | 724467 | 2020-11-12 | Washington | North Carolina | 37187 | 281 | 8 |
721224 | 721224 | 2020-11-11 | Washington | North Carolina | 37187 | 279 | 8 |
717981 | 717981 | 2020-11-10 | Washington | North Carolina | 37187 | 279 | 8 |
714738 | 714738 | 2020-11-09 | Washington | North Carolina | 37187 | 278 | 8 |
711494 | 711494 | 2020-11-08 | Washington | North Carolina | 37187 | 277 | 8 |
708250 | 708250 | 2020-11-07 | Washington | North Carolina | 37187 | 275 | 8 |
705007 | 705007 | 2020-11-06 | Washington | North Carolina | 37187 | 274 | 8 |
701764 | 701764 | 2020-11-05 | Washington | North Carolina | 37187 | 273 | 8 |
698520 | 698520 | 2020-11-04 | Washington | North Carolina | 37187 | 273 | 8 |
695277 | 695277 | 2020-11-03 | Washington | North Carolina | 37187 | 273 | 8 |
692035 | 692035 | 2020-11-02 | Washington | North Carolina | 37187 | 271 | 8 |
688791 | 688791 | 2020-11-01 | Washington | North Carolina | 37187 | 264 | 8 |
685546 | 685546 | 2020-10-31 | Washington | North Carolina | 37187 | 264 | 8 |
682303 | 682303 | 2020-10-30 | Washington | North Carolina | 37187 | 258 | 8 |
679060 | 679060 | 2020-10-29 | Washington | North Carolina | 37187 | 253 | 8 |
675817 | 675817 | 2020-10-28 | Washington | North Carolina | 37187 | 250 | 8 |
672574 | 672574 | 2020-10-27 | Washington | North Carolina | 37187 | 250 | 8 |
669332 | 669332 | 2020-10-26 | Washington | North Carolina | 37187 | 246 | 8 |
666088 | 666088 | 2020-10-25 | Washington | North Carolina | 37187 | 244 | 8 |
662843 | 662843 | 2020-10-24 | Washington | North Carolina | 37187 | 243 | 8 |
659599 | 659599 | 2020-10-23 | Washington | North Carolina | 37187 | 241 | 8 |
656355 | 656355 | 2020-10-22 | Washington | North Carolina | 37187 | 239 | 8 |
653110 | 653110 | 2020-10-21 | Washington | North Carolina | 37187 | 238 | 8 |
649865 | 649865 | 2020-10-20 | Washington | North Carolina | 37187 | 238 | 8 |
646621 | 646621 | 2020-10-19 | Washington | North Carolina | 37187 | 236 | 8 |
643375 | 643375 | 2020-10-18 | Washington | North Carolina | 37187 | 237 | 8 |
640127 | 640127 | 2020-10-17 | Washington | North Carolina | 37187 | 237 | 8 |
636881 | 636881 | 2020-10-16 | Washington | North Carolina | 37187 | 236 | 8 |
633635 | 633635 | 2020-10-15 | Washington | North Carolina | 37187 | 232 | 8 |
630390 | 630390 | 2020-10-14 | Washington | North Carolina | 37187 | 229 | 8 |
627146 | 627146 | 2020-10-13 | Washington | North Carolina | 37187 | 228 | 8 |
623904 | 623904 | 2020-10-12 | Washington | North Carolina | 37187 | 227 | 8 |
620661 | 620661 | 2020-10-11 | Washington | North Carolina | 37187 | 227 | 8 |
617419 | 617419 | 2020-10-10 | Washington | North Carolina | 37187 | 227 | 8 |
614177 | 614177 | 2020-10-09 | Washington | North Carolina | 37187 | 224 | 8 |
610936 | 610936 | 2020-10-08 | Washington | North Carolina | 37187 | 222 | 8 |
607694 | 607694 | 2020-10-07 | Washington | North Carolina | 37187 | 221 | 8 |
604451 | 604451 | 2020-10-06 | Washington | North Carolina | 37187 | 220 | 8 |
601209 | 601209 | 2020-10-05 | Washington | North Carolina | 37187 | 219 | 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);