ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Charlottesville 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 |
---|---|---|---|---|---|---|---|
1092154 | 1092154 | 2021-03-05 | Charlottesville city | Virginia | 51540 | 3663 | 46 |
1088908 | 1088908 | 2021-03-04 | Charlottesville city | Virginia | 51540 | 3660 | 46 |
1085663 | 1085663 | 2021-03-03 | Charlottesville city | Virginia | 51540 | 3662 | 47 |
1082417 | 1082417 | 2021-03-02 | Charlottesville city | Virginia | 51540 | 3636 | 47 |
1079171 | 1079171 | 2021-03-01 | Charlottesville city | Virginia | 51540 | 3642 | 45 |
1075926 | 1075926 | 2021-02-28 | Charlottesville city | Virginia | 51540 | 3624 | 44 |
1072680 | 1072680 | 2021-02-27 | Charlottesville city | Virginia | 51540 | 3602 | 43 |
1069434 | 1069434 | 2021-02-26 | Charlottesville city | Virginia | 51540 | 3574 | 41 |
1066189 | 1066189 | 2021-02-25 | Charlottesville city | Virginia | 51540 | 3550 | 41 |
1062944 | 1062944 | 2021-02-24 | Charlottesville city | Virginia | 51540 | 3529 | 41 |
1059699 | 1059699 | 2021-02-23 | Charlottesville city | Virginia | 51540 | 3519 | 41 |
1056453 | 1056453 | 2021-02-22 | Charlottesville city | Virginia | 51540 | 3519 | 40 |
1053207 | 1053207 | 2021-02-21 | Charlottesville city | Virginia | 51540 | 3508 | 40 |
1049960 | 1049960 | 2021-02-20 | Charlottesville city | Virginia | 51540 | 3434 | 40 |
1046713 | 1046713 | 2021-02-19 | Charlottesville city | Virginia | 51540 | 3374 | 40 |
1043468 | 1043468 | 2021-02-18 | Charlottesville city | Virginia | 51540 | 3267 | 40 |
1040223 | 1040223 | 2021-02-17 | Charlottesville city | Virginia | 51540 | 3168 | 40 |
1036978 | 1036978 | 2021-02-16 | Charlottesville city | Virginia | 51540 | 3088 | 40 |
1033733 | 1033733 | 2021-02-15 | Charlottesville city | Virginia | 51540 | 3073 | 40 |
1030487 | 1030487 | 2021-02-14 | Charlottesville city | Virginia | 51540 | 3060 | 40 |
1027240 | 1027240 | 2021-02-13 | Charlottesville city | Virginia | 51540 | 3017 | 40 |
1023995 | 1023995 | 2021-02-12 | Charlottesville city | Virginia | 51540 | 2969 | 40 |
1020750 | 1020750 | 2021-02-11 | Charlottesville city | Virginia | 51540 | 2927 | 40 |
1017505 | 1017505 | 2021-02-10 | Charlottesville city | Virginia | 51540 | 2883 | 40 |
1014260 | 1014260 | 2021-02-09 | Charlottesville city | Virginia | 51540 | 2836 | 40 |
1011015 | 1011015 | 2021-02-08 | Charlottesville city | Virginia | 51540 | 2826 | 40 |
1007769 | 1007769 | 2021-02-07 | Charlottesville city | Virginia | 51540 | 2820 | 40 |
1004523 | 1004523 | 2021-02-06 | Charlottesville city | Virginia | 51540 | 2807 | 40 |
1001277 | 1001277 | 2021-02-05 | Charlottesville city | Virginia | 51540 | 2791 | 40 |
998031 | 998031 | 2021-02-04 | Charlottesville city | Virginia | 51540 | 2761 | 39 |
994785 | 994785 | 2021-02-03 | Charlottesville city | Virginia | 51540 | 2752 | 39 |
991539 | 991539 | 2021-02-02 | Charlottesville city | Virginia | 51540 | 2750 | 39 |
988293 | 988293 | 2021-02-01 | Charlottesville city | Virginia | 51540 | 2743 | 39 |
985046 | 985046 | 2021-01-31 | Charlottesville city | Virginia | 51540 | 2740 | 39 |
981799 | 981799 | 2021-01-30 | Charlottesville city | Virginia | 51540 | 2728 | 39 |
978553 | 978553 | 2021-01-29 | Charlottesville city | Virginia | 51540 | 2713 | 39 |
975308 | 975308 | 2021-01-28 | Charlottesville city | Virginia | 51540 | 2697 | 39 |
972063 | 972063 | 2021-01-27 | Charlottesville city | Virginia | 51540 | 2681 | 38 |
968818 | 968818 | 2021-01-26 | Charlottesville city | Virginia | 51540 | 2662 | 37 |
965574 | 965574 | 2021-01-25 | Charlottesville city | Virginia | 51540 | 2651 | 37 |
962329 | 962329 | 2021-01-24 | Charlottesville city | Virginia | 51540 | 2639 | 37 |
959084 | 959084 | 2021-01-23 | Charlottesville city | Virginia | 51540 | 2638 | 38 |
955838 | 955838 | 2021-01-22 | Charlottesville city | Virginia | 51540 | 2628 | 37 |
952593 | 952593 | 2021-01-21 | Charlottesville city | Virginia | 51540 | 2621 | 37 |
949348 | 949348 | 2021-01-20 | Charlottesville city | Virginia | 51540 | 2604 | 35 |
946102 | 946102 | 2021-01-19 | Charlottesville city | Virginia | 51540 | 2586 | 35 |
942855 | 942855 | 2021-01-18 | Charlottesville city | Virginia | 51540 | 2581 | 35 |
939610 | 939610 | 2021-01-17 | Charlottesville city | Virginia | 51540 | 2560 | 35 |
936365 | 936365 | 2021-01-16 | Charlottesville city | Virginia | 51540 | 2534 | 35 |
933120 | 933120 | 2021-01-15 | Charlottesville city | Virginia | 51540 | 2523 | 35 |
929875 | 929875 | 2021-01-14 | Charlottesville city | Virginia | 51540 | 2502 | 35 |
926630 | 926630 | 2021-01-13 | Charlottesville city | Virginia | 51540 | 2482 | 35 |
923384 | 923384 | 2021-01-12 | Charlottesville city | Virginia | 51540 | 2459 | 34 |
920139 | 920139 | 2021-01-11 | Charlottesville city | Virginia | 51540 | 2452 | 34 |
916894 | 916894 | 2021-01-10 | Charlottesville city | Virginia | 51540 | 2441 | 34 |
913649 | 913649 | 2021-01-09 | Charlottesville city | Virginia | 51540 | 2409 | 34 |
910404 | 910404 | 2021-01-08 | Charlottesville city | Virginia | 51540 | 2373 | 34 |
907159 | 907159 | 2021-01-07 | Charlottesville city | Virginia | 51540 | 2339 | 34 |
903913 | 903913 | 2021-01-06 | Charlottesville city | Virginia | 51540 | 2303 | 34 |
900668 | 900668 | 2021-01-05 | Charlottesville city | Virginia | 51540 | 2257 | 34 |
897423 | 897423 | 2021-01-04 | Charlottesville city | Virginia | 51540 | 2250 | 34 |
894177 | 894177 | 2021-01-03 | Charlottesville city | Virginia | 51540 | 2244 | 34 |
890931 | 890931 | 2021-01-02 | Charlottesville city | Virginia | 51540 | 2233 | 34 |
887684 | 887684 | 2021-01-01 | Charlottesville city | Virginia | 51540 | 2222 | 34 |
884439 | 884439 | 2020-12-31 | Charlottesville city | Virginia | 51540 | 2203 | 34 |
881194 | 881194 | 2020-12-30 | Charlottesville city | Virginia | 51540 | 2182 | 34 |
877949 | 877949 | 2020-12-29 | Charlottesville city | Virginia | 51540 | 2165 | 34 |
874704 | 874704 | 2020-12-28 | Charlottesville city | Virginia | 51540 | 2159 | 34 |
871459 | 871459 | 2020-12-27 | Charlottesville city | Virginia | 51540 | 2147 | 34 |
868214 | 868214 | 2020-12-26 | Charlottesville city | Virginia | 51540 | 2136 | 35 |
864969 | 864969 | 2020-12-25 | Charlottesville city | Virginia | 51540 | 2135 | 35 |
861724 | 861724 | 2020-12-24 | Charlottesville city | Virginia | 51540 | 2121 | 35 |
858479 | 858479 | 2020-12-23 | Charlottesville city | Virginia | 51540 | 2108 | 35 |
855234 | 855234 | 2020-12-22 | Charlottesville city | Virginia | 51540 | 2089 | 34 |
851989 | 851989 | 2020-12-21 | Charlottesville city | Virginia | 51540 | 2086 | 34 |
848744 | 848744 | 2020-12-20 | Charlottesville city | Virginia | 51540 | 2081 | 34 |
845499 | 845499 | 2020-12-19 | Charlottesville city | Virginia | 51540 | 2062 | 34 |
842253 | 842253 | 2020-12-18 | Charlottesville city | Virginia | 51540 | 2050 | 33 |
839008 | 839008 | 2020-12-17 | Charlottesville city | Virginia | 51540 | 2048 | 32 |
835762 | 835762 | 2020-12-16 | Charlottesville city | Virginia | 51540 | 2036 | 31 |
832516 | 832516 | 2020-12-15 | Charlottesville city | Virginia | 51540 | 2030 | 31 |
829269 | 829269 | 2020-12-14 | Charlottesville city | Virginia | 51540 | 2022 | 31 |
826023 | 826023 | 2020-12-13 | Charlottesville city | Virginia | 51540 | 2008 | 31 |
822776 | 822776 | 2020-12-12 | Charlottesville city | Virginia | 51540 | 2003 | 31 |
819530 | 819530 | 2020-12-11 | Charlottesville city | Virginia | 51540 | 1977 | 31 |
816284 | 816284 | 2020-12-10 | Charlottesville city | Virginia | 51540 | 1965 | 31 |
813038 | 813038 | 2020-12-09 | Charlottesville city | Virginia | 51540 | 1958 | 31 |
809794 | 809794 | 2020-12-08 | Charlottesville city | Virginia | 51540 | 1946 | 31 |
806549 | 806549 | 2020-12-07 | Charlottesville city | Virginia | 51540 | 1940 | 31 |
803304 | 803304 | 2020-12-06 | Charlottesville city | Virginia | 51540 | 1925 | 31 |
800059 | 800059 | 2020-12-05 | Charlottesville city | Virginia | 51540 | 1908 | 31 |
796814 | 796814 | 2020-12-04 | Charlottesville city | Virginia | 51540 | 1890 | 31 |
793569 | 793569 | 2020-12-03 | Charlottesville city | Virginia | 51540 | 1872 | 31 |
790324 | 790324 | 2020-12-02 | Charlottesville city | Virginia | 51540 | 1864 | 31 |
787079 | 787079 | 2020-12-01 | Charlottesville city | Virginia | 51540 | 1860 | 31 |
783835 | 783835 | 2020-11-30 | Charlottesville city | Virginia | 51540 | 1854 | 31 |
780590 | 780590 | 2020-11-29 | Charlottesville city | Virginia | 51540 | 1848 | 31 |
777344 | 777344 | 2020-11-28 | Charlottesville city | Virginia | 51540 | 1848 | 31 |
774099 | 774099 | 2020-11-27 | Charlottesville city | Virginia | 51540 | 1847 | 31 |
770854 | 770854 | 2020-11-26 | Charlottesville city | Virginia | 51540 | 1835 | 31 |
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);