ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
444 rows where county = "Crawford" and deaths = 5 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 11
county 1
- Crawford · 444 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
424687 | 424687 | 2020-08-12 | Crawford | Arkansas | 5033 | 668 | 5 |
427911 | 427911 | 2020-08-13 | Crawford | Arkansas | 5033 | 682 | 5 |
431139 | 431139 | 2020-08-14 | Crawford | Arkansas | 5033 | 695 | 5 |
434364 | 434364 | 2020-08-15 | Crawford | Arkansas | 5033 | 711 | 5 |
437590 | 437590 | 2020-08-16 | Crawford | Arkansas | 5033 | 736 | 5 |
440816 | 440816 | 2020-08-17 | Crawford | Arkansas | 5033 | 746 | 5 |
444042 | 444042 | 2020-08-18 | Crawford | Arkansas | 5033 | 757 | 5 |
447269 | 447269 | 2020-08-19 | Crawford | Arkansas | 5033 | 768 | 5 |
528378 | 528378 | 2020-09-13 | Crawford | Georgia | 13079 | 163 | 5 |
531615 | 531615 | 2020-09-14 | Crawford | Georgia | 13079 | 163 | 5 |
560748 | 560748 | 2020-09-23 | Crawford | Georgia | 13079 | 166 | 5 |
563988 | 563988 | 2020-09-24 | Crawford | Georgia | 13079 | 166 | 5 |
567228 | 567228 | 2020-09-25 | Crawford | Georgia | 13079 | 166 | 5 |
570470 | 570470 | 2020-09-26 | Crawford | Georgia | 13079 | 167 | 5 |
573712 | 573712 | 2020-09-27 | Crawford | Georgia | 13079 | 167 | 5 |
576955 | 576955 | 2020-09-28 | Crawford | Georgia | 13079 | 167 | 5 |
580196 | 580196 | 2020-09-29 | Crawford | Georgia | 13079 | 166 | 5 |
583435 | 583435 | 2020-09-30 | Crawford | Georgia | 13079 | 167 | 5 |
586675 | 586675 | 2020-10-01 | Crawford | Georgia | 13079 | 168 | 5 |
589916 | 589916 | 2020-10-02 | Crawford | Georgia | 13079 | 169 | 5 |
593156 | 593156 | 2020-10-03 | Crawford | Georgia | 13079 | 169 | 5 |
596398 | 596398 | 2020-10-04 | Crawford | Georgia | 13079 | 170 | 5 |
599641 | 599641 | 2020-10-05 | Crawford | Georgia | 13079 | 188 | 5 |
602884 | 602884 | 2020-10-06 | Crawford | Georgia | 13079 | 188 | 5 |
606126 | 606126 | 2020-10-07 | Crawford | Georgia | 13079 | 188 | 5 |
609369 | 609369 | 2020-10-08 | Crawford | Georgia | 13079 | 192 | 5 |
586862 | 586862 | 2020-10-01 | Crawford | Illinois | 17033 | 472 | 5 |
590103 | 590103 | 2020-10-02 | Crawford | Illinois | 17033 | 473 | 5 |
807562 | 807562 | 2020-12-08 | Crawford | Indiana | 18025 | 418 | 5 |
554664 | 554664 | 2020-09-21 | Crawford | Iowa | 19047 | 1014 | 5 |
557901 | 557901 | 2020-09-22 | Crawford | Iowa | 19047 | 1022 | 5 |
561137 | 561137 | 2020-09-23 | Crawford | Iowa | 19047 | 1042 | 5 |
564377 | 564377 | 2020-09-24 | Crawford | Iowa | 19047 | 1065 | 5 |
567617 | 567617 | 2020-09-25 | Crawford | Iowa | 19047 | 1077 | 5 |
570859 | 570859 | 2020-09-26 | Crawford | Iowa | 19047 | 1088 | 5 |
574102 | 574102 | 2020-09-27 | Crawford | Iowa | 19047 | 1091 | 5 |
577344 | 577344 | 2020-09-28 | Crawford | Iowa | 19047 | 1100 | 5 |
522390 | 522390 | 2020-09-11 | Crawford | Kansas | 20037 | 855 | 5 |
525626 | 525626 | 2020-09-12 | Crawford | Kansas | 20037 | 855 | 5 |
528862 | 528862 | 2020-09-13 | Crawford | Kansas | 20037 | 855 | 5 |
532099 | 532099 | 2020-09-14 | Crawford | Kansas | 20037 | 891 | 5 |
535334 | 535334 | 2020-09-15 | Crawford | Kansas | 20037 | 891 | 5 |
538570 | 538570 | 2020-09-16 | Crawford | Kansas | 20037 | 912 | 5 |
541807 | 541807 | 2020-09-17 | Crawford | Kansas | 20037 | 912 | 5 |
158448 | 158448 | 2020-05-19 | Crawford | Michigan | 26039 | 57 | 5 |
161474 | 161474 | 2020-05-20 | Crawford | Michigan | 26039 | 58 | 5 |
164503 | 164503 | 2020-05-21 | Crawford | Michigan | 26039 | 58 | 5 |
167539 | 167539 | 2020-05-22 | Crawford | Michigan | 26039 | 58 | 5 |
170576 | 170576 | 2020-05-23 | Crawford | Michigan | 26039 | 58 | 5 |
173618 | 173618 | 2020-05-24 | Crawford | Michigan | 26039 | 58 | 5 |
176661 | 176661 | 2020-05-25 | Crawford | Michigan | 26039 | 58 | 5 |
179705 | 179705 | 2020-05-26 | Crawford | Michigan | 26039 | 58 | 5 |
182751 | 182751 | 2020-05-27 | Crawford | Michigan | 26039 | 58 | 5 |
185806 | 185806 | 2020-05-28 | Crawford | Michigan | 26039 | 58 | 5 |
188864 | 188864 | 2020-05-29 | Crawford | Michigan | 26039 | 58 | 5 |
191928 | 191928 | 2020-05-30 | Crawford | Michigan | 26039 | 58 | 5 |
194996 | 194996 | 2020-05-31 | Crawford | Michigan | 26039 | 58 | 5 |
198067 | 198067 | 2020-06-01 | Crawford | Michigan | 26039 | 62 | 5 |
201139 | 201139 | 2020-06-02 | Crawford | Michigan | 26039 | 62 | 5 |
204216 | 204216 | 2020-06-03 | Crawford | Michigan | 26039 | 63 | 5 |
207297 | 207297 | 2020-06-04 | Crawford | Michigan | 26039 | 63 | 5 |
210378 | 210378 | 2020-06-05 | Crawford | Michigan | 26039 | 63 | 5 |
213462 | 213462 | 2020-06-06 | Crawford | Michigan | 26039 | 63 | 5 |
216550 | 216550 | 2020-06-07 | Crawford | Michigan | 26039 | 63 | 5 |
219642 | 219642 | 2020-06-08 | Crawford | Michigan | 26039 | 63 | 5 |
222737 | 222737 | 2020-06-09 | Crawford | Michigan | 26039 | 63 | 5 |
225834 | 225834 | 2020-06-10 | Crawford | Michigan | 26039 | 63 | 5 |
228936 | 228936 | 2020-06-11 | Crawford | Michigan | 26039 | 63 | 5 |
232040 | 232040 | 2020-06-12 | Crawford | Michigan | 26039 | 63 | 5 |
235145 | 235145 | 2020-06-13 | Crawford | Michigan | 26039 | 63 | 5 |
238252 | 238252 | 2020-06-14 | Crawford | Michigan | 26039 | 63 | 5 |
241361 | 241361 | 2020-06-15 | Crawford | Michigan | 26039 | 65 | 5 |
244472 | 244472 | 2020-06-16 | Crawford | Michigan | 26039 | 65 | 5 |
247585 | 247585 | 2020-06-17 | Crawford | Michigan | 26039 | 65 | 5 |
250697 | 250697 | 2020-06-18 | Crawford | Michigan | 26039 | 65 | 5 |
253812 | 253812 | 2020-06-19 | Crawford | Michigan | 26039 | 66 | 5 |
256932 | 256932 | 2020-06-20 | Crawford | Michigan | 26039 | 66 | 5 |
260058 | 260058 | 2020-06-21 | Crawford | Michigan | 26039 | 66 | 5 |
263187 | 263187 | 2020-06-22 | Crawford | Michigan | 26039 | 66 | 5 |
266313 | 266313 | 2020-06-23 | Crawford | Michigan | 26039 | 66 | 5 |
269446 | 269446 | 2020-06-24 | Crawford | Michigan | 26039 | 68 | 5 |
272583 | 272583 | 2020-06-25 | Crawford | Michigan | 26039 | 68 | 5 |
275726 | 275726 | 2020-06-26 | Crawford | Michigan | 26039 | 68 | 5 |
278874 | 278874 | 2020-06-27 | Crawford | Michigan | 26039 | 68 | 5 |
282022 | 282022 | 2020-06-28 | Crawford | Michigan | 26039 | 68 | 5 |
285167 | 285167 | 2020-06-29 | Crawford | Michigan | 26039 | 71 | 5 |
288317 | 288317 | 2020-06-30 | Crawford | Michigan | 26039 | 70 | 5 |
291468 | 291468 | 2020-07-01 | Crawford | Michigan | 26039 | 70 | 5 |
294622 | 294622 | 2020-07-02 | Crawford | Michigan | 26039 | 70 | 5 |
297780 | 297780 | 2020-07-03 | Crawford | Michigan | 26039 | 70 | 5 |
300942 | 300942 | 2020-07-04 | Crawford | Michigan | 26039 | 70 | 5 |
304106 | 304106 | 2020-07-05 | Crawford | Michigan | 26039 | 70 | 5 |
307273 | 307273 | 2020-07-06 | Crawford | Michigan | 26039 | 70 | 5 |
310441 | 310441 | 2020-07-07 | Crawford | Michigan | 26039 | 81 | 5 |
313611 | 313611 | 2020-07-08 | Crawford | Michigan | 26039 | 81 | 5 |
316785 | 316785 | 2020-07-09 | Crawford | Michigan | 26039 | 81 | 5 |
319960 | 319960 | 2020-07-10 | Crawford | Michigan | 26039 | 82 | 5 |
323139 | 323139 | 2020-07-11 | Crawford | Michigan | 26039 | 82 | 5 |
326322 | 326322 | 2020-07-12 | Crawford | Michigan | 26039 | 86 | 5 |
329508 | 329508 | 2020-07-13 | Crawford | Michigan | 26039 | 84 | 5 |
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);