ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Washington" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636881 | 636881 | 2020-10-16 | Washington | North Carolina | 37187 | 236 | 8 |
633635 | 633635 | 2020-10-15 | Washington | North Carolina | 37187 | 232 | 8 |
630390 | 630390 | 2020-10-14 | Washington | North Carolina | 37187 | 229 | 8 |
627146 | 627146 | 2020-10-13 | Washington | North Carolina | 37187 | 228 | 8 |
623904 | 623904 | 2020-10-12 | Washington | North Carolina | 37187 | 227 | 8 |
620661 | 620661 | 2020-10-11 | Washington | North Carolina | 37187 | 227 | 8 |
617419 | 617419 | 2020-10-10 | Washington | North Carolina | 37187 | 227 | 8 |
614177 | 614177 | 2020-10-09 | Washington | North Carolina | 37187 | 224 | 8 |
610936 | 610936 | 2020-10-08 | Washington | North Carolina | 37187 | 222 | 8 |
607694 | 607694 | 2020-10-07 | Washington | North Carolina | 37187 | 221 | 8 |
604451 | 604451 | 2020-10-06 | Washington | North Carolina | 37187 | 220 | 8 |
601209 | 601209 | 2020-10-05 | Washington | North Carolina | 37187 | 219 | 8 |
597966 | 597966 | 2020-10-04 | Washington | North Carolina | 37187 | 219 | 8 |
594723 | 594723 | 2020-10-03 | Washington | North Carolina | 37187 | 218 | 8 |
591482 | 591482 | 2020-10-02 | Washington | North Carolina | 37187 | 217 | 8 |
588241 | 588241 | 2020-10-01 | Washington | North Carolina | 37187 | 214 | 8 |
585001 | 585001 | 2020-09-30 | Washington | North Carolina | 37187 | 212 | 8 |
581760 | 581760 | 2020-09-29 | Washington | North Carolina | 37187 | 209 | 8 |
578520 | 578520 | 2020-09-28 | Washington | North Carolina | 37187 | 208 | 8 |
575279 | 575279 | 2020-09-27 | Washington | North Carolina | 37187 | 208 | 8 |
572035 | 572035 | 2020-09-26 | Washington | North Carolina | 37187 | 208 | 8 |
568793 | 568793 | 2020-09-25 | Washington | North Carolina | 37187 | 209 | 8 |
565552 | 565552 | 2020-09-24 | Washington | North Carolina | 37187 | 202 | 8 |
562311 | 562311 | 2020-09-23 | Washington | North Carolina | 37187 | 201 | 8 |
559074 | 559074 | 2020-09-22 | Washington | North Carolina | 37187 | 200 | 8 |
555837 | 555837 | 2020-09-21 | Washington | North Carolina | 37187 | 200 | 8 |
552600 | 552600 | 2020-09-20 | Washington | North Carolina | 37187 | 200 | 8 |
549361 | 549361 | 2020-09-19 | Washington | North Carolina | 37187 | 200 | 8 |
546122 | 546122 | 2020-09-18 | Washington | North Carolina | 37187 | 199 | 8 |
542885 | 542885 | 2020-09-17 | Washington | North Carolina | 37187 | 198 | 8 |
539649 | 539649 | 2020-09-16 | Washington | North Carolina | 37187 | 197 | 8 |
536412 | 536412 | 2020-09-15 | Washington | North Carolina | 37187 | 196 | 8 |
533176 | 533176 | 2020-09-14 | Washington | North Carolina | 37187 | 195 | 8 |
529941 | 529941 | 2020-09-13 | Washington | North Carolina | 37187 | 195 | 7 |
526704 | 526704 | 2020-09-12 | Washington | North Carolina | 37187 | 194 | 7 |
523468 | 523468 | 2020-09-11 | Washington | North Carolina | 37187 | 193 | 7 |
520232 | 520232 | 2020-09-10 | Washington | North Carolina | 37187 | 192 | 7 |
516996 | 516996 | 2020-09-09 | Washington | North Carolina | 37187 | 190 | 6 |
513761 | 513761 | 2020-09-08 | Washington | North Carolina | 37187 | 190 | 6 |
510528 | 510528 | 2020-09-07 | Washington | North Carolina | 37187 | 188 | 6 |
507295 | 507295 | 2020-09-06 | Washington | North Carolina | 37187 | 188 | 6 |
504063 | 504063 | 2020-09-05 | Washington | North Carolina | 37187 | 186 | 6 |
500829 | 500829 | 2020-09-04 | Washington | North Carolina | 37187 | 184 | 6 |
497595 | 497595 | 2020-09-03 | Washington | North Carolina | 37187 | 181 | 6 |
494362 | 494362 | 2020-09-02 | Washington | North Carolina | 37187 | 179 | 6 |
491128 | 491128 | 2020-09-01 | Washington | North Carolina | 37187 | 180 | 6 |
487895 | 487895 | 2020-08-31 | Washington | North Carolina | 37187 | 177 | 6 |
484662 | 484662 | 2020-08-30 | Washington | North Carolina | 37187 | 175 | 5 |
481427 | 481427 | 2020-08-29 | Washington | North Carolina | 37187 | 173 | 4 |
478194 | 478194 | 2020-08-28 | Washington | North Carolina | 37187 | 172 | 4 |
474961 | 474961 | 2020-08-27 | Washington | North Carolina | 37187 | 170 | 4 |
471727 | 471727 | 2020-08-26 | Washington | North Carolina | 37187 | 169 | 4 |
468495 | 468495 | 2020-08-25 | Washington | North Carolina | 37187 | 168 | 4 |
465267 | 465267 | 2020-08-24 | Washington | North Carolina | 37187 | 168 | 4 |
462038 | 462038 | 2020-08-23 | Washington | North Carolina | 37187 | 160 | 4 |
458810 | 458810 | 2020-08-22 | Washington | North Carolina | 37187 | 159 | 4 |
455582 | 455582 | 2020-08-21 | Washington | North Carolina | 37187 | 156 | 4 |
452354 | 452354 | 2020-08-20 | Washington | North Carolina | 37187 | 155 | 4 |
449126 | 449126 | 2020-08-19 | Washington | North Carolina | 37187 | 153 | 4 |
445898 | 445898 | 2020-08-18 | Washington | North Carolina | 37187 | 146 | 4 |
442672 | 442672 | 2020-08-17 | Washington | North Carolina | 37187 | 144 | 4 |
439445 | 439445 | 2020-08-16 | Washington | North Carolina | 37187 | 142 | 4 |
436220 | 436220 | 2020-08-15 | Washington | North Carolina | 37187 | 140 | 4 |
432994 | 432994 | 2020-08-14 | Washington | North Carolina | 37187 | 137 | 4 |
429768 | 429768 | 2020-08-13 | Washington | North Carolina | 37187 | 136 | 4 |
426543 | 426543 | 2020-08-12 | Washington | North Carolina | 37187 | 136 | 4 |
423320 | 423320 | 2020-08-11 | Washington | North Carolina | 37187 | 133 | 4 |
420097 | 420097 | 2020-08-10 | Washington | North Carolina | 37187 | 133 | 4 |
416877 | 416877 | 2020-08-09 | Washington | North Carolina | 37187 | 133 | 4 |
413656 | 413656 | 2020-08-08 | Washington | North Carolina | 37187 | 132 | 4 |
410436 | 410436 | 2020-08-07 | Washington | North Carolina | 37187 | 128 | 4 |
407216 | 407216 | 2020-08-06 | Washington | North Carolina | 37187 | 127 | 4 |
403997 | 403997 | 2020-08-05 | Washington | North Carolina | 37187 | 124 | 4 |
400779 | 400779 | 2020-08-04 | Washington | North Carolina | 37187 | 121 | 4 |
397564 | 397564 | 2020-08-03 | Washington | North Carolina | 37187 | 121 | 3 |
394347 | 394347 | 2020-08-02 | Washington | North Carolina | 37187 | 120 | 3 |
391131 | 391131 | 2020-08-01 | Washington | North Carolina | 37187 | 118 | 3 |
387914 | 387914 | 2020-07-31 | Washington | North Carolina | 37187 | 114 | 3 |
384697 | 384697 | 2020-07-30 | Washington | North Carolina | 37187 | 113 | 3 |
381479 | 381479 | 2020-07-29 | Washington | North Carolina | 37187 | 110 | 3 |
378262 | 378262 | 2020-07-28 | Washington | North Carolina | 37187 | 106 | 3 |
375046 | 375046 | 2020-07-27 | Washington | North Carolina | 37187 | 103 | 3 |
371834 | 371834 | 2020-07-26 | Washington | North Carolina | 37187 | 100 | 3 |
368622 | 368622 | 2020-07-25 | Washington | North Carolina | 37187 | 97 | 3 |
365413 | 365413 | 2020-07-24 | Washington | North Carolina | 37187 | 96 | 3 |
362207 | 362207 | 2020-07-23 | Washington | North Carolina | 37187 | 94 | 3 |
359001 | 359001 | 2020-07-22 | Washington | North Carolina | 37187 | 89 | 3 |
355797 | 355797 | 2020-07-21 | Washington | North Carolina | 37187 | 80 | 3 |
352594 | 352594 | 2020-07-20 | Washington | North Carolina | 37187 | 75 | 3 |
349391 | 349391 | 2020-07-19 | Washington | North Carolina | 37187 | 67 | 3 |
346190 | 346190 | 2020-07-18 | Washington | North Carolina | 37187 | 62 | 3 |
342991 | 342991 | 2020-07-17 | Washington | North Carolina | 37187 | 60 | 3 |
339793 | 339793 | 2020-07-16 | Washington | North Carolina | 37187 | 57 | 3 |
336597 | 336597 | 2020-07-15 | Washington | North Carolina | 37187 | 54 | 3 |
333403 | 333403 | 2020-07-14 | Washington | North Carolina | 37187 | 54 | 3 |
330213 | 330213 | 2020-07-13 | Washington | North Carolina | 37187 | 51 | 3 |
327026 | 327026 | 2020-07-12 | Washington | North Carolina | 37187 | 50 | 3 |
323842 | 323842 | 2020-07-11 | Washington | North Carolina | 37187 | 46 | 3 |
320662 | 320662 | 2020-07-10 | Washington | North Carolina | 37187 | 42 | 3 |
317485 | 317485 | 2020-07-09 | Washington | North Carolina | 37187 | 41 | 3 |
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);