ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Richmond 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 |
---|---|---|---|---|---|---|---|
1095482 | 1095482 | 2021-03-06 | Richmond city | Virginia | 51760 | 14990 | 215 |
1092236 | 1092236 | 2021-03-05 | Richmond city | Virginia | 51760 | 14971 | 214 |
1088990 | 1088990 | 2021-03-04 | Richmond city | Virginia | 51760 | 14938 | 214 |
1085745 | 1085745 | 2021-03-03 | Richmond city | Virginia | 51760 | 14914 | 213 |
1082499 | 1082499 | 2021-03-02 | Richmond city | Virginia | 51760 | 14897 | 203 |
1079253 | 1079253 | 2021-03-01 | Richmond city | Virginia | 51760 | 14849 | 197 |
1076008 | 1076008 | 2021-02-28 | Richmond city | Virginia | 51760 | 14829 | 191 |
1072762 | 1072762 | 2021-02-27 | Richmond city | Virginia | 51760 | 14794 | 186 |
1069516 | 1069516 | 2021-02-26 | Richmond city | Virginia | 51760 | 14747 | 179 |
1066271 | 1066271 | 2021-02-25 | Richmond city | Virginia | 51760 | 14678 | 174 |
1063026 | 1063026 | 2021-02-24 | Richmond city | Virginia | 51760 | 14647 | 171 |
1059781 | 1059781 | 2021-02-23 | Richmond city | Virginia | 51760 | 14577 | 164 |
1056535 | 1056535 | 2021-02-22 | Richmond city | Virginia | 51760 | 14499 | 161 |
1053289 | 1053289 | 2021-02-21 | Richmond city | Virginia | 51760 | 14435 | 152 |
1050042 | 1050042 | 2021-02-20 | Richmond city | Virginia | 51760 | 14380 | 151 |
1046795 | 1046795 | 2021-02-19 | Richmond city | Virginia | 51760 | 14297 | 148 |
1043550 | 1043550 | 2021-02-18 | Richmond city | Virginia | 51760 | 14236 | 148 |
1040305 | 1040305 | 2021-02-17 | Richmond city | Virginia | 51760 | 14159 | 148 |
1037060 | 1037060 | 2021-02-16 | Richmond city | Virginia | 51760 | 14098 | 148 |
1033815 | 1033815 | 2021-02-15 | Richmond city | Virginia | 51760 | 14057 | 148 |
1030569 | 1030569 | 2021-02-14 | Richmond city | Virginia | 51760 | 14023 | 147 |
1027322 | 1027322 | 2021-02-13 | Richmond city | Virginia | 51760 | 13922 | 145 |
1024077 | 1024077 | 2021-02-12 | Richmond city | Virginia | 51760 | 13825 | 145 |
1020832 | 1020832 | 2021-02-11 | Richmond city | Virginia | 51760 | 13723 | 144 |
1017587 | 1017587 | 2021-02-10 | Richmond city | Virginia | 51760 | 13632 | 144 |
1014342 | 1014342 | 2021-02-09 | Richmond city | Virginia | 51760 | 13563 | 143 |
1011097 | 1011097 | 2021-02-08 | Richmond city | Virginia | 51760 | 13478 | 142 |
1007851 | 1007851 | 2021-02-07 | Richmond city | Virginia | 51760 | 13439 | 142 |
1004605 | 1004605 | 2021-02-06 | Richmond city | Virginia | 51760 | 13380 | 143 |
1001359 | 1001359 | 2021-02-05 | Richmond city | Virginia | 51760 | 13252 | 140 |
998113 | 998113 | 2021-02-04 | Richmond city | Virginia | 51760 | 13130 | 139 |
994867 | 994867 | 2021-02-03 | Richmond city | Virginia | 51760 | 13032 | 135 |
991621 | 991621 | 2021-02-02 | Richmond city | Virginia | 51760 | 12942 | 132 |
988375 | 988375 | 2021-02-01 | Richmond city | Virginia | 51760 | 12862 | 132 |
985128 | 985128 | 2021-01-31 | Richmond city | Virginia | 51760 | 12757 | 132 |
981881 | 981881 | 2021-01-30 | Richmond city | Virginia | 51760 | 12685 | 132 |
978635 | 978635 | 2021-01-29 | Richmond city | Virginia | 51760 | 12588 | 131 |
975390 | 975390 | 2021-01-28 | Richmond city | Virginia | 51760 | 12470 | 127 |
972145 | 972145 | 2021-01-27 | Richmond city | Virginia | 51760 | 12321 | 124 |
968900 | 968900 | 2021-01-26 | Richmond city | Virginia | 51760 | 12213 | 123 |
965656 | 965656 | 2021-01-25 | Richmond city | Virginia | 51760 | 12109 | 119 |
962411 | 962411 | 2021-01-24 | Richmond city | Virginia | 51760 | 11978 | 119 |
959166 | 959166 | 2021-01-23 | Richmond city | Virginia | 51760 | 11884 | 119 |
955920 | 955920 | 2021-01-22 | Richmond city | Virginia | 51760 | 11778 | 119 |
952675 | 952675 | 2021-01-21 | Richmond city | Virginia | 51760 | 11718 | 118 |
949430 | 949430 | 2021-01-20 | Richmond city | Virginia | 51760 | 11636 | 118 |
946184 | 946184 | 2021-01-19 | Richmond city | Virginia | 51760 | 11529 | 118 |
942937 | 942937 | 2021-01-18 | Richmond city | Virginia | 51760 | 11416 | 118 |
939692 | 939692 | 2021-01-17 | Richmond city | Virginia | 51760 | 11231 | 118 |
936447 | 936447 | 2021-01-16 | Richmond city | Virginia | 51760 | 11059 | 118 |
933202 | 933202 | 2021-01-15 | Richmond city | Virginia | 51760 | 10915 | 118 |
929957 | 929957 | 2021-01-14 | Richmond city | Virginia | 51760 | 10807 | 118 |
926712 | 926712 | 2021-01-13 | Richmond city | Virginia | 51760 | 10698 | 116 |
923466 | 923466 | 2021-01-12 | Richmond city | Virginia | 51760 | 10558 | 108 |
920221 | 920221 | 2021-01-11 | Richmond city | Virginia | 51760 | 10464 | 106 |
916976 | 916976 | 2021-01-10 | Richmond city | Virginia | 51760 | 10378 | 106 |
913731 | 913731 | 2021-01-09 | Richmond city | Virginia | 51760 | 10239 | 106 |
910486 | 910486 | 2021-01-08 | Richmond city | Virginia | 51760 | 10134 | 101 |
907241 | 907241 | 2021-01-07 | Richmond city | Virginia | 51760 | 9999 | 101 |
903995 | 903995 | 2021-01-06 | Richmond city | Virginia | 51760 | 9887 | 100 |
900750 | 900750 | 2021-01-05 | Richmond city | Virginia | 51760 | 9743 | 98 |
897505 | 897505 | 2021-01-04 | Richmond city | Virginia | 51760 | 9635 | 98 |
894259 | 894259 | 2021-01-03 | Richmond city | Virginia | 51760 | 9534 | 97 |
891013 | 891013 | 2021-01-02 | Richmond city | Virginia | 51760 | 9432 | 96 |
887766 | 887766 | 2021-01-01 | Richmond city | Virginia | 51760 | 9299 | 95 |
884521 | 884521 | 2020-12-31 | Richmond city | Virginia | 51760 | 9158 | 94 |
881276 | 881276 | 2020-12-30 | Richmond city | Virginia | 51760 | 9046 | 94 |
878031 | 878031 | 2020-12-29 | Richmond city | Virginia | 51760 | 8954 | 93 |
874786 | 874786 | 2020-12-28 | Richmond city | Virginia | 51760 | 8901 | 92 |
871541 | 871541 | 2020-12-27 | Richmond city | Virginia | 51760 | 8825 | 92 |
868296 | 868296 | 2020-12-26 | Richmond city | Virginia | 51760 | 8774 | 91 |
865051 | 865051 | 2020-12-25 | Richmond city | Virginia | 51760 | 8718 | 91 |
861806 | 861806 | 2020-12-24 | Richmond city | Virginia | 51760 | 8633 | 91 |
858561 | 858561 | 2020-12-23 | Richmond city | Virginia | 51760 | 8525 | 91 |
855316 | 855316 | 2020-12-22 | Richmond city | Virginia | 51760 | 8435 | 90 |
852071 | 852071 | 2020-12-21 | Richmond city | Virginia | 51760 | 8349 | 90 |
848826 | 848826 | 2020-12-20 | Richmond city | Virginia | 51760 | 8225 | 90 |
845581 | 845581 | 2020-12-19 | Richmond city | Virginia | 51760 | 8096 | 90 |
842335 | 842335 | 2020-12-18 | Richmond city | Virginia | 51760 | 7961 | 88 |
839090 | 839090 | 2020-12-17 | Richmond city | Virginia | 51760 | 7905 | 87 |
835844 | 835844 | 2020-12-16 | Richmond city | Virginia | 51760 | 7845 | 86 |
832598 | 832598 | 2020-12-15 | Richmond city | Virginia | 51760 | 7779 | 86 |
829351 | 829351 | 2020-12-14 | Richmond city | Virginia | 51760 | 7704 | 86 |
826105 | 826105 | 2020-12-13 | Richmond city | Virginia | 51760 | 7636 | 86 |
822858 | 822858 | 2020-12-12 | Richmond city | Virginia | 51760 | 7574 | 86 |
819612 | 819612 | 2020-12-11 | Richmond city | Virginia | 51760 | 7484 | 86 |
816366 | 816366 | 2020-12-10 | Richmond city | Virginia | 51760 | 7406 | 84 |
813120 | 813120 | 2020-12-09 | Richmond city | Virginia | 51760 | 7315 | 83 |
809876 | 809876 | 2020-12-08 | Richmond city | Virginia | 51760 | 7224 | 82 |
806631 | 806631 | 2020-12-07 | Richmond city | Virginia | 51760 | 7176 | 82 |
803386 | 803386 | 2020-12-06 | Richmond city | Virginia | 51760 | 7050 | 82 |
800141 | 800141 | 2020-12-05 | Richmond city | Virginia | 51760 | 6960 | 82 |
796896 | 796896 | 2020-12-04 | Richmond city | Virginia | 51760 | 6896 | 82 |
793651 | 793651 | 2020-12-03 | Richmond city | Virginia | 51760 | 6840 | 82 |
790406 | 790406 | 2020-12-02 | Richmond city | Virginia | 51760 | 6803 | 82 |
787161 | 787161 | 2020-12-01 | Richmond city | Virginia | 51760 | 6754 | 82 |
783917 | 783917 | 2020-11-30 | Richmond city | Virginia | 51760 | 6712 | 82 |
780672 | 780672 | 2020-11-29 | Richmond city | Virginia | 51760 | 6669 | 82 |
777426 | 777426 | 2020-11-28 | Richmond city | Virginia | 51760 | 6606 | 82 |
774181 | 774181 | 2020-11-27 | Richmond city | Virginia | 51760 | 6536 | 82 |
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);