ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635104 | 635104 | 2020-10-16 | Sacramento | California | 6067 | 24191 | 468 |
631858 | 631858 | 2020-10-15 | Sacramento | California | 6067 | 24101 | 464 |
628614 | 628614 | 2020-10-14 | Sacramento | California | 6067 | 24059 | 462 |
625371 | 625371 | 2020-10-13 | Sacramento | California | 6067 | 23968 | 458 |
622128 | 622128 | 2020-10-12 | Sacramento | California | 6067 | 23849 | 458 |
618885 | 618885 | 2020-10-11 | Sacramento | California | 6067 | 23688 | 450 |
615643 | 615643 | 2020-10-10 | Sacramento | California | 6067 | 23648 | 450 |
612402 | 612402 | 2020-10-09 | Sacramento | California | 6067 | 23648 | 450 |
609160 | 609160 | 2020-10-08 | Sacramento | California | 6067 | 23522 | 447 |
605917 | 605917 | 2020-10-07 | Sacramento | California | 6067 | 23419 | 445 |
602675 | 602675 | 2020-10-06 | Sacramento | California | 6067 | 23362 | 437 |
599432 | 599432 | 2020-10-05 | Sacramento | California | 6067 | 23244 | 432 |
596189 | 596189 | 2020-10-04 | Sacramento | California | 6067 | 23075 | 430 |
592947 | 592947 | 2020-10-03 | Sacramento | California | 6067 | 22854 | 430 |
589707 | 589707 | 2020-10-02 | Sacramento | California | 6067 | 22854 | 430 |
586466 | 586466 | 2020-10-01 | Sacramento | California | 6067 | 22754 | 426 |
583226 | 583226 | 2020-09-30 | Sacramento | California | 6067 | 22653 | 420 |
579987 | 579987 | 2020-09-29 | Sacramento | California | 6067 | 22589 | 416 |
576746 | 576746 | 2020-09-28 | Sacramento | California | 6067 | 22437 | 412 |
573503 | 573503 | 2020-09-27 | Sacramento | California | 6067 | 22268 | 406 |
570261 | 570261 | 2020-09-26 | Sacramento | California | 6067 | 22182 | 406 |
567019 | 567019 | 2020-09-25 | Sacramento | California | 6067 | 22182 | 406 |
563779 | 563779 | 2020-09-24 | Sacramento | California | 6067 | 22025 | 402 |
560540 | 560540 | 2020-09-23 | Sacramento | California | 6067 | 21871 | 399 |
557304 | 557304 | 2020-09-22 | Sacramento | California | 6067 | 21799 | 393 |
554067 | 554067 | 2020-09-21 | Sacramento | California | 6067 | 21627 | 383 |
550828 | 550828 | 2020-09-20 | Sacramento | California | 6067 | 21296 | 375 |
547589 | 547589 | 2020-09-19 | Sacramento | California | 6067 | 21170 | 375 |
544351 | 544351 | 2020-09-18 | Sacramento | California | 6067 | 21170 | 375 |
541115 | 541115 | 2020-09-17 | Sacramento | California | 6067 | 20960 | 371 |
537878 | 537878 | 2020-09-16 | Sacramento | California | 6067 | 20659 | 364 |
534642 | 534642 | 2020-09-15 | Sacramento | California | 6067 | 20544 | 358 |
531407 | 531407 | 2020-09-14 | Sacramento | California | 6067 | 20434 | 356 |
528170 | 528170 | 2020-09-13 | Sacramento | California | 6067 | 20183 | 350 |
524934 | 524934 | 2020-09-12 | Sacramento | California | 6067 | 20062 | 350 |
521698 | 521698 | 2020-09-11 | Sacramento | California | 6067 | 20062 | 350 |
518461 | 518461 | 2020-09-10 | Sacramento | California | 6067 | 19668 | 346 |
515226 | 515226 | 2020-09-09 | Sacramento | California | 6067 | 19523 | 339 |
511993 | 511993 | 2020-09-08 | Sacramento | California | 6067 | 19459 | 334 |
508760 | 508760 | 2020-09-07 | Sacramento | California | 6067 | 19345 | 332 |
505528 | 505528 | 2020-09-06 | Sacramento | California | 6067 | 18954 | 327 |
502294 | 502294 | 2020-09-05 | Sacramento | California | 6067 | 18812 | 327 |
499060 | 499060 | 2020-09-04 | Sacramento | California | 6067 | 18812 | 327 |
495827 | 495827 | 2020-09-03 | Sacramento | California | 6067 | 18606 | 317 |
492593 | 492593 | 2020-09-02 | Sacramento | California | 6067 | 18412 | 304 |
489360 | 489360 | 2020-09-01 | Sacramento | California | 6067 | 18285 | 296 |
486127 | 486127 | 2020-08-31 | Sacramento | California | 6067 | 18051 | 293 |
482892 | 482892 | 2020-08-30 | Sacramento | California | 6067 | 17587 | 274 |
479658 | 479658 | 2020-08-29 | Sacramento | California | 6067 | 17149 | 274 |
476425 | 476425 | 2020-08-28 | Sacramento | California | 6067 | 17149 | 274 |
473192 | 473192 | 2020-08-27 | Sacramento | California | 6067 | 16908 | 265 |
469960 | 469960 | 2020-08-26 | Sacramento | California | 6067 | 16741 | 259 |
466731 | 466731 | 2020-08-25 | Sacramento | California | 6067 | 16622 | 252 |
463502 | 463502 | 2020-08-24 | Sacramento | California | 6067 | 16330 | 246 |
460273 | 460273 | 2020-08-23 | Sacramento | California | 6067 | 15515 | 234 |
457046 | 457046 | 2020-08-22 | Sacramento | California | 6067 | 15246 | 234 |
453818 | 453818 | 2020-08-21 | Sacramento | California | 6067 | 15245 | 234 |
450590 | 450590 | 2020-08-20 | Sacramento | California | 6067 | 14983 | 230 |
447362 | 447362 | 2020-08-19 | Sacramento | California | 6067 | 14759 | 230 |
444135 | 444135 | 2020-08-18 | Sacramento | California | 6067 | 14601 | 219 |
440909 | 440909 | 2020-08-17 | Sacramento | California | 6067 | 14325 | 218 |
437683 | 437683 | 2020-08-16 | Sacramento | California | 6067 | 14017 | 199 |
434457 | 434457 | 2020-08-15 | Sacramento | California | 6067 | 13644 | 199 |
431232 | 431232 | 2020-08-14 | Sacramento | California | 6067 | 13614 | 199 |
428004 | 428004 | 2020-08-13 | Sacramento | California | 6067 | 13215 | 194 |
424780 | 424780 | 2020-08-12 | Sacramento | California | 6067 | 12477 | 186 |
421559 | 421559 | 2020-08-11 | Sacramento | California | 6067 | 12273 | 179 |
418338 | 418338 | 2020-08-10 | Sacramento | California | 6067 | 12039 | 177 |
415117 | 415117 | 2020-08-09 | Sacramento | California | 6067 | 11143 | 161 |
411897 | 411897 | 2020-08-08 | Sacramento | California | 6067 | 10797 | 161 |
408678 | 408678 | 2020-08-07 | Sacramento | California | 6067 | 10794 | 161 |
405458 | 405458 | 2020-08-06 | Sacramento | California | 6067 | 10543 | 155 |
402240 | 402240 | 2020-08-05 | Sacramento | California | 6067 | 10243 | 153 |
399024 | 399024 | 2020-08-04 | Sacramento | California | 6067 | 10173 | 148 |
395808 | 395808 | 2020-08-03 | Sacramento | California | 6067 | 10121 | 145 |
392592 | 392592 | 2020-08-02 | Sacramento | California | 6067 | 10066 | 142 |
389375 | 389375 | 2020-08-01 | Sacramento | California | 6067 | 10015 | 142 |
386158 | 386158 | 2020-07-31 | Sacramento | California | 6067 | 9819 | 133 |
382940 | 382940 | 2020-07-30 | Sacramento | California | 6067 | 9663 | 127 |
379723 | 379723 | 2020-07-29 | Sacramento | California | 6067 | 9513 | 126 |
376506 | 376506 | 2020-07-28 | Sacramento | California | 6067 | 9417 | 121 |
373292 | 373292 | 2020-07-27 | Sacramento | California | 6067 | 9017 | 114 |
370080 | 370080 | 2020-07-26 | Sacramento | California | 6067 | 8902 | 108 |
366870 | 366870 | 2020-07-25 | Sacramento | California | 6067 | 8635 | 108 |
363663 | 363663 | 2020-07-24 | Sacramento | California | 6067 | 8553 | 103 |
360456 | 360456 | 2020-07-23 | Sacramento | California | 6067 | 8246 | 98 |
357251 | 357251 | 2020-07-22 | Sacramento | California | 6067 | 7970 | 96 |
354048 | 354048 | 2020-07-21 | Sacramento | California | 6067 | 7685 | 96 |
350846 | 350846 | 2020-07-20 | Sacramento | California | 6067 | 7325 | 96 |
347645 | 347645 | 2020-07-19 | Sacramento | California | 6067 | 6934 | 96 |
344445 | 344445 | 2020-07-18 | Sacramento | California | 6067 | 6692 | 96 |
341246 | 341246 | 2020-07-17 | Sacramento | California | 6067 | 6510 | 95 |
338050 | 338050 | 2020-07-16 | Sacramento | California | 6067 | 6394 | 94 |
334855 | 334855 | 2020-07-15 | Sacramento | California | 6067 | 6173 | 92 |
331662 | 331662 | 2020-07-14 | Sacramento | California | 6067 | 5937 | 91 |
328476 | 328476 | 2020-07-13 | Sacramento | California | 6067 | 5713 | 83 |
325290 | 325290 | 2020-07-12 | Sacramento | California | 6067 | 5488 | 83 |
322109 | 322109 | 2020-07-11 | Sacramento | California | 6067 | 5338 | 81 |
318930 | 318930 | 2020-07-10 | Sacramento | California | 6067 | 5151 | 79 |
315757 | 315757 | 2020-07-09 | Sacramento | California | 6067 | 4931 | 78 |
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);