ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,446 rows where county = "Logan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 10
- Oklahoma 786
- Colorado 782
- Kentucky 782
- Ohio 782
- West Virginia 780
- Illinois 772
- Arkansas 768
- Kansas 689
- North Dakota 672
- Nebraska 633
fips 10
county 1
- Logan · 7,446 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4956 | 4956 | 2020-03-19 | Logan | Oklahoma | 40083 | 1 | 0 |
5823 | 5823 | 2020-03-20 | Logan | Oklahoma | 40083 | 1 | 0 |
6824 | 6824 | 2020-03-21 | Logan | Oklahoma | 40083 | 1 | 0 |
7937 | 7937 | 2020-03-22 | Logan | Oklahoma | 40083 | 1 | 0 |
8671 | 8671 | 2020-03-23 | Logan | Kentucky | 21141 | 1 | 0 |
9118 | 9118 | 2020-03-23 | Logan | Ohio | 39091 | 1 | 0 |
9145 | 9145 | 2020-03-23 | Logan | Oklahoma | 40083 | 1 | 0 |
9954 | 9954 | 2020-03-24 | Logan | Kentucky | 21141 | 1 | 0 |
10461 | 10461 | 2020-03-24 | Logan | Oklahoma | 40083 | 1 | 0 |
11356 | 11356 | 2020-03-25 | Logan | Kentucky | 21141 | 1 | 0 |
12313 | 12313 | 2020-03-25 | Logan | West Virginia | 54045 | 1 | 0 |
12927 | 12927 | 2020-03-26 | Logan | Kentucky | 21141 | 1 | 0 |
13964 | 13964 | 2020-03-26 | Logan | West Virginia | 54045 | 1 | 0 |
15735 | 15735 | 2020-03-27 | Logan | West Virginia | 54045 | 1 | 0 |
17615 | 17615 | 2020-03-28 | Logan | West Virginia | 54045 | 1 | 0 |
19581 | 19581 | 2020-03-29 | Logan | West Virginia | 54045 | 1 | 0 |
26635 | 26635 | 2020-04-02 | Logan | Illinois | 17107 | 1 | 0 |
28945 | 28945 | 2020-04-03 | Logan | Illinois | 17107 | 1 | 0 |
31309 | 31309 | 2020-04-04 | Logan | Illinois | 17107 | 1 | 0 |
33719 | 33719 | 2020-04-05 | Logan | Illinois | 17107 | 1 | 0 |
35724 | 35724 | 2020-04-06 | Logan | Arkansas | 5083 | 1 | 0 |
36171 | 36171 | 2020-04-06 | Logan | Illinois | 17107 | 1 | 0 |
38213 | 38213 | 2020-04-07 | Logan | Arkansas | 5083 | 1 | 0 |
40756 | 40756 | 2020-04-08 | Logan | Arkansas | 5083 | 1 | 0 |
43328 | 43328 | 2020-04-09 | Logan | Arkansas | 5083 | 1 | 0 |
269140 | 269140 | 2020-06-24 | Logan | Kansas | 20109 | 1 | 0 |
272277 | 272277 | 2020-06-25 | Logan | Kansas | 20109 | 1 | 0 |
275420 | 275420 | 2020-06-26 | Logan | Kansas | 20109 | 1 | 0 |
278568 | 278568 | 2020-06-27 | Logan | Kansas | 20109 | 1 | 0 |
281716 | 281716 | 2020-06-28 | Logan | Kansas | 20109 | 1 | 0 |
284861 | 284861 | 2020-06-29 | Logan | Kansas | 20109 | 1 | 0 |
288010 | 288010 | 2020-06-30 | Logan | Kansas | 20109 | 1 | 0 |
291160 | 291160 | 2020-07-01 | Logan | Kansas | 20109 | 1 | 0 |
294314 | 294314 | 2020-07-02 | Logan | Kansas | 20109 | 1 | 0 |
297472 | 297472 | 2020-07-03 | Logan | Kansas | 20109 | 1 | 0 |
300634 | 300634 | 2020-07-04 | Logan | Kansas | 20109 | 1 | 0 |
303798 | 303798 | 2020-07-05 | Logan | Kansas | 20109 | 1 | 0 |
306965 | 306965 | 2020-07-06 | Logan | Kansas | 20109 | 1 | 0 |
310133 | 310133 | 2020-07-07 | Logan | Kansas | 20109 | 1 | 0 |
313303 | 313303 | 2020-07-08 | Logan | Kansas | 20109 | 1 | 0 |
314339 | 314339 | 2020-07-08 | Logan | North Dakota | 38047 | 1 | 0 |
316477 | 316477 | 2020-07-09 | Logan | Kansas | 20109 | 1 | 0 |
319651 | 319651 | 2020-07-10 | Logan | Kansas | 20109 | 1 | 0 |
322830 | 322830 | 2020-07-11 | Logan | Kansas | 20109 | 1 | 0 |
327054 | 327054 | 2020-07-12 | Logan | North Dakota | 38047 | 1 | 0 |
330241 | 330241 | 2020-07-13 | Logan | North Dakota | 38047 | 1 | 0 |
333432 | 333432 | 2020-07-14 | Logan | North Dakota | 38047 | 1 | 0 |
336626 | 336626 | 2020-07-15 | Logan | North Dakota | 38047 | 1 | 0 |
339822 | 339822 | 2020-07-16 | Logan | North Dakota | 38047 | 1 | 0 |
343020 | 343020 | 2020-07-17 | Logan | North Dakota | 38047 | 1 | 0 |
346219 | 346219 | 2020-07-18 | Logan | North Dakota | 38047 | 1 | 0 |
349420 | 349420 | 2020-07-19 | Logan | North Dakota | 38047 | 1 | 0 |
352623 | 352623 | 2020-07-20 | Logan | North Dakota | 38047 | 1 | 0 |
355826 | 355826 | 2020-07-21 | Logan | North Dakota | 38047 | 1 | 0 |
359030 | 359030 | 2020-07-22 | Logan | North Dakota | 38047 | 1 | 0 |
362236 | 362236 | 2020-07-23 | Logan | North Dakota | 38047 | 1 | 0 |
365442 | 365442 | 2020-07-24 | Logan | North Dakota | 38047 | 1 | 0 |
368651 | 368651 | 2020-07-25 | Logan | North Dakota | 38047 | 1 | 0 |
371863 | 371863 | 2020-07-26 | Logan | North Dakota | 38047 | 1 | 0 |
375075 | 375075 | 2020-07-27 | Logan | North Dakota | 38047 | 1 | 0 |
448857 | 448857 | 2020-08-19 | Logan | Nebraska | 31113 | 1 | 0 |
8382 | 8382 | 2020-03-23 | Logan | Colorado | 8075 | 2 | 0 |
9627 | 9627 | 2020-03-24 | Logan | Colorado | 8075 | 2 | 0 |
10434 | 10434 | 2020-03-24 | Logan | Ohio | 39091 | 2 | 0 |
11000 | 11000 | 2020-03-25 | Logan | Colorado | 8075 | 2 | 0 |
11883 | 11883 | 2020-03-25 | Logan | Ohio | 39091 | 2 | 0 |
12546 | 12546 | 2020-03-26 | Logan | Colorado | 8075 | 2 | 0 |
13491 | 13491 | 2020-03-26 | Logan | Ohio | 39091 | 2 | 0 |
14633 | 14633 | 2020-03-27 | Logan | Kentucky | 21141 | 2 | 0 |
15229 | 15229 | 2020-03-27 | Logan | Ohio | 39091 | 2 | 0 |
16448 | 16448 | 2020-03-28 | Logan | Kentucky | 21141 | 2 | 0 |
18359 | 18359 | 2020-03-29 | Logan | Kentucky | 21141 | 2 | 0 |
20373 | 20373 | 2020-03-30 | Logan | Kentucky | 21141 | 2 | 0 |
21648 | 21648 | 2020-03-30 | Logan | West Virginia | 54045 | 2 | 0 |
22478 | 22478 | 2020-03-31 | Logan | Kentucky | 21141 | 2 | 0 |
23798 | 23798 | 2020-03-31 | Logan | West Virginia | 54045 | 2 | 0 |
24654 | 24654 | 2020-04-01 | Logan | Kentucky | 21141 | 2 | 0 |
26902 | 26902 | 2020-04-02 | Logan | Kentucky | 21141 | 2 | 0 |
29218 | 29218 | 2020-04-03 | Logan | Kentucky | 21141 | 2 | 0 |
31594 | 31594 | 2020-04-04 | Logan | Kentucky | 21141 | 2 | 0 |
38667 | 38667 | 2020-04-07 | Logan | Illinois | 17107 | 2 | 0 |
45927 | 45927 | 2020-04-10 | Logan | Arkansas | 5083 | 2 | 0 |
48557 | 48557 | 2020-04-11 | Logan | Arkansas | 5083 | 2 | 0 |
51219 | 51219 | 2020-04-12 | Logan | Arkansas | 5083 | 2 | 0 |
53898 | 53898 | 2020-04-13 | Logan | Arkansas | 5083 | 2 | 0 |
56590 | 56590 | 2020-04-14 | Logan | Arkansas | 5083 | 2 | 0 |
59298 | 59298 | 2020-04-15 | Logan | Arkansas | 5083 | 2 | 0 |
62017 | 62017 | 2020-04-16 | Logan | Arkansas | 5083 | 2 | 0 |
64750 | 64750 | 2020-04-17 | Logan | Arkansas | 5083 | 2 | 0 |
112615 | 112615 | 2020-05-04 | Logan | Arkansas | 5083 | 2 | 0 |
115498 | 115498 | 2020-05-05 | Logan | Arkansas | 5083 | 2 | 0 |
326013 | 326013 | 2020-07-12 | Logan | Kansas | 20109 | 2 | 0 |
329199 | 329199 | 2020-07-13 | Logan | Kansas | 20109 | 2 | 0 |
332386 | 332386 | 2020-07-14 | Logan | Kansas | 20109 | 2 | 0 |
335579 | 335579 | 2020-07-15 | Logan | Kansas | 20109 | 2 | 0 |
338775 | 338775 | 2020-07-16 | Logan | Kansas | 20109 | 2 | 0 |
341971 | 341971 | 2020-07-17 | Logan | Kansas | 20109 | 2 | 0 |
345171 | 345171 | 2020-07-18 | Logan | Kansas | 20109 | 2 | 0 |
348372 | 348372 | 2020-07-19 | Logan | Kansas | 20109 | 2 | 0 |
351572 | 351572 | 2020-07-20 | Logan | Kansas | 20109 | 2 | 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);