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 |
---|---|---|---|---|---|---|---|
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 |
399616 | 399616 | 2020-08-04 | Clay | Iowa | 19041 | 171 | 1 |
396400 | 396400 | 2020-08-03 | Clay | Iowa | 19041 | 171 | 1 |
393184 | 393184 | 2020-08-02 | Clay | Iowa | 19041 | 171 | 1 |
389967 | 389967 | 2020-08-01 | Clay | Iowa | 19041 | 170 | 1 |
386750 | 386750 | 2020-07-31 | Clay | Iowa | 19041 | 168 | 1 |
383532 | 383532 | 2020-07-30 | Clay | Iowa | 19041 | 168 | 1 |
380315 | 380315 | 2020-07-29 | Clay | Iowa | 19041 | 168 | 1 |
377098 | 377098 | 2020-07-28 | Clay | Iowa | 19041 | 167 | 1 |
373883 | 373883 | 2020-07-27 | Clay | Iowa | 19041 | 166 | 1 |
370671 | 370671 | 2020-07-26 | Clay | Iowa | 19041 | 166 | 1 |
367461 | 367461 | 2020-07-25 | Clay | Iowa | 19041 | 165 | 1 |
364254 | 364254 | 2020-07-24 | Clay | Iowa | 19041 | 164 | 1 |
361047 | 361047 | 2020-07-23 | Clay | Iowa | 19041 | 162 | 1 |
357842 | 357842 | 2020-07-22 | Clay | Iowa | 19041 | 161 | 1 |
354640 | 354640 | 2020-07-21 | Clay | Iowa | 19041 | 161 | 1 |
351438 | 351438 | 2020-07-20 | Clay | Iowa | 19041 | 161 | 1 |
348238 | 348238 | 2020-07-19 | Clay | Iowa | 19041 | 159 | 1 |
345037 | 345037 | 2020-07-18 | Clay | Iowa | 19041 | 158 | 1 |
341837 | 341837 | 2020-07-17 | Clay | Iowa | 19041 | 155 | 1 |
338641 | 338641 | 2020-07-16 | Clay | Iowa | 19041 | 155 | 1 |
335445 | 335445 | 2020-07-15 | Clay | Iowa | 19041 | 152 | 1 |
332252 | 332252 | 2020-07-14 | Clay | Iowa | 19041 | 152 | 1 |
329065 | 329065 | 2020-07-13 | Clay | Iowa | 19041 | 151 | 1 |
325879 | 325879 | 2020-07-12 | Clay | Iowa | 19041 | 150 | 1 |
322698 | 322698 | 2020-07-11 | Clay | Iowa | 19041 | 149 | 1 |
319519 | 319519 | 2020-07-10 | Clay | Iowa | 19041 | 148 | 1 |
316346 | 316346 | 2020-07-09 | Clay | Iowa | 19041 | 145 | 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);