ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Nelson" and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
71904 | 71904 | 2020-04-19 | Nelson | North Dakota | 38063 | 1 | 0 |
74679 | 74679 | 2020-04-20 | Nelson | North Dakota | 38063 | 1 | 0 |
77460 | 77460 | 2020-04-21 | Nelson | North Dakota | 38063 | 1 | 0 |
80249 | 80249 | 2020-04-22 | Nelson | North Dakota | 38063 | 1 | 0 |
83048 | 83048 | 2020-04-23 | Nelson | North Dakota | 38063 | 1 | 0 |
85852 | 85852 | 2020-04-24 | Nelson | North Dakota | 38063 | 1 | 0 |
88665 | 88665 | 2020-04-25 | Nelson | North Dakota | 38063 | 1 | 0 |
91480 | 91480 | 2020-04-26 | Nelson | North Dakota | 38063 | 1 | 0 |
94306 | 94306 | 2020-04-27 | Nelson | North Dakota | 38063 | 1 | 0 |
97143 | 97143 | 2020-04-28 | Nelson | North Dakota | 38063 | 1 | 0 |
99992 | 99992 | 2020-04-29 | Nelson | North Dakota | 38063 | 1 | 0 |
102845 | 102845 | 2020-04-30 | Nelson | North Dakota | 38063 | 1 | 0 |
105707 | 105707 | 2020-05-01 | Nelson | North Dakota | 38063 | 1 | 0 |
108574 | 108574 | 2020-05-02 | Nelson | North Dakota | 38063 | 1 | 0 |
111448 | 111448 | 2020-05-03 | Nelson | North Dakota | 38063 | 1 | 0 |
114329 | 114329 | 2020-05-04 | Nelson | North Dakota | 38063 | 1 | 0 |
117210 | 117210 | 2020-05-05 | Nelson | North Dakota | 38063 | 1 | 0 |
120171 | 120171 | 2020-05-06 | Nelson | North Dakota | 38063 | 1 | 0 |
123147 | 123147 | 2020-05-07 | Nelson | North Dakota | 38063 | 1 | 0 |
126130 | 126130 | 2020-05-08 | Nelson | North Dakota | 38063 | 1 | 0 |
129119 | 129119 | 2020-05-09 | Nelson | North Dakota | 38063 | 1 | 0 |
132108 | 132108 | 2020-05-10 | Nelson | North Dakota | 38063 | 1 | 0 |
135099 | 135099 | 2020-05-11 | Nelson | North Dakota | 38063 | 1 | 0 |
138089 | 138089 | 2020-05-12 | Nelson | North Dakota | 38063 | 1 | 0 |
141085 | 141085 | 2020-05-13 | Nelson | North Dakota | 38063 | 1 | 0 |
144080 | 144080 | 2020-05-14 | Nelson | North Dakota | 38063 | 1 | 0 |
147081 | 147081 | 2020-05-15 | Nelson | North Dakota | 38063 | 1 | 0 |
150088 | 150088 | 2020-05-16 | Nelson | North Dakota | 38063 | 1 | 0 |
153098 | 153098 | 2020-05-17 | Nelson | North Dakota | 38063 | 1 | 0 |
156115 | 156115 | 2020-05-18 | Nelson | North Dakota | 38063 | 1 | 0 |
159135 | 159135 | 2020-05-19 | Nelson | North Dakota | 38063 | 1 | 0 |
162162 | 162162 | 2020-05-20 | Nelson | North Dakota | 38063 | 2 | 0 |
165191 | 165191 | 2020-05-21 | Nelson | North Dakota | 38063 | 2 | 0 |
168227 | 168227 | 2020-05-22 | Nelson | North Dakota | 38063 | 2 | 0 |
171266 | 171266 | 2020-05-23 | Nelson | North Dakota | 38063 | 2 | 0 |
174308 | 174308 | 2020-05-24 | Nelson | North Dakota | 38063 | 2 | 0 |
177352 | 177352 | 2020-05-25 | Nelson | North Dakota | 38063 | 2 | 0 |
180395 | 180395 | 2020-05-26 | Nelson | North Dakota | 38063 | 1 | 0 |
183443 | 183443 | 2020-05-27 | Nelson | North Dakota | 38063 | 1 | 0 |
186500 | 186500 | 2020-05-28 | Nelson | North Dakota | 38063 | 1 | 0 |
189560 | 189560 | 2020-05-29 | Nelson | North Dakota | 38063 | 1 | 0 |
192624 | 192624 | 2020-05-30 | Nelson | North Dakota | 38063 | 1 | 0 |
195694 | 195694 | 2020-05-31 | Nelson | North Dakota | 38063 | 1 | 0 |
198767 | 198767 | 2020-06-01 | Nelson | North Dakota | 38063 | 1 | 0 |
201842 | 201842 | 2020-06-02 | Nelson | North Dakota | 38063 | 1 | 0 |
204919 | 204919 | 2020-06-03 | Nelson | North Dakota | 38063 | 1 | 0 |
208000 | 208000 | 2020-06-04 | Nelson | North Dakota | 38063 | 1 | 0 |
211082 | 211082 | 2020-06-05 | Nelson | North Dakota | 38063 | 1 | 0 |
214167 | 214167 | 2020-06-06 | Nelson | North Dakota | 38063 | 1 | 0 |
217257 | 217257 | 2020-06-07 | Nelson | North Dakota | 38063 | 1 | 0 |
220349 | 220349 | 2020-06-08 | Nelson | North Dakota | 38063 | 1 | 0 |
223444 | 223444 | 2020-06-09 | Nelson | North Dakota | 38063 | 1 | 0 |
226544 | 226544 | 2020-06-10 | Nelson | North Dakota | 38063 | 1 | 0 |
229648 | 229648 | 2020-06-11 | Nelson | North Dakota | 38063 | 1 | 0 |
232753 | 232753 | 2020-06-12 | Nelson | North Dakota | 38063 | 1 | 0 |
235858 | 235858 | 2020-06-13 | Nelson | North Dakota | 38063 | 1 | 0 |
238966 | 238966 | 2020-06-14 | Nelson | North Dakota | 38063 | 1 | 0 |
242075 | 242075 | 2020-06-15 | Nelson | North Dakota | 38063 | 1 | 0 |
245187 | 245187 | 2020-06-16 | Nelson | North Dakota | 38063 | 1 | 0 |
248300 | 248300 | 2020-06-17 | Nelson | North Dakota | 38063 | 1 | 0 |
251415 | 251415 | 2020-06-18 | Nelson | North Dakota | 38063 | 1 | 0 |
254530 | 254530 | 2020-06-19 | Nelson | North Dakota | 38063 | 1 | 0 |
257655 | 257655 | 2020-06-20 | Nelson | North Dakota | 38063 | 1 | 0 |
260782 | 260782 | 2020-06-21 | Nelson | North Dakota | 38063 | 1 | 0 |
263910 | 263910 | 2020-06-22 | Nelson | North Dakota | 38063 | 1 | 0 |
267038 | 267038 | 2020-06-23 | Nelson | North Dakota | 38063 | 1 | 0 |
270172 | 270172 | 2020-06-24 | Nelson | North Dakota | 38063 | 1 | 0 |
273311 | 273311 | 2020-06-25 | Nelson | North Dakota | 38063 | 1 | 0 |
276458 | 276458 | 2020-06-26 | Nelson | North Dakota | 38063 | 1 | 0 |
279606 | 279606 | 2020-06-27 | Nelson | North Dakota | 38063 | 1 | 0 |
282752 | 282752 | 2020-06-28 | Nelson | North Dakota | 38063 | 1 | 0 |
285897 | 285897 | 2020-06-29 | Nelson | North Dakota | 38063 | 1 | 0 |
289047 | 289047 | 2020-06-30 | Nelson | North Dakota | 38063 | 1 | 0 |
292199 | 292199 | 2020-07-01 | Nelson | North Dakota | 38063 | 1 | 0 |
295354 | 295354 | 2020-07-02 | Nelson | North Dakota | 38063 | 1 | 0 |
298514 | 298514 | 2020-07-03 | Nelson | North Dakota | 38063 | 1 | 0 |
301677 | 301677 | 2020-07-04 | Nelson | North Dakota | 38063 | 1 | 0 |
304840 | 304840 | 2020-07-05 | Nelson | North Dakota | 38063 | 1 | 0 |
308007 | 308007 | 2020-07-06 | Nelson | North Dakota | 38063 | 1 | 0 |
311175 | 311175 | 2020-07-07 | Nelson | North Dakota | 38063 | 1 | 0 |
314347 | 314347 | 2020-07-08 | Nelson | North Dakota | 38063 | 2 | 0 |
317520 | 317520 | 2020-07-09 | Nelson | North Dakota | 38063 | 2 | 0 |
320697 | 320697 | 2020-07-10 | Nelson | North Dakota | 38063 | 2 | 0 |
323877 | 323877 | 2020-07-11 | Nelson | North Dakota | 38063 | 2 | 0 |
327062 | 327062 | 2020-07-12 | Nelson | North Dakota | 38063 | 2 | 0 |
330249 | 330249 | 2020-07-13 | Nelson | North Dakota | 38063 | 2 | 0 |
333440 | 333440 | 2020-07-14 | Nelson | North Dakota | 38063 | 2 | 0 |
336634 | 336634 | 2020-07-15 | Nelson | North Dakota | 38063 | 2 | 0 |
339830 | 339830 | 2020-07-16 | Nelson | North Dakota | 38063 | 2 | 0 |
343028 | 343028 | 2020-07-17 | Nelson | North Dakota | 38063 | 2 | 0 |
346227 | 346227 | 2020-07-18 | Nelson | North Dakota | 38063 | 3 | 0 |
349428 | 349428 | 2020-07-19 | Nelson | North Dakota | 38063 | 3 | 0 |
352631 | 352631 | 2020-07-20 | Nelson | North Dakota | 38063 | 3 | 0 |
355834 | 355834 | 2020-07-21 | Nelson | North Dakota | 38063 | 3 | 0 |
359038 | 359038 | 2020-07-22 | Nelson | North Dakota | 38063 | 3 | 0 |
362244 | 362244 | 2020-07-23 | Nelson | North Dakota | 38063 | 3 | 0 |
365450 | 365450 | 2020-07-24 | Nelson | North Dakota | 38063 | 4 | 0 |
368659 | 368659 | 2020-07-25 | Nelson | North Dakota | 38063 | 5 | 0 |
371871 | 371871 | 2020-07-26 | Nelson | North Dakota | 38063 | 5 | 0 |
375083 | 375083 | 2020-07-27 | Nelson | North Dakota | 38063 | 5 | 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);