ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 41023 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
5834 | 5834 | 2020-03-20 | Grant | Oregon | 41023 | 1 | 0 |
6835 | 6835 | 2020-03-21 | Grant | Oregon | 41023 | 1 | 0 |
7950 | 7950 | 2020-03-22 | Grant | Oregon | 41023 | 1 | 0 |
9159 | 9159 | 2020-03-23 | Grant | Oregon | 41023 | 1 | 0 |
10478 | 10478 | 2020-03-24 | Grant | Oregon | 41023 | 1 | 0 |
11939 | 11939 | 2020-03-25 | Grant | Oregon | 41023 | 1 | 0 |
13555 | 13555 | 2020-03-26 | Grant | Oregon | 41023 | 1 | 0 |
15300 | 15300 | 2020-03-27 | Grant | Oregon | 41023 | 1 | 0 |
17147 | 17147 | 2020-03-28 | Grant | Oregon | 41023 | 1 | 0 |
19085 | 19085 | 2020-03-29 | Grant | Oregon | 41023 | 1 | 0 |
21135 | 21135 | 2020-03-30 | Grant | Oregon | 41023 | 1 | 0 |
23268 | 23268 | 2020-03-31 | Grant | Oregon | 41023 | 1 | 0 |
25466 | 25466 | 2020-04-01 | Grant | Oregon | 41023 | 1 | 0 |
27738 | 27738 | 2020-04-02 | Grant | Oregon | 41023 | 1 | 0 |
30071 | 30071 | 2020-04-03 | Grant | Oregon | 41023 | 1 | 0 |
32461 | 32461 | 2020-04-04 | Grant | Oregon | 41023 | 1 | 0 |
34895 | 34895 | 2020-04-05 | Grant | Oregon | 41023 | 1 | 0 |
37370 | 37370 | 2020-04-06 | Grant | Oregon | 41023 | 1 | 0 |
39891 | 39891 | 2020-04-07 | Grant | Oregon | 41023 | 1 | 0 |
42451 | 42451 | 2020-04-08 | Grant | Oregon | 41023 | 1 | 0 |
45037 | 45037 | 2020-04-09 | Grant | Oregon | 41023 | 1 | 0 |
47654 | 47654 | 2020-04-10 | Grant | Oregon | 41023 | 1 | 0 |
50311 | 50311 | 2020-04-11 | Grant | Oregon | 41023 | 1 | 0 |
52984 | 52984 | 2020-04-12 | Grant | Oregon | 41023 | 1 | 0 |
55669 | 55669 | 2020-04-13 | Grant | Oregon | 41023 | 1 | 0 |
58371 | 58371 | 2020-04-14 | Grant | Oregon | 41023 | 1 | 0 |
61086 | 61086 | 2020-04-15 | Grant | Oregon | 41023 | 1 | 0 |
63812 | 63812 | 2020-04-16 | Grant | Oregon | 41023 | 1 | 0 |
66558 | 66558 | 2020-04-17 | Grant | Oregon | 41023 | 1 | 0 |
69316 | 69316 | 2020-04-18 | Grant | Oregon | 41023 | 1 | 0 |
72083 | 72083 | 2020-04-19 | Grant | Oregon | 41023 | 1 | 0 |
74858 | 74858 | 2020-04-20 | Grant | Oregon | 41023 | 1 | 0 |
77640 | 77640 | 2020-04-21 | Grant | Oregon | 41023 | 1 | 0 |
80430 | 80430 | 2020-04-22 | Grant | Oregon | 41023 | 1 | 0 |
83229 | 83229 | 2020-04-23 | Grant | Oregon | 41023 | 1 | 0 |
86033 | 86033 | 2020-04-24 | Grant | Oregon | 41023 | 1 | 0 |
88847 | 88847 | 2020-04-25 | Grant | Oregon | 41023 | 1 | 0 |
91663 | 91663 | 2020-04-26 | Grant | Oregon | 41023 | 1 | 0 |
94490 | 94490 | 2020-04-27 | Grant | Oregon | 41023 | 1 | 0 |
97328 | 97328 | 2020-04-28 | Grant | Oregon | 41023 | 1 | 0 |
100177 | 100177 | 2020-04-29 | Grant | Oregon | 41023 | 1 | 0 |
103030 | 103030 | 2020-04-30 | Grant | Oregon | 41023 | 1 | 0 |
105893 | 105893 | 2020-05-01 | Grant | Oregon | 41023 | 1 | 0 |
108760 | 108760 | 2020-05-02 | Grant | Oregon | 41023 | 1 | 0 |
111634 | 111634 | 2020-05-03 | Grant | Oregon | 41023 | 1 | 0 |
114516 | 114516 | 2020-05-04 | Grant | Oregon | 41023 | 1 | 0 |
117397 | 117397 | 2020-05-05 | Grant | Oregon | 41023 | 1 | 0 |
120359 | 120359 | 2020-05-06 | Grant | Oregon | 41023 | 1 | 0 |
123336 | 123336 | 2020-05-07 | Grant | Oregon | 41023 | 1 | 0 |
126319 | 126319 | 2020-05-08 | Grant | Oregon | 41023 | 1 | 0 |
129308 | 129308 | 2020-05-09 | Grant | Oregon | 41023 | 1 | 0 |
132297 | 132297 | 2020-05-10 | Grant | Oregon | 41023 | 1 | 0 |
135288 | 135288 | 2020-05-11 | Grant | Oregon | 41023 | 1 | 0 |
138278 | 138278 | 2020-05-12 | Grant | Oregon | 41023 | 1 | 0 |
141274 | 141274 | 2020-05-13 | Grant | Oregon | 41023 | 1 | 0 |
144270 | 144270 | 2020-05-14 | Grant | Oregon | 41023 | 1 | 0 |
147271 | 147271 | 2020-05-15 | Grant | Oregon | 41023 | 1 | 0 |
150278 | 150278 | 2020-05-16 | Grant | Oregon | 41023 | 1 | 0 |
153289 | 153289 | 2020-05-17 | Grant | Oregon | 41023 | 1 | 0 |
156306 | 156306 | 2020-05-18 | Grant | Oregon | 41023 | 1 | 0 |
159327 | 159327 | 2020-05-19 | Grant | Oregon | 41023 | 1 | 0 |
162354 | 162354 | 2020-05-20 | Grant | Oregon | 41023 | 1 | 0 |
165383 | 165383 | 2020-05-21 | Grant | Oregon | 41023 | 1 | 0 |
168419 | 168419 | 2020-05-22 | Grant | Oregon | 41023 | 1 | 0 |
171458 | 171458 | 2020-05-23 | Grant | Oregon | 41023 | 1 | 0 |
174500 | 174500 | 2020-05-24 | Grant | Oregon | 41023 | 1 | 0 |
177544 | 177544 | 2020-05-25 | Grant | Oregon | 41023 | 1 | 0 |
180587 | 180587 | 2020-05-26 | Grant | Oregon | 41023 | 1 | 0 |
183636 | 183636 | 2020-05-27 | Grant | Oregon | 41023 | 1 | 0 |
186693 | 186693 | 2020-05-28 | Grant | Oregon | 41023 | 1 | 0 |
189754 | 189754 | 2020-05-29 | Grant | Oregon | 41023 | 1 | 0 |
192819 | 192819 | 2020-05-30 | Grant | Oregon | 41023 | 1 | 0 |
195888 | 195888 | 2020-05-31 | Grant | Oregon | 41023 | 1 | 0 |
198961 | 198961 | 2020-06-01 | Grant | Oregon | 41023 | 1 | 0 |
202036 | 202036 | 2020-06-02 | Grant | Oregon | 41023 | 1 | 0 |
205113 | 205113 | 2020-06-03 | Grant | Oregon | 41023 | 1 | 0 |
208194 | 208194 | 2020-06-04 | Grant | Oregon | 41023 | 1 | 0 |
211276 | 211276 | 2020-06-05 | Grant | Oregon | 41023 | 1 | 0 |
214362 | 214362 | 2020-06-06 | Grant | Oregon | 41023 | 1 | 0 |
217452 | 217452 | 2020-06-07 | Grant | Oregon | 41023 | 1 | 0 |
220544 | 220544 | 2020-06-08 | Grant | Oregon | 41023 | 1 | 0 |
223639 | 223639 | 2020-06-09 | Grant | Oregon | 41023 | 1 | 0 |
226739 | 226739 | 2020-06-10 | Grant | Oregon | 41023 | 1 | 0 |
229843 | 229843 | 2020-06-11 | Grant | Oregon | 41023 | 1 | 0 |
232948 | 232948 | 2020-06-12 | Grant | Oregon | 41023 | 1 | 0 |
236053 | 236053 | 2020-06-13 | Grant | Oregon | 41023 | 1 | 0 |
239161 | 239161 | 2020-06-14 | Grant | Oregon | 41023 | 1 | 0 |
242270 | 242270 | 2020-06-15 | Grant | Oregon | 41023 | 1 | 0 |
245382 | 245382 | 2020-06-16 | Grant | Oregon | 41023 | 1 | 0 |
248495 | 248495 | 2020-06-17 | Grant | Oregon | 41023 | 1 | 0 |
251610 | 251610 | 2020-06-18 | Grant | Oregon | 41023 | 1 | 0 |
254725 | 254725 | 2020-06-19 | Grant | Oregon | 41023 | 1 | 0 |
257851 | 257851 | 2020-06-20 | Grant | Oregon | 41023 | 1 | 0 |
260978 | 260978 | 2020-06-21 | Grant | Oregon | 41023 | 1 | 0 |
264106 | 264106 | 2020-06-22 | Grant | Oregon | 41023 | 1 | 0 |
267234 | 267234 | 2020-06-23 | Grant | Oregon | 41023 | 1 | 0 |
270368 | 270368 | 2020-06-24 | Grant | Oregon | 41023 | 1 | 0 |
273507 | 273507 | 2020-06-25 | Grant | Oregon | 41023 | 1 | 0 |
276654 | 276654 | 2020-06-26 | Grant | Oregon | 41023 | 1 | 0 |
279802 | 279802 | 2020-06-27 | Grant | Oregon | 41023 | 1 | 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);