ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,114 rows where county = "Smith" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 389 ✖
- 3 280
- 0 270
- 1 161
- 34 137
- 2 133
- 40 104
- 7 86
- 4 81
- 52 73
- 16 66
- 11 56
- 13 56
- 8 55
- 36 50
- 67 46
- 12 39
- 68 39
- 39 36
- 53 34
- 5 33
- 66 32
- 20 30
- 37 27
- 83 22
- 10 21
- 14 21
- 15 21
- 17 21
- 27 21
- 49 21
- 50 21
- 84 21
- 964 21
- 23 20
- 41 19
- 55 17
- 35 16
- 54 15
- 73 15
- 24 14
- 30 14
- 44 14
- 65 13
- 85 13
- 19 12
- 18 11
- 57 11
- 38 10
- 6 9
- 26 9
- 33 9
- 64 9
- 487 9
- 489 9
- 492 9
- 835 9
- 31 8
- 42 8
- 43 8
- 46 8
- 47 8
- 48 8
- 51 8
- 387 8
- 839 8
- 966 8
- 71 7
- 72 7
- 74 7
- 76 7
- 80 7
- 486 7
- 837 7
- 9 6
- 28 6
- 469 6
- 483 6
- 493 6
- 962 6
- 56 5
- 63 5
- 78 5
- 110 5
- 196 5
- 462 5
- 482 5
- 490 5
- 502 5
- 504 5
- 797 5
- 821 5
- 827 5
- 951 5
- 22 4
- 58 4
- 115 4
- 219 4
- 459 4
- 484 4
- 485 4
- 819 4
- 945 4
- 958 4
- 960 4
- 968 4
- 25 3
- 29 3
- 32 3
- 59 3
- 96 3
- 125 3
- 145 3
- 156 3
- 187 3
- 189 3
- 190 3
- 211 3
- 235 3
- 269 3
- 410 3
- 422 3
- 439 3
- 447 3
- 452 3
- 468 3
- 473 3
- 475 3
- 478 3
- 481 3
- 491 3
- 496 3
- 775 3
- 809 3
- 826 3
- 829 3
- 830 3
- 855 3
- 882 3
- 884 3
- 965 3
- 967 3
- 61 2
- 89 2
- 97 2
- 99 2
- 103 2
- 124 2
- 134 2
- 203 2
- 251 2
- 307 2
- 324 2
- 338 2
- 346 2
- 375 2
- 381 2
- 389 2
- 405 2
- 411 2
- 438 2
- 441 2
- 442 2
- 448 2
- 449 2
- 450 2
- 457 2
- 463 2
- 465 2
- 497 2
- 500 2
- 524 2
- 528 2
- 534 2
- 547 2
- 550 2
- 560 2
- 600 2
- 643 2
- 726 2
- 758 2
- 787 2
- 790 2
- 811 2
- 831 2
- 841 2
- 846 2
- 864 2
- 887 2
- 890 2
- 912 2
- 916 2
- 935 2
- 947 2
- 952 2
- 954 2
- 21 1
- 45 1
- 70 1
- 77 1
- 91 1
- 94 1
- 104 1
- 105 1
- 106 1
- 107 1
- 108 1
- 112 1
- 113 1
- 117 1
- 119 1
- 120 1
- 123 1
- 127 1
- 132 1
- 135 1
- 137 1
- 139 1
- 141 1
- 144 1
- 146 1
- 147 1
- 150 1
- 159 1
- 161 1
- 167 1
- 188 1
- 192 1
- 197 1
- 200 1
- 204 1
- 207 1
- 212 1
- 213 1
- 215 1
- 218 1
- 221 1
- 226 1
- 232 1
- 237 1
- 243 1
- 248 1
- 252 1
- 254 1
- 256 1
- 259 1
- 261 1
- 267 1
- 272 1
- 273 1
- 280 1
- 284 1
- 287 1
- 289 1
- 290 1
- 292 1
- 293 1
- 295 1
- 298 1
- 303 1
- 309 1
- 312 1
- 314 1
- 318 1
- 323 1
- 329 1
- 340 1
- 347 1
- 350 1
- 355 1
- 362 1
- 367 1
- 371 1
- 378 1
- 383 1
- 388 1
- 391 1
- 396 1
- 401 1
- 404 1
- 406 1
- 407 1
- 415 1
- 416 1
- 417 1
- 419 1
- 427 1
- 428 1
- 431 1
- 433 1
- 440 1
- 444 1
- 446 1
- 454 1
- 455 1
- 456 1
- 466 1
- 467 1
- 470 1
- 472 1
- 474 1
- 476 1
- 480 1
- 488 1
- 499 1
- 503 1
- 506 1
- 507 1
- 513 1
- 518 1
- 520 1
- 543 1
- 549 1
- 553 1
- 557 1
- 563 1
- 573 1
- 581 1
- 587 1
- 599 1
- 607 1
- 613 1
- 621 1
- 629 1
- 635 1
- 645 1
- 647 1
- 665 1
- 669 1
- 677 1
- 683 1
- 684 1
- 689 1
- 700 1
- 706 1
- 713 1
- 719 1
- 733 1
- 742 1
- 745 1
- 748 1
- 751 1
- 759 1
- 763 1
- 770 1
- 772 1
- 776 1
- 777 1
- 780 1
- 782 1
- 785 1
- 786 1
- 791 1
- 804 1
- 807 1
- 817 1
- 818 1
- 824 1
- 825 1
- 833 1
- 840 1
- 842 1
- 843 1
- 848 1
- 850 1
- 852 1
- 854 1
- 856 1
- 860 1
- 867 1
- 868 1
- 869 1
- 870 1
- 872 1
- 878 1
- 879 1
- 893 1
- 894 1
- 903 1
- 907 1
- 919 1
- 924 1
- 925 1
- 927 1
- 929 1
- 933 1
- 936 1
- 938 1
- 943 1
- 959 1
state 4
- Texas 792
- Mississippi 785
- Tennessee 778
- Kansas 759
county 1
- Smith · 3,114 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1889 | 1889 | 2020-03-13 | Smith | Texas | 48423 | 3 | 0 |
2256 | 2256 | 2020-03-14 | Smith | Texas | 48423 | 3 | 0 |
2682 | 2682 | 2020-03-15 | Smith | Texas | 48423 | 4 | 0 |
3151 | 3151 | 2020-03-16 | Smith | Texas | 48423 | 4 | 0 |
3687 | 3687 | 2020-03-17 | Smith | Texas | 48423 | 4 | 0 |
4314 | 4314 | 2020-03-18 | Smith | Texas | 48423 | 5 | 0 |
5069 | 5069 | 2020-03-19 | Smith | Texas | 48423 | 5 | 0 |
5628 | 5628 | 2020-03-20 | Smith | Mississippi | 28129 | 1 | 0 |
5962 | 5962 | 2020-03-20 | Smith | Texas | 48423 | 8 | 0 |
6612 | 6612 | 2020-03-21 | Smith | Mississippi | 28129 | 1 | 0 |
6985 | 6985 | 2020-03-21 | Smith | Texas | 48423 | 8 | 0 |
7698 | 7698 | 2020-03-22 | Smith | Mississippi | 28129 | 1 | 0 |
8115 | 8115 | 2020-03-22 | Smith | Texas | 48423 | 10 | 0 |
8880 | 8880 | 2020-03-23 | Smith | Mississippi | 28129 | 1 | 0 |
9334 | 9334 | 2020-03-23 | Smith | Texas | 48423 | 10 | 0 |
10178 | 10178 | 2020-03-24 | Smith | Mississippi | 28129 | 1 | 0 |
10676 | 10676 | 2020-03-24 | Smith | Texas | 48423 | 10 | 0 |
11599 | 11599 | 2020-03-25 | Smith | Mississippi | 28129 | 1 | 0 |
12182 | 12182 | 2020-03-25 | Smith | Texas | 48423 | 14 | 0 |
13193 | 13193 | 2020-03-26 | Smith | Mississippi | 28129 | 1 | 0 |
13816 | 13816 | 2020-03-26 | Smith | Texas | 48423 | 21 | 1 |
14913 | 14913 | 2020-03-27 | Smith | Mississippi | 28129 | 1 | 0 |
15481 | 15481 | 2020-03-27 | Smith | Tennessee | 47159 | 1 | 0 |
15576 | 15576 | 2020-03-27 | Smith | Texas | 48423 | 27 | 1 |
16737 | 16737 | 2020-03-28 | Smith | Mississippi | 28129 | 1 | 0 |
17345 | 17345 | 2020-03-28 | Smith | Tennessee | 47159 | 1 | 0 |
17447 | 17447 | 2020-03-28 | Smith | Texas | 48423 | 27 | 1 |
18659 | 18659 | 2020-03-29 | Smith | Mississippi | 28129 | 1 | 0 |
19295 | 19295 | 2020-03-29 | Smith | Tennessee | 47159 | 1 | 0 |
19404 | 19404 | 2020-03-29 | Smith | Texas | 48423 | 31 | 1 |
20683 | 20683 | 2020-03-30 | Smith | Mississippi | 28129 | 1 | 0 |
21352 | 21352 | 2020-03-30 | Smith | Tennessee | 47159 | 1 | 0 |
21466 | 21466 | 2020-03-30 | Smith | Texas | 48423 | 32 | 1 |
22800 | 22800 | 2020-03-31 | Smith | Mississippi | 28129 | 1 | 0 |
23491 | 23491 | 2020-03-31 | Smith | Tennessee | 47159 | 1 | 0 |
23605 | 23605 | 2020-03-31 | Smith | Texas | 48423 | 32 | 1 |
24984 | 24984 | 2020-04-01 | Smith | Mississippi | 28129 | 1 | 0 |
25694 | 25694 | 2020-04-01 | Smith | Tennessee | 47159 | 3 | 0 |
25819 | 25819 | 2020-04-01 | Smith | Texas | 48423 | 43 | 1 |
27238 | 27238 | 2020-04-02 | Smith | Mississippi | 28129 | 6 | 0 |
27974 | 27974 | 2020-04-02 | Smith | Tennessee | 47159 | 3 | 0 |
28107 | 28107 | 2020-04-02 | Smith | Texas | 48423 | 47 | 1 |
29557 | 29557 | 2020-04-03 | Smith | Mississippi | 28129 | 6 | 0 |
30309 | 30309 | 2020-04-03 | Smith | Tennessee | 47159 | 3 | 0 |
30443 | 30443 | 2020-04-03 | Smith | Texas | 48423 | 53 | 1 |
31937 | 31937 | 2020-04-04 | Smith | Mississippi | 28129 | 6 | 0 |
32700 | 32700 | 2020-04-04 | Smith | Tennessee | 47159 | 3 | 0 |
32839 | 32839 | 2020-04-04 | Smith | Texas | 48423 | 57 | 1 |
34364 | 34364 | 2020-04-05 | Smith | Mississippi | 28129 | 10 | 0 |
35137 | 35137 | 2020-04-05 | Smith | Tennessee | 47159 | 3 | 0 |
35277 | 35277 | 2020-04-05 | Smith | Texas | 48423 | 57 | 1 |
36827 | 36827 | 2020-04-06 | Smith | Mississippi | 28129 | 11 | 0 |
37613 | 37613 | 2020-04-06 | Smith | Tennessee | 47159 | 3 | 0 |
37754 | 37754 | 2020-04-06 | Smith | Texas | 48423 | 62 | 2 |
39338 | 39338 | 2020-04-07 | Smith | Mississippi | 28129 | 11 | 0 |
40136 | 40136 | 2020-04-07 | Smith | Tennessee | 47159 | 3 | 0 |
40283 | 40283 | 2020-04-07 | Smith | Texas | 48423 | 63 | 2 |
41892 | 41892 | 2020-04-08 | Smith | Mississippi | 28129 | 15 | 0 |
42698 | 42698 | 2020-04-08 | Smith | Tennessee | 47159 | 3 | 0 |
42851 | 42851 | 2020-04-08 | Smith | Texas | 48423 | 82 | 2 |
44469 | 44469 | 2020-04-09 | Smith | Mississippi | 28129 | 16 | 0 |
45285 | 45285 | 2020-04-09 | Smith | Tennessee | 47159 | 5 | 0 |
45445 | 45445 | 2020-04-09 | Smith | Texas | 48423 | 82 | 2 |
47078 | 47078 | 2020-04-10 | Smith | Mississippi | 28129 | 17 | 1 |
47903 | 47903 | 2020-04-10 | Smith | Tennessee | 47159 | 5 | 0 |
48067 | 48067 | 2020-04-10 | Smith | Texas | 48423 | 93 | 2 |
49724 | 49724 | 2020-04-11 | Smith | Mississippi | 28129 | 23 | 1 |
50561 | 50561 | 2020-04-11 | Smith | Tennessee | 47159 | 7 | 0 |
50725 | 50725 | 2020-04-11 | Smith | Texas | 48423 | 93 | 2 |
52397 | 52397 | 2020-04-12 | Smith | Mississippi | 28129 | 24 | 1 |
53236 | 53236 | 2020-04-12 | Smith | Tennessee | 47159 | 7 | 0 |
53400 | 53400 | 2020-04-12 | Smith | Texas | 48423 | 96 | 2 |
55079 | 55079 | 2020-04-13 | Smith | Mississippi | 28129 | 28 | 1 |
55923 | 55923 | 2020-04-13 | Smith | Tennessee | 47159 | 10 | 0 |
56089 | 56089 | 2020-04-13 | Smith | Texas | 48423 | 101 | 2 |
57777 | 57777 | 2020-04-14 | Smith | Mississippi | 28129 | 30 | 1 |
58626 | 58626 | 2020-04-14 | Smith | Tennessee | 47159 | 10 | 0 |
58794 | 58794 | 2020-04-14 | Smith | Texas | 48423 | 103 | 2 |
60039 | 60039 | 2020-04-15 | Smith | Kansas | 20183 | 1 | 0 |
60488 | 60488 | 2020-04-15 | Smith | Mississippi | 28129 | 36 | 1 |
61342 | 61342 | 2020-04-15 | Smith | Tennessee | 47159 | 11 | 1 |
61512 | 61512 | 2020-04-15 | Smith | Texas | 48423 | 108 | 2 |
62760 | 62760 | 2020-04-16 | Smith | Kansas | 20183 | 1 | 0 |
63210 | 63210 | 2020-04-16 | Smith | Mississippi | 28129 | 37 | 1 |
64069 | 64069 | 2020-04-16 | Smith | Tennessee | 47159 | 11 | 1 |
64244 | 64244 | 2020-04-16 | Smith | Texas | 48423 | 108 | 2 |
65497 | 65497 | 2020-04-17 | Smith | Kansas | 20183 | 2 | 0 |
65950 | 65950 | 2020-04-17 | Smith | Mississippi | 28129 | 38 | 1 |
66816 | 66816 | 2020-04-17 | Smith | Tennessee | 47159 | 12 | 1 |
66991 | 66991 | 2020-04-17 | Smith | Texas | 48423 | 116 | 2 |
68246 | 68246 | 2020-04-18 | Smith | Kansas | 20183 | 2 | 0 |
68702 | 68702 | 2020-04-18 | Smith | Mississippi | 28129 | 39 | 1 |
69575 | 69575 | 2020-04-18 | Smith | Tennessee | 47159 | 12 | 1 |
69751 | 69751 | 2020-04-18 | Smith | Texas | 48423 | 121 | 2 |
71008 | 71008 | 2020-04-19 | Smith | Kansas | 20183 | 2 | 0 |
71468 | 71468 | 2020-04-19 | Smith | Mississippi | 28129 | 45 | 1 |
72342 | 72342 | 2020-04-19 | Smith | Tennessee | 47159 | 13 | 1 |
72521 | 72521 | 2020-04-19 | Smith | Texas | 48423 | 121 | 3 |
73780 | 73780 | 2020-04-20 | Smith | Kansas | 20183 | 2 | 0 |
74241 | 74241 | 2020-04-20 | Smith | Mississippi | 28129 | 47 | 2 |
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);