ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Butler" and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25008 | 25008 | 2020-04-01 | Butler | Missouri | 29023 | 1 | 0 |
27263 | 27263 | 2020-04-02 | Butler | Missouri | 29023 | 1 | 0 |
29582 | 29582 | 2020-04-03 | Butler | Missouri | 29023 | 1 | 0 |
31962 | 31962 | 2020-04-04 | Butler | Missouri | 29023 | 2 | 0 |
34390 | 34390 | 2020-04-05 | Butler | Missouri | 29023 | 2 | 0 |
36853 | 36853 | 2020-04-06 | Butler | Missouri | 29023 | 2 | 0 |
39364 | 39364 | 2020-04-07 | Butler | Missouri | 29023 | 5 | 0 |
41918 | 41918 | 2020-04-08 | Butler | Missouri | 29023 | 6 | 0 |
44495 | 44495 | 2020-04-09 | Butler | Missouri | 29023 | 6 | 0 |
47104 | 47104 | 2020-04-10 | Butler | Missouri | 29023 | 10 | 0 |
49751 | 49751 | 2020-04-11 | Butler | Missouri | 29023 | 13 | 0 |
52424 | 52424 | 2020-04-12 | Butler | Missouri | 29023 | 13 | 0 |
55106 | 55106 | 2020-04-13 | Butler | Missouri | 29023 | 16 | 0 |
57804 | 57804 | 2020-04-14 | Butler | Missouri | 29023 | 16 | 0 |
60515 | 60515 | 2020-04-15 | Butler | Missouri | 29023 | 17 | 0 |
63237 | 63237 | 2020-04-16 | Butler | Missouri | 29023 | 21 | 0 |
65977 | 65977 | 2020-04-17 | Butler | Missouri | 29023 | 22 | 0 |
68729 | 68729 | 2020-04-18 | Butler | Missouri | 29023 | 23 | 0 |
71496 | 71496 | 2020-04-19 | Butler | Missouri | 29023 | 23 | 0 |
74269 | 74269 | 2020-04-20 | Butler | Missouri | 29023 | 24 | 0 |
77050 | 77050 | 2020-04-21 | Butler | Missouri | 29023 | 24 | 0 |
79835 | 79835 | 2020-04-22 | Butler | Missouri | 29023 | 24 | 0 |
82631 | 82631 | 2020-04-23 | Butler | Missouri | 29023 | 26 | 0 |
85435 | 85435 | 2020-04-24 | Butler | Missouri | 29023 | 25 | 0 |
88245 | 88245 | 2020-04-25 | Butler | Missouri | 29023 | 25 | 0 |
91061 | 91061 | 2020-04-26 | Butler | Missouri | 29023 | 26 | 0 |
93882 | 93882 | 2020-04-27 | Butler | Missouri | 29023 | 26 | 0 |
96718 | 96718 | 2020-04-28 | Butler | Missouri | 29023 | 26 | 0 |
99564 | 99564 | 2020-04-29 | Butler | Missouri | 29023 | 25 | 0 |
102416 | 102416 | 2020-04-30 | Butler | Missouri | 29023 | 25 | 0 |
105277 | 105277 | 2020-05-01 | Butler | Missouri | 29023 | 25 | 0 |
108142 | 108142 | 2020-05-02 | Butler | Missouri | 29023 | 26 | 0 |
111013 | 111013 | 2020-05-03 | Butler | Missouri | 29023 | 26 | 0 |
113892 | 113892 | 2020-05-04 | Butler | Missouri | 29023 | 26 | 0 |
116774 | 116774 | 2020-05-05 | Butler | Missouri | 29023 | 26 | 0 |
119734 | 119734 | 2020-05-06 | Butler | Missouri | 29023 | 26 | 0 |
122708 | 122708 | 2020-05-07 | Butler | Missouri | 29023 | 26 | 0 |
125690 | 125690 | 2020-05-08 | Butler | Missouri | 29023 | 26 | 0 |
128677 | 128677 | 2020-05-09 | Butler | Missouri | 29023 | 26 | 0 |
131667 | 131667 | 2020-05-10 | Butler | Missouri | 29023 | 27 | 0 |
134658 | 134658 | 2020-05-11 | Butler | Missouri | 29023 | 27 | 0 |
137648 | 137648 | 2020-05-12 | Butler | Missouri | 29023 | 27 | 0 |
140642 | 140642 | 2020-05-13 | Butler | Missouri | 29023 | 27 | 0 |
143637 | 143637 | 2020-05-14 | Butler | Missouri | 29023 | 27 | 0 |
146637 | 146637 | 2020-05-15 | Butler | Missouri | 29023 | 27 | 0 |
149642 | 149642 | 2020-05-16 | Butler | Missouri | 29023 | 28 | 0 |
152653 | 152653 | 2020-05-17 | Butler | Missouri | 29023 | 28 | 0 |
155667 | 155667 | 2020-05-18 | Butler | Missouri | 29023 | 30 | 0 |
158685 | 158685 | 2020-05-19 | Butler | Missouri | 29023 | 32 | 0 |
161711 | 161711 | 2020-05-20 | Butler | Missouri | 29023 | 34 | 0 |
164740 | 164740 | 2020-05-21 | Butler | Missouri | 29023 | 28 | 0 |
167776 | 167776 | 2020-05-22 | Butler | Missouri | 29023 | 28 | 0 |
170814 | 170814 | 2020-05-23 | Butler | Missouri | 29023 | 28 | 0 |
173856 | 173856 | 2020-05-24 | Butler | Missouri | 29023 | 28 | 0 |
176899 | 176899 | 2020-05-25 | Butler | Missouri | 29023 | 28 | 0 |
179943 | 179943 | 2020-05-26 | Butler | Missouri | 29023 | 28 | 0 |
182989 | 182989 | 2020-05-27 | Butler | Missouri | 29023 | 28 | 0 |
186045 | 186045 | 2020-05-28 | Butler | Missouri | 29023 | 29 | 0 |
189103 | 189103 | 2020-05-29 | Butler | Missouri | 29023 | 32 | 0 |
192167 | 192167 | 2020-05-30 | Butler | Missouri | 29023 | 32 | 0 |
195235 | 195235 | 2020-05-31 | Butler | Missouri | 29023 | 33 | 0 |
198306 | 198306 | 2020-06-01 | Butler | Missouri | 29023 | 34 | 0 |
201379 | 201379 | 2020-06-02 | Butler | Missouri | 29023 | 35 | 0 |
204456 | 204456 | 2020-06-03 | Butler | Missouri | 29023 | 35 | 0 |
207537 | 207537 | 2020-06-04 | Butler | Missouri | 29023 | 35 | 0 |
210618 | 210618 | 2020-06-05 | Butler | Missouri | 29023 | 37 | 0 |
213702 | 213702 | 2020-06-06 | Butler | Missouri | 29023 | 37 | 0 |
216790 | 216790 | 2020-06-07 | Butler | Missouri | 29023 | 37 | 0 |
219882 | 219882 | 2020-06-08 | Butler | Missouri | 29023 | 39 | 0 |
222977 | 222977 | 2020-06-09 | Butler | Missouri | 29023 | 41 | 0 |
226075 | 226075 | 2020-06-10 | Butler | Missouri | 29023 | 39 | 0 |
229178 | 229178 | 2020-06-11 | Butler | Missouri | 29023 | 39 | 0 |
232282 | 232282 | 2020-06-12 | Butler | Missouri | 29023 | 40 | 0 |
235388 | 235388 | 2020-06-13 | Butler | Missouri | 29023 | 41 | 0 |
238495 | 238495 | 2020-06-14 | Butler | Missouri | 29023 | 41 | 0 |
241604 | 241604 | 2020-06-15 | Butler | Missouri | 29023 | 46 | 0 |
244715 | 244715 | 2020-06-16 | Butler | Missouri | 29023 | 48 | 0 |
247828 | 247828 | 2020-06-17 | Butler | Missouri | 29023 | 53 | 0 |
250941 | 250941 | 2020-06-18 | Butler | Missouri | 29023 | 58 | 0 |
254056 | 254056 | 2020-06-19 | Butler | Missouri | 29023 | 59 | 0 |
257176 | 257176 | 2020-06-20 | Butler | Missouri | 29023 | 62 | 0 |
260302 | 260302 | 2020-06-21 | Butler | Missouri | 29023 | 62 | 0 |
263430 | 263430 | 2020-06-22 | Butler | Missouri | 29023 | 62 | 0 |
266556 | 266556 | 2020-06-23 | Butler | Missouri | 29023 | 67 | 0 |
269689 | 269689 | 2020-06-24 | Butler | Missouri | 29023 | 68 | 0 |
272827 | 272827 | 2020-06-25 | Butler | Missouri | 29023 | 71 | 0 |
275970 | 275970 | 2020-06-26 | Butler | Missouri | 29023 | 75 | 0 |
279118 | 279118 | 2020-06-27 | Butler | Missouri | 29023 | 75 | 0 |
282266 | 282266 | 2020-06-28 | Butler | Missouri | 29023 | 75 | 0 |
285411 | 285411 | 2020-06-29 | Butler | Missouri | 29023 | 99 | 0 |
288561 | 288561 | 2020-06-30 | Butler | Missouri | 29023 | 101 | 0 |
291712 | 291712 | 2020-07-01 | Butler | Missouri | 29023 | 106 | 0 |
294866 | 294866 | 2020-07-02 | Butler | Missouri | 29023 | 108 | 0 |
298024 | 298024 | 2020-07-03 | Butler | Missouri | 29023 | 108 | 0 |
301187 | 301187 | 2020-07-04 | Butler | Missouri | 29023 | 108 | 0 |
304351 | 304351 | 2020-07-05 | Butler | Missouri | 29023 | 108 | 0 |
307518 | 307518 | 2020-07-06 | Butler | Missouri | 29023 | 108 | 0 |
310686 | 310686 | 2020-07-07 | Butler | Missouri | 29023 | 111 | 0 |
313856 | 313856 | 2020-07-08 | Butler | Missouri | 29023 | 111 | 0 |
317030 | 317030 | 2020-07-09 | Butler | Missouri | 29023 | 116 | 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);