ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
286803 | 286803 | 2020-06-29 | Franklin | Virginia | 51067 | 72 | 1 |
289953 | 289953 | 2020-06-30 | Franklin | Virginia | 51067 | 88 | 1 |
293106 | 293106 | 2020-07-01 | Franklin | Virginia | 51067 | 91 | 1 |
296261 | 296261 | 2020-07-02 | Franklin | Virginia | 51067 | 92 | 1 |
299423 | 299423 | 2020-07-03 | Franklin | Virginia | 51067 | 92 | 1 |
302587 | 302587 | 2020-07-04 | Franklin | Virginia | 51067 | 92 | 1 |
305751 | 305751 | 2020-07-05 | Franklin | Virginia | 51067 | 96 | 1 |
308919 | 308919 | 2020-07-06 | Franklin | Virginia | 51067 | 104 | 1 |
312088 | 312088 | 2020-07-07 | Franklin | Virginia | 51067 | 104 | 1 |
315263 | 315263 | 2020-07-08 | Franklin | Virginia | 51067 | 104 | 1 |
318436 | 318436 | 2020-07-09 | Franklin | Virginia | 51067 | 106 | 1 |
321615 | 321615 | 2020-07-10 | Franklin | Virginia | 51067 | 105 | 1 |
324796 | 324796 | 2020-07-11 | Franklin | Virginia | 51067 | 106 | 1 |
327981 | 327981 | 2020-07-12 | Franklin | Virginia | 51067 | 106 | 1 |
331167 | 331167 | 2020-07-13 | Franklin | Virginia | 51067 | 106 | 1 |
334360 | 334360 | 2020-07-14 | Franklin | Virginia | 51067 | 114 | 1 |
337555 | 337555 | 2020-07-15 | Franklin | Virginia | 51067 | 115 | 1 |
340751 | 340751 | 2020-07-16 | Franklin | Virginia | 51067 | 117 | 1 |
343950 | 343950 | 2020-07-17 | Franklin | Virginia | 51067 | 117 | 1 |
347150 | 347150 | 2020-07-18 | Franklin | Virginia | 51067 | 117 | 1 |
350351 | 350351 | 2020-07-19 | Franklin | Virginia | 51067 | 117 | 1 |
353553 | 353553 | 2020-07-20 | Franklin | Virginia | 51067 | 117 | 1 |
356756 | 356756 | 2020-07-21 | Franklin | Virginia | 51067 | 125 | 1 |
359961 | 359961 | 2020-07-22 | Franklin | Virginia | 51067 | 132 | 1 |
363167 | 363167 | 2020-07-23 | Franklin | Virginia | 51067 | 132 | 1 |
366373 | 366373 | 2020-07-24 | Franklin | Virginia | 51067 | 137 | 1 |
369582 | 369582 | 2020-07-25 | Franklin | Virginia | 51067 | 138 | 1 |
372794 | 372794 | 2020-07-26 | Franklin | Virginia | 51067 | 141 | 1 |
376008 | 376008 | 2020-07-27 | Franklin | Virginia | 51067 | 141 | 1 |
379224 | 379224 | 2020-07-28 | Franklin | Virginia | 51067 | 146 | 1 |
382441 | 382441 | 2020-07-29 | Franklin | Virginia | 51067 | 150 | 1 |
385659 | 385659 | 2020-07-30 | Franklin | Virginia | 51067 | 150 | 1 |
388876 | 388876 | 2020-07-31 | Franklin | Virginia | 51067 | 151 | 1 |
392093 | 392093 | 2020-08-01 | Franklin | Virginia | 51067 | 156 | 1 |
395309 | 395309 | 2020-08-02 | Franklin | Virginia | 51067 | 160 | 1 |
398525 | 398525 | 2020-08-03 | Franklin | Virginia | 51067 | 160 | 1 |
401741 | 401741 | 2020-08-04 | Franklin | Virginia | 51067 | 164 | 1 |
404959 | 404959 | 2020-08-05 | Franklin | Virginia | 51067 | 163 | 1 |
408179 | 408179 | 2020-08-06 | Franklin | Virginia | 51067 | 163 | 1 |
411398 | 411398 | 2020-08-07 | Franklin | Virginia | 51067 | 168 | 1 |
414618 | 414618 | 2020-08-08 | Franklin | Virginia | 51067 | 168 | 1 |
417839 | 417839 | 2020-08-09 | Franklin | Virginia | 51067 | 172 | 1 |
421060 | 421060 | 2020-08-10 | Franklin | Virginia | 51067 | 175 | 1 |
424281 | 424281 | 2020-08-11 | Franklin | Virginia | 51067 | 175 | 1 |
427505 | 427505 | 2020-08-12 | Franklin | Virginia | 51067 | 176 | 1 |
430733 | 430733 | 2020-08-13 | Franklin | Virginia | 51067 | 177 | 1 |
433958 | 433958 | 2020-08-14 | Franklin | Virginia | 51067 | 179 | 1 |
437184 | 437184 | 2020-08-15 | Franklin | Virginia | 51067 | 182 | 1 |
440410 | 440410 | 2020-08-16 | Franklin | Virginia | 51067 | 182 | 1 |
443636 | 443636 | 2020-08-17 | Franklin | Virginia | 51067 | 182 | 1 |
446863 | 446863 | 2020-08-18 | Franklin | Virginia | 51067 | 192 | 1 |
450091 | 450091 | 2020-08-19 | Franklin | Virginia | 51067 | 194 | 1 |
453319 | 453319 | 2020-08-20 | Franklin | Virginia | 51067 | 197 | 1 |
456547 | 456547 | 2020-08-21 | Franklin | Virginia | 51067 | 197 | 1 |
459774 | 459774 | 2020-08-22 | Franklin | Virginia | 51067 | 198 | 1 |
463003 | 463003 | 2020-08-23 | Franklin | Virginia | 51067 | 200 | 1 |
466232 | 466232 | 2020-08-24 | Franklin | Virginia | 51067 | 201 | 1 |
469461 | 469461 | 2020-08-25 | Franklin | Virginia | 51067 | 203 | 1 |
472693 | 472693 | 2020-08-26 | Franklin | Virginia | 51067 | 204 | 1 |
475926 | 475926 | 2020-08-27 | Franklin | Virginia | 51067 | 204 | 1 |
479159 | 479159 | 2020-08-28 | Franklin | Virginia | 51067 | 208 | 1 |
482393 | 482393 | 2020-08-29 | Franklin | Virginia | 51067 | 209 | 1 |
485628 | 485628 | 2020-08-30 | Franklin | Virginia | 51067 | 212 | 1 |
488861 | 488861 | 2020-08-31 | Franklin | Virginia | 51067 | 213 | 1 |
492094 | 492094 | 2020-09-01 | Franklin | Virginia | 51067 | 216 | 1 |
495328 | 495328 | 2020-09-02 | Franklin | Virginia | 51067 | 218 | 1 |
498561 | 498561 | 2020-09-03 | Franklin | Virginia | 51067 | 225 | 1 |
501795 | 501795 | 2020-09-04 | Franklin | Virginia | 51067 | 235 | 1 |
505029 | 505029 | 2020-09-05 | Franklin | Virginia | 51067 | 240 | 1 |
508261 | 508261 | 2020-09-06 | Franklin | Virginia | 51067 | 243 | 1 |
511494 | 511494 | 2020-09-07 | Franklin | Virginia | 51067 | 249 | 1 |
514727 | 514727 | 2020-09-08 | Franklin | Virginia | 51067 | 251 | 1 |
517962 | 517962 | 2020-09-09 | Franklin | Virginia | 51067 | 254 | 1 |
521199 | 521199 | 2020-09-10 | Franklin | Virginia | 51067 | 259 | 1 |
524435 | 524435 | 2020-09-11 | Franklin | Virginia | 51067 | 263 | 1 |
527671 | 527671 | 2020-09-12 | Franklin | Virginia | 51067 | 266 | 1 |
530908 | 530908 | 2020-09-13 | Franklin | Virginia | 51067 | 266 | 1 |
534143 | 534143 | 2020-09-14 | Franklin | Virginia | 51067 | 272 | 1 |
537379 | 537379 | 2020-09-15 | Franklin | Virginia | 51067 | 280 | 3 |
540616 | 540616 | 2020-09-16 | Franklin | Virginia | 51067 | 284 | 3 |
543852 | 543852 | 2020-09-17 | Franklin | Virginia | 51067 | 287 | 3 |
547089 | 547089 | 2020-09-18 | Franklin | Virginia | 51067 | 291 | 3 |
550328 | 550328 | 2020-09-19 | Franklin | Virginia | 51067 | 303 | 3 |
553567 | 553567 | 2020-09-20 | Franklin | Virginia | 51067 | 310 | 3 |
556804 | 556804 | 2020-09-21 | Franklin | Virginia | 51067 | 310 | 3 |
560040 | 560040 | 2020-09-22 | Franklin | Virginia | 51067 | 320 | 3 |
563279 | 563279 | 2020-09-23 | Franklin | Virginia | 51067 | 325 | 3 |
566520 | 566520 | 2020-09-24 | Franklin | Virginia | 51067 | 329 | 3 |
569761 | 569761 | 2020-09-25 | Franklin | Virginia | 51067 | 333 | 3 |
573003 | 573003 | 2020-09-26 | Franklin | Virginia | 51067 | 335 | 3 |
576247 | 576247 | 2020-09-27 | Franklin | Virginia | 51067 | 337 | 3 |
579488 | 579488 | 2020-09-28 | Franklin | Virginia | 51067 | 343 | 3 |
582727 | 582727 | 2020-09-29 | Franklin | Virginia | 51067 | 365 | 3 |
585967 | 585967 | 2020-09-30 | Franklin | Virginia | 51067 | 373 | 4 |
589208 | 589208 | 2020-10-01 | Franklin | Virginia | 51067 | 379 | 4 |
592448 | 592448 | 2020-10-02 | Franklin | Virginia | 51067 | 391 | 4 |
595690 | 595690 | 2020-10-03 | Franklin | Virginia | 51067 | 414 | 4 |
598933 | 598933 | 2020-10-04 | Franklin | Virginia | 51067 | 422 | 4 |
602176 | 602176 | 2020-10-05 | Franklin | Virginia | 51067 | 429 | 4 |
605418 | 605418 | 2020-10-06 | Franklin | Virginia | 51067 | 431 | 4 |
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);