ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Clay" and state = "Indiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
18168 | 18168 | 2020-03-29 | Clay | Indiana | 18021 | 1 | 0 |
20174 | 20174 | 2020-03-30 | Clay | Indiana | 18021 | 1 | 0 |
22268 | 22268 | 2020-03-31 | Clay | Indiana | 18021 | 1 | 0 |
24438 | 24438 | 2020-04-01 | Clay | Indiana | 18021 | 1 | 0 |
26677 | 26677 | 2020-04-02 | Clay | Indiana | 18021 | 1 | 0 |
28987 | 28987 | 2020-04-03 | Clay | Indiana | 18021 | 2 | 0 |
31353 | 31353 | 2020-04-04 | Clay | Indiana | 18021 | 3 | 0 |
33763 | 33763 | 2020-04-05 | Clay | Indiana | 18021 | 4 | 0 |
36216 | 36216 | 2020-04-06 | Clay | Indiana | 18021 | 5 | 0 |
38714 | 38714 | 2020-04-07 | Clay | Indiana | 18021 | 7 | 0 |
41260 | 41260 | 2020-04-08 | Clay | Indiana | 18021 | 11 | 0 |
46440 | 46440 | 2020-04-10 | Clay | Indiana | 18021 | 11 | 0 |
49074 | 49074 | 2020-04-11 | Clay | Indiana | 18021 | 11 | 0 |
51737 | 51737 | 2020-04-12 | Clay | Indiana | 18021 | 11 | 0 |
43836 | 43836 | 2020-04-09 | Clay | Indiana | 18021 | 12 | 0 |
54418 | 54418 | 2020-04-13 | Clay | Indiana | 18021 | 12 | 0 |
57111 | 57111 | 2020-04-14 | Clay | Indiana | 18021 | 12 | 0 |
59819 | 59819 | 2020-04-15 | Clay | Indiana | 18021 | 13 | 0 |
62540 | 62540 | 2020-04-16 | Clay | Indiana | 18021 | 14 | 0 |
65274 | 65274 | 2020-04-17 | Clay | Indiana | 18021 | 14 | 0 |
68023 | 68023 | 2020-04-18 | Clay | Indiana | 18021 | 15 | 0 |
70785 | 70785 | 2020-04-19 | Clay | Indiana | 18021 | 18 | 0 |
76333 | 76333 | 2020-04-21 | Clay | Indiana | 18021 | 19 | 0 |
79117 | 79117 | 2020-04-22 | Clay | Indiana | 18021 | 19 | 1 |
81910 | 81910 | 2020-04-23 | Clay | Indiana | 18021 | 19 | 1 |
84710 | 84710 | 2020-04-24 | Clay | Indiana | 18021 | 19 | 1 |
87520 | 87520 | 2020-04-25 | Clay | Indiana | 18021 | 19 | 1 |
90336 | 90336 | 2020-04-26 | Clay | Indiana | 18021 | 19 | 1 |
93155 | 93155 | 2020-04-27 | Clay | Indiana | 18021 | 19 | 1 |
95987 | 95987 | 2020-04-28 | Clay | Indiana | 18021 | 19 | 1 |
98831 | 98831 | 2020-04-29 | Clay | Indiana | 18021 | 19 | 1 |
73556 | 73556 | 2020-04-20 | Clay | Indiana | 18021 | 20 | 0 |
101682 | 101682 | 2020-04-30 | Clay | Indiana | 18021 | 20 | 1 |
104538 | 104538 | 2020-05-01 | Clay | Indiana | 18021 | 20 | 1 |
107403 | 107403 | 2020-05-02 | Clay | Indiana | 18021 | 22 | 1 |
110273 | 110273 | 2020-05-03 | Clay | Indiana | 18021 | 22 | 1 |
113148 | 113148 | 2020-05-04 | Clay | Indiana | 18021 | 22 | 1 |
116031 | 116031 | 2020-05-05 | Clay | Indiana | 18021 | 22 | 1 |
118991 | 118991 | 2020-05-06 | Clay | Indiana | 18021 | 23 | 1 |
121961 | 121961 | 2020-05-07 | Clay | Indiana | 18021 | 23 | 1 |
124941 | 124941 | 2020-05-08 | Clay | Indiana | 18021 | 24 | 1 |
127928 | 127928 | 2020-05-09 | Clay | Indiana | 18021 | 24 | 1 |
130919 | 130919 | 2020-05-10 | Clay | Indiana | 18021 | 24 | 1 |
133909 | 133909 | 2020-05-11 | Clay | Indiana | 18021 | 24 | 1 |
136898 | 136898 | 2020-05-12 | Clay | Indiana | 18021 | 24 | 1 |
139890 | 139890 | 2020-05-13 | Clay | Indiana | 18021 | 24 | 1 |
142886 | 142886 | 2020-05-14 | Clay | Indiana | 18021 | 26 | 1 |
145886 | 145886 | 2020-05-15 | Clay | Indiana | 18021 | 28 | 1 |
148890 | 148890 | 2020-05-16 | Clay | Indiana | 18021 | 29 | 1 |
151899 | 151899 | 2020-05-17 | Clay | Indiana | 18021 | 30 | 1 |
154911 | 154911 | 2020-05-18 | Clay | Indiana | 18021 | 31 | 1 |
157927 | 157927 | 2020-05-19 | Clay | Indiana | 18021 | 32 | 1 |
160953 | 160953 | 2020-05-20 | Clay | Indiana | 18021 | 33 | 1 |
163981 | 163981 | 2020-05-21 | Clay | Indiana | 18021 | 36 | 1 |
167014 | 167014 | 2020-05-22 | Clay | Indiana | 18021 | 36 | 1 |
170051 | 170051 | 2020-05-23 | Clay | Indiana | 18021 | 38 | 1 |
173092 | 173092 | 2020-05-24 | Clay | Indiana | 18021 | 39 | 1 |
176136 | 176136 | 2020-05-25 | Clay | Indiana | 18021 | 39 | 1 |
179180 | 179180 | 2020-05-26 | Clay | Indiana | 18021 | 39 | 1 |
182224 | 182224 | 2020-05-27 | Clay | Indiana | 18021 | 41 | 1 |
185278 | 185278 | 2020-05-28 | Clay | Indiana | 18021 | 46 | 1 |
188336 | 188336 | 2020-05-29 | Clay | Indiana | 18021 | 47 | 1 |
191401 | 191401 | 2020-05-30 | Clay | Indiana | 18021 | 51 | 1 |
194468 | 194468 | 2020-05-31 | Clay | Indiana | 18021 | 51 | 1 |
197538 | 197538 | 2020-06-01 | Clay | Indiana | 18021 | 51 | 1 |
200611 | 200611 | 2020-06-02 | Clay | Indiana | 18021 | 51 | 2 |
203687 | 203687 | 2020-06-03 | Clay | Indiana | 18021 | 52 | 2 |
206767 | 206767 | 2020-06-04 | Clay | Indiana | 18021 | 53 | 3 |
209848 | 209848 | 2020-06-05 | Clay | Indiana | 18021 | 53 | 3 |
212933 | 212933 | 2020-06-06 | Clay | Indiana | 18021 | 53 | 3 |
216020 | 216020 | 2020-06-07 | Clay | Indiana | 18021 | 53 | 3 |
219112 | 219112 | 2020-06-08 | Clay | Indiana | 18021 | 53 | 3 |
222207 | 222207 | 2020-06-09 | Clay | Indiana | 18021 | 55 | 3 |
225302 | 225302 | 2020-06-10 | Clay | Indiana | 18021 | 56 | 3 |
228404 | 228404 | 2020-06-11 | Clay | Indiana | 18021 | 56 | 3 |
231507 | 231507 | 2020-06-12 | Clay | Indiana | 18021 | 56 | 3 |
234613 | 234613 | 2020-06-13 | Clay | Indiana | 18021 | 56 | 3 |
237720 | 237720 | 2020-06-14 | Clay | Indiana | 18021 | 56 | 3 |
240828 | 240828 | 2020-06-15 | Clay | Indiana | 18021 | 56 | 3 |
243939 | 243939 | 2020-06-16 | Clay | Indiana | 18021 | 56 | 3 |
247052 | 247052 | 2020-06-17 | Clay | Indiana | 18021 | 56 | 3 |
250164 | 250164 | 2020-06-18 | Clay | Indiana | 18021 | 56 | 3 |
253279 | 253279 | 2020-06-19 | Clay | Indiana | 18021 | 56 | 3 |
256399 | 256399 | 2020-06-20 | Clay | Indiana | 18021 | 56 | 3 |
259525 | 259525 | 2020-06-21 | Clay | Indiana | 18021 | 56 | 3 |
262652 | 262652 | 2020-06-22 | Clay | Indiana | 18021 | 56 | 3 |
265780 | 265780 | 2020-06-23 | Clay | Indiana | 18021 | 56 | 4 |
268910 | 268910 | 2020-06-24 | Clay | Indiana | 18021 | 56 | 4 |
272047 | 272047 | 2020-06-25 | Clay | Indiana | 18021 | 56 | 4 |
275189 | 275189 | 2020-06-26 | Clay | Indiana | 18021 | 56 | 4 |
278337 | 278337 | 2020-06-27 | Clay | Indiana | 18021 | 59 | 4 |
281485 | 281485 | 2020-06-28 | Clay | Indiana | 18021 | 59 | 4 |
284630 | 284630 | 2020-06-29 | Clay | Indiana | 18021 | 59 | 4 |
287779 | 287779 | 2020-06-30 | Clay | Indiana | 18021 | 59 | 4 |
290929 | 290929 | 2020-07-01 | Clay | Indiana | 18021 | 59 | 4 |
294083 | 294083 | 2020-07-02 | Clay | Indiana | 18021 | 59 | 4 |
297241 | 297241 | 2020-07-03 | Clay | Indiana | 18021 | 60 | 4 |
300403 | 300403 | 2020-07-04 | Clay | Indiana | 18021 | 60 | 4 |
303567 | 303567 | 2020-07-05 | Clay | Indiana | 18021 | 60 | 4 |
306732 | 306732 | 2020-07-06 | Clay | Indiana | 18021 | 60 | 4 |
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);