ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Marion" and fips = 41047 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
833 | 833 | 2020-03-08 | Marion | Oregon | 41047 | 1 | 0 |
961 | 961 | 2020-03-09 | Marion | Oregon | 41047 | 1 | 0 |
1112 | 1112 | 2020-03-10 | Marion | Oregon | 41047 | 1 | 0 |
1303 | 1303 | 2020-03-11 | Marion | Oregon | 41047 | 2 | 0 |
1547 | 1547 | 2020-03-12 | Marion | Oregon | 41047 | 2 | 0 |
1843 | 1843 | 2020-03-13 | Marion | Oregon | 41047 | 2 | 0 |
2204 | 2204 | 2020-03-14 | Marion | Oregon | 41047 | 2 | 0 |
2623 | 2623 | 2020-03-15 | Marion | Oregon | 41047 | 2 | 0 |
3088 | 3088 | 2020-03-16 | Marion | Oregon | 41047 | 3 | 0 |
3617 | 3617 | 2020-03-17 | Marion | Oregon | 41047 | 4 | 0 |
4232 | 4232 | 2020-03-18 | Marion | Oregon | 41047 | 8 | 0 |
4971 | 4971 | 2020-03-19 | Marion | Oregon | 41047 | 13 | 0 |
5839 | 5839 | 2020-03-20 | Marion | Oregon | 41047 | 17 | 0 |
6841 | 6841 | 2020-03-21 | Marion | Oregon | 41047 | 19 | 1 |
7956 | 7956 | 2020-03-22 | Marion | Oregon | 41047 | 22 | 1 |
9166 | 9166 | 2020-03-23 | Marion | Oregon | 41047 | 30 | 1 |
10485 | 10485 | 2020-03-24 | Marion | Oregon | 41047 | 32 | 1 |
11947 | 11947 | 2020-03-25 | Marion | Oregon | 41047 | 43 | 2 |
13563 | 13563 | 2020-03-26 | Marion | Oregon | 41047 | 57 | 2 |
15308 | 15308 | 2020-03-27 | Marion | Oregon | 41047 | 83 | 3 |
17155 | 17155 | 2020-03-28 | Marion | Oregon | 41047 | 94 | 3 |
19093 | 19093 | 2020-03-29 | Marion | Oregon | 41047 | 109 | 3 |
21143 | 21143 | 2020-03-30 | Marion | Oregon | 41047 | 123 | 3 |
23277 | 23277 | 2020-03-31 | Marion | Oregon | 41047 | 141 | 3 |
25475 | 25475 | 2020-04-01 | Marion | Oregon | 41047 | 151 | 3 |
27747 | 27747 | 2020-04-02 | Marion | Oregon | 41047 | 164 | 4 |
30080 | 30080 | 2020-04-03 | Marion | Oregon | 41047 | 178 | 4 |
32470 | 32470 | 2020-04-04 | Marion | Oregon | 41047 | 188 | 5 |
34904 | 34904 | 2020-04-05 | Marion | Oregon | 41047 | 198 | 5 |
37379 | 37379 | 2020-04-06 | Marion | Oregon | 41047 | 209 | 6 |
39900 | 39900 | 2020-04-07 | Marion | Oregon | 41047 | 215 | 9 |
42460 | 42460 | 2020-04-08 | Marion | Oregon | 41047 | 218 | 9 |
45046 | 45046 | 2020-04-09 | Marion | Oregon | 41047 | 235 | 9 |
47663 | 47663 | 2020-04-10 | Marion | Oregon | 41047 | 246 | 9 |
50320 | 50320 | 2020-04-11 | Marion | Oregon | 41047 | 263 | 9 |
52993 | 52993 | 2020-04-12 | Marion | Oregon | 41047 | 276 | 9 |
55678 | 55678 | 2020-04-13 | Marion | Oregon | 41047 | 280 | 9 |
58381 | 58381 | 2020-04-14 | Marion | Oregon | 41047 | 289 | 9 |
61096 | 61096 | 2020-04-15 | Marion | Oregon | 41047 | 294 | 10 |
63822 | 63822 | 2020-04-16 | Marion | Oregon | 41047 | 309 | 11 |
66568 | 66568 | 2020-04-17 | Marion | Oregon | 41047 | 317 | 12 |
69326 | 69326 | 2020-04-18 | Marion | Oregon | 41047 | 335 | 13 |
72093 | 72093 | 2020-04-19 | Marion | Oregon | 41047 | 358 | 13 |
74868 | 74868 | 2020-04-20 | Marion | Oregon | 41047 | 371 | 14 |
77650 | 77650 | 2020-04-21 | Marion | Oregon | 41047 | 381 | 14 |
80440 | 80440 | 2020-04-22 | Marion | Oregon | 41047 | 388 | 14 |
83239 | 83239 | 2020-04-23 | Marion | Oregon | 41047 | 397 | 14 |
86043 | 86043 | 2020-04-24 | Marion | Oregon | 41047 | 417 | 14 |
88857 | 88857 | 2020-04-25 | Marion | Oregon | 41047 | 432 | 14 |
91673 | 91673 | 2020-04-26 | Marion | Oregon | 41047 | 436 | 15 |
94500 | 94500 | 2020-04-27 | Marion | Oregon | 41047 | 447 | 15 |
97339 | 97339 | 2020-04-28 | Marion | Oregon | 41047 | 456 | 17 |
100188 | 100188 | 2020-04-29 | Marion | Oregon | 41047 | 474 | 17 |
103041 | 103041 | 2020-04-30 | Marion | Oregon | 41047 | 491 | 18 |
105904 | 105904 | 2020-05-01 | Marion | Oregon | 41047 | 508 | 18 |
108771 | 108771 | 2020-05-02 | Marion | Oregon | 41047 | 523 | 19 |
111645 | 111645 | 2020-05-03 | Marion | Oregon | 41047 | 544 | 19 |
114527 | 114527 | 2020-05-04 | Marion | Oregon | 41047 | 561 | 19 |
117408 | 117408 | 2020-05-05 | Marion | Oregon | 41047 | 574 | 19 |
120370 | 120370 | 2020-05-06 | Marion | Oregon | 41047 | 592 | 19 |
123347 | 123347 | 2020-05-07 | Marion | Oregon | 41047 | 613 | 21 |
126330 | 126330 | 2020-05-08 | Marion | Oregon | 41047 | 626 | 23 |
129319 | 129319 | 2020-05-09 | Marion | Oregon | 41047 | 663 | 23 |
132308 | 132308 | 2020-05-10 | Marion | Oregon | 41047 | 677 | 23 |
135299 | 135299 | 2020-05-11 | Marion | Oregon | 41047 | 694 | 23 |
138289 | 138289 | 2020-05-12 | Marion | Oregon | 41047 | 723 | 23 |
141285 | 141285 | 2020-05-13 | Marion | Oregon | 41047 | 746 | 23 |
144281 | 144281 | 2020-05-14 | Marion | Oregon | 41047 | 779 | 23 |
147282 | 147282 | 2020-05-15 | Marion | Oregon | 41047 | 797 | 23 |
150289 | 150289 | 2020-05-16 | Marion | Oregon | 41047 | 824 | 23 |
153300 | 153300 | 2020-05-17 | Marion | Oregon | 41047 | 827 | 23 |
156317 | 156317 | 2020-05-18 | Marion | Oregon | 41047 | 843 | 24 |
159338 | 159338 | 2020-05-19 | Marion | Oregon | 41047 | 855 | 24 |
162365 | 162365 | 2020-05-20 | Marion | Oregon | 41047 | 879 | 24 |
165394 | 165394 | 2020-05-21 | Marion | Oregon | 41047 | 882 | 24 |
168430 | 168430 | 2020-05-22 | Marion | Oregon | 41047 | 890 | 25 |
171469 | 171469 | 2020-05-23 | Marion | Oregon | 41047 | 898 | 25 |
174511 | 174511 | 2020-05-24 | Marion | Oregon | 41047 | 905 | 25 |
177555 | 177555 | 2020-05-25 | Marion | Oregon | 41047 | 909 | 25 |
180598 | 180598 | 2020-05-26 | Marion | Oregon | 41047 | 914 | 25 |
183648 | 183648 | 2020-05-27 | Marion | Oregon | 41047 | 920 | 25 |
186705 | 186705 | 2020-05-28 | Marion | Oregon | 41047 | 931 | 25 |
189766 | 189766 | 2020-05-29 | Marion | Oregon | 41047 | 942 | 25 |
192831 | 192831 | 2020-05-30 | Marion | Oregon | 41047 | 949 | 25 |
195900 | 195900 | 2020-05-31 | Marion | Oregon | 41047 | 960 | 25 |
198973 | 198973 | 2020-06-01 | Marion | Oregon | 41047 | 973 | 26 |
202048 | 202048 | 2020-06-02 | Marion | Oregon | 41047 | 981 | 26 |
205125 | 205125 | 2020-06-03 | Marion | Oregon | 41047 | 999 | 26 |
208206 | 208206 | 2020-06-04 | Marion | Oregon | 41047 | 1011 | 26 |
211288 | 211288 | 2020-06-05 | Marion | Oregon | 41047 | 1028 | 27 |
214374 | 214374 | 2020-06-06 | Marion | Oregon | 41047 | 1039 | 27 |
217464 | 217464 | 2020-06-07 | Marion | Oregon | 41047 | 1050 | 27 |
220556 | 220556 | 2020-06-08 | Marion | Oregon | 41047 | 1058 | 27 |
223651 | 223651 | 2020-06-09 | Marion | Oregon | 41047 | 1066 | 30 |
226751 | 226751 | 2020-06-10 | Marion | Oregon | 41047 | 1071 | 30 |
229855 | 229855 | 2020-06-11 | Marion | Oregon | 41047 | 1105 | 30 |
232960 | 232960 | 2020-06-12 | Marion | Oregon | 41047 | 1134 | 30 |
236065 | 236065 | 2020-06-13 | Marion | Oregon | 41047 | 1155 | 30 |
239173 | 239173 | 2020-06-14 | Marion | Oregon | 41047 | 1175 | 30 |
242282 | 242282 | 2020-06-15 | Marion | Oregon | 41047 | 1179 | 30 |
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);