ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29043 and state = "Missouri" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5636 | 5636 | 2020-03-20 | Christian | Missouri | 29043 | 2 | 0 |
6624 | 6624 | 2020-03-21 | Christian | Missouri | 29043 | 2 | 0 |
7713 | 7713 | 2020-03-22 | Christian | Missouri | 29043 | 2 | 0 |
8899 | 8899 | 2020-03-23 | Christian | Missouri | 29043 | 2 | 0 |
10198 | 10198 | 2020-03-24 | Christian | Missouri | 29043 | 2 | 0 |
11619 | 11619 | 2020-03-25 | Christian | Missouri | 29043 | 2 | 0 |
13217 | 13217 | 2020-03-26 | Christian | Missouri | 29043 | 2 | 0 |
14942 | 14942 | 2020-03-27 | Christian | Missouri | 29043 | 3 | 0 |
16766 | 16766 | 2020-03-28 | Christian | Missouri | 29043 | 6 | 0 |
18688 | 18688 | 2020-03-29 | Christian | Missouri | 29043 | 7 | 0 |
22831 | 22831 | 2020-03-31 | Christian | Missouri | 29043 | 11 | 0 |
25017 | 25017 | 2020-04-01 | Christian | Missouri | 29043 | 11 | 0 |
20713 | 20713 | 2020-03-30 | Christian | Missouri | 29043 | 12 | 0 |
27272 | 27272 | 2020-04-02 | Christian | Missouri | 29043 | 12 | 0 |
29591 | 29591 | 2020-04-03 | Christian | Missouri | 29043 | 13 | 0 |
31971 | 31971 | 2020-04-04 | Christian | Missouri | 29043 | 16 | 0 |
34399 | 34399 | 2020-04-05 | Christian | Missouri | 29043 | 16 | 0 |
36862 | 36862 | 2020-04-06 | Christian | Missouri | 29043 | 17 | 0 |
39373 | 39373 | 2020-04-07 | Christian | Missouri | 29043 | 17 | 0 |
41927 | 41927 | 2020-04-08 | Christian | Missouri | 29043 | 17 | 0 |
44504 | 44504 | 2020-04-09 | Christian | Missouri | 29043 | 17 | 0 |
47113 | 47113 | 2020-04-10 | Christian | Missouri | 29043 | 17 | 0 |
49760 | 49760 | 2020-04-11 | Christian | Missouri | 29043 | 17 | 0 |
52433 | 52433 | 2020-04-12 | Christian | Missouri | 29043 | 17 | 0 |
55115 | 55115 | 2020-04-13 | Christian | Missouri | 29043 | 17 | 0 |
63246 | 63246 | 2020-04-16 | Christian | Missouri | 29043 | 17 | 0 |
65986 | 65986 | 2020-04-17 | Christian | Missouri | 29043 | 17 | 0 |
68738 | 68738 | 2020-04-18 | Christian | Missouri | 29043 | 17 | 0 |
71505 | 71505 | 2020-04-19 | Christian | Missouri | 29043 | 17 | 0 |
60524 | 60524 | 2020-04-15 | Christian | Missouri | 29043 | 18 | 0 |
74278 | 74278 | 2020-04-20 | Christian | Missouri | 29043 | 18 | 0 |
77059 | 77059 | 2020-04-21 | Christian | Missouri | 29043 | 18 | 0 |
79845 | 79845 | 2020-04-22 | Christian | Missouri | 29043 | 18 | 0 |
82641 | 82641 | 2020-04-23 | Christian | Missouri | 29043 | 18 | 0 |
85445 | 85445 | 2020-04-24 | Christian | Missouri | 29043 | 18 | 0 |
88255 | 88255 | 2020-04-25 | Christian | Missouri | 29043 | 18 | 0 |
91071 | 91071 | 2020-04-26 | Christian | Missouri | 29043 | 18 | 0 |
57813 | 57813 | 2020-04-14 | Christian | Missouri | 29043 | 19 | 0 |
93892 | 93892 | 2020-04-27 | Christian | Missouri | 29043 | 19 | 0 |
96728 | 96728 | 2020-04-28 | Christian | Missouri | 29043 | 19 | 0 |
99574 | 99574 | 2020-04-29 | Christian | Missouri | 29043 | 19 | 0 |
102426 | 102426 | 2020-04-30 | Christian | Missouri | 29043 | 19 | 0 |
105287 | 105287 | 2020-05-01 | Christian | Missouri | 29043 | 19 | 0 |
108152 | 108152 | 2020-05-02 | Christian | Missouri | 29043 | 19 | 0 |
111023 | 111023 | 2020-05-03 | Christian | Missouri | 29043 | 19 | 0 |
113902 | 113902 | 2020-05-04 | Christian | Missouri | 29043 | 19 | 0 |
116784 | 116784 | 2020-05-05 | Christian | Missouri | 29043 | 19 | 0 |
119744 | 119744 | 2020-05-06 | Christian | Missouri | 29043 | 19 | 0 |
122718 | 122718 | 2020-05-07 | Christian | Missouri | 29043 | 20 | 0 |
125700 | 125700 | 2020-05-08 | Christian | Missouri | 29043 | 20 | 0 |
128687 | 128687 | 2020-05-09 | Christian | Missouri | 29043 | 20 | 0 |
131677 | 131677 | 2020-05-10 | Christian | Missouri | 29043 | 20 | 0 |
134668 | 134668 | 2020-05-11 | Christian | Missouri | 29043 | 20 | 0 |
137658 | 137658 | 2020-05-12 | Christian | Missouri | 29043 | 21 | 0 |
140652 | 140652 | 2020-05-13 | Christian | Missouri | 29043 | 21 | 0 |
143647 | 143647 | 2020-05-14 | Christian | Missouri | 29043 | 21 | 0 |
146647 | 146647 | 2020-05-15 | Christian | Missouri | 29043 | 21 | 0 |
149652 | 149652 | 2020-05-16 | Christian | Missouri | 29043 | 21 | 0 |
152663 | 152663 | 2020-05-17 | Christian | Missouri | 29043 | 21 | 0 |
155677 | 155677 | 2020-05-18 | Christian | Missouri | 29043 | 21 | 0 |
158695 | 158695 | 2020-05-19 | Christian | Missouri | 29043 | 21 | 0 |
161721 | 161721 | 2020-05-20 | Christian | Missouri | 29043 | 21 | 0 |
164750 | 164750 | 2020-05-21 | Christian | Missouri | 29043 | 21 | 0 |
167786 | 167786 | 2020-05-22 | Christian | Missouri | 29043 | 21 | 0 |
170824 | 170824 | 2020-05-23 | Christian | Missouri | 29043 | 22 | 0 |
173866 | 173866 | 2020-05-24 | Christian | Missouri | 29043 | 22 | 0 |
176909 | 176909 | 2020-05-25 | Christian | Missouri | 29043 | 22 | 0 |
179953 | 179953 | 2020-05-26 | Christian | Missouri | 29043 | 22 | 0 |
182999 | 182999 | 2020-05-27 | Christian | Missouri | 29043 | 22 | 0 |
186055 | 186055 | 2020-05-28 | Christian | Missouri | 29043 | 22 | 0 |
189113 | 189113 | 2020-05-29 | Christian | Missouri | 29043 | 22 | 0 |
192177 | 192177 | 2020-05-30 | Christian | Missouri | 29043 | 23 | 0 |
195245 | 195245 | 2020-05-31 | Christian | Missouri | 29043 | 23 | 0 |
198316 | 198316 | 2020-06-01 | Christian | Missouri | 29043 | 24 | 0 |
201389 | 201389 | 2020-06-02 | Christian | Missouri | 29043 | 24 | 0 |
204466 | 204466 | 2020-06-03 | Christian | Missouri | 29043 | 27 | 0 |
213712 | 213712 | 2020-06-06 | Christian | Missouri | 29043 | 28 | 0 |
216800 | 216800 | 2020-06-07 | Christian | Missouri | 29043 | 28 | 0 |
219892 | 219892 | 2020-06-08 | Christian | Missouri | 29043 | 28 | 0 |
222987 | 222987 | 2020-06-09 | Christian | Missouri | 29043 | 28 | 0 |
226085 | 226085 | 2020-06-10 | Christian | Missouri | 29043 | 28 | 0 |
229188 | 229188 | 2020-06-11 | Christian | Missouri | 29043 | 28 | 0 |
207547 | 207547 | 2020-06-04 | Christian | Missouri | 29043 | 29 | 0 |
210628 | 210628 | 2020-06-05 | Christian | Missouri | 29043 | 29 | 0 |
232292 | 232292 | 2020-06-12 | Christian | Missouri | 29043 | 29 | 0 |
235398 | 235398 | 2020-06-13 | Christian | Missouri | 29043 | 29 | 0 |
238505 | 238505 | 2020-06-14 | Christian | Missouri | 29043 | 29 | 0 |
241614 | 241614 | 2020-06-15 | Christian | Missouri | 29043 | 30 | 0 |
244725 | 244725 | 2020-06-16 | Christian | Missouri | 29043 | 30 | 0 |
247838 | 247838 | 2020-06-17 | Christian | Missouri | 29043 | 30 | 0 |
250951 | 250951 | 2020-06-18 | Christian | Missouri | 29043 | 31 | 0 |
254066 | 254066 | 2020-06-19 | Christian | Missouri | 29043 | 31 | 0 |
257186 | 257186 | 2020-06-20 | Christian | Missouri | 29043 | 32 | 0 |
260312 | 260312 | 2020-06-21 | Christian | Missouri | 29043 | 32 | 0 |
263440 | 263440 | 2020-06-22 | Christian | Missouri | 29043 | 32 | 0 |
266566 | 266566 | 2020-06-23 | Christian | Missouri | 29043 | 35 | 0 |
269699 | 269699 | 2020-06-24 | Christian | Missouri | 29043 | 37 | 0 |
272837 | 272837 | 2020-06-25 | Christian | Missouri | 29043 | 38 | 0 |
275980 | 275980 | 2020-06-26 | Christian | Missouri | 29043 | 39 | 0 |
279128 | 279128 | 2020-06-27 | Christian | Missouri | 29043 | 40 | 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);