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 · 918 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
268385 | 268385 | 2020-06-24 | Scott | Arkansas | 5127 | 8 | 0 |
268970 | 268970 | 2020-06-24 | Scott | Indiana | 18143 | 154 | 7 |
269073 | 269073 | 2020-06-24 | Scott | Iowa | 19163 | 488 | 10 |
269168 | 269168 | 2020-06-24 | Scott | Kansas | 20171 | 16 | 0 |
269290 | 269290 | 2020-06-24 | Scott | Kentucky | 21209 | 76 | 0 |
269577 | 269577 | 2020-06-24 | Scott | Minnesota | 27139 | 603 | 4 |
269657 | 269657 | 2020-06-24 | Scott | Mississippi | 28123 | 709 | 14 |
269772 | 269772 | 2020-06-24 | Scott | Missouri | 29201 | 159 | 11 |
270724 | 270724 | 2020-06-24 | Scott | Tennessee | 47151 | 14 | 0 |
271144 | 271144 | 2020-06-24 | Scott | Virginia | 51169 | 9 | 2 |
265255 | 265255 | 2020-06-23 | Scott | Arkansas | 5127 | 8 | 0 |
265840 | 265840 | 2020-06-23 | Scott | Indiana | 18143 | 153 | 7 |
265943 | 265943 | 2020-06-23 | Scott | Iowa | 19163 | 460 | 10 |
266036 | 266036 | 2020-06-23 | Scott | Kansas | 20171 | 16 | 0 |
266157 | 266157 | 2020-06-23 | Scott | Kentucky | 21209 | 75 | 0 |
266444 | 266444 | 2020-06-23 | Scott | Minnesota | 27139 | 595 | 4 |
266524 | 266524 | 2020-06-23 | Scott | Mississippi | 28123 | 707 | 14 |
266639 | 266639 | 2020-06-23 | Scott | Missouri | 29201 | 159 | 11 |
267590 | 267590 | 2020-06-23 | Scott | Tennessee | 47151 | 14 | 0 |
268010 | 268010 | 2020-06-23 | Scott | Virginia | 51169 | 9 | 2 |
262127 | 262127 | 2020-06-22 | Scott | Arkansas | 5127 | 8 | 0 |
262712 | 262712 | 2020-06-22 | Scott | Indiana | 18143 | 151 | 7 |
262815 | 262815 | 2020-06-22 | Scott | Iowa | 19163 | 451 | 10 |
262908 | 262908 | 2020-06-22 | Scott | Kansas | 20171 | 16 | 0 |
263030 | 263030 | 2020-06-22 | Scott | Kentucky | 21209 | 67 | 0 |
263318 | 263318 | 2020-06-22 | Scott | Minnesota | 27139 | 587 | 4 |
263398 | 263398 | 2020-06-22 | Scott | Mississippi | 28123 | 700 | 14 |
263513 | 263513 | 2020-06-22 | Scott | Missouri | 29201 | 160 | 11 |
264462 | 264462 | 2020-06-22 | Scott | Tennessee | 47151 | 14 | 0 |
264881 | 264881 | 2020-06-22 | Scott | Virginia | 51169 | 8 | 2 |
259000 | 259000 | 2020-06-21 | Scott | Arkansas | 5127 | 8 | 0 |
259585 | 259585 | 2020-06-21 | Scott | Indiana | 18143 | 151 | 7 |
259688 | 259688 | 2020-06-21 | Scott | Iowa | 19163 | 447 | 10 |
259781 | 259781 | 2020-06-21 | Scott | Kansas | 20171 | 16 | 0 |
259901 | 259901 | 2020-06-21 | Scott | Kentucky | 21209 | 67 | 0 |
260189 | 260189 | 2020-06-21 | Scott | Minnesota | 27139 | 570 | 4 |
260269 | 260269 | 2020-06-21 | Scott | Mississippi | 28123 | 696 | 12 |
260385 | 260385 | 2020-06-21 | Scott | Missouri | 29201 | 159 | 10 |
261334 | 261334 | 2020-06-21 | Scott | Tennessee | 47151 | 14 | 0 |
261752 | 261752 | 2020-06-21 | Scott | Virginia | 51169 | 8 | 2 |
255873 | 255873 | 2020-06-20 | Scott | Arkansas | 5127 | 8 | 0 |
256459 | 256459 | 2020-06-20 | Scott | Indiana | 18143 | 151 | 7 |
256562 | 256562 | 2020-06-20 | Scott | Iowa | 19163 | 435 | 10 |
256655 | 256655 | 2020-06-20 | Scott | Kansas | 20171 | 16 | 0 |
256775 | 256775 | 2020-06-20 | Scott | Kentucky | 21209 | 66 | 0 |
257063 | 257063 | 2020-06-20 | Scott | Minnesota | 27139 | 561 | 4 |
257143 | 257143 | 2020-06-20 | Scott | Mississippi | 28123 | 696 | 12 |
257259 | 257259 | 2020-06-20 | Scott | Missouri | 29201 | 157 | 10 |
258207 | 258207 | 2020-06-20 | Scott | Tennessee | 47151 | 14 | 0 |
258625 | 258625 | 2020-06-20 | Scott | Virginia | 51169 | 8 | 2 |
252754 | 252754 | 2020-06-19 | Scott | Arkansas | 5127 | 7 | 0 |
253339 | 253339 | 2020-06-19 | Scott | Indiana | 18143 | 149 | 7 |
253442 | 253442 | 2020-06-19 | Scott | Iowa | 19163 | 431 | 10 |
253535 | 253535 | 2020-06-19 | Scott | Kansas | 20171 | 16 | 0 |
253655 | 253655 | 2020-06-19 | Scott | Kentucky | 21209 | 60 | 0 |
253943 | 253943 | 2020-06-19 | Scott | Minnesota | 27139 | 555 | 4 |
254023 | 254023 | 2020-06-19 | Scott | Mississippi | 28123 | 696 | 12 |
254138 | 254138 | 2020-06-19 | Scott | Missouri | 29201 | 155 | 10 |
255081 | 255081 | 2020-06-19 | Scott | Tennessee | 47151 | 15 | 0 |
255498 | 255498 | 2020-06-19 | Scott | Virginia | 51169 | 8 | 2 |
249639 | 249639 | 2020-06-18 | Scott | Arkansas | 5127 | 6 | 0 |
250224 | 250224 | 2020-06-18 | Scott | Indiana | 18143 | 150 | 7 |
250327 | 250327 | 2020-06-18 | Scott | Iowa | 19163 | 421 | 10 |
250420 | 250420 | 2020-06-18 | Scott | Kansas | 20171 | 16 | 0 |
250540 | 250540 | 2020-06-18 | Scott | Kentucky | 21209 | 57 | 0 |
250828 | 250828 | 2020-06-18 | Scott | Minnesota | 27139 | 551 | 4 |
250908 | 250908 | 2020-06-18 | Scott | Mississippi | 28123 | 696 | 12 |
251023 | 251023 | 2020-06-18 | Scott | Missouri | 29201 | 149 | 10 |
251966 | 251966 | 2020-06-18 | Scott | Tennessee | 47151 | 15 | 0 |
252379 | 252379 | 2020-06-18 | Scott | Virginia | 51169 | 8 | 2 |
246527 | 246527 | 2020-06-17 | Scott | Arkansas | 5127 | 5 | 0 |
247112 | 247112 | 2020-06-17 | Scott | Indiana | 18143 | 147 | 5 |
247215 | 247215 | 2020-06-17 | Scott | Iowa | 19163 | 417 | 10 |
247308 | 247308 | 2020-06-17 | Scott | Kansas | 20171 | 16 | 0 |
247428 | 247428 | 2020-06-17 | Scott | Kentucky | 21209 | 54 | 0 |
247716 | 247716 | 2020-06-17 | Scott | Minnesota | 27139 | 546 | 4 |
247796 | 247796 | 2020-06-17 | Scott | Mississippi | 28123 | 696 | 12 |
247910 | 247910 | 2020-06-17 | Scott | Missouri | 29201 | 149 | 10 |
248851 | 248851 | 2020-06-17 | Scott | Tennessee | 47151 | 14 | 0 |
249264 | 249264 | 2020-06-17 | Scott | Virginia | 51169 | 8 | 2 |
243414 | 243414 | 2020-06-16 | Scott | Arkansas | 5127 | 5 | 0 |
243999 | 243999 | 2020-06-16 | Scott | Indiana | 18143 | 147 | 3 |
244102 | 244102 | 2020-06-16 | Scott | Iowa | 19163 | 409 | 10 |
244195 | 244195 | 2020-06-16 | Scott | Kansas | 20171 | 16 | 0 |
244315 | 244315 | 2020-06-16 | Scott | Kentucky | 21209 | 54 | 0 |
244603 | 244603 | 2020-06-16 | Scott | Minnesota | 27139 | 541 | 4 |
244683 | 244683 | 2020-06-16 | Scott | Mississippi | 28123 | 692 | 12 |
244797 | 244797 | 2020-06-16 | Scott | Missouri | 29201 | 145 | 10 |
245738 | 245738 | 2020-06-16 | Scott | Tennessee | 47151 | 14 | 0 |
246152 | 246152 | 2020-06-16 | Scott | Virginia | 51169 | 8 | 2 |
240303 | 240303 | 2020-06-15 | Scott | Arkansas | 5127 | 5 | 0 |
240888 | 240888 | 2020-06-15 | Scott | Indiana | 18143 | 145 | 3 |
240991 | 240991 | 2020-06-15 | Scott | Iowa | 19163 | 407 | 10 |
241084 | 241084 | 2020-06-15 | Scott | Kansas | 20171 | 16 | 0 |
241204 | 241204 | 2020-06-15 | Scott | Kentucky | 21209 | 54 | 0 |
241492 | 241492 | 2020-06-15 | Scott | Minnesota | 27139 | 536 | 4 |
241572 | 241572 | 2020-06-15 | Scott | Mississippi | 28123 | 690 | 12 |
241686 | 241686 | 2020-06-15 | Scott | Missouri | 29201 | 145 | 10 |
242626 | 242626 | 2020-06-15 | Scott | Tennessee | 47151 | 14 | 0 |
243039 | 243039 | 2020-06-15 | Scott | Virginia | 51169 | 8 | 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);