ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where county = "Solano" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635118 | 635118 | 2020-10-16 | Solano | California | 6095 | 7014 | 74 |
631872 | 631872 | 2020-10-15 | Solano | California | 6095 | 6956 | 74 |
628628 | 628628 | 2020-10-14 | Solano | California | 6095 | 6913 | 74 |
625385 | 625385 | 2020-10-13 | Solano | California | 6095 | 6881 | 74 |
622142 | 622142 | 2020-10-12 | Solano | California | 6095 | 6755 | 74 |
618899 | 618899 | 2020-10-11 | Solano | California | 6095 | 6755 | 74 |
615657 | 615657 | 2020-10-10 | Solano | California | 6095 | 6755 | 74 |
612416 | 612416 | 2020-10-09 | Solano | California | 6095 | 6755 | 74 |
609174 | 609174 | 2020-10-08 | Solano | California | 6095 | 6713 | 74 |
605931 | 605931 | 2020-10-07 | Solano | California | 6095 | 6663 | 74 |
602689 | 602689 | 2020-10-06 | Solano | California | 6095 | 6629 | 72 |
599446 | 599446 | 2020-10-05 | Solano | California | 6095 | 6606 | 72 |
596203 | 596203 | 2020-10-04 | Solano | California | 6095 | 6525 | 71 |
592961 | 592961 | 2020-10-03 | Solano | California | 6095 | 6525 | 71 |
589721 | 589721 | 2020-10-02 | Solano | California | 6095 | 6525 | 71 |
586480 | 586480 | 2020-10-01 | Solano | California | 6095 | 6480 | 71 |
583240 | 583240 | 2020-09-30 | Solano | California | 6095 | 6450 | 71 |
580001 | 580001 | 2020-09-29 | Solano | California | 6095 | 6424 | 69 |
576760 | 576760 | 2020-09-28 | Solano | California | 6095 | 6405 | 65 |
573517 | 573517 | 2020-09-27 | Solano | California | 6095 | 6314 | 63 |
570275 | 570275 | 2020-09-26 | Solano | California | 6095 | 6314 | 63 |
567033 | 567033 | 2020-09-25 | Solano | California | 6095 | 6314 | 63 |
563793 | 563793 | 2020-09-24 | Solano | California | 6095 | 6283 | 63 |
560554 | 560554 | 2020-09-23 | Solano | California | 6095 | 6237 | 60 |
557318 | 557318 | 2020-09-22 | Solano | California | 6095 | 6199 | 57 |
554081 | 554081 | 2020-09-21 | Solano | California | 6095 | 6180 | 55 |
550842 | 550842 | 2020-09-20 | Solano | California | 6095 | 6090 | 55 |
547603 | 547603 | 2020-09-19 | Solano | California | 6095 | 6090 | 55 |
544365 | 544365 | 2020-09-18 | Solano | California | 6095 | 6090 | 55 |
541129 | 541129 | 2020-09-17 | Solano | California | 6095 | 6059 | 55 |
537892 | 537892 | 2020-09-16 | Solano | California | 6095 | 6012 | 52 |
534656 | 534656 | 2020-09-15 | Solano | California | 6095 | 5992 | 52 |
531421 | 531421 | 2020-09-14 | Solano | California | 6095 | 5942 | 50 |
528184 | 528184 | 2020-09-13 | Solano | California | 6095 | 5825 | 48 |
524948 | 524948 | 2020-09-12 | Solano | California | 6095 | 5825 | 48 |
521712 | 521712 | 2020-09-11 | Solano | California | 6095 | 5825 | 48 |
518475 | 518475 | 2020-09-10 | Solano | California | 6095 | 5810 | 48 |
515240 | 515240 | 2020-09-09 | Solano | California | 6095 | 5783 | 48 |
512007 | 512007 | 2020-09-08 | Solano | California | 6095 | 5767 | 48 |
508774 | 508774 | 2020-09-07 | Solano | California | 6095 | 5676 | 48 |
505542 | 505542 | 2020-09-06 | Solano | California | 6095 | 5676 | 48 |
502308 | 502308 | 2020-09-05 | Solano | California | 6095 | 5676 | 48 |
499074 | 499074 | 2020-09-04 | Solano | California | 6095 | 5676 | 48 |
495841 | 495841 | 2020-09-03 | Solano | California | 6095 | 5636 | 47 |
492607 | 492607 | 2020-09-02 | Solano | California | 6095 | 5593 | 47 |
489374 | 489374 | 2020-09-01 | Solano | California | 6095 | 5552 | 47 |
486141 | 486141 | 2020-08-31 | Solano | California | 6095 | 5517 | 47 |
482906 | 482906 | 2020-08-30 | Solano | California | 6095 | 5393 | 46 |
479672 | 479672 | 2020-08-29 | Solano | California | 6095 | 5393 | 46 |
476439 | 476439 | 2020-08-28 | Solano | California | 6095 | 5393 | 46 |
473206 | 473206 | 2020-08-27 | Solano | California | 6095 | 5333 | 46 |
469974 | 469974 | 2020-08-26 | Solano | California | 6095 | 5285 | 46 |
466745 | 466745 | 2020-08-25 | Solano | California | 6095 | 5236 | 46 |
463516 | 463516 | 2020-08-24 | Solano | California | 6095 | 5211 | 46 |
460287 | 460287 | 2020-08-23 | Solano | California | 6095 | 5053 | 44 |
457060 | 457060 | 2020-08-22 | Solano | California | 6095 | 5053 | 44 |
453832 | 453832 | 2020-08-21 | Solano | California | 6095 | 5053 | 44 |
450604 | 450604 | 2020-08-20 | Solano | California | 6095 | 5011 | 44 |
447376 | 447376 | 2020-08-19 | Solano | California | 6095 | 4948 | 44 |
444149 | 444149 | 2020-08-18 | Solano | California | 6095 | 4876 | 43 |
440923 | 440923 | 2020-08-17 | Solano | California | 6095 | 4772 | 41 |
437697 | 437697 | 2020-08-16 | Solano | California | 6095 | 4601 | 41 |
434471 | 434471 | 2020-08-15 | Solano | California | 6095 | 4601 | 41 |
431246 | 431246 | 2020-08-14 | Solano | California | 6095 | 4601 | 41 |
428018 | 428018 | 2020-08-13 | Solano | California | 6095 | 4539 | 41 |
424794 | 424794 | 2020-08-12 | Solano | California | 6095 | 4419 | 41 |
421573 | 421573 | 2020-08-11 | Solano | California | 6095 | 4343 | 41 |
418352 | 418352 | 2020-08-10 | Solano | California | 6095 | 4279 | 41 |
415131 | 415131 | 2020-08-09 | Solano | California | 6095 | 4034 | 40 |
411911 | 411911 | 2020-08-08 | Solano | California | 6095 | 4034 | 40 |
408692 | 408692 | 2020-08-07 | Solano | California | 6095 | 4034 | 40 |
405472 | 405472 | 2020-08-06 | Solano | California | 6095 | 3964 | 39 |
402254 | 402254 | 2020-08-05 | Solano | California | 6095 | 3889 | 38 |
399038 | 399038 | 2020-08-04 | Solano | California | 6095 | 3811 | 38 |
395822 | 395822 | 2020-08-03 | Solano | California | 6095 | 3726 | 37 |
392606 | 392606 | 2020-08-02 | Solano | California | 6095 | 3616 | 37 |
389389 | 389389 | 2020-08-01 | Solano | California | 6095 | 3616 | 37 |
386172 | 386172 | 2020-07-31 | Solano | California | 6095 | 3616 | 37 |
382954 | 382954 | 2020-07-30 | Solano | California | 6095 | 3525 | 37 |
379737 | 379737 | 2020-07-29 | Solano | California | 6095 | 3467 | 37 |
376520 | 376520 | 2020-07-28 | Solano | California | 6095 | 3393 | 36 |
373306 | 373306 | 2020-07-27 | Solano | California | 6095 | 3288 | 36 |
370094 | 370094 | 2020-07-26 | Solano | California | 6095 | 3134 | 35 |
366884 | 366884 | 2020-07-25 | Solano | California | 6095 | 3134 | 35 |
363677 | 363677 | 2020-07-24 | Solano | California | 6095 | 3134 | 35 |
360470 | 360470 | 2020-07-23 | Solano | California | 6095 | 3075 | 35 |
357265 | 357265 | 2020-07-22 | Solano | California | 6095 | 2987 | 35 |
354062 | 354062 | 2020-07-21 | Solano | California | 6095 | 2862 | 35 |
350860 | 350860 | 2020-07-20 | Solano | California | 6095 | 2764 | 34 |
347659 | 347659 | 2020-07-19 | Solano | California | 6095 | 2559 | 31 |
344459 | 344459 | 2020-07-18 | Solano | California | 6095 | 2559 | 31 |
341260 | 341260 | 2020-07-17 | Solano | California | 6095 | 2559 | 31 |
338064 | 338064 | 2020-07-16 | Solano | California | 6095 | 2488 | 31 |
334869 | 334869 | 2020-07-15 | Solano | California | 6095 | 2412 | 31 |
331676 | 331676 | 2020-07-14 | Solano | California | 6095 | 2318 | 31 |
328490 | 328490 | 2020-07-13 | Solano | California | 6095 | 2224 | 31 |
325304 | 325304 | 2020-07-12 | Solano | California | 6095 | 2080 | 28 |
322123 | 322123 | 2020-07-11 | Solano | California | 6095 | 2080 | 28 |
318944 | 318944 | 2020-07-10 | Solano | California | 6095 | 2080 | 28 |
315771 | 315771 | 2020-07-09 | Solano | California | 6095 | 1990 | 27 |
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);