ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37139 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 |
---|---|---|---|---|---|---|---|
633611 | 633611 | 2020-10-15 | Pasquotank | North Carolina | 37139 | 801 | 33 |
630366 | 630366 | 2020-10-14 | Pasquotank | North Carolina | 37139 | 797 | 33 |
627122 | 627122 | 2020-10-13 | Pasquotank | North Carolina | 37139 | 795 | 33 |
623880 | 623880 | 2020-10-12 | Pasquotank | North Carolina | 37139 | 794 | 33 |
620637 | 620637 | 2020-10-11 | Pasquotank | North Carolina | 37139 | 790 | 33 |
617395 | 617395 | 2020-10-10 | Pasquotank | North Carolina | 37139 | 784 | 33 |
614153 | 614153 | 2020-10-09 | Pasquotank | North Carolina | 37139 | 783 | 33 |
610912 | 610912 | 2020-10-08 | Pasquotank | North Carolina | 37139 | 768 | 33 |
607670 | 607670 | 2020-10-07 | Pasquotank | North Carolina | 37139 | 757 | 33 |
604427 | 604427 | 2020-10-06 | Pasquotank | North Carolina | 37139 | 753 | 33 |
601185 | 601185 | 2020-10-05 | Pasquotank | North Carolina | 37139 | 746 | 33 |
597942 | 597942 | 2020-10-04 | Pasquotank | North Carolina | 37139 | 731 | 33 |
594699 | 594699 | 2020-10-03 | Pasquotank | North Carolina | 37139 | 726 | 33 |
591458 | 591458 | 2020-10-02 | Pasquotank | North Carolina | 37139 | 724 | 31 |
588217 | 588217 | 2020-10-01 | Pasquotank | North Carolina | 37139 | 717 | 31 |
584977 | 584977 | 2020-09-30 | Pasquotank | North Carolina | 37139 | 711 | 31 |
581736 | 581736 | 2020-09-29 | Pasquotank | North Carolina | 37139 | 709 | 31 |
578496 | 578496 | 2020-09-28 | Pasquotank | North Carolina | 37139 | 710 | 30 |
575255 | 575255 | 2020-09-27 | Pasquotank | North Carolina | 37139 | 707 | 30 |
572011 | 572011 | 2020-09-26 | Pasquotank | North Carolina | 37139 | 700 | 30 |
568769 | 568769 | 2020-09-25 | Pasquotank | North Carolina | 37139 | 695 | 30 |
565528 | 565528 | 2020-09-24 | Pasquotank | North Carolina | 37139 | 692 | 30 |
562287 | 562287 | 2020-09-23 | Pasquotank | North Carolina | 37139 | 688 | 30 |
559050 | 559050 | 2020-09-22 | Pasquotank | North Carolina | 37139 | 683 | 29 |
555813 | 555813 | 2020-09-21 | Pasquotank | North Carolina | 37139 | 677 | 29 |
552576 | 552576 | 2020-09-20 | Pasquotank | North Carolina | 37139 | 677 | 29 |
549337 | 549337 | 2020-09-19 | Pasquotank | North Carolina | 37139 | 658 | 29 |
546098 | 546098 | 2020-09-18 | Pasquotank | North Carolina | 37139 | 647 | 29 |
542861 | 542861 | 2020-09-17 | Pasquotank | North Carolina | 37139 | 638 | 29 |
539625 | 539625 | 2020-09-16 | Pasquotank | North Carolina | 37139 | 631 | 29 |
536388 | 536388 | 2020-09-15 | Pasquotank | North Carolina | 37139 | 631 | 26 |
533152 | 533152 | 2020-09-14 | Pasquotank | North Carolina | 37139 | 630 | 26 |
529917 | 529917 | 2020-09-13 | Pasquotank | North Carolina | 37139 | 627 | 26 |
526680 | 526680 | 2020-09-12 | Pasquotank | North Carolina | 37139 | 622 | 26 |
523444 | 523444 | 2020-09-11 | Pasquotank | North Carolina | 37139 | 618 | 26 |
520208 | 520208 | 2020-09-10 | Pasquotank | North Carolina | 37139 | 612 | 26 |
516972 | 516972 | 2020-09-09 | Pasquotank | North Carolina | 37139 | 606 | 26 |
513737 | 513737 | 2020-09-08 | Pasquotank | North Carolina | 37139 | 602 | 26 |
510504 | 510504 | 2020-09-07 | Pasquotank | North Carolina | 37139 | 602 | 26 |
507271 | 507271 | 2020-09-06 | Pasquotank | North Carolina | 37139 | 600 | 26 |
504039 | 504039 | 2020-09-05 | Pasquotank | North Carolina | 37139 | 593 | 26 |
500805 | 500805 | 2020-09-04 | Pasquotank | North Carolina | 37139 | 587 | 25 |
497571 | 497571 | 2020-09-03 | Pasquotank | North Carolina | 37139 | 580 | 23 |
494338 | 494338 | 2020-09-02 | Pasquotank | North Carolina | 37139 | 572 | 23 |
491104 | 491104 | 2020-09-01 | Pasquotank | North Carolina | 37139 | 564 | 23 |
487871 | 487871 | 2020-08-31 | Pasquotank | North Carolina | 37139 | 548 | 23 |
484638 | 484638 | 2020-08-30 | Pasquotank | North Carolina | 37139 | 546 | 23 |
481403 | 481403 | 2020-08-29 | Pasquotank | North Carolina | 37139 | 544 | 23 |
478170 | 478170 | 2020-08-28 | Pasquotank | North Carolina | 37139 | 532 | 23 |
474937 | 474937 | 2020-08-27 | Pasquotank | North Carolina | 37139 | 523 | 23 |
471703 | 471703 | 2020-08-26 | Pasquotank | North Carolina | 37139 | 515 | 23 |
468471 | 468471 | 2020-08-25 | Pasquotank | North Carolina | 37139 | 512 | 22 |
465243 | 465243 | 2020-08-24 | Pasquotank | North Carolina | 37139 | 513 | 22 |
462014 | 462014 | 2020-08-23 | Pasquotank | North Carolina | 37139 | 507 | 22 |
458786 | 458786 | 2020-08-22 | Pasquotank | North Carolina | 37139 | 504 | 22 |
455558 | 455558 | 2020-08-21 | Pasquotank | North Carolina | 37139 | 483 | 21 |
452330 | 452330 | 2020-08-20 | Pasquotank | North Carolina | 37139 | 468 | 21 |
449102 | 449102 | 2020-08-19 | Pasquotank | North Carolina | 37139 | 464 | 21 |
445874 | 445874 | 2020-08-18 | Pasquotank | North Carolina | 37139 | 458 | 21 |
442648 | 442648 | 2020-08-17 | Pasquotank | North Carolina | 37139 | 456 | 20 |
439421 | 439421 | 2020-08-16 | Pasquotank | North Carolina | 37139 | 447 | 20 |
436196 | 436196 | 2020-08-15 | Pasquotank | North Carolina | 37139 | 443 | 20 |
432970 | 432970 | 2020-08-14 | Pasquotank | North Carolina | 37139 | 436 | 20 |
429744 | 429744 | 2020-08-13 | Pasquotank | North Carolina | 37139 | 430 | 20 |
426519 | 426519 | 2020-08-12 | Pasquotank | North Carolina | 37139 | 423 | 20 |
423296 | 423296 | 2020-08-11 | Pasquotank | North Carolina | 37139 | 423 | 20 |
420073 | 420073 | 2020-08-10 | Pasquotank | North Carolina | 37139 | 402 | 20 |
416853 | 416853 | 2020-08-09 | Pasquotank | North Carolina | 37139 | 401 | 20 |
413632 | 413632 | 2020-08-08 | Pasquotank | North Carolina | 37139 | 395 | 20 |
410412 | 410412 | 2020-08-07 | Pasquotank | North Carolina | 37139 | 388 | 19 |
407192 | 407192 | 2020-08-06 | Pasquotank | North Carolina | 37139 | 371 | 19 |
403973 | 403973 | 2020-08-05 | Pasquotank | North Carolina | 37139 | 360 | 17 |
400755 | 400755 | 2020-08-04 | Pasquotank | North Carolina | 37139 | 360 | 17 |
397540 | 397540 | 2020-08-03 | Pasquotank | North Carolina | 37139 | 359 | 17 |
394323 | 394323 | 2020-08-02 | Pasquotank | North Carolina | 37139 | 351 | 17 |
391107 | 391107 | 2020-08-01 | Pasquotank | North Carolina | 37139 | 351 | 17 |
387890 | 387890 | 2020-07-31 | Pasquotank | North Carolina | 37139 | 346 | 17 |
384673 | 384673 | 2020-07-30 | Pasquotank | North Carolina | 37139 | 336 | 17 |
381455 | 381455 | 2020-07-29 | Pasquotank | North Carolina | 37139 | 314 | 17 |
378238 | 378238 | 2020-07-28 | Pasquotank | North Carolina | 37139 | 311 | 17 |
375022 | 375022 | 2020-07-27 | Pasquotank | North Carolina | 37139 | 305 | 17 |
371810 | 371810 | 2020-07-26 | Pasquotank | North Carolina | 37139 | 298 | 17 |
368598 | 368598 | 2020-07-25 | Pasquotank | North Carolina | 37139 | 295 | 17 |
365389 | 365389 | 2020-07-24 | Pasquotank | North Carolina | 37139 | 288 | 17 |
362183 | 362183 | 2020-07-23 | Pasquotank | North Carolina | 37139 | 281 | 17 |
358977 | 358977 | 2020-07-22 | Pasquotank | North Carolina | 37139 | 278 | 17 |
355773 | 355773 | 2020-07-21 | Pasquotank | North Carolina | 37139 | 271 | 17 |
352570 | 352570 | 2020-07-20 | Pasquotank | North Carolina | 37139 | 267 | 17 |
349367 | 349367 | 2020-07-19 | Pasquotank | North Carolina | 37139 | 267 | 17 |
346166 | 346166 | 2020-07-18 | Pasquotank | North Carolina | 37139 | 267 | 17 |
342967 | 342967 | 2020-07-17 | Pasquotank | North Carolina | 37139 | 262 | 17 |
339769 | 339769 | 2020-07-16 | Pasquotank | North Carolina | 37139 | 262 | 17 |
336573 | 336573 | 2020-07-15 | Pasquotank | North Carolina | 37139 | 258 | 17 |
333379 | 333379 | 2020-07-14 | Pasquotank | North Carolina | 37139 | 255 | 17 |
330189 | 330189 | 2020-07-13 | Pasquotank | North Carolina | 37139 | 244 | 17 |
327002 | 327002 | 2020-07-12 | Pasquotank | North Carolina | 37139 | 243 | 17 |
323818 | 323818 | 2020-07-11 | Pasquotank | North Carolina | 37139 | 242 | 17 |
320638 | 320638 | 2020-07-10 | Pasquotank | North Carolina | 37139 | 234 | 17 |
317461 | 317461 | 2020-07-09 | Pasquotank | North Carolina | 37139 | 233 | 17 |
314287 | 314287 | 2020-07-08 | Pasquotank | North Carolina | 37139 | 233 | 17 |
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);