ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,478 rows where county = "Scott" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
county 1
- Scott · 818 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
237195 | 237195 | 2020-06-14 | Scott | Arkansas | 5127 | 3 | 0 |
237780 | 237780 | 2020-06-14 | Scott | Indiana | 18143 | 145 | 3 |
237883 | 237883 | 2020-06-14 | Scott | Iowa | 19163 | 406 | 10 |
237975 | 237975 | 2020-06-14 | Scott | Kansas | 20171 | 15 | 0 |
238095 | 238095 | 2020-06-14 | Scott | Kentucky | 21209 | 54 | 0 |
238383 | 238383 | 2020-06-14 | Scott | Minnesota | 27139 | 528 | 4 |
238463 | 238463 | 2020-06-14 | Scott | Mississippi | 28123 | 688 | 12 |
238576 | 238576 | 2020-06-14 | Scott | Missouri | 29201 | 139 | 10 |
239516 | 239516 | 2020-06-14 | Scott | Tennessee | 47151 | 14 | 0 |
239928 | 239928 | 2020-06-14 | Scott | Virginia | 51169 | 7 | 2 |
234088 | 234088 | 2020-06-13 | Scott | Arkansas | 5127 | 2 | 0 |
234673 | 234673 | 2020-06-13 | Scott | Indiana | 18143 | 144 | 3 |
234776 | 234776 | 2020-06-13 | Scott | Iowa | 19163 | 407 | 10 |
234868 | 234868 | 2020-06-13 | Scott | Kansas | 20171 | 15 | 0 |
234988 | 234988 | 2020-06-13 | Scott | Kentucky | 21209 | 54 | 0 |
235276 | 235276 | 2020-06-13 | Scott | Minnesota | 27139 | 526 | 4 |
235356 | 235356 | 2020-06-13 | Scott | Mississippi | 28123 | 688 | 12 |
235469 | 235469 | 2020-06-13 | Scott | Missouri | 29201 | 139 | 10 |
236408 | 236408 | 2020-06-13 | Scott | Tennessee | 47151 | 14 | 0 |
236820 | 236820 | 2020-06-13 | Scott | Virginia | 51169 | 7 | 2 |
230982 | 230982 | 2020-06-12 | Scott | Arkansas | 5127 | 2 | 0 |
231567 | 231567 | 2020-06-12 | Scott | Indiana | 18143 | 143 | 3 |
231670 | 231670 | 2020-06-12 | Scott | Iowa | 19163 | 404 | 10 |
231762 | 231762 | 2020-06-12 | Scott | Kansas | 20171 | 15 | 0 |
231883 | 231883 | 2020-06-12 | Scott | Kentucky | 21209 | 54 | 0 |
232170 | 232170 | 2020-06-12 | Scott | Minnesota | 27139 | 525 | 4 |
232250 | 232250 | 2020-06-12 | Scott | Mississippi | 28123 | 685 | 12 |
232363 | 232363 | 2020-06-12 | Scott | Missouri | 29201 | 134 | 10 |
233302 | 233302 | 2020-06-12 | Scott | Tennessee | 47151 | 14 | 0 |
233713 | 233713 | 2020-06-12 | Scott | Virginia | 51169 | 7 | 2 |
227879 | 227879 | 2020-06-11 | Scott | Arkansas | 5127 | 2 | 0 |
228464 | 228464 | 2020-06-11 | Scott | Indiana | 18143 | 141 | 3 |
228567 | 228567 | 2020-06-11 | Scott | Iowa | 19163 | 400 | 10 |
228659 | 228659 | 2020-06-11 | Scott | Kansas | 20171 | 15 | 0 |
228779 | 228779 | 2020-06-11 | Scott | Kentucky | 21209 | 54 | 0 |
229066 | 229066 | 2020-06-11 | Scott | Minnesota | 27139 | 517 | 4 |
229146 | 229146 | 2020-06-11 | Scott | Mississippi | 28123 | 682 | 12 |
229259 | 229259 | 2020-06-11 | Scott | Missouri | 29201 | 132 | 10 |
230197 | 230197 | 2020-06-11 | Scott | Tennessee | 47151 | 14 | 0 |
230608 | 230608 | 2020-06-11 | Scott | Virginia | 51169 | 7 | 2 |
224777 | 224777 | 2020-06-10 | Scott | Arkansas | 5127 | 2 | 0 |
225362 | 225362 | 2020-06-10 | Scott | Indiana | 18143 | 133 | 3 |
225465 | 225465 | 2020-06-10 | Scott | Iowa | 19163 | 398 | 10 |
225557 | 225557 | 2020-06-10 | Scott | Kansas | 20171 | 15 | 0 |
225677 | 225677 | 2020-06-10 | Scott | Kentucky | 21209 | 54 | 0 |
225964 | 225964 | 2020-06-10 | Scott | Minnesota | 27139 | 504 | 3 |
226044 | 226044 | 2020-06-10 | Scott | Mississippi | 28123 | 682 | 12 |
226156 | 226156 | 2020-06-10 | Scott | Missouri | 29201 | 128 | 10 |
227093 | 227093 | 2020-06-10 | Scott | Tennessee | 47151 | 14 | 0 |
227504 | 227504 | 2020-06-10 | Scott | Virginia | 51169 | 7 | 2 |
221682 | 221682 | 2020-06-09 | Scott | Arkansas | 5127 | 2 | 0 |
222267 | 222267 | 2020-06-09 | Scott | Indiana | 18143 | 132 | 3 |
222370 | 222370 | 2020-06-09 | Scott | Iowa | 19163 | 393 | 10 |
222462 | 222462 | 2020-06-09 | Scott | Kansas | 20171 | 15 | 0 |
222581 | 222581 | 2020-06-09 | Scott | Kentucky | 21209 | 54 | 0 |
222866 | 222866 | 2020-06-09 | Scott | Minnesota | 27139 | 496 | 2 |
222946 | 222946 | 2020-06-09 | Scott | Mississippi | 28123 | 677 | 12 |
223057 | 223057 | 2020-06-09 | Scott | Missouri | 29201 | 127 | 10 |
223993 | 223993 | 2020-06-09 | Scott | Tennessee | 47151 | 13 | 0 |
224404 | 224404 | 2020-06-09 | Scott | Virginia | 51169 | 7 | 2 |
218587 | 218587 | 2020-06-08 | Scott | Arkansas | 5127 | 2 | 0 |
219172 | 219172 | 2020-06-08 | Scott | Indiana | 18143 | 130 | 3 |
219275 | 219275 | 2020-06-08 | Scott | Iowa | 19163 | 393 | 10 |
219367 | 219367 | 2020-06-08 | Scott | Kansas | 20171 | 15 | 0 |
219486 | 219486 | 2020-06-08 | Scott | Kentucky | 21209 | 54 | 0 |
219771 | 219771 | 2020-06-08 | Scott | Minnesota | 27139 | 493 | 2 |
219851 | 219851 | 2020-06-08 | Scott | Mississippi | 28123 | 673 | 12 |
219962 | 219962 | 2020-06-08 | Scott | Missouri | 29201 | 123 | 10 |
220898 | 220898 | 2020-06-08 | Scott | Tennessee | 47151 | 13 | 0 |
221308 | 221308 | 2020-06-08 | Scott | Virginia | 51169 | 7 | 2 |
215496 | 215496 | 2020-06-07 | Scott | Arkansas | 5127 | 1 | 0 |
216080 | 216080 | 2020-06-07 | Scott | Indiana | 18143 | 129 | 3 |
216183 | 216183 | 2020-06-07 | Scott | Iowa | 19163 | 388 | 10 |
216275 | 216275 | 2020-06-07 | Scott | Kansas | 20171 | 14 | 0 |
216394 | 216394 | 2020-06-07 | Scott | Kentucky | 21209 | 37 | 0 |
216679 | 216679 | 2020-06-07 | Scott | Minnesota | 27139 | 486 | 2 |
216759 | 216759 | 2020-06-07 | Scott | Mississippi | 28123 | 671 | 12 |
216870 | 216870 | 2020-06-07 | Scott | Missouri | 29201 | 121 | 9 |
217806 | 217806 | 2020-06-07 | Scott | Tennessee | 47151 | 14 | 0 |
218216 | 218216 | 2020-06-07 | Scott | Virginia | 51169 | 7 | 2 |
212409 | 212409 | 2020-06-06 | Scott | Arkansas | 5127 | 1 | 0 |
212993 | 212993 | 2020-06-06 | Scott | Indiana | 18143 | 129 | 3 |
213096 | 213096 | 2020-06-06 | Scott | Iowa | 19163 | 386 | 10 |
213188 | 213188 | 2020-06-06 | Scott | Kansas | 20171 | 14 | 0 |
213307 | 213307 | 2020-06-06 | Scott | Kentucky | 21209 | 37 | 0 |
213591 | 213591 | 2020-06-06 | Scott | Minnesota | 27139 | 483 | 2 |
213671 | 213671 | 2020-06-06 | Scott | Mississippi | 28123 | 670 | 12 |
213781 | 213781 | 2020-06-06 | Scott | Missouri | 29201 | 121 | 9 |
214716 | 214716 | 2020-06-06 | Scott | Tennessee | 47151 | 13 | 0 |
215126 | 215126 | 2020-06-06 | Scott | Virginia | 51169 | 7 | 2 |
209324 | 209324 | 2020-06-05 | Scott | Arkansas | 5127 | 1 | 0 |
209908 | 209908 | 2020-06-05 | Scott | Indiana | 18143 | 127 | 3 |
210011 | 210011 | 2020-06-05 | Scott | Iowa | 19163 | 385 | 10 |
210103 | 210103 | 2020-06-05 | Scott | Kansas | 20171 | 14 | 0 |
210222 | 210222 | 2020-06-05 | Scott | Kentucky | 21209 | 37 | 0 |
210507 | 210507 | 2020-06-05 | Scott | Minnesota | 27139 | 471 | 2 |
210587 | 210587 | 2020-06-05 | Scott | Mississippi | 28123 | 663 | 12 |
210697 | 210697 | 2020-06-05 | Scott | Missouri | 29201 | 119 | 9 |
211629 | 211629 | 2020-06-05 | Scott | Tennessee | 47151 | 13 | 0 |
212039 | 212039 | 2020-06-05 | Scott | Virginia | 51169 | 7 | 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);