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 |
---|---|---|---|---|---|---|---|
357711 | 357711 | 2020-07-22 | Scott | Illinois | 17171 | 4 | 0 |
357800 | 357800 | 2020-07-22 | Scott | Indiana | 18143 | 206 | 11 |
357903 | 357903 | 2020-07-22 | Scott | Iowa | 19163 | 1365 | 11 |
358006 | 358006 | 2020-07-22 | Scott | Kansas | 20171 | 21 | 0 |
358129 | 358129 | 2020-07-22 | Scott | Kentucky | 21209 | 193 | 0 |
358418 | 358418 | 2020-07-22 | Scott | Minnesota | 27139 | 1072 | 8 |
358499 | 358499 | 2020-07-22 | Scott | Mississippi | 28123 | 911 | 16 |
358616 | 358616 | 2020-07-22 | Scott | Missouri | 29201 | 266 | 13 |
359600 | 359600 | 2020-07-22 | Scott | Tennessee | 47151 | 39 | 0 |
360030 | 360030 | 2020-07-22 | Scott | Virginia | 51169 | 30 | 2 |
354002 | 354002 | 2020-07-21 | Scott | Arkansas | 5127 | 21 | 0 |
354509 | 354509 | 2020-07-21 | Scott | Illinois | 17171 | 2 | 0 |
354598 | 354598 | 2020-07-21 | Scott | Indiana | 18143 | 204 | 10 |
354701 | 354701 | 2020-07-21 | Scott | Iowa | 19163 | 1335 | 11 |
354804 | 354804 | 2020-07-21 | Scott | Kansas | 20171 | 20 | 0 |
354926 | 354926 | 2020-07-21 | Scott | Kentucky | 21209 | 174 | 0 |
355215 | 355215 | 2020-07-21 | Scott | Minnesota | 27139 | 1046 | 8 |
355296 | 355296 | 2020-07-21 | Scott | Mississippi | 28123 | 901 | 16 |
355413 | 355413 | 2020-07-21 | Scott | Missouri | 29201 | 250 | 13 |
356396 | 356396 | 2020-07-21 | Scott | Tennessee | 47151 | 38 | 0 |
356825 | 356825 | 2020-07-21 | Scott | Virginia | 51169 | 30 | 2 |
350800 | 350800 | 2020-07-20 | Scott | Arkansas | 5127 | 21 | 0 |
351307 | 351307 | 2020-07-20 | Scott | Illinois | 17171 | 1 | 0 |
351396 | 351396 | 2020-07-20 | Scott | Indiana | 18143 | 202 | 10 |
351499 | 351499 | 2020-07-20 | Scott | Iowa | 19163 | 1318 | 11 |
351602 | 351602 | 2020-07-20 | Scott | Kansas | 20171 | 20 | 0 |
351724 | 351724 | 2020-07-20 | Scott | Kentucky | 21209 | 169 | 0 |
352013 | 352013 | 2020-07-20 | Scott | Minnesota | 27139 | 1022 | 8 |
352094 | 352094 | 2020-07-20 | Scott | Mississippi | 28123 | 886 | 16 |
352211 | 352211 | 2020-07-20 | Scott | Missouri | 29201 | 244 | 13 |
353193 | 353193 | 2020-07-20 | Scott | Tennessee | 47151 | 36 | 0 |
353622 | 353622 | 2020-07-20 | Scott | Virginia | 51169 | 25 | 2 |
347599 | 347599 | 2020-07-19 | Scott | Arkansas | 5127 | 20 | 0 |
348107 | 348107 | 2020-07-19 | Scott | Illinois | 17171 | 1 | 0 |
348196 | 348196 | 2020-07-19 | Scott | Indiana | 18143 | 197 | 10 |
348299 | 348299 | 2020-07-19 | Scott | Iowa | 19163 | 1290 | 10 |
348402 | 348402 | 2020-07-19 | Scott | Kansas | 20171 | 19 | 0 |
348524 | 348524 | 2020-07-19 | Scott | Kentucky | 21209 | 168 | 0 |
348813 | 348813 | 2020-07-19 | Scott | Minnesota | 27139 | 1010 | 7 |
348894 | 348894 | 2020-07-19 | Scott | Mississippi | 28123 | 873 | 16 |
349011 | 349011 | 2020-07-19 | Scott | Missouri | 29201 | 244 | 13 |
349990 | 349990 | 2020-07-19 | Scott | Tennessee | 47151 | 35 | 0 |
350420 | 350420 | 2020-07-19 | Scott | Virginia | 51169 | 25 | 2 |
344399 | 344399 | 2020-07-18 | Scott | Arkansas | 5127 | 19 | 0 |
344906 | 344906 | 2020-07-18 | Scott | Illinois | 17171 | 1 | 0 |
344995 | 344995 | 2020-07-18 | Scott | Indiana | 18143 | 187 | 10 |
345098 | 345098 | 2020-07-18 | Scott | Iowa | 19163 | 1277 | 10 |
345201 | 345201 | 2020-07-18 | Scott | Kansas | 20171 | 19 | 0 |
345323 | 345323 | 2020-07-18 | Scott | Kentucky | 21209 | 153 | 0 |
345612 | 345612 | 2020-07-18 | Scott | Minnesota | 27139 | 986 | 7 |
345693 | 345693 | 2020-07-18 | Scott | Mississippi | 28123 | 872 | 16 |
345810 | 345810 | 2020-07-18 | Scott | Missouri | 29201 | 242 | 13 |
346790 | 346790 | 2020-07-18 | Scott | Tennessee | 47151 | 34 | 0 |
347219 | 347219 | 2020-07-18 | Scott | Virginia | 51169 | 25 | 2 |
341200 | 341200 | 2020-07-17 | Scott | Arkansas | 5127 | 18 | 0 |
341706 | 341706 | 2020-07-17 | Scott | Illinois | 17171 | 1 | 0 |
341795 | 341795 | 2020-07-17 | Scott | Indiana | 18143 | 185 | 10 |
341898 | 341898 | 2020-07-17 | Scott | Iowa | 19163 | 1254 | 10 |
342001 | 342001 | 2020-07-17 | Scott | Kansas | 20171 | 19 | 0 |
342123 | 342123 | 2020-07-17 | Scott | Kentucky | 21209 | 136 | 0 |
342412 | 342412 | 2020-07-17 | Scott | Minnesota | 27139 | 977 | 7 |
342493 | 342493 | 2020-07-17 | Scott | Mississippi | 28123 | 848 | 16 |
342610 | 342610 | 2020-07-17 | Scott | Missouri | 29201 | 240 | 13 |
343590 | 343590 | 2020-07-17 | Scott | Tennessee | 47151 | 33 | 0 |
344019 | 344019 | 2020-07-17 | Scott | Virginia | 51169 | 20 | 2 |
338004 | 338004 | 2020-07-16 | Scott | Arkansas | 5127 | 18 | 0 |
338510 | 338510 | 2020-07-16 | Scott | Illinois | 17171 | 1 | 0 |
338599 | 338599 | 2020-07-16 | Scott | Indiana | 18143 | 178 | 10 |
338702 | 338702 | 2020-07-16 | Scott | Iowa | 19163 | 1226 | 10 |
338805 | 338805 | 2020-07-16 | Scott | Kansas | 20171 | 19 | 0 |
338927 | 338927 | 2020-07-16 | Scott | Kentucky | 21209 | 137 | 0 |
339216 | 339216 | 2020-07-16 | Scott | Minnesota | 27139 | 965 | 7 |
339297 | 339297 | 2020-07-16 | Scott | Mississippi | 28123 | 847 | 15 |
339414 | 339414 | 2020-07-16 | Scott | Missouri | 29201 | 237 | 13 |
340392 | 340392 | 2020-07-16 | Scott | Tennessee | 47151 | 32 | 0 |
340820 | 340820 | 2020-07-16 | Scott | Virginia | 51169 | 20 | 2 |
334809 | 334809 | 2020-07-15 | Scott | Arkansas | 5127 | 18 | 0 |
335314 | 335314 | 2020-07-15 | Scott | Illinois | 17171 | 1 | 0 |
335403 | 335403 | 2020-07-15 | Scott | Indiana | 18143 | 171 | 10 |
335506 | 335506 | 2020-07-15 | Scott | Iowa | 19163 | 1174 | 10 |
335609 | 335609 | 2020-07-15 | Scott | Kansas | 20171 | 19 | 0 |
335731 | 335731 | 2020-07-15 | Scott | Kentucky | 21209 | 133 | 0 |
336020 | 336020 | 2020-07-15 | Scott | Minnesota | 27139 | 953 | 4 |
336101 | 336101 | 2020-07-15 | Scott | Mississippi | 28123 | 843 | 15 |
336218 | 336218 | 2020-07-15 | Scott | Missouri | 29201 | 235 | 13 |
337195 | 337195 | 2020-07-15 | Scott | Tennessee | 47151 | 31 | 0 |
337624 | 337624 | 2020-07-15 | Scott | Virginia | 51169 | 17 | 2 |
331616 | 331616 | 2020-07-14 | Scott | Arkansas | 5127 | 17 | 0 |
332121 | 332121 | 2020-07-14 | Scott | Illinois | 17171 | 1 | 0 |
332210 | 332210 | 2020-07-14 | Scott | Indiana | 18143 | 170 | 10 |
332313 | 332313 | 2020-07-14 | Scott | Iowa | 19163 | 1126 | 10 |
332416 | 332416 | 2020-07-14 | Scott | Kansas | 20171 | 19 | 0 |
332538 | 332538 | 2020-07-14 | Scott | Kentucky | 21209 | 131 | 0 |
332827 | 332827 | 2020-07-14 | Scott | Minnesota | 27139 | 923 | 4 |
332908 | 332908 | 2020-07-14 | Scott | Mississippi | 28123 | 837 | 15 |
333025 | 333025 | 2020-07-14 | Scott | Missouri | 29201 | 219 | 12 |
334001 | 334001 | 2020-07-14 | Scott | Tennessee | 47151 | 30 | 0 |
334429 | 334429 | 2020-07-14 | Scott | Virginia | 51169 | 16 | 2 |
328430 | 328430 | 2020-07-13 | Scott | Arkansas | 5127 | 17 | 0 |
328934 | 328934 | 2020-07-13 | Scott | Illinois | 17171 | 1 | 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);