ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Williamsburg city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952698 | 952698 | 2021-01-21 | Williamsburg city | Virginia | 51830 | 423 | 8 |
949453 | 949453 | 2021-01-20 | Williamsburg city | Virginia | 51830 | 411 | 8 |
946207 | 946207 | 2021-01-19 | Williamsburg city | Virginia | 51830 | 417 | 8 |
942960 | 942960 | 2021-01-18 | Williamsburg city | Virginia | 51830 | 416 | 8 |
939715 | 939715 | 2021-01-17 | Williamsburg city | Virginia | 51830 | 411 | 8 |
936470 | 936470 | 2021-01-16 | Williamsburg city | Virginia | 51830 | 405 | 8 |
933225 | 933225 | 2021-01-15 | Williamsburg city | Virginia | 51830 | 418 | 8 |
929980 | 929980 | 2021-01-14 | Williamsburg city | Virginia | 51830 | 395 | 8 |
926735 | 926735 | 2021-01-13 | Williamsburg city | Virginia | 51830 | 393 | 8 |
923489 | 923489 | 2021-01-12 | Williamsburg city | Virginia | 51830 | 392 | 8 |
920244 | 920244 | 2021-01-11 | Williamsburg city | Virginia | 51830 | 392 | 8 |
916999 | 916999 | 2021-01-10 | Williamsburg city | Virginia | 51830 | 391 | 8 |
913754 | 913754 | 2021-01-09 | Williamsburg city | Virginia | 51830 | 389 | 8 |
910509 | 910509 | 2021-01-08 | Williamsburg city | Virginia | 51830 | 385 | 8 |
907264 | 907264 | 2021-01-07 | Williamsburg city | Virginia | 51830 | 383 | 8 |
904018 | 904018 | 2021-01-06 | Williamsburg city | Virginia | 51830 | 380 | 8 |
900773 | 900773 | 2021-01-05 | Williamsburg city | Virginia | 51830 | 377 | 8 |
897528 | 897528 | 2021-01-04 | Williamsburg city | Virginia | 51830 | 394 | 8 |
894282 | 894282 | 2021-01-03 | Williamsburg city | Virginia | 51830 | 385 | 8 |
891036 | 891036 | 2021-01-02 | Williamsburg city | Virginia | 51830 | 360 | 8 |
887789 | 887789 | 2021-01-01 | Williamsburg city | Virginia | 51830 | 360 | 8 |
884544 | 884544 | 2020-12-31 | Williamsburg city | Virginia | 51830 | 358 | 8 |
881299 | 881299 | 2020-12-30 | Williamsburg city | Virginia | 51830 | 353 | 8 |
878054 | 878054 | 2020-12-29 | Williamsburg city | Virginia | 51830 | 352 | 8 |
874809 | 874809 | 2020-12-28 | Williamsburg city | Virginia | 51830 | 352 | 8 |
871564 | 871564 | 2020-12-27 | Williamsburg city | Virginia | 51830 | 352 | 8 |
868319 | 868319 | 2020-12-26 | Williamsburg city | Virginia | 51830 | 350 | 8 |
865074 | 865074 | 2020-12-25 | Williamsburg city | Virginia | 51830 | 350 | 8 |
861829 | 861829 | 2020-12-24 | Williamsburg city | Virginia | 51830 | 349 | 8 |
858584 | 858584 | 2020-12-23 | Williamsburg city | Virginia | 51830 | 348 | 8 |
855339 | 855339 | 2020-12-22 | Williamsburg city | Virginia | 51830 | 346 | 8 |
852094 | 852094 | 2020-12-21 | Williamsburg city | Virginia | 51830 | 350 | 8 |
848849 | 848849 | 2020-12-20 | Williamsburg city | Virginia | 51830 | 346 | 8 |
845604 | 845604 | 2020-12-19 | Williamsburg city | Virginia | 51830 | 344 | 8 |
842358 | 842358 | 2020-12-18 | Williamsburg city | Virginia | 51830 | 343 | 8 |
839113 | 839113 | 2020-12-17 | Williamsburg city | Virginia | 51830 | 340 | 8 |
835867 | 835867 | 2020-12-16 | Williamsburg city | Virginia | 51830 | 338 | 8 |
832621 | 832621 | 2020-12-15 | Williamsburg city | Virginia | 51830 | 334 | 8 |
829374 | 829374 | 2020-12-14 | Williamsburg city | Virginia | 51830 | 330 | 8 |
826128 | 826128 | 2020-12-13 | Williamsburg city | Virginia | 51830 | 325 | 8 |
822881 | 822881 | 2020-12-12 | Williamsburg city | Virginia | 51830 | 321 | 8 |
819635 | 819635 | 2020-12-11 | Williamsburg city | Virginia | 51830 | 319 | 8 |
816389 | 816389 | 2020-12-10 | Williamsburg city | Virginia | 51830 | 318 | 8 |
813143 | 813143 | 2020-12-09 | Williamsburg city | Virginia | 51830 | 314 | 8 |
809899 | 809899 | 2020-12-08 | Williamsburg city | Virginia | 51830 | 309 | 8 |
806654 | 806654 | 2020-12-07 | Williamsburg city | Virginia | 51830 | 309 | 8 |
803409 | 803409 | 2020-12-06 | Williamsburg city | Virginia | 51830 | 308 | 8 |
800164 | 800164 | 2020-12-05 | Williamsburg city | Virginia | 51830 | 300 | 8 |
796919 | 796919 | 2020-12-04 | Williamsburg city | Virginia | 51830 | 301 | 8 |
793674 | 793674 | 2020-12-03 | Williamsburg city | Virginia | 51830 | 298 | 8 |
790429 | 790429 | 2020-12-02 | Williamsburg city | Virginia | 51830 | 295 | 8 |
787184 | 787184 | 2020-12-01 | Williamsburg city | Virginia | 51830 | 291 | 8 |
783940 | 783940 | 2020-11-30 | Williamsburg city | Virginia | 51830 | 289 | 8 |
780695 | 780695 | 2020-11-29 | Williamsburg city | Virginia | 51830 | 289 | 8 |
777449 | 777449 | 2020-11-28 | Williamsburg city | Virginia | 51830 | 287 | 8 |
774204 | 774204 | 2020-11-27 | Williamsburg city | Virginia | 51830 | 287 | 8 |
770959 | 770959 | 2020-11-26 | Williamsburg city | Virginia | 51830 | 285 | 8 |
767713 | 767713 | 2020-11-25 | Williamsburg city | Virginia | 51830 | 285 | 8 |
764468 | 764468 | 2020-11-24 | Williamsburg city | Virginia | 51830 | 284 | 8 |
761223 | 761223 | 2020-11-23 | Williamsburg city | Virginia | 51830 | 283 | 8 |
757978 | 757978 | 2020-11-22 | Williamsburg city | Virginia | 51830 | 279 | 8 |
754731 | 754731 | 2020-11-21 | Williamsburg city | Virginia | 51830 | 279 | 8 |
751485 | 751485 | 2020-11-20 | Williamsburg city | Virginia | 51830 | 275 | 8 |
748239 | 748239 | 2020-11-19 | Williamsburg city | Virginia | 51830 | 275 | 8 |
744993 | 744993 | 2020-11-18 | Williamsburg city | Virginia | 51830 | 264 | 8 |
741746 | 741746 | 2020-11-17 | Williamsburg city | Virginia | 51830 | 260 | 8 |
738499 | 738499 | 2020-11-16 | Williamsburg city | Virginia | 51830 | 257 | 8 |
735255 | 735255 | 2020-11-15 | Williamsburg city | Virginia | 51830 | 248 | 8 |
732009 | 732009 | 2020-11-14 | Williamsburg city | Virginia | 51830 | 248 | 8 |
728764 | 728764 | 2020-11-13 | Williamsburg city | Virginia | 51830 | 245 | 8 |
725521 | 725521 | 2020-11-12 | Williamsburg city | Virginia | 51830 | 244 | 8 |
722278 | 722278 | 2020-11-11 | Williamsburg city | Virginia | 51830 | 244 | 8 |
719035 | 719035 | 2020-11-10 | Williamsburg city | Virginia | 51830 | 243 | 8 |
715792 | 715792 | 2020-11-09 | Williamsburg city | Virginia | 51830 | 240 | 8 |
712548 | 712548 | 2020-11-08 | Williamsburg city | Virginia | 51830 | 239 | 8 |
709304 | 709304 | 2020-11-07 | Williamsburg city | Virginia | 51830 | 235 | 8 |
706060 | 706060 | 2020-11-06 | Williamsburg city | Virginia | 51830 | 235 | 8 |
702817 | 702817 | 2020-11-05 | Williamsburg city | Virginia | 51830 | 232 | 8 |
699574 | 699574 | 2020-11-04 | Williamsburg city | Virginia | 51830 | 231 | 8 |
696330 | 696330 | 2020-11-03 | Williamsburg city | Virginia | 51830 | 230 | 8 |
693088 | 693088 | 2020-11-02 | Williamsburg city | Virginia | 51830 | 228 | 8 |
689844 | 689844 | 2020-11-01 | Williamsburg city | Virginia | 51830 | 225 | 8 |
686599 | 686599 | 2020-10-31 | Williamsburg city | Virginia | 51830 | 223 | 8 |
683356 | 683356 | 2020-10-30 | Williamsburg city | Virginia | 51830 | 219 | 8 |
680113 | 680113 | 2020-10-29 | Williamsburg city | Virginia | 51830 | 218 | 8 |
676870 | 676870 | 2020-10-28 | Williamsburg city | Virginia | 51830 | 216 | 8 |
673627 | 673627 | 2020-10-27 | Williamsburg city | Virginia | 51830 | 215 | 8 |
670385 | 670385 | 2020-10-26 | Williamsburg city | Virginia | 51830 | 215 | 8 |
667142 | 667142 | 2020-10-25 | Williamsburg city | Virginia | 51830 | 213 | 8 |
663897 | 663897 | 2020-10-24 | Williamsburg city | Virginia | 51830 | 213 | 8 |
660653 | 660653 | 2020-10-23 | Williamsburg city | Virginia | 51830 | 211 | 8 |
657409 | 657409 | 2020-10-22 | Williamsburg city | Virginia | 51830 | 210 | 8 |
654164 | 654164 | 2020-10-21 | Williamsburg city | Virginia | 51830 | 210 | 8 |
650919 | 650919 | 2020-10-20 | Williamsburg city | Virginia | 51830 | 210 | 8 |
647675 | 647675 | 2020-10-19 | Williamsburg city | Virginia | 51830 | 209 | 8 |
644429 | 644429 | 2020-10-18 | Williamsburg city | Virginia | 51830 | 204 | 8 |
641181 | 641181 | 2020-10-17 | Williamsburg city | Virginia | 51830 | 204 | 8 |
637934 | 637934 | 2020-10-16 | Williamsburg city | Virginia | 51830 | 204 | 8 |
634689 | 634689 | 2020-10-15 | Williamsburg city | Virginia | 51830 | 204 | 8 |
631444 | 631444 | 2020-10-14 | Williamsburg city | Virginia | 51830 | 204 | 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);