ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Randolph" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638020 | 638020 | 2020-10-16 | Randolph | West Virginia | 54083 | 368 | 1 |
634775 | 634775 | 2020-10-15 | Randolph | West Virginia | 54083 | 360 | 1 |
631530 | 631530 | 2020-10-14 | Randolph | West Virginia | 54083 | 351 | 1 |
628286 | 628286 | 2020-10-13 | Randolph | West Virginia | 54083 | 338 | 1 |
625043 | 625043 | 2020-10-12 | Randolph | West Virginia | 54083 | 323 | 1 |
621800 | 621800 | 2020-10-11 | Randolph | West Virginia | 54083 | 321 | 1 |
618557 | 618557 | 2020-10-10 | Randolph | West Virginia | 54083 | 312 | 1 |
615315 | 615315 | 2020-10-09 | Randolph | West Virginia | 54083 | 303 | 1 |
612074 | 612074 | 2020-10-08 | Randolph | West Virginia | 54083 | 284 | 1 |
608832 | 608832 | 2020-10-07 | Randolph | West Virginia | 54083 | 281 | 1 |
605589 | 605589 | 2020-10-06 | Randolph | West Virginia | 54083 | 280 | 1 |
602347 | 602347 | 2020-10-05 | Randolph | West Virginia | 54083 | 270 | 1 |
599104 | 599104 | 2020-10-04 | Randolph | West Virginia | 54083 | 269 | 1 |
595861 | 595861 | 2020-10-03 | Randolph | West Virginia | 54083 | 268 | 1 |
592619 | 592619 | 2020-10-02 | Randolph | West Virginia | 54083 | 265 | 1 |
589379 | 589379 | 2020-10-01 | Randolph | West Virginia | 54083 | 259 | 1 |
586138 | 586138 | 2020-09-30 | Randolph | West Virginia | 54083 | 259 | 1 |
582898 | 582898 | 2020-09-29 | Randolph | West Virginia | 54083 | 256 | 1 |
579659 | 579659 | 2020-09-28 | Randolph | West Virginia | 54083 | 252 | 1 |
576418 | 576418 | 2020-09-27 | Randolph | West Virginia | 54083 | 252 | 1 |
573174 | 573174 | 2020-09-26 | Randolph | West Virginia | 54083 | 242 | 1 |
569932 | 569932 | 2020-09-25 | Randolph | West Virginia | 54083 | 240 | 1 |
566691 | 566691 | 2020-09-24 | Randolph | West Virginia | 54083 | 240 | 1 |
563450 | 563450 | 2020-09-23 | Randolph | West Virginia | 54083 | 237 | 1 |
560211 | 560211 | 2020-09-22 | Randolph | West Virginia | 54083 | 237 | 1 |
556975 | 556975 | 2020-09-21 | Randolph | West Virginia | 54083 | 236 | 1 |
553738 | 553738 | 2020-09-20 | Randolph | West Virginia | 54083 | 234 | 1 |
550499 | 550499 | 2020-09-19 | Randolph | West Virginia | 54083 | 234 | 1 |
547260 | 547260 | 2020-09-18 | Randolph | West Virginia | 54083 | 233 | 1 |
544023 | 544023 | 2020-09-17 | Randolph | West Virginia | 54083 | 233 | 1 |
540787 | 540787 | 2020-09-16 | Randolph | West Virginia | 54083 | 231 | 1 |
537550 | 537550 | 2020-09-15 | Randolph | West Virginia | 54083 | 230 | 1 |
534314 | 534314 | 2020-09-14 | Randolph | West Virginia | 54083 | 230 | 1 |
531079 | 531079 | 2020-09-13 | Randolph | West Virginia | 54083 | 230 | 2 |
527842 | 527842 | 2020-09-12 | Randolph | West Virginia | 54083 | 230 | 2 |
524606 | 524606 | 2020-09-11 | Randolph | West Virginia | 54083 | 229 | 2 |
521370 | 521370 | 2020-09-10 | Randolph | West Virginia | 54083 | 228 | 2 |
518133 | 518133 | 2020-09-09 | Randolph | West Virginia | 54083 | 228 | 2 |
514898 | 514898 | 2020-09-08 | Randolph | West Virginia | 54083 | 228 | 1 |
511665 | 511665 | 2020-09-07 | Randolph | West Virginia | 54083 | 228 | 1 |
508432 | 508432 | 2020-09-06 | Randolph | West Virginia | 54083 | 228 | 1 |
505200 | 505200 | 2020-09-05 | Randolph | West Virginia | 54083 | 227 | 1 |
501966 | 501966 | 2020-09-04 | Randolph | West Virginia | 54083 | 227 | 1 |
498732 | 498732 | 2020-09-03 | Randolph | West Virginia | 54083 | 227 | 1 |
495499 | 495499 | 2020-09-02 | Randolph | West Virginia | 54083 | 227 | 0 |
492265 | 492265 | 2020-09-01 | Randolph | West Virginia | 54083 | 226 | 0 |
489032 | 489032 | 2020-08-31 | Randolph | West Virginia | 54083 | 224 | 0 |
485799 | 485799 | 2020-08-30 | Randolph | West Virginia | 54083 | 223 | 0 |
482564 | 482564 | 2020-08-29 | Randolph | West Virginia | 54083 | 222 | 0 |
479330 | 479330 | 2020-08-28 | Randolph | West Virginia | 54083 | 221 | 0 |
476097 | 476097 | 2020-08-27 | Randolph | West Virginia | 54083 | 221 | 0 |
472864 | 472864 | 2020-08-26 | Randolph | West Virginia | 54083 | 220 | 0 |
469632 | 469632 | 2020-08-25 | Randolph | West Virginia | 54083 | 221 | 0 |
466403 | 466403 | 2020-08-24 | Randolph | West Virginia | 54083 | 219 | 0 |
463174 | 463174 | 2020-08-23 | Randolph | West Virginia | 54083 | 220 | 0 |
459945 | 459945 | 2020-08-22 | Randolph | West Virginia | 54083 | 219 | 0 |
456718 | 456718 | 2020-08-21 | Randolph | West Virginia | 54083 | 218 | 0 |
453490 | 453490 | 2020-08-20 | Randolph | West Virginia | 54083 | 218 | 0 |
450262 | 450262 | 2020-08-19 | Randolph | West Virginia | 54083 | 218 | 0 |
447034 | 447034 | 2020-08-18 | Randolph | West Virginia | 54083 | 217 | 0 |
443807 | 443807 | 2020-08-17 | Randolph | West Virginia | 54083 | 213 | 0 |
440581 | 440581 | 2020-08-16 | Randolph | West Virginia | 54083 | 214 | 0 |
437355 | 437355 | 2020-08-15 | Randolph | West Virginia | 54083 | 213 | 0 |
434129 | 434129 | 2020-08-14 | Randolph | West Virginia | 54083 | 213 | 0 |
430904 | 430904 | 2020-08-13 | Randolph | West Virginia | 54083 | 212 | 0 |
427676 | 427676 | 2020-08-12 | Randolph | West Virginia | 54083 | 211 | 0 |
424452 | 424452 | 2020-08-11 | Randolph | West Virginia | 54083 | 211 | 0 |
421231 | 421231 | 2020-08-10 | Randolph | West Virginia | 54083 | 210 | 0 |
418010 | 418010 | 2020-08-09 | Randolph | West Virginia | 54083 | 210 | 0 |
414789 | 414789 | 2020-08-08 | Randolph | West Virginia | 54083 | 208 | 0 |
411569 | 411569 | 2020-08-07 | Randolph | West Virginia | 54083 | 208 | 0 |
408350 | 408350 | 2020-08-06 | Randolph | West Virginia | 54083 | 206 | 0 |
405130 | 405130 | 2020-08-05 | Randolph | West Virginia | 54083 | 206 | 0 |
401912 | 401912 | 2020-08-04 | Randolph | West Virginia | 54083 | 206 | 0 |
398696 | 398696 | 2020-08-03 | Randolph | West Virginia | 54083 | 205 | 0 |
395480 | 395480 | 2020-08-02 | Randolph | West Virginia | 54083 | 207 | 0 |
392264 | 392264 | 2020-08-01 | Randolph | West Virginia | 54083 | 207 | 0 |
389047 | 389047 | 2020-07-31 | Randolph | West Virginia | 54083 | 207 | 0 |
385830 | 385830 | 2020-07-30 | Randolph | West Virginia | 54083 | 206 | 0 |
382612 | 382612 | 2020-07-29 | Randolph | West Virginia | 54083 | 206 | 0 |
379395 | 379395 | 2020-07-28 | Randolph | West Virginia | 54083 | 206 | 0 |
376179 | 376179 | 2020-07-27 | Randolph | West Virginia | 54083 | 206 | 0 |
372965 | 372965 | 2020-07-26 | Randolph | West Virginia | 54083 | 206 | 0 |
369753 | 369753 | 2020-07-25 | Randolph | West Virginia | 54083 | 205 | 0 |
366543 | 366543 | 2020-07-24 | Randolph | West Virginia | 54083 | 205 | 0 |
363336 | 363336 | 2020-07-23 | Randolph | West Virginia | 54083 | 202 | 0 |
360130 | 360130 | 2020-07-22 | Randolph | West Virginia | 54083 | 203 | 0 |
356925 | 356925 | 2020-07-21 | Randolph | West Virginia | 54083 | 202 | 0 |
353722 | 353722 | 2020-07-20 | Randolph | West Virginia | 54083 | 201 | 0 |
350520 | 350520 | 2020-07-19 | Randolph | West Virginia | 54083 | 198 | 0 |
347319 | 347319 | 2020-07-18 | Randolph | West Virginia | 54083 | 198 | 0 |
344119 | 344119 | 2020-07-17 | Randolph | West Virginia | 54083 | 198 | 0 |
340920 | 340920 | 2020-07-16 | Randolph | West Virginia | 54083 | 195 | 0 |
337724 | 337724 | 2020-07-15 | Randolph | West Virginia | 54083 | 194 | 0 |
334529 | 334529 | 2020-07-14 | Randolph | West Virginia | 54083 | 191 | 0 |
331336 | 331336 | 2020-07-13 | Randolph | West Virginia | 54083 | 190 | 0 |
328150 | 328150 | 2020-07-12 | Randolph | West Virginia | 54083 | 189 | 0 |
324964 | 324964 | 2020-07-11 | Randolph | West Virginia | 54083 | 187 | 0 |
321783 | 321783 | 2020-07-10 | Randolph | West Virginia | 54083 | 186 | 0 |
318604 | 318604 | 2020-07-09 | Randolph | West Virginia | 54083 | 176 | 0 |
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);