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 |
---|---|---|---|---|---|---|---|
535978 | 535978 | 2020-09-15 | Madison | Missouri | 29123 | 247 | 0 |
532743 | 532743 | 2020-09-14 | Madison | Missouri | 29123 | 242 | 0 |
529507 | 529507 | 2020-09-13 | Madison | Missouri | 29123 | 238 | 0 |
526271 | 526271 | 2020-09-12 | Madison | Missouri | 29123 | 238 | 0 |
523035 | 523035 | 2020-09-11 | Madison | Missouri | 29123 | 229 | 0 |
519798 | 519798 | 2020-09-10 | Madison | Missouri | 29123 | 224 | 0 |
516563 | 516563 | 2020-09-09 | Madison | Missouri | 29123 | 222 | 0 |
513329 | 513329 | 2020-09-08 | Madison | Missouri | 29123 | 208 | 0 |
510097 | 510097 | 2020-09-07 | Madison | Missouri | 29123 | 204 | 0 |
506864 | 506864 | 2020-09-06 | Madison | Missouri | 29123 | 199 | 0 |
503631 | 503631 | 2020-09-05 | Madison | Missouri | 29123 | 198 | 0 |
500397 | 500397 | 2020-09-04 | Madison | Missouri | 29123 | 182 | 0 |
497163 | 497163 | 2020-09-03 | Madison | Missouri | 29123 | 176 | 0 |
493930 | 493930 | 2020-09-02 | Madison | Missouri | 29123 | 170 | 0 |
490696 | 490696 | 2020-09-01 | Madison | Missouri | 29123 | 147 | 0 |
487463 | 487463 | 2020-08-31 | Madison | Missouri | 29123 | 143 | 0 |
484229 | 484229 | 2020-08-30 | Madison | Missouri | 29123 | 131 | 0 |
480994 | 480994 | 2020-08-29 | Madison | Missouri | 29123 | 119 | 0 |
477762 | 477762 | 2020-08-28 | Madison | Missouri | 29123 | 111 | 0 |
474529 | 474529 | 2020-08-27 | Madison | Missouri | 29123 | 98 | 0 |
471297 | 471297 | 2020-08-26 | Madison | Missouri | 29123 | 84 | 0 |
468067 | 468067 | 2020-08-25 | Madison | Missouri | 29123 | 77 | 0 |
464838 | 464838 | 2020-08-24 | Madison | Missouri | 29123 | 77 | 0 |
461607 | 461607 | 2020-08-23 | Madison | Missouri | 29123 | 71 | 0 |
458380 | 458380 | 2020-08-22 | Madison | Missouri | 29123 | 67 | 0 |
455152 | 455152 | 2020-08-21 | Madison | Missouri | 29123 | 54 | 0 |
451924 | 451924 | 2020-08-20 | Madison | Missouri | 29123 | 49 | 0 |
448696 | 448696 | 2020-08-19 | Madison | Missouri | 29123 | 46 | 0 |
445470 | 445470 | 2020-08-18 | Madison | Missouri | 29123 | 41 | 0 |
442244 | 442244 | 2020-08-17 | Madison | Missouri | 29123 | 38 | 0 |
439017 | 439017 | 2020-08-16 | Madison | Missouri | 29123 | 35 | 0 |
435792 | 435792 | 2020-08-15 | Madison | Missouri | 29123 | 34 | 0 |
432566 | 432566 | 2020-08-14 | Madison | Missouri | 29123 | 30 | 0 |
429339 | 429339 | 2020-08-13 | Madison | Missouri | 29123 | 29 | 0 |
426115 | 426115 | 2020-08-12 | Madison | Missouri | 29123 | 28 | 0 |
422893 | 422893 | 2020-08-11 | Madison | Missouri | 29123 | 25 | 0 |
419671 | 419671 | 2020-08-10 | Madison | Missouri | 29123 | 25 | 0 |
416450 | 416450 | 2020-08-09 | Madison | Missouri | 29123 | 25 | 0 |
413230 | 413230 | 2020-08-08 | Madison | Missouri | 29123 | 24 | 0 |
410010 | 410010 | 2020-08-07 | Madison | Missouri | 29123 | 24 | 0 |
406790 | 406790 | 2020-08-06 | Madison | Missouri | 29123 | 24 | 0 |
403572 | 403572 | 2020-08-05 | Madison | Missouri | 29123 | 18 | 0 |
400355 | 400355 | 2020-08-04 | Madison | Missouri | 29123 | 17 | 0 |
397141 | 397141 | 2020-08-03 | Madison | Missouri | 29123 | 17 | 0 |
393925 | 393925 | 2020-08-02 | Madison | Missouri | 29123 | 17 | 0 |
390708 | 390708 | 2020-08-01 | Madison | Missouri | 29123 | 17 | 0 |
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 |
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);