ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Richland" 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 |
---|---|---|---|---|---|---|---|
536457 | 536457 | 2020-09-15 | Richland | North Dakota | 38077 | 178 | 1 |
533221 | 533221 | 2020-09-14 | Richland | North Dakota | 38077 | 176 | 1 |
529986 | 529986 | 2020-09-13 | Richland | North Dakota | 38077 | 174 | 1 |
526749 | 526749 | 2020-09-12 | Richland | North Dakota | 38077 | 166 | 1 |
523513 | 523513 | 2020-09-11 | Richland | North Dakota | 38077 | 159 | 1 |
520277 | 520277 | 2020-09-10 | Richland | North Dakota | 38077 | 158 | 1 |
517041 | 517041 | 2020-09-09 | Richland | North Dakota | 38077 | 154 | 1 |
513806 | 513806 | 2020-09-08 | Richland | North Dakota | 38077 | 149 | 1 |
510573 | 510573 | 2020-09-07 | Richland | North Dakota | 38077 | 149 | 1 |
507340 | 507340 | 2020-09-06 | Richland | North Dakota | 38077 | 149 | 1 |
504108 | 504108 | 2020-09-05 | Richland | North Dakota | 38077 | 149 | 1 |
500874 | 500874 | 2020-09-04 | Richland | North Dakota | 38077 | 144 | 1 |
497640 | 497640 | 2020-09-03 | Richland | North Dakota | 38077 | 142 | 1 |
494407 | 494407 | 2020-09-02 | Richland | North Dakota | 38077 | 136 | 1 |
491173 | 491173 | 2020-09-01 | Richland | North Dakota | 38077 | 134 | 1 |
487940 | 487940 | 2020-08-31 | Richland | North Dakota | 38077 | 136 | 1 |
484707 | 484707 | 2020-08-30 | Richland | North Dakota | 38077 | 135 | 1 |
481472 | 481472 | 2020-08-29 | Richland | North Dakota | 38077 | 132 | 1 |
478239 | 478239 | 2020-08-28 | Richland | North Dakota | 38077 | 132 | 1 |
475006 | 475006 | 2020-08-27 | Richland | North Dakota | 38077 | 129 | 1 |
471772 | 471772 | 2020-08-26 | Richland | North Dakota | 38077 | 124 | 1 |
468540 | 468540 | 2020-08-25 | Richland | North Dakota | 38077 | 124 | 1 |
465312 | 465312 | 2020-08-24 | Richland | North Dakota | 38077 | 124 | 1 |
462083 | 462083 | 2020-08-23 | Richland | North Dakota | 38077 | 122 | 1 |
458855 | 458855 | 2020-08-22 | Richland | North Dakota | 38077 | 121 | 1 |
455627 | 455627 | 2020-08-21 | Richland | North Dakota | 38077 | 121 | 1 |
452399 | 452399 | 2020-08-20 | Richland | North Dakota | 38077 | 119 | 1 |
449171 | 449171 | 2020-08-19 | Richland | North Dakota | 38077 | 119 | 1 |
445943 | 445943 | 2020-08-18 | Richland | North Dakota | 38077 | 117 | 1 |
442717 | 442717 | 2020-08-17 | Richland | North Dakota | 38077 | 117 | 1 |
439490 | 439490 | 2020-08-16 | Richland | North Dakota | 38077 | 117 | 2 |
436265 | 436265 | 2020-08-15 | Richland | North Dakota | 38077 | 115 | 1 |
433039 | 433039 | 2020-08-14 | Richland | North Dakota | 38077 | 115 | 1 |
429813 | 429813 | 2020-08-13 | Richland | North Dakota | 38077 | 114 | 1 |
426588 | 426588 | 2020-08-12 | Richland | North Dakota | 38077 | 113 | 1 |
423365 | 423365 | 2020-08-11 | Richland | North Dakota | 38077 | 110 | 1 |
420142 | 420142 | 2020-08-10 | Richland | North Dakota | 38077 | 109 | 1 |
416922 | 416922 | 2020-08-09 | Richland | North Dakota | 38077 | 109 | 1 |
413701 | 413701 | 2020-08-08 | Richland | North Dakota | 38077 | 105 | 1 |
410481 | 410481 | 2020-08-07 | Richland | North Dakota | 38077 | 104 | 0 |
407261 | 407261 | 2020-08-06 | Richland | North Dakota | 38077 | 101 | 0 |
404042 | 404042 | 2020-08-05 | Richland | North Dakota | 38077 | 101 | 0 |
400824 | 400824 | 2020-08-04 | Richland | North Dakota | 38077 | 95 | 0 |
397609 | 397609 | 2020-08-03 | Richland | North Dakota | 38077 | 93 | 0 |
394392 | 394392 | 2020-08-02 | Richland | North Dakota | 38077 | 92 | 0 |
391176 | 391176 | 2020-08-01 | Richland | North Dakota | 38077 | 91 | 0 |
387959 | 387959 | 2020-07-31 | Richland | North Dakota | 38077 | 87 | 0 |
384742 | 384742 | 2020-07-30 | Richland | North Dakota | 38077 | 82 | 0 |
381524 | 381524 | 2020-07-29 | Richland | North Dakota | 38077 | 77 | 0 |
378307 | 378307 | 2020-07-28 | Richland | North Dakota | 38077 | 77 | 0 |
375090 | 375090 | 2020-07-27 | Richland | North Dakota | 38077 | 75 | 0 |
371878 | 371878 | 2020-07-26 | Richland | North Dakota | 38077 | 71 | 0 |
368666 | 368666 | 2020-07-25 | Richland | North Dakota | 38077 | 69 | 0 |
365457 | 365457 | 2020-07-24 | Richland | North Dakota | 38077 | 66 | 0 |
362251 | 362251 | 2020-07-23 | Richland | North Dakota | 38077 | 58 | 0 |
359045 | 359045 | 2020-07-22 | Richland | North Dakota | 38077 | 57 | 0 |
355841 | 355841 | 2020-07-21 | Richland | North Dakota | 38077 | 53 | 0 |
352638 | 352638 | 2020-07-20 | Richland | North Dakota | 38077 | 52 | 0 |
349435 | 349435 | 2020-07-19 | Richland | North Dakota | 38077 | 51 | 0 |
346234 | 346234 | 2020-07-18 | Richland | North Dakota | 38077 | 49 | 0 |
343035 | 343035 | 2020-07-17 | Richland | North Dakota | 38077 | 49 | 0 |
339837 | 339837 | 2020-07-16 | Richland | North Dakota | 38077 | 48 | 0 |
336641 | 336641 | 2020-07-15 | Richland | North Dakota | 38077 | 47 | 0 |
333447 | 333447 | 2020-07-14 | Richland | North Dakota | 38077 | 47 | 0 |
330256 | 330256 | 2020-07-13 | Richland | North Dakota | 38077 | 47 | 0 |
327069 | 327069 | 2020-07-12 | Richland | North Dakota | 38077 | 47 | 0 |
323884 | 323884 | 2020-07-11 | Richland | North Dakota | 38077 | 47 | 0 |
320704 | 320704 | 2020-07-10 | Richland | North Dakota | 38077 | 45 | 0 |
317527 | 317527 | 2020-07-09 | Richland | North Dakota | 38077 | 44 | 0 |
314354 | 314354 | 2020-07-08 | Richland | North Dakota | 38077 | 43 | 0 |
311182 | 311182 | 2020-07-07 | Richland | North Dakota | 38077 | 43 | 0 |
308014 | 308014 | 2020-07-06 | Richland | North Dakota | 38077 | 43 | 0 |
304847 | 304847 | 2020-07-05 | Richland | North Dakota | 38077 | 43 | 0 |
301684 | 301684 | 2020-07-04 | Richland | North Dakota | 38077 | 43 | 0 |
298521 | 298521 | 2020-07-03 | Richland | North Dakota | 38077 | 42 | 0 |
295361 | 295361 | 2020-07-02 | Richland | North Dakota | 38077 | 41 | 0 |
292206 | 292206 | 2020-07-01 | Richland | North Dakota | 38077 | 41 | 0 |
289054 | 289054 | 2020-06-30 | Richland | North Dakota | 38077 | 41 | 0 |
285904 | 285904 | 2020-06-29 | Richland | North Dakota | 38077 | 41 | 0 |
282759 | 282759 | 2020-06-28 | Richland | North Dakota | 38077 | 41 | 0 |
279613 | 279613 | 2020-06-27 | Richland | North Dakota | 38077 | 41 | 0 |
276465 | 276465 | 2020-06-26 | Richland | North Dakota | 38077 | 41 | 0 |
273318 | 273318 | 2020-06-25 | Richland | North Dakota | 38077 | 41 | 0 |
270179 | 270179 | 2020-06-24 | Richland | North Dakota | 38077 | 39 | 0 |
267045 | 267045 | 2020-06-23 | Richland | North Dakota | 38077 | 39 | 0 |
263917 | 263917 | 2020-06-22 | Richland | North Dakota | 38077 | 39 | 0 |
260789 | 260789 | 2020-06-21 | Richland | North Dakota | 38077 | 38 | 0 |
257662 | 257662 | 2020-06-20 | Richland | North Dakota | 38077 | 38 | 0 |
254537 | 254537 | 2020-06-19 | Richland | North Dakota | 38077 | 37 | 0 |
251422 | 251422 | 2020-06-18 | Richland | North Dakota | 38077 | 37 | 0 |
248307 | 248307 | 2020-06-17 | Richland | North Dakota | 38077 | 37 | 0 |
245194 | 245194 | 2020-06-16 | Richland | North Dakota | 38077 | 37 | 0 |
242082 | 242082 | 2020-06-15 | Richland | North Dakota | 38077 | 37 | 0 |
238973 | 238973 | 2020-06-14 | Richland | North Dakota | 38077 | 37 | 0 |
235865 | 235865 | 2020-06-13 | Richland | North Dakota | 38077 | 36 | 0 |
232760 | 232760 | 2020-06-12 | Richland | North Dakota | 38077 | 33 | 0 |
229655 | 229655 | 2020-06-11 | Richland | North Dakota | 38077 | 32 | 0 |
226551 | 226551 | 2020-06-10 | Richland | North Dakota | 38077 | 31 | 0 |
223451 | 223451 | 2020-06-09 | Richland | North Dakota | 38077 | 30 | 0 |
220356 | 220356 | 2020-06-08 | Richland | North Dakota | 38077 | 28 | 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);