ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 38081 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 |
---|---|---|---|---|---|---|---|
536459 | 536459 | 2020-09-15 | Sargent | North Dakota | 38081 | 32 | 0 |
533223 | 533223 | 2020-09-14 | Sargent | North Dakota | 38081 | 30 | 0 |
529988 | 529988 | 2020-09-13 | Sargent | North Dakota | 38081 | 29 | 0 |
526751 | 526751 | 2020-09-12 | Sargent | North Dakota | 38081 | 29 | 0 |
523515 | 523515 | 2020-09-11 | Sargent | North Dakota | 38081 | 29 | 0 |
520279 | 520279 | 2020-09-10 | Sargent | North Dakota | 38081 | 28 | 0 |
517043 | 517043 | 2020-09-09 | Sargent | North Dakota | 38081 | 25 | 0 |
513808 | 513808 | 2020-09-08 | Sargent | North Dakota | 38081 | 20 | 0 |
510575 | 510575 | 2020-09-07 | Sargent | North Dakota | 38081 | 20 | 0 |
507342 | 507342 | 2020-09-06 | Sargent | North Dakota | 38081 | 19 | 0 |
504110 | 504110 | 2020-09-05 | Sargent | North Dakota | 38081 | 19 | 0 |
500876 | 500876 | 2020-09-04 | Sargent | North Dakota | 38081 | 18 | 0 |
497642 | 497642 | 2020-09-03 | Sargent | North Dakota | 38081 | 18 | 0 |
494409 | 494409 | 2020-09-02 | Sargent | North Dakota | 38081 | 18 | 0 |
491175 | 491175 | 2020-09-01 | Sargent | North Dakota | 38081 | 16 | 0 |
487942 | 487942 | 2020-08-31 | Sargent | North Dakota | 38081 | 17 | 0 |
484709 | 484709 | 2020-08-30 | Sargent | North Dakota | 38081 | 15 | 0 |
481474 | 481474 | 2020-08-29 | Sargent | North Dakota | 38081 | 15 | 0 |
478241 | 478241 | 2020-08-28 | Sargent | North Dakota | 38081 | 15 | 0 |
475008 | 475008 | 2020-08-27 | Sargent | North Dakota | 38081 | 13 | 0 |
471774 | 471774 | 2020-08-26 | Sargent | North Dakota | 38081 | 13 | 0 |
468542 | 468542 | 2020-08-25 | Sargent | North Dakota | 38081 | 12 | 0 |
465314 | 465314 | 2020-08-24 | Sargent | North Dakota | 38081 | 10 | 0 |
462085 | 462085 | 2020-08-23 | Sargent | North Dakota | 38081 | 10 | 0 |
458857 | 458857 | 2020-08-22 | Sargent | North Dakota | 38081 | 10 | 0 |
455629 | 455629 | 2020-08-21 | Sargent | North Dakota | 38081 | 10 | 0 |
452401 | 452401 | 2020-08-20 | Sargent | North Dakota | 38081 | 10 | 0 |
449173 | 449173 | 2020-08-19 | Sargent | North Dakota | 38081 | 10 | 0 |
445945 | 445945 | 2020-08-18 | Sargent | North Dakota | 38081 | 10 | 0 |
442719 | 442719 | 2020-08-17 | Sargent | North Dakota | 38081 | 10 | 0 |
439492 | 439492 | 2020-08-16 | Sargent | North Dakota | 38081 | 10 | 0 |
436267 | 436267 | 2020-08-15 | Sargent | North Dakota | 38081 | 10 | 0 |
433041 | 433041 | 2020-08-14 | Sargent | North Dakota | 38081 | 10 | 0 |
429815 | 429815 | 2020-08-13 | Sargent | North Dakota | 38081 | 10 | 0 |
426590 | 426590 | 2020-08-12 | Sargent | North Dakota | 38081 | 10 | 0 |
423367 | 423367 | 2020-08-11 | Sargent | North Dakota | 38081 | 10 | 0 |
420144 | 420144 | 2020-08-10 | Sargent | North Dakota | 38081 | 10 | 0 |
416924 | 416924 | 2020-08-09 | Sargent | North Dakota | 38081 | 10 | 0 |
413703 | 413703 | 2020-08-08 | Sargent | North Dakota | 38081 | 11 | 0 |
410483 | 410483 | 2020-08-07 | Sargent | North Dakota | 38081 | 11 | 0 |
407263 | 407263 | 2020-08-06 | Sargent | North Dakota | 38081 | 10 | 0 |
404044 | 404044 | 2020-08-05 | Sargent | North Dakota | 38081 | 10 | 0 |
400826 | 400826 | 2020-08-04 | Sargent | North Dakota | 38081 | 11 | 0 |
397611 | 397611 | 2020-08-03 | Sargent | North Dakota | 38081 | 9 | 0 |
394394 | 394394 | 2020-08-02 | Sargent | North Dakota | 38081 | 8 | 0 |
391178 | 391178 | 2020-08-01 | Sargent | North Dakota | 38081 | 8 | 0 |
387961 | 387961 | 2020-07-31 | Sargent | North Dakota | 38081 | 8 | 0 |
384744 | 384744 | 2020-07-30 | Sargent | North Dakota | 38081 | 9 | 0 |
381526 | 381526 | 2020-07-29 | Sargent | North Dakota | 38081 | 8 | 0 |
378309 | 378309 | 2020-07-28 | Sargent | North Dakota | 38081 | 8 | 0 |
375092 | 375092 | 2020-07-27 | Sargent | North Dakota | 38081 | 8 | 0 |
371880 | 371880 | 2020-07-26 | Sargent | North Dakota | 38081 | 8 | 0 |
368668 | 368668 | 2020-07-25 | Sargent | North Dakota | 38081 | 8 | 0 |
365459 | 365459 | 2020-07-24 | Sargent | North Dakota | 38081 | 9 | 0 |
362253 | 362253 | 2020-07-23 | Sargent | North Dakota | 38081 | 8 | 0 |
359047 | 359047 | 2020-07-22 | Sargent | North Dakota | 38081 | 9 | 0 |
355843 | 355843 | 2020-07-21 | Sargent | North Dakota | 38081 | 8 | 0 |
352640 | 352640 | 2020-07-20 | Sargent | North Dakota | 38081 | 8 | 0 |
349437 | 349437 | 2020-07-19 | Sargent | North Dakota | 38081 | 8 | 0 |
346236 | 346236 | 2020-07-18 | Sargent | North Dakota | 38081 | 8 | 0 |
343037 | 343037 | 2020-07-17 | Sargent | North Dakota | 38081 | 9 | 0 |
339839 | 339839 | 2020-07-16 | Sargent | North Dakota | 38081 | 8 | 0 |
336643 | 336643 | 2020-07-15 | Sargent | North Dakota | 38081 | 8 | 0 |
333449 | 333449 | 2020-07-14 | Sargent | North Dakota | 38081 | 8 | 0 |
330258 | 330258 | 2020-07-13 | Sargent | North Dakota | 38081 | 8 | 0 |
327071 | 327071 | 2020-07-12 | Sargent | North Dakota | 38081 | 8 | 0 |
323886 | 323886 | 2020-07-11 | Sargent | North Dakota | 38081 | 7 | 0 |
320706 | 320706 | 2020-07-10 | Sargent | North Dakota | 38081 | 7 | 0 |
317529 | 317529 | 2020-07-09 | Sargent | North Dakota | 38081 | 7 | 0 |
314356 | 314356 | 2020-07-08 | Sargent | North Dakota | 38081 | 7 | 0 |
311184 | 311184 | 2020-07-07 | Sargent | North Dakota | 38081 | 7 | 0 |
308016 | 308016 | 2020-07-06 | Sargent | North Dakota | 38081 | 6 | 0 |
304849 | 304849 | 2020-07-05 | Sargent | North Dakota | 38081 | 6 | 0 |
301686 | 301686 | 2020-07-04 | Sargent | North Dakota | 38081 | 6 | 0 |
298523 | 298523 | 2020-07-03 | Sargent | North Dakota | 38081 | 6 | 0 |
295363 | 295363 | 2020-07-02 | Sargent | North Dakota | 38081 | 6 | 0 |
292208 | 292208 | 2020-07-01 | Sargent | North Dakota | 38081 | 6 | 0 |
289056 | 289056 | 2020-06-30 | Sargent | North Dakota | 38081 | 6 | 0 |
285906 | 285906 | 2020-06-29 | Sargent | North Dakota | 38081 | 6 | 0 |
282761 | 282761 | 2020-06-28 | Sargent | North Dakota | 38081 | 6 | 0 |
279615 | 279615 | 2020-06-27 | Sargent | North Dakota | 38081 | 6 | 0 |
276467 | 276467 | 2020-06-26 | Sargent | North Dakota | 38081 | 6 | 0 |
273320 | 273320 | 2020-06-25 | Sargent | North Dakota | 38081 | 5 | 0 |
270181 | 270181 | 2020-06-24 | Sargent | North Dakota | 38081 | 4 | 0 |
267047 | 267047 | 2020-06-23 | Sargent | North Dakota | 38081 | 4 | 0 |
263919 | 263919 | 2020-06-22 | Sargent | North Dakota | 38081 | 4 | 0 |
260791 | 260791 | 2020-06-21 | Sargent | North Dakota | 38081 | 4 | 0 |
257664 | 257664 | 2020-06-20 | Sargent | North Dakota | 38081 | 4 | 0 |
254539 | 254539 | 2020-06-19 | Sargent | North Dakota | 38081 | 4 | 0 |
251424 | 251424 | 2020-06-18 | Sargent | North Dakota | 38081 | 5 | 0 |
248309 | 248309 | 2020-06-17 | Sargent | North Dakota | 38081 | 4 | 0 |
245196 | 245196 | 2020-06-16 | Sargent | North Dakota | 38081 | 4 | 0 |
242084 | 242084 | 2020-06-15 | Sargent | North Dakota | 38081 | 4 | 0 |
238975 | 238975 | 2020-06-14 | Sargent | North Dakota | 38081 | 4 | 0 |
235867 | 235867 | 2020-06-13 | Sargent | North Dakota | 38081 | 4 | 0 |
232762 | 232762 | 2020-06-12 | Sargent | North Dakota | 38081 | 4 | 0 |
229657 | 229657 | 2020-06-11 | Sargent | North Dakota | 38081 | 4 | 0 |
226553 | 226553 | 2020-06-10 | Sargent | North Dakota | 38081 | 4 | 0 |
223453 | 223453 | 2020-06-09 | Sargent | North Dakota | 38081 | 4 | 0 |
220358 | 220358 | 2020-06-08 | Sargent | North Dakota | 38081 | 4 | 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);