ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Carroll" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14468 | 14468 | 2020-03-27 | Carroll | Indiana | 18015 | 1 | 0 |
16265 | 16265 | 2020-03-28 | Carroll | Indiana | 18015 | 1 | 0 |
18166 | 18166 | 2020-03-29 | Carroll | Indiana | 18015 | 1 | 0 |
20172 | 20172 | 2020-03-30 | Carroll | Indiana | 18015 | 2 | 0 |
22265 | 22265 | 2020-03-31 | Carroll | Indiana | 18015 | 2 | 0 |
24435 | 24435 | 2020-04-01 | Carroll | Indiana | 18015 | 2 | 0 |
26674 | 26674 | 2020-04-02 | Carroll | Indiana | 18015 | 2 | 0 |
28984 | 28984 | 2020-04-03 | Carroll | Indiana | 18015 | 2 | 0 |
31350 | 31350 | 2020-04-04 | Carroll | Indiana | 18015 | 3 | 0 |
33760 | 33760 | 2020-04-05 | Carroll | Indiana | 18015 | 3 | 0 |
36213 | 36213 | 2020-04-06 | Carroll | Indiana | 18015 | 3 | 0 |
38711 | 38711 | 2020-04-07 | Carroll | Indiana | 18015 | 3 | 0 |
41257 | 41257 | 2020-04-08 | Carroll | Indiana | 18015 | 3 | 0 |
43833 | 43833 | 2020-04-09 | Carroll | Indiana | 18015 | 3 | 0 |
46437 | 46437 | 2020-04-10 | Carroll | Indiana | 18015 | 4 | 0 |
49071 | 49071 | 2020-04-11 | Carroll | Indiana | 18015 | 5 | 0 |
51734 | 51734 | 2020-04-12 | Carroll | Indiana | 18015 | 5 | 0 |
54415 | 54415 | 2020-04-13 | Carroll | Indiana | 18015 | 5 | 0 |
57108 | 57108 | 2020-04-14 | Carroll | Indiana | 18015 | 6 | 1 |
59816 | 59816 | 2020-04-15 | Carroll | Indiana | 18015 | 6 | 1 |
62537 | 62537 | 2020-04-16 | Carroll | Indiana | 18015 | 6 | 1 |
65271 | 65271 | 2020-04-17 | Carroll | Indiana | 18015 | 6 | 1 |
68020 | 68020 | 2020-04-18 | Carroll | Indiana | 18015 | 6 | 1 |
70782 | 70782 | 2020-04-19 | Carroll | Indiana | 18015 | 6 | 1 |
73553 | 73553 | 2020-04-20 | Carroll | Indiana | 18015 | 7 | 1 |
76330 | 76330 | 2020-04-21 | Carroll | Indiana | 18015 | 8 | 1 |
79114 | 79114 | 2020-04-22 | Carroll | Indiana | 18015 | 7 | 1 |
81907 | 81907 | 2020-04-23 | Carroll | Indiana | 18015 | 7 | 1 |
84707 | 84707 | 2020-04-24 | Carroll | Indiana | 18015 | 8 | 1 |
87517 | 87517 | 2020-04-25 | Carroll | Indiana | 18015 | 9 | 1 |
90333 | 90333 | 2020-04-26 | Carroll | Indiana | 18015 | 13 | 1 |
93152 | 93152 | 2020-04-27 | Carroll | Indiana | 18015 | 18 | 1 |
95984 | 95984 | 2020-04-28 | Carroll | Indiana | 18015 | 18 | 1 |
98828 | 98828 | 2020-04-29 | Carroll | Indiana | 18015 | 21 | 1 |
101679 | 101679 | 2020-04-30 | Carroll | Indiana | 18015 | 22 | 1 |
104535 | 104535 | 2020-05-01 | Carroll | Indiana | 18015 | 24 | 1 |
107400 | 107400 | 2020-05-02 | Carroll | Indiana | 18015 | 25 | 1 |
110270 | 110270 | 2020-05-03 | Carroll | Indiana | 18015 | 41 | 1 |
113145 | 113145 | 2020-05-04 | Carroll | Indiana | 18015 | 56 | 1 |
116028 | 116028 | 2020-05-05 | Carroll | Indiana | 18015 | 63 | 1 |
118988 | 118988 | 2020-05-06 | Carroll | Indiana | 18015 | 65 | 1 |
121958 | 121958 | 2020-05-07 | Carroll | Indiana | 18015 | 66 | 1 |
124938 | 124938 | 2020-05-08 | Carroll | Indiana | 18015 | 70 | 2 |
127925 | 127925 | 2020-05-09 | Carroll | Indiana | 18015 | 71 | 2 |
130916 | 130916 | 2020-05-10 | Carroll | Indiana | 18015 | 71 | 2 |
133906 | 133906 | 2020-05-11 | Carroll | Indiana | 18015 | 71 | 2 |
136895 | 136895 | 2020-05-12 | Carroll | Indiana | 18015 | 71 | 2 |
139887 | 139887 | 2020-05-13 | Carroll | Indiana | 18015 | 73 | 2 |
142883 | 142883 | 2020-05-14 | Carroll | Indiana | 18015 | 75 | 2 |
145883 | 145883 | 2020-05-15 | Carroll | Indiana | 18015 | 77 | 2 |
148887 | 148887 | 2020-05-16 | Carroll | Indiana | 18015 | 78 | 2 |
151896 | 151896 | 2020-05-17 | Carroll | Indiana | 18015 | 79 | 2 |
154908 | 154908 | 2020-05-18 | Carroll | Indiana | 18015 | 79 | 2 |
157924 | 157924 | 2020-05-19 | Carroll | Indiana | 18015 | 79 | 2 |
160950 | 160950 | 2020-05-20 | Carroll | Indiana | 18015 | 81 | 2 |
163978 | 163978 | 2020-05-21 | Carroll | Indiana | 18015 | 85 | 2 |
167011 | 167011 | 2020-05-22 | Carroll | Indiana | 18015 | 87 | 2 |
170048 | 170048 | 2020-05-23 | Carroll | Indiana | 18015 | 88 | 2 |
173089 | 173089 | 2020-05-24 | Carroll | Indiana | 18015 | 91 | 2 |
176133 | 176133 | 2020-05-25 | Carroll | Indiana | 18015 | 92 | 2 |
179177 | 179177 | 2020-05-26 | Carroll | Indiana | 18015 | 92 | 2 |
182221 | 182221 | 2020-05-27 | Carroll | Indiana | 18015 | 93 | 2 |
185275 | 185275 | 2020-05-28 | Carroll | Indiana | 18015 | 93 | 3 |
188333 | 188333 | 2020-05-29 | Carroll | Indiana | 18015 | 92 | 2 |
191398 | 191398 | 2020-05-30 | Carroll | Indiana | 18015 | 93 | 2 |
194465 | 194465 | 2020-05-31 | Carroll | Indiana | 18015 | 93 | 2 |
197535 | 197535 | 2020-06-01 | Carroll | Indiana | 18015 | 93 | 2 |
200608 | 200608 | 2020-06-02 | Carroll | Indiana | 18015 | 93 | 3 |
203684 | 203684 | 2020-06-03 | Carroll | Indiana | 18015 | 93 | 3 |
206764 | 206764 | 2020-06-04 | Carroll | Indiana | 18015 | 94 | 3 |
209845 | 209845 | 2020-06-05 | Carroll | Indiana | 18015 | 95 | 2 |
212930 | 212930 | 2020-06-06 | Carroll | Indiana | 18015 | 96 | 2 |
216017 | 216017 | 2020-06-07 | Carroll | Indiana | 18015 | 96 | 2 |
219109 | 219109 | 2020-06-08 | Carroll | Indiana | 18015 | 96 | 2 |
222204 | 222204 | 2020-06-09 | Carroll | Indiana | 18015 | 95 | 2 |
225299 | 225299 | 2020-06-10 | Carroll | Indiana | 18015 | 96 | 2 |
228401 | 228401 | 2020-06-11 | Carroll | Indiana | 18015 | 97 | 2 |
231504 | 231504 | 2020-06-12 | Carroll | Indiana | 18015 | 98 | 2 |
234610 | 234610 | 2020-06-13 | Carroll | Indiana | 18015 | 98 | 2 |
237717 | 237717 | 2020-06-14 | Carroll | Indiana | 18015 | 99 | 2 |
240825 | 240825 | 2020-06-15 | Carroll | Indiana | 18015 | 101 | 2 |
243936 | 243936 | 2020-06-16 | Carroll | Indiana | 18015 | 102 | 2 |
247049 | 247049 | 2020-06-17 | Carroll | Indiana | 18015 | 102 | 2 |
250161 | 250161 | 2020-06-18 | Carroll | Indiana | 18015 | 103 | 2 |
253276 | 253276 | 2020-06-19 | Carroll | Indiana | 18015 | 103 | 2 |
256396 | 256396 | 2020-06-20 | Carroll | Indiana | 18015 | 103 | 2 |
259522 | 259522 | 2020-06-21 | Carroll | Indiana | 18015 | 103 | 2 |
262649 | 262649 | 2020-06-22 | Carroll | Indiana | 18015 | 103 | 2 |
265777 | 265777 | 2020-06-23 | Carroll | Indiana | 18015 | 103 | 2 |
268907 | 268907 | 2020-06-24 | Carroll | Indiana | 18015 | 103 | 2 |
272044 | 272044 | 2020-06-25 | Carroll | Indiana | 18015 | 104 | 2 |
275186 | 275186 | 2020-06-26 | Carroll | Indiana | 18015 | 109 | 2 |
278334 | 278334 | 2020-06-27 | Carroll | Indiana | 18015 | 107 | 2 |
281482 | 281482 | 2020-06-28 | Carroll | Indiana | 18015 | 107 | 2 |
284627 | 284627 | 2020-06-29 | Carroll | Indiana | 18015 | 107 | 2 |
287776 | 287776 | 2020-06-30 | Carroll | Indiana | 18015 | 108 | 2 |
290926 | 290926 | 2020-07-01 | Carroll | Indiana | 18015 | 109 | 2 |
294080 | 294080 | 2020-07-02 | Carroll | Indiana | 18015 | 109 | 2 |
297238 | 297238 | 2020-07-03 | Carroll | Indiana | 18015 | 110 | 2 |
300400 | 300400 | 2020-07-04 | Carroll | Indiana | 18015 | 110 | 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);