ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636124 | 636124 | 2020-10-16 | Suffolk | Massachusetts | 25025 | 26160 | 1155 |
632878 | 632878 | 2020-10-15 | Suffolk | Massachusetts | 25025 | 26012 | 1153 |
629633 | 629633 | 2020-10-14 | Suffolk | Massachusetts | 25025 | 25896 | 1150 |
626389 | 626389 | 2020-10-13 | Suffolk | Massachusetts | 25025 | 25824 | 1148 |
623147 | 623147 | 2020-10-12 | Suffolk | Massachusetts | 25025 | 25702 | 1147 |
619904 | 619904 | 2020-10-11 | Suffolk | Massachusetts | 25025 | 25562 | 1147 |
616662 | 616662 | 2020-10-10 | Suffolk | Massachusetts | 25025 | 25497 | 1145 |
613421 | 613421 | 2020-10-09 | Suffolk | Massachusetts | 25025 | 25382 | 1144 |
610179 | 610179 | 2020-10-08 | Suffolk | Massachusetts | 25025 | 25273 | 1143 |
606937 | 606937 | 2020-10-07 | Suffolk | Massachusetts | 25025 | 25200 | 1143 |
603694 | 603694 | 2020-10-06 | Suffolk | Massachusetts | 25025 | 25117 | 1142 |
600452 | 600452 | 2020-10-05 | Suffolk | Massachusetts | 25025 | 25052 | 1142 |
597209 | 597209 | 2020-10-04 | Suffolk | Massachusetts | 25025 | 24987 | 1142 |
593968 | 593968 | 2020-10-03 | Suffolk | Massachusetts | 25025 | 24871 | 1142 |
590727 | 590727 | 2020-10-02 | Suffolk | Massachusetts | 25025 | 24764 | 1142 |
587486 | 587486 | 2020-10-01 | Suffolk | Massachusetts | 25025 | 24622 | 1142 |
584246 | 584246 | 2020-09-30 | Suffolk | Massachusetts | 25025 | 24479 | 1137 |
581005 | 581005 | 2020-09-29 | Suffolk | Massachusetts | 25025 | 24426 | 1135 |
577764 | 577764 | 2020-09-28 | Suffolk | Massachusetts | 25025 | 24360 | 1135 |
574523 | 574523 | 2020-09-27 | Suffolk | Massachusetts | 25025 | 24281 | 1135 |
571280 | 571280 | 2020-09-26 | Suffolk | Massachusetts | 25025 | 24177 | 1134 |
568038 | 568038 | 2020-09-25 | Suffolk | Massachusetts | 25025 | 24089 | 1133 |
564798 | 564798 | 2020-09-24 | Suffolk | Massachusetts | 25025 | 23988 | 1132 |
561558 | 561558 | 2020-09-23 | Suffolk | Massachusetts | 25025 | 23891 | 1131 |
558321 | 558321 | 2020-09-22 | Suffolk | Massachusetts | 25025 | 23822 | 1131 |
555084 | 555084 | 2020-09-21 | Suffolk | Massachusetts | 25025 | 23798 | 1131 |
551846 | 551846 | 2020-09-20 | Suffolk | Massachusetts | 25025 | 23741 | 1131 |
548607 | 548607 | 2020-09-19 | Suffolk | Massachusetts | 25025 | 23674 | 1128 |
545369 | 545369 | 2020-09-18 | Suffolk | Massachusetts | 25025 | 23552 | 1124 |
542132 | 542132 | 2020-09-17 | Suffolk | Massachusetts | 25025 | 23464 | 1122 |
538896 | 538896 | 2020-09-16 | Suffolk | Massachusetts | 25025 | 23371 | 1122 |
535659 | 535659 | 2020-09-15 | Suffolk | Massachusetts | 25025 | 23306 | 1120 |
532424 | 532424 | 2020-09-14 | Suffolk | Massachusetts | 25025 | 23236 | 1119 |
529188 | 529188 | 2020-09-13 | Suffolk | Massachusetts | 25025 | 23194 | 1116 |
525952 | 525952 | 2020-09-12 | Suffolk | Massachusetts | 25025 | 23130 | 1116 |
522716 | 522716 | 2020-09-11 | Suffolk | Massachusetts | 25025 | 23028 | 1114 |
519479 | 519479 | 2020-09-10 | Suffolk | Massachusetts | 25025 | 22920 | 1113 |
516244 | 516244 | 2020-09-09 | Suffolk | Massachusetts | 25025 | 22831 | 1111 |
513010 | 513010 | 2020-09-08 | Suffolk | Massachusetts | 25025 | 22788 | 1111 |
509778 | 509778 | 2020-09-07 | Suffolk | Massachusetts | 25025 | 22756 | 1111 |
506545 | 506545 | 2020-09-06 | Suffolk | Massachusetts | 25025 | 22697 | 1110 |
503312 | 503312 | 2020-09-05 | Suffolk | Massachusetts | 25025 | 22623 | 1110 |
500078 | 500078 | 2020-09-04 | Suffolk | Massachusetts | 25025 | 22529 | 1107 |
496844 | 496844 | 2020-09-03 | Suffolk | Massachusetts | 25025 | 22593 | 1106 |
493611 | 493611 | 2020-09-02 | Suffolk | Massachusetts | 25025 | 22508 | 1104 |
490377 | 490377 | 2020-09-01 | Suffolk | Massachusetts | 25025 | 23552 | 1110 |
487144 | 487144 | 2020-08-31 | Suffolk | Massachusetts | 25025 | 23472 | 1109 |
483910 | 483910 | 2020-08-30 | Suffolk | Massachusetts | 25025 | 23403 | 1107 |
480675 | 480675 | 2020-08-29 | Suffolk | Massachusetts | 25025 | 23350 | 1107 |
477443 | 477443 | 2020-08-28 | Suffolk | Massachusetts | 25025 | 23261 | 1106 |
474210 | 474210 | 2020-08-27 | Suffolk | Massachusetts | 25025 | 23154 | 1105 |
470978 | 470978 | 2020-08-26 | Suffolk | Massachusetts | 25025 | 23064 | 1101 |
467748 | 467748 | 2020-08-25 | Suffolk | Massachusetts | 25025 | 22973 | 1097 |
464519 | 464519 | 2020-08-24 | Suffolk | Massachusetts | 25025 | 22904 | 1095 |
461288 | 461288 | 2020-08-23 | Suffolk | Massachusetts | 25025 | 22706 | 1093 |
458061 | 458061 | 2020-08-22 | Suffolk | Massachusetts | 25025 | 22706 | 1093 |
454833 | 454833 | 2020-08-21 | Suffolk | Massachusetts | 25025 | 22694 | 1092 |
451605 | 451605 | 2020-08-20 | Suffolk | Massachusetts | 25025 | 22577 | 1091 |
448377 | 448377 | 2020-08-19 | Suffolk | Massachusetts | 25025 | 22511 | 1090 |
445151 | 445151 | 2020-08-18 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
441925 | 441925 | 2020-08-17 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
438698 | 438698 | 2020-08-16 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
435473 | 435473 | 2020-08-15 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
432247 | 432247 | 2020-08-14 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
429020 | 429020 | 2020-08-13 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
425796 | 425796 | 2020-08-12 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
422574 | 422574 | 2020-08-11 | Suffolk | Massachusetts | 25025 | 22017 | 1076 |
419352 | 419352 | 2020-08-10 | Suffolk | Massachusetts | 25025 | 21929 | 1074 |
416131 | 416131 | 2020-08-09 | Suffolk | Massachusetts | 25025 | 21849 | 1074 |
412911 | 412911 | 2020-08-08 | Suffolk | Massachusetts | 25025 | 21778 | 1073 |
409691 | 409691 | 2020-08-07 | Suffolk | Massachusetts | 25025 | 21717 | 1071 |
406471 | 406471 | 2020-08-06 | Suffolk | Massachusetts | 25025 | 21631 | 1066 |
403253 | 403253 | 2020-08-05 | Suffolk | Massachusetts | 25025 | 21579 | 1063 |
400036 | 400036 | 2020-08-04 | Suffolk | Massachusetts | 25025 | 21481 | 1062 |
396822 | 396822 | 2020-08-03 | Suffolk | Massachusetts | 25025 | 21378 | 1059 |
393606 | 393606 | 2020-08-02 | Suffolk | Massachusetts | 25025 | 21355 | 1058 |
390389 | 390389 | 2020-08-01 | Suffolk | Massachusetts | 25025 | 21279 | 1057 |
387172 | 387172 | 2020-07-31 | Suffolk | Massachusetts | 25025 | 21222 | 1055 |
383954 | 383954 | 2020-07-30 | Suffolk | Massachusetts | 25025 | 21113 | 1055 |
380737 | 380737 | 2020-07-29 | Suffolk | Massachusetts | 25025 | 21030 | 1054 |
377520 | 377520 | 2020-07-28 | Suffolk | Massachusetts | 25025 | 20960 | 1052 |
374305 | 374305 | 2020-07-27 | Suffolk | Massachusetts | 25025 | 20914 | 1048 |
371093 | 371093 | 2020-07-26 | Suffolk | Massachusetts | 25025 | 20896 | 1048 |
367883 | 367883 | 2020-07-25 | Suffolk | Massachusetts | 25025 | 20827 | 1046 |
364676 | 364676 | 2020-07-24 | Suffolk | Massachusetts | 25025 | 20793 | 1044 |
361469 | 361469 | 2020-07-23 | Suffolk | Massachusetts | 25025 | 20732 | 1042 |
358264 | 358264 | 2020-07-22 | Suffolk | Massachusetts | 25025 | 20678 | 1039 |
355061 | 355061 | 2020-07-21 | Suffolk | Massachusetts | 25025 | 20650 | 1039 |
351859 | 351859 | 2020-07-20 | Suffolk | Massachusetts | 25025 | 20621 | 1035 |
348659 | 348659 | 2020-07-19 | Suffolk | Massachusetts | 25025 | 20601 | 1035 |
345458 | 345458 | 2020-07-18 | Suffolk | Massachusetts | 25025 | 20555 | 1035 |
342258 | 342258 | 2020-07-17 | Suffolk | Massachusetts | 25025 | 20499 | 1030 |
339062 | 339062 | 2020-07-16 | Suffolk | Massachusetts | 25025 | 20445 | 1027 |
335866 | 335866 | 2020-07-15 | Suffolk | Massachusetts | 25025 | 20411 | 1024 |
332673 | 332673 | 2020-07-14 | Suffolk | Massachusetts | 25025 | 20386 | 1022 |
329486 | 329486 | 2020-07-13 | Suffolk | Massachusetts | 25025 | 20342 | 1020 |
326300 | 326300 | 2020-07-12 | Suffolk | Massachusetts | 25025 | 20301 | 1020 |
323117 | 323117 | 2020-07-11 | Suffolk | Massachusetts | 25025 | 20272 | 1018 |
319938 | 319938 | 2020-07-10 | Suffolk | Massachusetts | 25025 | 20228 | 1016 |
316763 | 316763 | 2020-07-09 | Suffolk | Massachusetts | 25025 | 20172 | 1013 |
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);