ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,326 rows where county = "Buchanan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
county 1
- Buchanan · 2,326 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
9891 | 9891 | 2020-03-24 | Buchanan | Iowa | 19019 | 1 | 0 |
11288 | 11288 | 2020-03-25 | Buchanan | Iowa | 19019 | 1 | 0 |
12850 | 12850 | 2020-03-26 | Buchanan | Iowa | 19019 | 1 | 0 |
14537 | 14537 | 2020-03-27 | Buchanan | Iowa | 19019 | 1 | 0 |
40366 | 40366 | 2020-04-07 | Buchanan | Virginia | 51027 | 1 | 0 |
42935 | 42935 | 2020-04-08 | Buchanan | Virginia | 51027 | 1 | 0 |
45529 | 45529 | 2020-04-09 | Buchanan | Virginia | 51027 | 1 | 0 |
48153 | 48153 | 2020-04-10 | Buchanan | Virginia | 51027 | 1 | 0 |
14935 | 14935 | 2020-03-27 | Buchanan | Missouri | 29021 | 2 | 0 |
16341 | 16341 | 2020-03-28 | Buchanan | Iowa | 19019 | 2 | 0 |
18246 | 18246 | 2020-03-29 | Buchanan | Iowa | 19019 | 2 | 0 |
20253 | 20253 | 2020-03-30 | Buchanan | Iowa | 19019 | 2 | 0 |
22348 | 22348 | 2020-03-31 | Buchanan | Iowa | 19019 | 2 | 0 |
24520 | 24520 | 2020-04-01 | Buchanan | Iowa | 19019 | 2 | 0 |
50811 | 50811 | 2020-04-11 | Buchanan | Virginia | 51027 | 2 | 0 |
53486 | 53486 | 2020-04-12 | Buchanan | Virginia | 51027 | 2 | 0 |
56175 | 56175 | 2020-04-13 | Buchanan | Virginia | 51027 | 2 | 0 |
16759 | 16759 | 2020-03-28 | Buchanan | Missouri | 29021 | 3 | 0 |
18681 | 18681 | 2020-03-29 | Buchanan | Missouri | 29021 | 3 | 0 |
20705 | 20705 | 2020-03-30 | Buchanan | Missouri | 29021 | 3 | 0 |
26761 | 26761 | 2020-04-02 | Buchanan | Iowa | 19019 | 3 | 0 |
29072 | 29072 | 2020-04-03 | Buchanan | Iowa | 19019 | 3 | 0 |
31440 | 31440 | 2020-04-04 | Buchanan | Iowa | 19019 | 3 | 0 |
22823 | 22823 | 2020-03-31 | Buchanan | Missouri | 29021 | 5 | 0 |
25007 | 25007 | 2020-04-01 | Buchanan | Missouri | 29021 | 5 | 0 |
27262 | 27262 | 2020-04-02 | Buchanan | Missouri | 29021 | 5 | 0 |
33851 | 33851 | 2020-04-05 | Buchanan | Iowa | 19019 | 5 | 0 |
36304 | 36304 | 2020-04-06 | Buchanan | Iowa | 19019 | 5 | 0 |
38802 | 38802 | 2020-04-07 | Buchanan | Iowa | 19019 | 5 | 0 |
41348 | 41348 | 2020-04-08 | Buchanan | Iowa | 19019 | 5 | 0 |
43924 | 43924 | 2020-04-09 | Buchanan | Iowa | 19019 | 6 | 0 |
46529 | 46529 | 2020-04-10 | Buchanan | Iowa | 19019 | 6 | 0 |
49163 | 49163 | 2020-04-11 | Buchanan | Iowa | 19019 | 6 | 0 |
51827 | 51827 | 2020-04-12 | Buchanan | Iowa | 19019 | 7 | 0 |
29581 | 29581 | 2020-04-03 | Buchanan | Missouri | 29021 | 8 | 0 |
31961 | 31961 | 2020-04-04 | Buchanan | Missouri | 29021 | 8 | 0 |
34389 | 34389 | 2020-04-05 | Buchanan | Missouri | 29021 | 8 | 0 |
54508 | 54508 | 2020-04-13 | Buchanan | Iowa | 19019 | 8 | 0 |
57201 | 57201 | 2020-04-14 | Buchanan | Iowa | 19019 | 8 | 0 |
59909 | 59909 | 2020-04-15 | Buchanan | Iowa | 19019 | 8 | 0 |
62630 | 62630 | 2020-04-16 | Buchanan | Iowa | 19019 | 8 | 0 |
65364 | 65364 | 2020-04-17 | Buchanan | Iowa | 19019 | 8 | 0 |
68113 | 68113 | 2020-04-18 | Buchanan | Iowa | 19019 | 8 | 0 |
70875 | 70875 | 2020-04-19 | Buchanan | Iowa | 19019 | 8 | 0 |
36852 | 36852 | 2020-04-06 | Buchanan | Missouri | 29021 | 11 | 0 |
73646 | 73646 | 2020-04-20 | Buchanan | Iowa | 19019 | 11 | 0 |
76423 | 76423 | 2020-04-21 | Buchanan | Iowa | 19019 | 11 | 0 |
79207 | 79207 | 2020-04-22 | Buchanan | Iowa | 19019 | 11 | 0 |
82000 | 82000 | 2020-04-23 | Buchanan | Iowa | 19019 | 11 | 0 |
58881 | 58881 | 2020-04-14 | Buchanan | Virginia | 51027 | 12 | 0 |
61600 | 61600 | 2020-04-15 | Buchanan | Virginia | 51027 | 12 | 0 |
64332 | 64332 | 2020-04-16 | Buchanan | Virginia | 51027 | 12 | 0 |
67080 | 67080 | 2020-04-17 | Buchanan | Virginia | 51027 | 12 | 0 |
69842 | 69842 | 2020-04-18 | Buchanan | Virginia | 51027 | 12 | 0 |
72612 | 72612 | 2020-04-19 | Buchanan | Virginia | 51027 | 12 | 0 |
75388 | 75388 | 2020-04-20 | Buchanan | Virginia | 51027 | 12 | 0 |
78170 | 78170 | 2020-04-21 | Buchanan | Virginia | 51027 | 12 | 0 |
80962 | 80962 | 2020-04-22 | Buchanan | Virginia | 51027 | 12 | 0 |
83763 | 83763 | 2020-04-23 | Buchanan | Virginia | 51027 | 12 | 0 |
86570 | 86570 | 2020-04-24 | Buchanan | Virginia | 51027 | 12 | 0 |
87610 | 87610 | 2020-04-25 | Buchanan | Iowa | 19019 | 12 | 0 |
90426 | 90426 | 2020-04-26 | Buchanan | Iowa | 19019 | 12 | 0 |
93245 | 93245 | 2020-04-27 | Buchanan | Iowa | 19019 | 12 | 0 |
84800 | 84800 | 2020-04-24 | Buchanan | Iowa | 19019 | 13 | 0 |
89385 | 89385 | 2020-04-25 | Buchanan | Virginia | 51027 | 13 | 0 |
92202 | 92202 | 2020-04-26 | Buchanan | Virginia | 51027 | 13 | 0 |
39363 | 39363 | 2020-04-07 | Buchanan | Missouri | 29021 | 14 | 0 |
95031 | 95031 | 2020-04-27 | Buchanan | Virginia | 51027 | 14 | 0 |
96077 | 96077 | 2020-04-28 | Buchanan | Iowa | 19019 | 14 | 0 |
41917 | 41917 | 2020-04-08 | Buchanan | Missouri | 29021 | 16 | 0 |
97873 | 97873 | 2020-04-28 | Buchanan | Virginia | 51027 | 16 | 0 |
98921 | 98921 | 2020-04-29 | Buchanan | Iowa | 19019 | 16 | 0 |
100723 | 100723 | 2020-04-29 | Buchanan | Virginia | 51027 | 16 | 0 |
103578 | 103578 | 2020-04-30 | Buchanan | Virginia | 51027 | 16 | 0 |
106442 | 106442 | 2020-05-01 | Buchanan | Virginia | 51027 | 16 | 0 |
109311 | 109311 | 2020-05-02 | Buchanan | Virginia | 51027 | 16 | 0 |
112185 | 112185 | 2020-05-03 | Buchanan | Virginia | 51027 | 16 | 0 |
115068 | 115068 | 2020-05-04 | Buchanan | Virginia | 51027 | 16 | 0 |
118027 | 118027 | 2020-05-05 | Buchanan | Virginia | 51027 | 16 | 0 |
120991 | 120991 | 2020-05-06 | Buchanan | Virginia | 51027 | 16 | 0 |
123972 | 123972 | 2020-05-07 | Buchanan | Virginia | 51027 | 16 | 0 |
126957 | 126957 | 2020-05-08 | Buchanan | Virginia | 51027 | 16 | 0 |
129946 | 129946 | 2020-05-09 | Buchanan | Virginia | 51027 | 16 | 0 |
132936 | 132936 | 2020-05-10 | Buchanan | Virginia | 51027 | 16 | 0 |
135926 | 135926 | 2020-05-11 | Buchanan | Virginia | 51027 | 16 | 0 |
138917 | 138917 | 2020-05-12 | Buchanan | Virginia | 51027 | 16 | 0 |
141913 | 141913 | 2020-05-13 | Buchanan | Virginia | 51027 | 16 | 0 |
144910 | 144910 | 2020-05-14 | Buchanan | Virginia | 51027 | 16 | 0 |
147913 | 147913 | 2020-05-15 | Buchanan | Virginia | 51027 | 16 | 0 |
150922 | 150922 | 2020-05-16 | Buchanan | Virginia | 51027 | 16 | 0 |
153933 | 153933 | 2020-05-17 | Buchanan | Virginia | 51027 | 16 | 0 |
156950 | 156950 | 2020-05-18 | Buchanan | Virginia | 51027 | 16 | 0 |
44494 | 44494 | 2020-04-09 | Buchanan | Missouri | 29021 | 17 | 1 |
101772 | 101772 | 2020-04-30 | Buchanan | Iowa | 19019 | 17 | 0 |
104628 | 104628 | 2020-05-01 | Buchanan | Iowa | 19019 | 18 | 0 |
159974 | 159974 | 2020-05-19 | Buchanan | Virginia | 51027 | 18 | 0 |
163002 | 163002 | 2020-05-20 | Buchanan | Virginia | 51027 | 18 | 0 |
166031 | 166031 | 2020-05-21 | Buchanan | Virginia | 51027 | 18 | 0 |
169067 | 169067 | 2020-05-22 | Buchanan | Virginia | 51027 | 18 | 0 |
172108 | 172108 | 2020-05-23 | Buchanan | Virginia | 51027 | 18 | 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);