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 date
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 |
8382 | 8382 | 2020-03-23 | Logan | Colorado | 8075 | 2 | 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 |
9627 | 9627 | 2020-03-24 | Logan | Colorado | 8075 | 2 | 0 |
9954 | 9954 | 2020-03-24 | Logan | Kentucky | 21141 | 1 | 0 |
10434 | 10434 | 2020-03-24 | Logan | Ohio | 39091 | 2 | 0 |
10461 | 10461 | 2020-03-24 | Logan | Oklahoma | 40083 | 1 | 0 |
11000 | 11000 | 2020-03-25 | Logan | Colorado | 8075 | 2 | 0 |
11356 | 11356 | 2020-03-25 | Logan | Kentucky | 21141 | 1 | 0 |
11883 | 11883 | 2020-03-25 | Logan | Ohio | 39091 | 2 | 0 |
11919 | 11919 | 2020-03-25 | Logan | Oklahoma | 40083 | 3 | 0 |
12313 | 12313 | 2020-03-25 | Logan | West Virginia | 54045 | 1 | 0 |
12546 | 12546 | 2020-03-26 | Logan | Colorado | 8075 | 2 | 0 |
12927 | 12927 | 2020-03-26 | Logan | Kentucky | 21141 | 1 | 0 |
13491 | 13491 | 2020-03-26 | Logan | Ohio | 39091 | 2 | 0 |
13532 | 13532 | 2020-03-26 | Logan | Oklahoma | 40083 | 3 | 0 |
13964 | 13964 | 2020-03-26 | Logan | West Virginia | 54045 | 1 | 0 |
14215 | 14215 | 2020-03-27 | Logan | Colorado | 8075 | 3 | 0 |
14633 | 14633 | 2020-03-27 | Logan | Kentucky | 21141 | 2 | 0 |
15229 | 15229 | 2020-03-27 | Logan | Ohio | 39091 | 2 | 0 |
15275 | 15275 | 2020-03-27 | Logan | Oklahoma | 40083 | 3 | 0 |
15735 | 15735 | 2020-03-27 | Logan | West Virginia | 54045 | 1 | 0 |
15998 | 15998 | 2020-03-28 | Logan | Colorado | 8075 | 5 | 0 |
16448 | 16448 | 2020-03-28 | Logan | Kentucky | 21141 | 2 | 0 |
17071 | 17071 | 2020-03-28 | Logan | Ohio | 39091 | 3 | 0 |
17121 | 17121 | 2020-03-28 | Logan | Oklahoma | 40083 | 3 | 0 |
17615 | 17615 | 2020-03-28 | Logan | West Virginia | 54045 | 1 | 0 |
17888 | 17888 | 2020-03-29 | Logan | Colorado | 8075 | 5 | 0 |
18359 | 18359 | 2020-03-29 | Logan | Kentucky | 21141 | 2 | 0 |
19005 | 19005 | 2020-03-29 | Logan | Ohio | 39091 | 3 | 0 |
19056 | 19056 | 2020-03-29 | Logan | Oklahoma | 40083 | 3 | 0 |
19581 | 19581 | 2020-03-29 | Logan | West Virginia | 54045 | 1 | 0 |
19866 | 19866 | 2020-03-30 | Logan | Colorado | 8075 | 5 | 0 |
20373 | 20373 | 2020-03-30 | Logan | Kentucky | 21141 | 2 | 0 |
21050 | 21050 | 2020-03-30 | Logan | Ohio | 39091 | 3 | 0 |
21105 | 21105 | 2020-03-30 | Logan | Oklahoma | 40083 | 4 | 0 |
21648 | 21648 | 2020-03-30 | Logan | West Virginia | 54045 | 2 | 0 |
21942 | 21942 | 2020-03-31 | Logan | Colorado | 8075 | 6 | 0 |
22478 | 22478 | 2020-03-31 | Logan | Kentucky | 21141 | 2 | 0 |
23182 | 23182 | 2020-03-31 | Logan | Ohio | 39091 | 3 | 0 |
23238 | 23238 | 2020-03-31 | Logan | Oklahoma | 40083 | 4 | 0 |
23798 | 23798 | 2020-03-31 | Logan | West Virginia | 54045 | 2 | 0 |
24101 | 24101 | 2020-04-01 | Logan | Colorado | 8075 | 6 | 0 |
24654 | 24654 | 2020-04-01 | Logan | Kentucky | 21141 | 2 | 0 |
25377 | 25377 | 2020-04-01 | Logan | Ohio | 39091 | 3 | 0 |
25435 | 25435 | 2020-04-01 | Logan | Oklahoma | 40083 | 4 | 0 |
26016 | 26016 | 2020-04-01 | Logan | West Virginia | 54045 | 3 | 0 |
26331 | 26331 | 2020-04-02 | Logan | Colorado | 8075 | 7 | 0 |
26635 | 26635 | 2020-04-02 | Logan | Illinois | 17107 | 1 | 0 |
26902 | 26902 | 2020-04-02 | Logan | Kentucky | 21141 | 2 | 0 |
27645 | 27645 | 2020-04-02 | Logan | Ohio | 39091 | 3 | 0 |
27707 | 27707 | 2020-04-02 | Logan | Oklahoma | 40083 | 5 | 0 |
28308 | 28308 | 2020-04-02 | Logan | West Virginia | 54045 | 4 | 0 |
28632 | 28632 | 2020-04-03 | Logan | Colorado | 8075 | 7 | 0 |
28945 | 28945 | 2020-04-03 | Logan | Illinois | 17107 | 1 | 0 |
29218 | 29218 | 2020-04-03 | Logan | Kentucky | 21141 | 2 | 0 |
29974 | 29974 | 2020-04-03 | Logan | Ohio | 39091 | 3 | 0 |
30037 | 30037 | 2020-04-03 | Logan | Oklahoma | 40083 | 5 | 0 |
30661 | 30661 | 2020-04-03 | Logan | West Virginia | 54045 | 4 | 0 |
30989 | 30989 | 2020-04-04 | Logan | Colorado | 8075 | 8 | 0 |
31309 | 31309 | 2020-04-04 | Logan | Illinois | 17107 | 1 | 0 |
31594 | 31594 | 2020-04-04 | Logan | Kentucky | 21141 | 2 | 0 |
32363 | 32363 | 2020-04-04 | Logan | Ohio | 39091 | 3 | 0 |
32426 | 32426 | 2020-04-04 | Logan | Oklahoma | 40083 | 6 | 0 |
33062 | 33062 | 2020-04-04 | Logan | West Virginia | 54045 | 5 | 0 |
33395 | 33395 | 2020-04-05 | Logan | Colorado | 8075 | 9 | 0 |
33719 | 33719 | 2020-04-05 | Logan | Illinois | 17107 | 1 | 0 |
34016 | 34016 | 2020-04-05 | Logan | Kentucky | 21141 | 4 | 0 |
34796 | 34796 | 2020-04-05 | Logan | Ohio | 39091 | 5 | 0 |
34860 | 34860 | 2020-04-05 | Logan | Oklahoma | 40083 | 6 | 0 |
35500 | 35500 | 2020-04-05 | Logan | West Virginia | 54045 | 5 | 0 |
35724 | 35724 | 2020-04-06 | Logan | Arkansas | 5083 | 1 | 0 |
35840 | 35840 | 2020-04-06 | Logan | Colorado | 8075 | 11 | 0 |
36171 | 36171 | 2020-04-06 | Logan | Illinois | 17107 | 1 | 0 |
36474 | 36474 | 2020-04-06 | Logan | Kentucky | 21141 | 4 | 0 |
37265 | 37265 | 2020-04-06 | Logan | Ohio | 39091 | 5 | 0 |
37334 | 37334 | 2020-04-06 | Logan | Oklahoma | 40083 | 6 | 0 |
37985 | 37985 | 2020-04-06 | Logan | West Virginia | 54045 | 6 | 0 |
38213 | 38213 | 2020-04-07 | Logan | Arkansas | 5083 | 1 | 0 |
38330 | 38330 | 2020-04-07 | Logan | Colorado | 8075 | 13 | 0 |
38667 | 38667 | 2020-04-07 | Logan | Illinois | 17107 | 2 | 0 |
38981 | 38981 | 2020-04-07 | Logan | Kentucky | 21141 | 4 | 0 |
39782 | 39782 | 2020-04-07 | Logan | Ohio | 39091 | 5 | 0 |
39854 | 39854 | 2020-04-07 | Logan | Oklahoma | 40083 | 6 | 0 |
40522 | 40522 | 2020-04-07 | Logan | West Virginia | 54045 | 7 | 0 |
40756 | 40756 | 2020-04-08 | Logan | Arkansas | 5083 | 1 | 0 |
40873 | 40873 | 2020-04-08 | Logan | Colorado | 8075 | 13 | 0 |
41212 | 41212 | 2020-04-08 | Logan | Illinois | 17107 | 3 | 0 |
41531 | 41531 | 2020-04-08 | Logan | Kentucky | 21141 | 5 | 0 |
42342 | 42342 | 2020-04-08 | Logan | Ohio | 39091 | 5 | 0 |
42414 | 42414 | 2020-04-08 | Logan | Oklahoma | 40083 | 6 | 0 |
43094 | 43094 | 2020-04-08 | Logan | West Virginia | 54045 | 8 | 0 |
43328 | 43328 | 2020-04-09 | Logan | Arkansas | 5083 | 1 | 0 |
43446 | 43446 | 2020-04-09 | Logan | Colorado | 8075 | 13 | 0 |
43786 | 43786 | 2020-04-09 | Logan | Illinois | 17107 | 3 | 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);