ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Mercer" and state = "Ohio" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
11890 | 11890 | 2020-03-25 | Mercer | Ohio | 39107 | 1 | 0 |
13498 | 13498 | 2020-03-26 | Mercer | Ohio | 39107 | 1 | 0 |
15236 | 15236 | 2020-03-27 | Mercer | Ohio | 39107 | 2 | 0 |
17078 | 17078 | 2020-03-28 | Mercer | Ohio | 39107 | 2 | 0 |
19012 | 19012 | 2020-03-29 | Mercer | Ohio | 39107 | 2 | 0 |
21057 | 21057 | 2020-03-30 | Mercer | Ohio | 39107 | 2 | 0 |
23189 | 23189 | 2020-03-31 | Mercer | Ohio | 39107 | 2 | 0 |
25384 | 25384 | 2020-04-01 | Mercer | Ohio | 39107 | 4 | 0 |
27652 | 27652 | 2020-04-02 | Mercer | Ohio | 39107 | 5 | 0 |
29981 | 29981 | 2020-04-03 | Mercer | Ohio | 39107 | 6 | 0 |
32370 | 32370 | 2020-04-04 | Mercer | Ohio | 39107 | 6 | 1 |
34803 | 34803 | 2020-04-05 | Mercer | Ohio | 39107 | 7 | 1 |
37272 | 37272 | 2020-04-06 | Mercer | Ohio | 39107 | 8 | 1 |
39790 | 39790 | 2020-04-07 | Mercer | Ohio | 39107 | 8 | 1 |
42350 | 42350 | 2020-04-08 | Mercer | Ohio | 39107 | 11 | 1 |
44935 | 44935 | 2020-04-09 | Mercer | Ohio | 39107 | 12 | 1 |
47550 | 47550 | 2020-04-10 | Mercer | Ohio | 39107 | 12 | 1 |
50206 | 50206 | 2020-04-11 | Mercer | Ohio | 39107 | 12 | 1 |
52879 | 52879 | 2020-04-12 | Mercer | Ohio | 39107 | 13 | 1 |
55563 | 55563 | 2020-04-13 | Mercer | Ohio | 39107 | 13 | 1 |
58264 | 58264 | 2020-04-14 | Mercer | Ohio | 39107 | 13 | 1 |
60979 | 60979 | 2020-04-15 | Mercer | Ohio | 39107 | 13 | 1 |
63705 | 63705 | 2020-04-16 | Mercer | Ohio | 39107 | 13 | 1 |
66448 | 66448 | 2020-04-17 | Mercer | Ohio | 39107 | 13 | 1 |
69205 | 69205 | 2020-04-18 | Mercer | Ohio | 39107 | 13 | 1 |
71972 | 71972 | 2020-04-19 | Mercer | Ohio | 39107 | 13 | 1 |
74747 | 74747 | 2020-04-20 | Mercer | Ohio | 39107 | 13 | 1 |
77528 | 77528 | 2020-04-21 | Mercer | Ohio | 39107 | 13 | 1 |
80318 | 80318 | 2020-04-22 | Mercer | Ohio | 39107 | 14 | 1 |
83117 | 83117 | 2020-04-23 | Mercer | Ohio | 39107 | 16 | 1 |
85921 | 85921 | 2020-04-24 | Mercer | Ohio | 39107 | 16 | 1 |
88735 | 88735 | 2020-04-25 | Mercer | Ohio | 39107 | 18 | 1 |
91551 | 91551 | 2020-04-26 | Mercer | Ohio | 39107 | 18 | 1 |
94377 | 94377 | 2020-04-27 | Mercer | Ohio | 39107 | 18 | 1 |
97214 | 97214 | 2020-04-28 | Mercer | Ohio | 39107 | 18 | 1 |
100063 | 100063 | 2020-04-29 | Mercer | Ohio | 39107 | 18 | 1 |
102916 | 102916 | 2020-04-30 | Mercer | Ohio | 39107 | 21 | 1 |
105779 | 105779 | 2020-05-01 | Mercer | Ohio | 39107 | 26 | 1 |
108646 | 108646 | 2020-05-02 | Mercer | Ohio | 39107 | 28 | 1 |
111520 | 111520 | 2020-05-03 | Mercer | Ohio | 39107 | 29 | 1 |
114401 | 114401 | 2020-05-04 | Mercer | Ohio | 39107 | 33 | 1 |
117282 | 117282 | 2020-05-05 | Mercer | Ohio | 39107 | 38 | 1 |
120243 | 120243 | 2020-05-06 | Mercer | Ohio | 39107 | 42 | 1 |
123220 | 123220 | 2020-05-07 | Mercer | Ohio | 39107 | 42 | 1 |
126203 | 126203 | 2020-05-08 | Mercer | Ohio | 39107 | 62 | 1 |
129192 | 129192 | 2020-05-09 | Mercer | Ohio | 39107 | 66 | 1 |
132181 | 132181 | 2020-05-10 | Mercer | Ohio | 39107 | 67 | 1 |
135172 | 135172 | 2020-05-11 | Mercer | Ohio | 39107 | 84 | 1 |
138162 | 138162 | 2020-05-12 | Mercer | Ohio | 39107 | 86 | 1 |
141158 | 141158 | 2020-05-13 | Mercer | Ohio | 39107 | 90 | 1 |
144153 | 144153 | 2020-05-14 | Mercer | Ohio | 39107 | 109 | 1 |
147154 | 147154 | 2020-05-15 | Mercer | Ohio | 39107 | 115 | 1 |
150161 | 150161 | 2020-05-16 | Mercer | Ohio | 39107 | 121 | 1 |
153172 | 153172 | 2020-05-17 | Mercer | Ohio | 39107 | 133 | 2 |
156189 | 156189 | 2020-05-18 | Mercer | Ohio | 39107 | 141 | 2 |
159209 | 159209 | 2020-05-19 | Mercer | Ohio | 39107 | 148 | 2 |
162236 | 162236 | 2020-05-20 | Mercer | Ohio | 39107 | 162 | 2 |
165265 | 165265 | 2020-05-21 | Mercer | Ohio | 39107 | 163 | 3 |
168301 | 168301 | 2020-05-22 | Mercer | Ohio | 39107 | 170 | 3 |
171340 | 171340 | 2020-05-23 | Mercer | Ohio | 39107 | 178 | 3 |
174382 | 174382 | 2020-05-24 | Mercer | Ohio | 39107 | 184 | 3 |
177426 | 177426 | 2020-05-25 | Mercer | Ohio | 39107 | 190 | 3 |
180469 | 180469 | 2020-05-26 | Mercer | Ohio | 39107 | 200 | 3 |
183518 | 183518 | 2020-05-27 | Mercer | Ohio | 39107 | 201 | 4 |
186575 | 186575 | 2020-05-28 | Mercer | Ohio | 39107 | 201 | 6 |
189635 | 189635 | 2020-05-29 | Mercer | Ohio | 39107 | 203 | 7 |
192699 | 192699 | 2020-05-30 | Mercer | Ohio | 39107 | 210 | 7 |
195769 | 195769 | 2020-05-31 | Mercer | Ohio | 39107 | 211 | 7 |
198842 | 198842 | 2020-06-01 | Mercer | Ohio | 39107 | 216 | 7 |
201917 | 201917 | 2020-06-02 | Mercer | Ohio | 39107 | 217 | 7 |
204994 | 204994 | 2020-06-03 | Mercer | Ohio | 39107 | 220 | 7 |
208075 | 208075 | 2020-06-04 | Mercer | Ohio | 39107 | 223 | 8 |
211157 | 211157 | 2020-06-05 | Mercer | Ohio | 39107 | 227 | 8 |
214243 | 214243 | 2020-06-06 | Mercer | Ohio | 39107 | 230 | 8 |
217333 | 217333 | 2020-06-07 | Mercer | Ohio | 39107 | 233 | 8 |
220425 | 220425 | 2020-06-08 | Mercer | Ohio | 39107 | 237 | 8 |
223520 | 223520 | 2020-06-09 | Mercer | Ohio | 39107 | 237 | 8 |
226620 | 226620 | 2020-06-10 | Mercer | Ohio | 39107 | 239 | 8 |
229724 | 229724 | 2020-06-11 | Mercer | Ohio | 39107 | 242 | 8 |
232829 | 232829 | 2020-06-12 | Mercer | Ohio | 39107 | 244 | 8 |
235934 | 235934 | 2020-06-13 | Mercer | Ohio | 39107 | 243 | 8 |
239042 | 239042 | 2020-06-14 | Mercer | Ohio | 39107 | 245 | 8 |
242151 | 242151 | 2020-06-15 | Mercer | Ohio | 39107 | 246 | 8 |
245263 | 245263 | 2020-06-16 | Mercer | Ohio | 39107 | 247 | 8 |
248376 | 248376 | 2020-06-17 | Mercer | Ohio | 39107 | 253 | 8 |
251491 | 251491 | 2020-06-18 | Mercer | Ohio | 39107 | 253 | 8 |
254606 | 254606 | 2020-06-19 | Mercer | Ohio | 39107 | 255 | 8 |
257731 | 257731 | 2020-06-20 | Mercer | Ohio | 39107 | 257 | 8 |
260858 | 260858 | 2020-06-21 | Mercer | Ohio | 39107 | 258 | 8 |
263986 | 263986 | 2020-06-22 | Mercer | Ohio | 39107 | 257 | 8 |
267114 | 267114 | 2020-06-23 | Mercer | Ohio | 39107 | 258 | 8 |
270248 | 270248 | 2020-06-24 | Mercer | Ohio | 39107 | 259 | 8 |
273387 | 273387 | 2020-06-25 | Mercer | Ohio | 39107 | 259 | 8 |
276534 | 276534 | 2020-06-26 | Mercer | Ohio | 39107 | 265 | 8 |
279682 | 279682 | 2020-06-27 | Mercer | Ohio | 39107 | 265 | 8 |
282828 | 282828 | 2020-06-28 | Mercer | Ohio | 39107 | 266 | 8 |
285973 | 285973 | 2020-06-29 | Mercer | Ohio | 39107 | 266 | 8 |
289123 | 289123 | 2020-06-30 | Mercer | Ohio | 39107 | 270 | 8 |
292275 | 292275 | 2020-07-01 | Mercer | Ohio | 39107 | 272 | 8 |
295430 | 295430 | 2020-07-02 | Mercer | Ohio | 39107 | 272 | 8 |
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);