ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and fips = 36115 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4166 | 4166 | 2020-03-18 | Washington | New York | 36115 | 1 | 0 |
4896 | 4896 | 2020-03-19 | Washington | New York | 36115 | 1 | 0 |
5747 | 5747 | 2020-03-20 | Washington | New York | 36115 | 1 | 0 |
6742 | 6742 | 2020-03-21 | Washington | New York | 36115 | 1 | 0 |
7838 | 7838 | 2020-03-22 | Washington | New York | 36115 | 1 | 0 |
9038 | 9038 | 2020-03-23 | Washington | New York | 36115 | 3 | 0 |
10346 | 10346 | 2020-03-24 | Washington | New York | 36115 | 3 | 0 |
11782 | 11782 | 2020-03-25 | Washington | New York | 36115 | 4 | 0 |
13385 | 13385 | 2020-03-26 | Washington | New York | 36115 | 4 | 0 |
15119 | 15119 | 2020-03-27 | Washington | New York | 36115 | 6 | 0 |
16950 | 16950 | 2020-03-28 | Washington | New York | 36115 | 6 | 0 |
18876 | 18876 | 2020-03-29 | Washington | New York | 36115 | 7 | 0 |
20915 | 20915 | 2020-03-30 | Washington | New York | 36115 | 7 | 0 |
23039 | 23039 | 2020-03-31 | Washington | New York | 36115 | 10 | 0 |
25233 | 25233 | 2020-04-01 | Washington | New York | 36115 | 10 | 0 |
27493 | 27493 | 2020-04-02 | Washington | New York | 36115 | 13 | 0 |
29817 | 29817 | 2020-04-03 | Washington | New York | 36115 | 13 | 0 |
32203 | 32203 | 2020-04-04 | Washington | New York | 36115 | 17 | 1 |
34634 | 34634 | 2020-04-05 | Washington | New York | 36115 | 18 | 1 |
37103 | 37103 | 2020-04-06 | Washington | New York | 36115 | 19 | 1 |
39618 | 39618 | 2020-04-07 | Washington | New York | 36115 | 19 | 1 |
42175 | 42175 | 2020-04-08 | Washington | New York | 36115 | 20 | 0 |
44758 | 44758 | 2020-04-09 | Washington | New York | 36115 | 25 | 0 |
47371 | 47371 | 2020-04-10 | Washington | New York | 36115 | 26 | 0 |
50026 | 50026 | 2020-04-11 | Washington | New York | 36115 | 31 | 0 |
52699 | 52699 | 2020-04-12 | Washington | New York | 36115 | 34 | 0 |
55382 | 55382 | 2020-04-13 | Washington | New York | 36115 | 37 | 0 |
58082 | 58082 | 2020-04-14 | Washington | New York | 36115 | 40 | 0 |
60796 | 60796 | 2020-04-15 | Washington | New York | 36115 | 42 | 0 |
63522 | 63522 | 2020-04-16 | Washington | New York | 36115 | 46 | 0 |
66265 | 66265 | 2020-04-17 | Washington | New York | 36115 | 48 | 0 |
69022 | 69022 | 2020-04-18 | Washington | New York | 36115 | 52 | 0 |
71788 | 71788 | 2020-04-19 | Washington | New York | 36115 | 63 | 0 |
74563 | 74563 | 2020-04-20 | Washington | New York | 36115 | 65 | 0 |
77344 | 77344 | 2020-04-21 | Washington | New York | 36115 | 68 | 0 |
80133 | 80133 | 2020-04-22 | Washington | New York | 36115 | 73 | 0 |
82932 | 82932 | 2020-04-23 | Washington | New York | 36115 | 80 | 0 |
85736 | 85736 | 2020-04-24 | Washington | New York | 36115 | 83 | 0 |
88548 | 88548 | 2020-04-25 | Washington | New York | 36115 | 113 | 0 |
91363 | 91363 | 2020-04-26 | Washington | New York | 36115 | 127 | 0 |
94188 | 94188 | 2020-04-27 | Washington | New York | 36115 | 130 | 0 |
97024 | 97024 | 2020-04-28 | Washington | New York | 36115 | 131 | 0 |
99871 | 99871 | 2020-04-29 | Washington | New York | 36115 | 134 | 0 |
102724 | 102724 | 2020-04-30 | Washington | New York | 36115 | 148 | 0 |
105586 | 105586 | 2020-05-01 | Washington | New York | 36115 | 170 | 2 |
108453 | 108453 | 2020-05-02 | Washington | New York | 36115 | 184 | 2 |
111326 | 111326 | 2020-05-03 | Washington | New York | 36115 | 186 | 2 |
114207 | 114207 | 2020-05-04 | Washington | New York | 36115 | 188 | 2 |
117087 | 117087 | 2020-05-05 | Washington | New York | 36115 | 188 | 2 |
120048 | 120048 | 2020-05-06 | Washington | New York | 36115 | 189 | 8 |
123023 | 123023 | 2020-05-07 | Washington | New York | 36115 | 190 | 8 |
126006 | 126006 | 2020-05-08 | Washington | New York | 36115 | 201 | 9 |
128995 | 128995 | 2020-05-09 | Washington | New York | 36115 | 204 | 9 |
131984 | 131984 | 2020-05-10 | Washington | New York | 36115 | 206 | 9 |
134975 | 134975 | 2020-05-11 | Washington | New York | 36115 | 210 | 10 |
137965 | 137965 | 2020-05-12 | Washington | New York | 36115 | 210 | 10 |
140961 | 140961 | 2020-05-13 | Washington | New York | 36115 | 214 | 10 |
143956 | 143956 | 2020-05-14 | Washington | New York | 36115 | 215 | 11 |
146957 | 146957 | 2020-05-15 | Washington | New York | 36115 | 217 | 11 |
149964 | 149964 | 2020-05-16 | Washington | New York | 36115 | 218 | 11 |
152974 | 152974 | 2020-05-17 | Washington | New York | 36115 | 219 | 11 |
155991 | 155991 | 2020-05-18 | Washington | New York | 36115 | 219 | 11 |
159009 | 159009 | 2020-05-19 | Washington | New York | 36115 | 220 | 11 |
162036 | 162036 | 2020-05-20 | Washington | New York | 36115 | 221 | 11 |
165065 | 165065 | 2020-05-21 | Washington | New York | 36115 | 222 | 11 |
168100 | 168100 | 2020-05-22 | Washington | New York | 36115 | 224 | 11 |
171139 | 171139 | 2020-05-23 | Washington | New York | 36115 | 225 | 11 |
174181 | 174181 | 2020-05-24 | Washington | New York | 36115 | 226 | 11 |
177225 | 177225 | 2020-05-25 | Washington | New York | 36115 | 228 | 11 |
180268 | 180268 | 2020-05-26 | Washington | New York | 36115 | 228 | 11 |
183316 | 183316 | 2020-05-27 | Washington | New York | 36115 | 228 | 11 |
186373 | 186373 | 2020-05-28 | Washington | New York | 36115 | 231 | 11 |
189433 | 189433 | 2020-05-29 | Washington | New York | 36115 | 232 | 11 |
192497 | 192497 | 2020-05-30 | Washington | New York | 36115 | 235 | 11 |
195567 | 195567 | 2020-05-31 | Washington | New York | 36115 | 235 | 11 |
198640 | 198640 | 2020-06-01 | Washington | New York | 36115 | 235 | 11 |
201714 | 201714 | 2020-06-02 | Washington | New York | 36115 | 237 | 11 |
204791 | 204791 | 2020-06-03 | Washington | New York | 36115 | 238 | 11 |
207872 | 207872 | 2020-06-04 | Washington | New York | 36115 | 238 | 11 |
210954 | 210954 | 2020-06-05 | Washington | New York | 36115 | 240 | 11 |
214038 | 214038 | 2020-06-06 | Washington | New York | 36115 | 240 | 11 |
217128 | 217128 | 2020-06-07 | Washington | New York | 36115 | 240 | 11 |
220220 | 220220 | 2020-06-08 | Washington | New York | 36115 | 240 | 11 |
223314 | 223314 | 2020-06-09 | Washington | New York | 36115 | 240 | 11 |
226414 | 226414 | 2020-06-10 | Washington | New York | 36115 | 240 | 11 |
229518 | 229518 | 2020-06-11 | Washington | New York | 36115 | 241 | 11 |
232623 | 232623 | 2020-06-12 | Washington | New York | 36115 | 242 | 11 |
235728 | 235728 | 2020-06-13 | Washington | New York | 36115 | 242 | 11 |
238836 | 238836 | 2020-06-14 | Washington | New York | 36115 | 243 | 11 |
241945 | 241945 | 2020-06-15 | Washington | New York | 36115 | 243 | 11 |
245057 | 245057 | 2020-06-16 | Washington | New York | 36115 | 243 | 11 |
248170 | 248170 | 2020-06-17 | Washington | New York | 36115 | 243 | 11 |
251285 | 251285 | 2020-06-18 | Washington | New York | 36115 | 243 | 11 |
254400 | 254400 | 2020-06-19 | Washington | New York | 36115 | 243 | 11 |
257523 | 257523 | 2020-06-20 | Washington | New York | 36115 | 244 | 11 |
260650 | 260650 | 2020-06-21 | Washington | New York | 36115 | 244 | 11 |
263778 | 263778 | 2020-06-22 | Washington | New York | 36115 | 244 | 11 |
266906 | 266906 | 2020-06-23 | Washington | New York | 36115 | 244 | 11 |
270040 | 270040 | 2020-06-24 | Washington | New York | 36115 | 244 | 11 |
273179 | 273179 | 2020-06-25 | Washington | New York | 36115 | 245 | 11 |
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);