ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "York" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280601 | 1280601 | 2021-05-02 | York | Virginia | 51199 | 3697 | 52 |
1277354 | 1277354 | 2021-05-01 | York | Virginia | 51199 | 3696 | 52 |
1274107 | 1274107 | 2021-04-30 | York | Virginia | 51199 | 3689 | 52 |
1270860 | 1270860 | 2021-04-29 | York | Virginia | 51199 | 3685 | 52 |
1267613 | 1267613 | 2021-04-28 | York | Virginia | 51199 | 3674 | 52 |
1264366 | 1264366 | 2021-04-27 | York | Virginia | 51199 | 3665 | 52 |
1261119 | 1261119 | 2021-04-26 | York | Virginia | 51199 | 3654 | 52 |
1257872 | 1257872 | 2021-04-25 | York | Virginia | 51199 | 3647 | 52 |
1254625 | 1254625 | 2021-04-24 | York | Virginia | 51199 | 3643 | 52 |
1251378 | 1251378 | 2021-04-23 | York | Virginia | 51199 | 3639 | 52 |
1248131 | 1248131 | 2021-04-22 | York | Virginia | 51199 | 3632 | 52 |
1244884 | 1244884 | 2021-04-21 | York | Virginia | 51199 | 3622 | 52 |
1241637 | 1241637 | 2021-04-20 | York | Virginia | 51199 | 3619 | 52 |
1238390 | 1238390 | 2021-04-19 | York | Virginia | 51199 | 3608 | 50 |
1235143 | 1235143 | 2021-04-18 | York | Virginia | 51199 | 3604 | 50 |
1231895 | 1231895 | 2021-04-17 | York | Virginia | 51199 | 3597 | 50 |
1228647 | 1228647 | 2021-04-16 | York | Virginia | 51199 | 3588 | 50 |
1225399 | 1225399 | 2021-04-15 | York | Virginia | 51199 | 3581 | 50 |
1222152 | 1222152 | 2021-04-14 | York | Virginia | 51199 | 3575 | 50 |
1218904 | 1218904 | 2021-04-13 | York | Virginia | 51199 | 3565 | 50 |
1215656 | 1215656 | 2021-04-12 | York | Virginia | 51199 | 3554 | 50 |
1212409 | 1212409 | 2021-04-11 | York | Virginia | 51199 | 3552 | 50 |
1209160 | 1209160 | 2021-04-10 | York | Virginia | 51199 | 3547 | 50 |
1205912 | 1205912 | 2021-04-09 | York | Virginia | 51199 | 3540 | 50 |
1202664 | 1202664 | 2021-04-08 | York | Virginia | 51199 | 3533 | 50 |
1199416 | 1199416 | 2021-04-07 | York | Virginia | 51199 | 3525 | 50 |
1196167 | 1196167 | 2021-04-06 | York | Virginia | 51199 | 3513 | 50 |
1192919 | 1192919 | 2021-04-05 | York | Virginia | 51199 | 3500 | 50 |
1189669 | 1189669 | 2021-04-04 | York | Virginia | 51199 | 3489 | 50 |
1186422 | 1186422 | 2021-04-03 | York | Virginia | 51199 | 3483 | 50 |
1183175 | 1183175 | 2021-04-02 | York | Virginia | 51199 | 3469 | 50 |
1179928 | 1179928 | 2021-04-01 | York | Virginia | 51199 | 3458 | 50 |
1176681 | 1176681 | 2021-03-31 | York | Virginia | 51199 | 3439 | 50 |
1173434 | 1173434 | 2021-03-30 | York | Virginia | 51199 | 3430 | 50 |
1170187 | 1170187 | 2021-03-29 | York | Virginia | 51199 | 3411 | 50 |
1166939 | 1166939 | 2021-03-28 | York | Virginia | 51199 | 3403 | 50 |
1163691 | 1163691 | 2021-03-27 | York | Virginia | 51199 | 3393 | 50 |
1160443 | 1160443 | 2021-03-26 | York | Virginia | 51199 | 3376 | 50 |
1157195 | 1157195 | 2021-03-25 | York | Virginia | 51199 | 3367 | 50 |
1153948 | 1153948 | 2021-03-24 | York | Virginia | 51199 | 3354 | 50 |
1150701 | 1150701 | 2021-03-23 | York | Virginia | 51199 | 3345 | 50 |
1147454 | 1147454 | 2021-03-22 | York | Virginia | 51199 | 3331 | 50 |
1144207 | 1144207 | 2021-03-21 | York | Virginia | 51199 | 3326 | 50 |
1140960 | 1140960 | 2021-03-20 | York | Virginia | 51199 | 3323 | 50 |
1137714 | 1137714 | 2021-03-19 | York | Virginia | 51199 | 3305 | 50 |
1134468 | 1134468 | 2021-03-18 | York | Virginia | 51199 | 3286 | 50 |
1131220 | 1131220 | 2021-03-17 | York | Virginia | 51199 | 3271 | 49 |
1127973 | 1127973 | 2021-03-16 | York | Virginia | 51199 | 3238 | 48 |
1124727 | 1124727 | 2021-03-15 | York | Virginia | 51199 | 3220 | 47 |
1121481 | 1121481 | 2021-03-14 | York | Virginia | 51199 | 3205 | 46 |
1118234 | 1118234 | 2021-03-13 | York | Virginia | 51199 | 3200 | 44 |
1114987 | 1114987 | 2021-03-12 | York | Virginia | 51199 | 3180 | 44 |
1111741 | 1111741 | 2021-03-11 | York | Virginia | 51199 | 3163 | 44 |
1108495 | 1108495 | 2021-03-10 | York | Virginia | 51199 | 3152 | 43 |
1105249 | 1105249 | 2021-03-09 | York | Virginia | 51199 | 3130 | 42 |
1102003 | 1102003 | 2021-03-08 | York | Virginia | 51199 | 3122 | 41 |
1098757 | 1098757 | 2021-03-07 | York | Virginia | 51199 | 3114 | 39 |
1095509 | 1095509 | 2021-03-06 | York | Virginia | 51199 | 3104 | 39 |
1092263 | 1092263 | 2021-03-05 | York | Virginia | 51199 | 3082 | 38 |
1089017 | 1089017 | 2021-03-04 | York | Virginia | 51199 | 3059 | 38 |
1085772 | 1085772 | 2021-03-03 | York | Virginia | 51199 | 3054 | 38 |
1082526 | 1082526 | 2021-03-02 | York | Virginia | 51199 | 3037 | 35 |
1079280 | 1079280 | 2021-03-01 | York | Virginia | 51199 | 3011 | 33 |
1076035 | 1076035 | 2021-02-28 | York | Virginia | 51199 | 3008 | 30 |
1072789 | 1072789 | 2021-02-27 | York | Virginia | 51199 | 3000 | 30 |
1069543 | 1069543 | 2021-02-26 | York | Virginia | 51199 | 2990 | 30 |
1066298 | 1066298 | 2021-02-25 | York | Virginia | 51199 | 2984 | 29 |
1063053 | 1063053 | 2021-02-24 | York | Virginia | 51199 | 2967 | 29 |
1059808 | 1059808 | 2021-02-23 | York | Virginia | 51199 | 2952 | 27 |
1056562 | 1056562 | 2021-02-22 | York | Virginia | 51199 | 2932 | 26 |
1053316 | 1053316 | 2021-02-21 | York | Virginia | 51199 | 2924 | 23 |
1050069 | 1050069 | 2021-02-20 | York | Virginia | 51199 | 2897 | 21 |
1046822 | 1046822 | 2021-02-19 | York | Virginia | 51199 | 2895 | 22 |
1043577 | 1043577 | 2021-02-18 | York | Virginia | 51199 | 2878 | 22 |
1040332 | 1040332 | 2021-02-17 | York | Virginia | 51199 | 2872 | 22 |
1037087 | 1037087 | 2021-02-16 | York | Virginia | 51199 | 2849 | 22 |
1033842 | 1033842 | 2021-02-15 | York | Virginia | 51199 | 2840 | 21 |
1030596 | 1030596 | 2021-02-14 | York | Virginia | 51199 | 2832 | 21 |
1027349 | 1027349 | 2021-02-13 | York | Virginia | 51199 | 2809 | 21 |
1024104 | 1024104 | 2021-02-12 | York | Virginia | 51199 | 2790 | 21 |
1020859 | 1020859 | 2021-02-11 | York | Virginia | 51199 | 2774 | 21 |
1017614 | 1017614 | 2021-02-10 | York | Virginia | 51199 | 2755 | 21 |
1014369 | 1014369 | 2021-02-09 | York | Virginia | 51199 | 2743 | 21 |
1011124 | 1011124 | 2021-02-08 | York | Virginia | 51199 | 2728 | 19 |
1007878 | 1007878 | 2021-02-07 | York | Virginia | 51199 | 2701 | 18 |
1004632 | 1004632 | 2021-02-06 | York | Virginia | 51199 | 2672 | 18 |
1001386 | 1001386 | 2021-02-05 | York | Virginia | 51199 | 2643 | 17 |
998140 | 998140 | 2021-02-04 | York | Virginia | 51199 | 2602 | 17 |
994894 | 994894 | 2021-02-03 | York | Virginia | 51199 | 2592 | 16 |
991648 | 991648 | 2021-02-02 | York | Virginia | 51199 | 2574 | 16 |
988402 | 988402 | 2021-02-01 | York | Virginia | 51199 | 2559 | 16 |
985155 | 985155 | 2021-01-31 | York | Virginia | 51199 | 2548 | 16 |
981908 | 981908 | 2021-01-30 | York | Virginia | 51199 | 2534 | 16 |
978662 | 978662 | 2021-01-29 | York | Virginia | 51199 | 2514 | 16 |
975417 | 975417 | 2021-01-28 | York | Virginia | 51199 | 2485 | 16 |
972172 | 972172 | 2021-01-27 | York | Virginia | 51199 | 2448 | 16 |
968927 | 968927 | 2021-01-26 | York | Virginia | 51199 | 2397 | 16 |
965683 | 965683 | 2021-01-25 | York | Virginia | 51199 | 2347 | 16 |
962438 | 962438 | 2021-01-24 | York | Virginia | 51199 | 2287 | 16 |
959193 | 959193 | 2021-01-23 | York | Virginia | 51199 | 2253 | 16 |
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);