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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387450 | 387450 | 2020-07-31 | Christian | Missouri | 29043 | 278 | 1 |
384232 | 384232 | 2020-07-30 | Christian | Missouri | 29043 | 278 | 1 |
381016 | 381016 | 2020-07-29 | Christian | Missouri | 29043 | 241 | 1 |
377799 | 377799 | 2020-07-28 | Christian | Missouri | 29043 | 241 | 1 |
374584 | 374584 | 2020-07-27 | Christian | Missouri | 29043 | 241 | 1 |
371372 | 371372 | 2020-07-26 | Christian | Missouri | 29043 | 211 | 1 |
368161 | 368161 | 2020-07-25 | Christian | Missouri | 29043 | 211 | 1 |
364953 | 364953 | 2020-07-24 | Christian | Missouri | 29043 | 211 | 1 |
361746 | 361746 | 2020-07-23 | Christian | Missouri | 29043 | 185 | 1 |
358541 | 358541 | 2020-07-22 | Christian | Missouri | 29043 | 185 | 1 |
355338 | 355338 | 2020-07-21 | Christian | Missouri | 29043 | 176 | 1 |
352136 | 352136 | 2020-07-20 | Christian | Missouri | 29043 | 148 | 1 |
348936 | 348936 | 2020-07-19 | Christian | Missouri | 29043 | 130 | 1 |
345735 | 345735 | 2020-07-18 | Christian | Missouri | 29043 | 130 | 1 |
342535 | 342535 | 2020-07-17 | Christian | Missouri | 29043 | 130 | 1 |
339339 | 339339 | 2020-07-16 | Christian | Missouri | 29043 | 130 | 1 |
336143 | 336143 | 2020-07-15 | Christian | Missouri | 29043 | 120 | 1 |
332950 | 332950 | 2020-07-14 | Christian | Missouri | 29043 | 120 | 1 |
329763 | 329763 | 2020-07-13 | Christian | Missouri | 29043 | 102 | 1 |
326577 | 326577 | 2020-07-12 | Christian | Missouri | 29043 | 85 | 1 |
323394 | 323394 | 2020-07-11 | Christian | Missouri | 29043 | 85 | 1 |
320215 | 320215 | 2020-07-10 | Christian | Missouri | 29043 | 85 | 1 |
317040 | 317040 | 2020-07-09 | Christian | Missouri | 29043 | 85 | 1 |
313866 | 313866 | 2020-07-08 | Christian | Missouri | 29043 | 71 | 1 |
310696 | 310696 | 2020-07-07 | Christian | Missouri | 29043 | 71 | 1 |
307528 | 307528 | 2020-07-06 | Christian | Missouri | 29043 | 58 | 1 |
304361 | 304361 | 2020-07-05 | Christian | Missouri | 29043 | 54 | 1 |
301197 | 301197 | 2020-07-04 | Christian | Missouri | 29043 | 54 | 1 |
298034 | 298034 | 2020-07-03 | Christian | Missouri | 29043 | 54 | 1 |
294876 | 294876 | 2020-07-02 | Christian | Missouri | 29043 | 54 | 1 |
291722 | 291722 | 2020-07-01 | Christian | Missouri | 29043 | 45 | 0 |
288571 | 288571 | 2020-06-30 | Christian | Missouri | 29043 | 44 | 0 |
285421 | 285421 | 2020-06-29 | Christian | Missouri | 29043 | 43 | 0 |
282276 | 282276 | 2020-06-28 | Christian | Missouri | 29043 | 41 | 0 |
279128 | 279128 | 2020-06-27 | Christian | Missouri | 29043 | 40 | 0 |
275980 | 275980 | 2020-06-26 | Christian | Missouri | 29043 | 39 | 0 |
272837 | 272837 | 2020-06-25 | Christian | Missouri | 29043 | 38 | 0 |
269699 | 269699 | 2020-06-24 | Christian | Missouri | 29043 | 37 | 0 |
266566 | 266566 | 2020-06-23 | Christian | Missouri | 29043 | 35 | 0 |
263440 | 263440 | 2020-06-22 | Christian | Missouri | 29043 | 32 | 0 |
260312 | 260312 | 2020-06-21 | Christian | Missouri | 29043 | 32 | 0 |
257186 | 257186 | 2020-06-20 | Christian | Missouri | 29043 | 32 | 0 |
254066 | 254066 | 2020-06-19 | Christian | Missouri | 29043 | 31 | 0 |
250951 | 250951 | 2020-06-18 | Christian | Missouri | 29043 | 31 | 0 |
247838 | 247838 | 2020-06-17 | Christian | Missouri | 29043 | 30 | 0 |
244725 | 244725 | 2020-06-16 | Christian | Missouri | 29043 | 30 | 0 |
241614 | 241614 | 2020-06-15 | Christian | Missouri | 29043 | 30 | 0 |
238505 | 238505 | 2020-06-14 | Christian | Missouri | 29043 | 29 | 0 |
235398 | 235398 | 2020-06-13 | Christian | Missouri | 29043 | 29 | 0 |
232292 | 232292 | 2020-06-12 | Christian | Missouri | 29043 | 29 | 0 |
229188 | 229188 | 2020-06-11 | Christian | Missouri | 29043 | 28 | 0 |
226085 | 226085 | 2020-06-10 | Christian | Missouri | 29043 | 28 | 0 |
222987 | 222987 | 2020-06-09 | Christian | Missouri | 29043 | 28 | 0 |
219892 | 219892 | 2020-06-08 | Christian | Missouri | 29043 | 28 | 0 |
216800 | 216800 | 2020-06-07 | Christian | Missouri | 29043 | 28 | 0 |
213712 | 213712 | 2020-06-06 | Christian | Missouri | 29043 | 28 | 0 |
210628 | 210628 | 2020-06-05 | Christian | Missouri | 29043 | 29 | 0 |
207547 | 207547 | 2020-06-04 | Christian | Missouri | 29043 | 29 | 0 |
204466 | 204466 | 2020-06-03 | Christian | Missouri | 29043 | 27 | 0 |
201389 | 201389 | 2020-06-02 | Christian | Missouri | 29043 | 24 | 0 |
198316 | 198316 | 2020-06-01 | Christian | Missouri | 29043 | 24 | 0 |
195245 | 195245 | 2020-05-31 | Christian | Missouri | 29043 | 23 | 0 |
192177 | 192177 | 2020-05-30 | Christian | Missouri | 29043 | 23 | 0 |
189113 | 189113 | 2020-05-29 | Christian | Missouri | 29043 | 22 | 0 |
186055 | 186055 | 2020-05-28 | Christian | Missouri | 29043 | 22 | 0 |
182999 | 182999 | 2020-05-27 | Christian | Missouri | 29043 | 22 | 0 |
179953 | 179953 | 2020-05-26 | Christian | Missouri | 29043 | 22 | 0 |
176909 | 176909 | 2020-05-25 | Christian | Missouri | 29043 | 22 | 0 |
173866 | 173866 | 2020-05-24 | Christian | Missouri | 29043 | 22 | 0 |
170824 | 170824 | 2020-05-23 | Christian | Missouri | 29043 | 22 | 0 |
167786 | 167786 | 2020-05-22 | Christian | Missouri | 29043 | 21 | 0 |
164750 | 164750 | 2020-05-21 | Christian | Missouri | 29043 | 21 | 0 |
161721 | 161721 | 2020-05-20 | Christian | Missouri | 29043 | 21 | 0 |
158695 | 158695 | 2020-05-19 | Christian | Missouri | 29043 | 21 | 0 |
155677 | 155677 | 2020-05-18 | Christian | Missouri | 29043 | 21 | 0 |
152663 | 152663 | 2020-05-17 | Christian | Missouri | 29043 | 21 | 0 |
149652 | 149652 | 2020-05-16 | Christian | Missouri | 29043 | 21 | 0 |
146647 | 146647 | 2020-05-15 | Christian | Missouri | 29043 | 21 | 0 |
143647 | 143647 | 2020-05-14 | Christian | Missouri | 29043 | 21 | 0 |
140652 | 140652 | 2020-05-13 | Christian | Missouri | 29043 | 21 | 0 |
137658 | 137658 | 2020-05-12 | Christian | Missouri | 29043 | 21 | 0 |
134668 | 134668 | 2020-05-11 | Christian | Missouri | 29043 | 20 | 0 |
131677 | 131677 | 2020-05-10 | Christian | Missouri | 29043 | 20 | 0 |
128687 | 128687 | 2020-05-09 | Christian | Missouri | 29043 | 20 | 0 |
125700 | 125700 | 2020-05-08 | Christian | Missouri | 29043 | 20 | 0 |
122718 | 122718 | 2020-05-07 | Christian | Missouri | 29043 | 20 | 0 |
119744 | 119744 | 2020-05-06 | Christian | Missouri | 29043 | 19 | 0 |
116784 | 116784 | 2020-05-05 | Christian | Missouri | 29043 | 19 | 0 |
113902 | 113902 | 2020-05-04 | Christian | Missouri | 29043 | 19 | 0 |
111023 | 111023 | 2020-05-03 | Christian | Missouri | 29043 | 19 | 0 |
108152 | 108152 | 2020-05-02 | Christian | Missouri | 29043 | 19 | 0 |
105287 | 105287 | 2020-05-01 | Christian | Missouri | 29043 | 19 | 0 |
102426 | 102426 | 2020-04-30 | Christian | Missouri | 29043 | 19 | 0 |
99574 | 99574 | 2020-04-29 | Christian | Missouri | 29043 | 19 | 0 |
96728 | 96728 | 2020-04-28 | Christian | Missouri | 29043 | 19 | 0 |
93892 | 93892 | 2020-04-27 | Christian | Missouri | 29043 | 19 | 0 |
91071 | 91071 | 2020-04-26 | Christian | Missouri | 29043 | 18 | 0 |
88255 | 88255 | 2020-04-25 | Christian | Missouri | 29043 | 18 | 0 |
85445 | 85445 | 2020-04-24 | Christian | Missouri | 29043 | 18 | 0 |
82641 | 82641 | 2020-04-23 | Christian | Missouri | 29043 | 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);