ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Mahoning" and state = "Ohio" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3595 | 3595 | 2020-03-17 | Mahoning | Ohio | 39099 | 1 | 0 |
4209 | 4209 | 2020-03-18 | Mahoning | Ohio | 39099 | 3 | 0 |
4941 | 4941 | 2020-03-19 | Mahoning | Ohio | 39099 | 5 | 0 |
5804 | 5804 | 2020-03-20 | Mahoning | Ohio | 39099 | 7 | 0 |
6805 | 6805 | 2020-03-21 | Mahoning | Ohio | 39099 | 14 | 0 |
7916 | 7916 | 2020-03-22 | Mahoning | Ohio | 39099 | 18 | 0 |
9122 | 9122 | 2020-03-23 | Mahoning | Ohio | 39099 | 23 | 0 |
10438 | 10438 | 2020-03-24 | Mahoning | Ohio | 39099 | 28 | 0 |
11887 | 11887 | 2020-03-25 | Mahoning | Ohio | 39099 | 42 | 0 |
13495 | 13495 | 2020-03-26 | Mahoning | Ohio | 39099 | 51 | 1 |
15233 | 15233 | 2020-03-27 | Mahoning | Ohio | 39099 | 68 | 2 |
17075 | 17075 | 2020-03-28 | Mahoning | Ohio | 39099 | 80 | 2 |
19009 | 19009 | 2020-03-29 | Mahoning | Ohio | 39099 | 84 | 2 |
21054 | 21054 | 2020-03-30 | Mahoning | Ohio | 39099 | 117 | 4 |
23186 | 23186 | 2020-03-31 | Mahoning | Ohio | 39099 | 153 | 9 |
25381 | 25381 | 2020-04-01 | Mahoning | Ohio | 39099 | 177 | 10 |
27649 | 27649 | 2020-04-02 | Mahoning | Ohio | 39099 | 192 | 11 |
29978 | 29978 | 2020-04-03 | Mahoning | Ohio | 39099 | 203 | 12 |
32367 | 32367 | 2020-04-04 | Mahoning | Ohio | 39099 | 250 | 13 |
34800 | 34800 | 2020-04-05 | Mahoning | Ohio | 39099 | 261 | 15 |
37269 | 37269 | 2020-04-06 | Mahoning | Ohio | 39099 | 272 | 17 |
39786 | 39786 | 2020-04-07 | Mahoning | Ohio | 39099 | 300 | 19 |
42346 | 42346 | 2020-04-08 | Mahoning | Ohio | 39099 | 305 | 28 |
44931 | 44931 | 2020-04-09 | Mahoning | Ohio | 39099 | 334 | 28 |
47546 | 47546 | 2020-04-10 | Mahoning | Ohio | 39099 | 358 | 31 |
50202 | 50202 | 2020-04-11 | Mahoning | Ohio | 39099 | 375 | 31 |
52875 | 52875 | 2020-04-12 | Mahoning | Ohio | 39099 | 417 | 31 |
55559 | 55559 | 2020-04-13 | Mahoning | Ohio | 39099 | 443 | 31 |
58260 | 58260 | 2020-04-14 | Mahoning | Ohio | 39099 | 469 | 35 |
60975 | 60975 | 2020-04-15 | Mahoning | Ohio | 39099 | 486 | 41 |
63701 | 63701 | 2020-04-16 | Mahoning | Ohio | 39099 | 512 | 41 |
66444 | 66444 | 2020-04-17 | Mahoning | Ohio | 39099 | 547 | 44 |
69201 | 69201 | 2020-04-18 | Mahoning | Ohio | 39099 | 572 | 45 |
71968 | 71968 | 2020-04-19 | Mahoning | Ohio | 39099 | 589 | 48 |
74743 | 74743 | 2020-04-20 | Mahoning | Ohio | 39099 | 604 | 50 |
77524 | 77524 | 2020-04-21 | Mahoning | Ohio | 39099 | 621 | 54 |
80314 | 80314 | 2020-04-22 | Mahoning | Ohio | 39099 | 635 | 56 |
83113 | 83113 | 2020-04-23 | Mahoning | Ohio | 39099 | 666 | 62 |
85917 | 85917 | 2020-04-24 | Mahoning | Ohio | 39099 | 688 | 65 |
88731 | 88731 | 2020-04-25 | Mahoning | Ohio | 39099 | 721 | 66 |
91547 | 91547 | 2020-04-26 | Mahoning | Ohio | 39099 | 737 | 66 |
94373 | 94373 | 2020-04-27 | Mahoning | Ohio | 39099 | 764 | 65 |
97210 | 97210 | 2020-04-28 | Mahoning | Ohio | 39099 | 784 | 67 |
100059 | 100059 | 2020-04-29 | Mahoning | Ohio | 39099 | 804 | 81 |
102912 | 102912 | 2020-04-30 | Mahoning | Ohio | 39099 | 828 | 80 |
105775 | 105775 | 2020-05-01 | Mahoning | Ohio | 39099 | 853 | 82 |
108642 | 108642 | 2020-05-02 | Mahoning | Ohio | 39099 | 883 | 82 |
111516 | 111516 | 2020-05-03 | Mahoning | Ohio | 39099 | 937 | 83 |
114397 | 114397 | 2020-05-04 | Mahoning | Ohio | 39099 | 961 | 83 |
117278 | 117278 | 2020-05-05 | Mahoning | Ohio | 39099 | 998 | 92 |
120239 | 120239 | 2020-05-06 | Mahoning | Ohio | 39099 | 1024 | 108 |
123216 | 123216 | 2020-05-07 | Mahoning | Ohio | 39099 | 1044 | 115 |
126199 | 126199 | 2020-05-08 | Mahoning | Ohio | 39099 | 1087 | 119 |
129188 | 129188 | 2020-05-09 | Mahoning | Ohio | 39099 | 1104 | 122 |
132177 | 132177 | 2020-05-10 | Mahoning | Ohio | 39099 | 1119 | 122 |
135168 | 135168 | 2020-05-11 | Mahoning | Ohio | 39099 | 1144 | 123 |
138158 | 138158 | 2020-05-12 | Mahoning | Ohio | 39099 | 1150 | 132 |
141154 | 141154 | 2020-05-13 | Mahoning | Ohio | 39099 | 1163 | 134 |
144149 | 144149 | 2020-05-14 | Mahoning | Ohio | 39099 | 1174 | 138 |
147150 | 147150 | 2020-05-15 | Mahoning | Ohio | 39099 | 1185 | 145 |
150157 | 150157 | 2020-05-16 | Mahoning | Ohio | 39099 | 1199 | 146 |
153168 | 153168 | 2020-05-17 | Mahoning | Ohio | 39099 | 1212 | 146 |
156185 | 156185 | 2020-05-18 | Mahoning | Ohio | 39099 | 1226 | 148 |
159205 | 159205 | 2020-05-19 | Mahoning | Ohio | 39099 | 1247 | 156 |
162232 | 162232 | 2020-05-20 | Mahoning | Ohio | 39099 | 1252 | 160 |
165261 | 165261 | 2020-05-21 | Mahoning | Ohio | 39099 | 1277 | 162 |
168297 | 168297 | 2020-05-22 | Mahoning | Ohio | 39099 | 1295 | 163 |
171336 | 171336 | 2020-05-23 | Mahoning | Ohio | 39099 | 1317 | 169 |
174378 | 174378 | 2020-05-24 | Mahoning | Ohio | 39099 | 1334 | 169 |
177422 | 177422 | 2020-05-25 | Mahoning | Ohio | 39099 | 1341 | 169 |
180465 | 180465 | 2020-05-26 | Mahoning | Ohio | 39099 | 1347 | 171 |
183514 | 183514 | 2020-05-27 | Mahoning | Ohio | 39099 | 1367 | 173 |
186571 | 186571 | 2020-05-28 | Mahoning | Ohio | 39099 | 1397 | 173 |
189631 | 189631 | 2020-05-29 | Mahoning | Ohio | 39099 | 1405 | 173 |
192695 | 192695 | 2020-05-30 | Mahoning | Ohio | 39099 | 1428 | 174 |
195765 | 195765 | 2020-05-31 | Mahoning | Ohio | 39099 | 1431 | 174 |
198838 | 198838 | 2020-06-01 | Mahoning | Ohio | 39099 | 1438 | 178 |
201913 | 201913 | 2020-06-02 | Mahoning | Ohio | 39099 | 1456 | 186 |
204990 | 204990 | 2020-06-03 | Mahoning | Ohio | 39099 | 1463 | 188 |
208071 | 208071 | 2020-06-04 | Mahoning | Ohio | 39099 | 1466 | 191 |
211153 | 211153 | 2020-06-05 | Mahoning | Ohio | 39099 | 1486 | 191 |
214239 | 214239 | 2020-06-06 | Mahoning | Ohio | 39099 | 1502 | 194 |
217329 | 217329 | 2020-06-07 | Mahoning | Ohio | 39099 | 1511 | 194 |
220421 | 220421 | 2020-06-08 | Mahoning | Ohio | 39099 | 1516 | 195 |
223516 | 223516 | 2020-06-09 | Mahoning | Ohio | 39099 | 1522 | 195 |
226616 | 226616 | 2020-06-10 | Mahoning | Ohio | 39099 | 1529 | 195 |
229720 | 229720 | 2020-06-11 | Mahoning | Ohio | 39099 | 1563 | 202 |
232825 | 232825 | 2020-06-12 | Mahoning | Ohio | 39099 | 1576 | 204 |
235930 | 235930 | 2020-06-13 | Mahoning | Ohio | 39099 | 1586 | 214 |
239038 | 239038 | 2020-06-14 | Mahoning | Ohio | 39099 | 1595 | 214 |
242147 | 242147 | 2020-06-15 | Mahoning | Ohio | 39099 | 1600 | 216 |
245259 | 245259 | 2020-06-16 | Mahoning | Ohio | 39099 | 1607 | 218 |
248372 | 248372 | 2020-06-17 | Mahoning | Ohio | 39099 | 1606 | 218 |
251487 | 251487 | 2020-06-18 | Mahoning | Ohio | 39099 | 1619 | 218 |
254602 | 254602 | 2020-06-19 | Mahoning | Ohio | 39099 | 1632 | 223 |
257727 | 257727 | 2020-06-20 | Mahoning | Ohio | 39099 | 1639 | 224 |
260854 | 260854 | 2020-06-21 | Mahoning | Ohio | 39099 | 1654 | 224 |
263982 | 263982 | 2020-06-22 | Mahoning | Ohio | 39099 | 1665 | 224 |
267110 | 267110 | 2020-06-23 | Mahoning | Ohio | 39099 | 1669 | 225 |
270244 | 270244 | 2020-06-24 | Mahoning | Ohio | 39099 | 1680 | 226 |
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);