ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
698 rows where county = "Dade" and state = "Missouri" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
241621 | 241621 | 2020-06-15 | Dade | Missouri | 29057 | 1 | 0 |
244732 | 244732 | 2020-06-16 | Dade | Missouri | 29057 | 1 | 0 |
247845 | 247845 | 2020-06-17 | Dade | Missouri | 29057 | 1 | 0 |
250958 | 250958 | 2020-06-18 | Dade | Missouri | 29057 | 1 | 0 |
254073 | 254073 | 2020-06-19 | Dade | Missouri | 29057 | 1 | 0 |
257193 | 257193 | 2020-06-20 | Dade | Missouri | 29057 | 1 | 0 |
260319 | 260319 | 2020-06-21 | Dade | Missouri | 29057 | 1 | 0 |
263447 | 263447 | 2020-06-22 | Dade | Missouri | 29057 | 1 | 0 |
266573 | 266573 | 2020-06-23 | Dade | Missouri | 29057 | 1 | 0 |
269706 | 269706 | 2020-06-24 | Dade | Missouri | 29057 | 1 | 0 |
272844 | 272844 | 2020-06-25 | Dade | Missouri | 29057 | 1 | 0 |
275987 | 275987 | 2020-06-26 | Dade | Missouri | 29057 | 1 | 0 |
279135 | 279135 | 2020-06-27 | Dade | Missouri | 29057 | 1 | 0 |
282283 | 282283 | 2020-06-28 | Dade | Missouri | 29057 | 1 | 0 |
285428 | 285428 | 2020-06-29 | Dade | Missouri | 29057 | 1 | 0 |
288578 | 288578 | 2020-06-30 | Dade | Missouri | 29057 | 1 | 0 |
291729 | 291729 | 2020-07-01 | Dade | Missouri | 29057 | 1 | 0 |
294883 | 294883 | 2020-07-02 | Dade | Missouri | 29057 | 1 | 0 |
298041 | 298041 | 2020-07-03 | Dade | Missouri | 29057 | 1 | 0 |
301204 | 301204 | 2020-07-04 | Dade | Missouri | 29057 | 1 | 0 |
304368 | 304368 | 2020-07-05 | Dade | Missouri | 29057 | 1 | 0 |
307535 | 307535 | 2020-07-06 | Dade | Missouri | 29057 | 1 | 0 |
310703 | 310703 | 2020-07-07 | Dade | Missouri | 29057 | 1 | 0 |
313873 | 313873 | 2020-07-08 | Dade | Missouri | 29057 | 1 | 0 |
317047 | 317047 | 2020-07-09 | Dade | Missouri | 29057 | 2 | 0 |
320222 | 320222 | 2020-07-10 | Dade | Missouri | 29057 | 2 | 0 |
323401 | 323401 | 2020-07-11 | Dade | Missouri | 29057 | 2 | 0 |
326584 | 326584 | 2020-07-12 | Dade | Missouri | 29057 | 2 | 0 |
329770 | 329770 | 2020-07-13 | Dade | Missouri | 29057 | 2 | 0 |
332957 | 332957 | 2020-07-14 | Dade | Missouri | 29057 | 2 | 0 |
336150 | 336150 | 2020-07-15 | Dade | Missouri | 29057 | 2 | 0 |
339346 | 339346 | 2020-07-16 | Dade | Missouri | 29057 | 2 | 0 |
342542 | 342542 | 2020-07-17 | Dade | Missouri | 29057 | 3 | 0 |
345742 | 345742 | 2020-07-18 | Dade | Missouri | 29057 | 4 | 0 |
348943 | 348943 | 2020-07-19 | Dade | Missouri | 29057 | 4 | 0 |
352143 | 352143 | 2020-07-20 | Dade | Missouri | 29057 | 4 | 0 |
355345 | 355345 | 2020-07-21 | Dade | Missouri | 29057 | 4 | 0 |
358548 | 358548 | 2020-07-22 | Dade | Missouri | 29057 | 9 | 0 |
361753 | 361753 | 2020-07-23 | Dade | Missouri | 29057 | 10 | 0 |
364960 | 364960 | 2020-07-24 | Dade | Missouri | 29057 | 10 | 0 |
368168 | 368168 | 2020-07-25 | Dade | Missouri | 29057 | 10 | 0 |
371379 | 371379 | 2020-07-26 | Dade | Missouri | 29057 | 10 | 0 |
374591 | 374591 | 2020-07-27 | Dade | Missouri | 29057 | 10 | 0 |
377806 | 377806 | 2020-07-28 | Dade | Missouri | 29057 | 11 | 0 |
381023 | 381023 | 2020-07-29 | Dade | Missouri | 29057 | 14 | 0 |
384239 | 384239 | 2020-07-30 | Dade | Missouri | 29057 | 14 | 0 |
387457 | 387457 | 2020-07-31 | Dade | Missouri | 29057 | 14 | 0 |
390674 | 390674 | 2020-08-01 | Dade | Missouri | 29057 | 14 | 0 |
393891 | 393891 | 2020-08-02 | Dade | Missouri | 29057 | 15 | 0 |
397107 | 397107 | 2020-08-03 | Dade | Missouri | 29057 | 21 | 0 |
400321 | 400321 | 2020-08-04 | Dade | Missouri | 29057 | 21 | 0 |
403538 | 403538 | 2020-08-05 | Dade | Missouri | 29057 | 15 | 0 |
406756 | 406756 | 2020-08-06 | Dade | Missouri | 29057 | 14 | 0 |
409976 | 409976 | 2020-08-07 | Dade | Missouri | 29057 | 15 | 0 |
413196 | 413196 | 2020-08-08 | Dade | Missouri | 29057 | 15 | 0 |
416416 | 416416 | 2020-08-09 | Dade | Missouri | 29057 | 15 | 0 |
419637 | 419637 | 2020-08-10 | Dade | Missouri | 29057 | 15 | 0 |
422859 | 422859 | 2020-08-11 | Dade | Missouri | 29057 | 15 | 0 |
426081 | 426081 | 2020-08-12 | Dade | Missouri | 29057 | 15 | 0 |
429305 | 429305 | 2020-08-13 | Dade | Missouri | 29057 | 17 | 0 |
432532 | 432532 | 2020-08-14 | Dade | Missouri | 29057 | 17 | 0 |
435758 | 435758 | 2020-08-15 | Dade | Missouri | 29057 | 17 | 0 |
438983 | 438983 | 2020-08-16 | Dade | Missouri | 29057 | 17 | 0 |
442210 | 442210 | 2020-08-17 | Dade | Missouri | 29057 | 17 | 0 |
445436 | 445436 | 2020-08-18 | Dade | Missouri | 29057 | 18 | 0 |
448662 | 448662 | 2020-08-19 | Dade | Missouri | 29057 | 19 | 0 |
451890 | 451890 | 2020-08-20 | Dade | Missouri | 29057 | 19 | 0 |
455118 | 455118 | 2020-08-21 | Dade | Missouri | 29057 | 21 | 0 |
458346 | 458346 | 2020-08-22 | Dade | Missouri | 29057 | 21 | 0 |
461573 | 461573 | 2020-08-23 | Dade | Missouri | 29057 | 21 | 0 |
464804 | 464804 | 2020-08-24 | Dade | Missouri | 29057 | 20 | 0 |
468033 | 468033 | 2020-08-25 | Dade | Missouri | 29057 | 20 | 0 |
471263 | 471263 | 2020-08-26 | Dade | Missouri | 29057 | 22 | 0 |
474495 | 474495 | 2020-08-27 | Dade | Missouri | 29057 | 22 | 0 |
477728 | 477728 | 2020-08-28 | Dade | Missouri | 29057 | 24 | 0 |
480960 | 480960 | 2020-08-29 | Dade | Missouri | 29057 | 26 | 0 |
484195 | 484195 | 2020-08-30 | Dade | Missouri | 29057 | 27 | 0 |
487429 | 487429 | 2020-08-31 | Dade | Missouri | 29057 | 30 | 0 |
490662 | 490662 | 2020-09-01 | Dade | Missouri | 29057 | 30 | 0 |
493896 | 493896 | 2020-09-02 | Dade | Missouri | 29057 | 30 | 0 |
497129 | 497129 | 2020-09-03 | Dade | Missouri | 29057 | 32 | 0 |
500363 | 500363 | 2020-09-04 | Dade | Missouri | 29057 | 32 | 0 |
503597 | 503597 | 2020-09-05 | Dade | Missouri | 29057 | 34 | 0 |
506830 | 506830 | 2020-09-06 | Dade | Missouri | 29057 | 34 | 0 |
510063 | 510063 | 2020-09-07 | Dade | Missouri | 29057 | 36 | 0 |
513295 | 513295 | 2020-09-08 | Dade | Missouri | 29057 | 36 | 0 |
516529 | 516529 | 2020-09-09 | Dade | Missouri | 29057 | 36 | 0 |
519764 | 519764 | 2020-09-10 | Dade | Missouri | 29057 | 37 | 0 |
523001 | 523001 | 2020-09-11 | Dade | Missouri | 29057 | 39 | 0 |
526237 | 526237 | 2020-09-12 | Dade | Missouri | 29057 | 41 | 0 |
529473 | 529473 | 2020-09-13 | Dade | Missouri | 29057 | 41 | 0 |
532709 | 532709 | 2020-09-14 | Dade | Missouri | 29057 | 42 | 0 |
535944 | 535944 | 2020-09-15 | Dade | Missouri | 29057 | 44 | 0 |
539181 | 539181 | 2020-09-16 | Dade | Missouri | 29057 | 44 | 0 |
542417 | 542417 | 2020-09-17 | Dade | Missouri | 29057 | 44 | 0 |
545654 | 545654 | 2020-09-18 | Dade | Missouri | 29057 | 46 | 0 |
548892 | 548892 | 2020-09-19 | Dade | Missouri | 29057 | 47 | 0 |
552131 | 552131 | 2020-09-20 | Dade | Missouri | 29057 | 48 | 0 |
555369 | 555369 | 2020-09-21 | Dade | Missouri | 29057 | 50 | 0 |
558606 | 558606 | 2020-09-22 | Dade | Missouri | 29057 | 52 | 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);