ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18061 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6374 | 6374 | 2020-03-21 | Harrison | Indiana | 18061 | 1 | 0 |
7428 | 7428 | 2020-03-22 | Harrison | Indiana | 18061 | 1 | 0 |
8586 | 8586 | 2020-03-23 | Harrison | Indiana | 18061 | 1 | 0 |
9854 | 9854 | 2020-03-24 | Harrison | Indiana | 18061 | 1 | 0 |
11248 | 11248 | 2020-03-25 | Harrison | Indiana | 18061 | 2 | 0 |
12805 | 12805 | 2020-03-26 | Harrison | Indiana | 18061 | 2 | 0 |
14486 | 14486 | 2020-03-27 | Harrison | Indiana | 18061 | 4 | 0 |
16284 | 16284 | 2020-03-28 | Harrison | Indiana | 18061 | 7 | 0 |
18187 | 18187 | 2020-03-29 | Harrison | Indiana | 18061 | 14 | 0 |
20193 | 20193 | 2020-03-30 | Harrison | Indiana | 18061 | 15 | 0 |
22287 | 22287 | 2020-03-31 | Harrison | Indiana | 18061 | 15 | 0 |
24457 | 24457 | 2020-04-01 | Harrison | Indiana | 18061 | 15 | 0 |
26696 | 26696 | 2020-04-02 | Harrison | Indiana | 18061 | 18 | 0 |
29006 | 29006 | 2020-04-03 | Harrison | Indiana | 18061 | 23 | 1 |
31372 | 31372 | 2020-04-04 | Harrison | Indiana | 18061 | 28 | 1 |
33783 | 33783 | 2020-04-05 | Harrison | Indiana | 18061 | 33 | 1 |
36236 | 36236 | 2020-04-06 | Harrison | Indiana | 18061 | 38 | 1 |
38734 | 38734 | 2020-04-07 | Harrison | Indiana | 18061 | 48 | 1 |
41280 | 41280 | 2020-04-08 | Harrison | Indiana | 18061 | 48 | 1 |
43856 | 43856 | 2020-04-09 | Harrison | Indiana | 18061 | 51 | 1 |
46460 | 46460 | 2020-04-10 | Harrison | Indiana | 18061 | 50 | 1 |
49094 | 49094 | 2020-04-11 | Harrison | Indiana | 18061 | 54 | 2 |
51757 | 51757 | 2020-04-12 | Harrison | Indiana | 18061 | 55 | 2 |
54438 | 54438 | 2020-04-13 | Harrison | Indiana | 18061 | 58 | 2 |
57131 | 57131 | 2020-04-14 | Harrison | Indiana | 18061 | 58 | 2 |
59839 | 59839 | 2020-04-15 | Harrison | Indiana | 18061 | 59 | 2 |
62560 | 62560 | 2020-04-16 | Harrison | Indiana | 18061 | 61 | 2 |
65294 | 65294 | 2020-04-17 | Harrison | Indiana | 18061 | 65 | 2 |
68043 | 68043 | 2020-04-18 | Harrison | Indiana | 18061 | 85 | 2 |
70805 | 70805 | 2020-04-19 | Harrison | Indiana | 18061 | 87 | 2 |
73576 | 73576 | 2020-04-20 | Harrison | Indiana | 18061 | 102 | 3 |
76353 | 76353 | 2020-04-21 | Harrison | Indiana | 18061 | 104 | 3 |
79137 | 79137 | 2020-04-22 | Harrison | Indiana | 18061 | 106 | 4 |
81930 | 81930 | 2020-04-23 | Harrison | Indiana | 18061 | 109 | 5 |
84730 | 84730 | 2020-04-24 | Harrison | Indiana | 18061 | 112 | 5 |
87540 | 87540 | 2020-04-25 | Harrison | Indiana | 18061 | 116 | 5 |
90356 | 90356 | 2020-04-26 | Harrison | Indiana | 18061 | 119 | 6 |
93175 | 93175 | 2020-04-27 | Harrison | Indiana | 18061 | 122 | 6 |
96007 | 96007 | 2020-04-28 | Harrison | Indiana | 18061 | 126 | 6 |
98851 | 98851 | 2020-04-29 | Harrison | Indiana | 18061 | 128 | 8 |
101702 | 101702 | 2020-04-30 | Harrison | Indiana | 18061 | 130 | 9 |
104558 | 104558 | 2020-05-01 | Harrison | Indiana | 18061 | 130 | 9 |
107423 | 107423 | 2020-05-02 | Harrison | Indiana | 18061 | 136 | 9 |
110293 | 110293 | 2020-05-03 | Harrison | Indiana | 18061 | 139 | 9 |
113168 | 113168 | 2020-05-04 | Harrison | Indiana | 18061 | 139 | 9 |
116051 | 116051 | 2020-05-05 | Harrison | Indiana | 18061 | 139 | 10 |
119011 | 119011 | 2020-05-06 | Harrison | Indiana | 18061 | 146 | 12 |
121981 | 121981 | 2020-05-07 | Harrison | Indiana | 18061 | 151 | 12 |
124961 | 124961 | 2020-05-08 | Harrison | Indiana | 18061 | 154 | 12 |
127948 | 127948 | 2020-05-09 | Harrison | Indiana | 18061 | 157 | 12 |
130939 | 130939 | 2020-05-10 | Harrison | Indiana | 18061 | 158 | 12 |
133929 | 133929 | 2020-05-11 | Harrison | Indiana | 18061 | 161 | 13 |
136918 | 136918 | 2020-05-12 | Harrison | Indiana | 18061 | 163 | 14 |
139910 | 139910 | 2020-05-13 | Harrison | Indiana | 18061 | 166 | 14 |
142906 | 142906 | 2020-05-14 | Harrison | Indiana | 18061 | 167 | 15 |
145906 | 145906 | 2020-05-15 | Harrison | Indiana | 18061 | 169 | 16 |
148910 | 148910 | 2020-05-16 | Harrison | Indiana | 18061 | 168 | 16 |
151919 | 151919 | 2020-05-17 | Harrison | Indiana | 18061 | 171 | 16 |
154931 | 154931 | 2020-05-18 | Harrison | Indiana | 18061 | 174 | 17 |
157947 | 157947 | 2020-05-19 | Harrison | Indiana | 18061 | 175 | 19 |
160973 | 160973 | 2020-05-20 | Harrison | Indiana | 18061 | 176 | 20 |
164001 | 164001 | 2020-05-21 | Harrison | Indiana | 18061 | 179 | 21 |
167034 | 167034 | 2020-05-22 | Harrison | Indiana | 18061 | 180 | 21 |
170071 | 170071 | 2020-05-23 | Harrison | Indiana | 18061 | 184 | 22 |
173112 | 173112 | 2020-05-24 | Harrison | Indiana | 18061 | 185 | 22 |
176156 | 176156 | 2020-05-25 | Harrison | Indiana | 18061 | 186 | 22 |
179200 | 179200 | 2020-05-26 | Harrison | Indiana | 18061 | 189 | 23 |
182244 | 182244 | 2020-05-27 | Harrison | Indiana | 18061 | 190 | 23 |
185298 | 185298 | 2020-05-28 | Harrison | Indiana | 18061 | 191 | 23 |
188356 | 188356 | 2020-05-29 | Harrison | Indiana | 18061 | 194 | 23 |
191421 | 191421 | 2020-05-30 | Harrison | Indiana | 18061 | 196 | 24 |
194488 | 194488 | 2020-05-31 | Harrison | Indiana | 18061 | 196 | 24 |
197558 | 197558 | 2020-06-01 | Harrison | Indiana | 18061 | 196 | 24 |
200631 | 200631 | 2020-06-02 | Harrison | Indiana | 18061 | 198 | 24 |
203707 | 203707 | 2020-06-03 | Harrison | Indiana | 18061 | 198 | 24 |
206787 | 206787 | 2020-06-04 | Harrison | Indiana | 18061 | 197 | 24 |
209868 | 209868 | 2020-06-05 | Harrison | Indiana | 18061 | 198 | 24 |
212953 | 212953 | 2020-06-06 | Harrison | Indiana | 18061 | 198 | 24 |
216040 | 216040 | 2020-06-07 | Harrison | Indiana | 18061 | 197 | 24 |
219132 | 219132 | 2020-06-08 | Harrison | Indiana | 18061 | 199 | 24 |
222227 | 222227 | 2020-06-09 | Harrison | Indiana | 18061 | 200 | 24 |
225322 | 225322 | 2020-06-10 | Harrison | Indiana | 18061 | 200 | 24 |
228424 | 228424 | 2020-06-11 | Harrison | Indiana | 18061 | 200 | 24 |
231527 | 231527 | 2020-06-12 | Harrison | Indiana | 18061 | 200 | 24 |
234633 | 234633 | 2020-06-13 | Harrison | Indiana | 18061 | 200 | 24 |
237740 | 237740 | 2020-06-14 | Harrison | Indiana | 18061 | 200 | 24 |
240848 | 240848 | 2020-06-15 | Harrison | Indiana | 18061 | 200 | 24 |
243959 | 243959 | 2020-06-16 | Harrison | Indiana | 18061 | 201 | 24 |
247072 | 247072 | 2020-06-17 | Harrison | Indiana | 18061 | 202 | 24 |
250184 | 250184 | 2020-06-18 | Harrison | Indiana | 18061 | 203 | 24 |
253299 | 253299 | 2020-06-19 | Harrison | Indiana | 18061 | 202 | 24 |
256419 | 256419 | 2020-06-20 | Harrison | Indiana | 18061 | 202 | 24 |
259545 | 259545 | 2020-06-21 | Harrison | Indiana | 18061 | 202 | 24 |
262672 | 262672 | 2020-06-22 | Harrison | Indiana | 18061 | 202 | 24 |
265800 | 265800 | 2020-06-23 | Harrison | Indiana | 18061 | 202 | 24 |
268930 | 268930 | 2020-06-24 | Harrison | Indiana | 18061 | 203 | 24 |
272067 | 272067 | 2020-06-25 | Harrison | Indiana | 18061 | 205 | 24 |
275209 | 275209 | 2020-06-26 | Harrison | Indiana | 18061 | 205 | 24 |
278357 | 278357 | 2020-06-27 | Harrison | Indiana | 18061 | 205 | 24 |
281505 | 281505 | 2020-06-28 | Harrison | Indiana | 18061 | 207 | 24 |
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);