ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 6077 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635109 | 635109 | 2020-10-16 | San Joaquin | California | 6077 | 21187 | 484 |
631863 | 631863 | 2020-10-15 | San Joaquin | California | 6077 | 21138 | 483 |
628619 | 628619 | 2020-10-14 | San Joaquin | California | 6077 | 20828 | 477 |
625376 | 625376 | 2020-10-13 | San Joaquin | California | 6077 | 20828 | 473 |
622133 | 622133 | 2020-10-12 | San Joaquin | California | 6077 | 20828 | 473 |
618890 | 618890 | 2020-10-11 | San Joaquin | California | 6077 | 20828 | 473 |
615648 | 615648 | 2020-10-10 | San Joaquin | California | 6077 | 20828 | 473 |
612407 | 612407 | 2020-10-09 | San Joaquin | California | 6077 | 20828 | 473 |
609165 | 609165 | 2020-10-08 | San Joaquin | California | 6077 | 20828 | 473 |
605922 | 605922 | 2020-10-07 | San Joaquin | California | 6077 | 20779 | 473 |
602680 | 602680 | 2020-10-06 | San Joaquin | California | 6077 | 20731 | 472 |
599437 | 599437 | 2020-10-05 | San Joaquin | California | 6077 | 20569 | 471 |
596194 | 596194 | 2020-10-04 | San Joaquin | California | 6077 | 20485 | 470 |
592952 | 592952 | 2020-10-03 | San Joaquin | California | 6077 | 20485 | 470 |
589712 | 589712 | 2020-10-02 | San Joaquin | California | 6077 | 20485 | 470 |
586471 | 586471 | 2020-10-01 | San Joaquin | California | 6077 | 20457 | 466 |
583231 | 583231 | 2020-09-30 | San Joaquin | California | 6077 | 20411 | 456 |
579992 | 579992 | 2020-09-29 | San Joaquin | California | 6077 | 20357 | 447 |
576751 | 576751 | 2020-09-28 | San Joaquin | California | 6077 | 20245 | 441 |
573508 | 573508 | 2020-09-27 | San Joaquin | California | 6077 | 20194 | 441 |
570266 | 570266 | 2020-09-26 | San Joaquin | California | 6077 | 20194 | 441 |
567024 | 567024 | 2020-09-25 | San Joaquin | California | 6077 | 20194 | 441 |
563784 | 563784 | 2020-09-24 | San Joaquin | California | 6077 | 20126 | 437 |
560545 | 560545 | 2020-09-23 | San Joaquin | California | 6077 | 20060 | 434 |
557309 | 557309 | 2020-09-22 | San Joaquin | California | 6077 | 20019 | 421 |
554072 | 554072 | 2020-09-21 | San Joaquin | California | 6077 | 19841 | 415 |
550833 | 550833 | 2020-09-20 | San Joaquin | California | 6077 | 19793 | 414 |
547594 | 547594 | 2020-09-19 | San Joaquin | California | 6077 | 19793 | 414 |
544356 | 544356 | 2020-09-18 | San Joaquin | California | 6077 | 19793 | 414 |
541120 | 541120 | 2020-09-17 | San Joaquin | California | 6077 | 19701 | 407 |
537883 | 537883 | 2020-09-16 | San Joaquin | California | 6077 | 19623 | 399 |
534647 | 534647 | 2020-09-15 | San Joaquin | California | 6077 | 19564 | 392 |
531412 | 531412 | 2020-09-14 | San Joaquin | California | 6077 | 19364 | 389 |
528175 | 528175 | 2020-09-13 | San Joaquin | California | 6077 | 19108 | 383 |
524939 | 524939 | 2020-09-12 | San Joaquin | California | 6077 | 19019 | 383 |
521703 | 521703 | 2020-09-11 | San Joaquin | California | 6077 | 18854 | 383 |
518466 | 518466 | 2020-09-10 | San Joaquin | California | 6077 | 18799 | 383 |
515231 | 515231 | 2020-09-09 | San Joaquin | California | 6077 | 18550 | 382 |
511998 | 511998 | 2020-09-08 | San Joaquin | California | 6077 | 18552 | 377 |
508765 | 508765 | 2020-09-07 | San Joaquin | California | 6077 | 18558 | 368 |
505533 | 505533 | 2020-09-06 | San Joaquin | California | 6077 | 18557 | 368 |
502299 | 502299 | 2020-09-05 | San Joaquin | California | 6077 | 18438 | 368 |
499065 | 499065 | 2020-09-04 | San Joaquin | California | 6077 | 18331 | 368 |
495832 | 495832 | 2020-09-03 | San Joaquin | California | 6077 | 18194 | 361 |
492598 | 492598 | 2020-09-02 | San Joaquin | California | 6077 | 17915 | 344 |
489365 | 489365 | 2020-09-01 | San Joaquin | California | 6077 | 17807 | 330 |
486132 | 486132 | 2020-08-31 | San Joaquin | California | 6077 | 17637 | 328 |
482897 | 482897 | 2020-08-30 | San Joaquin | California | 6077 | 17493 | 307 |
479663 | 479663 | 2020-08-29 | San Joaquin | California | 6077 | 17114 | 307 |
476430 | 476430 | 2020-08-28 | San Joaquin | California | 6077 | 16989 | 307 |
473197 | 473197 | 2020-08-27 | San Joaquin | California | 6077 | 16845 | 305 |
469965 | 469965 | 2020-08-26 | San Joaquin | California | 6077 | 16795 | 297 |
466736 | 466736 | 2020-08-25 | San Joaquin | California | 6077 | 16565 | 297 |
463507 | 463507 | 2020-08-24 | San Joaquin | California | 6077 | 16131 | 297 |
460278 | 460278 | 2020-08-23 | San Joaquin | California | 6077 | 16068 | 294 |
457051 | 457051 | 2020-08-22 | San Joaquin | California | 6077 | 15888 | 294 |
453823 | 453823 | 2020-08-21 | San Joaquin | California | 6077 | 15778 | 294 |
450595 | 450595 | 2020-08-20 | San Joaquin | California | 6077 | 15677 | 288 |
447367 | 447367 | 2020-08-19 | San Joaquin | California | 6077 | 15379 | 287 |
444140 | 444140 | 2020-08-18 | San Joaquin | California | 6077 | 15323 | 280 |
440914 | 440914 | 2020-08-17 | San Joaquin | California | 6077 | 15288 | 269 |
437688 | 437688 | 2020-08-16 | San Joaquin | California | 6077 | 15113 | 261 |
434462 | 434462 | 2020-08-15 | San Joaquin | California | 6077 | 14925 | 261 |
431237 | 431237 | 2020-08-14 | San Joaquin | California | 6077 | 14651 | 261 |
428009 | 428009 | 2020-08-13 | San Joaquin | California | 6077 | 14276 | 245 |
424785 | 424785 | 2020-08-12 | San Joaquin | California | 6077 | 14026 | 239 |
421564 | 421564 | 2020-08-11 | San Joaquin | California | 6077 | 13870 | 235 |
418343 | 418343 | 2020-08-10 | San Joaquin | California | 6077 | 12933 | 223 |
415122 | 415122 | 2020-08-09 | San Joaquin | California | 6077 | 12559 | 211 |
411902 | 411902 | 2020-08-08 | San Joaquin | California | 6077 | 12392 | 211 |
408683 | 408683 | 2020-08-07 | San Joaquin | California | 6077 | 12303 | 211 |
405463 | 405463 | 2020-08-06 | San Joaquin | California | 6077 | 12148 | 192 |
402245 | 402245 | 2020-08-05 | San Joaquin | California | 6077 | 12087 | 187 |
399029 | 399029 | 2020-08-04 | San Joaquin | California | 6077 | 12007 | 180 |
395813 | 395813 | 2020-08-03 | San Joaquin | California | 6077 | 11937 | 180 |
392597 | 392597 | 2020-08-02 | San Joaquin | California | 6077 | 11807 | 168 |
389380 | 389380 | 2020-08-01 | San Joaquin | California | 6077 | 11561 | 168 |
386163 | 386163 | 2020-07-31 | San Joaquin | California | 6077 | 11483 | 168 |
382945 | 382945 | 2020-07-30 | San Joaquin | California | 6077 | 11342 | 151 |
379728 | 379728 | 2020-07-29 | San Joaquin | California | 6077 | 11209 | 146 |
376511 | 376511 | 2020-07-28 | San Joaquin | California | 6077 | 10923 | 133 |
373297 | 373297 | 2020-07-27 | San Joaquin | California | 6077 | 10675 | 118 |
370085 | 370085 | 2020-07-26 | San Joaquin | California | 6077 | 10347 | 110 |
366875 | 366875 | 2020-07-25 | San Joaquin | California | 6077 | 10190 | 110 |
363668 | 363668 | 2020-07-24 | San Joaquin | California | 6077 | 10126 | 110 |
360461 | 360461 | 2020-07-23 | San Joaquin | California | 6077 | 9826 | 107 |
357256 | 357256 | 2020-07-22 | San Joaquin | California | 6077 | 9595 | 98 |
354053 | 354053 | 2020-07-21 | San Joaquin | California | 6077 | 8799 | 95 |
350851 | 350851 | 2020-07-20 | San Joaquin | California | 6077 | 8321 | 94 |
347650 | 347650 | 2020-07-19 | San Joaquin | California | 6077 | 8118 | 83 |
344450 | 344450 | 2020-07-18 | San Joaquin | California | 6077 | 7925 | 83 |
341251 | 341251 | 2020-07-17 | San Joaquin | California | 6077 | 7819 | 83 |
338055 | 338055 | 2020-07-16 | San Joaquin | California | 6077 | 7680 | 81 |
334860 | 334860 | 2020-07-15 | San Joaquin | California | 6077 | 7428 | 73 |
331667 | 331667 | 2020-07-14 | San Joaquin | California | 6077 | 7216 | 73 |
328481 | 328481 | 2020-07-13 | San Joaquin | California | 6077 | 6988 | 70 |
325295 | 325295 | 2020-07-12 | San Joaquin | California | 6077 | 6518 | 68 |
322114 | 322114 | 2020-07-11 | San Joaquin | California | 6077 | 6279 | 68 |
318935 | 318935 | 2020-07-10 | San Joaquin | California | 6077 | 6279 | 68 |
315762 | 315762 | 2020-07-09 | San Joaquin | California | 6077 | 6065 | 67 |
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);