ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,374 rows where county = "Williamson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Williamson · 559 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535121 | 535121 | 2020-09-15 | Williamson | Illinois | 17199 | 1204 | 27 |
537035 | 537035 | 2020-09-15 | Williamson | Tennessee | 47187 | 4879 | 35 |
537279 | 537279 | 2020-09-15 | Williamson | Texas | 48491 | 8446 | 135 |
531886 | 531886 | 2020-09-14 | Williamson | Illinois | 17199 | 1183 | 27 |
533799 | 533799 | 2020-09-14 | Williamson | Tennessee | 47187 | 4851 | 35 |
534043 | 534043 | 2020-09-14 | Williamson | Texas | 48491 | 8421 | 135 |
528649 | 528649 | 2020-09-13 | Williamson | Illinois | 17199 | 1160 | 27 |
530564 | 530564 | 2020-09-13 | Williamson | Tennessee | 47187 | 4788 | 35 |
530808 | 530808 | 2020-09-13 | Williamson | Texas | 48491 | 8337 | 135 |
525413 | 525413 | 2020-09-12 | Williamson | Illinois | 17199 | 1141 | 26 |
527327 | 527327 | 2020-09-12 | Williamson | Tennessee | 47187 | 4755 | 35 |
527571 | 527571 | 2020-09-12 | Williamson | Texas | 48491 | 8337 | 135 |
522177 | 522177 | 2020-09-11 | Williamson | Illinois | 17199 | 1126 | 26 |
524091 | 524091 | 2020-09-11 | Williamson | Tennessee | 47187 | 4733 | 34 |
524335 | 524335 | 2020-09-11 | Williamson | Texas | 48491 | 8337 | 135 |
518940 | 518940 | 2020-09-10 | Williamson | Illinois | 17199 | 1098 | 23 |
520855 | 520855 | 2020-09-10 | Williamson | Tennessee | 47187 | 4685 | 34 |
521099 | 521099 | 2020-09-10 | Williamson | Texas | 48491 | 8318 | 133 |
515705 | 515705 | 2020-09-09 | Williamson | Illinois | 17199 | 1068 | 24 |
517619 | 517619 | 2020-09-09 | Williamson | Tennessee | 47187 | 4609 | 32 |
517863 | 517863 | 2020-09-09 | Williamson | Texas | 48491 | 8296 | 132 |
512472 | 512472 | 2020-09-08 | Williamson | Illinois | 17199 | 1065 | 20 |
514384 | 514384 | 2020-09-08 | Williamson | Tennessee | 47187 | 4585 | 32 |
514628 | 514628 | 2020-09-08 | Williamson | Texas | 48491 | 8281 | 132 |
509239 | 509239 | 2020-09-07 | Williamson | Illinois | 17199 | 1058 | 18 |
511151 | 511151 | 2020-09-07 | Williamson | Tennessee | 47187 | 4572 | 31 |
511395 | 511395 | 2020-09-07 | Williamson | Texas | 48491 | 8213 | 131 |
506007 | 506007 | 2020-09-06 | Williamson | Illinois | 17199 | 1036 | 18 |
507918 | 507918 | 2020-09-06 | Williamson | Tennessee | 47187 | 4548 | 30 |
508162 | 508162 | 2020-09-06 | Williamson | Texas | 48491 | 8213 | 131 |
502773 | 502773 | 2020-09-05 | Williamson | Illinois | 17199 | 1024 | 18 |
504686 | 504686 | 2020-09-05 | Williamson | Tennessee | 47187 | 4501 | 30 |
504930 | 504930 | 2020-09-05 | Williamson | Texas | 48491 | 8213 | 130 |
499539 | 499539 | 2020-09-04 | Williamson | Illinois | 17199 | 1017 | 16 |
501452 | 501452 | 2020-09-04 | Williamson | Tennessee | 47187 | 4455 | 30 |
501696 | 501696 | 2020-09-04 | Williamson | Texas | 48491 | 8213 | 128 |
496306 | 496306 | 2020-09-03 | Williamson | Illinois | 17199 | 965 | 14 |
498218 | 498218 | 2020-09-03 | Williamson | Tennessee | 47187 | 4424 | 29 |
498462 | 498462 | 2020-09-03 | Williamson | Texas | 48491 | 8195 | 126 |
493072 | 493072 | 2020-09-02 | Williamson | Illinois | 17199 | 960 | 14 |
494985 | 494985 | 2020-09-02 | Williamson | Tennessee | 47187 | 4465 | 30 |
495229 | 495229 | 2020-09-02 | Williamson | Texas | 48491 | 8173 | 126 |
489839 | 489839 | 2020-09-01 | Williamson | Illinois | 17199 | 927 | 13 |
491751 | 491751 | 2020-09-01 | Williamson | Tennessee | 47187 | 4422 | 30 |
491995 | 491995 | 2020-09-01 | Williamson | Texas | 48491 | 8158 | 124 |
486606 | 486606 | 2020-08-31 | Williamson | Illinois | 17199 | 908 | 12 |
488518 | 488518 | 2020-08-31 | Williamson | Tennessee | 47187 | 4369 | 28 |
488762 | 488762 | 2020-08-31 | Williamson | Texas | 48491 | 8138 | 124 |
483371 | 483371 | 2020-08-30 | Williamson | Illinois | 17199 | 879 | 12 |
485285 | 485285 | 2020-08-30 | Williamson | Tennessee | 47187 | 4334 | 28 |
485529 | 485529 | 2020-08-30 | Williamson | Texas | 48491 | 8079 | 123 |
480137 | 480137 | 2020-08-29 | Williamson | Illinois | 17199 | 860 | 12 |
482050 | 482050 | 2020-08-29 | Williamson | Tennessee | 47187 | 4328 | 27 |
482294 | 482294 | 2020-08-29 | Williamson | Texas | 48491 | 8079 | 123 |
476904 | 476904 | 2020-08-28 | Williamson | Illinois | 17199 | 812 | 12 |
478816 | 478816 | 2020-08-28 | Williamson | Tennessee | 47187 | 4295 | 27 |
479060 | 479060 | 2020-08-28 | Williamson | Texas | 48491 | 8079 | 120 |
473671 | 473671 | 2020-08-27 | Williamson | Illinois | 17199 | 806 | 11 |
475583 | 475583 | 2020-08-27 | Williamson | Tennessee | 47187 | 4260 | 27 |
475827 | 475827 | 2020-08-27 | Williamson | Texas | 48491 | 8053 | 119 |
470439 | 470439 | 2020-08-26 | Williamson | Illinois | 17199 | 784 | 11 |
472350 | 472350 | 2020-08-26 | Williamson | Tennessee | 47187 | 4210 | 27 |
472594 | 472594 | 2020-08-26 | Williamson | Texas | 48491 | 8006 | 116 |
467210 | 467210 | 2020-08-25 | Williamson | Illinois | 17199 | 747 | 10 |
469118 | 469118 | 2020-08-25 | Williamson | Tennessee | 47187 | 4165 | 27 |
469362 | 469362 | 2020-08-25 | Williamson | Texas | 48491 | 7976 | 115 |
463981 | 463981 | 2020-08-24 | Williamson | Illinois | 17199 | 716 | 9 |
465889 | 465889 | 2020-08-24 | Williamson | Tennessee | 47187 | 4157 | 27 |
466133 | 466133 | 2020-08-24 | Williamson | Texas | 48491 | 7927 | 114 |
460752 | 460752 | 2020-08-23 | Williamson | Illinois | 17199 | 695 | 9 |
462660 | 462660 | 2020-08-23 | Williamson | Tennessee | 47187 | 4140 | 27 |
462904 | 462904 | 2020-08-23 | Williamson | Texas | 48491 | 7867 | 113 |
457525 | 457525 | 2020-08-22 | Williamson | Illinois | 17199 | 673 | 9 |
459431 | 459431 | 2020-08-22 | Williamson | Tennessee | 47187 | 4096 | 27 |
459675 | 459675 | 2020-08-22 | Williamson | Texas | 48491 | 7867 | 113 |
454297 | 454297 | 2020-08-21 | Williamson | Illinois | 17199 | 654 | 9 |
456204 | 456204 | 2020-08-21 | Williamson | Tennessee | 47187 | 4055 | 27 |
456448 | 456448 | 2020-08-21 | Williamson | Texas | 48491 | 7867 | 113 |
451069 | 451069 | 2020-08-20 | Williamson | Illinois | 17199 | 637 | 8 |
452976 | 452976 | 2020-08-20 | Williamson | Tennessee | 47187 | 4014 | 26 |
453220 | 453220 | 2020-08-20 | Williamson | Texas | 48491 | 7827 | 113 |
447841 | 447841 | 2020-08-19 | Williamson | Illinois | 17199 | 620 | 7 |
449748 | 449748 | 2020-08-19 | Williamson | Tennessee | 47187 | 3979 | 26 |
449992 | 449992 | 2020-08-19 | Williamson | Texas | 48491 | 7803 | 110 |
444614 | 444614 | 2020-08-18 | Williamson | Illinois | 17199 | 568 | 7 |
446520 | 446520 | 2020-08-18 | Williamson | Tennessee | 47187 | 3932 | 27 |
446764 | 446764 | 2020-08-18 | Williamson | Texas | 48491 | 7759 | 105 |
441388 | 441388 | 2020-08-17 | Williamson | Illinois | 17199 | 552 | 7 |
443293 | 443293 | 2020-08-17 | Williamson | Tennessee | 47187 | 3893 | 26 |
443537 | 443537 | 2020-08-17 | Williamson | Texas | 48491 | 7661 | 103 |
438162 | 438162 | 2020-08-16 | Williamson | Illinois | 17199 | 534 | 7 |
440067 | 440067 | 2020-08-16 | Williamson | Tennessee | 47187 | 3861 | 26 |
440311 | 440311 | 2020-08-16 | Williamson | Texas | 48491 | 7506 | 103 |
434936 | 434936 | 2020-08-15 | Williamson | Illinois | 17199 | 512 | 7 |
436841 | 436841 | 2020-08-15 | Williamson | Tennessee | 47187 | 3812 | 26 |
437085 | 437085 | 2020-08-15 | Williamson | Texas | 48491 | 7506 | 103 |
431711 | 431711 | 2020-08-14 | Williamson | Illinois | 17199 | 499 | 7 |
433615 | 433615 | 2020-08-14 | Williamson | Tennessee | 47187 | 3741 | 25 |
433859 | 433859 | 2020-08-14 | Williamson | Texas | 48491 | 7506 | 103 |
428483 | 428483 | 2020-08-13 | Williamson | Illinois | 17199 | 477 | 7 |
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);