ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Sandusky" and state = "Ohio" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9129 | 9129 | 2020-03-23 | Sandusky | Ohio | 39143 | 1 | 0 |
10445 | 10445 | 2020-03-24 | Sandusky | Ohio | 39143 | 1 | 0 |
11896 | 11896 | 2020-03-25 | Sandusky | Ohio | 39143 | 1 | 0 |
13505 | 13505 | 2020-03-26 | Sandusky | Ohio | 39143 | 1 | 0 |
15243 | 15243 | 2020-03-27 | Sandusky | Ohio | 39143 | 1 | 0 |
17087 | 17087 | 2020-03-28 | Sandusky | Ohio | 39143 | 2 | 0 |
19021 | 19021 | 2020-03-29 | Sandusky | Ohio | 39143 | 3 | 0 |
21068 | 21068 | 2020-03-30 | Sandusky | Ohio | 39143 | 3 | 0 |
23201 | 23201 | 2020-03-31 | Sandusky | Ohio | 39143 | 4 | 0 |
25397 | 25397 | 2020-04-01 | Sandusky | Ohio | 39143 | 5 | 0 |
27665 | 27665 | 2020-04-02 | Sandusky | Ohio | 39143 | 5 | 0 |
29994 | 29994 | 2020-04-03 | Sandusky | Ohio | 39143 | 5 | 0 |
32383 | 32383 | 2020-04-04 | Sandusky | Ohio | 39143 | 5 | 0 |
34817 | 34817 | 2020-04-05 | Sandusky | Ohio | 39143 | 5 | 0 |
37289 | 37289 | 2020-04-06 | Sandusky | Ohio | 39143 | 5 | 0 |
39807 | 39807 | 2020-04-07 | Sandusky | Ohio | 39143 | 5 | 0 |
42367 | 42367 | 2020-04-08 | Sandusky | Ohio | 39143 | 5 | 1 |
44953 | 44953 | 2020-04-09 | Sandusky | Ohio | 39143 | 7 | 1 |
47568 | 47568 | 2020-04-10 | Sandusky | Ohio | 39143 | 7 | 1 |
50224 | 50224 | 2020-04-11 | Sandusky | Ohio | 39143 | 10 | 2 |
52897 | 52897 | 2020-04-12 | Sandusky | Ohio | 39143 | 11 | 2 |
55581 | 55581 | 2020-04-13 | Sandusky | Ohio | 39143 | 12 | 2 |
58282 | 58282 | 2020-04-14 | Sandusky | Ohio | 39143 | 13 | 2 |
60997 | 60997 | 2020-04-15 | Sandusky | Ohio | 39143 | 13 | 2 |
63723 | 63723 | 2020-04-16 | Sandusky | Ohio | 39143 | 14 | 2 |
66466 | 66466 | 2020-04-17 | Sandusky | Ohio | 39143 | 16 | 2 |
69223 | 69223 | 2020-04-18 | Sandusky | Ohio | 39143 | 17 | 2 |
71990 | 71990 | 2020-04-19 | Sandusky | Ohio | 39143 | 18 | 2 |
74765 | 74765 | 2020-04-20 | Sandusky | Ohio | 39143 | 17 | 2 |
77546 | 77546 | 2020-04-21 | Sandusky | Ohio | 39143 | 17 | 2 |
80336 | 80336 | 2020-04-22 | Sandusky | Ohio | 39143 | 17 | 2 |
83135 | 83135 | 2020-04-23 | Sandusky | Ohio | 39143 | 20 | 2 |
85939 | 85939 | 2020-04-24 | Sandusky | Ohio | 39143 | 20 | 2 |
88753 | 88753 | 2020-04-25 | Sandusky | Ohio | 39143 | 20 | 2 |
91569 | 91569 | 2020-04-26 | Sandusky | Ohio | 39143 | 20 | 2 |
94395 | 94395 | 2020-04-27 | Sandusky | Ohio | 39143 | 19 | 2 |
97232 | 97232 | 2020-04-28 | Sandusky | Ohio | 39143 | 19 | 4 |
100081 | 100081 | 2020-04-29 | Sandusky | Ohio | 39143 | 23 | 4 |
102934 | 102934 | 2020-04-30 | Sandusky | Ohio | 39143 | 27 | 5 |
105797 | 105797 | 2020-05-01 | Sandusky | Ohio | 39143 | 28 | 6 |
108664 | 108664 | 2020-05-02 | Sandusky | Ohio | 39143 | 32 | 6 |
111538 | 111538 | 2020-05-03 | Sandusky | Ohio | 39143 | 34 | 6 |
114419 | 114419 | 2020-05-04 | Sandusky | Ohio | 39143 | 36 | 7 |
117300 | 117300 | 2020-05-05 | Sandusky | Ohio | 39143 | 41 | 7 |
120261 | 120261 | 2020-05-06 | Sandusky | Ohio | 39143 | 40 | 7 |
123238 | 123238 | 2020-05-07 | Sandusky | Ohio | 39143 | 41 | 7 |
126221 | 126221 | 2020-05-08 | Sandusky | Ohio | 39143 | 47 | 7 |
129210 | 129210 | 2020-05-09 | Sandusky | Ohio | 39143 | 48 | 7 |
132199 | 132199 | 2020-05-10 | Sandusky | Ohio | 39143 | 49 | 7 |
135190 | 135190 | 2020-05-11 | Sandusky | Ohio | 39143 | 52 | 8 |
138180 | 138180 | 2020-05-12 | Sandusky | Ohio | 39143 | 53 | 8 |
141176 | 141176 | 2020-05-13 | Sandusky | Ohio | 39143 | 53 | 8 |
144171 | 144171 | 2020-05-14 | Sandusky | Ohio | 39143 | 54 | 8 |
147172 | 147172 | 2020-05-15 | Sandusky | Ohio | 39143 | 56 | 8 |
150179 | 150179 | 2020-05-16 | Sandusky | Ohio | 39143 | 56 | 8 |
153190 | 153190 | 2020-05-17 | Sandusky | Ohio | 39143 | 56 | 8 |
156207 | 156207 | 2020-05-18 | Sandusky | Ohio | 39143 | 57 | 9 |
159227 | 159227 | 2020-05-19 | Sandusky | Ohio | 39143 | 62 | 9 |
162254 | 162254 | 2020-05-20 | Sandusky | Ohio | 39143 | 63 | 9 |
165283 | 165283 | 2020-05-21 | Sandusky | Ohio | 39143 | 63 | 9 |
168319 | 168319 | 2020-05-22 | Sandusky | Ohio | 39143 | 63 | 9 |
171358 | 171358 | 2020-05-23 | Sandusky | Ohio | 39143 | 65 | 10 |
174400 | 174400 | 2020-05-24 | Sandusky | Ohio | 39143 | 65 | 10 |
177444 | 177444 | 2020-05-25 | Sandusky | Ohio | 39143 | 68 | 10 |
180487 | 180487 | 2020-05-26 | Sandusky | Ohio | 39143 | 70 | 10 |
183536 | 183536 | 2020-05-27 | Sandusky | Ohio | 39143 | 70 | 11 |
186593 | 186593 | 2020-05-28 | Sandusky | Ohio | 39143 | 72 | 11 |
189653 | 189653 | 2020-05-29 | Sandusky | Ohio | 39143 | 73 | 11 |
192717 | 192717 | 2020-05-30 | Sandusky | Ohio | 39143 | 73 | 11 |
195787 | 195787 | 2020-05-31 | Sandusky | Ohio | 39143 | 79 | 11 |
198860 | 198860 | 2020-06-01 | Sandusky | Ohio | 39143 | 81 | 11 |
201935 | 201935 | 2020-06-02 | Sandusky | Ohio | 39143 | 82 | 11 |
205012 | 205012 | 2020-06-03 | Sandusky | Ohio | 39143 | 85 | 12 |
208093 | 208093 | 2020-06-04 | Sandusky | Ohio | 39143 | 85 | 12 |
211175 | 211175 | 2020-06-05 | Sandusky | Ohio | 39143 | 91 | 12 |
214261 | 214261 | 2020-06-06 | Sandusky | Ohio | 39143 | 94 | 12 |
217351 | 217351 | 2020-06-07 | Sandusky | Ohio | 39143 | 95 | 12 |
220443 | 220443 | 2020-06-08 | Sandusky | Ohio | 39143 | 97 | 12 |
223538 | 223538 | 2020-06-09 | Sandusky | Ohio | 39143 | 98 | 13 |
226638 | 226638 | 2020-06-10 | Sandusky | Ohio | 39143 | 102 | 13 |
229742 | 229742 | 2020-06-11 | Sandusky | Ohio | 39143 | 102 | 13 |
232847 | 232847 | 2020-06-12 | Sandusky | Ohio | 39143 | 102 | 13 |
235952 | 235952 | 2020-06-13 | Sandusky | Ohio | 39143 | 102 | 13 |
239060 | 239060 | 2020-06-14 | Sandusky | Ohio | 39143 | 103 | 13 |
242169 | 242169 | 2020-06-15 | Sandusky | Ohio | 39143 | 104 | 13 |
245281 | 245281 | 2020-06-16 | Sandusky | Ohio | 39143 | 104 | 13 |
248394 | 248394 | 2020-06-17 | Sandusky | Ohio | 39143 | 104 | 13 |
251509 | 251509 | 2020-06-18 | Sandusky | Ohio | 39143 | 106 | 13 |
254624 | 254624 | 2020-06-19 | Sandusky | Ohio | 39143 | 109 | 13 |
257749 | 257749 | 2020-06-20 | Sandusky | Ohio | 39143 | 109 | 13 |
260876 | 260876 | 2020-06-21 | Sandusky | Ohio | 39143 | 109 | 13 |
264004 | 264004 | 2020-06-22 | Sandusky | Ohio | 39143 | 110 | 13 |
267132 | 267132 | 2020-06-23 | Sandusky | Ohio | 39143 | 110 | 13 |
270266 | 270266 | 2020-06-24 | Sandusky | Ohio | 39143 | 110 | 13 |
273405 | 273405 | 2020-06-25 | Sandusky | Ohio | 39143 | 112 | 13 |
276552 | 276552 | 2020-06-26 | Sandusky | Ohio | 39143 | 114 | 13 |
279700 | 279700 | 2020-06-27 | Sandusky | Ohio | 39143 | 114 | 13 |
282846 | 282846 | 2020-06-28 | Sandusky | Ohio | 39143 | 115 | 13 |
285991 | 285991 | 2020-06-29 | Sandusky | Ohio | 39143 | 120 | 13 |
289141 | 289141 | 2020-06-30 | Sandusky | Ohio | 39143 | 122 | 13 |
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);