ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

139 rows where fips = 53033 sorted by date descending

View and edit SQL

state

fips

  • 53033 · 139

county

Link rowid date ▲ county state fips cases deaths
337396 2020-07-15 King Washington 53033 12355 651
334203 2020-07-14 King Washington 53033 12246 645
331012 2020-07-13 King Washington 53033 12101 639
327828 2020-07-12 King Washington 53033 11947 639
324644 2020-07-11 King Washington 53033 11773 635
321465 2020-07-10 King Washington 53033 11634 635
318288 2020-07-09 King Washington 53033 11488 634
315117 2020-07-08 King Washington 53033 11321 630
311944 2020-07-07 King Washington 53033 11208 628
308777 2020-07-06 King Washington 53033 11142 624
305611 2020-07-05 King Washington 53033 11016 622
302449 2020-07-04 King Washington 53033 10786 621
299287 2020-07-03 King Washington 53033 10721 620
296127 2020-07-02 King Washington 53033 10598 617
292974 2020-07-01 King Washington 53033 10358 614
289823 2020-06-30 King Washington 53033 10198 612
286674 2020-06-29 King Washington 53033 10071 612
283529 2020-06-28 King Washington 53033 9903 612
280384 2020-06-27 King Washington 53033 9821 612
277238 2020-06-26 King Washington 53033 9697 609
274092 2020-06-25 King Washington 53033 9614 608
270954 2020-06-24 King Washington 53033 9504 606
267822 2020-06-23 King Washington 53033 9371 606
264694 2020-06-22 King Washington 53033 9275 604
261567 2020-06-21 King Washington 53033 9236 602
258442 2020-06-20 King Washington 53033 9167 603
255317 2020-06-19 King Washington 53033 9098 602
252200 2020-06-18 King Washington 53033 8989 599
249087 2020-06-17 King Washington 53033 8895 593
245977 2020-06-16 King Washington 53033 8857 597
242866 2020-06-15 King Washington 53033 8799 594
239757 2020-06-14 King Washington 53033 8753 593
236651 2020-06-13 King Washington 53033 8702 593
233546 2020-06-12 King Washington 53033 8646 588
230442 2020-06-11 King Washington 53033 8586 585
227340 2020-06-10 King Washington 53033 8561 582
224241 2020-06-09 King Washington 53033 8538 582
221147 2020-06-08 King Washington 53033 8509 581
218057 2020-06-07 King Washington 53033 8467 580
214969 2020-06-06 King Washington 53033 8419 578
211884 2020-06-05 King Washington 53033 8398 578
208801 2020-06-04 King Washington 53033 8335 576
205722 2020-06-03 King Washington 53033 8279 575
202646 2020-06-02 King Washington 53033 8237 572
199573 2020-06-01 King Washington 53033 8194 571
196503 2020-05-31 King Washington 53033 8161 569
193436 2020-05-30 King Washington 53033 8056 569
190373 2020-05-29 King Washington 53033 8008 566
187312 2020-05-28 King Washington 53033 7988 564
184258 2020-05-27 King Washington 53033 7933 561
181210 2020-05-26 King Washington 53033 7898 554
178169 2020-05-25 King Washington 53033 7881 552
175127 2020-05-24 King Washington 53033 7821 549
172087 2020-05-23 King Washington 53033 7766 544
169049 2020-05-22 King Washington 53033 7699 544
166016 2020-05-21 King Washington 53033 7647 541
162990 2020-05-20 King Washington 53033 7619 536
159965 2020-05-19 King Washington 53033 7584 536
156944 2020-05-18 King Washington 53033 7531 530
153930 2020-05-17 King Washington 53033 7482 529
150922 2020-05-16 King Washington 53033 7442 528
147916 2020-05-15 King Washington 53033 7362 523
144916 2020-05-14 King Washington 53033 7309 516
141922 2020-05-13 King Washington 53033 7223 516
138929 2020-05-12 King Washington 53033 7181 513
135941 2020-05-11 King Washington 53033 7117 507
132954 2020-05-10 King Washington 53033 7048 502
129967 2020-05-09 King Washington 53033 7002 492
126980 2020-05-08 King Washington 53033 6942 487
123998 2020-05-07 King Washington 53033 6865 482
121021 2020-05-06 King Washington 53033 6772 476
118061 2020-05-05 King Washington 53033 6655 471
115106 2020-05-04 King Washington 53033 6584 465
112227 2020-05-03 King Washington 53033 6620 461
109357 2020-05-02 King Washington 53033 6507 456
106492 2020-05-01 King Washington 53033 6409 451
103632 2020-04-30 King Washington 53033 6310 448
100781 2020-04-29 King Washington 53033 6184 438
97935 2020-04-28 King Washington 53033 6056 429
95094 2020-04-27 King Washington 53033 5992 418
92268 2020-04-26 King Washington 53033 5914 410
89454 2020-04-25 King Washington 53033 5813 401
86642 2020-04-24 King Washington 53033 5691 393
83838 2020-04-23 King Washington 53033 5571 386
81040 2020-04-22 King Washington 53033 5451 381
78250 2020-04-21 King Washington 53033 5381 374
75470 2020-04-20 King Washington 53033 5295 362
72697 2020-04-19 King Washington 53033 5174 348
69930 2020-04-18 King Washington 53033 5065 342
67171 2020-04-17 King Washington 53033 4904 333
64426 2020-04-16 King Washington 53033 4811 322
61696 2020-04-15 King Washington 53033 4699 314
58980 2020-04-14 King Washington 53033 4622 305
56277 2020-04-13 King Washington 53033 4551 298
53590 2020-04-12 King Washington 53033 4428 294
50918 2020-04-11 King Washington 53033 4264 286
48263 2020-04-10 King Washington 53033 4119 279
45639 2020-04-09 King Washington 53033 3888 260
43046 2020-04-08 King Washington 53033 3690 246
40480 2020-04-07 King Washington 53033 3488 232

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1507.565ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette