ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Madison" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387491 | 387491 | 2020-07-31 | Madison | Missouri | 29123 | 17 | 0 |
384273 | 384273 | 2020-07-30 | Madison | Missouri | 29123 | 16 | 0 |
381057 | 381057 | 2020-07-29 | Madison | Missouri | 29123 | 16 | 0 |
377840 | 377840 | 2020-07-28 | Madison | Missouri | 29123 | 18 | 0 |
374625 | 374625 | 2020-07-27 | Madison | Missouri | 29123 | 16 | 0 |
371413 | 371413 | 2020-07-26 | Madison | Missouri | 29123 | 15 | 0 |
368202 | 368202 | 2020-07-25 | Madison | Missouri | 29123 | 15 | 0 |
364994 | 364994 | 2020-07-24 | Madison | Missouri | 29123 | 15 | 0 |
361787 | 361787 | 2020-07-23 | Madison | Missouri | 29123 | 13 | 0 |
358582 | 358582 | 2020-07-22 | Madison | Missouri | 29123 | 13 | 0 |
355379 | 355379 | 2020-07-21 | Madison | Missouri | 29123 | 12 | 0 |
352177 | 352177 | 2020-07-20 | Madison | Missouri | 29123 | 11 | 0 |
348977 | 348977 | 2020-07-19 | Madison | Missouri | 29123 | 9 | 0 |
345776 | 345776 | 2020-07-18 | Madison | Missouri | 29123 | 9 | 0 |
342576 | 342576 | 2020-07-17 | Madison | Missouri | 29123 | 8 | 0 |
339380 | 339380 | 2020-07-16 | Madison | Missouri | 29123 | 8 | 0 |
336184 | 336184 | 2020-07-15 | Madison | Missouri | 29123 | 7 | 0 |
332991 | 332991 | 2020-07-14 | Madison | Missouri | 29123 | 7 | 0 |
329804 | 329804 | 2020-07-13 | Madison | Missouri | 29123 | 7 | 0 |
326618 | 326618 | 2020-07-12 | Madison | Missouri | 29123 | 7 | 0 |
323435 | 323435 | 2020-07-11 | Madison | Missouri | 29123 | 7 | 0 |
320256 | 320256 | 2020-07-10 | Madison | Missouri | 29123 | 7 | 0 |
317081 | 317081 | 2020-07-09 | Madison | Missouri | 29123 | 7 | 0 |
313907 | 313907 | 2020-07-08 | Madison | Missouri | 29123 | 7 | 0 |
310736 | 310736 | 2020-07-07 | Madison | Missouri | 29123 | 7 | 0 |
307568 | 307568 | 2020-07-06 | Madison | Missouri | 29123 | 7 | 0 |
304401 | 304401 | 2020-07-05 | Madison | Missouri | 29123 | 7 | 0 |
301237 | 301237 | 2020-07-04 | Madison | Missouri | 29123 | 7 | 0 |
298074 | 298074 | 2020-07-03 | Madison | Missouri | 29123 | 6 | 0 |
294916 | 294916 | 2020-07-02 | Madison | Missouri | 29123 | 6 | 0 |
291762 | 291762 | 2020-07-01 | Madison | Missouri | 29123 | 6 | 0 |
288611 | 288611 | 2020-06-30 | Madison | Missouri | 29123 | 6 | 0 |
285461 | 285461 | 2020-06-29 | Madison | Missouri | 29123 | 6 | 0 |
282316 | 282316 | 2020-06-28 | Madison | Missouri | 29123 | 5 | 0 |
279168 | 279168 | 2020-06-27 | Madison | Missouri | 29123 | 4 | 0 |
276020 | 276020 | 2020-06-26 | Madison | Missouri | 29123 | 3 | 0 |
272877 | 272877 | 2020-06-25 | Madison | Missouri | 29123 | 3 | 0 |
269738 | 269738 | 2020-06-24 | Madison | Missouri | 29123 | 3 | 0 |
266605 | 266605 | 2020-06-23 | Madison | Missouri | 29123 | 3 | 0 |
263479 | 263479 | 2020-06-22 | Madison | Missouri | 29123 | 3 | 0 |
260351 | 260351 | 2020-06-21 | Madison | Missouri | 29123 | 3 | 0 |
257225 | 257225 | 2020-06-20 | Madison | Missouri | 29123 | 3 | 0 |
254105 | 254105 | 2020-06-19 | Madison | Missouri | 29123 | 3 | 0 |
250990 | 250990 | 2020-06-18 | Madison | Missouri | 29123 | 3 | 0 |
247877 | 247877 | 2020-06-17 | Madison | Missouri | 29123 | 3 | 0 |
244764 | 244764 | 2020-06-16 | Madison | Missouri | 29123 | 3 | 0 |
241653 | 241653 | 2020-06-15 | Madison | Missouri | 29123 | 3 | 0 |
238543 | 238543 | 2020-06-14 | Madison | Missouri | 29123 | 3 | 0 |
235436 | 235436 | 2020-06-13 | Madison | Missouri | 29123 | 3 | 0 |
232330 | 232330 | 2020-06-12 | Madison | Missouri | 29123 | 3 | 0 |
229226 | 229226 | 2020-06-11 | Madison | Missouri | 29123 | 3 | 0 |
226123 | 226123 | 2020-06-10 | Madison | Missouri | 29123 | 3 | 0 |
223024 | 223024 | 2020-06-09 | Madison | Missouri | 29123 | 3 | 0 |
219929 | 219929 | 2020-06-08 | Madison | Missouri | 29123 | 3 | 0 |
216837 | 216837 | 2020-06-07 | Madison | Missouri | 29123 | 3 | 0 |
213749 | 213749 | 2020-06-06 | Madison | Missouri | 29123 | 3 | 0 |
210665 | 210665 | 2020-06-05 | Madison | Missouri | 29123 | 3 | 0 |
207584 | 207584 | 2020-06-04 | Madison | Missouri | 29123 | 3 | 0 |
204503 | 204503 | 2020-06-03 | Madison | Missouri | 29123 | 3 | 0 |
201426 | 201426 | 2020-06-02 | Madison | Missouri | 29123 | 3 | 0 |
198353 | 198353 | 2020-06-01 | Madison | Missouri | 29123 | 3 | 0 |
195282 | 195282 | 2020-05-31 | Madison | Missouri | 29123 | 3 | 0 |
192213 | 192213 | 2020-05-30 | Madison | Missouri | 29123 | 3 | 0 |
189149 | 189149 | 2020-05-29 | Madison | Missouri | 29123 | 3 | 0 |
186091 | 186091 | 2020-05-28 | Madison | Missouri | 29123 | 3 | 0 |
183035 | 183035 | 2020-05-27 | Madison | Missouri | 29123 | 3 | 0 |
179989 | 179989 | 2020-05-26 | Madison | Missouri | 29123 | 3 | 0 |
176945 | 176945 | 2020-05-25 | Madison | Missouri | 29123 | 3 | 0 |
173902 | 173902 | 2020-05-24 | Madison | Missouri | 29123 | 3 | 0 |
170860 | 170860 | 2020-05-23 | Madison | Missouri | 29123 | 3 | 0 |
167821 | 167821 | 2020-05-22 | Madison | Missouri | 29123 | 3 | 0 |
164785 | 164785 | 2020-05-21 | Madison | Missouri | 29123 | 3 | 0 |
161756 | 161756 | 2020-05-20 | Madison | Missouri | 29123 | 3 | 0 |
158730 | 158730 | 2020-05-19 | Madison | Missouri | 29123 | 3 | 0 |
155712 | 155712 | 2020-05-18 | Madison | Missouri | 29123 | 3 | 0 |
152698 | 152698 | 2020-05-17 | Madison | Missouri | 29123 | 3 | 0 |
149687 | 149687 | 2020-05-16 | Madison | Missouri | 29123 | 3 | 0 |
146682 | 146682 | 2020-05-15 | Madison | Missouri | 29123 | 3 | 0 |
143681 | 143681 | 2020-05-14 | Madison | Missouri | 29123 | 3 | 0 |
140686 | 140686 | 2020-05-13 | Madison | Missouri | 29123 | 3 | 0 |
137692 | 137692 | 2020-05-12 | Madison | Missouri | 29123 | 3 | 0 |
134702 | 134702 | 2020-05-11 | Madison | Missouri | 29123 | 3 | 0 |
131711 | 131711 | 2020-05-10 | Madison | Missouri | 29123 | 3 | 0 |
128721 | 128721 | 2020-05-09 | Madison | Missouri | 29123 | 3 | 0 |
125733 | 125733 | 2020-05-08 | Madison | Missouri | 29123 | 2 | 0 |
122751 | 122751 | 2020-05-07 | Madison | Missouri | 29123 | 2 | 0 |
119777 | 119777 | 2020-05-06 | Madison | Missouri | 29123 | 2 | 0 |
116817 | 116817 | 2020-05-05 | Madison | Missouri | 29123 | 2 | 0 |
113935 | 113935 | 2020-05-04 | Madison | Missouri | 29123 | 1 | 0 |
111056 | 111056 | 2020-05-03 | Madison | Missouri | 29123 | 1 | 0 |
108184 | 108184 | 2020-05-02 | Madison | Missouri | 29123 | 1 | 0 |
105319 | 105319 | 2020-05-01 | Madison | Missouri | 29123 | 1 | 0 |
102458 | 102458 | 2020-04-30 | Madison | Missouri | 29123 | 1 | 0 |
99606 | 99606 | 2020-04-29 | Madison | Missouri | 29123 | 1 | 0 |
96760 | 96760 | 2020-04-28 | Madison | Missouri | 29123 | 1 | 0 |
93924 | 93924 | 2020-04-27 | Madison | Missouri | 29123 | 1 | 0 |
91103 | 91103 | 2020-04-26 | Madison | Missouri | 29123 | 1 | 0 |
88287 | 88287 | 2020-04-25 | Madison | Missouri | 29123 | 1 | 0 |
85477 | 85477 | 2020-04-24 | Madison | Missouri | 29123 | 1 | 0 |
82673 | 82673 | 2020-04-23 | Madison | Missouri | 29123 | 1 | 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);