ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" and fips = 19041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
723286 | 723286 | 2020-11-12 | Clay | Iowa | 19041 | 829 | 4 |
720043 | 720043 | 2020-11-11 | Clay | Iowa | 19041 | 801 | 4 |
716800 | 716800 | 2020-11-10 | Clay | Iowa | 19041 | 766 | 4 |
713556 | 713556 | 2020-11-09 | Clay | Iowa | 19041 | 750 | 4 |
710312 | 710312 | 2020-11-08 | Clay | Iowa | 19041 | 727 | 4 |
707068 | 707068 | 2020-11-07 | Clay | Iowa | 19041 | 700 | 4 |
703825 | 703825 | 2020-11-06 | Clay | Iowa | 19041 | 680 | 4 |
700583 | 700583 | 2020-11-05 | Clay | Iowa | 19041 | 660 | 4 |
697339 | 697339 | 2020-11-04 | Clay | Iowa | 19041 | 625 | 4 |
694097 | 694097 | 2020-11-03 | Clay | Iowa | 19041 | 608 | 4 |
690854 | 690854 | 2020-11-02 | Clay | Iowa | 19041 | 600 | 4 |
687609 | 687609 | 2020-11-01 | Clay | Iowa | 19041 | 595 | 4 |
684365 | 684365 | 2020-10-31 | Clay | Iowa | 19041 | 591 | 4 |
681122 | 681122 | 2020-10-30 | Clay | Iowa | 19041 | 568 | 4 |
677879 | 677879 | 2020-10-29 | Clay | Iowa | 19041 | 559 | 4 |
674636 | 674636 | 2020-10-28 | Clay | Iowa | 19041 | 549 | 4 |
671394 | 671394 | 2020-10-27 | Clay | Iowa | 19041 | 542 | 4 |
668151 | 668151 | 2020-10-26 | Clay | Iowa | 19041 | 535 | 4 |
664907 | 664907 | 2020-10-25 | Clay | Iowa | 19041 | 528 | 4 |
661662 | 661662 | 2020-10-24 | Clay | Iowa | 19041 | 524 | 4 |
658418 | 658418 | 2020-10-23 | Clay | Iowa | 19041 | 518 | 4 |
655173 | 655173 | 2020-10-22 | Clay | Iowa | 19041 | 508 | 4 |
651928 | 651928 | 2020-10-21 | Clay | Iowa | 19041 | 502 | 4 |
648684 | 648684 | 2020-10-20 | Clay | Iowa | 19041 | 488 | 4 |
645439 | 645439 | 2020-10-19 | Clay | Iowa | 19041 | 485 | 4 |
642192 | 642192 | 2020-10-18 | Clay | Iowa | 19041 | 481 | 4 |
638945 | 638945 | 2020-10-17 | Clay | Iowa | 19041 | 477 | 4 |
635699 | 635699 | 2020-10-16 | Clay | Iowa | 19041 | 471 | 4 |
632453 | 632453 | 2020-10-15 | Clay | Iowa | 19041 | 461 | 4 |
629209 | 629209 | 2020-10-14 | Clay | Iowa | 19041 | 449 | 4 |
625966 | 625966 | 2020-10-13 | Clay | Iowa | 19041 | 442 | 4 |
622724 | 622724 | 2020-10-12 | Clay | Iowa | 19041 | 438 | 4 |
619480 | 619480 | 2020-10-11 | Clay | Iowa | 19041 | 433 | 4 |
616238 | 616238 | 2020-10-10 | Clay | Iowa | 19041 | 424 | 4 |
612997 | 612997 | 2020-10-09 | Clay | Iowa | 19041 | 415 | 4 |
609755 | 609755 | 2020-10-08 | Clay | Iowa | 19041 | 407 | 4 |
606512 | 606512 | 2020-10-07 | Clay | Iowa | 19041 | 395 | 4 |
603270 | 603270 | 2020-10-06 | Clay | Iowa | 19041 | 385 | 4 |
600027 | 600027 | 2020-10-05 | Clay | Iowa | 19041 | 381 | 4 |
596785 | 596785 | 2020-10-04 | Clay | Iowa | 19041 | 377 | 4 |
593543 | 593543 | 2020-10-03 | Clay | Iowa | 19041 | 370 | 4 |
590302 | 590302 | 2020-10-02 | Clay | Iowa | 19041 | 368 | 4 |
587061 | 587061 | 2020-10-01 | Clay | Iowa | 19041 | 360 | 4 |
583821 | 583821 | 2020-09-30 | Clay | Iowa | 19041 | 350 | 4 |
580582 | 580582 | 2020-09-29 | Clay | Iowa | 19041 | 343 | 4 |
577341 | 577341 | 2020-09-28 | Clay | Iowa | 19041 | 334 | 4 |
574099 | 574099 | 2020-09-27 | Clay | Iowa | 19041 | 328 | 4 |
570856 | 570856 | 2020-09-26 | Clay | Iowa | 19041 | 326 | 4 |
567614 | 567614 | 2020-09-25 | Clay | Iowa | 19041 | 319 | 4 |
564374 | 564374 | 2020-09-24 | Clay | Iowa | 19041 | 316 | 4 |
561134 | 561134 | 2020-09-23 | Clay | Iowa | 19041 | 309 | 4 |
557898 | 557898 | 2020-09-22 | Clay | Iowa | 19041 | 301 | 4 |
554661 | 554661 | 2020-09-21 | Clay | Iowa | 19041 | 296 | 3 |
551422 | 551422 | 2020-09-20 | Clay | Iowa | 19041 | 292 | 3 |
548183 | 548183 | 2020-09-19 | Clay | Iowa | 19041 | 288 | 3 |
544945 | 544945 | 2020-09-18 | Clay | Iowa | 19041 | 277 | 3 |
541709 | 541709 | 2020-09-17 | Clay | Iowa | 19041 | 271 | 3 |
538472 | 538472 | 2020-09-16 | Clay | Iowa | 19041 | 265 | 3 |
535236 | 535236 | 2020-09-15 | Clay | Iowa | 19041 | 261 | 3 |
532001 | 532001 | 2020-09-14 | Clay | Iowa | 19041 | 255 | 3 |
528764 | 528764 | 2020-09-13 | Clay | Iowa | 19041 | 254 | 3 |
525528 | 525528 | 2020-09-12 | Clay | Iowa | 19041 | 252 | 3 |
522292 | 522292 | 2020-09-11 | Clay | Iowa | 19041 | 251 | 3 |
519055 | 519055 | 2020-09-10 | Clay | Iowa | 19041 | 247 | 3 |
515820 | 515820 | 2020-09-09 | Clay | Iowa | 19041 | 246 | 3 |
512587 | 512587 | 2020-09-08 | Clay | Iowa | 19041 | 244 | 3 |
509354 | 509354 | 2020-09-07 | Clay | Iowa | 19041 | 244 | 3 |
506122 | 506122 | 2020-09-06 | Clay | Iowa | 19041 | 244 | 3 |
502888 | 502888 | 2020-09-05 | Clay | Iowa | 19041 | 244 | 3 |
499654 | 499654 | 2020-09-04 | Clay | Iowa | 19041 | 241 | 3 |
496421 | 496421 | 2020-09-03 | Clay | Iowa | 19041 | 241 | 3 |
493187 | 493187 | 2020-09-02 | Clay | Iowa | 19041 | 238 | 3 |
489954 | 489954 | 2020-09-01 | Clay | Iowa | 19041 | 236 | 3 |
486721 | 486721 | 2020-08-31 | Clay | Iowa | 19041 | 236 | 3 |
483486 | 483486 | 2020-08-30 | Clay | Iowa | 19041 | 236 | 3 |
480252 | 480252 | 2020-08-29 | Clay | Iowa | 19041 | 236 | 3 |
477019 | 477019 | 2020-08-28 | Clay | Iowa | 19041 | 236 | 3 |
473786 | 473786 | 2020-08-27 | Clay | Iowa | 19041 | 236 | 2 |
470554 | 470554 | 2020-08-26 | Clay | Iowa | 19041 | 235 | 2 |
467325 | 467325 | 2020-08-25 | Clay | Iowa | 19041 | 233 | 2 |
464096 | 464096 | 2020-08-24 | Clay | Iowa | 19041 | 231 | 2 |
460867 | 460867 | 2020-08-23 | Clay | Iowa | 19041 | 229 | 2 |
457640 | 457640 | 2020-08-22 | Clay | Iowa | 19041 | 229 | 2 |
454412 | 454412 | 2020-08-21 | Clay | Iowa | 19041 | 229 | 2 |
451184 | 451184 | 2020-08-20 | Clay | Iowa | 19041 | 226 | 1 |
447956 | 447956 | 2020-08-19 | Clay | Iowa | 19041 | 223 | 1 |
444729 | 444729 | 2020-08-18 | Clay | Iowa | 19041 | 218 | 1 |
441503 | 441503 | 2020-08-17 | Clay | Iowa | 19041 | 219 | 1 |
438277 | 438277 | 2020-08-16 | Clay | Iowa | 19041 | 215 | 1 |
435051 | 435051 | 2020-08-15 | Clay | Iowa | 19041 | 212 | 1 |
431826 | 431826 | 2020-08-14 | Clay | Iowa | 19041 | 210 | 1 |
428598 | 428598 | 2020-08-13 | Clay | Iowa | 19041 | 205 | 1 |
425374 | 425374 | 2020-08-12 | Clay | Iowa | 19041 | 203 | 1 |
422153 | 422153 | 2020-08-11 | Clay | Iowa | 19041 | 201 | 1 |
418930 | 418930 | 2020-08-10 | Clay | Iowa | 19041 | 196 | 1 |
415709 | 415709 | 2020-08-09 | Clay | Iowa | 19041 | 190 | 1 |
412489 | 412489 | 2020-08-08 | Clay | Iowa | 19041 | 186 | 1 |
409270 | 409270 | 2020-08-07 | Clay | Iowa | 19041 | 179 | 1 |
406050 | 406050 | 2020-08-06 | Clay | Iowa | 19041 | 176 | 1 |
402832 | 402832 | 2020-08-05 | Clay | Iowa | 19041 | 174 | 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);