ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Washington" and state = "Ohio" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9136 | 9136 | 2020-03-23 | Washington | Ohio | 39167 | 1 | 0 |
10452 | 10452 | 2020-03-24 | Washington | Ohio | 39167 | 1 | 0 |
11904 | 11904 | 2020-03-25 | Washington | Ohio | 39167 | 1 | 0 |
13513 | 13513 | 2020-03-26 | Washington | Ohio | 39167 | 1 | 0 |
15252 | 15252 | 2020-03-27 | Washington | Ohio | 39167 | 2 | 0 |
17097 | 17097 | 2020-03-28 | Washington | Ohio | 39167 | 2 | 0 |
19031 | 19031 | 2020-03-29 | Washington | Ohio | 39167 | 3 | 0 |
21078 | 21078 | 2020-03-30 | Washington | Ohio | 39167 | 3 | 0 |
23211 | 23211 | 2020-03-31 | Washington | Ohio | 39167 | 3 | 0 |
25407 | 25407 | 2020-04-01 | Washington | Ohio | 39167 | 3 | 0 |
27675 | 27675 | 2020-04-02 | Washington | Ohio | 39167 | 4 | 0 |
30004 | 30004 | 2020-04-03 | Washington | Ohio | 39167 | 4 | 0 |
32393 | 32393 | 2020-04-04 | Washington | Ohio | 39167 | 6 | 0 |
34827 | 34827 | 2020-04-05 | Washington | Ohio | 39167 | 8 | 0 |
37300 | 37300 | 2020-04-06 | Washington | Ohio | 39167 | 15 | 0 |
39818 | 39818 | 2020-04-07 | Washington | Ohio | 39167 | 27 | 0 |
42378 | 42378 | 2020-04-08 | Washington | Ohio | 39167 | 30 | 0 |
44964 | 44964 | 2020-04-09 | Washington | Ohio | 39167 | 34 | 0 |
47579 | 47579 | 2020-04-10 | Washington | Ohio | 39167 | 35 | 1 |
50235 | 50235 | 2020-04-11 | Washington | Ohio | 39167 | 36 | 1 |
52908 | 52908 | 2020-04-12 | Washington | Ohio | 39167 | 39 | 1 |
55592 | 55592 | 2020-04-13 | Washington | Ohio | 39167 | 41 | 1 |
58293 | 58293 | 2020-04-14 | Washington | Ohio | 39167 | 44 | 2 |
61008 | 61008 | 2020-04-15 | Washington | Ohio | 39167 | 47 | 4 |
63734 | 63734 | 2020-04-16 | Washington | Ohio | 39167 | 53 | 5 |
66477 | 66477 | 2020-04-17 | Washington | Ohio | 39167 | 55 | 5 |
69234 | 69234 | 2020-04-18 | Washington | Ohio | 39167 | 57 | 6 |
72001 | 72001 | 2020-04-19 | Washington | Ohio | 39167 | 65 | 6 |
74776 | 74776 | 2020-04-20 | Washington | Ohio | 39167 | 65 | 6 |
77557 | 77557 | 2020-04-21 | Washington | Ohio | 39167 | 69 | 6 |
80347 | 80347 | 2020-04-22 | Washington | Ohio | 39167 | 73 | 6 |
83146 | 83146 | 2020-04-23 | Washington | Ohio | 39167 | 75 | 8 |
85950 | 85950 | 2020-04-24 | Washington | Ohio | 39167 | 80 | 8 |
88764 | 88764 | 2020-04-25 | Washington | Ohio | 39167 | 93 | 8 |
91580 | 91580 | 2020-04-26 | Washington | Ohio | 39167 | 94 | 10 |
94406 | 94406 | 2020-04-27 | Washington | Ohio | 39167 | 94 | 10 |
97244 | 97244 | 2020-04-28 | Washington | Ohio | 39167 | 95 | 10 |
100093 | 100093 | 2020-04-29 | Washington | Ohio | 39167 | 95 | 12 |
102946 | 102946 | 2020-04-30 | Washington | Ohio | 39167 | 98 | 12 |
105809 | 105809 | 2020-05-01 | Washington | Ohio | 39167 | 99 | 12 |
108676 | 108676 | 2020-05-02 | Washington | Ohio | 39167 | 100 | 12 |
111550 | 111550 | 2020-05-03 | Washington | Ohio | 39167 | 102 | 14 |
114431 | 114431 | 2020-05-04 | Washington | Ohio | 39167 | 103 | 14 |
117312 | 117312 | 2020-05-05 | Washington | Ohio | 39167 | 105 | 15 |
120273 | 120273 | 2020-05-06 | Washington | Ohio | 39167 | 106 | 16 |
123250 | 123250 | 2020-05-07 | Washington | Ohio | 39167 | 111 | 17 |
126233 | 126233 | 2020-05-08 | Washington | Ohio | 39167 | 111 | 17 |
129222 | 129222 | 2020-05-09 | Washington | Ohio | 39167 | 113 | 17 |
132211 | 132211 | 2020-05-10 | Washington | Ohio | 39167 | 114 | 17 |
135202 | 135202 | 2020-05-11 | Washington | Ohio | 39167 | 114 | 17 |
138192 | 138192 | 2020-05-12 | Washington | Ohio | 39167 | 114 | 17 |
141188 | 141188 | 2020-05-13 | Washington | Ohio | 39167 | 115 | 17 |
144183 | 144183 | 2020-05-14 | Washington | Ohio | 39167 | 116 | 17 |
147184 | 147184 | 2020-05-15 | Washington | Ohio | 39167 | 116 | 17 |
150191 | 150191 | 2020-05-16 | Washington | Ohio | 39167 | 116 | 17 |
153202 | 153202 | 2020-05-17 | Washington | Ohio | 39167 | 116 | 17 |
156219 | 156219 | 2020-05-18 | Washington | Ohio | 39167 | 116 | 17 |
159239 | 159239 | 2020-05-19 | Washington | Ohio | 39167 | 116 | 17 |
162266 | 162266 | 2020-05-20 | Washington | Ohio | 39167 | 116 | 17 |
165295 | 165295 | 2020-05-21 | Washington | Ohio | 39167 | 116 | 17 |
168331 | 168331 | 2020-05-22 | Washington | Ohio | 39167 | 116 | 17 |
171370 | 171370 | 2020-05-23 | Washington | Ohio | 39167 | 116 | 18 |
174412 | 174412 | 2020-05-24 | Washington | Ohio | 39167 | 117 | 18 |
177456 | 177456 | 2020-05-25 | Washington | Ohio | 39167 | 117 | 18 |
180499 | 180499 | 2020-05-26 | Washington | Ohio | 39167 | 117 | 18 |
183548 | 183548 | 2020-05-27 | Washington | Ohio | 39167 | 118 | 19 |
186605 | 186605 | 2020-05-28 | Washington | Ohio | 39167 | 118 | 19 |
189665 | 189665 | 2020-05-29 | Washington | Ohio | 39167 | 118 | 19 |
192730 | 192730 | 2020-05-30 | Washington | Ohio | 39167 | 118 | 19 |
195799 | 195799 | 2020-05-31 | Washington | Ohio | 39167 | 118 | 19 |
198872 | 198872 | 2020-06-01 | Washington | Ohio | 39167 | 118 | 19 |
201947 | 201947 | 2020-06-02 | Washington | Ohio | 39167 | 118 | 19 |
205024 | 205024 | 2020-06-03 | Washington | Ohio | 39167 | 118 | 19 |
208105 | 208105 | 2020-06-04 | Washington | Ohio | 39167 | 118 | 19 |
211187 | 211187 | 2020-06-05 | Washington | Ohio | 39167 | 118 | 19 |
214273 | 214273 | 2020-06-06 | Washington | Ohio | 39167 | 118 | 19 |
217363 | 217363 | 2020-06-07 | Washington | Ohio | 39167 | 118 | 19 |
220455 | 220455 | 2020-06-08 | Washington | Ohio | 39167 | 118 | 19 |
223550 | 223550 | 2020-06-09 | Washington | Ohio | 39167 | 118 | 19 |
226650 | 226650 | 2020-06-10 | Washington | Ohio | 39167 | 118 | 19 |
229754 | 229754 | 2020-06-11 | Washington | Ohio | 39167 | 117 | 19 |
232859 | 232859 | 2020-06-12 | Washington | Ohio | 39167 | 117 | 19 |
235964 | 235964 | 2020-06-13 | Washington | Ohio | 39167 | 118 | 19 |
239072 | 239072 | 2020-06-14 | Washington | Ohio | 39167 | 118 | 19 |
242181 | 242181 | 2020-06-15 | Washington | Ohio | 39167 | 118 | 19 |
245293 | 245293 | 2020-06-16 | Washington | Ohio | 39167 | 118 | 19 |
248406 | 248406 | 2020-06-17 | Washington | Ohio | 39167 | 118 | 19 |
251521 | 251521 | 2020-06-18 | Washington | Ohio | 39167 | 119 | 20 |
254636 | 254636 | 2020-06-19 | Washington | Ohio | 39167 | 119 | 20 |
257762 | 257762 | 2020-06-20 | Washington | Ohio | 39167 | 119 | 20 |
260888 | 260888 | 2020-06-21 | Washington | Ohio | 39167 | 119 | 20 |
264016 | 264016 | 2020-06-22 | Washington | Ohio | 39167 | 120 | 20 |
267144 | 267144 | 2020-06-23 | Washington | Ohio | 39167 | 120 | 20 |
270278 | 270278 | 2020-06-24 | Washington | Ohio | 39167 | 120 | 20 |
273417 | 273417 | 2020-06-25 | Washington | Ohio | 39167 | 120 | 20 |
276564 | 276564 | 2020-06-26 | Washington | Ohio | 39167 | 122 | 20 |
279712 | 279712 | 2020-06-27 | Washington | Ohio | 39167 | 122 | 20 |
282858 | 282858 | 2020-06-28 | Washington | Ohio | 39167 | 122 | 20 |
286003 | 286003 | 2020-06-29 | Washington | Ohio | 39167 | 124 | 20 |
289153 | 289153 | 2020-06-30 | Washington | Ohio | 39167 | 124 | 20 |
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);