ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Oliver", fips = 38065 and state = "North Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21004 | 21004 | 2020-03-30 | Oliver | North Dakota | 38065 | 1 | 0 |
23135 | 23135 | 2020-03-31 | Oliver | North Dakota | 38065 | 1 | 0 |
25330 | 25330 | 2020-04-01 | Oliver | North Dakota | 38065 | 1 | 0 |
27596 | 27596 | 2020-04-02 | Oliver | North Dakota | 38065 | 1 | 0 |
29924 | 29924 | 2020-04-03 | Oliver | North Dakota | 38065 | 1 | 0 |
32312 | 32312 | 2020-04-04 | Oliver | North Dakota | 38065 | 1 | 0 |
34745 | 34745 | 2020-04-05 | Oliver | North Dakota | 38065 | 1 | 0 |
37214 | 37214 | 2020-04-06 | Oliver | North Dakota | 38065 | 1 | 0 |
39731 | 39731 | 2020-04-07 | Oliver | North Dakota | 38065 | 1 | 0 |
42288 | 42288 | 2020-04-08 | Oliver | North Dakota | 38065 | 1 | 0 |
44872 | 44872 | 2020-04-09 | Oliver | North Dakota | 38065 | 1 | 0 |
47485 | 47485 | 2020-04-10 | Oliver | North Dakota | 38065 | 1 | 0 |
50140 | 50140 | 2020-04-11 | Oliver | North Dakota | 38065 | 1 | 0 |
52813 | 52813 | 2020-04-12 | Oliver | North Dakota | 38065 | 1 | 0 |
55497 | 55497 | 2020-04-13 | Oliver | North Dakota | 38065 | 1 | 0 |
58198 | 58198 | 2020-04-14 | Oliver | North Dakota | 38065 | 1 | 0 |
60912 | 60912 | 2020-04-15 | Oliver | North Dakota | 38065 | 1 | 0 |
63638 | 63638 | 2020-04-16 | Oliver | North Dakota | 38065 | 1 | 0 |
66381 | 66381 | 2020-04-17 | Oliver | North Dakota | 38065 | 1 | 0 |
69138 | 69138 | 2020-04-18 | Oliver | North Dakota | 38065 | 1 | 0 |
71905 | 71905 | 2020-04-19 | Oliver | North Dakota | 38065 | 1 | 0 |
74680 | 74680 | 2020-04-20 | Oliver | North Dakota | 38065 | 1 | 0 |
77461 | 77461 | 2020-04-21 | Oliver | North Dakota | 38065 | 1 | 0 |
80250 | 80250 | 2020-04-22 | Oliver | North Dakota | 38065 | 1 | 0 |
83049 | 83049 | 2020-04-23 | Oliver | North Dakota | 38065 | 1 | 0 |
85853 | 85853 | 2020-04-24 | Oliver | North Dakota | 38065 | 1 | 0 |
88666 | 88666 | 2020-04-25 | Oliver | North Dakota | 38065 | 1 | 0 |
91481 | 91481 | 2020-04-26 | Oliver | North Dakota | 38065 | 1 | 0 |
94307 | 94307 | 2020-04-27 | Oliver | North Dakota | 38065 | 1 | 0 |
97144 | 97144 | 2020-04-28 | Oliver | North Dakota | 38065 | 1 | 0 |
99993 | 99993 | 2020-04-29 | Oliver | North Dakota | 38065 | 1 | 0 |
102846 | 102846 | 2020-04-30 | Oliver | North Dakota | 38065 | 1 | 0 |
105708 | 105708 | 2020-05-01 | Oliver | North Dakota | 38065 | 1 | 0 |
108575 | 108575 | 2020-05-02 | Oliver | North Dakota | 38065 | 1 | 0 |
111449 | 111449 | 2020-05-03 | Oliver | North Dakota | 38065 | 1 | 0 |
114330 | 114330 | 2020-05-04 | Oliver | North Dakota | 38065 | 1 | 0 |
117211 | 117211 | 2020-05-05 | Oliver | North Dakota | 38065 | 1 | 0 |
120172 | 120172 | 2020-05-06 | Oliver | North Dakota | 38065 | 1 | 0 |
123148 | 123148 | 2020-05-07 | Oliver | North Dakota | 38065 | 1 | 0 |
126131 | 126131 | 2020-05-08 | Oliver | North Dakota | 38065 | 1 | 0 |
129120 | 129120 | 2020-05-09 | Oliver | North Dakota | 38065 | 1 | 0 |
132109 | 132109 | 2020-05-10 | Oliver | North Dakota | 38065 | 1 | 0 |
135100 | 135100 | 2020-05-11 | Oliver | North Dakota | 38065 | 1 | 0 |
138090 | 138090 | 2020-05-12 | Oliver | North Dakota | 38065 | 1 | 0 |
141086 | 141086 | 2020-05-13 | Oliver | North Dakota | 38065 | 1 | 0 |
144081 | 144081 | 2020-05-14 | Oliver | North Dakota | 38065 | 1 | 0 |
147082 | 147082 | 2020-05-15 | Oliver | North Dakota | 38065 | 1 | 0 |
150089 | 150089 | 2020-05-16 | Oliver | North Dakota | 38065 | 1 | 0 |
153099 | 153099 | 2020-05-17 | Oliver | North Dakota | 38065 | 1 | 0 |
156116 | 156116 | 2020-05-18 | Oliver | North Dakota | 38065 | 1 | 0 |
159136 | 159136 | 2020-05-19 | Oliver | North Dakota | 38065 | 1 | 0 |
162163 | 162163 | 2020-05-20 | Oliver | North Dakota | 38065 | 1 | 0 |
165192 | 165192 | 2020-05-21 | Oliver | North Dakota | 38065 | 1 | 0 |
168228 | 168228 | 2020-05-22 | Oliver | North Dakota | 38065 | 1 | 0 |
171267 | 171267 | 2020-05-23 | Oliver | North Dakota | 38065 | 1 | 0 |
174309 | 174309 | 2020-05-24 | Oliver | North Dakota | 38065 | 1 | 0 |
177353 | 177353 | 2020-05-25 | Oliver | North Dakota | 38065 | 1 | 0 |
180396 | 180396 | 2020-05-26 | Oliver | North Dakota | 38065 | 1 | 0 |
183444 | 183444 | 2020-05-27 | Oliver | North Dakota | 38065 | 1 | 0 |
186501 | 186501 | 2020-05-28 | Oliver | North Dakota | 38065 | 1 | 0 |
189561 | 189561 | 2020-05-29 | Oliver | North Dakota | 38065 | 1 | 0 |
192625 | 192625 | 2020-05-30 | Oliver | North Dakota | 38065 | 1 | 0 |
195695 | 195695 | 2020-05-31 | Oliver | North Dakota | 38065 | 1 | 0 |
198768 | 198768 | 2020-06-01 | Oliver | North Dakota | 38065 | 1 | 0 |
201843 | 201843 | 2020-06-02 | Oliver | North Dakota | 38065 | 1 | 0 |
204920 | 204920 | 2020-06-03 | Oliver | North Dakota | 38065 | 1 | 0 |
208001 | 208001 | 2020-06-04 | Oliver | North Dakota | 38065 | 1 | 0 |
211083 | 211083 | 2020-06-05 | Oliver | North Dakota | 38065 | 1 | 0 |
214168 | 214168 | 2020-06-06 | Oliver | North Dakota | 38065 | 1 | 0 |
217258 | 217258 | 2020-06-07 | Oliver | North Dakota | 38065 | 1 | 0 |
220350 | 220350 | 2020-06-08 | Oliver | North Dakota | 38065 | 1 | 0 |
223445 | 223445 | 2020-06-09 | Oliver | North Dakota | 38065 | 1 | 0 |
226545 | 226545 | 2020-06-10 | Oliver | North Dakota | 38065 | 1 | 0 |
229649 | 229649 | 2020-06-11 | Oliver | North Dakota | 38065 | 1 | 0 |
232754 | 232754 | 2020-06-12 | Oliver | North Dakota | 38065 | 1 | 0 |
235859 | 235859 | 2020-06-13 | Oliver | North Dakota | 38065 | 1 | 0 |
238967 | 238967 | 2020-06-14 | Oliver | North Dakota | 38065 | 1 | 0 |
242076 | 242076 | 2020-06-15 | Oliver | North Dakota | 38065 | 1 | 0 |
245188 | 245188 | 2020-06-16 | Oliver | North Dakota | 38065 | 1 | 0 |
248301 | 248301 | 2020-06-17 | Oliver | North Dakota | 38065 | 1 | 0 |
251416 | 251416 | 2020-06-18 | Oliver | North Dakota | 38065 | 1 | 0 |
254531 | 254531 | 2020-06-19 | Oliver | North Dakota | 38065 | 1 | 0 |
257656 | 257656 | 2020-06-20 | Oliver | North Dakota | 38065 | 1 | 0 |
260783 | 260783 | 2020-06-21 | Oliver | North Dakota | 38065 | 1 | 0 |
263911 | 263911 | 2020-06-22 | Oliver | North Dakota | 38065 | 1 | 0 |
267039 | 267039 | 2020-06-23 | Oliver | North Dakota | 38065 | 1 | 0 |
270173 | 270173 | 2020-06-24 | Oliver | North Dakota | 38065 | 1 | 0 |
273312 | 273312 | 2020-06-25 | Oliver | North Dakota | 38065 | 1 | 0 |
276459 | 276459 | 2020-06-26 | Oliver | North Dakota | 38065 | 1 | 0 |
279607 | 279607 | 2020-06-27 | Oliver | North Dakota | 38065 | 1 | 0 |
282753 | 282753 | 2020-06-28 | Oliver | North Dakota | 38065 | 1 | 0 |
285898 | 285898 | 2020-06-29 | Oliver | North Dakota | 38065 | 2 | 0 |
289048 | 289048 | 2020-06-30 | Oliver | North Dakota | 38065 | 2 | 0 |
292200 | 292200 | 2020-07-01 | Oliver | North Dakota | 38065 | 2 | 0 |
295355 | 295355 | 2020-07-02 | Oliver | North Dakota | 38065 | 2 | 0 |
298515 | 298515 | 2020-07-03 | Oliver | North Dakota | 38065 | 2 | 0 |
301678 | 301678 | 2020-07-04 | Oliver | North Dakota | 38065 | 2 | 0 |
304841 | 304841 | 2020-07-05 | Oliver | North Dakota | 38065 | 2 | 0 |
308008 | 308008 | 2020-07-06 | Oliver | North Dakota | 38065 | 2 | 0 |
311176 | 311176 | 2020-07-07 | Oliver | North Dakota | 38065 | 2 | 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);