ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where county = "Clarke", deaths = 3 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
710311 | 710311 | 2020-11-08 | Clarke | Iowa | 19039 | 398 | 3 |
707067 | 707067 | 2020-11-07 | Clarke | Iowa | 19039 | 394 | 3 |
703824 | 703824 | 2020-11-06 | Clarke | Iowa | 19039 | 391 | 3 |
700582 | 700582 | 2020-11-05 | Clarke | Iowa | 19039 | 386 | 3 |
697338 | 697338 | 2020-11-04 | Clarke | Iowa | 19039 | 375 | 3 |
694096 | 694096 | 2020-11-03 | Clarke | Iowa | 19039 | 374 | 3 |
690853 | 690853 | 2020-11-02 | Clarke | Iowa | 19039 | 371 | 3 |
687608 | 687608 | 2020-11-01 | Clarke | Iowa | 19039 | 368 | 3 |
684364 | 684364 | 2020-10-31 | Clarke | Iowa | 19039 | 368 | 3 |
681121 | 681121 | 2020-10-30 | Clarke | Iowa | 19039 | 364 | 3 |
677878 | 677878 | 2020-10-29 | Clarke | Iowa | 19039 | 357 | 3 |
674635 | 674635 | 2020-10-28 | Clarke | Iowa | 19039 | 358 | 3 |
671393 | 671393 | 2020-10-27 | Clarke | Iowa | 19039 | 358 | 3 |
668150 | 668150 | 2020-10-26 | Clarke | Iowa | 19039 | 352 | 3 |
664906 | 664906 | 2020-10-25 | Clarke | Iowa | 19039 | 349 | 3 |
661661 | 661661 | 2020-10-24 | Clarke | Iowa | 19039 | 346 | 3 |
658417 | 658417 | 2020-10-23 | Clarke | Iowa | 19039 | 339 | 3 |
655172 | 655172 | 2020-10-22 | Clarke | Iowa | 19039 | 330 | 3 |
651927 | 651927 | 2020-10-21 | Clarke | Iowa | 19039 | 321 | 3 |
648683 | 648683 | 2020-10-20 | Clarke | Iowa | 19039 | 316 | 3 |
645438 | 645438 | 2020-10-19 | Clarke | Iowa | 19039 | 313 | 3 |
642191 | 642191 | 2020-10-18 | Clarke | Iowa | 19039 | 308 | 3 |
638944 | 638944 | 2020-10-17 | Clarke | Iowa | 19039 | 303 | 3 |
635698 | 635698 | 2020-10-16 | Clarke | Iowa | 19039 | 301 | 3 |
632452 | 632452 | 2020-10-15 | Clarke | Iowa | 19039 | 299 | 3 |
629208 | 629208 | 2020-10-14 | Clarke | Iowa | 19039 | 297 | 3 |
625965 | 625965 | 2020-10-13 | Clarke | Iowa | 19039 | 295 | 3 |
622723 | 622723 | 2020-10-12 | Clarke | Iowa | 19039 | 291 | 3 |
619479 | 619479 | 2020-10-11 | Clarke | Iowa | 19039 | 289 | 3 |
616237 | 616237 | 2020-10-10 | Clarke | Iowa | 19039 | 287 | 3 |
612996 | 612996 | 2020-10-09 | Clarke | Iowa | 19039 | 287 | 3 |
609754 | 609754 | 2020-10-08 | Clarke | Iowa | 19039 | 279 | 3 |
606511 | 606511 | 2020-10-07 | Clarke | Iowa | 19039 | 277 | 3 |
603269 | 603269 | 2020-10-06 | Clarke | Iowa | 19039 | 275 | 3 |
600026 | 600026 | 2020-10-05 | Clarke | Iowa | 19039 | 272 | 3 |
596784 | 596784 | 2020-10-04 | Clarke | Iowa | 19039 | 269 | 3 |
593542 | 593542 | 2020-10-03 | Clarke | Iowa | 19039 | 275 | 3 |
590301 | 590301 | 2020-10-02 | Clarke | Iowa | 19039 | 273 | 3 |
587060 | 587060 | 2020-10-01 | Clarke | Iowa | 19039 | 273 | 3 |
583820 | 583820 | 2020-09-30 | Clarke | Iowa | 19039 | 270 | 3 |
580581 | 580581 | 2020-09-29 | Clarke | Iowa | 19039 | 269 | 3 |
577340 | 577340 | 2020-09-28 | Clarke | Iowa | 19039 | 268 | 3 |
574098 | 574098 | 2020-09-27 | Clarke | Iowa | 19039 | 266 | 3 |
570855 | 570855 | 2020-09-26 | Clarke | Iowa | 19039 | 265 | 3 |
567613 | 567613 | 2020-09-25 | Clarke | Iowa | 19039 | 265 | 3 |
564373 | 564373 | 2020-09-24 | Clarke | Iowa | 19039 | 264 | 3 |
561133 | 561133 | 2020-09-23 | Clarke | Iowa | 19039 | 262 | 3 |
557897 | 557897 | 2020-09-22 | Clarke | Iowa | 19039 | 261 | 3 |
554660 | 554660 | 2020-09-21 | Clarke | Iowa | 19039 | 256 | 3 |
551421 | 551421 | 2020-09-20 | Clarke | Iowa | 19039 | 255 | 3 |
548182 | 548182 | 2020-09-19 | Clarke | Iowa | 19039 | 255 | 3 |
544944 | 544944 | 2020-09-18 | Clarke | Iowa | 19039 | 253 | 3 |
541708 | 541708 | 2020-09-17 | Clarke | Iowa | 19039 | 253 | 3 |
538471 | 538471 | 2020-09-16 | Clarke | Iowa | 19039 | 251 | 3 |
535235 | 535235 | 2020-09-15 | Clarke | Iowa | 19039 | 249 | 3 |
532000 | 532000 | 2020-09-14 | Clarke | Iowa | 19039 | 249 | 3 |
528763 | 528763 | 2020-09-13 | Clarke | Iowa | 19039 | 249 | 3 |
525527 | 525527 | 2020-09-12 | Clarke | Iowa | 19039 | 249 | 3 |
522291 | 522291 | 2020-09-11 | Clarke | Iowa | 19039 | 249 | 3 |
519054 | 519054 | 2020-09-10 | Clarke | Iowa | 19039 | 249 | 3 |
515819 | 515819 | 2020-09-09 | Clarke | Iowa | 19039 | 248 | 3 |
512586 | 512586 | 2020-09-08 | Clarke | Iowa | 19039 | 246 | 3 |
509353 | 509353 | 2020-09-07 | Clarke | Iowa | 19039 | 246 | 3 |
506121 | 506121 | 2020-09-06 | Clarke | Iowa | 19039 | 244 | 3 |
502887 | 502887 | 2020-09-05 | Clarke | Iowa | 19039 | 244 | 3 |
499653 | 499653 | 2020-09-04 | Clarke | Iowa | 19039 | 244 | 3 |
496420 | 496420 | 2020-09-03 | Clarke | Iowa | 19039 | 244 | 3 |
493186 | 493186 | 2020-09-02 | Clarke | Iowa | 19039 | 241 | 3 |
489953 | 489953 | 2020-09-01 | Clarke | Iowa | 19039 | 240 | 3 |
486720 | 486720 | 2020-08-31 | Clarke | Iowa | 19039 | 241 | 3 |
483485 | 483485 | 2020-08-30 | Clarke | Iowa | 19039 | 239 | 3 |
480251 | 480251 | 2020-08-29 | Clarke | Iowa | 19039 | 236 | 3 |
477018 | 477018 | 2020-08-28 | Clarke | Iowa | 19039 | 234 | 3 |
473785 | 473785 | 2020-08-27 | Clarke | Iowa | 19039 | 231 | 3 |
470553 | 470553 | 2020-08-26 | Clarke | Iowa | 19039 | 224 | 3 |
467324 | 467324 | 2020-08-25 | Clarke | Iowa | 19039 | 218 | 3 |
464095 | 464095 | 2020-08-24 | Clarke | Iowa | 19039 | 216 | 3 |
460866 | 460866 | 2020-08-23 | Clarke | Iowa | 19039 | 216 | 3 |
457639 | 457639 | 2020-08-22 | Clarke | Iowa | 19039 | 215 | 3 |
454411 | 454411 | 2020-08-21 | Clarke | Iowa | 19039 | 215 | 3 |
451183 | 451183 | 2020-08-20 | Clarke | Iowa | 19039 | 216 | 3 |
447955 | 447955 | 2020-08-19 | Clarke | Iowa | 19039 | 212 | 3 |
444728 | 444728 | 2020-08-18 | Clarke | Iowa | 19039 | 213 | 3 |
441502 | 441502 | 2020-08-17 | Clarke | Iowa | 19039 | 212 | 3 |
438276 | 438276 | 2020-08-16 | Clarke | Iowa | 19039 | 212 | 3 |
435050 | 435050 | 2020-08-15 | Clarke | Iowa | 19039 | 211 | 3 |
431825 | 431825 | 2020-08-14 | Clarke | Iowa | 19039 | 210 | 3 |
428597 | 428597 | 2020-08-13 | Clarke | Iowa | 19039 | 208 | 3 |
425373 | 425373 | 2020-08-12 | Clarke | Iowa | 19039 | 206 | 3 |
422152 | 422152 | 2020-08-11 | Clarke | Iowa | 19039 | 204 | 3 |
418929 | 418929 | 2020-08-10 | Clarke | Iowa | 19039 | 202 | 3 |
415708 | 415708 | 2020-08-09 | Clarke | Iowa | 19039 | 201 | 3 |
412488 | 412488 | 2020-08-08 | Clarke | Iowa | 19039 | 197 | 3 |
409269 | 409269 | 2020-08-07 | Clarke | Iowa | 19039 | 197 | 3 |
406049 | 406049 | 2020-08-06 | Clarke | Iowa | 19039 | 195 | 3 |
402831 | 402831 | 2020-08-05 | Clarke | Iowa | 19039 | 190 | 3 |
399615 | 399615 | 2020-08-04 | Clarke | Iowa | 19039 | 188 | 3 |
396399 | 396399 | 2020-08-03 | Clarke | Iowa | 19039 | 186 | 3 |
393183 | 393183 | 2020-08-02 | Clarke | Iowa | 19039 | 185 | 3 |
389966 | 389966 | 2020-08-01 | Clarke | Iowa | 19039 | 178 | 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);