ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39153 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 |
---|---|---|---|---|---|---|---|
2192 | 2192 | 2020-03-14 | Summit | Ohio | 39153 | 2 | 0 |
2608 | 2608 | 2020-03-15 | Summit | Ohio | 39153 | 2 | 0 |
3071 | 3071 | 2020-03-16 | Summit | Ohio | 39153 | 2 | 0 |
3598 | 3598 | 2020-03-17 | Summit | Ohio | 39153 | 4 | 0 |
4213 | 4213 | 2020-03-18 | Summit | Ohio | 39153 | 4 | 0 |
4947 | 4947 | 2020-03-19 | Summit | Ohio | 39153 | 6 | 0 |
5811 | 5811 | 2020-03-20 | Summit | Ohio | 39153 | 10 | 0 |
6812 | 6812 | 2020-03-21 | Summit | Ohio | 39153 | 15 | 0 |
7924 | 7924 | 2020-03-22 | Summit | Ohio | 39153 | 23 | 0 |
9131 | 9131 | 2020-03-23 | Summit | Ohio | 39153 | 28 | 0 |
10447 | 10447 | 2020-03-24 | Summit | Ohio | 39153 | 36 | 0 |
11899 | 11899 | 2020-03-25 | Summit | Ohio | 39153 | 43 | 0 |
13508 | 13508 | 2020-03-26 | Summit | Ohio | 39153 | 50 | 0 |
15247 | 15247 | 2020-03-27 | Summit | Ohio | 39153 | 65 | 3 |
17091 | 17091 | 2020-03-28 | Summit | Ohio | 39153 | 79 | 4 |
19025 | 19025 | 2020-03-29 | Summit | Ohio | 39153 | 99 | 5 |
21072 | 21072 | 2020-03-30 | Summit | Ohio | 39153 | 118 | 5 |
23205 | 23205 | 2020-03-31 | Summit | Ohio | 39153 | 131 | 5 |
25401 | 25401 | 2020-04-01 | Summit | Ohio | 39153 | 144 | 7 |
27669 | 27669 | 2020-04-02 | Summit | Ohio | 39153 | 155 | 7 |
29998 | 29998 | 2020-04-03 | Summit | Ohio | 39153 | 165 | 7 |
32387 | 32387 | 2020-04-04 | Summit | Ohio | 39153 | 184 | 7 |
34821 | 34821 | 2020-04-05 | Summit | Ohio | 39153 | 184 | 9 |
37294 | 37294 | 2020-04-06 | Summit | Ohio | 39153 | 189 | 10 |
39812 | 39812 | 2020-04-07 | Summit | Ohio | 39153 | 199 | 12 |
42372 | 42372 | 2020-04-08 | Summit | Ohio | 39153 | 211 | 12 |
44958 | 44958 | 2020-04-09 | Summit | Ohio | 39153 | 221 | 12 |
47573 | 47573 | 2020-04-10 | Summit | Ohio | 39153 | 235 | 13 |
50229 | 50229 | 2020-04-11 | Summit | Ohio | 39153 | 243 | 14 |
52902 | 52902 | 2020-04-12 | Summit | Ohio | 39153 | 257 | 14 |
55586 | 55586 | 2020-04-13 | Summit | Ohio | 39153 | 262 | 15 |
58287 | 58287 | 2020-04-14 | Summit | Ohio | 39153 | 273 | 15 |
61002 | 61002 | 2020-04-15 | Summit | Ohio | 39153 | 294 | 15 |
63728 | 63728 | 2020-04-16 | Summit | Ohio | 39153 | 310 | 16 |
66471 | 66471 | 2020-04-17 | Summit | Ohio | 39153 | 323 | 17 |
69228 | 69228 | 2020-04-18 | Summit | Ohio | 39153 | 340 | 20 |
71995 | 71995 | 2020-04-19 | Summit | Ohio | 39153 | 350 | 21 |
74770 | 74770 | 2020-04-20 | Summit | Ohio | 39153 | 370 | 24 |
77551 | 77551 | 2020-04-21 | Summit | Ohio | 39153 | 385 | 28 |
80341 | 80341 | 2020-04-22 | Summit | Ohio | 39153 | 415 | 30 |
83140 | 83140 | 2020-04-23 | Summit | Ohio | 39153 | 447 | 32 |
85944 | 85944 | 2020-04-24 | Summit | Ohio | 39153 | 460 | 35 |
88758 | 88758 | 2020-04-25 | Summit | Ohio | 39153 | 475 | 35 |
91574 | 91574 | 2020-04-26 | Summit | Ohio | 39153 | 485 | 38 |
94400 | 94400 | 2020-04-27 | Summit | Ohio | 39153 | 500 | 39 |
97237 | 97237 | 2020-04-28 | Summit | Ohio | 39153 | 542 | 43 |
100086 | 100086 | 2020-04-29 | Summit | Ohio | 39153 | 584 | 49 |
102939 | 102939 | 2020-04-30 | Summit | Ohio | 39153 | 608 | 49 |
105802 | 105802 | 2020-05-01 | Summit | Ohio | 39153 | 639 | 49 |
108669 | 108669 | 2020-05-02 | Summit | Ohio | 39153 | 679 | 57 |
111543 | 111543 | 2020-05-03 | Summit | Ohio | 39153 | 701 | 58 |
114424 | 114424 | 2020-05-04 | Summit | Ohio | 39153 | 716 | 58 |
117305 | 117305 | 2020-05-05 | Summit | Ohio | 39153 | 751 | 66 |
120266 | 120266 | 2020-05-06 | Summit | Ohio | 39153 | 787 | 70 |
123243 | 123243 | 2020-05-07 | Summit | Ohio | 39153 | 831 | 73 |
126226 | 126226 | 2020-05-08 | Summit | Ohio | 39153 | 867 | 74 |
129215 | 129215 | 2020-05-09 | Summit | Ohio | 39153 | 880 | 78 |
132204 | 132204 | 2020-05-10 | Summit | Ohio | 39153 | 892 | 78 |
135195 | 135195 | 2020-05-11 | Summit | Ohio | 39153 | 915 | 78 |
138185 | 138185 | 2020-05-12 | Summit | Ohio | 39153 | 930 | 86 |
141181 | 141181 | 2020-05-13 | Summit | Ohio | 39153 | 946 | 88 |
144176 | 144176 | 2020-05-14 | Summit | Ohio | 39153 | 976 | 101 |
147177 | 147177 | 2020-05-15 | Summit | Ohio | 39153 | 989 | 104 |
150184 | 150184 | 2020-05-16 | Summit | Ohio | 39153 | 995 | 110 |
153195 | 153195 | 2020-05-17 | Summit | Ohio | 39153 | 1004 | 110 |
156212 | 156212 | 2020-05-18 | Summit | Ohio | 39153 | 1028 | 112 |
159232 | 159232 | 2020-05-19 | Summit | Ohio | 39153 | 1042 | 113 |
162259 | 162259 | 2020-05-20 | Summit | Ohio | 39153 | 1077 | 131 |
165288 | 165288 | 2020-05-21 | Summit | Ohio | 39153 | 1141 | 139 |
168324 | 168324 | 2020-05-22 | Summit | Ohio | 39153 | 1183 | 148 |
171363 | 171363 | 2020-05-23 | Summit | Ohio | 39153 | 1204 | 159 |
174405 | 174405 | 2020-05-24 | Summit | Ohio | 39153 | 1220 | 159 |
177449 | 177449 | 2020-05-25 | Summit | Ohio | 39153 | 1236 | 159 |
180492 | 180492 | 2020-05-26 | Summit | Ohio | 39153 | 1277 | 159 |
183541 | 183541 | 2020-05-27 | Summit | Ohio | 39153 | 1315 | 160 |
186598 | 186598 | 2020-05-28 | Summit | Ohio | 39153 | 1335 | 172 |
189658 | 189658 | 2020-05-29 | Summit | Ohio | 39153 | 1380 | 172 |
192722 | 192722 | 2020-05-30 | Summit | Ohio | 39153 | 1390 | 172 |
195792 | 195792 | 2020-05-31 | Summit | Ohio | 39153 | 1420 | 173 |
198865 | 198865 | 2020-06-01 | Summit | Ohio | 39153 | 1453 | 176 |
201940 | 201940 | 2020-06-02 | Summit | Ohio | 39153 | 1475 | 180 |
205017 | 205017 | 2020-06-03 | Summit | Ohio | 39153 | 1487 | 181 |
208098 | 208098 | 2020-06-04 | Summit | Ohio | 39153 | 1505 | 181 |
211180 | 211180 | 2020-06-05 | Summit | Ohio | 39153 | 1529 | 181 |
214266 | 214266 | 2020-06-06 | Summit | Ohio | 39153 | 1540 | 183 |
217356 | 217356 | 2020-06-07 | Summit | Ohio | 39153 | 1548 | 183 |
220448 | 220448 | 2020-06-08 | Summit | Ohio | 39153 | 1571 | 184 |
223543 | 223543 | 2020-06-09 | Summit | Ohio | 39153 | 1592 | 185 |
226643 | 226643 | 2020-06-10 | Summit | Ohio | 39153 | 1621 | 187 |
229747 | 229747 | 2020-06-11 | Summit | Ohio | 39153 | 1623 | 188 |
232852 | 232852 | 2020-06-12 | Summit | Ohio | 39153 | 1638 | 190 |
235957 | 235957 | 2020-06-13 | Summit | Ohio | 39153 | 1655 | 192 |
239065 | 239065 | 2020-06-14 | Summit | Ohio | 39153 | 1666 | 192 |
242174 | 242174 | 2020-06-15 | Summit | Ohio | 39153 | 1675 | 194 |
245286 | 245286 | 2020-06-16 | Summit | Ohio | 39153 | 1706 | 196 |
248399 | 248399 | 2020-06-17 | Summit | Ohio | 39153 | 1712 | 195 |
251514 | 251514 | 2020-06-18 | Summit | Ohio | 39153 | 1722 | 196 |
254629 | 254629 | 2020-06-19 | Summit | Ohio | 39153 | 1735 | 199 |
257754 | 257754 | 2020-06-20 | Summit | Ohio | 39153 | 1743 | 201 |
260881 | 260881 | 2020-06-21 | Summit | Ohio | 39153 | 1756 | 201 |
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);