ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Montgomery" and state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
295287 | 295287 | 2020-07-02 | Montgomery | North Carolina | 37123 | 321 | 7 |
298447 | 298447 | 2020-07-03 | Montgomery | North Carolina | 37123 | 334 | 7 |
301610 | 301610 | 2020-07-04 | Montgomery | North Carolina | 37123 | 337 | 7 |
304773 | 304773 | 2020-07-05 | Montgomery | North Carolina | 37123 | 343 | 7 |
307940 | 307940 | 2020-07-06 | Montgomery | North Carolina | 37123 | 347 | 7 |
311108 | 311108 | 2020-07-07 | Montgomery | North Carolina | 37123 | 358 | 9 |
314279 | 314279 | 2020-07-08 | Montgomery | North Carolina | 37123 | 362 | 9 |
317453 | 317453 | 2020-07-09 | Montgomery | North Carolina | 37123 | 368 | 9 |
320630 | 320630 | 2020-07-10 | Montgomery | North Carolina | 37123 | 376 | 9 |
323810 | 323810 | 2020-07-11 | Montgomery | North Carolina | 37123 | 392 | 9 |
326994 | 326994 | 2020-07-12 | Montgomery | North Carolina | 37123 | 399 | 9 |
330181 | 330181 | 2020-07-13 | Montgomery | North Carolina | 37123 | 402 | 9 |
333371 | 333371 | 2020-07-14 | Montgomery | North Carolina | 37123 | 408 | 9 |
336565 | 336565 | 2020-07-15 | Montgomery | North Carolina | 37123 | 417 | 9 |
339761 | 339761 | 2020-07-16 | Montgomery | North Carolina | 37123 | 420 | 10 |
342959 | 342959 | 2020-07-17 | Montgomery | North Carolina | 37123 | 430 | 10 |
346158 | 346158 | 2020-07-18 | Montgomery | North Carolina | 37123 | 445 | 10 |
349359 | 349359 | 2020-07-19 | Montgomery | North Carolina | 37123 | 452 | 10 |
352562 | 352562 | 2020-07-20 | Montgomery | North Carolina | 37123 | 456 | 10 |
355765 | 355765 | 2020-07-21 | Montgomery | North Carolina | 37123 | 458 | 10 |
358969 | 358969 | 2020-07-22 | Montgomery | North Carolina | 37123 | 466 | 11 |
362175 | 362175 | 2020-07-23 | Montgomery | North Carolina | 37123 | 469 | 11 |
365381 | 365381 | 2020-07-24 | Montgomery | North Carolina | 37123 | 491 | 12 |
368590 | 368590 | 2020-07-25 | Montgomery | North Carolina | 37123 | 499 | 13 |
371802 | 371802 | 2020-07-26 | Montgomery | North Carolina | 37123 | 514 | 13 |
375014 | 375014 | 2020-07-27 | Montgomery | North Carolina | 37123 | 531 | 13 |
378230 | 378230 | 2020-07-28 | Montgomery | North Carolina | 37123 | 552 | 13 |
381447 | 381447 | 2020-07-29 | Montgomery | North Carolina | 37123 | 561 | 13 |
384665 | 384665 | 2020-07-30 | Montgomery | North Carolina | 37123 | 563 | 13 |
387882 | 387882 | 2020-07-31 | Montgomery | North Carolina | 37123 | 569 | 13 |
391099 | 391099 | 2020-08-01 | Montgomery | North Carolina | 37123 | 585 | 13 |
394315 | 394315 | 2020-08-02 | Montgomery | North Carolina | 37123 | 587 | 13 |
397532 | 397532 | 2020-08-03 | Montgomery | North Carolina | 37123 | 594 | 13 |
400747 | 400747 | 2020-08-04 | Montgomery | North Carolina | 37123 | 601 | 13 |
403965 | 403965 | 2020-08-05 | Montgomery | North Carolina | 37123 | 610 | 13 |
407184 | 407184 | 2020-08-06 | Montgomery | North Carolina | 37123 | 621 | 13 |
410404 | 410404 | 2020-08-07 | Montgomery | North Carolina | 37123 | 626 | 13 |
413624 | 413624 | 2020-08-08 | Montgomery | North Carolina | 37123 | 635 | 13 |
416845 | 416845 | 2020-08-09 | Montgomery | North Carolina | 37123 | 640 | 13 |
420065 | 420065 | 2020-08-10 | Montgomery | North Carolina | 37123 | 647 | 13 |
423288 | 423288 | 2020-08-11 | Montgomery | North Carolina | 37123 | 650 | 13 |
426511 | 426511 | 2020-08-12 | Montgomery | North Carolina | 37123 | 656 | 14 |
429736 | 429736 | 2020-08-13 | Montgomery | North Carolina | 37123 | 659 | 14 |
432962 | 432962 | 2020-08-14 | Montgomery | North Carolina | 37123 | 673 | 15 |
436188 | 436188 | 2020-08-15 | Montgomery | North Carolina | 37123 | 686 | 16 |
439413 | 439413 | 2020-08-16 | Montgomery | North Carolina | 37123 | 701 | 16 |
442640 | 442640 | 2020-08-17 | Montgomery | North Carolina | 37123 | 714 | 16 |
445866 | 445866 | 2020-08-18 | Montgomery | North Carolina | 37123 | 722 | 16 |
449094 | 449094 | 2020-08-19 | Montgomery | North Carolina | 37123 | 725 | 16 |
452322 | 452322 | 2020-08-20 | Montgomery | North Carolina | 37123 | 739 | 16 |
455550 | 455550 | 2020-08-21 | Montgomery | North Carolina | 37123 | 753 | 17 |
458778 | 458778 | 2020-08-22 | Montgomery | North Carolina | 37123 | 771 | 17 |
462006 | 462006 | 2020-08-23 | Montgomery | North Carolina | 37123 | 779 | 17 |
465235 | 465235 | 2020-08-24 | Montgomery | North Carolina | 37123 | 797 | 17 |
468463 | 468463 | 2020-08-25 | Montgomery | North Carolina | 37123 | 804 | 17 |
471695 | 471695 | 2020-08-26 | Montgomery | North Carolina | 37123 | 824 | 17 |
474929 | 474929 | 2020-08-27 | Montgomery | North Carolina | 37123 | 840 | 17 |
478162 | 478162 | 2020-08-28 | Montgomery | North Carolina | 37123 | 854 | 18 |
481395 | 481395 | 2020-08-29 | Montgomery | North Carolina | 37123 | 869 | 18 |
484630 | 484630 | 2020-08-30 | Montgomery | North Carolina | 37123 | 881 | 18 |
487863 | 487863 | 2020-08-31 | Montgomery | North Carolina | 37123 | 885 | 18 |
491096 | 491096 | 2020-09-01 | Montgomery | North Carolina | 37123 | 893 | 18 |
494330 | 494330 | 2020-09-02 | Montgomery | North Carolina | 37123 | 896 | 18 |
497563 | 497563 | 2020-09-03 | Montgomery | North Carolina | 37123 | 895 | 18 |
500797 | 500797 | 2020-09-04 | Montgomery | North Carolina | 37123 | 923 | 18 |
504031 | 504031 | 2020-09-05 | Montgomery | North Carolina | 37123 | 930 | 18 |
507263 | 507263 | 2020-09-06 | Montgomery | North Carolina | 37123 | 935 | 18 |
510496 | 510496 | 2020-09-07 | Montgomery | North Carolina | 37123 | 943 | 18 |
513729 | 513729 | 2020-09-08 | Montgomery | North Carolina | 37123 | 950 | 18 |
516964 | 516964 | 2020-09-09 | Montgomery | North Carolina | 37123 | 961 | 19 |
520200 | 520200 | 2020-09-10 | Montgomery | North Carolina | 37123 | 964 | 19 |
523436 | 523436 | 2020-09-11 | Montgomery | North Carolina | 37123 | 968 | 22 |
526672 | 526672 | 2020-09-12 | Montgomery | North Carolina | 37123 | 975 | 23 |
529909 | 529909 | 2020-09-13 | Montgomery | North Carolina | 37123 | 979 | 23 |
533144 | 533144 | 2020-09-14 | Montgomery | North Carolina | 37123 | 986 | 23 |
536380 | 536380 | 2020-09-15 | Montgomery | North Carolina | 37123 | 990 | 23 |
539617 | 539617 | 2020-09-16 | Montgomery | North Carolina | 37123 | 995 | 25 |
542853 | 542853 | 2020-09-17 | Montgomery | North Carolina | 37123 | 1013 | 25 |
546090 | 546090 | 2020-09-18 | Montgomery | North Carolina | 37123 | 1016 | 25 |
549329 | 549329 | 2020-09-19 | Montgomery | North Carolina | 37123 | 1020 | 25 |
552568 | 552568 | 2020-09-20 | Montgomery | North Carolina | 37123 | 1025 | 25 |
555805 | 555805 | 2020-09-21 | Montgomery | North Carolina | 37123 | 1026 | 25 |
559042 | 559042 | 2020-09-22 | Montgomery | North Carolina | 37123 | 1028 | 26 |
562279 | 562279 | 2020-09-23 | Montgomery | North Carolina | 37123 | 1029 | 26 |
565520 | 565520 | 2020-09-24 | Montgomery | North Carolina | 37123 | 1029 | 27 |
568761 | 568761 | 2020-09-25 | Montgomery | North Carolina | 37123 | 1042 | 30 |
572003 | 572003 | 2020-09-26 | Montgomery | North Carolina | 37123 | 1047 | 30 |
575247 | 575247 | 2020-09-27 | Montgomery | North Carolina | 37123 | 1049 | 30 |
578488 | 578488 | 2020-09-28 | Montgomery | North Carolina | 37123 | 1052 | 30 |
581728 | 581728 | 2020-09-29 | Montgomery | North Carolina | 37123 | 1052 | 30 |
584969 | 584969 | 2020-09-30 | Montgomery | North Carolina | 37123 | 1049 | 32 |
588209 | 588209 | 2020-10-01 | Montgomery | North Carolina | 37123 | 1053 | 33 |
591450 | 591450 | 2020-10-02 | Montgomery | North Carolina | 37123 | 1058 | 34 |
594691 | 594691 | 2020-10-03 | Montgomery | North Carolina | 37123 | 1063 | 34 |
597934 | 597934 | 2020-10-04 | Montgomery | North Carolina | 37123 | 1067 | 34 |
601177 | 601177 | 2020-10-05 | Montgomery | North Carolina | 37123 | 1070 | 34 |
604419 | 604419 | 2020-10-06 | Montgomery | North Carolina | 37123 | 1070 | 35 |
607662 | 607662 | 2020-10-07 | Montgomery | North Carolina | 37123 | 1071 | 35 |
610904 | 610904 | 2020-10-08 | Montgomery | North Carolina | 37123 | 1076 | 36 |
614145 | 614145 | 2020-10-09 | Montgomery | North Carolina | 37123 | 1085 | 36 |
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);