ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40,499 rows where state = "North Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 38101 794
- 38015 788
- 38017 788
- 38059 787
- 38069 785
- 38071 785
- 38099 782
- 38025 781
- 38031 780
- 38089 780
- 38049 779
- 38051 779
- 38003 777
- 38023 777
- 38055 777
- 38061 777
- 38085 777
- 38035 775
- 38065 775
- 38037 774
- 38053 774
- 38105 774
- 38013 773
- 38027 771
- 38087 771
- 38029 769
- 38011 767
- 38093 766
- 38077 765
- 38081 764
- …
county >30
- Ward 794
- Burleigh 788
- Cass 788
- Morton 787
- Pierce 785
- Ramsey 785
- Walsh 782
- Dunn 781
- Foster 780
- Stark 780
- McHenry 779
- McIntosh 779
- Barnes 777
- Divide 777
- McLean 777
- Mountrail 777
- Sioux 777
- Grand Forks 775
- Oliver 775
- Grant 774
- McKenzie 774
- Williams 774
- Burke 773
- Eddy 771
- Slope 771
- Emmons 769
- Bowman 767
- Stutsman 766
- Richland 765
- Sargent 764
- …
state 1
- North Dakota · 40,499 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1294 | 1294 | 2020-03-11 | Ward | North Dakota | 38101 | 1 | 0 |
1536 | 1536 | 2020-03-12 | Ward | North Dakota | 38101 | 1 | 0 |
1831 | 1831 | 2020-03-13 | Ward | North Dakota | 38101 | 1 | 0 |
2185 | 2185 | 2020-03-14 | Ward | North Dakota | 38101 | 1 | 0 |
2599 | 2599 | 2020-03-15 | Ward | North Dakota | 38101 | 1 | 0 |
3061 | 3061 | 2020-03-16 | Ward | North Dakota | 38101 | 1 | 0 |
3582 | 3582 | 2020-03-17 | Burleigh | North Dakota | 38015 | 2 | 0 |
3583 | 3583 | 2020-03-17 | Cass | North Dakota | 38017 | 1 | 0 |
3584 | 3584 | 2020-03-17 | Ward | North Dakota | 38101 | 2 | 0 |
4191 | 4191 | 2020-03-18 | Burleigh | North Dakota | 38015 | 2 | 0 |
4192 | 4192 | 2020-03-18 | Cass | North Dakota | 38017 | 1 | 0 |
4193 | 4193 | 2020-03-18 | Morton | North Dakota | 38059 | 2 | 0 |
4194 | 4194 | 2020-03-18 | Ward | North Dakota | 38101 | 2 | 0 |
4922 | 4922 | 2020-03-19 | Burleigh | North Dakota | 38015 | 11 | 0 |
4923 | 4923 | 2020-03-19 | Cass | North Dakota | 38017 | 1 | 0 |
4924 | 4924 | 2020-03-19 | Morton | North Dakota | 38059 | 4 | 0 |
4925 | 4925 | 2020-03-19 | Ward | North Dakota | 38101 | 3 | 0 |
5781 | 5781 | 2020-03-20 | Burleigh | North Dakota | 38015 | 13 | 0 |
5782 | 5782 | 2020-03-20 | Cass | North Dakota | 38017 | 1 | 0 |
5783 | 5783 | 2020-03-20 | Morton | North Dakota | 38059 | 8 | 0 |
5784 | 5784 | 2020-03-20 | Pierce | North Dakota | 38069 | 1 | 0 |
5785 | 5785 | 2020-03-20 | Ramsey | North Dakota | 38071 | 1 | 0 |
5786 | 5786 | 2020-03-20 | Ward | North Dakota | 38101 | 3 | 0 |
6778 | 6778 | 2020-03-21 | Burleigh | North Dakota | 38015 | 14 | 0 |
6779 | 6779 | 2020-03-21 | Cass | North Dakota | 38017 | 1 | 0 |
6780 | 6780 | 2020-03-21 | Morton | North Dakota | 38059 | 8 | 0 |
6781 | 6781 | 2020-03-21 | Pierce | North Dakota | 38069 | 1 | 0 |
6782 | 6782 | 2020-03-21 | Ramsey | North Dakota | 38071 | 1 | 0 |
6783 | 6783 | 2020-03-21 | Ward | North Dakota | 38101 | 3 | 0 |
7884 | 7884 | 2020-03-22 | Burleigh | North Dakota | 38015 | 15 | 0 |
7885 | 7885 | 2020-03-22 | Cass | North Dakota | 38017 | 1 | 0 |
7886 | 7886 | 2020-03-22 | Morton | North Dakota | 38059 | 8 | 0 |
7887 | 7887 | 2020-03-22 | Pierce | North Dakota | 38069 | 2 | 0 |
7888 | 7888 | 2020-03-22 | Ramsey | North Dakota | 38071 | 1 | 0 |
7889 | 7889 | 2020-03-22 | Ward | North Dakota | 38101 | 3 | 0 |
9086 | 9086 | 2020-03-23 | Burleigh | North Dakota | 38015 | 16 | 0 |
9087 | 9087 | 2020-03-23 | Cass | North Dakota | 38017 | 1 | 0 |
9088 | 9088 | 2020-03-23 | Morton | North Dakota | 38059 | 8 | 0 |
9089 | 9089 | 2020-03-23 | Pierce | North Dakota | 38069 | 2 | 0 |
9090 | 9090 | 2020-03-23 | Ramsey | North Dakota | 38071 | 1 | 0 |
9091 | 9091 | 2020-03-23 | Walsh | North Dakota | 38099 | 1 | 0 |
9092 | 9092 | 2020-03-23 | Ward | North Dakota | 38101 | 3 | 0 |
10397 | 10397 | 2020-03-24 | Burleigh | North Dakota | 38015 | 18 | 0 |
10398 | 10398 | 2020-03-24 | Cass | North Dakota | 38017 | 3 | 0 |
10399 | 10399 | 2020-03-24 | Dunn | North Dakota | 38025 | 1 | 0 |
10400 | 10400 | 2020-03-24 | Morton | North Dakota | 38059 | 8 | 0 |
10401 | 10401 | 2020-03-24 | Pierce | North Dakota | 38069 | 2 | 0 |
10402 | 10402 | 2020-03-24 | Ramsey | North Dakota | 38071 | 1 | 0 |
10403 | 10403 | 2020-03-24 | Walsh | North Dakota | 38099 | 1 | 0 |
10404 | 10404 | 2020-03-24 | Ward | North Dakota | 38101 | 3 | 0 |
11842 | 11842 | 2020-03-25 | Burleigh | North Dakota | 38015 | 18 | 0 |
11843 | 11843 | 2020-03-25 | Cass | North Dakota | 38017 | 6 | 0 |
11844 | 11844 | 2020-03-25 | Dunn | North Dakota | 38025 | 1 | 0 |
11845 | 11845 | 2020-03-25 | Foster | North Dakota | 38031 | 1 | 0 |
11846 | 11846 | 2020-03-25 | Morton | North Dakota | 38059 | 8 | 0 |
11847 | 11847 | 2020-03-25 | Pierce | North Dakota | 38069 | 2 | 0 |
11848 | 11848 | 2020-03-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
11849 | 11849 | 2020-03-25 | Stark | North Dakota | 38089 | 2 | 0 |
11850 | 11850 | 2020-03-25 | Walsh | North Dakota | 38099 | 1 | 0 |
11851 | 11851 | 2020-03-25 | Ward | North Dakota | 38101 | 3 | 0 |
13446 | 13446 | 2020-03-26 | Burleigh | North Dakota | 38015 | 23 | 0 |
13447 | 13447 | 2020-03-26 | Cass | North Dakota | 38017 | 8 | 0 |
13448 | 13448 | 2020-03-26 | Dunn | North Dakota | 38025 | 1 | 0 |
13449 | 13449 | 2020-03-26 | Foster | North Dakota | 38031 | 1 | 0 |
13450 | 13450 | 2020-03-26 | McHenry | North Dakota | 38049 | 1 | 0 |
13451 | 13451 | 2020-03-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
13452 | 13452 | 2020-03-26 | Morton | North Dakota | 38059 | 8 | 0 |
13453 | 13453 | 2020-03-26 | Pierce | North Dakota | 38069 | 2 | 0 |
13454 | 13454 | 2020-03-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
13455 | 13455 | 2020-03-26 | Stark | North Dakota | 38089 | 5 | 0 |
13456 | 13456 | 2020-03-26 | Walsh | North Dakota | 38099 | 1 | 0 |
13457 | 13457 | 2020-03-26 | Ward | North Dakota | 38101 | 4 | 0 |
15183 | 15183 | 2020-03-27 | Burleigh | North Dakota | 38015 | 25 | 0 |
15184 | 15184 | 2020-03-27 | Cass | North Dakota | 38017 | 11 | 1 |
15185 | 15185 | 2020-03-27 | Dunn | North Dakota | 38025 | 1 | 0 |
15186 | 15186 | 2020-03-27 | Foster | North Dakota | 38031 | 1 | 0 |
15187 | 15187 | 2020-03-27 | McHenry | North Dakota | 38049 | 1 | 0 |
15188 | 15188 | 2020-03-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
15189 | 15189 | 2020-03-27 | Morton | North Dakota | 38059 | 11 | 0 |
15190 | 15190 | 2020-03-27 | Pierce | North Dakota | 38069 | 2 | 0 |
15191 | 15191 | 2020-03-27 | Ramsey | North Dakota | 38071 | 3 | 0 |
15192 | 15192 | 2020-03-27 | Stark | North Dakota | 38089 | 7 | 0 |
15193 | 15193 | 2020-03-27 | Walsh | North Dakota | 38099 | 1 | 0 |
15194 | 15194 | 2020-03-27 | Ward | North Dakota | 38101 | 4 | 0 |
17017 | 17017 | 2020-03-28 | Barnes | North Dakota | 38003 | 2 | 0 |
17018 | 17018 | 2020-03-28 | Burleigh | North Dakota | 38015 | 28 | 0 |
17019 | 17019 | 2020-03-28 | Cass | North Dakota | 38017 | 18 | 1 |
17020 | 17020 | 2020-03-28 | Divide | North Dakota | 38023 | 1 | 0 |
17021 | 17021 | 2020-03-28 | Dunn | North Dakota | 38025 | 1 | 0 |
17022 | 17022 | 2020-03-28 | Foster | North Dakota | 38031 | 1 | 0 |
17023 | 17023 | 2020-03-28 | McHenry | North Dakota | 38049 | 1 | 0 |
17024 | 17024 | 2020-03-28 | McIntosh | North Dakota | 38051 | 1 | 0 |
17025 | 17025 | 2020-03-28 | McLean | North Dakota | 38055 | 2 | 0 |
17026 | 17026 | 2020-03-28 | Morton | North Dakota | 38059 | 13 | 0 |
17027 | 17027 | 2020-03-28 | Mountrail | North Dakota | 38061 | 2 | 0 |
17028 | 17028 | 2020-03-28 | Pierce | North Dakota | 38069 | 2 | 0 |
17029 | 17029 | 2020-03-28 | Ramsey | North Dakota | 38071 | 3 | 0 |
17030 | 17030 | 2020-03-28 | Sioux | North Dakota | 38085 | 1 | 0 |
17031 | 17031 | 2020-03-28 | Stark | North Dakota | 38089 | 9 | 0 |
17032 | 17032 | 2020-03-28 | Walsh | North Dakota | 38099 | 1 | 0 |
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);