ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6087 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635114 | 635114 | 2020-10-16 | Santa Cruz | California | 6087 | 2682 | 23 |
631868 | 631868 | 2020-10-15 | Santa Cruz | California | 6087 | 2670 | 23 |
628624 | 628624 | 2020-10-14 | Santa Cruz | California | 6087 | 2633 | 23 |
625381 | 625381 | 2020-10-13 | Santa Cruz | California | 6087 | 2618 | 20 |
622138 | 622138 | 2020-10-12 | Santa Cruz | California | 6087 | 2605 | 20 |
618895 | 618895 | 2020-10-11 | Santa Cruz | California | 6087 | 2595 | 20 |
615653 | 615653 | 2020-10-10 | Santa Cruz | California | 6087 | 2589 | 20 |
612412 | 612412 | 2020-10-09 | Santa Cruz | California | 6087 | 2563 | 20 |
609170 | 609170 | 2020-10-08 | Santa Cruz | California | 6087 | 2552 | 19 |
605927 | 605927 | 2020-10-07 | Santa Cruz | California | 6087 | 2535 | 18 |
602685 | 602685 | 2020-10-06 | Santa Cruz | California | 6087 | 2527 | 14 |
599442 | 599442 | 2020-10-05 | Santa Cruz | California | 6087 | 2519 | 12 |
596199 | 596199 | 2020-10-04 | Santa Cruz | California | 6087 | 2501 | 12 |
592957 | 592957 | 2020-10-03 | Santa Cruz | California | 6087 | 2494 | 12 |
589717 | 589717 | 2020-10-02 | Santa Cruz | California | 6087 | 2481 | 12 |
586476 | 586476 | 2020-10-01 | Santa Cruz | California | 6087 | 2427 | 12 |
583236 | 583236 | 2020-09-30 | Santa Cruz | California | 6087 | 2423 | 12 |
579997 | 579997 | 2020-09-29 | Santa Cruz | California | 6087 | 2394 | 10 |
576756 | 576756 | 2020-09-28 | Santa Cruz | California | 6087 | 2379 | 9 |
573513 | 573513 | 2020-09-27 | Santa Cruz | California | 6087 | 2360 | 9 |
570271 | 570271 | 2020-09-26 | Santa Cruz | California | 6087 | 2358 | 9 |
567029 | 567029 | 2020-09-25 | Santa Cruz | California | 6087 | 2330 | 9 |
563789 | 563789 | 2020-09-24 | Santa Cruz | California | 6087 | 2319 | 9 |
560550 | 560550 | 2020-09-23 | Santa Cruz | California | 6087 | 2294 | 9 |
557314 | 557314 | 2020-09-22 | Santa Cruz | California | 6087 | 2283 | 8 |
554077 | 554077 | 2020-09-21 | Santa Cruz | California | 6087 | 2276 | 8 |
550838 | 550838 | 2020-09-20 | Santa Cruz | California | 6087 | 2218 | 8 |
547599 | 547599 | 2020-09-19 | Santa Cruz | California | 6087 | 2218 | 8 |
544361 | 544361 | 2020-09-18 | Santa Cruz | California | 6087 | 2189 | 8 |
541125 | 541125 | 2020-09-17 | Santa Cruz | California | 6087 | 2175 | 8 |
537888 | 537888 | 2020-09-16 | Santa Cruz | California | 6087 | 2108 | 8 |
534652 | 534652 | 2020-09-15 | Santa Cruz | California | 6087 | 2096 | 7 |
531417 | 531417 | 2020-09-14 | Santa Cruz | California | 6087 | 2065 | 7 |
528180 | 528180 | 2020-09-13 | Santa Cruz | California | 6087 | 2043 | 7 |
524944 | 524944 | 2020-09-12 | Santa Cruz | California | 6087 | 2043 | 7 |
521708 | 521708 | 2020-09-11 | Santa Cruz | California | 6087 | 2021 | 7 |
518471 | 518471 | 2020-09-10 | Santa Cruz | California | 6087 | 2013 | 7 |
515236 | 515236 | 2020-09-09 | Santa Cruz | California | 6087 | 1993 | 7 |
512003 | 512003 | 2020-09-08 | Santa Cruz | California | 6087 | 1931 | 7 |
508770 | 508770 | 2020-09-07 | Santa Cruz | California | 6087 | 1931 | 7 |
505538 | 505538 | 2020-09-06 | Santa Cruz | California | 6087 | 1931 | 7 |
502304 | 502304 | 2020-09-05 | Santa Cruz | California | 6087 | 1931 | 7 |
499070 | 499070 | 2020-09-04 | Santa Cruz | California | 6087 | 1923 | 7 |
495837 | 495837 | 2020-09-03 | Santa Cruz | California | 6087 | 1896 | 7 |
492603 | 492603 | 2020-09-02 | Santa Cruz | California | 6087 | 1878 | 7 |
489370 | 489370 | 2020-09-01 | Santa Cruz | California | 6087 | 1755 | 7 |
486137 | 486137 | 2020-08-31 | Santa Cruz | California | 6087 | 1744 | 7 |
482902 | 482902 | 2020-08-30 | Santa Cruz | California | 6087 | 1746 | 7 |
479668 | 479668 | 2020-08-29 | Santa Cruz | California | 6087 | 1747 | 7 |
476435 | 476435 | 2020-08-28 | Santa Cruz | California | 6087 | 1735 | 7 |
473202 | 473202 | 2020-08-27 | Santa Cruz | California | 6087 | 1726 | 7 |
469970 | 469970 | 2020-08-26 | Santa Cruz | California | 6087 | 1714 | 7 |
466741 | 466741 | 2020-08-25 | Santa Cruz | California | 6087 | 1698 | 7 |
463512 | 463512 | 2020-08-24 | Santa Cruz | California | 6087 | 1636 | 7 |
460283 | 460283 | 2020-08-23 | Santa Cruz | California | 6087 | 1628 | 7 |
457056 | 457056 | 2020-08-22 | Santa Cruz | California | 6087 | 1617 | 7 |
453828 | 453828 | 2020-08-21 | Santa Cruz | California | 6087 | 1605 | 7 |
450600 | 450600 | 2020-08-20 | Santa Cruz | California | 6087 | 1569 | 7 |
447372 | 447372 | 2020-08-19 | Santa Cruz | California | 6087 | 1546 | 7 |
444145 | 444145 | 2020-08-18 | Santa Cruz | California | 6087 | 1505 | 7 |
440919 | 440919 | 2020-08-17 | Santa Cruz | California | 6087 | 1454 | 7 |
437693 | 437693 | 2020-08-16 | Santa Cruz | California | 6087 | 1454 | 7 |
434467 | 434467 | 2020-08-15 | Santa Cruz | California | 6087 | 1420 | 7 |
431242 | 431242 | 2020-08-14 | Santa Cruz | California | 6087 | 1383 | 6 |
428014 | 428014 | 2020-08-13 | Santa Cruz | California | 6087 | 1382 | 6 |
424790 | 424790 | 2020-08-12 | Santa Cruz | California | 6087 | 1352 | 6 |
421569 | 421569 | 2020-08-11 | Santa Cruz | California | 6087 | 1287 | 6 |
418348 | 418348 | 2020-08-10 | Santa Cruz | California | 6087 | 1246 | 6 |
415127 | 415127 | 2020-08-09 | Santa Cruz | California | 6087 | 1247 | 6 |
411907 | 411907 | 2020-08-08 | Santa Cruz | California | 6087 | 1238 | 6 |
408688 | 408688 | 2020-08-07 | Santa Cruz | California | 6087 | 1229 | 4 |
405468 | 405468 | 2020-08-06 | Santa Cruz | California | 6087 | 1213 | 4 |
402250 | 402250 | 2020-08-05 | Santa Cruz | California | 6087 | 1202 | 4 |
399034 | 399034 | 2020-08-04 | Santa Cruz | California | 6087 | 1196 | 4 |
395818 | 395818 | 2020-08-03 | Santa Cruz | California | 6087 | 1162 | 4 |
392602 | 392602 | 2020-08-02 | Santa Cruz | California | 6087 | 1164 | 4 |
389385 | 389385 | 2020-08-01 | Santa Cruz | California | 6087 | 1152 | 4 |
386168 | 386168 | 2020-07-31 | Santa Cruz | California | 6087 | 1109 | 4 |
382950 | 382950 | 2020-07-30 | Santa Cruz | California | 6087 | 1076 | 4 |
379733 | 379733 | 2020-07-29 | Santa Cruz | California | 6087 | 1030 | 4 |
376516 | 376516 | 2020-07-28 | Santa Cruz | California | 6087 | 984 | 4 |
373302 | 373302 | 2020-07-27 | Santa Cruz | California | 6087 | 970 | 4 |
370090 | 370090 | 2020-07-26 | Santa Cruz | California | 6087 | 939 | 4 |
366880 | 366880 | 2020-07-25 | Santa Cruz | California | 6087 | 930 | 4 |
363673 | 363673 | 2020-07-24 | Santa Cruz | California | 6087 | 891 | 4 |
360466 | 360466 | 2020-07-23 | Santa Cruz | California | 6087 | 878 | 4 |
357261 | 357261 | 2020-07-22 | Santa Cruz | California | 6087 | 848 | 3 |
354058 | 354058 | 2020-07-21 | Santa Cruz | California | 6087 | 830 | 3 |
350856 | 350856 | 2020-07-20 | Santa Cruz | California | 6087 | 772 | 3 |
347655 | 347655 | 2020-07-19 | Santa Cruz | California | 6087 | 772 | 3 |
344455 | 344455 | 2020-07-18 | Santa Cruz | California | 6087 | 772 | 3 |
341256 | 341256 | 2020-07-17 | Santa Cruz | California | 6087 | 736 | 3 |
338060 | 338060 | 2020-07-16 | Santa Cruz | California | 6087 | 706 | 3 |
334865 | 334865 | 2020-07-15 | Santa Cruz | California | 6087 | 639 | 3 |
331672 | 331672 | 2020-07-14 | Santa Cruz | California | 6087 | 600 | 3 |
328486 | 328486 | 2020-07-13 | Santa Cruz | California | 6087 | 573 | 3 |
325300 | 325300 | 2020-07-12 | Santa Cruz | California | 6087 | 571 | 3 |
322119 | 322119 | 2020-07-11 | Santa Cruz | California | 6087 | 568 | 3 |
318940 | 318940 | 2020-07-10 | Santa Cruz | California | 6087 | 537 | 3 |
315767 | 315767 | 2020-07-09 | Santa Cruz | California | 6087 | 509 | 3 |
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);