ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Hamilton" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282805 | 282805 | 2020-06-28 | Hamilton | Ohio | 39061 | 4794 | 191 |
279659 | 279659 | 2020-06-27 | Hamilton | Ohio | 39061 | 4661 | 191 |
276511 | 276511 | 2020-06-26 | Hamilton | Ohio | 39061 | 4491 | 191 |
273364 | 273364 | 2020-06-25 | Hamilton | Ohio | 39061 | 4337 | 191 |
270225 | 270225 | 2020-06-24 | Hamilton | Ohio | 39061 | 4189 | 189 |
267091 | 267091 | 2020-06-23 | Hamilton | Ohio | 39061 | 4098 | 188 |
263963 | 263963 | 2020-06-22 | Hamilton | Ohio | 39061 | 4020 | 187 |
260835 | 260835 | 2020-06-21 | Hamilton | Ohio | 39061 | 3829 | 186 |
257708 | 257708 | 2020-06-20 | Hamilton | Ohio | 39061 | 3744 | 186 |
254583 | 254583 | 2020-06-19 | Hamilton | Ohio | 39061 | 3634 | 184 |
251468 | 251468 | 2020-06-18 | Hamilton | Ohio | 39061 | 3508 | 181 |
248353 | 248353 | 2020-06-17 | Hamilton | Ohio | 39061 | 3374 | 181 |
245240 | 245240 | 2020-06-16 | Hamilton | Ohio | 39061 | 3316 | 181 |
242128 | 242128 | 2020-06-15 | Hamilton | Ohio | 39061 | 3250 | 179 |
239019 | 239019 | 2020-06-14 | Hamilton | Ohio | 39061 | 3185 | 179 |
235911 | 235911 | 2020-06-13 | Hamilton | Ohio | 39061 | 3130 | 179 |
232806 | 232806 | 2020-06-12 | Hamilton | Ohio | 39061 | 3078 | 178 |
229701 | 229701 | 2020-06-11 | Hamilton | Ohio | 39061 | 3011 | 177 |
226597 | 226597 | 2020-06-10 | Hamilton | Ohio | 39061 | 2975 | 174 |
223497 | 223497 | 2020-06-09 | Hamilton | Ohio | 39061 | 2918 | 173 |
220402 | 220402 | 2020-06-08 | Hamilton | Ohio | 39061 | 2891 | 172 |
217310 | 217310 | 2020-06-07 | Hamilton | Ohio | 39061 | 2860 | 171 |
214220 | 214220 | 2020-06-06 | Hamilton | Ohio | 39061 | 2831 | 171 |
211134 | 211134 | 2020-06-05 | Hamilton | Ohio | 39061 | 2811 | 171 |
208052 | 208052 | 2020-06-04 | Hamilton | Ohio | 39061 | 2767 | 167 |
204971 | 204971 | 2020-06-03 | Hamilton | Ohio | 39061 | 2739 | 164 |
201894 | 201894 | 2020-06-02 | Hamilton | Ohio | 39061 | 2721 | 156 |
198819 | 198819 | 2020-06-01 | Hamilton | Ohio | 39061 | 2698 | 151 |
195746 | 195746 | 2020-05-31 | Hamilton | Ohio | 39061 | 2672 | 150 |
192676 | 192676 | 2020-05-30 | Hamilton | Ohio | 39061 | 2642 | 148 |
189612 | 189612 | 2020-05-29 | Hamilton | Ohio | 39061 | 2603 | 147 |
186552 | 186552 | 2020-05-28 | Hamilton | Ohio | 39061 | 2555 | 135 |
183495 | 183495 | 2020-05-27 | Hamilton | Ohio | 39061 | 2523 | 131 |
180446 | 180446 | 2020-05-26 | Hamilton | Ohio | 39061 | 2492 | 128 |
177403 | 177403 | 2020-05-25 | Hamilton | Ohio | 39061 | 2458 | 128 |
174359 | 174359 | 2020-05-24 | Hamilton | Ohio | 39061 | 2403 | 128 |
171317 | 171317 | 2020-05-23 | Hamilton | Ohio | 39061 | 2349 | 128 |
168278 | 168278 | 2020-05-22 | Hamilton | Ohio | 39061 | 2279 | 124 |
165242 | 165242 | 2020-05-21 | Hamilton | Ohio | 39061 | 2228 | 123 |
162213 | 162213 | 2020-05-20 | Hamilton | Ohio | 39061 | 2167 | 117 |
159186 | 159186 | 2020-05-19 | Hamilton | Ohio | 39061 | 2138 | 117 |
156166 | 156166 | 2020-05-18 | Hamilton | Ohio | 39061 | 2082 | 112 |
153149 | 153149 | 2020-05-17 | Hamilton | Ohio | 39061 | 2047 | 111 |
150138 | 150138 | 2020-05-16 | Hamilton | Ohio | 39061 | 2007 | 111 |
147131 | 147131 | 2020-05-15 | Hamilton | Ohio | 39061 | 1961 | 109 |
144130 | 144130 | 2020-05-14 | Hamilton | Ohio | 39061 | 1927 | 105 |
141135 | 141135 | 2020-05-13 | Hamilton | Ohio | 39061 | 1886 | 105 |
138139 | 138139 | 2020-05-12 | Hamilton | Ohio | 39061 | 1859 | 102 |
135149 | 135149 | 2020-05-11 | Hamilton | Ohio | 39061 | 1823 | 101 |
132158 | 132158 | 2020-05-10 | Hamilton | Ohio | 39061 | 1757 | 101 |
129169 | 129169 | 2020-05-09 | Hamilton | Ohio | 39061 | 1731 | 99 |
126180 | 126180 | 2020-05-08 | Hamilton | Ohio | 39061 | 1664 | 100 |
123197 | 123197 | 2020-05-07 | Hamilton | Ohio | 39061 | 1572 | 93 |
120220 | 120220 | 2020-05-06 | Hamilton | Ohio | 39061 | 1527 | 93 |
117259 | 117259 | 2020-05-05 | Hamilton | Ohio | 39061 | 1480 | 83 |
114378 | 114378 | 2020-05-04 | Hamilton | Ohio | 39061 | 1434 | 80 |
111497 | 111497 | 2020-05-03 | Hamilton | Ohio | 39061 | 1380 | 80 |
108623 | 108623 | 2020-05-02 | Hamilton | Ohio | 39061 | 1353 | 78 |
105756 | 105756 | 2020-05-01 | Hamilton | Ohio | 39061 | 1297 | 75 |
102893 | 102893 | 2020-04-30 | Hamilton | Ohio | 39061 | 1218 | 71 |
100040 | 100040 | 2020-04-29 | Hamilton | Ohio | 39061 | 1150 | 68 |
97191 | 97191 | 2020-04-28 | Hamilton | Ohio | 39061 | 1091 | 58 |
94354 | 94354 | 2020-04-27 | Hamilton | Ohio | 39061 | 1048 | 56 |
91528 | 91528 | 2020-04-26 | Hamilton | Ohio | 39061 | 1005 | 56 |
88712 | 88712 | 2020-04-25 | Hamilton | Ohio | 39061 | 975 | 54 |
85898 | 85898 | 2020-04-24 | Hamilton | Ohio | 39061 | 932 | 51 |
83094 | 83094 | 2020-04-23 | Hamilton | Ohio | 39061 | 868 | 47 |
80295 | 80295 | 2020-04-22 | Hamilton | Ohio | 39061 | 785 | 45 |
77505 | 77505 | 2020-04-21 | Hamilton | Ohio | 39061 | 768 | 39 |
74724 | 74724 | 2020-04-20 | Hamilton | Ohio | 39061 | 735 | 37 |
71949 | 71949 | 2020-04-19 | Hamilton | Ohio | 39061 | 718 | 33 |
69182 | 69182 | 2020-04-18 | Hamilton | Ohio | 39061 | 701 | 30 |
66425 | 66425 | 2020-04-17 | Hamilton | Ohio | 39061 | 658 | 30 |
63682 | 63682 | 2020-04-16 | Hamilton | Ohio | 39061 | 615 | 29 |
60956 | 60956 | 2020-04-15 | Hamilton | Ohio | 39061 | 594 | 27 |
58242 | 58242 | 2020-04-14 | Hamilton | Ohio | 39061 | 576 | 24 |
55541 | 55541 | 2020-04-13 | Hamilton | Ohio | 39061 | 558 | 21 |
52857 | 52857 | 2020-04-12 | Hamilton | Ohio | 39061 | 535 | 17 |
50184 | 50184 | 2020-04-11 | Hamilton | Ohio | 39061 | 529 | 17 |
47529 | 47529 | 2020-04-10 | Hamilton | Ohio | 39061 | 504 | 14 |
44914 | 44914 | 2020-04-09 | Hamilton | Ohio | 39061 | 473 | 14 |
42329 | 42329 | 2020-04-08 | Hamilton | Ohio | 39061 | 437 | 13 |
39771 | 39771 | 2020-04-07 | Hamilton | Ohio | 39061 | 411 | 12 |
37254 | 37254 | 2020-04-06 | Hamilton | Ohio | 39061 | 394 | 9 |
34785 | 34785 | 2020-04-05 | Hamilton | Ohio | 39061 | 319 | 3 |
32352 | 32352 | 2020-04-04 | Hamilton | Ohio | 39061 | 288 | 2 |
29963 | 29963 | 2020-04-03 | Hamilton | Ohio | 39061 | 220 | 2 |
27634 | 27634 | 2020-04-02 | Hamilton | Ohio | 39061 | 178 | 2 |
25367 | 25367 | 2020-04-01 | Hamilton | Ohio | 39061 | 154 | 0 |
23172 | 23172 | 2020-03-31 | Hamilton | Ohio | 39061 | 124 | 0 |
21040 | 21040 | 2020-03-30 | Hamilton | Ohio | 39061 | 101 | 0 |
18996 | 18996 | 2020-03-29 | Hamilton | Ohio | 39061 | 85 | 0 |
17062 | 17062 | 2020-03-28 | Hamilton | Ohio | 39061 | 71 | 0 |
15220 | 15220 | 2020-03-27 | Hamilton | Ohio | 39061 | 63 | 0 |
13482 | 13482 | 2020-03-26 | Hamilton | Ohio | 39061 | 53 | 0 |
11875 | 11875 | 2020-03-25 | Hamilton | Ohio | 39061 | 48 | 0 |
10427 | 10427 | 2020-03-24 | Hamilton | Ohio | 39061 | 38 | 0 |
9112 | 9112 | 2020-03-23 | Hamilton | Ohio | 39061 | 26 | 0 |
7909 | 7909 | 2020-03-22 | Hamilton | Ohio | 39061 | 19 | 0 |
6799 | 6799 | 2020-03-21 | Hamilton | Ohio | 39061 | 8 | 0 |
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);