ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Thurston" and state = "Washington" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1357 | 1357 | 2020-03-11 | Thurston | Washington | 53067 | 1 | 0 |
1611 | 1611 | 2020-03-12 | Thurston | Washington | 53067 | 1 | 0 |
1922 | 1922 | 2020-03-13 | Thurston | Washington | 53067 | 3 | 0 |
2296 | 2296 | 2020-03-14 | Thurston | Washington | 53067 | 3 | 0 |
2725 | 2725 | 2020-03-15 | Thurston | Washington | 53067 | 4 | 0 |
3199 | 3199 | 2020-03-16 | Thurston | Washington | 53067 | 4 | 0 |
3741 | 3741 | 2020-03-17 | Thurston | Washington | 53067 | 5 | 0 |
4376 | 4376 | 2020-03-18 | Thurston | Washington | 53067 | 6 | 0 |
5133 | 5133 | 2020-03-19 | Thurston | Washington | 53067 | 6 | 0 |
6037 | 6037 | 2020-03-20 | Thurston | Washington | 53067 | 8 | 0 |
7068 | 7068 | 2020-03-21 | Thurston | Washington | 53067 | 10 | 0 |
8205 | 8205 | 2020-03-22 | Thurston | Washington | 53067 | 11 | 0 |
9430 | 9430 | 2020-03-23 | Thurston | Washington | 53067 | 11 | 0 |
10779 | 10779 | 2020-03-24 | Thurston | Washington | 53067 | 14 | 0 |
12303 | 12303 | 2020-03-25 | Thurston | Washington | 53067 | 14 | 0 |
13953 | 13953 | 2020-03-26 | Thurston | Washington | 53067 | 24 | 0 |
15722 | 15722 | 2020-03-27 | Thurston | Washington | 53067 | 27 | 0 |
17602 | 17602 | 2020-03-28 | Thurston | Washington | 53067 | 33 | 0 |
19567 | 19567 | 2020-03-29 | Thurston | Washington | 53067 | 36 | 0 |
21634 | 21634 | 2020-03-30 | Thurston | Washington | 53067 | 43 | 0 |
23783 | 23783 | 2020-03-31 | Thurston | Washington | 53067 | 48 | 0 |
26001 | 26001 | 2020-04-01 | Thurston | Washington | 53067 | 51 | 0 |
28292 | 28292 | 2020-04-02 | Thurston | Washington | 53067 | 55 | 0 |
30645 | 30645 | 2020-04-03 | Thurston | Washington | 53067 | 58 | 0 |
33045 | 33045 | 2020-04-04 | Thurston | Washington | 53067 | 64 | 1 |
35483 | 35483 | 2020-04-05 | Thurston | Washington | 53067 | 67 | 1 |
37967 | 37967 | 2020-04-06 | Thurston | Washington | 53067 | 72 | 1 |
40502 | 40502 | 2020-04-07 | Thurston | Washington | 53067 | 74 | 1 |
43071 | 43071 | 2020-04-08 | Thurston | Washington | 53067 | 77 | 1 |
45667 | 45667 | 2020-04-09 | Thurston | Washington | 53067 | 81 | 1 |
48295 | 48295 | 2020-04-10 | Thurston | Washington | 53067 | 81 | 1 |
50953 | 50953 | 2020-04-11 | Thurston | Washington | 53067 | 81 | 1 |
53628 | 53628 | 2020-04-12 | Thurston | Washington | 53067 | 81 | 1 |
56318 | 56318 | 2020-04-13 | Thurston | Washington | 53067 | 81 | 1 |
59024 | 59024 | 2020-04-14 | Thurston | Washington | 53067 | 82 | 1 |
61743 | 61743 | 2020-04-15 | Thurston | Washington | 53067 | 82 | 1 |
64476 | 64476 | 2020-04-16 | Thurston | Washington | 53067 | 86 | 1 |
67224 | 67224 | 2020-04-17 | Thurston | Washington | 53067 | 89 | 1 |
69986 | 69986 | 2020-04-18 | Thurston | Washington | 53067 | 93 | 1 |
72756 | 72756 | 2020-04-19 | Thurston | Washington | 53067 | 94 | 1 |
75532 | 75532 | 2020-04-20 | Thurston | Washington | 53067 | 94 | 1 |
78315 | 78315 | 2020-04-21 | Thurston | Washington | 53067 | 94 | 1 |
81108 | 81108 | 2020-04-22 | Thurston | Washington | 53067 | 95 | 1 |
83909 | 83909 | 2020-04-23 | Thurston | Washington | 53067 | 96 | 1 |
86716 | 86716 | 2020-04-24 | Thurston | Washington | 53067 | 98 | 1 |
89531 | 89531 | 2020-04-25 | Thurston | Washington | 53067 | 101 | 1 |
92348 | 92348 | 2020-04-26 | Thurston | Washington | 53067 | 100 | 1 |
95177 | 95177 | 2020-04-27 | Thurston | Washington | 53067 | 100 | 1 |
98022 | 98022 | 2020-04-28 | Thurston | Washington | 53067 | 100 | 1 |
100872 | 100872 | 2020-04-29 | Thurston | Washington | 53067 | 104 | 1 |
103727 | 103727 | 2020-04-30 | Thurston | Washington | 53067 | 105 | 1 |
106591 | 106591 | 2020-05-01 | Thurston | Washington | 53067 | 110 | 1 |
109460 | 109460 | 2020-05-02 | Thurston | Washington | 53067 | 111 | 1 |
112334 | 112334 | 2020-05-03 | Thurston | Washington | 53067 | 111 | 1 |
115217 | 115217 | 2020-05-04 | Thurston | Washington | 53067 | 113 | 1 |
118176 | 118176 | 2020-05-05 | Thurston | Washington | 53067 | 113 | 1 |
121140 | 121140 | 2020-05-06 | Thurston | Washington | 53067 | 116 | 1 |
124120 | 124120 | 2020-05-07 | Thurston | Washington | 53067 | 117 | 1 |
127105 | 127105 | 2020-05-08 | Thurston | Washington | 53067 | 118 | 1 |
130095 | 130095 | 2020-05-09 | Thurston | Washington | 53067 | 120 | 1 |
133085 | 133085 | 2020-05-10 | Thurston | Washington | 53067 | 123 | 1 |
136075 | 136075 | 2020-05-11 | Thurston | Washington | 53067 | 123 | 1 |
139066 | 139066 | 2020-05-12 | Thurston | Washington | 53067 | 124 | 1 |
142062 | 142062 | 2020-05-13 | Thurston | Washington | 53067 | 124 | 1 |
145059 | 145059 | 2020-05-14 | Thurston | Washington | 53067 | 125 | 1 |
148062 | 148062 | 2020-05-15 | Thurston | Washington | 53067 | 126 | 1 |
151071 | 151071 | 2020-05-16 | Thurston | Washington | 53067 | 127 | 1 |
154082 | 154082 | 2020-05-17 | Thurston | Washington | 53067 | 127 | 1 |
157099 | 157099 | 2020-05-18 | Thurston | Washington | 53067 | 127 | 1 |
160123 | 160123 | 2020-05-19 | Thurston | Washington | 53067 | 127 | 1 |
163151 | 163151 | 2020-05-20 | Thurston | Washington | 53067 | 127 | 1 |
166180 | 166180 | 2020-05-21 | Thurston | Washington | 53067 | 127 | 1 |
169216 | 169216 | 2020-05-22 | Thurston | Washington | 53067 | 127 | 1 |
172257 | 172257 | 2020-05-23 | Thurston | Washington | 53067 | 127 | 1 |
175300 | 175300 | 2020-05-24 | Thurston | Washington | 53067 | 131 | 1 |
178345 | 178345 | 2020-05-25 | Thurston | Washington | 53067 | 132 | 1 |
181389 | 181389 | 2020-05-26 | Thurston | Washington | 53067 | 132 | 1 |
184440 | 184440 | 2020-05-27 | Thurston | Washington | 53067 | 135 | 1 |
187497 | 187497 | 2020-05-28 | Thurston | Washington | 53067 | 135 | 1 |
190561 | 190561 | 2020-05-29 | Thurston | Washington | 53067 | 136 | 1 |
193627 | 193627 | 2020-05-30 | Thurston | Washington | 53067 | 148 | 2 |
196697 | 196697 | 2020-05-31 | Thurston | Washington | 53067 | 154 | 2 |
199770 | 199770 | 2020-06-01 | Thurston | Washington | 53067 | 155 | 2 |
202846 | 202846 | 2020-06-02 | Thurston | Washington | 53067 | 157 | 2 |
205925 | 205925 | 2020-06-03 | Thurston | Washington | 53067 | 157 | 2 |
209007 | 209007 | 2020-06-04 | Thurston | Washington | 53067 | 160 | 2 |
212092 | 212092 | 2020-06-05 | Thurston | Washington | 53067 | 165 | 2 |
215179 | 215179 | 2020-06-06 | Thurston | Washington | 53067 | 170 | 2 |
218269 | 218269 | 2020-06-07 | Thurston | Washington | 53067 | 170 | 2 |
221361 | 221361 | 2020-06-08 | Thurston | Washington | 53067 | 173 | 3 |
224457 | 224457 | 2020-06-09 | Thurston | Washington | 53067 | 174 | 4 |
227557 | 227557 | 2020-06-10 | Thurston | Washington | 53067 | 179 | 4 |
230661 | 230661 | 2020-06-11 | Thurston | Washington | 53067 | 179 | 4 |
233766 | 233766 | 2020-06-12 | Thurston | Washington | 53067 | 187 | 4 |
236873 | 236873 | 2020-06-13 | Thurston | Washington | 53067 | 192 | 4 |
239981 | 239981 | 2020-06-14 | Thurston | Washington | 53067 | 193 | 4 |
243092 | 243092 | 2020-06-15 | Thurston | Washington | 53067 | 197 | 4 |
246205 | 246205 | 2020-06-16 | Thurston | Washington | 53067 | 198 | 5 |
249317 | 249317 | 2020-06-17 | Thurston | Washington | 53067 | 201 | 5 |
252432 | 252432 | 2020-06-18 | Thurston | Washington | 53067 | 205 | 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);