ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Ripley" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281543 | 281543 | 2020-06-28 | Ripley | Indiana | 18137 | 112 | 7 |
278395 | 278395 | 2020-06-27 | Ripley | Indiana | 18137 | 112 | 7 |
275247 | 275247 | 2020-06-26 | Ripley | Indiana | 18137 | 112 | 7 |
272105 | 272105 | 2020-06-25 | Ripley | Indiana | 18137 | 111 | 7 |
268968 | 268968 | 2020-06-24 | Ripley | Indiana | 18137 | 113 | 7 |
265838 | 265838 | 2020-06-23 | Ripley | Indiana | 18137 | 112 | 7 |
262710 | 262710 | 2020-06-22 | Ripley | Indiana | 18137 | 112 | 7 |
259583 | 259583 | 2020-06-21 | Ripley | Indiana | 18137 | 112 | 7 |
256457 | 256457 | 2020-06-20 | Ripley | Indiana | 18137 | 111 | 7 |
253337 | 253337 | 2020-06-19 | Ripley | Indiana | 18137 | 111 | 7 |
250222 | 250222 | 2020-06-18 | Ripley | Indiana | 18137 | 111 | 6 |
247110 | 247110 | 2020-06-17 | Ripley | Indiana | 18137 | 111 | 6 |
243997 | 243997 | 2020-06-16 | Ripley | Indiana | 18137 | 111 | 6 |
240886 | 240886 | 2020-06-15 | Ripley | Indiana | 18137 | 109 | 6 |
237778 | 237778 | 2020-06-14 | Ripley | Indiana | 18137 | 109 | 6 |
234671 | 234671 | 2020-06-13 | Ripley | Indiana | 18137 | 109 | 6 |
231565 | 231565 | 2020-06-12 | Ripley | Indiana | 18137 | 109 | 6 |
228462 | 228462 | 2020-06-11 | Ripley | Indiana | 18137 | 109 | 6 |
225360 | 225360 | 2020-06-10 | Ripley | Indiana | 18137 | 109 | 6 |
222265 | 222265 | 2020-06-09 | Ripley | Indiana | 18137 | 110 | 6 |
219170 | 219170 | 2020-06-08 | Ripley | Indiana | 18137 | 109 | 6 |
216078 | 216078 | 2020-06-07 | Ripley | Indiana | 18137 | 108 | 6 |
212991 | 212991 | 2020-06-06 | Ripley | Indiana | 18137 | 108 | 6 |
209906 | 209906 | 2020-06-05 | Ripley | Indiana | 18137 | 108 | 6 |
206825 | 206825 | 2020-06-04 | Ripley | Indiana | 18137 | 108 | 6 |
203745 | 203745 | 2020-06-03 | Ripley | Indiana | 18137 | 108 | 6 |
200669 | 200669 | 2020-06-02 | Ripley | Indiana | 18137 | 108 | 6 |
197596 | 197596 | 2020-06-01 | Ripley | Indiana | 18137 | 109 | 6 |
194526 | 194526 | 2020-05-31 | Ripley | Indiana | 18137 | 109 | 6 |
191459 | 191459 | 2020-05-30 | Ripley | Indiana | 18137 | 108 | 6 |
188394 | 188394 | 2020-05-29 | Ripley | Indiana | 18137 | 108 | 6 |
185336 | 185336 | 2020-05-28 | Ripley | Indiana | 18137 | 110 | 6 |
182282 | 182282 | 2020-05-27 | Ripley | Indiana | 18137 | 113 | 6 |
179238 | 179238 | 2020-05-26 | Ripley | Indiana | 18137 | 112 | 6 |
176194 | 176194 | 2020-05-25 | Ripley | Indiana | 18137 | 112 | 6 |
173150 | 173150 | 2020-05-24 | Ripley | Indiana | 18137 | 112 | 6 |
170109 | 170109 | 2020-05-23 | Ripley | Indiana | 18137 | 112 | 6 |
167072 | 167072 | 2020-05-22 | Ripley | Indiana | 18137 | 110 | 6 |
164039 | 164039 | 2020-05-21 | Ripley | Indiana | 18137 | 110 | 6 |
161011 | 161011 | 2020-05-20 | Ripley | Indiana | 18137 | 107 | 6 |
157985 | 157985 | 2020-05-19 | Ripley | Indiana | 18137 | 107 | 6 |
154969 | 154969 | 2020-05-18 | Ripley | Indiana | 18137 | 108 | 6 |
151957 | 151957 | 2020-05-17 | Ripley | Indiana | 18137 | 107 | 6 |
148948 | 148948 | 2020-05-16 | Ripley | Indiana | 18137 | 107 | 6 |
145944 | 145944 | 2020-05-15 | Ripley | Indiana | 18137 | 106 | 6 |
142944 | 142944 | 2020-05-14 | Ripley | Indiana | 18137 | 105 | 6 |
139948 | 139948 | 2020-05-13 | Ripley | Indiana | 18137 | 105 | 6 |
136956 | 136956 | 2020-05-12 | Ripley | Indiana | 18137 | 104 | 6 |
133967 | 133967 | 2020-05-11 | Ripley | Indiana | 18137 | 101 | 6 |
130977 | 130977 | 2020-05-10 | Ripley | Indiana | 18137 | 101 | 6 |
127986 | 127986 | 2020-05-09 | Ripley | Indiana | 18137 | 98 | 6 |
124999 | 124999 | 2020-05-08 | Ripley | Indiana | 18137 | 98 | 6 |
122019 | 122019 | 2020-05-07 | Ripley | Indiana | 18137 | 98 | 6 |
119049 | 119049 | 2020-05-06 | Ripley | Indiana | 18137 | 99 | 6 |
116089 | 116089 | 2020-05-05 | Ripley | Indiana | 18137 | 98 | 6 |
113206 | 113206 | 2020-05-04 | Ripley | Indiana | 18137 | 97 | 6 |
110331 | 110331 | 2020-05-03 | Ripley | Indiana | 18137 | 94 | 6 |
107461 | 107461 | 2020-05-02 | Ripley | Indiana | 18137 | 94 | 6 |
104596 | 104596 | 2020-05-01 | Ripley | Indiana | 18137 | 93 | 5 |
101740 | 101740 | 2020-04-30 | Ripley | Indiana | 18137 | 92 | 5 |
98889 | 98889 | 2020-04-29 | Ripley | Indiana | 18137 | 92 | 5 |
96045 | 96045 | 2020-04-28 | Ripley | Indiana | 18137 | 91 | 5 |
93213 | 93213 | 2020-04-27 | Ripley | Indiana | 18137 | 90 | 5 |
90394 | 90394 | 2020-04-26 | Ripley | Indiana | 18137 | 89 | 5 |
87578 | 87578 | 2020-04-25 | Ripley | Indiana | 18137 | 89 | 5 |
84768 | 84768 | 2020-04-24 | Ripley | Indiana | 18137 | 87 | 5 |
81968 | 81968 | 2020-04-23 | Ripley | Indiana | 18137 | 87 | 5 |
79175 | 79175 | 2020-04-22 | Ripley | Indiana | 18137 | 86 | 3 |
76391 | 76391 | 2020-04-21 | Ripley | Indiana | 18137 | 83 | 3 |
73614 | 73614 | 2020-04-20 | Ripley | Indiana | 18137 | 82 | 3 |
70843 | 70843 | 2020-04-19 | Ripley | Indiana | 18137 | 82 | 3 |
68081 | 68081 | 2020-04-18 | Ripley | Indiana | 18137 | 80 | 3 |
65332 | 65332 | 2020-04-17 | Ripley | Indiana | 18137 | 77 | 3 |
62598 | 62598 | 2020-04-16 | Ripley | Indiana | 18137 | 89 | 3 |
59877 | 59877 | 2020-04-15 | Ripley | Indiana | 18137 | 88 | 3 |
57169 | 57169 | 2020-04-14 | Ripley | Indiana | 18137 | 89 | 3 |
54476 | 54476 | 2020-04-13 | Ripley | Indiana | 18137 | 86 | 3 |
51795 | 51795 | 2020-04-12 | Ripley | Indiana | 18137 | 84 | 3 |
49131 | 49131 | 2020-04-11 | Ripley | Indiana | 18137 | 81 | 3 |
46497 | 46497 | 2020-04-10 | Ripley | Indiana | 18137 | 79 | 3 |
43892 | 43892 | 2020-04-09 | Ripley | Indiana | 18137 | 77 | 3 |
41316 | 41316 | 2020-04-08 | Ripley | Indiana | 18137 | 76 | 3 |
38770 | 38770 | 2020-04-07 | Ripley | Indiana | 18137 | 76 | 2 |
36272 | 36272 | 2020-04-06 | Ripley | Indiana | 18137 | 70 | 2 |
33818 | 33818 | 2020-04-05 | Ripley | Indiana | 18137 | 60 | 2 |
31407 | 31407 | 2020-04-04 | Ripley | Indiana | 18137 | 51 | 2 |
29040 | 29040 | 2020-04-03 | Ripley | Indiana | 18137 | 47 | 1 |
26729 | 26729 | 2020-04-02 | Ripley | Indiana | 18137 | 39 | 1 |
24490 | 24490 | 2020-04-01 | Ripley | Indiana | 18137 | 33 | 1 |
22319 | 22319 | 2020-03-31 | Ripley | Indiana | 18137 | 31 | 1 |
20224 | 20224 | 2020-03-30 | Ripley | Indiana | 18137 | 25 | 0 |
18218 | 18218 | 2020-03-29 | Ripley | Indiana | 18137 | 19 | 0 |
16314 | 16314 | 2020-03-28 | Ripley | Indiana | 18137 | 15 | 0 |
14515 | 14515 | 2020-03-27 | Ripley | Indiana | 18137 | 14 | 0 |
12829 | 12829 | 2020-03-26 | Ripley | Indiana | 18137 | 11 | 0 |
11269 | 11269 | 2020-03-25 | Ripley | Indiana | 18137 | 7 | 0 |
9874 | 9874 | 2020-03-24 | Ripley | Indiana | 18137 | 6 | 0 |
8601 | 8601 | 2020-03-23 | Ripley | Indiana | 18137 | 1 | 0 |
7443 | 7443 | 2020-03-22 | Ripley | Indiana | 18137 | 1 | 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);