ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,630 rows where county = "Suffolk" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535659 | 535659 | 2020-09-15 | Suffolk | Massachusetts | 25025 | 23306 | 1120 |
536308 | 536308 | 2020-09-15 | Suffolk | New York | 36103 | 45785 | 2011 |
532424 | 532424 | 2020-09-14 | Suffolk | Massachusetts | 25025 | 23236 | 1119 |
533072 | 533072 | 2020-09-14 | Suffolk | New York | 36103 | 45714 | 2010 |
529188 | 529188 | 2020-09-13 | Suffolk | Massachusetts | 25025 | 23194 | 1116 |
529837 | 529837 | 2020-09-13 | Suffolk | New York | 36103 | 45683 | 2009 |
525952 | 525952 | 2020-09-12 | Suffolk | Massachusetts | 25025 | 23130 | 1116 |
526600 | 526600 | 2020-09-12 | Suffolk | New York | 36103 | 45615 | 2008 |
522716 | 522716 | 2020-09-11 | Suffolk | Massachusetts | 25025 | 23028 | 1114 |
523364 | 523364 | 2020-09-11 | Suffolk | New York | 36103 | 45534 | 2008 |
519479 | 519479 | 2020-09-10 | Suffolk | Massachusetts | 25025 | 22920 | 1113 |
520128 | 520128 | 2020-09-10 | Suffolk | New York | 36103 | 45463 | 2006 |
516244 | 516244 | 2020-09-09 | Suffolk | Massachusetts | 25025 | 22831 | 1111 |
516892 | 516892 | 2020-09-09 | Suffolk | New York | 36103 | 45411 | 2006 |
513010 | 513010 | 2020-09-08 | Suffolk | Massachusetts | 25025 | 22788 | 1111 |
513657 | 513657 | 2020-09-08 | Suffolk | New York | 36103 | 45356 | 2006 |
509778 | 509778 | 2020-09-07 | Suffolk | Massachusetts | 25025 | 22756 | 1111 |
510424 | 510424 | 2020-09-07 | Suffolk | New York | 36103 | 45304 | 2006 |
506545 | 506545 | 2020-09-06 | Suffolk | Massachusetts | 25025 | 22697 | 1110 |
507191 | 507191 | 2020-09-06 | Suffolk | New York | 36103 | 45258 | 2006 |
503312 | 503312 | 2020-09-05 | Suffolk | Massachusetts | 25025 | 22623 | 1110 |
503959 | 503959 | 2020-09-05 | Suffolk | New York | 36103 | 45200 | 2006 |
500078 | 500078 | 2020-09-04 | Suffolk | Massachusetts | 25025 | 22529 | 1107 |
500725 | 500725 | 2020-09-04 | Suffolk | New York | 36103 | 45102 | 2005 |
496844 | 496844 | 2020-09-03 | Suffolk | Massachusetts | 25025 | 22593 | 1106 |
497491 | 497491 | 2020-09-03 | Suffolk | New York | 36103 | 45006 | 2005 |
493611 | 493611 | 2020-09-02 | Suffolk | Massachusetts | 25025 | 22508 | 1104 |
494258 | 494258 | 2020-09-02 | Suffolk | New York | 36103 | 44940 | 2003 |
490377 | 490377 | 2020-09-01 | Suffolk | Massachusetts | 25025 | 23552 | 1110 |
491024 | 491024 | 2020-09-01 | Suffolk | New York | 36103 | 44885 | 2002 |
487144 | 487144 | 2020-08-31 | Suffolk | Massachusetts | 25025 | 23472 | 1109 |
487791 | 487791 | 2020-08-31 | Suffolk | New York | 36103 | 44820 | 2002 |
483910 | 483910 | 2020-08-30 | Suffolk | Massachusetts | 25025 | 23403 | 1107 |
484558 | 484558 | 2020-08-30 | Suffolk | New York | 36103 | 44763 | 2002 |
480675 | 480675 | 2020-08-29 | Suffolk | Massachusetts | 25025 | 23350 | 1107 |
481323 | 481323 | 2020-08-29 | Suffolk | New York | 36103 | 44712 | 2002 |
477443 | 477443 | 2020-08-28 | Suffolk | Massachusetts | 25025 | 23261 | 1106 |
478090 | 478090 | 2020-08-28 | Suffolk | New York | 36103 | 44678 | 2001 |
474210 | 474210 | 2020-08-27 | Suffolk | Massachusetts | 25025 | 23154 | 1105 |
474857 | 474857 | 2020-08-27 | Suffolk | New York | 36103 | 44641 | 2001 |
470978 | 470978 | 2020-08-26 | Suffolk | Massachusetts | 25025 | 23064 | 1101 |
471623 | 471623 | 2020-08-26 | Suffolk | New York | 36103 | 44605 | 2001 |
467748 | 467748 | 2020-08-25 | Suffolk | Massachusetts | 25025 | 22973 | 1097 |
468391 | 468391 | 2020-08-25 | Suffolk | New York | 36103 | 44561 | 2001 |
464519 | 464519 | 2020-08-24 | Suffolk | Massachusetts | 25025 | 22904 | 1095 |
465163 | 465163 | 2020-08-24 | Suffolk | New York | 36103 | 44519 | 2001 |
461288 | 461288 | 2020-08-23 | Suffolk | Massachusetts | 25025 | 22706 | 1093 |
461934 | 461934 | 2020-08-23 | Suffolk | New York | 36103 | 44498 | 2001 |
458061 | 458061 | 2020-08-22 | Suffolk | Massachusetts | 25025 | 22706 | 1093 |
458706 | 458706 | 2020-08-22 | Suffolk | New York | 36103 | 44456 | 2001 |
454833 | 454833 | 2020-08-21 | Suffolk | Massachusetts | 25025 | 22694 | 1092 |
455478 | 455478 | 2020-08-21 | Suffolk | New York | 36103 | 44400 | 2000 |
451605 | 451605 | 2020-08-20 | Suffolk | Massachusetts | 25025 | 22577 | 1091 |
452250 | 452250 | 2020-08-20 | Suffolk | New York | 36103 | 44353 | 2000 |
448377 | 448377 | 2020-08-19 | Suffolk | Massachusetts | 25025 | 22511 | 1090 |
449022 | 449022 | 2020-08-19 | Suffolk | New York | 36103 | 44305 | 2000 |
445151 | 445151 | 2020-08-18 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
445794 | 445794 | 2020-08-18 | Suffolk | New York | 36103 | 44235 | 2000 |
441925 | 441925 | 2020-08-17 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
442568 | 442568 | 2020-08-17 | Suffolk | New York | 36103 | 44185 | 1999 |
438698 | 438698 | 2020-08-16 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
439341 | 439341 | 2020-08-16 | Suffolk | New York | 36103 | 44159 | 1998 |
435473 | 435473 | 2020-08-15 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
436116 | 436116 | 2020-08-15 | Suffolk | New York | 36103 | 44109 | 1998 |
432247 | 432247 | 2020-08-14 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
432890 | 432890 | 2020-08-14 | Suffolk | New York | 36103 | 44045 | 1998 |
429020 | 429020 | 2020-08-13 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
429664 | 429664 | 2020-08-13 | Suffolk | New York | 36103 | 43987 | 1998 |
425796 | 425796 | 2020-08-12 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
426439 | 426439 | 2020-08-12 | Suffolk | New York | 36103 | 43948 | 1998 |
422574 | 422574 | 2020-08-11 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
423216 | 423216 | 2020-08-11 | Suffolk | New York | 36103 | 43893 | 1998 |
419352 | 419352 | 2020-08-10 | Suffolk | Massachusetts | 25025 | 21929 | 1074 |
419993 | 419993 | 2020-08-10 | Suffolk | New York | 36103 | 43844 | 1998 |
416131 | 416131 | 2020-08-09 | Suffolk | Massachusetts | 25025 | 21849 | 1074 |
416773 | 416773 | 2020-08-09 | Suffolk | New York | 36103 | 43786 | 1998 |
412911 | 412911 | 2020-08-08 | Suffolk | Massachusetts | 25025 | 21778 | 1073 |
413552 | 413552 | 2020-08-08 | Suffolk | New York | 36103 | 43749 | 1998 |
409691 | 409691 | 2020-08-07 | Suffolk | Massachusetts | 25025 | 21717 | 1071 |
410332 | 410332 | 2020-08-07 | Suffolk | New York | 36103 | 43681 | 1998 |
406471 | 406471 | 2020-08-06 | Suffolk | Massachusetts | 25025 | 21631 | 1066 |
407112 | 407112 | 2020-08-06 | Suffolk | New York | 36103 | 43630 | 1998 |
403253 | 403253 | 2020-08-05 | Suffolk | Massachusetts | 25025 | 21579 | 1063 |
403893 | 403893 | 2020-08-05 | Suffolk | New York | 36103 | 43553 | 2044 |
400036 | 400036 | 2020-08-04 | Suffolk | Massachusetts | 25025 | 21481 | 1062 |
400675 | 400675 | 2020-08-04 | Suffolk | New York | 36103 | 43468 | 2044 |
396822 | 396822 | 2020-08-03 | Suffolk | Massachusetts | 25025 | 21378 | 1059 |
397460 | 397460 | 2020-08-03 | Suffolk | New York | 36103 | 43395 | 2044 |
393606 | 393606 | 2020-08-02 | Suffolk | Massachusetts | 25025 | 21355 | 1058 |
394243 | 394243 | 2020-08-02 | Suffolk | New York | 36103 | 43345 | 2044 |
390389 | 390389 | 2020-08-01 | Suffolk | Massachusetts | 25025 | 21279 | 1057 |
391027 | 391027 | 2020-08-01 | Suffolk | New York | 36103 | 43300 | 2044 |
387172 | 387172 | 2020-07-31 | Suffolk | Massachusetts | 25025 | 21222 | 1055 |
387810 | 387810 | 2020-07-31 | Suffolk | New York | 36103 | 43224 | 2044 |
383954 | 383954 | 2020-07-30 | Suffolk | Massachusetts | 25025 | 21113 | 1055 |
384593 | 384593 | 2020-07-30 | Suffolk | New York | 36103 | 43170 | 2043 |
380737 | 380737 | 2020-07-29 | Suffolk | Massachusetts | 25025 | 21030 | 1054 |
381375 | 381375 | 2020-07-29 | Suffolk | New York | 36103 | 43084 | 2043 |
377520 | 377520 | 2020-07-28 | Suffolk | Massachusetts | 25025 | 20960 | 1052 |
378158 | 378158 | 2020-07-28 | Suffolk | New York | 36103 | 43024 | 2043 |
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);