ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28067 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
279058 | 279058 | 2020-06-27 | Jones | Mississippi | 28067 | 1014 | 48 |
282206 | 282206 | 2020-06-28 | Jones | Mississippi | 28067 | 1027 | 48 |
285351 | 285351 | 2020-06-29 | Jones | Mississippi | 28067 | 1033 | 49 |
288501 | 288501 | 2020-06-30 | Jones | Mississippi | 28067 | 1061 | 49 |
291652 | 291652 | 2020-07-01 | Jones | Mississippi | 28067 | 1069 | 49 |
294806 | 294806 | 2020-07-02 | Jones | Mississippi | 28067 | 1091 | 49 |
297964 | 297964 | 2020-07-03 | Jones | Mississippi | 28067 | 1104 | 49 |
301127 | 301127 | 2020-07-04 | Jones | Mississippi | 28067 | 1120 | 49 |
304291 | 304291 | 2020-07-05 | Jones | Mississippi | 28067 | 1124 | 49 |
307458 | 307458 | 2020-07-06 | Jones | Mississippi | 28067 | 1128 | 49 |
310626 | 310626 | 2020-07-07 | Jones | Mississippi | 28067 | 1140 | 49 |
313796 | 313796 | 2020-07-08 | Jones | Mississippi | 28067 | 1159 | 49 |
316970 | 316970 | 2020-07-09 | Jones | Mississippi | 28067 | 1173 | 49 |
320145 | 320145 | 2020-07-10 | Jones | Mississippi | 28067 | 1185 | 49 |
323324 | 323324 | 2020-07-11 | Jones | Mississippi | 28067 | 1203 | 49 |
326507 | 326507 | 2020-07-12 | Jones | Mississippi | 28067 | 1224 | 49 |
329693 | 329693 | 2020-07-13 | Jones | Mississippi | 28067 | 1231 | 49 |
332880 | 332880 | 2020-07-14 | Jones | Mississippi | 28067 | 1254 | 50 |
336073 | 336073 | 2020-07-15 | Jones | Mississippi | 28067 | 1266 | 51 |
339269 | 339269 | 2020-07-16 | Jones | Mississippi | 28067 | 1284 | 52 |
342465 | 342465 | 2020-07-17 | Jones | Mississippi | 28067 | 1302 | 52 |
345665 | 345665 | 2020-07-18 | Jones | Mississippi | 28067 | 1342 | 52 |
348866 | 348866 | 2020-07-19 | Jones | Mississippi | 28067 | 1346 | 53 |
352066 | 352066 | 2020-07-20 | Jones | Mississippi | 28067 | 1382 | 53 |
355268 | 355268 | 2020-07-21 | Jones | Mississippi | 28067 | 1422 | 53 |
358471 | 358471 | 2020-07-22 | Jones | Mississippi | 28067 | 1432 | 53 |
361676 | 361676 | 2020-07-23 | Jones | Mississippi | 28067 | 1455 | 53 |
364883 | 364883 | 2020-07-24 | Jones | Mississippi | 28067 | 1495 | 54 |
368091 | 368091 | 2020-07-25 | Jones | Mississippi | 28067 | 1522 | 54 |
371301 | 371301 | 2020-07-26 | Jones | Mississippi | 28067 | 1563 | 56 |
374513 | 374513 | 2020-07-27 | Jones | Mississippi | 28067 | 1591 | 56 |
377728 | 377728 | 2020-07-28 | Jones | Mississippi | 28067 | 1621 | 56 |
380945 | 380945 | 2020-07-29 | Jones | Mississippi | 28067 | 1635 | 56 |
384162 | 384162 | 2020-07-30 | Jones | Mississippi | 28067 | 1674 | 57 |
387380 | 387380 | 2020-07-31 | Jones | Mississippi | 28067 | 1705 | 57 |
390597 | 390597 | 2020-08-01 | Jones | Mississippi | 28067 | 1740 | 57 |
393814 | 393814 | 2020-08-02 | Jones | Mississippi | 28067 | 1765 | 57 |
397030 | 397030 | 2020-08-03 | Jones | Mississippi | 28067 | 1774 | 57 |
400244 | 400244 | 2020-08-04 | Jones | Mississippi | 28067 | 1804 | 57 |
403461 | 403461 | 2020-08-05 | Jones | Mississippi | 28067 | 1828 | 57 |
406679 | 406679 | 2020-08-06 | Jones | Mississippi | 28067 | 1842 | 58 |
409899 | 409899 | 2020-08-07 | Jones | Mississippi | 28067 | 1850 | 58 |
413119 | 413119 | 2020-08-08 | Jones | Mississippi | 28067 | 1885 | 58 |
416339 | 416339 | 2020-08-09 | Jones | Mississippi | 28067 | 1899 | 58 |
419560 | 419560 | 2020-08-10 | Jones | Mississippi | 28067 | 1916 | 59 |
422782 | 422782 | 2020-08-11 | Jones | Mississippi | 28067 | 1931 | 59 |
426004 | 426004 | 2020-08-12 | Jones | Mississippi | 28067 | 1947 | 62 |
429228 | 429228 | 2020-08-13 | Jones | Mississippi | 28067 | 1945 | 62 |
432455 | 432455 | 2020-08-14 | Jones | Mississippi | 28067 | 1965 | 62 |
435681 | 435681 | 2020-08-15 | Jones | Mississippi | 28067 | 1978 | 64 |
438906 | 438906 | 2020-08-16 | Jones | Mississippi | 28067 | 1987 | 65 |
442133 | 442133 | 2020-08-17 | Jones | Mississippi | 28067 | 2002 | 65 |
445359 | 445359 | 2020-08-18 | Jones | Mississippi | 28067 | 2007 | 66 |
448585 | 448585 | 2020-08-19 | Jones | Mississippi | 28067 | 2020 | 66 |
451813 | 451813 | 2020-08-20 | Jones | Mississippi | 28067 | 2033 | 67 |
455041 | 455041 | 2020-08-21 | Jones | Mississippi | 28067 | 2041 | 68 |
458269 | 458269 | 2020-08-22 | Jones | Mississippi | 28067 | 2057 | 69 |
461496 | 461496 | 2020-08-23 | Jones | Mississippi | 28067 | 2073 | 69 |
464727 | 464727 | 2020-08-24 | Jones | Mississippi | 28067 | 2080 | 69 |
467956 | 467956 | 2020-08-25 | Jones | Mississippi | 28067 | 2087 | 69 |
471186 | 471186 | 2020-08-26 | Jones | Mississippi | 28067 | 2114 | 69 |
474418 | 474418 | 2020-08-27 | Jones | Mississippi | 28067 | 2111 | 71 |
477651 | 477651 | 2020-08-28 | Jones | Mississippi | 28067 | 2127 | 72 |
480883 | 480883 | 2020-08-29 | Jones | Mississippi | 28067 | 2146 | 72 |
484118 | 484118 | 2020-08-30 | Jones | Mississippi | 28067 | 2153 | 72 |
487352 | 487352 | 2020-08-31 | Jones | Mississippi | 28067 | 2159 | 72 |
490585 | 490585 | 2020-09-01 | Jones | Mississippi | 28067 | 2169 | 73 |
493819 | 493819 | 2020-09-02 | Jones | Mississippi | 28067 | 2178 | 74 |
497052 | 497052 | 2020-09-03 | Jones | Mississippi | 28067 | 2191 | 74 |
500286 | 500286 | 2020-09-04 | Jones | Mississippi | 28067 | 2212 | 75 |
503520 | 503520 | 2020-09-05 | Jones | Mississippi | 28067 | 2218 | 75 |
506753 | 506753 | 2020-09-06 | Jones | Mississippi | 28067 | 2222 | 75 |
509986 | 509986 | 2020-09-07 | Jones | Mississippi | 28067 | 2234 | 75 |
513218 | 513218 | 2020-09-08 | Jones | Mississippi | 28067 | 2239 | 75 |
516452 | 516452 | 2020-09-09 | Jones | Mississippi | 28067 | 2246 | 76 |
519687 | 519687 | 2020-09-10 | Jones | Mississippi | 28067 | 2253 | 76 |
522924 | 522924 | 2020-09-11 | Jones | Mississippi | 28067 | 2276 | 76 |
526160 | 526160 | 2020-09-12 | Jones | Mississippi | 28067 | 2288 | 76 |
529396 | 529396 | 2020-09-13 | Jones | Mississippi | 28067 | 2293 | 76 |
532632 | 532632 | 2020-09-14 | Jones | Mississippi | 28067 | 2298 | 76 |
535867 | 535867 | 2020-09-15 | Jones | Mississippi | 28067 | 2315 | 77 |
539104 | 539104 | 2020-09-16 | Jones | Mississippi | 28067 | 2340 | 77 |
542340 | 542340 | 2020-09-17 | Jones | Mississippi | 28067 | 2360 | 78 |
545577 | 545577 | 2020-09-18 | Jones | Mississippi | 28067 | 2376 | 78 |
548815 | 548815 | 2020-09-19 | Jones | Mississippi | 28067 | 2399 | 78 |
552054 | 552054 | 2020-09-20 | Jones | Mississippi | 28067 | 2420 | 78 |
555292 | 555292 | 2020-09-21 | Jones | Mississippi | 28067 | 2427 | 78 |
558529 | 558529 | 2020-09-22 | Jones | Mississippi | 28067 | 2438 | 78 |
561766 | 561766 | 2020-09-23 | Jones | Mississippi | 28067 | 2452 | 79 |
565006 | 565006 | 2020-09-24 | Jones | Mississippi | 28067 | 2468 | 79 |
568246 | 568246 | 2020-09-25 | Jones | Mississippi | 28067 | 2475 | 79 |
571488 | 571488 | 2020-09-26 | Jones | Mississippi | 28067 | 2487 | 79 |
574731 | 574731 | 2020-09-27 | Jones | Mississippi | 28067 | 2498 | 79 |
577972 | 577972 | 2020-09-28 | Jones | Mississippi | 28067 | 2504 | 79 |
581213 | 581213 | 2020-09-29 | Jones | Mississippi | 28067 | 2515 | 80 |
584454 | 584454 | 2020-09-30 | Jones | Mississippi | 28067 | 2527 | 80 |
587694 | 587694 | 2020-10-01 | Jones | Mississippi | 28067 | 2546 | 81 |
590935 | 590935 | 2020-10-02 | Jones | Mississippi | 28067 | 2560 | 81 |
594176 | 594176 | 2020-10-03 | Jones | Mississippi | 28067 | 2570 | 81 |
597417 | 597417 | 2020-10-04 | Jones | Mississippi | 28067 | 2583 | 81 |
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);