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 |
---|---|---|---|---|---|---|---|
386111 | 386111 | 2020-07-31 | Scott | Arkansas | 5127 | 41 | 0 |
386619 | 386619 | 2020-07-31 | Scott | Illinois | 17171 | 9 | 0 |
386708 | 386708 | 2020-07-31 | Scott | Indiana | 18143 | 247 | 11 |
386811 | 386811 | 2020-07-31 | Scott | Iowa | 19163 | 1557 | 12 |
386914 | 386914 | 2020-07-31 | Scott | Kansas | 20171 | 28 | 0 |
387037 | 387037 | 2020-07-31 | Scott | Kentucky | 21209 | 311 | 0 |
387327 | 387327 | 2020-07-31 | Scott | Minnesota | 27139 | 1296 | 12 |
387408 | 387408 | 2020-07-31 | Scott | Mississippi | 28123 | 947 | 17 |
387525 | 387525 | 2020-07-31 | Scott | Missouri | 29201 | 342 | 13 |
388515 | 388515 | 2020-07-31 | Scott | Tennessee | 47151 | 91 | 0 |
388945 | 388945 | 2020-07-31 | Scott | Virginia | 51169 | 51 | 3 |
382893 | 382893 | 2020-07-30 | Scott | Arkansas | 5127 | 35 | 0 |
383401 | 383401 | 2020-07-30 | Scott | Illinois | 17171 | 7 | 0 |
383490 | 383490 | 2020-07-30 | Scott | Indiana | 18143 | 240 | 11 |
383593 | 383593 | 2020-07-30 | Scott | Iowa | 19163 | 1542 | 11 |
383696 | 383696 | 2020-07-30 | Scott | Kansas | 20171 | 26 | 0 |
383819 | 383819 | 2020-07-30 | Scott | Kentucky | 21209 | 298 | 0 |
384109 | 384109 | 2020-07-30 | Scott | Minnesota | 27139 | 1272 | 11 |
384190 | 384190 | 2020-07-30 | Scott | Mississippi | 28123 | 944 | 17 |
384307 | 384307 | 2020-07-30 | Scott | Missouri | 29201 | 330 | 13 |
385298 | 385298 | 2020-07-30 | Scott | Tennessee | 47151 | 80 | 0 |
385728 | 385728 | 2020-07-30 | Scott | Virginia | 51169 | 47 | 3 |
379676 | 379676 | 2020-07-29 | Scott | Arkansas | 5127 | 34 | 0 |
380184 | 380184 | 2020-07-29 | Scott | Illinois | 17171 | 6 | 0 |
380273 | 380273 | 2020-07-29 | Scott | Indiana | 18143 | 237 | 11 |
380376 | 380376 | 2020-07-29 | Scott | Iowa | 19163 | 1525 | 11 |
380479 | 380479 | 2020-07-29 | Scott | Kansas | 20171 | 26 | 0 |
380602 | 380602 | 2020-07-29 | Scott | Kentucky | 21209 | 286 | 0 |
380892 | 380892 | 2020-07-29 | Scott | Minnesota | 27139 | 1249 | 11 |
380973 | 380973 | 2020-07-29 | Scott | Mississippi | 28123 | 941 | 17 |
381091 | 381091 | 2020-07-29 | Scott | Missouri | 29201 | 313 | 13 |
382080 | 382080 | 2020-07-29 | Scott | Tennessee | 47151 | 68 | 0 |
382510 | 382510 | 2020-07-29 | Scott | Virginia | 51169 | 45 | 3 |
376460 | 376460 | 2020-07-28 | Scott | Arkansas | 5127 | 33 | 0 |
376967 | 376967 | 2020-07-28 | Scott | Illinois | 17171 | 6 | 0 |
377056 | 377056 | 2020-07-28 | Scott | Indiana | 18143 | 232 | 11 |
377159 | 377159 | 2020-07-28 | Scott | Iowa | 19163 | 1500 | 11 |
377262 | 377262 | 2020-07-28 | Scott | Kansas | 20171 | 26 | 0 |
377385 | 377385 | 2020-07-28 | Scott | Kentucky | 21209 | 268 | 0 |
377675 | 377675 | 2020-07-28 | Scott | Minnesota | 27139 | 1217 | 11 |
377756 | 377756 | 2020-07-28 | Scott | Mississippi | 28123 | 936 | 17 |
377874 | 377874 | 2020-07-28 | Scott | Missouri | 29201 | 311 | 13 |
378863 | 378863 | 2020-07-28 | Scott | Tennessee | 47151 | 67 | 0 |
379293 | 379293 | 2020-07-28 | Scott | Virginia | 51169 | 41 | 3 |
373246 | 373246 | 2020-07-27 | Scott | Arkansas | 5127 | 31 | 0 |
373752 | 373752 | 2020-07-27 | Scott | Illinois | 17171 | 6 | 0 |
373841 | 373841 | 2020-07-27 | Scott | Indiana | 18143 | 227 | 11 |
373944 | 373944 | 2020-07-27 | Scott | Iowa | 19163 | 1491 | 11 |
374047 | 374047 | 2020-07-27 | Scott | Kansas | 20171 | 25 | 0 |
374170 | 374170 | 2020-07-27 | Scott | Kentucky | 21209 | 262 | 0 |
374460 | 374460 | 2020-07-27 | Scott | Minnesota | 27139 | 1198 | 11 |
374541 | 374541 | 2020-07-27 | Scott | Mississippi | 28123 | 932 | 16 |
374659 | 374659 | 2020-07-27 | Scott | Missouri | 29201 | 294 | 13 |
375647 | 375647 | 2020-07-27 | Scott | Tennessee | 47151 | 57 | 0 |
376077 | 376077 | 2020-07-27 | Scott | Virginia | 51169 | 40 | 3 |
370034 | 370034 | 2020-07-26 | Scott | Arkansas | 5127 | 31 | 0 |
370540 | 370540 | 2020-07-26 | Scott | Illinois | 17171 | 6 | 0 |
370629 | 370629 | 2020-07-26 | Scott | Indiana | 18143 | 227 | 11 |
370732 | 370732 | 2020-07-26 | Scott | Iowa | 19163 | 1483 | 11 |
370835 | 370835 | 2020-07-26 | Scott | Kansas | 20171 | 24 | 0 |
370958 | 370958 | 2020-07-26 | Scott | Kentucky | 21209 | 261 | 0 |
371248 | 371248 | 2020-07-26 | Scott | Minnesota | 27139 | 1176 | 11 |
371329 | 371329 | 2020-07-26 | Scott | Mississippi | 28123 | 930 | 16 |
371447 | 371447 | 2020-07-26 | Scott | Missouri | 29201 | 285 | 13 |
372434 | 372434 | 2020-07-26 | Scott | Tennessee | 47151 | 50 | 0 |
372863 | 372863 | 2020-07-26 | Scott | Virginia | 51169 | 37 | 3 |
366824 | 366824 | 2020-07-25 | Scott | Arkansas | 5127 | 30 | 0 |
367330 | 367330 | 2020-07-25 | Scott | Illinois | 17171 | 6 | 0 |
367419 | 367419 | 2020-07-25 | Scott | Indiana | 18143 | 222 | 11 |
367522 | 367522 | 2020-07-25 | Scott | Iowa | 19163 | 1458 | 11 |
367625 | 367625 | 2020-07-25 | Scott | Kansas | 20171 | 22 | 0 |
367748 | 367748 | 2020-07-25 | Scott | Kentucky | 21209 | 250 | 0 |
368038 | 368038 | 2020-07-25 | Scott | Minnesota | 27139 | 1144 | 11 |
368119 | 368119 | 2020-07-25 | Scott | Mississippi | 28123 | 926 | 16 |
368236 | 368236 | 2020-07-25 | Scott | Missouri | 29201 | 286 | 13 |
369222 | 369222 | 2020-07-25 | Scott | Tennessee | 47151 | 46 | 0 |
369651 | 369651 | 2020-07-25 | Scott | Virginia | 51169 | 34 | 3 |
363617 | 363617 | 2020-07-24 | Scott | Arkansas | 5127 | 26 | 0 |
364123 | 364123 | 2020-07-24 | Scott | Illinois | 17171 | 5 | 0 |
364212 | 364212 | 2020-07-24 | Scott | Indiana | 18143 | 219 | 11 |
364315 | 364315 | 2020-07-24 | Scott | Iowa | 19163 | 1434 | 11 |
364418 | 364418 | 2020-07-24 | Scott | Kansas | 20171 | 22 | 0 |
364541 | 364541 | 2020-07-24 | Scott | Kentucky | 21209 | 220 | 0 |
364830 | 364830 | 2020-07-24 | Scott | Minnesota | 27139 | 1119 | 10 |
364911 | 364911 | 2020-07-24 | Scott | Mississippi | 28123 | 919 | 16 |
365028 | 365028 | 2020-07-24 | Scott | Missouri | 29201 | 282 | 13 |
366013 | 366013 | 2020-07-24 | Scott | Tennessee | 47151 | 43 | 0 |
366442 | 366442 | 2020-07-24 | Scott | Virginia | 51169 | 33 | 3 |
360410 | 360410 | 2020-07-23 | Scott | Arkansas | 5127 | 26 | 0 |
360916 | 360916 | 2020-07-23 | Scott | Illinois | 17171 | 6 | 0 |
361005 | 361005 | 2020-07-23 | Scott | Indiana | 18143 | 211 | 11 |
361108 | 361108 | 2020-07-23 | Scott | Iowa | 19163 | 1398 | 11 |
361211 | 361211 | 2020-07-23 | Scott | Kansas | 20171 | 21 | 0 |
361334 | 361334 | 2020-07-23 | Scott | Kentucky | 21209 | 205 | 0 |
361623 | 361623 | 2020-07-23 | Scott | Minnesota | 27139 | 1094 | 9 |
361704 | 361704 | 2020-07-23 | Scott | Mississippi | 28123 | 917 | 16 |
361821 | 361821 | 2020-07-23 | Scott | Missouri | 29201 | 272 | 13 |
362807 | 362807 | 2020-07-23 | Scott | Tennessee | 47151 | 39 | 0 |
363236 | 363236 | 2020-07-23 | Scott | Virginia | 51169 | 30 | 2 |
357205 | 357205 | 2020-07-22 | Scott | Arkansas | 5127 | 21 | 0 |
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);