ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38105 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 |
---|---|---|---|---|---|---|---|
1094509 | 1094509 | 2021-03-06 | Williams | North Dakota | 38105 | 4505 | 36 |
1091263 | 1091263 | 2021-03-05 | Williams | North Dakota | 38105 | 4497 | 36 |
1088018 | 1088018 | 2021-03-04 | Williams | North Dakota | 38105 | 4496 | 36 |
1084773 | 1084773 | 2021-03-03 | Williams | North Dakota | 38105 | 4484 | 36 |
1081527 | 1081527 | 2021-03-02 | Williams | North Dakota | 38105 | 4476 | 36 |
1078281 | 1078281 | 2021-03-01 | Williams | North Dakota | 38105 | 4464 | 36 |
1075036 | 1075036 | 2021-02-28 | Williams | North Dakota | 38105 | 4462 | 36 |
1071790 | 1071790 | 2021-02-27 | Williams | North Dakota | 38105 | 4462 | 36 |
1068544 | 1068544 | 2021-02-26 | Williams | North Dakota | 38105 | 4458 | 36 |
1065299 | 1065299 | 2021-02-25 | Williams | North Dakota | 38105 | 4456 | 36 |
1062055 | 1062055 | 2021-02-24 | Williams | North Dakota | 38105 | 4454 | 36 |
1058809 | 1058809 | 2021-02-23 | Williams | North Dakota | 38105 | 4441 | 36 |
1055563 | 1055563 | 2021-02-22 | Williams | North Dakota | 38105 | 4437 | 36 |
1052317 | 1052317 | 2021-02-21 | Williams | North Dakota | 38105 | 4431 | 36 |
1049070 | 1049070 | 2021-02-20 | Williams | North Dakota | 38105 | 4432 | 36 |
1045823 | 1045823 | 2021-02-19 | Williams | North Dakota | 38105 | 4425 | 36 |
1042578 | 1042578 | 2021-02-18 | Williams | North Dakota | 38105 | 4418 | 36 |
1039333 | 1039333 | 2021-02-17 | Williams | North Dakota | 38105 | 4407 | 36 |
1036088 | 1036088 | 2021-02-16 | Williams | North Dakota | 38105 | 4403 | 36 |
1032843 | 1032843 | 2021-02-15 | Williams | North Dakota | 38105 | 4396 | 36 |
1029597 | 1029597 | 2021-02-14 | Williams | North Dakota | 38105 | 4393 | 36 |
1026350 | 1026350 | 2021-02-13 | Williams | North Dakota | 38105 | 4390 | 36 |
1023105 | 1023105 | 2021-02-12 | Williams | North Dakota | 38105 | 4385 | 36 |
1019860 | 1019860 | 2021-02-11 | Williams | North Dakota | 38105 | 4379 | 35 |
1016615 | 1016615 | 2021-02-10 | Williams | North Dakota | 38105 | 4373 | 35 |
1013370 | 1013370 | 2021-02-09 | Williams | North Dakota | 38105 | 4366 | 35 |
1010125 | 1010125 | 2021-02-08 | Williams | North Dakota | 38105 | 4361 | 35 |
1006879 | 1006879 | 2021-02-07 | Williams | North Dakota | 38105 | 4360 | 35 |
1003633 | 1003633 | 2021-02-06 | Williams | North Dakota | 38105 | 4356 | 35 |
1000387 | 1000387 | 2021-02-05 | Williams | North Dakota | 38105 | 4355 | 35 |
997141 | 997141 | 2021-02-04 | Williams | North Dakota | 38105 | 4351 | 35 |
993895 | 993895 | 2021-02-03 | Williams | North Dakota | 38105 | 4328 | 35 |
990649 | 990649 | 2021-02-02 | Williams | North Dakota | 38105 | 4321 | 35 |
987403 | 987403 | 2021-02-01 | Williams | North Dakota | 38105 | 4313 | 35 |
984156 | 984156 | 2021-01-31 | Williams | North Dakota | 38105 | 4311 | 35 |
980909 | 980909 | 2021-01-30 | Williams | North Dakota | 38105 | 4306 | 35 |
977663 | 977663 | 2021-01-29 | Williams | North Dakota | 38105 | 4293 | 35 |
974418 | 974418 | 2021-01-28 | Williams | North Dakota | 38105 | 4287 | 35 |
971173 | 971173 | 2021-01-27 | Williams | North Dakota | 38105 | 4266 | 35 |
967928 | 967928 | 2021-01-26 | Williams | North Dakota | 38105 | 4240 | 35 |
964684 | 964684 | 2021-01-25 | Williams | North Dakota | 38105 | 4225 | 35 |
961439 | 961439 | 2021-01-24 | Williams | North Dakota | 38105 | 4220 | 35 |
958194 | 958194 | 2021-01-23 | Williams | North Dakota | 38105 | 4216 | 35 |
954948 | 954948 | 2021-01-22 | Williams | North Dakota | 38105 | 4197 | 35 |
951703 | 951703 | 2021-01-21 | Williams | North Dakota | 38105 | 4181 | 35 |
948458 | 948458 | 2021-01-20 | Williams | North Dakota | 38105 | 4164 | 34 |
945212 | 945212 | 2021-01-19 | Williams | North Dakota | 38105 | 4148 | 34 |
941965 | 941965 | 2021-01-18 | Williams | North Dakota | 38105 | 4139 | 34 |
938720 | 938720 | 2021-01-17 | Williams | North Dakota | 38105 | 4136 | 34 |
935475 | 935475 | 2021-01-16 | Williams | North Dakota | 38105 | 4131 | 34 |
932230 | 932230 | 2021-01-15 | Williams | North Dakota | 38105 | 4127 | 34 |
928985 | 928985 | 2021-01-14 | Williams | North Dakota | 38105 | 4108 | 34 |
925740 | 925740 | 2021-01-13 | Williams | North Dakota | 38105 | 4096 | 34 |
922494 | 922494 | 2021-01-12 | Williams | North Dakota | 38105 | 4084 | 34 |
919249 | 919249 | 2021-01-11 | Williams | North Dakota | 38105 | 4073 | 33 |
916004 | 916004 | 2021-01-10 | Williams | North Dakota | 38105 | 4069 | 33 |
912759 | 912759 | 2021-01-09 | Williams | North Dakota | 38105 | 4053 | 33 |
909514 | 909514 | 2021-01-08 | Williams | North Dakota | 38105 | 4048 | 33 |
906269 | 906269 | 2021-01-07 | Williams | North Dakota | 38105 | 4037 | 33 |
903023 | 903023 | 2021-01-06 | Williams | North Dakota | 38105 | 4008 | 33 |
899778 | 899778 | 2021-01-05 | Williams | North Dakota | 38105 | 4002 | 33 |
896533 | 896533 | 2021-01-04 | Williams | North Dakota | 38105 | 3976 | 32 |
893287 | 893287 | 2021-01-03 | Williams | North Dakota | 38105 | 3974 | 32 |
890041 | 890041 | 2021-01-02 | Williams | North Dakota | 38105 | 3967 | 32 |
886794 | 886794 | 2021-01-01 | Williams | North Dakota | 38105 | 3962 | 32 |
883549 | 883549 | 2020-12-31 | Williams | North Dakota | 38105 | 3955 | 31 |
880304 | 880304 | 2020-12-30 | Williams | North Dakota | 38105 | 3944 | 30 |
877059 | 877059 | 2020-12-29 | Williams | North Dakota | 38105 | 3925 | 30 |
873814 | 873814 | 2020-12-28 | Williams | North Dakota | 38105 | 3919 | 29 |
870569 | 870569 | 2020-12-27 | Williams | North Dakota | 38105 | 3917 | 29 |
867324 | 867324 | 2020-12-26 | Williams | North Dakota | 38105 | 3913 | 29 |
864079 | 864079 | 2020-12-25 | Williams | North Dakota | 38105 | 3902 | 29 |
860834 | 860834 | 2020-12-24 | Williams | North Dakota | 38105 | 3889 | 27 |
857589 | 857589 | 2020-12-23 | Williams | North Dakota | 38105 | 3889 | 27 |
854344 | 854344 | 2020-12-22 | Williams | North Dakota | 38105 | 3868 | 27 |
851099 | 851099 | 2020-12-21 | Williams | North Dakota | 38105 | 3851 | 27 |
847854 | 847854 | 2020-12-20 | Williams | North Dakota | 38105 | 3851 | 27 |
844609 | 844609 | 2020-12-19 | Williams | North Dakota | 38105 | 3845 | 27 |
841363 | 841363 | 2020-12-18 | Williams | North Dakota | 38105 | 3831 | 27 |
838118 | 838118 | 2020-12-17 | Williams | North Dakota | 38105 | 3807 | 27 |
834872 | 834872 | 2020-12-16 | Williams | North Dakota | 38105 | 3785 | 27 |
831626 | 831626 | 2020-12-15 | Williams | North Dakota | 38105 | 3773 | 26 |
828379 | 828379 | 2020-12-14 | Williams | North Dakota | 38105 | 3769 | 26 |
825133 | 825133 | 2020-12-13 | Williams | North Dakota | 38105 | 3768 | 26 |
821886 | 821886 | 2020-12-12 | Williams | North Dakota | 38105 | 3760 | 26 |
818640 | 818640 | 2020-12-11 | Williams | North Dakota | 38105 | 3748 | 26 |
815394 | 815394 | 2020-12-10 | Williams | North Dakota | 38105 | 3722 | 25 |
812148 | 812148 | 2020-12-09 | Williams | North Dakota | 38105 | 3706 | 25 |
808904 | 808904 | 2020-12-08 | Williams | North Dakota | 38105 | 3201 | 23 |
805659 | 805659 | 2020-12-07 | Williams | North Dakota | 38105 | 3201 | 23 |
802414 | 802414 | 2020-12-06 | Williams | North Dakota | 38105 | 3187 | 23 |
799169 | 799169 | 2020-12-05 | Williams | North Dakota | 38105 | 3169 | 23 |
795924 | 795924 | 2020-12-04 | Williams | North Dakota | 38105 | 3117 | 23 |
792679 | 792679 | 2020-12-03 | Williams | North Dakota | 38105 | 3101 | 23 |
789434 | 789434 | 2020-12-02 | Williams | North Dakota | 38105 | 3078 | 23 |
786189 | 786189 | 2020-12-01 | Williams | North Dakota | 38105 | 3059 | 23 |
782945 | 782945 | 2020-11-30 | Williams | North Dakota | 38105 | 3040 | 23 |
779699 | 779699 | 2020-11-29 | Williams | North Dakota | 38105 | 3033 | 23 |
776454 | 776454 | 2020-11-28 | Williams | North Dakota | 38105 | 2993 | 23 |
773209 | 773209 | 2020-11-27 | Williams | North Dakota | 38105 | 2976 | 23 |
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);