ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where fips = 38043 and state = "North Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
223435 | 223435 | 2020-06-09 | Kidder | North Dakota | 38043 | 1 | 0 |
226535 | 226535 | 2020-06-10 | Kidder | North Dakota | 38043 | 2 | 0 |
229639 | 229639 | 2020-06-11 | Kidder | North Dakota | 38043 | 2 | 0 |
232744 | 232744 | 2020-06-12 | Kidder | North Dakota | 38043 | 2 | 0 |
235849 | 235849 | 2020-06-13 | Kidder | North Dakota | 38043 | 2 | 0 |
238957 | 238957 | 2020-06-14 | Kidder | North Dakota | 38043 | 2 | 0 |
242066 | 242066 | 2020-06-15 | Kidder | North Dakota | 38043 | 2 | 0 |
245178 | 245178 | 2020-06-16 | Kidder | North Dakota | 38043 | 2 | 0 |
248291 | 248291 | 2020-06-17 | Kidder | North Dakota | 38043 | 2 | 0 |
251406 | 251406 | 2020-06-18 | Kidder | North Dakota | 38043 | 2 | 0 |
254521 | 254521 | 2020-06-19 | Kidder | North Dakota | 38043 | 2 | 0 |
257646 | 257646 | 2020-06-20 | Kidder | North Dakota | 38043 | 2 | 0 |
260773 | 260773 | 2020-06-21 | Kidder | North Dakota | 38043 | 2 | 0 |
263901 | 263901 | 2020-06-22 | Kidder | North Dakota | 38043 | 2 | 0 |
267029 | 267029 | 2020-06-23 | Kidder | North Dakota | 38043 | 2 | 0 |
270163 | 270163 | 2020-06-24 | Kidder | North Dakota | 38043 | 2 | 0 |
273302 | 273302 | 2020-06-25 | Kidder | North Dakota | 38043 | 2 | 0 |
276449 | 276449 | 2020-06-26 | Kidder | North Dakota | 38043 | 2 | 0 |
279597 | 279597 | 2020-06-27 | Kidder | North Dakota | 38043 | 2 | 0 |
282743 | 282743 | 2020-06-28 | Kidder | North Dakota | 38043 | 2 | 0 |
285888 | 285888 | 2020-06-29 | Kidder | North Dakota | 38043 | 2 | 0 |
289038 | 289038 | 2020-06-30 | Kidder | North Dakota | 38043 | 2 | 0 |
292190 | 292190 | 2020-07-01 | Kidder | North Dakota | 38043 | 2 | 0 |
295345 | 295345 | 2020-07-02 | Kidder | North Dakota | 38043 | 2 | 0 |
298505 | 298505 | 2020-07-03 | Kidder | North Dakota | 38043 | 2 | 0 |
301668 | 301668 | 2020-07-04 | Kidder | North Dakota | 38043 | 2 | 0 |
304831 | 304831 | 2020-07-05 | Kidder | North Dakota | 38043 | 2 | 0 |
307998 | 307998 | 2020-07-06 | Kidder | North Dakota | 38043 | 2 | 0 |
311166 | 311166 | 2020-07-07 | Kidder | North Dakota | 38043 | 2 | 0 |
314337 | 314337 | 2020-07-08 | Kidder | North Dakota | 38043 | 2 | 0 |
317511 | 317511 | 2020-07-09 | Kidder | North Dakota | 38043 | 2 | 0 |
320688 | 320688 | 2020-07-10 | Kidder | North Dakota | 38043 | 2 | 0 |
323868 | 323868 | 2020-07-11 | Kidder | North Dakota | 38043 | 2 | 0 |
327052 | 327052 | 2020-07-12 | Kidder | North Dakota | 38043 | 3 | 0 |
330239 | 330239 | 2020-07-13 | Kidder | North Dakota | 38043 | 3 | 0 |
333430 | 333430 | 2020-07-14 | Kidder | North Dakota | 38043 | 3 | 0 |
336624 | 336624 | 2020-07-15 | Kidder | North Dakota | 38043 | 4 | 0 |
339820 | 339820 | 2020-07-16 | Kidder | North Dakota | 38043 | 4 | 0 |
343018 | 343018 | 2020-07-17 | Kidder | North Dakota | 38043 | 4 | 0 |
346217 | 346217 | 2020-07-18 | Kidder | North Dakota | 38043 | 4 | 0 |
349418 | 349418 | 2020-07-19 | Kidder | North Dakota | 38043 | 4 | 0 |
352621 | 352621 | 2020-07-20 | Kidder | North Dakota | 38043 | 4 | 0 |
355824 | 355824 | 2020-07-21 | Kidder | North Dakota | 38043 | 4 | 0 |
359028 | 359028 | 2020-07-22 | Kidder | North Dakota | 38043 | 5 | 0 |
362234 | 362234 | 2020-07-23 | Kidder | North Dakota | 38043 | 6 | 0 |
365440 | 365440 | 2020-07-24 | Kidder | North Dakota | 38043 | 7 | 0 |
368649 | 368649 | 2020-07-25 | Kidder | North Dakota | 38043 | 8 | 0 |
371861 | 371861 | 2020-07-26 | Kidder | North Dakota | 38043 | 8 | 0 |
375073 | 375073 | 2020-07-27 | Kidder | North Dakota | 38043 | 10 | 0 |
378290 | 378290 | 2020-07-28 | Kidder | North Dakota | 38043 | 10 | 0 |
381507 | 381507 | 2020-07-29 | Kidder | North Dakota | 38043 | 10 | 0 |
384725 | 384725 | 2020-07-30 | Kidder | North Dakota | 38043 | 10 | 0 |
387942 | 387942 | 2020-07-31 | Kidder | North Dakota | 38043 | 11 | 0 |
391159 | 391159 | 2020-08-01 | Kidder | North Dakota | 38043 | 11 | 0 |
394375 | 394375 | 2020-08-02 | Kidder | North Dakota | 38043 | 11 | 0 |
397592 | 397592 | 2020-08-03 | Kidder | North Dakota | 38043 | 11 | 0 |
400807 | 400807 | 2020-08-04 | Kidder | North Dakota | 38043 | 11 | 0 |
404025 | 404025 | 2020-08-05 | Kidder | North Dakota | 38043 | 12 | 0 |
407244 | 407244 | 2020-08-06 | Kidder | North Dakota | 38043 | 13 | 0 |
410464 | 410464 | 2020-08-07 | Kidder | North Dakota | 38043 | 13 | 0 |
413684 | 413684 | 2020-08-08 | Kidder | North Dakota | 38043 | 13 | 0 |
416905 | 416905 | 2020-08-09 | Kidder | North Dakota | 38043 | 14 | 0 |
420125 | 420125 | 2020-08-10 | Kidder | North Dakota | 38043 | 18 | 0 |
423348 | 423348 | 2020-08-11 | Kidder | North Dakota | 38043 | 18 | 0 |
426571 | 426571 | 2020-08-12 | Kidder | North Dakota | 38043 | 18 | 0 |
429796 | 429796 | 2020-08-13 | Kidder | North Dakota | 38043 | 19 | 0 |
433022 | 433022 | 2020-08-14 | Kidder | North Dakota | 38043 | 19 | 0 |
436248 | 436248 | 2020-08-15 | Kidder | North Dakota | 38043 | 22 | 0 |
439473 | 439473 | 2020-08-16 | Kidder | North Dakota | 38043 | 22 | 0 |
442700 | 442700 | 2020-08-17 | Kidder | North Dakota | 38043 | 23 | 0 |
445926 | 445926 | 2020-08-18 | Kidder | North Dakota | 38043 | 23 | 0 |
449154 | 449154 | 2020-08-19 | Kidder | North Dakota | 38043 | 24 | 0 |
452382 | 452382 | 2020-08-20 | Kidder | North Dakota | 38043 | 24 | 0 |
455610 | 455610 | 2020-08-21 | Kidder | North Dakota | 38043 | 24 | 0 |
458838 | 458838 | 2020-08-22 | Kidder | North Dakota | 38043 | 24 | 0 |
462066 | 462066 | 2020-08-23 | Kidder | North Dakota | 38043 | 24 | 0 |
465295 | 465295 | 2020-08-24 | Kidder | North Dakota | 38043 | 25 | 0 |
468523 | 468523 | 2020-08-25 | Kidder | North Dakota | 38043 | 27 | 0 |
471755 | 471755 | 2020-08-26 | Kidder | North Dakota | 38043 | 28 | 0 |
474989 | 474989 | 2020-08-27 | Kidder | North Dakota | 38043 | 29 | 0 |
478222 | 478222 | 2020-08-28 | Kidder | North Dakota | 38043 | 30 | 0 |
481455 | 481455 | 2020-08-29 | Kidder | North Dakota | 38043 | 32 | 0 |
484690 | 484690 | 2020-08-30 | Kidder | North Dakota | 38043 | 34 | 0 |
487923 | 487923 | 2020-08-31 | Kidder | North Dakota | 38043 | 34 | 0 |
491156 | 491156 | 2020-09-01 | Kidder | North Dakota | 38043 | 33 | 0 |
494390 | 494390 | 2020-09-02 | Kidder | North Dakota | 38043 | 33 | 0 |
497623 | 497623 | 2020-09-03 | Kidder | North Dakota | 38043 | 37 | 0 |
500857 | 500857 | 2020-09-04 | Kidder | North Dakota | 38043 | 37 | 0 |
504091 | 504091 | 2020-09-05 | Kidder | North Dakota | 38043 | 37 | 0 |
507323 | 507323 | 2020-09-06 | Kidder | North Dakota | 38043 | 37 | 0 |
510556 | 510556 | 2020-09-07 | Kidder | North Dakota | 38043 | 37 | 0 |
513789 | 513789 | 2020-09-08 | Kidder | North Dakota | 38043 | 38 | 0 |
517024 | 517024 | 2020-09-09 | Kidder | North Dakota | 38043 | 38 | 0 |
520260 | 520260 | 2020-09-10 | Kidder | North Dakota | 38043 | 38 | 0 |
523496 | 523496 | 2020-09-11 | Kidder | North Dakota | 38043 | 38 | 0 |
526732 | 526732 | 2020-09-12 | Kidder | North Dakota | 38043 | 38 | 0 |
529969 | 529969 | 2020-09-13 | Kidder | North Dakota | 38043 | 38 | 0 |
533204 | 533204 | 2020-09-14 | Kidder | North Dakota | 38043 | 38 | 0 |
536440 | 536440 | 2020-09-15 | Kidder | North Dakota | 38043 | 38 | 0 |
539677 | 539677 | 2020-09-16 | Kidder | North Dakota | 38043 | 38 | 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);