ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Spotsylvania" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095493 | 1095493 | 2021-03-06 | Spotsylvania | Virginia | 51177 | 8418 | 102 |
1092247 | 1092247 | 2021-03-05 | Spotsylvania | Virginia | 51177 | 8402 | 102 |
1089001 | 1089001 | 2021-03-04 | Spotsylvania | Virginia | 51177 | 8385 | 102 |
1085756 | 1085756 | 2021-03-03 | Spotsylvania | Virginia | 51177 | 8367 | 102 |
1082510 | 1082510 | 2021-03-02 | Spotsylvania | Virginia | 51177 | 8341 | 100 |
1079264 | 1079264 | 2021-03-01 | Spotsylvania | Virginia | 51177 | 8300 | 100 |
1076019 | 1076019 | 2021-02-28 | Spotsylvania | Virginia | 51177 | 8281 | 99 |
1072773 | 1072773 | 2021-02-27 | Spotsylvania | Virginia | 51177 | 8270 | 98 |
1069527 | 1069527 | 2021-02-26 | Spotsylvania | Virginia | 51177 | 8251 | 97 |
1066282 | 1066282 | 2021-02-25 | Spotsylvania | Virginia | 51177 | 8221 | 96 |
1063037 | 1063037 | 2021-02-24 | Spotsylvania | Virginia | 51177 | 8190 | 95 |
1059792 | 1059792 | 2021-02-23 | Spotsylvania | Virginia | 51177 | 8156 | 93 |
1056546 | 1056546 | 2021-02-22 | Spotsylvania | Virginia | 51177 | 8140 | 89 |
1053300 | 1053300 | 2021-02-21 | Spotsylvania | Virginia | 51177 | 8121 | 88 |
1050053 | 1050053 | 2021-02-20 | Spotsylvania | Virginia | 51177 | 8094 | 88 |
1046806 | 1046806 | 2021-02-19 | Spotsylvania | Virginia | 51177 | 8070 | 88 |
1043561 | 1043561 | 2021-02-18 | Spotsylvania | Virginia | 51177 | 8043 | 88 |
1040316 | 1040316 | 2021-02-17 | Spotsylvania | Virginia | 51177 | 8011 | 88 |
1037071 | 1037071 | 2021-02-16 | Spotsylvania | Virginia | 51177 | 7975 | 88 |
1033826 | 1033826 | 2021-02-15 | Spotsylvania | Virginia | 51177 | 7935 | 88 |
1030580 | 1030580 | 2021-02-14 | Spotsylvania | Virginia | 51177 | 7920 | 88 |
1027333 | 1027333 | 2021-02-13 | Spotsylvania | Virginia | 51177 | 7884 | 88 |
1024088 | 1024088 | 2021-02-12 | Spotsylvania | Virginia | 51177 | 7852 | 87 |
1020843 | 1020843 | 2021-02-11 | Spotsylvania | Virginia | 51177 | 7799 | 87 |
1017598 | 1017598 | 2021-02-10 | Spotsylvania | Virginia | 51177 | 7744 | 87 |
1014353 | 1014353 | 2021-02-09 | Spotsylvania | Virginia | 51177 | 7705 | 87 |
1011108 | 1011108 | 2021-02-08 | Spotsylvania | Virginia | 51177 | 7641 | 87 |
1007862 | 1007862 | 2021-02-07 | Spotsylvania | Virginia | 51177 | 7611 | 87 |
1004616 | 1004616 | 2021-02-06 | Spotsylvania | Virginia | 51177 | 7576 | 87 |
1001370 | 1001370 | 2021-02-05 | Spotsylvania | Virginia | 51177 | 7486 | 87 |
998124 | 998124 | 2021-02-04 | Spotsylvania | Virginia | 51177 | 7380 | 84 |
994878 | 994878 | 2021-02-03 | Spotsylvania | Virginia | 51177 | 7322 | 83 |
991632 | 991632 | 2021-02-02 | Spotsylvania | Virginia | 51177 | 7282 | 83 |
988386 | 988386 | 2021-02-01 | Spotsylvania | Virginia | 51177 | 7246 | 82 |
985139 | 985139 | 2021-01-31 | Spotsylvania | Virginia | 51177 | 7194 | 82 |
981892 | 981892 | 2021-01-30 | Spotsylvania | Virginia | 51177 | 7150 | 82 |
978646 | 978646 | 2021-01-29 | Spotsylvania | Virginia | 51177 | 7077 | 81 |
975401 | 975401 | 2021-01-28 | Spotsylvania | Virginia | 51177 | 6974 | 80 |
972156 | 972156 | 2021-01-27 | Spotsylvania | Virginia | 51177 | 6879 | 80 |
968911 | 968911 | 2021-01-26 | Spotsylvania | Virginia | 51177 | 6820 | 79 |
965667 | 965667 | 2021-01-25 | Spotsylvania | Virginia | 51177 | 6697 | 78 |
962422 | 962422 | 2021-01-24 | Spotsylvania | Virginia | 51177 | 6600 | 78 |
959177 | 959177 | 2021-01-23 | Spotsylvania | Virginia | 51177 | 6551 | 78 |
955931 | 955931 | 2021-01-22 | Spotsylvania | Virginia | 51177 | 6457 | 76 |
952686 | 952686 | 2021-01-21 | Spotsylvania | Virginia | 51177 | 6396 | 75 |
949441 | 949441 | 2021-01-20 | Spotsylvania | Virginia | 51177 | 6348 | 75 |
946195 | 946195 | 2021-01-19 | Spotsylvania | Virginia | 51177 | 6256 | 75 |
942948 | 942948 | 2021-01-18 | Spotsylvania | Virginia | 51177 | 6124 | 74 |
939703 | 939703 | 2021-01-17 | Spotsylvania | Virginia | 51177 | 6007 | 74 |
936458 | 936458 | 2021-01-16 | Spotsylvania | Virginia | 51177 | 5926 | 74 |
933213 | 933213 | 2021-01-15 | Spotsylvania | Virginia | 51177 | 5806 | 72 |
929968 | 929968 | 2021-01-14 | Spotsylvania | Virginia | 51177 | 5688 | 71 |
926723 | 926723 | 2021-01-13 | Spotsylvania | Virginia | 51177 | 5614 | 71 |
923477 | 923477 | 2021-01-12 | Spotsylvania | Virginia | 51177 | 5550 | 71 |
920232 | 920232 | 2021-01-11 | Spotsylvania | Virginia | 51177 | 5468 | 71 |
916987 | 916987 | 2021-01-10 | Spotsylvania | Virginia | 51177 | 5408 | 71 |
913742 | 913742 | 2021-01-09 | Spotsylvania | Virginia | 51177 | 5331 | 71 |
910497 | 910497 | 2021-01-08 | Spotsylvania | Virginia | 51177 | 5301 | 70 |
907252 | 907252 | 2021-01-07 | Spotsylvania | Virginia | 51177 | 5257 | 70 |
904006 | 904006 | 2021-01-06 | Spotsylvania | Virginia | 51177 | 5183 | 69 |
900761 | 900761 | 2021-01-05 | Spotsylvania | Virginia | 51177 | 5077 | 69 |
897516 | 897516 | 2021-01-04 | Spotsylvania | Virginia | 51177 | 5001 | 68 |
894270 | 894270 | 2021-01-03 | Spotsylvania | Virginia | 51177 | 4954 | 68 |
891024 | 891024 | 2021-01-02 | Spotsylvania | Virginia | 51177 | 4901 | 67 |
887777 | 887777 | 2021-01-01 | Spotsylvania | Virginia | 51177 | 4843 | 67 |
884532 | 884532 | 2020-12-31 | Spotsylvania | Virginia | 51177 | 4797 | 67 |
881287 | 881287 | 2020-12-30 | Spotsylvania | Virginia | 51177 | 4678 | 67 |
878042 | 878042 | 2020-12-29 | Spotsylvania | Virginia | 51177 | 4607 | 67 |
874797 | 874797 | 2020-12-28 | Spotsylvania | Virginia | 51177 | 4510 | 67 |
871552 | 871552 | 2020-12-27 | Spotsylvania | Virginia | 51177 | 4470 | 67 |
868307 | 868307 | 2020-12-26 | Spotsylvania | Virginia | 51177 | 4464 | 67 |
865062 | 865062 | 2020-12-25 | Spotsylvania | Virginia | 51177 | 4446 | 67 |
861817 | 861817 | 2020-12-24 | Spotsylvania | Virginia | 51177 | 4338 | 67 |
858572 | 858572 | 2020-12-23 | Spotsylvania | Virginia | 51177 | 4219 | 67 |
855327 | 855327 | 2020-12-22 | Spotsylvania | Virginia | 51177 | 4171 | 67 |
852082 | 852082 | 2020-12-21 | Spotsylvania | Virginia | 51177 | 4121 | 66 |
848837 | 848837 | 2020-12-20 | Spotsylvania | Virginia | 51177 | 4018 | 66 |
845592 | 845592 | 2020-12-19 | Spotsylvania | Virginia | 51177 | 3996 | 62 |
842346 | 842346 | 2020-12-18 | Spotsylvania | Virginia | 51177 | 3974 | 61 |
839101 | 839101 | 2020-12-17 | Spotsylvania | Virginia | 51177 | 3916 | 60 |
835855 | 835855 | 2020-12-16 | Spotsylvania | Virginia | 51177 | 3872 | 59 |
832609 | 832609 | 2020-12-15 | Spotsylvania | Virginia | 51177 | 3818 | 58 |
829362 | 829362 | 2020-12-14 | Spotsylvania | Virginia | 51177 | 3786 | 58 |
826116 | 826116 | 2020-12-13 | Spotsylvania | Virginia | 51177 | 3709 | 58 |
822869 | 822869 | 2020-12-12 | Spotsylvania | Virginia | 51177 | 3705 | 58 |
819623 | 819623 | 2020-12-11 | Spotsylvania | Virginia | 51177 | 3652 | 58 |
816377 | 816377 | 2020-12-10 | Spotsylvania | Virginia | 51177 | 3610 | 58 |
813131 | 813131 | 2020-12-09 | Spotsylvania | Virginia | 51177 | 3574 | 58 |
809887 | 809887 | 2020-12-08 | Spotsylvania | Virginia | 51177 | 3529 | 58 |
806642 | 806642 | 2020-12-07 | Spotsylvania | Virginia | 51177 | 3472 | 58 |
803397 | 803397 | 2020-12-06 | Spotsylvania | Virginia | 51177 | 3394 | 58 |
800152 | 800152 | 2020-12-05 | Spotsylvania | Virginia | 51177 | 3340 | 58 |
796907 | 796907 | 2020-12-04 | Spotsylvania | Virginia | 51177 | 3292 | 58 |
793662 | 793662 | 2020-12-03 | Spotsylvania | Virginia | 51177 | 3248 | 58 |
790417 | 790417 | 2020-12-02 | Spotsylvania | Virginia | 51177 | 3218 | 58 |
787172 | 787172 | 2020-12-01 | Spotsylvania | Virginia | 51177 | 3185 | 58 |
783928 | 783928 | 2020-11-30 | Spotsylvania | Virginia | 51177 | 3161 | 58 |
780683 | 780683 | 2020-11-29 | Spotsylvania | Virginia | 51177 | 3147 | 58 |
777437 | 777437 | 2020-11-28 | Spotsylvania | Virginia | 51177 | 3109 | 58 |
774192 | 774192 | 2020-11-27 | Spotsylvania | Virginia | 51177 | 3067 | 57 |
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);