ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Daviess" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
33766 | 33766 | 2020-04-05 | Daviess | Indiana | 18027 | 2 | 0 |
36219 | 36219 | 2020-04-06 | Daviess | Indiana | 18027 | 2 | 0 |
38717 | 38717 | 2020-04-07 | Daviess | Indiana | 18027 | 4 | 0 |
41263 | 41263 | 2020-04-08 | Daviess | Indiana | 18027 | 5 | 1 |
43839 | 43839 | 2020-04-09 | Daviess | Indiana | 18027 | 8 | 1 |
46443 | 46443 | 2020-04-10 | Daviess | Indiana | 18027 | 9 | 1 |
49077 | 49077 | 2020-04-11 | Daviess | Indiana | 18027 | 9 | 1 |
51740 | 51740 | 2020-04-12 | Daviess | Indiana | 18027 | 10 | 1 |
54421 | 54421 | 2020-04-13 | Daviess | Indiana | 18027 | 10 | 1 |
57114 | 57114 | 2020-04-14 | Daviess | Indiana | 18027 | 12 | 1 |
59822 | 59822 | 2020-04-15 | Daviess | Indiana | 18027 | 21 | 1 |
62543 | 62543 | 2020-04-16 | Daviess | Indiana | 18027 | 24 | 1 |
65277 | 65277 | 2020-04-17 | Daviess | Indiana | 18027 | 27 | 1 |
68026 | 68026 | 2020-04-18 | Daviess | Indiana | 18027 | 29 | 2 |
70788 | 70788 | 2020-04-19 | Daviess | Indiana | 18027 | 35 | 4 |
73559 | 73559 | 2020-04-20 | Daviess | Indiana | 18027 | 35 | 4 |
76336 | 76336 | 2020-04-21 | Daviess | Indiana | 18027 | 39 | 6 |
79120 | 79120 | 2020-04-22 | Daviess | Indiana | 18027 | 39 | 7 |
81913 | 81913 | 2020-04-23 | Daviess | Indiana | 18027 | 39 | 8 |
84713 | 84713 | 2020-04-24 | Daviess | Indiana | 18027 | 43 | 9 |
87523 | 87523 | 2020-04-25 | Daviess | Indiana | 18027 | 44 | 10 |
90339 | 90339 | 2020-04-26 | Daviess | Indiana | 18027 | 45 | 11 |
93158 | 93158 | 2020-04-27 | Daviess | Indiana | 18027 | 45 | 9 |
95990 | 95990 | 2020-04-28 | Daviess | Indiana | 18027 | 47 | 12 |
98834 | 98834 | 2020-04-29 | Daviess | Indiana | 18027 | 49 | 13 |
101685 | 101685 | 2020-04-30 | Daviess | Indiana | 18027 | 49 | 13 |
104541 | 104541 | 2020-05-01 | Daviess | Indiana | 18027 | 49 | 15 |
107406 | 107406 | 2020-05-02 | Daviess | Indiana | 18027 | 52 | 16 |
110276 | 110276 | 2020-05-03 | Daviess | Indiana | 18027 | 53 | 16 |
113151 | 113151 | 2020-05-04 | Daviess | Indiana | 18027 | 54 | 17 |
116034 | 116034 | 2020-05-05 | Daviess | Indiana | 18027 | 54 | 17 |
118994 | 118994 | 2020-05-06 | Daviess | Indiana | 18027 | 54 | 17 |
121964 | 121964 | 2020-05-07 | Daviess | Indiana | 18027 | 56 | 17 |
124944 | 124944 | 2020-05-08 | Daviess | Indiana | 18027 | 56 | 17 |
127931 | 127931 | 2020-05-09 | Daviess | Indiana | 18027 | 56 | 17 |
130922 | 130922 | 2020-05-10 | Daviess | Indiana | 18027 | 56 | 17 |
133912 | 133912 | 2020-05-11 | Daviess | Indiana | 18027 | 56 | 17 |
136901 | 136901 | 2020-05-12 | Daviess | Indiana | 18027 | 57 | 17 |
139893 | 139893 | 2020-05-13 | Daviess | Indiana | 18027 | 58 | 17 |
142889 | 142889 | 2020-05-14 | Daviess | Indiana | 18027 | 59 | 17 |
145889 | 145889 | 2020-05-15 | Daviess | Indiana | 18027 | 61 | 17 |
148893 | 148893 | 2020-05-16 | Daviess | Indiana | 18027 | 63 | 17 |
151902 | 151902 | 2020-05-17 | Daviess | Indiana | 18027 | 66 | 17 |
154914 | 154914 | 2020-05-18 | Daviess | Indiana | 18027 | 73 | 17 |
157930 | 157930 | 2020-05-19 | Daviess | Indiana | 18027 | 73 | 17 |
160956 | 160956 | 2020-05-20 | Daviess | Indiana | 18027 | 73 | 17 |
163984 | 163984 | 2020-05-21 | Daviess | Indiana | 18027 | 75 | 18 |
167017 | 167017 | 2020-05-22 | Daviess | Indiana | 18027 | 75 | 18 |
170054 | 170054 | 2020-05-23 | Daviess | Indiana | 18027 | 83 | 18 |
173095 | 173095 | 2020-05-24 | Daviess | Indiana | 18027 | 83 | 18 |
176139 | 176139 | 2020-05-25 | Daviess | Indiana | 18027 | 84 | 18 |
179183 | 179183 | 2020-05-26 | Daviess | Indiana | 18027 | 84 | 18 |
182227 | 182227 | 2020-05-27 | Daviess | Indiana | 18027 | 86 | 18 |
185281 | 185281 | 2020-05-28 | Daviess | Indiana | 18027 | 86 | 18 |
188339 | 188339 | 2020-05-29 | Daviess | Indiana | 18027 | 87 | 18 |
191404 | 191404 | 2020-05-30 | Daviess | Indiana | 18027 | 87 | 18 |
194471 | 194471 | 2020-05-31 | Daviess | Indiana | 18027 | 90 | 18 |
197541 | 197541 | 2020-06-01 | Daviess | Indiana | 18027 | 94 | 18 |
200614 | 200614 | 2020-06-02 | Daviess | Indiana | 18027 | 96 | 18 |
203690 | 203690 | 2020-06-03 | Daviess | Indiana | 18027 | 97 | 18 |
206770 | 206770 | 2020-06-04 | Daviess | Indiana | 18027 | 101 | 18 |
209851 | 209851 | 2020-06-05 | Daviess | Indiana | 18027 | 106 | 18 |
212936 | 212936 | 2020-06-06 | Daviess | Indiana | 18027 | 109 | 18 |
216023 | 216023 | 2020-06-07 | Daviess | Indiana | 18027 | 109 | 18 |
219115 | 219115 | 2020-06-08 | Daviess | Indiana | 18027 | 112 | 18 |
222210 | 222210 | 2020-06-09 | Daviess | Indiana | 18027 | 113 | 18 |
225305 | 225305 | 2020-06-10 | Daviess | Indiana | 18027 | 115 | 18 |
228407 | 228407 | 2020-06-11 | Daviess | Indiana | 18027 | 118 | 18 |
231510 | 231510 | 2020-06-12 | Daviess | Indiana | 18027 | 119 | 18 |
234616 | 234616 | 2020-06-13 | Daviess | Indiana | 18027 | 119 | 18 |
237723 | 237723 | 2020-06-14 | Daviess | Indiana | 18027 | 123 | 18 |
240831 | 240831 | 2020-06-15 | Daviess | Indiana | 18027 | 125 | 18 |
243942 | 243942 | 2020-06-16 | Daviess | Indiana | 18027 | 128 | 18 |
247055 | 247055 | 2020-06-17 | Daviess | Indiana | 18027 | 130 | 18 |
250167 | 250167 | 2020-06-18 | Daviess | Indiana | 18027 | 129 | 18 |
253282 | 253282 | 2020-06-19 | Daviess | Indiana | 18027 | 131 | 18 |
256402 | 256402 | 2020-06-20 | Daviess | Indiana | 18027 | 132 | 18 |
259528 | 259528 | 2020-06-21 | Daviess | Indiana | 18027 | 134 | 18 |
262655 | 262655 | 2020-06-22 | Daviess | Indiana | 18027 | 134 | 18 |
265783 | 265783 | 2020-06-23 | Daviess | Indiana | 18027 | 134 | 18 |
268913 | 268913 | 2020-06-24 | Daviess | Indiana | 18027 | 134 | 18 |
272050 | 272050 | 2020-06-25 | Daviess | Indiana | 18027 | 134 | 18 |
275192 | 275192 | 2020-06-26 | Daviess | Indiana | 18027 | 134 | 18 |
278340 | 278340 | 2020-06-27 | Daviess | Indiana | 18027 | 135 | 18 |
281488 | 281488 | 2020-06-28 | Daviess | Indiana | 18027 | 136 | 18 |
284633 | 284633 | 2020-06-29 | Daviess | Indiana | 18027 | 137 | 18 |
287782 | 287782 | 2020-06-30 | Daviess | Indiana | 18027 | 140 | 18 |
290932 | 290932 | 2020-07-01 | Daviess | Indiana | 18027 | 141 | 18 |
294086 | 294086 | 2020-07-02 | Daviess | Indiana | 18027 | 141 | 18 |
297244 | 297244 | 2020-07-03 | Daviess | Indiana | 18027 | 143 | 18 |
300406 | 300406 | 2020-07-04 | Daviess | Indiana | 18027 | 144 | 18 |
303570 | 303570 | 2020-07-05 | Daviess | Indiana | 18027 | 145 | 19 |
306735 | 306735 | 2020-07-06 | Daviess | Indiana | 18027 | 145 | 19 |
309903 | 309903 | 2020-07-07 | Daviess | Indiana | 18027 | 149 | 19 |
313073 | 313073 | 2020-07-08 | Daviess | Indiana | 18027 | 150 | 19 |
316247 | 316247 | 2020-07-09 | Daviess | Indiana | 18027 | 152 | 19 |
319420 | 319420 | 2020-07-10 | Daviess | Indiana | 18027 | 152 | 19 |
322599 | 322599 | 2020-07-11 | Daviess | Indiana | 18027 | 152 | 19 |
325780 | 325780 | 2020-07-12 | Daviess | Indiana | 18027 | 153 | 19 |
328966 | 328966 | 2020-07-13 | Daviess | Indiana | 18027 | 153 | 19 |
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);