ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635119 | 635119 | 2020-10-16 | Sonoma | California | 6097 | 8717 | 129 |
631873 | 631873 | 2020-10-15 | Sonoma | California | 6097 | 8684 | 128 |
628629 | 628629 | 2020-10-14 | Sonoma | California | 6097 | 8615 | 128 |
625386 | 625386 | 2020-10-13 | Sonoma | California | 6097 | 8558 | 128 |
622143 | 622143 | 2020-10-12 | Sonoma | California | 6097 | 8500 | 128 |
618900 | 618900 | 2020-10-11 | Sonoma | California | 6097 | 8422 | 128 |
615658 | 615658 | 2020-10-10 | Sonoma | California | 6097 | 8352 | 126 |
612417 | 612417 | 2020-10-09 | Sonoma | California | 6097 | 8270 | 126 |
609175 | 609175 | 2020-10-08 | Sonoma | California | 6097 | 8155 | 126 |
605932 | 605932 | 2020-10-07 | Sonoma | California | 6097 | 8083 | 126 |
602690 | 602690 | 2020-10-06 | Sonoma | California | 6097 | 8037 | 122 |
599447 | 599447 | 2020-10-05 | Sonoma | California | 6097 | 7940 | 122 |
596204 | 596204 | 2020-10-04 | Sonoma | California | 6097 | 7861 | 122 |
592962 | 592962 | 2020-10-03 | Sonoma | California | 6097 | 7799 | 122 |
589722 | 589722 | 2020-10-02 | Sonoma | California | 6097 | 7752 | 122 |
586481 | 586481 | 2020-10-01 | Sonoma | California | 6097 | 7578 | 122 |
583241 | 583241 | 2020-09-30 | Sonoma | California | 6097 | 7578 | 122 |
580002 | 580002 | 2020-09-29 | Sonoma | California | 6097 | 7528 | 122 |
576761 | 576761 | 2020-09-28 | Sonoma | California | 6097 | 7412 | 122 |
573518 | 573518 | 2020-09-27 | Sonoma | California | 6097 | 7412 | 122 |
570276 | 570276 | 2020-09-26 | Sonoma | California | 6097 | 7369 | 122 |
567034 | 567034 | 2020-09-25 | Sonoma | California | 6097 | 7320 | 120 |
563794 | 563794 | 2020-09-24 | Sonoma | California | 6097 | 7262 | 120 |
560555 | 560555 | 2020-09-23 | Sonoma | California | 6097 | 7225 | 120 |
557319 | 557319 | 2020-09-22 | Sonoma | California | 6097 | 7160 | 120 |
554082 | 554082 | 2020-09-21 | Sonoma | California | 6097 | 7112 | 114 |
550843 | 550843 | 2020-09-20 | Sonoma | California | 6097 | 7060 | 114 |
547604 | 547604 | 2020-09-19 | Sonoma | California | 6097 | 6998 | 114 |
544366 | 544366 | 2020-09-18 | Sonoma | California | 6097 | 6987 | 114 |
541130 | 541130 | 2020-09-17 | Sonoma | California | 6097 | 6874 | 114 |
537893 | 537893 | 2020-09-16 | Sonoma | California | 6097 | 6827 | 114 |
534657 | 534657 | 2020-09-15 | Sonoma | California | 6097 | 6777 | 110 |
531422 | 531422 | 2020-09-14 | Sonoma | California | 6097 | 6738 | 110 |
528185 | 528185 | 2020-09-13 | Sonoma | California | 6097 | 6701 | 108 |
524949 | 524949 | 2020-09-12 | Sonoma | California | 6097 | 6666 | 108 |
521713 | 521713 | 2020-09-11 | Sonoma | California | 6097 | 6623 | 108 |
518476 | 518476 | 2020-09-10 | Sonoma | California | 6097 | 6561 | 105 |
515241 | 515241 | 2020-09-09 | Sonoma | California | 6097 | 6516 | 98 |
512008 | 512008 | 2020-09-08 | Sonoma | California | 6097 | 6488 | 98 |
508775 | 508775 | 2020-09-07 | Sonoma | California | 6097 | 6360 | 93 |
505543 | 505543 | 2020-09-06 | Sonoma | California | 6097 | 6303 | 93 |
502309 | 502309 | 2020-09-05 | Sonoma | California | 6097 | 6142 | 93 |
499075 | 499075 | 2020-09-04 | Sonoma | California | 6097 | 6142 | 93 |
495842 | 495842 | 2020-09-03 | Sonoma | California | 6097 | 6142 | 93 |
492608 | 492608 | 2020-09-02 | Sonoma | California | 6097 | 6067 | 89 |
489375 | 489375 | 2020-09-01 | Sonoma | California | 6097 | 5917 | 83 |
486142 | 486142 | 2020-08-31 | Sonoma | California | 6097 | 5800 | 80 |
482907 | 482907 | 2020-08-30 | Sonoma | California | 6097 | 5654 | 78 |
479673 | 479673 | 2020-08-29 | Sonoma | California | 6097 | 5654 | 78 |
476440 | 476440 | 2020-08-28 | Sonoma | California | 6097 | 5588 | 78 |
473207 | 473207 | 2020-08-27 | Sonoma | California | 6097 | 5469 | 78 |
469975 | 469975 | 2020-08-26 | Sonoma | California | 6097 | 5422 | 75 |
466746 | 466746 | 2020-08-25 | Sonoma | California | 6097 | 5351 | 75 |
463517 | 463517 | 2020-08-24 | Sonoma | California | 6097 | 5212 | 73 |
460288 | 460288 | 2020-08-23 | Sonoma | California | 6097 | 5120 | 72 |
457061 | 457061 | 2020-08-22 | Sonoma | California | 6097 | 5067 | 72 |
453833 | 453833 | 2020-08-21 | Sonoma | California | 6097 | 4942 | 70 |
450605 | 450605 | 2020-08-20 | Sonoma | California | 6097 | 4863 | 70 |
447377 | 447377 | 2020-08-19 | Sonoma | California | 6097 | 4779 | 65 |
444150 | 444150 | 2020-08-18 | Sonoma | California | 6097 | 4465 | 57 |
440924 | 440924 | 2020-08-17 | Sonoma | California | 6097 | 4465 | 57 |
437698 | 437698 | 2020-08-16 | Sonoma | California | 6097 | 4377 | 57 |
434472 | 434472 | 2020-08-15 | Sonoma | California | 6097 | 4293 | 54 |
431247 | 431247 | 2020-08-14 | Sonoma | California | 6097 | 4157 | 51 |
428019 | 428019 | 2020-08-13 | Sonoma | California | 6097 | 4063 | 51 |
424795 | 424795 | 2020-08-12 | Sonoma | California | 6097 | 3859 | 51 |
421574 | 421574 | 2020-08-11 | Sonoma | California | 6097 | 3825 | 51 |
418353 | 418353 | 2020-08-10 | Sonoma | California | 6097 | 3753 | 50 |
415132 | 415132 | 2020-08-09 | Sonoma | California | 6097 | 3670 | 47 |
411912 | 411912 | 2020-08-08 | Sonoma | California | 6097 | 3556 | 47 |
408693 | 408693 | 2020-08-07 | Sonoma | California | 6097 | 3431 | 47 |
405473 | 405473 | 2020-08-06 | Sonoma | California | 6097 | 3358 | 44 |
402255 | 402255 | 2020-08-05 | Sonoma | California | 6097 | 3208 | 42 |
399039 | 399039 | 2020-08-04 | Sonoma | California | 6097 | 3113 | 39 |
395823 | 395823 | 2020-08-03 | Sonoma | California | 6097 | 3113 | 39 |
392607 | 392607 | 2020-08-02 | Sonoma | California | 6097 | 3113 | 39 |
389390 | 389390 | 2020-08-01 | Sonoma | California | 6097 | 3055 | 37 |
386173 | 386173 | 2020-07-31 | Sonoma | California | 6097 | 2944 | 36 |
382955 | 382955 | 2020-07-30 | Sonoma | California | 6097 | 2842 | 32 |
379738 | 379738 | 2020-07-29 | Sonoma | California | 6097 | 2748 | 31 |
376521 | 376521 | 2020-07-28 | Sonoma | California | 6097 | 2662 | 31 |
373307 | 373307 | 2020-07-27 | Sonoma | California | 6097 | 2617 | 24 |
370095 | 370095 | 2020-07-26 | Sonoma | California | 6097 | 2570 | 24 |
366885 | 366885 | 2020-07-25 | Sonoma | California | 6097 | 2559 | 24 |
363678 | 363678 | 2020-07-24 | Sonoma | California | 6097 | 2466 | 24 |
360471 | 360471 | 2020-07-23 | Sonoma | California | 6097 | 2300 | 22 |
357266 | 357266 | 2020-07-22 | Sonoma | California | 6097 | 2241 | 22 |
354063 | 354063 | 2020-07-21 | Sonoma | California | 6097 | 2241 | 22 |
350861 | 350861 | 2020-07-20 | Sonoma | California | 6097 | 2212 | 20 |
347660 | 347660 | 2020-07-19 | Sonoma | California | 6097 | 2169 | 20 |
344460 | 344460 | 2020-07-18 | Sonoma | California | 6097 | 2121 | 19 |
341261 | 341261 | 2020-07-17 | Sonoma | California | 6097 | 2068 | 19 |
338065 | 338065 | 2020-07-16 | Sonoma | California | 6097 | 2027 | 19 |
334870 | 334870 | 2020-07-15 | Sonoma | California | 6097 | 1979 | 16 |
331677 | 331677 | 2020-07-14 | Sonoma | California | 6097 | 1886 | 16 |
328491 | 328491 | 2020-07-13 | Sonoma | California | 6097 | 1819 | 16 |
325305 | 325305 | 2020-07-12 | Sonoma | California | 6097 | 1819 | 16 |
322124 | 322124 | 2020-07-11 | Sonoma | California | 6097 | 1703 | 16 |
318945 | 318945 | 2020-07-10 | Sonoma | California | 6097 | 1650 | 14 |
315772 | 315772 | 2020-07-09 | Sonoma | California | 6097 | 1561 | 14 |
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);