ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Buchanan" and state = "Missouri" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
14935 | 14935 | 2020-03-27 | Buchanan | Missouri | 29021 | 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 |
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 |
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 |
36852 | 36852 | 2020-04-06 | Buchanan | Missouri | 29021 | 11 | 0 |
39363 | 39363 | 2020-04-07 | Buchanan | Missouri | 29021 | 14 | 0 |
41917 | 41917 | 2020-04-08 | Buchanan | Missouri | 29021 | 16 | 0 |
44494 | 44494 | 2020-04-09 | Buchanan | Missouri | 29021 | 17 | 1 |
47103 | 47103 | 2020-04-10 | Buchanan | Missouri | 29021 | 20 | 1 |
49750 | 49750 | 2020-04-11 | Buchanan | Missouri | 29021 | 20 | 1 |
52423 | 52423 | 2020-04-12 | Buchanan | Missouri | 29021 | 20 | 1 |
55105 | 55105 | 2020-04-13 | Buchanan | Missouri | 29021 | 22 | 1 |
57803 | 57803 | 2020-04-14 | Buchanan | Missouri | 29021 | 22 | 1 |
60514 | 60514 | 2020-04-15 | Buchanan | Missouri | 29021 | 26 | 1 |
63236 | 63236 | 2020-04-16 | Buchanan | Missouri | 29021 | 26 | 1 |
65976 | 65976 | 2020-04-17 | Buchanan | Missouri | 29021 | 28 | 1 |
68728 | 68728 | 2020-04-18 | Buchanan | Missouri | 29021 | 30 | 1 |
71495 | 71495 | 2020-04-19 | Buchanan | Missouri | 29021 | 31 | 1 |
74268 | 74268 | 2020-04-20 | Buchanan | Missouri | 29021 | 32 | 1 |
77049 | 77049 | 2020-04-21 | Buchanan | Missouri | 29021 | 33 | 1 |
79834 | 79834 | 2020-04-22 | Buchanan | Missouri | 29021 | 35 | 1 |
82630 | 82630 | 2020-04-23 | Buchanan | Missouri | 29021 | 43 | 1 |
85434 | 85434 | 2020-04-24 | Buchanan | Missouri | 29021 | 48 | 1 |
88244 | 88244 | 2020-04-25 | Buchanan | Missouri | 29021 | 48 | 1 |
91060 | 91060 | 2020-04-26 | Buchanan | Missouri | 29021 | 57 | 1 |
93881 | 93881 | 2020-04-27 | Buchanan | Missouri | 29021 | 63 | 1 |
96717 | 96717 | 2020-04-28 | Buchanan | Missouri | 29021 | 68 | 1 |
99563 | 99563 | 2020-04-29 | Buchanan | Missouri | 29021 | 76 | 1 |
102415 | 102415 | 2020-04-30 | Buchanan | Missouri | 29021 | 87 | 1 |
105276 | 105276 | 2020-05-01 | Buchanan | Missouri | 29021 | 141 | 1 |
108141 | 108141 | 2020-05-02 | Buchanan | Missouri | 29021 | 185 | 1 |
111012 | 111012 | 2020-05-03 | Buchanan | Missouri | 29021 | 229 | 1 |
113891 | 113891 | 2020-05-04 | Buchanan | Missouri | 29021 | 341 | 2 |
116773 | 116773 | 2020-05-05 | Buchanan | Missouri | 29021 | 369 | 2 |
119733 | 119733 | 2020-05-06 | Buchanan | Missouri | 29021 | 386 | 2 |
122707 | 122707 | 2020-05-07 | Buchanan | Missouri | 29021 | 404 | 3 |
125689 | 125689 | 2020-05-08 | Buchanan | Missouri | 29021 | 409 | 3 |
128676 | 128676 | 2020-05-09 | Buchanan | Missouri | 29021 | 432 | 2 |
131666 | 131666 | 2020-05-10 | Buchanan | Missouri | 29021 | 442 | 2 |
134657 | 134657 | 2020-05-11 | Buchanan | Missouri | 29021 | 447 | 2 |
137647 | 137647 | 2020-05-12 | Buchanan | Missouri | 29021 | 464 | 2 |
140641 | 140641 | 2020-05-13 | Buchanan | Missouri | 29021 | 476 | 2 |
143636 | 143636 | 2020-05-14 | Buchanan | Missouri | 29021 | 496 | 2 |
146636 | 146636 | 2020-05-15 | Buchanan | Missouri | 29021 | 502 | 2 |
152652 | 152652 | 2020-05-17 | Buchanan | Missouri | 29021 | 505 | 2 |
149641 | 149641 | 2020-05-16 | Buchanan | Missouri | 29021 | 506 | 2 |
155666 | 155666 | 2020-05-18 | Buchanan | Missouri | 29021 | 520 | 2 |
158684 | 158684 | 2020-05-19 | Buchanan | Missouri | 29021 | 543 | 2 |
161710 | 161710 | 2020-05-20 | Buchanan | Missouri | 29021 | 562 | 2 |
164739 | 164739 | 2020-05-21 | Buchanan | Missouri | 29021 | 587 | 2 |
167775 | 167775 | 2020-05-22 | Buchanan | Missouri | 29021 | 599 | 2 |
170813 | 170813 | 2020-05-23 | Buchanan | Missouri | 29021 | 609 | 2 |
173855 | 173855 | 2020-05-24 | Buchanan | Missouri | 29021 | 617 | 2 |
176898 | 176898 | 2020-05-25 | Buchanan | Missouri | 29021 | 628 | 2 |
179942 | 179942 | 2020-05-26 | Buchanan | Missouri | 29021 | 640 | 2 |
182988 | 182988 | 2020-05-27 | Buchanan | Missouri | 29021 | 662 | 2 |
186044 | 186044 | 2020-05-28 | Buchanan | Missouri | 29021 | 677 | 2 |
189102 | 189102 | 2020-05-29 | Buchanan | Missouri | 29021 | 687 | 2 |
192166 | 192166 | 2020-05-30 | Buchanan | Missouri | 29021 | 690 | 2 |
195234 | 195234 | 2020-05-31 | Buchanan | Missouri | 29021 | 692 | 2 |
198305 | 198305 | 2020-06-01 | Buchanan | Missouri | 29021 | 709 | 2 |
201378 | 201378 | 2020-06-02 | Buchanan | Missouri | 29021 | 719 | 2 |
204455 | 204455 | 2020-06-03 | Buchanan | Missouri | 29021 | 725 | 2 |
207536 | 207536 | 2020-06-04 | Buchanan | Missouri | 29021 | 736 | 2 |
210617 | 210617 | 2020-06-05 | Buchanan | Missouri | 29021 | 741 | 2 |
213701 | 213701 | 2020-06-06 | Buchanan | Missouri | 29021 | 744 | 2 |
216789 | 216789 | 2020-06-07 | Buchanan | Missouri | 29021 | 748 | 2 |
219881 | 219881 | 2020-06-08 | Buchanan | Missouri | 29021 | 754 | 2 |
222976 | 222976 | 2020-06-09 | Buchanan | Missouri | 29021 | 755 | 2 |
226074 | 226074 | 2020-06-10 | Buchanan | Missouri | 29021 | 762 | 2 |
229177 | 229177 | 2020-06-11 | Buchanan | Missouri | 29021 | 768 | 2 |
232281 | 232281 | 2020-06-12 | Buchanan | Missouri | 29021 | 772 | 2 |
235387 | 235387 | 2020-06-13 | Buchanan | Missouri | 29021 | 784 | 2 |
238494 | 238494 | 2020-06-14 | Buchanan | Missouri | 29021 | 784 | 2 |
241603 | 241603 | 2020-06-15 | Buchanan | Missouri | 29021 | 787 | 2 |
244714 | 244714 | 2020-06-16 | Buchanan | Missouri | 29021 | 791 | 2 |
247827 | 247827 | 2020-06-17 | Buchanan | Missouri | 29021 | 793 | 3 |
250940 | 250940 | 2020-06-18 | Buchanan | Missouri | 29021 | 800 | 3 |
254055 | 254055 | 2020-06-19 | Buchanan | Missouri | 29021 | 802 | 3 |
257175 | 257175 | 2020-06-20 | Buchanan | Missouri | 29021 | 805 | 3 |
260301 | 260301 | 2020-06-21 | Buchanan | Missouri | 29021 | 805 | 3 |
263429 | 263429 | 2020-06-22 | Buchanan | Missouri | 29021 | 809 | 3 |
266555 | 266555 | 2020-06-23 | Buchanan | Missouri | 29021 | 812 | 3 |
269688 | 269688 | 2020-06-24 | Buchanan | Missouri | 29021 | 819 | 3 |
272826 | 272826 | 2020-06-25 | Buchanan | Missouri | 29021 | 827 | 3 |
275969 | 275969 | 2020-06-26 | Buchanan | Missouri | 29021 | 834 | 3 |
279117 | 279117 | 2020-06-27 | Buchanan | Missouri | 29021 | 838 | 3 |
282265 | 282265 | 2020-06-28 | Buchanan | Missouri | 29021 | 855 | 3 |
285410 | 285410 | 2020-06-29 | Buchanan | Missouri | 29021 | 862 | 3 |
288560 | 288560 | 2020-06-30 | Buchanan | Missouri | 29021 | 869 | 3 |
291711 | 291711 | 2020-07-01 | Buchanan | Missouri | 29021 | 873 | 3 |
294865 | 294865 | 2020-07-02 | Buchanan | Missouri | 29021 | 880 | 3 |
298023 | 298023 | 2020-07-03 | Buchanan | Missouri | 29021 | 883 | 3 |
301186 | 301186 | 2020-07-04 | Buchanan | Missouri | 29021 | 883 | 3 |
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);