ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Walsh" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536469 | 536469 | 2020-09-15 | Walsh | North Dakota | 38099 | 162 | 1 |
533233 | 533233 | 2020-09-14 | Walsh | North Dakota | 38099 | 162 | 1 |
529998 | 529998 | 2020-09-13 | Walsh | North Dakota | 38099 | 162 | 1 |
526761 | 526761 | 2020-09-12 | Walsh | North Dakota | 38099 | 161 | 1 |
523525 | 523525 | 2020-09-11 | Walsh | North Dakota | 38099 | 158 | 1 |
520289 | 520289 | 2020-09-10 | Walsh | North Dakota | 38099 | 156 | 1 |
517053 | 517053 | 2020-09-09 | Walsh | North Dakota | 38099 | 155 | 1 |
513818 | 513818 | 2020-09-08 | Walsh | North Dakota | 38099 | 156 | 1 |
510585 | 510585 | 2020-09-07 | Walsh | North Dakota | 38099 | 157 | 1 |
507352 | 507352 | 2020-09-06 | Walsh | North Dakota | 38099 | 154 | 1 |
504120 | 504120 | 2020-09-05 | Walsh | North Dakota | 38099 | 152 | 1 |
500886 | 500886 | 2020-09-04 | Walsh | North Dakota | 38099 | 148 | 1 |
497652 | 497652 | 2020-09-03 | Walsh | North Dakota | 38099 | 148 | 1 |
494419 | 494419 | 2020-09-02 | Walsh | North Dakota | 38099 | 146 | 1 |
491185 | 491185 | 2020-09-01 | Walsh | North Dakota | 38099 | 144 | 1 |
487952 | 487952 | 2020-08-31 | Walsh | North Dakota | 38099 | 141 | 1 |
484719 | 484719 | 2020-08-30 | Walsh | North Dakota | 38099 | 141 | 1 |
481484 | 481484 | 2020-08-29 | Walsh | North Dakota | 38099 | 140 | 1 |
478251 | 478251 | 2020-08-28 | Walsh | North Dakota | 38099 | 137 | 1 |
475018 | 475018 | 2020-08-27 | Walsh | North Dakota | 38099 | 140 | 1 |
471784 | 471784 | 2020-08-26 | Walsh | North Dakota | 38099 | 141 | 1 |
468552 | 468552 | 2020-08-25 | Walsh | North Dakota | 38099 | 139 | 1 |
465324 | 465324 | 2020-08-24 | Walsh | North Dakota | 38099 | 138 | 1 |
462095 | 462095 | 2020-08-23 | Walsh | North Dakota | 38099 | 137 | 1 |
458867 | 458867 | 2020-08-22 | Walsh | North Dakota | 38099 | 137 | 1 |
455639 | 455639 | 2020-08-21 | Walsh | North Dakota | 38099 | 137 | 0 |
452411 | 452411 | 2020-08-20 | Walsh | North Dakota | 38099 | 132 | 0 |
449183 | 449183 | 2020-08-19 | Walsh | North Dakota | 38099 | 127 | 0 |
445955 | 445955 | 2020-08-18 | Walsh | North Dakota | 38099 | 122 | 0 |
442729 | 442729 | 2020-08-17 | Walsh | North Dakota | 38099 | 116 | 0 |
439502 | 439502 | 2020-08-16 | Walsh | North Dakota | 38099 | 116 | 0 |
436277 | 436277 | 2020-08-15 | Walsh | North Dakota | 38099 | 114 | 0 |
433051 | 433051 | 2020-08-14 | Walsh | North Dakota | 38099 | 112 | 0 |
429825 | 429825 | 2020-08-13 | Walsh | North Dakota | 38099 | 107 | 0 |
426600 | 426600 | 2020-08-12 | Walsh | North Dakota | 38099 | 106 | 0 |
423377 | 423377 | 2020-08-11 | Walsh | North Dakota | 38099 | 106 | 0 |
420154 | 420154 | 2020-08-10 | Walsh | North Dakota | 38099 | 104 | 0 |
416934 | 416934 | 2020-08-09 | Walsh | North Dakota | 38099 | 104 | 0 |
413713 | 413713 | 2020-08-08 | Walsh | North Dakota | 38099 | 104 | 0 |
410493 | 410493 | 2020-08-07 | Walsh | North Dakota | 38099 | 103 | 0 |
407273 | 407273 | 2020-08-06 | Walsh | North Dakota | 38099 | 103 | 0 |
404054 | 404054 | 2020-08-05 | Walsh | North Dakota | 38099 | 101 | 0 |
400836 | 400836 | 2020-08-04 | Walsh | North Dakota | 38099 | 99 | 0 |
397621 | 397621 | 2020-08-03 | Walsh | North Dakota | 38099 | 98 | 0 |
394404 | 394404 | 2020-08-02 | Walsh | North Dakota | 38099 | 98 | 0 |
391188 | 391188 | 2020-08-01 | Walsh | North Dakota | 38099 | 98 | 0 |
387971 | 387971 | 2020-07-31 | Walsh | North Dakota | 38099 | 96 | 0 |
384754 | 384754 | 2020-07-30 | Walsh | North Dakota | 38099 | 94 | 0 |
381536 | 381536 | 2020-07-29 | Walsh | North Dakota | 38099 | 94 | 0 |
378319 | 378319 | 2020-07-28 | Walsh | North Dakota | 38099 | 94 | 0 |
375102 | 375102 | 2020-07-27 | Walsh | North Dakota | 38099 | 95 | 0 |
371890 | 371890 | 2020-07-26 | Walsh | North Dakota | 38099 | 95 | 0 |
368678 | 368678 | 2020-07-25 | Walsh | North Dakota | 38099 | 95 | 0 |
365469 | 365469 | 2020-07-24 | Walsh | North Dakota | 38099 | 87 | 0 |
362263 | 362263 | 2020-07-23 | Walsh | North Dakota | 38099 | 86 | 0 |
359057 | 359057 | 2020-07-22 | Walsh | North Dakota | 38099 | 85 | 0 |
355853 | 355853 | 2020-07-21 | Walsh | North Dakota | 38099 | 83 | 0 |
352650 | 352650 | 2020-07-20 | Walsh | North Dakota | 38099 | 79 | 0 |
349447 | 349447 | 2020-07-19 | Walsh | North Dakota | 38099 | 77 | 0 |
346246 | 346246 | 2020-07-18 | Walsh | North Dakota | 38099 | 70 | 0 |
343047 | 343047 | 2020-07-17 | Walsh | North Dakota | 38099 | 66 | 0 |
339849 | 339849 | 2020-07-16 | Walsh | North Dakota | 38099 | 66 | 0 |
336653 | 336653 | 2020-07-15 | Walsh | North Dakota | 38099 | 65 | 0 |
333459 | 333459 | 2020-07-14 | Walsh | North Dakota | 38099 | 60 | 0 |
330268 | 330268 | 2020-07-13 | Walsh | North Dakota | 38099 | 59 | 0 |
327081 | 327081 | 2020-07-12 | Walsh | North Dakota | 38099 | 48 | 0 |
323896 | 323896 | 2020-07-11 | Walsh | North Dakota | 38099 | 46 | 0 |
320716 | 320716 | 2020-07-10 | Walsh | North Dakota | 38099 | 44 | 0 |
317539 | 317539 | 2020-07-09 | Walsh | North Dakota | 38099 | 41 | 0 |
314366 | 314366 | 2020-07-08 | Walsh | North Dakota | 38099 | 31 | 0 |
311194 | 311194 | 2020-07-07 | Walsh | North Dakota | 38099 | 30 | 0 |
308025 | 308025 | 2020-07-06 | Walsh | North Dakota | 38099 | 29 | 0 |
304858 | 304858 | 2020-07-05 | Walsh | North Dakota | 38099 | 28 | 0 |
301695 | 301695 | 2020-07-04 | Walsh | North Dakota | 38099 | 26 | 0 |
298532 | 298532 | 2020-07-03 | Walsh | North Dakota | 38099 | 26 | 0 |
295372 | 295372 | 2020-07-02 | Walsh | North Dakota | 38099 | 25 | 0 |
292217 | 292217 | 2020-07-01 | Walsh | North Dakota | 38099 | 24 | 0 |
289065 | 289065 | 2020-06-30 | Walsh | North Dakota | 38099 | 23 | 0 |
285915 | 285915 | 2020-06-29 | Walsh | North Dakota | 38099 | 22 | 0 |
282770 | 282770 | 2020-06-28 | Walsh | North Dakota | 38099 | 22 | 0 |
279624 | 279624 | 2020-06-27 | Walsh | North Dakota | 38099 | 21 | 0 |
276476 | 276476 | 2020-06-26 | Walsh | North Dakota | 38099 | 20 | 0 |
273329 | 273329 | 2020-06-25 | Walsh | North Dakota | 38099 | 20 | 0 |
270190 | 270190 | 2020-06-24 | Walsh | North Dakota | 38099 | 19 | 0 |
267056 | 267056 | 2020-06-23 | Walsh | North Dakota | 38099 | 17 | 0 |
263928 | 263928 | 2020-06-22 | Walsh | North Dakota | 38099 | 17 | 0 |
260800 | 260800 | 2020-06-21 | Walsh | North Dakota | 38099 | 17 | 0 |
257673 | 257673 | 2020-06-20 | Walsh | North Dakota | 38099 | 17 | 0 |
254548 | 254548 | 2020-06-19 | Walsh | North Dakota | 38099 | 17 | 0 |
251433 | 251433 | 2020-06-18 | Walsh | North Dakota | 38099 | 17 | 0 |
248318 | 248318 | 2020-06-17 | Walsh | North Dakota | 38099 | 17 | 0 |
245205 | 245205 | 2020-06-16 | Walsh | North Dakota | 38099 | 17 | 0 |
242093 | 242093 | 2020-06-15 | Walsh | North Dakota | 38099 | 16 | 0 |
238984 | 238984 | 2020-06-14 | Walsh | North Dakota | 38099 | 16 | 0 |
235876 | 235876 | 2020-06-13 | Walsh | North Dakota | 38099 | 16 | 0 |
232771 | 232771 | 2020-06-12 | Walsh | North Dakota | 38099 | 16 | 0 |
229666 | 229666 | 2020-06-11 | Walsh | North Dakota | 38099 | 16 | 0 |
226562 | 226562 | 2020-06-10 | Walsh | North Dakota | 38099 | 16 | 0 |
223462 | 223462 | 2020-06-09 | Walsh | North Dakota | 38099 | 16 | 0 |
220367 | 220367 | 2020-06-08 | Walsh | North Dakota | 38099 | 16 | 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);