ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where county = "Crawford" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 10
county 1
- Crawford · 101 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
754842 | 754842 | 2020-11-21 | Crawford | Wisconsin | 55023 | 813 | 4 |
751596 | 751596 | 2020-11-20 | Crawford | Wisconsin | 55023 | 797 | 4 |
748350 | 748350 | 2020-11-19 | Crawford | Wisconsin | 55023 | 762 | 4 |
745104 | 745104 | 2020-11-18 | Crawford | Wisconsin | 55023 | 733 | 4 |
741857 | 741857 | 2020-11-17 | Crawford | Wisconsin | 55023 | 718 | 4 |
738610 | 738610 | 2020-11-16 | Crawford | Wisconsin | 55023 | 696 | 4 |
735366 | 735366 | 2020-11-15 | Crawford | Wisconsin | 55023 | 676 | 4 |
732120 | 732120 | 2020-11-14 | Crawford | Wisconsin | 55023 | 651 | 4 |
728875 | 728875 | 2020-11-13 | Crawford | Wisconsin | 55023 | 623 | 4 |
724751 | 724751 | 2020-11-12 | Crawford | Pennsylvania | 42039 | 883 | 4 |
725632 | 725632 | 2020-11-12 | Crawford | Wisconsin | 55023 | 597 | 4 |
721508 | 721508 | 2020-11-11 | Crawford | Pennsylvania | 42039 | 813 | 4 |
718265 | 718265 | 2020-11-10 | Crawford | Pennsylvania | 42039 | 765 | 4 |
715022 | 715022 | 2020-11-09 | Crawford | Pennsylvania | 42039 | 741 | 4 |
711778 | 711778 | 2020-11-08 | Crawford | Pennsylvania | 42039 | 730 | 4 |
708534 | 708534 | 2020-11-07 | Crawford | Pennsylvania | 42039 | 703 | 4 |
705291 | 705291 | 2020-11-06 | Crawford | Pennsylvania | 42039 | 687 | 4 |
702048 | 702048 | 2020-11-05 | Crawford | Pennsylvania | 42039 | 668 | 4 |
698804 | 698804 | 2020-11-04 | Crawford | Pennsylvania | 42039 | 650 | 4 |
583622 | 583622 | 2020-09-30 | Crawford | Illinois | 17033 | 466 | 4 |
580383 | 580383 | 2020-09-29 | Crawford | Illinois | 17033 | 459 | 4 |
581289 | 581289 | 2020-09-29 | Crawford | Missouri | 29055 | 407 | 4 |
577142 | 577142 | 2020-09-28 | Crawford | Illinois | 17033 | 458 | 4 |
578048 | 578048 | 2020-09-28 | Crawford | Missouri | 29055 | 407 | 4 |
574807 | 574807 | 2020-09-27 | Crawford | Missouri | 29055 | 402 | 4 |
571564 | 571564 | 2020-09-26 | Crawford | Missouri | 29055 | 397 | 4 |
568322 | 568322 | 2020-09-25 | Crawford | Missouri | 29055 | 391 | 4 |
565082 | 565082 | 2020-09-24 | Crawford | Missouri | 29055 | 388 | 4 |
561842 | 561842 | 2020-09-23 | Crawford | Missouri | 29055 | 369 | 4 |
557512 | 557512 | 2020-09-22 | Crawford | Georgia | 13079 | 166 | 4 |
554275 | 554275 | 2020-09-21 | Crawford | Georgia | 13079 | 165 | 4 |
551036 | 551036 | 2020-09-20 | Crawford | Georgia | 13079 | 165 | 4 |
551425 | 551425 | 2020-09-20 | Crawford | Iowa | 19047 | 1001 | 4 |
547797 | 547797 | 2020-09-19 | Crawford | Georgia | 13079 | 165 | 4 |
548186 | 548186 | 2020-09-19 | Crawford | Iowa | 19047 | 994 | 4 |
544559 | 544559 | 2020-09-18 | Crawford | Georgia | 13079 | 165 | 4 |
544948 | 544948 | 2020-09-18 | Crawford | Iowa | 19047 | 980 | 4 |
541323 | 541323 | 2020-09-17 | Crawford | Georgia | 13079 | 164 | 4 |
541712 | 541712 | 2020-09-17 | Crawford | Iowa | 19047 | 954 | 4 |
538086 | 538086 | 2020-09-16 | Crawford | Georgia | 13079 | 164 | 4 |
538475 | 538475 | 2020-09-16 | Crawford | Iowa | 19047 | 936 | 4 |
534850 | 534850 | 2020-09-15 | Crawford | Georgia | 13079 | 164 | 4 |
535239 | 535239 | 2020-09-15 | Crawford | Iowa | 19047 | 924 | 4 |
532004 | 532004 | 2020-09-14 | Crawford | Iowa | 19047 | 910 | 4 |
528767 | 528767 | 2020-09-13 | Crawford | Iowa | 19047 | 909 | 4 |
525142 | 525142 | 2020-09-12 | Crawford | Georgia | 13079 | 162 | 4 |
525531 | 525531 | 2020-09-12 | Crawford | Iowa | 19047 | 908 | 4 |
521906 | 521906 | 2020-09-11 | Crawford | Georgia | 13079 | 162 | 4 |
522295 | 522295 | 2020-09-11 | Crawford | Iowa | 19047 | 889 | 4 |
518669 | 518669 | 2020-09-10 | Crawford | Georgia | 13079 | 162 | 4 |
519153 | 519153 | 2020-09-10 | Crawford | Kansas | 20037 | 816 | 4 |
515434 | 515434 | 2020-09-09 | Crawford | Georgia | 13079 | 162 | 4 |
515918 | 515918 | 2020-09-09 | Crawford | Kansas | 20037 | 816 | 4 |
512201 | 512201 | 2020-09-08 | Crawford | Georgia | 13079 | 162 | 4 |
512685 | 512685 | 2020-09-08 | Crawford | Kansas | 20037 | 800 | 4 |
508968 | 508968 | 2020-09-07 | Crawford | Georgia | 13079 | 159 | 4 |
509452 | 509452 | 2020-09-07 | Crawford | Kansas | 20037 | 800 | 4 |
505736 | 505736 | 2020-09-06 | Crawford | Georgia | 13079 | 159 | 4 |
506220 | 506220 | 2020-09-06 | Crawford | Kansas | 20037 | 766 | 4 |
502986 | 502986 | 2020-09-05 | Crawford | Kansas | 20037 | 766 | 4 |
421466 | 421466 | 2020-08-11 | Crawford | Arkansas | 5033 | 648 | 4 |
418245 | 418245 | 2020-08-10 | Crawford | Arkansas | 5033 | 635 | 4 |
415024 | 415024 | 2020-08-09 | Crawford | Arkansas | 5033 | 627 | 4 |
411804 | 411804 | 2020-08-08 | Crawford | Arkansas | 5033 | 620 | 4 |
235897 | 235897 | 2020-06-13 | Crawford | Ohio | 39033 | 122 | 4 |
232792 | 232792 | 2020-06-12 | Crawford | Ohio | 39033 | 122 | 4 |
229687 | 229687 | 2020-06-11 | Crawford | Ohio | 39033 | 123 | 4 |
226583 | 226583 | 2020-06-10 | Crawford | Ohio | 39033 | 121 | 4 |
223483 | 223483 | 2020-06-09 | Crawford | Ohio | 39033 | 121 | 4 |
220388 | 220388 | 2020-06-08 | Crawford | Ohio | 39033 | 121 | 4 |
217296 | 217296 | 2020-06-07 | Crawford | Ohio | 39033 | 120 | 4 |
214206 | 214206 | 2020-06-06 | Crawford | Ohio | 39033 | 118 | 4 |
211120 | 211120 | 2020-06-05 | Crawford | Ohio | 39033 | 118 | 4 |
208038 | 208038 | 2020-06-04 | Crawford | Ohio | 39033 | 118 | 4 |
204957 | 204957 | 2020-06-03 | Crawford | Ohio | 39033 | 117 | 4 |
201880 | 201880 | 2020-06-02 | Crawford | Ohio | 39033 | 116 | 4 |
198805 | 198805 | 2020-06-01 | Crawford | Ohio | 39033 | 115 | 4 |
195732 | 195732 | 2020-05-31 | Crawford | Ohio | 39033 | 114 | 4 |
192662 | 192662 | 2020-05-30 | Crawford | Ohio | 39033 | 114 | 4 |
189598 | 189598 | 2020-05-29 | Crawford | Ohio | 39033 | 110 | 4 |
155430 | 155430 | 2020-05-18 | Crawford | Michigan | 26039 | 57 | 4 |
152416 | 152416 | 2020-05-17 | Crawford | Michigan | 26039 | 57 | 4 |
149405 | 149405 | 2020-05-16 | Crawford | Michigan | 26039 | 57 | 4 |
146400 | 146400 | 2020-05-15 | Crawford | Michigan | 26039 | 57 | 4 |
143400 | 143400 | 2020-05-14 | Crawford | Michigan | 26039 | 57 | 4 |
140405 | 140405 | 2020-05-13 | Crawford | Michigan | 26039 | 57 | 4 |
137411 | 137411 | 2020-05-12 | Crawford | Michigan | 26039 | 57 | 4 |
134421 | 134421 | 2020-05-11 | Crawford | Michigan | 26039 | 57 | 4 |
131430 | 131430 | 2020-05-10 | Crawford | Michigan | 26039 | 57 | 4 |
128440 | 128440 | 2020-05-09 | Crawford | Michigan | 26039 | 57 | 4 |
125453 | 125453 | 2020-05-08 | Crawford | Michigan | 26039 | 56 | 4 |
122471 | 122471 | 2020-05-07 | Crawford | Michigan | 26039 | 56 | 4 |
119499 | 119499 | 2020-05-06 | Crawford | Michigan | 26039 | 56 | 4 |
116538 | 116538 | 2020-05-05 | Crawford | Michigan | 26039 | 56 | 4 |
113657 | 113657 | 2020-05-04 | Crawford | Michigan | 26039 | 56 | 4 |
110779 | 110779 | 2020-05-03 | Crawford | Michigan | 26039 | 56 | 4 |
107907 | 107907 | 2020-05-02 | Crawford | Michigan | 26039 | 57 | 4 |
105043 | 105043 | 2020-05-01 | Crawford | Michigan | 26039 | 53 | 4 |
102183 | 102183 | 2020-04-30 | Crawford | Michigan | 26039 | 54 | 4 |
99331 | 99331 | 2020-04-29 | Crawford | Michigan | 26039 | 54 | 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);