ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Madison" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1082468 | 1082468 | 2021-03-02 | Madison | Virginia | 51113 | 533 | 13 |
1079222 | 1079222 | 2021-03-01 | Madison | Virginia | 51113 | 533 | 12 |
1075977 | 1075977 | 2021-02-28 | Madison | Virginia | 51113 | 532 | 12 |
1072731 | 1072731 | 2021-02-27 | Madison | Virginia | 51113 | 531 | 11 |
1069485 | 1069485 | 2021-02-26 | Madison | Virginia | 51113 | 530 | 11 |
1066240 | 1066240 | 2021-02-25 | Madison | Virginia | 51113 | 529 | 9 |
1062995 | 1062995 | 2021-02-24 | Madison | Virginia | 51113 | 528 | 9 |
1059750 | 1059750 | 2021-02-23 | Madison | Virginia | 51113 | 528 | 8 |
1056504 | 1056504 | 2021-02-22 | Madison | Virginia | 51113 | 527 | 8 |
1053258 | 1053258 | 2021-02-21 | Madison | Virginia | 51113 | 527 | 8 |
1050011 | 1050011 | 2021-02-20 | Madison | Virginia | 51113 | 527 | 7 |
1046764 | 1046764 | 2021-02-19 | Madison | Virginia | 51113 | 527 | 7 |
1043519 | 1043519 | 2021-02-18 | Madison | Virginia | 51113 | 527 | 7 |
1040274 | 1040274 | 2021-02-17 | Madison | Virginia | 51113 | 528 | 7 |
1037029 | 1037029 | 2021-02-16 | Madison | Virginia | 51113 | 525 | 7 |
1033784 | 1033784 | 2021-02-15 | Madison | Virginia | 51113 | 525 | 7 |
1030538 | 1030538 | 2021-02-14 | Madison | Virginia | 51113 | 523 | 7 |
1027291 | 1027291 | 2021-02-13 | Madison | Virginia | 51113 | 523 | 7 |
1024046 | 1024046 | 2021-02-12 | Madison | Virginia | 51113 | 521 | 7 |
1020801 | 1020801 | 2021-02-11 | Madison | Virginia | 51113 | 518 | 7 |
1017556 | 1017556 | 2021-02-10 | Madison | Virginia | 51113 | 516 | 7 |
1014311 | 1014311 | 2021-02-09 | Madison | Virginia | 51113 | 513 | 6 |
1011066 | 1011066 | 2021-02-08 | Madison | Virginia | 51113 | 511 | 6 |
1007820 | 1007820 | 2021-02-07 | Madison | Virginia | 51113 | 511 | 6 |
1004574 | 1004574 | 2021-02-06 | Madison | Virginia | 51113 | 509 | 6 |
1001328 | 1001328 | 2021-02-05 | Madison | Virginia | 51113 | 499 | 6 |
998082 | 998082 | 2021-02-04 | Madison | Virginia | 51113 | 486 | 6 |
994836 | 994836 | 2021-02-03 | Madison | Virginia | 51113 | 486 | 6 |
991590 | 991590 | 2021-02-02 | Madison | Virginia | 51113 | 483 | 6 |
988344 | 988344 | 2021-02-01 | Madison | Virginia | 51113 | 481 | 6 |
985097 | 985097 | 2021-01-31 | Madison | Virginia | 51113 | 473 | 6 |
981850 | 981850 | 2021-01-30 | Madison | Virginia | 51113 | 471 | 6 |
978604 | 978604 | 2021-01-29 | Madison | Virginia | 51113 | 465 | 6 |
975359 | 975359 | 2021-01-28 | Madison | Virginia | 51113 | 458 | 6 |
972114 | 972114 | 2021-01-27 | Madison | Virginia | 51113 | 448 | 6 |
968869 | 968869 | 2021-01-26 | Madison | Virginia | 51113 | 438 | 6 |
965625 | 965625 | 2021-01-25 | Madison | Virginia | 51113 | 437 | 6 |
962380 | 962380 | 2021-01-24 | Madison | Virginia | 51113 | 433 | 6 |
959135 | 959135 | 2021-01-23 | Madison | Virginia | 51113 | 429 | 6 |
955889 | 955889 | 2021-01-22 | Madison | Virginia | 51113 | 416 | 5 |
952644 | 952644 | 2021-01-21 | Madison | Virginia | 51113 | 413 | 5 |
949399 | 949399 | 2021-01-20 | Madison | Virginia | 51113 | 406 | 5 |
946153 | 946153 | 2021-01-19 | Madison | Virginia | 51113 | 399 | 5 |
942906 | 942906 | 2021-01-18 | Madison | Virginia | 51113 | 397 | 5 |
939661 | 939661 | 2021-01-17 | Madison | Virginia | 51113 | 394 | 5 |
936416 | 936416 | 2021-01-16 | Madison | Virginia | 51113 | 389 | 5 |
933171 | 933171 | 2021-01-15 | Madison | Virginia | 51113 | 384 | 5 |
929926 | 929926 | 2021-01-14 | Madison | Virginia | 51113 | 382 | 5 |
926681 | 926681 | 2021-01-13 | Madison | Virginia | 51113 | 370 | 5 |
923435 | 923435 | 2021-01-12 | Madison | Virginia | 51113 | 364 | 5 |
920190 | 920190 | 2021-01-11 | Madison | Virginia | 51113 | 362 | 5 |
916945 | 916945 | 2021-01-10 | Madison | Virginia | 51113 | 356 | 5 |
913700 | 913700 | 2021-01-09 | Madison | Virginia | 51113 | 347 | 5 |
910455 | 910455 | 2021-01-08 | Madison | Virginia | 51113 | 340 | 4 |
907210 | 907210 | 2021-01-07 | Madison | Virginia | 51113 | 335 | 4 |
903964 | 903964 | 2021-01-06 | Madison | Virginia | 51113 | 328 | 4 |
900719 | 900719 | 2021-01-05 | Madison | Virginia | 51113 | 320 | 4 |
897474 | 897474 | 2021-01-04 | Madison | Virginia | 51113 | 319 | 4 |
894228 | 894228 | 2021-01-03 | Madison | Virginia | 51113 | 317 | 4 |
890982 | 890982 | 2021-01-02 | Madison | Virginia | 51113 | 303 | 4 |
887735 | 887735 | 2021-01-01 | Madison | Virginia | 51113 | 303 | 4 |
884490 | 884490 | 2020-12-31 | Madison | Virginia | 51113 | 299 | 4 |
881245 | 881245 | 2020-12-30 | Madison | Virginia | 51113 | 289 | 4 |
878000 | 878000 | 2020-12-29 | Madison | Virginia | 51113 | 283 | 4 |
874755 | 874755 | 2020-12-28 | Madison | Virginia | 51113 | 285 | 4 |
871510 | 871510 | 2020-12-27 | Madison | Virginia | 51113 | 285 | 4 |
868265 | 868265 | 2020-12-26 | Madison | Virginia | 51113 | 279 | 4 |
865020 | 865020 | 2020-12-25 | Madison | Virginia | 51113 | 280 | 4 |
861775 | 861775 | 2020-12-24 | Madison | Virginia | 51113 | 276 | 4 |
858530 | 858530 | 2020-12-23 | Madison | Virginia | 51113 | 265 | 4 |
855285 | 855285 | 2020-12-22 | Madison | Virginia | 51113 | 262 | 4 |
852040 | 852040 | 2020-12-21 | Madison | Virginia | 51113 | 258 | 4 |
848795 | 848795 | 2020-12-20 | Madison | Virginia | 51113 | 257 | 4 |
845550 | 845550 | 2020-12-19 | Madison | Virginia | 51113 | 254 | 4 |
842304 | 842304 | 2020-12-18 | Madison | Virginia | 51113 | 251 | 4 |
839059 | 839059 | 2020-12-17 | Madison | Virginia | 51113 | 249 | 4 |
835813 | 835813 | 2020-12-16 | Madison | Virginia | 51113 | 239 | 4 |
832567 | 832567 | 2020-12-15 | Madison | Virginia | 51113 | 238 | 4 |
829320 | 829320 | 2020-12-14 | Madison | Virginia | 51113 | 237 | 4 |
826074 | 826074 | 2020-12-13 | Madison | Virginia | 51113 | 232 | 4 |
822827 | 822827 | 2020-12-12 | Madison | Virginia | 51113 | 224 | 4 |
819581 | 819581 | 2020-12-11 | Madison | Virginia | 51113 | 224 | 4 |
816335 | 816335 | 2020-12-10 | Madison | Virginia | 51113 | 216 | 4 |
813089 | 813089 | 2020-12-09 | Madison | Virginia | 51113 | 216 | 4 |
809845 | 809845 | 2020-12-08 | Madison | Virginia | 51113 | 210 | 4 |
806600 | 806600 | 2020-12-07 | Madison | Virginia | 51113 | 205 | 4 |
803355 | 803355 | 2020-12-06 | Madison | Virginia | 51113 | 204 | 4 |
800110 | 800110 | 2020-12-05 | Madison | Virginia | 51113 | 200 | 4 |
796865 | 796865 | 2020-12-04 | Madison | Virginia | 51113 | 195 | 4 |
793620 | 793620 | 2020-12-03 | Madison | Virginia | 51113 | 194 | 4 |
790375 | 790375 | 2020-12-02 | Madison | Virginia | 51113 | 192 | 4 |
787130 | 787130 | 2020-12-01 | Madison | Virginia | 51113 | 191 | 4 |
783886 | 783886 | 2020-11-30 | Madison | Virginia | 51113 | 190 | 4 |
780641 | 780641 | 2020-11-29 | Madison | Virginia | 51113 | 189 | 4 |
777395 | 777395 | 2020-11-28 | Madison | Virginia | 51113 | 185 | 4 |
774150 | 774150 | 2020-11-27 | Madison | Virginia | 51113 | 185 | 4 |
770905 | 770905 | 2020-11-26 | Madison | Virginia | 51113 | 185 | 4 |
767659 | 767659 | 2020-11-25 | Madison | Virginia | 51113 | 183 | 4 |
764414 | 764414 | 2020-11-24 | Madison | Virginia | 51113 | 182 | 4 |
761169 | 761169 | 2020-11-23 | Madison | Virginia | 51113 | 182 | 4 |
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);