ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51540 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280492 | 1280492 | 2021-05-02 | Charlottesville city | Virginia | 51540 | 4017 | 55 |
1277245 | 1277245 | 2021-05-01 | Charlottesville city | Virginia | 51540 | 4012 | 55 |
1273998 | 1273998 | 2021-04-30 | Charlottesville city | Virginia | 51540 | 4007 | 55 |
1270751 | 1270751 | 2021-04-29 | Charlottesville city | Virginia | 51540 | 3999 | 55 |
1267504 | 1267504 | 2021-04-28 | Charlottesville city | Virginia | 51540 | 3994 | 55 |
1264257 | 1264257 | 2021-04-27 | Charlottesville city | Virginia | 51540 | 3993 | 55 |
1261010 | 1261010 | 2021-04-26 | Charlottesville city | Virginia | 51540 | 3987 | 55 |
1257763 | 1257763 | 2021-04-25 | Charlottesville city | Virginia | 51540 | 3986 | 55 |
1254516 | 1254516 | 2021-04-24 | Charlottesville city | Virginia | 51540 | 3979 | 55 |
1251269 | 1251269 | 2021-04-23 | Charlottesville city | Virginia | 51540 | 3973 | 55 |
1248022 | 1248022 | 2021-04-22 | Charlottesville city | Virginia | 51540 | 3968 | 55 |
1244775 | 1244775 | 2021-04-21 | Charlottesville city | Virginia | 51540 | 3959 | 55 |
1241528 | 1241528 | 2021-04-20 | Charlottesville city | Virginia | 51540 | 3994 | 55 |
1238281 | 1238281 | 2021-04-19 | Charlottesville city | Virginia | 51540 | 3992 | 55 |
1235034 | 1235034 | 2021-04-18 | Charlottesville city | Virginia | 51540 | 3991 | 55 |
1231786 | 1231786 | 2021-04-17 | Charlottesville city | Virginia | 51540 | 3980 | 55 |
1228538 | 1228538 | 2021-04-16 | Charlottesville city | Virginia | 51540 | 3975 | 55 |
1225290 | 1225290 | 2021-04-15 | Charlottesville city | Virginia | 51540 | 3960 | 55 |
1222043 | 1222043 | 2021-04-14 | Charlottesville city | Virginia | 51540 | 3950 | 55 |
1218795 | 1218795 | 2021-04-13 | Charlottesville city | Virginia | 51540 | 3936 | 55 |
1215547 | 1215547 | 2021-04-12 | Charlottesville city | Virginia | 51540 | 3927 | 55 |
1212300 | 1212300 | 2021-04-11 | Charlottesville city | Virginia | 51540 | 3927 | 55 |
1209051 | 1209051 | 2021-04-10 | Charlottesville city | Virginia | 51540 | 3927 | 55 |
1205803 | 1205803 | 2021-04-09 | Charlottesville city | Virginia | 51540 | 3922 | 55 |
1202555 | 1202555 | 2021-04-08 | Charlottesville city | Virginia | 51540 | 3915 | 55 |
1199307 | 1199307 | 2021-04-07 | Charlottesville city | Virginia | 51540 | 3911 | 55 |
1196058 | 1196058 | 2021-04-06 | Charlottesville city | Virginia | 51540 | 3895 | 55 |
1192810 | 1192810 | 2021-04-05 | Charlottesville city | Virginia | 51540 | 3890 | 55 |
1189560 | 1189560 | 2021-04-04 | Charlottesville city | Virginia | 51540 | 3888 | 55 |
1186313 | 1186313 | 2021-04-03 | Charlottesville city | Virginia | 51540 | 3880 | 53 |
1183066 | 1183066 | 2021-04-02 | Charlottesville city | Virginia | 51540 | 3860 | 53 |
1179819 | 1179819 | 2021-04-01 | Charlottesville city | Virginia | 51540 | 3845 | 53 |
1176572 | 1176572 | 2021-03-31 | Charlottesville city | Virginia | 51540 | 3834 | 53 |
1173325 | 1173325 | 2021-03-30 | Charlottesville city | Virginia | 51540 | 3824 | 53 |
1170078 | 1170078 | 2021-03-29 | Charlottesville city | Virginia | 51540 | 3819 | 53 |
1166830 | 1166830 | 2021-03-28 | Charlottesville city | Virginia | 51540 | 3814 | 53 |
1163582 | 1163582 | 2021-03-27 | Charlottesville city | Virginia | 51540 | 3808 | 53 |
1160334 | 1160334 | 2021-03-26 | Charlottesville city | Virginia | 51540 | 3800 | 53 |
1157086 | 1157086 | 2021-03-25 | Charlottesville city | Virginia | 51540 | 3800 | 53 |
1153839 | 1153839 | 2021-03-24 | Charlottesville city | Virginia | 51540 | 3789 | 53 |
1150592 | 1150592 | 2021-03-23 | Charlottesville city | Virginia | 51540 | 3771 | 53 |
1147345 | 1147345 | 2021-03-22 | Charlottesville city | Virginia | 51540 | 3765 | 53 |
1144098 | 1144098 | 2021-03-21 | Charlottesville city | Virginia | 51540 | 3760 | 53 |
1140851 | 1140851 | 2021-03-20 | Charlottesville city | Virginia | 51540 | 3755 | 53 |
1137605 | 1137605 | 2021-03-19 | Charlottesville city | Virginia | 51540 | 3752 | 53 |
1134359 | 1134359 | 2021-03-18 | Charlottesville city | Virginia | 51540 | 3745 | 52 |
1131111 | 1131111 | 2021-03-17 | Charlottesville city | Virginia | 51540 | 3738 | 49 |
1127864 | 1127864 | 2021-03-16 | Charlottesville city | Virginia | 51540 | 3730 | 49 |
1124618 | 1124618 | 2021-03-15 | Charlottesville city | Virginia | 51540 | 3723 | 48 |
1121372 | 1121372 | 2021-03-14 | Charlottesville city | Virginia | 51540 | 3720 | 47 |
1118125 | 1118125 | 2021-03-13 | Charlottesville city | Virginia | 51540 | 3711 | 47 |
1114878 | 1114878 | 2021-03-12 | Charlottesville city | Virginia | 51540 | 3702 | 47 |
1111632 | 1111632 | 2021-03-11 | Charlottesville city | Virginia | 51540 | 3697 | 47 |
1108386 | 1108386 | 2021-03-10 | Charlottesville city | Virginia | 51540 | 3689 | 46 |
1105140 | 1105140 | 2021-03-09 | Charlottesville city | Virginia | 51540 | 3679 | 46 |
1101894 | 1101894 | 2021-03-08 | Charlottesville city | Virginia | 51540 | 3677 | 46 |
1098648 | 1098648 | 2021-03-07 | Charlottesville city | Virginia | 51540 | 3672 | 45 |
1095400 | 1095400 | 2021-03-06 | Charlottesville city | Virginia | 51540 | 3669 | 45 |
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 |
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);