ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Jefferson" and fips = 18077 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22294 | 22294 | 2020-03-31 | Jefferson | Indiana | 18077 | 1 | 0 |
24465 | 24465 | 2020-04-01 | Jefferson | Indiana | 18077 | 1 | 0 |
26704 | 26704 | 2020-04-02 | Jefferson | Indiana | 18077 | 3 | 0 |
29014 | 29014 | 2020-04-03 | Jefferson | Indiana | 18077 | 5 | 0 |
31380 | 31380 | 2020-04-04 | Jefferson | Indiana | 18077 | 5 | 0 |
33791 | 33791 | 2020-04-05 | Jefferson | Indiana | 18077 | 5 | 0 |
36244 | 36244 | 2020-04-06 | Jefferson | Indiana | 18077 | 6 | 0 |
38742 | 38742 | 2020-04-07 | Jefferson | Indiana | 18077 | 6 | 0 |
41288 | 41288 | 2020-04-08 | Jefferson | Indiana | 18077 | 7 | 0 |
43864 | 43864 | 2020-04-09 | Jefferson | Indiana | 18077 | 10 | 0 |
46468 | 46468 | 2020-04-10 | Jefferson | Indiana | 18077 | 10 | 0 |
49102 | 49102 | 2020-04-11 | Jefferson | Indiana | 18077 | 13 | 0 |
51765 | 51765 | 2020-04-12 | Jefferson | Indiana | 18077 | 12 | 0 |
54446 | 54446 | 2020-04-13 | Jefferson | Indiana | 18077 | 12 | 0 |
57139 | 57139 | 2020-04-14 | Jefferson | Indiana | 18077 | 16 | 0 |
59847 | 59847 | 2020-04-15 | Jefferson | Indiana | 18077 | 15 | 0 |
62568 | 62568 | 2020-04-16 | Jefferson | Indiana | 18077 | 15 | 0 |
65302 | 65302 | 2020-04-17 | Jefferson | Indiana | 18077 | 18 | 0 |
68051 | 68051 | 2020-04-18 | Jefferson | Indiana | 18077 | 18 | 0 |
70813 | 70813 | 2020-04-19 | Jefferson | Indiana | 18077 | 18 | 0 |
73584 | 73584 | 2020-04-20 | Jefferson | Indiana | 18077 | 20 | 0 |
76361 | 76361 | 2020-04-21 | Jefferson | Indiana | 18077 | 21 | 0 |
79145 | 79145 | 2020-04-22 | Jefferson | Indiana | 18077 | 21 | 0 |
81938 | 81938 | 2020-04-23 | Jefferson | Indiana | 18077 | 23 | 0 |
84738 | 84738 | 2020-04-24 | Jefferson | Indiana | 18077 | 23 | 0 |
87548 | 87548 | 2020-04-25 | Jefferson | Indiana | 18077 | 23 | 0 |
90364 | 90364 | 2020-04-26 | Jefferson | Indiana | 18077 | 23 | 0 |
93183 | 93183 | 2020-04-27 | Jefferson | Indiana | 18077 | 27 | 0 |
96015 | 96015 | 2020-04-28 | Jefferson | Indiana | 18077 | 27 | 0 |
98859 | 98859 | 2020-04-29 | Jefferson | Indiana | 18077 | 27 | 0 |
101710 | 101710 | 2020-04-30 | Jefferson | Indiana | 18077 | 27 | 0 |
104566 | 104566 | 2020-05-01 | Jefferson | Indiana | 18077 | 30 | 0 |
107431 | 107431 | 2020-05-02 | Jefferson | Indiana | 18077 | 31 | 0 |
110301 | 110301 | 2020-05-03 | Jefferson | Indiana | 18077 | 31 | 0 |
113176 | 113176 | 2020-05-04 | Jefferson | Indiana | 18077 | 31 | 0 |
116059 | 116059 | 2020-05-05 | Jefferson | Indiana | 18077 | 31 | 0 |
119019 | 119019 | 2020-05-06 | Jefferson | Indiana | 18077 | 31 | 0 |
121989 | 121989 | 2020-05-07 | Jefferson | Indiana | 18077 | 33 | 0 |
124969 | 124969 | 2020-05-08 | Jefferson | Indiana | 18077 | 35 | 0 |
127956 | 127956 | 2020-05-09 | Jefferson | Indiana | 18077 | 35 | 0 |
130947 | 130947 | 2020-05-10 | Jefferson | Indiana | 18077 | 36 | 0 |
133937 | 133937 | 2020-05-11 | Jefferson | Indiana | 18077 | 36 | 0 |
136926 | 136926 | 2020-05-12 | Jefferson | Indiana | 18077 | 36 | 0 |
139918 | 139918 | 2020-05-13 | Jefferson | Indiana | 18077 | 36 | 0 |
142914 | 142914 | 2020-05-14 | Jefferson | Indiana | 18077 | 36 | 1 |
145914 | 145914 | 2020-05-15 | Jefferson | Indiana | 18077 | 36 | 1 |
148918 | 148918 | 2020-05-16 | Jefferson | Indiana | 18077 | 35 | 1 |
151927 | 151927 | 2020-05-17 | Jefferson | Indiana | 18077 | 36 | 1 |
154939 | 154939 | 2020-05-18 | Jefferson | Indiana | 18077 | 40 | 1 |
157955 | 157955 | 2020-05-19 | Jefferson | Indiana | 18077 | 41 | 1 |
160981 | 160981 | 2020-05-20 | Jefferson | Indiana | 18077 | 42 | 1 |
164009 | 164009 | 2020-05-21 | Jefferson | Indiana | 18077 | 42 | 1 |
167042 | 167042 | 2020-05-22 | Jefferson | Indiana | 18077 | 42 | 1 |
170079 | 170079 | 2020-05-23 | Jefferson | Indiana | 18077 | 42 | 1 |
173120 | 173120 | 2020-05-24 | Jefferson | Indiana | 18077 | 42 | 1 |
176164 | 176164 | 2020-05-25 | Jefferson | Indiana | 18077 | 42 | 1 |
179208 | 179208 | 2020-05-26 | Jefferson | Indiana | 18077 | 42 | 1 |
182252 | 182252 | 2020-05-27 | Jefferson | Indiana | 18077 | 43 | 1 |
185306 | 185306 | 2020-05-28 | Jefferson | Indiana | 18077 | 44 | 1 |
188364 | 188364 | 2020-05-29 | Jefferson | Indiana | 18077 | 44 | 1 |
191429 | 191429 | 2020-05-30 | Jefferson | Indiana | 18077 | 46 | 1 |
194496 | 194496 | 2020-05-31 | Jefferson | Indiana | 18077 | 46 | 1 |
197566 | 197566 | 2020-06-01 | Jefferson | Indiana | 18077 | 46 | 1 |
200639 | 200639 | 2020-06-02 | Jefferson | Indiana | 18077 | 47 | 1 |
203715 | 203715 | 2020-06-03 | Jefferson | Indiana | 18077 | 48 | 1 |
206795 | 206795 | 2020-06-04 | Jefferson | Indiana | 18077 | 50 | 1 |
209876 | 209876 | 2020-06-05 | Jefferson | Indiana | 18077 | 50 | 1 |
212961 | 212961 | 2020-06-06 | Jefferson | Indiana | 18077 | 50 | 1 |
216048 | 216048 | 2020-06-07 | Jefferson | Indiana | 18077 | 50 | 1 |
219140 | 219140 | 2020-06-08 | Jefferson | Indiana | 18077 | 52 | 1 |
222235 | 222235 | 2020-06-09 | Jefferson | Indiana | 18077 | 53 | 1 |
225330 | 225330 | 2020-06-10 | Jefferson | Indiana | 18077 | 52 | 1 |
228432 | 228432 | 2020-06-11 | Jefferson | Indiana | 18077 | 52 | 1 |
231535 | 231535 | 2020-06-12 | Jefferson | Indiana | 18077 | 53 | 1 |
234641 | 234641 | 2020-06-13 | Jefferson | Indiana | 18077 | 54 | 1 |
237748 | 237748 | 2020-06-14 | Jefferson | Indiana | 18077 | 54 | 1 |
240856 | 240856 | 2020-06-15 | Jefferson | Indiana | 18077 | 54 | 1 |
243967 | 243967 | 2020-06-16 | Jefferson | Indiana | 18077 | 54 | 1 |
247080 | 247080 | 2020-06-17 | Jefferson | Indiana | 18077 | 55 | 1 |
250192 | 250192 | 2020-06-18 | Jefferson | Indiana | 18077 | 56 | 1 |
253307 | 253307 | 2020-06-19 | Jefferson | Indiana | 18077 | 56 | 1 |
256427 | 256427 | 2020-06-20 | Jefferson | Indiana | 18077 | 57 | 1 |
259553 | 259553 | 2020-06-21 | Jefferson | Indiana | 18077 | 57 | 1 |
262680 | 262680 | 2020-06-22 | Jefferson | Indiana | 18077 | 57 | 1 |
265808 | 265808 | 2020-06-23 | Jefferson | Indiana | 18077 | 59 | 1 |
268938 | 268938 | 2020-06-24 | Jefferson | Indiana | 18077 | 59 | 1 |
272075 | 272075 | 2020-06-25 | Jefferson | Indiana | 18077 | 59 | 1 |
275217 | 275217 | 2020-06-26 | Jefferson | Indiana | 18077 | 59 | 1 |
278365 | 278365 | 2020-06-27 | Jefferson | Indiana | 18077 | 63 | 1 |
281513 | 281513 | 2020-06-28 | Jefferson | Indiana | 18077 | 64 | 1 |
284658 | 284658 | 2020-06-29 | Jefferson | Indiana | 18077 | 64 | 1 |
287807 | 287807 | 2020-06-30 | Jefferson | Indiana | 18077 | 65 | 1 |
290957 | 290957 | 2020-07-01 | Jefferson | Indiana | 18077 | 66 | 1 |
294111 | 294111 | 2020-07-02 | Jefferson | Indiana | 18077 | 67 | 1 |
297269 | 297269 | 2020-07-03 | Jefferson | Indiana | 18077 | 71 | 1 |
300431 | 300431 | 2020-07-04 | Jefferson | Indiana | 18077 | 73 | 2 |
303595 | 303595 | 2020-07-05 | Jefferson | Indiana | 18077 | 73 | 2 |
306760 | 306760 | 2020-07-06 | Jefferson | Indiana | 18077 | 73 | 2 |
309928 | 309928 | 2020-07-07 | Jefferson | Indiana | 18077 | 73 | 2 |
313098 | 313098 | 2020-07-08 | Jefferson | Indiana | 18077 | 77 | 2 |
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);