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 |
---|---|---|---|---|---|---|---|
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 |
312597 | 312597 | 2020-07-08 | Sonoma | California | 6097 | 1519 | 14 |
309427 | 309427 | 2020-07-07 | Sonoma | California | 6097 | 1487 | 14 |
306259 | 306259 | 2020-07-06 | Sonoma | California | 6097 | 1466 | 12 |
303095 | 303095 | 2020-07-05 | Sonoma | California | 6097 | 1370 | 11 |
299931 | 299931 | 2020-07-04 | Sonoma | California | 6097 | 1359 | 11 |
296769 | 296769 | 2020-07-03 | Sonoma | California | 6097 | 1267 | 11 |
293613 | 293613 | 2020-07-02 | Sonoma | California | 6097 | 1267 | 10 |
290459 | 290459 | 2020-07-01 | Sonoma | California | 6097 | 1229 | 9 |
287308 | 287308 | 2020-06-30 | Sonoma | California | 6097 | 1185 | 7 |
284162 | 284162 | 2020-06-29 | Sonoma | California | 6097 | 1136 | 7 |
281016 | 281016 | 2020-06-28 | Sonoma | California | 6097 | 1118 | 5 |
277869 | 277869 | 2020-06-27 | Sonoma | California | 6097 | 1092 | 5 |
274721 | 274721 | 2020-06-26 | Sonoma | California | 6097 | 1006 | 5 |
271581 | 271581 | 2020-06-25 | Sonoma | California | 6097 | 1006 | 5 |
268446 | 268446 | 2020-06-24 | Sonoma | California | 6097 | 974 | 5 |
265316 | 265316 | 2020-06-23 | Sonoma | California | 6097 | 956 | 5 |
262188 | 262188 | 2020-06-22 | Sonoma | California | 6097 | 935 | 5 |
259061 | 259061 | 2020-06-21 | Sonoma | California | 6097 | 885 | 5 |
255934 | 255934 | 2020-06-20 | Sonoma | California | 6097 | 835 | 4 |
252815 | 252815 | 2020-06-19 | Sonoma | California | 6097 | 835 | 4 |
249700 | 249700 | 2020-06-18 | Sonoma | California | 6097 | 822 | 4 |
246588 | 246588 | 2020-06-17 | Sonoma | California | 6097 | 803 | 4 |
243475 | 243475 | 2020-06-16 | Sonoma | California | 6097 | 774 | 4 |
240364 | 240364 | 2020-06-15 | Sonoma | California | 6097 | 765 | 4 |
237256 | 237256 | 2020-06-14 | Sonoma | California | 6097 | 758 | 4 |
234149 | 234149 | 2020-06-13 | Sonoma | California | 6097 | 752 | 4 |
231043 | 231043 | 2020-06-12 | Sonoma | California | 6097 | 722 | 4 |
227940 | 227940 | 2020-06-11 | Sonoma | California | 6097 | 701 | 4 |
224838 | 224838 | 2020-06-10 | Sonoma | California | 6097 | 671 | 4 |
221743 | 221743 | 2020-06-09 | Sonoma | California | 6097 | 671 | 4 |
218648 | 218648 | 2020-06-08 | Sonoma | California | 6097 | 664 | 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);