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)
fips >30
- 38101 777
- 38003 776
- 38015 776
- 38017 776
- 38023 776
- 38025 776
- 38031 776
- 38049 776
- 38051 776
- 38055 776
- 38059 776
- 38061 776
- 38069 776
- 38071 776
- 38085 776
- 38089 776
- 38099 776
- 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 777
- Barnes 776
- Burleigh 776
- Cass 776
- Divide 776
- Dunn 776
- Foster 776
- McHenry 776
- McIntosh 776
- McLean 776
- Morton 776
- Mountrail 776
- Pierce 776
- Ramsey 776
- Sioux 776
- Stark 776
- Walsh 776
- 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,399 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17033 | 17033 | 2020-03-28 | Ward | North Dakota | 38101 | 7 | 0 |
18951 | 18951 | 2020-03-29 | Barnes | North Dakota | 38003 | 2 | 0 |
18952 | 18952 | 2020-03-29 | Burleigh | North Dakota | 38015 | 28 | 0 |
18953 | 18953 | 2020-03-29 | Cass | North Dakota | 38017 | 20 | 1 |
18954 | 18954 | 2020-03-29 | Divide | North Dakota | 38023 | 1 | 0 |
18955 | 18955 | 2020-03-29 | Dunn | North Dakota | 38025 | 1 | 0 |
18956 | 18956 | 2020-03-29 | Foster | North Dakota | 38031 | 1 | 0 |
18957 | 18957 | 2020-03-29 | McHenry | North Dakota | 38049 | 1 | 0 |
18958 | 18958 | 2020-03-29 | McIntosh | North Dakota | 38051 | 1 | 0 |
18959 | 18959 | 2020-03-29 | McLean | North Dakota | 38055 | 2 | 0 |
18960 | 18960 | 2020-03-29 | Morton | North Dakota | 38059 | 14 | 0 |
18961 | 18961 | 2020-03-29 | Mountrail | North Dakota | 38061 | 2 | 0 |
18962 | 18962 | 2020-03-29 | Pierce | North Dakota | 38069 | 2 | 0 |
18963 | 18963 | 2020-03-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
18964 | 18964 | 2020-03-29 | Sioux | North Dakota | 38085 | 1 | 0 |
18965 | 18965 | 2020-03-29 | Stark | North Dakota | 38089 | 10 | 0 |
18966 | 18966 | 2020-03-29 | Walsh | North Dakota | 38099 | 1 | 0 |
18967 | 18967 | 2020-03-29 | Ward | North Dakota | 38101 | 7 | 0 |
20992 | 20992 | 2020-03-30 | Barnes | North Dakota | 38003 | 2 | 0 |
20993 | 20993 | 2020-03-30 | Burleigh | North Dakota | 38015 | 29 | 0 |
20994 | 20994 | 2020-03-30 | Cass | North Dakota | 38017 | 23 | 1 |
20995 | 20995 | 2020-03-30 | Divide | North Dakota | 38023 | 1 | 0 |
20996 | 20996 | 2020-03-30 | Dunn | North Dakota | 38025 | 1 | 0 |
20997 | 20997 | 2020-03-30 | Foster | North Dakota | 38031 | 1 | 0 |
20998 | 20998 | 2020-03-30 | Grand Forks | North Dakota | 38035 | 2 | 0 |
20999 | 20999 | 2020-03-30 | McHenry | North Dakota | 38049 | 1 | 1 |
21000 | 21000 | 2020-03-30 | McIntosh | North Dakota | 38051 | 1 | 0 |
21001 | 21001 | 2020-03-30 | McLean | North Dakota | 38055 | 2 | 0 |
21002 | 21002 | 2020-03-30 | Morton | North Dakota | 38059 | 14 | 1 |
21003 | 21003 | 2020-03-30 | Mountrail | North Dakota | 38061 | 4 | 0 |
21004 | 21004 | 2020-03-30 | Oliver | North Dakota | 38065 | 1 | 0 |
21005 | 21005 | 2020-03-30 | Pierce | North Dakota | 38069 | 2 | 0 |
21006 | 21006 | 2020-03-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
21007 | 21007 | 2020-03-30 | Sioux | North Dakota | 38085 | 1 | 0 |
21008 | 21008 | 2020-03-30 | Stark | North Dakota | 38089 | 11 | 0 |
21009 | 21009 | 2020-03-30 | Walsh | North Dakota | 38099 | 1 | 0 |
21010 | 21010 | 2020-03-30 | Ward | North Dakota | 38101 | 9 | 0 |
23121 | 23121 | 2020-03-31 | Barnes | North Dakota | 38003 | 2 | 0 |
23122 | 23122 | 2020-03-31 | Burleigh | North Dakota | 38015 | 30 | 0 |
23123 | 23123 | 2020-03-31 | Cass | North Dakota | 38017 | 31 | 1 |
23124 | 23124 | 2020-03-31 | Divide | North Dakota | 38023 | 1 | 0 |
23125 | 23125 | 2020-03-31 | Dunn | North Dakota | 38025 | 1 | 0 |
23126 | 23126 | 2020-03-31 | Foster | North Dakota | 38031 | 1 | 0 |
23127 | 23127 | 2020-03-31 | Grand Forks | North Dakota | 38035 | 3 | 0 |
23128 | 23128 | 2020-03-31 | Grant | North Dakota | 38037 | 1 | 0 |
23129 | 23129 | 2020-03-31 | McHenry | North Dakota | 38049 | 1 | 1 |
23130 | 23130 | 2020-03-31 | McIntosh | North Dakota | 38051 | 1 | 0 |
23131 | 23131 | 2020-03-31 | McKenzie | North Dakota | 38053 | 1 | 0 |
23132 | 23132 | 2020-03-31 | McLean | North Dakota | 38055 | 2 | 0 |
23133 | 23133 | 2020-03-31 | Morton | North Dakota | 38059 | 14 | 1 |
23134 | 23134 | 2020-03-31 | Mountrail | North Dakota | 38061 | 5 | 0 |
23135 | 23135 | 2020-03-31 | Oliver | North Dakota | 38065 | 1 | 0 |
23136 | 23136 | 2020-03-31 | Pierce | North Dakota | 38069 | 2 | 0 |
23137 | 23137 | 2020-03-31 | Ramsey | North Dakota | 38071 | 3 | 0 |
23138 | 23138 | 2020-03-31 | Sioux | North Dakota | 38085 | 1 | 0 |
23139 | 23139 | 2020-03-31 | Stark | North Dakota | 38089 | 12 | 0 |
23140 | 23140 | 2020-03-31 | Walsh | North Dakota | 38099 | 1 | 0 |
23141 | 23141 | 2020-03-31 | Ward | North Dakota | 38101 | 9 | 0 |
23142 | 23142 | 2020-03-31 | Williams | North Dakota | 38105 | 3 | 0 |
25315 | 25315 | 2020-04-01 | Barnes | North Dakota | 38003 | 2 | 0 |
25316 | 25316 | 2020-04-01 | Burke | North Dakota | 38013 | 2 | 0 |
25317 | 25317 | 2020-04-01 | Burleigh | North Dakota | 38015 | 32 | 0 |
25318 | 25318 | 2020-04-01 | Cass | North Dakota | 38017 | 37 | 1 |
25319 | 25319 | 2020-04-01 | Divide | North Dakota | 38023 | 1 | 0 |
25320 | 25320 | 2020-04-01 | Dunn | North Dakota | 38025 | 1 | 0 |
25321 | 25321 | 2020-04-01 | Foster | North Dakota | 38031 | 1 | 0 |
25322 | 25322 | 2020-04-01 | Grand Forks | North Dakota | 38035 | 5 | 0 |
25323 | 25323 | 2020-04-01 | Grant | North Dakota | 38037 | 1 | 0 |
25324 | 25324 | 2020-04-01 | McHenry | North Dakota | 38049 | 1 | 1 |
25325 | 25325 | 2020-04-01 | McIntosh | North Dakota | 38051 | 1 | 0 |
25326 | 25326 | 2020-04-01 | McKenzie | North Dakota | 38053 | 2 | 0 |
25327 | 25327 | 2020-04-01 | McLean | North Dakota | 38055 | 2 | 0 |
25328 | 25328 | 2020-04-01 | Morton | North Dakota | 38059 | 14 | 1 |
25329 | 25329 | 2020-04-01 | Mountrail | North Dakota | 38061 | 6 | 0 |
25330 | 25330 | 2020-04-01 | Oliver | North Dakota | 38065 | 1 | 0 |
25331 | 25331 | 2020-04-01 | Pierce | North Dakota | 38069 | 2 | 0 |
25332 | 25332 | 2020-04-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
25333 | 25333 | 2020-04-01 | Sioux | North Dakota | 38085 | 1 | 0 |
25334 | 25334 | 2020-04-01 | Stark | North Dakota | 38089 | 16 | 0 |
25335 | 25335 | 2020-04-01 | Walsh | North Dakota | 38099 | 1 | 0 |
25336 | 25336 | 2020-04-01 | Ward | North Dakota | 38101 | 12 | 0 |
25337 | 25337 | 2020-04-01 | Williams | North Dakota | 38105 | 3 | 0 |
27581 | 27581 | 2020-04-02 | Barnes | North Dakota | 38003 | 2 | 0 |
27582 | 27582 | 2020-04-02 | Burke | North Dakota | 38013 | 2 | 0 |
27583 | 27583 | 2020-04-02 | Burleigh | North Dakota | 38015 | 32 | 0 |
27584 | 27584 | 2020-04-02 | Cass | North Dakota | 38017 | 43 | 1 |
27585 | 27585 | 2020-04-02 | Divide | North Dakota | 38023 | 1 | 0 |
27586 | 27586 | 2020-04-02 | Dunn | North Dakota | 38025 | 1 | 0 |
27587 | 27587 | 2020-04-02 | Foster | North Dakota | 38031 | 1 | 0 |
27588 | 27588 | 2020-04-02 | Grand Forks | North Dakota | 38035 | 5 | 0 |
27589 | 27589 | 2020-04-02 | Grant | North Dakota | 38037 | 1 | 0 |
27590 | 27590 | 2020-04-02 | McHenry | North Dakota | 38049 | 1 | 1 |
27591 | 27591 | 2020-04-02 | McIntosh | North Dakota | 38051 | 1 | 0 |
27592 | 27592 | 2020-04-02 | McKenzie | North Dakota | 38053 | 2 | 0 |
27593 | 27593 | 2020-04-02 | McLean | North Dakota | 38055 | 2 | 0 |
27594 | 27594 | 2020-04-02 | Morton | North Dakota | 38059 | 14 | 1 |
27595 | 27595 | 2020-04-02 | Mountrail | North Dakota | 38061 | 8 | 0 |
27596 | 27596 | 2020-04-02 | Oliver | North Dakota | 38065 | 1 | 0 |
27597 | 27597 | 2020-04-02 | Pierce | North Dakota | 38069 | 2 | 0 |
27598 | 27598 | 2020-04-02 | Ramsey | North Dakota | 38071 | 3 | 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);