ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Polk" and fips = 29167 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636466 | 636466 | 2020-10-16 | Polk | Missouri | 29167 | 1039 | 19 |
633220 | 633220 | 2020-10-15 | Polk | Missouri | 29167 | 1008 | 19 |
629975 | 629975 | 2020-10-14 | Polk | Missouri | 29167 | 995 | 19 |
626731 | 626731 | 2020-10-13 | Polk | Missouri | 29167 | 973 | 19 |
623489 | 623489 | 2020-10-12 | Polk | Missouri | 29167 | 913 | 18 |
620246 | 620246 | 2020-10-11 | Polk | Missouri | 29167 | 913 | 18 |
617004 | 617004 | 2020-10-10 | Polk | Missouri | 29167 | 913 | 18 |
613763 | 613763 | 2020-10-09 | Polk | Missouri | 29167 | 913 | 18 |
610521 | 610521 | 2020-10-08 | Polk | Missouri | 29167 | 893 | 17 |
607279 | 607279 | 2020-10-07 | Polk | Missouri | 29167 | 874 | 17 |
604036 | 604036 | 2020-10-06 | Polk | Missouri | 29167 | 863 | 9 |
600794 | 600794 | 2020-10-05 | Polk | Missouri | 29167 | 850 | 9 |
597551 | 597551 | 2020-10-04 | Polk | Missouri | 29167 | 819 | 9 |
594310 | 594310 | 2020-10-03 | Polk | Missouri | 29167 | 819 | 9 |
591069 | 591069 | 2020-10-02 | Polk | Missouri | 29167 | 819 | 9 |
587828 | 587828 | 2020-10-01 | Polk | Missouri | 29167 | 805 | 9 |
584588 | 584588 | 2020-09-30 | Polk | Missouri | 29167 | 769 | 4 |
581347 | 581347 | 2020-09-29 | Polk | Missouri | 29167 | 747 | 4 |
578106 | 578106 | 2020-09-28 | Polk | Missouri | 29167 | 733 | 4 |
574865 | 574865 | 2020-09-27 | Polk | Missouri | 29167 | 688 | 4 |
571622 | 571622 | 2020-09-26 | Polk | Missouri | 29167 | 688 | 4 |
568380 | 568380 | 2020-09-25 | Polk | Missouri | 29167 | 688 | 4 |
565140 | 565140 | 2020-09-24 | Polk | Missouri | 29167 | 675 | 4 |
561900 | 561900 | 2020-09-23 | Polk | Missouri | 29167 | 629 | 4 |
558663 | 558663 | 2020-09-22 | Polk | Missouri | 29167 | 589 | 4 |
555426 | 555426 | 2020-09-21 | Polk | Missouri | 29167 | 589 | 4 |
552188 | 552188 | 2020-09-20 | Polk | Missouri | 29167 | 551 | 4 |
548949 | 548949 | 2020-09-19 | Polk | Missouri | 29167 | 551 | 4 |
545711 | 545711 | 2020-09-18 | Polk | Missouri | 29167 | 551 | 4 |
542474 | 542474 | 2020-09-17 | Polk | Missouri | 29167 | 535 | 4 |
539238 | 539238 | 2020-09-16 | Polk | Missouri | 29167 | 528 | 4 |
536001 | 536001 | 2020-09-15 | Polk | Missouri | 29167 | 519 | 4 |
532766 | 532766 | 2020-09-14 | Polk | Missouri | 29167 | 494 | 4 |
529530 | 529530 | 2020-09-13 | Polk | Missouri | 29167 | 460 | 4 |
526294 | 526294 | 2020-09-12 | Polk | Missouri | 29167 | 460 | 4 |
523058 | 523058 | 2020-09-11 | Polk | Missouri | 29167 | 460 | 4 |
519821 | 519821 | 2020-09-10 | Polk | Missouri | 29167 | 447 | 1 |
516586 | 516586 | 2020-09-09 | Polk | Missouri | 29167 | 443 | 1 |
513352 | 513352 | 2020-09-08 | Polk | Missouri | 29167 | 407 | 1 |
510120 | 510120 | 2020-09-07 | Polk | Missouri | 29167 | 366 | 1 |
506887 | 506887 | 2020-09-06 | Polk | Missouri | 29167 | 366 | 1 |
503654 | 503654 | 2020-09-05 | Polk | Missouri | 29167 | 366 | 1 |
500420 | 500420 | 2020-09-04 | Polk | Missouri | 29167 | 366 | 1 |
497186 | 497186 | 2020-09-03 | Polk | Missouri | 29167 | 366 | 1 |
493953 | 493953 | 2020-09-02 | Polk | Missouri | 29167 | 351 | 1 |
490719 | 490719 | 2020-09-01 | Polk | Missouri | 29167 | 347 | 1 |
487486 | 487486 | 2020-08-31 | Polk | Missouri | 29167 | 317 | 1 |
484252 | 484252 | 2020-08-30 | Polk | Missouri | 29167 | 317 | 1 |
481017 | 481017 | 2020-08-29 | Polk | Missouri | 29167 | 317 | 1 |
477785 | 477785 | 2020-08-28 | Polk | Missouri | 29167 | 317 | 1 |
474552 | 474552 | 2020-08-27 | Polk | Missouri | 29167 | 307 | 1 |
471320 | 471320 | 2020-08-26 | Polk | Missouri | 29167 | 302 | 1 |
468090 | 468090 | 2020-08-25 | Polk | Missouri | 29167 | 300 | 1 |
464861 | 464861 | 2020-08-24 | Polk | Missouri | 29167 | 300 | 1 |
461630 | 461630 | 2020-08-23 | Polk | Missouri | 29167 | 288 | 1 |
458403 | 458403 | 2020-08-22 | Polk | Missouri | 29167 | 288 | 1 |
455175 | 455175 | 2020-08-21 | Polk | Missouri | 29167 | 288 | 1 |
451947 | 451947 | 2020-08-20 | Polk | Missouri | 29167 | 281 | 1 |
448719 | 448719 | 2020-08-19 | Polk | Missouri | 29167 | 275 | 1 |
445493 | 445493 | 2020-08-18 | Polk | Missouri | 29167 | 271 | 1 |
442267 | 442267 | 2020-08-17 | Polk | Missouri | 29167 | 258 | 1 |
439040 | 439040 | 2020-08-16 | Polk | Missouri | 29167 | 248 | 1 |
435815 | 435815 | 2020-08-15 | Polk | Missouri | 29167 | 248 | 1 |
432589 | 432589 | 2020-08-14 | Polk | Missouri | 29167 | 248 | 1 |
429362 | 429362 | 2020-08-13 | Polk | Missouri | 29167 | 242 | 1 |
426138 | 426138 | 2020-08-12 | Polk | Missouri | 29167 | 219 | 1 |
422916 | 422916 | 2020-08-11 | Polk | Missouri | 29167 | 213 | 0 |
419694 | 419694 | 2020-08-10 | Polk | Missouri | 29167 | 210 | 0 |
416473 | 416473 | 2020-08-09 | Polk | Missouri | 29167 | 208 | 0 |
413253 | 413253 | 2020-08-08 | Polk | Missouri | 29167 | 209 | 0 |
410033 | 410033 | 2020-08-07 | Polk | Missouri | 29167 | 209 | 0 |
406813 | 406813 | 2020-08-06 | Polk | Missouri | 29167 | 200 | 0 |
403595 | 403595 | 2020-08-05 | Polk | Missouri | 29167 | 196 | 0 |
400378 | 400378 | 2020-08-04 | Polk | Missouri | 29167 | 194 | 0 |
397164 | 397164 | 2020-08-03 | Polk | Missouri | 29167 | 192 | 0 |
393948 | 393948 | 2020-08-02 | Polk | Missouri | 29167 | 191 | 0 |
390731 | 390731 | 2020-08-01 | Polk | Missouri | 29167 | 189 | 0 |
387514 | 387514 | 2020-07-31 | Polk | Missouri | 29167 | 187 | 0 |
384296 | 384296 | 2020-07-30 | Polk | Missouri | 29167 | 186 | 0 |
381080 | 381080 | 2020-07-29 | Polk | Missouri | 29167 | 184 | 0 |
377863 | 377863 | 2020-07-28 | Polk | Missouri | 29167 | 170 | 0 |
374648 | 374648 | 2020-07-27 | Polk | Missouri | 29167 | 153 | 0 |
371436 | 371436 | 2020-07-26 | Polk | Missouri | 29167 | 150 | 0 |
368225 | 368225 | 2020-07-25 | Polk | Missouri | 29167 | 150 | 0 |
365017 | 365017 | 2020-07-24 | Polk | Missouri | 29167 | 144 | 0 |
361810 | 361810 | 2020-07-23 | Polk | Missouri | 29167 | 137 | 0 |
358605 | 358605 | 2020-07-22 | Polk | Missouri | 29167 | 125 | 0 |
355402 | 355402 | 2020-07-21 | Polk | Missouri | 29167 | 114 | 0 |
352200 | 352200 | 2020-07-20 | Polk | Missouri | 29167 | 93 | 0 |
349000 | 349000 | 2020-07-19 | Polk | Missouri | 29167 | 85 | 0 |
345799 | 345799 | 2020-07-18 | Polk | Missouri | 29167 | 55 | 0 |
342599 | 342599 | 2020-07-17 | Polk | Missouri | 29167 | 26 | 0 |
339403 | 339403 | 2020-07-16 | Polk | Missouri | 29167 | 25 | 0 |
336207 | 336207 | 2020-07-15 | Polk | Missouri | 29167 | 23 | 0 |
333014 | 333014 | 2020-07-14 | Polk | Missouri | 29167 | 22 | 0 |
329827 | 329827 | 2020-07-13 | Polk | Missouri | 29167 | 22 | 0 |
326641 | 326641 | 2020-07-12 | Polk | Missouri | 29167 | 21 | 0 |
323458 | 323458 | 2020-07-11 | Polk | Missouri | 29167 | 20 | 0 |
320279 | 320279 | 2020-07-10 | Polk | Missouri | 29167 | 19 | 0 |
317104 | 317104 | 2020-07-09 | Polk | Missouri | 29167 | 19 | 0 |
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);