ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 39057 and state = "Ohio" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
7908 | 7908 | 2020-03-22 | Greene | Ohio | 39057 | 1 | 0 |
9111 | 9111 | 2020-03-23 | Greene | Ohio | 39057 | 1 | 0 |
10426 | 10426 | 2020-03-24 | Greene | Ohio | 39057 | 3 | 0 |
11874 | 11874 | 2020-03-25 | Greene | Ohio | 39057 | 3 | 0 |
13481 | 13481 | 2020-03-26 | Greene | Ohio | 39057 | 3 | 0 |
15219 | 15219 | 2020-03-27 | Greene | Ohio | 39057 | 3 | 0 |
17061 | 17061 | 2020-03-28 | Greene | Ohio | 39057 | 3 | 0 |
18995 | 18995 | 2020-03-29 | Greene | Ohio | 39057 | 3 | 0 |
21039 | 21039 | 2020-03-30 | Greene | Ohio | 39057 | 3 | 0 |
23171 | 23171 | 2020-03-31 | Greene | Ohio | 39057 | 6 | 1 |
25366 | 25366 | 2020-04-01 | Greene | Ohio | 39057 | 8 | 1 |
27632 | 27632 | 2020-04-02 | Greene | Ohio | 39057 | 8 | 1 |
29961 | 29961 | 2020-04-03 | Greene | Ohio | 39057 | 9 | 1 |
32350 | 32350 | 2020-04-04 | Greene | Ohio | 39057 | 11 | 1 |
34783 | 34783 | 2020-04-05 | Greene | Ohio | 39057 | 13 | 1 |
37252 | 37252 | 2020-04-06 | Greene | Ohio | 39057 | 15 | 1 |
39769 | 39769 | 2020-04-07 | Greene | Ohio | 39057 | 20 | 1 |
42327 | 42327 | 2020-04-08 | Greene | Ohio | 39057 | 21 | 1 |
44912 | 44912 | 2020-04-09 | Greene | Ohio | 39057 | 21 | 1 |
47527 | 47527 | 2020-04-10 | Greene | Ohio | 39057 | 22 | 1 |
50182 | 50182 | 2020-04-11 | Greene | Ohio | 39057 | 24 | 1 |
52855 | 52855 | 2020-04-12 | Greene | Ohio | 39057 | 28 | 1 |
55539 | 55539 | 2020-04-13 | Greene | Ohio | 39057 | 30 | 1 |
58240 | 58240 | 2020-04-14 | Greene | Ohio | 39057 | 31 | 2 |
60954 | 60954 | 2020-04-15 | Greene | Ohio | 39057 | 31 | 1 |
63680 | 63680 | 2020-04-16 | Greene | Ohio | 39057 | 33 | 1 |
66423 | 66423 | 2020-04-17 | Greene | Ohio | 39057 | 33 | 2 |
69180 | 69180 | 2020-04-18 | Greene | Ohio | 39057 | 39 | 2 |
71947 | 71947 | 2020-04-19 | Greene | Ohio | 39057 | 38 | 2 |
74722 | 74722 | 2020-04-20 | Greene | Ohio | 39057 | 39 | 2 |
77503 | 77503 | 2020-04-21 | Greene | Ohio | 39057 | 39 | 3 |
80293 | 80293 | 2020-04-22 | Greene | Ohio | 39057 | 39 | 3 |
83092 | 83092 | 2020-04-23 | Greene | Ohio | 39057 | 40 | 3 |
85896 | 85896 | 2020-04-24 | Greene | Ohio | 39057 | 40 | 3 |
88710 | 88710 | 2020-04-25 | Greene | Ohio | 39057 | 41 | 3 |
91526 | 91526 | 2020-04-26 | Greene | Ohio | 39057 | 43 | 3 |
94352 | 94352 | 2020-04-27 | Greene | Ohio | 39057 | 45 | 3 |
97189 | 97189 | 2020-04-28 | Greene | Ohio | 39057 | 45 | 4 |
100038 | 100038 | 2020-04-29 | Greene | Ohio | 39057 | 46 | 4 |
102891 | 102891 | 2020-04-30 | Greene | Ohio | 39057 | 46 | 4 |
105754 | 105754 | 2020-05-01 | Greene | Ohio | 39057 | 46 | 4 |
108621 | 108621 | 2020-05-02 | Greene | Ohio | 39057 | 48 | 4 |
111495 | 111495 | 2020-05-03 | Greene | Ohio | 39057 | 48 | 4 |
114376 | 114376 | 2020-05-04 | Greene | Ohio | 39057 | 49 | 4 |
117257 | 117257 | 2020-05-05 | Greene | Ohio | 39057 | 50 | 5 |
120218 | 120218 | 2020-05-06 | Greene | Ohio | 39057 | 50 | 5 |
123195 | 123195 | 2020-05-07 | Greene | Ohio | 39057 | 52 | 5 |
126178 | 126178 | 2020-05-08 | Greene | Ohio | 39057 | 52 | 5 |
129167 | 129167 | 2020-05-09 | Greene | Ohio | 39057 | 53 | 5 |
132156 | 132156 | 2020-05-10 | Greene | Ohio | 39057 | 59 | 5 |
135147 | 135147 | 2020-05-11 | Greene | Ohio | 39057 | 63 | 5 |
138137 | 138137 | 2020-05-12 | Greene | Ohio | 39057 | 67 | 5 |
141133 | 141133 | 2020-05-13 | Greene | Ohio | 39057 | 68 | 5 |
144128 | 144128 | 2020-05-14 | Greene | Ohio | 39057 | 70 | 5 |
147129 | 147129 | 2020-05-15 | Greene | Ohio | 39057 | 73 | 5 |
150136 | 150136 | 2020-05-16 | Greene | Ohio | 39057 | 75 | 5 |
153147 | 153147 | 2020-05-17 | Greene | Ohio | 39057 | 75 | 5 |
156164 | 156164 | 2020-05-18 | Greene | Ohio | 39057 | 78 | 5 |
159184 | 159184 | 2020-05-19 | Greene | Ohio | 39057 | 78 | 5 |
162211 | 162211 | 2020-05-20 | Greene | Ohio | 39057 | 85 | 5 |
165240 | 165240 | 2020-05-21 | Greene | Ohio | 39057 | 86 | 5 |
168276 | 168276 | 2020-05-22 | Greene | Ohio | 39057 | 86 | 5 |
171315 | 171315 | 2020-05-23 | Greene | Ohio | 39057 | 92 | 5 |
174357 | 174357 | 2020-05-24 | Greene | Ohio | 39057 | 93 | 5 |
177401 | 177401 | 2020-05-25 | Greene | Ohio | 39057 | 93 | 5 |
180444 | 180444 | 2020-05-26 | Greene | Ohio | 39057 | 94 | 5 |
183493 | 183493 | 2020-05-27 | Greene | Ohio | 39057 | 98 | 5 |
186550 | 186550 | 2020-05-28 | Greene | Ohio | 39057 | 101 | 5 |
189610 | 189610 | 2020-05-29 | Greene | Ohio | 39057 | 101 | 5 |
192674 | 192674 | 2020-05-30 | Greene | Ohio | 39057 | 101 | 5 |
195744 | 195744 | 2020-05-31 | Greene | Ohio | 39057 | 101 | 5 |
198817 | 198817 | 2020-06-01 | Greene | Ohio | 39057 | 103 | 5 |
201892 | 201892 | 2020-06-02 | Greene | Ohio | 39057 | 102 | 5 |
204969 | 204969 | 2020-06-03 | Greene | Ohio | 39057 | 102 | 5 |
208050 | 208050 | 2020-06-04 | Greene | Ohio | 39057 | 105 | 5 |
211132 | 211132 | 2020-06-05 | Greene | Ohio | 39057 | 106 | 5 |
214218 | 214218 | 2020-06-06 | Greene | Ohio | 39057 | 108 | 5 |
217308 | 217308 | 2020-06-07 | Greene | Ohio | 39057 | 111 | 5 |
220400 | 220400 | 2020-06-08 | Greene | Ohio | 39057 | 114 | 5 |
223495 | 223495 | 2020-06-09 | Greene | Ohio | 39057 | 120 | 6 |
226595 | 226595 | 2020-06-10 | Greene | Ohio | 39057 | 122 | 6 |
229699 | 229699 | 2020-06-11 | Greene | Ohio | 39057 | 129 | 6 |
232804 | 232804 | 2020-06-12 | Greene | Ohio | 39057 | 132 | 6 |
235909 | 235909 | 2020-06-13 | Greene | Ohio | 39057 | 133 | 6 |
239017 | 239017 | 2020-06-14 | Greene | Ohio | 39057 | 135 | 6 |
242126 | 242126 | 2020-06-15 | Greene | Ohio | 39057 | 143 | 6 |
245238 | 245238 | 2020-06-16 | Greene | Ohio | 39057 | 151 | 6 |
248351 | 248351 | 2020-06-17 | Greene | Ohio | 39057 | 150 | 6 |
251466 | 251466 | 2020-06-18 | Greene | Ohio | 39057 | 156 | 6 |
254581 | 254581 | 2020-06-19 | Greene | Ohio | 39057 | 158 | 8 |
257706 | 257706 | 2020-06-20 | Greene | Ohio | 39057 | 165 | 8 |
260833 | 260833 | 2020-06-21 | Greene | Ohio | 39057 | 169 | 8 |
263961 | 263961 | 2020-06-22 | Greene | Ohio | 39057 | 175 | 8 |
267089 | 267089 | 2020-06-23 | Greene | Ohio | 39057 | 177 | 8 |
270223 | 270223 | 2020-06-24 | Greene | Ohio | 39057 | 183 | 9 |
273362 | 273362 | 2020-06-25 | Greene | Ohio | 39057 | 187 | 9 |
276509 | 276509 | 2020-06-26 | Greene | Ohio | 39057 | 189 | 9 |
279657 | 279657 | 2020-06-27 | Greene | Ohio | 39057 | 193 | 9 |
282803 | 282803 | 2020-06-28 | Greene | Ohio | 39057 | 194 | 9 |
285948 | 285948 | 2020-06-29 | Greene | Ohio | 39057 | 201 | 9 |
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);