ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Walsh" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9091 | 9091 | 2020-03-23 | Walsh | North Dakota | 38099 | 1 | 0 |
10403 | 10403 | 2020-03-24 | Walsh | North Dakota | 38099 | 1 | 0 |
11850 | 11850 | 2020-03-25 | Walsh | North Dakota | 38099 | 1 | 0 |
13456 | 13456 | 2020-03-26 | Walsh | North Dakota | 38099 | 1 | 0 |
15193 | 15193 | 2020-03-27 | Walsh | North Dakota | 38099 | 1 | 0 |
17032 | 17032 | 2020-03-28 | Walsh | North Dakota | 38099 | 1 | 0 |
18966 | 18966 | 2020-03-29 | Walsh | North Dakota | 38099 | 1 | 0 |
21009 | 21009 | 2020-03-30 | Walsh | North Dakota | 38099 | 1 | 0 |
23140 | 23140 | 2020-03-31 | Walsh | North Dakota | 38099 | 1 | 0 |
25335 | 25335 | 2020-04-01 | Walsh | North Dakota | 38099 | 1 | 0 |
27601 | 27601 | 2020-04-02 | Walsh | North Dakota | 38099 | 1 | 0 |
29930 | 29930 | 2020-04-03 | Walsh | North Dakota | 38099 | 1 | 0 |
32318 | 32318 | 2020-04-04 | Walsh | North Dakota | 38099 | 1 | 0 |
34751 | 34751 | 2020-04-05 | Walsh | North Dakota | 38099 | 1 | 0 |
37220 | 37220 | 2020-04-06 | Walsh | North Dakota | 38099 | 3 | 0 |
39737 | 39737 | 2020-04-07 | Walsh | North Dakota | 38099 | 3 | 0 |
42295 | 42295 | 2020-04-08 | Walsh | North Dakota | 38099 | 3 | 0 |
44880 | 44880 | 2020-04-09 | Walsh | North Dakota | 38099 | 3 | 0 |
47495 | 47495 | 2020-04-10 | Walsh | North Dakota | 38099 | 3 | 0 |
50150 | 50150 | 2020-04-11 | Walsh | North Dakota | 38099 | 3 | 0 |
52823 | 52823 | 2020-04-12 | Walsh | North Dakota | 38099 | 3 | 0 |
55507 | 55507 | 2020-04-13 | Walsh | North Dakota | 38099 | 3 | 0 |
58208 | 58208 | 2020-04-14 | Walsh | North Dakota | 38099 | 3 | 0 |
60922 | 60922 | 2020-04-15 | Walsh | North Dakota | 38099 | 3 | 0 |
63648 | 63648 | 2020-04-16 | Walsh | North Dakota | 38099 | 3 | 0 |
66391 | 66391 | 2020-04-17 | Walsh | North Dakota | 38099 | 3 | 0 |
69148 | 69148 | 2020-04-18 | Walsh | North Dakota | 38099 | 3 | 0 |
71915 | 71915 | 2020-04-19 | Walsh | North Dakota | 38099 | 3 | 0 |
74690 | 74690 | 2020-04-20 | Walsh | North Dakota | 38099 | 3 | 0 |
77471 | 77471 | 2020-04-21 | Walsh | North Dakota | 38099 | 3 | 0 |
80260 | 80260 | 2020-04-22 | Walsh | North Dakota | 38099 | 3 | 0 |
83059 | 83059 | 2020-04-23 | Walsh | North Dakota | 38099 | 3 | 0 |
85863 | 85863 | 2020-04-24 | Walsh | North Dakota | 38099 | 4 | 0 |
88677 | 88677 | 2020-04-25 | Walsh | North Dakota | 38099 | 4 | 0 |
91493 | 91493 | 2020-04-26 | Walsh | North Dakota | 38099 | 4 | 0 |
94319 | 94319 | 2020-04-27 | Walsh | North Dakota | 38099 | 7 | 0 |
97156 | 97156 | 2020-04-28 | Walsh | North Dakota | 38099 | 7 | 0 |
100005 | 100005 | 2020-04-29 | Walsh | North Dakota | 38099 | 7 | 0 |
102858 | 102858 | 2020-04-30 | Walsh | North Dakota | 38099 | 7 | 0 |
105721 | 105721 | 2020-05-01 | Walsh | North Dakota | 38099 | 7 | 0 |
108588 | 108588 | 2020-05-02 | Walsh | North Dakota | 38099 | 7 | 0 |
111462 | 111462 | 2020-05-03 | Walsh | North Dakota | 38099 | 7 | 0 |
114343 | 114343 | 2020-05-04 | Walsh | North Dakota | 38099 | 7 | 0 |
117224 | 117224 | 2020-05-05 | Walsh | North Dakota | 38099 | 7 | 0 |
120185 | 120185 | 2020-05-06 | Walsh | North Dakota | 38099 | 7 | 0 |
123162 | 123162 | 2020-05-07 | Walsh | North Dakota | 38099 | 8 | 0 |
126145 | 126145 | 2020-05-08 | Walsh | North Dakota | 38099 | 8 | 0 |
129134 | 129134 | 2020-05-09 | Walsh | North Dakota | 38099 | 8 | 0 |
132123 | 132123 | 2020-05-10 | Walsh | North Dakota | 38099 | 8 | 0 |
135114 | 135114 | 2020-05-11 | Walsh | North Dakota | 38099 | 8 | 0 |
138104 | 138104 | 2020-05-12 | Walsh | North Dakota | 38099 | 8 | 0 |
141100 | 141100 | 2020-05-13 | Walsh | North Dakota | 38099 | 9 | 0 |
144095 | 144095 | 2020-05-14 | Walsh | North Dakota | 38099 | 9 | 0 |
147096 | 147096 | 2020-05-15 | Walsh | North Dakota | 38099 | 9 | 0 |
150103 | 150103 | 2020-05-16 | Walsh | North Dakota | 38099 | 9 | 0 |
153114 | 153114 | 2020-05-17 | Walsh | North Dakota | 38099 | 10 | 0 |
156131 | 156131 | 2020-05-18 | Walsh | North Dakota | 38099 | 10 | 0 |
159151 | 159151 | 2020-05-19 | Walsh | North Dakota | 38099 | 10 | 0 |
162178 | 162178 | 2020-05-20 | Walsh | North Dakota | 38099 | 11 | 0 |
165207 | 165207 | 2020-05-21 | Walsh | North Dakota | 38099 | 11 | 0 |
168243 | 168243 | 2020-05-22 | Walsh | North Dakota | 38099 | 11 | 0 |
171282 | 171282 | 2020-05-23 | Walsh | North Dakota | 38099 | 11 | 0 |
174324 | 174324 | 2020-05-24 | Walsh | North Dakota | 38099 | 13 | 0 |
177368 | 177368 | 2020-05-25 | Walsh | North Dakota | 38099 | 13 | 0 |
180411 | 180411 | 2020-05-26 | Walsh | North Dakota | 38099 | 13 | 0 |
183460 | 183460 | 2020-05-27 | Walsh | North Dakota | 38099 | 13 | 0 |
186517 | 186517 | 2020-05-28 | Walsh | North Dakota | 38099 | 13 | 0 |
189577 | 189577 | 2020-05-29 | Walsh | North Dakota | 38099 | 13 | 0 |
192641 | 192641 | 2020-05-30 | Walsh | North Dakota | 38099 | 13 | 0 |
195711 | 195711 | 2020-05-31 | Walsh | North Dakota | 38099 | 13 | 0 |
198784 | 198784 | 2020-06-01 | Walsh | North Dakota | 38099 | 14 | 0 |
201859 | 201859 | 2020-06-02 | Walsh | North Dakota | 38099 | 14 | 0 |
204936 | 204936 | 2020-06-03 | Walsh | North Dakota | 38099 | 15 | 0 |
208017 | 208017 | 2020-06-04 | Walsh | North Dakota | 38099 | 15 | 0 |
211099 | 211099 | 2020-06-05 | Walsh | North Dakota | 38099 | 15 | 0 |
214185 | 214185 | 2020-06-06 | Walsh | North Dakota | 38099 | 16 | 0 |
217275 | 217275 | 2020-06-07 | Walsh | North Dakota | 38099 | 16 | 0 |
220367 | 220367 | 2020-06-08 | Walsh | North Dakota | 38099 | 16 | 0 |
223462 | 223462 | 2020-06-09 | Walsh | North Dakota | 38099 | 16 | 0 |
226562 | 226562 | 2020-06-10 | Walsh | North Dakota | 38099 | 16 | 0 |
229666 | 229666 | 2020-06-11 | Walsh | North Dakota | 38099 | 16 | 0 |
232771 | 232771 | 2020-06-12 | Walsh | North Dakota | 38099 | 16 | 0 |
235876 | 235876 | 2020-06-13 | Walsh | North Dakota | 38099 | 16 | 0 |
238984 | 238984 | 2020-06-14 | Walsh | North Dakota | 38099 | 16 | 0 |
242093 | 242093 | 2020-06-15 | Walsh | North Dakota | 38099 | 16 | 0 |
245205 | 245205 | 2020-06-16 | Walsh | North Dakota | 38099 | 17 | 0 |
248318 | 248318 | 2020-06-17 | Walsh | North Dakota | 38099 | 17 | 0 |
251433 | 251433 | 2020-06-18 | Walsh | North Dakota | 38099 | 17 | 0 |
254548 | 254548 | 2020-06-19 | Walsh | North Dakota | 38099 | 17 | 0 |
257673 | 257673 | 2020-06-20 | Walsh | North Dakota | 38099 | 17 | 0 |
260800 | 260800 | 2020-06-21 | Walsh | North Dakota | 38099 | 17 | 0 |
263928 | 263928 | 2020-06-22 | Walsh | North Dakota | 38099 | 17 | 0 |
267056 | 267056 | 2020-06-23 | Walsh | North Dakota | 38099 | 17 | 0 |
270190 | 270190 | 2020-06-24 | Walsh | North Dakota | 38099 | 19 | 0 |
273329 | 273329 | 2020-06-25 | Walsh | North Dakota | 38099 | 20 | 0 |
276476 | 276476 | 2020-06-26 | Walsh | North Dakota | 38099 | 20 | 0 |
279624 | 279624 | 2020-06-27 | Walsh | North Dakota | 38099 | 21 | 0 |
282770 | 282770 | 2020-06-28 | Walsh | North Dakota | 38099 | 22 | 0 |
285915 | 285915 | 2020-06-29 | Walsh | North Dakota | 38099 | 22 | 0 |
289065 | 289065 | 2020-06-30 | Walsh | North Dakota | 38099 | 23 | 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);