ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,547 rows where county = "McDowell" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11818 | 11818 | 2020-03-25 | McDowell | North Carolina | 37111 | 2 | 0 |
13422 | 13422 | 2020-03-26 | McDowell | North Carolina | 37111 | 2 | 0 |
15157 | 15157 | 2020-03-27 | McDowell | North Carolina | 37111 | 3 | 0 |
16989 | 16989 | 2020-03-28 | McDowell | North Carolina | 37111 | 3 | 0 |
18920 | 18920 | 2020-03-29 | McDowell | North Carolina | 37111 | 4 | 0 |
20960 | 20960 | 2020-03-30 | McDowell | North Carolina | 37111 | 4 | 0 |
23087 | 23087 | 2020-03-31 | McDowell | North Carolina | 37111 | 7 | 0 |
25281 | 25281 | 2020-04-01 | McDowell | North Carolina | 37111 | 7 | 0 |
27545 | 27545 | 2020-04-02 | McDowell | North Carolina | 37111 | 8 | 0 |
29872 | 29872 | 2020-04-03 | McDowell | North Carolina | 37111 | 8 | 0 |
32259 | 32259 | 2020-04-04 | McDowell | North Carolina | 37111 | 8 | 0 |
34690 | 34690 | 2020-04-05 | McDowell | North Carolina | 37111 | 9 | 0 |
37159 | 37159 | 2020-04-06 | McDowell | North Carolina | 37111 | 10 | 0 |
39674 | 39674 | 2020-04-07 | McDowell | North Carolina | 37111 | 10 | 0 |
40526 | 40526 | 2020-04-07 | McDowell | West Virginia | 54047 | 2 | 0 |
42231 | 42231 | 2020-04-08 | McDowell | North Carolina | 37111 | 10 | 0 |
43098 | 43098 | 2020-04-08 | McDowell | West Virginia | 54047 | 3 | 0 |
44815 | 44815 | 2020-04-09 | McDowell | North Carolina | 37111 | 13 | 0 |
45694 | 45694 | 2020-04-09 | McDowell | West Virginia | 54047 | 4 | 0 |
47428 | 47428 | 2020-04-10 | McDowell | North Carolina | 37111 | 16 | 0 |
48322 | 48322 | 2020-04-10 | McDowell | West Virginia | 54047 | 4 | 0 |
50083 | 50083 | 2020-04-11 | McDowell | North Carolina | 37111 | 16 | 0 |
50980 | 50980 | 2020-04-11 | McDowell | West Virginia | 54047 | 5 | 0 |
52756 | 52756 | 2020-04-12 | McDowell | North Carolina | 37111 | 16 | 0 |
53656 | 53656 | 2020-04-12 | McDowell | West Virginia | 54047 | 5 | 0 |
55440 | 55440 | 2020-04-13 | McDowell | North Carolina | 37111 | 16 | 0 |
56346 | 56346 | 2020-04-13 | McDowell | West Virginia | 54047 | 6 | 0 |
58140 | 58140 | 2020-04-14 | McDowell | North Carolina | 37111 | 18 | 0 |
59053 | 59053 | 2020-04-14 | McDowell | West Virginia | 54047 | 6 | 0 |
60854 | 60854 | 2020-04-15 | McDowell | North Carolina | 37111 | 18 | 0 |
61772 | 61772 | 2020-04-15 | McDowell | West Virginia | 54047 | 6 | 0 |
63580 | 63580 | 2020-04-16 | McDowell | North Carolina | 37111 | 18 | 0 |
64505 | 64505 | 2020-04-16 | McDowell | West Virginia | 54047 | 6 | 0 |
66323 | 66323 | 2020-04-17 | McDowell | North Carolina | 37111 | 19 | 0 |
67253 | 67253 | 2020-04-17 | McDowell | West Virginia | 54047 | 6 | 0 |
69080 | 69080 | 2020-04-18 | McDowell | North Carolina | 37111 | 19 | 0 |
70015 | 70015 | 2020-04-18 | McDowell | West Virginia | 54047 | 6 | 0 |
71846 | 71846 | 2020-04-19 | McDowell | North Carolina | 37111 | 19 | 0 |
72784 | 72784 | 2020-04-19 | McDowell | West Virginia | 54047 | 6 | 0 |
74621 | 74621 | 2020-04-20 | McDowell | North Carolina | 37111 | 20 | 0 |
75560 | 75560 | 2020-04-20 | McDowell | West Virginia | 54047 | 6 | 0 |
77402 | 77402 | 2020-04-21 | McDowell | North Carolina | 37111 | 20 | 0 |
78343 | 78343 | 2020-04-21 | McDowell | West Virginia | 54047 | 6 | 0 |
80191 | 80191 | 2020-04-22 | McDowell | North Carolina | 37111 | 20 | 0 |
81136 | 81136 | 2020-04-22 | McDowell | West Virginia | 54047 | 6 | 0 |
82990 | 82990 | 2020-04-23 | McDowell | North Carolina | 37111 | 20 | 0 |
83937 | 83937 | 2020-04-23 | McDowell | West Virginia | 54047 | 6 | 0 |
85794 | 85794 | 2020-04-24 | McDowell | North Carolina | 37111 | 20 | 0 |
86744 | 86744 | 2020-04-24 | McDowell | West Virginia | 54047 | 6 | 0 |
88607 | 88607 | 2020-04-25 | McDowell | North Carolina | 37111 | 21 | 1 |
89560 | 89560 | 2020-04-25 | McDowell | West Virginia | 54047 | 6 | 0 |
91422 | 91422 | 2020-04-26 | McDowell | North Carolina | 37111 | 21 | 1 |
92378 | 92378 | 2020-04-26 | McDowell | West Virginia | 54047 | 6 | 0 |
94248 | 94248 | 2020-04-27 | McDowell | North Carolina | 37111 | 21 | 1 |
95207 | 95207 | 2020-04-27 | McDowell | West Virginia | 54047 | 6 | 0 |
97085 | 97085 | 2020-04-28 | McDowell | North Carolina | 37111 | 22 | 1 |
98052 | 98052 | 2020-04-28 | McDowell | West Virginia | 54047 | 6 | 0 |
99933 | 99933 | 2020-04-29 | McDowell | North Carolina | 37111 | 22 | 1 |
100902 | 100902 | 2020-04-29 | McDowell | West Virginia | 54047 | 6 | 0 |
102786 | 102786 | 2020-04-30 | McDowell | North Carolina | 37111 | 22 | 1 |
103757 | 103757 | 2020-04-30 | McDowell | West Virginia | 54047 | 6 | 0 |
105648 | 105648 | 2020-05-01 | McDowell | North Carolina | 37111 | 25 | 1 |
106621 | 106621 | 2020-05-01 | McDowell | West Virginia | 54047 | 6 | 0 |
108515 | 108515 | 2020-05-02 | McDowell | North Carolina | 37111 | 25 | 1 |
109490 | 109490 | 2020-05-02 | McDowell | West Virginia | 54047 | 6 | 0 |
111388 | 111388 | 2020-05-03 | McDowell | North Carolina | 37111 | 27 | 1 |
112364 | 112364 | 2020-05-03 | McDowell | West Virginia | 54047 | 6 | 0 |
114269 | 114269 | 2020-05-04 | McDowell | North Carolina | 37111 | 27 | 1 |
115247 | 115247 | 2020-05-04 | McDowell | West Virginia | 54047 | 6 | 0 |
117149 | 117149 | 2020-05-05 | McDowell | North Carolina | 37111 | 28 | 1 |
118206 | 118206 | 2020-05-05 | McDowell | West Virginia | 54047 | 6 | 0 |
120110 | 120110 | 2020-05-06 | McDowell | North Carolina | 37111 | 28 | 1 |
121171 | 121171 | 2020-05-06 | McDowell | West Virginia | 54047 | 6 | 0 |
123085 | 123085 | 2020-05-07 | McDowell | North Carolina | 37111 | 28 | 1 |
124151 | 124151 | 2020-05-07 | McDowell | West Virginia | 54047 | 6 | 0 |
126068 | 126068 | 2020-05-08 | McDowell | North Carolina | 37111 | 29 | 1 |
127136 | 127136 | 2020-05-08 | McDowell | West Virginia | 54047 | 6 | 0 |
129057 | 129057 | 2020-05-09 | McDowell | North Carolina | 37111 | 29 | 1 |
130126 | 130126 | 2020-05-09 | McDowell | West Virginia | 54047 | 6 | 0 |
132046 | 132046 | 2020-05-10 | McDowell | North Carolina | 37111 | 29 | 1 |
133116 | 133116 | 2020-05-10 | McDowell | West Virginia | 54047 | 6 | 0 |
135037 | 135037 | 2020-05-11 | McDowell | North Carolina | 37111 | 29 | 1 |
136106 | 136106 | 2020-05-11 | McDowell | West Virginia | 54047 | 6 | 0 |
138027 | 138027 | 2020-05-12 | McDowell | North Carolina | 37111 | 29 | 1 |
139097 | 139097 | 2020-05-12 | McDowell | West Virginia | 54047 | 6 | 0 |
141023 | 141023 | 2020-05-13 | McDowell | North Carolina | 37111 | 29 | 1 |
142093 | 142093 | 2020-05-13 | McDowell | West Virginia | 54047 | 6 | 0 |
144018 | 144018 | 2020-05-14 | McDowell | North Carolina | 37111 | 29 | 1 |
145090 | 145090 | 2020-05-14 | McDowell | West Virginia | 54047 | 6 | 0 |
147019 | 147019 | 2020-05-15 | McDowell | North Carolina | 37111 | 29 | 1 |
148093 | 148093 | 2020-05-15 | McDowell | West Virginia | 54047 | 6 | 0 |
150026 | 150026 | 2020-05-16 | McDowell | North Carolina | 37111 | 30 | 1 |
151102 | 151102 | 2020-05-16 | McDowell | West Virginia | 54047 | 6 | 0 |
153036 | 153036 | 2020-05-17 | McDowell | North Carolina | 37111 | 30 | 1 |
154113 | 154113 | 2020-05-17 | McDowell | West Virginia | 54047 | 6 | 0 |
156053 | 156053 | 2020-05-18 | McDowell | North Carolina | 37111 | 32 | 1 |
157130 | 157130 | 2020-05-18 | McDowell | West Virginia | 54047 | 6 | 0 |
159072 | 159072 | 2020-05-19 | McDowell | North Carolina | 37111 | 32 | 1 |
160154 | 160154 | 2020-05-19 | McDowell | West Virginia | 54047 | 6 | 0 |
162099 | 162099 | 2020-05-20 | McDowell | North Carolina | 37111 | 33 | 1 |
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);