ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Dubuque" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
278449 | 278449 | 2020-06-27 | Dubuque | Iowa | 19061 | 497 | 22 |
281597 | 281597 | 2020-06-28 | Dubuque | Iowa | 19061 | 500 | 22 |
284742 | 284742 | 2020-06-29 | Dubuque | Iowa | 19061 | 501 | 22 |
287891 | 287891 | 2020-06-30 | Dubuque | Iowa | 19061 | 523 | 22 |
291041 | 291041 | 2020-07-01 | Dubuque | Iowa | 19061 | 546 | 22 |
294195 | 294195 | 2020-07-02 | Dubuque | Iowa | 19061 | 609 | 22 |
297353 | 297353 | 2020-07-03 | Dubuque | Iowa | 19061 | 627 | 22 |
300515 | 300515 | 2020-07-04 | Dubuque | Iowa | 19061 | 685 | 22 |
303679 | 303679 | 2020-07-05 | Dubuque | Iowa | 19061 | 700 | 22 |
306844 | 306844 | 2020-07-06 | Dubuque | Iowa | 19061 | 702 | 22 |
310012 | 310012 | 2020-07-07 | Dubuque | Iowa | 19061 | 742 | 22 |
313182 | 313182 | 2020-07-08 | Dubuque | Iowa | 19061 | 773 | 22 |
316356 | 316356 | 2020-07-09 | Dubuque | Iowa | 19061 | 835 | 22 |
319529 | 319529 | 2020-07-10 | Dubuque | Iowa | 19061 | 920 | 23 |
322708 | 322708 | 2020-07-11 | Dubuque | Iowa | 19061 | 941 | 23 |
325889 | 325889 | 2020-07-12 | Dubuque | Iowa | 19061 | 978 | 23 |
329075 | 329075 | 2020-07-13 | Dubuque | Iowa | 19061 | 1000 | 23 |
332262 | 332262 | 2020-07-14 | Dubuque | Iowa | 19061 | 1022 | 23 |
335455 | 335455 | 2020-07-15 | Dubuque | Iowa | 19061 | 1054 | 23 |
338651 | 338651 | 2020-07-16 | Dubuque | Iowa | 19061 | 1122 | 23 |
341847 | 341847 | 2020-07-17 | Dubuque | Iowa | 19061 | 1136 | 23 |
345047 | 345047 | 2020-07-18 | Dubuque | Iowa | 19061 | 1170 | 23 |
348248 | 348248 | 2020-07-19 | Dubuque | Iowa | 19061 | 1189 | 23 |
351448 | 351448 | 2020-07-20 | Dubuque | Iowa | 19061 | 1215 | 23 |
354650 | 354650 | 2020-07-21 | Dubuque | Iowa | 19061 | 1237 | 24 |
357852 | 357852 | 2020-07-22 | Dubuque | Iowa | 19061 | 1265 | 24 |
361057 | 361057 | 2020-07-23 | Dubuque | Iowa | 19061 | 1301 | 26 |
364264 | 364264 | 2020-07-24 | Dubuque | Iowa | 19061 | 1324 | 26 |
367471 | 367471 | 2020-07-25 | Dubuque | Iowa | 19061 | 1340 | 26 |
370681 | 370681 | 2020-07-26 | Dubuque | Iowa | 19061 | 1355 | 26 |
373893 | 373893 | 2020-07-27 | Dubuque | Iowa | 19061 | 1368 | 26 |
377108 | 377108 | 2020-07-28 | Dubuque | Iowa | 19061 | 1384 | 26 |
380325 | 380325 | 2020-07-29 | Dubuque | Iowa | 19061 | 1416 | 28 |
383542 | 383542 | 2020-07-30 | Dubuque | Iowa | 19061 | 1452 | 28 |
386760 | 386760 | 2020-07-31 | Dubuque | Iowa | 19061 | 1484 | 28 |
389977 | 389977 | 2020-08-01 | Dubuque | Iowa | 19061 | 1503 | 29 |
393194 | 393194 | 2020-08-02 | Dubuque | Iowa | 19061 | 1527 | 29 |
396410 | 396410 | 2020-08-03 | Dubuque | Iowa | 19061 | 1537 | 29 |
399626 | 399626 | 2020-08-04 | Dubuque | Iowa | 19061 | 1549 | 29 |
402842 | 402842 | 2020-08-05 | Dubuque | Iowa | 19061 | 1594 | 31 |
406060 | 406060 | 2020-08-06 | Dubuque | Iowa | 19061 | 1623 | 31 |
409280 | 409280 | 2020-08-07 | Dubuque | Iowa | 19061 | 1647 | 31 |
412499 | 412499 | 2020-08-08 | Dubuque | Iowa | 19061 | 1665 | 31 |
415719 | 415719 | 2020-08-09 | Dubuque | Iowa | 19061 | 1676 | 31 |
418940 | 418940 | 2020-08-10 | Dubuque | Iowa | 19061 | 1686 | 31 |
422163 | 422163 | 2020-08-11 | Dubuque | Iowa | 19061 | 1698 | 31 |
425384 | 425384 | 2020-08-12 | Dubuque | Iowa | 19061 | 1722 | 31 |
428608 | 428608 | 2020-08-13 | Dubuque | Iowa | 19061 | 1744 | 31 |
431836 | 431836 | 2020-08-14 | Dubuque | Iowa | 19061 | 1773 | 31 |
435061 | 435061 | 2020-08-15 | Dubuque | Iowa | 19061 | 1795 | 31 |
438287 | 438287 | 2020-08-16 | Dubuque | Iowa | 19061 | 1797 | 31 |
441513 | 441513 | 2020-08-17 | Dubuque | Iowa | 19061 | 1816 | 31 |
444739 | 444739 | 2020-08-18 | Dubuque | Iowa | 19061 | 1823 | 33 |
447966 | 447966 | 2020-08-19 | Dubuque | Iowa | 19061 | 1849 | 34 |
451194 | 451194 | 2020-08-20 | Dubuque | Iowa | 19061 | 1868 | 34 |
454422 | 454422 | 2020-08-21 | Dubuque | Iowa | 19061 | 1885 | 35 |
457650 | 457650 | 2020-08-22 | Dubuque | Iowa | 19061 | 1899 | 35 |
460877 | 460877 | 2020-08-23 | Dubuque | Iowa | 19061 | 1903 | 35 |
464106 | 464106 | 2020-08-24 | Dubuque | Iowa | 19061 | 1907 | 35 |
467335 | 467335 | 2020-08-25 | Dubuque | Iowa | 19061 | 1920 | 36 |
470564 | 470564 | 2020-08-26 | Dubuque | Iowa | 19061 | 1938 | 36 |
473796 | 473796 | 2020-08-27 | Dubuque | Iowa | 19061 | 1966 | 36 |
477029 | 477029 | 2020-08-28 | Dubuque | Iowa | 19061 | 1984 | 36 |
480262 | 480262 | 2020-08-29 | Dubuque | Iowa | 19061 | 2016 | 36 |
483496 | 483496 | 2020-08-30 | Dubuque | Iowa | 19061 | 2027 | 36 |
486731 | 486731 | 2020-08-31 | Dubuque | Iowa | 19061 | 2039 | 36 |
489964 | 489964 | 2020-09-01 | Dubuque | Iowa | 19061 | 2049 | 36 |
493197 | 493197 | 2020-09-02 | Dubuque | Iowa | 19061 | 2064 | 36 |
496431 | 496431 | 2020-09-03 | Dubuque | Iowa | 19061 | 2106 | 36 |
499664 | 499664 | 2020-09-04 | Dubuque | Iowa | 19061 | 2139 | 36 |
502898 | 502898 | 2020-09-05 | Dubuque | Iowa | 19061 | 2165 | 36 |
506132 | 506132 | 2020-09-06 | Dubuque | Iowa | 19061 | 2179 | 36 |
509364 | 509364 | 2020-09-07 | Dubuque | Iowa | 19061 | 2197 | 36 |
512597 | 512597 | 2020-09-08 | Dubuque | Iowa | 19061 | 2226 | 36 |
515830 | 515830 | 2020-09-09 | Dubuque | Iowa | 19061 | 2263 | 37 |
519065 | 519065 | 2020-09-10 | Dubuque | Iowa | 19061 | 2296 | 37 |
522302 | 522302 | 2020-09-11 | Dubuque | Iowa | 19061 | 2340 | 37 |
525538 | 525538 | 2020-09-12 | Dubuque | Iowa | 19061 | 2372 | 37 |
528774 | 528774 | 2020-09-13 | Dubuque | Iowa | 19061 | 2384 | 37 |
532011 | 532011 | 2020-09-14 | Dubuque | Iowa | 19061 | 2416 | 38 |
535246 | 535246 | 2020-09-15 | Dubuque | Iowa | 19061 | 2436 | 38 |
538482 | 538482 | 2020-09-16 | Dubuque | Iowa | 19061 | 2501 | 40 |
541719 | 541719 | 2020-09-17 | Dubuque | Iowa | 19061 | 2568 | 40 |
544955 | 544955 | 2020-09-18 | Dubuque | Iowa | 19061 | 2661 | 40 |
548193 | 548193 | 2020-09-19 | Dubuque | Iowa | 19061 | 2760 | 40 |
551432 | 551432 | 2020-09-20 | Dubuque | Iowa | 19061 | 2798 | 40 |
554671 | 554671 | 2020-09-21 | Dubuque | Iowa | 19061 | 2823 | 41 |
557908 | 557908 | 2020-09-22 | Dubuque | Iowa | 19061 | 2894 | 41 |
561144 | 561144 | 2020-09-23 | Dubuque | Iowa | 19061 | 2991 | 41 |
564384 | 564384 | 2020-09-24 | Dubuque | Iowa | 19061 | 3101 | 41 |
567624 | 567624 | 2020-09-25 | Dubuque | Iowa | 19061 | 3173 | 41 |
570866 | 570866 | 2020-09-26 | Dubuque | Iowa | 19061 | 3257 | 41 |
574109 | 574109 | 2020-09-27 | Dubuque | Iowa | 19061 | 3283 | 41 |
577351 | 577351 | 2020-09-28 | Dubuque | Iowa | 19061 | 3332 | 41 |
580592 | 580592 | 2020-09-29 | Dubuque | Iowa | 19061 | 3402 | 42 |
583831 | 583831 | 2020-09-30 | Dubuque | Iowa | 19061 | 3474 | 43 |
587071 | 587071 | 2020-10-01 | Dubuque | Iowa | 19061 | 3539 | 43 |
590312 | 590312 | 2020-10-02 | Dubuque | Iowa | 19061 | 3605 | 44 |
593553 | 593553 | 2020-10-03 | Dubuque | Iowa | 19061 | 3696 | 44 |
596795 | 596795 | 2020-10-04 | Dubuque | Iowa | 19061 | 3714 | 44 |
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);