ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 30029 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
279232 | 279232 | 2020-06-27 | Flathead | Montana | 30029 | 53 | 2 |
282380 | 282380 | 2020-06-28 | Flathead | Montana | 30029 | 53 | 2 |
285525 | 285525 | 2020-06-29 | Flathead | Montana | 30029 | 59 | 2 |
288675 | 288675 | 2020-06-30 | Flathead | Montana | 30029 | 58 | 2 |
291826 | 291826 | 2020-07-01 | Flathead | Montana | 30029 | 58 | 2 |
294980 | 294980 | 2020-07-02 | Flathead | Montana | 30029 | 62 | 2 |
298138 | 298138 | 2020-07-03 | Flathead | Montana | 30029 | 62 | 2 |
301301 | 301301 | 2020-07-04 | Flathead | Montana | 30029 | 63 | 2 |
304465 | 304465 | 2020-07-05 | Flathead | Montana | 30029 | 64 | 2 |
307632 | 307632 | 2020-07-06 | Flathead | Montana | 30029 | 65 | 2 |
310800 | 310800 | 2020-07-07 | Flathead | Montana | 30029 | 64 | 2 |
313971 | 313971 | 2020-07-08 | Flathead | Montana | 30029 | 64 | 2 |
317145 | 317145 | 2020-07-09 | Flathead | Montana | 30029 | 64 | 2 |
320320 | 320320 | 2020-07-10 | Flathead | Montana | 30029 | 64 | 2 |
323499 | 323499 | 2020-07-11 | Flathead | Montana | 30029 | 67 | 2 |
326683 | 326683 | 2020-07-12 | Flathead | Montana | 30029 | 66 | 2 |
329869 | 329869 | 2020-07-13 | Flathead | Montana | 30029 | 75 | 2 |
333056 | 333056 | 2020-07-14 | Flathead | Montana | 30029 | 84 | 2 |
336249 | 336249 | 2020-07-15 | Flathead | Montana | 30029 | 92 | 2 |
339446 | 339446 | 2020-07-16 | Flathead | Montana | 30029 | 97 | 2 |
342642 | 342642 | 2020-07-17 | Flathead | Montana | 30029 | 102 | 2 |
345842 | 345842 | 2020-07-18 | Flathead | Montana | 30029 | 112 | 2 |
349043 | 349043 | 2020-07-19 | Flathead | Montana | 30029 | 120 | 2 |
352243 | 352243 | 2020-07-20 | Flathead | Montana | 30029 | 132 | 2 |
355446 | 355446 | 2020-07-21 | Flathead | Montana | 30029 | 142 | 2 |
358649 | 358649 | 2020-07-22 | Flathead | Montana | 30029 | 149 | 2 |
361854 | 361854 | 2020-07-23 | Flathead | Montana | 30029 | 159 | 2 |
365061 | 365061 | 2020-07-24 | Flathead | Montana | 30029 | 172 | 2 |
368270 | 368270 | 2020-07-25 | Flathead | Montana | 30029 | 174 | 2 |
371481 | 371481 | 2020-07-26 | Flathead | Montana | 30029 | 190 | 2 |
374693 | 374693 | 2020-07-27 | Flathead | Montana | 30029 | 190 | 2 |
377908 | 377908 | 2020-07-28 | Flathead | Montana | 30029 | 201 | 2 |
381125 | 381125 | 2020-07-29 | Flathead | Montana | 30029 | 213 | 2 |
384341 | 384341 | 2020-07-30 | Flathead | Montana | 30029 | 220 | 2 |
387559 | 387559 | 2020-07-31 | Flathead | Montana | 30029 | 237 | 2 |
390776 | 390776 | 2020-08-01 | Flathead | Montana | 30029 | 253 | 2 |
393993 | 393993 | 2020-08-02 | Flathead | Montana | 30029 | 263 | 2 |
397209 | 397209 | 2020-08-03 | Flathead | Montana | 30029 | 263 | 2 |
400423 | 400423 | 2020-08-04 | Flathead | Montana | 30029 | 272 | 2 |
403640 | 403640 | 2020-08-05 | Flathead | Montana | 30029 | 276 | 2 |
406858 | 406858 | 2020-08-06 | Flathead | Montana | 30029 | 301 | 2 |
410078 | 410078 | 2020-08-07 | Flathead | Montana | 30029 | 322 | 2 |
413298 | 413298 | 2020-08-08 | Flathead | Montana | 30029 | 330 | 2 |
416518 | 416518 | 2020-08-09 | Flathead | Montana | 30029 | 330 | 2 |
419739 | 419739 | 2020-08-10 | Flathead | Montana | 30029 | 347 | 2 |
422961 | 422961 | 2020-08-11 | Flathead | Montana | 30029 | 352 | 2 |
426183 | 426183 | 2020-08-12 | Flathead | Montana | 30029 | 357 | 3 |
429407 | 429407 | 2020-08-13 | Flathead | Montana | 30029 | 364 | 3 |
432634 | 432634 | 2020-08-14 | Flathead | Montana | 30029 | 376 | 3 |
435860 | 435860 | 2020-08-15 | Flathead | Montana | 30029 | 385 | 3 |
439085 | 439085 | 2020-08-16 | Flathead | Montana | 30029 | 392 | 3 |
442312 | 442312 | 2020-08-17 | Flathead | Montana | 30029 | 407 | 3 |
445538 | 445538 | 2020-08-18 | Flathead | Montana | 30029 | 412 | 3 |
448764 | 448764 | 2020-08-19 | Flathead | Montana | 30029 | 414 | 3 |
451992 | 451992 | 2020-08-20 | Flathead | Montana | 30029 | 432 | 3 |
455220 | 455220 | 2020-08-21 | Flathead | Montana | 30029 | 449 | 3 |
458448 | 458448 | 2020-08-22 | Flathead | Montana | 30029 | 469 | 3 |
461675 | 461675 | 2020-08-23 | Flathead | Montana | 30029 | 479 | 3 |
464906 | 464906 | 2020-08-24 | Flathead | Montana | 30029 | 490 | 3 |
468135 | 468135 | 2020-08-25 | Flathead | Montana | 30029 | 506 | 3 |
471365 | 471365 | 2020-08-26 | Flathead | Montana | 30029 | 539 | 4 |
474597 | 474597 | 2020-08-27 | Flathead | Montana | 30029 | 545 | 4 |
477830 | 477830 | 2020-08-28 | Flathead | Montana | 30029 | 557 | 4 |
481062 | 481062 | 2020-08-29 | Flathead | Montana | 30029 | 585 | 7 |
484297 | 484297 | 2020-08-30 | Flathead | Montana | 30029 | 588 | 7 |
487531 | 487531 | 2020-08-31 | Flathead | Montana | 30029 | 599 | 7 |
490764 | 490764 | 2020-09-01 | Flathead | Montana | 30029 | 611 | 7 |
493998 | 493998 | 2020-09-02 | Flathead | Montana | 30029 | 626 | 7 |
497231 | 497231 | 2020-09-03 | Flathead | Montana | 30029 | 651 | 7 |
500465 | 500465 | 2020-09-04 | Flathead | Montana | 30029 | 663 | 9 |
503699 | 503699 | 2020-09-05 | Flathead | Montana | 30029 | 678 | 9 |
506932 | 506932 | 2020-09-06 | Flathead | Montana | 30029 | 684 | 9 |
510165 | 510165 | 2020-09-07 | Flathead | Montana | 30029 | 686 | 9 |
513397 | 513397 | 2020-09-08 | Flathead | Montana | 30029 | 691 | 9 |
516631 | 516631 | 2020-09-09 | Flathead | Montana | 30029 | 723 | 9 |
519866 | 519866 | 2020-09-10 | Flathead | Montana | 30029 | 727 | 9 |
523103 | 523103 | 2020-09-11 | Flathead | Montana | 30029 | 729 | 13 |
526339 | 526339 | 2020-09-12 | Flathead | Montana | 30029 | 729 | 13 |
529575 | 529575 | 2020-09-13 | Flathead | Montana | 30029 | 730 | 13 |
532811 | 532811 | 2020-09-14 | Flathead | Montana | 30029 | 731 | 13 |
536046 | 536046 | 2020-09-15 | Flathead | Montana | 30029 | 736 | 13 |
539283 | 539283 | 2020-09-16 | Flathead | Montana | 30029 | 734 | 13 |
542519 | 542519 | 2020-09-17 | Flathead | Montana | 30029 | 740 | 13 |
545756 | 545756 | 2020-09-18 | Flathead | Montana | 30029 | 782 | 13 |
548994 | 548994 | 2020-09-19 | Flathead | Montana | 30029 | 826 | 16 |
552233 | 552233 | 2020-09-20 | Flathead | Montana | 30029 | 863 | 16 |
555471 | 555471 | 2020-09-21 | Flathead | Montana | 30029 | 865 | 16 |
558708 | 558708 | 2020-09-22 | Flathead | Montana | 30029 | 903 | 16 |
561945 | 561945 | 2020-09-23 | Flathead | Montana | 30029 | 923 | 16 |
565186 | 565186 | 2020-09-24 | Flathead | Montana | 30029 | 934 | 16 |
568426 | 568426 | 2020-09-25 | Flathead | Montana | 30029 | 956 | 16 |
571668 | 571668 | 2020-09-26 | Flathead | Montana | 30029 | 988 | 17 |
574911 | 574911 | 2020-09-27 | Flathead | Montana | 30029 | 1034 | 17 |
578152 | 578152 | 2020-09-28 | Flathead | Montana | 30029 | 1062 | 17 |
581393 | 581393 | 2020-09-29 | Flathead | Montana | 30029 | 1112 | 18 |
584634 | 584634 | 2020-09-30 | Flathead | Montana | 30029 | 1176 | 19 |
587874 | 587874 | 2020-10-01 | Flathead | Montana | 30029 | 1242 | 19 |
591115 | 591115 | 2020-10-02 | Flathead | Montana | 30029 | 1265 | 19 |
594356 | 594356 | 2020-10-03 | Flathead | Montana | 30029 | 1313 | 19 |
597597 | 597597 | 2020-10-04 | Flathead | Montana | 30029 | 1385 | 19 |
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);