ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 39025 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6789 | 6789 | 2020-03-21 | Clermont | Ohio | 39025 | 2 | 0 |
7896 | 7896 | 2020-03-22 | Clermont | Ohio | 39025 | 5 | 0 |
9099 | 9099 | 2020-03-23 | Clermont | Ohio | 39025 | 5 | 0 |
10412 | 10412 | 2020-03-24 | Clermont | Ohio | 39025 | 5 | 0 |
11859 | 11859 | 2020-03-25 | Clermont | Ohio | 39025 | 5 | 0 |
13466 | 13466 | 2020-03-26 | Clermont | Ohio | 39025 | 6 | 0 |
15203 | 15203 | 2020-03-27 | Clermont | Ohio | 39025 | 6 | 0 |
17045 | 17045 | 2020-03-28 | Clermont | Ohio | 39025 | 8 | 0 |
18979 | 18979 | 2020-03-29 | Clermont | Ohio | 39025 | 8 | 0 |
21023 | 21023 | 2020-03-30 | Clermont | Ohio | 39025 | 9 | 0 |
23155 | 23155 | 2020-03-31 | Clermont | Ohio | 39025 | 10 | 0 |
25350 | 25350 | 2020-04-01 | Clermont | Ohio | 39025 | 11 | 0 |
27616 | 27616 | 2020-04-02 | Clermont | Ohio | 39025 | 14 | 0 |
29945 | 29945 | 2020-04-03 | Clermont | Ohio | 39025 | 16 | 1 |
32334 | 32334 | 2020-04-04 | Clermont | Ohio | 39025 | 20 | 1 |
34767 | 34767 | 2020-04-05 | Clermont | Ohio | 39025 | 21 | 1 |
37236 | 37236 | 2020-04-06 | Clermont | Ohio | 39025 | 27 | 1 |
39753 | 39753 | 2020-04-07 | Clermont | Ohio | 39025 | 22 | 1 |
42311 | 42311 | 2020-04-08 | Clermont | Ohio | 39025 | 27 | 1 |
44896 | 44896 | 2020-04-09 | Clermont | Ohio | 39025 | 33 | 1 |
47511 | 47511 | 2020-04-10 | Clermont | Ohio | 39025 | 36 | 1 |
50166 | 50166 | 2020-04-11 | Clermont | Ohio | 39025 | 41 | 1 |
52839 | 52839 | 2020-04-12 | Clermont | Ohio | 39025 | 41 | 1 |
55523 | 55523 | 2020-04-13 | Clermont | Ohio | 39025 | 39 | 1 |
58224 | 58224 | 2020-04-14 | Clermont | Ohio | 39025 | 44 | 1 |
60938 | 60938 | 2020-04-15 | Clermont | Ohio | 39025 | 49 | 1 |
63664 | 63664 | 2020-04-16 | Clermont | Ohio | 39025 | 60 | 1 |
66407 | 66407 | 2020-04-17 | Clermont | Ohio | 39025 | 66 | 1 |
69164 | 69164 | 2020-04-18 | Clermont | Ohio | 39025 | 71 | 1 |
71931 | 71931 | 2020-04-19 | Clermont | Ohio | 39025 | 72 | 1 |
74706 | 74706 | 2020-04-20 | Clermont | Ohio | 39025 | 72 | 2 |
77487 | 77487 | 2020-04-21 | Clermont | Ohio | 39025 | 74 | 3 |
80277 | 80277 | 2020-04-22 | Clermont | Ohio | 39025 | 73 | 2 |
83076 | 83076 | 2020-04-23 | Clermont | Ohio | 39025 | 76 | 2 |
85880 | 85880 | 2020-04-24 | Clermont | Ohio | 39025 | 77 | 2 |
88694 | 88694 | 2020-04-25 | Clermont | Ohio | 39025 | 77 | 2 |
91510 | 91510 | 2020-04-26 | Clermont | Ohio | 39025 | 77 | 2 |
94336 | 94336 | 2020-04-27 | Clermont | Ohio | 39025 | 76 | 2 |
97173 | 97173 | 2020-04-28 | Clermont | Ohio | 39025 | 78 | 2 |
100022 | 100022 | 2020-04-29 | Clermont | Ohio | 39025 | 81 | 3 |
102875 | 102875 | 2020-04-30 | Clermont | Ohio | 39025 | 88 | 3 |
105738 | 105738 | 2020-05-01 | Clermont | Ohio | 39025 | 93 | 3 |
108605 | 108605 | 2020-05-02 | Clermont | Ohio | 39025 | 99 | 3 |
111479 | 111479 | 2020-05-03 | Clermont | Ohio | 39025 | 101 | 3 |
114360 | 114360 | 2020-05-04 | Clermont | Ohio | 39025 | 103 | 3 |
117241 | 117241 | 2020-05-05 | Clermont | Ohio | 39025 | 109 | 3 |
120202 | 120202 | 2020-05-06 | Clermont | Ohio | 39025 | 110 | 3 |
123179 | 123179 | 2020-05-07 | Clermont | Ohio | 39025 | 110 | 3 |
126162 | 126162 | 2020-05-08 | Clermont | Ohio | 39025 | 120 | 3 |
129151 | 129151 | 2020-05-09 | Clermont | Ohio | 39025 | 122 | 3 |
132140 | 132140 | 2020-05-10 | Clermont | Ohio | 39025 | 123 | 3 |
135131 | 135131 | 2020-05-11 | Clermont | Ohio | 39025 | 125 | 3 |
138121 | 138121 | 2020-05-12 | Clermont | Ohio | 39025 | 125 | 3 |
141117 | 141117 | 2020-05-13 | Clermont | Ohio | 39025 | 129 | 3 |
144112 | 144112 | 2020-05-14 | Clermont | Ohio | 39025 | 136 | 4 |
147113 | 147113 | 2020-05-15 | Clermont | Ohio | 39025 | 144 | 4 |
150120 | 150120 | 2020-05-16 | Clermont | Ohio | 39025 | 149 | 4 |
153131 | 153131 | 2020-05-17 | Clermont | Ohio | 39025 | 152 | 4 |
156148 | 156148 | 2020-05-18 | Clermont | Ohio | 39025 | 152 | 5 |
159168 | 159168 | 2020-05-19 | Clermont | Ohio | 39025 | 156 | 5 |
162195 | 162195 | 2020-05-20 | Clermont | Ohio | 39025 | 160 | 5 |
165224 | 165224 | 2020-05-21 | Clermont | Ohio | 39025 | 167 | 5 |
168260 | 168260 | 2020-05-22 | Clermont | Ohio | 39025 | 170 | 5 |
171299 | 171299 | 2020-05-23 | Clermont | Ohio | 39025 | 177 | 5 |
174341 | 174341 | 2020-05-24 | Clermont | Ohio | 39025 | 181 | 5 |
177385 | 177385 | 2020-05-25 | Clermont | Ohio | 39025 | 188 | 5 |
180428 | 180428 | 2020-05-26 | Clermont | Ohio | 39025 | 193 | 5 |
183477 | 183477 | 2020-05-27 | Clermont | Ohio | 39025 | 197 | 5 |
186534 | 186534 | 2020-05-28 | Clermont | Ohio | 39025 | 202 | 5 |
189594 | 189594 | 2020-05-29 | Clermont | Ohio | 39025 | 206 | 5 |
192658 | 192658 | 2020-05-30 | Clermont | Ohio | 39025 | 206 | 5 |
195728 | 195728 | 2020-05-31 | Clermont | Ohio | 39025 | 211 | 5 |
198801 | 198801 | 2020-06-01 | Clermont | Ohio | 39025 | 213 | 5 |
201876 | 201876 | 2020-06-02 | Clermont | Ohio | 39025 | 215 | 5 |
204953 | 204953 | 2020-06-03 | Clermont | Ohio | 39025 | 216 | 5 |
208034 | 208034 | 2020-06-04 | Clermont | Ohio | 39025 | 218 | 5 |
211116 | 211116 | 2020-06-05 | Clermont | Ohio | 39025 | 219 | 5 |
214202 | 214202 | 2020-06-06 | Clermont | Ohio | 39025 | 224 | 6 |
217292 | 217292 | 2020-06-07 | Clermont | Ohio | 39025 | 227 | 6 |
220384 | 220384 | 2020-06-08 | Clermont | Ohio | 39025 | 232 | 6 |
223479 | 223479 | 2020-06-09 | Clermont | Ohio | 39025 | 234 | 6 |
226579 | 226579 | 2020-06-10 | Clermont | Ohio | 39025 | 237 | 6 |
229683 | 229683 | 2020-06-11 | Clermont | Ohio | 39025 | 235 | 6 |
232788 | 232788 | 2020-06-12 | Clermont | Ohio | 39025 | 236 | 6 |
235893 | 235893 | 2020-06-13 | Clermont | Ohio | 39025 | 237 | 6 |
239001 | 239001 | 2020-06-14 | Clermont | Ohio | 39025 | 238 | 6 |
242110 | 242110 | 2020-06-15 | Clermont | Ohio | 39025 | 240 | 6 |
245222 | 245222 | 2020-06-16 | Clermont | Ohio | 39025 | 244 | 6 |
248335 | 248335 | 2020-06-17 | Clermont | Ohio | 39025 | 252 | 6 |
251450 | 251450 | 2020-06-18 | Clermont | Ohio | 39025 | 256 | 6 |
254565 | 254565 | 2020-06-19 | Clermont | Ohio | 39025 | 266 | 6 |
257690 | 257690 | 2020-06-20 | Clermont | Ohio | 39025 | 275 | 6 |
260817 | 260817 | 2020-06-21 | Clermont | Ohio | 39025 | 279 | 6 |
263945 | 263945 | 2020-06-22 | Clermont | Ohio | 39025 | 287 | 6 |
267073 | 267073 | 2020-06-23 | Clermont | Ohio | 39025 | 288 | 6 |
270207 | 270207 | 2020-06-24 | Clermont | Ohio | 39025 | 294 | 6 |
273346 | 273346 | 2020-06-25 | Clermont | Ohio | 39025 | 300 | 6 |
276493 | 276493 | 2020-06-26 | Clermont | Ohio | 39025 | 307 | 6 |
279641 | 279641 | 2020-06-27 | Clermont | Ohio | 39025 | 319 | 6 |
282787 | 282787 | 2020-06-28 | Clermont | Ohio | 39025 | 327 | 6 |
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);