ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marshall" and fips = 21157 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
313425 | 313425 | 2020-07-08 | Marshall | Kentucky | 21157 | 66 | 2 |
316599 | 316599 | 2020-07-09 | Marshall | Kentucky | 21157 | 66 | 2 |
319774 | 319774 | 2020-07-10 | Marshall | Kentucky | 21157 | 68 | 2 |
322953 | 322953 | 2020-07-11 | Marshall | Kentucky | 21157 | 69 | 2 |
326136 | 326136 | 2020-07-12 | Marshall | Kentucky | 21157 | 70 | 2 |
329322 | 329322 | 2020-07-13 | Marshall | Kentucky | 21157 | 72 | 2 |
332509 | 332509 | 2020-07-14 | Marshall | Kentucky | 21157 | 74 | 2 |
335702 | 335702 | 2020-07-15 | Marshall | Kentucky | 21157 | 81 | 2 |
338898 | 338898 | 2020-07-16 | Marshall | Kentucky | 21157 | 82 | 2 |
342094 | 342094 | 2020-07-17 | Marshall | Kentucky | 21157 | 87 | 2 |
345294 | 345294 | 2020-07-18 | Marshall | Kentucky | 21157 | 88 | 2 |
348495 | 348495 | 2020-07-19 | Marshall | Kentucky | 21157 | 92 | 2 |
351695 | 351695 | 2020-07-20 | Marshall | Kentucky | 21157 | 92 | 2 |
354897 | 354897 | 2020-07-21 | Marshall | Kentucky | 21157 | 94 | 2 |
358100 | 358100 | 2020-07-22 | Marshall | Kentucky | 21157 | 98 | 2 |
361305 | 361305 | 2020-07-23 | Marshall | Kentucky | 21157 | 100 | 2 |
364512 | 364512 | 2020-07-24 | Marshall | Kentucky | 21157 | 103 | 2 |
367719 | 367719 | 2020-07-25 | Marshall | Kentucky | 21157 | 110 | 2 |
370929 | 370929 | 2020-07-26 | Marshall | Kentucky | 21157 | 112 | 2 |
374141 | 374141 | 2020-07-27 | Marshall | Kentucky | 21157 | 112 | 2 |
377356 | 377356 | 2020-07-28 | Marshall | Kentucky | 21157 | 112 | 2 |
380573 | 380573 | 2020-07-29 | Marshall | Kentucky | 21157 | 113 | 2 |
383790 | 383790 | 2020-07-30 | Marshall | Kentucky | 21157 | 115 | 2 |
387008 | 387008 | 2020-07-31 | Marshall | Kentucky | 21157 | 120 | 2 |
390225 | 390225 | 2020-08-01 | Marshall | Kentucky | 21157 | 124 | 2 |
393442 | 393442 | 2020-08-02 | Marshall | Kentucky | 21157 | 124 | 2 |
396658 | 396658 | 2020-08-03 | Marshall | Kentucky | 21157 | 125 | 2 |
399873 | 399873 | 2020-08-04 | Marshall | Kentucky | 21157 | 128 | 2 |
403090 | 403090 | 2020-08-05 | Marshall | Kentucky | 21157 | 128 | 2 |
406308 | 406308 | 2020-08-06 | Marshall | Kentucky | 21157 | 131 | 2 |
409528 | 409528 | 2020-08-07 | Marshall | Kentucky | 21157 | 137 | 2 |
412748 | 412748 | 2020-08-08 | Marshall | Kentucky | 21157 | 137 | 2 |
415968 | 415968 | 2020-08-09 | Marshall | Kentucky | 21157 | 137 | 2 |
419189 | 419189 | 2020-08-10 | Marshall | Kentucky | 21157 | 138 | 2 |
422411 | 422411 | 2020-08-11 | Marshall | Kentucky | 21157 | 139 | 2 |
425632 | 425632 | 2020-08-12 | Marshall | Kentucky | 21157 | 140 | 2 |
428856 | 428856 | 2020-08-13 | Marshall | Kentucky | 21157 | 142 | 2 |
432084 | 432084 | 2020-08-14 | Marshall | Kentucky | 21157 | 147 | 2 |
435309 | 435309 | 2020-08-15 | Marshall | Kentucky | 21157 | 155 | 2 |
438534 | 438534 | 2020-08-16 | Marshall | Kentucky | 21157 | 155 | 2 |
441761 | 441761 | 2020-08-17 | Marshall | Kentucky | 21157 | 155 | 2 |
444987 | 444987 | 2020-08-18 | Marshall | Kentucky | 21157 | 157 | 2 |
448214 | 448214 | 2020-08-19 | Marshall | Kentucky | 21157 | 165 | 2 |
451442 | 451442 | 2020-08-20 | Marshall | Kentucky | 21157 | 169 | 2 |
454670 | 454670 | 2020-08-21 | Marshall | Kentucky | 21157 | 173 | 2 |
457898 | 457898 | 2020-08-22 | Marshall | Kentucky | 21157 | 174 | 2 |
461125 | 461125 | 2020-08-23 | Marshall | Kentucky | 21157 | 174 | 2 |
464356 | 464356 | 2020-08-24 | Marshall | Kentucky | 21157 | 177 | 2 |
467585 | 467585 | 2020-08-25 | Marshall | Kentucky | 21157 | 183 | 2 |
470814 | 470814 | 2020-08-26 | Marshall | Kentucky | 21157 | 183 | 2 |
474046 | 474046 | 2020-08-27 | Marshall | Kentucky | 21157 | 183 | 2 |
477279 | 477279 | 2020-08-28 | Marshall | Kentucky | 21157 | 185 | 2 |
480512 | 480512 | 2020-08-29 | Marshall | Kentucky | 21157 | 186 | 2 |
483746 | 483746 | 2020-08-30 | Marshall | Kentucky | 21157 | 187 | 2 |
486981 | 486981 | 2020-08-31 | Marshall | Kentucky | 21157 | 188 | 2 |
490214 | 490214 | 2020-09-01 | Marshall | Kentucky | 21157 | 193 | 2 |
493448 | 493448 | 2020-09-02 | Marshall | Kentucky | 21157 | 199 | 2 |
496681 | 496681 | 2020-09-03 | Marshall | Kentucky | 21157 | 200 | 2 |
499915 | 499915 | 2020-09-04 | Marshall | Kentucky | 21157 | 202 | 2 |
503148 | 503148 | 2020-09-05 | Marshall | Kentucky | 21157 | 204 | 2 |
506382 | 506382 | 2020-09-06 | Marshall | Kentucky | 21157 | 206 | 2 |
509615 | 509615 | 2020-09-07 | Marshall | Kentucky | 21157 | 208 | 2 |
512847 | 512847 | 2020-09-08 | Marshall | Kentucky | 21157 | 220 | 2 |
516080 | 516080 | 2020-09-09 | Marshall | Kentucky | 21157 | 222 | 2 |
519315 | 519315 | 2020-09-10 | Marshall | Kentucky | 21157 | 225 | 2 |
525788 | 525788 | 2020-09-12 | Marshall | Kentucky | 21157 | 235 | 2 |
522552 | 522552 | 2020-09-11 | Marshall | Kentucky | 21157 | 236 | 2 |
529024 | 529024 | 2020-09-13 | Marshall | Kentucky | 21157 | 236 | 2 |
532261 | 532261 | 2020-09-14 | Marshall | Kentucky | 21157 | 237 | 2 |
535496 | 535496 | 2020-09-15 | Marshall | Kentucky | 21157 | 239 | 2 |
538733 | 538733 | 2020-09-16 | Marshall | Kentucky | 21157 | 244 | 2 |
541969 | 541969 | 2020-09-17 | Marshall | Kentucky | 21157 | 251 | 2 |
545205 | 545205 | 2020-09-18 | Marshall | Kentucky | 21157 | 257 | 2 |
548443 | 548443 | 2020-09-19 | Marshall | Kentucky | 21157 | 260 | 2 |
551682 | 551682 | 2020-09-20 | Marshall | Kentucky | 21157 | 271 | 2 |
554921 | 554921 | 2020-09-21 | Marshall | Kentucky | 21157 | 276 | 2 |
558158 | 558158 | 2020-09-22 | Marshall | Kentucky | 21157 | 280 | 2 |
561394 | 561394 | 2020-09-23 | Marshall | Kentucky | 21157 | 285 | 3 |
564634 | 564634 | 2020-09-24 | Marshall | Kentucky | 21157 | 290 | 3 |
567874 | 567874 | 2020-09-25 | Marshall | Kentucky | 21157 | 297 | 4 |
571116 | 571116 | 2020-09-26 | Marshall | Kentucky | 21157 | 299 | 4 |
574359 | 574359 | 2020-09-27 | Marshall | Kentucky | 21157 | 302 | 4 |
577601 | 577601 | 2020-09-28 | Marshall | Kentucky | 21157 | 307 | 4 |
580842 | 580842 | 2020-09-29 | Marshall | Kentucky | 21157 | 314 | 4 |
584082 | 584082 | 2020-09-30 | Marshall | Kentucky | 21157 | 317 | 4 |
587322 | 587322 | 2020-10-01 | Marshall | Kentucky | 21157 | 324 | 4 |
590563 | 590563 | 2020-10-02 | Marshall | Kentucky | 21157 | 331 | 4 |
593804 | 593804 | 2020-10-03 | Marshall | Kentucky | 21157 | 337 | 4 |
597046 | 597046 | 2020-10-04 | Marshall | Kentucky | 21157 | 341 | 4 |
600288 | 600288 | 2020-10-05 | Marshall | Kentucky | 21157 | 343 | 4 |
603531 | 603531 | 2020-10-06 | Marshall | Kentucky | 21157 | 349 | 4 |
606773 | 606773 | 2020-10-07 | Marshall | Kentucky | 21157 | 353 | 4 |
610015 | 610015 | 2020-10-08 | Marshall | Kentucky | 21157 | 361 | 4 |
613257 | 613257 | 2020-10-09 | Marshall | Kentucky | 21157 | 364 | 4 |
616498 | 616498 | 2020-10-10 | Marshall | Kentucky | 21157 | 368 | 4 |
619740 | 619740 | 2020-10-11 | Marshall | Kentucky | 21157 | 372 | 4 |
622984 | 622984 | 2020-10-12 | Marshall | Kentucky | 21157 | 374 | 4 |
626226 | 626226 | 2020-10-13 | Marshall | Kentucky | 21157 | 381 | 4 |
629470 | 629470 | 2020-10-14 | Marshall | Kentucky | 21157 | 393 | 4 |
632714 | 632714 | 2020-10-15 | Marshall | Kentucky | 21157 | 405 | 4 |
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);