ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Pulaski" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280570 | 1280570 | 2021-05-02 | Pulaski | Virginia | 51155 | 2612 | 61 |
1277323 | 1277323 | 2021-05-01 | Pulaski | Virginia | 51155 | 2603 | 61 |
1274076 | 1274076 | 2021-04-30 | Pulaski | Virginia | 51155 | 2596 | 61 |
1270829 | 1270829 | 2021-04-29 | Pulaski | Virginia | 51155 | 2589 | 61 |
1267582 | 1267582 | 2021-04-28 | Pulaski | Virginia | 51155 | 2583 | 61 |
1264335 | 1264335 | 2021-04-27 | Pulaski | Virginia | 51155 | 2574 | 61 |
1261088 | 1261088 | 2021-04-26 | Pulaski | Virginia | 51155 | 2571 | 61 |
1257841 | 1257841 | 2021-04-25 | Pulaski | Virginia | 51155 | 2570 | 61 |
1254594 | 1254594 | 2021-04-24 | Pulaski | Virginia | 51155 | 2566 | 61 |
1251347 | 1251347 | 2021-04-23 | Pulaski | Virginia | 51155 | 2559 | 61 |
1248100 | 1248100 | 2021-04-22 | Pulaski | Virginia | 51155 | 2547 | 61 |
1244853 | 1244853 | 2021-04-21 | Pulaski | Virginia | 51155 | 2540 | 61 |
1241606 | 1241606 | 2021-04-20 | Pulaski | Virginia | 51155 | 2538 | 61 |
1238359 | 1238359 | 2021-04-19 | Pulaski | Virginia | 51155 | 2536 | 61 |
1235112 | 1235112 | 2021-04-18 | Pulaski | Virginia | 51155 | 2533 | 61 |
1231864 | 1231864 | 2021-04-17 | Pulaski | Virginia | 51155 | 2528 | 61 |
1228616 | 1228616 | 2021-04-16 | Pulaski | Virginia | 51155 | 2527 | 61 |
1225368 | 1225368 | 2021-04-15 | Pulaski | Virginia | 51155 | 2517 | 61 |
1222121 | 1222121 | 2021-04-14 | Pulaski | Virginia | 51155 | 2512 | 61 |
1218873 | 1218873 | 2021-04-13 | Pulaski | Virginia | 51155 | 2502 | 61 |
1215625 | 1215625 | 2021-04-12 | Pulaski | Virginia | 51155 | 2500 | 60 |
1212378 | 1212378 | 2021-04-11 | Pulaski | Virginia | 51155 | 2496 | 60 |
1209129 | 1209129 | 2021-04-10 | Pulaski | Virginia | 51155 | 2492 | 60 |
1205881 | 1205881 | 2021-04-09 | Pulaski | Virginia | 51155 | 2489 | 60 |
1202633 | 1202633 | 2021-04-08 | Pulaski | Virginia | 51155 | 2483 | 60 |
1199385 | 1199385 | 2021-04-07 | Pulaski | Virginia | 51155 | 2481 | 60 |
1196136 | 1196136 | 2021-04-06 | Pulaski | Virginia | 51155 | 2476 | 60 |
1192888 | 1192888 | 2021-04-05 | Pulaski | Virginia | 51155 | 2470 | 60 |
1189638 | 1189638 | 2021-04-04 | Pulaski | Virginia | 51155 | 2467 | 60 |
1186391 | 1186391 | 2021-04-03 | Pulaski | Virginia | 51155 | 2464 | 60 |
1183144 | 1183144 | 2021-04-02 | Pulaski | Virginia | 51155 | 2463 | 60 |
1179897 | 1179897 | 2021-04-01 | Pulaski | Virginia | 51155 | 2463 | 60 |
1176650 | 1176650 | 2021-03-31 | Pulaski | Virginia | 51155 | 2456 | 60 |
1173403 | 1173403 | 2021-03-30 | Pulaski | Virginia | 51155 | 2454 | 60 |
1170156 | 1170156 | 2021-03-29 | Pulaski | Virginia | 51155 | 2448 | 60 |
1166908 | 1166908 | 2021-03-28 | Pulaski | Virginia | 51155 | 2444 | 60 |
1163660 | 1163660 | 2021-03-27 | Pulaski | Virginia | 51155 | 2436 | 60 |
1160412 | 1160412 | 2021-03-26 | Pulaski | Virginia | 51155 | 2433 | 60 |
1157164 | 1157164 | 2021-03-25 | Pulaski | Virginia | 51155 | 2429 | 60 |
1153917 | 1153917 | 2021-03-24 | Pulaski | Virginia | 51155 | 2423 | 60 |
1150670 | 1150670 | 2021-03-23 | Pulaski | Virginia | 51155 | 2415 | 60 |
1147423 | 1147423 | 2021-03-22 | Pulaski | Virginia | 51155 | 2409 | 60 |
1144176 | 1144176 | 2021-03-21 | Pulaski | Virginia | 51155 | 2406 | 60 |
1140929 | 1140929 | 2021-03-20 | Pulaski | Virginia | 51155 | 2402 | 60 |
1137683 | 1137683 | 2021-03-19 | Pulaski | Virginia | 51155 | 2398 | 60 |
1134437 | 1134437 | 2021-03-18 | Pulaski | Virginia | 51155 | 2392 | 61 |
1131189 | 1131189 | 2021-03-17 | Pulaski | Virginia | 51155 | 2383 | 61 |
1127942 | 1127942 | 2021-03-16 | Pulaski | Virginia | 51155 | 2378 | 60 |
1124696 | 1124696 | 2021-03-15 | Pulaski | Virginia | 51155 | 2373 | 59 |
1121450 | 1121450 | 2021-03-14 | Pulaski | Virginia | 51155 | 2366 | 59 |
1118203 | 1118203 | 2021-03-13 | Pulaski | Virginia | 51155 | 2366 | 59 |
1114956 | 1114956 | 2021-03-12 | Pulaski | Virginia | 51155 | 2360 | 59 |
1111710 | 1111710 | 2021-03-11 | Pulaski | Virginia | 51155 | 2351 | 59 |
1108464 | 1108464 | 2021-03-10 | Pulaski | Virginia | 51155 | 2350 | 59 |
1105218 | 1105218 | 2021-03-09 | Pulaski | Virginia | 51155 | 2343 | 59 |
1101972 | 1101972 | 2021-03-08 | Pulaski | Virginia | 51155 | 2338 | 56 |
1098726 | 1098726 | 2021-03-07 | Pulaski | Virginia | 51155 | 2337 | 56 |
1095478 | 1095478 | 2021-03-06 | Pulaski | Virginia | 51155 | 2331 | 55 |
1092232 | 1092232 | 2021-03-05 | Pulaski | Virginia | 51155 | 2330 | 55 |
1088986 | 1088986 | 2021-03-04 | Pulaski | Virginia | 51155 | 2328 | 55 |
1085741 | 1085741 | 2021-03-03 | Pulaski | Virginia | 51155 | 2330 | 55 |
1082495 | 1082495 | 2021-03-02 | Pulaski | Virginia | 51155 | 2318 | 54 |
1079249 | 1079249 | 2021-03-01 | Pulaski | Virginia | 51155 | 2313 | 54 |
1076004 | 1076004 | 2021-02-28 | Pulaski | Virginia | 51155 | 2309 | 53 |
1072758 | 1072758 | 2021-02-27 | Pulaski | Virginia | 51155 | 2300 | 52 |
1069512 | 1069512 | 2021-02-26 | Pulaski | Virginia | 51155 | 2294 | 52 |
1066267 | 1066267 | 2021-02-25 | Pulaski | Virginia | 51155 | 2288 | 50 |
1063022 | 1063022 | 2021-02-24 | Pulaski | Virginia | 51155 | 2285 | 48 |
1059777 | 1059777 | 2021-02-23 | Pulaski | Virginia | 51155 | 2274 | 48 |
1056531 | 1056531 | 2021-02-22 | Pulaski | Virginia | 51155 | 2271 | 46 |
1053285 | 1053285 | 2021-02-21 | Pulaski | Virginia | 51155 | 2268 | 46 |
1050038 | 1050038 | 2021-02-20 | Pulaski | Virginia | 51155 | 2262 | 46 |
1046791 | 1046791 | 2021-02-19 | Pulaski | Virginia | 51155 | 2263 | 46 |
1043546 | 1043546 | 2021-02-18 | Pulaski | Virginia | 51155 | 2260 | 46 |
1040301 | 1040301 | 2021-02-17 | Pulaski | Virginia | 51155 | 2259 | 46 |
1037056 | 1037056 | 2021-02-16 | Pulaski | Virginia | 51155 | 2257 | 46 |
1033811 | 1033811 | 2021-02-15 | Pulaski | Virginia | 51155 | 2250 | 46 |
1030565 | 1030565 | 2021-02-14 | Pulaski | Virginia | 51155 | 2248 | 46 |
1027318 | 1027318 | 2021-02-13 | Pulaski | Virginia | 51155 | 2242 | 46 |
1024073 | 1024073 | 2021-02-12 | Pulaski | Virginia | 51155 | 2232 | 46 |
1020828 | 1020828 | 2021-02-11 | Pulaski | Virginia | 51155 | 2229 | 46 |
1017583 | 1017583 | 2021-02-10 | Pulaski | Virginia | 51155 | 2216 | 46 |
1014338 | 1014338 | 2021-02-09 | Pulaski | Virginia | 51155 | 2208 | 46 |
1011093 | 1011093 | 2021-02-08 | Pulaski | Virginia | 51155 | 2204 | 46 |
1007847 | 1007847 | 2021-02-07 | Pulaski | Virginia | 51155 | 2204 | 45 |
1004601 | 1004601 | 2021-02-06 | Pulaski | Virginia | 51155 | 2199 | 45 |
1001355 | 1001355 | 2021-02-05 | Pulaski | Virginia | 51155 | 2193 | 45 |
998109 | 998109 | 2021-02-04 | Pulaski | Virginia | 51155 | 2188 | 45 |
994863 | 994863 | 2021-02-03 | Pulaski | Virginia | 51155 | 2184 | 45 |
991617 | 991617 | 2021-02-02 | Pulaski | Virginia | 51155 | 2179 | 45 |
988371 | 988371 | 2021-02-01 | Pulaski | Virginia | 51155 | 2177 | 45 |
985124 | 985124 | 2021-01-31 | Pulaski | Virginia | 51155 | 2167 | 45 |
981877 | 981877 | 2021-01-30 | Pulaski | Virginia | 51155 | 2160 | 44 |
978631 | 978631 | 2021-01-29 | Pulaski | Virginia | 51155 | 2153 | 43 |
975386 | 975386 | 2021-01-28 | Pulaski | Virginia | 51155 | 2141 | 42 |
972141 | 972141 | 2021-01-27 | Pulaski | Virginia | 51155 | 2128 | 42 |
968896 | 968896 | 2021-01-26 | Pulaski | Virginia | 51155 | 2104 | 41 |
965652 | 965652 | 2021-01-25 | Pulaski | Virginia | 51155 | 2091 | 39 |
962407 | 962407 | 2021-01-24 | Pulaski | Virginia | 51155 | 2081 | 39 |
959162 | 959162 | 2021-01-23 | Pulaski | Virginia | 51155 | 2068 | 39 |
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);