ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 41003 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3081 | 3081 | 2020-03-16 | Benton | Oregon | 41003 | 1 | 0 |
3609 | 3609 | 2020-03-17 | Benton | Oregon | 41003 | 1 | 0 |
4224 | 4224 | 2020-03-18 | Benton | Oregon | 41003 | 2 | 0 |
4963 | 4963 | 2020-03-19 | Benton | Oregon | 41003 | 2 | 0 |
5830 | 5830 | 2020-03-20 | Benton | Oregon | 41003 | 2 | 0 |
6831 | 6831 | 2020-03-21 | Benton | Oregon | 41003 | 2 | 0 |
7946 | 7946 | 2020-03-22 | Benton | Oregon | 41003 | 4 | 0 |
9155 | 9155 | 2020-03-23 | Benton | Oregon | 41003 | 4 | 0 |
10473 | 10473 | 2020-03-24 | Benton | Oregon | 41003 | 4 | 0 |
11934 | 11934 | 2020-03-25 | Benton | Oregon | 41003 | 6 | 0 |
13550 | 13550 | 2020-03-26 | Benton | Oregon | 41003 | 6 | 0 |
15294 | 15294 | 2020-03-27 | Benton | Oregon | 41003 | 6 | 0 |
17141 | 17141 | 2020-03-28 | Benton | Oregon | 41003 | 9 | 0 |
19079 | 19079 | 2020-03-29 | Benton | Oregon | 41003 | 9 | 0 |
21129 | 21129 | 2020-03-30 | Benton | Oregon | 41003 | 10 | 0 |
23262 | 23262 | 2020-03-31 | Benton | Oregon | 41003 | 12 | 1 |
25460 | 25460 | 2020-04-01 | Benton | Oregon | 41003 | 13 | 1 |
27732 | 27732 | 2020-04-02 | Benton | Oregon | 41003 | 15 | 1 |
30064 | 30064 | 2020-04-03 | Benton | Oregon | 41003 | 17 | 1 |
32454 | 32454 | 2020-04-04 | Benton | Oregon | 41003 | 19 | 1 |
34888 | 34888 | 2020-04-05 | Benton | Oregon | 41003 | 19 | 1 |
37362 | 37362 | 2020-04-06 | Benton | Oregon | 41003 | 21 | 1 |
39883 | 39883 | 2020-04-07 | Benton | Oregon | 41003 | 21 | 1 |
42443 | 42443 | 2020-04-08 | Benton | Oregon | 41003 | 21 | 1 |
45029 | 45029 | 2020-04-09 | Benton | Oregon | 41003 | 21 | 2 |
47646 | 47646 | 2020-04-10 | Benton | Oregon | 41003 | 21 | 2 |
50302 | 50302 | 2020-04-11 | Benton | Oregon | 41003 | 22 | 2 |
52975 | 52975 | 2020-04-12 | Benton | Oregon | 41003 | 23 | 2 |
55660 | 55660 | 2020-04-13 | Benton | Oregon | 41003 | 23 | 2 |
58362 | 58362 | 2020-04-14 | Benton | Oregon | 41003 | 24 | 3 |
61077 | 61077 | 2020-04-15 | Benton | Oregon | 41003 | 25 | 3 |
63803 | 63803 | 2020-04-16 | Benton | Oregon | 41003 | 27 | 4 |
66549 | 66549 | 2020-04-17 | Benton | Oregon | 41003 | 27 | 4 |
69307 | 69307 | 2020-04-18 | Benton | Oregon | 41003 | 27 | 4 |
72074 | 72074 | 2020-04-19 | Benton | Oregon | 41003 | 27 | 5 |
74849 | 74849 | 2020-04-20 | Benton | Oregon | 41003 | 28 | 5 |
77631 | 77631 | 2020-04-21 | Benton | Oregon | 41003 | 27 | 5 |
80421 | 80421 | 2020-04-22 | Benton | Oregon | 41003 | 27 | 5 |
83220 | 83220 | 2020-04-23 | Benton | Oregon | 41003 | 27 | 5 |
86024 | 86024 | 2020-04-24 | Benton | Oregon | 41003 | 27 | 5 |
88838 | 88838 | 2020-04-25 | Benton | Oregon | 41003 | 28 | 5 |
91654 | 91654 | 2020-04-26 | Benton | Oregon | 41003 | 29 | 5 |
94481 | 94481 | 2020-04-27 | Benton | Oregon | 41003 | 29 | 5 |
97319 | 97319 | 2020-04-28 | Benton | Oregon | 41003 | 29 | 5 |
100168 | 100168 | 2020-04-29 | Benton | Oregon | 41003 | 29 | 5 |
103021 | 103021 | 2020-04-30 | Benton | Oregon | 41003 | 30 | 5 |
105884 | 105884 | 2020-05-01 | Benton | Oregon | 41003 | 32 | 5 |
108751 | 108751 | 2020-05-02 | Benton | Oregon | 41003 | 32 | 5 |
111625 | 111625 | 2020-05-03 | Benton | Oregon | 41003 | 32 | 5 |
114507 | 114507 | 2020-05-04 | Benton | Oregon | 41003 | 36 | 5 |
117388 | 117388 | 2020-05-05 | Benton | Oregon | 41003 | 39 | 5 |
120350 | 120350 | 2020-05-06 | Benton | Oregon | 41003 | 40 | 5 |
123327 | 123327 | 2020-05-07 | Benton | Oregon | 41003 | 44 | 5 |
126310 | 126310 | 2020-05-08 | Benton | Oregon | 41003 | 43 | 5 |
129299 | 129299 | 2020-05-09 | Benton | Oregon | 41003 | 44 | 5 |
132288 | 132288 | 2020-05-10 | Benton | Oregon | 41003 | 47 | 5 |
135279 | 135279 | 2020-05-11 | Benton | Oregon | 41003 | 49 | 5 |
138269 | 138269 | 2020-05-12 | Benton | Oregon | 41003 | 50 | 5 |
141265 | 141265 | 2020-05-13 | Benton | Oregon | 41003 | 50 | 5 |
144261 | 144261 | 2020-05-14 | Benton | Oregon | 41003 | 50 | 5 |
147262 | 147262 | 2020-05-15 | Benton | Oregon | 41003 | 51 | 5 |
150269 | 150269 | 2020-05-16 | Benton | Oregon | 41003 | 51 | 5 |
153280 | 153280 | 2020-05-17 | Benton | Oregon | 41003 | 51 | 5 |
156297 | 156297 | 2020-05-18 | Benton | Oregon | 41003 | 54 | 5 |
159318 | 159318 | 2020-05-19 | Benton | Oregon | 41003 | 54 | 5 |
162345 | 162345 | 2020-05-20 | Benton | Oregon | 41003 | 55 | 5 |
165374 | 165374 | 2020-05-21 | Benton | Oregon | 41003 | 55 | 5 |
168410 | 168410 | 2020-05-22 | Benton | Oregon | 41003 | 55 | 5 |
171449 | 171449 | 2020-05-23 | Benton | Oregon | 41003 | 55 | 5 |
174491 | 174491 | 2020-05-24 | Benton | Oregon | 41003 | 55 | 5 |
177535 | 177535 | 2020-05-25 | Benton | Oregon | 41003 | 55 | 5 |
180578 | 180578 | 2020-05-26 | Benton | Oregon | 41003 | 55 | 5 |
183627 | 183627 | 2020-05-27 | Benton | Oregon | 41003 | 55 | 5 |
186684 | 186684 | 2020-05-28 | Benton | Oregon | 41003 | 55 | 5 |
189745 | 189745 | 2020-05-29 | Benton | Oregon | 41003 | 55 | 5 |
192810 | 192810 | 2020-05-30 | Benton | Oregon | 41003 | 55 | 5 |
195879 | 195879 | 2020-05-31 | Benton | Oregon | 41003 | 55 | 5 |
198952 | 198952 | 2020-06-01 | Benton | Oregon | 41003 | 55 | 5 |
202027 | 202027 | 2020-06-02 | Benton | Oregon | 41003 | 56 | 5 |
205104 | 205104 | 2020-06-03 | Benton | Oregon | 41003 | 57 | 5 |
208185 | 208185 | 2020-06-04 | Benton | Oregon | 41003 | 57 | 5 |
211267 | 211267 | 2020-06-05 | Benton | Oregon | 41003 | 62 | 5 |
214353 | 214353 | 2020-06-06 | Benton | Oregon | 41003 | 62 | 5 |
217443 | 217443 | 2020-06-07 | Benton | Oregon | 41003 | 62 | 5 |
220535 | 220535 | 2020-06-08 | Benton | Oregon | 41003 | 62 | 5 |
223630 | 223630 | 2020-06-09 | Benton | Oregon | 41003 | 63 | 5 |
226730 | 226730 | 2020-06-10 | Benton | Oregon | 41003 | 63 | 5 |
229834 | 229834 | 2020-06-11 | Benton | Oregon | 41003 | 63 | 5 |
232939 | 232939 | 2020-06-12 | Benton | Oregon | 41003 | 63 | 5 |
236044 | 236044 | 2020-06-13 | Benton | Oregon | 41003 | 63 | 5 |
239152 | 239152 | 2020-06-14 | Benton | Oregon | 41003 | 63 | 5 |
242261 | 242261 | 2020-06-15 | Benton | Oregon | 41003 | 63 | 5 |
245373 | 245373 | 2020-06-16 | Benton | Oregon | 41003 | 63 | 5 |
248486 | 248486 | 2020-06-17 | Benton | Oregon | 41003 | 66 | 5 |
251601 | 251601 | 2020-06-18 | Benton | Oregon | 41003 | 66 | 5 |
254716 | 254716 | 2020-06-19 | Benton | Oregon | 41003 | 66 | 5 |
257842 | 257842 | 2020-06-20 | Benton | Oregon | 41003 | 66 | 5 |
260969 | 260969 | 2020-06-21 | Benton | Oregon | 41003 | 67 | 5 |
264097 | 264097 | 2020-06-22 | Benton | Oregon | 41003 | 69 | 5 |
267225 | 267225 | 2020-06-23 | Benton | Oregon | 41003 | 68 | 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);