ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,307 rows where county = "Todd" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
state 3
- South Dakota 778
- Kentucky 767
- Minnesota 762
county 1
- Todd · 2,307 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15430 | 15430 | 2020-03-27 | Todd | South Dakota | 46121 | 1 | 0 |
17288 | 17288 | 2020-03-28 | Todd | South Dakota | 46121 | 1 | 0 |
19232 | 19232 | 2020-03-29 | Todd | South Dakota | 46121 | 1 | 0 |
21285 | 21285 | 2020-03-30 | Todd | South Dakota | 46121 | 1 | 0 |
23423 | 23423 | 2020-03-31 | Todd | South Dakota | 46121 | 1 | 0 |
25621 | 25621 | 2020-04-01 | Todd | South Dakota | 46121 | 1 | 0 |
27899 | 27899 | 2020-04-02 | Todd | South Dakota | 46121 | 1 | 0 |
30234 | 30234 | 2020-04-03 | Todd | South Dakota | 46121 | 1 | 0 |
32625 | 32625 | 2020-04-04 | Todd | South Dakota | 46121 | 1 | 0 |
35061 | 35061 | 2020-04-05 | Todd | South Dakota | 46121 | 1 | 0 |
37536 | 37536 | 2020-04-06 | Todd | South Dakota | 46121 | 1 | 0 |
39013 | 39013 | 2020-04-07 | Todd | Kentucky | 21219 | 2 | 0 |
40059 | 40059 | 2020-04-07 | Todd | South Dakota | 46121 | 1 | 0 |
41563 | 41563 | 2020-04-08 | Todd | Kentucky | 21219 | 3 | 0 |
42620 | 42620 | 2020-04-08 | Todd | South Dakota | 46121 | 1 | 0 |
44139 | 44139 | 2020-04-09 | Todd | Kentucky | 21219 | 3 | 0 |
45208 | 45208 | 2020-04-09 | Todd | South Dakota | 46121 | 1 | 0 |
46747 | 46747 | 2020-04-10 | Todd | Kentucky | 21219 | 5 | 0 |
47826 | 47826 | 2020-04-10 | Todd | South Dakota | 46121 | 1 | 0 |
49388 | 49388 | 2020-04-11 | Todd | Kentucky | 21219 | 6 | 0 |
50484 | 50484 | 2020-04-11 | Todd | South Dakota | 46121 | 1 | 0 |
52056 | 52056 | 2020-04-12 | Todd | Kentucky | 21219 | 7 | 0 |
52323 | 52323 | 2020-04-12 | Todd | Minnesota | 27153 | 2 | 0 |
53158 | 53158 | 2020-04-12 | Todd | South Dakota | 46121 | 1 | 0 |
54737 | 54737 | 2020-04-13 | Todd | Kentucky | 21219 | 7 | 0 |
55005 | 55005 | 2020-04-13 | Todd | Minnesota | 27153 | 2 | 0 |
55844 | 55844 | 2020-04-13 | Todd | South Dakota | 46121 | 1 | 0 |
57435 | 57435 | 2020-04-14 | Todd | Kentucky | 21219 | 8 | 0 |
57703 | 57703 | 2020-04-14 | Todd | Minnesota | 27153 | 2 | 0 |
58547 | 58547 | 2020-04-14 | Todd | South Dakota | 46121 | 1 | 0 |
60144 | 60144 | 2020-04-15 | Todd | Kentucky | 21219 | 10 | 0 |
60414 | 60414 | 2020-04-15 | Todd | Minnesota | 27153 | 2 | 0 |
61262 | 61262 | 2020-04-15 | Todd | South Dakota | 46121 | 1 | 0 |
62864 | 62864 | 2020-04-16 | Todd | Kentucky | 21219 | 10 | 0 |
63137 | 63137 | 2020-04-16 | Todd | Minnesota | 27153 | 2 | 0 |
63989 | 63989 | 2020-04-16 | Todd | South Dakota | 46121 | 1 | 0 |
65603 | 65603 | 2020-04-17 | Todd | Kentucky | 21219 | 10 | 0 |
65876 | 65876 | 2020-04-17 | Todd | Minnesota | 27153 | 2 | 0 |
66735 | 66735 | 2020-04-17 | Todd | South Dakota | 46121 | 1 | 0 |
68352 | 68352 | 2020-04-18 | Todd | Kentucky | 21219 | 11 | 0 |
68628 | 68628 | 2020-04-18 | Todd | Minnesota | 27153 | 2 | 0 |
69493 | 69493 | 2020-04-18 | Todd | South Dakota | 46121 | 1 | 0 |
71115 | 71115 | 2020-04-19 | Todd | Kentucky | 21219 | 9 | 0 |
71394 | 71394 | 2020-04-19 | Todd | Minnesota | 27153 | 2 | 0 |
72260 | 72260 | 2020-04-19 | Todd | South Dakota | 46121 | 1 | 0 |
73887 | 73887 | 2020-04-20 | Todd | Kentucky | 21219 | 9 | 0 |
74167 | 74167 | 2020-04-20 | Todd | Minnesota | 27153 | 3 | 0 |
75035 | 75035 | 2020-04-20 | Todd | South Dakota | 46121 | 1 | 0 |
76668 | 76668 | 2020-04-21 | Todd | Kentucky | 21219 | 9 | 0 |
76948 | 76948 | 2020-04-21 | Todd | Minnesota | 27153 | 3 | 0 |
77817 | 77817 | 2020-04-21 | Todd | South Dakota | 46121 | 1 | 0 |
79453 | 79453 | 2020-04-22 | Todd | Kentucky | 21219 | 9 | 0 |
79733 | 79733 | 2020-04-22 | Todd | Minnesota | 27153 | 3 | 0 |
80607 | 80607 | 2020-04-22 | Todd | South Dakota | 46121 | 1 | 0 |
82250 | 82250 | 2020-04-23 | Todd | Kentucky | 21219 | 9 | 0 |
82529 | 82529 | 2020-04-23 | Todd | Minnesota | 27153 | 3 | 0 |
83406 | 83406 | 2020-04-23 | Todd | South Dakota | 46121 | 1 | 0 |
85053 | 85053 | 2020-04-24 | Todd | Kentucky | 21219 | 10 | 0 |
85333 | 85333 | 2020-04-24 | Todd | Minnesota | 27153 | 3 | 0 |
86211 | 86211 | 2020-04-24 | Todd | South Dakota | 46121 | 1 | 0 |
87862 | 87862 | 2020-04-25 | Todd | Kentucky | 21219 | 10 | 0 |
88143 | 88143 | 2020-04-25 | Todd | Minnesota | 27153 | 3 | 0 |
89026 | 89026 | 2020-04-25 | Todd | South Dakota | 46121 | 1 | 0 |
90678 | 90678 | 2020-04-26 | Todd | Kentucky | 21219 | 11 | 0 |
90959 | 90959 | 2020-04-26 | Todd | Minnesota | 27153 | 3 | 0 |
91843 | 91843 | 2020-04-26 | Todd | South Dakota | 46121 | 1 | 0 |
93499 | 93499 | 2020-04-27 | Todd | Kentucky | 21219 | 11 | 0 |
93780 | 93780 | 2020-04-27 | Todd | Minnesota | 27153 | 3 | 0 |
94671 | 94671 | 2020-04-27 | Todd | South Dakota | 46121 | 1 | 0 |
96334 | 96334 | 2020-04-28 | Todd | Kentucky | 21219 | 12 | 0 |
96615 | 96615 | 2020-04-28 | Todd | Minnesota | 27153 | 4 | 0 |
97511 | 97511 | 2020-04-28 | Todd | South Dakota | 46121 | 1 | 0 |
99180 | 99180 | 2020-04-29 | Todd | Kentucky | 21219 | 12 | 0 |
99461 | 99461 | 2020-04-29 | Todd | Minnesota | 27153 | 7 | 0 |
100361 | 100361 | 2020-04-29 | Todd | South Dakota | 46121 | 1 | 0 |
102032 | 102032 | 2020-04-30 | Todd | Kentucky | 21219 | 12 | 0 |
102313 | 102313 | 2020-04-30 | Todd | Minnesota | 27153 | 7 | 0 |
103214 | 103214 | 2020-04-30 | Todd | South Dakota | 46121 | 1 | 0 |
104893 | 104893 | 2020-05-01 | Todd | Kentucky | 21219 | 12 | 0 |
105174 | 105174 | 2020-05-01 | Todd | Minnesota | 27153 | 7 | 0 |
106077 | 106077 | 2020-05-01 | Todd | South Dakota | 46121 | 2 | 0 |
107758 | 107758 | 2020-05-02 | Todd | Kentucky | 21219 | 12 | 0 |
108039 | 108039 | 2020-05-02 | Todd | Minnesota | 27153 | 8 | 0 |
108944 | 108944 | 2020-05-02 | Todd | South Dakota | 46121 | 3 | 0 |
110629 | 110629 | 2020-05-03 | Todd | Kentucky | 21219 | 12 | 0 |
110910 | 110910 | 2020-05-03 | Todd | Minnesota | 27153 | 8 | 0 |
111818 | 111818 | 2020-05-03 | Todd | South Dakota | 46121 | 3 | 0 |
113506 | 113506 | 2020-05-04 | Todd | Kentucky | 21219 | 12 | 0 |
113789 | 113789 | 2020-05-04 | Todd | Minnesota | 27153 | 15 | 0 |
114700 | 114700 | 2020-05-04 | Todd | South Dakota | 46121 | 3 | 0 |
116388 | 116388 | 2020-05-05 | Todd | Kentucky | 21219 | 13 | 0 |
116671 | 116671 | 2020-05-05 | Todd | Minnesota | 27153 | 15 | 0 |
117656 | 117656 | 2020-05-05 | Todd | South Dakota | 46121 | 6 | 0 |
119349 | 119349 | 2020-05-06 | Todd | Kentucky | 21219 | 13 | 0 |
119631 | 119631 | 2020-05-06 | Todd | Minnesota | 27153 | 18 | 0 |
120619 | 120619 | 2020-05-06 | Todd | South Dakota | 46121 | 7 | 0 |
122320 | 122320 | 2020-05-07 | Todd | Kentucky | 21219 | 13 | 0 |
122605 | 122605 | 2020-05-07 | Todd | Minnesota | 27153 | 26 | 0 |
123597 | 123597 | 2020-05-07 | Todd | South Dakota | 46121 | 7 | 0 |
125302 | 125302 | 2020-05-08 | Todd | Kentucky | 21219 | 13 | 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);