ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where deaths = 13 and fips = 33017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
626937 | 626937 | 2020-10-13 | Strafford | New Hampshire | 33017 | 630 | 13 |
623695 | 623695 | 2020-10-12 | Strafford | New Hampshire | 33017 | 622 | 13 |
620452 | 620452 | 2020-10-11 | Strafford | New Hampshire | 33017 | 618 | 13 |
617210 | 617210 | 2020-10-10 | Strafford | New Hampshire | 33017 | 608 | 13 |
613968 | 613968 | 2020-10-09 | Strafford | New Hampshire | 33017 | 603 | 13 |
610727 | 610727 | 2020-10-08 | Strafford | New Hampshire | 33017 | 603 | 13 |
607485 | 607485 | 2020-10-07 | Strafford | New Hampshire | 33017 | 600 | 13 |
604242 | 604242 | 2020-10-06 | Strafford | New Hampshire | 33017 | 598 | 13 |
601000 | 601000 | 2020-10-05 | Strafford | New Hampshire | 33017 | 592 | 13 |
597756 | 597756 | 2020-10-04 | Strafford | New Hampshire | 33017 | 587 | 13 |
594514 | 594514 | 2020-10-03 | Strafford | New Hampshire | 33017 | 581 | 13 |
591273 | 591273 | 2020-10-02 | Strafford | New Hampshire | 33017 | 579 | 13 |
588032 | 588032 | 2020-10-01 | Strafford | New Hampshire | 33017 | 567 | 13 |
584792 | 584792 | 2020-09-30 | Strafford | New Hampshire | 33017 | 562 | 13 |
581551 | 581551 | 2020-09-29 | Strafford | New Hampshire | 33017 | 557 | 13 |
578310 | 578310 | 2020-09-28 | Strafford | New Hampshire | 33017 | 552 | 13 |
575069 | 575069 | 2020-09-27 | Strafford | New Hampshire | 33017 | 551 | 13 |
571826 | 571826 | 2020-09-26 | Strafford | New Hampshire | 33017 | 542 | 13 |
568584 | 568584 | 2020-09-25 | Strafford | New Hampshire | 33017 | 538 | 13 |
565343 | 565343 | 2020-09-24 | Strafford | New Hampshire | 33017 | 526 | 13 |
562102 | 562102 | 2020-09-23 | Strafford | New Hampshire | 33017 | 515 | 13 |
558865 | 558865 | 2020-09-22 | Strafford | New Hampshire | 33017 | 513 | 13 |
555628 | 555628 | 2020-09-21 | Strafford | New Hampshire | 33017 | 503 | 13 |
552390 | 552390 | 2020-09-20 | Strafford | New Hampshire | 33017 | 502 | 13 |
549151 | 549151 | 2020-09-19 | Strafford | New Hampshire | 33017 | 493 | 13 |
545913 | 545913 | 2020-09-18 | Strafford | New Hampshire | 33017 | 481 | 13 |
542676 | 542676 | 2020-09-17 | Strafford | New Hampshire | 33017 | 470 | 13 |
539440 | 539440 | 2020-09-16 | Strafford | New Hampshire | 33017 | 470 | 13 |
536202 | 536202 | 2020-09-15 | Strafford | New Hampshire | 33017 | 463 | 13 |
532967 | 532967 | 2020-09-14 | Strafford | New Hampshire | 33017 | 458 | 13 |
529731 | 529731 | 2020-09-13 | Strafford | New Hampshire | 33017 | 457 | 13 |
526495 | 526495 | 2020-09-12 | Strafford | New Hampshire | 33017 | 453 | 13 |
523259 | 523259 | 2020-09-11 | Strafford | New Hampshire | 33017 | 446 | 13 |
520022 | 520022 | 2020-09-10 | Strafford | New Hampshire | 33017 | 439 | 13 |
516787 | 516787 | 2020-09-09 | Strafford | New Hampshire | 33017 | 429 | 13 |
513553 | 513553 | 2020-09-08 | Strafford | New Hampshire | 33017 | 427 | 13 |
510320 | 510320 | 2020-09-07 | Strafford | New Hampshire | 33017 | 426 | 13 |
507087 | 507087 | 2020-09-06 | Strafford | New Hampshire | 33017 | 418 | 13 |
503855 | 503855 | 2020-09-05 | Strafford | New Hampshire | 33017 | 415 | 13 |
500621 | 500621 | 2020-09-04 | Strafford | New Hampshire | 33017 | 400 | 13 |
497387 | 497387 | 2020-09-03 | Strafford | New Hampshire | 33017 | 395 | 13 |
494154 | 494154 | 2020-09-02 | Strafford | New Hampshire | 33017 | 391 | 13 |
490920 | 490920 | 2020-09-01 | Strafford | New Hampshire | 33017 | 390 | 13 |
487687 | 487687 | 2020-08-31 | Strafford | New Hampshire | 33017 | 383 | 13 |
484453 | 484453 | 2020-08-30 | Strafford | New Hampshire | 33017 | 383 | 13 |
481218 | 481218 | 2020-08-29 | Strafford | New Hampshire | 33017 | 382 | 13 |
477986 | 477986 | 2020-08-28 | Strafford | New Hampshire | 33017 | 382 | 13 |
474753 | 474753 | 2020-08-27 | Strafford | New Hampshire | 33017 | 379 | 13 |
471520 | 471520 | 2020-08-26 | Strafford | New Hampshire | 33017 | 377 | 13 |
468288 | 468288 | 2020-08-25 | Strafford | New Hampshire | 33017 | 378 | 13 |
465060 | 465060 | 2020-08-24 | Strafford | New Hampshire | 33017 | 376 | 13 |
461829 | 461829 | 2020-08-23 | Strafford | New Hampshire | 33017 | 372 | 13 |
458602 | 458602 | 2020-08-22 | Strafford | New Hampshire | 33017 | 371 | 13 |
455374 | 455374 | 2020-08-21 | Strafford | New Hampshire | 33017 | 370 | 13 |
452146 | 452146 | 2020-08-20 | Strafford | New Hampshire | 33017 | 368 | 13 |
448918 | 448918 | 2020-08-19 | Strafford | New Hampshire | 33017 | 367 | 13 |
445691 | 445691 | 2020-08-18 | Strafford | New Hampshire | 33017 | 367 | 13 |
442465 | 442465 | 2020-08-17 | Strafford | New Hampshire | 33017 | 367 | 13 |
439238 | 439238 | 2020-08-16 | Strafford | New Hampshire | 33017 | 367 | 13 |
436013 | 436013 | 2020-08-15 | Strafford | New Hampshire | 33017 | 367 | 13 |
432787 | 432787 | 2020-08-14 | Strafford | New Hampshire | 33017 | 366 | 13 |
429560 | 429560 | 2020-08-13 | Strafford | New Hampshire | 33017 | 363 | 13 |
426335 | 426335 | 2020-08-12 | Strafford | New Hampshire | 33017 | 363 | 13 |
423113 | 423113 | 2020-08-11 | Strafford | New Hampshire | 33017 | 362 | 13 |
419890 | 419890 | 2020-08-10 | Strafford | New Hampshire | 33017 | 360 | 13 |
416669 | 416669 | 2020-08-09 | Strafford | New Hampshire | 33017 | 358 | 13 |
413448 | 413448 | 2020-08-08 | Strafford | New Hampshire | 33017 | 353 | 13 |
410228 | 410228 | 2020-08-07 | Strafford | New Hampshire | 33017 | 348 | 13 |
407008 | 407008 | 2020-08-06 | Strafford | New Hampshire | 33017 | 346 | 13 |
403789 | 403789 | 2020-08-05 | Strafford | New Hampshire | 33017 | 338 | 13 |
400571 | 400571 | 2020-08-04 | Strafford | New Hampshire | 33017 | 338 | 13 |
397356 | 397356 | 2020-08-03 | Strafford | New Hampshire | 33017 | 335 | 13 |
394140 | 394140 | 2020-08-02 | Strafford | New Hampshire | 33017 | 330 | 13 |
390923 | 390923 | 2020-08-01 | Strafford | New Hampshire | 33017 | 328 | 13 |
387706 | 387706 | 2020-07-31 | Strafford | New Hampshire | 33017 | 325 | 13 |
384489 | 384489 | 2020-07-30 | Strafford | New Hampshire | 33017 | 323 | 13 |
381272 | 381272 | 2020-07-29 | Strafford | New Hampshire | 33017 | 323 | 13 |
378054 | 378054 | 2020-07-28 | Strafford | New Hampshire | 33017 | 322 | 13 |
374839 | 374839 | 2020-07-27 | Strafford | New Hampshire | 33017 | 320 | 13 |
371627 | 371627 | 2020-07-26 | Strafford | New Hampshire | 33017 | 319 | 13 |
368415 | 368415 | 2020-07-25 | Strafford | New Hampshire | 33017 | 316 | 13 |
365206 | 365206 | 2020-07-24 | Strafford | New Hampshire | 33017 | 311 | 13 |
362000 | 362000 | 2020-07-23 | Strafford | New Hampshire | 33017 | 310 | 13 |
358794 | 358794 | 2020-07-22 | Strafford | New Hampshire | 33017 | 310 | 13 |
355590 | 355590 | 2020-07-21 | Strafford | New Hampshire | 33017 | 307 | 13 |
352387 | 352387 | 2020-07-20 | Strafford | New Hampshire | 33017 | 306 | 13 |
349184 | 349184 | 2020-07-19 | Strafford | New Hampshire | 33017 | 306 | 13 |
345983 | 345983 | 2020-07-18 | Strafford | New Hampshire | 33017 | 306 | 13 |
342784 | 342784 | 2020-07-17 | Strafford | New Hampshire | 33017 | 307 | 13 |
339586 | 339586 | 2020-07-16 | Strafford | New Hampshire | 33017 | 307 | 13 |
336390 | 336390 | 2020-07-15 | Strafford | New Hampshire | 33017 | 306 | 13 |
333196 | 333196 | 2020-07-14 | Strafford | New Hampshire | 33017 | 306 | 13 |
330005 | 330005 | 2020-07-13 | Strafford | New Hampshire | 33017 | 301 | 13 |
326818 | 326818 | 2020-07-12 | Strafford | New Hampshire | 33017 | 301 | 13 |
323634 | 323634 | 2020-07-11 | Strafford | New Hampshire | 33017 | 299 | 13 |
320454 | 320454 | 2020-07-10 | Strafford | New Hampshire | 33017 | 298 | 13 |
317278 | 317278 | 2020-07-09 | Strafford | New Hampshire | 33017 | 297 | 13 |
314104 | 314104 | 2020-07-08 | Strafford | New Hampshire | 33017 | 296 | 13 |
310933 | 310933 | 2020-07-07 | Strafford | New Hampshire | 33017 | 295 | 13 |
307765 | 307765 | 2020-07-06 | Strafford | New Hampshire | 33017 | 296 | 13 |
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);