ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 6057 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635099 | 635099 | 2020-10-16 | Nevada | California | 6057 | 581 | 8 |
631853 | 631853 | 2020-10-15 | Nevada | California | 6057 | 579 | 8 |
628609 | 628609 | 2020-10-14 | Nevada | California | 6057 | 576 | 8 |
625366 | 625366 | 2020-10-13 | Nevada | California | 6057 | 573 | 8 |
622123 | 622123 | 2020-10-12 | Nevada | California | 6057 | 569 | 8 |
618880 | 618880 | 2020-10-11 | Nevada | California | 6057 | 564 | 8 |
615638 | 615638 | 2020-10-10 | Nevada | California | 6057 | 562 | 8 |
612397 | 612397 | 2020-10-09 | Nevada | California | 6057 | 562 | 8 |
609155 | 609155 | 2020-10-08 | Nevada | California | 6057 | 557 | 8 |
605912 | 605912 | 2020-10-07 | Nevada | California | 6057 | 554 | 7 |
602670 | 602670 | 2020-10-06 | Nevada | California | 6057 | 553 | 7 |
599427 | 599427 | 2020-10-05 | Nevada | California | 6057 | 550 | 7 |
596184 | 596184 | 2020-10-04 | Nevada | California | 6057 | 544 | 7 |
592942 | 592942 | 2020-10-03 | Nevada | California | 6057 | 543 | 7 |
589702 | 589702 | 2020-10-02 | Nevada | California | 6057 | 543 | 7 |
586461 | 586461 | 2020-10-01 | Nevada | California | 6057 | 544 | 7 |
583221 | 583221 | 2020-09-30 | Nevada | California | 6057 | 543 | 7 |
579982 | 579982 | 2020-09-29 | Nevada | California | 6057 | 541 | 7 |
576741 | 576741 | 2020-09-28 | Nevada | California | 6057 | 540 | 7 |
573498 | 573498 | 2020-09-27 | Nevada | California | 6057 | 534 | 7 |
570256 | 570256 | 2020-09-26 | Nevada | California | 6057 | 533 | 7 |
567014 | 567014 | 2020-09-25 | Nevada | California | 6057 | 533 | 7 |
563774 | 563774 | 2020-09-24 | Nevada | California | 6057 | 531 | 7 |
560535 | 560535 | 2020-09-23 | Nevada | California | 6057 | 528 | 6 |
557299 | 557299 | 2020-09-22 | Nevada | California | 6057 | 525 | 6 |
554062 | 554062 | 2020-09-21 | Nevada | California | 6057 | 524 | 6 |
550823 | 550823 | 2020-09-20 | Nevada | California | 6057 | 506 | 6 |
547584 | 547584 | 2020-09-19 | Nevada | California | 6057 | 506 | 6 |
544346 | 544346 | 2020-09-18 | Nevada | California | 6057 | 506 | 6 |
541110 | 541110 | 2020-09-17 | Nevada | California | 6057 | 503 | 5 |
537873 | 537873 | 2020-09-16 | Nevada | California | 6057 | 497 | 5 |
534637 | 534637 | 2020-09-15 | Nevada | California | 6057 | 496 | 5 |
531402 | 531402 | 2020-09-14 | Nevada | California | 6057 | 494 | 5 |
528165 | 528165 | 2020-09-13 | Nevada | California | 6057 | 482 | 5 |
524929 | 524929 | 2020-09-12 | Nevada | California | 6057 | 483 | 5 |
521693 | 521693 | 2020-09-11 | Nevada | California | 6057 | 482 | 5 |
518456 | 518456 | 2020-09-10 | Nevada | California | 6057 | 478 | 5 |
515221 | 515221 | 2020-09-09 | Nevada | California | 6057 | 476 | 5 |
511988 | 511988 | 2020-09-08 | Nevada | California | 6057 | 469 | 5 |
508755 | 508755 | 2020-09-07 | Nevada | California | 6057 | 467 | 5 |
505523 | 505523 | 2020-09-06 | Nevada | California | 6057 | 461 | 5 |
502289 | 502289 | 2020-09-05 | Nevada | California | 6057 | 456 | 5 |
499055 | 499055 | 2020-09-04 | Nevada | California | 6057 | 456 | 5 |
495822 | 495822 | 2020-09-03 | Nevada | California | 6057 | 452 | 5 |
492588 | 492588 | 2020-09-02 | Nevada | California | 6057 | 450 | 5 |
489355 | 489355 | 2020-09-01 | Nevada | California | 6057 | 449 | 5 |
486122 | 486122 | 2020-08-31 | Nevada | California | 6057 | 446 | 5 |
482887 | 482887 | 2020-08-30 | Nevada | California | 6057 | 442 | 5 |
479653 | 479653 | 2020-08-29 | Nevada | California | 6057 | 438 | 5 |
476420 | 476420 | 2020-08-28 | Nevada | California | 6057 | 435 | 5 |
473187 | 473187 | 2020-08-27 | Nevada | California | 6057 | 432 | 5 |
469955 | 469955 | 2020-08-26 | Nevada | California | 6057 | 430 | 5 |
466726 | 466726 | 2020-08-25 | Nevada | California | 6057 | 424 | 5 |
463497 | 463497 | 2020-08-24 | Nevada | California | 6057 | 423 | 3 |
460268 | 460268 | 2020-08-23 | Nevada | California | 6057 | 411 | 3 |
457041 | 457041 | 2020-08-22 | Nevada | California | 6057 | 406 | 3 |
453813 | 453813 | 2020-08-21 | Nevada | California | 6057 | 404 | 3 |
450585 | 450585 | 2020-08-20 | Nevada | California | 6057 | 399 | 3 |
447357 | 447357 | 2020-08-19 | Nevada | California | 6057 | 394 | 2 |
444130 | 444130 | 2020-08-18 | Nevada | California | 6057 | 392 | 2 |
440904 | 440904 | 2020-08-17 | Nevada | California | 6057 | 385 | 2 |
437678 | 437678 | 2020-08-16 | Nevada | California | 6057 | 376 | 2 |
434452 | 434452 | 2020-08-15 | Nevada | California | 6057 | 377 | 2 |
431227 | 431227 | 2020-08-14 | Nevada | California | 6057 | 372 | 2 |
427999 | 427999 | 2020-08-13 | Nevada | California | 6057 | 362 | 1 |
424775 | 424775 | 2020-08-12 | Nevada | California | 6057 | 358 | 1 |
421554 | 421554 | 2020-08-11 | Nevada | California | 6057 | 357 | 1 |
418333 | 418333 | 2020-08-10 | Nevada | California | 6057 | 357 | 1 |
415112 | 415112 | 2020-08-09 | Nevada | California | 6057 | 325 | 1 |
411892 | 411892 | 2020-08-08 | Nevada | California | 6057 | 324 | 1 |
408673 | 408673 | 2020-08-07 | Nevada | California | 6057 | 327 | 1 |
405453 | 405453 | 2020-08-06 | Nevada | California | 6057 | 327 | 1 |
402235 | 402235 | 2020-08-05 | Nevada | California | 6057 | 322 | 1 |
399019 | 399019 | 2020-08-04 | Nevada | California | 6057 | 316 | 1 |
395803 | 395803 | 2020-08-03 | Nevada | California | 6057 | 314 | 1 |
392587 | 392587 | 2020-08-02 | Nevada | California | 6057 | 305 | 1 |
389370 | 389370 | 2020-08-01 | Nevada | California | 6057 | 302 | 1 |
386153 | 386153 | 2020-07-31 | Nevada | California | 6057 | 299 | 1 |
382935 | 382935 | 2020-07-30 | Nevada | California | 6057 | 293 | 1 |
379718 | 379718 | 2020-07-29 | Nevada | California | 6057 | 288 | 1 |
376501 | 376501 | 2020-07-28 | Nevada | California | 6057 | 285 | 1 |
373287 | 373287 | 2020-07-27 | Nevada | California | 6057 | 273 | 1 |
370075 | 370075 | 2020-07-26 | Nevada | California | 6057 | 257 | 1 |
366865 | 366865 | 2020-07-25 | Nevada | California | 6057 | 255 | 1 |
363658 | 363658 | 2020-07-24 | Nevada | California | 6057 | 255 | 1 |
360451 | 360451 | 2020-07-23 | Nevada | California | 6057 | 251 | 1 |
357246 | 357246 | 2020-07-22 | Nevada | California | 6057 | 242 | 1 |
354043 | 354043 | 2020-07-21 | Nevada | California | 6057 | 231 | 1 |
350841 | 350841 | 2020-07-20 | Nevada | California | 6057 | 228 | 1 |
347640 | 347640 | 2020-07-19 | Nevada | California | 6057 | 204 | 1 |
344440 | 344440 | 2020-07-18 | Nevada | California | 6057 | 204 | 1 |
341241 | 341241 | 2020-07-17 | Nevada | California | 6057 | 204 | 1 |
338045 | 338045 | 2020-07-16 | Nevada | California | 6057 | 197 | 1 |
334850 | 334850 | 2020-07-15 | Nevada | California | 6057 | 185 | 1 |
331657 | 331657 | 2020-07-14 | Nevada | California | 6057 | 183 | 1 |
328471 | 328471 | 2020-07-13 | Nevada | California | 6057 | 180 | 1 |
325285 | 325285 | 2020-07-12 | Nevada | California | 6057 | 163 | 1 |
322104 | 322104 | 2020-07-11 | Nevada | California | 6057 | 163 | 1 |
318925 | 318925 | 2020-07-10 | Nevada | California | 6057 | 163 | 1 |
315752 | 315752 | 2020-07-09 | Nevada | California | 6057 | 159 | 1 |
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);