ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 33011 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636669 | 636669 | 2020-10-16 | Hillsborough | New Hampshire | 33011 | 5040 | 310 |
633423 | 633423 | 2020-10-15 | Hillsborough | New Hampshire | 33011 | 4999 | 308 |
630178 | 630178 | 2020-10-14 | Hillsborough | New Hampshire | 33011 | 4971 | 304 |
626934 | 626934 | 2020-10-13 | Hillsborough | New Hampshire | 33011 | 4939 | 303 |
623692 | 623692 | 2020-10-12 | Hillsborough | New Hampshire | 33011 | 4910 | 303 |
620449 | 620449 | 2020-10-11 | Hillsborough | New Hampshire | 33011 | 4887 | 303 |
617207 | 617207 | 2020-10-10 | Hillsborough | New Hampshire | 33011 | 4866 | 302 |
613965 | 613965 | 2020-10-09 | Hillsborough | New Hampshire | 33011 | 4820 | 298 |
610724 | 610724 | 2020-10-08 | Hillsborough | New Hampshire | 33011 | 4775 | 296 |
607482 | 607482 | 2020-10-07 | Hillsborough | New Hampshire | 33011 | 4724 | 296 |
604239 | 604239 | 2020-10-06 | Hillsborough | New Hampshire | 33011 | 4681 | 294 |
600997 | 600997 | 2020-10-05 | Hillsborough | New Hampshire | 33011 | 4656 | 292 |
597753 | 597753 | 2020-10-04 | Hillsborough | New Hampshire | 33011 | 4642 | 292 |
594511 | 594511 | 2020-10-03 | Hillsborough | New Hampshire | 33011 | 4616 | 291 |
591270 | 591270 | 2020-10-02 | Hillsborough | New Hampshire | 33011 | 4579 | 291 |
588029 | 588029 | 2020-10-01 | Hillsborough | New Hampshire | 33011 | 4451 | 291 |
584789 | 584789 | 2020-09-30 | Hillsborough | New Hampshire | 33011 | 4426 | 289 |
581548 | 581548 | 2020-09-29 | Hillsborough | New Hampshire | 33011 | 4408 | 289 |
578307 | 578307 | 2020-09-28 | Hillsborough | New Hampshire | 33011 | 4400 | 289 |
575066 | 575066 | 2020-09-27 | Hillsborough | New Hampshire | 33011 | 4381 | 289 |
571823 | 571823 | 2020-09-26 | Hillsborough | New Hampshire | 33011 | 4366 | 289 |
568581 | 568581 | 2020-09-25 | Hillsborough | New Hampshire | 33011 | 4345 | 288 |
565340 | 565340 | 2020-09-24 | Hillsborough | New Hampshire | 33011 | 4326 | 288 |
562099 | 562099 | 2020-09-23 | Hillsborough | New Hampshire | 33011 | 4310 | 288 |
558862 | 558862 | 2020-09-22 | Hillsborough | New Hampshire | 33011 | 4302 | 288 |
555625 | 555625 | 2020-09-21 | Hillsborough | New Hampshire | 33011 | 4296 | 288 |
552387 | 552387 | 2020-09-20 | Hillsborough | New Hampshire | 33011 | 4294 | 288 |
549148 | 549148 | 2020-09-19 | Hillsborough | New Hampshire | 33011 | 4289 | 288 |
545910 | 545910 | 2020-09-18 | Hillsborough | New Hampshire | 33011 | 4273 | 288 |
542673 | 542673 | 2020-09-17 | Hillsborough | New Hampshire | 33011 | 4234 | 288 |
539437 | 539437 | 2020-09-16 | Hillsborough | New Hampshire | 33011 | 4234 | 288 |
536199 | 536199 | 2020-09-15 | Hillsborough | New Hampshire | 33011 | 4219 | 288 |
532964 | 532964 | 2020-09-14 | Hillsborough | New Hampshire | 33011 | 4207 | 288 |
529728 | 529728 | 2020-09-13 | Hillsborough | New Hampshire | 33011 | 4196 | 288 |
526492 | 526492 | 2020-09-12 | Hillsborough | New Hampshire | 33011 | 4180 | 288 |
523256 | 523256 | 2020-09-11 | Hillsborough | New Hampshire | 33011 | 4171 | 288 |
520019 | 520019 | 2020-09-10 | Hillsborough | New Hampshire | 33011 | 4158 | 288 |
516784 | 516784 | 2020-09-09 | Hillsborough | New Hampshire | 33011 | 4133 | 287 |
513550 | 513550 | 2020-09-08 | Hillsborough | New Hampshire | 33011 | 4121 | 287 |
510317 | 510317 | 2020-09-07 | Hillsborough | New Hampshire | 33011 | 4121 | 287 |
507084 | 507084 | 2020-09-06 | Hillsborough | New Hampshire | 33011 | 4105 | 287 |
503852 | 503852 | 2020-09-05 | Hillsborough | New Hampshire | 33011 | 4095 | 286 |
500618 | 500618 | 2020-09-04 | Hillsborough | New Hampshire | 33011 | 4080 | 286 |
497384 | 497384 | 2020-09-03 | Hillsborough | New Hampshire | 33011 | 4074 | 286 |
494151 | 494151 | 2020-09-02 | Hillsborough | New Hampshire | 33011 | 4052 | 286 |
490917 | 490917 | 2020-09-01 | Hillsborough | New Hampshire | 33011 | 4048 | 286 |
487684 | 487684 | 2020-08-31 | Hillsborough | New Hampshire | 33011 | 4040 | 286 |
484450 | 484450 | 2020-08-30 | Hillsborough | New Hampshire | 33011 | 4027 | 286 |
481215 | 481215 | 2020-08-29 | Hillsborough | New Hampshire | 33011 | 4024 | 286 |
477983 | 477983 | 2020-08-28 | Hillsborough | New Hampshire | 33011 | 4010 | 286 |
474750 | 474750 | 2020-08-27 | Hillsborough | New Hampshire | 33011 | 4001 | 285 |
471517 | 471517 | 2020-08-26 | Hillsborough | New Hampshire | 33011 | 3992 | 285 |
468285 | 468285 | 2020-08-25 | Hillsborough | New Hampshire | 33011 | 3987 | 284 |
465057 | 465057 | 2020-08-24 | Hillsborough | New Hampshire | 33011 | 3983 | 284 |
461826 | 461826 | 2020-08-23 | Hillsborough | New Hampshire | 33011 | 3979 | 284 |
458599 | 458599 | 2020-08-22 | Hillsborough | New Hampshire | 33011 | 3979 | 284 |
455371 | 455371 | 2020-08-21 | Hillsborough | New Hampshire | 33011 | 3972 | 283 |
452143 | 452143 | 2020-08-20 | Hillsborough | New Hampshire | 33011 | 3963 | 283 |
448915 | 448915 | 2020-08-19 | Hillsborough | New Hampshire | 33011 | 3960 | 282 |
445688 | 445688 | 2020-08-18 | Hillsborough | New Hampshire | 33011 | 3948 | 281 |
442462 | 442462 | 2020-08-17 | Hillsborough | New Hampshire | 33011 | 3942 | 281 |
439235 | 439235 | 2020-08-16 | Hillsborough | New Hampshire | 33011 | 3935 | 281 |
436010 | 436010 | 2020-08-15 | Hillsborough | New Hampshire | 33011 | 3931 | 281 |
432784 | 432784 | 2020-08-14 | Hillsborough | New Hampshire | 33011 | 3919 | 281 |
429557 | 429557 | 2020-08-13 | Hillsborough | New Hampshire | 33011 | 3891 | 280 |
426332 | 426332 | 2020-08-12 | Hillsborough | New Hampshire | 33011 | 3872 | 280 |
423110 | 423110 | 2020-08-11 | Hillsborough | New Hampshire | 33011 | 3863 | 279 |
419887 | 419887 | 2020-08-10 | Hillsborough | New Hampshire | 33011 | 3855 | 279 |
416666 | 416666 | 2020-08-09 | Hillsborough | New Hampshire | 33011 | 3850 | 279 |
413445 | 413445 | 2020-08-08 | Hillsborough | New Hampshire | 33011 | 3842 | 279 |
410225 | 410225 | 2020-08-07 | Hillsborough | New Hampshire | 33011 | 3824 | 279 |
407005 | 407005 | 2020-08-06 | Hillsborough | New Hampshire | 33011 | 3807 | 279 |
403786 | 403786 | 2020-08-05 | Hillsborough | New Hampshire | 33011 | 3801 | 279 |
400568 | 400568 | 2020-08-04 | Hillsborough | New Hampshire | 33011 | 3787 | 279 |
397353 | 397353 | 2020-08-03 | Hillsborough | New Hampshire | 33011 | 3775 | 279 |
394137 | 394137 | 2020-08-02 | Hillsborough | New Hampshire | 33011 | 3767 | 279 |
390920 | 390920 | 2020-08-01 | Hillsborough | New Hampshire | 33011 | 3755 | 278 |
387703 | 387703 | 2020-07-31 | Hillsborough | New Hampshire | 33011 | 3743 | 277 |
384486 | 384486 | 2020-07-30 | Hillsborough | New Hampshire | 33011 | 3717 | 277 |
381269 | 381269 | 2020-07-29 | Hillsborough | New Hampshire | 33011 | 3701 | 274 |
378051 | 378051 | 2020-07-28 | Hillsborough | New Hampshire | 33011 | 3692 | 272 |
374836 | 374836 | 2020-07-27 | Hillsborough | New Hampshire | 33011 | 3669 | 272 |
371624 | 371624 | 2020-07-26 | Hillsborough | New Hampshire | 33011 | 3668 | 272 |
368412 | 368412 | 2020-07-25 | Hillsborough | New Hampshire | 33011 | 3655 | 272 |
365203 | 365203 | 2020-07-24 | Hillsborough | New Hampshire | 33011 | 3633 | 271 |
361997 | 361997 | 2020-07-23 | Hillsborough | New Hampshire | 33011 | 3590 | 270 |
358791 | 358791 | 2020-07-22 | Hillsborough | New Hampshire | 33011 | 3575 | 267 |
355587 | 355587 | 2020-07-21 | Hillsborough | New Hampshire | 33011 | 3557 | 267 |
352384 | 352384 | 2020-07-20 | Hillsborough | New Hampshire | 33011 | 3549 | 265 |
349181 | 349181 | 2020-07-19 | Hillsborough | New Hampshire | 33011 | 3510 | 265 |
345980 | 345980 | 2020-07-18 | Hillsborough | New Hampshire | 33011 | 3500 | 264 |
342781 | 342781 | 2020-07-17 | Hillsborough | New Hampshire | 33011 | 3486 | 263 |
339583 | 339583 | 2020-07-16 | Hillsborough | New Hampshire | 33011 | 3468 | 263 |
336387 | 336387 | 2020-07-15 | Hillsborough | New Hampshire | 33011 | 3455 | 263 |
333193 | 333193 | 2020-07-14 | Hillsborough | New Hampshire | 33011 | 3443 | 261 |
330002 | 330002 | 2020-07-13 | Hillsborough | New Hampshire | 33011 | 3433 | 260 |
326815 | 326815 | 2020-07-12 | Hillsborough | New Hampshire | 33011 | 3427 | 260 |
323631 | 323631 | 2020-07-11 | Hillsborough | New Hampshire | 33011 | 3410 | 260 |
320451 | 320451 | 2020-07-10 | Hillsborough | New Hampshire | 33011 | 3391 | 259 |
317275 | 317275 | 2020-07-09 | Hillsborough | New Hampshire | 33011 | 3387 | 257 |
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);