ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 41051 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1113 | 1113 | 2020-03-10 | Multnomah | Oregon | 41051 | 1 | 0 |
1304 | 1304 | 2020-03-11 | Multnomah | Oregon | 41051 | 1 | 0 |
1548 | 1548 | 2020-03-12 | Multnomah | Oregon | 41051 | 1 | 0 |
1844 | 1844 | 2020-03-13 | Multnomah | Oregon | 41051 | 1 | 0 |
2205 | 2205 | 2020-03-14 | Multnomah | Oregon | 41051 | 1 | 1 |
2624 | 2624 | 2020-03-15 | Multnomah | Oregon | 41051 | 1 | 1 |
3089 | 3089 | 2020-03-16 | Multnomah | Oregon | 41051 | 2 | 1 |
3618 | 3618 | 2020-03-17 | Multnomah | Oregon | 41051 | 3 | 1 |
4233 | 4233 | 2020-03-18 | Multnomah | Oregon | 41051 | 3 | 1 |
4972 | 4972 | 2020-03-19 | Multnomah | Oregon | 41051 | 7 | 1 |
5840 | 5840 | 2020-03-20 | Multnomah | Oregon | 41051 | 12 | 1 |
6842 | 6842 | 2020-03-21 | Multnomah | Oregon | 41051 | 18 | 1 |
7957 | 7957 | 2020-03-22 | Multnomah | Oregon | 41051 | 19 | 1 |
9167 | 9167 | 2020-03-23 | Multnomah | Oregon | 41051 | 21 | 1 |
10486 | 10486 | 2020-03-24 | Multnomah | Oregon | 41051 | 25 | 2 |
11948 | 11948 | 2020-03-25 | Multnomah | Oregon | 41051 | 33 | 2 |
13564 | 13564 | 2020-03-26 | Multnomah | Oregon | 41051 | 45 | 2 |
15310 | 15310 | 2020-03-27 | Multnomah | Oregon | 41051 | 67 | 2 |
17157 | 17157 | 2020-03-28 | Multnomah | Oregon | 41051 | 81 | 2 |
19095 | 19095 | 2020-03-29 | Multnomah | Oregon | 41051 | 91 | 2 |
21145 | 21145 | 2020-03-30 | Multnomah | Oregon | 41051 | 100 | 2 |
23279 | 23279 | 2020-03-31 | Multnomah | Oregon | 41051 | 116 | 2 |
25477 | 25477 | 2020-04-01 | Multnomah | Oregon | 41051 | 134 | 3 |
27749 | 27749 | 2020-04-02 | Multnomah | Oregon | 41051 | 160 | 3 |
30082 | 30082 | 2020-04-03 | Multnomah | Oregon | 41051 | 175 | 3 |
32472 | 32472 | 2020-04-04 | Multnomah | Oregon | 41051 | 209 | 6 |
34906 | 34906 | 2020-04-05 | Multnomah | Oregon | 41051 | 233 | 7 |
37381 | 37381 | 2020-04-06 | Multnomah | Oregon | 41051 | 243 | 7 |
39902 | 39902 | 2020-04-07 | Multnomah | Oregon | 41051 | 258 | 7 |
42462 | 42462 | 2020-04-08 | Multnomah | Oregon | 41051 | 286 | 10 |
45048 | 45048 | 2020-04-09 | Multnomah | Oregon | 41051 | 302 | 13 |
47665 | 47665 | 2020-04-10 | Multnomah | Oregon | 41051 | 317 | 17 |
50322 | 50322 | 2020-04-11 | Multnomah | Oregon | 41051 | 343 | 18 |
52995 | 52995 | 2020-04-12 | Multnomah | Oregon | 41051 | 374 | 19 |
55680 | 55680 | 2020-04-13 | Multnomah | Oregon | 41051 | 398 | 19 |
58383 | 58383 | 2020-04-14 | Multnomah | Oregon | 41051 | 420 | 20 |
61098 | 61098 | 2020-04-15 | Multnomah | Oregon | 41051 | 430 | 22 |
63824 | 63824 | 2020-04-16 | Multnomah | Oregon | 41051 | 448 | 26 |
66570 | 66570 | 2020-04-17 | Multnomah | Oregon | 41051 | 467 | 28 |
69328 | 69328 | 2020-04-18 | Multnomah | Oregon | 41051 | 493 | 28 |
72095 | 72095 | 2020-04-19 | Multnomah | Oregon | 41051 | 514 | 28 |
74870 | 74870 | 2020-04-20 | Multnomah | Oregon | 41051 | 520 | 28 |
77652 | 77652 | 2020-04-21 | Multnomah | Oregon | 41051 | 542 | 29 |
80442 | 80442 | 2020-04-22 | Multnomah | Oregon | 41051 | 566 | 29 |
83241 | 83241 | 2020-04-23 | Multnomah | Oregon | 41051 | 582 | 33 |
86045 | 86045 | 2020-04-24 | Multnomah | Oregon | 41051 | 596 | 35 |
88859 | 88859 | 2020-04-25 | Multnomah | Oregon | 41051 | 623 | 35 |
91675 | 91675 | 2020-04-26 | Multnomah | Oregon | 41051 | 652 | 37 |
94502 | 94502 | 2020-04-27 | Multnomah | Oregon | 41051 | 664 | 37 |
97341 | 97341 | 2020-04-28 | Multnomah | Oregon | 41051 | 677 | 40 |
100190 | 100190 | 2020-04-29 | Multnomah | Oregon | 41051 | 696 | 42 |
103043 | 103043 | 2020-04-30 | Multnomah | Oregon | 41051 | 707 | 43 |
105906 | 105906 | 2020-05-01 | Multnomah | Oregon | 41051 | 720 | 44 |
108773 | 108773 | 2020-05-02 | Multnomah | Oregon | 41051 | 734 | 46 |
111647 | 111647 | 2020-05-03 | Multnomah | Oregon | 41051 | 739 | 46 |
114529 | 114529 | 2020-05-04 | Multnomah | Oregon | 41051 | 754 | 46 |
117410 | 117410 | 2020-05-05 | Multnomah | Oregon | 41051 | 769 | 49 |
120372 | 120372 | 2020-05-06 | Multnomah | Oregon | 41051 | 793 | 50 |
123349 | 123349 | 2020-05-07 | Multnomah | Oregon | 41051 | 809 | 52 |
126332 | 126332 | 2020-05-08 | Multnomah | Oregon | 41051 | 839 | 52 |
129321 | 129321 | 2020-05-09 | Multnomah | Oregon | 41051 | 863 | 53 |
132310 | 132310 | 2020-05-10 | Multnomah | Oregon | 41051 | 885 | 53 |
135301 | 135301 | 2020-05-11 | Multnomah | Oregon | 41051 | 899 | 53 |
138291 | 138291 | 2020-05-12 | Multnomah | Oregon | 41051 | 908 | 53 |
141287 | 141287 | 2020-05-13 | Multnomah | Oregon | 41051 | 921 | 53 |
144283 | 144283 | 2020-05-14 | Multnomah | Oregon | 41051 | 940 | 55 |
147284 | 147284 | 2020-05-15 | Multnomah | Oregon | 41051 | 957 | 55 |
150291 | 150291 | 2020-05-16 | Multnomah | Oregon | 41051 | 979 | 55 |
153302 | 153302 | 2020-05-17 | Multnomah | Oregon | 41051 | 984 | 55 |
156319 | 156319 | 2020-05-18 | Multnomah | Oregon | 41051 | 996 | 55 |
159340 | 159340 | 2020-05-19 | Multnomah | Oregon | 41051 | 1005 | 55 |
162367 | 162367 | 2020-05-20 | Multnomah | Oregon | 41051 | 1018 | 57 |
165396 | 165396 | 2020-05-21 | Multnomah | Oregon | 41051 | 1026 | 57 |
168432 | 168432 | 2020-05-22 | Multnomah | Oregon | 41051 | 1037 | 58 |
171471 | 171471 | 2020-05-23 | Multnomah | Oregon | 41051 | 1037 | 58 |
174513 | 174513 | 2020-05-24 | Multnomah | Oregon | 41051 | 1040 | 58 |
177557 | 177557 | 2020-05-25 | Multnomah | Oregon | 41051 | 1045 | 58 |
180600 | 180600 | 2020-05-26 | Multnomah | Oregon | 41051 | 1052 | 58 |
183650 | 183650 | 2020-05-27 | Multnomah | Oregon | 41051 | 1093 | 58 |
186707 | 186707 | 2020-05-28 | Multnomah | Oregon | 41051 | 1103 | 59 |
189768 | 189768 | 2020-05-29 | Multnomah | Oregon | 41051 | 1121 | 59 |
192833 | 192833 | 2020-05-30 | Multnomah | Oregon | 41051 | 1142 | 59 |
195902 | 195902 | 2020-05-31 | Multnomah | Oregon | 41051 | 1165 | 59 |
198975 | 198975 | 2020-06-01 | Multnomah | Oregon | 41051 | 1171 | 59 |
202050 | 202050 | 2020-06-02 | Multnomah | Oregon | 41051 | 1181 | 61 |
205127 | 205127 | 2020-06-03 | Multnomah | Oregon | 41051 | 1194 | 62 |
208208 | 208208 | 2020-06-04 | Multnomah | Oregon | 41051 | 1224 | 62 |
211290 | 211290 | 2020-06-05 | Multnomah | Oregon | 41051 | 1240 | 63 |
214376 | 214376 | 2020-06-06 | Multnomah | Oregon | 41051 | 1268 | 65 |
217466 | 217466 | 2020-06-07 | Multnomah | Oregon | 41051 | 1286 | 65 |
220558 | 220558 | 2020-06-08 | Multnomah | Oregon | 41051 | 1302 | 65 |
223653 | 223653 | 2020-06-09 | Multnomah | Oregon | 41051 | 1337 | 66 |
226753 | 226753 | 2020-06-10 | Multnomah | Oregon | 41051 | 1369 | 66 |
229857 | 229857 | 2020-06-11 | Multnomah | Oregon | 41051 | 1407 | 66 |
232962 | 232962 | 2020-06-12 | Multnomah | Oregon | 41051 | 1443 | 67 |
236067 | 236067 | 2020-06-13 | Multnomah | Oregon | 41051 | 1490 | 67 |
239175 | 239175 | 2020-06-14 | Multnomah | Oregon | 41051 | 1522 | 68 |
242284 | 242284 | 2020-06-15 | Multnomah | Oregon | 41051 | 1559 | 68 |
245396 | 245396 | 2020-06-16 | Multnomah | Oregon | 41051 | 1601 | 68 |
248509 | 248509 | 2020-06-17 | Multnomah | Oregon | 41051 | 1635 | 68 |
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);