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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280955 | 280955 | 2020-06-28 | Scott | Arkansas | 5127 | 10 | 0 |
281545 | 281545 | 2020-06-28 | Scott | Indiana | 18143 | 157 | 7 |
281648 | 281648 | 2020-06-28 | Scott | Iowa | 19163 | 598 | 10 |
281744 | 281744 | 2020-06-28 | Scott | Kansas | 20171 | 16 | 0 |
281865 | 281865 | 2020-06-28 | Scott | Kentucky | 21209 | 82 | 0 |
282153 | 282153 | 2020-06-28 | Scott | Minnesota | 27139 | 637 | 4 |
282234 | 282234 | 2020-06-28 | Scott | Mississippi | 28123 | 726 | 14 |
282350 | 282350 | 2020-06-28 | Scott | Missouri | 29201 | 162 | 11 |
283304 | 283304 | 2020-06-28 | Scott | Tennessee | 47151 | 14 | 0 |
283726 | 283726 | 2020-06-28 | Scott | Virginia | 51169 | 10 | 2 |
277808 | 277808 | 2020-06-27 | Scott | Arkansas | 5127 | 10 | 0 |
278397 | 278397 | 2020-06-27 | Scott | Indiana | 18143 | 157 | 7 |
278500 | 278500 | 2020-06-27 | Scott | Iowa | 19163 | 580 | 10 |
278596 | 278596 | 2020-06-27 | Scott | Kansas | 20171 | 16 | 0 |
278717 | 278717 | 2020-06-27 | Scott | Kentucky | 21209 | 82 | 0 |
279005 | 279005 | 2020-06-27 | Scott | Minnesota | 27139 | 627 | 4 |
279086 | 279086 | 2020-06-27 | Scott | Mississippi | 28123 | 725 | 14 |
279202 | 279202 | 2020-06-27 | Scott | Missouri | 29201 | 161 | 11 |
280158 | 280158 | 2020-06-27 | Scott | Tennessee | 47151 | 14 | 0 |
280580 | 280580 | 2020-06-27 | Scott | Virginia | 51169 | 9 | 2 |
274660 | 274660 | 2020-06-26 | Scott | Arkansas | 5127 | 9 | 0 |
275249 | 275249 | 2020-06-26 | Scott | Indiana | 18143 | 156 | 7 |
275352 | 275352 | 2020-06-26 | Scott | Iowa | 19163 | 561 | 10 |
275448 | 275448 | 2020-06-26 | Scott | Kansas | 20171 | 16 | 0 |
275569 | 275569 | 2020-06-26 | Scott | Kentucky | 21209 | 83 | 0 |
275857 | 275857 | 2020-06-26 | Scott | Minnesota | 27139 | 616 | 4 |
275938 | 275938 | 2020-06-26 | Scott | Mississippi | 28123 | 723 | 14 |
276054 | 276054 | 2020-06-26 | Scott | Missouri | 29201 | 161 | 11 |
277010 | 277010 | 2020-06-26 | Scott | Tennessee | 47151 | 14 | 0 |
277432 | 277432 | 2020-06-26 | Scott | Virginia | 51169 | 9 | 2 |
271520 | 271520 | 2020-06-25 | Scott | Arkansas | 5127 | 8 | 0 |
272107 | 272107 | 2020-06-25 | Scott | Indiana | 18143 | 157 | 7 |
272210 | 272210 | 2020-06-25 | Scott | Iowa | 19163 | 516 | 10 |
272305 | 272305 | 2020-06-25 | Scott | Kansas | 20171 | 16 | 0 |
272426 | 272426 | 2020-06-25 | Scott | Kentucky | 21209 | 79 | 0 |
272714 | 272714 | 2020-06-25 | Scott | Minnesota | 27139 | 609 | 4 |
272795 | 272795 | 2020-06-25 | Scott | Mississippi | 28123 | 721 | 14 |
272911 | 272911 | 2020-06-25 | Scott | Missouri | 29201 | 159 | 11 |
273863 | 273863 | 2020-06-25 | Scott | Tennessee | 47151 | 14 | 0 |
274284 | 274284 | 2020-06-25 | Scott | Virginia | 51169 | 9 | 2 |
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 |
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);