ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 39039 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6794 | 6794 | 2020-03-21 | Defiance | Ohio | 39039 | 2 | 0 |
7902 | 7902 | 2020-03-22 | Defiance | Ohio | 39039 | 2 | 0 |
9105 | 9105 | 2020-03-23 | Defiance | Ohio | 39039 | 2 | 0 |
10419 | 10419 | 2020-03-24 | Defiance | Ohio | 39039 | 2 | 0 |
11866 | 11866 | 2020-03-25 | Defiance | Ohio | 39039 | 2 | 0 |
13473 | 13473 | 2020-03-26 | Defiance | Ohio | 39039 | 2 | 0 |
15210 | 15210 | 2020-03-27 | Defiance | Ohio | 39039 | 5 | 0 |
17052 | 17052 | 2020-03-28 | Defiance | Ohio | 39039 | 5 | 0 |
18986 | 18986 | 2020-03-29 | Defiance | Ohio | 39039 | 5 | 0 |
21030 | 21030 | 2020-03-30 | Defiance | Ohio | 39039 | 5 | 0 |
23162 | 23162 | 2020-03-31 | Defiance | Ohio | 39039 | 5 | 0 |
25357 | 25357 | 2020-04-01 | Defiance | Ohio | 39039 | 6 | 0 |
27623 | 27623 | 2020-04-02 | Defiance | Ohio | 39039 | 6 | 0 |
29952 | 29952 | 2020-04-03 | Defiance | Ohio | 39039 | 6 | 0 |
32341 | 32341 | 2020-04-04 | Defiance | Ohio | 39039 | 7 | 0 |
34774 | 34774 | 2020-04-05 | Defiance | Ohio | 39039 | 7 | 0 |
37243 | 37243 | 2020-04-06 | Defiance | Ohio | 39039 | 8 | 0 |
39760 | 39760 | 2020-04-07 | Defiance | Ohio | 39039 | 9 | 0 |
42318 | 42318 | 2020-04-08 | Defiance | Ohio | 39039 | 10 | 0 |
44903 | 44903 | 2020-04-09 | Defiance | Ohio | 39039 | 10 | 0 |
47518 | 47518 | 2020-04-10 | Defiance | Ohio | 39039 | 11 | 0 |
50173 | 50173 | 2020-04-11 | Defiance | Ohio | 39039 | 11 | 0 |
52846 | 52846 | 2020-04-12 | Defiance | Ohio | 39039 | 11 | 0 |
55530 | 55530 | 2020-04-13 | Defiance | Ohio | 39039 | 12 | 0 |
58231 | 58231 | 2020-04-14 | Defiance | Ohio | 39039 | 12 | 0 |
60945 | 60945 | 2020-04-15 | Defiance | Ohio | 39039 | 12 | 0 |
63671 | 63671 | 2020-04-16 | Defiance | Ohio | 39039 | 12 | 0 |
66414 | 66414 | 2020-04-17 | Defiance | Ohio | 39039 | 13 | 0 |
69171 | 69171 | 2020-04-18 | Defiance | Ohio | 39039 | 13 | 0 |
71938 | 71938 | 2020-04-19 | Defiance | Ohio | 39039 | 14 | 0 |
74713 | 74713 | 2020-04-20 | Defiance | Ohio | 39039 | 15 | 0 |
77494 | 77494 | 2020-04-21 | Defiance | Ohio | 39039 | 15 | 0 |
80284 | 80284 | 2020-04-22 | Defiance | Ohio | 39039 | 17 | 0 |
83083 | 83083 | 2020-04-23 | Defiance | Ohio | 39039 | 17 | 1 |
85887 | 85887 | 2020-04-24 | Defiance | Ohio | 39039 | 18 | 1 |
88701 | 88701 | 2020-04-25 | Defiance | Ohio | 39039 | 19 | 1 |
91517 | 91517 | 2020-04-26 | Defiance | Ohio | 39039 | 19 | 1 |
94343 | 94343 | 2020-04-27 | Defiance | Ohio | 39039 | 19 | 1 |
97180 | 97180 | 2020-04-28 | Defiance | Ohio | 39039 | 20 | 1 |
100029 | 100029 | 2020-04-29 | Defiance | Ohio | 39039 | 20 | 1 |
102882 | 102882 | 2020-04-30 | Defiance | Ohio | 39039 | 20 | 1 |
105745 | 105745 | 2020-05-01 | Defiance | Ohio | 39039 | 20 | 1 |
108612 | 108612 | 2020-05-02 | Defiance | Ohio | 39039 | 20 | 1 |
111486 | 111486 | 2020-05-03 | Defiance | Ohio | 39039 | 20 | 1 |
114367 | 114367 | 2020-05-04 | Defiance | Ohio | 39039 | 20 | 1 |
117248 | 117248 | 2020-05-05 | Defiance | Ohio | 39039 | 21 | 1 |
120209 | 120209 | 2020-05-06 | Defiance | Ohio | 39039 | 21 | 1 |
123186 | 123186 | 2020-05-07 | Defiance | Ohio | 39039 | 21 | 1 |
126169 | 126169 | 2020-05-08 | Defiance | Ohio | 39039 | 21 | 1 |
129158 | 129158 | 2020-05-09 | Defiance | Ohio | 39039 | 26 | 1 |
132147 | 132147 | 2020-05-10 | Defiance | Ohio | 39039 | 26 | 1 |
135138 | 135138 | 2020-05-11 | Defiance | Ohio | 39039 | 26 | 1 |
138128 | 138128 | 2020-05-12 | Defiance | Ohio | 39039 | 26 | 1 |
141124 | 141124 | 2020-05-13 | Defiance | Ohio | 39039 | 26 | 1 |
144119 | 144119 | 2020-05-14 | Defiance | Ohio | 39039 | 26 | 1 |
147120 | 147120 | 2020-05-15 | Defiance | Ohio | 39039 | 26 | 1 |
150127 | 150127 | 2020-05-16 | Defiance | Ohio | 39039 | 26 | 1 |
153138 | 153138 | 2020-05-17 | Defiance | Ohio | 39039 | 26 | 1 |
156155 | 156155 | 2020-05-18 | Defiance | Ohio | 39039 | 27 | 1 |
159175 | 159175 | 2020-05-19 | Defiance | Ohio | 39039 | 28 | 1 |
162202 | 162202 | 2020-05-20 | Defiance | Ohio | 39039 | 30 | 1 |
165231 | 165231 | 2020-05-21 | Defiance | Ohio | 39039 | 30 | 2 |
168267 | 168267 | 2020-05-22 | Defiance | Ohio | 39039 | 32 | 2 |
171306 | 171306 | 2020-05-23 | Defiance | Ohio | 39039 | 32 | 2 |
174348 | 174348 | 2020-05-24 | Defiance | Ohio | 39039 | 32 | 2 |
177392 | 177392 | 2020-05-25 | Defiance | Ohio | 39039 | 32 | 2 |
180435 | 180435 | 2020-05-26 | Defiance | Ohio | 39039 | 32 | 2 |
183484 | 183484 | 2020-05-27 | Defiance | Ohio | 39039 | 33 | 2 |
186541 | 186541 | 2020-05-28 | Defiance | Ohio | 39039 | 33 | 2 |
189601 | 189601 | 2020-05-29 | Defiance | Ohio | 39039 | 33 | 2 |
192665 | 192665 | 2020-05-30 | Defiance | Ohio | 39039 | 33 | 2 |
195735 | 195735 | 2020-05-31 | Defiance | Ohio | 39039 | 34 | 2 |
198808 | 198808 | 2020-06-01 | Defiance | Ohio | 39039 | 34 | 2 |
201883 | 201883 | 2020-06-02 | Defiance | Ohio | 39039 | 34 | 2 |
204960 | 204960 | 2020-06-03 | Defiance | Ohio | 39039 | 34 | 2 |
208041 | 208041 | 2020-06-04 | Defiance | Ohio | 39039 | 34 | 2 |
211123 | 211123 | 2020-06-05 | Defiance | Ohio | 39039 | 34 | 2 |
214209 | 214209 | 2020-06-06 | Defiance | Ohio | 39039 | 35 | 2 |
217299 | 217299 | 2020-06-07 | Defiance | Ohio | 39039 | 36 | 2 |
220391 | 220391 | 2020-06-08 | Defiance | Ohio | 39039 | 37 | 2 |
223486 | 223486 | 2020-06-09 | Defiance | Ohio | 39039 | 38 | 2 |
226586 | 226586 | 2020-06-10 | Defiance | Ohio | 39039 | 39 | 2 |
229690 | 229690 | 2020-06-11 | Defiance | Ohio | 39039 | 40 | 2 |
232795 | 232795 | 2020-06-12 | Defiance | Ohio | 39039 | 40 | 2 |
235900 | 235900 | 2020-06-13 | Defiance | Ohio | 39039 | 40 | 2 |
239008 | 239008 | 2020-06-14 | Defiance | Ohio | 39039 | 40 | 2 |
242117 | 242117 | 2020-06-15 | Defiance | Ohio | 39039 | 40 | 2 |
245229 | 245229 | 2020-06-16 | Defiance | Ohio | 39039 | 40 | 2 |
248342 | 248342 | 2020-06-17 | Defiance | Ohio | 39039 | 40 | 2 |
251457 | 251457 | 2020-06-18 | Defiance | Ohio | 39039 | 40 | 2 |
254572 | 254572 | 2020-06-19 | Defiance | Ohio | 39039 | 40 | 2 |
257697 | 257697 | 2020-06-20 | Defiance | Ohio | 39039 | 42 | 2 |
260824 | 260824 | 2020-06-21 | Defiance | Ohio | 39039 | 42 | 2 |
263952 | 263952 | 2020-06-22 | Defiance | Ohio | 39039 | 42 | 2 |
267080 | 267080 | 2020-06-23 | Defiance | Ohio | 39039 | 43 | 3 |
270214 | 270214 | 2020-06-24 | Defiance | Ohio | 39039 | 43 | 3 |
273353 | 273353 | 2020-06-25 | Defiance | Ohio | 39039 | 43 | 3 |
276500 | 276500 | 2020-06-26 | Defiance | Ohio | 39039 | 43 | 3 |
279648 | 279648 | 2020-06-27 | Defiance | Ohio | 39039 | 44 | 3 |
282794 | 282794 | 2020-06-28 | Defiance | Ohio | 39039 | 45 | 3 |
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);