ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and fips = 18143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386708 | 386708 | 2020-07-31 | Scott | Indiana | 18143 | 247 | 11 |
383490 | 383490 | 2020-07-30 | Scott | Indiana | 18143 | 240 | 11 |
380273 | 380273 | 2020-07-29 | Scott | Indiana | 18143 | 237 | 11 |
377056 | 377056 | 2020-07-28 | Scott | Indiana | 18143 | 232 | 11 |
373841 | 373841 | 2020-07-27 | Scott | Indiana | 18143 | 227 | 11 |
370629 | 370629 | 2020-07-26 | Scott | Indiana | 18143 | 227 | 11 |
367419 | 367419 | 2020-07-25 | Scott | Indiana | 18143 | 222 | 11 |
364212 | 364212 | 2020-07-24 | Scott | Indiana | 18143 | 219 | 11 |
361005 | 361005 | 2020-07-23 | Scott | Indiana | 18143 | 211 | 11 |
357800 | 357800 | 2020-07-22 | Scott | Indiana | 18143 | 206 | 11 |
354598 | 354598 | 2020-07-21 | Scott | Indiana | 18143 | 204 | 10 |
351396 | 351396 | 2020-07-20 | Scott | Indiana | 18143 | 202 | 10 |
348196 | 348196 | 2020-07-19 | Scott | Indiana | 18143 | 197 | 10 |
344995 | 344995 | 2020-07-18 | Scott | Indiana | 18143 | 187 | 10 |
341795 | 341795 | 2020-07-17 | Scott | Indiana | 18143 | 185 | 10 |
338599 | 338599 | 2020-07-16 | Scott | Indiana | 18143 | 178 | 10 |
335403 | 335403 | 2020-07-15 | Scott | Indiana | 18143 | 171 | 10 |
332210 | 332210 | 2020-07-14 | Scott | Indiana | 18143 | 170 | 10 |
329023 | 329023 | 2020-07-13 | Scott | Indiana | 18143 | 169 | 10 |
325837 | 325837 | 2020-07-12 | Scott | Indiana | 18143 | 169 | 10 |
322656 | 322656 | 2020-07-11 | Scott | Indiana | 18143 | 168 | 10 |
319477 | 319477 | 2020-07-10 | Scott | Indiana | 18143 | 167 | 10 |
316304 | 316304 | 2020-07-09 | Scott | Indiana | 18143 | 166 | 9 |
313130 | 313130 | 2020-07-08 | Scott | Indiana | 18143 | 166 | 9 |
309960 | 309960 | 2020-07-07 | Scott | Indiana | 18143 | 166 | 9 |
306792 | 306792 | 2020-07-06 | Scott | Indiana | 18143 | 166 | 8 |
303627 | 303627 | 2020-07-05 | Scott | Indiana | 18143 | 164 | 8 |
300463 | 300463 | 2020-07-04 | Scott | Indiana | 18143 | 164 | 8 |
297301 | 297301 | 2020-07-03 | Scott | Indiana | 18143 | 164 | 8 |
294143 | 294143 | 2020-07-02 | Scott | Indiana | 18143 | 159 | 8 |
290989 | 290989 | 2020-07-01 | Scott | Indiana | 18143 | 158 | 8 |
287839 | 287839 | 2020-06-30 | Scott | Indiana | 18143 | 158 | 8 |
284690 | 284690 | 2020-06-29 | Scott | Indiana | 18143 | 157 | 7 |
281545 | 281545 | 2020-06-28 | Scott | Indiana | 18143 | 157 | 7 |
278397 | 278397 | 2020-06-27 | Scott | Indiana | 18143 | 157 | 7 |
275249 | 275249 | 2020-06-26 | Scott | Indiana | 18143 | 156 | 7 |
272107 | 272107 | 2020-06-25 | Scott | Indiana | 18143 | 157 | 7 |
268970 | 268970 | 2020-06-24 | Scott | Indiana | 18143 | 154 | 7 |
265840 | 265840 | 2020-06-23 | Scott | Indiana | 18143 | 153 | 7 |
262712 | 262712 | 2020-06-22 | Scott | Indiana | 18143 | 151 | 7 |
259585 | 259585 | 2020-06-21 | Scott | Indiana | 18143 | 151 | 7 |
256459 | 256459 | 2020-06-20 | Scott | Indiana | 18143 | 151 | 7 |
253339 | 253339 | 2020-06-19 | Scott | Indiana | 18143 | 149 | 7 |
250224 | 250224 | 2020-06-18 | Scott | Indiana | 18143 | 150 | 7 |
247112 | 247112 | 2020-06-17 | Scott | Indiana | 18143 | 147 | 5 |
243999 | 243999 | 2020-06-16 | Scott | Indiana | 18143 | 147 | 3 |
240888 | 240888 | 2020-06-15 | Scott | Indiana | 18143 | 145 | 3 |
237780 | 237780 | 2020-06-14 | Scott | Indiana | 18143 | 145 | 3 |
234673 | 234673 | 2020-06-13 | Scott | Indiana | 18143 | 144 | 3 |
231567 | 231567 | 2020-06-12 | Scott | Indiana | 18143 | 143 | 3 |
228464 | 228464 | 2020-06-11 | Scott | Indiana | 18143 | 141 | 3 |
225362 | 225362 | 2020-06-10 | Scott | Indiana | 18143 | 133 | 3 |
222267 | 222267 | 2020-06-09 | Scott | Indiana | 18143 | 132 | 3 |
219172 | 219172 | 2020-06-08 | Scott | Indiana | 18143 | 130 | 3 |
216080 | 216080 | 2020-06-07 | Scott | Indiana | 18143 | 129 | 3 |
212993 | 212993 | 2020-06-06 | Scott | Indiana | 18143 | 129 | 3 |
209908 | 209908 | 2020-06-05 | Scott | Indiana | 18143 | 127 | 3 |
206827 | 206827 | 2020-06-04 | Scott | Indiana | 18143 | 127 | 3 |
203747 | 203747 | 2020-06-03 | Scott | Indiana | 18143 | 123 | 3 |
200671 | 200671 | 2020-06-02 | Scott | Indiana | 18143 | 122 | 3 |
197598 | 197598 | 2020-06-01 | Scott | Indiana | 18143 | 121 | 3 |
194528 | 194528 | 2020-05-31 | Scott | Indiana | 18143 | 121 | 3 |
191461 | 191461 | 2020-05-30 | Scott | Indiana | 18143 | 120 | 3 |
188396 | 188396 | 2020-05-29 | Scott | Indiana | 18143 | 120 | 3 |
185338 | 185338 | 2020-05-28 | Scott | Indiana | 18143 | 121 | 3 |
182284 | 182284 | 2020-05-27 | Scott | Indiana | 18143 | 119 | 3 |
179240 | 179240 | 2020-05-26 | Scott | Indiana | 18143 | 119 | 3 |
176196 | 176196 | 2020-05-25 | Scott | Indiana | 18143 | 119 | 3 |
173152 | 173152 | 2020-05-24 | Scott | Indiana | 18143 | 117 | 3 |
170111 | 170111 | 2020-05-23 | Scott | Indiana | 18143 | 116 | 3 |
167074 | 167074 | 2020-05-22 | Scott | Indiana | 18143 | 107 | 3 |
164041 | 164041 | 2020-05-21 | Scott | Indiana | 18143 | 106 | 3 |
161013 | 161013 | 2020-05-20 | Scott | Indiana | 18143 | 102 | 3 |
157987 | 157987 | 2020-05-19 | Scott | Indiana | 18143 | 99 | 2 |
154971 | 154971 | 2020-05-18 | Scott | Indiana | 18143 | 98 | 2 |
151959 | 151959 | 2020-05-17 | Scott | Indiana | 18143 | 97 | 2 |
148950 | 148950 | 2020-05-16 | Scott | Indiana | 18143 | 94 | 2 |
145946 | 145946 | 2020-05-15 | Scott | Indiana | 18143 | 91 | 2 |
142946 | 142946 | 2020-05-14 | Scott | Indiana | 18143 | 90 | 2 |
139950 | 139950 | 2020-05-13 | Scott | Indiana | 18143 | 89 | 2 |
136958 | 136958 | 2020-05-12 | Scott | Indiana | 18143 | 85 | 2 |
133969 | 133969 | 2020-05-11 | Scott | Indiana | 18143 | 81 | 2 |
130979 | 130979 | 2020-05-10 | Scott | Indiana | 18143 | 81 | 2 |
127988 | 127988 | 2020-05-09 | Scott | Indiana | 18143 | 79 | 2 |
125001 | 125001 | 2020-05-08 | Scott | Indiana | 18143 | 73 | 2 |
122021 | 122021 | 2020-05-07 | Scott | Indiana | 18143 | 63 | 2 |
119051 | 119051 | 2020-05-06 | Scott | Indiana | 18143 | 54 | 2 |
116091 | 116091 | 2020-05-05 | Scott | Indiana | 18143 | 54 | 2 |
113208 | 113208 | 2020-05-04 | Scott | Indiana | 18143 | 52 | 2 |
110333 | 110333 | 2020-05-03 | Scott | Indiana | 18143 | 52 | 2 |
107463 | 107463 | 2020-05-02 | Scott | Indiana | 18143 | 51 | 2 |
104598 | 104598 | 2020-05-01 | Scott | Indiana | 18143 | 47 | 2 |
101742 | 101742 | 2020-04-30 | Scott | Indiana | 18143 | 46 | 2 |
98891 | 98891 | 2020-04-29 | Scott | Indiana | 18143 | 41 | 2 |
96047 | 96047 | 2020-04-28 | Scott | Indiana | 18143 | 39 | 2 |
93215 | 93215 | 2020-04-27 | Scott | Indiana | 18143 | 38 | 2 |
90396 | 90396 | 2020-04-26 | Scott | Indiana | 18143 | 37 | 2 |
87580 | 87580 | 2020-04-25 | Scott | Indiana | 18143 | 36 | 2 |
84770 | 84770 | 2020-04-24 | Scott | Indiana | 18143 | 33 | 2 |
81970 | 81970 | 2020-04-23 | Scott | Indiana | 18143 | 28 | 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);