ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5,289 rows where county = "Lewis" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 7
- Washington 790
- Tennessee 780
- Kentucky 776
- New York 776
- West Virginia 768
- Missouri 756
- Idaho 643
county 1
- Lewis · 5,289 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2719 | 2719 | 2020-03-15 | Lewis | Washington | 53041 | 1 | 0 |
3193 | 3193 | 2020-03-16 | Lewis | Washington | 53041 | 1 | 0 |
3734 | 3734 | 2020-03-17 | Lewis | Washington | 53041 | 1 | 0 |
4369 | 4369 | 2020-03-18 | Lewis | Washington | 53041 | 1 | 0 |
5126 | 5126 | 2020-03-19 | Lewis | Washington | 53041 | 1 | 0 |
6028 | 6028 | 2020-03-20 | Lewis | Washington | 53041 | 2 | 0 |
7059 | 7059 | 2020-03-21 | Lewis | Washington | 53041 | 2 | 0 |
8196 | 8196 | 2020-03-22 | Lewis | Washington | 53041 | 2 | 0 |
9421 | 9421 | 2020-03-23 | Lewis | Washington | 53041 | 2 | 0 |
10770 | 10770 | 2020-03-24 | Lewis | Washington | 53041 | 2 | 0 |
12085 | 12085 | 2020-03-25 | Lewis | Tennessee | 47101 | 1 | 0 |
12293 | 12293 | 2020-03-25 | Lewis | Washington | 53041 | 5 | 0 |
13709 | 13709 | 2020-03-26 | Lewis | Tennessee | 47101 | 2 | 0 |
13943 | 13943 | 2020-03-26 | Lewis | Washington | 53041 | 5 | 0 |
15461 | 15461 | 2020-03-27 | Lewis | Tennessee | 47101 | 2 | 0 |
15711 | 15711 | 2020-03-27 | Lewis | Washington | 53041 | 7 | 0 |
17324 | 17324 | 2020-03-28 | Lewis | Tennessee | 47101 | 2 | 0 |
17591 | 17591 | 2020-03-28 | Lewis | Washington | 53041 | 7 | 0 |
18358 | 18358 | 2020-03-29 | Lewis | Kentucky | 21135 | 1 | 0 |
18845 | 18845 | 2020-03-29 | Lewis | New York | 36049 | 2 | 0 |
19272 | 19272 | 2020-03-29 | Lewis | Tennessee | 47101 | 2 | 0 |
19556 | 19556 | 2020-03-29 | Lewis | Washington | 53041 | 10 | 0 |
20372 | 20372 | 2020-03-30 | Lewis | Kentucky | 21135 | 1 | 0 |
20884 | 20884 | 2020-03-30 | Lewis | New York | 36049 | 2 | 0 |
21328 | 21328 | 2020-03-30 | Lewis | Tennessee | 47101 | 2 | 0 |
21623 | 21623 | 2020-03-30 | Lewis | Washington | 53041 | 10 | 0 |
22477 | 22477 | 2020-03-31 | Lewis | Kentucky | 21135 | 1 | 0 |
23007 | 23007 | 2020-03-31 | Lewis | New York | 36049 | 2 | 0 |
23467 | 23467 | 2020-03-31 | Lewis | Tennessee | 47101 | 2 | 0 |
23772 | 23772 | 2020-03-31 | Lewis | Washington | 53041 | 10 | 0 |
24653 | 24653 | 2020-04-01 | Lewis | Kentucky | 21135 | 1 | 0 |
25201 | 25201 | 2020-04-01 | Lewis | New York | 36049 | 2 | 0 |
25669 | 25669 | 2020-04-01 | Lewis | Tennessee | 47101 | 2 | 0 |
25990 | 25990 | 2020-04-01 | Lewis | Washington | 53041 | 10 | 0 |
26900 | 26900 | 2020-04-02 | Lewis | Kentucky | 21135 | 1 | 0 |
27461 | 27461 | 2020-04-02 | Lewis | New York | 36049 | 3 | 0 |
27948 | 27948 | 2020-04-02 | Lewis | Tennessee | 47101 | 2 | 0 |
28280 | 28280 | 2020-04-02 | Lewis | Washington | 53041 | 12 | 0 |
29216 | 29216 | 2020-04-03 | Lewis | Kentucky | 21135 | 1 | 0 |
29785 | 29785 | 2020-04-03 | Lewis | New York | 36049 | 3 | 0 |
30283 | 30283 | 2020-04-03 | Lewis | Tennessee | 47101 | 2 | 0 |
30633 | 30633 | 2020-04-03 | Lewis | Washington | 53041 | 12 | 0 |
31592 | 31592 | 2020-04-04 | Lewis | Kentucky | 21135 | 2 | 0 |
32171 | 32171 | 2020-04-04 | Lewis | New York | 36049 | 5 | 0 |
32674 | 32674 | 2020-04-04 | Lewis | Tennessee | 47101 | 2 | 0 |
33033 | 33033 | 2020-04-04 | Lewis | Washington | 53041 | 12 | 0 |
34014 | 34014 | 2020-04-05 | Lewis | Kentucky | 21135 | 2 | 0 |
34602 | 34602 | 2020-04-05 | Lewis | New York | 36049 | 8 | 0 |
35111 | 35111 | 2020-04-05 | Lewis | Tennessee | 47101 | 2 | 0 |
35471 | 35471 | 2020-04-05 | Lewis | Washington | 53041 | 16 | 0 |
36472 | 36472 | 2020-04-06 | Lewis | Kentucky | 21135 | 2 | 0 |
37072 | 37072 | 2020-04-06 | Lewis | New York | 36049 | 8 | 0 |
37587 | 37587 | 2020-04-06 | Lewis | Tennessee | 47101 | 2 | 0 |
37955 | 37955 | 2020-04-06 | Lewis | Washington | 53041 | 16 | 1 |
37984 | 37984 | 2020-04-06 | Lewis | West Virginia | 54041 | 1 | 0 |
38979 | 38979 | 2020-04-07 | Lewis | Kentucky | 21135 | 2 | 0 |
39587 | 39587 | 2020-04-07 | Lewis | New York | 36049 | 8 | 0 |
40110 | 40110 | 2020-04-07 | Lewis | Tennessee | 47101 | 2 | 0 |
40490 | 40490 | 2020-04-07 | Lewis | Washington | 53041 | 16 | 1 |
40521 | 40521 | 2020-04-07 | Lewis | West Virginia | 54041 | 1 | 0 |
41529 | 41529 | 2020-04-08 | Lewis | Kentucky | 21135 | 2 | 0 |
42144 | 42144 | 2020-04-08 | Lewis | New York | 36049 | 8 | 0 |
42672 | 42672 | 2020-04-08 | Lewis | Tennessee | 47101 | 2 | 0 |
43059 | 43059 | 2020-04-08 | Lewis | Washington | 53041 | 17 | 2 |
43093 | 43093 | 2020-04-08 | Lewis | West Virginia | 54041 | 1 | 0 |
44105 | 44105 | 2020-04-09 | Lewis | Kentucky | 21135 | 2 | 0 |
44727 | 44727 | 2020-04-09 | Lewis | New York | 36049 | 6 | 0 |
45259 | 45259 | 2020-04-09 | Lewis | Tennessee | 47101 | 2 | 0 |
45655 | 45655 | 2020-04-09 | Lewis | Washington | 53041 | 18 | 2 |
45689 | 45689 | 2020-04-09 | Lewis | West Virginia | 54041 | 1 | 0 |
46713 | 46713 | 2020-04-10 | Lewis | Kentucky | 21135 | 2 | 0 |
47340 | 47340 | 2020-04-10 | Lewis | New York | 36049 | 6 | 0 |
47877 | 47877 | 2020-04-10 | Lewis | Tennessee | 47101 | 2 | 0 |
48282 | 48282 | 2020-04-10 | Lewis | Washington | 53041 | 18 | 2 |
48317 | 48317 | 2020-04-10 | Lewis | West Virginia | 54041 | 2 | 0 |
49353 | 49353 | 2020-04-11 | Lewis | Kentucky | 21135 | 2 | 0 |
49995 | 49995 | 2020-04-11 | Lewis | New York | 36049 | 6 | 0 |
50535 | 50535 | 2020-04-11 | Lewis | Tennessee | 47101 | 2 | 0 |
50940 | 50940 | 2020-04-11 | Lewis | Washington | 53041 | 18 | 2 |
50975 | 50975 | 2020-04-11 | Lewis | West Virginia | 54041 | 2 | 0 |
52019 | 52019 | 2020-04-12 | Lewis | Kentucky | 21135 | 2 | 0 |
52668 | 52668 | 2020-04-12 | Lewis | New York | 36049 | 6 | 0 |
53210 | 53210 | 2020-04-12 | Lewis | Tennessee | 47101 | 2 | 0 |
53615 | 53615 | 2020-04-12 | Lewis | Washington | 53041 | 18 | 2 |
53651 | 53651 | 2020-04-12 | Lewis | West Virginia | 54041 | 2 | 0 |
54700 | 54700 | 2020-04-13 | Lewis | Kentucky | 21135 | 2 | 0 |
55351 | 55351 | 2020-04-13 | Lewis | New York | 36049 | 6 | 0 |
55897 | 55897 | 2020-04-13 | Lewis | Tennessee | 47101 | 2 | 0 |
56305 | 56305 | 2020-04-13 | Lewis | Washington | 53041 | 17 | 2 |
56341 | 56341 | 2020-04-13 | Lewis | West Virginia | 54041 | 2 | 0 |
57397 | 57397 | 2020-04-14 | Lewis | Kentucky | 21135 | 2 | 0 |
58051 | 58051 | 2020-04-14 | Lewis | New York | 36049 | 7 | 0 |
58600 | 58600 | 2020-04-14 | Lewis | Tennessee | 47101 | 2 | 0 |
59011 | 59011 | 2020-04-14 | Lewis | Washington | 53041 | 19 | 2 |
59047 | 59047 | 2020-04-14 | Lewis | West Virginia | 54041 | 2 | 0 |
60106 | 60106 | 2020-04-15 | Lewis | Kentucky | 21135 | 2 | 0 |
60765 | 60765 | 2020-04-15 | Lewis | New York | 36049 | 7 | 0 |
61315 | 61315 | 2020-04-15 | Lewis | Tennessee | 47101 | 2 | 0 |
61730 | 61730 | 2020-04-15 | Lewis | Washington | 53041 | 19 | 2 |
61766 | 61766 | 2020-04-15 | Lewis | West Virginia | 54041 | 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);