ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Grand Forks" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922458 | 922458 | 2021-01-12 | Grand Forks | North Dakota | 38035 | 9435 | 70 |
919213 | 919213 | 2021-01-11 | Grand Forks | North Dakota | 38035 | 9424 | 69 |
915968 | 915968 | 2021-01-10 | Grand Forks | North Dakota | 38035 | 9412 | 69 |
912723 | 912723 | 2021-01-09 | Grand Forks | North Dakota | 38035 | 9395 | 69 |
909478 | 909478 | 2021-01-08 | Grand Forks | North Dakota | 38035 | 9386 | 69 |
906233 | 906233 | 2021-01-07 | Grand Forks | North Dakota | 38035 | 9360 | 68 |
902987 | 902987 | 2021-01-06 | Grand Forks | North Dakota | 38035 | 9346 | 67 |
899742 | 899742 | 2021-01-05 | Grand Forks | North Dakota | 38035 | 9322 | 67 |
896497 | 896497 | 2021-01-04 | Grand Forks | North Dakota | 38035 | 9303 | 66 |
893251 | 893251 | 2021-01-03 | Grand Forks | North Dakota | 38035 | 9285 | 66 |
890005 | 890005 | 2021-01-02 | Grand Forks | North Dakota | 38035 | 9258 | 66 |
886758 | 886758 | 2021-01-01 | Grand Forks | North Dakota | 38035 | 9255 | 66 |
883513 | 883513 | 2020-12-31 | Grand Forks | North Dakota | 38035 | 9237 | 66 |
880268 | 880268 | 2020-12-30 | Grand Forks | North Dakota | 38035 | 9220 | 65 |
877023 | 877023 | 2020-12-29 | Grand Forks | North Dakota | 38035 | 9199 | 65 |
873778 | 873778 | 2020-12-28 | Grand Forks | North Dakota | 38035 | 9181 | 65 |
870533 | 870533 | 2020-12-27 | Grand Forks | North Dakota | 38035 | 9175 | 65 |
867288 | 867288 | 2020-12-26 | Grand Forks | North Dakota | 38035 | 9169 | 65 |
864043 | 864043 | 2020-12-25 | Grand Forks | North Dakota | 38035 | 9161 | 65 |
860798 | 860798 | 2020-12-24 | Grand Forks | North Dakota | 38035 | 9146 | 64 |
857553 | 857553 | 2020-12-23 | Grand Forks | North Dakota | 38035 | 9138 | 61 |
854308 | 854308 | 2020-12-22 | Grand Forks | North Dakota | 38035 | 9121 | 61 |
851063 | 851063 | 2020-12-21 | Grand Forks | North Dakota | 38035 | 9096 | 61 |
847818 | 847818 | 2020-12-20 | Grand Forks | North Dakota | 38035 | 9091 | 61 |
844573 | 844573 | 2020-12-19 | Grand Forks | North Dakota | 38035 | 9068 | 61 |
841327 | 841327 | 2020-12-18 | Grand Forks | North Dakota | 38035 | 9064 | 59 |
838082 | 838082 | 2020-12-17 | Grand Forks | North Dakota | 38035 | 9033 | 56 |
834836 | 834836 | 2020-12-16 | Grand Forks | North Dakota | 38035 | 9004 | 56 |
831590 | 831590 | 2020-12-15 | Grand Forks | North Dakota | 38035 | 8984 | 56 |
828343 | 828343 | 2020-12-14 | Grand Forks | North Dakota | 38035 | 8963 | 55 |
825097 | 825097 | 2020-12-13 | Grand Forks | North Dakota | 38035 | 8959 | 55 |
821850 | 821850 | 2020-12-12 | Grand Forks | North Dakota | 38035 | 8924 | 55 |
818604 | 818604 | 2020-12-11 | Grand Forks | North Dakota | 38035 | 8896 | 54 |
815358 | 815358 | 2020-12-10 | Grand Forks | North Dakota | 38035 | 8855 | 53 |
812113 | 812113 | 2020-12-09 | Grand Forks | North Dakota | 38035 | 8820 | 52 |
808868 | 808868 | 2020-12-08 | Grand Forks | North Dakota | 38035 | 8431 | 48 |
805623 | 805623 | 2020-12-07 | Grand Forks | North Dakota | 38035 | 8431 | 48 |
802378 | 802378 | 2020-12-06 | Grand Forks | North Dakota | 38035 | 8394 | 48 |
799133 | 799133 | 2020-12-05 | Grand Forks | North Dakota | 38035 | 8368 | 48 |
795888 | 795888 | 2020-12-04 | Grand Forks | North Dakota | 38035 | 8313 | 48 |
792643 | 792643 | 2020-12-03 | Grand Forks | North Dakota | 38035 | 8270 | 48 |
789398 | 789398 | 2020-12-02 | Grand Forks | North Dakota | 38035 | 8196 | 47 |
786153 | 786153 | 2020-12-01 | Grand Forks | North Dakota | 38035 | 8179 | 47 |
782909 | 782909 | 2020-11-30 | Grand Forks | North Dakota | 38035 | 8170 | 44 |
779663 | 779663 | 2020-11-29 | Grand Forks | North Dakota | 38035 | 8144 | 43 |
776418 | 776418 | 2020-11-28 | Grand Forks | North Dakota | 38035 | 8051 | 43 |
773173 | 773173 | 2020-11-27 | Grand Forks | North Dakota | 38035 | 8013 | 41 |
769928 | 769928 | 2020-11-26 | Grand Forks | North Dakota | 38035 | 7891 | 41 |
766682 | 766682 | 2020-11-25 | Grand Forks | North Dakota | 38035 | 7873 | 41 |
763437 | 763437 | 2020-11-24 | Grand Forks | North Dakota | 38035 | 7774 | 41 |
760192 | 760192 | 2020-11-23 | Grand Forks | North Dakota | 38035 | 7718 | 41 |
756946 | 756946 | 2020-11-22 | Grand Forks | North Dakota | 38035 | 7651 | 40 |
753699 | 753699 | 2020-11-21 | Grand Forks | North Dakota | 38035 | 7604 | 40 |
750453 | 750453 | 2020-11-20 | Grand Forks | North Dakota | 38035 | 7475 | 39 |
747207 | 747207 | 2020-11-19 | Grand Forks | North Dakota | 38035 | 7323 | 35 |
743961 | 743961 | 2020-11-18 | Grand Forks | North Dakota | 38035 | 7142 | 35 |
740714 | 740714 | 2020-11-17 | Grand Forks | North Dakota | 38035 | 7050 | 33 |
737469 | 737469 | 2020-11-16 | Grand Forks | North Dakota | 38035 | 6931 | 33 |
734225 | 734225 | 2020-11-15 | Grand Forks | North Dakota | 38035 | 6757 | 32 |
730979 | 730979 | 2020-11-14 | Grand Forks | North Dakota | 38035 | 6621 | 29 |
727735 | 727735 | 2020-11-13 | Grand Forks | North Dakota | 38035 | 6327 | 29 |
724491 | 724491 | 2020-11-12 | Grand Forks | North Dakota | 38035 | 6165 | 28 |
721248 | 721248 | 2020-11-11 | Grand Forks | North Dakota | 38035 | 6055 | 28 |
718005 | 718005 | 2020-11-10 | Grand Forks | North Dakota | 38035 | 6004 | 27 |
714762 | 714762 | 2020-11-09 | Grand Forks | North Dakota | 38035 | 5950 | 27 |
711518 | 711518 | 2020-11-08 | Grand Forks | North Dakota | 38035 | 5786 | 27 |
708274 | 708274 | 2020-11-07 | Grand Forks | North Dakota | 38035 | 5601 | 27 |
705031 | 705031 | 2020-11-06 | Grand Forks | North Dakota | 38035 | 5504 | 25 |
701788 | 701788 | 2020-11-05 | Grand Forks | North Dakota | 38035 | 5167 | 25 |
698544 | 698544 | 2020-11-04 | Grand Forks | North Dakota | 38035 | 5066 | 22 |
695301 | 695301 | 2020-11-03 | Grand Forks | North Dakota | 38035 | 4999 | 22 |
692059 | 692059 | 2020-11-02 | Grand Forks | North Dakota | 38035 | 4780 | 22 |
688815 | 688815 | 2020-11-01 | Grand Forks | North Dakota | 38035 | 4624 | 22 |
685570 | 685570 | 2020-10-31 | Grand Forks | North Dakota | 38035 | 4520 | 22 |
682327 | 682327 | 2020-10-30 | Grand Forks | North Dakota | 38035 | 4356 | 21 |
679084 | 679084 | 2020-10-29 | Grand Forks | North Dakota | 38035 | 4118 | 20 |
675841 | 675841 | 2020-10-28 | Grand Forks | North Dakota | 38035 | 4020 | 20 |
672598 | 672598 | 2020-10-27 | Grand Forks | North Dakota | 38035 | 3991 | 20 |
669356 | 669356 | 2020-10-26 | Grand Forks | North Dakota | 38035 | 3838 | 18 |
666112 | 666112 | 2020-10-25 | Grand Forks | North Dakota | 38035 | 3789 | 18 |
662867 | 662867 | 2020-10-24 | Grand Forks | North Dakota | 38035 | 3684 | 18 |
659623 | 659623 | 2020-10-23 | Grand Forks | North Dakota | 38035 | 3541 | 17 |
656379 | 656379 | 2020-10-22 | Grand Forks | North Dakota | 38035 | 3421 | 17 |
653134 | 653134 | 2020-10-21 | Grand Forks | North Dakota | 38035 | 3365 | 15 |
649889 | 649889 | 2020-10-20 | Grand Forks | North Dakota | 38035 | 3337 | 15 |
646645 | 646645 | 2020-10-19 | Grand Forks | North Dakota | 38035 | 3137 | 15 |
643399 | 643399 | 2020-10-18 | Grand Forks | North Dakota | 38035 | 3099 | 15 |
640151 | 640151 | 2020-10-17 | Grand Forks | North Dakota | 38035 | 2985 | 15 |
636905 | 636905 | 2020-10-16 | Grand Forks | North Dakota | 38035 | 2930 | 15 |
633659 | 633659 | 2020-10-15 | Grand Forks | North Dakota | 38035 | 2817 | 14 |
630414 | 630414 | 2020-10-14 | Grand Forks | North Dakota | 38035 | 2777 | 14 |
627170 | 627170 | 2020-10-13 | Grand Forks | North Dakota | 38035 | 2746 | 14 |
623928 | 623928 | 2020-10-12 | Grand Forks | North Dakota | 38035 | 2707 | 14 |
620685 | 620685 | 2020-10-11 | Grand Forks | North Dakota | 38035 | 2667 | 14 |
617443 | 617443 | 2020-10-10 | Grand Forks | North Dakota | 38035 | 2635 | 14 |
614201 | 614201 | 2020-10-09 | Grand Forks | North Dakota | 38035 | 2587 | 14 |
610960 | 610960 | 2020-10-08 | Grand Forks | North Dakota | 38035 | 2511 | 14 |
607718 | 607718 | 2020-10-07 | Grand Forks | North Dakota | 38035 | 2480 | 14 |
604475 | 604475 | 2020-10-06 | Grand Forks | North Dakota | 38035 | 2463 | 13 |
601233 | 601233 | 2020-10-05 | Grand Forks | North Dakota | 38035 | 2432 | 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);