ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Unknown" and state = "North Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
47494 | 47494 | 2020-04-10 | Unknown | North Dakota | 0 | 1 | |
183459 | 183459 | 2020-05-27 | Unknown | North Dakota | 3 | 3 | |
186516 | 186516 | 2020-05-28 | Unknown | North Dakota | 3 | 3 | |
189576 | 189576 | 2020-05-29 | Unknown | North Dakota | 3 | 3 | |
192640 | 192640 | 2020-05-30 | Unknown | North Dakota | 3 | 3 | |
195710 | 195710 | 2020-05-31 | Unknown | North Dakota | 3 | 3 | |
198783 | 198783 | 2020-06-01 | Unknown | North Dakota | 3 | 3 | |
201858 | 201858 | 2020-06-02 | Unknown | North Dakota | 3 | 3 | |
204935 | 204935 | 2020-06-03 | Unknown | North Dakota | 3 | 3 | |
208016 | 208016 | 2020-06-04 | Unknown | North Dakota | 3 | 3 | |
211098 | 211098 | 2020-06-05 | Unknown | North Dakota | 3 | 3 | |
214184 | 214184 | 2020-06-06 | Unknown | North Dakota | 3 | 3 | |
217274 | 217274 | 2020-06-07 | Unknown | North Dakota | 3 | 3 | |
220366 | 220366 | 2020-06-08 | Unknown | North Dakota | 3 | 3 | |
223461 | 223461 | 2020-06-09 | Unknown | North Dakota | 3 | 3 | |
226561 | 226561 | 2020-06-10 | Unknown | North Dakota | 3 | 3 | |
229665 | 229665 | 2020-06-11 | Unknown | North Dakota | 3 | 3 | |
232770 | 232770 | 2020-06-12 | Unknown | North Dakota | 3 | 3 | |
235875 | 235875 | 2020-06-13 | Unknown | North Dakota | 3 | 3 | |
238983 | 238983 | 2020-06-14 | Unknown | North Dakota | 3 | 3 | |
242092 | 242092 | 2020-06-15 | Unknown | North Dakota | 3 | 3 | |
245204 | 245204 | 2020-06-16 | Unknown | North Dakota | 3 | 3 | |
520288 | 520288 | 2020-09-10 | Unknown | North Dakota | 3 | 3 | |
523524 | 523524 | 2020-09-11 | Unknown | North Dakota | 3 | 3 | |
526760 | 526760 | 2020-09-12 | Unknown | North Dakota | 3 | 3 | |
529997 | 529997 | 2020-09-13 | Unknown | North Dakota | 3 | 3 | |
533232 | 533232 | 2020-09-14 | Unknown | North Dakota | 3 | 3 | |
536468 | 536468 | 2020-09-15 | Unknown | North Dakota | 3 | 3 | |
539705 | 539705 | 2020-09-16 | Unknown | North Dakota | 3 | 3 | |
542941 | 542941 | 2020-09-17 | Unknown | North Dakota | 3 | 3 | |
546178 | 546178 | 2020-09-18 | Unknown | North Dakota | 3 | 3 | |
549417 | 549417 | 2020-09-19 | Unknown | North Dakota | 3 | 3 | |
552656 | 552656 | 2020-09-20 | Unknown | North Dakota | 3 | 3 | |
555893 | 555893 | 2020-09-21 | Unknown | North Dakota | 3 | 3 | |
559130 | 559130 | 2020-09-22 | Unknown | North Dakota | 3 | 3 | |
562367 | 562367 | 2020-09-23 | Unknown | North Dakota | 3 | 3 | |
565608 | 565608 | 2020-09-24 | Unknown | North Dakota | 3 | 3 | |
568849 | 568849 | 2020-09-25 | Unknown | North Dakota | 3 | 3 | |
572091 | 572091 | 2020-09-26 | Unknown | North Dakota | 3 | 3 | |
575335 | 575335 | 2020-09-27 | Unknown | North Dakota | 3 | 3 | |
578576 | 578576 | 2020-09-28 | Unknown | North Dakota | 3 | 3 | |
581816 | 581816 | 2020-09-29 | Unknown | North Dakota | 3 | 3 | |
585057 | 585057 | 2020-09-30 | Unknown | North Dakota | 3 | 3 | |
588297 | 588297 | 2020-10-01 | Unknown | North Dakota | 3 | 3 | |
591538 | 591538 | 2020-10-02 | Unknown | North Dakota | 3 | 3 | |
594779 | 594779 | 2020-10-03 | Unknown | North Dakota | 3 | 3 | |
598022 | 598022 | 2020-10-04 | Unknown | North Dakota | 3 | 3 | |
601265 | 601265 | 2020-10-05 | Unknown | North Dakota | 3 | 3 | |
248317 | 248317 | 2020-06-17 | Unknown | North Dakota | 4 | 4 | |
314365 | 314365 | 2020-07-08 | Unknown | North Dakota | 4 | 4 | |
317538 | 317538 | 2020-07-09 | Unknown | North Dakota | 4 | 4 | |
320715 | 320715 | 2020-07-10 | Unknown | North Dakota | 4 | 4 | |
323895 | 323895 | 2020-07-11 | Unknown | North Dakota | 4 | 4 | |
327080 | 327080 | 2020-07-12 | Unknown | North Dakota | 4 | 4 | |
330267 | 330267 | 2020-07-13 | Unknown | North Dakota | 4 | 4 | |
333458 | 333458 | 2020-07-14 | Unknown | North Dakota | 4 | 4 | |
336652 | 336652 | 2020-07-15 | Unknown | North Dakota | 4 | 4 | |
339848 | 339848 | 2020-07-16 | Unknown | North Dakota | 4 | 4 | |
343046 | 343046 | 2020-07-17 | Unknown | North Dakota | 4 | 4 | |
346245 | 346245 | 2020-07-18 | Unknown | North Dakota | 4 | 4 | |
349446 | 349446 | 2020-07-19 | Unknown | North Dakota | 4 | 4 | |
352649 | 352649 | 2020-07-20 | Unknown | North Dakota | 4 | 4 | |
355852 | 355852 | 2020-07-21 | Unknown | North Dakota | 4 | 4 | |
359056 | 359056 | 2020-07-22 | Unknown | North Dakota | 4 | 4 | |
362262 | 362262 | 2020-07-23 | Unknown | North Dakota | 4 | 4 | |
365468 | 365468 | 2020-07-24 | Unknown | North Dakota | 4 | 4 | |
368677 | 368677 | 2020-07-25 | Unknown | North Dakota | 4 | 4 | |
371889 | 371889 | 2020-07-26 | Unknown | North Dakota | 4 | 4 | |
375101 | 375101 | 2020-07-27 | Unknown | North Dakota | 4 | 4 | |
378318 | 378318 | 2020-07-28 | Unknown | North Dakota | 4 | 4 | |
381535 | 381535 | 2020-07-29 | Unknown | North Dakota | 4 | 4 | |
384753 | 384753 | 2020-07-30 | Unknown | North Dakota | 4 | 4 | |
387970 | 387970 | 2020-07-31 | Unknown | North Dakota | 4 | 4 | |
391187 | 391187 | 2020-08-01 | Unknown | North Dakota | 4 | 4 | |
394403 | 394403 | 2020-08-02 | Unknown | North Dakota | 4 | 4 | |
397620 | 397620 | 2020-08-03 | Unknown | North Dakota | 4 | 4 | |
400835 | 400835 | 2020-08-04 | Unknown | North Dakota | 4 | 4 | |
404053 | 404053 | 2020-08-05 | Unknown | North Dakota | 4 | 4 | |
407272 | 407272 | 2020-08-06 | Unknown | North Dakota | 4 | 4 | |
410492 | 410492 | 2020-08-07 | Unknown | North Dakota | 4 | 4 | |
413712 | 413712 | 2020-08-08 | Unknown | North Dakota | 4 | 4 | |
416933 | 416933 | 2020-08-09 | Unknown | North Dakota | 4 | 4 | |
420153 | 420153 | 2020-08-10 | Unknown | North Dakota | 4 | 4 | |
423376 | 423376 | 2020-08-11 | Unknown | North Dakota | 4 | 4 | |
426599 | 426599 | 2020-08-12 | Unknown | North Dakota | 4 | 4 | |
429824 | 429824 | 2020-08-13 | Unknown | North Dakota | 4 | 4 | |
433050 | 433050 | 2020-08-14 | Unknown | North Dakota | 4 | 4 | |
436276 | 436276 | 2020-08-15 | Unknown | North Dakota | 4 | 4 | |
439501 | 439501 | 2020-08-16 | Unknown | North Dakota | 4 | 4 | |
442728 | 442728 | 2020-08-17 | Unknown | North Dakota | 4 | 4 | |
445954 | 445954 | 2020-08-18 | Unknown | North Dakota | 4 | 4 | |
449182 | 449182 | 2020-08-19 | Unknown | North Dakota | 4 | 4 | |
452410 | 452410 | 2020-08-20 | Unknown | North Dakota | 4 | 4 | |
455638 | 455638 | 2020-08-21 | Unknown | North Dakota | 4 | 4 | |
458866 | 458866 | 2020-08-22 | Unknown | North Dakota | 4 | 4 | |
462094 | 462094 | 2020-08-23 | Unknown | North Dakota | 4 | 4 | |
465323 | 465323 | 2020-08-24 | Unknown | North Dakota | 4 | 4 | |
468551 | 468551 | 2020-08-25 | Unknown | North Dakota | 4 | 4 | |
471783 | 471783 | 2020-08-26 | Unknown | North Dakota | 4 | 4 | |
475017 | 475017 | 2020-08-27 | Unknown | North Dakota | 4 | 4 |
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);