ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51036 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092152 | 1092152 | 2021-03-05 | Charles City | Virginia | 51036 | 410 | 12 |
1088906 | 1088906 | 2021-03-04 | Charles City | Virginia | 51036 | 408 | 12 |
1085661 | 1085661 | 2021-03-03 | Charles City | Virginia | 51036 | 402 | 11 |
1082415 | 1082415 | 2021-03-02 | Charles City | Virginia | 51036 | 401 | 11 |
1079169 | 1079169 | 2021-03-01 | Charles City | Virginia | 51036 | 398 | 11 |
1075924 | 1075924 | 2021-02-28 | Charles City | Virginia | 51036 | 398 | 11 |
1072678 | 1072678 | 2021-02-27 | Charles City | Virginia | 51036 | 397 | 11 |
1069432 | 1069432 | 2021-02-26 | Charles City | Virginia | 51036 | 397 | 11 |
1066187 | 1066187 | 2021-02-25 | Charles City | Virginia | 51036 | 396 | 11 |
1062942 | 1062942 | 2021-02-24 | Charles City | Virginia | 51036 | 393 | 10 |
1059697 | 1059697 | 2021-02-23 | Charles City | Virginia | 51036 | 392 | 10 |
1056451 | 1056451 | 2021-02-22 | Charles City | Virginia | 51036 | 392 | 10 |
1053205 | 1053205 | 2021-02-21 | Charles City | Virginia | 51036 | 391 | 10 |
1049958 | 1049958 | 2021-02-20 | Charles City | Virginia | 51036 | 389 | 10 |
1046711 | 1046711 | 2021-02-19 | Charles City | Virginia | 51036 | 388 | 10 |
1043466 | 1043466 | 2021-02-18 | Charles City | Virginia | 51036 | 387 | 10 |
1040221 | 1040221 | 2021-02-17 | Charles City | Virginia | 51036 | 385 | 10 |
1036976 | 1036976 | 2021-02-16 | Charles City | Virginia | 51036 | 382 | 10 |
1033731 | 1033731 | 2021-02-15 | Charles City | Virginia | 51036 | 378 | 10 |
1030485 | 1030485 | 2021-02-14 | Charles City | Virginia | 51036 | 377 | 10 |
1027238 | 1027238 | 2021-02-13 | Charles City | Virginia | 51036 | 376 | 10 |
1023993 | 1023993 | 2021-02-12 | Charles City | Virginia | 51036 | 373 | 10 |
1020748 | 1020748 | 2021-02-11 | Charles City | Virginia | 51036 | 371 | 10 |
1017503 | 1017503 | 2021-02-10 | Charles City | Virginia | 51036 | 369 | 10 |
1014258 | 1014258 | 2021-02-09 | Charles City | Virginia | 51036 | 365 | 10 |
1011013 | 1011013 | 2021-02-08 | Charles City | Virginia | 51036 | 366 | 10 |
1007767 | 1007767 | 2021-02-07 | Charles City | Virginia | 51036 | 362 | 10 |
1004521 | 1004521 | 2021-02-06 | Charles City | Virginia | 51036 | 359 | 10 |
1001275 | 1001275 | 2021-02-05 | Charles City | Virginia | 51036 | 357 | 10 |
998029 | 998029 | 2021-02-04 | Charles City | Virginia | 51036 | 351 | 10 |
994783 | 994783 | 2021-02-03 | Charles City | Virginia | 51036 | 348 | 9 |
991537 | 991537 | 2021-02-02 | Charles City | Virginia | 51036 | 345 | 9 |
988291 | 988291 | 2021-02-01 | Charles City | Virginia | 51036 | 345 | 9 |
985044 | 985044 | 2021-01-31 | Charles City | Virginia | 51036 | 342 | 9 |
981797 | 981797 | 2021-01-30 | Charles City | Virginia | 51036 | 340 | 9 |
978551 | 978551 | 2021-01-29 | Charles City | Virginia | 51036 | 338 | 9 |
975306 | 975306 | 2021-01-28 | Charles City | Virginia | 51036 | 335 | 9 |
972061 | 972061 | 2021-01-27 | Charles City | Virginia | 51036 | 333 | 9 |
968816 | 968816 | 2021-01-26 | Charles City | Virginia | 51036 | 328 | 9 |
965572 | 965572 | 2021-01-25 | Charles City | Virginia | 51036 | 326 | 9 |
962327 | 962327 | 2021-01-24 | Charles City | Virginia | 51036 | 321 | 9 |
959082 | 959082 | 2021-01-23 | Charles City | Virginia | 51036 | 319 | 9 |
955836 | 955836 | 2021-01-22 | Charles City | Virginia | 51036 | 316 | 9 |
952591 | 952591 | 2021-01-21 | Charles City | Virginia | 51036 | 313 | 9 |
949346 | 949346 | 2021-01-20 | Charles City | Virginia | 51036 | 311 | 9 |
946100 | 946100 | 2021-01-19 | Charles City | Virginia | 51036 | 307 | 9 |
942853 | 942853 | 2021-01-18 | Charles City | Virginia | 51036 | 300 | 9 |
939608 | 939608 | 2021-01-17 | Charles City | Virginia | 51036 | 290 | 9 |
936363 | 936363 | 2021-01-16 | Charles City | Virginia | 51036 | 276 | 9 |
933118 | 933118 | 2021-01-15 | Charles City | Virginia | 51036 | 276 | 9 |
929873 | 929873 | 2021-01-14 | Charles City | Virginia | 51036 | 274 | 9 |
926628 | 926628 | 2021-01-13 | Charles City | Virginia | 51036 | 270 | 9 |
923382 | 923382 | 2021-01-12 | Charles City | Virginia | 51036 | 270 | 9 |
920137 | 920137 | 2021-01-11 | Charles City | Virginia | 51036 | 252 | 8 |
916892 | 916892 | 2021-01-10 | Charles City | Virginia | 51036 | 244 | 8 |
913647 | 913647 | 2021-01-09 | Charles City | Virginia | 51036 | 232 | 8 |
910402 | 910402 | 2021-01-08 | Charles City | Virginia | 51036 | 230 | 8 |
907157 | 907157 | 2021-01-07 | Charles City | Virginia | 51036 | 227 | 8 |
903911 | 903911 | 2021-01-06 | Charles City | Virginia | 51036 | 220 | 8 |
900666 | 900666 | 2021-01-05 | Charles City | Virginia | 51036 | 212 | 8 |
897421 | 897421 | 2021-01-04 | Charles City | Virginia | 51036 | 203 | 8 |
894175 | 894175 | 2021-01-03 | Charles City | Virginia | 51036 | 202 | 8 |
890929 | 890929 | 2021-01-02 | Charles City | Virginia | 51036 | 201 | 8 |
887682 | 887682 | 2021-01-01 | Charles City | Virginia | 51036 | 195 | 8 |
884437 | 884437 | 2020-12-31 | Charles City | Virginia | 51036 | 195 | 8 |
881192 | 881192 | 2020-12-30 | Charles City | Virginia | 51036 | 193 | 8 |
877947 | 877947 | 2020-12-29 | Charles City | Virginia | 51036 | 189 | 8 |
874702 | 874702 | 2020-12-28 | Charles City | Virginia | 51036 | 186 | 8 |
871457 | 871457 | 2020-12-27 | Charles City | Virginia | 51036 | 186 | 8 |
868212 | 868212 | 2020-12-26 | Charles City | Virginia | 51036 | 184 | 8 |
864967 | 864967 | 2020-12-25 | Charles City | Virginia | 51036 | 183 | 8 |
861722 | 861722 | 2020-12-24 | Charles City | Virginia | 51036 | 181 | 8 |
858477 | 858477 | 2020-12-23 | Charles City | Virginia | 51036 | 180 | 8 |
855232 | 855232 | 2020-12-22 | Charles City | Virginia | 51036 | 172 | 8 |
851987 | 851987 | 2020-12-21 | Charles City | Virginia | 51036 | 169 | 8 |
848742 | 848742 | 2020-12-20 | Charles City | Virginia | 51036 | 166 | 8 |
845497 | 845497 | 2020-12-19 | Charles City | Virginia | 51036 | 165 | 8 |
842251 | 842251 | 2020-12-18 | Charles City | Virginia | 51036 | 163 | 8 |
839006 | 839006 | 2020-12-17 | Charles City | Virginia | 51036 | 162 | 7 |
835760 | 835760 | 2020-12-16 | Charles City | Virginia | 51036 | 162 | 7 |
832514 | 832514 | 2020-12-15 | Charles City | Virginia | 51036 | 162 | 7 |
829267 | 829267 | 2020-12-14 | Charles City | Virginia | 51036 | 161 | 7 |
826021 | 826021 | 2020-12-13 | Charles City | Virginia | 51036 | 159 | 7 |
822774 | 822774 | 2020-12-12 | Charles City | Virginia | 51036 | 156 | 7 |
819528 | 819528 | 2020-12-11 | Charles City | Virginia | 51036 | 154 | 7 |
816282 | 816282 | 2020-12-10 | Charles City | Virginia | 51036 | 153 | 7 |
813036 | 813036 | 2020-12-09 | Charles City | Virginia | 51036 | 151 | 7 |
809792 | 809792 | 2020-12-08 | Charles City | Virginia | 51036 | 151 | 7 |
806547 | 806547 | 2020-12-07 | Charles City | Virginia | 51036 | 150 | 7 |
803302 | 803302 | 2020-12-06 | Charles City | Virginia | 51036 | 149 | 7 |
800057 | 800057 | 2020-12-05 | Charles City | Virginia | 51036 | 150 | 7 |
796812 | 796812 | 2020-12-04 | Charles City | Virginia | 51036 | 146 | 7 |
793567 | 793567 | 2020-12-03 | Charles City | Virginia | 51036 | 145 | 7 |
790322 | 790322 | 2020-12-02 | Charles City | Virginia | 51036 | 145 | 7 |
787077 | 787077 | 2020-12-01 | Charles City | Virginia | 51036 | 145 | 7 |
783833 | 783833 | 2020-11-30 | Charles City | Virginia | 51036 | 142 | 7 |
780588 | 780588 | 2020-11-29 | Charles City | Virginia | 51036 | 141 | 7 |
777342 | 777342 | 2020-11-28 | Charles City | Virginia | 51036 | 141 | 7 |
774097 | 774097 | 2020-11-27 | Charles City | Virginia | 51036 | 141 | 7 |
770852 | 770852 | 2020-11-26 | Charles City | Virginia | 51036 | 139 | 6 |
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);